Search Results insert_parameters

Overview

OKL_PARAMETERS_PUB is the public PL/SQL API package for managing the parameter records used by Oracle Lease and Finance Management (OKL) within Oracle E-Business Suite 12.1.1 and 12.2.2. The package body exposes a set of standard, FND_API-compliant programs that create, maintain, validate, and remove parameter data stored on the underlying parameter table. Each program follows the Oracle Applications API conventions: it declares an API version, honors an initialization flag for the message list, returns a standard return status, and reports message count and message data through OUT parameters. The body delegates the physical DML operations to the private package OKL_PMR_PVT, of which the relevant entry point, insert_row, is visible in the source excerpt. This layering keeps the public package focused on API contract handling and error translation while the private package performs the row-level work.

Key Procedures and Functions

Eleven programs are documented for the package. Each is described by name and purpose only.

• ADD_LANGUAGE — Language installation stub. In the source it performs no work and simply returns, which is typical of MLS-related entry points that have been retired or never implemented for this object.
• INSERT_PARAMETERS — Creates a new parameter record. The body saves the incoming record, calls the private insert routine, raises the appropriate FND_API exception when the status indicates an error or unexpected error, and reassigns the local record from the returned output record.
• LOCK_PARAMETERS — Locks an existing parameter record for update, supporting the standard optimistic or explicit locking pattern before modification.
• UPDATE_PARAMETERS — Modifies an existing parameter record through the same public-to-private delegation pattern used for insertion.
• DELETE_PARAMETERS — Removes a parameter record, applying the same savepoint, status, and message handling conventions.
• VALIDATE_PARAMETERS — Validates parameter data, which is the program surfaced by a search on "validate_parameters." It applies the package's business rules to the supplied parameter record and reports the outcome through the standard return status and message list.

Tables Accessed

The documented table reference is PLITBLM, accessed through an APPS synonym. This is the multilanguage (MLS) table used by the EBS translation infrastructure for storing language-specific text rows, and OKL_PARAMETERS_PUB reaches it in the context of the language-related processing associated with the package. The primary parameter storage is written and read indirectly through the private package OKL_PMR_PVT, which is why the public body itself shows no direct DML against the parameter table.

Usage Notes

OKL_PARAMETERS_PUB is invoked as a standard EBS public API rather than being called directly from a form or concurrent program in most implementations. Callers are expected to supply a correctly populated parameter record, request the desired API version, and initialize the message list as needed. Return status must be inspected after every call, and messages retrieved via FND_MSG_PUB when the status is not success. The presence of the API classification PUB confirms that this is a supported integration point for custom code and for other EBS packages; the metadata records that it is referenced by one other package, indicating downstream dependency. Because the package is a thin wrapper over OKL_PMR_PVT, customizations should use the public programs in preference to the private ones to preserve upgrade safety. All calls should be executed in the context of the APPS schema with the OKL application initialized.