APPS.PO_XML_UTILS_GRP dependencies on DUAL

Line 55: select userenv('LANG') into l_lang from dual;

51: l_lang varchar2(30);
52:
53: begin
54:
55: select userenv('LANG') into l_lang from dual;
56:
57: select fad.entity_name, fad.pk1_value, fad.pk2_value,
58: fad.pk3_value, fad.pk4_value, fad.pk5_value
59: into l_entity_name, l_pk1_value, l_pk2_value,

Line 150: select fnd_global.NEWLINE into l_newline from dual;

146: l_filedir := PO_COMMUNICATION_PVT.get_preparer_profile(p_document_id,p_document_type,'PO_EMAIL_TERMS_DIR_NAME');
147: l_filename := PO_COMMUNICATION_PVT.get_preparer_profile(p_document_id,p_document_type,'PO_EMAIL_TERMS_FILE_NAME');
148:
149: --bug#4278861: populate l_newline with new line value from FND_GLOBAL
150: select fnd_global.NEWLINE into l_newline from dual;
151:
152: if ((l_filedir is not null) and (l_filename is not null)) then
153:
154: /* Check for supplier site language tandc file first if that doesn't exist then check for base language tandc file else check for just l_filename */

Line 255: select PO_WF_ITEMKEY_S.nextval into l_wf_item_seq from dual;

251:
252: wf_core.context('PO_ECX_UTIL_PKG','regenandsend',x_progress);
253:
254: -- Create EVENT_KEY and EVENT_NAME
255: select PO_WF_ITEMKEY_S.nextval into l_wf_item_seq from dual;
256: l_event_key := to_char(p_po_header_id) || '-' || to_char(l_wf_item_seq);
257:
258: x_progress := '001';
259: wf_core.context('POM_ECX_UTIL_PKG','regenandsend',x_progress);

Line 444: select userenv('lang') into x_lang from dual;

440: procedure getUserEnvLang (x_lang OUT NOCOPY varchar2) is
441:
442: begin
443:
444: select userenv('lang') into x_lang from dual;
445: exception when others then
446: x_lang := 'US'; --We don't want to error out here. Instead let default be : 'US'.
447: end;
448: