APPS.WSH_DELIVERY_LEGS_ACTIONS dependencies on WSH_TRIP_STOPS_PVT

Line 213: l_trip_stop_info wsh_trip_stops_pvt.trip_stop_rec_type;

209: l_count NUMBER := 0;
210:
211:
212: --2709662
213: l_trip_stop_info wsh_trip_stops_pvt.trip_stop_rec_type;
214: l_delivery_leg_info wsh_delivery_legs_pvt.delivery_leg_rec_type;
215: l_rowid VARCHAR2(30);
216: l_pickup_stop_id NUMBER;
217: l_dropoff_stop_id NUMBER;

Line 259: l_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;

255: l_dropoff_stop_seq NUMBER;
256: l_new_flag VARCHAR2(30);
257:
258: /* H integration for Multi Leg */
259: l_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;
260: l_pub_stop_rec WSH_TRIP_STOPS_PUB.TRIP_STOP_PUB_REC_TYPE;
261: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
262: l_pub_trip_rec WSH_TRIPS_PUB.TRIP_PUB_REC_TYPE;
263: l_return_status VARCHAR2(30);

Line 947: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.CREATE_TRIP_STOP',WSH_DEBUG_SV.C_PROC_LEVEL);

943: --
944: -- Debug Statements
945: --
946: IF l_debug_on THEN
947: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.CREATE_TRIP_STOP',WSH_DEBUG_SV.C_PROC_LEVEL);
948: END IF;
949: --
950: --
951:

Line 952: wsh_trip_stops_pvt.create_trip_stop(l_trip_stop_info,l_rowid,l_pickup_stop_id, x_return_status);

948: END IF;
949: --
950: --
951:
952: wsh_trip_stops_pvt.create_trip_stop(l_trip_stop_info,l_rowid,l_pickup_stop_id, x_return_status);
953:
954: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
955: RAISE e_InvalidDelExcep; -- Bug 5336308
956: END IF;

Line 1370: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.CREATE_TRIP_STOP',WSH_DEBUG_SV.C_PROC_LEVEL);

1366: --
1367: -- Debug Statements
1368: --
1369: IF l_debug_on THEN
1370: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.CREATE_TRIP_STOP',WSH_DEBUG_SV.C_PROC_LEVEL);
1371: END IF;
1372: --
1373: wsh_trip_stops_pvt.create_trip_stop(l_trip_stop_info,l_rowid,l_dropoff_stop_id, x_return_status);
1374:

Line 1373: wsh_trip_stops_pvt.create_trip_stop(l_trip_stop_info,l_rowid,l_dropoff_stop_id, x_return_status);

1369: IF l_debug_on THEN
1370: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.CREATE_TRIP_STOP',WSH_DEBUG_SV.C_PROC_LEVEL);
1371: END IF;
1372: --
1373: wsh_trip_stops_pvt.create_trip_stop(l_trip_stop_info,l_rowid,l_dropoff_stop_id, x_return_status);
1374:
1375: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1376: RAISE e_InvalidDelExcep; -- Bug 5336308
1377: END IF;