[Home] [Help]
846:
847: BEGIN
848: p_warn_level := NULL;
849: p_message_name := null;
850: -- Check if IGS_PE_PERSON has a IGS_RE_CANDIDATURE record linked
851: -- to the student IGS_PS_COURSE attempt.
852: OPEN c_ca;
853: FETCH c_ca INTO v_sca_ca_sequence_number;
854: CLOSE c_ca;
851: -- to the student IGS_PS_COURSE attempt.
852: OPEN c_ca;
853: FETCH c_ca INTO v_sca_ca_sequence_number;
854: CLOSE c_ca;
855: -- Check if IGS_PE_PERSON has a IGS_RE_CANDIDATURE record linked to
856: -- the admission IGS_PS_COURSE application instance.
857: OPEN c_ca2;
858: FETCH c_ca2 INTO v_acai_ca_sequence_number;
859: CLOSE c_ca2;
1556: END IF;
1557: RAISE;
1558: END;
1559: ELSIF v_sca_rec.course_attempt_status = cst_discontin THEN
1560: -- Check if the IGS_PE_PERSON has been made an offer after
1561: -- they were discontinued.
1562: IF v_acaiv_rec.offer_dt >= v_sca_rec.discontinued_dt THEN
1563: BEGIN
1564: -- Lift the discontinuation and update details of the IGS_PS_COURSE
1696: END IF;
1697: RAISE;
1698: END;
1699: ELSE
1700: -- IGS_PE_PERSON does not have a current admission offer.
1701: IF p_log_creation_dt IS NOT NULL THEN
1702: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
1703: cst_pre_enrol,
1704: p_log_creation_dt,
8654:
8655: l_waitlist_ind VARCHAR2(2);
8656: l_unit_section_status igs_en_su_attempt.unit_attempt_status%TYPE;
8657: l_uoo_id igs_en_su_attempt.uoo_id%TYPE;
8658: l_person_number igs_pe_person.person_number%TYPE;
8659: l_ret_stat VARCHAR2(1);
8660: l_unit_attempt_status igs_en_su_attempt.unit_attempt_status%TYPE;
8661: l_sub_sup_status igs_en_su_attempt.unit_attempt_status%TYPE;
8662: l_primary_program_cd IGS_PS_VER_ALL.COURSE_CD%TYPE;