APPS.CS_KB_SYNC_INDEX_PKG dependencies on CS_KB_ELEMENTS_B

Line 333: update cs_kb_elements_b

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

Line 357: update cs_kb_elements_b

353:
354: -- DELAYED Mark all statements linked to solutions contained
355: -- in categories having a higher category visibility positions than
356: -- the added visibility level
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,

Line 389: update cs_kb_elements_b

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

Line 413: update cs_kb_elements_b

409:
410: -- IMMEDIATELY Mark all statements linked to solutions contained
411: -- in categories having a higher category visibility positions than
412: -- the removed visibility level
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,

Line 460: update cs_kb_elements_b

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

Line 603: update cs_kb_elements_b

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