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_DTC_GENERATION_PKG dependencies on AP_PAYMENT_SCHEDULES_ALL

Line 5917: cursor c_ap_payment_schedules_all(p_invoice_id number) is

5913: cursor c_get_ja_in_ap_inv_id is
5914: select to_char(JAI_AP_TDS_THHOLD_TRXS_S1.nextval)--to_char(JAI_AP_TDS_INVOICE_NUM_S.nextval)commented by rchandan for bug#4487676
5915: from dual;
5916:
5917: cursor c_ap_payment_schedules_all(p_invoice_id number) is
5918: select payment_priority
5919: from ap_payment_schedules_all
5920: where invoice_id = p_invoice_id;
5921:

Line 5919: from ap_payment_schedules_all

5915: from dual;
5916:
5917: cursor c_ap_payment_schedules_all(p_invoice_id number) is
5918: select payment_priority
5919: from ap_payment_schedules_all
5920: where invoice_id = p_invoice_id;
5921:
5922: --Add by Chong on 20130130 for bug#16048702 begin
5923: ----------------------------------------------------------------------

Line 5951: r_ap_payment_schedules_all c_ap_payment_schedules_all%rowtype;

5947: r_ja_in_tax_codes c_ja_in_tax_codes%rowtype;
5948: r_po_vendor_sites_all c_po_vendor_sites_all%rowtype;
5949: r_po_vendors c_po_vendors%rowtype;
5950: r_gl_sets_of_books c_gl_sets_of_books%rowtype;
5951: r_ap_payment_schedules_all c_ap_payment_schedules_all%rowtype;
5952:
5953:
5954: lv_source varchar2(30); --File.Sql.35 Cbabu := 'TDS';
5955:

Line 6506: open c_ap_payment_schedules_all(pn_invoice_id);

6502: end if;
6503: end if; /* Invoice to Supplier */
6504:
6505: /* Store the parent invoices payment priority as this is to be used in the credit memo generated for the supplier */
6506: open c_ap_payment_schedules_all(pn_invoice_id);
6507: fetch c_ap_payment_schedules_all into r_ap_payment_schedules_all;
6508: close c_ap_payment_schedules_all;
6509:
6510: /* Bug 5751783

Line 6507: fetch c_ap_payment_schedules_all into r_ap_payment_schedules_all;

6503: end if; /* Invoice to Supplier */
6504:
6505: /* Store the parent invoices payment priority as this is to be used in the credit memo generated for the supplier */
6506: open c_ap_payment_schedules_all(pn_invoice_id);
6507: fetch c_ap_payment_schedules_all into r_ap_payment_schedules_all;
6508: close c_ap_payment_schedules_all;
6509:
6510: /* Bug 5751783
6511: * Moved the assignment of ln_invoice_amount outside IF as this is used

Line 6508: close c_ap_payment_schedules_all;

6504:
6505: /* Store the parent invoices payment priority as this is to be used in the credit memo generated for the supplier */
6506: open c_ap_payment_schedules_all(pn_invoice_id);
6507: fetch c_ap_payment_schedules_all into r_ap_payment_schedules_all;
6508: close c_ap_payment_schedules_all;
6509:
6510: /* Bug 5751783
6511: * Moved the assignment of ln_invoice_amount outside IF as this is used
6512: * in the insert to jai_ap_tds_thhold_trxs. This has to be derived irrespective

Line 6718: r_ap_payment_schedules_all.payment_priority ,

6714: lv_invoice_to_vendor_num ,
6715: lv_invoice_to_vendor_type ,
6716: r_ap_invoices_all.invoice_currency_code ,
6717: ln_invoice_to_vendor_amount ,
6718: r_ap_payment_schedules_all.payment_priority ,
6719: r_ap_invoices_all.exchange_rate ,
6720: fnd_global.user_id ,
6721: sysdate ,
6722: fnd_global.user_id ,

Line 6836: cursor c_ap_payment_schedules_all(p_invoice_id number) is

6832: cursor c_get_ja_in_ap_inv_id is
6833: select to_char(JAI_AP_TDS_THHOLD_TRXS_S1.nextval)--to_char(JAI_AP_TDS_INVOICE_NUM_S.nextval)commented by rchandan for bug#4487676
6834: from dual;
6835:
6836: cursor c_ap_payment_schedules_all(p_invoice_id number) is
6837: select payment_priority
6838: from ap_payment_schedules_all
6839: where invoice_id = p_invoice_id;
6840:

Line 6838: from ap_payment_schedules_all

6834: from dual;
6835:
6836: cursor c_ap_payment_schedules_all(p_invoice_id number) is
6837: select payment_priority
6838: from ap_payment_schedules_all
6839: where invoice_id = p_invoice_id;
6840:
6841: r_ap_invoices_all c_ap_invoices_all%rowtype;
6842: r_ja_in_tax_codes c_ja_in_tax_codes%rowtype;

Line 6846: r_ap_payment_schedules_all c_ap_payment_schedules_all%rowtype;

6842: r_ja_in_tax_codes c_ja_in_tax_codes%rowtype;
6843: r_po_vendor_sites_all c_po_vendor_sites_all%rowtype;
6844: r_po_vendors c_po_vendors%rowtype;
6845: r_gl_sets_of_books c_gl_sets_of_books%rowtype;
6846: r_ap_payment_schedules_all c_ap_payment_schedules_all%rowtype;
6847:
6848:
6849: lv_source varchar2(30); --File.Sql.35 Cbabu := 'TDS';
6850:

Line 7672: open c_ap_payment_schedules_all(pn_invoice_id);

7668:
7669:
7670:
7671: /* Store the parent invoices payment priority as this is to be used in the credit memo generated for the supplier */
7672: open c_ap_payment_schedules_all(pn_invoice_id);
7673: fetch c_ap_payment_schedules_all into r_ap_payment_schedules_all;
7674: close c_ap_payment_schedules_all;
7675:
7676: /* Bug 5751783

Line 7673: fetch c_ap_payment_schedules_all into r_ap_payment_schedules_all;

7669:
7670:
7671: /* Store the parent invoices payment priority as this is to be used in the credit memo generated for the supplier */
7672: open c_ap_payment_schedules_all(pn_invoice_id);
7673: fetch c_ap_payment_schedules_all into r_ap_payment_schedules_all;
7674: close c_ap_payment_schedules_all;
7675:
7676: /* Bug 5751783
7677: * Moved the assignment of ln_invoice_amount outside IF as this is used

Line 7674: close c_ap_payment_schedules_all;

7670:
7671: /* Store the parent invoices payment priority as this is to be used in the credit memo generated for the supplier */
7672: open c_ap_payment_schedules_all(pn_invoice_id);
7673: fetch c_ap_payment_schedules_all into r_ap_payment_schedules_all;
7674: close c_ap_payment_schedules_all;
7675:
7676: /* Bug 5751783
7677: * Moved the assignment of ln_invoice_amount outside IF as this is used
7678: * in the insert to jai_ap_tds_thhold_trxs. This has to be derived irrespective

Line 7923: r_ap_payment_schedules_all.payment_priority ,

7919: lv_invoice_to_vendor_num ,
7920: lv_invoice_to_vendor_type ,
7921: r_ap_invoices_all.invoice_currency_code ,
7922: ln_invoice_to_vendor_amount ,
7923: r_ap_payment_schedules_all.payment_priority ,
7924: r_ap_invoices_all.exchange_rate ,
7925: fnd_global.user_id ,
7926: sysdate ,
7927: fnd_global.user_id ,

Line 10365: cursor c_ap_payment_schedules_all(p_invoice_id number) is

10361: cursor c_get_ja_in_ap_inv_id is
10362: select to_char(JAI_AP_TDS_THHOLD_TRXS_S1.nextval)--to_char(JAI_AP_TDS_INVOICE_NUM_S.nextval)commented by rchandan for bug#4487676
10363: from dual;
10364:
10365: cursor c_ap_payment_schedules_all(p_invoice_id number) is
10366: select payment_priority
10367: from ap_payment_schedules_all
10368: where invoice_id = p_invoice_id;
10369:

Line 10367: from ap_payment_schedules_all

10363: from dual;
10364:
10365: cursor c_ap_payment_schedules_all(p_invoice_id number) is
10366: select payment_priority
10367: from ap_payment_schedules_all
10368: where invoice_id = p_invoice_id;
10369:
10370: r_ap_invoices_all c_ap_invoices_all%rowtype;
10371: r_ja_in_tax_codes c_ja_in_tax_codes%rowtype;

Line 10375: r_ap_payment_schedules_all c_ap_payment_schedules_all%rowtype;

10371: r_ja_in_tax_codes c_ja_in_tax_codes%rowtype;
10372: r_po_vendor_sites_all c_po_vendor_sites_all%rowtype;
10373: r_po_vendors c_po_vendors%rowtype;
10374: r_gl_sets_of_books c_gl_sets_of_books%rowtype;
10375: r_ap_payment_schedules_all c_ap_payment_schedules_all%rowtype;
10376:
10377:
10378: lv_source varchar2(30); --File.Sql.35 Cbabu := 'TDS';
10379:

Line 10961: open c_ap_payment_schedules_all(r_ap_invoices_all.invoice_id);

10957: end if;
10958:
10959:
10960: /* Store the parent invoices payment priority as this is to be used in the credit memo generated for the supplier */
10961: open c_ap_payment_schedules_all(r_ap_invoices_all.invoice_id);
10962: fetch c_ap_payment_schedules_all into r_ap_payment_schedules_all;
10963: close c_ap_payment_schedules_all;
10964:
10965:

Line 10962: fetch c_ap_payment_schedules_all into r_ap_payment_schedules_all;

10958:
10959:
10960: /* Store the parent invoices payment priority as this is to be used in the credit memo generated for the supplier */
10961: open c_ap_payment_schedules_all(r_ap_invoices_all.invoice_id);
10962: fetch c_ap_payment_schedules_all into r_ap_payment_schedules_all;
10963: close c_ap_payment_schedules_all;
10964:
10965:
10966: /* Bug 5751783

Line 10963: close c_ap_payment_schedules_all;

10959:
10960: /* Store the parent invoices payment priority as this is to be used in the credit memo generated for the supplier */
10961: open c_ap_payment_schedules_all(r_ap_invoices_all.invoice_id);
10962: fetch c_ap_payment_schedules_all into r_ap_payment_schedules_all;
10963: close c_ap_payment_schedules_all;
10964:
10965:
10966: /* Bug 5751783
10967: * Moved the assignment of ln_invoice_amount outside IF as this is used

Line 11095: r_ap_payment_schedules_all.payment_priority ,

11091: lv_invoice_to_vendor_num ,
11092: lv_invoice_to_vendor_type ,
11093: r_ap_invoices_all.invoice_currency_code ,
11094: ln_invoice_to_vendor_amount ,
11095: r_ap_payment_schedules_all.payment_priority ,
11096: r_ap_invoices_all.exchange_rate ,
11097: fnd_global.user_id ,
11098: sysdate ,
11099: fnd_global.user_id ,