7.15 GET_TASK_PARAMETER_OLD_VALUE Function
This function retrieves the old value of a parameter of this task that was updated in the current session. Raises a "No Data Found" error if the parameter does not exist and p_raise_error flag
is set to TRUE
.
Syntax
APEX_APPROVAL.GET_TASK_PARAMETER_OLD_VALUE (
p_task_id IN NUMBER,
p_param_static_id IN VARCHAR2,
p_raise_error IN BOOLEAN DEFAULT TRUE )
Parameters
Parameter | Description |
---|---|
p_task_id |
The Task ID. |
p_param_static_id |
The static ID of the parameter. |
p_raise_error |
If TRUE , raises an error if the parameter is not found.
|
Returns
VARCHAR2 - The old value of this parameter in VARCHAR2 format.
Example
BEGIN
return apex_approval.get_task_parameter_old_value(
p_task_id => 1234,
p_param_static_id => 'REQ_AMOUNT',
p_raise_error => false);
END;
Parent topic: APEX_APPROVAL