[Home] [Help]
PACKAGE: APPS.AMV_USER_PVT_W
Source
1 package amv_user_pvt_w as
2 /* $Header: amvwusrs.pls 120.2 2005/06/30 08:50 appldev ship $ */
3 procedure rosetta_table_copy_in_p31(t out nocopy amv_user_pvt.amv_char_varray_type, a0 JTF_VARCHAR2_TABLE_4000);
4 procedure rosetta_table_copy_out_p31(t amv_user_pvt.amv_char_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_4000);
5
6 procedure rosetta_table_copy_in_p32(t out nocopy amv_user_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);
7 procedure rosetta_table_copy_out_p32(t amv_user_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
8
9 procedure rosetta_table_copy_in_p36(t out nocopy amv_user_pvt.amv_resource_obj_varray, a0 JTF_NUMBER_TABLE
10 , a1 JTF_NUMBER_TABLE
11 , a2 JTF_VARCHAR2_TABLE_100
12 , a3 JTF_VARCHAR2_TABLE_100
13 , a4 JTF_VARCHAR2_TABLE_100
14 );
15 procedure rosetta_table_copy_out_p36(t amv_user_pvt.amv_resource_obj_varray, a0 out nocopy JTF_NUMBER_TABLE
16 , a1 out nocopy JTF_NUMBER_TABLE
17 , a2 out nocopy JTF_VARCHAR2_TABLE_100
18 , a3 out nocopy JTF_VARCHAR2_TABLE_100
19 , a4 out nocopy JTF_VARCHAR2_TABLE_100
20 );
21
22 procedure rosetta_table_copy_in_p38(t out nocopy amv_user_pvt.amv_group_obj_varray, a0 JTF_NUMBER_TABLE
23 , a1 JTF_VARCHAR2_TABLE_100
24 , a2 JTF_NUMBER_TABLE
25 , a3 JTF_VARCHAR2_TABLE_300
26 , a4 JTF_VARCHAR2_TABLE_2000
27 , a5 JTF_DATE_TABLE
28 , a6 JTF_DATE_TABLE
29 );
30 procedure rosetta_table_copy_out_p38(t amv_user_pvt.amv_group_obj_varray, a0 out nocopy JTF_NUMBER_TABLE
31 , a1 out nocopy JTF_VARCHAR2_TABLE_100
32 , a2 out nocopy JTF_NUMBER_TABLE
33 , a3 out nocopy JTF_VARCHAR2_TABLE_300
34 , a4 out nocopy JTF_VARCHAR2_TABLE_2000
35 , a5 out nocopy JTF_DATE_TABLE
36 , a6 out nocopy JTF_DATE_TABLE
37 );
38
39 procedure rosetta_table_copy_in_p40(t out nocopy amv_user_pvt.amv_access_obj_varray, a0 JTF_NUMBER_TABLE
40 , a1 JTF_NUMBER_TABLE
41 , a2 JTF_VARCHAR2_TABLE_100
42 , a3 JTF_NUMBER_TABLE
43 , a4 JTF_NUMBER_TABLE
44 , a5 JTF_VARCHAR2_TABLE_100
45 , a6 JTF_DATE_TABLE
46 , a7 JTF_DATE_TABLE
47 , a8 JTF_VARCHAR2_TABLE_100
48 , a9 JTF_VARCHAR2_TABLE_100
49 , a10 JTF_VARCHAR2_TABLE_100
50 , a11 JTF_VARCHAR2_TABLE_100
51 , a12 JTF_VARCHAR2_TABLE_100
52 , a13 JTF_VARCHAR2_TABLE_100
53 , a14 JTF_VARCHAR2_TABLE_100
54 , a15 JTF_VARCHAR2_TABLE_100
55 );
56 procedure rosetta_table_copy_out_p40(t amv_user_pvt.amv_access_obj_varray, a0 out nocopy JTF_NUMBER_TABLE
57 , a1 out nocopy JTF_NUMBER_TABLE
58 , a2 out nocopy JTF_VARCHAR2_TABLE_100
59 , a3 out nocopy JTF_NUMBER_TABLE
60 , a4 out nocopy JTF_NUMBER_TABLE
61 , a5 out nocopy JTF_VARCHAR2_TABLE_100
62 , a6 out nocopy JTF_DATE_TABLE
63 , a7 out nocopy JTF_DATE_TABLE
64 , a8 out nocopy JTF_VARCHAR2_TABLE_100
65 , a9 out nocopy JTF_VARCHAR2_TABLE_100
66 , a10 out nocopy JTF_VARCHAR2_TABLE_100
67 , a11 out nocopy JTF_VARCHAR2_TABLE_100
68 , a12 out nocopy JTF_VARCHAR2_TABLE_100
69 , a13 out nocopy JTF_VARCHAR2_TABLE_100
70 , a14 out nocopy JTF_VARCHAR2_TABLE_100
71 , a15 out nocopy JTF_VARCHAR2_TABLE_100
72 );
73
74 procedure find_resource(p_api_version NUMBER
75 , p_init_msg_list VARCHAR2
76 , p_validation_level NUMBER
77 , x_return_status out nocopy VARCHAR2
78 , x_msg_count out nocopy NUMBER
79 , x_msg_data out nocopy VARCHAR2
80 , p_check_login_user VARCHAR2
81 , p_group_id NUMBER
82 , p_check_effective_date VARCHAR2
83 , p_user_name VARCHAR2
84 , p_last_name VARCHAR2
85 , p_first_name VARCHAR2
86 , p13_a0 out nocopy NUMBER
87 , p13_a1 out nocopy NUMBER
88 , p13_a2 out nocopy NUMBER
89 , p14_a0 out nocopy JTF_NUMBER_TABLE
90 , p14_a1 out nocopy JTF_NUMBER_TABLE
91 , p14_a2 out nocopy JTF_VARCHAR2_TABLE_100
92 , p14_a3 out nocopy JTF_VARCHAR2_TABLE_100
93 , p14_a4 out nocopy JTF_VARCHAR2_TABLE_100
94 , p12_a0 NUMBER := 0-1962.0724
95 , p12_a1 NUMBER := 0-1962.0724
96 , p12_a2 VARCHAR2 := fnd_api.g_miss_char
97 );
98 procedure find_resource(p_api_version NUMBER
99 , p_init_msg_list VARCHAR2
100 , p_validation_level NUMBER
101 , x_return_status out nocopy VARCHAR2
102 , x_msg_count out nocopy NUMBER
103 , x_msg_data out nocopy VARCHAR2
104 , p_check_login_user VARCHAR2
105 , p_resource_id NUMBER
106 , p_resource_name VARCHAR2
107 , p10_a0 out nocopy NUMBER
108 , p10_a1 out nocopy NUMBER
109 , p10_a2 out nocopy NUMBER
110 , p11_a0 out nocopy JTF_NUMBER_TABLE
111 , p11_a1 out nocopy JTF_NUMBER_TABLE
112 , p11_a2 out nocopy JTF_VARCHAR2_TABLE_100
113 , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
114 , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
115 , x_role_code_varray out nocopy JTF_VARCHAR2_TABLE_4000
116 , p9_a0 NUMBER := 0-1962.0724
117 , p9_a1 NUMBER := 0-1962.0724
118 , p9_a2 VARCHAR2 := fnd_api.g_miss_char
119 );
120 procedure add_resourcerole(p_api_version NUMBER
121 , p_init_msg_list VARCHAR2
122 , p_commit VARCHAR2
123 , p_validation_level NUMBER
124 , x_return_status out nocopy VARCHAR2
125 , x_msg_count out nocopy NUMBER
126 , x_msg_data out nocopy VARCHAR2
127 , p_check_login_user VARCHAR2
128 , p_resource_id NUMBER
129 , p_role_id_varray JTF_NUMBER_TABLE
130 );
131 procedure remove_resourcerole(p_api_version NUMBER
132 , p_init_msg_list VARCHAR2
133 , p_commit VARCHAR2
134 , p_validation_level NUMBER
135 , x_return_status out nocopy VARCHAR2
136 , x_msg_count out nocopy NUMBER
137 , x_msg_data out nocopy VARCHAR2
138 , p_check_login_user VARCHAR2
139 , p_resource_id NUMBER
140 , p_role_id_varray JTF_NUMBER_TABLE
141 );
142 procedure replace_resourcerole(p_api_version NUMBER
143 , p_init_msg_list VARCHAR2
144 , p_commit VARCHAR2
145 , p_validation_level NUMBER
146 , x_return_status out nocopy VARCHAR2
147 , x_msg_count out nocopy NUMBER
148 , x_msg_data out nocopy VARCHAR2
149 , p_check_login_user VARCHAR2
150 , p_resource_id NUMBER
151 , p_role_id_varray JTF_NUMBER_TABLE
152 );
153 procedure get_resourceroles(p_api_version NUMBER
154 , p_init_msg_list VARCHAR2
155 , p_validation_level NUMBER
156 , x_return_status out nocopy VARCHAR2
157 , x_msg_count out nocopy NUMBER
158 , x_msg_data out nocopy VARCHAR2
159 , p_check_login_user VARCHAR2
160 , p_resource_id NUMBER
161 , x_role_id_varray out nocopy JTF_NUMBER_TABLE
162 , x_role_code_varray out nocopy JTF_VARCHAR2_TABLE_4000
163 );
164 procedure add_grouprole(p_api_version NUMBER
165 , p_init_msg_list VARCHAR2
166 , p_commit VARCHAR2
167 , p_validation_level NUMBER
168 , x_return_status out nocopy VARCHAR2
169 , x_msg_count out nocopy NUMBER
170 , x_msg_data out nocopy VARCHAR2
171 , p_check_login_user VARCHAR2
172 , p_group_id NUMBER
173 , p_role_id_varray JTF_NUMBER_TABLE
174 );
175 procedure remove_grouprole(p_api_version NUMBER
176 , p_init_msg_list VARCHAR2
177 , p_commit VARCHAR2
178 , p_validation_level NUMBER
179 , x_return_status out nocopy VARCHAR2
180 , x_msg_count out nocopy NUMBER
181 , x_msg_data out nocopy VARCHAR2
182 , p_check_login_user VARCHAR2
183 , p_group_id NUMBER
184 , p_role_id_varray JTF_NUMBER_TABLE
185 );
186 procedure replace_grouprole(p_api_version NUMBER
187 , p_init_msg_list VARCHAR2
188 , p_commit VARCHAR2
189 , p_validation_level NUMBER
190 , x_return_status out nocopy VARCHAR2
191 , x_msg_count out nocopy NUMBER
192 , x_msg_data out nocopy VARCHAR2
193 , p_check_login_user VARCHAR2
194 , p_group_id NUMBER
195 , p_role_id_varray JTF_NUMBER_TABLE
196 );
197 procedure get_grouproles(p_api_version NUMBER
198 , p_init_msg_list VARCHAR2
199 , p_validation_level NUMBER
200 , x_return_status out nocopy VARCHAR2
201 , x_msg_count out nocopy NUMBER
202 , x_msg_data out nocopy VARCHAR2
203 , p_check_login_user VARCHAR2
204 , p_group_id NUMBER
205 , p_check_effective_date VARCHAR2
206 , x_role_id_varray out nocopy JTF_NUMBER_TABLE
207 , x_role_code_varray out nocopy JTF_VARCHAR2_TABLE_4000
208 );
209 procedure add_group(p_api_version NUMBER
210 , p_init_msg_list VARCHAR2
211 , p_commit VARCHAR2
212 , p_validation_level NUMBER
213 , x_return_status out nocopy VARCHAR2
214 , x_msg_count out nocopy NUMBER
215 , x_msg_data out nocopy VARCHAR2
216 , p_check_login_user VARCHAR2
217 , p_group_name VARCHAR2
218 , p_group_desc VARCHAR2
219 , p_group_usage VARCHAR2
220 , p_email_address VARCHAR2
221 , p_start_date date
222 , p_end_date date
223 , x_group_id out nocopy NUMBER
224 );
225 procedure update_group(p_api_version NUMBER
226 , p_init_msg_list VARCHAR2
227 , p_commit VARCHAR2
228 , p_validation_level NUMBER
229 , x_return_status out nocopy VARCHAR2
230 , x_msg_count out nocopy NUMBER
231 , x_msg_data out nocopy VARCHAR2
232 , p_check_login_user VARCHAR2
233 , p_group_id NUMBER
234 , p_new_group_name VARCHAR2
235 , p_new_group_desc VARCHAR2
236 , p_group_usage VARCHAR2
237 , p_email_address VARCHAR2
238 , p_new_start_date date
239 , p_new_end_date date
240 );
241 procedure get_group(p_api_version NUMBER
242 , p_init_msg_list VARCHAR2
243 , p_validation_level NUMBER
244 , x_return_status out nocopy VARCHAR2
245 , x_msg_count out nocopy NUMBER
246 , x_msg_data out nocopy VARCHAR2
247 , p_check_login_user VARCHAR2
248 , p_group_id NUMBER
249 , p8_a0 out nocopy NUMBER
250 , p8_a1 out nocopy VARCHAR2
251 , p8_a2 out nocopy NUMBER
252 , p8_a3 out nocopy VARCHAR2
253 , p8_a4 out nocopy VARCHAR2
254 , p8_a5 out nocopy DATE
255 , p8_a6 out nocopy DATE
256 );
257 procedure find_group(p_api_version NUMBER
258 , p_init_msg_list VARCHAR2
259 , p_validation_level NUMBER
260 , x_return_status out nocopy VARCHAR2
261 , x_msg_count out nocopy NUMBER
262 , x_msg_data out nocopy VARCHAR2
263 , p_check_login_user VARCHAR2
264 , p_resource_id NUMBER
265 , p_group_name VARCHAR2
266 , p_group_desc VARCHAR2
267 , p_group_email VARCHAR2
268 , p_group_usage VARCHAR2
269 , p13_a0 out nocopy NUMBER
270 , p13_a1 out nocopy NUMBER
271 , p13_a2 out nocopy NUMBER
272 , p14_a0 out nocopy JTF_NUMBER_TABLE
273 , p14_a1 out nocopy JTF_VARCHAR2_TABLE_100
274 , p14_a2 out nocopy JTF_NUMBER_TABLE
275 , p14_a3 out nocopy JTF_VARCHAR2_TABLE_300
276 , p14_a4 out nocopy JTF_VARCHAR2_TABLE_2000
277 , p14_a5 out nocopy JTF_DATE_TABLE
278 , p14_a6 out nocopy JTF_DATE_TABLE
279 , p12_a0 NUMBER := 0-1962.0724
280 , p12_a1 NUMBER := 0-1962.0724
281 , p12_a2 VARCHAR2 := fnd_api.g_miss_char
282 );
283 procedure find_group(p_api_version NUMBER
284 , p_init_msg_list VARCHAR2
285 , p_validation_level NUMBER
286 , x_return_status out nocopy VARCHAR2
287 , x_msg_count out nocopy NUMBER
288 , x_msg_data out nocopy VARCHAR2
289 , p_check_login_user VARCHAR2
290 , p_group_id NUMBER
291 , p_group_name VARCHAR2
292 , p_group_usage VARCHAR2
293 , p11_a0 out nocopy NUMBER
294 , p11_a1 out nocopy NUMBER
295 , p11_a2 out nocopy NUMBER
296 , p12_a0 out nocopy JTF_NUMBER_TABLE
297 , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100
298 , p12_a2 out nocopy JTF_NUMBER_TABLE
299 , p12_a3 out nocopy JTF_VARCHAR2_TABLE_300
300 , p12_a4 out nocopy JTF_VARCHAR2_TABLE_2000
301 , p12_a5 out nocopy JTF_DATE_TABLE
302 , p12_a6 out nocopy JTF_DATE_TABLE
303 , x_role_code_varray out nocopy JTF_VARCHAR2_TABLE_4000
304 , p10_a0 NUMBER := 0-1962.0724
305 , p10_a1 NUMBER := 0-1962.0724
306 , p10_a2 VARCHAR2 := fnd_api.g_miss_char
307 );
308 procedure add_groupmember(p_api_version NUMBER
309 , p_init_msg_list VARCHAR2
310 , p_commit VARCHAR2
311 , p_validation_level NUMBER
312 , x_return_status out nocopy VARCHAR2
313 , x_msg_count out nocopy NUMBER
314 , x_msg_data out nocopy VARCHAR2
315 , p_check_login_user VARCHAR2
316 , p_group_id NUMBER
317 , p_resource_id_varray JTF_NUMBER_TABLE
318 );
319 procedure remove_groupmember(p_api_version NUMBER
320 , p_init_msg_list VARCHAR2
321 , p_commit VARCHAR2
322 , p_validation_level NUMBER
323 , x_return_status out nocopy VARCHAR2
324 , x_msg_count out nocopy NUMBER
325 , x_msg_data out nocopy VARCHAR2
326 , p_check_login_user VARCHAR2
327 , p_group_id NUMBER
328 , p_resource_id_varray JTF_NUMBER_TABLE
329 );
330 procedure update_access(p_api_version NUMBER
331 , p_init_msg_list VARCHAR2
332 , p_commit VARCHAR2
333 , p_validation_level NUMBER
334 , x_return_status out nocopy VARCHAR2
335 , x_msg_count out nocopy NUMBER
336 , x_msg_data out nocopy VARCHAR2
337 , p_check_login_user VARCHAR2
338 , p8_a0 NUMBER := 0-1962.0724
339 , p8_a1 NUMBER := 0-1962.0724
340 , p8_a2 VARCHAR2 := fnd_api.g_miss_char
341 , p8_a3 NUMBER := 0-1962.0724
342 , p8_a4 NUMBER := 0-1962.0724
343 , p8_a5 VARCHAR2 := fnd_api.g_miss_char
344 , p8_a6 DATE := fnd_api.g_miss_date
345 , p8_a7 DATE := fnd_api.g_miss_date
346 , p8_a8 VARCHAR2 := fnd_api.g_miss_char
347 , p8_a9 VARCHAR2 := fnd_api.g_miss_char
348 , p8_a10 VARCHAR2 := fnd_api.g_miss_char
349 , p8_a11 VARCHAR2 := fnd_api.g_miss_char
350 , p8_a12 VARCHAR2 := fnd_api.g_miss_char
351 , p8_a13 VARCHAR2 := fnd_api.g_miss_char
352 , p8_a14 VARCHAR2 := fnd_api.g_miss_char
353 , p8_a15 VARCHAR2 := fnd_api.g_miss_char
354 );
355 procedure update_access(p_api_version NUMBER
356 , p_init_msg_list VARCHAR2
357 , p_commit VARCHAR2
358 , p_validation_level NUMBER
359 , x_return_status out nocopy VARCHAR2
360 , x_msg_count out nocopy NUMBER
361 , x_msg_data out nocopy VARCHAR2
362 , p_check_login_user VARCHAR2
363 , p8_a0 JTF_NUMBER_TABLE
364 , p8_a1 JTF_NUMBER_TABLE
365 , p8_a2 JTF_VARCHAR2_TABLE_100
366 , p8_a3 JTF_NUMBER_TABLE
367 , p8_a4 JTF_NUMBER_TABLE
368 , p8_a5 JTF_VARCHAR2_TABLE_100
369 , p8_a6 JTF_DATE_TABLE
370 , p8_a7 JTF_DATE_TABLE
371 , p8_a8 JTF_VARCHAR2_TABLE_100
372 , p8_a9 JTF_VARCHAR2_TABLE_100
373 , p8_a10 JTF_VARCHAR2_TABLE_100
374 , p8_a11 JTF_VARCHAR2_TABLE_100
375 , p8_a12 JTF_VARCHAR2_TABLE_100
376 , p8_a13 JTF_VARCHAR2_TABLE_100
377 , p8_a14 JTF_VARCHAR2_TABLE_100
378 , p8_a15 JTF_VARCHAR2_TABLE_100
379 );
380 procedure update_resourceapplaccess(p_api_version NUMBER
381 , p_init_msg_list VARCHAR2
382 , p_commit VARCHAR2
383 , p_validation_level NUMBER
384 , x_return_status out nocopy VARCHAR2
385 , x_msg_count out nocopy NUMBER
386 , x_msg_data out nocopy VARCHAR2
387 , p_check_login_user VARCHAR2
388 , p_resource_id NUMBER
389 , p_application_id NUMBER
390 , p10_a0 VARCHAR2 := fnd_api.g_miss_char
391 , p10_a1 VARCHAR2 := fnd_api.g_miss_char
392 , p10_a2 VARCHAR2 := fnd_api.g_miss_char
393 , p10_a3 VARCHAR2 := fnd_api.g_miss_char
394 , p10_a4 VARCHAR2 := fnd_api.g_miss_char
398 );
395 , p10_a5 VARCHAR2 := fnd_api.g_miss_char
396 , p10_a6 VARCHAR2 := fnd_api.g_miss_char
397 , p10_a7 VARCHAR2 := fnd_api.g_miss_char
399 procedure update_resourcechanaccess(p_api_version NUMBER
400 , p_init_msg_list VARCHAR2
401 , p_commit VARCHAR2
402 , p_validation_level NUMBER
403 , x_return_status out nocopy VARCHAR2
404 , x_msg_count out nocopy NUMBER
405 , x_msg_data out nocopy VARCHAR2
406 , p_check_login_user VARCHAR2
407 , p_resource_id NUMBER
408 , p_channel_id NUMBER
409 , p10_a0 VARCHAR2 := fnd_api.g_miss_char
410 , p10_a1 VARCHAR2 := fnd_api.g_miss_char
411 , p10_a2 VARCHAR2 := fnd_api.g_miss_char
412 , p10_a3 VARCHAR2 := fnd_api.g_miss_char
413 , p10_a4 VARCHAR2 := fnd_api.g_miss_char
414 , p10_a5 VARCHAR2 := fnd_api.g_miss_char
415 , p10_a6 VARCHAR2 := fnd_api.g_miss_char
416 , p10_a7 VARCHAR2 := fnd_api.g_miss_char
417 );
418 procedure update_resourcecateaccess(p_api_version NUMBER
419 , p_init_msg_list VARCHAR2
420 , p_commit VARCHAR2
421 , p_validation_level NUMBER
422 , x_return_status out nocopy VARCHAR2
423 , x_msg_count out nocopy NUMBER
424 , x_msg_data out nocopy VARCHAR2
425 , p_check_login_user VARCHAR2
426 , p_resource_id NUMBER
427 , p_category_id NUMBER
428 , p10_a0 VARCHAR2 := fnd_api.g_miss_char
429 , p10_a1 VARCHAR2 := fnd_api.g_miss_char
430 , p10_a2 VARCHAR2 := fnd_api.g_miss_char
431 , p10_a3 VARCHAR2 := fnd_api.g_miss_char
432 , p10_a4 VARCHAR2 := fnd_api.g_miss_char
433 , p10_a5 VARCHAR2 := fnd_api.g_miss_char
434 , p10_a6 VARCHAR2 := fnd_api.g_miss_char
435 , p10_a7 VARCHAR2 := fnd_api.g_miss_char
436 );
437 procedure update_resourceitemaccess(p_api_version NUMBER
438 , p_init_msg_list VARCHAR2
439 , p_commit VARCHAR2
440 , p_validation_level NUMBER
441 , x_return_status out nocopy VARCHAR2
442 , x_msg_count out nocopy NUMBER
443 , x_msg_data out nocopy VARCHAR2
444 , p_check_login_user VARCHAR2
445 , p_resource_id NUMBER
446 , p_item_id NUMBER
447 , p10_a0 VARCHAR2 := fnd_api.g_miss_char
448 , p10_a1 VARCHAR2 := fnd_api.g_miss_char
449 , p10_a2 VARCHAR2 := fnd_api.g_miss_char
450 , p10_a3 VARCHAR2 := fnd_api.g_miss_char
451 , p10_a4 VARCHAR2 := fnd_api.g_miss_char
452 , p10_a5 VARCHAR2 := fnd_api.g_miss_char
453 , p10_a6 VARCHAR2 := fnd_api.g_miss_char
454 , p10_a7 VARCHAR2 := fnd_api.g_miss_char
455 );
456 procedure update_groupapplaccess(p_api_version NUMBER
457 , p_init_msg_list VARCHAR2
458 , p_commit VARCHAR2
459 , p_validation_level NUMBER
460 , x_return_status out nocopy VARCHAR2
461 , x_msg_count out nocopy NUMBER
462 , x_msg_data out nocopy VARCHAR2
463 , p_check_login_user VARCHAR2
464 , p_resource_id NUMBER
465 , p_group_id NUMBER
466 , p_application_id NUMBER
467 , p11_a0 VARCHAR2 := fnd_api.g_miss_char
468 , p11_a1 VARCHAR2 := fnd_api.g_miss_char
469 , p11_a2 VARCHAR2 := fnd_api.g_miss_char
470 , p11_a3 VARCHAR2 := fnd_api.g_miss_char
471 , p11_a4 VARCHAR2 := fnd_api.g_miss_char
472 , p11_a5 VARCHAR2 := fnd_api.g_miss_char
473 , p11_a6 VARCHAR2 := fnd_api.g_miss_char
474 , p11_a7 VARCHAR2 := fnd_api.g_miss_char
475 );
476 procedure update_groupchanaccess(p_api_version NUMBER
477 , p_init_msg_list VARCHAR2
478 , p_commit VARCHAR2
479 , p_validation_level NUMBER
480 , x_return_status out nocopy VARCHAR2
481 , x_msg_count out nocopy NUMBER
482 , x_msg_data out nocopy VARCHAR2
483 , p_check_login_user VARCHAR2
484 , p_group_id NUMBER
485 , p_channel_id NUMBER
486 , p10_a0 VARCHAR2 := fnd_api.g_miss_char
487 , p10_a1 VARCHAR2 := fnd_api.g_miss_char
488 , p10_a2 VARCHAR2 := fnd_api.g_miss_char
489 , p10_a3 VARCHAR2 := fnd_api.g_miss_char
490 , p10_a4 VARCHAR2 := fnd_api.g_miss_char
491 , p10_a5 VARCHAR2 := fnd_api.g_miss_char
492 , p10_a6 VARCHAR2 := fnd_api.g_miss_char
493 , p10_a7 VARCHAR2 := fnd_api.g_miss_char
494 );
495 procedure update_groupcateaccess(p_api_version NUMBER
496 , p_init_msg_list VARCHAR2
497 , p_commit VARCHAR2
498 , p_validation_level NUMBER
499 , x_return_status out nocopy VARCHAR2
500 , x_msg_count out nocopy NUMBER
501 , x_msg_data out nocopy VARCHAR2
502 , p_check_login_user VARCHAR2
503 , p_group_id NUMBER
504 , p_category_id NUMBER
505 , p10_a0 VARCHAR2 := fnd_api.g_miss_char
506 , p10_a1 VARCHAR2 := fnd_api.g_miss_char
507 , p10_a2 VARCHAR2 := fnd_api.g_miss_char
508 , p10_a3 VARCHAR2 := fnd_api.g_miss_char
509 , p10_a4 VARCHAR2 := fnd_api.g_miss_char
510 , p10_a5 VARCHAR2 := fnd_api.g_miss_char
511 , p10_a6 VARCHAR2 := fnd_api.g_miss_char
512 , p10_a7 VARCHAR2 := fnd_api.g_miss_char
513 );
514 procedure update_groupitemaccess(p_api_version NUMBER
515 , p_init_msg_list VARCHAR2
516 , p_commit VARCHAR2
517 , p_validation_level NUMBER
518 , x_return_status out nocopy VARCHAR2
519 , x_msg_count out nocopy NUMBER
523 , p_item_id NUMBER
520 , x_msg_data out nocopy VARCHAR2
521 , p_check_login_user VARCHAR2
522 , p_group_id NUMBER
524 , p10_a0 VARCHAR2 := fnd_api.g_miss_char
525 , p10_a1 VARCHAR2 := fnd_api.g_miss_char
526 , p10_a2 VARCHAR2 := fnd_api.g_miss_char
527 , p10_a3 VARCHAR2 := fnd_api.g_miss_char
528 , p10_a4 VARCHAR2 := fnd_api.g_miss_char
529 , p10_a5 VARCHAR2 := fnd_api.g_miss_char
530 , p10_a6 VARCHAR2 := fnd_api.g_miss_char
531 , p10_a7 VARCHAR2 := fnd_api.g_miss_char
532 );
533 procedure get_businessobjectaccess(p_api_version NUMBER
534 , p_init_msg_list VARCHAR2
535 , p_validation_level NUMBER
536 , x_return_status out nocopy VARCHAR2
537 , x_msg_count out nocopy NUMBER
538 , x_msg_data out nocopy VARCHAR2
539 , p_check_login_user VARCHAR2
540 , p_user_or_group_id NUMBER
541 , p_user_or_group_type VARCHAR2
542 , p_business_object_id NUMBER
543 , p_business_object_type VARCHAR2
544 , p11_a0 out nocopy NUMBER
545 , p11_a1 out nocopy NUMBER
546 , p11_a2 out nocopy VARCHAR2
547 , p11_a3 out nocopy NUMBER
548 , p11_a4 out nocopy NUMBER
549 , p11_a5 out nocopy VARCHAR2
550 , p11_a6 out nocopy DATE
551 , p11_a7 out nocopy DATE
552 , p11_a8 out nocopy VARCHAR2
553 , p11_a9 out nocopy VARCHAR2
554 , p11_a10 out nocopy VARCHAR2
555 , p11_a11 out nocopy VARCHAR2
556 , p11_a12 out nocopy VARCHAR2
557 , p11_a13 out nocopy VARCHAR2
558 , p11_a14 out nocopy VARCHAR2
559 , p11_a15 out nocopy VARCHAR2
560 );
561 procedure get_channelaccess(p_api_version NUMBER
562 , p_init_msg_list VARCHAR2
563 , p_validation_level NUMBER
564 , x_return_status out nocopy VARCHAR2
565 , x_msg_count out nocopy NUMBER
566 , x_msg_data out nocopy VARCHAR2
567 , p_check_login_user VARCHAR2
568 , p_user_or_group_id NUMBER
569 , p_user_or_group_type VARCHAR2
570 , x_channel_name_varray out nocopy JTF_VARCHAR2_TABLE_4000
571 , p10_a0 out nocopy JTF_NUMBER_TABLE
572 , p10_a1 out nocopy JTF_NUMBER_TABLE
573 , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
574 , p10_a3 out nocopy JTF_NUMBER_TABLE
575 , p10_a4 out nocopy JTF_NUMBER_TABLE
576 , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
577 , p10_a6 out nocopy JTF_DATE_TABLE
578 , p10_a7 out nocopy JTF_DATE_TABLE
579 , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100
580 , p10_a9 out nocopy JTF_VARCHAR2_TABLE_100
581 , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
582 , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
583 , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
584 , p10_a13 out nocopy JTF_VARCHAR2_TABLE_100
585 , p10_a14 out nocopy JTF_VARCHAR2_TABLE_100
586 , p10_a15 out nocopy JTF_VARCHAR2_TABLE_100
587 );
588 procedure get_accessperchannel(p_api_version NUMBER
589 , p_init_msg_list VARCHAR2
590 , p_validation_level NUMBER
591 , x_return_status out nocopy VARCHAR2
592 , x_msg_count out nocopy NUMBER
593 , x_msg_data out nocopy VARCHAR2
594 , p_check_login_user VARCHAR2
595 , p_channel_id NUMBER
596 , p_user_or_group_type VARCHAR2
597 , x_name_varray out nocopy JTF_VARCHAR2_TABLE_4000
598 , p10_a0 out nocopy JTF_NUMBER_TABLE
599 , p10_a1 out nocopy JTF_NUMBER_TABLE
600 , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
601 , p10_a3 out nocopy JTF_NUMBER_TABLE
602 , p10_a4 out nocopy JTF_NUMBER_TABLE
603 , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
604 , p10_a6 out nocopy JTF_DATE_TABLE
605 , p10_a7 out nocopy JTF_DATE_TABLE
606 , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100
607 , p10_a9 out nocopy JTF_VARCHAR2_TABLE_100
608 , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
609 , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
610 , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
611 , p10_a13 out nocopy JTF_VARCHAR2_TABLE_100
612 , p10_a14 out nocopy JTF_VARCHAR2_TABLE_100
613 , p10_a15 out nocopy JTF_VARCHAR2_TABLE_100
614 );
615 procedure get_businessobjectaccess(p_api_version NUMBER
616 , p_init_msg_list VARCHAR2
617 , p_validation_level NUMBER
618 , x_return_status out nocopy VARCHAR2
619 , x_msg_count out nocopy NUMBER
620 , x_msg_data out nocopy VARCHAR2
621 , p_check_login_user VARCHAR2
622 , p_include_group_flag VARCHAR2
623 , p_check_effective_date VARCHAR2
624 , p_user_or_group_id NUMBER
625 , p_user_or_group_type VARCHAR2
626 , p_business_object_id NUMBER
627 , p_business_object_type VARCHAR2
628 , p13_a0 out nocopy VARCHAR2
629 , p13_a1 out nocopy VARCHAR2
630 , p13_a2 out nocopy VARCHAR2
631 , p13_a3 out nocopy VARCHAR2
632 , p13_a4 out nocopy VARCHAR2
633 , p13_a5 out nocopy VARCHAR2
634 , p13_a6 out nocopy VARCHAR2
635 , p13_a7 out nocopy VARCHAR2
636 );
637 procedure get_resourceapplaccess(p_api_version NUMBER
638 , p_init_msg_list VARCHAR2
639 , p_validation_level NUMBER
640 , x_return_status out nocopy VARCHAR2
641 , x_msg_count out nocopy NUMBER
642 , x_msg_data out nocopy VARCHAR2
643 , p_check_login_user VARCHAR2
644 , p_include_group_flag VARCHAR2
645 , p_resource_id NUMBER
649 , p10_a2 out nocopy VARCHAR2
646 , p_application_id NUMBER
647 , p10_a0 out nocopy VARCHAR2
648 , p10_a1 out nocopy VARCHAR2
650 , p10_a3 out nocopy VARCHAR2
651 , p10_a4 out nocopy VARCHAR2
652 , p10_a5 out nocopy VARCHAR2
653 , p10_a6 out nocopy VARCHAR2
654 , p10_a7 out nocopy VARCHAR2
655 );
659 , x_return_status out nocopy VARCHAR2
656 procedure get_resourcechanaccess(p_api_version NUMBER
657 , p_init_msg_list VARCHAR2
658 , p_validation_level NUMBER
660 , x_msg_count out nocopy NUMBER
661 , x_msg_data out nocopy VARCHAR2
662 , p_check_login_user VARCHAR2
663 , p_include_group_flag VARCHAR2
664 , p_resource_id NUMBER
665 , p_channel_id NUMBER
666 , p10_a0 out nocopy VARCHAR2
667 , p10_a1 out nocopy VARCHAR2
668 , p10_a2 out nocopy VARCHAR2
669 , p10_a3 out nocopy VARCHAR2
670 , p10_a4 out nocopy VARCHAR2
671 , p10_a5 out nocopy VARCHAR2
672 , p10_a6 out nocopy VARCHAR2
673 , p10_a7 out nocopy VARCHAR2
674 );
675 procedure get_resourcecateaccess(p_api_version NUMBER
676 , p_init_msg_list VARCHAR2
677 , p_validation_level NUMBER
678 , x_return_status out nocopy VARCHAR2
679 , x_msg_count out nocopy NUMBER
680 , x_msg_data out nocopy VARCHAR2
681 , p_check_login_user VARCHAR2
682 , p_include_group_flag VARCHAR2
683 , p_resource_id NUMBER
684 , p_category_id NUMBER
685 , p10_a0 out nocopy VARCHAR2
686 , p10_a1 out nocopy VARCHAR2
687 , p10_a2 out nocopy VARCHAR2
688 , p10_a3 out nocopy VARCHAR2
689 , p10_a4 out nocopy VARCHAR2
690 , p10_a5 out nocopy VARCHAR2
691 , p10_a6 out nocopy VARCHAR2
692 , p10_a7 out nocopy VARCHAR2
693 );
694 procedure get_resourceitemaccess(p_api_version NUMBER
695 , p_init_msg_list VARCHAR2
696 , p_validation_level NUMBER
697 , x_return_status out nocopy VARCHAR2
698 , x_msg_count out nocopy NUMBER
699 , x_msg_data out nocopy VARCHAR2
700 , p_check_login_user VARCHAR2
701 , p_include_group_flag VARCHAR2
702 , p_resource_id NUMBER
703 , p_item_id NUMBER
704 , p10_a0 out nocopy VARCHAR2
705 , p10_a1 out nocopy VARCHAR2
706 , p10_a2 out nocopy VARCHAR2
707 , p10_a3 out nocopy VARCHAR2
708 , p10_a4 out nocopy VARCHAR2
709 , p10_a5 out nocopy VARCHAR2
710 , p10_a6 out nocopy VARCHAR2
711 , p10_a7 out nocopy VARCHAR2
712 );
713 procedure get_groupapplaccess(p_api_version NUMBER
714 , p_init_msg_list VARCHAR2
715 , p_validation_level NUMBER
716 , x_return_status out nocopy VARCHAR2
717 , x_msg_count out nocopy NUMBER
718 , x_msg_data out nocopy VARCHAR2
719 , p_check_login_user VARCHAR2
720 , p_group_id NUMBER
721 , p_application_id NUMBER
722 , p9_a0 out nocopy VARCHAR2
723 , p9_a1 out nocopy VARCHAR2
724 , p9_a2 out nocopy VARCHAR2
725 , p9_a3 out nocopy VARCHAR2
726 , p9_a4 out nocopy VARCHAR2
727 , p9_a5 out nocopy VARCHAR2
728 , p9_a6 out nocopy VARCHAR2
729 , p9_a7 out nocopy VARCHAR2
730 );
731 procedure get_groupchanaccess(p_api_version NUMBER
732 , p_init_msg_list VARCHAR2
733 , p_validation_level NUMBER
734 , x_return_status out nocopy VARCHAR2
735 , x_msg_count out nocopy NUMBER
739 , p_channel_id NUMBER
736 , x_msg_data out nocopy VARCHAR2
737 , p_check_login_user VARCHAR2
738 , p_group_id NUMBER
740 , p9_a0 out nocopy VARCHAR2
741 , p9_a1 out nocopy VARCHAR2
742 , p9_a2 out nocopy VARCHAR2
743 , p9_a3 out nocopy VARCHAR2
744 , p9_a4 out nocopy VARCHAR2
745 , p9_a5 out nocopy VARCHAR2
746 , p9_a6 out nocopy VARCHAR2
747 , p9_a7 out nocopy VARCHAR2
748 );
749 procedure get_groupcateaccess(p_api_version NUMBER
750 , p_init_msg_list VARCHAR2
751 , p_validation_level NUMBER
752 , x_return_status out nocopy VARCHAR2
753 , x_msg_count out nocopy NUMBER
754 , x_msg_data out nocopy VARCHAR2
755 , p_check_login_user VARCHAR2
756 , p_group_id NUMBER
757 , p_category_id NUMBER
758 , p9_a0 out nocopy VARCHAR2
759 , p9_a1 out nocopy VARCHAR2
760 , p9_a2 out nocopy VARCHAR2
761 , p9_a3 out nocopy VARCHAR2
762 , p9_a4 out nocopy VARCHAR2
763 , p9_a5 out nocopy VARCHAR2
764 , p9_a6 out nocopy VARCHAR2
765 , p9_a7 out nocopy VARCHAR2
766 );
767 procedure get_resourceitemaccess(p_api_version NUMBER
768 , p_init_msg_list VARCHAR2
769 , p_validation_level NUMBER
770 , x_return_status out nocopy VARCHAR2
771 , x_msg_count out nocopy NUMBER
772 , x_msg_data out nocopy VARCHAR2
773 , p_check_login_user VARCHAR2
774 , p_group_id NUMBER
775 , p_item_id NUMBER
776 , p9_a0 out nocopy VARCHAR2
777 , p9_a1 out nocopy VARCHAR2
778 , p9_a2 out nocopy VARCHAR2
779 , p9_a3 out nocopy VARCHAR2
780 , p9_a4 out nocopy VARCHAR2
781 , p9_a5 out nocopy VARCHAR2
782 , p9_a6 out nocopy VARCHAR2
783 , p9_a7 out nocopy VARCHAR2
784 );
785 end amv_user_pvt_w;