APPS.VEA_PARAMETERS_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_PARAMETERS table

    ========================================================================*/
    PROCEDURE
      insert_row
        (
          p_layer_provider_code    IN     vea_parameters.layer_provider_code%TYPE,
          p_parameter_id           IN     vea_parameters.parameter_id%TYPE,
          p_program_unit_id        IN     vea_parameters.program_unit_id%TYPE,
          p_parameter_type         IN     vea_parameters.parameter_type%TYPE,
          p_parameter_seq          IN     vea_parameters.parameter_seq%TYPE,
          p_name                   IN     vea_parameters.name%TYPE,
          p_datatype               IN     vea_parameters.datatype%TYPE,
          p_default_value          IN     vea_parameters.default_value%TYPE,
          p_description            IN     vea_parameters.description%TYPE
        )
    IS
    --{
        l_api_name            CONSTANT VARCHAR2(30) := 'insert_row';

Line: 53

	INSERT INTO vea_parameters
	  (
	    layer_provider_code, parameter_id,
	    program_unit_id, parameter_type,
	    name, parameter_seq,
	    datatype, default_value,
	    description,
	    created_by, creation_date,
	    last_updated_by, last_update_date,
	    last_update_login
	  )
	VALUES
	  (
	    p_layer_provider_code, p_parameter_id,
	    p_program_unit_id, p_parameter_type,
	    p_name, p_parameter_seq,
	    p_datatype, p_default_value,
	    p_description,
	    l_user_id, SYSDATE,
	    l_user_id, SYSDATE,
	    l_login_id
	  );

Line: 89

    END insert_row;

Line: 94

       PROCEDURE NAME: update_row

       PURPOSE: Updates a record into VEA_PARAMETERS table

    ========================================================================*/
    PROCEDURE
      update_row
        (
          p_layer_provider_code    IN     vea_parameters.layer_provider_code%TYPE,
          p_parameter_id           IN     vea_parameters.parameter_id%TYPE,
          p_program_unit_id        IN     vea_parameters.program_unit_id%TYPE,
          p_parameter_type         IN     vea_parameters.parameter_type%TYPE,
          p_parameter_seq          IN     vea_parameters.parameter_seq%TYPE,
          p_name                   IN     vea_parameters.name%TYPE,
          p_datatype               IN     vea_parameters.datatype%TYPE,
          p_default_value          IN     vea_parameters.default_value%TYPE,
          p_description            IN     vea_parameters.description%TYPE
        )
    IS
    --{
        l_api_name            CONSTANT VARCHAR2(30) := 'update_row';

Line: 125

	UPDATE vea_parameters
	SET    program_unit_id              = p_program_unit_id,
	       parameter_type               = p_parameter_type,
	       parameter_seq                = p_parameter_seq,
	       name                         = p_name,
	       datatype                     = p_datatype,
	       default_value                = p_default_value,
	       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    parameter_id                 = p_parameter_id;

Line: 152

    END update_row;

Line: 157

       PROCEDURE NAME: delete_rows

       PURPOSE: Deletes all parameters for the specified program unit

    ========================================================================*/
    PROCEDURE
      delete_rows
        (
          p_layer_provider_code         IN     vea_parameters.layer_provider_code%TYPE,
          p_program_unit_id             IN     vea_parameters.program_unit_id%TYPE
        )
    IS
    --{
        l_api_name            CONSTANT VARCHAR2(30) := 'delete_rows';

Line: 179

        DELETE vea_parameters
        WHERE  layer_provider_code          = p_layer_provider_code
        AND    program_unit_id              = p_program_unit_id;

Line: 196

    END delete_rows;

Line: 228

	  SELECT parameter_id
	  FROM   vea_parameters
	  WHERE  layer_provider_code = p_layer_provider_code
	  AND    program_unit_id     = p_program_unit_id
	  AND    upper(name)         = upper(p_name);

Line: 272

		It inserts/updates a record in VEA_PARAMETERS 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_parameters.parameter_id%TYPE,
          p_layer_provider_code    IN     vea_parameters.layer_provider_code%TYPE,
          p_program_unit_id        IN     vea_parameters.program_unit_id%TYPE,
          p_parameter_type         IN     vea_parameters.parameter_type%TYPE,
          p_parameter_seq          IN     vea_parameters.parameter_seq%TYPE,
          p_name                   IN     vea_parameters.name%TYPE,
          p_datatype               IN     vea_parameters.datatype%TYPE,
          p_default_value          IN     vea_parameters.default_value%TYPE,
          p_description            IN     vea_parameters.description%TYPE,
          p_id                     IN     vea_parameters.parameter_id%TYPE   := NULL,
          p_tp_layer_id            IN     vea_tp_layers.tp_layer_id%TYPE   := NULL
        )
    IS
    --{
        l_api_name            CONSTANT VARCHAR2(30) := 'process';

Line: 319

	  SELECT parameter_id
	  FROM   vea_parameters
	  WHERE  layer_provider_code = p_layer_provider_code
	  AND    program_unit_id     = p_program_unit_id
	  AND    name                = p_name;

Line: 433

	            SELECT NVL( p_id, vea_parameters_s.NEXTVAL )
	            INTO   l_parameter_id
	            FROM   DUAL;

Line: 437

	            SELECT vea_parameters_s.NEXTVAL
	            INTO   l_parameter_id
                    FROM DUAL;

Line: 446

	        insert_row
	          (
	            p_layer_provider_code          => p_layer_provider_code,
	            p_parameter_id                 => l_parameter_id,
	            p_program_unit_id              => l_program_unit_id,
	            p_parameter_type               => p_parameter_type,
	            p_parameter_seq                => p_parameter_seq,
	            p_name                         => p_name,
	            p_datatype                     => p_datatype,
	            p_default_value                => p_default_value,
	            p_description                  => p_description
	          );

Line: 471

	        update_row
	          (
	            p_layer_provider_code          => p_layer_provider_code,
	            p_parameter_id                 => l_parameter_id,
	            p_program_unit_id              => l_program_unit_id,
	            p_parameter_type               => p_parameter_type,
	            p_parameter_seq                => p_parameter_seq,
	            p_name                         => p_name,
	            p_datatype                     => p_datatype,
	            p_default_value                => p_default_value,
	            p_description                  => p_description
	          );