Thanks all for the quick response.. We will rethink about converting SPs to packages if it can't improve the performance.

Rob, We are asked to do that since the long procedures are not easy to manage. Also, wanted to improve the performance. I am not sure whether converting it to...