APPS.JTF_TASK_CONFIRMATION_PUB SQL Statements

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

Line: 28

           Select * from jtf_tasks_vl
                    Where task_id=p_task_id;

Line: 56

      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: 214

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