[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT object_type
INTO l_tar_obj_type
FROM ecx_objects
WHERE map_id = p_map_id
AND object_id = 2;
select attribute_name,
element_tag_name
from ecx_standard_attributes esa,
ecx_standards es
where es.standard_code = p_standard_code
and es.standard_type = nvl(p_standard_type, 'XML')
and esa.standard_id = es.standard_id;
i_string varchar2(2000) := ' update ecx_doclogs set ';
i_attr_rec.DELETE;
select etd.map_id map_id,
etd.routing_id routing_id,
etd.tp_header_id tp_header_id,
etd.confirmation confirmation
from ecx_tp_details etd,
ecx_ext_processes eep,
ecx_standards es
where etd.source_tp_location_code = p_party_ext_code
and eep.ext_type = p_ext_type
and eep.ext_subtype = p_ext_subtype
and eep.ext_process_id = etd.ext_process_id
and eep.standard_id = es.standard_id
and es.standard_code = p_message_standard
and es.standard_type = nvl(p_message_type, 'XML')
and eep.direction = 'IN';
select etd.tp_header_id tp_header_id,
etd.tp_detail_id tp_detail_id
from ecx_tp_details etd,
ecx_ext_processes eep,
ecx_standards es
where etd.source_tp_location_code = p_party_ext_code
and eep.ext_type = p_ext_type
and eep.ext_subtype = p_ext_subtype
and eep.ext_process_id = etd.ext_process_id
and eep.standard_id = es.standard_id
and es.standard_code = p_message_standard
and es.standard_type = nvl(p_message_type, 'XML')
and eep.direction = 'OUT';
select tp_header_id
from ecx_tp_details
where tp_detail_id = p_routing_id;
select count(1) into i_map_type
from ecx_objects
where object_type <> 'DB' and map_id = i_map_id;
ecx_debug.log(l_statement,'Update doclogs for Msg Id : ' , m_msgid,i_method_name);
ecx_errorlog.update_log_document
(
m_msgid,
null,
'Inbound processing complete.',
ecx_utils.g_logfile,
null
);
select es.standard_type standard_type,
es.standard_code standard_code,
source_tp_location_code source,
external_tp_location_code destination,
protocol_type,
protocol_address,
username,
password,
hub_user_id,
eep.ext_type ext_type,
eep.ext_subtype ext_subtype,
et.transaction_type,
et.transaction_subtype,
eth.party_id,
eth.party_site_id,
eth.party_type
into i_standard_type,
i_standard_code,
i_source_code,
i_destination_code,
i_destination_type,
i_destination_address,
i_username,
i_password,
i_hub_user_id,
i_ext_type,
i_ext_subtype,
i_int_type,
i_int_subtype,
i_party_id,
i_party_site_id,
i_party_type
from ecx_tp_details etd,
ecx_ext_processes eep,
ecx_standards es,
ecx_transactions et,
ecx_tp_headers eth
where etd.tp_detail_id = i_tp_detail_id
and es.standard_id = eep.standard_id
and eep.ext_process_id = etd.ext_process_id
and eep.transaction_id = et.transaction_id
and eep.direction = 'OUT'
and etd.tp_header_id = eth.tp_header_id;
select hub_entity_code,
protocol_type,
protocol_address,
username,
password
into i_source_code,
i_destination_type,
i_destination_address,
i_username,
i_password
from ecx_hubs eh,
ecx_hub_users ehu
where eh.hub_id = ehu.hub_id
and ehu.hub_user_id = i_hub_user_id;
select name
into i_system
from wf_systems
where guid = wf_core.translate('WF_SYSTEM_GUID');
select es.standard_type standard_type,
es.standard_code standard_code,
source_tp_location_code source,
external_tp_location_code destination,
protocol_type,
protocol_address,
username,
password,
hub_user_id,
eep.ext_type ext_type,
eep.ext_subtype ext_subtype
into i_standard_type,
i_standard_code,
i_source_code,
i_destination_code,
i_destination_type,
i_destination_address,
i_username,
i_password,
i_hub_user_id,
i_ext_type,
i_ext_subtype
from ecx_tp_details etd,
ecx_ext_processes eep,
ecx_standards es
where etd.tp_detail_id = i_tp_detail_id
and es.standard_id = eep.standard_id
and eep.ext_process_id = etd.ext_process_id;
select hub_entity_code,
protocol_type,
protocol_address,
username,
password
into i_source_code,
i_destination_type,
i_destination_address,
i_username,
i_password
from ecx_hubs eh,
ecx_hub_users ehu
where eh.hub_id = ehu.hub_id
and ehu.hub_user_id = i_hub_user_id;
select party_type
into i_party_type
from ecx_tp_headers eth,
ecx_tp_details etd
where eth.tp_header_id = etd.tp_header_id
and etd.tp_detail_id = i_tp_detail_id;
select ecx_output_runs_s.NEXTVAL
from dual;
select message_standard,
message_type,
transaction_type,
transaction_subtype,
party_site_id,
payload,
document_number,
attribute3,
internal_control_number
from ecx_doclogs
where msgid = p_msgid
for update;
select standard_id
into ecx_utils.g_standard_id
from ecx_standards
where standard_code = m_message_standard
and standard_type = nvl(m_message_type, 'XML');
select standard_id
into ecx_utils.g_standard_id
from ecx_standards
where standard_code = m_message_standard
and standard_type = nvl(m_message_type, 'XML');
select ecx_output_runs_s.NEXTVAL
from dual;
select message_standard,
message_type,
transaction_type,
transaction_subtype,
party_site_id,
payload,
document_number,
attribute3,
internal_control_number
from ecx_doclogs
where msgid = p_msgid
for update;
select standard_id
into ecx_utils.g_standard_id
from ecx_standards
where standard_code = m_message_standard
and standard_type = nvl(m_message_type, 'XML');
select ecx_output_runs_s.NEXTVAL
from dual;
select map_id
into i_map_id
from ecx_mappings
where map_code = i_map_code;
select standard_id
into ecx_utils.g_standard_id
from ecx_standards
where standard_code = i_message_standard
and standard_type = nvl(i_message_type, 'XML');
select ecx_trigger_id_s.NEXTVAL
from dual;
select process_id into i_process_id from ecx_inbound_logs where msgid=i_msgid;