203: PROCEDURE drop_submit (person_id IN NUMBER,
204: program_cd IN VARCHAR2,
205: p_uoo_ids IN VARCHAR2) ;
206:
207: FUNCTION get_sua_fin_mark(p_person_id IN igs_en_su_attempt_all.person_id%TYPE,
208: p_course_cd IN igs_en_su_attempt_all.course_Cd%TYPE,
209: p_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE) RETURN NUMBER ;
210:
211: FUNCTION get_sua_fin_grade(p_person_id IN igs_en_su_attempt_all.person_id%TYPE,
204: program_cd IN VARCHAR2,
205: p_uoo_ids IN VARCHAR2) ;
206:
207: FUNCTION get_sua_fin_mark(p_person_id IN igs_en_su_attempt_all.person_id%TYPE,
208: p_course_cd IN igs_en_su_attempt_all.course_Cd%TYPE,
209: p_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE) RETURN NUMBER ;
210:
211: FUNCTION get_sua_fin_grade(p_person_id IN igs_en_su_attempt_all.person_id%TYPE,
212: p_course_cd IN igs_en_su_attempt_all.course_Cd%TYPE,
205: p_uoo_ids IN VARCHAR2) ;
206:
207: FUNCTION get_sua_fin_mark(p_person_id IN igs_en_su_attempt_all.person_id%TYPE,
208: p_course_cd IN igs_en_su_attempt_all.course_Cd%TYPE,
209: p_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE) RETURN NUMBER ;
210:
211: FUNCTION get_sua_fin_grade(p_person_id IN igs_en_su_attempt_all.person_id%TYPE,
212: p_course_cd IN igs_en_su_attempt_all.course_Cd%TYPE,
213: p_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE) RETURN VARCHAR2;
207: FUNCTION get_sua_fin_mark(p_person_id IN igs_en_su_attempt_all.person_id%TYPE,
208: p_course_cd IN igs_en_su_attempt_all.course_Cd%TYPE,
209: p_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE) RETURN NUMBER ;
210:
211: FUNCTION get_sua_fin_grade(p_person_id IN igs_en_su_attempt_all.person_id%TYPE,
212: p_course_cd IN igs_en_su_attempt_all.course_Cd%TYPE,
213: p_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE) RETURN VARCHAR2;
214:
215: END IGS_EN_PLAN_UTILS;
208: p_course_cd IN igs_en_su_attempt_all.course_Cd%TYPE,
209: p_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE) RETURN NUMBER ;
210:
211: FUNCTION get_sua_fin_grade(p_person_id IN igs_en_su_attempt_all.person_id%TYPE,
212: p_course_cd IN igs_en_su_attempt_all.course_Cd%TYPE,
213: p_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE) RETURN VARCHAR2;
214:
215: END IGS_EN_PLAN_UTILS;
209: p_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE) RETURN NUMBER ;
210:
211: FUNCTION get_sua_fin_grade(p_person_id IN igs_en_su_attempt_all.person_id%TYPE,
212: p_course_cd IN igs_en_su_attempt_all.course_Cd%TYPE,
213: p_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE) RETURN VARCHAR2;
214:
215: END IGS_EN_PLAN_UTILS;