25.4.4 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 25-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.
Figure 25-159 APEX Dictionary Views Related to Workflow Instances
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 25-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.
Figure 25-160 APEX Dictionary Views Related to Task Instances
Parent topic: Maintaining Workflow Processes