[Home] [Help]
PACKAGE: APPS.IGI_SLS_OBJECTS_PKG
Source
1 PACKAGE igi_sls_objects_pkg AUTHID CURRENT_USER AS
2 -- $Header: igislsos.pls 120.6.12020000.1 2012/06/27 11:21:32 appldev ship $
3
4 PROCEDURE write_to_log(p_level IN NUMBER,p_path IN VARCHAR2, p_mesg IN VARCHAR2);
5
6 PROCEDURE create_sls_tab(sls_tab IN VARCHAR2,
7 schema_name IN VARCHAR2,
8 errbuf OUT NOCOPY VARCHAR2,
9 retcode OUT NOCOPY NUMBER);
10
11 PROCEDURE create_sls_inx(sls_tab IN VARCHAR2,
12 errbuf OUT NOCOPY VARCHAR2,
13 retcode OUT NOCOPY NUMBER);
14
15 PROCEDURE create_sls_apps_syn(sls_tab IN VARCHAR2,
16 schema_name IN VARCHAR2,
17 errbuf OUT NOCOPY VARCHAR2,
18 retcode OUT NOCOPY NUMBER);
19
20 PROCEDURE create_sls_mls_syn(sls_tab IN VARCHAR2,
21 mls_schemaname IN VARCHAR2,
22 errbuf OUT NOCOPY VARCHAR2,
23 retcode OUT NOCOPY NUMBER);
24
25 PROCEDURE create_sls_mrc_syn(sls_tab IN VARCHAR2,
26 mrc_schemaname IN VARCHAR2,
27 errbuf OUT NOCOPY VARCHAR2,
28 retcode OUT NOCOPY NUMBER);
29
30
31 PROCEDURE drop_sls_tab (sls_tab IN VARCHAR2,
32 errbuf OUT NOCOPY VARCHAR2,
33 retcode OUT NOCOPY NUMBER);
34
35 PROCEDURE drop_sls_apps_syn(sls_tab IN VARCHAR2,
36 schema_name IN VARCHAR2,
37 errbuf OUT NOCOPY VARCHAR2,
38 retcode OUT NOCOPY NUMBER);
39
40 PROCEDURE drop_sls_mls_syn(sls_tab IN VARCHAR2,
41 mls_schemaname IN VARCHAR2,
42 errbuf OUT NOCOPY VARCHAR2,
43 retcode OUT NOCOPY NUMBER);
44
45 PROCEDURE drop_sls_mrc_syn(sls_tab IN VARCHAR2,
46 mrc_schemaname IN VARCHAR2,
47 errbuf OUT NOCOPY VARCHAR2,
48 retcode OUT NOCOPY NUMBER);
49
50 PROCEDURE create_sls_trg(sls_tab IN VARCHAR2,
51 sec_tab IN VARCHAR2,
52 errbuf OUT NOCOPY VARCHAR2,
53 retcode OUT NOCOPY NUMBER);
54
55 PROCEDURE drop_sls_trg (sls_tab IN VARCHAR2,
56 errbuf OUT NOCOPY VARCHAR2,
57 retcode OUT NOCOPY NUMBER);
58
59
60 PROCEDURE cre_pol_function(sec_tab IN VARCHAR2,
61 sls_tab IN VARCHAR2,
62 errbuf OUT NOCOPY VARCHAR2,
63 retcode OUT NOCOPY NUMBER);
64
65
66 PROCEDURE drop_pol_function(sls_tab IN VARCHAR2,
67 errbuf OUT NOCOPY VARCHAR2,
68 retcode OUT NOCOPY NUMBER);
69
70 PROCEDURE sls_add_pol(object_schema IN VARCHAR2,
71 table_name IN VARCHAR2,
72 policy_name IN VARCHAR2,
73 function_owner IN VARCHAR2,
74 policy_function IN VARCHAR2,
75 statement_types IN VARCHAR2,
76 errbuf OUT NOCOPY VARCHAR2,
77 retcode OUT NOCOPY NUMBER);
78
79 PROCEDURE sls_drop_pol(object_schema IN VARCHAR2,
80 table_name IN VARCHAR2,
81 policy_name IN VARCHAR2,
82 errbuf OUT NOCOPY VARCHAR2,
83 retcode OUT NOCOPY NUMBER);
84
85 PROCEDURE sls_refresh_pol(object_schema IN VARCHAR2,
86 table_name IN VARCHAR2,
87 policy_name IN VARCHAR2,
88 errbuf OUT NOCOPY VARCHAR2,
89 retcode OUT NOCOPY NUMBER);
90
91 PROCEDURE sls_enable_pol(object_schema IN VARCHAR2,
92 table_name IN VARCHAR2,
93 policy_name IN VARCHAR2,
94 enable IN BOOLEAN,
95 errbuf OUT NOCOPY VARCHAR2,
96 retcode OUT NOCOPY NUMBER);
97
98
99 PROCEDURE sls_disable_pol(object_schema IN VARCHAR2,
100 table_name IN VARCHAR2,
101 policy_name IN VARCHAR2,
102 enable IN BOOLEAN,
103 errbuf OUT NOCOPY VARCHAR2,
104 retcode OUT NOCOPY NUMBER);
105
106 PROCEDURE create_sls_col (sec_tab IN VARCHAR,
107 schema_name IN VARCHAR2,
108 errbuf OUT NOCOPY VARCHAR2,
109 retcode OUT NOCOPY NUMBER);
110
111 PROCEDURE create_sls_core_inx
112 (sec_tab IN VARCHAR2,
113 sls_tab IN VARCHAR2,
114 schema_name IN VARCHAR2,
115 errbuf OUT NOCOPY VARCHAR2,
116 retcode OUT NOCOPY NUMBER);
117
118 PROCEDURE drop_sls_col (sec_tab IN VARCHAR,
119 schema_name IN VARCHAR2,
120 errbuf OUT NOCOPY VARCHAR2,
121 retcode OUT NOCOPY NUMBER);
122
123 PROCEDURE create_sls_col_trg
124 (sls_tab IN VARCHAR2,
125 sec_tab IN VARCHAR2,
126 errbuf OUT NOCOPY VARCHAR2,
127 retcode OUT NOCOPY NUMBER);
128
129
130 PROCEDURE cre_ext_col_pol_func(sec_tab IN VARCHAR2,
131 sls_tab IN VARCHAR2,
132 errbuf OUT NOCOPY VARCHAR2,
133 retcode OUT NOCOPY NUMBER);
134
135 END igi_sls_objects_pkg ;