DBA Data[Home] [Help]

APPS.XNP_WEB_UTILS dependencies on WF_NOTIFICATIONS

Line 206: select count(*) into l_num1 from WF_NOTIFICATIONS where status = 'OPEN';

202: BEGIN
203: select text into l_wf_path from wf_resources where name = 'WF_WEB_AGENT';
204: FND_PROFILE.GET('APPS_WEB_AGENT', l_wa_path);
205:
206: select count(*) into l_num1 from WF_NOTIFICATIONS where status = 'OPEN';
207: -- l_link1 := l_wf_path||'/wfa_html.WorkList?status=OPEN&ittype=*&user=WFADMIN&resetcookie=1&priority=*';
208: l_link1 := l_wf_path||'/wfa_html.login';
209:
210: select count(*) into l_num2 from XDP_ADAPTER_REG where ADAPTER_STATUS = 'ERROR';