[Home] [Help]
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,
222: qsc.ENABLED_FLAG,
248: ORDER BY qpc.prompt_sequence, qpcat.trigger_sequence,
249: qpcat.plan_char_action_trigger_id;
250:
251: Cursor MY_MESSAGE(X_PCA_ID NUMBER) is
252: select MESSAGE, ASSIGN_TYPE from qa_plan_char_actions
253: where PLAN_CHAR_ACTION_ID = X_PCA_ID;
254:
255: Cursor WORKFLOW_itemtype(X_PCA_ID VARCHAR2) is
256: select MESSAGE from qa_plan_char_actions
252: select MESSAGE, ASSIGN_TYPE from qa_plan_char_actions
253: where PLAN_CHAR_ACTION_ID = X_PCA_ID;
254:
255: Cursor WORKFLOW_itemtype(X_PCA_ID VARCHAR2) is
256: select MESSAGE from qa_plan_char_actions
257: where PLAN_CHAR_ACTION_ID = X_PCA_ID;
258:
259: Cursor WF_ITEMTYPE_SELECTOR(WORKFLOW_ITEMTYPE VARCHAR2) IS
260: select wf_selector
266: from wf_runnable_processes_v
267: where item_type = WORKFLOW_ITEMTYPE;
268:
269: Cursor MY_STATUS(X_PCA_ID NUMBER) is
270: select STATUS_CODE from qa_plan_char_actions
271: where PLAN_CHAR_ACTION_ID = X_PCA_ID;
272:
273:
274: -- Bug 5196076. SQL Repository Fix SQL ID 17898864.
316: and lookup_type = 'WIP_INTRAOPERATION_STEP';
317:
318: Cursor MY_ASSIGNED_CHAR_ID(X_PCA_ID NUMBER, X_ACTION_ID NUMBER) is
319: select ASSIGNED_CHAR_ID
320: from QA_PLAN_CHAR_ACTIONS
321: where PLAN_CHAR_ACTION_ID = X_PCA_ID
322: and ACTION_ID = X_ACTION_ID;
323:
324: -- Bug 4958762: SQL Repository Fix SQL ID: 15008263
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;
399:
400: -- used for action 18, 19 to
401: -- get status id for lot/serial statuses
402: CURSOR MY_STATUS_ID (X_PCA_ID NUMBER) IS
403: SELECT STATUS_ID FROM QA_PLAN_CHAR_ACTIONS
404: WHERE PLAN_CHAR_ACTION_ID = X_PCA_ID;
405:
406: -- Bug 8849343.Added this cursor and a variable to check
407: -- if the eam_item_type has value 1(asset group) or 3(rebuildable)
2097: qc.datatype DATATYPE
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
2113: qc.char_id CHAR_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
2327: qc.char_id CHAR_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
2342: qc.fk_lookup_type LOOKUP_TYPE,
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
2352: and qc.char_context_flag = 3;
2353:
2354: CURSOR ACTION_SET_NAME IS
2355: SELECT aas.NAME
2356: FROM QA_PLAN_CHAR_ACTIONS qpca,
2357: ALR_ACTION_SETS aas
2358: WHERE qpca.PLAN_CHAR_ACTION_ID = X_PCA_ID
2359: AND qpca.ALR_ACTION_SET_ID = aas.ACTION_SET_ID
2360: AND aas.APPLICATION_ID = 250;
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
2378: SELECT result_column_name FROM qa_plan_chars
2379: WHERE plan_id = l_plan_id AND char_id = ( SELECT char_id
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);
2385: l_result_column_value VARCHAR2(2000);
2386: l_plan_id NUMBER;
2624: qc.fk_lookup_type LOOKUP_TYPE,
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
2639: qpcao.token_name TOKEN_NAME,
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
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
3165: and qp.plan_id = pcat.plan_id;