APPS.WSH_FTE_INTEGRATION dependencies on WSH_TRIP_STOPS

Line 356: p_stop_rec - record to be inserted/updated/deleted from wsh_trip_stops

352: END Shipment_Price_Consolidate;
353:
354: /*
355: Parameters :
356: p_stop_rec - record to be inserted/updated/deleted from wsh_trip_stops
357: p_trip_rec - record to be inserted/updated/deleted from wsh_trips
358: p_action - Action called
359: Values of p_action are
360: ADD

Line 368: ( p_stop_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,

364:
365: */
366:
367: PROCEDURE trip_stop_validations
368: ( p_stop_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,
369: p_trip_rec IN WSH_TRIPS_PVT.trip_rec_type,
370: p_action IN VARCHAR2,
371: x_return_status OUT NOCOPY VARCHAR2
372: ) IS

Line 374: l_stop_rec_old WSH_TRIP_STOPS_PVT.trip_stop_rec_type;

370: p_action IN VARCHAR2,
371: x_return_status OUT NOCOPY VARCHAR2
372: ) IS
373:
374: l_stop_rec_old WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
375: l_stop_rec_new WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
376: l_stop_rec_null WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
377:
378: l_trip_rec_old WSH_TRIPS_PVT.trip_rec_type;

Line 375: l_stop_rec_new WSH_TRIP_STOPS_PVT.trip_stop_rec_type;

371: x_return_status OUT NOCOPY VARCHAR2
372: ) IS
373:
374: l_stop_rec_old WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
375: l_stop_rec_new WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
376: l_stop_rec_null WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
377:
378: l_trip_rec_old WSH_TRIPS_PVT.trip_rec_type;
379: l_trip_rec_new WSH_TRIPS_PVT.trip_rec_type;

Line 376: l_stop_rec_null WSH_TRIP_STOPS_PVT.trip_stop_rec_type;

372: ) IS
373:
374: l_stop_rec_old WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
375: l_stop_rec_new WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
376: l_stop_rec_null WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
377:
378: l_trip_rec_old WSH_TRIPS_PVT.trip_rec_type;
379: l_trip_rec_new WSH_TRIPS_PVT.trip_rec_type;
380: l_trip_rec_null WSH_TRIPS_PVT.trip_rec_type;

Line 401: /* Input is of type WSH_TRIPS_PVT or WSH_TRIP_STOPS_PVT api */

397: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'TRIP_STOP_VALIDATIONS';
398: --
399: BEGIN
400:
401: /* Input is of type WSH_TRIPS_PVT or WSH_TRIP_STOPS_PVT api */
402: /* l_stop_rec and l_trip_rec are of type as per WSH_TRIPS_GRP api */
403: --
404: --
405: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

Line 498: wsh_trip_stops_grp.get_stop_details_pvt(

494: AND p_stop_rec.stop_location_id IS NOT NULL
495: )THEN
496:
497: -- Get details of existing stop from database into l_stop_rec_old
498: wsh_trip_stops_grp.get_stop_details_pvt(
499: p_stop_id => p_stop_rec.stop_id,
500: x_stop_rec => l_stop_rec_old,
501: x_return_status => l_return_status
502: );

Line 919: from wsh_trip_stops wts, wsh_trips wt

915: last_update_login = FND_GLOBAL.LOGIN_ID
916: WHERE NVL(reprice_required, 'N') ='N'
917: and pick_up_stop_id IN
918: (select stop_id
919: from wsh_trip_stops wts, wsh_trips wt
920: where wts.trip_id=wt.trip_id
921: and wt.trip_id=l_action_param_rec.trip_id_list(i)
922: and wt.lane_id is not null
923: );