Accessing Workflow and Task Data
Understand APEX dictionary views and packages for workflows, tasks, and their definitions.
APEX dictionary views shown below contain complete information about your workflow definitions and instances. The APEX_WORKFLOW package is your API to work programmatically with workflows.
Table 7 APEX Dictionary Views for Workflows
| Workflow | View | Parent View |
|---|---|---|
| Definitions | APEX_APPL_WORKFLOWS |
APEX_APPLICATIONS |
| Parameter Definitions | APEX_APPL_WORKFLOW_PARAMS |
APEX_APPL_WORKFLOWS |
| Process Parameter Values | APEX_APPL_WORKFLOW_COMP_PARAMS |
APEX_APPLICATION_PAGE_PROC |
| Versions | APEX_APPL_WORKFLOW_VERSIONS |
APEX_APPL_WORKFLOWS |
| Variable Definitions | APEX_APPL_WORKFLOW_VARIABLES |
APEX_APPL_WORKFLOW_VERSIONS |
| Participant Definitions | APEX_APPL_WORKFLOW_PARTICIPANTS |
APEX_APPL_WORKFLOW_VERSIONS |
| Activity Definitions | APEX_APPL_WORKFLOW_ACTIVITIES |
APEX_APPL_WORKFLOW_VERSIONS |
| Activity Variable Definitions | APEX_APPL_WORKFLOW_ACT_VARS |
APEX_APPL_WORKFLOW_ACTIVITIES |
| Branches | APEX_APPL_WORKFLOW_BRANCHES |
APEX_APPL_WORKFLOW_ACTIVITIES |
| Transitions | APEX_APPL_WORKFLOW_TRANSITIONS |
APEX_APPL_WORKFLOW_ACTIVITIES |
| Instances | APEX_WORKFLOWS |
APEX_APPL_WORKFLOW_VERSIONS |
| Activities | APEX_WORKFLOW_ACTIVITIES |
APEX_WORKFLOWS |
| Activity Variables | APEX_WORKFLOW_ACTIVITY_VARS |
APEX_WORKFLOW_ACTIVITIES |
| Variables | APEX_WORKFLOW_VARIABLES |
APEX_WORKFLOWS |
| Parameters | APEX_WORKFLOW_PARMETERS |
APEX_WORKFLOWS |
| Participants | APEX_WORKFLOW_PARTICIPANTS |
APEX_WORKFLOWS |
| Audit | APEX_WORKFLOW_AUDIT |
APEX_WORKFLOWS |
The diagram shows the relationship between dictionary views related to workflow definition metadata and workflow instance data.
Description of the illustration workflow-views.jpg
The additional views shown below contain all relevant information about your task definitions and instances. The APEX_HUMAN_TASK package is your API to work programmatically with tasks.
Table 8 APEX Dictionary Views for Workflows
| Task | View | Parent View |
|---|---|---|
| Definitions | APEX_APPL_TASKDEFS |
APEX_APPLICATIONS |
| Parameter Definitions | APEX_APPL_TASKDEF_PARAMS |
APEX_APPL_TASKDEFS |
| Participant Definitions | APEX_APPL_TASKDEF_PARTICIPANTS |
APEX_APPL_TASKDEFS |
| Action Definitions | APEX_APPL_TASKDEF_ACTIONS |
APEX_APPL_TASKDEFS |
| Instances | APEX_TASKS |
APEX_APPL_TASKDEFS |
| Parameters | APEX_TASK_PARMETERS |
APEX_TASKS |
| Participants | APEX_TASK_PARTICIPANTS |
APEX_TASKS |
| History | APEX_TASK_HISTORY |
APEX_TASKS |
| Comments | APEX_TASK_COMMENTS |
APEX_TASKS |
The diagram shows the relationship between dictionary views related to task definition metadata and task instance data.
