APPS.AP_IMPORT_VALIDATION_PKG dependencies on AP_INVOICES_ALL

Line 21451: l_related_inv_id ap_invoices_all.invoice_id%TYPE;

21447:
21448: debug_info VARCHAR2(500);
21449: check_tax_failure EXCEPTION;
21450:
21451: l_related_inv_id ap_invoices_all.invoice_id%TYPE;
21452: l_exist_tax_line ap_invoices_all.invoice_id%TYPE;
21453: l_alloc_not_provided VARCHAR2(1);
21454: l_tax_lines_cannot_coexist VARCHAR2(1);
21455: l_tax_found_in_nontax_line VARCHAR2(1);

Line 21452: l_exist_tax_line ap_invoices_all.invoice_id%TYPE;

21448: debug_info VARCHAR2(500);
21449: check_tax_failure EXCEPTION;
21450:
21451: l_related_inv_id ap_invoices_all.invoice_id%TYPE;
21452: l_exist_tax_line ap_invoices_all.invoice_id%TYPE;
21453: l_alloc_not_provided VARCHAR2(1);
21454: l_tax_lines_cannot_coexist VARCHAR2(1);
21455: l_tax_found_in_nontax_line VARCHAR2(1);
21456:

Line 21512: FROM ap_invoices_all

21508:
21509: BEGIN
21510: SELECT invoice_id
21511: INTO l_related_inv_id
21512: FROM ap_invoices_all
21513: WHERE invoice_id = p_invoice_rec.tax_related_invoice_id
21514: AND vendor_id = p_invoice_rec.vendor_id
21515: AND vendor_site_id = p_invoice_rec.vendor_site_id
21516: AND cancelled_date IS NULL

Line 22768: l_remit_party_id AP_INVOICES_ALL.PARTY_ID%TYPE;

22764: -- Bug 5448579
22765: l_valid_payment_method IBY_PAYMENT_METHODS_VL.Payment_Method_Code%TYPE;
22766:
22767: --Bug 8213679
22768: l_remit_party_id AP_INVOICES_ALL.PARTY_ID%TYPE;
22769: l_remit_party_site_id AP_INVOICES_ALL.PARTY_SITE_ID%TYPE;
22770: --Bug 8213679
22771:
22772:

Line 22769: l_remit_party_site_id AP_INVOICES_ALL.PARTY_SITE_ID%TYPE;

22765: l_valid_payment_method IBY_PAYMENT_METHODS_VL.Payment_Method_Code%TYPE;
22766:
22767: --Bug 8213679
22768: l_remit_party_id AP_INVOICES_ALL.PARTY_ID%TYPE;
22769: l_remit_party_site_id AP_INVOICES_ALL.PARTY_SITE_ID%TYPE;
22770: --Bug 8213679
22771:
22772:
22773: begin