Search Results okl_setupoptvalues_pvt




Overview
Explore in AI Chat

Overview

OKL_OVE_PVT is an internal private PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema that belongs to the Oracle Lease and Finance Management (OKL) module. Its role centres on the Option Value Engine (OVE) — the component of Oracle Lease Management responsible for defining, storing, and evaluating the option values attached to lease contracts. Option values provide the contractual prices and book-effect amounts that a lessee may pay at the end of a lease term to exercise purchase, renewal, or return options, and the OVE layer validates and records these values against their governing setup rules and templates.

The package is classified as a PVT package, meaning it is a private implementation layer rather than a public API. It follows Oracle's standard API architecture, in which a public PL/publisher package validates inputs and delegates the physical persistence of records to a private package of this kind. Consumers therefore never call OKL_OVE_PVT directly; they invoke the public packages such as OKL_SETUPOPTVALUES_PUB or OKL_OPTIONS_PUB, which in turn call this package. The metadata confirms OKL_OVE_PVT is referenced by eighteen other packages, including OKL_OVE_PVT_W, OKL_OPTIONS_PVT, OKL_SETUPOPTVALUES_PVT, OKL_SETUPOVDTEMPLATES_PVT, and OKL_SETUPOVERULES_PVT. This confirms its position as a shared low-level data-access engine for the entire option-value feature set.

Key Procedures and Functions

Thirteen documented procedures and functions constitute the package interface. Their purposes are as follows:

  • QC — A standard quality-control routine used to determine whether the package is available and initialised before a caller proceeds with option-value processing.
  • CHANGE_VERSION — Manages concurrent-version control, ensuring that option-value records are edited under a consistent version context.
  • API_COPY — Copies option-value rows, typically during template application or when duplicating option definitions across versions or contracts.
  • INSERT_ROW — Inserts a new option-value record into the underlying table after validation.
  • LOCK_ROW — Acquires the row-level lock required before a record is modified or deleted.
  • UPDATE_ROW — Applies changes to an existing option-value record.
  • DELETE_ROW — Physically removes an option-value record.
  • VALIDATE_ROW — Enforces business and referential rules on an option-value record prior to commit.

The remaining documented entries are helper members supporting this create, read, update, and delete cycle. Parameter lists are not published here and have deliberately not been restated.

Tables Accessed

Two tables are documented as being referenced through APPS synonyms.

  • OKL_OPT_VALUES — The principal table of option values. This package reads, inserts, updates, and deletes rows here. The associated view OKL_OPT_VALUES_V is also referenced, most likely for query-only validation and value derivation.
  • PLITBLM — The PL/SQL integer table type used for bulk processing and set-based operations within the DML routines.

The dependency list also shows reliance on FND_API (standard validation constants and exception handling), OKC_API (the Contracts Core API used for currency and contract-context rules), and STANDARD.

Usage Notes

OKL_OVE_PVT is invoked indirectly. Oracle Lease Management setup forms and contract-capture forms call OKL_SETUPOPTVALUES_PUB, OKL_OPTIONS_PUB, and their related public packages; those public packages perform validation and then delegate persistence to OKL_OVE_PVT through the *_PVT and *_PVT_W wrappers. Concurrent programs that generate or refresh option values follow the same path.

Customisation guidance is unambiguous: developers must not call OKL_OVE_PVT from custom code, because its signature may change without notice between releases. Customisations should use the published OKL_SETUPOPTVALUES_PUB and OKL_OPTIONS_PUB APIs instead. The metadata is identical for both Oracle EBS 12.1.1 and 12.2.2, so behaviour is consistent across those releases.