Search Results get_chr_currency

Overview

OKL_AM_UTIL_PVT is a private (PVT) PL/SQL utility package in the Oracle E-Business Suite Lease Management (OKL) module. Its source header identifies it as OKLRAMUS.pls, version 120.14, last updated in 2007. The package provides a broad set of reusable helper routines that support the asset management and transaction processing components of Oracle Lease Management. Rather than exposing a public business API, OKL_AM_UTIL_PVT functions as an internal service layer that other OKL packages and forms call to resolve organizational context, currency information, transaction and stream identifiers, asset quantities, formulae, rule data, and JTF object metadata.

The package declares several global data structures and subtypes that are shared across its routines, including bind variable tables, a quote record type sourced from OKL_TRX_QUOTES_PUB, and record/table types for WHERE clauses, JTF objects, and recipients. These structures enable dynamic query construction and message processing. Global constants handle error and debug message levels via FND_MSG_PUB, and application name constants reference OKL_API and OKC_API, confirming the package's integration with the leasing and contract core APIs.

Key Procedures and Functions

The package documents 61 procedures and functions. Prominent routines include:

• GET_ASSET_QUANTITY — the routine most relevant to asset quantity resolution, returning the quantity associated with an asset in a lease transaction context.
• GET_OKL_ORG_ID / GET_CHR_ORG_ID — resolve the operating unit or organization identifier for lease and contract header records.
• GET_CHR_CURRENCY / GET_CURRENCY_INFO — retrieve currency attributes for contracts and transactions.
• GET_TRANSACTION_ID / GET_STREAM_TYPE_ID — return transaction and stream type identifiers used in lease processing.
• GET_RULE_CHR_ID / GET_RULE_RECORD — fetch rule-related contract header and rule record data.
• GET_FORMULA_VALUE / GET_FORMULA_STRING — evaluate or return formulae stored in OKL_FORMULAE_B.
• GET_BILL_TO_ADDRESS — resolve the bill-to address for a transaction.
• INITIALIZE_TXN_REC — initialize a transaction record structure.
• GET_OBJECT_DETAILS / GET_JTF_OBJECT_NAME / GET_JTF_OBJECT_COLUMN — retrieve JTF object metadata for notification and messaging integration.
• SET_TOKEN / SET_MESSAGE / SET_INVALID_RULE_MESSAGE / PROCESS_MESSAGES — manage token substitution, message construction, and error message processing.

Tables Accessed

The package references a range of tables through APPS synonyms. Lease and contract tables include OKC_K_HEADERS_B, OKC_K_PARTY_ROLES_B, OKL_K_HEADERS, OKL_K_LINES, OKL_FORMULAE_B, and OKL_TRX_MSGS. Asset information is sourced from FA_ADDITIONS, while depreciation data is drawn from FA_BOOKS, FA_BOOK_CONTROLS, FA_CALENDAR_PERIODS, FA_DEPRN_PERIODS, and FA_DEPRN_SUMMARY. Currency conversion and lookup rely on FND_CURRENCIES, user context on FND_USER, and organizational context on HR_ALL_ORGANIZATION_UNITS.

Usage Notes

OKL_AM_UTIL_PVT is a private package and is not intended for direct customer invocation. It is referenced by 71 other packages, indicating its role as a shared utility layer across Oracle Lease Management. Custom code should avoid calling it directly; extensions should instead use public OKL APIs. The presence of GET_ASSET_QUANTITY, formulae routines, and depreciation table access suggests it is invoked during asset-based lease calculations, depreciation roll-ups, and transaction message generation, typically triggered from Lease Management forms and concurrent programs.