APPS.CSM_TASK_PURGE_PKG SQL Statements

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

Line: 43

 	UPDATE JTF_OBJECT_PURGE_PARAM_TMP
	SET	   purge_status = 'E',
     	   purge_error_message = 'CSM:CSM_TASK_PURGE_FAILED'
	WHERE  processing_set_id = P_PROCESSING_SET_ID AND
           object_id IN
        		   (
             	   SELECT	 DISTINCT acc.TASK_ID
				   FROM		 CSM_TASKS_ACC acc,
				   			 JTF_OBJECT_PURGE_PARAM_TMP tmp
			       WHERE	 tmp.object_id = acc.TASK_ID AND
                             nvl(tmp.purge_status, 'S') <> 'E' AND
                             tmp.processing_set_id = P_PROCESSING_SET_ID
        	      ) AND
            nvl(purge_status, 'S') <> 'E';

Line: 89

  PROCEDURE DELETE_MFS_TASKS(
      P_API_VERSION                IN	   NUMBER  ,
      P_INIT_MSG_LIST              IN      VARCHAR2     := FND_API.G_FALSE,
      P_COMMIT                     IN      VARCHAR2     := FND_API.G_FALSE,
      P_PROCESSING_SET_ID          IN      NUMBER  ,
      P_OBJECT_TYPE                IN  	   VARCHAR2 ,
      X_RETURN_STATUS              IN      OUT NOCOPY  VARCHAR2,
      X_MSG_COUNT                  IN 	   OUT NOCOPY   NUMBER,
      X_MSG_DATA                   IN	   OUT NOCOPY VARCHAR2)
   IS
l_api_name                CONSTANT VARCHAR2(30) := 'DELETE_MFS_TASKS';

Line: 104

   CSM_UTIL_PKG.LOG('Entering CSM_TASK_PURGE_PKG.DELETE_MFS_TASKS',
     'CSM_TASK_PURGE_PKG.DELETE_MFS_TASKS',FND_LOG.LEVEL_PROCEDURE);

Line: 116

   CSM_UTIL_PKG.LOG('Leaving CSM_TASK_PURGE_PKG.DELETE_MFS_TASKS',
 	'CSM_TASK_PURGE_PKG.DELETE_MFS_TASKS',FND_LOG.LEVEL_PROCEDURE);

Line: 122

     csm_util_pkg.log('CSM_TASK_PURGE_PKG.DELETE_MFS_TASKS ERROR : ' ||
                  l_sqlerrno || ':' || l_sqlerrmsg, FND_LOG.LEVEL_EXCEPTION);

Line: 124

END DELETE_MFS_TASKS;