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_UTIL_CORE dependencies on WSH_TRIPS

Line 2547: l_trip_rec WSH_TRIPS_PVT.trip_rec_type;

2543: --new variable
2544: l_fte_flag VARCHAR2(1) := 'N';
2545: l_return_status VARCHAR2(30);
2546: l_stop_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
2547: l_trip_rec WSH_TRIPS_PVT.trip_rec_type;
2548: -- bmso
2549: l_lpn_ids WMS_Data_Type_Definitions_PUB.LPNPurgeRecordType;
2550: l_lpn_id_tab wsh_util_core.id_tab_type;
2551:

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

2692: --
2693: -- Debug Statements
2694: --
2695: IF l_debug_on THEN
2696: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.GET_TRIP_DETAILS_PVT',WSH_DEBUG_SV.C_PROC_LEVEL);
2697: END IF;
2698: --
2699: wsh_trips_grp.get_trip_details_pvt
2700: (p_trip_id => p_rows(i),

Line 2699: wsh_trips_grp.get_trip_details_pvt

2695: IF l_debug_on THEN
2696: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.GET_TRIP_DETAILS_PVT',WSH_DEBUG_SV.C_PROC_LEVEL);
2697: END IF;
2698: --
2699: wsh_trips_grp.get_trip_details_pvt
2700: (p_trip_id => p_rows(i),
2701: x_trip_rec => l_trip_rec,
2702: x_return_status => l_return_status);
2703: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 2817: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.DELETE_TRIP',WSH_DEBUG_SV.C_PROC_LEVEL);

2813: --
2814: -- Debug Statements
2815: --
2816: IF l_debug_on THEN
2817: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.DELETE_TRIP',WSH_DEBUG_SV.C_PROC_LEVEL);
2818: END IF;
2819: --
2820: wsh_trips_pvt.delete_trip(p_rowid => null,
2821: p_trip_id => p_rows(i),

Line 2820: wsh_trips_pvt.delete_trip(p_rowid => null,

2816: IF l_debug_on THEN
2817: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.DELETE_TRIP',WSH_DEBUG_SV.C_PROC_LEVEL);
2818: END IF;
2819: --
2820: wsh_trips_pvt.delete_trip(p_rowid => null,
2821: p_trip_id => p_rows(i),
2822: x_return_status => cur_return_status,
2823: p_validate_flag => 'Y',
2824: p_caller => p_caller);

Line 3752: WSH_TRIPS TP

3748: CURSOR c_get_trip_name IS
3749: SELECT TP.Name, DLG.reprice_required
3750: FROM WSH_DELIVERY_LEGS DLG,
3751: WSH_TRIP_STOPS TS,
3752: WSH_TRIPS TP
3753: WHERE DLG.delivery_leg_id = p_delivery_leg_id AND
3754: DLG.pick_up_stop_id = TS.stop_id AND
3755: TS.trip_id = TP.trip_id;
3756:

Line 6739: p_out_entity_id := nvl(wsh_trips_pvt.get_name(p_in_entity_id), p_in_entity_id);

6735:
6736: IF p_in_entity_name = 'TRIP'
6737: THEN
6738: p_out_entity_name := 'Trip';
6739: p_out_entity_id := nvl(wsh_trips_pvt.get_name(p_in_entity_id), p_in_entity_id);
6740: ELSIF p_in_entity_name = 'STOP'
6741: THEN
6742: p_out_entity_name := 'Stop';
6743: p_out_entity_id := nvl(wsh_trip_stops_pvt.get_name(p_in_entity_id), p_in_entity_id);

Line 6777: -- COMMENT : This procedure will call the WSH_TRIPS_ACTIONS.Fte_Load_Tender

6773:
6774: --========================================================================
6775: -- PROCEDURE : Process_stops_for_load_tender
6776: --
6777: -- COMMENT : This procedure will call the WSH_TRIPS_ACTIONS.Fte_Load_Tender
6778: -- for the Stop ID's present in the global cache table
6779: -- G_STOP_IDS_STOP_IDS_CACHE and G_STOP_IDS_STOP_IDS_EXT_CACHE.
6780: -- Once processed, this will call the API Reset_stops_for_load_tender
6781: -- to reset the global variables.

Line 6862: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.Fte_Load_Tender',WSH_DEBUG_SV.C_PROC_LEVEL);

6858: WSH_DEBUG_SV.log(l_module_name,'l_gross_weight',l_gross_weight);
6859: WSH_DEBUG_SV.log(l_module_name,'l_net_weight',l_net_weight);
6860: WSH_DEBUG_SV.log(l_module_name,'l_volume',l_volume);
6861: WSH_DEBUG_SV.log(l_module_name,'l_fill_percent',l_fill_percent);
6862: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.Fte_Load_Tender',WSH_DEBUG_SV.C_PROC_LEVEL);
6863: END IF;
6864:
6865: WSH_TRIPS_ACTIONS.Fte_Load_Tender(
6866: p_stop_id => l_stop_id ,

Line 6865: WSH_TRIPS_ACTIONS.Fte_Load_Tender(

6861: WSH_DEBUG_SV.log(l_module_name,'l_fill_percent',l_fill_percent);
6862: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.Fte_Load_Tender',WSH_DEBUG_SV.C_PROC_LEVEL);
6863: END IF;
6864:
6865: WSH_TRIPS_ACTIONS.Fte_Load_Tender(
6866: p_stop_id => l_stop_id ,
6867: p_gross_weight => l_gross_weight ,
6868: p_net_weight => l_net_weight ,
6869: p_volume => l_volume ,

Line 6918: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.Fte_Load_Tender',WSH_DEBUG_SV.C_PROC_LEVEL);

6914: WSH_DEBUG_SV.log(l_module_name,'l_gross_weight',l_gross_weight);
6915: WSH_DEBUG_SV.log(l_module_name,'l_net_weight',l_net_weight);
6916: WSH_DEBUG_SV.log(l_module_name,'l_volume',l_volume);
6917: WSH_DEBUG_SV.log(l_module_name,'l_fill_percent',l_fill_percent);
6918: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.Fte_Load_Tender',WSH_DEBUG_SV.C_PROC_LEVEL);
6919: END IF;
6920:
6921: WSH_TRIPS_ACTIONS.Fte_Load_Tender(
6922: p_stop_id => l_stop_id ,

Line 6921: WSH_TRIPS_ACTIONS.Fte_Load_Tender(

6917: WSH_DEBUG_SV.log(l_module_name,'l_fill_percent',l_fill_percent);
6918: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.Fte_Load_Tender',WSH_DEBUG_SV.C_PROC_LEVEL);
6919: END IF;
6920:
6921: WSH_TRIPS_ACTIONS.Fte_Load_Tender(
6922: p_stop_id => l_stop_id ,
6923: p_gross_weight => l_gross_weight ,
6924: p_net_weight => l_net_weight ,
6925: p_volume => l_volume ,

Line 8129: FROM WSH_TRIPS

8125: RAISE FND_API.G_EXC_ERROR;
8126: END IF;
8127:
8128: SELECT shipments_type_flag INTO l_typeflag
8129: FROM WSH_TRIPS
8130: WHERE TRIP_ID = p_trip_id;
8131:
8132: -- Bug 6633529: Handling OTHERS EXCEPTION
8133: BEGIN

Line 8244: FROM wsh_trip_stops stops, wsh_trips trips

8240: /* Replaced this query to get pickup and drop off
8241: CURSOR GET_TRIP_STOPS IS
8242: SELECT stop_location_id, planned_arrival_date, planned_departure_date ,
8243: stops.stop_id
8244: FROM wsh_trip_stops stops, wsh_trips trips
8245: WHERE trips.trip_id = p_trip_id
8246: and trips.trip_id = stops.trip_id
8247: ORDER BY PLANNED_ARRIVAL_DATE,
8248: STOP_SEQUENCE_NUMBER;

Line 8256: wsh_trips trips,

8252: IS
8253: SELECT stop_location_id, planned_arrival_date, planned_departure_date,
8254: stops.stop_id,stops.tms_interface_flag
8255: FROM wsh_trip_stops stops,
8256: wsh_trips trips,
8257: wsh_delivery_legs wdg
8258: WHERE trips.trip_id = p_trip_id
8259: and trips.trip_id = stops.trip_id
8260: and wdg.pick_up_stop_id = stops.stop_id

Line 8269: wsh_trips trips,

8265: IS
8266: SELECT stop_location_id, planned_arrival_date, planned_departure_date,
8267: stops.stop_id,stops.tms_interface_flag
8268: FROM wsh_trip_stops stops,
8269: wsh_trips trips,
8270: wsh_delivery_legs wdg
8271: WHERE trips.trip_id = p_trip_id
8272: and trips.trip_id = stops.trip_id
8273: and wdg.drop_off_stop_id = stops.stop_id