95: -- used to filter out students whose awards are not conferred
96: -- between the correct award conferral dates.
97: FUNCTION validate_award_conferral_dates (p_std_awd_cmp_ind IN igs_en_spa_awd_aim.complete_ind%TYPE,
98: p_std_awd_conf_dt IN igs_en_spa_awd_aim.conferral_date%TYPE,
99: p_awd_conf_start_dt OUT NOCOPY igs_he_submsn_awd.award_start_date%TYPE,
100: p_awd_conf_end_dt OUT NOCOPY igs_he_submsn_awd.award_end_date%TYPE)
101: RETURN BOOLEAN
102: IS
103:
96: -- between the correct award conferral dates.
97: FUNCTION validate_award_conferral_dates (p_std_awd_cmp_ind IN igs_en_spa_awd_aim.complete_ind%TYPE,
98: p_std_awd_conf_dt IN igs_en_spa_awd_aim.conferral_date%TYPE,
99: p_awd_conf_start_dt OUT NOCOPY igs_he_submsn_awd.award_start_date%TYPE,
100: p_awd_conf_end_dt OUT NOCOPY igs_he_submsn_awd.award_end_date%TYPE)
101: RETURN BOOLEAN
102: IS
103:
104: -- Only to be run if prog type award conferral dates exist for submission
109: WHERE course_cd = g_en_stdnt_ps_att.course_cd
110: AND version_number = g_en_stdnt_ps_att.version_number;
111:
112: l_prog_type igs_ps_ver_all.course_type%TYPE;
113: l_awd_conf_start_dt igs_he_submsn_awd.award_start_date%TYPE;
114: l_awd_conf_end_dt igs_he_submsn_awd.award_end_date%TYPE;
115: l_valid BOOLEAN;
116:
117: BEGIN
110: AND version_number = g_en_stdnt_ps_att.version_number;
111:
112: l_prog_type igs_ps_ver_all.course_type%TYPE;
113: l_awd_conf_start_dt igs_he_submsn_awd.award_start_date%TYPE;
114: l_awd_conf_end_dt igs_he_submsn_awd.award_end_date%TYPE;
115: l_valid BOOLEAN;
116:
117: BEGIN
118: