DBA Data[Home] [Help]

APPS.IGS_PR_GEN_002 dependencies on IGS_EN_SU_ATTEMPT_ALL

Line 34: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,

30: -- kdande; 22-Apr-2003; Bug# 2829262
31: -- Added p_uoo_id parameter to the FUNCTION prgp_get_sua_gpa_val
32: --
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 ,

Line 35: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,

31: -- Added p_uoo_id parameter to the FUNCTION prgp_get_sua_gpa_val
32: --
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 ,

Line 36: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,

32: --
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,

Line 69: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,

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 ,
73: p_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,

Line 70: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,

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 ,
73: p_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
74: p_details_ind IN VARCHAR2 ,

Line 71: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,

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 ,
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 ,