DBA Data[Home] [Help]

APPS.IGI_VENDOR_MERGE_GRP dependencies on FND_GLOBAL

Line 103: last_update_login = FND_GLOBAL.login_id,

99: UPDATE igi_cis_payment_vouchers
100: SET vendor_id = p_new_vendor_id,
101: vendor_site_id = p_new_vendor_site_id,
102: last_update_date = SYSDATE,
103: last_update_login = FND_GLOBAL.login_id,
104: last_updated_by = FND_GLOBAL.user_id
105: WHERE vendor_id = p_old_vendor_id
106: AND vendor_site_id = p_old_vendor_site_id;
107:

Line 104: last_updated_by = FND_GLOBAL.user_id

100: SET vendor_id = p_new_vendor_id,
101: vendor_site_id = p_new_vendor_site_id,
102: last_update_date = SYSDATE,
103: last_update_login = FND_GLOBAL.login_id,
104: last_updated_by = FND_GLOBAL.user_id
105: WHERE vendor_id = p_old_vendor_id
106: AND vendor_site_id = p_old_vendor_site_id;
107:
108: END IF;

Line 202: du.last_update_login = FND_GLOBAL.login_id,

198: UPDATE igi_exp_dus du
199: SET du.du_stp_id = p_new_vendor_id,
200: du.du_stp_site_id = p_new_vendor_site_id,
201: du.last_update_date = SYSDATE,
202: du.last_update_login = FND_GLOBAL.login_id,
203: du.last_updated_by = FND_GLOBAL.user_id
204: WHERE du.du_stp_id = p_old_vendor_id
205: AND du.du_stp_site_id = p_old_vendor_site_id
206: AND du.du_type_header_id IN

Line 203: du.last_updated_by = FND_GLOBAL.user_id

199: SET du.du_stp_id = p_new_vendor_id,
200: du.du_stp_site_id = p_new_vendor_site_id,
201: du.last_update_date = SYSDATE,
202: du.last_update_login = FND_GLOBAL.login_id,
203: du.last_updated_by = FND_GLOBAL.user_id
204: WHERE du.du_stp_id = p_old_vendor_id
205: AND du.du_stp_site_id = p_old_vendor_site_id
206: AND du.du_type_header_id IN
207: (SELECT du_type_header_id

Line 217: du.last_update_login = FND_GLOBAL.login_id,

213: UPDATE igi_exp_dus du
214: SET du.du_stp_id = p_new_vendor_id,
215: du.du_stp_site_id = p_new_vendor_site_id,
216: du.last_update_date = SYSDATE,
217: du.last_update_login = FND_GLOBAL.login_id,
218: du.last_updated_by = FND_GLOBAL.user_id
219: WHERE du.du_stp_id = p_old_vendor_id
220: AND du.du_stp_site_id = p_old_vendor_site_id
221: AND du.du_status <> 'COM'

Line 218: du.last_updated_by = FND_GLOBAL.user_id

214: SET du.du_stp_id = p_new_vendor_id,
215: du.du_stp_site_id = p_new_vendor_site_id,
216: du.last_update_date = SYSDATE,
217: du.last_update_login = FND_GLOBAL.login_id,
218: du.last_updated_by = FND_GLOBAL.user_id
219: WHERE du.du_stp_id = p_old_vendor_id
220: AND du.du_stp_site_id = p_old_vendor_site_id
221: AND du.du_status <> 'COM'
222: AND du.du_type_header_id IN

Line 234: du.last_update_login = FND_GLOBAL.login_id,

230: UPDATE igi_exp_dus du
231: SET du.du_stp_id = p_new_vendor_id,
232: du.du_stp_site_id = p_new_vendor_site_id,
233: du.last_update_date = SYSDATE,
234: du.last_update_login = FND_GLOBAL.login_id,
235: du.last_updated_by = FND_GLOBAL.user_id
236: WHERE du.du_stp_id = p_old_vendor_id
237: AND du.du_stp_site_id = p_old_vendor_site_id
238: AND du.du_status = 'COM'

Line 235: du.last_updated_by = FND_GLOBAL.user_id

231: SET du.du_stp_id = p_new_vendor_id,
232: du.du_stp_site_id = p_new_vendor_site_id,
233: du.last_update_date = SYSDATE,
234: du.last_update_login = FND_GLOBAL.login_id,
235: du.last_updated_by = FND_GLOBAL.user_id
236: WHERE du.du_stp_id = p_old_vendor_id
237: AND du.du_stp_site_id = p_old_vendor_site_id
238: AND du.du_status = 'COM'
239: AND du.du_type_header_id IN