APPS.IGS_PR_VAL_SCA dependencies on IGS_PS_STDNT_APV_ALT

Line 17: -- and the IGS_PS_STDNT_APV_ALT.rqrmnts_complete_ind

13: RETURN BOOLEAN AS
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);

Line 74: --IGS_PS_STDNT_APV_ALT.rqrmnts_complete_ind.

70: gv_other_detail VARCHAR2(255);
71: BEGIN -- prgp_val_sca_status
72: -- Validate IGS_EN_STDNT_PS_ATT.course_attempt_status when setting the
73: --student_course_attepmt.course_rqrmnt_complete_ind or the
74: --IGS_PS_STDNT_APV_ALT.rqrmnts_complete_ind.
75: --? Cannot be set if course_attempt_status is 'COMPLETED' or 'UNCONFIRM'.
76: --
77: -- Modified 28/01/99 to only test for UNCONFIRM (Greg White).
78: DECLARE

Line 223: -- IGS_PS_STDNT_APV_ALT.rqrmnts_complete_ind.

219: RETURN BOOLEAN AS
220: gv_other_detail VARCHAR2(255);
221: BEGIN -- prgp_val_cmplt_ind
222: -- Validate IGS_EN_STDNT_PS_ATT.course_rqrmnt_complete_ind and the
223: -- IGS_PS_STDNT_APV_ALT.rqrmnts_complete_ind.
224: --* Both cannot be set for the same IGS_PS_COURSE attempt
225: DECLARE
226: cst_course CONSTANT VARCHAR2(11) := 'COURSE';
227: cst_exit_course CONSTANT VARCHAR2(11) := 'EXIT_COURSE';

Line 228: v_scaae_rec IGS_PS_STDNT_APV_ALT.rqrmnts_complete_ind%TYPE;

224: --* Both cannot be set for the same IGS_PS_COURSE attempt
225: DECLARE
226: cst_course CONSTANT VARCHAR2(11) := 'COURSE';
227: cst_exit_course CONSTANT VARCHAR2(11) := 'EXIT_COURSE';
228: v_scaae_rec IGS_PS_STDNT_APV_ALT.rqrmnts_complete_ind%TYPE;
229: v_sca_rec IGS_EN_STDNT_PS_ATT.course_rqrmnt_complete_ind%TYPE;
230: CURSOR c_scaae IS
231: SELECT 'X'
232: FROM IGS_PS_STDNT_APV_ALT scaae

Line 232: FROM IGS_PS_STDNT_APV_ALT scaae

228: v_scaae_rec IGS_PS_STDNT_APV_ALT.rqrmnts_complete_ind%TYPE;
229: v_sca_rec IGS_EN_STDNT_PS_ATT.course_rqrmnt_complete_ind%TYPE;
230: CURSOR c_scaae IS
231: SELECT 'X'
232: FROM IGS_PS_STDNT_APV_ALT scaae
233: WHERE scaae.person_id = p_person_id AND
234: scaae.course_cd = p_course_cd AND
235: scaae.rqrmnts_complete_ind = 'Y';
236: CURSOR c_sca IS