APPS.XNP_WEB_UTILS dependencies on XNP_MSGS

Line 67: select avg (send_rcv_date - msg_creation_date ) into l_msg_days from xnp_msgs

63: PROCEDURE show_indicators IS
64: l_msg_days NUMBER(5,2);
65: BEGIN
66:
67: select avg (send_rcv_date - msg_creation_date ) into l_msg_days from xnp_msgs
68: where send_rcv_date is not null;
69:
70: htp.bodyOpen;
71:

Line 219: select count(*) into l_num5 from XNP_MSGS where MSG_STATUS = 'FAILED';

215:
216: select count(*) into l_num4 from XNP_CALLBACK_EVENTS where status ='WAITING' and MSG_CODE='ADAPTER_READY';
217: l_link4 := '/OA_FORMS60/forms6';
218:
219: select count(*) into l_num5 from XNP_MSGS where MSG_STATUS = 'FAILED';
220: l_link5 := l_wa_path||'/xnp_msg_diagnostics$xnp_msgs.actionquery?Z_CHK=0&p_msg_status=FAILED';
221:
222: select count(*) into l_num6 from WF_ITEM_ACTIVITY_STATUSES
223: where (ITEM_TYPE like 'XNP%' and ACTIVITY_STATUS = 'ERROR');

Line 220: l_link5 := l_wa_path||'/xnp_msg_diagnostics$xnp_msgs.actionquery?Z_CHK=0&p_msg_status=FAILED';

216: select count(*) into l_num4 from XNP_CALLBACK_EVENTS where status ='WAITING' and MSG_CODE='ADAPTER_READY';
217: l_link4 := '/OA_FORMS60/forms6';
218:
219: select count(*) into l_num5 from XNP_MSGS where MSG_STATUS = 'FAILED';
220: l_link5 := l_wa_path||'/xnp_msg_diagnostics$xnp_msgs.actionquery?Z_CHK=0&p_msg_status=FAILED';
221:
222: select count(*) into l_num6 from WF_ITEM_ACTIVITY_STATUSES
223: where (ITEM_TYPE like 'XNP%' and ACTIVITY_STATUS = 'ERROR');
224: l_link6 := l_wf_path||'/wf_monitor.instance_list?x_active=ALL&x_itemtype=*&x_status=ERROR&x_admin_privilege=Y';