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 345: from fnd_user fu

341: -- Default 'N' as a placeholder for default_user flag in the fetch.
342: -- Default_user needs to be calculated using preferences.
343: cursor guid_users(l_sso_guid in varchar2) is
344: select fu.user_id, fu.user_name, 'N'
345: from fnd_user fu
346: where fu.user_guid = l_sso_guid
347: order by user_id;
348:
349: begin

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

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