Search Results okl_ldb_pvt




Overview
Explore in AI Chat

Overview

OKL_LDB_PVT is an internal, private (PVT-classified) PL/SQL package in the APPS schema that supports Oracle Enterprise Asset Management / Lease and Finance Management (formerly Oracle Lease Management, OKL) functionality within Oracle E-Business Suite 12.1.1 and 12.2.2. In the ETRM data model, "LDB" refers to the Lease Decision Balance or ledger/balance processing layer associated with lease contracts, and this package encapsulates the low-level database operations performed against the party payment header structures. Rather than exposing business logic directly to end users, OKL_LDB_PVT provides the private worker routines—row insertion, locking, update, deletion, validation, and versioning—that public APIs and contract-processing packages call to maintain the underlying lease/payment data. The package is STATUS VALID in the dictionary, confirming that it compiles and is available for use by dependent objects.

Key Procedures and Functions

The package exposes approximately twenty documented program units. The core CRUD layer consists of INSERT_ROW, LOCK_ROW, UPDATE_ROW, DELETE_ROW, and VALIDATE_ROW, which respectively create, lock, modify, remove, and validate a single logical row in the party payment header structures. These follow the standard Oracle private-API pattern of accepting a row identifier or whole-row record and performing the corresponding DML with consistent validation.

The versioning sub-layer is handled by CREATE_VERSION, RESTORE_VERSION, and CHANGE_VERSION, which together manage the historical and current versions of lease payment header data, enabling point-in-time recovery and change tracking. API_COPY duplicates an existing record set, typically supporting contract duplication or rebooking scenarios. QC is a quality-check or quick-check routine used to verify data integrity or pre-conditions before a transaction proceeds. The package also provides private helper entry points that are reused internally by the version and CRUD routines. All routines are private in the sense that they are not intended for direct external invocation, and their parameter lists are inherited from the parent public APIs.

Tables Accessed

OKL_LDB_PVT operates against several tables referenced through APPS synonyms. OKL_PARTY_PAYMENT_HDR and its correlated view OKL_PARTY_PAYMENT_HDR_V store the party payment header records that are the package's primary target of DML. OKL_PARTY_PAYMENT_HDR_H is the history table used by the versioning routines to preserve prior states. OKC_K_HEADERS_B supplies contract header context against which payment rows are associated and validated. PLITBLM is a PL/SQL index-by table type used for bulk operations within the package. The dependency list also confirms use of the shared FND_API and OKC_API packages for error handling and contract API services.

Usage Notes

Because it is a PVT-classified package, OKL_LDB_PVT is not called directly from concurrent programs or forms. It is invoked indirectly by the public lease APIs and contract-processing packages that reference it, notably OKL_CONTRACT_PVT, OKL_CONTRACT_REBOOK_PVT, OKL_COPY_CONTRACT_PVT, OKL_DEAL_TERMS_PVT, OKL_MAINTAIN_FEE_PVT, OKL_PARTY_PAYMENTS_PVT, OKL_VERSION_PVT, and the OKL_OPEN_INTERFACE_PVT package that users typically reach through the open interface concurrent process when loading lease contract data. Customizations should call the corresponding public API layered above this package rather than OKL_LDB_PVT itself, to preserve upgrade safety and versioning integrity.