DBA Data[Home] [Help]

APPS.PAY_SLA_UPDATE_PKG dependencies on AD_PARALLEL_UPDATES_PKG

Line 456: ad_parallel_updates_pkg.initialize_id_range(

452: Also note that the table pay_patch_status is a PAY table */
453: /*l_table_owner:='HR'; Commented out for bug 12343825*/
454:
455:
456: ad_parallel_updates_pkg.initialize_id_range(
457: X_update_type=>ad_parallel_updates_pkg.ID_RANGE,
458: X_owner=>l_table_owner,
459: X_table=>l_table_name,
460: X_script=>l_update_name,

Line 457: X_update_type=>ad_parallel_updates_pkg.ID_RANGE,

453: /*l_table_owner:='HR'; Commented out for bug 12343825*/
454:
455:
456: ad_parallel_updates_pkg.initialize_id_range(
457: X_update_type=>ad_parallel_updates_pkg.ID_RANGE,
458: X_owner=>l_table_owner,
459: X_table=>l_table_name,
460: X_script=>l_update_name,
461: X_ID_column=>l_id_column,

Line 468: ad_parallel_updates_pkg.get_id_range(

464: X_batch_size=>X_batch_size,
465: X_debug_level=>0);
466:
467:
468: ad_parallel_updates_pkg.get_id_range(
469: l_start_id,
470: l_end_id,
471: l_any_rows_to_process,
472: X_batch_size,

Line 506: ad_parallel_updates_pkg.processed_id_range(

502: l_rows_processed := X_batch_size;
503:
504: l_stmt_num :=40;
505:
506: ad_parallel_updates_pkg.processed_id_range(
507: l_rows_processed,
508: l_end_id);
509:
510: commit;

Line 513: ad_parallel_updates_pkg.get_id_range(

509:
510: commit;
511:
512: l_stmt_num :=50;
513: ad_parallel_updates_pkg.get_id_range(
514: l_start_id,
515: l_end_id,
516: l_any_rows_to_process,
517: X_batch_size,