Results for “item_revisions”

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

Overview

EGO_ICC_STRUCTURE_PVT is a private PL/SQL package body in the Oracle E-Business Suite Applications (APPS) schema that supports the Item Catalog Core (ICC) feature set. Its primary business function is to manage versioned item catalog group structures and the bill of material (BOM) components associated with them. The package bridges the Item Catalog Group hierarchy (stored in MTL_ITEM_CATALOG_GROUPS_B and EGO_MTL_CATALOG_GRP_VERS_B) with BOM structures and components, allowing versioned catalogs to inherit, release, and revert component definitions across versions.

A central concern of the package is item revisions. The source declares item_revision_record, revision_rec, and v_item_revisions_tbl to store and retrieve item revision details (revision id, revision number, start date, and end date), and exposes helper functions GET_REVISION_START_DATE and GET_REVISION_END_DATE. This makes the package relevant to any search concerning item_revisions, since it queries MTL_ITEM_REVISIONS and MTL_ITEM_REVISIONS_B to resolve effective revision dates when versioned structures are processed.

Key Procedures and Functions

• DELETE_COMP_USER_ATTRS — Removes user-defined attributes from a component by deleting rows from BOM_COMPONENTS_EXT_B and BOM_COMPONENTS_EXT_TL.
• CREATE_DEFAULT_HEADER — Creates a structure header for versioned ICCs that do not yet have one, resolving the catalog group hierarchy through a connect-by query over MTL_ITEM_CATALOG_GROUPS_B.
• CREATE_STRUCTURE_INHERIT — Creates an inherited structure, using stored assembly/inventory item identifiers (G_INV_ITEM_ID) for the target assembly.
• INHERIT_ICC_COMPONENTS — Copies component definitions from a parent catalog version into the inheriting version.
• IS_STRUCTURE_INHERITING — Determines whether a structure is currently inheriting from a parent.
• RELEASE_COMPONENTS and REVERT_DRAFT_COMPONENTS — Manage the transition of draft component changes into a released state, or roll them back.
• GETICCNAME — Resolves the descriptive name of an item catalog group.
• GET_EFFECTIVE_VERSION, GET_PARENT_VERSION — Identify the effective or parent version of a catalog group structure.
• IS_STRUCTURE_UPDATED, IS_PARENT_UPDATABLE — Boolean checks used to gate inheritance and update logic.
• COMPARE_UDA_VALUES, COMPARE_COMPONENTS — Compare two sets of user-defined attribute values or two component sets to detect differences.
• GET_REVISION_START_DATE, GET_REVISION_END_DATE — Return the effective start and end dates for an item revision, drawing on the revision records cached in v_item_revisions_tbl.
• VALIDATE_BASE_ATTRIBUTES — Performs validation of base component attributes before persistence.

Tables Accessed

The package reads and writes several core tables through APPS synonyms. Component data is maintained in BOM_COMPONENTS_B, BOM_COMPONENTS_EXT_B, BOM_COMPONENTS_EXT_TL, BOM_INVENTORY_COMPONENTS_S, and BOM_STRUCTURES_B. Catalog group definitions come from MTL_ITEM_CATALOG_GROUPS_B, EGO_MTL_CATALOG_GRP_VERS_B, and EGO_DATA_LEVEL_B. Item revision dates are sourced from MTL_ITEM_REVISIONS and MTL_ITEM_REVISIONS_B, while item master and revision metadata are read from MTL_SYSTEM_ITEMS, MTL_SYSTEM_ITEMS_B, and ENG_REVISED_ITEMS. MTL_PARAMETERS and MTL_SECONDARY_INVENTORIES supply organizational and inventory context. The package both reads (for inheritance and comparison) and writes (for header creation, release, and reversion) across these tables.

Usage Notes

As a PVT (private) package, EGO_ICC_STRUCTURE_PVT is not intended to be called directly by external code. It is invoked internally by the EGO Item Catalog user interface forms, by the higher-level public APIs that manage item catalog groups, and by concurrent programs that process version inheritance and release. In Oracle EBS 12.1.1 and 12.2.2, this logic underlies the versioned catalog feature in Product Information Management (PIM). Customizations should generally call the corresponding public EGO package rather than this private body, since the private interface may change between patch levels. The header comment references patch 120.0.12010000.13, indicating active maintenance across the 12.1.x line.