DBA Data[Home] [Help]

APPS.IGS_PR_GEN_006 dependencies on IGS_PR_S_PRG_CONF

Line 597: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;

593: v_start_dt DATE;
594: v_cutoff_dt DATE;
595: v_benefit_dt DATE;
596: v_penalty_dt DATE;
597: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
598: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
599: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
600: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
601: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;

Line 598: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;

594: v_cutoff_dt DATE;
595: v_benefit_dt DATE;
596: v_penalty_dt DATE;
597: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
598: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
599: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
600: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
601: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
602: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;

Line 599: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;

595: v_benefit_dt DATE;
596: v_penalty_dt DATE;
597: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
598: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
599: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
600: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
601: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
602: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
603: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;

Line 600: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;

596: v_penalty_dt DATE;
597: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
598: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
599: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
600: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
601: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
602: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
603: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
604: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;

Line 601: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;

597: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
598: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
599: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
600: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
601: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
602: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
603: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
604: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
605: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;

Line 602: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;

598: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
599: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
600: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
601: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
602: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
603: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
604: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
605: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
606: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;

Line 603: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;

599: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
600: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
601: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
602: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
603: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
604: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
605: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
606: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
607: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;

Line 604: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;

600: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;
601: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
602: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
603: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
604: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
605: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
606: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
607: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
608: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;

Line 605: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;

601: v_show_cause_cutoff_dt IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE;
602: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
603: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
604: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
605: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
606: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
607: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
608: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
609: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;

Line 606: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;

602: v_appeal_cutoff_dt IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE;
603: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
604: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
605: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
606: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
607: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
608: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
609: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
610: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;

Line 607: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;

603: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
604: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
605: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
606: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
607: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
608: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
609: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
610: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
611: v_outcome_check_type IGS_PR_S_PRG_CONF.outcome_check_type%TYPE;

Line 608: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;

604: v_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE;
605: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
606: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
607: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
608: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
609: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
610: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
611: v_outcome_check_type IGS_PR_S_PRG_CONF.outcome_check_type%TYPE;
612: FUNCTION prgpl_get_alias_value (

Line 609: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;

605: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
606: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
607: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
608: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
609: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
610: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
611: v_outcome_check_type IGS_PR_S_PRG_CONF.outcome_check_type%TYPE;
612: FUNCTION prgpl_get_alias_value (
613: p_dt_alias VARCHAR2)

Line 610: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;

606: v_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE;
607: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
608: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
609: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
610: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
611: v_outcome_check_type IGS_PR_S_PRG_CONF.outcome_check_type%TYPE;
612: FUNCTION prgpl_get_alias_value (
613: p_dt_alias VARCHAR2)
614: RETURN DATE

Line 611: v_outcome_check_type IGS_PR_S_PRG_CONF.outcome_check_type%TYPE;

607: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
608: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
609: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
610: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
611: v_outcome_check_type IGS_PR_S_PRG_CONF.outcome_check_type%TYPE;
612: FUNCTION prgpl_get_alias_value (
613: p_dt_alias VARCHAR2)
614: RETURN DATE
615: IS