APPS.QLTVCREB dependencies on QA_CHAR_INDEXES_PKG

Line 855: l_index_exists := qa_char_indexes_pkg.index_exists_and_enabled(fk.char_id);

851: -- temp := 'qr.' || fk.result_column_name ;
852:
853: -- temp := 'qltdate.any_to_number(qr.' || fk.result_column_name || ')';
854:
855: l_index_exists := qa_char_indexes_pkg.index_exists_and_enabled(fk.char_id);
856:
857: if l_index_exists = 1 then
858: l_ret_status := qa_char_indexes_pkg.get_case_function(fk.char_id, 'QR', l_num_column);
859:

Line 858: l_ret_status := qa_char_indexes_pkg.get_case_function(fk.char_id, 'QR', l_num_column);

854:
855: l_index_exists := qa_char_indexes_pkg.index_exists_and_enabled(fk.char_id);
856:
857: if l_index_exists = 1 then
858: l_ret_status := qa_char_indexes_pkg.get_case_function(fk.char_id, 'QR', l_num_column);
859:
860: If l_ret_status = 0 then
861: temp := l_num_column ;
862: Else

Line 885: l_index_exists := qa_char_indexes_pkg.index_exists_and_enabled(fk.char_id);

881: --
882: -- For Softcoded character elements, we should add the index predicate
883: -- So the drive goes through the Function based index, if its created
884: --
885: l_index_exists := qa_char_indexes_pkg.index_exists_and_enabled(fk.char_id);
886:
887: if l_index_exists = 1 then
888: l_index_predicate := qa_char_indexes_pkg.get_decode_function(fk.char_id, 'QR.');
889:

Line 888: l_index_predicate := qa_char_indexes_pkg.get_decode_function(fk.char_id, 'QR.');

884: --
885: l_index_exists := qa_char_indexes_pkg.index_exists_and_enabled(fk.char_id);
886:
887: if l_index_exists = 1 then
888: l_index_predicate := qa_char_indexes_pkg.get_decode_function(fk.char_id, 'QR.');
889:
890: temp := l_index_predicate;
891: l_index_predicate := null;
892: l_index_exists := 0;