151: BEGIN
152: IF column_name is null then
153: NULL;
154: ELSIF UPPER(column_name) = 'YEAR_OFFSET' Then
155: new_references.year_offset :=igs_ge_number.to_num(column_value);
156: Elsif UPPER(column_name) = 'WEEK_OFFSET' Then
157: NEW_REFERENCES.week_offset:= igs_ge_number.to_num(column_value);
158: Elsif UPPER(column_name) = 'DAY_OFFSET' Then
159: NEW_REFERENCES.day_offset := igs_ge_number.to_num(column_value);
153: NULL;
154: ELSIF UPPER(column_name) = 'YEAR_OFFSET' Then
155: new_references.year_offset :=igs_ge_number.to_num(column_value);
156: Elsif UPPER(column_name) = 'WEEK_OFFSET' Then
157: NEW_REFERENCES.week_offset:= igs_ge_number.to_num(column_value);
158: Elsif UPPER(column_name) = 'DAY_OFFSET' Then
159: NEW_REFERENCES.day_offset := igs_ge_number.to_num(column_value);
160: Elsif UPPER(column_name) = 'MONTH_OFFSET' Then
161: NEW_REFERENCES.month_offset:= igs_ge_number.to_num(column_value);
155: new_references.year_offset :=igs_ge_number.to_num(column_value);
156: Elsif UPPER(column_name) = 'WEEK_OFFSET' Then
157: NEW_REFERENCES.week_offset:= igs_ge_number.to_num(column_value);
158: Elsif UPPER(column_name) = 'DAY_OFFSET' Then
159: NEW_REFERENCES.day_offset := igs_ge_number.to_num(column_value);
160: Elsif UPPER(column_name) = 'MONTH_OFFSET' Then
161: NEW_REFERENCES.month_offset:= igs_ge_number.to_num(column_value);
162: Elsif UPPER(column_name) = 'DT_ALIAS' Then
163: NEW_REFERENCES.dt_alias:= column_value;
157: NEW_REFERENCES.week_offset:= igs_ge_number.to_num(column_value);
158: Elsif UPPER(column_name) = 'DAY_OFFSET' Then
159: NEW_REFERENCES.day_offset := igs_ge_number.to_num(column_value);
160: Elsif UPPER(column_name) = 'MONTH_OFFSET' Then
161: NEW_REFERENCES.month_offset:= igs_ge_number.to_num(column_value);
162: Elsif UPPER(column_name) = 'DT_ALIAS' Then
163: NEW_REFERENCES.dt_alias:= column_value;
164: Elsif UPPER(column_name) = 'CAL_TYPE' Then
165: NEW_REFERENCES.cal_type:= column_value;