[Home] [Help]
419: update cs_kb_elements_b
420: set reindex_flag = 'U'
421: where element_id in
422: ( select unique c.element_id
423: from cs_kb_sets_b a, cs_kb_visibilities_b b, cs_kb_set_eles c
424: where a.visibility_id = b.visibility_id
425: and a.set_id = c.set_id
426: and b.position >= p_added_vis_pos );
427:
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
452: and c.position >= p_added_vis_pos );
475: update cs_kb_elements_b
476: set reindex_flag = 'U'
477: where element_id in
478: ( select unique c.element_id
479: from cs_kb_sets_b a, cs_kb_visibilities_b b, cs_kb_set_eles c
480: where a.visibility_id = b.visibility_id
481: and a.set_id = c.set_id
482: and b.position >= p_removed_vis_pos );
483:
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
508: and c.position >= p_removed_vis_pos );
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
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.
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
621: where set_id = l_set_id);
622: end loop;
623: close get_descendent_sets;
624:
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
664: where set_id = l_set_id);
665: end if;
666: end loop;
667: end Mark_Idxs_For_Multi_Soln;
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
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
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 );
770: end;
771:
772: /*
778: is
779: --(3377135)
780: CURSOR get_related_sets (p_statement_id NUMBER)
781: IS
782: select se.set_id from cs_kb_set_eles se, cs_kb_sets_b sb
783: where se.element_id = p_statement_id
784: and se.set_id = sb.set_id
785: and sb.status = 'PUB';
786: TYPE list_set_ids IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
816: -- statement
817: update cs_kb_sets_tl
818: set composite_assoc_index = 'U'
819: where set_id in
820: ( select se.set_id from cs_kb_set_eles se,
821: cs_kb_sets_b sb
822: where se.element_id = p_statement_id
823: and se.set_id = sb.set_id
824: and sb.status = 'PUB');