APPS.QPR_LOAD_MEAS_DATA dependencies on V$TIMER

Line 1814: select hsecs into l_start_time from v$timer;

1810: and INSTANCE_TYPE = l_inst_type
1811: order by TGT_TBL_NAME;
1812: begin
1813: log_debug('Starting...');
1814: select hsecs into l_start_time from v$timer;
1815: log_debug('Start time :'||
1816: to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
1817: db_link := qpr_sr_util.get_dblink(p_instance_id);
1818:

Line 1881: select hsecs into l_end_time from v$timer;

1877: s_sql := get_select_meas_sql(src_table, p_meas_type);
1878: insert_update_meas_data(p_date_from, p_date_to, s_sql);
1879: end if;
1880: end loop;
1881: select hsecs into l_end_time from v$timer;
1882: log_debug('End time :'|| to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
1883: log_debug('Time taken for loading(sec):' ||(l_end_time - l_start_time)/100);
1884: exception
1885: when OTHERS then