APPS.WF_LOG_PKG dependencies on DBMS_UTILITY

Line 215: l_idx := dbms_utility.get_hash_value(module, 1, 1048576);

211: l_start_time number;
212: l_idx number;
213: begin
214: -- using 2^20 as the size of the hash table
215: l_idx := dbms_utility.get_hash_value(module, 1, 1048576);
216:
217: if (starts) then
218: wf_log_pkg.g_start_times(l_idx) := dbms_utility.get_time();
219: l_log := ' [Start time '||to_char(wf_log_pkg.g_start_times(l_idx))||']';

Line 218: wf_log_pkg.g_start_times(l_idx) := dbms_utility.get_time();

214: -- using 2^20 as the size of the hash table
215: l_idx := dbms_utility.get_hash_value(module, 1, 1048576);
216:
217: if (starts) then
218: wf_log_pkg.g_start_times(l_idx) := dbms_utility.get_time();
219: l_log := ' [Start time '||to_char(wf_log_pkg.g_start_times(l_idx))||']';
220: else
221: l_end_time := dbms_utility.get_time();
222: l_start_time := wf_log_pkg.g_start_times(l_idx);

Line 221: l_end_time := dbms_utility.get_time();

217: if (starts) then
218: wf_log_pkg.g_start_times(l_idx) := dbms_utility.get_time();
219: l_log := ' [Start time '||to_char(wf_log_pkg.g_start_times(l_idx))||']';
220: else
221: l_end_time := dbms_utility.get_time();
222: l_start_time := wf_log_pkg.g_start_times(l_idx);
223:
224: -- Retaining the start time may help printing incremental
225: -- elapsed time... Scope for improvement later.