DBA Data[Home] [Help]

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 362: from fnd_user

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

Line 389: FROM fnd_user

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

Line 762: from fnd_user

758: --l_guest_pwd := SUBSTR(l_guest_profile_value, INSTR(l_guest_profile_value, '/') + 1);
759: l_guest_name := upper(l_guest_name);
760: SELECT user_id
761: into l_user_id
762: from fnd_user
763: where user_name = l_guest_name;
764:
765: --create anonymous session
766:

Line 888: from FND_USER fu,

884: icx_sec.g_prog_appl_id := -1;
885:
886: select USER_NAME
887: into l_user_name
888: from FND_USER fu,
889: ICX_SESSIONS i
890: where i.SESSION_ID = l_session_id
891: and i.USER_ID = fu.USER_ID;
892:

Line 921: from fnd_user

917: --l_guest_pwd := SUBSTR(l_guest_profile_value, INSTR(l_guest_profile_value, '/') + 1);
918: l_guest_name := upper(l_guest_name);
919: SELECT user_id
920: into l_user_id
921: from fnd_user
922: where user_name = l_guest_name;
923:
924: --create anonymous session
925:

Line 993: from fnd_user

989: --l_guest_pwd := SUBSTR(l_guest_profile_value, INSTR(l_guest_profile_value, '/') + 1);
990: l_guest_name := upper(l_guest_name);
991: SELECT user_id
992: into l_user_id
993: from fnd_user
994: where user_name = l_guest_name;
995: ----
996: l_session_id:=icx_sec.getsessioncookie;
997: IF ((l_user_id <> icx_sec.g_user_id) OR (icx_sec.check_session(icx_sec.getsessioncookie) = 'INVALID')) THEN