The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_ovd_id IN NUMBER,
p_rgrv_rec IN rgrv_rec_type,
x_rgrv_rec OUT NOCOPY rgrv_rec_type)
IS
l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
SELECT rgr_rgd_code,
rgr_rdf_code
FROM OKL_OPT_RULES ORL,
OKL_OPV_RULES OVD
WHERE OVD.ORL_ID = ORL.ID
AND OVD.ID = p_in_id;
SAVEPOINT Opt_Rul_Tmp_insert;
Okc_Rul_Pvt.INSERT_ROW(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_rulv_rec,
x_rulv_rec);
Okl_Ovd_Rul_Tmls_Pub.insert_ovd_rul_tmls(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_ovtv_rec => l_ovtv_rec,
x_ovtv_rec => x_ovtv_rec);
ROLLBACK TO Opt_Rul_Tmp_insert;
ROLLBACK TO Opt_Rul_Tmp_insert;
ROLLBACK TO Opt_Rul_Tmp_insert;
Fnd_Msg_Pub.ADD_EXC_MSG('OKL_Opt_Rul_Tmp_PVT','insert_Opt_Rul_Tmp');
END insert_row;
PROCEDURE insert_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_ovd_id IN NUMBER,
p_rgrv_tbl IN rgrv_tbl_type,
x_rgrv_tbl OUT NOCOPY rgrv_tbl_type)
IS
p_rgrv_rec rgrv_rec_type;
SAVEPOINT Opt_Rul_Tmp_insert;
Okl_Opt_Rul_Tmp_Pvt.insert_row(
p_api_version
,p_init_msg_list
,x_return_status
,x_msg_count
,x_msg_data
,p_ovd_id
,p_rgrv_rec
,x_rgrv_rec);
ROLLBACK TO Opt_Rul_Tmp_insert;
ROLLBACK TO Opt_Rul_Tmp_insert;
ROLLBACK TO Opt_Rul_Tmp_insert;
Fnd_Msg_Pub.ADD_EXC_MSG('OKL_Opt_Rul_Tmp_PVT','insert_Opt_Rul_Tmp');
END insert_row;
PROCEDURE update_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_rgrv_rec IN rgrv_rec_type,
x_rgrv_rec OUT NOCOPY rgrv_rec_type)
IS
BEGIN
NULL;
END update_row;
PROCEDURE update_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_rgrv_tbl IN rgrv_tbl_type,
x_rgrv_tbl OUT NOCOPY rgrv_tbl_type)
IS
BEGIN
NULL;
END update_row;
PROCEDURE delete_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_rgrv_rec IN rgrv_rec_type)
IS
BEGIN
NULL;
END delete_row;
PROCEDURE delete_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_rgrv_tbl IN rgrv_tbl_type)
IS
BEGIN
NULL;
END delete_row;