APPS.JTF_TASK_WORKFLOW_PKG SQL Statements

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

Line: 30

      SELECT end_date
      FROM   wf_items
      WHERE  item_type = 'JTFTASK'
      AND    item_key  = l_itemkey;

Line: 77

    SELECT display_name INTO l_display_name
      FROM WF_RUNNABLE_PROCESSES_V
     WHERE item_type = p_item_type
       AND process_name = p_process_name;

Line: 215

         SELECT jtf_task_workflow_process_s.nextval
           FROM dual;

Line: 221

         SELECT task_name, description, owner_type_code owner_code, owner_id, task_number
           FROM jtf_tasks_v
          WHERE task_id = p_task_id;*/

Line: 228

         SELECT a.task_name, a.description, a.owner_type_code owner_code, a.owner_id, a.task_number
              FROM jtf_tasks_vl a
              WHERE a.task_id = p_task_id
                AND (a.deleted_flag <> 'Y' OR a.deleted_flag is null)
                AND a.task_type_id <> 22;

Line: 261

               'DELETE_ASSIGNEE',
               'CHANGE_OWNER',
               'CHANGE_TASK_DETAILS'
              )
      THEN
         null;

Line: 323

      /*select task_status, task_priority , task_type
      into l_task_status_name, l_task_priority_name  , l_task_type_name
      from jtf_tasks_v where task_id = p_task_id ;*/

Line: 328

      select b.name task_status, c.name task_priority , d.name task_type
          into l_task_status_name, l_task_priority_name  , l_task_type_name
          from jtf_tasks_b a,
               jtf_task_statuses_tl b,
               jtf_task_priorities_tl c,
               jtf_task_types_tl d
          where a.task_id = p_task_id
            and (a.deleted_flag <> 'Y' OR a.deleted_flag is null)
            and d.task_type_id <> 22
            and b.task_status_id=a.task_status_id
            and c.task_priority_id=a.task_priority_id
            and d.task_type_id=a.task_type_id
            and b.language=userenv('lang')
            and c.language=userenv('lang')
            and d.language=userenv('lang');

Line: 522

      IF p_event = 'DELETE_ASSIGNEE'
      THEN

         IF (  p_old_assignee_code IS NULL
            OR p_old_assignee_id IS NULL)
         THEN
            fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_ASSIGNEE_DETAILS');

Line: 723

         SELECT task_name, description, owner_type_code owner_code, owner_id
           FROM jtf_tasks_vl
          WHERE task_id = p_task_id;