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.DPP_UIWRAPPER_PVT_W dependencies on JTF_NUMBER_TABLE

Line 53: procedure rosetta_table_copy_in_p7(t out nocopy dpp_uiwrapper_pvt.vendor_tbl_type, a0 JTF_NUMBER_TABLE

49: end if;
50: end if;
51: end rosetta_table_copy_out_p5;
52:
53: procedure rosetta_table_copy_in_p7(t out nocopy dpp_uiwrapper_pvt.vendor_tbl_type, a0 JTF_NUMBER_TABLE
54: , a1 JTF_VARCHAR2_TABLE_100
55: , a2 JTF_VARCHAR2_TABLE_300
56: ) as
57: ddindx binary_integer; indx binary_integer;

Line 76: procedure rosetta_table_copy_out_p7(t dpp_uiwrapper_pvt.vendor_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

72: end loop;
73: end if;
74: end if;
75: end rosetta_table_copy_in_p7;
76: procedure rosetta_table_copy_out_p7(t dpp_uiwrapper_pvt.vendor_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
77: , a1 out nocopy JTF_VARCHAR2_TABLE_100
78: , a2 out nocopy JTF_VARCHAR2_TABLE_300
79: ) as
80: ddindx binary_integer; indx binary_integer;

Line 83: a0 := JTF_NUMBER_TABLE();

79: ) as
80: ddindx binary_integer; indx binary_integer;
81: begin
82: if t is null or t.count = 0 then
83: a0 := JTF_NUMBER_TABLE();
84: a1 := JTF_VARCHAR2_TABLE_100();
85: a2 := JTF_VARCHAR2_TABLE_300();
86: else
87: a0 := JTF_NUMBER_TABLE();

Line 87: a0 := JTF_NUMBER_TABLE();

83: a0 := JTF_NUMBER_TABLE();
84: a1 := JTF_VARCHAR2_TABLE_100();
85: a2 := JTF_VARCHAR2_TABLE_300();
86: else
87: a0 := JTF_NUMBER_TABLE();
88: a1 := JTF_VARCHAR2_TABLE_100();
89: a2 := JTF_VARCHAR2_TABLE_300();
90: if t.count > 0 then
91: a0.extend(t.count);

Line 110: procedure rosetta_table_copy_in_p9(t out nocopy dpp_uiwrapper_pvt.vendor_site_tbl_type, a0 JTF_NUMBER_TABLE

106: end if;
107: end if;
108: end rosetta_table_copy_out_p7;
109:
110: procedure rosetta_table_copy_in_p9(t out nocopy dpp_uiwrapper_pvt.vendor_site_tbl_type, a0 JTF_NUMBER_TABLE
111: , a1 JTF_NUMBER_TABLE
112: , a2 JTF_VARCHAR2_TABLE_100
113: , a3 JTF_VARCHAR2_TABLE_300
114: , a4 JTF_VARCHAR2_TABLE_300

Line 111: , a1 JTF_NUMBER_TABLE

107: end if;
108: end rosetta_table_copy_out_p7;
109:
110: procedure rosetta_table_copy_in_p9(t out nocopy dpp_uiwrapper_pvt.vendor_site_tbl_type, a0 JTF_NUMBER_TABLE
111: , a1 JTF_NUMBER_TABLE
112: , a2 JTF_VARCHAR2_TABLE_100
113: , a3 JTF_VARCHAR2_TABLE_300
114: , a4 JTF_VARCHAR2_TABLE_300
115: , a5 JTF_VARCHAR2_TABLE_300

Line 147: procedure rosetta_table_copy_out_p9(t dpp_uiwrapper_pvt.vendor_site_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

143: end loop;
144: end if;
145: end if;
146: end rosetta_table_copy_in_p9;
147: procedure rosetta_table_copy_out_p9(t dpp_uiwrapper_pvt.vendor_site_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
148: , a1 out nocopy JTF_NUMBER_TABLE
149: , a2 out nocopy JTF_VARCHAR2_TABLE_100
150: , a3 out nocopy JTF_VARCHAR2_TABLE_300
151: , a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 148: , a1 out nocopy JTF_NUMBER_TABLE

144: end if;
145: end if;
146: end rosetta_table_copy_in_p9;
147: procedure rosetta_table_copy_out_p9(t dpp_uiwrapper_pvt.vendor_site_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
148: , a1 out nocopy JTF_NUMBER_TABLE
149: , a2 out nocopy JTF_VARCHAR2_TABLE_100
150: , a3 out nocopy JTF_VARCHAR2_TABLE_300
151: , a4 out nocopy JTF_VARCHAR2_TABLE_300
152: , a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 161: a0 := JTF_NUMBER_TABLE();

157: ) as
158: ddindx binary_integer; indx binary_integer;
159: begin
160: if t is null or t.count = 0 then
161: a0 := JTF_NUMBER_TABLE();
162: a1 := JTF_NUMBER_TABLE();
163: a2 := JTF_VARCHAR2_TABLE_100();
164: a3 := JTF_VARCHAR2_TABLE_300();
165: a4 := JTF_VARCHAR2_TABLE_300();

Line 162: a1 := JTF_NUMBER_TABLE();

158: ddindx binary_integer; indx binary_integer;
159: begin
160: if t is null or t.count = 0 then
161: a0 := JTF_NUMBER_TABLE();
162: a1 := JTF_NUMBER_TABLE();
163: a2 := JTF_VARCHAR2_TABLE_100();
164: a3 := JTF_VARCHAR2_TABLE_300();
165: a4 := JTF_VARCHAR2_TABLE_300();
166: a5 := JTF_VARCHAR2_TABLE_300();

Line 172: a0 := JTF_NUMBER_TABLE();

168: a7 := JTF_VARCHAR2_TABLE_200();
169: a8 := JTF_VARCHAR2_TABLE_100();
170: a9 := JTF_VARCHAR2_TABLE_100();
171: else
172: a0 := JTF_NUMBER_TABLE();
173: a1 := JTF_NUMBER_TABLE();
174: a2 := JTF_VARCHAR2_TABLE_100();
175: a3 := JTF_VARCHAR2_TABLE_300();
176: a4 := JTF_VARCHAR2_TABLE_300();

Line 173: a1 := JTF_NUMBER_TABLE();

169: a8 := JTF_VARCHAR2_TABLE_100();
170: a9 := JTF_VARCHAR2_TABLE_100();
171: else
172: a0 := JTF_NUMBER_TABLE();
173: a1 := JTF_NUMBER_TABLE();
174: a2 := JTF_VARCHAR2_TABLE_100();
175: a3 := JTF_VARCHAR2_TABLE_300();
176: a4 := JTF_VARCHAR2_TABLE_300();
177: a5 := JTF_VARCHAR2_TABLE_300();

Line 216: procedure rosetta_table_copy_in_p11(t out nocopy dpp_uiwrapper_pvt.vendor_contact_tbl_type, a0 JTF_NUMBER_TABLE

212: end if;
213: end if;
214: end rosetta_table_copy_out_p9;
215:
216: procedure rosetta_table_copy_in_p11(t out nocopy dpp_uiwrapper_pvt.vendor_contact_tbl_type, a0 JTF_NUMBER_TABLE
217: , a1 JTF_NUMBER_TABLE
218: , a2 JTF_VARCHAR2_TABLE_100
219: , a3 JTF_VARCHAR2_TABLE_100
220: , a4 JTF_VARCHAR2_TABLE_100

Line 217: , a1 JTF_NUMBER_TABLE

213: end if;
214: end rosetta_table_copy_out_p9;
215:
216: procedure rosetta_table_copy_in_p11(t out nocopy dpp_uiwrapper_pvt.vendor_contact_tbl_type, a0 JTF_NUMBER_TABLE
217: , a1 JTF_NUMBER_TABLE
218: , a2 JTF_VARCHAR2_TABLE_100
219: , a3 JTF_VARCHAR2_TABLE_100
220: , a4 JTF_VARCHAR2_TABLE_100
221: , a5 JTF_VARCHAR2_TABLE_100

Line 249: procedure rosetta_table_copy_out_p11(t dpp_uiwrapper_pvt.vendor_contact_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

245: end loop;
246: end if;
247: end if;
248: end rosetta_table_copy_in_p11;
249: procedure rosetta_table_copy_out_p11(t dpp_uiwrapper_pvt.vendor_contact_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
250: , a1 out nocopy JTF_NUMBER_TABLE
251: , a2 out nocopy JTF_VARCHAR2_TABLE_100
252: , a3 out nocopy JTF_VARCHAR2_TABLE_100
253: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 250: , a1 out nocopy JTF_NUMBER_TABLE

246: end if;
247: end if;
248: end rosetta_table_copy_in_p11;
249: procedure rosetta_table_copy_out_p11(t dpp_uiwrapper_pvt.vendor_contact_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
250: , a1 out nocopy JTF_NUMBER_TABLE
251: , a2 out nocopy JTF_VARCHAR2_TABLE_100
252: , a3 out nocopy JTF_VARCHAR2_TABLE_100
253: , a4 out nocopy JTF_VARCHAR2_TABLE_100
254: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 261: a0 := JTF_NUMBER_TABLE();

257: ) as
258: ddindx binary_integer; indx binary_integer;
259: begin
260: if t is null or t.count = 0 then
261: a0 := JTF_NUMBER_TABLE();
262: a1 := JTF_NUMBER_TABLE();
263: a2 := JTF_VARCHAR2_TABLE_100();
264: a3 := JTF_VARCHAR2_TABLE_100();
265: a4 := JTF_VARCHAR2_TABLE_100();

Line 262: a1 := JTF_NUMBER_TABLE();

258: ddindx binary_integer; indx binary_integer;
259: begin
260: if t is null or t.count = 0 then
261: a0 := JTF_NUMBER_TABLE();
262: a1 := JTF_NUMBER_TABLE();
263: a2 := JTF_VARCHAR2_TABLE_100();
264: a3 := JTF_VARCHAR2_TABLE_100();
265: a4 := JTF_VARCHAR2_TABLE_100();
266: a5 := JTF_VARCHAR2_TABLE_100();

Line 270: a0 := JTF_NUMBER_TABLE();

266: a5 := JTF_VARCHAR2_TABLE_100();
267: a6 := JTF_VARCHAR2_TABLE_2000();
268: a7 := JTF_VARCHAR2_TABLE_100();
269: else
270: a0 := JTF_NUMBER_TABLE();
271: a1 := JTF_NUMBER_TABLE();
272: a2 := JTF_VARCHAR2_TABLE_100();
273: a3 := JTF_VARCHAR2_TABLE_100();
274: a4 := JTF_VARCHAR2_TABLE_100();

Line 271: a1 := JTF_NUMBER_TABLE();

267: a6 := JTF_VARCHAR2_TABLE_2000();
268: a7 := JTF_VARCHAR2_TABLE_100();
269: else
270: a0 := JTF_NUMBER_TABLE();
271: a1 := JTF_NUMBER_TABLE();
272: a2 := JTF_VARCHAR2_TABLE_100();
273: a3 := JTF_VARCHAR2_TABLE_100();
274: a4 := JTF_VARCHAR2_TABLE_100();
275: a5 := JTF_VARCHAR2_TABLE_100();

Line 308: procedure rosetta_table_copy_in_p13(t out nocopy dpp_uiwrapper_pvt.customer_tbl_type, a0 JTF_NUMBER_TABLE

304: end if;
305: end if;
306: end rosetta_table_copy_out_p11;
307:
308: procedure rosetta_table_copy_in_p13(t out nocopy dpp_uiwrapper_pvt.customer_tbl_type, a0 JTF_NUMBER_TABLE
309: , a1 JTF_VARCHAR2_TABLE_100
310: , a2 JTF_VARCHAR2_TABLE_400
311: ) as
312: ddindx binary_integer; indx binary_integer;

Line 331: procedure rosetta_table_copy_out_p13(t dpp_uiwrapper_pvt.customer_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

327: end loop;
328: end if;
329: end if;
330: end rosetta_table_copy_in_p13;
331: procedure rosetta_table_copy_out_p13(t dpp_uiwrapper_pvt.customer_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
332: , a1 out nocopy JTF_VARCHAR2_TABLE_100
333: , a2 out nocopy JTF_VARCHAR2_TABLE_400
334: ) as
335: ddindx binary_integer; indx binary_integer;

Line 338: a0 := JTF_NUMBER_TABLE();

334: ) as
335: ddindx binary_integer; indx binary_integer;
336: begin
337: if t is null or t.count = 0 then
338: a0 := JTF_NUMBER_TABLE();
339: a1 := JTF_VARCHAR2_TABLE_100();
340: a2 := JTF_VARCHAR2_TABLE_400();
341: else
342: a0 := JTF_NUMBER_TABLE();

Line 342: a0 := JTF_NUMBER_TABLE();

338: a0 := JTF_NUMBER_TABLE();
339: a1 := JTF_VARCHAR2_TABLE_100();
340: a2 := JTF_VARCHAR2_TABLE_400();
341: else
342: a0 := JTF_NUMBER_TABLE();
343: a1 := JTF_VARCHAR2_TABLE_100();
344: a2 := JTF_VARCHAR2_TABLE_400();
345: if t.count > 0 then
346: a0.extend(t.count);

Line 365: procedure rosetta_table_copy_in_p15(t out nocopy dpp_uiwrapper_pvt.item_tbl_type, a0 JTF_NUMBER_TABLE

361: end if;
362: end if;
363: end rosetta_table_copy_out_p13;
364:
365: procedure rosetta_table_copy_in_p15(t out nocopy dpp_uiwrapper_pvt.item_tbl_type, a0 JTF_NUMBER_TABLE
366: , a1 JTF_VARCHAR2_TABLE_100
367: , a2 JTF_VARCHAR2_TABLE_300
368: ) as
369: ddindx binary_integer; indx binary_integer;

Line 388: procedure rosetta_table_copy_out_p15(t dpp_uiwrapper_pvt.item_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

384: end loop;
385: end if;
386: end if;
387: end rosetta_table_copy_in_p15;
388: procedure rosetta_table_copy_out_p15(t dpp_uiwrapper_pvt.item_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
389: , a1 out nocopy JTF_VARCHAR2_TABLE_100
390: , a2 out nocopy JTF_VARCHAR2_TABLE_300
391: ) as
392: ddindx binary_integer; indx binary_integer;

Line 395: a0 := JTF_NUMBER_TABLE();

391: ) as
392: ddindx binary_integer; indx binary_integer;
393: begin
394: if t is null or t.count = 0 then
395: a0 := JTF_NUMBER_TABLE();
396: a1 := JTF_VARCHAR2_TABLE_100();
397: a2 := JTF_VARCHAR2_TABLE_300();
398: else
399: a0 := JTF_NUMBER_TABLE();

Line 399: a0 := JTF_NUMBER_TABLE();

395: a0 := JTF_NUMBER_TABLE();
396: a1 := JTF_VARCHAR2_TABLE_100();
397: a2 := JTF_VARCHAR2_TABLE_300();
398: else
399: a0 := JTF_NUMBER_TABLE();
400: a1 := JTF_VARCHAR2_TABLE_100();
401: a2 := JTF_VARCHAR2_TABLE_300();
402: if t.count > 0 then
403: a0.extend(t.count);

Line 422: procedure rosetta_table_copy_in_p17(t out nocopy dpp_uiwrapper_pvt.itemnum_tbl_type, a0 JTF_NUMBER_TABLE

418: end if;
419: end if;
420: end rosetta_table_copy_out_p15;
421:
422: procedure rosetta_table_copy_in_p17(t out nocopy dpp_uiwrapper_pvt.itemnum_tbl_type, a0 JTF_NUMBER_TABLE
423: , a1 JTF_VARCHAR2_TABLE_100
424: , a2 JTF_VARCHAR2_TABLE_300
425: , a3 JTF_VARCHAR2_TABLE_100
426: ) as

Line 447: procedure rosetta_table_copy_out_p17(t dpp_uiwrapper_pvt.itemnum_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

443: end loop;
444: end if;
445: end if;
446: end rosetta_table_copy_in_p17;
447: procedure rosetta_table_copy_out_p17(t dpp_uiwrapper_pvt.itemnum_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
448: , a1 out nocopy JTF_VARCHAR2_TABLE_100
449: , a2 out nocopy JTF_VARCHAR2_TABLE_300
450: , a3 out nocopy JTF_VARCHAR2_TABLE_100
451: ) as

Line 455: a0 := JTF_NUMBER_TABLE();

451: ) as
452: ddindx binary_integer; indx binary_integer;
453: begin
454: if t is null or t.count = 0 then
455: a0 := JTF_NUMBER_TABLE();
456: a1 := JTF_VARCHAR2_TABLE_100();
457: a2 := JTF_VARCHAR2_TABLE_300();
458: a3 := JTF_VARCHAR2_TABLE_100();
459: else

Line 460: a0 := JTF_NUMBER_TABLE();

456: a1 := JTF_VARCHAR2_TABLE_100();
457: a2 := JTF_VARCHAR2_TABLE_300();
458: a3 := JTF_VARCHAR2_TABLE_100();
459: else
460: a0 := JTF_NUMBER_TABLE();
461: a1 := JTF_VARCHAR2_TABLE_100();
462: a2 := JTF_VARCHAR2_TABLE_300();
463: a3 := JTF_VARCHAR2_TABLE_100();
464: if t.count > 0 then

Line 486: procedure rosetta_table_copy_in_p19(t out nocopy dpp_uiwrapper_pvt.warehouse_tbl_type, a0 JTF_NUMBER_TABLE

482: end if;
483: end if;
484: end rosetta_table_copy_out_p17;
485:
486: procedure rosetta_table_copy_in_p19(t out nocopy dpp_uiwrapper_pvt.warehouse_tbl_type, a0 JTF_NUMBER_TABLE
487: , a1 JTF_VARCHAR2_TABLE_100
488: , a2 JTF_VARCHAR2_TABLE_300
489: ) as
490: ddindx binary_integer; indx binary_integer;

Line 509: procedure rosetta_table_copy_out_p19(t dpp_uiwrapper_pvt.warehouse_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

505: end loop;
506: end if;
507: end if;
508: end rosetta_table_copy_in_p19;
509: procedure rosetta_table_copy_out_p19(t dpp_uiwrapper_pvt.warehouse_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
510: , a1 out nocopy JTF_VARCHAR2_TABLE_100
511: , a2 out nocopy JTF_VARCHAR2_TABLE_300
512: ) as
513: ddindx binary_integer; indx binary_integer;

Line 516: a0 := JTF_NUMBER_TABLE();

512: ) as
513: ddindx binary_integer; indx binary_integer;
514: begin
515: if t is null or t.count = 0 then
516: a0 := JTF_NUMBER_TABLE();
517: a1 := JTF_VARCHAR2_TABLE_100();
518: a2 := JTF_VARCHAR2_TABLE_300();
519: else
520: a0 := JTF_NUMBER_TABLE();

Line 520: a0 := JTF_NUMBER_TABLE();

516: a0 := JTF_NUMBER_TABLE();
517: a1 := JTF_VARCHAR2_TABLE_100();
518: a2 := JTF_VARCHAR2_TABLE_300();
519: else
520: a0 := JTF_NUMBER_TABLE();
521: a1 := JTF_VARCHAR2_TABLE_100();
522: a2 := JTF_VARCHAR2_TABLE_300();
523: if t.count > 0 then
524: a0.extend(t.count);

Line 544: , a1 JTF_NUMBER_TABLE

540: end if;
541: end rosetta_table_copy_out_p19;
542:
543: procedure rosetta_table_copy_in_p22(t out nocopy dpp_uiwrapper_pvt.dpp_inv_cov_rct_tbl_type, a0 JTF_DATE_TABLE
544: , a1 JTF_NUMBER_TABLE
545: ) as
546: ddindx binary_integer; indx binary_integer;
547: begin
548: if a0 is not null and a0.count > 0 then

Line 565: , a1 out nocopy JTF_NUMBER_TABLE

561: end if;
562: end if;
563: end rosetta_table_copy_in_p22;
564: procedure rosetta_table_copy_out_p22(t dpp_uiwrapper_pvt.dpp_inv_cov_rct_tbl_type, a0 out nocopy JTF_DATE_TABLE
565: , a1 out nocopy JTF_NUMBER_TABLE
566: ) as
567: ddindx binary_integer; indx binary_integer;
568: begin
569: if t is null or t.count = 0 then

Line 571: a1 := JTF_NUMBER_TABLE();

567: ddindx binary_integer; indx binary_integer;
568: begin
569: if t is null or t.count = 0 then
570: a0 := JTF_DATE_TABLE();
571: a1 := JTF_NUMBER_TABLE();
572: else
573: a0 := JTF_DATE_TABLE();
574: a1 := JTF_NUMBER_TABLE();
575: if t.count > 0 then

Line 574: a1 := JTF_NUMBER_TABLE();

570: a0 := JTF_DATE_TABLE();
571: a1 := JTF_NUMBER_TABLE();
572: else
573: a0 := JTF_DATE_TABLE();
574: a1 := JTF_NUMBER_TABLE();
575: if t.count > 0 then
576: a0.extend(t.count);
577: a1.extend(t.count);
578: ddindx := t.first;

Line 593: procedure rosetta_table_copy_in_p24(t out nocopy dpp_uiwrapper_pvt.inventorydetails_tbl_type, a0 JTF_NUMBER_TABLE

589: end if;
590: end if;
591: end rosetta_table_copy_out_p22;
592:
593: procedure rosetta_table_copy_in_p24(t out nocopy dpp_uiwrapper_pvt.inventorydetails_tbl_type, a0 JTF_NUMBER_TABLE
594: , a1 JTF_NUMBER_TABLE
595: , a2 JTF_VARCHAR2_TABLE_100
596: , a3 JTF_NUMBER_TABLE
597: , a4 JTF_NUMBER_TABLE

Line 594: , a1 JTF_NUMBER_TABLE

590: end if;
591: end rosetta_table_copy_out_p22;
592:
593: procedure rosetta_table_copy_in_p24(t out nocopy dpp_uiwrapper_pvt.inventorydetails_tbl_type, a0 JTF_NUMBER_TABLE
594: , a1 JTF_NUMBER_TABLE
595: , a2 JTF_VARCHAR2_TABLE_100
596: , a3 JTF_NUMBER_TABLE
597: , a4 JTF_NUMBER_TABLE
598: ) as

Line 596: , a3 JTF_NUMBER_TABLE

592:
593: procedure rosetta_table_copy_in_p24(t out nocopy dpp_uiwrapper_pvt.inventorydetails_tbl_type, a0 JTF_NUMBER_TABLE
594: , a1 JTF_NUMBER_TABLE
595: , a2 JTF_VARCHAR2_TABLE_100
596: , a3 JTF_NUMBER_TABLE
597: , a4 JTF_NUMBER_TABLE
598: ) as
599: ddindx binary_integer; indx binary_integer;
600: begin

Line 597: , a4 JTF_NUMBER_TABLE

593: procedure rosetta_table_copy_in_p24(t out nocopy dpp_uiwrapper_pvt.inventorydetails_tbl_type, a0 JTF_NUMBER_TABLE
594: , a1 JTF_NUMBER_TABLE
595: , a2 JTF_VARCHAR2_TABLE_100
596: , a3 JTF_NUMBER_TABLE
597: , a4 JTF_NUMBER_TABLE
598: ) as
599: ddindx binary_integer; indx binary_integer;
600: begin
601: if a0 is not null and a0.count > 0 then

Line 620: procedure rosetta_table_copy_out_p24(t dpp_uiwrapper_pvt.inventorydetails_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

616: end loop;
617: end if;
618: end if;
619: end rosetta_table_copy_in_p24;
620: procedure rosetta_table_copy_out_p24(t dpp_uiwrapper_pvt.inventorydetails_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
621: , a1 out nocopy JTF_NUMBER_TABLE
622: , a2 out nocopy JTF_VARCHAR2_TABLE_100
623: , a3 out nocopy JTF_NUMBER_TABLE
624: , a4 out nocopy JTF_NUMBER_TABLE

Line 621: , a1 out nocopy JTF_NUMBER_TABLE

617: end if;
618: end if;
619: end rosetta_table_copy_in_p24;
620: procedure rosetta_table_copy_out_p24(t dpp_uiwrapper_pvt.inventorydetails_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
621: , a1 out nocopy JTF_NUMBER_TABLE
622: , a2 out nocopy JTF_VARCHAR2_TABLE_100
623: , a3 out nocopy JTF_NUMBER_TABLE
624: , a4 out nocopy JTF_NUMBER_TABLE
625: ) as

Line 623: , a3 out nocopy JTF_NUMBER_TABLE

619: end rosetta_table_copy_in_p24;
620: procedure rosetta_table_copy_out_p24(t dpp_uiwrapper_pvt.inventorydetails_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
621: , a1 out nocopy JTF_NUMBER_TABLE
622: , a2 out nocopy JTF_VARCHAR2_TABLE_100
623: , a3 out nocopy JTF_NUMBER_TABLE
624: , a4 out nocopy JTF_NUMBER_TABLE
625: ) as
626: ddindx binary_integer; indx binary_integer;
627: begin

Line 624: , a4 out nocopy JTF_NUMBER_TABLE

620: procedure rosetta_table_copy_out_p24(t dpp_uiwrapper_pvt.inventorydetails_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
621: , a1 out nocopy JTF_NUMBER_TABLE
622: , a2 out nocopy JTF_VARCHAR2_TABLE_100
623: , a3 out nocopy JTF_NUMBER_TABLE
624: , a4 out nocopy JTF_NUMBER_TABLE
625: ) as
626: ddindx binary_integer; indx binary_integer;
627: begin
628: if t is null or t.count = 0 then

Line 629: a0 := JTF_NUMBER_TABLE();

625: ) as
626: ddindx binary_integer; indx binary_integer;
627: begin
628: if t is null or t.count = 0 then
629: a0 := JTF_NUMBER_TABLE();
630: a1 := JTF_NUMBER_TABLE();
631: a2 := JTF_VARCHAR2_TABLE_100();
632: a3 := JTF_NUMBER_TABLE();
633: a4 := JTF_NUMBER_TABLE();

Line 630: a1 := JTF_NUMBER_TABLE();

626: ddindx binary_integer; indx binary_integer;
627: begin
628: if t is null or t.count = 0 then
629: a0 := JTF_NUMBER_TABLE();
630: a1 := JTF_NUMBER_TABLE();
631: a2 := JTF_VARCHAR2_TABLE_100();
632: a3 := JTF_NUMBER_TABLE();
633: a4 := JTF_NUMBER_TABLE();
634: else

Line 632: a3 := JTF_NUMBER_TABLE();

628: if t is null or t.count = 0 then
629: a0 := JTF_NUMBER_TABLE();
630: a1 := JTF_NUMBER_TABLE();
631: a2 := JTF_VARCHAR2_TABLE_100();
632: a3 := JTF_NUMBER_TABLE();
633: a4 := JTF_NUMBER_TABLE();
634: else
635: a0 := JTF_NUMBER_TABLE();
636: a1 := JTF_NUMBER_TABLE();

Line 633: a4 := JTF_NUMBER_TABLE();

629: a0 := JTF_NUMBER_TABLE();
630: a1 := JTF_NUMBER_TABLE();
631: a2 := JTF_VARCHAR2_TABLE_100();
632: a3 := JTF_NUMBER_TABLE();
633: a4 := JTF_NUMBER_TABLE();
634: else
635: a0 := JTF_NUMBER_TABLE();
636: a1 := JTF_NUMBER_TABLE();
637: a2 := JTF_VARCHAR2_TABLE_100();

Line 635: a0 := JTF_NUMBER_TABLE();

631: a2 := JTF_VARCHAR2_TABLE_100();
632: a3 := JTF_NUMBER_TABLE();
633: a4 := JTF_NUMBER_TABLE();
634: else
635: a0 := JTF_NUMBER_TABLE();
636: a1 := JTF_NUMBER_TABLE();
637: a2 := JTF_VARCHAR2_TABLE_100();
638: a3 := JTF_NUMBER_TABLE();
639: a4 := JTF_NUMBER_TABLE();

Line 636: a1 := JTF_NUMBER_TABLE();

632: a3 := JTF_NUMBER_TABLE();
633: a4 := JTF_NUMBER_TABLE();
634: else
635: a0 := JTF_NUMBER_TABLE();
636: a1 := JTF_NUMBER_TABLE();
637: a2 := JTF_VARCHAR2_TABLE_100();
638: a3 := JTF_NUMBER_TABLE();
639: a4 := JTF_NUMBER_TABLE();
640: if t.count > 0 then

Line 638: a3 := JTF_NUMBER_TABLE();

634: else
635: a0 := JTF_NUMBER_TABLE();
636: a1 := JTF_NUMBER_TABLE();
637: a2 := JTF_VARCHAR2_TABLE_100();
638: a3 := JTF_NUMBER_TABLE();
639: a4 := JTF_NUMBER_TABLE();
640: if t.count > 0 then
641: a0.extend(t.count);
642: a1.extend(t.count);

Line 639: a4 := JTF_NUMBER_TABLE();

635: a0 := JTF_NUMBER_TABLE();
636: a1 := JTF_NUMBER_TABLE();
637: a2 := JTF_VARCHAR2_TABLE_100();
638: a3 := JTF_NUMBER_TABLE();
639: a4 := JTF_NUMBER_TABLE();
640: if t.count > 0 then
641: a0.extend(t.count);
642: a1.extend(t.count);
643: a2.extend(t.count);

Line 664: procedure rosetta_table_copy_in_p26(t out nocopy dpp_uiwrapper_pvt.dpp_cust_inv_tbl_type, a0 JTF_NUMBER_TABLE

660: end if;
661: end if;
662: end rosetta_table_copy_out_p24;
663:
664: procedure rosetta_table_copy_in_p26(t out nocopy dpp_uiwrapper_pvt.dpp_cust_inv_tbl_type, a0 JTF_NUMBER_TABLE
665: , a1 JTF_NUMBER_TABLE
666: , a2 JTF_VARCHAR2_TABLE_100
667: , a3 JTF_NUMBER_TABLE
668: ) as

Line 665: , a1 JTF_NUMBER_TABLE

661: end if;
662: end rosetta_table_copy_out_p24;
663:
664: procedure rosetta_table_copy_in_p26(t out nocopy dpp_uiwrapper_pvt.dpp_cust_inv_tbl_type, a0 JTF_NUMBER_TABLE
665: , a1 JTF_NUMBER_TABLE
666: , a2 JTF_VARCHAR2_TABLE_100
667: , a3 JTF_NUMBER_TABLE
668: ) as
669: ddindx binary_integer; indx binary_integer;

Line 667: , a3 JTF_NUMBER_TABLE

663:
664: procedure rosetta_table_copy_in_p26(t out nocopy dpp_uiwrapper_pvt.dpp_cust_inv_tbl_type, a0 JTF_NUMBER_TABLE
665: , a1 JTF_NUMBER_TABLE
666: , a2 JTF_VARCHAR2_TABLE_100
667: , a3 JTF_NUMBER_TABLE
668: ) as
669: ddindx binary_integer; indx binary_integer;
670: begin
671: if a0 is not null and a0.count > 0 then

Line 689: procedure rosetta_table_copy_out_p26(t dpp_uiwrapper_pvt.dpp_cust_inv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

685: end loop;
686: end if;
687: end if;
688: end rosetta_table_copy_in_p26;
689: procedure rosetta_table_copy_out_p26(t dpp_uiwrapper_pvt.dpp_cust_inv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
690: , a1 out nocopy JTF_NUMBER_TABLE
691: , a2 out nocopy JTF_VARCHAR2_TABLE_100
692: , a3 out nocopy JTF_NUMBER_TABLE
693: ) as

Line 690: , a1 out nocopy JTF_NUMBER_TABLE

686: end if;
687: end if;
688: end rosetta_table_copy_in_p26;
689: procedure rosetta_table_copy_out_p26(t dpp_uiwrapper_pvt.dpp_cust_inv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
690: , a1 out nocopy JTF_NUMBER_TABLE
691: , a2 out nocopy JTF_VARCHAR2_TABLE_100
692: , a3 out nocopy JTF_NUMBER_TABLE
693: ) as
694: ddindx binary_integer; indx binary_integer;

Line 692: , a3 out nocopy JTF_NUMBER_TABLE

688: end rosetta_table_copy_in_p26;
689: procedure rosetta_table_copy_out_p26(t dpp_uiwrapper_pvt.dpp_cust_inv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
690: , a1 out nocopy JTF_NUMBER_TABLE
691: , a2 out nocopy JTF_VARCHAR2_TABLE_100
692: , a3 out nocopy JTF_NUMBER_TABLE
693: ) as
694: ddindx binary_integer; indx binary_integer;
695: begin
696: if t is null or t.count = 0 then

Line 697: a0 := JTF_NUMBER_TABLE();

693: ) as
694: ddindx binary_integer; indx binary_integer;
695: begin
696: if t is null or t.count = 0 then
697: a0 := JTF_NUMBER_TABLE();
698: a1 := JTF_NUMBER_TABLE();
699: a2 := JTF_VARCHAR2_TABLE_100();
700: a3 := JTF_NUMBER_TABLE();
701: else

Line 698: a1 := JTF_NUMBER_TABLE();

694: ddindx binary_integer; indx binary_integer;
695: begin
696: if t is null or t.count = 0 then
697: a0 := JTF_NUMBER_TABLE();
698: a1 := JTF_NUMBER_TABLE();
699: a2 := JTF_VARCHAR2_TABLE_100();
700: a3 := JTF_NUMBER_TABLE();
701: else
702: a0 := JTF_NUMBER_TABLE();

Line 700: a3 := JTF_NUMBER_TABLE();

696: if t is null or t.count = 0 then
697: a0 := JTF_NUMBER_TABLE();
698: a1 := JTF_NUMBER_TABLE();
699: a2 := JTF_VARCHAR2_TABLE_100();
700: a3 := JTF_NUMBER_TABLE();
701: else
702: a0 := JTF_NUMBER_TABLE();
703: a1 := JTF_NUMBER_TABLE();
704: a2 := JTF_VARCHAR2_TABLE_100();

Line 702: a0 := JTF_NUMBER_TABLE();

698: a1 := JTF_NUMBER_TABLE();
699: a2 := JTF_VARCHAR2_TABLE_100();
700: a3 := JTF_NUMBER_TABLE();
701: else
702: a0 := JTF_NUMBER_TABLE();
703: a1 := JTF_NUMBER_TABLE();
704: a2 := JTF_VARCHAR2_TABLE_100();
705: a3 := JTF_NUMBER_TABLE();
706: if t.count > 0 then

Line 703: a1 := JTF_NUMBER_TABLE();

699: a2 := JTF_VARCHAR2_TABLE_100();
700: a3 := JTF_NUMBER_TABLE();
701: else
702: a0 := JTF_NUMBER_TABLE();
703: a1 := JTF_NUMBER_TABLE();
704: a2 := JTF_VARCHAR2_TABLE_100();
705: a3 := JTF_NUMBER_TABLE();
706: if t.count > 0 then
707: a0.extend(t.count);

Line 705: a3 := JTF_NUMBER_TABLE();

701: else
702: a0 := JTF_NUMBER_TABLE();
703: a1 := JTF_NUMBER_TABLE();
704: a2 := JTF_VARCHAR2_TABLE_100();
705: a3 := JTF_NUMBER_TABLE();
706: if t.count > 0 then
707: a0.extend(t.count);
708: a1.extend(t.count);
709: a2.extend(t.count);

Line 728: procedure rosetta_table_copy_in_p28(t out nocopy dpp_uiwrapper_pvt.dpp_cust_price_tbl_type, a0 JTF_NUMBER_TABLE

724: end if;
725: end if;
726: end rosetta_table_copy_out_p26;
727:
728: procedure rosetta_table_copy_in_p28(t out nocopy dpp_uiwrapper_pvt.dpp_cust_price_tbl_type, a0 JTF_NUMBER_TABLE
729: , a1 JTF_NUMBER_TABLE
730: , a2 JTF_VARCHAR2_TABLE_100
731: , a3 JTF_NUMBER_TABLE
732: , a4 JTF_VARCHAR2_TABLE_100

Line 729: , a1 JTF_NUMBER_TABLE

725: end if;
726: end rosetta_table_copy_out_p26;
727:
728: procedure rosetta_table_copy_in_p28(t out nocopy dpp_uiwrapper_pvt.dpp_cust_price_tbl_type, a0 JTF_NUMBER_TABLE
729: , a1 JTF_NUMBER_TABLE
730: , a2 JTF_VARCHAR2_TABLE_100
731: , a3 JTF_NUMBER_TABLE
732: , a4 JTF_VARCHAR2_TABLE_100
733: , a5 JTF_NUMBER_TABLE

Line 731: , a3 JTF_NUMBER_TABLE

727:
728: procedure rosetta_table_copy_in_p28(t out nocopy dpp_uiwrapper_pvt.dpp_cust_price_tbl_type, a0 JTF_NUMBER_TABLE
729: , a1 JTF_NUMBER_TABLE
730: , a2 JTF_VARCHAR2_TABLE_100
731: , a3 JTF_NUMBER_TABLE
732: , a4 JTF_VARCHAR2_TABLE_100
733: , a5 JTF_NUMBER_TABLE
734: , a6 JTF_NUMBER_TABLE
735: ) as

Line 733: , a5 JTF_NUMBER_TABLE

729: , a1 JTF_NUMBER_TABLE
730: , a2 JTF_VARCHAR2_TABLE_100
731: , a3 JTF_NUMBER_TABLE
732: , a4 JTF_VARCHAR2_TABLE_100
733: , a5 JTF_NUMBER_TABLE
734: , a6 JTF_NUMBER_TABLE
735: ) as
736: ddindx binary_integer; indx binary_integer;
737: begin

Line 734: , a6 JTF_NUMBER_TABLE

730: , a2 JTF_VARCHAR2_TABLE_100
731: , a3 JTF_NUMBER_TABLE
732: , a4 JTF_VARCHAR2_TABLE_100
733: , a5 JTF_NUMBER_TABLE
734: , a6 JTF_NUMBER_TABLE
735: ) as
736: ddindx binary_integer; indx binary_integer;
737: begin
738: if a0 is not null and a0.count > 0 then

Line 759: procedure rosetta_table_copy_out_p28(t dpp_uiwrapper_pvt.dpp_cust_price_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

755: end loop;
756: end if;
757: end if;
758: end rosetta_table_copy_in_p28;
759: procedure rosetta_table_copy_out_p28(t dpp_uiwrapper_pvt.dpp_cust_price_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
760: , a1 out nocopy JTF_NUMBER_TABLE
761: , a2 out nocopy JTF_VARCHAR2_TABLE_100
762: , a3 out nocopy JTF_NUMBER_TABLE
763: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 760: , a1 out nocopy JTF_NUMBER_TABLE

756: end if;
757: end if;
758: end rosetta_table_copy_in_p28;
759: procedure rosetta_table_copy_out_p28(t dpp_uiwrapper_pvt.dpp_cust_price_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
760: , a1 out nocopy JTF_NUMBER_TABLE
761: , a2 out nocopy JTF_VARCHAR2_TABLE_100
762: , a3 out nocopy JTF_NUMBER_TABLE
763: , a4 out nocopy JTF_VARCHAR2_TABLE_100
764: , a5 out nocopy JTF_NUMBER_TABLE

Line 762: , a3 out nocopy JTF_NUMBER_TABLE

758: end rosetta_table_copy_in_p28;
759: procedure rosetta_table_copy_out_p28(t dpp_uiwrapper_pvt.dpp_cust_price_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
760: , a1 out nocopy JTF_NUMBER_TABLE
761: , a2 out nocopy JTF_VARCHAR2_TABLE_100
762: , a3 out nocopy JTF_NUMBER_TABLE
763: , a4 out nocopy JTF_VARCHAR2_TABLE_100
764: , a5 out nocopy JTF_NUMBER_TABLE
765: , a6 out nocopy JTF_NUMBER_TABLE
766: ) as

Line 764: , a5 out nocopy JTF_NUMBER_TABLE

760: , a1 out nocopy JTF_NUMBER_TABLE
761: , a2 out nocopy JTF_VARCHAR2_TABLE_100
762: , a3 out nocopy JTF_NUMBER_TABLE
763: , a4 out nocopy JTF_VARCHAR2_TABLE_100
764: , a5 out nocopy JTF_NUMBER_TABLE
765: , a6 out nocopy JTF_NUMBER_TABLE
766: ) as
767: ddindx binary_integer; indx binary_integer;
768: begin

Line 765: , a6 out nocopy JTF_NUMBER_TABLE

761: , a2 out nocopy JTF_VARCHAR2_TABLE_100
762: , a3 out nocopy JTF_NUMBER_TABLE
763: , a4 out nocopy JTF_VARCHAR2_TABLE_100
764: , a5 out nocopy JTF_NUMBER_TABLE
765: , a6 out nocopy JTF_NUMBER_TABLE
766: ) as
767: ddindx binary_integer; indx binary_integer;
768: begin
769: if t is null or t.count = 0 then

Line 770: a0 := JTF_NUMBER_TABLE();

766: ) as
767: ddindx binary_integer; indx binary_integer;
768: begin
769: if t is null or t.count = 0 then
770: a0 := JTF_NUMBER_TABLE();
771: a1 := JTF_NUMBER_TABLE();
772: a2 := JTF_VARCHAR2_TABLE_100();
773: a3 := JTF_NUMBER_TABLE();
774: a4 := JTF_VARCHAR2_TABLE_100();

Line 771: a1 := JTF_NUMBER_TABLE();

767: ddindx binary_integer; indx binary_integer;
768: begin
769: if t is null or t.count = 0 then
770: a0 := JTF_NUMBER_TABLE();
771: a1 := JTF_NUMBER_TABLE();
772: a2 := JTF_VARCHAR2_TABLE_100();
773: a3 := JTF_NUMBER_TABLE();
774: a4 := JTF_VARCHAR2_TABLE_100();
775: a5 := JTF_NUMBER_TABLE();

Line 773: a3 := JTF_NUMBER_TABLE();

769: if t is null or t.count = 0 then
770: a0 := JTF_NUMBER_TABLE();
771: a1 := JTF_NUMBER_TABLE();
772: a2 := JTF_VARCHAR2_TABLE_100();
773: a3 := JTF_NUMBER_TABLE();
774: a4 := JTF_VARCHAR2_TABLE_100();
775: a5 := JTF_NUMBER_TABLE();
776: a6 := JTF_NUMBER_TABLE();
777: else

Line 775: a5 := JTF_NUMBER_TABLE();

771: a1 := JTF_NUMBER_TABLE();
772: a2 := JTF_VARCHAR2_TABLE_100();
773: a3 := JTF_NUMBER_TABLE();
774: a4 := JTF_VARCHAR2_TABLE_100();
775: a5 := JTF_NUMBER_TABLE();
776: a6 := JTF_NUMBER_TABLE();
777: else
778: a0 := JTF_NUMBER_TABLE();
779: a1 := JTF_NUMBER_TABLE();

Line 776: a6 := JTF_NUMBER_TABLE();

772: a2 := JTF_VARCHAR2_TABLE_100();
773: a3 := JTF_NUMBER_TABLE();
774: a4 := JTF_VARCHAR2_TABLE_100();
775: a5 := JTF_NUMBER_TABLE();
776: a6 := JTF_NUMBER_TABLE();
777: else
778: a0 := JTF_NUMBER_TABLE();
779: a1 := JTF_NUMBER_TABLE();
780: a2 := JTF_VARCHAR2_TABLE_100();

Line 778: a0 := JTF_NUMBER_TABLE();

774: a4 := JTF_VARCHAR2_TABLE_100();
775: a5 := JTF_NUMBER_TABLE();
776: a6 := JTF_NUMBER_TABLE();
777: else
778: a0 := JTF_NUMBER_TABLE();
779: a1 := JTF_NUMBER_TABLE();
780: a2 := JTF_VARCHAR2_TABLE_100();
781: a3 := JTF_NUMBER_TABLE();
782: a4 := JTF_VARCHAR2_TABLE_100();

Line 779: a1 := JTF_NUMBER_TABLE();

775: a5 := JTF_NUMBER_TABLE();
776: a6 := JTF_NUMBER_TABLE();
777: else
778: a0 := JTF_NUMBER_TABLE();
779: a1 := JTF_NUMBER_TABLE();
780: a2 := JTF_VARCHAR2_TABLE_100();
781: a3 := JTF_NUMBER_TABLE();
782: a4 := JTF_VARCHAR2_TABLE_100();
783: a5 := JTF_NUMBER_TABLE();

Line 781: a3 := JTF_NUMBER_TABLE();

777: else
778: a0 := JTF_NUMBER_TABLE();
779: a1 := JTF_NUMBER_TABLE();
780: a2 := JTF_VARCHAR2_TABLE_100();
781: a3 := JTF_NUMBER_TABLE();
782: a4 := JTF_VARCHAR2_TABLE_100();
783: a5 := JTF_NUMBER_TABLE();
784: a6 := JTF_NUMBER_TABLE();
785: if t.count > 0 then

Line 783: a5 := JTF_NUMBER_TABLE();

779: a1 := JTF_NUMBER_TABLE();
780: a2 := JTF_VARCHAR2_TABLE_100();
781: a3 := JTF_NUMBER_TABLE();
782: a4 := JTF_VARCHAR2_TABLE_100();
783: a5 := JTF_NUMBER_TABLE();
784: a6 := JTF_NUMBER_TABLE();
785: if t.count > 0 then
786: a0.extend(t.count);
787: a1.extend(t.count);

Line 784: a6 := JTF_NUMBER_TABLE();

780: a2 := JTF_VARCHAR2_TABLE_100();
781: a3 := JTF_NUMBER_TABLE();
782: a4 := JTF_VARCHAR2_TABLE_100();
783: a5 := JTF_NUMBER_TABLE();
784: a6 := JTF_NUMBER_TABLE();
785: if t.count > 0 then
786: a0.extend(t.count);
787: a1.extend(t.count);
788: a2.extend(t.count);

Line 813: procedure rosetta_table_copy_in_p30(t out nocopy dpp_uiwrapper_pvt.dpp_list_price_tbl_type, a0 JTF_NUMBER_TABLE

809: end if;
810: end if;
811: end rosetta_table_copy_out_p28;
812:
813: procedure rosetta_table_copy_in_p30(t out nocopy dpp_uiwrapper_pvt.dpp_list_price_tbl_type, a0 JTF_NUMBER_TABLE
814: , a1 JTF_NUMBER_TABLE
815: ) as
816: ddindx binary_integer; indx binary_integer;
817: begin

Line 814: , a1 JTF_NUMBER_TABLE

810: end if;
811: end rosetta_table_copy_out_p28;
812:
813: procedure rosetta_table_copy_in_p30(t out nocopy dpp_uiwrapper_pvt.dpp_list_price_tbl_type, a0 JTF_NUMBER_TABLE
814: , a1 JTF_NUMBER_TABLE
815: ) as
816: ddindx binary_integer; indx binary_integer;
817: begin
818: if a0 is not null and a0.count > 0 then

Line 834: procedure rosetta_table_copy_out_p30(t dpp_uiwrapper_pvt.dpp_list_price_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

830: end loop;
831: end if;
832: end if;
833: end rosetta_table_copy_in_p30;
834: procedure rosetta_table_copy_out_p30(t dpp_uiwrapper_pvt.dpp_list_price_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
835: , a1 out nocopy JTF_NUMBER_TABLE
836: ) as
837: ddindx binary_integer; indx binary_integer;
838: begin

Line 835: , a1 out nocopy JTF_NUMBER_TABLE

831: end if;
832: end if;
833: end rosetta_table_copy_in_p30;
834: procedure rosetta_table_copy_out_p30(t dpp_uiwrapper_pvt.dpp_list_price_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
835: , a1 out nocopy JTF_NUMBER_TABLE
836: ) as
837: ddindx binary_integer; indx binary_integer;
838: begin
839: if t is null or t.count = 0 then

Line 840: a0 := JTF_NUMBER_TABLE();

836: ) as
837: ddindx binary_integer; indx binary_integer;
838: begin
839: if t is null or t.count = 0 then
840: a0 := JTF_NUMBER_TABLE();
841: a1 := JTF_NUMBER_TABLE();
842: else
843: a0 := JTF_NUMBER_TABLE();
844: a1 := JTF_NUMBER_TABLE();

Line 841: a1 := JTF_NUMBER_TABLE();

837: ddindx binary_integer; indx binary_integer;
838: begin
839: if t is null or t.count = 0 then
840: a0 := JTF_NUMBER_TABLE();
841: a1 := JTF_NUMBER_TABLE();
842: else
843: a0 := JTF_NUMBER_TABLE();
844: a1 := JTF_NUMBER_TABLE();
845: if t.count > 0 then

Line 843: a0 := JTF_NUMBER_TABLE();

839: if t is null or t.count = 0 then
840: a0 := JTF_NUMBER_TABLE();
841: a1 := JTF_NUMBER_TABLE();
842: else
843: a0 := JTF_NUMBER_TABLE();
844: a1 := JTF_NUMBER_TABLE();
845: if t.count > 0 then
846: a0.extend(t.count);
847: a1.extend(t.count);

Line 844: a1 := JTF_NUMBER_TABLE();

840: a0 := JTF_NUMBER_TABLE();
841: a1 := JTF_NUMBER_TABLE();
842: else
843: a0 := JTF_NUMBER_TABLE();
844: a1 := JTF_NUMBER_TABLE();
845: if t.count > 0 then
846: a0.extend(t.count);
847: a1.extend(t.count);
848: ddindx := t.first;

Line 863: procedure rosetta_table_copy_in_p33(t out nocopy dpp_uiwrapper_pvt.approverstable, a0 JTF_NUMBER_TABLE

859: end if;
860: end if;
861: end rosetta_table_copy_out_p30;
862:
863: procedure rosetta_table_copy_in_p33(t out nocopy dpp_uiwrapper_pvt.approverstable, a0 JTF_NUMBER_TABLE
864: , a1 JTF_NUMBER_TABLE
865: , a2 JTF_VARCHAR2_TABLE_200
866: , a3 JTF_VARCHAR2_TABLE_200
867: , a4 JTF_VARCHAR2_TABLE_100

Line 864: , a1 JTF_NUMBER_TABLE

860: end if;
861: end rosetta_table_copy_out_p30;
862:
863: procedure rosetta_table_copy_in_p33(t out nocopy dpp_uiwrapper_pvt.approverstable, a0 JTF_NUMBER_TABLE
864: , a1 JTF_NUMBER_TABLE
865: , a2 JTF_VARCHAR2_TABLE_200
866: , a3 JTF_VARCHAR2_TABLE_200
867: , a4 JTF_VARCHAR2_TABLE_100
868: , a5 JTF_VARCHAR2_TABLE_100

Line 870: , a7 JTF_NUMBER_TABLE

866: , a3 JTF_VARCHAR2_TABLE_200
867: , a4 JTF_VARCHAR2_TABLE_100
868: , a5 JTF_VARCHAR2_TABLE_100
869: , a6 JTF_VARCHAR2_TABLE_100
870: , a7 JTF_NUMBER_TABLE
871: , a8 JTF_NUMBER_TABLE
872: , a9 JTF_NUMBER_TABLE
873: , a10 JTF_VARCHAR2_TABLE_500
874: , a11 JTF_NUMBER_TABLE

Line 871: , a8 JTF_NUMBER_TABLE

867: , a4 JTF_VARCHAR2_TABLE_100
868: , a5 JTF_VARCHAR2_TABLE_100
869: , a6 JTF_VARCHAR2_TABLE_100
870: , a7 JTF_NUMBER_TABLE
871: , a8 JTF_NUMBER_TABLE
872: , a9 JTF_NUMBER_TABLE
873: , a10 JTF_VARCHAR2_TABLE_500
874: , a11 JTF_NUMBER_TABLE
875: , a12 JTF_VARCHAR2_TABLE_300

Line 872: , a9 JTF_NUMBER_TABLE

868: , a5 JTF_VARCHAR2_TABLE_100
869: , a6 JTF_VARCHAR2_TABLE_100
870: , a7 JTF_NUMBER_TABLE
871: , a8 JTF_NUMBER_TABLE
872: , a9 JTF_NUMBER_TABLE
873: , a10 JTF_VARCHAR2_TABLE_500
874: , a11 JTF_NUMBER_TABLE
875: , a12 JTF_VARCHAR2_TABLE_300
876: , a13 JTF_VARCHAR2_TABLE_100

Line 874: , a11 JTF_NUMBER_TABLE

870: , a7 JTF_NUMBER_TABLE
871: , a8 JTF_NUMBER_TABLE
872: , a9 JTF_NUMBER_TABLE
873: , a10 JTF_VARCHAR2_TABLE_500
874: , a11 JTF_NUMBER_TABLE
875: , a12 JTF_VARCHAR2_TABLE_300
876: , a13 JTF_VARCHAR2_TABLE_100
877: ) as
878: ddindx binary_integer; indx binary_integer;

Line 908: procedure rosetta_table_copy_out_p33(t dpp_uiwrapper_pvt.approverstable, a0 out nocopy JTF_NUMBER_TABLE

904: end loop;
905: end if;
906: end if;
907: end rosetta_table_copy_in_p33;
908: procedure rosetta_table_copy_out_p33(t dpp_uiwrapper_pvt.approverstable, a0 out nocopy JTF_NUMBER_TABLE
909: , a1 out nocopy JTF_NUMBER_TABLE
910: , a2 out nocopy JTF_VARCHAR2_TABLE_200
911: , a3 out nocopy JTF_VARCHAR2_TABLE_200
912: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 909: , a1 out nocopy JTF_NUMBER_TABLE

905: end if;
906: end if;
907: end rosetta_table_copy_in_p33;
908: procedure rosetta_table_copy_out_p33(t dpp_uiwrapper_pvt.approverstable, a0 out nocopy JTF_NUMBER_TABLE
909: , a1 out nocopy JTF_NUMBER_TABLE
910: , a2 out nocopy JTF_VARCHAR2_TABLE_200
911: , a3 out nocopy JTF_VARCHAR2_TABLE_200
912: , a4 out nocopy JTF_VARCHAR2_TABLE_100
913: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 915: , a7 out nocopy JTF_NUMBER_TABLE

911: , a3 out nocopy JTF_VARCHAR2_TABLE_200
912: , a4 out nocopy JTF_VARCHAR2_TABLE_100
913: , a5 out nocopy JTF_VARCHAR2_TABLE_100
914: , a6 out nocopy JTF_VARCHAR2_TABLE_100
915: , a7 out nocopy JTF_NUMBER_TABLE
916: , a8 out nocopy JTF_NUMBER_TABLE
917: , a9 out nocopy JTF_NUMBER_TABLE
918: , a10 out nocopy JTF_VARCHAR2_TABLE_500
919: , a11 out nocopy JTF_NUMBER_TABLE

Line 916: , a8 out nocopy JTF_NUMBER_TABLE

912: , a4 out nocopy JTF_VARCHAR2_TABLE_100
913: , a5 out nocopy JTF_VARCHAR2_TABLE_100
914: , a6 out nocopy JTF_VARCHAR2_TABLE_100
915: , a7 out nocopy JTF_NUMBER_TABLE
916: , a8 out nocopy JTF_NUMBER_TABLE
917: , a9 out nocopy JTF_NUMBER_TABLE
918: , a10 out nocopy JTF_VARCHAR2_TABLE_500
919: , a11 out nocopy JTF_NUMBER_TABLE
920: , a12 out nocopy JTF_VARCHAR2_TABLE_300

Line 917: , a9 out nocopy JTF_NUMBER_TABLE

913: , a5 out nocopy JTF_VARCHAR2_TABLE_100
914: , a6 out nocopy JTF_VARCHAR2_TABLE_100
915: , a7 out nocopy JTF_NUMBER_TABLE
916: , a8 out nocopy JTF_NUMBER_TABLE
917: , a9 out nocopy JTF_NUMBER_TABLE
918: , a10 out nocopy JTF_VARCHAR2_TABLE_500
919: , a11 out nocopy JTF_NUMBER_TABLE
920: , a12 out nocopy JTF_VARCHAR2_TABLE_300
921: , a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 919: , a11 out nocopy JTF_NUMBER_TABLE

915: , a7 out nocopy JTF_NUMBER_TABLE
916: , a8 out nocopy JTF_NUMBER_TABLE
917: , a9 out nocopy JTF_NUMBER_TABLE
918: , a10 out nocopy JTF_VARCHAR2_TABLE_500
919: , a11 out nocopy JTF_NUMBER_TABLE
920: , a12 out nocopy JTF_VARCHAR2_TABLE_300
921: , a13 out nocopy JTF_VARCHAR2_TABLE_100
922: ) as
923: ddindx binary_integer; indx binary_integer;

Line 926: a0 := JTF_NUMBER_TABLE();

922: ) as
923: ddindx binary_integer; indx binary_integer;
924: begin
925: if t is null or t.count = 0 then
926: a0 := JTF_NUMBER_TABLE();
927: a1 := JTF_NUMBER_TABLE();
928: a2 := JTF_VARCHAR2_TABLE_200();
929: a3 := JTF_VARCHAR2_TABLE_200();
930: a4 := JTF_VARCHAR2_TABLE_100();

Line 927: a1 := JTF_NUMBER_TABLE();

923: ddindx binary_integer; indx binary_integer;
924: begin
925: if t is null or t.count = 0 then
926: a0 := JTF_NUMBER_TABLE();
927: a1 := JTF_NUMBER_TABLE();
928: a2 := JTF_VARCHAR2_TABLE_200();
929: a3 := JTF_VARCHAR2_TABLE_200();
930: a4 := JTF_VARCHAR2_TABLE_100();
931: a5 := JTF_VARCHAR2_TABLE_100();

Line 933: a7 := JTF_NUMBER_TABLE();

929: a3 := JTF_VARCHAR2_TABLE_200();
930: a4 := JTF_VARCHAR2_TABLE_100();
931: a5 := JTF_VARCHAR2_TABLE_100();
932: a6 := JTF_VARCHAR2_TABLE_100();
933: a7 := JTF_NUMBER_TABLE();
934: a8 := JTF_NUMBER_TABLE();
935: a9 := JTF_NUMBER_TABLE();
936: a10 := JTF_VARCHAR2_TABLE_500();
937: a11 := JTF_NUMBER_TABLE();

Line 934: a8 := JTF_NUMBER_TABLE();

930: a4 := JTF_VARCHAR2_TABLE_100();
931: a5 := JTF_VARCHAR2_TABLE_100();
932: a6 := JTF_VARCHAR2_TABLE_100();
933: a7 := JTF_NUMBER_TABLE();
934: a8 := JTF_NUMBER_TABLE();
935: a9 := JTF_NUMBER_TABLE();
936: a10 := JTF_VARCHAR2_TABLE_500();
937: a11 := JTF_NUMBER_TABLE();
938: a12 := JTF_VARCHAR2_TABLE_300();

Line 935: a9 := JTF_NUMBER_TABLE();

931: a5 := JTF_VARCHAR2_TABLE_100();
932: a6 := JTF_VARCHAR2_TABLE_100();
933: a7 := JTF_NUMBER_TABLE();
934: a8 := JTF_NUMBER_TABLE();
935: a9 := JTF_NUMBER_TABLE();
936: a10 := JTF_VARCHAR2_TABLE_500();
937: a11 := JTF_NUMBER_TABLE();
938: a12 := JTF_VARCHAR2_TABLE_300();
939: a13 := JTF_VARCHAR2_TABLE_100();

Line 937: a11 := JTF_NUMBER_TABLE();

933: a7 := JTF_NUMBER_TABLE();
934: a8 := JTF_NUMBER_TABLE();
935: a9 := JTF_NUMBER_TABLE();
936: a10 := JTF_VARCHAR2_TABLE_500();
937: a11 := JTF_NUMBER_TABLE();
938: a12 := JTF_VARCHAR2_TABLE_300();
939: a13 := JTF_VARCHAR2_TABLE_100();
940: else
941: a0 := JTF_NUMBER_TABLE();

Line 941: a0 := JTF_NUMBER_TABLE();

937: a11 := JTF_NUMBER_TABLE();
938: a12 := JTF_VARCHAR2_TABLE_300();
939: a13 := JTF_VARCHAR2_TABLE_100();
940: else
941: a0 := JTF_NUMBER_TABLE();
942: a1 := JTF_NUMBER_TABLE();
943: a2 := JTF_VARCHAR2_TABLE_200();
944: a3 := JTF_VARCHAR2_TABLE_200();
945: a4 := JTF_VARCHAR2_TABLE_100();

Line 942: a1 := JTF_NUMBER_TABLE();

938: a12 := JTF_VARCHAR2_TABLE_300();
939: a13 := JTF_VARCHAR2_TABLE_100();
940: else
941: a0 := JTF_NUMBER_TABLE();
942: a1 := JTF_NUMBER_TABLE();
943: a2 := JTF_VARCHAR2_TABLE_200();
944: a3 := JTF_VARCHAR2_TABLE_200();
945: a4 := JTF_VARCHAR2_TABLE_100();
946: a5 := JTF_VARCHAR2_TABLE_100();

Line 948: a7 := JTF_NUMBER_TABLE();

944: a3 := JTF_VARCHAR2_TABLE_200();
945: a4 := JTF_VARCHAR2_TABLE_100();
946: a5 := JTF_VARCHAR2_TABLE_100();
947: a6 := JTF_VARCHAR2_TABLE_100();
948: a7 := JTF_NUMBER_TABLE();
949: a8 := JTF_NUMBER_TABLE();
950: a9 := JTF_NUMBER_TABLE();
951: a10 := JTF_VARCHAR2_TABLE_500();
952: a11 := JTF_NUMBER_TABLE();

Line 949: a8 := JTF_NUMBER_TABLE();

945: a4 := JTF_VARCHAR2_TABLE_100();
946: a5 := JTF_VARCHAR2_TABLE_100();
947: a6 := JTF_VARCHAR2_TABLE_100();
948: a7 := JTF_NUMBER_TABLE();
949: a8 := JTF_NUMBER_TABLE();
950: a9 := JTF_NUMBER_TABLE();
951: a10 := JTF_VARCHAR2_TABLE_500();
952: a11 := JTF_NUMBER_TABLE();
953: a12 := JTF_VARCHAR2_TABLE_300();

Line 950: a9 := JTF_NUMBER_TABLE();

946: a5 := JTF_VARCHAR2_TABLE_100();
947: a6 := JTF_VARCHAR2_TABLE_100();
948: a7 := JTF_NUMBER_TABLE();
949: a8 := JTF_NUMBER_TABLE();
950: a9 := JTF_NUMBER_TABLE();
951: a10 := JTF_VARCHAR2_TABLE_500();
952: a11 := JTF_NUMBER_TABLE();
953: a12 := JTF_VARCHAR2_TABLE_300();
954: a13 := JTF_VARCHAR2_TABLE_100();

Line 952: a11 := JTF_NUMBER_TABLE();

948: a7 := JTF_NUMBER_TABLE();
949: a8 := JTF_NUMBER_TABLE();
950: a9 := JTF_NUMBER_TABLE();
951: a10 := JTF_VARCHAR2_TABLE_500();
952: a11 := JTF_NUMBER_TABLE();
953: a12 := JTF_VARCHAR2_TABLE_300();
954: a13 := JTF_VARCHAR2_TABLE_100();
955: if t.count > 0 then
956: a0.extend(t.count);

Line 997: procedure rosetta_table_copy_in_p35(t out nocopy dpp_uiwrapper_pvt.dpp_txn_line_tbl_type, a0 JTF_NUMBER_TABLE) as

993: end if;
994: end if;
995: end rosetta_table_copy_out_p33;
996:
997: procedure rosetta_table_copy_in_p35(t out nocopy dpp_uiwrapper_pvt.dpp_txn_line_tbl_type, a0 JTF_NUMBER_TABLE) as
998: ddindx binary_integer; indx binary_integer;
999: begin
1000: if a0 is not null and a0.count > 0 then
1001: if a0.count > 0 then

Line 1015: procedure rosetta_table_copy_out_p35(t dpp_uiwrapper_pvt.dpp_txn_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

1011: end loop;
1012: end if;
1013: end if;
1014: end rosetta_table_copy_in_p35;
1015: procedure rosetta_table_copy_out_p35(t dpp_uiwrapper_pvt.dpp_txn_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
1016: ddindx binary_integer; indx binary_integer;
1017: begin
1018: if t is null or t.count = 0 then
1019: a0 := JTF_NUMBER_TABLE();

Line 1019: a0 := JTF_NUMBER_TABLE();

1015: procedure rosetta_table_copy_out_p35(t dpp_uiwrapper_pvt.dpp_txn_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
1016: ddindx binary_integer; indx binary_integer;
1017: begin
1018: if t is null or t.count = 0 then
1019: a0 := JTF_NUMBER_TABLE();
1020: else
1021: a0 := JTF_NUMBER_TABLE();
1022: if t.count > 0 then
1023: a0.extend(t.count);

Line 1021: a0 := JTF_NUMBER_TABLE();

1017: begin
1018: if t is null or t.count = 0 then
1019: a0 := JTF_NUMBER_TABLE();
1020: else
1021: a0 := JTF_NUMBER_TABLE();
1022: if t.count > 0 then
1023: a0.extend(t.count);
1024: ddindx := t.first;
1025: indx := 1;

Line 1040: , p1_a0 out nocopy JTF_NUMBER_TABLE

1036: end rosetta_table_copy_out_p35;
1037:
1038: procedure search_vendors(p0_a0 JTF_VARCHAR2_TABLE_100
1039: , p0_a1 JTF_VARCHAR2_TABLE_300
1040: , p1_a0 out nocopy JTF_NUMBER_TABLE
1041: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
1042: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_300
1043: , x_rec_count out nocopy NUMBER
1044: , x_return_status out nocopy VARCHAR2

Line 1079: , p1_a0 out nocopy JTF_NUMBER_TABLE

1075: end;
1076:
1077: procedure search_vendor_sites(p0_a0 JTF_VARCHAR2_TABLE_100
1078: , p0_a1 JTF_VARCHAR2_TABLE_300
1079: , p1_a0 out nocopy JTF_NUMBER_TABLE
1080: , p1_a1 out nocopy JTF_NUMBER_TABLE
1081: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100
1082: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_300
1083: , p1_a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 1080: , p1_a1 out nocopy JTF_NUMBER_TABLE

1076:
1077: procedure search_vendor_sites(p0_a0 JTF_VARCHAR2_TABLE_100
1078: , p0_a1 JTF_VARCHAR2_TABLE_300
1079: , p1_a0 out nocopy JTF_NUMBER_TABLE
1080: , p1_a1 out nocopy JTF_NUMBER_TABLE
1081: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100
1082: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_300
1083: , p1_a4 out nocopy JTF_VARCHAR2_TABLE_300
1084: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 1132: , p1_a0 out nocopy JTF_NUMBER_TABLE

1128: end;
1129:
1130: procedure search_vendor_contacts(p0_a0 JTF_VARCHAR2_TABLE_100
1131: , p0_a1 JTF_VARCHAR2_TABLE_300
1132: , p1_a0 out nocopy JTF_NUMBER_TABLE
1133: , p1_a1 out nocopy JTF_NUMBER_TABLE
1134: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100
1135: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_100
1136: , p1_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1133: , p1_a1 out nocopy JTF_NUMBER_TABLE

1129:
1130: procedure search_vendor_contacts(p0_a0 JTF_VARCHAR2_TABLE_100
1131: , p0_a1 JTF_VARCHAR2_TABLE_300
1132: , p1_a0 out nocopy JTF_NUMBER_TABLE
1133: , p1_a1 out nocopy JTF_NUMBER_TABLE
1134: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100
1135: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_100
1136: , p1_a4 out nocopy JTF_VARCHAR2_TABLE_100
1137: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 1181: , p1_a0 out nocopy JTF_NUMBER_TABLE

1177: end;
1178:
1179: procedure search_items(p0_a0 JTF_VARCHAR2_TABLE_100
1180: , p0_a1 JTF_VARCHAR2_TABLE_300
1181: , p1_a0 out nocopy JTF_NUMBER_TABLE
1182: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
1183: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_300
1184: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_100
1185: , x_rec_count out nocopy NUMBER

Line 1222: , p1_a0 out nocopy JTF_NUMBER_TABLE

1218: end;
1219:
1220: procedure search_customer_items(p0_a0 JTF_VARCHAR2_TABLE_100
1221: , p0_a1 JTF_VARCHAR2_TABLE_300
1222: , p1_a0 out nocopy JTF_NUMBER_TABLE
1223: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
1224: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_300
1225: , x_rec_count out nocopy NUMBER
1226: , x_return_status out nocopy VARCHAR2

Line 1261: , p1_a0 out nocopy JTF_NUMBER_TABLE

1257: end;
1258:
1259: procedure search_warehouses(p0_a0 JTF_VARCHAR2_TABLE_100
1260: , p0_a1 JTF_VARCHAR2_TABLE_300
1261: , p1_a0 out nocopy JTF_NUMBER_TABLE
1262: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
1263: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_300
1264: , x_rec_count out nocopy NUMBER
1265: , x_return_status out nocopy VARCHAR2

Line 1302: , p1_a0 in out nocopy JTF_NUMBER_TABLE

1298: procedure get_inventorydetails(p0_a0 NUMBER
1299: , p0_a1 DATE
1300: , p0_a2 DATE
1301: , p0_a3 VARCHAR2
1302: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1303: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1304: , p1_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1305: , p1_a3 in out nocopy JTF_NUMBER_TABLE
1306: , p1_a4 in out nocopy JTF_NUMBER_TABLE

Line 1303: , p1_a1 in out nocopy JTF_NUMBER_TABLE

1299: , p0_a1 DATE
1300: , p0_a2 DATE
1301: , p0_a3 VARCHAR2
1302: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1303: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1304: , p1_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1305: , p1_a3 in out nocopy JTF_NUMBER_TABLE
1306: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1307: , x_rec_count out nocopy NUMBER

Line 1305: , p1_a3 in out nocopy JTF_NUMBER_TABLE

1301: , p0_a3 VARCHAR2
1302: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1303: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1304: , p1_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1305: , p1_a3 in out nocopy JTF_NUMBER_TABLE
1306: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1307: , x_rec_count out nocopy NUMBER
1308: , x_return_status out nocopy VARCHAR2
1309: )

Line 1306: , p1_a4 in out nocopy JTF_NUMBER_TABLE

1302: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1303: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1304: , p1_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1305: , p1_a3 in out nocopy JTF_NUMBER_TABLE
1306: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1307: , x_rec_count out nocopy NUMBER
1308: , x_return_status out nocopy VARCHAR2
1309: )
1310:

Line 1354: , p1_a0 in out nocopy JTF_NUMBER_TABLE

1350: procedure get_customerinventory(p0_a0 NUMBER
1351: , p0_a1 DATE
1352: , p0_a2 DATE
1353: , p0_a3 VARCHAR2
1354: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1355: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1356: , p1_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1357: , p1_a3 in out nocopy JTF_NUMBER_TABLE
1358: , x_rec_count out nocopy NUMBER

Line 1355: , p1_a1 in out nocopy JTF_NUMBER_TABLE

1351: , p0_a1 DATE
1352: , p0_a2 DATE
1353: , p0_a3 VARCHAR2
1354: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1355: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1356: , p1_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1357: , p1_a3 in out nocopy JTF_NUMBER_TABLE
1358: , x_rec_count out nocopy NUMBER
1359: , x_return_status out nocopy VARCHAR2

Line 1357: , p1_a3 in out nocopy JTF_NUMBER_TABLE

1353: , p0_a3 VARCHAR2
1354: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1355: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1356: , p1_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1357: , p1_a3 in out nocopy JTF_NUMBER_TABLE
1358: , x_rec_count out nocopy NUMBER
1359: , x_return_status out nocopy VARCHAR2
1360: )
1361:

Line 1401: , p1_a0 out nocopy JTF_NUMBER_TABLE

1397: end;
1398:
1399: procedure search_customers(p0_a0 JTF_VARCHAR2_TABLE_100
1400: , p0_a1 JTF_VARCHAR2_TABLE_300
1401: , p1_a0 out nocopy JTF_NUMBER_TABLE
1402: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
1403: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_400
1404: , x_rec_count out nocopy NUMBER
1405: , x_return_status out nocopy VARCHAR2

Line 1442: , p1_a0 in out nocopy JTF_NUMBER_TABLE

1438: procedure get_lastprice(p0_a0 NUMBER
1439: , p0_a1 DATE
1440: , p0_a2 DATE
1441: , p0_a3 VARCHAR2
1442: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1443: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1444: , p1_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1445: , p1_a3 in out nocopy JTF_NUMBER_TABLE
1446: , p1_a4 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1443: , p1_a1 in out nocopy JTF_NUMBER_TABLE

1439: , p0_a1 DATE
1440: , p0_a2 DATE
1441: , p0_a3 VARCHAR2
1442: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1443: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1444: , p1_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1445: , p1_a3 in out nocopy JTF_NUMBER_TABLE
1446: , p1_a4 in out nocopy JTF_VARCHAR2_TABLE_100
1447: , p1_a5 in out nocopy JTF_NUMBER_TABLE

Line 1445: , p1_a3 in out nocopy JTF_NUMBER_TABLE

1441: , p0_a3 VARCHAR2
1442: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1443: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1444: , p1_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1445: , p1_a3 in out nocopy JTF_NUMBER_TABLE
1446: , p1_a4 in out nocopy JTF_VARCHAR2_TABLE_100
1447: , p1_a5 in out nocopy JTF_NUMBER_TABLE
1448: , p1_a6 in out nocopy JTF_NUMBER_TABLE
1449: , x_rec_count out nocopy NUMBER

Line 1447: , p1_a5 in out nocopy JTF_NUMBER_TABLE

1443: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1444: , p1_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1445: , p1_a3 in out nocopy JTF_NUMBER_TABLE
1446: , p1_a4 in out nocopy JTF_VARCHAR2_TABLE_100
1447: , p1_a5 in out nocopy JTF_NUMBER_TABLE
1448: , p1_a6 in out nocopy JTF_NUMBER_TABLE
1449: , x_rec_count out nocopy NUMBER
1450: , x_return_status out nocopy VARCHAR2
1451: )

Line 1448: , p1_a6 in out nocopy JTF_NUMBER_TABLE

1444: , p1_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1445: , p1_a3 in out nocopy JTF_NUMBER_TABLE
1446: , p1_a4 in out nocopy JTF_VARCHAR2_TABLE_100
1447: , p1_a5 in out nocopy JTF_NUMBER_TABLE
1448: , p1_a6 in out nocopy JTF_NUMBER_TABLE
1449: , x_rec_count out nocopy NUMBER
1450: , x_return_status out nocopy VARCHAR2
1451: )
1452:

Line 1500: , p1_a0 in out nocopy JTF_NUMBER_TABLE

1496: procedure get_listprice(p0_a0 NUMBER
1497: , p0_a1 DATE
1498: , p0_a2 DATE
1499: , p0_a3 VARCHAR2
1500: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1501: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1502: , x_rec_count out nocopy NUMBER
1503: , x_return_status out nocopy VARCHAR2
1504: )

Line 1501: , p1_a1 in out nocopy JTF_NUMBER_TABLE

1497: , p0_a1 DATE
1498: , p0_a2 DATE
1499: , p0_a3 VARCHAR2
1500: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1501: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1502: , x_rec_count out nocopy NUMBER
1503: , x_return_status out nocopy VARCHAR2
1504: )
1505:

Line 1671: procedure get_warehouse(p0_a0 in out nocopy JTF_NUMBER_TABLE

1667:
1668:
1669: end;
1670:
1671: procedure get_warehouse(p0_a0 in out nocopy JTF_NUMBER_TABLE
1672: , p0_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1673: , p0_a2 in out nocopy JTF_VARCHAR2_TABLE_300
1674: , x_rec_count out nocopy NUMBER
1675: , x_return_status out nocopy VARCHAR2

Line 1705: procedure get_customer(p0_a0 in out nocopy JTF_NUMBER_TABLE

1701:
1702:
1703: end;
1704:
1705: procedure get_customer(p0_a0 in out nocopy JTF_NUMBER_TABLE
1706: , p0_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1707: , p0_a2 in out nocopy JTF_VARCHAR2_TABLE_400
1708: , x_rec_count out nocopy NUMBER
1709: , x_return_status out nocopy VARCHAR2

Line 1739: procedure get_product(p0_a0 in out nocopy JTF_NUMBER_TABLE

1735:
1736:
1737: end;
1738:
1739: procedure get_product(p0_a0 in out nocopy JTF_NUMBER_TABLE
1740: , p0_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1741: , p0_a2 in out nocopy JTF_VARCHAR2_TABLE_300
1742: , p_org_id NUMBER
1743: , x_rec_count out nocopy NUMBER

Line 1788: , p7_a0 out nocopy JTF_NUMBER_TABLE

1784: , p6_a1 NUMBER
1785: , p6_a2 VARCHAR2
1786: , p6_a3 VARCHAR2
1787: , p6_a4 NUMBER
1788: , p7_a0 out nocopy JTF_NUMBER_TABLE
1789: , p7_a1 out nocopy JTF_NUMBER_TABLE
1790: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
1791: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
1792: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1789: , p7_a1 out nocopy JTF_NUMBER_TABLE

1785: , p6_a2 VARCHAR2
1786: , p6_a3 VARCHAR2
1787: , p6_a4 NUMBER
1788: , p7_a0 out nocopy JTF_NUMBER_TABLE
1789: , p7_a1 out nocopy JTF_NUMBER_TABLE
1790: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
1791: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
1792: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
1793: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 1795: , p7_a7 out nocopy JTF_NUMBER_TABLE

1791: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
1792: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
1793: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
1794: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
1795: , p7_a7 out nocopy JTF_NUMBER_TABLE
1796: , p7_a8 out nocopy JTF_NUMBER_TABLE
1797: , p7_a9 out nocopy JTF_NUMBER_TABLE
1798: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_500
1799: , p7_a11 out nocopy JTF_NUMBER_TABLE

Line 1796: , p7_a8 out nocopy JTF_NUMBER_TABLE

1792: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
1793: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
1794: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
1795: , p7_a7 out nocopy JTF_NUMBER_TABLE
1796: , p7_a8 out nocopy JTF_NUMBER_TABLE
1797: , p7_a9 out nocopy JTF_NUMBER_TABLE
1798: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_500
1799: , p7_a11 out nocopy JTF_NUMBER_TABLE
1800: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_300

Line 1797: , p7_a9 out nocopy JTF_NUMBER_TABLE

1793: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
1794: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
1795: , p7_a7 out nocopy JTF_NUMBER_TABLE
1796: , p7_a8 out nocopy JTF_NUMBER_TABLE
1797: , p7_a9 out nocopy JTF_NUMBER_TABLE
1798: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_500
1799: , p7_a11 out nocopy JTF_NUMBER_TABLE
1800: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_300
1801: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 1799: , p7_a11 out nocopy JTF_NUMBER_TABLE

1795: , p7_a7 out nocopy JTF_NUMBER_TABLE
1796: , p7_a8 out nocopy JTF_NUMBER_TABLE
1797: , p7_a9 out nocopy JTF_NUMBER_TABLE
1798: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_500
1799: , p7_a11 out nocopy JTF_NUMBER_TABLE
1800: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_300
1801: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100
1802: )
1803:

Line 1933: , p_txn_line_id JTF_NUMBER_TABLE

1929: , p7_a2 VARCHAR2
1930: , p7_a3 NUMBER
1931: , p7_a4 VARCHAR2
1932: , p7_a5 VARCHAR2
1933: , p_txn_line_id JTF_NUMBER_TABLE
1934: )
1935:
1936: as
1937: ddp_txn_hdr_rec dpp_uiwrapper_pvt.dpp_txn_hdr_rec_type;