APPS.QP_ATTR_GRP_PVT dependencies on V$TIMER

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

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

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

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

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

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

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

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