The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT authorization_status
INTO l_authorization_status
FROM po_headers_all
WHERE po_header_id = p_document_id;
SELECT authorization_status
INTO l_authorization_status
FROM po_releases_all
WHERE po_release_id = p_document_id;
SELECT cln_generic_s.nextval INTO l_cln_event_key FROM dual;
insert into cln_test(test) values('Exception ' || ':' || l_error_code || ':' || l_error_msg);
SELECT poh.segment1, por.release_num, poh.revision_num, poh.vendor_order_num
INTO l_po_number, l_rel_number, l_rev_number, l_supp_ord_number
FROM po_headers_all poh, po_releases_all por
WHERE poh.po_header_id = l_po_header_id
AND poh.po_header_id = por.po_header_id(+);
SELECT poh.po_header_id, poh.segment1, por.release_num, por.revision_num, poh.vendor_order_num
INTO l_po_header_id, l_po_number, l_rel_number, l_rev_number, l_supp_ord_number
FROM po_headers_all poh, po_releases_all por
WHERE por.po_release_id = l_po_release_id
AND poh.po_header_id = por.po_header_id(+);
SELECT VENDOR_ID, VENDOR_SITE_ID
INTO l_party_id, l_party_site_id
FROM PO_HEADERS_ALL
WHERE PO_HEADER_ID = l_po_header_id;
SELECT cln_generic_s.nextval INTO l_cln_event_key FROM dual;
SELECT cln_generic_s.nextval INTO l_xmlg_doc_id FROM dual;
SELECT poh.xml_flag
INTO l_xml_flag
FROM po_headers_all poh
WHERE po_header_id= l_po_header_id;
SELECT por.xml_flag
INTO l_xml_flag
FROM po_headers_all poh, po_releases_all por
WHERE poh.po_header_id = por.po_header_id
AND por.po_release_id = l_po_release_id;