1 PACKAGE IGS_EN_VAL_SUSA AUTHID CURRENT_USER AS
2 /* $Header: IGSEN69S.pls 115.5 2002/11/29 00:08:19 nsidana ship $ */
3 --
4 -------------------------------------------------------------------------------------------
5 --Change History:
6 --Who When What
7 --smadathi 28-AUG-2001 Bug No. 1956374 .Function genp_val_staff_prsn Removed
8 --smadathi 24-AUG-2001 Bug No. 1956374 .Function genp_val_sdtt_sess Removed
9 --msrinivi 27-AUG-2001 Bug 1956374 Func genp_val_prsn_id removed
10 --prraj 15-Nov-2002 Added p_legacy parameter to functions enrp_val_susa_ins, enrp_val_susa_auth,
11 -- enrp_val_susa_cmplt, enrp_val_susa_sci_sd, enrp_val_susa_cousr, enrp_val_susa_parent,
12 -- enrp_val_susa_end_dt, enrp_val_susa_sci, enrp_val_susa_prmry as part of Legacy
13 -- build Bug# 2661533
14 -------------------------------------------------------------------------------------------
15 TYPE t_susa_rowid_record IS RECORD
16 (
17 v_rowid ROWID,
18 v_parent_unit_set_cd IGS_AS_SU_SETATMPT.PARENT_UNIT_SET_CD%TYPE,
19 v_end_dt IGS_AS_SU_SETATMPT.END_DT%TYPE,
20 v_student_confirmed_ind IGS_AS_SU_SETATMPT.STUDENT_CONFIRMED_IND%TYPE,
21 v_primary_set_ind IGS_AS_SU_SETATMPT.PRIMARY_SET_IND%TYPE);
22 --
23 --
24
25
26 --
27 -- Validate the authorisation fields.
28 FUNCTION enrp_val_susa_auth(
29 p_unit_set_cd IN VARCHAR2 ,
30 p_us_version_number IN NUMBER ,
31 p_end_dt IN IGS_AS_SU_SETATMPT.end_dt%TYPE ,
32 p_authorised_person_id IN NUMBER ,
33 p_authorised_on IN DATE ,
34 p_message_name OUT NOCOPY VARCHAR2,
35 p_legacy IN VARCHAR2 DEFAULT 'N')
36 RETURN BOOLEAN;
37 --
38 --PRAGMA RESTRICT_REFERENCES(enrp_val_susa_auth , WNDS);
39 -- Validate the requirement complete fields for IGS_AS_SU_SETATMPT.
40 FUNCTION enrp_val_susa_cmplt(
41 p_rqrmnts_complete_dt IN DATE ,
42 p_rqrmnts_complete_ind IN VARCHAR2 DEFAULT 'N',
43 p_student_confirmed_ind IN VARCHAR2 DEFAULT 'N',
44 p_message_name OUT NOCOPY VARCHAR2,
45 p_legacy IN VARCHAR2 DEFAULT 'N')
46 RETURN BOOLEAN;
47 --
48 --PRAGMA RESTRICT_REFERENCES(enrp_val_susa_cmplt , WNDS);
49
50 -- Validate the susa relationship exists in cousr
51 FUNCTION ENRP_VAL_SUSA_COUSR(
52 p_person_id IN NUMBER ,
53 p_course_cd IN VARCHAR2 ,
54 p_unit_set_cd IN VARCHAR2 ,
55 p_us_version_number IN NUMBER ,
56 p_parent_unit_set_cd IN VARCHAR2 ,
57 p_parent_sequence_number IN NUMBER ,
58 p_message_type IN VARCHAR2 ,
59 p_message_name OUT NOCOPY VARCHAR2,
60 p_legacy IN VARCHAR2 DEFAULT 'N')
61 RETURN BOOLEAN;
62 --PRAGMA RESTRICT_REFERENCES( ENRP_VAL_SUSA_COUSR , WNDS);
63
64 --
65 -- Validate the student unit set attempt is able to be deleted.
66 FUNCTION ENRP_VAL_SUSA_DEL(
67 p_person_id IN NUMBER ,
68 p_course_cd IN VARCHAR2 ,
69 p_unit_set_cd IN VARCHAR2 ,
70 p_sequence_number IN NUMBER ,
71 p_us_version_number IN NUMBER ,
72 p_end_dt IN DATE ,
73 p_rqrmnts_complete_ind IN VARCHAR2 DEFAULT 'N',
74 p_db_trg_call IN VARCHAR2 ,
75 p_message_name OUT NOCOPY VARCHAR2)
76 RETURN BOOLEAN;
77 --PRAGMA RESTRICT_REFERENCES( ENRP_VAL_SUSA_DEL , WNDS);
78 --
79 -- Validate the date fields associated with a student unit set attempt.
80 FUNCTION ENRP_VAL_SUSA_DTS(
81 p_selection_dt IN DATE ,
82 p_end_dt IN DATE ,
83 p_rqrmnts_complete_dt IN DATE ,
84 p_message_name OUT NOCOPY VARCHAR2)
85 RETURN BOOLEAN;
86 --PRAGMA RESTRICT_REFERENCES( ENRP_VAL_SUSA_DTS, WNDS);
87
88 --
89 -- Validate the student unit set attempt end date.
90 FUNCTION ENRP_VAL_SUSA_END_DT(
91 p_person_id IN NUMBER ,
92 p_course_cd IN VARCHAR2 ,
93 p_unit_set_cd IN VARCHAR2 ,
94 p_sequence_number IN NUMBER ,
95 p_us_version_number IN NUMBER ,
96 p_end_dt IN DATE ,
97 p_authorised_person_id IN NUMBER ,
98 p_authorised_on IN DATE ,
99 p_parent_unit_set_cd IN VARCHAR2 ,
100 p_parent_sequence_number IN NUMBER ,
101 p_message_type IN VARCHAR2 ,
102 p_message_name OUT NOCOPY VARCHAR2,
103 p_legacy IN VARCHAR2 DEFAULT 'N')
104 RETURN BOOLEAN;
105 --PRAGMA RESTRICT_REFERENCES( ENRP_VAL_SUSA_END_DT , WNDS);
106
107 --
108 -- Validate student unit set atmpt voluntary end indicator and end date.
109 FUNCTION ENRP_VAL_SUSA_END_VI(
110 p_voluntary_end_ind IN VARCHAR2 DEFAULT 'N',
111 p_end_dt IN DATE ,
112 p_message_name OUT NOCOPY VARCHAR2)
113 RETURN BOOLEAN;
114 --PRAGMA RESTRICT_REFERENCES( ENRP_VAL_SUSA_END_VI , WNDS);
115
116 --
117 -- Validate the student unit set attempt is able to be created.
118 FUNCTION ENRP_VAL_SUSA_INS(
119 p_person_id IN NUMBER ,
120 p_course_cd IN VARCHAR2 ,
121 p_unit_set_cd IN VARCHAR2 ,
122 p_sequence_number IN NUMBER ,
123 p_us_version_number IN NUMBER ,
124 p_message_name OUT NOCOPY VARCHAR2,
125 p_legacy IN VARCHAR2 DEFAULT 'N')
126 RETURN BOOLEAN;
127 --PRAGMA RESTRICT_REFERENCES( ENRP_VAL_SUSA_INS, WNDS);
128 --
129 -- Validate the linking of parent unit set to student unit set attempt .
130 FUNCTION ENRP_VAL_SUSA_PARENT(
131 p_person_id IN NUMBER ,
132 p_course_cd IN VARCHAR2 ,
133 p_unit_set_cd IN VARCHAR2 ,
134 p_sequence_number IN NUMBER ,
135 p_parent_unit_set_cd IN VARCHAR2 ,
136 p_parent_sequence_number IN NUMBER ,
137 p_student_confirmed_ind IN VARCHAR2 DEFAULT 'N',
138 p_message_name OUT NOCOPY VARCHAR2,
139 p_legacy IN VARCHAR2 DEFAULT 'N')
140 RETURN BOOLEAN;
141 --PRAGMA RESTRICT_REFERENCES( ENRP_VAL_SUSA_PARENT , WNDS);
142 --
143 -- Validate the IGS_AS_SU_SETATMPT.primary_set_ind field.
144 FUNCTION ENRP_VAL_SUSA_PRMRY(
145 p_person_id IN NUMBER ,
146 p_course_cd IN VARCHAR2 ,
147 p_unit_set_cd IN VARCHAR2 ,
148 p_us_version_number IN NUMBER ,
149 p_primary_set_ind IN VARCHAR2 DEFAULT 'N',
150 p_message_name OUT NOCOPY VARCHAR2,
151 p_legacy IN VARCHAR2 DEFAULT 'N')
152 RETURN BOOLEAN;
153 --PRAGMA RESTRICT_REFERENCES( ENRP_VAL_SUSA_PRMRY , WNDS);
154 --
155 -- Validate the student unit set attempt against for the stdnt crs atmpt.
156 FUNCTION ENRP_VAL_SUSA_SCA(
157 p_person_id IN NUMBER ,
158 p_course_cd IN VARCHAR2 ,
159 p_message_name OUT NOCOPY VARCHAR2)
160 RETURN BOOLEAN;
161 --PRAGMA RESTRICT_REFERENCES( ENRP_VAL_SUSA_SCA , WNDS);
162
163 --
164 -- Validate the student unit set attempt confirmation indicator.
165 FUNCTION ENRP_VAL_SUSA_SCI(
166 p_person_id IN NUMBER ,
167 p_course_cd IN VARCHAR2 ,
168 p_unit_set_cd IN VARCHAR2 ,
169 p_sequence_number IN NUMBER ,
170 p_us_version_number IN NUMBER ,
171 p_parent_unit_set_cd IN VARCHAR2 ,
172 p_parent_sequence_number IN NUMBER ,
173 p_student_confirmed_ind IN VARCHAR2 DEFAULT 'N',
174 p_selection_dt IN DATE ,
175 p_end_dt IN DATE ,
176 p_rqrmnts_complete_ind IN VARCHAR2 DEFAULT 'N',
177 p_message_name OUT NOCOPY VARCHAR2,
178 p_legacy IN VARCHAR2 DEFAULT 'N')
179 RETURN BOOLEAN;
180 --PRAGMA RESTRICT_REFERENCES( ENRP_VAL_SUSA_SCI , WNDS);
181
182 --
183 -- Validate the student unit set attempt confirmation rules.
184 FUNCTION ENRP_VAL_SUSA_SCI_RL(
185 p_person_id IN NUMBER ,
186 p_course_cd IN VARCHAR2 ,
187 p_unit_set_cd IN VARCHAR2 ,
188 p_us_version_number IN NUMBER ,
189 p_new_student_confirmed_ind IN VARCHAR2 DEFAULT 'N',
190 p_old_student_confirmed_ind IN VARCHAR2 DEFAULT 'N',
191 p_message_name OUT NOCOPY VARCHAR2,
192 p_message_text OUT NOCOPY VARCHAR2 )
193 RETURN BOOLEAN;
194 --PRAGMA RESTRICT_REFERENCES( ENRP_VAL_SUSA_SCI_RL , WNDS);
195
196 --
197 -- Validate student unit set atmpt confirm indicator and selection date.
198 FUNCTION ENRP_VAL_SUSA_SCI_SD(
199 p_student_confirmed_ind IN VARCHAR2 DEFAULT 'N',
200 p_selection_dt IN DATE ,
201 p_message_name OUT NOCOPY VARCHAR2,
202 p_legacy IN VARCHAR2 DEFAULT 'N')
203 RETURN BOOLEAN;
204 --PRAGMA RESTRICT_REFERENCES( ENRP_VAL_SUSA_SCI_SD , WNDS);
205 --
206 -- Validate the unit set is active for student unit set attempt.
207 FUNCTION ENRP_VAL_SUSA_US_ACT(
208 p_person_id IN NUMBER ,
209 p_course_cd IN VARCHAR2 ,
210 p_unit_set_cd IN VARCHAR2 ,
211 p_sequence_number IN NUMBER ,
212 p_version_number IN NUMBER ,
213 p_message_name OUT NOCOPY VARCHAR2)
214 RETURN BOOLEAN;
215 --PRAGMA RESTRICT_REFERENCES(ENRP_VAL_SUSA_US_ACT , WNDS);
216
217 --
218 -- Validate the student unit set attempt requires authorisation.
219 FUNCTION ENRP_VAL_SUSA_US_ATH(
220 p_unit_set_cd IN VARCHAR2 ,
221 p_version_number IN NUMBER ,
222 p_authorised_person_id IN NUMBER ,
223 p_authorised_on IN DATE ,
224 p_message_name OUT NOCOPY VARCHAR2)
225 RETURN BOOLEAN;
226 --PRAGMA RESTRICT_REFERENCES( ENRP_VAL_SUSA_US_ATH , WNDS);
227 --
228 -- Validation routines for student unit set attempt.
229 FUNCTION ENRP_VAL_SUSA(
230 p_person_id IN NUMBER ,
231 p_course_cd IN VARCHAR2 ,
232 p_unit_set_cd IN VARCHAR2 ,
233 p_sequence_number IN NUMBER ,
234 p_us_version_number IN NUMBER ,
235 p_selection_dt IN DATE ,
236 p_student_confirmed_ind IN VARCHAR2 DEFAULT 'N',
237 p_end_dt IN DATE ,
238 p_parent_unit_set_cd IN VARCHAR2 ,
239 p_parent_sequence_number IN NUMBER ,
240 p_primary_set_ind IN VARCHAR2 DEFAULT 'N',
241 p_voluntary_end_ind IN VARCHAR2 DEFAULT 'N',
242 p_authorised_person_id IN NUMBER ,
243 p_authorised_on IN DATE ,
244 p_override_title IN VARCHAR2 ,
245 p_rqrmnts_complete_ind IN VARCHAR2 DEFAULT 'N',
246 p_rqrmnts_complete_dt IN DATE ,
247 p_s_completed_source_type IN VARCHAR2 ,
248 p_action IN VARCHAR2 ,
249 p_message_name OUT NOCOPY VARCHAR2,
250 p_message_text OUT NOCOPY VARCHAR2 )
251 RETURN BOOLEAN;
252 --PRAGMA RESTRICT_REFERENCES( ENRP_VAL_SUSA , WNDS);
253
254 --
255 -- Validate the cascading setting of the end date of an susa record.
256 FUNCTION ENRP_VAL_SUSA_ED_UPD(
257 p_person_id IN NUMBER ,
258 p_course_cd IN VARCHAR2 ,
259 p_unit_set_cd IN VARCHAR2 ,
260 p_sequence_number IN NUMBER ,
261 p_end_dt IN DATE ,
262 p_voluntary_end_ind IN VARCHAR2 DEFAULT 'N',
263 p_authorised_person_id IN NUMBER ,
264 p_authorised_on IN DATE ,
265 p_message_name OUT NOCOPY VARCHAR2)
266 RETURN BOOLEAN;
267 --PRAGMA RESTRICT_REFERENCES( ENRP_VAL_SUSA_ED_UPD, WNDS);
268 --
269 -- Validate cascade unsetting of stdnt unit set atmpt confirmation ind.
270 FUNCTION ENRP_VAL_SUSA_SCI_UP(
271 p_person_id IN NUMBER ,
272 p_course_cd IN VARCHAR2 ,
273 p_unit_set_cd IN VARCHAR2 ,
274 p_sequence_number IN NUMBER ,
275 p_student_confirmed_ind IN VARCHAR2 DEFAULT 'N',
276 p_message_name OUT NOCOPY VARCHAR2)
277 RETURN BOOLEAN;
278 --PRAGMA RESTRICT_REFERENCES( ENRP_VAL_SUSA_SCI_UP , WNDS);
279 --
280 -- Validate the requirement complete fields for IGS_AS_SU_SETATMPT.
281 FUNCTION enrp_val_susa_scst(
282 p_rqrmnts_complete_dt IN DATE ,
283 p_rqrmnts_complete_ind IN VARCHAR2 DEFAULT 'N',
284 p_s_completed_source_type IN VARCHAR2 DEFAULT 'N',
285 p_message_name OUT NOCOPY VARCHAR2 )
286 RETURN BOOLEAN;
287 --PRAGMA RESTRICT_REFERENCES( enrp_val_susa_scst , WNDS);
288
289 END IGS_EN_VAL_SUSA;