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

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

Line: 20


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
			OPD_ID,
			FMA_ID,
			LABEL,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            NVL(LAST_UPDATE_LOGIN, OKL_API.G_MISS_NUM) LAST_UPDATE_LOGIN
     FROM Okl_Fmla_Oprnds_V
     WHERE okl_Fmla_Oprnds_V.id    = p_id;

Line: 49


              l_fodv_rec.LAST_UPDATED_BY,
              l_fodv_rec.LAST_UPDATE_DATE,
              l_fodv_rec.LAST_UPDATE_LOGIN;

Line: 87


    SELECT '1'
    FROM Okl_Operands_V opd,
         Okl_Formulae_V fma
    WHERE opd.ID    = p_opd_id
    AND   fma.ID    = p_fma_id
	AND   (opd.START_DATE > fma.START_DATE  OR
	      NVL(opd.END_DATE, NVL(fma.END_DATE, OKL_API.G_MISS_DATE)) < NVL(fma.END_DATE, OKL_API.G_MISS_DATE));

Line: 141


  PROCEDURE insert_fmaconstraints(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,
                        		  p_fodv_rec        IN  fodv_rec_type,
                        		  x_fodv_rec        OUT NOCOPY fodv_rec_type
                        ) IS
    l_api_version     CONSTANT NUMBER := 1;

Line: 151


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

Line: 189


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

Line: 197


        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSFCB.pls call okl_fmla_oprnds_pub.insert_fmla_oprnds ');

Line: 200


    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_rec      => l_fodv_rec,
                              		 	   x_fodv_rec      => x_fodv_rec);

Line: 209


        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSFCB.pls call okl_fmla_oprnds_pub.insert_fmla_oprnds ');

Line: 245


  END insert_fmaconstraints;

Line: 250


  PROCEDURE update_fmaconstraints(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,
                        		  p_fodv_rec        IN  fodv_rec_type,
                        		  x_fodv_rec        OUT NOCOPY fodv_rec_type
                        ) IS
    l_api_version     CONSTANT NUMBER := 1;

Line: 260


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

Line: 297


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

Line: 305


        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSFCB.pls call okl_fmla_oprnds_pub.update_fmla_oprnds ');

Line: 308


    okl_fmla_oprnds_pub.update_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_rec      => l_fodv_rec,
                              		 	   x_fodv_rec      => x_fodv_rec);

Line: 317


        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSFCB.pls call okl_fmla_oprnds_pub.update_fmla_oprnds ');

Line: 353


  END update_fmaconstraints;

Line: 360


  PROCEDURE delete_fmaconstraints(
                         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_fodv_tbl                     IN  fodv_tbl_type
                        ) IS
    l_api_version     CONSTANT NUMBER := 1;

Line: 370


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

Line: 390


	/* delete formulae constraints */
-- Start of wraper code generated automatically by Debug code generator for okl_fmla_oprnds_pub.delete_fmla_oprnds
  IF(L_DEBUG_ENABLED='Y') THEN
    L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;

Line: 398


        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSFCB.pls call okl_fmla_oprnds_pub.delete_fmla_oprnds ');

Line: 401


    okl_fmla_oprnds_pub.delete_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);

Line: 409


        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSFCB.pls call okl_fmla_oprnds_pub.delete_fmla_oprnds ');

Line: 445


  END delete_fmaconstraints;

Line: 449


  PROCEDURE insert_fmaconstraints(
                         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
                        ,p_fodv_tbl                     IN  fodv_tbl_type
                        ,x_fodv_tbl                     OUT NOCOPY fodv_tbl_type
                        ) IS
    l_fodv_tbl                        fodv_tbl_type;

Line: 462


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

Line: 469


    SAVEPOINT insert_fmaconstraints;

Line: 478


        insert_fmaconstraints (
                           p_api_version   => p_api_version
                          ,p_init_msg_list => p_init_msg_list
                          ,x_return_status => x_return_status
                          ,x_msg_count     => x_msg_count
                          ,x_msg_data      => x_msg_data
                          ,p_fmav_rec     => p_fmav_rec
                          ,p_fodv_rec      => p_fodv_tbl(i)
                          ,x_fodv_rec      => x_fodv_tbl(i)
                          );

Line: 518


      ROLLBACK TO insert_fmaconstraints;

Line: 526


      ROLLBACK TO insert_fmaconstraints;

Line: 533


      FND_MSG_PUB.ADD_EXC_MSG('OKL_fmaconstraints_PUB','insert_fmaconstraints');

Line: 540


 END insert_fmaconstraints;

Line: 544


PROCEDURE update_fmaconstraints(
                         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
                        ,p_fodv_tbl                     IN  fodv_tbl_type
                        ,x_fodv_tbl                     OUT NOCOPY fodv_tbl_type
                        ) IS
    l_fodv_tbl                        fodv_tbl_type;

Line: 557


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

Line: 564


    SAVEPOINT update_fmaconstraints;

Line: 573


        update_fmaconstraints (
                           p_api_version   => p_api_version
--start:|  20-Nov-08 cklee/smadhava Bug# 7439737/7298457
--                          ,p_init_msg_list => p_init_msg_list
-- Bug# 7298457 - Donot reset message list- passing 'T' overwrites the error messages of previous operands
                          ,p_init_msg_list => OKL_API.G_FALSE
--end:|  20-Nov-08 cklee/smadhava Bug# 7439737/7298457
                          ,x_return_status => x_return_status
                          ,x_msg_count     => x_msg_count
                          ,x_msg_data      => x_msg_data
                          ,p_fmav_rec     => p_fmav_rec
                          ,p_fodv_rec      => p_fodv_tbl(i)
                          ,x_fodv_rec      => x_fodv_tbl(i)
                          );

Line: 619


      ROLLBACK TO update_fmaconstraints;

Line: 627


      ROLLBACK TO update_fmaconstraints;

Line: 634


      FND_MSG_PUB.ADD_EXC_MSG('OKL_fmaconstraints_PUB','update_fmaconstraints');

Line: 641


  END update_fmaconstraints;