DBA Data[Home] [Help]

APPS.IGS_PR_GEN_002 dependencies on IGS_CA_INST_ALL

Line 75: p_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,

71: FUNCTION prgp_get_sua_gpa_val(
72: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
73: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
74: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
75: p_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
76: p_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
77: p_best_worst IN VARCHAR2 ,
78: p_recommended_ind IN VARCHAR2,
79: p_uoo_id IN NUMBER)

Line 76: p_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,

72: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
73: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
74: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
75: p_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
76: p_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
77: p_best_worst IN VARCHAR2 ,
78: p_recommended_ind IN VARCHAR2,
79: p_uoo_id IN NUMBER)
80: RETURN IGS_AS_GRD_SCH_GRADE.gpa_val%TYPE AS

Line 432: p_prg_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,

428: -- kdande; 22-Apr-2003; Bug# 2829262
429: -- Added p_uoo_id parameter to the FUNCTION prgp_get_sua_prg_prd
430: --
431: FUNCTION prgp_get_sua_prg_prd(
432: p_prg_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
433: p_prg_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
434: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
435: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
436: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,

Line 433: p_prg_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,

429: -- Added p_uoo_id parameter to the FUNCTION prgp_get_sua_prg_prd
430: --
431: FUNCTION prgp_get_sua_prg_prd(
432: p_prg_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
433: p_prg_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
434: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
435: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
436: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
437: p_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,

Line 437: p_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,

433: p_prg_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
434: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
435: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
436: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
437: p_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
438: p_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
439: p_details_ind IN VARCHAR2 ,
440: p_unit_attempt_status IN VARCHAR2 ,
441: p_discontinued_dt IN DATE,

Line 438: p_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,

434: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
435: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
436: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
437: p_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
438: p_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
439: p_details_ind IN VARCHAR2 ,
440: p_unit_attempt_status IN VARCHAR2 ,
441: p_discontinued_dt IN DATE,
442: p_uoo_id IN NUMBER)