A proc containing a cursor can be written as follows:

PROCEDURE my_proc IS
  CURSOR mytable_cur IS
    SELECT id
    FROM   mytable
    WHERE  status = 1;

BEGIN

  FOR mytable_rec IN mytable_cur LOOP
    -- do whatever
  END LOOP;

END my_proc;