APPS.QPR_COPY_PRICE_PLAN dependencies on V$TIMER

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

1486: and parent_id = p_from_pp_id;
1487:
1488: begin
1489: fnd_file.put_line(fnd_file.log, 'Starting to copy...');
1490: select hsecs into l_start_time from v$timer;
1491: fnd_file.put_line(fnd_file.log, 'Start time :'||
1492: to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
1493: fnd_profile.get('CONC_REQUEST_ID', g_request_id);
1494: g_sys_date := sysdate;

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

1576: l_ret_cube := copy_cube_data(p_from_pp_id,t_old_new_dim);
1577: end if;
1578:
1579: commit;
1580: select hsecs into l_end_time from v$timer;
1581: fnd_file.put_line(fnd_file.log, 'End time :'|| to_char(sysdate,
1582: 'MM/DD/YYYY:HH:MM:SS'));
1583: fnd_file.put_line(fnd_file.log, 'Time taken for loading(sec):' ||
1584: (l_end_time - l_start_time)/100);