eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMV_SEARCH_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 121: , a1 JTF_VARCHAR2_TABLE_100

117: end if;
118: end rosetta_table_copy_out_p1;
119:
120: procedure rosetta_table_copy_in_p5(t out nocopy amv_search_pvt.amv_area_varray_type, a0 JTF_NUMBER_TABLE
121: , a1 JTF_VARCHAR2_TABLE_100
122: ) as
123: ddindx binary_integer; indx binary_integer;
124: begin
125: if a0 is not null and a0.count=0 then

Line 146: , a1 out nocopy JTF_VARCHAR2_TABLE_100

142: end if;
143: end if;
144: end rosetta_table_copy_in_p5;
145: procedure rosetta_table_copy_out_p5(t amv_search_pvt.amv_area_varray_type, a0 out nocopy JTF_NUMBER_TABLE
146: , a1 out nocopy JTF_VARCHAR2_TABLE_100
147: ) as
148: ddindx binary_integer; indx binary_integer;
149: begin
150: if t is null then

Line 155: a1 := JTF_VARCHAR2_TABLE_100();

151: a0 := null;
152: a1 := null;
153: elsif t.count = 0 then
154: a0 := JTF_NUMBER_TABLE();
155: a1 := JTF_VARCHAR2_TABLE_100();
156: else
157: a0 := JTF_NUMBER_TABLE();
158: a1 := JTF_VARCHAR2_TABLE_100();
159: if t.count > 0 then

Line 158: a1 := JTF_VARCHAR2_TABLE_100();

154: a0 := JTF_NUMBER_TABLE();
155: a1 := JTF_VARCHAR2_TABLE_100();
156: else
157: a0 := JTF_NUMBER_TABLE();
158: a1 := JTF_VARCHAR2_TABLE_100();
159: if t.count > 0 then
160: a0.extend(t.count);
161: a1.extend(t.count);
162: ddindx := t.first;

Line 178: , a1 JTF_VARCHAR2_TABLE_100

174: end if;
175: end rosetta_table_copy_out_p5;
176:
177: procedure rosetta_table_copy_in_p7(t out nocopy amv_search_pvt.amv_searchrep_varray_type, a0 JTF_NUMBER_TABLE
178: , a1 JTF_VARCHAR2_TABLE_100
179: , a2 JTF_VARCHAR2_TABLE_100
180: , a3 JTF_VARCHAR2_TABLE_100
181: , a4 JTF_NUMBER_TABLE
182: ) as

Line 179: , a2 JTF_VARCHAR2_TABLE_100

175: end rosetta_table_copy_out_p5;
176:
177: procedure rosetta_table_copy_in_p7(t out nocopy amv_search_pvt.amv_searchrep_varray_type, a0 JTF_NUMBER_TABLE
178: , a1 JTF_VARCHAR2_TABLE_100
179: , a2 JTF_VARCHAR2_TABLE_100
180: , a3 JTF_VARCHAR2_TABLE_100
181: , a4 JTF_NUMBER_TABLE
182: ) as
183: ddindx binary_integer; indx binary_integer;

Line 180: , a3 JTF_VARCHAR2_TABLE_100

176:
177: procedure rosetta_table_copy_in_p7(t out nocopy amv_search_pvt.amv_searchrep_varray_type, a0 JTF_NUMBER_TABLE
178: , a1 JTF_VARCHAR2_TABLE_100
179: , a2 JTF_VARCHAR2_TABLE_100
180: , a3 JTF_VARCHAR2_TABLE_100
181: , a4 JTF_NUMBER_TABLE
182: ) as
183: ddindx binary_integer; indx binary_integer;
184: begin

Line 209: , a1 out nocopy JTF_VARCHAR2_TABLE_100

205: end if;
206: end if;
207: end rosetta_table_copy_in_p7;
208: procedure rosetta_table_copy_out_p7(t amv_search_pvt.amv_searchrep_varray_type, a0 out nocopy JTF_NUMBER_TABLE
209: , a1 out nocopy JTF_VARCHAR2_TABLE_100
210: , a2 out nocopy JTF_VARCHAR2_TABLE_100
211: , a3 out nocopy JTF_VARCHAR2_TABLE_100
212: , a4 out nocopy JTF_NUMBER_TABLE
213: ) as

Line 210: , a2 out nocopy JTF_VARCHAR2_TABLE_100

206: end if;
207: end rosetta_table_copy_in_p7;
208: procedure rosetta_table_copy_out_p7(t amv_search_pvt.amv_searchrep_varray_type, a0 out nocopy JTF_NUMBER_TABLE
209: , a1 out nocopy JTF_VARCHAR2_TABLE_100
210: , a2 out nocopy JTF_VARCHAR2_TABLE_100
211: , a3 out nocopy JTF_VARCHAR2_TABLE_100
212: , a4 out nocopy JTF_NUMBER_TABLE
213: ) as
214: ddindx binary_integer; indx binary_integer;

Line 211: , a3 out nocopy JTF_VARCHAR2_TABLE_100

207: end rosetta_table_copy_in_p7;
208: procedure rosetta_table_copy_out_p7(t amv_search_pvt.amv_searchrep_varray_type, a0 out nocopy JTF_NUMBER_TABLE
209: , a1 out nocopy JTF_VARCHAR2_TABLE_100
210: , a2 out nocopy JTF_VARCHAR2_TABLE_100
211: , a3 out nocopy JTF_VARCHAR2_TABLE_100
212: , a4 out nocopy JTF_NUMBER_TABLE
213: ) as
214: ddindx binary_integer; indx binary_integer;
215: begin

Line 224: a1 := JTF_VARCHAR2_TABLE_100();

220: a3 := null;
221: a4 := null;
222: elsif t.count = 0 then
223: a0 := JTF_NUMBER_TABLE();
224: a1 := JTF_VARCHAR2_TABLE_100();
225: a2 := JTF_VARCHAR2_TABLE_100();
226: a3 := JTF_VARCHAR2_TABLE_100();
227: a4 := JTF_NUMBER_TABLE();
228: else

Line 225: a2 := JTF_VARCHAR2_TABLE_100();

221: a4 := null;
222: elsif t.count = 0 then
223: a0 := JTF_NUMBER_TABLE();
224: a1 := JTF_VARCHAR2_TABLE_100();
225: a2 := JTF_VARCHAR2_TABLE_100();
226: a3 := JTF_VARCHAR2_TABLE_100();
227: a4 := JTF_NUMBER_TABLE();
228: else
229: a0 := JTF_NUMBER_TABLE();

Line 226: a3 := JTF_VARCHAR2_TABLE_100();

222: elsif t.count = 0 then
223: a0 := JTF_NUMBER_TABLE();
224: a1 := JTF_VARCHAR2_TABLE_100();
225: a2 := JTF_VARCHAR2_TABLE_100();
226: a3 := JTF_VARCHAR2_TABLE_100();
227: a4 := JTF_NUMBER_TABLE();
228: else
229: a0 := JTF_NUMBER_TABLE();
230: a1 := JTF_VARCHAR2_TABLE_100();

Line 230: a1 := JTF_VARCHAR2_TABLE_100();

226: a3 := JTF_VARCHAR2_TABLE_100();
227: a4 := JTF_NUMBER_TABLE();
228: else
229: a0 := JTF_NUMBER_TABLE();
230: a1 := JTF_VARCHAR2_TABLE_100();
231: a2 := JTF_VARCHAR2_TABLE_100();
232: a3 := JTF_VARCHAR2_TABLE_100();
233: a4 := JTF_NUMBER_TABLE();
234: if t.count > 0 then

Line 231: a2 := JTF_VARCHAR2_TABLE_100();

227: a4 := JTF_NUMBER_TABLE();
228: else
229: a0 := JTF_NUMBER_TABLE();
230: a1 := JTF_VARCHAR2_TABLE_100();
231: a2 := JTF_VARCHAR2_TABLE_100();
232: a3 := JTF_VARCHAR2_TABLE_100();
233: a4 := JTF_NUMBER_TABLE();
234: if t.count > 0 then
235: a0.extend(t.count);

Line 232: a3 := JTF_VARCHAR2_TABLE_100();

228: else
229: a0 := JTF_NUMBER_TABLE();
230: a1 := JTF_VARCHAR2_TABLE_100();
231: a2 := JTF_VARCHAR2_TABLE_100();
232: a3 := JTF_VARCHAR2_TABLE_100();
233: a4 := JTF_NUMBER_TABLE();
234: if t.count > 0 then
235: a0.extend(t.count);
236: a1.extend(t.count);

Line 259: , a1 JTF_VARCHAR2_TABLE_100

255: end if;
256: end rosetta_table_copy_out_p7;
257:
258: procedure rosetta_table_copy_in_p9(t out nocopy amv_search_pvt.amv_searchara_varray_type, a0 JTF_NUMBER_TABLE
259: , a1 JTF_VARCHAR2_TABLE_100
260: , a2 JTF_VARCHAR2_TABLE_100
261: , a3 JTF_NUMBER_TABLE
262: , a4 JTF_VARCHAR2_TABLE_100
263: , a5 JTF_VARCHAR2_TABLE_100

Line 260: , a2 JTF_VARCHAR2_TABLE_100

256: end rosetta_table_copy_out_p7;
257:
258: procedure rosetta_table_copy_in_p9(t out nocopy amv_search_pvt.amv_searchara_varray_type, a0 JTF_NUMBER_TABLE
259: , a1 JTF_VARCHAR2_TABLE_100
260: , a2 JTF_VARCHAR2_TABLE_100
261: , a3 JTF_NUMBER_TABLE
262: , a4 JTF_VARCHAR2_TABLE_100
263: , a5 JTF_VARCHAR2_TABLE_100
264: , a6 JTF_VARCHAR2_TABLE_100

Line 262: , a4 JTF_VARCHAR2_TABLE_100

258: procedure rosetta_table_copy_in_p9(t out nocopy amv_search_pvt.amv_searchara_varray_type, a0 JTF_NUMBER_TABLE
259: , a1 JTF_VARCHAR2_TABLE_100
260: , a2 JTF_VARCHAR2_TABLE_100
261: , a3 JTF_NUMBER_TABLE
262: , a4 JTF_VARCHAR2_TABLE_100
263: , a5 JTF_VARCHAR2_TABLE_100
264: , a6 JTF_VARCHAR2_TABLE_100
265: , a7 JTF_NUMBER_TABLE
266: ) as

Line 263: , a5 JTF_VARCHAR2_TABLE_100

259: , a1 JTF_VARCHAR2_TABLE_100
260: , a2 JTF_VARCHAR2_TABLE_100
261: , a3 JTF_NUMBER_TABLE
262: , a4 JTF_VARCHAR2_TABLE_100
263: , a5 JTF_VARCHAR2_TABLE_100
264: , a6 JTF_VARCHAR2_TABLE_100
265: , a7 JTF_NUMBER_TABLE
266: ) as
267: ddindx binary_integer; indx binary_integer;

Line 264: , a6 JTF_VARCHAR2_TABLE_100

260: , a2 JTF_VARCHAR2_TABLE_100
261: , a3 JTF_NUMBER_TABLE
262: , a4 JTF_VARCHAR2_TABLE_100
263: , a5 JTF_VARCHAR2_TABLE_100
264: , a6 JTF_VARCHAR2_TABLE_100
265: , a7 JTF_NUMBER_TABLE
266: ) as
267: ddindx binary_integer; indx binary_integer;
268: begin

Line 296: , a1 out nocopy JTF_VARCHAR2_TABLE_100

292: end if;
293: end if;
294: end rosetta_table_copy_in_p9;
295: procedure rosetta_table_copy_out_p9(t amv_search_pvt.amv_searchara_varray_type, a0 out nocopy JTF_NUMBER_TABLE
296: , a1 out nocopy JTF_VARCHAR2_TABLE_100
297: , a2 out nocopy JTF_VARCHAR2_TABLE_100
298: , a3 out nocopy JTF_NUMBER_TABLE
299: , a4 out nocopy JTF_VARCHAR2_TABLE_100
300: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 297: , a2 out nocopy JTF_VARCHAR2_TABLE_100

293: end if;
294: end rosetta_table_copy_in_p9;
295: procedure rosetta_table_copy_out_p9(t amv_search_pvt.amv_searchara_varray_type, a0 out nocopy JTF_NUMBER_TABLE
296: , a1 out nocopy JTF_VARCHAR2_TABLE_100
297: , a2 out nocopy JTF_VARCHAR2_TABLE_100
298: , a3 out nocopy JTF_NUMBER_TABLE
299: , a4 out nocopy JTF_VARCHAR2_TABLE_100
300: , a5 out nocopy JTF_VARCHAR2_TABLE_100
301: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 299: , a4 out nocopy JTF_VARCHAR2_TABLE_100

295: procedure rosetta_table_copy_out_p9(t amv_search_pvt.amv_searchara_varray_type, a0 out nocopy JTF_NUMBER_TABLE
296: , a1 out nocopy JTF_VARCHAR2_TABLE_100
297: , a2 out nocopy JTF_VARCHAR2_TABLE_100
298: , a3 out nocopy JTF_NUMBER_TABLE
299: , a4 out nocopy JTF_VARCHAR2_TABLE_100
300: , a5 out nocopy JTF_VARCHAR2_TABLE_100
301: , a6 out nocopy JTF_VARCHAR2_TABLE_100
302: , a7 out nocopy JTF_NUMBER_TABLE
303: ) as

Line 300: , a5 out nocopy JTF_VARCHAR2_TABLE_100

296: , a1 out nocopy JTF_VARCHAR2_TABLE_100
297: , a2 out nocopy JTF_VARCHAR2_TABLE_100
298: , a3 out nocopy JTF_NUMBER_TABLE
299: , a4 out nocopy JTF_VARCHAR2_TABLE_100
300: , a5 out nocopy JTF_VARCHAR2_TABLE_100
301: , a6 out nocopy JTF_VARCHAR2_TABLE_100
302: , a7 out nocopy JTF_NUMBER_TABLE
303: ) as
304: ddindx binary_integer; indx binary_integer;

Line 301: , a6 out nocopy JTF_VARCHAR2_TABLE_100

297: , a2 out nocopy JTF_VARCHAR2_TABLE_100
298: , a3 out nocopy JTF_NUMBER_TABLE
299: , a4 out nocopy JTF_VARCHAR2_TABLE_100
300: , a5 out nocopy JTF_VARCHAR2_TABLE_100
301: , a6 out nocopy JTF_VARCHAR2_TABLE_100
302: , a7 out nocopy JTF_NUMBER_TABLE
303: ) as
304: ddindx binary_integer; indx binary_integer;
305: begin

Line 317: a1 := JTF_VARCHAR2_TABLE_100();

313: a6 := null;
314: a7 := null;
315: elsif t.count = 0 then
316: a0 := JTF_NUMBER_TABLE();
317: a1 := JTF_VARCHAR2_TABLE_100();
318: a2 := JTF_VARCHAR2_TABLE_100();
319: a3 := JTF_NUMBER_TABLE();
320: a4 := JTF_VARCHAR2_TABLE_100();
321: a5 := JTF_VARCHAR2_TABLE_100();

Line 318: a2 := JTF_VARCHAR2_TABLE_100();

314: a7 := null;
315: elsif t.count = 0 then
316: a0 := JTF_NUMBER_TABLE();
317: a1 := JTF_VARCHAR2_TABLE_100();
318: a2 := JTF_VARCHAR2_TABLE_100();
319: a3 := JTF_NUMBER_TABLE();
320: a4 := JTF_VARCHAR2_TABLE_100();
321: a5 := JTF_VARCHAR2_TABLE_100();
322: a6 := JTF_VARCHAR2_TABLE_100();

Line 320: a4 := JTF_VARCHAR2_TABLE_100();

316: a0 := JTF_NUMBER_TABLE();
317: a1 := JTF_VARCHAR2_TABLE_100();
318: a2 := JTF_VARCHAR2_TABLE_100();
319: a3 := JTF_NUMBER_TABLE();
320: a4 := JTF_VARCHAR2_TABLE_100();
321: a5 := JTF_VARCHAR2_TABLE_100();
322: a6 := JTF_VARCHAR2_TABLE_100();
323: a7 := JTF_NUMBER_TABLE();
324: else

Line 321: a5 := JTF_VARCHAR2_TABLE_100();

317: a1 := JTF_VARCHAR2_TABLE_100();
318: a2 := JTF_VARCHAR2_TABLE_100();
319: a3 := JTF_NUMBER_TABLE();
320: a4 := JTF_VARCHAR2_TABLE_100();
321: a5 := JTF_VARCHAR2_TABLE_100();
322: a6 := JTF_VARCHAR2_TABLE_100();
323: a7 := JTF_NUMBER_TABLE();
324: else
325: a0 := JTF_NUMBER_TABLE();

Line 322: a6 := JTF_VARCHAR2_TABLE_100();

318: a2 := JTF_VARCHAR2_TABLE_100();
319: a3 := JTF_NUMBER_TABLE();
320: a4 := JTF_VARCHAR2_TABLE_100();
321: a5 := JTF_VARCHAR2_TABLE_100();
322: a6 := JTF_VARCHAR2_TABLE_100();
323: a7 := JTF_NUMBER_TABLE();
324: else
325: a0 := JTF_NUMBER_TABLE();
326: a1 := JTF_VARCHAR2_TABLE_100();

Line 326: a1 := JTF_VARCHAR2_TABLE_100();

322: a6 := JTF_VARCHAR2_TABLE_100();
323: a7 := JTF_NUMBER_TABLE();
324: else
325: a0 := JTF_NUMBER_TABLE();
326: a1 := JTF_VARCHAR2_TABLE_100();
327: a2 := JTF_VARCHAR2_TABLE_100();
328: a3 := JTF_NUMBER_TABLE();
329: a4 := JTF_VARCHAR2_TABLE_100();
330: a5 := JTF_VARCHAR2_TABLE_100();

Line 327: a2 := JTF_VARCHAR2_TABLE_100();

323: a7 := JTF_NUMBER_TABLE();
324: else
325: a0 := JTF_NUMBER_TABLE();
326: a1 := JTF_VARCHAR2_TABLE_100();
327: a2 := JTF_VARCHAR2_TABLE_100();
328: a3 := JTF_NUMBER_TABLE();
329: a4 := JTF_VARCHAR2_TABLE_100();
330: a5 := JTF_VARCHAR2_TABLE_100();
331: a6 := JTF_VARCHAR2_TABLE_100();

Line 329: a4 := JTF_VARCHAR2_TABLE_100();

325: a0 := JTF_NUMBER_TABLE();
326: a1 := JTF_VARCHAR2_TABLE_100();
327: a2 := JTF_VARCHAR2_TABLE_100();
328: a3 := JTF_NUMBER_TABLE();
329: a4 := JTF_VARCHAR2_TABLE_100();
330: a5 := JTF_VARCHAR2_TABLE_100();
331: a6 := JTF_VARCHAR2_TABLE_100();
332: a7 := JTF_NUMBER_TABLE();
333: if t.count > 0 then

Line 330: a5 := JTF_VARCHAR2_TABLE_100();

326: a1 := JTF_VARCHAR2_TABLE_100();
327: a2 := JTF_VARCHAR2_TABLE_100();
328: a3 := JTF_NUMBER_TABLE();
329: a4 := JTF_VARCHAR2_TABLE_100();
330: a5 := JTF_VARCHAR2_TABLE_100();
331: a6 := JTF_VARCHAR2_TABLE_100();
332: a7 := JTF_NUMBER_TABLE();
333: if t.count > 0 then
334: a0.extend(t.count);

Line 331: a6 := JTF_VARCHAR2_TABLE_100();

327: a2 := JTF_VARCHAR2_TABLE_100();
328: a3 := JTF_NUMBER_TABLE();
329: a4 := JTF_VARCHAR2_TABLE_100();
330: a5 := JTF_VARCHAR2_TABLE_100();
331: a6 := JTF_VARCHAR2_TABLE_100();
332: a7 := JTF_NUMBER_TABLE();
333: if t.count > 0 then
334: a0.extend(t.count);
335: a1.extend(t.count);

Line 363: procedure rosetta_table_copy_in_p11(t out nocopy amv_search_pvt.amv_searchpar_varray_type, a0 JTF_VARCHAR2_TABLE_100

359: end if;
360: end if;
361: end rosetta_table_copy_out_p9;
362:
363: procedure rosetta_table_copy_in_p11(t out nocopy amv_search_pvt.amv_searchpar_varray_type, a0 JTF_VARCHAR2_TABLE_100
364: , a1 JTF_VARCHAR2_TABLE_400
365: ) as
366: ddindx binary_integer; indx binary_integer;
367: begin

Line 388: procedure rosetta_table_copy_out_p11(t amv_search_pvt.amv_searchpar_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

384: end loop;
385: end if;
386: end if;
387: end rosetta_table_copy_in_p11;
388: procedure rosetta_table_copy_out_p11(t amv_search_pvt.amv_searchpar_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
389: , a1 out nocopy JTF_VARCHAR2_TABLE_400
390: ) as
391: ddindx binary_integer; indx binary_integer;
392: begin

Line 397: a0 := JTF_VARCHAR2_TABLE_100();

393: if t is null then
394: a0 := null;
395: a1 := null;
396: elsif t.count = 0 then
397: a0 := JTF_VARCHAR2_TABLE_100();
398: a1 := JTF_VARCHAR2_TABLE_400();
399: else
400: a0 := JTF_VARCHAR2_TABLE_100();
401: a1 := JTF_VARCHAR2_TABLE_400();

Line 400: a0 := JTF_VARCHAR2_TABLE_100();

396: elsif t.count = 0 then
397: a0 := JTF_VARCHAR2_TABLE_100();
398: a1 := JTF_VARCHAR2_TABLE_400();
399: else
400: a0 := JTF_VARCHAR2_TABLE_100();
401: a1 := JTF_VARCHAR2_TABLE_400();
402: if t.count > 0 then
403: a0.extend(t.count);
404: a1.extend(t.count);

Line 425: , a5 JTF_VARCHAR2_TABLE_100

421: , a1 JTF_VARCHAR2_TABLE_2000
422: , a2 JTF_VARCHAR2_TABLE_4000
423: , a3 JTF_NUMBER_TABLE
424: , a4 JTF_NUMBER_TABLE
425: , a5 JTF_VARCHAR2_TABLE_100
426: , a6 JTF_VARCHAR2_TABLE_300
427: , a7 JTF_VARCHAR2_TABLE_300
428: , a8 JTF_VARCHAR2_TABLE_300
429: ) as

Line 464: , a5 out nocopy JTF_VARCHAR2_TABLE_100

460: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
461: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
462: , a3 out nocopy JTF_NUMBER_TABLE
463: , a4 out nocopy JTF_NUMBER_TABLE
464: , a5 out nocopy JTF_VARCHAR2_TABLE_100
465: , a6 out nocopy JTF_VARCHAR2_TABLE_300
466: , a7 out nocopy JTF_VARCHAR2_TABLE_300
467: , a8 out nocopy JTF_VARCHAR2_TABLE_300
468: ) as

Line 487: a5 := JTF_VARCHAR2_TABLE_100();

483: a1 := JTF_VARCHAR2_TABLE_2000();
484: a2 := JTF_VARCHAR2_TABLE_4000();
485: a3 := JTF_NUMBER_TABLE();
486: a4 := JTF_NUMBER_TABLE();
487: a5 := JTF_VARCHAR2_TABLE_100();
488: a6 := JTF_VARCHAR2_TABLE_300();
489: a7 := JTF_VARCHAR2_TABLE_300();
490: a8 := JTF_VARCHAR2_TABLE_300();
491: else

Line 497: a5 := JTF_VARCHAR2_TABLE_100();

493: a1 := JTF_VARCHAR2_TABLE_2000();
494: a2 := JTF_VARCHAR2_TABLE_4000();
495: a3 := JTF_NUMBER_TABLE();
496: a4 := JTF_NUMBER_TABLE();
497: a5 := JTF_VARCHAR2_TABLE_100();
498: a6 := JTF_VARCHAR2_TABLE_300();
499: a7 := JTF_VARCHAR2_TABLE_300();
500: a8 := JTF_VARCHAR2_TABLE_300();
501: if t.count > 0 then

Line 546: , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100

542: , p_repository_code VARCHAR2
543: , p_repository_name VARCHAR2
544: , p_status VARCHAR2
545: , p12_a0 out nocopy JTF_NUMBER_TABLE
546: , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100
547: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_100
548: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
549: , p12_a4 out nocopy JTF_NUMBER_TABLE
550: )

Line 547: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_100

543: , p_repository_name VARCHAR2
544: , p_status VARCHAR2
545: , p12_a0 out nocopy JTF_NUMBER_TABLE
546: , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100
547: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_100
548: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
549: , p12_a4 out nocopy JTF_NUMBER_TABLE
550: )
551:

Line 548: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100

544: , p_status VARCHAR2
545: , p12_a0 out nocopy JTF_NUMBER_TABLE
546: , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100
547: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_100
548: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
549: , p12_a4 out nocopy JTF_NUMBER_TABLE
550: )
551:
552: as

Line 615: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100

611: , x_msg_count out nocopy NUMBER
612: , x_msg_data out nocopy VARCHAR2
613: , p_check_login_user VARCHAR2
614: , p8_a0 out nocopy JTF_NUMBER_TABLE
615: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
616: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
617: , p8_a3 out nocopy JTF_NUMBER_TABLE
618: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
619: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 616: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100

612: , x_msg_data out nocopy VARCHAR2
613: , p_check_login_user VARCHAR2
614: , p8_a0 out nocopy JTF_NUMBER_TABLE
615: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
616: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
617: , p8_a3 out nocopy JTF_NUMBER_TABLE
618: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
619: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
620: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 618: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100

614: , p8_a0 out nocopy JTF_NUMBER_TABLE
615: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
616: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
617: , p8_a3 out nocopy JTF_NUMBER_TABLE
618: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
619: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
620: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
621: , p8_a7 out nocopy JTF_NUMBER_TABLE
622: , p7_a0 NUMBER := 0-1962.0724

Line 619: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100

615: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
616: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
617: , p8_a3 out nocopy JTF_NUMBER_TABLE
618: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
619: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
620: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
621: , p8_a7 out nocopy JTF_NUMBER_TABLE
622: , p7_a0 NUMBER := 0-1962.0724
623: , p7_a1 VARCHAR2 := fnd_api.g_miss_char

Line 620: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100

616: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
617: , p8_a3 out nocopy JTF_NUMBER_TABLE
618: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
619: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
620: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
621: , p8_a7 out nocopy JTF_NUMBER_TABLE
622: , p7_a0 NUMBER := 0-1962.0724
623: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
624: , p7_a2 VARCHAR2 := fnd_api.g_miss_char

Line 697: , p10_a0 JTF_VARCHAR2_TABLE_100

693: , p_check_login_user VARCHAR2
694: , p_application_id NUMBER
695: , p_area_array JTF_VARCHAR2_TABLE_4000
696: , p_content_array JTF_VARCHAR2_TABLE_4000
697: , p10_a0 JTF_VARCHAR2_TABLE_100
698: , p10_a1 JTF_VARCHAR2_TABLE_400
699: , p_imt_string VARCHAR2
700: , p_days NUMBER
701: , p_user_id NUMBER

Line 713: , p19_a5 out nocopy JTF_VARCHAR2_TABLE_100

709: , p19_a1 out nocopy JTF_VARCHAR2_TABLE_2000
710: , p19_a2 out nocopy JTF_VARCHAR2_TABLE_4000
711: , p19_a3 out nocopy JTF_NUMBER_TABLE
712: , p19_a4 out nocopy JTF_NUMBER_TABLE
713: , p19_a5 out nocopy JTF_VARCHAR2_TABLE_100
714: , p19_a6 out nocopy JTF_VARCHAR2_TABLE_300
715: , p19_a7 out nocopy JTF_VARCHAR2_TABLE_300
716: , p19_a8 out nocopy JTF_VARCHAR2_TABLE_300
717: , p17_a0 NUMBER := 0-1962.0724