APPS.HZ_DQM_DIAGNOSTICS_XML dependencies on FND_CONCURRENT_REQUESTS

Line 182: select count(*) into l_schedule_cnt from fnd_concurrent_requests where concurrent_program_id=44464

178: l_xml_header := l_xml_header ||l_new_line||''||to_char(l_st_pcnpts_size)||'';
179: l_xml_header := l_xml_header || l_new_line||''||to_char(GET_TABLE_SIZE('HZ_CONTACT_POINTS'))||'';
180: l_xml_header := l_xml_header ||l_new_line||''||l_index_time||'';
181:
182: select count(*) into l_schedule_cnt from fnd_concurrent_requests where concurrent_program_id=44464
183: and phase_code='P';
184:
185: if(l_schedule_cnt>0) then
186: l_xml_header := l_xml_header ||l_new_line||'Yes';

Line 476: from FND_CONCURRENT_REQUESTS where status_code=''Q'' and phase_code=''P'' and program_application_id=222

472: END IF;
473:
474:
475: qryCtx := dbms_xmlgen.newContext('select request_id,last_update_date,request_date, phase_code,status_code,to_char(requested_start_date,''DD-MON-YY HH24:MI:SS'') requested_start_date,concurrent_program_id
476: from FND_CONCURRENT_REQUESTS where status_code=''Q'' and phase_code=''P'' and program_application_id=222
477: and concurrent_program_id in(select concurrent_program_id from fnd_concurrent_programs where concurrent_program_name=''ARHDQSYN'')');
478: DBMS_XMLGEN.setRowTag(qryCtx, 'Sync program Schedule');
479: l_result := DBMS_XMLGEN.getXML(qryCtx);
480: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);