APPS.AP_INVOICE_LINES_PKG dependencies on AP_INVOICE_LINES_ALL

Line 1815: l_included_tax_amount AP_INVOICE_LINES_ALL.INCLUDED_TAX_AMOUNT%TYPE;

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
1819: l_prepay_dist_info AP_PREPAY_PKG.prepay_dist_tab_type;

Line 1884: ,ap_invoice_lines_all ail

1880: CURSOR c_charge_lines(c_invoice_id number,
1881: c_item_line_number number) Is
1882: SELECT ail.*
1883: FROM ap_allocation_rule_lines arl
1884: ,ap_invoice_lines_all ail
1885: WHERE arl.invoice_id = c_invoice_id
1886: AND arl.to_invoice_line_number = c_item_line_number
1887: AND arl.invoice_id = ail.invoice_id
1888: AND arl.chrg_invoice_line_number = ail.line_number

Line 1895: l_chrg_line_rec ap_invoice_lines_all%rowtype;

1891: from ap_invoice_distributions_all aid
1892: where aid.invoice_id = ail.invoice_id
1893: and aid.invoice_line_number = ail.line_number);
1894:
1895: l_chrg_line_rec ap_invoice_lines_all%rowtype;
1896:
1897: -- Bug 5396138 Start
1898: cursor c_recouped_shipment IS
1899: select pll.line_location_id

Line 1908: from ap_invoice_lines_all ail

1904: 'AMOUNT_CORRECTION', 0,
1905: 'ITEM_TO_SERVICE_PO', 0,
1906: 'ITEM_TO_SERVICE_RECEIPT', 0,
1907: NVL(AID.corrected_quantity, 0) + NVL(AID.quantity_invoiced,0))) quantity
1908: from ap_invoice_lines_all ail
1909: ,ap_invoice_distributions_all aid
1910: ,po_distributions_all pod
1911: ,po_line_locations_all pll
1912: where ail.invoice_id = p_line_rec.invoice_id

Line 1948: l_prepay_included ap_invoice_lines_all.invoice_includes_prepay_flag%type;

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:
1952: l_shipment_amt_billed := 0;

Line 2103: update ap_invoice_lines_all ail

2099: l_debug_info := 'Reset generate distributions flag on related charge lines';
2100: Print (l_api_name, l_debug_info);
2101: ----------------------------------------------------------------------------
2102:
2103: update ap_invoice_lines_all ail
2104: set generate_dists = 'Y'
2105: where ail.invoice_id = p_line_rec.invoice_id
2106: and exists (select arl.chrg_invoice_line_number
2107: from ap_allocation_rule_lines arl

Line 2490: UPDATE ap_invoice_lines_all

2486: IF p_line_rec.line_type_lookup_code = 'RETAINAGE RELEASE' AND
2487: p_line_rec.retained_invoice_id IS NOT NULL AND
2488: p_line_rec.retained_line_number IS NOT NULL THEN
2489:
2490: UPDATE ap_invoice_lines_all
2491: SET retained_amount_remaining = nvl(retained_amount_remaining, 0) + p_line_rec.amount
2492: WHERE invoice_id = p_line_rec.retained_invoice_id
2493: AND line_number = p_line_rec.retained_line_number;
2494:

Line 3309: (p_inv_line_rec IN AP_INVOICE_LINES_ALL%rowtype,

3305:
3306: END Discard_Inv_line;
3307:
3308: FUNCTION Reverse_Charge_Distributions
3309: (p_inv_line_rec IN AP_INVOICE_LINES_ALL%rowtype,
3310: p_calling_mode IN VARCHAR2,
3311: x_error_code OUT NOCOPY VARCHAR2,
3312: x_debug_info OUT NOCOPY VARCHAR2,
3313: p_calling_sequence IN VARCHAR2) RETURN BOOLEAN IS