APPS.QPR_LOAD_DIM_DATA dependencies on V$TIMER

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

59: date_from := fnd_date.canonical_to_date(p_start_date);
60: date_to := fnd_date.canonical_to_date(p_end_date);
61:
62: fnd_file.put_line(fnd_file.log, 'Starting...');
63: select hsecs into l_start_time from v$timer;
64: fnd_file.put_line(fnd_file.log, 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
65:
66: fnd_file.put_line(fnd_file.log, 'Dimension: '||p_dim_code);
67: fnd_file.put_line(fnd_file.log, 'Hierarchy: '||p_hier_code);

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

109:
110: -- delete_duplicate_data (p_instance_id);
111: -- commit;
112:
113: select hsecs into l_end_time from v$timer;
114: fnd_file.put_line(fnd_file.log, 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
115: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Time taken for loading dimension data (sec):' ||(l_end_time - l_start_time)/100);
116:
117: exception