511: new_references.GOVT_TYPE_OF_ACTIVITY_CD := COLUMN_VALUE ;
512: ELSIF upper(Column_name) = 'SCA_COURSE_CD' THEN
513: new_references.SCA_COURSE_CD := COLUMN_VALUE ;
514: ELSIF upper(Column_name) = 'SEQUENCE_NUMBER' THEN
515: new_references.SEQUENCE_NUMBER := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
516: ELSIF upper(Column_name) = 'ACAI_SEQUENCE_NUMBER' THEN
517: new_references.ACAI_SEQUENCE_NUMBER := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
518: ELSIF upper(Column_name) = 'ATTENDANCE_PERCENTAGE' THEN
519: new_references.ATTENDANCE_PERCENTAGE := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
513: new_references.SCA_COURSE_CD := COLUMN_VALUE ;
514: ELSIF upper(Column_name) = 'SEQUENCE_NUMBER' THEN
515: new_references.SEQUENCE_NUMBER := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
516: ELSIF upper(Column_name) = 'ACAI_SEQUENCE_NUMBER' THEN
517: new_references.ACAI_SEQUENCE_NUMBER := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
518: ELSIF upper(Column_name) = 'ATTENDANCE_PERCENTAGE' THEN
519: new_references.ATTENDANCE_PERCENTAGE := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
520: END IF;
521:
515: new_references.SEQUENCE_NUMBER := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
516: ELSIF upper(Column_name) = 'ACAI_SEQUENCE_NUMBER' THEN
517: new_references.ACAI_SEQUENCE_NUMBER := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
518: ELSIF upper(Column_name) = 'ATTENDANCE_PERCENTAGE' THEN
519: new_references.ATTENDANCE_PERCENTAGE := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
520: END IF;
521:
522: IF upper(column_name) = 'ACAI_NOMINATED_COURSE_CD' OR COLUMN_NAME IS NULL THEN
523: IF new_references.ACAI_NOMINATED_COURSE_CD <> upper(NEW_REFERENCES.ACAI_NOMINATED_COURSE_CD) then