APPS.OE_BULK_ORDER_IMPORT_PVT dependencies on DBMS_UTILITY

Line 871: v_start := DBMS_UTILITY.GET_TIME;

867: -----------------------------------------------------------
868: -- Populate l_instance_tbl for l_num_instances
869: -----------------------------------------------------------
870:
871: v_start := DBMS_UTILITY.GET_TIME;
872: FOR I IN 1..l_num_instances LOOP
873:
874: -- Generate and populate request_id for each instance
875: l_new_request_id := FND_REQUEST.SUBMIT_REQUEST('ONT', 'OEHVIMP',

Line 895: v_end := DBMS_UTILITY.GET_TIME;

891: l_instance_tbl(I).request_id := l_new_request_id; -- I*1000;
892:
893: END LOOP;
894:
895: v_end := DBMS_UTILITY.GET_TIME;
896: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time for submit REQUESTs :'||to_char((v_end-v_start)/100));
897:
898: -----------------------------------------------------------
899: -- BULK Populate Orders Table - l_order_rec

Line 907: v_start := DBMS_UTILITY.GET_TIME;

903: oe_debug_pub.add('p_process_recs_with_no_org = '||p_process_recs_with_no_org);
904: oe_debug_pub.add('l_default_org_id = '||l_default_org_id);
905: end if;
906: If p_process_recs_with_no_org = 'N' Then
907: v_start := DBMS_UTILITY.GET_TIME;
908: OPEN c_lines_per_order;
909: FETCH c_lines_per_order BULK COLLECT
910: INTO l_order_rec.order_source_id
911: , l_order_rec.orig_sys_document_ref

Line 918: v_end := DBMS_UTILITY.GET_TIME;

914: , l_order_rec.batch_id
915: , l_order_rec.org_id
916: ;
917: CLOSE c_lines_per_order;
918: v_end := DBMS_UTILITY.GET_TIME;
919: FND_FILE.PUT_LINE(FND_FILE.LOG,'TIME FOR BULK COLLECT:'||TO_CHAR ( ( V_END-V_START ) /100 ) ) ;
920: Elsif p_process_recs_with_no_org = 'Y' Then
921: v_start := DBMS_UTILITY.GET_TIME;
922: If p_debug_level > 0 Then

Line 921: v_start := DBMS_UTILITY.GET_TIME;

917: CLOSE c_lines_per_order;
918: v_end := DBMS_UTILITY.GET_TIME;
919: FND_FILE.PUT_LINE(FND_FILE.LOG,'TIME FOR BULK COLLECT:'||TO_CHAR ( ( V_END-V_START ) /100 ) ) ;
920: Elsif p_process_recs_with_no_org = 'Y' Then
921: v_start := DBMS_UTILITY.GET_TIME;
922: If p_debug_level > 0 Then
923: oe_debug_pub.add('here1');
924: End If;
925: OPEN c_lines_per_order_2;

Line 935: v_end := DBMS_UTILITY.GET_TIME;

931: , l_order_rec.batch_id
932: , l_order_rec.org_id
933: ;
934: CLOSE c_lines_per_order_2;
935: v_end := DBMS_UTILITY.GET_TIME;
936: FND_FILE.PUT_LINE(FND_FILE.LOG,'TIME FOR BULK COLLECT:'||TO_CHAR ( ( V_END-V_START ) /100 ) ) ;
937: End If;
938: -----------------------------------------------------------
939: -- Assign request_id (instance) AND batch_id to the orders

Line 947: v_start := DBMS_UTILITY.GET_TIME;

943: If p_debug_level > 0 Then
944: oe_debug_pub.add('Order Count = '||l_order_count);
945: End If;
946: minimum := 0;
947: v_start := DBMS_UTILITY.GET_TIME;
948: l_index := 1;
949:
950: <>
951: WHILE l_index <= l_order_count LOOP

Line 1061: v_end := DBMS_UTILITY.GET_TIME;

1057:
1058: l_index := l_index + 1;
1059:
1060: END LOOP; -- End of loop over Orders table - l_order_rec
1061: v_end := DBMS_UTILITY.GET_TIME;
1062: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time to ASSIGN IDs :'||to_char((v_end-v_start)/100));
1063:
1064:
1065: --------------------------------------------------------------

Line 1069: v_start := DBMS_UTILITY.GET_TIME;

1065: --------------------------------------------------------------
1066: -- BULK UPDATE Request_ID and Batch_ID on headers iface table
1067: --------------------------------------------------------------
1068:
1069: v_start := DBMS_UTILITY.GET_TIME;
1070: FORALL l_index IN 1..l_order_count
1071: UPDATE oe_headers_iface_all
1072: SET request_id = l_order_rec.request_id(l_index)
1073: , batch_id = l_order_rec.batch_id(l_index)

Line 1150: v_end := DBMS_UTILITY.GET_TIME;

1146: END LOOP;
1147:
1148: END LOOP;
1149:
1150: v_end := DBMS_UTILITY.GET_TIME;
1151: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time to BULK UPDATE:'||to_char((v_end-v_start)/100));
1152:
1153: COMMIT;
1154: