APPS.OE_BULK_ORDER_IMPORT_PVT dependencies on V$TIMER

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

155: -- Bug 5640601 =>
156: -- Selecting hsecs from v$times is changed to execute only when debug
157: -- is enabled, as hsec is used for logging only when debug is enabled.
158: IF l_debug_level > 0 THEN
159: SELECT hsecs INTO l_start_time from v$timer;
160: END IF;
161:
162: -- Load the Hold Sources Globals
163: OE_Bulk_Holds_PVT.Load_Hold_Sources;

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

165: -- Bug 5640601 =>
166: -- Selecting hsecs from v$times is changed to execute only when debug
167: -- is enabled, as hsec is used for logging only when debug is enabled.
168: IF l_debug_level > 0 THEN
169: SELECT hsecs INTO l_end_time from v$timer;
170: END IF;
171:
172: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Load Hold Sources is (sec) '
173: ||((l_end_time-l_start_time)/100));

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

1297: -- Bug 5640601 =>
1298: -- Selecting hsecs from v$times is changed to execute only when debug
1299: -- is enabled, as hsec is used for logging only when debug is enabled.
1300: IF p_debug_level > 0 THEN
1301: SELECT hsecs INTO l_start_total_time from v$timer;
1302: END IF;
1303:
1304: Initialize_Request
1305: ( p_request_id => l_request_id

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

1446: -- Bug 5640601 =>
1447: -- Selecting hsecs from v$times is changed to execute only when debug
1448: -- is enabled, as hsec is used for logging only when debug is enabled.
1449: IF p_debug_level > 0 THEN
1450: SELECT hsecs INTO l_end_total_time from v$timer;
1451: END IF;
1452:
1453: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total time is (sec) '
1454: ||((l_end_total_time-l_start_total_time)/100));