The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE update_task_assignment (
p_api_version IN NUMBER,
p_object_version_number IN OUT NOCOPY NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
p_task_assignment_id IN NUMBER,
p_task_id IN NUMBER
DEFAULT fnd_api.g_miss_num,
p_task_number IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_task_name IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_resource_type_code IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_resource_id IN NUMBER
DEFAULT fnd_api.g_miss_num,
p_resource_name IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_actual_effort IN NUMBER
DEFAULT fnd_api.g_miss_num,
p_actual_effort_uom IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_schedule_flag IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_alarm_type_code IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_alarm_contact IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_sched_travel_distance IN NUMBER
DEFAULT fnd_api.g_miss_num,
p_sched_travel_duration IN NUMBER
DEFAULT fnd_api.g_miss_num,
p_sched_travel_duration_uom IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_actual_travel_distance IN NUMBER
DEFAULT fnd_api.g_miss_num,
p_actual_travel_duration IN NUMBER
DEFAULT fnd_api.g_miss_num,
p_actual_travel_duration_uom IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
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_palm_flag IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_wince_flag IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_laptop_flag IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_device1_flag IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_device2_flag IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_device3_flag IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_resource_territory_id IN NUMBER
DEFAULT fnd_api.g_miss_num,
p_assignment_status_id IN NUMBER
DEFAULT fnd_api.g_miss_num,
p_shift_construct_id IN NUMBER
DEFAULT fnd_api.g_miss_num,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_attribute1 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute2 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute3 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute4 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute5 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute6 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute7 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute8 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute9 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute10 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute11 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute12 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute13 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute14 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute15 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute_category IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_show_on_calendar IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_category_id IN NUMBER
DEFAULT jtf_task_utl.g_miss_number,
p_enable_workflow IN VARCHAR2,
p_abort_workflow IN VARCHAR2,
p_object_capacity_id IN NUMBER
)
IS
--Declare the variables
--
l_api_version CONSTANT NUMBER
:= 1.0;
:= 'Update_Task_Assignment';
SELECT task_id,
DECODE (
p_resource_id,
fnd_api.g_miss_num, resource_id,
p_resource_id
) resource_id,
DECODE (
p_resource_type_code,
fnd_api.g_miss_char, resource_type_code,
p_resource_type_code
) resource_type_code,
DECODE (
p_assignment_status_id,
fnd_api.g_miss_num, assignment_status_id,
p_assignment_status_id
) assignment_status_id,
DECODE (
p_actual_effort,
fnd_api.g_miss_num, actual_effort,
p_actual_effort
) actual_effort,
DECODE (
p_actual_effort_uom,
fnd_api.g_miss_char, actual_effort_uom,
p_actual_effort_uom
) actual_effort_uom,
DECODE (
p_alarm_type_code,
fnd_api.g_miss_char, alarm_type_code,
p_alarm_type_code
) alarm_type_code,
DECODE (
p_alarm_contact,
fnd_api.g_miss_char, alarm_contact,
p_alarm_contact
) alarm_contact,
DECODE (
p_sched_travel_distance,
fnd_api.g_miss_num, sched_travel_distance,
p_sched_travel_distance
) sched_travel_distance,
DECODE (
p_sched_travel_duration,
fnd_api.g_miss_num, sched_travel_duration,
p_sched_travel_duration
) sched_travel_duration,
DECODE (
p_sched_travel_duration_uom,
fnd_api.g_miss_char, sched_travel_duration_uom,
p_sched_travel_duration_uom
) sched_travel_dur_uom,
DECODE (
p_actual_travel_distance,
fnd_api.g_miss_num, actual_travel_distance,
p_actual_travel_distance
) actual_travel_distance,
DECODE (
p_actual_travel_duration,
fnd_api.g_miss_num, actual_travel_duration,
p_actual_travel_duration
) actual_travel_duration,
DECODE (
p_resource_territory_id,
fnd_api.g_miss_num, resource_territory_id,
p_resource_territory_id
) resource_territory_id,
DECODE (
p_shift_construct_id,
fnd_api.g_miss_num, shift_construct_id,
p_shift_construct_id
) shift_construct_id,
DECODE (
p_actual_travel_duration_uom,
fnd_api.g_miss_char, actual_travel_duration_uom,
p_actual_travel_duration_uom
) actual_travel_dur_uom,
DECODE (
p_schedule_flag,
fnd_api.g_miss_char, schedule_flag,
p_schedule_flag
) schedule_flag,
DECODE (
p_actual_start_date,
fnd_api.g_miss_date, actual_start_date,
p_actual_start_date
) actual_start_date,
DECODE (
p_actual_end_date,
fnd_api.g_miss_date, actual_end_date,
p_actual_end_date
) actual_end_date,
DECODE (
p_palm_flag,
fnd_api.g_miss_char, palm_flag,
p_palm_flag
) palm_flag,
DECODE (
p_wince_flag,
fnd_api.g_miss_char, wince_flag,
p_wince_flag
) wince_flag,
DECODE (
p_laptop_flag,
fnd_api.g_miss_char, laptop_flag,
p_laptop_flag
) laptop_flag,
DECODE (
p_device1_flag,
fnd_api.g_miss_char, device1_flag,
p_device1_flag
) device1_flag,
DECODE (
p_device2_flag,
fnd_api.g_miss_char, device2_flag,
p_device2_flag
) device2_flag,
DECODE (
p_device3_flag,
fnd_api.g_miss_char, device3_flag,
p_device3_flag
) device3_flag,
DECODE (
p_show_on_calendar,
fnd_api.g_miss_char, show_on_calendar,
p_show_on_calendar
) show_on_calendar,
DECODE (
p_category_id,
fnd_api.g_miss_num, category_id,
p_category_id
) category_id,
DECODE (
p_attribute1,
fnd_api.g_miss_char, attribute1,
p_attribute1
) attribute1,
DECODE (
p_attribute2,
fnd_api.g_miss_char, attribute2,
p_attribute2
) attribute2,
DECODE (
p_attribute3,
fnd_api.g_miss_char, attribute3,
p_attribute3
) attribute3,
DECODE (
p_attribute4,
fnd_api.g_miss_char, attribute4,
p_attribute4
) attribute4,
DECODE (
p_attribute5,
fnd_api.g_miss_char, attribute5,
p_attribute5
) attribute5,
DECODE (
p_attribute6,
fnd_api.g_miss_char, attribute6,
p_attribute6
) attribute6,
DECODE (
p_attribute7,
fnd_api.g_miss_char, attribute7,
p_attribute7
) attribute7,
DECODE (
p_attribute8,
fnd_api.g_miss_char, attribute8,
p_attribute8
) attribute8,
DECODE (
p_attribute9,
fnd_api.g_miss_char, attribute9,
p_attribute9
) attribute9,
DECODE (
p_attribute10,
fnd_api.g_miss_char, attribute10,
p_attribute10
) attribute10,
DECODE (
p_attribute11,
fnd_api.g_miss_char, attribute11,
p_attribute11
) attribute11,
DECODE (
p_attribute12,
fnd_api.g_miss_char, attribute12,
p_attribute12
) attribute12,
DECODE (
p_attribute13,
fnd_api.g_miss_char, attribute13,
p_attribute13
) attribute13,
DECODE (
p_attribute14,
fnd_api.g_miss_char, attribute14,
p_attribute14
) attribute14,
DECODE (
p_attribute15,
fnd_api.g_miss_char, attribute15,
p_attribute15
) attribute15,
DECODE (
p_attribute_category,
fnd_api.g_miss_char, attribute_category,
p_attribute_category
) attribute_category
FROM jtf_task_all_assignments
WHERE task_assignment_id = l_task_assignment_id;
SAVEPOINT update_task_assignment_pub;
jtf_task_assignments_iuhk.update_task_assignment_pre(x_return_status );
jtf_task_assignments_pvt.update_task_assignment (
p_api_version => l_api_version,
p_object_version_number => p_object_version_number,
p_init_msg_list => fnd_api.g_false,
p_commit => fnd_api.g_false,
p_task_assignment_id => l_task_assignment_id,
p_sched_travel_duration_uom => l_sched_travel_dur_uom,
p_actual_travel_distance => l_actual_travel_distance,
p_actual_travel_duration => l_actual_travel_duration,
p_actual_travel_duration_uom => l_actual_travel_dur_uom,
p_actual_start_date => l_actual_start_date,
p_actual_end_date => l_actual_end_date,
p_palm_flag => l_palm_flag,
p_wince_flag => l_wince_flag,
p_laptop_flag => l_laptop_flag,
p_device1_flag => l_device1_flag,
p_device2_flag => l_device2_flag,
p_device3_flag => l_device3_flag,
p_resource_id => l_resource_id,
p_actual_effort => l_act_eff,
p_actual_effort_uom => l_act_eff_uom,
p_schedule_flag => l_schedule_flag,
p_alarm_type_code => l_alarm_type_code,
p_alarm_contact => l_alarm_contact,
p_sched_travel_distance => l_sched_travel_distance,
p_sched_travel_duration => l_sched_travel_duration,
p_resource_type_code => l_resource_type_code,
p_resource_territory_id => l_resource_territory_id,
p_assignment_status_id => l_assignment_status_id,
p_shift_construct_id => l_shift_construct_id,
x_msg_data => x_msg_data,
x_msg_count => x_msg_count,
x_return_status => x_return_status,
p_attribute1 => task_ass_rec.attribute1,
p_attribute2 => task_ass_rec.attribute2,
p_attribute3 => task_ass_rec.attribute3,
p_attribute4 => task_ass_rec.attribute4,
p_attribute5 => task_ass_rec.attribute5,
p_attribute6 => task_ass_rec.attribute6,
p_attribute7 => task_ass_rec.attribute7,
p_attribute8 => task_ass_rec.attribute8,
p_attribute9 => task_ass_rec.attribute9,
p_attribute10 => task_ass_rec.attribute10,
p_attribute11 => task_ass_rec.attribute11,
p_attribute12 => task_ass_rec.attribute12,
p_attribute13 => task_ass_rec.attribute13,
p_attribute14 => task_ass_rec.attribute14,
p_attribute15 => task_ass_rec.attribute15,
p_attribute_category => task_ass_rec.attribute_category,
p_show_on_calendar => l_show_on_calendar,
p_category_id => l_category_id,
p_enable_workflow => l_enable_workflow,
p_abort_workflow => l_abort_workflow,
p_free_busy_type => fnd_api.g_miss_char,
p_object_capacity_id => p_object_capacity_id
);
/* jtf_task_assignments_iuhk.update_task_assignment_post(x_return_status );
ROLLBACK TO update_task_assignment_pub;
ROLLBACK TO update_task_assignment_pub;
ROLLBACK TO update_task_assignment_pub;
PROCEDURE update_task_assignment (
p_api_version IN NUMBER,
p_object_version_number IN OUT NOCOPY NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
p_task_assignment_id IN NUMBER,
p_task_id IN NUMBER
DEFAULT fnd_api.g_miss_num,
p_task_number IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_task_name IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_resource_type_code IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_resource_id IN NUMBER
DEFAULT fnd_api.g_miss_num,
p_resource_name IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_actual_effort IN NUMBER
DEFAULT fnd_api.g_miss_num,
p_actual_effort_uom IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_schedule_flag IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_alarm_type_code IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_alarm_contact IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_sched_travel_distance IN NUMBER
DEFAULT fnd_api.g_miss_num,
p_sched_travel_duration IN NUMBER
DEFAULT fnd_api.g_miss_num,
p_sched_travel_duration_uom IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_actual_travel_distance IN NUMBER
DEFAULT fnd_api.g_miss_num,
p_actual_travel_duration IN NUMBER
DEFAULT fnd_api.g_miss_num,
p_actual_travel_duration_uom IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
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_palm_flag IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_wince_flag IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_laptop_flag IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_device1_flag IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_device2_flag IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_device3_flag IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_resource_territory_id IN NUMBER
DEFAULT fnd_api.g_miss_num,
p_assignment_status_id IN NUMBER
DEFAULT fnd_api.g_miss_num,
p_shift_construct_id IN NUMBER
DEFAULT fnd_api.g_miss_num,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_attribute1 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute2 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute3 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute4 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute5 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute6 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute7 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute8 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute9 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute10 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute11 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute12 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute13 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute14 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute15 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute_category IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_show_on_calendar IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_category_id IN NUMBER
DEFAULT jtf_task_utl.g_miss_number,
p_enable_workflow IN VARCHAR2,
p_abort_workflow IN VARCHAR2
)
IS
BEGIN
jtf_task_assignments_pub.update_task_assignment (
p_api_version => p_api_version,
p_object_version_number => p_object_version_number,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
p_task_assignment_id => p_task_assignment_id,
p_task_id => p_task_id,
p_task_number => p_task_number,
p_task_name => p_task_name,
p_resource_type_code => p_resource_type_code,
p_resource_id => p_resource_id,
p_resource_name => p_resource_name,
p_actual_effort => p_actual_effort,
p_actual_effort_uom => p_actual_effort_uom,
p_schedule_flag => p_schedule_flag,
p_alarm_type_code => p_alarm_type_code,
p_alarm_contact => p_alarm_contact,
p_sched_travel_distance => p_sched_travel_distance,
p_sched_travel_duration => p_sched_travel_duration,
p_sched_travel_duration_uom => p_sched_travel_duration_uom,
p_actual_travel_distance => p_actual_travel_distance,
p_actual_travel_duration => p_actual_travel_duration,
p_actual_travel_duration_uom => p_actual_travel_duration_uom,
p_actual_start_date => p_actual_start_date,
p_actual_end_date => p_actual_end_date,
p_palm_flag => p_palm_flag,
p_wince_flag => p_wince_flag,
p_laptop_flag => p_laptop_flag,
p_device1_flag => p_device1_flag,
p_device2_flag => p_device2_flag,
p_device3_flag => p_device3_flag,
p_resource_territory_id => p_resource_territory_id,
p_assignment_status_id => p_assignment_status_id,
p_shift_construct_id => p_shift_construct_id,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_attribute1 => p_attribute1,
p_attribute2 => p_attribute2,
p_attribute3 => p_attribute3,
p_attribute4 => p_attribute4,
p_attribute5 => p_attribute5,
p_attribute6 => p_attribute6,
p_attribute7 => p_attribute7,
p_attribute8 => p_attribute8,
p_attribute9 => p_attribute9,
p_attribute10 => p_attribute10,
p_attribute11 => p_attribute11,
p_attribute12 => p_attribute12,
p_attribute13 => p_attribute13,
p_attribute14 => p_attribute14,
p_attribute15 => p_attribute15,
p_attribute_category => p_attribute_category,
p_show_on_calendar => p_show_on_calendar,
p_category_id => p_category_id,
p_enable_workflow => p_enable_workflow,
p_abort_workflow => p_abort_workflow,
p_object_capacity_id => fnd_api.g_miss_num
);
PROCEDURE update_task_assignment (
p_api_version IN NUMBER,
p_object_version_number IN OUT NOCOPY NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
p_task_assignment_id IN NUMBER,
p_task_id IN NUMBER
DEFAULT fnd_api.g_miss_num,
p_task_number IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_task_name IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_resource_type_code IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_resource_id IN NUMBER
DEFAULT fnd_api.g_miss_num,
p_resource_name IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_actual_effort IN NUMBER
DEFAULT fnd_api.g_miss_num,
p_actual_effort_uom IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_schedule_flag IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_alarm_type_code IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_alarm_contact IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_sched_travel_distance IN NUMBER
DEFAULT fnd_api.g_miss_num,
p_sched_travel_duration IN NUMBER
DEFAULT fnd_api.g_miss_num,
p_sched_travel_duration_uom IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_actual_travel_distance IN NUMBER
DEFAULT fnd_api.g_miss_num,
p_actual_travel_duration IN NUMBER
DEFAULT fnd_api.g_miss_num,
p_actual_travel_duration_uom IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
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_palm_flag IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_wince_flag IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_laptop_flag IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_device1_flag IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_device2_flag IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_device3_flag IN VARCHAR2
DEFAULT fnd_api.g_miss_char,
p_resource_territory_id IN NUMBER
DEFAULT fnd_api.g_miss_num,
p_assignment_status_id IN NUMBER
DEFAULT fnd_api.g_miss_num,
p_shift_construct_id IN NUMBER
DEFAULT fnd_api.g_miss_num,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_attribute1 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute2 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute3 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute4 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute5 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute6 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute7 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute8 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute9 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute10 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute11 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute12 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute13 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute14 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute15 IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_attribute_category IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_show_on_calendar IN VARCHAR2
DEFAULT jtf_task_utl.g_miss_char,
p_category_id IN NUMBER
DEFAULT jtf_task_utl.g_miss_number
)
IS
BEGIN
jtf_task_assignments_pub.update_task_assignment (
p_api_version => p_api_version,
p_object_version_number => p_object_version_number,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
p_task_assignment_id => p_task_assignment_id,
p_task_id => p_task_id,
p_task_number => p_task_number,
p_task_name => p_task_name,
p_resource_type_code => p_resource_type_code,
p_resource_id => p_resource_id,
p_resource_name => p_resource_name,
p_actual_effort => p_actual_effort,
p_actual_effort_uom => p_actual_effort_uom,
p_schedule_flag => p_schedule_flag,
p_alarm_type_code => p_alarm_type_code,
p_alarm_contact => p_alarm_contact,
p_sched_travel_distance => p_sched_travel_distance,
p_sched_travel_duration => p_sched_travel_duration,
p_sched_travel_duration_uom => p_sched_travel_duration_uom,
p_actual_travel_distance => p_actual_travel_distance,
p_actual_travel_duration => p_actual_travel_duration,
p_actual_travel_duration_uom => p_actual_travel_duration_uom,
p_actual_start_date => p_actual_start_date,
p_actual_end_date => p_actual_end_date,
p_palm_flag => p_palm_flag,
p_wince_flag => p_wince_flag,
p_laptop_flag => p_laptop_flag,
p_device1_flag => p_device1_flag,
p_device2_flag => p_device2_flag,
p_device3_flag => p_device3_flag,
p_resource_territory_id => p_resource_territory_id,
p_assignment_status_id => p_assignment_status_id,
p_shift_construct_id => p_shift_construct_id,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_attribute1 => p_attribute1,
p_attribute2 => p_attribute2,
p_attribute3 => p_attribute3,
p_attribute4 => p_attribute4,
p_attribute5 => p_attribute5,
p_attribute6 => p_attribute6,
p_attribute7 => p_attribute7,
p_attribute8 => p_attribute8,
p_attribute9 => p_attribute9,
p_attribute10 => p_attribute10,
p_attribute11 => p_attribute11,
p_attribute12 => p_attribute12,
p_attribute13 => p_attribute13,
p_attribute14 => p_attribute14,
p_attribute15 => p_attribute15,
p_attribute_category => p_attribute_category,
p_show_on_calendar => p_show_on_calendar,
p_category_id => p_category_id,
p_enable_workflow => fnd_profile.value('JTF_TASK_ENABLE_WORKFLOW'),
p_abort_workflow => fnd_profile.value('JTF_TASK_ABORT_PREV_WF')
);
PROCEDURE delete_task_assignment (
p_api_version IN NUMBER,
p_object_version_number IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
p_task_assignment_id IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_enable_workflow IN VARCHAR2,
p_abort_workflow IN VARCHAR2
)
IS
--
--
l_api_version CONSTANT NUMBER
:= 1.0;
:= 'Delete_Task_Assignment';
SELECT 1
FROM jtf_task_all_assignments
WHERE task_assignment_id = l_task_assignment_id;
SAVEPOINT delete_task_assignment_pub;
jtf_task_assignments_iuhk.delete_task_assignment_pre(x_return_status );
jtf_task_assignments_pvt.delete_task_assignment (
p_api_version => l_api_version,
p_object_version_number => p_object_version_number,
p_init_msg_list => fnd_api.g_false,
p_commit => fnd_api.g_false,
p_task_assignment_id => l_task_assignment_id,
x_return_status => x_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_enable_workflow => l_enable_workflow,
p_abort_workflow => l_abort_workflow
);
/*jtf_task_assignments_iuhk.delete_task_assignment_post(x_return_status );
ROLLBACK TO delete_task_assignment_pub;
ROLLBACK TO delete_task_assignment_pub;
ROLLBACK TO delete_task_assignment_pub;
PROCEDURE delete_task_assignment (
p_api_version IN NUMBER,
p_object_version_number IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
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
BEGIN
jtf_task_assignments_pub.delete_task_assignment (
p_api_version => p_api_version,
p_object_version_number => p_object_version_number,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
p_task_assignment_id => p_task_assignment_id,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_enable_workflow => fnd_profile.value('JTF_TASK_ENABLE_WORKFLOW'),
p_abort_workflow => fnd_profile.value('JTF_TASK_ABORT_PREV_WF')
);