Search Results get_primary_stream_type

Overview

OKL_ISG_UTILS_PVT is a private (PVT) PL/SQL utility package in the Oracle E-Business Suite Oracle Lease and Finance Management (OKL) module. The package name and its declared constant, G_PKG_NAME, together with the API prefix OKL_ISG_UTILS, indicate that it supports Oracle Lease Management structured (stream) generation and related installment-processing utilities. The package is declared with AUTHID CURRENT_USER and depends on the OKL_API, OKC_API, and OKL_API error-handling conventions, using standard tokens such as G_APP_NAME, G_UNEXPECTED_ERROR, G_DB_ERROR, G_COL_NAME_TOKEN, G_SQLERRM_TOKEN, and G_SQLCODE_TOKEN for consistent exception reporting.

The package provides internal helper logic used by other lease and contract APIs. It exposes utility routines for validating structured-payment generation templates, resolving stream type values (both primary and dependent), and determining arrears-payment date options. Because it is classified PVT, its procedures and functions are intended to be invoked by other OKL packages rather than being treated as a public, customer-facing API. The embedded cursor G_GET_K_INFO_CSR demonstrates its role in retrieving contract-header context—joining OKC_K_HEADERS_V, OKL_K_HEADERS, and OKL_PRODUCTS_V—to derive product ID, start date, deal type, and reporting product ID for a given contract header.

Key Procedures and Functions

• VALIDATE_STRM_GEN_TEMPLATE — Validates the structure and applicability of a stream generation template. It uses the standard API parameter conventions (API version, initialization message list, and status/message outputs) consistent with Oracle EBS API design.
• GET_PRIMARY_STREAM_TYPE — Returns the primary stream type associated with the lease or contract context, supporting the determination of the main payment/stream schedule.
• GET_DEPENDENT_STREAM_TYPE — Returns a dependent stream type derived from the primary stream type. This is the procedure directly matching the user search term "get_dependent_stream_type," and it is central to resolving how secondary streams relate to the primary stream in structured generation.
• GET_DEP_STREAM_TYPE — A related helper that resolves the dependent stream type, likely used as an internal or alternative access point for the same dependency logic as GET_DEPENDENT_STREAM_TYPE.
• GET_ARREARS_PAY_DATES_OPTION — Determines the arrears payment dates option, controlling how payment dates are computed when streams are processed in arrears rather than in advance.

Tables Accessed

The package reads from a range of lease and contract tables via public APPS synonyms. Stream type lookup is driven by OKL_STRM_TYPE_B. Template validation and generation rely on OKL_ST_GEN_TEMPLATES, OKL_ST_GEN_TMPT_SETS, OKL_ST_GEN_TMPT_LNS, and OKL_AE_TMPT_SETS / OKL_AE_TMPT_SETS_ALL. Contract and line context come from OKL_K_HEADERS, OKL_K_HEADERS_H, OKL_K_LINES, OKC_K_LINES_B, OKC_K_LINES_TL, OKC_LINE_STYLES_B, OKC_RULES_B, OKC_RULE_GROUPS_B, and OKC_STATUSES_B. These joins support determination of line styles, rule groups, and statuses required to derive the correct stream type and payment-date options.

Usage Notes

OKL_ISG_UTILS_PVT is referenced by approximately ten other packages, confirming its role as an internal utility library. It is typically invoked from lease and contract processing logic — including forms, concurrent programs, and other OKL packages — during structured stream generation, template validation, and payment schedule calculation. Because the routines are private, customizations should call them only with caution and preferably through supported public APIs; direct use risks breakage across EBS 12.1.1 and 12.2.2 patch levels, where the package body version may differ.