178: l_xml_header := l_xml_header ||l_new_line||'
179: l_xml_header := l_xml_header || l_new_line||'
180: l_xml_header := l_xml_header ||l_new_line||'
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||'
470: END IF;
471:
472:
473: 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
474: from FND_CONCURRENT_REQUESTS where status_code=''Q'' and phase_code=''P'' and program_application_id=222
475: and concurrent_program_id in(select concurrent_program_id from fnd_concurrent_programs where concurrent_program_name=''ARHDQSYN'')');
476: DBMS_XMLGEN.setRowTag(qryCtx, 'Sync program Schedule');
477: l_result := DBMS_XMLGEN.getXML(qryCtx);
478: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);