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_TRIPS_PUB dependencies on CAC_SR_OBJECT_CAPACITY

Line 317: FROM cac_sr_object_capacity oc

313: FUNCTION trip_has_active_tasks(p_trip_id NUMBER)
314: RETURN BOOLEAN IS
315: CURSOR c_active_tasks_exist IS
316: SELECT 1
317: FROM cac_sr_object_capacity oc
318: WHERE object_capacity_id = p_trip_id
319: AND EXISTS (SELECT 1
320: FROM jtf_task_assignments ta
321: , jtf_task_statuses_b ts

Line 356: FROM cac_sr_object_capacity

352: i PLS_INTEGER;
353:
354: CURSOR c_trips (p_resource_id NUMBER, p_resource_type VARCHAR2) IS
355: SELECT *
356: FROM cac_sr_object_capacity
357: WHERE object_id = p_resource_id
358: AND object_type = p_resource_type
359: AND p_start_date_time <= (end_date_time + l_overtime)
360: AND p_end_date_time >= start_date_time

Line 401: FROM cac_sr_object_capacity

397: FUNCTION get_trip(p_trip_id IN NUMBER) RETURN trip_rec_type AS
398: l_trip trip_rec_type;
399: CURSOR c_trip IS
400: SELECT *
401: FROM cac_sr_object_capacity
402: WHERE object_capacity_id = p_trip_id;
403: BEGIN
404: FOR v_trip IN c_trip LOOP
405: l_trip.trip_id := v_trip.object_capacity_id;

Line 623: l_object_capacity_tbl cac_sr_object_capacity_pub.object_capacity_tbl_type;

619: l_time_occupied NUMBER;
620: l_dep_task_id NUMBER;
621: l_arr_task_id NUMBER;
622: i PLS_INTEGER;
623: l_object_capacity_tbl cac_sr_object_capacity_pub.object_capacity_tbl_type;
624: l_object_tasks_tbl cac_sr_object_capacity_pub.object_tasks_tbl_type;
625:
626: CURSOR c_linkable_tasks IS
627: SELECT ta.task_assignment_id

Line 624: l_object_tasks_tbl cac_sr_object_capacity_pub.object_tasks_tbl_type;

620: l_dep_task_id NUMBER;
621: l_arr_task_id NUMBER;
622: i PLS_INTEGER;
623: l_object_capacity_tbl cac_sr_object_capacity_pub.object_capacity_tbl_type;
624: l_object_tasks_tbl cac_sr_object_capacity_pub.object_tasks_tbl_type;
625:
626: CURSOR c_linkable_tasks IS
627: SELECT ta.task_assignment_id
628: , ta.object_version_number

Line 766: cac_sr_object_capacity_pub.insert_object_capacity(

762: debug(' Trip Available Hours = ' || l_available_hours, l_api_name, fnd_log.level_statement);
763: END IF;
764:
765: -- Create the Trip by calling Object Capacity Table Handlers
766: cac_sr_object_capacity_pub.insert_object_capacity(
767: p_api_version => 1.0
768: , p_init_msg_list => fnd_api.g_false
769: , x_return_status => x_return_status
770: , x_msg_count => x_msg_count

Line 851: FROM cac_sr_object_capacity cac

847: , t.task_id
848: , t.task_number
849: , t.object_version_number task_ovn
850: , t.task_status_id
851: FROM cac_sr_object_capacity cac
852: , jtf_task_assignments ta
853: , jtf_tasks_b t
854: , jtf_task_statuses_b ts
855: WHERE cac.object_capacity_id = p_trip.trip_id

Line 934: cac_sr_object_capacity_pub.update_object_capacity(

930: fnd_msg_pub.ADD;
931: RAISE fnd_api.g_exc_error;
932: END IF;
933:
934: cac_sr_object_capacity_pub.update_object_capacity(
935: p_api_version => 1.0
936: , x_return_status => x_return_status
937: , x_msg_count => x_msg_count
938: , x_msg_data => x_msg_data

Line 1125: cac_sr_object_capacity_pub.delete_object_capacity(

1121: END IF;
1122: END LOOP;
1123:
1124: -- Delete the Object Capacity
1125: cac_sr_object_capacity_pub.delete_object_capacity(
1126: p_api_version => 1.0
1127: , x_return_status => x_return_status
1128: , x_msg_count => x_msg_count
1129: , x_msg_data => x_msg_data

Line 1192: FROM cac_sr_object_capacity oc

1188: , ta.task_assignment_id
1189: , ta.object_version_number
1190: , ta.object_capacity_id wrong_trip_id
1191: , oc.object_capacity_id correct_trip_id
1192: FROM cac_sr_object_capacity oc
1193: , jtf_task_assignments ta
1194: , jtf_tasks_b t
1195: , jtf_task_statuses_b ts
1196: WHERE oc.object_capacity_id = p_trip.trip_id

Line 1216: FROM cac_sr_object_capacity oc

1212: , ta.task_assignment_id
1213: , ta.object_version_number
1214: , p_trip.trip_id wrong_trip_id
1215: , oc.object_capacity_id correct_trip_id
1216: FROM cac_sr_object_capacity oc
1217: , jtf_task_assignments ta
1218: , jtf_tasks_b t
1219: , jtf_task_statuses_b ts
1220: WHERE ta.object_capacity_id = p_trip.trip_id

Line 1390: cac_sr_object_capacity_pub.update_object_capacity(

1386: l_available_hours := (p_trip.end_date_time - p_trip.start_date_time)
1387: - l_total_task_time
1388: - l_total_travel_time / g_mins_in_day;
1389:
1390: cac_sr_object_capacity_pub.update_object_capacity(
1391: p_api_version => 1.0
1392: , x_return_status => x_return_status
1393: , x_msg_count => x_msg_count
1394: , x_msg_data => x_msg_data

Line 1647: FROM cac_sr_object_capacity oc

1643:
1644: CURSOR c_trip_info(p_trip_id NUMBER) IS
1645: SELECT oc.object_version_number
1646: , oc.available_hours
1647: FROM cac_sr_object_capacity oc
1648: WHERE oc.object_capacity_id = p_trip_id;
1649:
1650: l_trip_info c_trip_info%ROWTYPE;
1651:

Line 1947: cac_sr_object_capacity_pub.update_object_capacity(

1943:
1944: l_trip_info.available_hours := l_trip_info.available_hours
1945: - l_trip_length * g_hours_in_day;
1946: -- Update the new Trip Capacity of the new trip created (Always OVN is 1)
1947: cac_sr_object_capacity_pub.update_object_capacity(
1948: p_api_version => 1.0
1949: , x_return_status => x_return_status
1950: , x_msg_count => x_msg_count
1951: , x_msg_data => x_msg_data