APPS.QA_ERES_UTIL dependencies on QA_RESULTS

Line 70: l_sql_string := 'SELECT '||l_res_col ||' FROM QA_RESULTS '

66: return NULL;
67: END IF;
68:
69:
70: l_sql_string := 'SELECT '||l_res_col ||' FROM QA_RESULTS '
71: || 'WHERE plan_id = :1'
72: || ' AND collection_id = :2'
73: || ' AND occurrence = :3';
74:

Line 389: FROM qa_results

385: x_xml_result OUT NOCOPY CLOB) IS
386: l_temp_xml CLOB;
387:
388: CURSOR c(coll_id IN varchar2) is SELECT distinct plan_id
389: FROM qa_results
390: WHERE plan_id || '-' || collection_id || '-' || occurrence NOT IN
391: (SELECT child_plan_id || '-' || child_collection_id || '-' || child_occurrence
392: FROM qa_pc_results_relationship
393: WHERE parent_collection_id = coll_id)

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 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 417: FROM qa_results

413: p_plan_id IN varchar2,
414: x_xml_result_plan OUT NOCOPY CLOB) IS
415: l_temp_xml CLOB;
416: CURSOR c(coll_id IN varchar2, l_plan_id IN varchar2) is SELECT plan_id || '-' || collection_id || '-' || occurrence doc_id
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);

Line 437: EDR_UTILITIES.GENERATE_XML( P_MAP_CODE => 'qa_results',

433: err_code NUMBER;
434: err_msg VARCHAR2(4000);
435: log_file VARCHAR2(4000);
436: BEGIN
437: EDR_UTILITIES.GENERATE_XML( P_MAP_CODE => 'qa_results',
438: P_DOCUMENT_ID => p_document_id,
439: P_XML => x_xml_result_row,
440: P_ERROR_CODE => err_code,
441: P_ERROR_MSG => err_msg,