APPS.PO_XML_UTILS_GRP dependencies on DUAL

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

58: l_lang varchar2(30);
59:
60: begin
61:
62: select userenv('LANG') into l_lang from dual;
63:
64: ECX_ATTACHMENT.register_attachment(p_entity_name, p_pk1_value, p_pk2_value,
65: p_pk3_value, p_pk4_value, p_pk5_value,
66: p_media_id, 6, x_cid);

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

144: l_filedir := PO_COMMUNICATION_PVT.get_preparer_profile(p_document_id,p_document_type,'PO_EMAIL_TERMS_DIR_NAME');
145: l_filename := PO_COMMUNICATION_PVT.get_preparer_profile(p_document_id,p_document_type,'PO_EMAIL_TERMS_FILE_NAME');
146:
147: --bug#4278861: populate l_newline with new line value from FND_GLOBAL
148: select fnd_global.NEWLINE into l_newline from dual;
149:
150: if ((l_filedir is not null) and (l_filename is not null)) then
151:
152: /* 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 253: select PO_WF_ITEMKEY_S.nextval into l_wf_item_seq from dual;

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

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

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