Search Results okc_cnh_pvt




Overview
Explore in AI Chat

Overview

The APPS.OKC_CNH_PVT package body is a private (PVT) PL/SQL API within the Oracle E-Business Suite Contracts module (OKC). It encapsulates the low-level data manipulation, validation, concurrency control, and multi-language support logic for condition headers — the parent records that group contract terms, conditions, and entitlement rules defined in Oracle Contracts (formerly Oracle Contracts Core / OKC). As a private package, OKC_CNH_PVT is not intended for direct customer invocation; it sits beneath the public OKC_CNH API and the condition management forms, providing the reusable insert, update, delete, lock, version, and translation routines that the public layer and its internal callers depend upon.

The package is classified as VALID in the APPS schema under ETRM 12.2.2, and its structure is consistent with the standard Oracle EBS "table handler" pattern: a single private package centralising DML for the condition headers base table, its translation table, its audit and history tables, and its primary key sequence. Because OKC_CNH_PVT is referenced by 17 other packages while itself referencing no external custom objects, it functions as an internal implementation detail of the Contracts condition framework.

Key Procedures and Functions

The documented interface exposes the following procedures and functions (parameter lists are not reproduced here):

  • QC — an internal quality-check/validation helper, used to assert row-level consistency before committing condition header data.
  • CHANGE_VERSION / CREATE_VERSION / RESTORE_VERSION — versioning routines that create new revisions of a condition header and restore prior versions. These support the version-controlled editing model used throughout Oracle Contracts.
  • API_COPY — copies an existing condition header (and its associated attributes) as the basis for a new record or version.
  • ADD_LANGUAGE — inserts translated rows into the condition headers translation table for a specified language.
  • INSERT_ROW / UPDATE_ROW / DELETE_ROW — the core DML primitives for the condition headers base record.
  • INSERT_ROW_UPG — a variant of INSERT_ROW used during upgrade paths, preserving legacy key and attribute semantics.
  • LOCK_ROW — obtains a row lock (typically SELECT ... FOR UPDATE) to enforce optimistic concurrency control.
  • VALIDATE_ROW — performs business and referential validation against condition header attributes prior to persistence.

Tables Accessed

Dependencies confirm that the package reads and writes the following objects through APPS synonyms:

Usage Notes

OKC_CNH_PVT is invoked indirectly. The Oracle Contracts condition setup forms, the public OKC_CNH API, and internal EBS processes that manipulate condition headers call into these routines to create, version, translate, and validate header records. It is also referenced by 17 other packages, meaning any custom extension that manipulates condition headers should call the public OKC_CNH API rather than OKC_CNH_PVT directly, as the private interface carries no backward-compatibility guarantee and may change between point releases of EBS 12.1.1 and 12.2.2. During multi-language installations, ADD_LANGUAGE is exercised by the standard translation and language-installation concurrent programs. Version-related routines execute whenever a user creates or restores a contract condition version.