DBA Data[Home] [Help]

APPS.IGS_AD_INTERFACE_PKG dependencies on IGS_PE_PERS_IMP_001

Line 219: IF new_references.sex IS NOT NULL AND NOT (igs_pe_pers_imp_001.validate_lookup_type_code

215:
216: -- The following code checks for check constraints on the Columns.
217: IF Upper(Column_Name) = 'SEX' OR
218: Column_Name IS NULL THEN
219: IF new_references.sex IS NOT NULL AND NOT (igs_pe_pers_imp_001.validate_lookup_type_code
220: ('HZ_GENDER', UPPER(new_references.sex),222)) THEN
221: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
222: IGS_GE_MSG_STACK.ADD;
223: App_Exception.Raise_Exception;