APPS.VEA_RELEASE_DETAILS_SV SQL Statements

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

Line: 28

      insert_row
        (
          p_layer_provider_code     IN     vea_release_details.layer_provider_code%TYPE,
          p_release_id              IN     vea_release_details.release_id%TYPE,
          p_file_name               IN     vea_release_details.file_name%TYPE,
          p_version_number          IN     vea_release_details.version_number%TYPE,
          p_application_short_name  IN     vea_release_details.application_short_name%TYPE,
          p_description             IN     vea_release_details.description%TYPE,
          p_aru_number              IN     vea_release_details.aru_number%TYPE,
          p_bug_number              IN     vea_release_details.bug_number%TYPE,
          p_tp_layer_id             IN     vea_release_details.tp_layer_id%TYPE,
          p_file_path               IN     vea_release_details.file_path%TYPE
        )
    IS
    --{
        l_api_name            CONSTANT VARCHAR2(30) := 'insert_row';

Line: 54

        INSERT INTO vea_release_details
          (
            layer_provider_code, release_id,
            file_name, version_number,
            application_short_name,
            description,
	    aru_number, bug_number,
	    tp_layer_id, file_path,
            created_by, creation_date,
            last_updated_by, last_update_date,
            last_update_login
          )
        VALUES
          (
            p_layer_provider_code, p_release_id,
            p_file_name, p_version_number,
            p_application_short_name,
            p_description,
	    p_aru_number, p_bug_number,
	    p_tp_layer_id, p_file_path,
            l_user_id, SYSDATE,
            l_user_id, SYSDATE,
            l_login_id
          );

Line: 92

    END insert_row;

Line: 103

      update_row
        (
          p_layer_provider_code     IN     vea_release_details.layer_provider_code%TYPE,
          p_release_id              IN     vea_release_details.release_id%TYPE,
          p_file_name               IN     vea_release_details.file_name%TYPE,
          p_version_number          IN     vea_release_details.version_number%TYPE,
          p_application_short_name  IN     vea_release_details.application_short_name%TYPE,
          p_description             IN     vea_release_details.description%TYPE,
          p_aru_number              IN     vea_release_details.aru_number%TYPE,
          p_bug_number              IN     vea_release_details.bug_number%TYPE,
          p_tp_layer_id             IN     vea_release_details.tp_layer_id%TYPE,
          p_file_path               IN     vea_release_details.file_path%TYPE
        )
    IS
    --{
        l_api_name            CONSTANT VARCHAR2(30) := 'update_row';

Line: 129

        UPDATE vea_release_details
        SET    version_number               = p_version_number,
               description                  = p_description,
               aru_number                   = p_aru_number,
               bug_number                   = p_bug_number,
               tp_layer_id                  = p_tp_layer_id,
               file_path                    = p_file_path,
               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    file_name                    = p_file_name
        AND    application_short_name       = p_application_short_name;

Line: 157

    END update_row;

Line: 211

          SELECT 1 layer_id,
                 release_id
          FROM   vea_release_details
          WHERE  layer_provider_code     = p_layer_provider_code
          AND    release_id              = p_release_id
          --AND    tp_layer_id              = p_tp_layer_id
          AND    file_name               = p_file_name
          AND    application_short_name  = p_application_short_name;

Line: 298

            insert_row
              (
                p_layer_provider_code     => p_layer_provider_code,
                p_release_id              => l_release_id,
                p_file_name               => p_file_name,
                p_version_number          => p_version_number,
                p_application_short_name  => p_application_short_name,
                p_description             => p_description,
                p_aru_number              => p_aru_number,
                p_bug_number              => p_bug_number,
                p_tp_layer_id             => l_tp_layer_id,
                p_file_path               => p_file_path
              );

Line: 316

            update_row
              (
                p_layer_provider_code     => p_layer_provider_code,
                p_release_id              => l_release_id,
                p_file_name               => p_file_name,
                p_version_number          => p_version_number,
                p_application_short_name  => p_application_short_name,
                p_description             => p_description,
                p_aru_number              => p_aru_number,
                p_bug_number              => p_bug_number,
                p_tp_layer_id             => l_tp_layer_id,
                p_file_path               => p_file_path
              );