Search Results check_delete_attrgroup_assoc

Overview

EGO_ITEM_CATALOG_PUB is the public PL/SQL package that exposes the catalog group API for Oracle E-Business Suite. It belongs to the EGO (Product Information Management / EGO application) schema and is classified as a public API in the ETRM repository. Its principal responsibility is to encapsulate the creation, update, validation, and processing of item catalog groups — the logical containers that classify items for catalog browsing, sourcing, purchasing, and order entry. Catalog groups stored in MTL_ITEM_CATALOG_GROUPS_B and its translation table are the foundation of default category assignment and item catalog display in Oracle Inventory and Oracle iProcurement.

The package body header identifies module version 120.7, with the internal package name token EGO_ITEM_CATALOG_PUB and debug infrastructure provided through Set_Debug_Parameters, an unexposed helper that opens a debug session file when the debug flag is set. Because the procedures are classified as PUB, customers and partners may call them from custom code, though Oracle recommends using the documented entry points only.

Key Procedures and Functions

The ETRM metadata documents six public procedures and functions:

• PROCESS_CATALOG_GROUPS — Bulk entry point that processes a set of catalog group records. It is the typical API invoked when several catalog groups must be created or maintained in one call.
• PROCESS_CATALOG_GROUP — Single-record equivalent of PROCESS_CATALOG_GROUPS, handling the create-or-update logic for one catalog group.
• CREATE_CATALOG_GROUP — Inserts a new catalog group definition, including its base row in MTL_ITEM_CATALOG_GROUPS_B and its translated description.
• UPDATE_CATALOG_GROUP — Modifies an existing catalog group, including descriptive and translation attributes.
• CHECK_DELETE_ATTRGROUP_ASSOC — Validation routine that determines whether an attribute group association may be deleted. This is the procedure most closely associated with the search term and is normally invoked before a delete attempt to enforce referential rules.
• LOCK_ROW — Concurrency-control utility that locks the target catalog group row so that competing sessions cannot modify it simultaneously.

Tables Accessed

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

• MTL_ITEM_CATALOG_GROUPS_B and MTL_ITEM_CATALOG_GROUPS_TL — the base and translated catalog group definitions that are the primary target of the create and update procedures.
• EGO_MTL_CATALOG_GRP_VERS_B — version records for catalog groups, used when maintaining versioned catalog structures.
• EGO_CAT_GRP_TEMPLATES — catalog group templates that prescribe the attribute layout of a group.
• EGO_FND_DSC_FLX_CTX_EXT — descriptive flexfield context extensions that hold additional catalog group attributes.
• EGO_PAGE_ENTRIES_B — page entry definitions associated with catalog group display.
• FND_APPLICATION, FND_NEW_MESSAGES, and FND_OBJECTS — Oracle Application Object Library lookups for validation, messaging, and object registration.

Usage Notes

EGO_ITEM_CATALOG_PUB is referenced by nine other packages, indicating it functions as a shared lower-level service within the EGO stack rather than as a standalone user interface. It is typically invoked from catalog group maintenance forms, from concurrent programs that mass-create or synchronize catalog groups, and from custom integrations that need to register catalog groups programmatically. The presence of the debug helper indicates that developers can enable tracing by passing a debug flag, output directory, and debug filename. Custom callers should observe the standard EBS API conventions — validate inputs, check the return status, and use LOCK_ROW for concurrency-sensitive updates.