Search Results okc_k_groups_s1

Overview

The APPS.OKC_CGP_PVT package body is a private (PVT-classified) PL/SQL API within the Oracle E-Business Suite Contracts (OKC) module. Its name reflects its role in managing Contract Groups — specifically the "CGP" designation (Contract Group Processing), which handles the header-level groupings that organize contract line items and related business entities under logical contract structures. This package provides the underlying programmatic engine for creating, copying, updating, and validating records in the OKC_K_GROUPS entity, which is the central repository for contract group definitions across Oracle Contracts, Order Management, and related modules.

As a private package, OKC_CGP_PVT is not intended for direct invocation by external callers. It is the implementation partner to the public OKC_API and related packages that expose contract group functionality to forms, concurrent programs, and integration interfaces. The package depends on the standard EBS toolkit — FND_API, FND_GLOBAL, FND_LANGUAGES, FND_PROFILE, and FND_USER_VIEW — confirming full multi-org and multi-language (MLS) compliance consistent with EBS 12.1.1 and 12.2.2 architecture.

Key Procedures and Functions

The package exposes 20 documented procedures and functions that collectively implement the CRUD and validation lifecycle for contract groups:

• QC — Quality control or standard consistency check routine invoked during processing.
• CHANGE_VERSION — Manages versioning of contract group records, supporting the Contracts versioning model.
• API_COPY — Copies a contract group record, typically used in contract duplication and template scenarios.
• ADD_LANGUAGE — Inserts translation rows into the MLS-enabled groups table for supported languages.
• INSERT_ROW — Creates a new contract group row, populating both the base table and translation table.
• LOCK_ROW — Acquires a row-level lock to prevent concurrent modification during updates.
• UPDATE_ROW — Modifies an existing contract group record.
• DELETE_ROW — Removes a contract group record and its dependent translations.
• VALIDATE_ROW — Performs holistic validation on a group record prior to DML.
• VALIDATE_NAME — Verifies uniqueness and format of the group name.
• VALIDATE_PUBLIC_YN — Validates the public/private flag on a group.
• VALIDATE_SHORT_DESCRIPTION — Checks the short description field for length and content rules.
• VALIDATE_RECORD — Aggregates validation checks for an entire record.
• BUILD_GROUPS_TBL — Constructs an in-memory PL/SQL table of groups for bulk processing.
• POPULATE_GROUPS_TEMP_TBL — Loads the temporary table OKC_GRPINGS_TEMP with group data, supporting set-based operations.

Tables Accessed

The package reads and writes the following documented tables through APPS synonyms:

• OKC_K_GROUPS_B — Base table holding the core group records (primary DML target).
• OKC_K_GROUPS_TL — Translation table for MLS columns such as name and description.
• OKC_K_GROUPS_S1 — The user's searched object; a sequence used to generate primary keys for new group records.
• OKC_K_GROUPS_V — View combining base and translation data for read access.
• OKC_K_GRPINGS_V — View used to resolve groupings associations.
• OKC_GRPINGS_TEMP — Global temporary table used during bulk build and populate operations.
• FND_LANGUAGES — Source of installed language codes for MLS inserts.
• DUAL and PLITBLM — Utility references for sequence selection and PL/SQL table operations.

Usage Notes

Because OKC_CGP_PVT is a private package, it is not referenced by any external database object and is not called directly from custom code. It is instead invoked by the public Contracts APIs (OKC_API) and the contract group maintenance forms within the Contracts workbench. The typical invocation paths are:

• Contract group creation and maintenance through the Contract Groups form in the Contracts Manager responsibility.
• Contract copy and template application, which trigger API_COPY indirectly.
• Concurrent programs that mass-process contract groupings.
• Internal calls from OKC_API during contract line assignment and re-grouping operations.

Customizations requiring contract group manipulation should target the public OKC_API layer rather than this private package, ensuring forward compatibility across EBS 12.1.1 and 12.2.2 upgrades.