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
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
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
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
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
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
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
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
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
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
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
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
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: );
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
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
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
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
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
395: , p10_a5 VARCHAR2 := fnd_api.g_miss_char
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
395: , p10_a5 VARCHAR2 := fnd_api.g_miss_char
396: , p10_a6 VARCHAR2 := fnd_api.g_miss_char
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
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
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
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
398: );
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
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
398: );
399: procedure update_resourcechanaccess(p_api_version NUMBER
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
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
398: );
399: procedure update_resourcechanaccess(p_api_version NUMBER
400: , p_init_msg_list VARCHAR2
393: , p10_a3 VARCHAR2 := fnd_api.g_miss_char
394: , p10_a4 VARCHAR2 := fnd_api.g_miss_char
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
398: );
399: procedure update_resourcechanaccess(p_api_version NUMBER
400: , p_init_msg_list VARCHAR2
401: , p_commit VARCHAR2
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
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
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
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
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: );
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
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
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
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
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
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
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
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: );
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
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
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
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
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
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
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
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: );
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
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
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
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
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
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
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
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: );
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
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
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
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
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
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
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
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: );
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
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
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
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
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
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
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
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: );
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
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
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
520: , x_msg_data out nocopy VARCHAR2
521: , p_check_login_user VARCHAR2
522: , p_group_id NUMBER
523: , p_item_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
521: , p_check_login_user VARCHAR2
522: , p_group_id NUMBER
523: , p_item_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
522: , p_group_id NUMBER
523: , p_item_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
523: , p_item_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
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: );
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
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
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