DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_PKG dependencies on WSH_WV_UTILS

Line 3446: WSH_WV_UTILS.Convert_Uom_core (

3442: END IF;
3443:
3444: IF l_weight_uom_code_item <> l_tmp_wt_uom_code THEN --{
3445: l_maximum_load_weight :=
3446: WSH_WV_UTILS.Convert_Uom_core (
3447: from_uom => l_weight_uom_code_item,
3448: to_uom => l_tmp_wt_uom_code,
3449: quantity => l_maximum_load_weight,
3450: item_id => p_delivery_details_info.inventory_item_id,

Line 3467: WSH_WV_UTILS.Convert_Uom_core (

3463: l_maximum_load_weight);
3464: END IF;
3465:
3466: l_unit_weight_item :=
3467: WSH_WV_UTILS.Convert_Uom_core (
3468: from_uom => l_weight_uom_code_item,
3469: to_uom => l_tmp_wt_uom_code,
3470: quantity => l_unit_weight_item,
3471: item_id => p_delivery_details_info.inventory_item_id,

Line 3489: WSH_WV_UTILS.Convert_Uom_core (

3485: END IF; --}
3486: IF l_volume_uom_code_item <> l_tmp_vol_uom_code THEN --{
3487:
3488: l_unit_volume_item :=
3489: WSH_WV_UTILS.Convert_Uom_core (
3490: from_uom => l_volume_uom_code_item,
3491: to_uom => l_tmp_vol_uom_code,
3492: quantity => l_unit_volume_item,
3493: item_id => p_delivery_details_info.inventory_item_id,

Line 3509: WSH_WV_UTILS.Convert_Uom_core (

3505: l_unit_volume_item);
3506: END IF;
3507:
3508: l_maximum_volume :=
3509: WSH_WV_UTILS.Convert_Uom_core (
3510: from_uom => l_volume_uom_code_item,
3511: to_uom => l_tmp_vol_uom_code,
3512: quantity => l_maximum_volume,
3513: item_id => p_delivery_details_info.inventory_item_id,

Line 3546: l_gross_wt := WSH_WV_UTILS.Convert_Uom(

3542: IF l_container_flag IN ('Y', 'C') AND l_frozen_flag = 'N' THEN
3543:
3544: IF l_tmp_wt_uom_code <> p_delivery_details_info.weight_uom_code THEN
3545:
3546: l_gross_wt := WSH_WV_UTILS.Convert_Uom(
3547: from_uom => l_tmp_wt_uom_code,
3548: to_uom => p_delivery_details_info.weight_uom_code,
3549: quantity => l_gross_wt,
3550: item_id => p_delivery_details_info.inventory_item_id);

Line 3552: l_net_wt := WSH_WV_UTILS.Convert_Uom(

3548: to_uom => p_delivery_details_info.weight_uom_code,
3549: quantity => l_gross_wt,
3550: item_id => p_delivery_details_info.inventory_item_id);
3551:
3552: l_net_wt := WSH_WV_UTILS.Convert_Uom(
3553: from_uom => l_tmp_wt_uom_code,
3554: to_uom => p_delivery_details_info.weight_uom_code,
3555: quantity => l_net_wt,
3556: item_id => p_delivery_details_info.inventory_item_id);

Line 3562: l_volume := WSH_WV_UTILS.Convert_Uom(

3558: END IF;
3559:
3560: IF l_tmp_vol_uom_code <> p_delivery_details_info.volume_uom_code THEN
3561:
3562: l_volume := WSH_WV_UTILS.Convert_Uom(
3563: from_uom => l_tmp_vol_uom_code,
3564: to_uom => p_delivery_details_info.volume_uom_code,
3565: quantity => l_volume,
3566: item_id => p_delivery_details_info.inventory_item_id);

Line 3646: l_tmp_gross_wt := WSH_WV_UTILS.Convert_Uom(

3642: END IF;
3643:
3644: IF l_tmp_wt_uom_code <> p_delivery_details_info.weight_uom_code THEN
3645:
3646: l_tmp_gross_wt := WSH_WV_UTILS.Convert_Uom(
3647: from_uom => l_tmp_wt_uom_code,
3648: to_uom => p_delivery_details_info.weight_uom_code,
3649: quantity => l_tmp_gross_wt,
3650: item_id => p_delivery_details_info.inventory_item_id);

Line 3655: l_tmp_vol := WSH_WV_UTILS.Convert_Uom(

3651: END IF;
3652:
3653: IF l_tmp_vol_uom_code <> p_delivery_details_info.volume_uom_code THEN
3654:
3655: l_tmp_vol := WSH_WV_UTILS.Convert_Uom(
3656: from_uom => l_tmp_vol_uom_code,
3657: to_uom => p_delivery_details_info.volume_uom_code,
3658: quantity => l_tmp_vol,
3659: item_id => p_delivery_details_info.inventory_item_id);

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

3975: (NVL(l_tmp_vol_uom_code,'XX') <> NVL(p_delivery_details_info.volume_uom_code,'XX')) THEN
3976: --{
3977:
3978: IF l_debug_on THEN
3979: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
3980: END IF;
3981:
3982: WSH_WV_UTILS.DD_WV_Post_Process(
3983: p_delivery_detail_id => p_delivery_details_info.delivery_detail_id,

Line 3982: WSH_WV_UTILS.DD_WV_Post_Process(

3978: IF l_debug_on THEN
3979: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
3980: END IF;
3981:
3982: WSH_WV_UTILS.DD_WV_Post_Process(
3983: p_delivery_detail_id => p_delivery_details_info.delivery_detail_id,
3984: p_diff_gross_wt => NVL(p_delivery_details_info.gross_weight,0) - NVL(l_gross_wt,0),
3985: p_diff_net_wt => NVL(p_delivery_details_info.net_weight,0) - NVL(l_net_wt,0),
3986: p_diff_fill_volume => NVL(p_delivery_details_info.volume,0) - NVL(l_volume,0),