eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.OE_BULK_ORDER_PVT dependencies on V$TIMER

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

317: -- Bug 5640601 =>
318: -- Selecting hsecs from v$times is changed to execute only when debug
319: -- is enabled, as hsec is used for logging only when debug is enabled.
320: IF l_debug_level > 0 Then
321: SELECT hsecs INTO l_start_time from v$timer;
322: end if;
323:
324: OE_Bulk_Header_Util.Load_Headers
325: (p_batch_id => p_batch_id

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

328: -- Bug 5640601 =>
329: -- Selecting hsecs from v$times is changed to execute only when debug
330: -- is enabled, as hsec is used for logging only when debug is enabled.
331: IF l_debug_level > 0 Then
332: SELECT hsecs INTO l_end_time from v$timer;
333: end if;
334:
335: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Load_Headers is (sec) '||((l_end_time-l_start_time)/100));
336:

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

348: -- Bug 5640601 =>
349: -- Selecting hsecs from v$times is changed to execute only when debug
350: -- is enabled, as hsec is used for logging only when debug is enabled.
351: IF l_debug_level > 0 Then
352: SELECT hsecs INTO l_start_time from v$timer;
353: end if;
354:
355: OE_Bulk_Process_Header.Entity
356: (p_header_rec => G_HEADER_REC

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

365: -- Bug 5640601 =>
366: -- Selecting hsecs from v$times is changed to execute only when debug
367: -- is enabled, as hsec is used for logging only when debug is enabled.
368: IF l_debug_level > 0 Then
369: SELECT hsecs INTO l_end_time from v$timer;
370: end if;
371:
372:
373: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Headers Entity validation is (sec) '||((l_end_time-l_start_time)/100));

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

384: -- Bug 5640601 =>
385: -- Selecting hsecs from v$times is changed to execute only when debug
386: -- is enabled, as hsec is used for logging only when debug is enabled.
387: IF l_debug_level > 0 Then
388: SELECT hsecs INTO l_start_time from v$timer;
389: end if;
390:
391: OE_Bulk_Msg_PUB.Save_Messages(G_REQUEST_ID);
392:

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

393: -- Bug 5640601 =>
394: -- Selecting hsecs from v$times is changed to execute only when debug
395: -- is enabled, as hsec is used for logging only when debug is enabled.
396: IF l_debug_level > 0 Then
397: SELECT hsecs INTO l_end_time from v$timer;
398: end if;
399:
400: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Save Messages is (sec) '||((l_end_time-l_start_time)/100));
401:

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

406: -- Bug 5640601 =>
407: -- Selecting hsecs from v$times is changed to execute only when debug
408: -- is enabled, as hsec is used for logging only when debug is enabled.
409: IF l_debug_level > 0 Then
410: SELECT hsecs INTO l_start_time from v$timer;
411: end if;
412: Process_Invalid_Records;
413:
414: -- Bug 5640601 =>

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

414: -- Bug 5640601 =>
415: -- Selecting hsecs from v$times is changed to execute only when debug
416: -- is enabled, as hsec is used for logging only when debug is enabled.
417: IF l_debug_level > 0 Then
418: SELECT hsecs INTO l_end_time from v$timer;
419: end if;
420:
421: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Process_Invalid_Records is (sec) '||((l_end_time-l_start_time)/100));
422:

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

431: -- Bug 5640601 =>
432: -- Selecting hsecs from v$times is changed to execute only when debug
433: -- is enabled, as hsec is used for logging only when debug is enabled.
434: IF l_debug_level > 0 Then
435: SELECT hsecs INTO l_start_time from v$timer;
436: end if;
437:
438: OE_Bulk_Header_Util.Create_Header_Scredits(l_header_scredit_rec);
439:

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

440: -- Bug 5640601 =>
441: -- Selecting hsecs from v$times is changed to execute only when debug
442: -- is enabled, as hsec is used for logging only when debug is enabled.
443: IF l_debug_level > 0 Then
444: SELECT hsecs INTO l_end_time from v$timer;
445: end if;
446:
447: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Create Sales Credits is (sec) '
448: ||((l_end_time-l_start_time)/100));

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

483: -- Bug 5640601 =>
484: -- Selecting hsecs from v$times is changed to execute only when debug
485: -- is enabled, as hsec is used for logging only when debug is enabled.
486: IF l_debug_level > 0 Then
487: SELECT hsecs INTO l_start_time from v$timer;
488: end if;
489: oe_debug_pub.add( 'Process Tax :'|| p_process_tax,1);
490:
491: OE_Bulk_Line_Util.Load_Lines

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

497:
498: -- Bug 5640601 =>
499: -- Selecting hsecs from v$times is changed to execute only when debug
500: -- is enabled, as hsec is used for logging only when debug is enabled.
501: SELECT hsecs INTO l_end_time from v$timer;
502: END IF;
503:
504: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Load_Lines is (sec) '||((l_end_time-l_start_time)/100));
505:

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

514: -- Bug 5640601 =>
515: -- Selecting hsecs from v$times is changed to execute only when debug
516: -- is enabled, as hsec is used for logging only when debug is enabled.
517: IF l_debug_level > 0 Then
518: SELECT hsecs INTO l_start_time from v$timer;
519: end if;
520:
521:
522: OE_Bulk_Process_Line.Entity

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

535: -- Bug 5640601 =>
536: -- Selecting hsecs from v$times is changed to execute only when debug
537: -- is enabled, as hsec is used for logging only when debug is enabled.
538: IF l_debug_level > 0 Then
539: SELECT hsecs INTO l_end_time from v$timer;
540: end if;
541:
542: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Entity Validation is (sec) '||((l_end_time-l_start_time)/100));
543:

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

552: -- Bug 5640601 =>
553: -- Selecting hsecs from v$times is changed to execute only when debug
554: -- is enabled, as hsec is used for logging only when debug is enabled.
555: IF l_debug_level > 0 Then
556: SELECT hsecs INTO l_start_time from v$timer;
557: end if;
558:
559: Process_Invalid_Records;
560:

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

561: -- Bug 5640601 =>
562: -- Selecting hsecs from v$times is changed to execute only when debug
563: -- is enabled, as hsec is used for logging only when debug is enabled.
564: IF l_debug_level > 0 Then
565: SELECT hsecs INTO l_end_time from v$timer;
566: end if;
567:
568: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Process_Invalid Records for lines is (sec) '||((l_end_time-l_start_time)/100));
569:

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

574: -- Bug 5640601 =>
575: -- Selecting hsecs from v$times is changed to execute only when debug
576: -- is enabled, as hsec is used for logging only when debug is enabled.
577: IF l_debug_level > 0 Then
578: SELECT hsecs INTO l_start_time from v$timer;
579: end if;
580:
581: OE_Bulk_Line_Util.Create_Line_Scredits(l_line_scredit_rec);
582:

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

583: -- Bug 5640601 =>
584: -- Selecting hsecs from v$times is changed to execute only when debug
585: -- is enabled, as hsec is used for logging only when debug is enabled.
586: IF l_debug_level > 0 Then
587: SELECT hsecs INTO l_end_time from v$timer;
588: end if;
589:
590: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Create Line Sales Credits is (sec) '
591: ||((l_end_time-l_start_time)/100));

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

643: -- Bug 5640601 =>
644: -- Selecting hsecs from v$times is changed to execute only when debug
645: -- is enabled, as hsec is used for logging only when debug is enabled.
646: IF l_debug_level > 0 Then
647: SELECT hsecs INTO l_start_time from v$timer;
648: end if;
649:
650: INV_SalesOrder.Create_MTL_Sales_Orders_Bulk
651: (p_api_version_number => 1.0

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

665: -- Bug 5640601 =>
666: -- Selecting hsecs from v$times is changed to execute only when debug
667: -- is enabled, as hsec is used for logging only when debug is enabled.
668: IF l_debug_level > 0 Then
669: SELECT hsecs INTO l_end_time from v$timer;
670: end if;
671:
672:
673: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in MTL_SALES_ORDERS creates is (sec) '

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

683: -- Bug 5640601 =>
684: -- Selecting hsecs from v$times is changed to execute only when debug
685: -- is enabled, as hsec is used for logging only when debug is enabled.
686: IF l_debug_level > 0 Then
687: SELECT hsecs INTO l_start_time from v$timer;
688: end if;
689:
690: OE_Bulk_Schedule_Util.Schedule_Orders
691: (p_line_rec => OE_BULK_ORDER_PVT.G_LINE_REC

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

700: -- Bug 5640601 =>
701: -- Selecting hsecs from v$times is changed to execute only when debug
702: -- is enabled, as hsec is used for logging only when debug is enabled.
703: IF l_debug_level > 0 Then
704: SELECT hsecs INTO l_end_time from v$timer;
705: end if;
706:
707: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Scheduling is (sec) '
708: ||((l_end_time-l_start_time)/100));

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

720: -- Bug 5640601 =>
721: -- Selecting hsecs from v$times is changed to execute only when debug
722: -- is enabled, as hsec is used for logging only when debug is enabled.
723: IF l_debug_level > 0 Then
724: SELECT hsecs INTO l_start_time from v$timer;
725: end if;
726:
727: IF G_PRICING_NEEDED = 'Y' AND QP_UTIL_PUB.Hvop_Pricing_Setup = 'Y'
728: AND NOT G_CATCHWEIGHT THEN --bug 3798477

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

752: -- Bug 5640601 =>
753: -- Selecting hsecs from v$times is changed to execute only when debug
754: -- is enabled, as hsec is used for logging only when debug is enabled.
755: IF l_debug_level > 0 Then
756: SELECT hsecs INTO l_end_time from v$timer;
757: end if;
758:
759:
760: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in HVOP Pricing is (sec) '

Line 770: select hsecs into l_start_time from v$timer;

766:
767: -- added for HVOP TAX project
768: IF p_process_tax = 'Y' AND
769: G_PRICING_NEEDED = 'N' THEN
770: select hsecs into l_start_time from v$timer;
771:
772: /*TAX ER Commented the call to calculate_tax as the call is happening twice */
773: -- OE_Bulk_Tax_Util.Calculate_Tax(p_post_insert => FALSE); --TAX ER
774: select hsecs into l_end_time from v$timer;

Line 774: select hsecs into l_end_time from v$timer;

770: select hsecs into l_start_time from v$timer;
771:
772: /*TAX ER Commented the call to calculate_tax as the call is happening twice */
773: -- OE_Bulk_Tax_Util.Calculate_Tax(p_post_insert => FALSE); --TAX ER
774: select hsecs into l_end_time from v$timer;
775:
776: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Tax is (sec) '
777: ||((l_end_time-l_start_time)/100));
778:

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

793: -- Bug 5640601 =>
794: -- Selecting hsecs from v$times is changed to execute only when debug
795: -- is enabled, as hsec is used for logging only when debug is enabled.
796: IF l_debug_level > 0 Then
797: SELECT hsecs INTO l_start_time from v$timer;
798: end if;
799:
800: OE_Bulk_Header_Util.Insert_Headers
801: ( p_header_rec => G_HEADER_REC

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

805: -- Bug 5640601 =>
806: -- Selecting hsecs from v$times is changed to execute only when debug
807: -- is enabled, as hsec is used for logging only when debug is enabled.
808: IF l_debug_level > 0 Then
809: SELECT hsecs INTO l_end_time from v$timer;
810: end if;
811:
812: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Insert_headers is (sec) '||((l_end_time-l_start_time)/100));
813:

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

814: -- Bug 5640601 =>
815: -- Selecting hsecs from v$times is changed to execute only when debug
816: -- is enabled, as hsec is used for logging only when debug is enabled.
817: IF l_debug_level > 0 Then
818: SELECT hsecs INTO l_start_time from v$timer;
819: end if;
820:
821: OE_Bulk_Line_Util.Insert_Lines
822: ( p_line_rec => G_LINE_REC

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

825: -- Bug 5640601 =>
826: -- Selecting hsecs from v$times is changed to execute only when debug
827: -- is enabled, as hsec is used for logging only when debug is enabled.
828: IF l_debug_level > 0 Then
829: SELECT hsecs INTO l_end_time from v$timer;
830: end if;
831:
832: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Insert_Lines is (sec) '||((l_end_time-l_start_time)/100));
833:

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

839: -- Bug 5640601 =>
840: -- Selecting hsecs from v$times is changed to execute only when debug
841: -- is enabled, as hsec is used for logging only when debug is enabled.
842: IF l_debug_level > 0 Then
843: SELECT hsecs INTO l_start_time from v$timer;
844: end if;
845:
846: OE_Bulk_Holds_Pvt.Create_Holds;
847:

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

848: -- Bug 5640601 =>
849: -- Selecting hsecs from v$times is changed to execute only when debug
850: -- is enabled, as hsec is used for logging only when debug is enabled.
851: IF l_debug_level > 0 Then
852: SELECT hsecs INTO l_end_time from v$timer;
853: end if;
854:
855: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Evaluating Holds is (sec) '
856: ||((l_end_time-l_start_time)/100));

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

865: -- Bug 5640601 =>
866: -- Selecting hsecs from v$times is changed to execute only when debug
867: -- is enabled, as hsec is used for logging only when debug is enabled.
868: IF l_debug_level > 0 Then
869: SELECT hsecs INTO l_start_time from v$timer;
870: end if;
871:
872: Update_DBI_Log(p_line_rec => G_LINE_REC
873: ,x_return_status => l_return_status

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

882: -- Bug 5640601 =>
883: -- Selecting hsecs from v$times is changed to execute only when debug
884: -- is enabled, as hsec is used for logging only when debug is enabled.
885: IF l_debug_level > 0 Then
886: SELECT hsecs INTO l_end_time from v$timer;
887: end if;
888:
889: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Update DBI Logs is (sec) '
890: ||((l_end_time-l_start_time)/100));

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

912: -- Bug 5640601 =>
913: -- Selecting hsecs from v$times is changed to execute only when debug
914: -- is enabled, as hsec is used for logging only when debug is enabled.
915: IF l_debug_level > 0 Then
916: SELECT hsecs INTO l_start_time from v$timer;
917: end if;
918:
919: OE_Bulk_Price_Pvt.Insert_Adjustments(p_batch_id, l_return_status);
920:

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

925: -- Bug 5640601 =>
926: -- Selecting hsecs from v$times is changed to execute only when debug
927: -- is enabled, as hsec is used for logging only when debug is enabled.
928: IF l_debug_level > 0 Then
929: SELECT hsecs INTO l_end_time from v$timer;
930: end if;
931:
932: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Inserting Price Adjs is (sec) '
933: ||((l_end_time-l_start_time)/100));

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

941: -- Bug 5640601 =>
942: -- Selecting hsecs from v$times is changed to execute only when debug
943: -- is enabled, as hsec is used for logging only when debug is enabled.
944: IF l_debug_level > 0 Then
945: SELECT hsecs INTO l_start_time from v$timer;
946: end if;
947:
948: OE_Bulk_Price_Pvt.Price_Orders
949: (p_header_rec => G_HEADER_REC

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

966: -- Bug 5640601 =>
967: -- Selecting hsecs from v$times is changed to execute only when debug
968: -- is enabled, as hsec is used for logging only when debug is enabled.
969: IF l_debug_level > 0 Then
970: SELECT hsecs INTO l_end_time from v$timer;
971: end if;
972:
973: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Pricing is (sec) '
974: ||((l_end_time-l_start_time)/100));

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

997: -- Bug 5640601 =>
998: -- Selecting hsecs from v$times is changed to execute only when debug
999: -- is enabled, as hsec is used for logging only when debug is enabled.
1000: IF l_debug_level > 0 Then
1001: SELECT hsecs INTO l_start_time from v$timer;
1002: end if;
1003:
1004: OE_Bulk_Ack_Pvt.Process_Acknowledgments(p_batch_id, l_return_status);
1005:

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

1010: -- Bug 5640601 =>
1011: -- Selecting hsecs from v$times is changed to execute only when debug
1012: -- is enabled, as hsec is used for logging only when debug is enabled.
1013: IF l_debug_level > 0 Then
1014: SELECT hsecs INTO l_end_time from v$timer;
1015: end if;
1016:
1017: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Acknowledgments is (sec) '
1018: ||((l_end_time-l_start_time)/100));

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

1027: -- Bug 5640601 =>
1028: -- Selecting hsecs from v$times is changed to execute only when debug
1029: -- is enabled, as hsec is used for logging only when debug is enabled.
1030: IF l_debug_level > 0 Then
1031: SELECT hsecs INTO l_start_time from v$timer;
1032: end if;
1033:
1034: OE_Bulk_WF_Util.Start_Flows(p_header_rec => G_HEADER_REC
1035: ,p_line_rec => G_LINE_REC

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

1043: -- Bug 5640601 =>
1044: -- Selecting hsecs from v$times is changed to execute only when debug
1045: -- is enabled, as hsec is used for logging only when debug is enabled.
1046: IF l_debug_level > 0 Then
1047: SELECT hsecs INTO l_end_time from v$timer;
1048: end if;
1049:
1050: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Starting Workflows is (sec) '
1051: ||((l_end_time-l_start_time)/100));

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

1059: -- Bug 5640601 =>
1060: -- Selecting hsecs from v$times is changed to execute only when debug
1061: -- is enabled, as hsec is used for logging only when debug is enabled.
1062: IF l_debug_level > 0 Then
1063: SELECT hsecs INTO l_start_time from v$timer;
1064: end if;
1065:
1066: IF G_LINE_REC.shipping_eligible_flag.COUNT > 0 THEN
1067:

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

1085: -- Bug 5640601 =>
1086: -- Selecting hsecs from v$times is changed to execute only when debug
1087: -- is enabled, as hsec is used for logging only when debug is enabled.
1088: IF l_debug_level > 0 Then
1089: SELECT hsecs INTO l_end_time from v$timer;
1090: end if;
1091:
1092: FND_FILE.PUT_LINE
1093: (FND_FILE.LOG,'Time spent in OM to WSH Interface is (sec) '

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

1199: -- Bug 5640601 =>
1200: -- Selecting hsecs from v$times is changed to execute only when debug
1201: -- is enabled, as hsec is used for logging only when debug is enabled.
1202: IF l_debug_level > 0 Then
1203: SELECT hsecs INTO l_start_time from v$timer;
1204: end if;
1205: OE_BULK_VALIDATE.Pre_Process(p_batch_id);
1206: -- Bug 5640601 =>
1207: -- Selecting hsecs from v$times is changed to execute only when debug

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

1206: -- Bug 5640601 =>
1207: -- Selecting hsecs from v$times is changed to execute only when debug
1208: -- is enabled, as hsec is used for logging only when debug is enabled.
1209: IF l_debug_level > 0 Then
1210: SELECT hsecs INTO l_end_time from v$timer;
1211: end if;
1212: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Pre_Process is (sec) '
1213: ||((l_end_time-l_start_time)/100));
1214:

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

1220: -- Bug 5640601 =>
1221: -- Selecting hsecs from v$times is changed to execute only when debug
1222: -- is enabled, as hsec is used for logging only when debug is enabled.
1223: IF l_debug_level > 0 Then
1224: SELECT hsecs INTO l_start_time from v$timer;
1225: end if;
1226: OE_BULK_VALIDATE.Attributes(p_batch_id, l_adjustments_exist);
1227: -- Bug 5640601 =>
1228: -- Selecting hsecs from v$times is changed to execute only when debug

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

1227: -- Bug 5640601 =>
1228: -- Selecting hsecs from v$times is changed to execute only when debug
1229: -- is enabled, as hsec is used for logging only when debug is enabled.
1230: IF l_debug_level > 0 Then
1231: SELECT hsecs INTO l_end_time from v$timer;
1232: end if;
1233: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Attribute Validation is (sec) '
1234: ||((l_end_time-l_start_time)/100));
1235:

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

1241: -- Bug 5640601 =>
1242: -- Selecting hsecs from v$times is changed to execute only when debug
1243: -- is enabled, as hsec is used for logging only when debug is enabled.
1244: IF l_debug_level > 0 Then
1245: SELECT hsecs INTO l_start_time from v$timer;
1246: end if;
1247:
1248: -- Value to ID for Header Attributes
1249:

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

1266: -- Bug 5640601 =>
1267: -- Selecting hsecs from v$times is changed to execute only when debug
1268: -- is enabled, as hsec is used for logging only when debug is enabled.
1269: IF l_debug_level > 0 Then
1270: SELECT hsecs INTO l_end_time from v$timer;
1271: end if;
1272: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Value To ID is (sec) '
1273: ||((l_end_time-l_start_time)/100));
1274:

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

1294: IF l_debug_level > 0 THEN
1295: oe_debug_pub.add( 'CALLING OE_BULK_CONFIG_UTIL.Pre_Process ' ) ;
1296: END IF;
1297:
1298: SELECT hsecs INTO l_start_time from v$timer;
1299:
1300: OE_BULK_CONFIG_UTIL.Pre_Process
1301: (p_batch_id => p_batch_id,
1302: p_validate_only => p_validate_only,

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

1302: p_validate_only => p_validate_only,
1303: p_use_configurator => G_CONFIGURATOR_USED,
1304: p_validate_configurations => p_validate_configurations);
1305:
1306: SELECT hsecs INTO l_end_time from v$timer;
1307: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in CONFIG Pre_Process is (sec) '
1308: ||((l_end_time-l_start_time)/100));
1309:
1310: END IF;