Search Results ego_pages_s

Overview

APPS.EGO_GTIN_PVT is a private (PVT) PL/SQL package body within the Oracle E-Business Suite Product Information Management (PIM) / Item Management module. Its core business function is to manage Global Trade Item Numbers (GTIN) and the publication, registration, and catalog lifecycle of items across trading partner and data-pool contexts (including UCCnet/GDSN-style synchronization). The package encapsulates the business logic that governs whether an item may be published to a data pool, whether it is registered, published, withdrawn, rejected, or de-listed, and whether re-publication or re-registration is required. It also supports the attribute-driven data model used by the extensibility framework (EGO_EXT_FWK) for storing and validating item GTIN and multiple-GTIN attributes.

The suffix _PVT indicates this is a private API: it is not intended to be called directly by external integrators but is invoked internally by public packages such as EGO_ITEM_PUB, EGO_EXT_FWK_PUB, and EGO_COMMON_PVT, all of which appear in its dependency list. The searched term "ego_pages_s" corresponds to the EGO_PAGES_S table and related EGO_PAGES_B/TL/V objects referenced by this package, reflecting its role in page/attribute-driven item maintenance.

Key Procedures and Functions

The package exposes 35 documented procedures and functions. The publication-related group includes GET_PUBLICATION_STATUS and GET_PUBLICATION_STATUS_CODE, which return the human-readable and coded publication state, and the predicate functions IS_NOT_PUBLISHED, IS_PUBLICATION_IN_PROG, IS_PUBLISHED, IS_RE_PUBLISH_NEEDED, IS_WITHDRAWN, IS_REJECTED, and IS_DELISTED, which evaluate the item's position in the publication workflow. The registration group mirrors this design: GET_REGISTRATION_STATUS and GET_REGISTRATION_STATUS_CODE return status text and code, while IS_NOT_REGISTERED, IS_REGISTRATION_IN_PROG, IS_REGISTERED, IS_RE_REGISTER_NEEDED, and IS_GLOBALLY_PUBLISHED provide boolean evaluations of the registration lifecycle.

Validation and processing routines include VALIDATE_UNIT_WT_UOM, which validates the unit-of-measure associated with unit weight attributes; PROCESS_CAT_ASSIGNMENT, which handles catalog/category assignment for the item; PROCESS_UCCNET_ATTRIBUTES, which maps item attributes to the UCCnet/GDSN interchange structures; and PROCESS_ATTRIBUTE_UPDATES, which applies attribute changes to the GTIN attribute tables. These routines collectively enforce the integrity rules required for compliant item data exchange with trading partners and data pools.

Tables Accessed

The package operates against the EGO extensibility and item attribute tables. GTIN and attribute data are persisted in APPS synonyms for EGO_ITEM_GTN_ATTRS_B (GTIN attributes), EGO_ITM_GTN_MUL_ATTRS_B (multiple GTIN attributes), EGO_ITEM_CUST_ATTRS_B, EGO_ITEM_TP_ATTRS_EXT_B, and EGO_ITEM_TP_ATTRS_EXT_TL. Attribute-group and page configuration is read from EGO_PAGES_B, EGO_PAGES_TL, EGO_PAGES_V, EGO_PAGES_S, EGO_PAGE_ENTRIES_B, EGO_OBJ_AG_ASSOCS_B, and EGO_ASSOCS_S. It also reads EGO_EXTFWK_S, EGO_FND_DF_COL_USGS_EXT, and EGO_FND_DSC_FLX_CTX_EXT for the extensibility and descriptive flexfield context. UCCnet event tracking uses EGO_UCCNET_EVENTS.

Item master and cross-reference data is read from MTL_SYSTEM_ITEMS_B, MTL_SYSTEM_ITEMS_TL, MTL_PARAMETERS, MTL_CROSS_REFERENCES, MTL_CUSTOMER_ITEMS, MTL_CUSTOMER_ITEM_XREFS, MTL_ITEM_CATALOG_GROUPS_B, and MTL_SYSTEM_ITEMS_INTERFACE. Trade partner/site data is sourced from HZ_PARTY_SITES and HZ_CUST_ACCT_SITES_ALL, while BOM_EXPLOSIONS_ALL_V and BOM_ROLLUP_PUB support structure-related attribute derivation. Standard infrastructure tables such as FND_LOOKUPS, FND_LANGUAGES, FND_OBJECTS, FND_DESCR_FLEX_COLUMN_USAGES, and DUAL are also referenced.

Usage Notes

Because EGO_GTIN_PVT is a private package, it is not documented as a public integration interface and is not referenced by any database object outside the APPS schema (though it is referenced by six other packages). It is typically invoked indirectly through item maintenance and extensibility flows — for example from the Item Master (EGO_ITEM_PUB), the extensibility framework (EGO_EXT_FWK_PUB), and common utilities (EGO_COMMON_PVT) — during publication and registration to data pools, when UCCnet/GDSN attributes are processed, and when GTIN attributes or catalog assignments are updated. Concurrent programs and forms that drive item publishing, registration, and withdrawal rely on the status and predicate functions to determine eligible actions and to render the correct workflow state. Custom code should not call this package directly; instead it should use the corresponding public APIs and allow EGO_GTIN_PVT to enforce the underlying GTIN, publication, and registration business rules.