DBA Data[Home] [Help]

APPS.AP_PO_AMT_MATCH_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 136: G_Set_of_Books_ID ap_system_parameters.set_of_books_id%TYPE;

132: G_Max_Invoice_Line_Number ap_invoice_lines.line_number%TYPE := 0;
133: G_Batch_id ap_batches.batch_id%TYPE;
134: G_Accounting_Date ap_invoice_lines.accounting_date%TYPE;
135: G_Period_Name gl_period_statuses.period_name%TYPE;
136: G_Set_of_Books_ID ap_system_parameters.set_of_books_id%TYPE;
137: G_Awt_Group_ID ap_awt_groups.group_id%TYPE;
138: G_Invoice_Type_Lookup_Code ap_invoices.invoice_type_lookup_code%TYPE;
139: G_Exchange_Rate ap_invoices.exchange_rate%TYPE;
140: G_Precision fnd_currencies.precision%TYPE;

Line 142: G_System_Allow_Awt_Flag ap_system_parameters.allow_awt_flag%TYPE;

138: G_Invoice_Type_Lookup_Code ap_invoices.invoice_type_lookup_code%TYPE;
139: G_Exchange_Rate ap_invoices.exchange_rate%TYPE;
140: G_Precision fnd_currencies.precision%TYPE;
141: G_Min_Acct_Unit fnd_currencies.minimum_accountable_unit%TYPE;
142: G_System_Allow_Awt_Flag ap_system_parameters.allow_awt_flag%TYPE;
143: G_Site_Allow_Awt_Flag po_vendor_sites.allow_awt_flag%TYPE;
144: G_Transfer_Flag ap_system_parameters.transfer_desc_flex_flag%TYPE;
145: G_Base_Currency_Code ap_system_parameters.base_currency_code%TYPE;
146: G_Invoice_Currency_Code ap_invoices.invoice_currency_code%TYPE;

Line 144: G_Transfer_Flag ap_system_parameters.transfer_desc_flex_flag%TYPE;

140: G_Precision fnd_currencies.precision%TYPE;
141: G_Min_Acct_Unit fnd_currencies.minimum_accountable_unit%TYPE;
142: G_System_Allow_Awt_Flag ap_system_parameters.allow_awt_flag%TYPE;
143: G_Site_Allow_Awt_Flag po_vendor_sites.allow_awt_flag%TYPE;
144: G_Transfer_Flag ap_system_parameters.transfer_desc_flex_flag%TYPE;
145: G_Base_Currency_Code ap_system_parameters.base_currency_code%TYPE;
146: G_Invoice_Currency_Code ap_invoices.invoice_currency_code%TYPE;
147: G_Allow_PA_Override varchar2(1);
148: G_Pa_Expenditure_Date_Default varchar2(50);

Line 145: G_Base_Currency_Code ap_system_parameters.base_currency_code%TYPE;

141: G_Min_Acct_Unit fnd_currencies.minimum_accountable_unit%TYPE;
142: G_System_Allow_Awt_Flag ap_system_parameters.allow_awt_flag%TYPE;
143: G_Site_Allow_Awt_Flag po_vendor_sites.allow_awt_flag%TYPE;
144: G_Transfer_Flag ap_system_parameters.transfer_desc_flex_flag%TYPE;
145: G_Base_Currency_Code ap_system_parameters.base_currency_code%TYPE;
146: G_Invoice_Currency_Code ap_invoices.invoice_currency_code%TYPE;
147: G_Allow_PA_Override varchar2(1);
148: G_Pa_Expenditure_Date_Default varchar2(50);
149: G_Prepay_CCID ap_system_parameters.prepay_code_combination_id%TYPE;

Line 149: G_Prepay_CCID ap_system_parameters.prepay_code_combination_id%TYPE;

145: G_Base_Currency_Code ap_system_parameters.base_currency_code%TYPE;
146: G_Invoice_Currency_Code ap_invoices.invoice_currency_code%TYPE;
147: G_Allow_PA_Override varchar2(1);
148: G_Pa_Expenditure_Date_Default varchar2(50);
149: G_Prepay_CCID ap_system_parameters.prepay_code_combination_id%TYPE;
150: G_Build_Prepay_Accts_Flag ap_system_parameters.build_prepayment_accounts_flag%TYPE;
151: G_Income_Tax_Region ap_system_parameters.income_tax_region%TYPE;
152: G_Project_ID pa_projects_all.project_id%TYPE;
153: G_Task_ID pa_tasks.task_id%TYPE;

Line 150: G_Build_Prepay_Accts_Flag ap_system_parameters.build_prepayment_accounts_flag%TYPE;

146: G_Invoice_Currency_Code ap_invoices.invoice_currency_code%TYPE;
147: G_Allow_PA_Override varchar2(1);
148: G_Pa_Expenditure_Date_Default varchar2(50);
149: G_Prepay_CCID ap_system_parameters.prepay_code_combination_id%TYPE;
150: G_Build_Prepay_Accts_Flag ap_system_parameters.build_prepayment_accounts_flag%TYPE;
151: G_Income_Tax_Region ap_system_parameters.income_tax_region%TYPE;
152: G_Project_ID pa_projects_all.project_id%TYPE;
153: G_Task_ID pa_tasks.task_id%TYPE;
154: G_Expenditure_Type pa_expenditure_types.expenditure_type%TYPE;

Line 151: G_Income_Tax_Region ap_system_parameters.income_tax_region%TYPE;

147: G_Allow_PA_Override varchar2(1);
148: G_Pa_Expenditure_Date_Default varchar2(50);
149: G_Prepay_CCID ap_system_parameters.prepay_code_combination_id%TYPE;
150: G_Build_Prepay_Accts_Flag ap_system_parameters.build_prepayment_accounts_flag%TYPE;
151: G_Income_Tax_Region ap_system_parameters.income_tax_region%TYPE;
152: G_Project_ID pa_projects_all.project_id%TYPE;
153: G_Task_ID pa_tasks.task_id%TYPE;
154: G_Expenditure_Type pa_expenditure_types.expenditure_type%TYPE;
155: G_Invoice_Date ap_invoices.invoice_date%TYPE;

Line 160: G_Approval_Workflow_Flag ap_system_parameters.approval_workflow_flag%TYPE;

156: G_Expenditure_Organization_ID pa_exp_orgs_it.organization_id%TYPE;
157: G_Asset_Book_Type_Code fa_book_controls.book_type_code%TYPE;
158: G_Asset_Category_Id mtl_system_items.asset_category_id%TYPE;
159: G_Inventory_Organization_Id financials_system_parameters.inventory_organization_id%TYPE;
160: G_Approval_Workflow_Flag ap_system_parameters.approval_workflow_flag%TYPE;
161: -- Removed for bug 4277744
162: -- G_Ussgl_Transaction_Code ap_invoices.ussgl_transaction_code%TYPE;
163: G_Allow_Flex_Override_Flag ap_system_parameters.allow_flex_override_flag%TYPE;
164: G_Shipment_Type po_line_locations.shipment_type%TYPE;

Line 163: G_Allow_Flex_Override_Flag ap_system_parameters.allow_flex_override_flag%TYPE;

159: G_Inventory_Organization_Id financials_system_parameters.inventory_organization_id%TYPE;
160: G_Approval_Workflow_Flag ap_system_parameters.approval_workflow_flag%TYPE;
161: -- Removed for bug 4277744
162: -- G_Ussgl_Transaction_Code ap_invoices.ussgl_transaction_code%TYPE;
163: G_Allow_Flex_Override_Flag ap_system_parameters.allow_flex_override_flag%TYPE;
164: G_Shipment_Type po_line_locations.shipment_type%TYPE;
165: G_Org_id ap_invoices.org_id%TYPE;
166: G_Encumbrance_Flag financials_system_parameters.purch_encumbrance_flag%TYPE;
167: G_User_Id number;

Line 720: ap_system_parameters_all asp,

716: g_source,
717: g_recurring_payment_id -- Bug 7305223
718: /* Bug 5572876, using base tables */
719: FROM ap_invoices_all ai ,
720: ap_system_parameters_all asp,
721: ap_suppliers pv,
722: ap_supplier_sites_all pvs,
723: financials_system_params_all fsp,
724: fnd_currencies fc