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_OLD_PKG dependencies on JAI_AP_TDS_INVOICES

Line 102: FROM JAI_AP_TDS_INVOICES

98: where invoice_id = p_inv_id;
99:
100: CURSOR tds_invoices(inv_id NUMBER) IS
101: SELECT tds_invoice_num,tds_tax_id,dm_invoice_num,tds_amount,tds_tax_rate,invoice_amount -- 4333449
102: FROM JAI_AP_TDS_INVOICES
103: WHERE invoice_id = inv_id;
104:
105: CURSOR vendor(t_id NUMBER) IS
106: SELECT vendor_id

Line 996: FROM JAI_AP_TDS_INVOICES

992: amt_applied,tds_tax_id,
993: tds_amount,
994: tds_tax_rate,
995: organization_id
996: FROM JAI_AP_TDS_INVOICES
997: WHERE invoice_id =inv_id
998: AND source_attribute=p_att;
999:
1000:

Line 1007: FROM JAI_AP_TDS_INVOICES

1003: amt_applied,tds_tax_id,
1004: tds_amount,
1005: tds_tax_rate,
1006: organization_id
1007: FROM JAI_AP_TDS_INVOICES
1008: WHERE source_attribute=p_att
1009: AND invoice_id = (SELECT invoice_id
1010: FROM ap_invoice_distributions_all
1011: WHERE invoice_distribution_id=prepay_dist_id);

Line 1015: FROM JAI_AP_TDS_INVOICES

1011: WHERE invoice_distribution_id=prepay_dist_id);
1012:
1013: /*CURSOR check_for_tds_invoice(inv_id NUMBER) IS
1014: SELECT tds_invoice_num,invoice_id,invoice_amount,amt_reversed,amt_applied,tds_tax_id,organization_id
1015: FROM JAI_AP_TDS_INVOICES
1016: WHERE invoice_id = inv_id
1017: AND source_attribute = p_attribute;*/
1018:
1019: CURSOR for_vendor_id(t_id NUMBER) IS

Line 1180: ln_tax_rate JAI_AP_TDS_INVOICES.tds_tax_rate%type;

1176:
1177: v_insertion_amount_tds_si NUMBER := 0; -- bug#3469847
1178: ln_prnt_pay_priority ap_payment_schedules_all.payment_priority%TYPE;
1179: ln_prnt_exchange_rate ap_invoices_all.exchange_rate%TYPE;
1180: ln_tax_rate JAI_AP_TDS_INVOICES.tds_tax_rate%type;
1181: ln_tax_amount JAI_AP_TDS_INVOICES.tds_amount%type;
1182: ln_taxable_amount JAI_AP_TDS_INVOICES.invoice_amount%type;
1183: lv_invoice_num ap_invoices_interface.invoice_num%type; --rchandan for bug#4428980
1184: lv_description ap_invoices_interface.description%type; --rchandan for bug#4428980

Line 1181: ln_tax_amount JAI_AP_TDS_INVOICES.tds_amount%type;

1177: v_insertion_amount_tds_si NUMBER := 0; -- bug#3469847
1178: ln_prnt_pay_priority ap_payment_schedules_all.payment_priority%TYPE;
1179: ln_prnt_exchange_rate ap_invoices_all.exchange_rate%TYPE;
1180: ln_tax_rate JAI_AP_TDS_INVOICES.tds_tax_rate%type;
1181: ln_tax_amount JAI_AP_TDS_INVOICES.tds_amount%type;
1182: ln_taxable_amount JAI_AP_TDS_INVOICES.invoice_amount%type;
1183: lv_invoice_num ap_invoices_interface.invoice_num%type; --rchandan for bug#4428980
1184: lv_description ap_invoices_interface.description%type; --rchandan for bug#4428980
1185: lv_lookup_type_code ap_invoices_interface.invoice_type_lookup_code%TYPE; --rchandan for bug#4428980

Line 1182: ln_taxable_amount JAI_AP_TDS_INVOICES.invoice_amount%type;

1178: ln_prnt_pay_priority ap_payment_schedules_all.payment_priority%TYPE;
1179: ln_prnt_exchange_rate ap_invoices_all.exchange_rate%TYPE;
1180: ln_tax_rate JAI_AP_TDS_INVOICES.tds_tax_rate%type;
1181: ln_tax_amount JAI_AP_TDS_INVOICES.tds_amount%type;
1182: ln_taxable_amount JAI_AP_TDS_INVOICES.invoice_amount%type;
1183: lv_invoice_num ap_invoices_interface.invoice_num%type; --rchandan for bug#4428980
1184: lv_description ap_invoices_interface.description%type; --rchandan for bug#4428980
1185: lv_lookup_type_code ap_invoices_interface.invoice_type_lookup_code%TYPE; --rchandan for bug#4428980
1186: lv_source ap_invoices_interface.source%type; --rchandan for bug#4428980

Line 1756: UPDATE JAI_AP_TDS_INVOICES

1752:
1753: insert_amt_ap := ABS(check_prep_amt_app_rec.amt_app);
1754: insert_inv_id := check_tds_prepayment_rec.invoice_id ;
1755:
1756: UPDATE JAI_AP_TDS_INVOICES
1757: SET amt_reversed = NVL(amt_reversed,0) - insertion_amount,
1758: amt_applied = NVL(amt_applied,0) - insert_amt_ap
1759: WHERE invoice_id = insert_inv_id ;
1760:

Line 1868: FROM JAI_AP_TDS_INVOICES

1864: tds_tax_id,
1865: tds_amount, -- 4333449
1866: tds_tax_rate, -- 4333449
1867: organization_id
1868: FROM JAI_AP_TDS_INVOICES
1869: WHERE invoice_id =inv_id
1870: AND source_attribute=p_att;
1871:
1872: CURSOR check_for_tds_invoice(prepay_dist_id NUMBER, p_att VARCHAR2) IS

Line 1882: FROM JAI_AP_TDS_INVOICES

1878: tds_tax_id,
1879: tds_amount, -- 4333449
1880: tds_tax_rate, -- 4333449
1881: organization_id
1882: FROM JAI_AP_TDS_INVOICES
1883: WHERE source_attribute=p_att
1884: AND invoice_id = (SELECT invoice_id
1885: FROM ap_invoice_distributions_all
1886: WHERE invoice_distribution_id=prepay_dist_id);

Line 2029: FROM JAI_AP_TDS_INVOICES

2025:
2026:
2027: CURSOR get_base_inv_id(v_inv_num VARCHAR2) IS
2028: SELECT invoice_id
2029: FROM JAI_AP_TDS_INVOICES
2030: WHERE tds_invoice_num = v_inv_num;
2031:
2032: get_base_inv_id_rec get_base_inv_id%ROWTYPE;
2033:

Line 2074: ln_tax_rate JAI_AP_TDS_INVOICES.tds_tax_rate%type; -- 4333449

2070: v_ap_sup_inv_num ap_invoices_all.invoice_num%TYPE;
2071: v_prepay_dist_date ap_invoice_distributions_all.accounting_date%TYPE; -- bug 3112711 kpvs
2072: ln_prnt_pay_priority ap_payment_schedules_all.payment_priority%TYPE; -- 4333449
2073: ln_prnt_exchange_rate ap_invoices_all.exchange_rate%TYPE; --4333449
2074: ln_tax_rate JAI_AP_TDS_INVOICES.tds_tax_rate%type; -- 4333449
2075: ln_tax_amount JAI_AP_TDS_INVOICES.tds_amount%type; -- 4333449
2076: ln_taxable_amount JAI_AP_TDS_INVOICES.invoice_amount%type; -- 4333449
2077:
2078: /* Ramananda for BIND VARIABLES Compliance */

Line 2075: ln_tax_amount JAI_AP_TDS_INVOICES.tds_amount%type; -- 4333449

2071: v_prepay_dist_date ap_invoice_distributions_all.accounting_date%TYPE; -- bug 3112711 kpvs
2072: ln_prnt_pay_priority ap_payment_schedules_all.payment_priority%TYPE; -- 4333449
2073: ln_prnt_exchange_rate ap_invoices_all.exchange_rate%TYPE; --4333449
2074: ln_tax_rate JAI_AP_TDS_INVOICES.tds_tax_rate%type; -- 4333449
2075: ln_tax_amount JAI_AP_TDS_INVOICES.tds_amount%type; -- 4333449
2076: ln_taxable_amount JAI_AP_TDS_INVOICES.invoice_amount%type; -- 4333449
2077:
2078: /* Ramananda for BIND VARIABLES Compliance */
2079: lv_tds_cm_num VARCHAR2(100);

Line 2076: ln_taxable_amount JAI_AP_TDS_INVOICES.invoice_amount%type; -- 4333449

2072: ln_prnt_pay_priority ap_payment_schedules_all.payment_priority%TYPE; -- 4333449
2073: ln_prnt_exchange_rate ap_invoices_all.exchange_rate%TYPE; --4333449
2074: ln_tax_rate JAI_AP_TDS_INVOICES.tds_tax_rate%type; -- 4333449
2075: ln_tax_amount JAI_AP_TDS_INVOICES.tds_amount%type; -- 4333449
2076: ln_taxable_amount JAI_AP_TDS_INVOICES.invoice_amount%type; -- 4333449
2077:
2078: /* Ramananda for BIND VARIABLES Compliance */
2079: lv_tds_cm_num VARCHAR2(100);
2080: lv_credit_note_tds VARCHAR2(100);

Line 3018: UPDATE JAI_AP_TDS_INVOICES

3014: );
3015:
3016: upd_inv_id := var_invoice_id ;
3017:
3018: UPDATE JAI_AP_TDS_INVOICES
3019: SET amt_reversed = NVL(amt_reversed,0) + insertion_amount,
3020: amt_applied = NVL(amt_applied,0) + p_amount
3021: WHERE invoice_id = upd_inv_id ;
3022:

Line 3610: FROM JAI_AP_TDS_INVOICES

3606: AND Vendor_Site_Id = p_vendor_site_id; */
3607:
3608: CURSOR Fetch_Inv_Num_Cur IS
3609: SELECT Tds_Invoice_Num, Dm_Invoice_Num, Tds_Tax_Id
3610: FROM JAI_AP_TDS_INVOICES
3611: WHERE Invoice_Id = p_invoice_id;
3612:
3613: CURSOR Fetch_Tds_Vendor_Dtls_Cur( v_tds_tax_id IN NUMBER ) IS
3614: SELECT Vendor_Id, Vendor_Site_Id

Line 3627: FROM JAI_AP_TDS_INVOICES

3623: AND Vendor_Site_Id = v_vendor_site_id;
3624:
3625: CURSOR for_cancelled_invoices(inv_id NUMBER) IS
3626: SELECT dm_invoice_num
3627: FROM JAI_AP_TDS_INVOICES
3628: WHERE invoice_id = inv_id;
3629:
3630: CURSOR cancelled_info(inv_id NUMBER) IS
3631: SELECT cancelled_date