在工作流的WEB审批界面,有批准、拒绝等按钮,我们只要点击他们就会让流程流走下去。那如何实现不使用WEB页面点击,而是直接调用包实现勒?
经过资料查找,发现了工作流引擎包wf_engine.completeactivity。传递的参数有itemtype ,itemkey,activity,RESULT。
参数查找SQL:
1. itemtype、itemkey、activity获取sql
SELECT n.notification_id,
n.group_id,
n.message_type,
n.item_key,
p.process_name,
p.activity_name
FROM wf_notifications n,wf_item_activity_statuses a,wf_process_activities p
where n.status = 'OPEN'
and a.item_type = n.message_type
and a.item_key = n.item_key
and a.notification_id = n.notification_id
and p.instance_id = a.process_activity
and p.process_item_type = a.item_type
and n.message_type='APEXP' --流程类型
2. RESULT参数返回值
SELECT t.ITEM_TYPE,
t.LOOKUP_TYPE,
l.LOOKUP_CODE
FROM wf_lookup_types t, wf_lookups l
WHERE t.ITEM_TYPE = 'APEXP' --流程类型
and l.LOOKUP_TYPE = t.LOOKUP_TYPE