Search Results update_reg_pub_update_dates

Overview

BOM_GTIN_RULES is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that enforces Global Trade Item Number (GTIN) validation rules within the Bill of Materials (BOM) product family. It is classified as an OTHER API and consists of twelve documented procedures and functions. The package centers on validating GTIN attributes associated with assemblies and their components, propagating GTIN values upward through a bill structure, and supporting the rollup processing that aggregates GTIN data across multi-level manufacturing and published hierarchies.

The package header dates to 2004, with the current version reflecting a 2007 revision (BOMLGTNS.pls, version 120.4). Its responsibilities include checking that component GTIN attributes conform to defined rules before a bill is saved or published, handling exceptions for published hierarchies during rollup operations, and returning unit-of-measure conversion rates and suggested component quantities for GTIN packaging contexts.

Key Procedures and Functions

• CHECK_GTIN_ATTRIBUTES — Validates the GTIN attributes of a component within a specified assembly, organization, and alternate BOM. An overloaded variant accepts a flag to ignore the published hierarchy exception, which supports GTIN rollups without failing on already-published structures.
• UPDATE_TOP_GTIN — Updates the GTIN held at the top level of a structure for a given organization and component item, optionally scoped to a parent item and structure name.
• GET_SUGGESTED_QUANTITY — Returns a suggested component quantity, along with the associated unit-of-measure conversion rate; returns a sentinel value of -99999 when an error is encountered.
• PACK_CHECK — Performs GTIN packaging validation for an item within an organization, returning a status indicator as a VARCHAR2.
• PERFORM_ROLLUP — The routine of interest for the "perform_rollup" search term. It drives the GTIN rollup operation, aggregating or propagating GTIN values through the BOM hierarchy. It works in conjunction with the rollup-aware overload of CHECK_GTIN_ATTRIBUTES so that published hierarchies are not treated as blocking exceptions.
• UPDATE_REG_PUB_UPDATE_DATES — Maintains registration and publication update dates associated with GTIN attribute changes.
• GET_UOM_CLASS_COMPATIBILITY — Determines unit-of-measure class compatibility, supporting quantity and packaging validation logic.
• VALIDATE_HIERARCHY_ATTRS — Validates hierarchy-level attributes, ensuring structural consistency before rollup and publication processing.

Tables Accessed

The package reads and writes through APPS synonyms. BOM_COMPONENTS_B and BOM_STRUCTURES_B supply component and structure definitions; BOM_STRUCTURE_TYPES_B identifies structure types, and BOM_EXPLOSIONS_ALL supports the exploded, multi-level view required for rollup traversal. GTIN-specific attributes reside in EGO_ITEM_GTN_ATTRS_B and its translated counterpart EGO_ITEM_GTN_ATTRS_TL. MTL_SYSTEM_ITEMS_B provides item master detail such as UOM and item definitions, while the PLITBLM table is a standard EBS PL/SQL index-by table used for bulk data handling.

Usage Notes

BOM_GTIN_RULES is referenced by four other packages, indicating it is a shared validation and rollup utility rather than a standalone entry point. It is typically invoked from BOM inquiry and maintenance forms when GTIN attributes are entered or changed, from concurrent programs that perform mass GTIN rollups or publication, and from custom code that must validate GTIN data before committing bills. Because PERFORM_ROLLUP and the rollup-aware overload of CHECK_GTIN_ATTRIBUTES both incorporate the published-hierarchy exception, callers performing rollups should use these variants to avoid false validation failures on structures already published to downstream systems.