APPS.OKL_SETUPDSFPARAMETERS_PVT SQL Statements

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

Line: 14

    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
			SFWT_FLAG,
			DSF_ID,
			PMR_ID,
			SEQUENCE_NUMBER,
			NVL(VALUE,OKL_API.G_MISS_CHAR) VALUE,
			NVL(INSTRUCTIONS,OKL_API.G_MISS_CHAR) INSTRUCTIONS,
			FPR_TYPE,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            NVL(LAST_UPDATE_LOGIN, OKL_API.G_MISS_NUM) LAST_UPDATE_LOGIN
     FROM Okl_Fnctn_Prmtrs_V
     WHERE okl_Fnctn_Prmtrs_V.id    = p_id;

Line: 51

              l_fprv_rec.LAST_UPDATED_BY,
              l_fprv_rec.LAST_UPDATE_DATE,
              l_fprv_rec.LAST_UPDATE_LOGIN;

Line: 88

    SELECT '1'
    FROM Okl_Fnctn_Prmtrs_V fpr
    WHERE fpr.DSF_ID 		= p_dsf_id
	AND fpr.SEQUENCE_NUMBER = p_sequence_number;

Line: 156

  SELECT '1'
    FROM OKL_PARAMETERS_V
   WHERE OKL_PARAMETERS_V.id = p_id;

Line: 353

  PROCEDURE insert_dsfparameters(p_api_version     IN  NUMBER,
                        		  p_init_msg_list  IN  VARCHAR2 DEFAULT OKL_API.G_FALSE,
                        		  x_return_status  OUT NOCOPY VARCHAR2,
                        		  x_msg_count      OUT NOCOPY NUMBER,
                        		  x_msg_data       OUT NOCOPY VARCHAR2,
								  p_dsfv_rec	   IN  dsfv_rec_type,
                        		  p_fprv_rec       IN  fprv_rec_type,
                        		  x_fprv_rec       OUT NOCOPY fprv_rec_type
                        ) IS
    l_api_version     CONSTANT NUMBER := 1;

Line: 363

    l_api_name        CONSTANT VARCHAR2(30)  := 'insert_dsfparameters';

Line: 407

	/* public api to insert function parameters */
    okl_fnctn_prmtrs_pub.insert_fnctn_prmtrs(p_api_version   => p_api_version,
                              		         p_init_msg_list => p_init_msg_list,
                              		 	   	 x_return_status => l_return_status,
                              		 	   	 x_msg_count     => x_msg_count,
                              		 	   	 x_msg_data      => x_msg_data,
                              		 	   	 p_fprv_rec      => l_fprv_rec,
                              		 	   	 x_fprv_rec      => x_fprv_rec);

Line: 447

  END insert_dsfparameters;

Line: 452

  PROCEDURE update_dsfparameters(p_api_version     IN  NUMBER,
                        		  p_init_msg_list   IN  VARCHAR2 DEFAULT OKL_API.G_FALSE,
                        		  x_return_status   OUT NOCOPY VARCHAR2,
                        		  x_msg_count       OUT NOCOPY NUMBER,
                        		  x_msg_data        OUT NOCOPY VARCHAR2,
								  p_dsfv_rec		IN  dsfv_rec_type,
                        		  p_fprv_rec        IN  fprv_rec_type,
                        		  x_fprv_rec        OUT NOCOPY fprv_rec_type
                        ) IS
    l_api_version     CONSTANT NUMBER := 1;

Line: 462

    l_api_name        CONSTANT VARCHAR2(30)  := 'update_dsfparameters';

Line: 498

	/* public api to insert function parameters */
    okl_fnctn_prmtrs_pub.update_fnctn_prmtrs(p_api_version   => p_api_version,
                              		 	     p_init_msg_list => p_init_msg_list,
                              		 	   	 x_return_status => l_return_status,
                              		 	   	 x_msg_count     => x_msg_count,
                              		 	   	 x_msg_data      => x_msg_data,
                              		 	   	 p_fprv_rec      => l_fprv_rec,
                              		 	   	 x_fprv_rec      => x_fprv_rec);

Line: 538

  END update_dsfparameters;

Line: 545

  PROCEDURE delete_dsfparameters(p_api_version          IN  NUMBER,
                                 p_init_msg_list        IN  VARCHAR2 DEFAULT OKL_API.G_FALSE,
                        		 x_return_status        OUT NOCOPY VARCHAR2,
                        		 x_msg_count            OUT NOCOPY NUMBER,
                        		 x_msg_data             OUT NOCOPY VARCHAR2,
                        		 p_fprv_tbl             IN  fprv_tbl_type
                        ) IS
    l_api_version     CONSTANT NUMBER := 1;

Line: 554

    l_api_name        CONSTANT VARCHAR2(30)  := 'delete_dsfparameters';

Line: 574

	/* delete formulae constraints */
    okl_fnctn_prmtrs_pub.delete_fnctn_prmtrs(p_api_version   => p_api_version,
                              		         p_init_msg_list => p_init_msg_list,
                              		 		 x_return_status => l_return_status,
                              		 		 x_msg_count     => x_msg_count,
                              		 		 x_msg_data      => x_msg_data,
                              		 		 p_fprv_tbl      => l_fprv_tbl);

Line: 613

  END delete_dsfparameters;

Line: 619

  PROCEDURE insert_dsfparameters(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
   	p_dsfv_rec					   IN dsfv_rec_type,
    p_fprv_tbl                     IN fprv_tbl_type,
    x_fprv_tbl                     OUT NOCOPY fprv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 630

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_insert_dsfparameters';

Line: 642

        insert_dsfparameters (
          p_api_version                  => p_api_version,
          p_init_msg_list                => Okl_Api.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          p_dsfv_rec                     => p_dsfv_rec,
          x_msg_data                     => x_msg_data,
          p_fprv_rec                     => p_fprv_tbl(i),
          x_fprv_rec                     => x_fprv_tbl(i));

Line: 700

  END insert_dsfparameters;

Line: 708

  PROCEDURE update_dsfparameters(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
   	p_dsfv_rec					   IN dsfv_rec_type,
    p_fprv_tbl                     IN fprv_tbl_type,
    x_fprv_tbl                     OUT NOCOPY fprv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 719

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_update_dsfparameters';

Line: 732

        update_dsfparameters (
          p_api_version                  => p_api_version,
          p_init_msg_list                => Okl_Api.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          p_dsfv_rec                     => p_dsfv_rec,
          x_msg_data                     => x_msg_data,
          p_fprv_rec                     => p_fprv_tbl(i),
          x_fprv_rec                     => x_fprv_tbl(i));

Line: 791

  END update_dsfparameters;