WSH_EXCEPTION_PUB to purge and close exception
For change_status, I set the p_exception_rec.exception_id and p_exception_rec.new_status. I would expect only 1 row has changed status since exception_id is unique. but the x_msg_count shows me 3 rows of data has change the status. WHY? How can I specify one row to change status?