1 PACKAGE igs_en_hesa_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSHE16S.pls 115.4 2002/11/22 12:17:50 knaraset noship $ */
3
4 PROCEDURE hesa_susa_enr(
5 p_person_id IN NUMBER,
6 p_course_cd IN VARCHAR2,
7 p_crv_version_number IN NUMBER,
8 p_old_unit_set_cd IN VARCHAR2,
9 p_old_us_version_number IN NUMBER,
10 p_old_sequence_number IN NUMBER ,
11 p_new_unit_set_cd IN VARCHAR2,
12 p_new_us_version_number IN NUMBER,
13 p_new_sequence_number IN NUMBER,
14 p_message OUT NOCOPY VARCHAR2,
15 p_status OUT NOCOPY NUMBER);
16
17 PROCEDURE hesa_stats_enr(
18 p_person_id IN NUMBER,
19 p_course_cd IN VARCHAR2,
20 p_crv_version_number IN NUMBER,
21 p_message OUT NOCOPY VARCHAR2,
22 p_status OUT NOCOPY NUMBER);
23
24 /*------------------------------------------------------------------
25 --Created by : knaraset, Oracle IDC
26 --Date created: 14-Nov-2002
27 --
28 --Purpose: Function to validate whether the given award code exists
29 -- against system award type COURSE
30 --
31 --Known limitations/enhancements and/or remarks:
32 --
33 --Change History:
34 --Who When What
35 --
36 ------------------------------------------------------------------ */
37 FUNCTION validate_program_aim(
38 p_award_cd IN VARCHAR2)
39 RETURN BOOLEAN;
40
41 /*------------------------------------------------------------------
42 --Created by : knaraset, Oracle IDC
43 --Date created: 14-Nov-2002
44 --
45 --Purpose: function to validate whether the specified combination of subj_qualaim's and qualaim_proportion is valid
46 --
47 --Known limitations/enhancements and/or remarks:
48 --
49 --Change History:
50 --Who When What
51 --
52 ------------------------------------------------------------------ */
53 FUNCTION val_sub_qual_proportion(
54 p_subj_qualaim1 IN VARCHAR2,
55 p_subj_qualaim2 IN VARCHAR2,
56 p_subj_qualaim3 IN VARCHAR2,
57 p_qualaim_proportion IN VARCHAR2)
58 RETURN BOOLEAN;
59
60 /*------------------------------------------------------------------
61 --Created by : knaraset, Oracle IDC
62 --Date created: 14-Nov-2002
63 --
64 --Purpose: function to check whether the given highest qual on entry is exists against the
65 -- grading schema defined for HESA code HESA_HIGH_QUAL_ON_ENT.
66 --
67 --Known limitations/enhancements and/or remarks:
68 --
69 --Change History:
70 --Who When What
71 --
72 ------------------------------------------------------------------ */
73 FUNCTION val_highest_qual_entry(
74 p_highest_qual_on_entry IN VARCHAR2)
75 RETURN BOOLEAN;
76
77 /*------------------------------------------------------------------
78 --Created by : knaraset, Oracle IDC
79 --Date created: 14-Nov-2002
80 --
81 --Purpose: function to get the unit set category for the given unit set
82 --
83 --Known limitations/enhancements and/or remarks:
84 --
85 --Change History:
86 --Who When What
87 --
88 ------------------------------------------------------------------ */
89 FUNCTION get_unit_set_cat(
90 p_unit_set_cd IN VARCHAR2,
91 p_us_version_number IN NUMBER)
92 RETURN VARCHAR2;
93
94 /*------------------------------------------------------------------
95 --Created by : knaraset, Oracle IDC
96 --Date created: 14-Nov-2002
97 --
98 --Purpose: function to check whether the given institution exists with institution type Post-Secondary
99 --
100 --Known limitations/enhancements and/or remarks:
101 --
102 --Change History:
103 --Who When What
104 --
105 ------------------------------------------------------------------ */
106 FUNCTION check_teach_inst(
107 p_teaching_inst IN VARCHAR2)
108 RETURN BOOLEAN;
109
110 /*------------------------------------------------------------------
111 --Created by : knaraset, Oracle IDC
112 --Date created: 14-Nov-2002
113 --
114 --Purpose: function to check whether the given grade is exists against the grading schema defined in Unit set statistics.
115 --
116 --Known limitations/enhancements and/or remarks:
117 --
118 --Change History:
119 --Who When What
120 --
121 ------------------------------------------------------------------ */
122 FUNCTION check_grading_sch_grade(
123 p_person_id IN NUMBER,
124 p_program_cd IN VARCHAR2,
125 p_unit_set_cd IN VARCHAR2,
126 p_grad_sch_grade IN VARCHAR2)
127 RETURN BOOLEAN;
128
129 END igs_en_hesa_pkg;
130