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 68: INSERT INTO jtf_pf_repository(

64: SELECT sysdate INTO dbdate FROM dual;
65:
66: IF (write_to_jtf = 1) THEN
67: FORALL indx IN objTabLocal.FIRST .. objTabLocal.LAST
68: INSERT INTO jtf_pf_repository(
69: pageobject,
70: object_version_number,
71: created_by,
72: creation_date,

Line 133: INSERT INTO jtf_pf_repository(

129: obj.ses, obj.jsp, obj.loc, obj.lang, obj.client, obj.params,
130: obj.cookies, obj.headers, obj.prodinfo);
131:
132: IF (write_to_jtf = 1) THEN
133: INSERT INTO jtf_pf_repository(
134: pageobject,
135: object_version_number,
136: created_by,
137: creation_date,

Line 322: FROM jtf_pf_repository a;

318: enable_user varchar2(10) := NULL;
319: BEGIN
320: SELECT max(a.pageobject.info.recid)
321: INTO last_msg_in_jtf_rep
322: FROM jtf_pf_repository a;
323: -- select max(a.corrid) into last_msg_to_upload from JTF_PF_LOGGING_TABLE a;
324:
325: IF last_msg_in_jtf_rep IS NOT NULL THEN
326: current_msg := last_msg_in_jtf_rep;

Line 353: INSERT INTO jtf_pf_repository( --ang no need to update this insert

349: current_msg := mprop.correlation;
350: dopt.navigation := dbms_aq.first_message;
351: dopt.wait := 0;
352:
353: INSERT INTO jtf_pf_repository( --ang no need to update this insert
354: pageobject, --as the proc is not in use
355: object_version_number,
356: created_by,
357: creation_date,

Line 387: | This procedure is for migrating data from the JTF_PF_REPOSITORY (OLTP Stage

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

Line 588: FROM JTF_PF_REPOSITORY x

584: v_SQLString VARCHAR2(300);
585:
586: CURSOR po_Cursor(starting_po IN INTEGER) IS
587: SELECT x.pageobject, x.tech_stack
588: FROM JTF_PF_REPOSITORY x
589: WHERE x.pageobject.info.RecId > starting_po and
590: x.track_purpose not in (2, 4)
591: ORDER BY x.pageobject.ses.SessionId, x.pageobject.jsp.StartTime;
592:

Line 806: FROM JTF_PF_REPOSITORY x

802: pname JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();
803:
804: CURSOR cur(poid IN INTEGER) IS
805: SELECT x.pageobject.params
806: FROM JTF_PF_REPOSITORY x
807: WHERE x.pageobject.info.RecId = poid;
808: BEGIN
809: OPEN cur(po_id);
810: FETCH cur INTO params;

Line 864: | This procedure cleans data from JTF_PF_REPOSITORY based on when the data

860: pval(i) := nv.value;
861: END LOOP;
862: END;
863: /*===========================================================================
864: | This procedure cleans data from JTF_PF_REPOSITORY based on when the data
865: | was last migrated into the Page Access Tracking tables. It can also clean
866: | all data from JTF_PF_REPOSITORY by force, if preferred.
867: ============================================================================*/
868: PROCEDURE CLEAN_DATA(START_DATE DATE, force_clean boolean default FALSE)

Line 866: | all data from JTF_PF_REPOSITORY by force, if preferred.

862: END;
863: /*===========================================================================
864: | This procedure cleans data from JTF_PF_REPOSITORY based on when the data
865: | was last migrated into the Page Access Tracking tables. It can also clean
866: | all data from JTF_PF_REPOSITORY by force, if preferred.
867: ============================================================================*/
868: PROCEDURE CLEAN_DATA(START_DATE DATE, force_clean boolean default FALSE)
869: IS
870: -- PRAGMA AUTONOMOUS_TRANSACTION;

Line 877: FROM JTF_PF_REPOSITORY X

873:
874: CURSOR EBIZ_DATA
875: IS
876: SELECT X.PAGEOBJECT.INFO.RECID
877: FROM JTF_PF_REPOSITORY X
878: WHERE X.TRACK_PURPOSE IN (0,1)
879: AND X.LAST_UPDATE_DATE <= LEAST(START_DATE,
880: (SELECT LAST_RECORD_MIGRATED_TIME
881: FROM JTF_PF_PURGEABLE

Line 888: FROM JTF_PF_REPOSITORY X

884:
885: CURSOR NON_EBIZ_DATA
886: IS
887: SELECT X.PAGEOBJECT.INFO.RECID
888: FROM JTF_PF_REPOSITORY X
889: WHERE X.TRACK_PURPOSE = 4
890: AND X.LAST_UPDATE_DATE <= LEAST(START_DATE,
891: (SELECT LAST_RECORD_MIGRATED_TIME
892: FROM JTF_PF_PURGEABLE

Line 899: FROM JTF_PF_REPOSITORY X

895:
896: CURSOR WA_EBIZ_DATA
897: IS
898: SELECT X.PAGEOBJECT.INFO.RECID
899: FROM JTF_PF_REPOSITORY X
900: WHERE X.TRACK_PURPOSE = 2
901: AND X.LAST_UPDATE_DATE <= LEAST( START_DATE,
902: (SELECT LAST_RECORD_MIGRATED_TIME
903: FROM JTF_PF_PURGEABLE

Line 910: FROM JTF_PF_REPOSITORY X

906:
907: CURSOR COMMON_DATA
908: IS
909: SELECT X.PAGEOBJECT.INFO.RECID
910: FROM JTF_PF_REPOSITORY X
911: WHERE X.TRACK_PURPOSE = 3
912: AND X.LAST_UPDATE_DATE <= LEAST (START_DATE ,
913: (SELECT MIN(LAST_RECORD_MIGRATED_TIME)
914: FROM JTF_PF_PURGEABLE

Line 922: -- Get owner of JTF_PF_REPOSITORY, cannot hardcode 'JTF' per GSCC

918: JTF_OWNER varchar2(10);
919: BEGIN
920: -- If data is to be cleaned by force
921: IF force_clean THEN
922: -- Get owner of JTF_PF_REPOSITORY, cannot hardcode 'JTF' per GSCC
923: -- standards File.Sql.6
924: SELECT FOU.ORACLE_USERNAME INTO JTF_OWNER
925: FROM FND_ORACLE_USERID FOU,
926: FND_PRODUCT_INSTALLATIONS FPI,

Line 932: -- truncate all rows from the table JTF_PF_REPOSITORY;

928: WHERE FOU.ORACLE_ID = FPI.ORACLE_ID
929: AND FPI.APPLICATION_ID = A.APPLICATION_ID
930: AND A.APPLICATION_SHORT_NAME = 'JTF';
931:
932: -- truncate all rows from the table JTF_PF_REPOSITORY;
933: -- TRUNCATE TABLE cannot be called directly from PL/SQL, so use
934: -- dynamic PL/SQL call. Once table is truncated, it cannot be rolled back.
935: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || JTF_OWNER ||'.JTF_PF_REPOSITORY';
936: ELSE

Line 935: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || JTF_OWNER ||'.JTF_PF_REPOSITORY';

931:
932: -- truncate all rows from the table JTF_PF_REPOSITORY;
933: -- TRUNCATE TABLE cannot be called directly from PL/SQL, so use
934: -- dynamic PL/SQL call. Once table is truncated, it cannot be rolled back.
935: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || JTF_OWNER ||'.JTF_PF_REPOSITORY';
936: ELSE
937: -- Use cursors that filter on when data was last migrated
938: OPEN EBIZ_DATA;
939: LOOP

Line 944: FROM JTF_PF_REPOSITORY X

940: FETCH EBIZ_DATA BULK COLLECT INTO RECTABTYPE1 LIMIT 1000;
941: IF RECTABTYPE1.COUNT > 0 THEN
942: FORALL I IN RECTABTYPE1.FIRST .. RECTABTYPE1.LAST
943: DELETE
944: FROM JTF_PF_REPOSITORY X
945: WHERE X.PAGEOBJECT.INFO.RECID = RECTABTYPE1(I);
946: END IF;
947: EXIT
948: WHEN EBIZ_DATA%NOTFOUND;

Line 959: FROM JTF_PF_REPOSITORY X

955: FETCH NON_EBIZ_DATA BULK COLLECT INTO RECTABTYPE1 LIMIT 1000;
956: IF RECTABTYPE1.COUNT > 0 THEN
957: FORALL I IN RECTABTYPE1.FIRST .. RECTABTYPE1.LAST
958: DELETE
959: FROM JTF_PF_REPOSITORY X
960: WHERE X.PAGEOBJECT.INFO.RECID = RECTABTYPE1(I);
961: END IF;
962: EXIT
963: WHEN NON_EBIZ_DATA%NOTFOUND;

Line 974: FROM JTF_PF_REPOSITORY X

970: FETCH WA_EBIZ_DATA BULK COLLECT INTO RECTABTYPE1 LIMIT 1000;
971: IF RECTABTYPE1.COUNT > 0 THEN
972: FORALL I IN RECTABTYPE1.FIRST .. RECTABTYPE1.LAST
973: DELETE
974: FROM JTF_PF_REPOSITORY X
975: WHERE X.PAGEOBJECT.INFO.RECID = RECTABTYPE1(I);
976: END IF;
977: EXIT
978: WHEN WA_EBIZ_DATA%NOTFOUND;

Line 989: FROM JTF_PF_REPOSITORY X

985: FETCH COMMON_DATA BULK COLLECT INTO RECTABTYPE1 LIMIT 1000;
986: IF RECTABTYPE1.COUNT > 0 THEN
987: FORALL I IN RECTABTYPE1.FIRST .. RECTABTYPE1.LAST
988: DELETE
989: FROM JTF_PF_REPOSITORY X
990: WHERE X.PAGEOBJECT.INFO.RECID = RECTABTYPE1(I);
991: END IF;
992: EXIT
993: WHEN COMMON_DATA%NOTFOUND;

Line 1060: FROM JTF_PF_REPOSITORY_TMP x;

1056:
1057: CURSOR cur
1058: IS
1059: SELECT MAX(x.pageobject.ses.sessionid) + 3
1060: FROM JTF_PF_REPOSITORY_TMP x;
1061:
1062: max_sessionid INTEGER;
1063: BEGIN
1064: DELETE FROM JTF_PF_REPOSITORY_TMP;

Line 1064: DELETE FROM JTF_PF_REPOSITORY_TMP;

1060: FROM JTF_PF_REPOSITORY_TMP x;
1061:
1062: max_sessionid INTEGER;
1063: BEGIN
1064: DELETE FROM JTF_PF_REPOSITORY_TMP;
1065: DELETE FROM JTF_PF_REPOSITORY x WHERE x.pageobject.info.day > sysdate;
1066: COMMIT;
1067:
1068: INSERT INTO JTF_PF_REPOSITORY_TMP(

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

1061:
1062: max_sessionid INTEGER;
1063: BEGIN
1064: DELETE FROM JTF_PF_REPOSITORY_TMP;
1065: DELETE FROM JTF_PF_REPOSITORY x WHERE x.pageobject.info.day > sysdate;
1066: COMMIT;
1067:
1068: INSERT INTO JTF_PF_REPOSITORY_TMP(
1069: pageobject,

Line 1068: INSERT INTO JTF_PF_REPOSITORY_TMP(

1064: DELETE FROM JTF_PF_REPOSITORY_TMP;
1065: DELETE FROM JTF_PF_REPOSITORY x WHERE x.pageobject.info.day > sysdate;
1066: COMMIT;
1067:
1068: INSERT INTO JTF_PF_REPOSITORY_TMP(
1069: pageobject,
1070: object_version_number,
1071: created_by,
1072: creation_date,

Line 1088: FROM JTF_PF_REPOSITORY x

1084: last_update_date,
1085: last_update_login,
1086: security_group_id,
1087: tech_stack
1088: FROM JTF_PF_REPOSITORY x
1089: WHERE x.pageobject.info.day > sysdate - 1
1090: AND x.pageobject.info.day < sysdate);
1091: COMMIT;
1092:

Line 1102: UPDATE JTF_PF_REPOSITORY_TMP x

1098: CLOSE cur;
1099:
1100: FOR i IN 1..days
1101: LOOP
1102: UPDATE JTF_PF_REPOSITORY_TMP x
1103: SET x.pageobject.info.day = x.pageobject.info.day + 1,
1104: x.pageobject.info.timestamp = x.pageobject.info.timestamp + 1,
1105: x.pageobject.jsp.starttime =
1106: x.pageobject.jsp.starttime + 1000 * 60 * 60 * 24;

Line 1109: UPDATE JTF_PF_REPOSITORY_TMP x

1105: x.pageobject.jsp.starttime =
1106: x.pageobject.jsp.starttime + 1000 * 60 * 60 * 24;
1107: COMMIT;
1108:
1109: UPDATE JTF_PF_REPOSITORY_TMP x
1110: SET x.pageobject.ses.sessionid = DECODE(x.pageobject.ses.sessionid, NULL,
1111: x.pageobject.ses.sessionid, -1,x.pageobject.ses.sessionid,
1112: x.pageobject.ses.sessionid - max_sessionid)
1113: WHERE x.pageobject.ses IS NOT NULL;

Line 1116: INSERT INTO JTF_PF_REPOSITORY(

1112: x.pageobject.ses.sessionid - max_sessionid)
1113: WHERE x.pageobject.ses IS NOT NULL;
1114: COMMIT;
1115:
1116: INSERT INTO JTF_PF_REPOSITORY(
1117: pageobject,
1118: object_version_number,
1119: created_by,
1120: creation_date,

Line 1136: FROM JTF_PF_REPOSITORY_TMP);

1132: last_update_date,
1133: last_update_login,
1134: security_group_id,
1135: tech_stack
1136: FROM JTF_PF_REPOSITORY_TMP);
1137: COMMIT;
1138:
1139: END LOOP;
1140: END;