DBA Data[Home] [Help]

APPS.OE_SHIP_CONFIRMATION_PUB dependencies on V$TIMER

Line 5316: SELECT hsecs INTO l_start_time from v$timer;

5312: -- Bug 5640601 =>
5313: -- Selecting hsecs from v$times is changed to execute only when debug
5314: -- is enabled, as hsec is used for logging only when debug is enabled.
5315: IF l_debug_level > 0 Then
5316: SELECT hsecs INTO l_start_time from v$timer;
5317: end if;
5318:
5319: IF p_index is NULL THEN
5320: IF p_start_index is NULL THEN -- non bulk

Line 5474: SELECT hsecs INTO l_end_time from v$timer;

5470: -- Bug 5640601 =>
5471: -- Selecting hsecs from v$times is changed to execute only when debug
5472: -- is enabled, as hsec is used for logging only when debug is enabled.
5473: IF l_debug_level > 0 Then
5474: SELECT hsecs INTO l_end_time from v$timer;
5475: end if;
5476:
5477: FND_FILE.PUT_LINE
5478: (FND_FILE.LOG,'Time spent in notification framework is (sec) '