DBA Data[Home] [Help]

APPS.IGS_RE_CDT_ATT_HIST_PKG dependencies on IGS_GE_NUMBER

Line 176: new_references.CA_SEQUENCE_NUMBER := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;

172: NULL;
173: ELSIF upper(Column_name) = 'ATTENDANCE_TYPE' THEN
174: new_references.ATTENDANCE_TYPE := COLUMN_VALUE ;
175: ELSIF upper(Column_name) = 'CA_SEQUENCE_NUMBER' THEN
176: new_references.CA_SEQUENCE_NUMBER := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
177: ELSIF upper(Column_name) = 'SEQUENCE_NUMBER' THEN
178: new_references.SEQUENCE_NUMBER := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
179: ELSIF upper(Column_name) = 'ATTENDANCE_PERCENTAGE' THEN
180: new_references.ATTENDANCE_PERCENTAGE := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;

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

174: new_references.ATTENDANCE_TYPE := COLUMN_VALUE ;
175: ELSIF upper(Column_name) = 'CA_SEQUENCE_NUMBER' THEN
176: new_references.CA_SEQUENCE_NUMBER := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
177: ELSIF upper(Column_name) = 'SEQUENCE_NUMBER' THEN
178: new_references.SEQUENCE_NUMBER := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
179: ELSIF upper(Column_name) = 'ATTENDANCE_PERCENTAGE' THEN
180: new_references.ATTENDANCE_PERCENTAGE := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
181: END IF;
182:

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

176: new_references.CA_SEQUENCE_NUMBER := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
177: ELSIF upper(Column_name) = 'SEQUENCE_NUMBER' THEN
178: new_references.SEQUENCE_NUMBER := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
179: ELSIF upper(Column_name) = 'ATTENDANCE_PERCENTAGE' THEN
180: new_references.ATTENDANCE_PERCENTAGE := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
181: END IF;
182:
183: IF upper(column_name) = 'ATTENDANCE_TYPE' OR COLUMN_NAME IS NULL THEN
184: IF new_references.ATTENDANCE_TYPE <> upper(new_references.ATTENDANCE_TYPE) then