DBA Data[Home] [Help]

APPS.OKC_SECTIONS_PUB SQL Statements

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

Line: 223

  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 scnv_rec_type,
    x_scnv_rec                     OUT NOCOPY scnv_rec_type) IS

    l_scnv_rec		scnv_rec_type;
Line: 233

    l_api_name		CONSTANT VARCHAR2(30) := 'UPDATE_SECTION';
Line: 277

    OKC_SECTIONS_PVT.update_section(
	 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: 339

  END update_section;
Line: 341

  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 scnv_tbl_type,
    x_scnv_tbl                     OUT NOCOPY scnv_tbl_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'UPDATE_SECTION';
Line: 378

		OKC_SECTIONS_PUB.update_section(
			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_tbl(i),
			x_scnv_rec		=> x_scnv_tbl(i));
Line: 437

  END update_section;
Line: 439

  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 scnv_rec_type) IS

    l_scnv_rec		scnv_rec_type;
Line: 448

    l_api_name		CONSTANT VARCHAR2(30) := 'DELETE_SECTION';
Line: 492

    OKC_SECTIONS_PVT.delete_section(
	 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);
Line: 550

  END delete_section;
Line: 552

  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 scnv_tbl_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'DELETE_SECTION';
Line: 588

		OKC_SECTIONS_PUB.delete_section(
			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_tbl(i));
Line: 646

  END delete_section;
Line: 1282

  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 sccv_rec_type,
    x_sccv_rec                     OUT NOCOPY sccv_rec_type) IS

    l_sccv_rec		sccv_rec_type;
Line: 1292

    l_api_name		CONSTANT VARCHAR2(30) := 'UPDATE_SECTION_CONTENT';
Line: 1336

    OKC_SECTIONS_PVT.update_section_content(
	 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: 1398

  END update_section_content;
Line: 1400

  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 sccv_tbl_type,
    x_sccv_tbl                     OUT NOCOPY sccv_tbl_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'UPDATE_SECTION_CONTENT';
Line: 1437

		OKC_SECTIONS_PUB.update_section_content(
			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_tbl(i),
			x_sccv_rec		=> x_sccv_tbl(i));
Line: 1496

  END update_section_content;
Line: 1498

  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 sccv_rec_type) IS

    l_sccv_rec		sccv_rec_type;
Line: 1507

    l_api_name		CONSTANT VARCHAR2(30) := 'DELETE_SECTION_CONTENT';
Line: 1551

    OKC_SECTIONS_PVT.delete_section_content(
	 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);
Line: 1609

  END delete_section_content;
Line: 1611

  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 sccv_tbl_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'DELETE_SECTION_CONTENT';
Line: 1647

		OKC_SECTIONS_PUB.delete_section_content(
			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_tbl(i));
Line: 1705

  END delete_section_content;