DBA Data[Home] [Help]

APPS.AP_INVOICE_LINES_PKG dependencies on AP_INVOICES_ALL

Line 1812: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;

1808:
1809: l_invoice_validation_status VARCHAR2(100);
1810: l_success BOOLEAN;
1811: l_error_code VARCHAR2(4000);
1812: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;
1813: l_payment_status_flag AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE;
1814: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
1815: l_included_tax_amount AP_INVOICE_LINES_ALL.INCLUDED_TAX_AMOUNT%TYPE;
1816: l_tax_distribution_count NUMBER;

Line 1813: l_payment_status_flag AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE;

1809: l_invoice_validation_status VARCHAR2(100);
1810: l_success BOOLEAN;
1811: l_error_code VARCHAR2(4000);
1812: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;
1813: l_payment_status_flag AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE;
1814: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
1815: l_included_tax_amount AP_INVOICE_LINES_ALL.INCLUDED_TAX_AMOUNT%TYPE;
1816: l_tax_distribution_count NUMBER;
1817:

Line 1814: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;

1810: l_success BOOLEAN;
1811: l_error_code VARCHAR2(4000);
1812: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;
1813: l_payment_status_flag AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE;
1814: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
1815: l_included_tax_amount AP_INVOICE_LINES_ALL.INCLUDED_TAX_AMOUNT%TYPE;
1816: l_tax_distribution_count NUMBER;
1817:
1818: --Contract Payments

Line 1935: l_recouped_amount ap_invoices_all.invoice_amount%type;

1931: FROM ap_invoice_distributions_all aid
1932: WHERE aid.invoice_id = p_line_rec.invoice_id;
1933:
1934: --bugfix:5638822
1935: l_recouped_amount ap_invoices_all.invoice_amount%type;
1936: l_amount_paid number;
1937: l_error_message varchar2(4000);
1938: l_payment_currency_code ap_invoices_all.payment_currency_code%TYPE;
1939: l_amount_remaining number;

Line 1938: l_payment_currency_code ap_invoices_all.payment_currency_code%TYPE;

1934: --bugfix:5638822
1935: l_recouped_amount ap_invoices_all.invoice_amount%type;
1936: l_amount_paid number;
1937: l_error_message varchar2(4000);
1938: l_payment_currency_code ap_invoices_all.payment_currency_code%TYPE;
1939: l_amount_remaining number;
1940:
1941: --bugfix:5697764
1942: l_tax_line_number number;

Line 1945: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type;

1941: --bugfix:5697764
1942: l_tax_line_number number;
1943: l_unapplied_tax_amount number;
1944: l_unapplied_tax_amt_pay_curr number;
1945: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type;
1946: l_payment_cross_rate_date ap_invoices_all.payment_cross_rate_date%type;
1947: l_payment_cross_rate_type ap_invoices_all.payment_cross_rate_type%type;
1948: l_prepay_included ap_invoice_lines_all.invoice_includes_prepay_flag%type;
1949:

Line 1946: l_payment_cross_rate_date ap_invoices_all.payment_cross_rate_date%type;

1942: l_tax_line_number number;
1943: l_unapplied_tax_amount number;
1944: l_unapplied_tax_amt_pay_curr number;
1945: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type;
1946: l_payment_cross_rate_date ap_invoices_all.payment_cross_rate_date%type;
1947: l_payment_cross_rate_type ap_invoices_all.payment_cross_rate_type%type;
1948: l_prepay_included ap_invoice_lines_all.invoice_includes_prepay_flag%type;
1949:
1950: BEGIN

Line 1947: l_payment_cross_rate_type ap_invoices_all.payment_cross_rate_type%type;

1943: l_unapplied_tax_amount number;
1944: l_unapplied_tax_amt_pay_curr number;
1945: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type;
1946: l_payment_cross_rate_date ap_invoices_all.payment_cross_rate_date%type;
1947: l_payment_cross_rate_type ap_invoices_all.payment_cross_rate_type%type;
1948: l_prepay_included ap_invoice_lines_all.invoice_includes_prepay_flag%type;
1949:
1950: BEGIN
1951: