113:
114: BEGIN
115: SELECT NVL(reservable_type, 1)
116: INTO l_lot_reservable_type
117: FROM mtl_lot_numbers
118: WHERE inventory_item_id = l_rsv_rec.inventory_item_id
119: AND organization_id = l_rsv_rec.organization_id
120: AND lot_number = l_rsv_rec.lot_number;
121: EXCEPTION