23: PRAGMA RESTRICT_REFERENCES (ENRP_GET_SUAEH_COL,WNDS);
24: --
25: -- Routine to get the effective end date for a SUA history
26: FUNCTION enrp_get_suaeh_eff_end(
27: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
28: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
29: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
30: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
31: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
24: --
25: -- Routine to get the effective end date for a SUA history
26: FUNCTION enrp_get_suaeh_eff_end(
27: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
28: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
29: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
30: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
31: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
32: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE ,
25: -- Routine to get the effective end date for a SUA history
26: FUNCTION enrp_get_suaeh_eff_end(
27: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
28: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
29: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
30: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
31: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
32: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE ,
33: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE,
26: FUNCTION enrp_get_suaeh_eff_end(
27: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
28: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
29: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
30: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
31: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
32: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE ,
33: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE,
34: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)
27: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
28: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
29: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
30: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
31: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
32: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE ,
33: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE,
34: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)
35: RETURN DATE;
28: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
29: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
30: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
31: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
32: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE ,
33: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE,
34: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)
35: RETURN DATE;
36: PRAGMA RESTRICT_REFERENCES (ENRP_GET_SUAEH_EFF_END,WNDS);
36: PRAGMA RESTRICT_REFERENCES (ENRP_GET_SUAEH_EFF_END,WNDS);
37:
38: -- Routine to get the effective start date for a SUA history
39: FUNCTION enrp_get_suaeh_eff_st(
40: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
41: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
42: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
43: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
44: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
37:
38: -- Routine to get the effective start date for a SUA history
39: FUNCTION enrp_get_suaeh_eff_st(
40: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
41: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
42: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
43: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
44: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
45: p_hist_start_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_start_dt%TYPE ,
38: -- Routine to get the effective start date for a SUA history
39: FUNCTION enrp_get_suaeh_eff_st(
40: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
41: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
42: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
43: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
44: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
45: p_hist_start_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_start_dt%TYPE ,
46: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE,
39: FUNCTION enrp_get_suaeh_eff_st(
40: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
41: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
42: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
43: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
44: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
45: p_hist_start_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_start_dt%TYPE ,
46: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE,
47: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)
40: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
41: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
42: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
43: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
44: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
45: p_hist_start_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_start_dt%TYPE ,
46: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE,
47: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)
48: RETURN DATE;
41: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
42: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
43: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
44: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
45: p_hist_start_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_start_dt%TYPE ,
46: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE,
47: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)
48: RETURN DATE;
49: PRAGMA RESTRICT_REFERENCES (ENRP_GET_SUAEH_EFF_ST,WNDS);