APPS.JAI_AP_TDS_GENERATION_PKG dependencies on JAI_AP_TDS_INVOICES

Line 107: Added the WHO columns in the 'insert into JAI_AP_TDS_INVOICES' statement

103: jai_ap_tds_dflt.plb Version 120.3
104:
105: 14. 18-Aug-2005 Ramananda for bug#4560109 during R12 Sanity Testing. File Verion 120.5
106: In generate_tds_invoices procedure:
107: Added the WHO columns in the 'insert into JAI_AP_TDS_INVOICES' statement
108:
109: 15. 19-Aug-2005 Ramananda for bug#4562793. File Version 120.6
110: 1) Moved the Cursor - c_ja_in_tax_codes, up from below the cursor c_po_vendor_sites_all
111: 2) Changed the parameters being passed to cursor - c_po_vendors and c_po_vendor_sites_all

Line 1319: lv_source_attribute jai_ap_tds_invoices.source_attribute%TYPE ; --rchandan for bug#4428980

1315: lv_open_period ap_invoice_distributions_all.period_name%type;
1316: ln_tax_amount number;
1317:
1318: lv_invoice_num ap_invoices_all.invoice_num%type;
1319: lv_source_attribute jai_ap_tds_invoices.source_attribute%TYPE ; --rchandan for bug#4428980
1320:
1321: ln_invoice_amount ap_invoices_all.invoice_amount%TYPE; --Added by Ramananda for Bug#4562801
1322:
1323: lv_group_id VARCHAR2(80); --Added by Sanjikum for Bug#5131075(4722011)

Line 1768: insert into JAI_AP_TDS_INVOICES

1764: fnd_file.put_line(FND_FILE.LOG, 'org id '|| r_ap_invoices_all.org_id);
1765: fnd_file.put_line(FND_FILE.LOG, 'src att'||lv_source_attribute);
1766:
1767: IF NVL(ln_invoice_amount,0) <> 0 THEN --Added the condition by bgowrava for Bug#4549019
1768: insert into JAI_AP_TDS_INVOICES
1769: (TDS_INVOICE_ID,
1770: invoice_id,
1771: invoice_amount,
1772: tds_invoice_num,

Line 1790: ( JAI_AP_TDS_INVOICES_S.nextval,

1786: last_update_date ,
1787: last_update_login
1788: )
1789: values
1790: ( JAI_AP_TDS_INVOICES_S.nextval,
1791: pn_invoice_id,
1792: --round(ln_invoice_to_tds_amount * ( 100 / r_ja_in_tax_codes.tax_rate), 2),
1793: --commented the above and added the below by Ramananda for Bug#4562801
1794: ln_invoice_amount,