[Home] [Help]
133:
134: -- STEP 2 --
135: -- Select Document_ID those marked for archival
136: -- Loop through the list and make entry into FRM_ARCHIVED_LOBS
137: FOR DOCUMENT_ROW IN (SELECT LOBS.FILE_ID, LOBS.FILE_NAME, LOBS.FILE_CONTENT_TYPE, LOBS.FILE_DATA, LOBS.UPLOAD_DATE, LOBS.PROGRAM_NAME, LOBS.PROGRAM_TAG FROM FRM_REPOSITORY_LOBS LOBS,FRM_DOCUMENT_DETAILS DOC
138: WHERE
139: LOBS.FILE_ID = DOC.FILE_ID AND
140: DOC.ARCHIVED_FLAG = 'Y' AND
141: DOC.END_DATE <= SYSDATE)
146: end loop;
147: -- End Loop
148:
149: -- Delete entries from Repository Lobs
150: DELETE FROM FRM_REPOSITORY_LOBS WHERE FILE_ID IN (SELECT FILE_ID FROM FRM_DOCUMENT_DETAILS WHERE END_DATE <= SYSDATE);
151:
152:
153: -- STEP 3 --
154: -- Select Document_ID those marked for delete to remove corresponding menu / form entries
205: EMESG VARCHAR2(250);
206: BEGIN
207:
208: -- Delete document, timeframe entry from Repository Lobs
209: DELETE FROM FRM_REPOSITORY_LOBS WHERE FILE_ID IN (SELECT FILE_ID FROM FRM_DOCUMENT_DETAILS WHERE DOCUMENT_ID = P_DOCUMENT_ID AND TIMEFRAME = P_TIMEFRAME);
210:
211: -- Delete document, timeframe publishing options.
212: DELETE FROM FRM_DOC_PUB_OPTIONS WHERE DOCUMENT_ID = P_DOCUMENT_ID AND TIMEFRAME = P_TIMEFRAME;
213: