1 package cs_kb_ctx_pkg AUTHID DEFINER as
2 /* $Header: cskbdsts.pls 120.0 2005/08/16 13:33 alawang noship $ */
3 /* This is the cs_kb_ctx_pkg spec in apps schema*/
4
5 -- Used for solution Text index user-datastore.
6 -- Outputs the indexable content for a solution
7 procedure Get_Composite_Elements(
8 p_rowid IN ROWID, p_clob IN OUT NOCOPY CLOB
9 );
10
11 -- Used for statement Text index user-datastore.
12 -- Outputs the indexable content for a statement
13 procedure Build_Elements(
14 p_rowid IN ROWID, p_clob IN OUT NOCOPY CLOB
15 );
16
17 -- Synthesizes content from a solution and its statements,
18 -- categories, products, platforms, and other attributes
19 -- into a single CLOB
20 procedure Synthesize_Solution_Content
21 ( p_solution_id IN NUMBER,
22 p_lang IN VARCHAR2,
23 p_clob IN OUT NOCOPY CLOB);
24
25 -- Synthesizes content of a statement, including its summary
26 -- and description into a single CLOB
27 -- procedure Synthesize_Statement_Content
28 -- ( p_statement_id IN NUMBER,
29 -- p_lang IN VARCHAR2,
30 -- p_clob IN OUT NOCOPY CLOB);
31
32
33
34 -- Remove_Tags:
35 -- - enable indexing of words between tags
36 -- - replaces all occurrences of '<' with '!'
37 -- p_text: the original varchar
38 -- returns: the modified varchar
39 function Remove_Tags
40 ( p_text IN VARCHAR2)
41 return VARCHAR2;
42
43 -- Remove_Tags_Clob:
44 -- - enable indexing of words between tags
45 -- - replaces all occurrences of '<' with '!'
46 -- p_clob: the original data
47 -- p_temp_clob: if necessary, modified data is stored here
48 -- returns: pointer to either p_clob or p_temp_clob
49 function Remove_Tags_Clob
50 ( p_clob IN CLOB,
51 p_temp_clob IN OUT NOCOPY CLOB
52 )
53 RETURN CLOB;
54
55 end cs_kb_ctx_pkg;