DBA Data[Home] [Help]

APPS.AP_IMPORT_INVOICES_PKG dependencies on AP_INVOICES_ALL

Line 2600: FROM ap_invoices_all ai

2596: FROM ap_invoice_lines_all ail
2597: WHERE ail.invoice_id = l_base_invoice_id
2598: AND ail.line_type_lookup_code = 'TAX')
2599: INTO l_inv_hdr_amount, l_exclusive_tax_amount
2600: FROM ap_invoices_all ai
2601: WHERE ai.invoice_id = l_base_invoice_id;
2602:
2603: l_payment_status_flag := AP_INVOICES_UTILITY_PKG.get_payment_status (l_base_invoice_id);
2604:

Line 2619: UPDATE ap_invoices_all ai

2615: X_calling_sequence => 'APXIIMPT',
2616: X_calling_mode => 'APXIIMPT',
2617: X_revalidate_ps => l_revalidate_ps);
2618:
2619: UPDATE ap_invoices_all ai
2620: SET ai.invoice_amount = ai.invoice_amount + l_exclusive_tax_amount,
2621: ai.amount_applicable_to_discount = ai.amount_applicable_to_discount + l_exclusive_tax_amount
2622: WHERE ai.invoice_id = l_base_invoice_id;
2623:

Line 2626: UPDATE ap_invoices_all ai

2622: WHERE ai.invoice_id = l_base_invoice_id;
2623:
2624: IF ( l_invoice_rec.payment_cross_rate is NOT NULL) THEN
2625:
2626: UPDATE ap_invoices_all ai
2627: SET ai.pay_curr_invoice_amount = ai.pay_curr_invoice_amount +
2628: gl_currency_api.convert_amount(
2629: ai.invoice_currency_code,
2630: ai.payment_currency_code,