APPS.CS_KB_SYNC_INDEX_PKG dependencies on CS_KB_VISIBILITIES_B

Line 327: from cs_kb_sets_b a, cs_kb_visibilities_b b

323: update cs_kb_sets_b
324: set reindex_flag = 'U'
325: where set_id in
326: ( select a.set_id
327: from cs_kb_sets_b a, cs_kb_visibilities_b b
328: where a.visibility_id = b.visibility_id
329: and b.position >= p_added_vis_pos );
330:
331: -- DELAYED Mark all statements linked to solutions having a higher

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

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
338: where a.visibility_id = b.visibility_id
339: and a.set_id = c.set_id
340: and b.position >= p_added_vis_pos );
341:

Line 349: cs_kb_visibilities_b c

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

Line 362: cs_kb_visibilities_b c, cs_kb_set_eles d

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
366: and c.position >= p_added_vis_pos );

Line 383: from cs_kb_sets_b a, cs_kb_visibilities_b b

379: update cs_kb_sets_b
380: set reindex_flag = 'U'
381: where set_id in
382: ( select a.set_id
383: from cs_kb_sets_b a, cs_kb_visibilities_b b
384: where a.visibility_id = b.visibility_id
385: and b.position >= p_removed_vis_pos );
386:
387: -- IMMEDIATELY Mark all statements linked to solutions having a higher

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

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
394: where a.visibility_id = b.visibility_id
395: and a.set_id = c.set_id
396: and b.position >= p_removed_vis_pos );
397:

Line 405: cs_kb_visibilities_b c

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

Line 418: cs_kb_visibilities_b c, cs_kb_set_eles d

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
422: and c.position >= p_removed_vis_pos );

Line 438: from cs_kb_visibilities_b

434: begin
435: -- Fetch the visibility position for the categories original visibility
436: -- and the categories new visibility
437: select position into l_orig_cat_vis_pos
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

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