Search Results okl_ive_pvt




Overview
Explore in AI Chat

Overview

OKL_IVE_PVT is a private PL/SQL package body in the APPS schema that supports Oracle Lease and Finance Management (OLFM), part of the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 application stack. The "IVE" component designates index value entry functionality. The package manages index value records — the period-by-period values of financial indices (such as a consumer price index, prime rate, or other reference rate) used to reprice and escalate lease contracts. It encapsulates the low-level data manipulation and validation logic behind the public API layer that exposes these operations to the OLFM application. As a PVT (private) package, its routines are intended for internal use by other OLFM packages rather than direct invocation by external callers.

Key Procedures and Functions

The documented API comprises thirteen procedures and functions. While the metadata identifies the following named routines, their parameter signatures are not reproduced here:

  • INSERT_ROW — Inserts a new index value record into the underlying index value store, applying defaulting and validation prior to persistence.
  • UPDATE_ROW — Modifies an existing index value record, revalidating the changed attributes.
  • DELETE_ROW — Removes an index value record subject to the package's deletion rules.
  • LOCK_ROW — Obtains a row-level lock on an index value record to preserve transactional consistency during concurrent updates.
  • VALIDATE_ROW — Performs attribute-level and cross-field validation against the supplied index value data.
  • API_COPY — Copies index value records, typically supporting versioning or duplication scenarios.
  • CHANGE_VERSION — Reassigns the version context of an index value record, aligning it with the package's versioning model.
  • QC — A quality-check routine that verifies data integrity and completeness for supplied index value information.

Collectively these routines implement the standard Oracle Application Object Library private-package pattern: a uniform insert/update/delete/lock/validate/version matrix that the public API calls after performing its own checks.

Tables Accessed

The package operates primarily against OKL_INDEX_VALUES, the base table storing index value data. It also reads the OKL_INDEX_VALUES_V and OKL_INDICES_V views to resolve index definitions and validated value sets. AK_ATTRIBUTES_TL supplies translated attribute metadata (descriptive flexfield support), while DUAL and PLITBLM (the standard PL/SQL index-by-table system object) are used for lightweight query and collection processing. FND_API, FND_GLOBAL, OKC_API, OKC_P_UTIL, and OKL_API provide the error-handling, session-context, and common utility services that the private routines depend upon.

Usage Notes

OKL_IVE_PVT is not intended for standalone or ad-hoc execution; it is invoked indirectly by public OLFM APIs and UI components when index values are created, maintained, or validated. ETRM documentation records that the package is referenced by eleven other database objects and references no external objects beyond its documented dependencies, confirming its role as a foundational private layer. In practice it is reached through the OLFM index value maintenance forms, through concurrent processing that loads or refreshes index values, and through custom extensions that call the surrounding public API rather than this private package directly. Because it is a package body classified as PVT, Oracle reserves the right to change its interface without notice, so custom code should never reference OKL_IVE_PVT directly.