The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT pa_workflow_itemkey_s.nextval
INTO l_item_key
FROM dual;
PA_WORKFLOW_UTILS.Insert_WF_Processes(
p_wf_type_code => l_wf_type_code
,p_item_type => p_item_type
,p_item_key => l_item_key
,p_entity_key1 => l_entity_key1
,p_entity_key2 => l_entity_key2
,p_description => p_process_name
,p_err_code => l_err_code
,p_err_stage => l_err_stage
,p_err_stack => l_err_stack
);
SELECT object_page_layout_id,
object_id,
object_type,
page_name,
page_id,
page_type_code,
report_name
FROM pa_progress_report_setup_v
WHERE object_id = c_object_id
AND object_type = 'PA_PROJECTS'
AND page_type_code='PPR'
AND generation_method='AUTOMATIC';
SELECT name, segment1 INTO l_project_name, l_project_number
FROM pa_projects_all
WHERE project_id=p_project_id;