DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_GRP dependencies on WSH_WV_UTILS

Line 3631: WSH_WV_UTILS.G_RESET_WV := 'Y'; -- set to Y to enable the update

3627: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;
3628: END IF;
3629:
3630: IF l_gc3_is_installed = 'Y' THEN
3631: WSH_WV_UTILS.G_RESET_WV := 'Y'; -- set to Y to enable the update
3632: END IF;
3633: -- End of OTM R12 : packing ECO
3634:
3635: IF l_debug_on THEN

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

3632: END IF;
3633: -- End of OTM R12 : packing ECO
3634:
3635: IF l_debug_on THEN
3636: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DETAIL_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
3637: END IF;
3638: --
3639: wsh_wv_utils.detail_weight_volume (
3640: p_detail_rows => l_id_tab ,

Line 3639: wsh_wv_utils.detail_weight_volume (

3635: IF l_debug_on THEN
3636: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DETAIL_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
3637: END IF;
3638: --
3639: wsh_wv_utils.detail_weight_volume (
3640: p_detail_rows => l_id_tab ,
3641: p_override_flag => 'Y', -- Need to see if we can Use p_action_prms.wv_override_flag
3642: x_return_status => l_return_status);
3643:

Line 3654: WSH_WV_UTILS.G_RESET_WV := 'N'; -- after call, set it back to 'N'

3650: );
3651:
3652: -- OTM R12 : packing ECO
3653: IF l_gc3_is_installed = 'Y' THEN
3654: WSH_WV_UTILS.G_RESET_WV := 'N'; -- after call, set it back to 'N'
3655: END IF;
3656: -- End of OTM R12 : packing ECO
3657:
3658: --

Line 6238: SELECT wsh_wv_utils.convert_uom (msi.weight_uom_code,

6234: --Bug 12850936: Cursor to determine weight/volume in case
6235: --where shipped quantity is zero
6236: CURSOR Item_Net_Wt_Vol(c_delivery_detail_id NUMBER,
6237: c_shipped_quantity NUMBER) IS
6238: SELECT wsh_wv_utils.convert_uom (msi.weight_uom_code,
6239: wdd.weight_uom_code,
6240: (NVL(wdd.unit_weight, msi.unit_weight) *
6241: wsh_wv_utils.convert_uom (wdd.requested_quantity_uom,
6242: msi.primary_uom_code,

Line 6241: wsh_wv_utils.convert_uom (wdd.requested_quantity_uom,

6237: c_shipped_quantity NUMBER) IS
6238: SELECT wsh_wv_utils.convert_uom (msi.weight_uom_code,
6239: wdd.weight_uom_code,
6240: (NVL(wdd.unit_weight, msi.unit_weight) *
6241: wsh_wv_utils.convert_uom (wdd.requested_quantity_uom,
6242: msi.primary_uom_code,
6243: nvl(c_shipped_quantity,
6244: NVL(wdd.picked_quantity,
6245: wdd.requested_quantity)),

Line 6248: wsh_wv_utils.convert_uom (msi.volume_uom_code,

6244: NVL(wdd.picked_quantity,
6245: wdd.requested_quantity)),
6246: wdd.inventory_item_id) ),
6247: wdd.inventory_item_id ) weight,
6248: wsh_wv_utils.convert_uom (msi.volume_uom_code,
6249: wdd.volume_uom_code,
6250: (NVL(wdd.unit_volume, msi.unit_volume) *
6251: wsh_wv_utils.convert_uom (wdd.requested_quantity_uom,
6252: msi.primary_uom_code,

Line 6251: wsh_wv_utils.convert_uom (wdd.requested_quantity_uom,

6247: wdd.inventory_item_id ) weight,
6248: wsh_wv_utils.convert_uom (msi.volume_uom_code,
6249: wdd.volume_uom_code,
6250: (NVL(wdd.unit_volume, msi.unit_volume) *
6251: wsh_wv_utils.convert_uom (wdd.requested_quantity_uom,
6252: msi.primary_uom_code,
6253: nvl(c_shipped_quantity,
6254: NVL(wdd.picked_quantity,
6255: wdd.requested_quantity)),

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

6465: --
6466: IF ( nvl(x_detail_info_tab(l_index).requested_quantity,fnd_api.g_miss_num) = fnd_api.g_miss_num ) THEN
6467:
6468: IF l_debug_on THEN
6469: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
6470: END IF;
6471:
6472: x_detail_info_tab(l_index).requested_quantity := wsh_wv_utils.convert_uom(
6473: x_detail_info_tab(l_index).src_requested_quantity_uom,

Line 6472: x_detail_info_tab(l_index).requested_quantity := wsh_wv_utils.convert_uom(

6468: IF l_debug_on THEN
6469: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
6470: END IF;
6471:
6472: x_detail_info_tab(l_index).requested_quantity := wsh_wv_utils.convert_uom(
6473: x_detail_info_tab(l_index).src_requested_quantity_uom,
6474: l_inventory_item_info.primary_uom_code,
6475: x_detail_info_tab(l_index).src_requested_quantity,
6476: x_detail_info_tab(l_index).inventory_item_id);

Line 10253: WSH_WV_UTILS.Convert_Uom_core (

10249: l_delivery_detail_rec.weight_uom_code
10250: AND l_weight_uom_code <> FND_API.G_MISS_CHAR
10251: THEN
10252: l_delivery_detail_rec.gross_weight :=
10253: WSH_WV_UTILS.Convert_Uom_core (
10254: from_uom => l_weight_uom_code,
10255: to_uom => l_delivery_detail_rec.weight_uom_code,
10256: quantity => l_delivery_detail_rec.gross_weight,
10257: item_id => l_delivery_detail_rec.inventory_item_id,

Line 10267: WSH_WV_UTILS.Convert_Uom_core (

10263: x_num_errors => l_loop_num_error
10264: );
10265:
10266: l_delivery_detail_rec.net_weight :=
10267: WSH_WV_UTILS.Convert_Uom_core (
10268: from_uom => l_weight_uom_code,
10269: to_uom => l_delivery_detail_rec.weight_uom_code,
10270: quantity => l_delivery_detail_rec.net_weight,
10271: item_id => l_delivery_detail_rec.inventory_item_id,

Line 10297: WSH_WV_UTILS.Convert_Uom_core (

10293: AND l_volume_uom_code <> FND_API.G_MISS_CHAR
10294: THEN
10295:
10296: l_delivery_detail_rec.volume :=
10297: WSH_WV_UTILS.Convert_Uom_core (
10298: from_uom => l_volume_uom_code,
10299: to_uom => l_delivery_detail_rec.volume_uom_code,
10300: quantity => l_delivery_detail_rec.volume,
10301: item_id => l_delivery_detail_rec.inventory_item_id,

Line 10311: WSH_WV_UTILS.Convert_Uom_core (

10307: x_num_errors => l_loop_num_error
10308: );
10309:
10310: l_delivery_detail_rec.filled_volume :=
10311: WSH_WV_UTILS.Convert_Uom_core (
10312: from_uom => l_volume_uom_code,
10313: to_uom => l_delivery_detail_rec.volume_uom_code,
10314: quantity => l_delivery_detail_rec.filled_volume,
10315: item_id => l_delivery_detail_rec.inventory_item_id,