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.CSF_TASK_ASSIGNMENTS_PUB dependencies on CSF_UTIL_PVT

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

69:
70: CURSOR c_task_info IS
71: SELECT t.scheduled_start_date
72: , t.scheduled_end_date
73: , csf_util_pvt.convert_to_minutes(planned_effort, planned_effort_uom) planned_effort
74: , ta.actual_start_date
75: , ta.actual_end_date
76: , ta.resource_id
77: , ta.resource_type_code

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

74: , ta.actual_start_date
75: , ta.actual_end_date
76: , ta.resource_id
77: , ta.resource_type_code
78: , csf_util_pvt.convert_to_minutes(ta.actual_effort, ta.actual_effort_uom) actual_effort
79: , csf_util_pvt.convert_to_minutes(ta.sched_travel_duration, ta.sched_travel_duration_uom) sched_travel_duration
80: , csf_util_pvt.convert_to_minutes(ta.actual_travel_duration, ta.actual_travel_duration_uom) actual_travel_duration
81: , cac.object_capacity_id old_trip_id
82: , cac.object_version_number old_trip_ovn

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

75: , ta.actual_end_date
76: , ta.resource_id
77: , ta.resource_type_code
78: , csf_util_pvt.convert_to_minutes(ta.actual_effort, ta.actual_effort_uom) actual_effort
79: , csf_util_pvt.convert_to_minutes(ta.sched_travel_duration, ta.sched_travel_duration_uom) sched_travel_duration
80: , csf_util_pvt.convert_to_minutes(ta.actual_travel_duration, ta.actual_travel_duration_uom) actual_travel_duration
81: , cac.object_capacity_id old_trip_id
82: , cac.object_version_number old_trip_ovn
83: FROM jtf_tasks_b t

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

76: , ta.resource_id
77: , ta.resource_type_code
78: , csf_util_pvt.convert_to_minutes(ta.actual_effort, ta.actual_effort_uom) actual_effort
79: , csf_util_pvt.convert_to_minutes(ta.sched_travel_duration, ta.sched_travel_duration_uom) sched_travel_duration
80: , csf_util_pvt.convert_to_minutes(ta.actual_travel_duration, ta.actual_travel_duration_uom) actual_travel_duration
81: , cac.object_capacity_id old_trip_id
82: , cac.object_version_number old_trip_ovn
83: FROM jtf_tasks_b t
84: , jtf_task_assignments ta

Line 112: + csf_util_pvt.convert_to_minutes(

108: IF NVL(l_new_end_date, fnd_api.g_miss_date) = fnd_api.g_miss_date
109: AND NVL(p_actual_effort, fnd_api.g_miss_num) <> fnd_api.g_miss_num
110: THEN
111: l_new_end_date := l_new_start_date
112: + csf_util_pvt.convert_to_minutes(
113: p_actual_effort
114: , p_actual_effort_uom) / (60 * 24);
115: END IF;
116: END IF;

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

239: --
240: IF NVL(l_trip.trip_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
241: l_travel_time := 0;
242: IF NVL(p_actual_travel_duration, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
243: l_travel_time := csf_util_pvt.convert_to_minutes(p_actual_travel_duration, p_actual_travel_duration_uom);
244: ELSIF NVL(p_sched_travel_duration, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
245: l_travel_time := csf_util_pvt.convert_to_minutes(p_sched_travel_duration, p_sched_travel_duration);
246: ELSIF NVL(l_task_info.actual_travel_duration, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
247: l_travel_time := l_task_info.actual_travel_duration;

Line 245: l_travel_time := csf_util_pvt.convert_to_minutes(p_sched_travel_duration, p_sched_travel_duration);

241: l_travel_time := 0;
242: IF NVL(p_actual_travel_duration, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
243: l_travel_time := csf_util_pvt.convert_to_minutes(p_actual_travel_duration, p_actual_travel_duration_uom);
244: ELSIF NVL(p_sched_travel_duration, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
245: l_travel_time := csf_util_pvt.convert_to_minutes(p_sched_travel_duration, p_sched_travel_duration);
246: ELSIF NVL(l_task_info.actual_travel_duration, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
247: l_travel_time := l_task_info.actual_travel_duration;
248: ELSIF NVL(l_task_info.sched_travel_duration, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
249: l_travel_time := l_task_info.sched_travel_duration;

Line 390: l_scheduled_start := csf_util_pvt.get_miss_date;

386: IF p_new_sts_cancelled_flag = 'Y' AND l_task_info.source_object_type_code = 'SR' THEN
387: l_scheduled_start := NULL;
388: l_scheduled_end := NULL;
389: ELSE
390: l_scheduled_start := csf_util_pvt.get_miss_date;
391: l_scheduled_end := csf_util_pvt.get_miss_date;
392: END IF;
393: -- cross task validation
394:

Line 391: l_scheduled_end := csf_util_pvt.get_miss_date;

387: l_scheduled_start := NULL;
388: l_scheduled_end := NULL;
389: ELSE
390: l_scheduled_start := csf_util_pvt.get_miss_date;
391: l_scheduled_end := csf_util_pvt.get_miss_date;
392: END IF;
393: -- cross task validation
394:
395:

Line 1373: l_distance := csf_util_pvt.get_miss_num;

1369: l_duration := NULL;
1370: l_duration_uom := NULL;
1371: l_trip_id := NULL;
1372: ELSE
1373: l_distance := csf_util_pvt.get_miss_num;
1374: l_duration := csf_util_pvt.get_miss_num;
1375: l_duration_uom := csf_util_pvt.get_miss_char;
1376: l_trip_id := csf_util_pvt.get_miss_num;
1377: END IF;

Line 1374: l_duration := csf_util_pvt.get_miss_num;

1370: l_duration_uom := NULL;
1371: l_trip_id := NULL;
1372: ELSE
1373: l_distance := csf_util_pvt.get_miss_num;
1374: l_duration := csf_util_pvt.get_miss_num;
1375: l_duration_uom := csf_util_pvt.get_miss_char;
1376: l_trip_id := csf_util_pvt.get_miss_num;
1377: END IF;
1378:

Line 1375: l_duration_uom := csf_util_pvt.get_miss_char;

1371: l_trip_id := NULL;
1372: ELSE
1373: l_distance := csf_util_pvt.get_miss_num;
1374: l_duration := csf_util_pvt.get_miss_num;
1375: l_duration_uom := csf_util_pvt.get_miss_char;
1376: l_trip_id := csf_util_pvt.get_miss_num;
1377: END IF;
1378:
1379: open c_scheduled_dates(l_task_id);

Line 1376: l_trip_id := csf_util_pvt.get_miss_num;

1372: ELSE
1373: l_distance := csf_util_pvt.get_miss_num;
1374: l_duration := csf_util_pvt.get_miss_num;
1375: l_duration_uom := csf_util_pvt.get_miss_char;
1376: l_trip_id := csf_util_pvt.get_miss_num;
1377: END IF;
1378:
1379: open c_scheduled_dates(l_task_id);
1380: fetch c_scheduled_dates into scheduled_dates;