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...