[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT crt.vendor_id
,crt.report_date
,pvs.email_address
,crt.report_number
,crt.cure_report_id
,crt.object_version_number
,crt.report_type
FROM OKL_cure_reports crt
,po_vendor_sites_all pvs
WHERE trunc(crt.report_date) = NVL(l_report_date , trunc(crt.report_date))
AND crt.report_number = NVL(l_request_number, crt.report_number)
AND crt.vendor_id = NVL(l_vendor_id,crt.vendor_id)
AND crt.vendor_site_id = pvs.vendor_site_id
AND crt.approval_status = 'APPROVED';
SELECT jtf_amv_item_id, email_subject_line
FROM okl_cs_process_tmplts_uv
WHERE PTM_CODE=p_process_code;
OKL_cure_reports_pub.update_cure_reports(
p_api_version => l_api_version
,p_init_msg_list => okl_api.G_TRUE
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
,p_crtv_rec => l_crtv_rec
,x_crtv_rec => lx_crtv_rec);
'Cure Request Status could not be updated for request = '
|| i.report_number);
END IF; --return_status of update cure reports
'After calling update cure reports and return status is'
|| l_return_status);