APPS.IGS_DA_PURGE_RQST_PKG SQL Statements

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

Line: 12

  PROCEDURE delete_row (
    p_batch_id          IN NUMBER,
    x_status            OUT NOCOPY VARCHAR2
  ) IS
  /*****************************************************************************
    Created By:         Deepankar Dey
    Date Created By:    12-11-2001
    Purpose:
      This procedure is to be called from the SS screens, to delete the records
      corresponding to the
    Known limitations,enhancements,remarks:
    Change History
    Who        When        What
  *****************************************************************************/
    CURSOR cur_req_stdnts IS
      SELECT   ROWID
      FROM     igs_da_req_stdnts
      WHERE    batch_id = p_batch_id ;

Line: 31

      SELECT   ROWID
      FROM     igs_da_req_ftrs
      WHERE    batch_id = p_batch_id ;

Line: 35

      SELECT   ROWID
      FROM     igs_da_req_wif
      WHERE    batch_id = p_batch_id ;

Line: 39

      SELECT   ROWID
      FROM     igs_da_rqst
      WHERE    batch_id = p_batch_id ;

Line: 57

        igs_da_req_stdnts_pkg.delete_row (
          x_rowid                =>   l_req_stdnts.ROWID
        );

Line: 63

        igs_da_req_ftrs_pkg.delete_row (
          x_rowid                => l_req_ftrs.ROWID,
          x_return_status        => l_return_status,
          x_msg_data             => l_msg_data,
          x_msg_count            => l_msg_count
        );

Line: 72

        igs_da_req_wif_pkg.delete_row (
          x_rowid                => l_req_wifs.ROWID,
          x_return_status        => l_return_status,
          x_msg_data             => l_msg_data,
          x_msg_count            => l_msg_count
        );

Line: 81

        igs_da_rqst_pkg.delete_row(
          x_rowid                => l_req_rqst.ROWID,
          x_return_status        => l_return_status,
          x_msg_data             => l_msg_data,
          x_msg_count            => l_msg_count
        );

Line: 122

  END delete_row;

Line: 151

     SELECT distinct dar.ROWID, dar.batch_id, dar.request_type_id,
       flv.meaning request_status_meaning,
       pbv1.full_name requestor_full_name,
       dar.creation_date,
       dar.requestor_id
  FROM igs_da_rqst dar,
       igs_pe_person_base_v pbv1,
       igs_da_cnfg dac,
       igs_da_cnfg_req_typ dacr,
       fnd_lookup_values_vl flv
 WHERE dacr.request_type_id = dar.request_type_id
   AND dacr.purgable_ind = 'Y'
   AND flv.lookup_type = 'IGS_DA_RQST_STATUS'
   AND flv.lookup_code = dar.request_status
   AND dar.batch_id = NVL(p_c_request_number, dar.batch_id)
   AND dar.requestor_id =  NVL(p_requestor_id, dar.requestor_id)
   AND dac.responsibility_name = NVL(p_responsibility,dac.responsibility_name)
   AND dar.request_status = NVL(p_request_status,dar.request_status)
   AND dacr.request_type =NVL(p_request_type,dacr.request_type)
   AND ((p_c_start_date IS NULL)OR ( p_c_start_date IS NOT NULL AND dar.creation_date >= fnd_date.canonical_to_date (p_c_start_date)))
   AND ((p_c_end_date IS NULL)OR ( p_c_end_date IS NOT NULL AND dar.creation_date <= fnd_date.canonical_to_date (p_c_end_date)))
   AND dar.requestor_id = pbv1.person_id
   AND dac.request_type_id(+) = dar.request_type_id ;

Line: 178

      SELECT   dacr.request_name,
               dacr.request_type_meaning,
               dacr.request_mode_meaning
      FROM     igs_da_cnfg_req_typ_v dacr
      WHERE    dacr.request_type_id = cp_request_type_id;

Line: 185

      SELECT   ROWID
      FROM     igs_da_req_stdnts
      WHERE    batch_id = cp_batch_id ;

Line: 190

      SELECT   ROWID
      FROM     igs_da_req_ftrs
      WHERE    batch_id = cp_batch_id ;

Line: 195

      SELECT   ROWID
      FROM     igs_da_req_wif
      WHERE    batch_id = cp_batch_id ;

Line: 213

    SAVEPOINT s_before_delete;

Line: 266

          igs_da_req_stdnts_pkg.delete_row (
            x_rowid =>   l_cur_req_stdnts.ROWID
          );

Line: 275

          igs_da_req_ftrs_pkg.delete_row (
            x_rowid                => l_cur_req_ftrs.ROWID,
            x_return_status        => l_return_status,
            x_msg_data             => l_msg_data,
            x_msg_count            => l_msg_count
          );

Line: 287

          igs_da_req_wif_pkg.delete_row (
            x_rowid                => l_cur_req_wifs.ROWID,
            x_return_status        => l_return_status,
            x_msg_data             => l_msg_data,
            x_msg_count            => l_msg_count
          );

Line: 338

        igs_da_rqst_pkg.delete_row(
          x_rowid                => l_cur_request.rowid,
          x_return_status        => l_return_status,
          x_msg_data             => l_msg_data,
          x_msg_count            => l_msg_count
        );

Line: 355

      ROLLBACK TO s_before_delete;

Line: 357

      ROLLBACK TO s_before_delete;