Search Results process_system_params

Overview

OKL_AM_SYSTEM_PARAMS_PUB is the public application programming interface for maintaining system-level parameter records within the Oracle E-Business Suite Lease and Finance Management (formerly Oracle Lease Management / OKL) module. In EBS 12.1.1 and 12.2.2, the package exposes a single documented public entry point, PROCESS_SYSTEM_PARAMS, which creates or updates a row in the OKL_SYSTEM_PARAMS_ALL_V view. The package belongs to the APPS schema and is classified as a PUB (public) API, meaning it is intended for invocation from outside the owning module — by forms, concurrent programs, or custom integration code — rather than being restricted to internal package-to-package calls.

The package body is a thin public wrapper. It does not itself contain the core parameter-maintenance logic; instead it delegates the business processing to a private counterpart, OKL_AM_SYSTEM_PARAMS_PVT.process_system_params. This public/private split is a standard Oracle Application Framework API design convention that isolates validation, message handling, and DML within the _PVT layer while the _PUB layer provides a stable, documented contract to callers.

Key Procedures and Functions

The package body documents one procedure:

• process_system_params — Creates or updates a record in OKL_SYSTEM_PARAMS_ALL_V. It accepts an API version, an initialization flag for the message list, a system-parameter record structure (sypv_rec_type), and returns a corresponding output record structure together with the standard API return status, message count, and message data outputs. The procedure is the sole documented public interface of this package.

Internally, process_system_params begins by emitting a procedure-level log entry through FND_LOG, then calls OKL_API.start_activity to validate the API version, initialize the message list as directed by the caller, and establish a savepoint for the transaction. If start_activity signals an unexpected error, the procedure raises G_EXCEPTION_UNEXPECTED_ERROR; if it signals an ordinary error, it raises G_EXCEPTION_ERROR. On success it invokes OKL_AM_SYSTEM_PARAMS_PVT.process_system_params, propagating the API version, the input record, and the output status and message parameters. This confirmatory behavior is central to how callers interpret the return status.

Tables Accessed

The documented data target is the view OKL_SYSTEM_PARAMS_ALL_V, which the procedure creates or updates. The view exposes lease-management system parameter definitions — the configuration values that govern module-wide processing behavior. Because the public layer performs no direct DML, the actual insert or update against the underlying base table occurs within the private package after any required validation. The documentation excerpt does not enumerate additional tables referenced through APPS synonyms, and no other objects are asserted here.

Usage Notes

Because PROCESS_SYSTEM_PARAMS is a public API, it is typically invoked by the Oracle Lease Management setup forms or by concurrent programs responsible for maintaining system parameters, and it may be called from custom PL/SQL that needs to programmatically establish or revise those parameters. Callers should pass a valid API version, supply the input sypv_rec structure, and inspect x_return_status together with x_msg_count and x_msg_data to determine success or failure. The ETRM metadata records that this package is referenced by one other package, confirming its role as a supporting interface within the OKL module. The header comment indicates the procedure was created in 2003 and the package is flagged noship, reflecting its status as a standard internal application object rather than a shipped standalone deliverable.