1270: -- return Y if the role has at least one active user; otherwise N
1271: FUNCTION wfrole_has_active_user
1272: (p_role IN VARCHAR2) RETURN VARCHAR2 IS
1273: l_users wf_directory.usertable; 1274: l_username wf_users.name%TYPE; 1275: BEGIN
1276: wf_directory.GetRoleUsers(p_role, l_users);
1277: FOR l_index IN 1..l_users.COUNT LOOP
1278: IF l_users(l_index) IS NOT NULL