DBA Data[Home] [Help]

APPS.AP_INVOICE_CORRECTIONS_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 88: G_Set_of_Books_ID ap_system_parameters.set_of_books_id%TYPE;

84: G_max_invoice_line_number ap_invoice_lines.line_number%TYPE := 0;
85: G_batch_id ap_batches.batch_id%TYPE;
86: G_Accounting_Date ap_invoice_lines.accounting_date%TYPE;
87: G_Period_Name gl_period_statuses.period_name%TYPE;
88: G_Set_of_Books_ID ap_system_parameters.set_of_books_id%TYPE;
89: G_Awt_Group_ID ap_awt_groups.group_id%TYPE;
90: G_Exchange_Rate ap_invoices.exchange_rate%TYPE;
91: G_Precision fnd_currencies.precision%TYPE;
92: G_Min_Acct_Unit fnd_currencies.minimum_accountable_unit%TYPE;

Line 93: G_System_Allow_Awt_Flag ap_system_parameters.allow_awt_flag%TYPE;

89: G_Awt_Group_ID ap_awt_groups.group_id%TYPE;
90: G_Exchange_Rate ap_invoices.exchange_rate%TYPE;
91: G_Precision fnd_currencies.precision%TYPE;
92: G_Min_Acct_Unit fnd_currencies.minimum_accountable_unit%TYPE;
93: G_System_Allow_Awt_Flag ap_system_parameters.allow_awt_flag%TYPE;
94: G_Site_Allow_Awt_Flag po_vendor_sites.allow_awt_flag%TYPE;
95: G_Base_Currency_Code ap_system_parameters.base_currency_code%TYPE;
96: G_Invoice_Currency_Code ap_invoices.invoice_currency_code%TYPE;
97: G_Allow_PA_Override VARCHAR2(1);

Line 95: G_Base_Currency_Code ap_system_parameters.base_currency_code%TYPE;

91: G_Precision fnd_currencies.precision%TYPE;
92: G_Min_Acct_Unit fnd_currencies.minimum_accountable_unit%TYPE;
93: G_System_Allow_Awt_Flag ap_system_parameters.allow_awt_flag%TYPE;
94: G_Site_Allow_Awt_Flag po_vendor_sites.allow_awt_flag%TYPE;
95: G_Base_Currency_Code ap_system_parameters.base_currency_code%TYPE;
96: G_Invoice_Currency_Code ap_invoices.invoice_currency_code%TYPE;
97: G_Allow_PA_Override VARCHAR2(1);
98: G_Income_Tax_Region ap_system_parameters.income_tax_region%TYPE;
99: G_Approval_Workflow_Flag ap_system_parameters.approval_workflow_flag%TYPE;

Line 98: G_Income_Tax_Region ap_system_parameters.income_tax_region%TYPE;

94: G_Site_Allow_Awt_Flag po_vendor_sites.allow_awt_flag%TYPE;
95: G_Base_Currency_Code ap_system_parameters.base_currency_code%TYPE;
96: G_Invoice_Currency_Code ap_invoices.invoice_currency_code%TYPE;
97: G_Allow_PA_Override VARCHAR2(1);
98: G_Income_Tax_Region ap_system_parameters.income_tax_region%TYPE;
99: G_Approval_Workflow_Flag ap_system_parameters.approval_workflow_flag%TYPE;
100: -- Removed for bug 4277744
101: -- G_Ussgl_Transaction_Code ap_invoices.ussgl_transaction_code%TYPE;
102: G_Type_1099 po_vendors.type_1099%TYPE;

Line 99: G_Approval_Workflow_Flag ap_system_parameters.approval_workflow_flag%TYPE;

95: G_Base_Currency_Code ap_system_parameters.base_currency_code%TYPE;
96: G_Invoice_Currency_Code ap_invoices.invoice_currency_code%TYPE;
97: G_Allow_PA_Override VARCHAR2(1);
98: G_Income_Tax_Region ap_system_parameters.income_tax_region%TYPE;
99: G_Approval_Workflow_Flag ap_system_parameters.approval_workflow_flag%TYPE;
100: -- Removed for bug 4277744
101: -- G_Ussgl_Transaction_Code ap_invoices.ussgl_transaction_code%TYPE;
102: G_Type_1099 po_vendors.type_1099%TYPE;
103: G_User_Id number;

Line 337: ap_system_parameters asp,

333: -- g_ussgl_transaction_code, - Bug 4277744
334: g_trx_business_category,
335: g_org_id
336: FROM ap_invoices_all ai ,
337: ap_system_parameters asp,
338: ap_suppliers pv,
339: ap_supplier_sites_all pvs,
340: fnd_currencies fc -- bug 5052493
341: WHERE ai.invoice_id = x_invoice_id