APPS.FRM_REPOSITORY_MAINTENANCE dependencies on FRM_DOCUMENTS_VL

Line 156: FOR DOCUMENT_ROW IN (SELECT DOCUMENT_ID FROM FRM_DOCUMENTS_VL WHERE ARCHIVED_FLAG = 'N' AND END_DATE <= SYSDATE) LOOP

152:
153: -- STEP 3 --
154: -- Select Document_ID those marked for delete to remove corresponding menu / form entries
155: -- Loop through the list and remove menu / form entries
156: FOR DOCUMENT_ROW IN (SELECT DOCUMENT_ID FROM FRM_DOCUMENTS_VL WHERE ARCHIVED_FLAG = 'N' AND END_DATE <= SYSDATE) LOOP
157: DELETE_MENUFORM_ENTRIES(DOCUMENT_ROW.DOCUMENT_ID);
158: END LOOP;
159: -- End Loop
160:

Line 161: DELETE FROM FRM_DOCUMENTS_VL WHERE ARCHIVED_FLAG = 'N' AND END_DATE <= SYSDATE ;

157: DELETE_MENUFORM_ENTRIES(DOCUMENT_ROW.DOCUMENT_ID);
158: END LOOP;
159: -- End Loop
160:
161: DELETE FROM FRM_DOCUMENTS_VL WHERE ARCHIVED_FLAG = 'N' AND END_DATE <= SYSDATE ;
162:
163:
164: -- STEP 4 --
165: DELETE FROM FRM_DOC_PUB_OPTIONS WHERE ARCHIVED_FLAG = 'N' AND END_DATE <= SYSDATE;