DBA Data[Home] [Help]

APPS.IGS_ST_GEN_004 dependencies on IGS_EN_ATD_MODE

Line 250: v_attendance_mode_1 IGS_EN_ATD_MODE.attendance_mode%TYPE;

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;

Line 251: v_govt_attendance_mode_1 IGS_EN_ATD_MODE.govt_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;

Line 252: v_attendance_mode_2 IGS_EN_ATD_MODE.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;

Line 253: v_govt_attendance_mode_2 IGS_EN_ATD_MODE.govt_attendance_mode%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;
257: v_load_ci_sequence_number

Line 254: v_attendance_mode_3 IGS_EN_ATD_MODE.attendance_mode%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
258: IGS_EN_ST_SNAPSHOT.ci_sequence_number%TYPE DEFAULT NULL;

Line 255: v_govt_attendance_mode_3 IGS_EN_ATD_MODE.govt_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;
259: v_teach_cal_type IGS_EN_ST_SNAPSHOT.sua_cal_type%TYPE DEFAULT NULL;

Line 331: v_govt_attendance_mode IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;

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;

Line 332: v_attendance_mode IGS_EN_ATD_MODE.attendance_mode%TYPE;

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;

Line 412: FROM IGS_EN_ATD_MODE atm

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,

Line 418: FROM IGS_EN_ATD_MODE atm

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,

Line 424: FROM IGS_EN_ATD_MODE atm

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