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.

[Home] [Help]

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 48: select 'Y' into x_XSID from icx_sessions

44: l_XSID := fnd_crypto.encode(fnd_crypto.RandomBytes(18),fnd_crypto.ENCODE_URL);
45:
46: loop
47:
48: select 'Y' into x_XSID from icx_sessions
49: where XSID = l_XSID;
50:
51: if x_XSID = 'Y'
52: then

Line 260: UPDATE icx_sessions

256:
257: IF (instrb((nvl(l_except_ids,' ')),l_user_name) = 0)
258: THEN
259: BEGIN
260: UPDATE icx_sessions
261: SET disabled_flag='Y'
262: WHERE user_id = l_user_id
263: AND session_id <> l_session_id;
264: COMMIT;

Line 457: insert into icx_sessions (

453: l_enc_key := fnd_crypto.RandomBytes(32);
454: l_mac_key := fnd_crypto.RandomBytes(20);
455: end if;
456:
457: insert into icx_sessions (
458: session_id,
459: user_id,
460: org_id,
461: security_group_id,

Line 671: from icx_sessions

667: -- check if it is guest session
668: begin
669: select session_id,guest, mode_code, time_out, responsibility_application_id, responsibility_id, login_id
670: into l_session_id,l_guest, l_mode_code, l_curr_timeout, l_resp_app_id, l_resp_id, l_from_login_id
671: from icx_sessions
672: where xsid = p_session_id;
673: exception
674: when no_data_found then
675: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 783: update icx_sessions set (

779: l_login_id);
780:
781: get_fixed_sec_keys(p_user_id, l_mac_key, l_enc_key);
782:
783: update icx_sessions set (
784: user_id,
785: mode_code,
786: org_id,
787: security_group_id,

Line 944: select node_id into c_node_id from icx_sessions

940: begin
941:
942: if p_node_id is null
943: then
944: select node_id into c_node_id from icx_sessions
945: where session_id = g_session_id;
946: else
947: c_node_id := p_node_id;
948: end if;

Line 1081: from ICX_SESSIONS

1077: fnd_session_management.g_node_id,
1078: fnd_session_management.g_mac_key,
1079: fnd_session_management.g_enc_key,
1080: fnd_session_management.g_proxy_user_id
1081: from ICX_SESSIONS
1082: where SESSION_ID = p_session_id;
1083:
1084: if fnd_session_management.g_language_code is null
1085: then

Line 1298: update icx_sessions

1294:
1295:
1296: /* Bug 3634632 removed commit - call validateSession_pragma now.
1297:
1298: update icx_sessions
1299: set last_connect = sysdate,
1300: counter = counter + 1
1301: where session_id = fnd_session_management.g_session_id;
1302:

Line 1355: update icx_sessions

1351: PRAGMA AUTONOMOUS_TRANSACTION; -- mputman added for 2233089
1352:
1353: begin
1354:
1355: update icx_sessions
1356: set last_connect = sysdate
1357: where session_id = p_session_id;
1358: commit;
1359:

Line 1368: update icx_sessions

1364: is
1365:
1366: begin
1367:
1368: update icx_sessions
1369: set last_connect = sysdate
1370: where session_id = p_session_id;
1371: commit;
1372:

Line 1381: update icx_sessions

1377: is
1378: PRAGMA AUTONOMOUS_TRANSACTION;
1379: begin
1380:
1381: update icx_sessions
1382: set last_connect = sysdate,
1383: counter = counter + 1
1384: where session_id = p_session_id;
1385: commit;

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

1395: pragma autonomous_transaction;
1396:
1397: begin
1398:
1399: update icx_sessions set time_out = l_timeout where session_id = p_session_id;
1400: commit;
1401:
1402: end Session_update_timeout_pvt;
1403:

Line 1453: from ICX_SESSIONS

1449: c_disabled_flag,
1450: l_last_connect, l_user_id,
1451: l_resp_id, l_app_resp_id,
1452: l_session_timeout, l_guest, l_dist
1453: from ICX_SESSIONS
1454: where SESSION_ID = p_session_id;
1455:
1456: exception
1457: when no_data_found

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

1505: -- values for p_resp_id and p_app_resp_id
1506: -- Then, if passed p_resp_id and p_app_resp_id the ICX_SESSION_TIMEOUT
1507: -- value returned will the one defined for the USER or for the SITE
1508: -- Calling fnd_profile.get_specific with the resp_id and app_resp_id
1509: -- taken from ICX_SESSIONS given the session_id.
1510: -- AMGONZAL
1511: l_profile_defined := false;
1512: fnd_profile.get_specific(
1513: name_z => 'ICX_SESSION_TIMEOUT',

Line 1576: from icx_sessions a,

1572: elsif n_param = PV_USER_NAME --** USERNAME (99) **
1573: then
1574: select b.USER_NAME
1575: into n_id
1576: from icx_sessions a,
1577: fnd_user b
1578: where b.user_id = a.user_id
1579: and a.session_id = p_session_id;
1580:

Line 1806: from icx_sessions

1802: --
1803: Begin
1804: Select user_id, time_out
1805: into l_user_id, l_prev_timeout
1806: from icx_sessions
1807: where session_id = p_session_id;
1808:
1809:
1810: fnd_profile.get_specific(

Line 1836: update ICX_SESSIONS

1832: l_timeout := l_prev_timeout;
1833: end if;
1834: End;
1835:
1836: update ICX_SESSIONS
1837: set RESPONSIBILITY_APPLICATION_ID = p_application_id,
1838: RESPONSIBILITY_ID = p_responsibility_id,
1839: SECURITY_GROUP_ID = p_security_group_id,
1840: ORG_ID = l_org_id,

Line 1847: -- rollback will undo icx_sessions update

1843: time_out = l_timeout
1844: where SESSION_ID = p_session_id;
1845:
1846: -- Bug 6032403 : In case next SQL stmt gaves error a
1847: -- rollback will undo icx_sessions update
1848: commit;
1849:
1850: if p_transaction_id is not null
1851: then

Line 1902: UPDATE icx_sessions

1898: p_territory IN VARCHAR2) IS
1899:
1900: BEGIN
1901:
1902: UPDATE icx_sessions
1903: SET
1904: NLS_LANGUAGE=p_language,
1905: DATE_FORMAT_MASK=p_date_format_mask,
1906: LANGUAGE_CODE=p_language_code,

Line 1921: UPDATE icx_sessions

1917: procedure reset_session(p_session_id in number) is
1918:
1919: begin
1920:
1921: UPDATE icx_sessions
1922: SET disabled_flag='N',
1923: last_connect=SYSDATE,
1924: counter=0,
1925: first_connect=SYSDATE

Line 1957: UPDATE icx_sessions

1953: IS
1954:
1955: BEGIN
1956:
1957: UPDATE icx_sessions
1958: SET disabled_flag='Y'
1959: WHERE
1960: (((SYSDATE-first_connect)*24*60)> threshold);
1961:

Line 1978: from ICX_SESSIONS

1974: begin
1975:
1976: --added for 4230606
1977: select login_id into l_login_id
1978: from ICX_SESSIONS
1979: where SESSION_ID = c_session_id;
1980:
1981: l_audit_level:=fnd_profile.value('SIGNONAUDIT:LEVEL');
1982: if (l_audit_level is not null) and ( l_login_id is not null)

Line 1989: update icx_sessions

1985: end if;
1986: --end changes for 4230606
1987:
1988: if c_user_id is null then
1989: update icx_sessions
1990: set disabled_flag = 'Y'
1991: where session_id = c_session_id;
1992: elsif c_user_id is not null then
1993: update icx_sessions

Line 1993: update icx_sessions

1989: update icx_sessions
1990: set disabled_flag = 'Y'
1991: where session_id = c_session_id;
1992: elsif c_user_id is not null then
1993: update icx_sessions
1994: set disabled_flag = 'Y'
1995: where session_id = c_session_id
1996: and user_id = c_user_id;
1997: end if;

Line 2216: select proxy_user_id into user_id from icx_sessions where

2212: else
2213: return fnd_session_management.g_proxy_user_id;
2214: end if;
2215: end if;
2216: select proxy_user_id into user_id from icx_sessions where
2217: session_id = p_session_id;
2218: return user_id;
2219: exception
2220: when no_data_found then