The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
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);
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;
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);
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;
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);