DBA Data[Home] [Help]

PACKAGE: CTXSYS.DRITHSL

Source


1 PACKAGE drithsl AS
2 
3 /*---------------------------- create_thesaurus ---------------------------*/
4 /*
5   NAME
6     create_thesaurus
7 
8   DESCRIPTION
9     specialized version of drithsc.create_thesaurus for thesaurus loader
10 */
11 
12 FUNCTION create_thesaurus (tname in varchar2, casesens in boolean)
13 return NUMBER;
14 
15 /*---------------------------- create_phrase ---------------------------*/
16 /*
17    NAME
18      create_phrase
19 
20    DESCRIPTION
21      Specialized version of drithsc.create_phrase for thesaurus loader
22 */
23 
24 function create_phrase (
25   tid    in number,
26   tcs    in boolean,
27   phrase in varchar2,
28   rel    in varchar2 default null,
29   relid  in number   default null
30 ) return number;
31 
32 /*------------------------------- dump_thesaurus -------------------------*/
33 /*
34   NAME
35     dump_thesaurus
36 
37   DESCRIPTION
38     Specialized version of drithsd.dump_thesaurus for thesaurus loader
39 */
40 
41 PROCEDURE dump_thesaurus (
42   tname in varchar2
43 );
44 
45 /*------------------------------- next_dump_line -------------------------*/
46 /*
47   NAME
48     next_dump_line
49 
50   DESCRIPTION
51     Specialized version of drithsd.next_dump_line for thesaurus loader
52 */
53 FUNCTION next_dump_line RETURN VARCHAR2;
54 
55 /*------------------------------- allocate_ids  -------------------------*/
56 /*
57   NAME
58     allocate_ids
59 
60   DESCRIPTION
61     allocate a list of thes ids and return the starting number of that list
62 
63   ARGUMENTS
64     numalloc  (IN)  -- number of thesaurus id to be allocated
65     start_id  (OUT) -- start id of the list of thesaurus id
66 */
67 PROCEDURE allocate_ids (
68   numalloc  in  number,
69   start_id  out number
70 );
71 PRAGMA SUPPLEMENTAL_LOG_DATA(allocate_ids, AUTO);
72 
73 /*------------------------------- insert_phrase -------------------------*/
74 PROCEDURE insert_phrase(
75   phr_id        in  number,
76   phr_thsid     in  number,
77   phr_phrase    in  varchar2,
78   phr_qualify   in  varchar2,
79   phr_note      in  varchar2,
80   phr_ringid    in  number
81 );
82 PRAGMA SUPPLEMENTAL_LOG_DATA(insert_phrase, AUTO);
83 
84 PROCEDURE insert_bt(
85   ths_thp_id  in number,
86   ths_type    in varchar2,
87   ths_bt      in number
88 );
89 PRAGMA SUPPLEMENTAL_LOG_DATA(insert_bt, AUTO);
90 
91 PROCEDURE insert_fphrase(
92   phr_thp_id    in number,
93   phr_phrase    in varchar2,
94   phr_type      in varchar2
95 );
96 PRAGMA SUPPLEMENTAL_LOG_DATA(insert_fphrase, AUTO);
97 
98 PROCEDURE update_phrase(
99   phr_thp_id   in number,
100   phr_note     in varchar2
101 );
102 PRAGMA SUPPLEMENTAL_LOG_DATA(update_phrase, AUTO);
103 
104 FUNCTION get_thsid_byname(
105   thsname   in    varchar2
106 )
107 return number;
108 
109 end drithsl;