APPS.OKL_SETUPOVDTEMPLATES_PUB SQL Statements

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

Line: 43

  PROCEDURE insert_ovdtemplates(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_optv_rec		   IN  optv_rec_type,
                                p_ovev_rec         IN  ovev_rec_type,
                                p_ovdv_rec         IN  ovdv_rec_type,
                        	    p_ovtv_rec         IN  ovtv_rec_type,
                        	    x_ovtv_rec         OUT NOCOPY ovtv_rec_type) IS
	l_optv_rec						  optv_rec_type;

Line: 58

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

Line: 63

    SAVEPOINT sp_insert_ovdtemplates;

Line: 72

	-- call process api to insert formula operands
    okl_setupovdtemplates_pvt.insert_ovdtemplates(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_optv_rec      => l_optv_rec,
                                                  p_ovev_rec      => l_ovev_rec,
                                                  p_ovdv_rec      => l_ovdv_rec,
                              			          p_ovtv_rec      => l_ovtv_rec,
                              			          x_ovtv_rec      => x_ovtv_rec);

Line: 97

      ROLLBACK TO sp_insert_ovdtemplates;

Line: 107

      ROLLBACK TO sp_insert_ovdtemplates;

Line: 119

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPOVDTEMPLATES_PUB','insert_ovdtemplates');

Line: 125

  END insert_ovdtemplates;

Line: 131

  PROCEDURE delete_ovdtemplates(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_optv_rec		   IN  optv_rec_type,
                                p_ovev_rec         IN  ovev_rec_type,
                                p_ovdv_rec         IN  ovdv_rec_type,
                      		    p_ovtv_tbl         IN  ovtv_tbl_type) IS
	l_optv_rec						  optv_rec_type;

Line: 146

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

Line: 150

    SAVEPOINT sp_delete_ovdtemplates;

Line: 159

	-- call process api to delete formula operands
    okl_setupovdtemplates_pvt.delete_ovdtemplates(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_optv_rec      => l_optv_rec,
                                                  p_ovev_rec      => l_ovev_rec,
                                                  p_ovdv_rec      => l_ovdv_rec,
                              			  	      p_ovtv_tbl      => l_ovtv_tbl);

Line: 180

      ROLLBACK TO sp_delete_ovdtemplates;

Line: 190

      ROLLBACK TO sp_delete_ovdtemplates;

Line: 202

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPOVDTEMPLATES_PUB','delete_ovdtemplates');

Line: 208

  END delete_ovdtemplates;