APPS.OKL_SETUPPOVALUES_PUB SQL Statements

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

Line: 43

  PROCEDURE insert_povalues(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_optv_rec           IN  optv_rec_type,
							p_povv_rec           IN  povv_rec_type,
							x_povv_rec           OUT NOCOPY povv_rec_type
							) IS
    l_povv_rec                        povv_rec_type;

Line: 58

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

Line: 63

    SAVEPOINT sp_insert_povalues;

Line: 70

	-- call process api to insert Product Option Values
    okl_SETUPPOVALUES_pvt.insert_povalues(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_povv_rec      => l_povv_rec,
                              			  x_povv_rec      => x_povv_rec,
			  							  p_pdtv_rec      => l_pdtv_rec,
										  p_optv_rec      => l_optv_rec
										  );

Line: 95

      ROLLBACK TO sp_insert_povalues;

Line: 105

      ROLLBACK TO sp_insert_povalues;

Line: 117

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPOVALUES_PUB','insert_povalues');

Line: 123

  END insert_povalues;

Line: 129

  PROCEDURE delete_povalues(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_optv_rec           IN  optv_rec_type,
							P_povv_tbl         IN povv_tbl_type) IS
    l_povv_tbl                        povv_tbl_type;

Line: 142

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

Line: 146

    SAVEPOINT sp_delete_povalues;

Line: 153

	-- call process api to delete_povalues
    okl_SETUPPOVALUES_pvt.delete_povalues(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_optv_rec      => l_optv_rec,
                              			  p_povv_tbl      => l_povv_tbl);

Line: 173

      ROLLBACK TO sp_delete_povalues;

Line: 183

      ROLLBACK TO sp_delete_povalues;

Line: 195

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPOVALUES_PUB','delete_povalues');

Line: 201

  END delete_povalues;