1 PACKAGE EGO_SEARCH_FWK_PUB AS
2 /* $Header: EGOPSFWS.pls 120.2.12000000.2 2007/05/03 12:39:12 ksathupa ship $ */
3 /*---------------------------------------------------------------------------+
4 | This package contains public API for Search Framework |
5 +---------------------------------------------------------------------------*/
6
7
8 PROCEDURE create_criteria_template
9 (
10 X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
11 X_CUSTOMIZATION_CODE IN VARCHAR2,
12 X_REGION_APPLICATION_ID IN NUMBER,
13 X_REGION_CODE IN VARCHAR2,
14 X_NAME IN VARCHAR2,
15 X_DESCRIPTION IN VARCHAR2,
16 X_VERTICALIZATION_ID IN VARCHAR2,
17 X_LOCALIZATION_CODE IN VARCHAR2,
18 X_ORG_ID IN NUMBER,
19 X_SITE_ID IN NUMBER,
20 X_RESPONSIBILITY_ID IN NUMBER,
21 X_WEB_USER_ID IN NUMBER,
22 X_DEFAULT_CUSTOMIZATION_FLAG IN VARCHAR2,
23 X_CUSTOMIZATION_LEVEL_ID IN NUMBER,
24 X_CREATED_BY IN NUMBER,
25 X_CREATION_DATE IN DATE,
26 X_LAST_UPDATED_BY IN NUMBER,
27 X_LAST_UPDATE_DATE IN DATE,
28 X_LAST_UPDATE_LOGIN IN NUMBER,
29 X_START_DATE_ACTIVE IN DATE,
30 X_END_DATE_ACTIVE IN DATE,
31 X_CLASSIFICATION_1 IN VARCHAR2 DEFAULT NULL,
32 X_CLASSIFICATION_2 IN VARCHAR2 DEFAULT NULL,
33 X_CLASSIFICATION_3 IN VARCHAR2 DEFAULT NULL,
34 X_RF_CUSTOMIZATION_APPL_ID IN NUMBER DEFAULT NULL,
35 X_RF_CUSTOMIZATION_CODE IN VARCHAR2 DEFAULT NULL,
36 X_RF_REGION_APPLICATION_ID IN NUMBER DEFAULT NULL,
37 X_RF_REGION_CODE IN VARCHAR2 DEFAULT NULL,
38 X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
39 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
40 X_ERRORCODE OUT NOCOPY NUMBER
41 );
42
43 PROCEDURE update_criteria_template
44 (
45 X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
46 X_CUSTOMIZATION_CODE IN VARCHAR2,
47 X_REGION_APPLICATION_ID IN NUMBER,
48 X_REGION_CODE IN VARCHAR2,
49 X_NAME IN VARCHAR2,
50 X_DESCRIPTION IN VARCHAR2,
51 X_VERTICALIZATION_ID IN VARCHAR2,
52 X_LOCALIZATION_CODE IN VARCHAR2,
53 X_ORG_ID IN NUMBER,
54 X_SITE_ID IN NUMBER,
55 X_RESPONSIBILITY_ID IN NUMBER,
56 X_WEB_USER_ID IN NUMBER,
57 X_DEFAULT_CUSTOMIZATION_FLAG IN VARCHAR2,
58 X_CUSTOMIZATION_LEVEL_ID IN NUMBER,
59 X_LAST_UPDATED_BY IN NUMBER,
60 X_LAST_UPDATE_DATE IN DATE,
61 X_LAST_UPDATE_LOGIN IN NUMBER,
62 X_START_DATE_ACTIVE IN DATE,
63 X_END_DATE_ACTIVE IN DATE,
64 X_CLASSIFICATION_1 IN VARCHAR2 DEFAULT NULL,
65 X_CLASSIFICATION_2 IN VARCHAR2 DEFAULT NULL,
66 X_CLASSIFICATION_3 IN VARCHAR2 DEFAULT NULL,
67 X_RF_CUSTOMIZATION_APPL_ID IN NUMBER DEFAULT NULL,
68 X_RF_CUSTOMIZATION_CODE IN VARCHAR2 DEFAULT NULL,
69 X_RF_REGION_APPLICATION_ID IN NUMBER DEFAULT NULL,
70 X_RF_REGION_CODE IN VARCHAR2 DEFAULT NULL,
71 X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
72 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
73 X_ERRORCODE OUT NOCOPY NUMBER
74 );
75
76 PROCEDURE delete_criteria_template
77 (
78 X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
79 X_CUSTOMIZATION_CODE IN VARCHAR2,
80 X_REGION_APPLICATION_ID IN NUMBER,
81 X_REGION_CODE IN VARCHAR2,
82 X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
83 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
84 X_ERRORCODE OUT NOCOPY NUMBER
85 );
86
87 PROCEDURE translate_criteria_template
88 ( p_customization_application_id IN NUMBER
89 ,p_customization_code IN VARCHAR2
90 ,p_region_application_id IN NUMBER
91 ,p_region_code IN VARCHAR2
92 ,p_customization_level_id IN NUMBER
93 ,p_last_update_date IN VARCHAR2
94 ,p_last_updated_by IN NUMBER
95 ,p_name IN VARCHAR2
96 ,p_description IN VARCHAR2
97 ,x_return_status OUT NOCOPY VARCHAR2
98 ,x_msg_data OUT NOCOPY VARCHAR2
99 );
100
101 ---------------------------------------------------------
102 PROCEDURE create_criteria_template_rf
103 (
104 X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
105 X_CUSTOMIZATION_CODE IN VARCHAR2,
106 X_REGION_APPLICATION_ID IN NUMBER,
107 X_REGION_CODE IN VARCHAR2,
108 X_RF_CUSTOMIZATION_APPL_ID IN NUMBER,
109 X_RF_CUSTOMIZATION_CODE IN VARCHAR2,
110 X_RF_REGION_APPLICATION_ID IN NUMBER,
111 X_RF_REGION_CODE IN VARCHAR2,
112 X_RF_TAG IN VARCHAR2,
113 X_CREATED_BY IN NUMBER,
114 X_CREATION_DATE IN DATE,
115 X_LAST_UPDATED_BY IN NUMBER,
116 X_LAST_UPDATE_DATE IN DATE,
117 X_LAST_UPDATE_LOGIN IN NUMBER,
118 X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
119 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
120 X_ERRORCODE OUT NOCOPY NUMBER
121 );
122
123 PROCEDURE update_criteria_template_rf
124 (
125 X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
126 X_CUSTOMIZATION_CODE IN VARCHAR2,
127 X_REGION_APPLICATION_ID IN NUMBER,
128 X_REGION_CODE IN VARCHAR2,
129 X_RF_CUSTOMIZATION_APPL_ID IN NUMBER,
130 X_RF_CUSTOMIZATION_CODE IN VARCHAR2,
131 X_RF_REGION_APPLICATION_ID IN NUMBER,
132 X_RF_REGION_CODE IN VARCHAR2,
133 X_RF_TAG IN VARCHAR2,
134 X_LAST_UPDATED_BY IN NUMBER,
135 X_LAST_UPDATE_DATE IN DATE,
136 X_LAST_UPDATE_LOGIN IN NUMBER,
137 X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
138 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
139 X_ERRORCODE OUT NOCOPY NUMBER
140 );
141
142 PROCEDURE delete_criteria_template_rf
143 (
144 X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
145 X_CUSTOMIZATION_CODE IN VARCHAR2,
146 X_REGION_APPLICATION_ID IN NUMBER,
147 X_REGION_CODE IN VARCHAR2,
148 X_RF_TAG IN VARCHAR2,
149 X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
150 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
151 X_ERRORCODE OUT NOCOPY NUMBER
152 );
153
154 ---------------------------------------------------------
155
156 PROCEDURE create_result_format
157 (
158 X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
159 X_CUSTOMIZATION_CODE IN VARCHAR2,
160 X_REGION_APPLICATION_ID IN NUMBER,
161 X_REGION_CODE IN VARCHAR2,
162 X_NAME IN VARCHAR2,
163 X_DESCRIPTION IN VARCHAR2,
164 X_NUM_ROWS_DISPLAYED IN NUMBER,
165 X_DEFAULT_RESULT_FLAG IN VARCHAR2,
166 X_SITE_ID IN NUMBER,
167 X_WEB_USER_ID IN NUMBER,
168 X_CUSTOMIZATION_LEVEL_ID IN NUMBER,
169 X_IMPORT_FLAG IN VARCHAR2 DEFAULT NULL,
170 X_DATA_LEVEL IN VARCHAR2 DEFAULT NULL,
171 X_CREATED_BY IN NUMBER,
172 X_CREATION_DATE IN DATE,
173 X_LAST_UPDATED_BY IN NUMBER,
174 X_LAST_UPDATE_DATE IN DATE,
175 X_LAST_UPDATE_LOGIN IN NUMBER,
176 X_CLASSIFICATION_1 IN VARCHAR2 DEFAULT NULL,
177 X_CLASSIFICATION_2 IN VARCHAR2 DEFAULT NULL,
178 X_CLASSIFICATION_3 IN VARCHAR2 DEFAULT NULL,
179 X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
180 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
181 X_ERRORCODE OUT NOCOPY NUMBER
182 );
183
184 PROCEDURE update_result_format
185 (
186 X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
187 X_CUSTOMIZATION_CODE IN VARCHAR2,
188 X_REGION_APPLICATION_ID IN NUMBER,
189 X_REGION_CODE IN VARCHAR2,
190 X_NAME IN VARCHAR2,
191 X_DESCRIPTION IN VARCHAR2,
192 X_NUM_ROWS_DISPLAYED IN NUMBER,
193 X_DEFAULT_RESULT_FLAG IN VARCHAR2,
194 X_SITE_ID IN NUMBER,
195 X_WEB_USER_ID IN NUMBER,
196 X_CUSTOMIZATION_LEVEL_ID IN NUMBER,
197 X_IMPORT_FLAG IN VARCHAR2 DEFAULT NULL,
198 X_DATA_LEVEL IN VARCHAR2 DEFAULT NULL, --Bug 6011948
199 X_LAST_UPDATED_BY IN NUMBER,
200 X_LAST_UPDATE_DATE IN DATE,
201 X_LAST_UPDATE_LOGIN IN NUMBER,
202 X_CLASSIFICATION_1 IN VARCHAR2 DEFAULT NULL,
203 X_CLASSIFICATION_2 IN VARCHAR2 DEFAULT NULL,
204 X_CLASSIFICATION_3 IN VARCHAR2 DEFAULT NULL,
205 X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
206 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
207 X_ERRORCODE OUT NOCOPY NUMBER
208 );
209
210 PROCEDURE delete_result_format
211 (
212 X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
213 X_CUSTOMIZATION_CODE IN VARCHAR2,
214 X_REGION_APPLICATION_ID IN NUMBER,
215 X_REGION_CODE IN VARCHAR2,
216 X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
217 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
218 X_ERRORCODE OUT NOCOPY NUMBER
219 );
220
221 PROCEDURE translate_result_format
222 ( p_customization_application_id IN NUMBER
223 ,p_customization_code IN VARCHAR2
224 ,p_region_application_id IN NUMBER
225 ,p_region_code IN VARCHAR2
226 ,p_last_update_date IN VARCHAR2
227 ,p_last_updated_by IN NUMBER
228 ,p_name IN VARCHAR2
229 ,p_description IN VARCHAR2
230 ,x_return_status OUT NOCOPY VARCHAR2
231 ,x_msg_data OUT NOCOPY VARCHAR2
232 );
233
234 ---------------------------------------------------------
235
236 PROCEDURE create_result_column
237 (
238 X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
239 X_CUSTOMIZATION_CODE IN VARCHAR2,
240 X_REGION_APPLICATION_ID IN NUMBER,
241 X_REGION_CODE IN VARCHAR2,
242 X_ATTRIBUTE_APPLICATION_ID IN NUMBER,
243 X_ATTRIBUTE_CODE IN VARCHAR2,
244 X_DISPLAY_SEQUENCE IN NUMBER,
245 X_ORDER_SEQUENCE IN NUMBER,
246 X_ORDER_DIRECTION IN VARCHAR2,
247 X_COLUMN_NAME IN VARCHAR2 := NULL,
248 X_SHOW_TOTAL IN VARCHAR2 := NULL,
249 X_CREATED_BY IN NUMBER,
250 X_CREATION_DATE IN DATE,
251 X_LAST_UPDATED_BY IN NUMBER,
252 X_LAST_UPDATE_DATE IN DATE,
253 X_LAST_UPDATE_LOGIN IN NUMBER,
254 X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
255 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
256 X_ERRORCODE OUT NOCOPY NUMBER
257 );
258
259 PROCEDURE update_result_column
260 (
261 X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
262 X_CUSTOMIZATION_CODE IN VARCHAR2,
263 X_REGION_APPLICATION_ID IN NUMBER,
264 X_REGION_CODE IN VARCHAR2,
265 X_ATTRIBUTE_APPLICATION_ID IN NUMBER,
266 X_ATTRIBUTE_CODE IN VARCHAR2,
267 X_DISPLAY_SEQUENCE IN NUMBER,
268 X_ORDER_SEQUENCE IN NUMBER,
269 X_ORDER_DIRECTION IN VARCHAR2,
270 X_COLUMN_NAME IN VARCHAR2 := NULL,
271 X_SHOW_TOTAL IN VARCHAR2 := NULL,
272 X_LAST_UPDATED_BY IN NUMBER,
273 X_LAST_UPDATE_DATE IN DATE,
274 X_LAST_UPDATE_LOGIN IN NUMBER,
275 X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
276 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
277 X_ERRORCODE OUT NOCOPY NUMBER
278 );
279
280 PROCEDURE delete_result_column
281 (
282 X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
283 X_CUSTOMIZATION_CODE IN VARCHAR2,
284 X_REGION_APPLICATION_ID IN NUMBER,
285 X_REGION_CODE IN VARCHAR2,
286 X_ATTRIBUTE_APPLICATION_ID IN NUMBER,
287 X_ATTRIBUTE_CODE IN VARCHAR2,
288 X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
289 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
290 X_ERRORCODE OUT NOCOPY NUMBER
291 );
292
293 ---------------------------------------------------------
294
295 PROCEDURE insert_criterion
296 (
297 X_ROWID IN OUT NOCOPY VARCHAR2,
298 X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
299 X_CUSTOMIZATION_CODE IN VARCHAR2,
300 X_REGION_APPLICATION_ID IN NUMBER,
301 X_REGION_CODE IN VARCHAR2,
302 X_ATTRIBUTE_APPLICATION_ID IN NUMBER,
303 X_ATTRIBUTE_CODE IN VARCHAR2,
304 X_SEQUENCE_NUMBER IN NUMBER,
305 X_OPERATION IN VARCHAR2,
306 X_VALUE_VARCHAR2 IN VARCHAR2,
307 X_SECOND_VALUE_VARCHAR2 IN VARCHAR2,
308 X_VALUE_NUMBER IN NUMBER,
309 X_SECOND_VALUE_NUMBER IN NUMBER,
313 X_CREATION_DATE IN DATE,
310 X_VALUE_DATE IN DATE,
311 X_SECOND_VALUE_DATE IN DATE,
312 X_CREATED_BY IN NUMBER,
314 X_LAST_UPDATED_BY IN NUMBER,
315 X_LAST_UPDATE_DATE IN DATE,
316 X_LAST_UPDATE_LOGIN IN NUMBER,
317 X_START_DATE_ACTIVE IN DATE,
318 X_END_DATE_ACTIVE IN DATE,
319 X_USE_KEYWORD_SEARCH IN VARCHAR2 := 'Y',
320 X_MATCH_CONDITION IN VARCHAR2 := 'ALL',
321 X_FUZZY IN VARCHAR2 := 'N',
322 X_STEMMING IN VARCHAR2 := 'N',
323 X_SYNONYMS IN VARCHAR2 := 'N',
324 X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
325 );
326
327 PROCEDURE update_criterion
328 (
329 X_ROWID IN OUT NOCOPY VARCHAR2,
330 X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
331 X_CUSTOMIZATION_CODE IN VARCHAR2,
332 X_REGION_APPLICATION_ID IN NUMBER,
333 X_REGION_CODE IN VARCHAR2,
334 X_ATTRIBUTE_APPLICATION_ID IN NUMBER,
335 X_ATTRIBUTE_CODE IN VARCHAR2,
336 X_SEQUENCE_NUMBER IN NUMBER,
337 X_OPERATION IN VARCHAR2,
338 X_VALUE_VARCHAR2 IN VARCHAR2,
339 X_SECOND_VALUE_VARCHAR2 IN VARCHAR2,
340 X_VALUE_NUMBER IN NUMBER,
341 X_SECOND_VALUE_NUMBER IN NUMBER,
342 X_VALUE_DATE IN DATE,
343 X_SECOND_VALUE_DATE IN DATE,
344 X_LAST_UPDATED_BY IN NUMBER,
345 X_LAST_UPDATE_DATE IN DATE,
346 X_LAST_UPDATE_LOGIN IN NUMBER,
347 X_START_DATE_ACTIVE IN DATE,
348 X_END_DATE_ACTIVE IN DATE,
349 X_USE_KEYWORD_SEARCH IN VARCHAR2 := 'Y',
350 X_MATCH_CONDITION IN VARCHAR2 := 'ALL',
351 X_FUZZY IN VARCHAR2 := 'N',
352 X_STEMMING IN VARCHAR2 := 'N',
353 X_SYNONYMS IN VARCHAR2 := 'N',
354 X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
355 );
356
357 PROCEDURE delete_criterion
358 (
359 X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
360 X_CUSTOMIZATION_CODE IN VARCHAR2,
361 X_REGION_APPLICATION_ID IN NUMBER,
362 X_REGION_CODE IN VARCHAR2,
363 X_ATTRIBUTE_APPLICATION_ID IN NUMBER,
364 X_ATTRIBUTE_CODE IN VARCHAR2,
365 X_SEQUENCE_NUMBER IN NUMBER,
366 X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
367 );
368
369 PROCEDURE create_result_section
370 (
371 X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
372 X_CUSTOMIZATION_CODE IN VARCHAR2,
373 X_REGION_APPLICATION_ID IN NUMBER,
374 X_REGION_CODE IN VARCHAR2,
375 X_ATTRIBUTE_APPLICATION_ID IN NUMBER,
376 X_ATTRIBUTE_CODE IN VARCHAR2,
377 X_DISPLAY_SEQUENCE IN NUMBER,
378 X_CREATED_BY IN NUMBER,
379 X_CREATION_DATE IN DATE,
380 X_LAST_UPDATED_BY IN NUMBER,
381 X_LAST_UPDATE_DATE IN DATE,
382 X_LAST_UPDATE_LOGIN IN NUMBER,
383 X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
384 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
385 X_ERRORCODE OUT NOCOPY NUMBER
386 );
387
388 PROCEDURE update_result_section
389 (
390 X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
391 X_CUSTOMIZATION_CODE IN VARCHAR2,
392 X_REGION_APPLICATION_ID IN NUMBER,
393 X_REGION_CODE IN VARCHAR2,
394 X_ATTRIBUTE_APPLICATION_ID IN NUMBER,
395 X_ATTRIBUTE_CODE IN VARCHAR2,
396 X_DISPLAY_SEQUENCE IN NUMBER,
397 X_LAST_UPDATED_BY IN NUMBER,
398 X_LAST_UPDATE_DATE IN DATE,
399 X_LAST_UPDATE_LOGIN IN NUMBER,
400 X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
401 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
402 X_ERRORCODE OUT NOCOPY NUMBER
403 );
404
405 PROCEDURE delete_result_section
406 (
407 X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
408 X_CUSTOMIZATION_CODE IN VARCHAR2,
409 X_REGION_APPLICATION_ID IN NUMBER,
410 X_REGION_CODE IN VARCHAR2,
411 X_ATTRIBUTE_APPLICATION_ID IN NUMBER,
412 X_ATTRIBUTE_CODE IN VARCHAR2,
413 X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
414 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
415 X_ERRORCODE OUT NOCOPY NUMBER
416 );
417
418 PROCEDURE Check_Result_Format_Deletion
419 (
420 X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
421 X_CUSTOMIZATION_CODE IN VARCHAR2,
422 X_REGION_APPLICATION_ID IN NUMBER,
423 X_REGION_CODE IN VARCHAR2,
424 X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
425 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
426 X_ERRORCODE OUT NOCOPY NUMBER
427 );
428
429 END EGO_SEARCH_FWK_PUB;