DBA Data[Home] [Help]

APPS.OE_BULK_SCHEDULE_UTIL dependencies on V$TIMER

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

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

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

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