Search Results okl_stream_interfaces_pub




Overview
Explore in AI Chat

Overview

OKL_SIF_PVT is a private PL/SQL package in the APPS schema belonging to the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite. The suffix _PVT identifies it as an internal implementation package rather than a published API; the corresponding public entry point is OKL_STREAM_INTERFACES_PUB, which is the object users typically search for under the name "okl_stream_interfaces_pub." The package serves the stream interface staging area of ETRM, the subsystem that captures, validates, and stages lease stream (payment and billing schedule) data before it is processed into contract streams.

The package is classified as a PVT-layer object, meaning it holds the procedural logic, row-level DML, and validation rules that the public API layer delegates to. Business users never call OKL_SIF_PVT directly; it is invoked by the public wrappers and by other private packages in the stream processing chain.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents thirteen procedures and functions. The principal ones are:

  • INSERT_ROW — inserts a new record into the stream interfaces staging table, populating the sequence-derived primary key and defaulting attributes.
  • UPDATE_ROW — applies changes to an existing staged interface record.
  • DELETE_ROW — removes a staged interface record, typically used when a user or process discards an invalid row prior to processing.
  • LOCK_ROW — acquires a row-level lock to serialize concurrent modifications during processing.
  • VALIDATE_ROW — enforces business and data-integrity rules against a staged row, returning validation errors to the caller.
  • API_COPY — copies an interface row, supporting duplication and re-staging scenarios.
  • CHANGE_VERSION — performs optimistic concurrency control, verifying or advancing the version indicator on a row before update.
  • QC — a quality-check routine invoked as part of the validation and processing flow.

The remaining documented routines complete the standard CRUD and validation set used by the public API layer.

Tables Accessed

Through APPS synonyms, OKL_SIF_PVT reads and writes:

  • OKL_STREAM_INTERFACES — the primary staging table holding stream interface records; this is the central object of the package's DML.
  • OKL_STREAM_INTERFACES_V — a view over the interface table used for validated or joined reads.
  • OKL_SIF_SEQ — the sequence supplying primary keys for new interface rows.
  • JTF_OBJECTS_B — the shared object registry used for entity identification and reference metadata.
  • DUAL — used for scalar expression evaluation.
  • PLITBLM — the PL/SQL integer table type used for bulk processing and list handling.

The package also depends on the FND_API, OKC_API, and OKL_API foundation packages for standard API error handling and message retrieval.

Usage Notes

OKL_SIF_PVT is invoked indirectly. The public package OKL_STREAM_INTERFACES_PUB and its _W wrapper version call it, as do OKL_CREATE_STREAMS_PUB, OKL_CREATE_STREAMS_PVT, OKL_GENERATE_STREAMS_PVT, OKL_PROCESS_STREAMS_PVT, OKL_INVOKE_PRICING_ENGINE_PUB/PVT, OKL_POPULATE_PRCENG_RESULT_PUB/PVT, OKL_POPULATE_PRCENG_RST_PUB, OKL_PRCTIMEOUT_PVT, and OKL_PURGE_STRM_INTF_PVT. These are reached from ETRM concurrent programs such as stream generation and pricing engine invocation, and from the Lease Management forms when interface rows are maintained on-screen.

Customizations should call OKL_STREAM_INTERFACES_PUB rather than OKL_SIF_PVT, since the private package signature is not guaranteed across patches and is expected to change between 12.1.1 and 12.2.2 releases.