DBA Data[Home] [Help]

APPS.IGS_RE_CDT_HIST_PKG dependencies on IGS_GE_NUMBER

Line 91: new_references.SEQUENCE_NUMBER := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;

87: new_references.GOVT_TYPE_OF_ACTIVITY_CD := COLUMN_VALUE ;
88: ELSIF upper(Column_name) = 'SCA_COURSE_CD' THEN
89: new_references.SCA_COURSE_CD := COLUMN_VALUE ;
90: ELSIF upper(Column_name) = 'SEQUENCE_NUMBER' THEN
91: new_references.SEQUENCE_NUMBER := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
92: ELSIF upper(Column_name) = 'ACAI_SEQUENCE_NUMBER' THEN
93: new_references.ACAI_SEQUENCE_NUMBER := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
94: ELSIF upper(Column_name) = 'ATTENDANCE_PERCENTAGE' THEN
95: new_references.ATTENDANCE_PERCENTAGE := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;

Line 93: new_references.ACAI_SEQUENCE_NUMBER := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;

89: new_references.SCA_COURSE_CD := COLUMN_VALUE ;
90: ELSIF upper(Column_name) = 'SEQUENCE_NUMBER' THEN
91: new_references.SEQUENCE_NUMBER := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
92: ELSIF upper(Column_name) = 'ACAI_SEQUENCE_NUMBER' THEN
93: new_references.ACAI_SEQUENCE_NUMBER := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
94: ELSIF upper(Column_name) = 'ATTENDANCE_PERCENTAGE' THEN
95: new_references.ATTENDANCE_PERCENTAGE := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
96: END IF;
97: IF upper(column_name) = 'ACAI_NOMINATED_COURSE_CD' OR COLUMN_NAME IS NULL THEN

Line 95: new_references.ATTENDANCE_PERCENTAGE := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;

91: new_references.SEQUENCE_NUMBER := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
92: ELSIF upper(Column_name) = 'ACAI_SEQUENCE_NUMBER' THEN
93: new_references.ACAI_SEQUENCE_NUMBER := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
94: ELSIF upper(Column_name) = 'ATTENDANCE_PERCENTAGE' THEN
95: new_references.ATTENDANCE_PERCENTAGE := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
96: END IF;
97: IF upper(column_name) = 'ACAI_NOMINATED_COURSE_CD' OR COLUMN_NAME IS NULL THEN
98: IF new_references.ACAI_NOMINATED_COURSE_CD <> upper(NEW_REFERENCES.ACAI_NOMINATED_COURSE_CD) then
99: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');