DBA Data[Home] [Help]

APPS.JAI_AP_DTC_GENERATION_PKG dependencies on JAI_AP_TDS_INVOICES_S

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 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 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)