APPS.QP_ATTR_GRP_PVT dependencies on V$TIMER

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

231: remove_duplicate_patterns;
232: return;
233: end if;
234:
235: select hsecs into l_start_time from v$timer;
236: fnd_file.put_line(FND_FILE.LOG, 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
237:
238: if p_list_header_id is null then
239: -- like upgrade, refresh everything related to patterns

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

302: l_count := l_count + 1;
303: exit when l_count > l_slab_count;
304: end loop;
305:
306: select hsecs into l_end_time from v$timer;
307: fnd_file.put_line(FND_FILE.LOG, 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
308: fnd_file.put_line(fnd_file.log, 'Time taken for the header process (sec):' ||(l_end_time - l_start_time)/100);
309:
310: fnd_conc_global.set_req_globals(conc_status => 'PAUSED',

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

343: end if; -- if l_total_lines > 0
344: end if; -- if p_spawned_request = 'N'
345:
346: if p_spawned_request = 'Y' then
347: select hsecs into l_start_time from v$timer;
348: fnd_file.put_line(FND_FILE.LOG, 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
349: if p_list_header_id is null then
350: -- like upgrade, refresh everything related to patterns
351: update /*+ index_asc(lines QP_LIST_LINES_PK) */ qp_list_lines lines

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

389: p_high_list_line_id);
390: update_pp_lines(p_list_header_id,
391: p_low_list_line_id,
392: p_high_list_line_id);
393: select hsecs into l_end_time from v$timer;
394: fnd_file.put_line(FND_FILE.LOG, 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
395: fnd_file.put_line(fnd_file.log, 'Time taken for the line process (sec):' ||(l_end_time - l_start_time)/100);
396: end if; -- if p_spawned_request = 'Y'
397: -- commit the changes done so far