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 2006: cursor c_ap_payment_schedules_all(p_invoice_id number) is

2002: cursor c_get_ja_in_ap_inv_id is
2003: 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
2004: from dual;
2005:
2006: cursor c_ap_payment_schedules_all(p_invoice_id number) is
2007: select payment_priority
2008: from ap_payment_schedules_all
2009: where invoice_id = p_invoice_id;
2010:

Line 2008: from ap_payment_schedules_all

2004: from dual;
2005:
2006: cursor c_ap_payment_schedules_all(p_invoice_id number) is
2007: select payment_priority
2008: from ap_payment_schedules_all
2009: where invoice_id = p_invoice_id;
2010:
2011: r_ap_invoices_all c_ap_invoices_all%rowtype;
2012: r_ja_in_tax_codes c_ja_in_tax_codes%rowtype;

Line 2016: r_ap_payment_schedules_all c_ap_payment_schedules_all%rowtype;

2012: r_ja_in_tax_codes c_ja_in_tax_codes%rowtype;
2013: r_po_vendor_sites_all c_po_vendor_sites_all%rowtype;
2014: r_po_vendors c_po_vendors%rowtype;
2015: r_gl_sets_of_books c_gl_sets_of_books%rowtype;
2016: r_ap_payment_schedules_all c_ap_payment_schedules_all%rowtype;
2017:
2018:
2019: lv_source varchar2(30); --File.Sql.35 Cbabu := 'TDS';
2020:

Line 2535: open c_ap_payment_schedules_all(pn_invoice_id);

2531: end if;
2532: end if; /* Invoice to Supplier */
2533:
2534: /* Store the parent invoices payment priority as this is to be used in the credit memo generated for the supplier */
2535: open c_ap_payment_schedules_all(pn_invoice_id);
2536: fetch c_ap_payment_schedules_all into r_ap_payment_schedules_all;
2537: close c_ap_payment_schedules_all;
2538:
2539: /* Bug 5751783

Line 2536: fetch c_ap_payment_schedules_all into r_ap_payment_schedules_all;

2532: end if; /* Invoice to Supplier */
2533:
2534: /* Store the parent invoices payment priority as this is to be used in the credit memo generated for the supplier */
2535: open c_ap_payment_schedules_all(pn_invoice_id);
2536: fetch c_ap_payment_schedules_all into r_ap_payment_schedules_all;
2537: close c_ap_payment_schedules_all;
2538:
2539: /* Bug 5751783
2540: * Moved the assignment of ln_invoice_amount outside IF as this is used

Line 2537: close c_ap_payment_schedules_all;

2533:
2534: /* Store the parent invoices payment priority as this is to be used in the credit memo generated for the supplier */
2535: open c_ap_payment_schedules_all(pn_invoice_id);
2536: fetch c_ap_payment_schedules_all into r_ap_payment_schedules_all;
2537: close c_ap_payment_schedules_all;
2538:
2539: /* Bug 5751783
2540: * Moved the assignment of ln_invoice_amount outside IF as this is used
2541: * in the insert to jai_ap_tds_thhold_trxs. This has to be derived irrespective

Line 2735: r_ap_payment_schedules_all.payment_priority ,

2731: lv_invoice_to_vendor_num ,
2732: lv_invoice_to_vendor_type ,
2733: r_ap_invoices_all.invoice_currency_code ,
2734: ln_invoice_to_vendor_amount ,
2735: r_ap_payment_schedules_all.payment_priority ,
2736: r_ap_invoices_all.exchange_rate ,
2737: fnd_global.user_id ,
2738: sysdate ,
2739: fnd_global.user_id ,