1079: new_references.milestone_status := Column_Value;
1080: ELSIF upper(Column_Name) = 'MILESTONE_TYPE' then
1081: new_references.milestone_type := Column_Value;
1082: ELSIF upper(Column_Name) = 'CA_SEQUENCE_NUMBER' then
1083: new_references.ca_sequence_number := IGS_GE_NUMBER.to_num(Column_Value);
1084: ELSIF upper(Column_Name) = 'SEQUENCE_NUMBER' then
1085: new_references.sequence_number := IGS_GE_NUMBER.to_num(Column_Value);
1086: ELSIF upper(Column_Name) = 'PRECED_SEQUENCE_NUMBER' then
1087: new_references.preced_sequence_number := IGS_GE_NUMBER.to_num(Column_Value);
1081: new_references.milestone_type := Column_Value;
1082: ELSIF upper(Column_Name) = 'CA_SEQUENCE_NUMBER' then
1083: new_references.ca_sequence_number := IGS_GE_NUMBER.to_num(Column_Value);
1084: ELSIF upper(Column_Name) = 'SEQUENCE_NUMBER' then
1085: new_references.sequence_number := IGS_GE_NUMBER.to_num(Column_Value);
1086: ELSIF upper(Column_Name) = 'PRECED_SEQUENCE_NUMBER' then
1087: new_references.preced_sequence_number := IGS_GE_NUMBER.to_num(Column_Value);
1088: ELSIF upper(Column_Name) = 'OVRD_NTFCTN_REMINDER_DAYS' then
1089: new_references.ovrd_ntfctn_reminder_days := IGS_GE_NUMBER.to_num(Column_Value);
1083: new_references.ca_sequence_number := IGS_GE_NUMBER.to_num(Column_Value);
1084: ELSIF upper(Column_Name) = 'SEQUENCE_NUMBER' then
1085: new_references.sequence_number := IGS_GE_NUMBER.to_num(Column_Value);
1086: ELSIF upper(Column_Name) = 'PRECED_SEQUENCE_NUMBER' then
1087: new_references.preced_sequence_number := IGS_GE_NUMBER.to_num(Column_Value);
1088: ELSIF upper(Column_Name) = 'OVRD_NTFCTN_REMINDER_DAYS' then
1089: new_references.ovrd_ntfctn_reminder_days := IGS_GE_NUMBER.to_num(Column_Value);
1090: ELSIF upper(Column_Name) = 'OVRD_NTFCTN_RE_REMINDER_DAYS' then
1091: new_references.ovrd_ntfctn_re_reminder_days := IGS_GE_NUMBER.to_num(Column_Value);
1085: new_references.sequence_number := IGS_GE_NUMBER.to_num(Column_Value);
1086: ELSIF upper(Column_Name) = 'PRECED_SEQUENCE_NUMBER' then
1087: new_references.preced_sequence_number := IGS_GE_NUMBER.to_num(Column_Value);
1088: ELSIF upper(Column_Name) = 'OVRD_NTFCTN_REMINDER_DAYS' then
1089: new_references.ovrd_ntfctn_reminder_days := IGS_GE_NUMBER.to_num(Column_Value);
1090: ELSIF upper(Column_Name) = 'OVRD_NTFCTN_RE_REMINDER_DAYS' then
1091: new_references.ovrd_ntfctn_re_reminder_days := IGS_GE_NUMBER.to_num(Column_Value);
1092: ELSIF upper(Column_Name) = 'OVRD_NTFCTN_IMMINENT_DAYS' then
1093: new_references.ovrd_ntfctn_imminent_days := IGS_GE_NUMBER.to_num(Column_Value);
1087: new_references.preced_sequence_number := IGS_GE_NUMBER.to_num(Column_Value);
1088: ELSIF upper(Column_Name) = 'OVRD_NTFCTN_REMINDER_DAYS' then
1089: new_references.ovrd_ntfctn_reminder_days := IGS_GE_NUMBER.to_num(Column_Value);
1090: ELSIF upper(Column_Name) = 'OVRD_NTFCTN_RE_REMINDER_DAYS' then
1091: new_references.ovrd_ntfctn_re_reminder_days := IGS_GE_NUMBER.to_num(Column_Value);
1092: ELSIF upper(Column_Name) = 'OVRD_NTFCTN_IMMINENT_DAYS' then
1093: new_references.ovrd_ntfctn_imminent_days := IGS_GE_NUMBER.to_num(Column_Value);
1094: END IF;
1095:
1089: new_references.ovrd_ntfctn_reminder_days := IGS_GE_NUMBER.to_num(Column_Value);
1090: ELSIF upper(Column_Name) = 'OVRD_NTFCTN_RE_REMINDER_DAYS' then
1091: new_references.ovrd_ntfctn_re_reminder_days := IGS_GE_NUMBER.to_num(Column_Value);
1092: ELSIF upper(Column_Name) = 'OVRD_NTFCTN_IMMINENT_DAYS' then
1093: new_references.ovrd_ntfctn_imminent_days := IGS_GE_NUMBER.to_num(Column_Value);
1094: END IF;
1095:
1096: IF upper(column_name) = 'MILESTONE_STATUS' OR
1097: column_name is NULL THEN