Search Results is_delisted

Overview

The APPS.EGO_GTIN_PVT package is the private API layer that governs the publication and registration lifecycle of item data within the Oracle E-Business Suite Product Information Management (PIM) and UCCnet/GS1 data synchronization framework. Its principal business function is to determine whether a given inventory item, in a given inventory organization, is eligible to be published to a trading partner, is already published, is in the process of publication, requires re-publication, or has been withdrawn or rejected. Publication status is evaluated against a Global Location Number (GLN) and, where applicable, a customer and address, reflecting the requirement that the same item may carry different synchronization states for different trading partners.

The package header carries the version marker EGOUCCPS.pls 120.8, indicating it belongs to the EGO (Engineering/Product Information) module's UCCnet publication subsystem. It is classified as a PVT package, meaning it is an internal implementation construct rather than a formally supported public API; Oracle sanctions its use only through the interfaces that ship with the application.

Key Procedures and Functions

The package exposes thirty-five documented procedures and functions. The status-inquiry functions form the core of the interface:

• GET_PUBLICATION_STATUS and GET_PUBLICATION_STATUS_CODE return the current publication state of an item for a specified organization, address, GLN, and customer, in descriptive and coded form respectively. Overloaded variants support calls made with or without a GLN.
• IS_NOT_PUBLISHED, IS_PUBLICATION_IN_PROG, IS_PUBLISHED, IS_RE_PUBLISH_NEEDED, IS_WITHDRAWN, IS_REJECTED, and IS_DELISTED are Boolean predicates that test for discrete lifecycle conditions.
• GET_REGISTRATION_STATUS, GET_REGISTRATION_STATUS_CODE, IS_NOT_REGISTERED, IS_REGISTRATION_IN_PROG, IS_REGISTERED, and IS_RE_REGISTER_NEEDED perform the equivalent role for the registry side of the data-synchronization cycle.
• IS_GLOBALLY_PUBLISHED determines whether an item has achieved publication without restriction to a single recipient.
• VALIDATE_UNIT_WT_UOM checks unit-of-measure consistency for weight attributes prior to transmission.
• PROCESS_CAT_ASSIGNMENT, PROCESS_UCCNET_ATTRIBUTES, and PROCESS_ATTRIBUTE_UPDATES drive the staging and refresh of classification assignment and item attribute data destined for publication.

Tables Accessed

The package operates across the EGO item and attribute schema. EGO_ITEM_GTN_ATTRS_B and EGO_ITM_GTN_MUL_ATTRS_B hold GTIN and multi-valued GTIN attributes; EGO_ITEM_CUST_ATTRS_B and EGO_ITEM_TP_ATTRS_EXT_B with its _TL counterpart store customer- and trading-partner-specific attributes and translations. Structural and descriptive metadata is read from EGO_ASSOCS_S, EGO_OBJ_AG_ASSOCS_B, EGO_EXTFWK_S, EGO_FND_DSC_FLX_CTX_EXT, and EGO_FND_DF_COL_USGS_EXT. Page and classification content resides in EGO_PAGES_B, EGO_PAGES_S, EGO_PAGES_TL, and EGO_PAGE_ENTRIES_B. Transmission history is tracked in EGO_UCCNET_EVENTS.

Usage Notes

As a private package, EGO_GTIN_PVT is not intended for direct invocation from customer code. It is referenced by six other packages within the EGO schema, which serve as the sanctioned entry points. Typical invocation occurs during concurrent program runs that publish or register item data, from PIM item maintenance forms that refresh publication status as users edit attributes, and from workflow or event-driven processes that react to registry responses recorded in EGO_UCCNET_EVENTS. Both Oracle EBS 12.1.1 and 12.2.2 deployments share the same schema and signature set, so customizations written against 12.1.1 remain valid after upgrade to 12.2.2. Custom development should call the supported wrapper APIs rather than these private functions.