APPS.IGS_EN_VAL_SUT dependencies on IGS_EN_SU_ATTEMPT

Line 38: FROM IGS_PS_STDNT_UNT_TRN sut, igs_en_su_attempt sua

34: -- This module validates the delete of IGS_PS_STDNT_UNT_TRN details.
35: DECLARE
36: CURSOR c_sua IS
37: SELECT 'X'
38: FROM IGS_PS_STDNT_UNT_TRN sut, igs_en_su_attempt sua
39: WHERE sut.person_id = p_person_id AND
40: sut.transfer_course_cd = p_course_cd AND
41: sut.uoo_id = p_uoo_id AND
42: sua.person_id = sut.person_id AND

Line 91: -- 'DUPLICATE', ('DISCONTIN' and IGS_EN_SU_ATTEMPT has a result of

87: -------------------------------------------------------------------------------------------
88: -- enrp_val_sut_insert
89: -- This module validates the insert of IGS_PS_STDNT_UNT_TRN details
90: -- * Transferred 'from' IGS_PS_UNIT must have unit_attempt_status 'COMPLETED',
91: -- 'DUPLICATE', ('DISCONTIN' and IGS_EN_SU_ATTEMPT has a result of
92: -- 'FAIL').
93: -- * Cannot insert if transferred ?to? IGS_PS_UNIT maps to IGS_EN_STDNT_PS_ATT
94: -- with course_attempt_status 'UNCONFIRM', 'DISCONTIN', 'LAPSED',
95: -- 'COMPLETED'.

Line 115: FROM IGS_EN_SU_ATTEMPT sua

111: cst_dropped CONSTANT VARCHAR2(10) := 'DROPPED';
112: cst_unconfirm CONSTANT VARCHAR2(10) := 'UNCONFIRM';
113: CURSOR c_sua_from IS
114: SELECT sua.unit_attempt_status
115: FROM IGS_EN_SU_ATTEMPT sua
116: WHERE sua.person_id = p_person_id AND
117: sua.course_cd = p_transfer_course_cd AND
118: sua.uoo_id = p_uoo_id ;
119: CURSOR c_sca IS

Line 124: v_from_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;

120: SELECT sca.course_attempt_status
121: FROM IGS_EN_STDNT_PS_ATT sca
122: WHERE sca.person_id = p_person_id AND
123: sca.course_cd = p_course_cd;
124: v_from_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
125: v_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
126: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
127: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
128: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;

Line 131: v_origin_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;

127: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
128: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
129: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
130: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
131: v_origin_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
132: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
133: BEGIN
134: p_message_name := null;
135: -- Get student unit attempt of transfer 'from' IGS_PS_UNIT