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

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

Line: 21


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

Line: 78


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            SFWT_FLAG,
            NVL(FMA_ID, OKL_API.G_MISS_NUM) FMA_ID,
			NVL(DSF_ID, OKL_API.G_MISS_NUM) DSF_ID,
            OPD_TYPE,
            NAME,
            NVL(DESCRIPTION,OKL_API.G_MISS_CHAR) DESCRIPTION,
            VERSION,
            START_DATE,
            NVL(END_DATE,OKL_API.G_MISS_DATE) END_DATE,
            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_Operands_V
     WHERE okl_operands_v.id    = p_id;

Line: 121


              l_opdv_rec.LAST_UPDATED_BY,
              l_opdv_rec.LAST_UPDATE_DATE,
              l_opdv_rec.LAST_UPDATE_LOGIN;

Line: 157


   SELECT '1'
   FROM Okl_Formulae_B fma
   WHERE fma.ID 	=  p_fma_id
   AND ((fma.start_date > p_start_date) OR
  	  (fma.end_date < NVL(p_end_date, TO_DATE('31/12/9999', 'DD/MM/YYYY')))) ;

Line: 224


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

Line: 297


	SELECT '1'
	FROM Okl_Operands_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_Operands_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: 369


    SELECT '1'
    FROM Okl_Data_Src_Fnctns_V dsf
     WHERE dsf.ID    = p_dsf_id
	 AND   (dsf.START_DATE > p_start_date OR
	 	    NVL(dsf.END_DATE, p_end_date) < p_end_date);

Line: 380


    SELECT '1'
    FROM Okl_Formulae_V fma
     WHERE fma.ID    = p_fma_id
	 AND   (fma.START_DATE > p_start_date OR
	 	    NVL(fma.END_DATE, p_end_date) < p_end_date);

Line: 598


    SELECT fma.ID ID,
		   fma.START_DATE START_DATE,
		   NVL(fma.END_DATE, OKL_API.G_MISS_DATE) END_DATE
    FROM Okl_Fmla_Oprnds_V fod,
		 Okl_Formulae_V fma
    WHERE fod.opd_ID    = p_opd_id
	AND   fma.ID = fod.FMA_ID;

Line: 675


  PROCEDURE check_updates (
    p_upd_opdv_rec                 IN opdv_rec_type,
	p_db_opdv_rec				   IN opdv_rec_type,
	p_opdv_rec					   IN opdv_rec_type,
	x_return_status				   OUT NOCOPY VARCHAR2,
	x_msg_data					   OUT NOCOPY VARCHAR2
  ) IS
  l_opdv_rec	  opdv_rec_type;

Line: 769


  END check_updates;

Line: 826


  PROCEDURE insert_operands(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_opdv_rec                     IN  opdv_rec_type,
                        	x_opdv_rec                     OUT NOCOPY opdv_rec_type
                        ) IS
    l_api_version     CONSTANT NUMBER := 1;

Line: 835


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

Line: 898


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

Line: 906


        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSOPB.pls call okl_operands_pub.insert_operands ');

Line: 909


    okl_operands_pub.insert_operands(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_opdv_rec      => l_opdv_rec,
                              		 x_opdv_rec      => x_opdv_rec);

Line: 918


        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSOPB.pls call okl_operands_pub.insert_operands ');

Line: 954


  END insert_operands;

Line: 959


  PROCEDURE update_operands(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_opdv_rec                     IN  opdv_rec_type,
                        	x_opdv_rec                     OUT NOCOPY opdv_rec_type
                        ) IS
    l_api_version     	  	CONSTANT NUMBER := 1;

Line: 968


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

Line: 1078


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

Line: 1086


        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSOPB.pls call okl_operands_pub.update_operands ');

Line: 1089


       okl_operands_pub.update_operands(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_opdv_rec      => l_upd_opdv_rec,
                              		 	x_opdv_rec      => x_opdv_rec);

Line: 1098


        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSOPB.pls call okl_operands_pub.update_operands ');

Line: 1118


	    -- public api to update operands
       okl_operands_pub.update_operands(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_opdv_rec      => l_upd_opdv_rec,
                              		 	x_opdv_rec      => x_opdv_rec);

Line: 1141


	   check_updates(p_upd_opdv_rec	 => l_upd_opdv_rec,
	   			     p_db_opdv_rec	 => l_db_opdv_rec,
					 p_opdv_rec		 => l_opdv_rec,
					 x_return_status => l_return_status,
					 x_msg_data		 => x_msg_data);

Line: 1152


	   -- public api to update operands
       okl_operands_pub.update_operands(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_opdv_rec      => l_upd_opdv_rec,
                              		 	x_opdv_rec      => x_opdv_rec);

Line: 1181


	   -- call verify changes to update the database
	   IF to_date(to_char(l_oldversion_enddate, 'DD/MM/YYYY'), 'DD/MM/YYYY') > to_date(to_char(l_db_opdv_rec.end_date, 'DD/MM/YYYY'), 'DD/MM/YYYY') THEN
	   	  check_updates(p_upd_opdv_rec	=> l_upd_opdv_rec,
	   			     	p_db_opdv_rec	=> l_db_opdv_rec,
					 	p_opdv_rec		=> l_opdv_rec,
					 	x_return_status => l_return_status,
					 	x_msg_data		=> x_msg_data);

Line: 1195


	   -- public api to update operands
       okl_operands_pub.update_operands(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_opdv_rec      => l_opdv_rec,
                              		 	x_opdv_rec      => x_opdv_rec);

Line: 1236


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

Line: 1240


	   	  check_updates(p_upd_opdv_rec	=> l_upd_opdv_rec,
	   				    p_db_opdv_rec	=> l_db_opdv_rec,
					  	p_opdv_rec		=> l_opdv_rec,
					  	x_return_status => l_return_status,
					  	x_msg_data		=> x_msg_data);

Line: 1252


	   -- public api to insert operands -
       okl_operands_pub.insert_operands(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_opdv_rec      => l_opdv_rec,
                              		 	x_opdv_rec      => x_opdv_rec);

Line: 1295


  END update_operands;