DBA Data[Home] [Help]

APPS.OE_PAYMENT_DATA_MIGRATION_UTIL dependencies on AD_PARALLEL_UPDATES_PKG

Line 369: ad_parallel_updates_pkg.delete_update_information(

365: -- Fetching records from OE_ORDER_HEADERS_ALL table
366: -----------------------------------------------------------
367: l_table_name := 'OE_ORDER_HEADERS_ALL' ;
368:
369: ad_parallel_updates_pkg.delete_update_information(
370: 0,
371: l_table_owner,
372: l_table_name,
373: l_script_name ) ;

Line 375: ad_parallel_updates_pkg.initialize_rowid_range(

371: l_table_owner,
372: l_table_name,
373: l_script_name ) ;
374:
375: ad_parallel_updates_pkg.initialize_rowid_range(
376: ad_parallel_updates_pkg.ROWID_RANGE,
377: l_table_owner,
378: l_table_name,
379: l_script_name,

Line 376: ad_parallel_updates_pkg.ROWID_RANGE,

372: l_table_name,
373: l_script_name ) ;
374:
375: ad_parallel_updates_pkg.initialize_rowid_range(
376: ad_parallel_updates_pkg.ROWID_RANGE,
377: l_table_owner,
378: l_table_name,
379: l_script_name,
380: X_worker_id,

Line 384: ad_parallel_updates_pkg.get_rowid_range(

380: X_worker_id,
381: X_num_workers,
382: X_batch_size, 0) ;
383:
384: ad_parallel_updates_pkg.get_rowid_range(
385: l_start_rowid,
386: l_end_rowid,
387: l_any_rows_to_process,
388: X_batch_size,

Line 550: ad_parallel_updates_pkg.processed_rowid_range

546: END LOOP;
547: END ;
548: --6757060
549:
550: ad_parallel_updates_pkg.processed_rowid_range
551: (l_rows_processed,
552: l_end_rowid) ;
553:
554: COMMIT ;

Line 556: ad_parallel_updates_pkg.get_rowid_range

552: l_end_rowid) ;
553:
554: COMMIT ;
555:
556: ad_parallel_updates_pkg.get_rowid_range
557: (l_start_rowid,
558: l_end_rowid,
559: l_any_rows_to_process,
560: X_batch_size,

Line 605: ad_parallel_updates_pkg.delete_update_information(

601: -- Fetching records from OE_PAYMENTS table
602: -----------------------------------------------------------
603: l_table_name := 'OE_PAYMENTS' ;
604:
605: ad_parallel_updates_pkg.delete_update_information(
606: 0,
607: l_table_owner,
608: l_table_name,
609: l_script_name ) ;

Line 611: ad_parallel_updates_pkg.initialize_rowid_range(

607: l_table_owner,
608: l_table_name,
609: l_script_name ) ;
610:
611: ad_parallel_updates_pkg.initialize_rowid_range(
612: ad_parallel_updates_pkg.ROWID_RANGE,
613: l_table_owner,
614: l_table_name,
615: l_script_name,

Line 612: ad_parallel_updates_pkg.ROWID_RANGE,

608: l_table_name,
609: l_script_name ) ;
610:
611: ad_parallel_updates_pkg.initialize_rowid_range(
612: ad_parallel_updates_pkg.ROWID_RANGE,
613: l_table_owner,
614: l_table_name,
615: l_script_name,
616: X_worker_id,

Line 620: ad_parallel_updates_pkg.get_rowid_range(

616: X_worker_id,
617: X_num_workers,
618: X_batch_size, 0) ;
619:
620: ad_parallel_updates_pkg.get_rowid_range(
621: l_start_rowid,
622: l_end_rowid,
623: l_any_rows_to_process,
624: X_batch_size,

Line 744: ad_parallel_updates_pkg.processed_rowid_range

740:
741: l_process_total1 := l_process_total1 + l_rows_processed ;
742: END IF ;
743:
744: ad_parallel_updates_pkg.processed_rowid_range
745: (l_rows_processed,
746: l_end_rowid) ;
747:
748: COMMIT ;

Line 750: ad_parallel_updates_pkg.get_rowid_range

746: l_end_rowid) ;
747:
748: COMMIT ;
749:
750: ad_parallel_updates_pkg.get_rowid_range
751: (l_start_rowid,
752: l_end_rowid,
753: l_any_rows_to_process,
754: X_batch_size,

Line 798: ad_parallel_updates_pkg.delete_update_information(

794: -- Fetching records from OE_PAYMENTS table
795: -----------------------------------------------------------
796: l_table_name := 'OE_PAYMENTS' ;
797:
798: ad_parallel_updates_pkg.delete_update_information(
799: 0,
800: l_table_owner,
801: l_table_name,
802: l_script_name ) ;

Line 804: ad_parallel_updates_pkg.initialize_rowid_range(

800: l_table_owner,
801: l_table_name,
802: l_script_name ) ;
803:
804: ad_parallel_updates_pkg.initialize_rowid_range(
805: ad_parallel_updates_pkg.ROWID_RANGE,
806: l_table_owner,
807: l_table_name,
808: l_script_name,

Line 805: ad_parallel_updates_pkg.ROWID_RANGE,

801: l_table_name,
802: l_script_name ) ;
803:
804: ad_parallel_updates_pkg.initialize_rowid_range(
805: ad_parallel_updates_pkg.ROWID_RANGE,
806: l_table_owner,
807: l_table_name,
808: l_script_name,
809: X_worker_id,

Line 813: ad_parallel_updates_pkg.get_rowid_range(

809: X_worker_id,
810: X_num_workers,
811: X_batch_size, 0) ;
812:
813: ad_parallel_updates_pkg.get_rowid_range(
814: l_start_rowid,
815: l_end_rowid,
816: l_any_rows_to_process,
817: X_batch_size,

Line 917: ad_parallel_updates_pkg.processed_rowid_range

913:
914: l_process_total1 := l_process_total1 + l_rows_processed ;
915: END IF ;
916:
917: ad_parallel_updates_pkg.processed_rowid_range
918: (l_rows_processed,
919: l_end_rowid) ;
920:
921: COMMIT ;

Line 923: ad_parallel_updates_pkg.get_rowid_range

919: l_end_rowid) ;
920:
921: COMMIT ;
922:
923: ad_parallel_updates_pkg.get_rowid_range
924: (l_start_rowid,
925: l_end_rowid,
926: l_any_rows_to_process,
927: X_batch_size,

Line 1123: ad_parallel_updates_pkg.delete_update_information(

1119: -- Fetching records from OE_PAYMENTS table
1120: -----------------------------------------------------------
1121: l_table_name := 'OE_PAYMENTS' ;
1122:
1123: ad_parallel_updates_pkg.delete_update_information(
1124: 0,
1125: l_table_owner,
1126: l_table_name,
1127: l_script_name ) ;

Line 1129: ad_parallel_updates_pkg.initialize_rowid_range(

1125: l_table_owner,
1126: l_table_name,
1127: l_script_name ) ;
1128:
1129: ad_parallel_updates_pkg.initialize_rowid_range(
1130: ad_parallel_updates_pkg.ROWID_RANGE,
1131: l_table_owner,
1132: l_table_name,
1133: l_script_name,

Line 1130: ad_parallel_updates_pkg.ROWID_RANGE,

1126: l_table_name,
1127: l_script_name ) ;
1128:
1129: ad_parallel_updates_pkg.initialize_rowid_range(
1130: ad_parallel_updates_pkg.ROWID_RANGE,
1131: l_table_owner,
1132: l_table_name,
1133: l_script_name,
1134: X_worker_id,

Line 1138: ad_parallel_updates_pkg.get_rowid_range(

1134: X_worker_id,
1135: X_num_workers,
1136: X_batch_size, 0) ;
1137:
1138: ad_parallel_updates_pkg.get_rowid_range(
1139: l_start_rowid,
1140: l_end_rowid,
1141: l_any_rows_to_process,
1142: X_batch_size,

Line 1287: ad_parallel_updates_pkg.processed_rowid_range

1283:
1284: l_process_total1 := l_process_total1 + l_rows_processed ;
1285: END IF ;
1286:
1287: ad_parallel_updates_pkg.processed_rowid_range
1288: (l_rows_processed,
1289: l_end_rowid) ;
1290:
1291: COMMIT ;

Line 1293: ad_parallel_updates_pkg.get_rowid_range

1289: l_end_rowid) ;
1290:
1291: COMMIT ;
1292:
1293: ad_parallel_updates_pkg.get_rowid_range
1294: (l_start_rowid,
1295: l_end_rowid,
1296: l_any_rows_to_process,
1297: X_batch_size,

Line 1324: ad_parallel_updates_pkg.delete_update_information(

1320: -- Fetching records from OE_ORDER_HEADERS_ALL table
1321: -----------------------------------------------------------
1322: l_table_name := 'OE_ORDER_HEADERS_ALL' ;
1323:
1324: ad_parallel_updates_pkg.delete_update_information(
1325: 0,
1326: l_table_owner,
1327: l_table_name,
1328: l_script_name ) ;

Line 1330: ad_parallel_updates_pkg.initialize_rowid_range(

1326: l_table_owner,
1327: l_table_name,
1328: l_script_name ) ;
1329:
1330: ad_parallel_updates_pkg.initialize_rowid_range(
1331: ad_parallel_updates_pkg.ROWID_RANGE,
1332: l_table_owner,
1333: l_table_name,
1334: l_script_name,

Line 1331: ad_parallel_updates_pkg.ROWID_RANGE,

1327: l_table_name,
1328: l_script_name ) ;
1329:
1330: ad_parallel_updates_pkg.initialize_rowid_range(
1331: ad_parallel_updates_pkg.ROWID_RANGE,
1332: l_table_owner,
1333: l_table_name,
1334: l_script_name,
1335: X_worker_id,

Line 1339: ad_parallel_updates_pkg.get_rowid_range(

1335: X_worker_id,
1336: X_num_workers,
1337: X_batch_size, 0) ;
1338:
1339: ad_parallel_updates_pkg.get_rowid_range(
1340: l_start_rowid,
1341: l_end_rowid,
1342: l_any_rows_to_process,
1343: X_batch_size,

Line 1414: ad_parallel_updates_pkg.processed_rowid_range

1410:
1411: l_process_total1 := l_process_total1 + l_rows_processed ;
1412: END IF ;
1413:
1414: ad_parallel_updates_pkg.processed_rowid_range
1415: (l_rows_processed,
1416: l_end_rowid) ;
1417:
1418: COMMIT ;

Line 1420: ad_parallel_updates_pkg.get_rowid_range

1416: l_end_rowid) ;
1417:
1418: COMMIT ;
1419:
1420: ad_parallel_updates_pkg.get_rowid_range
1421: (l_start_rowid,
1422: l_end_rowid,
1423: l_any_rows_to_process,
1424: X_batch_size,

Line 1453: ad_parallel_updates_pkg.delete_update_information(

1449: -- Fetching records from OE_ORDER_HEADERS_HISTORY table
1450: -----------------------------------------------------------
1451: l_table_name := 'OE_ORDER_HEADER_HISTORY' ;
1452:
1453: ad_parallel_updates_pkg.delete_update_information(
1454: 0,
1455: l_table_owner,
1456: l_table_name,
1457: l_script_name ) ;

Line 1459: ad_parallel_updates_pkg.initialize_rowid_range(

1455: l_table_owner,
1456: l_table_name,
1457: l_script_name ) ;
1458:
1459: ad_parallel_updates_pkg.initialize_rowid_range(
1460: ad_parallel_updates_pkg.ROWID_RANGE,
1461: l_table_owner,
1462: l_table_name,
1463: l_script_name,

Line 1460: ad_parallel_updates_pkg.ROWID_RANGE,

1456: l_table_name,
1457: l_script_name ) ;
1458:
1459: ad_parallel_updates_pkg.initialize_rowid_range(
1460: ad_parallel_updates_pkg.ROWID_RANGE,
1461: l_table_owner,
1462: l_table_name,
1463: l_script_name,
1464: X_worker_id,

Line 1468: ad_parallel_updates_pkg.get_rowid_range(

1464: X_worker_id,
1465: X_num_workers,
1466: X_batch_size, 0) ;
1467:
1468: ad_parallel_updates_pkg.get_rowid_range(
1469: l_start_rowid,
1470: l_end_rowid,
1471: l_any_rows_to_process,
1472: X_batch_size,

Line 1541: ad_parallel_updates_pkg.processed_rowid_range

1537:
1538: l_process_total1 := l_process_total1 + l_rows_processed ;
1539: END IF ;
1540:
1541: ad_parallel_updates_pkg.processed_rowid_range
1542: (l_rows_processed,
1543: l_end_rowid) ;
1544:
1545: COMMIT ;

Line 1547: ad_parallel_updates_pkg.get_rowid_range

1543: l_end_rowid) ;
1544:
1545: COMMIT ;
1546:
1547: ad_parallel_updates_pkg.get_rowid_range
1548: (l_start_rowid,
1549: l_end_rowid,
1550: l_any_rows_to_process,
1551: X_batch_size,