Search Results okl_setup_prcparams_pub




Overview
Explore in AI Chat

Overview

OKL_SPP_PVT is a private PL/SQL package in the APPS schema that belongs to the Oracle Lease and Finance Management (OLFM) module of Oracle E-Business Suite. Its name derives from "SPP" (Setup Price Parameters), and it functions as the private implementation layer behind the public setup price parameter APIs. As a PVT-classified package, it is not intended to be called directly by external code; instead, it provides the internal logic consumed by OKL_SETUP_PRCPARAMS_PUB, OKL_SETUP_PRCPARAMS_PVT, and OKL_SIF_PRICE_PARMS_PUB.

The package encapsulates the low-level business rules for maintaining price parameter setup records, including concurrency control (row locking and version checking), record-level validation, and the standard insert, update, copy, and delete operations that define the setup pricing configuration in Oracle Lease Management. Because the user searched for "okl_setup_prcparams_pub," it is important to recognize that OKL_SPP_PVT is one of the primary internal dependencies of that public API.

Key Procedures and Functions

  • QC — A quality-check or quick-check helper routinely used to assert internal invariants before performing database operations.
  • CHANGE_VERSION — Adjusts the version attribute of a price parameter row, supporting optimistic locking and multi-version concurrency control.
  • API_COPY — Copies price parameter configuration from a source record to a target record, enabling duplication of setup pricing data.
  • INSERT_ROW — Physically creates a new price parameter row in the underlying table, applying defaulting and audit column population.
  • LOCK_ROW — Acquires a row-level lock using SELECT FOR UPDATE semantics to prevent concurrent modification of the same parameter record.
  • UPDATE_ROW — Modifies an existing price parameter row while preserving audit and version integrity.
  • DELETE_ROW — Removes a price parameter row, typically preceded by referential and status validation.
  • VALIDATE_ROW — Executes the business validation rules that a price parameter record must satisfy before it is persisted.

The package exposes thirteen documented procedures and functions in total, including the W (wrapper) counterparts used by the public API layer. Parameter lists are not documented here and are not speculated.

Tables Accessed

The package operates primarily on OKL_SIF_PRICE_PARMS, accessed via the APPS synonym, which stores the setup price parameter definitions maintained through the OLFM setup UI. It also reads PLITBLM, the standard Oracle EBS PL/SQL integer-indexed table type used for bulk item processing. These objects are referenced through APPS synonyms, consistent with the private API pattern.

Usage Notes

OKL_SPP_PVT is invoked indirectly. Oracle EBS users interact with it through the Setup Price Parameters forms and through the public entry points OKL_SETUP_PRCPARAMS_PUB and OKL_SIF_PRICE_PARMS_PUB. This package is referenced by six other packages, all of which are part of the pricing setup subsystem. Customizations should invoke the public (PUB) APIs rather than this private layer, because Oracle reserves the right to change private signatures without notice. Typical invocations occur during setup maintenance, configuration copy operations, and concurrent processing of price parameter changes. In 12.1.1 and 12.2.2, the package remains VALID and is a documented dependency of the setup price parameters public API, making it a foundational component of Oracle Lease Management pricing configuration.