[Home] [Help]
274:
275: fk fk_cursor%ROWTYPE;
276:
277: --
278: -- This cursor loops through qa_plan_chars to find all
279: -- plan_id and result_column_name for each collection element.
280: --
281: -- The decode() function and distinct are there to cleverly
282: -- eliminate all but one row of hardcoded elements. We only
293: decode(qc.hardcoded_column, null, qpc.plan_id, 0) plan_id,
294: upper(qpc.result_column_name) result_column_name,
295: qc.name,
296: qc.hardcoded_column
297: FROM qa_plan_chars qpc, qa_chars qc
298: WHERE qc.char_id = qpc.char_id AND
299: qpc.enabled_flag = 1 AND
300: qc.enabled_flag = 1
301: ORDER BY qc.hardcoded_column, qc.name;
376: --
377:
378: --
379: -- One option is to go through each element, but it is slightly
380: -- more efficient to go through qa_plan_chars to avoid performing
381: -- too many database parses.
382: --
383: -- FOR element IN elements_cursor LOOP
384: --
709: qc.FK_DESCRIPTION,
710: qc.FK_ADD_WHERE,
711: qc.DATATYPE
712: FROM qa_chars qc,
713: qa_plan_chars qpc
714: WHERE qc.char_id = qpc.char_id
715: AND qpc.plan_id = x_plan_id
716: ORDER BY qpc.prompt_sequence;
717:
939: qc.FK_DESCRIPTION,
940: qc.FK_ADD_WHERE,
941: qc.DATATYPE
942: FROM qa_chars qc,
943: qa_plan_chars qpc
944: WHERE qc.char_id = qpc.char_id
945: AND qpc.plan_id = x_plan_id
946: ORDER BY qpc.prompt_sequence;
947:
1287: SELECT qpc.result_column_name,
1288: upper(translate(qc.name,' ''*{}','_____')) name,
1289: qc.hardcoded_column,
1290: qc.developer_name
1291: FROM qa_plan_chars qpc, qa_chars qc
1292: WHERE qpc.char_id = qc.char_id AND qpc.plan_id = x_plan_id
1293: ORDER BY prompt_sequence;
1294:
1295: --