Search Results gr_item_information_seq

Overview

GR_WF_UTIL_PVT is a private PL/SQL package body in the APPS schema that provides the workflow integration and outbound document delivery utility layer for Oracle E-Business Suite's Process Manufacturing (OPM) Quality and item management functionality. Its principal responsibility is to bridge Oracle Workflow with the ETRM (Enterprise Transaction and Reporting Management) framework—managing workflow initialization, resolving default roles and technical parameters, assembling item and formula detail payloads, generating XML documents via the ECX (e-Commerce XML) infrastructure, and dispatching outbound documents to trading partners or rebuild recipients. The package is classified as PVT, indicating it is an internal implementation package invoked by sibling GR packages rather than exposed as a public API.

Key Procedures and Functions

• WF_INIT — Initializes the workflow context, establishing the runtime environment prior to subsequent workflow operations.
• APPS_INITIALIZE — Performs standard APPS schema environment initialization (application ID, responsibility, and user context) required before other routines execute.
• GET_DEFAULT_ROLE — Derives the default Oracle Workflow role to be assigned during initiation or notification.
• CHECK_FOR_TECH_PARAM — Validates the presence and correctness of technical workflow parameters.
• GET_ITEM_DETAILS — Retrieves item-level detail used in outbound item information requests and documents.
• GET_FORMULA_DETAILS — Retrieves formula detail used in the same document assembly flows.
• IS_IT_PROP_OR_FORMULA_CHANGE — Determines whether a change pertains to an item property or a formula, guiding change event handling.
• SEND_OUTBOUND_DOCUMENT — Assembles and transmits an outbound XML document to the appropriate recipient.
• SEND_DOC_RBLD_OUTBND — Sends the document rebuild outbound variant.
• GETXMLTP — Generates the XML payload for a trading partner using the ECX mappings.
• INIT_THRDPRTY_WF — Initializes the third-party workflow process.
• THRDPRTY_INS — Inserts third-party workflow data.
• ITEMS_REQUESTED_INS — Inserts records into the items-requested staging structure.
• WF_INIT_ITEM_INFO_REQ — Initiates the item information request workflow.
• LOG_MSG — Writes diagnostic and error messages to the standard logging facility.

Tables Accessed

The package reads/writes OPM item and property master data through GR_ITEM_GENERAL, GR_ITEM_GENERAL_V, GR_INV_ITEM_PROPERTIES, GR_PROPERTIES_B, GR_PROP_CHNG_TEMP, and GR_XML_PROPERTIES_MAP. It stages item requests in GR_ITEMS_REQUESTED and uses GR_ITEM_INFORMATION_SEQ to populate surrogate keys for item information records. Label data is read from GR_LABELS_B and GR_LABELS_TL. Outbound document configuration is resolved from the ECX tables ECX_TP_DETAILS, ECX_TP_HEADERS, and ECX_TRIGGER_ID_S, with change-history tracking via GR_DISPATCH_HISTORY_PVT. Supporting lookups include FND_APPLICATION, FND_USER, FND_PROFILE, FND_MESSAGE/FND_MSG_PUB, FM_FORM_MST_B, IC_ITEM_MST_B, MTL_PARAMETERS, MTL_SYSTEM_ITEMS_KFV, and the Workflow tables WF_ITEMS, WF_SYSTEMS, and related WF types.

Usage Notes

GR_WF_UTIL_PVT is invoked internally by Oracle Workflow business events and by the ETRM outbound document generation process when item or formula changes must be communicated to trading partners. It is typically triggered from Workflow event subscriptions, from concurrent-program-driven dispatch processes, and from forms performing item information requests. Because it is a PVT package, it is not intended as a supported public API; custom code should call the public wrappers instead. Direct references to GR_ITEM_INFORMATION_SEQ confirm its role in sequencing item information records during workflow-driven document creation. Customers extending item change notification should treat this package as read-only and non-supported for direct invocation.