APPS.OKL_SETUPOVERULES_PUB SQL Statements

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

Line: 43

  PROCEDURE insert_overules(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,
                        	p_ovdv_rec         IN  ovdv_rec_type,
                        	x_ovdv_rec         OUT NOCOPY ovdv_rec_type) IS
	l_optv_rec						  optv_rec_type;

Line: 56

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

Line: 61

    SAVEPOINT sp_insert_overules;

Line: 69

	-- call process api to insert formula operands
    okl_setupoverules_pvt.insert_overules(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,
                              			  p_ovdv_rec      => l_ovdv_rec,
                              			  x_ovdv_rec      => x_ovdv_rec);

Line: 93

      ROLLBACK TO sp_insert_overules;

Line: 103

      ROLLBACK TO sp_insert_overules;

Line: 115

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPOVERULES_PUB','insert_overules');

Line: 121

  END insert_overules;

Line: 127

  PROCEDURE delete_overules(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,
                      		p_ovdv_tbl         IN  ovdv_tbl_type) IS
	l_optv_rec						  optv_rec_type;

Line: 140

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

Line: 144

    SAVEPOINT sp_delete_overules;

Line: 152

	-- call process api to delete formula operands
    okl_setupoverules_pvt.delete_overules(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,
                              			  	p_ovdv_tbl      => l_ovdv_tbl);

Line: 172

      ROLLBACK TO sp_delete_overules;

Line: 182

      ROLLBACK TO sp_delete_overules;

Line: 194

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPOVERULES_PUB','delete_overules');

Line: 200

  END delete_overules;