APPS.QA_PARENT_CHILD_COPY_PKG dependencies on QA_CHAR_INDEXES_PKG

Line 833: -- AND qa_char_indexes_pkg.index_exists_and_enabled(qc.char_id) = 1;

829: WHERE qpc.plan_id = p_plan_id
830: AND qpc.char_id = qc.char_id
831: AND qpc.char_id = qci.char_id
832: AND qci.enabled_flag = 1;
833: -- AND qa_char_indexes_pkg.index_exists_and_enabled(qc.char_id) = 1;
834: --local variables to facilitate certain function calls
835: l_return_status VARCHAR2(2);
836: l_msg_count NUMBER;
837: l_msg_data VARCHAR2(2000);

Line 967: qa_char_indexes_pkg.get_default_result_column(qa_pc_rec.char_id) then

963: WHILE (src_id IS NOT NULL) LOOP
964: FOR qa_pc_rec in qa_pc(phtable(src_id).dest_id) LOOP -- fetch all indexed softcoded chars
965:
966: if qa_pc_rec.result_column_name =
967: qa_char_indexes_pkg.get_default_result_column(qa_pc_rec.char_id) then
968: null; -- no need to drop because it is already the best fit.
969: else
970: l_temp := qa_char_indexes_pkg.disable_index(qa_pc_rec.char_id); -- disable the index
971:

Line 970: l_temp := qa_char_indexes_pkg.disable_index(qa_pc_rec.char_id); -- disable the index

966: if qa_pc_rec.result_column_name =
967: qa_char_indexes_pkg.get_default_result_column(qa_pc_rec.char_id) then
968: null; -- no need to drop because it is already the best fit.
969: else
970: l_temp := qa_char_indexes_pkg.disable_index(qa_pc_rec.char_id); -- disable the index
971:
972: -- To restrict message length to 1260. (60 is an offset for message content)
973: if((nvl(length(char_id_list),0) + nvl(length(qa_pc_rec.name),0)) < 1200) then
974: char_id_list := char_id_list || ', ' || qa_pc_rec.name;