221: BEGIN
222: IF column_name is null THEN
223: NULL;
224: ELSIF upper(column_name) = 'SUBMISSION_YR' THEN
225: new_references.submission_yr := IGS_GE_NUMBER.to_num(column_value);
226: ELSIF upper(column_name) = 'SUBMISSION_NUMBER' THEN
227: new_references.submission_number := IGS_GE_NUMBER.to_num(column_value);
228: END IF;
229:
223: NULL;
224: ELSIF upper(column_name) = 'SUBMISSION_YR' THEN
225: new_references.submission_yr := IGS_GE_NUMBER.to_num(column_value);
226: ELSIF upper(column_name) = 'SUBMISSION_NUMBER' THEN
227: new_references.submission_number := IGS_GE_NUMBER.to_num(column_value);
228: END IF;
229:
230: IF upper(column_name) = 'SUBMISSION_YR' OR column_name IS NULL THEN
231: IF new_references.submission_yr < 0 OR new_references.submission_yr > 9999 THEN