APPS.JAI_AP_DTC_GENERATION_PKG dependencies on JAI_AP_TDS_INVOICES

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

5983: lv_open_period ap_invoice_distributions_all.period_name%type;
5984: ln_tax_amount number;
5985:
5986: lv_invoice_num ap_invoices_all.invoice_num%type;
5987: lv_source_attribute jai_ap_tds_invoices.source_attribute%TYPE ; --rchandan for bug#4428980
5988:
5989: ln_invoice_amount ap_invoices_all.invoice_amount%TYPE; --Added by Ramananda for Bug#4562801
5990:
5991: lv_group_id VARCHAR2(80); --Added by Sanjikum for Bug#5131075(4722011)

Line 6564: insert into JAI_AP_TDS_INVOICES

6560: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'org id '|| r_ap_invoices_all.org_id);
6561: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'src att'||lv_source_attribute);
6562:
6563: IF NVL(ln_invoice_amount,0) <> 0 THEN --Added the condition by bgowrava for Bug#4549019
6564: insert into JAI_AP_TDS_INVOICES
6565: (TDS_INVOICE_ID,
6566: invoice_id,
6567: invoice_amount,
6568: tds_invoice_num,

Line 6586: ( JAI_AP_TDS_INVOICES_S.nextval,

6582: last_update_date ,
6583: last_update_login
6584: )
6585: values
6586: ( JAI_AP_TDS_INVOICES_S.nextval,
6587: pn_invoice_id,
6588: --round(ln_invoice_to_tds_amount * ( 100 / r_ja_in_tax_codes.tax_rate), 2),
6589: --commented the above and added the below by Ramananda for Bug#4562801
6590: ln_invoice_amount,

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

6878: lv_open_period ap_invoice_distributions_all.period_name%type;
6879: ln_tax_amount number;
6880:
6881: lv_invoice_num ap_invoices_all.invoice_num%type;
6882: lv_source_attribute jai_ap_tds_invoices.source_attribute%TYPE ; --rchandan for bug#4428980
6883:
6884: ln_invoice_amount ap_invoices_all.invoice_amount%TYPE; --Added by Ramananda for Bug#4562801
6885:
6886: lv_group_id VARCHAR2(80); --Added by Sanjikum for Bug#5131075(4722011)

Line 7764: insert into JAI_AP_TDS_INVOICES

7760: --fnd_file.put_line(FND_FILE.LOG, 'org id '|| r_ap_invoices_all.org_id);
7761: --fnd_file.put_line(FND_FILE.LOG, 'src att'||lv_source_attribute);
7762:
7763: IF NVL(ln_invoice_amount,0) <> 0 THEN --Added the condition by bgowrava for Bug#4549019
7764: insert into JAI_AP_TDS_INVOICES
7765: (TDS_INVOICE_ID,
7766: invoice_id,
7767: invoice_amount,
7768: tds_invoice_num,

Line 7787: ( JAI_AP_TDS_INVOICES_S.nextval,

7783: last_update_date ,
7784: last_update_login
7785: )
7786: values
7787: ( JAI_AP_TDS_INVOICES_S.nextval,
7788: pn_invoice_id,
7789: --round(ln_invoice_to_tds_amount * ( 100 / r_ja_in_tax_codes.tax_rate), 2),
7790: --commented the above and added the below by Ramananda for Bug#4562801
7791: pn_taxable_amount,--ln_invoice_amount,--UPdate by Zhiwei Hou on 20120111

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

10407: lv_open_period ap_invoice_distributions_all.period_name%type;
10408: ln_tax_amount number;
10409:
10410: lv_invoice_num ap_invoices_all.invoice_num%type;
10411: lv_source_attribute jai_ap_tds_invoices.source_attribute%TYPE ; --rchandan for bug#4428980
10412:
10413: ln_invoice_amount ap_invoices_all.invoice_amount%TYPE; --Added by Ramananda for Bug#4562801
10414:
10415: lv_group_id VARCHAR2(80); --Added by Sanjikum for Bug#5131075(4722011)