APPS.OE_BULK_ORDER_IMPORT_PVT dependencies on DBMS_UTILITY

Line 966: v_start := DBMS_UTILITY.GET_TIME;

962: -----------------------------------------------------------
963: -- Populate l_instance_tbl for l_num_instances
964: -----------------------------------------------------------
965:
966: v_start := DBMS_UTILITY.GET_TIME;
967: FOR I IN 1..l_num_instances LOOP
968:
969: -- Generate and populate request_id for each instance
970: l_new_request_id := FND_REQUEST.SUBMIT_REQUEST('ONT', 'OEHVIMP',

Line 990: v_end := DBMS_UTILITY.GET_TIME;

986: l_instance_tbl(I).request_id := l_new_request_id; -- I*1000;
987:
988: END LOOP;
989:
990: v_end := DBMS_UTILITY.GET_TIME;
991: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time for submit REQUESTs :'||to_char((v_end-v_start)/100));
992:
993: -----------------------------------------------------------
994: -- BULK Populate Orders Table - l_order_rec

Line 1002: v_start := DBMS_UTILITY.GET_TIME;

998: oe_debug_pub.add('p_process_recs_with_no_org = '||p_process_recs_with_no_org);
999: oe_debug_pub.add('l_default_org_id = '||l_default_org_id);
1000: end if;
1001: If p_process_recs_with_no_org = 'N' Then
1002: v_start := DBMS_UTILITY.GET_TIME;
1003: OPEN c_lines_per_order;
1004: FETCH c_lines_per_order BULK COLLECT
1005: INTO l_order_rec.order_source_id
1006: , l_order_rec.orig_sys_document_ref

Line 1013: v_end := DBMS_UTILITY.GET_TIME;

1009: , l_order_rec.batch_id
1010: , l_order_rec.org_id
1011: ;
1012: CLOSE c_lines_per_order;
1013: v_end := DBMS_UTILITY.GET_TIME;
1014: FND_FILE.PUT_LINE(FND_FILE.LOG,'TIME FOR BULK COLLECT:'||TO_CHAR ( ( V_END-V_START ) /100 ) ) ;
1015: Elsif p_process_recs_with_no_org = 'Y' Then
1016: v_start := DBMS_UTILITY.GET_TIME;
1017: If p_debug_level > 0 Then

Line 1016: v_start := DBMS_UTILITY.GET_TIME;

1012: CLOSE c_lines_per_order;
1013: v_end := DBMS_UTILITY.GET_TIME;
1014: FND_FILE.PUT_LINE(FND_FILE.LOG,'TIME FOR BULK COLLECT:'||TO_CHAR ( ( V_END-V_START ) /100 ) ) ;
1015: Elsif p_process_recs_with_no_org = 'Y' Then
1016: v_start := DBMS_UTILITY.GET_TIME;
1017: If p_debug_level > 0 Then
1018: oe_debug_pub.add('here1');
1019: End If;
1020: OPEN c_lines_per_order_2;

Line 1030: v_end := DBMS_UTILITY.GET_TIME;

1026: , l_order_rec.batch_id
1027: , l_order_rec.org_id
1028: ;
1029: CLOSE c_lines_per_order_2;
1030: v_end := DBMS_UTILITY.GET_TIME;
1031: FND_FILE.PUT_LINE(FND_FILE.LOG,'TIME FOR BULK COLLECT:'||TO_CHAR ( ( V_END-V_START ) /100 ) ) ;
1032: End If;
1033: -----------------------------------------------------------
1034: -- Assign request_id (instance) AND batch_id to the orders

Line 1042: v_start := DBMS_UTILITY.GET_TIME;

1038: If p_debug_level > 0 Then
1039: oe_debug_pub.add('Order Count = '||l_order_count);
1040: End If;
1041: minimum := 0;
1042: v_start := DBMS_UTILITY.GET_TIME;
1043: l_index := 1;
1044:
1045: <>
1046: WHILE l_index <= l_order_count LOOP

Line 1156: v_end := DBMS_UTILITY.GET_TIME;

1152:
1153: l_index := l_index + 1;
1154:
1155: END LOOP; -- End of loop over Orders table - l_order_rec
1156: v_end := DBMS_UTILITY.GET_TIME;
1157: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time to ASSIGN IDs :'||to_char((v_end-v_start)/100));
1158:
1159:
1160: --------------------------------------------------------------

Line 1164: v_start := DBMS_UTILITY.GET_TIME;

1160: --------------------------------------------------------------
1161: -- BULK UPDATE Request_ID and Batch_ID on headers iface table
1162: --------------------------------------------------------------
1163:
1164: v_start := DBMS_UTILITY.GET_TIME;
1165: FORALL l_index IN 1..l_order_count
1166: UPDATE oe_headers_iface_all
1167: SET request_id = l_order_rec.request_id(l_index)
1168: , batch_id = l_order_rec.batch_id(l_index)

Line 1245: v_end := DBMS_UTILITY.GET_TIME;

1241: END LOOP;
1242:
1243: END LOOP;
1244:
1245: v_end := DBMS_UTILITY.GET_TIME;
1246: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time to BULK UPDATE:'||to_char((v_end-v_start)/100));
1247:
1248: COMMIT;
1249: