1 PACKAGE CS_KB_SYNC_INDEX_PKG AS
2 /* $Header: csksyncs.pls 120.1 2006/03/27 15:26:20 allau noship $ */
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
20 /*
21 * Request_Sync_Index
22 * This procedure submits a concurrent request
23 * to sync KM indexes.
24 */
25 PROCEDURE Request_Sync_KM_Indexes
26 ( x_request_id OUT NOCOPY NUMBER,
27 x_return_status OUT NOCOPY VARCHAR2 );
28
29 /*
30 * Request_Mark_Idx_on_Sec_Change
31 * This procedure submits a concurrent request
32 * to mark the solution and statement text indexes when
33 * KM security setup changes.
34 *
35 * Parameters:
36 * 1) SECURITY_CHANGE_ACTION_TYPE
37 * Valid values:
38 * ADD_VIS - Add Visibility Level
39 * REM_VIS - Remove Visibility Level
40 * CHANGE_CAT_VIS - Change Category Visibility
41 * ADD_CAT_TO_CAT_GRP - Add Category to Category Group
42 * REM_CAT_FROM_CAT_GRP - Remove Category from Category Group
43 * 2) For each action type, the parameter values required are as follows:
44 * ADD_VIS
45 * PARAMETER1 - visibility position of the added visibility
46 * REM_VIS
47 * PARAMETER1 - visibility position of the removed visibility
48 * CHANGE_CAT_VIS
49 * PARAMETER1 - category id for which the visibility changed
50 * PARAMETER2 - the original visibility id for the category
51 * ADD_CAT_TO_CAT_GRP
52 * PARAMETER1 - category group id to which the category was added.
53 * PARAMETER2 - category id which was added to the category group.
54 * REM_CAT_FROM_CAT_GRP
55 * PARAMETER1 - category group id from which the category was removed.
56 * PARAMETER2 - category id which was removed from the category group.
57 */
58 PROCEDURE Request_Mark_Idx_on_Sec_Change
59 ( p_security_change_action_type IN VARCHAR2,
60 p_parameter1 IN NUMBER default null,
61 p_parameter2 IN NUMBER default null,
62 x_request_id OUT NOCOPY NUMBER,
63 x_return_status OUT NOCOPY VARCHAR2 );
64
65 /*
66 * Mark_Idxs_on_Pub_Soln
67 * Mark all appropriate text indexes after a solution is
68 * published.
69 */
70 PROCEDURE Mark_Idxs_on_Pub_Soln( p_solution_number varchar2 );
71
72 /*
73 * Mark_Idxs_on_Obs_Soln
74 * Mark all appropriate text indexes after a solution is
75 * obsoleted.
76 */
77 PROCEDURE Mark_Idxs_on_Obs_Soln( p_solution_number varchar2 );
78
79 /*
80 * Mark_Idxs_on_Global_Stmt_Upd
81 * Mark all appropriate text indexes after a global statement
82 * update is performed.
83 */
84 PROCEDURE Mark_Idxs_on_Global_Stmt_Upd( p_statement_id number );
85
86 -- Add Visibility Level - ADD_VIS
87 /*
88 * Mark_Idx_on_Add_Vis
89 * Mark Solution and Statement text indexes when a new visibility
90 * level is added.
91 */
92 PROCEDURE Mark_Idx_on_Add_Vis( p_added_vis_pos number );
93
94 /*
95 * Mark_Idx_on_Rem_Vis
96 * Mark Solution and Statement text indexes when a visibility is
97 * removed.
98 */
99 PROCEDURE Mark_Idx_on_Rem_Vis( p_removed_vis_pos number );
100
101 /*
102 * Mark_Idx_on_Change_Cat_Vis
103 * Mark Solution and Statement text indexes when a Solution Category's
104 * visibility level changes.
105 */
106 PROCEDURE Mark_Idx_on_Change_Cat_Vis( p_cat_id number, p_orig_vis_id number );
107
108 /*
109 * Mark_Idx_on_Add_Cat_To_Cat_Grp
110 * Mark Solution and Statement text indexes when a Category is
111 * added to a Category Group.
112 */
113 PROCEDURE Mark_Idx_on_Add_Cat_To_Cat_Grp( p_cat_grp_id number, p_cat_id number );
114
115 /*
116 * Mark_Idx_on_Rem_Cat_fr_Cat_Grp
117 * Mark Solution and Statement text indexes when a Category is
118 * removed from a Category Group.
119 */
120 PROCEDURE Mark_Idx_on_Rem_Cat_fr_Cat_Grp( p_cat_grp_id number, p_cat_id number );
121
122 /*
123 * Mark_Idx_on_Change_Parent_Cat
124 * Mark Solution and Statement text indexes when a Solution Category's
125 * visibility level changes.
126 */
127 PROCEDURE Mark_Idx_on_Change_Parent_Cat( p_cat_id number, p_orig_parent_cat_id number );
128
129 /*
130 * Mark_Idxs_For_Multi_Soln
131 * Mark Solution and Statement text indexes for multiple solutions.
132 */
133 PROCEDURE Mark_Idxs_For_Multi_Soln( p_set_ids JTF_NUMBER_TABLE );
134
135
136 /*
137 * Request_Sync_Set_Index
138 * This procedure submits a concurrent request
139 * to sync KM set index.
140 */
141 PROCEDURE Request_Sync_Set_Index
142 ( x_request_id OUT NOCOPY NUMBER,
143 x_return_status OUT NOCOPY VARCHAR2 );
144
145 /*
146 * Request_Sync_Element_Index
147 * This procedure submits a concurrent request
148 * to sync KM element index.
149 */
150 PROCEDURE Request_Sync_Element_Index
151 ( x_request_id OUT NOCOPY NUMBER,
152 x_return_status OUT NOCOPY VARCHAR2 );
153
154 end CS_KB_SYNC_INDEX_PKG;