DBA Data[Home] [Help]

APPS.CSF_TASK_ASSIGNMENTS_PUB dependencies on CSF_UTIL_PVT

Line 55: , csf_util_pvt.convert_to_minutes(planned_effort, planned_effort_uom) planned_effort

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

Line 60: , csf_util_pvt.convert_to_minutes(ta.actual_effort, ta.actual_effort_uom) actual_effort

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

Line 61: , csf_util_pvt.convert_to_minutes(ta.sched_travel_duration, ta.sched_travel_duration_uom) sched_travel_duration

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

Line 62: , csf_util_pvt.convert_to_minutes(ta.actual_travel_duration, ta.actual_travel_duration_uom) actual_travel_duration

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

Line 94: + csf_util_pvt.convert_to_minutes(

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;

Line 223: l_travel_time := csf_util_pvt.convert_to_minutes(p_actual_travel_duration, p_actual_travel_duration_uom);

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;

Line 225: l_travel_time := csf_util_pvt.convert_to_minutes(p_sched_travel_duration, p_sched_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;

Line 353: l_scheduled_start := csf_util_pvt.get_miss_date;

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.

Line 354: l_scheduled_end := csf_util_pvt.get_miss_date;

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(

Line 1115: l_distance := csf_util_pvt.get_miss_num;

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;

Line 1116: l_duration := csf_util_pvt.get_miss_num;

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:

Line 1117: l_duration_uom := csf_util_pvt.get_miss_char;

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.

Line 1118: l_trip_id := csf_util_pvt.get_miss_num;

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(