Search Results okl_lrt_pvt




Overview
Explore in AI Chat

Overview

The APPS.OKL_LRT_PVT package body is a private (PVT-classified) PL/SQL unit within the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite, available in release 12.1.1 and 12.2.2. The name convention — LRT for Lease Rate Terms and PVT for private — indicates that this package encapsulates the internal persistence and validation logic that supports the public lease rate factor APIs. Its principal business function is the maintenance of lease rate factor sets and their associated entities, including multi-language (translation) handling, row locking, insert, update, delete, and validation operations against the underlying rate factor tables.

The package is owned by the APPS schema and is reported as VALID in the documented metadata. It is a tightly scoped internal utility that exposes no public interface for external consumers; instead it is invoked by the surrounding public rate-term layer. The metadata records that OKL_LRT_PVT is referenced by seven other packages, confirming its role as a shared internal service within the OKL rate-factor subsystem, yet it is not itself referenced by any database object outside that scope.

Key Procedures and Functions

The documented metadata lists eleven program units, six of which are named:

  • ADD_LANGUAGE — Inserts translation rows for the rate factor set descriptive columns, propagating the base-language record into additional installed languages through the standard EBS multi-language pattern. It works in tandem with FND_LANGUAGES to determine the set of active languages.
  • INSERT_ROW — Creates a new rate factor set record, including the base table and the translation table entries, and typically triggers the associated language rows through ADD_LANGUAGE.
  • LOCK_ROW — Acquires a row-level lock (SELECT ... FOR UPDATE) on a rate factor set prior to modification, protecting concurrent edits against lost updates.
  • UPDATE_ROW — Modifies an existing rate factor set, including translated descriptive columns, after the row has been locked.
  • DELETE_ROW — Removes a rate factor set and its dependent translation and entity rows, subject to validation constraints.
  • VALIDATE_ROW — Performs the business-rule validation of a rate factor set, returning error status via the standard OKL/FND exception mechanism rather than raising unhandled exceptions.

All units follow the standard EBS API conventions: a p_ parameter prefix, an x_return_status out parameter (S/W/E), and an x_msg_count/x_msg_data message stack populated through FND_API and OKC_API. Parameter lists are not published in the metadata and are not reproduced here.

Tables Accessed

  • OKL_LS_RT_FCTR_SETS_B — the base table for lease rate factor sets; INSERT_ROW and UPDATE_ROW write here.
  • OKL_LS_RT_FCTR_SETS_TL — the translation table holding language-specific descriptive columns; populated by ADD_LANGUAGE and updated by UPDATE_ROW.
  • OKL_LS_RT_FCTR_SETS_V — the view combining base and translation rows, used for validation and lookup.
  • OKL_LS_RT_FCTR_ENTS — rate factor set entities; validated and deleted in conjunction with the parent set.
  • OKL_LS_RT_FTR_SETS_ALL_B — the all-organization variant of the rate factor set base table.
  • FND_LANGUAGES — the installed-language reference used by ADD_LANGUAGE.
  • PLITBLM — the PL/SQL internal index-by table type used for message and ID collections.

The package additionally depends on OKL_LRF_PVT, OKL_API, OKL_UTIL, OKC_API, OKC_P_UTIL, FND_API, FND_GLOBAL, FND_LOOKUPS, MO_GLOBAL, APP_EXCEPTIONS, and OKL_FE_EO_TERMS_V.

Usage Notes

Because OKL_LRT_PVT is classified PVT, it is not intended to be called directly from custom code, concurrent programs, or forms. It is invoked internally by the public rate-term and rate-factor APIs, and indirectly by the Oracle Lease Management rate factor setup forms whenever a user creates, modifies, or end-dates a rate factor set. Customizations should target the corresponding public API layer rather than this private package; direct calls risk breaking the insert/validate/language synchronization sequence that OKL_LRT_PVT maintains. The package is also invoked during multi-language installation and upgrade routines, since ADD_LANGUAGE follows the standard EBS translation-propagation cycle.