add

About Me

My photo
Oracle Apps - Techno Functional consultant

Wednesday, July 23

How to Launch Workflow from PL SQL

The below script will launch the desired workflow FROM PL/SQL code:

DECLARE
  v_itemtype VARCHAR2(50);
  v_itemkey  VARCHAR2(50);
  v_process  VARCHAR2(50);
  v_userkey  VARCHAR2(50);
BEGIN
  v_itemtype          := 'DEMOIT';
  v_itemkey           := '1233';
  v_userkey           := '1233';
  v_process           := 'DEMOPROCESS';
  WF_ENGINE.Threshold := -1;
  WF_ENGINE.CREATEPROCESS(v_itemtype, v_itemkey, v_process);
  wf_engine.setitemuserkey(v_itemtype, v_itemkey, v_userkey );
  wf_engine.setitemowner (v_itemtype, v_itemkey,'SYSADMIN');
  WF_ENGINE.STARTPROCESS(v_itemtype, v_itemkey);
  COMMIT;
EXCEPTION
WHEN OTHERS THEN
  dbms_output.put_line(SQLERRM);
END;

No comments: