1 package "DBMS_HS" as
2
3 ----------------------------------------
4 -- Exceptions
5 --
6 miss_base_caps exception;
7 pragma exception_init(miss_base_caps, -24274);
8 miss_base_caps_num number := -24274;
9 miss_base_caps_msg varchar2(76) := 'HS$_BASE_CAPS';
10
11 dupl_base_caps exception;
12 pragma exception_init(dupl_base_caps, -24270);
13 dupl_base_caps_num number := -24270;
14 dupl_base_caps_msg varchar2(76) := 'HS$_BASE_CAPS';
15
16 miss_base_dd exception;
17 pragma exception_init(miss_base_dd, -24274);
18 miss_base_dd_num number := -24274;
19 miss_base_dd_msg varchar2(76) := 'HS$_BASE_DD';
20
21 dupl_base_dd exception;
22 pragma exception_init(dupl_base_dd, -24270);
23 dupl_base_dd_num number := -24270;
24 dupl_base_dd_msg varchar2(76) := 'HS$_BASE_DD';
25
26 miss_class_caps exception;
27 pragma exception_init(miss_class_caps, -24274);
28 miss_class_caps_num number := -24274;
29 miss_class_caps_msg varchar2(76) := 'HS$_CLASS_CAPS';
30
31 dupl_class_caps exception;
32 pragma exception_init(dupl_class_caps, -24270);
33 dupl_class_caps_num number := -24270;
34 dupl_class_caps_msg varchar2(76) := 'HS$_CLASS_CAPS';
35
36 miss_class_dd exception;
37 pragma exception_init(miss_class_dd, -24274);
38 miss_class_dd_num number := -24274;
39 miss_class_dd_msg varchar2(76) := 'HS$_CLASS_DD';
40
41 dupl_class_dd exception;
42 pragma exception_init(dupl_class_dd, -24270);
43 dupl_class_dd_num number := -24270;
44 dupl_class_dd_msg varchar2(76) := 'HS$_CLASS_DD';
45
46 bad_TRANSLATION_TYPE exception;
47 pragma exception_init(bad_TRANSLATION_TYPE, -24271);
48 bad_TRANSLATION_TYPE_num number := -24271;
49 bad_TRANSLATION_TYPE_msg varchar2(76) := 'NULL';
50
51 bad_TRANSLATION_TEXT exception;
52 pragma exception_init(bad_TRANSLATION_TEXT, -24273);
53 bad_TRANSLATION_TEXT_num number := -24273;
54 bad_TRANSLATION_TEXT_msg varchar2(76) := 'NULL';
55
56 miss_class_init exception;
57 pragma exception_init(miss_class_init, -24274);
58 miss_class_init_num number := -24274;
59 miss_class_init_msg varchar2(76) := 'HS$_CLASS_INIT';
60
61 dupl_class_init exception;
62 pragma exception_init(dupl_class_init, -24270);
63 dupl_class_init_num number := -24270;
64 dupl_class_init_msg varchar2(76) := 'HS$_CLASS_INIT';
65
66 bad_INIT_VALUE_TYPE exception;
67 pragma exception_init(bad_INIT_VALUE_TYPE, -24272);
68 bad_INIT_VALUE_TYPE_num number := -24272;
69 bad_INIT_VALUE_TYPE_msg varchar2(76) := 'NULL';
70
71 miss_fds_class exception;
72 pragma exception_init(miss_fds_class, -24274);
73 miss_fds_class_num number := -24274;
74 miss_fds_class_msg varchar2(76) := 'HS$_FDS_CLASS';
75
76 dupl_fds_class exception;
77 pragma exception_init(dupl_fds_class, -24270);
78 dupl_fds_class_num number := -24270;
79 dupl_fds_class_msg varchar2(76) := 'HS$_FDS_CLASS';
80
81 miss_fds_inst exception;
82 pragma exception_init(miss_fds_inst, -24274);
83 miss_fds_inst_num number := -24274;
84 miss_fds_inst_msg varchar2(76) := 'HS$_FDS_INST';
85
86 dupl_fds_inst exception;
87 pragma exception_init(dupl_fds_inst, -24270);
88 dupl_fds_inst_num number := -24270;
89 dupl_fds_inst_msg varchar2(76) := 'HS$_FDS_INST';
90
91 miss_inst_caps exception;
92 pragma exception_init(miss_inst_caps, -24274);
93 miss_inst_caps_num number := -24274;
94 miss_inst_caps_msg varchar2(76) := 'HS$_INST_CAPS';
95
96 dupl_inst_caps exception;
97 pragma exception_init(dupl_inst_caps, -24270);
98 dupl_inst_caps_num number := -24270;
99 dupl_inst_caps_msg varchar2(76) := 'HS$_INST_CAPS';
100
101 miss_inst_dd exception;
102 pragma exception_init(miss_inst_dd, -24274);
103 miss_inst_dd_num number := -24274;
104 miss_inst_dd_msg varchar2(76) := 'HS$_INST_DD';
105
106 dupl_inst_dd exception;
107 pragma exception_init(dupl_inst_dd, -24270);
108 dupl_inst_dd_num number := -24270;
109 dupl_inst_dd_msg varchar2(76) := 'HS$_INST_DD';
110
111 miss_inst_init exception;
112 pragma exception_init(miss_inst_init, -24274);
113 miss_inst_init_num number := -24274;
114 miss_inst_init_msg varchar2(76) := 'HS$_INST_INIT';
115
116 dupl_inst_init exception;
117 pragma exception_init(dupl_inst_init, -24270);
118 dupl_inst_init_num number := -24270;
119 dupl_inst_init_msg varchar2(76) := 'HS$_INST_INIT';
120 --------------------------------
121 -- Public procedures
122 --
123
124 --------------------------------
125 -- create_base_caps procedure
126 --
127 -- This procedure creates a row in the HS$_BASE_CAPS table.
128 --
129
130 procedure create_base_caps(
131 CAP_NUMBER in NUMBER,
132 CAP_DESCRIPTION in VARCHAR2 := null);
133
134 --------------------------------
135 -- create_base_dd procedure
136 --
137 -- This procedure creates a row in the HS$_BASE_DD table.
138 --
139
140 procedure create_base_dd(
141 DD_TABLE_NAME in VARCHAR2,
142 DD_TABLE_DESC in VARCHAR2 := null);
143
144 --------------------------------
145 -- create_class_caps procedure
146 --
147 -- This procedure creates a row in the HS$_CLASS_CAPS table.
148 -- The FDS_CLASS_NAME must be exist in the HS$_FDS_CLASS table.
149 -- The CAP_NUMBER must be defined in the HS$_BASE_CAPS table.
150
151 procedure create_class_caps(
152 FDS_CLASS_NAME in VARCHAR2,
153 CAP_NUMBER in NUMBER,
154 CONTEXT in NUMBER := null,
155 TRANSLATION in VARCHAR2 := null,
156 ADDITIONAL_INFO in NUMBER := null);
157
158 --------------------------------
159 -- create_class_dd procedure
160 --
161 -- This procedure creates a row in the HS$_CLASS_DD table.
162 -- The FDS_CLASS_NAME must exist in the HS$_FDS_CLASS table.
163 -- The DD_TABLE_NAME must exist in the HS$_BASE_DD table.
164 -- TRANSLATION_TYPE must be either 'T' (translated) or 'M'
165 -- (mimicked). If TRANSLATION_TYPE = 'T' then the TRANSLATION_TEXT
166 -- string must be supplied.
167
168 procedure create_class_dd(
169 FDS_CLASS_NAME in VARCHAR2,
170 DD_TABLE_NAME in VARCHAR2,
171 TRANSLATION_TYPE in CHAR,
172 TRANSLATION_TEXT in VARCHAR2 := null);
173
174 --------------------------------
175 -- create_class_init procedure
176 --
177 -- This procedure creates a row in the HS$_CLASS_INIT table.
178 -- The FDS_CLASS_NAME must exist in the HS$_FDS_CLASS table.
179 -- The INIT_VALUE_TYPE must either 'F' (environment variable) or
180 -- 'M' (not an environment variable).
181
182 procedure create_class_init(
183 FDS_CLASS_NAME in VARCHAR2,
184 INIT_VALUE_NAME in VARCHAR2,
185 INIT_VALUE in VARCHAR2,
186 INIT_VALUE_TYPE in VARCHAR2);
187
188 --------------------------------
189 -- create_fds_class procedure
190 --
191 -- This procedure creates a row in the HS$_FDS_CLASS table.
192
193 procedure create_fds_class(
194 FDS_CLASS_NAME in VARCHAR2,
195 FDS_CLASS_COMMENTS in VARCHAR2 := null);
196
197 --------------------------------
198 -- create_fds_inst procedure
199 --
200 -- This procedure creates a row in the HS$_FDS_INST table.
201 -- The FDS_CLASS_NAME must exist in the HS$_FDS_CLASS table.
202
203 procedure create_fds_inst(
204 FDS_INST_NAME in VARCHAR2,
205 FDS_CLASS_NAME in VARCHAR2,
206 FDS_INST_COMMENTS in VARCHAR2 := null);
207
208 --------------------------------
209 -- create_inst_caps procedure
210 --
211 -- This procedure creates a row in the HS$_INST_CAPS table.
212 -- The FDS_INST_NAME must exist in the HS$_FDS_INST table and
213 -- be defined for the row in HS$_FDS_CLASS specified by the FDS_CLASS_NAME
214 -- row. The CAP_NUMBER must be defined in the HS$_BASE_CAPS table.
215
216 procedure create_inst_caps(
217 FDS_INST_NAME in VARCHAR2,
218 FDS_CLASS_NAME in VARCHAR2,
219 CAP_NUMBER in NUMBER,
220 CONTEXT in NUMBER := null,
221 TRANSLATION in VARCHAR2 := null,
222 ADDITIONAL_INFO in NUMBER := null);
223
224 --------------------------------
225 -- create_inst_dd procedure
226 --
227 -- This procedure creates a row in the HS$_INST_DD table.
228 -- The FDS_INST_NAME must be defined in the HS$_FDS_INST table and
229 -- must belong to the FDS_CLASS specified by the HS$_FDS_CLASS
230 -- parameter. The DD_TABLE_NAME must be defined in the HS$_BASE_DD
231 -- table. TRANSLATION_TYPE must be either 'T' (translated) or 'M'
232 -- (mimicked). If TRANSLATION_TYPE is 'T', then TRANSLATION_TEXT
233 -- must be supplied.
234
235 procedure create_inst_dd(
236 FDS_INST_NAME in VARCHAR2,
237 FDS_CLASS_NAME in VARCHAR2,
238 DD_TABLE_NAME in VARCHAR2,
239 TRANSLATION_TYPE in CHAR,
240 TRANSLATION_TEXT in VARCHAR2 := null);
241
242 --------------------------------
243 -- create_inst_init procedure
244 --
245 -- This procedure creates a row in the HS$_INST_INIT table.
246 -- The FDS_INST_NAME must exist in the HS$_FDS_INST table and
247 -- must be exist in the HS$_FDS_CLASS table as specified by
248 -- the FDS_CLASS_NAME parameter. The INIT_VALUE_TYPE must
249 -- be defined either 'F' or 'T'.
250
251 procedure create_inst_init(
252 FDS_INST_NAME in VARCHAR2,
253 FDS_CLASS_NAME in VARCHAR2,
254 INIT_VALUE_NAME in VARCHAR2,
255 INIT_VALUE in VARCHAR2,
256 INIT_VALUE_TYPE in VARCHAR2);
257
258 --------------------------------
259 -- drop_base_caps procedure
260 --
261 -- This procedure drops a row from the HS$_BASE_CAPS table as specified
262 -- by the CAP_NUMBER parameter.
263
264 procedure drop_base_caps(
265 CAP_NUMBER in NUMBER);
266
267 --------------------------------
268 -- drop_base_dd procedure
269 --
270 -- drops a row from the HS$_BASE_DD table as specified by table_name.
271
272 procedure drop_base_dd(
273 DD_TABLE_NAME in VARCHAR2);
274
275 --------------------------------
276 -- drop_class_caps procedure
277 --
278 -- This procedure deletes a row from the HS$_CLASS_CAPS table
279 -- as specified by the FDS_CLASS_NAME and CAP_NUMBER.
280
281 procedure drop_class_caps(
282 FDS_CLASS_NAME in VARCHAR2,
283 CAP_NUMBER in NUMBER);
284
285 --------------------------------
286 -- drop_class_dd procedure
287 --
288 -- Deletes row in HS$_CLASS_DD specified by FDS_CLASS_NAME and DD_TABLE_NAME
289
290 procedure drop_class_dd(
291 FDS_CLASS_NAME in VARCHAR2,
292 DD_TABLE_NAME in VARCHAR2);
293
294 --------------------------------
295 -- drop_class_init procedure
296 --
297 -- Drops row in HS$_CLASS_INIT as specified by FDS_CLASS_NAME and
298 -- INIT_VALUE_NAME.
299
300 procedure drop_class_init(
301 FDS_CLASS_NAME in VARCHAR2,
302 INIT_VALUE_NAME in VARCHAR2);
303
304 --------------------------------
305 -- drop_fds_class procedure
306 --
307 -- Drops row in HS$_FDS_CLASS as specified by FDS_CLASS_NAME;
308
309 procedure drop_fds_class(
310 FDS_CLASS_NAME in VARCHAR2);
311
312 --------------------------------
313 -- drop_fds_inst procedure
314 --
315 -- Drops row in HS$_FDS_INST table as specified by FDS_INST_NAME
316 -- and FDS_CLASS_NAME.
317
318 procedure drop_fds_inst(
319 FDS_INST_NAME in VARCHAR2,
320 FDS_CLASS_NAME in VARCHAR2);
321
322 --------------------------------
323 -- drop_inst_caps
324 --
325 -- delete rows in HS$_INST_CAPS specified by FDS_INST_NAME, FDS_CLASS_NAME
326 -- and CAP_NUMBER
327
328 procedure drop_inst_caps(
329 FDS_INST_NAME in VARCHAR2,
330 FDS_CLASS_NAME in VARCHAR2,
331 CAP_NUMBER in NUMBER);
332
333 --------------------------------
334 -- drop_inst_dd
335 --
336 -- Drops rows from HS$_INST_DD specified by FDS_INST_NAME, FDS_CLASS_NAME
337 -- and DD_TABLE_NAME.
338
339 procedure drop_inst_dd(
340 FDS_INST_NAME in VARCHAR2,
341 FDS_CLASS_NAME in VARCHAR2,
342 DD_TABLE_NAME in VARCHAR2);
343
344 --------------------------------
345 -- drop_inst_init
346 --
347 -- Drops rows from HS$_INST_INIT table as specified by
348 -- FDS_INST_NAME, FDS_CLASS_NAME, and INIT_VALUE_NAME.
349
350 procedure drop_inst_init(
351 FDS_INST_NAME in VARCHAR2,
352 FDS_CLASS_NAME in VARCHAR2,
353 INIT_VALUE_NAME in VARCHAR2);
354
355 --------------------------------
356 -- alter_base_caps
357 --
358 -- This procedure alters a row in the HS$_BASE_CAPS table.
359
360 procedure alter_base_caps(
361 CAP_NUMBER in NUMBER,
362 new_CAP_NUMBER in NUMBER := -1e-130,
363 new_CAP_DESCRIPTION in VARCHAR2 := '-');
364
365 --------------------------------
366 -- alter_base_dd
367 --
368 -- This procedure alters a row in the HS$_BASE_DD table.
369
370 procedure alter_base_dd(
371 DD_TABLE_NAME in VARCHAR2,
372 new_DD_TABLE_NAME in VARCHAR2 := '-',
373 new_DD_TABLE_DESC in VARCHAR2 := '-');
374
375 --------------------------------
376 -- alter_class_caps
377 --
378 -- This procedure alters the contents of the HS$_CLASS_CAPS table.
379
380 procedure alter_class_caps(
381 FDS_CLASS_NAME in VARCHAR2,
382 CAP_NUMBER in NUMBER,
383 new_FDS_CLASS_NAME in VARCHAR2 := '-',
384 new_CAP_NUMBER in NUMBER := -1e-130,
385 new_CONTEXT in NUMBER := -1e-130,
386 new_TRANSLATION in VARCHAR2 := '-',
387 new_ADDITIONAL_INFO in NUMBER := -1e-130);
388
389 --------------------------------
390 -- alter_class_dd
391 --
392 -- This procedure modifies the contents of the HS$_CLASS_DD table.
393
394 procedure alter_class_dd(
395 FDS_CLASS_NAME in VARCHAR2,
396 DD_TABLE_NAME in VARCHAR2,
397 new_FDS_CLASS_NAME in VARCHAR2 := '-',
398 new_DD_TABLE_NAME in VARCHAR2 := '-',
399 new_TRANSLATION_TYPE in CHAR := '-',
400 new_TRANSLATION_TEXT in VARCHAR2 := '-');
401
402 --------------------------------
403 -- alter_class_init
404 --
405 -- This procedure alters the contents of the HS$_CLASS_INIT table.
406
407 procedure alter_class_init(
408 FDS_CLASS_NAME in VARCHAR2,
409 INIT_VALUE_NAME in VARCHAR2,
410 new_FDS_CLASS_NAME in VARCHAR2 := '-',
411 new_INIT_VALUE_NAME in VARCHAR2 := '-',
412 new_INIT_VALUE in VARCHAR2 := '-',
413 new_INIT_VALUE_TYPE in VARCHAR2 := '-');
414
415 --------------------------------
416 -- alter_fds_class
417 --
418 -- Alters the contents of the HS$_FDS_CLASS table.
419
420 procedure alter_fds_class(
421 FDS_CLASS_NAME in VARCHAR2,
422 new_FDS_CLASS_NAME in VARCHAR2 := '-',
423 new_FDS_CLASS_COMMENTS in VARCHAR2 := '-');
424
425 --------------------------------
426 -- alter_fds_inst
427 --
428 -- Modifies the contents of the HS$_FDS_INST table.
429
430 procedure alter_fds_inst(
431 FDS_INST_NAME in VARCHAR2,
432 FDS_CLASS_NAME in VARCHAR2,
433 new_FDS_INST_NAME in VARCHAR2 := '-',
434 new_FDS_CLASS_NAME in VARCHAR2 := '-',
435 new_FDS_INST_COMMENTS in VARCHAR2 := '-');
436
437 --------------------------------
438 -- alter_inst_caps procedures
439 --
440 -- Modifies the contents of the $HS_INST_CAPS table.
441
442 procedure alter_inst_caps(
443 FDS_INST_NAME in VARCHAR2,
444 FDS_CLASS_NAME in VARCHAR2,
445 CAP_NUMBER in NUMBER,
446 new_FDS_INST_NAME in VARCHAR2 := '-',
450 new_TRANSLATION in VARCHAR2 := '-',
447 new_FDS_CLASS_NAME in VARCHAR2 := '-',
448 new_CAP_NUMBER in NUMBER := -1e-130,
449 new_CONTEXT in NUMBER := -1e-130,
451 new_ADDITIONAL_INFO in NUMBER := -1e-130);
452
453 --------------------------------
454 -- alter_inst_dd
455 --
456 -- Alters the contents of the HS$_INST_DD table.
457
458 procedure alter_inst_dd(
459 FDS_INST_NAME in VARCHAR2,
460 FDS_CLASS_NAME in VARCHAR2,
461 DD_TABLE_NAME in VARCHAR2,
462 new_FDS_INST_NAME in VARCHAR2 := '-',
463 new_FDS_CLASS_NAME in VARCHAR2 := '-',
464 new_DD_TABLE_NAME in VARCHAR2 := '-',
465 new_TRANSLATION_TYPE in CHAR := '-',
466 new_TRANSLATION_TEXT in VARCHAR2 := '-');
467
468 --------------------------------
469 -- alter_inst_init
470 --
471 -- Alters the contents of the HS$_INST_INIT table.
472
473 procedure alter_inst_init(
474 FDS_INST_NAME in VARCHAR2,
475 FDS_CLASS_NAME in VARCHAR2,
476 INIT_VALUE_NAME in VARCHAR2,
477 new_FDS_INST_NAME in VARCHAR2 := '-',
478 new_FDS_CLASS_NAME in VARCHAR2 := '-',
479 new_INIT_VALUE_NAME in VARCHAR2 := '-',
480 new_INIT_VALUE in VARCHAR2 := '-',
481 new_INIT_VALUE_TYPE in VARCHAR2 := '-');
482
483 -------------------------------
484 -- copy_inst
485 --
486 -- copies everything for an HS$_FDS_INST to
487 -- a new inst in the same FDS_CLASS
488
489 procedure copy_inst(FDS_INST_NAME in VARCHAR2,
490 FDS_CLASS_NAME in VARCHAR2,
491 new_FDS_INST_NAME in VARCHAR2,
492 new_FDS_COMMENTS in VARCHAR2 default '-');
493
494 -------------------------------
495 -- copy_class
496 --
497 -- Copies everything for a class to another class
498 procedure copy_class(old_fds_class_name varchar2,
499 new_fds_class_name varchar2,
500 new_fds_class_comments varchar2 default '-');
501
502
503 --------------------------------
504 -- replace_base_caps
505 --
506 -- This procedure creates or replaces a row in the HS$_BASE_CAPS table.
507 -- It will first attempt to update the row in hs$_base_caps. If the row
508 -- does not exist, it will attempt to insert the row.
509 -- The new_CAP_NUMBER parameter is ignored if the row specified by
510 -- CAP_NUMBER does not exist.
511
512 procedure replace_base_caps(
513 CAP_NUMBER in NUMBER,
514 new_CAP_NUMBER in NUMBER := null,
515 new_CAP_DESCRIPTION in VARCHAR2 := null);
516
517 --------------------------------
518 -- replace_base_dd
519 --
520 -- This procedure does a create or replace on a row in the HS$_BASE_DD
521 -- table. First, this procedure will attempt to update the row. If
522 -- the row does not exist, it is inserted.
523 -- The new_DD_TABLE_NAME parameter is ignored if the row does not
524 -- exist.
525
526 procedure replace_base_dd(
527 DD_TABLE_NAME in VARCHAR2,
528 new_DD_TABLE_NAME in VARCHAR2 := null,
529 new_DD_TABLE_DESC in VARCHAR2 := null);
530
531 --------------------------------
532 -- replace_class_caps
533 --
534 -- This procedure does a 'create or replace' on the HS$_CLASS_CAPS table.
535 -- If a row exists for the FDS_CLASS_NAME and CAP_NUMBER, it is updated.
536 -- If a row does not exist, it is inserted.
537 -- If a row does not exist, the new_FDS_CLASS_NAME and new_CAP_NUMBER
538 -- parameters are ignored.
539
540 procedure replace_class_caps(
541 FDS_CLASS_NAME in VARCHAR2,
542 CAP_NUMBER in NUMBER,
543 new_FDS_CLASS_NAME in VARCHAR2 := NULL,
544 new_CAP_NUMBER in NUMBER := null,
545 new_CONTEXT in NUMBER := NULL,
546 new_TRANSLATION in VARCHAR2 := NULL,
547 new_ADDITIONAL_INFO in NUMBER := NULL);
548
549 --------------------------------
550 -- replace_class_dd
551 --
552 -- This procedure performs a 'create or replace' on the HS$_CLASS_DD table.
553 -- If a row exists for the FDS_CLASS_NAME and DD_TABLE_NAME then the row
554 -- is updated. If a row does not exist, it is inserted.
555 -- If a row does not exist, the new_FDS_CLASS_NAME and new_DD_TABLE_NAME
556 -- parameters are ignored.
557
558 procedure replace_class_dd(
559 FDS_CLASS_NAME in VARCHAR2,
560 DD_TABLE_NAME in VARCHAR2,
561 new_FDS_CLASS_NAME in VARCHAR2 := NULL,
562 new_DD_TABLE_NAME in VARCHAR2 := NULL,
563 new_TRANSLATION_TYPE in CHAR := NULL,
564 new_TRANSLATION_TEXT in VARCHAR2 := NULL);
565
566 --------------------------------
567 -- replace_class_init
568 --
569 -- This procedure will create or update a row in the HS$_CLASS_INIT table.
570 -- If a row exists with the specified FDS_CLASS_NAME and INIT_VALUE_NAME,
571 -- it will be updated. If the row does not exist, it is inserted. If
572 -- the row does not exist, new_FDS_CLASS_NAME and new_INIT_VALUE_NAME
573 -- parameters are ignored.
574
575 procedure replace_class_init(
576 FDS_CLASS_NAME in VARCHAR2,
577 INIT_VALUE_NAME in VARCHAR2,
578 new_FDS_CLASS_NAME in VARCHAR2 := NULL,
579 new_INIT_VALUE_NAME in VARCHAR2 := NULL,
580 new_INIT_VALUE in VARCHAR2 := NULL,
584 -- replace_fds_class
581 new_INIT_VALUE_TYPE in VARCHAR2 := NULL);
582
583 --------------------------------
585 --
586 -- This procedure does create or replace operations on the
587 -- HS$_FDS_CLASS table. If a row exists for the FDS_CLASS_NAME,
588 -- it is updated. If no row exists, it is created. If no row exists,
589 -- the new_FDS_CLASS_NAME parameter is ignored.
590
591 procedure replace_fds_class(
592 FDS_CLASS_NAME in VARCHAR2,
593 new_FDS_CLASS_NAME in VARCHAR2 := NULL,
594 new_FDS_CLASS_COMMENTS in VARCHAR2 := NULL);
595
596 --------------------------------
597 -- replace_fds_inst
598 --
599 -- This procedure creates or replaces rows in the HS$_FDS_INST table.
600 -- If a row exists for the FDS_INST_NAME and FDS_CLASS_NAME, it is
601 -- updated. If no row exists, it is created.
602 -- If no row exists, the new_FDS_INST_NAME and new_FDS_CLASS_NAME
603 -- parameters are ignored when performing the insert.
604
605 procedure replace_fds_inst(
606 FDS_INST_NAME in VARCHAR2,
607 FDS_CLASS_NAME in VARCHAR2,
608 new_FDS_INST_NAME in VARCHAR2 := NULL,
609 new_FDS_CLASS_NAME in VARCHAR2 := NULL,
610 new_FDS_INST_COMMENTS in VARCHAR2 := NULL);
611
612 --------------------------------
613 -- replace_inst_caps
614 --
615 -- This procedure does a create or replace on the HS$_INST_CAPS table.
616 -- If no row exists for the FDS_INST_NAME, FDS_CLASS_NAME and CAP_NUMBER,
617 -- the row is created.
618 -- If a row exists, it is updated.
619 -- In the case where an insert is performed, the new_FDS_INST_NAME,
620 -- new_FDS_CLASS_NAME and new_CLASS_NUMBER parameters are ignored.
621
622 procedure replace_inst_caps(
623 FDS_INST_NAME in VARCHAR2,
624 FDS_CLASS_NAME in VARCHAR2,
625 CAP_NUMBER in NUMBER,
626 new_FDS_INST_NAME in VARCHAR2 := NULL,
627 new_FDS_CLASS_NAME in VARCHAR2 := NULL,
628 new_CAP_NUMBER in NUMBER := NULL,
629 new_CONTEXT in NUMBER := NULL,
630 new_TRANSLATION in VARCHAR2 := NULL,
631 new_ADDITIONAL_INFO in NUMBER := NULL);
632
633 --------------------------------
634 -- replace_inst_dd
635 --
636 -- This procedure performs a create or replace operation on the
637 -- HS$_INST_DD table. If a row exists for the FDS_INST_NAME,
638 -- FDS_CLASS_NAME and DD_TABLE_NAME, it is updated. If no row
639 -- exists, it is created and the new_FDS_INST_NAME, new_FDS_CLASS_NAME,
640 -- and new_DD_TABLE_NAME values are ignored.
641
642 procedure replace_inst_dd(
643 FDS_INST_NAME in VARCHAR2,
644 FDS_CLASS_NAME in VARCHAR2,
645 DD_TABLE_NAME in VARCHAR2,
646 new_FDS_INST_NAME in VARCHAR2 := NULL,
647 new_FDS_CLASS_NAME in VARCHAR2 := NULL,
648 new_DD_TABLE_NAME in VARCHAR2 := NULL,
649 new_TRANSLATION_TYPE in CHAR := NULL,
650 new_TRANSLATION_TEXT in VARCHAR2 := NULL);
651
652 --------------------------------
653 -- replace_inst_init
654 --
655 -- This procedure performs a create or replace on the HS$_INST_INIT table.
656 -- If a row exists with the FDS_INST_NAME, FDS_CLASS_NAME and
657 -- and INIT_VALUE_NAME, it is updated. If a row does not exist, it is
658 -- created. In the creation case, the new_FDS_INST_NAME, new_FDS_CLASS_NAME
659 -- and new_INIT_VALUE_NAME are ignored.
660
661 procedure replace_inst_init(
662 FDS_INST_NAME in VARCHAR2,
663 FDS_CLASS_NAME in VARCHAR2,
664 INIT_VALUE_NAME in VARCHAR2,
665 new_FDS_INST_NAME in VARCHAR2 := NULL,
666 new_FDS_CLASS_NAME in VARCHAR2 := NULL,
667 new_INIT_VALUE_NAME in VARCHAR2 := NULL,
668 new_INIT_VALUE in VARCHAR2 := NULL,
669 new_INIT_VALUE_TYPE in VARCHAR2 := NULL);
670
671 end "DBMS_HS";