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 2424: qa_char_indexes_pkg.get_default_result_column(p_element_id) THEN

2420: -- function-based index. If so, add info message to the msg stack.
2421: -- bso Sat Dec 4 16:08:07 PST 2004
2422: --
2423: IF l_result_column LIKE 'CHARACTER%' AND l_result_column <>
2424: qa_char_indexes_pkg.get_default_result_column(p_element_id) THEN
2425: disable_index_private(p_element_id);
2426: END IF;
2427:
2428: END delete_plan_element;

Line 2438: FROM qa_plan_chars qpc, qa_char_indexes qci

2434: -- is disrupted due to this action.
2435: --
2436: CURSOR c IS
2437: SELECT qpc.char_id
2438: FROM qa_plan_chars qpc, qa_char_indexes qci
2439: WHERE qpc.plan_id = p_plan_id AND
2440: qpc.char_id = qci.char_id AND
2441: qpc.result_column_name <> qci.default_result_column;
2442: BEGIN