GET_TASK_PARAMETER_OLD_VALUE Function

9.16 GET_TASK_PARAMETER_OLD_VALUE Function

Caution:

This API is deprecated and will be removed in a future release.

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 (Deprecated)