Search Results gms_workflow_utils




Overview
Explore in AI Chat

Overview

GMS_WORKFLOW_UTILS is a PL/SQL utility package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM as an "OTHER" API type. It belongs to the Oracle Grants Management (GMS) product family and provides the workflow plumbing that underpins Grants Management approval processes. Its name and procedure signatures indicate that it acts as a bridge between Grants Management business events and the Oracle Workflow engine, seeding the workflow process records that Oracle Workflow requires in order to route, track, and audit an approval.

The package header retained in the ETRM excerpt carries a header comment dated 2005 and defines four public program units. It is referenced by exactly one other package, confirming its role as a shared internal utility rather than a wide-facing public API. For EBS 12.1.1 and 12.2.2, the package ships as part of the standard APPS code set and is generally compiled in the same schema and dependency chain as the rest of the Grants Management application objects.

Key Procedures and Functions

  • INSERT_WF_PROCESSES — Inserts and initiates workflow process records for a Grants Management entity. It takes the workflow type code, item type, item key, and a pair of entity keys that identify the underlying award, budget, or proposal, with optional description and standard error-handling out parameters. This is the package's primary entry point for launching a workflow.
  • SET_GLOBAL_ATTR — Populates Oracle Workflow global attributes for an active item type and item key. Global attributes allow downstream activities and notifications to reference contextual Grants Management data without repeated lookups.
  • SET_NOTIFICATION_MESSAGES — Assembles and sets the notification message content associated with a workflow item, so that approvers receive meaningful text when a notification is delivered.
  • GET_APPLICATION_ID — A function returning the application identifier for a given responsibility identifier. Per the embedded comments, it returns null when no application id is found and returns the Oracle error number when an Oracle error occurs. It is declared with PRAGMA RESTRICT_REFERENCES (WNDS, WNPS), making it callable from SQL and safe for use in restricted contexts.

Tables Accessed

Documented access is limited to two tables reached through APPS synonyms. FND_RESPONSIBILITY is read by GET_APPLICATION_ID to resolve a responsibility to its owning application; this is a standard Foundation lookup and is read-only. GMS_WF_PROCESSES is the Grants Management workflow tracking table, read and written by INSERT_WF_PROCESSES and the attribute and notification procedures to persist the workflow item state that Oracle Workflow then drives forward. Additional Workflow runtime tables are almost certainly touched indirectly through Workflow APIs rather than by direct DML.

Usage Notes

This package is an internal implementation utility. It is not intended for direct customer invocation; instead it is called from Grants Management approval logic, typically triggered when a user submits an award, budget, or proposal for approval in the corresponding OAF or Forms-based pages. Because it manipulates Workflow item state, any custom code that calls it must preserve the documented error-handling contract, returning err_code, err_stage, and err_stack to the caller so that failures can be surfaced and logged. In 12.2.2 the same package and signature are retained, so upgrades from 12.1.1 do not require code changes. Customizations should prefer supported Workflow APIs where possible.