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_DTC_GENERATION_PKG dependencies on AP_INVOICE_LINES_INTERFACE

Line 5965: ln_invoice_to_tds_line_id ap_invoice_lines_interface.invoice_line_id%type;

5961:
5962: ln_invoice_to_tds_id ap_invoices_all.invoice_id%type;
5963: ln_invoice_to_vendor_id ap_invoices_all.invoice_id%type;
5964:
5965: ln_invoice_to_tds_line_id ap_invoice_lines_interface.invoice_line_id%type;
5966: ln_invoice_to_vendor_line_id ap_invoice_lines_interface.invoice_line_id%type;
5967:
5968: lv_invoice_to_tds_line_type ap_invoice_distributions_all.line_type_lookup_code%type; --File.Sql.35 Cbabu := 'ITEM';
5969: lv_invoice_to_vendor_line_type ap_invoice_distributions_all.line_type_lookup_code%type; --File.Sql.35 Cbabu := 'ITEM';

Line 5966: ln_invoice_to_vendor_line_id ap_invoice_lines_interface.invoice_line_id%type;

5962: ln_invoice_to_tds_id ap_invoices_all.invoice_id%type;
5963: ln_invoice_to_vendor_id ap_invoices_all.invoice_id%type;
5964:
5965: ln_invoice_to_tds_line_id ap_invoice_lines_interface.invoice_line_id%type;
5966: ln_invoice_to_vendor_line_id ap_invoice_lines_interface.invoice_line_id%type;
5967:
5968: lv_invoice_to_tds_line_type ap_invoice_distributions_all.line_type_lookup_code%type; --File.Sql.35 Cbabu := 'ITEM';
5969: lv_invoice_to_vendor_line_type ap_invoice_distributions_all.line_type_lookup_code%type; --File.Sql.35 Cbabu := 'ITEM';
5970:

Line 6860: ln_invoice_to_tds_line_id ap_invoice_lines_interface.invoice_line_id%type;

6856:
6857: ln_invoice_to_tds_id ap_invoices_all.invoice_id%type;
6858: ln_invoice_to_vendor_id ap_invoices_all.invoice_id%type;
6859:
6860: ln_invoice_to_tds_line_id ap_invoice_lines_interface.invoice_line_id%type;
6861: ln_invoice_to_vendor_line_id ap_invoice_lines_interface.invoice_line_id%type;
6862:
6863: lv_invoice_to_tds_line_type ap_invoice_distributions_all.line_type_lookup_code%type; --File.Sql.35 Cbabu := 'ITEM';
6864: lv_invoice_to_vendor_line_type ap_invoice_distributions_all.line_type_lookup_code%type; --File.Sql.35 Cbabu := 'ITEM';

Line 6861: ln_invoice_to_vendor_line_id ap_invoice_lines_interface.invoice_line_id%type;

6857: ln_invoice_to_tds_id ap_invoices_all.invoice_id%type;
6858: ln_invoice_to_vendor_id ap_invoices_all.invoice_id%type;
6859:
6860: ln_invoice_to_tds_line_id ap_invoice_lines_interface.invoice_line_id%type;
6861: ln_invoice_to_vendor_line_id ap_invoice_lines_interface.invoice_line_id%type;
6862:
6863: lv_invoice_to_tds_line_type ap_invoice_distributions_all.line_type_lookup_code%type; --File.Sql.35 Cbabu := 'ITEM';
6864: lv_invoice_to_vendor_line_type ap_invoice_distributions_all.line_type_lookup_code%type; --File.Sql.35 Cbabu := 'ITEM';
6865:

Line 7652: update ap_invoice_lines_interface

7648: end loop;
7649:
7650: if lv_invoice_to_tds_num is not null and lv_invoice_to_tds_type is not null and NVL(ln_invoice_to_tds_amount,0) <> 0 then
7651:
7652: update ap_invoice_lines_interface
7653: set amount = round(ln_invoice_to_tds_amount - ln_amount_for_sub_au , g_inr_currency_rounding)
7654: where invoice_id = ln_invoice_to_tds_id
7655: and line_number = 1;
7656:

Line 7662: update ap_invoice_lines_interface

7658:
7659:
7660: if lv_invoice_to_vendor_num is not null and lv_invoice_to_vendor_type is not null and NVL(ln_invoice_to_vendor_amount,0) <> 0 then
7661:
7662: update ap_invoice_lines_interface
7663: set amount = round(ln_invoice_to_vendor_amount - ln_amount_for_sub_cm, g_inr_currency_rounding)
7664: where invoice_id = ln_invoice_to_vendor_id
7665: and line_number = 1;
7666:

Line 10389: ln_invoice_to_tds_line_id ap_invoice_lines_interface.invoice_line_id%type;

10385:
10386: ln_invoice_to_tds_id ap_invoices_all.invoice_id%type;
10387: ln_invoice_to_vendor_id ap_invoices_all.invoice_id%type;
10388:
10389: ln_invoice_to_tds_line_id ap_invoice_lines_interface.invoice_line_id%type;
10390: ln_invoice_to_vendor_line_id ap_invoice_lines_interface.invoice_line_id%type;
10391:
10392: lv_invoice_to_tds_line_type ap_invoice_distributions_all.line_type_lookup_code%type; --File.Sql.35 Cbabu := 'ITEM';
10393: lv_invoice_to_vendor_line_type ap_invoice_distributions_all.line_type_lookup_code%type; --File.Sql.35 Cbabu := 'ITEM';

Line 10390: ln_invoice_to_vendor_line_id ap_invoice_lines_interface.invoice_line_id%type;

10386: ln_invoice_to_tds_id ap_invoices_all.invoice_id%type;
10387: ln_invoice_to_vendor_id ap_invoices_all.invoice_id%type;
10388:
10389: ln_invoice_to_tds_line_id ap_invoice_lines_interface.invoice_line_id%type;
10390: ln_invoice_to_vendor_line_id ap_invoice_lines_interface.invoice_line_id%type;
10391:
10392: lv_invoice_to_tds_line_type ap_invoice_distributions_all.line_type_lookup_code%type; --File.Sql.35 Cbabu := 'ITEM';
10393: lv_invoice_to_vendor_line_type ap_invoice_distributions_all.line_type_lookup_code%type; --File.Sql.35 Cbabu := 'ITEM';
10394:

Line 10945: update ap_invoice_lines_interface

10941: end loop;
10942:
10943: if lv_invoice_to_tds_num is not null and lv_invoice_to_tds_type is not null and NVL(ln_invoice_to_tds_amount,0) <> 0 then
10944:
10945: update ap_invoice_lines_interface
10946: set amount = round(ln_invoice_to_tds_amount - ln_amount_for_sub_au , g_inr_currency_rounding)
10947: where invoice_id = ln_invoice_to_tds_id
10948: and line_number = 1;
10949: end if;

Line 10952: update ap_invoice_lines_interface

10948: and line_number = 1;
10949: end if;
10950: if lv_invoice_to_vendor_num is not null and lv_invoice_to_vendor_type is not null and NVL(ln_invoice_to_vendor_amount,0) <> 0 then
10951:
10952: update ap_invoice_lines_interface
10953: set amount = round(ln_invoice_to_vendor_amount - ln_amount_for_sub_cm , g_inr_currency_rounding)
10954: where invoice_id = ln_invoice_to_vendor_id
10955: and line_number = 1;
10956: