51:
52: CURSOR c_task_info IS
53: SELECT t.scheduled_start_date
54: , t.scheduled_end_date
55: , csf_util_pvt.convert_to_minutes(planned_effort, planned_effort_uom) planned_effort
56: , ta.actual_start_date
57: , ta.actual_end_date
58: , ta.resource_id
59: , ta.resource_type_code
56: , ta.actual_start_date
57: , ta.actual_end_date
58: , ta.resource_id
59: , ta.resource_type_code
60: , csf_util_pvt.convert_to_minutes(ta.actual_effort, ta.actual_effort_uom) actual_effort
61: , csf_util_pvt.convert_to_minutes(ta.sched_travel_duration, ta.sched_travel_duration_uom) sched_travel_duration
62: , csf_util_pvt.convert_to_minutes(ta.actual_travel_duration, ta.actual_travel_duration_uom) actual_travel_duration
63: , cac.object_capacity_id old_trip_id
64: , cac.object_version_number old_trip_ovn
57: , ta.actual_end_date
58: , ta.resource_id
59: , ta.resource_type_code
60: , csf_util_pvt.convert_to_minutes(ta.actual_effort, ta.actual_effort_uom) actual_effort
61: , csf_util_pvt.convert_to_minutes(ta.sched_travel_duration, ta.sched_travel_duration_uom) sched_travel_duration
62: , csf_util_pvt.convert_to_minutes(ta.actual_travel_duration, ta.actual_travel_duration_uom) actual_travel_duration
63: , cac.object_capacity_id old_trip_id
64: , cac.object_version_number old_trip_ovn
65: FROM jtf_tasks_b t
58: , ta.resource_id
59: , ta.resource_type_code
60: , csf_util_pvt.convert_to_minutes(ta.actual_effort, ta.actual_effort_uom) actual_effort
61: , csf_util_pvt.convert_to_minutes(ta.sched_travel_duration, ta.sched_travel_duration_uom) sched_travel_duration
62: , csf_util_pvt.convert_to_minutes(ta.actual_travel_duration, ta.actual_travel_duration_uom) actual_travel_duration
63: , cac.object_capacity_id old_trip_id
64: , cac.object_version_number old_trip_ovn
65: FROM jtf_tasks_b t
66: , jtf_task_assignments ta
90: IF NVL(l_new_end_date, fnd_api.g_miss_date) = fnd_api.g_miss_date
91: AND NVL(p_actual_effort, fnd_api.g_miss_num) <> fnd_api.g_miss_num
92: THEN
93: l_new_end_date := l_new_start_date
94: + csf_util_pvt.convert_to_minutes(
95: p_actual_effort
96: , p_actual_effort_uom) / (60 * 24);
97: END IF;
98: END IF;
219: --
220: IF NVL(l_trip.trip_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
221: l_travel_time := 0;
222: IF NVL(p_actual_travel_duration, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
223: l_travel_time := csf_util_pvt.convert_to_minutes(p_actual_travel_duration, p_actual_travel_duration_uom);
224: ELSIF NVL(p_sched_travel_duration, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
225: l_travel_time := csf_util_pvt.convert_to_minutes(p_sched_travel_duration, p_sched_travel_duration);
226: ELSIF NVL(l_task_info.actual_travel_duration, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
227: l_travel_time := l_task_info.actual_travel_duration;
221: l_travel_time := 0;
222: IF NVL(p_actual_travel_duration, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
223: l_travel_time := csf_util_pvt.convert_to_minutes(p_actual_travel_duration, p_actual_travel_duration_uom);
224: ELSIF NVL(p_sched_travel_duration, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
225: l_travel_time := csf_util_pvt.convert_to_minutes(p_sched_travel_duration, p_sched_travel_duration);
226: ELSIF NVL(l_task_info.actual_travel_duration, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
227: l_travel_time := l_task_info.actual_travel_duration;
228: ELSIF NVL(l_task_info.sched_travel_duration, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
229: l_travel_time := l_task_info.sched_travel_duration;
349: IF p_new_sts_cancelled_flag = 'Y' AND l_task_info.source_object_type_code = 'SR' THEN
350: l_scheduled_start := NULL;
351: l_scheduled_end := NULL;
352: ELSE
353: l_scheduled_start := csf_util_pvt.get_miss_date;
354: l_scheduled_end := csf_util_pvt.get_miss_date;
355: END IF;
356:
357: -- No other open Task Assignments. Update the Task also.
350: l_scheduled_start := NULL;
351: l_scheduled_end := NULL;
352: ELSE
353: l_scheduled_start := csf_util_pvt.get_miss_date;
354: l_scheduled_end := csf_util_pvt.get_miss_date;
355: END IF;
356:
357: -- No other open Task Assignments. Update the Task also.
358: jtf_tasks_pub.update_task(
1111: l_duration := NULL;
1112: l_duration_uom := NULL;
1113: l_trip_id := NULL;
1114: ELSE
1115: l_distance := csf_util_pvt.get_miss_num;
1116: l_duration := csf_util_pvt.get_miss_num;
1117: l_duration_uom := csf_util_pvt.get_miss_char;
1118: l_trip_id := csf_util_pvt.get_miss_num;
1119: END IF;
1112: l_duration_uom := NULL;
1113: l_trip_id := NULL;
1114: ELSE
1115: l_distance := csf_util_pvt.get_miss_num;
1116: l_duration := csf_util_pvt.get_miss_num;
1117: l_duration_uom := csf_util_pvt.get_miss_char;
1118: l_trip_id := csf_util_pvt.get_miss_num;
1119: END IF;
1120:
1113: l_trip_id := NULL;
1114: ELSE
1115: l_distance := csf_util_pvt.get_miss_num;
1116: l_duration := csf_util_pvt.get_miss_num;
1117: l_duration_uom := csf_util_pvt.get_miss_char;
1118: l_trip_id := csf_util_pvt.get_miss_num;
1119: END IF;
1120:
1121: -- Update the Task Assignment.
1114: ELSE
1115: l_distance := csf_util_pvt.get_miss_num;
1116: l_duration := csf_util_pvt.get_miss_num;
1117: l_duration_uom := csf_util_pvt.get_miss_char;
1118: l_trip_id := csf_util_pvt.get_miss_num;
1119: END IF;
1120:
1121: -- Update the Task Assignment.
1122: jtf_task_assignments_pub.update_task_assignment(