Search Results okl_lla_util_pvt




Overview
Explore in AI Chat

Overview

OKL_LLA_UTIL_PVT is a private utility package body in the Oracle E-Business Suite Lease and Loan Management (formerly Oracle Lease Management) module. The suffix "PVT" identifies it as an internal implementation package that is not intended to be called directly by customer code; the public-facing counterpart in this architectural pattern is typically named OKL_LLA_UTIL_PUB. The package provides low-level shared services that support lease lifecycle activities: date and currency-amount formatting and canonicalization, validation of contract rebook, release, split, and mass-rebook operations, and resolution of asset and party location information. Because it consolidates these miscellaneous helpers, OKL_LLA_UTIL_PVT is referenced by approximately fifty other packages within the ETRM schema, making it one of the more widely depended-upon utilities in the lease application. The package body holds a VALID status in both Release 12.1.1 and 12.2.2, and the documented metadata identifies thirty procedures and functions. It is owned by the APPS schema and is not referenced by any database object outside the EBS application stack.

Key Procedures and Functions

The API classification is PVT, and the documented procedures fall into functional groupings. The date and amount helpers include FORMAT_ROUND_AMOUNT and ROUND_AMOUNT, which control rounding presentation for lease amounts; GET_NUMBER, which parses numeric containers; and GET_CANONICAL_DATE, VALIDATE_GET_CANONICAL_DATE, GET_DISPLAY_DATE, and CONVERT_DATE, which normalize, validate, and convert lease dates between canonical internal and display representations. The contract validation group includes CHECK_MASS_REBOOK_CONTRACT, CHECK_REBOOK_CONTRACT, CHECK_RELEASE_CONTRACT, CHECK_RELEASE_ASSETS, CHECK_NEW_CONTRACT, and CHECK_SPLIT_CONTRACT; these evaluate whether a given lease contract or asset set is eligible for the named operation and typically return a Boolean or raise an application error. GET_CONTRACT_PROCESS and IS_LEASE_CONTRACT identify whether the supplied contract qualifies as a lease and determine the current processing path. CALCULATE_END_DATE derives terminal dates for lease terms. GET_LOOKUP_MEANING resolves coded lookup values to display text. CHECK_LINE_UPDATE_ALLOWED determines whether a contract line may still be modified. The location procedures GET_ASSET_LOCATION and GET_AST_INSTALL_LOC_ID return the asset's current location and its installation location identifier, using the Oracle Install Base view and trading community model tables. The metadata does not document explicit parameter lists for these procedures.

Tables Accessed

The package reads Oracle Contracts tables, including OKC_K_HEADERS_B, OKC_K_HEADERS_ALL_B, OKC_K_ITEMS, OKC_K_LINES_B, OKC_LINE_STYLES_B, and OKC_RULES_B, to inspect contract headers, lines, and business rules during contract validation. It reads OKL_K_LINES, OKL_TRX_CONTRACTS, OKL_TRX_CONTRACTS_ALL, and OKL_SYS_ACCT_OPTS for lease-specific line, transaction, and accounting option data. Supplier and payment information is drawn from AP_SUPPLIERS, OKL_PARTY_PAYMENT_DTLS, and OKL_PARTY_PAYMENT_HDR. Trading community tables HZ_LOCATIONS, HZ_PARTIES, HZ_PARTY_SITES, and HZ_PARTY_SITE_USES support party and address resolution for asset location. Oracle Install Base data comes from CSI_ITEM_INSTANCES and the view OKL_TXL_ITM_INSTS_V, with fixed asset identification via FA_ADDITIONS_B. Stream-related tables OKL_STREAM_TRX_DATA and OKL_ST_GEN_TMPT_SETS and the selected-rebook table OKL_RBK_SELECTED_CONTRACT support lease stream generation and rebook processing. Standard FND utilities (FND_API, FND_DATE, FND_LOOKUPS, FND_PROFILE) supply error handling, date formatting, lookup, and profile option retrieval.

Usage Notes

OKL_LLA_UTIL_PVT is invoked indirectly from lease management forms, concurrent programs such as stream generation and rebook processing, and other PL/SQL packages; it is not part of the documented public API and should not be called from custom code, which should target OKL_LLA_UTIL_PUB when available. Customers performing upgrades between Release 12.1.1 and 12.2.2 should verify compilation status on this object, since it is a foundational dependency for a large portion of the ETRM package stack.