Search Results okl_lrf_pvt




Overview
Explore in AI Chat

Overview

OKL_LRF_PVT is a private PL/SQL package in the APPS schema belonging to Oracle Enterprise Asset Management / Oracle Lease and Finance Management (part of the E-Business Suite 12.1.1 and 12.2.2 codebase, ETRM family). The "LRF" prefix identifies the Lease Rate Factors functional area, and the "_PVT" suffix follows Oracle's standard private API naming convention, indicating that the package is intended for internal use by other packages rather than direct invocation by external clients or end users. Its role is to encapsulate the row-level data manipulation and validation logic for lease rate factor entities, providing a reusable, secured layer beneath the public and working (non-underscore) packages. As a private package it is not exposed as a callable interface to users, forms or concurrent programs directly; instead it is consumed by the surrounding lease rate factors infrastructure.

Key Procedures and Functions

The ETRM metadata documents ten procedures and functions classified for this package, of which the following are named and confirmed:

  • INSERT_ROW — Inserts a new lease rate factor entity row into the base table, applying defaulting and standard column population.
  • LOCK_ROW — Acquires a row-level lock on the target rate factor record, used to serialize concurrent modifications before update or delete.
  • UPDATE_ROW — Modifies an existing rate factor entity row, typically invoked after LOCK_ROW has secured the record.
  • DELETE_ROW — Removes a rate factor entity row, honouring referential and business constraints.
  • VALIDATE_ROW — Performs business rule and data-integrity validation on the supplied attributes, returning or raising errors through the OKL_API / OKC_API / FND_API error-handling stack.

Additional private helper procedures/functions complete the documented set of ten; these support the CRUD-and-validate pattern described above. Parameter lists are intentionally not reproduced here because the ETRM metadata does not publish them.

Tables Accessed

Dependency analysis shows OKL_LRF_PVT references the following objects through APPS synonyms:

  • OKL_LS_RT_FCTR_ENTS — the core lease rate factor entity table, the primary target of the INSERT/UPDATE/DELETE/VALIDATE logic.
  • OKL_LS_RT_FCTR_ENTS_V — the corresponding view, used for read access and validation lookups.
  • OKL_FE_RATE_SET_VERSIONS — rate set version information, used to resolve the version context in which a rate factor applies.
  • OKL_LS_RT_FCTR_SETS_B — the base table for rate factor sets that group the individual factors.
  • PLITBLM — a standard Oracle date/lookup utility table.

The package also depends on the shared API libraries FND_API, OKC_API and OKL_API, which supply message handling, error stack management, and consistent API behaviour across the Lease Management product suite.

Usage Notes

OKL_LRF_PVT is referenced by nine other packages, indicating that it sits at the bottom of the lease rate factor call stack. Documented callers include OKL_LEASE_RATE_FACTORS_PVT, OKL_LEASE_RATE_FACTORS_PVT_W, OKL_LEASE_RATE_SETS_PVT, OKL_LRF_GENERATE_PVT, OKL_LRF_INTERFACE_PVT, OKL_LRF_PVT_W, OKL_LRT_PVT, OKL_LS_RT_FCTR_ENTS_PUB and OKL_LS_RT_FCTR_ENTS_PUB_W. Because it is a private package, it is typically invoked indirectly: end users interact through the Lease Rate Factors forms and the public _PUB packages, while concurrent programs such as the rate factor generation and interface processes drive bulk operations through OKL_LRF_GENERATE_PVT and OKL_LRF_INTERFACE_PVT, which in turn call this package. Custom code should not call OKL_LRF_PVT directly; developers requiring rate factor maintenance should use the public OKL_LS_RT_FCTR_ENTS_PUB API instead, which provides the supported, error-handled entry point. The package is marked VALID, confirming it is compiled and active in the referenced release.