need to optimise the procedure

[iceman]

hi

i have a proc which needs to be optimised... also i need to transfer the code into pl/sql but i am not good in using pl/sql.

can some help me on this proc...I would like to remove the delete statemnt and use insert and update only.