DBA Data[Home] [Help]

APPS.WF_DIAGNOSTICS dependencies on DUAL

Line 3148: SELECT WF_EVENT.LOCAL_SYSTEM_NAME INTO l_sys_name FROM dual;

3144: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3145:
3146: l_temp_result := '';
3147:
3148: SELECT WF_EVENT.LOCAL_SYSTEM_NAME INTO l_sys_name FROM dual;
3149:
3150: l_temp_result := l_temp_result || '';
3151:
3152: l_temp_result := l_temp_result || '
The local System Name is ' || l_sys_name || '
';

Line 4318: select user into l_user from dual;

4314:
4315: begin
4316:
4317: -- get session user
4318: select user into l_user from dual;
4319:
4320: dbms_lob.CreateTemporary(l_value, TRUE, dbms_lob.session);
4321: dbms_lob.CreateTemporary(l_temp, TRUE, dbms_lob.session);
4322: