The following lines contain the word 'select', 'insert', 'update' or 'delete':
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';
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';
CSM_UTIL_PKG.LOG('Entering CSM_SR_PURGE_PKG.Delete_MobileFSObjects',
'CSM_SR_PURGE_PKG.Delete_MobileFSObjects',FND_LOG.LEVEL_PROCEDURE);
CSM_UTIL_PKG.LOG('Leaving CSM_SR_PURGE_PKG.Delete_MobileFSObjects',
'CSM_SR_PURGE_PKG.Delete_MobileFSObjects',FND_LOG.LEVEL_PROCEDURE);
csm_util_pkg.log('CSM_SR_PURGE_PKG.Delete_MobileFSObjects ERROR : ' ||
l_sqlerrno || ':' || l_sqlerrmsg, FND_LOG.LEVEL_EXCEPTION);
END Delete_MobileFSObjects;