APPS.JAI_AP_IA_TRIGGER_PKG dependencies on FND_GLOBAL

Line 88: last_updated_by = fnd_global.user_id,

84: IF nvl(pr_old.payment_status_flag,'N') <> 'Y' AND nvl(pr_new.payment_status_flag,'N') = 'Y' AND pr_new.invoice_num like 'TCS%' THEN
85:
86: UPDATE jai_rgm_settlements
87: SET invoice_id = pr_new.invoice_id,
88: last_updated_by = fnd_global.user_id,
89: last_update_date = sysdate
90: WHERE system_invoice_no = pr_new.invoice_num
91: AND tax_authority_id = pr_new.vendor_id
92: AND tax_authority_site_id = pr_new.vendor_site_id;

Line 101: ,last_update_login = fnd_global.login_id

97: IF nvl(pr_old.payment_status_flag,'N') <> 'Y' AND nvl(pr_new.payment_status_flag,'N') = 'Y' AND pr_new.invoice_num like 'BOE%' THEN
98: UPDATE JAI_CMN_BOE_HDRS hdr
99: SET hdr.status = 'AVAILABLE'
100: ,last_update_date = SYSDATE
101: ,last_update_login = fnd_global.login_id
102: ,last_updated_by = fnd_global.user_id
103: WHERE hdr.boe_id = to_number(pr_new.reference_key1);
104: END IF;
105: /* Updated By Wenqiong Zhou for Bug #1168411 BOE enhancement End*/

Line 102: ,last_updated_by = fnd_global.user_id

98: UPDATE JAI_CMN_BOE_HDRS hdr
99: SET hdr.status = 'AVAILABLE'
100: ,last_update_date = SYSDATE
101: ,last_update_login = fnd_global.login_id
102: ,last_updated_by = fnd_global.user_id
103: WHERE hdr.boe_id = to_number(pr_new.reference_key1);
104: END IF;
105: /* Updated By Wenqiong Zhou for Bug #1168411 BOE enhancement End*/
106: end if; /* updating */

Line 280: ,last_update_login = fnd_global.login_id

276: ----------------------------------------------------------
277: /* UPDATE JAI_CMN_BOE_HDRS hdr
278: SET hdr.status = 'CANCELLED'
279: ,last_update_date = SYSDATE
280: ,last_update_login = fnd_global.login_id
281: ,last_updated_by = fnd_global.user_id
282: WHERE hdr.boe_id = to_number(pr_new.reference_key1);
283: */
284: ----------------------------------------------------------

Line 281: ,last_updated_by = fnd_global.user_id

277: /* UPDATE JAI_CMN_BOE_HDRS hdr
278: SET hdr.status = 'CANCELLED'
279: ,last_update_date = SYSDATE
280: ,last_update_login = fnd_global.login_id
281: ,last_updated_by = fnd_global.user_id
282: WHERE hdr.boe_id = to_number(pr_new.reference_key1);
283: */
284: ----------------------------------------------------------
285: --Commented by qiong.liu for bug12621302 09-JUN-2011 End