1 PACKAGE IGS_AS_CALC_AWARD_MARK AS
2 /* $Header: IGSAS57S.pls 120.1 2006/07/31 07:31:41 ijeddy noship $ */
3
4 /*************************************************************
5 Created By : smanglm
6 Date Created on : 10-Oct-2003
7 Purpose : This package is created as part iof Summary Measurement
8 of attainment build.
9 This will have program unit to calculate
10 unit level marks,
11 award marks and honors level.
12 Change History
13 Who When What
14
15 (reverse chronological order - newest change first)
16 ***************************************************************/
17
18 FUNCTION fn_calc_award_mark (p_person_id IN NUMBER,
19 p_course_cd IN VARCHAR2,
20 p_award_cd IN VARCHAR2,
21 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
22 X_MSG_DATA OUT NOCOPY VARCHAR2,
23 X_MSG_COUNT OUT NOCOPY NUMBER) RETURN NUMBER ;
24
25 FUNCTION fn_derive_honors_level (p_person_id IN NUMBER,
26 p_course_cd IN VARCHAR2,
27 p_award_cd IN VARCHAR2 ) RETURN VARCHAR2;
28
29 PROCEDURE pr_calc_award_mark (p_person_id IN NUMBER,
30 p_course_cd IN VARCHAR2,
31 p_award_cd IN VARCHAR2,
32 p_award_mark OUT NOCOPY NUMBER,
33 p_honors_level OUT NOCOPY VARCHAR2,
34 p_grading_schema_cd OUT NOCOPY VARCHAR2,
35 p_version_number OUT NOCOPY NUMBER,
36 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
37 X_MSG_DATA OUT NOCOPY VARCHAR2,
38 X_MSG_COUNT OUT NOCOPY NUMBER);
39
40 FUNCTION fn_calc_unit_lvl_mark (p_person_id IN NUMBER,
41 p_course_cd IN VARCHAR2,
42 p_unit_level IN VARCHAR2,
43 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
44 X_MSG_DATA OUT NOCOPY VARCHAR2,
45 X_MSG_COUNT OUT NOCOPY NUMBER) RETURN NUMBER;
46
47 FUNCTION get_mark (p_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE,
48 p_gs_version_number igs_as_su_stmptout.version_number%TYPE,
49 p_grade igs_as_su_stmptout.grade%TYPE) RETURN NUMBER;
50
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,
60 p_override_enrolled_cp NUMBER DEFAULT NULL) RETURN NUMBER;
61
62 Procedure upgrade_awards
63 ( errbuff OUT NOCOPY VARCHAR2,
64 retcode OUT NOCOPY NUMBER,
65 p_award_cd igs_ps_awd.AWARD_CD%TYPE
66
67 );
68 FUNCTION fn_ret_unit_lvl_mark (p_person_id IN NUMBER,
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
78
79 END igs_as_calc_award_mark;