APPS.OKL_SETUP_PRD_PRCTEMPL_PUB SQL Statements

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

Line: 8

  PROCEDURE insert_prd_price_tmpls(	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_pitv_rec                     IN  pitv_rec_type,
      		                  	x_pitv_rec                     OUT NOCOPY pitv_rec_type
                        ) IS
    l_api_name        CONSTANT VARCHAR2(30)  := 'insert_prd_price_tmpls';

Line: 42

	-- call process api to insert_prd_price_tmpls
    OKL_SETUP_PRD_PRCTEMPL_PVT.insert_prd_price_tmpls(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_pitv_rec      => l_pitv_rec,
                              			  x_pitv_rec      => x_pitv_rec);

Line: 86

  END insert_prd_price_tmpls;

Line: 92

  PROCEDURE update_prd_price_tmpls(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_pitv_rec                     IN  pitv_rec_type,
                        	x_pitv_rec                     OUT NOCOPY pitv_rec_type
                        ) IS

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

Line: 128

	-- call process api to update formulae
    OKL_SETUP_PRD_PRCTEMPL_PVT.update_prd_price_tmpls(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_pitv_rec      => l_pitv_rec,
                              			  x_pitv_rec      => x_pitv_rec);

Line: 172

  END update_prd_price_tmpls;

Line: 174

  PROCEDURE insert_prd_price_tmpls(
         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_pitv_tbl                     IN  pitv_tbl_type,
         x_pitv_tbl                     OUT NOCOPY pitv_tbl_type)
   IS
    l_return_status   	  	VARCHAR2(1) := G_RET_STS_SUCCESS;

Line: 184

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

Line: 204

		insert_prd_price_tmpls(
         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_pitv_rec                     => p_pitv_tbl(rec_num),
         x_pitv_rec                     => x_pitv_tbl(rec_num) );

Line: 245

  END insert_prd_price_tmpls;

Line: 248

  PROCEDURE update_prd_price_tmpls(
         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_pitv_tbl                     IN  pitv_tbl_type,
         x_pitv_tbl                     OUT NOCOPY pitv_tbl_type)
   IS
    l_return_status   	  	VARCHAR2(1) := G_RET_STS_SUCCESS;

Line: 258

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

Line: 278

		update_prd_price_tmpls(
         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_pitv_rec                     => p_pitv_tbl(rec_num),
         x_pitv_rec                     => x_pitv_tbl(rec_num) );

Line: 321

  END update_prd_price_tmpls;

Line: 359

	-- call process api to update formulae
    OKL_SETUP_PRD_PRCTEMPL_PVT.check_product_constraints(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_validated      => l_validated);