[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select company_admin_email
into i_email_addr
from ecx_tp_headers eth
where eth.party_id = i_party_id
and eth.party_site_id = i_party_site_id
and eth.party_type = nvl(party_type, eth.party_type);
p_name => 'UpdateOnly',
p_value => 'TRUE',
p_parameterlist => l_params);
p_name => 'UpdateOnly',
p_value => 'TRUE',
p_parameterlist => l_params);
select distinct et.transaction_id,usr.email_address
into i_transaction_id,i_email_addr
from ecx_ext_processes eep,
ecx_standards es,
ecx_tp_details etd,
ecx_tp_headers eth,
ecx_transactions et,
fnd_user usr
where eep.ext_type = l_transaction_type
and eep.ext_subtype = l_transaction_subtype
and eep.standard_id = es.standard_id
and es.standard_code = l_standard_code
and es.standard_type = nvl(l_standard_type,'XML')
and et.transaction_id = eep.transaction_id
and etd.ext_process_id = eep.ext_process_id
and eth.party_site_id = l_party_site_id
and (eth.party_type = l_party_type or l_party_type is null)
and eth.tp_header_id = etd.tp_header_id
and et.admin_user = usr.user_name
and eep.direction = 'IN' ;
p_name => 'UpdateOnly',
p_value => 'TRUE',
p_parameterlist => l_params);