Search Results oke_chr_pvt




Overview
Explore in AI Chat

Overview

OKE_CHR_PVT is a private PL/SQL package in the APPS schema that supports the Oracle Contracts (OKE) module, specifically the contract header repository and its associated versioning and copy logic. As a package classified as PVT (private), it is not exposed as a public API and is intended for internal consumption by other contract packages. Its primary responsibility is to manage the persistence, validation, and re-versioning of contract header records, providing the low-level row manipulation routines that public and shared packages build upon. In Oracle EBS 12.1.1 and 12.2.2, this package forms part of the plumbing behind contract authoring, amendment, and duplication features, ensuring that header data is consistently inserted, updated, validated, and version-tracked within the contract repository.

Key Procedures and Functions

The package exposes a set of ten documented procedures and functions, several of which are listed in the ETRM metadata. These fall into two functional categories: row-level data manipulation and API/version management.

  • INSERT_ROW — Inserts a new contract header row into the repository, applying defaulting and standard contract header attributes.
  • UPDATE_ROW — Updates an existing contract header row, typically invoked during amendment or correction of contract terms.
  • DELETE_ROW — Removes a contract header row, supporting cleanup and purge operations.
  • VALIDATE_ROW — Performs validation checks on the header data before it is persisted, enforcing contract business rules.
  • CHANGE_VERSION — Manages the version progression of a contract header, supporting the versioning model that underpins contract amendments.
  • API_COPY — Copies contract header data, enabling duplication of an existing contract as the basis for a new one.

The package also references the FND_API and OKE_API packages, indicating that it participates in the standard Oracle application API error-handling and messaging model, using the common FND_API messaging conventions for status and error reporting.

Tables Accessed

Through APPS synonyms, OKE_CHR_PVT reads and writes several core contract tables. The primary target is OKE_K_HEADERS and its base table OKC_K_HEADERS_B, which store contract header information. OKE_K_TYPES_B is consulted to determine the contract type and its associated attributes, while OKE_PROGRAMS supports program or template associations. PA_PROJECTS_ALL is referenced to link contracts to Oracle Projects data, and PLITBLM is a standard Oracle PL/SQL table used for in-memory collection handling. These tables reflect the package's role in binding contract headers to their type definitions and, where applicable, to project data.

Usage Notes

OKE_CHR_PVT is a private package and should not be called directly from custom code; Oracle recommends using the public APIs. It is referenced by the shared package OKE_CHR_PVT itself, the public contract APIs OKE_CONTRACT_PUB and OKE_CONTRACT_PVT, OKE_IMPORT_CONTRACT_PUB, and OKE_KCOPY_PKG. This dependency pattern confirms its role as a foundational layer invoked during contract creation, amendment, copying, and import operations, whether through the Contracts forms, concurrent programs, or public API calls. Customizations should target the public API layer rather than this private package, which may change between releases.