DBA Data[Home] [Help]

APPS.AP_RECT_MATCH_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 164: G_set_of_books_id ap_system_parameters.set_of_books_id%TYPE;

160: G_max_invoice_line_number ap_invoice_lines.line_number%TYPE := 0 ;
161: G_batch_id ap_batches.batch_id%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;

Line 170: G_system_allow_awt_flag ap_system_parameters.allow_awt_flag%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;
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);

Line 172: G_transfer_flag ap_system_parameters.transfer_desc_flex_flag%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;
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;

Line 175: G_base_currency_code ap_system_parameters.base_currency_code%TYPE;

171: G_site_allow_awt_flag po_vendor_sites.allow_awt_flag%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;

Line 177: G_prepay_ccid ap_system_parameters.prepay_code_combination_id%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;
181: G_task_id pa_tasks.task_id%TYPE;

Line 178: G_Build_Prepay_Accts_Flag ap_system_parameters.build_prepayment_accounts_flag%TYPE;

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;
181: G_task_id pa_tasks.task_id%TYPE;
182: G_expenditure_type pa_expenditure_types.expenditure_type%TYPE;

Line 179: G_income_tax_region ap_system_parameters.income_tax_region%TYPE;

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;
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;

Line 187: G_allow_account_override ap_system_parameters.allow_flex_override_flag%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;
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

Line 190: G_approval_workflow_flag ap_system_parameters.approval_workflow_flag%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;
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;

Line 823: ap_system_parameters_all asp,

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,
827: fnd_currencies fc