DBA Data[Home] [Help]

APPS.OKC_PROCESS_PVT SQL Statements

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

Line: 88

PROCEDURE update_process_def(
    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_pdfv_rec		    IN pdfv_rec_type,
    p_pdpv_tbl              IN pdpv_tbl_type,
    x_pdfv_rec              OUT NOCOPY pdfv_rec_type,
    x_pdpv_tbl              OUT NOCOPY pdpv_tbl_type) IS
    l_return_status         VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 101

    update_proc_def(
    	p_api_version,
    	p_init_msg_list,
    	x_return_status,
    	x_msg_count,
    	x_msg_data,
    	p_pdfv_rec,
    	x_pdfv_rec);
Line: 118

    update_proc_def_parms(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_pdpv_tbl,
    x_pdpv_tbl);
Line: 146

end update_process_def;
Line: 216

    okc_pdf_pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_pdfv_rec,
    x_pdfv_rec);
Line: 235

    okc_pdf_pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_pdfv_tbl,
    x_pdfv_tbl);
Line: 279

PROCEDURE update_proc_def(
    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_pdfv_rec		    IN pdfv_rec_type,
    x_pdfv_rec              OUT NOCOPY pdfv_rec_type) IS
    l_pdpv_tbl              OKC_PROCESS_PUB.pdpv_tbl_type;
Line: 297

   SELECT *
   FROM okc_process_def_parameters_v
   WHERE pdf_id = p_pdfv_rec.id;
Line: 301

    SELECT application_id INTO l_app_id1
    FROM OKC_PROCESS_DEFS_B
    WHERE id = p_pdfv_rec.id;
Line: 305

    okc_pdf_pvt.update_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_pdfv_rec,
    x_pdfv_rec);
Line: 315

        l_pdpv_tbl.delete;
Line: 316

        v_pdpv_tbl.delete;
Line: 333

         l_pdpv_tbl(l_cnt).last_updated_by := l_pdpv_rec.last_updated_by;
Line: 334

         l_pdpv_tbl(l_cnt).last_update_date := l_pdpv_rec.last_update_date;
Line: 335

         l_pdpv_tbl(l_cnt).last_update_login := l_pdpv_rec.last_update_login;
Line: 340

  okc_process_pub.update_proc_def_parms(
   p_api_version    =>  l_api_version,
   p_init_msg_list  =>  l_init_msg_list,
   x_return_status  =>  l_return_status,
   x_msg_count      =>  l_msg_count,
   x_msg_data       =>  l_msg_data,
   p_pdpv_tbl      =>   l_pdpv_tbl,
   x_pdpv_tbl      =>   v_pdpv_tbl);
Line: 350

End update_proc_def;
Line: 352

PROCEDURE update_proc_def(
    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_pdfv_tbl		    IN pdfv_tbl_type,
    x_pdfv_tbl              OUT NOCOPY pdfv_tbl_type) IS
begin
    okc_pdf_pvt.update_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_pdfv_tbl,
    x_pdfv_tbl);
Line: 369

End update_proc_def;
Line: 372

PROCEDURE delete_proc_def(
    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_pdfv_rec		    IN pdfv_rec_type) IS

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

    select pdp.id
    from okc_process_def_parameters_v pdp
    where pdp.pdf_id = p_pdfv_rec.id;
Line: 396

    select '1'
    from okc_process_defs_v pdf,
	okc_outcomes_v out,
	okc_condition_headers_v cnh
    where pdf.id = out.pdf_id
    and pdf.id = p_pdf_id
    and out.cnh_id = cnh.id;
Line: 405

    select '1'
    from okc_process_defs_v pdf,
	okc_qa_list_processes qa
    where pdf.id = qa.pdf_id
    and pdf.id = p_pdf_id;
Line: 412

    select '1'
    from okc_process_defs_v pdf,
	okc_k_processes k
    where pdf.id = k.pdf_id
    and pdf.id = p_pdf_id;
Line: 434

                       	    p_msg_name     => g_delete_proc_def);
Line: 446

       	okc_process_pub.delete_proc_def_parms(
    			p_api_version,
    			p_init_msg_list,
    			x_return_status,
    			x_msg_count,
    			x_msg_data,
    			l_pdpv_tbl);
Line: 461

	--Delete the Master
        okc_pdf_pvt.delete_row(
    		p_api_version,
    		p_init_msg_list,
    		x_return_status,
    		x_msg_count,
    		x_msg_data,
    		p_pdfv_rec);
Line: 489

End delete_proc_def;
Line: 491

PROCEDURE delete_proc_def(
    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_pdfv_tbl		    IN pdfv_tbl_type) IS
    i	                    NUMBER :=0;
Line: 507

          delete_proc_def(
    		p_api_version,
    		p_init_msg_list,
    		x_return_status,
    		x_msg_count,
    		x_msg_data,
    		p_pdfv_tbl(i));
Line: 537

End delete_proc_def;
Line: 586

   SELECT application_id into l_app_id
   FROM OKC_PROCESS_DEFS_B
   WHERE ID = l_pdpv_rec.pdf_id;
Line: 590

    okc_pdp_pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    l_pdpv_rec,
    x_pdpv_rec);
Line: 609

    okc_pdp_pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_pdpv_tbl,
    x_pdpv_tbl);
Line: 653

PROCEDURE update_proc_def_parms(
    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_pdpv_rec		    IN pdpv_rec_type,
    x_pdpv_rec              OUT NOCOPY pdpv_rec_type) IS
begin
    okc_pdp_pvt.update_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_pdpv_rec,
    x_pdpv_rec);
Line: 670

End update_proc_def_parms;
Line: 672

PROCEDURE update_proc_def_parms(
    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_pdpv_tbl		    IN pdpv_tbl_type,
    x_pdpv_tbl              OUT NOCOPY pdpv_tbl_type) IS
begin
    okc_pdp_pvt.update_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_pdpv_tbl,
    x_pdpv_tbl);
Line: 689

End update_proc_def_parms;
Line: 691

PROCEDURE delete_proc_def_parms(
    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_pdpv_rec		    IN pdpv_rec_type) IS
begin
    okc_pdp_pvt.delete_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_pdpv_rec);
Line: 706

End delete_proc_def_parms;
Line: 708

PROCEDURE delete_proc_def_parms(
    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_pdpv_tbl		    IN pdpv_tbl_type) IS
begin
    okc_pdp_pvt.delete_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_pdpv_tbl);
Line: 723

End delete_proc_def_parms;
Line: 780

		SELECT    RUNNABLE_FLAG
		 FROM     wf_activities_vl w
           WHERE    w.item_type = UPPER(wfname)
		   AND    w.name = UPPER(wfproc)
		   AND    w.version = (SELECT max(version)
							FROM wf_activities_vl sq
                                  WHERE sq.item_type = UPPER(wfname)
							 AND sq.name = UPPER(wfproc) );
Line: 790

		SELECT    1
		  FROM    user_arguments a,
				user_objects o
           WHERE    o.object_type = 'PACKAGE'
		   and    o.object_name = UPPER(packname)
		   and    a.object_id = o.object_id
		   AND    a.object_name = UPPER(procname);