[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
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
and territory <> '00'
and lob_code = l_templ_code;
select distinct territory
into l_templ_terr
from xdo_lobs
where application_short_name='IEX' and upper(language)=l_iso_lang
and territory <> '00'
and lob_code = l_templ_code;
SELECT cust_account_id, customer_site_use_id
FROM IEX_DELINQUENCIES
WHERE delinquency_ID = in_del_ID;
SELECT template_code
FROM XDO_TEMPLATES_VL
WHERE template_id = in_TEMP_ID
--AND Application_id = 695;
SELECT xref.query_temp_id
FROM iex_query_temp_xref xref
WHERE xref.query_id = P_QUERY_ID
AND xref.template_id = p_temp_id;
select cust.cust_account_id
from hz_cust_accounts cust,
hz_cust_acct_sites_all acc_site,
hz_cust_site_uses_all site_use
where site_use.site_use_id = p_site_use_id and
site_use.cust_acct_site_id = acc_site.cust_acct_site_id and
acc_site.cust_account_id = cust.cust_account_id;
select PARENT_DUNNING_ID
from IEX_DUNNINGS
where DUNNING_ID = p_dunning_id;
select count(idt.cust_trx_id)
from iex_dunning_transactions idt,
ra_customer_trx trx
where idt.dunning_id = p_dunn_dunning_id
and idt.cust_trx_id is not null
and trx.customer_trx_id = idt.cust_trx_id
and trx.printing_option = 'PRI';
SELECT document_type
FROM iex_xml_request_histories
WHERE xml_request_id = p_xml_req_id;
WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - UpdateRow');
IEX_DUNNING_PVT.Update_DUNNING(
p_api_version => 1.0
, p_init_msg_list => FND_API.G_FALSE
, p_commit => FND_API.G_TRUE
, p_dunning_rec => l_dunn_rec
, x_return_status => l_return_status1
, x_msg_count => l_msg_count1
, x_msg_data => l_msg_data1);
WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - UpdateDunning status='|| l_return_status1);
WriteLog(l_msg || ' insert_row' );
WriteLog(' before insert xml org_id ' || p_org_id);
IEX_XML_PKG.insert_row (
px_rowid => l_rowid
,px_xml_request_id => l_request_id
,p_query_temp_id => l_query_temp_id -- Added for bug#8845762 by SNUTHALA on 9/14/2009
,p_status => 'XMLDATA'
,p_document => l_doc
,p_html_document => l_doc
,p_xmldata => l_content_xml
,p_method => p_method
,p_destination => p_dest
,p_subject => p_subject
,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
,p_request_id => -1
,p_worker_id => -1
,p_confirmation_mode => null -- added by gnramasa for bug 8489610 14-May-09
,p_conc_request_id => l_con_req_id --FND_GLOBAL.Conc_Request_Id -- added by gnramasa for bug 8489610 14-May-09
,p_org_id => p_org_id -- added for bug 9151851
,p_template_language => lower(l_templ_lang) -- added by gnramasa for bug 8489610 28-May-09
,p_template_territory => upper(l_templ_terr) -- added by gnramasa for bug 8489610 28-May-09
,p_document_type => l_document_type
,p_addt_query_id => l_addt_query_id
,p_addt_xmldata => l_addt_content_xml
,p_addt_status => l_addt_status
,p_addt_document => l_doc
,p_addt_html_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, addt_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';
WriteLog('GetXmlData: Update dunning Row');
IEX_DUNNING_PVT.Update_DUNNING(
p_api_version => 1.0
, p_init_msg_list => FND_API.G_FALSE
, p_commit => FND_API.G_TRUE
, p_dunning_rec => l_dunn_rec
, x_return_status => l_return_status1
, x_msg_count => l_msg_count1
, x_msg_data => l_msg_data1);
WriteLog('GetXmlData: - UpdateDunning status='|| l_return_status1);
SELECT NVL(PREFERENCE_VALUE, 'FFM')
FROM IEX_APP_PREFERENCES_VL
WHERE PREFERENCE_NAME= 'COLLECTIONS DELIVERY METHOD';