APPS.IGS_OR_INSTITUTION_PKG SQL Statements

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

Line: 6

  Purpose    : to remove the procedures like insert_row, update_row,lock_row,
               before DML, check_parent_existence,check_child_existence,
               check_constraints, set_column_values, after_dml for
               TCA related work as this would now be taken care through TCA
               table handlers.
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

  (reverse chronological order - newest change first)
  ***************************************************************/


  l_rowid VARCHAR2(25);

Line: 26

      SELECT   ROW_ID
      FROM     IGS_OR_INSTITUTION
      WHERE    institution_cd = x_institution_cd;

Line: 46

     SELECT   ROW_ID
      FROM     IGS_OR_INSTITUTION
      WHERE    GOVT_INSTITUTION_CD = x_govt_institution_cd ;

Line: 67

      SELECT   ROW_ID
      FROM     IGS_OR_INSTITUTION
      WHERE    institution_status = x_institution_status ;

Line: 103

      SELECT   ROW_ID
      FROM     igs_or_institution
      WHERE    institution_type = x_institution_type ;

Line: 143

      SELECT   ROW_ID
      FROM     igs_or_institution
      WHERE    inst_control_type = x_inst_control_type ;