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_PUB

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 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 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 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 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 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