APPS.CSM_SR_PURGE_PKG SQL Statements

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

Line: 44

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

Line: 90

  PROCEDURE Delete_MobileFSObjects(
      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_MobileFSObjects';

Line: 105

   CSM_UTIL_PKG.LOG('Entering CSM_SR_PURGE_PKG.Delete_MobileFSObjects',
     'CSM_SR_PURGE_PKG.Delete_MobileFSObjects',FND_LOG.LEVEL_PROCEDURE);

Line: 117

   CSM_UTIL_PKG.LOG('Leaving CSM_SR_PURGE_PKG.Delete_MobileFSObjects',
 	'CSM_SR_PURGE_PKG.Delete_MobileFSObjects',FND_LOG.LEVEL_PROCEDURE);

Line: 123

     csm_util_pkg.log('CSM_SR_PURGE_PKG.Delete_MobileFSObjects ERROR : ' ||
                  l_sqlerrno || ':' || l_sqlerrmsg, FND_LOG.LEVEL_EXCEPTION);

Line: 125

END Delete_MobileFSObjects;