DBA Data[Home] [Help]

APPS.INV_LOT_API_PKG dependencies on MTL_LOT_UOM_CLASS_CONVERSIONS

Line 2150: FROM mtl_lot_uom_class_conversions

2146: l_gen_obj_id NUMBER ;
2147:
2148: CURSOR c_uom_conv_rec IS
2149: SELECT *
2150: FROM mtl_lot_uom_class_conversions
2151: WHERE lot_number = p_lot_number ;
2152:
2153: l_uom_conv_rec c_uom_conv_rec%ROWTYPE ;
2154:

Line 2288: DELETE FROM mtl_lot_uom_class_conversions

2284: OPEN c_uom_conv_rec ;
2285: FETCH c_uom_conv_rec INTO l_uom_conv_rec ;
2286:
2287: IF c_uom_conv_rec%FOUND THEN
2288: DELETE FROM mtl_lot_uom_class_conversions
2289: WHERE lot_number = p_lot_number ;
2290: END IF;
2291:
2292: CLOSE c_uom_conv_rec ;