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 359: FROM cac_sr_object_capacity oc

355: FUNCTION trip_has_active_tasks(p_trip_id NUMBER)
356: RETURN BOOLEAN IS
357: CURSOR c_active_tasks_exist IS
358: SELECT 1
359: FROM cac_sr_object_capacity oc
360: WHERE object_capacity_id = p_trip_id
361: AND EXISTS (SELECT 1
362: FROM jtf_task_assignments ta
363: , jtf_task_statuses_b ts

Line 398: FROM cac_sr_object_capacity

394: i PLS_INTEGER;
395:
396: CURSOR c_trips (p_resource_id NUMBER, p_resource_type VARCHAR2) IS
397: SELECT *
398: FROM cac_sr_object_capacity
399: WHERE object_id = p_resource_id
400: AND object_type = p_resource_type
401: AND p_start_date_time <= (end_date_time + l_overtime)
402: AND p_end_date_time >= start_date_time

Line 444: FROM cac_sr_object_capacity

440: FUNCTION get_trip(p_trip_id IN NUMBER) RETURN trip_rec_type AS
441: l_trip trip_rec_type;
442: CURSOR c_trip IS
443: SELECT *
444: FROM cac_sr_object_capacity
445: WHERE object_capacity_id = p_trip_id;
446: BEGIN
447: FOR v_trip IN c_trip LOOP
448: l_trip.trip_id := v_trip.object_capacity_id;

Line 490: from cac_sr_object_capacity

486:
487: CURSOR c_obj_capacity_det
488: IS
489: select object_id,object_type,start_date_time,end_date_time
490: from cac_sr_object_capacity
491: where object_id = p_resource_id
492: and object_type = p_resource_type
493: and start_date_time = p_start_date_time
494: and end_date_time = p_end_date_time;

Line 733: l_object_capacity_tbl cac_sr_object_capacity_pub.object_capacity_tbl_type;

729: l_available_hours NUMBER;
730: l_time_occupied NUMBER;
731:
732: i PLS_INTEGER;
733: l_object_capacity_tbl cac_sr_object_capacity_pub.object_capacity_tbl_type;
734: l_object_tasks_tbl cac_sr_object_capacity_pub.object_tasks_tbl_type;
735: BEGIN
736: SAVEPOINT csf_new_trip;
737:

Line 734: l_object_tasks_tbl cac_sr_object_capacity_pub.object_tasks_tbl_type;

730: l_time_occupied NUMBER;
731:
732: i PLS_INTEGER;
733: l_object_capacity_tbl cac_sr_object_capacity_pub.object_capacity_tbl_type;
734: l_object_tasks_tbl cac_sr_object_capacity_pub.object_tasks_tbl_type;
735: BEGIN
736: SAVEPOINT csf_new_trip;
737:
738: x_return_status := fnd_api.g_ret_sts_success;

Line 850: cac_sr_object_capacity_pub.insert_object_capacity(

846: debug(' No departure Arrival for Resource ' || p_resource_id || ' and Resource Type' ||p_resource_type , l_api_name, fnd_log.level_statement);
847: END IF;
848:
849: -- Create the Trip by calling Object Capacity Table Handlers
850: cac_sr_object_capacity_pub.insert_object_capacity(
851: p_api_version => 1.0
852: , p_init_msg_list => fnd_api.g_false
853: , x_return_status => x_return_status
854: , x_msg_count => x_msg_count

Line 951: FROM cac_sr_object_capacity cac

947: , t.task_id
948: , t.task_number
949: , t.object_version_number task_ovn
950: , t.task_status_id
951: FROM cac_sr_object_capacity cac
952: , jtf_task_assignments ta
953: , jtf_tasks_b t
954: , jtf_task_statuses_b ts
955: WHERE cac.object_capacity_id = p_trip.trip_id

Line 1035: cac_sr_object_capacity_pub.update_object_capacity(

1031: fnd_msg_pub.ADD;
1032: RAISE fnd_api.g_exc_error;
1033: END IF;
1034:
1035: cac_sr_object_capacity_pub.update_object_capacity(
1036: p_api_version => 1.0
1037: , x_return_status => x_return_status
1038: , x_msg_count => x_msg_count
1039: , x_msg_data => x_msg_data

Line 1229: cac_sr_object_capacity_pub.delete_object_capacity(

1225: END IF;
1226: END LOOP;
1227:
1228: -- Delete the Object Capacity
1229: cac_sr_object_capacity_pub.delete_object_capacity(
1230: p_api_version => 1.0
1231: , x_return_status => x_return_status
1232: , x_msg_count => x_msg_count
1233: , x_msg_data => x_msg_data

Line 1303: FROM cac_sr_object_capacity oc

1299: , ta.task_assignment_id
1300: , ta.object_version_number
1301: , ta.object_capacity_id wrong_trip_id
1302: , oc.object_capacity_id correct_trip_id
1303: FROM cac_sr_object_capacity oc
1304: , jtf_task_assignments ta
1305: , jtf_tasks_b t
1306: , jtf_task_statuses_b ts
1307: WHERE oc.object_capacity_id = p_trip.trip_id

Line 1327: FROM cac_sr_object_capacity oc

1323: , ta.task_assignment_id
1324: , ta.object_version_number
1325: , p_trip.trip_id wrong_trip_id
1326: , oc.object_capacity_id correct_trip_id
1327: FROM cac_sr_object_capacity oc
1328: , jtf_task_assignments ta
1329: , jtf_tasks_b t
1330: , jtf_task_statuses_b ts
1331: WHERE ta.object_capacity_id = p_trip.trip_id

Line 1500: cac_sr_object_capacity_pub.update_object_capacity(

1496:
1497: --l_available_hours := (p_trip.end_date_time - p_trip.start_date_time) - l_total_task_time - l_total_travel_time / g_mins_in_day;
1498: l_available_hours := p_trip.end_date_time - p_trip.start_date_time ;
1499:
1500: cac_sr_object_capacity_pub.update_object_capacity(
1501: p_api_version => 1.0
1502: , x_return_status => x_return_status
1503: , x_msg_count => x_msg_count
1504: , x_msg_data => x_msg_data

Line 1782: FROM cac_sr_object_capacity oc

1778:
1779: CURSOR c_trip_info(p_trip_id NUMBER) IS
1780: SELECT oc.object_version_number
1781: , oc.available_hours
1782: FROM cac_sr_object_capacity oc
1783: WHERE oc.object_capacity_id = p_trip_id;
1784:
1785: l_trip_info c_trip_info%ROWTYPE;
1786: l_links c_linkable_tasks%ROWTYPE;

Line 2115: cac_sr_object_capacity_pub.update_object_capacity(

2111:
2112: l_trip_info.available_hours := l_trip_info.available_hours
2113: - l_trip_length * g_hours_in_day;
2114: -- Update the new Trip Capacity of the new trip created (Always OVN is 1)
2115: cac_sr_object_capacity_pub.update_object_capacity(
2116: p_api_version => 1.0
2117: , x_return_status => x_return_status
2118: , x_msg_count => x_msg_count
2119: , x_msg_data => x_msg_data

Line 3930: FROM cac_sr_object_capacity

3926:
3927: CURSOR c_trip_exist
3928: is
3929: SELECT 'Y'
3930: FROM cac_sr_object_capacity
3931: WHERE p_start_date_time <= (end_date_time + g_overtime)
3932: AND p_end_date_time >= start_date_time
3933: AND object_id=p_resource_id;
3934:

Line 4073: l_object_capacity_tbl cac_sr_object_capacity_pub.object_capacity_tbl_type;

4069: l_time_occupied NUMBER;
4070: l_dep_task_id NUMBER;
4071: l_arr_task_id NUMBER;
4072: i PLS_INTEGER;
4073: l_object_capacity_tbl cac_sr_object_capacity_pub.object_capacity_tbl_type;
4074: l_object_tasks_tbl cac_sr_object_capacity_pub.object_tasks_tbl_type;
4075:
4076: CURSOR c_linkable_tasks IS
4077: SELECT ta.task_assignment_id

Line 4074: l_object_tasks_tbl cac_sr_object_capacity_pub.object_tasks_tbl_type;

4070: l_dep_task_id NUMBER;
4071: l_arr_task_id NUMBER;
4072: i PLS_INTEGER;
4073: l_object_capacity_tbl cac_sr_object_capacity_pub.object_capacity_tbl_type;
4074: l_object_tasks_tbl cac_sr_object_capacity_pub.object_tasks_tbl_type;
4075:
4076: CURSOR c_linkable_tasks IS
4077: SELECT ta.task_assignment_id
4078: , ta.object_version_number

Line 4225: cac_sr_object_capacity_pub.insert_object_capacity(

4221: debug(' Trip Available Hours = ' || l_available_hours, l_api_name, fnd_log.level_statement);
4222: END IF;
4223:
4224: -- Create the Trip by calling Object Capacity Table Handlers
4225: cac_sr_object_capacity_pub.insert_object_capacity(
4226: p_api_version => 1.0
4227: , p_init_msg_list => fnd_api.g_false
4228: , x_return_status => x_return_status
4229: , x_msg_count => x_msg_count

Line 4447: FROM cac_sr_object_capacity

4443:
4444: CURSOR c_trip_exist(p_resource_id number)
4445: is
4446: SELECT 'Y'
4447: FROM cac_sr_object_capacity
4448: WHERE p_start_date_time <= (end_date_time + g_overtime)
4449: AND p_end_date_time >= start_date_time
4450: AND object_id=p_resource_id
4451: AND OBJECT_CAPACITY_ID NOT IN (p_trip_id);

Line 5004: FROM cac_sr_object_capacity co,

5000: (SELECT TASK_ID
5001: FROM JTF_TASK_ASSIGNMENTS
5002: WHERE OBJECT_CAPACITY_ID IN
5003: (SELECT co.object_capacity_id
5004: FROM cac_sr_object_capacity co,
5005: jtf_tasks_b jtb,
5006: jtf_task_assignments jta,
5007: jtf_task_statuses_b jts,
5008: jtf_Task_statuses_b jtsa

Line 5209: FROM cac_sr_object_capacity co

5205: AND (t.task_type_id NOT IN (20, 21));
5206:
5207: CURSOR c_trip_count(p_start_date date,p_end_date date,p_res_id number,p_res_type varchar2) IS
5208: select count(distinct object_capacity_id)
5209: FROM cac_sr_object_capacity co
5210: WHERE co.start_date_time <= p_end_date
5211: and co.end_date_time >= p_start_date
5212: and object_id= p_res_id
5213: and object_type= p_res_type;

Line 5218: FROM cac_sr_object_capacity oc

5214:
5215: CURSOR c_trip_info(p_trip_id NUMBER) IS
5216: SELECT oc.object_version_number
5217: , oc.available_hours
5218: FROM cac_sr_object_capacity oc
5219: WHERE oc.object_capacity_id = p_trip_id;
5220:
5221: l_tasks c_linkable_tasks%rowtype;
5222: l_trip_count number;

Line 5290: cac_sr_object_capacity_pub.update_object_capacity(

5286: l_time_occupied := l_tasks.booking_end_date - l_tasks.booking_start_date; -- Scheduled Task Duration
5287: l_time_occupied := l_time_occupied + NVL(l_tasks.travel_time, 0) / g_mins_in_day; -- Scheduled Travel Duration
5288: l_available_hours := l_available_hours - l_time_occupied * g_hours_in_day;
5289:
5290: cac_sr_object_capacity_pub.update_object_capacity(
5291: p_api_version => 1.0
5292: , x_return_status => x_return_status
5293: , x_msg_count => x_msg_count
5294: , x_msg_data => x_msg_data