APPS.QLTDACTB dependencies on QA_CHARS

Line 215: FROM qa_chars qc,

211: qpcat.plan_char_action_trigger_id PCAT_ID,
212: nvl(qscqs.uom_code, qc.uom_code) SPEC_CHAR_UOM,
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,

Line 308: from qa_chars

304: /*
305: select RESULT_COLUMN_NAME from qa_plan_chars
306: where PLAN_ID = X_PLAN_ID
307: and CHAR_ID in (select char_id
308: from qa_chars
309: where developer_name =
310: 'TO_INTRAOPERATION_STEP');
311: */
312:

Line 330: qa_chars qc

326: SELECT
327: NVL(qc.hardcoded_column,qpc.result_column_name) Q_COLUMN,
328: qc.developer_name DEV_NAME
329: FROM qa_plan_chars qpc,
330: qa_chars qc
331: WHERE qpc.plan_id = X_PLAN_ID
332: AND qc.char_id = qpc.char_id
333: AND qc.char_context_flag <> 3
334: ORDER BY qc.char_id;

Line 2098: from qa_chars qc,

2094: qpcao.token_name TOKEN_NAME,
2095: qc.fk_lookup_type LOOKUP_TYPE,
2096: qc.char_id CHAR_ID,
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

Line 2115: from qa_chars qc,

2111: qpcao.token_name TOKEN_NAME,
2112: qc.fk_lookup_type LOOKUP_TYPE,
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

Line 2135: qa_chars qc

2131: CURSOR token_column_datatype (t_char_id number) IS
2132: SELECT
2133: qc.datatype
2134: FROM qa_plan_chars qpc,
2135: qa_chars qc
2136: WHERE qc.char_id = t_char_id
2137: AND qpc.char_id = qc.char_id
2138: AND qpc.plan_id = X_PLAN_ID;
2139: /*

Line 2328: from qa_chars qc,

2324: SELECT NVL(qc.hardcoded_column,qpc.result_column_name) Q_COLUMN,
2325: qpcao.token_name TOKEN_NAME,
2326: qc.fk_lookup_type LOOKUP_TYPE,
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

Line 2344: from qa_chars qc,

2340: UNION SELECT qc.hardcoded_column Q_COLUMN,
2341: qpcao.token_name TOKEN_NAME,
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

Line 2419: IF(qa_chars_api.datatype(prec.char_id) = 3) THEN

2415: -- any conversion.
2416: -- hmakam
2417:
2418: IF NOT(prec.char_id = 51) THEN
2419: IF(qa_chars_api.datatype(prec.char_id) = 3) THEN
2420: ACTUAL_OUTPUT := QLTDATE.any_to_user(ACTUAL_OUTPUT);
2421: ELSIF(qa_chars_api.datatype(prec.char_id) = 6) THEN
2422: ACTUAL_OUTPUT := QLTDATE.any_to_user_dt(ACTUAL_OUTPUT);
2423: END IF;

Line 2421: ELSIF(qa_chars_api.datatype(prec.char_id) = 6) THEN

2417:
2418: IF NOT(prec.char_id = 51) THEN
2419: IF(qa_chars_api.datatype(prec.char_id) = 3) THEN
2420: ACTUAL_OUTPUT := QLTDATE.any_to_user(ACTUAL_OUTPUT);
2421: ELSIF(qa_chars_api.datatype(prec.char_id) = 6) THEN
2422: ACTUAL_OUTPUT := QLTDATE.any_to_user_dt(ACTUAL_OUTPUT);
2423: END IF;
2424: END IF;
2425:

Line 2428: IF (qa_chars_api.datatype(prec.char_id) = 4) THEN

2424: END IF;
2425:
2426:
2427: /*kashyap, rkaza 06/14/2002. as part of fix for Bug 2408728 */
2428: IF (qa_chars_api.datatype(prec.char_id) = 4) THEN
2429:
2430: -- Bug 2640953. If the ACTUAL_OUTPUT is NULL, set the l_count to 0.
2431: -- Added the NVL() below. kabalakr.
2432:

Line 2626: from qa_chars qc,

2622: SELECT NVL(qc.hardcoded_column,qpc.result_column_name) Q_COLUMN,
2623: qpcao.token_name TOKEN_NAME,
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

Line 2642: from qa_chars qc,

2638: UNION SELECT qc.hardcoded_column Q_COLUMN,
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

Line 2659: qa_chars qc

2655: NVL(qc.hardcoded_column,qpc.result_column_name) Q_COLUMN,
2656: qc.datatype,
2657: DECODE(qpc.decimal_precision, NULL, qc.decimal_precision, qpc.decimal_precision)
2658: FROM qa_plan_chars qpc,
2659: qa_chars qc
2660: WHERE qc.char_id = qpc.char_id
2661: AND qc.char_id = t_char_id
2662: AND qpc.plan_id = X_PLAN_ID;
2663: /*