eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 443: ap_invoices ai

439: round (((x_correction_amount * ail.amount/p_line_proration_total)/
440: g_min_acct_unit) * g_min_acct_unit)
441: )
442: FROM ap_invoice_lines ail,
443: ap_invoices ai
444: WHERE ai.invoice_id = x_corrected_invoice_id
445: AND ail.invoice_id = ai.invoice_id
446: AND ail.line_type_lookup_code = 'ITEM'; -- Bug 5597409, restricting for Item line only
447:

Line 1279: FROM ap_invoices ai,

1275: AIL.PRODUCT_TYPE, --product_type
1276: AIL.PRODUCT_CATEGORY, --product_category
1277: AIL.USER_DEFINED_FISC_CLASS, --user_defined_fisc_class
1278: AIL.PURCHASING_CATEGORY_ID --purchasing_category_id
1279: FROM ap_invoices ai,
1280: ap_invoice_lines ail
1281: WHERE ai.invoice_id = ail.invoice_id
1282: AND ai.invoice_id = x_corrected_invoice_id
1283: AND ail.line_number = x_corrected_line_number;