Search Results okl_process_streams_pvt




Overview
Explore in AI Chat

Overview

OKL_VARIABLE_INTEREST_PUB is a public PL/SQL API package in the APPS schema that supports variable interest rate processing within Oracle Lease and Finance Management, part of the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 release streams. In lease and loan contracts, interest terms are frequently tied to floating or variable indices rather than to a fixed rate. This package provides the entry points needed to evaluate and apply variable interest to contract streams so that payment schedules, cash flows, and accounting distributions reflect the correct rate over the life of the instrument. As a "PUB" classified package, it is intended as a supported, externally callable API rather than an internal implementation package, which means other product modules, extensions, and custom integrations may invoke it directly.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents two callable units within this package:

  • VARIABLE_INTEREST — The primary program unit exposed by the package. It encapsulates the business logic for evaluating and applying variable interest to lease contract data, allowing callers to initiate variable interest processing without directly manipulating the underlying rate or stream records.
  • Package specification/body entry — The package itself is listed as a documented object with both a specification and body present and a status of VALID, confirming the API is compiled and available for runtime invocation.

Because the documented metadata lists only the VARIABLE_INTEREST procedure, no parameter signatures are asserted here. Consumers should inspect the package specification in the APPS schema or the ETRM API documentation for the exact argument list before coding calls.

Tables Accessed

The extracted documentation does not enumerate specific base tables. Instead, the package references other PL/SQL APIs through which the table access is performed. The documented dependencies include OKL_CREATE_STREAMS_PVT, OKL_PROCESS_STREAMS_PVT, OKL_SRL_PVT, and OKC_API. Streams records in ETRM are the fundamental mechanism for storing contractual cash flow and rate information, so variable interest logic necessarily reads and updates stream data through these private packages rather than via direct DML.

Usage Notes

OKL_VARIABLE_INTEREST_PUB is typically invoked during contract processing when a variable or floating interest rate must be re-evaluated — for example, during stream generation, rate resets, or repricing of existing contracts. It is most commonly called indirectly: the dependency metadata shows that OKL_VARIABLE_INTEREST_PUB both references and is referenced by OKL_PROCESS_STREAMS_PVT, indicating a tight coupling during stream processing. This is directly relevant to the searched term "okl_process_streams_pvt," since that package is a primary consumer and collaborator of the variable interest API. The package may also be reached from ETRM forms or concurrent programs that drive contract and stream maintenance, and from custom code that needs to trigger variable interest evaluation in an extension. Because it delegates to the OKL private APIs, invoking it ensures that the standard validation, stream creation, and SRL handling logic is respected, making it preferable to direct table updates for supported implementations.