Search Results okl_parameters_pub




Overview
Explore in AI Chat

Overview

The APPS.OKL_PARAMETERS_PUB package is a public application programming interface within the Oracle E-Business Suite (EBS) Lease and Finance Management module, part of the Enterprise Contracts (OKL/OKC) family of objects. It is classified as a PUB (public) API, indicating that it is intended for supported, external invocation by other Oracle modules and by customer extensions. The package encapsulates the business logic required to create, maintain, validate, and remove lease and contract parameters — the configurable system, operational, and finance settings that drive how lease contracts are generated, priced, and processed. Because parameter records govern downstream behavior in contract authoring and financial processing, the package enforces the validation and locking rules that protect parameter integrity. Its dependency on OKC_API links it to the core Contracts foundation, while its dependency on OKL_PMR_PVT ties it to internal lease parameter processing logic. The object holds a VALID status in the APPS schema across Oracle EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The documented public procedures expose a complete maintain-back API for lease parameters:

  • INSERT_PARAMETERS — Creates a new parameter record, applying the package's defaulting and validation rules during creation.
  • UPDATE_PARAMETERS — Modifies an existing parameter record, enforcing the same validation logic before committing changes.
  • DELETE_PARAMETERS — Removes a parameter record, presumably after the appropriate edit and integrity checks have been satisfied.
  • VALIDATE_PARAMETERS — Performs the validation checks applied by the insert and update operations, allowing callers to verify parameter data before committing changes.
  • LOCK_PARAMETERS — Acquires a lock on the parameter record, ensuring concurrency control when multiple users or processes attempt to modify the same parameters.
  • ADD_LANGUAGE — Inserts the language-specific (translated) rows associated with parameter setup, supporting the multilingual requirements of a global EBS deployment.

These procedures constitute the standard public interface for parameter maintenance; internal processing is delegated to the package body and its dependent objects.

Tables Accessed

The principal table accessed through APPS synonyms is PLITBLM, the EBS multilanguage (MLS) table that stores translated text segments for setup entities. Use of this table aligns with the ADD_LANGUAGE procedure, which seeds the language rows required for multilingual display of parameter definitions. Parameter records are additionally processed through the package's dependencies on OKC_API and OKL_PMR_PVT, which broker the underlying contract and lease parameter data model. The API therefore reads and writes translation data directly while relying on these dependent packages for the core parameter data manipulation and validation.

Usage Notes

OKL_PARAMETERS_PUB is invoked when lease and contract parameters must be created, changed, validated, or deleted in a supported manner rather than through direct table manipulation. Typical callers include Oracle Lease and Finance Management setup forms, concurrent programs that seed or migrate parameter data, and customer-developed customization or integration code that requires the documented public interface. The companion package OKL_PARAMETERS_PUB_W provides the standard wrapper layer used by EBS UI and multilanguage infrastructure, while direct references to OKL_PARAMETERS_PUB appear where business logic must be executed without the wrapper. Developers extending or integrating with ETRM should invoke these public procedures rather than writing to the underlying setup tables, because the API centralizes locking, validation, language row generation, and the interactions with OKC_API and OKL_PMR_PVT. Parameter setup should generally be completed before contracts are authored, since these values inform pricing and processing behavior throughout the lease lifecycle.