How to run workflow using PL/SQL
来源:互联网 发布:网络快车的新政策 编辑:程序博客网 时间:2024/05/20 00:38
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;
- How to run workflow using PL/SQL
- How (not) to complete workflow tasks using code in WSS3
- How To Load CLOB Data from a File into a CLOB column using PL/SQL
- Add Responsibility to USER using pl/sql
- Siebel HOW TO: How to Deactivate Workflow
- How to send an email from oracle workflow process using an AdHocRole?
- how to run couchDB
- How to run Conda?
- Using the DBMS_SQLTUNE package to Run the Sql Tuning Advisor
- How to run debug SQL with in front end(EBS)?
- How to run SSIS Project as a SQL Job
- How to use PL SQL Developer in Ubuntu
- How to Using exploits.
- How to using TOR
- HOW TO: Using CVS
- How to Using Theano
- How to Hack a WordPress Site using SQL Injection
- How-To: Run a MapReduce Job in CDH4 using Advanced Features
- jquery获取table下的td的select标签选中的值
- FFMPEG 1.0 在 Galaxy Tab 8.1 下运行失败的原因
- SVN:入门级安装和源码安装、Hooks设置
- 阅读源代码系列
- JSP九种内置对象及其作用
- How to run workflow using PL/SQL
- android之Notification通知
- php解析请求url并返回json数据
- something useful
- 阅读源代码系列
- java.lang.NoClassDefFoundError: com/sun/mail/util/LineInputStream
- SVN: 高级应用
- 电话来电显示
- ACM知识点