146: new_references.course_cd := column_value;
147: ELSIF upper(Column_name) = 'TEACH_CAL_TYPE' then
148: new_references.teach_cal_type := column_value;
149: ELSIF upper(Column_name) = 'POS_SEQUENCE_NUMBER' then
150: new_references.pos_sequence_number := IGS_GE_NUMBER.TO_NUM(column_value);
151: ELSIF upper(Column_name) = 'ACAD_PERIOD_NUM' then
152: new_references.acad_period_num := IGS_GE_NUMBER.TO_NUM(column_value);
153: ELSIF upper(Column_name) = 'SEQUENCE_NUMBER' then
154: new_references.sequence_number :=IGS_GE_NUMBER.TO_NUM(column_value);
148: new_references.teach_cal_type := column_value;
149: ELSIF upper(Column_name) = 'POS_SEQUENCE_NUMBER' then
150: new_references.pos_sequence_number := IGS_GE_NUMBER.TO_NUM(column_value);
151: ELSIF upper(Column_name) = 'ACAD_PERIOD_NUM' then
152: new_references.acad_period_num := IGS_GE_NUMBER.TO_NUM(column_value);
153: ELSIF upper(Column_name) = 'SEQUENCE_NUMBER' then
154: new_references.sequence_number :=IGS_GE_NUMBER.TO_NUM(column_value);
155: ELSIF upper(Column_name) = 'VERSION_NUMBER' then
156: new_references.version_number :=IGS_GE_NUMBER.TO_NUM(column_value);
150: new_references.pos_sequence_number := IGS_GE_NUMBER.TO_NUM(column_value);
151: ELSIF upper(Column_name) = 'ACAD_PERIOD_NUM' then
152: new_references.acad_period_num := IGS_GE_NUMBER.TO_NUM(column_value);
153: ELSIF upper(Column_name) = 'SEQUENCE_NUMBER' then
154: new_references.sequence_number :=IGS_GE_NUMBER.TO_NUM(column_value);
155: ELSIF upper(Column_name) = 'VERSION_NUMBER' then
156: new_references.version_number :=IGS_GE_NUMBER.TO_NUM(column_value);
157: END IF;
158:
152: new_references.acad_period_num := IGS_GE_NUMBER.TO_NUM(column_value);
153: ELSIF upper(Column_name) = 'SEQUENCE_NUMBER' then
154: new_references.sequence_number :=IGS_GE_NUMBER.TO_NUM(column_value);
155: ELSIF upper(Column_name) = 'VERSION_NUMBER' then
156: new_references.version_number :=IGS_GE_NUMBER.TO_NUM(column_value);
157: END IF;
158:
159: IF upper(column_name) = 'CAL_TYPE' OR
160: column_name is null Then