Function for geting WF Notification History

CREATE OR REPLACE FUNCTION get_hist ( p_nid IN PLS_INTEGER
, p_disp_type IN VARCHAR2 DEFAULT WF_NOTIFICATION.doc_text ) RETURN VARCHAR2 AS


---------------------------------------------------------------------
-- This Function is created for returning the Notification History --
-- Para Meter : p_nid ( Notification ID) --
-- Created By : Ajit Raut Creation Date: 10-Feb-2009 --

-- Eg: select get_hist('9962') from dual --

---------------------------------------------------------------------
v_hist VARCHAR2(32767);
BEGIN
Wf_Notification.GetComments2 ( p_nid => p_nid

, p_display_type => NVL(p_disp_type,WF_NOTIFICATION.doc_text)
, p_hide_reassign => 'Y'
, p_hide_requestinfo => 'Y'
, p_action_history => v_hist );


RETURN v_hist;


END get_hist;

/