DBA Data[Home] [Help]

APPS.WF_DIAGNOSTICS dependencies on DBMS_UTILITY

Line 1997: l_before := dbms_utility.get_time();

1993:
1994: dbms_lob.CreateTemporary(l_doc, false, dbms_lob.Call);
1995:
1996: wf_mail.test_flag := TRUE;
1997: l_before := dbms_utility.get_time();
1998: begin
1999: l_doc := wf_xml.generate(p_event_name, p_event_key, l_parameters);
2000: exception
2001: when others then

Line 2005: l_time_taken := to_char((dbms_utility.get_time()-l_before)/100);

2001: when others then
2002: wf_core.context('WF_DIAGNOSTICS', 'Generate', p_event_name, p_event_key);
2003: raise;
2004: end;
2005: l_time_taken := to_char((dbms_utility.get_time()-l_before)/100);
2006:
2007: l_result := l_result||'Time Taken to complete Generate: '||l_time_taken||' Seconds';
2009: l_result := l_result||'
';




Line 2099: l_before := dbms_utility.get_time();



2095: dbms_lob.CreateTemporary(l_doc, false, dbms_lob.Call);

2096: 

2097: wf_mail.test_flag := TRUE;

2098: 

2099: l_before := dbms_utility.get_time();

2100: 

2101: begin

2102: l_doc := wf_xml.generate(p_event_name, p_event_key, l_parameters);

2103: exception




Line 2109: l_time_taken := to_char((dbms_utility.get_time()-l_before)/100);



2105: wf_core.context('WF_DIAGNOSTICS', 'Generate', p_event_name, p_event_key);

2106: raise;

2107: end;

2108: 

2109: l_time_taken := to_char((dbms_utility.get_time()-l_before)/100);

2110: 

2111: l_result := l_result||'
Time Taken to complete Generate: '||l_time_taken||' Seconds
';
2113: l_result := l_result||'
';