DBA Data[Home] [Help]

APPS.WF_DIAGNOSTICS dependencies on DUAL

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

3495: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3496:
3497: l_temp_result := '';
3498:
3499: SELECT WF_EVENT.LOCAL_SYSTEM_NAME INTO l_sys_name FROM dual;
3500:
3501: l_temp_result := l_temp_result || '';
3502:
3503: l_temp_result := l_temp_result || '
The local System Name is ' || l_sys_name || '
';

Line 4669: select user into l_user from dual;

4665:
4666: begin
4667:
4668: -- get session user
4669: select user into l_user from dual;
4670:
4671: dbms_lob.CreateTemporary(l_value, TRUE, dbms_lob.session);
4672: dbms_lob.CreateTemporary(l_temp, TRUE, dbms_lob.session);
4673: