APPS.VEA_VERSIONS_SV SQL Statements

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

Line: 28

      insert_row
        (
          p_layer_provider_code     IN     vea_versions.layer_provider_code%TYPE,
          p_release_id              IN     vea_versions.release_id%TYPE,
          p_version_id              IN     vea_versions.version_id%TYPE,
          p_version_number          IN     vea_versions.version_number%TYPE,
          p_description             IN     vea_versions.description%TYPE
        )
    IS
    --{
        l_api_name            CONSTANT VARCHAR2(30) := 'insert_row';

Line: 49

        INSERT INTO vea_versions
          (
            layer_provider_code, release_id,
            version_id, version_number,
            description,
            created_by, creation_date,
            last_updated_by, last_update_date,
            last_update_login
          )
        VALUES
          (
            p_layer_provider_code, p_release_id,
            p_version_id, p_version_number,
            p_description,
            l_user_id, SYSDATE,
            l_user_id, SYSDATE,
            l_login_id
          );

Line: 81

    END insert_row;

Line: 92

      update_row
        (
          p_layer_provider_code     IN     vea_versions.layer_provider_code%TYPE,
          p_release_id              IN     vea_versions.release_id%TYPE,
          p_version_id              IN     vea_versions.version_id%TYPE,
          p_version_number          IN     vea_versions.version_number%TYPE,
          p_description             IN     vea_versions.description%TYPE
        )
    IS
    --{
        l_api_name            CONSTANT VARCHAR2(30) := 'update_row';

Line: 113

        UPDATE vea_versions
        SET    version_number               = p_version_number,
               description                  = p_description,
               last_updated_by              = l_user_id,
               last_update_date             = SYSDATE,
               last_update_login            = l_login_id
        WHERE  layer_provider_code          = p_layer_provider_code
        AND    release_id                   = p_release_id
        AND    version_id                   = p_version_id;

Line: 136

    END update_row;

Line: 184

          SELECT 1 layer_id,
                 version_id
          FROM   vea_versions
          WHERE  layer_provider_code     = p_layer_provider_code
          AND    release_id              = p_release_id
          AND    version_id              = p_version_id
          AND    version_number              = p_version_number;

Line: 267

            insert_row
              (
                p_layer_provider_code     => p_layer_provider_code,
                p_release_id              => l_release_id,
                p_version_id              => l_version_id,
                p_version_number          => p_version_number,
                p_description             => p_description
              );

Line: 280

            update_row
              (
                p_layer_provider_code     => p_layer_provider_code,
                p_release_id              => l_release_id,
                p_version_id              => l_version_id,
                p_version_number          => p_version_number,
                p_description             => p_description
              );