APPS.QA_ERES_UTIL dependencies on QA_RESULTS

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

59: return NULL;
60: END IF;
61:
62:
63: l_sql_string := 'SELECT '||l_res_col ||' FROM QA_RESULTS '
64: || 'WHERE plan_id = :1'
65: || ' AND collection_id = :2'
66: || ' AND occurrence = :3';
67:

Line 374: FROM qa_results

370: x_xml_result OUT NOCOPY CLOB) IS
371: l_temp_xml CLOB;
372:
373: CURSOR c(coll_id IN varchar2) is SELECT distinct plan_id
374: FROM qa_results
375: WHERE plan_id || '-' || collection_id || '-' || occurrence NOT IN
376: (SELECT child_plan_id || '-' || child_collection_id || '-' || child_occurrence
377: FROM qa_pc_results_relationship
378: WHERE parent_collection_id = coll_id)

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

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

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

418: err_code NUMBER;
419: err_msg VARCHAR2(4000);
420: log_file VARCHAR2(4000);
421: BEGIN
422: EDR_UTILITIES.GENERATE_XML( P_MAP_CODE => 'qa_results',
423: P_DOCUMENT_ID => p_document_id,
424: P_XML => x_xml_result_row,
425: P_ERROR_CODE => err_code,
426: P_ERROR_MSG => err_msg,