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_REPOSITORY

Line 56: INSERT INTO jtf_pf_repository(

52: END LOOP;
53: SELECT sysdate INTO dbdate FROM dual;
54: IF (write_to_jtf = 1) THEN
55: FORALL indx IN objTabLocal.FIRST .. objTabLocal.LAST
56: INSERT INTO jtf_pf_repository(
57: pageobject, object_version_number,
58: created_by, creation_date,
59: last_updated_by, last_update_date, tech_stack, track_purpose)
60: VALUES (objTabLocal(indx), 0, 690, sysdate, 690, sysdate, tech_stack_tbl(indx), track_prps_tbl(indx));

Line 95: INSERT INTO jtf_pf_repository(

91: dummyPageObj := JTF_PF_PAGE_OBJECT(JTF_PF_INFO_OBJECT(seq_num,obj.info.Day,obj.info.Timestamp),obj.dpf,obj.ses,obj.jsp,
92: obj.loc,obj.lang,obj.client,obj.params,
93: obj.cookies,obj.headers,obj.prodinfo);
94: IF (write_to_jtf = 1) THEN
95: INSERT INTO jtf_pf_repository(
96: pageobject, object_version_number,
97: created_by, creation_date,
98: last_updated_by, last_update_date, tech_stack, track_purpose)
99: VALUES (dummyPageObj, 0, 690, obj.info.Day, 690, obj.info.Timestamp, tech_stack, track_purpose);

Line 253: SELECT max(a.pageobject.info.recid) INTO last_msg_in_jtf_rep FROM jtf_pf_repository a;

249: QUERY VARCHAR2(2000);
250: PRAGMA EXCEPTION_INIT(NO_MESSAGES,-25228);
251: PRAGMA AUTONOMOUS_TRANSACTION;
252: BEGIN
253: SELECT max(a.pageobject.info.recid) INTO last_msg_in_jtf_rep FROM jtf_pf_repository a;
254: -- select max(a.corrid) into last_msg_to_upload from JTF_PF_LOGGING_TABLE a;
255:
256: IF last_msg_in_jtf_rep IS NOT NULL THEN current_msg := last_msg_in_jtf_rep; END IF;
257:

Line 278: INSERT INTO jtf_pf_repository( --ang no need to update this insert as the proc is not in use

274:
275: current_msg := mprop.correlation;
276: dopt.navigation := dbms_aq.first_message;
277: dopt.wait := 0;
278: INSERT INTO jtf_pf_repository( --ang no need to update this insert as the proc is not in use
279: pageobject, object_version_number,
280: created_by, creation_date,
281: last_updated_by, last_update_date)
282: VALUES (pgObjects, 0, 690, pgObjects.info.Day, 690, pgObjects.info.Timestamp);

Line 304: -- This procedure is for migrating data from the JTF_PF_REPOSITORY (OLTP Stage Area)

300: END;
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

Line 425: FROM JTF_PF_REPOSITORY x

421: v_SQLString VARCHAR2(300);
422:
423: CURSOR po_Cursor(starting_po IN INTEGER) IS
424: SELECT x.pageobject, x.tech_stack
425: FROM JTF_PF_REPOSITORY x
426: WHERE x.pageobject.info.RecId > starting_po and
427: x.track_purpose not in (2, 4)
428: ORDER BY x.pageobject.ses.SessionId, x.pageobject.jsp.StartTime;
429:

Line 620: FROM JTF_PF_REPOSITORY x

616: nv JTF_PF_NVPAIR;
617: pname JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();
618: CURSOR cur(poid IN INTEGER) IS
619: SELECT x.pageobject.params
620: FROM JTF_PF_REPOSITORY x
621: WHERE x.pageobject.info.RecId = poid;
622: BEGIN
623: OPEN cur(po_id);
624: FETCH cur INTO params;

Line 679: SELECT X.PAGEOBJECT.INFO.RECID FROM JTF_PF_REPOSITORY X WHERE

675: TYPE RECTABTYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
676: RECTABTYPE1 RECTABTYPE;
677:
678: CURSOR EBIZ_DATA IS
679: SELECT X.PAGEOBJECT.INFO.RECID FROM JTF_PF_REPOSITORY X WHERE
680: X.TRACK_PURPOSE IN (0,1) AND
681: X.LAST_UPDATE_DATE <= LEAST(START_DATE ,(SELECT LAST_RECORD_MIGRATED_TIME FROM JTF_PF_PURGEABLE WHERE TRACK_PURPOSE IN (0,1)));
682:
683: CURSOR NON_EBIZ_DATA IS

Line 684: SELECT X.PAGEOBJECT.INFO.RECID FROM JTF_PF_REPOSITORY X WHERE

680: X.TRACK_PURPOSE IN (0,1) AND
681: X.LAST_UPDATE_DATE <= LEAST(START_DATE ,(SELECT LAST_RECORD_MIGRATED_TIME FROM JTF_PF_PURGEABLE WHERE TRACK_PURPOSE IN (0,1)));
682:
683: CURSOR NON_EBIZ_DATA IS
684: SELECT X.PAGEOBJECT.INFO.RECID FROM JTF_PF_REPOSITORY X WHERE
685: X.TRACK_PURPOSE = 4 AND
686: X.LAST_UPDATE_DATE <= LEAST(START_DATE , (SELECT LAST_RECORD_MIGRATED_TIME FROM JTF_PF_PURGEABLE WHERE TRACK_PURPOSE = 4));
687:
688: CURSOR WA_EBIZ_DATA IS

Line 689: SELECT X.PAGEOBJECT.INFO.RECID FROM JTF_PF_REPOSITORY X WHERE

685: X.TRACK_PURPOSE = 4 AND
686: X.LAST_UPDATE_DATE <= LEAST(START_DATE , (SELECT LAST_RECORD_MIGRATED_TIME FROM JTF_PF_PURGEABLE WHERE TRACK_PURPOSE = 4));
687:
688: CURSOR WA_EBIZ_DATA IS
689: SELECT X.PAGEOBJECT.INFO.RECID FROM JTF_PF_REPOSITORY X WHERE
690: X.TRACK_PURPOSE = 2 AND
691: X.LAST_UPDATE_DATE <= LEAST( START_DATE, (SELECT LAST_RECORD_MIGRATED_TIME FROM JTF_PF_PURGEABLE WHERE TRACK_PURPOSE = 2));
692:
693: CURSOR COMMON_DATA IS

Line 694: SELECT X.PAGEOBJECT.INFO.RECID FROM JTF_PF_REPOSITORY X WHERE

690: X.TRACK_PURPOSE = 2 AND
691: X.LAST_UPDATE_DATE <= LEAST( START_DATE, (SELECT LAST_RECORD_MIGRATED_TIME FROM JTF_PF_PURGEABLE WHERE TRACK_PURPOSE = 2));
692:
693: CURSOR COMMON_DATA IS
694: SELECT X.PAGEOBJECT.INFO.RECID FROM JTF_PF_REPOSITORY X WHERE
695: X.TRACK_PURPOSE = 3 AND
696: X.LAST_UPDATE_DATE <= LEAST (START_DATE ,(SELECT MIN(LAST_RECORD_MIGRATED_TIME) FROM JTF_PF_PURGEABLE WHERE TRACK_PURPOSE IN(0,1,2)));
697:
698: BEGIN

Line 704: DELETE FROM JTF_PF_REPOSITORY X WHERE X.PAGEOBJECT.INFO.RECID = RECTABTYPE1(I);

700: LOOP
701: FETCH EBIZ_DATA BULK COLLECT INTO RECTABTYPE1 LIMIT 1000;
702: IF RECTABTYPE1.COUNT > 0 THEN
703: FORALL I IN RECTABTYPE1.FIRST .. RECTABTYPE1.LAST
704: DELETE FROM JTF_PF_REPOSITORY X WHERE X.PAGEOBJECT.INFO.RECID = RECTABTYPE1(I);
705: END IF;
706:
707: EXIT WHEN EBIZ_DATA%NOTFOUND;
708: END LOOP;

Line 717: DELETE FROM JTF_PF_REPOSITORY X WHERE X.PAGEOBJECT.INFO.RECID = RECTABTYPE1(I);

713: LOOP
714: FETCH NON_EBIZ_DATA BULK COLLECT INTO RECTABTYPE1 LIMIT 1000;
715: IF RECTABTYPE1.COUNT > 0 THEN
716: FORALL I IN RECTABTYPE1.FIRST .. RECTABTYPE1.LAST
717: DELETE FROM JTF_PF_REPOSITORY X WHERE X.PAGEOBJECT.INFO.RECID = RECTABTYPE1(I);
718: END IF;
719:
720: EXIT WHEN NON_EBIZ_DATA%NOTFOUND;
721: END LOOP;

Line 730: DELETE FROM JTF_PF_REPOSITORY X WHERE X.PAGEOBJECT.INFO.RECID = RECTABTYPE1(I);

726: LOOP
727: FETCH WA_EBIZ_DATA BULK COLLECT INTO RECTABTYPE1 LIMIT 1000;
728: IF RECTABTYPE1.COUNT > 0 THEN
729: FORALL I IN RECTABTYPE1.FIRST .. RECTABTYPE1.LAST
730: DELETE FROM JTF_PF_REPOSITORY X WHERE X.PAGEOBJECT.INFO.RECID = RECTABTYPE1(I);
731: END IF;
732:
733: EXIT WHEN WA_EBIZ_DATA%NOTFOUND;
734: END LOOP;

Line 744: DELETE FROM JTF_PF_REPOSITORY X WHERE X.PAGEOBJECT.INFO.RECID = RECTABTYPE1(I);

740: LOOP
741: FETCH COMMON_DATA BULK COLLECT INTO RECTABTYPE1 LIMIT 1000;
742: IF RECTABTYPE1.COUNT > 0 THEN
743: FORALL I IN RECTABTYPE1.FIRST .. RECTABTYPE1.LAST
744: DELETE FROM JTF_PF_REPOSITORY X WHERE X.PAGEOBJECT.INFO.RECID = RECTABTYPE1(I);
745: END IF;
746: EXIT WHEN COMMON_DATA%NOTFOUND;
747: END LOOP;
748:

Line 792: FROM JTF_PF_REPOSITORY_TMP x;

788: PROCEDURE MULTIPLY_DATA(days NUMBER) IS
789: PRAGMA AUTONOMOUS_TRANSACTION;
790: CURSOR cur IS
791: SELECT MAX(x.pageobject.ses.sessionid) + 3
792: FROM JTF_PF_REPOSITORY_TMP x;
793: max_sessionid INTEGER;
794: BEGIN
795: DELETE FROM JTF_PF_REPOSITORY_TMP;
796: DELETE FROM JTF_PF_REPOSITORY x WHERE x.pageobject.info.day > sysdate;

Line 795: DELETE FROM JTF_PF_REPOSITORY_TMP;

791: SELECT MAX(x.pageobject.ses.sessionid) + 3
792: FROM JTF_PF_REPOSITORY_TMP x;
793: max_sessionid INTEGER;
794: BEGIN
795: DELETE FROM JTF_PF_REPOSITORY_TMP;
796: DELETE FROM JTF_PF_REPOSITORY x WHERE x.pageobject.info.day > sysdate;
797: COMMIT;
798:
799: INSERT INTO JTF_PF_REPOSITORY_TMP(pageobject, object_version_number, created_by, creation_date, last_updated_by, last_update_date, last_update_login, security_group_id, tech_stack)

Line 796: DELETE FROM JTF_PF_REPOSITORY x WHERE x.pageobject.info.day > sysdate;

792: FROM JTF_PF_REPOSITORY_TMP x;
793: max_sessionid INTEGER;
794: BEGIN
795: DELETE FROM JTF_PF_REPOSITORY_TMP;
796: DELETE FROM JTF_PF_REPOSITORY x WHERE x.pageobject.info.day > sysdate;
797: COMMIT;
798:
799: INSERT INTO JTF_PF_REPOSITORY_TMP(pageobject, object_version_number, created_by, creation_date, last_updated_by, last_update_date, last_update_login, security_group_id, tech_stack)
800: (SELECT pageobject, object_version_number, created_by, creation_date, last_updated_by, last_update_date, last_update_login, security_group_id, tech_stack FROM JTF_PF_REPOSITORY x

Line 799: INSERT INTO JTF_PF_REPOSITORY_TMP(pageobject, object_version_number, created_by, creation_date, last_updated_by, last_update_date, last_update_login, security_group_id, tech_stack)

795: DELETE FROM JTF_PF_REPOSITORY_TMP;
796: DELETE FROM JTF_PF_REPOSITORY x WHERE x.pageobject.info.day > sysdate;
797: COMMIT;
798:
799: INSERT INTO JTF_PF_REPOSITORY_TMP(pageobject, object_version_number, created_by, creation_date, last_updated_by, last_update_date, last_update_login, security_group_id, tech_stack)
800: (SELECT pageobject, object_version_number, created_by, creation_date, last_updated_by, last_update_date, last_update_login, security_group_id, tech_stack FROM JTF_PF_REPOSITORY x
801: WHERE
802: x.pageobject.info.day > sysdate - 1
803: AND x.pageobject.info.day < sysdate);

Line 800: (SELECT pageobject, object_version_number, created_by, creation_date, last_updated_by, last_update_date, last_update_login, security_group_id, tech_stack FROM JTF_PF_REPOSITORY x

796: DELETE FROM JTF_PF_REPOSITORY x WHERE x.pageobject.info.day > sysdate;
797: COMMIT;
798:
799: INSERT INTO JTF_PF_REPOSITORY_TMP(pageobject, object_version_number, created_by, creation_date, last_updated_by, last_update_date, last_update_login, security_group_id, tech_stack)
800: (SELECT pageobject, object_version_number, created_by, creation_date, last_updated_by, last_update_date, last_update_login, security_group_id, tech_stack FROM JTF_PF_REPOSITORY x
801: WHERE
802: x.pageobject.info.day > sysdate - 1
803: AND x.pageobject.info.day < sysdate);
804: COMMIT;

Line 814: UPDATE JTF_PF_REPOSITORY_TMP x

810: END IF;
811: CLOSE cur;
812:
813: FOR i IN 1..days LOOP
814: UPDATE JTF_PF_REPOSITORY_TMP x
815: SET
816: x.pageobject.info.day = x.pageobject.info.day + 1,
817: x.pageobject.info.timestamp = x.pageobject.info.timestamp + 1,
818: x.pageobject.jsp.starttime = x.pageobject.jsp.starttime + 1000 * 60 * 60 * 24;

Line 821: UPDATE JTF_PF_REPOSITORY_TMP x

817: x.pageobject.info.timestamp = x.pageobject.info.timestamp + 1,
818: x.pageobject.jsp.starttime = x.pageobject.jsp.starttime + 1000 * 60 * 60 * 24;
819: COMMIT;
820:
821: UPDATE JTF_PF_REPOSITORY_TMP x
822: SET
823: x.pageobject.ses.sessionid = decode(x.pageobject.ses.sessionid,
824: NULL,x.pageobject.ses.sessionid,
825: -1,x.pageobject.ses.sessionid,

Line 831: INSERT INTO JTF_PF_REPOSITORY (pageobject, object_version_number, created_by, creation_date, last_updated_by, last_update_date, last_update_login, security_group_id, tech_stack)

827: WHERE
828: x.pageobject.ses IS NOT NULL;
829: COMMIT;
830:
831: INSERT INTO JTF_PF_REPOSITORY (pageobject, object_version_number, created_by, creation_date, last_updated_by, last_update_date, last_update_login, security_group_id, tech_stack)
832: (SELECT pageobject, object_version_number, created_by, creation_date, last_updated_by, last_update_date, last_update_login, security_group_id, tech_stack FROM JTF_PF_REPOSITORY_TMP);
833: COMMIT;
834: END LOOP;
835: END;

Line 832: (SELECT pageobject, object_version_number, created_by, creation_date, last_updated_by, last_update_date, last_update_login, security_group_id, tech_stack FROM JTF_PF_REPOSITORY_TMP);

828: x.pageobject.ses IS NOT NULL;
829: COMMIT;
830:
831: INSERT INTO JTF_PF_REPOSITORY (pageobject, object_version_number, created_by, creation_date, last_updated_by, last_update_date, last_update_login, security_group_id, tech_stack)
832: (SELECT pageobject, object_version_number, created_by, creation_date, last_updated_by, last_update_date, last_update_login, security_group_id, tech_stack FROM JTF_PF_REPOSITORY_TMP);
833: COMMIT;
834: END LOOP;
835: END;
836: Function GROUP_CONCAT ( list IN JTF_PF_TABLETYPE, separator VARCHAR2)