[Home] [Help]
561: */
562: gv_other_detail VARCHAR2(255);
563: gv_extra_detail VARCHAR2(255) DEFAULT NULL;
564: BEGIN
565: -- Validate whether the nominated IGS_PE_PERSON is eligible to enrol in the nominated
566: -- IGS_PS_COURSE in an nominated academic period. This routine performs the same
567: -- logic for both new and returning students, due to the requirements of
568: -- re-admission and IGS_PS_COURSE transfer which blur the strict lines between the
569: -- two. The following checks are performed:
566: -- IGS_PS_COURSE in an nominated academic period. This routine performs the same
567: -- logic for both new and returning students, due to the requirements of
568: -- re-admission and IGS_PS_COURSE transfer which blur the strict lines between the
569: -- two. The following checks are performed:
570: -- * The deceased_ind for the IGS_PE_PERSON is not set
571: -- * Student has no exclusions/encumbrances preventing them from enrolling.
572: -- The student must be excluded from all teaching periods linked to the
573: -- academic year to be ineligible.
574: -- * Student has an offer in the IGS_PS_COURSE within the nominated academic period,
597: cst_intermit CONSTANT VARCHAR2(10) := 'INTERMIT';
598: cst_discontin CONSTANT VARCHAR2(10) := 'DISCONTIN';
599: cst_unconfirm CONSTANT VARCHAR2(10) := 'UNCONFIRM';
600:
601: v_deceased_ind IGS_PE_PERSON.deceased_ind%TYPE;
602: v_instance_start_dt IGS_CA_INST.start_dt%TYPE;
603: v_instance_end_dt IGS_CA_INST.end_dt%TYPE;
604: v_intrmsn_start_dt IGS_EN_STDNT_PS_INTM.start_dt%TYPE;
605: v_intrmsn_end_dt IGS_EN_STDNT_PS_INTM.end_dt%TYPE;
627: --modified cursor for performance bug 4968380
628: CURSOR c_person IS
629: SELECT DECODE(Pbv.DATE_OF_DEATH,NULL,NVL(PE.DECEASED_IND,'N'),'Y') DECEASED_IND
630: FROM IGS_PE_HZ_PARTIES pe,
631: IGS_PE_PERSON_BASE_V pbv
632: WHERE pe.party_id = p_person_id AND
633: pbv.person_id = pe.party_id;
634:
635: CURSOR c_ci IS