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.

APPS.IGS_PR_GEN_003 dependencies on IGS_PR_S_PRG_CONF

Line 312: FROM IGS_PR_S_PRG_CONF sprgc

308: sprgc.count_exc_in_time_ind,
309: sprgc.calculate_wam_ind,
310: sprgc.calculate_gpa_ind,
311: sprgc.outcome_check_type
312: FROM IGS_PR_S_PRG_CONF sprgc
313: WHERE sprgc.s_control_num = 1;
314: CURSOR c_sopc (
315: cp_org_unit_cd IGS_PR_S_OU_PRG_CONF.org_unit_cd%TYPE,
316: cp_ou_start_dt IGS_PR_S_OU_PRG_CONF.ou_start_dt%TYPE) IS

Line 605: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;

601: --
602: --The routine checks the system parameters applying to the students
603: -- course version and inserts the appropriate GPA/WAM values accordingly.
604: DECLARE
605: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
606: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
607: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
608: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
609: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;

Line 606: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;

602: --The routine checks the system parameters applying to the students
603: -- course version and inserts the appropriate GPA/WAM values accordingly.
604: DECLARE
605: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
606: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
607: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
608: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
609: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
610: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;

Line 607: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;

603: -- course version and inserts the appropriate GPA/WAM values accordingly.
604: DECLARE
605: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
606: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
607: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
608: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
609: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
610: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
611: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;

Line 608: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;

604: DECLARE
605: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
606: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
607: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
608: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
609: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
610: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
611: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
612: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;

Line 609: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;

605: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
606: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
607: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
608: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
609: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
610: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
611: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
612: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
613: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;

Line 610: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;

606: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
607: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
608: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
609: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
610: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
611: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
612: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
613: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
614: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;

Line 611: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;

607: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
608: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
609: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
610: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
611: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
612: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
613: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
614: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
615: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;

Line 612: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;

608: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
609: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
610: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
611: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
612: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
613: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
614: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
615: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
616: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;

Line 613: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;

609: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
610: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
611: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
612: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
613: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
614: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
615: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
616: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
617: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;

Line 614: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;

610: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
611: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
612: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
613: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
614: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
615: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
616: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
617: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
618: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;

Line 615: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;

611: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
612: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
613: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
614: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
615: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
616: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
617: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
618: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
619: v_outcome_check_type IGS_PR_S_PRG_CONF.outcome_check_type%TYPE;

Line 616: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;

612: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
613: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
614: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
615: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
616: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
617: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
618: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
619: v_outcome_check_type IGS_PR_S_PRG_CONF.outcome_check_type%TYPE;
620: v_course_gpa NUMBER;

Line 617: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;

613: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
614: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
615: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
616: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
617: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
618: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
619: v_outcome_check_type IGS_PR_S_PRG_CONF.outcome_check_type%TYPE;
620: v_course_gpa NUMBER;
621: v_period_gpa NUMBER;

Line 618: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;

614: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
615: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
616: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
617: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
618: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
619: v_outcome_check_type IGS_PR_S_PRG_CONF.outcome_check_type%TYPE;
620: v_course_gpa NUMBER;
621: v_period_gpa NUMBER;
622: v_course_wam NUMBER;

Line 619: v_outcome_check_type IGS_PR_S_PRG_CONF.outcome_check_type%TYPE;

615: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
616: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
617: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
618: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
619: v_outcome_check_type IGS_PR_S_PRG_CONF.outcome_check_type%TYPE;
620: v_course_gpa NUMBER;
621: v_period_gpa NUMBER;
622: v_course_wam NUMBER;
623: v_period_wam NUMBER;