Search Results create_streams_loan_restr

Overview

OKL_CREATE_STREAMS_PUB is the public application programming interface (API) within the Oracle Lease and Finance Management (OLFM) module of Oracle E-Business Suite that governs the creation of payment streams for lease and loan contracts. In ETRM terminology a "stream" represents the schedule of cash flows — rents, principal, interest, fees, and residuals — generated against a contract, book, or quote. This package orchestrates that generation logic across the various lifecycle events that require stream construction, including origination, restructuring, renewals, principal paydown, and variable interest processing. It is classified as a PUB package, meaning it is intended for external invocation by other APIs, concurrent programs, and forms rather than being called directly by end users. The package serves as the public wrapper around the private worker package OKL_CREATE_STREAMS_PVT, delegating the substantive business logic to the private layer while exposing a stable, supported interface to callers. The user's search term "okl_la_stream_pvt" is relevant because OKL_LA_STREAM_PVT appears in the dependency list as a referencing object, and its counterpart OKL_LA_STREAM_PUB also references this package, illustrating the tight coupling between the stream creation API and the Lease Accounting stream processing routines.

Key Procedures and Functions

The package exposes six documented procedures, each corresponding to a distinct stream-generation scenario:

• CREATE_STREAMS_LEASE_BOOK — Generates the payment streams associated with a lease contract for a specified book, applying the accounting and pricing rules configured for that book.
• CREATE_STREAMS_LOAN_BOOK — Performs the equivalent stream generation for loan-type contracts within a designated book.
• INVOKE_PRICING_ENGINE — Invokes the pricing engine to calculate rates, yields, and financial terms that drive the stream amounts before or during stream creation.
• CREATE_STREAMS_LEASE_RESTR — Creates streams for a lease contract undergoing restructuring, reflecting the revised payment terms produced by the restructuring process.
• CREATE_STREAMS_LOAN_RESTR — Creates streams for a loan contract undergoing restructuring, mirroring the lease restructuring logic for the loan side.
• CREATE_STREAMS_LEASE_QUOTE — Generates projected streams for a lease quotation, enabling pricing and yield analysis before the quote is converted to a live contract.

Parameter lists are deliberately omitted, as the ETRM metadata does not document them; callers should consult the package specification in the APPS schema for exact signatures.

Tables Accessed

The ETRM metadata does not enumerate base tables accessed directly by OKL_CREATE_STREAMS_PUB. Stream data is persisted primarily through the OLFM stream tables (the OKL_STREAMS_B and related interface entities) and manipulated via the dependent packages, notably OKL_CREATE_STREAMS_PVT, OKL_SIF_PVT, OKL_STREAM_INTERFACES_PUB, and the foundational OKL_API and OKC_API utility packages. The package also depends on FND_API for the standard EBS API return-status conventions and on OKL_STREAM_INTERFACES_PUB for interfacing stream records. Because the bulk of table access occurs in the private layer, customizations should not assume direct DML against stream tables by this package.

Usage Notes

OKL_CREATE_STREAMS_PUB is typically invoked indirectly. The dependency list shows it is referenced by seven OLFM packages, including OKL_GENERATE_STREAMS_PVT, OKL_AM_RESTRUCTURE_RENTS_PVT, OKL_CS_LEASE_RENEWAL_PVT, OKL_CS_PRINCIPAL_PAYDOWN_PVT, OKL_VARIABLE_INTEREST_PVT, and both OKL_LA_STREAM_PUB and OKL_LA_STREAM_PVT. These callers drive stream creation during contract booking, restructuring, renewal, paydown, and variable interest recalculation. In practice the package is reached through the OLFM contract and lease accounting forms (notably the stream generation and book assignment screens) and through concurrent programs that batch-process stream creation. Custom code should call the public procedures rather than the private OKL_CREATE_STREAMS_PVT equivalents to preserve upgrade compatibility. Standard FND_API error handling applies, so callers must check the returned status and message before committing. The package is valid in both 12.1.1 and 12.2.2, and the dependency chain through OKL_LA_STREAM_PUB and OKL_LA_STREAM_PVT confirms its central role in lease accounting stream processing.