438: -- Get the security profile as set in the profile option
439: -- 'MO:Security Profile'.
440: --
441: OPEN csr_get_sec_prf(p_security_profile_id =>
442: to_number(fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL')));
443: FETCH csr_get_sec_prf INTO g_mo_context;
444: CLOSE csr_get_sec_prf;
445:
446: --
777: -- This function will return TRUE if iRecruitment is not installed
778: -- or view_all_candidates_flag is set to 'All'.
779: if (nvl(hr_signon.g_hr_security_profile.view_all_candidates_flag,
780: g_context.view_all_candidates_flag) = 'Y' or
781: nvl(fnd_profile.value('IRC_INSTALLED_FLAG'), 'N') = 'N') then
782: --
783: return true;
784: --
785: else
2381: --
2382: -- The org security mode is operating unit only. Get the
2383: -- 'MO:Operating Unit' profile option.
2384: --
2385: l_pv_org_id := to_number(fnd_profile.value('ORG_ID'));
2386:
2387: --
2388: -- The value of the profile option 'MO:Operating Unit' is
2389: -- validated against p_org_id.
2402: --
2403: -- The org_security_mode is operating unit and inventory orgs.
2404: -- Get the 'MO:Operating Unit' profile option.
2405: --
2406: l_pv_org_id := to_number(fnd_profile.value('ORG_ID'));
2407:
2408: --
2409: -- The value of the profile option 'MO:Operating Unit' is
2410: -- compared against p_org_id.