Search Results okl_create_streams_pvt




Overview
Explore in AI Chat

Overview

OKL_SIT_PVT is a private (PVT) PL/SQL package in the Oracle Lease and Finance Management (OLFM) module, owned by the APPS schema. It provides the internal data-access and validation layer for the OKL_SIF_STREAM_TYPES table, which stores the interface definitions that drive stream generation and stream type processing within OLFM. Because its identifier carries the PVT suffix, the package is classified as a private API: it is not intended for direct invocation by external or customer code, and Oracle reserves the right to change its internal structure between releases. Functionally it sits beneath the public stream-type API surface, supplying row-level locking, DML, and validation services to the packages that manage stream type and stream interface records.

The package is referenced by the same family of stream-processing packages that a user searching for okl_create_streams_pvt would be investigating, confirming its role as a shared dependency in the stream creation and purge chain.

Key Procedures and Functions

The package exposes the standard Oracle Application Object Library (AOL) private-API pattern plus a small number of utility routines. Documented program units include:

  • QC — A utility routine, typically used for internal consistency checking or quality control within the package.
  • CHANGE_VERSION — Manages versioning behavior for rows processed through the API, supporting the interface table lifecycle.
  • API_COPY — Copies a stream-type interface record, supporting duplication of stream type definitions.
  • INSERT_ROW — Inserts a new row into the stream type interface table.
  • LOCK_ROW — Obtains a row-level lock to serialize concurrent modification.
  • UPDATE_ROW — Updates an existing row in the interface table.
  • DELETE_ROW — Removes a row from the interface table.
  • VALIDATE_ROW — Applies business validation rules before committing or processing a row.

Parameter signatures are not reproduced here; callers should treat these procedures as internal and invoke them only through the supported public APIs that wrap them.

Tables Accessed

The package operates primarily on OKL_SIF_STREAM_TYPES, a core OLFM table holding stream interface/stream type definitions. Through standard APPS synonyms, references also resolve to OKL_SIF_STREAM_TYPES_V (the validation view) and to PLITBLM, an internal PL/SQL assertion/message table used by the OKL_API error-handling framework. Read and write activity is centered on maintaining accurate, validated stream type rows consumed by downstream stream generation logic.

Usage Notes

OKL_SIT_PVT is not called directly by users. It is invoked indirectly by public and private packages within the OLFM stream-processing stack, including OKL_CREATE_STREAMS_PVT (the object behind the searched term okl_create_streams_pvt), OKL_PURGE_STRM_INTF_PVT, OKL_SIF_STREAM_TYPES_PUB and its wrapper OKL_SIF_STREAM_TYPES_PUB_W, and its own C-layer wrapper OKL_SIT_PVT_W. These callers are reached through concurrent programs that create or purge lease streams, through the OLFM HTML forms that maintain stream type setup, and through integration flows loading interface records. Custom development should never call OKL_SIT_PVT procedures directly; instead it should invoke the corresponding public API, which delegates to this package after performing the required validation and security checks.