21:
22: procedure rosetta_table_copy_in_p2(t out nocopy jtf_um_subscription_info.subscription_info_table, a0 JTF_VARCHAR2_TABLE_1000
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_2000
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_2000
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_2000
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_VARCHAR2_TABLE_300
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_VARCHAR2_TABLE_300
36: , a14 JTF_VARCHAR2_TABLE_300
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_VARCHAR2_TABLE_300
36: , a14 JTF_VARCHAR2_TABLE_300
37: ) as
68: end rosetta_table_copy_in_p2;
69: procedure rosetta_table_copy_out_p2(t jtf_um_subscription_info.subscription_info_table, a0 out nocopy JTF_VARCHAR2_TABLE_1000
70: , a1 out nocopy JTF_VARCHAR2_TABLE_100
71: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
72: , a3 out nocopy JTF_NUMBER_TABLE
73: , a4 out nocopy JTF_VARCHAR2_TABLE_100
74: , a5 out nocopy JTF_NUMBER_TABLE
75: , a6 out nocopy JTF_NUMBER_TABLE
76: , a7 out nocopy JTF_NUMBER_TABLE
70: , a1 out nocopy JTF_VARCHAR2_TABLE_100
71: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
72: , a3 out nocopy JTF_NUMBER_TABLE
73: , a4 out nocopy JTF_VARCHAR2_TABLE_100
74: , a5 out nocopy JTF_NUMBER_TABLE
75: , a6 out nocopy JTF_NUMBER_TABLE
76: , a7 out nocopy JTF_NUMBER_TABLE
77: , a8 out nocopy JTF_NUMBER_TABLE
78: , a9 out nocopy JTF_NUMBER_TABLE
71: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
72: , a3 out nocopy JTF_NUMBER_TABLE
73: , a4 out nocopy JTF_VARCHAR2_TABLE_100
74: , a5 out nocopy JTF_NUMBER_TABLE
75: , a6 out nocopy JTF_NUMBER_TABLE
76: , a7 out nocopy JTF_NUMBER_TABLE
77: , a8 out nocopy JTF_NUMBER_TABLE
78: , a9 out nocopy JTF_NUMBER_TABLE
79: , a10 out nocopy JTF_NUMBER_TABLE
72: , a3 out nocopy JTF_NUMBER_TABLE
73: , a4 out nocopy JTF_VARCHAR2_TABLE_100
74: , a5 out nocopy JTF_NUMBER_TABLE
75: , a6 out nocopy JTF_NUMBER_TABLE
76: , a7 out nocopy JTF_NUMBER_TABLE
77: , a8 out nocopy JTF_NUMBER_TABLE
78: , a9 out nocopy JTF_NUMBER_TABLE
79: , a10 out nocopy JTF_NUMBER_TABLE
80: , a11 out nocopy JTF_NUMBER_TABLE
73: , a4 out nocopy JTF_VARCHAR2_TABLE_100
74: , a5 out nocopy JTF_NUMBER_TABLE
75: , a6 out nocopy JTF_NUMBER_TABLE
76: , a7 out nocopy JTF_NUMBER_TABLE
77: , a8 out nocopy JTF_NUMBER_TABLE
78: , a9 out nocopy JTF_NUMBER_TABLE
79: , a10 out nocopy JTF_NUMBER_TABLE
80: , a11 out nocopy JTF_NUMBER_TABLE
81: , a12 out nocopy JTF_VARCHAR2_TABLE_100
74: , a5 out nocopy JTF_NUMBER_TABLE
75: , a6 out nocopy JTF_NUMBER_TABLE
76: , a7 out nocopy JTF_NUMBER_TABLE
77: , a8 out nocopy JTF_NUMBER_TABLE
78: , a9 out nocopy JTF_NUMBER_TABLE
79: , a10 out nocopy JTF_NUMBER_TABLE
80: , a11 out nocopy JTF_NUMBER_TABLE
81: , a12 out nocopy JTF_VARCHAR2_TABLE_100
82: , a13 out nocopy JTF_VARCHAR2_TABLE_300
75: , a6 out nocopy JTF_NUMBER_TABLE
76: , a7 out nocopy JTF_NUMBER_TABLE
77: , a8 out nocopy JTF_NUMBER_TABLE
78: , a9 out nocopy JTF_NUMBER_TABLE
79: , a10 out nocopy JTF_NUMBER_TABLE
80: , a11 out nocopy JTF_NUMBER_TABLE
81: , a12 out nocopy JTF_VARCHAR2_TABLE_100
82: , a13 out nocopy JTF_VARCHAR2_TABLE_300
83: , a14 out nocopy JTF_VARCHAR2_TABLE_300
76: , a7 out nocopy JTF_NUMBER_TABLE
77: , a8 out nocopy JTF_NUMBER_TABLE
78: , a9 out nocopy JTF_NUMBER_TABLE
79: , a10 out nocopy JTF_NUMBER_TABLE
80: , a11 out nocopy JTF_NUMBER_TABLE
81: , a12 out nocopy JTF_VARCHAR2_TABLE_100
82: , a13 out nocopy JTF_VARCHAR2_TABLE_300
83: , a14 out nocopy JTF_VARCHAR2_TABLE_300
84: ) as
87: if t is null or t.count = 0 then
88: a0 := JTF_VARCHAR2_TABLE_1000();
89: a1 := JTF_VARCHAR2_TABLE_100();
90: a2 := JTF_VARCHAR2_TABLE_2000();
91: a3 := JTF_NUMBER_TABLE();
92: a4 := JTF_VARCHAR2_TABLE_100();
93: a5 := JTF_NUMBER_TABLE();
94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_NUMBER_TABLE();
89: a1 := JTF_VARCHAR2_TABLE_100();
90: a2 := JTF_VARCHAR2_TABLE_2000();
91: a3 := JTF_NUMBER_TABLE();
92: a4 := JTF_VARCHAR2_TABLE_100();
93: a5 := JTF_NUMBER_TABLE();
94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_NUMBER_TABLE();
96: a8 := JTF_NUMBER_TABLE();
97: a9 := JTF_NUMBER_TABLE();
90: a2 := JTF_VARCHAR2_TABLE_2000();
91: a3 := JTF_NUMBER_TABLE();
92: a4 := JTF_VARCHAR2_TABLE_100();
93: a5 := JTF_NUMBER_TABLE();
94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_NUMBER_TABLE();
96: a8 := JTF_NUMBER_TABLE();
97: a9 := JTF_NUMBER_TABLE();
98: a10 := JTF_NUMBER_TABLE();
91: a3 := JTF_NUMBER_TABLE();
92: a4 := JTF_VARCHAR2_TABLE_100();
93: a5 := JTF_NUMBER_TABLE();
94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_NUMBER_TABLE();
96: a8 := JTF_NUMBER_TABLE();
97: a9 := JTF_NUMBER_TABLE();
98: a10 := JTF_NUMBER_TABLE();
99: a11 := JTF_NUMBER_TABLE();
92: a4 := JTF_VARCHAR2_TABLE_100();
93: a5 := JTF_NUMBER_TABLE();
94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_NUMBER_TABLE();
96: a8 := JTF_NUMBER_TABLE();
97: a9 := JTF_NUMBER_TABLE();
98: a10 := JTF_NUMBER_TABLE();
99: a11 := JTF_NUMBER_TABLE();
100: a12 := JTF_VARCHAR2_TABLE_100();
93: a5 := JTF_NUMBER_TABLE();
94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_NUMBER_TABLE();
96: a8 := JTF_NUMBER_TABLE();
97: a9 := JTF_NUMBER_TABLE();
98: a10 := JTF_NUMBER_TABLE();
99: a11 := JTF_NUMBER_TABLE();
100: a12 := JTF_VARCHAR2_TABLE_100();
101: a13 := JTF_VARCHAR2_TABLE_300();
94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_NUMBER_TABLE();
96: a8 := JTF_NUMBER_TABLE();
97: a9 := JTF_NUMBER_TABLE();
98: a10 := JTF_NUMBER_TABLE();
99: a11 := JTF_NUMBER_TABLE();
100: a12 := JTF_VARCHAR2_TABLE_100();
101: a13 := JTF_VARCHAR2_TABLE_300();
102: a14 := JTF_VARCHAR2_TABLE_300();
95: a7 := JTF_NUMBER_TABLE();
96: a8 := JTF_NUMBER_TABLE();
97: a9 := JTF_NUMBER_TABLE();
98: a10 := JTF_NUMBER_TABLE();
99: a11 := JTF_NUMBER_TABLE();
100: a12 := JTF_VARCHAR2_TABLE_100();
101: a13 := JTF_VARCHAR2_TABLE_300();
102: a14 := JTF_VARCHAR2_TABLE_300();
103: else
103: else
104: a0 := JTF_VARCHAR2_TABLE_1000();
105: a1 := JTF_VARCHAR2_TABLE_100();
106: a2 := JTF_VARCHAR2_TABLE_2000();
107: a3 := JTF_NUMBER_TABLE();
108: a4 := JTF_VARCHAR2_TABLE_100();
109: a5 := JTF_NUMBER_TABLE();
110: a6 := JTF_NUMBER_TABLE();
111: a7 := JTF_NUMBER_TABLE();
105: a1 := JTF_VARCHAR2_TABLE_100();
106: a2 := JTF_VARCHAR2_TABLE_2000();
107: a3 := JTF_NUMBER_TABLE();
108: a4 := JTF_VARCHAR2_TABLE_100();
109: a5 := JTF_NUMBER_TABLE();
110: a6 := JTF_NUMBER_TABLE();
111: a7 := JTF_NUMBER_TABLE();
112: a8 := JTF_NUMBER_TABLE();
113: a9 := JTF_NUMBER_TABLE();
106: a2 := JTF_VARCHAR2_TABLE_2000();
107: a3 := JTF_NUMBER_TABLE();
108: a4 := JTF_VARCHAR2_TABLE_100();
109: a5 := JTF_NUMBER_TABLE();
110: a6 := JTF_NUMBER_TABLE();
111: a7 := JTF_NUMBER_TABLE();
112: a8 := JTF_NUMBER_TABLE();
113: a9 := JTF_NUMBER_TABLE();
114: a10 := JTF_NUMBER_TABLE();
107: a3 := JTF_NUMBER_TABLE();
108: a4 := JTF_VARCHAR2_TABLE_100();
109: a5 := JTF_NUMBER_TABLE();
110: a6 := JTF_NUMBER_TABLE();
111: a7 := JTF_NUMBER_TABLE();
112: a8 := JTF_NUMBER_TABLE();
113: a9 := JTF_NUMBER_TABLE();
114: a10 := JTF_NUMBER_TABLE();
115: a11 := JTF_NUMBER_TABLE();
108: a4 := JTF_VARCHAR2_TABLE_100();
109: a5 := JTF_NUMBER_TABLE();
110: a6 := JTF_NUMBER_TABLE();
111: a7 := JTF_NUMBER_TABLE();
112: a8 := JTF_NUMBER_TABLE();
113: a9 := JTF_NUMBER_TABLE();
114: a10 := JTF_NUMBER_TABLE();
115: a11 := JTF_NUMBER_TABLE();
116: a12 := JTF_VARCHAR2_TABLE_100();
109: a5 := JTF_NUMBER_TABLE();
110: a6 := JTF_NUMBER_TABLE();
111: a7 := JTF_NUMBER_TABLE();
112: a8 := JTF_NUMBER_TABLE();
113: a9 := JTF_NUMBER_TABLE();
114: a10 := JTF_NUMBER_TABLE();
115: a11 := JTF_NUMBER_TABLE();
116: a12 := JTF_VARCHAR2_TABLE_100();
117: a13 := JTF_VARCHAR2_TABLE_300();
110: a6 := JTF_NUMBER_TABLE();
111: a7 := JTF_NUMBER_TABLE();
112: a8 := JTF_NUMBER_TABLE();
113: a9 := JTF_NUMBER_TABLE();
114: a10 := JTF_NUMBER_TABLE();
115: a11 := JTF_NUMBER_TABLE();
116: a12 := JTF_VARCHAR2_TABLE_100();
117: a13 := JTF_VARCHAR2_TABLE_300();
118: a14 := JTF_VARCHAR2_TABLE_300();
111: a7 := JTF_NUMBER_TABLE();
112: a8 := JTF_NUMBER_TABLE();
113: a9 := JTF_NUMBER_TABLE();
114: a10 := JTF_NUMBER_TABLE();
115: a11 := JTF_NUMBER_TABLE();
116: a12 := JTF_VARCHAR2_TABLE_100();
117: a13 := JTF_VARCHAR2_TABLE_300();
118: a14 := JTF_VARCHAR2_TABLE_300();
119: if t.count > 0 then
159: end if;
160: end if;
161: end rosetta_table_copy_out_p2;
162:
163: procedure rosetta_table_copy_in_p3(t out nocopy jtf_um_subscription_info.subscription_list, a0 JTF_NUMBER_TABLE
164: ) as
165: ddindx binary_integer; indx binary_integer;
166: begin
167: if a0 is not null and a0.count > 0 then
178: end loop;
179: end if;
180: end if;
181: end rosetta_table_copy_in_p3;
182: procedure rosetta_table_copy_out_p3(t jtf_um_subscription_info.subscription_list, a0 out nocopy JTF_NUMBER_TABLE
183: ) as
184: ddindx binary_integer; indx binary_integer;
185: begin
186: if t is null or t.count = 0 then
183: ) as
184: ddindx binary_integer; indx binary_integer;
185: begin
186: if t is null or t.count = 0 then
187: a0 := JTF_NUMBER_TABLE();
188: else
189: a0 := JTF_NUMBER_TABLE();
190: if t.count > 0 then
191: a0.extend(t.count);
185: begin
186: if t is null or t.count = 0 then
187: a0 := JTF_NUMBER_TABLE();
188: else
189: a0 := JTF_NUMBER_TABLE();
190: if t.count > 0 then
191: a0.extend(t.count);
192: ddindx := t.first;
193: indx := 1;
208: , p_is_admin NUMBER
209: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_1000
210: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
211: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_2000
212: , p3_a3 out nocopy JTF_NUMBER_TABLE
213: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
214: , p3_a5 out nocopy JTF_NUMBER_TABLE
215: , p3_a6 out nocopy JTF_NUMBER_TABLE
216: , p3_a7 out nocopy JTF_NUMBER_TABLE
210: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
211: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_2000
212: , p3_a3 out nocopy JTF_NUMBER_TABLE
213: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
214: , p3_a5 out nocopy JTF_NUMBER_TABLE
215: , p3_a6 out nocopy JTF_NUMBER_TABLE
216: , p3_a7 out nocopy JTF_NUMBER_TABLE
217: , p3_a8 out nocopy JTF_NUMBER_TABLE
218: , p3_a9 out nocopy JTF_NUMBER_TABLE
211: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_2000
212: , p3_a3 out nocopy JTF_NUMBER_TABLE
213: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
214: , p3_a5 out nocopy JTF_NUMBER_TABLE
215: , p3_a6 out nocopy JTF_NUMBER_TABLE
216: , p3_a7 out nocopy JTF_NUMBER_TABLE
217: , p3_a8 out nocopy JTF_NUMBER_TABLE
218: , p3_a9 out nocopy JTF_NUMBER_TABLE
219: , p3_a10 out nocopy JTF_NUMBER_TABLE
212: , p3_a3 out nocopy JTF_NUMBER_TABLE
213: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
214: , p3_a5 out nocopy JTF_NUMBER_TABLE
215: , p3_a6 out nocopy JTF_NUMBER_TABLE
216: , p3_a7 out nocopy JTF_NUMBER_TABLE
217: , p3_a8 out nocopy JTF_NUMBER_TABLE
218: , p3_a9 out nocopy JTF_NUMBER_TABLE
219: , p3_a10 out nocopy JTF_NUMBER_TABLE
220: , p3_a11 out nocopy JTF_NUMBER_TABLE
213: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
214: , p3_a5 out nocopy JTF_NUMBER_TABLE
215: , p3_a6 out nocopy JTF_NUMBER_TABLE
216: , p3_a7 out nocopy JTF_NUMBER_TABLE
217: , p3_a8 out nocopy JTF_NUMBER_TABLE
218: , p3_a9 out nocopy JTF_NUMBER_TABLE
219: , p3_a10 out nocopy JTF_NUMBER_TABLE
220: , p3_a11 out nocopy JTF_NUMBER_TABLE
221: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
214: , p3_a5 out nocopy JTF_NUMBER_TABLE
215: , p3_a6 out nocopy JTF_NUMBER_TABLE
216: , p3_a7 out nocopy JTF_NUMBER_TABLE
217: , p3_a8 out nocopy JTF_NUMBER_TABLE
218: , p3_a9 out nocopy JTF_NUMBER_TABLE
219: , p3_a10 out nocopy JTF_NUMBER_TABLE
220: , p3_a11 out nocopy JTF_NUMBER_TABLE
221: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
222: , p3_a13 out nocopy JTF_VARCHAR2_TABLE_300
215: , p3_a6 out nocopy JTF_NUMBER_TABLE
216: , p3_a7 out nocopy JTF_NUMBER_TABLE
217: , p3_a8 out nocopy JTF_NUMBER_TABLE
218: , p3_a9 out nocopy JTF_NUMBER_TABLE
219: , p3_a10 out nocopy JTF_NUMBER_TABLE
220: , p3_a11 out nocopy JTF_NUMBER_TABLE
221: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
222: , p3_a13 out nocopy JTF_VARCHAR2_TABLE_300
223: , p3_a14 out nocopy JTF_VARCHAR2_TABLE_300
216: , p3_a7 out nocopy JTF_NUMBER_TABLE
217: , p3_a8 out nocopy JTF_NUMBER_TABLE
218: , p3_a9 out nocopy JTF_NUMBER_TABLE
219: , p3_a10 out nocopy JTF_NUMBER_TABLE
220: , p3_a11 out nocopy JTF_NUMBER_TABLE
221: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
222: , p3_a13 out nocopy JTF_VARCHAR2_TABLE_300
223: , p3_a14 out nocopy JTF_VARCHAR2_TABLE_300
224: )
268: , p_sub_status VARCHAR2
269: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_1000
270: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
271: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_2000
272: , p5_a3 out nocopy JTF_NUMBER_TABLE
273: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
274: , p5_a5 out nocopy JTF_NUMBER_TABLE
275: , p5_a6 out nocopy JTF_NUMBER_TABLE
276: , p5_a7 out nocopy JTF_NUMBER_TABLE
270: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
271: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_2000
272: , p5_a3 out nocopy JTF_NUMBER_TABLE
273: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
274: , p5_a5 out nocopy JTF_NUMBER_TABLE
275: , p5_a6 out nocopy JTF_NUMBER_TABLE
276: , p5_a7 out nocopy JTF_NUMBER_TABLE
277: , p5_a8 out nocopy JTF_NUMBER_TABLE
278: , p5_a9 out nocopy JTF_NUMBER_TABLE
271: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_2000
272: , p5_a3 out nocopy JTF_NUMBER_TABLE
273: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
274: , p5_a5 out nocopy JTF_NUMBER_TABLE
275: , p5_a6 out nocopy JTF_NUMBER_TABLE
276: , p5_a7 out nocopy JTF_NUMBER_TABLE
277: , p5_a8 out nocopy JTF_NUMBER_TABLE
278: , p5_a9 out nocopy JTF_NUMBER_TABLE
279: , p5_a10 out nocopy JTF_NUMBER_TABLE
272: , p5_a3 out nocopy JTF_NUMBER_TABLE
273: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
274: , p5_a5 out nocopy JTF_NUMBER_TABLE
275: , p5_a6 out nocopy JTF_NUMBER_TABLE
276: , p5_a7 out nocopy JTF_NUMBER_TABLE
277: , p5_a8 out nocopy JTF_NUMBER_TABLE
278: , p5_a9 out nocopy JTF_NUMBER_TABLE
279: , p5_a10 out nocopy JTF_NUMBER_TABLE
280: , p5_a11 out nocopy JTF_NUMBER_TABLE
273: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
274: , p5_a5 out nocopy JTF_NUMBER_TABLE
275: , p5_a6 out nocopy JTF_NUMBER_TABLE
276: , p5_a7 out nocopy JTF_NUMBER_TABLE
277: , p5_a8 out nocopy JTF_NUMBER_TABLE
278: , p5_a9 out nocopy JTF_NUMBER_TABLE
279: , p5_a10 out nocopy JTF_NUMBER_TABLE
280: , p5_a11 out nocopy JTF_NUMBER_TABLE
281: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
274: , p5_a5 out nocopy JTF_NUMBER_TABLE
275: , p5_a6 out nocopy JTF_NUMBER_TABLE
276: , p5_a7 out nocopy JTF_NUMBER_TABLE
277: , p5_a8 out nocopy JTF_NUMBER_TABLE
278: , p5_a9 out nocopy JTF_NUMBER_TABLE
279: , p5_a10 out nocopy JTF_NUMBER_TABLE
280: , p5_a11 out nocopy JTF_NUMBER_TABLE
281: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
282: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_300
275: , p5_a6 out nocopy JTF_NUMBER_TABLE
276: , p5_a7 out nocopy JTF_NUMBER_TABLE
277: , p5_a8 out nocopy JTF_NUMBER_TABLE
278: , p5_a9 out nocopy JTF_NUMBER_TABLE
279: , p5_a10 out nocopy JTF_NUMBER_TABLE
280: , p5_a11 out nocopy JTF_NUMBER_TABLE
281: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
282: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_300
283: , p5_a14 out nocopy JTF_VARCHAR2_TABLE_300
276: , p5_a7 out nocopy JTF_NUMBER_TABLE
277: , p5_a8 out nocopy JTF_NUMBER_TABLE
278: , p5_a9 out nocopy JTF_NUMBER_TABLE
279: , p5_a10 out nocopy JTF_NUMBER_TABLE
280: , p5_a11 out nocopy JTF_NUMBER_TABLE
281: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
282: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_300
283: , p5_a14 out nocopy JTF_VARCHAR2_TABLE_300
284: )
331: , p_usertype_id NUMBER
332: , p_is_admin NUMBER
333: , p_admin_id NUMBER
334: , p_administrator NUMBER
335: , p5_a0 JTF_NUMBER_TABLE
336: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_1000
337: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
338: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000
339: , p6_a3 out nocopy JTF_NUMBER_TABLE
335: , p5_a0 JTF_NUMBER_TABLE
336: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_1000
337: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
338: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000
339: , p6_a3 out nocopy JTF_NUMBER_TABLE
340: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
341: , p6_a5 out nocopy JTF_NUMBER_TABLE
342: , p6_a6 out nocopy JTF_NUMBER_TABLE
343: , p6_a7 out nocopy JTF_NUMBER_TABLE
337: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
338: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000
339: , p6_a3 out nocopy JTF_NUMBER_TABLE
340: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
341: , p6_a5 out nocopy JTF_NUMBER_TABLE
342: , p6_a6 out nocopy JTF_NUMBER_TABLE
343: , p6_a7 out nocopy JTF_NUMBER_TABLE
344: , p6_a8 out nocopy JTF_NUMBER_TABLE
345: , p6_a9 out nocopy JTF_NUMBER_TABLE
338: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000
339: , p6_a3 out nocopy JTF_NUMBER_TABLE
340: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
341: , p6_a5 out nocopy JTF_NUMBER_TABLE
342: , p6_a6 out nocopy JTF_NUMBER_TABLE
343: , p6_a7 out nocopy JTF_NUMBER_TABLE
344: , p6_a8 out nocopy JTF_NUMBER_TABLE
345: , p6_a9 out nocopy JTF_NUMBER_TABLE
346: , p6_a10 out nocopy JTF_NUMBER_TABLE
339: , p6_a3 out nocopy JTF_NUMBER_TABLE
340: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
341: , p6_a5 out nocopy JTF_NUMBER_TABLE
342: , p6_a6 out nocopy JTF_NUMBER_TABLE
343: , p6_a7 out nocopy JTF_NUMBER_TABLE
344: , p6_a8 out nocopy JTF_NUMBER_TABLE
345: , p6_a9 out nocopy JTF_NUMBER_TABLE
346: , p6_a10 out nocopy JTF_NUMBER_TABLE
347: , p6_a11 out nocopy JTF_NUMBER_TABLE
340: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
341: , p6_a5 out nocopy JTF_NUMBER_TABLE
342: , p6_a6 out nocopy JTF_NUMBER_TABLE
343: , p6_a7 out nocopy JTF_NUMBER_TABLE
344: , p6_a8 out nocopy JTF_NUMBER_TABLE
345: , p6_a9 out nocopy JTF_NUMBER_TABLE
346: , p6_a10 out nocopy JTF_NUMBER_TABLE
347: , p6_a11 out nocopy JTF_NUMBER_TABLE
348: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
341: , p6_a5 out nocopy JTF_NUMBER_TABLE
342: , p6_a6 out nocopy JTF_NUMBER_TABLE
343: , p6_a7 out nocopy JTF_NUMBER_TABLE
344: , p6_a8 out nocopy JTF_NUMBER_TABLE
345: , p6_a9 out nocopy JTF_NUMBER_TABLE
346: , p6_a10 out nocopy JTF_NUMBER_TABLE
347: , p6_a11 out nocopy JTF_NUMBER_TABLE
348: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
349: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_300
342: , p6_a6 out nocopy JTF_NUMBER_TABLE
343: , p6_a7 out nocopy JTF_NUMBER_TABLE
344: , p6_a8 out nocopy JTF_NUMBER_TABLE
345: , p6_a9 out nocopy JTF_NUMBER_TABLE
346: , p6_a10 out nocopy JTF_NUMBER_TABLE
347: , p6_a11 out nocopy JTF_NUMBER_TABLE
348: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
349: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_300
350: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_300
343: , p6_a7 out nocopy JTF_NUMBER_TABLE
344: , p6_a8 out nocopy JTF_NUMBER_TABLE
345: , p6_a9 out nocopy JTF_NUMBER_TABLE
346: , p6_a10 out nocopy JTF_NUMBER_TABLE
347: , p6_a11 out nocopy JTF_NUMBER_TABLE
348: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
349: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_300
350: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_300
351: )
403: procedure get_usertype_sub(p_usertype_id NUMBER
404: , p_user_id NUMBER
405: , p_is_admin NUMBER
406: , p_admin_id NUMBER
407: , p4_a0 JTF_NUMBER_TABLE
408: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_1000
409: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
410: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_2000
411: , p5_a3 out nocopy JTF_NUMBER_TABLE
407: , p4_a0 JTF_NUMBER_TABLE
408: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_1000
409: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
410: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_2000
411: , p5_a3 out nocopy JTF_NUMBER_TABLE
412: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
413: , p5_a5 out nocopy JTF_NUMBER_TABLE
414: , p5_a6 out nocopy JTF_NUMBER_TABLE
415: , p5_a7 out nocopy JTF_NUMBER_TABLE
409: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
410: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_2000
411: , p5_a3 out nocopy JTF_NUMBER_TABLE
412: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
413: , p5_a5 out nocopy JTF_NUMBER_TABLE
414: , p5_a6 out nocopy JTF_NUMBER_TABLE
415: , p5_a7 out nocopy JTF_NUMBER_TABLE
416: , p5_a8 out nocopy JTF_NUMBER_TABLE
417: , p5_a9 out nocopy JTF_NUMBER_TABLE
410: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_2000
411: , p5_a3 out nocopy JTF_NUMBER_TABLE
412: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
413: , p5_a5 out nocopy JTF_NUMBER_TABLE
414: , p5_a6 out nocopy JTF_NUMBER_TABLE
415: , p5_a7 out nocopy JTF_NUMBER_TABLE
416: , p5_a8 out nocopy JTF_NUMBER_TABLE
417: , p5_a9 out nocopy JTF_NUMBER_TABLE
418: , p5_a10 out nocopy JTF_NUMBER_TABLE
411: , p5_a3 out nocopy JTF_NUMBER_TABLE
412: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
413: , p5_a5 out nocopy JTF_NUMBER_TABLE
414: , p5_a6 out nocopy JTF_NUMBER_TABLE
415: , p5_a7 out nocopy JTF_NUMBER_TABLE
416: , p5_a8 out nocopy JTF_NUMBER_TABLE
417: , p5_a9 out nocopy JTF_NUMBER_TABLE
418: , p5_a10 out nocopy JTF_NUMBER_TABLE
419: , p5_a11 out nocopy JTF_NUMBER_TABLE
412: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
413: , p5_a5 out nocopy JTF_NUMBER_TABLE
414: , p5_a6 out nocopy JTF_NUMBER_TABLE
415: , p5_a7 out nocopy JTF_NUMBER_TABLE
416: , p5_a8 out nocopy JTF_NUMBER_TABLE
417: , p5_a9 out nocopy JTF_NUMBER_TABLE
418: , p5_a10 out nocopy JTF_NUMBER_TABLE
419: , p5_a11 out nocopy JTF_NUMBER_TABLE
420: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
413: , p5_a5 out nocopy JTF_NUMBER_TABLE
414: , p5_a6 out nocopy JTF_NUMBER_TABLE
415: , p5_a7 out nocopy JTF_NUMBER_TABLE
416: , p5_a8 out nocopy JTF_NUMBER_TABLE
417: , p5_a9 out nocopy JTF_NUMBER_TABLE
418: , p5_a10 out nocopy JTF_NUMBER_TABLE
419: , p5_a11 out nocopy JTF_NUMBER_TABLE
420: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
421: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_300
414: , p5_a6 out nocopy JTF_NUMBER_TABLE
415: , p5_a7 out nocopy JTF_NUMBER_TABLE
416: , p5_a8 out nocopy JTF_NUMBER_TABLE
417: , p5_a9 out nocopy JTF_NUMBER_TABLE
418: , p5_a10 out nocopy JTF_NUMBER_TABLE
419: , p5_a11 out nocopy JTF_NUMBER_TABLE
420: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
421: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_300
422: , p5_a14 out nocopy JTF_VARCHAR2_TABLE_300
415: , p5_a7 out nocopy JTF_NUMBER_TABLE
416: , p5_a8 out nocopy JTF_NUMBER_TABLE
417: , p5_a9 out nocopy JTF_NUMBER_TABLE
418: , p5_a10 out nocopy JTF_NUMBER_TABLE
419: , p5_a11 out nocopy JTF_NUMBER_TABLE
420: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
421: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_300
422: , p5_a14 out nocopy JTF_VARCHAR2_TABLE_300
423: )