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_Pay_Awt_Group_ID ap_awt_groups.group_id%TYPE; --bug 9689194
139: G_Invoice_Type_Lookup_Code ap_invoices.invoice_type_lookup_code%TYPE;
140: G_Exchange_Rate ap_invoices.exchange_rate%TYPE;

Line 143: G_System_Allow_Awt_Flag ap_system_parameters.allow_awt_flag%TYPE;

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

Line 145: G_Transfer_Flag ap_system_parameters.transfer_desc_flex_flag%TYPE;

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

Line 146: G_Base_Currency_Code ap_system_parameters.base_currency_code%TYPE;

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

Line 150: G_Prepay_CCID ap_system_parameters.prepay_code_combination_id%TYPE;

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

Line 151: G_Build_Prepay_Accts_Flag ap_system_parameters.build_prepayment_accounts_flag%TYPE;

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

Line 152: G_Income_Tax_Region ap_system_parameters.income_tax_region%TYPE;

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

Line 161: G_Approval_Workflow_Flag ap_system_parameters.approval_workflow_flag%TYPE;

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

Line 164: G_Allow_Flex_Override_Flag ap_system_parameters.allow_flex_override_flag%TYPE;

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

Line 811: ap_system_parameters_all asp,

807: g_recurring_payment_id, -- Bug 7305223
808: g_pay_awt_group_id --Bug 9689194
809: /* Bug 5572876, using base tables */
810: FROM ap_invoices_all ai ,
811: ap_system_parameters_all asp,
812: ap_suppliers pv,
813: ap_supplier_sites_all pvs,
814: financials_system_params_all fsp,
815: fnd_currencies fc