APPS.IGS_AD_VAL_ACA dependencies on IGS_EN_STDNT_PS_ATT

Line 14: -- IGS_EN_STDNT_PS_ATT when lifting discontinuation.

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
18: -- attempt and the last transfer was not 'to' the course.

Line 39: FROM IGS_EN_STDNT_PS_ATT sca,

35: sct.transfer_course_cd = p_course_cd)
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

Line 49: IGS_EN_STDNT_PS_ATT sca

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
53: sca.person_id = sct.person_id AND

Line 235: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;

231: cst_completed CONSTANT VARCHAR2(9) := 'COMPLETED';
232: v_message_name VARCHAR2(30);
233: v_encmb_chk_dt IGS_CA_DA_INST_V.alias_val%TYPE;
234: v_generic_course_ind IGS_PS_VER.generic_course_ind%TYPE;
235: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
236: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
237: v_transfer_course_group_found BOOLEAN DEFAULT FALSE;
238: v_nominated_course_found BOOLEAN DEFAULT FALSE;
239: v_check CHAR;

Line 236: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

232: v_message_name VARCHAR2(30);
233: v_encmb_chk_dt IGS_CA_DA_INST_V.alias_val%TYPE;
234: v_generic_course_ind IGS_PS_VER.generic_course_ind%TYPE;
235: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
236: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
237: v_transfer_course_group_found BOOLEAN DEFAULT FALSE;
238: v_nominated_course_found BOOLEAN DEFAULT FALSE;
239: v_check CHAR;
240: CURSOR c_cv IS

Line 248: FROM IGS_EN_STDNT_PS_ATT

244: version_number = p_nominated_version_number;
245: CURSOR c_sca IS
246: SELECT course_attempt_status,
247: version_number
248: FROM IGS_EN_STDNT_PS_ATT
249: WHERE person_id = p_person_id AND
250: course_cd = p_transfer_course_cd;
251: CURSOR c_get_course_group_cd (
252: cp_version_number IGS_PS_GRP_MBR.version_number%TYPE) IS