APPS.IEX_SEND_XML_PVT dependencies on XDO_LOBS

Line 305: from xdo_lobs

301: WriteLog(l_msg || 'l_iso_lang1 = '||l_iso_lang1 );
302:
303: select count(distinct territory)
304: into l_no_terr
305: from xdo_lobs
306: where application_short_name='IEX' and upper(language)=l_iso_lang1;
307:
308: WriteLog(l_msg || 'l_no_terr = '||l_no_terr );
309:

Line 316: from xdo_lobs

312: --if no of territory is >1 then send territory as '00' else the default territory for that template.
313: if l_no_terr = 1 then
314: select distinct territory
315: into l_templ_terr1
316: from xdo_lobs
317: where application_short_name='IEX' and upper(language)=l_iso_lang1;
318: else
319: l_templ_terr1 := '00';
320: end if;

Line 379: from xdo_lobs

375: WriteLog(l_msg || 'l_iso_lang = '||l_iso_lang );
376:
377: select count(distinct territory)
378: into l_no_terr
379: from xdo_lobs
380: where application_short_name='IEX' and upper(language)=l_iso_lang;
381:
382: WriteLog(l_msg || 'l_no_terr = '||l_no_terr );
383:

Line 390: from xdo_lobs

386: --if no of territory is >1 then send territory as '00' else the default territory for that template.
387: if l_no_terr = 1 then
388: select distinct territory
389: into l_templ_terr
390: from xdo_lobs
391: where application_short_name='IEX' and upper(language)=l_iso_lang;
392: else
393: l_templ_terr := '00';
394: end if;