122: insert into iby_instrholder ( ownertype, ownerid, owneraddressid,instrtype, instrid, activestatus,
123: last_update_date, last_updated_by, creation_date,
124: created_by,object_version_number)
125: values ( i_hld_type, i_hld_id,i_hld_address_id,i_instr_type, i_instr_id, 1,
126: sysdate, fnd_global.user_id, sysdate,
127: fnd_global.user_id, 1);
128: --commit;
129: end createHolderinstr;
130:
123: last_update_date, last_updated_by, creation_date,
124: created_by,object_version_number)
125: values ( i_hld_type, i_hld_id,i_hld_address_id,i_instr_type, i_instr_id, 1,
126: sysdate, fnd_global.user_id, sysdate,
127: fnd_global.user_id, 1);
128: --commit;
129: end createHolderinstr;
130:
131:
189: if (i_instrtype is null) then
190: update iby_instrholder
191: set activestatus = 0,
192: last_update_date = sysdate,
193: last_updated_by = fnd_global.user_id,
194: last_update_login = fnd_global.login_id
195: where ownertype = i_ownertype
196: and ownerid = i_ownerid
197: and activestatus = 1
190: update iby_instrholder
191: set activestatus = 0,
192: last_update_date = sysdate,
193: last_updated_by = fnd_global.user_id,
194: last_update_login = fnd_global.login_id
195: where ownertype = i_ownertype
196: and ownerid = i_ownerid
197: and activestatus = 1
198: and instrid = i_instrid;
199: else
200: update iby_instrholder
201: set activestatus = 0,
202: last_update_date = sysdate,
203: last_updated_by = fnd_global.user_id,
204: last_update_login = fnd_global.login_id
205: where ownertype = i_ownertype
206: and ownerid = i_ownerid
207: and instrtype = i_instrtype
200: update iby_instrholder
201: set activestatus = 0,
202: last_update_date = sysdate,
203: last_updated_by = fnd_global.user_id,
204: last_update_login = fnd_global.login_id
205: where ownertype = i_ownertype
206: and ownerid = i_ownerid
207: and instrtype = i_instrtype
208: and activestatus = 1