APPS.CS_KB_SYNC_INDEX_PKG dependencies on CS_KB_SOLN_CATEGORIES_B

Line 434: from cs_kb_set_categories a, cs_kb_soln_categories_b b,

430: update cs_kb_sets_b
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 );

Line 447: from cs_kb_set_categories a, cs_kb_soln_categories_b b,

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,
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

Line 490: from cs_kb_set_categories a, cs_kb_soln_categories_b b,

486: update cs_kb_sets_b
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 );

Line 503: from cs_kb_set_categories a, cs_kb_soln_categories_b b,

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,
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

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

Line 594: from cs_kb_soln_categories_b

590: from cs_kb_set_categories c, cs_kb_sets_b b
591: where c.category_id in
592: (
593: select category_id
594: from cs_kb_soln_categories_b
595: start with category_id = cp_cat_id
596: connect by prior category_id = Parent_category_id
597: )
598: and c.set_id = b.set_id

Line 685: from cs_kb_soln_categories_b

681: ( select unique set_id
682: from cs_kb_set_categories
683: where category_id in
684: ( select category_id
685: from cs_kb_soln_categories_b
686: start with category_id = p_cat_id
687: connect by prior category_id = parent_category_id ));
688:
689: -- DELAYED Mark all statements linked to all solutions in the

Line 699: from cs_kb_soln_categories_b

695: from cs_kb_set_categories a, cs_kb_set_eles b
696: where a.set_id = b.set_id
697: and a.category_id in
698: ( select category_id
699: from cs_kb_soln_categories_b
700: start with category_id = p_cat_id
701: connect by prior category_id = parent_category_id ));
702: end Mark_Idx_on_Add_Cat_To_Cat_Grp;
703:

Line 721: from cs_kb_soln_categories_b

717: ( select unique set_id
718: from cs_kb_set_categories
719: where category_id in
720: ( select category_id
721: from cs_kb_soln_categories_b
722: start with category_id = p_cat_id
723: connect by prior category_id = parent_category_id ));
724:
725: -- IMMEDIATELY Mark all statements linked to all solutions in

Line 735: from cs_kb_soln_categories_b

731: from cs_kb_set_categories a, cs_kb_set_eles b
732: where a.set_id = b.set_id
733: and a.category_id in
734: ( select category_id
735: from cs_kb_soln_categories_b
736: start with category_id = p_cat_id
737: connect by prior category_id = parent_category_id ));
738: end Mark_Idx_on_Rem_Cat_fr_Cat_Grp;
739: