The following lines contain the word 'select', 'insert', 'update' or 'delete':
is select parameters
from wf_event_subscriptions
where guid = p_subscription_guid;
select queue_name ,
tp_header_id
into i_queue_name,
l_tp_header_id
from ecx_ext_processes eep,
ecx_standards es,
ecx_tp_details etd
where eep.ext_type = l_transaction_type
and eep.ext_subtype = l_transaction_subtype
and eep.direction = 'IN'
and eep.standard_id = es.standard_id
and es.standard_code = l_standard_code
and es.standard_type = l_standard_type
and etd.ext_process_id = eep.ext_process_id
and etd.source_tp_location_code = l_party_site_id;
select parameters
into r_myparams
from wf_event_subscriptions
where guid = p_subscription_guid;
'Error in selecting parameters.');
ecx_debug.setErrorInfo(1,30,'ECX_PARAM_SELECT_ERROR',
'p_guid',
p_subscription_guid);
select parameters
into myparams
from wf_event_subscriptions
where guid = p_subscription_guid;
'Error in selecting parameters.');
select out_agent_guid, to_agent_guid, wf_process_type, wf_process_name,
priority, parameters, map_code, standard_type, standard_code
into l_out_guid, l_to_guid, l_wftype, l_wfname, l_pri, l_subparams,
l_map_code, l_std_type, l_std_code
from wf_event_subscriptions
where guid = p_subscription_guid;
select to_char(WF_ERROR_PROCESSES_S.nextval) into l_ikey from dual;
select party_type
into l_party_type
from ecx_tp_headers
where tp_header_id=ecx_utils.g_snd_tp_id;
select queue_name ,
tp_header_id
into x_queue_name,
x_tp_header_id
from ecx_ext_processes eep,
ecx_standards es,
ecx_tp_details etd
where eep.ext_type = p_transaction_type
and eep.ext_subtype = p_transaction_subtype
and eep.direction = 'IN'
and eep.standard_id = es.standard_id
and es.standard_code = p_standard_code
and es.standard_type = p_standard_type
and etd.ext_process_id = eep.ext_process_id
and etd.source_tp_location_code = p_party_site_id;
select parameters
from wf_event_subscriptions
where guid = p_subscription_guid;
select ecx_trigger_id_s.NEXTVAL
from dual;
select ecx_trigger_id_s.NEXTVAL
from dual;
select trigger_id into l_trigger_id
from ecx_inbound_logs
where msgid = l_msgid;
select max(trigger_id) into l_trigger_id
from ecx_inbound_logs
where msgid = l_msgid;
select ecx_inlstn_s.nextval into l_internal_control_number from dual;