APPS.FND_TABLESPACES_PUB SQL Statements

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

Line: 59

  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 );

Line: 111

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';

Line: 127

  SAVEPOINT UPDATE_TABLESPACES_PUB;

Line: 150

    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);

Line: 160

  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 );

Line: 181

        ROLLBACK TO UPDATE_TABLESPACES_PUB;

Line: 188

        ROLLBACK TO UPDATE_TABLESPACES_PUB;

Line: 195

        ROLLBACK TO UPDATE_TABLESPACES_PUB;

Line: 206

END UPDATE_TABLESPACES;

Line: 219

    select 1
    from fnd_tablespaces
    where tablespace_type = p_tablespace_type;

Line: 252

        FND_MESSAGE.Set_Name('FND', 'OATM_NO_INSERT');

Line: 262

  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;

Line: 269

        FND_MESSAGE.Set_Name('FND', 'OATM_NO_UPDATE');