APPS.JTF_PF_CONV_PKG dependencies on JTF_PF_USER_SUMM

Line 429: FROM JTF_PF_USER_SUMM) x;

425: SELECT max(day) AS day
426: FROM JTF_PF_SESSION_SUMM
427: UNION ALL
428: SELECT max(day) AS day
429: FROM JTF_PF_USER_SUMM) x;
430: END IF;
431:
432: IF (last_migrate_day IS NOT NULL) THEN
433: --DELETE FROM JTF_PF_ANON_ACTIVITY WHERE day < last_migrate_day;

Line 453: DELETE FROM JTF_PF_USER_SUMM

449: from JTF_PF_SES_ACTIVITY
450: where day >= last_migrate_day
451: OR last_migrate_day IS NULL));
452:
453: DELETE FROM JTF_PF_USER_SUMM
454: WHERE day >= last_migrate_day;
455: END IF;
456:
457: -- ADDED to fix bug no-5036611 (START HERE)

Line 501: INSERT INTO JTF_PF_USER_SUMM (day, user_name, userid, sum_exect_jtf,

497: and sessionid IN
498: (select distinct sessionid
499: from JTF_PF_SES_ACTIVITY)));
500:
501: INSERT INTO JTF_PF_USER_SUMM (day, user_name, userid, sum_exect_jtf,
502: sum_exect_oaf, sum_exect_form, sum_thinkt_jtf, sum_thinkt_oaf,
503: sum_thinkt_form, cnt_pages_jtf, cnt_pages_oaf, cnt_pages_form,
504: cnt_pages_all, ucnt_ses, ucnt_pages, ucnt_apps, ucnt_resps, ucnt_langs,
505: startt, endt, cnt_fail)

Line 511: FROM JTF_PF_USER_SUMMARY_VL);

507: sum_exect_form, sum_thinkt_jtf, sum_thinkt_oaf, sum_thinkt_form,
508: cnt_pages_jtf, cnt_pages_oaf, cnt_pages_form,
509: cnt_pages_jtf+cnt_pages_oaf+cnt_pages_form, ucnt_ses, ucnt_pages,
510: ucnt_apps, ucnt_resps, ucnt_langs, startt, endt, cnt_fail
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,

Line 560: INSERT INTO JTF_PF_USER_SUMM (day, user_name, userid, sum_exect_jtf,

556: (select distinct sessionid
557: from JTF_PF_SES_ACTIVITY
558: where day >= last_migrate_day )));
559:
560: INSERT INTO JTF_PF_USER_SUMM (day, user_name, userid, sum_exect_jtf,
561: sum_exect_oaf, sum_exect_form, sum_thinkt_jtf, sum_thinkt_oaf,
562: sum_thinkt_form, cnt_pages_jtf, cnt_pages_oaf, cnt_pages_form,
563: cnt_pages_all, ucnt_ses, ucnt_pages, ucnt_apps, ucnt_resps, ucnt_langs,
564: startt, endt, cnt_fail)

Line 570: FROM JTF_PF_USER_SUMMARY_VL

566: sum_exect_form, sum_thinkt_jtf, sum_thinkt_oaf, sum_thinkt_form,
567: cnt_pages_jtf, cnt_pages_oaf, cnt_pages_form,
568: cnt_pages_jtf+cnt_pages_oaf+cnt_pages_form, ucnt_ses, ucnt_pages,
569: ucnt_apps, ucnt_resps, ucnt_langs, startt, endt, cnt_fail
570: FROM JTF_PF_USER_SUMMARY_VL
571: WHERE day >= last_migrate_day);
572:
573: END IF;
574: -- ADDED To fix bug no-5036611 (END HERE)

Line 1025: DELETE FROM JTF_PF_USER_SUMM 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;
1026: COMMIT;
1027: END;
1028: /*===========================================================================
1029: |