DBA Data[Home] [Help]

APPS.HR_GENERAL dependencies on FND_GLOBAL

Line 218: rnemani 06-OCT-2008 120.3.12000000.2 New predicate "fnd_global.per_security_profile_id =-1" is

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:

Line 450: if ( fnd_global.user_id = -1 ) then

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;

Line 2160: -- Using fnd_global.per_security_profile_id for performance

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.

Line 2166: if ( fnd_global.user_id = -1

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' ;

Line 2167: or fnd_global.per_security_profile_id is null

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

Line 2168: or fnd_global.per_security_profile_id = -1 )

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') );