APPS.OKL_SETUPOPTVALUES_PUB SQL Statements

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

Line: 43

  PROCEDURE insert_optvalues(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_optv_rec		 IN  optv_rec_type,
                        	 p_ovev_rec         IN  ovev_rec_type,
                        	 x_ovev_rec         OUT NOCOPY ovev_rec_type) IS
	l_optv_rec						  optv_rec_type;

Line: 54

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

Line: 59

    SAVEPOINT sp_insert_optvalues;

Line: 66

	-- call process api to insert formula operands
    okl_setupoptvalues_pvt.insert_optvalues(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_optv_rec      => l_optv_rec,
                              			  	p_ovev_rec      => l_ovev_rec,
                              			  	x_ovev_rec      => x_ovev_rec);

Line: 89

      ROLLBACK TO sp_insert_optvalues;

Line: 99

      ROLLBACK TO sp_insert_optvalues;

Line: 111

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPOPTVALUES_PUB','insert_optvalues');

Line: 117

  END insert_optvalues;

Line: 123

  PROCEDURE update_optvalues(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_optv_rec		 IN  optv_rec_type,
                      			  p_ovev_rec         IN  ovev_rec_type,
                        		  x_ovev_rec         OUT NOCOPY ovev_rec_type) IS
	l_optv_rec						  optv_rec_type;

Line: 135

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

Line: 139

    SAVEPOINT sp_update_optvalues;

Line: 146

	-- call process api to update formula operands
    okl_setupoptvalues_pvt.update_optvalues(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_optv_rec      => l_optv_rec,
                              			  	p_ovev_rec      => l_ovev_rec,
                              			  	x_ovev_rec      => x_ovev_rec);

Line: 169

      ROLLBACK TO sp_update_optvalues;

Line: 179

      ROLLBACK TO sp_update_optvalues;

Line: 191

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPOPTVALUES_PUB','update_optvalues');

Line: 197

  END update_optvalues;