DBA Data[Home] [Help]

PACKAGE: APPS.CS_CTX_PKG

Source


1 PACKAGE CS_CTX_PKG AUTHID CURRENT_USER AS
2 /* $Header: cscuctxs.pls 115.0 99/07/16 08:56:23 porting ship $ */
3 
4  PROCEDURE Get_Context_Stop_Words(stop_word_list OUT VARCHAR2,
5                          policy1 IN VARCHAR2 default NULL,
6                          policy2 IN VARCHAR2 default NULL,
7                          policy3 IN VARCHAR2 default NULL,
8                          policy4 IN VARCHAR2 default NULL);
9 
10 
11  PROCEDURE Clean_Results_Table(results_table IN VARCHAR2,
12 					conid1 	     IN NUMBER DEFAULT 0,
13 					conid2 	     IN NUMBER DEFAULT 0,
14 					conid3 	     IN NUMBER DEFAULT 0,
15 					conid4 	     IN NUMBER DEFAULT 0
16 					);
17 
18  PROCEDURE Update_Context_Index(policy_name IN VARCHAR2,
19 					primary_key IN VARCHAR2
20 					);
21 
22  PROCEDURE Get_Conids(sequence_name IN VARCHAR2,
23 				  no_of_conids  IN NUMBER,
24 				  conid1 	      OUT NUMBER,
25 				  conid2 	      OUT NUMBER,
26 				  conid3 	      OUT NUMBER,
27 				  conid4 	      OUT NUMBER
28 				  );
29 
30  PROCEDURE Search(policy1       IN VARCHAR2,
31                   policy2       IN VARCHAR2,
32                   policy3       IN VARCHAR2,
33                   policy4       IN VARCHAR2,
34 			   stop_words    IN VARCHAR2,
35                   search_string IN VARCHAR2,
36                   search_option IN VARCHAR2,-- 'AND', 'OR', 'EXACT'
37                   results_table IN VARCHAR2,
38                   conid1        IN NUMBER,-- unique id for policy1
39                   conid2        IN NUMBER,-- unique id for policy2
40                   conid3        IN NUMBER,-- unique id for policy3
41                   conid4        IN NUMBER-- unique id for policy4
42                   );
43 
44  PROCEDURE Get_Result_Table(result_table  OUT VARCHAR2);
45 
46  PROCEDURE Release_Result_Table(result_table IN VARCHAR2);
47 
48 END;