DBA Data[Home] [Help]

APPS.IGS_ST_GVTSEMLOAD_CA_PKG dependencies on IGS_GE_NUMBER

Line 124: new_references.CI_SEQUENCE_NUMBER:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;

120: ELSIF upper(Column_name) = 'CAL_TYPE' THEN
121: new_references.CAL_TYPE:= COLUMN_VALUE ;
122:
123: ELSIF upper(Column_name) = 'CI_SEQUENCE_NUMBER' THEN
124: new_references.CI_SEQUENCE_NUMBER:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
125:
126: ELSIF upper(Column_name) = 'SUBMISSION_YR' THEN
127: new_references.SUBMISSION_YR:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
128:

Line 127: new_references.SUBMISSION_YR:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;

123: ELSIF upper(Column_name) = 'CI_SEQUENCE_NUMBER' THEN
124: new_references.CI_SEQUENCE_NUMBER:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
125:
126: ELSIF upper(Column_name) = 'SUBMISSION_YR' THEN
127: new_references.SUBMISSION_YR:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
128:
129: END IF ;
130:
131: IF upper(Column_name) = 'CAL_TYPE' OR COLUMN_NAME IS NULL THEN