APPS.OKL_SETUPPMVALUES_PUB SQL Statements

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

Line: 42

  PROCEDURE insert_pmvalues(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_ptlv_rec         IN  ptlv_rec_type,
                        	p_pmvv_rec         IN  pmvv_rec_type,
                        	x_pmvv_rec         OUT NOCOPY pmvv_rec_type) IS
    l_pmvv_rec                        pmvv_rec_type;

Line: 53

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

Line: 58

    SAVEPOINT sp_insert_pmvalues;

Line: 64

	-- call process api to insert Product Template Values.
    okl_SETUPPMVALUES_pvt.insert_pmvalues(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_ptlv_rec      => l_ptlv_rec,
                              			  p_pmvv_rec      => l_pmvv_rec,
                              			  x_pmvv_rec      => x_pmvv_rec);

Line: 87

      ROLLBACK TO sp_insert_pmvalues;

Line: 97

      ROLLBACK TO pm_insert_pmvalues;

Line: 109

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPMVALUES_PUB','insert_pmvalues');

Line: 115

  END insert_pmvalues;

Line: 118

  PROCEDURE insert_pmvalues(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_ptlv_rec         IN  ptlv_rec_type,
                        	p_pmvv_tbl         IN  pmvv_tbl_type,
                        	x_pmvv_tbl         OUT NOCOPY pmvv_tbl_type) IS
    l_pmvv_tbl                        pmvv_tbl_type;

Line: 129

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

Line: 134

    SAVEPOINT sp_insert_pmvalues;

Line: 140

	-- call process api to insert Product Template Values.
    okl_SETUPPMVALUES_pvt.insert_pmvalues(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_ptlv_rec      => l_ptlv_rec,
                              			  p_pmvv_tbl      => l_pmvv_tbl,
                              			  x_pmvv_tbl      => x_pmvv_tbl);

Line: 163

      ROLLBACK TO sp_insert_pmvalues;

Line: 173

      ROLLBACK TO pm_insert_pmvalues;

Line: 185

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPMVALUES_PUB','insert_pmvalues');

Line: 191

  END insert_pmvalues;

Line: 198

  PROCEDURE delete_pmvalues(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_ptlv_rec         IN  ptlv_rec_type,
                        	p_pmvv_tbl         IN  pmvv_tbl_type) IS
    l_pmvv_tbl                        pmvv_tbl_type;

Line: 209

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

Line: 213

    SAVEPOINT sp_delete_pmvalues;

Line: 219

	-- call process api to update Product Template Values.
    okl_SETUPPMVALUES_pvt.delete_pmvalues(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_ptlv_rec     => l_ptlv_rec,
                              			  p_pmvv_tbl      => l_pmvv_tbl);

Line: 238

      ROLLBACK TO sp_delete_pmvalues;

Line: 248

      ROLLBACK TO sp_delete_pmvalues;

Line: 260

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPMVALUES_PUB','delete_pmvalues');

Line: 266

  END delete_pmvalues;