[Home] [Help]
97:
98: IF column_name is null then
99: null;
100: ELSIF upper(Column_name)= 'DAY_OFFSET' Then
101: new_references.day_offset := igs_ge_number.to_num(column_value);
102: ELSIF upper(column_name) = 'WEEK_OFFSET' Then
103: new_references.week_offset := igs_ge_number.to_num(column_value);
104: ELSIF upper(Column_name)= 'MONTH_OFFSET' Then
105: new_references.month_offset := igs_ge_number.to_num(column_value);
99: null;
100: ELSIF upper(Column_name)= 'DAY_OFFSET' Then
101: new_references.day_offset := igs_ge_number.to_num(column_value);
102: ELSIF upper(column_name) = 'WEEK_OFFSET' Then
103: new_references.week_offset := igs_ge_number.to_num(column_value);
104: ELSIF upper(Column_name)= 'MONTH_OFFSET' Then
105: new_references.month_offset := igs_ge_number.to_num(column_value);
106: ELSIF upper(Column_name)= 'YEAR_OFFSET' Then
107: new_references.year_offset := igs_ge_number.to_num(column_value);
101: new_references.day_offset := igs_ge_number.to_num(column_value);
102: ELSIF upper(column_name) = 'WEEK_OFFSET' Then
103: new_references.week_offset := igs_ge_number.to_num(column_value);
104: ELSIF upper(Column_name)= 'MONTH_OFFSET' Then
105: new_references.month_offset := igs_ge_number.to_num(column_value);
106: ELSIF upper(Column_name)= 'YEAR_OFFSET' Then
107: new_references.year_offset := igs_ge_number.to_num(column_value);
108: ELSIF upper(column_name) = 'DT_ALIAS' Then
109: new_references.dt_alias := column_value;
103: new_references.week_offset := igs_ge_number.to_num(column_value);
104: ELSIF upper(Column_name)= 'MONTH_OFFSET' Then
105: new_references.month_offset := igs_ge_number.to_num(column_value);
106: ELSIF upper(Column_name)= 'YEAR_OFFSET' Then
107: new_references.year_offset := igs_ge_number.to_num(column_value);
108: ELSIF upper(column_name) = 'DT_ALIAS' Then
109: new_references.dt_alias := column_value;
110: ELSIF upper(column_name) = 'OFFSET_DT_ALIAS' Then
111: new_references.offset_dt_alias := column_value;