APPS.JTF_PF_CONV_PKG dependencies on JTF_PF_PURGEABLE

Line 881: FROM JTF_PF_PURGEABLE

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
882: WHERE TRACK_PURPOSE IN (0,1)
883: ));
884:
885: CURSOR NON_EBIZ_DATA

Line 892: FROM JTF_PF_PURGEABLE

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
893: WHERE TRACK_PURPOSE = 4
894: ));
895:
896: CURSOR WA_EBIZ_DATA

Line 903: FROM JTF_PF_PURGEABLE

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
904: WHERE TRACK_PURPOSE = 2
905: ));
906:
907: CURSOR COMMON_DATA

Line 914: FROM JTF_PF_PURGEABLE

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
915: WHERE TRACK_PURPOSE IN(0,1,2)
916: ));
917:
918: JTF_OWNER varchar2(10);

Line 1179: FROM JTF_PF_PURGEABLE

1175: TP NUMBER := -1;
1176: BEGIN
1177: SELECT COUNT(TRACK_PURPOSE)
1178: INTO TP
1179: FROM JTF_PF_PURGEABLE
1180: WHERE TRACK_PURPOSE = TRK_PRPS;
1181: IF (TP > 0) THEN
1182: UPDATE JTF_PF_PURGEABLE
1183: SET LAST_RECORD_MIGRATED_TIME = LST_RCD_MGRTD_TM

Line 1182: UPDATE JTF_PF_PURGEABLE

1178: INTO TP
1179: FROM JTF_PF_PURGEABLE
1180: WHERE TRACK_PURPOSE = TRK_PRPS;
1181: IF (TP > 0) THEN
1182: UPDATE JTF_PF_PURGEABLE
1183: SET LAST_RECORD_MIGRATED_TIME = LST_RCD_MGRTD_TM
1184: WHERE TRACK_PURPOSE = TRK_PRPS;
1185: ELSE
1186: INSERT INTO JTF_PF_PURGEABLE(

Line 1186: INSERT INTO JTF_PF_PURGEABLE(

1182: UPDATE JTF_PF_PURGEABLE
1183: SET LAST_RECORD_MIGRATED_TIME = LST_RCD_MGRTD_TM
1184: WHERE TRACK_PURPOSE = TRK_PRPS;
1185: ELSE
1186: INSERT INTO JTF_PF_PURGEABLE(
1187: TRACK_PURPOSE,
1188: LAST_RECORD_MIGRATED_TIME)
1189: VALUES(
1190: TRK_PRPS,