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.ICX_SEC dependencies on ICX_SESSIONS

Line 21: select 'Y' into x_session_id from icx_sessions

17: l_session_id := abs(dbms_random.random);
18:
19: loop
20:
21: select 'Y' into x_session_id from icx_sessions
22: where session_id = l_session_id;
23:
24: if x_session_id = 'Y'
25: then

Line 57: --select icx_sessions_s.nextval

53: --l_new_session_id number;
54:
55: --begin
56:
57: --select icx_sessions_s.nextval
58: -- into l_session_id
59: -- from sys.dual;
60:
61: -- l_random_num := Random1('X');

Line 693: insert into icx_sessions (

689: defined_z => l_profile_defined);
690:
691:
692:
693: insert into icx_sessions (
694: session_id,
695: user_id,
696: org_id,
697: security_group_id,

Line 1200: update ICX_SESSIONS

1196: val_z => l_org_id,
1197: defined_z => l_profile_defined);
1198: end if;
1199:
1200: update ICX_SESSIONS
1201: set RESPONSIBILITY_APPLICATION_ID = l_resp_appl_id,
1202: RESPONSIBILITY_ID = l_responsibility_id,
1203: SECURITY_GROUP_ID = l_security_group_id,
1204: ORG_ID = l_org_id,

Line 1274: from ICX_SESSIONS

1270: icx_sec.g_user_id,
1271: icx_sec.g_resp_appl_id,
1272: icx_sec.g_security_group_id,
1273: icx_sec.g_responsibility_id
1274: from ICX_SESSIONS
1275: where SESSION_ID = p_session_id;
1276:
1277: setSessionPrivate(icx_sec.g_user_id,
1278: icx_sec.g_responsibility_id,

Line 1328: select node_id into c_node_id from icx_sessions

1324: */
1325:
1326: begin
1327:
1328: select node_id into c_node_id from icx_sessions
1329: where user_id = p_user_id and session_id = g_session_id;
1330:
1331: -- changed call to fnd_global.initialize to pass login_id 2020952
1332: -- Bug 2864081

Line 1572: from ICX_SESSIONS

1568: c_org_id, icx_sec.g_mode_code,
1569: l_last_connect,
1570: icx_sec.g_login_id --mputman added 2020952
1571:
1572: from ICX_SESSIONS
1573: where SESSION_ID = icx_sec.g_session_id;
1574:
1575: if c_transaction_id is not null
1576: then

Line 1796: update icx_sessions

1792: end if;
1793:
1794: if c_update
1795: then
1796: update icx_sessions
1797: set last_connect = sysdate,
1798: counter = counter + 1
1799: where session_id = icx_sec.g_session_id;
1800:

Line 1825: update icx_sessions

1821: c_error_msg := dbms_utility.format_error_stack;
1822:
1823: if g_session_id is not null
1824: then
1825: update icx_sessions
1826: set disabled_flag = 'Y'
1827: where session_id = g_session_id;
1828: COMMIT; -- mputman added 1574527
1829: end if;

Line 2026: update icx_sessions

2022: -- c_login_msg := fnd_message.get;
2023:
2024: if g_session_id is not null
2025: then
2026: update icx_sessions
2027: set disabled_flag = 'Y'
2028: where session_id = g_session_id;
2029: COMMIT; -- mputman added 1574527
2030: end if;

Line 2052: update icx_sessions

2048: c_login_msg := fnd_message.get;
2049:
2050: if g_session_id is not null
2051: then
2052: update icx_sessions
2053: set disabled_flag = 'Y'
2054: where session_id = g_session_id;
2055: COMMIT; -- mputman added 1574527
2056: end if;

Line 2164: update icx_sessions

2160: PRAGMA AUTONOMOUS_TRANSACTION; -- mputman added for 2233089
2161:
2162: begin
2163:
2164: update icx_sessions
2165: set last_connect = sysdate
2166: where session_id = p_session_id;
2167: commit;
2168:

Line 2176: update icx_sessions

2172: is
2173:
2174: begin
2175:
2176: update icx_sessions
2177: set last_connect = sysdate
2178: where session_id = p_session_id;
2179: commit;
2180:

Line 2226: from ICX_SESSIONS

2222: d_first_connect_time,n_counter,
2223: c_disabled_flag,
2224: l_last_connect, l_user_id,
2225: l_resp_id, l_app_resp_id
2226: from ICX_SESSIONS
2227: where SESSION_ID = p_session_id;
2228:
2229: if ((n_counter + 1) > n_limit_connects) or
2230: (( d_first_connect_time + n_limit_time/24 < sysdate))

Line 2355: update icx_sessions

2351: c_login_msg := fnd_message.get;
2352:
2353: if n_session_id is not null
2354: then
2355: update icx_sessions
2356: set disabled_flag = 'Y'
2357: where session_id = n_session_id;
2358: COMMIT; -- mputman added 1574527
2359: end if;

Line 2377: update icx_sessions

2373: c_login_msg := fnd_message.get;
2374:
2375: if n_session_id is not null
2376: then
2377: update icx_sessions
2378: set disabled_flag = 'Y'
2379: where session_id = n_session_id;
2380: COMMIT; -- mputman added 1574527
2381: end if;

Line 2410: update icx_sessions

2406: l_session_id := c_session_id;
2407: end if;
2408:
2409: if c_user_id is null then
2410: update icx_sessions
2411: set disabled_flag = 'Y'
2412: where session_id = l_session_id;
2413: COMMIT; -- mputman added 1574527
2414: elsif c_user_id is not null then

Line 2415: update icx_sessions

2411: set disabled_flag = 'Y'
2412: where session_id = l_session_id;
2413: COMMIT; -- mputman added 1574527
2414: elsif c_user_id is not null then
2415: update icx_sessions
2416: set disabled_flag = 'Y'
2417: where session_id = l_session_id
2418: and user_id = c_user_id;
2419: COMMIT; -- mputman added 1574527

Line 2449: update icx_sessions

2445: if (n_session_id > 0)
2446: then
2447: if n_session_id is not null
2448: then
2449: update icx_sessions
2450: set disabled_flag = 'Y'
2451: where session_id = n_session_id;
2452: COMMIT; -- mputman added 1574527
2453: end if;

Line 2583: from icx_sessions a

2579: end if;
2580:
2581: select a.user_id
2582: into l_user_id
2583: from icx_sessions a
2584: where session_id = n_session_id;
2585:
2586: for cur_att in c_attri
2587: loop

Line 2666: from icx_sessions a

2662: end if;
2663:
2664: select a.user_id
2665: into l_user_id
2666: from icx_sessions a
2667: where session_id = n_session_id;
2668:
2669: for cur_att in c_attri
2670: loop

Line 2674: from icx_sessions

2670: loop
2671: l_count := l_count + 1;
2672: select date_format_mask
2673: into v_date_format
2674: from icx_sessions
2675: where session_id = n_session_id;
2676:
2677: p_date_tbl(l_count) := to_char(cur_att.date_value, v_date_format);
2678:

Line 2755: from icx_sessions a

2751: end if;
2752:
2753: select a.user_id
2754: into l_user_id
2755: from icx_sessions a
2756: where session_id = n_session_id;
2757:
2758: for cur_att in c_attri
2759: loop

Line 2806: from icx_sessions a

2802: begin
2803:
2804: select a.user_id
2805: into n_user_id
2806: from icx_sessions a
2807: where a.session_id = n_session_id;
2808:
2809: if n_user_id <> 1 and n_user_id <> -1 -- ** 1 is sysadmin **
2810: then

Line 2862: update icx_sessions

2858: begin
2859:
2860: if n_session_id is not null and n_org_id is not null
2861: then
2862: update icx_sessions
2863: set org_id = n_org_id
2864: where session_id = n_session_id;
2865:
2866: fnd_client_info.set_org_context(to_char(n_org_id));

Line 2929: from icx_sessions

2925: then
2926: begin -- bug 643163, check session exists
2927: select session_id
2928: into l_session_id
2929: from icx_sessions
2930: where session_id = n_session_id;
2931: exception
2932: when others then
2933: n_session_id := -1;

Line 2971: from icx_sessions a,

2967: elsif n_param = PV_USER_NAME --** USERNAME (99) **
2968: then
2969: select b.USER_NAME
2970: into n_id
2971: from icx_sessions a,
2972: fnd_user b
2973: where b.user_id = a.user_id
2974: and a.session_id = n_session_id;
2975:

Line 3042: from icx_sessions

3038: elsif n_param = PV_SESSION_MODE --** PV_SESSION_MODE (30) **
3039: then
3040: select mode_code
3041: into n_id
3042: from icx_sessions
3043: where session_id = n_session_id;
3044:
3045: elsif n_param = 0
3046: then

Line 3746: update ICX_SESSIONS

3742: val_z => l_org_id,
3743: defined_z => l_profile_defined);
3744: end if;
3745:
3746: update ICX_SESSIONS
3747: set RESPONSIBILITY_APPLICATION_ID = p_application_id,
3748: RESPONSIBILITY_ID = p_responsibility_id,
3749: SECURITY_GROUP_ID = p_security_group_id,
3750: ORG_ID = l_org_id,

Line 4009: UPDATE icx_sessions

4005:
4006:
4007: BEGIN
4008:
4009: UPDATE icx_sessions
4010: SET
4011:
4012: NLS_LANGUAGE=p_language,
4013: DATE_FORMAT_MASK=p_date_format_mask,

Line 4115: UPDATE icx_sessions

4111:
4112: -- Session Hijacking. re-create XSID whenever session is re-created.
4113: l_new_xsid := fnd_session_management.NewXSID;
4114: BEGIN
4115: UPDATE icx_sessions
4116: SET
4117: disabled_flag='N',
4118: last_connect=SYSDATE,
4119: counter=0,

Line 4230: -- FROM icx_sessions

4226:
4227: --get mode_code to see if a portal session
4228: -- SELECT mode_code
4229: -- INTO l_mode
4230: -- FROM icx_sessions
4231: -- WHERE session_id=p_session_id;
4232: --get home_url so we know where to send after portal logout
4233: -- SELECT home_url
4234: -- INTO l_url3

Line 4346: UPDATE icx_sessions

4342: IF (instrb((nvl(l_except_ids,' ')),l_user_name) = 0) THEN
4343:
4344:
4345: BEGIN
4346: UPDATE icx_sessions
4347: SET disabled_flag='Y'
4348: WHERE user_id = l_user_id
4349: AND session_id <> l_session_id
4350: AND mode_code = '115P';

Line 4399: UPDATE icx_sessions

4395: IS
4396:
4397: BEGIN
4398:
4399: UPDATE icx_sessions
4400: SET disabled_flag='Y'
4401: WHERE
4402: (((SYSDATE-first_connect)*24*60)> threshold);
4403: