Help....on stored procedure (or package)

[Lowaiy]

Dear,
In order to help you, you should ask your question in brief. So try to throw your question in better format, and without all these codes.