How to mark every inserted/updated record by increased number, generated at commit time

Tip from Vlad Khorsun:

1. add TranNum field to the all interesting tables
2. fill this field in BEFORE INSERT OR UPDATE trigger using CURRENT_TRANSACTION value
3. create special table like TranMarks(TranNum, TranMark)
4. create sequence SeqTranMarks
5. create ON COMMIT database trigger which will insert CURRENT_TRANSACTION and next value of sequence SeqTranMarks into TranMarks table

Now you have marked all records by transaction numbers and order of transaction's commits.