APPS.IGS_OR_INST_ADDR_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: 38

      SELECT   rowid
      FROM     IGS_OR_INST_ADDR
      WHERE    institution_cd = x_institution_cd
      AND      addr_type = x_addr_type
      AND      start_dt = x_start_dt
      FOR UPDATE NOWAIT;

Line: 70

      SELECT   rowid
      FROM     IGS_OR_INST_ADDR
      WHERE addr_type = x_addr_type ;

Line: 101

      SELECT   rowid
      FROM     IGS_OR_INST_ADDR
      WHERE    institution_cd = x_institution_cd ;

Line: 122

      SELECT   rowid
      FROM     IGS_OR_INST_ADDR
      WHERE    postal_code = x_postcode ;