APPS.OKL_SETUP_PRCPARAMS_PUB SQL Statements

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

Line: 96

  PROCEDURE update_price_parm(p_api_version                  IN  NUMBER,
                              p_init_msg_list                IN  VARCHAR2 DEFAULT G_FALSE,
                              p_sppv_rec                     IN  sppv_rec_type,
                              x_sppv_rec                     OUT NOCOPY sppv_rec_type,
                              x_return_status                OUT NOCOPY VARCHAR2,
                              x_msg_count                    OUT NOCOPY NUMBER,
                              x_msg_data                     OUT NOCOPY VARCHAR2
                        ) IS

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

Line: 130

	-- call process api to update formulae
    OKL_SETUP_PRCPARAMS_pvt.update_price_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_sppv_rec      => l_sppv_rec,
                              			  x_sppv_rec      => x_sppv_rec);

Line: 177

  END update_price_parm;

Line: 230

  PROCEDURE update_price_parm(
         p_api_version                  IN  NUMBER,
         p_init_msg_list                IN  VARCHAR2 DEFAULT G_FALSE,
         p_sppv_tbl                     IN  sppv_tbl_type,
         x_sppv_tbl                     OUT NOCOPY sppv_tbl_type,
         x_return_status                OUT NOCOPY VARCHAR2,
         x_msg_count                    OUT NOCOPY NUMBER,
         x_msg_data                     OUT NOCOPY VARCHAR2)
   IS
    l_api_name        	  	CONSTANT VARCHAR2(30)  := 'update_price_parm';

Line: 244

		update_price_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_sppv_rec                     => p_sppv_tbl(rec_num),
         x_sppv_rec                     => x_sppv_tbl(rec_num) );

Line: 278

  END update_price_parm;