Search Results get_nbv

Overview

OKL_CREATE_KLE_PVT is a private PL/SQL package in the APPS schema within Oracle E-Business Suite's Enterprise Trading and Lease Management (ETRM) module (Oracle Lease Management / OKL). It is classified as a PVT (private) API, meaning it is intended for internal consumption by public API wrappers rather than direct calls from external custom code. The package encapsulates the core logic required to create and maintain the financial and asset-oriented structures of a lease contract, including the Key Lines and Elements (KLE) that represent contract lines, add-on lines, interest/insurance lines, asset line details, and associated party roles. It acts as the engine behind the public interface OKL_CREATE_KLE_PUB, mediating writes into the OKC contract tables and the OEM/asset tables. In effect, it converts business-level requests—generated during lease origination, quote-to-contract conversion, equipment exchange, or interface processing—into correctly structured contract header, line, rule, and asset records, while applying financing and capitalized cost logic. The package is documented in ETRM 12.2.2 and remains valid in the 12.1.1 architecture; it sits in the lineage of Oracle Lease Management's contract authoring APIs and is referenced by other private packages such as OKL_ASSET_DETAILS_PVT, OKL_DEAL_ASSET_PVT, OKL_EQUIPMENT_EXCHANGE_PVT, OKL_OPEN_INTERFACE_PVT, and OKL_QUOTE_TO_CONTRACT_PVT.

Key Procedures and Functions

• UPDATE_FIN_CAP_COST — recalculates or updates the financed and capitalized cost amounts associated with a contract line or asset.
• CREATE_ADD_ON_LINE / UPDATE_ADD_ON_LINE / DELETE_ADD_ON_LINE — manage add-on lines attached to a lease contract, covering creation, modification, and removal.
• CREATE_PARTY_ROLES_REC / UPDATE_PARTY_ROLES_REC — create and maintain party role records (e.g., lessee, lessor, guarantor) tied to the contract.
• CREATE_ALL_LINE / UPDATE_ALL_LINE — handle the primary lease contract line records, the base "all line" structures from which contract elements derive.
• CREATE_INTS_IB_LINE / UPDATE_INTS_IB_LINE / DELETE_INTS_IB_LINE — manage interest and insurance (INTS/IB) lines within the contract.
• CREATE_ASSET_LINE_DETAILS / UPDATE_ASSET_LINE_DETAILS — write and maintain asset-specific detail records linked to contract lines.
• GET_NBV — a function returning the net book value of an asset, typically sourced from fixed asset data.

Tables Accessed

The package reads and writes contract structures primarily through OKC tables: OKC_K_HEADERS_B, OKC_K_ITEMS, OKC_K_LINES_B, OKC_K_LINES_TL, OKC_K_PARTY_ROLES_B, OKC_LINE_STYLES_B, OKC_RULES_B, and OKC_RULE_GROUPS_B. These hold the contract header, line definitions, descriptive text, party roles, line styles, and rule groups that drive pricing and behavior. Asset and item data are read from CSI_ITEM_INSTANCES, MTL_SYSTEM_ITEMS, and the fixed asset tables FA_ADDITIONS, FA_ADDITIONS_B, FA_BOOKS, FA_BOOK_CONTROLS, and FA_CATEGORY_BOOK_DEFAULTS—used to resolve asset identity, book defaults, and depreciation context for net book value and financed cost calculations.

Usage Notes

This package is invoked indirectly. Its public wrapper OKL_CREATE_KLE_PUB is the supported entry point and is called from Oracle Lease Management forms, concurrent programs (such as open interface and quote-to-contract processing), and migration routines. Because it is a PVT package, Oracle recommends it not be called directly; customizations should use the corresponding _PUB package. Deployment must respect object dependencies, since the package compiles against OKC_API, OKL_API, OKL_KLE_PVT, and several other OKL private packages.