DBA Data[Home] [Help]

APPS.FND_OAM_DSCRAM_UNITS_PKG dependencies on AD_PARALLEL_UPDATES_PKG

Line 879: AD_PARALLEL_UPDATES_PKG.INITIALIZE_ROWID_RANGE(X_update_type => AD_PARALLEL_UPDATES_PKG.ROWID_RANGE,

875: fnd_oam_debug.log(1, l_ctxt, 'Using owner.table: '||p_object_owner||'.'||p_object_name);
876:
877: --Default the # of workers and batch size from the bundle if they're not defined for the unit.
878: --Values in the bundle are non-null and these fields are required for AD to function in the multi-worker case.
879: AD_PARALLEL_UPDATES_PKG.INITIALIZE_ROWID_RANGE(X_update_type => AD_PARALLEL_UPDATES_PKG.ROWID_RANGE,
880: X_owner => p_object_owner,
881: X_table => p_object_name,
882: X_script => FND_OAM_DSCRAM_UTILS_PKG.MAKE_AD_SCRIPT_KEY(p_unit_id),
883: X_worker_id => FND_OAM_DSCRAM_BUNDLES_PKG.GET_WORKER_ID,

Line 887: X_processed_mode => AD_PARALLEL_UPDATES_PKG.PRESERVE_PROCESSED_UNITS);

883: X_worker_id => FND_OAM_DSCRAM_BUNDLES_PKG.GET_WORKER_ID,
884: X_num_workers => NVL(p_num_workers, FND_OAM_DSCRAM_BUNDLES_PKG.GET_WORKERS_ALLOWED),
885: X_batch_size => NVL(p_batch_size, FND_OAM_DSCRAM_BUNDLES_PKG.GET_BATCH_SIZE),
886: X_debug_level => 0,
887: X_processed_mode => AD_PARALLEL_UPDATES_PKG.PRESERVE_PROCESSED_UNITS);
888: --safety commit
889: COMMIT;
890:
891: fnd_oam_debug.log(1, l_ctxt, 'Finished initialize.');

Line 920: AD_PARALLEL_UPDATES_PKG.GET_ROWID_RANGE(X_start_rowid => x_rowid_lbound,

916: x_return_msg := '';
917:
918: fnd_oam_debug.log(1, l_ctxt, 'Getting next range...');
919:
920: AD_PARALLEL_UPDATES_PKG.GET_ROWID_RANGE(X_start_rowid => x_rowid_lbound,
921: X_end_rowid => x_rowid_ubound,
922: X_any_rows => x_rows_found,
923: X_num_rows => NULL, --unused in 120.2
924: X_restart => FALSE); --also unused in 120.2

Line 956: AD_PARALLEL_UPDATES_pkg.PROCESSED_ROWID_RANGE(X_rows_processed => p_rows_processed,

952: IS
953: BEGIN
954: --Note: the rows_processed here is based on how many rows the DMLs actually interacted with, not the number
955: --in the range. This means it can be zero even for a large range.
956: AD_PARALLEL_UPDATES_pkg.PROCESSED_ROWID_RANGE(X_rows_processed => p_rows_processed,
957: X_last_rowid => p_rowid_ubound);
958: END;
959:
960: --Wrapper to perform range commit autonomously. Used in non-normal modes to roll back the work