Search Results okl_lrl_pvt




Overview
Explore in AI Chat

Overview

OKL_LRL_PVT is a private PL/SQL package in the APPS schema belonging to the Oracle Enterprise Transaction Management (ETRM) family of modules, which manages leasing and finance contracts. The package name resolves to "OKL Lease Rate List" (LRL) private API, and it operates as the persistence and lifecycle layer for lease rate list and rate factor set definitions used during lease pricing and rate factor computation. In the Oracle EBS 12.1.1 and 12.2.2 releases, OKL_LRL_PVT sits beneath the public application programming interfaces that expose lease rate functionality to forms and concurrent programs. It encapsulates low-level row manipulation against the rate set level and rate factor set tables, shielding callers from direct DML and preserving the integrity of versioned pricing data.

Key Procedures and Functions

The ETRM documentation records eight procedures and functions in OKL_LRL_PVT, with the following named entry points:

  • CHANGE_VERSION — Creates or transitions a rate list definition to a new version, supporting Oracle's standard versioning model so that rate structures can be revised without destroying historical definitions used by existing contracts.
  • API_COPY — Copies an existing rate list or rate factor set definition, including its associated setup rows, to produce a reusable template or a new version baseline.
  • INSERT_ROW — Inserts a new rate list or rate factor set entry, applying the validation and defaulting logic expected by the surrounding ETRM rate model.
  • UPDATE_ROW — Modifies an existing entry in place, used when rate levels, factor entries, or set attributes are adjusted.
  • DELETE_ROW — Removes an entry from the rate list structures, subject to the referential rules governing rate factor sets and their dependent entries.

The remaining documented members are not individually named in the metadata; they support the internal housekeeping that these five public entry points rely upon.

Tables Accessed

OKL_LRL_PVT reads and writes through APPS synonyms for the following tables:

  • OKL_FE_RATE_SET_LEVELS and OKL_FE_RATE_SET_LEVELS_V — Store the hierarchical levels that make up a rate set; the package reads the view for validation and writes the base table when levels are created, changed, or removed.
  • OKL_FE_RATE_SET_VERSIONS — Tracks the version history of rate sets, driven by CHANGE_VERSION.
  • OKL_LS_RT_FCTR_SETS_B — The base table for lease rate factor sets; INSERT_ROW, UPDATE_ROW, and DELETE_ROW operate here.
  • OKL_LS_RT_FCTR_ENTS — Holds the individual rate factor entries belonging to a set, maintained in step with the set header.
  • PLITBLM — The standard Oracle PL/SQL index-by table support object used for bulk processing.

Usage Notes

OKL_LRL_PVT is a private (PVT) API and is not intended for direct invocation by external or customer code. It is referenced by five other packages, including OKL_LEASE_RATE_FACTORS_PVT, OKL_LEASE_RATE_SETS_PVT, OKL_LRF_GENERATE_PVT, OKL_LRL_PVT_W, and OKL_LEASE_RATE_FACTORS_PVT_W. The _W suffixed packages are the public wrappers exposed to Oracle Forms and concurrent programs within ETRM, and they delegate to OKL_LRL_PVT to perform the underlying database work. The user search term okl_lrf_generate_pvt refers to the LRF Generate package, which consumes OKL_LRL_PVT when generating lease rate factors from defined rate lists. In practice, the package is invoked indirectly through the Lease Rate Lists and Rate Factor Sets setup forms, and through concurrent programs that generate or refresh rate factors. Customizations should call the public wrapper packages rather than OKL_LRL_PVT directly, ensuring that version control, validation, and auditing logic remain intact across both EBS 12.1.1 and 12.2.2.