Envers will only work if the operations are performed through Hibernate.
If you have stored procedures, you have to rely on hand-written triggers or modifying the stored procedures.
Thanks Adam for reply.
I will look for a better solution using trigger or other which fits best.As I get it will post here for reference.
As you said Adam, I have created my own function and called it in every procedure where the direct operations are performed on my table.
Also I have created new audit table to audit the direct insert/update/delete at database level.While displaying the audit reports the join of my audit table and envers audit table is taken.