DBA Data[Home] [Help]

APPS.JTF_PF_CONV_PKG dependencies on JTF_PF_SES_ACTIVITY

Line 305: -- to the OLAP Tables (JTF_PF_ANON_ACTIVITY, JTF_PF_SES_ACTIVITY).

301: END LOOP;
302: END ;
303:
304: -- This procedure is for migrating data from the JTF_PF_REPOSITORY (OLTP Stage Area)
305: -- to the OLAP Tables (JTF_PF_ANON_ACTIVITY, JTF_PF_SES_ACTIVITY).
306: PROCEDURE MIGRATE_DATA(timezone_offset IN NUMBER) IS
307: today DATE;
308: BEGIN
309: SELECT trunc(sysdate) INTO today FROM dual;

Line 336: --DELETE FROM JTF_PF_SES_ACTIVITY WHERE day < last_migrate_day;

332: ) x;
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)

Line 342: (select distinct sessionid from JTF_PF_SES_ACTIVITY where day >= last_migrate_day OR last_migrate_day IS NULL));

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
342: (select distinct sessionid from JTF_PF_SES_ACTIVITY where day >= last_migrate_day OR last_migrate_day IS NULL));
343: DELETE FROM JTF_PF_USER_SUMM WHERE day >= last_migrate_day;
344: END IF;
345: -- ADDED to fix bug no-5036611 (START HERE)
346: IF (last_migrate_day is null) THEN

Line 369: (select distinct sessionid from JTF_PF_SES_ACTIVITY))

365: cnt_pages_jtf, cnt_pages_oaf, cnt_pages_form, cnt_pages_jtf+cnt_pages_oaf+cnt_pages_form, ucnt_pages, ucnt_flows, ucnt_users, ucnt_apps, ucnt_resps, ucnt_langs, startt, endt, cnt_fail
366: FROM JTF_PF_SESSION_SUMMARY_VL
367: WHERE (sessionid IS NULL )
368: or (sessionid IS NOT NULL and sessionid IN
369: (select distinct sessionid from JTF_PF_SES_ACTIVITY))
370: );
371: INSERT INTO JTF_PF_USER_SUMM (day, user_name, userid, sum_exect_jtf, sum_exect_oaf, sum_exect_form, sum_thinkt_jtf, sum_thinkt_oaf, sum_thinkt_form,
372: cnt_pages_jtf, cnt_pages_oaf, cnt_pages_form, cnt_pages_all, ucnt_ses, ucnt_pages, ucnt_apps, ucnt_resps, ucnt_langs, startt, endt, cnt_fail)
373: (SELECT day, user_name, userid, sum_exect_jtf, sum_exect_oaf, sum_exect_form, sum_thinkt_jtf, sum_thinkt_oaf, sum_thinkt_form,

Line 404: (select distinct sessionid from JTF_PF_SES_ACTIVITY where day >= last_migrate_day ))

400: cnt_pages_jtf, cnt_pages_oaf, cnt_pages_form, cnt_pages_jtf+cnt_pages_oaf+cnt_pages_form, ucnt_pages, ucnt_flows, ucnt_users, ucnt_apps, ucnt_resps, ucnt_langs, startt, endt, cnt_fail
401: FROM JTF_PF_SESSION_SUMMARY_VL
402: WHERE (sessionid IS NULL and day >= last_migrate_day)
403: or (sessionid IS NOT NULL and sessionid IN
404: (select distinct sessionid from JTF_PF_SES_ACTIVITY where day >= last_migrate_day ))
405: );
406: INSERT INTO JTF_PF_USER_SUMM (day, user_name, userid, sum_exect_jtf, sum_exect_oaf, sum_exect_form, sum_thinkt_jtf, sum_thinkt_oaf, sum_thinkt_form,
407: cnt_pages_jtf, cnt_pages_oaf, cnt_pages_form, cnt_pages_all, ucnt_ses, ucnt_pages, ucnt_apps, ucnt_resps, ucnt_langs, startt, endt, cnt_fail)
408: (SELECT day, user_name, userid, sum_exect_jtf, sum_exect_oaf, sum_exect_form, sum_thinkt_jtf, sum_thinkt_oaf, sum_thinkt_form,

Line 533: INSERT INTO JTF_PF_SES_ACTIVITY(

529: AND currpo.jsp.statusCode IS NOT NULL
530: AND currpo.jsp.executionTime IS NOT NULL
531: THEN
532: seqcnt2 := seqcnt2 + 1;
533: INSERT INTO JTF_PF_SES_ACTIVITY(
534: SEQID,
535: DAY,
536: TECH_STACK,
537: TIMESTAMP,

Line 762: DELETE FROM JTF_PF_SES_ACTIVITY WHERE DAY <= START_DATE;

758: BEGIN
759: --dbms_output.put_line('purge data ');
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;