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 373: FROM icx_sessions

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

Line 406: UPDATE icx_sessions

402: IF l_session_status <> 'INVALID' and l_user_id <> l_anon_id and c_user_id = l_user_id THEN
403: -- Reuse expired session
404: -- Session Hijacking. Reset xsid whenever session is reset
405: l_new_xsid := fnd_session_management.NewXSID;
406: UPDATE icx_sessions
407: SET last_connect = sysdate,
408: first_connect = SYSDATE,
409: counter = 1,
410: xsid = l_new_xsid

Line 436: UPDATE icx_sessions

432:
433: --preserve the existing session durring switch from anon user.
434: -- Session Hijacking. Reset xsid whenever session is upgraded from GUEST to user
435: l_new_xsid := fnd_session_management.NewXSID;
436: UPDATE icx_sessions
437: SET user_id = l_user_id,
438: nls_language = l_language,
439: language_code = l_language_code,
440: date_format_mask = l_date_format,

Line 736: update ICX_SESSIONS

732:
733:
734: -- 2646577, nvl(l_language,NLS_LANGUAGE)
735:
736: update ICX_SESSIONS
737: set RESPONSIBILITY_APPLICATION_ID = l_resp_appl_id,
738: RESPONSIBILITY_ID = l_responsibility_id,
739: SECURITY_GROUP_ID = l_security_group_id,
740: ORG_ID = l_org_id,

Line 889: ICX_SESSIONS i

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

Line 962: update ICX_SESSIONS

958: application_id_z => l_resp_appl_id,
959: val_z => l_org_id,
960: defined_z => l_profile_defined);
961: end if;
962: update ICX_SESSIONS
963: set RESPONSIBILITY_APPLICATION_ID = l_resp_appl_id,
964: RESPONSIBILITY_ID = l_responsibility_id,
965: SECURITY_GROUP_ID = l_security_group_id,
966: ORG_ID = l_org_id,

Line 1033: update ICX_SESSIONS

1029: application_id_z => l_resp_appl_id,
1030: val_z => l_org_id,
1031: defined_z => l_profile_defined);
1032: end if;
1033: update ICX_SESSIONS
1034: set RESPONSIBILITY_APPLICATION_ID = l_resp_appl_id,
1035: RESPONSIBILITY_ID = l_responsibility_id,
1036: SECURITY_GROUP_ID = l_security_group_id,
1037: ORG_ID = l_org_id,