Search Results fm_form_mst_b_tg

Overview

APPS.GR_WF_UTIL_PUB is a public PL/SQL utility package within the Oracle E-Business Suite Process Manufacturing (OPM) schema family. Its principal business function is to initiate Oracle Workflow processes that respond to change events occurring against process manufacturing master data. The package name and the documented entry points indicate that it acts as a bridge between OPM process entities — formulas, technical data, and item definitions — and the Workflow notification and routing infrastructure.

The package is classified as a PUBLIC (PUB) API, meaning it is intended for external invocation rather than being restricted to internal package calls. The current status of the object is VALID in the APPS schema. It depends on FND_MSG_PUB for message retrieval and on the SYS.STANDARD package, confirming that it leverages the standard Foundation message dictionary. The metadata records four total documented procedures and six tables referenced through APPS synonyms.

Key Procedures and Functions

The documented public procedures are as follows:

• INITIATE_PROCESS_ITEM_CHNG — Initiates a Workflow process in response to a change made to an item definition. It is the entry point used when an item's attributes are modified and downstream subscribers or approvers must be notified.
• INITIATE_PROCESS_FORMULA_CHNG — Initiates a Workflow process when a formula is changed. Given the package's dependency on FM_FORM_MST_B, this procedure is tied to formula header maintenance.
• INITIATE_PROCESS_SALES_ORDER — Initiates a Workflow process related to sales order activity for process-manufactured goods, allowing order-driven events to be routed through Workflow.
• INITIATE_PROCESS_TECH_CHNG — Initiates a Workflow process when technical data changes on a process entity, corresponding to the GMD_TECHNICAL_DATA_HDR and GMD_TECH_PARAMETERS_B dependencies.

All four are documented as initiating Workflow processes. Parameter lists are not published in the available metadata and should be confirmed directly from the package specification before custom invocation.

Tables Accessed

• FM_FORM_MST_B — Formula master base table; read to identify the formula affected by a change event.
• GMD_TECHNICAL_DATA_HDR — Technical data header; consulted when technical data change processes are initiated.
• GMD_TECH_PARAMETERS_B — Technical parameter base table, used alongside the technical data header.
• GR_ITEM_GENERAL — OPM item general information, referenced for item-level context.
• MTL_SYSTEM_ITEMS_KFV — Item key flexfield view, used to resolve item identifiers and descriptions for Workflow payloads.
• FND_PROFILE_OPTION_VALUES — Profile option values, read to determine environment-specific configuration such as Workflow item type or routing behavior.

Usage Notes

GR_WF_UTIL_PUB is typically invoked indirectly. The dependency metadata shows that it is referenced by database triggers including FM_FORM_MST_B_TG, GMD_RECIPE_VALIDITY_RULES_TG, GMD_TECHNICAL_DATA_DTL_TG, and GR_INV_ITEM_PROPERTIES_TG. These triggers call the package after DML against their base tables, so item, formula, and technical data changes automatically launch the relevant Workflow process without user action.

It is also referenced by other public APIs, notably GMI_MOVE_ORDER_LINES_PUB and INV_MOVE_ORDER_PUB, indicating that move order activity can trigger the same Workflow initiation path. The GR_INV_ITEM_PROPERTIES_TG trigger confirms a self-referencing relationship, where the package's own dependent code participates in the chain.

Because it is a PUB package, custom extensions may call these procedures directly from forms, concurrent programs, or bespoke PL/SQL. When doing so, developers should first confirm the profile options in FND_PROFILE_OPTION_VALUES and ensure that the Workflow item types referenced by the procedures are properly defined and active. As with all OPM Workflow integrations in EBS 12.1.1 and 12.2.2, the package should be treated as an interface layer and not modified directly.