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.JTF_PF_SOA_MIGRATE_PKG dependencies on FND_GLOBAL

Line 30: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.conc_login_id, 'N/A', -1

26: (SELECT /*+ parallel(i) use_nl(f) */ JTF_PF_SOA_SEQ.NEXTVAL + 0.1, trunc(f.start_time), f.start_time, i.session_id, f.user_id,
27: NVL(i.responsibility_application_id, -1), NVL(i.responsibility_id, -1), NVL(i.language_code, -1), NVL(i.proxy_user_id, -1),
28: (trunc( (f.start_time - to_date('1970/01/01', 'YYYY/MM/DD')) * 86400 * 1000) - timezone_offset) startt,
29: 'AUDIT', 'LOGIN', 200, 0, -1, 1, (f.end_time - f.start_time) * 86400 * 1000 thinkt,
30: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.conc_login_id, 'N/A', -1
31: FROM fnd_logins f, icx_sessions i
32: WHERE f.login_id = i.login_id
33: AND (maxstartt IS NULL
34: OR f.start_time > maxstartt

Line 58: 'AUDIT', 'LOGOUT', 200, 0, -1, 1, fnd_global.user_id,

54: )
55: (SELECT /*+ parallel(i) use_nl(f) */ JTF_PF_SOA_SEQ.NEXTVAL + 0.1, trunc(f.end_time), f.end_time, i.session_id, f.user_id,
56: NVL(i.responsibility_application_id, -1), NVL(i.responsibility_id, -1), NVL(i.language_code, -1), NVL(i.proxy_user_id, -1),
57: (trunc( (end_time - to_date('1970/01/01', 'YYYY/MM/DD')) * 86400 * 1000) - timezone_offset) startt,
58: 'AUDIT', 'LOGOUT', 200, 0, -1, 1, fnd_global.user_id,
59: sysdate, fnd_global.user_id, sysdate, fnd_global.conc_login_id
60: FROM fnd_logins f, icx_sessions i
61: WHERE f.login_id = i.login_id
62: AND f.end_time IS NOT NULL

Line 59: sysdate, fnd_global.user_id, sysdate, fnd_global.conc_login_id

55: (SELECT /*+ parallel(i) use_nl(f) */ JTF_PF_SOA_SEQ.NEXTVAL + 0.1, trunc(f.end_time), f.end_time, i.session_id, f.user_id,
56: NVL(i.responsibility_application_id, -1), NVL(i.responsibility_id, -1), NVL(i.language_code, -1), NVL(i.proxy_user_id, -1),
57: (trunc( (end_time - to_date('1970/01/01', 'YYYY/MM/DD')) * 86400 * 1000) - timezone_offset) startt,
58: 'AUDIT', 'LOGOUT', 200, 0, -1, 1, fnd_global.user_id,
59: sysdate, fnd_global.user_id, sysdate, fnd_global.conc_login_id
60: FROM fnd_logins f, icx_sessions i
61: WHERE f.login_id = i.login_id
62: AND f.end_time IS NOT NULL
63: AND (maxendt IS NULL

Line 99: -1, 1, fnd_global.user_id, sysdate, fnd_global.user_id,

95: (SELECT /*+ parallel(i) use_nl(r) */ JTF_PF_SOA_SEQ.NEXTVAL + 0.1, trunc(r.start_time), r.start_time, i.session_id, i.user_id, r.resp_appl_id,
96: r.responsibility_id, NVL(i.language_code, -1), NVL(i.proxy_user_id, -1),
97: (trunc( (r.start_time - to_date('1970/01/01', 'YYYY/MM/DD')) * 86400 * 1000) - timezone_offset) startt,
98: 'AUDIT', 'RESP_CHANGE', 200, 0, (r.end_time - r.start_time) * 86400 * 1000 thinkt,
99: -1, 1, fnd_global.user_id, sysdate, fnd_global.user_id,
100: sysdate, fnd_global.conc_login_id
101: FROM fnd_login_responsibilities r, icx_sessions i
102: WHERE r.login_id = i.login_id
103: AND (maxtimestamp IS NULL

Line 100: sysdate, fnd_global.conc_login_id

96: r.responsibility_id, NVL(i.language_code, -1), NVL(i.proxy_user_id, -1),
97: (trunc( (r.start_time - to_date('1970/01/01', 'YYYY/MM/DD')) * 86400 * 1000) - timezone_offset) startt,
98: 'AUDIT', 'RESP_CHANGE', 200, 0, (r.end_time - r.start_time) * 86400 * 1000 thinkt,
99: -1, 1, fnd_global.user_id, sysdate, fnd_global.user_id,
100: sysdate, fnd_global.conc_login_id
101: FROM fnd_login_responsibilities r, icx_sessions i
102: WHERE r.login_id = i.login_id
103: AND (maxtimestamp IS NULL
104: OR r.start_time > maxtimestamp

Line 136: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.conc_login_id

132: ( SELECT /*+ parallel(i) use_nl(f) */ JTF_PF_SOA_SEQ.NEXTVAL + 0.1, trunc(f.start_time), f.start_time,
133: i.session_id, i.user_id, f.form_appl_id, r.responsibility_id, NVL(i.language_code, -1),NVL(i.proxy_user_id, -1),
134: (trunc( (f.start_time - to_date('1970/01/01', 'YYYY/MM/DD')) * 86400 * 1000) - timezone_offset) startt,
135: 'FORM', to_char(f.form_id), 200, 0, (f.end_time - f.start_time) * 86400 * 1000 thinkt, -1, 1,
136: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.conc_login_id
137: FROM fnd_login_resp_forms f, icx_sessions i, fnd_login_responsibilities r
138: WHERE f.login_id = i.login_id
139: AND r.login_resp_id = f.login_resp_id
140: AND (maxtimestamp IS NULL