APPS.FTE_ACS_TRIP_PKG dependencies on WSH_TRIPS

Line 47: l_trip_in_rec WSH_TRIPS_GRP.tripInRecType;

43: l_msg_data VARCHAR2(2000);
44: l_msg_count NUMBER;
45: p_api_version_number NUMBER;
46: p_action_code VARCHAR2(10);
47: l_trip_in_rec WSH_TRIPS_GRP.tripInRecType;
48: l_stop_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
49: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
50: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;
51: l_pickup_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;

Line 49: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

45: p_api_version_number NUMBER;
46: p_action_code VARCHAR2(10);
47: l_trip_in_rec WSH_TRIPS_GRP.tripInRecType;
48: l_stop_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
49: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
50: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;
51: l_pickup_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
52: l_pickup_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
53: l_dropoff_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;

Line 50: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;

46: p_action_code VARCHAR2(10);
47: l_trip_in_rec WSH_TRIPS_GRP.tripInRecType;
48: l_stop_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
49: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
50: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;
51: l_pickup_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
52: l_pickup_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
53: l_dropoff_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
54: l_dropoff_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;

Line 76: l_ignore_for_planning wsh_trips.ignore_for_planning%TYPE;

72: l_initial_pickup_date DATE;
73: l_ultimate_dropoff_date DATE;
74: l_dlvy_weight_uom VARCHAR2(10);
75: l_dlvy_volume_uom VARCHAR2(10);
76: l_ignore_for_planning wsh_trips.ignore_for_planning%TYPE;
77: l_caller VARCHAR2(30) := 'FTE_ROUTING_GUIDE';
78: l_debug_on BOOLEAN;
79: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CARRIER_SEL_CREATE_TRIP';
80:

Line 286: WSH_TRIPS_GRP.Create_Update_Trip(

282: l_trip_info_tab(1).SHIP_METHOD_NAME := FND_API.G_MISS_CHAR;
283: l_trip_info_tab(1).VEHICLE_ITEM_DESC := FND_API.G_MISS_CHAR;
284: l_trip_info_tab(1).VEHICLE_ORGANIZATION_CODE := FND_API.G_MISS_CHAR;
285:
286: WSH_TRIPS_GRP.Create_Update_Trip(
287: p_api_version_number => l_api_version_number,
288: p_init_msg_list => l_init_msg_list,
289: p_commit => l_commit,
290: x_return_status => l_return_status,

Line 311: l_ultimate_dropoff_date := l_initial_pickup_date + WSH_TRIPS_ACTIONS.C_TEN_MINUTES;

307: END IF;
308:
309: IF l_initial_pickup_date IS NULL AND l_ultimate_dropoff_date IS NULL THEN
310: l_initial_pickup_date := sysdate;
311: l_ultimate_dropoff_date := l_initial_pickup_date + WSH_TRIPS_ACTIONS.C_TEN_MINUTES;
312: ELSIF l_initial_pickup_date IS NULL AND l_ultimate_dropoff_date IS NOT NULL THEN
313: l_initial_pickup_date := l_ultimate_dropoff_date - WSH_TRIPS_ACTIONS.C_TEN_MINUTES;
314: ELSIF l_initial_pickup_date IS NOT NULL AND l_ultimate_dropoff_date IS NULL THEN
315: l_ultimate_dropoff_date := l_initial_pickup_date + WSH_TRIPS_ACTIONS.C_TEN_MINUTES;

Line 313: l_initial_pickup_date := l_ultimate_dropoff_date - WSH_TRIPS_ACTIONS.C_TEN_MINUTES;

309: IF l_initial_pickup_date IS NULL AND l_ultimate_dropoff_date IS NULL THEN
310: l_initial_pickup_date := sysdate;
311: l_ultimate_dropoff_date := l_initial_pickup_date + WSH_TRIPS_ACTIONS.C_TEN_MINUTES;
312: ELSIF l_initial_pickup_date IS NULL AND l_ultimate_dropoff_date IS NOT NULL THEN
313: l_initial_pickup_date := l_ultimate_dropoff_date - WSH_TRIPS_ACTIONS.C_TEN_MINUTES;
314: ELSIF l_initial_pickup_date IS NOT NULL AND l_ultimate_dropoff_date IS NULL THEN
315: l_ultimate_dropoff_date := l_initial_pickup_date + WSH_TRIPS_ACTIONS.C_TEN_MINUTES;
316: END IF;
317:

Line 315: l_ultimate_dropoff_date := l_initial_pickup_date + WSH_TRIPS_ACTIONS.C_TEN_MINUTES;

311: l_ultimate_dropoff_date := l_initial_pickup_date + WSH_TRIPS_ACTIONS.C_TEN_MINUTES;
312: ELSIF l_initial_pickup_date IS NULL AND l_ultimate_dropoff_date IS NOT NULL THEN
313: l_initial_pickup_date := l_ultimate_dropoff_date - WSH_TRIPS_ACTIONS.C_TEN_MINUTES;
314: ELSIF l_initial_pickup_date IS NOT NULL AND l_ultimate_dropoff_date IS NULL THEN
315: l_ultimate_dropoff_date := l_initial_pickup_date + WSH_TRIPS_ACTIONS.C_TEN_MINUTES;
316: END IF;
317:
318: IF l_debug_on THEN
319: WSH_DEBUG_SV.logmsg(l_module_name,'l_initial_pickup_date :'||l_initial_pickup_date);