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 417: FROM JTF_PF_APP_SUMM

413: IF (last_migrate_day IS NULL) THEN
414: SELECT min(x.day)
415: INTO last_migrate_day
416: FROM (SELECT max(day) AS day
417: FROM JTF_PF_APP_SUMM
418: UNION ALL
419: SELECT max(day) AS day
420: FROM JTF_PF_HOST_SUMM
421: UNION ALL

Line 435: DELETE FROM JTF_PF_APP_SUMM

431:
432: IF (last_migrate_day IS NOT NULL) THEN
433: --DELETE FROM JTF_PF_ANON_ACTIVITY WHERE day < last_migrate_day;
434: --DELETE FROM JTF_PF_SES_ACTIVITY WHERE day < last_migrate_day;
435: DELETE FROM JTF_PF_APP_SUMM
436: WHERE day >= last_migrate_day;
437:
438: DELETE FROM JTF_PF_HOST_SUMM
439: WHERE day >= last_migrate_day;

Line 460: INSERT INTO JTF_PF_APP_SUMM(day, cnt_pages_jtf, cnt_pages_oaf,

456:
457: -- ADDED to fix bug no-5036611 (START HERE)
458: IF (last_migrate_day is null) THEN
459:
460: INSERT INTO JTF_PF_APP_SUMM(day, cnt_pages_jtf, cnt_pages_oaf,
461: cnt_pages_form, cnt_pages_all, cnt_flows, cnt_users, cnt_apps,
462: cnt_resps, cnt_sessions, cnt_langs)
463: (SELECT day, cnt_pages_jtf, cnt_pages_oaf, cnt_pages_form,
464: cnt_pages_jtf+cnt_pages_oaf+cnt_pages_form, cnt_flows, cnt_users,

Line 466: FROM JTF_PF_APP_SUMMARY_VL);

462: cnt_resps, cnt_sessions, cnt_langs)
463: (SELECT day, cnt_pages_jtf, cnt_pages_oaf, cnt_pages_form,
464: cnt_pages_jtf+cnt_pages_oaf+cnt_pages_form, cnt_flows, cnt_users,
465: cnt_apps, cnt_resps, cnt_sessions, cnt_langs
466: FROM JTF_PF_APP_SUMMARY_VL);
467:
468: INSERT INTO JTF_PF_HOST_SUMM (day, servername, serverport, jservs,
469: sum_exect_jtf, sum_exect_oaf, pagehits_jtf, pagehits_oaf, pagehits_all,
470: fails, pages, badpages)

Line 515: INSERT INTO JTF_PF_APP_SUMM (day, cnt_pages_jtf, cnt_pages_oaf,

511: FROM JTF_PF_USER_SUMMARY_VL);
512:
513: ELSE
514:
515: INSERT INTO JTF_PF_APP_SUMM (day, cnt_pages_jtf, cnt_pages_oaf,
516: cnt_pages_form, cnt_pages_all, cnt_flows, cnt_users, cnt_apps,
517: cnt_resps, cnt_sessions, cnt_langs)
518: (SELECT day, cnt_pages_jtf, cnt_pages_oaf, cnt_pages_form,
519: cnt_pages_jtf+cnt_pages_oaf+cnt_pages_form, cnt_flows, cnt_users,

Line 521: FROM JTF_PF_APP_SUMMARY_VL

517: cnt_resps, cnt_sessions, cnt_langs)
518: (SELECT day, cnt_pages_jtf, cnt_pages_oaf, cnt_pages_form,
519: cnt_pages_jtf+cnt_pages_oaf+cnt_pages_form, cnt_flows, cnt_users,
520: cnt_apps, cnt_resps, cnt_sessions, cnt_langs
521: FROM JTF_PF_APP_SUMMARY_VL
522: WHERE day >= last_migrate_day);
523:
524: INSERT INTO JTF_PF_HOST_SUMM (day, servername, serverport, jservs,
525: sum_exect_jtf, sum_exect_oaf, pagehits_jtf, pagehits_oaf, pagehits_all,

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

1017: end if;
1018:
1019: DELETE FROM JTF_PF_SES_ACTIVITY WHERE DAY <= START_DATE;
1020: DELETE FROM JTF_PF_ANON_ACTIVITY WHERE DAY <= START_DATE;
1021: DELETE FROM JTF_PF_APP_SUMM WHERE DAY <= START_DATE;
1022: DELETE FROM JTF_PF_HOST_SUMM WHERE DAY <= START_DATE;
1023: DELETE FROM JTF_PF_PAGE_SUMM WHERE DAY <= START_DATE;
1024: DELETE FROM JTF_PF_SESSION_SUMM WHERE DAY <= START_DATE;
1025: DELETE FROM JTF_PF_USER_SUMM WHERE DAY <= START_DATE;