Search Results okl_setup_prcparams_pvt




Overview
Explore in AI Chat

Overview

OKL_SIF_PRICE_PARMS_PUB is a public PL/SQL package in the APPS schema that supports the Oracle E-Business Suite Lease Management (formerly Oracle Lease Management, OKL) pricing and price parameter configuration flow. Its central purpose is to manage the persistence of price parameters used by the Supplier Information File / pricing setup process, providing a controlled, API-based layer over the underlying price parameter data so that pricing rules and parameters can be inserted, maintained, and validated in a consistent and auditable manner. In the ETRM 12.2.2 metadata, the package is classified as a "PUB" (public) API, indicating it is intended for supported, external invocation by other EBS components and custom extensions, rather than being a purely internal helper. The package depends on OKC_API (Contracts Core API) and OKL_SPP_PVT (the private pricing parameter processing layer), and it is itself referenced by the setup packages OKL_SETUP_PRCPARAMS_PUB and OKL_SETUP_PRCPARAMS_PVT. This confirms that OKL_SIF_PRICE_PARMS_PUB sits within the price parameter setup subsystem and mediates between the lease setup user interface/entries and the lower-level pricing engine.

Key Procedures and Functions

  • ADD_LANGUAGE — Adds or associates language-specific (translation) rows for price parameter definitions, ensuring that price parameter descriptions and labels are available in the required languages. This supports the multilingual footprint expected of an EBS setup object.
  • INSERT_SIF_PRICE_PARMS — Creates new SIF price parameter records. This is the primary entry point for introducing a new price parameter into the ETRM pricing configuration.
  • LOCK_SIF_PRICE_PARMS — Provides concurrency control by locking the relevant price parameter records so that concurrent update or delete operations cannot interleave inconsistently.
  • UPDATE_SIF_PRICE_PARMS — Modifies existing SIF price parameter records, applying changes to the stored pricing parameters.
  • DELETE_SIF_PRICE_PARMS — Removes SIF price parameter records that are no longer required, subject to whatever validation and locking the package enforces.
  • VALIDATE_SIF_PRICE_PARMS — Performs business-rule validation on SIF price parameters, verifying that supplied values satisfy the constraints required before the records are committed.

Together these six documented procedures form a complete create-read-request lifecycle (insert, lock, update, delete, validate) plus language maintenance, reflecting a standard EBS public API design.

Tables Accessed

The documented table access for this package is via the APPS synonym PLITBLM. This synonym resolves to the underlying pricing/lease table that stores price parameter data used by the SIF pricing setup. All insert, update, delete, lock, and validation activity described above ultimately reads from and writes to this table through the synonym, which isolates the package from physical table name changes across EBS releases. Because the package operates through the APPS synonym layer and is backed by OKL_SPP_PVT, it also inherits the private pricing parameter processing logic implemented there; that private package is the recognized vehicle for the more detailed rules and derivations applied to the stored data.

Usage Notes

OKL_SIF_PRICE_PARMS_PUB is typically invoked from the price parameter setup flows within Oracle Lease Management, where a user defines or maintains the pricing parameters applied to lease contracts. In the standard application, the setup forms and related components call OKL_SETUP_PRCPARAMS_PUB and OKL_SETUP_PRCPARAMS_PVT, which in turn reference OKL_SIF_PRICE_PARMS_PUB and its wrapper OKL_SIF_PRICE_PARMS_PUB_W. Custom code and extensions should likewise invoke the public procedures of OKL_SIF_PRICE_PARMS_PUB rather than manipulating PLITBLM directly, so that locking, validation, and dependency on OKC_API and OKL_SPP_PVT remain intact. A sensible calling convention is to validate first, lock the target rows before updating or deleting, and use ADD_LANGUAGE only when translation rows are required. Because the API classification is PUB and the object status is VALID, the package is a supported integration point; however, callers should confirm record-level prerequisites and handle exceptions raised by the validation and lock procedures. The wrapper package OKL_SIF_PRICE_PARMS_PUB_W provides the outward-facing interface used by setup components, reinforcing the package's role as the controlled gateway to SIF price parameter data.