APPS.IGS_EN_VAL_SUT dependencies on IGS_EN_STDNT_PS_ATT

Line 93: -- * Cannot insert if transferred ?to? IGS_PS_UNIT maps to IGS_EN_STDNT_PS_ATT

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'.
96: -- IGS_GE_NOTE: all statuses with the exception of unconfirmed are handled in
97: -- ENRP_VAL_SCT_TO validation.

Line 121: FROM IGS_EN_STDNT_PS_ATT sca

117: sua.course_cd = p_transfer_course_cd AND
118: sua.uoo_id = p_uoo_id ;
119: CURSOR c_sca IS
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;

Line 132: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%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
136: OPEN c_sua_from;