DBA Data[Home] [Help]

APPS.AP_RECT_MATCH_PKG dependencies on AP_INVOICES

Line 166: G_invoice_type_lookup_code ap_invoices.invoice_type_lookup_code%TYPE;

162: G_accounting_date ap_invoice_lines.accounting_date%TYPE;
163: G_period_name gl_period_statuses.period_name%TYPE;
164: G_set_of_books_id ap_system_parameters.set_of_books_id%TYPE;
165: G_awt_group_id ap_awt_groups.group_id%TYPE;
166: G_invoice_type_lookup_code ap_invoices.invoice_type_lookup_code%TYPE;
167: G_exchange_rate ap_invoices.exchange_rate%TYPE;
168: G_precision fnd_currencies.precision%TYPE;
169: G_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;
170: G_system_allow_awt_flag ap_system_parameters.allow_awt_flag%TYPE;

Line 167: G_exchange_rate ap_invoices.exchange_rate%TYPE;

163: G_period_name gl_period_statuses.period_name%TYPE;
164: G_set_of_books_id ap_system_parameters.set_of_books_id%TYPE;
165: G_awt_group_id ap_awt_groups.group_id%TYPE;
166: G_invoice_type_lookup_code ap_invoices.invoice_type_lookup_code%TYPE;
167: G_exchange_rate ap_invoices.exchange_rate%TYPE;
168: G_precision fnd_currencies.precision%TYPE;
169: G_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;
170: G_system_allow_awt_flag ap_system_parameters.allow_awt_flag%TYPE;
171: G_site_allow_awt_flag po_vendor_sites.allow_awt_flag%TYPE;

Line 176: G_invoice_currency_code ap_invoices.invoice_currency_code%TYPE;

172: G_transfer_flag ap_system_parameters.transfer_desc_flex_flag%TYPE;
173: G_allow_pa_override varchar2(1);
174: G_pa_expenditure_date_default varchar2(50);
175: G_base_currency_code ap_system_parameters.base_currency_code%TYPE;
176: G_invoice_currency_code ap_invoices.invoice_currency_code%TYPE;
177: G_prepay_ccid ap_system_parameters.prepay_code_combination_id%TYPE;
178: G_Build_Prepay_Accts_Flag ap_system_parameters.build_prepayment_accounts_flag%TYPE;
179: G_income_tax_region ap_system_parameters.income_tax_region%TYPE;
180: G_project_id pa_projects_all.project_id%TYPE;

Line 183: G_invoice_date ap_invoices.invoice_date%TYPE;

179: G_income_tax_region ap_system_parameters.income_tax_region%TYPE;
180: G_project_id pa_projects_all.project_id%TYPE;
181: G_task_id pa_tasks.task_id%TYPE;
182: G_expenditure_type pa_expenditure_types.expenditure_type%TYPE;
183: G_invoice_date ap_invoices.invoice_date%TYPE;
184: G_expenditure_organization_id pa_exp_orgs_it.organization_id%TYPE;
185: G_asset_book_type_code fa_book_controls.book_type_code%TYPE;
186: G_inventory_organization_id financials_system_parameters.inventory_organization_id%TYPE;
187: G_allow_account_override ap_system_parameters.allow_flex_override_flag%TYPE;

Line 191: --G_Ussgl_Transaction_Code ap_invoices.ussgl_transaction_code%TYPE; - Bug 4277744

187: G_allow_account_override ap_system_parameters.allow_flex_override_flag%TYPE;
188: G_encumbrance_flag financials_system_parameters.purch_encumbrance_flag%TYPE;
189: G_match_option po_line_locations.match_option%TYPE;
190: G_approval_workflow_flag ap_system_parameters.approval_workflow_flag%TYPE;
191: --G_Ussgl_Transaction_Code ap_invoices.ussgl_transaction_code%TYPE; - Bug 4277744
192: G_login_id number;
193: G_User_id number;
194: G_Account_Segment ap_invoice_lines.account_segment%TYPE := NULL;
195: G_Balancing_Segment ap_invoice_lines.balancing_segment%TYPE := NULL;

Line 205: G_Award_Id ap_invoices.award_id%TYPE;

201: G_Line_Award_id ap_invoice_lines.award_id%TYPE;
202: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;
203: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;
204: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;
205: G_Award_Id ap_invoices.award_id%TYPE;
206: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;
207: G_Line_Awt_Group_Id ap_invoice_lines.awt_group_id%TYPE ;
208: G_Line_Accounting_Date ap_invoice_lines.accounting_date%TYPE;
209: G_Org_Id ap_invoices.org_id%TYPE;

Line 209: G_Org_Id ap_invoices.org_id%TYPE;

205: G_Award_Id ap_invoices.award_id%TYPE;
206: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;
207: G_Line_Awt_Group_Id ap_invoice_lines.awt_group_id%TYPE ;
208: G_Line_Accounting_Date ap_invoice_lines.accounting_date%TYPE;
209: G_Org_Id ap_invoices.org_id%TYPE;
210: G_Trx_Business_Category ap_invoices.trx_business_category%TYPE;
211:
212: --Contract Payments
213: G_Shipment_Type po_line_locations_all.shipment_type%TYPE;

Line 210: G_Trx_Business_Category ap_invoices.trx_business_category%TYPE;

206: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;
207: G_Line_Awt_Group_Id ap_invoice_lines.awt_group_id%TYPE ;
208: G_Line_Accounting_Date ap_invoice_lines.accounting_date%TYPE;
209: G_Org_Id ap_invoices.org_id%TYPE;
210: G_Trx_Business_Category ap_invoices.trx_business_category%TYPE;
211:
212: --Contract Payments
213: G_Shipment_Type po_line_locations_all.shipment_type%TYPE;
214: G_Vendor_Id ap_invoices.vendor_id%TYPE;

Line 214: G_Vendor_Id ap_invoices.vendor_id%TYPE;

210: G_Trx_Business_Category ap_invoices.trx_business_category%TYPE;
211:
212: --Contract Payments
213: G_Shipment_Type po_line_locations_all.shipment_type%TYPE;
214: G_Vendor_Id ap_invoices.vendor_id%TYPE;
215: G_Vendor_Site_Id ap_invoices.vendor_site_id%TYPE;
216: G_Po_Line_Id po_lines_all.po_line_id%TYPE;
217: G_Recoupment_Rate po_lines_all.recoupment_rate%TYPE;
218:

Line 215: G_Vendor_Site_Id ap_invoices.vendor_site_id%TYPE;

211:
212: --Contract Payments
213: G_Shipment_Type po_line_locations_all.shipment_type%TYPE;
214: G_Vendor_Id ap_invoices.vendor_id%TYPE;
215: G_Vendor_Site_Id ap_invoices.vendor_site_id%TYPE;
216: G_Po_Line_Id po_lines_all.po_line_id%TYPE;
217: G_Recoupment_Rate po_lines_all.recoupment_rate%TYPE;
218:
219: --Bugfix:5565310

Line 227: G_source ap_invoices_all.source%type;

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

Line 740: l_accounting_date ap_invoices_all.gl_date%TYPE;

736: X_Po_Line_Location_Id IN NUMBER,
737: X_Calling_Sequence IN VARCHAR2 ) IS
738:
739: current_calling_sequence VARCHAR2(2000);
740: l_accounting_date ap_invoices_all.gl_date%TYPE;
741: l_debug_info VARCHAR2(2000);
742: l_api_name VARCHAR2(32);
743: BEGIN
744:

Line 822: FROM ap_invoices_all ai ,

818: g_vendor_id,
819: g_vendor_site_id,
820: g_source
821: /* Bug 5572876, using base tables */
822: FROM ap_invoices_all ai ,
823: ap_system_parameters_all asp,
824: ap_suppliers pv,
825: ap_supplier_sites_all pvs,
826: financials_system_params_all fsp,

Line 4320: FROM ap_invoices ai,

4316: G_TRX_BUSINESS_CATEGORY, --trx_business_category
4317: AIL.PRODUCT_TYPE, --product_type
4318: AIL.PRODUCT_CATEGORY, --product_category
4319: AIL.USER_DEFINED_FISC_CLASS --user_defined_fisc_class
4320: FROM ap_invoices ai,
4321: ap_invoice_lines ail,
4322: po_line_locations_ap_v pll
4323: WHERE ai.invoice_id = x_corrected_invoice_id
4324: AND ail.invoice_id = ai.invoice_id