120: App_Exception.Raise_Exception;
121:
122: END student_cohort;
123:
124: FUNCTION repeat_grades_exist( p_person_id IGS_AS_SU_STMPTOUT_ALL.person_id%TYPE,
125: p_unit_cd IGS_AS_SU_STMPTOUT_ALL.unit_cd%TYPE,
126: p_course_cd IGS_AS_SU_STMPTOUT_ALL.course_cd%TYPE,
127: p_cal_type IGS_AS_SU_STMPTOUT_ALL.cal_type%TYPE,
128: p_ci_sequence_number IGS_AS_SU_STMPTOUT_ALL.ci_sequence_number%TYPE,
121:
122: END student_cohort;
123:
124: FUNCTION repeat_grades_exist( p_person_id IGS_AS_SU_STMPTOUT_ALL.person_id%TYPE,
125: p_unit_cd IGS_AS_SU_STMPTOUT_ALL.unit_cd%TYPE,
126: p_course_cd IGS_AS_SU_STMPTOUT_ALL.course_cd%TYPE,
127: p_cal_type IGS_AS_SU_STMPTOUT_ALL.cal_type%TYPE,
128: p_ci_sequence_number IGS_AS_SU_STMPTOUT_ALL.ci_sequence_number%TYPE,
129: -- anilk, 22-Apr-2003, Bug# 2829262
122: END student_cohort;
123:
124: FUNCTION repeat_grades_exist( p_person_id IGS_AS_SU_STMPTOUT_ALL.person_id%TYPE,
125: p_unit_cd IGS_AS_SU_STMPTOUT_ALL.unit_cd%TYPE,
126: p_course_cd IGS_AS_SU_STMPTOUT_ALL.course_cd%TYPE,
127: p_cal_type IGS_AS_SU_STMPTOUT_ALL.cal_type%TYPE,
128: p_ci_sequence_number IGS_AS_SU_STMPTOUT_ALL.ci_sequence_number%TYPE,
129: -- anilk, 22-Apr-2003, Bug# 2829262
130: p_uoo_id IGS_AS_SU_STMPTOUT_ALL.uoo_id%TYPE) RETURN VARCHAR2 IS
123:
124: FUNCTION repeat_grades_exist( p_person_id IGS_AS_SU_STMPTOUT_ALL.person_id%TYPE,
125: p_unit_cd IGS_AS_SU_STMPTOUT_ALL.unit_cd%TYPE,
126: p_course_cd IGS_AS_SU_STMPTOUT_ALL.course_cd%TYPE,
127: p_cal_type IGS_AS_SU_STMPTOUT_ALL.cal_type%TYPE,
128: p_ci_sequence_number IGS_AS_SU_STMPTOUT_ALL.ci_sequence_number%TYPE,
129: -- anilk, 22-Apr-2003, Bug# 2829262
130: p_uoo_id IGS_AS_SU_STMPTOUT_ALL.uoo_id%TYPE) RETURN VARCHAR2 IS
131: BEGIN -- repeat_grades_exist
124: FUNCTION repeat_grades_exist( p_person_id IGS_AS_SU_STMPTOUT_ALL.person_id%TYPE,
125: p_unit_cd IGS_AS_SU_STMPTOUT_ALL.unit_cd%TYPE,
126: p_course_cd IGS_AS_SU_STMPTOUT_ALL.course_cd%TYPE,
127: p_cal_type IGS_AS_SU_STMPTOUT_ALL.cal_type%TYPE,
128: p_ci_sequence_number IGS_AS_SU_STMPTOUT_ALL.ci_sequence_number%TYPE,
129: -- anilk, 22-Apr-2003, Bug# 2829262
130: p_uoo_id IGS_AS_SU_STMPTOUT_ALL.uoo_id%TYPE) RETURN VARCHAR2 IS
131: BEGIN -- repeat_grades_exist
132: -- This function checks whether a particular student outcome record
126: p_course_cd IGS_AS_SU_STMPTOUT_ALL.course_cd%TYPE,
127: p_cal_type IGS_AS_SU_STMPTOUT_ALL.cal_type%TYPE,
128: p_ci_sequence_number IGS_AS_SU_STMPTOUT_ALL.ci_sequence_number%TYPE,
129: -- anilk, 22-Apr-2003, Bug# 2829262
130: p_uoo_id IGS_AS_SU_STMPTOUT_ALL.uoo_id%TYPE) RETURN VARCHAR2 IS
131: BEGIN -- repeat_grades_exist
132: -- This function checks whether a particular student outcome record
133: -- has any other records created by repeat process
134: