Search Results okl_opt_pvt




Overview
Explore in AI Chat

Overview

OKL_OPT_PVT is the private implementation package body for option (contract option or "opt") processing within the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite. In the ETRM (Enterprise Transaction and Reference Model) object classification scheme, packages carrying the PVT suffix are internal, private-layer packages that back a corresponding public API package (typically OKL_OPT_PUB or a functional wrapper). The package encapsulates the DML and business-logic primitives that operate against the OKL_OPTIONS entity — the foundation of contract option handling such as purchase options, renewal options, and term-extension options tied to a lease or loan contract.

The body is stored under the APPS schema and is reported as VALID. It exposes the low-level operations used to insert, update, lock, validate, version, and copy option records. It also provides a "QC" entry point, which in OKL packages is conventionally a change-quality or quality-check routine invoked during record manipulation. Because this is a body rather than a specification-only package, the documented procedures represent the actual callable implementation units.

Key Procedures and Functions

The ETRM metadata documents 13 callable units in the body. The principal named procedures are:

  • QC — the quality-check entry point, invoked by calling APIs before committing an option row. It performs integrity and consistency checks on the option record.
  • CHANGE_VERSION — manages versioning of option records, supporting the OKL contract versioning model so that changes to an option do not overwrite prior versions.
  • API_COPY — copies option data, typically used when duplicating a contract or propagating options across versions.
  • INSERT_ROW — inserts a new OKL_OPTIONS record with the supplied attribute set.
  • LOCK_ROW — issues a SELECT ... FOR UPDATE against the option row, ensuring exclusive access during concurrent modification.
  • UPDATE_ROW — updates an existing option record.
  • DELETE_ROW — logically or physically deletes an option record.
  • VALIDATE_ROW — applies business-rule validation to an option row before persistence.

Per ETRM conventions, these procedures are not parameter-documented here; their signatures are exposed via the package specification. The naming pattern mirrors the standard OKL private-package CRUD+validation template.

Tables Accessed

The package body reads and writes the following documented tables (via APPS synonyms):

  • OKL_OPTIONS — the base option transaction table. INSERT_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW operate directly on this table.
  • OKL_OPTIONS_V — the corresponding view, referenced by the package for query/validation reads.
  • PLITBLM — the standard Oracle PL/SQL index-by-table (associative array) type from the SYS/PUBLIC PLITBLM package used for bulk processing.

It additionally depends on OKL_ACCOUNTING_UTIL for accounting integration, OKC_API and OKC_P_UTIL for contract core services, and FND_API / FND_GLOBAL for the standard EBS API error-handling and session-context framework.

Usage Notes

OKL_OPT_PVT is not intended for direct customer invocation; it is an internal layer invoked by the option public API, which in turn is called from the OKL contract entry forms, concurrent programs, and option maintenance flows. The ETRM metadata records that the package is referenced by 29 other database objects, confirming it sits beneath a widely used option-processing surface. Customizations should target the corresponding public API rather than OKL_OPT_PVT, because private-layer signatures may change between patch levels. The package honors FND_GLOBAL session context (org, user) and uses FND_API for message and exception propagation, so it must be invoked within an initialized EBS session. Both 12.1.1 and 12.2.2 retain the same private-package structure.