[Home] [Help]
PACKAGE: APPS.HZ_DSS_GROUPS_PUB
Source
1 PACKAGE HZ_DSS_GROUPS_PUB AUTHID CURRENT_USER AS
2 /*$Header: ARHPDSSS.pls 115.4 2003/01/08 07:15:00 jypandey noship $ */
3
4 --------------------------------------
5 -- declaration of record types
6 --------------------------------------
7
8 TYPE dss_group_rec_type IS RECORD (
9 dss_group_code hz_dss_groups_b.dss_group_code%TYPE,
10 order_before_group_code hz_dss_groups_b.dss_group_code%TYPE,
11 bes_enable_flag hz_dss_groups_b.bes_enable_flag%TYPE DEFAULT 'N',
12 status hz_dss_groups_b.status%TYPE DEFAULT 'A',
13 dss_group_name hz_dss_groups_tl.dss_group_name%TYPE,
14 description hz_dss_groups_tl.description%TYPE
15 );
16
17
18 TYPE dss_secured_class_type IS RECORD (
19 secured_item_id hz_dss_criteria.secured_item_id%TYPE,
20 dss_group_code hz_dss_criteria.dss_group_code%TYPE,
21 class_category hz_class_categories.class_category%TYPE,
22 class_code hz_code_assignments.class_code%TYPE,
23 status hz_dss_criteria.status%TYPE DEFAULT 'A'
24 );
25
26
27 TYPE dss_secured_rel_type IS RECORD (
28 secured_item_id hz_dss_criteria.secured_item_id%TYPE,
29 dss_group_code hz_dss_criteria.dss_group_code%TYPE,
30 relationship_type_id hz_relationship_types.relationship_type_id%TYPE,
31 status hz_dss_criteria.status%TYPE DEFAULT 'A'
32 );
33
34 --Bug 2624549
35 TYPE dss_secured_module_type IS RECORD (
36 secured_item_id hz_dss_criteria.secured_item_id%TYPE,
37 dss_group_code hz_dss_criteria.dss_group_code%TYPE,
38 created_by_module hz_dss_criteria.owner_table_id2%TYPE,
39 status hz_dss_criteria.status%TYPE DEFAULT 'A'
40 );
41
42
43 TYPE dss_assignment_type IS RECORD (
44 dss_group_code hz_dss_groups_b.dss_group_code%TYPE,
45 assignment_id hz_dss_assignments.dss_group_code%TYPE,
46 owner_table_name hz_dss_assignments.owner_table_name%TYPE,
47 owner_table_id1 hz_dss_assignments.owner_table_id1%TYPE,
48 owner_table_id2 hz_dss_assignments.owner_table_id2%TYPE,
49 owner_table_id3 hz_dss_assignments.owner_table_id3%TYPE,
50 owner_table_id4 hz_dss_assignments.owner_table_id4%TYPE,
51 owner_table_id5 hz_dss_assignments.owner_table_id5%TYPE,
52 status hz_dss_assignments.status%TYPE DEFAULT 'A'
53
54 );
55
56 TYPE dss_secured_entity_type IS RECORD (
57 dss_group_code hz_dss_groups_b.dss_group_code%TYPE,
58 entity_id hz_dss_entities.entity_id%TYPE,
59 status hz_dss_groups_b.status%TYPE DEFAULT 'A'
60 );
61
62
63 TYPE dss_secured_criterion_type IS RECORD (
64 secured_item_id hz_dss_criteria.secured_item_id%TYPE,
65 dss_group_code hz_dss_criteria.dss_group_code%TYPE,
66 owner_table_name hz_dss_criteria.owner_table_name%TYPE,
67 owner_table_id1 hz_dss_criteria.owner_table_id1%TYPE,
68 owner_table_id2 hz_dss_criteria.owner_table_id2%TYPE,
69 owner_table_id3 hz_dss_criteria.owner_table_id3%TYPE,
70 owner_table_id4 hz_dss_criteria.owner_table_id4%TYPE,
71 owner_table_id5 hz_dss_criteria.owner_table_id5%TYPE,
72 status hz_dss_criteria.status%TYPE DEFAULT 'A'
73 );
74
75
76
77
78 ------------------------------------
79 -- declaration of procedures
80 ------------------------------------
81
82 PROCEDURE create_group (
83 -- input parameters
84 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
85 p_dss_group IN dss_group_rec_type,
86 -- output parameters
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2
90 );
91
92 PROCEDURE update_group (
93 -- input parameters
94 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
95 p_dss_group IN dss_group_rec_type,
96 -- in/out parameters
97 x_object_version_number IN OUT NOCOPY NUMBER,
98 -- output parameters
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER,
101 x_msg_data OUT NOCOPY VARCHAR2
102 );
103
104
105 PROCEDURE create_secured_criterion (
106 -- input parameters
107 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
108 p_dss_secured_criterion IN dss_secured_criterion_type,
109 -- output parameters
110 x_secured_item_id OUT NOCOPY NUMBER,
111 x_return_status OUT NOCOPY VARCHAR2,
112 x_msg_count OUT NOCOPY NUMBER,
113 x_msg_data OUT NOCOPY VARCHAR2
114 );
115
116
117 --Bug 2624549
118 PROCEDURE create_secured_module (
119 -- input parameters
120 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
121 p_dss_secured_module IN dss_secured_module_type,
122 -- output parameters
123 x_secured_item_id OUT NOCOPY NUMBER,
124 x_return_status OUT NOCOPY VARCHAR2,
125 x_msg_count OUT NOCOPY NUMBER,
126 x_msg_data OUT NOCOPY VARCHAR2
127 );
128
129 --Bug 2624549
130 PROCEDURE update_secured_module (
131 -- input parameters
132 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
133 p_dss_secured_module IN dss_secured_module_type,
134 -- in/out parameters
135 x_object_version_number IN OUT NOCOPY NUMBER,
136 -- output parameters
137 x_return_status OUT NOCOPY VARCHAR2,
138 x_msg_count OUT NOCOPY NUMBER,
139 x_msg_data OUT NOCOPY VARCHAR2
140 );
141
142
143 PROCEDURE create_secured_classification (
144 -- input parameters
145 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
146 p_dss_secured_class IN dss_secured_class_type,
147 -- output parameters
148 x_secured_item_id OUT NOCOPY NUMBER,
149 x_return_status OUT NOCOPY VARCHAR2,
150 x_msg_count OUT NOCOPY NUMBER,
151 x_msg_data OUT NOCOPY VARCHAR2
152 );
153
154 PROCEDURE update_secured_criterion (
155 -- input parameters
156 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
157 p_dss_secured_criterion IN dss_secured_criterion_type,
158 -- in/out parameters
159 x_object_version_number IN OUT NOCOPY NUMBER,
160 -- output parameters
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_msg_count OUT NOCOPY NUMBER,
163 x_msg_data OUT NOCOPY VARCHAR2
164 );
165
166 PROCEDURE update_secured_classification (
167 -- input parameters
168 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
169 p_dss_secured_class IN dss_secured_class_type,
170 -- in/out parameters
171 x_object_version_number IN OUT NOCOPY NUMBER,
172 -- output parameters
173 x_return_status OUT NOCOPY VARCHAR2,
174 x_msg_count OUT NOCOPY NUMBER,
175 x_msg_data OUT NOCOPY VARCHAR2
176 );
177
178
179 PROCEDURE create_secured_rel_type (
180 -- input parameters
181 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
182 p_dss_secured_rel_type IN dss_secured_rel_type,
183 -- output parameters
184 x_secured_item_id OUT NOCOPY NUMBER,
185 x_return_status OUT NOCOPY VARCHAR2,
186 x_msg_count OUT NOCOPY NUMBER,
187 x_msg_data OUT NOCOPY VARCHAR2
188 );
189
190
191
192 PROCEDURE update_secured_rel_type (
193 -- input parameters
194 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
195 p_dss_secured_rel_type IN dss_secured_rel_type,
196 -- in/out parameters
197 x_object_version_number IN OUT NOCOPY NUMBER,
198 -- output parameters
199 x_return_status OUT NOCOPY VARCHAR2,
200 x_msg_count OUT NOCOPY NUMBER,
201 x_msg_data OUT NOCOPY VARCHAR2
202 );
203
204
205 PROCEDURE create_assignment (
206 -- input parameters
207 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
208 p_dss_assignment IN dss_assignment_type,
209 -- output parameters
210 x_assignment_id OUT NOCOPY NUMBER,
211 x_return_status OUT NOCOPY VARCHAR2,
212 x_msg_count OUT NOCOPY NUMBER,
213 x_msg_data OUT NOCOPY VARCHAR2
214 );
215
216
217 PROCEDURE delete_assignment (
218 -- input parameters
219 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
220 p_assignment_id IN NUMBER,
221 -- output parameters
222 x_return_status OUT NOCOPY VARCHAR2,
223 x_msg_count OUT NOCOPY NUMBER,
224 x_msg_data OUT NOCOPY VARCHAR2
225 );
226
227
228 PROCEDURE create_secured_entity (
229 -- input parameters
230 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
231 p_dss_secured_entity IN dss_secured_entity_type,
232 -- output parameters
233 x_dss_instance_set_id OUT NOCOPY NUMBER,
234 x_return_status OUT NOCOPY VARCHAR2,
235 x_msg_count OUT NOCOPY NUMBER,
236 x_msg_data OUT NOCOPY VARCHAR2
237 );
238
239
240 PROCEDURE update_secured_entity (
241 -- input parameters
242 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
243 p_dss_secured_entity IN dss_secured_entity_type,
244 -- in/out parameters
245 x_object_version_number IN OUT NOCOPY NUMBER,
246 -- output parameters
247 x_return_status OUT NOCOPY VARCHAR2,
248 x_msg_count OUT NOCOPY NUMBER,
249 x_msg_data OUT NOCOPY VARCHAR2
250 );
251
252 END HZ_DSS_GROUPS_PUB ;