APPS.FND_SESSION_MANAGEMENT dependencies on FND_USER

Line 262: FROM fnd_user

258:
259: BEGIN
260: SELECT user_name
261: INTO l_user_name
262: FROM fnd_user
263: WHERE user_id=l_user_id;
264: EXCEPTION
265: WHEN OTHERS THEN
266: WF_CORE.CONTEXT('fnd_session_management', 'doNewSessionEvent',p_evtMsg.getEventName( ), p_guid);

Line 472: FROM fnd_user

468: l_guest_username := UPPER(SUBSTR(l_guest_username,1,INSTR(l_guest_username,'/') -1));
469: BEGIN
470: SELECT user_id
471: INTO l_guest_user_id
472: FROM fnd_user
473: WHERE user_name = l_guest_username;
474: EXCEPTION
475: WHEN no_data_found THEN
476: l_guest_user_id := -999;

Line 698: select user_id into l_user_id from fnd_user

694: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , l_module, 'BEGIN');
695: end if;
696: -- check if user exists
697: begin
698: select user_id into l_user_id from fnd_user
699: where user_id = p_user_id and
700: (start_date <= sysdate) and
701: (end_date is null or end_date>sysdate);
702: exception

Line 744: FROM fnd_user

740: l_guest_username := UPPER(SUBSTR(l_guest_username,1,INSTR(l_guest_username,'/') -1));
741: BEGIN
742: SELECT user_id
743: INTO l_guest_user_id
744: FROM fnd_user
745: WHERE user_name = l_guest_username;
746: EXCEPTION
747: WHEN no_data_found THEN
748: l_guest_user_id := -999;

Line 1625: fnd_user b

1621: then
1622: select b.USER_NAME
1623: into n_id
1624: from icx_sessions a,
1625: fnd_user b
1626: where b.user_id = a.user_id
1627: and a.session_id = p_session_id;
1628:
1629: elsif n_param = PV_USER_ID --** WEB USER ID (10) **

Line 2331: select user_guid into l_user_guid from fnd_user where user_id = l_user_id;

2327: l_user_id := p_user_id;
2328: end if;
2329:
2330: if (l_user_id is not null) then
2331: select user_guid into l_user_guid from fnd_user where user_id = l_user_id;
2332:
2333: if (l_user_guid is not null) then
2334: -- Could have an SSO session - if so disable if profile is set to limit
2335: fnd_profile.get_specific(name_z => 'APPS_SSO_LIMIT_SESSIONS',