822: hr_utility.set_location('send_email_to : '||send_email_to,50);
823: hr_utility.set_location('description : '||description,50);
824:
825:
826: wf_engine.createprocess(l_itemtype, l_itemkey, 'MAIN_PROCESS');
827:
828: wf_engine.setitemuserkey(itemtype => l_itemtype
829: ,itemkey => l_itemkey
830: ,userkey => 'USERKEY: ' || l_itemkey);
824:
825:
826: wf_engine.createprocess(l_itemtype, l_itemkey, 'MAIN_PROCESS');
827:
828: wf_engine.setitemuserkey(itemtype => l_itemtype
829: ,itemkey => l_itemkey
830: ,userkey => 'USERKEY: ' || l_itemkey);
831:
832: wf_engine.setitemowner(itemtype => l_itemtype
828: wf_engine.setitemuserkey(itemtype => l_itemtype
829: ,itemkey => l_itemkey
830: ,userkey => 'USERKEY: ' || l_itemkey);
831:
832: wf_engine.setitemowner(itemtype => l_itemtype
833: ,itemkey => l_itemkey
834: ,owner => 'SYSADMIN');
835:
836: wf_engine.setitemattrtext(itemtype => l_itemtype
832: wf_engine.setitemowner(itemtype => l_itemtype
833: ,itemkey => l_itemkey
834: ,owner => 'SYSADMIN');
835:
836: wf_engine.setitemattrtext(itemtype => l_itemtype
837: ,itemkey => l_itemkey
838: ,aname => 'EPS_ID'
839: ,avalue => eps_id);
840:
837: ,itemkey => l_itemkey
838: ,aname => 'EPS_ID'
839: ,avalue => eps_id);
840:
841: wf_engine.setitemattrtext(itemtype => l_itemtype
842: ,itemkey => l_itemkey
843: ,aname => 'SEND_TO_EMAIL'
844: ,avalue => send_email_to);
845:
842: ,itemkey => l_itemkey
843: ,aname => 'SEND_TO_EMAIL'
844: ,avalue => send_email_to);
845:
846: wf_engine.setitemattrtext(itemtype => l_itemtype
847: ,itemkey => l_itemkey
848: ,aname => 'EPS_NOTIFICATION'
849: ,avalue => description);
850:
847: ,itemkey => l_itemkey
848: ,aname => 'EPS_NOTIFICATION'
849: ,avalue => description);
850:
851: wf_engine.setitemattrtext(itemtype => l_itemtype
852: ,itemkey => l_itemkey
853: ,aname => 'SEND_TO_ROLE'
854: ,avalue => user_name);
855:
852: ,itemkey => l_itemkey
853: ,aname => 'SEND_TO_ROLE'
854: ,avalue => user_name);
855:
856: wf_engine.startprocess(l_itemtype, l_itemkey);
857:
858: COMMIT;
859: END start_eps_wf;
860:
870: v_role_email VARCHAR2(300);
871: n_ctr INTEGER := 0;
872:
873: BEGIN
874: v_role_email := upper(wf_engine.getitemattrtext(itemtype => itemtype
875: ,itemkey => itemkey
876: ,aname => 'SEND_TO_EMAIL'));
877:
878: hr_utility.set_location('v_role_email : '||v_role_email,50);