Search Results update_ls_rt_fctr_ents

Overview

The package body APPS.OKL_LS_RT_FCTR_ENTS_PUB is a public PL/SQL API within the Oracle Lease and Finance Management (OLFM) module of Oracle E-Business Suite. Its name derives from the functional area it serves: OKL (Oracle K-Lease, the historical prefix for the leasing product), LS (Lease), RT_FCTR (Rate Factor), and ENTS (Entities). The package therefore governs the creation, maintenance, validation, and lifecycle control of rate factor entity records used during lease pricing and rate determination. Rate factors are the adjustable inputs — such as residual percentages, money factors, term-based indices, and credit-driven adjustments — that the pricing engine applies when generating lease rates and payment schedules. This public package exposes the transactional entry points that forms, concurrent programs, and external integrations use to persist and manipulate those rate factor entity rows in a controlled, validated manner consistent with the OLFM data model.

Key Procedures and Functions

The documented public interface exposes five primary procedures, organized as a conventional CRUD-plus-validation set:

• INSERT_LS_RT_FCTR_ENTS — Creates new rate factor entity records. It accepts the business attributes required to define a rate factor entity and persists them, typically returning the generated primary key so that downstream processing can reference the new row.
• LOCK_LS_RT_FCTR_ENTS — Obtains a row-level lock on an existing rate factor entity record, protecting it from concurrent modification while a caller performs dependent validation, update, or deletion logic. This supports the OLFM concurrency model by serializing access to a single entity.
• UPDATE_LS_RT_FCTR_ENTS — Modifies an existing rate factor entity, applying the supplied attribute changes to the stored record. Callers are expected to have locked the row beforehand.
• DELETE_LS_RT_FCTR_ENTS — Removes a rate factor entity record, subject to the referential and business constraints enforced by the package and the underlying schema.
• VALIDATE_LS_RT_FCTR_ENTS — Performs business rule checks against the entity attributes — for example, ensuring required columns are populated and that values fall within permitted ranges — before an insert or update is committed.

These procedures are the documented members of the package; the body may contain additional private helpers not exposed through the public specification.

Tables Accessed

The ETRM metadata records the dependency graph rather than an explicit table list. The package body depends on APPS.FND_API and APPS.OKL_API, the standard Oracle Application Object Library and OLFM error-handling and message utilities, and on the SYS.STANDARD package. It also references its own package specification. Functionally, the procedures operate on the OLFM rate factor entity base table (the OKL_LS_RT_FCTR_ENTS family of tables and their _B/_TL variants), reading and writing the rows that define rate factor entities and their translated descriptive columns. Validation and error reporting route through FND_API/OKL_API so that failures are surfaced through the standard EBS message stack rather than native exceptions.

Usage Notes

This package is classified as a public (PUB) API and is not referenced by any other database object, meaning it is an entry point rather than an internal utility. It is typically invoked from OLFM setup and pricing forms, from concurrent programs that load or refresh rate factor data, and from custom extensions or integrations that need to maintain rate factor entities programmatically. Callers should follow the canonical pattern: validate, then lock before update or delete, and rely on the API's error handling to populate the standard message stack. Because the API is not internally called, changes to its behavior have limited blast radius within the schema, but external customizations depending on it should be regression-tested during upgrades between 12.1.1 and 12.2.2.