APPS.JTF_PF_CONV_PKG dependencies on JTF_PF_ANON_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 335: --DELETE FROM JTF_PF_ANON_ACTIVITY WHERE day < last_migrate_day;

331: SELECT max(day) AS day FROM JTF_PF_USER_SUMM
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;

Line 457: INSERT INTO JTF_PF_ANON_ACTIVITY(

453: -- for anonymous activity
454: IF currpo.ses IS NULL THEN
455: IF currpo.jsp IS NOT NULL AND currpo.loc IS NOT NULL AND currpo.info IS NOT NULL THEN
456: seqcnt1 := seqcnt1 - 1;
457: INSERT INTO JTF_PF_ANON_ACTIVITY(
458: SEQID,
459: DAY,
460: TECH_STACK,
461: TIMESTAMP,

Line 763: DELETE FROM JTF_PF_ANON_ACTIVITY WHERE DAY <= START_DATE;

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;
767: DELETE FROM JTF_PF_SESSION_SUMM WHERE DAY <= START_DATE;