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_DELIVERY_LEGS_ACTIONS dependencies on WSH_WV_UTILS

Line 166: select wsh_wv_utils.convert_uom( WEIGHT_UOM_CODE, p_wt_uom, DEPARTURE_GROSS_WEIGHT, null) gross_weight,

162: );
163:
164: -- Get Previous stops W/V converted to c_wt_uom/c_vol_uom
165: CURSOR c_get_prev_seq_wv(p_trip_id NUMBER, p_stop_seq NUMBER, p_wt_uom VARCHAR2, p_vol_uom VARCHAR2) IS
166: select wsh_wv_utils.convert_uom( WEIGHT_UOM_CODE, p_wt_uom, DEPARTURE_GROSS_WEIGHT, null) gross_weight,
167: wsh_wv_utils.convert_uom( WEIGHT_UOM_CODE, p_wt_uom, DEPARTURE_NET_WEIGHT, null) net_weight,
168: wsh_wv_utils.convert_uom( VOLUME_UOM_CODE, p_vol_uom, DEPARTURE_VOLUME, null) volume
169: from wsh_trip_stops
170: where trip_id = p_trip_id

Line 167: wsh_wv_utils.convert_uom( WEIGHT_UOM_CODE, p_wt_uom, DEPARTURE_NET_WEIGHT, null) net_weight,

163:
164: -- Get Previous stops W/V converted to c_wt_uom/c_vol_uom
165: CURSOR c_get_prev_seq_wv(p_trip_id NUMBER, p_stop_seq NUMBER, p_wt_uom VARCHAR2, p_vol_uom VARCHAR2) IS
166: select wsh_wv_utils.convert_uom( WEIGHT_UOM_CODE, p_wt_uom, DEPARTURE_GROSS_WEIGHT, null) gross_weight,
167: wsh_wv_utils.convert_uom( WEIGHT_UOM_CODE, p_wt_uom, DEPARTURE_NET_WEIGHT, null) net_weight,
168: wsh_wv_utils.convert_uom( VOLUME_UOM_CODE, p_vol_uom, DEPARTURE_VOLUME, null) volume
169: from wsh_trip_stops
170: where trip_id = p_trip_id
171: and stop_sequence_number < p_stop_seq

Line 168: wsh_wv_utils.convert_uom( VOLUME_UOM_CODE, p_vol_uom, DEPARTURE_VOLUME, null) volume

164: -- Get Previous stops W/V converted to c_wt_uom/c_vol_uom
165: CURSOR c_get_prev_seq_wv(p_trip_id NUMBER, p_stop_seq NUMBER, p_wt_uom VARCHAR2, p_vol_uom VARCHAR2) IS
166: select wsh_wv_utils.convert_uom( WEIGHT_UOM_CODE, p_wt_uom, DEPARTURE_GROSS_WEIGHT, null) gross_weight,
167: wsh_wv_utils.convert_uom( WEIGHT_UOM_CODE, p_wt_uom, DEPARTURE_NET_WEIGHT, null) net_weight,
168: wsh_wv_utils.convert_uom( VOLUME_UOM_CODE, p_vol_uom, DEPARTURE_VOLUME, null) volume
169: from wsh_trip_stops
170: where trip_id = p_trip_id
171: and stop_sequence_number < p_stop_seq
172: order by stop_sequence_number desc;

Line 744: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.GET_DEFAULT_UOMS',WSH_DEBUG_SV.C_PROC_LEVEL);

740: --
741: -- Debug Statements
742: --
743: IF l_debug_on THEN
744: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.GET_DEFAULT_UOMS',WSH_DEBUG_SV.C_PROC_LEVEL);
745: END IF;
746: --
747: wsh_wv_utils.get_default_uoms(l_org_id, l_default_wt_uom, l_default_vol_uom, x_return_status);
748:

Line 747: wsh_wv_utils.get_default_uoms(l_org_id, l_default_wt_uom, l_default_vol_uom, x_return_status);

743: IF l_debug_on THEN
744: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.GET_DEFAULT_UOMS',WSH_DEBUG_SV.C_PROC_LEVEL);
745: END IF;
746: --
747: wsh_wv_utils.get_default_uoms(l_org_id, l_default_wt_uom, l_default_vol_uom, x_return_status);
748:
749: -- Check if delivery leg exists for the delivery/trip combination
750: -- Skip this delivery if leg exists
751:

Line 1743: WSH_WV_UTILS.Del_WV_Post_Process(

1739: RAISE e_InvalidDelExcep; -- Bug 5336308
1740: END IF;
1741:
1742: -- J: W/V Changes
1743: WSH_WV_UTILS.Del_WV_Post_Process(
1744: p_delivery_id => l_del_rows(i),
1745: p_diff_gross_wt => l_org_gross_wt,
1746: p_diff_net_wt => l_org_net_wt,
1747: p_diff_volume => l_org_vol,

Line 3152: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.Del_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);

3148: -- J: W/V Changes
3149: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3150:
3151: IF l_debug_on THEN
3152: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.Del_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
3153: END IF;
3154: WSH_WV_UTILS.Del_WV_Post_Process(
3155: p_delivery_id => p_del_rows(i),
3156: p_diff_gross_wt => -1 * l_gross_wt,

Line 3154: WSH_WV_UTILS.Del_WV_Post_Process(

3150:
3151: IF l_debug_on THEN
3152: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.Del_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
3153: END IF;
3154: WSH_WV_UTILS.Del_WV_Post_Process(
3155: p_delivery_id => p_del_rows(i),
3156: p_diff_gross_wt => -1 * l_gross_wt,
3157: p_diff_net_wt => -1 * l_net_wt,
3158: p_diff_volume => -1 * l_vol,