APPS.OKL_SETUPPRODUCTS_PUB SQL Statements

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

Line: 130

  PROCEDURE insert_products(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,
                        	x_pdtv_rec         OUT NOCOPY pdtv_rec_type) IS
    l_pdtv_rec                        pdtv_rec_type;

Line: 139

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

Line: 144

    SAVEPOINT sp_insert_products;

Line: 147

	-- call process api to insert products
-- Start of wraper code generated automatically by Debug code generator for okl_setupproducts_pvt.insert_products
  IF(L_DEBUG_ENABLED='Y') THEN
    L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;

Line: 155

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSPDB.pls call okl_setupproducts_pvt.insert_products ');

Line: 158

    okl_setupproducts_pvt.insert_products(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,
                              			  x_pdtv_rec      => x_pdtv_rec);

Line: 167

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPSPDB.pls call okl_setupproducts_pvt.insert_products ');

Line: 184

      ROLLBACK TO sp_insert_products;

Line: 194

      ROLLBACK TO sp_insert_products;

Line: 206

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPRODUCTS_PUB','insert_products');

Line: 212

  END insert_products;

Line: 218

  PROCEDURE update_products(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,
                        	x_pdtv_rec         OUT NOCOPY pdtv_rec_type) IS
    l_pdtv_rec                        pdtv_rec_type;

Line: 228

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

Line: 232

    SAVEPOINT sp_update_products;

Line: 236

	-- call process api to update products
-- Start of wraper code generated automatically by Debug code generator for okl_setupproducts_pvt.update_products
  IF(L_DEBUG_ENABLED='Y') THEN
    L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;

Line: 244

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSPDB.pls call okl_setupproducts_pvt.update_products ');

Line: 247

    okl_setupproducts_pvt.update_products(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,
                              			  x_pdtv_rec      => x_pdtv_rec);

Line: 256

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPSPDB.pls call okl_setupproducts_pvt.update_products ');

Line: 273

      ROLLBACK TO sp_update_products;

Line: 283

      ROLLBACK TO sp_update_products;

Line: 295

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPRODUCTS_PUB','update_products');

Line: 301

  END update_products;