DBA Data[Home] [Help]

APPS.IGS_PR_GEN_002 dependencies on IGS_CA_INST_ALL

Line 37: p_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,

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)

Line 38: p_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,

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;

Line 67: p_prg_cal_type IN IGS_CA_INST_ALL.cal_type%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 ,

Line 68: p_prg_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%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 ,

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

Line 73: p_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,
77: p_uoo_id IN NUMBER DEFAULT NULL)