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 1206: SELECT hsecs INTO l_start_total_time from v$timer;

1202: -- Bug 5640601 =>
1203: -- Selecting hsecs from v$times is changed to execute only when debug
1204: -- is enabled, as hsec is used for logging only when debug is enabled.
1205: IF p_debug_level > 0 THEN
1206: SELECT hsecs INTO l_start_total_time from v$timer;
1207: END IF;
1208:
1209: Initialize_Request
1210: ( p_request_id => l_request_id

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

1351: -- Bug 5640601 =>
1352: -- Selecting hsecs from v$times is changed to execute only when debug
1353: -- is enabled, as hsec is used for logging only when debug is enabled.
1354: IF p_debug_level > 0 THEN
1355: SELECT hsecs INTO l_end_total_time from v$timer;
1356: END IF;
1357:
1358: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total time is (sec) '
1359: ||((l_end_total_time-l_start_total_time)/100));