[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select party_site_id,
transaction_type,
transaction_subtype,
field8
into i_location_code,
i_transaction_type,
i_transaction_subtype,
i_confirmation
from ecx_doclogs
where internal_control_number = p_document_id;
select party_id,
party_site_id,
confirmation
into i_party_id,
i_party_site_id,
i_confirmation
from ecx_ext_processes eep,
ecx_transactions et,
ecx_standards es,
ecx_tp_headers eth,
ecx_tp_details etd
where et.transaction_type = p_transaction_type
and et.transaction_subtype = p_transaction_subtype
and (p_party_type is null or eth.party_type = p_party_type)
and eep.transaction_id = et.transaction_id
and eep.direction = 'OUT'
and eep.standard_id = es.standard_id
and es.standard_code = 'OAG'
and etd.source_tp_location_code = i_location_code
and etd.tp_header_id = eth.tp_header_id
and etd.ext_process_id = eep.ext_process_id;
select transaction_id
into i_transaction_id
from ecx_transactions
where transaction_type = i_transaction_type
and transaction_subtype = i_transaction_subtype
and (i_party_type is null or party_type = i_party_type);
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,
connection_type,
hub_id ,
map_code,
eep.queue_name queue_name,
eep.ext_type ext_type,
eep.ext_subtype ext_subtype,
eth.party_type party_type,
eth.tp_header_id tp_header_id,
etd.tp_detail_id
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_connection_type,
i_hub_id,
i_map_code,
i_queue_name,
i_ext_type,
i_ext_subtype,
i_party_type,
i_tp_header_id,
ecx_utils.g_tp_dtl_id
from ecx_tp_details etd,
ecx_tp_headers eth,
ecx_ext_processes eep,
ecx_transactions et,
ecx_standards es,
ecx_mappings em
where ( eth.party_id = i_party_id or i_party_id is null )
and eth.party_site_id = i_party_site_id
and eth.party_type = et.party_type
and eth.tp_header_id = etd.tp_header_id
and et.transaction_type = i_transaction_type
and et.transaction_subtype = i_transaction_subtype
and (i_party_type is null or et.party_type = i_party_type)
and et.transaction_id = eep.transaction_id
and es.standard_id = eep.standard_id
and eep.ext_process_id = etd.ext_process_id
and eep.direction = 'OUT'
and em.map_id = etd.map_id;
select protocol_type,
protocol_address
into i_destination_type,
i_destination_address
from ecx_hubs
where hub_id=i_hub_id;
select hub_entity_code,
username,
password
into i_source_code,
i_username,
i_password
from ecx_hub_users
where hub_user_id = i_hub_user_id;
select ecx_trigger_id_s.NEXTVAL
from dual;
select ecx_trigger_id_s.NEXTVAL
from dual;
Select msgid,
message_type,
message_standard,
transaction_type,
transaction_subtype,
document_number,
party_type,
partyid,
party_site_id,
protocol_type,
protocol_address,
username,
password,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
payload,
time_stamp,
status,
direction
From ECX_DOCLOGS
Where msgid = l_msgid ;
select etd.protocol_type,
etd.protocol_address,
etd.username,
etd.password,
etd.connection_type,
hub_id,
hub_user_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 protocol_type,
protocol_address
into l_protocol_type,
l_protocol_address
from ecx_hubs
where hub_id=l_hub_id;
select username,
password
into l_username,
l_password
from ecx_hub_users
where hub_user_id = l_hub_user_id;
select name
into i_system
from wf_systems
where guid = wf_core.translate('WF_SYSTEM_GUID');
select etd.confirmation into o_confirmation
from ecx_tp_details etd,
ecx_tp_headers eth,
ecx_ext_processes eep,
ecx_transactions et,
ecx_standards es,
ecx_mappings em
where ( eth.party_id = i_party_id or i_party_id is null )
and eth.party_site_id = i_party_site_id
and eth.party_type = et.party_type
and eth.tp_header_id = etd.tp_header_id
and et.transaction_type = i_transaction_type
and et.transaction_subtype = i_transaction_subtype
and (i_party_type is null or et.party_type = i_party_type)
and et.transaction_id = eep.transaction_id
and es.standard_id = eep.standard_id
and eep.ext_process_id = etd.ext_process_id
and eep.direction = 'OUT'
and em.map_id = etd.map_id;