Search Results get_info

Overview

APPS.ICX_CAT_UTIL_PKG is a utility package body in the Oracle E-Business Suite Internet Commerce Exchange (iProcurement/ICX) schema. Its documented purpose is to centralize currency-related helper logic used by the iProcurement catalog and shopping modules. The package, whose header comment identifies it as ICXCUTLB.pls (115.2), provides two principal utilities: a private procedure, get_info, that retrieves a currency's minimum accountable unit (MAU), and a public function, convert_amount_sql, that converts a monetary amount from one currency to another using Oracle General Ledger exchange rates. By encapsulating these operations, the package ensures consistent rounding and currency handling across catalog pricing, requisition display, and cross-currency shopping scenarios in EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The ETRM metadata documents the following program units:

• get_info — A procedure that accepts a currency code and returns its minimum accountable unit as an IN OUT NOCOPY NUMBER parameter. It queries FND_CURRENCIES and, when no explicit MAU is defined, derives the value using the expression power(10, (-1 * extended_precision)). If the currency code does not exist, it raises the custom exception INVALID_CURRENCY. Though not listed as publicly documented in the metadata, this procedure is called internally by convert_amount_sql and is frequently the object users locate when searching for "get_info."
• convert_amount_sql — The primary documented function. It converts an amount between a source and target currency using a specified conversion date and, optionally, a conversion rate type. When the source currency equals the target currency or the source is null, the original amount is returned unchanged. When no conversion type is supplied, the function retrieves the default rate type from the purchasing system parameters. It then fetches the target currency's MAU via get_info, applies the GL exchange rate, and rounds the result to the MAU before returning it. If no rate exists, the function's exception handler returns null.

Tables Accessed

The package reads from the following tables through APPS synonyms:

• FND_CURRENCIES — The Oracle Application Object Library currency definition table. It supplies the minimum_accountable_unit and extended_precision values used to compute MAU and to round converted amounts correctly.
• PO_SYSTEM_PARAMETERS — The Purchasing application setup table. It is queried for default_rate_type when the caller does not provide an explicit conversion rate type. A local exception handler defaults this value to null if the select fails, preserving function execution.

Usage Notes

ICX_CAT_UTIL_PKG is most commonly invoked from iProcurement catalog and shopping form logic, and from custom or extension code that must display monetary values in a user's preferred currency. The convert_amount_sql function is typically called when prices must be restated from a supplier or base currency into the session currency. The get_info procedure supports this by supplying the rounding increment. The ETRM metadata records no other packages referencing this package (referenced by 0 other packages), indicating its role as a leaf-level utility rather than a shared framework component. Because exchange-rate lookups rely on gl_currency_api.get_rate, callers should ensure that rates and rate types are defined for the required date, and should anticipate a null return when the GL currency API raises NO_RATE. Applications must also handle the INVALID_CURRENCY exception when an unrecognized currency code is passed to get_info.