DBA Data[Home] [Help]

APPS.AP_MATCHING_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_Base_Currency_Code ap_system_parameters.base_currency_code%TYPE;
174: G_Invoice_Currency_Code ap_invoices.invoice_currency_code%TYPE;

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_Base_Currency_Code ap_system_parameters.base_currency_code%TYPE;
174: G_Invoice_Currency_Code ap_invoices.invoice_currency_code%TYPE;
175: G_Allow_PA_Override varchar2(1);
176: G_Pa_Expenditure_Date_Default varchar2(50);

Line 173: G_Base_Currency_Code ap_system_parameters.base_currency_code%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_Base_Currency_Code ap_system_parameters.base_currency_code%TYPE;
174: G_Invoice_Currency_Code ap_invoices.invoice_currency_code%TYPE;
175: G_Allow_PA_Override varchar2(1);
176: G_Pa_Expenditure_Date_Default varchar2(50);
177: G_Prepay_CCID ap_system_parameters.prepay_code_combination_id%TYPE;

Line 177: G_Prepay_CCID ap_system_parameters.prepay_code_combination_id%TYPE;

173: G_Base_Currency_Code ap_system_parameters.base_currency_code%TYPE;
174: G_Invoice_Currency_Code ap_invoices.invoice_currency_code%TYPE;
175: G_Allow_PA_Override varchar2(1);
176: G_Pa_Expenditure_Date_Default varchar2(50);
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_Invoice_Currency_Code ap_invoices.invoice_currency_code%TYPE;
175: G_Allow_PA_Override varchar2(1);
176: G_Pa_Expenditure_Date_Default varchar2(50);
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_Award_ID po_distributions_all.award_id%TYPE;

Line 179: G_Income_Tax_Region ap_system_parameters.income_tax_region%TYPE;

175: G_Allow_PA_Override varchar2(1);
176: G_Pa_Expenditure_Date_Default varchar2(50);
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_Award_ID po_distributions_all.award_id%TYPE;
183: G_Expenditure_Type pa_expenditure_types.expenditure_type%TYPE;

Line 189: G_Approval_Workflow_Flag ap_system_parameters.approval_workflow_flag%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_Asset_Category_Id mtl_system_items.asset_category_id%TYPE;
188: G_Inventory_Organization_Id financials_system_parameters.inventory_organization_id%TYPE;
189: G_Approval_Workflow_Flag ap_system_parameters.approval_workflow_flag%TYPE;
190: -- Removed for bug 4277744
191: -- G_Ussgl_Transaction_Code ap_invoices.ussgl_transaction_code%TYPE;
192: G_Allow_Flex_Override_Flag ap_system_parameters.allow_flex_override_flag%TYPE;
193: G_Shipment_Type po_line_locations.shipment_type%TYPE;

Line 192: G_Allow_Flex_Override_Flag ap_system_parameters.allow_flex_override_flag%TYPE;

188: G_Inventory_Organization_Id financials_system_parameters.inventory_organization_id%TYPE;
189: G_Approval_Workflow_Flag ap_system_parameters.approval_workflow_flag%TYPE;
190: -- Removed for bug 4277744
191: -- G_Ussgl_Transaction_Code ap_invoices.ussgl_transaction_code%TYPE;
192: G_Allow_Flex_Override_Flag ap_system_parameters.allow_flex_override_flag%TYPE;
193: G_Shipment_Type po_line_locations.shipment_type%TYPE;
194: G_Org_id ap_invoices.org_id%TYPE;
195: G_Encumbrance_Flag financials_system_parameters.purch_encumbrance_flag%TYPE;
196: G_User_Id number;

Line 903: ap_system_parameters_all asp,

899: g_recurring_payment_id, -- Bug 7305223
900: /* Bug 5572876, using base tables */
901: g_pay_awt_group_id -- bug 8222382
902: FROM ap_invoices_all ai ,
903: ap_system_parameters_all asp,
904: ap_suppliers pv,
905: ap_supplier_sites_all pvs,
906: financials_system_params_all fsp,
907: fnd_currencies fc

Line 6489: l_primary_sob_id AP_SYSTEM_PARAMETERS.set_of_books_id%TYPE;

6485: l_num_of_segments NUMBER ;
6486: l_result BOOLEAN ;
6487: l_curr_calling_sequence VARCHAR2(2000);
6488: G_flex_qualifier_name VARCHAR2(100);
6489: l_primary_sob_id AP_SYSTEM_PARAMETERS.set_of_books_id%TYPE;
6490: l_liability_post_lookup_code AP_SYSTEM_PARAMETERS.liability_post_lookup_code%TYPE;
6491: l_chart_of_accts_id GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;
6492: G_flex_segment_num NUMBER;
6493: l_api_name CONSTANT VARCHAR2(200) := 'Build_Prepay_Account';

Line 6490: l_liability_post_lookup_code AP_SYSTEM_PARAMETERS.liability_post_lookup_code%TYPE;

6486: l_result BOOLEAN ;
6487: l_curr_calling_sequence VARCHAR2(2000);
6488: G_flex_qualifier_name VARCHAR2(100);
6489: l_primary_sob_id AP_SYSTEM_PARAMETERS.set_of_books_id%TYPE;
6490: l_liability_post_lookup_code AP_SYSTEM_PARAMETERS.liability_post_lookup_code%TYPE;
6491: l_chart_of_accts_id GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;
6492: G_flex_segment_num NUMBER;
6493: l_api_name CONSTANT VARCHAR2(200) := 'Build_Prepay_Account';
6494: l_debug_info VARCHAR2(2000);

Line 6508: FROM ap_system_parameters;

6504:
6505:
6506: SELECT set_of_books_id
6507: INTO l_primary_sob_id
6508: FROM ap_system_parameters;
6509:
6510: SELECT chart_of_accounts_id
6511: INTO l_chart_of_accts_id
6512: FROM gl_sets_of_books