Search Results gma_wfstd_p




Overview
Explore in AI Chat

Overview

GMA_WFSTD_P is a PL/SQL package body owned by the APPS schema that provides the standard workflow support layer for Oracle Process Manufacturing (OPM) quality and process execution functionality in Oracle E-Business Suite 12.1.1 and 12.2.2. The package encapsulates the runtime logic used by the Oracle Workflow engine to determine role assignment, approval requirements, and process enablement flags when process and activity data records transition through their defined workflow lifecycles. It acts as a bridge between the OPM process/activity definition and collection tables and the generic Workflow infrastructure supplied by WF_CORE and the FND message and profile utilities. The package is classified as OTHER in the ETRM repository, indicating that it is an internal, non-public API rather than a customer-callable interface. It is listed as VALID and is not referenced by any other database object, which confirms its position at the top of the dependency hierarchy as a terminal implementation unit invoked externally by the Workflow engine.

Key Procedures and Functions

The package exposes five documented procedures and functions:

  • GET_ROLE — Resolves the workflow role (user, responsibility, or group) that should be assigned to a given process or activity workflow instance. It is the principal mechanism by which OPM workflow routing identifies the responsible party.
  • CHECK_PROCESS_APPROVAL_REQ — Determines whether an approval step is required for a process-level workflow record, based on the process definition and associated control parameters.
  • CHECK_ACTIVITY_APPROVAL_REQ — Performs the equivalent evaluation for activity-level workflow records, allowing approval requirements to differ between process headers and their constituent activities.
  • CHECK_PROCESS_ENABLED — Verifies whether the process workflow feature is enabled for the current operating context, typically by inspecting profile option settings through FND_PROFILE.
  • WF_GET_CONTORL_PARAMS — Retrieves the set of workflow control parameters that govern routing and approval behaviour for the record being processed. The procedure name is spelled with the internal typographical variant "CONTORL" as documented.

Tables Accessed

The package reads and writes the OPM workflow staging and collection tables through APPS synonyms. GMA_PROCDEF_WF and GMA_PROCDATA_WF hold process definition and process instance data respectively, while GMA_ACTDEF_WF and GMA_ACTDATA_WF hold the corresponding activity-level definition and instance data. The view layer is accessed through GMA_PROCCOL_WF_B, GMA_PROCCOL_WF_VL, GMA_ACTCOL_WF_B, GMA_ACTCOL_WF_TL, and GMA_ACTCOL_WF_VL, which supply base, translated, and validation view access to process and activity collections. DBMS_SQL is used for dynamic SQL execution, and WF_CORE, FND_MESSAGE, FND_PROFILE, APP_EXCEPTION, and STANDARD provide the workflow, messaging, profile, and error-handling utilities on which the package depends.

Usage Notes

GMA_WFSTD_P is invoked by the Oracle Workflow engine during execution of OPM process and activity approval workflows, and by the sixteen dependent database objects identified in the ETRM dependency report. It is not intended for direct invocation from custom forms or concurrent programs. Because it is a package body with no public API classification, customisations should avoid calling it directly; instead, extensions should target the documented OPM workflow configuration and the profile options that CHECK_PROCESS_ENABLED and WF_GET_CONTORL_PARAMS evaluate. When troubleshooting routing or approval behaviour, DBMS_OUTPUT tracing combined with inspection of the GMA_*_WF tables provides the most reliable diagnostic path, since failures are surfaced through APP_EXCEPTION and FND_MESSAGE rather than through return codes exposed to callers.