How to run workflow using PL/SQL

Run workflow from PL/SQL

declare
  v_itemtype varchar2(30):=\'TPLEAVE\';          --Item Type Internal Nam
  v_process varchar2(30):=\'DEFAULT_PROCESS\';   --Process Name
  v_itemkey varchar2(30);
begin
  select rcv_transactions_s.nextval into v_itemkey from dual; --Assign a item key

  wf_engine.createprocess(v_itemtype, v_itemkey,v_process);  --Creates a new runtime process for an application item.

  wf_engine.SetItemAttrText(v_itemtype ,v_itemkey,\'EMPLOYEE\',\'OPERATIONS\');  --Input Parameter
  wf_engine.SetItemAttrText(v_itemtype ,v_itemkey,\'MANAGER\',\'CBROWN\');     --Input Parameter
  wf_engine.SetItemAttrDate(v_itemtype ,v_itemkey,\'START_DATE\',sysdate);   --Input Parameter
  wf_engine.SetItemAttrDate(v_itemtype ,v_itemkey,\'END_DATE\',SYSDATE+1);   --Input Parameter


  wf_engine.StartProcess(v_itemtype, v_itemkey);    --Begins execution of the specified process.
  commit;
end;

Related Queries:

select * from wf_items where item_type = \'TPLEAVE\' ;

select * from wf_item_activity_statuses where item_type = \'TPLEAVE\' and item_key= \'4088307\' ;

select * from wf_notifications where notification_id = 8972914;



请使用浏览器的分享功能分享到微信等