eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MO_UTILS dependencies on PER_SECURITY_PROFILES

Line 344: l_sp_name per_security_profiles.security_profile_name%TYPE;

340: RETURN VARCHAR2
341: IS
342: l_security_profile_id fnd_profile_option_values.profile_option_value%TYPE;
343: l_org_exists VARCHAR2(1) := 'N';
344: l_sp_name per_security_profiles.security_profile_name%TYPE;
345: l_bg_id per_security_profiles.business_group_id%TYPE;
346: is_view_all_org VARCHAR2(1);
347:
348: BEGIN

Line 345: l_bg_id per_security_profiles.business_group_id%TYPE;

341: IS
342: l_security_profile_id fnd_profile_option_values.profile_option_value%TYPE;
343: l_org_exists VARCHAR2(1) := 'N';
344: l_sp_name per_security_profiles.security_profile_name%TYPE;
345: l_bg_id per_security_profiles.business_group_id%TYPE;
346: is_view_all_org VARCHAR2(1);
347:
348: BEGIN
349: --

Line 373: -- the business group id is populated per_security_profiles.

369: -- security profile. The HR table per_organization_list is not
370: -- populated for view all or global view all organizations.
371: --
372: -- For a view all security profile within a business group,
373: -- the business group id is populated per_security_profiles.
374: --
375: SELECT security_profile_name
376: , business_group_id
377: , view_all_organizations_flag

Line 381: FROM per_security_profiles

377: , view_all_organizations_flag
378: INTO l_sp_name
379: , l_bg_id
380: , is_view_all_org
381: FROM per_security_profiles
382: WHERE security_profile_id = to_number(l_security_profile_id);
383:
384: IF (is_view_all_org = 'Y') THEN
385: IF (l_bg_id IS NOT NULL) THEN