1 PACKAGE CS_KB_CONC_PROG_PKG AS
2 /* $Header: csksynis.pls 120.0 2005/06/01 12:11:58 appldev noship $ */
3
4 SUCCESS NUMBER := 0;
5 WARNING NUMBER := 1;
6 ERROR NUMBER := 2;
7
8 PROCEDURE Sync_All_Index (ERRBUF OUT NOCOPY VARCHAR2,
9 RETCODE OUT NOCOPY NUMBER,
10 BMODE IN VARCHAR2 default null);
11
12 PROCEDURE Sync_Element_Index (ERRBUF OUT NOCOPY VARCHAR2,
13 RETCODE OUT NOCOPY NUMBER,
14 BMODE IN VARCHAR2,
15 pworker IN NUMBER DEFAULT 0);
16 PROCEDURE Sync_Set_Index (ERRBUF OUT NOCOPY VARCHAR2,
17 RETCODE OUT NOCOPY NUMBER,
18 BMODE IN VARCHAR2,
19 pworker IN NUMBER DEFAULT 0);
20
21 PROCEDURE Sync_Forum_Index (ERRBUF OUT NOCOPY VARCHAR2,
22 RETCODE OUT NOCOPY NUMBER,
23 BMODE IN VARCHAR2,
24 pworker IN NUMBER DEFAULT 0);
25
26 PROCEDURE Sync_Soln_Cat_Index (ERRBUF OUT NOCOPY VARCHAR2,
27 RETCODE OUT NOCOPY NUMBER,
28 BMODE IN VARCHAR2,
29 pworker IN NUMBER DEFAULT 0);
30
31 PROCEDURE Sync_index( index1 IN VARCHAR2,
32 bmode IN VARCHAR2,
33 pworker IN NUMBER DEFAULT 0);
34
35 procedure del_sync_prog;
36
37 procedure update_set_count_sum (ERRBUF OUT NOCOPY VARCHAR2,
38 RETCODE OUT NOCOPY NUMBER);
39
40 -- klou, (SRCHEFF), since 11.5.10
41 PROCEDURE Update_Magic_Word;
42
43 PROCEDURE Update_Usage_Score (ERRBUF OUT NOCOPY VARCHAR2,
44 RETCODE OUT NOCOPY NUMBER);
45 -- End (SRCHEFF)
46
47 /*
48 * Rebuild_Soln_Content_Cache
49 * Repopulate the solution content cache column for all published
50 * solutions. Content cache entries will be commited in batches.
51 */
52 PROCEDURE Rebuild_Soln_Content_Cache
53 ( errbuf out nocopy varchar2,
54 retcode out nocopy number );
55
56
57 /*
58 * Mark_Idx_on_Sec_Change
59 * Mark text index columns (solutions and statements) when KM
60 * security setup changes. Marking the text columns is done off-line
61 * in a concurrent program to give better UI response time.
62 * The way the program works is by passing in a security change
63 * action type code. For each action type, there is a list of
64 * parameters that get passed through parameter1-2.
65 *
66 * Parameters:
67 * 1) SECURITY_CHANGE_ACTION_TYPE
68 * Valid values:
69 * ADD_VIS - Add Visibility Level
70 * REM_VIS - Remove Visibility Level
71 * CHANGE_CAT_VIS - Change Category Visibility
72 * ADD_CAT_TO_CAT_GRP - Add Category to Category Group
73 * REM_CAT_FROM_CAT_GRP - Remove Category from Category Group
74 * 2) For each action type, the parameter values required are as follows:
75 * ADD_VIS
76 * PARAMETER1 - visibility position of the added visibility
77 * REM_VIS
78 * PARAMETER1 - visibility position of the removed visibility
79 * CHANGE_CAT_VIS
80 * PARAMETER1 - category id for which the visibility changed
81 * PARAMETER2 - the original visibility id for the category
82 * ADD_CAT_TO_CAT_GRP
83 * PARAMETER1 - category group id to which the category was added.
84 * PARAMETER2 - category id which was added to the category group.
85 * REM_CAT_FROM_CAT_GRP
86 * PARAMETER1 - category group id from which the category was removed.
87 * PARAMETER2 - category id which was removed from the category group.
88 */
89 PROCEDURE Mark_Idx_on_Sec_Change
90 ( ERRBUF OUT NOCOPY VARCHAR2,
91 RETCODE OUT NOCOPY NUMBER,
92 SECURITY_CHANGE_ACTION_TYPE IN VARCHAR2 default null,
93 PARAMETER1 IN NUMBER default null,
94 PARAMETER2 IN NUMBER default null );
95
96
97 /*
98 * get_max_parallel_worker: get THE job_queue_processes value.
99 */
100 FUNCTION get_max_parallel_worker RETURN NUMBER;
101
102 /*
103 * is_validate_mode: VALIDATE a synchronization MODE.
104 * RETURN 'Y' IF THE MODE IS valid. Otherwise RETURN 'N'.
105 */
106 FUNCTION is_validate_mode(bmode IN VARCHAR2) RETURN VARCHAR;
107
108 /*
109 * Create_Set_Index
110 * This PROCEDURE creates THE solution INDEX AND also populates THE INDEX
111 * content.
112 */
113 PROCEDURE Create_Set_Index
114 ( pworker IN NUMBER DEFAULT 0,
115 x_msg_error OUT NOCOPY VARCHAR2,
116 x_return_status OUT NOCOPY VARCHAR2
117 );
118
119
120 /*
121 * Create_Element_Index
122 * This PROCEDURE creates the statement INDEX AND also populates THE INDEX
123 * content.
124 */
125 PROCEDURE Create_Element_Index
126 ( pworker IN NUMBER DEFAULT 0,
127 x_msg_error OUT NOCOPY VARCHAR2,
128 x_return_status OUT NOCOPY VARCHAR2
129 );
130
131 /*
132 * Create_Soln_Cat_Index
133 * This PROCEDURE creates the category INDEX AND also populates THE INDEX
134 * content.
135 */
136 PROCEDURE Create_Soln_Cat_Index
137 ( pworker IN NUMBER DEFAULT 0,
138 x_msg_error OUT NOCOPY VARCHAR2,
139 x_return_status OUT NOCOPY VARCHAR2
140 );
141
142
143 /*
144 * Create_Forum_Index
145 * This PROCEDURE creates the forum INDEX AND also populates THE INDEX
146 * content.
147 */
148 PROCEDURE Create_Forum_Index
149 ( pworker IN NUMBER DEFAULT 0,
150 x_msg_error OUT NOCOPY VARCHAR2,
151 x_return_status OUT NOCOPY VARCHAR2
152 );
153
154 PROCEDURE Drop_Index
155 ( p_index_name IN VARCHAR,
156 x_msg_error OUT NOCOPY VARCHAR2,
157 x_return_status OUT NOCOPY VARCHAR2
158 );
159
160 end CS_KB_CONC_PROG_PKG;