Friday, July 29, 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_comment := wf_notification.getattrtext(wf_engine.context_nid,'WF_NOTE');
     wf_notification.SetAttrText(wf_engine.context_nid, 'WF_NOTE', l_comment);

No comments:

Post a Comment