DBA Data[Home] [Help]

APPS.FRM_REPOSITORY_MAINTENANCE dependencies on FRM_DOC_REVIEWERS

Line 169: DELETE FROM FRM_DOC_REVIEWERS WHERE ARCHIVED_FLAG = 'N' AND END_DATE <= SYSDATE;

165: DELETE FROM FRM_DOC_PUB_OPTIONS WHERE ARCHIVED_FLAG = 'N' AND END_DATE <= SYSDATE;
166:
167:
168: -- STEP 5 --
169: DELETE FROM FRM_DOC_REVIEWERS WHERE ARCHIVED_FLAG = 'N' AND END_DATE <= SYSDATE;
170:
171:
172: -- STEP 6 --
173: DELETE FROM FRM_DOCUMENT_DETAILS WHERE ARCHIVED_FLAG = 'N' AND END_DATE <= SYSDATE;

Line 215: DELETE FROM FRM_DOC_REVIEWERS WHERE DOCUMENT_ID = P_DOCUMENT_ID AND TIMEFRAME = P_TIMEFRAME;

211: -- Delete document, timeframe publishing options.
212: DELETE FROM FRM_DOC_PUB_OPTIONS WHERE DOCUMENT_ID = P_DOCUMENT_ID AND TIMEFRAME = P_TIMEFRAME;
213:
214: -- Delete document, timeframe entry reviewers details.
215: DELETE FROM FRM_DOC_REVIEWERS WHERE DOCUMENT_ID = P_DOCUMENT_ID AND TIMEFRAME = P_TIMEFRAME;
216:
217: -- Dlete document, timeframe entry details.
218: DELETE FROM FRM_DOCUMENT_DETAILS WHERE DOCUMENT_ID = P_DOCUMENT_ID AND TIMEFRAME = P_TIMEFRAME;
219: