eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CAC_AVLBLTY_EVENTS_PVT dependencies on WF_EVENT

Line 15: SELECT p_EventName ||'-'|| cac_sr_wf_events_s.NEXTVAL INTO l_key FROM DUAL;

11: RETURN VARCHAR2
12: IS
13: l_key varchar2(240);
14: BEGIN
15: SELECT p_EventName ||'-'|| cac_sr_wf_events_s.NEXTVAL INTO l_key FROM DUAL;
16: RETURN l_key;
17: END getItemKey;
18:
19:

Line 51: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_ID'

47:
48: --
49: -- construct the parameter list
50: --
51: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_ID'
52: , p_value => TO_CHAR(p_Schedule_Id)
53: , p_parameterlist => l_ParameterList
54: );
55:

Line 56: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_CATEGORY'

52: , p_value => TO_CHAR(p_Schedule_Id)
53: , p_parameterlist => l_ParameterList
54: );
55:
56: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_CATEGORY'
57: , p_value => p_Schedule_Category
58: , p_parameterlist => l_ParameterList
59: );
60:

Line 61: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_START_DATE'

57: , p_value => p_Schedule_Category
58: , p_parameterlist => l_ParameterList
59: );
60:
61: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_START_DATE'
62: , p_value => TO_CHAR(p_Schdl_Start_Date,'MM/DD/YYYY')
63: , p_parameterlist => l_ParameterList
64: );
65:

Line 66: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_END_DATE'

62: , p_value => TO_CHAR(p_Schdl_Start_Date,'MM/DD/YYYY')
63: , p_parameterlist => l_ParameterList
64: );
65:
66: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_END_DATE'
67: , p_value => TO_CHAR(p_Schdl_End_Date,'MM/DD/YYYY')
68: , p_parameterlist => l_ParameterList
69: );
70: --

Line 73: WF_EVENT.RAISE3( p_event_name => l_EventName

69: );
70: --
71: -- Raise the event
72: --
73: WF_EVENT.RAISE3( p_event_name => l_EventName
74: , p_event_key => l_ItemKey
75: , p_event_data => NULL
76: , p_parameter_list => l_ParameterList
77: , p_send_date => SYSDATE

Line 119: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_ID'

115:
116: --
117: -- construct the parameter list
118: --
119: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_ID'
120: , p_value => TO_CHAR(p_Schedule_Id)
121: , p_parameterlist => l_ParameterList
122: );
123:

Line 124: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_CATEGORY'

120: , p_value => TO_CHAR(p_Schedule_Id)
121: , p_parameterlist => l_ParameterList
122: );
123:
124: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_CATEGORY'
125: , p_value => p_Schedule_Category
126: , p_parameterlist => l_ParameterList
127: );
128:

Line 129: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_START_DATE'

125: , p_value => p_Schedule_Category
126: , p_parameterlist => l_ParameterList
127: );
128:
129: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_START_DATE'
130: , p_value => TO_CHAR(p_Schdl_Start_Date,'MM/DD/YYYY')
131: , p_parameterlist => l_ParameterList
132: );
133:

Line 134: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_END_DATE'

130: , p_value => TO_CHAR(p_Schdl_Start_Date,'MM/DD/YYYY')
131: , p_parameterlist => l_ParameterList
132: );
133:
134: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_END_DATE'
135: , p_value => TO_CHAR(p_Schdl_End_Date,'MM/DD/YYYY')
136: , p_parameterlist => l_ParameterList
137: );
138: --

Line 141: WF_EVENT.RAISE3( p_event_name => l_EventName

137: );
138: --
139: -- Raise the event
140: --
141: WF_EVENT.RAISE3( p_event_name => l_EventName
142: , p_event_key => l_ItemKey
143: , p_event_data => NULL
144: , p_parameter_list => l_ParameterList
145: , p_send_date => SYSDATE

Line 187: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_ID'

183:
184: --
185: -- construct the parameter list
186: --
187: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_ID'
188: , p_value => TO_CHAR(p_Schedule_Id)
189: , p_parameterlist => l_ParameterList
190: );
191:

Line 192: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_CATEGORY'

188: , p_value => TO_CHAR(p_Schedule_Id)
189: , p_parameterlist => l_ParameterList
190: );
191:
192: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_CATEGORY'
193: , p_value => p_Schedule_Category
194: , p_parameterlist => l_ParameterList
195: );
196:

Line 197: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_START_DATE'

193: , p_value => p_Schedule_Category
194: , p_parameterlist => l_ParameterList
195: );
196:
197: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_START_DATE'
198: , p_value => TO_CHAR(p_Schdl_Start_Date,'MM/DD/YYYY')
199: , p_parameterlist => l_ParameterList
200: );
201:

Line 202: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_END_DATE'

198: , p_value => TO_CHAR(p_Schdl_Start_Date,'MM/DD/YYYY')
199: , p_parameterlist => l_ParameterList
200: );
201:
202: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_END_DATE'
203: , p_value => TO_CHAR(p_Schdl_End_Date,'MM/DD/YYYY')
204: , p_parameterlist => l_ParameterList
205: );
206: --

Line 209: WF_EVENT.RAISE3( p_event_name => l_EventName

205: );
206: --
207: -- Raise the event
208: --
209: WF_EVENT.RAISE3( p_event_name => l_EventName
210: , p_event_key => l_ItemKey
211: , p_event_data => NULL
212: , p_parameter_list => l_ParameterList
213: , p_send_date => SYSDATE

Line 259: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_ID'

255:
256: --
257: -- construct the parameter list
258: --
259: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_ID'
260: , p_value => TO_CHAR(p_Schedule_Id)
261: , p_parameterlist => l_ParameterList
262: );
263:

Line 264: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_CATEGORY'

260: , p_value => TO_CHAR(p_Schedule_Id)
261: , p_parameterlist => l_ParameterList
262: );
263:
264: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_CATEGORY'
265: , p_value => p_Schedule_Category
266: , p_parameterlist => l_ParameterList
267: );
268:

Line 269: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_START_DATE'

265: , p_value => p_Schedule_Category
266: , p_parameterlist => l_ParameterList
267: );
268:
269: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_START_DATE'
270: , p_value => TO_CHAR(p_Schdl_Start_Date,'MM/DD/YYYY')
271: , p_parameterlist => l_ParameterList
272: );
273:

Line 274: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_END_DATE'

270: , p_value => TO_CHAR(p_Schdl_Start_Date,'MM/DD/YYYY')
271: , p_parameterlist => l_ParameterList
272: );
273:
274: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_END_DATE'
275: , p_value => TO_CHAR(p_Schdl_End_Date,'MM/DD/YYYY')
276: , p_parameterlist => l_ParameterList
277: );
278: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'OBJECT_ID'

Line 278: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'OBJECT_ID'

274: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_END_DATE'
275: , p_value => TO_CHAR(p_Schdl_End_Date,'MM/DD/YYYY')
276: , p_parameterlist => l_ParameterList
277: );
278: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'OBJECT_ID'
279: , p_value => TO_CHAR(p_Object_Id)
280: , p_parameterlist => l_ParameterList
281: );
282:

Line 283: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'OBJECT_CODE'

279: , p_value => TO_CHAR(p_Object_Id)
280: , p_parameterlist => l_ParameterList
281: );
282:
283: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'OBJECT_CODE'
284: , p_value => p_Object_Type
285: , p_parameterlist => l_ParameterList
286: );
287:

Line 288: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'OBJECT_START_DATE'

284: , p_value => p_Object_Type
285: , p_parameterlist => l_ParameterList
286: );
287:
288: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'OBJECT_START_DATE'
289: , p_value => TO_CHAR(p_Object_Start_Date,'MM/DD/YYYY')
290: , p_parameterlist => l_ParameterList
291: );
292:

Line 293: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'OBJECT_END_DATE'

289: , p_value => TO_CHAR(p_Object_Start_Date,'MM/DD/YYYY')
290: , p_parameterlist => l_ParameterList
291: );
292:
293: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'OBJECT_END_DATE'
294: , p_value => TO_CHAR(p_Object_End_Date,'MM/DD/YYYY')
295: , p_parameterlist => l_ParameterList
296: );
297: --

Line 300: WF_EVENT.RAISE3( p_event_name => l_EventName

296: );
297: --
298: -- Raise the event
299: --
300: WF_EVENT.RAISE3( p_event_name => l_EventName
301: , p_event_key => l_ItemKey
302: , p_event_data => NULL
303: , p_parameter_list => l_ParameterList
304: , p_send_date => SYSDATE

Line 350: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_ID'

346:
347: --
348: -- construct the parameter list
349: --
350: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_ID'
351: , p_value => TO_CHAR(p_Schedule_Id)
352: , p_parameterlist => l_ParameterList
353: );
354:

Line 355: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_CATEGORY'

351: , p_value => TO_CHAR(p_Schedule_Id)
352: , p_parameterlist => l_ParameterList
353: );
354:
355: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_CATEGORY'
356: , p_value => p_Schedule_Category
357: , p_parameterlist => l_ParameterList
358: );
359:

Line 360: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_START_DATE'

356: , p_value => p_Schedule_Category
357: , p_parameterlist => l_ParameterList
358: );
359:
360: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_START_DATE'
361: , p_value => TO_CHAR(p_Schdl_Start_Date,'MM/DD/YYYY')
362: , p_parameterlist => l_ParameterList
363: );
364:

Line 365: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_END_DATE'

361: , p_value => TO_CHAR(p_Schdl_Start_Date,'MM/DD/YYYY')
362: , p_parameterlist => l_ParameterList
363: );
364:
365: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_END_DATE'
366: , p_value => TO_CHAR(p_Schdl_End_Date,'MM/DD/YYYY')
367: , p_parameterlist => l_ParameterList
368: );
369: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'OBJECT_ID'

Line 369: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'OBJECT_ID'

365: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_END_DATE'
366: , p_value => TO_CHAR(p_Schdl_End_Date,'MM/DD/YYYY')
367: , p_parameterlist => l_ParameterList
368: );
369: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'OBJECT_ID'
370: , p_value => TO_CHAR(p_Object_Id)
371: , p_parameterlist => l_ParameterList
372: );
373:

Line 374: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'OBJECT_CODE'

370: , p_value => TO_CHAR(p_Object_Id)
371: , p_parameterlist => l_ParameterList
372: );
373:
374: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'OBJECT_CODE'
375: , p_value => p_Object_Type
376: , p_parameterlist => l_ParameterList
377: );
378:

Line 379: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'OBJECT_START_DATE'

375: , p_value => p_Object_Type
376: , p_parameterlist => l_ParameterList
377: );
378:
379: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'OBJECT_START_DATE'
380: , p_value => TO_CHAR(p_Object_Start_Date,'MM/DD/YYYY')
381: , p_parameterlist => l_ParameterList
382: );
383:

Line 384: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'OBJECT_END_DATE'

380: , p_value => TO_CHAR(p_Object_Start_Date,'MM/DD/YYYY')
381: , p_parameterlist => l_ParameterList
382: );
383:
384: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'OBJECT_END_DATE'
385: , p_value => TO_CHAR(p_Object_End_Date,'MM/DD/YYYY')
386: , p_parameterlist => l_ParameterList
387: );
388: --

Line 391: WF_EVENT.RAISE3( p_event_name => l_EventName

387: );
388: --
389: -- Raise the event
390: --
391: WF_EVENT.RAISE3( p_event_name => l_EventName
392: , p_event_key => l_ItemKey
393: , p_event_data => NULL
394: , p_parameter_list => l_ParameterList
395: , p_send_date => SYSDATE

Line 441: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_ID'

437:
438: --
439: -- construct the parameter list
440: --
441: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_ID'
442: , p_value => TO_CHAR(p_Schedule_Id)
443: , p_parameterlist => l_ParameterList
444: );
445:

Line 446: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_CATEGORY'

442: , p_value => TO_CHAR(p_Schedule_Id)
443: , p_parameterlist => l_ParameterList
444: );
445:
446: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_CATEGORY'
447: , p_value => p_Schedule_Category
448: , p_parameterlist => l_ParameterList
449: );
450:

Line 451: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_START_DATE'

447: , p_value => p_Schedule_Category
448: , p_parameterlist => l_ParameterList
449: );
450:
451: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_START_DATE'
452: , p_value => TO_CHAR(p_Schdl_Start_Date,'MM/DD/YYYY')
453: , p_parameterlist => l_ParameterList
454: );
455:

Line 456: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_END_DATE'

452: , p_value => TO_CHAR(p_Schdl_Start_Date,'MM/DD/YYYY')
453: , p_parameterlist => l_ParameterList
454: );
455:
456: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_END_DATE'
457: , p_value => TO_CHAR(p_Schdl_End_Date,'MM/DD/YYYY')
458: , p_parameterlist => l_ParameterList
459: );
460: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'OBJECT_ID'

Line 460: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'OBJECT_ID'

456: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'SCHEDULE_END_DATE'
457: , p_value => TO_CHAR(p_Schdl_End_Date,'MM/DD/YYYY')
458: , p_parameterlist => l_ParameterList
459: );
460: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'OBJECT_ID'
461: , p_value => TO_CHAR(p_Object_Id)
462: , p_parameterlist => l_ParameterList
463: );
464:

Line 465: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'OBJECT_CODE'

461: , p_value => TO_CHAR(p_Object_Id)
462: , p_parameterlist => l_ParameterList
463: );
464:
465: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'OBJECT_CODE'
466: , p_value => p_Object_Type
467: , p_parameterlist => l_ParameterList
468: );
469:

Line 470: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'OBJECT_START_DATE'

466: , p_value => p_Object_Type
467: , p_parameterlist => l_ParameterList
468: );
469:
470: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'OBJECT_START_DATE'
471: , p_value => TO_CHAR(p_Object_Start_Date,'MM/DD/YYYY')
472: , p_parameterlist => l_ParameterList
473: );
474:

Line 475: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'OBJECT_END_DATE'

471: , p_value => TO_CHAR(p_Object_Start_Date,'MM/DD/YYYY')
472: , p_parameterlist => l_ParameterList
473: );
474:
475: WF_EVENT.ADDPARAMETERTOLIST( p_name => 'OBJECT_END_DATE'
476: , p_value => TO_CHAR(p_Object_End_Date,'MM/DD/YYYY')
477: , p_parameterlist => l_ParameterList
478: );
479: --

Line 482: WF_EVENT.RAISE3( p_event_name => l_EventName

478: );
479: --
480: -- Raise the event
481: --
482: WF_EVENT.RAISE3( p_event_name => l_EventName
483: , p_event_key => l_ItemKey
484: , p_event_data => NULL
485: , p_parameter_list => l_ParameterList
486: , p_send_date => SYSDATE