DBA Data[Home] [Help]

APPS.OE_BULK_CONFIG_UTIL dependencies on V$TIMER

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

710: IF l_debug_level > 0 THEN
711: oe_debug_pub.add('BEFORE CALL CZ_BATCH_VALIDATE.Validate', 1);
712: END IF;
713:
714: SELECT hsecs INTO l_start_time from v$timer;
715:
716: CZ_BATCH_VALIDATE.Validate
717: ( config_input_list => l_batch_val_tbl ,
718: init_message => l_xml_hdr ,

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

719: config_messages => l_html_pieces ,
720: validation_status => l_validation_status ,
721: URL => l_url );
722:
723: SELECT hsecs INTO l_end_time from v$timer;
724: p_batch_validate_time := p_batch_validate_time + (l_end_time-l_start_time)/100;
725:
726: IF l_debug_level > 0 THEN
727: oe_debug_pub.add('AFTER CALL CZ_BATCH_VALIDATE.Validate , STATUS : '

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

1840: END IF;
1841:
1842: IF nvl(p_validate_configurations, 'N') = 'Y' THEN
1843:
1844: SELECT hsecs INTO l_start_time from v$timer;
1845:
1846: Validate_Configuration(
1847: p_new_config => 'N',
1848: p_line_rec => l_line_rec,

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

1849: p_line_index => I,
1850: p_batch_validate_time => l_batch_validate_time
1851: );
1852:
1853: SELECT hsecs INTO l_end_time from v$timer;
1854: l_config_validate_time := l_config_validate_time + (l_end_time-l_start_time)/100;
1855:
1856: END IF;
1857:

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

2568: l_line_rec.header_id(I) <> l_line_rec.header_id(I+1)) OR
2569: I = l_line_rec.line_id.count) THEN
2570:
2571:
2572: SELECT hsecs INTO l_start_time from v$timer;
2573:
2574: Validate_Configuration(
2575: p_new_config => 'Y',
2576: p_line_rec => l_line_rec,

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

2577: p_line_index => l_curr_model_index,
2578: p_batch_validate_time => l_batch_validate_time
2579: );
2580:
2581: SELECT hsecs INTO l_end_time from v$timer;
2582: l_config_validate_time := l_config_validate_time + (l_end_time-l_start_time)/100;
2583:
2584: END IF;
2585:

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

3092: IF l_debug_level > 0 THEN
3093: oe_debug_pub.add( 'Calling OE_BULK_VALIDATE.Validate_BOM ') ;
3094: END IF;
3095:
3096: SELECT hsecs INTO l_start_time from v$timer;
3097:
3098: OE_BULK_VALIDATE.Validate_BOM;
3099:
3100: SELECT hsecs INTO l_end_time from v$timer;

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

3096: SELECT hsecs INTO l_start_time from v$timer;
3097:
3098: OE_BULK_VALIDATE.Validate_BOM;
3099:
3100: SELECT hsecs INTO l_end_time from v$timer;
3101: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Validate_BOM is (sec) '
3102: ||((l_end_time-l_start_time)/100));
3103:
3104: END IF;