APPS.OKL_SETUPPQYVALUES_PUB SQL Statements

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

Line: 43

  PROCEDURE insert_pqyvalues(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_pqyv_rec         IN  pqyv_rec_type,
                        	p_qvev_rec         IN  qvev_rec_type,
                        	x_qvev_rec         OUT NOCOPY qvev_rec_type) IS
    l_qvev_rec                        qvev_rec_type;

Line: 54

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

Line: 59

    SAVEPOINT sp_insert_pqyvalues;

Line: 65

	-- call process api to insert pqyvalues
    okl_SETUPPQYVALUES_pvt.insert_pqyvalues(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_pqyv_rec      => l_pqyv_rec,
                              			  p_qvev_rec      => l_qvev_rec,
                              			  x_qvev_rec      => x_qvev_rec);

Line: 88

      ROLLBACK TO sp_insert_pqyvalues;

Line: 98

      ROLLBACK TO sp_insert_pqyvalues;

Line: 110

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPQYVALUES_PUB','insert_pqyvalues');

Line: 116

  END insert_pqyvalues;

Line: 122

  PROCEDURE update_pqyvalues(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_pqyv_rec         IN  pqyv_rec_type,
                        	p_qvev_rec         IN  qvev_rec_type,
                        	x_qvev_rec         OUT NOCOPY qvev_rec_type) IS
    l_qvev_rec                        qvev_rec_type;

Line: 134

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

Line: 138

    SAVEPOINT sp_update_pqyvalues;

Line: 144

	-- call process api to update pqyvalues
    okl_SETUPPQYVALUES_pvt.update_pqyvalues(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_pqyv_rec      => l_pqyv_rec,
                              			  p_qvev_rec      => l_qvev_rec,
                              			  x_qvev_rec      => x_qvev_rec);

Line: 167

      ROLLBACK TO sp_update_pqyvalues;

Line: 177

      ROLLBACK TO sp_update_pqyvalues;

Line: 189

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPQYVALUES_PUB','update_pqyvalues');

Line: 195

  END update_pqyvalues;