DBA Data[Home] [Help]

APPS.OE_BULK_SCHEDULE_UTIL dependencies on V$TIMER

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

1165: -- Bug 5640601 =>
1166: -- Selecting hsecs from v$times is changed to execute only when debug
1167: -- is enabled, as hsec is used for logging only when debug is enabled.
1168: IF l_debug_level > 0 THEN
1169: SELECT hsecs INTO l_start_time from v$timer;
1170: END IF;
1171: MRP_ATP_PUB.Call_ATP
1172: ( p_session_id => l_session_id
1173: , p_atp_rec => l_mrp_atp_rec

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

1183: oe_debug_pub.add( '3. AFTER CALL_ATP , STATUS:' ||X_RETURN_STATUS , 1 ) ;
1184: -- Bug 5640601 =>
1185: -- Selecting hsecs from v$times is changed to execute only when debug
1186: -- is enabled, as hsec is used for logging only when debug is enabled.
1187: SELECT hsecs INTO l_end_time from v$timer;
1188: END IF;
1189:
1190: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in MRP Call is (sec) '||((l_end_time-l_start_time)/100));
1191: