trigger logic

   Ok, I don't know how to link to the previous post "trigger causing locks"

But anyway, basically I have a source table and a copy table. The copy table is the exact copy of the source table, but has an extra reflag column. Both tables have t$item column as the key. I have an after insert, update trigger on the source table. Whenever, the source table insert or updates, it inserts or updates the copy table and sets reflag to 0. My developer has a procedure that processes the data on the copy table thousand rows at a time. His procedure sets the first thousand row reflag to 1 and processes the data, and after the processes finishes,