Thursday, July 28, 2016

WF_NOTE in Workflow


select count(*) into L_attr_cnt from wf_notification_attributes where notification_id =  wf_engine.context_nid and name = 'WF_NOTE'  ;
if  L_attr_cnt = 0 then
wf_notification.ADDATTR( wf_engine.context_nid,'WF_NOTE');
end if;
l_sp_comment := wf_notification.getattrtext(wf_engine.context_nid,'WF_NOTE');
wf_notification.SetAttrText(wf_engine.context_nid, 'WF_NOTE', l_sp_comment);

-- Used to Show comments in Comment Column in workflow Notifications.

No comments:

Post a Comment