246: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
247: v_derived_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
248: v_attendance_type IGS_EN_ATD_TYPE.attendance_type%TYPE;
249: v_govt_attendance_type IGS_EN_ATD_TYPE.govt_attendance_type%TYPE;
250: v_attendance_mode_1 IGS_EN_ATD_MODE.attendance_mode%TYPE;
251: v_govt_attendance_mode_1 IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
252: v_attendance_mode_2 IGS_EN_ATD_MODE.attendance_mode%TYPE;
253: v_govt_attendance_mode_2 IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
254: v_attendance_mode_3 IGS_EN_ATD_MODE.attendance_mode%TYPE;
247: v_derived_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
248: v_attendance_type IGS_EN_ATD_TYPE.attendance_type%TYPE;
249: v_govt_attendance_type IGS_EN_ATD_TYPE.govt_attendance_type%TYPE;
250: v_attendance_mode_1 IGS_EN_ATD_MODE.attendance_mode%TYPE;
251: v_govt_attendance_mode_1 IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
252: v_attendance_mode_2 IGS_EN_ATD_MODE.attendance_mode%TYPE;
253: v_govt_attendance_mode_2 IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
254: v_attendance_mode_3 IGS_EN_ATD_MODE.attendance_mode%TYPE;
255: v_govt_attendance_mode_3 IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
248: v_attendance_type IGS_EN_ATD_TYPE.attendance_type%TYPE;
249: v_govt_attendance_type IGS_EN_ATD_TYPE.govt_attendance_type%TYPE;
250: v_attendance_mode_1 IGS_EN_ATD_MODE.attendance_mode%TYPE;
251: v_govt_attendance_mode_1 IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
252: v_attendance_mode_2 IGS_EN_ATD_MODE.attendance_mode%TYPE;
253: v_govt_attendance_mode_2 IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
254: v_attendance_mode_3 IGS_EN_ATD_MODE.attendance_mode%TYPE;
255: v_govt_attendance_mode_3 IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
256: v_load_cal_type IGS_EN_ST_SNAPSHOT.ci_cal_type%TYPE DEFAULT NULL;
249: v_govt_attendance_type IGS_EN_ATD_TYPE.govt_attendance_type%TYPE;
250: v_attendance_mode_1 IGS_EN_ATD_MODE.attendance_mode%TYPE;
251: v_govt_attendance_mode_1 IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
252: v_attendance_mode_2 IGS_EN_ATD_MODE.attendance_mode%TYPE;
253: v_govt_attendance_mode_2 IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
254: v_attendance_mode_3 IGS_EN_ATD_MODE.attendance_mode%TYPE;
255: v_govt_attendance_mode_3 IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
256: v_load_cal_type IGS_EN_ST_SNAPSHOT.ci_cal_type%TYPE DEFAULT NULL;
257: v_load_ci_sequence_number
250: v_attendance_mode_1 IGS_EN_ATD_MODE.attendance_mode%TYPE;
251: v_govt_attendance_mode_1 IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
252: v_attendance_mode_2 IGS_EN_ATD_MODE.attendance_mode%TYPE;
253: v_govt_attendance_mode_2 IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
254: v_attendance_mode_3 IGS_EN_ATD_MODE.attendance_mode%TYPE;
255: v_govt_attendance_mode_3 IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
256: v_load_cal_type IGS_EN_ST_SNAPSHOT.ci_cal_type%TYPE DEFAULT NULL;
257: v_load_ci_sequence_number
258: IGS_EN_ST_SNAPSHOT.ci_sequence_number%TYPE DEFAULT NULL;
251: v_govt_attendance_mode_1 IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
252: v_attendance_mode_2 IGS_EN_ATD_MODE.attendance_mode%TYPE;
253: v_govt_attendance_mode_2 IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
254: v_attendance_mode_3 IGS_EN_ATD_MODE.attendance_mode%TYPE;
255: v_govt_attendance_mode_3 IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
256: v_load_cal_type IGS_EN_ST_SNAPSHOT.ci_cal_type%TYPE DEFAULT NULL;
257: v_load_ci_sequence_number
258: IGS_EN_ST_SNAPSHOT.ci_sequence_number%TYPE DEFAULT NULL;
259: v_teach_cal_type IGS_EN_ST_SNAPSHOT.sua_cal_type%TYPE DEFAULT NULL;
327: v_tmp_person_id NUMBER;
328: v_flag BOOLEAN;
329: v_prev_sub BOOLEAN;
330: v_s_unit_mode IGS_AS_UNIT_MODE.s_unit_mode%TYPE;
331: v_govt_attendance_mode IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
332: v_attendance_mode IGS_EN_ATD_MODE.attendance_mode%TYPE;
333: v_lower_enr_load_range IGS_EN_ATD_TYPE.lower_enr_load_range%TYPE;
334: v_major_course IGS_ST_GOVT_STDNT_EN.major_course%TYPE;
335: v_on BOOLEAN DEFAULT FALSE;
328: v_flag BOOLEAN;
329: v_prev_sub BOOLEAN;
330: v_s_unit_mode IGS_AS_UNIT_MODE.s_unit_mode%TYPE;
331: v_govt_attendance_mode IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
332: v_attendance_mode IGS_EN_ATD_MODE.attendance_mode%TYPE;
333: v_lower_enr_load_range IGS_EN_ATD_TYPE.lower_enr_load_range%TYPE;
334: v_major_course IGS_ST_GOVT_STDNT_EN.major_course%TYPE;
335: v_on BOOLEAN DEFAULT FALSE;
336: v_off BOOLEAN DEFAULT FALSE;
408: aty.upper_enr_load_range > 0;
409: CURSOR c_get_att_mode_1 IS
410: SELECT atm.attendance_mode,
411: atm.govt_attendance_mode
412: FROM IGS_EN_ATD_MODE atm
413: WHERE atm.govt_attendance_mode = '1'
414: ORDER BY atm.attendance_mode ASC;
415: CURSOR c_get_att_mode_2 IS
416: SELECT atm.attendance_mode,
414: ORDER BY atm.attendance_mode ASC;
415: CURSOR c_get_att_mode_2 IS
416: SELECT atm.attendance_mode,
417: atm.govt_attendance_mode
418: FROM IGS_EN_ATD_MODE atm
419: WHERE atm.govt_attendance_mode = '2'
420: ORDER BY atm.attendance_mode ASC;
421: CURSOR c_get_att_mode_3 IS
422: SELECT atm.attendance_mode,
420: ORDER BY atm.attendance_mode ASC;
421: CURSOR c_get_att_mode_3 IS
422: SELECT atm.attendance_mode,
423: atm.govt_attendance_mode
424: FROM IGS_EN_ATD_MODE atm
425: WHERE atm.govt_attendance_mode = '3'
426: ORDER BY atm.attendance_mode ASC;
427: CURSOR c_enr_snpsht_rec (
428: cp_dt_time IGS_ST_GVT_SPSHT_CTL.ess_snapshot_dt_time%TYPE) IS