DBA Data[Home] [Help]

APPS.QA_PLANS_PUB dependencies on QA_CHAR_INDEXES

Line 446: dummy := qa_char_indexes_pkg.disable_index(p_char_id);

442: -- bso Sat Dec 4 16:12:44 PST 2004
443: --
444: dummy NUMBER;
445: BEGIN
446: dummy := qa_char_indexes_pkg.disable_index(p_char_id);
447: fnd_message.set_name('QA', 'QA_CHAR_REGENERATE_INDEX');
448: fnd_message.set_token('ELEMENT_NAME',
449: qa_chars_api.get_element_name(p_char_id));
450: fnd_msg_pub.add;

Line 478: l_default_column := qa_char_indexes_pkg.get_default_result_column(p_char_id);

474: init_result_column_array(-1);
475: init_result_column_array(p_plan_id);
476: END IF;
477:
478: l_default_column := qa_char_indexes_pkg.get_default_result_column(p_char_id);
479: IF l_default_column IS NOT NULL THEN
480: --
481: -- We will be in here if there is a function-based index on this element.
482: --

Line 2294: qa_char_indexes_pkg.get_default_result_column(p_element_id) THEN

2290: -- function-based index. If so, add info message to the msg stack.
2291: -- bso Sat Dec 4 16:08:07 PST 2004
2292: --
2293: IF l_result_column LIKE 'CHARACTER%' AND l_result_column <>
2294: qa_char_indexes_pkg.get_default_result_column(p_element_id) THEN
2295: disable_index_private(p_element_id);
2296: END IF;
2297:
2298: END delete_plan_element;

Line 2308: FROM qa_plan_chars qpc, qa_char_indexes qci

2304: -- is disrupted due to this action.
2305: --
2306: CURSOR c IS
2307: SELECT qpc.char_id
2308: FROM qa_plan_chars qpc, qa_char_indexes qci
2309: WHERE qpc.plan_id = p_plan_id AND
2310: qpc.char_id = qci.char_id AND
2311: qpc.result_column_name <> qci.default_result_column;
2312: BEGIN