eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SETUPOPTIONS_PVT SQL Statements

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

Line: 17


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            NAME,
            NVL(DESCRIPTION,Okl_Api.G_MISS_CHAR) DESCRIPTION,
            FROM_DATE,
            NVL(TO_DATE,Okl_Api.G_MISS_DATE) TO_DATE,
            NVL(ATTRIBUTE_CATEGORY, Okl_Api.G_MISS_CHAR) ATTRIBUTE_CATEGORY,
            NVL(ATTRIBUTE1, Okl_Api.G_MISS_CHAR) ATTRIBUTE1,
            NVL(ATTRIBUTE2, Okl_Api.G_MISS_CHAR) ATTRIBUTE2,
            NVL(ATTRIBUTE3, Okl_Api.G_MISS_CHAR) ATTRIBUTE3,
            NVL(ATTRIBUTE4, Okl_Api.G_MISS_CHAR) ATTRIBUTE4,
            NVL(ATTRIBUTE5, Okl_Api.G_MISS_CHAR) ATTRIBUTE5,
            NVL(ATTRIBUTE6, Okl_Api.G_MISS_CHAR) ATTRIBUTE6,
            NVL(ATTRIBUTE7, Okl_Api.G_MISS_CHAR) ATTRIBUTE7,
            NVL(ATTRIBUTE8, Okl_Api.G_MISS_CHAR) ATTRIBUTE8,
            NVL(ATTRIBUTE9, Okl_Api.G_MISS_CHAR) ATTRIBUTE9,
            NVL(ATTRIBUTE10, Okl_Api.G_MISS_CHAR) ATTRIBUTE10,
            NVL(ATTRIBUTE11, Okl_Api.G_MISS_CHAR) ATTRIBUTE11,
            NVL(ATTRIBUTE12, Okl_Api.G_MISS_CHAR) ATTRIBUTE12,
            NVL(ATTRIBUTE13, Okl_Api.G_MISS_CHAR) ATTRIBUTE13,
            NVL(ATTRIBUTE14, Okl_Api.G_MISS_CHAR) ATTRIBUTE14,
            NVL(ATTRIBUTE15, Okl_Api.G_MISS_CHAR) ATTRIBUTE15,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            NVL(LAST_UPDATE_LOGIN, Okl_Api.G_MISS_NUM) LAST_UPDATE_LOGIN
      FROM Okl_Options_V
     WHERE okl_options_v.id    = p_id;

Line: 80


              l_optv_rec.LAST_UPDATED_BY,
              l_optv_rec.LAST_UPDATE_DATE,
              l_optv_rec.LAST_UPDATE_LOGIN;

Line: 114


    SELECT ove.ID ID,
           ove.FROM_DATE FROM_DATE,
           ove.TO_DATE TO_DATE
    FROM Okl_opt_Values_V ove
    WHERE ove.opt_id = p_opt_id
    AND   ove.TO_DATE IS NULL;

Line: 173


	SELECT '1'
    FROM Okl_Opt_Rules_V orl,
         Okl_Lse_Scs_Rules_V lsr
    WHERE orl.OPT_ID = p_opt_id
    AND ((orl.LRG_LSE_ID IS NOT NULL
         AND lsr.LSE_ID = orl.LRG_LSE_ID
         AND lsr.SRD_ID = orl.LRG_SRD_ID)
         OR
         (orl.LRG_LSE_ID IS NULL
         AND lsr.LSE_ID IS NULL
         AND lsr.SRD_ID = orl.SRD_ID_FOR))
    AND lsr.RULE_GROUP = orl.RGR_RGD_CODE
    AND lsr.RULE = orl.RGR_RDF_CODE
    AND ((lsr.START_DATE > p_from_date OR
         P_from_date > NVL(lsr.END_DATE,p_from_date)) OR
	     NVL(lsr.END_DATE, p_to_date) < p_to_date);

Line: 195


	SELECT '1'
    FROM Okl_Opt_Values_V ove
     WHERE ove.OPT_ID    = p_opt_id
	 AND   (ove.FROM_DATE < p_from_date OR
	 	    NVL(ove.TO_DATE, ove.FROM_DATE) > p_to_date);

Line: 205


    SELECT '1'
    FROM Okl_Pdt_Opts_V pon
    WHERE pon.OPT_ID    = p_opt_id
    AND (pon.FROM_DATE < p_from_date OR
	     NVL(pon.TO_DATE, pon.FROM_DATE) > p_to_date);

Line: 677


  PROCEDURE check_updates (
    p_upd_optv_rec                 IN optv_rec_type,
	p_db_optv_rec				   IN optv_rec_type,
	p_optv_rec					   IN optv_rec_type,
	x_return_status				   OUT NOCOPY VARCHAR2,
	x_msg_data					   OUT NOCOPY VARCHAR2
  ) IS
  l_optv_rec	  optv_rec_type;

Line: 754


  END check_updates;

Line: 784


  PROCEDURE copy_update_constraints (p_api_version    IN  NUMBER,
                                     p_init_msg_list  IN  VARCHAR2 DEFAULT Okl_Api.G_FALSE,
                                     p_upd_optv_rec   IN  optv_rec_type,
									 x_return_status  OUT NOCOPY VARCHAR2,
                      		 		 x_msg_count      OUT NOCOPY NUMBER,
                              		 x_msg_data       OUT NOCOPY VARCHAR2
  ) IS
	l_upd_optv_rec	 	  	optv_rec_type; /* input copy */

Line: 813


	      Okl_Options_Pub.update_option_values(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_ovev_tbl      => l_ovev_tbl,
                              		 		   x_ovev_tbl      => l_out_ovev_tbl);

Line: 847


  END copy_update_constraints;

Line: 852


  PROCEDURE insert_options(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_optv_rec          IN  optv_rec_type,
                           x_optv_rec          OUT NOCOPY optv_rec_type
                        ) IS
    CURSOR okl_options_unique (p_unique  OKL_OPTIONS_V.NAME%TYPE) IS
    SELECT '1'
       FROM OKL_OPTIONS_V
      WHERE OKL_OPTIONS_V.NAME =  p_unique;

Line: 868


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

Line: 964


  END insert_options;

Line: 969


  PROCEDURE update_options(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_optv_rec                     IN  optv_rec_type,
                        	x_optv_rec                     OUT NOCOPY optv_rec_type
                        ) IS
    l_api_version     	  	CONSTANT NUMBER := 1;

Line: 978


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

Line: 1016


    /* update constraints */
	copy_update_constraints(p_api_version     => p_api_version,
                            p_init_msg_list   => p_init_msg_list,
							p_upd_optv_rec	  => l_upd_optv_rec,
                            x_return_status   => l_return_status,
                    		x_msg_count       => x_msg_count,
                            x_msg_data        => x_msg_data);

Line: 1073


	   /* public api to update options */
       Okl_Options_Pub.update_options(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_optv_rec      => l_upd_optv_rec,
                              		  x_optv_rec      => x_optv_rec);

Line: 1093


	   check_updates(p_upd_optv_rec	 => l_upd_optv_rec,
	   			     p_db_optv_rec	 => l_db_optv_rec,
					 p_optv_rec		 => l_optv_rec,
					 x_return_status => l_return_status,
					 x_msg_data		 => x_msg_data);

Line: 1104


	   /* public api to update options */
       Okl_Options_Pub.update_options(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_optv_rec      => l_upd_optv_rec,
                              		  x_optv_rec      => x_optv_rec);

Line: 1144


  END update_options;