DBA Data[Home] [Help]

APPS.WSH_FTE_INTEGRATION dependencies on WSH_TRIP_STOPS_PVT

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;