1 PACKAGE IGS_SC_DATA_SEC_APIS_PKG AS
2 /* $Header: IGSSC02S.pls 120.3 2005/07/18 22:57:05 appldev ship $ */
3
4 /******************************************************************
5
6 Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA
7 All rights reserved.
8
9 Created By : Don Shellito
10
11 Date Created By : April 8, 2003
12
13 Purpose : This package is to be used for the processing and
14 gathering of the security process for Oracle
15 Student System.
16
17 remarks : None
18
19 Change History
20
21 Who When What
22 -----------------------------------------------------------
23 Don Shellito 08-Apr-2003 New Package created.
24 prbhardw Jul 18, 2005 Added one more parameter in Update_Grant_Cond
25 to update condition number
26
27 ******************************************************************/
28
29 -- -----------------------------------------------------------------
30 -- APIs for the inserting of data into security data model framework
31 -- -----------------------------------------------------------------
32 PROCEDURE Insert_Grant (p_api_version IN NUMBER,
33 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
34 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
35 p_grant_id IN OUT NOCOPY igs_sc_grants.grant_id%TYPE,
36 p_function_id IN igs_sc_grants.function_id%TYPE,
37 p_user_group_id IN igs_sc_grants.user_group_id%TYPE,
38 p_obj_group_id IN igs_sc_grants.obj_group_id%TYPE,
39 p_grant_name IN igs_sc_grants.grant_name%TYPE,
40 p_grant_text IN igs_sc_grants.grant_text%TYPE,
41 p_grant_select_flag IN igs_sc_grants.grant_select_flag%TYPE DEFAULT 'N',
42 p_grant_insert_flag IN igs_sc_grants.grant_insert_flag%TYPE DEFAULT 'N',
43 p_grant_update_flag IN igs_sc_grants.grant_update_flag%TYPE DEFAULT 'N',
44 p_grant_delete_flag IN igs_sc_grants.grant_delete_flag%TYPE DEFAULT 'N',
45 x_return_status OUT NOCOPY VARCHAR2,
46 x_return_message OUT NOCOPY VARCHAR2
47 );
48
49 PROCEDURE Insert_Grant_Cond (p_api_version IN NUMBER,
50 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
51 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
52 p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,
53 p_obj_attrib_id IN igs_sc_grant_conds.obj_attrib_id%TYPE,
54 p_user_attrib_id IN igs_sc_grant_conds.user_attrib_id%TYPE,
55 p_condition IN igs_sc_grant_conds.condition%TYPE,
56 p_text_value IN igs_sc_grant_conds.text_value%TYPE,
57 p_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE,
58 x_return_status OUT NOCOPY VARCHAR2,
59 x_return_message OUT NOCOPY VARCHAR2
60 );
61
62 PROCEDURE Insert_Object_Group (p_api_version IN NUMBER,
63 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
64 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
65 p_obj_group_id IN OUT NOCOPY igs_sc_obj_groups.obj_group_id%TYPE,
66 p_obj_group_name IN igs_sc_obj_groups.obj_group_name%TYPE ,
67 p_default_policy_type IN igs_sc_obj_groups.default_policy_type%TYPE,
68 x_return_status OUT NOCOPY VARCHAR2,
69 x_return_message OUT NOCOPY VARCHAR2
70 );
71
72 PROCEDURE Insert_Object_Attr (p_api_version IN NUMBER,
73 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
74 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
75 p_obj_attrib_id IN OUT NOCOPY igs_sc_obj_attribs.obj_attrib_id%TYPE,
76 p_obj_group_id IN igs_sc_obj_attribs.obj_group_id%TYPE,
77 p_obj_attrib_name IN igs_sc_obj_attribs.obj_attrib_name%TYPE,
78 p_active_flag IN VARCHAR2 DEFAULT 'Y',
79 x_return_status OUT NOCOPY VARCHAR2,
80 x_return_message OUT NOCOPY VARCHAR2
81 );
82
83 PROCEDURE Insert_Object_Attr_Method (p_api_version IN NUMBER,
84 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
85 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
86 p_object_id IN igs_sc_obj_att_mths.object_id%TYPE,
87 p_obj_attrib_id IN igs_sc_obj_att_mths.obj_attrib_id%TYPE,
88 p_obj_attrib_type IN igs_sc_obj_att_mths.obj_attrib_type%TYPE,
89 p_static_type IN igs_sc_obj_att_mths.static_type%TYPE,
90 p_select_text IN igs_sc_obj_att_mths.select_text%TYPE,
91 p_null_allow_flag IN VARCHAR2 DEFAULT 'N',
92 p_call_from_lct IN VARCHAR2 DEFAULT 'N',
93 x_return_status OUT NOCOPY VARCHAR2,
94 x_return_message OUT NOCOPY VARCHAR2);
95
96 PROCEDURE Insert_Object_Func (p_api_version IN NUMBER,
97 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
98 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
99 p_function_id IN OUT NOCOPY igs_sc_obj_functns.function_id%TYPE,
100 p_obj_group_id IN igs_sc_obj_functns.obj_group_id%TYPE,
101 p_function_name IN igs_sc_obj_functns.function_name%TYPE,
102 x_return_status OUT NOCOPY VARCHAR2,
103 x_return_message OUT NOCOPY VARCHAR2
104 );
105
106 PROCEDURE Insert_Object (p_api_version IN NUMBER,
107 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
108 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
109 p_object_id IN OUT NOCOPY igs_sc_objects.object_id%TYPE,
110 p_obj_group_id IN igs_sc_objects.obj_group_id%TYPE,
111 p_obj_name IN fnd_objects.obj_name%TYPE ,
112 p_database_object_name IN fnd_objects.database_object_name%TYPE ,
113 p_pk1_column_name IN fnd_objects.pk1_column_name%TYPE ,
114 p_pk2_column_name IN fnd_objects.pk2_column_name%TYPE ,
115 p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,
116 p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,
117 p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,
118 p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,
119 p_pk2_column_type IN fnd_objects.pk2_column_type%TYPE ,
120 p_pk3_column_type IN fnd_objects.pk3_column_type%TYPE ,
121 p_pk4_column_type IN fnd_objects.pk4_column_type%TYPE ,
122 p_pk5_column_type IN fnd_objects.pk5_column_type%TYPE ,
123 p_select_flag IN VARCHAR2 DEFAULT 'Y',
124 p_insert_flag IN VARCHAR2 DEFAULT 'Y',
125 p_update_flag IN VARCHAR2 DEFAULT 'Y',
126 p_delete_flag IN VARCHAR2 DEFAULT 'Y',
127 p_enforce_par_sec_flag IN VARCHAR2 DEFAULT 'N',
128 p_active_flag IN VARCHAR2 DEFAULT 'Y',
129 x_return_status OUT NOCOPY VARCHAR2,
130 x_return_message OUT NOCOPY VARCHAR2
131 );
132
133
134 PROCEDURE Insert_User_Attr (p_api_version IN NUMBER,
135 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
136 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
137 p_user_attrib_id IN OUT NOCOPY igs_sc_usr_attribs.user_attrib_id%TYPE,
138 p_user_attrib_name IN igs_sc_usr_attribs.user_attrib_name%TYPE,
139 p_user_attrib_type IN igs_sc_usr_attribs.user_attrib_type%TYPE,
140 p_static_type IN igs_sc_usr_attribs.static_type%TYPE,
141 p_select_text IN igs_sc_usr_attribs.select_text%TYPE,
142 p_active_flag IN VARCHAR2 DEFAULT 'Y',
143 x_return_status OUT NOCOPY VARCHAR2,
144 x_return_message OUT NOCOPY VARCHAR2
145 );
146
147 PROCEDURE Insert_Local_Role (
148 p_api_version IN NUMBER,
149 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
150 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
151 p_role_name IN VARCHAR2,
152 p_role_display_name IN VARCHAR2,
153 p_orig_system IN VARCHAR2,
154 p_orig_system_id IN NUMBER,
155 p_language IN VARCHAR2 DEFAULT NULL,
156 p_territory IN VARCHAR2 DEFAULT NULL,
157 p_role_description IN VARCHAR2 DEFAULT NULL,
158 p_notification_preference IN VARCHAR2 DEFAULT 'MAILHTML',
159 p_email_address IN VARCHAR2 DEFAULT NULL,
160 p_fax IN VARCHAR2 DEFAULT NULL,
161 p_status IN VARCHAR2 DEFAULT 'ACTIVE',
162 p_expiration_date IN DATE DEFAULT NULL,
163 p_start_date IN DATE DEFAULT SYSDATE,
164 x_return_status OUT NOCOPY VARCHAR2,
165 x_return_message OUT NOCOPY VARCHAR2
166 ) ;
167
168 PROCEDURE Insert_Local_User_Role (p_api_version IN NUMBER,
169 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
170 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
171 p_user_name IN wf_local_user_roles.user_name%TYPE,
172 p_role_name IN wf_local_user_roles.role_name%TYPE,
173 p_user_orig_system IN wf_local_user_roles.user_orig_system%TYPE,
174 p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,
175 p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,
176 p_role_orig_system_id IN wf_local_user_roles.role_orig_system_id%TYPE,
177 p_start_date IN wf_local_user_roles.start_date%TYPE,
178 p_expiration_date IN wf_local_user_roles.expiration_date%TYPE,
179 p_security_group_id IN wf_local_user_roles.security_group_id%TYPE,
180 x_return_status OUT NOCOPY VARCHAR2,
181 x_return_message OUT NOCOPY VARCHAR2
182 );
183
184 -- -----------------------------------------------------------------
185 -- APIs for the updating of data into security data model framework
186 -- -----------------------------------------------------------------
187 PROCEDURE Update_Local_Role (p_api_version IN NUMBER,
188 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
189 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
190 p_role_name IN VARCHAR2,
191 p_role_display_name IN VARCHAR2,
192 p_orig_system IN VARCHAR2,
193 p_orig_system_id IN NUMBER,
194 p_language IN VARCHAR2 DEFAULT NULL,
195 p_territory IN VARCHAR2 DEFAULT NULL,
196 p_role_description IN VARCHAR2 DEFAULT NULL,
197 p_notification_preference IN VARCHAR2 DEFAULT 'MAILHTML',
198 p_email_address IN VARCHAR2 DEFAULT NULL,
199 p_fax IN VARCHAR2 DEFAULT NULL,
200 p_status IN VARCHAR2 DEFAULT 'ACTIVE',
201 p_expiration_date IN DATE DEFAULT NULL,
202 p_start_date IN DATE DEFAULT SYSDATE,
203 x_return_status OUT NOCOPY VARCHAR2,
204 x_return_message OUT NOCOPY VARCHAR2
205 );
206
207 PROCEDURE Update_Local_User_Role (p_api_version IN NUMBER,
208 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
209 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
210 p_user_name IN wf_local_user_roles.user_name%TYPE,
211 p_role_name IN wf_local_user_roles.role_name%TYPE,
212 p_user_orig_system IN wf_local_user_roles.user_orig_system%TYPE,
213 p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,
214 p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,
215 p_role_orig_system_id IN wf_local_user_roles.role_orig_system_id%TYPE,
216 p_start_date IN wf_local_user_roles.start_date%TYPE,
217 p_expiration_date IN wf_local_user_roles.expiration_date%TYPE,
218 p_security_group_id IN wf_local_user_roles.security_group_id%TYPE,
219 x_return_status OUT NOCOPY VARCHAR2,
220 x_return_message OUT NOCOPY VARCHAR2
221 );
222
223 PROCEDURE Update_Grant (p_api_version IN NUMBER,
224 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
225 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
226 p_grant_id IN igs_sc_grants.grant_id%TYPE,
227 p_function_id IN igs_sc_grants.function_id%TYPE,
228 p_user_group_id IN igs_sc_grants.user_group_id%TYPE,
229 p_grant_name IN igs_sc_grants.grant_name%TYPE,
230 p_grant_text IN igs_sc_grants.grant_text%TYPE,
231 p_grant_select_flag IN igs_sc_grants.grant_select_flag%TYPE DEFAULT 'N',
232 p_grant_insert_flag IN igs_sc_grants.grant_insert_flag%TYPE DEFAULT 'N',
233 p_grant_update_flag IN igs_sc_grants.grant_update_flag%TYPE DEFAULT 'N',
234 p_grant_delete_flag IN igs_sc_grants.grant_delete_flag%TYPE DEFAULT 'N',
235 x_return_status OUT NOCOPY VARCHAR2,
236 x_return_message OUT NOCOPY VARCHAR2
237 );
238
239 PROCEDURE Update_Grant_Cond (p_api_version IN NUMBER,
240 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
241 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
242 p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,
243 p_obj_attrib_id IN igs_sc_grant_conds.obj_attrib_id%TYPE,
244 p_user_attrib_id IN igs_sc_grant_conds.user_attrib_id%TYPE,
248 p_old_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE DEFAULT 0,
245 p_condition IN igs_sc_grant_conds.condition%TYPE,
246 p_text_value IN igs_sc_grant_conds.text_value%TYPE,
247 p_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE,
249 x_return_status OUT NOCOPY VARCHAR2,
250 x_return_message OUT NOCOPY VARCHAR2
251 );
252
253 PROCEDURE Update_Object_Group (p_api_version IN NUMBER,
254 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
255 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
256 p_obj_group_id IN igs_sc_obj_groups.obj_group_id%TYPE,
257 p_obj_group_name IN igs_sc_obj_groups.obj_group_name%TYPE ,
258 p_default_policy_type IN igs_sc_obj_groups.default_policy_type%TYPE,
259 x_return_status OUT NOCOPY VARCHAR2,
260 x_return_message OUT NOCOPY VARCHAR2
261 );
262
263 PROCEDURE Update_Object_Attr_Method (p_api_version IN NUMBER,
264 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
265 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
266 p_object_id IN igs_sc_obj_att_mths.object_id%TYPE,
267 p_obj_attrib_id IN igs_sc_obj_att_mths.obj_attrib_id%TYPE,
268 p_obj_attrib_type IN igs_sc_obj_att_mths.obj_attrib_type%TYPE,
269 p_static_type IN igs_sc_obj_att_mths.static_type%TYPE,
270 p_select_text IN igs_sc_obj_att_mths.select_text%TYPE,
271 p_null_allow_flag IN VARCHAR2 DEFAULT 'N',
272 p_call_from_lct IN VARCHAR2 DEFAULT 'N',
273 x_return_status OUT NOCOPY VARCHAR2,
274 x_return_message OUT NOCOPY VARCHAR2
275 );
276
277 PROCEDURE Update_Object_Func (p_api_version IN NUMBER,
278 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
279 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
280 p_function_id IN igs_sc_obj_functns.function_id%TYPE,
281 p_obj_group_id IN igs_sc_obj_functns.obj_group_id%TYPE,
282 p_function_name IN igs_sc_obj_functns.function_name%TYPE,
283 x_return_status OUT NOCOPY VARCHAR2,
284 x_return_message OUT NOCOPY VARCHAR2
285 );
286
287 PROCEDURE Update_Object_Attr (p_api_version IN NUMBER,
288 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
289 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
290 p_obj_attrib_id IN igs_sc_obj_attribs.obj_attrib_id%TYPE,
291 p_obj_group_id IN igs_sc_obj_attribs.obj_group_id%TYPE,
292 p_obj_attrib_name IN igs_sc_obj_attribs.obj_attrib_name%TYPE,
293 p_active_flag IN VARCHAR2 DEFAULT 'Y',
294 x_return_status OUT NOCOPY VARCHAR2,
295 x_return_message OUT NOCOPY VARCHAR2
296 );
297
298 PROCEDURE Update_User_Attr (p_api_version IN NUMBER,
299 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
300 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
301 p_user_attrib_id IN igs_sc_usr_attribs.user_attrib_id%TYPE,
302 p_user_attrib_name IN igs_sc_usr_attribs.user_attrib_name%TYPE,
303 p_user_attrib_type IN igs_sc_usr_attribs.user_attrib_type%TYPE,
304 p_static_type IN igs_sc_usr_attribs.static_type%TYPE,
305 p_select_text IN igs_sc_usr_attribs.select_text%TYPE,
306 p_active_flag IN igs_sc_usr_attribs.active_flag%TYPE,
307 x_return_status OUT NOCOPY VARCHAR2,
308 x_return_message OUT NOCOPY VARCHAR2
309 );
310
311 PROCEDURE Update_Object (p_api_version IN NUMBER,
312 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
313 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
314 p_object_id IN igs_sc_objects.object_id%TYPE,
315 p_obj_group_id IN igs_sc_objects.obj_group_id%TYPE,
316 p_obj_name IN fnd_objects.obj_name%TYPE ,
317 p_database_object_name IN fnd_objects.database_object_name%TYPE ,
318 p_pk1_column_name IN fnd_objects.pk1_column_name%TYPE ,
319 p_pk2_column_name IN fnd_objects.pk2_column_name%TYPE ,
320 p_pk3_column_name IN fnd_objects.pk3_column_name%TYPE ,
321 p_pk4_column_name IN fnd_objects.pk4_column_name%TYPE ,
322 p_pk5_column_name IN fnd_objects.pk5_column_name%TYPE ,
323 p_pk1_column_type IN fnd_objects.pk1_column_type%TYPE ,
327 p_pk5_column_type IN fnd_objects.pk5_column_type%TYPE ,
324 p_pk2_column_type IN fnd_objects.pk2_column_type%TYPE ,
325 p_pk3_column_type IN fnd_objects.pk3_column_type%TYPE ,
326 p_pk4_column_type IN fnd_objects.pk4_column_type%TYPE ,
328 p_select_flag IN VARCHAR2 DEFAULT 'Y',
329 p_insert_flag IN VARCHAR2 DEFAULT 'Y',
330 p_update_flag IN VARCHAR2 DEFAULT 'Y',
331 p_delete_flag IN VARCHAR2 DEFAULT 'Y',
332 p_enforce_par_sec_flag IN VARCHAR2 DEFAULT 'N',
333 p_active_flag IN VARCHAR2 DEFAULT 'Y',
334 x_return_status OUT NOCOPY VARCHAR2,
335 x_return_message OUT NOCOPY VARCHAR2
336 );
337 -- -----------------------------------------------------------------
338 -- APIs for the deleting of data into security data model framework
339 -- -----------------------------------------------------------------
340 PROCEDURE Delete_Object_Group (p_api_version IN NUMBER,
341 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
342 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
343 p_obj_group_id IN igs_sc_obj_groups.obj_group_id%TYPE,
344 x_return_status OUT NOCOPY VARCHAR2,
345 x_return_message OUT NOCOPY VARCHAR2
346 );
347
348 PROCEDURE Delete_Object (p_api_version IN NUMBER,
349 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
350 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
351 p_obj_group_id IN igs_sc_objects.obj_group_id%TYPE,
352 p_object_id IN igs_sc_objects.object_id%TYPE,
353 x_return_status OUT NOCOPY VARCHAR2,
354 x_return_message OUT NOCOPY VARCHAR2
355 );
356
357 PROCEDURE Delete_Object_Attr (p_api_version IN NUMBER,
358 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
359 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
360 p_obj_attrib_id IN igs_sc_obj_attribs.obj_attrib_id%TYPE,
361 x_return_status OUT NOCOPY VARCHAR2,
362 x_return_message OUT NOCOPY VARCHAR2
363 );
364
365 PROCEDURE Delete_Object_Attr_Method (p_api_version IN NUMBER,
366 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
367 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
368 p_object_id IN igs_sc_obj_att_mths.object_id%TYPE,
369 p_obj_attrib_id IN igs_sc_obj_att_mths.obj_attrib_id%TYPE,
370 x_return_status OUT NOCOPY VARCHAR2,
371 x_return_message OUT NOCOPY VARCHAR2
372 );
373
374 PROCEDURE Delete_Object_Func (p_api_version IN NUMBER,
375 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
376 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
377 p_function_id IN igs_sc_obj_functns.function_id%TYPE,
378 x_return_status OUT NOCOPY VARCHAR2,
379 x_return_message OUT NOCOPY VARCHAR2
380 );
381
382 PROCEDURE Delete_Object_Attr_Val (p_api_version IN NUMBER,
383 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
384 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
385 p_object_id IN igs_sc_obj_att_mths.object_id%TYPE,
386 p_obj_attrib_id IN igs_sc_obj_att_mths.obj_attrib_id%TYPE,
387 x_return_status OUT NOCOPY VARCHAR2,
388 x_return_message OUT NOCOPY VARCHAR2
389 );
390
391 PROCEDURE Delete_User_Attr (p_api_version IN NUMBER,
392 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
393 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
394 p_user_attrib_id IN igs_sc_usr_attribs.user_attrib_id%TYPE,
395 x_return_status OUT NOCOPY VARCHAR2,
396 x_return_message OUT NOCOPY VARCHAR2
397 );
398
399 PROCEDURE Delete_User_Attr_Val (p_api_version IN NUMBER,
400 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
401 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
402 p_user_attrib_id IN igs_sc_usr_attribs.user_attrib_id%TYPE,
403 p_user_id IN NUMBER,
404 x_return_status OUT NOCOPY VARCHAR2,
405 x_return_message OUT NOCOPY VARCHAR2
406 );
407
408 PROCEDURE Delete_Grant (p_api_version IN NUMBER,
409 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
410 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
411 p_grant_id IN igs_sc_grants.grant_id%TYPE,
415
412 x_return_status OUT NOCOPY VARCHAR2,
413 x_return_message OUT NOCOPY VARCHAR2
414 );
416 PROCEDURE Delete_Grant_Cond (p_api_version IN NUMBER,
417 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
418 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
419 p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,
420 p_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE,
421 x_return_status OUT NOCOPY VARCHAR2,
422 x_return_message OUT NOCOPY VARCHAR2
423 );
424
425 PROCEDURE Delete_Local_Role (p_api_version IN NUMBER,
426 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
427 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
428 x_return_status OUT NOCOPY VARCHAR2,
429 x_return_message OUT NOCOPY VARCHAR2
430 );
431
432 PROCEDURE Delete_Local_User_Role (p_api_version IN NUMBER,
433 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
434 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
435 x_return_status OUT NOCOPY VARCHAR2,
436 x_return_message OUT NOCOPY VARCHAR2
437 );
438 -- -----------------------------------------------------------------
439 -- Other APIs to be used for Security purposes.
440 -- -----------------------------------------------------------------
441 PROCEDURE Lock_Grant (p_api_version IN NUMBER,
442 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
443 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
444 p_grant_id IN igs_sc_grants.grant_id%TYPE,
445 x_return_status OUT NOCOPY VARCHAR2,
446 x_return_message OUT NOCOPY VARCHAR2
447 );
448
449 PROCEDURE Unlock_Grant (p_api_version IN NUMBER,
450 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
451 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
452 p_grant_id IN igs_sc_grants.grant_id%TYPE,
453 x_return_status OUT NOCOPY VARCHAR2,
454 x_return_message OUT NOCOPY VARCHAR2
455 );
456
457 FUNCTION Is_Grant_Locked (p_grant_id IN igs_sc_grants.grant_id%TYPE) RETURN VARCHAR2;
458
459 PROCEDURE Lock_All_Grants(
460 errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
461 retcode OUT NOCOPY NUMBER , -- Request standard return status
462 p_obj_group_id IN igs_sc_obj_groups.obj_group_id%TYPE
463 ) ;
464 PROCEDURE Unlock_All_Grants(
465 errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
466 retcode OUT NOCOPY NUMBER , -- Request standard return status
467 p_obj_group_id IN igs_sc_obj_groups.obj_group_id%TYPE
468 ) ;
469
470 PROCEDURE Populate_User_Attribs(
471 errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
472 retcode OUT NOCOPY NUMBER , -- Request standard return status
473 p_all_attribs IN VARCHAR2
474 ) ;
475
476 PROCEDURE enable_policy (
477 p_database_object_name IN VARCHAR2 );
478
479 PROCEDURE enable_upgrade_mode (
480 p_api_version IN NUMBER,
481 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
482 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
483 p_obj_group_id IN igs_sc_obj_groups.obj_group_id%TYPE,
484 x_return_status OUT NOCOPY VARCHAR2,
485 x_msg_data OUT NOCOPY VARCHAR2
486 );
487
488
489 PROCEDURE change_seq ;
490
491 PROCEDURE Generate_SQL_file(
492 p_api_version IN NUMBER,
493 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
494 p_commit IN VARCHAR2 := FND_API.G_FALSE,
495 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
496 x_return_status OUT NOCOPY VARCHAR2,
497 x_msg_count OUT NOCOPY NUMBER,
498 x_msg_data OUT NOCOPY VARCHAR2,
499 p_dirpath IN VARCHAR2,
500 p_in_file_name IN VARCHAR2,
501 p_out_file_name IN VARCHAR2
502 );
503
504 FUNCTION get_obj_name (
505 p_obj_id IN fnd_objects.object_id%TYPE )
506 RETURN VARCHAR2;
507
508 END IGS_SC_DATA_SEC_APIS_PKG;