63: END enrp_get_student_ind;
64:
65: FUNCTION Enrp_Get_Suah_Col(
66: p_column_name IN user_tab_columns.column_name%TYPE ,
67: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
68: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
69: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
70: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
71: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
64:
65: FUNCTION Enrp_Get_Suah_Col(
66: p_column_name IN user_tab_columns.column_name%TYPE ,
67: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
68: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
69: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
70: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
71: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
72: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE,
65: FUNCTION Enrp_Get_Suah_Col(
66: p_column_name IN user_tab_columns.column_name%TYPE ,
67: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
68: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
69: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
70: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
71: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
72: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE,
73: p_uoo_id IN IGS_EN_SU_ATTEMPT_H_ALL.UOO_ID%TYPE)
66: p_column_name IN user_tab_columns.column_name%TYPE ,
67: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
68: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
69: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
70: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
71: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
72: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE,
73: p_uoo_id IN IGS_EN_SU_ATTEMPT_H_ALL.UOO_ID%TYPE)
74: -------------------------------------------------------------------------------------------
67: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
68: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
69: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
70: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
71: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
72: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE,
73: p_uoo_id IN IGS_EN_SU_ATTEMPT_H_ALL.UOO_ID%TYPE)
74: -------------------------------------------------------------------------------------------
75: --Change History:
68: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
69: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
70: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
71: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
72: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE,
73: p_uoo_id IN IGS_EN_SU_ATTEMPT_H_ALL.UOO_ID%TYPE)
74: -------------------------------------------------------------------------------------------
75: --Change History:
76: --Who When What
69: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
70: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
71: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
72: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE,
73: p_uoo_id IN IGS_EN_SU_ATTEMPT_H_ALL.UOO_ID%TYPE)
74: -------------------------------------------------------------------------------------------
75: --Change History:
76: --Who When What
77: --kkillams 25-04-2003 New paramater p_uoo_id is added to the function and c_suah cursor modified.