User Security and Admin sample in Oracle Stored procedures

Procedure UserSecurityAdd(pUSER_login in users_t1.usr_login
%type,
pUSER_lname in users_t1.usr_lname
%type,
pUSER_fname in users_t1.usr_fname
%type,
pUSER_mi in users_t1.usr_mi%type,
pUSER_pcd_view in users_t1.usr_pcd_view
%type,
pUSER_emp_id in users_t1.usr_emp_id
%type,
pRowsAffected out number) is

begin
select usr_id_s1.nextval into pUSER_id from dual;
insert into users_t1
( usr_emp_id,
usr_login,
usr_lname,
usr_fname,
usr_mi,
usr_pcd_view)
values
( pUSER_emp_id,
pUSER_login,
pUSER_lname,
pUSER_fname,
pUSER_mi,
pUSER_pcd_view);

commit;
pRowsAffected := sql%rowcount;
end UserSecurityAdd;