[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;
2098: from qa_chars qc,
2099: qa_plan_chars qpc,
2100: qa_plan_char_action_outputs qpcao,
2101: qa_plan_char_actions qpca,
2102: qa_plan_char_action_triggers qpcat
2103: where qc.char_id = qpcao.char_id
2104: and qpc.char_id = qpcao.char_id
2105: and qpcao.PLAN_CHAR_ACTION_ID = qpca.PLAN_CHAR_ACTION_ID
2106: and qpcat.PLAN_CHAR_ACTION_TRIGGER_ID = qpca.PLAN_CHAR_ACTION_TRIGGER_ID
2114: qc.datatype DATATYPE
2115: from qa_chars qc,
2116: qa_plan_char_action_outputs qpcao,
2117: qa_plan_char_actions qpca,
2118: qa_plan_char_action_triggers qpcat
2119: where qc.char_id = qpcao.char_id
2120: and qpcao.PLAN_CHAR_ACTION_ID = qpca.PLAN_CHAR_ACTION_ID
2121: and qpcat.PLAN_CHAR_ACTION_TRIGGER_ID = qpca.PLAN_CHAR_ACTION_TRIGGER_ID
2122: and qpcao.PLAN_CHAR_ACTION_ID = X_PCA_ID
2328: from qa_chars qc,
2329: qa_plan_chars qpc,
2330: qa_plan_char_action_outputs qpcao,
2331: qa_plan_char_actions qpca,
2332: qa_plan_char_action_triggers qpcat
2333: where qc.char_id = qpcao.char_id
2334: and qpc.char_id = qpcao.char_id
2335: and qpcao.PLAN_CHAR_ACTION_ID = qpca.PLAN_CHAR_ACTION_ID
2336: and qpcat.PLAN_CHAR_ACTION_TRIGGER_ID = qpca.PLAN_CHAR_ACTION_TRIGGER_ID
2343: qc.char_id CHAR_ID
2344: from qa_chars qc,
2345: qa_plan_char_action_outputs qpcao,
2346: qa_plan_char_actions qpca,
2347: qa_plan_char_action_triggers qpcat
2348: where qc.char_id = qpcao.char_id
2349: and qpcao.PLAN_CHAR_ACTION_ID = qpca.PLAN_CHAR_ACTION_ID
2350: and qpcat.PLAN_CHAR_ACTION_TRIGGER_ID = qpca.PLAN_CHAR_ACTION_TRIGGER_ID
2351: and qpcao.PLAN_CHAR_ACTION_ID = X_PCA_ID
2369:
2370: -- suramasw.Bug 3162828.
2371:
2372: CURSOR CPLAN(l_pca_id number) IS
2373: SELECT plan_id FROM qa_plan_char_action_triggers
2374: WHERE plan_char_action_trigger_id = (select PLAN_CHAR_ACTION_TRIGGER_ID
2375: FROM QA_PLAN_CHAR_ACTIONS WHERE PLAN_CHAR_ACTION_ID = l_pca_id);
2376:
2377: CURSOR RESULT_COLUMN(l_plan_id number, l_pca_id number) IS
2376:
2377: CURSOR RESULT_COLUMN(l_plan_id number, l_pca_id number) IS
2378: SELECT result_column_name FROM qa_plan_chars
2379: WHERE plan_id = l_plan_id AND char_id = ( SELECT char_id
2380: FROM qa_plan_char_action_triggers WHERE
2381: plan_char_action_trigger_id = (SELECT plan_char_action_trigger_id
2382: FROM qa_plan_char_actions WHERE plan_char_action_id = l_pca_id));
2383:
2384: l_result_column_name VARCHAR2(100);
2625: qc.char_id CHAR_ID
2626: from qa_chars qc,
2627: qa_plan_chars qpc,
2628: qa_plan_char_actions qpca,
2629: qa_plan_char_action_triggers qpcat,
2630: qa_plan_char_action_outputs qpcao
2631: where qc.char_id = qpcao.char_id
2632: and qpc.char_id = qpcao.char_id
2633: and qpcao.PLAN_CHAR_ACTION_ID = qpca.PLAN_CHAR_ACTION_ID
2640: qc.fk_lookup_type LOOKUP_TYPE,
2641: qc.char_id CHAR_ID
2642: from qa_chars qc,
2643: qa_plan_char_actions qpca,
2644: qa_plan_char_action_triggers qpcat,
2645: qa_plan_char_action_outputs qpcao
2646: where qc.char_id = qpcao.char_id
2647: and qpcao.PLAN_CHAR_ACTION_ID = qpca.PLAN_CHAR_ACTION_ID
2648: and qpcat.PLAN_CHAR_ACTION_TRIGGER_ID = qpca.PLAN_CHAR_ACTION_TRIGGER_ID
3156: -- skolluku
3157: --
3158: Select qp.organization_id
3159: INTO l_org_id
3160: From Qa_Plan_Char_Action_Triggers Pcat,
3161: Qa_Plan_Char_Actions Pca,
3162: qa_plans qp
3163: Where Pcat.Plan_Char_Action_Trigger_Id = Pca.Plan_Char_Action_Trigger_Id
3164: And Pca.Plan_Char_Action_Id = p_plan_char_action_id