The following lines contain the word 'select', 'insert', 'update' or 'delete':
select compile_designator
from mst_plans
where plan_id = l_plan_id;
select med.exception_detail_id
, med.exception_type
, 'EXCEPTION_PROCESS1'
, mst_wb_util.get_trip_tokenized_exception(med.plan_id, med.exception_detail_id, med.trip_id1, 1)
from mst_excep_preferences mep
, mst_exception_details med
where mep.exception_type = med.exception_type
and mep.user_id = -9999
and mep.work_flow_item_type = '1' -- 1 stands for status:enabled
and med.plan_id = l_plan_id;
DeleteActivities(p_plan_id);
PROCEDURE Select_Planner( itemtype in varchar2
, itemkey in varchar2
, actid in number
, funcmode in varchar2
, resultout out NOCOPY varchar2) is
l_msg varchar2(500);
END Select_Planner;
PROCEDURE DeleteActivities( arg_plan_id in number) IS
CURSOR Cur_Delete_Activities (l_item_type in varchar2, l_plan_char in varchar2)
IS
SELECT wi.item_key
FROM wf_items wi
WHERE wi.item_type = l_item_type
AND wi.item_key like l_plan_char;
OPEN Cur_Delete_Activities (l_item_type,l_plan_char);
FETCH Cur_Delete_Activities BULK COLLECT INTO l_item_key_tab;
CLOSE Cur_Delete_Activities;
UPDATE wf_notifications wn
SET wn.end_date = sysdate
WHERE wn.group_id IN (SELECT wias.notification_id
FROM wf_item_activity_statuses wias
WHERE wias.item_type = l_item_type
AND wias.item_key = l_item_key_tab(i)
UNION ALL
SELECT wiah.notification_id
FROM wf_item_activity_statuses_h wiah
WHERE wiah.item_type = l_item_type
AND wiah.item_key = l_item_key_tab(i));
UPDATE wf_items wi
SET wi.end_date = sysdate
WHERE wi.item_type = l_item_type
AND wi.item_key = l_item_key_tab(i);
UPDATE wf_item_activity_statuses wias
SET wias.end_date = sysdate
WHERE wias.item_type = l_item_type
AND wias.item_key = l_item_key_tab(i);
UPDATE wf_item_activity_statuses_h wiah
SET wiah.end_date = sysdate
WHERE wiah.item_type = l_item_type
AND wiah.item_key = l_item_key_tab(i);
print_info(p_log_message, 'Error in delete activities:'|| to_char(sqlcode) || ':' || substr(sqlerrm,1,100));
END DeleteActivities;