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.JTF_TASK_ASSIGNMENTS_PUB_W SQL Statements

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

Line: 976


  procedure update_task_assignment(p_api_version  NUMBER
    , p_object_version_number in out nocopy  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p_task_assignment_id  NUMBER
    , p_task_id  NUMBER
    , p_task_number  VARCHAR2
    , p_task_name  VARCHAR2
    , p_resource_type_code  VARCHAR2
    , p_resource_id  NUMBER
    , p_resource_name  VARCHAR2
    , p_actual_effort  NUMBER
    , p_actual_effort_uom  VARCHAR2
    , p_schedule_flag  VARCHAR2
    , p_alarm_type_code  VARCHAR2
    , p_alarm_contact  VARCHAR2
    , p_sched_travel_distance  NUMBER
    , p_sched_travel_duration  NUMBER
    , p_sched_travel_duration_uom  VARCHAR2
    , p_actual_travel_distance  NUMBER
    , p_actual_travel_duration  NUMBER
    , p_actual_travel_duration_uom  VARCHAR2
    , p_actual_start_date  date
    , p_actual_end_date  date
    , p_palm_flag  VARCHAR2
    , p_wince_flag  VARCHAR2
    , p_laptop_flag  VARCHAR2
    , p_device1_flag  VARCHAR2
    , p_device2_flag  VARCHAR2
    , p_device3_flag  VARCHAR2
    , p_resource_territory_id  NUMBER
    , p_assignment_status_id  NUMBER
    , p_shift_construct_id  NUMBER
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p_attribute1  VARCHAR2
    , p_attribute2  VARCHAR2
    , p_attribute3  VARCHAR2
    , p_attribute4  VARCHAR2
    , p_attribute5  VARCHAR2
    , p_attribute6  VARCHAR2
    , p_attribute7  VARCHAR2
    , p_attribute8  VARCHAR2
    , p_attribute9  VARCHAR2
    , p_attribute10  VARCHAR2
    , p_attribute11  VARCHAR2
    , p_attribute12  VARCHAR2
    , p_attribute13  VARCHAR2
    , p_attribute14  VARCHAR2
    , p_attribute15  VARCHAR2
    , p_attribute_category  VARCHAR2
    , p_show_on_calendar  VARCHAR2
    , p_category_id  NUMBER
    , p_enable_workflow  VARCHAR2
    , p_abort_workflow  VARCHAR2
    , p_object_capacity_id  NUMBER
  )

  as
    ddp_actual_start_date date;

Line: 1102


    jtf_task_assignments_pub.update_task_assignment(p_api_version,
      p_object_version_number,
      p_init_msg_list,
      p_commit,
      p_task_assignment_id,
      p_task_id,
      p_task_number,
      p_task_name,
      p_resource_type_code,
      p_resource_id,
      p_resource_name,
      p_actual_effort,
      p_actual_effort_uom,
      p_schedule_flag,
      p_alarm_type_code,
      p_alarm_contact,
      p_sched_travel_distance,
      p_sched_travel_duration,
      p_sched_travel_duration_uom,
      p_actual_travel_distance,
      p_actual_travel_duration,
      p_actual_travel_duration_uom,
      ddp_actual_start_date,
      ddp_actual_end_date,
      p_palm_flag,
      p_wince_flag,
      p_laptop_flag,
      p_device1_flag,
      p_device2_flag,
      p_device3_flag,
      p_resource_territory_id,
      p_assignment_status_id,
      p_shift_construct_id,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_attribute1,
      p_attribute2,
      p_attribute3,
      p_attribute4,
      p_attribute5,
      p_attribute6,
      p_attribute7,
      p_attribute8,
      p_attribute9,
      p_attribute10,
      p_attribute11,
      p_attribute12,
      p_attribute13,
      p_attribute14,
      p_attribute15,
      p_attribute_category,
      p_show_on_calendar,
      p_category_id,
      p_enable_workflow,
      p_abort_workflow,
      p_object_capacity_id);

Line: 1219


  procedure update_task_assignment(p_api_version  NUMBER
    , p_object_version_number in out nocopy  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p_task_assignment_id  NUMBER
    , p_task_id  NUMBER
    , p_task_number  VARCHAR2
    , p_task_name  VARCHAR2
    , p_resource_type_code  VARCHAR2
    , p_resource_id  NUMBER
    , p_resource_name  VARCHAR2
    , p_actual_effort  NUMBER
    , p_actual_effort_uom  VARCHAR2
    , p_schedule_flag  VARCHAR2
    , p_alarm_type_code  VARCHAR2
    , p_alarm_contact  VARCHAR2
    , p_sched_travel_distance  NUMBER
    , p_sched_travel_duration  NUMBER
    , p_sched_travel_duration_uom  VARCHAR2
    , p_actual_travel_distance  NUMBER
    , p_actual_travel_duration  NUMBER
    , p_actual_travel_duration_uom  VARCHAR2
    , p_actual_start_date  date
    , p_actual_end_date  date
    , p_palm_flag  VARCHAR2
    , p_wince_flag  VARCHAR2
    , p_laptop_flag  VARCHAR2
    , p_device1_flag  VARCHAR2
    , p_device2_flag  VARCHAR2
    , p_device3_flag  VARCHAR2
    , p_resource_territory_id  NUMBER
    , p_assignment_status_id  NUMBER
    , p_shift_construct_id  NUMBER
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p_attribute1  VARCHAR2
    , p_attribute2  VARCHAR2
    , p_attribute3  VARCHAR2
    , p_attribute4  VARCHAR2
    , p_attribute5  VARCHAR2
    , p_attribute6  VARCHAR2
    , p_attribute7  VARCHAR2
    , p_attribute8  VARCHAR2
    , p_attribute9  VARCHAR2
    , p_attribute10  VARCHAR2
    , p_attribute11  VARCHAR2
    , p_attribute12  VARCHAR2
    , p_attribute13  VARCHAR2
    , p_attribute14  VARCHAR2
    , p_attribute15  VARCHAR2
    , p_attribute_category  VARCHAR2
    , p_show_on_calendar  VARCHAR2
    , p_category_id  NUMBER
    , p_enable_workflow  VARCHAR2
    , p_abort_workflow  VARCHAR2
  )

  as
    ddp_actual_start_date date;

Line: 1343


    jtf_task_assignments_pub.update_task_assignment(p_api_version,
      p_object_version_number,
      p_init_msg_list,
      p_commit,
      p_task_assignment_id,
      p_task_id,
      p_task_number,
      p_task_name,
      p_resource_type_code,
      p_resource_id,
      p_resource_name,
      p_actual_effort,
      p_actual_effort_uom,
      p_schedule_flag,
      p_alarm_type_code,
      p_alarm_contact,
      p_sched_travel_distance,
      p_sched_travel_duration,
      p_sched_travel_duration_uom,
      p_actual_travel_distance,
      p_actual_travel_duration,
      p_actual_travel_duration_uom,
      ddp_actual_start_date,
      ddp_actual_end_date,
      p_palm_flag,
      p_wince_flag,
      p_laptop_flag,
      p_device1_flag,
      p_device2_flag,
      p_device3_flag,
      p_resource_territory_id,
      p_assignment_status_id,
      p_shift_construct_id,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_attribute1,
      p_attribute2,
      p_attribute3,
      p_attribute4,
      p_attribute5,
      p_attribute6,
      p_attribute7,
      p_attribute8,
      p_attribute9,
      p_attribute10,
      p_attribute11,
      p_attribute12,
      p_attribute13,
      p_attribute14,
      p_attribute15,
      p_attribute_category,
      p_show_on_calendar,
      p_category_id,
      p_enable_workflow,
      p_abort_workflow);

Line: 1458


  procedure update_task_assignment(p_api_version  NUMBER
    , p_object_version_number in out nocopy  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p_task_assignment_id  NUMBER
    , p_task_id  NUMBER
    , p_task_number  VARCHAR2
    , p_task_name  VARCHAR2
    , p_resource_type_code  VARCHAR2
    , p_resource_id  NUMBER
    , p_resource_name  VARCHAR2
    , p_actual_effort  NUMBER
    , p_actual_effort_uom  VARCHAR2
    , p_schedule_flag  VARCHAR2
    , p_alarm_type_code  VARCHAR2
    , p_alarm_contact  VARCHAR2
    , p_sched_travel_distance  NUMBER
    , p_sched_travel_duration  NUMBER
    , p_sched_travel_duration_uom  VARCHAR2
    , p_actual_travel_distance  NUMBER
    , p_actual_travel_duration  NUMBER
    , p_actual_travel_duration_uom  VARCHAR2
    , p_actual_start_date  date
    , p_actual_end_date  date
    , p_palm_flag  VARCHAR2
    , p_wince_flag  VARCHAR2
    , p_laptop_flag  VARCHAR2
    , p_device1_flag  VARCHAR2
    , p_device2_flag  VARCHAR2
    , p_device3_flag  VARCHAR2
    , p_resource_territory_id  NUMBER
    , p_assignment_status_id  NUMBER
    , p_shift_construct_id  NUMBER
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p_attribute1  VARCHAR2
    , p_attribute2  VARCHAR2
    , p_attribute3  VARCHAR2
    , p_attribute4  VARCHAR2
    , p_attribute5  VARCHAR2
    , p_attribute6  VARCHAR2
    , p_attribute7  VARCHAR2
    , p_attribute8  VARCHAR2
    , p_attribute9  VARCHAR2
    , p_attribute10  VARCHAR2
    , p_attribute11  VARCHAR2
    , p_attribute12  VARCHAR2
    , p_attribute13  VARCHAR2
    , p_attribute14  VARCHAR2
    , p_attribute15  VARCHAR2
    , p_attribute_category  VARCHAR2
    , p_show_on_calendar  VARCHAR2
    , p_category_id  NUMBER
  )

  as
    ddp_actual_start_date date;

Line: 1578


    jtf_task_assignments_pub.update_task_assignment(p_api_version,
      p_object_version_number,
      p_init_msg_list,
      p_commit,
      p_task_assignment_id,
      p_task_id,
      p_task_number,
      p_task_name,
      p_resource_type_code,
      p_resource_id,
      p_resource_name,
      p_actual_effort,
      p_actual_effort_uom,
      p_schedule_flag,
      p_alarm_type_code,
      p_alarm_contact,
      p_sched_travel_distance,
      p_sched_travel_duration,
      p_sched_travel_duration_uom,
      p_actual_travel_distance,
      p_actual_travel_duration,
      p_actual_travel_duration_uom,
      ddp_actual_start_date,
      ddp_actual_end_date,
      p_palm_flag,
      p_wince_flag,
      p_laptop_flag,
      p_device1_flag,
      p_device2_flag,
      p_device3_flag,
      p_resource_territory_id,
      p_assignment_status_id,
      p_shift_construct_id,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_attribute1,
      p_attribute2,
      p_attribute3,
      p_attribute4,
      p_attribute5,
      p_attribute6,
      p_attribute7,
      p_attribute8,
      p_attribute9,
      p_attribute10,
      p_attribute11,
      p_attribute12,
      p_attribute13,
      p_attribute14,
      p_attribute15,
      p_attribute_category,
      p_show_on_calendar,
      p_category_id);