[Home] [Help]
564: where category_id = p_cat_id );
565:
566: -- IMMEDIATELY Mark all statements linked to the solutions within the
567: -- changed category
568: update cs_kb_elements_tl
569: set composite_text_index = 'U'
570: where element_id in
571: ( select b.element_id
572: from cs_kb_set_categories a, cs_kb_set_eles b
612: -- Update the content cache, cause the full path is now changed.
613: Populate_Soln_Content_Cache( l_set_id );
614: Pop_Soln_Attach_Content_Cache (l_set_id);
615: -- IMMEDIATELY Mark all statements linked to this solution.
616: update cs_kb_elements_tl
617: set composite_text_index = 'U'
618: where element_id in
619: ( select element_id
620: from cs_kb_set_eles
655: Populate_Soln_Content_Cache( l_set_id );
656: Pop_Soln_Attach_Content_Cache (l_set_id);
657:
658: -- IMMEDIATELY Mark all statements linked to this solution.
659: update cs_kb_elements_tl
660: set composite_text_index = 'U'
661: where element_id in
662: ( select element_id
663: from cs_kb_set_eles
723: connect by prior category_id = parent_category_id ));
724:
725: -- IMMEDIATELY Mark all statements linked to all solutions in
726: -- the removed category and all of its subcategories, recursively
727: update cs_kb_elements_tl
728: set composite_text_index = 'U'
729: where element_id in
730: ( select unique b.element_id
731: from cs_kb_set_categories a, cs_kb_set_eles b
761: -- end (3377135)
762:
763: -- IMMEDIATE Mark all of the statements linked to the
764: -- solution version
765: update cs_kb_elements_tl
766: set composite_text_index = 'U'
767: where element_id in
768: ( select element_id from cs_kb_set_eles
769: where set_id = p_solution_id );
787: l_set_ids list_set_ids;
788: i NUMBER;
789: begin
790: -- IMMEDIATE Mark the statement for indexing
791: update cs_kb_elements_tl
792: set composite_text_index = 'U'
793: where element_id = p_statement_id;
794:
795: --start (3377135)