The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_cnhv_rec.last_updated_by := p_cnhv_rec1.last_updated_by;
l_cnhv_rec.last_update_date := p_cnhv_rec1.last_update_date;
l_cnhv_rec.last_update_login := p_cnhv_rec1.last_update_login;
l_cnlv_rec.last_updated_by := p_cnlv_rec1.last_updated_by;
l_cnlv_rec.last_update_date := p_cnlv_rec1.last_update_date;
l_cnlv_rec.last_update_login := p_cnlv_rec1.last_update_login;
l_coev_rec.last_updated_by := p_coev_rec1.last_updated_by;
l_coev_rec.last_update_date := p_coev_rec1.last_update_date;
l_coev_rec.last_update_login := p_coev_rec1.last_update_login;
l_aavv_rec.last_updated_by := p_aavv_rec1.last_updated_by;
l_aavv_rec.last_update_date := p_aavv_rec1.last_update_date;
l_aavv_rec.last_update_login := p_aavv_rec1.last_update_login;
l_aalv_rec.last_updated_by := p_aalv_rec1.last_updated_by;
l_aalv_rec.last_update_date := p_aalv_rec1.last_update_date;
l_aalv_rec.last_update_login := p_aalv_rec1.last_update_login;
l_fepv_rec.last_updated_by := p_fepv_rec1.last_updated_by;
l_fepv_rec.last_update_date := p_fepv_rec1.last_update_date;
l_fepv_rec.last_update_login := p_fepv_rec1.last_update_login;
PROCEDURE update_cond_hdrs(
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_cnhv_rec IN cnhv_rec_type,
p_cnlv_tbl IN cnlv_tbl_type,
x_cnhv_rec OUT NOCOPY cnhv_rec_type,
x_cnlv_tbl OUT NOCOPY cnlv_tbl_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_update_cond_hdrs';
okc_conditions_pvt.update_cond_hdrs(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_cnhv_rec,
p_cnlv_tbl,
x_cnhv_rec,
x_cnlv_tbl);
END update_cond_hdrs;
PROCEDURE update_cond_hdrs(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_cnhv_rec IN cnhv_rec_type,
x_cnhv_rec OUT NOCOPY cnhv_rec_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'update_cond_hdrs';
okc_conditions_pvt.update_cond_hdrs(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_cnhv_rec => l_cnhv_rec,
x_cnhv_rec => x_cnhv_rec);
end update_cond_hdrs;
PROCEDURE update_cond_hdrs(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_cnhv_tbl IN cnhv_tbl_type,
x_cnhv_tbl OUT NOCOPY cnhv_tbl_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
update_cond_hdrs(
p_api_version,
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
p_cnhv_tbl(i),
x_cnhv_tbl(i));
END update_cond_hdrs;
PROCEDURE delete_cond_hdrs(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_cnhv_rec IN cnhv_rec_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'delete_cond_hdrs';
okc_conditions_pvt.delete_cond_hdrs(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_cnhv_rec => l_cnhv_rec);
end delete_cond_hdrs;
PROCEDURE delete_cond_hdrs(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_cnhv_tbl IN cnhv_tbl_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
delete_cond_hdrs(
p_api_version,
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
p_cnhv_tbl(i));
END delete_cond_hdrs;
PROCEDURE update_cond_lines(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_cnlv_rec IN cnlv_rec_type,
x_cnlv_rec OUT NOCOPY cnlv_rec_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'update_cond_lines';
okc_conditions_pvt.update_cond_lines(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_cnlv_rec => l_cnlv_rec,
x_cnlv_rec => x_cnlv_rec);
END update_cond_lines;
PROCEDURE update_cond_lines(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_cnlv_tbl IN cnlv_tbl_type,
x_cnlv_tbl OUT NOCOPY cnlv_tbl_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
update_cond_lines(
p_api_version,
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
p_cnlv_tbl(i),
x_cnlv_tbl(i));
END update_cond_lines;
PROCEDURE delete_cond_lines(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_cnlv_rec IN cnlv_rec_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'delete_cond_lines';
okc_conditions_pvt.delete_cond_lines(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_cnlv_rec => l_cnlv_rec);
END delete_cond_lines;
PROCEDURE delete_cond_lines(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_cnlv_tbl IN cnlv_tbl_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
delete_cond_lines(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_cnlv_tbl(i));
END delete_cond_lines;
PROCEDURE delete_cond_occurs(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_coev_rec IN coev_rec_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'delete_cond_occurs';
okc_conditions_pvt.delete_cond_occurs(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_coev_rec => l_coev_rec);
END delete_cond_occurs;
PROCEDURE delete_cond_occurs(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_coev_tbl IN coev_tbl_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
delete_cond_occurs(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_coev_tbl(i));
END delete_cond_occurs;
PROCEDURE delete_act_att_vals(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_aavv_rec IN aavv_rec_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'delete_act_att_vals';
okc_conditions_pvt.delete_act_att_vals(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_aavv_rec => l_aavv_rec);
END delete_act_att_vals;
PROCEDURE delete_act_att_vals(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_aavv_tbl IN aavv_tbl_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
delete_act_att_vals(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_aavv_tbl(i));
END delete_act_att_vals;
l_api_name CONSTANT VARCHAR2(30) := 'delete_act_att_lkps';
PROCEDURE update_act_att_lkps(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_aalv_rec IN aalv_rec_type,
x_aalv_rec OUT NOCOPY aalv_rec_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'update_act_att_lkps';
okc_conditions_pvt.update_act_att_lkps(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_aalv_rec => l_aalv_rec,
x_aalv_rec => x_aalv_rec);
END update_act_att_lkps;
PROCEDURE update_act_att_lkps(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_aalv_tbl IN aalv_tbl_type,
x_aalv_tbl OUT NOCOPY aalv_tbl_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
update_act_att_lkps(
p_api_version,
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
p_aalv_tbl(i),
x_aalv_tbl(i));
END update_act_att_lkps;
PROCEDURE delete_act_att_lkps(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_aalv_rec IN aalv_rec_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'delete_act_att_lkps';
okc_conditions_pvt.delete_act_att_lkps(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_aalv_rec => l_aalv_rec);
END delete_act_att_lkps;
PROCEDURE delete_act_att_lkps(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_aalv_tbl IN aalv_tbl_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
delete_act_att_lkps(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_aalv_tbl(i));
END delete_act_att_lkps;
PROCEDURE update_func_exprs(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_fepv_rec IN fepv_rec_type,
x_fepv_rec OUT NOCOPY fepv_rec_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'update_func_exprs';
okc_conditions_pvt.update_func_exprs(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_fepv_rec => l_fepv_rec,
x_fepv_rec => x_fepv_rec);
END update_func_exprs;
PROCEDURE update_func_exprs(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_fepv_tbl IN fepv_tbl_type,
x_fepv_tbl OUT NOCOPY fepv_tbl_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
update_func_exprs(
p_api_version,
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
p_fepv_tbl(i),
x_fepv_tbl(i));
END update_func_exprs;
PROCEDURE delete_func_exprs(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_fepv_rec IN fepv_rec_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'delete_func_exprs';
okc_conditions_pvt.delete_func_exprs(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_fepv_rec => l_fepv_rec);
END delete_func_exprs;
PROCEDURE delete_func_exprs(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_fepv_tbl IN fepv_tbl_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
delete_func_exprs(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_fepv_tbl(i));
END delete_func_exprs;