Results for “okl_streams_pub”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OKL_STREAMS_PUB is the public API package for Oracle Lease and Finance Management (OKL / ETRM) that manages lease and loan streams and their constituent stream elements. In Oracle EBS Release 12.1.1 and 12.2.2, streams represent the scheduled cash flow lines (payments, billings, accruals, and related financial events) that drive a contract's accounting and billing lifecycle. The package body implements the published interface through which forms, concurrent programs, and custom extensions create, maintain, validate, and retire these stream records without touching the underlying tables directly.
As a classified PUB package with owner APPS, OKL_STREAMS_PUB follows the standard Oracle Application Object Library (AOL) API conventions: it layers validation and error messaging over the private logic housed in OKL_STM_PVT and OKL_STREAMS_PVT, and it depends on FND_API, FND_MSG_PUB, OKC_API, and OKL_SEL_PVT. It exposes 25 documented procedures and functions and is referenced by 34 other database objects, confirming its role as a foundational, widely-consumed interface within the ETRM schema.
Key Procedures and Functions
The documented entry points fall into two functional groups.
- Stream-level operations: CREATE_STREAMS and CREATE_STREAMS_PERF (plus its performance-oriented variant) insert new stream headers; UPDATE_STREAMS modifies existing stream definitions; VALIDATE_STREAMS applies business-rule checks; LOCK_STREAMS obtains the concurrency control required before dependent changes; and DELETE_STREAMS removes stream records subject to referential and status rules.
- Stream-element operations: CREATE_STREAM_ELEMENTS, UPDATE_STREAM_ELEMENTS, and DELETE_STREAM_ELEMENTS manage the individual line items that make up a stream; VALIDATE_STREAM_ELEMENTS performs element-level validation; and LOCK_STREAM_ELEMENTS secures the elements for update.
Because the metadata documents procedure names only, parameter lists are intentionally not reproduced here. Consumers should obtain the exact signatures from the package specification in the target instance.
Tables Accessed
The documented table reference for the package body is PLITBLM (accessed through an APPS synonym), the PL/SQL table and index-by table support structure used by Oracle's standard runtime. All principal stream and stream-element DML is performed indirectly through the private packages OKL_STM_PVT and OKL_STREAMS_PVT, which own the physical inserts, updates, and deletes against the OKL stream tables. This indirection is deliberate: it keeps the public signature stable across releases while private logic evolves. Validation and message-queue processing is handled jointly by OKC_API and FND_MSG_PUB, and selection or lookup activity routes through OKL_SEL_PVT.
Usage Notes
OKL_STREAMS_PUB is normally invoked from Lease Management forms and from ETRM concurrent programs that generate or regenerate contract streams, rather than being called directly by end users. The typical call sequence is LOCK_STREAMS (or LOCK_STREAM_ELEMENTS), followed by the relevant CREATE, UPDATE, or DELETE call, with VALIDATE_STREAMS/VALIDATE_STREAM_ELEMENTS invoked to enforce contract rules before commit. Custom code and integrations should call only the public procedures, always check the returned FND_API-compatible status and inspect FND_MSG_PUB for error messages, and never write to the underlying stream tables directly. Because 34 objects depend on this package, signature and behavior changes introduced by patches or upgrades should be regression-tested against all calling programs before deployment.