DBA Data[Home] [Help]

APPS.AMV_USER_PVT_W dependencies on JTF_NUMBER_TABLE

Line 6: procedure rosetta_table_copy_in_p32(t out nocopy amv_user_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);

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

Line 7: procedure rosetta_table_copy_out_p32(t amv_user_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);

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

Line 9: procedure rosetta_table_copy_in_p36(t out nocopy amv_user_pvt.amv_resource_obj_varray, a0 JTF_NUMBER_TABLE

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

Line 10: , a1 JTF_NUMBER_TABLE

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: );

Line 15: procedure rosetta_table_copy_out_p36(t amv_user_pvt.amv_resource_obj_varray, a0 out nocopy 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

Line 16: , a1 out nocopy JTF_NUMBER_TABLE

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: );

Line 22: procedure rosetta_table_copy_in_p38(t out nocopy amv_user_pvt.amv_group_obj_varray, a0 JTF_NUMBER_TABLE

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

Line 24: , a2 JTF_NUMBER_TABLE

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

Line 30: procedure rosetta_table_copy_out_p38(t amv_user_pvt.amv_group_obj_varray, a0 out nocopy JTF_NUMBER_TABLE

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

Line 32: , a2 out nocopy JTF_NUMBER_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

Line 39: procedure rosetta_table_copy_in_p40(t out nocopy amv_user_pvt.amv_access_obj_varray, a0 JTF_NUMBER_TABLE

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

Line 40: , a1 JTF_NUMBER_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

Line 42: , a3 JTF_NUMBER_TABLE

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

Line 43: , a4 JTF_NUMBER_TABLE

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

Line 56: procedure rosetta_table_copy_out_p40(t amv_user_pvt.amv_access_obj_varray, a0 out nocopy JTF_NUMBER_TABLE

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

Line 57: , a1 out nocopy JTF_NUMBER_TABLE

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

Line 59: , a3 out nocopy JTF_NUMBER_TABLE

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

Line 60: , a4 out nocopy JTF_NUMBER_TABLE

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

Line 89: , p14_a0 out nocopy JTF_NUMBER_TABLE

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

Line 90: , p14_a1 out nocopy JTF_NUMBER_TABLE

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

Line 110: , p11_a0 out nocopy JTF_NUMBER_TABLE

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

Line 111: , p11_a1 out nocopy JTF_NUMBER_TABLE

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

Line 129: , p_role_id_varray JTF_NUMBER_TABLE

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

Line 140: , p_role_id_varray JTF_NUMBER_TABLE

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

Line 151: , p_role_id_varray JTF_NUMBER_TABLE

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

Line 161: , x_role_id_varray out nocopy JTF_NUMBER_TABLE

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

Line 173: , p_role_id_varray JTF_NUMBER_TABLE

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

Line 184: , p_role_id_varray JTF_NUMBER_TABLE

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

Line 195: , p_role_id_varray JTF_NUMBER_TABLE

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

Line 206: , x_role_id_varray out nocopy JTF_NUMBER_TABLE

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

Line 272: , p14_a0 out nocopy JTF_NUMBER_TABLE

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

Line 274: , p14_a2 out nocopy JTF_NUMBER_TABLE

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

Line 296: , p12_a0 out nocopy JTF_NUMBER_TABLE

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

Line 298: , p12_a2 out nocopy JTF_NUMBER_TABLE

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

Line 317: , p_resource_id_varray JTF_NUMBER_TABLE

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

Line 328: , p_resource_id_varray JTF_NUMBER_TABLE

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

Line 363: , p8_a0 JTF_NUMBER_TABLE

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

Line 364: , p8_a1 JTF_NUMBER_TABLE

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

Line 366: , p8_a3 JTF_NUMBER_TABLE

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

Line 367: , p8_a4 JTF_NUMBER_TABLE

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

Line 571: , p10_a0 out nocopy JTF_NUMBER_TABLE

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

Line 572: , p10_a1 out nocopy JTF_NUMBER_TABLE

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

Line 574: , p10_a3 out nocopy JTF_NUMBER_TABLE

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

Line 575: , p10_a4 out nocopy JTF_NUMBER_TABLE

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

Line 598: , p10_a0 out nocopy JTF_NUMBER_TABLE

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

Line 599: , p10_a1 out nocopy JTF_NUMBER_TABLE

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

Line 601: , p10_a3 out nocopy JTF_NUMBER_TABLE

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

Line 602: , p10_a4 out nocopy JTF_NUMBER_TABLE

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