APPS.OKL_SETUPPQUALITYS_PUB SQL Statements

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

Line: 42

  PROCEDURE insert_pqualitys(p_api_version      IN  NUMBER,
                            p_init_msg_list    IN  VARCHAR2 DEFAULT OKL_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,
                        	x_pqyv_rec         OUT NOCOPY pqyv_rec_type
					        ) IS
    l_pqyv_rec                        pqyv_rec_type;

Line: 52

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

Line: 57

    SAVEPOINT sp_insert_pqualitys;

Line: 62

	-- call process api to insert pqualitys
    okl_setuppqualitys_pvt.insert_pqualitys(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,
                              			  x_pqyv_rec      => x_pqyv_rec
										  );

Line: 85

      ROLLBACK TO sp_insert_pqualitys;

Line: 95

      ROLLBACK TO sp_insert_pqualitys;

Line: 107

      FND_MSG_PUB.ADD_EXC_MSG('OKL_setuppqualitys_PUB','insert_pqualitys');

Line: 113

  END insert_pqualitys;

Line: 119

  PROCEDURE update_pqualitys(p_api_version      IN  NUMBER,
                            p_init_msg_list    IN  VARCHAR2 DEFAULT OKL_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,
                        	x_pqyv_rec         OUT NOCOPY pqyv_rec_type) IS
    l_pqyv_rec                        pqyv_rec_type;

Line: 129

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

Line: 133

    SAVEPOINT sp_update_pqualitys;

Line: 138

	-- call process api to update pqualitys
    okl_setuppqualitys_pvt.update_pqualitys(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,
                              			   x_pqyv_rec      => x_pqyv_rec);

Line: 160

      ROLLBACK TO sp_update_pqualitys;

Line: 170

      ROLLBACK TO sp_update_pqualitys;

Line: 182

      FND_MSG_PUB.ADD_EXC_MSG('OKL_setuppqualitys_PUB','update_pqualitys');

Line: 188

  END update_pqualitys;