APPS.IGS_OR_PRC_CWLK SQL Statements

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

Line: 35

                    Made the alt_id_value UPPER while inserting.
***************************************************************** */
    l_rowid             VARCHAR2(25);

Line: 50

      SELECT *
      FROM   IGS_OR_CWLK_INT
      WHERE  status = cp_stat;

Line: 57

      SELECT *
      FROM   IGS_OR_CWLK_DTL_INT
      WHERE  interface_crosswalk_id   = cp_cwlk_int_id;

Line: 67

        SELECT   rowid
        FROM     igs_or_org_alt_idtyp
        WHERE    org_alternate_id_type = cp_org_alternate_id_type AND
                 CLOSE_IND = cp_close_ind AND
		 inst_flag = cp_inst_flag;

Line: 107

        IGS_OR_CWLK_PKG.Insert_Row(x_rowid            => l_rowid,
                                   x_crosswalk_id     => l_cwlk_id,
                                   x_institution_code => NULL,
                                   x_institution_name => cwlkrec.institution_name);

Line: 147

          IGS_OR_CWLK_DTL_PKG.Insert_Row(x_rowid                 => l_rowid,
                                         x_crosswalk_dtl_id      => l_cwlk_dtl_id,
                                         x_crosswalk_id          => l_cwlk_id,
                                         x_alt_id_type           => cwlkdtlrec.alt_id_type,
                                         x_alt_id_value          => UPPER(cwlkdtlrec.alt_id_value));

Line: 176

      UPDATE IGS_OR_CWLK_INT
      SET    status                 = l_status
      WHERE  interface_crosswalk_id = cwlkrec.interface_crosswalk_id;

Line: 193

    DELETE FROM IGS_OR_CWLK_DTL_INT DTL
    WHERE  EXISTS
          (SELECT 1
	   FROM   IGS_OR_CWLK_INT MSTR
	   WHERE  MSTR.STATUS = '1' AND
	          MSTR.INTERFACE_CROSSWALK_ID = DTL.INTERFACE_CROSSWALK_ID);

Line: 200

    DELETE FROM IGS_OR_CWLK_INT WHERE STATUS = '1';