The following lines contain the word 'select', 'insert', 'update' or 'delete':
select object_version_number
from OKL_CURE_REFUND_HEADERS_B
where cure_refund_header_id = l_cure_refund_header_id;
select sum(received_amount),sum(offset_amount), sum(disbursement_amount)
from OKL_CURE_REFUNDS
where cure_refund_header_id = l_cure_refund_header_id;
lp_crsv_tbl(i).status := 'SELECTED';
OKL_cure_refunds_pub.insert_cure_refunds(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_crfv_tbl => lp_crfv_tbl,
x_crfv_tbl => lx_crfv_tbl
);
OKL_cure_rfnd_hdr_pub.update_cure_rfnd_hdr(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_chdv_rec => lp_chdv_rec,
x_chdv_rec => lx_chdv_rec
);
OKL_cure_rfnd_stage_pub.update_cure_refunds(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_crsv_tbl => lp_crsv_tbl,
x_crsv_tbl => lx_crsv_tbl
);
PROCEDURE update_cure_refund(
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_cure_rfnd_tbl IN cure_rfnd_tbl_type,
x_cure_rfnd_tbl OUT NOCOPY cure_rfnd_tbl_type
) IS
l_api_name VARCHAR2(30) := 'update_cure_refund';
select object_version_number
from OKL_CURE_REFUND_HEADERS_B
where cure_refund_header_id = l_cure_refund_header_id;
select sum(received_amount),sum(offset_amount), sum(disbursement_amount)
from OKL_CURE_REFUNDS
where cure_refund_header_id = l_cure_refund_header_id;
lp_crsv_tbl(i).status := 'SELECTED';
OKL_cure_refunds_pub.update_cure_refunds(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_crfv_tbl => lp_crfv_tbl,
x_crfv_tbl => lx_crfv_tbl
);
OKL_cure_rfnd_hdr_pub.update_cure_rfnd_hdr(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_chdv_rec => lp_chdv_rec,
x_chdv_rec => lx_chdv_rec
);
OKL_cure_rfnd_stage_pub.update_cure_refunds(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_crsv_tbl => lp_crsv_tbl,
x_crsv_tbl => lx_crsv_tbl
);
PROCEDURE delete_cure_refund(
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_cure_rfnd_tbl IN cure_rfnd_tbl_type
) IS
l_api_name VARCHAR2(30) := 'delete_cure_refund';
select object_version_number
from OKL_CURE_REFUND_HEADERS_B
where cure_refund_header_id = l_cure_refund_header_id;
select sum(received_amount),sum(offset_amount)
from OKL_CURE_REFUNDS
where cure_refund_header_id = l_cure_refund_header_id;
OKL_cure_refunds_pub.delete_cure_refunds(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_crfv_tbl => lp_crfv_tbl
);
OKL_cure_rfnd_hdr_pub.update_cure_rfnd_hdr(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_chdv_rec => lp_chdv_rec,
x_chdv_rec => lx_chdv_rec
);
OKL_cure_rfnd_stage_pub.update_cure_refunds(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_crsv_tbl => lp_crsv_tbl,
x_crsv_tbl => lx_crsv_tbl
);