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.