eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_CONDITIONS_PVT SQL Statements

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

Line: 88


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

Line: 101


    update_cond_hdrs(
    	p_api_version,
    	p_init_msg_list,
    	x_return_status,
    	x_msg_count,
    	x_msg_data,
    	p_cnhv_rec,
    	x_cnhv_rec);

Line: 118


    update_cond_lines(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_cnlv_tbl,
    x_cnlv_tbl);

Line: 146


end update_cond_hdrs;

Line: 207


PROCEDURE update_minor_version(p_chr_id IN NUMBER) IS
  l_api_version          NUMBER := 1;

Line: 221


	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: 248


END update_minor_version;

Line: 261


    okc_cnh_pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_cnhv_rec,
    x_cnhv_rec);

Line: 271


       Update_Minor_Version(p_cnhv_rec.dnz_chr_id);

Line: 285


    okc_cnh_pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_cnhv_tbl,
    x_cnhv_tbl);

Line: 329


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
begin
    okc_cnh_pvt.update_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_cnhv_rec,
    x_cnhv_rec);

Line: 348


       Update_Minor_Version(p_cnhv_rec.dnz_chr_id);

Line: 350


End update_cond_hdrs;

Line: 352


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
begin
    okc_cnh_pvt.update_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_cnhv_tbl,
    x_cnhv_tbl);

Line: 369


End update_cond_hdrs;

Line: 372


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_dummy                 VARCHAR2(1) ;

Line: 388


    select '1'
    from okc_timevalues tve
    where tve.cnh_id = p_cnhv_rec.id
    and   tve.tve_type = 'TGN';

Line: 394


    select cnl.id
    from okc_condition_lines_v cnl
    where cnl.cnh_id = p_cnhv_rec.id;

Line: 399


    select oce.id
    from okc_outcomes_v oce
    where oce.cnh_id = p_cnhv_rec.id;

Line: 425


       	okc_outcome_pub.delete_outcome(
    			p_api_version,
    			p_init_msg_list,
    			x_return_status,
    			x_msg_count,
    			x_msg_data,
    			l_ocev_tbl);

Line: 450


       	okc_conditions_pub.delete_cond_lines(
    			p_api_version,
    			p_init_msg_list,
    			x_return_status,
    			x_msg_count,
    			x_msg_data,
    			l_cnlv_tbl);

Line: 466


	--Delete the Master
        okc_cnh_pvt.delete_row(
    		p_api_version,
    		p_init_msg_list,
    		x_return_status,
    		x_msg_count,
    		x_msg_data,
    		p_cnhv_rec);

Line: 484


       Update_Minor_Version(p_cnhv_rec.dnz_chr_id);

Line: 499


End delete_cond_hdrs;

Line: 501


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

Line: 517


          delete_cond_hdrs(
    		p_api_version,
    		p_init_msg_list,
    		x_return_status,
    		x_msg_count,
    		x_msg_data,
    		p_cnhv_tbl(i));

Line: 547


End delete_cond_hdrs;

Line: 595


    okc_cnl_pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_cnlv_rec,
    x_cnlv_rec);

Line: 605


       Update_Minor_Version(p_cnlv_rec.dnz_chr_id);

Line: 618


    okc_cnl_pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_cnlv_tbl,
    x_cnlv_tbl);

Line: 662


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
begin
    okc_cnl_pvt.update_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_cnlv_rec,
    x_cnlv_rec);

Line: 681


       Update_Minor_Version(p_cnlv_rec.dnz_chr_id);

Line: 683


End update_cond_lines;

Line: 685


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
begin
    okc_cnl_pvt.update_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_cnlv_tbl,
    x_cnlv_tbl);

Line: 702


End update_cond_lines;

Line: 704


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

Line: 717


    select fep.id
    from okc_function_expr_params_v fep
    where fep.cnl_id = p_cnlv_rec.id;

Line: 729


	  okc_conditions_pub.delete_func_exprs(
			  p_api_version,
			  p_init_msg_list,
			  x_return_status,
			  x_msg_count,
			  x_msg_data,
			  l_fepv_tbl);

Line: 745


	 --Delete the condition lines
    okc_cnl_pvt.delete_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_cnlv_rec);

Line: 762


       Update_Minor_Version(p_cnlv_rec.dnz_chr_id);

Line: 776


End delete_cond_lines;

Line: 778


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
begin
    okc_cnl_pvt.delete_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_cnlv_tbl);

Line: 794


End delete_cond_lines;

Line: 842


    okc_aav_pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_aavv_rec,
    x_aavv_rec);

Line: 861


    okc_aav_pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_aavv_tbl,
    x_aavv_tbl);

Line: 871


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
begin
    okc_aav_pvt.delete_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_aavv_rec);

Line: 886


End delete_act_att_vals;

Line: 888


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
begin
    okc_aav_pvt.delete_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_aavv_tbl);

Line: 903


End delete_act_att_vals;

Line: 951


    okc_coe_pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_coev_rec,
    x_coev_rec);

Line: 970


    okc_coe_pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_coev_tbl,
    x_coev_tbl);

Line: 980


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
begin
    okc_coe_pvt.delete_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_coev_rec);

Line: 995


End delete_cond_occurs;

Line: 997


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
begin
    okc_coe_pvt.delete_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_coev_tbl);

Line: 1012


End delete_cond_occurs;

Line: 1060


    okc_aal_pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_aalv_rec,
    x_aalv_rec);

Line: 1079


    okc_aal_pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_aalv_tbl,
    x_aalv_tbl);

Line: 1123


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
begin
    okc_aal_pvt.update_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_aalv_rec,
    x_aalv_rec);

Line: 1140


End update_act_att_lkps;

Line: 1142


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
begin
    okc_aal_pvt.update_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_aalv_tbl,
    x_aalv_tbl);

Line: 1159


End update_act_att_lkps;

Line: 1161


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
begin
    okc_aal_pvt.delete_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_aalv_rec);

Line: 1176


End delete_act_att_lkps;

Line: 1178


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
begin
    okc_aal_pvt.delete_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_aalv_tbl);

Line: 1193


End delete_act_att_lkps;

Line: 1241


    okc_fep_pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_fepv_rec,
    x_fepv_rec);

Line: 1251


       Update_Minor_Version(p_fepv_rec.dnz_chr_id);

Line: 1264


    okc_fep_pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_fepv_tbl,
    x_fepv_tbl);

Line: 1308


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
begin
    okc_fep_pvt.update_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_fepv_rec,
    x_fepv_rec);

Line: 1327


       Update_Minor_Version(p_fepv_rec.dnz_chr_id);

Line: 1329


End update_func_exprs;

Line: 1331


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
begin
    okc_fep_pvt.update_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_fepv_tbl,
    x_fepv_tbl);

Line: 1348


End update_func_exprs;

Line: 1350


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
begin
    okc_fep_pvt.delete_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_fepv_rec);

Line: 1367


       Update_Minor_Version(p_fepv_rec.dnz_chr_id);

Line: 1369


End delete_func_exprs;

Line: 1371


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
begin
    okc_fep_pvt.delete_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_fepv_tbl);

Line: 1386


End delete_func_exprs;

Line: 1430


    SELECT cnl.sortseq sortseq,
	   cnl.cnl_type cnl_type,
	   cnl.aae_id aae_id,
	   cnl.pdf_id pdf_id,
	   cnl.cnh_id cnh_id,
	   cnl.left_parenthesis left_parenthesis,
	   cnl.left_ctr_master_id left_ctr_master_id,
	   cnl.left_counter_id left_counter_id,
	   cnl.relational_operator relational_operator,
	   cnl.right_ctr_master_id right_ctr_master_id,
	   cnl.right_counter_id right_counter_id,
	   cnl.right_operand right_operand,
	   cnl.right_parenthesis right_parenthesis,
	   cnl.logical_operator logical_operator
   FROM    okc_condition_lines_b cnl
   WHERE   cnl.cnh_id = p_cnh_id
   ORDER   BY cnl.sortseq;

Line: 1451


   SELECT  name
   FROM    okc_action_attributes_v
   WHERE   id = a;

Line: 1458


   SELECT  name
   FROM    okc_process_defs_v
   WHERE   id = b;

Line: 1465


   SELECT  name
   FROM    okx_counters_v
   WHERE   counter_id = x;

Line: 1470


   l_string      VARCHAR2(32000):= 'select sysdate from dual where ';