The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_update_name varchar2(30);
l_update_name := 'Import'||P_batch_id;
ad_parallel_updates_pkg.purge_processed_units(l_table_owner,
l_table_name,
l_update_name);
DELETE FROM AD_PARALLEL_UPDATES
WHERE OWNER = l_table_owner AND TABLE_NAME = l_table_name AND script_name = l_update_name;
SELECT count(1) INTO l_row_count FROM OKS_HEADERS_INTERFACE
WHERE BATCH_ID = P_batch_id
AND INTERFACE_STATUS = 'S'
AND rownum = 1;
DELETE FROM OKS_IMPORT_STATISTICS WHERE BATCH_ID = P_batch_id;