The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_SECTION';
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);
END update_section;
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';
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));
END update_section;
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;
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_SECTION';
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);
END delete_section;
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';
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));
END delete_section;
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;
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_SECTION_CONTENT';
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);
END update_section_content;
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';
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));
END update_section_content;
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;
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_SECTION_CONTENT';
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);
END delete_section_content;
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';
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));
END delete_section_content;