DBA Data[Home] [Help]

APPS.AR_LATE_CHARGE_UPG dependencies on AD_PARALLEL_UPDATES_PKG

Line 62: ad_parallel_updates_pkg.initialize_rowid_range(

58: END IF;
59:
60:
61: /* ------ Initialize the rowid ranges ------ */
62: ad_parallel_updates_pkg.initialize_rowid_range(
63: ad_parallel_updates_pkg.ROWID_RANGE,
64: l_table_owner,
65: l_table_name,
66: l_script_name,

Line 63: ad_parallel_updates_pkg.ROWID_RANGE,

59:
60:
61: /* ------ Initialize the rowid ranges ------ */
62: ad_parallel_updates_pkg.initialize_rowid_range(
63: ad_parallel_updates_pkg.ROWID_RANGE,
64: l_table_owner,
65: l_table_name,
66: l_script_name,
67: l_worker_id,

Line 72: ad_parallel_updates_pkg.get_rowid_range(

68: l_num_workers,
69: l_batch_size, 0);
70:
71: /* ------ Get rowid ranges ------ */
72: ad_parallel_updates_pkg.get_rowid_range(
73: l_start_rowid,
74: l_end_rowid,
75: l_any_rows_to_process,
76: l_batch_size,

Line 226: ad_parallel_updates_pkg.processed_rowid_range(

222: AND jg.rowid <= l_end_rowid;
223:
224: l_rows_processed := l_rows_processed + SQL%ROWCOUNT;
225:
226: ad_parallel_updates_pkg.processed_rowid_range(
227: l_rows_processed,
228: l_end_rowid);
229:
230: commit;

Line 232: ad_parallel_updates_pkg.get_rowid_range(

228: l_end_rowid);
229:
230: commit;
231:
232: ad_parallel_updates_pkg.get_rowid_range(
233: l_start_rowid,
234: l_end_rowid,
235: l_any_rows_to_process,
236: l_batch_size,

Line 310: ad_parallel_updates_pkg.initialize_rowid_range(

306:
307: BEGIN
308:
309: /* ------ Initialize the rowid ranges ------ */
310: ad_parallel_updates_pkg.initialize_rowid_range(
311: ad_parallel_updates_pkg.ROWID_RANGE,
312: l_table_owner,
313: l_table_name,
314: l_script_name,

Line 311: ad_parallel_updates_pkg.ROWID_RANGE,

307: BEGIN
308:
309: /* ------ Initialize the rowid ranges ------ */
310: ad_parallel_updates_pkg.initialize_rowid_range(
311: ad_parallel_updates_pkg.ROWID_RANGE,
312: l_table_owner,
313: l_table_name,
314: l_script_name,
315: l_worker_id,

Line 320: ad_parallel_updates_pkg.get_rowid_range(

316: l_num_workers,
317: l_batch_size, 0);
318:
319: /* ------ Get rowid ranges ------ */
320: ad_parallel_updates_pkg.get_rowid_range(
321: l_start_rowid,
322: l_end_rowid,
323: l_any_rows_to_process,
324: l_batch_size,

Line 385: ad_parallel_updates_pkg.processed_rowid_range(

381:
382: CLOSE c;
383:
384:
385: ad_parallel_updates_pkg.processed_rowid_range(
386: l_rows_processed,
387: l_end_rowid);
388:
389: commit;

Line 391: ad_parallel_updates_pkg.get_rowid_range(

387: l_end_rowid);
388:
389: commit;
390:
391: ad_parallel_updates_pkg.get_rowid_range(
392: l_start_rowid,
393: l_end_rowid,
394: l_any_rows_to_process,
395: l_batch_size,

Line 478: ad_parallel_updates_pkg.initialize_rowid_range(

474:
475: BEGIN
476:
477: /* ------ Initialize the rowid ranges ------ */
478: ad_parallel_updates_pkg.initialize_rowid_range(
479: ad_parallel_updates_pkg.ROWID_RANGE,
480: l_table_owner,
481: l_table_name,
482: l_script_name,

Line 479: ad_parallel_updates_pkg.ROWID_RANGE,

475: BEGIN
476:
477: /* ------ Initialize the rowid ranges ------ */
478: ad_parallel_updates_pkg.initialize_rowid_range(
479: ad_parallel_updates_pkg.ROWID_RANGE,
480: l_table_owner,
481: l_table_name,
482: l_script_name,
483: l_worker_id,

Line 488: ad_parallel_updates_pkg.get_rowid_range(

484: l_num_workers,
485: l_batch_size, 0);
486:
487: /* ------ Get rowid ranges ------ */
488: ad_parallel_updates_pkg.get_rowid_range(
489: l_start_rowid,
490: l_end_rowid,
491: l_any_rows_to_process,
492: l_batch_size,

Line 559: ad_parallel_updates_pkg.processed_rowid_range(

555:
556: CLOSE c;
557:
558:
559: ad_parallel_updates_pkg.processed_rowid_range(
560: l_rows_processed,
561: l_end_rowid);
562:
563: commit;

Line 565: ad_parallel_updates_pkg.get_rowid_range(

561: l_end_rowid);
562:
563: commit;
564:
565: ad_parallel_updates_pkg.get_rowid_range(
566: l_start_rowid,
567: l_end_rowid,
568: l_any_rows_to_process,
569: l_batch_size,

Line 651: ad_parallel_updates_pkg.initialize_rowid_range(

647:
648: BEGIN
649:
650: /* ------ Initialize the rowid ranges ------ */
651: ad_parallel_updates_pkg.initialize_rowid_range(
652: ad_parallel_updates_pkg.ROWID_RANGE,
653: l_table_owner,
654: l_table_name,
655: l_script_name,

Line 652: ad_parallel_updates_pkg.ROWID_RANGE,

648: BEGIN
649:
650: /* ------ Initialize the rowid ranges ------ */
651: ad_parallel_updates_pkg.initialize_rowid_range(
652: ad_parallel_updates_pkg.ROWID_RANGE,
653: l_table_owner,
654: l_table_name,
655: l_script_name,
656: l_worker_id,

Line 661: ad_parallel_updates_pkg.get_rowid_range(

657: l_num_workers,
658: l_batch_size, 0);
659:
660: /* ------ Get rowid ranges ------ */
661: ad_parallel_updates_pkg.get_rowid_range(
662: l_start_rowid,
663: l_end_rowid,
664: l_any_rows_to_process,
665: l_batch_size,

Line 726: ad_parallel_updates_pkg.processed_rowid_range(

722:
723: CLOSE c;
724:
725:
726: ad_parallel_updates_pkg.processed_rowid_range(
727: l_rows_processed,
728: l_end_rowid);
729:
730: commit;

Line 732: ad_parallel_updates_pkg.get_rowid_range(

728: l_end_rowid);
729:
730: commit;
731:
732: ad_parallel_updates_pkg.get_rowid_range(
733: l_start_rowid,
734: l_end_rowid,
735: l_any_rows_to_process,
736: l_batch_size,

Line 818: ad_parallel_updates_pkg.initialize_rowid_range(

814:
815: BEGIN
816:
817: /* ------ Initialize the rowid ranges ------ */
818: ad_parallel_updates_pkg.initialize_rowid_range(
819: ad_parallel_updates_pkg.ROWID_RANGE,
820: l_table_owner,
821: l_table_name,
822: l_script_name,

Line 819: ad_parallel_updates_pkg.ROWID_RANGE,

815: BEGIN
816:
817: /* ------ Initialize the rowid ranges ------ */
818: ad_parallel_updates_pkg.initialize_rowid_range(
819: ad_parallel_updates_pkg.ROWID_RANGE,
820: l_table_owner,
821: l_table_name,
822: l_script_name,
823: l_worker_id,

Line 828: ad_parallel_updates_pkg.get_rowid_range(

824: l_num_workers,
825: l_batch_size, 0);
826:
827: /* ------ Get rowid ranges ------ */
828: ad_parallel_updates_pkg.get_rowid_range(
829: l_start_rowid,
830: l_end_rowid,
831: l_any_rows_to_process,
832: l_batch_size,

Line 897: ad_parallel_updates_pkg.processed_rowid_range(

893:
894: CLOSE c;
895:
896:
897: ad_parallel_updates_pkg.processed_rowid_range(
898: l_rows_processed,
899: l_end_rowid);
900:
901: commit;

Line 903: ad_parallel_updates_pkg.get_rowid_range(

899: l_end_rowid);
900:
901: commit;
902:
903: ad_parallel_updates_pkg.get_rowid_range(
904: l_start_rowid,
905: l_end_rowid,
906: l_any_rows_to_process,
907: l_batch_size,

Line 978: ad_parallel_updates_pkg.initialize_rowid_range(

974:
975: BEGIN
976:
977: /* ------ Initialize the rowid ranges ------ */
978: ad_parallel_updates_pkg.initialize_rowid_range(
979: ad_parallel_updates_pkg.ROWID_RANGE,
980: l_table_owner,
981: l_table_name,
982: l_script_name,

Line 979: ad_parallel_updates_pkg.ROWID_RANGE,

975: BEGIN
976:
977: /* ------ Initialize the rowid ranges ------ */
978: ad_parallel_updates_pkg.initialize_rowid_range(
979: ad_parallel_updates_pkg.ROWID_RANGE,
980: l_table_owner,
981: l_table_name,
982: l_script_name,
983: l_worker_id,

Line 988: ad_parallel_updates_pkg.get_rowid_range(

984: l_num_workers,
985: l_batch_size, 0);
986:
987: /* ------ Get rowid ranges ------ */
988: ad_parallel_updates_pkg.get_rowid_range(
989: l_start_rowid,
990: l_end_rowid,
991: l_any_rows_to_process,
992: l_batch_size,

Line 1035: ad_parallel_updates_pkg.processed_rowid_range(

1031:
1032: CLOSE c;
1033:
1034:
1035: ad_parallel_updates_pkg.processed_rowid_range(
1036: l_rows_processed,
1037: l_end_rowid);
1038:
1039: commit;

Line 1041: ad_parallel_updates_pkg.get_rowid_range(

1037: l_end_rowid);
1038:
1039: commit;
1040:
1041: ad_parallel_updates_pkg.get_rowid_range(
1042: l_start_rowid,
1043: l_end_rowid,
1044: l_any_rows_to_process,
1045: l_batch_size,

Line 1109: ad_parallel_updates_pkg.initialize_rowid_range(

1105:
1106: BEGIN
1107:
1108: /* ------ Initialize the rowid ranges ------ */
1109: ad_parallel_updates_pkg.initialize_rowid_range(
1110: ad_parallel_updates_pkg.ROWID_RANGE,
1111: l_table_owner,
1112: l_table_name,
1113: l_script_name,

Line 1110: ad_parallel_updates_pkg.ROWID_RANGE,

1106: BEGIN
1107:
1108: /* ------ Initialize the rowid ranges ------ */
1109: ad_parallel_updates_pkg.initialize_rowid_range(
1110: ad_parallel_updates_pkg.ROWID_RANGE,
1111: l_table_owner,
1112: l_table_name,
1113: l_script_name,
1114: l_worker_id,

Line 1119: ad_parallel_updates_pkg.get_rowid_range(

1115: l_num_workers,
1116: l_batch_size, 0);
1117:
1118: /* ------ Get rowid ranges ------ */
1119: ad_parallel_updates_pkg.get_rowid_range(
1120: l_start_rowid,
1121: l_end_rowid,
1122: l_any_rows_to_process,
1123: l_batch_size,

Line 1169: ad_parallel_updates_pkg.processed_rowid_range(

1165:
1166: CLOSE c;
1167:
1168:
1169: ad_parallel_updates_pkg.processed_rowid_range(
1170: l_rows_processed,
1171: l_end_rowid);
1172:
1173: commit;

Line 1175: ad_parallel_updates_pkg.get_rowid_range(

1171: l_end_rowid);
1172:
1173: commit;
1174:
1175: ad_parallel_updates_pkg.get_rowid_range(
1176: l_start_rowid,
1177: l_end_rowid,
1178: l_any_rows_to_process,
1179: l_batch_size,

Line 1219: ad_parallel_updates_pkg.initialize_rowid_range(

1215: g_bulk_fetch_rows NUMBER := 10000;
1216: l_last_fetch BOOLEAN := FALSE;
1217: BEGIN
1218: /* ------ Initialize the rowid ranges ------ */
1219: ad_parallel_updates_pkg.initialize_rowid_range(
1220: ad_parallel_updates_pkg.ROWID_RANGE,
1221: l_table_owner,
1222: l_table_name,
1223: l_script_name,

Line 1220: ad_parallel_updates_pkg.ROWID_RANGE,

1216: l_last_fetch BOOLEAN := FALSE;
1217: BEGIN
1218: /* ------ Initialize the rowid ranges ------ */
1219: ad_parallel_updates_pkg.initialize_rowid_range(
1220: ad_parallel_updates_pkg.ROWID_RANGE,
1221: l_table_owner,
1222: l_table_name,
1223: l_script_name,
1224: l_worker_id,

Line 1229: ad_parallel_updates_pkg.get_rowid_range(

1225: l_num_workers,
1226: l_batch_size, 0);
1227:
1228: /* ------ Get rowid ranges ------ */
1229: ad_parallel_updates_pkg.get_rowid_range(
1230: l_start_rowid,
1231: l_end_rowid,
1232: l_any_rows_to_process,
1233: l_batch_size,

Line 1293: ad_parallel_updates_pkg.processed_rowid_range(

1289:
1290:
1291: l_rows_processed := l_rows_processed + SQL%ROWCOUNT;
1292:
1293: ad_parallel_updates_pkg.processed_rowid_range(
1294: l_rows_processed,
1295: l_end_rowid);
1296:
1297: commit;

Line 1299: ad_parallel_updates_pkg.get_rowid_range(

1295: l_end_rowid);
1296:
1297: commit;
1298:
1299: ad_parallel_updates_pkg.get_rowid_range(
1300: l_start_rowid,
1301: l_end_rowid,
1302: l_any_rows_to_process,
1303: l_batch_size,