Search Results okc_contract_group_pvt




Overview
Explore in AI Chat

Overview

The APPS.OKC_CGP_PVT package is a private PL/SQL API belonging to the Oracle Contracts (OKC) product family within Oracle E-Business Suite. It serves as the internal implementation layer for managing contract groups — the logical groupings used to associate related contracts, templates, and terms for reporting, authorization, and lifecycle management. The classification "PVT" indicates that the package is intended for internal consumption by the public API layer rather than for direct customer invocation; the public-facing entry points are exposed through OKC_CONTRACT_GROUP_PUB and OKC_CONTRACT_GROUP_PVT, both of which delegate to OKC_CGP_PVT for their core row-level processing.

The package encapsulates the standard EBS multi-org, multi-language, and concurrency-safe data manipulation patterns required to maintain contract group records across the base table OKC_K_GROUPS_B and its translation table OKC_K_GROUPS_TL. It reuses the FND_API error-handling framework and OKC_API conventions, ensuring consistent message propagation and versioning behaviour across the Contracts module.

Key Procedures and Functions

  • QC — Quality-control routine used internally to validate consistency and support the API's internal state checks.
  • CHANGE_VERSION — Manages optimistic concurrency by updating the record's version number when a contract group is modified.
  • API_COPY — Copies an existing contract group definition, supporting duplication scenarios during contract creation or template replication.
  • ADD_LANGUAGE — Inserts translated rows into the translation table for a newly installed or added language.
  • INSERT_ROW — Creates a new contract group record in the base table.
  • LOCK_ROW — Acquires a row-level lock to prevent concurrent modification.
  • UPDATE_ROW — Modifies an existing contract group record.
  • DELETE_ROW — Removes a contract group record.
  • VALIDATE_ROW — Performs the master validation logic prior to insert, update, or delete.
  • VALIDATE_NAME — Checks that the contract group name is present and unique where required.
  • VALIDATE_PUBLIC_YN — Validates the public/private flag governing group visibility.
  • VALIDATE_SHORT_DESCRIPTION — Validates the short description attribute.
  • VALIDATE_RECORD — Combined record-level validation invoked by the row operations.
  • BUILD_GROUPS_TBL — Constructs the in-memory PL/SQL table of group records used by downstream processing.
  • POPULATE_GROUPS_TEMP_TBL — Loads the temporary staging table that drives bulk or hierarchical group processing.

Tables Accessed

  • OKC_K_GROUPS_B — The base table storing contract group records; the primary insert/update/delete target.
  • OKC_K_GROUPS_TL — The translation table holding language-specific name and description values.
  • FND_LANGUAGES — Supplies installed-language information for translation-related logic.
  • OKC_GRPINGS_TEMP — Temporary staging table populated during group-build operations.
  • OKC_K_GROUPS_S1 — The sequence used to generate primary keys for new group records.
  • DUAL — Used for single-row calculations and lookups.
  • PLITBLM — The standard EBS PL/SQL table of VARCHAR2, used for internal collections.

Usage Notes

OKC_CGP_PVT is invoked indirectly. Users interact with contract groups through the Contracts authoring forms or the public API packages OKC_CONTRACT_GROUP_PUB and OKC_CONTRACT_GROUP_PVT, which in turn call the private routines documented here. Custom extensions that need to create, copy, or modify contract groups should call the public API rather than OKC_CGP_PVT directly; the private package makes no commitment to interface stability across patch levels. When diagnosing issues, note that the package depends on FND_API and OKC_API, so error messages surface through the standard FND_MSG_PUB stack. It references two other packages and is itself referenced by OKC_CONTRACT_GROUP_PUB and OKC_CONTRACT_GROUP_PVT, confirming its role as the shared internal engine for contract group maintenance in both 12.1.1 and 12.2.2.