DBA Data[Home] [Help]

APPS.IGS_AS_GEN_002 dependencies on IGS_AS_UNITASS_ITEM_ALL

Line 172: p_uai_exam_cal_type igs_as_unitass_item_all.exam_cal_type%TYPE,

168: app_exception.raise_exception;
169: END assp_get_dflt_grade;
170:
171: FUNCTION assp_get_exam_view (
172: p_uai_exam_cal_type igs_as_unitass_item_all.exam_cal_type%TYPE,
173: p_uai_exam_ci_seq igs_as_unitass_item_all.exam_ci_sequence_number%TYPE,
174: p_ueciv_exam_cal_type igs_as_unitass_item_all.exam_cal_type%TYPE,
175: p_ueciv_exam_ci_seq igs_as_unitass_item_all.exam_ci_sequence_number%TYPE,
176: p_sua_person_id igs_en_su_attempt_all.person_id%TYPE,

Line 173: p_uai_exam_ci_seq igs_as_unitass_item_all.exam_ci_sequence_number%TYPE,

169: END assp_get_dflt_grade;
170:
171: FUNCTION assp_get_exam_view (
172: p_uai_exam_cal_type igs_as_unitass_item_all.exam_cal_type%TYPE,
173: p_uai_exam_ci_seq igs_as_unitass_item_all.exam_ci_sequence_number%TYPE,
174: p_ueciv_exam_cal_type igs_as_unitass_item_all.exam_cal_type%TYPE,
175: p_ueciv_exam_ci_seq igs_as_unitass_item_all.exam_ci_sequence_number%TYPE,
176: p_sua_person_id igs_en_su_attempt_all.person_id%TYPE,
177: p_sua_course_cd igs_en_su_attempt_all.course_cd%TYPE,

Line 174: p_ueciv_exam_cal_type igs_as_unitass_item_all.exam_cal_type%TYPE,

170:
171: FUNCTION assp_get_exam_view (
172: p_uai_exam_cal_type igs_as_unitass_item_all.exam_cal_type%TYPE,
173: p_uai_exam_ci_seq igs_as_unitass_item_all.exam_ci_sequence_number%TYPE,
174: p_ueciv_exam_cal_type igs_as_unitass_item_all.exam_cal_type%TYPE,
175: p_ueciv_exam_ci_seq igs_as_unitass_item_all.exam_ci_sequence_number%TYPE,
176: p_sua_person_id igs_en_su_attempt_all.person_id%TYPE,
177: p_sua_course_cd igs_en_su_attempt_all.course_cd%TYPE,
178: p_sua_unit_cd igs_en_su_attempt_all.unit_cd%TYPE,

Line 175: p_ueciv_exam_ci_seq igs_as_unitass_item_all.exam_ci_sequence_number%TYPE,

171: FUNCTION assp_get_exam_view (
172: p_uai_exam_cal_type igs_as_unitass_item_all.exam_cal_type%TYPE,
173: p_uai_exam_ci_seq igs_as_unitass_item_all.exam_ci_sequence_number%TYPE,
174: p_ueciv_exam_cal_type igs_as_unitass_item_all.exam_cal_type%TYPE,
175: p_ueciv_exam_ci_seq igs_as_unitass_item_all.exam_ci_sequence_number%TYPE,
176: p_sua_person_id igs_en_su_attempt_all.person_id%TYPE,
177: p_sua_course_cd igs_en_su_attempt_all.course_cd%TYPE,
178: p_sua_unit_cd igs_en_su_attempt_all.unit_cd%TYPE,
179: p_sua_version_number igs_en_su_attempt_all.version_number%TYPE,

Line 186: p_ueciv_ass_id igs_as_unitass_item_all.ass_id%TYPE

182: p_sua_unit_attempt_status igs_en_su_attempt_all.unit_attempt_status%TYPE,
183: p_sua_location_cd igs_en_su_attempt_all.location_cd%TYPE,
184: p_ucl_unit_mode igs_as_unit_class_all.unit_mode%TYPE,
185: p_sua_unit_class igs_en_su_attempt_all.unit_class%TYPE,
186: p_ueciv_ass_id igs_as_unitass_item_all.ass_id%TYPE
187: )
188: RETURN VARCHAR2 IS
189: BEGIN
190: DECLARE