用PL/SQL运行工作流代码,OracleEBS代码库,德仔网

代码语言

代码分类

【OracleEBS】用PL/SQL运行工作流

作者:Dezai.CN / 发布于2012/11/14/ 899

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;

试试其它关键字

　工作流　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)