Search Results update_tmpt_lines

Overview

OKL_PROCESS_TMPT_SET_PVT is a private (PVT) PL/SQL package in the Oracle E-Business Suite Oracle Lease and Finance Management (OKL) module. It implements the internal processing logic for template sets — the reusable configuration structures that streamline the creation of new lease contracts and related documents. The package belongs to the OKL contract authoring and setup family, and its _PVT designation indicates that it is not a public API; it is called only from within other OKL packages, forms, or concurrent programs and is not intended for direct customer invocation.

The package is declared AUTHID CURRENT_USER, meaning that database object resolution and privileges are evaluated in the schema of the invoker rather than the definer, which is typical of EBS internal packages. Constant declarations in the header reference standard OKL_API and OKC_API tokens such as G_MISS_NUM, G_MISS_CHAR, G_MISS_DATE, G_RET_STS_SUCCESS, G_RET_STS_ERROR, and G_REQUIRED_VALUE, confirming that this package follows the standard Oracle EBS API error-handling and defaulting conventions. The G_PKG_NAME constant, however, is anomalously set to 'OKL_SETUP_PRICEPARMS_PVT', a known copy-paste characteristic of the source.

Key Procedures and Functions

The package exposes 23 documented procedures and functions grouped by the entity they operate on:

• CREATE_TMPT_SET / UPDATE_TMPT_SET / DELETE_TMPT_SET — manage the header records of template sets, the top-level grouping used to organize reusable template definitions.
• CREATE_TEMPLATE / UPDATE_TEMPLATE / DELETE_TEMPLATE — manage individual template records within a template set, including their descriptive and operational attributes.
• CREATE_TMPT_LINES / UPDATE_TMPT_LINES / DELETE_TMPT_LINES — maintain the line-level detail of templates. The UPDATE_TMPT_LINES procedure is the object most commonly searched for and corresponds to the user query "update_tmpt_lines"; it is the internal routine that persists changes to template line rows.
• COPY_TMPL_SET / COPY_TEMPLATE — duplicate existing template sets or templates, enabling rapid creation of similar configurations.
• VALIDATE_GTS_ID — a validation function that verifies the existence and validity of a Global Template Set identifier before it is used in downstream processing.

Each procedure adheres to the OKL API pattern: required-value and invalid-value errors are raised through G_EXCEPTION_ERROR, unexpected errors through G_EXCEPTION_UNEXPECTED_ERROR, and processing-halting conditions through G_EXCEPTION_HALT_PROCESSING.

Tables Accessed

The package performs DML and queries against the following tables through APPS synonyms:

• OKL_AE_TMPT_SETS — the template set header table, written by CREATE/UPDATE/DELETE_TMPT_SET and COPY_TMPL_SET.
• OKL_AE_TEMPLATES — the template definition table, managed by the TEMPLATE procedures.
• OKL_AE_TMPT_LNES — the template line table, the target of CREATE/UPDATE/DELETE_TMPT_LINES.
• OKL_ST_GEN_TMPT_SETS — stores generated template set information, read during copy and validation.
• OKL_SYS_ACCT_OPTS and OKL_TRNS_ACC_DSTRS — system accounting options and transaction account distributions, consulted when templates include accounting-related attributes.
• PLITBLM — a general-purpose EBS table often used for storing VARCHAR2 list values; it supports multi-value parameter parsing within this package.

Usage Notes

Because OKL_PROCESS_TMPT_SET_PVT is classified as a private package, it should not be called directly from custom code. It is invoked indirectly through OKL setup forms, through public wrapper APIs, or from concurrent programs that create or copy lease templates. The metadata indicates the package is referenced by two other packages, which act as the public entry points. Developers debugging template-line updates — for example, when troubleshooting the "update_tmpt_lines" behavior — should trace calls upward to those referencing packages rather than modifying this private unit. Any customization of the private logic risks breaking the OKL template framework and is unsupported in both EBS 12.1.1 and 12.2.2.