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_VARCHAR2_TABLE_300

Line 4: , a1 JTF_VARCHAR2_TABLE_300

1: package body dpp_uiwrapper_pvt_w as
2: /* $Header: dppvuirb.pls 120.7 2008/05/19 09:17:02 cthour noship $ */
3: procedure rosetta_table_copy_in_p5(t out nocopy dpp_uiwrapper_pvt.search_criteria_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_300
5: ) as
6: ddindx binary_integer; indx binary_integer;
7: begin
8: if a0 is not null and a0.count > 0 then

Line 25: , a1 out nocopy JTF_VARCHAR2_TABLE_300

21: end if;
22: end if;
23: end rosetta_table_copy_in_p5;
24: procedure rosetta_table_copy_out_p5(t dpp_uiwrapper_pvt.search_criteria_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
25: , a1 out nocopy JTF_VARCHAR2_TABLE_300
26: ) as
27: ddindx binary_integer; indx binary_integer;
28: begin
29: if t is null or t.count = 0 then

Line 31: a1 := JTF_VARCHAR2_TABLE_300();

27: ddindx binary_integer; indx binary_integer;
28: begin
29: if t is null or t.count = 0 then
30: a0 := JTF_VARCHAR2_TABLE_100();
31: a1 := JTF_VARCHAR2_TABLE_300();
32: else
33: a0 := JTF_VARCHAR2_TABLE_100();
34: a1 := JTF_VARCHAR2_TABLE_300();
35: if t.count > 0 then

Line 34: a1 := JTF_VARCHAR2_TABLE_300();

30: a0 := JTF_VARCHAR2_TABLE_100();
31: a1 := JTF_VARCHAR2_TABLE_300();
32: else
33: a0 := JTF_VARCHAR2_TABLE_100();
34: a1 := JTF_VARCHAR2_TABLE_300();
35: if t.count > 0 then
36: a0.extend(t.count);
37: a1.extend(t.count);
38: ddindx := t.first;

Line 55: , a2 JTF_VARCHAR2_TABLE_300

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;
58: begin
59: if a0 is not null and a0.count > 0 then

Line 78: , a2 out nocopy JTF_VARCHAR2_TABLE_300

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;
81: begin
82: if t is null or t.count = 0 then

Line 85: a2 := JTF_VARCHAR2_TABLE_300();

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();
88: a1 := JTF_VARCHAR2_TABLE_100();
89: a2 := JTF_VARCHAR2_TABLE_300();

Line 89: a2 := JTF_VARCHAR2_TABLE_300();

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);
92: a1.extend(t.count);
93: a2.extend(t.count);

Line 113: , a3 JTF_VARCHAR2_TABLE_300

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
116: , a6 JTF_VARCHAR2_TABLE_100
117: , a7 JTF_VARCHAR2_TABLE_200

Line 114: , a4 JTF_VARCHAR2_TABLE_300

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
116: , a6 JTF_VARCHAR2_TABLE_100
117: , a7 JTF_VARCHAR2_TABLE_200
118: , a8 JTF_VARCHAR2_TABLE_100

Line 115: , a5 JTF_VARCHAR2_TABLE_300

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
116: , a6 JTF_VARCHAR2_TABLE_100
117: , a7 JTF_VARCHAR2_TABLE_200
118: , a8 JTF_VARCHAR2_TABLE_100
119: , a9 JTF_VARCHAR2_TABLE_100

Line 150: , a3 out nocopy JTF_VARCHAR2_TABLE_300

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
153: , a6 out nocopy JTF_VARCHAR2_TABLE_100
154: , a7 out nocopy JTF_VARCHAR2_TABLE_200

Line 151: , a4 out nocopy JTF_VARCHAR2_TABLE_300

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
153: , a6 out nocopy JTF_VARCHAR2_TABLE_100
154: , a7 out nocopy JTF_VARCHAR2_TABLE_200
155: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 152: , a5 out nocopy JTF_VARCHAR2_TABLE_300

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
153: , a6 out nocopy JTF_VARCHAR2_TABLE_100
154: , a7 out nocopy JTF_VARCHAR2_TABLE_200
155: , a8 out nocopy JTF_VARCHAR2_TABLE_100
156: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 164: a3 := JTF_VARCHAR2_TABLE_300();

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();
167: a6 := JTF_VARCHAR2_TABLE_100();
168: a7 := JTF_VARCHAR2_TABLE_200();

Line 165: a4 := JTF_VARCHAR2_TABLE_300();

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();
167: a6 := JTF_VARCHAR2_TABLE_100();
168: a7 := JTF_VARCHAR2_TABLE_200();
169: a8 := JTF_VARCHAR2_TABLE_100();

Line 166: a5 := JTF_VARCHAR2_TABLE_300();

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();
167: a6 := JTF_VARCHAR2_TABLE_100();
168: a7 := JTF_VARCHAR2_TABLE_200();
169: a8 := JTF_VARCHAR2_TABLE_100();
170: a9 := JTF_VARCHAR2_TABLE_100();

Line 175: a3 := JTF_VARCHAR2_TABLE_300();

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();
178: a6 := JTF_VARCHAR2_TABLE_100();
179: a7 := JTF_VARCHAR2_TABLE_200();

Line 176: a4 := JTF_VARCHAR2_TABLE_300();

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();
178: a6 := JTF_VARCHAR2_TABLE_100();
179: a7 := JTF_VARCHAR2_TABLE_200();
180: a8 := JTF_VARCHAR2_TABLE_100();

Line 177: a5 := JTF_VARCHAR2_TABLE_300();

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();
178: a6 := JTF_VARCHAR2_TABLE_100();
179: a7 := JTF_VARCHAR2_TABLE_200();
180: a8 := JTF_VARCHAR2_TABLE_100();
181: a9 := JTF_VARCHAR2_TABLE_100();

Line 367: , a2 JTF_VARCHAR2_TABLE_300

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;
370: begin
371: if a0 is not null and a0.count > 0 then

Line 390: , a2 out nocopy JTF_VARCHAR2_TABLE_300

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;
393: begin
394: if t is null or t.count = 0 then

Line 397: a2 := JTF_VARCHAR2_TABLE_300();

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();
400: a1 := JTF_VARCHAR2_TABLE_100();
401: a2 := JTF_VARCHAR2_TABLE_300();

Line 401: a2 := JTF_VARCHAR2_TABLE_300();

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);
404: a1.extend(t.count);
405: a2.extend(t.count);

Line 424: , a2 JTF_VARCHAR2_TABLE_300

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
427: ddindx binary_integer; indx binary_integer;
428: begin

Line 449: , a2 out nocopy JTF_VARCHAR2_TABLE_300

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
452: ddindx binary_integer; indx binary_integer;
453: begin

Line 457: a2 := JTF_VARCHAR2_TABLE_300();

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
460: a0 := JTF_NUMBER_TABLE();
461: a1 := JTF_VARCHAR2_TABLE_100();

Line 462: 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
465: a0.extend(t.count);
466: a1.extend(t.count);

Line 488: , a2 JTF_VARCHAR2_TABLE_300

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;
491: begin
492: if a0 is not null and a0.count > 0 then

Line 511: , a2 out nocopy JTF_VARCHAR2_TABLE_300

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;
514: begin
515: if t is null or t.count = 0 then

Line 518: a2 := JTF_VARCHAR2_TABLE_300();

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();
521: a1 := JTF_VARCHAR2_TABLE_100();
522: a2 := JTF_VARCHAR2_TABLE_300();

Line 522: a2 := JTF_VARCHAR2_TABLE_300();

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);
525: a1.extend(t.count);
526: a2.extend(t.count);

Line 875: , a12 JTF_VARCHAR2_TABLE_300

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;
879: begin

Line 920: , a12 out nocopy JTF_VARCHAR2_TABLE_300

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;
924: begin

Line 938: a12 := JTF_VARCHAR2_TABLE_300();

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();
942: a1 := JTF_NUMBER_TABLE();

Line 953: a12 := JTF_VARCHAR2_TABLE_300();

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);
957: a1.extend(t.count);

Line 1039: , p0_a1 JTF_VARCHAR2_TABLE_300

1035: end if;
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

Line 1042: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_300

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
1045: )
1046:

Line 1078: , p0_a1 JTF_VARCHAR2_TABLE_300

1074:
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

Line 1082: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_300

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
1085: , p1_a6 out nocopy JTF_VARCHAR2_TABLE_100
1086: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_200

Line 1083: , p1_a4 out nocopy 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
1085: , p1_a6 out nocopy JTF_VARCHAR2_TABLE_100
1086: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_200
1087: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 1084: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_300

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
1085: , p1_a6 out nocopy JTF_VARCHAR2_TABLE_100
1086: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_200
1087: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_100
1088: , p1_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 1131: , p0_a1 JTF_VARCHAR2_TABLE_300

1127:
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

Line 1180: , p0_a1 JTF_VARCHAR2_TABLE_300

1176:
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

Line 1183: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_300

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
1186: , x_return_status out nocopy VARCHAR2
1187: )

Line 1221: , p0_a1 JTF_VARCHAR2_TABLE_300

1217:
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

Line 1224: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_300

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
1227: )
1228:

Line 1260: , p0_a1 JTF_VARCHAR2_TABLE_300

1256:
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

Line 1263: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_300

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
1266: )
1267:

Line 1400: , p0_a1 JTF_VARCHAR2_TABLE_300

1396:
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

Line 1673: , p0_a2 in out nocopy JTF_VARCHAR2_TABLE_300

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
1676: )
1677:

Line 1741: , p0_a2 in out nocopy JTF_VARCHAR2_TABLE_300

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
1744: , x_return_status out nocopy VARCHAR2
1745: )

Line 1800: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_300

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:
1804: as