Search Results okc_contract_group_pub




Overview
Explore in AI Chat

Overview

OKC_CONTRACT_GROUP_PVT is a private (PVT) PL/SQL package in the APPS schema within Oracle E-Business Suite's Enterprise Contracts (OKC) module. It provides the internal implementation layer for managing contract groups, which are logical groupings of contracts or contract lines used for categorization, reporting, and bulk processing within the Contracts workbench. Contract groups allow users to organize related contract records and apply group-level attributes, such as name, public accessibility flags, and short descriptions.

Because the package is classified as PVT, it is not intended for direct invocation by external applications or custom code. Instead, it serves as the backend engine called by the public wrapper package OKC_CONTRACT_GROUP_PUB, as well as by OKC_CONTRACT_GROUP_PVT itself (recursive internal calls) and OKS_RENEW_CONTRACT_PVT (the service contracts renewal package). This layering follows the standard Oracle EBS public/private API pattern: public APIs validate and route calls, while private packages perform the substantive business logic and DML against underlying tables.

Key Procedures and Functions

The documented 28 procedures and functions fall into several functional categories:

The naming distinguishes the "CTR" variants (likely header-level or legacy entry points) from the "CONTRACT" variants, both of which orchestrate the same logical operations.

Tables Accessed

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

  • OKC_K_GROUPS_B: The base table storing contract group header records, including group identifiers, names, and public flags.
  • OKC_K_GRPINGS: Stores the groupings — the associations between a contract group and its member contract records.
  • PLITBLM: A standard Oracle EBS PL/SQL table type used for in-memory collections passed between API layers, not physical persistent data.

Usage Notes

Because OKC_CONTRACT_GROUP_PVT is a private package, direct calls from forms, concurrent programs, or custom code are discouraged; Oracle's extensibility guidance directs developers to invoke OKC_CONTRACT_GROUP_PUB instead, which wraps and delegates to this package. Typical invocations occur when a user creates or modifies a contract group through the Enterprise Contracts user interface, when the renewal process (OKS_RENEW_CONTRACT_PVT) programmatically reorganizes contracts into groups, and during bulk data migrations. All calls should respect the standard FND_API return-status and message conventions, and callers should invoke the LOCK and VALIDATE routines before DML operations to ensure data integrity and concurrency control.