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_PARENT_CHILD_PKG dependencies on QA_PC_CRITERIA

Line 387: --- relationship through plan_relationship_id in qa_pc_criteria table.

383: RETURN VARCHAR2 IS
384:
385: ---
386: --- This function first finds out all the criteria for the parent-child
387: --- relationship through plan_relationship_id in qa_pc_criteria table.
388: --- If no criteria found then return true
389: --- else finds out all the char_id and its associated values
390: --- for the plan_relationship_id.
391:

Line 411: FROM qa_pc_criteria qpc ,qa_chars qc

407: l_ret_value VARCHAR2(1);
408: l_datatype NUMBER;
409:
410: CURSOR c IS SELECT qpc.char_id,qpc.operator,qpc.low_value,qpc.high_value,qc.datatype
411: FROM qa_pc_criteria qpc ,qa_chars qc
412: WHERE qpc.plan_relationship_id = p_plan_relationship_id
413: AND qpc.char_id = qc.char_id;
414: BEGIN
415:

Line 431: -- with the criteria for the same element in qa_pc_criteria

427: END IF;
428:
429: -- There are records for the plan_relationship_id, our next job is to
430: -- check the value entered in the parent plan for the element, matches
431: -- with the criteria for the same element in qa_pc_criteria
432:
433: IF (p_criteria_array.EXISTS(l_char_id)) THEN
434:
435: IF( QLTCOMPB.compare(p_criteria_array(l_char_id).value,

Line 4485: qa_pc_criteria qpc,

4481: SELECT REPLACE(DECODE(QC.HARDCODED_COLUMN, NULL ,QAPC.RESULT_COLUMN_NAME,QC.DEVELOPER_NAME),
4482: 'CHARACTER','DISPLAY') FORM_FIELD
4483: BULK COLLECT INTO result_column_name_tab
4484: FROM qa_pc_plan_relationship qppr,
4485: qa_pc_criteria qpc,
4486: qa_results qr,
4487: qa_plan_chars qapc,
4488: qa_chars qc
4489: WHERE qpc.plan_relationship_id = qppr.plan_relationship_id