Search Results get_converted_amount

Overview

FEM_DIS_UTL_PKG is a utility package owned by the APPS schema within the Oracle E-Business Suite Enterprise Tax and Reporting/Enterprise Data Management (ETRM) product family. Its name follows the FEM prefix convention, which identifies objects belonging to the Application Data Model (ADM) and data integration layer rather than the core General Ledger ledger engine. The package encapsulates a collection of reusable helper routines that support higher-level ETRM features such as dimension browsing, period mapping, currency conversion, and diagnostic tracing. Under ETRM 12.1.1 the package is classified as an API of type OTHER, indicating it is an internal support package rather than a published, externally callable interface. It is documented as VALID and, according to the provided dependency information, it has no downstream package references, meaning no other PL/SQL packages in the APPS schema depend on it. Its own dependencies are limited to the SYS.STANDARD package, confirming that it is effectively a leaf-level utility with no reliance on other application code.

Key Procedures and Functions

Five documented program units make up the public surface of this package. Their purposes are as follows:

• VISUAL_TRACE_URL — Generates a diagnostic trace URL used for debugging and runtime investigation. It supports the visualization and tracing facilities used to inspect ETRM processing behavior.
• GET_EXCHANGE_RATE — Retrieves the applicable exchange rate between currencies for a given context, supplying rate information needed when ETRM data is presented or converted across currencies.
• GET_CONVERTED_AMOUNT — Applies a determined exchange rate to produce a converted monetary amount. It is the consumer-facing counterpart to the rate retrieval routine.
• GET_DIM_ATTRIBUTE_VALUE — Resolves the value of a specified attribute belonging to a dimension, allowing callers to obtain dimension attribute metadata or values without directly querying the underlying attribute tables.
• GET_RELATIVE_CAL_PERIOD_NAME — Derives a calendar period name relative to a supplied reference period, facilitating period-shifting logic used in reporting and data integration.

The metadata does not publish parameter lists for these routines, and their exact signatures should be confirmed against the package specification in the target environment before use.

Tables Accessed

The package reads from four documented tables, accessed through APPS synonyms:

• FEM_CAL_PERIODS_ATTR — Stores calendar period attribute definitions; used to support relative period name resolution.
• FEM_DIM_ATTRIBUTES_B — The base table defining dimension attributes; queried when resolving dimension attribute values.
• FEM_DIM_ATTR_VERSIONS_B — Holds versioned dimension attribute definitions; consulted to obtain version-specific attribute data.
• FND_FORM_FUNCTIONS — The standard Oracle Forms function registry; referenced in support of the diagnostic tracing and URL-generation logic.

No insert, update, or delete operations are documented, suggesting the package is primarily read-only in its data access.

Usage Notes

Because FEM_DIS_UTL_PKG is classified as an internal utility with no dependent packages, it is not intended as a general-purpose integration API. It is most likely invoked by ETRM forms, concurrent programs, and internal ETRM processing code that require currency conversion, period name resolution, dimension attribute lookups, or trace URL construction. Customizations should treat the package as unsupported internals; where identical behavior is needed, developers are advised to use the officially published ETRM APIs and views instead. Any direct call should be preceded by inspection of the deployed package specification, since documented metadata does not include parameter definitions. The lack of downstream dependencies also means the package can generally be validated or recompiled independently of other ETRM PL/SQL units.