DBA Data[Home] [Help]

APPS.JAI_AP_IA_TRIGGER_PKG dependencies on JAI_CMN_BOE_HDRS

Line 98: UPDATE JAI_CMN_BOE_HDRS hdr

94: END IF;/*5631784 end*/
95:
96: /* Updated By Wenqiong Zhou for Bug #1168411 BOE enhancement Start*/
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

Line 277: /* UPDATE JAI_CMN_BOE_HDRS hdr

273: ----------------------------------------------------
274: --Add by qiong.liu for bug12621302 09-JUN-2011 End
275: --Commented by qiong.liu for bug12621302 09-JUN-2011 Begin
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