SELECT
 /*+ PARALLEL({ iv_tabnm }, 36) */
TRUNC(rownum / 200000) as pack_num,
MIN(rowid), MAX(rowid)
FROM { iv_tabnm } PARTITION ({ iv_partition_name })
WHERE
AND { ls_condition }
GROUP BY TRUNC(rownum / 200000)

SELECT
 /*+ PARALLEL({ iv_tabnm }, 36) */
field1, field2,...,fieldn
FROM { iv_tabnm } PARTITION ({ iv_partition_name })
WHERE rownum <= 200000
AND { ls_condition }
AND rowid >= iv_min_rowid
AND rowid <= iv_max_rowid

SELECT
 /*+ PARALLEL({ iv_tabnm }, 36) */
field1, field2,...,fieldn
FROM { iv_tabnm } PARTITION ({ iv_partition_name })
WHERE rownum <= 200000
AND { ls_condition }
AND rowid >= '{ iv_min_rowid }'
AND rowid <= '{ iv_max_rowid }'.
...
UPDATE
	/*+ PARALLEL({ iv_tabnm }, 36)*/
   { iv_tabnm } PARTITION ({ lv_partition_name })
   SET status = 'C'
	   stmp_calc = iv_now
  WHERE { ls_condition }
    AND ROWID  >= '{ iv_min_rowid }'
    AND ROWID  <= '{ iv_max_rowid }'.