1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| declare
v_item_type wf_item_activity_statuses.item_type%TYPE;
v_item_key wf_item_activity_statuses.item_key%TYPE;
v_instance_label wf_process_activities.instance_label%TYPE;
begin
SELECT ias.item_type,
ias.item_key,
pa.instance_label
INTO v_item_type, v_item_key, v_instance_label
FROM wf_item_activity_statuses ias,
wf_process_activities pa
WHERE ias.item_key = '&IK'
AND ias.process_activity = pa.instance_id
AND ias.activity_status = 'ERROR'
Wf_Engine.HandleError(v_item_type, v_item_key, v_instance_label,
'RETRY');
end;
/
commit; |
Partager