APPS.IBY_INSTRHOLDER_PKG dependencies on FND_GLOBAL

Line 126: sysdate, fnd_global.user_id, sysdate,

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:

Line 127: fnd_global.user_id, 1);

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:

Line 193: last_updated_by = fnd_global.user_id,

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

Line 194: last_update_login = fnd_global.login_id

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;

Line 203: last_updated_by = fnd_global.user_id,

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

Line 204: last_update_login = fnd_global.login_id

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