[Home] [Help]
478: where category_id = p_cat_id );
479:
480: -- IMMEDIATELY Mark all statements linked to the solutions within the
481: -- changed category
482: update cs_kb_elements_tl
483: set composite_text_index = 'U'
484: where element_id in
485: ( select b.element_id
486: from cs_kb_set_categories a, cs_kb_set_eles b
525: where set_id = l_set_id;
526: -- Update the content cache, cause the full path is now changed.
527: Populate_Soln_Content_Cache( l_set_id );
528: -- IMMEDIATELY Mark all statements linked to this solution.
529: update cs_kb_elements_tl
530: set composite_text_index = 'U'
531: where element_id in
532: ( select element_id
533: from cs_kb_set_eles
567: -- Update the content cache, cause the full path is now changed.
568: Populate_Soln_Content_Cache( l_set_id );
569:
570: -- IMMEDIATELY Mark all statements linked to this solution.
571: update cs_kb_elements_tl
572: set composite_text_index = 'U'
573: where element_id in
574: ( select element_id
575: from cs_kb_set_eles
635: connect by prior category_id = parent_category_id ));
636:
637: -- IMMEDIATELY Mark all statements linked to all solutions in
638: -- the removed category and all of its subcategories, recursively
639: update cs_kb_elements_tl
640: set composite_text_index = 'U'
641: where element_id in
642: ( select unique b.element_id
643: from cs_kb_set_categories a, cs_kb_set_eles b
672: -- end (3377135)
673:
674: -- IMMEDIATE Mark all of the statements linked to the
675: -- solution version
676: update cs_kb_elements_tl
677: set composite_text_index = 'U'
678: where element_id in
679: ( select element_id from cs_kb_set_eles
680: where set_id = p_solution_id );
698: l_set_ids list_set_ids;
699: i NUMBER;
700: begin
701: -- IMMEDIATE Mark the statement for indexing
702: update cs_kb_elements_tl
703: set composite_text_index = 'U'
704: where element_id = p_statement_id;
705:
706: --start (3377135)