APPS.AP_RECT_MATCH_PKG dependencies on AP_INVOICES_ALL

Line 229: G_source ap_invoices_all.source%type;

225: G_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;
226: G_user_defined_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;
227: G_assessable_value zx_lines_det_factors.assessable_value%type;
228: G_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
229: G_source ap_invoices_all.source%type;
230:
231:
232: PROCEDURE Base_Credit_RCV_Match(
233: X_match_mode IN VARCHAR2,

Line 829: l_accounting_date ap_invoices_all.gl_date%TYPE;

825: X_Po_Line_Location_Id IN NUMBER,
826: X_Calling_Sequence IN VARCHAR2 ) IS
827:
828: current_calling_sequence VARCHAR2(2000);
829: l_accounting_date ap_invoices_all.gl_date%TYPE;
830: l_debug_info VARCHAR2(2000);
831: l_api_name VARCHAR2(32);
832: BEGIN
833:

Line 913: FROM ap_invoices_all ai ,

909: g_vendor_site_id,
910: g_source,
911: g_pay_awt_group_id --bug 9689194
912: /* Bug 5572876, using base tables */
913: FROM ap_invoices_all ai ,
914: ap_system_parameters_all asp,
915: ap_suppliers pv,
916: ap_supplier_sites_all pvs,
917: financials_system_params_all fsp,

Line 1904: l_source AP_INVOICES_ALL.SOURCE%TYPE ; -- Bug 9160534

1900:
1901: current_calling_sequence VARCHAR2(2000);
1902: l_debug_info VARCHAR2(2000);
1903: l_api_name VARCHAR2(4000);
1904: l_source AP_INVOICES_ALL.SOURCE%TYPE ; -- Bug 9160534
1905: l_full_mtch_amt NUMBER; --Bug13505998
1906:
1907: BEGIN
1908:

Line 1937: from ap_invoices_all ai

1933: --from PO.
1934:
1935: -- Bug 9160534. Start
1936: select nvl(ai.source, 'DUMMY') into l_source
1937: from ap_invoices_all ai
1938: where ai.invoice_id = X_Invoice_Id;
1939: -- Bug 9160534. End
1940:
1941: INSERT INTO AP_INVOICE_LINES