Well I didnt really tried to understand what was going in your procedure.

In my opinion you should move all buisness logic to your application layer.

Then you most likely never need...