Search Results okl_tmpt_set_pub




Overview
Explore in AI Chat

Overview

The OKL_TMPT_SET_PVT package is a private PL/SQL API within the Oracle E-Business Suite Oracle Lease and Finance Management (OKL/ETRM) module, owned by the APPS schema. It provides the underlying implementation logic for the management of lease templates and template sets — reusable definitions that govern how lease and finance contracts are structured, defaulted, and generated during contract authoring.

As a private (PVT) API, this package is not intended to be called directly by external or customer code. Instead, it functions as the internal workhorse behind the public wrapper OKL_TMPT_SET_PUB, which exposes the supported entry points to forms, concurrent programs, and integration code. The package is validated in both EBS 12.1.1 and 12.2.2, and it depends on several peer APIs, including OKC_API (the common contract core API), OKL_AES_PVT, OKL_ATL_PVT, and OKL_AVL_PVT, which together cover the contract terms, line, and value-layer operations that template processing requires.

Key Procedures and Functions

The package exposes 33 documented procedures and functions grouped into logical processing domains. Each domain follows the standard Oracle EBS private API pattern of create, lock, update, delete, and validate.

Collectively, these procedures implement the full lifecycle of template maintenance, enforcing validation rules and maintaining referential and concurrency integrity across the header, template, and line levels.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

  • OKL_AE_TEMPLATES — stores template header and template-set definitions; the primary target of the set and template procedures.
  • OKL_AE_TMPT_LNES — stores the individual template lines, accessed by the TMPT_LINES procedures.
  • PLITBLM — a standard Oracle/APPS utility table used for PL/SQL messaging, temporary identifiers, or error handling support during processing.

Usage Notes

OKL_TMPT_SET_PVT is invoked indirectly. The ETRM Template Setup forms and related maintenance screens call OKL_TMPT_SET_PUB, which in turn delegates to this private package. The metadata confirms OKL_TMPT_SET_PVT is referenced by OKL_TMPT_SET_PUB, OKL_TMPT_SET_PVT_W, and itself, and that it is referenced by two other packages overall.

Developers performing customizations or integrations should always call the public wrapper OKL_TMPT_SET_PUB rather than this package, since private APIs are not guaranteed to remain stable across patches or version upgrades. Direct invocation risks breakage and bypasses the supported validation and locking conventions enforced by the public layer.