APPS.IGS_PR_VAL_SPO dependencies on IGS_PR_S_PRG_CONF

Line 361: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;

357: -- Cannot alter show_cause_dt once show_cause_outcome_dt has been set
358: -- If 'applicable' apply_before_show_ind is N then cannot set show_cause_dt
359: -- once applied_dt has been set.
360: DECLARE
361: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
362: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
363: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
364: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
365: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;

Line 362: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;

358: -- If 'applicable' apply_before_show_ind is N then cannot set show_cause_dt
359: -- once applied_dt has been set.
360: DECLARE
361: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
362: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
363: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
364: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
365: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
366: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;

Line 363: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;

359: -- once applied_dt has been set.
360: DECLARE
361: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
362: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
363: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
364: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
365: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
366: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
367: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;

Line 364: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;

360: DECLARE
361: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
362: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
363: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
364: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
365: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
366: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
367: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
368: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;

Line 365: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;

361: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
362: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
363: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
364: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
365: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
366: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
367: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
368: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
369: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;

Line 366: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;

362: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
363: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
364: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
365: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
366: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
367: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
368: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
369: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
370: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;

Line 367: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;

363: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
364: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
365: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
366: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
367: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
368: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
369: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
370: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
371: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;

Line 368: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;

364: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
365: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
366: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
367: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
368: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
369: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
370: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
371: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
372: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;

Line 369: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;

365: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
366: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
367: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
368: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
369: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
370: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
371: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
372: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
373: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;

Line 370: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;

366: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
367: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
368: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
369: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
370: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
371: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
372: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
373: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
374: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;

Line 371: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;

367: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
368: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
369: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
370: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
371: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
372: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
373: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
374: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
375: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

Line 372: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;

368: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
369: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
370: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
371: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
372: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
373: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
374: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
375: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
376: v_outcome_check_type VARCHAR2(10);

Line 373: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;

369: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
370: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
371: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
372: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
373: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
374: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
375: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
376: v_outcome_check_type VARCHAR2(10);
377: CURSOR c_sca IS

Line 374: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;

370: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
371: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
372: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
373: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
374: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
375: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
376: v_outcome_check_type VARCHAR2(10);
377: CURSOR c_sca IS
378: SELECT sca.version_number

Line 489: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;

485: -- Cannot alter show_cause_expiry_dt once show_cause_outcome_dt has been set
486: -- Warn if the show_cause_expiry_dt is after the applicable show cause
487: -- cut-off date for the student's course version.
488: DECLARE
489: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
490: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
491: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
492: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
493: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;

Line 490: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;

486: -- Warn if the show_cause_expiry_dt is after the applicable show cause
487: -- cut-off date for the student's course version.
488: DECLARE
489: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
490: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
491: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
492: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
493: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
494: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;

Line 491: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;

487: -- cut-off date for the student's course version.
488: DECLARE
489: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
490: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
491: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
492: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
493: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
494: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
495: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;

Line 492: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;

488: DECLARE
489: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
490: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
491: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
492: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
493: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
494: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
495: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
496: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;

Line 493: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;

489: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
490: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
491: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
492: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
493: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
494: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
495: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
496: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
497: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;

Line 494: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;

490: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
491: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
492: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
493: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
494: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
495: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
496: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
497: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
498: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;

Line 495: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;

491: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
492: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
493: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
494: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
495: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
496: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
497: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
498: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
499: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;

Line 496: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;

492: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
493: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
494: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
495: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
496: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
497: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
498: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
499: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
500: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;

Line 497: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;

493: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
494: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
495: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
496: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
497: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
498: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
499: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
500: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
501: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;

Line 498: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;

494: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
495: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
496: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
497: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
498: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
499: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
500: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
501: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
502: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;

Line 499: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;

495: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
496: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
497: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
498: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
499: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
500: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
501: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
502: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
503: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

Line 500: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;

496: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
497: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
498: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
499: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
500: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
501: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
502: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
503: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
504: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;

Line 501: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;

497: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
498: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
499: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
500: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
501: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
502: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
503: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
504: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
505: v_outcome_check_type VARCHAR2(10);

Line 502: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;

498: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
499: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
500: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
501: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
502: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
503: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
504: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
505: v_outcome_check_type VARCHAR2(10);
506: CURSOR c_sca IS

Line 512: (cp_shw_cse_ctoff_dt_alias IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE) IS

508: FROM IGS_EN_STDNT_PS_ATT sca
509: WHERE sca.person_id = p_person_id AND
510: sca.course_cd = p_course_cd;
511: CURSOR c_daiv
512: (cp_shw_cse_ctoff_dt_alias IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE) IS
513: SELECT MAX(daiv.alias_val)
514: FROM IGS_CA_DA_INST_V daiv
515: WHERE daiv.dt_alias = cp_shw_cse_ctoff_dt_alias AND
516: daiv.cal_type = p_prg_cal_type AND

Line 688: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;

684: -- Cannot alter appeal_dt once appeal_outcome_dt has been set
685: -- If 'applicable' apply_before_appeal_ind is N then cannot
686: -- set appeal_dt once applied_dt has been set.
687: DECLARE
688: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
689: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
690: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
691: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
692: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;

Line 689: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;

685: -- If 'applicable' apply_before_appeal_ind is N then cannot
686: -- set appeal_dt once applied_dt has been set.
687: DECLARE
688: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
689: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
690: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
691: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
692: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
693: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;

Line 690: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;

686: -- set appeal_dt once applied_dt has been set.
687: DECLARE
688: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
689: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
690: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
691: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
692: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
693: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
694: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;

Line 691: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;

687: DECLARE
688: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
689: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
690: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
691: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
692: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
693: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
694: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
695: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;

Line 692: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;

688: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
689: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
690: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
691: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
692: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
693: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
694: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
695: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
696: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;

Line 693: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;

689: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
690: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
691: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
692: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
693: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
694: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
695: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
696: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
697: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;

Line 694: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;

690: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
691: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
692: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
693: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
694: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
695: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
696: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
697: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
698: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;

Line 695: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;

691: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
692: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
693: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
694: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
695: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
696: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
697: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
698: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
699: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;

Line 696: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;

692: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
693: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
694: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
695: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
696: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
697: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
698: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
699: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
700: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;

Line 697: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;

693: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
694: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
695: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
696: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
697: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
698: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
699: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
700: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
701: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;

Line 698: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;

694: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
695: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
696: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
697: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
698: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
699: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
700: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
701: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
702: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

Line 699: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;

695: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
696: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
697: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
698: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
699: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
700: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
701: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
702: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
703: v_outcome_check_type VARCHAR2(10);

Line 700: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;

696: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
697: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
698: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
699: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
700: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
701: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
702: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
703: v_outcome_check_type VARCHAR2(10);
704: CURSOR c_sca IS

Line 701: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;

697: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
698: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
699: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
700: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
701: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
702: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
703: v_outcome_check_type VARCHAR2(10);
704: CURSOR c_sca IS
705: SELECT sca.version_number

Line 810: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;

806: -- Cannot alter appeal_expiry_dt once appeal_outcome_dt has been set
807: -- Warn if the appeal_expiry_dt is after the applicable appeal cut-off date
808: -- for the student's course version.
809: DECLARE
810: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
811: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
812: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
813: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
814: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;

Line 811: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;

807: -- Warn if the appeal_expiry_dt is after the applicable appeal cut-off date
808: -- for the student's course version.
809: DECLARE
810: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
811: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
812: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
813: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
814: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
815: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;

Line 812: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;

808: -- for the student's course version.
809: DECLARE
810: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
811: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
812: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
813: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
814: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
815: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
816: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;

Line 813: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;

809: DECLARE
810: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
811: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
812: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
813: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
814: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
815: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
816: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
817: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;

Line 814: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;

810: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
811: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
812: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
813: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
814: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
815: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
816: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
817: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
818: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;

Line 815: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;

811: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
812: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
813: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
814: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
815: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
816: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
817: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
818: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
819: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;

Line 816: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;

812: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
813: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
814: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
815: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
816: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
817: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
818: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
819: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
820: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;

Line 817: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;

813: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
814: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
815: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
816: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
817: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
818: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
819: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
820: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
821: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;

Line 818: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;

814: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
815: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
816: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
817: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
818: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
819: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
820: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
821: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
822: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;

Line 819: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;

815: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
816: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
817: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
818: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
819: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
820: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
821: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
822: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
823: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;

Line 820: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;

816: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
817: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
818: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
819: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
820: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
821: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
822: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
823: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
824: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

Line 821: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;

817: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
818: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
819: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
820: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
821: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
822: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
823: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
824: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
825: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;

Line 822: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;

818: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
819: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
820: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
821: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
822: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
823: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
824: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
825: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
826: v_outcome_check_type VARCHAR2(10);

Line 823: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;

819: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
820: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
821: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
822: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
823: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
824: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
825: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
826: v_outcome_check_type VARCHAR2(10);
827: CURSOR c_sca IS

Line 832: CURSOR c_daiv (cp_apl_ctoff_dt_alias IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE) IS

828: SELECT sca.version_number
829: FROM IGS_EN_STDNT_PS_ATT sca
830: WHERE sca.person_id = p_person_id AND
831: sca.course_cd = p_course_cd;
832: CURSOR c_daiv (cp_apl_ctoff_dt_alias IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE) IS
833: SELECT MAX(daiv.alias_val)
834: FROM IGS_CA_DA_INST_V daiv
835: WHERE daiv.dt_alias = cp_apl_ctoff_dt_alias AND
836: daiv.cal_type = p_prg_cal_type AND

Line 2009: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;

2005: cst_cancelled CONSTANT VARCHAR2(10) := 'CANCELLED';
2006: cst_removed CONSTANT VARCHAR2(10) := 'REMOVED';
2007: cst_approved CONSTANT VARCHAR2(10) := 'APPROVED';
2008: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
2009: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
2010: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
2011: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
2012: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
2013: v_show_cause_cutoff_dt_alias IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;

Line 2010: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;

2006: cst_removed CONSTANT VARCHAR2(10) := 'REMOVED';
2007: cst_approved CONSTANT VARCHAR2(10) := 'APPROVED';
2008: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
2009: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
2010: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
2011: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
2012: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
2013: v_show_cause_cutoff_dt_alias IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
2014: v_appeal_cutoff_dt_alias IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;

Line 2011: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;

2007: cst_approved CONSTANT VARCHAR2(10) := 'APPROVED';
2008: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
2009: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
2010: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
2011: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
2012: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
2013: v_show_cause_cutoff_dt_alias IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
2014: v_appeal_cutoff_dt_alias IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
2015: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;

Line 2012: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;

2008: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
2009: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
2010: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
2011: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
2012: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
2013: v_show_cause_cutoff_dt_alias IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
2014: v_appeal_cutoff_dt_alias IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
2015: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
2016: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;

Line 2013: v_show_cause_cutoff_dt_alias IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;

2009: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
2010: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
2011: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
2012: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
2013: v_show_cause_cutoff_dt_alias IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
2014: v_appeal_cutoff_dt_alias IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
2015: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
2016: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
2017: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;

Line 2014: v_appeal_cutoff_dt_alias IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;

2010: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
2011: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
2012: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
2013: v_show_cause_cutoff_dt_alias IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
2014: v_appeal_cutoff_dt_alias IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
2015: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
2016: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
2017: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
2018: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;

Line 2015: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;

2011: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
2012: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
2013: v_show_cause_cutoff_dt_alias IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
2014: v_appeal_cutoff_dt_alias IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
2015: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
2016: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
2017: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
2018: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
2019: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;

Line 2016: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;

2012: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
2013: v_show_cause_cutoff_dt_alias IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
2014: v_appeal_cutoff_dt_alias IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
2015: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
2016: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
2017: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
2018: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
2019: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
2020: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;

Line 2017: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;

2013: v_show_cause_cutoff_dt_alias IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
2014: v_appeal_cutoff_dt_alias IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
2015: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
2016: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
2017: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
2018: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
2019: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
2020: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
2021: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;

Line 2018: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;

2014: v_appeal_cutoff_dt_alias IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
2015: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
2016: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
2017: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
2018: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
2019: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
2020: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
2021: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
2022: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;

Line 2019: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;

2015: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
2016: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
2017: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
2018: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
2019: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
2020: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
2021: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
2022: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
2023: v_outcome_check_type VARCHAR2(10);

Line 2020: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;

2016: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
2017: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
2018: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
2019: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
2020: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
2021: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
2022: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
2023: v_outcome_check_type VARCHAR2(10);
2024: CURSOR c_sca IS

Line 2021: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;

2017: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
2018: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
2019: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
2020: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
2021: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
2022: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
2023: v_outcome_check_type VARCHAR2(10);
2024: CURSOR c_sca IS
2025: SELECT sca.version_number

Line 2022: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;

2018: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
2019: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
2020: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
2021: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
2022: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
2023: v_outcome_check_type VARCHAR2(10);
2024: CURSOR c_sca IS
2025: SELECT sca.version_number
2026: FROM IGS_EN_STDNT_PS_ATT sca