[Home] [Help]
PACKAGE: APPS.HZ_DSS_GRANTS_PUB
Source
1 PACKAGE HZ_DSS_GRANTS_PUB AUTHID CURRENT_USER AS
2 /*$Header: ARHPDSXS.pls 120.2 2005/10/30 04:22:03 appldev noship $ */
3
4
5 --------------------------------------
6 -- declaration of global variables
7 --------------------------------------
8
9 g_dss_admin_create VARCHAR2(30) := 'CREATE'; -- or "copy"
10 g_dss_admin_update VARCHAR2(30) := 'UPDATE';
11 g_dss_admin_grant VARCHAR2(30) := 'GRANT';
12
13
14 --------------------------------------
15 -- declaration of procedures / functions
16 --------------------------------------
17
18 /**
19 * PROCEDURE create_grant
20 *
21 * DESCRIPTION
22 *
23 * Creates a set of Grants to a Data Sharing Group.
24 * This signature matches the UI and corresponds to a "UI Grant Create".
25 *
26 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
27 *
28 * ARGUMENTS
29 *
30 * NOTES
31 *
32 * MODIFICATION HISTORY
33 *
34 * 09-03-2002 Chris Saulit o Created.
35 *
36 */
37
38 PROCEDURE create_grant (
39 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
40 p_dss_group_code IN VARCHAR2,
41 p_dss_grantee_type IN VARCHAR2,
42 p_dss_grantee_key IN VARCHAR2,
43 p_view_flag IN VARCHAR2,
44 p_insert_flag IN VARCHAR2,
45 p_update_flag IN VARCHAR2,
46 p_delete_flag IN VARCHAR2,
47 p_admin_flag IN VARCHAR2,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2
51 );
52
53 /**
54 * PROCEDURE create_grant
55 *
56 * DESCRIPTION
57 *
58 * Creates a set of Grants to a Data Sharing Group.
59 * The procedure is called when a new secured entity is
60 * added to a dss group.
61 *
62 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
63 *
64 * ARGUMENTS
65 *
66 * NOTES
67 *
68 * MODIFICATION HISTORY
69 *
70 * 06-30-2004 Jianying Huang o Created.
71 *
72 */
73
74 PROCEDURE create_grant (
75 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
76 p_dss_group_code IN VARCHAR2,
77 p_dss_instance_set_id IN NUMBER,
78 p_secured_entity_status IN VARCHAR2,
79 x_return_status OUT NOCOPY VARCHAR2,
80 x_msg_count OUT NOCOPY NUMBER,
81 x_msg_data OUT NOCOPY VARCHAR2
82 );
83
84 /**
85 * PROCEDURE update_grant
86 *
87 * DESCRIPTION
88 *
89 * Updates a set of Grants against a Data Sharing Group.
90 * This signature matches the UI and corresponds to a "UI Grant Update".
91 *
92 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
93 *
94 * ARGUMENTS
95 *
96 * NOTES
97 *
98 * MODIFICATION HISTORY
99 *
100 * 09-03-2002 Chris Saulit o Created.
101 *
102 */
103
104 PROCEDURE update_grant (
105 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
106 p_dss_group_code IN VARCHAR2,
107 p_dss_grantee_type IN VARCHAR2,
108 p_dss_grantee_key IN VARCHAR2,
109 p_view_flag IN VARCHAR2,
110 p_insert_flag IN VARCHAR2,
111 p_update_flag IN VARCHAR2,
112 p_delete_flag IN VARCHAR2,
113 p_admin_flag IN VARCHAR2,
114 x_return_status OUT NOCOPY VARCHAR2,
115 x_msg_count OUT NOCOPY NUMBER,
116 x_msg_data OUT NOCOPY VARCHAR2
117 );
118
119
120 /**
121 * PROCEDURE update_grant
122 *
123 * DESCRIPTION
124 *
125 * Updates a set of Grants against a Data Sharing Group.
126 * This procedure is called when a whole DSS group is
127 * disabled/enabled.
128 *
129 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
130 *
131 * ARGUMENTS
132 *
133 * NOTES
134 *
135 * MODIFICATION HISTORY
136 *
137 * 06-29-2004 Jianying Huang o Created.
138 *
139 */
140
141 PROCEDURE update_grant (
142 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
143 p_dss_group_code IN VARCHAR2,
144 p_dss_group_status IN VARCHAR2,
145 x_return_status OUT NOCOPY VARCHAR2,
146 x_msg_count OUT NOCOPY NUMBER,
147 x_msg_data OUT NOCOPY VARCHAR2
148 );
149
150
151 /**
152 * PROCEDURE update_grant
153 *
154 * DESCRIPTION
155 *
156 * Updates a set of Grants against a Data Sharing Group.
157 * This procedure is called when an entity inside a DSS group
158 * is disabled/enabled.
159 *
160 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
161 *
162 * ARGUMENTS
163 *
164 * NOTES
165 *
166 * MODIFICATION HISTORY
167 *
168 * 06-29-2004 Jianying Huang o Created.
169 *
170 */
171
172 PROCEDURE update_grant (
173 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
174 p_dss_group_code IN VARCHAR2,
175 p_dss_instance_set_id IN NUMBER,
176 p_secured_entity_status IN VARCHAR2,
177 x_return_status OUT NOCOPY VARCHAR2,
178 x_msg_count OUT NOCOPY NUMBER,
179 x_msg_data OUT NOCOPY VARCHAR2
180 );
181
182
183 /**
184 * PROCEDURE check_admin_priv
185 *
186 * DESCRIPTION
187 *
188 * Checks whether the current user has sufficient privilege to maintain
189 * a Data Sharing Group.
190 *
191 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
192 *
193 * ARGUMENTS
194 *
195 * NOTES
196 *
197 * MODIFICATION HISTORY
198 *
199 * 09-18-2002 Chris Saulit o Created.
200 *
201 */
202
203 PROCEDURE check_admin_priv (
204 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
205 p_dss_group_code IN VARCHAR2,
206 p_dss_admin_func_code IN VARCHAR2,
207 x_pass_fail_flag OUT NOCOPY VARCHAR2,
208 x_return_status OUT NOCOPY VARCHAR2,
209 x_msg_count OUT NOCOPY NUMBER,
210 x_msg_data OUT NOCOPY VARCHAR2
211 );
212
213
214 /**
215 * FUNCTION check_admin_priv
216 *
217 * DESCRIPTION
218 *
219 * Checks whether the current user has sufficient privilege to maintain
220 * a Data Sharing Group.
221 *
222 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
223 *
224 * ARGUMENTS
225 *
226 * NOTES
227 *
228 * MODIFICATION HISTORY
229 *
230 * 09-18-2002 Chris Saulit o Created.
231 *
232 */
233
234 FUNCTION check_admin_priv (
235 p_dss_group_code IN VARCHAR2,
236 p_dss_admin_func_code IN VARCHAR2
237 ) RETURN VARCHAR2;
238
239
240 END HZ_DSS_GRANTS_PUB;