DBA Data[Home] [Help]

APPS.IGS_AS_GEN_008 dependencies on IGS_AS_SU_STMPTOUT_ALL

Line 124: FUNCTION repeat_grades_exist( p_person_id IGS_AS_SU_STMPTOUT_ALL.person_id%TYPE,

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,

Line 125: p_unit_cd IGS_AS_SU_STMPTOUT_ALL.unit_cd%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

Line 126: p_course_cd IGS_AS_SU_STMPTOUT_ALL.course_cd%TYPE,

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

Line 127: p_cal_type IGS_AS_SU_STMPTOUT_ALL.cal_type%TYPE,

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

Line 128: p_ci_sequence_number IGS_AS_SU_STMPTOUT_ALL.ci_sequence_number%TYPE,

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

Line 130: p_uoo_id IGS_AS_SU_STMPTOUT_ALL.uoo_id%TYPE) RETURN VARCHAR2 IS

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: