[Home] [Help]
213: nvl(qpc.uom_code, qc.uom_code) PLAN_CHAR_UOM,
214: qpc.decimal_precision DECIMAL_PRECISION
215: FROM qa_chars qc,
216: qa_plan_chars qpc,
217: qa_plan_char_action_triggers qpcat,
218: qa_plan_char_actions qpca,
219: qa_actions qa,
220: (select
221: qsc.CHAR_ID,
362:
363:
364: CURSOR Get_user_message(elem_id NUMBER,col_plan_id NUMBER, act_id NUMBER) IS
365: select qpca.message
366: from qa_plan_char_actions qpca, qa_plan_char_action_triggers qpcat
367: where qpcat.char_id = elem_id and
368: qpcat.plan_id = col_plan_id and
369: qpcat.plan_char_action_trigger_id = qpca.plan_char_action_trigger_id and
370: qpca.action_id = act_id;
2018: from qa_chars qc,
2019: qa_plan_chars qpc,
2020: qa_plan_char_action_outputs qpcao,
2021: qa_plan_char_actions qpca,
2022: qa_plan_char_action_triggers qpcat
2023: where qc.char_id = qpcao.char_id
2024: and qpc.char_id = qpcao.char_id
2025: and qpcao.PLAN_CHAR_ACTION_ID = qpca.PLAN_CHAR_ACTION_ID
2026: and qpcat.PLAN_CHAR_ACTION_TRIGGER_ID = qpca.PLAN_CHAR_ACTION_TRIGGER_ID
2034: qc.datatype DATATYPE
2035: from qa_chars qc,
2036: qa_plan_char_action_outputs qpcao,
2037: qa_plan_char_actions qpca,
2038: qa_plan_char_action_triggers qpcat
2039: where qc.char_id = qpcao.char_id
2040: and qpcao.PLAN_CHAR_ACTION_ID = qpca.PLAN_CHAR_ACTION_ID
2041: and qpcat.PLAN_CHAR_ACTION_TRIGGER_ID = qpca.PLAN_CHAR_ACTION_TRIGGER_ID
2042: and qpcao.PLAN_CHAR_ACTION_ID = X_PCA_ID
2228: from qa_chars qc,
2229: qa_plan_chars qpc,
2230: qa_plan_char_action_outputs qpcao,
2231: qa_plan_char_actions qpca,
2232: qa_plan_char_action_triggers qpcat
2233: where qc.char_id = qpcao.char_id
2234: and qpc.char_id = qpcao.char_id
2235: and qpcao.PLAN_CHAR_ACTION_ID = qpca.PLAN_CHAR_ACTION_ID
2236: and qpcat.PLAN_CHAR_ACTION_TRIGGER_ID = qpca.PLAN_CHAR_ACTION_TRIGGER_ID
2243: qc.char_id CHAR_ID
2244: from qa_chars qc,
2245: qa_plan_char_action_outputs qpcao,
2246: qa_plan_char_actions qpca,
2247: qa_plan_char_action_triggers qpcat
2248: where qc.char_id = qpcao.char_id
2249: and qpcao.PLAN_CHAR_ACTION_ID = qpca.PLAN_CHAR_ACTION_ID
2250: and qpcat.PLAN_CHAR_ACTION_TRIGGER_ID = qpca.PLAN_CHAR_ACTION_TRIGGER_ID
2251: and qpcao.PLAN_CHAR_ACTION_ID = X_PCA_ID
2269:
2270: -- suramasw.Bug 3162828.
2271:
2272: CURSOR CPLAN(l_pca_id number) IS
2273: SELECT plan_id FROM qa_plan_char_action_triggers
2274: WHERE plan_char_action_trigger_id = (select PLAN_CHAR_ACTION_TRIGGER_ID
2275: FROM QA_PLAN_CHAR_ACTIONS WHERE PLAN_CHAR_ACTION_ID = l_pca_id);
2276:
2277: CURSOR RESULT_COLUMN(l_plan_id number, l_pca_id number) IS
2276:
2277: CURSOR RESULT_COLUMN(l_plan_id number, l_pca_id number) IS
2278: SELECT result_column_name FROM qa_plan_chars
2279: WHERE plan_id = l_plan_id AND char_id = ( SELECT char_id
2280: FROM qa_plan_char_action_triggers WHERE
2281: plan_char_action_trigger_id = (SELECT plan_char_action_trigger_id
2282: FROM qa_plan_char_actions WHERE plan_char_action_id = l_pca_id));
2283:
2284: l_result_column_name VARCHAR2(100);
2496: qc.char_id CHAR_ID
2497: from qa_chars qc,
2498: qa_plan_chars qpc,
2499: qa_plan_char_actions qpca,
2500: qa_plan_char_action_triggers qpcat,
2501: qa_plan_char_action_outputs qpcao
2502: where qc.char_id = qpcao.char_id
2503: and qpc.char_id = qpcao.char_id
2504: and qpcao.PLAN_CHAR_ACTION_ID = qpca.PLAN_CHAR_ACTION_ID
2511: qc.fk_lookup_type LOOKUP_TYPE,
2512: qc.char_id CHAR_ID
2513: from qa_chars qc,
2514: qa_plan_char_actions qpca,
2515: qa_plan_char_action_triggers qpcat,
2516: qa_plan_char_action_outputs qpcao
2517: where qc.char_id = qpcao.char_id
2518: and qpcao.PLAN_CHAR_ACTION_ID = qpca.PLAN_CHAR_ACTION_ID
2519: and qpcat.PLAN_CHAR_ACTION_TRIGGER_ID = qpca.PLAN_CHAR_ACTION_TRIGGER_ID