APPS.OKL_SETUP_STREAMTYPES_PUB SQL Statements

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

Line: 94

  PROCEDURE update_stream_type(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_styv_rec                     IN  styv_rec_type,
                        	x_styv_rec                     OUT NOCOPY styv_rec_type
                        ) IS

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

Line: 128

	-- call process api to update formulae
    okl_setup_streamtypes_pvt.update_stream_type(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_styv_rec      => l_styv_rec,
                              			  x_styv_rec      => x_styv_rec);

Line: 173

  END update_stream_type;

Line: 249

  PROCEDURE update_stream_type(
         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_styv_tbl                     IN  styv_tbl_type,
         x_styv_tbl                     OUT NOCOPY styv_tbl_type)
   IS
    l_api_name        	  	CONSTANT VARCHAR2(30)  := 'update_stream_type_tbl';

Line: 278

		update_stream_type(
         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_styv_rec                     => p_styv_tbl(rec_num),
         x_styv_rec                     => x_styv_tbl(rec_num) );

Line: 320

  END update_stream_type;