[Home] [Help]
655: -- the default values for elements and store them in
656: -- an array.
657: -- skolluku
658: --
659: TYPE def_arr_typ IS TABLE OF QA_PLAN_CHARS.DEFAULT_VALUE%TYPE INDEX BY BINARY_INTEGER;
660: def_arr def_arr_typ;
661: cntr NUMBER;
662: CURSOR def_cur(c_child_plan_id NUMBER) IS
663: SELECT
662: CURSOR def_cur(c_child_plan_id NUMBER) IS
663: SELECT
664: qpc.char_id,
665: qpc.default_value
666: FROM qa_plan_chars qpc,
667: qa_plans qp
668: WHERE qp.plan_id = qpc.plan_id
669: AND qpc.default_value IS NOT NULL
670: AND qpc.enabled_flag=1
705:
706: -- Bug 4958734. SQL Repository Fix SQL ID: 15007931
707: CURSOR child_seq_char_ids(c_child_plan_id NUMBER) IS
708: SELECT qc.char_id
709: FROM qa_plan_chars qpc, qa_chars qc
710: WHERE qpc.plan_id = c_child_plan_id
711: AND qpc.char_id = qc.char_id
712: AND qpc.enabled_flag = 1
713: AND qc.datatype = 5
719: AND parent_enabled_flag = 1
720: AND child_enabled_flag = 1;
721: /*
722: SELECT qc.char_id
723: FROM qa_plan_chars qpc,
724: qa_chars qc
725: WHERE qpc.plan_id = c_child_plan_id
726: AND qpc.char_id = qc.char_id
727: AND qpc.enabled_flag = 1
1300: qpc2.result_column_name child_database_column
1301: from
1302: qa_pc_plan_relationship pr,
1303: qa_pc_element_relationship pe,
1304: qa_plan_chars qpc1,
1305: qa_plan_chars qpc2
1306: where
1307: pr.plan_relationship_id = pe.plan_relationship_id and
1308: pr.parent_plan_id = qpc1.plan_id and
1301: from
1302: qa_pc_plan_relationship pr,
1303: qa_pc_element_relationship pe,
1304: qa_plan_chars qpc1,
1305: qa_plan_chars qpc2
1306: where
1307: pr.plan_relationship_id = pe.plan_relationship_id and
1308: pr.parent_plan_id = qpc1.plan_id and
1309: pe.parent_char_id = qpc1.char_id and
2070: -- Bug 8546279.Changed cursor query to inclide date type elements too
2071: -- collecting datatype too for datatype 3,date and 6,datetime.pdube
2072: Cursor cur (p_plan_id in NUMBER, p_res_col in VARCHAR2) is
2073: Select 1, qc.hardcoded_column, qc.datatype
2074: from qa_plan_chars qpc, qa_chars qc
2075: where qpc.plan_id = p_plan_id
2076: and qpc.char_id = qc.char_id
2077: and qpc.result_column_name = p_res_col
2078: and qc.datatype in (3,6);
2224: p_child_plan_id NUMBER) return BOOLEAN AS
2225: CURSOR p_cur IS
2226: SELECT 1
2227: FROM qa_chars qc,
2228: qa_plan_chars qpc
2229: WHERE qc.char_id = qpc.char_id
2230: AND qpc.plan_id = p_child_plan_id
2231: AND qpc.result_column_name = p_child_result_column
2232: AND qc.hardcoded_column IS NOT NULL -- HC element
2262: -- of a Hardcoded element and also to fetch its
2263: -- dereferenced column.
2264: Cursor cur (p_plan_id in NUMBER, p_res_col in VARCHAR2) is
2265: Select UPPER(TRANSLATE(qc.name, ' ''*{}', '_____')) name, qc.hardcoded_column
2266: from qa_plan_chars qpc, qa_chars qc
2267: where qpc.plan_id = p_plan_id
2268: and qpc.char_id = qc.char_id
2269: and qpc.result_column_name = p_res_col;
2270:
2686: CURSOR seq_cursor is
2687: SELECT qpc.char_id,
2688: qpc.result_column_name
2689: FROM qa_chars qc,
2690: qa_plan_chars qpc
2691: WHERE qpc.plan_id = p_child_plan_id
2692: AND qpc.char_id NOT IN
2693: (SELECT child_char_id
2694: FROM qa_pc_element_relationship qper,
4654:
4655: cntr NUMBER;
4656: BEGIN
4657: -- Getting the list of the result_column_names from the
4658: -- qa_plan_chars table
4659: SELECT char_id, result_column_name
4660: BULK COLLECT INTO res_col_tab
4661: FROM qa_plan_chars
4662: WHERE plan_id = p_plan_id;
4657: -- Getting the list of the result_column_names from the
4658: -- qa_plan_chars table
4659: SELECT char_id, result_column_name
4660: BULK COLLECT INTO res_col_tab
4661: FROM qa_plan_chars
4662: WHERE plan_id = p_plan_id;
4663:
4664: -- building the select query
4665: FOR cntr in 1..res_col_tab.count
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
4901: AND qapc.char_id = qpc.char_id
4902: AND qapc.char_id = qc.char_id