DBA Data[Home] [Help]

APPS.IGS_AS_EXM_INS_SPVSR_PKG dependencies on IGS_GE_NUMBER

Line 749: new_references.DAI_SEQUENCE_NUMBER := IGS_GE_NUMBER.TO_NUM(column_value);

745: new_references.EXAM_SUPERVISOR_TYPE := column_value;
746: ELSIF upper(Column_name) = 'VENUE_CD' then
747: new_references.VENUE_CD := column_value;
748: ELSIF upper(Column_name) = 'DAI_SEQUENCE_NUMBER' then
749: new_references.DAI_SEQUENCE_NUMBER := IGS_GE_NUMBER.TO_NUM(column_value);
750: ELSIF upper(Column_name) = 'EXAM_CI_SEQUENCE_NUMBER' then
751: new_references.EXAM_CI_SEQUENCE_NUMBER := IGS_GE_NUMBER.TO_NUM(column_value);
752: ELSIF upper(Column_name) = 'ESE_ID' then
753: new_references.ESE_ID := IGS_GE_NUMBER.TO_NUM(column_value);

Line 751: new_references.EXAM_CI_SEQUENCE_NUMBER := IGS_GE_NUMBER.TO_NUM(column_value);

747: new_references.VENUE_CD := column_value;
748: ELSIF upper(Column_name) = 'DAI_SEQUENCE_NUMBER' then
749: new_references.DAI_SEQUENCE_NUMBER := IGS_GE_NUMBER.TO_NUM(column_value);
750: ELSIF upper(Column_name) = 'EXAM_CI_SEQUENCE_NUMBER' then
751: new_references.EXAM_CI_SEQUENCE_NUMBER := IGS_GE_NUMBER.TO_NUM(column_value);
752: ELSIF upper(Column_name) = 'ESE_ID' then
753: new_references.ESE_ID := IGS_GE_NUMBER.TO_NUM(column_value);
754: end if;
755: IF upper(column_name) = 'DT_ALIAS' OR

Line 753: new_references.ESE_ID := IGS_GE_NUMBER.TO_NUM(column_value);

749: new_references.DAI_SEQUENCE_NUMBER := IGS_GE_NUMBER.TO_NUM(column_value);
750: ELSIF upper(Column_name) = 'EXAM_CI_SEQUENCE_NUMBER' then
751: new_references.EXAM_CI_SEQUENCE_NUMBER := IGS_GE_NUMBER.TO_NUM(column_value);
752: ELSIF upper(Column_name) = 'ESE_ID' then
753: new_references.ESE_ID := IGS_GE_NUMBER.TO_NUM(column_value);
754: end if;
755: IF upper(column_name) = 'DT_ALIAS' OR
756: column_name is null Then
757: IF new_references.DT_ALIAS <> UPPER(new_references.DT_ALIAS) Then