Search Results calculate_functional_currency

Overview

OZF_UTILITY_PVT_W is a public PL/SQL wrapper package in the Oracle EBS APPS schema that exposes a set of shared utility services used by the Oracle Trade Management (OZF) product family. The "_W" suffix indicates that the package is a generated Rosetta wrapper: it provides strongly-referenced, procedure-based interfaces that adapt Oracle's internal PL/SQL collection types to the JTF_NUMBER_TABLE and JTF_VARCHAR2_TABLE_100/300 types required for cross-language (Java/.NET) integration through the Rosetta/BPEL infrastructure. In the 12.1.1 and 12.2.2 releases the package is owned by APPS and classified as OTHER, meaning it is neither a formal public API nor an internal-only private package; it is a support module whose callers are expected to be other OZF packages or custom extensions. Its scope spans operating-unit resolution, dependent-object handling, diagnostic logging, currency conversion, and timezone conversion — the common infrastructure operations needed whenever Trade Management records such as claims, accruals, offers, and budgets are created or displayed.

Key Procedures and Functions

The documented interface contains thirteen procedures and functions. The four ROSETTA_TABLE_COPY_IN/OUT procedures (P12 for OPERATING_UNITS_TBL and P59 for DEPENDENT_OBJECTS_TBL_TYPE) perform bidirectional marshalling between the PL/SQL table types defined in OZF_UTILITY_PVT and the JTF_NUMBER_TABLE / JTF_VARCHAR2_TABLE collections used by the wrapper layer.

• LOG_MESSAGE — writes a diagnostic message at a caller-supplied level, tagged with a module name, RCS identifier, and message code.
• LOGGING_ENABLED — evaluates the requested log level against the current system/Profile Option logging threshold and returns a boolean output indicating whether logging should proceed.
• CREATE_LOG — persists an activity/log record with attributes including log-used-by, message level/type, description, budget, threshold, transaction, notification date, and activity log identifier.
• CONVERT_CURRENCY — converts an amount between currencies for a given conversion date using Oracle's currency rate tables.
• CONVERT_TIMEZONE — converts a timestamp between user and system timezones according to the requested conversion type.
• CALCULATE_FUNCTIONAL_CURR / CALCULATE_FUNCTIONAL_CURRENCY — derive the functional currency (and related amount) applicable to a Trade Management transaction.

Tables Accessed

The ETRM metadata documents a single referenced table accessed via an APPS synonym: PLITBLM, the standard Oracle Applications "PL/SQL integer table" diagnostic structure (PL/SQL Table of Integer, B – numeric). It is used by the logging and table-copy routines to buffer integer-indexed collections during message assembly and Rosetta marshalling. All other data access (for example currency rates and timezone definitions) is performed indirectly through standard Oracle currency utilities or through private helpers inside OZF_UTILITY_PVT rather than through direct DML in this wrapper.

Usage Notes

Because the package is a Rosetta-generated wrapper, it is normally invoked from other OZF PL/SQL packages and from Forms or concurrent programs that route through the Trade Management business logic, not directly by end users. The logging_enabled procedure is the typical gate: callers first invoke LOGGING_ENABLED to check whether the requested level is active, and only then call LOG_MESSAGE and CREATE_LOG, which minimizes overhead when diagnostic logging is switched off. The package is referenced by zero other documented packages, which confirms its role as a leaf-level utility rather than a hub. Custom code extending Trade Management should call LOGGING_ENABLED before LOG_MESSAGE, and should treat the log_level and module_name arguments as the standard diagnostic identifiers used elsewhere in OZF.