The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT item_type_code,ato_line_id,explosion_date
INTO l_item_type,l_ato_line_id,l_explosion_date
FROM oe_order_lines_all
WHERE line_id = to_number(itemkey);
SELECT nvl(wdd.oe_interfaced_flag, 'N')
INTO l_if
FROM wsh_delivery_details wdd
WHERE wdd.source_line_id = to_number(itemkey)
AND wdd.source_code = 'OE'
AND released_status = 'C' --Added for bug#6727843
GROUP BY oe_interfaced_flag;
SELECT NVL(shipped_quantity,0)
INTO l_oe_shipped_quantity
FROM oe_order_lines
WHERE line_id= to_number(itemkey);
SELECT line_id, top_model_line_id
, header_id
, order_source_id
, orig_sys_document_ref
, orig_sys_line_ref
, orig_sys_shipment_ref
, change_sequence
, source_document_type_id
, source_document_id
, source_document_line_id
INTO l_line_id, l_top_model_line_id
, l_header_id
, l_order_source_id
, l_orig_sys_document_ref
, l_orig_sys_line_ref
, l_orig_sys_shipment_ref
, l_change_sequence
, l_source_document_type_id
, l_source_document_id
, l_source_document_line_id
FROM oe_order_lines
WHERE line_id = to_number(itemkey);
SELECT line_id, top_model_line_id
INTO l_line_id, l_top_model_line_id
FROM oe_order_lines_all
WHERE line_id = l_top_model_line_id
FOR UPDATE NOWAIT;
SELECT line_id
INTO l_line_id
FROM oe_order_lines_all
WHERE line_id = l_itemkey
FOR UPDATE NOWAIT;
insert into ont_wf_skip_log(creation_date, line_id, activity_id, user_id, responsibility_id, application_id) values (sysdate, to_number(itemkey), actid, FND_GLOBAL.user_id, FND_GLOBAL.RESP_ID, FND_GLOBAL.RESP_APPL_ID);
select header_id
into l_header_id
from oe_order_lines_all
where line_id = to_number(itemkey);
select employee_id
into l_eid
from fnd_user
where user_id =l_user_id;
select name
into role_name
from wf_roles
where orig_system='FND_USR'
and orig_system_id = l_user_id;
select name
into role_name
from wf_roles
where orig_system='PER'
and orig_system_id = l_eid;
select RESPONSIBILITY_NAME
into l_resp_name
from FND_RESPONSIBILITY_VL
where RESPONSIBILITY_ID=l_resp_id
and APPLICATION_ID=l_resp_appl_id;
select APPLICATION_NAME
into l_appl_name
from fnd_application_vl
where APPLICATION_ID = l_resp_appl_id;
select 1
into l_validate_user
from wf_roles
where name = l_from_role;