APPS.CS_KB_SYNC_INDEX_PKG dependencies on CS_KB_ELEMENTS_B

Line 419: update cs_kb_elements_b

415: and b.position >= p_added_vis_pos );
416:
417: -- DELAYED Mark all statements linked to solutions having a higher
418: -- visibility position than the added visibility level.
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

Line 443: update cs_kb_elements_b

439:
440: -- DELAYED Mark all statements linked to solutions contained
441: -- in categories having a higher category visibility positions than
442: -- the added visibility level
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,

Line 475: update cs_kb_elements_b

471: and b.position >= p_removed_vis_pos );
472:
473: -- IMMEDIATELY Mark all statements linked to solutions having a higher
474: -- visibility position than the removed visibility level.
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

Line 499: update cs_kb_elements_b

495:
496: -- IMMEDIATELY Mark all statements linked to solutions contained
497: -- in categories having a higher category visibility positions than
498: -- the removed visibility level
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,

Line 546: update cs_kb_elements_b

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

Line 691: update cs_kb_elements_b

687: connect by prior category_id = parent_category_id ));
688:
689: -- DELAYED Mark all statements linked to all solutions in the
690: -- removed category and all of its subcategories, recursively
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