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 2511: l_trip_rec WSH_TRIPS_PVT.trip_rec_type;

2507: --new variable
2508: l_fte_flag VARCHAR2(1) := 'N';
2509: l_return_status VARCHAR2(30);
2510: l_stop_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
2511: l_trip_rec WSH_TRIPS_PVT.trip_rec_type;
2512: -- bmso
2513: l_lpn_ids WMS_Data_Type_Definitions_PUB.LPNPurgeRecordType;
2514: l_lpn_id_tab wsh_util_core.id_tab_type;
2515:

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

2656: --
2657: -- Debug Statements
2658: --
2659: IF l_debug_on THEN
2660: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.GET_TRIP_DETAILS_PVT',WSH_DEBUG_SV.C_PROC_LEVEL);
2661: END IF;
2662: --
2663: wsh_trips_grp.get_trip_details_pvt
2664: (p_trip_id => p_rows(i),

Line 2663: wsh_trips_grp.get_trip_details_pvt

2659: IF l_debug_on THEN
2660: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.GET_TRIP_DETAILS_PVT',WSH_DEBUG_SV.C_PROC_LEVEL);
2661: END IF;
2662: --
2663: wsh_trips_grp.get_trip_details_pvt
2664: (p_trip_id => p_rows(i),
2665: x_trip_rec => l_trip_rec,
2666: x_return_status => l_return_status);
2667: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

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

2777: --
2778: -- Debug Statements
2779: --
2780: IF l_debug_on THEN
2781: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.DELETE_TRIP',WSH_DEBUG_SV.C_PROC_LEVEL);
2782: END IF;
2783: --
2784: wsh_trips_pvt.delete_trip(p_rowid => null,
2785: p_trip_id => p_rows(i),

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

2780: IF l_debug_on THEN
2781: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.DELETE_TRIP',WSH_DEBUG_SV.C_PROC_LEVEL);
2782: END IF;
2783: --
2784: wsh_trips_pvt.delete_trip(p_rowid => null,
2785: p_trip_id => p_rows(i),
2786: x_return_status => cur_return_status,
2787: p_validate_flag => 'Y',
2788: p_caller => p_caller);

Line 3716: WSH_TRIPS TP

3712: CURSOR c_get_trip_name IS
3713: SELECT TP.Name, DLG.reprice_required
3714: FROM WSH_DELIVERY_LEGS DLG,
3715: WSH_TRIP_STOPS TS,
3716: WSH_TRIPS TP
3717: WHERE DLG.delivery_leg_id = p_delivery_leg_id AND
3718: DLG.pick_up_stop_id = TS.stop_id AND
3719: TS.trip_id = TP.trip_id;
3720:

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

6699:
6700: IF p_in_entity_name = 'TRIP'
6701: THEN
6702: p_out_entity_name := 'Trip';
6703: p_out_entity_id := nvl(wsh_trips_pvt.get_name(p_in_entity_id), p_in_entity_id);
6704: ELSIF p_in_entity_name = 'STOP'
6705: THEN
6706: p_out_entity_name := 'Stop';
6707: p_out_entity_id := nvl(wsh_trip_stops_pvt.get_name(p_in_entity_id), p_in_entity_id);

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

6737:
6738: --========================================================================
6739: -- PROCEDURE : Process_stops_for_load_tender
6740: --
6741: -- COMMENT : This procedure will call the WSH_TRIPS_ACTIONS.Fte_Load_Tender
6742: -- for the Stop ID's present in the global cache table
6743: -- G_STOP_IDS_STOP_IDS_CACHE and G_STOP_IDS_STOP_IDS_EXT_CACHE.
6744: -- Once processed, this will call the API Reset_stops_for_load_tender
6745: -- to reset the global variables.

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

6822: WSH_DEBUG_SV.log(l_module_name,'l_gross_weight',l_gross_weight);
6823: WSH_DEBUG_SV.log(l_module_name,'l_net_weight',l_net_weight);
6824: WSH_DEBUG_SV.log(l_module_name,'l_volume',l_volume);
6825: WSH_DEBUG_SV.log(l_module_name,'l_fill_percent',l_fill_percent);
6826: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.Fte_Load_Tender',WSH_DEBUG_SV.C_PROC_LEVEL);
6827: END IF;
6828:
6829: WSH_TRIPS_ACTIONS.Fte_Load_Tender(
6830: p_stop_id => l_stop_id ,

Line 6829: WSH_TRIPS_ACTIONS.Fte_Load_Tender(

6825: WSH_DEBUG_SV.log(l_module_name,'l_fill_percent',l_fill_percent);
6826: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.Fte_Load_Tender',WSH_DEBUG_SV.C_PROC_LEVEL);
6827: END IF;
6828:
6829: WSH_TRIPS_ACTIONS.Fte_Load_Tender(
6830: p_stop_id => l_stop_id ,
6831: p_gross_weight => l_gross_weight ,
6832: p_net_weight => l_net_weight ,
6833: p_volume => l_volume ,

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

6878: WSH_DEBUG_SV.log(l_module_name,'l_gross_weight',l_gross_weight);
6879: WSH_DEBUG_SV.log(l_module_name,'l_net_weight',l_net_weight);
6880: WSH_DEBUG_SV.log(l_module_name,'l_volume',l_volume);
6881: WSH_DEBUG_SV.log(l_module_name,'l_fill_percent',l_fill_percent);
6882: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.Fte_Load_Tender',WSH_DEBUG_SV.C_PROC_LEVEL);
6883: END IF;
6884:
6885: WSH_TRIPS_ACTIONS.Fte_Load_Tender(
6886: p_stop_id => l_stop_id ,

Line 6885: WSH_TRIPS_ACTIONS.Fte_Load_Tender(

6881: WSH_DEBUG_SV.log(l_module_name,'l_fill_percent',l_fill_percent);
6882: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.Fte_Load_Tender',WSH_DEBUG_SV.C_PROC_LEVEL);
6883: END IF;
6884:
6885: WSH_TRIPS_ACTIONS.Fte_Load_Tender(
6886: p_stop_id => l_stop_id ,
6887: p_gross_weight => l_gross_weight ,
6888: p_net_weight => l_net_weight ,
6889: p_volume => l_volume ,

Line 8093: FROM WSH_TRIPS

8089: RAISE FND_API.G_EXC_ERROR;
8090: END IF;
8091:
8092: SELECT shipments_type_flag INTO l_typeflag
8093: FROM WSH_TRIPS
8094: WHERE TRIP_ID = p_trip_id;
8095:
8096: -- Bug 6633529: Handling OTHERS EXCEPTION
8097: BEGIN

Line 8208: FROM wsh_trip_stops stops, wsh_trips trips

8204: /* Replaced this query to get pickup and drop off
8205: CURSOR GET_TRIP_STOPS IS
8206: SELECT stop_location_id, planned_arrival_date, planned_departure_date ,
8207: stops.stop_id
8208: FROM wsh_trip_stops stops, wsh_trips trips
8209: WHERE trips.trip_id = p_trip_id
8210: and trips.trip_id = stops.trip_id
8211: ORDER BY PLANNED_ARRIVAL_DATE,
8212: STOP_SEQUENCE_NUMBER;

Line 8220: wsh_trips trips,

8216: IS
8217: SELECT stop_location_id, planned_arrival_date, planned_departure_date,
8218: stops.stop_id,stops.tms_interface_flag
8219: FROM wsh_trip_stops stops,
8220: wsh_trips trips,
8221: wsh_delivery_legs wdg
8222: WHERE trips.trip_id = p_trip_id
8223: and trips.trip_id = stops.trip_id
8224: and wdg.pick_up_stop_id = stops.stop_id

Line 8233: wsh_trips trips,

8229: IS
8230: SELECT stop_location_id, planned_arrival_date, planned_departure_date,
8231: stops.stop_id,stops.tms_interface_flag
8232: FROM wsh_trip_stops stops,
8233: wsh_trips trips,
8234: wsh_delivery_legs wdg
8235: WHERE trips.trip_id = p_trip_id
8236: and trips.trip_id = stops.trip_id
8237: and wdg.drop_off_stop_id = stops.stop_id