APPS.ORACLESSWA dependencies on ICX_SESSIONS

Line 87: update ICX_SESSIONS

83: val_z => l_org_id,
84: defined_z => l_profile_defined);
85: end if;
86:
87: update ICX_SESSIONS
88: set RESPONSIBILITY_APPLICATION_ID = l_resp_appl_id,
89: RESPONSIBILITY_ID = l_responsibility_id,
90: SECURITY_GROUP_ID = l_security_group_id,
91: ORG_ID = l_org_id,

Line 164: from icx_sessions

160:
161: -- Get the current user's user_id
162: select user_id
163: into l_user_id
164: from icx_sessions
165: where session_id = l_session_id;
166:
167: -- Update the caching key for every 'Current responsibility
168: -- pages' portlet belonging to the current user

Line 371: FROM icx_sessions

367: l_session_status := icx_sec.check_session(l_session_id); -- check to see if cookie is for valid session
368: BEGIN
369: SELECT user_id
370: INTO c_user_id
371: FROM icx_sessions
372: WHERE session_id=l_session_id; -- use cookie value to get user_id, defaults to -999 if bogus cookie/user_id.
373: EXCEPTION
374: WHEN no_data_found THEN
375: c_user_id := -999;

Line 402: UPDATE icx_sessions

398: --test to see if we are switching from an anonymous session to authenticated session
399: -- if it is a valid session, and the users are difference, and the original user is the anonymous user then
400: IF l_session_status <> 'INVALID' and l_user_id <> l_anon_id and c_user_id = l_user_id THEN
401: -- Reuse expired session
402: UPDATE icx_sessions
403: SET last_connect = sysdate,
404: first_connect = SYSDATE,
405: counter = 1
406: WHERE session_id = l_session_id;

Line 427: UPDATE icx_sessions

423: l_org_id,
424: l_timeout);
425:
426: --preserve the existing session durring switch from anon user.
427: UPDATE icx_sessions
428: SET user_id = l_user_id,
429: nls_language = l_language,
430: language_code = l_language_code,
431: date_format_mask = l_date_format,

Line 724: update ICX_SESSIONS

720:
721:
722: -- 2646577, nvl(l_language,NLS_LANGUAGE)
723:
724: update ICX_SESSIONS
725: set RESPONSIBILITY_APPLICATION_ID = l_resp_appl_id,
726: RESPONSIBILITY_ID = l_responsibility_id,
727: SECURITY_GROUP_ID = l_security_group_id,
728: ORG_ID = l_org_id,

Line 877: ICX_SESSIONS i

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:
881: l_recreate_code := icx_call.encrypt(l_session_id||'*'||l_user_name||'**]');

Line 950: update ICX_SESSIONS

946: application_id_z => l_resp_appl_id,
947: val_z => l_org_id,
948: defined_z => l_profile_defined);
949: end if;
950: update ICX_SESSIONS
951: set RESPONSIBILITY_APPLICATION_ID = l_resp_appl_id,
952: RESPONSIBILITY_ID = l_responsibility_id,
953: SECURITY_GROUP_ID = l_security_group_id,
954: ORG_ID = l_org_id,

Line 1021: update ICX_SESSIONS

1017: application_id_z => l_resp_appl_id,
1018: val_z => l_org_id,
1019: defined_z => l_profile_defined);
1020: end if;
1021: update ICX_SESSIONS
1022: set RESPONSIBILITY_APPLICATION_ID = l_resp_appl_id,
1023: RESPONSIBILITY_ID = l_responsibility_id,
1024: SECURITY_GROUP_ID = l_security_group_id,
1025: ORG_ID = l_org_id,