DBA Data[Home] [Help]

APPS.OTA_DATA_UPGRADER_UTIL dependencies on AD_PARALLEL_UPDATES_PKG

Line 98: ad_parallel_updates_pkg.initialize_rowid_range(

94: l_any_rows_to_process boolean;
95: l_plsql varchar2(2000);
96: begin
97:
98: ad_parallel_updates_pkg.initialize_rowid_range(
99: ad_parallel_updates_pkg.ROWID_RANGE,
100: p_table_owner,
101: p_table_name,
102: p_update_name,

Line 99: ad_parallel_updates_pkg.ROWID_RANGE,

95: l_plsql varchar2(2000);
96: begin
97:
98: ad_parallel_updates_pkg.initialize_rowid_range(
99: ad_parallel_updates_pkg.ROWID_RANGE,
100: p_table_owner,
101: p_table_name,
102: p_update_name,
103: p_this_worker_num,

Line 107: ad_parallel_updates_pkg.get_rowid_range(

103: p_this_worker_num,
104: p_total_num_workers,
105: p_batch_size, 0);
106:
107: ad_parallel_updates_pkg.get_rowid_range(
108: l_start_rowid,
109: l_end_rowid,
110: l_any_rows_to_process,
111: p_batch_size,

Line 134: ad_parallel_updates_pkg.processed_rowid_range(

130: to_number(p_upgrade_id) ;
131:
132: -----------------------------------------------------
133:
134: ad_parallel_updates_pkg.processed_rowid_range(
135: l_rows_processed,
136: l_end_rowid);
137:
138: --

Line 147: ad_parallel_updates_pkg.get_rowid_range(

143:
144: --
145: -- get new range of rowids
146: --
147: ad_parallel_updates_pkg.get_rowid_range(
148: l_start_rowid,
149: l_end_rowid,
150: l_any_rows_to_process,
151: p_batch_size,

Line 226: ad_parallel_updates_pkg.initialize_id_range(

222: else
223: /*
224: ** Prepare the upgrade....
225: */
226: ad_parallel_updates_pkg.initialize_id_range(
227: ad_parallel_updates_pkg.ID_RANGE,
228: p_table_owner,
229: p_table_name,
230: p_update_name,

Line 227: ad_parallel_updates_pkg.ID_RANGE,

223: /*
224: ** Prepare the upgrade....
225: */
226: ad_parallel_updates_pkg.initialize_id_range(
227: ad_parallel_updates_pkg.ID_RANGE,
228: p_table_owner,
229: p_table_name,
230: p_update_name,
231: p_pkid_column,

Line 240: ad_parallel_updates_pkg.get_id_range(

236: );
237: /*
238: ** Get the initial range of IDs to process.
239: */
240: ad_parallel_updates_pkg.get_id_range(
241: l_start_pkid,
242: l_end_pkid,
243: l_any_rows_to_process,
244: p_batch_size,

Line 283: ad_parallel_updates_pkg.processed_id_range(

279: end if;
280: /*
281: ** Mark the batch of IDs as processed...
282: */
283: ad_parallel_updates_pkg.processed_id_range(
284: l_rows_processed,
285: l_end_pkid);
286:
287: /*

Line 295: ad_parallel_updates_pkg.get_id_range(

291:
292: /*
293: ** Get the next range of IDs
294: */
295: ad_parallel_updates_pkg.get_id_range(
296: l_start_pkid,
297: l_end_pkid,
298: l_any_rows_to_process,
299: p_batch_size,