1 package ad_dd AUTHID CURRENT_USER as
2 /* $Header: addds.pls 115.5 2004/06/02 08:09:46 sallamse ship $ */
3 procedure register_table
4 (p_appl_short_name in varchar2,
5 p_tab_name in varchar2,
6 p_tab_type in varchar2,
7 p_next_extent in number default 512,
8 p_pct_free in number default 10,
9 p_pct_used in number default 70);
10
11 procedure register_column
12 (p_appl_short_name in varchar2,
13 p_tab_name in varchar2,
14 p_col_name in varchar2,
15 p_col_seq in number,
16 p_col_type in varchar2,
17 p_col_width in number,
18 p_nullable in varchar2,
19 p_translate in varchar2,
20 p_precision in number default null,
21 p_scale in number default null);
22
23 procedure register_primary_key
24 (p_appl_short_name in varchar2,
25 p_key_name in varchar2,
26 p_tab_name in varchar2,
27 p_description in varchar2,
28 p_key_type in varchar2,
29 p_audit_flag in varchar2,
30 p_enabled_flag in varchar2);
31
32 procedure update_primary_key
33 (p_appl_short_name in varchar2,
34 p_key_name in varchar2,
35 p_tab_name in varchar2,
36 p_description in varchar2 default null,
37 p_key_type in varchar2 default null,
38 p_audit_flag in varchar2 default null,
39 p_enabled_flag in varchar2 default null);
40
41 procedure register_primary_key_column
42 (p_appl_short_name in varchar2,
43 p_key_name in varchar2,
44 p_tab_name in varchar2,
45 p_col_name in varchar2,
46 p_col_sequence in number);
47
48 procedure delete_primary_key_column
49 (p_appl_short_name in varchar2,
50 p_key_name in varchar2,
51 p_tab_name in varchar2,
52 p_col_name in varchar2 default null);
53
54
55 procedure delete_table
56 (p_appl_short_name in varchar2,
57 p_tab_name in varchar2);
58
59 procedure delete_column
60 (p_appl_short_name in varchar2,
61 p_tab_name in varchar2,
62 p_col_name in varchar2);
63
64 end ad_dd;
[Home] [Help]