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

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

Line: 22


    SELECT '1'
    FROM Okl_Formulae_V
    WHERE name = p_name
	AND NVL(end_date,p_date) > p_date;

Line: 79


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            SFWT_FLAG,
            CGR_ID,
            FYP_CODE,
            NAME,
            FORMULA_STRING,
            NVL(DESCRIPTION,OKL_API.G_MISS_CHAR) DESCRIPTION,
            VERSION,
            START_DATE,
            NVL(END_DATE,OKL_API.G_MISS_DATE) END_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,
            NVL(ORG_ID,  OKL_API.G_MISS_NUM) ORG_ID,
            NVL(THERE_CAN_BE_ONLY_ONE_YN, OKL_API.G_MISS_CHAR) THERE_CAN_BE_ONLY_ONE_YN,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            NVL(LAST_UPDATE_LOGIN, OKL_API.G_MISS_NUM) LAST_UPDATE_LOGIN
      FROM Okl_Formulae_V
     WHERE okl_formulae_v.id    = p_id;

Line: 156


              l_fmav_rec.LAST_UPDATED_BY,
              l_fmav_rec.LAST_UPDATE_DATE,
              l_fmav_rec.LAST_UPDATE_LOGIN;

Line: 198


	SELECT '1'
	FROM Okl_Formulae_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_Formulae_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: 271


    SELECT '1'
    FROM Okl_Fmla_Oprnds_V fod,
		   Okl_Operands_V opd
     WHERE fod.FMA_ID    = p_fma_id
	 AND   opd.ID		 = fod.OPD_ID
	 AND   (opd.START_DATE > p_start_date OR
	 	    NVL(opd.END_DATE, p_end_date) < p_end_date);

Line: 280


    SELECT '1'
    FROM Okl_Operands_V opd
     WHERE OPD.FMA_ID    = p_fma_id
	 AND   ((opd.START_DATE < p_start_date) OR
	 	    (NVL(opd.END_DATE, to_date('31/12/9999', 'DD/MM/YYYY'))) >
			(NVL(p_end_date, to_date('31/12/9999', 'DD/MM/YYYY'))));

Line: 345


    SELECT opd.ID ID,
		   opd.START_DATE START_DATE,
		   opd.END_DATE
    FROM Okl_Operands_B opd
    WHERE opd.fma_ID 	= p_fma_id;

Line: 429


   SELECT '1'
   FROM Okl_Operands_B opd
   WHERE opd.FMA_ID 	=  p_fma_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: 720


  PROCEDURE check_updates (
    p_upd_fmav_rec                 IN fmav_rec_type,
	p_db_fmav_rec				   IN fmav_rec_type,
	p_fmav_rec					   IN fmav_rec_type,
	x_return_status				   OUT NOCOPY VARCHAR2,
	x_msg_data					   OUT NOCOPY VARCHAR2
  ) IS
  l_fmav_rec	  fmav_rec_type;

Line: 799


  END check_updates;

Line: 866


    SELECT OPD_ID,
		   LABEL
    FROM Okl_Fmla_Oprnds_V fod
    WHERE fod.FMA_ID    = p_fma_id;

Line: 913


  PROCEDURE insert_formulae(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_fmav_rec                     IN  fmav_rec_type,
                        	x_fmav_rec                     OUT NOCOPY fmav_rec_type
                        ) IS
    l_api_version     CONSTANT NUMBER := 1;

Line: 922


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

Line: 961


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

Line: 969


        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSFMB.pls call okl_formulae_pub.insert_formulae ');

Line: 972


    okl_formulae_pub.insert_formulae(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_fmav_rec      => l_fmav_rec,
                              		 x_fmav_rec      => x_fmav_rec);

Line: 981


        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSFMB.pls call okl_formulae_pub.insert_formulae ');

Line: 1016


  END insert_formulae;

Line: 1021


  PROCEDURE update_formulae(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_fmav_rec                     IN  fmav_rec_type,
                        	x_fmav_rec                     OUT NOCOPY fmav_rec_type
                        ) IS
    l_api_version     	  	CONSTANT NUMBER := 1;

Line: 1030


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

Line: 1151


        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSFMB.pls call okl_formulae_pub.update_formulae ');

Line: 1154


       okl_formulae_pub.update_formulae(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_fmav_rec      => l_upd_fmav_rec,
                              		 	x_fmav_rec      => x_fmav_rec);

Line: 1163


        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSFMB.pls call okl_formulae_pub.update_formulae ');

Line: 1187


       okl_formulae_pub.update_formulae(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_fmav_rec      => l_upd_fmav_rec,
                              		 	x_fmav_rec      => x_fmav_rec);

Line: 1209


	   check_updates(p_upd_fmav_rec	=> l_upd_fmav_rec,
	   			     p_db_fmav_rec	=> l_db_fmav_rec,
					 p_fmav_rec		=> l_fmav_rec,
					 x_return_status => l_return_status,
					 x_msg_data		=> x_msg_data);

Line: 1220


	   -- public api to update formulae
       okl_formulae_pub.update_formulae(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_fmav_rec      => l_upd_fmav_rec,
                              		 	x_fmav_rec      => x_fmav_rec);

Line: 1249


	   -- call verify changes to update the database
	   IF l_oldversion_enddate > l_db_fmav_rec.end_date THEN
	   	  check_updates(p_upd_fmav_rec	=> l_upd_fmav_rec,
	   			     	p_db_fmav_rec	=> l_db_fmav_rec,
					 	p_fmav_rec		=> l_fmav_rec,
					 	x_return_status => l_return_status,
					 	x_msg_data		=> x_msg_data);

Line: 1263


	    public api to update formulae
       okl_formulae_pub.update_formulae(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_fmav_rec      => l_fmav_rec,
                              		 	x_fmav_rec      => x_fmav_rec);

Line: 1306


	   --  call verify changes to update the database
	   IF l_fmav_rec.end_date > l_db_fmav_rec.end_date THEN
	   	  check_updates(p_upd_fmav_rec	=> l_upd_fmav_rec,
	   				    p_db_fmav_rec	=> l_db_fmav_rec,
					  	p_fmav_rec		=> l_fmav_rec,
					  	x_return_status => l_return_status,
					  	x_msg_data		=> x_msg_data);

Line: 1320


	   -- public api to insert formulae
       okl_formulae_pub.insert_formulae(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_fmav_rec      => l_fmav_rec,
                              		 	x_fmav_rec      => x_fmav_rec);

Line: 1348


	   	  okl_fmla_oprnds_pub.insert_fmla_oprnds(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_fodv_tbl      => l_fodv_tbl,
                              		 			 x_fodv_tbl      => l_out_fodv_tbl);

Line: 1390


  END update_formulae;