eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_SESSION_MANAGEMENT dependencies on ICX_SESSIONS

Line 19: select 'Y' into x_session_id from icx_sessions

15: l_session_id := fnd_crypto.SmallRandomNumber;
16:
17: loop
18:
19: select 'Y' into x_session_id from icx_sessions
20: where session_id = l_session_id;
21:
22: if x_session_id = 'Y'
23: then

Line 53: select 'Y' into x_XSID from icx_sessions

49: msk=> FND_CRYPTO_CONSTANTS.ALPHANUMERIC_MASK);
50:
51: loop
52:
53: select 'Y' into x_XSID from icx_sessions
54: where XSID = l_XSID;
55:
56: if x_XSID = 'Y'
57: then

Line 243: from ICX_SESSIONS

239: l_audit_level VARCHAR2(1);
240:
241: cursor c_end_date_fndlogins is
242: SELECT login_id
243: from ICX_SESSIONS
244: where user_id = l_user_id
245: and session_id <> l_session_id
246: and disabled_flag = 'N'
247: and mode_code = '115P'

Line 298: UPDATE icx_sessions

294: END LOOP;
295: END IF;
296:
297:
298: UPDATE icx_sessions
299: SET disabled_flag='Y'
300: WHERE user_id = l_user_id
301: AND session_id <> l_session_id
302: AND mode_code = '115P';

Line 498: insert into icx_sessions (

494: l_enc_key := fnd_crypto.RandomBytes(32);
495: l_mac_key := fnd_crypto.RandomBytes(20);
496: end if;
497:
498: insert into icx_sessions (
499: session_id,
500: user_id,
501: org_id,
502: security_group_id,

Line 714: from icx_sessions

710: -- check if it is guest session
711: begin
712: select session_id,guest, mode_code, time_out, responsibility_application_id, responsibility_id, login_id
713: into l_session_id,l_guest, l_mode_code, l_curr_timeout, l_resp_app_id, l_resp_id, l_from_login_id
714: from icx_sessions
715: where xsid = p_session_id;
716: exception
717: when no_data_found then
718: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 828: update icx_sessions set (

824: get_fixed_sec_keys(p_user_id, l_mac_key, l_enc_key);
825:
826: -- Session Hijacking fix.
827: l_XSID := NewXSID;
828: update icx_sessions set (
829: user_id,
830: mode_code,
831: org_id,
832: security_group_id,

Line 992: select node_id into c_node_id from icx_sessions

988: begin
989:
990: if p_node_id is null
991: then
992: select node_id into c_node_id from icx_sessions
993: where session_id = g_session_id;
994: else
995: c_node_id := p_node_id;
996: end if;

Line 1129: from ICX_SESSIONS

1125: fnd_session_management.g_node_id,
1126: fnd_session_management.g_mac_key,
1127: fnd_session_management.g_enc_key,
1128: fnd_session_management.g_proxy_user_id
1129: from ICX_SESSIONS
1130: where SESSION_ID = p_session_id;
1131:
1132: if fnd_session_management.g_language_code is null
1133: then

Line 1346: update icx_sessions

1342:
1343:
1344: /* Bug 3634632 removed commit - call validateSession_pragma now.
1345:
1346: update icx_sessions
1347: set last_connect = sysdate,
1348: counter = counter + 1
1349: where session_id = fnd_session_management.g_session_id;
1350:

Line 1403: update icx_sessions

1399: PRAGMA AUTONOMOUS_TRANSACTION; -- mputman added for 2233089
1400:
1401: begin
1402:
1403: update icx_sessions
1404: set last_connect = sysdate
1405: where session_id = p_session_id;
1406: commit;
1407:

Line 1416: update icx_sessions

1412: is
1413:
1414: begin
1415:
1416: update icx_sessions
1417: set last_connect = sysdate
1418: where session_id = p_session_id;
1419: commit;
1420:

Line 1429: update icx_sessions

1425: is
1426: PRAGMA AUTONOMOUS_TRANSACTION;
1427: begin
1428:
1429: update icx_sessions
1430: set last_connect = sysdate,
1431: counter = counter + 1
1432: where session_id = p_session_id;
1433: commit;

Line 1447: update icx_sessions set time_out = l_timeout where session_id = p_session_id;

1443: pragma autonomous_transaction;
1444:
1445: begin
1446:
1447: update icx_sessions set time_out = l_timeout where session_id = p_session_id;
1448: commit;
1449:
1450: end Session_update_timeout_pvt;
1451:

Line 1501: from ICX_SESSIONS

1497: c_disabled_flag,
1498: l_last_connect, l_user_id,
1499: l_resp_id, l_app_resp_id,
1500: l_session_timeout, l_guest, l_dist
1501: from ICX_SESSIONS
1502: where SESSION_ID = p_session_id;
1503:
1504: exception
1505: when no_data_found

Line 1557: -- taken from ICX_SESSIONS given the session_id.

1553: -- values for p_resp_id and p_app_resp_id
1554: -- Then, if passed p_resp_id and p_app_resp_id the ICX_SESSION_TIMEOUT
1555: -- value returned will the one defined for the USER or for the SITE
1556: -- Calling fnd_profile.get_specific with the resp_id and app_resp_id
1557: -- taken from ICX_SESSIONS given the session_id.
1558: -- AMGONZAL
1559: l_profile_defined := false;
1560: fnd_profile.get_specific(
1561: name_z => 'ICX_SESSION_TIMEOUT',

Line 1624: from icx_sessions a,

1620: elsif n_param = PV_USER_NAME --** USERNAME (99) **
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:

Line 1854: from icx_sessions

1850: --
1851: Begin
1852: Select user_id, time_out
1853: into l_user_id, l_prev_timeout
1854: from icx_sessions
1855: where session_id = p_session_id;
1856:
1857:
1858: fnd_profile.get_specific(

Line 1884: update ICX_SESSIONS

1880: l_timeout := l_prev_timeout;
1881: end if;
1882: End;
1883:
1884: update ICX_SESSIONS
1885: set RESPONSIBILITY_APPLICATION_ID = p_application_id,
1886: RESPONSIBILITY_ID = p_responsibility_id,
1887: SECURITY_GROUP_ID = p_security_group_id,
1888: ORG_ID = l_org_id,

Line 1895: -- rollback will undo icx_sessions update

1891: time_out = l_timeout
1892: where SESSION_ID = p_session_id;
1893:
1894: -- Bug 6032403 : In case next SQL stmt gaves error a
1895: -- rollback will undo icx_sessions update
1896: commit;
1897:
1898: if p_transaction_id is not null
1899: then

Line 1950: UPDATE icx_sessions

1946: p_territory IN VARCHAR2) IS
1947:
1948: BEGIN
1949:
1950: UPDATE icx_sessions
1951: SET
1952: NLS_LANGUAGE=p_language,
1953: DATE_FORMAT_MASK=p_date_format_mask,
1954: LANGUAGE_CODE=p_language_code,

Line 1972: UPDATE icx_sessions

1968:
1969: -- Session Hijacking fix.
1970: l_XSID := NewXSID;
1971:
1972: UPDATE icx_sessions
1973: SET disabled_flag='N',
1974: last_connect=SYSDATE,
1975: counter=0,
1976: first_connect=SYSDATE,

Line 2009: UPDATE icx_sessions

2005: IS
2006:
2007: BEGIN
2008:
2009: UPDATE icx_sessions
2010: SET disabled_flag='Y'
2011: WHERE
2012: (((SYSDATE-first_connect)*24*60)> threshold);
2013:

Line 2030: from ICX_SESSIONS

2026: begin
2027:
2028: --added for 4230606
2029: select login_id into l_login_id
2030: from ICX_SESSIONS
2031: where SESSION_ID = c_session_id;
2032:
2033: l_audit_level:=fnd_profile.value('SIGNONAUDIT:LEVEL');
2034: if (l_audit_level is not null) and ( l_login_id is not null)

Line 2041: update icx_sessions

2037: end if;
2038: --end changes for 4230606
2039:
2040: if c_user_id is null then
2041: update icx_sessions
2042: set disabled_flag = 'Y'
2043: where session_id = c_session_id;
2044: elsif c_user_id is not null then
2045: update icx_sessions

Line 2045: update icx_sessions

2041: update icx_sessions
2042: set disabled_flag = 'Y'
2043: where session_id = c_session_id;
2044: elsif c_user_id is not null then
2045: update icx_sessions
2046: set disabled_flag = 'Y'
2047: where session_id = c_session_id
2048: and user_id = c_user_id;
2049: end if;

Line 2268: select proxy_user_id into user_id from icx_sessions where

2264: else
2265: return fnd_session_management.g_proxy_user_id;
2266: end if;
2267: end if;
2268: select proxy_user_id into user_id from icx_sessions where
2269: session_id = p_session_id;
2270: return user_id;
2271: exception
2272: when no_data_found then

Line 2314: from icx_sessions

2310: end if;
2311:
2312: select user_id, time_out
2313: into l_user_id, l_session_timeout
2314: from icx_sessions
2315: where session_id = p_session_id;
2316:
2317: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
2318: then

Line 2354: UPDATE icx_sessions

2350: then
2351: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Limiting SSO user session. Disable all but session id '||to_char(p_session_id));
2352: end if;
2353:
2354: UPDATE icx_sessions
2355: SET last_connect=sysdate-2 -- May need to adjust this value
2356: WHERE mode_code = '115J'
2357: AND session_id <> p_session_id
2358: AND user_id = l_user_id