Search Results g_required_value

Overview

APPS.OKL_KRP_PVT is the private (PVT) package body that implements the core validation logic for Oracle Lease and Finance Management rate parameters in Oracle E-Business Suite, specifically within the ETRM (Enterprise Tax, Reimbursement, and Miscellaneous) lease management module. The "KRP" designation refers to the key rate parameter functionality that governs how lease interest rates, indices, and associated calculations are stored and validated in the leasing application. As a private package, it is not intended to be called directly by end users or external interfaces but rather serves as the implementation layer behind public APIs and forms that manage lease rate structures.

The package follows Oracle's standard private API architecture, where OKL_KRP_PVT contains the actual business logic while a corresponding public package (typically OKL_KRP_PUB) would expose the supported interface. The presence of a header comment referencing version 120.18 and the module name "okl.stream.esg.okl_esg_transport_pvt" indicates this object forms part of the lease rate stream transport framework used during lease origination and rerating.

Key Procedures and Functions

The package contains 19 documented routines. The principal documented routines include:

• QC — A quality check routine typically used to validate data integrity and enforce business rules across rate parameter records.
• CHANGE_VERSION — Handles object versioning, allowing rate parameter records to be updated while preserving historical version information, a critical requirement in lease contracts subject to amendment and rerating.
• API_COPY — Copies rate parameter data, commonly invoked during contract copying, template application, or renegotiation scenarios.
• INSERT_ROW — Inserts new rate parameter rows into the underlying base table, applying defaulting and validation logic.
• LOCK_ROW — Obtains a lock on a specific row prior to update to prevent concurrent modification conflicts.
• UPDATE_ROW — Updates existing rate parameter records with new values, ensuring referential and business rule integrity.
• DELETE_ROW — Removes rate parameter records subject to validation that no dependent data exists.
• VALIDATE_ROW — Performs comprehensive row-level validation, likely including lookup code checks (as illustrated by the check_lookup_code function in the source excerpt) against FND_LOOKUPS.

The source also documents check_lookup_code, a helper function that validates lookup types and codes against FND_LOOKUPS, returning success, error, or unexpected error status through OKL_API constants. This ensures rate parameter values conform to configured lookup definitions.

Tables Accessed

The package references the following APPS-synonymed tables:

• OKL_K_RATE_PARAMS — The primary rate parameters table storing lease interest rates and associated parameter definitions.
• OKC_K_HEADERS_ALL_B — The contract headers base table, providing the contract context in which rate parameters apply.
• OKL_FORMULAE_B — Stores formula definitions used to compute rates derived from indices.
• OKL_INDICES — Holds index definitions (such as prime rate, LIBOR references) against which floating rates are calculated.
• OKL_ST_GEN_TMPT_SETS — Stream generation template sets, linking rate parameters to stream generation logic.
• PLITBLM — A PL/SQL index-by table used internally for caching lookup values or performing bulk operations, not a physical table.

Usage Notes

OKL_KRP_PVT is referenced by four other packages, indicating it is primarily invoked by higher-level lease management APIs. It is typically called from the lease origination and rerating forms within the OKL module, from concurrent programs that regenerate rate parameters in bulk, and from custom extensions that must manipulate rate data. Because the package is designated PVT, direct invocation should be avoided; callers should route through the corresponding public API to preserve upgrade safety across 12.1.1 and 12.2.2 releases.