APPS.MRP_MSC_EXP_WF SQL Statements

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

Line: 40

    select a.name
    from wf_roles a,
         jtf_rs_salesreps b
    where a.orig_system = 'PER'
    and  a.orig_system_id = b.person_id
    and  b.salesrep_id = to_number(l_salesrep)
    and  a.status = 'ACTIVE'
    and  rownum = 1;

Line: 990

PROCEDURE DeleteActivities( arg_plan_id in number) IS

    TYPE DelExpType is REF CURSOR;

Line: 993

  delete_activities_c DelExpType;

Line: 1000

     sql_stmt := ' SELECT item_key ' ||
                ' FROM wf_items' ||
                ' WHERE item_type = :l_item_type' ||
                ' AND   item_key like '''|| to_char(arg_plan_id) || '-%''';

Line: 1005

    OPEN delete_activities_c for sql_stmt using l_item_type;

Line: 1008

        FETCH DELETE_ACTIVITIES_C INTO l_item_key;

Line: 1009

        EXIT WHEN DELETE_ACTIVITIES_C%NOTFOUND;

Line: 1014

        update wf_notifications
         set    end_date = sysdate
         where  group_id in
          (select notification_id
          from wf_item_activity_statuses
          where item_type = 'MRPEXWFS'
          and item_key = l_item_key
          union
          select notification_id
          from wf_item_activity_statuses_h
          where item_type = 'MRPEXWFS'
          and item_key = l_item_key);

Line: 1027

        update wf_items
         set end_date = sysdate
         where item_type = 'MRPEXWFS'
         and item_key = l_item_key;

Line: 1032

        update wf_item_activity_statuses
         set end_date = sysdate
         where item_type = 'MRPEXWFS'
         and item_key = l_item_key;

Line: 1037

        update wf_item_activity_statuses_h
         set end_date = sysdate
         where item_type = 'MRPEXWFS'
         and item_key = l_item_key;

Line: 1045

      CLOSE delete_activities_c;

Line: 1050

    msc_util.msc_debug('Error in delete activities:'|| to_char(sqlcode) || ':'
    || substr(sqlerrm,1,100));

Line: 1054

END DeleteActivities;

Line: 1067

     select user_id
       into p_user_id
       from fnd_user
      where user_name = p_planner;

Line: 1072

      SELECT APPLICATION_ID
        INTO p_app_id
        FROM FND_APPLICATION_VL
       WHERE APPLICATION_NAME = 'Oracle Manufacturing' ;

Line: 1077

      SELECT responsibility_id
        INTO p_resp_id
        FROM FND_responsibility_vl
        where application_Id = p_app_id
          and rownum = 1;

Line: 1135

  select to_char(mrp_form_query_s.nextval)
    into item_key
   from dual;