APPS.AHL_RM_MATERIAL_AS_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 17: , a3 JTF_VARCHAR2_TABLE_100

13: end;
14: procedure rosetta_table_copy_in_p1(t out nocopy ahl_rm_material_as_pvt.material_req_tbl_type, a0 JTF_NUMBER_TABLE
15: , a1 JTF_NUMBER_TABLE
16: , a2 JTF_NUMBER_TABLE
17: , a3 JTF_VARCHAR2_TABLE_100
18: , a4 JTF_VARCHAR2_TABLE_100
19: , a5 JTF_NUMBER_TABLE
20: , a6 JTF_NUMBER_TABLE
21: , a7 JTF_VARCHAR2_TABLE_100

Line 18: , a4 JTF_VARCHAR2_TABLE_100

14: procedure rosetta_table_copy_in_p1(t out nocopy ahl_rm_material_as_pvt.material_req_tbl_type, a0 JTF_NUMBER_TABLE
15: , a1 JTF_NUMBER_TABLE
16: , a2 JTF_NUMBER_TABLE
17: , a3 JTF_VARCHAR2_TABLE_100
18: , a4 JTF_VARCHAR2_TABLE_100
19: , a5 JTF_NUMBER_TABLE
20: , a6 JTF_NUMBER_TABLE
21: , a7 JTF_VARCHAR2_TABLE_100
22: , a8 JTF_VARCHAR2_TABLE_100

Line 21: , a7 JTF_VARCHAR2_TABLE_100

17: , a3 JTF_VARCHAR2_TABLE_100
18: , a4 JTF_VARCHAR2_TABLE_100
19: , a5 JTF_NUMBER_TABLE
20: , a6 JTF_NUMBER_TABLE
21: , a7 JTF_VARCHAR2_TABLE_100
22: , a8 JTF_VARCHAR2_TABLE_100
23: , a9 JTF_NUMBER_TABLE
24: , a10 JTF_VARCHAR2_TABLE_100
25: , a11 JTF_VARCHAR2_TABLE_200

Line 22: , a8 JTF_VARCHAR2_TABLE_100

18: , a4 JTF_VARCHAR2_TABLE_100
19: , a5 JTF_NUMBER_TABLE
20: , a6 JTF_NUMBER_TABLE
21: , a7 JTF_VARCHAR2_TABLE_100
22: , a8 JTF_VARCHAR2_TABLE_100
23: , a9 JTF_NUMBER_TABLE
24: , a10 JTF_VARCHAR2_TABLE_100
25: , a11 JTF_VARCHAR2_TABLE_200
26: , a12 JTF_VARCHAR2_TABLE_200

Line 24: , a10 JTF_VARCHAR2_TABLE_100

20: , a6 JTF_NUMBER_TABLE
21: , a7 JTF_VARCHAR2_TABLE_100
22: , a8 JTF_VARCHAR2_TABLE_100
23: , a9 JTF_NUMBER_TABLE
24: , a10 JTF_VARCHAR2_TABLE_100
25: , a11 JTF_VARCHAR2_TABLE_200
26: , a12 JTF_VARCHAR2_TABLE_200
27: , a13 JTF_VARCHAR2_TABLE_200
28: , a14 JTF_VARCHAR2_TABLE_200

Line 45: , a31 JTF_VARCHAR2_TABLE_100

41: , a27 JTF_NUMBER_TABLE
42: , a28 JTF_DATE_TABLE
43: , a29 JTF_NUMBER_TABLE
44: , a30 JTF_NUMBER_TABLE
45: , a31 JTF_VARCHAR2_TABLE_100
46: , a32 JTF_VARCHAR2_TABLE_4000
47: , a33 JTF_NUMBER_TABLE
48: , a34 JTF_NUMBER_TABLE
49: , a35 JTF_VARCHAR2_TABLE_100

Line 49: , a35 JTF_VARCHAR2_TABLE_100

45: , a31 JTF_VARCHAR2_TABLE_100
46: , a32 JTF_VARCHAR2_TABLE_4000
47: , a33 JTF_NUMBER_TABLE
48: , a34 JTF_NUMBER_TABLE
49: , a35 JTF_VARCHAR2_TABLE_100
50: , a36 JTF_NUMBER_TABLE
51: , a37 JTF_NUMBER_TABLE
52: , a38 JTF_VARCHAR2_TABLE_100
53: , a39 JTF_VARCHAR2_TABLE_100

Line 52: , a38 JTF_VARCHAR2_TABLE_100

48: , a34 JTF_NUMBER_TABLE
49: , a35 JTF_VARCHAR2_TABLE_100
50: , a36 JTF_NUMBER_TABLE
51: , a37 JTF_NUMBER_TABLE
52: , a38 JTF_VARCHAR2_TABLE_100
53: , a39 JTF_VARCHAR2_TABLE_100
54: , a40 JTF_VARCHAR2_TABLE_100
55: , a41 JTF_NUMBER_TABLE
56: , a42 JTF_VARCHAR2_TABLE_100

Line 53: , a39 JTF_VARCHAR2_TABLE_100

49: , a35 JTF_VARCHAR2_TABLE_100
50: , a36 JTF_NUMBER_TABLE
51: , a37 JTF_NUMBER_TABLE
52: , a38 JTF_VARCHAR2_TABLE_100
53: , a39 JTF_VARCHAR2_TABLE_100
54: , a40 JTF_VARCHAR2_TABLE_100
55: , a41 JTF_NUMBER_TABLE
56: , a42 JTF_VARCHAR2_TABLE_100
57: , a43 JTF_NUMBER_TABLE

Line 54: , a40 JTF_VARCHAR2_TABLE_100

50: , a36 JTF_NUMBER_TABLE
51: , a37 JTF_NUMBER_TABLE
52: , a38 JTF_VARCHAR2_TABLE_100
53: , a39 JTF_VARCHAR2_TABLE_100
54: , a40 JTF_VARCHAR2_TABLE_100
55: , a41 JTF_NUMBER_TABLE
56: , a42 JTF_VARCHAR2_TABLE_100
57: , a43 JTF_NUMBER_TABLE
58: ) as

Line 56: , a42 JTF_VARCHAR2_TABLE_100

52: , a38 JTF_VARCHAR2_TABLE_100
53: , a39 JTF_VARCHAR2_TABLE_100
54: , a40 JTF_VARCHAR2_TABLE_100
55: , a41 JTF_NUMBER_TABLE
56: , a42 JTF_VARCHAR2_TABLE_100
57: , a43 JTF_NUMBER_TABLE
58: ) as
59: ddindx binary_integer; indx binary_integer;
60: begin

Line 122: , a3 out nocopy JTF_VARCHAR2_TABLE_100

118: end rosetta_table_copy_in_p1;
119: procedure rosetta_table_copy_out_p1(t ahl_rm_material_as_pvt.material_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
120: , a1 out nocopy JTF_NUMBER_TABLE
121: , a2 out nocopy JTF_NUMBER_TABLE
122: , a3 out nocopy JTF_VARCHAR2_TABLE_100
123: , a4 out nocopy JTF_VARCHAR2_TABLE_100
124: , a5 out nocopy JTF_NUMBER_TABLE
125: , a6 out nocopy JTF_NUMBER_TABLE
126: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 123: , a4 out nocopy JTF_VARCHAR2_TABLE_100

119: procedure rosetta_table_copy_out_p1(t ahl_rm_material_as_pvt.material_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
120: , a1 out nocopy JTF_NUMBER_TABLE
121: , a2 out nocopy JTF_NUMBER_TABLE
122: , a3 out nocopy JTF_VARCHAR2_TABLE_100
123: , a4 out nocopy JTF_VARCHAR2_TABLE_100
124: , a5 out nocopy JTF_NUMBER_TABLE
125: , a6 out nocopy JTF_NUMBER_TABLE
126: , a7 out nocopy JTF_VARCHAR2_TABLE_100
127: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 126: , a7 out nocopy JTF_VARCHAR2_TABLE_100

122: , a3 out nocopy JTF_VARCHAR2_TABLE_100
123: , a4 out nocopy JTF_VARCHAR2_TABLE_100
124: , a5 out nocopy JTF_NUMBER_TABLE
125: , a6 out nocopy JTF_NUMBER_TABLE
126: , a7 out nocopy JTF_VARCHAR2_TABLE_100
127: , a8 out nocopy JTF_VARCHAR2_TABLE_100
128: , a9 out nocopy JTF_NUMBER_TABLE
129: , a10 out nocopy JTF_VARCHAR2_TABLE_100
130: , a11 out nocopy JTF_VARCHAR2_TABLE_200

Line 127: , a8 out nocopy JTF_VARCHAR2_TABLE_100

123: , a4 out nocopy JTF_VARCHAR2_TABLE_100
124: , a5 out nocopy JTF_NUMBER_TABLE
125: , a6 out nocopy JTF_NUMBER_TABLE
126: , a7 out nocopy JTF_VARCHAR2_TABLE_100
127: , a8 out nocopy JTF_VARCHAR2_TABLE_100
128: , a9 out nocopy JTF_NUMBER_TABLE
129: , a10 out nocopy JTF_VARCHAR2_TABLE_100
130: , a11 out nocopy JTF_VARCHAR2_TABLE_200
131: , a12 out nocopy JTF_VARCHAR2_TABLE_200

Line 129: , a10 out nocopy JTF_VARCHAR2_TABLE_100

125: , a6 out nocopy JTF_NUMBER_TABLE
126: , a7 out nocopy JTF_VARCHAR2_TABLE_100
127: , a8 out nocopy JTF_VARCHAR2_TABLE_100
128: , a9 out nocopy JTF_NUMBER_TABLE
129: , a10 out nocopy JTF_VARCHAR2_TABLE_100
130: , a11 out nocopy JTF_VARCHAR2_TABLE_200
131: , a12 out nocopy JTF_VARCHAR2_TABLE_200
132: , a13 out nocopy JTF_VARCHAR2_TABLE_200
133: , a14 out nocopy JTF_VARCHAR2_TABLE_200

Line 150: , a31 out nocopy JTF_VARCHAR2_TABLE_100

146: , a27 out nocopy JTF_NUMBER_TABLE
147: , a28 out nocopy JTF_DATE_TABLE
148: , a29 out nocopy JTF_NUMBER_TABLE
149: , a30 out nocopy JTF_NUMBER_TABLE
150: , a31 out nocopy JTF_VARCHAR2_TABLE_100
151: , a32 out nocopy JTF_VARCHAR2_TABLE_4000
152: , a33 out nocopy JTF_NUMBER_TABLE
153: , a34 out nocopy JTF_NUMBER_TABLE
154: , a35 out nocopy JTF_VARCHAR2_TABLE_100

Line 154: , a35 out nocopy JTF_VARCHAR2_TABLE_100

150: , a31 out nocopy JTF_VARCHAR2_TABLE_100
151: , a32 out nocopy JTF_VARCHAR2_TABLE_4000
152: , a33 out nocopy JTF_NUMBER_TABLE
153: , a34 out nocopy JTF_NUMBER_TABLE
154: , a35 out nocopy JTF_VARCHAR2_TABLE_100
155: , a36 out nocopy JTF_NUMBER_TABLE
156: , a37 out nocopy JTF_NUMBER_TABLE
157: , a38 out nocopy JTF_VARCHAR2_TABLE_100
158: , a39 out nocopy JTF_VARCHAR2_TABLE_100

Line 157: , a38 out nocopy JTF_VARCHAR2_TABLE_100

153: , a34 out nocopy JTF_NUMBER_TABLE
154: , a35 out nocopy JTF_VARCHAR2_TABLE_100
155: , a36 out nocopy JTF_NUMBER_TABLE
156: , a37 out nocopy JTF_NUMBER_TABLE
157: , a38 out nocopy JTF_VARCHAR2_TABLE_100
158: , a39 out nocopy JTF_VARCHAR2_TABLE_100
159: , a40 out nocopy JTF_VARCHAR2_TABLE_100
160: , a41 out nocopy JTF_NUMBER_TABLE
161: , a42 out nocopy JTF_VARCHAR2_TABLE_100

Line 158: , a39 out nocopy JTF_VARCHAR2_TABLE_100

154: , a35 out nocopy JTF_VARCHAR2_TABLE_100
155: , a36 out nocopy JTF_NUMBER_TABLE
156: , a37 out nocopy JTF_NUMBER_TABLE
157: , a38 out nocopy JTF_VARCHAR2_TABLE_100
158: , a39 out nocopy JTF_VARCHAR2_TABLE_100
159: , a40 out nocopy JTF_VARCHAR2_TABLE_100
160: , a41 out nocopy JTF_NUMBER_TABLE
161: , a42 out nocopy JTF_VARCHAR2_TABLE_100
162: , a43 out nocopy JTF_NUMBER_TABLE

Line 159: , a40 out nocopy JTF_VARCHAR2_TABLE_100

155: , a36 out nocopy JTF_NUMBER_TABLE
156: , a37 out nocopy JTF_NUMBER_TABLE
157: , a38 out nocopy JTF_VARCHAR2_TABLE_100
158: , a39 out nocopy JTF_VARCHAR2_TABLE_100
159: , a40 out nocopy JTF_VARCHAR2_TABLE_100
160: , a41 out nocopy JTF_NUMBER_TABLE
161: , a42 out nocopy JTF_VARCHAR2_TABLE_100
162: , a43 out nocopy JTF_NUMBER_TABLE
163: ) as

Line 161: , a42 out nocopy JTF_VARCHAR2_TABLE_100

157: , a38 out nocopy JTF_VARCHAR2_TABLE_100
158: , a39 out nocopy JTF_VARCHAR2_TABLE_100
159: , a40 out nocopy JTF_VARCHAR2_TABLE_100
160: , a41 out nocopy JTF_NUMBER_TABLE
161: , a42 out nocopy JTF_VARCHAR2_TABLE_100
162: , a43 out nocopy JTF_NUMBER_TABLE
163: ) as
164: ddindx binary_integer; indx binary_integer;
165: begin

Line 170: a3 := JTF_VARCHAR2_TABLE_100();

166: if t is null or t.count = 0 then
167: a0 := JTF_NUMBER_TABLE();
168: a1 := JTF_NUMBER_TABLE();
169: a2 := JTF_NUMBER_TABLE();
170: a3 := JTF_VARCHAR2_TABLE_100();
171: a4 := JTF_VARCHAR2_TABLE_100();
172: a5 := JTF_NUMBER_TABLE();
173: a6 := JTF_NUMBER_TABLE();
174: a7 := JTF_VARCHAR2_TABLE_100();

Line 171: a4 := JTF_VARCHAR2_TABLE_100();

167: a0 := JTF_NUMBER_TABLE();
168: a1 := JTF_NUMBER_TABLE();
169: a2 := JTF_NUMBER_TABLE();
170: a3 := JTF_VARCHAR2_TABLE_100();
171: a4 := JTF_VARCHAR2_TABLE_100();
172: a5 := JTF_NUMBER_TABLE();
173: a6 := JTF_NUMBER_TABLE();
174: a7 := JTF_VARCHAR2_TABLE_100();
175: a8 := JTF_VARCHAR2_TABLE_100();

Line 174: a7 := JTF_VARCHAR2_TABLE_100();

170: a3 := JTF_VARCHAR2_TABLE_100();
171: a4 := JTF_VARCHAR2_TABLE_100();
172: a5 := JTF_NUMBER_TABLE();
173: a6 := JTF_NUMBER_TABLE();
174: a7 := JTF_VARCHAR2_TABLE_100();
175: a8 := JTF_VARCHAR2_TABLE_100();
176: a9 := JTF_NUMBER_TABLE();
177: a10 := JTF_VARCHAR2_TABLE_100();
178: a11 := JTF_VARCHAR2_TABLE_200();

Line 175: a8 := JTF_VARCHAR2_TABLE_100();

171: a4 := JTF_VARCHAR2_TABLE_100();
172: a5 := JTF_NUMBER_TABLE();
173: a6 := JTF_NUMBER_TABLE();
174: a7 := JTF_VARCHAR2_TABLE_100();
175: a8 := JTF_VARCHAR2_TABLE_100();
176: a9 := JTF_NUMBER_TABLE();
177: a10 := JTF_VARCHAR2_TABLE_100();
178: a11 := JTF_VARCHAR2_TABLE_200();
179: a12 := JTF_VARCHAR2_TABLE_200();

Line 177: a10 := JTF_VARCHAR2_TABLE_100();

173: a6 := JTF_NUMBER_TABLE();
174: a7 := JTF_VARCHAR2_TABLE_100();
175: a8 := JTF_VARCHAR2_TABLE_100();
176: a9 := JTF_NUMBER_TABLE();
177: a10 := JTF_VARCHAR2_TABLE_100();
178: a11 := JTF_VARCHAR2_TABLE_200();
179: a12 := JTF_VARCHAR2_TABLE_200();
180: a13 := JTF_VARCHAR2_TABLE_200();
181: a14 := JTF_VARCHAR2_TABLE_200();

Line 198: a31 := JTF_VARCHAR2_TABLE_100();

194: a27 := JTF_NUMBER_TABLE();
195: a28 := JTF_DATE_TABLE();
196: a29 := JTF_NUMBER_TABLE();
197: a30 := JTF_NUMBER_TABLE();
198: a31 := JTF_VARCHAR2_TABLE_100();
199: a32 := JTF_VARCHAR2_TABLE_4000();
200: a33 := JTF_NUMBER_TABLE();
201: a34 := JTF_NUMBER_TABLE();
202: a35 := JTF_VARCHAR2_TABLE_100();

Line 202: a35 := JTF_VARCHAR2_TABLE_100();

198: a31 := JTF_VARCHAR2_TABLE_100();
199: a32 := JTF_VARCHAR2_TABLE_4000();
200: a33 := JTF_NUMBER_TABLE();
201: a34 := JTF_NUMBER_TABLE();
202: a35 := JTF_VARCHAR2_TABLE_100();
203: a36 := JTF_NUMBER_TABLE();
204: a37 := JTF_NUMBER_TABLE();
205: a38 := JTF_VARCHAR2_TABLE_100();
206: a39 := JTF_VARCHAR2_TABLE_100();

Line 205: a38 := JTF_VARCHAR2_TABLE_100();

201: a34 := JTF_NUMBER_TABLE();
202: a35 := JTF_VARCHAR2_TABLE_100();
203: a36 := JTF_NUMBER_TABLE();
204: a37 := JTF_NUMBER_TABLE();
205: a38 := JTF_VARCHAR2_TABLE_100();
206: a39 := JTF_VARCHAR2_TABLE_100();
207: a40 := JTF_VARCHAR2_TABLE_100();
208: a41 := JTF_NUMBER_TABLE();
209: a42 := JTF_VARCHAR2_TABLE_100();

Line 206: a39 := JTF_VARCHAR2_TABLE_100();

202: a35 := JTF_VARCHAR2_TABLE_100();
203: a36 := JTF_NUMBER_TABLE();
204: a37 := JTF_NUMBER_TABLE();
205: a38 := JTF_VARCHAR2_TABLE_100();
206: a39 := JTF_VARCHAR2_TABLE_100();
207: a40 := JTF_VARCHAR2_TABLE_100();
208: a41 := JTF_NUMBER_TABLE();
209: a42 := JTF_VARCHAR2_TABLE_100();
210: a43 := JTF_NUMBER_TABLE();

Line 207: a40 := JTF_VARCHAR2_TABLE_100();

203: a36 := JTF_NUMBER_TABLE();
204: a37 := JTF_NUMBER_TABLE();
205: a38 := JTF_VARCHAR2_TABLE_100();
206: a39 := JTF_VARCHAR2_TABLE_100();
207: a40 := JTF_VARCHAR2_TABLE_100();
208: a41 := JTF_NUMBER_TABLE();
209: a42 := JTF_VARCHAR2_TABLE_100();
210: a43 := JTF_NUMBER_TABLE();
211: else

Line 209: a42 := JTF_VARCHAR2_TABLE_100();

205: a38 := JTF_VARCHAR2_TABLE_100();
206: a39 := JTF_VARCHAR2_TABLE_100();
207: a40 := JTF_VARCHAR2_TABLE_100();
208: a41 := JTF_NUMBER_TABLE();
209: a42 := JTF_VARCHAR2_TABLE_100();
210: a43 := JTF_NUMBER_TABLE();
211: else
212: a0 := JTF_NUMBER_TABLE();
213: a1 := JTF_NUMBER_TABLE();

Line 215: a3 := JTF_VARCHAR2_TABLE_100();

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

Line 216: a4 := JTF_VARCHAR2_TABLE_100();

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

Line 219: a7 := JTF_VARCHAR2_TABLE_100();

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

Line 220: a8 := JTF_VARCHAR2_TABLE_100();

216: a4 := JTF_VARCHAR2_TABLE_100();
217: a5 := JTF_NUMBER_TABLE();
218: a6 := JTF_NUMBER_TABLE();
219: a7 := JTF_VARCHAR2_TABLE_100();
220: a8 := JTF_VARCHAR2_TABLE_100();
221: a9 := JTF_NUMBER_TABLE();
222: a10 := JTF_VARCHAR2_TABLE_100();
223: a11 := JTF_VARCHAR2_TABLE_200();
224: a12 := JTF_VARCHAR2_TABLE_200();

Line 222: a10 := JTF_VARCHAR2_TABLE_100();

218: a6 := JTF_NUMBER_TABLE();
219: a7 := JTF_VARCHAR2_TABLE_100();
220: a8 := JTF_VARCHAR2_TABLE_100();
221: a9 := JTF_NUMBER_TABLE();
222: a10 := JTF_VARCHAR2_TABLE_100();
223: a11 := JTF_VARCHAR2_TABLE_200();
224: a12 := JTF_VARCHAR2_TABLE_200();
225: a13 := JTF_VARCHAR2_TABLE_200();
226: a14 := JTF_VARCHAR2_TABLE_200();

Line 243: a31 := JTF_VARCHAR2_TABLE_100();

239: a27 := JTF_NUMBER_TABLE();
240: a28 := JTF_DATE_TABLE();
241: a29 := JTF_NUMBER_TABLE();
242: a30 := JTF_NUMBER_TABLE();
243: a31 := JTF_VARCHAR2_TABLE_100();
244: a32 := JTF_VARCHAR2_TABLE_4000();
245: a33 := JTF_NUMBER_TABLE();
246: a34 := JTF_NUMBER_TABLE();
247: a35 := JTF_VARCHAR2_TABLE_100();

Line 247: a35 := JTF_VARCHAR2_TABLE_100();

243: a31 := JTF_VARCHAR2_TABLE_100();
244: a32 := JTF_VARCHAR2_TABLE_4000();
245: a33 := JTF_NUMBER_TABLE();
246: a34 := JTF_NUMBER_TABLE();
247: a35 := JTF_VARCHAR2_TABLE_100();
248: a36 := JTF_NUMBER_TABLE();
249: a37 := JTF_NUMBER_TABLE();
250: a38 := JTF_VARCHAR2_TABLE_100();
251: a39 := JTF_VARCHAR2_TABLE_100();

Line 250: a38 := JTF_VARCHAR2_TABLE_100();

246: a34 := JTF_NUMBER_TABLE();
247: a35 := JTF_VARCHAR2_TABLE_100();
248: a36 := JTF_NUMBER_TABLE();
249: a37 := JTF_NUMBER_TABLE();
250: a38 := JTF_VARCHAR2_TABLE_100();
251: a39 := JTF_VARCHAR2_TABLE_100();
252: a40 := JTF_VARCHAR2_TABLE_100();
253: a41 := JTF_NUMBER_TABLE();
254: a42 := JTF_VARCHAR2_TABLE_100();

Line 251: a39 := JTF_VARCHAR2_TABLE_100();

247: a35 := JTF_VARCHAR2_TABLE_100();
248: a36 := JTF_NUMBER_TABLE();
249: a37 := JTF_NUMBER_TABLE();
250: a38 := JTF_VARCHAR2_TABLE_100();
251: a39 := JTF_VARCHAR2_TABLE_100();
252: a40 := JTF_VARCHAR2_TABLE_100();
253: a41 := JTF_NUMBER_TABLE();
254: a42 := JTF_VARCHAR2_TABLE_100();
255: a43 := JTF_NUMBER_TABLE();

Line 252: a40 := JTF_VARCHAR2_TABLE_100();

248: a36 := JTF_NUMBER_TABLE();
249: a37 := JTF_NUMBER_TABLE();
250: a38 := JTF_VARCHAR2_TABLE_100();
251: a39 := JTF_VARCHAR2_TABLE_100();
252: a40 := JTF_VARCHAR2_TABLE_100();
253: a41 := JTF_NUMBER_TABLE();
254: a42 := JTF_VARCHAR2_TABLE_100();
255: a43 := JTF_NUMBER_TABLE();
256: if t.count > 0 then

Line 254: a42 := JTF_VARCHAR2_TABLE_100();

250: a38 := JTF_VARCHAR2_TABLE_100();
251: a39 := JTF_VARCHAR2_TABLE_100();
252: a40 := JTF_VARCHAR2_TABLE_100();
253: a41 := JTF_NUMBER_TABLE();
254: a42 := JTF_VARCHAR2_TABLE_100();
255: a43 := JTF_NUMBER_TABLE();
256: if t.count > 0 then
257: a0.extend(t.count);
258: a1.extend(t.count);

Line 358: , a1 JTF_VARCHAR2_TABLE_100

354: end if;
355: end if;
356: end rosetta_table_copy_out_p1;
357: procedure rosetta_table_copy_in_p3(t out nocopy ahl_rm_material_as_pvt.route_efct_tbl_type, a0 JTF_NUMBER_TABLE
358: , a1 JTF_VARCHAR2_TABLE_100
359: , a2 JTF_NUMBER_TABLE
360: , a3 JTF_NUMBER_TABLE
361: , a4 JTF_VARCHAR2_TABLE_100
362: , a5 JTF_VARCHAR2_TABLE_300

Line 361: , a4 JTF_VARCHAR2_TABLE_100

357: procedure rosetta_table_copy_in_p3(t out nocopy ahl_rm_material_as_pvt.route_efct_tbl_type, a0 JTF_NUMBER_TABLE
358: , a1 JTF_VARCHAR2_TABLE_100
359: , a2 JTF_NUMBER_TABLE
360: , a3 JTF_NUMBER_TABLE
361: , a4 JTF_VARCHAR2_TABLE_100
362: , a5 JTF_VARCHAR2_TABLE_300
363: , a6 JTF_VARCHAR2_TABLE_100
364: , a7 JTF_NUMBER_TABLE
365: , a8 JTF_VARCHAR2_TABLE_100

Line 363: , a6 JTF_VARCHAR2_TABLE_100

359: , a2 JTF_NUMBER_TABLE
360: , a3 JTF_NUMBER_TABLE
361: , a4 JTF_VARCHAR2_TABLE_100
362: , a5 JTF_VARCHAR2_TABLE_300
363: , a6 JTF_VARCHAR2_TABLE_100
364: , a7 JTF_NUMBER_TABLE
365: , a8 JTF_VARCHAR2_TABLE_100
366: , a9 JTF_NUMBER_TABLE
367: , a10 JTF_VARCHAR2_TABLE_100

Line 365: , a8 JTF_VARCHAR2_TABLE_100

361: , a4 JTF_VARCHAR2_TABLE_100
362: , a5 JTF_VARCHAR2_TABLE_300
363: , a6 JTF_VARCHAR2_TABLE_100
364: , a7 JTF_NUMBER_TABLE
365: , a8 JTF_VARCHAR2_TABLE_100
366: , a9 JTF_NUMBER_TABLE
367: , a10 JTF_VARCHAR2_TABLE_100
368: , a11 JTF_VARCHAR2_TABLE_300
369: , a12 JTF_NUMBER_TABLE

Line 367: , a10 JTF_VARCHAR2_TABLE_100

363: , a6 JTF_VARCHAR2_TABLE_100
364: , a7 JTF_NUMBER_TABLE
365: , a8 JTF_VARCHAR2_TABLE_100
366: , a9 JTF_NUMBER_TABLE
367: , a10 JTF_VARCHAR2_TABLE_100
368: , a11 JTF_VARCHAR2_TABLE_300
369: , a12 JTF_NUMBER_TABLE
370: , a13 JTF_DATE_TABLE
371: , a14 JTF_NUMBER_TABLE

Line 377: , a20 JTF_VARCHAR2_TABLE_100

373: , a16 JTF_NUMBER_TABLE
374: , a17 JTF_NUMBER_TABLE
375: , a18 JTF_NUMBER_TABLE
376: , a19 JTF_NUMBER_TABLE
377: , a20 JTF_VARCHAR2_TABLE_100
378: , a21 JTF_VARCHAR2_TABLE_200
379: , a22 JTF_VARCHAR2_TABLE_200
380: , a23 JTF_VARCHAR2_TABLE_200
381: , a24 JTF_VARCHAR2_TABLE_200

Line 393: , a36 JTF_VARCHAR2_TABLE_100

389: , a32 JTF_VARCHAR2_TABLE_200
390: , a33 JTF_VARCHAR2_TABLE_200
391: , a34 JTF_VARCHAR2_TABLE_200
392: , a35 JTF_VARCHAR2_TABLE_200
393: , a36 JTF_VARCHAR2_TABLE_100
394: ) as
395: ddindx binary_integer; indx binary_integer;
396: begin
397: if a0 is not null and a0.count > 0 then

Line 449: , a1 out nocopy JTF_VARCHAR2_TABLE_100

445: end if;
446: end if;
447: end rosetta_table_copy_in_p3;
448: procedure rosetta_table_copy_out_p3(t ahl_rm_material_as_pvt.route_efct_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
449: , a1 out nocopy JTF_VARCHAR2_TABLE_100
450: , a2 out nocopy JTF_NUMBER_TABLE
451: , a3 out nocopy JTF_NUMBER_TABLE
452: , a4 out nocopy JTF_VARCHAR2_TABLE_100
453: , a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 452: , a4 out nocopy JTF_VARCHAR2_TABLE_100

448: procedure rosetta_table_copy_out_p3(t ahl_rm_material_as_pvt.route_efct_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
449: , a1 out nocopy JTF_VARCHAR2_TABLE_100
450: , a2 out nocopy JTF_NUMBER_TABLE
451: , a3 out nocopy JTF_NUMBER_TABLE
452: , a4 out nocopy JTF_VARCHAR2_TABLE_100
453: , a5 out nocopy JTF_VARCHAR2_TABLE_300
454: , a6 out nocopy JTF_VARCHAR2_TABLE_100
455: , a7 out nocopy JTF_NUMBER_TABLE
456: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 454: , a6 out nocopy JTF_VARCHAR2_TABLE_100

450: , a2 out nocopy JTF_NUMBER_TABLE
451: , a3 out nocopy JTF_NUMBER_TABLE
452: , a4 out nocopy JTF_VARCHAR2_TABLE_100
453: , a5 out nocopy JTF_VARCHAR2_TABLE_300
454: , a6 out nocopy JTF_VARCHAR2_TABLE_100
455: , a7 out nocopy JTF_NUMBER_TABLE
456: , a8 out nocopy JTF_VARCHAR2_TABLE_100
457: , a9 out nocopy JTF_NUMBER_TABLE
458: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 456: , a8 out nocopy JTF_VARCHAR2_TABLE_100

452: , a4 out nocopy JTF_VARCHAR2_TABLE_100
453: , a5 out nocopy JTF_VARCHAR2_TABLE_300
454: , a6 out nocopy JTF_VARCHAR2_TABLE_100
455: , a7 out nocopy JTF_NUMBER_TABLE
456: , a8 out nocopy JTF_VARCHAR2_TABLE_100
457: , a9 out nocopy JTF_NUMBER_TABLE
458: , a10 out nocopy JTF_VARCHAR2_TABLE_100
459: , a11 out nocopy JTF_VARCHAR2_TABLE_300
460: , a12 out nocopy JTF_NUMBER_TABLE

Line 458: , a10 out nocopy JTF_VARCHAR2_TABLE_100

454: , a6 out nocopy JTF_VARCHAR2_TABLE_100
455: , a7 out nocopy JTF_NUMBER_TABLE
456: , a8 out nocopy JTF_VARCHAR2_TABLE_100
457: , a9 out nocopy JTF_NUMBER_TABLE
458: , a10 out nocopy JTF_VARCHAR2_TABLE_100
459: , a11 out nocopy JTF_VARCHAR2_TABLE_300
460: , a12 out nocopy JTF_NUMBER_TABLE
461: , a13 out nocopy JTF_DATE_TABLE
462: , a14 out nocopy JTF_NUMBER_TABLE

Line 468: , a20 out nocopy JTF_VARCHAR2_TABLE_100

464: , a16 out nocopy JTF_NUMBER_TABLE
465: , a17 out nocopy JTF_NUMBER_TABLE
466: , a18 out nocopy JTF_NUMBER_TABLE
467: , a19 out nocopy JTF_NUMBER_TABLE
468: , a20 out nocopy JTF_VARCHAR2_TABLE_100
469: , a21 out nocopy JTF_VARCHAR2_TABLE_200
470: , a22 out nocopy JTF_VARCHAR2_TABLE_200
471: , a23 out nocopy JTF_VARCHAR2_TABLE_200
472: , a24 out nocopy JTF_VARCHAR2_TABLE_200

Line 484: , a36 out nocopy JTF_VARCHAR2_TABLE_100

480: , a32 out nocopy JTF_VARCHAR2_TABLE_200
481: , a33 out nocopy JTF_VARCHAR2_TABLE_200
482: , a34 out nocopy JTF_VARCHAR2_TABLE_200
483: , a35 out nocopy JTF_VARCHAR2_TABLE_200
484: , a36 out nocopy JTF_VARCHAR2_TABLE_100
485: ) as
486: ddindx binary_integer; indx binary_integer;
487: begin
488: if t is null or t.count = 0 then

Line 490: a1 := JTF_VARCHAR2_TABLE_100();

486: ddindx binary_integer; indx binary_integer;
487: begin
488: if t is null or t.count = 0 then
489: a0 := JTF_NUMBER_TABLE();
490: a1 := JTF_VARCHAR2_TABLE_100();
491: a2 := JTF_NUMBER_TABLE();
492: a3 := JTF_NUMBER_TABLE();
493: a4 := JTF_VARCHAR2_TABLE_100();
494: a5 := JTF_VARCHAR2_TABLE_300();

Line 493: a4 := JTF_VARCHAR2_TABLE_100();

489: a0 := JTF_NUMBER_TABLE();
490: a1 := JTF_VARCHAR2_TABLE_100();
491: a2 := JTF_NUMBER_TABLE();
492: a3 := JTF_NUMBER_TABLE();
493: a4 := JTF_VARCHAR2_TABLE_100();
494: a5 := JTF_VARCHAR2_TABLE_300();
495: a6 := JTF_VARCHAR2_TABLE_100();
496: a7 := JTF_NUMBER_TABLE();
497: a8 := JTF_VARCHAR2_TABLE_100();

Line 495: a6 := JTF_VARCHAR2_TABLE_100();

491: a2 := JTF_NUMBER_TABLE();
492: a3 := JTF_NUMBER_TABLE();
493: a4 := JTF_VARCHAR2_TABLE_100();
494: a5 := JTF_VARCHAR2_TABLE_300();
495: a6 := JTF_VARCHAR2_TABLE_100();
496: a7 := JTF_NUMBER_TABLE();
497: a8 := JTF_VARCHAR2_TABLE_100();
498: a9 := JTF_NUMBER_TABLE();
499: a10 := JTF_VARCHAR2_TABLE_100();

Line 497: a8 := JTF_VARCHAR2_TABLE_100();

493: a4 := JTF_VARCHAR2_TABLE_100();
494: a5 := JTF_VARCHAR2_TABLE_300();
495: a6 := JTF_VARCHAR2_TABLE_100();
496: a7 := JTF_NUMBER_TABLE();
497: a8 := JTF_VARCHAR2_TABLE_100();
498: a9 := JTF_NUMBER_TABLE();
499: a10 := JTF_VARCHAR2_TABLE_100();
500: a11 := JTF_VARCHAR2_TABLE_300();
501: a12 := JTF_NUMBER_TABLE();

Line 499: a10 := JTF_VARCHAR2_TABLE_100();

495: a6 := JTF_VARCHAR2_TABLE_100();
496: a7 := JTF_NUMBER_TABLE();
497: a8 := JTF_VARCHAR2_TABLE_100();
498: a9 := JTF_NUMBER_TABLE();
499: a10 := JTF_VARCHAR2_TABLE_100();
500: a11 := JTF_VARCHAR2_TABLE_300();
501: a12 := JTF_NUMBER_TABLE();
502: a13 := JTF_DATE_TABLE();
503: a14 := JTF_NUMBER_TABLE();

Line 509: a20 := JTF_VARCHAR2_TABLE_100();

505: a16 := JTF_NUMBER_TABLE();
506: a17 := JTF_NUMBER_TABLE();
507: a18 := JTF_NUMBER_TABLE();
508: a19 := JTF_NUMBER_TABLE();
509: a20 := JTF_VARCHAR2_TABLE_100();
510: a21 := JTF_VARCHAR2_TABLE_200();
511: a22 := JTF_VARCHAR2_TABLE_200();
512: a23 := JTF_VARCHAR2_TABLE_200();
513: a24 := JTF_VARCHAR2_TABLE_200();

Line 525: a36 := JTF_VARCHAR2_TABLE_100();

521: a32 := JTF_VARCHAR2_TABLE_200();
522: a33 := JTF_VARCHAR2_TABLE_200();
523: a34 := JTF_VARCHAR2_TABLE_200();
524: a35 := JTF_VARCHAR2_TABLE_200();
525: a36 := JTF_VARCHAR2_TABLE_100();
526: else
527: a0 := JTF_NUMBER_TABLE();
528: a1 := JTF_VARCHAR2_TABLE_100();
529: a2 := JTF_NUMBER_TABLE();

Line 528: a1 := JTF_VARCHAR2_TABLE_100();

524: a35 := JTF_VARCHAR2_TABLE_200();
525: a36 := JTF_VARCHAR2_TABLE_100();
526: else
527: a0 := JTF_NUMBER_TABLE();
528: a1 := JTF_VARCHAR2_TABLE_100();
529: a2 := JTF_NUMBER_TABLE();
530: a3 := JTF_NUMBER_TABLE();
531: a4 := JTF_VARCHAR2_TABLE_100();
532: a5 := JTF_VARCHAR2_TABLE_300();

Line 531: a4 := JTF_VARCHAR2_TABLE_100();

527: a0 := JTF_NUMBER_TABLE();
528: a1 := JTF_VARCHAR2_TABLE_100();
529: a2 := JTF_NUMBER_TABLE();
530: a3 := JTF_NUMBER_TABLE();
531: a4 := JTF_VARCHAR2_TABLE_100();
532: a5 := JTF_VARCHAR2_TABLE_300();
533: a6 := JTF_VARCHAR2_TABLE_100();
534: a7 := JTF_NUMBER_TABLE();
535: a8 := JTF_VARCHAR2_TABLE_100();

Line 533: a6 := JTF_VARCHAR2_TABLE_100();

529: a2 := JTF_NUMBER_TABLE();
530: a3 := JTF_NUMBER_TABLE();
531: a4 := JTF_VARCHAR2_TABLE_100();
532: a5 := JTF_VARCHAR2_TABLE_300();
533: a6 := JTF_VARCHAR2_TABLE_100();
534: a7 := JTF_NUMBER_TABLE();
535: a8 := JTF_VARCHAR2_TABLE_100();
536: a9 := JTF_NUMBER_TABLE();
537: a10 := JTF_VARCHAR2_TABLE_100();

Line 535: a8 := JTF_VARCHAR2_TABLE_100();

531: a4 := JTF_VARCHAR2_TABLE_100();
532: a5 := JTF_VARCHAR2_TABLE_300();
533: a6 := JTF_VARCHAR2_TABLE_100();
534: a7 := JTF_NUMBER_TABLE();
535: a8 := JTF_VARCHAR2_TABLE_100();
536: a9 := JTF_NUMBER_TABLE();
537: a10 := JTF_VARCHAR2_TABLE_100();
538: a11 := JTF_VARCHAR2_TABLE_300();
539: a12 := JTF_NUMBER_TABLE();

Line 537: a10 := JTF_VARCHAR2_TABLE_100();

533: a6 := JTF_VARCHAR2_TABLE_100();
534: a7 := JTF_NUMBER_TABLE();
535: a8 := JTF_VARCHAR2_TABLE_100();
536: a9 := JTF_NUMBER_TABLE();
537: a10 := JTF_VARCHAR2_TABLE_100();
538: a11 := JTF_VARCHAR2_TABLE_300();
539: a12 := JTF_NUMBER_TABLE();
540: a13 := JTF_DATE_TABLE();
541: a14 := JTF_NUMBER_TABLE();

Line 547: a20 := JTF_VARCHAR2_TABLE_100();

543: a16 := JTF_NUMBER_TABLE();
544: a17 := JTF_NUMBER_TABLE();
545: a18 := JTF_NUMBER_TABLE();
546: a19 := JTF_NUMBER_TABLE();
547: a20 := JTF_VARCHAR2_TABLE_100();
548: a21 := JTF_VARCHAR2_TABLE_200();
549: a22 := JTF_VARCHAR2_TABLE_200();
550: a23 := JTF_VARCHAR2_TABLE_200();
551: a24 := JTF_VARCHAR2_TABLE_200();

Line 563: a36 := JTF_VARCHAR2_TABLE_100();

559: a32 := JTF_VARCHAR2_TABLE_200();
560: a33 := JTF_VARCHAR2_TABLE_200();
561: a34 := JTF_VARCHAR2_TABLE_200();
562: a35 := JTF_VARCHAR2_TABLE_200();
563: a36 := JTF_VARCHAR2_TABLE_100();
564: if t.count > 0 then
565: a0.extend(t.count);
566: a1.extend(t.count);
567: a2.extend(t.count);

Line 663: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100

659: , x_msg_data out nocopy VARCHAR2
660: , p9_a0 in out nocopy JTF_NUMBER_TABLE
661: , p9_a1 in out nocopy JTF_NUMBER_TABLE
662: , p9_a2 in out nocopy JTF_NUMBER_TABLE
663: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
664: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
665: , p9_a5 in out nocopy JTF_NUMBER_TABLE
666: , p9_a6 in out nocopy JTF_NUMBER_TABLE
667: , p9_a7 in out nocopy JTF_VARCHAR2_TABLE_100

Line 664: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100

660: , p9_a0 in out nocopy JTF_NUMBER_TABLE
661: , p9_a1 in out nocopy JTF_NUMBER_TABLE
662: , p9_a2 in out nocopy JTF_NUMBER_TABLE
663: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
664: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
665: , p9_a5 in out nocopy JTF_NUMBER_TABLE
666: , p9_a6 in out nocopy JTF_NUMBER_TABLE
667: , p9_a7 in out nocopy JTF_VARCHAR2_TABLE_100
668: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100

Line 667: , p9_a7 in out nocopy JTF_VARCHAR2_TABLE_100

663: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
664: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
665: , p9_a5 in out nocopy JTF_NUMBER_TABLE
666: , p9_a6 in out nocopy JTF_NUMBER_TABLE
667: , p9_a7 in out nocopy JTF_VARCHAR2_TABLE_100
668: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
669: , p9_a9 in out nocopy JTF_NUMBER_TABLE
670: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
671: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_200

Line 668: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100

664: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
665: , p9_a5 in out nocopy JTF_NUMBER_TABLE
666: , p9_a6 in out nocopy JTF_NUMBER_TABLE
667: , p9_a7 in out nocopy JTF_VARCHAR2_TABLE_100
668: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
669: , p9_a9 in out nocopy JTF_NUMBER_TABLE
670: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
671: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_200
672: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_200

Line 670: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100

666: , p9_a6 in out nocopy JTF_NUMBER_TABLE
667: , p9_a7 in out nocopy JTF_VARCHAR2_TABLE_100
668: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
669: , p9_a9 in out nocopy JTF_NUMBER_TABLE
670: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
671: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_200
672: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_200
673: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_200
674: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_200

Line 691: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100

687: , p9_a27 in out nocopy JTF_NUMBER_TABLE
688: , p9_a28 in out nocopy JTF_DATE_TABLE
689: , p9_a29 in out nocopy JTF_NUMBER_TABLE
690: , p9_a30 in out nocopy JTF_NUMBER_TABLE
691: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
692: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_4000
693: , p9_a33 in out nocopy JTF_NUMBER_TABLE
694: , p9_a34 in out nocopy JTF_NUMBER_TABLE
695: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100

Line 695: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100

691: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
692: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_4000
693: , p9_a33 in out nocopy JTF_NUMBER_TABLE
694: , p9_a34 in out nocopy JTF_NUMBER_TABLE
695: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100
696: , p9_a36 in out nocopy JTF_NUMBER_TABLE
697: , p9_a37 in out nocopy JTF_NUMBER_TABLE
698: , p9_a38 in out nocopy JTF_VARCHAR2_TABLE_100
699: , p9_a39 in out nocopy JTF_VARCHAR2_TABLE_100

Line 698: , p9_a38 in out nocopy JTF_VARCHAR2_TABLE_100

694: , p9_a34 in out nocopy JTF_NUMBER_TABLE
695: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100
696: , p9_a36 in out nocopy JTF_NUMBER_TABLE
697: , p9_a37 in out nocopy JTF_NUMBER_TABLE
698: , p9_a38 in out nocopy JTF_VARCHAR2_TABLE_100
699: , p9_a39 in out nocopy JTF_VARCHAR2_TABLE_100
700: , p9_a40 in out nocopy JTF_VARCHAR2_TABLE_100
701: , p9_a41 in out nocopy JTF_NUMBER_TABLE
702: , p9_a42 in out nocopy JTF_VARCHAR2_TABLE_100

Line 699: , p9_a39 in out nocopy JTF_VARCHAR2_TABLE_100

695: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100
696: , p9_a36 in out nocopy JTF_NUMBER_TABLE
697: , p9_a37 in out nocopy JTF_NUMBER_TABLE
698: , p9_a38 in out nocopy JTF_VARCHAR2_TABLE_100
699: , p9_a39 in out nocopy JTF_VARCHAR2_TABLE_100
700: , p9_a40 in out nocopy JTF_VARCHAR2_TABLE_100
701: , p9_a41 in out nocopy JTF_NUMBER_TABLE
702: , p9_a42 in out nocopy JTF_VARCHAR2_TABLE_100
703: , p9_a43 in out nocopy JTF_NUMBER_TABLE

Line 700: , p9_a40 in out nocopy JTF_VARCHAR2_TABLE_100

696: , p9_a36 in out nocopy JTF_NUMBER_TABLE
697: , p9_a37 in out nocopy JTF_NUMBER_TABLE
698: , p9_a38 in out nocopy JTF_VARCHAR2_TABLE_100
699: , p9_a39 in out nocopy JTF_VARCHAR2_TABLE_100
700: , p9_a40 in out nocopy JTF_VARCHAR2_TABLE_100
701: , p9_a41 in out nocopy JTF_NUMBER_TABLE
702: , p9_a42 in out nocopy JTF_VARCHAR2_TABLE_100
703: , p9_a43 in out nocopy JTF_NUMBER_TABLE
704: , p_object_id NUMBER

Line 702: , p9_a42 in out nocopy JTF_VARCHAR2_TABLE_100

698: , p9_a38 in out nocopy JTF_VARCHAR2_TABLE_100
699: , p9_a39 in out nocopy JTF_VARCHAR2_TABLE_100
700: , p9_a40 in out nocopy JTF_VARCHAR2_TABLE_100
701: , p9_a41 in out nocopy JTF_NUMBER_TABLE
702: , p9_a42 in out nocopy JTF_VARCHAR2_TABLE_100
703: , p9_a43 in out nocopy JTF_NUMBER_TABLE
704: , p_object_id NUMBER
705: , p_association_type VARCHAR2
706: )

Line 828: , p10_a1 in out nocopy JTF_VARCHAR2_TABLE_100

824: , x_return_status out nocopy VARCHAR2
825: , x_msg_count out nocopy NUMBER
826: , x_msg_data out nocopy VARCHAR2
827: , p10_a0 in out nocopy JTF_NUMBER_TABLE
828: , p10_a1 in out nocopy JTF_VARCHAR2_TABLE_100
829: , p10_a2 in out nocopy JTF_NUMBER_TABLE
830: , p10_a3 in out nocopy JTF_NUMBER_TABLE
831: , p10_a4 in out nocopy JTF_VARCHAR2_TABLE_100
832: , p10_a5 in out nocopy JTF_VARCHAR2_TABLE_300

Line 831: , p10_a4 in out nocopy JTF_VARCHAR2_TABLE_100

827: , p10_a0 in out nocopy JTF_NUMBER_TABLE
828: , p10_a1 in out nocopy JTF_VARCHAR2_TABLE_100
829: , p10_a2 in out nocopy JTF_NUMBER_TABLE
830: , p10_a3 in out nocopy JTF_NUMBER_TABLE
831: , p10_a4 in out nocopy JTF_VARCHAR2_TABLE_100
832: , p10_a5 in out nocopy JTF_VARCHAR2_TABLE_300
833: , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100
834: , p10_a7 in out nocopy JTF_NUMBER_TABLE
835: , p10_a8 in out nocopy JTF_VARCHAR2_TABLE_100

Line 833: , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100

829: , p10_a2 in out nocopy JTF_NUMBER_TABLE
830: , p10_a3 in out nocopy JTF_NUMBER_TABLE
831: , p10_a4 in out nocopy JTF_VARCHAR2_TABLE_100
832: , p10_a5 in out nocopy JTF_VARCHAR2_TABLE_300
833: , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100
834: , p10_a7 in out nocopy JTF_NUMBER_TABLE
835: , p10_a8 in out nocopy JTF_VARCHAR2_TABLE_100
836: , p10_a9 in out nocopy JTF_NUMBER_TABLE
837: , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_100

Line 835: , p10_a8 in out nocopy JTF_VARCHAR2_TABLE_100

831: , p10_a4 in out nocopy JTF_VARCHAR2_TABLE_100
832: , p10_a5 in out nocopy JTF_VARCHAR2_TABLE_300
833: , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100
834: , p10_a7 in out nocopy JTF_NUMBER_TABLE
835: , p10_a8 in out nocopy JTF_VARCHAR2_TABLE_100
836: , p10_a9 in out nocopy JTF_NUMBER_TABLE
837: , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_100
838: , p10_a11 in out nocopy JTF_VARCHAR2_TABLE_300
839: , p10_a12 in out nocopy JTF_NUMBER_TABLE

Line 837: , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_100

833: , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100
834: , p10_a7 in out nocopy JTF_NUMBER_TABLE
835: , p10_a8 in out nocopy JTF_VARCHAR2_TABLE_100
836: , p10_a9 in out nocopy JTF_NUMBER_TABLE
837: , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_100
838: , p10_a11 in out nocopy JTF_VARCHAR2_TABLE_300
839: , p10_a12 in out nocopy JTF_NUMBER_TABLE
840: , p10_a13 in out nocopy JTF_DATE_TABLE
841: , p10_a14 in out nocopy JTF_NUMBER_TABLE

Line 847: , p10_a20 in out nocopy JTF_VARCHAR2_TABLE_100

843: , p10_a16 in out nocopy JTF_NUMBER_TABLE
844: , p10_a17 in out nocopy JTF_NUMBER_TABLE
845: , p10_a18 in out nocopy JTF_NUMBER_TABLE
846: , p10_a19 in out nocopy JTF_NUMBER_TABLE
847: , p10_a20 in out nocopy JTF_VARCHAR2_TABLE_100
848: , p10_a21 in out nocopy JTF_VARCHAR2_TABLE_200
849: , p10_a22 in out nocopy JTF_VARCHAR2_TABLE_200
850: , p10_a23 in out nocopy JTF_VARCHAR2_TABLE_200
851: , p10_a24 in out nocopy JTF_VARCHAR2_TABLE_200

Line 863: , p10_a36 in out nocopy JTF_VARCHAR2_TABLE_100

859: , p10_a32 in out nocopy JTF_VARCHAR2_TABLE_200
860: , p10_a33 in out nocopy JTF_VARCHAR2_TABLE_200
861: , p10_a34 in out nocopy JTF_VARCHAR2_TABLE_200
862: , p10_a35 in out nocopy JTF_VARCHAR2_TABLE_200
863: , p10_a36 in out nocopy JTF_VARCHAR2_TABLE_100
864: )
865: as
866: ddp_x_route_efct_tbl ahl_rm_material_as_pvt.route_efct_tbl_type;
867: ddindx binary_integer; indx binary_integer;