DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_PKG dependencies on WSH_WV_UTILS

Line 3581: WSH_WV_UTILS.Convert_Uom_core (

3577: END IF;
3578:
3579: IF l_weight_uom_code_item <> l_tmp_wt_uom_code THEN --{
3580: l_maximum_load_weight :=
3581: WSH_WV_UTILS.Convert_Uom_core (
3582: from_uom => l_weight_uom_code_item,
3583: to_uom => l_tmp_wt_uom_code,
3584: quantity => l_maximum_load_weight,
3585: item_id => p_delivery_details_info.inventory_item_id,

Line 3602: WSH_WV_UTILS.Convert_Uom_core (

3598: l_maximum_load_weight);
3599: END IF;
3600:
3601: l_unit_weight_item :=
3602: WSH_WV_UTILS.Convert_Uom_core (
3603: from_uom => l_weight_uom_code_item,
3604: to_uom => l_tmp_wt_uom_code,
3605: quantity => l_unit_weight_item,
3606: item_id => p_delivery_details_info.inventory_item_id,

Line 3624: WSH_WV_UTILS.Convert_Uom_core (

3620: END IF; --}
3621: IF l_volume_uom_code_item <> l_tmp_vol_uom_code THEN --{
3622:
3623: l_unit_volume_item :=
3624: WSH_WV_UTILS.Convert_Uom_core (
3625: from_uom => l_volume_uom_code_item,
3626: to_uom => l_tmp_vol_uom_code,
3627: quantity => l_unit_volume_item,
3628: item_id => p_delivery_details_info.inventory_item_id,

Line 3644: WSH_WV_UTILS.Convert_Uom_core (

3640: l_unit_volume_item);
3641: END IF;
3642:
3643: l_maximum_volume :=
3644: WSH_WV_UTILS.Convert_Uom_core (
3645: from_uom => l_volume_uom_code_item,
3646: to_uom => l_tmp_vol_uom_code,
3647: quantity => l_maximum_volume,
3648: item_id => p_delivery_details_info.inventory_item_id,

Line 3681: l_gross_wt := WSH_WV_UTILS.Convert_Uom(

3677: IF l_container_flag IN ('Y', 'C') AND l_frozen_flag = 'N' THEN
3678:
3679: IF l_tmp_wt_uom_code <> p_delivery_details_info.weight_uom_code THEN
3680:
3681: l_gross_wt := WSH_WV_UTILS.Convert_Uom(
3682: from_uom => l_tmp_wt_uom_code,
3683: to_uom => p_delivery_details_info.weight_uom_code,
3684: quantity => l_gross_wt,
3685: item_id => p_delivery_details_info.inventory_item_id);

Line 3687: l_net_wt := WSH_WV_UTILS.Convert_Uom(

3683: to_uom => p_delivery_details_info.weight_uom_code,
3684: quantity => l_gross_wt,
3685: item_id => p_delivery_details_info.inventory_item_id);
3686:
3687: l_net_wt := WSH_WV_UTILS.Convert_Uom(
3688: from_uom => l_tmp_wt_uom_code,
3689: to_uom => p_delivery_details_info.weight_uom_code,
3690: quantity => l_net_wt,
3691: item_id => p_delivery_details_info.inventory_item_id);

Line 3697: l_volume := WSH_WV_UTILS.Convert_Uom(

3693: END IF;
3694:
3695: IF l_tmp_vol_uom_code <> p_delivery_details_info.volume_uom_code THEN
3696:
3697: l_volume := WSH_WV_UTILS.Convert_Uom(
3698: from_uom => l_tmp_vol_uom_code,
3699: to_uom => p_delivery_details_info.volume_uom_code,
3700: quantity => l_volume,
3701: item_id => p_delivery_details_info.inventory_item_id);

Line 3781: l_tmp_gross_wt := WSH_WV_UTILS.Convert_Uom(

3777: END IF;
3778:
3779: IF l_tmp_wt_uom_code <> p_delivery_details_info.weight_uom_code THEN
3780:
3781: l_tmp_gross_wt := WSH_WV_UTILS.Convert_Uom(
3782: from_uom => l_tmp_wt_uom_code,
3783: to_uom => p_delivery_details_info.weight_uom_code,
3784: quantity => l_tmp_gross_wt,
3785: item_id => p_delivery_details_info.inventory_item_id);

Line 3790: l_tmp_vol := WSH_WV_UTILS.Convert_Uom(

3786: END IF;
3787:
3788: IF l_tmp_vol_uom_code <> p_delivery_details_info.volume_uom_code THEN
3789:
3790: l_tmp_vol := WSH_WV_UTILS.Convert_Uom(
3791: from_uom => l_tmp_vol_uom_code,
3792: to_uom => p_delivery_details_info.volume_uom_code,
3793: quantity => l_tmp_vol,
3794: item_id => p_delivery_details_info.inventory_item_id);

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

4110: (NVL(l_tmp_vol_uom_code,'XX') <> NVL(p_delivery_details_info.volume_uom_code,'XX')) THEN
4111: --{
4112:
4113: IF l_debug_on THEN
4114: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
4115: END IF;
4116:
4117: WSH_WV_UTILS.DD_WV_Post_Process(
4118: p_delivery_detail_id => p_delivery_details_info.delivery_detail_id,

Line 4117: WSH_WV_UTILS.DD_WV_Post_Process(

4113: IF l_debug_on THEN
4114: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
4115: END IF;
4116:
4117: WSH_WV_UTILS.DD_WV_Post_Process(
4118: p_delivery_detail_id => p_delivery_details_info.delivery_detail_id,
4119: p_diff_gross_wt => NVL(p_delivery_details_info.gross_weight,0) - NVL(l_gross_wt,0),
4120: p_diff_net_wt => NVL(p_delivery_details_info.net_weight,0) - NVL(l_net_wt,0),
4121: p_diff_fill_volume => NVL(p_delivery_details_info.volume,0) - NVL(l_volume,0),