APPS.OKL_SETUPOPTRULES_PUB SQL Statements

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

Line: 43

  PROCEDURE insert_optrules(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_orlv_rec         IN  orlv_rec_type,
                        	x_orlv_rec         OUT NOCOPY orlv_rec_type) IS
	l_optv_rec						  optv_rec_type;

Line: 54

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

Line: 59

    SAVEPOINT sp_insert_optrules;

Line: 66

	-- call process api to insert formula operands
    okl_setupoptrules_pvt.insert_optrules(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_orlv_rec      => l_orlv_rec,
                              			  x_orlv_rec      => x_orlv_rec);

Line: 89

      ROLLBACK TO sp_insert_optrules;

Line: 99

      ROLLBACK TO sp_insert_optrules;

Line: 111

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPOPTRULES_PUB','insert_optrules');

Line: 117

  END insert_optrules;

Line: 123

  PROCEDURE delete_optrules(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_orlv_tbl         IN  orlv_tbl_type) IS
	l_optv_rec						  optv_rec_type;

Line: 134

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

Line: 138

    SAVEPOINT sp_delete_optrules;

Line: 145

	-- call process api to delete formula operands
    okl_setupoptrules_pvt.delete_optrules(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_orlv_tbl      => l_orlv_tbl);

Line: 164

      ROLLBACK TO sp_delete_optrules;

Line: 174

      ROLLBACK TO sp_delete_optrules;

Line: 186

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPOPTRULES_PUB','delete_optrules');

Line: 192

  END delete_optrules;