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

Line 1273: cursor c_ap_payment_schedules_all(p_invoice_id number) is

1269: cursor c_get_ja_in_ap_inv_id is
1270: 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
1271: from dual;
1272:
1273: cursor c_ap_payment_schedules_all(p_invoice_id number) is
1274: select payment_priority
1275: from ap_payment_schedules_all
1276: where invoice_id = p_invoice_id;
1277:

Line 1275: from ap_payment_schedules_all

1271: from dual;
1272:
1273: cursor c_ap_payment_schedules_all(p_invoice_id number) is
1274: select payment_priority
1275: from ap_payment_schedules_all
1276: where invoice_id = p_invoice_id;
1277:
1278: r_ap_invoices_all c_ap_invoices_all%rowtype;
1279: r_ja_in_tax_codes c_ja_in_tax_codes%rowtype;

Line 1283: r_ap_payment_schedules_all c_ap_payment_schedules_all%rowtype;

1279: r_ja_in_tax_codes c_ja_in_tax_codes%rowtype;
1280: r_po_vendor_sites_all c_po_vendor_sites_all%rowtype;
1281: r_po_vendors c_po_vendors%rowtype;
1282: r_gl_sets_of_books c_gl_sets_of_books%rowtype;
1283: r_ap_payment_schedules_all c_ap_payment_schedules_all%rowtype;
1284:
1285:
1286: lv_source varchar2(30); --File.Sql.35 Cbabu := 'TDS';
1287:

Line 1730: open c_ap_payment_schedules_all(pn_invoice_id);

1726: end if;
1727: end if; /* Invoice to Supplier */
1728:
1729: /* Store the parent invoices payment priority as this is to be used in the credit memo generated for the supplier */
1730: open c_ap_payment_schedules_all(pn_invoice_id);
1731: fetch c_ap_payment_schedules_all into r_ap_payment_schedules_all;
1732: close c_ap_payment_schedules_all;
1733:
1734: /* For downward compatibility with the pre-cleanup code */

Line 1731: fetch c_ap_payment_schedules_all into r_ap_payment_schedules_all;

1727: end if; /* Invoice to Supplier */
1728:
1729: /* Store the parent invoices payment priority as this is to be used in the credit memo generated for the supplier */
1730: open c_ap_payment_schedules_all(pn_invoice_id);
1731: fetch c_ap_payment_schedules_all into r_ap_payment_schedules_all;
1732: close c_ap_payment_schedules_all;
1733:
1734: /* For downward compatibility with the pre-cleanup code */
1735: if ( (pv_tds_event = 'INVOICE VALIDATE') or (pv_tds_event like 'THRESHOLD TRANSITION%') ) then

Line 1732: close c_ap_payment_schedules_all;

1728:
1729: /* Store the parent invoices payment priority as this is to be used in the credit memo generated for the supplier */
1730: open c_ap_payment_schedules_all(pn_invoice_id);
1731: fetch c_ap_payment_schedules_all into r_ap_payment_schedules_all;
1732: close c_ap_payment_schedules_all;
1733:
1734: /* For downward compatibility with the pre-cleanup code */
1735: if ( (pv_tds_event = 'INVOICE VALIDATE') or (pv_tds_event like 'THRESHOLD TRANSITION%') ) then
1736:

Line 1902: r_ap_payment_schedules_all.payment_priority ,

1898: lv_invoice_to_vendor_num ,
1899: lv_invoice_to_vendor_type ,
1900: r_ap_invoices_all.invoice_currency_code ,
1901: ln_invoice_to_vendor_amount ,
1902: r_ap_payment_schedules_all.payment_priority ,
1903: r_ap_invoices_all.exchange_rate ,
1904: fnd_global.user_id ,
1905: sysdate ,
1906: fnd_global.user_id ,