APPS.XNP_WEB_UTILS dependencies on XDP_FULFILL_WORKLIST

Line 125: select count(*) into l_xdp_workitems from XDP_FULFILL_WORKLIST ;

121:
122: select count(*) into l_inquery_portings from xnp_sv_soa_vl
123: where status_phase IN ('INQUIRY');
124:
125: select count(*) into l_xdp_workitems from XDP_FULFILL_WORKLIST ;
126:
127: htp.bodyOpen;
128: show_statistics_item('SDPHOME_INPROGRESS_PORTING', l_inprogress_portings, '');
129: show_statistics_item('SDPHOME_INQUERY_PORTING', l_inquery_portings, '');

Line 213: select count(*) into l_num3 from XDP_FULFILL_WORKLIST where STATUS_CODE = 'ERROR';

209:
210: select count(*) into l_num2 from XDP_ADAPTER_REG where ADAPTER_STATUS = 'ERROR';
211: l_link2 := '/OA_FORMS60/forms6';
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';