[Home] [Help]
392: RETURN VARCHAR2 IS
393:
394: ---
395: --- This function first finds out all the criteria for the parent-child
396: --- relationship through plan_relationship_id in qa_pc_criteria table.
397: --- If no criteria found then return true
398: --- else finds out all the char_id and its associated values
399: --- for the plan_relationship_id.
400:
416: l_ret_value VARCHAR2(1);
417: l_datatype NUMBER;
418:
419: CURSOR c IS SELECT qpc.char_id,qpc.operator,qpc.low_value,qpc.high_value,qc.datatype
420: FROM qa_pc_criteria qpc ,qa_chars qc
421: WHERE qpc.plan_relationship_id = p_plan_relationship_id
422: AND qpc.char_id = qc.char_id;
423: BEGIN
424:
436: END IF;
437:
438: -- There are records for the plan_relationship_id, our next job is to
439: -- check the value entered in the parent plan for the element, matches
440: -- with the criteria for the same element in qa_pc_criteria
441:
442: IF (p_criteria_array.EXISTS(l_char_id)) THEN
443:
444: IF( QLTCOMPB.compare(p_criteria_array(l_char_id).value,
4892: SELECT REPLACE(DECODE(QC.HARDCODED_COLUMN, NULL ,QAPC.RESULT_COLUMN_NAME,QC.DEVELOPER_NAME),
4893: 'CHARACTER','DISPLAY') FORM_FIELD
4894: BULK COLLECT INTO result_column_name_tab
4895: FROM qa_pc_plan_relationship qppr,
4896: qa_pc_criteria qpc,
4897: qa_results qr,
4898: qa_plan_chars qapc,
4899: qa_chars qc
4900: WHERE qpc.plan_relationship_id = qppr.plan_relationship_id