DBA Data[Home] [Help]

APPS.AP_INVOICE_CORRECTIONS_PKG dependencies on AP_INVOICES

Line 90: G_Exchange_Rate ap_invoices.exchange_rate%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;
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;

Line 96: G_Invoice_Currency_Code ap_invoices.invoice_currency_code%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;
100: -- Removed for bug 4277744

Line 101: -- G_Ussgl_Transaction_Code ap_invoices.ussgl_transaction_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;
104: G_Login_Id number;
105: G_Trx_Business_Category ap_invoices.trx_business_category%TYPE;

Line 105: G_Trx_Business_Category ap_invoices.trx_business_category%TYPE;

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;
104: G_Login_Id number;
105: G_Trx_Business_Category ap_invoices.trx_business_category%TYPE;
106: G_Org_Id ap_invoices_all.org_id%TYPE;
107:
108:
109: PROCEDURE Invoice_Correction(

Line 106: G_Org_Id ap_invoices_all.org_id%TYPE;

102: G_Type_1099 po_vendors.type_1099%TYPE;
103: G_User_Id number;
104: G_Login_Id number;
105: G_Trx_Business_Category ap_invoices.trx_business_category%TYPE;
106: G_Org_Id ap_invoices_all.org_id%TYPE;
107:
108:
109: PROCEDURE Invoice_Correction(
110: X_Invoice_Id IN NUMBER,

Line 336: FROM ap_invoices_all ai ,

332: g_approval_workflow_flag,
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

Line 449: ap_invoices ai

445: round (((x_correction_amount * ail.amount/p_line_proration_total)/
446: g_min_acct_unit) * g_min_acct_unit)
447: )
448: FROM ap_invoice_lines ail,
449: ap_invoices ai
450: WHERE ai.invoice_id = x_corrected_invoice_id
451: AND ail.invoice_id = ai.invoice_id
452: --Modified below condition for bug#10410133
453: --from " = 'ITEM' to in ('ITEM','FREIGHT','MISCELLANEOUS') "

Line 1311: FROM ap_invoices ai,

1307: AIL.PRODUCT_CATEGORY, --product_category
1308: AIL.USER_DEFINED_FISC_CLASS, --user_defined_fisc_class
1309: AIL.PURCHASING_CATEGORY_ID, --purchasing_category_id
1310: AIL.PAY_AWT_GROUP_ID --pay_awt_group_id --bug13793337
1311: FROM ap_invoices ai,
1312: ap_invoice_lines ail
1313: WHERE ai.invoice_id = ail.invoice_id
1314: AND ai.invoice_id = x_corrected_invoice_id
1315: AND ail.line_number = x_corrected_line_number;