Search Results okc_cgc_pvt




Overview
Explore in AI Chat

Overview

OKC_CGC_PVT is a private PL/SQL package body in the APPS schema that supports the Contract Groups and Conditions (CGC) functionality within Oracle Contracts, part of the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 codebase. The "PVT" suffix identifies it as a private implementation package, meaning its procedures are not part of the public API surface exposed to external callers but are instead consumed internally by sibling packages and public APIs within the Contracts module. Its primary business function is to manage the persistence, validation, and lifecycle of contract group and grouping records -- essentially the structures that associate contract headers with one another in hierarchical or grouped relationships. Because it is private, the package encapsulates low-level row operations, concurrency handling, and version management that the Contracts framework relies upon but does not expose directly to end users or integrators.

Key Procedures and Functions

The package exposes sixteen documented procedures and functions. The core data manipulation routines follow a conventional row-operation pattern:

  • INSERT_ROW, UPDATE_ROW, DELETE_ROW, LOCK_ROW -- standard CRUD and concurrency primitives that create, modify, soft-delete, and lock grouping records within the underlying tables.
  • VALIDATE_ROW -- performs business-rule validation on a candidate record before it is committed.
  • INSERT_ROW_UPG -- a migration-oriented insert routine used during upgrade processing to load legacy group data.
  • API_COPY -- duplicates grouping structures, supporting contract duplication and versioning scenarios.
  • CHANGE_VERSION -- manages version transitions on grouped contracts, ensuring references remain consistent across revisions.
  • SET_SEARCH_STRING and GET_QUERIED_CONTRACTS -- support query and search behavior, building the search criteria and returning matching contract groupings.
  • QC -- a quality-check/quick-check routine that validates group integrity.

These routines collectively allow the Contracts engine to maintain grouping relationships reliably while enforcing validation and version control.

Tables Accessed

Through APPS synonyms, the package reads and writes several core Contracts tables:

  • OKC_K_GRPINGS -- the base table storing contract grouping records; this is the primary target of the insert, update, delete, and lock operations.
  • OKC_K_HEADERS_B -- the contract header base table, referenced to validate and resolve the contracts that belong to a grouping.
  • PLITBLM -- an Oracle Applications standard PL/SQL index-by table type used internally for bulk operations and cursor processing.

Views OKC_K_GROUPS_V and OKC_K_GRPINGS_V are also referenced for read access, and OKC_K_HEADERS_V for header lookups, providing denormalized views over the base tables.

Usage Notes

OKC_CGC_PVT is invoked indirectly. It is referenced by thirteen other packages, including the public OKC_API, which delegates grouping-related operations to this private layer. It also depends on FND_API, FND_GLOBAL, and FND_PROFILE for standard EBS API error handling, session context, and profile option access. Because it is a private package, it should not be called directly from custom code; developers should instead use the supported public APIs (such as OKC_API) that wrap this functionality. Typical invocation paths include the Contracts forms, contract versioning and duplication concurrent programs, and the upgrade driver (via INSERT_ROW_UPG). Any direct reference to OKC_CGC_PVT risks breakage during patching or upgrades, as private packages may change without notice.