DBA Data[Home] [Help]

APPS.OKC_OUTCOME_PVT SQL Statements

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

Line: 87

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_return_status         VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 100

    update_outcome(
    	p_api_version,
    	p_init_msg_list,
    	x_return_status,
    	x_msg_count,
    	x_msg_data,
    	p_ocev_rec,
    	x_ocev_rec);
Line: 117

    update_out_arg(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_oatv_tbl,
    x_oatv_tbl);
Line: 145

end update_outcomes_args;
Line: 206

 Procedure  Update_Minor_Version(p_chr_id NUMBER) Is
     l_api_version                NUMBER := 1;
Line: 219

     OKC_CVM_PVT.update_contract_version(
          p_api_version     => l_api_version,
          p_init_msg_list   => l_init_msg_list,
          x_return_status   => x_return_status,
          x_msg_count       => x_msg_count,
          x_msg_data        => x_msg_data,
          p_cvmv_rec        => l_cvmv_rec,
          x_cvmv_rec        => x_out_rec);
Line: 247

 End update_minor_version;
Line: 260

    okc_oce_pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_ocev_rec,
    x_ocev_rec);
Line: 271

    	update_minor_version(p_ocev_rec.dnz_chr_id);
Line: 284

    okc_oce_pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_ocev_tbl,
    x_ocev_tbl);
Line: 328

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
begin
    okc_oce_pvt.update_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_ocev_rec,
    x_ocev_rec);
Line: 347

    	update_minor_version(p_ocev_rec.dnz_chr_id);
Line: 349

End update_outcome;
Line: 351

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
begin
    okc_oce_pvt.update_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_ocev_tbl,
    x_ocev_tbl);
Line: 368

End update_outcome;
Line: 371

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_return_status         VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 384

    select oat.id
    from okc_outcome_arguments_v oat
    where oat.oce_id = p_ocev_rec.id;
Line: 396

       		okc_outcome_pub.delete_out_arg(
    			p_api_version,
    			p_init_msg_list,
    			x_return_status,
    			x_msg_count,
    			x_msg_data,
    			l_oatv_tbl);
Line: 411

	--Delete the Master
    	okc_oce_pvt.delete_row(
    		p_api_version,
    		p_init_msg_list,
    		x_return_status,
    		x_msg_count,
    		x_msg_data,
    		p_ocev_rec);
Line: 424

  	   --Update minor version
    	   update_minor_version(p_ocev_rec.dnz_chr_id);
Line: 441

End delete_outcome;
Line: 443

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
    i	                    NUMBER :=0;
Line: 459

          delete_outcome(
    		p_api_version,
    		p_init_msg_list,
    		x_return_status,
    		x_msg_count,
    		x_msg_data,
    		p_ocev_tbl(i));
Line: 489

End delete_outcome;
Line: 536

    okc_oat_pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_oatv_rec,
    x_oatv_rec);
Line: 546

    	update_minor_version(p_oatv_rec.dnz_chr_id);
Line: 559

    okc_oat_pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_oatv_tbl,
    x_oatv_tbl);
Line: 603

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
begin
    okc_oat_pvt.update_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_oatv_rec,
    x_oatv_rec);
Line: 622

    	update_minor_version(p_oatv_rec.dnz_chr_id);
Line: 624

End update_out_arg;
Line: 626

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
begin
    okc_oat_pvt.update_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_oatv_tbl,
    x_oatv_tbl);
Line: 643

End update_out_arg;
Line: 645

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
begin
    okc_oat_pvt.delete_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_oatv_rec);
Line: 662

    	update_minor_version(p_oatv_rec.dnz_chr_id);
Line: 664

End delete_out_arg;
Line: 666

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
begin
    okc_oat_pvt.delete_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_oatv_tbl);
Line: 681

End delete_out_arg;