The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE UPDATE_ACTIONS(
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_acnv_rec IN acnv_rec_type,
p_aaev_tbl IN aaev_tbl_type,
x_acnv_rec OUT NOCOPY acnv_rec_type,
x_aaev_tbl OUT NOCOPY aaev_tbl_type) IS
--l_api_vsersion CONSTANT NUMBER := 1;
update_actions(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_acnv_rec,
x_acnv_rec);
update_act_atts(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_aaev_tbl,
x_aaev_tbl);
END UPDATE_ACTIONS;
okc_acn_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_acnv_rec,
x_acnv_rec);
okc_acn_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_acnv_tbl,
x_acnv_tbl);
PROCEDURE UPDATE_ACTIONS(
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_acnv_rec IN acnv_rec_type,
x_acnv_rec OUT NOCOPY acnv_rec_type) IS
l_aaev_tbl OKC_ACTIONS_PUB.aaev_tbl_type;
SELECT *
FROM okc_action_attributes_V
WHERE acn_id = p_acnv_rec.id;
SELECT application_id INTO l_app_id1
FROM OKC_ACTIONS_B
WHERE id = p_acnv_rec.id;
okc_acn_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_acnv_rec,
x_acnv_rec);
l_aaev_tbl.delete;
v_aaev_tbl.delete;
l_aaev_tbl(l_cnt).LAST_UPDATED_BY := l_aaev_rec.LAST_UPDATED_BY;
l_aaev_tbl(l_cnt).LAST_UPDATE_DATE := l_aaev_rec.LAST_UPDATE_DATE;
l_aaev_tbl(l_cnt).LAST_UPDATE_LOGIN := l_aaev_rec.LAST_UPDATE_LOGIN;
okc_actions_pub.update_act_atts (
p_api_version => l_api_version
,p_init_msg_list => l_init_msg_list
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
,p_aaev_tbl => l_aaev_tbl
,x_aaev_tbl => v_aaev_tbl
);
END UPDATE_ACTIONS;
PROCEDURE UPDATE_ACTIONS(
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_acnv_tbl IN acnv_tbl_type,
x_acnv_tbl OUT NOCOPY acnv_tbl_type) IS
BEGIN
okc_acn_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_acnv_tbl,
x_acnv_tbl);
END UPDATE_ACTIONS;
PROCEDURE DELETE_ACTIONS(
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_acnv_rec IN acnv_rec_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
SELECT aae.id
FROM okc_action_attributes_v aae
WHERE aae.acn_id = p_acnv_rec.id;
okc_actions_pvt.delete_act_atts(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_aaev_tbl);
okc_acn_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_acnv_rec);
END DELETE_ACTIONS;
PROCEDURE DELETE_ACTIONS(
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_acnv_tbl IN acnv_tbl_type) IS
i NUMBER := 0;
delete_actions(
p_api_version
,p_init_msg_list
,x_return_status
,x_msg_count
,x_msg_data
,p_acnv_tbl(i));
END DELETE_ACTIONS;
SELECT application_id into l_app_id
FROM OKC_ACTIONS_B
WHERE ID = l_aaev_rec.acn_id;
okc_aae_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_aaev_rec,
x_aaev_rec);
okc_aae_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_aaev_tbl,
x_aaev_tbl);
PROCEDURE UPDATE_ACT_ATTS(
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_aaev_rec IN aaev_rec_type,
x_aaev_rec OUT NOCOPY aaev_rec_type) IS
BEGIN
okc_aae_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_aaev_rec,
x_aaev_rec);
END UPDATE_ACT_ATTS;
PROCEDURE UPDATE_ACT_ATTS(
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_aaev_tbl IN aaev_tbl_type,
x_aaev_tbl OUT NOCOPY aaev_tbl_type) IS
BEGIN
okc_aae_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_aaev_tbl,
x_aaev_tbl);
END UPDATE_ACT_ATTS;
PROCEDURE DELETE_ACT_ATTS(
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_aaev_rec IN aaev_rec_type) IS
BEGIN
okc_aae_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_aaev_rec);
END DELETE_ACT_ATTS;
PROCEDURE DELETE_ACT_ATTS(
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_aaev_tbl IN aaev_tbl_type) IS
BEGIN
okc_aae_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_aaev_tbl);
END DELETE_ACT_ATTS;