Search Results okl_setupdsfparameters_pub




Overview
Explore in AI Chat

Overview

The OKL_SETUPDSFPARAMETERS_PVT package is a private (PVT classification) PL/SQL package in the APPS schema that supports the configuration of Data Source Function (DSF) parameters within Oracle E-Business Suite's Enterprise Contracts, specifically the Oracle Lease and Finance Management (OKL) module. In Oracle EBS 12.1.1 and 12.2.2, the OKL schema governs the rules, computations, and derived values used during lease origination, contract authoring, and pricing. DSF parameters represent the configurable inputs that drive these data source functions, allowing administrators to tailor contract calculations without invasive customization.

This package functions as the internal implementation layer behind the public API OKL_SETUPDSFPARAMETERS_PUB, which exposes the supported interface to callers. The private package contains the core DML logic while the public package provides the governed entry point. This separation follows Oracle's standard public/private API design pattern, preserving backward compatibility and encapsulating direct table manipulation.

Key Procedures and Functions

The package exposes six documented program units, of which the principal procedures are:

  • GET_REC — Retrieves the current record of DSF parameter configuration, typically used to validate existence and populate a persistent record structure before updates.
  • INSERT_DSFPARAMETERS — Creates a new DSF parameter setup record, invoked when a new parameter must be registered against a data source function.
  • UPDATE_DSFPARAMETERS — Modifies an existing DSF parameter configuration, applying changes to stored parameter attributes.
  • DELETE_DSFPARAMETERS — Removes a DSF parameter configuration when it is no longer required.

These procedures collectively implement the CRUD lifecycle for DSF parameter setup. Parameter lists are intentionally not reproduced here; callers should reference the package specification through the ETRM documentation or the APPS schema.

Tables Accessed

The package operates against the base table referenced through the APPS synonym PLITBLM, an Oracle Standard Library table used for persistent PL/SQL data storage. The DSF parameter configuration records are read and written via the DML operations implemented in the procedures above. In addition, the package depends on supporting OKL packages — OKL_DSF_PVT, OKL_FNCTN_PRMTRS_PUB, OKL_FPR_PVT, and OKL_DATA_SRC_FNCTNS_PUB — which provide the validation, function lookup, and parameter metadata necessary to maintain referential integrity of DSF configurations.

Usage Notes

As a private package, OKL_SETUPDSFPARAMETERS_PVT is not intended for direct invocation by external or custom code. It is referenced by its public counterpart, OKL_SETUPDSFPARAMETERS_PUB, and by a wrapper package OKL_SETUPDSFPARAMETERS_PVT_W. Typical invocation paths include Oracle Forms-based setup screens in the Lease Management Administrator responsibility where DSF parameters are configured, and internal OKL processing logic that resolves data source functions during contract rating and pricing.

Developers integrating with OKL should always call the PUBLIC package rather than the PVT package, since the private interface is subject to change without notice and does not carry the support guarantees of the published API. Any customization that needs to register or modify DSF parameters must route through the public API to ensure proper validation, audit, and downstream consistency with the function parameter framework.