Search Results lock_fmla_oprnds

Overview

OKL_FMLA_OPRNDS_PUB is a public PL/SQL package in the APPS schema that supports Oracle Lease and Finance Management (OKL), part of the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 stack. The package name derives from "FMLA" (formula) and "OPRNDS" (operands), identifying it as the public application programmatic interface for maintaining formula operands used within the lease and finance contract authoring and pricing engine.

In OKL, pricing and calculation logic is expressed through formulas whose components are operands — data elements drawn from contract attributes, system variables, or user-defined inputs. OKL_FMLA_OPRNDS_PUB encapsulates the create, update, delete, lock, and validation operations performed against these operand definitions, exposing them through a standardized, message-based interface. The package is classified as a PUB API, meaning it is intended for supported external invocation by forms, concurrent programs, and custom extensions rather than being an internal private implementation.

The package body depends on FND_API for the standard API framework, FND_MSG_PUB for message stack handling, OKC_API for core contract utilities, OKL_FOD_PVT for formula operand definition private logic, and PLITBLM for PL/SQL table handling utilities. It is referenced by three other database objects, confirming it occupies a central position in the formula configuration layer.

Key Procedures and Functions

The documented interface comprises the following procedures and functions:

• INSERT_FMLA_OPRNDS — Creates a new formula operand definition, populating the underlying operand records with the supplied attributes and returning the standard API outcome.
• UPDATE_FMLA_OPRNDS — Modifies an existing formula operand definition, applying changed attributes to the stored record.
• DELETE_FMLA_OPRNDS — Removes a formula operand definition that is no longer required by the associated formula.
• LOCK_FMLA_OPRNDS — Obtains a logical lock on a formula operand record to preserve concurrency control during multi-step maintenance transactions.
• VALIDATE_FMLA_OPRNDS — Performs pre-processing validation on the operand definition, verifying data integrity and business rules before insert, update, or delete operations are committed.
• ADD_LANGUAGE — Inserts translated (language-specific) rows for operand definitions, supporting the multi-language requirements of a global EBS installation.

Each procedure follows the Oracle EBS API conventions established by FND_API, returning a standard return status and accumulating errors on the FND_MSG_PUB message stack for retrieval by the calling program.

Tables Accessed

The documented table reference via APPS synonyms is PLITBLM, the PL/SQL table used for bulk processing and in-memory collection handling. Operand persistence logic is delegated internally through OKL_FOD_PVT, which manages the formula operand definition base tables on behalf of this public wrapper. Consequently, direct DML against the underlying OKL formula operand tables occurs within the private layer, while OKL_FMLA_OPRNDS_PUB serves as the transactional and validation gateway.

Usage Notes

OKL_FMLA_OPRNDS_PUB is typically invoked from the Oracle Lease and Finance Management setup and contract authoring forms when administrators define or revise the operands available to pricing formulas, and from concurrent programs that bulk-load or migrate formula configurations. Because it is a public API, custom code and interfaces should call these procedures rather than writing directly to the underlying operand tables, ensuring that validation, locking, and message handling behave consistently with seeded functionality.

Callers must supply parameters according to the published signature, check the return status, and inspect the FND_MSG_PUB message stack for errors. The presence of LOCK_FMLA_OPRNDS indicates that multi-step maintenance sequences should lock the operand before applying updates, and ADD_LANGUAGE should be used whenever translated operand rows are required for non-English deployments.