APPS.QPR_MAINTAIN_AW dependencies on V$TIMER

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

265: l_msg_data varchar2(30);
266:
267: Begin
268: log_debug('Starting...');
269: select hsecs into l_start_time from v$timer;
270: log_debug('Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
271: begin
272: select instance_id,
273: base_uom_code, currency_code,

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

408: c_scope_lines_rec.level_seq_num,
409: c_scope_lines_rec.scope_value);
410: end loop; --c_scope_lines
411:
412: select hsecs into l_start_time from v$timer;
413: log_debug('Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
414:
415: log_debug('PricePlanId: '||p_price_plan_id);
416:

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

437: retcode := 1;
438: log_debug('User Plan initialization is not fully successful');
439: end if;
440: */
441: select hsecs into l_end_time from v$timer;
442: log_debug('End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
443: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Time taken for AW Maintanance (sec):' ||
444: (l_end_time - l_start_time)/100);
445: