DBA Data[Home] [Help]

APPS.IGS_AD_AUS_SEC_EDU_PKG dependencies on IGS_GE_NUMBER

Line 162: new_references.sequence_number := igs_ge_number.to_num(column_value);

158: Begin
159: IF column_name is null then
160: NULL;
161: ELSIF upper(Column_name) = 'SEQUENCE_NUMBER' Then
162: new_references.sequence_number := igs_ge_number.to_num(column_value);
163: ELSIF upper(Column_name) = 'RESULT_OBTAINED_YR' Then
164: new_references.result_obtained_yr := igs_ge_number.to_num(column_value);
165: ELSIF upper(Column_name) = 'STATE_CD' Then
166: new_references.state_cd := column_value;

Line 164: new_references.result_obtained_yr := igs_ge_number.to_num(column_value);

160: NULL;
161: ELSIF upper(Column_name) = 'SEQUENCE_NUMBER' Then
162: new_references.sequence_number := igs_ge_number.to_num(column_value);
163: ELSIF upper(Column_name) = 'RESULT_OBTAINED_YR' Then
164: new_references.result_obtained_yr := igs_ge_number.to_num(column_value);
165: ELSIF upper(Column_name) = 'STATE_CD' Then
166: new_references.state_cd := column_value;
167: ELSIF upper(Column_name) = 'AUS_SCNDRY_EDU_ASS_TYPE' Then
168: new_references.aus_scndry_edu_ass_type := column_value;

Line 172: new_references.score := igs_ge_number.to_num(column_value);

168: new_references.aus_scndry_edu_ass_type := column_value;
169: ELSIF upper(Column_name) = 'SECONDARY_SCHOOL_CD' Then
170: new_references.secondary_school_cd := column_value;
171: ELSIF upper(Column_name) = 'SCORE' Then
172: new_references.score := igs_ge_number.to_num(column_value);
173: ELSIF upper(Column_name) = 'CANDIDATE_NUMBER' Then
174: new_references.candidate_number := igs_ge_number.to_num(column_value);
175: END IF;
176: IF ((UPPER (column_name) = 'SEQUENCE_NUMBER') OR (column_name IS NULL)) THEN

Line 174: new_references.candidate_number := igs_ge_number.to_num(column_value);

170: new_references.secondary_school_cd := column_value;
171: ELSIF upper(Column_name) = 'SCORE' Then
172: new_references.score := igs_ge_number.to_num(column_value);
173: ELSIF upper(Column_name) = 'CANDIDATE_NUMBER' Then
174: new_references.candidate_number := igs_ge_number.to_num(column_value);
175: END IF;
176: IF ((UPPER (column_name) = 'SEQUENCE_NUMBER') OR (column_name IS NULL)) THEN
177: IF ((new_references.sequence_number < 1) OR (new_references.sequence_number > 9999999999)) THEN
178: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');