APPS.JTF_PF_CONV_PKG dependencies on JTF_PF_SES_ACTIVITY

Line 388: | Area) to the OLAP Tables (JTF_PF_ANON_ACTIVITY, JTF_PF_SES_ACTIVITY).

384: END LOOP;
385: END;
386: /*===========================================================================
387: | This procedure is for migrating data from the JTF_PF_REPOSITORY (OLTP Stage
388: | Area) to the OLAP Tables (JTF_PF_ANON_ACTIVITY, JTF_PF_SES_ACTIVITY).
389: ============================================================================*/
390: PROCEDURE MIGRATE_DATA(timezone_offset IN NUMBER)
391: IS
392: today DATE;

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

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;
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

Line 449: from JTF_PF_SES_ACTIVITY

445: WHERE (sessionid IS NULL and day >= last_migrate_day)
446: OR (sessionid IS NOT NULL
447: and sessionid IN
448: (select distinct sessionid
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

Line 499: from JTF_PF_SES_ACTIVITY)));

495: WHERE (sessionid IS NULL )
496: or (sessionid IS NOT NULL
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,

Line 557: from JTF_PF_SES_ACTIVITY

553: WHERE (sessionid IS NULL and day >= last_migrate_day)
554: or (sessionid IS NOT NULL
555: and sessionid IN
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,

Line 713: INSERT INTO JTF_PF_SES_ACTIVITY(

709: AND currpo.jsp.NAME IS NOT NULL
710: AND currpo.jsp.statusCode IS NOT NULL
711: AND currpo.jsp.executionTime IS NOT NULL THEN
712: seqcnt2 := seqcnt2 + 1;
713: INSERT INTO JTF_PF_SES_ACTIVITY(
714: SEQID,
715: DAY,
716: TECH_STACK,
717: TIMESTAMP,

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

1015: else
1016: CLEAN_DATA(TEMP_DATE, FALSE);
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;