Search Results convert_to_contract_currency

Overview

OKL_ACCOUNTING_UTIL_W is the public wrapper package for OKL_ACCOUNTING_UTIL in Oracle Lease and Finance Management (OKL), part of Oracle E-Business Suite 12.1.1 and 12.2.2. The _W suffix denotes an interoperable wrapper generated to expose the underlying package's PL/SQL collection types to external and layered callers, most notably the Oracle Application Framework (OAF) and Java-based middle tiers. The underlying business function is lease accounting utilities: the derivation of accounting segment combinations, the retrieval of accounting period information, currency conversion at contract and functional currency levels, and the detection of overlapping accounting attributes.

Because OAF cannot natively bind PL/SQL associative array and VARRAY types, the package relies on "Rosetta" bridge routines that copy data between OKL_ACCOUNTING_UTIL's strongly typed collections and the generic JTF_NUMBER_TABLE, JTF_VARCHAR2_TABLE_100, JTF_VARCHAR2_TABLE_2000, and JTF_VARCHAR2_TABLE_200 types. The package is declared AUTHID CURRENT_USER, so all unqualified object references resolve in the schema of the invoker rather than the definer. The header revision is 120.3, dated 25 January 2007, indicating the interface has been stable across the 11i-to-12.x upgrade path. The classification is OTHER, and the package is referenced by no other documented packages, so it is predominantly an entry point rather than an internal dependency.

Key Procedures and Functions

Twenty-four documented procedures and functions are exposed. They divide into three groups.

• Rosetta table-copy bridges: ROSETTA_TABLE_COPY_IN_P0 / OUT_P0 (numeric segment identifiers), _P1 (segment values), _P2 (segment descriptions), _P3 (multi-row error messages up to 2000 characters), and _P26 (overlap attribute combinations spanning two 100-character and one 200-character column). The _IN variants populate typed OKL structures from generic JTF tables; the _OUT variants perform the reverse copy.
• Segment and message utilities: GET_SEGMENT_ARRAY parses a delimited concatenated segment string into a table of segment values. GET_ERROR_MESSAGE and GET_ERROR_MSG return accumulated validation messages into a JTF_VARCHAR2_TABLE_2000.
• Accounting logic: GET_ACCOUNTING_SEGMENT derives the accounting flexfield segment combination; GET_PERIOD_INFO resolves the accounting period for a given date; GET_CURR_CON_RATE returns a conversion rate between two currencies for a date and rate type; CONVERT_TO_FUNCTIONAL_CURRENCY and CONVERT_TO_CONTRACT_CURRENCY apply those rates; CHECK_OVERLAPS detects conflicting or duplicate accounting attribute assignments; GET_VERSION returns the package version string.

Tables Accessed

The only documented table reference, resolved through an APPS synonym, is PLITBLM, the PL/SQL intermediate/date table used by Oracle's conversion utilities for rate lookup and date handling. GET_CURR_CON_RATE, CONVERT_TO_FUNCTIONAL_CURRENCY, and CONVERT_TO_CONTRACT_CURRENCY depend on this table for daily and period rate retrieval. All other logic operates on values passed in through the JTF collection parameters or on OKL_ACCOUNTING_UTIL's in-memory structures, so the package itself performs limited direct DML; persistence occurs in the underlying package and in the lease accounting schema.

Usage Notes

OKL_ACCOUNTING_UTIL_W is invoked from OAF pages and Java business components that must exchange accounting segments, error messages, or overlap attributes with PL/SQL. The Rosetta routines are called first to marshal data across the JDBC boundary, then the business routines are invoked. Custom code should call the _W wrapper rather than OKL_ACCOUNTING_UTIL directly whenever the caller cannot reference OKL's declared collection types in the same schema, and should always use named notation and preserve the JTF table types exactly, since array length mismatches are not tolerated. Because the package executes with the invoker's privileges, grants on the underlying OKL objects and on PLITBLM must be in place for the calling user or responsibility. Typical triggers include lease accounting generation, period close processing, and any custom concurrent program that must translate contract currency amounts into functional currency or validate that accounting segment assignments do not overlap.