APPS.JTF_PF_CONV_PKG dependencies on JTF_PF_REPOSITORY_TMP

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