DBA Data[Home] [Help]

APPS.IGS_RE_CAND_SEO_CLS_PKG dependencies on IGS_GE_NUMBER

Line 121: new_references.PERCENTAGE := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;

117: NULL;
118: ELSIF upper(Column_name) = 'SEO_CLASS_CD' THEN
119: new_references.SEO_CLASS_CD := COLUMN_VALUE ;
120: ELSIF upper(Column_name) = 'PERCENTAGE' THEN
121: new_references.PERCENTAGE := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
122: ELSIF upper(Column_name) = 'CA_SEQUENCE_NUMBER' THEN
123: new_references.CA_SEQUENCE_NUMBER := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
124: END IF;
125:

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

119: new_references.SEO_CLASS_CD := COLUMN_VALUE ;
120: ELSIF upper(Column_name) = 'PERCENTAGE' THEN
121: new_references.PERCENTAGE := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
122: ELSIF upper(Column_name) = 'CA_SEQUENCE_NUMBER' THEN
123: new_references.CA_SEQUENCE_NUMBER := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
124: END IF;
125:
126: IF upper(column_name) = 'SEO_CLASS_CD' OR COLUMN_NAME IS NULL THEN
127: IF new_references.SEO_CLASS_CD <> upper(new_references.SEO_CLASS_CD) then