121: p_reference_type IN VARCHAR2)
122: RETURN BOOLEAN AS
123: BEGIN
124: DECLARE
125: l_mandatory_flag IGS_GE_REF_CD_TYPE.mandatory_flag%TYPE;
126: CURSOR c_mandatory_flag IS
127: SELECT mandatory_flag
128: FROM IGS_GE_REF_CD_TYPE
129: WHERE reference_cd_type = p_reference_type;
124: DECLARE
125: l_mandatory_flag IGS_GE_REF_CD_TYPE.mandatory_flag%TYPE;
126: CURSOR c_mandatory_flag IS
127: SELECT mandatory_flag
128: FROM IGS_GE_REF_CD_TYPE
129: WHERE reference_cd_type = p_reference_type;
130: BEGIN
131: OPEN c_mandatory_flag;
132: FETCH c_mandatory_flag INTO l_mandatory_flag;