APPS.QA_VALIDATION_API dependencies on QA_PLAN_CHARS

Line 305: from qa_plan_chars

301: ordered_array ElementInfoArray;
302:
303: CURSOR c IS
304: select char_id
305: from qa_plan_chars
306: where plan_id = p_plan_id
307: and enabled_flag = 1
308: order by prompt_sequence;
309:

Line 2540: FROM qa_plan_char_action_outputs qpcao, qa_plan_chars_v qpcv

2536:
2537: --move the lookup of the datatype into this cursor
2538: /* CURSOR c1 (token VARCHAR2, pca_id NUMBER) IS
2539: SELECT qpcao.char_id, qpcv.datatype
2540: FROM qa_plan_char_action_outputs qpcao, qa_plan_chars_v qpcv
2541: WHERE plan_char_action_id = pca_id AND
2542: token_name = token AND
2543: qpcao.char_id = qpcv.char_id; */
2544:

Line 2629: FROM qa_plan_char_actions qpca, qa_plan_chars_v qpcv

2625:
2626: --besides fetching the assign type, get the datatype of the assign target
2627: /* CURSOR c2 (pca_id NUMBER) IS
2628: SELECT qpca.assign_type, qpcv.datatype, qpcv.decimal_precision
2629: FROM qa_plan_char_actions qpca, qa_plan_chars_v qpcv
2630: WHERE qpca.plan_char_action_id = pca_id AND
2631: qpca.assigned_char_id = qpcv.char_id; */
2632:
2633: -- Bug 4958778. SQL Repository Fix SQL ID: 15008799

Line 2644: qa_plan_chars qpc,

2640: qpca.assign_type,
2641: qc.datatype,
2642: nvl(qpc.decimal_precision, qc.decimal_precision) decimal_precision
2643: FROM qa_chars qc,
2644: qa_plan_chars qpc,
2645: qa_plan_char_actions qpca,
2646: qa_plan_char_action_triggers qpcat
2647: WHERE
2648: qpca.plan_char_action_trigger_id = qpcat.plan_char_action_trigger_id

Line 2879: from qa_plan_chars

2875: -- srhariha.Wed Jun 16 06:54:06 PDT 2004
2876:
2877: cursor validate_target(p_plan_id number,p_char_id number) is
2878: select 1
2879: from qa_plan_chars
2880: where plan_id = p_plan_id
2881: and char_id = p_char_id
2882: and enabled_flag = 1;
2883:

Line 4072: FROM qa_plan_chars qpc,

4068: --Get the list of HardCoded elements in the
4069: --Collection plan
4070: SELECT qpc.char_id bulk collect
4071: INTO hardcoded_char_tab
4072: FROM qa_plan_chars qpc,
4073: qa_chars qc
4074: WHERE qpc.plan_id = p_plan_id
4075: AND qpc.char_id = qc.char_id
4076: AND qc.hardcoded_column IS NOT NULL

Line 4404: qa_plan_chars qpc

4400: select upper(translate(qc.name,' ''*{}','_____')) name,
4401: qpc.char_id char_id,
4402: qc.datatype
4403: from qa_chars qc,
4404: qa_plan_chars qpc
4405: WHERE qc.char_id = qpc.char_id
4406: AND qpc.plan_id = p_plan_id
4407: ORDER BY qpc.prompt_sequence;
4408: