DBA Data[Home] [Help]

APPS.MST_WORKFLOW_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 18

  select compile_designator
  from mst_plans
  where plan_id = l_plan_id;
Line: 27

  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;
Line: 48

  DeleteActivities(p_plan_id);
Line: 107

PROCEDURE Select_Planner( itemtype  in  varchar2
                        , itemkey   in  varchar2
                        , actid     in  number
                        , funcmode  in  varchar2
			, resultout out NOCOPY varchar2) is

  l_msg  varchar2(500);
Line: 136

END Select_Planner;
Line: 146

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;
Line: 165

  OPEN Cur_Delete_Activities (l_item_type,l_plan_char);
Line: 166

  FETCH Cur_Delete_Activities BULK COLLECT INTO l_item_key_tab;
Line: 167

  CLOSE Cur_Delete_Activities;
Line: 171

    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));
Line: 184

    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);
Line: 190

    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);
Line: 196

    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);
Line: 212

    print_info(p_log_message, 'Error in delete activities:'|| to_char(sqlcode) || ':' || substr(sqlerrm,1,100));
Line: 214

END DeleteActivities;