1999: x_return_status OUT NOCOPY VARCHAR2)
2000: IS
2001: CURSOR check_order_uom IS
2002: SELECT uom_code
2003: FROM mtl_item_uoms_view
2004: WHERE organization_id = p_organization_id AND
2005: inventory_item_id = p_inventory_item_id AND
2006: uom_code = x_uom_code
2007: UNION ALL
2005: inventory_item_id = p_inventory_item_id AND
2006: uom_code = x_uom_code
2007: UNION ALL
2008: SELECT uom_code
2009: FROM mtl_item_uoms_view
2010: WHERE organization_id = p_organization_id AND
2011: inventory_item_id = p_inventory_item_id AND
2012: unit_of_measure = p_unit_of_measure;
2013: --