Get Oracle Workflow Action History Details

CREATE OR REPLACE FUNCTION APPS.XXXX_get_hist (
p_nid IN PLS_INTEGER,
p_disp_type IN VARCHAR2 DEFAULT wf_notification.doc_text
)
RETURN VARCHAR2
AS
v_hist VARCHAR2 (32767);
BEGIN
wf_notification.getcomments2
(p_nid => 157531211,
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 XXXX_get_hist;
/

Advertisements