1 PACKAGE IGS_AS_GEN_003 AS
2 /* $Header: IGSAS03S.pls 120.0 2005/07/05 12:12:27 appldev noship $ */
3
4 FUNCTION assp_get_ai_ref(
5 usaii in igs_ps_unitass_item.unit_section_ass_item_id%type,
6 uaii in igs_as_unitass_item.unit_ass_item_id%type
7 )
8 RETURN VARCHAR2 ;
9 PRAGMA RESTRICT_REFERENCES(assp_get_ai_ref,WNDS,WNPS);
10
11 FUNCTION assp_get_ai_reldate(
12 usaii in igs_ps_unitass_item.unit_section_ass_item_id%type,
13 uaii in igs_as_unitass_item.unit_ass_item_id%type
14 )
15 RETURN DATE ;
16 PRAGMA RESTRICT_REFERENCES(assp_get_ai_reldate,WNDS,WNPS);
17
18
19 FUNCTION assp_get_sua_exam_tp(
20 p_person_id IN NUMBER ,
21 p_course_cd IN VARCHAR2 ,
22 p_unit_cd IN VARCHAR2 ,
23 p_cal_type IN VARCHAR2 ,
24 p_ci_sequence_number IN NUMBER ,
25 p_unit_attempt_status IN VARCHAR2 ,
26 -- anilk, 22-Apr-2003, Bug# 2829262
27 p_uoo_id IN NUMBER )
28 RETURN VARCHAR2 ;
29 PRAGMA RESTRICT_REFERENCES(assp_get_sua_exam_tp,WNDS,WNPS);
30 FUNCTION assp_get_sua_exloc(
31 p_person_id IN NUMBER ,
32 p_course_cd IN VARCHAR2 ,
33 p_unit_cd IN VARCHAR2 ,
34 p_cal_type IN VARCHAR2 ,
35 p_ci_sequence_number IN NUMBER ,
36 p_ass_id IN NUMBER ,
37 -- anilk, 22-Apr-2003, Bug# 2829262
38 p_uoo_id IN NUMBER )
39 RETURN VARCHAR2 ;
40 PRAGMA RESTRICT_REFERENCES(assp_get_sua_exloc,WNDS,WNPS);
41 FUNCTION assp_get_sua_grade(
42 p_person_id IN NUMBER ,
43 p_course_cd IN VARCHAR2 ,
44 p_unit_cd IN VARCHAR2 ,
45 p_cal_type IN VARCHAR2 ,
46 p_ci_sequence_number IN NUMBER ,
47 p_unit_attempt_status IN VARCHAR2 ,
48 p_finalised_ind IN VARCHAR2 ,
49 p_grading_schema_cd OUT NOCOPY VARCHAR2 ,
50 p_gs_version_number OUT NOCOPY NUMBER ,
51 p_grade OUT NOCOPY VARCHAR2 ,
52 -- anilk, 22-Apr-2003, Bug# 2829262
53 p_uoo_id IN NUMBER )
54 RETURN VARCHAR2 ;
55 PRAGMA RESTRICT_REFERENCES(assp_get_sua_grade,WNDS,WNPS);
56 FUNCTION assp_get_sua_gs(
57 p_person_id IN NUMBER ,
58 p_course_cd IN VARCHAR2 ,
59 p_unit_cd IN VARCHAR2 ,
60 p_version_number IN NUMBER ,
61 p_cal_type IN VARCHAR2 ,
62 p_ci_sequence_number IN NUMBER ,
63 p_location_cd IN VARCHAR2 ,
64 p_unit_class IN VARCHAR2 ,
65 p_grading_schema OUT NOCOPY VARCHAR2 ,
66 p_gs_version_number OUT NOCOPY NUMBER )
67 RETURN boolean ;
68 PRAGMA RESTRICT_REFERENCES(assp_get_sua_gs,WNDS);
69 FUNCTION assp_get_sua_outcome(
70 p_person_id IN NUMBER ,
71 p_course_cd IN VARCHAR2 ,
72 p_unit_cd IN VARCHAR2 ,
73 p_cal_type IN VARCHAR2 ,
74 p_ci_sequence_number IN NUMBER ,
75 p_unit_attempt_status IN VARCHAR2 ,
76 p_finalised_ind IN VARCHAR2 ,
77 p_outcome_dt OUT NOCOPY DATE ,
78 p_grading_schema_cd OUT NOCOPY VARCHAR2 ,
79 p_gs_version_number OUT NOCOPY NUMBER ,
80 p_grade OUT NOCOPY VARCHAR2 ,
81 p_mark OUT NOCOPY NUMBER ,
82 p_origin_course_cd OUT NOCOPY VARCHAR2 ,
83 -- anilk, 22-Apr-2003, Bug# 2829262
84 p_uoo_id IN NUMBER ,
85 p_use_released_ind IN VARCHAR2 DEFAULT 'N')
86 RETURN VARCHAR2 ;
87 PRAGMA RESTRICT_REFERENCES(assp_get_sua_outcome,WNDS,WNPS);
88 FUNCTION assp_get_supp_cal(
89 p_exam_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
90 p_exam_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
91 p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
92 p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
93 p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
94 p_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
95 p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
96 p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
97 p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
98 p_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
99 p_unit_mode IN IGS_AS_UNIT_CLASS_ALL.unit_mode%TYPE ,
100 p_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
101 p_ass_id IN IGS_AS_UNITASS_ITEM_ALL.ass_id%TYPE )
102 RETURN VARCHAR2 ;
103 PRAGMA RESTRICT_REFERENCES(assp_get_supp_cal,WNDS,WNPS);
104 FUNCTION assp_get_trn_sua_out(
105 p_person_id IN NUMBER ,
106 p_course_cd IN VARCHAR2 ,
107 p_unit_cd IN VARCHAR2 ,
108 p_cal_type IN VARCHAR2 ,
109 p_ci_sequence_number IN NUMBER ,
110 p_unit_attempt_status IN VARCHAR2 ,
111 p_final_outcome IN VARCHAR2 ,
112 -- anilk, 22-Apr-2003, Bug# 2829262
113 p_uoo_id IN NUMBER )
114 RETURN VARCHAR2 ;
115
116 FUNCTION assp_get_uai_due_dt(
117 p_person_id IN NUMBER ,
118 p_course_cd IN VARCHAR2 ,
119 p_unit_cd IN VARCHAR2 ,
120 p_cal_type IN VARCHAR2 ,
121 p_ci_sequence_number IN NUMBER ,
122 p_ass_id IN NUMBER ,
123 -- anilk, 22-Apr-2003, Bug# 2829262
124 p_uoo_id IN NUMBER )
125 RETURN DATE ;
126 PRAGMA RESTRICT_REFERENCES(assp_get_uai_due_dt,WNDS,WNPS);
127 FUNCTION assp_get_uai_ref(
128 p_person_id IN NUMBER ,
129 p_course_cd IN VARCHAR2 ,
130 p_unit_cd IN VARCHAR2 ,
131 p_cal_type IN VARCHAR2 ,
132 p_ci_sequence_number IN NUMBER ,
133 p_ass_id IN NUMBER ,
134 -- anilk, 22-Apr-2003, Bug# 2829262
135 p_uoo_id IN NUMBER )
136 RETURN VARCHAR2 ;
137 PRAGMA RESTRICT_REFERENCES(assp_get_uai_ref,WNDS,WNPS);
138
139 FUNCTION assp_get_spcl_needs(
140 p_person_id IN NUMBER )
141 RETURN VARCHAR2 ;
142 PRAGMA RESTRICT_REFERENCES(assp_get_spcl_needs,WNDS);
143
144 PROCEDURE get_default_grds(
145 x_unit_cd IN VARCHAR2,
146 x_version_number IN NUMBER,
147 x_assessment_type IN VARCHAR2,
148 x_grading_schema_cd OUT NOCOPY VARCHAR2,
149 x_gs_version_number OUT NOCOPY NUMBER,
150 x_description OUT NOCOPY VARCHAR2,
151 x_approved OUT NOCOPY VARCHAR2
152 );
153 PROCEDURE assp_get_suaai_gs(
154 p_person_id IN NUMBER,
155 p_course_cd IN VARCHAR2,
156 p_unit_cd IN VARCHAR2,
157 p_cal_type IN VARCHAR2,
158 p_ci_sequence_number IN NUMBER,
159 p_ass_id IN VARCHAR2,
160 p_grading_schema_cd OUT NOCOPY VARCHAR2,
161 p_gs_version_number OUT NOCOPY NUMBER,
162 -- anilk, 22-Apr-2003, Bug# 2829262
163 p_uoo_id IN NUMBER );
164
165 FUNCTION getStdntCareerPrograms(
166 P_PERSON_ID IN IGS_EN_STDNT_PS_ATT.person_id%TYPE ,
167 P_PROGRAM_TYPE IN IGS_PS_VER_ALL.course_type%TYPE ) RETURN VARCHAR2 ;
168
169 FUNCTION getStdntCareerProgsBetween(
170 P_PERSON_ID IN igs_en_stdnt_ps_att.person_id%TYPE ,
171 P_COURSE_CD IN igs_en_stdnt_ps_att.course_cd%TYPE ,
172 P_TERM_START_DATE IN DATE ,
173 P_TERM_END_DATE IN DATE ) RETURN VARCHAR2 ;
174
175 FUNCTION getStdntPrograms(
176 P_PERSON_ID IGS_EN_STDNT_PS_ATT.PERSON_ID%TYPE ,
177 P_PROGRAM_CD IGS_PS_VER_ALL.COURSE_CD%TYPE ) RETURN VARCHAR2 ;
178
179 FUNCTION getStdntProgsBetween(
180 P_PERSON_ID igs_en_stdnt_ps_att.person_id%type ,
181 P_program_cd igs_ps_ver_all.course_type%type ,
182 p_term_start_date DATE ,
183 p_term_end_date DATE ) RETURN VARCHAR2 ;
184
185 PROCEDURE get_current_term (
186 p_person_id IN NUMBER,
187 p_course_cd IN VARCHAR2,
188 p_cal_type OUT NOCOPY VARCHAR2,
189 p_seq_num OUT NOCOPY NUMBER
190 );
191 FUNCTION get_spat_att_type_desc (
192 p_person_id IN NUMBER,
193 p_program_cd IN VARCHAR2
194 ) RETURN VARCHAR2;
195
196
197 FUNCTION get_spat_att_mode_desc(
198 p_person_id IN NUMBER,
199 p_program_cd IN VARCHAR2
200 ) RETURN VARCHAR2;
201
202 FUNCTION get_spat_location_desc(
203 p_person_id IN NUMBER,
204 p_program_cd IN VARCHAR2
205 ) RETURN VARCHAR2;
206 FUNCTION assp_get_sua_rel_grade(
207 p_person_id IN NUMBER ,
208 p_course_cd IN VARCHAR2 ,
209 p_unit_cd IN VARCHAR2 ,
210 p_cal_type IN VARCHAR2 ,
211 p_ci_sequence_number IN NUMBER ,
212 p_unit_attempt_status IN VARCHAR2 ,
213 p_finalised_ind IN VARCHAR2 ,
214 p_grading_schema_cd OUT NOCOPY VARCHAR2 ,
215 p_gs_version_number OUT NOCOPY NUMBER ,
216 p_grade OUT NOCOPY VARCHAR2 ,
217 p_uoo_id IN NUMBER )
218 RETURN VARCHAR2 ;
219 PRAGMA RESTRICT_REFERENCES(assp_get_sua_rel_grade,WNDS,WNPS);
220 FUNCTION assp_get_sua_rel_marks(
221 p_person_id IN NUMBER ,
222 p_course_cd IN VARCHAR2 ,
223 p_unit_cd IN VARCHAR2 ,
224 p_cal_type IN VARCHAR2 ,
225 p_ci_sequence_number IN NUMBER ,
226 p_unit_attempt_status IN VARCHAR2 ,
227 p_finalised_ind IN VARCHAR2 ,
228 p_grading_schema_cd OUT NOCOPY VARCHAR2 ,
229 p_gs_version_number OUT NOCOPY NUMBER ,
230 p_grade OUT NOCOPY VARCHAR2 ,
231 p_uoo_id IN NUMBER )
232 RETURN NUMBER ;
233 PRAGMA RESTRICT_REFERENCES(assp_get_sua_rel_marks,WNDS,WNPS);
234 END IGS_AS_GEN_003 ;