1 PACKAGE CS_KB_SYNC_INDEX_PKG AUTHID CURRENT_USER AS
2 /* $Header: csksyncs.pls 120.2 2009/05/06 08:06:10 mmaiya ship $ */
3
4 /*
5 * Populate_Soln_Content_Cache
6 * Populate a solution's content cache, for a given
7 * language, with the cacheable synthesized text content
8 */
9 PROCEDURE Populate_Soln_Content_Cache
10 ( p_solution_id in number, p_lang in varchar2 );
11
12 /*
13 * Populate_Soln_Content_Cache
14 * Populate a solution's content cache, for all installed
15 * languages, with the cacheable synthesized text content
16 */
17 PROCEDURE Populate_Soln_Content_Cache( p_solution_id in number );
18
19 --Start 12.1.3
20 /*
21 * Populate_Soln_Attach_Content_Cache
22 * Populate a solution's attachment content cache, for a given
23 * language, with the cacheable synthesized text content
24 */
25 PROCEDURE Pop_Soln_Attach_Content_Cache
26 ( p_solution_id in number, p_lang in varchar2 );
27
28 /*
29 * Populate_Soln_Attach_Content_Cache
30 * Populate a solution's attachment content cache, for all installed
31 * languages, with the cacheable synthesized text content
32 */
33 PROCEDURE Pop_Soln_Attach_Content_Cache( p_solution_id in number );
34 --End 12.1.3
35
36
37 /*
38 * Request_Sync_Index
39 * This procedure submits a concurrent request
40 * to sync KM indexes.
41 */
42 PROCEDURE Request_Sync_KM_Indexes
43 ( x_request_id OUT NOCOPY NUMBER,
44 x_return_status OUT NOCOPY VARCHAR2 );
45
46 /*
47 * Request_Mark_Idx_on_Sec_Change
48 * This procedure submits a concurrent request
49 * to mark the solution and statement text indexes when
50 * KM security setup changes.
51 *
52 * Parameters:
53 * 1) SECURITY_CHANGE_ACTION_TYPE
54 * Valid values:
55 * ADD_VIS - Add Visibility Level
56 * REM_VIS - Remove Visibility Level
57 * CHANGE_CAT_VIS - Change Category Visibility
58 * ADD_CAT_TO_CAT_GRP - Add Category to Category Group
59 * REM_CAT_FROM_CAT_GRP - Remove Category from Category Group
60 * 2) For each action type, the parameter values required are as follows:
61 * ADD_VIS
62 * PARAMETER1 - visibility position of the added visibility
63 * REM_VIS
64 * PARAMETER1 - visibility position of the removed visibility
65 * CHANGE_CAT_VIS
66 * PARAMETER1 - category id for which the visibility changed
67 * PARAMETER2 - the original visibility id for the category
68 * ADD_CAT_TO_CAT_GRP
69 * PARAMETER1 - category group id to which the category was added.
70 * PARAMETER2 - category id which was added to the category group.
71 * REM_CAT_FROM_CAT_GRP
72 * PARAMETER1 - category group id from which the category was removed.
73 * PARAMETER2 - category id which was removed from the category group.
74 */
75 PROCEDURE Request_Mark_Idx_on_Sec_Change
76 ( p_security_change_action_type IN VARCHAR2,
77 p_parameter1 IN NUMBER default null,
78 p_parameter2 IN NUMBER default null,
79 x_request_id OUT NOCOPY NUMBER,
80 x_return_status OUT NOCOPY VARCHAR2 );
81
82 /*
83 * Mark_Idxs_on_Pub_Soln
84 * Mark all appropriate text indexes after a solution is
85 * published.
86 */
87 PROCEDURE Mark_Idxs_on_Pub_Soln( p_solution_number varchar2 );
88
89 /*
90 * Mark_Idxs_on_Obs_Soln
91 * Mark all appropriate text indexes after a solution is
92 * obsoleted.
93 */
94 PROCEDURE Mark_Idxs_on_Obs_Soln( p_solution_number varchar2 );
95
96 /*
97 * Mark_Idxs_on_Global_Stmt_Upd
98 * Mark all appropriate text indexes after a global statement
99 * update is performed.
100 */
101 PROCEDURE Mark_Idxs_on_Global_Stmt_Upd( p_statement_id number );
102
103 -- Add Visibility Level - ADD_VIS
104 /*
105 * Mark_Idx_on_Add_Vis
106 * Mark Solution and Statement text indexes when a new visibility
107 * level is added.
108 */
109 PROCEDURE Mark_Idx_on_Add_Vis( p_added_vis_pos number );
110
111 /*
112 * Mark_Idx_on_Rem_Vis
113 * Mark Solution and Statement text indexes when a visibility is
114 * removed.
115 */
116 PROCEDURE Mark_Idx_on_Rem_Vis( p_removed_vis_pos number );
117
118 /*
119 * Mark_Idx_on_Change_Cat_Vis
120 * Mark Solution and Statement text indexes when a Solution Category's
121 * visibility level changes.
122 */
123 PROCEDURE Mark_Idx_on_Change_Cat_Vis( p_cat_id number, p_orig_vis_id number );
124
125 /*
126 * Mark_Idx_on_Add_Cat_To_Cat_Grp
127 * Mark Solution and Statement text indexes when a Category is
128 * added to a Category Group.
129 */
130 PROCEDURE Mark_Idx_on_Add_Cat_To_Cat_Grp( p_cat_grp_id number, p_cat_id number );
131
132 /*
133 * Mark_Idx_on_Rem_Cat_fr_Cat_Grp
134 * Mark Solution and Statement text indexes when a Category is
135 * removed from a Category Group.
136 */
137 PROCEDURE Mark_Idx_on_Rem_Cat_fr_Cat_Grp( p_cat_grp_id number, p_cat_id number );
138
139 /*
140 * Mark_Idx_on_Change_Parent_Cat
141 * Mark Solution and Statement text indexes when a Solution Category's
142 * visibility level changes.
143 */
144 PROCEDURE Mark_Idx_on_Change_Parent_Cat( p_cat_id number, p_orig_parent_cat_id number );
145
146 /*
147 * Mark_Idxs_For_Multi_Soln
148 * Mark Solution and Statement text indexes for multiple solutions.
149 */
150 PROCEDURE Mark_Idxs_For_Multi_Soln( p_set_ids JTF_NUMBER_TABLE );
151
152
153 /*
154 * Request_Sync_Set_Index
155 * This procedure submits a concurrent request
156 * to sync KM set index.
157 */
158 PROCEDURE Request_Sync_Set_Index
159 ( x_request_id OUT NOCOPY NUMBER,
160 x_return_status OUT NOCOPY VARCHAR2 );
161
162 /*
163 * Request_Sync_Element_Index
164 * This procedure submits a concurrent request
165 * to sync KM element index.
166 */
167 PROCEDURE Request_Sync_Element_Index
168 ( x_request_id OUT NOCOPY NUMBER,
169 x_return_status OUT NOCOPY VARCHAR2 );
170
171 end CS_KB_SYNC_INDEX_PKG;