It looks like your collection of rowids contain only one item, and your load the successive rowids in the some item. Due to this, at the end of the operation the collection contains only the last rowid.

I don't see anything wrong in the code listed in your message. If you do not find yourself the bug in the rest of the code, please provide:

- the declaration of price_event_pkg.rowid_type

- the procedure declaration and the code fragment from price_event_pkg.pos_items_stage which loads pos_mods_rowid