auto generate number

IF :SYSTEM.LAST_RECORD = 'TRUE' AND :CAAE.CAAEALU IS NOT NULL THEN
   NEXT_RECORD;
END IF;