The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE update_outcomes_args(
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_ocev_rec IN ocev_rec_type,
p_oatv_tbl IN oatv_tbl_type,
x_ocev_rec OUT NOCOPY ocev_rec_type,
x_oatv_tbl OUT NOCOPY oatv_tbl_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
update_outcome(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_ocev_rec,
x_ocev_rec);
update_out_arg(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_oatv_tbl,
x_oatv_tbl);
end update_outcomes_args;
Procedure Update_Minor_Version(p_chr_id NUMBER) Is
l_api_version NUMBER := 1;
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);
End update_minor_version;
okc_oce_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_ocev_rec,
x_ocev_rec);
update_minor_version(p_ocev_rec.dnz_chr_id);
okc_oce_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_ocev_tbl,
x_ocev_tbl);
PROCEDURE update_outcome(
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_ocev_rec IN ocev_rec_type,
x_ocev_rec OUT NOCOPY ocev_rec_type) IS
begin
okc_oce_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_ocev_rec,
x_ocev_rec);
update_minor_version(p_ocev_rec.dnz_chr_id);
End update_outcome;
PROCEDURE update_outcome(
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_ocev_tbl IN ocev_tbl_type,
x_ocev_tbl OUT NOCOPY ocev_tbl_type) IS
begin
okc_oce_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_ocev_tbl,
x_ocev_tbl);
End update_outcome;
PROCEDURE delete_outcome(
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_ocev_rec IN ocev_rec_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
select oat.id
from okc_outcome_arguments_v oat
where oat.oce_id = p_ocev_rec.id;
okc_outcome_pub.delete_out_arg(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_oatv_tbl);
--Delete the Master
okc_oce_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_ocev_rec);
--Update minor version
update_minor_version(p_ocev_rec.dnz_chr_id);
End delete_outcome;
PROCEDURE delete_outcome(
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_ocev_tbl IN ocev_tbl_type) IS
i NUMBER :=0;
delete_outcome(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_ocev_tbl(i));
End delete_outcome;
okc_oat_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_oatv_rec,
x_oatv_rec);
update_minor_version(p_oatv_rec.dnz_chr_id);
okc_oat_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_oatv_tbl,
x_oatv_tbl);
PROCEDURE update_out_arg(
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_oatv_rec IN oatv_rec_type,
x_oatv_rec OUT NOCOPY oatv_rec_type) IS
begin
okc_oat_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_oatv_rec,
x_oatv_rec);
update_minor_version(p_oatv_rec.dnz_chr_id);
End update_out_arg;
PROCEDURE update_out_arg(
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_oatv_tbl IN oatv_tbl_type,
x_oatv_tbl OUT NOCOPY oatv_tbl_type) IS
begin
okc_oat_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_oatv_tbl,
x_oatv_tbl);
End update_out_arg;
PROCEDURE delete_out_arg(
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_oatv_rec IN oatv_rec_type) IS
begin
okc_oat_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_oatv_rec);
update_minor_version(p_oatv_rec.dnz_chr_id);
End delete_out_arg;
PROCEDURE delete_out_arg(
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_oatv_tbl IN oatv_tbl_type) IS
begin
okc_oat_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_oatv_tbl);
End delete_out_arg;