APPS.FTE_SOURCE_LINE_CONSOLIDATION dependencies on WSH_WV_UTILS

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

76: --
77: -- Debug Statements
78: --
79: IF l_debug_on THEN
80: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.GET_DEFAULT_UOMS',WSH_DEBUG_SV.C_PROC_LEVEL);
81: END IF;
82: --
83: WSH_WV_UTILS.get_default_uoms(p_org_id,
84: l_weight_uom_code,

Line 83: WSH_WV_UTILS.get_default_uoms(p_org_id,

79: IF l_debug_on THEN
80: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.GET_DEFAULT_UOMS',WSH_DEBUG_SV.C_PROC_LEVEL);
81: END IF;
82: --
83: WSH_WV_UTILS.get_default_uoms(p_org_id,
84: l_weight_uom_code,
85: l_volume_uom_code,
86: l_status);
87:

Line 348: --bug 6707893: Added p_inv_id parameter in WSH_WV_UTILS.convert_uom called in the cursor

344: l_override_ship_method BOOLEAN;
345:
346: l_group_by_flags WSH_DELIVERY_AUTOCREATE.group_by_flags_rec_type;
347:
348: --bug 6707893: Added p_inv_id parameter in WSH_WV_UTILS.convert_uom called in the cursor
349: CURSOR get_converted_wv(p_org_id NUMBER, p_inv_id NUMBER, p_source_qty NUMBER,
350: p_source_qty_uom VARCHAR2, p_weight_uom VARCHAR2,
351: p_volume_uom VARCHAR2) IS
352: SELECT WSH_WV_UTILS.convert_uom(weight_uom_code,

Line 352: SELECT WSH_WV_UTILS.convert_uom(weight_uom_code,

348: --bug 6707893: Added p_inv_id parameter in WSH_WV_UTILS.convert_uom called in the cursor
349: CURSOR get_converted_wv(p_org_id NUMBER, p_inv_id NUMBER, p_source_qty NUMBER,
350: p_source_qty_uom VARCHAR2, p_weight_uom VARCHAR2,
351: p_volume_uom VARCHAR2) IS
352: SELECT WSH_WV_UTILS.convert_uom(weight_uom_code,
353: p_weight_uom,
354: nvl(unit_weight, 0) * WSH_WV_UTILS.convert_uom(p_source_qty_uom,
355: primary_uom_code,
356: p_source_qty, p_inv_id), p_inv_id),

Line 354: nvl(unit_weight, 0) * WSH_WV_UTILS.convert_uom(p_source_qty_uom,

350: p_source_qty_uom VARCHAR2, p_weight_uom VARCHAR2,
351: p_volume_uom VARCHAR2) IS
352: SELECT WSH_WV_UTILS.convert_uom(weight_uom_code,
353: p_weight_uom,
354: nvl(unit_weight, 0) * WSH_WV_UTILS.convert_uom(p_source_qty_uom,
355: primary_uom_code,
356: p_source_qty, p_inv_id), p_inv_id),
357: WSH_WV_UTILS.convert_uom(volume_uom_code,
358: p_volume_uom,

Line 357: WSH_WV_UTILS.convert_uom(volume_uom_code,

353: p_weight_uom,
354: nvl(unit_weight, 0) * WSH_WV_UTILS.convert_uom(p_source_qty_uom,
355: primary_uom_code,
356: p_source_qty, p_inv_id), p_inv_id),
357: WSH_WV_UTILS.convert_uom(volume_uom_code,
358: p_volume_uom,
359: nvl(unit_volume, 0) * WSH_WV_UTILS.convert_uom(p_source_qty_uom,
360: primary_uom_code,
361: p_source_qty,p_inv_id),p_inv_id)

Line 359: nvl(unit_volume, 0) * WSH_WV_UTILS.convert_uom(p_source_qty_uom,

355: primary_uom_code,
356: p_source_qty, p_inv_id), p_inv_id),
357: WSH_WV_UTILS.convert_uom(volume_uom_code,
358: p_volume_uom,
359: nvl(unit_volume, 0) * WSH_WV_UTILS.convert_uom(p_source_qty_uom,
360: primary_uom_code,
361: p_source_qty,p_inv_id),p_inv_id)
362: FROM mtl_system_items
363: WHERE organization_id = p_org_id