Search Results okl_populate_prceng_result_pub




Overview
Explore in AI Chat

Overview

OKL_SIR_PVT is an internal (private) PL/SQL package in the Oracle E-Business Suite Applications schema (APPS) belonging to the Oracle Lease and Finance Management (OLFM/OKL) module, an integrated component of the ETRM (Enterprise Contracts and Trade Management) family. The package name follows Oracle's naming convention where the _PVT suffix denotes a private implementation package that is normally not invoked directly by external callers, but is instead exposed through a public wrapper package. OKL_SIR_PVT supports the Stream Interface Requests (SIR) functionality, which governs the interface into lease and finance management streams. The package encapsulates the core row-level data manipulation and validation logic for the OKL_SIF_RETS table (Stream Interface Requests), providing a standardized foundation of private procedures that public API packages call to create, maintain, lock, validate and delete SIR records. By centralizing this logic, it enforces consistency across the many online forms, concurrent programs and public APIs that manipulate stream interface data.

Key Procedures and Functions

The documented package exposes a family of procedures and functions (13 recorded in total) that provide the standard private-API surface for a table-driven Oracle package:

  • QC — The quality-control routine that serves as the standard internal entry point for validating and processing a single SIR record.
  • CHANGE_VERSION — Manages object version control, ensuring that concurrent updates maintain a consistent version identifier on SIR records.
  • API_COPY — Copies SIR record data, typically to populate or duplicate interface rows during processing.
  • INSERT_ROW — Performs the actual insert of a new SIR record into the underlying table.
  • LOCK_ROW — Acquires a lock on a SIR record so it cannot be modified concurrently.
  • UPDATE_ROW — Writes updated column values to an existing SIR record.
  • DELETE_ROW — Removes a SIR record from the table.
  • VALIDATE_ROW — Applies business-rule validation to a SIR record before it is committed.

These procedures do not represent public API entry points; they are invoked by the wrapping public package, which supplies the parameter lists and orchestrates transactional flow.

Tables Accessed

The package reads and writes the following tables, referenced through APPS synonyms:

  • OKL_SIF_RETS — The Stream Interface Requests table, the primary subject of the package's insert, update, delete, lock and validate operations.
  • OKL_STREAM_INTERFACES — The parent stream interface definition table, referenced to establish the relationship between a stream interface and its request rows.
  • PLITBLM — A standard Oracle EBS PL/SQL table used for in-memory array processing.
  • DUAL — The Oracle single-row utility table, used for single-value queries and version lookups.

The same logic is also exposed through the OKL_SIF_RETS_V view, which may be used to read consistent record representations.

Usage Notes

OKL_SIR_PVT is not intended for direct invocation by customers or external integrations. It is invoked internally by the public packages that wrap it, notably OKL_POPULATE_PRCENG_RESULT_PUB, OKL_POPULATE_PRCENG_RESULT_PVT, OKL_POPULATE_PRCENG_RST_PUB, OKL_PROCESS_STREAMS_PVT, OKL_PURGE_STRM_INTF_PVT, OKL_SIF_RETS_PUB, OKL_SIR_PVT_W and OKL_SIR_PVT_W (versions). These callers are associated with the pricing engine result population, stream processing, and stream interface purge functions of Lease and Finance Management. Because the package is private, customizations should use the corresponding public APIs rather than calling OKL_SIR_PVT directly, preserving upgrade safety. The package depends on FND_API, OKC_API and OKL_API for standard error-handling and validation services, and on OKL_SIR_PVT_W for versioning support.