[Home] [Help]
PACKAGE BODY: APPS.IGS_AS_GRD_ATT_BE_PKG
Source
1 PACKAGE BODY IGS_AS_GRD_ATT_BE_PKG AS
2 /* $Header: IGSAS53B.pls 115.0 2002/12/26 09:49:19 ddey noship $ */
3
4 /* *************************************************************************************/
5 -- This Procedure raises an event when Change Grade Submission is done.
6 /* *************************************************************************************/
7
8 PROCEDURE Wf_Inform_Admin_CG
9 ( p_person_id IN VARCHAR2,
10 p_person_number IN hz_parties.party_number%TYPE,
11 p_person_name IN hz_parties.party_name%TYPE,
12 p_course_cd IN igs_as_chn_grd_req.course_cd%TYPE,
13 p_unit_cd IN igs_as_chn_grd_req.unit_cd%TYPE,
14 p_unit_section IN igs_as_chn_grd_req.unit_class%TYPE,
15 p_title IN igs_ps_unit_ver_all.title%TYPE,
16 p_grading_schema IN igs_as_chn_grd_req.current_grading_schema_cd%TYPE,
17 p_current_mark IN igs_as_chn_grd_req.current_mark%TYPE,
18 p_current_grade IN igs_as_chn_grd_req.current_grade%TYPE,
19 p_change_mark IN igs_as_chn_grd_req.change_mark%TYPE,
20 p_change_grade IN igs_as_chn_grd_req.change_grade%TYPE,
21 p_requester_id IN igs_as_chn_grd_req.requester_id%TYPE,
22 p_requester_name IN VARCHAR2,
23 p_requester_number IN VARCHAR2,
24 p_request_date IN igs_as_chn_grd_req.request_date%TYPE,
25 p_requester_comments IN igs_as_chn_grd_req.requester_comments%TYPE,
26 p_teach_cal_type IN igs_as_chn_grd_req.teach_cal_type%TYPE,
27 p_teach_ci_seq_num IN igs_as_chn_grd_req.teach_ci_sequence_number%TYPE,
28 p_start_dt IN DATE,
29 p_end_dt IN DATE,
30 p_load_cal_type IN igs_as_chn_grd_req.load_cal_type%TYPE,
31 p_load_seq_num IN igs_as_chn_grd_req.load_ci_sequence_number%TYPE,
32 p_grade_ver_num IN igs_as_chn_grd_req.current_gs_version_number%TYPE,
33 p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
34 p_grading_period_cd IN igs_as_su_stmptout.grading_period_cd%TYPE
35 )
36 IS
37 l_event_t wf_event_t;
38 l_parameter_list_t wf_parameter_list_t;
39 l_itemKey varchar2(100);
40
41 CURSOR cur_seq IS
42 SELECT IGS_EN_WF_MAILADM_S.NEXTVAL
43 FROM dual;
44
45 BEGIN
46 --Changing Date to Character
47 -- l_request_date := TO_CHAR(p_request_date,'DD-MON-YY');
48 --
49 -- initialize the wf_event_t object
50 --
51 wf_event_t.Initialize(l_event_t);
52 --
53 -- set the event name
54 --
55 -- wf_event_t.setEventName( pEventName => 'oracle.apps.igs.as.infadmcg');
56 --
57 -- set the event key but before the select a number from sequence
58 --
59
60
61
62 OPEN cur_seq ;
63 FETCH cur_seq INTO l_itemKey ;
64 CLOSE cur_seq ;
65
66
67
68 -- l_wf_event_t.setEventKey ( pEventKey => 'infadmcg'||l_key );
69 --
70 -- set the parameter list
71 --
72 -- l_event_t.setParameterList ( p_parameterlist => l_parameter_list_t );
73 -- wf_event_t.SetParameterList ( p_parameterlist => l_parameter_list_t );
74 --
75 -- now add the parameters to the parameter list
76 --
77
78 wf_event.AddParameterToList ( p_Name => 'PERSON_ID',p_Value => p_person_id,p_parameterlist=>l_parameter_list_t);
79 wf_event.AddParameterToList ( p_Name => 'PERSON_NAME',p_Value => p_person_name,p_parameterlist=>l_parameter_list_t);
80 wf_event.AddParameterToList ( p_Name => 'PERSON_NUMBER',p_Value => p_person_number,p_parameterlist=>l_parameter_list_t);
81 wf_event.AddParameterToList ( p_Name => 'COURSE_CD',p_Value => p_course_cd,p_parameterlist=>l_parameter_list_t);
82 wf_event.AddParameterToList ( p_Name => 'UNIT_CODE',p_Value => p_unit_cd,p_parameterlist=>l_parameter_list_t);
83 wf_event.AddParameterToList ( p_Name => 'UNIT_SECTION',p_Value => p_unit_section,p_parameterlist=>l_parameter_list_t);
84 wf_event.AddParameterToList ( p_Name => 'UNIT_TITLE',p_Value => p_title,p_parameterlist=>l_parameter_list_t);
85 wf_event.AddParameterToList ( p_Name => 'GRADING_SCHEMA',p_Value => p_grading_schema,p_parameterlist=>l_parameter_list_t);
86 wf_event.AddParameterToList ( p_Name => 'CURRENT_MARK',p_Value => p_current_mark,p_parameterlist=>l_parameter_list_t);
87 wf_event.AddParameterToList ( p_Name => 'CURRENT_GRADE',p_Value => p_current_grade,p_parameterlist=>l_parameter_list_t);
88 wf_event.AddParameterToList ( p_Name => 'CHANGE_MARK',p_Value => p_change_mark,p_parameterlist=>l_parameter_list_t);
89 wf_event.AddParameterToList ( p_Name => 'CHANGE_GRADE',p_Value => p_change_grade,p_parameterlist=>l_parameter_list_t);
90 wf_event.AddParameterToList ( p_Name => 'REQUESTER_ID',p_Value => p_requester_id,p_parameterlist=>l_parameter_list_t);
91 wf_event.AddParameterToList ( p_Name => 'REQUESTER_NAME',p_Value => p_requester_name,p_parameterlist=>l_parameter_list_t);
92 wf_event.AddParameterToList ( p_Name => 'REQUESTER_NUMBER',p_Value => p_requester_number,p_parameterlist=>l_parameter_list_t);
93 wf_event.AddParameterToList ( p_Name => 'REQUEST_DATE',p_Value => p_request_date,p_parameterlist=>l_parameter_list_t);
94 wf_event.AddParameterToList ( p_Name => 'REQUESTER_COMMENTS',p_Value => p_requester_comments,p_parameterlist=>l_parameter_list_t);
95 wf_event.AddParameterToList ( p_Name => 'TEACH_CAL_TYPE',p_Value => p_teach_cal_type,p_parameterlist=>l_parameter_list_t);
96 wf_event.AddParameterToList ( p_Name => 'TEACH_CI_SEQUENCE_NUMBER',p_Value => p_teach_ci_seq_num,p_parameterlist=>l_parameter_list_t);
97 wf_event.AddParameterToList ( p_Name => 'LOAD_CAL_TYPE',p_Value => p_load_cal_type,p_parameterlist=>l_parameter_list_t);
98 wf_event.AddParameterToList ( p_Name => 'CI_SEQUENCE_NUMBER',p_Value => p_load_seq_num,p_parameterlist=>l_parameter_list_t);
99 wf_event.AddParameterToList ( p_Name => 'CI_START_DT',p_Value => p_start_dt,p_parameterlist=>l_parameter_list_t );
100 wf_event.AddParameterToList ( p_Name => 'CI_END_DT',p_Value => p_end_dt,p_parameterlist=>l_parameter_list_t );
101 wf_event.AddParameterToList ( p_Name => 'UOO_ID',p_Value => p_uoo_id,p_parameterlist=>l_parameter_list_t);
102 wf_event.AddParameterToList ( p_Name => 'CHANGE_GRADE_VERSION_NUM',p_Value => p_grade_ver_num,p_parameterlist=>l_parameter_list_t);
103 wf_event.AddParameterToList ( p_Name => 'GRADING_PERIOD_CD',p_Value => p_grading_period_cd,p_parameterlist=>l_parameter_list_t);
104 --
105 -- raise the event
106 --
107 WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.as.infadmcg',
108 p_event_key => l_itemKey,
109 p_parameters => l_parameter_list_t);
110
111
112 END Wf_Inform_Admin_CG ;
113
114 /* *************************************************************************************/
115 -- This Procedure raises an event when Grade Submission is done.
116 /* *************************************************************************************/
117
118 PROCEDURE Wf_Inform_Admin_Grd
119 ( p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE ,
120 p_unit_cd IN igs_ps_unit_ver_all.unit_cd%TYPE,
121 p_unit_class IN igs_ps_unit_ofr_opt.unit_class%TYPE,
122 p_title IN igs_ps_unit_ver_all.title%TYPE,
123 p_instructor IN hz_parties.party_name%TYPE,
124 p_submission_date IN DATE,
125 p_requestor_id IN VARCHAR2 /* Added by aiyer for the bug 2403814 */
126 )
127 IS
128
129 l_event_t wf_event_t;
130 l_parameter_list_t wf_parameter_list_t;
131 l_itemKey varchar2(100);
132
133 CURSOR cur_seq1 IS
134 SELECT IGS_EN_WF_MAILADM_S.NEXTVAL
135 FROM dual;
136
137 BEGIN
138
139 --
140 -- initialize the wf_event_t object
141 --
142 wf_event_t.Initialize(l_event_t);
143 --
144 -- set the event name
145 --
146 -- wf_event_t.setEventName( pEventName => 'oracle.apps.igs.as.infadmgrd');
147 --
148 -- set the event key but before the select a number from sequence
149 --
150
151
152 OPEN cur_seq1;
153 FETCH cur_seq1 INTO l_itemKey ;
154 CLOSE cur_seq1;
155
156
157
158 -- l_wf_event_t.setEventKey ( pEventKey => 'infadmgrd'||l_key );
159 --
160 -- set the parameter list
161 --
162 -- l_event_t.setParameterList ( p_parameterlist => l_parameter_list_t );
163 -- wf_event_t.SetParameterList ( p_parameterlist => l_parameter_list_t );
164 --
165 -- now add the parameters to the parameter list
166 --
167
168 wf_event.AddParameterToList (p_name=>'UOO_ID',p_value=>p_uoo_id,p_parameterlist=>l_parameter_list_t);
169 wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd, p_ParameterList => l_parameter_list_t);
170 wf_event.AddParameterToList ( p_Name => 'UNIT_SECTION', p_Value => p_unit_class, p_ParameterList => l_parameter_list_t);
171 wf_event.AddParameterToList ( p_Name => 'UNIT_TITLE', p_Value => p_title, p_ParameterList => l_parameter_list_t);
172 wf_event.AddParameterToList ( p_Name => 'INSTRUCTOR', p_Value => p_instructor, p_ParameterList => l_parameter_list_t);
173 wf_event.AddParameterToList ( p_Name => 'SUBMISSION_DATE', p_Value => p_submission_date, p_ParameterList => l_parameter_list_t);
174 /* This has been added by aiyer for the bug 2430814 . Set the FROM_USER_ID parameter attribute in the Grade Submission Workflow */
175 wf_event.AddParameterToList ( p_Name => 'FROM_USER_ID', p_Value => p_requestor_id, p_ParameterList => l_parameter_list_t);
176 --
177 -- raise the event
178 --
179 WF_EVENT.RAISE (p_event_name =>
180 'oracle.apps.igs.as.infadmgrd',
181 p_event_key => l_itemKey,
182 p_parameters => l_parameter_list_t);
183
184
185 l_parameter_list_t.delete;
186
187 END Wf_Inform_Admin_Grd ;
188
189 /* *************************************************************************************/
190 -- This Procedure raises an event when Incomplete Grade Conversion Process is done.
191 /* *************************************************************************************/
192 PROCEDURE Wf_Inform_Admin_Grd_Mt
193 ( p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE ,
194 p_unit_cd IN igs_ps_unit_ver_all.unit_cd%TYPE,
195 p_unit_class IN igs_ps_unit_ofr_opt.unit_class%TYPE,
196 p_title IN igs_ps_unit_ver_all.title%TYPE,
197 p_instructor IN hz_parties.party_name%TYPE,
198 p_submission_date IN DATE
199 )
200 IS
201
202 l_event_t wf_event_t;
203 l_parameter_list_t wf_parameter_list_t;
204 l_itemKey varchar2(100);
205
206 CURSOR cur_seq3 IS
207 SELECT IGS_EN_WF_MAILADM_S.NEXTVAL
208 FROM dual;
209 BEGIN
210
211 --
212 -- initialize the wf_event_t object
213 --
214 wf_event_t.Initialize(l_event_t);
215 --
216 -- set the event name
217 --
218 -- wf_event_t.setEventName( pEventName => 'oracle.apps.igs.as.infadmgrdmt');
219 --
220 -- set the event key but before the select a number from sequence
221 --
222
223 OPEN cur_seq3;
224 FETCH cur_seq3 INTO l_itemKey ;
225 CLOSE cur_seq3;
226
227 -- l_wf_event_t.setEventKey ( pEventKey => 'infadmgrdmt'||l_key );
228 --
229 -- set the parameter list
230 --
231 -- l_event_t.setParameterList ( p_parameterlist => l_parameter_list_t );
232 -- wf_event_t.SetParameterList ( p_parameterlist => l_parameter_list_t );
233 --
234 -- now add the parameters to the parameter list
235 --
236
237 wf_event.AddParameterToList (p_name=>'UOO_ID',p_value=>p_uoo_id,p_parameterlist=>l_parameter_list_t);
238 wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd, p_ParameterList => l_parameter_list_t);
242 wf_event.AddParameterToList ( p_Name => 'SUBMISSION_DATE', p_Value => p_submission_date, p_ParameterList => l_parameter_list_t);
239 wf_event.AddParameterToList ( p_Name => 'UNIT_SECTION', p_Value => p_unit_class, p_ParameterList => l_parameter_list_t);
240 wf_event.AddParameterToList ( p_Name => 'UNIT_TITLE', p_Value => p_title, p_ParameterList => l_parameter_list_t);
241 wf_event.AddParameterToList ( p_Name => 'INSTRUCTOR', p_Value => p_instructor, p_ParameterList => l_parameter_list_t);
243
244 --
245 -- raise the event
246 --
247 WF_EVENT.RAISE (p_event_name =>
248 'oracle.apps.igs.as.infadmgrdmt',
249 p_event_key => l_itemKey,
250 p_parameters => l_parameter_list_t);
251
252
253 l_parameter_list_t.delete;
254
255 END Wf_Inform_Admin_Grd_Mt ;
256
257 /* *************************************************************************************/
258 -- This Procedure raises an event when Attendance Submission is done.
259 /* *************************************************************************************/
260
261 PROCEDURE Wf_Inform_Admin_Attd
262 ( p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE ,
263 p_unit_cd IN igs_ps_unit_ver_all.unit_cd%TYPE,
264 p_unit_class IN igs_ps_unit_ofr_opt.unit_class%TYPE,
265 p_title IN igs_ps_unit_ver_all.title%TYPE,
266 p_instructor IN hz_parties.party_name%TYPE,
267 p_submission_date IN DATE
268 )
269 IS
270
271 l_event_t wf_event_t;
272 l_parameter_list_t wf_parameter_list_t;
273 l_itemKey varchar2(100);
274
275 CURSOR cur_seq4 IS
276 SELECT IGS_EN_WF_MAILADM_S.NEXTVAL
277 FROM dual;
278 BEGIN
279
280 --
281 -- initialize the wf_event_t object
282 --
283 wf_event_t.Initialize(l_event_t);
284 --
285 -- set the event name
286 --
287 -- wf_event_t.setEventName( pEventName => 'oracle.apps.igs.as.infadmattd');
288 --
289 -- set the event key but before the select a number from sequence
290 --
291
292
293 OPEN cur_seq4;
294 FETCH cur_seq4 INTO l_itemKey ;
295 CLOSE cur_seq4;
296
297
298 -- l_wf_event_t.setEventKey ( pEventKey => 'infadmattd'||l_key );
299 --
300 -- set the parameter list
301 --
302 -- l_event_t.setParameterList ( p_parameterlist => l_parameter_list_t );
303 -- wf_event_t.SetParameterList ( p_parameterlist => l_parameter_list_t );
304 --
305 -- now add the parameters to the parameter list
306 --
307
308 wf_event.AddParameterToList (p_name=>'UOO_ID',p_value=>p_uoo_id,p_parameterlist=>l_parameter_list_t);
309 wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd, p_ParameterList => l_parameter_list_t);
310 wf_event.AddParameterToList ( p_Name => 'UNIT_SECTION', p_Value => p_unit_class, p_ParameterList => l_parameter_list_t);
311 wf_event.AddParameterToList ( p_Name => 'UNIT_TITLE', p_Value => p_title, p_ParameterList => l_parameter_list_t);
312 wf_event.AddParameterToList ( p_Name => 'INSTRUCTOR', p_Value => p_instructor, p_ParameterList => l_parameter_list_t);
313 wf_event.AddParameterToList ( p_Name => 'SUBMISSION_DATE', p_Value => p_submission_date, p_ParameterList => l_parameter_list_t);
314
315 --
316 -- raise the event
317 --
318 WF_EVENT.RAISE (p_event_name =>
319 'oracle.apps.igs.as.infadmattd',
320 p_event_key => l_itemKey,
321 p_parameters => l_parameter_list_t);
322
323
324 l_parameter_list_t.delete;
325
326 END Wf_Inform_Admin_Attd ;
327 /* *************************************************************************************/
328 -- This Procedure raises an event when Incomplete Grade Conversion Process is done.
329 /* *************************************************************************************/
330 PROCEDURE Wf_Inform_Admin_IncGrd
331 ( p_person_id IN igs_as_su_stmptout.person_id%TYPE ,
332 p_course_cd IN igs_as_su_stmptout.course_cd%TYPE,
333 p_unit_cd IN igs_as_su_stmptout.unit_cd%TYPE,
334 p_cal_type IN igs_as_su_stmptout.cal_type%TYPE,
335 p_ci_seq_num IN igs_as_su_stmptout.ci_sequence_number%TYPE,
336 p_date_changed IN DATE,
337 p_old_grade IN igs_as_su_stmptout.grade%TYPE,
338 p_new_grade IN igs_as_su_stmptout.incomp_default_grade%TYPE
339 )
340 IS
341 l_event_t wf_event_t;
342 l_parameter_list_t wf_parameter_list_t;
343 l_itemKey varchar2(100);
344
345 CURSOR cur_seq5 IS
346 SELECT IGS_EN_WF_MAILADM_S.NEXTVAL
347 FROM dual;
348
349 BEGIN
350
351 --
352 -- initialize the wf_event_t object
353 --
354 wf_event_t.Initialize(l_event_t);
355 --
356 -- set the event name
357 --
358 -- wf_event_t.setEventName( pEventName => 'oracle.apps.igs.as.infadmincgrd');
359 --
363
360 -- set the event key but before the select a number from sequence
361 --
362
364 OPEN cur_seq5;
365 FETCH cur_seq5 INTO l_itemKey ;
366 CLOSE cur_seq5;
367
368 -- l_wf_event_t.setEventKey ( pEventKey => 'infadmincgrd'||l_key );
369 --
370 -- set the parameter list
371 --
372 -- l_event_t.setParameterList ( p_parameterlist => l_parameter_list_t );
373 -- wf_event_t.SetParameterList ( p_parameterlist => l_parameter_list_t );
374 --
375 -- now add the parameters to the parameter list
376 --
377
378 wf_event.AddParameterToList ( p_Name => 'PERSON_ID', p_Value => p_person_id,p_parameterlist=>l_parameter_list_t);
379 wf_event.AddParameterToList ( p_Name => 'COURSE_CD', p_Value => p_course_cd,p_parameterlist=>l_parameter_list_t);
380 wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd,p_parameterlist=>l_parameter_list_t);
381 wf_event.AddParameterToList ( p_Name => 'CAL_TYPE', p_Value => p_cal_type,p_parameterlist=>l_parameter_list_t);
382 wf_event.AddParameterToList ( p_Name => 'CI_SEQUENCE_NUMBER', p_Value => p_ci_seq_num,p_parameterlist=>l_parameter_list_t);
383 wf_event.AddParameterToList ( p_Name => 'DATE_CHANGED', p_Value => p_date_changed,p_parameterlist=>l_parameter_list_t);
384 wf_event.AddParameterToList ( p_Name => 'OLD_GRADE', p_Value => p_old_grade,p_parameterlist=>l_parameter_list_t);
385 wf_event.AddParameterToList ( p_Name => 'NEW_GRADE', p_Value => p_new_grade,p_parameterlist=>l_parameter_list_t);
386 --
387 -- raise the event
388 --
389 WF_EVENT.RAISE (p_event_name =>
390 'oracle.apps.igs.as.infadmincgrd',
391 p_event_key => l_itemKey,
392 p_parameters => l_parameter_list_t);
393 END Wf_Inform_Admin_IncGrd;
394
395 /* *************************************************************************************/
396 -- This Procedure raises an event when Incomplete Grade is submitted.
397 /* *************************************************************************************/
398 PROCEDURE Wf_Inform_Admin_IncGrdSub
399 ( p_person_id IN igs_as_su_stmptout.person_id%TYPE ,
400 p_course_cd IN igs_as_su_stmptout.course_cd%TYPE,
401 p_unit_cd IN igs_as_su_stmptout.unit_cd%TYPE,
402 p_cal_type IN igs_as_su_stmptout.cal_type%TYPE,
403 p_ci_seq_num IN igs_as_su_stmptout.ci_sequence_number%TYPE,
404 p_grade IN igs_as_su_stmptout.grade%TYPE,
405 p_incomp_deadline_dt IN igs_as_su_stmptout.incomp_deadline_date%TYPE,
406 p_incomp_default_grd IN igs_as_su_stmptout.incomp_default_grade%TYPE,
407 p_incomp_default_mark IN igs_as_su_stmptout.incomp_default_mark%TYPE,
408 p_date_submitted IN DATE
409 )
410 IS
411 l_event_t wf_event_t;
412 l_parameter_list_t wf_parameter_list_t;
413 l_itemKey varchar2(100);
414
415 CURSOR cur_seq2 IS
416 SELECT IGS_EN_WF_MAILADM_S.NEXTVAL
417 FROM dual;
418
419 BEGIN
420 --
421 -- initialize the wf_event_t object
422 --
423 wf_event_t.Initialize(l_event_t);
424 --
425 -- set the event name
426 --
427 -- wf_event_t.setEventName( pEventName => 'oracle.apps.igs.as.infadmincgrdsub');
428 --
429 -- set the event key but before the select a number from sequence
430 --
431
432 OPEN cur_seq2;
433 FETCH cur_seq2 INTO l_itemKey ;
434 CLOSE cur_seq2;
435
436
437 -- l_wf_event_t.setEventKey ( pEventKey => 'infadmincgrdsub'||l_key );
438 --
439 -- set the parameter list
440 --
441 -- l_event_t.setParameterList ( p_parameterlist => l_parameter_list_t );
442 -- wf_event_t.SetParameterList ( p_parameterlist => l_parameter_list_t );
443 --
444 -- now add the parameters to the parameter list
445 --
446
447 wf_event.AddParameterToList ( p_Name => 'PERSON_ID', p_Value => p_person_id,p_parameterlist=>l_parameter_list_t);
448 wf_event.AddParameterToList ( p_Name => 'COURSE_CD', p_Value => p_course_cd,p_parameterlist=>l_parameter_list_t);
449 wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd,p_parameterlist=>l_parameter_list_t);
450 wf_event.AddParameterToList ( p_Name => 'CAL_TYPE', p_Value => p_cal_type,p_parameterlist=>l_parameter_list_t);
451 wf_event.AddParameterToList ( p_Name => 'CI_SEQUENCE_NUMBER', p_Value => p_ci_seq_num,p_parameterlist=>l_parameter_list_t);
452 wf_event.AddParameterToList ( p_Name => 'GRADE', p_Value => p_grade,p_parameterlist=>l_parameter_list_t);
453 wf_event.AddParameterToList ( p_Name => 'INCOMP_DEADLINE_DATE', p_Value => p_incomp_deadline_dt,p_parameterlist=>l_parameter_list_t);
454 wf_event.AddParameterToList ( p_Name => 'INCOMP_DEFAULT_GRADE', p_Value => p_incomp_default_grd,p_parameterlist=>l_parameter_list_t);
455 wf_event.AddParameterToList ( p_Name => 'INCOMP_DEFAULT_MARK', p_Value => p_incomp_default_mark,p_parameterlist=>l_parameter_list_t);
456 wf_event.AddParameterToList ( p_Name => 'DATE_SUBMITTED', p_Value => p_date_submitted,p_parameterlist=>l_parameter_list_t);
457 --
458 -- raise the event
459 --
460 WF_EVENT.RAISE (p_event_name =>
461 'oracle.apps.igs.as.infadmincgrdsub',
462 p_event_key => l_itemKey,
463 p_parameters => l_parameter_list_t);
464 END Wf_Inform_Admin_IncGrdSub;
465
466 END IGS_AS_GRD_ATT_BE_PKG ;