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;