APPS.IGS_PR_VAL_SCA dependencies on IGS_AS_SU_SETATMPT

Line 18: -- * Cannot be set if any IGS_AS_SU_SETATMPT records

14: gv_other_detail VARCHAR2(255);
15: BEGIN -- prgp_val_susa_cmplt
16: -- Validate IGS_EN_STDNT_PS_ATT.course_rqrmnt_complete_ind
17: -- and the IGS_PS_STDNT_APV_ALT.rqrmnts_complete_ind
18: -- * Cannot be set if any IGS_AS_SU_SETATMPT records
19: -- are incomplete or unended for the IGS_PS_COURSE attempt.
20: DECLARE
21: v_susa_rec_found VARCHAR2(1);
22: CURSOR c_susa IS

Line 24: FROM IGS_AS_SU_SETATMPT susa

20: DECLARE
21: v_susa_rec_found VARCHAR2(1);
22: CURSOR c_susa IS
23: SELECT 'x'
24: FROM IGS_AS_SU_SETATMPT susa
25: WHERE susa.person_id = p_person_id AND
26: susa.course_cd = p_course_cd AND
27: susa.student_confirmed_ind = 'Y' AND
28: susa.rqrmnts_complete_ind = 'N' AND

Line 37: -- Check if any IGS_AS_SU_SETATMPT records are incomplete

33: IF p_person_id IS NULL OR
34: p_course_cd IS NULL THEN
35: RETURN TRUE;
36: END IF;
37: -- Check if any IGS_AS_SU_SETATMPT records are incomplete
38: -- or unended.
39: OPEN c_susa;
40: FETCH c_susa INTO v_susa_rec_found;
41: IF c_susa%FOUND THEN