APPS.IEO_SVR_VALUES_PVT SQL Statements

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

Line: 5

     PROCEDURE insert_row(
          x_rowid                          IN OUT NOCOPY VARCHAR2
        , x_value_id                         NUMBER
        , x_created_by                       NUMBER
        , x_creation_date                    DATE
        , x_last_updated_by                  NUMBER
        , x_last_update_date                 DATE
        , x_last_update_login                NUMBER
        , x_value_index                      NUMBER
        , x_param_id                         NUMBER
        , x_server_id                        NUMBER
        , x_value                            VARCHAR2
     ) IS
        CURSOR l_insert IS
          SELECT ROWID
          FROM ieo_svr_values
          WHERE value_id = x_value_id;

Line: 23

        INSERT INTO ieo_svr_values (
          value_id
        , created_by
        , creation_date
        , last_updated_by
        , last_update_date
        , last_update_login
        , value_index
        , param_id
        , server_id
        , value
        ) VALUES (
          x_value_id
        , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
        , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
        , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
        , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
        , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
        , DECODE(x_value_index,FND_API.G_MISS_NUM,NULL,x_value_index)
        , DECODE(x_param_id,FND_API.G_MISS_NUM,NULL,x_param_id)
        , DECODE(x_server_id,FND_API.G_MISS_NUM,NULL,x_server_id)
        , DECODE(x_value,FND_API.G_MISS_CHAR,NULL,x_value)
        );

Line: 47

        OPEN l_insert;

Line: 48

        FETCH l_insert INTO x_rowid;

Line: 49

        IF (l_insert%NOTFOUND) THEN
            CLOSE l_insert;

Line: 53

     END insert_row;

Line: 55

     PROCEDURE delete_row(
        x_value_id                         NUMBER
     ) IS
     BEGIN
        DELETE FROM ieo_svr_values
        WHERE value_id = x_value_id;

Line: 64

     END delete_row;

Line: 66

     PROCEDURE update_row(
          x_rowid                          VARCHAR2
        , x_value_id                       NUMBER
        , x_created_by                     NUMBER
        , x_creation_date                  DATE
        , x_last_updated_by                NUMBER
        , x_last_update_date               DATE
        , x_last_update_login              NUMBER
        , x_value_index                    NUMBER
        , x_param_id                       NUMBER
        , x_server_id                      NUMBER
        , x_value                          VARCHAR2
     ) IS
     BEGIN
        UPDATE ieo_svr_values
        SET
          value_id=DECODE(x_value_id,FND_API.G_MISS_NUM,NULL,x_value_id)
        , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
        , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
        , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
        , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
        , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
        , value_index=DECODE(x_value_index,FND_API.G_MISS_NUM,NULL,x_value_index)
        , param_id=DECODE(x_param_id,FND_API.G_MISS_NUM,NULL,x_param_id)
        , server_id=DECODE(x_server_id,FND_API.G_MISS_NUM,NULL,x_server_id)
        , value=DECODE(x_value,FND_API.G_MISS_CHAR,NULL,x_value)
        WHERE ROWID = x_rowid;

Line: 96

     END update_row;

Line: 103

        , x_last_updated_by                NUMBER
        , x_last_update_date               DATE
        , x_last_update_login              NUMBER
        , x_value_index                    NUMBER
        , x_param_id                       NUMBER
        , x_server_id                      NUMBER
        , x_value                          VARCHAR2
     ) IS
        CURSOR l_lock IS
          SELECT *
          FROM ieo_svr_values
          WHERE rowid = x_rowid
          FOR UPDATE OF value_id NOWAIT;

Line: 122

             FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');

Line: 136

          AND           ((l_table_rec.last_updated_by = x_last_updated_by)
            OR ((l_table_rec.last_updated_by IS NULL)
                AND ( x_last_updated_by IS NULL)))
          AND           ((l_table_rec.last_update_date = x_last_update_date)
            OR ((l_table_rec.last_update_date IS NULL)
                AND ( x_last_update_date IS NULL)))
          AND           ((l_table_rec.last_update_login = x_last_update_login)
            OR ((l_table_rec.last_update_login IS NULL)
                AND ( x_last_update_login IS NULL)))
          AND           ((l_table_rec.value_index = x_value_index)
            OR ((l_table_rec.value_index IS NULL)
                AND ( x_value_index IS NULL)))
          AND           ((l_table_rec.param_id = x_param_id)
            OR ((l_table_rec.param_id IS NULL)
                AND ( x_param_id IS NULL)))
          AND           ((l_table_rec.server_id = x_server_id)
            OR ((l_table_rec.server_id IS NULL)
                AND ( x_server_id IS NULL)))
          AND           ((l_table_rec.value = x_value)
            OR ((l_table_rec.value IS NULL)
                AND ( x_value IS NULL)))
        ) THEN
          RETURN;

Line: 160

          FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');