APPS.APP_SESSION dependencies on FND_USER

Line 128: fnd_user fu

124: fu.user_id
125: into l_user_guid,
126: l_user_id
127: from icx_sessions ses,
128: fnd_user fu
129: where ses.user_id = fu.user_id
130: and ses.session_id = l_session_id;
131:
132: if(l_user_guid = p_sso_guid) then

Line 138: fnd_user_resp_groups_api.validate_security_context(

134:
135: if(l_responsibility_id is not null) then
136: -- validate the security context
137:
138: fnd_user_resp_groups_api.validate_security_context(
139: p_user_id => l_user_id,
140: p_resp_appl_id => l_resp_appl_id,
141: p_responsibility_id => l_responsibility_id,
142: p_security_group_id => l_security_group_id,

Line 206: fnd_user_resp_groups_api.validate_security_context(

202:
203: if(l_responsibility_id is not null) then
204: -- validate the security context
205:
206: fnd_user_resp_groups_api.validate_security_context(
207: p_user_id => l_user_id,
208: p_resp_appl_id => l_resp_appl_id,
209: p_responsibility_id => l_responsibility_id,
210: p_security_group_id => l_security_group_id,

Line 325: -- Return a list of all FND users linked to an SSO guid

321: end Validate_Icx_Session;
322:
323: --
324: -- Get_All_Linked_Users
325: -- Return a list of all FND users linked to an SSO guid
326: -- IN
327: -- p_sso_guid - the user's SSO guid (required)
328: -- RETURNS
329: -- An array of users linked to this guid

Line 346: cursor guid_users(l_sso_guid in fnd_user.user_guid%TYPE) is

342: -- Default_user needs to be calculated using preferences.
343: --
344: -- Bug 5556799 - added user_guid TYPE to cursor as per recommendation
345: -- of ATG Perf Team (AAlomari), to bind with RAW index in GSI DB
346: cursor guid_users(l_sso_guid in fnd_user.user_guid%TYPE) is
347: select fu.user_id, fu.user_name, 'N'
348: from fnd_user fu
349: where fu.user_guid = l_sso_guid
350: order by user_id;

Line 348: from fnd_user fu

344: -- Bug 5556799 - added user_guid TYPE to cursor as per recommendation
345: -- of ATG Perf Team (AAlomari), to bind with RAW index in GSI DB
346: cursor guid_users(l_sso_guid in fnd_user.user_guid%TYPE) is
347: select fu.user_id, fu.user_name, 'N'
348: from fnd_user fu
349: where fu.user_guid = l_sso_guid
350: order by user_id;
351:
352: begin

Line 385: -- Get the default FND user linked to an SSO guid

381: end Get_All_Linked_Users;
382:
383: --
384: -- Get_Default_User
385: -- Get the default FND user linked to an SSO guid
386: -- IN
387: -- p_sso_guid - the user's SSO guid (required)
388: -- RETURNS
389: -- A record for default user linked to this guid