The image cncpt074.gif shows the hire_employees procedure.
Procedure hire_employees (last_name VARCHAR2, job_id VARCHAR2,
manager)id NUMBER, hire_date DATE, salary NUMBER,
commission_pct NUMBER, department_id NUMBER)
BEGIN
.
.
INSERT INTO employees VALUES
(emp_sequence.NEXTVAL, last_name, job_id, manager_id
hire_date, salary, commission_pct, department_id);
.
.
END;
End of image description.