The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_update_name VARCHAR2(30) := 'csxelnub.120.1';
SELECT Row_Id,
Rn
FROM ( SELECT rowid AS Row_Id,
Line_Number,
Row_Number() over (PARTITION BY Incident_Id
ORDER BY Creation_Date asc,
Estimate_Detail_Id ) rn
FROM CS_ESTIMATE_DETAILS
WHERE Incident_id between v_start_incident and v_end_incident )
WHERE nvl(Line_Number,-1) <> Rn;
AD_PARALLEL_UPDATES_PKG.initialize_id_range(
ad_parallel_updates_pkg.ID_RANGE_SCAN_EQUI_ROWSETS, --ID_RANGE
l_table_owner,
l_table_name,
l_update_name,
l_id_column,
x_worker_id,
x_num_workers,
x_batch_size,
0,
' SELECT ed.incident_id id_value
FROM CS_ESTIMATE_DETAILS ed ', --> X_SQL_Stmt
null, --> X_Begin_ID
null --> X_End_ID
);
SELECT unit_id+1 AS unit_id,
MIN(incident_id) AS start_id_value,
MAX(incident_id) AS end_id_value
FROM ( SELECT ed.incident_id,
FLOOR( RANK() OVER (ORDER BY ed.incident_id)/:batchsize ) unit_id
FROM CS_ESTIMATE_DETAILS ed )
GROUP BY unit_id
*/
AD_PARALLEL_UPDATES_PKG.get_id_range(
l_start_id,
l_end_id,
l_any_rows_to_process,
x_batch_size,
TRUE);
UPDATE CS_ESTIMATE_DETAILS
SET line_number = v_row_number(i)
WHERE rowid = v_row_id(i);
AD_PARALLEL_UPDATES_PKG.processed_id_range(
l_rows_processed,
l_end_id);
AD_PARALLEL_UPDATES_PKG.get_id_range(
l_start_id,
l_end_id,
l_any_rows_to_process,
x_batch_size,
FALSE);