Search Results process_catalog_groups

Overview

EGO_ITEM_CATALOG_PVT is a private PL/SQL package in the Oracle E-Business Suite APPS schema that supports the batch processing of catalog groups within the Oracle Product Information Management (PIM) and Items module. Catalog groups are the hierarchical classification structures used to organize items into categories for searching, browsing, and attribute-driven item definition. The package header is declared with AUTHID CURRENT_USER, meaning that at runtime it executes with the privileges of the calling schema rather than the definer, which is consistent with its designation as a private (PVT) API.

The header comment explicitly states that this is a "Private API for processing catalog groups" and warns that "Applications should not call this catalog group api directly." This establishes the package as an internal implementation component intended to be driven by higher-level public APIs, concurrent programs, or framework code rather than by end users or custom integrations. Its core responsibility is to iterate over catalog group definitions and synchronize or process them, returning a status code and a message count to the caller so that errors and warnings can be surfaced appropriately.

Key Procedures and Functions

The package exposes a single documented procedure:

• PROCESS_CATALOG_GROUPS — The primary processing routine. It returns two OUT parameters: a return status indicating success or failure of the call, and a message count indicating how many messages were logged during execution. Its purpose is to drive the processing logic for catalog groups, orchestrating the reads and writes needed to reconcile catalog group data against the underlying base tables and profile settings. Because the package header is marked private, this procedure is not part of the supported public API surface.

No other procedures or functions are documented in the 12.2.2 ETRM metadata for this package.

Tables Accessed

The documented table references reveal the data footprint of the processing routine:

• MTL_ITEM_CATALOG_GROUPS_B — The base table holding item catalog group definitions. This is the primary source of records to be processed.
• EGO_MTL_CATALOG_GRP_VERS_B — The versioned catalog group base table used by the EGO (Product Information Management) schema, reflecting the versioning model introduced for catalog group definitions.
• FND_PROFILE_OPTION_VALUES — Read to obtain profile option settings that govern processing behavior, such as enabling flags or organizational context.
• DUAL — Used for scalar evaluations and simple SELECT expressions within the PL/SQL logic.
• PLITBLM — A generic PL/SQL index-by table type used internally for message or collection handling.

These references indicate the procedure reads catalog group base data and versioned catalog group data, consults profile options for configuration, and manages messages during execution.

Usage Notes

Because EGO_ITEM_CATALOG_PVT is classified as a private API, it is not intended to be invoked directly from custom code, forms personalizations, or ad-hoc scripts. In the standard EBS architecture, it is called by a parent package or framework component — the ETRM metadata notes it is referenced by one other package — which acts as the public entry point for catalog group processing.

Typical invocation contexts include concurrent programs that batch-process catalog groups, and internal processing triggered during catalog group setup or item classification activities in PIM. When invoked, callers must supply the OUT variables for return status and message count and should inspect both to determine whether processing succeeded and whether any messages require attention. Because the package relies on FND_PROFILE_OPTION_VALUES, behavior can vary by site-level or user-level profile configuration, and administrators should verify profile settings before diagnosing unexpected results.

For 12.1.1 and 12.2.2, the package signature and private classification remain consistent. Developers seeking to extend catalog group processing should locate the public wrapper that calls PROCESS_CATALOG_GROUPS rather than invoking this private package directly, as Oracle does not support direct calls to private APIs.