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 397: dbms_lob.createtemporary(x_xml_result,true);

393: WHERE parent_collection_id = coll_id)
394: AND collection_id = coll_id;
395:
396: BEGIN
397: dbms_lob.createtemporary(x_xml_result,true);
398: dbms_lob.append(x_xml_result,'' );
399: FOR l_plan IN c(p_collection_id)
400: LOOP
401: generate_xml_for_plan(p_collection_id,l_plan.plan_id,l_temp_xml);

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

394: AND collection_id = coll_id;
395:
396: BEGIN
397: dbms_lob.createtemporary(x_xml_result,true);
398: dbms_lob.append(x_xml_result,'' );
399: FOR l_plan IN c(p_collection_id)
400: LOOP
401: generate_xml_for_plan(p_collection_id,l_plan.plan_id,l_temp_xml);
402: dbms_lob.append(x_xml_result,'');

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

398: dbms_lob.append(x_xml_result,'' );
399: FOR l_plan IN c(p_collection_id)
400: LOOP
401: generate_xml_for_plan(p_collection_id,l_plan.plan_id,l_temp_xml);
402: dbms_lob.append(x_xml_result,'');
403: dbms_lob.append(x_xml_result,l_temp_xml);
404: dbms_lob.append(x_xml_result,'');
405: END LOOP;
406: dbms_lob.append(x_xml_result,'');

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

399: FOR l_plan IN c(p_collection_id)
400: LOOP
401: generate_xml_for_plan(p_collection_id,l_plan.plan_id,l_temp_xml);
402: dbms_lob.append(x_xml_result,'');
403: dbms_lob.append(x_xml_result,l_temp_xml);
404: dbms_lob.append(x_xml_result,'');
405: END LOOP;
406: dbms_lob.append(x_xml_result,'');
407:

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

400: LOOP
401: generate_xml_for_plan(p_collection_id,l_plan.plan_id,l_temp_xml);
402: dbms_lob.append(x_xml_result,'');
403: dbms_lob.append(x_xml_result,l_temp_xml);
404: dbms_lob.append(x_xml_result,'');
405: END LOOP;
406: dbms_lob.append(x_xml_result,'');
407:
408: END generate_xml;

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

402: dbms_lob.append(x_xml_result,'');
403: dbms_lob.append(x_xml_result,l_temp_xml);
404: dbms_lob.append(x_xml_result,'');
405: END LOOP;
406: dbms_lob.append(x_xml_result,'');
407:
408: END generate_xml;
409:
410: -- This procedure takes in the collection id, plan_id

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

417: FROM qa_results
418: WHERE plan_id = l_plan_id
419: AND collection_id = coll_id;
420: BEGIN
421: dbms_lob.createtemporary(x_xml_result_plan,true);
422: FOR l_doc_id IN c(p_collection_id, p_plan_id)
423: LOOP
424: get_xml_for_row(l_doc_id.doc_id,l_temp_xml);
425: dbms_lob.append(x_xml_result_plan,l_temp_xml);

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

421: dbms_lob.createtemporary(x_xml_result_plan,true);
422: FOR l_doc_id IN c(p_collection_id, p_plan_id)
423: LOOP
424: get_xml_for_row(l_doc_id.doc_id,l_temp_xml);
425: dbms_lob.append(x_xml_result_plan,l_temp_xml);
426: END LOOP;
427: END generate_xml_for_plan;
428:
429: -- This procedure generates the XML CLOB object for for a particular