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.WF_OAM_METRICS dependencies on FND_USER_PREFERENCES

Line 55: update FND_USER_PREFERENCES set preference_value = to_char(activeCount) where preference_name = 'NUM_ACTIVE' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFItemsGraph';

51: WHERE activity_status = 'ERROR');
52:
53: SELECT count(*) into suspendedCount FROM wf_item_activity_statuses WHERE activity_status = 'SUSPEND';
54:
55: update FND_USER_PREFERENCES set preference_value = to_char(activeCount) where preference_name = 'NUM_ACTIVE' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFItemsGraph';
56:
57: update FND_USER_PREFERENCES set preference_value = to_char(deferredCount) where preference_name = 'NUM_DEFER' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFItemsGraph';
58:
59: update FND_USER_PREFERENCES set preference_value = to_char(erroredCount) where preference_name = 'NUM_ERROR' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFItemsGraph';

Line 57: update FND_USER_PREFERENCES set preference_value = to_char(deferredCount) where preference_name = 'NUM_DEFER' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFItemsGraph';

53: SELECT count(*) into suspendedCount FROM wf_item_activity_statuses WHERE activity_status = 'SUSPEND';
54:
55: update FND_USER_PREFERENCES set preference_value = to_char(activeCount) where preference_name = 'NUM_ACTIVE' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFItemsGraph';
56:
57: update FND_USER_PREFERENCES set preference_value = to_char(deferredCount) where preference_name = 'NUM_DEFER' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFItemsGraph';
58:
59: update FND_USER_PREFERENCES set preference_value = to_char(erroredCount) where preference_name = 'NUM_ERROR' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFItemsGraph';
60:
61: update FND_USER_PREFERENCES set preference_value = to_char(suspendedCount) where preference_name = 'NUM_SUSPEND' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFItemsGraph';

Line 59: update FND_USER_PREFERENCES set preference_value = to_char(erroredCount) where preference_name = 'NUM_ERROR' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFItemsGraph';

55: update FND_USER_PREFERENCES set preference_value = to_char(activeCount) where preference_name = 'NUM_ACTIVE' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFItemsGraph';
56:
57: update FND_USER_PREFERENCES set preference_value = to_char(deferredCount) where preference_name = 'NUM_DEFER' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFItemsGraph';
58:
59: update FND_USER_PREFERENCES set preference_value = to_char(erroredCount) where preference_name = 'NUM_ERROR' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFItemsGraph';
60:
61: update FND_USER_PREFERENCES set preference_value = to_char(suspendedCount) where preference_name = 'NUM_SUSPEND' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFItemsGraph';
62:
63: --Update the Last Updated Time

Line 61: update FND_USER_PREFERENCES set preference_value = to_char(suspendedCount) where preference_name = 'NUM_SUSPEND' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFItemsGraph';

57: update FND_USER_PREFERENCES set preference_value = to_char(deferredCount) where preference_name = 'NUM_DEFER' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFItemsGraph';
58:
59: update FND_USER_PREFERENCES set preference_value = to_char(erroredCount) where preference_name = 'NUM_ERROR' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFItemsGraph';
60:
61: update FND_USER_PREFERENCES set preference_value = to_char(suspendedCount) where preference_name = 'NUM_SUSPEND' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFItemsGraph';
62:
63: --Update the Last Updated Time
64: update fnd_user_preferences
65: set preference_value = to_char(sysdate,'dd/MM/YYYY HH24:MI:SS')

Line 64: update fnd_user_preferences

60:
61: update FND_USER_PREFERENCES set preference_value = to_char(suspendedCount) where preference_name = 'NUM_SUSPEND' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFItemsGraph';
62:
63: --Update the Last Updated Time
64: update fnd_user_preferences
65: set preference_value = to_char(sysdate,'dd/MM/YYYY HH24:MI:SS')
66: where preference_name = 'LAST_UPDATE_TIME' and
67: module_name = 'WFManagerWFItemsGraph' and
68: user_name = '-WF_DEFAULT-';

Line 109: update fnd_user_preferences

105:
106: end loop;
107: close wf_items_cursor;
108:
109: update fnd_user_preferences
110: set preference_value = to_char(sysdate,'dd/MM/YYYY HH24:MI:SS')
111: where preference_name = 'LAST_UPDATE_TIME' and
112: module_name = 'WFManagerActiveWFItems' and
113: user_name = '-WF_DEFAULT-';

Line 156: update fnd_user_preferences

152:
153: end loop;
154: close wf_items_cursor;
155:
156: update fnd_user_preferences
157: set preference_value = to_char(sysdate,'dd/MM/YYYY HH24:MI:SS')
158: where preference_name = 'LAST_UPDATE_TIME' and
159: module_name = 'WFManagerErrorWFItems' and
160: user_name = '-WF_DEFAULT-';

Line 203: update fnd_user_preferences

199:
200: end loop;
201: close wf_items_cursor;
202:
203: update fnd_user_preferences
204: set preference_value = to_char(sysdate,'dd/MM/YYYY HH24:MI:SS')
205: where preference_name = 'LAST_UPDATE_TIME' and
206: module_name = 'WFManagerDeferWFItems' and
207: user_name = '-WF_DEFAULT-';

Line 250: update fnd_user_preferences

246:
247: end loop;
248: close wf_items_cursor;
249:
250: update fnd_user_preferences
251: set preference_value = to_char(sysdate,'dd/MM/YYYY HH24:MI:SS')
252: where preference_name = 'LAST_UPDATE_TIME' and
253: module_name = 'WFManagerSuspendWFItems' and
254: user_name = '-WF_DEFAULT-';

Line 302: update fnd_user_preferences

298:
299: end loop;
300: close wf_items_cursor;
301:
302: update fnd_user_preferences
303: set preference_value = to_char(sysdate,'dd/MM/YYYY HH24:MI:SS')
304: where preference_name = 'LAST_UPDATE_TIME' and
305: module_name = 'WFManagerCompleteWFItems' and
306: user_name = '-WF_DEFAULT-';

Line 358: update FND_USER_PREFERENCES set preference_value = to_char(readyCount) where preference_name = 'NUM_READY' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFAgentsGraph';

354: wf_queue.getcntmsgst(agentname, readyCount, waitingCount, processedCount,
355: expiredCount, undeliverableCount, erroredCount);
356:
357:
358: update FND_USER_PREFERENCES set preference_value = to_char(readyCount) where preference_name = 'NUM_READY' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFAgentsGraph';
359:
360: update FND_USER_PREFERENCES set preference_value = to_char(waitingCount) where preference_name = 'NUM_WAITING' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFAgentsGraph';
361:
362: update FND_USER_PREFERENCES set preference_value = to_char(processedCount) where preference_name = 'NUM_PROCESSED' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFAgentsGraph';

Line 360: update FND_USER_PREFERENCES set preference_value = to_char(waitingCount) where preference_name = 'NUM_WAITING' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFAgentsGraph';

356:
357:
358: update FND_USER_PREFERENCES set preference_value = to_char(readyCount) where preference_name = 'NUM_READY' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFAgentsGraph';
359:
360: update FND_USER_PREFERENCES set preference_value = to_char(waitingCount) where preference_name = 'NUM_WAITING' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFAgentsGraph';
361:
362: update FND_USER_PREFERENCES set preference_value = to_char(processedCount) where preference_name = 'NUM_PROCESSED' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFAgentsGraph';
363:
364: update FND_USER_PREFERENCES set preference_value = to_char(expiredCount) where preference_name = 'NUM_EXPIRED' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFAgentsGraph';

Line 362: update FND_USER_PREFERENCES set preference_value = to_char(processedCount) where preference_name = 'NUM_PROCESSED' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFAgentsGraph';

358: update FND_USER_PREFERENCES set preference_value = to_char(readyCount) where preference_name = 'NUM_READY' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFAgentsGraph';
359:
360: update FND_USER_PREFERENCES set preference_value = to_char(waitingCount) where preference_name = 'NUM_WAITING' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFAgentsGraph';
361:
362: update FND_USER_PREFERENCES set preference_value = to_char(processedCount) where preference_name = 'NUM_PROCESSED' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFAgentsGraph';
363:
364: update FND_USER_PREFERENCES set preference_value = to_char(expiredCount) where preference_name = 'NUM_EXPIRED' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFAgentsGraph';
365:
366: update FND_USER_PREFERENCES set preference_value = to_char(undeliverableCount) where preference_name = 'NUM_UNDELIV' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFAgentsGraph';

Line 364: update FND_USER_PREFERENCES set preference_value = to_char(expiredCount) where preference_name = 'NUM_EXPIRED' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFAgentsGraph';

360: update FND_USER_PREFERENCES set preference_value = to_char(waitingCount) where preference_name = 'NUM_WAITING' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFAgentsGraph';
361:
362: update FND_USER_PREFERENCES set preference_value = to_char(processedCount) where preference_name = 'NUM_PROCESSED' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFAgentsGraph';
363:
364: update FND_USER_PREFERENCES set preference_value = to_char(expiredCount) where preference_name = 'NUM_EXPIRED' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFAgentsGraph';
365:
366: update FND_USER_PREFERENCES set preference_value = to_char(undeliverableCount) where preference_name = 'NUM_UNDELIV' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFAgentsGraph';
367:
368: update FND_USER_PREFERENCES set preference_value = to_char(erroredCount) where preference_name = 'NUM_ERROR' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFAgentsGraph';

Line 366: update FND_USER_PREFERENCES set preference_value = to_char(undeliverableCount) where preference_name = 'NUM_UNDELIV' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFAgentsGraph';

362: update FND_USER_PREFERENCES set preference_value = to_char(processedCount) where preference_name = 'NUM_PROCESSED' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFAgentsGraph';
363:
364: update FND_USER_PREFERENCES set preference_value = to_char(expiredCount) where preference_name = 'NUM_EXPIRED' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFAgentsGraph';
365:
366: update FND_USER_PREFERENCES set preference_value = to_char(undeliverableCount) where preference_name = 'NUM_UNDELIV' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFAgentsGraph';
367:
368: update FND_USER_PREFERENCES set preference_value = to_char(erroredCount) where preference_name = 'NUM_ERROR' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFAgentsGraph';
369:
370: update fnd_user_preferences

Line 368: update FND_USER_PREFERENCES set preference_value = to_char(erroredCount) where preference_name = 'NUM_ERROR' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFAgentsGraph';

364: update FND_USER_PREFERENCES set preference_value = to_char(expiredCount) where preference_name = 'NUM_EXPIRED' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFAgentsGraph';
365:
366: update FND_USER_PREFERENCES set preference_value = to_char(undeliverableCount) where preference_name = 'NUM_UNDELIV' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFAgentsGraph';
367:
368: update FND_USER_PREFERENCES set preference_value = to_char(erroredCount) where preference_name = 'NUM_ERROR' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFAgentsGraph';
369:
370: update fnd_user_preferences
371: set preference_value = to_char(sysdate,'dd/MM/YYYY HH24:MI:SS')
372: where preference_name = 'LAST_UPDATE_TIME' and

Line 370: update fnd_user_preferences

366: update FND_USER_PREFERENCES set preference_value = to_char(undeliverableCount) where preference_name = 'NUM_UNDELIV' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFAgentsGraph';
367:
368: update FND_USER_PREFERENCES set preference_value = to_char(erroredCount) where preference_name = 'NUM_ERROR' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFAgentsGraph';
369:
370: update fnd_user_preferences
371: set preference_value = to_char(sysdate,'dd/MM/YYYY HH24:MI:SS')
372: where preference_name = 'LAST_UPDATE_TIME' and
373: module_name = 'WFManagerWFAgentsGraph' and
374: user_name = '-WF_DEFAULT-';

Line 433: update fnd_user_preferences

429: system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID'));
430:
431: end loop;
432:
433: update fnd_user_preferences
434: set preference_value = to_char(sysdate,'dd/MM/YYYY HH24:MI:SS')
435: where preference_name = 'LAST_UPDATE_TIME' and
436: module_name = 'WFManagerWFAgents' and
437: user_name = '-WF_DEFAULT-';

Line 510: UPDATE FND_USER_PREFERENCES

506:
507: SELECT count(*) into waitingCount FROM wf_notifications
508: WHERE mail_status = 'MAIL';
509:
510: UPDATE FND_USER_PREFERENCES
511: SET preference_value = to_char(processedCount)
512: WHERE preference_name = 'NUM_PROCESSED' and
513: user_name='-WF_DEFAULT-' and module_name='WFManagerWFNtfsGraph';
514:

Line 515: UPDATE FND_USER_PREFERENCES SET preference_value = to_char(waitingCount) WHERE preference_name = 'NUM_WAITING' and

511: SET preference_value = to_char(processedCount)
512: WHERE preference_name = 'NUM_PROCESSED' and
513: user_name='-WF_DEFAULT-' and module_name='WFManagerWFNtfsGraph';
514:
515: UPDATE FND_USER_PREFERENCES SET preference_value = to_char(waitingCount) WHERE preference_name = 'NUM_WAITING' and
516: user_name='-WF_DEFAULT-' and module_name='WFManagerWFNtfsGraph';
517:
518:
519: UPDATE fnd_user_preferences

Line 519: UPDATE fnd_user_preferences

515: UPDATE FND_USER_PREFERENCES SET preference_value = to_char(waitingCount) WHERE preference_name = 'NUM_WAITING' and
516: user_name='-WF_DEFAULT-' and module_name='WFManagerWFNtfsGraph';
517:
518:
519: UPDATE fnd_user_preferences
520: set preference_value = to_char(sysdate,'dd/MM/YYYY HH24:MI:SS')
521: where preference_name = 'LAST_UPDATE_TIME' and
522: module_name = 'WFManagerWFNtfsGraph' and
523: user_name = '-WF_DEFAULT-';