Search Results is_it_prop_or_formula_change

Overview

GR_WF_UTIL_PVT is a private PL/SQL utility package owned by APPS within the Oracle E-Business Suite environment (12.1.1 and 12.2.2). It belongs to the Regulatory (GR) product family and provides shared workflow and Oracle Workflow integration plumbing used internally by other Regulatory components. The package is declared with AUTHID CURRENT_USER, meaning its unqualified references resolve under the privileges of the calling schema; the header is tagged as GRWFUPTS.pls with a $Header value of 120.2 dated 2007/12/13, indicating a long-stable, low-churn codebase inherited from an earlier release line.

The package's core business purpose is to support the outbound/third-party integration workflow for Regulatory items, formulas, and properties — retrieving item and formula detail, initializing Workflow item types and third-party recipients, transmitting XML payloads, and providing consistent debug logging. Because the classification is PVT (private), it is not a supported public API surface; it exists to be called by other GR packages rather than directly by customers.

Key Procedures and Functions

The documented interface exposes fifteen procedures and functions:

• GET_ITEM_DETAILS — retrieves item number and description for a given organization and inventory item.
• GET_FORMULA_DETAILS — retrieves formula number and related details for a given formula id.
• WF_INIT — initializes the workflow context used by this package.
• GET_DEFAULT_ROLE — returns the default role used when initiating workflow notifications; this is the object of the user's search.
• CHECK_FOR_TECH_PARAM — validates whether a technical parameter is present on the input before processing.
• IS_IT_PROP_OR_FORMULA_CHANGE — determines whether an incoming change pertains to a property or to a formula, driving branching logic.
• SEND_OUTBOUND_DOCUMENT — transmits an outbound document through the third-party transport.
• SEND_DOC_RBLD_OUTBND — sends a rebuilt outbound document, typically re-dispatched after a failure.
• GETXMLTP — obtains the XML transport/third-party configuration for the delivery.
• INIT_THRDPRTY_WF — initializes the third-party workflow for outbound integration.
• THRDPRTY_INS — inserts third-party header/detail records.
• LOG_MSG — writes diagnostic messages respecting the FND_MSG_PUB message-level threshold.
• ITEMS_REQUESTED_INS — persists requested-item rows for the workflow.
• WF_INIT_ITEM_INFO_REQ — initializes the workflow for an item information request.
• APPS_INITIALIZE — standard FND initialization routine setting session context for the APPS environment.

Tables Accessed

The package reads and writes a well-defined set of APPS synonyms spanning ECX (e-commerce/transport) and GR (Regulatory) schemas:

• ECX_TP_HEADERS, ECX_TP_DETAILS, ECX_TRIGGER_ID_S — third-party delivery headers, details, and trigger id sequence supporting outbound transmission.
• FM_FORM_MST_B — formula master rows used by GET_FORMULA_DETAILS.
• GR_ITEM_GENERAL, GR_INV_ITEM_PROPERTIES, GR_ITEMS_REQUESTED, GR_ITEM_INFORMATION_SEQ, GR_PROPERTIES_B, GR_PROP_CHNG_TEMP, GR_LABELS_B, GR_LABELS_TL, GR_XML_PROPERTIES_MAP — Regulatory item/property/label stores and the XML property mapping driving payload construction.
• FND_APPLICATION, FND_USER — application context and user resolution (e.g., the default role returned by GET_DEFAULT_ROLE).

Usage Notes

GR_WF_UTIL_PVT is invoked internally by GR workflow components and by two other packages that reference it. It is not intended for direct customer invocation, though developers sometimes call GET_DEFAULT_ROLE from custom code to resolve the standard workflow notification role. Callers should ensure FND session context is initialized (APPS_INITIALIZE) and should not depend on this private interface across upgrades, as the AUTHID CURRENT_USER declaration and PVT classification make it an unsupported surface.