【OracleEBS】 用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;

关联查询

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;