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_CONV_PKG dependencies on JTF_PF_APP_SUMM

Line 323: (SELECT max(day) AS day FROM JTF_PF_APP_SUMM

319: PROCEDURE MIGRATE_DATA_STATS(today DATE) IS
320: BEGIN
321: IF (last_migrate_day IS NULL) THEN
322: SELECT min(x.day) INTO last_migrate_day FROM
323: (SELECT max(day) AS day FROM JTF_PF_APP_SUMM
324: UNION ALL
325: SELECT max(day) AS day FROM JTF_PF_HOST_SUMM
326: UNION ALL
327: SELECT max(day) AS day FROM JTF_PF_PAGE_SUMM

Line 337: DELETE FROM JTF_PF_APP_SUMM WHERE day >= last_migrate_day;

333: END IF;
334: IF (last_migrate_day IS NOT NULL) THEN
335: --DELETE FROM JTF_PF_ANON_ACTIVITY WHERE day < last_migrate_day;
336: --DELETE FROM JTF_PF_SES_ACTIVITY WHERE day < last_migrate_day;
337: DELETE FROM JTF_PF_APP_SUMM WHERE day >= last_migrate_day;
338: DELETE FROM JTF_PF_HOST_SUMM WHERE day >= last_migrate_day;
339: DELETE FROM JTF_PF_PAGE_SUMM WHERE day >= last_migrate_day;
340: DELETE FROM JTF_PF_SESSION_SUMM WHERE (sessionid IS NULL and day >= last_migrate_day)
341: or (sessionid IS NOT NULL and sessionid IN

Line 348: INSERT INTO JTF_PF_APP_SUMM (day, cnt_pages_jtf, cnt_pages_oaf, cnt_pages_form, cnt_pages_all, cnt_flows, cnt_users, cnt_apps, cnt_resps, cnt_sessions, cnt_langs)

344: END IF;
345: -- ADDED to fix bug no-5036611 (START HERE)
346: IF (last_migrate_day is null) THEN
347:
348: INSERT INTO JTF_PF_APP_SUMM (day, cnt_pages_jtf, cnt_pages_oaf, cnt_pages_form, cnt_pages_all, cnt_flows, cnt_users, cnt_apps, cnt_resps, cnt_sessions, cnt_langs)
349: (SELECT day, cnt_pages_jtf, cnt_pages_oaf, cnt_pages_form, cnt_pages_jtf+cnt_pages_oaf+cnt_pages_form, cnt_flows, cnt_users, cnt_apps, cnt_resps, cnt_sessions, cnt_langs
350: FROM JTF_PF_APP_SUMMARY_VL
351: );
352: INSERT INTO JTF_PF_HOST_SUMM (day, servername, serverport, jservs, sum_exect_jtf, sum_exect_oaf, pagehits_jtf, pagehits_oaf, pagehits_all, fails, pages, badpages)

Line 350: FROM JTF_PF_APP_SUMMARY_VL

346: IF (last_migrate_day is null) THEN
347:
348: INSERT INTO JTF_PF_APP_SUMM (day, cnt_pages_jtf, cnt_pages_oaf, cnt_pages_form, cnt_pages_all, cnt_flows, cnt_users, cnt_apps, cnt_resps, cnt_sessions, cnt_langs)
349: (SELECT day, cnt_pages_jtf, cnt_pages_oaf, cnt_pages_form, cnt_pages_jtf+cnt_pages_oaf+cnt_pages_form, cnt_flows, cnt_users, cnt_apps, cnt_resps, cnt_sessions, cnt_langs
350: FROM JTF_PF_APP_SUMMARY_VL
351: );
352: INSERT INTO JTF_PF_HOST_SUMM (day, servername, serverport, jservs, sum_exect_jtf, sum_exect_oaf, pagehits_jtf, pagehits_oaf, pagehits_all, fails, pages, badpages)
353: (SELECT day, NVL(servername, 'N/A'), NVL(serverport, -1), jservs, sum_exect_jtf, sum_exect_oaf, pagehits_jtf, pagehits_oaf, pagehits_jtf+pagehits_oaf, fails, pages, badpages
354: FROM JTF_PF_HOST_SUMMARY_VL

Line 380: INSERT INTO JTF_PF_APP_SUMM (day, cnt_pages_jtf, cnt_pages_oaf, cnt_pages_form, cnt_pages_all, cnt_flows, cnt_users, cnt_apps, cnt_resps, cnt_sessions, cnt_langs)

376: );
377:
378: ELSE
379:
380: INSERT INTO JTF_PF_APP_SUMM (day, cnt_pages_jtf, cnt_pages_oaf, cnt_pages_form, cnt_pages_all, cnt_flows, cnt_users, cnt_apps, cnt_resps, cnt_sessions, cnt_langs)
381: (SELECT day, cnt_pages_jtf, cnt_pages_oaf, cnt_pages_form, cnt_pages_jtf+cnt_pages_oaf+cnt_pages_form, cnt_flows, cnt_users, cnt_apps, cnt_resps, cnt_sessions, cnt_langs
382: FROM JTF_PF_APP_SUMMARY_VL
383: WHERE day >= last_migrate_day
384: );

Line 382: FROM JTF_PF_APP_SUMMARY_VL

378: ELSE
379:
380: INSERT INTO JTF_PF_APP_SUMM (day, cnt_pages_jtf, cnt_pages_oaf, cnt_pages_form, cnt_pages_all, cnt_flows, cnt_users, cnt_apps, cnt_resps, cnt_sessions, cnt_langs)
381: (SELECT day, cnt_pages_jtf, cnt_pages_oaf, cnt_pages_form, cnt_pages_jtf+cnt_pages_oaf+cnt_pages_form, cnt_flows, cnt_users, cnt_apps, cnt_resps, cnt_sessions, cnt_langs
382: FROM JTF_PF_APP_SUMMARY_VL
383: WHERE day >= last_migrate_day
384: );
385: INSERT INTO JTF_PF_HOST_SUMM (day, servername, serverport, jservs, sum_exect_jtf, sum_exect_oaf, pagehits_jtf, pagehits_oaf, pagehits_all, fails, pages, badpages)
386: (SELECT day, NVL(servername, 'N/A'), NVL(serverport, -1), jservs, sum_exect_jtf, sum_exect_oaf, pagehits_jtf, pagehits_oaf, pagehits_jtf+pagehits_oaf, fails, pages, badpages

Line 764: DELETE FROM JTF_PF_APP_SUMM WHERE DAY <= START_DATE;

760: TEMP_DATE:=(START_DATE-1);
761: CLEAN_DATA(TEMP_DATE);
762: DELETE FROM JTF_PF_SES_ACTIVITY WHERE DAY <= START_DATE;
763: DELETE FROM JTF_PF_ANON_ACTIVITY WHERE DAY <= START_DATE;
764: DELETE FROM JTF_PF_APP_SUMM WHERE DAY <= START_DATE;
765: DELETE FROM JTF_PF_HOST_SUMM WHERE DAY <= START_DATE;
766: DELETE FROM JTF_PF_PAGE_SUMM WHERE DAY <= START_DATE;
767: DELETE FROM JTF_PF_SESSION_SUMM WHERE DAY <= START_DATE;
768: DELETE FROM JTF_PF_USER_SUMM WHERE DAY <= START_DATE;