APPS.AP_IMPORT_VALIDATION_PKG dependencies on AP_INVOICES_ALL

Line 19649: l_related_inv_id ap_invoices_all.invoice_id%TYPE;

19645:
19646: debug_info VARCHAR2(500);
19647: check_tax_failure EXCEPTION;
19648:
19649: l_related_inv_id ap_invoices_all.invoice_id%TYPE;
19650: l_exist_tax_line ap_invoices_all.invoice_id%TYPE;
19651: l_alloc_not_provided VARCHAR2(1);
19652: l_tax_lines_cannot_coexist VARCHAR2(1);
19653: l_tax_found_in_nontax_line VARCHAR2(1);

Line 19650: l_exist_tax_line ap_invoices_all.invoice_id%TYPE;

19646: debug_info VARCHAR2(500);
19647: check_tax_failure EXCEPTION;
19648:
19649: l_related_inv_id ap_invoices_all.invoice_id%TYPE;
19650: l_exist_tax_line ap_invoices_all.invoice_id%TYPE;
19651: l_alloc_not_provided VARCHAR2(1);
19652: l_tax_lines_cannot_coexist VARCHAR2(1);
19653: l_tax_found_in_nontax_line VARCHAR2(1);
19654:

Line 19707: FROM ap_invoices_all

19703:
19704: BEGIN
19705: SELECT invoice_id
19706: INTO l_related_inv_id
19707: FROM ap_invoices_all
19708: WHERE invoice_id = p_invoice_rec.tax_related_invoice_id
19709: AND vendor_id = p_invoice_rec.vendor_id
19710: AND vendor_site_id = p_invoice_rec.vendor_site_id
19711: AND cancelled_date IS NULL

Line 20943: l_remit_party_id AP_INVOICES_ALL.PARTY_ID%TYPE;

20939: -- Bug 5448579
20940: l_valid_payment_method IBY_PAYMENT_METHODS_VL.Payment_Method_Code%TYPE;
20941:
20942: --Bug 8213679
20943: l_remit_party_id AP_INVOICES_ALL.PARTY_ID%TYPE;
20944: l_remit_party_site_id AP_INVOICES_ALL.PARTY_SITE_ID%TYPE;
20945: --Bug 8213679
20946:
20947:

Line 20944: l_remit_party_site_id AP_INVOICES_ALL.PARTY_SITE_ID%TYPE;

20940: l_valid_payment_method IBY_PAYMENT_METHODS_VL.Payment_Method_Code%TYPE;
20941:
20942: --Bug 8213679
20943: l_remit_party_id AP_INVOICES_ALL.PARTY_ID%TYPE;
20944: l_remit_party_site_id AP_INVOICES_ALL.PARTY_SITE_ID%TYPE;
20945: --Bug 8213679
20946:
20947:
20948: begin