APPS.OKL_SETUPTQYVALUES_PUB SQL Statements

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

Line: 43

  PROCEDURE insert_tqyvalues(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_ptqv_rec                     IN  ptqv_rec_type,
							p_ptvv_rec                     IN  ptvv_rec_type,
							x_ptvv_rec                     OUT NOCOPY ptvv_rec_type
							) IS
    l_ptvv_rec                        ptvv_rec_type;

Line: 55

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

Line: 60

    SAVEPOINT sp_insert_tqyvalues;

Line: 66

	-- call process api to insert formulae
    okl_setuptqyvalues_pvt.insert_tqyvalues(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_ptqv_rec      => l_ptqv_rec,
										  p_ptvv_rec      => l_ptvv_rec,
										  x_ptvv_rec      => x_ptvv_rec);

Line: 89

      ROLLBACK TO sp_insert_tqyvalues;

Line: 99

      ROLLBACK TO sp_insert_tqyvalues;

Line: 111

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPTQYVALUES_PUB','insert_tqyvalues');

Line: 117

  END insert_tqyvalues;

Line: 123

  PROCEDURE update_tqyvalues(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_ptqv_rec         IN  ptqv_rec_type,
                        	p_ptvv_rec         IN  ptvv_rec_type,
                        	x_ptvv_rec         OUT NOCOPY ptvv_rec_type) IS
    l_ptvv_rec                        ptvv_rec_type;

Line: 135

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

Line: 139

    SAVEPOINT sp_update_tqyvalues;

Line: 145

	-- call process api to update formulae
    okl_setuptqyvalues_pvt.update_tqyvalues(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_ptqv_rec      => l_ptqv_rec,
                              			  p_ptvv_rec      => l_ptvv_rec,
                              			  x_ptvv_rec      => x_ptvv_rec);

Line: 168

      ROLLBACK TO sp_update_tqyvalues;

Line: 178

      ROLLBACK TO sp_update_tqyvalues;

Line: 190

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPTQYVALUES_PUB','update_tqyvalues');

Line: 196

  END update_tqyvalues;