APPS.OE_ERROR_WF dependencies on V$TIMER

Line 2224: SELECT hsecs INTO l_start_total_time from v$timer;

2220: AND Check_Closed_Delivery_Detail (l_retry_rec.item_key(i), l_retry_rec.activity_id(i))) THEN
2221: IF get_lock(p_item_type,l_retry_rec.item_key(i)) THEN
2222: l_get_lock_failed := false;
2223: IF l_debug_level > 0 THEN
2224: SELECT hsecs INTO l_start_total_time from v$timer;
2225: oe_debug_pub.add('Calling Handleerror with item key '||l_retry_rec.item_key(i) ||
2226: ' and activity ' || l_retry_rec.process_name(i)||':'||l_retry_rec.activity_label(i));
2227: END IF;
2228: ----------------------------------------------------------------------------

Line 2262: SELECT hsecs INTO l_end_total_time from v$timer;

2258:
2259: END IF;
2260: l_commit_count := l_commit_count + 1;
2261: IF l_debug_level > 0 THEN
2262: SELECT hsecs INTO l_end_total_time from v$timer;
2263: oe_debug_pub.add('Total time taken to retry above item is (sec) '
2264: ||((l_end_total_time-l_start_total_time)/100));
2265: oe_debug_pub.add('Commit count '|| l_commit_count);
2266: END IF;