APPS.AP_CANCEL_PKG dependencies on AP_INVOICES_ALL

Line 145: FROM ap_invoices_all

141: l_debug_info := 'Get the org_id for the invoice';
142:
143: SELECT org_id
144: INTO l_org_id
145: FROM ap_invoices_all
146: WHERE invoice_id = p_invoice_id;
147:
148: l_debug_info := 'Check if inv distribution has open period';
149:

Line 587: FROM AP_Invoices_All AI,

583: -- notifying the calling product.
584:
585: CURSOR c_reg_products IS
586: SELECT Reg_Application_ID
587: FROM AP_Invoices_All AI,
588: AP_Product_Registrations APR
589: WHERE AI.Invoice_ID = P_Invoice_ID
590: AND AI.Application_ID = APR.Reg_Application_ID
591: AND APR.Registration_Event_Type = 'INVOICE_CANCELLED';

Line 615: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;

611: i BINARY_INTEGER := 1;
612: l_tax_holds_count NUMBER := 0;
613: l_hold_code_tab AP_ETAX_SERVICES_PKG.REL_HOLD_CODES_TYPE;
614: l_token VARCHAR2(4000);
615: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
616: l_invoice_validation_status VARCHAR2(100);
617: l_payment_status_flag AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE;
618: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;
619: Tax_Exception EXCEPTION;

Line 617: l_payment_status_flag AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE;

613: l_hold_code_tab AP_ETAX_SERVICES_PKG.REL_HOLD_CODES_TYPE;
614: l_token VARCHAR2(4000);
615: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
616: l_invoice_validation_status VARCHAR2(100);
617: l_payment_status_flag AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE;
618: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;
619: Tax_Exception EXCEPTION;
620: --Bug 4539462 DBI logging
621: l_dbi_key_value_list ap_dbi_pkg.r_dbi_key_value_arr;

Line 618: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;

614: l_token VARCHAR2(4000);
615: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
616: l_invoice_validation_status VARCHAR2(100);
617: l_payment_status_flag AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE;
618: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;
619: Tax_Exception EXCEPTION;
620: --Bug 4539462 DBI logging
621: l_dbi_key_value_list ap_dbi_pkg.r_dbi_key_value_arr;
622:

Line 631: l_open_gl_date AP_INVOICES_ALL.gl_date%type;

627:
628: -- Bug 4748638
629: l_Accounting_event_ID AP_INVOICE_DISTRIBUTIONS_ALL.accounting_event_id%TYPE;
630: l_cancel_dist_exists NUMBER := 0;
631: l_open_gl_date AP_INVOICES_ALL.gl_date%type;
632: l_funds_return_code VARCHAR2(30); -- 4276409 (3462325)
633:
634: -- Payment request Cancellation Subscription
635: l_return_status varchar2(1);