need help in rewriting sql into plsql

Hello,
I wanted to take the following sql and put it in a plsql precedure so that a user can just execute that procedure when ever they wanted to do the following operation.


spool delete_one_employee
delete from HRW_HEALTH_PLAN_DEPENDENTS where
health_plan_key in
(select health_plan_key from hrw_dependents where employee_id = '&&emp_id');

delete from HRW_INSURANCE_BENEFICIARIES where
insurance_key in
(select insurance_key from hrw_insurances where employee_id = '&&emp_id');

delete from HRW_INSURANCE_OFFERS where employee_id = '&&emp_id';

spool off
thanks
Jigar

would this work?

create or replace procedure delete_one_employee as

/*THIS SCRIPT DELETES AN ENTIRE EMPLOYEE'S "RECORD".
I.E. THE EMPLOYEE'S ROWS FROM ALL TABLES THAT
* HAVE AN EMPLOYEE_ID COLUMN.*/

BEGIN

delete from HRW_HEALTH_PLAN_DEPENDENTS where
health_plan_key in
(select health_plan_key from hrw_dependents where employee_id = '&&emp_id');

delete from HRW_INSURANCE_BENEFICIARIES where
insurance_key in
(select insurance_key from hrw_insurances where employee_id = '&&emp_id');

delete from HRW_INSURANCE_OFFERS where employee_id = '&&emp_id';
delete from HRW_MISC_OFFERS where employee_id = '&&emp_id';
delete from HRW_FLEX_SPEND_OFFERS where employee_id = '&&emp_id';

end;

Wouldn't it be better coding practice for the procedure to have the employee ID passed in as a parameter and remove the prompts?

create or replace procedure delete_one_employee (emp_id IN NUMBER) as...

stecal..i am a new at plsql..thats why i was askinng for help...