172: NULL;
173: ELSIF upper(Column_name) = 'ATTENDANCE_TYPE' THEN
174: new_references.ATTENDANCE_TYPE := COLUMN_VALUE ;
175: ELSIF upper(Column_name) = 'CA_SEQUENCE_NUMBER' THEN
176: new_references.CA_SEQUENCE_NUMBER := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
177: ELSIF upper(Column_name) = 'SEQUENCE_NUMBER' THEN
178: new_references.SEQUENCE_NUMBER := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
179: ELSIF upper(Column_name) = 'ATTENDANCE_PERCENTAGE' THEN
180: new_references.ATTENDANCE_PERCENTAGE := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
174: new_references.ATTENDANCE_TYPE := COLUMN_VALUE ;
175: ELSIF upper(Column_name) = 'CA_SEQUENCE_NUMBER' THEN
176: new_references.CA_SEQUENCE_NUMBER := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
177: ELSIF upper(Column_name) = 'SEQUENCE_NUMBER' THEN
178: new_references.SEQUENCE_NUMBER := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
179: ELSIF upper(Column_name) = 'ATTENDANCE_PERCENTAGE' THEN
180: new_references.ATTENDANCE_PERCENTAGE := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
181: END IF;
182:
176: new_references.CA_SEQUENCE_NUMBER := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
177: ELSIF upper(Column_name) = 'SEQUENCE_NUMBER' THEN
178: new_references.SEQUENCE_NUMBER := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
179: ELSIF upper(Column_name) = 'ATTENDANCE_PERCENTAGE' THEN
180: new_references.ATTENDANCE_PERCENTAGE := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
181: END IF;
182:
183: IF upper(column_name) = 'ATTENDANCE_TYPE' OR COLUMN_NAME IS NULL THEN
184: IF new_references.ATTENDANCE_TYPE <> upper(new_references.ATTENDANCE_TYPE) then