APPS.BSC_DIMENSION_KEYS_PKG dependencies on DBMS_UTILITY

Line 410: l_start := dbms_utility.get_time;

406: l_start number;
407: l_end number;
408: Begin
409: --dbms_output.put_line('Initialize Query :'||bsc_mo_helper_pkg.get_time);
410: l_start := dbms_utility.get_time;
411: initialize_parameters(p_parameters);
412: if (g_xtd_type is not null) then -- XTD query
413: populate_xtd_keys(p_kpi, p_dim_set, p_option_string, p_error_message);
414: else

Line 417: l_end := dbms_utility.get_time;

413: populate_xtd_keys(p_kpi, p_dim_set, p_option_string, p_error_message);
414: else
415: populate_nonxtd_keys(p_kpi, p_dim_set, p_option_string, p_error_message);
416: end if;
417: l_end := dbms_utility.get_time;
418: --dbms_output.put_line('calling internal limit api, time so far = '||(l_end-l_start));
419: l_start := dbms_utility.get_time;
420: limit_aw(p_kpi, p_dim_set);
421: l_end := dbms_utility.get_time;

Line 419: l_start := dbms_utility.get_time;

415: populate_nonxtd_keys(p_kpi, p_dim_set, p_option_string, p_error_message);
416: end if;
417: l_end := dbms_utility.get_time;
418: --dbms_output.put_line('calling internal limit api, time so far = '||(l_end-l_start));
419: l_start := dbms_utility.get_time;
420: limit_aw(p_kpi, p_dim_set);
421: l_end := dbms_utility.get_time;
422: --dbms_output.put_line('completed internal limit api, time so far = '||(l_end-l_start));
423: exception when others then

Line 421: l_end := dbms_utility.get_time;

417: l_end := dbms_utility.get_time;
418: --dbms_output.put_line('calling internal limit api, time so far = '||(l_end-l_start));
419: l_start := dbms_utility.get_time;
420: limit_aw(p_kpi, p_dim_set);
421: l_end := dbms_utility.get_time;
422: --dbms_output.put_line('completed internal limit api, time so far = '||(l_end-l_start));
423: exception when others then
424: --dbms_output.put_line('Exception in initialize_query:'||sqlerrm);
425: raise;