The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_ocev_rec.last_updated_by := p_ocev_rec1.last_updated_by;
l_ocev_rec.last_update_date := p_ocev_rec1.last_update_date;
l_ocev_rec.last_update_login := p_ocev_rec1.last_update_login;
l_oatv_rec.last_updated_by := p_oatv_rec1.last_updated_by;
l_oatv_rec.last_update_date := p_oatv_rec1.last_update_date;
l_oatv_rec.last_update_login := p_oatv_rec1.last_update_login;
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_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'update_outcomes_args';
l_proc varchar2(72) := ' okc_outcome_pub.'||'update_outcomes_args';
okc_outcome_pvt.update_outcomes_args(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_ocev_rec,
p_oatv_tbl,
x_ocev_rec,
x_oatv_tbl);
END update_outcomes_args;
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
l_api_name CONSTANT VARCHAR2(30) := 'update_outcome';
l_proc varchar2(72) := ' okc_outcome_pub.'||'update_outcome';
okc_outcome_pvt.update_outcome(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_ocev_rec => l_ocev_rec,
x_ocev_rec => x_ocev_rec);
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
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
l_proc varchar2(72) := ' okc_outcome_pub.'||'update_outcome';
update_outcome(
p_api_version,
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
p_ocev_tbl(i),
x_ocev_tbl(i));
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_api_name CONSTANT VARCHAR2(30) := 'delete_outcome';
l_proc varchar2(72) := ' okc_outcome_pub.'||'delete_outcome';
okc_outcome_pvt.delete_outcome(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_ocev_rec => l_ocev_rec);
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
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
l_proc varchar2(72) := ' okc_outcome_pub.'||'delete_outcome';
delete_outcome(
p_api_version,
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
p_ocev_tbl(i));
END delete_outcome;
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
l_api_name CONSTANT VARCHAR2(30) := 'update_out_arg';
l_proc varchar2(72) := ' okc_outcome_pub.'||'update_out_arg';
okc_outcome_pvt.update_out_arg(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_oatv_rec => l_oatv_rec,
x_oatv_rec => x_oatv_rec);
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
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
l_proc varchar2(72) := ' okc_outcome_pub.'||'update_out_arg';
update_out_arg(
p_api_version,
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
p_oatv_tbl(i),
x_oatv_tbl(i));
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
l_api_name CONSTANT VARCHAR2(30) := 'delete_out_arg';
l_proc varchar2(72) := ' okc_outcome_pub.'||'delete_out_arg';
okc_outcome_pvt.delete_out_arg(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_oatv_rec => l_oatv_rec);
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
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
l_proc varchar2(72) := ' okc_outcome_pub.'||'delete_out_arg';
delete_out_arg(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_oatv_tbl(i));
END delete_out_arg;