DBA Data[Home] [Help]

APPS.WSH_FTE_INTEGRATION dependencies on WSH_TRIPS_PVT

Line 369: p_trip_rec IN WSH_TRIPS_PVT.trip_rec_type,

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

Line 378: l_trip_rec_old WSH_TRIPS_PVT.trip_rec_type;

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;
381: l_stops_trip_rec WSH_TRIPS_PVT.trip_rec_type;
382:

Line 379: l_trip_rec_new WSH_TRIPS_PVT.trip_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;
381: l_stops_trip_rec WSH_TRIPS_PVT.trip_rec_type;
382:
383: l_stop_seg_IN FTE_WSH_INTERFACE_PKG.segmentStopChangeInRecType;

Line 380: l_trip_rec_null WSH_TRIPS_PVT.trip_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;
381: l_stops_trip_rec WSH_TRIPS_PVT.trip_rec_type;
382:
383: l_stop_seg_IN FTE_WSH_INTERFACE_PKG.segmentStopChangeInRecType;
384: l_stop_seg_OUT FTE_WSH_INTERFACE_PKG.segmentStopChangeOutRecType;

Line 381: l_stops_trip_rec WSH_TRIPS_PVT.trip_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;
381: l_stops_trip_rec WSH_TRIPS_PVT.trip_rec_type;
382:
383: l_stop_seg_IN FTE_WSH_INTERFACE_PKG.segmentStopChangeInRecType;
384: l_stop_seg_OUT FTE_WSH_INTERFACE_PKG.segmentStopChangeOutRecType;
385: l_trip_seg_IN FTE_WSH_INTERFACE_PKG.tripSegmentChangeInRecType;

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;