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_TAX_PROCESSING_PKG dependencies on JAI_AP_TDS_THHOLD_TRXS

Line 1339: FROM jai_ap_tds_thhold_trxs

1335: CURSOR c_tds_invoice_id(cp_invoice_id NUMBER)
1336: IS
1337: SELECT invoice_to_tds_authority_id invoice_id
1338: , invoice_to_tds_authority_num invoice_num
1339: FROM jai_ap_tds_thhold_trxs
1340: WHERE invoice_id = cp_invoice_id;
1341:
1342: CURSOR c_payment_status(cp_invoice_id NUMBER)
1343: IS

Line 2007: cursor c_jai_ap_tds_thhold_trxs(cp_invoice_id number) IS

2003: select apsa.*
2004: from ap_payment_schedules_all apsa
2005: where apsa.invoice_id = cp_trx_id;
2006:
2007: cursor c_jai_ap_tds_thhold_trxs(cp_invoice_id number) IS
2008: select parent_inv_payment_priority
2009: from jai_ap_tds_thhold_trxs
2010: where invoice_to_vendor_id = cp_invoice_id;
2011:

Line 2009: from jai_ap_tds_thhold_trxs

2005: where apsa.invoice_id = cp_trx_id;
2006:
2007: cursor c_jai_ap_tds_thhold_trxs(cp_invoice_id number) IS
2008: select parent_inv_payment_priority
2009: from jai_ap_tds_thhold_trxs
2010: where invoice_to_vendor_id = cp_invoice_id;
2011:
2012: cursor c_match_tax
2013: ( cp_match_type VARCHAR2,

Line 2029: ln_parent_inv_payment_priority jai_ap_tds_thhold_trxs.parent_inv_payment_priority%type;

2025: where invoice_id=cp_trx_id
2026: and line_type_lookup_code in ('ITEM', 'MISCELLANEOUS', 'FREIGHT') --Added by Chong for bug#16743694 2013/05/07
2027: ;
2028:
2029: ln_parent_inv_payment_priority jai_ap_tds_thhold_trxs.parent_inv_payment_priority%type;
2030: inv_rec AP_INVOICES_ALL%ROWTYPE;
2031: inv_line_rec AP_INVOICE_LINES_ALL%ROWTYPE;
2032: inv_dist_rec AP_INVOICE_DISTRIBUTIONS_ALL%ROWTYPE;
2033: inv_ps_rec AP_PAYMENT_SCHEDULES%ROWTYPE;

Line 2097: open c_jai_ap_tds_thhold_trxs(p_event_class_rec.trx_id);

2093: LOOP
2094: fnd_file.put_line(fnd_file.log,'In JAI_AP_TAX_PROCESSING.OPEN_INTERFACEIN at LOOP c_get_inv_pss invoice_id=' ||p_event_class_rec.trx_id);
2095: IF inv_rec.invoice_type_lookup_code = 'CREDIT' and inv_rec.source = 'INDIA TDS' then
2096:
2097: open c_jai_ap_tds_thhold_trxs(p_event_class_rec.trx_id);
2098: fetch c_jai_ap_tds_thhold_trxs into ln_parent_inv_payment_priority;
2099: close c_jai_ap_tds_thhold_trxs;
2100:
2101: IF ln_parent_inv_payment_priority is not null THEN

Line 2098: fetch c_jai_ap_tds_thhold_trxs into ln_parent_inv_payment_priority;

2094: fnd_file.put_line(fnd_file.log,'In JAI_AP_TAX_PROCESSING.OPEN_INTERFACEIN at LOOP c_get_inv_pss invoice_id=' ||p_event_class_rec.trx_id);
2095: IF inv_rec.invoice_type_lookup_code = 'CREDIT' and inv_rec.source = 'INDIA TDS' then
2096:
2097: open c_jai_ap_tds_thhold_trxs(p_event_class_rec.trx_id);
2098: fetch c_jai_ap_tds_thhold_trxs into ln_parent_inv_payment_priority;
2099: close c_jai_ap_tds_thhold_trxs;
2100:
2101: IF ln_parent_inv_payment_priority is not null THEN
2102: update ap_payment_schedules_all

Line 2099: close c_jai_ap_tds_thhold_trxs;

2095: IF inv_rec.invoice_type_lookup_code = 'CREDIT' and inv_rec.source = 'INDIA TDS' then
2096:
2097: open c_jai_ap_tds_thhold_trxs(p_event_class_rec.trx_id);
2098: fetch c_jai_ap_tds_thhold_trxs into ln_parent_inv_payment_priority;
2099: close c_jai_ap_tds_thhold_trxs;
2100:
2101: IF ln_parent_inv_payment_priority is not null THEN
2102: update ap_payment_schedules_all
2103: set payment_priority = ln_parent_inv_payment_priority