APPS.OKL_SETUPPOPTIONS_PUB SQL Statements

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

Line: 43

  PROCEDURE insert_poptions(p_api_version      IN  NUMBER,
                            p_init_msg_list    IN  VARCHAR2 DEFAULT OKL_API.G_FALSE,
                        	x_return_status    OUT NOCOPY VARCHAR2,
                        	x_msg_count        OUT NOCOPY NUMBER,
                        	x_msg_data         OUT NOCOPY VARCHAR2,
							p_pdtv_rec         IN  pdtv_rec_type,
                        	p_ponv_rec         IN  ponv_rec_type,
                        	x_ponv_rec         OUT NOCOPY ponv_rec_type
  					        ) IS
    l_ponv_rec                        ponv_rec_type;

Line: 55

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

Line: 60

    SAVEPOINT sp_insert_poptions;

Line: 66

	-- call process api to insert poptions
    okl_setuppoptions_pvt.insert_poptions(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_ponv_rec      => l_ponv_rec,
                              			  x_ponv_rec      => x_ponv_rec,
										  p_pdtv_rec      => l_pdtv_rec
										  );

Line: 87

      ROLLBACK TO sp_insert_poptions;

Line: 97

      ROLLBACK TO sp_insert_poptions;

Line: 109

      FND_MSG_PUB.ADD_EXC_MSG('OKL_setuppoptions_PUB','insert_poptions');

Line: 115

  END insert_poptions;

Line: 121

  PROCEDURE delete_poptions(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_pdtv_rec         IN  pdtv_rec_type,
                        	p_ponv_tbl         IN  ponv_tbl_type) IS
    l_ponv_tbl                        ponv_tbl_type;

Line: 132

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

Line: 136

    SAVEPOINT sp_delete_poptions;

Line: 142

	-- call process api to update formulae
    okl_setuppoptions_pvt.delete_poptions(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_pdtv_rec      => l_pdtv_rec,
                              			  p_ponv_tbl      => l_ponv_tbl);

Line: 161

      ROLLBACK TO sp_delete_poptions;

Line: 171

      ROLLBACK TO sp_delete_poptions;

Line: 183

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPOPTIONS_PUB','delete_poptions');

Line: 189

  END delete_poptions;