Search Results okl_process_tmpt_set_pvt




Overview
Explore in AI Chat

Overview

OKL_TMPT_SET_PUB is the public application programming interface (API) for the Oracle Lease and Finance Management (OLFM) template set component within Oracle E-Business Suite Release 12.1.1 and 12.2.2. The package, owned by the APPS schema, provides the externally callable business logic governing template sets and their associated template lines — the reusable structures that drive lease and finance contract generation, pricing, accounting, and lifecycle processing. As a designated public package (API classification PUB), it is the supported entry point for external and internal callers that need to create, modify, validate, lock, or remove template set definitions and template lines. The actual row-level processing is delegated to the private worker package OKL_TMPT_SET_PVT, while OKL_TMPT_SET_PUB enforces the standard OLFM API contract: bulk processing, validation levels, and standardized return status and message handling via FND_API and OKC_API. The package status is VALID and it is referenced by nine dependent packages across the application.

Key Procedures and Functions

The documented interface exposes 33 procedures and functions. The principal entry points fall into three groups:

Each operation follows the OLFM API convention of accepting entity identifiers, attribute values, and validation-level controls, and returning a standardized status code with associated error messages. The remaining documented procedures support internal orchestration and are invoked primarily by OKL_TMPT_SET_PUB itself and by its worker package.

Tables Accessed

Per the documented ETRM metadata, OKL_TMPT_SET_PUB references a single table via an APPS synonym: PLITBLM. This table is associated with the template set and template line data that the API creates, updates, validates, and deletes. All other data access for the template set component is performed by the private package OKL_TMPT_SET_PVT and by the dependent packages listed in the dependency tree, including OKL_AES_PVT, OKL_ATL_PVT, and OKL_AVL_PVT.

Usage Notes

OKL_TMPT_SET_PUB is not intended for direct end-user invocation; it is called programmatically by OLFM forms, concurrent programs, and other PL/SQL packages. The dependency metadata shows it is referenced by nine packages, including OKL_PROCESS_TMPT_SET_PVT (the object the user originally searched for), OKL_COPY_TEMPLATE_PVT, OKL_ACCOUNT_DIST_PUB, OKL_ACCOUNT_DIST_PVT, OKL_INTEREST_CALC_PVT, OKL_MISC_TRANS_PVT, OKL_PAY_CURE_REFUNDS_PVT, and OKL_BPD_TERMINATION_ADJ_PVT. Custom code extending OLFM functionality should invoke OKL_TMPT_SET_PUB rather than the underlying private package, because the public API preserves the documented validation semantics, concurrency locking, and error-handling contract across upgrades. Callers should supply the appropriate validation level and always inspect the returned status and message before committing.