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_SETUPFUNCTIONS_PVT SQL Statements

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

Line: 22


    SELECT '1'
    FROM Okl_Data_Src_Fnctns_V
    WHERE name = p_name
	AND NVL(end_date,OKL_API.G_MISS_DATE) > p_date;

Line: 80


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            SFWT_FLAG,
            NVL(FNCTN_CODE, OKL_API.G_MISS_CHAR) FNCTN_CODE,
            NAME,
            NVL(DESCRIPTION,OKL_API.G_MISS_CHAR) DESCRIPTION,
            VERSION,
            START_DATE,
            NVL(END_DATE,OKL_API.G_MISS_DATE) END_DATE,
			SOURCE,
            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,
            NVL(ORG_ID,  OKL_API.G_MISS_NUM) ORG_ID,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            NVL(LAST_UPDATE_LOGIN, OKL_API.G_MISS_NUM) LAST_UPDATE_LOGIN
      FROM Okl_Data_Src_Fnctns_V
     WHERE okl_Data_Src_Fnctns_v.id    = p_id;

Line: 153


              l_dsfv_rec.LAST_UPDATED_BY,
              l_dsfv_rec.LAST_UPDATE_DATE,
              l_dsfv_rec.LAST_UPDATE_LOGIN;

Line: 193


	SELECT '1'
	FROM Okl_Data_Src_Fnctns_V
	WHERE NAME = p_name
	AND   ID <> p_id
	AND	  (p_start_date BETWEEN START_DATE AND NVL(END_DATE, OKL_API.G_MISS_DATE) OR
		   p_end_date BETWEEN START_DATE AND NVL(END_DATE, OKL_API.G_MISS_DATE))
    UNION ALL
	SELECT '2'
	FROM Okl_Data_Src_Fnctns_V
	WHERE NAME = p_name
	AND   ID <> p_id
	AND	  p_start_date <= START_DATE
	AND   p_end_date >= NVL(END_DATE, OKL_API.G_MISS_DATE);

Line: 475


   SELECT '1'
   FROM Okl_Operands_B opd
   WHERE opd.DSF_ID 	=  p_dsf_id
   AND ((opd.start_date < p_start_date) OR
  	  (NVL(opd.end_date, TO_DATE('31/12/9999', 'DD/MM/YYYY')) > p_end_date )) ;

Line: 540


  PROCEDURE check_updates (
    p_upd_dsfv_rec                 IN dsfv_rec_type,
	p_db_dsfv_rec				   IN dsfv_rec_type,
	p_dsfv_rec					   IN dsfv_rec_type,
	x_return_status				   OUT NOCOPY VARCHAR2,
	x_msg_data					   OUT NOCOPY VARCHAR2
  ) IS
  l_dsfv_rec	  		dsfv_rec_type;

Line: 616


  END check_updates;

Line: 670


  PROCEDURE insert_functions(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,
                        	 x_dsfv_rec         OUT NOCOPY dsfv_rec_type
                        ) IS
    l_api_version     CONSTANT NUMBER := 1;

Line: 679


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

Line: 716


	/* public api to insert functions */
-- Start of wraper code generated automatically by Debug code generator for okl_data_src_fnctns_pub.insert_data_src_fnctns
  IF(L_DEBUG_ENABLED='Y') THEN
    L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;

Line: 724


        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDFB.pls call okl_data_src_fnctns_pub.insert_data_src_fnctns ');

Line: 727


    okl_data_src_fnctns_pub.insert_data_src_fnctns(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_dsfv_rec      => l_dsfv_rec,
                              		 			   x_dsfv_rec      => x_dsfv_rec);

Line: 736


        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSDFB.pls call okl_data_src_fnctns_pub.insert_data_src_fnctns ');

Line: 772


  END insert_functions;

Line: 777


  PROCEDURE update_functions(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,
                        	x_dsfv_rec                     OUT NOCOPY dsfv_rec_type
                        ) IS
    l_api_version     	  	CONSTANT NUMBER := 1;

Line: 786


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

Line: 879


	   /* public api to update functions */
-- Start of wraper code generated automatically by Debug code generator for okl_data_src_fnctns_pub.update_data_src_fnctns
  IF(L_DEBUG_ENABLED='Y') THEN
    L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;

Line: 887


        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDFB.pls call okl_data_src_fnctns_pub.update_data_src_fnctns ');

Line: 890


       okl_data_src_fnctns_pub.update_data_src_fnctns(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_dsfv_rec      => l_upd_dsfv_rec,
                              		 				  x_dsfv_rec      => x_dsfv_rec);

Line: 899


        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSDFB.pls call okl_data_src_fnctns_pub.update_data_src_fnctns ');

Line: 920


	   -- public api to update functions
       okl_data_src_fnctns_pub.update_data_src_fnctns(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_dsfv_rec      => l_upd_dsfv_rec,
                              		 				  x_dsfv_rec      => x_dsfv_rec);

Line: 942


	   check_updates(p_upd_dsfv_rec	 => l_upd_dsfv_rec,
	   			     p_db_dsfv_rec	 => l_db_dsfv_rec,
					 p_dsfv_rec		 => l_dsfv_rec,
					 x_return_status => l_return_status,
					 x_msg_data		 => x_msg_data);

Line: 953


	   -- public api to update functions
       okl_data_src_fnctns_pub.update_data_src_fnctns(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_dsfv_rec      => l_upd_dsfv_rec,
                              		 				  x_dsfv_rec      => x_dsfv_rec);

Line: 982


	    call verify changes to update the database
	   IF l_oldversion_enddate > l_db_dsfv_rec.end_date THEN
	   	  check_updates(p_upd_dsfv_rec	=> l_upd_dsfv_rec,
	   			     	p_db_dsfv_rec	=> l_db_dsfv_rec,
					 	p_dsfv_rec		=> l_dsfv_rec,
					 	x_return_status => l_return_status,
					 	x_msg_data		=> x_msg_data);

Line: 996


	   -- public api to update functions
       okl_data_src_fnctns_pub.update_data_src_fnctns(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_dsfv_rec      => l_dsfv_rec,
                              		 				  x_dsfv_rec      => x_dsfv_rec);

Line: 1038


	   -- call verify changes to update the database
	   l_dsfv_rec.id := OKL_API.G_MISS_NUM;

Line: 1042


	   	  check_updates(p_upd_dsfv_rec	=> l_upd_dsfv_rec,
	   				    p_db_dsfv_rec	=> l_db_dsfv_rec,
					  	p_dsfv_rec		=> l_dsfv_rec,
					  	x_return_status => l_return_status,
					  	x_msg_data		=> x_msg_data);

Line: 1054


	   -- public api to insert functions
       okl_data_src_fnctns_pub.insert_data_src_fnctns(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_dsfv_rec      => l_dsfv_rec,
                              		 				  x_dsfv_rec      => x_dsfv_rec);

Line: 1098


  END update_functions;