Hi,
I have gone through your project details and would like to take an opportunity to work on it. Being experienced in working on several database assignment/projects, I can help you out in getting the work done quickly. At first glance, I noticed that procedure is written in sql server database syntax and not oracle database syntax so need to be corrected.
Waiting for your response for quick discussion. Thanks.