APPS.JTF_TASK_CONFIRMATION_PUB SQL Statements

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

Line: 176

     SELECT nvl(task_confirmation_counter, 0)
     INTO   l_conf_counter
     FROM   jtf_tasks_b
     WHERE  task_id = p_task_id;

Line: 744

  PROCEDURE UpdateTaskConfirmation(
     p_object_version_number   IN OUT NOCOPY  NUMBER,
     p_task_id	      IN       NUMBER,
     p_task_confirmation_status	IN  VARCHAR2,
     p_task_confirmation_counter	IN  NUMBER
   )
  IS
    CURSOR c_task IS
      SELECT DECODE(
               p_task_confirmation_status
             , jtf_task_utl.g_miss_char, task_confirmation_status
             , p_task_confirmation_status
             ) task_confirmation_status
           , DECODE(
               p_task_confirmation_counter
             , jtf_task_utl.g_miss_number, task_confirmation_counter
             , p_task_confirmation_counter
             ) task_confirmation_counter
           FROM jtf_tasks_b
       WHERE task_id = p_task_id;

Line: 790

    Update jtf_tasks_b set
      task_confirmation_status = tasks.task_confirmation_status,
      task_confirmation_counter = tasks.task_confirmation_counter
    where task_id=p_task_id;

Line: 800

  END UpdateTaskConfirmation;

Line: 823

           Select * from jtf_tasks_vl
                    Where task_id=p_task_id;

Line: 854

        jtf_tasks_pvt.update_task (
           p_api_version               => 1.0,
           p_init_msg_list             => fnd_api.g_false,
           p_commit                    => fnd_api.g_false,
           p_object_version_number     => p_object_version_number,
           p_task_id                   => p_task_id,
           p_enable_workflow	       => jtf_task_utl.g_miss_char,
           p_abort_workflow	       => jtf_task_utl.g_miss_char,
           p_change_mode		       => jtf_task_utl.g_miss_char,
           p_free_busy_type   	       => jtf_task_utl.g_miss_char,
           p_task_confirmation_status	 =>  p_task_confirmation_status,
           p_task_confirmation_counter =>  p_task_confirmation_counter,
           p_task_split_flag           => jtf_task_utl.g_miss_char,
           -- p_child_position           => NULL,
           -- p_child_sequence_num       => NULL,
           x_return_status             => x_return_status,
           x_msg_count                 => x_msg_count,
           x_msg_data                  => x_msg_data,
           p_location_id               => l_task.location_id
         );

Line: 881

         UpdateTaskConfirmation(
           p_object_version_number     =>  p_object_version_number,
           p_task_id                   =>  p_task_id,
           p_task_confirmation_status  =>  p_task_confirmation_status,
           p_task_confirmation_counter =>  p_task_confirmation_counter
          );