Search Results okc_cpl_pvt




Overview
Explore in AI Chat

Overview

OKC_CPL_PVT is a private (PVT) PL/SQL package body in the APPS schema that supports the Oracle Contracts Core module of Oracle E-Business Suite, specifically the party-role and copy/versioning logic used by contract headers, lines, and their associated role assignments. In the EBS architecture, the OKC_CPL_PVT package operates as a supporting implementation layer for the public contract APIs (notably OKC_API), and it is referenced by 26 other packages, indicating its utility is broadly consumed across contract workflows. Its API classification as "PVT" indicates the package is not intended for direct invocation by end users or external integrations; rather it exposes internal helper routines that construct, validate, and maintain contract party-role records.

Key Procedures and Functions

The documented procedures and functions in OKC_CPL_PVT (17 total, with 12 named in the metadata) fall into several functional categories:

The presence of a RESTORE_VERSION alongside CREATE_VERSION and CHANGE_VERSION indicates the package supports the contract versioning model whereby prior versions can be reinstated.

Tables Accessed

OKC_CPL_PVT reads and writes a focused set of contract tables via APPS synonyms. OKC_K_HEADERS_ALL_B is the base table for contract headers; OKC_K_LINES_B stores contract lines; OKC_K_PARTY_ROLES_B and its translation table OKC_K_PARTY_ROLES_TL, together with the history tables OKC_K_PARTY_ROLES_BH and OKC_K_PARTY_ROLES_TLH, form the core party-role data model. FND_LANGUAGES supplies the installed language list used by ADD_LANGUAGE. OKC_LINE_STYLE_ROLES, OKC_ROLE_SOURCES, and OKC_SUBCLASS_ROLES participate in role derivation and line-level role rules. PLITBLM is an Oracle-supplied index-organized table used by DATE/time utilities. The presence of the history (_BH, _TLH) and translation (_TL) tables confirms the package enforces date-tracked and multilingual-aware writes.

Usage Notes

Because OKC_CPL_PVT is a private package, it is not documented for direct customer invocation. It is called internally by OKC_API and by the 26 dependent packages identified in the ETRM dependency tree. In practice, its routines are triggered from the Contract Management forms (OKC_* forms) when a user creates, copies, or versions a contract and when party roles are added or modified on a contract. The validation and lock-row primitives support concurrency handling typical of the OAF/Forms stack. The INSERT_ROW_UPG routine indicates that the package participates in the EBS upgrade path from 11i through 12.1.1 into 12.2.2. Custom code and integrations should not call OKC_CPL_PVT directly; the public OKC_API and related public interfaces should be used instead, since the private signatures are not guaranteed stable across patch levels.