APPS.QA_VALIDATION_API dependencies on QA_PLAN_CHARS

Line 294: from qa_plan_chars

290: ordered_array ElementInfoArray;
291:
292: CURSOR c IS
293: select char_id
294: from qa_plan_chars
295: where plan_id = p_plan_id
296: and enabled_flag = 1
297: order by prompt_sequence;
298:

Line 2473: FROM qa_plan_char_action_outputs qpcao, qa_plan_chars_v qpcv

2469:
2470: --move the lookup of the datatype into this cursor
2471: /* CURSOR c1 (token VARCHAR2, pca_id NUMBER) IS
2472: SELECT qpcao.char_id, qpcv.datatype
2473: FROM qa_plan_char_action_outputs qpcao, qa_plan_chars_v qpcv
2474: WHERE plan_char_action_id = pca_id AND
2475: token_name = token AND
2476: qpcao.char_id = qpcv.char_id; */
2477:

Line 2562: FROM qa_plan_char_actions qpca, qa_plan_chars_v qpcv

2558:
2559: --besides fetching the assign type, get the datatype of the assign target
2560: /* CURSOR c2 (pca_id NUMBER) IS
2561: SELECT qpca.assign_type, qpcv.datatype, qpcv.decimal_precision
2562: FROM qa_plan_char_actions qpca, qa_plan_chars_v qpcv
2563: WHERE qpca.plan_char_action_id = pca_id AND
2564: qpca.assigned_char_id = qpcv.char_id; */
2565:
2566: -- Bug 4958778. SQL Repository Fix SQL ID: 15008799

Line 2577: qa_plan_chars qpc,

2573: qpca.assign_type,
2574: qc.datatype,
2575: nvl(qpc.decimal_precision, qc.decimal_precision) decimal_precision
2576: FROM qa_chars qc,
2577: qa_plan_chars qpc,
2578: qa_plan_char_actions qpca,
2579: qa_plan_char_action_triggers qpcat
2580: WHERE
2581: qpca.plan_char_action_trigger_id = qpcat.plan_char_action_trigger_id

Line 2812: from qa_plan_chars

2808: -- srhariha.Wed Jun 16 06:54:06 PDT 2004
2809:
2810: cursor validate_target(p_plan_id number,p_char_id number) is
2811: select 1
2812: from qa_plan_chars
2813: where plan_id = p_plan_id
2814: and char_id = p_char_id
2815: and enabled_flag = 1;
2816:

Line 3944: FROM qa_plan_chars qpc,

3940: --Get the list of HardCoded elements in the
3941: --Collection plan
3942: SELECT qpc.char_id bulk collect
3943: INTO hardcoded_char_tab
3944: FROM qa_plan_chars qpc,
3945: qa_chars qc
3946: WHERE qpc.plan_id = p_plan_id
3947: AND qpc.char_id = qc.char_id
3948: AND qc.hardcoded_column IS NOT NULL

Line 4255: qa_plan_chars qpc

4251:
4252: CURSOR plan_chars IS
4253: select upper(translate(qc.name,' ''*{}','_____')) name
4254: from qa_chars qc,
4255: qa_plan_chars qpc
4256: WHERE qc.char_id = qpc.char_id
4257: AND qpc.plan_id = p_plan_id
4258: ORDER BY qpc.prompt_sequence;
4259: