The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_aqev_rec.last_updated_by := p_aqev_rec1.last_updated_by;
l_aqev_rec.last_update_date := p_aqev_rec1.last_update_date;
l_aqev_rec.last_update_login := p_aqev_rec1.last_update_login;
l_aqmv_rec.last_updated_by := p_aqmv_rec1.last_updated_by;
l_aqmv_rec.last_update_date := p_aqmv_rec1.last_update_date;
l_aqmv_rec.last_update_login := p_aqmv_rec1.last_update_login;
okc_aqe_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_aqev_rec,
x_aqev_rec);
okc_aqm_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_aqmv_tbl,
x_aqmv_tbl);
PROCEDURE update_err_msg(
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_aqev_rec IN aqev_rec_type,
p_aqmv_tbl IN aqmv_tbl_type,
x_aqev_rec OUT NOCOPY aqev_rec_type,
x_aqmv_tbl OUT NOCOPY aqmv_tbl_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'update_err_msg';
okc_aqe_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_aqev_rec,
x_aqev_rec);
okc_aqm_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_aqmv_tbl,
x_aqmv_tbl);
END update_err_msg;
okc_aqe_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_aqev_rec => l_aqev_rec,
x_aqev_rec => x_aqev_rec);
PROCEDURE update_err(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_aqev_rec IN aqev_rec_type,
x_aqev_rec OUT NOCOPY aqev_rec_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'update_err';
okc_aqe_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_aqev_rec => l_aqev_rec,
x_aqev_rec => x_aqev_rec);
end update_err;
PROCEDURE update_err(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_aqev_tbl IN aqev_tbl_type,
x_aqev_tbl OUT NOCOPY aqev_tbl_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
update_err(
p_api_version,
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
p_aqev_tbl(i),
x_aqev_tbl(i));
END update_err;
PROCEDURE delete_err(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_aqev_rec IN aqev_rec_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'delete_err';
okc_aqe_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_aqev_rec => l_aqev_rec);
end delete_err;
PROCEDURE delete_err(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_aqev_tbl IN aqev_tbl_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
delete_err(
p_api_version,
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
p_aqev_tbl(i));
END delete_err;
okc_aqm_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_aqmv_rec => l_aqmv_rec,
x_aqmv_rec => x_aqmv_rec);
PROCEDURE update_msg(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_aqmv_rec IN aqmv_rec_type,
x_aqmv_rec OUT NOCOPY aqmv_rec_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'update_msg';
okc_aqm_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_aqmv_rec => l_aqmv_rec,
x_aqmv_rec => x_aqmv_rec);
END update_msg;
PROCEDURE update_msg(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_aqmv_tbl IN aqmv_tbl_type,
x_aqmv_tbl OUT NOCOPY aqmv_tbl_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
update_msg(
p_api_version,
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
p_aqmv_tbl(i),
x_aqmv_tbl(i));
END update_msg;
PROCEDURE delete_msg(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_aqmv_rec IN aqmv_rec_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'delete_msg';
okc_aqm_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_aqmv_rec => l_aqmv_rec);
END delete_msg;
PROCEDURE delete_msg(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_aqmv_tbl IN aqmv_tbl_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
delete_msg(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_aqmv_tbl(i));
END delete_msg;