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_pay_awt_group_id ap_awt_groups.group_id%TYPE; --bug 9689194
167: G_invoice_type_lookup_code ap_invoices.invoice_type_lookup_code%TYPE;
168: G_exchange_rate ap_invoices.exchange_rate%TYPE;

Line 171: G_system_allow_awt_flag ap_system_parameters.allow_awt_flag%TYPE;

167: G_invoice_type_lookup_code ap_invoices.invoice_type_lookup_code%TYPE;
168: G_exchange_rate ap_invoices.exchange_rate%TYPE;
169: G_precision fnd_currencies.precision%TYPE;
170: G_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;
171: G_system_allow_awt_flag ap_system_parameters.allow_awt_flag%TYPE;
172: G_site_allow_awt_flag po_vendor_sites.allow_awt_flag%TYPE;
173: G_transfer_flag ap_system_parameters.transfer_desc_flex_flag%TYPE;
174: G_allow_pa_override varchar2(1);
175: G_pa_expenditure_date_default varchar2(50);

Line 173: G_transfer_flag ap_system_parameters.transfer_desc_flex_flag%TYPE;

169: G_precision fnd_currencies.precision%TYPE;
170: G_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;
171: G_system_allow_awt_flag ap_system_parameters.allow_awt_flag%TYPE;
172: G_site_allow_awt_flag po_vendor_sites.allow_awt_flag%TYPE;
173: G_transfer_flag ap_system_parameters.transfer_desc_flex_flag%TYPE;
174: G_allow_pa_override varchar2(1);
175: G_pa_expenditure_date_default varchar2(50);
176: G_base_currency_code ap_system_parameters.base_currency_code%TYPE;
177: G_invoice_currency_code ap_invoices.invoice_currency_code%TYPE;

Line 176: G_base_currency_code ap_system_parameters.base_currency_code%TYPE;

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

Line 178: G_prepay_ccid ap_system_parameters.prepay_code_combination_id%TYPE;

174: G_allow_pa_override varchar2(1);
175: G_pa_expenditure_date_default varchar2(50);
176: G_base_currency_code ap_system_parameters.base_currency_code%TYPE;
177: G_invoice_currency_code ap_invoices.invoice_currency_code%TYPE;
178: G_prepay_ccid ap_system_parameters.prepay_code_combination_id%TYPE;
179: G_Build_Prepay_Accts_Flag ap_system_parameters.build_prepayment_accounts_flag%TYPE;
180: G_income_tax_region ap_system_parameters.income_tax_region%TYPE;
181: G_project_id pa_projects_all.project_id%TYPE;
182: G_task_id pa_tasks.task_id%TYPE;

Line 179: G_Build_Prepay_Accts_Flag ap_system_parameters.build_prepayment_accounts_flag%TYPE;

175: G_pa_expenditure_date_default varchar2(50);
176: G_base_currency_code ap_system_parameters.base_currency_code%TYPE;
177: G_invoice_currency_code ap_invoices.invoice_currency_code%TYPE;
178: G_prepay_ccid ap_system_parameters.prepay_code_combination_id%TYPE;
179: G_Build_Prepay_Accts_Flag ap_system_parameters.build_prepayment_accounts_flag%TYPE;
180: G_income_tax_region ap_system_parameters.income_tax_region%TYPE;
181: G_project_id pa_projects_all.project_id%TYPE;
182: G_task_id pa_tasks.task_id%TYPE;
183: G_expenditure_type pa_expenditure_types.expenditure_type%TYPE;

Line 180: G_income_tax_region ap_system_parameters.income_tax_region%TYPE;

176: G_base_currency_code ap_system_parameters.base_currency_code%TYPE;
177: G_invoice_currency_code ap_invoices.invoice_currency_code%TYPE;
178: G_prepay_ccid ap_system_parameters.prepay_code_combination_id%TYPE;
179: G_Build_Prepay_Accts_Flag ap_system_parameters.build_prepayment_accounts_flag%TYPE;
180: G_income_tax_region ap_system_parameters.income_tax_region%TYPE;
181: G_project_id pa_projects_all.project_id%TYPE;
182: G_task_id pa_tasks.task_id%TYPE;
183: G_expenditure_type pa_expenditure_types.expenditure_type%TYPE;
184: G_invoice_date ap_invoices.invoice_date%TYPE;

Line 188: G_allow_account_override ap_system_parameters.allow_flex_override_flag%TYPE;

184: G_invoice_date ap_invoices.invoice_date%TYPE;
185: G_expenditure_organization_id pa_exp_orgs_it.organization_id%TYPE;
186: G_asset_book_type_code fa_book_controls.book_type_code%TYPE;
187: G_inventory_organization_id financials_system_parameters.inventory_organization_id%TYPE;
188: G_allow_account_override ap_system_parameters.allow_flex_override_flag%TYPE;
189: G_encumbrance_flag financials_system_parameters.purch_encumbrance_flag%TYPE;
190: G_match_option po_line_locations.match_option%TYPE;
191: G_approval_workflow_flag ap_system_parameters.approval_workflow_flag%TYPE;
192: --G_Ussgl_Transaction_Code ap_invoices.ussgl_transaction_code%TYPE; - Bug 4277744

Line 191: G_approval_workflow_flag ap_system_parameters.approval_workflow_flag%TYPE;

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

Line 914: ap_system_parameters_all asp,

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