DBA Data[Home] [Help]

APPS.OE_SHIP_CONFIRMATION_PUB dependencies on V$TIMER

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

4935: -- Bug 5640601 =>
4936: -- Selecting hsecs from v$times is changed to execute only when debug
4937: -- is enabled, as hsec is used for logging only when debug is enabled.
4938: IF l_debug_level > 0 Then
4939: SELECT hsecs INTO l_start_time from v$timer;
4940: end if;
4941:
4942: IF p_index is NULL THEN
4943: IF p_start_index is NULL THEN -- non bulk

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

5091: -- Bug 5640601 =>
5092: -- Selecting hsecs from v$times is changed to execute only when debug
5093: -- is enabled, as hsec is used for logging only when debug is enabled.
5094: IF l_debug_level > 0 Then
5095: SELECT hsecs INTO l_end_time from v$timer;
5096: end if;
5097:
5098: FND_FILE.PUT_LINE
5099: (FND_FILE.LOG,'Time spent in notification framework is (sec) '