APPS.AMV_MYCHANNEL_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 137: , a1 JTF_VARCHAR2_TABLE_100

133: end if;
134: end rosetta_table_copy_out_p4;
135:
136: procedure rosetta_table_copy_in_p6(t out nocopy amv_mychannel_pvt.amv_my_channel_varray_type, a0 JTF_NUMBER_TABLE
137: , a1 JTF_VARCHAR2_TABLE_100
138: , a2 JTF_VARCHAR2_TABLE_100
139: , a3 JTF_NUMBER_TABLE
140: , a4 JTF_VARCHAR2_TABLE_100
141: , a5 JTF_NUMBER_TABLE

Line 138: , a2 JTF_VARCHAR2_TABLE_100

134: end rosetta_table_copy_out_p4;
135:
136: procedure rosetta_table_copy_in_p6(t out nocopy amv_mychannel_pvt.amv_my_channel_varray_type, a0 JTF_NUMBER_TABLE
137: , a1 JTF_VARCHAR2_TABLE_100
138: , a2 JTF_VARCHAR2_TABLE_100
139: , a3 JTF_NUMBER_TABLE
140: , a4 JTF_VARCHAR2_TABLE_100
141: , a5 JTF_NUMBER_TABLE
142: , a6 JTF_VARCHAR2_TABLE_100

Line 140: , a4 JTF_VARCHAR2_TABLE_100

136: procedure rosetta_table_copy_in_p6(t out nocopy amv_mychannel_pvt.amv_my_channel_varray_type, a0 JTF_NUMBER_TABLE
137: , a1 JTF_VARCHAR2_TABLE_100
138: , a2 JTF_VARCHAR2_TABLE_100
139: , a3 JTF_NUMBER_TABLE
140: , a4 JTF_VARCHAR2_TABLE_100
141: , a5 JTF_NUMBER_TABLE
142: , a6 JTF_VARCHAR2_TABLE_100
143: , a7 JTF_VARCHAR2_TABLE_100
144: , a8 JTF_NUMBER_TABLE

Line 142: , a6 JTF_VARCHAR2_TABLE_100

138: , a2 JTF_VARCHAR2_TABLE_100
139: , a3 JTF_NUMBER_TABLE
140: , a4 JTF_VARCHAR2_TABLE_100
141: , a5 JTF_NUMBER_TABLE
142: , a6 JTF_VARCHAR2_TABLE_100
143: , a7 JTF_VARCHAR2_TABLE_100
144: , a8 JTF_NUMBER_TABLE
145: , a9 JTF_VARCHAR2_TABLE_100
146: , a10 JTF_VARCHAR2_TABLE_100

Line 143: , a7 JTF_VARCHAR2_TABLE_100

139: , a3 JTF_NUMBER_TABLE
140: , a4 JTF_VARCHAR2_TABLE_100
141: , a5 JTF_NUMBER_TABLE
142: , a6 JTF_VARCHAR2_TABLE_100
143: , a7 JTF_VARCHAR2_TABLE_100
144: , a8 JTF_NUMBER_TABLE
145: , a9 JTF_VARCHAR2_TABLE_100
146: , a10 JTF_VARCHAR2_TABLE_100
147: , a11 JTF_VARCHAR2_TABLE_100

Line 145: , a9 JTF_VARCHAR2_TABLE_100

141: , a5 JTF_NUMBER_TABLE
142: , a6 JTF_VARCHAR2_TABLE_100
143: , a7 JTF_VARCHAR2_TABLE_100
144: , a8 JTF_NUMBER_TABLE
145: , a9 JTF_VARCHAR2_TABLE_100
146: , a10 JTF_VARCHAR2_TABLE_100
147: , a11 JTF_VARCHAR2_TABLE_100
148: ) as
149: ddindx binary_integer; indx binary_integer;

Line 146: , a10 JTF_VARCHAR2_TABLE_100

142: , a6 JTF_VARCHAR2_TABLE_100
143: , a7 JTF_VARCHAR2_TABLE_100
144: , a8 JTF_NUMBER_TABLE
145: , a9 JTF_VARCHAR2_TABLE_100
146: , a10 JTF_VARCHAR2_TABLE_100
147: , a11 JTF_VARCHAR2_TABLE_100
148: ) as
149: ddindx binary_integer; indx binary_integer;
150: begin

Line 147: , a11 JTF_VARCHAR2_TABLE_100

143: , a7 JTF_VARCHAR2_TABLE_100
144: , a8 JTF_NUMBER_TABLE
145: , a9 JTF_VARCHAR2_TABLE_100
146: , a10 JTF_VARCHAR2_TABLE_100
147: , a11 JTF_VARCHAR2_TABLE_100
148: ) as
149: ddindx binary_integer; indx binary_integer;
150: begin
151: if a0 is not null and a0.count=0 then

Line 182: , a1 out nocopy JTF_VARCHAR2_TABLE_100

178: end if;
179: end if;
180: end rosetta_table_copy_in_p6;
181: procedure rosetta_table_copy_out_p6(t amv_mychannel_pvt.amv_my_channel_varray_type, a0 out nocopy JTF_NUMBER_TABLE
182: , a1 out nocopy JTF_VARCHAR2_TABLE_100
183: , a2 out nocopy JTF_VARCHAR2_TABLE_100
184: , a3 out nocopy JTF_NUMBER_TABLE
185: , a4 out nocopy JTF_VARCHAR2_TABLE_100
186: , a5 out nocopy JTF_NUMBER_TABLE

Line 183: , a2 out nocopy JTF_VARCHAR2_TABLE_100

179: end if;
180: end rosetta_table_copy_in_p6;
181: procedure rosetta_table_copy_out_p6(t amv_mychannel_pvt.amv_my_channel_varray_type, a0 out nocopy JTF_NUMBER_TABLE
182: , a1 out nocopy JTF_VARCHAR2_TABLE_100
183: , a2 out nocopy JTF_VARCHAR2_TABLE_100
184: , a3 out nocopy JTF_NUMBER_TABLE
185: , a4 out nocopy JTF_VARCHAR2_TABLE_100
186: , a5 out nocopy JTF_NUMBER_TABLE
187: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 185: , a4 out nocopy JTF_VARCHAR2_TABLE_100

181: procedure rosetta_table_copy_out_p6(t amv_mychannel_pvt.amv_my_channel_varray_type, a0 out nocopy JTF_NUMBER_TABLE
182: , a1 out nocopy JTF_VARCHAR2_TABLE_100
183: , a2 out nocopy JTF_VARCHAR2_TABLE_100
184: , a3 out nocopy JTF_NUMBER_TABLE
185: , a4 out nocopy JTF_VARCHAR2_TABLE_100
186: , a5 out nocopy JTF_NUMBER_TABLE
187: , a6 out nocopy JTF_VARCHAR2_TABLE_100
188: , a7 out nocopy JTF_VARCHAR2_TABLE_100
189: , a8 out nocopy JTF_NUMBER_TABLE

Line 187: , a6 out nocopy JTF_VARCHAR2_TABLE_100

183: , a2 out nocopy JTF_VARCHAR2_TABLE_100
184: , a3 out nocopy JTF_NUMBER_TABLE
185: , a4 out nocopy JTF_VARCHAR2_TABLE_100
186: , a5 out nocopy JTF_NUMBER_TABLE
187: , a6 out nocopy JTF_VARCHAR2_TABLE_100
188: , a7 out nocopy JTF_VARCHAR2_TABLE_100
189: , a8 out nocopy JTF_NUMBER_TABLE
190: , a9 out nocopy JTF_VARCHAR2_TABLE_100
191: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 188: , a7 out nocopy JTF_VARCHAR2_TABLE_100

184: , a3 out nocopy JTF_NUMBER_TABLE
185: , a4 out nocopy JTF_VARCHAR2_TABLE_100
186: , a5 out nocopy JTF_NUMBER_TABLE
187: , a6 out nocopy JTF_VARCHAR2_TABLE_100
188: , a7 out nocopy JTF_VARCHAR2_TABLE_100
189: , a8 out nocopy JTF_NUMBER_TABLE
190: , a9 out nocopy JTF_VARCHAR2_TABLE_100
191: , a10 out nocopy JTF_VARCHAR2_TABLE_100
192: , a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 190: , a9 out nocopy JTF_VARCHAR2_TABLE_100

186: , a5 out nocopy JTF_NUMBER_TABLE
187: , a6 out nocopy JTF_VARCHAR2_TABLE_100
188: , a7 out nocopy JTF_VARCHAR2_TABLE_100
189: , a8 out nocopy JTF_NUMBER_TABLE
190: , a9 out nocopy JTF_VARCHAR2_TABLE_100
191: , a10 out nocopy JTF_VARCHAR2_TABLE_100
192: , a11 out nocopy JTF_VARCHAR2_TABLE_100
193: ) as
194: ddindx binary_integer; indx binary_integer;

Line 191: , a10 out nocopy JTF_VARCHAR2_TABLE_100

187: , a6 out nocopy JTF_VARCHAR2_TABLE_100
188: , a7 out nocopy JTF_VARCHAR2_TABLE_100
189: , a8 out nocopy JTF_NUMBER_TABLE
190: , a9 out nocopy JTF_VARCHAR2_TABLE_100
191: , a10 out nocopy JTF_VARCHAR2_TABLE_100
192: , a11 out nocopy JTF_VARCHAR2_TABLE_100
193: ) as
194: ddindx binary_integer; indx binary_integer;
195: begin

Line 192: , a11 out nocopy JTF_VARCHAR2_TABLE_100

188: , a7 out nocopy JTF_VARCHAR2_TABLE_100
189: , a8 out nocopy JTF_NUMBER_TABLE
190: , a9 out nocopy JTF_VARCHAR2_TABLE_100
191: , a10 out nocopy JTF_VARCHAR2_TABLE_100
192: , a11 out nocopy JTF_VARCHAR2_TABLE_100
193: ) as
194: ddindx binary_integer; indx binary_integer;
195: begin
196: if t is null then

Line 211: a1 := JTF_VARCHAR2_TABLE_100();

207: a10 := null;
208: a11 := null;
209: elsif t.count = 0 then
210: a0 := JTF_NUMBER_TABLE();
211: a1 := JTF_VARCHAR2_TABLE_100();
212: a2 := JTF_VARCHAR2_TABLE_100();
213: a3 := JTF_NUMBER_TABLE();
214: a4 := JTF_VARCHAR2_TABLE_100();
215: a5 := JTF_NUMBER_TABLE();

Line 212: a2 := JTF_VARCHAR2_TABLE_100();

208: a11 := null;
209: elsif t.count = 0 then
210: a0 := JTF_NUMBER_TABLE();
211: a1 := JTF_VARCHAR2_TABLE_100();
212: a2 := JTF_VARCHAR2_TABLE_100();
213: a3 := JTF_NUMBER_TABLE();
214: a4 := JTF_VARCHAR2_TABLE_100();
215: a5 := JTF_NUMBER_TABLE();
216: a6 := JTF_VARCHAR2_TABLE_100();

Line 214: a4 := JTF_VARCHAR2_TABLE_100();

210: a0 := JTF_NUMBER_TABLE();
211: a1 := JTF_VARCHAR2_TABLE_100();
212: a2 := JTF_VARCHAR2_TABLE_100();
213: a3 := JTF_NUMBER_TABLE();
214: a4 := JTF_VARCHAR2_TABLE_100();
215: a5 := JTF_NUMBER_TABLE();
216: a6 := JTF_VARCHAR2_TABLE_100();
217: a7 := JTF_VARCHAR2_TABLE_100();
218: a8 := JTF_NUMBER_TABLE();

Line 216: a6 := JTF_VARCHAR2_TABLE_100();

212: a2 := JTF_VARCHAR2_TABLE_100();
213: a3 := JTF_NUMBER_TABLE();
214: a4 := JTF_VARCHAR2_TABLE_100();
215: a5 := JTF_NUMBER_TABLE();
216: a6 := JTF_VARCHAR2_TABLE_100();
217: a7 := JTF_VARCHAR2_TABLE_100();
218: a8 := JTF_NUMBER_TABLE();
219: a9 := JTF_VARCHAR2_TABLE_100();
220: a10 := JTF_VARCHAR2_TABLE_100();

Line 217: a7 := JTF_VARCHAR2_TABLE_100();

213: a3 := JTF_NUMBER_TABLE();
214: a4 := JTF_VARCHAR2_TABLE_100();
215: a5 := JTF_NUMBER_TABLE();
216: a6 := JTF_VARCHAR2_TABLE_100();
217: a7 := JTF_VARCHAR2_TABLE_100();
218: a8 := JTF_NUMBER_TABLE();
219: a9 := JTF_VARCHAR2_TABLE_100();
220: a10 := JTF_VARCHAR2_TABLE_100();
221: a11 := JTF_VARCHAR2_TABLE_100();

Line 219: a9 := JTF_VARCHAR2_TABLE_100();

215: a5 := JTF_NUMBER_TABLE();
216: a6 := JTF_VARCHAR2_TABLE_100();
217: a7 := JTF_VARCHAR2_TABLE_100();
218: a8 := JTF_NUMBER_TABLE();
219: a9 := JTF_VARCHAR2_TABLE_100();
220: a10 := JTF_VARCHAR2_TABLE_100();
221: a11 := JTF_VARCHAR2_TABLE_100();
222: else
223: a0 := JTF_NUMBER_TABLE();

Line 220: a10 := JTF_VARCHAR2_TABLE_100();

216: a6 := JTF_VARCHAR2_TABLE_100();
217: a7 := JTF_VARCHAR2_TABLE_100();
218: a8 := JTF_NUMBER_TABLE();
219: a9 := JTF_VARCHAR2_TABLE_100();
220: a10 := JTF_VARCHAR2_TABLE_100();
221: a11 := JTF_VARCHAR2_TABLE_100();
222: else
223: a0 := JTF_NUMBER_TABLE();
224: a1 := JTF_VARCHAR2_TABLE_100();

Line 221: a11 := JTF_VARCHAR2_TABLE_100();

217: a7 := JTF_VARCHAR2_TABLE_100();
218: a8 := JTF_NUMBER_TABLE();
219: a9 := JTF_VARCHAR2_TABLE_100();
220: a10 := JTF_VARCHAR2_TABLE_100();
221: a11 := JTF_VARCHAR2_TABLE_100();
222: else
223: a0 := JTF_NUMBER_TABLE();
224: a1 := JTF_VARCHAR2_TABLE_100();
225: a2 := JTF_VARCHAR2_TABLE_100();

Line 224: a1 := JTF_VARCHAR2_TABLE_100();

220: a10 := JTF_VARCHAR2_TABLE_100();
221: a11 := JTF_VARCHAR2_TABLE_100();
222: else
223: a0 := JTF_NUMBER_TABLE();
224: a1 := JTF_VARCHAR2_TABLE_100();
225: a2 := JTF_VARCHAR2_TABLE_100();
226: a3 := JTF_NUMBER_TABLE();
227: a4 := JTF_VARCHAR2_TABLE_100();
228: a5 := JTF_NUMBER_TABLE();

Line 225: a2 := JTF_VARCHAR2_TABLE_100();

221: a11 := JTF_VARCHAR2_TABLE_100();
222: else
223: a0 := JTF_NUMBER_TABLE();
224: a1 := JTF_VARCHAR2_TABLE_100();
225: a2 := JTF_VARCHAR2_TABLE_100();
226: a3 := JTF_NUMBER_TABLE();
227: a4 := JTF_VARCHAR2_TABLE_100();
228: a5 := JTF_NUMBER_TABLE();
229: a6 := JTF_VARCHAR2_TABLE_100();

Line 227: a4 := JTF_VARCHAR2_TABLE_100();

223: a0 := JTF_NUMBER_TABLE();
224: a1 := JTF_VARCHAR2_TABLE_100();
225: a2 := JTF_VARCHAR2_TABLE_100();
226: a3 := JTF_NUMBER_TABLE();
227: a4 := JTF_VARCHAR2_TABLE_100();
228: a5 := JTF_NUMBER_TABLE();
229: a6 := JTF_VARCHAR2_TABLE_100();
230: a7 := JTF_VARCHAR2_TABLE_100();
231: a8 := JTF_NUMBER_TABLE();

Line 229: a6 := JTF_VARCHAR2_TABLE_100();

225: a2 := JTF_VARCHAR2_TABLE_100();
226: a3 := JTF_NUMBER_TABLE();
227: a4 := JTF_VARCHAR2_TABLE_100();
228: a5 := JTF_NUMBER_TABLE();
229: a6 := JTF_VARCHAR2_TABLE_100();
230: a7 := JTF_VARCHAR2_TABLE_100();
231: a8 := JTF_NUMBER_TABLE();
232: a9 := JTF_VARCHAR2_TABLE_100();
233: a10 := JTF_VARCHAR2_TABLE_100();

Line 230: a7 := JTF_VARCHAR2_TABLE_100();

226: a3 := JTF_NUMBER_TABLE();
227: a4 := JTF_VARCHAR2_TABLE_100();
228: a5 := JTF_NUMBER_TABLE();
229: a6 := JTF_VARCHAR2_TABLE_100();
230: a7 := JTF_VARCHAR2_TABLE_100();
231: a8 := JTF_NUMBER_TABLE();
232: a9 := JTF_VARCHAR2_TABLE_100();
233: a10 := JTF_VARCHAR2_TABLE_100();
234: a11 := JTF_VARCHAR2_TABLE_100();

Line 232: a9 := JTF_VARCHAR2_TABLE_100();

228: a5 := JTF_NUMBER_TABLE();
229: a6 := JTF_VARCHAR2_TABLE_100();
230: a7 := JTF_VARCHAR2_TABLE_100();
231: a8 := JTF_NUMBER_TABLE();
232: a9 := JTF_VARCHAR2_TABLE_100();
233: a10 := JTF_VARCHAR2_TABLE_100();
234: a11 := JTF_VARCHAR2_TABLE_100();
235: if t.count > 0 then
236: a0.extend(t.count);

Line 233: a10 := JTF_VARCHAR2_TABLE_100();

229: a6 := JTF_VARCHAR2_TABLE_100();
230: a7 := JTF_VARCHAR2_TABLE_100();
231: a8 := JTF_NUMBER_TABLE();
232: a9 := JTF_VARCHAR2_TABLE_100();
233: a10 := JTF_VARCHAR2_TABLE_100();
234: a11 := JTF_VARCHAR2_TABLE_100();
235: if t.count > 0 then
236: a0.extend(t.count);
237: a1.extend(t.count);

Line 234: a11 := JTF_VARCHAR2_TABLE_100();

230: a7 := JTF_VARCHAR2_TABLE_100();
231: a8 := JTF_NUMBER_TABLE();
232: a9 := JTF_VARCHAR2_TABLE_100();
233: a10 := JTF_VARCHAR2_TABLE_100();
234: a11 := JTF_VARCHAR2_TABLE_100();
235: if t.count > 0 then
236: a0.extend(t.count);
237: a1.extend(t.count);
238: a2.extend(t.count);

Line 278: , a5 JTF_VARCHAR2_TABLE_100

274: , a1 JTF_VARCHAR2_TABLE_4000
275: , a2 JTF_DATE_TABLE
276: , a3 JTF_DATE_TABLE
277: , a4 JTF_DATE_TABLE
278: , a5 JTF_VARCHAR2_TABLE_100
279: , a6 JTF_NUMBER_TABLE
280: , a7 JTF_VARCHAR2_TABLE_100
281: ) as
282: ddindx binary_integer; indx binary_integer;

Line 280: , a7 JTF_VARCHAR2_TABLE_100

276: , a3 JTF_DATE_TABLE
277: , a4 JTF_DATE_TABLE
278: , a5 JTF_VARCHAR2_TABLE_100
279: , a6 JTF_NUMBER_TABLE
280: , a7 JTF_VARCHAR2_TABLE_100
281: ) as
282: ddindx binary_integer; indx binary_integer;
283: begin
284: if a0 is not null and a0.count=0 then

Line 315: , a5 out nocopy JTF_VARCHAR2_TABLE_100

311: , a1 out nocopy JTF_VARCHAR2_TABLE_4000
312: , a2 out nocopy JTF_DATE_TABLE
313: , a3 out nocopy JTF_DATE_TABLE
314: , a4 out nocopy JTF_DATE_TABLE
315: , a5 out nocopy JTF_VARCHAR2_TABLE_100
316: , a6 out nocopy JTF_NUMBER_TABLE
317: , a7 out nocopy JTF_VARCHAR2_TABLE_100
318: ) as
319: ddindx binary_integer; indx binary_integer;

Line 317: , a7 out nocopy JTF_VARCHAR2_TABLE_100

313: , a3 out nocopy JTF_DATE_TABLE
314: , a4 out nocopy JTF_DATE_TABLE
315: , a5 out nocopy JTF_VARCHAR2_TABLE_100
316: , a6 out nocopy JTF_NUMBER_TABLE
317: , a7 out nocopy JTF_VARCHAR2_TABLE_100
318: ) as
319: ddindx binary_integer; indx binary_integer;
320: begin
321: if t is null then

Line 336: a5 := JTF_VARCHAR2_TABLE_100();

332: a1 := JTF_VARCHAR2_TABLE_4000();
333: a2 := JTF_DATE_TABLE();
334: a3 := JTF_DATE_TABLE();
335: a4 := JTF_DATE_TABLE();
336: a5 := JTF_VARCHAR2_TABLE_100();
337: a6 := JTF_NUMBER_TABLE();
338: a7 := JTF_VARCHAR2_TABLE_100();
339: else
340: a0 := JTF_NUMBER_TABLE();

Line 338: a7 := JTF_VARCHAR2_TABLE_100();

334: a3 := JTF_DATE_TABLE();
335: a4 := JTF_DATE_TABLE();
336: a5 := JTF_VARCHAR2_TABLE_100();
337: a6 := JTF_NUMBER_TABLE();
338: a7 := JTF_VARCHAR2_TABLE_100();
339: else
340: a0 := JTF_NUMBER_TABLE();
341: a1 := JTF_VARCHAR2_TABLE_4000();
342: a2 := JTF_DATE_TABLE();

Line 345: a5 := JTF_VARCHAR2_TABLE_100();

341: a1 := JTF_VARCHAR2_TABLE_4000();
342: a2 := JTF_DATE_TABLE();
343: a3 := JTF_DATE_TABLE();
344: a4 := JTF_DATE_TABLE();
345: a5 := JTF_VARCHAR2_TABLE_100();
346: a6 := JTF_NUMBER_TABLE();
347: a7 := JTF_VARCHAR2_TABLE_100();
348: if t.count > 0 then
349: a0.extend(t.count);

Line 347: a7 := JTF_VARCHAR2_TABLE_100();

343: a3 := JTF_DATE_TABLE();
344: a4 := JTF_DATE_TABLE();
345: a5 := JTF_VARCHAR2_TABLE_100();
346: a6 := JTF_NUMBER_TABLE();
347: a7 := JTF_VARCHAR2_TABLE_100();
348: if t.count > 0 then
349: a0.extend(t.count);
350: a1.extend(t.count);
351: a2.extend(t.count);

Line 381: , a3 JTF_VARCHAR2_TABLE_100

377:
378: procedure rosetta_table_copy_in_p10(t out nocopy amv_mychannel_pvt.amv_itemdisplay_varray_type, a0 JTF_NUMBER_TABLE
379: , a1 JTF_VARCHAR2_TABLE_300
380: , a2 JTF_VARCHAR2_TABLE_2000
381: , a3 JTF_VARCHAR2_TABLE_100
382: ) as
383: ddindx binary_integer; indx binary_integer;
384: begin
385: if a0 is not null and a0.count=0 then

Line 410: , a3 out nocopy JTF_VARCHAR2_TABLE_100

406: end rosetta_table_copy_in_p10;
407: procedure rosetta_table_copy_out_p10(t amv_mychannel_pvt.amv_itemdisplay_varray_type, a0 out nocopy JTF_NUMBER_TABLE
408: , a1 out nocopy JTF_VARCHAR2_TABLE_300
409: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
410: , a3 out nocopy JTF_VARCHAR2_TABLE_100
411: ) as
412: ddindx binary_integer; indx binary_integer;
413: begin
414: if t is null then

Line 423: a3 := JTF_VARCHAR2_TABLE_100();

419: elsif t.count = 0 then
420: a0 := JTF_NUMBER_TABLE();
421: a1 := JTF_VARCHAR2_TABLE_300();
422: a2 := JTF_VARCHAR2_TABLE_2000();
423: a3 := JTF_VARCHAR2_TABLE_100();
424: else
425: a0 := JTF_NUMBER_TABLE();
426: a1 := JTF_VARCHAR2_TABLE_300();
427: a2 := JTF_VARCHAR2_TABLE_2000();

Line 428: a3 := JTF_VARCHAR2_TABLE_100();

424: else
425: a0 := JTF_NUMBER_TABLE();
426: a1 := JTF_VARCHAR2_TABLE_300();
427: a2 := JTF_VARCHAR2_TABLE_2000();
428: a3 := JTF_VARCHAR2_TABLE_100();
429: if t.count > 0 then
430: a0.extend(t.count);
431: a1.extend(t.count);
432: a2.extend(t.count);

Line 606: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100

602: , x_msg_data out nocopy VARCHAR2
603: , p_check_login_user VARCHAR2
604: , p_user_id NUMBER
605: , p8_a0 out nocopy JTF_NUMBER_TABLE
606: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
607: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
608: , p8_a3 out nocopy JTF_NUMBER_TABLE
609: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
610: , p8_a5 out nocopy JTF_NUMBER_TABLE

Line 607: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100

603: , p_check_login_user VARCHAR2
604: , p_user_id NUMBER
605: , p8_a0 out nocopy JTF_NUMBER_TABLE
606: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
607: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
608: , p8_a3 out nocopy JTF_NUMBER_TABLE
609: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
610: , p8_a5 out nocopy JTF_NUMBER_TABLE
611: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 609: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100

605: , p8_a0 out nocopy JTF_NUMBER_TABLE
606: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
607: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
608: , p8_a3 out nocopy JTF_NUMBER_TABLE
609: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
610: , p8_a5 out nocopy JTF_NUMBER_TABLE
611: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
612: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
613: , p8_a8 out nocopy JTF_NUMBER_TABLE

Line 611: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100

607: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
608: , p8_a3 out nocopy JTF_NUMBER_TABLE
609: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
610: , p8_a5 out nocopy JTF_NUMBER_TABLE
611: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
612: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
613: , p8_a8 out nocopy JTF_NUMBER_TABLE
614: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
615: , p8_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 612: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100

608: , p8_a3 out nocopy JTF_NUMBER_TABLE
609: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
610: , p8_a5 out nocopy JTF_NUMBER_TABLE
611: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
612: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
613: , p8_a8 out nocopy JTF_NUMBER_TABLE
614: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
615: , p8_a10 out nocopy JTF_VARCHAR2_TABLE_100
616: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 614: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100

610: , p8_a5 out nocopy JTF_NUMBER_TABLE
611: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
612: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
613: , p8_a8 out nocopy JTF_NUMBER_TABLE
614: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
615: , p8_a10 out nocopy JTF_VARCHAR2_TABLE_100
616: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
617: )
618:

Line 615: , p8_a10 out nocopy JTF_VARCHAR2_TABLE_100

611: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
612: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
613: , p8_a8 out nocopy JTF_NUMBER_TABLE
614: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
615: , p8_a10 out nocopy JTF_VARCHAR2_TABLE_100
616: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
617: )
618:
619: as

Line 616: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100

612: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
613: , p8_a8 out nocopy JTF_NUMBER_TABLE
614: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
615: , p8_a10 out nocopy JTF_VARCHAR2_TABLE_100
616: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
617: )
618:
619: as
620: ddx_mychannel_array amv_mychannel_pvt.amv_my_channel_varray_type;

Line 739: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100

735: , p12_a1 out nocopy JTF_VARCHAR2_TABLE_4000
736: , p12_a2 out nocopy JTF_DATE_TABLE
737: , p12_a3 out nocopy JTF_DATE_TABLE
738: , p12_a4 out nocopy JTF_DATE_TABLE
739: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
740: , p12_a6 out nocopy JTF_NUMBER_TABLE
741: , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100
742: )
743:

Line 741: , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100

737: , p12_a3 out nocopy JTF_DATE_TABLE
738: , p12_a4 out nocopy JTF_DATE_TABLE
739: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
740: , p12_a6 out nocopy JTF_NUMBER_TABLE
741: , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100
742: )
743:
744: as
745: ddx_notifications_array amv_mychannel_pvt.amv_wf_notif_varray_type;

Line 891: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100

887: , p10_a2 out nocopy NUMBER
888: , p11_a0 out nocopy JTF_NUMBER_TABLE
889: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_300
890: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_2000
891: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
892: , p9_a0 NUMBER := 0-1962.0724
893: , p9_a1 NUMBER := 0-1962.0724
894: , p9_a2 VARCHAR2 := fnd_api.g_miss_char
895: )