DBA Data[Home] [Help]

APPS.IGS_ST_GVT_SPSHT_CTL_PKG dependencies on IGS_GE_NUMBER

Line 225: new_references.submission_yr := IGS_GE_NUMBER.to_num(column_value);

221: BEGIN
222: IF column_name is null THEN
223: NULL;
224: ELSIF upper(column_name) = 'SUBMISSION_YR' THEN
225: new_references.submission_yr := IGS_GE_NUMBER.to_num(column_value);
226: ELSIF upper(column_name) = 'SUBMISSION_NUMBER' THEN
227: new_references.submission_number := IGS_GE_NUMBER.to_num(column_value);
228: END IF;
229:

Line 227: new_references.submission_number := IGS_GE_NUMBER.to_num(column_value);

223: NULL;
224: ELSIF upper(column_name) = 'SUBMISSION_YR' THEN
225: new_references.submission_yr := IGS_GE_NUMBER.to_num(column_value);
226: ELSIF upper(column_name) = 'SUBMISSION_NUMBER' THEN
227: new_references.submission_number := IGS_GE_NUMBER.to_num(column_value);
228: END IF;
229:
230: IF upper(column_name) = 'SUBMISSION_YR' OR column_name IS NULL THEN
231: IF new_references.submission_yr < 0 OR new_references.submission_yr > 9999 THEN