DECLARE l_item_key VARCHAR2(30) := 'CUX_DEMO_001'; --Item Type Internal Name l_item_type VARCHAR2(30); l_process VARCHAR2(30) := 'DEFAULT_PROCESS'; --Process Name BEGIN SELECT rcv_transactions_s.nextval INTO v_itemkey FROM dual; --Assign a item key --01 创建 wf_engine.createprocess(itemtype => l_item_type, itemkey => l_item_key, process => l_process, user_key => l_item_key); --02 初始化 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 --03 启动 wf_engine.startprocess(itemtype => l_item_type, itemkey => l_item_key); --Begins execution of the specified process. COMMIT; dbms_output.put_line(l_item_key); END;
相关查询SQL
SELECT * FROM wf_items; SELECT * FROM wf_item_activity_statuses; SELECT * FROM wf_notifications;