Search Results okc_contract_pvt_w




Overview
Explore in AI Chat

Overview

The APPS.OKC_CONTRACT_PVT_W package is a private wrapper package within the Oracle E-Business Suite Contracts (OKC) module. Its naming convention, ending in the _PVT_W suffix, indicates that it functions as the private-layer implementation exposed through the public Contracts API surface. In Oracle EBS 12.1.1 and 12.2.2, the OKC schema underpins the Contract Lifecycle Management (CLM) and core Contracts functionality used by purchasing, sales, and legal contracting flows.

The package serves as the programmatic entry point through which higher-level public APIs (notably OKC_CONTRACT_PVT) delegate their business logic. It encapsulates the transactional processing required to create, modify, delete, lock, and validate contract entities. Internally it depends on Oracle Application Object Library primitives such as FND_API and on the standard JTF PL/SQL collection types, confirming an adherence to the EBS API design pattern of returning status codes and message stacks.

Key Procedures and Functions

The package exposes 51 documented procedures and functions organized into logical groups aligned with contract object types.

Across each family, the pattern is consistent: a create routine, an update routine, a delete routine, a locking routine to prevent concurrent modification, and a validation routine that enforces business rules before persistence.

Tables Accessed

The ETRM metadata does not enumerate specific base tables referenced through APPS synonyms for this package. However, given the procedural scope, the package writes to and reads from the core OKC tables, including contract headers, contract lines, contract governance records, and process association tables, along with the underlying OKC_ intersection and reference tables that store hierarchy and version history. Collection parameters are passed using the JTF table types (JTF_VARCHAR2_TABLE_100/200/300/500/600, JTF_NUMBER_TABLE, JTF_DATE_TABLE), which are standard EBS mechanisms for bulk attribute transfer.

Usage Notes

OKC_CONTRACT_PVT_W is a private package and is not intended for direct invocation by customers. Documentation lists it as referenced by OKC_CONTRACT_PVT and referencing zero other packages, positioning it as a mid-tier dependency. In practice it is invoked indirectly through the public Contracts APIs, from the Contracts Forms UI (OKC forms), and from concurrent programs that perform bulk contract import, validation, or archive operations. Customizations that attempt to call this package directly risk breakage during patching, since private wrappers may change without notice between 12.1.1 and 12.2.2. Developers should target the public OKC_CONTRACT_PVT and OKC_CONTRACT_PUB APIs instead.