APPS.CS_CONTPNTS_AUDIT_UPD_CON_PRG SQL Statements

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

Line: 36

   p_update_date   IN  VARCHAR2     -- <4507823/>
  ) IS

  l_product               VARCHAR2(30) := 'CS';

Line: 45

  l_update_name           VARCHAR2(30) := 'csxacptb.pls';  -- l_update_name will be appended with sysdate, do not make this longer than 18 characters

Line: 79

    ad_parallel_updates_pkg.initialize_rowid_range(
           ad_parallel_updates_pkg.ROWID_RANGE,
           l_table_owner,
           l_table_name,
           l_update_name || p_update_date, -- to ensure it is rerunnable
           x_worker_id,
           x_num_workers,
           x_batch_size, 0);

Line: 88

    ad_parallel_updates_pkg.get_rowid_range(
           l_start_rowid,
           l_end_rowid,
           l_any_rows_to_process,
           x_batch_size,
           TRUE);

Line: 96

      INSERT INTO cs_hz_sr_contact_pnts_audit
      (sr_contact_point_audit_id,
       sr_contact_point_id,
       incident_id,
       party_id,
       old_party_id,
       primary_flag,
       old_primary_flag,
       contact_type,
       old_contact_type,
       contact_point_type,
       old_contact_point_type,
       contact_point_id,              --<4510186>
       old_contact_point_id,          --
       contact_point_modified_by,
       contact_point_modified_on,
       object_version_number,
       party_role_code,
       old_party_role_code,
       start_date_active,
       old_start_date_active,
       end_date_active,
       old_end_date_active,
       creation_date,
       created_by,
       last_update_date,
       last_updated_by,
       last_update_login
      )
        SELECT /*+ rowid(cp) */
               cs_hz_sr_cont_pnts_audit_s.NEXTVAL,
               sr_contact_point_id,
               incident_id,
               party_id,
               NULL,
               primary_flag,
               NULL,
               contact_type,
               NULL,
               contact_point_type,
               NULL,
               contact_point_id,
               NULL,
               last_updated_by,
               last_update_date,
               object_version_number,
               party_role_code,
               NULL,
               start_date_active,
               NULL,
               end_date_active,
               NULL,
               SYSDATE,
               -1,
               SYSDATE,
               -1,
               -1
        FROM   cs_hz_sr_contact_points cp
        WHERE  rowid BETWEEN l_start_rowid AND l_end_rowid
        AND    creation_date > l_cutoff_date                    -- <4507823/>
        AND    NOT EXISTS (
               SELECT 'x'
               FROM cs_hz_sr_contact_pnts_audit a
               WHERE a.sr_contact_point_id = cp.sr_contact_point_id);

Line: 163

      ad_parallel_updates_pkg.processed_rowid_range(
         l_rows_processed,
         l_end_rowid);

Line: 175

      ad_parallel_updates_pkg.get_rowid_range(
         l_start_rowid,
         l_end_rowid,
         l_any_rows_to_process,
         x_batch_size,
         FALSE);