APPS.OKC_PROCESS_PUB SQL Statements

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

Line: 14

    l_pdfv_rec.last_updated_by       := p_pdfv_rec1.last_updated_by;

Line: 15

    l_pdfv_rec.last_update_date      := p_pdfv_rec1.last_update_date;

Line: 16

    l_pdfv_rec.last_update_login     := p_pdfv_rec1.last_update_login;

Line: 63

    l_pdpv_rec.last_updated_by       := p_pdpv_rec1.last_updated_by;

Line: 64

    l_pdpv_rec.last_update_date      := p_pdpv_rec1.last_update_date;

Line: 65

    l_pdpv_rec.last_update_login     := p_pdpv_rec1.last_update_login;

Line: 157

  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_api_version           CONSTANT NUMBER := 1;

Line: 169

    l_api_name              CONSTANT VARCHAR2(30) := 'V_update_process_def';

Line: 184

    okc_process_pvt.update_process_def(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_pdfv_rec,
	    p_pdpv_tbl,
	    x_pdfv_rec,
	    x_pdpv_tbl);

Line: 226

  END update_process_def;

Line: 579

  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_api_name	 CONSTANT VARCHAR2(30) := 'update_proc_def';

Line: 624

	okc_process_pvt.update_proc_def(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_pdfv_rec      => l_pdfv_rec,
    				    x_pdfv_rec      => x_pdfv_rec);

Line: 688

  end update_proc_def;

Line: 690

  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

        l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line: 705

        update_proc_def(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_pdfv_tbl(i),
	    x_pdfv_tbl(i));

Line: 737

  END update_proc_def;

Line: 739

  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_api_name	 CONSTANT VARCHAR2(30) := 'delete_proc_def';

Line: 782

	okc_process_pvt.delete_proc_def(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_pdfv_rec      => l_pdfv_rec);

Line: 842

  end delete_proc_def;

Line: 844

  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

        l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line: 858

        delete_proc_def(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_pdfv_tbl(i));

Line: 889

  END delete_proc_def;

Line: 1212

  	 l_api_name	 CONSTANT VARCHAR2(30) := 'delete_proc_def_parms';

Line: 1328

  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

	 l_api_name	 CONSTANT VARCHAR2(30) := 'update_proc_def_parms';

Line: 1371

	okc_process_pvt.update_proc_def_parms(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_pdpv_rec      => l_pdpv_rec,
    				    	  x_pdpv_rec      => x_pdpv_rec);

Line: 1434

  END update_proc_def_parms;

Line: 1436

  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

	l_return_status  VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line: 1453

        update_proc_def_parms(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_pdpv_tbl(i),
	    x_pdpv_tbl(i));

Line: 1485

  END update_proc_def_parms;

Line: 1487

  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

	 l_api_name	 CONSTANT VARCHAR2(30) := 'delete_proc_def_parms';

Line: 1530

	okc_process_pvt.delete_proc_def_parms(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_pdpv_rec      => l_pdpv_rec);

Line: 1589

  END delete_proc_def_parms;

Line: 1591

  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

	l_return_status  VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line: 1607

        delete_proc_def_parms(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_pdpv_tbl(i));

Line: 1638

  END delete_proc_def_parms;