APPS.VEA_EXCEPTIONS_SV SQL Statements

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

Line: 22

       PROCEDURE NAME: insert_row

       PURPOSE: Inserts a record into VEA_EXCEPTIONS table

    ========================================================================*/
    PROCEDURE
      insert_row
        (
          p_exception_id           IN VEA_EXCEPTIONS.exception_id%TYPE,
          p_release_id             IN VEA_EXCEPTIONS.release_id%TYPE,
          p_layer_provider_code    IN VEA_EXCEPTIONS.layer_provider_code%TYPE,
          p_message_name           IN VEA_EXCEPTIONS.message_name%TYPE,
          p_exception_level        IN VEA_EXCEPTIONS.exception_level%TYPE,
          p_message_text           IN VEA_EXCEPTIONS.message_text%TYPE,
          p_description            IN VEA_EXCEPTIONS.description%TYPE
        )
    IS
    --{
        l_api_name            CONSTANT VARCHAR2(30) := 'insert_row';

Line: 51

	INSERT INTO vea_EXCEPTIONS
	  (
            exception_id, release_id, layer_provider_code,
            message_name, exception_level,
            message_text, description,
	    created_by, creation_date,
	    last_updated_by, last_update_date,
	    last_update_login
	  )
	VALUES
	  (
            p_exception_id, p_release_id, p_layer_provider_code,
            p_message_name, p_exception_level,
            p_message_text, p_description,
	    l_user_id, SYSDATE,
	    l_user_id, SYSDATE,
	    l_login_id
	  );

Line: 83

    END insert_row;

Line: 88

       PROCEDURE NAME: update_row

       PURPOSE: Updates a record into VEA_EXCEPTIONS table

    ========================================================================*/
    PROCEDURE
      update_row
        (
          p_exception_id           IN VEA_EXCEPTIONS.exception_id%TYPE,
          p_release_id             IN VEA_EXCEPTIONS.release_id%TYPE,
          p_layer_provider_code    IN VEA_EXCEPTIONS.layer_provider_code%TYPE,
          p_message_name           IN VEA_EXCEPTIONS.message_name%TYPE,
          p_exception_level        IN VEA_EXCEPTIONS.exception_level%TYPE,
          p_message_text           IN VEA_EXCEPTIONS.message_text%TYPE,
          p_description            IN VEA_EXCEPTIONS.description%TYPE
        )
    IS
    --{
        l_api_name            CONSTANT VARCHAR2(30) := 'update_row';

Line: 117

	UPDATE vea_EXCEPTIONS
	SET    release_id                   = p_release_id,
               message_name                 = p_message_name,
               exception_level              = p_exception_level,
               message_text                 = p_message_text,
	       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    exception_id                 = p_exception_id;

Line: 142

    END update_row;

Line: 151

		It inserts/updates a record in VEA_EXCEPTIONS table.

    ========================================================================*/
    PROCEDURE
      process
        (
          p_api_version            IN	  NUMBER,
          p_init_msg_list	   IN	  VARCHAR2 := FND_API.G_FALSE,
          p_commit    		   IN  	  VARCHAR2 := FND_API.G_FALSE,
          p_validation_level	   IN  	  NUMBER   := FND_API.G_VALID_LEVEL_FULL,
          x_return_status	   OUT NOCOPY 	  VARCHAR2,
          x_msg_count	           OUT NOCOPY 	  NUMBER,
          x_msg_data		   OUT NOCOPY 	  VARCHAR2,
          x_id                     OUT NOCOPY     vea_EXCEPTIONS.exception_id%TYPE,
          p_release_id             IN VEA_EXCEPTIONS.release_id%TYPE,
          p_layer_provider_code    IN VEA_EXCEPTIONS.layer_provider_code%TYPE,
          p_message_name           IN VEA_EXCEPTIONS.message_name%TYPE,
          p_exception_level        IN VEA_EXCEPTIONS.exception_level%TYPE,
          p_message_text           IN VEA_EXCEPTIONS.message_text%TYPE,
          p_description            IN VEA_EXCEPTIONS.description%TYPE,
          p_id                     IN VEA_EXCEPTIONS.exception_id%TYPE := NULL
        )
    IS
    --{
        l_api_name            CONSTANT VARCHAR2(30) := 'process';

Line: 226

	        SELECT NVL( x_id, vea_EXCEPTIONS_s.NEXTVAL )
	        INTO   x_id
	        FROM   DUAL;

Line: 234

	        insert_row
	          (
                    p_exception_id                 => x_id,
                    p_release_id                   => p_release_id,
	            p_layer_provider_code          => p_layer_provider_code,
                    p_message_name                 => p_message_name,
                    p_exception_level              => p_exception_level,
                    p_message_text                 => p_message_text,
                    p_description                  => p_description
	          );

Line: 250

	        update_row
	          (
                    p_exception_id                 => x_id,
                    p_release_id                   => p_release_id,
	            p_layer_provider_code          => p_layer_provider_code,
                    p_message_name                 => p_message_name,
                    p_exception_level              => p_exception_level,
                    p_message_text                 => p_message_text,
                    p_description                  => p_description
	          );