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;