APPS.JTF_PF_SOA_MIGRATE_PKG dependencies on JTF_PF_SOA_SEQ

Line 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,

22: startt,
23: tech_stack, pagename, statuscode, exect, po, object_version_number, thinkt,
24: created_by, creation_date, last_updated_by, last_update_date, last_update_login, servername, serverport
25: )
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

Line 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,

51: startt,
52: tech_stack, pagename, statuscode, exect, po, object_version_number, created_by,
53: creation_date, last_updated_by, last_update_date, last_update_login
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

Line 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,

91: tech_stack, pagename, statuscode, exect, thinkt,
92: po, object_version_number, created_by, creation_date, last_updated_by,
93: last_update_date, last_update_login
94: )
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,

Line 132: ( SELECT /*+ parallel(i) use_nl(f) */ JTF_PF_SOA_SEQ.NEXTVAL + 0.1, trunc(f.start_time), f.start_time,

128: statuscode, exect, thinkt, po, object_version_number,
129: created_by, creation_date, last_updated_by, last_update_date,
130: last_update_login
131: )
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