25.1.9.1.11.2 Accessing Task Information
Reference task source columns and built-in substitutions from task actions.
When configuring an action, you can reference any of the Actions Source
columns by name using either :NAME in PL/SQL code or
&NAME. in email or push notification substitutions. You can
also reference any of the built-in substitution values below:
Table 25-4 Pre-Defined Task Substitutions
| Name | Purpose |
|---|---|
APEX$TASK_ID |
Unique ID of task instance |
APEX$TASK_PK |
Details Primary Key value of related business entity row |
APEX$TASK_STATE |
Mixed-case |
APEX$TASK_OUTCOME |
In Complete action, outcome of APPROVED, REJECTED |
APEX$TASK_CREATED_ON |
Date task instance was created |
APEX$TASK_SUBJECT |
Task subject |
APEX$TASK_DUE_ON |
Date task is due (or null if no due date) |
APEX$TASK_INITIATOR |
Case-sensitive username of task initiator |
APEX$TASK_OWNER |
Case-sensitive username of task's actual owner |
APEX$TASK_RENEWAL_COUNT |
Number of times task has been renewed |
APEX$TASK_MAX_RENEWAL_COUNT |
Maximum task renewal count |
APEX$TASK_PREVIOUS_ID |
Unique ID of previous task in renewal "chain" |
APEX$TASK_TEXT |
In Update Comment action, text of comment added. |
In addition, an Update Parameter action can use the HAS_TASK_PARAM_CHANGED, GET_TASK_PARAMETER_VALUE, and GET_TASK_PARAMETER_OLD_VALUE functions in the APEX_HUMAN_TASK package to get more information on which parameters have changed, what any parameter's current value is, and what a parameter's previous value was.
Parent topic: Reacting to Task Change Events