APPS.CS_KB_SYNC_INDEX_PKG dependencies on CS_KB_SOLN_CATEGORIES_B

Line 348: from cs_kb_set_categories a, cs_kb_soln_categories_b b,

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

Line 361: from cs_kb_set_categories a, cs_kb_soln_categories_b b,

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

Line 404: from cs_kb_set_categories a, cs_kb_soln_categories_b b,

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

Line 417: from cs_kb_set_categories a, cs_kb_soln_categories_b b,

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

Line 442: from cs_kb_soln_categories_b c, cs_kb_visibilities_b v

438: from cs_kb_visibilities_b
439: where visibility_id = p_orig_vis_id;
440:
441: select v.position into l_new_cat_vis_pos
442: from cs_kb_soln_categories_b c, cs_kb_visibilities_b v
443: where c.category_id = p_cat_id
444: and c.visibility_id = v.visibility_id;
445:
446: -- Mark solutions and statements in DELAYED mode if the

Line 508: from cs_kb_soln_categories_b

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
509: start with category_id = cp_cat_id
510: connect by prior category_id = Parent_category_id
511: )
512: and c.set_id = b.set_id

Line 597: from cs_kb_soln_categories_b

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
599: connect by prior category_id = parent_category_id ));
600:
601: -- DELAYED Mark all statements linked to all solutions in the

Line 611: from cs_kb_soln_categories_b

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
612: start with category_id = p_cat_id
613: connect by prior category_id = parent_category_id ));
614: end Mark_Idx_on_Add_Cat_To_Cat_Grp;
615:

Line 633: from cs_kb_soln_categories_b

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
635: connect by prior category_id = parent_category_id ));
636:
637: -- IMMEDIATELY Mark all statements linked to all solutions in

Line 647: from cs_kb_soln_categories_b

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
648: start with category_id = p_cat_id
649: connect by prior category_id = parent_category_id ));
650: end Mark_Idx_on_Rem_Cat_fr_Cat_Grp;
651: