DBA Data[Home] [Help]

APPS.INV_LOT_API_PKG dependencies on MTL_LOT_UOM_CLASS_CONVERSIONS

Line 2206: FROM mtl_lot_uom_class_conversions

2202: l_gen_obj_id NUMBER ;
2203:
2204: CURSOR c_uom_conv_rec IS
2205: SELECT *
2206: FROM mtl_lot_uom_class_conversions
2207: WHERE lot_number = p_lot_number ;
2208:
2209: l_uom_conv_rec c_uom_conv_rec%ROWTYPE ;
2210:

Line 2344: DELETE FROM mtl_lot_uom_class_conversions

2340: OPEN c_uom_conv_rec ;
2341: FETCH c_uom_conv_rec INTO l_uom_conv_rec ;
2342:
2343: IF c_uom_conv_rec%FOUND THEN
2344: DELETE FROM mtl_lot_uom_class_conversions
2345: WHERE lot_number = p_lot_number ;
2346: END IF;
2347:
2348: CLOSE c_uom_conv_rec ;