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

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

Line: 20


     SELECT NVL(MAX(INDEX_NUMBER1),0)
     FROM OKL_SIF_TRX_PARMS TRX
     WHERE TRX.SIF_ID = p_sxpv_rec.sif_id
     AND TRX.SPP_ID = p_sxpv_rec.spp_id;

Line: 47


	/* public api to insert streamtype */
    okl_sif_trx_parms_pub.insert_sif_trx_parms(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_sxpv_rec      => l_sxpv_rec,
                              		 x_sxpv_rec      => x_sxpv_rec);

Line: 92


  PROCEDURE update_trx_parm(p_api_version                  IN  NUMBER,
                            p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
                        	x_return_status                OUT NOCOPY VARCHAR2,
                        	x_msg_count                    OUT NOCOPY NUMBER,
                        	x_msg_data                     OUT NOCOPY VARCHAR2,
                        	p_sxpv_rec                     IN  sxpv_rec_type,
                        	x_sxpv_rec                     OUT NOCOPY sxpv_rec_type
                        ) IS
    l_api_version     	  	CONSTANT NUMBER := 1;

Line: 101


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

Line: 108


   /* public api to update formulae */
      okl_sif_trx_parms_pub.update_sif_trx_parms(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_sxpv_rec      => l_sxpv_rec,
                             		 	x_sxpv_rec      => x_sxpv_rec);

Line: 142


  END update_trx_parm;

Line: 197


  PROCEDURE update_trx_parm(
         p_api_version                  IN  NUMBER,
         p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
         x_return_status                OUT NOCOPY VARCHAR2,
         x_msg_count                    OUT NOCOPY NUMBER,
         x_msg_data                     OUT NOCOPY VARCHAR2,
         p_sxpv_tbl                     IN  sxpv_tbl_type,
         x_sxpv_tbl                     OUT NOCOPY sxpv_tbl_type)
   IS
	rec_num		INTEGER	:= 0;

Line: 216


		update_trx_parm(
         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_sxpv_rec                     => l_sxpv_tbl(rec_num),
         x_sxpv_rec                     => x_sxpv_tbl(rec_num) );

Line: 246


  END update_trx_parm;

Line: 251


  PROCEDURE delete_trx_parm(p_api_version                  IN  NUMBER,
                            p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
                        	x_return_status                OUT NOCOPY VARCHAR2,
                        	x_msg_count                    OUT NOCOPY NUMBER,
                        	x_msg_data                     OUT NOCOPY VARCHAR2,
                        	p_sxpv_rec                     IN  sxpv_rec_type,
                        	x_sxpv_rec                     OUT NOCOPY sxpv_rec_type
                        ) IS

    CURSOR l_okl_sxp_csr(p_rec sxpv_rec_type)
	IS
	  SELECT ID
	  FROM OKL_SIF_TRX_PARMS
	  WHERE SIF_ID = p_rec.sif_id
	  AND	SPP_ID = p_rec.spp_id;

Line: 269


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

Line: 305


	     /* public api to delete trxparms */
	    okl_sif_trx_parms_pub.delete_sif_trx_parms(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_sxpv_tbl      => l_sxpv_tbl,
	                           		 	x_sxpv_tbl      => x_sxpv_tbl);

Line: 339


  END delete_trx_parm;

Line: 341


  PROCEDURE delete_trx_parm(
         p_api_version                  IN  NUMBER,
         p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
         x_return_status                OUT NOCOPY VARCHAR2,
         x_msg_count                    OUT NOCOPY NUMBER,
         x_msg_data                     OUT NOCOPY VARCHAR2,
         p_sxpv_tbl                     IN  sxpv_tbl_type,
         x_sxpv_tbl                     OUT NOCOPY sxpv_tbl_type)
   IS
	rec_num		INTEGER	:= 0;

Line: 354


		delete_trx_parm(
         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_sxpv_rec                     => p_sxpv_tbl(rec_num),
         x_sxpv_rec                     => x_sxpv_tbl(rec_num) );

Line: 384


  END delete_trx_parm;

Line: 444


  PROCEDURE update_trx_asset_parm(	p_api_version                  IN  NUMBER,
	                            p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
	 	                       	x_return_status                OUT NOCOPY VARCHAR2,
 	 	                      	x_msg_count                    OUT NOCOPY NUMBER,
  	 	                     	x_msg_data                     OUT NOCOPY VARCHAR2,
   	 	                    	p_sxpv_rec                     IN  sxpv_rec_type,
      		                  	x_sxpv_rec                     OUT NOCOPY sxpv_rec_type
                        ) IS
    l_api_version     CONSTANT NUMBER := 1;

Line: 453


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

Line: 463


		update_trx_parm(
         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_sxpv_rec                     => p_sxpv_rec,
         x_sxpv_rec                     => x_sxpv_rec );

Line: 494


  END update_trx_asset_parm;

Line: 546


  PROCEDURE update_trx_asset_parm(
         p_api_version                  IN  NUMBER,
         p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
         x_return_status                OUT NOCOPY VARCHAR2,
         x_msg_count                    OUT NOCOPY NUMBER,
         x_msg_data                     OUT NOCOPY VARCHAR2,
         p_sxpv_tbl                     IN  sxpv_tbl_type,
         x_sxpv_tbl                     OUT NOCOPY sxpv_tbl_type)
   IS
	rec_num		INTEGER	:= 0;

Line: 566


		update_trx_asset_parm(
         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_sxpv_rec                     => l_sxpv_tbl(rec_num),
         x_sxpv_rec                     => x_sxpv_tbl(rec_num) );

Line: 595


  END update_trx_asset_parm;