The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT cust_account_id, customer_site_use_id
FROM IEX_DELINQUENCIES
WHERE delinquency_ID = in_del_ID;
SELECT template_code,
default_language,
default_territory
FROM XDO_TEMPLATES_VL
WHERE template_id = in_TEMP_ID
--AND Application_id = 695;
WriteLog(l_msg || ' insert_row' );
IEX_XML_PKG.insert_row (
px_rowid => l_rowid
,px_xml_request_id => l_request_id
,p_query_temp_id => p_query_id
,p_status => 'XMLDATA'
,p_document => l_doc
,p_xmldata => l_content_xml
,p_method => p_method
,p_destination => p_dest
,p_object_type => p_object_type
,p_object_id => p_object_id
,p_resource_id => p_resource_id
,p_view_by => p_level
,p_party_id => l_party_id
,p_cust_account_id => l_account_id
,p_cust_site_use_id => l_site_id
,p_delinquency_id => l_delinquency_id
,p_last_update_date => sysdate
,p_last_updated_by => l_user_id
,p_creation_date => sysdate
,p_created_by => l_user_id
,p_last_update_login => l_user_id
,p_object_version_number => l_user_id
);
select iso_language
into l_iso_lang1
from fnd_languages
where language_code= upper(l_lang);
select count(distinct territory)
into l_no_terr
from xdo_lobs
where application_short_name='IEX' and upper(language)=l_iso_lang1;
select distinct territory
into l_templ_terr1
from xdo_lobs
where application_short_name='IEX' and upper(language)=l_iso_lang1;
select language
into l_loc_lang
from hz_locations
where location_id= to_number(l_bind_val);
select iso_language
into l_iso_lang
from fnd_languages
where language_code= upper(l_loc_lang);
select count(distinct territory)
into l_no_terr
from xdo_lobs
where application_short_name='IEX' and upper(language)=l_iso_lang;
select distinct territory
into l_templ_terr
from xdo_lobs
where application_short_name='IEX' and upper(language)=l_iso_lang;
IEX_XML_PKG.update_row (
p_xml_request_id => l_request_id
,p_status => l_return_status
--,p_document => l_doc
);
IEX_XML_PKG.update_row (
p_xml_request_id => l_request_id
,p_status => l_status
);
IEX_XML_PKG.update_row (
p_xml_request_id => l_request_id
,p_status => l_status
);
IEX_XML_PKG.update_row (
p_xml_request_id => l_request_id
,p_status => l_status
);
SELECT xmldata
FROM IEX_XML_REQUEST_HISTORIES
WHERE xml_request_id = in_request_id;
SELECT UPPER(ADDITIONAL_QUERY), UPPER(STATEMENT)
FROM IEX_XML_QUERIES
WHERE query_id = in_query_id
and trunc(sysdate) between trunc(nvl(start_date, sysdate)) and
trunc(nvl(end_date, sysdate))
and enabled_flag = 'Y';
l_dataHdrQry := 'SELECT '||l_dataHeader||' FROM DUAL';
SELECT NVL(PREFERENCE_VALUE, 'FFM')
FROM IEX_APP_PREFERENCES_VL
WHERE PREFERENCE_NAME= 'COLLECTIONS DELIVERY METHOD';