DBA Data[Home] [Help]

APPS.OKL_SETUPDQUALITYS_PUB SQL Statements

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

Line: 64

  PROCEDURE insert_dqualitys(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_pdqv_rec         IN  pdqv_rec_type,
                        	 x_pdqv_rec         OUT NOCOPY pdqv_rec_type) IS
    l_pdqv_rec                        pdqv_rec_type;
Line: 75

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

    SAVEPOINT sp_insert_dqualitys;
Line: 86

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

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSDQB.pls call okl_setupdqualitys_pvt.insert_dqualitys ');
Line: 97

    okl_setupdqualitys_pvt.insert_dqualitys(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_pdqv_rec      => l_pdqv_rec,
                              			    x_pdqv_rec      => x_pdqv_rec);
Line: 106

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPSDQB.pls call okl_setupdqualitys_pvt.insert_dqualitys ');
Line: 125

      ROLLBACK TO sp_insert_dqualitys;
Line: 135

      ROLLBACK TO sp_insert_dqualitys;
Line: 147

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPDQUALITYS_PUB','insert_dqualitys');
Line: 153

  END insert_dqualitys;
Line: 156

  PROCEDURE insert_dqualitys(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_pdqv_tbl         IN  pdqv_tbl_type,
                        	 x_pdqv_tbl         OUT NOCOPY pdqv_tbl_type) IS
    l_pdqv_tbl                        pdqv_tbl_type;
Line: 167

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

    SAVEPOINT sp_insert_dqualitys;
Line: 178

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

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSDQB.pls call okl_setupdqualitys_pvt.insert_dqualitys ');
Line: 189

    okl_setupdqualitys_pvt.insert_dqualitys(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_pdqv_tbl      => l_pdqv_tbl,
                              			    x_pdqv_tbl      => x_pdqv_tbl);
Line: 198

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPSDQB.pls call okl_setupdqualitys_pvt.insert_dqualitys ');
Line: 217

      ROLLBACK TO sp_insert_dqualitys;
Line: 227

      ROLLBACK TO sp_insert_dqualitys;
Line: 239

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPDQUALITYS_PUB','insert_dqualitys');
Line: 245

  END insert_dqualitys;
Line: 251

  PROCEDURE delete_dqualitys(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_ptlv_rec         IN  ptlv_rec_type,
                        	 p_pdqv_tbl         IN  pdqv_tbl_type) IS
    l_pdqv_tbl                        pdqv_tbl_type;
Line: 262

    l_api_name                        CONSTANT VARCHAR2(30)  := 'delete_dqualitys';
Line: 266

    SAVEPOINT sp_delete_dqualitys;
Line: 272

	-- call process api to delete dqualitys
-- Start of wraper code generated automatically by Debug code generator for okl_setupdqualitys_pvt.delete_dqualitys
  IF(L_DEBUG_ENABLED='Y') THEN
    L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
Line: 280

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSDQB.pls call okl_setupdqualitys_pvt.delete_dqualitys ');
Line: 283

    okl_setupdqualitys_pvt.delete_dqualitys(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_pdqv_tbl      => l_pdqv_tbl);
Line: 292

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPSDQB.pls call okl_setupdqualitys_pvt.delete_dqualitys ');
Line: 307

      ROLLBACK TO sp_delete_dqualitys;
Line: 317

      ROLLBACK TO sp_delete_dqualitys;
Line: 329

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPDQUALITYS_PUB','delete_dqualitys');
Line: 335

  END delete_dqualitys;