FUNCTION check_records( p_table_list IN VARCHAR2)
...
declarations --> recur type, refcur var, local variables, ...
...
IS
...
   FOR table_rec IN ( <split sql like in my link> )
   LOOP
      OPEN refcur FOR 'SELECT rownum FROM '||table_rec.table_name;
      FETCH refcur INTO v_dummy;
      IF v_refcur%NOTFOUND;
        v_return := 'Unsuccessful'
      END IF;
      CLOSE refcur;
      
      EXIT WHEN v_return = 'Unsuccessful';
   END LOOP;
...   
   RETURN v_return;
END;