The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE update_internal_trans(
p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
,p_rctv_rec IN rctv_rec_type
,p_rcav_tbl IN rcav_tbl_type
,x_rctv_rec OUT NOCOPY rctv_rec_type
,x_rcav_tbl OUT NOCOPY rcav_tbl_type
) IS
l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
update_internal_trans(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_rctv_rec,
x_rctv_rec);
update_internal_trans(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_rcav_tbl,
x_rcav_tbl);
PROCEDURE delete_internal_trans(
p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
,p_rctv_rec IN rctv_rec_type
,p_rcav_tbl IN rcav_tbl_type
,x_rctv_rec OUT NOCOPY rctv_rec_type
,x_rcav_tbl OUT NOCOPY rcav_tbl_type
) IS
l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
delete_internal_trans(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_rctv_rec);
delete_internal_trans(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_rcav_tbl);
Okl_Rct_Pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_rctv_rec,
x_rctv_rec);
Okl_Rct_Pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_rctv_tbl,
x_rctv_tbl);
PROCEDURE update_internal_trans(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_rctv_rec IN rctv_rec_type,
x_rctv_rec OUT NOCOPY rctv_rec_type) IS
BEGIN
Okl_Rct_Pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_rctv_rec,
x_rctv_rec);
END update_internal_trans;
PROCEDURE update_internal_trans(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_rctv_tbl IN rctv_tbl_type,
x_rctv_tbl OUT NOCOPY rctv_tbl_type) IS
BEGIN
Okl_Rct_Pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_rctv_tbl,
x_rctv_tbl);
END update_internal_trans;
--Put custom code for cascade delete by developer
PROCEDURE delete_internal_trans(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_rctv_rec IN rctv_rec_type) IS
i NUMBER :=0;
--Delete the Master
Okl_Rct_Pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_rctv_rec);
END delete_internal_trans;
PROCEDURE delete_internal_trans(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_rctv_tbl IN rctv_tbl_type) IS
i NUMBER :=0;
delete_internal_trans(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_rctv_tbl(i));
END delete_internal_trans;
Okl_Rca_Pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_rcav_rec,
x_rcav_rec);
Okl_Rca_Pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_rcav_tbl,
x_rcav_tbl);
PROCEDURE update_internal_trans(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_rcav_rec IN rcav_rec_type,
x_rcav_rec OUT NOCOPY rcav_rec_type) IS
BEGIN
Okl_Rca_Pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_rcav_rec,
x_rcav_rec);
END update_internal_trans;
PROCEDURE update_internal_trans(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_rcav_tbl IN rcav_tbl_type,
x_rcav_tbl OUT NOCOPY rcav_tbl_type) IS
BEGIN
Okl_Rca_Pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_rcav_tbl,
x_rcav_tbl);
END update_internal_trans;
--Put custom code for cascade delete by developer
PROCEDURE delete_internal_trans(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_rcav_rec IN rcav_rec_type) IS
i NUMBER :=0;
--Delete the Master
Okl_Rca_Pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_rcav_rec);
END delete_internal_trans;
PROCEDURE delete_internal_trans(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_rcav_tbl IN rcav_tbl_type) IS
i NUMBER :=0;
delete_internal_trans(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_rcav_tbl(i));
END delete_internal_trans;