3: --
4: -- Get year of program for student unit set attempt
5: --
6: FUNCTION get_sua_yop (
7: p_person_id IN igs_en_su_attempt.person_id%TYPE,
8: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
9: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
10: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE
11: ) RETURN VARCHAR2;
4: -- Get year of program for student unit set attempt
5: --
6: FUNCTION get_sua_yop (
7: p_person_id IN igs_en_su_attempt.person_id%TYPE,
8: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
9: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
10: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE
11: ) RETURN VARCHAR2;
12: --
5: --
6: FUNCTION get_sua_yop (
7: p_person_id IN igs_en_su_attempt.person_id%TYPE,
8: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
9: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
10: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE
11: ) RETURN VARCHAR2;
12: --
13: -- Validate the records before inserting into base table and call the table handlers
6: FUNCTION get_sua_yop (
7: p_person_id IN igs_en_su_attempt.person_id%TYPE,
8: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
9: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
10: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE
11: ) RETURN VARCHAR2;
12: --
13: -- Validate the records before inserting into base table and call the table handlers
14: --