The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_cgpv_rec.last_updated_by := p_cgpv_rec1.last_updated_by;
l_cgpv_rec.last_update_date := p_cgpv_rec1.last_update_date;
l_cgpv_rec.last_update_login := p_cgpv_rec1.last_update_login;
l_cgcv_rec.last_updated_by := p_cgcv_rec1.last_updated_by;
l_cgcv_rec.last_update_date := p_cgcv_rec1.last_update_date;
l_cgcv_rec.last_update_login := p_cgcv_rec1.last_update_login;
PROCEDURE update_ctr_group(
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_cgpv_rec IN cgpv_rec_type,
x_cgpv_rec OUT NOCOPY cgpv_rec_type,
p_cgcv_tbl IN cgcv_tbl_type,
x_cgcv_tbl OUT NOCOPY cgcv_tbl_type) IS
BEGIN
okc_contract_group_pvt.update_ctr_group(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_cgpv_rec,
x_cgpv_rec,
p_cgcv_tbl,
x_cgcv_tbl);
END update_ctr_group;
PROCEDURE update_contract_group(
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_cgpv_rec IN cgpv_rec_type,
x_cgpv_rec OUT NOCOPY cgpv_rec_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'update_contract_group';
okc_contract_group_pvt.update_contract_group(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_cgpv_rec,
x_cgpv_rec);
END update_contract_group;
PROCEDURE update_contract_group(
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_cgpv_tbl IN cgpv_tbl_type,
x_cgpv_tbl OUT NOCOPY cgpv_tbl_type) IS
i NUMBER := 0;
update_contract_group(
p_api_version,
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
p_cgpv_tbl(i),
x_cgpv_tbl(i));
END update_contract_group;
PROCEDURE delete_contract_group(
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_cgpv_rec IN cgpv_rec_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'delete_contract_group';
okc_contract_group_pvt.delete_contract_group(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_cgpv_rec);
END delete_contract_group;
PROCEDURE delete_contract_group(
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_cgpv_tbl IN cgpv_tbl_type) IS
i NUMBER := 0;
delete_contract_group(
p_api_version,
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
p_cgpv_tbl(i));
END delete_contract_group;
PROCEDURE update_contract_grpngs(
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_cgcv_rec IN cgcv_rec_type,
x_cgcv_rec OUT NOCOPY cgcv_rec_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'update_contract_grpngs';
okc_contract_group_pvt.update_contract_grpngs(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_cgcv_rec,
x_cgcv_rec);
END update_contract_grpngs;
PROCEDURE update_contract_grpngs(
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_cgcv_tbl IN cgcv_tbl_type,
x_cgcv_tbl OUT NOCOPY cgcv_tbl_type) IS
i NUMBER := 0;
update_contract_grpngs(
p_api_version,
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
p_cgcv_tbl(i),
x_cgcv_tbl(i));
END update_contract_grpngs;
PROCEDURE delete_contract_grpngs(
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_cgcv_rec IN cgcv_rec_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'delete_contract_grpngs';
okc_contract_group_pvt.delete_contract_grpngs(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_cgcv_rec);
END delete_contract_grpngs;
PROCEDURE delete_contract_grpngs(
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_cgcv_tbl IN cgcv_tbl_type) IS
i NUMBER := 0;
delete_contract_grpngs(
p_api_version,
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
p_cgcv_tbl(i));
END delete_contract_grpngs;