6.3 ADD_TO_HISTORY Procedure

This procedure adds a log entry into the task history and is to be used within task action code.

Syntax

APEX_APPROVAL.ADD_TO_HISTORY (
    p_message IN VARCHAR2 )

Parameters

Table 6-3 ADD_TO_HISTORY Parameters

Parameter	Description
p_message	Message to add into to the task history.

Example

The following example demonstrates how to write log information. The task action uses select * from emp as the action source query.

BEGIN
    apex_approval.add_to_history(
        p_message => 'Approved leave for employee with empno: ' || :EMPNO );
    my_logic_package.update_emp_leave_balance(
        p_empno        => :EMPNO,
        p_no_of_days   => :NO_OF_DAYS);
END;