DBA Data[Home] [Help]

APPS.WF_DIAGNOSTICS dependencies on DBMS_UTILITY

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

1806:
1807: dbms_lob.CreateTemporary(l_doc, false, dbms_lob.Call);
1808:
1809: wf_mail.test_flag := TRUE;
1810: l_before := dbms_utility.get_time();
1811: begin
1812: l_doc := wf_xml.generate(p_event_name, p_event_key, l_parameters);
1813: exception
1814: when others then

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

1814: when others then
1815: wf_core.context('WF_DIAGNOSTICS', 'Generate', p_event_name, p_event_key);
1816: raise;
1817: end;
1818: l_time_taken := to_char((dbms_utility.get_time()-l_before)/100);
1819:
1820: l_result := l_result||'Time Taken to complete Generate: '||l_time_taken||' Seconds';
1822: l_result := l_result||'
';




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



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

1909: 

1910: wf_mail.test_flag := TRUE;

1911: 

1912: l_before := dbms_utility.get_time();

1913: 

1914: begin

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

1916: exception




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



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

1919: raise;

1920: end;

1921: 

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

1923: 

1924: l_result := l_result||'
Time Taken to complete Generate: '||l_time_taken||' Seconds
';
1926: l_result := l_result||'
';