DBA Data[Home] [Help]

APPS.WSH_DETAILS_VALIDATIONS dependencies on WSH_WV_UTILS

Line 1790: SELECT WSH_WV_UTILS.CONVERT_UOM(order_quantity_uom,

1786:
1787: CURSOR c_ordered_quantity(x_source_line_id IN NUMBER,
1788: x_item_id IN NUMBER,
1789: x_primary_uom IN VARCHAR2) IS
1790: SELECT WSH_WV_UTILS.CONVERT_UOM(order_quantity_uom,
1791: x_primary_uom,
1792: ordered_quantity,
1793: x_item_id) quantity ,
1794: order_quantity_uom,

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

1998: --
1999: -- Debug Statements
2000: --
2001: IF l_debug_on THEN
2002: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
2003: END IF;
2004: --
2005: l_max_quantity := l_max_quantity
2006: - l_staged_info.net_staged_qty;

Line 3445: x_out_attributes.min_remaining_quantity := WSH_WV_UTILS.convert_uom(

3441: -- convert to order line UOM
3442: IF l_ordered_quantity_uom <> l_requested_quantity_uom THEN
3443:
3444: IF l_min_remaining_quantity > 0 THEN
3445: x_out_attributes.min_remaining_quantity := WSH_WV_UTILS.convert_uom(
3446: from_uom => l_requested_quantity_uom,
3447: to_uom => l_ordered_quantity_uom,
3448: quantity => l_min_remaining_quantity,
3449: item_id => l_inventory_item_id);

Line 3452: x_out_attributes.max_remaining_quantity := WSH_WV_UTILS.convert_uom(

3448: quantity => l_min_remaining_quantity,
3449: item_id => l_inventory_item_id);
3450: END IF;
3451: IF l_max_remaining_quantity > 0 THEN
3452: x_out_attributes.max_remaining_quantity := WSH_WV_UTILS.convert_uom(
3453: from_uom => l_requested_quantity_uom,
3454: to_uom => l_ordered_quantity_uom,
3455: quantity => l_max_remaining_quantity,
3456: item_id => l_inventory_item_id);

Line 6957: x_det_rec.cycle_count_quantity2 := WSH_WV_UTILS.convert_uom

6953: END IF;
6954:
6955: IF WSH_UTIL_CORE.Get_Line_Fulfillment_Base(l_det_source_code,
6956: l_det_source_line_id) <>'S' THEN
6957: x_det_rec.cycle_count_quantity2 := WSH_WV_UTILS.convert_uom
6958: (
6959: from_uom => x_det_rec.requested_quantity_uom,
6960: to_uom => x_det_rec.requested_quantity_uom2,
6961: quantity => x_det_rec.cycle_count_quantity,

Line 7503: WSH_WV_UTILS.within_deviation', wsh_debug_sv.c_proc_level);

7499: --{
7500: --
7501: IF l_debug_on THEN
7502: wsh_debug_sv.logmsg(l_module_name, 'Calling program unit
7503: WSH_WV_UTILS.within_deviation', wsh_debug_sv.c_proc_level);
7504: END IF;
7505: --
7506: -- HW OPMCONV - Call new API to check deviation
7507: l_return := WSH_WV_UTILS.within_deviation

Line 7507: l_return := WSH_WV_UTILS.within_deviation

7503: WSH_WV_UTILS.within_deviation', wsh_debug_sv.c_proc_level);
7504: END IF;
7505: --
7506: -- HW OPMCONV - Call new API to check deviation
7507: l_return := WSH_WV_UTILS.within_deviation
7508: (
7509: p_organization_id => l_line_rec.organization_id,
7510: p_inventory_item_id => l_line_rec.inventory_item_id,
7511: p_lot_number => l_lot_num,

Line 7540: wsh_debug_sv.logmsg(l_module_name, 'Calling program unit WSH_WV_UTILS.convert_uom', wsh_debug_sv.c_proc_level);

7536: THEN
7537: --{
7538: --
7539: IF l_debug_on THEN
7540: wsh_debug_sv.logmsg(l_module_name, 'Calling program unit WSH_WV_UTILS.convert_uom', wsh_debug_sv.c_proc_level);
7541: END IF;
7542: --
7543: -- HW OPMCONV - Call UOM routine passing lot_num
7544: l_qty2 := WSH_WV_UTILS.convert_uom

Line 7544: l_qty2 := WSH_WV_UTILS.convert_uom

7540: wsh_debug_sv.logmsg(l_module_name, 'Calling program unit WSH_WV_UTILS.convert_uom', wsh_debug_sv.c_proc_level);
7541: END IF;
7542: --
7543: -- HW OPMCONV - Call UOM routine passing lot_num
7544: l_qty2 := WSH_WV_UTILS.convert_uom
7545: (
7546: item_id => l_line_rec.inventory_item_id,
7547: org_id => l_line_rec.organization_id,
7548: from_uom => l_line_rec.requested_quantity_uom,