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 2052: lv_source_attribute jai_ap_tds_invoices.source_attribute%TYPE ; --rchandan for bug#4428980

2048: lv_open_period ap_invoice_distributions_all.period_name%type;
2049: ln_tax_amount number;
2050:
2051: lv_invoice_num ap_invoices_all.invoice_num%type;
2052: lv_source_attribute jai_ap_tds_invoices.source_attribute%TYPE ; --rchandan for bug#4428980
2053:
2054: ln_invoice_amount ap_invoices_all.invoice_amount%TYPE; --Added by Ramananda for Bug#4562801
2055:
2056: lv_group_id VARCHAR2(80); --Added by Sanjikum for Bug#5131075(4722011)

Line 2582: insert into JAI_AP_TDS_INVOICES

2578: fnd_file.put_line(FND_FILE.LOG, 'org id '|| r_ap_invoices_all.org_id);
2579: fnd_file.put_line(FND_FILE.LOG, 'src att'||lv_source_attribute);
2580:
2581: IF NVL(ln_invoice_amount,0) <> 0 THEN --Added the condition by bgowrava for Bug#4549019
2582: insert into JAI_AP_TDS_INVOICES
2583: (TDS_INVOICE_ID,
2584: invoice_id,
2585: invoice_amount,
2586: tds_invoice_num,

Line 2604: ( JAI_AP_TDS_INVOICES_S.nextval,

2600: last_update_date ,
2601: last_update_login
2602: )
2603: values
2604: ( JAI_AP_TDS_INVOICES_S.nextval,
2605: pn_invoice_id,
2606: --round(ln_invoice_to_tds_amount * ( 100 / r_ja_in_tax_codes.tax_rate), 2),
2607: --commented the above and added the below by Ramananda for Bug#4562801
2608: ln_invoice_amount,