[Home] [Help]
PACKAGE BODY: APPS.OE_OE_HTML_LINE_EXT_W
Source
1 package body oe_oe_html_line_ext_w as
2 /* $Header: ONTRLIEB.pls 120.0 2005/06/01 01:27:07 appldev noship $ */
3 rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4 rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5
6 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7 function rosetta_g_miss_date_in_map(d date) return date as
8 begin
9 if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10 return d;
11 end;
12
13 function rosetta_g_miss_num_map(n number) return number as
14 a number := fnd_api.g_miss_num;
15 b number := 0-1962.0724;
16 begin
17 if n=a then return b; end if;
18 if n=b then return a; end if;
19 return n;
20 end;
21
22 procedure rosetta_table_copy_in_p1(t out NOCOPY /* file.sql.39 change */ oe_oe_html_line_ext.line_dff_tbl_type, a0 JTF_VARCHAR2_TABLE_300
23 , a1 JTF_VARCHAR2_TABLE_300
24 , a2 JTF_VARCHAR2_TABLE_300
25 , a3 JTF_VARCHAR2_TABLE_300
26 , a4 JTF_VARCHAR2_TABLE_300
27 , a5 JTF_VARCHAR2_TABLE_300
28 , a6 JTF_VARCHAR2_TABLE_300
29 , a7 JTF_VARCHAR2_TABLE_300
30 , a8 JTF_VARCHAR2_TABLE_300
31 , a9 JTF_VARCHAR2_TABLE_300
32 , a10 JTF_VARCHAR2_TABLE_300
33 , a11 JTF_VARCHAR2_TABLE_300
34 , a12 JTF_VARCHAR2_TABLE_300
35 , a13 JTF_VARCHAR2_TABLE_300
36 , a14 JTF_VARCHAR2_TABLE_300
37 , a15 JTF_VARCHAR2_TABLE_300
38 , a16 JTF_VARCHAR2_TABLE_300
39 , a17 JTF_VARCHAR2_TABLE_300
40 , a18 JTF_VARCHAR2_TABLE_300
41 , a19 JTF_VARCHAR2_TABLE_300
42 , a20 JTF_VARCHAR2_TABLE_300
43 , a21 JTF_VARCHAR2_TABLE_300
44 , a22 JTF_VARCHAR2_TABLE_300
45 , a23 JTF_VARCHAR2_TABLE_300
46 , a24 JTF_VARCHAR2_TABLE_300
47 , a25 JTF_VARCHAR2_TABLE_300
48 , a26 JTF_VARCHAR2_TABLE_300
49 , a27 JTF_VARCHAR2_TABLE_300
50 , a28 JTF_VARCHAR2_TABLE_300
51 , a29 JTF_VARCHAR2_TABLE_300
52 , a30 JTF_VARCHAR2_TABLE_300
53 , a31 JTF_VARCHAR2_TABLE_300
54 , a32 JTF_VARCHAR2_TABLE_300
55 , a33 JTF_VARCHAR2_TABLE_300
56 , a34 JTF_VARCHAR2_TABLE_300
57 , a35 JTF_VARCHAR2_TABLE_300
58 , a36 JTF_VARCHAR2_TABLE_300
59 , a37 JTF_VARCHAR2_TABLE_300
60 , a38 JTF_VARCHAR2_TABLE_300
61 , a39 JTF_VARCHAR2_TABLE_300
62 , a40 JTF_VARCHAR2_TABLE_100
63 , a41 JTF_NUMBER_TABLE
64 , a42 JTF_VARCHAR2_TABLE_300
65 , a43 JTF_VARCHAR2_TABLE_300
66 , a44 JTF_VARCHAR2_TABLE_300
67 , a45 JTF_VARCHAR2_TABLE_300
68 , a46 JTF_VARCHAR2_TABLE_300
69 , a47 JTF_VARCHAR2_TABLE_300
70 , a48 JTF_VARCHAR2_TABLE_300
71 , a49 JTF_VARCHAR2_TABLE_300
72 , a50 JTF_VARCHAR2_TABLE_300
73 , a51 JTF_VARCHAR2_TABLE_300
74 , a52 JTF_VARCHAR2_TABLE_300
75 , a53 JTF_VARCHAR2_TABLE_300
76 , a54 JTF_VARCHAR2_TABLE_300
77 , a55 JTF_VARCHAR2_TABLE_300
78 , a56 JTF_VARCHAR2_TABLE_300
79 , a57 JTF_VARCHAR2_TABLE_300
80 , a58 JTF_VARCHAR2_TABLE_300
81 , a59 JTF_VARCHAR2_TABLE_300
82 , a60 JTF_VARCHAR2_TABLE_300
83 , a61 JTF_VARCHAR2_TABLE_300
84 , a62 JTF_VARCHAR2_TABLE_300
85 , a63 JTF_VARCHAR2_TABLE_300
86 , a64 JTF_VARCHAR2_TABLE_300
87 , a65 JTF_VARCHAR2_TABLE_300
88 , a66 JTF_VARCHAR2_TABLE_300
89 , a67 JTF_VARCHAR2_TABLE_300
90 , a68 JTF_VARCHAR2_TABLE_300
91 , a69 JTF_VARCHAR2_TABLE_300
92 , a70 JTF_VARCHAR2_TABLE_300
93 , a71 JTF_VARCHAR2_TABLE_300
94 , a72 JTF_VARCHAR2_TABLE_100
95 , a73 JTF_VARCHAR2_TABLE_100
96 , a74 JTF_VARCHAR2_TABLE_300
97 , a75 JTF_VARCHAR2_TABLE_300
98 , a76 JTF_VARCHAR2_TABLE_300
99 , a77 JTF_VARCHAR2_TABLE_300
100 , a78 JTF_VARCHAR2_TABLE_300
101 , a79 JTF_VARCHAR2_TABLE_300
102 , a80 JTF_VARCHAR2_TABLE_300
103 , a81 JTF_VARCHAR2_TABLE_300
104 , a82 JTF_VARCHAR2_TABLE_300
105 , a83 JTF_VARCHAR2_TABLE_300
106 , a84 JTF_VARCHAR2_TABLE_300
107 , a85 JTF_VARCHAR2_TABLE_300
108 , a86 JTF_VARCHAR2_TABLE_300
109 , a87 JTF_VARCHAR2_TABLE_300
110 , a88 JTF_VARCHAR2_TABLE_300
111 , a89 JTF_VARCHAR2_TABLE_300
112 , a90 JTF_VARCHAR2_TABLE_300
113 , a91 JTF_VARCHAR2_TABLE_300
114 , a92 JTF_VARCHAR2_TABLE_300
115 , a93 JTF_VARCHAR2_TABLE_300
116 , a94 JTF_VARCHAR2_TABLE_300
117 , a95 JTF_VARCHAR2_TABLE_300
118 , a96 JTF_VARCHAR2_TABLE_300
119 , a97 JTF_VARCHAR2_TABLE_300
120 , a98 JTF_VARCHAR2_TABLE_300
121 , a99 JTF_VARCHAR2_TABLE_300
122 , a100 JTF_VARCHAR2_TABLE_300
123 , a101 JTF_VARCHAR2_TABLE_300
124 , a102 JTF_VARCHAR2_TABLE_300
125 , a103 JTF_VARCHAR2_TABLE_300
126 , a104 JTF_VARCHAR2_TABLE_100
127 ) as
128 ddindx binary_integer; indx binary_integer;
129 begin
130 if a0 is not null and a0.count > 0 then
131 if a0.count > 0 then
132 indx := a0.first;
133 ddindx := 1;
134 while true loop
135 t(ddindx).attribute1 := a0(indx);
136 t(ddindx).attribute10 := a1(indx);
137 t(ddindx).attribute11 := a2(indx);
138 t(ddindx).attribute12 := a3(indx);
139 t(ddindx).attribute13 := a4(indx);
140 t(ddindx).attribute14 := a5(indx);
141 t(ddindx).attribute15 := a6(indx);
142 t(ddindx).attribute16 := a7(indx);
143 t(ddindx).attribute17 := a8(indx);
144 t(ddindx).attribute18 := a9(indx);
145 t(ddindx).attribute19 := a10(indx);
146 t(ddindx).attribute2 := a11(indx);
147 t(ddindx).attribute20 := a12(indx);
148 t(ddindx).attribute3 := a13(indx);
149 t(ddindx).attribute4 := a14(indx);
150 t(ddindx).attribute5 := a15(indx);
151 t(ddindx).attribute6 := a16(indx);
152 t(ddindx).attribute7 := a17(indx);
153 t(ddindx).attribute8 := a18(indx);
154 t(ddindx).attribute9 := a19(indx);
155 t(ddindx).global_attribute1 := a20(indx);
156 t(ddindx).global_attribute10 := a21(indx);
157 t(ddindx).global_attribute11 := a22(indx);
158 t(ddindx).global_attribute12 := a23(indx);
159 t(ddindx).global_attribute13 := a24(indx);
160 t(ddindx).global_attribute14 := a25(indx);
161 t(ddindx).global_attribute15 := a26(indx);
162 t(ddindx).global_attribute16 := a27(indx);
163 t(ddindx).global_attribute17 := a28(indx);
164 t(ddindx).global_attribute18 := a29(indx);
165 t(ddindx).global_attribute19 := a30(indx);
166 t(ddindx).global_attribute2 := a31(indx);
167 t(ddindx).global_attribute20 := a32(indx);
168 t(ddindx).global_attribute3 := a33(indx);
169 t(ddindx).global_attribute4 := a34(indx);
170 t(ddindx).global_attribute5 := a35(indx);
171 t(ddindx).global_attribute6 := a36(indx);
172 t(ddindx).global_attribute7 := a37(indx);
173 t(ddindx).global_attribute8 := a38(indx);
174 t(ddindx).global_attribute9 := a39(indx);
175 t(ddindx).global_attribute_category := a40(indx);
176 t(ddindx).line_id := rosetta_g_miss_num_map(a41(indx));
177 t(ddindx).industry_attribute1 := a42(indx);
178 t(ddindx).industry_attribute10 := a43(indx);
179 t(ddindx).industry_attribute11 := a44(indx);
180 t(ddindx).industry_attribute12 := a45(indx);
181 t(ddindx).industry_attribute13 := a46(indx);
182 t(ddindx).industry_attribute14 := a47(indx);
183 t(ddindx).industry_attribute15 := a48(indx);
184 t(ddindx).industry_attribute16 := a49(indx);
185 t(ddindx).industry_attribute17 := a50(indx);
186 t(ddindx).industry_attribute18 := a51(indx);
187 t(ddindx).industry_attribute19 := a52(indx);
188 t(ddindx).industry_attribute20 := a53(indx);
189 t(ddindx).industry_attribute21 := a54(indx);
190 t(ddindx).industry_attribute22 := a55(indx);
191 t(ddindx).industry_attribute23 := a56(indx);
192 t(ddindx).industry_attribute24 := a57(indx);
193 t(ddindx).industry_attribute25 := a58(indx);
194 t(ddindx).industry_attribute26 := a59(indx);
195 t(ddindx).industry_attribute27 := a60(indx);
196 t(ddindx).industry_attribute28 := a61(indx);
197 t(ddindx).industry_attribute29 := a62(indx);
198 t(ddindx).industry_attribute30 := a63(indx);
199 t(ddindx).industry_attribute2 := a64(indx);
200 t(ddindx).industry_attribute3 := a65(indx);
201 t(ddindx).industry_attribute4 := a66(indx);
202 t(ddindx).industry_attribute5 := a67(indx);
203 t(ddindx).industry_attribute6 := a68(indx);
204 t(ddindx).industry_attribute7 := a69(indx);
205 t(ddindx).industry_attribute8 := a70(indx);
206 t(ddindx).industry_attribute9 := a71(indx);
207 t(ddindx).industry_context := a72(indx);
208 t(ddindx).tp_context := a73(indx);
209 t(ddindx).tp_attribute1 := a74(indx);
210 t(ddindx).tp_attribute2 := a75(indx);
211 t(ddindx).tp_attribute3 := a76(indx);
212 t(ddindx).tp_attribute4 := a77(indx);
213 t(ddindx).tp_attribute5 := a78(indx);
214 t(ddindx).tp_attribute6 := a79(indx);
215 t(ddindx).tp_attribute7 := a80(indx);
216 t(ddindx).tp_attribute8 := a81(indx);
217 t(ddindx).tp_attribute9 := a82(indx);
218 t(ddindx).tp_attribute10 := a83(indx);
219 t(ddindx).tp_attribute11 := a84(indx);
220 t(ddindx).tp_attribute12 := a85(indx);
221 t(ddindx).tp_attribute13 := a86(indx);
222 t(ddindx).tp_attribute14 := a87(indx);
223 t(ddindx).tp_attribute15 := a88(indx);
224 t(ddindx).return_attribute1 := a89(indx);
225 t(ddindx).return_attribute10 := a90(indx);
226 t(ddindx).return_attribute11 := a91(indx);
227 t(ddindx).return_attribute12 := a92(indx);
228 t(ddindx).return_attribute13 := a93(indx);
229 t(ddindx).return_attribute14 := a94(indx);
230 t(ddindx).return_attribute15 := a95(indx);
231 t(ddindx).return_attribute2 := a96(indx);
232 t(ddindx).return_attribute3 := a97(indx);
233 t(ddindx).return_attribute4 := a98(indx);
234 t(ddindx).return_attribute5 := a99(indx);
235 t(ddindx).return_attribute6 := a100(indx);
236 t(ddindx).return_attribute7 := a101(indx);
237 t(ddindx).return_attribute8 := a102(indx);
238 t(ddindx).return_attribute9 := a103(indx);
239 t(ddindx).return_context := a104(indx);
240 ddindx := ddindx+1;
241 if a0.last =indx
242 then exit;
243 end if;
244 indx := a0.next(indx);
245 end loop;
246 end if;
247 end if;
248 end rosetta_table_copy_in_p1;
249 procedure rosetta_table_copy_out_p1(t oe_oe_html_line_ext.line_dff_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
250 , a1 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
251 , a2 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
252 , a3 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
253 , a4 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
254 , a5 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
255 , a6 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
256 , a7 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
257 , a8 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
258 , a9 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
259 , a10 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
260 , a11 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
261 , a12 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
262 , a13 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
263 , a14 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
264 , a15 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
265 , a16 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
266 , a17 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
267 , a18 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
268 , a19 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
269 , a20 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
270 , a21 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
271 , a22 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
272 , a23 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
273 , a24 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
274 , a25 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
275 , a26 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
276 , a27 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
277 , a28 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
278 , a29 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
279 , a30 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
280 , a31 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
281 , a32 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
282 , a33 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
283 , a34 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
284 , a35 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
285 , a36 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
286 , a37 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
287 , a38 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
288 , a39 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
289 , a40 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
290 , a41 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
291 , a42 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
292 , a43 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
293 , a44 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
294 , a45 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
295 , a46 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
296 , a47 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
297 , a48 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
298 , a49 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
299 , a50 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
300 , a51 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
301 , a52 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
302 , a53 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
303 , a54 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
304 , a55 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
305 , a56 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
306 , a57 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
307 , a58 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
308 , a59 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
309 , a60 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
310 , a61 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
311 , a62 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
312 , a63 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
313 , a64 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
314 , a65 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
315 , a66 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
316 , a67 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
317 , a68 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
318 , a69 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
319 , a70 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
320 , a71 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
321 , a72 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
322 , a73 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
323 , a74 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
324 , a75 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
325 , a76 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
326 , a77 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
327 , a78 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
328 , a79 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
329 , a80 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
330 , a81 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
331 , a82 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
332 , a83 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
333 , a84 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
334 , a85 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
335 , a86 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
336 , a87 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
337 , a88 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
338 , a89 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
339 , a90 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
340 , a91 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
341 , a92 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
342 , a93 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
343 , a94 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
344 , a95 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
345 , a96 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
346 , a97 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
347 , a98 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
348 , a99 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
349 , a100 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
350 , a101 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
351 , a102 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
352 , a103 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
353 , a104 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
354 ) as
355 ddindx binary_integer; indx binary_integer;
356 begin
357 if t is null or t.count = 0 then
358 a0 := JTF_VARCHAR2_TABLE_300();
359 a1 := JTF_VARCHAR2_TABLE_300();
360 a2 := JTF_VARCHAR2_TABLE_300();
361 a3 := JTF_VARCHAR2_TABLE_300();
362 a4 := JTF_VARCHAR2_TABLE_300();
363 a5 := JTF_VARCHAR2_TABLE_300();
364 a6 := JTF_VARCHAR2_TABLE_300();
365 a7 := JTF_VARCHAR2_TABLE_300();
366 a8 := JTF_VARCHAR2_TABLE_300();
367 a9 := JTF_VARCHAR2_TABLE_300();
368 a10 := JTF_VARCHAR2_TABLE_300();
369 a11 := JTF_VARCHAR2_TABLE_300();
370 a12 := JTF_VARCHAR2_TABLE_300();
371 a13 := JTF_VARCHAR2_TABLE_300();
372 a14 := JTF_VARCHAR2_TABLE_300();
373 a15 := JTF_VARCHAR2_TABLE_300();
374 a16 := JTF_VARCHAR2_TABLE_300();
375 a17 := JTF_VARCHAR2_TABLE_300();
376 a18 := JTF_VARCHAR2_TABLE_300();
377 a19 := JTF_VARCHAR2_TABLE_300();
378 a20 := JTF_VARCHAR2_TABLE_300();
379 a21 := JTF_VARCHAR2_TABLE_300();
380 a22 := JTF_VARCHAR2_TABLE_300();
381 a23 := JTF_VARCHAR2_TABLE_300();
382 a24 := JTF_VARCHAR2_TABLE_300();
383 a25 := JTF_VARCHAR2_TABLE_300();
384 a26 := JTF_VARCHAR2_TABLE_300();
385 a27 := JTF_VARCHAR2_TABLE_300();
386 a28 := JTF_VARCHAR2_TABLE_300();
387 a29 := JTF_VARCHAR2_TABLE_300();
388 a30 := JTF_VARCHAR2_TABLE_300();
389 a31 := JTF_VARCHAR2_TABLE_300();
390 a32 := JTF_VARCHAR2_TABLE_300();
391 a33 := JTF_VARCHAR2_TABLE_300();
392 a34 := JTF_VARCHAR2_TABLE_300();
393 a35 := JTF_VARCHAR2_TABLE_300();
394 a36 := JTF_VARCHAR2_TABLE_300();
395 a37 := JTF_VARCHAR2_TABLE_300();
396 a38 := JTF_VARCHAR2_TABLE_300();
397 a39 := JTF_VARCHAR2_TABLE_300();
398 a40 := JTF_VARCHAR2_TABLE_100();
399 a41 := JTF_NUMBER_TABLE();
400 a42 := JTF_VARCHAR2_TABLE_300();
401 a43 := JTF_VARCHAR2_TABLE_300();
402 a44 := JTF_VARCHAR2_TABLE_300();
403 a45 := JTF_VARCHAR2_TABLE_300();
404 a46 := JTF_VARCHAR2_TABLE_300();
405 a47 := JTF_VARCHAR2_TABLE_300();
406 a48 := JTF_VARCHAR2_TABLE_300();
407 a49 := JTF_VARCHAR2_TABLE_300();
408 a50 := JTF_VARCHAR2_TABLE_300();
409 a51 := JTF_VARCHAR2_TABLE_300();
410 a52 := JTF_VARCHAR2_TABLE_300();
411 a53 := JTF_VARCHAR2_TABLE_300();
412 a54 := JTF_VARCHAR2_TABLE_300();
413 a55 := JTF_VARCHAR2_TABLE_300();
414 a56 := JTF_VARCHAR2_TABLE_300();
415 a57 := JTF_VARCHAR2_TABLE_300();
416 a58 := JTF_VARCHAR2_TABLE_300();
417 a59 := JTF_VARCHAR2_TABLE_300();
418 a60 := JTF_VARCHAR2_TABLE_300();
419 a61 := JTF_VARCHAR2_TABLE_300();
420 a62 := JTF_VARCHAR2_TABLE_300();
421 a63 := JTF_VARCHAR2_TABLE_300();
422 a64 := JTF_VARCHAR2_TABLE_300();
423 a65 := JTF_VARCHAR2_TABLE_300();
424 a66 := JTF_VARCHAR2_TABLE_300();
425 a67 := JTF_VARCHAR2_TABLE_300();
426 a68 := JTF_VARCHAR2_TABLE_300();
427 a69 := JTF_VARCHAR2_TABLE_300();
428 a70 := JTF_VARCHAR2_TABLE_300();
429 a71 := JTF_VARCHAR2_TABLE_300();
430 a72 := JTF_VARCHAR2_TABLE_100();
431 a73 := JTF_VARCHAR2_TABLE_100();
432 a74 := JTF_VARCHAR2_TABLE_300();
433 a75 := JTF_VARCHAR2_TABLE_300();
434 a76 := JTF_VARCHAR2_TABLE_300();
435 a77 := JTF_VARCHAR2_TABLE_300();
436 a78 := JTF_VARCHAR2_TABLE_300();
437 a79 := JTF_VARCHAR2_TABLE_300();
438 a80 := JTF_VARCHAR2_TABLE_300();
439 a81 := JTF_VARCHAR2_TABLE_300();
440 a82 := JTF_VARCHAR2_TABLE_300();
441 a83 := JTF_VARCHAR2_TABLE_300();
442 a84 := JTF_VARCHAR2_TABLE_300();
443 a85 := JTF_VARCHAR2_TABLE_300();
444 a86 := JTF_VARCHAR2_TABLE_300();
445 a87 := JTF_VARCHAR2_TABLE_300();
446 a88 := JTF_VARCHAR2_TABLE_300();
447 a89 := JTF_VARCHAR2_TABLE_300();
448 a90 := JTF_VARCHAR2_TABLE_300();
449 a91 := JTF_VARCHAR2_TABLE_300();
450 a92 := JTF_VARCHAR2_TABLE_300();
451 a93 := JTF_VARCHAR2_TABLE_300();
452 a94 := JTF_VARCHAR2_TABLE_300();
453 a95 := JTF_VARCHAR2_TABLE_300();
454 a96 := JTF_VARCHAR2_TABLE_300();
455 a97 := JTF_VARCHAR2_TABLE_300();
456 a98 := JTF_VARCHAR2_TABLE_300();
457 a99 := JTF_VARCHAR2_TABLE_300();
458 a100 := JTF_VARCHAR2_TABLE_300();
459 a101 := JTF_VARCHAR2_TABLE_300();
460 a102 := JTF_VARCHAR2_TABLE_300();
461 a103 := JTF_VARCHAR2_TABLE_300();
462 a104 := JTF_VARCHAR2_TABLE_100();
463 else
464 a0 := JTF_VARCHAR2_TABLE_300();
465 a1 := JTF_VARCHAR2_TABLE_300();
466 a2 := JTF_VARCHAR2_TABLE_300();
467 a3 := JTF_VARCHAR2_TABLE_300();
468 a4 := JTF_VARCHAR2_TABLE_300();
469 a5 := JTF_VARCHAR2_TABLE_300();
470 a6 := JTF_VARCHAR2_TABLE_300();
471 a7 := JTF_VARCHAR2_TABLE_300();
472 a8 := JTF_VARCHAR2_TABLE_300();
473 a9 := JTF_VARCHAR2_TABLE_300();
474 a10 := JTF_VARCHAR2_TABLE_300();
475 a11 := JTF_VARCHAR2_TABLE_300();
476 a12 := JTF_VARCHAR2_TABLE_300();
477 a13 := JTF_VARCHAR2_TABLE_300();
478 a14 := JTF_VARCHAR2_TABLE_300();
479 a15 := JTF_VARCHAR2_TABLE_300();
480 a16 := JTF_VARCHAR2_TABLE_300();
481 a17 := JTF_VARCHAR2_TABLE_300();
482 a18 := JTF_VARCHAR2_TABLE_300();
483 a19 := JTF_VARCHAR2_TABLE_300();
484 a20 := JTF_VARCHAR2_TABLE_300();
485 a21 := JTF_VARCHAR2_TABLE_300();
486 a22 := JTF_VARCHAR2_TABLE_300();
487 a23 := JTF_VARCHAR2_TABLE_300();
488 a24 := JTF_VARCHAR2_TABLE_300();
489 a25 := JTF_VARCHAR2_TABLE_300();
490 a26 := JTF_VARCHAR2_TABLE_300();
491 a27 := JTF_VARCHAR2_TABLE_300();
492 a28 := JTF_VARCHAR2_TABLE_300();
493 a29 := JTF_VARCHAR2_TABLE_300();
494 a30 := JTF_VARCHAR2_TABLE_300();
495 a31 := JTF_VARCHAR2_TABLE_300();
496 a32 := JTF_VARCHAR2_TABLE_300();
497 a33 := JTF_VARCHAR2_TABLE_300();
498 a34 := JTF_VARCHAR2_TABLE_300();
499 a35 := JTF_VARCHAR2_TABLE_300();
500 a36 := JTF_VARCHAR2_TABLE_300();
501 a37 := JTF_VARCHAR2_TABLE_300();
502 a38 := JTF_VARCHAR2_TABLE_300();
503 a39 := JTF_VARCHAR2_TABLE_300();
504 a40 := JTF_VARCHAR2_TABLE_100();
505 a41 := JTF_NUMBER_TABLE();
506 a42 := JTF_VARCHAR2_TABLE_300();
507 a43 := JTF_VARCHAR2_TABLE_300();
508 a44 := JTF_VARCHAR2_TABLE_300();
509 a45 := JTF_VARCHAR2_TABLE_300();
510 a46 := JTF_VARCHAR2_TABLE_300();
511 a47 := JTF_VARCHAR2_TABLE_300();
512 a48 := JTF_VARCHAR2_TABLE_300();
513 a49 := JTF_VARCHAR2_TABLE_300();
514 a50 := JTF_VARCHAR2_TABLE_300();
515 a51 := JTF_VARCHAR2_TABLE_300();
516 a52 := JTF_VARCHAR2_TABLE_300();
517 a53 := JTF_VARCHAR2_TABLE_300();
518 a54 := JTF_VARCHAR2_TABLE_300();
519 a55 := JTF_VARCHAR2_TABLE_300();
520 a56 := JTF_VARCHAR2_TABLE_300();
521 a57 := JTF_VARCHAR2_TABLE_300();
522 a58 := JTF_VARCHAR2_TABLE_300();
523 a59 := JTF_VARCHAR2_TABLE_300();
524 a60 := JTF_VARCHAR2_TABLE_300();
525 a61 := JTF_VARCHAR2_TABLE_300();
526 a62 := JTF_VARCHAR2_TABLE_300();
527 a63 := JTF_VARCHAR2_TABLE_300();
528 a64 := JTF_VARCHAR2_TABLE_300();
529 a65 := JTF_VARCHAR2_TABLE_300();
530 a66 := JTF_VARCHAR2_TABLE_300();
531 a67 := JTF_VARCHAR2_TABLE_300();
532 a68 := JTF_VARCHAR2_TABLE_300();
533 a69 := JTF_VARCHAR2_TABLE_300();
534 a70 := JTF_VARCHAR2_TABLE_300();
535 a71 := JTF_VARCHAR2_TABLE_300();
536 a72 := JTF_VARCHAR2_TABLE_100();
537 a73 := JTF_VARCHAR2_TABLE_100();
538 a74 := JTF_VARCHAR2_TABLE_300();
539 a75 := JTF_VARCHAR2_TABLE_300();
540 a76 := JTF_VARCHAR2_TABLE_300();
541 a77 := JTF_VARCHAR2_TABLE_300();
542 a78 := JTF_VARCHAR2_TABLE_300();
543 a79 := JTF_VARCHAR2_TABLE_300();
544 a80 := JTF_VARCHAR2_TABLE_300();
545 a81 := JTF_VARCHAR2_TABLE_300();
546 a82 := JTF_VARCHAR2_TABLE_300();
547 a83 := JTF_VARCHAR2_TABLE_300();
548 a84 := JTF_VARCHAR2_TABLE_300();
549 a85 := JTF_VARCHAR2_TABLE_300();
550 a86 := JTF_VARCHAR2_TABLE_300();
551 a87 := JTF_VARCHAR2_TABLE_300();
552 a88 := JTF_VARCHAR2_TABLE_300();
553 a89 := JTF_VARCHAR2_TABLE_300();
554 a90 := JTF_VARCHAR2_TABLE_300();
555 a91 := JTF_VARCHAR2_TABLE_300();
556 a92 := JTF_VARCHAR2_TABLE_300();
557 a93 := JTF_VARCHAR2_TABLE_300();
558 a94 := JTF_VARCHAR2_TABLE_300();
559 a95 := JTF_VARCHAR2_TABLE_300();
560 a96 := JTF_VARCHAR2_TABLE_300();
561 a97 := JTF_VARCHAR2_TABLE_300();
562 a98 := JTF_VARCHAR2_TABLE_300();
563 a99 := JTF_VARCHAR2_TABLE_300();
564 a100 := JTF_VARCHAR2_TABLE_300();
565 a101 := JTF_VARCHAR2_TABLE_300();
566 a102 := JTF_VARCHAR2_TABLE_300();
567 a103 := JTF_VARCHAR2_TABLE_300();
568 a104 := JTF_VARCHAR2_TABLE_100();
569 if t.count > 0 then
570 a0.extend(t.count);
571 a1.extend(t.count);
572 a2.extend(t.count);
573 a3.extend(t.count);
574 a4.extend(t.count);
575 a5.extend(t.count);
576 a6.extend(t.count);
577 a7.extend(t.count);
578 a8.extend(t.count);
579 a9.extend(t.count);
580 a10.extend(t.count);
581 a11.extend(t.count);
582 a12.extend(t.count);
583 a13.extend(t.count);
584 a14.extend(t.count);
585 a15.extend(t.count);
586 a16.extend(t.count);
587 a17.extend(t.count);
588 a18.extend(t.count);
589 a19.extend(t.count);
590 a20.extend(t.count);
591 a21.extend(t.count);
592 a22.extend(t.count);
593 a23.extend(t.count);
594 a24.extend(t.count);
595 a25.extend(t.count);
596 a26.extend(t.count);
597 a27.extend(t.count);
598 a28.extend(t.count);
599 a29.extend(t.count);
600 a30.extend(t.count);
601 a31.extend(t.count);
602 a32.extend(t.count);
603 a33.extend(t.count);
604 a34.extend(t.count);
605 a35.extend(t.count);
606 a36.extend(t.count);
607 a37.extend(t.count);
608 a38.extend(t.count);
609 a39.extend(t.count);
610 a40.extend(t.count);
611 a41.extend(t.count);
612 a42.extend(t.count);
613 a43.extend(t.count);
614 a44.extend(t.count);
615 a45.extend(t.count);
616 a46.extend(t.count);
617 a47.extend(t.count);
618 a48.extend(t.count);
619 a49.extend(t.count);
620 a50.extend(t.count);
621 a51.extend(t.count);
622 a52.extend(t.count);
623 a53.extend(t.count);
624 a54.extend(t.count);
625 a55.extend(t.count);
626 a56.extend(t.count);
627 a57.extend(t.count);
628 a58.extend(t.count);
629 a59.extend(t.count);
630 a60.extend(t.count);
631 a61.extend(t.count);
632 a62.extend(t.count);
633 a63.extend(t.count);
634 a64.extend(t.count);
635 a65.extend(t.count);
636 a66.extend(t.count);
637 a67.extend(t.count);
638 a68.extend(t.count);
639 a69.extend(t.count);
640 a70.extend(t.count);
641 a71.extend(t.count);
642 a72.extend(t.count);
643 a73.extend(t.count);
644 a74.extend(t.count);
645 a75.extend(t.count);
646 a76.extend(t.count);
647 a77.extend(t.count);
648 a78.extend(t.count);
649 a79.extend(t.count);
650 a80.extend(t.count);
651 a81.extend(t.count);
652 a82.extend(t.count);
653 a83.extend(t.count);
654 a84.extend(t.count);
655 a85.extend(t.count);
656 a86.extend(t.count);
657 a87.extend(t.count);
658 a88.extend(t.count);
659 a89.extend(t.count);
660 a90.extend(t.count);
661 a91.extend(t.count);
662 a92.extend(t.count);
663 a93.extend(t.count);
664 a94.extend(t.count);
665 a95.extend(t.count);
666 a96.extend(t.count);
667 a97.extend(t.count);
668 a98.extend(t.count);
669 a99.extend(t.count);
670 a100.extend(t.count);
671 a101.extend(t.count);
672 a102.extend(t.count);
673 a103.extend(t.count);
674 a104.extend(t.count);
675 ddindx := t.first;
676 indx := 1;
677 while true loop
678 a0(indx) := t(ddindx).attribute1;
679 a1(indx) := t(ddindx).attribute10;
680 a2(indx) := t(ddindx).attribute11;
681 a3(indx) := t(ddindx).attribute12;
682 a4(indx) := t(ddindx).attribute13;
683 a5(indx) := t(ddindx).attribute14;
684 a6(indx) := t(ddindx).attribute15;
685 a7(indx) := t(ddindx).attribute16;
686 a8(indx) := t(ddindx).attribute17;
687 a9(indx) := t(ddindx).attribute18;
688 a10(indx) := t(ddindx).attribute19;
689 a11(indx) := t(ddindx).attribute2;
690 a12(indx) := t(ddindx).attribute20;
691 a13(indx) := t(ddindx).attribute3;
692 a14(indx) := t(ddindx).attribute4;
693 a15(indx) := t(ddindx).attribute5;
694 a16(indx) := t(ddindx).attribute6;
695 a17(indx) := t(ddindx).attribute7;
696 a18(indx) := t(ddindx).attribute8;
697 a19(indx) := t(ddindx).attribute9;
698 a20(indx) := t(ddindx).global_attribute1;
699 a21(indx) := t(ddindx).global_attribute10;
700 a22(indx) := t(ddindx).global_attribute11;
701 a23(indx) := t(ddindx).global_attribute12;
702 a24(indx) := t(ddindx).global_attribute13;
703 a25(indx) := t(ddindx).global_attribute14;
704 a26(indx) := t(ddindx).global_attribute15;
705 a27(indx) := t(ddindx).global_attribute16;
706 a28(indx) := t(ddindx).global_attribute17;
707 a29(indx) := t(ddindx).global_attribute18;
708 a30(indx) := t(ddindx).global_attribute19;
709 a31(indx) := t(ddindx).global_attribute2;
710 a32(indx) := t(ddindx).global_attribute20;
711 a33(indx) := t(ddindx).global_attribute3;
712 a34(indx) := t(ddindx).global_attribute4;
713 a35(indx) := t(ddindx).global_attribute5;
714 a36(indx) := t(ddindx).global_attribute6;
715 a37(indx) := t(ddindx).global_attribute7;
716 a38(indx) := t(ddindx).global_attribute8;
717 a39(indx) := t(ddindx).global_attribute9;
718 a40(indx) := t(ddindx).global_attribute_category;
719 a41(indx) := rosetta_g_miss_num_map(t(ddindx).line_id);
720 a42(indx) := t(ddindx).industry_attribute1;
721 a43(indx) := t(ddindx).industry_attribute10;
722 a44(indx) := t(ddindx).industry_attribute11;
723 a45(indx) := t(ddindx).industry_attribute12;
724 a46(indx) := t(ddindx).industry_attribute13;
725 a47(indx) := t(ddindx).industry_attribute14;
726 a48(indx) := t(ddindx).industry_attribute15;
727 a49(indx) := t(ddindx).industry_attribute16;
728 a50(indx) := t(ddindx).industry_attribute17;
729 a51(indx) := t(ddindx).industry_attribute18;
730 a52(indx) := t(ddindx).industry_attribute19;
731 a53(indx) := t(ddindx).industry_attribute20;
732 a54(indx) := t(ddindx).industry_attribute21;
733 a55(indx) := t(ddindx).industry_attribute22;
734 a56(indx) := t(ddindx).industry_attribute23;
735 a57(indx) := t(ddindx).industry_attribute24;
736 a58(indx) := t(ddindx).industry_attribute25;
737 a59(indx) := t(ddindx).industry_attribute26;
738 a60(indx) := t(ddindx).industry_attribute27;
739 a61(indx) := t(ddindx).industry_attribute28;
740 a62(indx) := t(ddindx).industry_attribute29;
741 a63(indx) := t(ddindx).industry_attribute30;
742 a64(indx) := t(ddindx).industry_attribute2;
743 a65(indx) := t(ddindx).industry_attribute3;
744 a66(indx) := t(ddindx).industry_attribute4;
745 a67(indx) := t(ddindx).industry_attribute5;
746 a68(indx) := t(ddindx).industry_attribute6;
747 a69(indx) := t(ddindx).industry_attribute7;
748 a70(indx) := t(ddindx).industry_attribute8;
749 a71(indx) := t(ddindx).industry_attribute9;
750 a72(indx) := t(ddindx).industry_context;
751 a73(indx) := t(ddindx).tp_context;
752 a74(indx) := t(ddindx).tp_attribute1;
753 a75(indx) := t(ddindx).tp_attribute2;
754 a76(indx) := t(ddindx).tp_attribute3;
755 a77(indx) := t(ddindx).tp_attribute4;
756 a78(indx) := t(ddindx).tp_attribute5;
757 a79(indx) := t(ddindx).tp_attribute6;
758 a80(indx) := t(ddindx).tp_attribute7;
759 a81(indx) := t(ddindx).tp_attribute8;
760 a82(indx) := t(ddindx).tp_attribute9;
761 a83(indx) := t(ddindx).tp_attribute10;
762 a84(indx) := t(ddindx).tp_attribute11;
763 a85(indx) := t(ddindx).tp_attribute12;
764 a86(indx) := t(ddindx).tp_attribute13;
765 a87(indx) := t(ddindx).tp_attribute14;
766 a88(indx) := t(ddindx).tp_attribute15;
767 a89(indx) := t(ddindx).return_attribute1;
768 a90(indx) := t(ddindx).return_attribute10;
769 a91(indx) := t(ddindx).return_attribute11;
770 a92(indx) := t(ddindx).return_attribute12;
771 a93(indx) := t(ddindx).return_attribute13;
772 a94(indx) := t(ddindx).return_attribute14;
773 a95(indx) := t(ddindx).return_attribute15;
774 a96(indx) := t(ddindx).return_attribute2;
775 a97(indx) := t(ddindx).return_attribute3;
776 a98(indx) := t(ddindx).return_attribute4;
777 a99(indx) := t(ddindx).return_attribute5;
778 a100(indx) := t(ddindx).return_attribute6;
779 a101(indx) := t(ddindx).return_attribute7;
780 a102(indx) := t(ddindx).return_attribute8;
781 a103(indx) := t(ddindx).return_attribute9;
782 a104(indx) := t(ddindx).return_context;
783 indx := indx+1;
784 if t.last =ddindx
785 then exit;
786 end if;
787 ddindx := t.next(ddindx);
788 end loop;
789 end if;
790 end if;
791 end rosetta_table_copy_out_p1;
792
793 procedure rosetta_table_copy_in_p5(t out NOCOPY /* file.sql.39 change */ oe_oe_html_line_ext.line_ext_val_tbl_type, a0 JTF_VARCHAR2_TABLE_300
794 , a1 JTF_VARCHAR2_TABLE_300
795 , a2 JTF_VARCHAR2_TABLE_300
796 , a3 JTF_NUMBER_TABLE
797 , a4 JTF_VARCHAR2_TABLE_300
798 , a5 JTF_VARCHAR2_TABLE_300
799 , a6 JTF_VARCHAR2_TABLE_300
800 , a7 JTF_VARCHAR2_TABLE_300
801 , a8 JTF_VARCHAR2_TABLE_400
802 , a9 JTF_VARCHAR2_TABLE_300
803 , a10 JTF_VARCHAR2_TABLE_300
804 , a11 JTF_VARCHAR2_TABLE_300
805 , a12 JTF_VARCHAR2_TABLE_300
806 , a13 JTF_VARCHAR2_TABLE_300
807 , a14 JTF_VARCHAR2_TABLE_300
808 , a15 JTF_VARCHAR2_TABLE_300
809 , a16 JTF_VARCHAR2_TABLE_300
810 , a17 JTF_VARCHAR2_TABLE_300
811 , a18 JTF_VARCHAR2_TABLE_300
812 , a19 JTF_VARCHAR2_TABLE_300
813 , a20 JTF_VARCHAR2_TABLE_300
814 , a21 JTF_VARCHAR2_TABLE_300
815 , a22 JTF_VARCHAR2_TABLE_300
816 , a23 JTF_VARCHAR2_TABLE_300
817 , a24 JTF_VARCHAR2_TABLE_300
818 , a25 JTF_VARCHAR2_TABLE_300
819 , a26 JTF_VARCHAR2_TABLE_400
820 , a27 JTF_VARCHAR2_TABLE_300
821 , a28 JTF_VARCHAR2_TABLE_300
822 , a29 JTF_VARCHAR2_TABLE_300
823 , a30 JTF_VARCHAR2_TABLE_300
824 , a31 JTF_VARCHAR2_TABLE_300
825 , a32 JTF_VARCHAR2_TABLE_300
826 , a33 JTF_VARCHAR2_TABLE_300
827 , a34 JTF_VARCHAR2_TABLE_300
828 , a35 JTF_VARCHAR2_TABLE_300
829 , a36 JTF_VARCHAR2_TABLE_300
830 , a37 JTF_VARCHAR2_TABLE_300
831 , a38 JTF_VARCHAR2_TABLE_300
832 , a39 JTF_VARCHAR2_TABLE_300
833 , a40 JTF_VARCHAR2_TABLE_300
834 , a41 JTF_VARCHAR2_TABLE_300
835 , a42 JTF_VARCHAR2_TABLE_300
836 , a43 JTF_VARCHAR2_TABLE_300
837 , a44 JTF_VARCHAR2_TABLE_300
838 , a45 JTF_VARCHAR2_TABLE_300
839 , a46 JTF_VARCHAR2_TABLE_300
840 , a47 JTF_VARCHAR2_TABLE_300
841 , a48 JTF_VARCHAR2_TABLE_300
842 , a49 JTF_VARCHAR2_TABLE_300
843 , a50 JTF_VARCHAR2_TABLE_300
844 , a51 JTF_VARCHAR2_TABLE_100
845 , a52 JTF_VARCHAR2_TABLE_100
846 , a53 JTF_VARCHAR2_TABLE_100
847 , a54 JTF_VARCHAR2_TABLE_300
848 , a55 JTF_VARCHAR2_TABLE_300
849 , a56 JTF_VARCHAR2_TABLE_300
850 , a57 JTF_VARCHAR2_TABLE_300
851 , a58 JTF_VARCHAR2_TABLE_300
852 , a59 JTF_VARCHAR2_TABLE_300
853 , a60 JTF_VARCHAR2_TABLE_300
854 , a61 JTF_VARCHAR2_TABLE_300
855 , a62 JTF_VARCHAR2_TABLE_300
856 , a63 JTF_VARCHAR2_TABLE_300
857 , a64 JTF_VARCHAR2_TABLE_300
858 , a65 JTF_VARCHAR2_TABLE_300
859 , a66 JTF_VARCHAR2_TABLE_300
860 , a67 JTF_VARCHAR2_TABLE_300
861 , a68 JTF_VARCHAR2_TABLE_400
862 , a69 JTF_VARCHAR2_TABLE_300
863 , a70 JTF_VARCHAR2_TABLE_300
864 , a71 JTF_VARCHAR2_TABLE_300
865 , a72 JTF_VARCHAR2_TABLE_300
866 , a73 JTF_VARCHAR2_TABLE_300
867 , a74 JTF_VARCHAR2_TABLE_300
868 , a75 JTF_VARCHAR2_TABLE_300
869 , a76 JTF_VARCHAR2_TABLE_300
870 , a77 JTF_VARCHAR2_TABLE_300
871 , a78 JTF_VARCHAR2_TABLE_300
872 , a79 JTF_VARCHAR2_TABLE_300
873 , a80 JTF_VARCHAR2_TABLE_300
874 , a81 JTF_VARCHAR2_TABLE_300
875 , a82 JTF_VARCHAR2_TABLE_300
876 , a83 JTF_VARCHAR2_TABLE_300
877 , a84 JTF_VARCHAR2_TABLE_300
878 , a85 JTF_VARCHAR2_TABLE_300
879 , a86 JTF_VARCHAR2_TABLE_300
880 , a87 JTF_VARCHAR2_TABLE_400
881 , a88 JTF_VARCHAR2_TABLE_300
882 , a89 JTF_VARCHAR2_TABLE_300
883 , a90 JTF_VARCHAR2_TABLE_300
884 , a91 JTF_VARCHAR2_TABLE_300
885 , a92 JTF_VARCHAR2_TABLE_300
886 , a93 JTF_VARCHAR2_TABLE_300
887 , a94 JTF_VARCHAR2_TABLE_300
888 , a95 JTF_VARCHAR2_TABLE_300
889 , a96 JTF_NUMBER_TABLE
890 , a97 JTF_NUMBER_TABLE
891 , a98 JTF_NUMBER_TABLE
892 , a99 JTF_NUMBER_TABLE
893 , a100 JTF_VARCHAR2_TABLE_100
894 , a101 JTF_NUMBER_TABLE
895 , a102 JTF_VARCHAR2_TABLE_100
896 , a103 JTF_VARCHAR2_TABLE_100
897 , a104 JTF_VARCHAR2_TABLE_300
898 , a105 JTF_VARCHAR2_TABLE_100
899 , a106 JTF_VARCHAR2_TABLE_100
900 , a107 JTF_VARCHAR2_TABLE_300
901 , a108 JTF_VARCHAR2_TABLE_400
902 , a109 JTF_VARCHAR2_TABLE_400
903 , a110 JTF_VARCHAR2_TABLE_100
904 , a111 JTF_VARCHAR2_TABLE_100
905 , a112 JTF_NUMBER_TABLE
906 , a113 JTF_NUMBER_TABLE
907 , a114 JTF_NUMBER_TABLE
908 , a115 JTF_VARCHAR2_TABLE_100
909 , a116 JTF_VARCHAR2_TABLE_400
910 , a117 JTF_VARCHAR2_TABLE_2000
911 , a118 JTF_VARCHAR2_TABLE_2000
912 , a119 JTF_VARCHAR2_TABLE_300
913 , a120 JTF_VARCHAR2_TABLE_100
914 , a121 JTF_VARCHAR2_TABLE_400
915 , a122 JTF_VARCHAR2_TABLE_100
916 , a123 JTF_VARCHAR2_TABLE_400
917 , a124 JTF_VARCHAR2_TABLE_100
918 , a125 JTF_VARCHAR2_TABLE_400
919 , a126 JTF_VARCHAR2_TABLE_100
920 , a127 JTF_VARCHAR2_TABLE_300
921 , a128 JTF_VARCHAR2_TABLE_400
922 , a129 JTF_VARCHAR2_TABLE_100
923 , a130 JTF_VARCHAR2_TABLE_400
924 , a131 JTF_VARCHAR2_TABLE_300
925 , a132 JTF_VARCHAR2_TABLE_300
926 , a133 JTF_VARCHAR2_TABLE_300
927 , a134 JTF_VARCHAR2_TABLE_300
928 , a135 JTF_VARCHAR2_TABLE_300
929 , a136 JTF_VARCHAR2_TABLE_300
930 , a137 JTF_VARCHAR2_TABLE_300
931 , a138 JTF_VARCHAR2_TABLE_300
932 , a139 JTF_VARCHAR2_TABLE_300
933 , a140 JTF_VARCHAR2_TABLE_300
934 , a141 JTF_VARCHAR2_TABLE_300
935 , a142 JTF_VARCHAR2_TABLE_300
936 , a143 JTF_VARCHAR2_TABLE_300
937 , a144 JTF_VARCHAR2_TABLE_300
938 , a145 JTF_VARCHAR2_TABLE_400
939 , a146 JTF_NUMBER_TABLE
940 , a147 JTF_NUMBER_TABLE
941 , a148 JTF_NUMBER_TABLE
942 , a149 JTF_VARCHAR2_TABLE_100
943 , a150 JTF_VARCHAR2_TABLE_1000
944 ) as
945 ddindx binary_integer; indx binary_integer;
946 begin
947 if a0 is not null and a0.count > 0 then
948 if a0.count > 0 then
949 indx := a0.first;
950 ddindx := 1;
951 while true loop
952 t(ddindx).accounting_rule := a0(indx);
953 t(ddindx).agreement := a1(indx);
954 t(ddindx).commitment := a2(indx);
955 t(ddindx).commitment_applied_amount := rosetta_g_miss_num_map(a3(indx));
956 t(ddindx).deliver_to_address1 := a4(indx);
957 t(ddindx).deliver_to_address2 := a5(indx);
958 t(ddindx).deliver_to_address3 := a6(indx);
959 t(ddindx).deliver_to_address4 := a7(indx);
960 t(ddindx).deliver_to_contact := a8(indx);
961 t(ddindx).deliver_to_location := a9(indx);
962 t(ddindx).deliver_to_org := a10(indx);
963 t(ddindx).deliver_to_state := a11(indx);
964 t(ddindx).deliver_to_city := a12(indx);
965 t(ddindx).deliver_to_zip := a13(indx);
966 t(ddindx).deliver_to_country := a14(indx);
967 t(ddindx).deliver_to_county := a15(indx);
968 t(ddindx).deliver_to_province := a16(indx);
969 t(ddindx).demand_class := a17(indx);
970 t(ddindx).demand_bucket_type := a18(indx);
971 t(ddindx).fob_point := a19(indx);
972 t(ddindx).freight_terms := a20(indx);
973 t(ddindx).inventory_item := a21(indx);
974 t(ddindx).invoice_to_address1 := a22(indx);
975 t(ddindx).invoice_to_address2 := a23(indx);
976 t(ddindx).invoice_to_address3 := a24(indx);
977 t(ddindx).invoice_to_address4 := a25(indx);
978 t(ddindx).invoice_to_contact := a26(indx);
979 t(ddindx).invoice_to_location := a27(indx);
980 t(ddindx).invoice_to_org := a28(indx);
981 t(ddindx).invoice_to_state := a29(indx);
982 t(ddindx).invoice_to_city := a30(indx);
983 t(ddindx).invoice_to_zip := a31(indx);
984 t(ddindx).invoice_to_country := a32(indx);
985 t(ddindx).invoice_to_county := a33(indx);
986 t(ddindx).invoice_to_province := a34(indx);
987 t(ddindx).invoicing_rule := a35(indx);
988 t(ddindx).item_type := a36(indx);
989 t(ddindx).line_type := a37(indx);
990 t(ddindx).over_ship_reason := a38(indx);
991 t(ddindx).payment_term := a39(indx);
992 t(ddindx).price_list := a40(indx);
993 t(ddindx).project := a41(indx);
994 t(ddindx).return_reason := a42(indx);
995 t(ddindx).rla_schedule_type := a43(indx);
996 t(ddindx).salesrep := a44(indx);
997 t(ddindx).shipment_priority := a45(indx);
998 t(ddindx).ship_from_address1 := a46(indx);
999 t(ddindx).ship_from_address2 := a47(indx);
1000 t(ddindx).ship_from_address3 := a48(indx);
1001 t(ddindx).ship_from_address4 := a49(indx);
1002 t(ddindx).ship_from_location := a50(indx);
1003 t(ddindx).ship_from_city := a51(indx);
1004 t(ddindx).ship_from_postal_code := a52(indx);
1005 t(ddindx).ship_from_country := a53(indx);
1006 t(ddindx).ship_from_region1 := a54(indx);
1007 t(ddindx).ship_from_region2 := a55(indx);
1008 t(ddindx).ship_from_region3 := a56(indx);
1009 t(ddindx).ship_from_org := a57(indx);
1010 t(ddindx).ship_to_address1 := a58(indx);
1011 t(ddindx).ship_to_address2 := a59(indx);
1012 t(ddindx).ship_to_address3 := a60(indx);
1013 t(ddindx).ship_to_address4 := a61(indx);
1014 t(ddindx).ship_to_state := a62(indx);
1015 t(ddindx).ship_to_country := a63(indx);
1016 t(ddindx).ship_to_zip := a64(indx);
1017 t(ddindx).ship_to_county := a65(indx);
1018 t(ddindx).ship_to_province := a66(indx);
1019 t(ddindx).ship_to_city := a67(indx);
1020 t(ddindx).ship_to_contact := a68(indx);
1021 t(ddindx).ship_to_contact_last_name := a69(indx);
1022 t(ddindx).ship_to_contact_first_name := a70(indx);
1023 t(ddindx).ship_to_location := a71(indx);
1024 t(ddindx).ship_to_org := a72(indx);
1025 t(ddindx).source_type := a73(indx);
1026 t(ddindx).intermed_ship_to_address1 := a74(indx);
1027 t(ddindx).intermed_ship_to_address2 := a75(indx);
1028 t(ddindx).intermed_ship_to_address3 := a76(indx);
1029 t(ddindx).intermed_ship_to_address4 := a77(indx);
1030 t(ddindx).intermed_ship_to_contact := a78(indx);
1031 t(ddindx).intermed_ship_to_location := a79(indx);
1032 t(ddindx).intermed_ship_to_org := a80(indx);
1033 t(ddindx).intermed_ship_to_state := a81(indx);
1034 t(ddindx).intermed_ship_to_city := a82(indx);
1035 t(ddindx).intermed_ship_to_zip := a83(indx);
1036 t(ddindx).intermed_ship_to_country := a84(indx);
1037 t(ddindx).intermed_ship_to_county := a85(indx);
1038 t(ddindx).intermed_ship_to_province := a86(indx);
1039 t(ddindx).sold_to_org := a87(indx);
1040 t(ddindx).sold_from_org := a88(indx);
1041 t(ddindx).task := a89(indx);
1042 t(ddindx).tax_exempt := a90(indx);
1043 t(ddindx).tax_exempt_reason := a91(indx);
1044 t(ddindx).tax_point := a92(indx);
1045 t(ddindx).veh_cus_item_cum_key := a93(indx);
1046 t(ddindx).visible_demand := a94(indx);
1047 t(ddindx).customer_payment_term := a95(indx);
1048 t(ddindx).ref_order_number := rosetta_g_miss_num_map(a96(indx));
1049 t(ddindx).ref_line_number := rosetta_g_miss_num_map(a97(indx));
1050 t(ddindx).ref_shipment_number := rosetta_g_miss_num_map(a98(indx));
1051 t(ddindx).ref_option_number := rosetta_g_miss_num_map(a99(indx));
1052 t(ddindx).ref_invoice_number := a100(indx);
1053 t(ddindx).ref_invoice_line_number := rosetta_g_miss_num_map(a101(indx));
1054 t(ddindx).credit_invoice_number := a102(indx);
1055 t(ddindx).tax_group := a103(indx);
1056 t(ddindx).status := a104(indx);
1057 t(ddindx).freight_carrier := a105(indx);
1058 t(ddindx).shipping_method := a106(indx);
1059 t(ddindx).calculate_price_descr := a107(indx);
1060 t(ddindx).ship_to_customer_name := a108(indx);
1061 t(ddindx).invoice_to_customer_name := a109(indx);
1062 t(ddindx).ship_to_customer_number := a110(indx);
1063 t(ddindx).invoice_to_customer_number := a111(indx);
1064 t(ddindx).ship_to_customer_id := rosetta_g_miss_num_map(a112(indx));
1065 t(ddindx).invoice_to_customer_id := rosetta_g_miss_num_map(a113(indx));
1066 t(ddindx).deliver_to_customer_id := rosetta_g_miss_num_map(a114(indx));
1067 t(ddindx).deliver_to_customer_number := a115(indx);
1068 t(ddindx).deliver_to_customer_name := a116(indx);
1069 t(ddindx).original_ordered_item := a117(indx);
1070 t(ddindx).original_inventory_item := a118(indx);
1071 t(ddindx).original_item_identifier_type := a119(indx);
1072 t(ddindx).deliver_to_customer_number_oi := a120(indx);
1073 t(ddindx).deliver_to_customer_name_oi := a121(indx);
1074 t(ddindx).ship_to_customer_number_oi := a122(indx);
1075 t(ddindx).ship_to_customer_name_oi := a123(indx);
1076 t(ddindx).invoice_to_customer_number_oi := a124(indx);
1077 t(ddindx).invoice_to_customer_name_oi := a125(indx);
1078 t(ddindx).item_relationship_type_dsp := a126(indx);
1079 t(ddindx).transaction_phase := a127(indx);
1080 t(ddindx).end_customer_name := a128(indx);
1081 t(ddindx).end_customer_number := a129(indx);
1082 t(ddindx).end_customer_contact := a130(indx);
1083 t(ddindx).end_cust_contact_last_name := a131(indx);
1084 t(ddindx).end_cust_contact_first_name := a132(indx);
1085 t(ddindx).end_customer_site_address1 := a133(indx);
1086 t(ddindx).end_customer_site_address2 := a134(indx);
1087 t(ddindx).end_customer_site_address3 := a135(indx);
1088 t(ddindx).end_customer_site_address4 := a136(indx);
1089 t(ddindx).end_customer_site_location := a137(indx);
1090 t(ddindx).end_customer_site_state := a138(indx);
1091 t(ddindx).end_customer_site_country := a139(indx);
1092 t(ddindx).end_customer_site_zip := a140(indx);
1093 t(ddindx).end_customer_site_county := a141(indx);
1094 t(ddindx).end_customer_site_province := a142(indx);
1095 t(ddindx).end_customer_site_city := a143(indx);
1096 t(ddindx).end_customer_site_postal_code := a144(indx);
1097 t(ddindx).blanket_agreement_name := a145(indx);
1098 t(ddindx).extended_price := rosetta_g_miss_num_map(a146(indx));
1099 t(ddindx).unit_selling_price := rosetta_g_miss_num_map(a147(indx));
1100 t(ddindx).unit_list_price := rosetta_g_miss_num_map(a148(indx));
1101 t(ddindx).line_number := a149(indx);
1102 t(ddindx).item_description := a150(indx);
1103 ddindx := ddindx+1;
1104 if a0.last =indx
1105 then exit;
1106 end if;
1107 indx := a0.next(indx);
1108 end loop;
1109 end if;
1110 end if;
1111 end rosetta_table_copy_in_p5;
1112 procedure rosetta_table_copy_out_p5(t oe_oe_html_line_ext.line_ext_val_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1113 , a1 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1114 , a2 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1115 , a3 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1116 , a4 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1117 , a5 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1118 , a6 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1119 , a7 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1120 , a8 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_400
1121 , a9 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1122 , a10 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1123 , a11 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1124 , a12 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1125 , a13 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1126 , a14 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1127 , a15 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1128 , a16 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1129 , a17 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1130 , a18 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1131 , a19 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1132 , a20 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1133 , a21 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1134 , a22 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1135 , a23 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1136 , a24 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1137 , a25 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1138 , a26 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_400
1139 , a27 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1140 , a28 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1141 , a29 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1142 , a30 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1143 , a31 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1144 , a32 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1145 , a33 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1146 , a34 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1147 , a35 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1148 , a36 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1149 , a37 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1150 , a38 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1151 , a39 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1152 , a40 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1153 , a41 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1154 , a42 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1155 , a43 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1156 , a44 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1157 , a45 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1158 , a46 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1159 , a47 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1160 , a48 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1161 , a49 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1162 , a50 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1163 , a51 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1164 , a52 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1165 , a53 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1166 , a54 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1167 , a55 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1168 , a56 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1169 , a57 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1170 , a58 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1171 , a59 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1172 , a60 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1173 , a61 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1174 , a62 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1175 , a63 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1176 , a64 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1177 , a65 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1178 , a66 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1179 , a67 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1180 , a68 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_400
1181 , a69 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1182 , a70 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1183 , a71 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1184 , a72 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1185 , a73 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1186 , a74 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1187 , a75 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1188 , a76 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1189 , a77 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1190 , a78 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1191 , a79 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1192 , a80 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1193 , a81 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1194 , a82 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1195 , a83 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1196 , a84 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1197 , a85 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1198 , a86 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1199 , a87 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_400
1200 , a88 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1201 , a89 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1202 , a90 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1203 , a91 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1204 , a92 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1205 , a93 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1206 , a94 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1207 , a95 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1208 , a96 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1209 , a97 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1210 , a98 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1211 , a99 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1212 , a100 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1213 , a101 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1214 , a102 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1215 , a103 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1216 , a104 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1217 , a105 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1218 , a106 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1219 , a107 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1220 , a108 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_400
1221 , a109 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_400
1222 , a110 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1223 , a111 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1224 , a112 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1225 , a113 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1226 , a114 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1227 , a115 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1228 , a116 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_400
1229 , a117 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
1230 , a118 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
1231 , a119 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1232 , a120 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1233 , a121 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_400
1234 , a122 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1235 , a123 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_400
1236 , a124 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1237 , a125 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_400
1238 , a126 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1239 , a127 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1240 , a128 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_400
1241 , a129 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1242 , a130 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_400
1243 , a131 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1244 , a132 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1245 , a133 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1246 , a134 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1247 , a135 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1248 , a136 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1249 , a137 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1250 , a138 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1251 , a139 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1252 , a140 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1253 , a141 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1254 , a142 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1255 , a143 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1256 , a144 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1257 , a145 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_400
1258 , a146 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1259 , a147 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1260 , a148 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1261 , a149 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1262 , a150 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_1000
1263 ) as
1264 ddindx binary_integer; indx binary_integer;
1265 begin
1266 if t is null or t.count = 0 then
1267 a0 := JTF_VARCHAR2_TABLE_300();
1268 a1 := JTF_VARCHAR2_TABLE_300();
1269 a2 := JTF_VARCHAR2_TABLE_300();
1270 a3 := JTF_NUMBER_TABLE();
1271 a4 := JTF_VARCHAR2_TABLE_300();
1272 a5 := JTF_VARCHAR2_TABLE_300();
1273 a6 := JTF_VARCHAR2_TABLE_300();
1274 a7 := JTF_VARCHAR2_TABLE_300();
1275 a8 := JTF_VARCHAR2_TABLE_400();
1276 a9 := JTF_VARCHAR2_TABLE_300();
1277 a10 := JTF_VARCHAR2_TABLE_300();
1278 a11 := JTF_VARCHAR2_TABLE_300();
1279 a12 := JTF_VARCHAR2_TABLE_300();
1280 a13 := JTF_VARCHAR2_TABLE_300();
1281 a14 := JTF_VARCHAR2_TABLE_300();
1282 a15 := JTF_VARCHAR2_TABLE_300();
1283 a16 := JTF_VARCHAR2_TABLE_300();
1284 a17 := JTF_VARCHAR2_TABLE_300();
1285 a18 := JTF_VARCHAR2_TABLE_300();
1286 a19 := JTF_VARCHAR2_TABLE_300();
1287 a20 := JTF_VARCHAR2_TABLE_300();
1288 a21 := JTF_VARCHAR2_TABLE_300();
1289 a22 := JTF_VARCHAR2_TABLE_300();
1290 a23 := JTF_VARCHAR2_TABLE_300();
1291 a24 := JTF_VARCHAR2_TABLE_300();
1292 a25 := JTF_VARCHAR2_TABLE_300();
1293 a26 := JTF_VARCHAR2_TABLE_400();
1294 a27 := JTF_VARCHAR2_TABLE_300();
1295 a28 := JTF_VARCHAR2_TABLE_300();
1296 a29 := JTF_VARCHAR2_TABLE_300();
1297 a30 := JTF_VARCHAR2_TABLE_300();
1298 a31 := JTF_VARCHAR2_TABLE_300();
1299 a32 := JTF_VARCHAR2_TABLE_300();
1300 a33 := JTF_VARCHAR2_TABLE_300();
1301 a34 := JTF_VARCHAR2_TABLE_300();
1302 a35 := JTF_VARCHAR2_TABLE_300();
1303 a36 := JTF_VARCHAR2_TABLE_300();
1304 a37 := JTF_VARCHAR2_TABLE_300();
1305 a38 := JTF_VARCHAR2_TABLE_300();
1306 a39 := JTF_VARCHAR2_TABLE_300();
1307 a40 := JTF_VARCHAR2_TABLE_300();
1308 a41 := JTF_VARCHAR2_TABLE_300();
1309 a42 := JTF_VARCHAR2_TABLE_300();
1310 a43 := JTF_VARCHAR2_TABLE_300();
1311 a44 := JTF_VARCHAR2_TABLE_300();
1312 a45 := JTF_VARCHAR2_TABLE_300();
1313 a46 := JTF_VARCHAR2_TABLE_300();
1314 a47 := JTF_VARCHAR2_TABLE_300();
1315 a48 := JTF_VARCHAR2_TABLE_300();
1316 a49 := JTF_VARCHAR2_TABLE_300();
1317 a50 := JTF_VARCHAR2_TABLE_300();
1318 a51 := JTF_VARCHAR2_TABLE_100();
1319 a52 := JTF_VARCHAR2_TABLE_100();
1320 a53 := JTF_VARCHAR2_TABLE_100();
1321 a54 := JTF_VARCHAR2_TABLE_300();
1322 a55 := JTF_VARCHAR2_TABLE_300();
1323 a56 := JTF_VARCHAR2_TABLE_300();
1324 a57 := JTF_VARCHAR2_TABLE_300();
1325 a58 := JTF_VARCHAR2_TABLE_300();
1326 a59 := JTF_VARCHAR2_TABLE_300();
1327 a60 := JTF_VARCHAR2_TABLE_300();
1328 a61 := JTF_VARCHAR2_TABLE_300();
1329 a62 := JTF_VARCHAR2_TABLE_300();
1330 a63 := JTF_VARCHAR2_TABLE_300();
1331 a64 := JTF_VARCHAR2_TABLE_300();
1332 a65 := JTF_VARCHAR2_TABLE_300();
1333 a66 := JTF_VARCHAR2_TABLE_300();
1334 a67 := JTF_VARCHAR2_TABLE_300();
1335 a68 := JTF_VARCHAR2_TABLE_400();
1336 a69 := JTF_VARCHAR2_TABLE_300();
1337 a70 := JTF_VARCHAR2_TABLE_300();
1338 a71 := JTF_VARCHAR2_TABLE_300();
1339 a72 := JTF_VARCHAR2_TABLE_300();
1340 a73 := JTF_VARCHAR2_TABLE_300();
1341 a74 := JTF_VARCHAR2_TABLE_300();
1342 a75 := JTF_VARCHAR2_TABLE_300();
1343 a76 := JTF_VARCHAR2_TABLE_300();
1344 a77 := JTF_VARCHAR2_TABLE_300();
1345 a78 := JTF_VARCHAR2_TABLE_300();
1346 a79 := JTF_VARCHAR2_TABLE_300();
1347 a80 := JTF_VARCHAR2_TABLE_300();
1348 a81 := JTF_VARCHAR2_TABLE_300();
1349 a82 := JTF_VARCHAR2_TABLE_300();
1350 a83 := JTF_VARCHAR2_TABLE_300();
1351 a84 := JTF_VARCHAR2_TABLE_300();
1352 a85 := JTF_VARCHAR2_TABLE_300();
1353 a86 := JTF_VARCHAR2_TABLE_300();
1354 a87 := JTF_VARCHAR2_TABLE_400();
1355 a88 := JTF_VARCHAR2_TABLE_300();
1356 a89 := JTF_VARCHAR2_TABLE_300();
1357 a90 := JTF_VARCHAR2_TABLE_300();
1358 a91 := JTF_VARCHAR2_TABLE_300();
1359 a92 := JTF_VARCHAR2_TABLE_300();
1360 a93 := JTF_VARCHAR2_TABLE_300();
1361 a94 := JTF_VARCHAR2_TABLE_300();
1362 a95 := JTF_VARCHAR2_TABLE_300();
1363 a96 := JTF_NUMBER_TABLE();
1364 a97 := JTF_NUMBER_TABLE();
1365 a98 := JTF_NUMBER_TABLE();
1366 a99 := JTF_NUMBER_TABLE();
1367 a100 := JTF_VARCHAR2_TABLE_100();
1368 a101 := JTF_NUMBER_TABLE();
1369 a102 := JTF_VARCHAR2_TABLE_100();
1370 a103 := JTF_VARCHAR2_TABLE_100();
1371 a104 := JTF_VARCHAR2_TABLE_300();
1372 a105 := JTF_VARCHAR2_TABLE_100();
1373 a106 := JTF_VARCHAR2_TABLE_100();
1374 a107 := JTF_VARCHAR2_TABLE_300();
1375 a108 := JTF_VARCHAR2_TABLE_400();
1376 a109 := JTF_VARCHAR2_TABLE_400();
1377 a110 := JTF_VARCHAR2_TABLE_100();
1378 a111 := JTF_VARCHAR2_TABLE_100();
1379 a112 := JTF_NUMBER_TABLE();
1380 a113 := JTF_NUMBER_TABLE();
1381 a114 := JTF_NUMBER_TABLE();
1382 a115 := JTF_VARCHAR2_TABLE_100();
1383 a116 := JTF_VARCHAR2_TABLE_400();
1384 a117 := JTF_VARCHAR2_TABLE_2000();
1385 a118 := JTF_VARCHAR2_TABLE_2000();
1386 a119 := JTF_VARCHAR2_TABLE_300();
1387 a120 := JTF_VARCHAR2_TABLE_100();
1388 a121 := JTF_VARCHAR2_TABLE_400();
1389 a122 := JTF_VARCHAR2_TABLE_100();
1390 a123 := JTF_VARCHAR2_TABLE_400();
1391 a124 := JTF_VARCHAR2_TABLE_100();
1392 a125 := JTF_VARCHAR2_TABLE_400();
1393 a126 := JTF_VARCHAR2_TABLE_100();
1394 a127 := JTF_VARCHAR2_TABLE_300();
1395 a128 := JTF_VARCHAR2_TABLE_400();
1396 a129 := JTF_VARCHAR2_TABLE_100();
1397 a130 := JTF_VARCHAR2_TABLE_400();
1398 a131 := JTF_VARCHAR2_TABLE_300();
1399 a132 := JTF_VARCHAR2_TABLE_300();
1400 a133 := JTF_VARCHAR2_TABLE_300();
1401 a134 := JTF_VARCHAR2_TABLE_300();
1402 a135 := JTF_VARCHAR2_TABLE_300();
1403 a136 := JTF_VARCHAR2_TABLE_300();
1404 a137 := JTF_VARCHAR2_TABLE_300();
1405 a138 := JTF_VARCHAR2_TABLE_300();
1406 a139 := JTF_VARCHAR2_TABLE_300();
1407 a140 := JTF_VARCHAR2_TABLE_300();
1408 a141 := JTF_VARCHAR2_TABLE_300();
1409 a142 := JTF_VARCHAR2_TABLE_300();
1410 a143 := JTF_VARCHAR2_TABLE_300();
1411 a144 := JTF_VARCHAR2_TABLE_300();
1412 a145 := JTF_VARCHAR2_TABLE_400();
1413 a146 := JTF_NUMBER_TABLE();
1414 a147 := JTF_NUMBER_TABLE();
1415 a148 := JTF_NUMBER_TABLE();
1416 a149 := JTF_VARCHAR2_TABLE_100();
1417 a150 := JTF_VARCHAR2_TABLE_1000();
1418 else
1419 a0 := JTF_VARCHAR2_TABLE_300();
1420 a1 := JTF_VARCHAR2_TABLE_300();
1421 a2 := JTF_VARCHAR2_TABLE_300();
1422 a3 := JTF_NUMBER_TABLE();
1423 a4 := JTF_VARCHAR2_TABLE_300();
1424 a5 := JTF_VARCHAR2_TABLE_300();
1425 a6 := JTF_VARCHAR2_TABLE_300();
1426 a7 := JTF_VARCHAR2_TABLE_300();
1427 a8 := JTF_VARCHAR2_TABLE_400();
1428 a9 := JTF_VARCHAR2_TABLE_300();
1429 a10 := JTF_VARCHAR2_TABLE_300();
1430 a11 := JTF_VARCHAR2_TABLE_300();
1431 a12 := JTF_VARCHAR2_TABLE_300();
1432 a13 := JTF_VARCHAR2_TABLE_300();
1433 a14 := JTF_VARCHAR2_TABLE_300();
1434 a15 := JTF_VARCHAR2_TABLE_300();
1435 a16 := JTF_VARCHAR2_TABLE_300();
1436 a17 := JTF_VARCHAR2_TABLE_300();
1437 a18 := JTF_VARCHAR2_TABLE_300();
1438 a19 := JTF_VARCHAR2_TABLE_300();
1439 a20 := JTF_VARCHAR2_TABLE_300();
1440 a21 := JTF_VARCHAR2_TABLE_300();
1441 a22 := JTF_VARCHAR2_TABLE_300();
1442 a23 := JTF_VARCHAR2_TABLE_300();
1443 a24 := JTF_VARCHAR2_TABLE_300();
1444 a25 := JTF_VARCHAR2_TABLE_300();
1445 a26 := JTF_VARCHAR2_TABLE_400();
1446 a27 := JTF_VARCHAR2_TABLE_300();
1447 a28 := JTF_VARCHAR2_TABLE_300();
1448 a29 := JTF_VARCHAR2_TABLE_300();
1449 a30 := JTF_VARCHAR2_TABLE_300();
1450 a31 := JTF_VARCHAR2_TABLE_300();
1451 a32 := JTF_VARCHAR2_TABLE_300();
1452 a33 := JTF_VARCHAR2_TABLE_300();
1453 a34 := JTF_VARCHAR2_TABLE_300();
1454 a35 := JTF_VARCHAR2_TABLE_300();
1455 a36 := JTF_VARCHAR2_TABLE_300();
1456 a37 := JTF_VARCHAR2_TABLE_300();
1457 a38 := JTF_VARCHAR2_TABLE_300();
1458 a39 := JTF_VARCHAR2_TABLE_300();
1459 a40 := JTF_VARCHAR2_TABLE_300();
1460 a41 := JTF_VARCHAR2_TABLE_300();
1461 a42 := JTF_VARCHAR2_TABLE_300();
1462 a43 := JTF_VARCHAR2_TABLE_300();
1463 a44 := JTF_VARCHAR2_TABLE_300();
1464 a45 := JTF_VARCHAR2_TABLE_300();
1465 a46 := JTF_VARCHAR2_TABLE_300();
1466 a47 := JTF_VARCHAR2_TABLE_300();
1467 a48 := JTF_VARCHAR2_TABLE_300();
1468 a49 := JTF_VARCHAR2_TABLE_300();
1469 a50 := JTF_VARCHAR2_TABLE_300();
1470 a51 := JTF_VARCHAR2_TABLE_100();
1471 a52 := JTF_VARCHAR2_TABLE_100();
1472 a53 := JTF_VARCHAR2_TABLE_100();
1473 a54 := JTF_VARCHAR2_TABLE_300();
1474 a55 := JTF_VARCHAR2_TABLE_300();
1475 a56 := JTF_VARCHAR2_TABLE_300();
1476 a57 := JTF_VARCHAR2_TABLE_300();
1477 a58 := JTF_VARCHAR2_TABLE_300();
1478 a59 := JTF_VARCHAR2_TABLE_300();
1479 a60 := JTF_VARCHAR2_TABLE_300();
1480 a61 := JTF_VARCHAR2_TABLE_300();
1481 a62 := JTF_VARCHAR2_TABLE_300();
1482 a63 := JTF_VARCHAR2_TABLE_300();
1483 a64 := JTF_VARCHAR2_TABLE_300();
1484 a65 := JTF_VARCHAR2_TABLE_300();
1485 a66 := JTF_VARCHAR2_TABLE_300();
1486 a67 := JTF_VARCHAR2_TABLE_300();
1487 a68 := JTF_VARCHAR2_TABLE_400();
1488 a69 := JTF_VARCHAR2_TABLE_300();
1489 a70 := JTF_VARCHAR2_TABLE_300();
1490 a71 := JTF_VARCHAR2_TABLE_300();
1491 a72 := JTF_VARCHAR2_TABLE_300();
1492 a73 := JTF_VARCHAR2_TABLE_300();
1493 a74 := JTF_VARCHAR2_TABLE_300();
1494 a75 := JTF_VARCHAR2_TABLE_300();
1495 a76 := JTF_VARCHAR2_TABLE_300();
1496 a77 := JTF_VARCHAR2_TABLE_300();
1497 a78 := JTF_VARCHAR2_TABLE_300();
1498 a79 := JTF_VARCHAR2_TABLE_300();
1499 a80 := JTF_VARCHAR2_TABLE_300();
1500 a81 := JTF_VARCHAR2_TABLE_300();
1501 a82 := JTF_VARCHAR2_TABLE_300();
1502 a83 := JTF_VARCHAR2_TABLE_300();
1503 a84 := JTF_VARCHAR2_TABLE_300();
1504 a85 := JTF_VARCHAR2_TABLE_300();
1505 a86 := JTF_VARCHAR2_TABLE_300();
1506 a87 := JTF_VARCHAR2_TABLE_400();
1507 a88 := JTF_VARCHAR2_TABLE_300();
1508 a89 := JTF_VARCHAR2_TABLE_300();
1509 a90 := JTF_VARCHAR2_TABLE_300();
1510 a91 := JTF_VARCHAR2_TABLE_300();
1511 a92 := JTF_VARCHAR2_TABLE_300();
1512 a93 := JTF_VARCHAR2_TABLE_300();
1513 a94 := JTF_VARCHAR2_TABLE_300();
1514 a95 := JTF_VARCHAR2_TABLE_300();
1515 a96 := JTF_NUMBER_TABLE();
1516 a97 := JTF_NUMBER_TABLE();
1517 a98 := JTF_NUMBER_TABLE();
1518 a99 := JTF_NUMBER_TABLE();
1519 a100 := JTF_VARCHAR2_TABLE_100();
1520 a101 := JTF_NUMBER_TABLE();
1521 a102 := JTF_VARCHAR2_TABLE_100();
1522 a103 := JTF_VARCHAR2_TABLE_100();
1523 a104 := JTF_VARCHAR2_TABLE_300();
1524 a105 := JTF_VARCHAR2_TABLE_100();
1525 a106 := JTF_VARCHAR2_TABLE_100();
1526 a107 := JTF_VARCHAR2_TABLE_300();
1527 a108 := JTF_VARCHAR2_TABLE_400();
1528 a109 := JTF_VARCHAR2_TABLE_400();
1529 a110 := JTF_VARCHAR2_TABLE_100();
1530 a111 := JTF_VARCHAR2_TABLE_100();
1531 a112 := JTF_NUMBER_TABLE();
1532 a113 := JTF_NUMBER_TABLE();
1533 a114 := JTF_NUMBER_TABLE();
1534 a115 := JTF_VARCHAR2_TABLE_100();
1535 a116 := JTF_VARCHAR2_TABLE_400();
1536 a117 := JTF_VARCHAR2_TABLE_2000();
1537 a118 := JTF_VARCHAR2_TABLE_2000();
1538 a119 := JTF_VARCHAR2_TABLE_300();
1539 a120 := JTF_VARCHAR2_TABLE_100();
1540 a121 := JTF_VARCHAR2_TABLE_400();
1541 a122 := JTF_VARCHAR2_TABLE_100();
1542 a123 := JTF_VARCHAR2_TABLE_400();
1543 a124 := JTF_VARCHAR2_TABLE_100();
1544 a125 := JTF_VARCHAR2_TABLE_400();
1545 a126 := JTF_VARCHAR2_TABLE_100();
1546 a127 := JTF_VARCHAR2_TABLE_300();
1547 a128 := JTF_VARCHAR2_TABLE_400();
1548 a129 := JTF_VARCHAR2_TABLE_100();
1549 a130 := JTF_VARCHAR2_TABLE_400();
1550 a131 := JTF_VARCHAR2_TABLE_300();
1551 a132 := JTF_VARCHAR2_TABLE_300();
1552 a133 := JTF_VARCHAR2_TABLE_300();
1553 a134 := JTF_VARCHAR2_TABLE_300();
1554 a135 := JTF_VARCHAR2_TABLE_300();
1555 a136 := JTF_VARCHAR2_TABLE_300();
1556 a137 := JTF_VARCHAR2_TABLE_300();
1557 a138 := JTF_VARCHAR2_TABLE_300();
1558 a139 := JTF_VARCHAR2_TABLE_300();
1559 a140 := JTF_VARCHAR2_TABLE_300();
1560 a141 := JTF_VARCHAR2_TABLE_300();
1561 a142 := JTF_VARCHAR2_TABLE_300();
1562 a143 := JTF_VARCHAR2_TABLE_300();
1563 a144 := JTF_VARCHAR2_TABLE_300();
1564 a145 := JTF_VARCHAR2_TABLE_400();
1565 a146 := JTF_NUMBER_TABLE();
1566 a147 := JTF_NUMBER_TABLE();
1567 a148 := JTF_NUMBER_TABLE();
1568 a149 := JTF_VARCHAR2_TABLE_100();
1569 a150 := JTF_VARCHAR2_TABLE_1000();
1570 if t.count > 0 then
1571 a0.extend(t.count);
1572 a1.extend(t.count);
1573 a2.extend(t.count);
1574 a3.extend(t.count);
1575 a4.extend(t.count);
1576 a5.extend(t.count);
1577 a6.extend(t.count);
1578 a7.extend(t.count);
1579 a8.extend(t.count);
1580 a9.extend(t.count);
1581 a10.extend(t.count);
1582 a11.extend(t.count);
1583 a12.extend(t.count);
1584 a13.extend(t.count);
1585 a14.extend(t.count);
1586 a15.extend(t.count);
1587 a16.extend(t.count);
1588 a17.extend(t.count);
1589 a18.extend(t.count);
1590 a19.extend(t.count);
1591 a20.extend(t.count);
1592 a21.extend(t.count);
1593 a22.extend(t.count);
1594 a23.extend(t.count);
1595 a24.extend(t.count);
1596 a25.extend(t.count);
1597 a26.extend(t.count);
1598 a27.extend(t.count);
1599 a28.extend(t.count);
1600 a29.extend(t.count);
1601 a30.extend(t.count);
1602 a31.extend(t.count);
1603 a32.extend(t.count);
1604 a33.extend(t.count);
1605 a34.extend(t.count);
1606 a35.extend(t.count);
1607 a36.extend(t.count);
1608 a37.extend(t.count);
1609 a38.extend(t.count);
1610 a39.extend(t.count);
1611 a40.extend(t.count);
1612 a41.extend(t.count);
1613 a42.extend(t.count);
1614 a43.extend(t.count);
1615 a44.extend(t.count);
1616 a45.extend(t.count);
1617 a46.extend(t.count);
1618 a47.extend(t.count);
1619 a48.extend(t.count);
1620 a49.extend(t.count);
1621 a50.extend(t.count);
1622 a51.extend(t.count);
1623 a52.extend(t.count);
1624 a53.extend(t.count);
1625 a54.extend(t.count);
1626 a55.extend(t.count);
1627 a56.extend(t.count);
1628 a57.extend(t.count);
1629 a58.extend(t.count);
1630 a59.extend(t.count);
1631 a60.extend(t.count);
1632 a61.extend(t.count);
1633 a62.extend(t.count);
1634 a63.extend(t.count);
1635 a64.extend(t.count);
1636 a65.extend(t.count);
1637 a66.extend(t.count);
1638 a67.extend(t.count);
1639 a68.extend(t.count);
1640 a69.extend(t.count);
1641 a70.extend(t.count);
1642 a71.extend(t.count);
1643 a72.extend(t.count);
1644 a73.extend(t.count);
1645 a74.extend(t.count);
1646 a75.extend(t.count);
1647 a76.extend(t.count);
1648 a77.extend(t.count);
1649 a78.extend(t.count);
1650 a79.extend(t.count);
1651 a80.extend(t.count);
1652 a81.extend(t.count);
1653 a82.extend(t.count);
1654 a83.extend(t.count);
1655 a84.extend(t.count);
1656 a85.extend(t.count);
1657 a86.extend(t.count);
1658 a87.extend(t.count);
1659 a88.extend(t.count);
1660 a89.extend(t.count);
1661 a90.extend(t.count);
1662 a91.extend(t.count);
1663 a92.extend(t.count);
1664 a93.extend(t.count);
1665 a94.extend(t.count);
1666 a95.extend(t.count);
1667 a96.extend(t.count);
1668 a97.extend(t.count);
1669 a98.extend(t.count);
1670 a99.extend(t.count);
1671 a100.extend(t.count);
1672 a101.extend(t.count);
1673 a102.extend(t.count);
1674 a103.extend(t.count);
1675 a104.extend(t.count);
1676 a105.extend(t.count);
1677 a106.extend(t.count);
1678 a107.extend(t.count);
1679 a108.extend(t.count);
1680 a109.extend(t.count);
1681 a110.extend(t.count);
1682 a111.extend(t.count);
1683 a112.extend(t.count);
1684 a113.extend(t.count);
1685 a114.extend(t.count);
1686 a115.extend(t.count);
1687 a116.extend(t.count);
1688 a117.extend(t.count);
1689 a118.extend(t.count);
1690 a119.extend(t.count);
1691 a120.extend(t.count);
1692 a121.extend(t.count);
1693 a122.extend(t.count);
1694 a123.extend(t.count);
1695 a124.extend(t.count);
1696 a125.extend(t.count);
1697 a126.extend(t.count);
1698 a127.extend(t.count);
1699 a128.extend(t.count);
1700 a129.extend(t.count);
1701 a130.extend(t.count);
1702 a131.extend(t.count);
1703 a132.extend(t.count);
1704 a133.extend(t.count);
1705 a134.extend(t.count);
1706 a135.extend(t.count);
1707 a136.extend(t.count);
1708 a137.extend(t.count);
1709 a138.extend(t.count);
1710 a139.extend(t.count);
1711 a140.extend(t.count);
1712 a141.extend(t.count);
1713 a142.extend(t.count);
1714 a143.extend(t.count);
1715 a144.extend(t.count);
1716 a145.extend(t.count);
1717 a146.extend(t.count);
1718 a147.extend(t.count);
1719 a148.extend(t.count);
1720 a149.extend(t.count);
1721 a150.extend(t.count);
1722 ddindx := t.first;
1723 indx := 1;
1724 while true loop
1725 a0(indx) := t(ddindx).accounting_rule;
1726 a1(indx) := t(ddindx).agreement;
1727 a2(indx) := t(ddindx).commitment;
1728 a3(indx) := rosetta_g_miss_num_map(t(ddindx).commitment_applied_amount);
1729 a4(indx) := t(ddindx).deliver_to_address1;
1730 a5(indx) := t(ddindx).deliver_to_address2;
1731 a6(indx) := t(ddindx).deliver_to_address3;
1732 a7(indx) := t(ddindx).deliver_to_address4;
1733 a8(indx) := t(ddindx).deliver_to_contact;
1734 a9(indx) := t(ddindx).deliver_to_location;
1735 a10(indx) := t(ddindx).deliver_to_org;
1736 a11(indx) := t(ddindx).deliver_to_state;
1737 a12(indx) := t(ddindx).deliver_to_city;
1738 a13(indx) := t(ddindx).deliver_to_zip;
1739 a14(indx) := t(ddindx).deliver_to_country;
1740 a15(indx) := t(ddindx).deliver_to_county;
1741 a16(indx) := t(ddindx).deliver_to_province;
1742 a17(indx) := t(ddindx).demand_class;
1743 a18(indx) := t(ddindx).demand_bucket_type;
1744 a19(indx) := t(ddindx).fob_point;
1745 a20(indx) := t(ddindx).freight_terms;
1746 a21(indx) := t(ddindx).inventory_item;
1747 a22(indx) := t(ddindx).invoice_to_address1;
1748 a23(indx) := t(ddindx).invoice_to_address2;
1749 a24(indx) := t(ddindx).invoice_to_address3;
1750 a25(indx) := t(ddindx).invoice_to_address4;
1751 a26(indx) := t(ddindx).invoice_to_contact;
1752 a27(indx) := t(ddindx).invoice_to_location;
1753 a28(indx) := t(ddindx).invoice_to_org;
1754 a29(indx) := t(ddindx).invoice_to_state;
1755 a30(indx) := t(ddindx).invoice_to_city;
1756 a31(indx) := t(ddindx).invoice_to_zip;
1757 a32(indx) := t(ddindx).invoice_to_country;
1758 a33(indx) := t(ddindx).invoice_to_county;
1759 a34(indx) := t(ddindx).invoice_to_province;
1760 a35(indx) := t(ddindx).invoicing_rule;
1761 a36(indx) := t(ddindx).item_type;
1762 a37(indx) := t(ddindx).line_type;
1763 a38(indx) := t(ddindx).over_ship_reason;
1764 a39(indx) := t(ddindx).payment_term;
1765 a40(indx) := t(ddindx).price_list;
1766 a41(indx) := t(ddindx).project;
1767 a42(indx) := t(ddindx).return_reason;
1768 a43(indx) := t(ddindx).rla_schedule_type;
1769 a44(indx) := t(ddindx).salesrep;
1770 a45(indx) := t(ddindx).shipment_priority;
1771 a46(indx) := t(ddindx).ship_from_address1;
1772 a47(indx) := t(ddindx).ship_from_address2;
1773 a48(indx) := t(ddindx).ship_from_address3;
1774 a49(indx) := t(ddindx).ship_from_address4;
1775 a50(indx) := t(ddindx).ship_from_location;
1776 a51(indx) := t(ddindx).ship_from_city;
1777 a52(indx) := t(ddindx).ship_from_postal_code;
1778 a53(indx) := t(ddindx).ship_from_country;
1779 a54(indx) := t(ddindx).ship_from_region1;
1780 a55(indx) := t(ddindx).ship_from_region2;
1781 a56(indx) := t(ddindx).ship_from_region3;
1782 a57(indx) := t(ddindx).ship_from_org;
1783 a58(indx) := t(ddindx).ship_to_address1;
1784 a59(indx) := t(ddindx).ship_to_address2;
1785 a60(indx) := t(ddindx).ship_to_address3;
1786 a61(indx) := t(ddindx).ship_to_address4;
1787 a62(indx) := t(ddindx).ship_to_state;
1788 a63(indx) := t(ddindx).ship_to_country;
1789 a64(indx) := t(ddindx).ship_to_zip;
1790 a65(indx) := t(ddindx).ship_to_county;
1791 a66(indx) := t(ddindx).ship_to_province;
1792 a67(indx) := t(ddindx).ship_to_city;
1793 a68(indx) := t(ddindx).ship_to_contact;
1794 a69(indx) := t(ddindx).ship_to_contact_last_name;
1795 a70(indx) := t(ddindx).ship_to_contact_first_name;
1796 a71(indx) := t(ddindx).ship_to_location;
1797 a72(indx) := t(ddindx).ship_to_org;
1798 a73(indx) := t(ddindx).source_type;
1799 a74(indx) := t(ddindx).intermed_ship_to_address1;
1800 a75(indx) := t(ddindx).intermed_ship_to_address2;
1801 a76(indx) := t(ddindx).intermed_ship_to_address3;
1802 a77(indx) := t(ddindx).intermed_ship_to_address4;
1803 a78(indx) := t(ddindx).intermed_ship_to_contact;
1804 a79(indx) := t(ddindx).intermed_ship_to_location;
1805 a80(indx) := t(ddindx).intermed_ship_to_org;
1806 a81(indx) := t(ddindx).intermed_ship_to_state;
1807 a82(indx) := t(ddindx).intermed_ship_to_city;
1808 a83(indx) := t(ddindx).intermed_ship_to_zip;
1809 a84(indx) := t(ddindx).intermed_ship_to_country;
1810 a85(indx) := t(ddindx).intermed_ship_to_county;
1811 a86(indx) := t(ddindx).intermed_ship_to_province;
1812 a87(indx) := t(ddindx).sold_to_org;
1813 a88(indx) := t(ddindx).sold_from_org;
1814 a89(indx) := t(ddindx).task;
1815 a90(indx) := t(ddindx).tax_exempt;
1816 a91(indx) := t(ddindx).tax_exempt_reason;
1817 a92(indx) := t(ddindx).tax_point;
1818 a93(indx) := t(ddindx).veh_cus_item_cum_key;
1819 a94(indx) := t(ddindx).visible_demand;
1820 a95(indx) := t(ddindx).customer_payment_term;
1821 a96(indx) := rosetta_g_miss_num_map(t(ddindx).ref_order_number);
1822 a97(indx) := rosetta_g_miss_num_map(t(ddindx).ref_line_number);
1823 a98(indx) := rosetta_g_miss_num_map(t(ddindx).ref_shipment_number);
1824 a99(indx) := rosetta_g_miss_num_map(t(ddindx).ref_option_number);
1825 a100(indx) := t(ddindx).ref_invoice_number;
1826 a101(indx) := rosetta_g_miss_num_map(t(ddindx).ref_invoice_line_number);
1827 a102(indx) := t(ddindx).credit_invoice_number;
1828 a103(indx) := t(ddindx).tax_group;
1829 a104(indx) := t(ddindx).status;
1830 a105(indx) := t(ddindx).freight_carrier;
1831 a106(indx) := t(ddindx).shipping_method;
1832 a107(indx) := t(ddindx).calculate_price_descr;
1833 a108(indx) := t(ddindx).ship_to_customer_name;
1834 a109(indx) := t(ddindx).invoice_to_customer_name;
1835 a110(indx) := t(ddindx).ship_to_customer_number;
1836 a111(indx) := t(ddindx).invoice_to_customer_number;
1837 a112(indx) := rosetta_g_miss_num_map(t(ddindx).ship_to_customer_id);
1838 a113(indx) := rosetta_g_miss_num_map(t(ddindx).invoice_to_customer_id);
1839 a114(indx) := rosetta_g_miss_num_map(t(ddindx).deliver_to_customer_id);
1840 a115(indx) := t(ddindx).deliver_to_customer_number;
1841 a116(indx) := t(ddindx).deliver_to_customer_name;
1842 a117(indx) := t(ddindx).original_ordered_item;
1843 a118(indx) := t(ddindx).original_inventory_item;
1844 a119(indx) := t(ddindx).original_item_identifier_type;
1845 a120(indx) := t(ddindx).deliver_to_customer_number_oi;
1846 a121(indx) := t(ddindx).deliver_to_customer_name_oi;
1847 a122(indx) := t(ddindx).ship_to_customer_number_oi;
1848 a123(indx) := t(ddindx).ship_to_customer_name_oi;
1849 a124(indx) := t(ddindx).invoice_to_customer_number_oi;
1850 a125(indx) := t(ddindx).invoice_to_customer_name_oi;
1851 a126(indx) := t(ddindx).item_relationship_type_dsp;
1852 a127(indx) := t(ddindx).transaction_phase;
1853 a128(indx) := t(ddindx).end_customer_name;
1854 a129(indx) := t(ddindx).end_customer_number;
1855 a130(indx) := t(ddindx).end_customer_contact;
1856 a131(indx) := t(ddindx).end_cust_contact_last_name;
1857 a132(indx) := t(ddindx).end_cust_contact_first_name;
1858 a133(indx) := t(ddindx).end_customer_site_address1;
1859 a134(indx) := t(ddindx).end_customer_site_address2;
1860 a135(indx) := t(ddindx).end_customer_site_address3;
1861 a136(indx) := t(ddindx).end_customer_site_address4;
1862 a137(indx) := t(ddindx).end_customer_site_location;
1863 a138(indx) := t(ddindx).end_customer_site_state;
1864 a139(indx) := t(ddindx).end_customer_site_country;
1865 a140(indx) := t(ddindx).end_customer_site_zip;
1866 a141(indx) := t(ddindx).end_customer_site_county;
1867 a142(indx) := t(ddindx).end_customer_site_province;
1868 a143(indx) := t(ddindx).end_customer_site_city;
1869 a144(indx) := t(ddindx).end_customer_site_postal_code;
1870 a145(indx) := t(ddindx).blanket_agreement_name;
1871 a146(indx) := rosetta_g_miss_num_map(t(ddindx).extended_price);
1872 a147(indx) := rosetta_g_miss_num_map(t(ddindx).unit_selling_price);
1873 a148(indx) := rosetta_g_miss_num_map(t(ddindx).unit_list_price);
1874 a149(indx) := t(ddindx).line_number;
1875 a150(indx) := t(ddindx).item_description;
1876 indx := indx+1;
1877 if t.last =ddindx
1878 then exit;
1879 end if;
1880 ddindx := t.next(ddindx);
1881 end loop;
1882 end if;
1883 end if;
1884 end rosetta_table_copy_out_p5;
1885
1886 procedure save_lines(x_return_status out NOCOPY /* file.sql.39 change */ VARCHAR2
1887 , x_msg_count out NOCOPY /* file.sql.39 change */ NUMBER
1888 , x_msg_data out NOCOPY /* file.sql.39 change */ VARCHAR2
1889 , x_cascade_flag out NOCOPY /* file.sql.39 change */ number
1890 , p4_a0 JTF_NUMBER_TABLE
1891 , p4_a1 JTF_DATE_TABLE
1892 , p4_a2 JTF_DATE_TABLE
1893 , p4_a3 JTF_NUMBER_TABLE
1894 , p4_a4 JTF_NUMBER_TABLE
1895 , p4_a5 JTF_NUMBER_TABLE
1896 , p4_a6 JTF_VARCHAR2_TABLE_100
1897 , p4_a7 JTF_NUMBER_TABLE
1898 , p4_a8 JTF_VARCHAR2_TABLE_100
1899 , p4_a9 JTF_VARCHAR2_TABLE_100
1900 , p4_a10 JTF_NUMBER_TABLE
1901 , p4_a11 JTF_NUMBER_TABLE
1902 , p4_a12 JTF_NUMBER_TABLE
1903 , p4_a13 JTF_VARCHAR2_TABLE_1000
1904 , p4_a14 JTF_NUMBER_TABLE
1905 , p4_a15 JTF_NUMBER_TABLE
1906 , p4_a16 JTF_NUMBER_TABLE
1907 , p4_a17 JTF_NUMBER_TABLE
1908 , p4_a18 JTF_NUMBER_TABLE
1909 , p4_a19 JTF_NUMBER_TABLE
1910 , p4_a20 JTF_VARCHAR2_TABLE_100
1911 , p4_a21 JTF_NUMBER_TABLE
1912 , p4_a22 JTF_DATE_TABLE
1913 , p4_a23 JTF_NUMBER_TABLE
1914 , p4_a24 JTF_VARCHAR2_TABLE_100
1915 , p4_a25 JTF_VARCHAR2_TABLE_100
1916 , p4_a26 JTF_VARCHAR2_TABLE_100
1917 , p4_a27 JTF_NUMBER_TABLE
1918 , p4_a28 JTF_VARCHAR2_TABLE_100
1919 , p4_a29 JTF_VARCHAR2_TABLE_100
1920 , p4_a30 JTF_VARCHAR2_TABLE_100
1921 , p4_a31 JTF_NUMBER_TABLE
1922 , p4_a32 JTF_NUMBER_TABLE
1923 , p4_a33 JTF_NUMBER_TABLE
1924 , p4_a34 JTF_VARCHAR2_TABLE_100
1925 , p4_a35 JTF_VARCHAR2_TABLE_100
1926 , p4_a36 JTF_VARCHAR2_TABLE_100
1927 , p4_a37 JTF_DATE_TABLE
1928 , p4_a38 JTF_VARCHAR2_TABLE_100
1929 , p4_a39 JTF_DATE_TABLE
1930 , p4_a40 JTF_VARCHAR2_TABLE_100
1931 , p4_a41 JTF_VARCHAR2_TABLE_100
1932 , p4_a42 JTF_VARCHAR2_TABLE_100
1933 , p4_a43 JTF_NUMBER_TABLE
1934 , p4_a44 JTF_NUMBER_TABLE
1935 , p4_a45 JTF_NUMBER_TABLE
1936 , p4_a46 JTF_NUMBER_TABLE
1937 , p4_a47 JTF_NUMBER_TABLE
1938 , p4_a48 JTF_NUMBER_TABLE
1939 , p4_a49 JTF_VARCHAR2_TABLE_100
1940 , p4_a50 JTF_NUMBER_TABLE
1941 , p4_a51 JTF_NUMBER_TABLE
1942 , p4_a52 JTF_NUMBER_TABLE
1943 , p4_a53 JTF_VARCHAR2_TABLE_2000
1944 , p4_a54 JTF_VARCHAR2_TABLE_100
1945 , p4_a55 JTF_VARCHAR2_TABLE_100
1946 , p4_a56 JTF_NUMBER_TABLE
1947 , p4_a57 JTF_DATE_TABLE
1948 , p4_a58 JTF_NUMBER_TABLE
1949 , p4_a59 JTF_DATE_TABLE
1950 , p4_a60 JTF_VARCHAR2_TABLE_100
1951 , p4_a61 JTF_NUMBER_TABLE
1952 , p4_a62 JTF_NUMBER_TABLE
1953 , p4_a63 JTF_NUMBER_TABLE
1954 , p4_a64 JTF_VARCHAR2_TABLE_100
1955 , p4_a65 JTF_NUMBER_TABLE
1956 , p4_a66 JTF_NUMBER_TABLE
1957 , p4_a67 JTF_NUMBER_TABLE
1958 , p4_a68 JTF_NUMBER_TABLE
1959 , p4_a69 JTF_NUMBER_TABLE
1960 , p4_a70 JTF_VARCHAR2_TABLE_100
1961 , p4_a71 JTF_VARCHAR2_TABLE_100
1962 , p4_a72 JTF_NUMBER_TABLE
1963 , p4_a73 JTF_NUMBER_TABLE
1964 , p4_a74 JTF_NUMBER_TABLE
1965 , p4_a75 JTF_VARCHAR2_TABLE_100
1966 , p4_a76 JTF_VARCHAR2_TABLE_100
1967 , p4_a77 JTF_NUMBER_TABLE
1968 , p4_a78 JTF_VARCHAR2_TABLE_100
1969 , p4_a79 JTF_VARCHAR2_TABLE_100
1970 , p4_a80 JTF_VARCHAR2_TABLE_100
1971 , p4_a81 JTF_VARCHAR2_TABLE_100
1972 , p4_a82 JTF_NUMBER_TABLE
1973 , p4_a83 JTF_NUMBER_TABLE
1974 , p4_a84 JTF_VARCHAR2_TABLE_100
1975 , p4_a85 JTF_NUMBER_TABLE
1976 , p4_a86 JTF_VARCHAR2_TABLE_300
1977 , p4_a87 JTF_DATE_TABLE
1978 , p4_a88 JTF_NUMBER_TABLE
1979 , p4_a89 JTF_VARCHAR2_TABLE_100
1980 , p4_a90 JTF_NUMBER_TABLE
1981 , p4_a91 JTF_NUMBER_TABLE
1982 , p4_a92 JTF_DATE_TABLE
1983 , p4_a93 JTF_NUMBER_TABLE
1984 , p4_a94 JTF_DATE_TABLE
1985 , p4_a95 JTF_VARCHAR2_TABLE_100
1986 , p4_a96 JTF_NUMBER_TABLE
1987 , p4_a97 JTF_NUMBER_TABLE
1988 , p4_a98 JTF_NUMBER_TABLE
1989 , p4_a99 JTF_VARCHAR2_TABLE_100
1990 , p4_a100 JTF_DATE_TABLE
1991 , p4_a101 JTF_NUMBER_TABLE
1992 , p4_a102 JTF_NUMBER_TABLE
1993 , p4_a103 JTF_VARCHAR2_TABLE_100
1994 , p4_a104 JTF_VARCHAR2_TABLE_100
1995 , p4_a105 JTF_NUMBER_TABLE
1996 , p4_a106 JTF_DATE_TABLE
1997 , p4_a107 JTF_DATE_TABLE
1998 , p4_a108 JTF_VARCHAR2_TABLE_100
1999 , p4_a109 JTF_VARCHAR2_TABLE_100
2000 , p4_a110 JTF_NUMBER_TABLE
2001 , p4_a111 JTF_VARCHAR2_TABLE_100
2002 , p4_a112 JTF_NUMBER_TABLE
2003 , p4_a113 JTF_NUMBER_TABLE
2004 , p4_a114 JTF_VARCHAR2_TABLE_100
2005 , p4_a115 JTF_VARCHAR2_TABLE_100
2006 , p4_a116 JTF_NUMBER_TABLE
2007 , p4_a117 JTF_NUMBER_TABLE
2008 , p4_a118 JTF_VARCHAR2_TABLE_100
2009 , p4_a119 JTF_VARCHAR2_TABLE_100
2010 , p4_a120 JTF_NUMBER_TABLE
2011 , p4_a121 JTF_VARCHAR2_TABLE_100
2012 , p4_a122 JTF_NUMBER_TABLE
2013 , p4_a123 JTF_NUMBER_TABLE
2014 , p4_a124 JTF_NUMBER_TABLE
2015 , p4_a125 JTF_NUMBER_TABLE
2016 , p4_a126 JTF_NUMBER_TABLE
2017 , p4_a127 JTF_NUMBER_TABLE
2018 , p4_a128 JTF_NUMBER_TABLE
2019 , p4_a129 JTF_NUMBER_TABLE
2020 , p4_a130 JTF_VARCHAR2_TABLE_2000
2021 , p4_a131 JTF_NUMBER_TABLE
2022 , p4_a132 JTF_NUMBER_TABLE
2023 , p4_a133 JTF_NUMBER_TABLE
2024 , p4_a134 JTF_VARCHAR2_TABLE_100
2025 , p4_a135 JTF_NUMBER_TABLE
2026 , p4_a136 JTF_NUMBER_TABLE
2027 , p4_a137 JTF_VARCHAR2_TABLE_100
2028 , p4_a138 JTF_DATE_TABLE
2029 , p4_a139 JTF_VARCHAR2_TABLE_100
2030 , p4_a140 JTF_VARCHAR2_TABLE_100
2031 , p4_a141 JTF_VARCHAR2_TABLE_100
2032 , p4_a142 JTF_VARCHAR2_TABLE_100
2033 , p4_a143 JTF_NUMBER_TABLE
2034 , p4_a144 JTF_NUMBER_TABLE
2035 , p4_a145 JTF_VARCHAR2_TABLE_100
2036 , p4_a146 JTF_NUMBER_TABLE
2037 , p4_a147 JTF_NUMBER_TABLE
2038 , p4_a148 JTF_NUMBER_TABLE
2039 , p4_a149 JTF_NUMBER_TABLE
2040 , p4_a150 JTF_NUMBER_TABLE
2041 , p4_a151 JTF_NUMBER_TABLE
2042 , p4_a152 JTF_NUMBER_TABLE
2043 , p4_a153 JTF_VARCHAR2_TABLE_100
2044 , p4_a154 JTF_VARCHAR2_TABLE_100
2045 , p4_a155 JTF_VARCHAR2_TABLE_100
2046 , p4_a156 JTF_VARCHAR2_TABLE_100
2047 , p4_a157 JTF_VARCHAR2_TABLE_100
2048 , p4_a158 JTF_DATE_TABLE
2049 , p4_a159 JTF_VARCHAR2_TABLE_100
2050 , p4_a160 JTF_DATE_TABLE
2051 , p4_a161 JTF_VARCHAR2_TABLE_100
2052 , p4_a162 JTF_VARCHAR2_TABLE_2000
2053 , p4_a163 JTF_VARCHAR2_TABLE_100
2054 , p4_a164 JTF_VARCHAR2_TABLE_100
2055 , p4_a165 JTF_VARCHAR2_TABLE_100
2056 , p4_a166 JTF_NUMBER_TABLE
2057 , p4_a167 JTF_VARCHAR2_TABLE_100
2058 , p4_a168 JTF_VARCHAR2_TABLE_100
2059 , p4_a169 JTF_VARCHAR2_TABLE_100
2060 , p4_a170 JTF_VARCHAR2_TABLE_100
2061 , p4_a171 JTF_VARCHAR2_TABLE_100
2062 , p4_a172 JTF_VARCHAR2_TABLE_100
2063 , p4_a173 JTF_VARCHAR2_TABLE_100
2064 , p4_a174 JTF_NUMBER_TABLE
2065 , p4_a175 JTF_NUMBER_TABLE
2066 , p4_a176 JTF_NUMBER_TABLE
2067 , p4_a177 JTF_VARCHAR2_TABLE_100
2068 , p4_a178 JTF_VARCHAR2_TABLE_2000
2069 , p4_a179 JTF_VARCHAR2_TABLE_2000
2070 , p4_a180 JTF_VARCHAR2_TABLE_100
2071 , p4_a181 JTF_NUMBER_TABLE
2072 , p4_a182 JTF_VARCHAR2_TABLE_100
2073 , p4_a183 JTF_VARCHAR2_TABLE_2000
2074 , p4_a184 JTF_NUMBER_TABLE
2075 , p4_a185 JTF_VARCHAR2_TABLE_100
2076 , p4_a186 JTF_DATE_TABLE
2077 , p4_a187 JTF_DATE_TABLE
2078 , p4_a188 JTF_VARCHAR2_TABLE_100
2079 , p4_a189 JTF_NUMBER_TABLE
2080 , p4_a190 JTF_NUMBER_TABLE
2081 , p4_a191 JTF_NUMBER_TABLE
2082 , p4_a192 JTF_NUMBER_TABLE
2083 , p4_a193 JTF_VARCHAR2_TABLE_100
2084 , p4_a194 JTF_NUMBER_TABLE
2085 , p4_a195 JTF_NUMBER_TABLE
2086 , p4_a196 JTF_NUMBER_TABLE
2087 , p4_a197 JTF_NUMBER_TABLE
2088 , p4_a198 JTF_VARCHAR2_TABLE_100
2089 , p4_a199 JTF_VARCHAR2_TABLE_100
2090 , p4_a200 JTF_VARCHAR2_TABLE_100
2091 , p4_a201 JTF_NUMBER_TABLE
2092 , p4_a202 JTF_NUMBER_TABLE
2093 , p4_a203 JTF_NUMBER_TABLE
2094 , p4_a204 JTF_NUMBER_TABLE
2095 , p4_a205 JTF_VARCHAR2_TABLE_300
2096 , p4_a206 JTF_VARCHAR2_TABLE_100
2097 , p4_a207 JTF_VARCHAR2_TABLE_100
2098 , p4_a208 JTF_VARCHAR2_TABLE_100
2099 , p4_a209 JTF_VARCHAR2_TABLE_100
2100 , p4_a210 JTF_VARCHAR2_TABLE_100
2101 , p4_a211 JTF_VARCHAR2_TABLE_100
2102 , p4_a212 JTF_NUMBER_TABLE
2103 , p4_a213 JTF_NUMBER_TABLE
2104 , p4_a214 JTF_DATE_TABLE
2105 , p4_a215 JTF_NUMBER_TABLE
2106 , p4_a216 JTF_VARCHAR2_TABLE_100
2107 , p4_a217 JTF_NUMBER_TABLE
2108 , p4_a218 JTF_VARCHAR2_TABLE_100
2109 , p4_a219 JTF_VARCHAR2_TABLE_100
2110 , p4_a220 JTF_VARCHAR2_TABLE_100
2111 , p4_a221 JTF_VARCHAR2_TABLE_100
2112 , p4_a222 JTF_VARCHAR2_TABLE_100
2113 , p4_a223 JTF_VARCHAR2_TABLE_100
2114 , p4_a224 JTF_NUMBER_TABLE
2115 , p4_a225 JTF_NUMBER_TABLE
2116 , p4_a226 JTF_NUMBER_TABLE
2117 , p4_a227 JTF_NUMBER_TABLE
2118 , p4_a228 JTF_VARCHAR2_TABLE_100
2119 , p4_a229 JTF_NUMBER_TABLE
2120 , p4_a230 JTF_VARCHAR2_TABLE_100
2121 , p4_a231 JTF_NUMBER_TABLE
2122 , p4_a232 JTF_VARCHAR2_TABLE_2000
2123 , p4_a233 JTF_VARCHAR2_TABLE_100
2124 , p4_a234 JTF_NUMBER_TABLE
2125 , p4_a235 JTF_VARCHAR2_TABLE_100
2126 , p4_a236 JTF_NUMBER_TABLE
2127 , p4_a237 JTF_NUMBER_TABLE
2128 , p4_a238 JTF_NUMBER_TABLE
2129 , p4_a239 JTF_NUMBER_TABLE
2130 , p4_a240 JTF_NUMBER_TABLE
2131 , p4_a241 JTF_VARCHAR2_TABLE_1000
2132 , p4_a242 JTF_VARCHAR2_TABLE_100
2133 , p4_a243 JTF_NUMBER_TABLE
2134 , p4_a244 JTF_NUMBER_TABLE
2135 , p4_a245 JTF_NUMBER_TABLE
2136 , p4_a246 JTF_NUMBER_TABLE
2137 , p4_a247 JTF_VARCHAR2_TABLE_100
2138 , p4_a248 JTF_VARCHAR2_TABLE_100
2139 , p4_a249 JTF_DATE_TABLE
2140 , p4_a250 JTF_VARCHAR2_TABLE_100
2141 , p4_a251 JTF_NUMBER_TABLE
2142 , p4_a252 JTF_NUMBER_TABLE
2143 , p4_a253 JTF_VARCHAR2_TABLE_100
2144 , p4_a254 JTF_VARCHAR2_TABLE_100
2145 , p4_a255 JTF_VARCHAR2_TABLE_100
2146 , p4_a256 JTF_NUMBER_TABLE
2147 , p4_a257 JTF_NUMBER_TABLE
2148 , p4_a258 JTF_NUMBER_TABLE
2149 , p4_a259 JTF_VARCHAR2_TABLE_300
2150 , p4_a260 JTF_DATE_TABLE
2151 , p4_a261 JTF_VARCHAR2_TABLE_300
2152 , p4_a262 JTF_DATE_TABLE
2153 , p4_a263 JTF_NUMBER_TABLE
2154 , p4_a264 JTF_NUMBER_TABLE
2155 , p4_a265 JTF_NUMBER_TABLE
2156 , p4_a266 JTF_NUMBER_TABLE
2157 , p4_a267 JTF_NUMBER_TABLE
2158 , p4_a268 JTF_NUMBER_TABLE
2159 , p4_a269 JTF_NUMBER_TABLE
2160 , p4_a270 JTF_NUMBER_TABLE
2161 , p4_a271 JTF_NUMBER_TABLE
2162 , p4_a272 JTF_NUMBER_TABLE
2163 , p4_a273 JTF_NUMBER_TABLE
2164 , p4_a274 JTF_NUMBER_TABLE
2165 , p4_a275 JTF_NUMBER_TABLE
2166 , p4_a276 JTF_NUMBER_TABLE
2167 , p4_a277 JTF_NUMBER_TABLE
2168 , p4_a278 JTF_NUMBER_TABLE
2169 , p4_a279 JTF_NUMBER_TABLE
2170 , p4_a280 JTF_NUMBER_TABLE
2171 , p5_a0 JTF_NUMBER_TABLE
2172 , p5_a1 JTF_DATE_TABLE
2173 , p5_a2 JTF_DATE_TABLE
2174 , p5_a3 JTF_NUMBER_TABLE
2175 , p5_a4 JTF_NUMBER_TABLE
2176 , p5_a5 JTF_NUMBER_TABLE
2177 , p5_a6 JTF_VARCHAR2_TABLE_100
2178 , p5_a7 JTF_NUMBER_TABLE
2179 , p5_a8 JTF_VARCHAR2_TABLE_100
2180 , p5_a9 JTF_VARCHAR2_TABLE_100
2181 , p5_a10 JTF_NUMBER_TABLE
2182 , p5_a11 JTF_NUMBER_TABLE
2183 , p5_a12 JTF_NUMBER_TABLE
2184 , p5_a13 JTF_VARCHAR2_TABLE_1000
2185 , p5_a14 JTF_NUMBER_TABLE
2186 , p5_a15 JTF_NUMBER_TABLE
2187 , p5_a16 JTF_NUMBER_TABLE
2188 , p5_a17 JTF_NUMBER_TABLE
2189 , p5_a18 JTF_NUMBER_TABLE
2190 , p5_a19 JTF_NUMBER_TABLE
2191 , p5_a20 JTF_VARCHAR2_TABLE_100
2192 , p5_a21 JTF_NUMBER_TABLE
2193 , p5_a22 JTF_DATE_TABLE
2194 , p5_a23 JTF_NUMBER_TABLE
2195 , p5_a24 JTF_VARCHAR2_TABLE_100
2196 , p5_a25 JTF_VARCHAR2_TABLE_100
2197 , p5_a26 JTF_VARCHAR2_TABLE_100
2198 , p5_a27 JTF_NUMBER_TABLE
2199 , p5_a28 JTF_VARCHAR2_TABLE_100
2200 , p5_a29 JTF_VARCHAR2_TABLE_100
2201 , p5_a30 JTF_VARCHAR2_TABLE_100
2202 , p5_a31 JTF_NUMBER_TABLE
2203 , p5_a32 JTF_NUMBER_TABLE
2204 , p5_a33 JTF_NUMBER_TABLE
2205 , p5_a34 JTF_VARCHAR2_TABLE_100
2206 , p5_a35 JTF_VARCHAR2_TABLE_100
2207 , p5_a36 JTF_VARCHAR2_TABLE_100
2208 , p5_a37 JTF_DATE_TABLE
2209 , p5_a38 JTF_VARCHAR2_TABLE_100
2210 , p5_a39 JTF_DATE_TABLE
2211 , p5_a40 JTF_VARCHAR2_TABLE_100
2212 , p5_a41 JTF_VARCHAR2_TABLE_100
2213 , p5_a42 JTF_VARCHAR2_TABLE_100
2214 , p5_a43 JTF_NUMBER_TABLE
2215 , p5_a44 JTF_NUMBER_TABLE
2216 , p5_a45 JTF_NUMBER_TABLE
2217 , p5_a46 JTF_NUMBER_TABLE
2218 , p5_a47 JTF_NUMBER_TABLE
2219 , p5_a48 JTF_NUMBER_TABLE
2220 , p5_a49 JTF_VARCHAR2_TABLE_100
2221 , p5_a50 JTF_NUMBER_TABLE
2222 , p5_a51 JTF_NUMBER_TABLE
2223 , p5_a52 JTF_NUMBER_TABLE
2224 , p5_a53 JTF_VARCHAR2_TABLE_2000
2225 , p5_a54 JTF_VARCHAR2_TABLE_100
2226 , p5_a55 JTF_VARCHAR2_TABLE_100
2227 , p5_a56 JTF_NUMBER_TABLE
2228 , p5_a57 JTF_DATE_TABLE
2229 , p5_a58 JTF_NUMBER_TABLE
2230 , p5_a59 JTF_DATE_TABLE
2231 , p5_a60 JTF_VARCHAR2_TABLE_100
2232 , p5_a61 JTF_NUMBER_TABLE
2233 , p5_a62 JTF_NUMBER_TABLE
2234 , p5_a63 JTF_NUMBER_TABLE
2235 , p5_a64 JTF_VARCHAR2_TABLE_100
2236 , p5_a65 JTF_NUMBER_TABLE
2237 , p5_a66 JTF_NUMBER_TABLE
2238 , p5_a67 JTF_NUMBER_TABLE
2239 , p5_a68 JTF_NUMBER_TABLE
2240 , p5_a69 JTF_NUMBER_TABLE
2241 , p5_a70 JTF_VARCHAR2_TABLE_100
2242 , p5_a71 JTF_VARCHAR2_TABLE_100
2243 , p5_a72 JTF_NUMBER_TABLE
2244 , p5_a73 JTF_NUMBER_TABLE
2245 , p5_a74 JTF_NUMBER_TABLE
2246 , p5_a75 JTF_VARCHAR2_TABLE_100
2247 , p5_a76 JTF_VARCHAR2_TABLE_100
2248 , p5_a77 JTF_NUMBER_TABLE
2249 , p5_a78 JTF_VARCHAR2_TABLE_100
2250 , p5_a79 JTF_VARCHAR2_TABLE_100
2251 , p5_a80 JTF_VARCHAR2_TABLE_100
2252 , p5_a81 JTF_VARCHAR2_TABLE_100
2253 , p5_a82 JTF_NUMBER_TABLE
2254 , p5_a83 JTF_NUMBER_TABLE
2255 , p5_a84 JTF_VARCHAR2_TABLE_100
2256 , p5_a85 JTF_NUMBER_TABLE
2257 , p5_a86 JTF_VARCHAR2_TABLE_300
2258 , p5_a87 JTF_DATE_TABLE
2259 , p5_a88 JTF_NUMBER_TABLE
2260 , p5_a89 JTF_VARCHAR2_TABLE_100
2261 , p5_a90 JTF_NUMBER_TABLE
2262 , p5_a91 JTF_NUMBER_TABLE
2263 , p5_a92 JTF_DATE_TABLE
2264 , p5_a93 JTF_NUMBER_TABLE
2265 , p5_a94 JTF_DATE_TABLE
2266 , p5_a95 JTF_VARCHAR2_TABLE_100
2267 , p5_a96 JTF_NUMBER_TABLE
2268 , p5_a97 JTF_NUMBER_TABLE
2269 , p5_a98 JTF_NUMBER_TABLE
2270 , p5_a99 JTF_VARCHAR2_TABLE_100
2271 , p5_a100 JTF_DATE_TABLE
2272 , p5_a101 JTF_NUMBER_TABLE
2273 , p5_a102 JTF_NUMBER_TABLE
2274 , p5_a103 JTF_VARCHAR2_TABLE_100
2275 , p5_a104 JTF_VARCHAR2_TABLE_100
2276 , p5_a105 JTF_NUMBER_TABLE
2277 , p5_a106 JTF_DATE_TABLE
2278 , p5_a107 JTF_DATE_TABLE
2279 , p5_a108 JTF_VARCHAR2_TABLE_100
2280 , p5_a109 JTF_VARCHAR2_TABLE_100
2281 , p5_a110 JTF_NUMBER_TABLE
2282 , p5_a111 JTF_VARCHAR2_TABLE_100
2283 , p5_a112 JTF_NUMBER_TABLE
2284 , p5_a113 JTF_NUMBER_TABLE
2285 , p5_a114 JTF_VARCHAR2_TABLE_100
2286 , p5_a115 JTF_VARCHAR2_TABLE_100
2287 , p5_a116 JTF_NUMBER_TABLE
2288 , p5_a117 JTF_NUMBER_TABLE
2289 , p5_a118 JTF_VARCHAR2_TABLE_100
2290 , p5_a119 JTF_VARCHAR2_TABLE_100
2291 , p5_a120 JTF_NUMBER_TABLE
2292 , p5_a121 JTF_VARCHAR2_TABLE_100
2293 , p5_a122 JTF_NUMBER_TABLE
2294 , p5_a123 JTF_NUMBER_TABLE
2295 , p5_a124 JTF_NUMBER_TABLE
2296 , p5_a125 JTF_NUMBER_TABLE
2297 , p5_a126 JTF_NUMBER_TABLE
2298 , p5_a127 JTF_NUMBER_TABLE
2299 , p5_a128 JTF_NUMBER_TABLE
2300 , p5_a129 JTF_NUMBER_TABLE
2301 , p5_a130 JTF_VARCHAR2_TABLE_2000
2302 , p5_a131 JTF_NUMBER_TABLE
2303 , p5_a132 JTF_NUMBER_TABLE
2304 , p5_a133 JTF_NUMBER_TABLE
2305 , p5_a134 JTF_VARCHAR2_TABLE_100
2306 , p5_a135 JTF_NUMBER_TABLE
2307 , p5_a136 JTF_NUMBER_TABLE
2308 , p5_a137 JTF_VARCHAR2_TABLE_100
2309 , p5_a138 JTF_DATE_TABLE
2310 , p5_a139 JTF_VARCHAR2_TABLE_100
2311 , p5_a140 JTF_VARCHAR2_TABLE_100
2312 , p5_a141 JTF_VARCHAR2_TABLE_100
2313 , p5_a142 JTF_VARCHAR2_TABLE_100
2314 , p5_a143 JTF_NUMBER_TABLE
2315 , p5_a144 JTF_NUMBER_TABLE
2316 , p5_a145 JTF_VARCHAR2_TABLE_100
2317 , p5_a146 JTF_NUMBER_TABLE
2318 , p5_a147 JTF_NUMBER_TABLE
2319 , p5_a148 JTF_NUMBER_TABLE
2320 , p5_a149 JTF_NUMBER_TABLE
2321 , p5_a150 JTF_NUMBER_TABLE
2322 , p5_a151 JTF_NUMBER_TABLE
2323 , p5_a152 JTF_NUMBER_TABLE
2324 , p5_a153 JTF_VARCHAR2_TABLE_100
2325 , p5_a154 JTF_VARCHAR2_TABLE_100
2326 , p5_a155 JTF_VARCHAR2_TABLE_100
2327 , p5_a156 JTF_VARCHAR2_TABLE_100
2328 , p5_a157 JTF_VARCHAR2_TABLE_100
2329 , p5_a158 JTF_DATE_TABLE
2330 , p5_a159 JTF_VARCHAR2_TABLE_100
2331 , p5_a160 JTF_DATE_TABLE
2332 , p5_a161 JTF_VARCHAR2_TABLE_100
2333 , p5_a162 JTF_VARCHAR2_TABLE_2000
2334 , p5_a163 JTF_VARCHAR2_TABLE_100
2335 , p5_a164 JTF_VARCHAR2_TABLE_100
2336 , p5_a165 JTF_VARCHAR2_TABLE_100
2337 , p5_a166 JTF_NUMBER_TABLE
2338 , p5_a167 JTF_VARCHAR2_TABLE_100
2339 , p5_a168 JTF_VARCHAR2_TABLE_100
2340 , p5_a169 JTF_VARCHAR2_TABLE_100
2341 , p5_a170 JTF_VARCHAR2_TABLE_100
2342 , p5_a171 JTF_VARCHAR2_TABLE_100
2343 , p5_a172 JTF_VARCHAR2_TABLE_100
2344 , p5_a173 JTF_VARCHAR2_TABLE_100
2345 , p5_a174 JTF_NUMBER_TABLE
2346 , p5_a175 JTF_NUMBER_TABLE
2347 , p5_a176 JTF_NUMBER_TABLE
2348 , p5_a177 JTF_VARCHAR2_TABLE_100
2349 , p5_a178 JTF_VARCHAR2_TABLE_2000
2350 , p5_a179 JTF_VARCHAR2_TABLE_2000
2351 , p5_a180 JTF_VARCHAR2_TABLE_100
2352 , p5_a181 JTF_NUMBER_TABLE
2353 , p5_a182 JTF_VARCHAR2_TABLE_100
2354 , p5_a183 JTF_VARCHAR2_TABLE_2000
2355 , p5_a184 JTF_NUMBER_TABLE
2356 , p5_a185 JTF_VARCHAR2_TABLE_100
2357 , p5_a186 JTF_DATE_TABLE
2358 , p5_a187 JTF_DATE_TABLE
2359 , p5_a188 JTF_VARCHAR2_TABLE_100
2360 , p5_a189 JTF_NUMBER_TABLE
2361 , p5_a190 JTF_NUMBER_TABLE
2362 , p5_a191 JTF_NUMBER_TABLE
2363 , p5_a192 JTF_NUMBER_TABLE
2364 , p5_a193 JTF_VARCHAR2_TABLE_100
2365 , p5_a194 JTF_NUMBER_TABLE
2366 , p5_a195 JTF_NUMBER_TABLE
2367 , p5_a196 JTF_NUMBER_TABLE
2368 , p5_a197 JTF_NUMBER_TABLE
2369 , p5_a198 JTF_VARCHAR2_TABLE_100
2370 , p5_a199 JTF_VARCHAR2_TABLE_100
2371 , p5_a200 JTF_VARCHAR2_TABLE_100
2372 , p5_a201 JTF_NUMBER_TABLE
2373 , p5_a202 JTF_NUMBER_TABLE
2374 , p5_a203 JTF_NUMBER_TABLE
2375 , p5_a204 JTF_NUMBER_TABLE
2376 , p5_a205 JTF_VARCHAR2_TABLE_300
2377 , p5_a206 JTF_VARCHAR2_TABLE_100
2378 , p5_a207 JTF_VARCHAR2_TABLE_100
2379 , p5_a208 JTF_VARCHAR2_TABLE_100
2380 , p5_a209 JTF_VARCHAR2_TABLE_100
2381 , p5_a210 JTF_VARCHAR2_TABLE_100
2382 , p5_a211 JTF_VARCHAR2_TABLE_100
2383 , p5_a212 JTF_NUMBER_TABLE
2384 , p5_a213 JTF_NUMBER_TABLE
2385 , p5_a214 JTF_DATE_TABLE
2386 , p5_a215 JTF_NUMBER_TABLE
2387 , p5_a216 JTF_VARCHAR2_TABLE_100
2388 , p5_a217 JTF_NUMBER_TABLE
2389 , p5_a218 JTF_VARCHAR2_TABLE_100
2390 , p5_a219 JTF_VARCHAR2_TABLE_100
2391 , p5_a220 JTF_VARCHAR2_TABLE_100
2392 , p5_a221 JTF_VARCHAR2_TABLE_100
2393 , p5_a222 JTF_VARCHAR2_TABLE_100
2394 , p5_a223 JTF_VARCHAR2_TABLE_100
2395 , p5_a224 JTF_NUMBER_TABLE
2396 , p5_a225 JTF_NUMBER_TABLE
2397 , p5_a226 JTF_NUMBER_TABLE
2398 , p5_a227 JTF_NUMBER_TABLE
2399 , p5_a228 JTF_VARCHAR2_TABLE_100
2400 , p5_a229 JTF_NUMBER_TABLE
2401 , p5_a230 JTF_VARCHAR2_TABLE_100
2402 , p5_a231 JTF_NUMBER_TABLE
2403 , p5_a232 JTF_VARCHAR2_TABLE_2000
2404 , p5_a233 JTF_VARCHAR2_TABLE_100
2405 , p5_a234 JTF_NUMBER_TABLE
2406 , p5_a235 JTF_VARCHAR2_TABLE_100
2407 , p5_a236 JTF_NUMBER_TABLE
2408 , p5_a237 JTF_NUMBER_TABLE
2409 , p5_a238 JTF_NUMBER_TABLE
2410 , p5_a239 JTF_NUMBER_TABLE
2411 , p5_a240 JTF_NUMBER_TABLE
2412 , p5_a241 JTF_VARCHAR2_TABLE_1000
2413 , p5_a242 JTF_VARCHAR2_TABLE_100
2414 , p5_a243 JTF_NUMBER_TABLE
2415 , p5_a244 JTF_NUMBER_TABLE
2416 , p5_a245 JTF_NUMBER_TABLE
2417 , p5_a246 JTF_NUMBER_TABLE
2418 , p5_a247 JTF_VARCHAR2_TABLE_100
2419 , p5_a248 JTF_VARCHAR2_TABLE_100
2420 , p5_a249 JTF_DATE_TABLE
2421 , p5_a250 JTF_VARCHAR2_TABLE_100
2422 , p5_a251 JTF_NUMBER_TABLE
2423 , p5_a252 JTF_NUMBER_TABLE
2424 , p5_a253 JTF_VARCHAR2_TABLE_100
2425 , p5_a254 JTF_VARCHAR2_TABLE_100
2426 , p5_a255 JTF_VARCHAR2_TABLE_100
2427 , p5_a256 JTF_NUMBER_TABLE
2428 , p5_a257 JTF_NUMBER_TABLE
2429 , p5_a258 JTF_NUMBER_TABLE
2430 , p5_a259 JTF_VARCHAR2_TABLE_300
2431 , p5_a260 JTF_DATE_TABLE
2432 , p5_a261 JTF_VARCHAR2_TABLE_300
2433 , p5_a262 JTF_DATE_TABLE
2434 , p5_a263 JTF_NUMBER_TABLE
2435 , p5_a264 JTF_NUMBER_TABLE
2436 , p5_a265 JTF_NUMBER_TABLE
2437 , p5_a266 JTF_NUMBER_TABLE
2438 , p5_a267 JTF_NUMBER_TABLE
2439 , p5_a268 JTF_NUMBER_TABLE
2440 , p5_a269 JTF_NUMBER_TABLE
2441 , p5_a270 JTF_NUMBER_TABLE
2442 , p5_a271 JTF_NUMBER_TABLE
2443 , p5_a272 JTF_NUMBER_TABLE
2444 , p5_a273 JTF_NUMBER_TABLE
2445 , p5_a274 JTF_NUMBER_TABLE
2446 , p5_a275 JTF_NUMBER_TABLE
2447 , p5_a276 JTF_NUMBER_TABLE
2448 , p5_a277 JTF_NUMBER_TABLE
2449 , p5_a278 JTF_NUMBER_TABLE
2450 , p5_a279 JTF_NUMBER_TABLE
2451 , p5_a280 JTF_NUMBER_TABLE
2452 )
2453
2454 as
2455 ddx_cascade_flag boolean;
2456 ddp_line_tbl oe_order_pub.line_tbl_type;
2457 ddp_old_line_tbl oe_order_pub.line_tbl_type;
2458 ddindx binary_integer; indx binary_integer;
2459 begin
2460
2461 -- copy data to the local IN or IN-OUT args, if any
2462
2463
2464
2465
2466 oe_order_pub_w.rosetta_table_copy_in_p19(ddp_line_tbl, p4_a0
2467 , p4_a1
2468 , p4_a2
2469 , p4_a3
2470 , p4_a4
2471 , p4_a5
2472 , p4_a6
2473 , p4_a7
2474 , p4_a8
2475 , p4_a9
2476 , p4_a10
2477 , p4_a11
2478 , p4_a12
2479 , p4_a13
2480 , p4_a14
2481 , p4_a15
2482 , p4_a16
2483 , p4_a17
2484 , p4_a18
2485 , p4_a19
2486 , p4_a20
2487 , p4_a21
2488 , p4_a22
2489 , p4_a23
2490 , p4_a24
2491 , p4_a25
2492 , p4_a26
2493 , p4_a27
2494 , p4_a28
2495 , p4_a29
2496 , p4_a30
2497 , p4_a31
2498 , p4_a32
2499 , p4_a33
2500 , p4_a34
2501 , p4_a35
2502 , p4_a36
2503 , p4_a37
2504 , p4_a38
2505 , p4_a39
2506 , p4_a40
2507 , p4_a41
2508 , p4_a42
2509 , p4_a43
2510 , p4_a44
2511 , p4_a45
2512 , p4_a46
2513 , p4_a47
2514 , p4_a48
2515 , p4_a49
2516 , p4_a50
2517 , p4_a51
2518 , p4_a52
2519 , p4_a53
2520 , p4_a54
2521 , p4_a55
2522 , p4_a56
2523 , p4_a57
2524 , p4_a58
2525 , p4_a59
2526 , p4_a60
2527 , p4_a61
2528 , p4_a62
2529 , p4_a63
2530 , p4_a64
2531 , p4_a65
2532 , p4_a66
2533 , p4_a67
2534 , p4_a68
2535 , p4_a69
2536 , p4_a70
2537 , p4_a71
2538 , p4_a72
2539 , p4_a73
2540 , p4_a74
2541 , p4_a75
2542 , p4_a76
2543 , p4_a77
2544 , p4_a78
2545 , p4_a79
2546 , p4_a80
2547 , p4_a81
2548 , p4_a82
2549 , p4_a83
2550 , p4_a84
2551 , p4_a85
2552 , p4_a86
2553 , p4_a87
2554 , p4_a88
2555 , p4_a89
2556 , p4_a90
2557 , p4_a91
2558 , p4_a92
2559 , p4_a93
2560 , p4_a94
2561 , p4_a95
2562 , p4_a96
2563 , p4_a97
2564 , p4_a98
2565 , p4_a99
2566 , p4_a100
2567 , p4_a101
2568 , p4_a102
2569 , p4_a103
2570 , p4_a104
2571 , p4_a105
2572 , p4_a106
2573 , p4_a107
2574 , p4_a108
2575 , p4_a109
2576 , p4_a110
2577 , p4_a111
2578 , p4_a112
2579 , p4_a113
2580 , p4_a114
2581 , p4_a115
2582 , p4_a116
2583 , p4_a117
2584 , p4_a118
2585 , p4_a119
2586 , p4_a120
2587 , p4_a121
2588 , p4_a122
2589 , p4_a123
2590 , p4_a124
2591 , p4_a125
2592 , p4_a126
2593 , p4_a127
2594 , p4_a128
2595 , p4_a129
2596 , p4_a130
2597 , p4_a131
2598 , p4_a132
2599 , p4_a133
2600 , p4_a134
2601 , p4_a135
2602 , p4_a136
2603 , p4_a137
2604 , p4_a138
2605 , p4_a139
2606 , p4_a140
2607 , p4_a141
2608 , p4_a142
2609 , p4_a143
2610 , p4_a144
2611 , p4_a145
2612 , p4_a146
2613 , p4_a147
2614 , p4_a148
2615 , p4_a149
2616 , p4_a150
2617 , p4_a151
2618 , p4_a152
2619 , p4_a153
2620 , p4_a154
2621 , p4_a155
2622 , p4_a156
2623 , p4_a157
2624 , p4_a158
2625 , p4_a159
2626 , p4_a160
2627 , p4_a161
2628 , p4_a162
2629 , p4_a163
2630 , p4_a164
2631 , p4_a165
2632 , p4_a166
2633 , p4_a167
2634 , p4_a168
2635 , p4_a169
2636 , p4_a170
2637 , p4_a171
2638 , p4_a172
2639 , p4_a173
2640 , p4_a174
2641 , p4_a175
2642 , p4_a176
2643 , p4_a177
2644 , p4_a178
2645 , p4_a179
2646 , p4_a180
2647 , p4_a181
2648 , p4_a182
2649 , p4_a183
2650 , p4_a184
2651 , p4_a185
2652 , p4_a186
2653 , p4_a187
2654 , p4_a188
2655 , p4_a189
2656 , p4_a190
2657 , p4_a191
2658 , p4_a192
2659 , p4_a193
2660 , p4_a194
2661 , p4_a195
2662 , p4_a196
2663 , p4_a197
2664 , p4_a198
2665 , p4_a199
2666 , p4_a200
2667 , p4_a201
2668 , p4_a202
2669 , p4_a203
2670 , p4_a204
2671 , p4_a205
2672 , p4_a206
2673 , p4_a207
2674 , p4_a208
2675 , p4_a209
2676 , p4_a210
2677 , p4_a211
2678 , p4_a212
2679 , p4_a213
2680 , p4_a214
2681 , p4_a215
2682 , p4_a216
2683 , p4_a217
2684 , p4_a218
2685 , p4_a219
2686 , p4_a220
2687 , p4_a221
2688 , p4_a222
2689 , p4_a223
2690 , p4_a224
2691 , p4_a225
2692 , p4_a226
2693 , p4_a227
2694 , p4_a228
2695 , p4_a229
2696 , p4_a230
2697 , p4_a231
2698 , p4_a232
2699 , p4_a233
2700 , p4_a234
2701 , p4_a235
2702 , p4_a236
2703 , p4_a237
2704 , p4_a238
2705 , p4_a239
2706 , p4_a240
2707 , p4_a241
2708 , p4_a242
2709 , p4_a243
2710 , p4_a244
2711 , p4_a245
2712 , p4_a246
2713 , p4_a247
2714 , p4_a248
2715 , p4_a249
2716 , p4_a250
2717 , p4_a251
2718 , p4_a252
2719 , p4_a253
2720 , p4_a254
2721 , p4_a255
2722 , p4_a256
2723 , p4_a257
2724 , p4_a258
2725 , p4_a259
2726 , p4_a260
2727 , p4_a261
2728 , p4_a262
2729 , p4_a263
2730 , p4_a264
2731 , p4_a265
2732 , p4_a266
2733 , p4_a267
2734 , p4_a268
2735 , p4_a269
2736 , p4_a270
2737 , p4_a271
2738 , p4_a272
2739 , p4_a273
2740 , p4_a274
2741 , p4_a275
2742 , p4_a276
2743 , p4_a277
2744 , p4_a278
2745 , p4_a279
2746 , p4_a280
2747 );
2748
2749 oe_order_pub_w.rosetta_table_copy_in_p19(ddp_old_line_tbl, p5_a0
2750 , p5_a1
2751 , p5_a2
2752 , p5_a3
2753 , p5_a4
2754 , p5_a5
2755 , p5_a6
2756 , p5_a7
2757 , p5_a8
2758 , p5_a9
2759 , p5_a10
2760 , p5_a11
2761 , p5_a12
2762 , p5_a13
2763 , p5_a14
2764 , p5_a15
2765 , p5_a16
2766 , p5_a17
2767 , p5_a18
2768 , p5_a19
2769 , p5_a20
2770 , p5_a21
2771 , p5_a22
2772 , p5_a23
2773 , p5_a24
2774 , p5_a25
2775 , p5_a26
2776 , p5_a27
2777 , p5_a28
2778 , p5_a29
2779 , p5_a30
2780 , p5_a31
2781 , p5_a32
2782 , p5_a33
2783 , p5_a34
2784 , p5_a35
2785 , p5_a36
2786 , p5_a37
2787 , p5_a38
2788 , p5_a39
2789 , p5_a40
2790 , p5_a41
2791 , p5_a42
2792 , p5_a43
2793 , p5_a44
2794 , p5_a45
2795 , p5_a46
2796 , p5_a47
2797 , p5_a48
2798 , p5_a49
2799 , p5_a50
2800 , p5_a51
2801 , p5_a52
2802 , p5_a53
2803 , p5_a54
2804 , p5_a55
2805 , p5_a56
2806 , p5_a57
2807 , p5_a58
2808 , p5_a59
2809 , p5_a60
2810 , p5_a61
2811 , p5_a62
2812 , p5_a63
2813 , p5_a64
2814 , p5_a65
2815 , p5_a66
2816 , p5_a67
2817 , p5_a68
2818 , p5_a69
2819 , p5_a70
2820 , p5_a71
2821 , p5_a72
2822 , p5_a73
2823 , p5_a74
2824 , p5_a75
2825 , p5_a76
2826 , p5_a77
2827 , p5_a78
2828 , p5_a79
2829 , p5_a80
2830 , p5_a81
2831 , p5_a82
2832 , p5_a83
2833 , p5_a84
2834 , p5_a85
2835 , p5_a86
2836 , p5_a87
2837 , p5_a88
2838 , p5_a89
2839 , p5_a90
2840 , p5_a91
2841 , p5_a92
2842 , p5_a93
2843 , p5_a94
2844 , p5_a95
2845 , p5_a96
2846 , p5_a97
2847 , p5_a98
2848 , p5_a99
2849 , p5_a100
2850 , p5_a101
2851 , p5_a102
2852 , p5_a103
2853 , p5_a104
2854 , p5_a105
2855 , p5_a106
2856 , p5_a107
2857 , p5_a108
2858 , p5_a109
2859 , p5_a110
2860 , p5_a111
2861 , p5_a112
2862 , p5_a113
2863 , p5_a114
2864 , p5_a115
2865 , p5_a116
2866 , p5_a117
2867 , p5_a118
2868 , p5_a119
2869 , p5_a120
2870 , p5_a121
2871 , p5_a122
2872 , p5_a123
2873 , p5_a124
2874 , p5_a125
2875 , p5_a126
2876 , p5_a127
2877 , p5_a128
2878 , p5_a129
2879 , p5_a130
2880 , p5_a131
2881 , p5_a132
2882 , p5_a133
2883 , p5_a134
2884 , p5_a135
2885 , p5_a136
2886 , p5_a137
2887 , p5_a138
2888 , p5_a139
2889 , p5_a140
2890 , p5_a141
2891 , p5_a142
2892 , p5_a143
2893 , p5_a144
2894 , p5_a145
2895 , p5_a146
2896 , p5_a147
2897 , p5_a148
2898 , p5_a149
2899 , p5_a150
2900 , p5_a151
2901 , p5_a152
2902 , p5_a153
2903 , p5_a154
2904 , p5_a155
2905 , p5_a156
2906 , p5_a157
2907 , p5_a158
2908 , p5_a159
2909 , p5_a160
2910 , p5_a161
2911 , p5_a162
2912 , p5_a163
2913 , p5_a164
2914 , p5_a165
2915 , p5_a166
2916 , p5_a167
2917 , p5_a168
2918 , p5_a169
2919 , p5_a170
2920 , p5_a171
2921 , p5_a172
2922 , p5_a173
2923 , p5_a174
2924 , p5_a175
2925 , p5_a176
2926 , p5_a177
2927 , p5_a178
2928 , p5_a179
2929 , p5_a180
2930 , p5_a181
2931 , p5_a182
2932 , p5_a183
2933 , p5_a184
2934 , p5_a185
2935 , p5_a186
2936 , p5_a187
2937 , p5_a188
2938 , p5_a189
2939 , p5_a190
2940 , p5_a191
2941 , p5_a192
2942 , p5_a193
2943 , p5_a194
2944 , p5_a195
2945 , p5_a196
2946 , p5_a197
2947 , p5_a198
2948 , p5_a199
2949 , p5_a200
2950 , p5_a201
2951 , p5_a202
2952 , p5_a203
2953 , p5_a204
2954 , p5_a205
2955 , p5_a206
2956 , p5_a207
2957 , p5_a208
2958 , p5_a209
2959 , p5_a210
2960 , p5_a211
2961 , p5_a212
2962 , p5_a213
2963 , p5_a214
2964 , p5_a215
2965 , p5_a216
2966 , p5_a217
2967 , p5_a218
2968 , p5_a219
2969 , p5_a220
2970 , p5_a221
2971 , p5_a222
2972 , p5_a223
2973 , p5_a224
2974 , p5_a225
2975 , p5_a226
2976 , p5_a227
2977 , p5_a228
2978 , p5_a229
2979 , p5_a230
2980 , p5_a231
2981 , p5_a232
2982 , p5_a233
2983 , p5_a234
2984 , p5_a235
2985 , p5_a236
2986 , p5_a237
2987 , p5_a238
2988 , p5_a239
2989 , p5_a240
2990 , p5_a241
2991 , p5_a242
2992 , p5_a243
2993 , p5_a244
2994 , p5_a245
2995 , p5_a246
2996 , p5_a247
2997 , p5_a248
2998 , p5_a249
2999 , p5_a250
3000 , p5_a251
3001 , p5_a252
3002 , p5_a253
3003 , p5_a254
3004 , p5_a255
3005 , p5_a256
3006 , p5_a257
3007 , p5_a258
3008 , p5_a259
3009 , p5_a260
3010 , p5_a261
3011 , p5_a262
3012 , p5_a263
3013 , p5_a264
3014 , p5_a265
3015 , p5_a266
3016 , p5_a267
3017 , p5_a268
3018 , p5_a269
3019 , p5_a270
3020 , p5_a271
3021 , p5_a272
3022 , p5_a273
3023 , p5_a274
3024 , p5_a275
3025 , p5_a276
3026 , p5_a277
3027 , p5_a278
3028 , p5_a279
3029 , p5_a280
3030 );
3031
3032 -- here's the delegated call to the old PL/SQL routine
3033 oe_oe_html_line_ext.save_lines(x_return_status,
3034 x_msg_count,
3035 x_msg_data,
3036 ddx_cascade_flag,
3037 ddp_line_tbl,
3038 ddp_old_line_tbl);
3039
3040 -- copy data back from the local variables to OUT or IN-OUT args, if any
3041
3042
3043
3044 if ddx_cascade_flag is null
3045 then x_cascade_flag := null;
3046 elsif ddx_cascade_flag
3047 then x_cascade_flag := 1;
3048 else x_cascade_flag := 0;
3049 end if;
3050
3051
3052 end;
3053
3054 procedure prepare_lines_dff_for_save(x_return_status out NOCOPY /* file.sql.39 change */ VARCHAR2
3055 , x_msg_count out NOCOPY /* file.sql.39 change */ NUMBER
3056 , x_msg_data out NOCOPY /* file.sql.39 change */ VARCHAR2
3057 , p3_a0 JTF_VARCHAR2_TABLE_300
3058 , p3_a1 JTF_VARCHAR2_TABLE_300
3059 , p3_a2 JTF_VARCHAR2_TABLE_300
3060 , p3_a3 JTF_VARCHAR2_TABLE_300
3061 , p3_a4 JTF_VARCHAR2_TABLE_300
3062 , p3_a5 JTF_VARCHAR2_TABLE_300
3063 , p3_a6 JTF_VARCHAR2_TABLE_300
3064 , p3_a7 JTF_VARCHAR2_TABLE_300
3065 , p3_a8 JTF_VARCHAR2_TABLE_300
3066 , p3_a9 JTF_VARCHAR2_TABLE_300
3067 , p3_a10 JTF_VARCHAR2_TABLE_300
3068 , p3_a11 JTF_VARCHAR2_TABLE_300
3069 , p3_a12 JTF_VARCHAR2_TABLE_300
3070 , p3_a13 JTF_VARCHAR2_TABLE_300
3071 , p3_a14 JTF_VARCHAR2_TABLE_300
3072 , p3_a15 JTF_VARCHAR2_TABLE_300
3073 , p3_a16 JTF_VARCHAR2_TABLE_300
3074 , p3_a17 JTF_VARCHAR2_TABLE_300
3075 , p3_a18 JTF_VARCHAR2_TABLE_300
3076 , p3_a19 JTF_VARCHAR2_TABLE_300
3077 , p3_a20 JTF_VARCHAR2_TABLE_300
3078 , p3_a21 JTF_VARCHAR2_TABLE_300
3079 , p3_a22 JTF_VARCHAR2_TABLE_300
3080 , p3_a23 JTF_VARCHAR2_TABLE_300
3081 , p3_a24 JTF_VARCHAR2_TABLE_300
3082 , p3_a25 JTF_VARCHAR2_TABLE_300
3083 , p3_a26 JTF_VARCHAR2_TABLE_300
3084 , p3_a27 JTF_VARCHAR2_TABLE_300
3085 , p3_a28 JTF_VARCHAR2_TABLE_300
3086 , p3_a29 JTF_VARCHAR2_TABLE_300
3087 , p3_a30 JTF_VARCHAR2_TABLE_300
3088 , p3_a31 JTF_VARCHAR2_TABLE_300
3089 , p3_a32 JTF_VARCHAR2_TABLE_300
3090 , p3_a33 JTF_VARCHAR2_TABLE_300
3091 , p3_a34 JTF_VARCHAR2_TABLE_300
3092 , p3_a35 JTF_VARCHAR2_TABLE_300
3093 , p3_a36 JTF_VARCHAR2_TABLE_300
3094 , p3_a37 JTF_VARCHAR2_TABLE_300
3095 , p3_a38 JTF_VARCHAR2_TABLE_300
3096 , p3_a39 JTF_VARCHAR2_TABLE_300
3097 , p3_a40 JTF_VARCHAR2_TABLE_100
3098 , p3_a41 JTF_NUMBER_TABLE
3099 , p3_a42 JTF_VARCHAR2_TABLE_300
3100 , p3_a43 JTF_VARCHAR2_TABLE_300
3101 , p3_a44 JTF_VARCHAR2_TABLE_300
3102 , p3_a45 JTF_VARCHAR2_TABLE_300
3103 , p3_a46 JTF_VARCHAR2_TABLE_300
3104 , p3_a47 JTF_VARCHAR2_TABLE_300
3105 , p3_a48 JTF_VARCHAR2_TABLE_300
3106 , p3_a49 JTF_VARCHAR2_TABLE_300
3107 , p3_a50 JTF_VARCHAR2_TABLE_300
3108 , p3_a51 JTF_VARCHAR2_TABLE_300
3109 , p3_a52 JTF_VARCHAR2_TABLE_300
3110 , p3_a53 JTF_VARCHAR2_TABLE_300
3111 , p3_a54 JTF_VARCHAR2_TABLE_300
3112 , p3_a55 JTF_VARCHAR2_TABLE_300
3113 , p3_a56 JTF_VARCHAR2_TABLE_300
3114 , p3_a57 JTF_VARCHAR2_TABLE_300
3115 , p3_a58 JTF_VARCHAR2_TABLE_300
3116 , p3_a59 JTF_VARCHAR2_TABLE_300
3117 , p3_a60 JTF_VARCHAR2_TABLE_300
3118 , p3_a61 JTF_VARCHAR2_TABLE_300
3119 , p3_a62 JTF_VARCHAR2_TABLE_300
3120 , p3_a63 JTF_VARCHAR2_TABLE_300
3121 , p3_a64 JTF_VARCHAR2_TABLE_300
3122 , p3_a65 JTF_VARCHAR2_TABLE_300
3123 , p3_a66 JTF_VARCHAR2_TABLE_300
3124 , p3_a67 JTF_VARCHAR2_TABLE_300
3125 , p3_a68 JTF_VARCHAR2_TABLE_300
3126 , p3_a69 JTF_VARCHAR2_TABLE_300
3127 , p3_a70 JTF_VARCHAR2_TABLE_300
3128 , p3_a71 JTF_VARCHAR2_TABLE_300
3129 , p3_a72 JTF_VARCHAR2_TABLE_100
3130 , p3_a73 JTF_VARCHAR2_TABLE_100
3131 , p3_a74 JTF_VARCHAR2_TABLE_300
3132 , p3_a75 JTF_VARCHAR2_TABLE_300
3133 , p3_a76 JTF_VARCHAR2_TABLE_300
3134 , p3_a77 JTF_VARCHAR2_TABLE_300
3135 , p3_a78 JTF_VARCHAR2_TABLE_300
3136 , p3_a79 JTF_VARCHAR2_TABLE_300
3137 , p3_a80 JTF_VARCHAR2_TABLE_300
3138 , p3_a81 JTF_VARCHAR2_TABLE_300
3139 , p3_a82 JTF_VARCHAR2_TABLE_300
3140 , p3_a83 JTF_VARCHAR2_TABLE_300
3141 , p3_a84 JTF_VARCHAR2_TABLE_300
3142 , p3_a85 JTF_VARCHAR2_TABLE_300
3143 , p3_a86 JTF_VARCHAR2_TABLE_300
3144 , p3_a87 JTF_VARCHAR2_TABLE_300
3145 , p3_a88 JTF_VARCHAR2_TABLE_300
3146 , p3_a89 JTF_VARCHAR2_TABLE_300
3147 , p3_a90 JTF_VARCHAR2_TABLE_300
3148 , p3_a91 JTF_VARCHAR2_TABLE_300
3149 , p3_a92 JTF_VARCHAR2_TABLE_300
3150 , p3_a93 JTF_VARCHAR2_TABLE_300
3151 , p3_a94 JTF_VARCHAR2_TABLE_300
3152 , p3_a95 JTF_VARCHAR2_TABLE_300
3153 , p3_a96 JTF_VARCHAR2_TABLE_300
3154 , p3_a97 JTF_VARCHAR2_TABLE_300
3155 , p3_a98 JTF_VARCHAR2_TABLE_300
3156 , p3_a99 JTF_VARCHAR2_TABLE_300
3157 , p3_a100 JTF_VARCHAR2_TABLE_300
3158 , p3_a101 JTF_VARCHAR2_TABLE_300
3159 , p3_a102 JTF_VARCHAR2_TABLE_300
3160 , p3_a103 JTF_VARCHAR2_TABLE_300
3161 , p3_a104 JTF_VARCHAR2_TABLE_100
3162 )
3163
3164 as
3165 ddx_line_dff_tbl oe_oe_html_line_ext.line_dff_tbl_type;
3166 ddindx binary_integer; indx binary_integer;
3167 begin
3168
3169 -- copy data to the local IN or IN-OUT args, if any
3170
3171
3172
3173 oe_oe_html_line_ext_w.rosetta_table_copy_in_p1(ddx_line_dff_tbl, p3_a0
3174 , p3_a1
3175 , p3_a2
3176 , p3_a3
3177 , p3_a4
3178 , p3_a5
3179 , p3_a6
3180 , p3_a7
3181 , p3_a8
3182 , p3_a9
3183 , p3_a10
3184 , p3_a11
3185 , p3_a12
3186 , p3_a13
3187 , p3_a14
3188 , p3_a15
3189 , p3_a16
3190 , p3_a17
3191 , p3_a18
3192 , p3_a19
3193 , p3_a20
3194 , p3_a21
3195 , p3_a22
3196 , p3_a23
3197 , p3_a24
3198 , p3_a25
3199 , p3_a26
3200 , p3_a27
3201 , p3_a28
3202 , p3_a29
3203 , p3_a30
3204 , p3_a31
3205 , p3_a32
3206 , p3_a33
3207 , p3_a34
3208 , p3_a35
3209 , p3_a36
3210 , p3_a37
3211 , p3_a38
3212 , p3_a39
3213 , p3_a40
3214 , p3_a41
3215 , p3_a42
3216 , p3_a43
3217 , p3_a44
3218 , p3_a45
3219 , p3_a46
3220 , p3_a47
3221 , p3_a48
3222 , p3_a49
3223 , p3_a50
3224 , p3_a51
3225 , p3_a52
3226 , p3_a53
3227 , p3_a54
3228 , p3_a55
3229 , p3_a56
3230 , p3_a57
3231 , p3_a58
3232 , p3_a59
3233 , p3_a60
3234 , p3_a61
3235 , p3_a62
3236 , p3_a63
3237 , p3_a64
3238 , p3_a65
3239 , p3_a66
3240 , p3_a67
3241 , p3_a68
3242 , p3_a69
3243 , p3_a70
3244 , p3_a71
3245 , p3_a72
3246 , p3_a73
3247 , p3_a74
3248 , p3_a75
3249 , p3_a76
3250 , p3_a77
3251 , p3_a78
3252 , p3_a79
3253 , p3_a80
3254 , p3_a81
3255 , p3_a82
3256 , p3_a83
3257 , p3_a84
3258 , p3_a85
3259 , p3_a86
3260 , p3_a87
3261 , p3_a88
3262 , p3_a89
3263 , p3_a90
3264 , p3_a91
3265 , p3_a92
3266 , p3_a93
3267 , p3_a94
3268 , p3_a95
3269 , p3_a96
3270 , p3_a97
3271 , p3_a98
3272 , p3_a99
3273 , p3_a100
3274 , p3_a101
3275 , p3_a102
3276 , p3_a103
3277 , p3_a104
3278 );
3279
3280 -- here's the delegated call to the old PL/SQL routine
3281 oe_oe_html_line_ext.prepare_lines_dff_for_save(x_return_status,
3282 x_msg_count,
3283 x_msg_data,
3284 ddx_line_dff_tbl);
3285
3286 -- copy data back from the local variables to OUT or IN-OUT args, if any
3287
3288
3289
3290 end;
3291
3292 procedure populate_transient_attributes(p0_a0 NUMBER
3293 , p0_a1 DATE
3294 , p0_a2 DATE
3295 , p0_a3 NUMBER
3296 , p0_a4 NUMBER
3297 , p0_a5 NUMBER
3298 , p0_a6 VARCHAR2
3299 , p0_a7 NUMBER
3300 , p0_a8 VARCHAR2
3301 , p0_a9 VARCHAR2
3302 , p0_a10 NUMBER
3303 , p0_a11 NUMBER
3304 , p0_a12 NUMBER
3305 , p0_a13 VARCHAR2
3306 , p0_a14 NUMBER
3307 , p0_a15 NUMBER
3308 , p0_a16 NUMBER
3309 , p0_a17 NUMBER
3310 , p0_a18 NUMBER
3311 , p0_a19 NUMBER
3312 , p0_a20 VARCHAR2
3313 , p0_a21 NUMBER
3314 , p0_a22 DATE
3315 , p0_a23 NUMBER
3316 , p0_a24 VARCHAR2
3317 , p0_a25 VARCHAR2
3318 , p0_a26 VARCHAR2
3319 , p0_a27 NUMBER
3320 , p0_a28 VARCHAR2
3321 , p0_a29 VARCHAR2
3322 , p0_a30 VARCHAR2
3323 , p0_a31 NUMBER
3324 , p0_a32 NUMBER
3325 , p0_a33 NUMBER
3326 , p0_a34 VARCHAR2
3327 , p0_a35 VARCHAR2
3328 , p0_a36 VARCHAR2
3329 , p0_a37 DATE
3330 , p0_a38 VARCHAR2
3331 , p0_a39 DATE
3332 , p0_a40 VARCHAR2
3333 , p0_a41 VARCHAR2
3334 , p0_a42 VARCHAR2
3335 , p0_a43 NUMBER
3336 , p0_a44 NUMBER
3337 , p0_a45 NUMBER
3338 , p0_a46 NUMBER
3339 , p0_a47 NUMBER
3340 , p0_a48 NUMBER
3341 , p0_a49 VARCHAR2
3342 , p0_a50 NUMBER
3343 , p0_a51 NUMBER
3344 , p0_a52 NUMBER
3345 , p0_a53 VARCHAR2
3346 , p0_a54 VARCHAR2
3347 , p0_a55 VARCHAR2
3348 , p0_a56 NUMBER
3349 , p0_a57 DATE
3350 , p0_a58 NUMBER
3351 , p0_a59 DATE
3352 , p0_a60 VARCHAR2
3353 , p0_a61 NUMBER
3354 , p0_a62 NUMBER
3355 , p0_a63 NUMBER
3356 , p0_a64 VARCHAR2
3357 , p0_a65 NUMBER
3358 , p0_a66 NUMBER
3359 , p0_a67 NUMBER
3360 , p0_a68 NUMBER
3361 , p0_a69 NUMBER
3362 , p0_a70 VARCHAR2
3363 , p0_a71 VARCHAR2
3364 , p0_a72 NUMBER
3365 , p0_a73 NUMBER
3366 , p0_a74 NUMBER
3367 , p0_a75 VARCHAR2
3368 , p0_a76 VARCHAR2
3369 , p0_a77 NUMBER
3370 , p0_a78 VARCHAR2
3371 , p0_a79 VARCHAR2
3372 , p0_a80 VARCHAR2
3373 , p0_a81 VARCHAR2
3374 , p0_a82 NUMBER
3375 , p0_a83 NUMBER
3376 , p0_a84 VARCHAR2
3377 , p0_a85 NUMBER
3378 , p0_a86 VARCHAR2
3379 , p0_a87 DATE
3380 , p0_a88 NUMBER
3381 , p0_a89 VARCHAR2
3382 , p0_a90 NUMBER
3383 , p0_a91 NUMBER
3384 , p0_a92 DATE
3385 , p0_a93 NUMBER
3386 , p0_a94 DATE
3387 , p0_a95 VARCHAR2
3388 , p0_a96 NUMBER
3389 , p0_a97 NUMBER
3390 , p0_a98 NUMBER
3391 , p0_a99 VARCHAR2
3392 , p0_a100 DATE
3393 , p0_a101 NUMBER
3394 , p0_a102 NUMBER
3395 , p0_a103 VARCHAR2
3396 , p0_a104 VARCHAR2
3397 , p0_a105 NUMBER
3398 , p0_a106 DATE
3399 , p0_a107 DATE
3400 , p0_a108 VARCHAR2
3401 , p0_a109 VARCHAR2
3402 , p0_a110 NUMBER
3403 , p0_a111 VARCHAR2
3404 , p0_a112 NUMBER
3405 , p0_a113 NUMBER
3406 , p0_a114 VARCHAR2
3407 , p0_a115 VARCHAR2
3408 , p0_a116 NUMBER
3409 , p0_a117 NUMBER
3410 , p0_a118 VARCHAR2
3411 , p0_a119 VARCHAR2
3412 , p0_a120 NUMBER
3413 , p0_a121 VARCHAR2
3414 , p0_a122 NUMBER
3415 , p0_a123 NUMBER
3416 , p0_a124 NUMBER
3417 , p0_a125 NUMBER
3418 , p0_a126 NUMBER
3419 , p0_a127 NUMBER
3420 , p0_a128 NUMBER
3421 , p0_a129 NUMBER
3422 , p0_a130 VARCHAR2
3423 , p0_a131 NUMBER
3424 , p0_a132 NUMBER
3425 , p0_a133 NUMBER
3426 , p0_a134 VARCHAR2
3427 , p0_a135 NUMBER
3428 , p0_a136 NUMBER
3429 , p0_a137 VARCHAR2
3430 , p0_a138 DATE
3431 , p0_a139 VARCHAR2
3432 , p0_a140 VARCHAR2
3433 , p0_a141 VARCHAR2
3434 , p0_a142 VARCHAR2
3435 , p0_a143 NUMBER
3436 , p0_a144 NUMBER
3437 , p0_a145 VARCHAR2
3438 , p0_a146 NUMBER
3439 , p0_a147 NUMBER
3440 , p0_a148 NUMBER
3441 , p0_a149 NUMBER
3442 , p0_a150 NUMBER
3443 , p0_a151 NUMBER
3444 , p0_a152 NUMBER
3445 , p0_a153 VARCHAR2
3446 , p0_a154 VARCHAR2
3447 , p0_a155 VARCHAR2
3448 , p0_a156 VARCHAR2
3449 , p0_a157 VARCHAR2
3450 , p0_a158 DATE
3451 , p0_a159 VARCHAR2
3452 , p0_a160 DATE
3453 , p0_a161 VARCHAR2
3454 , p0_a162 VARCHAR2
3455 , p0_a163 VARCHAR2
3456 , p0_a164 VARCHAR2
3457 , p0_a165 VARCHAR2
3458 , p0_a166 NUMBER
3459 , p0_a167 VARCHAR2
3460 , p0_a168 VARCHAR2
3461 , p0_a169 VARCHAR2
3462 , p0_a170 VARCHAR2
3463 , p0_a171 VARCHAR2
3464 , p0_a172 VARCHAR2
3465 , p0_a173 VARCHAR2
3466 , p0_a174 NUMBER
3467 , p0_a175 NUMBER
3468 , p0_a176 NUMBER
3469 , p0_a177 VARCHAR2
3470 , p0_a178 VARCHAR2
3471 , p0_a179 VARCHAR2
3472 , p0_a180 VARCHAR2
3473 , p0_a181 NUMBER
3474 , p0_a182 VARCHAR2
3475 , p0_a183 VARCHAR2
3476 , p0_a184 NUMBER
3477 , p0_a185 VARCHAR2
3478 , p0_a186 DATE
3479 , p0_a187 DATE
3480 , p0_a188 VARCHAR2
3481 , p0_a189 NUMBER
3482 , p0_a190 NUMBER
3483 , p0_a191 NUMBER
3484 , p0_a192 NUMBER
3485 , p0_a193 VARCHAR2
3486 , p0_a194 NUMBER
3487 , p0_a195 NUMBER
3488 , p0_a196 NUMBER
3489 , p0_a197 NUMBER
3490 , p0_a198 VARCHAR2
3491 , p0_a199 VARCHAR2
3492 , p0_a200 VARCHAR2
3493 , p0_a201 NUMBER
3494 , p0_a202 NUMBER
3495 , p0_a203 NUMBER
3496 , p0_a204 NUMBER
3497 , p0_a205 VARCHAR2
3498 , p0_a206 VARCHAR2
3499 , p0_a207 VARCHAR2
3500 , p0_a208 VARCHAR2
3501 , p0_a209 VARCHAR2
3502 , p0_a210 VARCHAR2
3503 , p0_a211 VARCHAR2
3504 , p0_a212 NUMBER
3505 , p0_a213 NUMBER
3506 , p0_a214 DATE
3507 , p0_a215 NUMBER
3508 , p0_a216 VARCHAR2
3509 , p0_a217 NUMBER
3510 , p0_a218 VARCHAR2
3511 , p0_a219 VARCHAR2
3512 , p0_a220 VARCHAR2
3513 , p0_a221 VARCHAR2
3514 , p0_a222 VARCHAR2
3515 , p0_a223 VARCHAR2
3516 , p0_a224 NUMBER
3517 , p0_a225 NUMBER
3518 , p0_a226 NUMBER
3519 , p0_a227 NUMBER
3520 , p0_a228 VARCHAR2
3521 , p0_a229 NUMBER
3522 , p0_a230 VARCHAR2
3523 , p0_a231 NUMBER
3524 , p0_a232 VARCHAR2
3525 , p0_a233 VARCHAR2
3526 , p0_a234 NUMBER
3527 , p0_a235 VARCHAR2
3528 , p0_a236 NUMBER
3529 , p0_a237 NUMBER
3530 , p0_a238 NUMBER
3531 , p0_a239 NUMBER
3532 , p0_a240 NUMBER
3533 , p0_a241 VARCHAR2
3534 , p0_a242 VARCHAR2
3535 , p0_a243 NUMBER
3536 , p0_a244 NUMBER
3537 , p0_a245 NUMBER
3538 , p0_a246 NUMBER
3539 , p0_a247 VARCHAR2
3540 , p0_a248 VARCHAR2
3541 , p0_a249 DATE
3542 , p0_a250 VARCHAR2
3543 , p0_a251 NUMBER
3544 , p0_a252 NUMBER
3545 , p0_a253 VARCHAR2
3546 , p0_a254 VARCHAR2
3547 , p0_a255 VARCHAR2
3548 , p0_a256 NUMBER
3549 , p0_a257 NUMBER
3550 , p0_a258 NUMBER
3551 , p0_a259 VARCHAR2
3552 , p0_a260 DATE
3553 , p0_a261 VARCHAR2
3554 , p0_a262 DATE
3555 , p0_a263 NUMBER
3556 , p0_a264 NUMBER
3557 , p0_a265 NUMBER
3558 , p0_a266 NUMBER
3559 , p0_a267 NUMBER
3560 , p0_a268 NUMBER
3561 , p0_a269 NUMBER
3562 , p0_a270 NUMBER
3563 , p0_a271 NUMBER
3564 , p0_a272 NUMBER
3565 , p0_a273 NUMBER
3566 , p0_a274 NUMBER
3567 , p0_a275 NUMBER
3568 , p0_a276 NUMBER
3569 , p0_a277 NUMBER
3570 , p0_a278 NUMBER
3571 , p0_a279 NUMBER
3572 , p0_a280 NUMBER
3573 , p1_a0 out NOCOPY /* file.sql.39 change */ VARCHAR2
3574 , p1_a1 out NOCOPY /* file.sql.39 change */ VARCHAR2
3575 , p1_a2 out NOCOPY /* file.sql.39 change */ VARCHAR2
3576 , p1_a3 out NOCOPY /* file.sql.39 change */ NUMBER
3577 , p1_a4 out NOCOPY /* file.sql.39 change */ VARCHAR2
3578 , p1_a5 out NOCOPY /* file.sql.39 change */ VARCHAR2
3579 , p1_a6 out NOCOPY /* file.sql.39 change */ VARCHAR2
3580 , p1_a7 out NOCOPY /* file.sql.39 change */ VARCHAR2
3581 , p1_a8 out NOCOPY /* file.sql.39 change */ VARCHAR2
3582 , p1_a9 out NOCOPY /* file.sql.39 change */ VARCHAR2
3583 , p1_a10 out NOCOPY /* file.sql.39 change */ VARCHAR2
3584 , p1_a11 out NOCOPY /* file.sql.39 change */ VARCHAR2
3585 , p1_a12 out NOCOPY /* file.sql.39 change */ VARCHAR2
3586 , p1_a13 out NOCOPY /* file.sql.39 change */ VARCHAR2
3587 , p1_a14 out NOCOPY /* file.sql.39 change */ VARCHAR2
3588 , p1_a15 out NOCOPY /* file.sql.39 change */ VARCHAR2
3589 , p1_a16 out NOCOPY /* file.sql.39 change */ VARCHAR2
3590 , p1_a17 out NOCOPY /* file.sql.39 change */ VARCHAR2
3591 , p1_a18 out NOCOPY /* file.sql.39 change */ VARCHAR2
3592 , p1_a19 out NOCOPY /* file.sql.39 change */ VARCHAR2
3593 , p1_a20 out NOCOPY /* file.sql.39 change */ VARCHAR2
3594 , p1_a21 out NOCOPY /* file.sql.39 change */ VARCHAR2
3595 , p1_a22 out NOCOPY /* file.sql.39 change */ VARCHAR2
3596 , p1_a23 out NOCOPY /* file.sql.39 change */ VARCHAR2
3597 , p1_a24 out NOCOPY /* file.sql.39 change */ VARCHAR2
3598 , p1_a25 out NOCOPY /* file.sql.39 change */ VARCHAR2
3599 , p1_a26 out NOCOPY /* file.sql.39 change */ VARCHAR2
3600 , p1_a27 out NOCOPY /* file.sql.39 change */ VARCHAR2
3601 , p1_a28 out NOCOPY /* file.sql.39 change */ VARCHAR2
3602 , p1_a29 out NOCOPY /* file.sql.39 change */ VARCHAR2
3603 , p1_a30 out NOCOPY /* file.sql.39 change */ VARCHAR2
3604 , p1_a31 out NOCOPY /* file.sql.39 change */ VARCHAR2
3605 , p1_a32 out NOCOPY /* file.sql.39 change */ VARCHAR2
3606 , p1_a33 out NOCOPY /* file.sql.39 change */ VARCHAR2
3607 , p1_a34 out NOCOPY /* file.sql.39 change */ VARCHAR2
3608 , p1_a35 out NOCOPY /* file.sql.39 change */ VARCHAR2
3609 , p1_a36 out NOCOPY /* file.sql.39 change */ VARCHAR2
3610 , p1_a37 out NOCOPY /* file.sql.39 change */ VARCHAR2
3611 , p1_a38 out NOCOPY /* file.sql.39 change */ VARCHAR2
3612 , p1_a39 out NOCOPY /* file.sql.39 change */ VARCHAR2
3613 , p1_a40 out NOCOPY /* file.sql.39 change */ VARCHAR2
3614 , p1_a41 out NOCOPY /* file.sql.39 change */ VARCHAR2
3615 , p1_a42 out NOCOPY /* file.sql.39 change */ VARCHAR2
3616 , p1_a43 out NOCOPY /* file.sql.39 change */ VARCHAR2
3617 , p1_a44 out NOCOPY /* file.sql.39 change */ VARCHAR2
3618 , p1_a45 out NOCOPY /* file.sql.39 change */ VARCHAR2
3619 , p1_a46 out NOCOPY /* file.sql.39 change */ VARCHAR2
3620 , p1_a47 out NOCOPY /* file.sql.39 change */ VARCHAR2
3621 , p1_a48 out NOCOPY /* file.sql.39 change */ VARCHAR2
3622 , p1_a49 out NOCOPY /* file.sql.39 change */ VARCHAR2
3623 , p1_a50 out NOCOPY /* file.sql.39 change */ VARCHAR2
3624 , p1_a51 out NOCOPY /* file.sql.39 change */ VARCHAR
3625 , p1_a52 out NOCOPY /* file.sql.39 change */ VARCHAR
3626 , p1_a53 out NOCOPY /* file.sql.39 change */ VARCHAR
3627 , p1_a54 out NOCOPY /* file.sql.39 change */ VARCHAR2
3628 , p1_a55 out NOCOPY /* file.sql.39 change */ VARCHAR2
3629 , p1_a56 out NOCOPY /* file.sql.39 change */ VARCHAR2
3630 , p1_a57 out NOCOPY /* file.sql.39 change */ VARCHAR2
3631 , p1_a58 out NOCOPY /* file.sql.39 change */ VARCHAR2
3632 , p1_a59 out NOCOPY /* file.sql.39 change */ VARCHAR2
3633 , p1_a60 out NOCOPY /* file.sql.39 change */ VARCHAR2
3634 , p1_a61 out NOCOPY /* file.sql.39 change */ VARCHAR2
3635 , p1_a62 out NOCOPY /* file.sql.39 change */ VARCHAR2
3636 , p1_a63 out NOCOPY /* file.sql.39 change */ VARCHAR2
3637 , p1_a64 out NOCOPY /* file.sql.39 change */ VARCHAR2
3638 , p1_a65 out NOCOPY /* file.sql.39 change */ VARCHAR2
3639 , p1_a66 out NOCOPY /* file.sql.39 change */ VARCHAR2
3640 , p1_a67 out NOCOPY /* file.sql.39 change */ VARCHAR2
3641 , p1_a68 out NOCOPY /* file.sql.39 change */ VARCHAR2
3642 , p1_a69 out NOCOPY /* file.sql.39 change */ VARCHAR2
3643 , p1_a70 out NOCOPY /* file.sql.39 change */ VARCHAR2
3644 , p1_a71 out NOCOPY /* file.sql.39 change */ VARCHAR2
3645 , p1_a72 out NOCOPY /* file.sql.39 change */ VARCHAR2
3646 , p1_a73 out NOCOPY /* file.sql.39 change */ VARCHAR2
3647 , p1_a74 out NOCOPY /* file.sql.39 change */ VARCHAR2
3648 , p1_a75 out NOCOPY /* file.sql.39 change */ VARCHAR2
3649 , p1_a76 out NOCOPY /* file.sql.39 change */ VARCHAR2
3650 , p1_a77 out NOCOPY /* file.sql.39 change */ VARCHAR2
3651 , p1_a78 out NOCOPY /* file.sql.39 change */ VARCHAR2
3652 , p1_a79 out NOCOPY /* file.sql.39 change */ VARCHAR2
3653 , p1_a80 out NOCOPY /* file.sql.39 change */ VARCHAR2
3654 , p1_a81 out NOCOPY /* file.sql.39 change */ VARCHAR2
3655 , p1_a82 out NOCOPY /* file.sql.39 change */ VARCHAR2
3656 , p1_a83 out NOCOPY /* file.sql.39 change */ VARCHAR2
3657 , p1_a84 out NOCOPY /* file.sql.39 change */ VARCHAR2
3658 , p1_a85 out NOCOPY /* file.sql.39 change */ VARCHAR2
3659 , p1_a86 out NOCOPY /* file.sql.39 change */ VARCHAR2
3660 , p1_a87 out NOCOPY /* file.sql.39 change */ VARCHAR2
3661 , p1_a88 out NOCOPY /* file.sql.39 change */ VARCHAR2
3662 , p1_a89 out NOCOPY /* file.sql.39 change */ VARCHAR2
3663 , p1_a90 out NOCOPY /* file.sql.39 change */ VARCHAR2
3664 , p1_a91 out NOCOPY /* file.sql.39 change */ VARCHAR2
3665 , p1_a92 out NOCOPY /* file.sql.39 change */ VARCHAR2
3666 , p1_a93 out NOCOPY /* file.sql.39 change */ VARCHAR2
3667 , p1_a94 out NOCOPY /* file.sql.39 change */ VARCHAR2
3668 , p1_a95 out NOCOPY /* file.sql.39 change */ VARCHAR2
3669 , p1_a96 out NOCOPY /* file.sql.39 change */ NUMBER
3670 , p1_a97 out NOCOPY /* file.sql.39 change */ NUMBER
3671 , p1_a98 out NOCOPY /* file.sql.39 change */ NUMBER
3672 , p1_a99 out NOCOPY /* file.sql.39 change */ NUMBER
3673 , p1_a100 out NOCOPY /* file.sql.39 change */ VARCHAR2
3674 , p1_a101 out NOCOPY /* file.sql.39 change */ NUMBER
3675 , p1_a102 out NOCOPY /* file.sql.39 change */ VARCHAR2
3676 , p1_a103 out NOCOPY /* file.sql.39 change */ VARCHAR2
3677 , p1_a104 out NOCOPY /* file.sql.39 change */ VARCHAR2
3678 , p1_a105 out NOCOPY /* file.sql.39 change */ VARCHAR2
3679 , p1_a106 out NOCOPY /* file.sql.39 change */ VARCHAR2
3680 , p1_a107 out NOCOPY /* file.sql.39 change */ VARCHAR2
3681 , p1_a108 out NOCOPY /* file.sql.39 change */ VARCHAR2
3682 , p1_a109 out NOCOPY /* file.sql.39 change */ VARCHAR2
3683 , p1_a110 out NOCOPY /* file.sql.39 change */ VARCHAR2
3684 , p1_a111 out NOCOPY /* file.sql.39 change */ VARCHAR2
3685 , p1_a112 out NOCOPY /* file.sql.39 change */ NUMBER
3686 , p1_a113 out NOCOPY /* file.sql.39 change */ NUMBER
3687 , p1_a114 out NOCOPY /* file.sql.39 change */ NUMBER
3688 , p1_a115 out NOCOPY /* file.sql.39 change */ VARCHAR2
3689 , p1_a116 out NOCOPY /* file.sql.39 change */ VARCHAR2
3690 , p1_a117 out NOCOPY /* file.sql.39 change */ VARCHAR2
3691 , p1_a118 out NOCOPY /* file.sql.39 change */ VARCHAR2
3692 , p1_a119 out NOCOPY /* file.sql.39 change */ VARCHAR2
3693 , p1_a120 out NOCOPY /* file.sql.39 change */ VARCHAR2
3694 , p1_a121 out NOCOPY /* file.sql.39 change */ VARCHAR2
3695 , p1_a122 out NOCOPY /* file.sql.39 change */ VARCHAR2
3696 , p1_a123 out NOCOPY /* file.sql.39 change */ VARCHAR2
3697 , p1_a124 out NOCOPY /* file.sql.39 change */ VARCHAR2
3698 , p1_a125 out NOCOPY /* file.sql.39 change */ VARCHAR2
3699 , p1_a126 out NOCOPY /* file.sql.39 change */ VARCHAR2
3700 , p1_a127 out NOCOPY /* file.sql.39 change */ VARCHAR2
3701 , p1_a128 out NOCOPY /* file.sql.39 change */ VARCHAR2
3702 , p1_a129 out NOCOPY /* file.sql.39 change */ VARCHAR2
3703 , p1_a130 out NOCOPY /* file.sql.39 change */ VARCHAR2
3704 , p1_a131 out NOCOPY /* file.sql.39 change */ VARCHAR2
3705 , p1_a132 out NOCOPY /* file.sql.39 change */ VARCHAR2
3706 , p1_a133 out NOCOPY /* file.sql.39 change */ VARCHAR2
3707 , p1_a134 out NOCOPY /* file.sql.39 change */ VARCHAR2
3708 , p1_a135 out NOCOPY /* file.sql.39 change */ VARCHAR2
3709 , p1_a136 out NOCOPY /* file.sql.39 change */ VARCHAR2
3710 , p1_a137 out NOCOPY /* file.sql.39 change */ VARCHAR2
3711 , p1_a138 out NOCOPY /* file.sql.39 change */ VARCHAR2
3712 , p1_a139 out NOCOPY /* file.sql.39 change */ VARCHAR2
3713 , p1_a140 out NOCOPY /* file.sql.39 change */ VARCHAR2
3714 , p1_a141 out NOCOPY /* file.sql.39 change */ VARCHAR2
3715 , p1_a142 out NOCOPY /* file.sql.39 change */ VARCHAR2
3716 , p1_a143 out NOCOPY /* file.sql.39 change */ VARCHAR2
3717 , p1_a144 out NOCOPY /* file.sql.39 change */ VARCHAR2
3718 , p1_a145 out NOCOPY /* file.sql.39 change */ VARCHAR2
3719 , p1_a146 out NOCOPY /* file.sql.39 change */ NUMBER
3720 , p1_a147 out NOCOPY /* file.sql.39 change */ NUMBER
3721 , p1_a148 out NOCOPY /* file.sql.39 change */ NUMBER
3722 , p1_a149 out NOCOPY /* file.sql.39 change */ VARCHAR2
3723 , p1_a150 out NOCOPY /* file.sql.39 change */ VARCHAR2
3724 , x_return_status out NOCOPY /* file.sql.39 change */ VARCHAR2
3725 , x_msg_count out NOCOPY /* file.sql.39 change */ NUMBER
3726 , x_msg_data out NOCOPY /* file.sql.39 change */ VARCHAR2
3727 )
3728
3729 as
3730 ddp_line_rec oe_order_pub.line_rec_type;
3731 ddx_line_val_rec oe_oe_html_line_ext.line_ext_val_rec_type;
3732 ddindx binary_integer; indx binary_integer;
3733 begin
3734
3735 -- copy data to the local IN or IN-OUT args, if any
3736 ddp_line_rec.accounting_rule_id := rosetta_g_miss_num_map(p0_a0);
3737 ddp_line_rec.actual_arrival_date := rosetta_g_miss_date_in_map(p0_a1);
3738 ddp_line_rec.actual_shipment_date := rosetta_g_miss_date_in_map(p0_a2);
3739 ddp_line_rec.agreement_id := rosetta_g_miss_num_map(p0_a3);
3740 ddp_line_rec.arrival_set_id := rosetta_g_miss_num_map(p0_a4);
3741 ddp_line_rec.ato_line_id := rosetta_g_miss_num_map(p0_a5);
3742 ddp_line_rec.authorized_to_ship_flag := p0_a6;
3743 ddp_line_rec.auto_selected_quantity := rosetta_g_miss_num_map(p0_a7);
3744 ddp_line_rec.booked_flag := p0_a8;
3745 ddp_line_rec.cancelled_flag := p0_a9;
3746 ddp_line_rec.cancelled_quantity := rosetta_g_miss_num_map(p0_a10);
3747 ddp_line_rec.cancelled_quantity2 := rosetta_g_miss_num_map(p0_a11);
3748 ddp_line_rec.commitment_id := rosetta_g_miss_num_map(p0_a12);
3749 ddp_line_rec.component_code := p0_a13;
3750 ddp_line_rec.component_number := rosetta_g_miss_num_map(p0_a14);
3751 ddp_line_rec.component_sequence_id := rosetta_g_miss_num_map(p0_a15);
3752 ddp_line_rec.config_header_id := rosetta_g_miss_num_map(p0_a16);
3753 ddp_line_rec.config_rev_nbr := rosetta_g_miss_num_map(p0_a17);
3754 ddp_line_rec.config_display_sequence := rosetta_g_miss_num_map(p0_a18);
3755 ddp_line_rec.configuration_id := rosetta_g_miss_num_map(p0_a19);
3756 ddp_line_rec.context := p0_a20;
3757 ddp_line_rec.created_by := rosetta_g_miss_num_map(p0_a21);
3758 ddp_line_rec.creation_date := rosetta_g_miss_date_in_map(p0_a22);
3759 ddp_line_rec.credit_invoice_line_id := rosetta_g_miss_num_map(p0_a23);
3760 ddp_line_rec.customer_dock_code := p0_a24;
3761 ddp_line_rec.customer_job := p0_a25;
3762 ddp_line_rec.customer_production_line := p0_a26;
3763 ddp_line_rec.customer_trx_line_id := rosetta_g_miss_num_map(p0_a27);
3764 ddp_line_rec.cust_model_serial_number := p0_a28;
3765 ddp_line_rec.cust_po_number := p0_a29;
3766 ddp_line_rec.cust_production_seq_num := p0_a30;
3767 ddp_line_rec.delivery_lead_time := rosetta_g_miss_num_map(p0_a31);
3768 ddp_line_rec.deliver_to_contact_id := rosetta_g_miss_num_map(p0_a32);
3769 ddp_line_rec.deliver_to_org_id := rosetta_g_miss_num_map(p0_a33);
3770 ddp_line_rec.demand_bucket_type_code := p0_a34;
3771 ddp_line_rec.demand_class_code := p0_a35;
3772 ddp_line_rec.dep_plan_required_flag := p0_a36;
3773 ddp_line_rec.earliest_acceptable_date := rosetta_g_miss_date_in_map(p0_a37);
3774 ddp_line_rec.end_item_unit_number := p0_a38;
3775 ddp_line_rec.explosion_date := rosetta_g_miss_date_in_map(p0_a39);
3776 ddp_line_rec.fob_point_code := p0_a40;
3777 ddp_line_rec.freight_carrier_code := p0_a41;
3778 ddp_line_rec.freight_terms_code := p0_a42;
3779 ddp_line_rec.fulfilled_quantity := rosetta_g_miss_num_map(p0_a43);
3780 ddp_line_rec.fulfilled_quantity2 := rosetta_g_miss_num_map(p0_a44);
3781 ddp_line_rec.header_id := rosetta_g_miss_num_map(p0_a45);
3782 ddp_line_rec.intermed_ship_to_org_id := rosetta_g_miss_num_map(p0_a46);
3783 ddp_line_rec.intermed_ship_to_contact_id := rosetta_g_miss_num_map(p0_a47);
3784 ddp_line_rec.inventory_item_id := rosetta_g_miss_num_map(p0_a48);
3785 ddp_line_rec.invoice_interface_status_code := p0_a49;
3786 ddp_line_rec.invoice_to_contact_id := rosetta_g_miss_num_map(p0_a50);
3787 ddp_line_rec.invoice_to_org_id := rosetta_g_miss_num_map(p0_a51);
3788 ddp_line_rec.invoicing_rule_id := rosetta_g_miss_num_map(p0_a52);
3789 ddp_line_rec.ordered_item := p0_a53;
3790 ddp_line_rec.item_revision := p0_a54;
3791 ddp_line_rec.item_type_code := p0_a55;
3792 ddp_line_rec.last_updated_by := rosetta_g_miss_num_map(p0_a56);
3793 ddp_line_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a57);
3794 ddp_line_rec.last_update_login := rosetta_g_miss_num_map(p0_a58);
3795 ddp_line_rec.latest_acceptable_date := rosetta_g_miss_date_in_map(p0_a59);
3796 ddp_line_rec.line_category_code := p0_a60;
3797 ddp_line_rec.line_id := rosetta_g_miss_num_map(p0_a61);
3798 ddp_line_rec.line_number := rosetta_g_miss_num_map(p0_a62);
3799 ddp_line_rec.line_type_id := rosetta_g_miss_num_map(p0_a63);
3800 ddp_line_rec.link_to_line_ref := p0_a64;
3801 ddp_line_rec.link_to_line_id := rosetta_g_miss_num_map(p0_a65);
3802 ddp_line_rec.link_to_line_index := rosetta_g_miss_num_map(p0_a66);
3803 ddp_line_rec.model_group_number := rosetta_g_miss_num_map(p0_a67);
3804 ddp_line_rec.mfg_component_sequence_id := rosetta_g_miss_num_map(p0_a68);
3805 ddp_line_rec.mfg_lead_time := rosetta_g_miss_num_map(p0_a69);
3806 ddp_line_rec.open_flag := p0_a70;
3807 ddp_line_rec.option_flag := p0_a71;
3808 ddp_line_rec.option_number := rosetta_g_miss_num_map(p0_a72);
3809 ddp_line_rec.ordered_quantity := rosetta_g_miss_num_map(p0_a73);
3810 ddp_line_rec.ordered_quantity2 := rosetta_g_miss_num_map(p0_a74);
3811 ddp_line_rec.order_quantity_uom := p0_a75;
3812 ddp_line_rec.ordered_quantity_uom2 := p0_a76;
3813 ddp_line_rec.org_id := rosetta_g_miss_num_map(p0_a77);
3814 ddp_line_rec.orig_sys_document_ref := p0_a78;
3815 ddp_line_rec.orig_sys_line_ref := p0_a79;
3816 ddp_line_rec.over_ship_reason_code := p0_a80;
3817 ddp_line_rec.over_ship_resolved_flag := p0_a81;
3818 ddp_line_rec.payment_term_id := rosetta_g_miss_num_map(p0_a82);
3819 ddp_line_rec.planning_priority := rosetta_g_miss_num_map(p0_a83);
3820 ddp_line_rec.preferred_grade := p0_a84;
3821 ddp_line_rec.price_list_id := rosetta_g_miss_num_map(p0_a85);
3822 ddp_line_rec.price_request_code := p0_a86;
3823 ddp_line_rec.pricing_date := rosetta_g_miss_date_in_map(p0_a87);
3824 ddp_line_rec.pricing_quantity := rosetta_g_miss_num_map(p0_a88);
3825 ddp_line_rec.pricing_quantity_uom := p0_a89;
3826 ddp_line_rec.program_application_id := rosetta_g_miss_num_map(p0_a90);
3827 ddp_line_rec.program_id := rosetta_g_miss_num_map(p0_a91);
3828 ddp_line_rec.program_update_date := rosetta_g_miss_date_in_map(p0_a92);
3829 ddp_line_rec.project_id := rosetta_g_miss_num_map(p0_a93);
3830 ddp_line_rec.promise_date := rosetta_g_miss_date_in_map(p0_a94);
3831 ddp_line_rec.re_source_flag := p0_a95;
3832 ddp_line_rec.reference_customer_trx_line_id := rosetta_g_miss_num_map(p0_a96);
3833 ddp_line_rec.reference_header_id := rosetta_g_miss_num_map(p0_a97);
3834 ddp_line_rec.reference_line_id := rosetta_g_miss_num_map(p0_a98);
3835 ddp_line_rec.reference_type := p0_a99;
3836 ddp_line_rec.request_date := rosetta_g_miss_date_in_map(p0_a100);
3837 ddp_line_rec.request_id := rosetta_g_miss_num_map(p0_a101);
3838 ddp_line_rec.reserved_quantity := rosetta_g_miss_num_map(p0_a102);
3839 ddp_line_rec.return_reason_code := p0_a103;
3840 ddp_line_rec.rla_schedule_type_code := p0_a104;
3841 ddp_line_rec.salesrep_id := rosetta_g_miss_num_map(p0_a105);
3842 ddp_line_rec.schedule_arrival_date := rosetta_g_miss_date_in_map(p0_a106);
3843 ddp_line_rec.schedule_ship_date := rosetta_g_miss_date_in_map(p0_a107);
3844 ddp_line_rec.schedule_action_code := p0_a108;
3845 ddp_line_rec.schedule_status_code := p0_a109;
3846 ddp_line_rec.shipment_number := rosetta_g_miss_num_map(p0_a110);
3847 ddp_line_rec.shipment_priority_code := p0_a111;
3848 ddp_line_rec.shipped_quantity := rosetta_g_miss_num_map(p0_a112);
3849 ddp_line_rec.shipped_quantity2 := rosetta_g_miss_num_map(p0_a113);
3850 ddp_line_rec.shipping_interfaced_flag := p0_a114;
3851 ddp_line_rec.shipping_method_code := p0_a115;
3852 ddp_line_rec.shipping_quantity := rosetta_g_miss_num_map(p0_a116);
3853 ddp_line_rec.shipping_quantity2 := rosetta_g_miss_num_map(p0_a117);
3854 ddp_line_rec.shipping_quantity_uom := p0_a118;
3855 ddp_line_rec.shipping_quantity_uom2 := p0_a119;
3856 ddp_line_rec.ship_from_org_id := rosetta_g_miss_num_map(p0_a120);
3857 ddp_line_rec.ship_model_complete_flag := p0_a121;
3858 ddp_line_rec.ship_set_id := rosetta_g_miss_num_map(p0_a122);
3859 ddp_line_rec.fulfillment_set_id := rosetta_g_miss_num_map(p0_a123);
3860 ddp_line_rec.ship_tolerance_above := rosetta_g_miss_num_map(p0_a124);
3861 ddp_line_rec.ship_tolerance_below := rosetta_g_miss_num_map(p0_a125);
3862 ddp_line_rec.ship_to_contact_id := rosetta_g_miss_num_map(p0_a126);
3863 ddp_line_rec.ship_to_org_id := rosetta_g_miss_num_map(p0_a127);
3864 ddp_line_rec.sold_to_org_id := rosetta_g_miss_num_map(p0_a128);
3865 ddp_line_rec.sold_from_org_id := rosetta_g_miss_num_map(p0_a129);
3866 ddp_line_rec.sort_order := p0_a130;
3867 ddp_line_rec.source_document_id := rosetta_g_miss_num_map(p0_a131);
3868 ddp_line_rec.source_document_line_id := rosetta_g_miss_num_map(p0_a132);
3869 ddp_line_rec.source_document_type_id := rosetta_g_miss_num_map(p0_a133);
3870 ddp_line_rec.source_type_code := p0_a134;
3871 ddp_line_rec.split_from_line_id := rosetta_g_miss_num_map(p0_a135);
3872 ddp_line_rec.task_id := rosetta_g_miss_num_map(p0_a136);
3873 ddp_line_rec.tax_code := p0_a137;
3874 ddp_line_rec.tax_date := rosetta_g_miss_date_in_map(p0_a138);
3875 ddp_line_rec.tax_exempt_flag := p0_a139;
3876 ddp_line_rec.tax_exempt_number := p0_a140;
3877 ddp_line_rec.tax_exempt_reason_code := p0_a141;
3878 ddp_line_rec.tax_point_code := p0_a142;
3879 ddp_line_rec.tax_rate := rosetta_g_miss_num_map(p0_a143);
3880 ddp_line_rec.tax_value := rosetta_g_miss_num_map(p0_a144);
3881 ddp_line_rec.top_model_line_ref := p0_a145;
3882 ddp_line_rec.top_model_line_id := rosetta_g_miss_num_map(p0_a146);
3883 ddp_line_rec.top_model_line_index := rosetta_g_miss_num_map(p0_a147);
3884 ddp_line_rec.unit_list_price := rosetta_g_miss_num_map(p0_a148);
3885 ddp_line_rec.unit_list_price_per_pqty := rosetta_g_miss_num_map(p0_a149);
3886 ddp_line_rec.unit_selling_price := rosetta_g_miss_num_map(p0_a150);
3887 ddp_line_rec.unit_selling_price_per_pqty := rosetta_g_miss_num_map(p0_a151);
3888 ddp_line_rec.veh_cus_item_cum_key_id := rosetta_g_miss_num_map(p0_a152);
3889 ddp_line_rec.visible_demand_flag := p0_a153;
3890 ddp_line_rec.return_status := p0_a154;
3891 ddp_line_rec.db_flag := p0_a155;
3892 ddp_line_rec.operation := p0_a156;
3893 ddp_line_rec.first_ack_code := p0_a157;
3894 ddp_line_rec.first_ack_date := rosetta_g_miss_date_in_map(p0_a158);
3895 ddp_line_rec.last_ack_code := p0_a159;
3896 ddp_line_rec.last_ack_date := rosetta_g_miss_date_in_map(p0_a160);
3897 ddp_line_rec.change_reason := p0_a161;
3898 ddp_line_rec.change_comments := p0_a162;
3899 ddp_line_rec.arrival_set := p0_a163;
3900 ddp_line_rec.ship_set := p0_a164;
3901 ddp_line_rec.fulfillment_set := p0_a165;
3902 ddp_line_rec.order_source_id := rosetta_g_miss_num_map(p0_a166);
3903 ddp_line_rec.orig_sys_shipment_ref := p0_a167;
3904 ddp_line_rec.change_sequence := p0_a168;
3905 ddp_line_rec.change_request_code := p0_a169;
3906 ddp_line_rec.status_flag := p0_a170;
3907 ddp_line_rec.drop_ship_flag := p0_a171;
3908 ddp_line_rec.customer_line_number := p0_a172;
3909 ddp_line_rec.customer_shipment_number := p0_a173;
3910 ddp_line_rec.customer_item_net_price := rosetta_g_miss_num_map(p0_a174);
3911 ddp_line_rec.customer_payment_term_id := rosetta_g_miss_num_map(p0_a175);
3912 ddp_line_rec.ordered_item_id := rosetta_g_miss_num_map(p0_a176);
3913 ddp_line_rec.item_identifier_type := p0_a177;
3914 ddp_line_rec.shipping_instructions := p0_a178;
3915 ddp_line_rec.packing_instructions := p0_a179;
3916 ddp_line_rec.calculate_price_flag := p0_a180;
3917 ddp_line_rec.invoiced_quantity := rosetta_g_miss_num_map(p0_a181);
3918 ddp_line_rec.service_txn_reason_code := p0_a182;
3919 ddp_line_rec.service_txn_comments := p0_a183;
3920 ddp_line_rec.service_duration := rosetta_g_miss_num_map(p0_a184);
3921 ddp_line_rec.service_period := p0_a185;
3922 ddp_line_rec.service_start_date := rosetta_g_miss_date_in_map(p0_a186);
3923 ddp_line_rec.service_end_date := rosetta_g_miss_date_in_map(p0_a187);
3924 ddp_line_rec.service_coterminate_flag := p0_a188;
3925 ddp_line_rec.unit_list_percent := rosetta_g_miss_num_map(p0_a189);
3926 ddp_line_rec.unit_selling_percent := rosetta_g_miss_num_map(p0_a190);
3927 ddp_line_rec.unit_percent_base_price := rosetta_g_miss_num_map(p0_a191);
3928 ddp_line_rec.service_number := rosetta_g_miss_num_map(p0_a192);
3929 ddp_line_rec.service_reference_type_code := p0_a193;
3930 ddp_line_rec.service_reference_line_id := rosetta_g_miss_num_map(p0_a194);
3931 ddp_line_rec.service_reference_system_id := rosetta_g_miss_num_map(p0_a195);
3932 ddp_line_rec.service_ref_order_number := rosetta_g_miss_num_map(p0_a196);
3933 ddp_line_rec.service_ref_line_number := rosetta_g_miss_num_map(p0_a197);
3934 ddp_line_rec.service_reference_order := p0_a198;
3935 ddp_line_rec.service_reference_line := p0_a199;
3936 ddp_line_rec.service_reference_system := p0_a200;
3937 ddp_line_rec.service_ref_shipment_number := rosetta_g_miss_num_map(p0_a201);
3938 ddp_line_rec.service_ref_option_number := rosetta_g_miss_num_map(p0_a202);
3939 ddp_line_rec.service_line_index := rosetta_g_miss_num_map(p0_a203);
3940 ddp_line_rec.line_set_id := rosetta_g_miss_num_map(p0_a204);
3941 ddp_line_rec.split_by := p0_a205;
3942 ddp_line_rec.split_action_code := p0_a206;
3943 ddp_line_rec.shippable_flag := p0_a207;
3944 ddp_line_rec.model_remnant_flag := p0_a208;
3945 ddp_line_rec.flow_status_code := p0_a209;
3946 ddp_line_rec.fulfilled_flag := p0_a210;
3947 ddp_line_rec.fulfillment_method_code := p0_a211;
3948 ddp_line_rec.revenue_amount := rosetta_g_miss_num_map(p0_a212);
3949 ddp_line_rec.marketing_source_code_id := rosetta_g_miss_num_map(p0_a213);
3950 ddp_line_rec.fulfillment_date := rosetta_g_miss_date_in_map(p0_a214);
3951 if p0_a215 is null
3952 then ddp_line_rec.semi_processed_flag := null;
3953 elsif p0_a215 = 0
3954 then ddp_line_rec.semi_processed_flag := false;
3955 else ddp_line_rec.semi_processed_flag := true;
3956 end if;
3957 ddp_line_rec.upgraded_flag := p0_a216;
3958 ddp_line_rec.lock_control := rosetta_g_miss_num_map(p0_a217);
3959 ddp_line_rec.subinventory := p0_a218;
3960 ddp_line_rec.split_from_line_ref := p0_a219;
3961 ddp_line_rec.split_from_shipment_ref := p0_a220;
3962 ddp_line_rec.ship_to_edi_location_code := p0_a221;
3963 ddp_line_rec.bill_to_edi_location_code := p0_a222;
3964 ddp_line_rec.ship_from_edi_location_code := p0_a223;
3965 ddp_line_rec.ship_from_address_id := rosetta_g_miss_num_map(p0_a224);
3966 ddp_line_rec.sold_to_address_id := rosetta_g_miss_num_map(p0_a225);
3967 ddp_line_rec.ship_to_address_id := rosetta_g_miss_num_map(p0_a226);
3968 ddp_line_rec.invoice_address_id := rosetta_g_miss_num_map(p0_a227);
3969 ddp_line_rec.ship_to_address_code := p0_a228;
3970 ddp_line_rec.original_inventory_item_id := rosetta_g_miss_num_map(p0_a229);
3971 ddp_line_rec.original_item_identifier_type := p0_a230;
3972 ddp_line_rec.original_ordered_item_id := rosetta_g_miss_num_map(p0_a231);
3973 ddp_line_rec.original_ordered_item := p0_a232;
3974 ddp_line_rec.item_substitution_type_code := p0_a233;
3975 ddp_line_rec.late_demand_penalty_factor := rosetta_g_miss_num_map(p0_a234);
3976 ddp_line_rec.override_atp_date_code := p0_a235;
3977 ddp_line_rec.ship_to_customer_id := rosetta_g_miss_num_map(p0_a236);
3978 ddp_line_rec.invoice_to_customer_id := rosetta_g_miss_num_map(p0_a237);
3979 ddp_line_rec.deliver_to_customer_id := rosetta_g_miss_num_map(p0_a238);
3980 ddp_line_rec.accounting_rule_duration := rosetta_g_miss_num_map(p0_a239);
3981 ddp_line_rec.unit_cost := rosetta_g_miss_num_map(p0_a240);
3982 ddp_line_rec.user_item_description := p0_a241;
3983 ddp_line_rec.xml_transaction_type_code := p0_a242;
3984 ddp_line_rec.item_relationship_type := rosetta_g_miss_num_map(p0_a243);
3985 ddp_line_rec.blanket_number := rosetta_g_miss_num_map(p0_a244);
3986 ddp_line_rec.blanket_line_number := rosetta_g_miss_num_map(p0_a245);
3987 ddp_line_rec.blanket_version_number := rosetta_g_miss_num_map(p0_a246);
3988 ddp_line_rec.cso_response_flag := p0_a247;
3989 ddp_line_rec.firm_demand_flag := p0_a248;
3990 ddp_line_rec.earliest_ship_date := rosetta_g_miss_date_in_map(p0_a249);
3991 ddp_line_rec.transaction_phase_code := p0_a250;
3992 ddp_line_rec.source_document_version_number := rosetta_g_miss_num_map(p0_a251);
3993 ddp_line_rec.minisite_id := rosetta_g_miss_num_map(p0_a252);
3994 ddp_line_rec.ib_owner := p0_a253;
3995 ddp_line_rec.ib_installed_at_location := p0_a254;
3996 ddp_line_rec.ib_current_location := p0_a255;
3997 ddp_line_rec.end_customer_id := rosetta_g_miss_num_map(p0_a256);
3998 ddp_line_rec.end_customer_contact_id := rosetta_g_miss_num_map(p0_a257);
3999 ddp_line_rec.end_customer_site_use_id := rosetta_g_miss_num_map(p0_a258);
4000 ddp_line_rec.supplier_signature := p0_a259;
4001 ddp_line_rec.supplier_signature_date := rosetta_g_miss_date_in_map(p0_a260);
4002 ddp_line_rec.customer_signature := p0_a261;
4003 ddp_line_rec.customer_signature_date := rosetta_g_miss_date_in_map(p0_a262);
4004 ddp_line_rec.ship_to_party_id := rosetta_g_miss_num_map(p0_a263);
4005 ddp_line_rec.ship_to_party_site_id := rosetta_g_miss_num_map(p0_a264);
4006 ddp_line_rec.ship_to_party_site_use_id := rosetta_g_miss_num_map(p0_a265);
4007 ddp_line_rec.deliver_to_party_id := rosetta_g_miss_num_map(p0_a266);
4008 ddp_line_rec.deliver_to_party_site_id := rosetta_g_miss_num_map(p0_a267);
4009 ddp_line_rec.deliver_to_party_site_use_id := rosetta_g_miss_num_map(p0_a268);
4010 ddp_line_rec.invoice_to_party_id := rosetta_g_miss_num_map(p0_a269);
4011 ddp_line_rec.invoice_to_party_site_id := rosetta_g_miss_num_map(p0_a270);
4012 ddp_line_rec.invoice_to_party_site_use_id := rosetta_g_miss_num_map(p0_a271);
4013 ddp_line_rec.ship_to_customer_party_id := rosetta_g_miss_num_map(p0_a272);
4014 ddp_line_rec.deliver_to_customer_party_id := rosetta_g_miss_num_map(p0_a273);
4015 ddp_line_rec.invoice_to_customer_party_id := rosetta_g_miss_num_map(p0_a274);
4016 ddp_line_rec.ship_to_org_contact_id := rosetta_g_miss_num_map(p0_a275);
4017 ddp_line_rec.deliver_to_org_contact_id := rosetta_g_miss_num_map(p0_a276);
4018 ddp_line_rec.invoice_to_org_contact_id := rosetta_g_miss_num_map(p0_a277);
4019 ddp_line_rec.retrobill_request_id := rosetta_g_miss_num_map(p0_a278);
4020 ddp_line_rec.original_list_price := rosetta_g_miss_num_map(p0_a279);
4021 ddp_line_rec.commitment_applied_amount := rosetta_g_miss_num_map(p0_a280);
4022
4023
4024
4025
4026
4027 -- here's the delegated call to the old PL/SQL routine
4028 oe_oe_html_line_ext.populate_transient_attributes(ddp_line_rec,
4029 ddx_line_val_rec,
4030 x_return_status,
4031 x_msg_count,
4032 x_msg_data);
4033
4034 -- copy data back from the local variables to OUT or IN-OUT args, if any
4035
4036 p1_a0 := ddx_line_val_rec.accounting_rule;
4037 p1_a1 := ddx_line_val_rec.agreement;
4038 p1_a2 := ddx_line_val_rec.commitment;
4039 p1_a3 := rosetta_g_miss_num_map(ddx_line_val_rec.commitment_applied_amount);
4040 p1_a4 := ddx_line_val_rec.deliver_to_address1;
4041 p1_a5 := ddx_line_val_rec.deliver_to_address2;
4042 p1_a6 := ddx_line_val_rec.deliver_to_address3;
4043 p1_a7 := ddx_line_val_rec.deliver_to_address4;
4044 p1_a8 := ddx_line_val_rec.deliver_to_contact;
4045 p1_a9 := ddx_line_val_rec.deliver_to_location;
4046 p1_a10 := ddx_line_val_rec.deliver_to_org;
4047 p1_a11 := ddx_line_val_rec.deliver_to_state;
4048 p1_a12 := ddx_line_val_rec.deliver_to_city;
4049 p1_a13 := ddx_line_val_rec.deliver_to_zip;
4050 p1_a14 := ddx_line_val_rec.deliver_to_country;
4051 p1_a15 := ddx_line_val_rec.deliver_to_county;
4052 p1_a16 := ddx_line_val_rec.deliver_to_province;
4053 p1_a17 := ddx_line_val_rec.demand_class;
4054 p1_a18 := ddx_line_val_rec.demand_bucket_type;
4055 p1_a19 := ddx_line_val_rec.fob_point;
4056 p1_a20 := ddx_line_val_rec.freight_terms;
4057 p1_a21 := ddx_line_val_rec.inventory_item;
4058 p1_a22 := ddx_line_val_rec.invoice_to_address1;
4059 p1_a23 := ddx_line_val_rec.invoice_to_address2;
4060 p1_a24 := ddx_line_val_rec.invoice_to_address3;
4061 p1_a25 := ddx_line_val_rec.invoice_to_address4;
4062 p1_a26 := ddx_line_val_rec.invoice_to_contact;
4063 p1_a27 := ddx_line_val_rec.invoice_to_location;
4064 p1_a28 := ddx_line_val_rec.invoice_to_org;
4065 p1_a29 := ddx_line_val_rec.invoice_to_state;
4066 p1_a30 := ddx_line_val_rec.invoice_to_city;
4067 p1_a31 := ddx_line_val_rec.invoice_to_zip;
4068 p1_a32 := ddx_line_val_rec.invoice_to_country;
4069 p1_a33 := ddx_line_val_rec.invoice_to_county;
4070 p1_a34 := ddx_line_val_rec.invoice_to_province;
4071 p1_a35 := ddx_line_val_rec.invoicing_rule;
4072 p1_a36 := ddx_line_val_rec.item_type;
4073 p1_a37 := ddx_line_val_rec.line_type;
4074 p1_a38 := ddx_line_val_rec.over_ship_reason;
4075 p1_a39 := ddx_line_val_rec.payment_term;
4076 p1_a40 := ddx_line_val_rec.price_list;
4077 p1_a41 := ddx_line_val_rec.project;
4078 p1_a42 := ddx_line_val_rec.return_reason;
4079 p1_a43 := ddx_line_val_rec.rla_schedule_type;
4080 p1_a44 := ddx_line_val_rec.salesrep;
4081 p1_a45 := ddx_line_val_rec.shipment_priority;
4082 p1_a46 := ddx_line_val_rec.ship_from_address1;
4083 p1_a47 := ddx_line_val_rec.ship_from_address2;
4084 p1_a48 := ddx_line_val_rec.ship_from_address3;
4085 p1_a49 := ddx_line_val_rec.ship_from_address4;
4086 p1_a50 := ddx_line_val_rec.ship_from_location;
4087 p1_a51 := ddx_line_val_rec.ship_from_city;
4088 p1_a52 := ddx_line_val_rec.ship_from_postal_code;
4089 p1_a53 := ddx_line_val_rec.ship_from_country;
4090 p1_a54 := ddx_line_val_rec.ship_from_region1;
4091 p1_a55 := ddx_line_val_rec.ship_from_region2;
4092 p1_a56 := ddx_line_val_rec.ship_from_region3;
4093 p1_a57 := ddx_line_val_rec.ship_from_org;
4094 p1_a58 := ddx_line_val_rec.ship_to_address1;
4095 p1_a59 := ddx_line_val_rec.ship_to_address2;
4096 p1_a60 := ddx_line_val_rec.ship_to_address3;
4097 p1_a61 := ddx_line_val_rec.ship_to_address4;
4098 p1_a62 := ddx_line_val_rec.ship_to_state;
4099 p1_a63 := ddx_line_val_rec.ship_to_country;
4100 p1_a64 := ddx_line_val_rec.ship_to_zip;
4101 p1_a65 := ddx_line_val_rec.ship_to_county;
4102 p1_a66 := ddx_line_val_rec.ship_to_province;
4103 p1_a67 := ddx_line_val_rec.ship_to_city;
4104 p1_a68 := ddx_line_val_rec.ship_to_contact;
4105 p1_a69 := ddx_line_val_rec.ship_to_contact_last_name;
4106 p1_a70 := ddx_line_val_rec.ship_to_contact_first_name;
4107 p1_a71 := ddx_line_val_rec.ship_to_location;
4108 p1_a72 := ddx_line_val_rec.ship_to_org;
4109 p1_a73 := ddx_line_val_rec.source_type;
4110 p1_a74 := ddx_line_val_rec.intermed_ship_to_address1;
4111 p1_a75 := ddx_line_val_rec.intermed_ship_to_address2;
4112 p1_a76 := ddx_line_val_rec.intermed_ship_to_address3;
4113 p1_a77 := ddx_line_val_rec.intermed_ship_to_address4;
4114 p1_a78 := ddx_line_val_rec.intermed_ship_to_contact;
4115 p1_a79 := ddx_line_val_rec.intermed_ship_to_location;
4116 p1_a80 := ddx_line_val_rec.intermed_ship_to_org;
4117 p1_a81 := ddx_line_val_rec.intermed_ship_to_state;
4118 p1_a82 := ddx_line_val_rec.intermed_ship_to_city;
4119 p1_a83 := ddx_line_val_rec.intermed_ship_to_zip;
4120 p1_a84 := ddx_line_val_rec.intermed_ship_to_country;
4121 p1_a85 := ddx_line_val_rec.intermed_ship_to_county;
4122 p1_a86 := ddx_line_val_rec.intermed_ship_to_province;
4123 p1_a87 := ddx_line_val_rec.sold_to_org;
4124 p1_a88 := ddx_line_val_rec.sold_from_org;
4125 p1_a89 := ddx_line_val_rec.task;
4126 p1_a90 := ddx_line_val_rec.tax_exempt;
4127 p1_a91 := ddx_line_val_rec.tax_exempt_reason;
4128 p1_a92 := ddx_line_val_rec.tax_point;
4129 p1_a93 := ddx_line_val_rec.veh_cus_item_cum_key;
4130 p1_a94 := ddx_line_val_rec.visible_demand;
4131 p1_a95 := ddx_line_val_rec.customer_payment_term;
4132 p1_a96 := rosetta_g_miss_num_map(ddx_line_val_rec.ref_order_number);
4133 p1_a97 := rosetta_g_miss_num_map(ddx_line_val_rec.ref_line_number);
4134 p1_a98 := rosetta_g_miss_num_map(ddx_line_val_rec.ref_shipment_number);
4135 p1_a99 := rosetta_g_miss_num_map(ddx_line_val_rec.ref_option_number);
4136 p1_a100 := ddx_line_val_rec.ref_invoice_number;
4137 p1_a101 := rosetta_g_miss_num_map(ddx_line_val_rec.ref_invoice_line_number);
4138 p1_a102 := ddx_line_val_rec.credit_invoice_number;
4139 p1_a103 := ddx_line_val_rec.tax_group;
4140 p1_a104 := ddx_line_val_rec.status;
4141 p1_a105 := ddx_line_val_rec.freight_carrier;
4142 p1_a106 := ddx_line_val_rec.shipping_method;
4143 p1_a107 := ddx_line_val_rec.calculate_price_descr;
4144 p1_a108 := ddx_line_val_rec.ship_to_customer_name;
4145 p1_a109 := ddx_line_val_rec.invoice_to_customer_name;
4146 p1_a110 := ddx_line_val_rec.ship_to_customer_number;
4147 p1_a111 := ddx_line_val_rec.invoice_to_customer_number;
4148 p1_a112 := rosetta_g_miss_num_map(ddx_line_val_rec.ship_to_customer_id);
4149 p1_a113 := rosetta_g_miss_num_map(ddx_line_val_rec.invoice_to_customer_id);
4150 p1_a114 := rosetta_g_miss_num_map(ddx_line_val_rec.deliver_to_customer_id);
4151 p1_a115 := ddx_line_val_rec.deliver_to_customer_number;
4152 p1_a116 := ddx_line_val_rec.deliver_to_customer_name;
4153 p1_a117 := ddx_line_val_rec.original_ordered_item;
4154 p1_a118 := ddx_line_val_rec.original_inventory_item;
4155 p1_a119 := ddx_line_val_rec.original_item_identifier_type;
4156 p1_a120 := ddx_line_val_rec.deliver_to_customer_number_oi;
4157 p1_a121 := ddx_line_val_rec.deliver_to_customer_name_oi;
4158 p1_a122 := ddx_line_val_rec.ship_to_customer_number_oi;
4159 p1_a123 := ddx_line_val_rec.ship_to_customer_name_oi;
4160 p1_a124 := ddx_line_val_rec.invoice_to_customer_number_oi;
4161 p1_a125 := ddx_line_val_rec.invoice_to_customer_name_oi;
4162 p1_a126 := ddx_line_val_rec.item_relationship_type_dsp;
4163 p1_a127 := ddx_line_val_rec.transaction_phase;
4164 p1_a128 := ddx_line_val_rec.end_customer_name;
4165 p1_a129 := ddx_line_val_rec.end_customer_number;
4166 p1_a130 := ddx_line_val_rec.end_customer_contact;
4167 p1_a131 := ddx_line_val_rec.end_cust_contact_last_name;
4168 p1_a132 := ddx_line_val_rec.end_cust_contact_first_name;
4169 p1_a133 := ddx_line_val_rec.end_customer_site_address1;
4170 p1_a134 := ddx_line_val_rec.end_customer_site_address2;
4171 p1_a135 := ddx_line_val_rec.end_customer_site_address3;
4172 p1_a136 := ddx_line_val_rec.end_customer_site_address4;
4173 p1_a137 := ddx_line_val_rec.end_customer_site_location;
4174 p1_a138 := ddx_line_val_rec.end_customer_site_state;
4175 p1_a139 := ddx_line_val_rec.end_customer_site_country;
4176 p1_a140 := ddx_line_val_rec.end_customer_site_zip;
4177 p1_a141 := ddx_line_val_rec.end_customer_site_county;
4178 p1_a142 := ddx_line_val_rec.end_customer_site_province;
4179 p1_a143 := ddx_line_val_rec.end_customer_site_city;
4180 p1_a144 := ddx_line_val_rec.end_customer_site_postal_code;
4181 p1_a145 := ddx_line_val_rec.blanket_agreement_name;
4182 p1_a146 := rosetta_g_miss_num_map(ddx_line_val_rec.extended_price);
4183 p1_a147 := rosetta_g_miss_num_map(ddx_line_val_rec.unit_selling_price);
4184 p1_a148 := rosetta_g_miss_num_map(ddx_line_val_rec.unit_list_price);
4185 p1_a149 := ddx_line_val_rec.line_number;
4186 p1_a150 := ddx_line_val_rec.item_description;
4187
4188
4189
4190 end;
4191
4192 end oe_oe_html_line_ext_w;