APPS.WSH_DELIVERY_LEGS_ACTIONS dependencies on WSH_TRIPS_ACTIONS

Line 366: l_stop_seq_mode := WSH_TRIPS_ACTIONS.GET_STOP_SEQ_MODE;

362: WSH_DEBUG_SV.log(l_module_name,'p_sc_pickup_date',p_sc_pickup_date);
363: WSH_DEBUG_SV.log(l_module_name,'p_sc_dropoff_date',p_sc_dropoff_date);
364: END IF;
365: --
366: l_stop_seq_mode := WSH_TRIPS_ACTIONS.GET_STOP_SEQ_MODE;
367: --
368: open get_trip_status(p_trip_id);
369: fetch get_trip_status into l_trip_status, l_plannedflag, l_trip_shipments_type_flag, l_trip_mode_of_transport;
370: close get_trip_status;

Line 1138: WSH_TRIPS_ACTIONS.Handle_Internal_Stops

1134: -- End of Code for DBI Project
1135: --
1136: IF p_caller like '%ASSIGNTRIP%' THEN
1137: l_trip_ids(1):=p_trip_id;
1138: WSH_TRIPS_ACTIONS.Handle_Internal_Stops
1139: ( p_trip_ids => l_trip_ids,
1140: p_caller => p_caller,
1141: x_success_trip_ids => l_dummy_trip_ids,
1142: x_return_status => l_return_status);

Line 1263: l_trip_stop_info.planned_arrival_date := greatest(NVL(l_pickup_date, sysdate) + WSH_TRIPS_ACTIONS.C_TEN_MINUTES, NVL(l_dropoff_date, sysdate));

1259: --l_trip_stop_info.stop_sequence_number := -99;
1260: l_trip_stop_info.stop_sequence_number := l_dropoff_stop_seq;
1261: l_trip_stop_info.stop_location_id := l_dropoff_location_id;
1262: IF l_pregen_seq = 'N' THEN
1263: l_trip_stop_info.planned_arrival_date := greatest(NVL(l_pickup_date, sysdate) + WSH_TRIPS_ACTIONS.C_TEN_MINUTES, NVL(l_dropoff_date, sysdate));
1264: ELSE
1265: l_trip_stop_info.planned_arrival_date := l_tmp_date;
1266: END IF;
1267: -- bug 3349133, the planned arrival date of pickup stop and dropoff stop is 10 minutes apart

Line 1992: WSH_TRIPS_ACTIONS.Handle_Internal_Stops

1988: END LOOP;
1989:
1990: IF p_caller like '%ASSIGNTRIP%' THEN
1991: l_trip_ids(1):=p_trip_id;
1992: WSH_TRIPS_ACTIONS.Handle_Internal_Stops
1993: ( p_trip_ids => l_trip_ids,
1994: p_caller => p_caller,
1995: x_success_trip_ids => l_dummy_trip_ids,
1996: x_return_status => l_return_status);

Line 3271: WSH_TRIPS_ACTIONS.Fte_Load_Tender(

3267: END IF;
3268: IF l_trip_empty THEN
3269:
3270: FOR rec IN c_trip_stops(p_trip_id) LOOP
3271: WSH_TRIPS_ACTIONS.Fte_Load_Tender(
3272: p_stop_id => rec.stop_id,
3273: p_gross_weight => null,
3274: p_net_weight => null,
3275: p_volume => null,