[Home] [Help]
333: update cs_kb_elements_b
334: set reindex_flag = 'U'
335: where element_id in
336: ( select unique c.element_id
337: from cs_kb_sets_b a, cs_kb_visibilities_b b, cs_kb_set_eles c
338: where a.visibility_id = b.visibility_id
339: and a.set_id = c.set_id
340: and b.position >= p_added_vis_pos );
341:
358: set reindex_flag = 'U'
359: where element_id in
360: ( select unique d.element_id
361: from cs_kb_set_categories a, cs_kb_soln_categories_b b,
362: cs_kb_visibilities_b c, cs_kb_set_eles d
363: where a.category_id = b.category_id
364: and a.set_id = d.set_id
365: and b.visibility_id = c.visibility_id
366: and c.position >= p_added_vis_pos );
389: update cs_kb_elements_b
390: set reindex_flag = 'U'
391: where element_id in
392: ( select unique c.element_id
393: from cs_kb_sets_b a, cs_kb_visibilities_b b, cs_kb_set_eles c
394: where a.visibility_id = b.visibility_id
395: and a.set_id = c.set_id
396: and b.position >= p_removed_vis_pos );
397:
414: set reindex_flag = 'U'
415: where element_id in
416: ( select unique d.element_id
417: from cs_kb_set_categories a, cs_kb_soln_categories_b b,
418: cs_kb_visibilities_b c, cs_kb_set_eles d
419: where a.category_id = b.category_id
420: and a.set_id = d.set_id
421: and b.visibility_id = c.visibility_id
422: and c.position >= p_removed_vis_pos );
460: update cs_kb_elements_b
461: set reindex_flag = 'U'
462: where element_id in
463: ( select b.element_id
464: from cs_kb_set_categories a, cs_kb_set_eles b
465: where a.set_id = b.set_id
466: and a.category_id = p_cat_id );
467: elsif ( l_new_cat_vis_pos < l_orig_cat_vis_pos )
468: then
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
487: where a.set_id = b.set_id
488: and a.category_id = p_cat_id );
489: else
490: -- Otherwise, the category visibilities have not change so do nothing.
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
534: where set_id = l_set_id);
535: end loop;
536: close get_descendent_sets;
537:
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
576: where set_id = l_set_id);
577: end if;
578: end loop;
579: end Mark_Idxs_For_Multi_Soln;
603: update cs_kb_elements_b
604: set reindex_flag = 'U'
605: where element_id in
606: ( select unique b.element_id
607: from cs_kb_set_categories a, cs_kb_set_eles b
608: where a.set_id = b.set_id
609: and a.category_id in
610: ( select category_id
611: from cs_kb_soln_categories_b
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
644: where a.set_id = b.set_id
645: and a.category_id in
646: ( select category_id
647: from cs_kb_soln_categories_b
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 );
681: end;
682:
683: /*
689: is
690: --(3377135)
691: CURSOR get_related_sets (p_statement_id NUMBER)
692: IS
693: select se.set_id from cs_kb_set_eles se, cs_kb_sets_b sb
694: where se.element_id = p_statement_id
695: and se.set_id = sb.set_id
696: and sb.status = 'PUB';
697: TYPE list_set_ids IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
726: -- statement
727: update cs_kb_sets_tl
728: set composite_assoc_index = 'U'
729: where set_id in
730: ( select se.set_id from cs_kb_set_eles se,
731: cs_kb_sets_b sb
732: where se.element_id = p_statement_id
733: and se.set_id = sb.set_id
734: and sb.status = 'PUB');