214: ========================================================================================
215: svittal 30-SEP-2005 120.1 Global Name Format from R12
216: changed decode_person_name
217: -------------------------------------------------------------------------------
218: rnemani 06-OCT-2008 120.3.12000000.2 New predicate "fnd_global.per_security_profile_id =-1" is
219: added to function get_xbg_profile'.
220: ------------------------------------------------------------------------------------------------
221: DO NOT ADD ANY FUTHER PROCEDURES / FUNCTIONS TO THIS FILE!
222:
446: -- the Setup Business group.
447: --
448: begin
449:
450: if ( fnd_global.user_id = -1 ) then
451: return(null);
452: else
453: return(fnd_profile.value('PER_BUSINESS_GROUP_ID'));
454: end if;
2156:
2157: --
2158: -- bug2372279
2159: --
2160: -- Using fnd_global.per_security_profile_id for performance
2161: -- reasons. hr_security.get_security_profile should probably
2162: -- be used as it looks like reporting users are getting an
2163: -- unrestricted bg view but will address this later as a
2164: -- separate pre-existing issue.
2162: -- be used as it looks like reporting users are getting an
2163: -- unrestricted bg view but will address this later as a
2164: -- separate pre-existing issue.
2165: --
2166: if ( fnd_global.user_id = -1
2167: or fnd_global.per_security_profile_id is null
2168: or fnd_global.per_security_profile_id = -1 )
2169: then
2170: return 'Y' ;
2163: -- unrestricted bg view but will address this later as a
2164: -- separate pre-existing issue.
2165: --
2166: if ( fnd_global.user_id = -1
2167: or fnd_global.per_security_profile_id is null
2168: or fnd_global.per_security_profile_id = -1 )
2169: then
2170: return 'Y' ;
2171: else
2164: -- separate pre-existing issue.
2165: --
2166: if ( fnd_global.user_id = -1
2167: or fnd_global.per_security_profile_id is null
2168: or fnd_global.per_security_profile_id = -1 )
2169: then
2170: return 'Y' ;
2171: else
2172: return( fnd_profile.value('HR_CROSS_BUSINESS_GROUP') );