eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PR_VAL_SCAAE dependencies on IGS_EN_STDNT_PS_ATT

Line 18: -- Validate IGS_EN_STDNT_PS_ATT.course_attempt_status when setting the

14: p_message_name OUT NOCOPY VARCHAR2 )
15: RETURN BOOLEAN AS
16: gv_other_detail VARCHAR2(255);
17: BEGIN -- prgp_val_sca_cmplt
18: -- Validate IGS_EN_STDNT_PS_ATT.course_attempt_status when setting the
19: --student_course_attepmt.course_rqrmnt_complete_ind or the
20: --IGS_PS_STDNT_APV_ALT.rqrmnts_complete_ind.
21: -- Cannot be set if course_attempt_status is 'DISCONTIN', 'INTERMIT' or
22: -- 'UNCONFIRM'.

Line 25: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'DISCONTIN';

21: -- Cannot be set if course_attempt_status is 'DISCONTIN', 'INTERMIT' or
22: -- 'UNCONFIRM'.
23: DECLARE
24: cst_discontinued CONSTANT
25: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'DISCONTIN';
26: cst_intermit CONSTANT
27: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INTERMIT';
28: cst_lapsed CONSTANT
29: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'LAPSED';

Line 27: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INTERMIT';

23: DECLARE
24: cst_discontinued CONSTANT
25: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'DISCONTIN';
26: cst_intermit CONSTANT
27: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INTERMIT';
28: cst_lapsed CONSTANT
29: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'LAPSED';
30: v_sca_course_attempt_status
31: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;

Line 29: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'LAPSED';

25: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'DISCONTIN';
26: cst_intermit CONSTANT
27: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INTERMIT';
28: cst_lapsed CONSTANT
29: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'LAPSED';
30: v_sca_course_attempt_status
31: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
32: CURSOR c_sca IS
33: SELECT sca.course_attempt_status

Line 31: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;

27: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INTERMIT';
28: cst_lapsed CONSTANT
29: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'LAPSED';
30: v_sca_course_attempt_status
31: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
32: CURSOR c_sca IS
33: SELECT sca.course_attempt_status
34: FROM IGS_EN_STDNT_PS_ATT sca
35: WHERE sca.person_id = p_person_id And

Line 34: FROM IGS_EN_STDNT_PS_ATT sca

30: v_sca_course_attempt_status
31: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
32: CURSOR c_sca IS
33: SELECT sca.course_attempt_status
34: FROM IGS_EN_STDNT_PS_ATT sca
35: WHERE sca.person_id = p_person_id And
36: sca.course_cd = p_course_cd And
37: sca.course_attempt_status IN (
38: cst_discontinued,