Search Results okl_generate_streams_pvt




Overview
Explore in AI Chat

Overview

OKL_GENERATE_STREAMS_PVT is a private PL/SQL package in the APPS schema that forms the core processing engine for generating stream records within Oracle E-Business Suite's Enterprise Trading and Risk Management (ETRM) module, specifically for the Oracle Lease and Finance Management (OKL) product. A stream represents an individual cash flow line — such as a periodic rental payment, an interest accrual, a tax amount, or a residual value — associated with a contract, lease, or financial instrument. The package's primary business function is to take header-level interface data and expand it into fully populated, priced stream records that are written to the stream interface tables and later validated and imported into the transactional schema.

The "_PVT" suffix indicates that this is a private, internal package not intended for direct invocation by external consumers. It is designed to be called exclusively by its public counterpart, OKL_GENERATE_STREAMS_PUB, which acts as the exposed API layer and handles validation, error propagation, and transaction control before delegating the substantive work to this private package.

Key Procedures and Functions

The documented package metadata lists three procedures, each fulfilling a discrete stage of the stream-generation process:

  • GENERATE_STREAMS — The orchestrating routine that drives the creation of stream records. It coordinates the overall generation flow, typically iterating over the input header information and producing the corresponding stream rows that will be persisted for subsequent pricing and validation.
  • POPULATE_HEADER_DATA — Responsible for assembling and populating the header-level data structures required before stream generation proceeds. This procedure prepares the driving context — for example, contract, stream type, and date-range attributes — that the rest of the package relies upon.
  • INVOKE_PRICING_ENGINE — Invokes the pricing engine so that generated streams carry calculated amounts and rates. This bridges the stream-generation activity to ETRM's pricing logic, ensuring streams are valued rather than left as unquantified placeholders.

This three-procedure structure reflects a clean separation of concerns: prepare the header context, generate the streams, then price them. No parameter lists are documented in the supplied metadata, and none are asserted here.

Tables Accessed

The package references two tables through APPS synonyms:

  • OKL_STREAM_INTERFACES — The principal working table. Generated stream records are written here as interface rows, where they await validation and import into the permanent stream tables. This table is central to the package's output.
  • WF_PARAMETER_LIST_T — The Oracle Workflow parameter list table, used to hold attribute values passed between the calling process and the pricing engine invocation and related workflow-driven processing.

The dependency metadata also confirms the package relies on OKL_SIF_PVT, OKL_STREAM_INTERFACES_PUB, OKL_API, and FND_API, indicating use of shared ETRM stream-interface utilities and the standard Oracle Application Object Library API error-handling framework.

Usage Notes

OKL_GENERATE_STREAMS_PVT is not called directly. The documented dependency information shows it is referenced by OKL_GENERATE_STREAMS_PUB, confirming that the public package is the supported entry point. Customizations and integrations should likewise call the public API, allowing the private package to remain an internal implementation detail subject to change between releases.

Typical invocation occurs when a user or process requests generation of streams for a lease or contract — for example, after contract booking or a pricing recalculation — through ETRM's standard concurrent programs, forms, or stream-interface workflows. Because ETRM is available in both EBS 12.1.1 and 12.2.2, the package exists in either release, though the internal implementation may differ even where the documented interface is unchanged.