Search Results okl_stm_pvt




Overview
Explore in AI Chat

Overview

OKL_STM_PVT is a private (PVT) PL/SQL package body in the APPS schema that supports the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite. Its name reflects its role as the primary private implementation layer for lease stream ("STM") processing—the streams that drive payment schedules, billing, and generating accounting entries for a lease contract. Because it is classified as a private API, it is intended for internal ETRM use rather than direct customer invocation; public access is normally channeled through the OKL_STM_PUB or related public packages. The package body is documented as VALID and depends on a broad set of ETRM infrastructure, including FND_API, OKL_API, OKC_API, OKL_ACCOUNTING_UTIL, and the stream views OKL_STREAMS_V and OKL_STRM_TYPE_V. Although the metadata states "APPS.OKL_STM_PVT is not referenced by any database object," the ETRM 12.2.2 documentation notes it is referenced by 36 other packages, confirming its role as a foundational private component consumed throughout the lease stream processing stack.

Key Procedures and Functions

The documented interface contains 14 procedures and functions. The core CRUD routine set consists of INSERT_ROW, INSERT_ROW_PERF (a performance-optimized insertion variant), UPDATE_ROW, LOCK_ROW, DELETE_ROW, and VALIDATE_ROW. These manage the lifecycle of lease stream rows: selecting and locking a record for concurrent update, performing referential and business-rule validation, and persisting inserts, updates, and deletes. CHANGE_VERSION supports the API's row-versioning/optimistic-locking convention, while API_COPY duplicates stream data, which is typical when a lease is copied, versioned, or rebooked. QC appears to be a quality-control or consistency-check utility that verifies stream data integrity. Because these are private implementations, parameter signatures are not published; the documented procedures are internal building blocks called by the package's own logic and by the 36 dependent packages.

Tables Accessed

The documented tables referenced through APPS synonyms are OKL_STREAMS, DUAL, and PLITBLM. OKL_STREAMS is the primary transactional table, holding the lease payment and billing streams written by INSERT_ROW, UPDATE_ROW, and DELETE_ROW, locked by LOCK_ROW, and validated by VALIDATE_ROW. DUAL is used for single-row lookups and expression evaluation. PLITBLM is the PL/SQL integer table type used to pass collections of row identifiers or batch keys, supporting the bulk/performance insertion path (INSERT_ROW_PERF) and QC checks. The dependency list also shows reads against the views OKL_K_HEADERS_V, OKL_K_LINES_V, OKL_STREAMS_V, and OKL_STRM_TYPE_V, which supply contract header, contract line, stream, and stream-type context during validation.

Usage Notes

OKL_STM_PVT is not intended for direct customer calls. It is normally invoked from the public OKL stream APIs, the ETRM Oracle Forms UI, concurrent programs that generate or regenerate lease streams, and accounting event processing via OKL_ACCOUNTING_UTIL. Customizations should call the corresponding public API rather than OKL_STM_PVT, since its private interface can change without notice. When troubleshooting stream behavior, this package appears in the dependency chain of 36 ETRM packages and should be enabled for PL/SQL debugging in development environments only.