APPS.QA_CHAR_INDEXES_PKG dependencies on QA_PLAN_ELEMENT_API

Line 481: IF qa_plan_element_api.get_element_datatype(p_char_id) = 1 THEN

477: -- thats constructed in QWB would contain an UPPER(). Hence
478: -- we have to add the upper function around the DECODE to ensure
479: -- that the search on the element is driven through the index.
480: --
481: IF qa_plan_element_api.get_element_datatype(p_char_id) = 1 THEN
482: l_ddl := 'UPPER('||l_ddl||')';
483:
484: --
485: -- bug 12596623

Line 489: ELSIF (qa_plan_element_api.get_element_datatype(p_char_id) = 2) THEN

485: -- bug 12596623
486: -- If the element is of the type number, then the where clause
487: -- thats constructed in QWB would contain the case function
488: --
489: ELSIF (qa_plan_element_api.get_element_datatype(p_char_id) = 2) THEN
490: l_status := get_case_function(p_char_id, p_alias, l_num_index_ddl);
491: IF l_status <> 0 THEN
492: RETURN l_status;
493: END IF;

Line 542: IF ((qa_plan_element_api.get_element_datatype(p_char_id) = 2) AND

538: --
539: -- bug 12596623
540: -- Create the Internal index for numbers
541: --
542: IF ((qa_plan_element_api.get_element_datatype(p_char_id) = 2) AND
543: l_num_index_ddl IS NOT NULL) THEN
544: l_num_index_ddl := 'CREATE INDEX ' || g_qa_schema || '.' ||
545: '"' || 'QA_'||p_char_id||'_INT' || '" ON ' ||
546: g_qa_schema || '.QA_RESULTS ' || p_alias ||

Line 723: IF qa_plan_element_api.get_element_datatype(p_char_id) = 2 THEN

719: --
720: -- bug 12596623
721: -- Drop the internal index if it exists for Numeric elements
722: --
723: IF qa_plan_element_api.get_element_datatype(p_char_id) = 2 THEN
724: OPEN c_num_idx;
725: FETCH c_num_idx INTO l_num_int_index;
726: IF c_num_idx%notfound THEN
727: CLOSE c_num_idx;