eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_PR_GEN_004 dependencies on IGS_PR_S_PRG_CONF

Line 296: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;

292: PRAGMA EXCEPTION_INIT(e_record_locked, -54);
293: e_application EXCEPTION;
294: PRAGMA EXCEPTION_INIT(e_application, -20000);
295:
296: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
297: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
298: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
299: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
300: v_show_cause_cutoff_dt_alias IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;

Line 297: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;

293: e_application EXCEPTION;
294: PRAGMA EXCEPTION_INIT(e_application, -20000);
295:
296: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
297: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
298: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
299: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
300: v_show_cause_cutoff_dt_alias IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
301: v_appeal_cutoff_dt_alias IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;

Line 298: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;

294: PRAGMA EXCEPTION_INIT(e_application, -20000);
295:
296: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
297: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
298: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
299: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
300: v_show_cause_cutoff_dt_alias IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
301: v_appeal_cutoff_dt_alias IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
302: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;

Line 299: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;

295:
296: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
297: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
298: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
299: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
300: v_show_cause_cutoff_dt_alias IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
301: v_appeal_cutoff_dt_alias IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
302: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
303: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;

Line 300: v_show_cause_cutoff_dt_alias IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;

296: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
297: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
298: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
299: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
300: v_show_cause_cutoff_dt_alias IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
301: v_appeal_cutoff_dt_alias IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
302: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
303: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
304: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;

Line 301: v_appeal_cutoff_dt_alias IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;

297: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
298: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
299: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
300: v_show_cause_cutoff_dt_alias IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
301: v_appeal_cutoff_dt_alias IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
302: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
303: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
304: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
305: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;

Line 302: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;

298: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
299: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
300: v_show_cause_cutoff_dt_alias IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
301: v_appeal_cutoff_dt_alias IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
302: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
303: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
304: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
305: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
306: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;

Line 303: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;

299: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
300: v_show_cause_cutoff_dt_alias IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
301: v_appeal_cutoff_dt_alias IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
302: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
303: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
304: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
305: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
306: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
307: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;

Line 304: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;

300: v_show_cause_cutoff_dt_alias IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
301: v_appeal_cutoff_dt_alias IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
302: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
303: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
304: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
305: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
306: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
307: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
308: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;

Line 305: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;

301: v_appeal_cutoff_dt_alias IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
302: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
303: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
304: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
305: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
306: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
307: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
308: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
309: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;

Line 306: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;

302: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
303: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
304: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
305: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
306: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
307: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
308: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
309: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
310: v_outcome_check_type IGS_PR_S_PRG_CONF.outcome_check_type%TYPE;

Line 307: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;

303: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
304: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
305: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
306: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
307: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
308: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
309: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
310: v_outcome_check_type IGS_PR_S_PRG_CONF.outcome_check_type%TYPE;
311: v_application_type VARCHAR2(10);

Line 308: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;

304: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
305: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
306: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
307: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
308: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
309: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
310: v_outcome_check_type IGS_PR_S_PRG_CONF.outcome_check_type%TYPE;
311: v_application_type VARCHAR2(10);
312: v_log_creation_dt DATE DEFAULT NULL;

Line 309: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;

305: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
306: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
307: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
308: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
309: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
310: v_outcome_check_type IGS_PR_S_PRG_CONF.outcome_check_type%TYPE;
311: v_application_type VARCHAR2(10);
312: v_log_creation_dt DATE DEFAULT NULL;
313: v_key IGS_GE_s_log.KEY%TYPE;

Line 310: v_outcome_check_type IGS_PR_S_PRG_CONF.outcome_check_type%TYPE;

306: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
307: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
308: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
309: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
310: v_outcome_check_type IGS_PR_S_PRG_CONF.outcome_check_type%TYPE;
311: v_application_type VARCHAR2(10);
312: v_log_creation_dt DATE DEFAULT NULL;
313: v_key IGS_GE_s_log.KEY%TYPE;
314: v_process_next_spo BOOLEAN;

Line 925: p_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE,

921: FUNCTION prgpl_upd_spo (
922: p_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
923: p_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
924: p_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE,
925: p_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE,
926: p_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE,
927: p_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE,
928: p_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE)
929: RETURN BOOLEAN

Line 926: p_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE,

922: p_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
923: p_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
924: p_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE,
925: p_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE,
926: p_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE,
927: p_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE,
928: p_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE)
929: RETURN BOOLEAN
930: IS

Line 927: p_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE,

923: p_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
924: p_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE,
925: p_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE,
926: p_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE,
927: p_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE,
928: p_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE)
929: RETURN BOOLEAN
930: IS
931: --rvangala 07-OCT-2003 Value for CORE_INDICATOR_CODE passed to IGS_EN_SUA_API.UPDATE_UNIT_ATTEMPT

Line 928: p_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE)

924: p_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE,
925: p_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE,
926: p_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE,
927: p_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE,
928: p_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE)
929: RETURN BOOLEAN
930: IS
931: --rvangala 07-OCT-2003 Value for CORE_INDICATOR_CODE passed to IGS_EN_SUA_API.UPDATE_UNIT_ATTEMPT
932: -- added as part of Prevent Dropping Core Units. Enh Bug# 3052432

Line 2737: EXISTS ( SELECT 1 FROM IGS_PR_S_PRG_CONF spc1

2733: FROM IGS_CA_DA_INST dai1
2734: WHERE ci.cal_type = dai1.cal_type AND
2735: ci.sequence_number = dai1.ci_sequence_number AND
2736: (
2737: EXISTS ( SELECT 1 FROM IGS_PR_S_PRG_CONF spc1
2738: WHERE dai1.dt_alias = spc1.apply_start_dt_alias)
2739: OR
2740: EXISTS (SELECT 1 FROM IGS_PR_S_OU_PRG_CONF sopc1
2741: WHERE dai1.dt_alias = sopc1.apply_start_dt_alias)

Line 2757: EXISTS ( SELECT 1 FROM IGS_PR_S_PRG_CONF spc2

2753: FROM IGS_CA_DA_INST dai2
2754: WHERE ci.cal_type = dai2.cal_type AND
2755: ci.sequence_number = dai2.ci_sequence_number AND
2756: (
2757: EXISTS ( SELECT 1 FROM IGS_PR_S_PRG_CONF spc2
2758: WHERE dai2.dt_alias = spc2.apply_end_dt_alias)
2759: OR
2760: EXISTS (SELECT 1 FROM IGS_PR_S_OU_PRG_CONF sopc2
2761: WHERE dai2.dt_alias = sopc2.apply_end_dt_alias)

Line 2782: p_outcome_check_type IGS_PR_S_PRG_CONF.outcome_check_type%TYPE)

2778: p_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
2779: p_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
2780: p_ci_cal_type IGS_CA_INST.cal_type%TYPE,
2781: p_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
2782: p_outcome_check_type IGS_PR_S_PRG_CONF.outcome_check_type%TYPE)
2783: RETURN VARCHAR2
2784: IS
2785: BEGIN -- prgpl_upd_check_readiness
2786: DECLARE

Line 2849: v_apply_start_dt_alias igs_pr_s_prg_conf.apply_start_dt_alias%TYPE;

2845: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE
2846: ) IS
2847: BEGIN -- prgpl_upd_initial_appl
2848: DECLARE
2849: v_apply_start_dt_alias igs_pr_s_prg_conf.apply_start_dt_alias%TYPE;
2850: v_apply_end_dt_alias igs_pr_s_prg_conf.apply_end_dt_alias%TYPE;
2851: v_end_benefit_dt_alias igs_pr_s_prg_conf.end_benefit_dt_alias%TYPE;
2852: v_end_penalty_dt_alias igs_pr_s_prg_conf.end_penalty_dt_alias%TYPE;
2853: v_show_cause_cutoff_dt igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;

Line 2850: v_apply_end_dt_alias igs_pr_s_prg_conf.apply_end_dt_alias%TYPE;

2846: ) IS
2847: BEGIN -- prgpl_upd_initial_appl
2848: DECLARE
2849: v_apply_start_dt_alias igs_pr_s_prg_conf.apply_start_dt_alias%TYPE;
2850: v_apply_end_dt_alias igs_pr_s_prg_conf.apply_end_dt_alias%TYPE;
2851: v_end_benefit_dt_alias igs_pr_s_prg_conf.end_benefit_dt_alias%TYPE;
2852: v_end_penalty_dt_alias igs_pr_s_prg_conf.end_penalty_dt_alias%TYPE;
2853: v_show_cause_cutoff_dt igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;
2854: v_appeal_cutoff_dt igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;

Line 2851: v_end_benefit_dt_alias igs_pr_s_prg_conf.end_benefit_dt_alias%TYPE;

2847: BEGIN -- prgpl_upd_initial_appl
2848: DECLARE
2849: v_apply_start_dt_alias igs_pr_s_prg_conf.apply_start_dt_alias%TYPE;
2850: v_apply_end_dt_alias igs_pr_s_prg_conf.apply_end_dt_alias%TYPE;
2851: v_end_benefit_dt_alias igs_pr_s_prg_conf.end_benefit_dt_alias%TYPE;
2852: v_end_penalty_dt_alias igs_pr_s_prg_conf.end_penalty_dt_alias%TYPE;
2853: v_show_cause_cutoff_dt igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;
2854: v_appeal_cutoff_dt igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;
2855: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;

Line 2852: v_end_penalty_dt_alias igs_pr_s_prg_conf.end_penalty_dt_alias%TYPE;

2848: DECLARE
2849: v_apply_start_dt_alias igs_pr_s_prg_conf.apply_start_dt_alias%TYPE;
2850: v_apply_end_dt_alias igs_pr_s_prg_conf.apply_end_dt_alias%TYPE;
2851: v_end_benefit_dt_alias igs_pr_s_prg_conf.end_benefit_dt_alias%TYPE;
2852: v_end_penalty_dt_alias igs_pr_s_prg_conf.end_penalty_dt_alias%TYPE;
2853: v_show_cause_cutoff_dt igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;
2854: v_appeal_cutoff_dt igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;
2855: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;
2856: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;

Line 2853: v_show_cause_cutoff_dt igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;

2849: v_apply_start_dt_alias igs_pr_s_prg_conf.apply_start_dt_alias%TYPE;
2850: v_apply_end_dt_alias igs_pr_s_prg_conf.apply_end_dt_alias%TYPE;
2851: v_end_benefit_dt_alias igs_pr_s_prg_conf.end_benefit_dt_alias%TYPE;
2852: v_end_penalty_dt_alias igs_pr_s_prg_conf.end_penalty_dt_alias%TYPE;
2853: v_show_cause_cutoff_dt igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;
2854: v_appeal_cutoff_dt igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;
2855: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;
2856: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;
2857: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;

Line 2854: v_appeal_cutoff_dt igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;

2850: v_apply_end_dt_alias igs_pr_s_prg_conf.apply_end_dt_alias%TYPE;
2851: v_end_benefit_dt_alias igs_pr_s_prg_conf.end_benefit_dt_alias%TYPE;
2852: v_end_penalty_dt_alias igs_pr_s_prg_conf.end_penalty_dt_alias%TYPE;
2853: v_show_cause_cutoff_dt igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;
2854: v_appeal_cutoff_dt igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;
2855: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;
2856: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;
2857: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;
2858: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;

Line 2855: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;

2851: v_end_benefit_dt_alias igs_pr_s_prg_conf.end_benefit_dt_alias%TYPE;
2852: v_end_penalty_dt_alias igs_pr_s_prg_conf.end_penalty_dt_alias%TYPE;
2853: v_show_cause_cutoff_dt igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;
2854: v_appeal_cutoff_dt igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;
2855: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;
2856: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;
2857: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;
2858: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;
2859: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;

Line 2856: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;

2852: v_end_penalty_dt_alias igs_pr_s_prg_conf.end_penalty_dt_alias%TYPE;
2853: v_show_cause_cutoff_dt igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;
2854: v_appeal_cutoff_dt igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;
2855: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;
2856: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;
2857: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;
2858: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;
2859: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;
2860: v_count_exc_in_time_ind igs_pr_s_prg_conf.count_exc_in_time_ind%TYPE;

Line 2857: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;

2853: v_show_cause_cutoff_dt igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;
2854: v_appeal_cutoff_dt igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;
2855: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;
2856: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;
2857: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;
2858: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;
2859: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;
2860: v_count_exc_in_time_ind igs_pr_s_prg_conf.count_exc_in_time_ind%TYPE;
2861: v_calculate_wam_ind igs_pr_s_prg_conf.calculate_wam_ind%TYPE;

Line 2858: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;

2854: v_appeal_cutoff_dt igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;
2855: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;
2856: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;
2857: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;
2858: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;
2859: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;
2860: v_count_exc_in_time_ind igs_pr_s_prg_conf.count_exc_in_time_ind%TYPE;
2861: v_calculate_wam_ind igs_pr_s_prg_conf.calculate_wam_ind%TYPE;
2862: v_calculate_gpa_ind igs_pr_s_prg_conf.calculate_gpa_ind%TYPE;

Line 2859: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;

2855: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;
2856: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;
2857: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;
2858: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;
2859: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;
2860: v_count_exc_in_time_ind igs_pr_s_prg_conf.count_exc_in_time_ind%TYPE;
2861: v_calculate_wam_ind igs_pr_s_prg_conf.calculate_wam_ind%TYPE;
2862: v_calculate_gpa_ind igs_pr_s_prg_conf.calculate_gpa_ind%TYPE;
2863: v_outcome_check_type igs_pr_s_prg_conf.outcome_check_type%TYPE;

Line 2860: v_count_exc_in_time_ind igs_pr_s_prg_conf.count_exc_in_time_ind%TYPE;

2856: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;
2857: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;
2858: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;
2859: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;
2860: v_count_exc_in_time_ind igs_pr_s_prg_conf.count_exc_in_time_ind%TYPE;
2861: v_calculate_wam_ind igs_pr_s_prg_conf.calculate_wam_ind%TYPE;
2862: v_calculate_gpa_ind igs_pr_s_prg_conf.calculate_gpa_ind%TYPE;
2863: v_outcome_check_type igs_pr_s_prg_conf.outcome_check_type%TYPE;
2864: --

Line 2861: v_calculate_wam_ind igs_pr_s_prg_conf.calculate_wam_ind%TYPE;

2857: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;
2858: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;
2859: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;
2860: v_count_exc_in_time_ind igs_pr_s_prg_conf.count_exc_in_time_ind%TYPE;
2861: v_calculate_wam_ind igs_pr_s_prg_conf.calculate_wam_ind%TYPE;
2862: v_calculate_gpa_ind igs_pr_s_prg_conf.calculate_gpa_ind%TYPE;
2863: v_outcome_check_type igs_pr_s_prg_conf.outcome_check_type%TYPE;
2864: --
2865: TYPE ScaCurTyp IS REF CURSOR;

Line 2862: v_calculate_gpa_ind igs_pr_s_prg_conf.calculate_gpa_ind%TYPE;

2858: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;
2859: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;
2860: v_count_exc_in_time_ind igs_pr_s_prg_conf.count_exc_in_time_ind%TYPE;
2861: v_calculate_wam_ind igs_pr_s_prg_conf.calculate_wam_ind%TYPE;
2862: v_calculate_gpa_ind igs_pr_s_prg_conf.calculate_gpa_ind%TYPE;
2863: v_outcome_check_type igs_pr_s_prg_conf.outcome_check_type%TYPE;
2864: --
2865: TYPE ScaCurTyp IS REF CURSOR;
2866: c_sca ScaCurTyp;

Line 2863: v_outcome_check_type igs_pr_s_prg_conf.outcome_check_type%TYPE;

2859: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;
2860: v_count_exc_in_time_ind igs_pr_s_prg_conf.count_exc_in_time_ind%TYPE;
2861: v_calculate_wam_ind igs_pr_s_prg_conf.calculate_wam_ind%TYPE;
2862: v_calculate_gpa_ind igs_pr_s_prg_conf.calculate_gpa_ind%TYPE;
2863: v_outcome_check_type igs_pr_s_prg_conf.outcome_check_type%TYPE;
2864: --
2865: TYPE ScaCurTyp IS REF CURSOR;
2866: c_sca ScaCurTyp;
2867: stmt_str VARCHAR2(10000);

Line 3562: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;

3558: v_beyond_penalty BOOLEAN DEFAULT FALSE;
3559: v_beyond_benefit BOOLEAN DEFAULT FALSE;
3560: v_rules_altered BOOLEAN DEFAULT FALSE;
3561: v_outcomes_removed BOOLEAN DEFAULT FALSE;
3562: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
3563: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
3564: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
3565: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
3566: v_show_cause_cutoff_dt_alias IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;

Line 3563: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;

3559: v_beyond_benefit BOOLEAN DEFAULT FALSE;
3560: v_rules_altered BOOLEAN DEFAULT FALSE;
3561: v_outcomes_removed BOOLEAN DEFAULT FALSE;
3562: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
3563: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
3564: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
3565: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
3566: v_show_cause_cutoff_dt_alias IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
3567: v_appeal_cutoff_dt_alias IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;

Line 3564: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;

3560: v_rules_altered BOOLEAN DEFAULT FALSE;
3561: v_outcomes_removed BOOLEAN DEFAULT FALSE;
3562: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
3563: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
3564: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
3565: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
3566: v_show_cause_cutoff_dt_alias IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
3567: v_appeal_cutoff_dt_alias IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
3568: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;

Line 3565: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;

3561: v_outcomes_removed BOOLEAN DEFAULT FALSE;
3562: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
3563: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
3564: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
3565: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
3566: v_show_cause_cutoff_dt_alias IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
3567: v_appeal_cutoff_dt_alias IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
3568: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
3569: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;

Line 3566: v_show_cause_cutoff_dt_alias IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;

3562: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
3563: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
3564: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
3565: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
3566: v_show_cause_cutoff_dt_alias IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
3567: v_appeal_cutoff_dt_alias IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
3568: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
3569: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
3570: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;

Line 3567: v_appeal_cutoff_dt_alias IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;

3563: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
3564: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
3565: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
3566: v_show_cause_cutoff_dt_alias IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
3567: v_appeal_cutoff_dt_alias IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
3568: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
3569: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
3570: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
3571: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;

Line 3568: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;

3564: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
3565: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
3566: v_show_cause_cutoff_dt_alias IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
3567: v_appeal_cutoff_dt_alias IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
3568: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
3569: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
3570: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
3571: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
3572: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;

Line 3569: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;

3565: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
3566: v_show_cause_cutoff_dt_alias IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
3567: v_appeal_cutoff_dt_alias IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
3568: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
3569: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
3570: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
3571: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
3572: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
3573: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;

Line 3570: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;

3566: v_show_cause_cutoff_dt_alias IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
3567: v_appeal_cutoff_dt_alias IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
3568: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
3569: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
3570: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
3571: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
3572: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
3573: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
3574: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;

Line 3571: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;

3567: v_appeal_cutoff_dt_alias IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
3568: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
3569: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
3570: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
3571: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
3572: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
3573: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
3574: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
3575: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;

Line 3572: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;

3568: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
3569: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
3570: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
3571: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
3572: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
3573: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
3574: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
3575: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
3576: v_outcome_check_type IGS_PR_S_PRG_CONF.outcome_check_type%TYPE;

Line 3573: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;

3569: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
3570: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
3571: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
3572: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
3573: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
3574: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
3575: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
3576: v_outcome_check_type IGS_PR_S_PRG_CONF.outcome_check_type%TYPE;
3577:

Line 3574: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;

3570: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
3571: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
3572: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
3573: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
3574: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
3575: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
3576: v_outcome_check_type IGS_PR_S_PRG_CONF.outcome_check_type%TYPE;
3577:
3578: CURSOR c_sca_crv IS

Line 3575: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;

3571: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
3572: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
3573: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
3574: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
3575: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
3576: v_outcome_check_type IGS_PR_S_PRG_CONF.outcome_check_type%TYPE;
3577:
3578: CURSOR c_sca_crv IS
3579: SELECT sca.course_attempt_status,

Line 3576: v_outcome_check_type IGS_PR_S_PRG_CONF.outcome_check_type%TYPE;

3572: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
3573: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
3574: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
3575: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
3576: v_outcome_check_type IGS_PR_S_PRG_CONF.outcome_check_type%TYPE;
3577:
3578: CURSOR c_sca_crv IS
3579: SELECT sca.course_attempt_status,
3580: sca.version_number,