7.20 HAS_TASK_PARAM_CHANGED Function

This function checks if the value of this task paramter has been modified in the current session. Returns NULL when the parameter does not exist.

Syntax

APEX_APPROVAL.HAS_TASK_PARAM_CHANGED (
             p_task_id                IN NUMBER,
             p_param_static_id        IN VARCHAR2 )
RETURN BOOLEAN;

Parameters

Parameter	Description
p_task_id	The Task ID.
p_param_static_id	The static ID of the parameter.

Example

BEGIN
    return apex_approval.has_task_param_changed(
                             p_task_id         => 1234,
                             p_param_static_id => 'REQ_AMOUNT'
    );
END;