Results for “create_default_header”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

EGO_ICC_STRUCTURE_PVT is a private PL/SQL package in the APPS schema that implements the core structure-management logic for Oracle EBS Item Catalog Catalogs (ICC), part of the Product Information Management (PIM) and Advanced Product Catalog functionality. It governs the lifecycle of item catalog group structures across draft and released versions, including the creation, inheritance, reversion, and deletion of components, the comparison of user-defined attribute (UDA) values between draft and released rows, and the resolution of effective versions based on date. The package is declared with AUTHID CURRENT_USER and its header identifies it as a non-shipped (noship) internal implementation unit, referred to internally as egoistps.pls. Because it is classified as a PVT (private) API, it is not intended for direct customer invocation; its entry points are called by the public catalog APIs and concurrent/UI layers that manage catalog versions.

Key Procedures and Functions

The documented entry points fall into several functional groups. The most directly relevant to the search term is DELETE_COMP_USER_ATTRS, which removes user attributes associated with a component identified by its sequence id, typically invoked when a component is being removed or rebuilt. Structure lifecycle management is handled by REVERT_DRAFT_COMPONENTS, which reverts components belonging to a draft ICC version, and RELEASE_COMPONENTS, which creates the component rows for a newly released catalog version based on a group, version, and start date.

Version resolution and naming are provided by GETICCNAME, which returns the ICC name for a given group and parent bill sequence id; GET_EFFECTIVE_VERSION, which resolves the effective version of an ICC for a given start date; and GET_PARENT_VERSION, which performs the equivalent resolution for a parent ICC. IS_STRUCTURE_UPDATED reports whether a draft version has been modified relative to the released baseline, and IS_STRUCTURE_INHERITING indicates whether a structure is inheriting changes from a parent.

Comparison and inheritance logic is concentrated in COMPARE_UDA_VALUES and COMPARE_COMPONENTS, which detect differences between draft and released components and their attribute values, and in CREATE_STRUCTURE_INHERIT and INHERIT_ICC_COMPONENTS, which propagate structural changes to inheriting children. Additional helpers include GET_REVISION_START_DATE and GET_REVISION_END_DATE for revision date ranges, CREATE_DEFAULT_HEADER for header initialization, IS_PARENT_UPDATABLE, and VALIDATE_BASE_ATTRIBUTES.

Tables Accessed

The package operates against both the BOM component tables (BOM_COMPONENTS_B, BOM_COMPONENTS_EXT_B, BOM_COMPONENTS_EXT_TL, BOM_INVENTORY_COMPONENTS_S) that physically store catalog component and structure definitions, and the catalog version tables (EGO_MTL_CATALOG_GRP_VERS_B, MTL_ITEM_CATALOG_GROUPS_B, EGO_DATA_LEVEL_B) that define the group, version, and hierarchy metadata driving draft/release behavior. Item master and revision data (MTL_SYSTEM_ITEMS, MTL_SYSTEM_ITEMS_B, MTL_ITEM_REVISIONS, MTL_ITEM_REVISIONS_B, ENG_REVISED_ITEMS) supply item and revision attributes for comparison and inheritance. MTL_PARAMETERS and MTL_SECONDARY_INVENTORIES are consulted for organizational context. All access is via APPS synonyms.

Usage Notes

EGO_ICC_STRUCTURE_PVT is referenced by one other package and is normally invoked indirectly through the public catalog versioning workflow—for example when a draft catalog is released, reverted, or compared, or when inheritance is propagated from a parent catalog. It is not a supported integration point; customizations should call the public EGO catalog APIs instead. DELETE_COMP_USER_ATTRS should only be invoked in the context of component rebuild or removal operations, as it directly purges component UDA rows. Behavior is consistent across 12.1.1 and 12.2.2, with the identified header version reflecting the 12.0.12010000 code lineage.