Search Results draw_process_children

Overview

APPS.WF_MONITOR is the server-side PL/SQL package that powers the Oracle Workflow Monitor, the administrative and diagnostic interface used to inspect workflow processes, item instances, activities, notifications, and role assignments within Oracle E-Business Suite. It is classified under product OWF (Oracle Workflow) with a public scope, an active lifecycle, and a compatibility rating of "S" (supported). The package constitutes a business entity mapped to WF_ENGINE.

Functionally, WF_MONITOR acts as the application tier behind the Monitor Java applet. Rather than rendering graphical workflow diagrams directly, it emits dynamic HTML and structured text streams that the applet parses line by line. The package exposes procedures for enumerating roles, resources, and process definitions, for retrieving access keys and URL references to workflow diagrams and notification envelopes, and for generating HTML frames that launch the correct applet. It also provides the FIND_INSTANCE capability that administrators invoke when searching for a specific workflow item instance by criteria such as item type, item key, or status.

Key Procedures and Functions

The package documents 27 procedures and functions. The principal entry points include:

• HTML — Returns a minimal dynamic HTML page instructing the browser which applet to launch, accepting item type, item key, administrative mode, access key, and NLS language.
• GETROLE — Streams role information back to the Monitor applet, optionally filtered by find criteria or titles only.
• GETRESOURCE / GETRESOURCES — Return information about a single resource or a set of resources matching a name pattern and resource type.
• GETPROCESS — Returns detailed information about workflow objects, accepting item type, item key, administrative mode, access key, and process name.
• GETACCESSKEY, GETURL, GETDIAGRAMURL, GETENVELOPEURL, GETADVANCEDENVELOPEURL — Supply authorization keys and construct URLs pointing to diagrams, envelopes, and advanced envelope views.
• FIND_INSTANCE, INSTANCE_LIST — Support locating and listing workflow item instances, forming the basis of the instance search feature.
• ENVELOPE, ENVELOPE_FRAME, NAME, SHOW, ENGAPI — Render envelope content, frame scaffolding, name lookups, display output, and engine API bridging.
• PROCESS_CHILDREN, DRAW_PROCESS_CHILDREN, GET_PROCESS_CHILDREN — Enumerate and render child activities within a process definition for diagram display.

Tables Accessed

WF_MONITOR reads from the core Workflow runtime and configuration tables through APPS synonyms, including WF_ACTIVITIES and WF_ACTIVITIES_TL (activity definitions and translations), WF_ACTIVITY_ATTR_VALUES and WF_ACTIVITY_TRANSITIONS (activity attribute values and routing), WF_ITEMS, WF_ITEM_ACTIVITY_STATUSES, and WF_ITEM_ATTRIBUTE_VALUES (instance state, activity status, and attribute data), WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES (notification queue content), WF_PROCESS_ACTIVITIES (process composition), and WF_RESOURCES (resource and role definitions). Utility packages DBMS_LOB, DBMS_SESSION, HTF, and HTP are referenced to assemble HTML output and manage session context.

Usage Notes

WF_MONITOR is normally invoked indirectly through the Workflow Monitor applet rather than by end users directly. Administrators reach it by navigating to the Workflow Monitor in the EBS environment, often via an administrative responsibility or a direct URL. The HTML procedure bootstraps the applet, after which the applet calls functions such as GETROLE, GETPROCESS, and FIND_INSTANCE to populate its panes. Because the package is declared public and referenced by 27 other packages, custom diagnostics and integrations may call its functions programmatically; however, such usage should respect the line-oriented output contract expected by the Monitor applet. The package should not be modified, as it is a shipped, supported Workflow component.