70: IF l_rsv_rec.subinventory_code IS NOT NULL AND l_rsv_rec.organization_id IS NOT NULL THEN
71: BEGIN
72: SELECT NVL(reservable_type, 1)
73: INTO l_sub_reservable_type
74: FROM mtl_secondary_inventories
75: WHERE organization_id = l_rsv_rec.organization_id
76: AND secondary_inventory_name = l_rsv_rec.subinventory_code;
77: EXCEPTION
78: WHEN OTHERS THEN