15: CURSOR c_dup_role_name IS
16: SELECT role_id FROM WSH_ROLES WHERE name = p_role_record.name;
17:
18: CURSOR c_new_role_id IS 19: SELECT wsh_roles_s.nextval FROM DUAL; 20:
21: CURSOR c_role_rowid(x_role_id IN NUMBER) IS
22: SELECT rowid FROM WSH_ROLES WHERE role_id = x_role_id;
23: