Search Results okl_sif_seq




Overview
Explore in AI Chat

Overview

OKL_SIF_PVT is a private API package body in the Oracle E-Business Suite Applications schema (APPS), operating within the Oracle Lease and Finance Management (OLFM) module formerly known as Oracle Contracts for Leases. The package name follows Oracle's naming convention, where "OKL" identifies the Lease Management product and "SIF" denotes Stream Interface functionality. The PVT suffix classifies the package as a private, internal utility rather than a public, externally callable API. It underlies the OKL_STREAM_INTERFACES object, which supports the creation, maintenance, and processing of stream interface records that feed lease-related cash flow and accounting stream generation. The package is valid in both Oracle EBS 12.1.1 and 12.2.2 and is marked as an internal API classification within the ETRM documentation.

Key Procedures and Functions

The package body exposes 13 documented procedures and functions covering the full row-level lifecycle of stream interface data:

  • QC — Performs quality control or consistency validation of stream interface records prior to processing.
  • CHANGE_VERSION — Manages object version tracking, ensuring concurrency control across interface rows.
  • API_COPY — Copies stream interface records, supporting replication or template-based record creation.
  • INSERT_ROW — Creates new stream interface records within OKL_STREAM_INTERFACES.
  • LOCK_ROW — Acquires a lock on a specific row to prevent concurrent modification during transactional processing.
  • UPDATE_ROW — Modifies existing stream interface records with validated attribute changes.
  • DELETE_ROW — Removes stream interface records, typically during cleanup or reversal processing.
  • VALIDATE_ROW — Applies business rule validation, leveraging OKC_API, OKL_ACCOUNTING_UTIL, and OKC_P_UTIL, before a row is committed.

These routines follow the standard Oracle API pattern of a private body supporting a public wrapper, with error handling routed through FND_API and APP_EXCEPTIONS.

Tables Accessed

The package references several tables via APPS synonyms:

  • OKL_STREAM_INTERFACES and OKL_STREAM_INTERFACES_V — The primary interface and view objects manipulated by the row-level procedures.
  • OKL_SIF_SEQ — The stream interface sequence generator, which supplies primary key values for new rows. This sequence is the reason a search for "okl_sif_seq" resolves to this package.
  • JTF_OBJECTS_B — Provides object registration metadata used in versioning and reference integrity.
  • DUAL and PLITBLM — Utility objects used for single-row queries and PL/SQL table operations.
  • OKL_K_HEADERS_V — Supplies lease header context for validation and stream linkage.

Usage Notes

Because OKL_SIF_PVT is a private package, it is not intended for direct invocation by external applications. It is typically called by public OLFM APIs, concurrent programs that process stream interfaces, and internal forms logic. The package depends on OKC_API, OKL_API, OKL_ACCOUNTING_UTIL, and OKL_STREAM_INTERFACES, and is referenced by approximately 14 other database objects. Customizations should interact with the corresponding public OKL stream interface API rather than calling OKL_SIF_PVT directly, since Oracle may change private package signatures without notice during patching or upgrade.