APPS.QPR_LOAD_MEAS_DATA dependencies on V$TIMER

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

1797: and INSTANCE_TYPE = l_inst_type
1798: order by TGT_TBL_NAME;
1799: begin
1800: log_debug('Starting...');
1801: select hsecs into l_start_time from v$timer;
1802: log_debug('Start time :'||
1803: to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
1804: db_link := qpr_sr_util.get_dblink(p_instance_id);
1805:

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

1864: s_sql := get_select_meas_sql(src_table, p_meas_type);
1865: insert_update_meas_data(p_date_from, p_date_to, s_sql);
1866: end if;
1867: end loop;
1868: select hsecs into l_end_time from v$timer;
1869: log_debug('End time :'|| to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
1870: log_debug('Time taken for loading(sec):' ||(l_end_time - l_start_time)/100);
1871: exception
1872: when OTHERS then