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_AD_VAL_ACA dependencies on IGS_PS_STDNT_TRN

Line 13: -- This module validates IGS_PS_STDNT_TRN links to a

9: p_validation_ind IN VARCHAR2 DEFAULT 'N',
10: p_message_name OUT NOCOPY varchar2 )
11: RETURN BOOLEAN IS
12: BEGIN -- enrp_val_sca_trnsfr
13: -- This module validates IGS_PS_STDNT_TRN links to a
14: -- IGS_EN_STDNT_PS_ATT when lifting discontinuation.
15: -- Do not allow lifting of discontinuation if IGS_PS_STDNT_TRN
16: -- exists where
17: -- * IGS_PS_STDNT_TRN details already exist against the course

Line 15: -- Do not allow lifting of discontinuation if IGS_PS_STDNT_TRN

11: RETURN BOOLEAN IS
12: BEGIN -- enrp_val_sca_trnsfr
13: -- This module validates IGS_PS_STDNT_TRN links to a
14: -- IGS_EN_STDNT_PS_ATT when lifting discontinuation.
15: -- Do not allow lifting of discontinuation if IGS_PS_STDNT_TRN
16: -- exists where
17: -- * IGS_PS_STDNT_TRN details already exist against the course
18: -- attempt and the last transfer was not 'to' the course.
19: -- * The transfer_course_cd has IGS_PS_STDNT_TRN links where the

Line 17: -- * IGS_PS_STDNT_TRN details already exist against the course

13: -- This module validates IGS_PS_STDNT_TRN links to a
14: -- IGS_EN_STDNT_PS_ATT when lifting discontinuation.
15: -- Do not allow lifting of discontinuation if IGS_PS_STDNT_TRN
16: -- exists where
17: -- * IGS_PS_STDNT_TRN details already exist against the course
18: -- attempt and the last transfer was not 'to' the course.
19: -- * The transfer_course_cd has IGS_PS_STDNT_TRN links where the
20: -- course transferred to is currently enrolled, inactive, intermitted
21: -- or lapsed.

Line 19: -- * The transfer_course_cd has IGS_PS_STDNT_TRN links where the

15: -- Do not allow lifting of discontinuation if IGS_PS_STDNT_TRN
16: -- exists where
17: -- * IGS_PS_STDNT_TRN details already exist against the course
18: -- attempt and the last transfer was not 'to' the course.
19: -- * The transfer_course_cd has IGS_PS_STDNT_TRN links where the
20: -- course transferred to is currently enrolled, inactive, intermitted
21: -- or lapsed.
22: DECLARE
23: cst_enrolled CONSTANT VARCHAR2(10) := 'ENROLLED';

Line 27: v_trnsfr_crs_cd IGS_PS_STDNT_TRN.transfer_course_cd%TYPE;

23: cst_enrolled CONSTANT VARCHAR2(10) := 'ENROLLED';
24: cst_inactive CONSTANT VARCHAR2(10) := 'INACTIVE';
25: cst_intermit CONSTANT VARCHAR2(10) := 'INTERMIT';
26: cst_lapsed CONSTANT VARCHAR2(10) := 'LAPSED';
27: v_trnsfr_crs_cd IGS_PS_STDNT_TRN.transfer_course_cd%TYPE;
28: v_link_found BOOLEAN DEFAULT FALSE;
29: v_dummy VARCHAR2(1);
30: CURSOR c_sct IS
31: SELECT sct.transfer_course_cd

Line 32: FROM IGS_PS_STDNT_TRN sct

28: v_link_found BOOLEAN DEFAULT FALSE;
29: v_dummy VARCHAR2(1);
30: CURSOR c_sct IS
31: SELECT sct.transfer_course_cd
32: FROM IGS_PS_STDNT_TRN sct
33: WHERE sct.person_id = p_person_id AND
34: (sct.course_cd = p_course_cd OR
35: sct.transfer_course_cd = p_course_cd)
36: ORDER BY transfer_dt desc;

Line 40: IGS_PS_STDNT_TRN sct

36: ORDER BY transfer_dt desc;
37: CURSOR c_sct_sca_course_cd IS
38: SELECT sca.course_cd
39: FROM IGS_EN_STDNT_PS_ATT sca,
40: IGS_PS_STDNT_TRN sct
41: WHERE sct.person_id = p_person_id AND
42: sct.course_cd = p_course_cd AND
43: sca.person_id = sct.person_id AND
44: sca.course_cd = sct.transfer_course_cd;

Line 46: cp_transfer_course_cd IGS_PS_STDNT_TRN.transfer_course_cd%TYPE) IS

42: sct.course_cd = p_course_cd AND
43: sca.person_id = sct.person_id AND
44: sca.course_cd = sct.transfer_course_cd;
45: CURSOR c_sct_sca(
46: cp_transfer_course_cd IGS_PS_STDNT_TRN.transfer_course_cd%TYPE) IS
47: SELECT 'X'
48: FROM IGS_PS_STDNT_TRN sct,
49: IGS_EN_STDNT_PS_ATT sca
50: WHERE sct.person_id = p_person_id AND

Line 48: FROM IGS_PS_STDNT_TRN sct,

44: sca.course_cd = sct.transfer_course_cd;
45: CURSOR c_sct_sca(
46: cp_transfer_course_cd IGS_PS_STDNT_TRN.transfer_course_cd%TYPE) IS
47: SELECT 'X'
48: FROM IGS_PS_STDNT_TRN sct,
49: IGS_EN_STDNT_PS_ATT sca
50: WHERE sct.person_id = p_person_id AND
51: sct.transfer_course_cd = cp_transfer_course_cd AND
52: (sct.course_cd <> p_course_cd) AND