The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_astv_rec.last_updated_by := p_astv_rec1.last_updated_by;
l_astv_rec.last_update_date := p_astv_rec1.last_update_date;
l_astv_rec.last_update_login := p_astv_rec1.last_update_login;
l_stsv_rec.last_updated_by := p_stsv_rec1.last_updated_by;
l_stsv_rec.last_update_date := p_stsv_rec1.last_update_date;
l_stsv_rec.last_update_login := p_stsv_rec1.last_update_login;
PROCEDURE update_assent(
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_astv_rec IN astv_rec_type,
x_astv_rec OUT NOCOPY astv_rec_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'update_assent';
OKC_ASSENT_PVT.update_assent(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_astv_rec,
x_astv_rec);
END update_assent;
PROCEDURE update_assent(
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_astv_tbl IN astv_tbl_type,
x_astv_tbl OUT NOCOPY astv_tbl_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'update_assent';
update_assent(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_astv_rec => p_astv_tbl(i),
x_astv_rec => x_astv_tbl(i));
END update_assent;
PROCEDURE delete_assent(
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_astv_rec IN astv_rec_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'delete_assent';
OKC_ASSENT_PVT.delete_assent(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_astv_rec);
END delete_assent;
PROCEDURE delete_assent(
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_astv_tbl IN astv_tbl_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'delete_assent';
delete_assent(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_astv_rec => p_astv_tbl(i));
END delete_assent;
PROCEDURE update_status(
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_stsv_rec IN stsv_rec_type,
x_stsv_rec OUT NOCOPY stsv_rec_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'update_status';
OKC_ASSENT_PVT.update_status(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_stsv_rec,
x_stsv_rec);
END update_status;
PROCEDURE update_status(
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_stsv_tbl IN stsv_tbl_type,
x_stsv_tbl OUT NOCOPY stsv_tbl_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'update_status';
update_status(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_stsv_rec => p_stsv_tbl(i),
x_stsv_rec => x_stsv_tbl(i));
END update_status;
PROCEDURE delete_status(
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_stsv_rec IN stsv_rec_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'delete_status';
OKC_ASSENT_PVT.delete_status(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_stsv_rec);
END delete_status;
PROCEDURE delete_status(
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_stsv_tbl IN stsv_tbl_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'delete_status';
delete_status(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_stsv_rec => p_stsv_tbl(i));
END delete_status;