DBA Data[Home] [Help]

APPS.XNP_WEB_UTILS dependencies on XDP_DQ_CONFIGURATION

Line 200: select q_alias from XDP_DQ_CONFIGURATION WHERE state = 'DISABLED';

196: tmp VARCHAR2(40);
197: l_wf_path VARCHAR2(80);
198: l_wa_path VARCHAR2(80);
199: cursor c_queue IS
200: select q_alias from XDP_DQ_CONFIGURATION WHERE state = 'DISABLED';
201:
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);

Line 234: --select count(*) into l_num7 from XDP_DQ_CONFIGURATION where state = 'DISABLED';

230: l_name := '';
231: for c_queue_rec in c_queue LOOP
232: l_name := l_name || c_queue_rec.q_alias || ' ';
233: END LOOP;
234: --select count(*) into l_num7 from XDP_DQ_CONFIGURATION where state = 'DISABLED';
235: l_link7 := '/OA_FORMS60/forms6';
236:
237: htp.bodyOpen;
238: show_alert_item1('SDPHOME_ALERT_ADAPTER',l_num2, l_link2, 'XNPRDFLG.gif');