APPS.CS_CHG_LINENO_UPG_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 40

 l_update_name         VARCHAR2(30) := 'csxelnub.120.1';

Line: 51

  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;

Line: 94

  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
           );

Line: 113

   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);

Line: 146

     UPDATE CS_ESTIMATE_DETAILS
     SET line_number = v_row_number(i)
     WHERE rowid = v_row_id(i);

Line: 150

    AD_PARALLEL_UPDATES_PKG.processed_id_range(
                                l_rows_processed,
                                l_end_id);

Line: 156

    AD_PARALLEL_UPDATES_PKG.get_id_range(
                      l_start_id,
                      l_end_id,
                      l_any_rows_to_process,
                      x_batch_size,
                      FALSE);