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 600: FROM AP_Invoices_All AI,

596: -- notifying the calling product.
597:
598: CURSOR c_reg_products IS
599: SELECT Reg_Application_ID
600: FROM AP_Invoices_All AI,
601: AP_Product_Registrations APR
602: WHERE AI.Invoice_ID = P_Invoice_ID
603: AND AI.Application_ID = APR.Reg_Application_ID
604: AND APR.Registration_Event_Type = 'INVOICE_CANCELLED';

Line 628: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;

624: i BINARY_INTEGER := 1;
625: l_tax_holds_count NUMBER := 0;
626: l_hold_code_tab AP_ETAX_SERVICES_PKG.REL_HOLD_CODES_TYPE;
627: l_token VARCHAR2(4000);
628: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
629: l_invoice_validation_status VARCHAR2(100);
630: l_payment_status_flag AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE;
631: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;
632: Tax_Exception EXCEPTION;

Line 630: l_payment_status_flag AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE;

626: l_hold_code_tab AP_ETAX_SERVICES_PKG.REL_HOLD_CODES_TYPE;
627: l_token VARCHAR2(4000);
628: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
629: l_invoice_validation_status VARCHAR2(100);
630: l_payment_status_flag AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE;
631: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;
632: Tax_Exception EXCEPTION;
633: --Bug 4539462 DBI logging
634: l_dbi_key_value_list ap_dbi_pkg.r_dbi_key_value_arr;

Line 631: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;

627: l_token VARCHAR2(4000);
628: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
629: l_invoice_validation_status VARCHAR2(100);
630: l_payment_status_flag AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE;
631: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;
632: Tax_Exception EXCEPTION;
633: --Bug 4539462 DBI logging
634: l_dbi_key_value_list ap_dbi_pkg.r_dbi_key_value_arr;
635:

Line 644: l_open_gl_date AP_INVOICES_ALL.gl_date%type;

640:
641: -- Bug 4748638
642: l_Accounting_event_ID AP_INVOICE_DISTRIBUTIONS_ALL.accounting_event_id%TYPE;
643: l_cancel_dist_exists NUMBER := 0;
644: l_open_gl_date AP_INVOICES_ALL.gl_date%type;
645: l_funds_return_code VARCHAR2(30); -- 4276409 (3462325)
646:
647: -- Payment request Cancellation Subscription
648: l_return_status varchar2(1);