Search Results set_item_property

Overview

FND_CURRENCY_CACHE is an Oracle E-Business Suite foundation package owned by APPS and classified as an OTHER API. Its primary purpose is to provide cached currency information to Forms and PL/SQL code so that monetary values are displayed and formatted consistently across the application. Rather than querying currency precision and formatting attributes repeatedly, the package maintains an in-memory cache of currency definitions sourced from the FND_CURRENCIES table.

The package exists chiefly to support currency-aware display logic. The header comment for GET_FORMAT_MASK is explicit: the returned mask is intended for use with the Forms built-in call SET_ITEM_PROPERTY(item_name, FORMAT_MASK, FND_CURRENCY.GET_FORMAT_MASK(...)), or with the PL/SQL to_char() routine. This directly answers the "set_item_property" search — the package is the canonical provider of dynamic currency format masks for Forms items.

The header revision (AFMLCUCS.pls 120.2, dated 2005/11/02) confirms the package is mature and stable across the 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

Three documented routines are exposed:

• GET_FORMAT_MASK — A function returning a format mask string for a given currency code and target field length. The mask is passed directly to SET_ITEM_PROPERTY or used with to_char().
• GET_INFO — A procedure returning currency precision metadata: the standard precision (digits to the right of the decimal), extended precision (used where greater accuracy is required, such as accounting calculations), and the minimum account unit (the smallest increment by which a monetary amount may vary). Values are served from the cache of currency information sourced from FND database tables.
• BUILD_FORMAT_MASK — A procedure that constructs a currency format mask from supplied parameters (field length, precision, minimum account unit, and optional display group separator and negative/positive format strings) rather than from a currency code alone. It too is intended for SET_ITEM_PROPERTY and to_char() consumption. Documented constraints require that a negative format of '-XXX' be paired with a positive format of '+XXX' or 'XXX'. The trailing parameters default from profile option values when omitted — notably the CURRENCY:THOUSANDS_SEPARATOR profile governs the display group separator when NULL is passed.

Tables Accessed

The package reads FND_CURRENCIES via its APPS synonym. That table is the authoritative source of currency codes, precision attributes, and format characteristics. FND_CURRENCY_CACHE caches this information to avoid repeated round-trips during interactive Forms sessions, and GET_INFO explicitly documents that it returns data "based on the cache of currency information from the FND db table." No writes are documented; the package is read-only with respect to FND_CURRENCIES.

Usage Notes

Typical invocation is from Oracle Forms triggers — most commonly POST-QUERY or WHEN-NEW-ITEM-INSTANCE — where the developer calls GET_FORMAT_MASK and applies the result through SET_ITEM_PROPERTY(item, FORMAT_MASK, mask) so that a currency field renders with the correct symbol, decimal precision, and separators for the currency of the underlying record. BUILD_FORMAT_MASK serves cases where precision and minimum account unit are already known and no currency-code lookup is needed. GET_INFO is used in validation and rounding logic where extended precision or minimum account unit values are required. The package is also referenced by 19 other packages, confirming it is a shared foundation utility behind higher-level currency and accounting APIs. Custom code should call these routines rather than re-deriving masks from FND_CURRENCIES directly, ensuring consistent formatting behavior.