1 package cs_kb_ctx_pkg AUTHID DEFINER as
2 /* $Header: cskbdsts.pls 120.2 2010/12/29 10:03:09 isugavan ship $ */
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 --12.1.3
12 procedure Get_Composite_Attach_Elements(
13 p_rowid IN ROWID, p_clob IN OUT NOCOPY CLOB
14 );
15 --12.1.3
16
17 -- Used for statement Text index user-datastore.
18 -- Outputs the indexable content for a statement
19 procedure Build_Elements(
20 p_rowid IN ROWID, p_clob IN OUT NOCOPY CLOB
21 );
22
23 -- Synthesizes content from a solution and its statements,
24 -- categories, products, platforms, and other attributes
25 -- into a single CLOB
26 procedure Synthesize_Solution_Content
27 ( p_solution_id IN NUMBER,
28 p_lang IN VARCHAR2,
29 p_clob IN OUT NOCOPY CLOB);
30
31
32 --Start 12.1.3
33 -- Synthesizes content from a solution and its statements,
34 -- categories, products, platforms, and other attributes
35 -- into a single CLOB
36 procedure Synthesize_Sol_Attach_Content
37 ( p_solution_id IN NUMBER,
38 p_lang IN VARCHAR2,
39 p_clob IN OUT NOCOPY CLOB);
40
41 --End 12.1.3
42
43 -- Synthesizes content of a statement, including its summary
44 -- and description into a single CLOB
45 -- procedure Synthesize_Statement_Content
46 -- ( p_statement_id IN NUMBER,
47 -- p_lang IN VARCHAR2,
48 -- p_clob IN OUT NOCOPY CLOB);
49
50
51
52 -- Remove_Tags:
53 -- - enable indexing of words between tags
54 -- - replaces all occurrences of '<' with '!'
55 -- p_text: the original varchar
56 -- returns: the modified varchar
57 function Remove_Tags
58 ( p_text IN VARCHAR2)
59 return VARCHAR2;
60
61 -- Remove_Tags_Clob:
62 -- - enable indexing of words between tags
63 -- - replaces all occurrences of '<' with '!'
64 -- p_clob: the original data
65 -- p_temp_clob: if necessary, modified data is stored here
66 -- returns: pointer to either p_clob or p_temp_clob
67 function Remove_Tags_Clob
68 ( p_clob IN CLOB,
69 p_temp_clob IN OUT NOCOPY CLOB
70 )
71 RETURN CLOB;
72
73 end cs_kb_ctx_pkg;
[Home] [Help]