19.6.12 Runtime Views for Approvals
Learn about the APEX_TASKS
, APEX_TASK_COMMENTS
, APEX_TASK_HISTORY
, APEX_TASK_PARAMETERS
, and APEX_TASK_PARTICIPANTS
views.
There are five public views available for the Approvals Component:
APEX_TASKS
, for the properties of each task instance.APEX_TASK_COMMENTS
, for all comments entered on each task instance.APEX_TASK_HISTORY
, for the chronological series of operations performed during the lifecycle of a task instance, including the user associated with the update and the date the operation was performed.APEX_TASK_PARAMETERS
, for the parameters defined for a task instance along with their computed runtime values in String format.APEX_TASK_PARTICIPANTS
, for the list of participants on each task instance. Note that this list can differ from the list in the task definition due to business administrators inviting new participants.
Table 19-2 APEX_TASKS
Name | Null? | Type |
---|---|---|
TASK_ID |
NOT NULL |
NUMBER |
WORKSPACE_ID |
NOT NULL |
NUMBER |
WORKSPACE |
NOT NULL |
VARCHAR2(255) |
WORKSPACE_DISPLAY_NAME |
N/A | VARCHAR2(4000) |
APPLICATION_ID |
NOT NULL |
NUMBER |
APPLICATION_NAME |
NOT NULL |
VARCHAR2(255) |
TASK_DEF_ID |
N/A | NUMBER |
TASK_DEF_NAME |
N/A | VARCHAR2(255) |
TASK_DEF_STATIC_ID |
N/A | VARCHAR2(255) |
PREVIOUS_TASK_ID |
N/A | NUMBER |
SUBJECT |
N/A | VARCHAR2(1000) |
DUE_ON |
N/A | TIMESTAMP(6) WITH TIME ZONE |
PRIORITY |
NOT NULL |
NUMBER(1) |
PRIORITY_LEVEL |
N/A | VARCHAR2(6) |
DETAIL_PK |
N/A | VARCHAR2(400) |
INITIATOR |
N/A | VARCHAR2(255) |
ACTUAL_OWNER |
N/A | VARCHAR2(255) |
PREVIOUS_OWNER |
N/A | VARCHAR2(255) |
STATE_CODE |
N/A | VARCHAR2(10) |
STATE |
N/A | VARCHAR2(10) |
RENEWAL_COUNT |
N/A | NUMBER |
OUTCOME_CODE |
N/A | VARCHAR2(32) |
OUTCOME |
N/A | VARCHAR2(32) |
CREATED_BY |
N/A | VARCHAR2(255) |
CREATED_ON |
NOT NULL |
TIMESTAMP(6) WITH TIME ZONE |
LAST_UPDATED_BY |
N/A | VARCHAR2(255) |
LAST_UPDATED_ON |
N/A | TIMESTAMP(6) WITH TIME ZONE |
Table 19-3 APEX_TASK_COMMENTS
Name | Null? | Type |
---|---|---|
TASK_ID |
NOT NULL |
NUMBER |
WORKSPACE |
NOT NULL |
VARCHAR2(255) |
WORKSPACE_DISPLAY_NAME |
N/A | VARCHAR2(4000) |
APPLICATION_ID |
NOT NULL |
NUMBER |
APPLICATION_NAME |
NOT NULL |
VARCHAR2(255) |
CREATED_BY |
N/A | VARCHAR2(255) |
CREATED_ON |
N/A | TIMESTAMP(9) WITH TIME ZONE |
TEXT |
N/A | VARCHAR2(4000) |
Table 19-4 APEX_TASK_HISTORY
Name | Null? | Type |
---|---|---|
TASK_ID |
NOT NULL |
NUMBER |
WORKSPACE |
NOT NULL |
VARCHAR2(255) |
WORKSPACE_DISPLAY_NAME |
N/A | VARCHAR2(4000) |
APPLICATION_ID |
N/A | NUMBER |
APPLICATION_NAME |
NOT NULL |
VARCHAR2(255) |
EVENT_TYPE_CODE |
N/A | VARCHAR2(20) |
EVENT_TYPE |
N/A | VARCHAR2(15) |
EVENT_CREATOR |
N/A | VARCHAR2(255) |
EVENT_TIMESTAMP |
N/A | TIMESTAMP(9) WITH TIME ZONE |
OLD_STATE_CODE |
N/A | VARCHAR2(32) |
OLD_STATE |
N/A | VARCHAR2(10) |
NEW_STATE_CODE |
N/A | VARCHAR2(32) |
NEW_STATE |
N/A | VARCHAR2(10) |
OLD_ACTUAL_OWNER |
N/A | VARCHAR2(255) |
NEW_ACTUAL_OWNER |
N/A | VARCHAR2(255) |
OLD_PRIORITY |
N/A | NUMBER |
NEW_PRIORITY |
N/A | NUMBER |
OLD_DUE_ON |
N/A | VARCHAR2(4000) |
NEW_DUE_ON |
N/A | VARCHAR2(4000) |
OUTCOME_CODE |
N/A | VARCHAR2(32) |
ACTION_NAME |
N/A | VARCHAR2(255) |
ACTION_STATUS |
N/A | VARCHAR2(7) |
ACTION_TIMESTAMP |
N/A | TIMESTAMP WITH TIME ZONE |
SUCCESS_MSG |
N/A | VARCHAR2(4000) |
FAILURE_MSG |
N/A | VARCHAR2(4000) |
OUTCOME |
N/A | CHAR(8) |
DISPLAY_MSG |
N/A | VARCHAR2(4000) |
Table 19-5 APEX_TASK_PARAMETERS
Name | Null? | Type |
---|---|---|
TASK_ID |
NOT NULL |
NUMBER |
TASK_DEF_PARAM_ID |
N/A | NUMBER |
WORKSPACE |
NOT NULL |
VARCHAR2(255) |
WORKSPACE_DISPLAY_NAME |
N/A | VARCHAR2(4000) |
APPLICATION_ID |
NOT NULL |
NUMBER |
APPLICATION_NAME |
NOT NULL |
VARCHAR2(255) |
PARAM_LABEL |
N/A | VARCHAR2(255) |
PARAM_STATIC_ID |
N/A | VARCHAR2(255) |
IS_REQUIRED |
N/A | VARCHAR2(1) |
IS_VISIBLE |
N/A | VARCHAR2(1) |
PARAM_VALUE |
N/A | VARCHAR2(255) |
Table 19-6 APEX_TASK_PARTICIPANTS
Name | Null? | Type |
---|---|---|
TASK_ID |
NOT NULL |
NUMBER |
WORKSPACE |
NOT NULL |
VARCHAR2(255) |
WORKSPACE_DISPLAY_NAME |
N/A | VARCHAR2(4000) |
APPLICATION_ID |
NOT NULL |
NUMBER |
APPLICATION_NAME |
NOT NULL |
VARCHAR2(255) |
PARTICIPANT |
N/A | VARCHAR2(4000) |
PARTICIPANT_TYPE |
N/A | VARCHAR2(15) |
IDENTITY_TYPE |
N/A | VARCHAR2(32) |
Parent topic: Managing Approvals