eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_FTE_INTEGRATION dependencies on WSH_TRIPS

Line 357: p_trip_rec - record to be inserted/updated/deleted from wsh_trips

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
361: UPDATE

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;

Line 402: /* l_stop_rec and l_trip_rec are of type as per WSH_TRIPS_GRP api */

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;
406: --

Line 456: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.GET_TRIP_DETAILS_PVT',WSH_DEBUG_SV.C_PROC_LEVEL);

452: l_stop_rec_new := p_stop_rec;
453: -- Get trip details into l_stops_trip_rec FOR GROUP
454: --
455: IF l_debug_on THEN
456: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.GET_TRIP_DETAILS_PVT',WSH_DEBUG_SV.C_PROC_LEVEL);
457: END IF;
458: --
459: wsh_trips_grp.get_trip_details_pvt(p_trip_id => p_stop_rec.trip_id,
460: x_trip_rec => l_stops_trip_rec,

Line 459: wsh_trips_grp.get_trip_details_pvt(p_trip_id => p_stop_rec.trip_id,

455: IF l_debug_on THEN
456: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.GET_TRIP_DETAILS_PVT',WSH_DEBUG_SV.C_PROC_LEVEL);
457: END IF;
458: --
459: wsh_trips_grp.get_trip_details_pvt(p_trip_id => p_stop_rec.trip_id,
460: x_trip_rec => l_stops_trip_rec,
461: x_return_status => l_return_status);
462:
463: --

Line 506: wsh_trips_grp.get_trip_details_pvt(p_trip_id => p_stop_rec.trip_id,

502: );
503: l_stop_rec_new := p_stop_rec;
504:
505: -- Get trip details into l_stops_trip_rec FOR GROUP
506: wsh_trips_grp.get_trip_details_pvt(p_trip_id => p_stop_rec.trip_id,
507: x_trip_rec => l_stops_trip_rec,
508: x_return_status => l_return_status);
509:
510: --

Line 545: wsh_trips_grp.get_trip_details_pvt(

541: ) THEN
542: l_stop_rec_old := p_stop_rec;
543: -- Get trip details into l_stops_trip_rec FOR GROUP
544: --
545: wsh_trips_grp.get_trip_details_pvt(
546: p_trip_id => p_stop_rec.trip_id,
547: x_trip_rec => l_stops_trip_rec,
548: x_return_status => l_return_status);
549: IF l_debug_on THEN

Line 583: wsh_trips_grp.get_trip_details_pvt(

579: )THEN
580:
581: -- Get the details of the trip as in the database in l_trip_rec_old
582: -- Get trip details into l_stops_trip_rec FOR GROUP
583: wsh_trips_grp.get_trip_details_pvt(
584: p_trip_id => p_trip_rec.trip_id,
585: x_trip_rec => l_trip_rec_old,
586: x_return_status => l_return_status);
587:

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: );

Line 1775: -- It will pull the required values from WSH_TRIPS to

1771: --
1772: -- This procedure is a wrapper for
1773: -- FTE_CARRIER_RANK_LIST_PVT.CREATE_RANK_LIST_BULK
1774: --
1775: -- It will pull the required values from WSH_TRIPS to
1776: -- build the rank list for the FTE API.
1777: --
1778: -- ----------------------------------------------------------------------
1779: PROCEDURE CREATE_RANK_LIST_BULK(

Line 1822: 'Selecting WSH_TRIPS into rank list');

1818: AND (WSH_UTIL_CORE.FTE_Is_Installed = 'Y') THEN
1819:
1820: IF l_debug_on THEN
1821: WSH_DEBUG_SV.logmsg(l_module_name,
1822: 'Selecting WSH_TRIPS into rank list');
1823: END IF;
1824:
1825: FOR i IN p_trip_id_tab.FIRST .. p_trip_id_tab.LAST LOOP
1826: SELECT

Line 1900: FROM wsh_trips wt

1896: l_ranklist.ATTRIBUTE12(i),
1897: l_ranklist.ATTRIBUTE13(i),
1898: l_ranklist.ATTRIBUTE14(i),
1899: l_ranklist.ATTRIBUTE15(i)
1900: FROM wsh_trips wt
1901: WHERE trip_id = p_trip_id_tab(i);
1902: END LOOP;
1903:
1904: IF l_debug_on THEN