DBA Data[Home] [Help]

APPS.OKC_OUTCOME_PUB SQL Statements

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

Line: 32

    l_ocev_rec.last_updated_by       := p_ocev_rec1.last_updated_by;
Line: 33

    l_ocev_rec.last_update_date      := p_ocev_rec1.last_update_date;
Line: 34

    l_ocev_rec.last_update_login     := p_ocev_rec1.last_update_login;
Line: 91

    l_oatv_rec.last_updated_by       := p_oatv_rec1.last_updated_by;
Line: 92

    l_oatv_rec.last_update_date      := p_oatv_rec1.last_update_date;
Line: 93

    l_oatv_rec.last_update_login     := p_oatv_rec1.last_update_login;
Line: 224

  PROCEDURE update_outcomes_args(
    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_ocev_rec		    IN ocev_rec_type,
    p_oatv_tbl              IN oatv_tbl_type,
    x_ocev_rec              OUT NOCOPY ocev_rec_type,
    x_oatv_tbl              OUT NOCOPY oatv_tbl_type) IS

    l_api_version           CONSTANT NUMBER := 1;
Line: 236

    l_api_name              CONSTANT VARCHAR2(30) := 'update_outcomes_args';
Line: 240

   l_proc varchar2(72) := '  okc_outcome_pub.'||'update_outcomes_args';
Line: 261

    okc_outcome_pvt.update_outcomes_args(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_ocev_rec,
	    p_oatv_tbl,
	    x_ocev_rec,
	    x_oatv_tbl);
Line: 321

  END update_outcomes_args;
Line: 806

  PROCEDURE update_outcome(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_ocev_rec		    IN ocev_rec_type,
    			    x_ocev_rec              OUT NOCOPY ocev_rec_type) IS

	 l_api_name	 CONSTANT VARCHAR2(30) := 'update_outcome';
Line: 819

   l_proc varchar2(72) := '  okc_outcome_pub.'||'update_outcome';
Line: 861

	okc_outcome_pvt.update_outcome(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_ocev_rec      => l_ocev_rec,
    				    x_ocev_rec      => x_ocev_rec);
Line: 942

  end update_outcome;
Line: 944

  PROCEDURE update_outcome(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_ocev_tbl		    IN ocev_tbl_type,
    			    x_ocev_tbl              OUT NOCOPY ocev_tbl_type) IS

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

   l_proc varchar2(72) := '  okc_outcome_pub.'||'update_outcome';
Line: 969

        update_outcome(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_ocev_tbl(i),
	    x_ocev_tbl(i));
Line: 1015

  END update_outcome;
Line: 1017

  PROCEDURE delete_outcome(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_ocev_rec		    IN ocev_rec_type) IS

	 l_api_name	 CONSTANT VARCHAR2(30) := 'delete_outcome';
Line: 1029

   l_proc varchar2(72) := '  okc_outcome_pub.'||'delete_outcome';
Line: 1070

	okc_outcome_pvt.delete_outcome(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_ocev_rec      => l_ocev_rec);
Line: 1148

  end delete_outcome;
Line: 1150

  PROCEDURE delete_outcome(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_ocev_tbl		    IN ocev_tbl_type) IS

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

   l_proc varchar2(72) := '  okc_outcome_pub.'||'delete_outcome';
Line: 1174

        delete_outcome(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_ocev_tbl(i));
Line: 1219

  END delete_outcome;
Line: 1814

  PROCEDURE update_out_arg(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_oatv_rec        IN oatv_rec_type,
    				  x_oatv_rec        OUT NOCOPY oatv_rec_type) IS

	 l_api_name	 CONSTANT VARCHAR2(30) := 'update_out_arg';
Line: 1827

   l_proc varchar2(72) := '  okc_outcome_pub.'||'update_out_arg';
Line: 1867

	okc_outcome_pvt.update_out_arg(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_oatv_rec      => l_oatv_rec,
    				    	  x_oatv_rec      => x_oatv_rec);
Line: 1948

  END update_out_arg;
Line: 1950

  PROCEDURE update_out_arg(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_oatv_tbl	    IN  oatv_tbl_type,
    				  x_oatv_tbl        OUT NOCOPY oatv_tbl_type) IS

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

   l_proc varchar2(72) := '  okc_outcome_pub.'||'update_out_arg';
Line: 1977

        update_out_arg(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_oatv_tbl(i),
	    x_oatv_tbl(i));
Line: 2023

  END update_out_arg;
Line: 2025

  PROCEDURE delete_out_arg(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_oatv_rec	    IN  oatv_rec_type) IS

	 l_api_name	 CONSTANT VARCHAR2(30) := 'delete_out_arg';
Line: 2037

   l_proc varchar2(72) := '  okc_outcome_pub.'||'delete_out_arg';
Line: 2078

	okc_outcome_pvt.delete_out_arg(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_oatv_rec      => l_oatv_rec);
Line: 2155

  END delete_out_arg;
Line: 2157

  PROCEDURE delete_out_arg(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_oatv_tbl	    IN  oatv_tbl_type) IS

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

   l_proc varchar2(72) := '  okc_outcome_pub.'||'delete_out_arg';
Line: 2183

        delete_out_arg(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_oatv_tbl(i));
Line: 2228

  END delete_out_arg;