APPS.FRM_REPOSITORY_MAINTENANCE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 26

PROCEDURE DELETE_MENU_ENTRIES(P_MENU_ID   IN NUMBER,
        		    P_ENTRY_SEQ   IN NUMBER)
  IS
  	emesg VARCHAR2(250);

Line: 32

      FND_MENU_ENTRIES_PKG.DELETE_ROW(P_MENU_ID,P_ENTRY_SEQ);

Line: 39

  END DELETE_MENU_ENTRIES;

Line: 50

PROCEDURE DELETE_FORM_ENTRIES(P_FUNC_ID   IN NUMBER)
	IS
		emesg VARCHAR2(250);

Line: 55

		FND_FORM_FUNCTIONS_PKG.DELETE_ROW(P_FUNC_ID);

Line: 61

	END DELETE_FORM_ENTRIES;

Line: 73

PROCEDURE DELETE_MENUFORM_ENTRIES(P_DOCUMENT_ID IN NUMBER)
  	IS
  	  emesg VARCHAR2(250);

Line: 87

		    SELECT
                        FormFunctions.FUNCTION_ID,
                        MenuEntries.MENU_ID,
                        MenuEntries.ENTRY_SEQUENCE
                        INTO P_FUNC_ID, P_MENU_ID, P_MENU_SEQ
		    FROM
			  FND_MENU_ENTRIES MenuEntries,
			  FND_FORM_FUNCTIONS FormFunctions
		    WHERE
			  MenuEntries.FUNCTION_ID = FormFunctions.FUNCTION_ID  AND
			  FormFunctions.WEB_HTML_CALL='OA.jsp?page=/oracle/apps/frm/report/display/webui/ReportDisplayPG' AND
		 	 (FormFunctions.PARAMETERS = DOCUMENT_PARAM1 OR FormFunctions.PARAMETERS LIKE DOCUMENT_PARAM2);

Line: 100

		 	 DELETE_MENU_ENTRIES (P_MENU_ID, P_MENU_SEQ);

Line: 102

			 DELETE_FORM_ENTRIES (P_FUNC_ID);

Line: 113

	END DELETE_MENUFORM_ENTRIES;

Line: 125

PROCEDURE DELETE_MARKED_ENTRIES(P_USER_ID IN NUMBER)
    IS
    	emesg VARCHAR2(250);

Line: 130

	--  Delete entries from Archived_Lobs --
	DELETE FROM  FRM_ARCHIVED_LOBS WHERE FILE_ID IN (SELECT FILE_ID FROM FRM_DOCUMENT_DETAILS WHERE ARCHIVED_FLAG = 'N' AND END_DATE <= SYSDATE);

Line: 135

	-- Select Document_ID those marked for archival
	-- Loop through the list and make entry into FRM_ARCHIVED_LOBS
	 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
	 WHERE
	 	LOBS.FILE_ID = DOC.FILE_ID AND
	 	DOC.ARCHIVED_FLAG = 'Y' AND
	 	DOC.END_DATE <= SYSDATE)
	 LOOP
	  	INSERT INTO FRM_ARCHIVED_LOBS
	  	(FILE_ID,FILE_NAME,FILE_CONTENT_TYPE ,FILE_DATA,UPLOAD_DATE ,EXPIRATION_DATE,PROGRAM_NAME,PROGRAM_TAG ,CREATION_DATE ,CREATED_BY ,LAST_UPDATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATE_DATE ) VALUES
	  	(DOCUMENT_ROW.FILE_ID ,DOCUMENT_ROW.FILE_NAME, DOCUMENT_ROW.FILE_CONTENT_TYPE, DOCUMENT_ROW.FILE_DATA, DOCUMENT_ROW.UPLOAD_DATE,'',DOCUMENT_ROW.PROGRAM_NAME, DOCUMENT_ROW.PROGRAM_TAG, SYSDATE,P_USER_ID,P_USER_ID,0,SYSDATE);

Line: 149

	--  Delete entries from Repository Lobs
	DELETE FROM  FRM_REPOSITORY_LOBS WHERE FILE_ID IN (SELECT FILE_ID FROM FRM_DOCUMENT_DETAILS WHERE END_DATE <= SYSDATE);

Line: 154

	-- Select Document_ID those marked for delete to remove corresponding menu / form entries
	-- Loop through the list and remove menu / form entries
	FOR DOCUMENT_ROW IN (SELECT DOCUMENT_ID FROM FRM_DOCUMENTS_VL WHERE ARCHIVED_FLAG = 'N' AND END_DATE <= SYSDATE) LOOP
		DELETE_MENUFORM_ENTRIES(DOCUMENT_ROW.DOCUMENT_ID);

Line: 161

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

Line: 165

	DELETE FROM  FRM_DOC_PUB_OPTIONS WHERE ARCHIVED_FLAG = 'N' AND END_DATE <= SYSDATE;

Line: 169

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

Line: 173

	DELETE FROM  FRM_DOCUMENT_DETAILS WHERE ARCHIVED_FLAG = 'N' AND END_DATE <= SYSDATE;

Line: 177

	DELETE FROM  FRM_DIRECTORY_VL WHERE ARCHIVED_FLAG = 'N' AND END_DATE <= SYSDATE;

Line: 186

END DELETE_MARKED_ENTRIES;

Line: 203

PROCEDURE DELETE_DOCUMENT_TIMEFRAME(P_DOCUMENT_ID IN NUMBER, P_TIMEFRAME IN VARCHAR2)
    IS
    	EMESG VARCHAR2(250);

Line: 208

	--  Delete document, timeframe entry from Repository Lobs
	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);

Line: 211

	-- Delete document, timeframe publishing options.
	DELETE FROM  FRM_DOC_PUB_OPTIONS WHERE DOCUMENT_ID = P_DOCUMENT_ID AND TIMEFRAME = P_TIMEFRAME;

Line: 214

	-- Delete document, timeframe entry reviewers details.
	DELETE FROM  FRM_DOC_REVIEWERS WHERE DOCUMENT_ID = P_DOCUMENT_ID AND TIMEFRAME = P_TIMEFRAME;

Line: 218

	DELETE FROM  FRM_DOCUMENT_DETAILS WHERE DOCUMENT_ID = P_DOCUMENT_ID AND TIMEFRAME = P_TIMEFRAME;

Line: 225

END DELETE_DOCUMENT_TIMEFRAME;