PACKAGE: APPS.IBC_CONTENT_SEARCH_PVT

Source

1 PACKAGE Ibc_Content_Search_Pvt AUTHID CURRENT_USER AS
2 /* $Header: ibcvsrcs.pls 120.0 2005/09/01 21:40 srrangar noship $ */
3 
4 --
5 -- CONSTANTS
6 --
7 
8   G_PKG_NAME  	     CONSTANT VARCHAR2(50) := 'IBC_CONTENT_SEARCH_PVT';
9 
10   -- for return status
11   ERROR_STATUS      CONSTANT NUMBER      := -1;
12   OKAY_STATUS       CONSTANT NUMBER      := 0;
13 
14   G_TRUE    CONSTANT VARCHAR2(1)  := Fnd_Api.G_TRUE;
15   G_FALSE   CONSTANT VARCHAR2(1)  := Fnd_Api.G_FALSE;
16   G_VALID_LEVEL_TYPESOK CONSTANT NUMBER := 50;
17 
18 --
19 -- TYPES AND MISSING CONSTANTS
20 --
21   G_MISS_NUM15          CONSTANT NUMBER(15)  := -9E14;
22 
23 
24 ------------------< Global Constants >-----------------------
25   G_POSITIVE_ASSOC   CONSTANT NUMBER(5)   := 1;
26   G_NEGATIVE_ASSOC   CONSTANT NUMBER(5)   := -1;
27 
28   /* default increment for count */
29   G_COUNT_INCR       CONSTANT NUMBER(5)   := 1;
30   G_COUNT_INIT       CONSTANT NUMBER(5)   := 1;
31 
32   /* for different Search options */
33 
34   MATCH_ALL          CONSTANT NUMBER(5)   := 0;
35   MATCH_ANY          CONSTANT NUMBER(5)   := 1;
36   FUZZY              CONSTANT NUMBER(5)   := 2;
37   INTERMEDIA_SYNTAX  CONSTANT NUMBER(5)   := 3;
38   THEME_BASED        CONSTANT NUMBER(5)   := 4;
39   MATCH_ACCUM        CONSTANT NUMBER(5)   := 5;
40   -- "6" is reserved for match by id at java level
41   MATCH_PHRASE       CONSTANT NUMBER(5)   := 7;
42 
43 --
44 -- TYPES AND MISSING CONSTANTS
45 -- (All types are defined in PUB package)
46 --
47 
48   /* for input query strings */
49   TYPE varchar21990_tbl_type IS TABLE OF VARCHAR2(1990);
50 
51   /* for input ids */
52   TYPE number15_tbl_type IS TABLE OF NUMBER(15);
53 
54   /* weakly typed cursor for dynamic sql */
55   TYPE general_csr_type IS REF CURSOR;
56 
57 ----------------<End of Constants>--------------------
58 --
59 -- Procedures and Functions
60 --
61 
62 --
63 -- Utility functions
64 --
65 FUNCTION Build_Simple_Text_Query
66   (
67     p_qry_string IN VARCHAR2,
68     p_search_option IN NUMBER
69   )
70   RETURN VARCHAR2;
71 
72 
73 FUNCTION Build_Keyword_Query
74   (
75     p_string        IN VARCHAR2,
76     p_search_option IN NUMBER
77   )
78   RETURN VARCHAR2;
79 
80 END Ibc_Content_Search_Pvt;