DBA Data[Home] [Help]

APPS.OKC_CONDITIONS_PUB SQL Statements

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

Line: 14

    l_cnhv_rec.last_updated_by       := p_cnhv_rec1.last_updated_by;
Line: 15

    l_cnhv_rec.last_update_date      := p_cnhv_rec1.last_update_date;
Line: 16

    l_cnhv_rec.last_update_login     := p_cnhv_rec1.last_update_login;
Line: 68

    l_cnlv_rec.last_updated_by       := p_cnlv_rec1.last_updated_by;
Line: 69

    l_cnlv_rec.last_update_date      := p_cnlv_rec1.last_update_date;
Line: 70

    l_cnlv_rec.last_update_login     := p_cnlv_rec1.last_update_login;
Line: 120

    l_coev_rec.last_updated_by       := p_coev_rec1.last_updated_by;
Line: 121

    l_coev_rec.last_update_date      := p_coev_rec1.last_update_date;
Line: 122

    l_coev_rec.last_update_login     := p_coev_rec1.last_update_login;
Line: 136

    l_aavv_rec.last_updated_by       := p_aavv_rec1.last_updated_by;
Line: 137

    l_aavv_rec.last_update_date      := p_aavv_rec1.last_update_date;
Line: 138

    l_aavv_rec.last_update_login     := p_aavv_rec1.last_update_login;
Line: 153

    l_aalv_rec.last_updated_by       := p_aalv_rec1.last_updated_by;
Line: 154

    l_aalv_rec.last_update_date      := p_aalv_rec1.last_update_date;
Line: 155

    l_aalv_rec.last_update_login     := p_aalv_rec1.last_update_login;
Line: 172

    l_fepv_rec.last_updated_by       := p_fepv_rec1.last_updated_by;
Line: 173

    l_fepv_rec.last_update_date      := p_fepv_rec1.last_update_date;
Line: 174

    l_fepv_rec.last_update_login     := p_fepv_rec1.last_update_login;
Line: 259

  PROCEDURE update_cond_hdrs(
    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_cnhv_rec		    IN cnhv_rec_type,
    p_cnlv_tbl              IN cnlv_tbl_type,
    x_cnhv_rec              OUT NOCOPY cnhv_rec_type,
    x_cnlv_tbl              OUT NOCOPY cnlv_tbl_type) IS

    l_api_version           CONSTANT NUMBER := 1;
Line: 271

    l_api_name              CONSTANT VARCHAR2(30) := 'V_update_cond_hdrs';
Line: 286

    okc_conditions_pvt.update_cond_hdrs(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_cnhv_rec,
	    p_cnlv_tbl,
	    x_cnhv_rec,
	    x_cnlv_tbl);
Line: 328

  END update_cond_hdrs;
Line: 681

  PROCEDURE update_cond_hdrs(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_cnhv_rec		    IN cnhv_rec_type,
    			    x_cnhv_rec              OUT NOCOPY cnhv_rec_type) IS

	 l_api_name	 CONSTANT VARCHAR2(30) := 'update_cond_hdrs';
Line: 726

	okc_conditions_pvt.update_cond_hdrs(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_cnhv_rec      => l_cnhv_rec,
    				    x_cnhv_rec      => x_cnhv_rec);
Line: 790

  end update_cond_hdrs;
Line: 792

  PROCEDURE update_cond_hdrs(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_cnhv_tbl		    IN cnhv_tbl_type,
    			    x_cnhv_tbl              OUT NOCOPY cnhv_tbl_type) IS

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

        update_cond_hdrs(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_cnhv_tbl(i),
	    x_cnhv_tbl(i));
Line: 839

  END update_cond_hdrs;
Line: 841

  PROCEDURE delete_cond_hdrs(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_cnhv_rec		    IN cnhv_rec_type) IS

	 l_api_name	 CONSTANT VARCHAR2(30) := 'delete_cond_hdrs';
Line: 884

	okc_conditions_pvt.delete_cond_hdrs(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_cnhv_rec      => l_cnhv_rec);
Line: 944

  end delete_cond_hdrs;
Line: 946

  PROCEDURE delete_cond_hdrs(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_cnhv_tbl		    IN cnhv_tbl_type) IS

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

        delete_cond_hdrs(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_cnhv_tbl(i));
Line: 991

  END delete_cond_hdrs;
Line: 1429

  PROCEDURE update_cond_lines(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_cnlv_rec        IN cnlv_rec_type,
    				  x_cnlv_rec        OUT NOCOPY cnlv_rec_type) IS

	 l_api_name	 CONSTANT VARCHAR2(30) := 'update_cond_lines';
Line: 1472

	okc_conditions_pvt.update_cond_lines(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_cnlv_rec      => l_cnlv_rec,
    				    	  x_cnlv_rec      => x_cnlv_rec);
Line: 1535

  END update_cond_lines;
Line: 1537

  PROCEDURE update_cond_lines(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_cnlv_tbl	    IN  cnlv_tbl_type,
    				  x_cnlv_tbl        OUT NOCOPY cnlv_tbl_type) IS

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

        update_cond_lines(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_cnlv_tbl(i),
	    x_cnlv_tbl(i));
Line: 1586

  END update_cond_lines;
Line: 1588

  PROCEDURE delete_cond_lines(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_cnlv_rec	    IN  cnlv_rec_type) IS

	 l_api_name	 CONSTANT VARCHAR2(30) := 'delete_cond_lines';
Line: 1631

	okc_conditions_pvt.delete_cond_lines(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_cnlv_rec      => l_cnlv_rec);
Line: 1690

  END delete_cond_lines;
Line: 1692

  PROCEDURE delete_cond_lines(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_cnlv_tbl	    IN  cnlv_tbl_type) IS

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

        delete_cond_lines(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_cnlv_tbl(i));
Line: 1739

  END delete_cond_lines;
Line: 2059

  PROCEDURE delete_cond_occurs(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_coev_rec	    IN  coev_rec_type) IS

	 l_api_name	 CONSTANT VARCHAR2(30) := 'delete_cond_occurs';
Line: 2102

	okc_conditions_pvt.delete_cond_occurs(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_coev_rec      => l_coev_rec);
Line: 2161

  END delete_cond_occurs;
Line: 2163

  PROCEDURE delete_cond_occurs(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_coev_tbl	    IN  coev_tbl_type) IS

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

        delete_cond_occurs(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_coev_tbl(i));
Line: 2210

  END delete_cond_occurs;
Line: 2530

  PROCEDURE delete_act_att_vals(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_aavv_rec	    IN  aavv_rec_type) IS

	 l_api_name	 CONSTANT VARCHAR2(30) := 'delete_act_att_vals';
Line: 2573

	okc_conditions_pvt.delete_act_att_vals(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_aavv_rec      => l_aavv_rec);
Line: 2632

  END delete_act_att_vals;
Line: 2634

  PROCEDURE delete_act_att_vals(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_aavv_tbl	    IN  aavv_tbl_type) IS

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

        delete_act_att_vals(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_aavv_tbl(i));
Line: 2681

  END delete_act_att_vals;
Line: 3006

  	 l_api_name	 CONSTANT VARCHAR2(30) := 'delete_act_att_lkps';
Line: 3122

  PROCEDURE update_act_att_lkps(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_aalv_rec        IN aalv_rec_type,
    				  x_aalv_rec        OUT NOCOPY aalv_rec_type) IS

	 l_api_name	 CONSTANT VARCHAR2(30) := 'update_act_att_lkps';
Line: 3165

	okc_conditions_pvt.update_act_att_lkps(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_aalv_rec      => l_aalv_rec,
    				    	  x_aalv_rec      => x_aalv_rec);
Line: 3228

  END update_act_att_lkps;
Line: 3230

  PROCEDURE update_act_att_lkps(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_aalv_tbl	    IN  aalv_tbl_type,
    				  x_aalv_tbl        OUT NOCOPY aalv_tbl_type) IS

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

        update_act_att_lkps(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_aalv_tbl(i),
	    x_aalv_tbl(i));
Line: 3279

  END update_act_att_lkps;
Line: 3281

  PROCEDURE delete_act_att_lkps(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_aalv_rec	    IN  aalv_rec_type) IS

	 l_api_name	 CONSTANT VARCHAR2(30) := 'delete_act_att_lkps';
Line: 3324

	okc_conditions_pvt.delete_act_att_lkps(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_aalv_rec      => l_aalv_rec);
Line: 3383

  END delete_act_att_lkps;
Line: 3385

  PROCEDURE delete_act_att_lkps(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_aalv_tbl	    IN  aalv_tbl_type) IS

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

        delete_act_att_lkps(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_aalv_tbl(i));
Line: 3432

  END delete_act_att_lkps;
Line: 3873

  PROCEDURE update_func_exprs(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_fepv_rec        IN fepv_rec_type,
    				  x_fepv_rec        OUT NOCOPY fepv_rec_type) IS

	 l_api_name	 CONSTANT VARCHAR2(30) := 'update_func_exprs';
Line: 3916

	okc_conditions_pvt.update_func_exprs(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_fepv_rec      => l_fepv_rec,
    				    	  x_fepv_rec      => x_fepv_rec);
Line: 3979

  END update_func_exprs;
Line: 3981

  PROCEDURE update_func_exprs(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_fepv_tbl	    IN  fepv_tbl_type,
    				  x_fepv_tbl        OUT NOCOPY fepv_tbl_type) IS

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

        update_func_exprs(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_fepv_tbl(i),
	    x_fepv_tbl(i));
Line: 4030

  END update_func_exprs;
Line: 4032

  PROCEDURE delete_func_exprs(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_fepv_rec	    IN  fepv_rec_type) IS

	 l_api_name	 CONSTANT VARCHAR2(30) := 'delete_func_exprs';
Line: 4075

	okc_conditions_pvt.delete_func_exprs(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_fepv_rec      => l_fepv_rec);
Line: 4134

  END delete_func_exprs;
Line: 4136

  PROCEDURE delete_func_exprs(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_fepv_tbl	    IN  fepv_tbl_type) IS

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

        delete_func_exprs(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_fepv_tbl(i));
Line: 4183

  END delete_func_exprs;