sequence in procedure (better question)

Original - oracle8 Code ( new_emp_last_name employee.emp_last_name%type, new_emp_first_name employee.emp_first_name%type, new_status employee.status%type, new_street address.street%type, new_city address.city%type, new_state address.state%type, new_zip address.zip%type ) AS base_hour_wage number(1) :=6; rowcount number(4) :=0; CURSOR emp_insert IS SELECT emp_no FROM employee; BEGIN SELECT count(*) INTO rowcount FROM employee WHERE emp_no = emp_no_seq.nextVal;; IF(rowcount = 0 AND new_status = 'tmp') THEN INSERT INTO employee(emp_no, emp_last_name, emp_first_name, status) VALUES(emp_no_seq.nextVal, new_emp_last_name, new_emp_first_name, new_status); INSERT INTO temp(emp_no) VALUES(emp_no_seq.currVal); UPDATE temp SET base_wage = base_hour_wage WHERE emp_no = emp_no_seq.currVal; UPDATE temp SET summers_worked = summers_worked + 1 WHERE emp_no = emp_no_seq.currVal; UPDATE temp SET hourly = summers_worked + base_hour_wage WHERE emp_no = emp_no_seq.currVal; ELSE IF(rowcount > 0)THEN DBMS_OUTPUT.PUT_LINE('Employee number in use.'); ELSE INSERT INTO employee(emp_no, emp_last_name, emp_first_name, status) VALUES(emp_no_seq.currVal, new_emp_last_name, new_emp_first_name, new_status); END IF; IF(new_status = 'mgr')THEN INSERT INTO manager(emp_no, salary) VALUES(emp_no_seq.currVal, 30000.00); END IF; IF(new_status = 'asc')THEN INSERT INTO associate(emp_no, salary) VALUES(emp_no_seq.currVal, 20000.00); END IF; END IF; INSERT into address values( address_seq.nextVal, new_street, new_city, new_state, new_zip); INSERT into emp_address values( address_seq.currVal,emp_no_seq.currVal); DBMS_OUTPUT.PUT_LINE('Employee added.'); END;

 (
new_emp_last_name   employee.emp_last_name%TYPE,
new_emp_first_name  employee.emp_first_name%TYPE,
new_status          employee.status%TYPE,
new_street       address.street%TYPE,
new_city          address.city%TYPE,
new_state        address.state%TYPE,
new_zip          address.zip%TYPE
)
AS
      
      base_hour_wage NUMBER(1) :=6; 
      rowcount NUMBER(4) :=0;
      CURSOR emp_insert IS
                    SELECT emp_no
                    FROM employee;
BEGIN
     SELECT COUNT(*) INTO rowcount
     FROM employee
     WHERE emp_no = emp_no_seq.NEXTVAL;;
     
     IF(rowcount = 0 AND new_status = 'tmp') THEN
          INSERT INTO employee(emp_no, emp_last_name, emp_first_name, status) 
          VALUES(emp_no_seq.NEXTVAL, new_emp_last_name, new_emp_first_name, new_status);
          
          INSERT INTO temp(emp_no)
          VALUES(emp_no_seq.CURRVAL);
          
          UPDATE temp SET base_wage = base_hour_wage
          WHERE emp_no = emp_no_seq.CURRVAL;
          
          UPDATE temp SET summers_worked = summers_worked + 1     
          WHERE emp_no = emp_no_seq.CURRVAL;
          
          UPDATE temp SET hourly = summers_worked + base_hour_wage
          WHERE emp_no = emp_no_seq.CURRVAL;
      
     ELSE  
              
           IF(rowcount > 0)THEN        
                DBMS_OUTPUT.PUT_LINE('Employee number in use.');           
           ELSE
                INSERT INTO employee(emp_no, emp_last_name, emp_first_name, status) 
                VALUES(emp_no_seq.CURRVAL, new_emp_last_name, new_emp_first_name, new_status);        
           END IF;
       
           IF(new_status = 'mgr')THEN
           INSERT INTO manager(emp_no, salary)
           VALUES(emp_no_seq.CURRVAL, 30000.00);
           END IF;
     
           IF(new_status = 'asc')THEN
           INSERT INTO ASSOCIATE(emp_no, salary)
           VALUES(emp_no_seq.CURRVAL, 20000.00);
           END IF;
     END IF; 
 
     INSERT INTO address VALUES(
                 address_seq.NEXTVAL, new_street, new_city, new_state, new_zip);
     INSERT INTO emp_address VALUES(
                 address_seq.CURRVAL,emp_no_seq.CURRVAL);
     
     DBMS_OUTPUT.PUT_LINE('Employee added.');
END;