eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QA_ERES_UTIL dependencies on DBMS_LOB

Line 382: dbms_lob.createtemporary(x_xml_result,true);

378: WHERE parent_collection_id = coll_id)
379: AND collection_id = coll_id;
380:
381: BEGIN
382: dbms_lob.createtemporary(x_xml_result,true);
383: dbms_lob.append(x_xml_result,'' );
384: FOR l_plan IN c(p_collection_id)
385: LOOP
386: generate_xml_for_plan(p_collection_id,l_plan.plan_id,l_temp_xml);

Line 383: dbms_lob.append(x_xml_result,'' );

379: AND collection_id = coll_id;
380:
381: BEGIN
382: dbms_lob.createtemporary(x_xml_result,true);
383: dbms_lob.append(x_xml_result,'' );
384: FOR l_plan IN c(p_collection_id)
385: LOOP
386: generate_xml_for_plan(p_collection_id,l_plan.plan_id,l_temp_xml);
387: dbms_lob.append(x_xml_result,'');

Line 387: dbms_lob.append(x_xml_result,'');

383: dbms_lob.append(x_xml_result,'' );
384: FOR l_plan IN c(p_collection_id)
385: LOOP
386: generate_xml_for_plan(p_collection_id,l_plan.plan_id,l_temp_xml);
387: dbms_lob.append(x_xml_result,'');
388: dbms_lob.append(x_xml_result,l_temp_xml);
389: dbms_lob.append(x_xml_result,'');
390: END LOOP;
391: dbms_lob.append(x_xml_result,'');

Line 388: dbms_lob.append(x_xml_result,l_temp_xml);

384: FOR l_plan IN c(p_collection_id)
385: LOOP
386: generate_xml_for_plan(p_collection_id,l_plan.plan_id,l_temp_xml);
387: dbms_lob.append(x_xml_result,'');
388: dbms_lob.append(x_xml_result,l_temp_xml);
389: dbms_lob.append(x_xml_result,'');
390: END LOOP;
391: dbms_lob.append(x_xml_result,'');
392:

Line 389: dbms_lob.append(x_xml_result,'');

385: LOOP
386: generate_xml_for_plan(p_collection_id,l_plan.plan_id,l_temp_xml);
387: dbms_lob.append(x_xml_result,'');
388: dbms_lob.append(x_xml_result,l_temp_xml);
389: dbms_lob.append(x_xml_result,'');
390: END LOOP;
391: dbms_lob.append(x_xml_result,'');
392:
393: END generate_xml;

Line 391: dbms_lob.append(x_xml_result,'');

387: dbms_lob.append(x_xml_result,'');
388: dbms_lob.append(x_xml_result,l_temp_xml);
389: dbms_lob.append(x_xml_result,'');
390: END LOOP;
391: dbms_lob.append(x_xml_result,'');
392:
393: END generate_xml;
394:
395: -- This procedure takes in the collection id, plan_id

Line 406: dbms_lob.createtemporary(x_xml_result_plan,true);

402: FROM qa_results
403: WHERE plan_id = l_plan_id
404: AND collection_id = coll_id;
405: BEGIN
406: dbms_lob.createtemporary(x_xml_result_plan,true);
407: FOR l_doc_id IN c(p_collection_id, p_plan_id)
408: LOOP
409: get_xml_for_row(l_doc_id.doc_id,l_temp_xml);
410: dbms_lob.append(x_xml_result_plan,l_temp_xml);

Line 410: dbms_lob.append(x_xml_result_plan,l_temp_xml);

406: dbms_lob.createtemporary(x_xml_result_plan,true);
407: FOR l_doc_id IN c(p_collection_id, p_plan_id)
408: LOOP
409: get_xml_for_row(l_doc_id.doc_id,l_temp_xml);
410: dbms_lob.append(x_xml_result_plan,l_temp_xml);
411: END LOOP;
412: END generate_xml_for_plan;
413:
414: -- This procedure generates the XML CLOB object for for a particular