DBA Data[Home] [Help]

APPS.IGS_AS_GRD_ATT_BE_PKG dependencies on WF_EVENT_T

Line 37: l_event_t wf_event_t;

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

Line 49: -- initialize the wf_event_t object

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

Line 51: wf_event_t.Initialize(l_event_t);

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

Line 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:

Line 68: -- l_wf_event_t.setEventKey ( pEventKey => 'infadmcg'||l_key );

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

Line 73: -- wf_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:

Line 129: l_event_t wf_event_t;

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

Line 140: -- initialize the wf_event_t object

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

Line 142: wf_event_t.Initialize(l_event_t);

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

Line 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:

Line 158: -- l_wf_event_t.setEventKey ( pEventKey => 'infadmgrd'||l_key );

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

Line 163: -- wf_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:

Line 202: l_event_t wf_event_t;

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

Line 212: -- initialize the wf_event_t object

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

Line 214: wf_event_t.Initialize(l_event_t);

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

Line 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:

Line 227: -- l_wf_event_t.setEventKey ( pEventKey => 'infadmgrdmt'||l_key );

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

Line 232: -- wf_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:

Line 271: l_event_t wf_event_t;

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

Line 281: -- initialize the wf_event_t object

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

Line 283: wf_event_t.Initialize(l_event_t);

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

Line 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:

Line 298: -- l_wf_event_t.setEventKey ( pEventKey => 'infadmattd'||l_key );

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

Line 303: -- wf_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:

Line 341: l_event_t wf_event_t;

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

Line 352: -- initialize the wf_event_t object

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

Line 354: wf_event_t.Initialize(l_event_t);

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

Line 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:

Line 368: -- l_wf_event_t.setEventKey ( pEventKey => 'infadmincgrd'||l_key );

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

Line 373: -- wf_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:

Line 411: l_event_t wf_event_t;

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

Line 421: -- initialize the wf_event_t object

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

Line 423: wf_event_t.Initialize(l_event_t);

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

Line 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:

Line 437: -- l_wf_event_t.setEventKey ( pEventKey => 'infadmincgrdsub'||l_key );

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

Line 442: -- wf_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: