Search Results oks_khr_pvt




Overview
Explore in AI Chat

Overview

OKS_KHR_PVT is a private (PVT-classified) PL/SQL package body residing in the APPS schema and documented as VALID in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the Oracle Knowledge Management / Service Contracts family of modules (the OKS and OKC prefixes) and provides the internal implementation layer for service contract header processing. The package exposes an Application Programming Interface for creating, copying, locking, updating, deleting, and validating contract header records, while also enforcing version control and multi-org security. Because it is a private package, its procedures are not intended for direct customer invocation; rather, they are consumed by related public APIs, private helpers such as OKS_WF_K_PROCESS_PVT, and higher-level contract authoring logic. The body depends on standard EBS foundation packages including FND_API, FND_GLOBAL, FND_MSG_PUB, and APP_EXCEPTIONS, confirming that it participates in the standard EBS API error-handling and message-stack conventions.

Key Procedures and Functions

The documented interface contains eighteen procedures and functions. The principal entry points are:

  • API_COPY — duplicates an existing contract header, including its associated role and party relationships, to create a new contract record.
  • INSERT_ROW — inserts a new contract header row into the base table, applying defaults and validation.
  • UPDATE_ROW — modifies an existing contract header, typically preceded by a lock to prevent concurrent updates.
  • DELETE_ROW — removes a contract header record, subject to business-rule validation.
  • LOCK_ROW — acquires a row-level lock on a contract header to serialize updates.
  • VALIDATE_ROW — evaluates the contract header against business rules and raises API errors on violation.
  • CHANGE_VERSION — increments or otherwise manages the version indicator on a contract header.
  • QC — a quality-control helper used to assert preconditions and postconditions internally.

The remaining procedures are private helpers supporting these operations. Parameter lists are intentionally not published because the package is Private-classified.

Tables Accessed

OKS_KHR_PVT reads and writes the following tables via APPS synonyms:

Usage Notes

OKS_KHR_PVT is not referenced by any database object and is not a public API. It is invoked indirectly through the Service Contracts forms, through the OKC public APIs that delegate to it, and through OKS_WF_K_PROCESS_PVT during workflow-driven contract processing. Customizations should call the corresponding OKC or OKS public API rather than OKS_KHR_PVT directly. It is referenced by fourteen other packages in the same module.