Search Results create_workflow_process

Overview

PA_WORKFLOW_UTILS is a PL/SQL utility package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It provides the internal plumbing that allows Oracle Projects to participate in Oracle Workflow-driven business processes. Its central purpose is to evaluate project status configuration, determine whether a workflow should be launched for a given project status transition, and then insert the corresponding workflow process, initialize item attributes, and post notification messages into the Workflow runtime tables. The package header carries the identifier $Header: PAWFUTLS.pls 120.1 2005/08/19 17:08:03 mwasowic noship $, indicating a long-lived, stable interface that is shipped but not exposed as a public API. The recorded API classification is OTHER, which signals that the package is an internal helper rather than a supported external integration point. Nine documented procedures and functions make up the interface, and the package is referenced by twenty-three other packages, confirming its position as a shared dependency across the Projects workflow layer.

Key Procedures and Functions

• INSERT_WF_PROCESSES — Creates the workflow process record for a given item type and item key, accepting entity keys, an optional description, and standard error code, stage, and stack OUT parameters.
• SET_GLOBAL_ATTR — Populates global Workflow item attributes for the specified item type and item key so that downstream activities can reference them.
• SET_NOTIFICATION_MESSAGES — Prepares notification messages associated with the workflow item, supporting the notification content used during process execution.
• GET_APPLICATION_ID — Function that returns the application identifier associated with a responsibility; returns null when none is found and the Oracle error number when an error occurs. It is declared with PRAGMA RESTRICT_REFERENCES (WNDS, WNPS), confirming it performs no database writes.
• GET_WORKFLOW_INFO — Resolves workflow configuration for a project status code and status type, returning the enablement flag, workflow item type, workflow process name, and success and failure status codes, together with standard message and return status outputs.
• CANCEL_WORKFLOW — Terminates an in-flight workflow associated with a Projects entity.
• CREATE_WORKFLOW_PROCESS — Establishes a workflow process instance for the relevant item type and key.
• START_WORKFLOW_PROCESS — Launches the configured workflow process after creation and attribute initialization.
• MODIFY_WF_CLOB_CONTENT — Alters workflow content held as a CLOB, using DBMS_LOB facilities.

Tables Accessed

• PA_PROJECT_STATUSES — Read to determine whether workflow is enabled for a given project status code and status type, and which process and success or failure statuses apply.
• PA_WF_PROCESSES — Stores the workflow process definitions and instances associated with Projects entities.
• PA_WORKFLOW_ITEMKEY_S — Sequence used to generate unique workflow item keys for new process instances.
• PA_PAGE_CONTENTS — Accessed for workflow-related page content used in notification or process context.
• FND_RESPONSIBILITY — Queried by GET_APPLICATION_ID to map a responsibility to its owning application.
• DBMS_LOB — Used for CLOB manipulation in MODIFY_WF_CLOB_CONTENT.
• DUAL — Used for scalar evaluation and default value selection.

Usage Notes

PA_WORKFLOW_UTILS is invoked internally when Oracle Projects raises a workflow event, most commonly during project status changes that are configured to trigger approval or notification flows. The typical sequence is GET_WORKFLOW_INFO to resolve configuration, followed by CREATE_WORKFLOW_PROCESS, SET_GLOBAL_ATTR, and START_WORKFLOW_PROCESS, with SET_NOTIFICATION_MESSAGES supplying notification content. Because the package is not classified as a public API, custom code should call supported Projects or Workflow APIs rather than these procedures directly, and any such call carries upgrade risk. The package is relevant to Projects forms and concurrent programs that manage workflow-enabled statuses, and its heavy reuse across twenty-three other packages means diagnostic efforts should account for callers that depend on its behavior.