Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
CREATE OR REPLACE FUNCTION GET_ROLE_NAME(P_USER_NAME VARCHAR2) RETURN VARCHAR2 IS V_ROLE_NAME VARCHAR2(80); L_RESULT VARCHAR2(4000); CURSOR CUR_ROLE_NAME IS select distinct SAT.ACTIVITY_SHORT_NAME as sn FROM si_users_t U, SI_USER_ORG_ROLES UOR, SI_ORG_ROLES SOR, SI_ROLES_T R, SI_ROLE_ACTIVITIES SRA, si_activities_t sat WHERE U.USER_ID = UOR.USER_ID AND UOR.ORG_ROLE_ID = SOR.ORG_ROLE_ID AND SOR.ROLE_ID = R.ROLE_ID AND SRA.ROLE_ID = R.ROLE_ID and SAT.ACTIVITY_ID = SRA.ACTIVITY_ID and SAT.ACTIVITY_SHORT_NAME in ( 'SRA - Auditor', 'SRA - TPA Auditor', 'SRA - Lead', 'SRA - Verification Lead', 'SRA - Facility Contact' ) AND U.USER_NAME = P_USER_NAME; --order by SAT.ACTIVITY_SHORT_NAME); BEGIN FOR I IN CUR_ROLE_NAME LOOP IF I.SN='SRA - Facility Contact' THEN L_RESULT:='Facility Contact'; ELSE IF I.SN='SRA - Lead'or i.sn='SRA - Verification Lead' THEN L_RESULT:='Lead'; ELSE IF I.SN='SRA - Verification Lead'AND I.SN!='Facility Contact' AND I.SN!='SRA - Lead' THEN L_RESULT:='Verification Lead'; END IF; END IF; END IF; END LOOP; RETURN L_RESULT; END;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.