APPS.CSF_TRIPS_PUB dependencies on CAC_SR_OBJECT_CAPACITY_PUB

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