Search Results okl_lrf_pvt_w




Overview
Explore in AI Chat

Overview

OKL_LRF_PVT_W is a private PL/SQL package in the APPS schema that supports the Oracle Lease and Finance Management (OKL) module's Lease Rate Factor (LRF) functionality within Oracle E-Business Suite 12.1.1 and 12.2.2. The package functions as a Rosetta-style wrapper or work-table processing layer that sits alongside the core package OKL_LRF_PVT. Its principal role is to provide the plumbing for passing structured, array-based data between the Oracle Forms user interface (or calling client) and the underlying business logic surrounding lease rate factor computation, storage, and validation. The "_W" suffix conventionally identifies a package that operates on temporary or staging ("work") tables populated by the interface layer before the data is moved into persistent storage by the base private package.

The package is dependency-linked to OKL_LRF_PVT, which it references, and it is in turn referenced by OKL_LEASE_RATE_FACTORS_PVT_W, a higher-level wrapper package. This layered arrangement is typical of ETRM/OKL architecture, where "PVT_W" packages broker data between forms-driven table handlers and the primary "PVT" business packages.

Key Procedures and Functions

The documented interface exposes fourteen program units, of which the following are named. Several are Rosetta table-copy routines that shuttle records between parameter-array structures and database work tables, distinguished by suffix (_P28, _P31) indicating the parameter set or calling context:

  • ROSETTA_TABLE_COPY_IN_P28 — Copies inbound data from the caller's parameter tables into the work table used for the P28 context.
  • ROSETTA_TABLE_COPY_OUT_P28 — Copies processed data from the work table back out to the caller's parameter tables for the P28 context.
  • ROSETTA_TABLE_COPY_IN_P31 — Performs the inbound copy for the P31 parameter set.
  • ROSETTA_TABLE_COPY_OUT_P31 — Performs the outbound copy for the P31 parameter set.
  • INSERT_ROW — Inserts a new lease rate factor row into the work table.
  • LOCK_ROW — Acquires a row-level lock on the target row, typically for update concurrency control.
  • UPDATE_ROW — Modifies an existing row in the work table.
  • DELETE_ROW — Removes a row from the work table.
  • VALIDATE_ROW — Applies business validation rules to a row before it is committed to persistent storage.

The remaining documented program units follow the same naming pattern and serve analogous Rosetta copy or row-management purposes. Parameter lists are not reproduced here; the routines use JTF_DATE_TABLE, JTF_NUMBER_TABLE, JTF_VARCHAR2_TABLE_100, and JTF_VARCHAR2_TABLE_500 as their array-typed arguments.

Tables Accessed

The package accesses the table referenced through APPS synonyms, namely PLITBLM, which functions as the temporary or interface work table holding lease rate factor rows during a forms or batch interaction. In addition, the package depends on the JTF table types (JTF_DATE_TABLE, JTF_NUMBER_TABLE, JTF_VARCHAR2_TABLE_100, JTF_VARCHAR2_TABLE_500) to define its array parameters, and calls into OKL_LRF_PVT for the core rate-factor logic. Data is read from and written to PLITBLM via the INSERT_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW routines, while VALIDATE_ROW applies the LRF business rules before persistence.

Usage Notes

OKL_LRF_PVT_W is not a public API and is not intended for direct invocation by customer code. It is invoked in practice through OKL_LEASE_RATE_FACTORS_PVT_W, which is the documented entry point referenced by the Oracle Forms-based rate factor maintenance screens and by concurrent or batch processes that populate rate factor work tables. Customizations that need to manipulate lease rate factor data should call the public wrapper (OKL_LEASE_RATE_FACTORS_PVT_W) rather than this private package. Because the package is classified VALID and declares OTHER as its API classification, its procedures carry no public-API compatibility guarantee across releases; direct use risks breakage on patching. Any extension work should be limited to the documented public packages in the OKL_LEASE_RATE_FACTORS family.