The following lines contain the word 'select', 'insert', 'update' or 'delete':
FND_TABLESPACES_PKG.INSERT_ROW(
X_ROWID => l_row_id,
P_TABLESPACE_TYPE => P_TABLESPACE_TYPE,
P_TABLESPACE => P_TABLESPACE,
P_CUSTOM_FLAG => 'C',
P_CREATION_DATE => sysdate,
P_CREATED_BY => G_USER_ID,
P_LAST_UPDATE_DATE => sysdate,
P_LAST_UPDATED_BY => G_USER_ID,
P_LAST_UPDATE_LOGIN => G_LOGIN_ID );
PROCEDURE UPDATE_TABLESPACES(
P_Api_Version_Number IN NUMBER,
P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
P_Commit IN VARCHAR2 := FND_API.G_FALSE,
P_TABLESPACE_TYPE IN VARCHAR2,
P_TABLESPACE IN VARCHAR2,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2)
IS
l_api_name CONSTANT VARCHAR2(30) := 'Update_Tablespaces';
SAVEPOINT UPDATE_TABLESPACES_PUB;
P_Validation_mode => AS_UTILITY_PVT.G_UPDATE,
P_TABLESPACE_TYPE => p_tablespace_type,
P_TABLESPACE => p_tablespace,
X_Return_Status => x_return_status,
X_Msg_Count => x_msg_count,
X_Msg_Data => x_msg_data);
FND_TABLESPACES_PKG.UPDATE_ROW(
P_TABLESPACE_TYPE => P_TABLESPACE_TYPE,
P_TABLESPACE => P_TABLESPACE,
P_CUSTOM_FLAG => 'C',
P_LAST_UPDATE_DATE => sysdate,
P_LAST_UPDATED_BY => G_USER_ID,
P_LAST_UPDATE_LOGIN => G_LOGIN_ID );
ROLLBACK TO UPDATE_TABLESPACES_PUB;
ROLLBACK TO UPDATE_TABLESPACES_PUB;
ROLLBACK TO UPDATE_TABLESPACES_PUB;
END UPDATE_TABLESPACES;
select 1
from fnd_tablespaces
where tablespace_type = p_tablespace_type;
FND_MESSAGE.Set_Name('FND', 'OATM_NO_INSERT');
ELSIF (p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
THEN
IF (p_TABLESPACE_TYPE is not NULL AND p_TABLESPACE_TYPE <> FND_API.G_MISS_CHAR)
THEN
OPEN c1;
FND_MESSAGE.Set_Name('FND', 'OATM_NO_UPDATE');