APPS.OKL_SETUP_TRXPARAMS_PUB SQL Statements

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

Line: 94

  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_name        	  	CONSTANT VARCHAR2(30)  := 'update_trx_parm';

Line: 128

	-- call process api to update formulae
    OKL_SETUP_TRXPARAMS_PVT.update_trx_parm(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: 172

END update_trx_parm;

Line: 246

  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
    l_api_name        	  	CONSTANT VARCHAR2(30)  := 'update_trx_parm_tbl';

Line: 276

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

Line: 316

 END update_trx_parm;

Line: 322

  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

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

Line: 356

	-- call process api to delete formulae
    OKL_SETUP_TRXPARAMS_PVT.delete_trx_parm(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: 402

  END delete_trx_parm;

Line: 404

  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
      l_api_name        	  	CONSTANT VARCHAR2(30)  := 'delete_trx_parm_tbl';

Line: 434

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

Line: 475

    END delete_trx_parm;

Line: 567

  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_name        	  	CONSTANT VARCHAR2(30)  := 'update_trx_asset_parm';

Line: 601

	-- call process api to update formulae
    OKL_SETUP_TRXPARAMS_PVT.update_trx_asset_parm(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: 645

END update_trx_asset_parm;

Line: 719

  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
    l_api_name        	  	CONSTANT VARCHAR2(30)  := 'update_trx_asset_parm_tbl';

Line: 749

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

Line: 789

 END update_trx_asset_parm;