maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_rw_shipperconf_addunit(integer, integer, integer)
Parameters
Name
Type
Mode
in_idclientowner
integer
IN
in_idclientshipper
integer
IN
in_idunit
integer
IN
Definition
DECLARE _idshipperconf INTEGER; _idunitgroup INTEGER; r record; BEGIN SELECT idshipperconf INTO _idshipperconf FROM shipperconf WHERE idclientowner = in_idclientowner AND idclientshipper = in_idclientshipper; SELECT idunitgoup INTO _idunitgroup FROM shipperconf_unitgroup WHERE idshipperconf = _idshipperconf; INSERT INTO unit_unitgroup (idunit,idunitgroup,createbyuser,creationdate,lastmodifiedbyuser,lastmodificationdate,originatingsystem,enabled) VALUES(in_idunit,_idunitgroup,0,now(),0,now(),'DBA',true) RETURNING * INTO r; RETURN r; END;