APPS.IGR_GEN_002 SQL Statements

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

Line: 32

      SELECT MAX(batch_id)
      FROM   igs_ad_imp_batch_det
      WHERE  created_by = FND_GLOBAL.USER_ID;

Line: 38

      SELECT batch_id
      FROM   igs_ad_interface_ctl
      WHERE  batch_id = cp_batch_id;

Line: 77

      SELECT igs_ad_interface_batch_id_s.NEXTVAL
      FROM dual;

Line: 86

        SELECT SUBSTR(user_name,1,20)
        FROM fnd_user
        WHERE USER_ID = FND_GLOBAL.USER_ID;

Line: 110

         INSERT INTO igs_ad_imp_batch_det (
                  batch_id,
                  batch_desc,
                  created_by,
                  creation_date,
                  last_updated_by,
                  last_update_date,
                  last_update_login,
                  request_id,
                  program_application_id,
                  program_update_date,
                  program_id)
         VALUES ( l_imp_batch_id,
                  l_batch_desc,
                  fnd_global.user_id,
                  SYSDATE,
                  fnd_global.user_id,
                  SYSDATE,
                  NULL,
                  NULL,
                  NULL,
                  NULL,
                  NULL
                );

Line: 140

  PROCEDURE Delete_Inquiry_Dtls (
      p_interface_id IN NUMBER )
  IS
  /*************************************************************
  Created By : Navin Sinha
  Date Created By : Tuesday, August 12, 2003
  Purpose : Admin_Quick_Entry, Enh#: 2885789
            If user clicks on Delete, the same record will be deleted from interface tables.
  Know limitations, enhancements or remarks
  Change History
  Who             When            What
  (reverse chronological order - newest change first)
  ***************************************************************/

  BEGIN
    -- All The records in the below interface tables
    -- which correspond to that Inquiry should be deleted .
    DELETE igs_ad_interface_all WHERE interface_id = p_interface_id;

Line: 158

    DELETE igs_ad_addr_int_all WHERE interface_id = p_interface_id;

Line: 160

    DELETE igr_i_lines_int WHERE interface_inq_appl_id IN
      (SELECT interface_inq_appl_id FROM igr_i_appl_int WHERE interface_id = p_interface_id);

Line: 162

    DELETE igr_i_appl_int WHERE interface_id = p_interface_id;

Line: 164

    DELETE igs_ad_acadhis_int_all WHERE interface_id = p_interface_id;

Line: 165

    DELETE igs_ad_contacts_int_all WHERE interface_id = p_interface_id;

Line: 166

    DELETE igs_pe_race_int WHERE interface_id = p_interface_id;

Line: 167

    DELETE igs_ad_stat_int WHERE interface_id = p_interface_id;

Line: 174

  END Delete_Inquiry_Dtls;