Search Results insert_row_perf

Overview

OKL_STM_PVT is a private PL/SQL package in the Oracle E-Business Suite (EBS) Release 12.1.1 / 12.2.2 environment, owned by the APPS schema. It belongs to the Oracle Lease and Finance Management (OKL) module and operates on the OKL_STREAMS table, which stores stream header records generated by lease and financing transactions. The package is classified as a PVT (private) API, meaning it is designed for internal consumption by other OKL packages and forms rather than as a public integration interface. Its source header (OKLSSTMS.pls) and the record structures it declares indicate that OKL_STM_PVT encapsulates the low-level data manipulation logic for stream records — creating, updating, copying, validating, locking, and deleting rows — while centralizing the row-type definitions used throughout the streams processing layer.

Key Procedures and Functions

• INSERT_ROW — Inserts a new stream record into OKL_STREAMS from the package's stream record structure.
• INSERT_ROW_PERF — A performance-oriented variant of INSERT_ROW, used when high-volume stream creation must avoid the overhead of the standard insert path. The query term "insert_row_perf" corresponds to this procedure.
• UPDATE_ROW — Updates an existing stream record identified by its primary key, applying changed column values.
• DELETE_ROW — Removes a stream record from OKL_STREAMS.
• LOCK_ROW — Acquires a row-level lock on a stream record to serialize concurrent modifications.
• VALIDATE_ROW — Performs validation logic on a stream record before it is persisted, enforcing business rules.
• QC — A query/check routine that verifies whether a record exists or matches expected criteria.
• CHANGE_VERSION — Manages the OBJECT_VERSION_NUMBER column to support optimistic locking and version tracking.
• API_COPY — Duplicates a stream record, typically to support versioning or copy-forward of lease streams.

Tables Accessed

• OKL_STREAMS — The primary base table; all insert, update, delete, lock, and validation operations target this table.
• DUAL — Used for single-row evaluations such as sequence lookups, version checks, and existence tests.
• PLITBLM — The PL/SQL index-by table utility, used to convert and manage the index-by-table structures (stm_tbl_type) declared in the package's global section.

Usage Notes

As a private API, OKL_STM_PVT is not intended for direct invocation by external or custom applications. It is referenced by 36 other packages within the OKL module, which delegate stream row manipulation to it, and it is invoked from the Oracle Forms layer when users maintain stream records in the Lease and Finance Management responsibility. The presence of both INSERT_ROW and INSERT_ROW_PERF reflects tuning for bulk stream generation performed by concurrent programs and batch processes. Customizations should call the public OKL APIs rather than OKL_STM_PVT, since its signatures and record types are subject to change without notice. The package uses AUTHID CURRENT_USER, so privileges are resolved against the calling schema, typically APPS.