DBA Data[Home] [Help]

APPS.XNP_WEB_UTILS dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 222: select count(*) into l_num6 from WF_ITEM_ACTIVITY_STATUSES

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';
225:
226: select count(*) into l_num8 from WF_ITEM_ACTIVITY_STATUSES

Line 226: select count(*) into l_num8 from WF_ITEM_ACTIVITY_STATUSES

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';
225:
226: select count(*) into l_num8 from WF_ITEM_ACTIVITY_STATUSES
227: where (ITEM_TYPE like 'XDP%' and ACTIVITY_STATUS = 'ERROR');
228: l_link8 := l_wf_path||'/wf_monitor.instance_list?x_active=ALL&x_itemtype=*&x_status=ERROR&x_admin_privilege=Y';
229:
230: l_name := '';