Search Results okl_ls_rt_fctr_ents_pub_w




Overview
Explore in AI Chat

Overview

The APPS.OKL_LS_RT_FCTR_ENTS_PUB_W package is a public wrapper package within the Oracle E-Business Suite (EBS) Lease and Finance Management (Oklahoma/OKL) module, part of the Enterprise Transaction and Rate Management (ETRM) family of APIs. It exposes a programmatic interface for managing lease-to-ownership or lease rate factor entries — the configuration records that define the rate factors and pricing-related line entries associated with lease contracts and their underlying rate structures. As a public wrapper (_PUB_W), it is designed to be the externally callable entry point for the underlying business logic, encapsulating validation and data manipulation so that forms, concurrent programs, and custom code interact through a stable, supported interface rather than directly against base tables.

The package is classified under API type OTHER and is owned by the APPS schema, ensuring it is accessible to all application modules and customization layers in both Oracle EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The ETRM metadata documents the following public procedures and functions:

  • INSERT_LS_RT_FCTR_ENTS — Creates new lease rate factor entry records. It accepts the data required to define a rate factor entry and persists a new row, applying standard defaults and validation before insertion.
  • LOCK_LS_RT_FCTR_ENTS — Obtains a lock on one or more rate factor entry records, typically using SELECT ... FOR UPDATE semantics, to prevent concurrent modification during a transaction.
  • UPDATE_LS_RT_FCTR_ENTS — Modifies existing rate factor entry records, enforcing validation rules before committing changes.
  • DELETE_LS_RT_FCTR_ENTS — Removes rate factor entry records, subject to referential integrity and business-rule checks.
  • VALIDATE_LS_RT_FCTR_ENTS — Performs validation of rate factor entry data (required fields, value ranges, cross-field consistency) without necessarily persisting changes, supporting pre-insert and pre-update checking.

Together these procedures form a standard CRUD-plus-validation interface. No parameter lists are reproduced here, as they are not part of the documented metadata.

Tables Accessed

The package references the APPS synonym set rather than naming base tables directly. Its documented technical dependencies include the JTF tables JTF_NUMBER_TABLE, JTF_VARCHAR2_TABLE_100, and JTF_VARCHAR2_TABLE_500 — Oracle Application Object Library (AOL) collection types used to pass arrays of numbers and strings between PL/SQL layers — as well as JTF_DATE_TABLE for date arrays. These collections allow the API to process multiple rate factor entries in a single call. The package also depends on the SYS.STANDARD package, provided automatically by the PL/SQL runtime environment.

Usage Notes

As a public wrapper (denoted by the _PUB_W suffix), this package is intended for external invocation. It is typically called from Oklahoma lease and rate factor maintenance forms, from concurrent programs that bulk-load or migrate lease rate factor entries, and from custom PL/SQL code extending the Lease Management module. Direct DML against the underlying rate factor entry tables is discouraged; the API should be used to ensure validation and consistent locking. Because the metadata records that it is referenced by no other packages, its consumers are external callers rather than other APIs. Any customization should respect the locking order established by LOCK_LS_RT_FCTR_ENTS prior to updates or deletions. The package status is VALID in the documented ETRM 12.2.2 environment.