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
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
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');
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:
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 );
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:
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
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
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');
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:
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 );
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:
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
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
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');
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 );
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:
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
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
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');
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:
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 );
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:
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
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
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');
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: --
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 );
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:
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
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
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');
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:
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 );
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: