[Home] [Help]
344: update cs_kb_sets_b
345: set reindex_flag = 'U'
346: where set_id in
347: ( select unique a.set_id
348: from cs_kb_set_categories a, cs_kb_soln_categories_b b,
349: cs_kb_visibilities_b c
350: where a.category_id = b.category_id
351: and b.visibility_id = c.visibility_id
352: and c.position >= p_added_vis_pos );
357: update cs_kb_elements_b
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
400: update cs_kb_sets_b
401: set reindex_flag = 'U'
402: where set_id in
403: ( select unique a.set_id
404: from cs_kb_set_categories a, cs_kb_soln_categories_b b,
405: cs_kb_visibilities_b c
406: where a.category_id = b.category_id
407: and b.visibility_id = c.visibility_id
408: and c.position >= p_removed_vis_pos );
413: update cs_kb_elements_b
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
451: update cs_kb_sets_b
452: set reindex_flag = 'U'
453: where set_id in
454: ( select set_id
455: from cs_kb_set_categories
456: where category_id = p_cat_id );
457:
458: -- DELAYED Mark all statements linked to the solutions
459: -- within the changed category
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
473: update cs_kb_sets_tl
474: set composite_assoc_index = 'U'
475: where set_id in
476: ( select set_id
477: from cs_kb_set_categories
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
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.
500: PROCEDURE Mark_Idx_on_Change_Parent_Cat( p_cat_id number, p_orig_parent_cat_id number )
501: is
502: cursor get_descendent_sets(cp_cat_id number) is
503: select b.set_id
504: from cs_kb_set_categories c, cs_kb_sets_b b
505: where c.category_id in
506: (
507: select category_id
508: from cs_kb_soln_categories_b
590: update cs_kb_sets_b
591: set reindex_flag = 'U'
592: where set_id in
593: ( select unique set_id
594: from cs_kb_set_categories
595: where category_id in
596: ( select category_id
597: from cs_kb_soln_categories_b
598: start with category_id = p_cat_id
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
626: update cs_kb_sets_tl
627: set composite_assoc_index = 'U'
628: where set_id in
629: ( select unique set_id
630: from cs_kb_set_categories
631: where category_id in
632: ( select category_id
633: from cs_kb_soln_categories_b
634: start with category_id = p_cat_id
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