APPS.ORACLESSWA dependencies on FND_USER

Line 253: u fnd_user%rowtype;

249: l_sso_time_remaining VARCHAR2(1000);
250: l_site_time_stamp VARCHAR2(1000);
251: l_url_requested VARCHAR2(32000);
252: l_unused_param VARCHAR2(1000);
253: u fnd_user%rowtype;
254: l_user_id number;
255: l_session_id number;
256: l_return VARCHAR2(240);
257: l_session_status VARCHAR2(10);

Line 360: from fnd_user

356: -- Bug 3801219
357: -- Bug 4151179 : remove those extra parentesis
358: select user_id
359: into l_user_id
360: from fnd_user
361: where user_name = l_sso_user_name
362: and (END_DATE is NULL or END_DATE > sysdate);
363:
364:

Line 387: FROM fnd_user

383: l_anon_name := SUBSTR(l_anon_name, 1, INSTR(l_anon_name, '/') -1); -- profile is stored as user/passwd
384: BEGIN
385: SELECT user_id
386: INTO l_anon_id
387: FROM fnd_user
388: WHERE user_name=l_anon_name;
389: EXCEPTION
390: WHEN OTHERS THEN
391: l_anon_id := -999;

Line 750: from fnd_user

746: --l_guest_pwd := SUBSTR(l_guest_profile_value, INSTR(l_guest_profile_value, '/') + 1);
747: l_guest_name := upper(l_guest_name);
748: SELECT user_id
749: into l_user_id
750: from fnd_user
751: where user_name = l_guest_name;
752:
753: --create anonymous session
754:

Line 876: from FND_USER fu,

872: icx_sec.g_prog_appl_id := -1;
873:
874: select USER_NAME
875: into l_user_name
876: from FND_USER fu,
877: ICX_SESSIONS i
878: where i.SESSION_ID = l_session_id
879: and i.USER_ID = fu.USER_ID;
880:

Line 909: from fnd_user

905: --l_guest_pwd := SUBSTR(l_guest_profile_value, INSTR(l_guest_profile_value, '/') + 1);
906: l_guest_name := upper(l_guest_name);
907: SELECT user_id
908: into l_user_id
909: from fnd_user
910: where user_name = l_guest_name;
911:
912: --create anonymous session
913:

Line 981: from fnd_user

977: --l_guest_pwd := SUBSTR(l_guest_profile_value, INSTR(l_guest_profile_value, '/') + 1);
978: l_guest_name := upper(l_guest_name);
979: SELECT user_id
980: into l_user_id
981: from fnd_user
982: where user_name = l_guest_name;
983: ----
984: l_session_id:=icx_sec.getsessioncookie;
985: IF ((l_user_id <> icx_sec.g_user_id) OR (icx_sec.check_session(icx_sec.getsessioncookie) = 'INVALID')) THEN