Search Results okl_streams_util




Overview
Explore in AI Chat

Overview

OKL_STREAMS_UTIL is a utility package body in the APPS schema of Oracle Lease and Finance Management (OKL), part of the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 technology stacks. In the ETRM classification model, this package is an internal UTIL API, meaning it is not designed as a public-facing interface but instead supports the stream-processing and accounting logic invoked by other leasing packages. The package centralizes common operations that surround the Oracle Lease Management stream model, including profile lookups, currency rounding, resolution of primary and dependent stream types, accumulation of stream headers and elements, and retrieval of accounting options and transaction-state values.

The package sits within the larger contract hierarchy structure, which links contracts (OKC_K_HEADERS_B) to lease headers (OKL_K_HEADERS) and eventually to individual streams represented by stream types and streams lines. Its routines depend on several foundational services: FND_API and OKL_API for the standard API framework, FND_MSG_PUB and FND_NEW_MESSAGES for message handling, FND_PROFILE for profile option retrieval, FND_CURRENCIES_VL and FND_LOOKUPS for currency and lookup validation, and OKL_STM_PVT and OKL_STREAMS_PUB for stream processing.

Key Procedures and Functions

The 27 documented procedures and functions fall into several functional groupings.

Tables Accessed

The package reads and writes contract and stream data through APPS synonyms. Contract and lease headers are read from OKC_K_HEADERS_B, OKC_K_HEADERS_ALL_B, and OKL_K_HEADERS, with OKL_K_LINES providing line-level detail. Stream interface data resides in OKL_STREAM_INTERFACES, OKL_SIF_LINES, OKL_SIF_RETS, and OKL_SIF_RET_LEVELS. Stream type metadata is held in OKL_STRM_TYPE_B, temporary set data in OKL_AE_TMPT_SETS_ALL, and system accounting options in OKL_SYS_ACCT_OPTS. Product and contract-selection records come from OKL_PRODUCTS and OKL_RBK_SELECTED_CONTRACT. UTL_FILE is used for file-based logging, and FND_NEW_MESSAGES supports message construction. The package is not referenced by any database object, confirming its role as a leaf utility consumed by PL/SQL callers rather than by database constraints or triggers.

Usage Notes

OKL_STREAMS_UTIL is invoked indirectly through the lease management application. Because the ETRM metadata shows the package is referenced by 67 other packages, including OKL_STREAMS_PUB and OKL_STM_PVT, it is typically reached during contract booking, stream generation, accounting, and reporting flows rather than called from a form or concurrent program directly. Customizations should treat it as an internal utility and prefer public APIs such as OKL_STREAMS_PUB where available. Any extension must respect its dependency on FND_API error handling and the standard OKL message stack, and callers should supply validated contract and stream identifiers.