DBA Data[Home] [Help]

APPS.OKC_SECTIONS_PVT SQL Statements

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

Line: 19

  G_NO_UPDATE_ALLOWED_EXCEPTION exception;
Line: 20

  G_NO_UPDATE_ALLOWED CONSTANT VARCHAR2(200) := 'OKC_NO_UPDATE_ALLOWED';
Line: 24

  FUNCTION Update_Minor_Version(p_chr_id IN NUMBER) RETURN VARCHAR2 Is
	l_api_version                 NUMBER := 1;
Line: 40

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

    OKC_SCN_PVT.Insert_Row(
	       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_scnv_rec		=> l_scnv_rec,
            x_scnv_rec		=> x_scnv_rec);
Line: 94

	  x_return_status := Update_Minor_Version(p_scnv_rec.chr_id);
Line: 109

    OKC_SCN_PVT.Insert_Row(
	 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_scnv_tbl		=> p_scnv_tbl,
      x_scnv_tbl		=> x_scnv_tbl);
Line: 119

  PROCEDURE update_section(
    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_scnv_rec                     IN OKC_SCN_PVT.scnv_rec_type,
    x_scnv_rec                     OUT NOCOPY OKC_SCN_PVT.scnv_rec_type) IS

  BEGIN

    OKC_SCN_PVT.Update_Row(
	 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_scnv_rec			=> p_scnv_rec,
      x_scnv_rec			=> x_scnv_rec);
Line: 143

	  x_return_status := Update_Minor_Version(p_scnv_rec.chr_id);
Line: 157

  END update_section;
Line: 159

  PROCEDURE update_section(
    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_scnv_tbl                     IN OKC_SCN_PVT.scnv_tbl_type,
    x_scnv_tbl                     OUT NOCOPY OKC_SCN_PVT.scnv_tbl_type) IS

  BEGIN
    OKC_SCN_PVT.Update_Row(
	 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_scnv_tbl			=> p_scnv_tbl,
      x_scnv_tbl			=> x_scnv_tbl);
Line: 177

  END update_section;
Line: 179

  PROCEDURE delete_section(
    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_scnv_rec                     IN OKC_SCN_PVT.scnv_rec_type) IS

    l_chr_id NUMBER;
Line: 189

		SELECT chr_id
		FROM okc_sections_b
		WHERE id = p_scnv_rec.ID;
Line: 198

    OKC_SCN_PVT.Delete_Row(
	 		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_scnv_rec		=> p_scnv_rec);
Line: 210

	  x_return_status := Update_Minor_Version(l_chr_id);
Line: 225

  END delete_section;
Line: 227

  PROCEDURE delete_section(
    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_scnv_tbl                     IN OKC_SCN_PVT.scnv_tbl_type) IS

  BEGIN
    OKC_SCN_PVT.Delete_Row(
	 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_scnv_tbl		=> p_scnv_tbl);
Line: 243

  END delete_section;
Line: 319

		SELECT chr_id
		FROM okc_sections_b
		WHERE id = p_scn_id;
Line: 349

    OKC_SCC_PVT.Insert_Row(
	       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_sccv_rec		=> l_sccv_rec,
            x_sccv_rec		=> x_sccv_rec);
Line: 363

	       x_return_status := Update_Minor_Version(l_chr_id);
Line: 378

    OKC_SCC_PVT.Insert_Row(
	 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_sccv_tbl		=> p_sccv_tbl,
      x_sccv_tbl		=> x_sccv_tbl);
Line: 388

  PROCEDURE update_section_content(
    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_sccv_rec                     IN OKC_SCC_PVT.sccv_rec_type,
    x_sccv_rec                     OUT NOCOPY OKC_SCC_PVT.sccv_rec_type) IS

     l_chr_id NUMBER := -1;
Line: 400

    OKC_SCC_PVT.Update_Row(
	 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_sccv_rec			=> p_sccv_rec,
      x_sccv_rec			=> x_sccv_rec);
Line: 413

	       x_return_status := Update_Minor_Version(l_chr_id);
Line: 428

  END update_section_content;
Line: 430

  PROCEDURE update_section_content(
    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_sccv_tbl                     IN OKC_SCC_PVT.sccv_tbl_type,
    x_sccv_tbl                     OUT NOCOPY OKC_SCC_PVT.sccv_tbl_type) IS

  BEGIN
    OKC_SCC_PVT.Update_Row(
	 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_sccv_tbl			=> p_sccv_tbl,
      x_sccv_tbl			=> x_sccv_tbl);
Line: 448

  END update_section_content;
Line: 450

  PROCEDURE delete_section_content(
    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_sccv_rec                     IN OKC_SCC_PVT.sccv_rec_type) IS

    l_chr_id NUMBER;
Line: 461

    OKC_SCC_PVT.Delete_Row(
	 		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_sccv_rec		=> p_sccv_rec);
Line: 473

	       x_return_status := Update_Minor_Version(l_chr_id);
Line: 488

  END delete_section_content;
Line: 490

  PROCEDURE delete_section_content(
    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_sccv_tbl                     IN OKC_SCC_PVT.sccv_tbl_type) IS

  BEGIN
    OKC_SCC_PVT.Delete_Row(
	 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_sccv_tbl		=> p_sccv_tbl);
Line: 506

  END delete_section_content;