Search Results set_search_string

Overview

OKC_CGC_PVT is a private PL/SQL package in the Oracle E-Business Suite Contracts (OKC) module, owned by the APPS schema and declared with AUTHID CURRENT_USER. It belongs to the Contract Groups and Groupings area of the Contracts Core architecture, managing the relationship records that link contract groupings (CGP) to their included contracts and grouping structures. The "CGC" designation refers to the Contract Groupings Child entity, while the "_PVT" suffix identifies this as a private package — an internal implementation layer invoked by the public OKC_CGC API and related packages rather than by external callers directly.

The package defines global record and collection types — cgc_rec_type, cgc_tbl_type, cgcv_rec_type, cgcv_tbl_type, qry_k_rec, qry_k_tbl, and the QueryKCursor REF CURSOR — that standardize how grouping child rows and contract query results are passed between procedures. Each record type initializes its fields to OKC_API.G_MISS_* sentinel values, enabling the API layer to distinguish supplied values from missing ones during insert and update processing.

Key Procedures and Functions

The package exposes sixteen documented procedures and functions. QC is a generic quality-control/processing entry point, and CHANGE_VERSION handles object version number increments for optimistic locking. API_COPY supports duplication of grouping child records, typically when a contract or grouping is copied. The core DML layer comprises INSERT_ROW, LOCK_ROW, UPDATE_ROW, DELETE_ROW, and VALIDATE_ROW, following the standard Oracle EBS table-handler pattern: LOCK_ROW performs a SELECT FOR UPDATE and version check, INSERT_ROW and UPDATE_ROW persist validated data, DELETE_ROW removes rows, and VALIDATE_ROW enforces business rules before persistence. INSERT_ROW_UPG is the upgrade-specific insert variant used during patch or upgrade processing. SET_SEARCH_STRING maintains a search-string value used for query filtering.

GET_QUERIED_CONTRACTS returns contract rows matching supplied query criteria, populating the qry_k_tbl collection or the QueryKCursor REF CURSOR with contract IDs and contract numbers. This function backs the contract-selection logic used when building or maintaining grouping membership.

Tables Accessed

The package operates against two documented base or view objects referenced through APPS synonyms. OKC_K_GRPINGS is the primary table storing grouping child records, including the included contract ID, included grouping ID, parent grouping ID, and SCS_CODE attribute; the record types bind directly to its columns. OKC_K_HEADERS_B supplies contract header information for contract-number lookups and the queried-contract retrieval path. PLITBLM is a standard EBS PL/SQL index-by table used for bulk DML and collection processing within the API's insert, update, and delete routines.

Usage Notes

OKC_CGC_PVT is referenced by thirteen other packages, confirming its role as a shared internal service layer. It is not intended for direct invocation from Forms or concurrent programs; instead, the public API packages (such as OKC_CGC) and supplementary upgrade or copy routines call its procedures to perform validated persistence on grouping children. Customizations should target the public API rather than this private package, because the private interface may change between patch levels. The OKC_API.G_MISS_* conventions and object_version_number handling follow the same optimistic-locking contract used throughout OKC, so any calling code must supply version numbers correctly to avoid concurrent-update failures.