Search Results g_default_mode




Overview
Explore in AI Chat

Overview

The OKL_STRM_GEN_TEMPLATE_PUB package is the public application programming interface for managing Stream Generation Templates within the Oracle E-Business Suite Lease and Finance Management (OKL) module. Stream Generation Templates define the rules by which contractual streams — such as payments, billings, and accounting events — are automatically generated for a lease or financing agreement. This package provides the supported entry points through which forms, concurrent programs, and custom extensions create, maintain, version, and activate these templates.

As a public (_PUB) package, it exposes a stable, documented contract while delegating the substantive business logic to the corresponding private package (OKL_STRM_GEN_TEMPLATE_PVT) and to supporting private packages such as OKL_GTT_PVT, OKL_GTS_PVT, OKL_GTP_PVT, and OKL_GTL_PVT. These private packages operate on the template set, template header, pricing parameter, and stream type records respectively, and the public package declares PL/SQL subtypes over their record and table types to standardize the interface. The package follows Oracle's standard API conventions: it uses the OKL_API error-handling framework, returns a status code of SUCCESS, ERROR, or UNEXP_ERROR, and populates a message table so callers can retrieve diagnostic text.

Key Procedures and Functions

The package documents eleven routines that cover the full lifecycle of a stream generation template:

  • CREATE_STRM_GEN_TEMPLATE — Creates a new stream generation template, including its associated lines, pricing parameters, and stream types.
  • UPDATE_STRM_GEN_TEMPLATE — Modifies an existing template header and its dependent detail records.
  • DELETE_TMPT_PRC_PARAMS — Removes pricing parameter records associated with a template.
  • DELETE_PRI_TMPT_LNS — Deletes primary template lines from the template definition.
  • DELETE_DEP_TMPT_LNS — Deletes dependent template lines.
  • UPDATE_DEP_STRMS — Updates dependent streams tied to the template.
  • CREATE_VERSION_DUPLICATE — Duplicates a template into a new version, preserving the prior definition for audit and comparison.
  • VALIDATE_TEMPLATE — Performs validation of a template's structure and configuration prior to activation.
  • ACTIVATE_TEMPLATE — Places a validated template into active status so it becomes available for stream generation.
  • VALIDATE_FOR_WARNINGS — Returns non-fatal warnings that do not block activation but warrant review.
  • UPDATE_PRI_DEP_OF_SGT — Maintains the relationships between primary and dependent lines within a stream generation template.

Tables Accessed

The package operates against two documented base tables, accessed through APPS synonyms:

  • OKL_ST_GEN_TEMPLATES — Stores the template header and its stream generation attributes. This is the primary table written by create and update operations and read during validation and activation.
  • OKL_ST_GEN_TMPT_LNS — Stores the individual lines belonging to a template, including primary and dependent lines and their pricing parameters. Line-level operations such as the delete routines and primary/dependent relationship maintenance target this table.

Usage Notes

This API is typically invoked from the Lease Management template setup forms, from concurrent programs that batch-process template changes, and by custom code extending standard template functionality. Because it is a _PUB package, it is the appropriate integration point; callers should not invoke the underlying private packages directly. All calls should inspect the returned status code and, where the status is ERROR or UNEXP_ERROR, read the message table populated by the OKL_API error-handling mechanism. Templates should be created or updated in an inactive state, validated, and only then activated, since VALIDATE_TEMPLATE and VALIDATE_FOR_WARNINGS are designed to precede ACTIVATE_TEMPLATE. The package is referenced by two other packages, confirming its role as a shared service within the OKL module.