Search Results okc_sai_pvt




Overview
Explore in AI Chat

Overview

OKC_SAI_PVT is a private PL/SQL package body owned by the APPS schema within Oracle E-Business Suite, belonging to the Contract Management (OKC) module family. The three-letter suffix "SAI" denotes its specialization in Standard Article Installments, the contractual clauses that govern recurring payment, billing, or delivery schedules attached to a contract template or contract. In ETRM terminology the package is classified as a PVT (private) API, meaning it is intended for internal consumption by the OKC public API layer, in particular OKC_API, rather than for direct invocation by external integrations. The package encapsulates the low-level DML, concurrency control, and validation logic that backs the Standard Article Installments entity, exposing it to the public API while keeping the physical table access and row-locking mechanics hidden. Its status is VALID, indicating the compiled body is present and operational in the documented 12.1.1 and 12.2.2 environments. The dependency metadata confirms that OKC_SAI_PVT references OKC_API and OKC_SAI_PVT itself, a pattern indicative of a layered, self-referencing API stack.

Key Procedures and Functions

Fourteen documented units form the public interface of this body. The core CRUD routines are INSERT_ROW, UPDATE_ROW, and DELETE_ROW, which respectively create, modify, and remove Standard Article Installment records in the underlying tables. LOCK_ROW performs the concurrency-control duty of selecting a row FOR UPDATE and verifying that the caller holds the current version before allowing a write. VALIDATE_ROW executes entity-level validation, while VALIDATE_UNIQUE enforces uniqueness constraints on the installment definition. CHANGE_VERSION and API_COPY support versioning and cloning of installment definitions, enabling contract templates to be replicated or revised without manual re-entry. The remaining documented units support internal orchestration and error handling. Parameters follow standard OKC private API conventions (row identifiers, version numbers, and an out parameter for the return status), but no parameter lists are reproduced here because they are not part of the documented metadata.

Tables Accessed

The package operates against two base tables and one view. OKC_STD_ARTICLES_B is the base table holding Standard Article headers, and OKC_STD_ART_INCMPTS stores the associated installment/incompatibility records. OKC_STD_ART_INCMPTS_V is the view through which installment data is read, typically joining language or translation columns. PLITBLM, a public synonym over a PL/SQL internal table type owned by PUBLIC, is used for bulk processing or array handling. All access occurs through APPS synonyms, ensuring the package remains portable across the 12.1.1 and 12.2.2 schemas.

Usage Notes

OKC_SAI_PVT is not referenced by any database object per the metadata, but it is referenced by two other packages, most notably OKC_API. Its routines are therefore invoked indirectly when users define or maintain payment schedules through Contract Management forms, when concurrent programs generate or refresh standard articles, or when custom code calls the OKC public API. Direct invocation is discouraged; developers should route through OKC_API, which in turn delegates to this private layer and maps raised exceptions to the FND_API message stack.