DBA Data[Home] [Help]

APPS.OKC_AQERRMSG_PUB SQL Statements

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

Line: 19

    l_aqev_rec.last_updated_by       := p_aqev_rec1.last_updated_by;
Line: 20

    l_aqev_rec.last_update_date      := p_aqev_rec1.last_update_date;
Line: 21

    l_aqev_rec.last_update_login     := p_aqev_rec1.last_update_login;
Line: 37

    l_aqmv_rec.last_updated_by       := p_aqmv_rec1.last_updated_by;
Line: 38

    l_aqmv_rec.last_update_date      := p_aqmv_rec1.last_update_date;
Line: 39

    l_aqmv_rec.last_update_login     := p_aqmv_rec1.last_update_login;
Line: 72

    okc_aqe_pvt.insert_row(
    	p_api_version,
    	p_init_msg_list,
    	x_return_status,
    	x_msg_count,
    	x_msg_data,
    	p_aqev_rec,
    	x_aqev_rec);
Line: 97

    okc_aqm_pvt.insert_row(
    	p_api_version,
    	p_init_msg_list,
    	x_return_status,
   	x_msg_count,
    	x_msg_data,
    	l_aqmv_tbl,
    	x_aqmv_tbl);
Line: 140

  PROCEDURE update_err_msg(
    p_api_version	    IN NUMBER,
    p_init_msg_list         IN VARCHAR2 ,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    p_aqev_rec		    IN aqev_rec_type,
    p_aqmv_tbl              IN aqmv_tbl_type,
    x_aqev_rec              OUT NOCOPY aqev_rec_type,
    x_aqmv_tbl              OUT NOCOPY aqmv_tbl_type) IS

    l_api_version           CONSTANT NUMBER := 1;
Line: 152

    l_api_name              CONSTANT VARCHAR2(30) := 'update_err_msg';
Line: 167

    okc_aqe_pvt.update_row(
    	p_api_version,
    	p_init_msg_list,
    	x_return_status,
    	x_msg_count,
    	x_msg_data,
    	p_aqev_rec,
    	x_aqev_rec);
Line: 182

    okc_aqm_pvt.update_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_aqmv_tbl,
    x_aqmv_tbl);
Line: 222

  END update_err_msg;
Line: 354

	okc_aqe_pvt.insert_row(p_api_version   => p_api_version,
    			       p_init_msg_list => p_init_msg_list,
    			       x_return_status => x_return_status,
    			       x_msg_count     => x_msg_count,
    			       x_msg_data      => x_msg_data,
    			       p_aqev_rec      => l_aqev_rec,
    			       x_aqev_rec      => x_aqev_rec);
Line: 590

  PROCEDURE update_err(p_api_version	       IN NUMBER,
    		       p_init_msg_list         IN VARCHAR2 ,
    		       x_return_status         OUT NOCOPY VARCHAR2,
    		       x_msg_count             OUT NOCOPY NUMBER,
    		       x_msg_data              OUT NOCOPY VARCHAR2,
    		       p_aqev_rec	       IN aqev_rec_type,
    		       x_aqev_rec              OUT NOCOPY aqev_rec_type) IS

	 l_api_name	 CONSTANT VARCHAR2(30) := 'update_err';
Line: 635

	okc_aqe_pvt.update_row(p_api_version   => p_api_version,
    			       p_init_msg_list => p_init_msg_list,
    			       x_return_status => x_return_status,
    		               x_msg_count     => x_msg_count,
    			       x_msg_data      => x_msg_data,
    			       p_aqev_rec      => l_aqev_rec,
    			       x_aqev_rec      => x_aqev_rec);
Line: 698

  end update_err;
Line: 700

 PROCEDURE update_err(p_api_version	       IN NUMBER,
    		       p_init_msg_list         IN VARCHAR2 ,
    		       x_return_status         OUT NOCOPY VARCHAR2,
    		       x_msg_count             OUT NOCOPY NUMBER,
    		       x_msg_data              OUT NOCOPY VARCHAR2,
    		       p_aqev_tbl	       IN aqev_tbl_type,
    		       x_aqev_tbl              OUT NOCOPY aqev_tbl_type) IS

        l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 715

        update_err(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_aqev_tbl(i),
	    x_aqev_tbl(i));
Line: 747

  END update_err;
Line: 749

  PROCEDURE delete_err(p_api_version	    IN NUMBER,
    		       p_init_msg_list      IN VARCHAR2 ,
    		       x_return_status      OUT NOCOPY VARCHAR2,
    		       x_msg_count          OUT NOCOPY NUMBER,
    		       x_msg_data           OUT NOCOPY VARCHAR2,
    		       p_aqev_rec	    IN aqev_rec_type) IS

	 l_api_name	 CONSTANT VARCHAR2(30) := 'delete_err';
Line: 792

	okc_aqe_pvt.delete_row(p_api_version   => p_api_version,
    			       p_init_msg_list => p_init_msg_list,
    			       x_return_status => x_return_status,
    			       x_msg_count     => x_msg_count,
    			       x_msg_data      => x_msg_data,
    			       p_aqev_rec      => l_aqev_rec);
Line: 852

  end delete_err;
Line: 854

   PROCEDURE delete_err(p_api_version	    IN NUMBER,
    		       p_init_msg_list      IN VARCHAR2 ,
    		       x_return_status      OUT NOCOPY VARCHAR2,
    		       x_msg_count          OUT NOCOPY NUMBER,
    		       x_msg_data           OUT NOCOPY VARCHAR2,
    		       p_aqev_tbl	    IN aqev_tbl_type) IS

        l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 868

        delete_err(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_aqev_tbl(i));
Line: 899

  END delete_err;
Line: 1099

	okc_aqm_pvt.insert_row(p_api_version   => p_api_version,
    			       p_init_msg_list => p_init_msg_list,
    			       x_return_status => x_return_status,
    			       x_msg_count     => x_msg_count,
    			       x_msg_data      => x_msg_data,
    			       p_aqmv_rec      => l_aqmv_rec,
    			       x_aqmv_rec      => x_aqmv_rec);
Line: 1336

  PROCEDURE update_msg(p_api_version	 IN NUMBER,
    		       p_init_msg_list   IN VARCHAR2 ,
    		       x_return_status   OUT NOCOPY VARCHAR2,
    		       x_msg_count       OUT NOCOPY NUMBER,
    		       x_msg_data        OUT NOCOPY VARCHAR2,
    		       p_aqmv_rec        IN aqmv_rec_type,
    		       x_aqmv_rec        OUT NOCOPY aqmv_rec_type) IS

	 l_api_name	 CONSTANT VARCHAR2(30) := 'update_msg';
Line: 1379

	okc_aqm_pvt.update_row(p_api_version   => p_api_version,
    			        p_init_msg_list => p_init_msg_list,
    			        x_return_status => x_return_status,
    				x_msg_count     => x_msg_count,
    				x_msg_data      => x_msg_data,
    				p_aqmv_rec      => l_aqmv_rec,
    				x_aqmv_rec      => x_aqmv_rec);
Line: 1442

  END update_msg;
Line: 1444

  PROCEDURE update_msg(p_api_version	 IN NUMBER,
    		       p_init_msg_list   IN VARCHAR2 ,
    		       x_return_status   OUT NOCOPY VARCHAR2,
    		       x_msg_count       OUT NOCOPY NUMBER,
    		       x_msg_data        OUT NOCOPY VARCHAR2,
    		       p_aqmv_tbl        IN aqmv_tbl_type,
    		       x_aqmv_tbl        OUT NOCOPY aqmv_tbl_type) IS

	l_return_status  VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 1461

        update_msg(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_aqmv_tbl(i),
	    x_aqmv_tbl(i));
Line: 1493

  END update_msg;
Line: 1495

  PROCEDURE delete_msg(p_api_version	 IN  NUMBER,
    		       p_init_msg_list   IN  VARCHAR2 ,
    		       x_return_status   OUT NOCOPY VARCHAR2,
    		       x_msg_count       OUT NOCOPY NUMBER,
    		       x_msg_data        OUT NOCOPY VARCHAR2,
    		       p_aqmv_rec	 IN  aqmv_rec_type) IS

	 l_api_name	 CONSTANT VARCHAR2(30) := 'delete_msg';
Line: 1538

	okc_aqm_pvt.delete_row(p_api_version   => p_api_version,
    			       p_init_msg_list => p_init_msg_list,
    			       x_return_status => x_return_status,
    			       x_msg_count     => x_msg_count,
    			       x_msg_data      => x_msg_data,
    			       p_aqmv_rec      => l_aqmv_rec);
Line: 1597

  END delete_msg;
Line: 1599

  PROCEDURE delete_msg(p_api_version	 IN  NUMBER,
    		       p_init_msg_list   IN  VARCHAR2 ,
    		       x_return_status   OUT NOCOPY VARCHAR2,
    		       x_msg_count       OUT NOCOPY NUMBER,
    		       x_msg_data        OUT NOCOPY VARCHAR2,
    		       p_aqmv_tbl	 IN  aqmv_tbl_type) IS

	l_return_status  VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 1615

        delete_msg(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_aqmv_tbl(i));
Line: 1646

  END delete_msg;