APPS.CS_KB_SYNC_INDEX_PKG dependencies on CS_KB_VISIBILITIES_B

Line 413: from cs_kb_sets_b a, cs_kb_visibilities_b b

409: update cs_kb_sets_b
410: set reindex_flag = 'U'
411: where set_id in
412: ( select a.set_id
413: from cs_kb_sets_b a, cs_kb_visibilities_b b
414: where a.visibility_id = b.visibility_id
415: and b.position >= p_added_vis_pos );
416:
417: -- DELAYED Mark all statements linked to solutions having a higher

Line 423: from cs_kb_sets_b a, cs_kb_visibilities_b b, cs_kb_set_eles c

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:

Line 435: cs_kb_visibilities_b c

431: set reindex_flag = 'U'
432: where set_id in
433: ( select unique a.set_id
434: from cs_kb_set_categories a, cs_kb_soln_categories_b b,
435: cs_kb_visibilities_b c
436: where a.category_id = b.category_id
437: and b.visibility_id = c.visibility_id
438: and c.position >= p_added_vis_pos );
439:

Line 448: cs_kb_visibilities_b c, cs_kb_set_eles d

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 );

Line 469: from cs_kb_sets_b a, cs_kb_visibilities_b b

465: update cs_kb_sets_b
466: set reindex_flag = 'U'
467: where set_id in
468: ( select a.set_id
469: from cs_kb_sets_b a, cs_kb_visibilities_b b
470: where a.visibility_id = b.visibility_id
471: and b.position >= p_removed_vis_pos );
472:
473: -- IMMEDIATELY Mark all statements linked to solutions having a higher

Line 479: from cs_kb_sets_b a, cs_kb_visibilities_b b, cs_kb_set_eles c

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:

Line 491: cs_kb_visibilities_b c

487: set reindex_flag = 'U'
488: where set_id in
489: ( select unique a.set_id
490: from cs_kb_set_categories a, cs_kb_soln_categories_b b,
491: cs_kb_visibilities_b c
492: where a.category_id = b.category_id
493: and b.visibility_id = c.visibility_id
494: and c.position >= p_removed_vis_pos );
495:

Line 504: cs_kb_visibilities_b c, cs_kb_set_eles d

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 );

Line 524: from cs_kb_visibilities_b

520: begin
521: -- Fetch the visibility position for the categories original visibility
522: -- and the categories new visibility
523: select position into l_orig_cat_vis_pos
524: from cs_kb_visibilities_b
525: where visibility_id = p_orig_vis_id;
526:
527: select v.position into l_new_cat_vis_pos
528: from cs_kb_soln_categories_b c, cs_kb_visibilities_b v

Line 528: from cs_kb_soln_categories_b c, cs_kb_visibilities_b v

524: from cs_kb_visibilities_b
525: where visibility_id = p_orig_vis_id;
526:
527: select v.position into l_new_cat_vis_pos
528: from cs_kb_soln_categories_b c, cs_kb_visibilities_b v
529: where c.category_id = p_cat_id
530: and c.visibility_id = v.visibility_id;
531:
532: -- Mark solutions and statements in DELAYED mode if the