The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_acnv_rec.last_updated_by := p_acnv_rec1.last_updated_by;
l_acnv_rec.last_update_date := p_acnv_rec1.last_update_date;
l_acnv_rec.last_update_login := p_acnv_rec1.last_update_login;
l_aaev_rec.last_updated_by := p_aaev_rec1.last_updated_by;
l_aaev_rec.last_update_date := p_aaev_rec1.last_update_date;
l_aaev_rec.last_update_login := p_aaev_rec1.last_update_login;
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_name CONSTANT VARCHAR2(30) := 'update_actions';
okc_actions_pvt.update_actions(p_api_version
,p_init_msg_list
,x_return_status
,x_msg_count
,x_msg_data
,p_acnv_rec
,p_aaev_tbl
,x_acnv_rec
,x_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
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
update_actions(
p_api_version
,p_init_msg_list
,l_return_status
,x_msg_count
,x_msg_data
,p_acnv_tbl(i)
,x_acnv_tbl(i));
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_rec IN acnv_rec_type,
x_acnv_rec OUT NOCOPY acnv_rec_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'update_actions';
okc_actions_pvt.update_actions(p_api_version
,p_init_msg_list
,x_return_status
,x_msg_count
,x_msg_data
,l_acnv_rec
,x_acnv_rec);
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_tbl IN acnv_tbl_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
delete_actions(
p_api_version
,p_init_msg_list
,l_return_status
,x_msg_count
,x_msg_data
,p_acnv_tbl(i));
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_rec IN acnv_rec_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'delete_actions';
okc_actions_pvt.delete_actions(p_api_version
,p_init_msg_list
,x_return_status
,x_msg_count
,x_msg_data
,l_acnv_rec);
END delete_actions;
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
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
update_act_atts(
p_api_version
,p_init_msg_list
,l_return_status
,x_msg_count
,x_msg_data
,p_aaev_tbl(i)
,x_aaev_tbl(i));
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_rec IN aaev_rec_type,
x_aaev_rec OUT NOCOPY aaev_rec_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'update_act_atts';
okc_actions_pvt.update_act_atts(p_api_version
,p_init_msg_list
,x_return_status
,x_msg_count
,x_msg_data
,l_aaev_rec
,x_aaev_rec);
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_tbl IN aaev_tbl_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
delete_act_atts(
p_api_version
,p_init_msg_list
,l_return_status
,x_msg_count
,x_msg_data
,p_aaev_tbl(i));
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_rec IN aaev_rec_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'delete_act_atts';
okc_actions_pvt.delete_act_atts(p_api_version
,p_init_msg_list
,x_return_status
,x_msg_count
,x_msg_data
,l_aaev_rec);
END delete_act_atts;