DBA Data[Home] [Help]

APPS.IGS_AS_CALC_AWARD_MARK dependencies on IGS_EN_SU_ATTEMPT

Line 55: p_unit_attempt_status igs_en_su_attempt.unit_attempt_status%TYPE,

51: FUNCTION get_earned_cp (p_person_id igs_as_su_stmptout.person_id%TYPE,
52: p_course_cd igs_as_su_stmptout.course_cd%TYPE,
53: p_unit_cd igs_as_su_stmptout.unit_cd%TYPE,
54: p_version_number igs_ps_unit_ver.version_number%TYPE,
55: p_unit_attempt_status igs_en_su_attempt.unit_attempt_status%TYPE,
56: p_teach_cal_type igs_ca_inst.cal_type%TYPE,
57: p_teach_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
58: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
59: p_override_achievable_cp NUMBER DEFAULT NULL,

Line 73: FUNCTION chk_if_excluded_unit ( p_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE,

69: p_course_cd IN VARCHAR2,
70: p_unit_level IN VARCHAR2
71: ) RETURN NUMBER;
72:
73: FUNCTION chk_if_excluded_unit ( p_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE,
74: p_unit_cd IN igs_en_su_attempt_all.unit_cd%TYPE,
75: p_version_number IN igs_en_su_attempt_all.version_number%TYPE
76: ) RETURN VARCHAR2;
77:

Line 74: p_unit_cd IN igs_en_su_attempt_all.unit_cd%TYPE,

70: p_unit_level IN VARCHAR2
71: ) RETURN NUMBER;
72:
73: FUNCTION chk_if_excluded_unit ( p_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE,
74: p_unit_cd IN igs_en_su_attempt_all.unit_cd%TYPE,
75: p_version_number IN igs_en_su_attempt_all.version_number%TYPE
76: ) RETURN VARCHAR2;
77:
78:

Line 75: p_version_number IN igs_en_su_attempt_all.version_number%TYPE

71: ) RETURN NUMBER;
72:
73: FUNCTION chk_if_excluded_unit ( p_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE,
74: p_unit_cd IN igs_en_su_attempt_all.unit_cd%TYPE,
75: p_version_number IN igs_en_su_attempt_all.version_number%TYPE
76: ) RETURN VARCHAR2;
77:
78:
79: END igs_as_calc_award_mark;