Search Results get_asset_number

Overview

OKL_DEAL_PAYMENTS_PVT is a private PL/SQL package in the Oracle E-Business Suite Lease and Finance Management (formerly Oracle Lease Management) module, delivered under the APPS schema. It forms part of the ETRM (Enterprise Transaction and Reporting Management) layer that supports lease and financing contract processing in EBS 12.1.1 and 12.2.2. The package encapsulates the logic required to assemble and return payment-related attributes for a lease deal, most notably the header information used when displaying or processing payment obligations on a contract. The "PVT" suffix indicates that the package is classified as a private API: its procedures and functions are intended for internal use by Oracle's own lease management components rather than being published as an open integration interface. The header comment shows a source revision from 2007, confirming the package has been stable across multiple EBS releases.

Key Procedures and Functions

The package exposes three documented program units. Each is summarized below; parameter lists are deliberately omitted, as the documented signatures should be consulted directly in the source.

• GET_FEE_SERVICE_NAME — A function that returns the descriptive name of a fee or service associated with a given contract, contract line, lease, and parent contract line combination. It resolves the human-readable service name used in payment header displays, drawing on contract line and item descriptions.
• GET_ASSET_NUMBER — A function that returns the asset number tied to a contract, contract line, and lease. This is the function most commonly sought by developers, since asset number is a frequently referenced attribute in lease payment and asset-tracking screens. It derives the asset identifier from the contract item associations.
• LOAD_PAYMENT_HEADER — A procedure that populates the payment header context for a contract and contract line. It returns the service fee contract line identifier and name, together with the asset contract line identifier, asset number, and asset description. This procedure consolidates the lookups performed individually by the two functions into a single call suitable for populating a form block or report header. It follows the standard OKL API convention, accepting an API version and an initialize-message-list flag, and returning the standard return status, message count, and message data out parameters.

Tables Accessed

The package reads from five tables through APPS synonyms. MTL_SYSTEM_ITEMS_TL and OKC_K_ITEMS supply item and contract item information used to resolve asset and service identities; MTL_SYSTEM_ITEMS_TL specifically provides the translated item description returned as the asset description. OKC_K_LINES_B and OKC_K_LINES_TL provide the base and translated contract line records, linking contract lines to the assets and fees referenced in the payment header. OKL_STRM_TYPE_TL supplies translated stream type descriptions relevant to the lease payment structure. The package is documented as a read-oriented utility, assembling descriptive values rather than performing inserts or updates on these tables.

Usage Notes

Because the package is classified as private (PVT), it is not documented as a supported public API and is referenced by zero other packages in the documented metadata, meaning Oracle's internal callers are not exposed through the ETRM dictionary. In practice it is invoked from Lease Management forms and concurrent programs that render the payment header region of a contract, and from the OKL payment processing flow. GET_ASSET_NUMBER is frequently the entry point developers search for when they need to resolve an asset number from a contract line without invoking the full header load. Custom code that calls these units directly should treat them as unsupported and validate behavior after any upgrade, since private APIs may change without notice between 12.1.1 and 12.2.2. Where an equivalent public API exists, it should be preferred.