1 PACKAGE outln_edit_pkg AUTHID CURRENT_USER as
2
3 --
4 -- NAME - create_edit_tables
5 --
6 -- DESCRIPTION
7 -- Create outline editing tables in calling user's schema.
8 --
9 -- USAGE NOTES
10 --
11 PROCEDURE create_edit_tables;
12
13 --
14 -- NAME - drop_edit_tables
15 --
16 -- DESCRIPTION
17 -- drop outline editing tables in calling user's schema.
18 --
19 -- USAGE NOTES
20 --
21 PROCEDURE drop_edit_tables;
22
23 --
24 -- NAME: refresh_private_outline
25 --
26 -- DESCRIPTION:
27 -- Refresh the in-memory copy of the outline, synchronizing
28 -- its data with the edits made to the outline hints.
29 --
30 -- PARAMETERS
31 --
32 -- name - Name of the private outline to be refreshed
33 --
34 -- USAGE NOTES:
35 -- 1. If the private outline specified by the user is not found then an
36 -- Ora-20001 error is raised to alert the user of this.
37 --
38 PROCEDURE refresh_private_outline(name IN VARCHAR2);
39
40 --
41 -- NAME: change_join_pos
42 --
43 -- DESCRIPTION:
44 -- Change the join position for the hint identified by outline name
45 -- and hint number to the position specified by newpos.
46 --
47 -- PARAMETERS
48 --
49 -- name - Name of the private outline to be modified
50 -- hintno - hint number to be modified
51 -- newpos - new join position for the target hint
52 --
53 -- USAGE NOTES:
54 --
55 PROCEDURE CHANGE_JOIN_POS(name VARCHAR2, hintno NUMBER, newpos NUMBER);
56
57 PROCEDURE generate_signature(sqltxt IN VARCHAR2, signature OUT RAW);
58
59 END;