The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE update_process_def(
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_pdfv_rec IN pdfv_rec_type,
p_pdpv_tbl IN pdpv_tbl_type,
x_pdfv_rec OUT NOCOPY pdfv_rec_type,
x_pdpv_tbl OUT NOCOPY pdpv_tbl_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
update_proc_def(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_pdfv_rec,
x_pdfv_rec);
update_proc_def_parms(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_pdpv_tbl,
x_pdpv_tbl);
end update_process_def;
okc_pdf_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_pdfv_rec,
x_pdfv_rec);
okc_pdf_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_pdfv_tbl,
x_pdfv_tbl);
PROCEDURE update_proc_def(
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_pdfv_rec IN pdfv_rec_type,
x_pdfv_rec OUT NOCOPY pdfv_rec_type) IS
l_pdpv_tbl OKC_PROCESS_PUB.pdpv_tbl_type;
SELECT *
FROM okc_process_def_parameters_v
WHERE pdf_id = p_pdfv_rec.id;
SELECT application_id INTO l_app_id1
FROM OKC_PROCESS_DEFS_B
WHERE id = p_pdfv_rec.id;
okc_pdf_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_pdfv_rec,
x_pdfv_rec);
l_pdpv_tbl.delete;
v_pdpv_tbl.delete;
l_pdpv_tbl(l_cnt).last_updated_by := l_pdpv_rec.last_updated_by;
l_pdpv_tbl(l_cnt).last_update_date := l_pdpv_rec.last_update_date;
l_pdpv_tbl(l_cnt).last_update_login := l_pdpv_rec.last_update_login;
okc_process_pub.update_proc_def_parms(
p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_pdpv_tbl => l_pdpv_tbl,
x_pdpv_tbl => v_pdpv_tbl);
End update_proc_def;
PROCEDURE update_proc_def(
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_pdfv_tbl IN pdfv_tbl_type,
x_pdfv_tbl OUT NOCOPY pdfv_tbl_type) IS
begin
okc_pdf_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_pdfv_tbl,
x_pdfv_tbl);
End update_proc_def;
PROCEDURE delete_proc_def(
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_pdfv_rec IN pdfv_rec_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
select pdp.id
from okc_process_def_parameters_v pdp
where pdp.pdf_id = p_pdfv_rec.id;
select '1'
from okc_process_defs_v pdf,
okc_outcomes_v out,
okc_condition_headers_v cnh
where pdf.id = out.pdf_id
and pdf.id = p_pdf_id
and out.cnh_id = cnh.id;
select '1'
from okc_process_defs_v pdf,
okc_qa_list_processes qa
where pdf.id = qa.pdf_id
and pdf.id = p_pdf_id;
select '1'
from okc_process_defs_v pdf,
okc_k_processes k
where pdf.id = k.pdf_id
and pdf.id = p_pdf_id;
p_msg_name => g_delete_proc_def);
okc_process_pub.delete_proc_def_parms(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_pdpv_tbl);
--Delete the Master
okc_pdf_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_pdfv_rec);
End delete_proc_def;
PROCEDURE delete_proc_def(
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_pdfv_tbl IN pdfv_tbl_type) IS
i NUMBER :=0;
delete_proc_def(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_pdfv_tbl(i));
End delete_proc_def;
SELECT application_id into l_app_id
FROM OKC_PROCESS_DEFS_B
WHERE ID = l_pdpv_rec.pdf_id;
okc_pdp_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_pdpv_rec,
x_pdpv_rec);
okc_pdp_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_pdpv_tbl,
x_pdpv_tbl);
PROCEDURE update_proc_def_parms(
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_pdpv_rec IN pdpv_rec_type,
x_pdpv_rec OUT NOCOPY pdpv_rec_type) IS
begin
okc_pdp_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_pdpv_rec,
x_pdpv_rec);
End update_proc_def_parms;
PROCEDURE update_proc_def_parms(
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_pdpv_tbl IN pdpv_tbl_type,
x_pdpv_tbl OUT NOCOPY pdpv_tbl_type) IS
begin
okc_pdp_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_pdpv_tbl,
x_pdpv_tbl);
End update_proc_def_parms;
PROCEDURE delete_proc_def_parms(
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_pdpv_rec IN pdpv_rec_type) IS
begin
okc_pdp_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_pdpv_rec);
End delete_proc_def_parms;
PROCEDURE delete_proc_def_parms(
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_pdpv_tbl IN pdpv_tbl_type) IS
begin
okc_pdp_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_pdpv_tbl);
End delete_proc_def_parms;
SELECT RUNNABLE_FLAG
FROM wf_activities_vl w
WHERE w.item_type = UPPER(wfname)
AND w.name = UPPER(wfproc)
AND w.version = (SELECT max(version)
FROM wf_activities_vl sq
WHERE sq.item_type = UPPER(wfname)
AND sq.name = UPPER(wfproc) );
SELECT 1
FROM user_arguments a,
user_objects o
WHERE o.object_type = 'PACKAGE'
and o.object_name = UPPER(packname)
and a.object_id = o.object_id
AND a.object_name = UPPER(procname);