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