33: FUNCTION prgp_get_sua_gpa_val(
34: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
35: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
36: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
37: p_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
38: p_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
39: p_best_worst IN VARCHAR2 ,
40: p_recommended_ind IN VARCHAR2,
41: p_uoo_id IN NUMBER DEFAULT NULL)
34: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
35: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
36: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
37: p_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
38: p_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
39: p_best_worst IN VARCHAR2 ,
40: p_recommended_ind IN VARCHAR2,
41: p_uoo_id IN NUMBER DEFAULT NULL)
42: RETURN IGS_AS_GRD_SCH_GRADE.gpa_val%TYPE;
63: -- kdande; 22-Apr-2003; Bug# 2829262
64: -- Added p_uoo_id parameter to the FUNCTION prgp_get_sua_prg_prd
65: --
66: FUNCTION prgp_get_sua_prg_prd(
67: p_prg_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
68: p_prg_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
69: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
70: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
71: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
64: -- Added p_uoo_id parameter to the FUNCTION prgp_get_sua_prg_prd
65: --
66: FUNCTION prgp_get_sua_prg_prd(
67: p_prg_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
68: p_prg_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
69: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
70: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
71: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
72: p_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
68: p_prg_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
69: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
70: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
71: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
72: p_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
73: p_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
74: p_details_ind IN VARCHAR2 ,
75: p_unit_attempt_status IN VARCHAR2 ,
76: p_discontinued_dt IN DATE,
69: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
70: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
71: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
72: p_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
73: p_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
74: p_details_ind IN VARCHAR2 ,
75: p_unit_attempt_status IN VARCHAR2 ,
76: p_discontinued_dt IN DATE,
77: p_uoo_id IN NUMBER DEFAULT NULL)