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_100

Line 3: procedure rosetta_table_copy_in_p5(t out nocopy dpp_uiwrapper_pvt.search_criteria_tbl_type, a0 JTF_VARCHAR2_TABLE_100

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

Line 24: procedure rosetta_table_copy_out_p5(t dpp_uiwrapper_pvt.search_criteria_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

20: end loop;
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

Line 30: a0 := JTF_VARCHAR2_TABLE_100();

26: ) as
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();

Line 33: a0 := JTF_VARCHAR2_TABLE_100();

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

Line 54: , a1 JTF_VARCHAR2_TABLE_100

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

Line 77: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 84: a1 := JTF_VARCHAR2_TABLE_100();

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

Line 88: a1 := JTF_VARCHAR2_TABLE_100();

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

Line 112: , a2 JTF_VARCHAR2_TABLE_100

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

Line 116: , a6 JTF_VARCHAR2_TABLE_100

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
120: ) as

Line 118: , a8 JTF_VARCHAR2_TABLE_100

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
120: ) as
121: ddindx binary_integer; indx binary_integer;
122: begin

Line 119: , a9 JTF_VARCHAR2_TABLE_100

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
120: ) as
121: ddindx binary_integer; indx binary_integer;
122: begin
123: if a0 is not null and a0.count > 0 then

Line 149: , a2 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 153: , a6 out nocopy JTF_VARCHAR2_TABLE_100

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
157: ) as

Line 155: , a8 out nocopy JTF_VARCHAR2_TABLE_100

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
157: ) as
158: ddindx binary_integer; indx binary_integer;
159: begin

Line 156: , a9 out nocopy JTF_VARCHAR2_TABLE_100

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
157: ) as
158: ddindx binary_integer; indx binary_integer;
159: begin
160: if t is null or t.count = 0 then

Line 163: a2 := JTF_VARCHAR2_TABLE_100();

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

Line 167: a6 := JTF_VARCHAR2_TABLE_100();

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();
171: else

Line 169: a8 := JTF_VARCHAR2_TABLE_100();

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();
171: else
172: a0 := JTF_NUMBER_TABLE();
173: a1 := JTF_NUMBER_TABLE();

Line 170: a9 := JTF_VARCHAR2_TABLE_100();

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();
171: else
172: a0 := JTF_NUMBER_TABLE();
173: a1 := JTF_NUMBER_TABLE();
174: a2 := JTF_VARCHAR2_TABLE_100();

Line 174: a2 := 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();
178: a6 := JTF_VARCHAR2_TABLE_100();

Line 178: a6 := JTF_VARCHAR2_TABLE_100();

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();
182: if t.count > 0 then

Line 180: a8 := JTF_VARCHAR2_TABLE_100();

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();
182: if t.count > 0 then
183: a0.extend(t.count);
184: a1.extend(t.count);

Line 181: a9 := JTF_VARCHAR2_TABLE_100();

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();
182: if t.count > 0 then
183: a0.extend(t.count);
184: a1.extend(t.count);
185: a2.extend(t.count);

Line 218: , a2 JTF_VARCHAR2_TABLE_100

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
222: , a6 JTF_VARCHAR2_TABLE_2000

Line 219: , a3 JTF_VARCHAR2_TABLE_100

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
222: , a6 JTF_VARCHAR2_TABLE_2000
223: , a7 JTF_VARCHAR2_TABLE_100

Line 220: , a4 JTF_VARCHAR2_TABLE_100

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
222: , a6 JTF_VARCHAR2_TABLE_2000
223: , a7 JTF_VARCHAR2_TABLE_100
224: ) as

Line 221: , a5 JTF_VARCHAR2_TABLE_100

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
222: , a6 JTF_VARCHAR2_TABLE_2000
223: , a7 JTF_VARCHAR2_TABLE_100
224: ) as
225: ddindx binary_integer; indx binary_integer;

Line 223: , a7 JTF_VARCHAR2_TABLE_100

219: , a3 JTF_VARCHAR2_TABLE_100
220: , a4 JTF_VARCHAR2_TABLE_100
221: , a5 JTF_VARCHAR2_TABLE_100
222: , a6 JTF_VARCHAR2_TABLE_2000
223: , a7 JTF_VARCHAR2_TABLE_100
224: ) as
225: ddindx binary_integer; indx binary_integer;
226: begin
227: if a0 is not null and a0.count > 0 then

Line 251: , a2 out nocopy JTF_VARCHAR2_TABLE_100

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
255: , a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 252: , a3 out nocopy JTF_VARCHAR2_TABLE_100

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
255: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
256: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 253: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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
255: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
256: , a7 out nocopy JTF_VARCHAR2_TABLE_100
257: ) as

Line 254: , a5 out nocopy JTF_VARCHAR2_TABLE_100

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
255: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
256: , a7 out nocopy JTF_VARCHAR2_TABLE_100
257: ) as
258: ddindx binary_integer; indx binary_integer;

Line 256: , a7 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
255: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
256: , a7 out nocopy JTF_VARCHAR2_TABLE_100
257: ) as
258: ddindx binary_integer; indx binary_integer;
259: begin
260: if t is null or t.count = 0 then

Line 263: a2 := JTF_VARCHAR2_TABLE_100();

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();
267: a6 := JTF_VARCHAR2_TABLE_2000();

Line 264: a3 := JTF_VARCHAR2_TABLE_100();

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();
267: a6 := JTF_VARCHAR2_TABLE_2000();
268: a7 := JTF_VARCHAR2_TABLE_100();

Line 265: a4 := JTF_VARCHAR2_TABLE_100();

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();
267: a6 := JTF_VARCHAR2_TABLE_2000();
268: a7 := JTF_VARCHAR2_TABLE_100();
269: else

Line 266: a5 := JTF_VARCHAR2_TABLE_100();

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();
267: a6 := JTF_VARCHAR2_TABLE_2000();
268: a7 := JTF_VARCHAR2_TABLE_100();
269: else
270: a0 := JTF_NUMBER_TABLE();

Line 268: a7 := JTF_VARCHAR2_TABLE_100();

264: a3 := JTF_VARCHAR2_TABLE_100();
265: a4 := JTF_VARCHAR2_TABLE_100();
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();

Line 272: a2 := JTF_VARCHAR2_TABLE_100();

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();
276: a6 := JTF_VARCHAR2_TABLE_2000();

Line 273: a3 := 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();
276: a6 := JTF_VARCHAR2_TABLE_2000();
277: a7 := JTF_VARCHAR2_TABLE_100();

Line 274: a4 := JTF_VARCHAR2_TABLE_100();

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();
276: a6 := JTF_VARCHAR2_TABLE_2000();
277: a7 := JTF_VARCHAR2_TABLE_100();
278: if t.count > 0 then

Line 275: a5 := JTF_VARCHAR2_TABLE_100();

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();
276: a6 := JTF_VARCHAR2_TABLE_2000();
277: a7 := JTF_VARCHAR2_TABLE_100();
278: if t.count > 0 then
279: a0.extend(t.count);

Line 277: a7 := JTF_VARCHAR2_TABLE_100();

273: a3 := JTF_VARCHAR2_TABLE_100();
274: a4 := JTF_VARCHAR2_TABLE_100();
275: a5 := JTF_VARCHAR2_TABLE_100();
276: a6 := JTF_VARCHAR2_TABLE_2000();
277: a7 := JTF_VARCHAR2_TABLE_100();
278: if t.count > 0 then
279: a0.extend(t.count);
280: a1.extend(t.count);
281: a2.extend(t.count);

Line 309: , a1 JTF_VARCHAR2_TABLE_100

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

Line 332: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 339: a1 := JTF_VARCHAR2_TABLE_100();

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();
343: a1 := JTF_VARCHAR2_TABLE_100();

Line 343: a1 := JTF_VARCHAR2_TABLE_100();

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

Line 366: , a1 JTF_VARCHAR2_TABLE_100

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

Line 389: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 396: a1 := JTF_VARCHAR2_TABLE_100();

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

Line 400: a1 := JTF_VARCHAR2_TABLE_100();

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

Line 423: , a1 JTF_VARCHAR2_TABLE_100

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

Line 425: , a3 JTF_VARCHAR2_TABLE_100

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
429: if a0 is not null and a0.count > 0 then

Line 448: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 450: , a3 out nocopy JTF_VARCHAR2_TABLE_100

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
454: if t is null or t.count = 0 then

Line 456: a1 := JTF_VARCHAR2_TABLE_100();

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

Line 458: a3 := JTF_VARCHAR2_TABLE_100();

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();
462: a2 := JTF_VARCHAR2_TABLE_300();

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

Line 463: 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);
467: a2.extend(t.count);

Line 487: , a1 JTF_VARCHAR2_TABLE_100

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

Line 510: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 517: a1 := JTF_VARCHAR2_TABLE_100();

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

Line 521: a1 := JTF_VARCHAR2_TABLE_100();

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

Line 595: , a2 JTF_VARCHAR2_TABLE_100

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
599: ddindx binary_integer; indx binary_integer;

Line 622: , a2 out nocopy JTF_VARCHAR2_TABLE_100

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
626: ddindx binary_integer; indx binary_integer;

Line 631: a2 := JTF_VARCHAR2_TABLE_100();

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
635: a0 := JTF_NUMBER_TABLE();

Line 637: a2 := JTF_VARCHAR2_TABLE_100();

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

Line 666: , a2 JTF_VARCHAR2_TABLE_100

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

Line 691: , a2 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 699: a2 := JTF_VARCHAR2_TABLE_100();

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

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

Line 730: , a2 JTF_VARCHAR2_TABLE_100

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
734: , a6 JTF_NUMBER_TABLE

Line 732: , a4 JTF_VARCHAR2_TABLE_100

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
736: ddindx binary_integer; indx binary_integer;

Line 761: , a2 out nocopy JTF_VARCHAR2_TABLE_100

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
765: , a6 out nocopy JTF_NUMBER_TABLE

Line 763: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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
767: ddindx binary_integer; indx binary_integer;

Line 772: a2 := JTF_VARCHAR2_TABLE_100();

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();
776: a6 := JTF_NUMBER_TABLE();

Line 774: a4 := JTF_VARCHAR2_TABLE_100();

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
778: a0 := JTF_NUMBER_TABLE();

Line 780: a2 := JTF_VARCHAR2_TABLE_100();

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();
784: a6 := JTF_NUMBER_TABLE();

Line 782: a4 := JTF_VARCHAR2_TABLE_100();

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

Line 867: , a4 JTF_VARCHAR2_TABLE_100

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
869: , a6 JTF_VARCHAR2_TABLE_100
870: , a7 JTF_NUMBER_TABLE
871: , a8 JTF_NUMBER_TABLE

Line 868: , a5 JTF_VARCHAR2_TABLE_100

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
869: , a6 JTF_VARCHAR2_TABLE_100
870: , a7 JTF_NUMBER_TABLE
871: , a8 JTF_NUMBER_TABLE
872: , a9 JTF_NUMBER_TABLE

Line 869: , a6 JTF_VARCHAR2_TABLE_100

865: , a2 JTF_VARCHAR2_TABLE_200
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

Line 876: , a13 JTF_VARCHAR2_TABLE_100

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
880: if a0 is not null and a0.count > 0 then

Line 912: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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
914: , a6 out nocopy JTF_VARCHAR2_TABLE_100
915: , a7 out nocopy JTF_NUMBER_TABLE
916: , a8 out nocopy JTF_NUMBER_TABLE

Line 913: , a5 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 914: , a6 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 921: , a13 out nocopy JTF_VARCHAR2_TABLE_100

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
925: if t is null or t.count = 0 then

Line 930: a4 := JTF_VARCHAR2_TABLE_100();

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();
932: a6 := JTF_VARCHAR2_TABLE_100();
933: a7 := JTF_NUMBER_TABLE();
934: a8 := JTF_NUMBER_TABLE();

Line 931: a5 := JTF_VARCHAR2_TABLE_100();

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();
932: a6 := JTF_VARCHAR2_TABLE_100();
933: a7 := JTF_NUMBER_TABLE();
934: a8 := JTF_NUMBER_TABLE();
935: a9 := JTF_NUMBER_TABLE();

Line 932: a6 := JTF_VARCHAR2_TABLE_100();

928: a2 := JTF_VARCHAR2_TABLE_200();
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();

Line 939: a13 := JTF_VARCHAR2_TABLE_100();

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();
943: a2 := JTF_VARCHAR2_TABLE_200();

Line 945: a4 := JTF_VARCHAR2_TABLE_100();

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();
947: a6 := JTF_VARCHAR2_TABLE_100();
948: a7 := JTF_NUMBER_TABLE();
949: a8 := JTF_NUMBER_TABLE();

Line 946: a5 := JTF_VARCHAR2_TABLE_100();

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();
947: a6 := JTF_VARCHAR2_TABLE_100();
948: a7 := JTF_NUMBER_TABLE();
949: a8 := JTF_NUMBER_TABLE();
950: a9 := JTF_NUMBER_TABLE();

Line 947: a6 := JTF_VARCHAR2_TABLE_100();

943: a2 := JTF_VARCHAR2_TABLE_200();
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();

Line 954: a13 := JTF_VARCHAR2_TABLE_100();

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

Line 1038: procedure search_vendors(p0_a0 JTF_VARCHAR2_TABLE_100

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

Line 1041: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 1077: procedure search_vendor_sites(p0_a0 JTF_VARCHAR2_TABLE_100

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

Line 1081: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 1085: , p1_a6 out nocopy JTF_VARCHAR2_TABLE_100

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
1089: , x_rec_count out nocopy NUMBER

Line 1087: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_100

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
1089: , x_rec_count out nocopy NUMBER
1090: , x_return_status out nocopy VARCHAR2
1091: )

Line 1088: , p1_a9 out nocopy JTF_VARCHAR2_TABLE_100

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
1089: , x_rec_count out nocopy NUMBER
1090: , x_return_status out nocopy VARCHAR2
1091: )
1092:

Line 1130: procedure search_vendor_contacts(p0_a0 JTF_VARCHAR2_TABLE_100

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

Line 1134: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100

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
1138: , p1_a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 1135: , p1_a3 out nocopy 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
1138: , p1_a6 out nocopy JTF_VARCHAR2_TABLE_2000
1139: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 1136: , p1_a4 out nocopy JTF_VARCHAR2_TABLE_100

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
1138: , p1_a6 out nocopy JTF_VARCHAR2_TABLE_2000
1139: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_100
1140: , x_rec_count out nocopy NUMBER

Line 1137: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_100

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
1138: , p1_a6 out nocopy JTF_VARCHAR2_TABLE_2000
1139: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_100
1140: , x_rec_count out nocopy NUMBER
1141: , x_return_status out nocopy VARCHAR2

Line 1139: , p1_a7 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
1138: , p1_a6 out nocopy JTF_VARCHAR2_TABLE_2000
1139: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_100
1140: , x_rec_count out nocopy NUMBER
1141: , x_return_status out nocopy VARCHAR2
1142: )
1143:

Line 1179: procedure search_items(p0_a0 JTF_VARCHAR2_TABLE_100

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

Line 1182: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 1184: , p1_a3 out nocopy 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: )
1188:

Line 1220: procedure search_customer_items(p0_a0 JTF_VARCHAR2_TABLE_100

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

Line 1223: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 1259: procedure search_warehouses(p0_a0 JTF_VARCHAR2_TABLE_100

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

Line 1262: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 1304: , p1_a2 in out nocopy JTF_VARCHAR2_TABLE_100

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
1308: , x_return_status out nocopy VARCHAR2

Line 1356: , p1_a2 in out nocopy JTF_VARCHAR2_TABLE_100

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
1360: )

Line 1399: procedure search_customers(p0_a0 JTF_VARCHAR2_TABLE_100

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

Line 1402: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100

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
1406: )

Line 1444: , p1_a2 in out nocopy JTF_VARCHAR2_TABLE_100

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
1448: , p1_a6 in out nocopy JTF_NUMBER_TABLE

Line 1446: , p1_a4 in out nocopy JTF_VARCHAR2_TABLE_100

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
1450: , x_return_status out nocopy VARCHAR2

Line 1672: , p0_a1 in out nocopy JTF_VARCHAR2_TABLE_100

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

Line 1706: , p0_a1 in out nocopy JTF_VARCHAR2_TABLE_100

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
1710: )

Line 1740: , p0_a1 in out nocopy JTF_VARCHAR2_TABLE_100

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

Line 1792: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 1793: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 1794: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 1801: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100

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
1805: ddp_approval_rec dpp_uiwrapper_pvt.approval_rec_type;