[Home] [Help]
41: l_src_pos number := 1;
42: begin
43: -- First fetch the existing content cache LOB locator
44: select content_cache into l_cache
45: from cs_kb_sets_tl
46: where set_id = p_solution_id and language = p_lang
47: for update;
48:
49: -- If the LOB locator is null, we need to initialize one
48:
49: -- If the LOB locator is null, we need to initialize one
50: if( l_cache is null ) then
51: -- populate cache LOB locator with an empty CLOB
52: update cs_kb_sets_tl
53: set content_cache = empty_clob()
54: where set_id = p_solution_id and language = p_lang;
55:
56: -- re-fetch the cache lob locator
54: where set_id = p_solution_id and language = p_lang;
55:
56: -- re-fetch the cache lob locator
57: select content_cache into l_cache
58: from cs_kb_sets_tl
59: where set_id = p_solution_id and language = p_lang
60: for update;
61: end if;
62:
117: l_attach_src_pos number := 1;
118: begin
119: -- First fetch the existing content cache LOB locator
120: select attachment_content_cache into l_attach_cache
121: from cs_kb_sets_tl
122: where set_id = p_solution_id and language = p_lang
123: for update;
124:
125: -- If the LOB locator is null, we need to initialize one
124:
125: -- If the LOB locator is null, we need to initialize one
126: if( l_attach_cache is null ) then
127: -- populate cache LOB locator with an empty CLOB
128: update cs_kb_sets_tl
129: set attachment_content_cache = empty_clob()
130: where set_id = p_solution_id and language = p_lang;
131:
132: -- re-fetch the cache lob locator
130: where set_id = p_solution_id and language = p_lang;
131:
132: -- re-fetch the cache lob locator
133: select attachment_content_cache into l_attach_cache
134: from cs_kb_sets_tl
135: where set_id = p_solution_id and language = p_lang
136: for update;
137: end if;
138:
555: -- Else if the category's visibility changed to a more secure level,
556: -- IMMEDIATELY mark the solutions and statements
557:
558: -- IMMEDIATELY Mark all solutions within the changed category
559: update cs_kb_sets_tl
560: set composite_assoc_index = 'U', composite_assoc_attach_index = 'U' --12.1.3
561: where set_id in
562: ( select set_id
563: from cs_kb_set_categories
605: open get_descendent_sets(p_cat_id);
606: loop
607: fetch get_descendent_sets into l_set_id;
608: exit when get_descendent_sets%notfound;
609: update cs_kb_sets_tl
610: set composite_assoc_index = 'U', composite_assoc_attach_index = 'U' --12.1.3
611: where set_id = l_set_id;
612: -- Update the content cache, cause the full path is now changed.
613: Populate_Soln_Content_Cache( l_set_id );
646: close is_published_soln;
647:
648: if(l_set_id is not null) then
649: -- IMMEDIATELY Mark this solution.
650: update cs_kb_sets_tl
651: set composite_assoc_index = 'U', composite_assoc_attach_index = 'U' --12.1.3
652: where set_id = l_set_id;
653:
654: -- Update the content cache, cause the full path is now changed.
710: is
711: begin
712: -- IMMEDIATELY Mark all solutions in the removed category
713: -- and all of its subcategories, recursively
714: update cs_kb_sets_tl
715: set composite_assoc_index = 'U', composite_assoc_attach_index = 'U' --12.1.3
716: where set_id in
717: ( select unique set_id
718: from cs_kb_set_categories
749: PROCEDURE Immediate_Mark_Soln_And_Stmts( p_solution_id number )
750: is
751: begin
752: -- IMMEDIATE Mark the solution version for indexing
753: update cs_kb_sets_tl
754: set composite_assoc_index = 'U', composite_assoc_attach_index = 'U' --12.1.3
755: where set_id = p_solution_id;
756:
757: -- (3377135)
803: populate_soln_content_cache(l_set_ids(i));
804: Pop_Soln_Attach_Content_Cache (l_set_ids(i));
805:
806: --Mark the solution for update
807: UPDATE cs_kb_sets_tl
808: set composite_assoc_index = 'U',composite_assoc_attach_index = 'U' --12.1.3
809: where set_id = l_set_ids(i);
810:
811: i := l_set_ids.NEXT(i);
813:
814: /*
815: -- IMMEDIATE Mark all of the published solutions linked to the
816: -- statement
817: update cs_kb_sets_tl
818: set composite_assoc_index = 'U'
819: where set_id in
820: ( select se.set_id from cs_kb_set_eles se,
821: cs_kb_sets_b sb