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.AP_INVOICE_LINES_PKG dependencies on AP_INVOICES_ALL

Line 23: l_user_id ap_invoices_all.created_by%TYPE := FND_GLOBAL.user_id;

19: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
20: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_INVOICE_LINES_PKG.';
21:
22: --Bug14383132: Start
23: l_user_id ap_invoices_all.created_by%TYPE := FND_GLOBAL.user_id;
24: l_reverse_dist_count NUMBER := 0; --Bug14383132
25: l_sa_reverse_dist_count NUMBER:= 0; --Bug14383132
26:
27: FUNCTION TAX_DISTRIBUTIONS_EXIST

Line 1867: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;

1863:
1864: l_invoice_validation_status VARCHAR2(100);
1865: l_success BOOLEAN;
1866: l_error_code VARCHAR2(4000);
1867: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;
1868: l_payment_status_flag AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE;
1869: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
1870: l_included_tax_amount AP_INVOICE_LINES_ALL.INCLUDED_TAX_AMOUNT%TYPE;
1871: l_tax_distribution_count NUMBER;

Line 1868: l_payment_status_flag AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE;

1864: l_invoice_validation_status VARCHAR2(100);
1865: l_success BOOLEAN;
1866: l_error_code VARCHAR2(4000);
1867: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;
1868: l_payment_status_flag AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE;
1869: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
1870: l_included_tax_amount AP_INVOICE_LINES_ALL.INCLUDED_TAX_AMOUNT%TYPE;
1871: l_tax_distribution_count NUMBER;
1872:

Line 1869: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;

1865: l_success BOOLEAN;
1866: l_error_code VARCHAR2(4000);
1867: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;
1868: l_payment_status_flag AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE;
1869: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
1870: l_included_tax_amount AP_INVOICE_LINES_ALL.INCLUDED_TAX_AMOUNT%TYPE;
1871: l_tax_distribution_count NUMBER;
1872:
1873: --Contract Payments

Line 2018: l_recouped_amount ap_invoices_all.invoice_amount%type;

2014: FROM ap_invoice_distributions_all aid
2015: WHERE aid.invoice_id = p_line_rec.invoice_id;
2016:
2017: --bugfix:5638822
2018: l_recouped_amount ap_invoices_all.invoice_amount%type;
2019: l_amount_paid number;
2020: l_error_message varchar2(4000);
2021: l_payment_currency_code ap_invoices_all.payment_currency_code%TYPE;
2022: l_amount_remaining number;

Line 2021: l_payment_currency_code ap_invoices_all.payment_currency_code%TYPE;

2017: --bugfix:5638822
2018: l_recouped_amount ap_invoices_all.invoice_amount%type;
2019: l_amount_paid number;
2020: l_error_message varchar2(4000);
2021: l_payment_currency_code ap_invoices_all.payment_currency_code%TYPE;
2022: l_amount_remaining number;
2023:
2024: TYPE r_line_number_arr IS TABLE OF ap_invoice_distributions.distribution_line_number%TYPE; /*Bug 9841966*/
2025: TYPE r_ppay_incl_arr IS TABLE OF ap_invoice_lines_all.invoice_includes_prepay_flag%TYPE; /*Bug 9841966*/

Line 2031: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type;

2027: --bugfix:5697764
2028: l_tax_line_number r_line_number_arr; --number; /*Bug 9841966: Commented old datatype and changed it to pl/sql array*/
2029: l_unapplied_tax_amount number;
2030: l_unapplied_tax_amt_pay_curr number;
2031: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type;
2032: l_payment_cross_rate_date ap_invoices_all.payment_cross_rate_date%type;
2033: l_payment_cross_rate_type ap_invoices_all.payment_cross_rate_type%type;
2034: l_prepay_included r_ppay_incl_arr;--ap_invoice_lines_all.invoice_includes_prepay_flag%type; /*Bug 9841966: Commented old datatype and changed it to pl/sql array*/
2035:

Line 2032: l_payment_cross_rate_date ap_invoices_all.payment_cross_rate_date%type;

2028: l_tax_line_number r_line_number_arr; --number; /*Bug 9841966: Commented old datatype and changed it to pl/sql array*/
2029: l_unapplied_tax_amount number;
2030: l_unapplied_tax_amt_pay_curr number;
2031: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type;
2032: l_payment_cross_rate_date ap_invoices_all.payment_cross_rate_date%type;
2033: l_payment_cross_rate_type ap_invoices_all.payment_cross_rate_type%type;
2034: l_prepay_included r_ppay_incl_arr;--ap_invoice_lines_all.invoice_includes_prepay_flag%type; /*Bug 9841966: Commented old datatype and changed it to pl/sql array*/
2035:
2036: --bug 8361741

Line 2033: l_payment_cross_rate_type ap_invoices_all.payment_cross_rate_type%type;

2029: l_unapplied_tax_amount number;
2030: l_unapplied_tax_amt_pay_curr number;
2031: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type;
2032: l_payment_cross_rate_date ap_invoices_all.payment_cross_rate_date%type;
2033: l_payment_cross_rate_type ap_invoices_all.payment_cross_rate_type%type;
2034: l_prepay_included r_ppay_incl_arr;--ap_invoice_lines_all.invoice_includes_prepay_flag%type; /*Bug 9841966: Commented old datatype and changed it to pl/sql array*/
2035:
2036: --bug 8361741
2037: l_itm_dist_count NUMBER;