108:
109: IF (column_name IS NULL) THEN
110: NULL;
111: ELSIF (UPPER(column_name) = 'REFERENCE_NUMBER') THEN
112: new_references.reference_number := igs_ge_number.to_num (column_value);
113: ELSIF (UPPER(column_name) = 'SEQUENCE_NUMBER') THEN
114: new_references.sequence_number := igs_ge_number.to_num (column_value);
115: ELSIF (UPPER(column_name) = 'CI_SEQUENCE_NUMBER') THEN
116: new_references.ci_sequence_number := igs_ge_number.to_num (column_value);
110: NULL;
111: ELSIF (UPPER(column_name) = 'REFERENCE_NUMBER') THEN
112: new_references.reference_number := igs_ge_number.to_num (column_value);
113: ELSIF (UPPER(column_name) = 'SEQUENCE_NUMBER') THEN
114: new_references.sequence_number := igs_ge_number.to_num (column_value);
115: ELSIF (UPPER(column_name) = 'CI_SEQUENCE_NUMBER') THEN
116: new_references.ci_sequence_number := igs_ge_number.to_num (column_value);
117: END IF;
118:
112: new_references.reference_number := igs_ge_number.to_num (column_value);
113: ELSIF (UPPER(column_name) = 'SEQUENCE_NUMBER') THEN
114: new_references.sequence_number := igs_ge_number.to_num (column_value);
115: ELSIF (UPPER(column_name) = 'CI_SEQUENCE_NUMBER') THEN
116: new_references.ci_sequence_number := igs_ge_number.to_num (column_value);
117: END IF;
118:
119: IF (UPPER(column_name) = 'REFERENCE_NUMBER' OR column_name IS NULL) THEN
120: IF NOT (new_references.reference_number BETWEEN 1