1322: -- return Y if the role has at least one active user; otherwise N
1323: FUNCTION wfrole_has_active_user
1324: (p_role IN VARCHAR2) RETURN VARCHAR2 IS
1325: l_users wf_directory.usertable; 1326: l_username wf_users.name%TYPE; 1327: BEGIN
1328: wf_directory.GetRoleUsers(p_role, l_users);
1329: FOR l_index IN 1..l_users.COUNT LOOP
1330: IF l_users(l_index) IS NOT NULL