eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AP_IA_TRIGGER_PKG dependencies on JAI_RGM_SETTLEMENTS

Line 40: the invoice_id column in the jai_rgm_settlements table with the

36:
37: 4. 01-FEB-2007 CSahoo for BUG#5631784, Version 120.1
38: Forward Porting of ii1 BUG#4742259(TCS solution)
39: When an invoice generated during the TCS settlement is paid we update
40: the invoice_id column in the jai_rgm_settlements table with the
41: corresponding invoice_id.
42: Update of invoice_id in jai_rgm_settlements is made when payment_status_flag is
43: Y. Previously it was checking if amount_paid is more than invoice_amount.
44: This would not work if there is any discount.

Line 42: Update of invoice_id in jai_rgm_settlements is made when payment_status_flag is

38: Forward Porting of ii1 BUG#4742259(TCS solution)
39: When an invoice generated during the TCS settlement is paid we update
40: the invoice_id column in the jai_rgm_settlements table with the
41: corresponding invoice_id.
42: Update of invoice_id in jai_rgm_settlements is made when payment_status_flag is
43: Y. Previously it was checking if amount_paid is more than invoice_amount.
44: This would not work if there is any discount.
45: The if condition to update invoice_id in jai_rgm_settlements was modified from
46: IF nvl(:new.payment_status_flag,'N') <> 'Y' AND nvl(:new.payment_status_flag,'N') = 'Y' to

Line 45: The if condition to update invoice_id in jai_rgm_settlements was modified from

41: corresponding invoice_id.
42: Update of invoice_id in jai_rgm_settlements is made when payment_status_flag is
43: Y. Previously it was checking if amount_paid is more than invoice_amount.
44: This would not work if there is any discount.
45: The if condition to update invoice_id in jai_rgm_settlements was modified from
46: IF nvl(:new.payment_status_flag,'N') <> 'Y' AND nvl(:new.payment_status_flag,'N') = 'Y' to
47: IF nvl(:old.payment_status_flag,'N') <> 'Y' AND nvl(:new.payment_status_flag,'N') = 'Y'
48: 5 29/03/2007 bduvarag for bug#5662741,File version 120.2
49: Forward porting the changes done in 11i bug#5638769

Line 86: UPDATE jai_rgm_settlements

82:
83: /*BUG#5631784, Added by CSahoo*/
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