Substitution Strings and Bind Variables for Tasks

[admin]

APEX$TASK_PK If a primary key column has been defined, this bind variable contains the primary key value.
APEX$TASK_PK can also be used as a bind variable in any PL/SQL query used by Task Definition Actions and Task Definition Participants. When used as a bind variable, the syntax is :APEX$TASK_PK
APEX$TASK_ID This substitution string contains the id of the task for which this action is defined.
APEX$TASK_SUBJECT This substitution string contains the subject of the task for which this action is defined.
APEX$TASK_STATE This substitution string contains the current state of the task for which this action is defined.
APEX$TASK_OUTCOME This substitution string contains the outcome of the task for which this action is defined. This variable is populated only for tasks in Completed state.
APEX$TASK_CREATED_ON Contains the timestamp of the task creation, in the YYYY-MM-DD"T"HH24:MI:SS.FF3TZH:TZM format.
APEX$TASK_INITIATOR Contains the user who has initiated the task. This value defaults to the logged-in user if not explicitly specified as part of the Human Task - Create Page Process type.
APEX$TASK_DUE_ON Contains the timestamp of when this task is due, in the YYYY-MM-DD"T"HH24:MI:SS.FF3TZH:TZM format.
APEX$TASK_OWNER Contains the user to whom the task is currently assigned.