DBA Data[Home] [Help]

APPS.OKL_SETUPPQVALUES_PUB SQL Statements

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

Line: 64

  PROCEDURE insert_pqvalues(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_pqyv_rec         IN  pqyv_rec_type,
							p_pdtv_rec         IN  pdtv_rec_type,
							p_pqvv_rec         IN  pqvv_rec_type,
                        	x_pqvv_rec         OUT NOCOPY pqvv_rec_type
						    ) IS
    l_pqvv_rec                        pqvv_rec_type;
Line: 79

    l_api_name                        CONSTANT VARCHAR2(30)  := 'insert_pqvalues';
Line: 83

    SAVEPOINT sp_insert_pqvalues;
Line: 90

	-- call process api to insert pqvalues
-- Start of wraper code generated automatically by Debug code generator for okl_setuppqvalues_pvt.insert_pqvalues
  IF(L_DEBUG_ENABLED='Y') THEN
    L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
Line: 98

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSUVB.pls call okl_setuppqvalues_pvt.insert_pqvalues ');
Line: 101

    okl_setuppqvalues_pvt.insert_pqvalues(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_pqvv_rec      => l_pqvv_rec,
                              			  x_pqvv_rec      => x_pqvv_rec,
										  p_pqyv_rec      => l_pqyv_rec,
										  p_pdtv_rec      => l_pdtv_rec
										  );
Line: 113

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPSUVB.pls call okl_setuppqvalues_pvt.insert_pqvalues ');
Line: 130

      ROLLBACK TO sp_insert_pqvalues;
Line: 140

      ROLLBACK TO sp_insert_pqvalues;
Line: 152

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPQVALUES_PUB','insert_pqvalues');
Line: 158

  END insert_pqvalues;
Line: 164

  PROCEDURE update_pqvalues(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_pqyv_rec         IN  pqyv_rec_type,
							p_pdtv_rec         IN  pdtv_rec_type,
							p_pqvv_rec         IN  pqvv_rec_type,
                        	x_pqvv_rec         OUT NOCOPY pqvv_rec_type
						    ) IS
    l_pqvv_rec                        pqvv_rec_type;
Line: 179

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_pqvalues';
Line: 183

    SAVEPOINT sp_update_pqvalues;
Line: 190

	-- call process api to update pqvalues
-- Start of wraper code generated automatically by Debug code generator for okl_setuppqvalues_pvt.update_pqvalues
  IF(L_DEBUG_ENABLED='Y') THEN
    L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
Line: 198

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSUVB.pls call okl_setuppqvalues_pvt.update_pqvalues ');
Line: 201

    okl_setuppqvalues_pvt.update_pqvalues(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_pqvv_rec      => l_pqvv_rec,
                              			  x_pqvv_rec      => x_pqvv_rec,
										  p_pqyv_rec      => l_pqyv_rec,
										  p_pdtv_rec      => l_pdtv_rec
										  );
Line: 213

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPSUVB.pls call okl_setuppqvalues_pvt.update_pqvalues ');
Line: 230

      ROLLBACK TO sp_update_pqvalues;
Line: 240

      ROLLBACK TO sp_update_pqvalues;
Line: 252

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPQVALUES_PUB','update_pqvalues');
Line: 258

  END update_pqvalues;
Line: 259

      PROCEDURE insert_pqvalues(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_pqyv_rec         IN  pqyv_rec_type,
							p_pdtv_rec         IN  pdtv_rec_type,
							p_pqvv_tbl         IN  pqvv_tbl_type,
                        	x_pqvv_tbl         OUT NOCOPY pqvv_tbl_type
						    ) IS
  l_pqyv_rec						pqyv_rec_type:= p_pqyv_rec ;
Line: 273

    l_api_name                        CONSTANT VARCHAR2(30)  := 'insert_dqualitys';
Line: 278

    SAVEPOINT sp_insert_pqvalues;
Line: 286

	-- call process api to insert dqualitys
-- Start of wraper code generated automatically by Debug code generator for OKL_SETUPPQVALUES_PUB .insert_pqvalues
  IF(L_DEBUG_ENABLED='Y') THEN
    L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
Line: 294

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSUVB.pls  call OKL_SETUPPQVALUES_PUB.insert_pqvalues ');
Line: 297

   OKL_SETUPPQVALUES_PVT.insert_pqvalues(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_pqyv_rec  =>        l_pqyv_rec,
							p_pdtv_rec     =>  l_pdtv_rec,
							p_pqvv_tbl       =>    l_pqvv_tbl,
                        	x_pqvv_tbl       =>   x_pqvv_tbl);
Line: 307

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPSUVB.pls  call OKL_SETUPPQVALUES_PUB.insert_pqvalues ');
Line: 326

      ROLLBACK TO sp_insert_pqvalues;
Line: 336

      ROLLBACK TO sp_insert_pqvalues;
Line: 348

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPQVALUES_PUB','insert_pqvalues');
Line: 354

  END insert_pqvalues;
Line: 355

      PROCEDURE update_pqvalues(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_pqyv_rec         IN  pqyv_rec_type,
							p_pdtv_rec         IN  pdtv_rec_type,
							p_pqvv_tbl         IN  pqvv_tbl_type,
                        	x_pqvv_tbl         OUT NOCOPY pqvv_tbl_type
						    ) IS
  l_pqyv_rec						pqyv_rec_type:= p_pqyv_rec ;
Line: 369

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_pqvalues';
Line: 374

    SAVEPOINT sp_update_pqvalues;
Line: 382

	-- call process api to insert dqualitys
-- Start of wraper code generated automatically by Debug code generator for OKL_SETUPPQVALUES_PUB .insert_pqvalues
  IF(L_DEBUG_ENABLED='Y') THEN
    L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
Line: 390

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSUVB.pls  call OKL_SETUPPQVALUES_PUB.update_pqvalues ');
Line: 393

  OKL_SETUPPQVALUES_PVT.update_pqvalues(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_pqyv_rec  =>        l_pqyv_rec,
							p_pdtv_rec     =>  l_pdtv_rec,
							p_pqvv_tbl       =>    l_pqvv_tbl,
                        	x_pqvv_tbl       =>   x_pqvv_tbl);
Line: 403

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPSUVB.pls  call OKL_SETUPPQVALUES_PUB.update_pqvalues ');
Line: 422

      ROLLBACK TO sp_update_pqvalues;
Line: 432

      ROLLBACK TO sp_update_pqvalues;
Line: 444

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPQVALUES_PUB','update_pqvalues');
Line: 450

  END update_pqvalues;