Search Results okl_setup_trxparams_pvt




Overview
Explore in AI Chat

Overview

The APPS.OKL_SETUP_TRXPARAMS_PVT package body is a private (PVT-classified) PL/SQL API within the Oracle Lease and Finance Management (OLFM) module of Oracle E-Business Suite, applicable to releases 12.1.1 and 12.2.2. Its business purpose is to manage the setup and configuration of transaction parameters and transaction asset parameters that govern how lease and finance transactions are created, validated, and processed by the OKL Transaction (SIF) framework. Transaction parameters act as the configurable control records that determine default behavior, processing rules, and asset-level attributes applied when agreement and transaction data are imported or entered. Because the package is classified as private, it is not intended as a public integration surface; rather, it provides the internal implementation used by the public transaction parameter API layer and by other OKL components. The dependency metadata confirms that it is a self-contained private implementation referencing other private and public OLFM APIs, including OKL_API, OKC_API, FND_API, and OKL_SXP_PVT, along with the public transaction parameter package OKL_SIF_TRX_PARMS_PUB.

Key Procedures and Functions

The ETRM metadata documents ten procedures or functions within this package body, of which the following are specifically identified:

  • CREATE_TRX_PARM — Creates a new transaction parameter setup record, establishing the configuration values used to control transaction processing behavior.
  • UPDATE_TRX_PARM — Modifies an existing transaction parameter setup record, allowing configuration values to be maintained over time.
  • DELETE_TRX_PARM — Removes a transaction parameter setup record that is no longer required.
  • CREATE_TRX_ASSET_PARM — Creates a new transaction asset parameter setup record, defining configuration attributes that apply at the asset level within a transaction.
  • UPDATE_TRX_ASSET_PARM — Modifies an existing transaction asset parameter setup record.

The remaining documented procedures and functions follow the same setup-maintenance pattern, providing the complementary create, update, and delete operations that complete the transaction parameter and transaction asset parameter maintenance lifecycle. These private routines encapsulate the validation, defaulting, and persistence logic behind the corresponding public API calls.

Tables Accessed

The package operates against the base transaction parameter table through its APPS synonym:

  • OKL_SIF_TRX_PARMS — The primary store for transaction parameter setup data. The create, update, and delete routines in this package insert, modify, and remove records in this table as the underlying persistence mechanism for the transaction and asset parameter configuration.
  • PLITBLM — A standard Oracle PL/SQL-supplied table type used by the package for bulk operations. The package also depends on the STANDARD package supplied by SYS for baseline PL/SQL functionality.

All access to the OKL_SIF_TRX_PARMS synonym is performed with the privileges of the APPS schema, consistent with the shared APPS codebase model.

Usage Notes

As a private package, OKL_SETUP_TRXPARAMS_PVT is not invoked directly by external integrations or custom code. It is called by the corresponding public API layer, principally OKL_SIF_TRX_PARMS_PUB, which exposes the supported interface for transaction parameter maintenance. Typical invocation therefore originates from OLFM setup forms, concurrent programs, and internal OLFM transaction processing routines that require transaction parameter or transaction asset parameter records to be created, updated, or deleted. The dependency metadata indicates the package references one other package and is referenced by one other package, reflecting its tightly scoped position within the OLFM API stack. Because the metadata available from ETRM is limited to signature names and dependencies, implementers should consult the Oracle Lease and Finance Management technical reference and the public OKL_SIF_TRX_PARMS_PUB specification for supported entry points, and must not call this private package directly in custom extensions, as its interface is subject to change without notice.