APPS.VEA_LAYER_LICENSES_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_LAYER_LICENSES table

    ========================================================================*/
    PROCEDURE
      insert_row
        (
          p_layer_provider_code        IN     vea_layer_licenses.layer_provider_code%TYPE,
          p_customer_name              IN     vea_layer_licenses.customer_name%TYPE,
          p_description                IN     vea_layer_licenses.description%TYPE,
          p_tp_layer_id                IN     vea_layer_licenses.tp_layer_id%TYPE
        )
    IS
    --{
        l_api_name            CONSTANT VARCHAR2(30) := 'insert_row';

Line: 48

        INSERT INTO vea_layer_licenses
          (
            layer_provider_code,
            customer_name,
            description,
	    tp_layer_id,
            created_by, creation_date,
            last_updated_by, last_update_date,
            last_update_login
          )
        VALUES
          (
            p_layer_provider_code,
            p_customer_name,
            p_description,
	    p_tp_layer_id,
            l_user_id, SYSDATE,
            l_user_id, SYSDATE,
            l_login_id
          );

Line: 82

    END insert_row;

Line: 87

       PROCEDURE NAME: update_row

       PURPOSE: Updates a record into VEA_LAYER_LICENSES table

    ========================================================================*/
    PROCEDURE
      update_row
        (
          p_layer_provider_code        IN     vea_layer_licenses.layer_provider_code%TYPE,
          p_customer_name              IN     vea_layer_licenses.customer_name%TYPE,
          p_description                IN     vea_layer_licenses.description%TYPE,
          p_tp_layer_id                IN     vea_layer_licenses.tp_layer_id%TYPE
        )
    IS
    --{
        l_api_name            CONSTANT VARCHAR2(30) := 'update_row';

Line: 113

        UPDATE vea_layer_licenses
        SET    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    tp_layer_id                  = p_tp_layer_id
        AND    customer_name                = p_customer_name;

Line: 135

    END update_row;

Line: 168

	  SELECT 'x'
	  FROM   vea_layer_licenses
	  WHERE  layer_provider_code = p_layer_provider_code
	  AND    tp_layer_id         = p_tp_layer_id;

Line: 264

       PROCEDURE NAME: delete_rows

       PURPOSE: Deletes all licenses for the specified TP Layer.

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

Line: 288

        DELETE vea_layer_licenses
        WHERE  layer_provider_code          = p_layer_provider_code
	AND    tp_layer_id                  = p_tp_layer_id;

Line: 305

    END delete_rows;

Line: 314

		It inserts/updates a record in VEA_LAYER_LICENSES 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,
          p_layer_provider_code        IN     vea_layer_licenses.layer_provider_code%TYPE,
          p_customer_name              IN     vea_layer_licenses.customer_name%TYPE,
          p_description                IN     vea_layer_licenses.description%TYPE,
          p_tp_layer_id                IN     vea_layer_licenses.tp_layer_id%TYPE
        )
    IS
    --{
        l_api_name            CONSTANT VARCHAR2(30) := 'process';

Line: 352

          SELECT 1 id
          FROM   vea_layer_licenses
          WHERE  layer_provider_code       = p_layer_provider_code
          AND    tp_layer_id               = p_tp_layer_id
          AND    customer_name             = p_customer_name;

Line: 436

                insert_row
                  (
                    p_layer_provider_code       => p_layer_provider_code,
                    p_customer_name             => p_customer_name,
                    p_description               => p_description,
		    p_tp_layer_id               => l_tp_layer_id
                  );

Line: 448

                update_row
                  (
                    p_layer_provider_code       => p_layer_provider_code,
                    p_customer_name             => p_customer_name,
                    p_description               => p_description,
		    p_tp_layer_id               => l_tp_layer_id
                  );