APPS.FND_OAM_DEBUG dependencies on DUAL

Line 168: FROM DUAL;

164: END IF;
165: IF p_include_unique_suffix IS NOT NULL AND p_include_unique_suffix THEN
166: SELECT substr(round(to_char(systimestamp, 'FF'),-5),1,4)
167: INTO l_suffix
168: FROM DUAL;
169: END IF;
170: l_name := l_prefix||l_suffix||'.txt';
171:
172: --issue the file open API

Line 324: FROM DUAL;

320: l_s := s;
321: ELSIF b_include_timestamp AND b_use_indentation THEN
322: SELECT systimestamp
323: INTO l_now
324: FROM DUAL;
325: l_s := MAKE_INDENT_STR||'('||to_char(l_now, 'HH24:MI:SS')||'.'||substr(to_char(l_now, 'FF'),1,4)||')['||p_ctxt||']('||p_level||'): "'||s||'"';
326: ELSIF b_include_timestamp THEN
327: SELECT systimestamp
328: INTO l_now

Line 329: FROM DUAL;

325: l_s := MAKE_INDENT_STR||'('||to_char(l_now, 'HH24:MI:SS')||'.'||substr(to_char(l_now, 'FF'),1,4)||')['||p_ctxt||']('||p_level||'): "'||s||'"';
326: ELSIF b_include_timestamp THEN
327: SELECT systimestamp
328: INTO l_now
329: FROM DUAL;
330: l_s := '('||to_char(l_now, 'HH24:MI:SS')||'.'||substr(to_char(l_now, 'FF'),1,4)||')['||p_ctxt||']('||p_level||'): "'||s||'"';
331: ELSIF b_use_indentation THEN
332: l_s := MAKE_INDENT_STR||'['||p_ctxt||']('||p_level||'): "'||s||'"';
333: END IF;