430: update cs_kb_sets_b
431: set reindex_flag = 'U'
432: where set_id in
433: ( select unique a.set_id
434: from cs_kb_set_categories a, cs_kb_soln_categories_b b,
435: cs_kb_visibilities_b c
436: where a.category_id = b.category_id
437: and b.visibility_id = c.visibility_id
438: and c.position >= p_added_vis_pos );
443: update cs_kb_elements_b
444: set reindex_flag = 'U'
445: where element_id in
446: ( select unique d.element_id
447: from cs_kb_set_categories a, cs_kb_soln_categories_b b,
448: cs_kb_visibilities_b c, cs_kb_set_eles d
449: where a.category_id = b.category_id
450: and a.set_id = d.set_id
451: and b.visibility_id = c.visibility_id
486: update cs_kb_sets_b
487: set reindex_flag = 'U'
488: where set_id in
489: ( select unique a.set_id
490: from cs_kb_set_categories a, cs_kb_soln_categories_b b,
491: cs_kb_visibilities_b c
492: where a.category_id = b.category_id
493: and b.visibility_id = c.visibility_id
494: and c.position >= p_removed_vis_pos );
499: update cs_kb_elements_b
500: set reindex_flag = 'U'
501: where element_id in
502: ( select unique d.element_id
503: from cs_kb_set_categories a, cs_kb_soln_categories_b b,
504: cs_kb_visibilities_b c, cs_kb_set_eles d
505: where a.category_id = b.category_id
506: and a.set_id = d.set_id
507: and b.visibility_id = c.visibility_id
537: update cs_kb_sets_b
538: set reindex_flag = 'U'
539: where set_id in
540: ( select set_id
541: from cs_kb_set_categories
542: where category_id = p_cat_id );
543:
544: -- DELAYED Mark all statements linked to the solutions
545: -- within the changed category
546: update cs_kb_elements_b
547: set reindex_flag = 'U'
548: where element_id in
549: ( select b.element_id
550: from cs_kb_set_categories a, cs_kb_set_eles b
551: where a.set_id = b.set_id
552: and a.category_id = p_cat_id );
553: elsif ( l_new_cat_vis_pos < l_orig_cat_vis_pos )
554: then
559: update cs_kb_sets_tl
560: set composite_assoc_index = 'U', composite_assoc_attach_index = 'U' --12.1.3
561: where set_id in
562: ( select set_id
563: from cs_kb_set_categories
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
573: where a.set_id = b.set_id
574: and a.category_id = p_cat_id );
575: else
576: -- Otherwise, the category visibilities have not change so do nothing.
586: PROCEDURE Mark_Idx_on_Change_Parent_Cat( p_cat_id number, p_orig_parent_cat_id number )
587: is
588: cursor get_descendent_sets(cp_cat_id number) is
589: select b.set_id
590: from cs_kb_set_categories c, cs_kb_sets_b b
591: where c.category_id in
592: (
593: select category_id
594: from cs_kb_soln_categories_b
678: update cs_kb_sets_b
679: set reindex_flag = 'U'
680: where set_id in
681: ( select unique set_id
682: from cs_kb_set_categories
683: where category_id in
684: ( select category_id
685: from cs_kb_soln_categories_b
686: start with category_id = p_cat_id
691: update cs_kb_elements_b
692: set reindex_flag = 'U'
693: where element_id in
694: ( select unique b.element_id
695: from cs_kb_set_categories a, cs_kb_set_eles b
696: where a.set_id = b.set_id
697: and a.category_id in
698: ( select category_id
699: from cs_kb_soln_categories_b
714: update cs_kb_sets_tl
715: set composite_assoc_index = 'U', composite_assoc_attach_index = 'U' --12.1.3
716: where set_id in
717: ( select unique set_id
718: from cs_kb_set_categories
719: where category_id in
720: ( select category_id
721: from cs_kb_soln_categories_b
722: start with category_id = p_cat_id
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
732: where a.set_id = b.set_id
733: and a.category_id in
734: ( select category_id
735: from cs_kb_soln_categories_b