APPS.WF_OAM_METRICS dependencies on WF_AGENTS

Line 396: cursor wf_agents_cursor is

392: erroredCount number := 0;
393:
394: agentName varchar2(60);
395:
396: cursor wf_agents_cursor is
397: SELECT distinct(queue_name) as queue_name FROM wf_agents
398: WHERE queue_name is not null
399: AND queue_name not like '%WF_SMTP_O_1_QUEUE'
400: AND system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID'));

Line 397: SELECT distinct(queue_name) as queue_name FROM wf_agents

393:
394: agentName varchar2(60);
395:
396: cursor wf_agents_cursor is
397: SELECT distinct(queue_name) as queue_name FROM wf_agents
398: WHERE queue_name is not null
399: AND queue_name not like '%WF_SMTP_O_1_QUEUE'
400: AND system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID'));
401:

Line 405: UPDATE wf_agents

401:
402:
403: begin
404:
405: UPDATE wf_agents
406: SET NUM_READY = 0, NUM_WAITING = 0, NUM_EXPIRED = 0, NUM_UNDELIV = 0,
407: NUM_ERROR = 0, NUM_PROCESS = 0;
408:
409:

Line 410: for agent_row in wf_agents_cursor loop

406: SET NUM_READY = 0, NUM_WAITING = 0, NUM_EXPIRED = 0, NUM_UNDELIV = 0,
407: NUM_ERROR = 0, NUM_PROCESS = 0;
408:
409:
410: for agent_row in wf_agents_cursor loop
411: readyCount := 0;
412: waitingCount := 0;
413: processedCount := 0;
414: expiredCount := 0;

Line 424: update wf_agents

420: wf_queue.getcntmsgst(agentName, readyCount, waitingCount,
421: processedCount, expiredCount, undeliverableCount,
422: erroredCount);
423:
424: update wf_agents
425: SET NUM_READY = readyCount, NUM_WAITING = waitingCount,
426: NUM_EXPIRED = expiredCount, NUM_UNDELIV = undeliverableCount,
427: NUM_ERROR = erroredCount, NUM_PROCESS = processedCount
428: WHERE queue_name = agent_row.queue_name and