Search Results create_streams_loan_book

Overview

The APPS.OKL_CREATE_STREAMS_PUB package body is a public API within the Oracle E-Business Suite Lease Management (OKL) module, part of the Enterprise Territory and Revenue Management (ETRM) product family. Its principal business function is the creation of financial streams — the periodic rents, expenses, fees, yields, and other cash flow elements — that constitute the economic substance of a lease or loan contract. In lease accounting and contract management, a "stream" represents a scheduled movement of value across time; the streams generated by this package feed downstream pricing, accounting, and revenue recognition processes.

The package is explicitly designed as a "public wrapper" layer. As documented in the source header for Create_Streams_Lease_Book, the procedure is described as a "Public Wrapper for Create_Streams_Lease_Book Process API," indicating that the package exposes a stabilized, externally callable interface that delegates to underlying process APIs. This wrapper pattern is standard in ETRM, shielding callers from internal implementation changes while enforcing consistent API-version and message-list handling conventions (via Okl_Api.START_ACTIVITY).

Key Procedures and Functions

The package exposes six documented public procedures:

• CREATE_STREAMS_LEASE_BOOK — The primary entry point for generating financial streams associated with a lease contract. It accepts a lease header record, one-off fee, periodic expense, yield, stream type, line detail, and rents collections, and returns a transaction identifier and transaction status alongside standard return status and message outputs. It is the object most commonly associated with the search term create_streams_lease_book.
• CREATE_STREAMS_LOAN_BOOK — The loan analogue of the lease-book procedure, generating streams for loan-type contracts.
• INVOKE_PRICING_ENGINE — Invokes the pricing engine to compute or refresh pricing for the streams being created.
• CREATE_STREAMS_LEASE_RESTR — Handles stream creation for lease contracts subject to restructuring.
• CREATE_STREAMS_LOAN_RESTR — Handles stream creation for loan contracts subject to restructuring.
• CREATE_STREAMS_LEASE_QUOTE — Generates streams in a quotation context, prior to contract booking.

All procedures follow the ETRM public API standard signature pattern, including API version, initialization flag, skip-pricing-engine flag, and standardized return status and message parameters.

Tables Accessed

The ETRM metadata does not enumerate the specific base tables referenced by this package, noting only that access occurs via APPS synonyms. Functionally, stream creation logic in OKL typically reads and writes the contract header and line tables (OKL_TRX_CONTRACTS and its line/stream children), stream and stream-type definition tables, and pricing/yield related tables used during stream generation. Because the package is a public wrapper, direct DML is generally confined to the underlying process APIs it calls rather than to the wrapper procedures themselves.

Usage Notes

OKL_CREATE_STREAMS_PUB is intended for invocation from Oracle Forms, concurrent programs, and custom PL/SQL code that must create or regenerate contract streams programmatically. The package is referenced by seven other packages within the ETRM schema, confirming its role as a shared infrastructure component. Callers should pass a valid API version (the wrapper enforces version 1 internally), supply the appropriate collection types for fees, expenses, yields, and line details, and inspect the returned transaction identifier, transaction status, and message stack to confirm success. When stream regeneration is required, the pricing engine invocation may be skipped via the skip-pricing-engine flag to avoid redundant computation.