eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_TASK_PVT SQL Statements

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

Line: 52


SELECT importance_level
 FROM  jtf_tasks_vl jtv, JTF_TASK_PRIORITIES_VL jtp
where jtv.task_id = p_task_id
  and jtp.task_priority_id = jtv.task_priority_id;

Line: 206


PROCEDURE update_task (
    p_api_version             IN   NUMBER,
    p_init_msg_list           IN   VARCHAR2 ,--DEFAULT fnd_api.g_false,
    p_commit                  IN   VARCHAR2 ,--DEFAULT fnd_api.g_false,
    p_object_version_number   IN   NUMBER ,
    p_task_id                 IN   NUMBER ,--DEFAULT fnd_api.g_miss_num,
    p_task_name               IN   VARCHAR2 ,--DEFAULT fnd_api.g_miss_char,
    p_task_type_id            IN   NUMBER ,--DEFAULT NULL,
    p_task_status_id          IN   NUMBER ,--DEFAULT NULL,
    p_task_priority_id        IN   NUMBER ,--DEFAULT NULL,
    p_owner_id                IN   NUMBER ,--DEFAULT NULL,
    p_private_flag            IN   VARCHAR2 ,--DEFAULT NULL,
    p_planned_start_date      IN   DATE ,--DEFAULT NULL,
    p_planned_end_date        IN   DATE ,--DEFAULT NULL,
    p_actual_start_date       IN   DATE ,--DEFAULT fnd_api.g_miss_date,
    p_actual_end_date         IN   DATE ,--DEFAULT fnd_api.g_miss_date,
    p_source_object_type_code IN   VARCHAR2 ,--DEFAULT fnd_api.g_miss_char,
    p_source_object_id        IN   NUMBER ,--DEFAULT fnd_api.g_miss_num,
    p_source_object_name      IN   VARCHAR2 ,--DEFAULT fnd_api.g_miss_char,
    x_return_status           OUT NOCOPY  VARCHAR2,
    x_msg_count               OUT NOCOPY  NUMBER,
    x_msg_data                OUT NOCOPY  VARCHAR2 )
IS

    l_init_msg_list           VARCHAR2(1) := fnd_api.g_true;

Line: 252


    SELECT 'x'
      FROM wf_item_activity_statuses
     WHERE item_type = 'AMSTASK'
       AND item_key like l_task_id || '%'
       AND activity_status = 'ACTIVE';

Line: 258


    SELECT task_status_id
	 FROM jtf_task_statuses_vl
    -- WHERE name = 'Assigned';

Line: 291


   JTF_TASKS_PUB.update_task (
      p_api_version             => l_api_version,
      p_object_version_number   => l_object_version_number,
      p_task_id                 => l_task_id,
      p_task_name               => l_task_name,
      p_task_type_id            => l_task_type_id,
      p_task_status_id          => l_task_status_id,
      p_task_priority_id        => l_task_priority_id,
      p_owner_id                => l_owner_id,
      p_private_flag            => l_private_flag,
      p_planned_start_date      => l_planned_start_date,
      p_planned_end_date        => l_planned_end_date,
      p_actual_start_date       => l_actual_start_date,
      p_actual_end_date         => l_actual_end_date ,
      p_source_object_type_code => l_source_object_type_code,
      p_source_object_id        => l_source_object_id ,
      p_source_object_name      => l_source_object_name ,
      x_return_status           =>  x_return_status,
      x_msg_count               =>  x_msg_count ,
      x_msg_data                =>  x_msg_data );

Line: 360


END update_task;

Line: 364


PROCEDURE delete_task (
    p_api_version             IN       NUMBER,
    p_init_msg_list           IN       VARCHAR2 ,--DEFAULT fnd_api.g_false,
    p_commit                  IN       VARCHAR2 ,--DEFAULT fnd_api.g_false,
    p_object_version_number   IN       NUMBER ,
    p_task_id                 IN       NUMBER ,--DEFAULT NULL,
    x_return_status           OUT NOCOPY      VARCHAR2,
    x_msg_count               OUT NOCOPY      NUMBER,
    x_msg_data                OUT NOCOPY      VARCHAR2
    )
    IS
  l_api_version CONSTANT    NUMBER       := 1.0;

Line: 380


  SELECT source_object_type_code,
         source_object_id
    FROM jtf_tasks_b
   WHERE task_id = l_task_id;

Line: 386


  SELECT 'x'
    FROM jtf_tasks_b
   WHERE source_object_type_code = p_obj_type
     AND source_object_id = p_obj_id
     AND deleted_flag <> 'Y'   ;

Line: 408


   JTF_TASKS_PUB.delete_task (
       p_api_version             => l_api_version,
       p_object_version_number   => l_object_version_number,
       p_task_id                 => l_task_id,
       x_return_status           => x_return_status,
       x_msg_count               => x_msg_count ,
       x_msg_data                => x_msg_data );

Line: 455


END delete_task;

Line: 481


    SELECT 'x'
      FROM wf_item_activity_statuses
     WHERE item_type = 'AMSTASK'
       AND item_key like l_task_id || '%'
       AND activity_status = 'ACTIVE';

Line: 488


    SELECT task_status_id
	 FROM jtf_task_statuses_vl
    -- WHERE name = 'Assigned';

Line: 493


    SELECT task_status_id  ,source_object_type_code,object_version_number
	 FROM jtf_tasks_b
     WHERE task_id  = l_task_id;

Line: 554


Procedure  Delete_Task_Assignment
     (P_API_VERSION               IN     NUMBER     ,
      P_INIT_MSG_LIST               IN     VARCHAR2 ,
      P_COMMIT                   IN     VARCHAR2 ,
      p_object_version_number IN     NUMBER     ,
      P_TASK_ASSIGNMENT_ID     IN     NUMBER      ,
      X_RETURN_STATUS               OUT NOCOPY     VARCHAR2,
      X_MSG_COUNT                   OUT NOCOPY     NUMBER      ,
      X_MSG_DATA                   OUT NOCOPY     VARCHAR2 )

IS

   l_api_version CONSTANT    NUMBER  := 1.0;

Line: 573


   JTF_TASK_ASSIGNMENTS_PUB.delete_task_assignment (
      p_api_version             => l_api_version,
      P_INIT_MSG_LIST               => l_init_msg_list,
      p_commit                  => l_commit,
      p_object_version_number   => l_object_version_number,
      p_task_assignment_id      => l_task_assignment_id ,
      x_return_status             =>  x_return_status,
      x_msg_count                  =>  x_msg_count ,
      x_msg_data                  =>  x_msg_data );

Line: 587


Procedure  Update_Task_Assignment(
    P_API_VERSION           IN   NUMBER,
    p_object_version_number IN   NUMBER,
    P_INIT_MSG_LIST         IN   VARCHAR2   ,--DEFAULT G_FALSE ,
    P_COMMIT                IN   VARCHAR2   ,--DEFAULT G_FALSE ,
    P_TASK_ASSIGNMENT_ID    IN   NUMBER ,
    P_TASK_ID               IN   NUMBER     ,--default fnd_api.g_miss_num ,
    P_RESOURCE_TYPE_CODE    IN   VARCHAR2   ,--DEFAULT NULL,
    P_RESOURCE_ID           IN   NUMBER,
    P_ASSIGNMENT_STATUS_ID  IN   NUMBER,
    X_RETURN_STATUS         OUT NOCOPY  VARCHAR2 ,
    X_MSG_COUNT             OUT NOCOPY  NUMBER ,
    X_MSG_DATA              OUT NOCOPY  VARCHAR2)

IS
   l_api_version CONSTANT    NUMBER  := 1.0;

Line: 613


   JTF_TASK_ASSIGNMENTS_PUB.update_task_assignment (
      p_api_version           => l_api_version,
      p_object_version_number => l_object_version_number,
      p_task_assignment_id    => l_task_assignment_id ,
      P_TASK_ID               => l_task_id,
      p_resource_id           => l_resource_id,
      p_resource_type_code    => l_resource_type_code,
      p_assignment_status_id  => l_assignment_status_id,
      x_return_status         =>  x_return_status,
      x_msg_count             =>  x_msg_count ,
      x_msg_data              =>  x_msg_data );