APPS.XNP_WEB_UTILS dependencies on XNP_CALLBACK_EVENTS

Line 97: show_menu_item('SDPHOME_CALLBACK_DIAGNOSTICS',l_wa_path||'/xnp_callback_events$.startup');

93: show_menu_item('SDPHOME_APP_LOGIN','/OA_FORMS60/forms6');
94: show_menu_item('SDPHOME_NP_CENTER',l_wa_path||'/xnp_center$.startup');
95: show_menu_item('SDPHOME_MSG_DIAGNOSTICS',l_wa_path||'/xnp_msg_diagnostics$.startup');
96: show_menu_item('SDPHOME_TIMER_DIAGNOSTICS',l_wa_path||'/xnp_timers$.startup');
97: show_menu_item('SDPHOME_CALLBACK_DIAGNOSTICS',l_wa_path||'/xnp_callback_events$.startup');
98: htp.bodyClose;
99: END show_menu;
100:
101: PROCEDURE show_statistics_item (p_itemname VARCHAR2,p_num NUMBER,p_afternum VARCHAR2) IS

Line 216: select count(*) into l_num4 from XNP_CALLBACK_EVENTS where status ='WAITING' and MSG_CODE='ADAPTER_READY';

212:
213: select count(*) into l_num3 from XDP_FULFILL_WORKLIST where STATUS_CODE = 'ERROR';
214: l_link3 := '/OA_FORMS60/forms6';
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';