[Home] [Help]
PACKAGE BODY: APPS.OE_PRICE_ORDER_PVT_W_OBSOLETE
Source
1 package body oe_price_order_pvt_w_obsolete as
2 /* $Header: OERVPROB.pls 115.2 2004/05/19 21:38:12 lchen 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_p3(t out oe_price_order_pvt.price_att_tbl_type, a0 JTF_NUMBER_TABLE
23 , a1 JTF_NUMBER_TABLE
24 , a2 JTF_VARCHAR2_TABLE_100
25 , a3 JTF_VARCHAR2_TABLE_100
26 , a4 JTF_VARCHAR2_TABLE_100
27 , a5 JTF_VARCHAR2_TABLE_300
28 , a6 JTF_VARCHAR2_TABLE_100
29 ) as
30 ddindx binary_integer; indx binary_integer;
31 begin
32 if a0 is not null and a0.count > 0 then
33 if a0.count > 0 then
34 indx := a0.first;
35 ddindx := 1;
36 while true loop
37 t(ddindx).header_id := rosetta_g_miss_num_map(a0(indx));
38 t(ddindx).line_id := rosetta_g_miss_num_map(a1(indx));
39 t(ddindx).flex_title := a2(indx);
40 t(ddindx).pricing_context := a3(indx);
41 t(ddindx).pricing_attribute := a4(indx);
42 t(ddindx).pricing_attr_value := a5(indx);
43 t(ddindx).override_flag := a6(indx);
44 ddindx := ddindx+1;
45 if a0.last =indx
46 then exit;
47 end if;
48 indx := a0.next(indx);
49 end loop;
50 end if;
51 end if;
52 end rosetta_table_copy_in_p3;
53 procedure rosetta_table_copy_out_p3(t oe_price_order_pvt.price_att_tbl_type, a0 out JTF_NUMBER_TABLE
54 , a1 out JTF_NUMBER_TABLE
55 , a2 out JTF_VARCHAR2_TABLE_100
56 , a3 out JTF_VARCHAR2_TABLE_100
57 , a4 out JTF_VARCHAR2_TABLE_100
58 , a5 out JTF_VARCHAR2_TABLE_300
59 , a6 out JTF_VARCHAR2_TABLE_100
60 ) as
61 ddindx binary_integer; indx binary_integer;
62 begin
63 if t is null or t.count = 0 then
64 a0 := JTF_NUMBER_TABLE();
65 a1 := JTF_NUMBER_TABLE();
66 a2 := JTF_VARCHAR2_TABLE_100();
67 a3 := JTF_VARCHAR2_TABLE_100();
68 a4 := JTF_VARCHAR2_TABLE_100();
69 a5 := JTF_VARCHAR2_TABLE_300();
70 a6 := JTF_VARCHAR2_TABLE_100();
71 else
72 a0 := JTF_NUMBER_TABLE();
73 a1 := JTF_NUMBER_TABLE();
74 a2 := JTF_VARCHAR2_TABLE_100();
75 a3 := JTF_VARCHAR2_TABLE_100();
76 a4 := JTF_VARCHAR2_TABLE_100();
77 a5 := JTF_VARCHAR2_TABLE_300();
78 a6 := JTF_VARCHAR2_TABLE_100();
79 if t.count > 0 then
80 a0.extend(t.count);
81 a1.extend(t.count);
82 a2.extend(t.count);
83 a3.extend(t.count);
84 a4.extend(t.count);
85 a5.extend(t.count);
86 a6.extend(t.count);
87 ddindx := t.first;
88 indx := 1;
89 while true loop
90 a0(indx) := rosetta_g_miss_num_map(t(ddindx).header_id);
91 a1(indx) := rosetta_g_miss_num_map(t(ddindx).line_id);
92 a2(indx) := t(ddindx).flex_title;
93 a3(indx) := t(ddindx).pricing_context;
94 a4(indx) := t(ddindx).pricing_attribute;
95 a5(indx) := t(ddindx).pricing_attr_value;
96 a6(indx) := t(ddindx).override_flag;
97 indx := indx+1;
98 if t.last =ddindx
99 then exit;
100 end if;
101 ddindx := t.next(ddindx);
102 end loop;
103 end if;
104 end if;
105 end rosetta_table_copy_out_p3;
106
107 procedure price_order(p0_a0 in out NUMBER
108 , p0_a1 in out NUMBER
109 , p0_a2 in out VARCHAR2
110 , p0_a3 in out VARCHAR2
111 , p0_a4 in out VARCHAR2
112 , p0_a5 in out VARCHAR2
113 , p0_a6 in out VARCHAR2
114 , p0_a7 in out VARCHAR2
115 , p0_a8 in out VARCHAR2
116 , p0_a9 in out VARCHAR2
117 , p0_a10 in out VARCHAR2
118 , p0_a11 in out VARCHAR2
119 , p0_a12 in out VARCHAR2
120 , p0_a13 in out VARCHAR2
121 , p0_a14 in out VARCHAR2
122 , p0_a15 in out VARCHAR2
123 , p0_a16 in out VARCHAR2
124 , p0_a17 in out VARCHAR2
125 , p0_a18 in out VARCHAR2
126 , p0_a19 in out VARCHAR2
127 , p0_a20 in out VARCHAR2
128 , p0_a21 in out VARCHAR2
129 , p0_a22 in out VARCHAR2
130 , p0_a23 in out VARCHAR2
131 , p0_a24 in out VARCHAR2
132 , p0_a25 in out NUMBER
133 , p0_a26 in out DATE
134 , p0_a27 in out VARCHAR2
135 , p0_a28 in out VARCHAR2
136 , p0_a29 in out NUMBER
137 , p0_a30 in out DATE
138 , p0_a31 in out VARCHAR2
139 , p0_a32 in out NUMBER
140 , p0_a33 in out NUMBER
141 , p0_a34 in out VARCHAR2
142 , p0_a35 in out NUMBER
143 , p0_a36 in out DATE
144 , p0_a37 in out VARCHAR2
145 , p0_a38 in out VARCHAR2
146 , p0_a39 in out VARCHAR2
147 , p0_a40 in out VARCHAR2
148 , p0_a41 in out VARCHAR2
149 , p0_a42 in out VARCHAR2
150 , p0_a43 in out VARCHAR2
151 , p0_a44 in out VARCHAR2
152 , p0_a45 in out VARCHAR2
153 , p0_a46 in out VARCHAR2
154 , p0_a47 in out VARCHAR2
155 , p0_a48 in out VARCHAR2
156 , p0_a49 in out VARCHAR2
157 , p0_a50 in out VARCHAR2
158 , p0_a51 in out VARCHAR2
159 , p0_a52 in out VARCHAR2
160 , p0_a53 in out VARCHAR2
161 , p0_a54 in out VARCHAR2
162 , p0_a55 in out VARCHAR2
163 , p0_a56 in out VARCHAR2
164 , p0_a57 in out VARCHAR2
165 , p0_a58 in out VARCHAR2
166 , p0_a59 in out VARCHAR2
167 , p0_a60 in out VARCHAR2
168 , p0_a61 in out VARCHAR2
169 , p0_a62 in out VARCHAR2
170 , p0_a63 in out VARCHAR2
171 , p0_a64 in out VARCHAR2
172 , p0_a65 in out VARCHAR2
173 , p0_a66 in out VARCHAR2
174 , p0_a67 in out VARCHAR2
175 , p0_a68 in out VARCHAR2
176 , p0_a69 in out VARCHAR2
177 , p0_a70 in out VARCHAR2
178 , p0_a71 in out VARCHAR2
179 , p0_a72 in out VARCHAR2
180 , p0_a73 in out VARCHAR2
181 , p0_a74 in out VARCHAR2
182 , p0_a75 in out VARCHAR2
183 , p0_a76 in out VARCHAR2
184 , p0_a77 in out NUMBER
185 , p0_a78 in out NUMBER
186 , p0_a79 in out NUMBER
187 , p0_a80 in out NUMBER
188 , p0_a81 in out NUMBER
189 , p0_a82 in out DATE
190 , p0_a83 in out NUMBER
191 , p0_a84 in out NUMBER
192 , p0_a85 in out VARCHAR2
193 , p0_a86 in out VARCHAR2
194 , p0_a87 in out DATE
195 , p0_a88 in out VARCHAR2
196 , p0_a89 in out NUMBER
197 , p0_a90 in out NUMBER
198 , p0_a91 in out NUMBER
199 , p0_a92 in out NUMBER
200 , p0_a93 in out VARCHAR2
201 , p0_a94 in out VARCHAR2
202 , p0_a95 in out NUMBER
203 , p0_a96 in out NUMBER
204 , p0_a97 in out VARCHAR2
205 , p0_a98 in out DATE
206 , p0_a99 in out NUMBER
207 , p0_a100 in out NUMBER
208 , p0_a101 in out DATE
209 , p0_a102 in out DATE
210 , p0_a103 in out NUMBER
211 , p0_a104 in out VARCHAR2
212 , p0_a105 in out NUMBER
213 , p0_a106 in out VARCHAR2
214 , p0_a107 in out VARCHAR2
215 , p0_a108 in out VARCHAR2
216 , p0_a109 in out NUMBER
217 , p0_a110 in out NUMBER
218 , p0_a111 in out NUMBER
219 , p0_a112 in out NUMBER
220 , p0_a113 in out NUMBER
221 , p0_a114 in out NUMBER
222 , p0_a115 in out NUMBER
223 , p0_a116 in out NUMBER
224 , p0_a117 in out NUMBER
225 , p0_a118 in out NUMBER
226 , p0_a119 in out NUMBER
227 , p0_a120 in out VARCHAR2
228 , p0_a121 in out VARCHAR2
229 , p0_a122 in out VARCHAR2
230 , p0_a123 in out VARCHAR2
231 , p0_a124 in out VARCHAR2
232 , p0_a125 in out NUMBER
233 , p0_a126 in out VARCHAR2
234 , p0_a127 in out VARCHAR2
235 , p0_a128 in out VARCHAR2
236 , p0_a129 in out VARCHAR2
237 , p0_a130 in out DATE
238 , p0_a131 in out VARCHAR2
239 , p0_a132 in out DATE
240 , p0_a133 in out VARCHAR2
241 , p0_a134 in out VARCHAR2
242 , p0_a135 in out VARCHAR2
243 , p0_a136 in out VARCHAR2
244 , p0_a137 in out VARCHAR2
245 , p0_a138 in out VARCHAR2
246 , p0_a139 in out VARCHAR2
247 , p0_a140 in out VARCHAR2
248 , p0_a141 in out NUMBER
249 , p0_a142 in out VARCHAR2
250 , p0_a143 in out NUMBER
251 , p0_a144 in out VARCHAR2
252 , p0_a145 in out VARCHAR2
253 , p0_a146 in out VARCHAR2
254 , p0_a147 in out VARCHAR2
255 , p0_a148 in out DATE
256 , p0_a149 in out VARCHAR2
257 , p0_a150 in out DATE
258 , p0_a151 in out VARCHAR2
259 , p0_a152 in out VARCHAR2
260 , p0_a153 in out VARCHAR2
261 , p0_a154 in out DATE
262 , p0_a155 in out NUMBER
263 , p0_a156 in out VARCHAR2
264 , p0_a157 in out NUMBER
265 , p0_a158 in out VARCHAR2
266 , p0_a159 in out VARCHAR2
267 , p0_a160 in out VARCHAR2
268 , p0_a161 in out VARCHAR2
269 , p0_a162 in out NUMBER
270 , p0_a163 in out NUMBER
271 , p0_a164 in out NUMBER
272 , p0_a165 in out NUMBER
273 , p0_a166 in out VARCHAR2
274 , p0_a167 in out NUMBER
275 , p0_a168 in out NUMBER
276 , p0_a169 in out NUMBER
277 , p0_a170 in out NUMBER
278 , p0_a171 in out NUMBER
279 , p0_a172 in out VARCHAR2
280 , p0_a173 in out NUMBER
281 , p0_a174 in out VARCHAR2
282 , p0_a175 in out VARCHAR2
283 , p0_a176 in out VARCHAR2
284 , p0_a177 in out DATE
285 , p0_a178 in out NUMBER
286 , p0_a179 in out VARCHAR2
287 , p0_a180 in out VARCHAR2
288 , p0_a181 in out VARCHAR2
289 , p0_a182 in out VARCHAR2
290 , p0_a183 in out NUMBER
291 , p0_a184 in out NUMBER
292 , p0_a185 in out NUMBER
293 , p0_a186 in out VARCHAR2
294 , p0_a187 in out VARCHAR2
295 , p0_a188 in out VARCHAR2
296 , p0_a189 in out NUMBER
297 , p0_a190 in out NUMBER
298 , p0_a191 in out NUMBER
299 , p0_a192 in out VARCHAR2
300 , p0_a193 in out DATE
301 , p0_a194 in out VARCHAR2
302 , p0_a195 in out DATE
303 , p0_a196 in out NUMBER
304 , p0_a197 in out NUMBER
305 , p0_a198 in out NUMBER
306 , p0_a199 in out NUMBER
307 , p0_a200 in out NUMBER
308 , p0_a201 in out NUMBER
309 , p0_a202 in out NUMBER
310 , p0_a203 in out NUMBER
311 , p0_a204 in out NUMBER
312 , p0_a205 in out NUMBER
313 , p0_a206 in out NUMBER
314 , p0_a207 in out NUMBER
315 , p0_a208 in out NUMBER
316 , p0_a209 in out NUMBER
317 , p0_a210 in out NUMBER
318 , p0_a211 in out NUMBER
319 , p0_a212 in out NUMBER
320 , p0_a213 in out NUMBER
321 , p0_a214 in out VARCHAR2
322 , p0_a215 in out NUMBER
323 , p1_a0 in out NUMBER
324 , p1_a1 in out DATE
325 , p1_a2 in out DATE
326 , p1_a3 in out NUMBER
327 , p1_a4 in out NUMBER
328 , p1_a5 in out NUMBER
329 , p1_a6 in out VARCHAR2
330 , p1_a7 in out NUMBER
331 , p1_a8 in out VARCHAR2
332 , p1_a9 in out VARCHAR2
333 , p1_a10 in out NUMBER
334 , p1_a11 in out NUMBER
335 , p1_a12 in out NUMBER
336 , p1_a13 in out VARCHAR2
337 , p1_a14 in out NUMBER
338 , p1_a15 in out NUMBER
339 , p1_a16 in out NUMBER
340 , p1_a17 in out NUMBER
341 , p1_a18 in out NUMBER
342 , p1_a19 in out NUMBER
343 , p1_a20 in out VARCHAR2
344 , p1_a21 in out NUMBER
345 , p1_a22 in out DATE
346 , p1_a23 in out NUMBER
347 , p1_a24 in out VARCHAR2
348 , p1_a25 in out VARCHAR2
349 , p1_a26 in out VARCHAR2
350 , p1_a27 in out NUMBER
351 , p1_a28 in out VARCHAR2
352 , p1_a29 in out VARCHAR2
353 , p1_a30 in out VARCHAR2
354 , p1_a31 in out NUMBER
355 , p1_a32 in out NUMBER
356 , p1_a33 in out NUMBER
357 , p1_a34 in out VARCHAR2
358 , p1_a35 in out VARCHAR2
359 , p1_a36 in out VARCHAR2
360 , p1_a37 in out DATE
361 , p1_a38 in out VARCHAR2
362 , p1_a39 in out DATE
363 , p1_a40 in out VARCHAR2
364 , p1_a41 in out VARCHAR2
365 , p1_a42 in out VARCHAR2
366 , p1_a43 in out NUMBER
367 , p1_a44 in out NUMBER
368 , p1_a45 in out NUMBER
369 , p1_a46 in out NUMBER
370 , p1_a47 in out NUMBER
371 , p1_a48 in out NUMBER
372 , p1_a49 in out VARCHAR2
373 , p1_a50 in out NUMBER
374 , p1_a51 in out NUMBER
375 , p1_a52 in out NUMBER
376 , p1_a53 in out VARCHAR2
377 , p1_a54 in out VARCHAR2
378 , p1_a55 in out VARCHAR2
379 , p1_a56 in out NUMBER
380 , p1_a57 in out DATE
381 , p1_a58 in out NUMBER
382 , p1_a59 in out DATE
383 , p1_a60 in out VARCHAR2
384 , p1_a61 in out NUMBER
385 , p1_a62 in out NUMBER
386 , p1_a63 in out NUMBER
387 , p1_a64 in out VARCHAR2
388 , p1_a65 in out NUMBER
389 , p1_a66 in out NUMBER
390 , p1_a67 in out NUMBER
391 , p1_a68 in out NUMBER
392 , p1_a69 in out NUMBER
393 , p1_a70 in out VARCHAR2
394 , p1_a71 in out VARCHAR2
395 , p1_a72 in out NUMBER
396 , p1_a73 in out NUMBER
397 , p1_a74 in out NUMBER
398 , p1_a75 in out VARCHAR2
399 , p1_a76 in out VARCHAR2
400 , p1_a77 in out NUMBER
401 , p1_a78 in out VARCHAR2
402 , p1_a79 in out VARCHAR2
403 , p1_a80 in out VARCHAR2
404 , p1_a81 in out VARCHAR2
405 , p1_a82 in out NUMBER
406 , p1_a83 in out NUMBER
407 , p1_a84 in out VARCHAR2
408 , p1_a85 in out NUMBER
409 , p1_a86 in out VARCHAR2
410 , p1_a87 in out DATE
411 , p1_a88 in out NUMBER
412 , p1_a89 in out VARCHAR2
413 , p1_a90 in out NUMBER
414 , p1_a91 in out NUMBER
415 , p1_a92 in out DATE
416 , p1_a93 in out NUMBER
417 , p1_a94 in out DATE
418 , p1_a95 in out VARCHAR2
419 , p1_a96 in out NUMBER
420 , p1_a97 in out NUMBER
421 , p1_a98 in out NUMBER
422 , p1_a99 in out VARCHAR2
423 , p1_a100 in out DATE
424 , p1_a101 in out NUMBER
425 , p1_a102 in out NUMBER
426 , p1_a103 in out VARCHAR2
427 , p1_a104 in out VARCHAR2
428 , p1_a105 in out NUMBER
429 , p1_a106 in out DATE
430 , p1_a107 in out DATE
431 , p1_a108 in out VARCHAR2
432 , p1_a109 in out VARCHAR2
433 , p1_a110 in out NUMBER
434 , p1_a111 in out VARCHAR2
435 , p1_a112 in out NUMBER
436 , p1_a113 in out NUMBER
437 , p1_a114 in out VARCHAR2
438 , p1_a115 in out VARCHAR2
439 , p1_a116 in out NUMBER
440 , p1_a117 in out NUMBER
441 , p1_a118 in out VARCHAR2
442 , p1_a119 in out VARCHAR2
443 , p1_a120 in out NUMBER
444 , p1_a121 in out VARCHAR2
445 , p1_a122 in out NUMBER
446 , p1_a123 in out NUMBER
447 , p1_a124 in out NUMBER
448 , p1_a125 in out NUMBER
449 , p1_a126 in out NUMBER
450 , p1_a127 in out NUMBER
451 , p1_a128 in out NUMBER
452 , p1_a129 in out NUMBER
453 , p1_a130 in out VARCHAR2
454 , p1_a131 in out NUMBER
455 , p1_a132 in out NUMBER
456 , p1_a133 in out NUMBER
457 , p1_a134 in out VARCHAR2
458 , p1_a135 in out NUMBER
459 , p1_a136 in out NUMBER
460 , p1_a137 in out VARCHAR2
461 , p1_a138 in out DATE
462 , p1_a139 in out VARCHAR2
463 , p1_a140 in out VARCHAR2
464 , p1_a141 in out VARCHAR2
465 , p1_a142 in out VARCHAR2
466 , p1_a143 in out NUMBER
467 , p1_a144 in out NUMBER
468 , p1_a145 in out VARCHAR2
469 , p1_a146 in out NUMBER
470 , p1_a147 in out NUMBER
471 , p1_a148 in out NUMBER
472 , p1_a149 in out NUMBER
473 , p1_a150 in out NUMBER
474 , p1_a151 in out NUMBER
475 , p1_a152 in out NUMBER
476 , p1_a153 in out VARCHAR2
477 , p1_a154 in out VARCHAR2
478 , p1_a155 in out VARCHAR2
479 , p1_a156 in out VARCHAR2
480 , p1_a157 in out VARCHAR2
481 , p1_a158 in out DATE
482 , p1_a159 in out VARCHAR2
483 , p1_a160 in out DATE
484 , p1_a161 in out VARCHAR2
485 , p1_a162 in out VARCHAR2
486 , p1_a163 in out VARCHAR2
487 , p1_a164 in out VARCHAR2
488 , p1_a165 in out VARCHAR2
489 , p1_a166 in out NUMBER
490 , p1_a167 in out VARCHAR2
491 , p1_a168 in out VARCHAR2
492 , p1_a169 in out VARCHAR2
493 , p1_a170 in out VARCHAR2
494 , p1_a171 in out VARCHAR2
495 , p1_a172 in out VARCHAR2
496 , p1_a173 in out VARCHAR2
497 , p1_a174 in out NUMBER
498 , p1_a175 in out NUMBER
499 , p1_a176 in out NUMBER
500 , p1_a177 in out VARCHAR2
501 , p1_a178 in out VARCHAR2
502 , p1_a179 in out VARCHAR2
503 , p1_a180 in out VARCHAR2
504 , p1_a181 in out NUMBER
505 , p1_a182 in out VARCHAR2
506 , p1_a183 in out VARCHAR2
507 , p1_a184 in out NUMBER
508 , p1_a185 in out VARCHAR2
509 , p1_a186 in out DATE
510 , p1_a187 in out DATE
511 , p1_a188 in out VARCHAR2
512 , p1_a189 in out NUMBER
513 , p1_a190 in out NUMBER
514 , p1_a191 in out NUMBER
515 , p1_a192 in out NUMBER
516 , p1_a193 in out VARCHAR2
517 , p1_a194 in out NUMBER
518 , p1_a195 in out NUMBER
519 , p1_a196 in out NUMBER
520 , p1_a197 in out NUMBER
521 , p1_a198 in out VARCHAR2
522 , p1_a199 in out VARCHAR2
523 , p1_a200 in out VARCHAR2
524 , p1_a201 in out NUMBER
525 , p1_a202 in out NUMBER
526 , p1_a203 in out NUMBER
527 , p1_a204 in out NUMBER
528 , p1_a205 in out VARCHAR2
529 , p1_a206 in out VARCHAR2
530 , p1_a207 in out VARCHAR2
531 , p1_a208 in out VARCHAR2
532 , p1_a209 in out VARCHAR2
533 , p1_a210 in out VARCHAR2
534 , p1_a211 in out VARCHAR2
535 , p1_a212 in out NUMBER
536 , p1_a213 in out NUMBER
537 , p1_a214 in out DATE
538 , p1_a215 in out NUMBER
539 , p1_a216 in out VARCHAR2
540 , p1_a217 in out NUMBER
541 , p1_a218 in out VARCHAR2
542 , p1_a219 in out VARCHAR2
543 , p1_a220 in out VARCHAR2
544 , p1_a221 in out VARCHAR2
545 , p1_a222 in out VARCHAR2
546 , p1_a223 in out VARCHAR2
547 , p1_a224 in out NUMBER
548 , p1_a225 in out NUMBER
549 , p1_a226 in out NUMBER
550 , p1_a227 in out NUMBER
551 , p1_a228 in out VARCHAR2
552 , p1_a229 in out NUMBER
553 , p1_a230 in out VARCHAR2
554 , p1_a231 in out NUMBER
555 , p1_a232 in out VARCHAR2
556 , p1_a233 in out VARCHAR2
557 , p1_a234 in out NUMBER
558 , p1_a235 in out VARCHAR2
559 , p1_a236 in out NUMBER
560 , p1_a237 in out NUMBER
561 , p1_a238 in out NUMBER
562 , p1_a239 in out NUMBER
563 , p1_a240 in out NUMBER
564 , p1_a241 in out VARCHAR2
565 , p1_a242 in out VARCHAR2
566 , p1_a243 in out NUMBER
567 , p1_a244 in out NUMBER
568 , p1_a245 in out NUMBER
569 , p1_a246 in out NUMBER
570 , p1_a247 in out VARCHAR2
571 , p1_a248 in out VARCHAR2
572 , p1_a249 in out DATE
573 , p1_a250 in out VARCHAR2
574 , p1_a251 in out NUMBER
575 , p1_a252 in out NUMBER
576 , p1_a253 in out VARCHAR2
577 , p1_a254 in out VARCHAR2
578 , p1_a255 in out VARCHAR2
579 , p1_a256 in out NUMBER
580 , p1_a257 in out NUMBER
581 , p1_a258 in out NUMBER
582 , p1_a259 in out VARCHAR2
583 , p1_a260 in out DATE
584 , p1_a261 in out VARCHAR2
585 , p1_a262 in out DATE
586 , p1_a263 in out NUMBER
587 , p1_a264 in out NUMBER
588 , p1_a265 in out NUMBER
589 , p1_a266 in out NUMBER
590 , p1_a267 in out NUMBER
591 , p1_a268 in out NUMBER
592 , p1_a269 in out NUMBER
593 , p1_a270 in out NUMBER
594 , p1_a271 in out NUMBER
595 , p1_a272 in out NUMBER
596 , p1_a273 in out NUMBER
597 , p1_a274 in out NUMBER
598 , p1_a275 in out NUMBER
599 , p1_a276 in out NUMBER
600 , p1_a277 in out NUMBER
601 , p1_a278 in out NUMBER
602 , p1_a279 in out NUMBER
603 , p1_a280 in out NUMBER
604 , p2_a0 in out JTF_VARCHAR2_TABLE_300
605 , p2_a1 in out JTF_VARCHAR2_TABLE_300
606 , p2_a2 in out JTF_VARCHAR2_TABLE_300
607 , p2_a3 in out JTF_VARCHAR2_TABLE_300
608 , p2_a4 in out JTF_VARCHAR2_TABLE_300
609 , p2_a5 in out JTF_VARCHAR2_TABLE_300
610 , p2_a6 in out JTF_VARCHAR2_TABLE_300
611 , p2_a7 in out JTF_VARCHAR2_TABLE_300
612 , p2_a8 in out JTF_VARCHAR2_TABLE_300
613 , p2_a9 in out JTF_VARCHAR2_TABLE_300
614 , p2_a10 in out JTF_VARCHAR2_TABLE_300
615 , p2_a11 in out JTF_VARCHAR2_TABLE_300
616 , p2_a12 in out JTF_VARCHAR2_TABLE_300
617 , p2_a13 in out JTF_VARCHAR2_TABLE_300
618 , p2_a14 in out JTF_VARCHAR2_TABLE_300
619 , p2_a15 in out JTF_VARCHAR2_TABLE_100
620 , p2_a16 in out JTF_VARCHAR2_TABLE_100
621 , p2_a17 in out JTF_NUMBER_TABLE
622 , p2_a18 in out JTF_DATE_TABLE
623 , p2_a19 in out JTF_NUMBER_TABLE
624 , p2_a20 in out JTF_NUMBER_TABLE
625 , p2_a21 in out JTF_NUMBER_TABLE
626 , p2_a22 in out JTF_NUMBER_TABLE
627 , p2_a23 in out JTF_DATE_TABLE
628 , p2_a24 in out JTF_NUMBER_TABLE
629 , p2_a25 in out JTF_NUMBER_TABLE
630 , p2_a26 in out JTF_NUMBER_TABLE
631 , p2_a27 in out JTF_NUMBER_TABLE
632 , p2_a28 in out JTF_NUMBER_TABLE
633 , p2_a29 in out JTF_NUMBER_TABLE
634 , p2_a30 in out JTF_DATE_TABLE
635 , p2_a31 in out JTF_NUMBER_TABLE
636 , p2_a32 in out JTF_VARCHAR2_TABLE_100
637 , p2_a33 in out JTF_VARCHAR2_TABLE_100
638 , p2_a34 in out JTF_VARCHAR2_TABLE_100
639 , p2_a35 in out JTF_NUMBER_TABLE
640 , p2_a36 in out JTF_VARCHAR2_TABLE_100
641 , p2_a37 in out JTF_VARCHAR2_TABLE_100
642 , p2_a38 in out JTF_VARCHAR2_TABLE_100
643 , p2_a39 in out JTF_NUMBER_TABLE
644 , p2_a40 in out JTF_NUMBER_TABLE
645 , p2_a41 in out JTF_VARCHAR2_TABLE_100
646 , p2_a42 in out JTF_VARCHAR2_TABLE_100
647 , p2_a43 in out JTF_VARCHAR2_TABLE_300
648 , p2_a44 in out JTF_VARCHAR2_TABLE_300
649 , p2_a45 in out JTF_VARCHAR2_TABLE_100
650 , p2_a46 in out JTF_VARCHAR2_TABLE_100
651 , p2_a47 in out JTF_VARCHAR2_TABLE_100
652 , p2_a48 in out JTF_VARCHAR2_TABLE_100
653 , p2_a49 in out JTF_VARCHAR2_TABLE_2000
654 , p2_a50 in out JTF_NUMBER_TABLE
655 , p2_a51 in out JTF_NUMBER_TABLE
656 , p2_a52 in out JTF_VARCHAR2_TABLE_100
657 , p2_a53 in out JTF_NUMBER_TABLE
658 , p2_a54 in out JTF_VARCHAR2_TABLE_100
659 , p2_a55 in out JTF_VARCHAR2_TABLE_100
660 , p2_a56 in out JTF_VARCHAR2_TABLE_100
661 , p2_a57 in out JTF_VARCHAR2_TABLE_100
662 , p2_a58 in out JTF_NUMBER_TABLE
663 , p2_a59 in out JTF_VARCHAR2_TABLE_100
664 , p2_a60 in out JTF_VARCHAR2_TABLE_100
665 , p2_a61 in out JTF_VARCHAR2_TABLE_100
666 , p2_a62 in out JTF_VARCHAR2_TABLE_100
667 , p2_a63 in out JTF_NUMBER_TABLE
668 , p2_a64 in out JTF_NUMBER_TABLE
669 , p2_a65 in out JTF_NUMBER_TABLE
670 , p2_a66 in out JTF_VARCHAR2_TABLE_100
671 , p2_a67 in out JTF_VARCHAR2_TABLE_100
672 , p2_a68 in out JTF_VARCHAR2_TABLE_300
673 , p2_a69 in out JTF_VARCHAR2_TABLE_100
674 , p2_a70 in out JTF_NUMBER_TABLE
675 , p2_a71 in out JTF_VARCHAR2_TABLE_100
676 , p2_a72 in out JTF_VARCHAR2_TABLE_100
677 , p2_a73 in out JTF_DATE_TABLE
678 , p2_a74 in out JTF_VARCHAR2_TABLE_100
679 , p2_a75 in out JTF_VARCHAR2_TABLE_100
680 , p2_a76 in out JTF_VARCHAR2_TABLE_100
681 , p2_a77 in out JTF_DATE_TABLE
682 , p2_a78 in out JTF_VARCHAR2_TABLE_100
683 , p2_a79 in out JTF_VARCHAR2_TABLE_100
684 , p2_a80 in out JTF_NUMBER_TABLE
685 , p2_a81 in out JTF_NUMBER_TABLE
686 , p2_a82 in out JTF_NUMBER_TABLE
687 , p2_a83 in out JTF_VARCHAR2_TABLE_100
688 , p2_a84 in out JTF_VARCHAR2_TABLE_100
689 , p2_a85 in out JTF_VARCHAR2_TABLE_100
690 , p2_a86 in out JTF_VARCHAR2_TABLE_100
691 , p2_a87 in out JTF_VARCHAR2_TABLE_100
692 , p2_a88 in out JTF_VARCHAR2_TABLE_100
693 , p2_a89 in out JTF_VARCHAR2_TABLE_300
694 , p2_a90 in out JTF_VARCHAR2_TABLE_300
695 , p2_a91 in out JTF_VARCHAR2_TABLE_300
696 , p2_a92 in out JTF_VARCHAR2_TABLE_300
697 , p2_a93 in out JTF_VARCHAR2_TABLE_300
698 , p2_a94 in out JTF_VARCHAR2_TABLE_300
699 , p2_a95 in out JTF_VARCHAR2_TABLE_300
700 , p2_a96 in out JTF_VARCHAR2_TABLE_300
701 , p2_a97 in out JTF_VARCHAR2_TABLE_300
702 , p2_a98 in out JTF_VARCHAR2_TABLE_300
703 , p2_a99 in out JTF_VARCHAR2_TABLE_300
704 , p2_a100 in out JTF_VARCHAR2_TABLE_300
705 , p2_a101 in out JTF_VARCHAR2_TABLE_300
706 , p2_a102 in out JTF_VARCHAR2_TABLE_300
707 , p2_a103 in out JTF_VARCHAR2_TABLE_300
708 , p2_a104 in out JTF_VARCHAR2_TABLE_200
709 , p2_a105 in out JTF_NUMBER_TABLE
710 , p2_a106 in out JTF_NUMBER_TABLE
711 , p2_a107 in out JTF_NUMBER_TABLE
712 , p2_a108 in out JTF_NUMBER_TABLE
713 , p3_a0 JTF_NUMBER_TABLE
714 , p3_a1 JTF_NUMBER_TABLE
715 , p3_a2 JTF_VARCHAR2_TABLE_100
716 , p3_a3 JTF_VARCHAR2_TABLE_100
717 , p3_a4 JTF_VARCHAR2_TABLE_100
718 , p3_a5 JTF_VARCHAR2_TABLE_300
719 , p3_a6 JTF_VARCHAR2_TABLE_100
720 , p_action_code VARCHAR2
721 , p_pricing_events VARCHAR2
722 , p_simulation_flag VARCHAR2
723 , p_get_freight_flag VARCHAR2
724 , x_return_status out VARCHAR2
725 )
726
727 as
728 ddpx_header_rec oe_order_pub.header_rec_type;
729 ddpx_line_rec oe_order_pub.line_rec_type;
730 ddpx_line_adj_tbl oe_order_pub.line_adj_tbl_type;
731 ddp_line_price_att_tbl oe_price_order_pvt.price_att_tbl_type;
732 ddindx binary_integer; indx binary_integer;
733 begin
734
735 -- copy data to the local IN or IN-OUT args, if any
736 ddpx_header_rec.accounting_rule_id := rosetta_g_miss_num_map(p0_a0);
737 ddpx_header_rec.agreement_id := rosetta_g_miss_num_map(p0_a1);
738 ddpx_header_rec.attribute1 := p0_a2;
739 ddpx_header_rec.attribute10 := p0_a3;
740 ddpx_header_rec.attribute11 := p0_a4;
741 ddpx_header_rec.attribute12 := p0_a5;
742 ddpx_header_rec.attribute13 := p0_a6;
743 ddpx_header_rec.attribute14 := p0_a7;
744 ddpx_header_rec.attribute15 := p0_a8;
745 ddpx_header_rec.attribute16 := p0_a9;
746 ddpx_header_rec.attribute17 := p0_a10;
747 ddpx_header_rec.attribute18 := p0_a11;
748 ddpx_header_rec.attribute19 := p0_a12;
749 ddpx_header_rec.attribute2 := p0_a13;
750 ddpx_header_rec.attribute20 := p0_a14;
751 ddpx_header_rec.attribute3 := p0_a15;
752 ddpx_header_rec.attribute4 := p0_a16;
753 ddpx_header_rec.attribute5 := p0_a17;
754 ddpx_header_rec.attribute6 := p0_a18;
755 ddpx_header_rec.attribute7 := p0_a19;
756 ddpx_header_rec.attribute8 := p0_a20;
757 ddpx_header_rec.attribute9 := p0_a21;
758 ddpx_header_rec.booked_flag := p0_a22;
759 ddpx_header_rec.cancelled_flag := p0_a23;
760 ddpx_header_rec.context := p0_a24;
761 ddpx_header_rec.conversion_rate := rosetta_g_miss_num_map(p0_a25);
762 ddpx_header_rec.conversion_rate_date := rosetta_g_miss_date_in_map(p0_a26);
763 ddpx_header_rec.conversion_type_code := p0_a27;
764 ddpx_header_rec.customer_preference_set_code := p0_a28;
765 ddpx_header_rec.created_by := rosetta_g_miss_num_map(p0_a29);
766 ddpx_header_rec.creation_date := rosetta_g_miss_date_in_map(p0_a30);
767 ddpx_header_rec.cust_po_number := p0_a31;
768 ddpx_header_rec.deliver_to_contact_id := rosetta_g_miss_num_map(p0_a32);
769 ddpx_header_rec.deliver_to_org_id := rosetta_g_miss_num_map(p0_a33);
770 ddpx_header_rec.demand_class_code := p0_a34;
771 ddpx_header_rec.earliest_schedule_limit := rosetta_g_miss_num_map(p0_a35);
772 ddpx_header_rec.expiration_date := rosetta_g_miss_date_in_map(p0_a36);
773 ddpx_header_rec.fob_point_code := p0_a37;
774 ddpx_header_rec.freight_carrier_code := p0_a38;
775 ddpx_header_rec.freight_terms_code := p0_a39;
776 ddpx_header_rec.global_attribute1 := p0_a40;
777 ddpx_header_rec.global_attribute10 := p0_a41;
778 ddpx_header_rec.global_attribute11 := p0_a42;
779 ddpx_header_rec.global_attribute12 := p0_a43;
780 ddpx_header_rec.global_attribute13 := p0_a44;
781 ddpx_header_rec.global_attribute14 := p0_a45;
782 ddpx_header_rec.global_attribute15 := p0_a46;
783 ddpx_header_rec.global_attribute16 := p0_a47;
784 ddpx_header_rec.global_attribute17 := p0_a48;
785 ddpx_header_rec.global_attribute18 := p0_a49;
786 ddpx_header_rec.global_attribute19 := p0_a50;
787 ddpx_header_rec.global_attribute2 := p0_a51;
788 ddpx_header_rec.global_attribute20 := p0_a52;
789 ddpx_header_rec.global_attribute3 := p0_a53;
790 ddpx_header_rec.global_attribute4 := p0_a54;
791 ddpx_header_rec.global_attribute5 := p0_a55;
792 ddpx_header_rec.global_attribute6 := p0_a56;
793 ddpx_header_rec.global_attribute7 := p0_a57;
794 ddpx_header_rec.global_attribute8 := p0_a58;
795 ddpx_header_rec.global_attribute9 := p0_a59;
796 ddpx_header_rec.global_attribute_category := p0_a60;
797 ddpx_header_rec.tp_context := p0_a61;
798 ddpx_header_rec.tp_attribute1 := p0_a62;
799 ddpx_header_rec.tp_attribute2 := p0_a63;
800 ddpx_header_rec.tp_attribute3 := p0_a64;
801 ddpx_header_rec.tp_attribute4 := p0_a65;
802 ddpx_header_rec.tp_attribute5 := p0_a66;
803 ddpx_header_rec.tp_attribute6 := p0_a67;
804 ddpx_header_rec.tp_attribute7 := p0_a68;
805 ddpx_header_rec.tp_attribute8 := p0_a69;
806 ddpx_header_rec.tp_attribute9 := p0_a70;
807 ddpx_header_rec.tp_attribute10 := p0_a71;
808 ddpx_header_rec.tp_attribute11 := p0_a72;
809 ddpx_header_rec.tp_attribute12 := p0_a73;
810 ddpx_header_rec.tp_attribute13 := p0_a74;
811 ddpx_header_rec.tp_attribute14 := p0_a75;
812 ddpx_header_rec.tp_attribute15 := p0_a76;
813 ddpx_header_rec.header_id := rosetta_g_miss_num_map(p0_a77);
814 ddpx_header_rec.invoice_to_contact_id := rosetta_g_miss_num_map(p0_a78);
815 ddpx_header_rec.invoice_to_org_id := rosetta_g_miss_num_map(p0_a79);
816 ddpx_header_rec.invoicing_rule_id := rosetta_g_miss_num_map(p0_a80);
817 ddpx_header_rec.last_updated_by := rosetta_g_miss_num_map(p0_a81);
818 ddpx_header_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a82);
819 ddpx_header_rec.last_update_login := rosetta_g_miss_num_map(p0_a83);
820 ddpx_header_rec.latest_schedule_limit := rosetta_g_miss_num_map(p0_a84);
821 ddpx_header_rec.open_flag := p0_a85;
822 ddpx_header_rec.order_category_code := p0_a86;
823 ddpx_header_rec.ordered_date := rosetta_g_miss_date_in_map(p0_a87);
824 ddpx_header_rec.order_date_type_code := p0_a88;
825 ddpx_header_rec.order_number := rosetta_g_miss_num_map(p0_a89);
826 ddpx_header_rec.order_source_id := rosetta_g_miss_num_map(p0_a90);
827 ddpx_header_rec.order_type_id := rosetta_g_miss_num_map(p0_a91);
828 ddpx_header_rec.org_id := rosetta_g_miss_num_map(p0_a92);
829 ddpx_header_rec.orig_sys_document_ref := p0_a93;
830 ddpx_header_rec.partial_shipments_allowed := p0_a94;
831 ddpx_header_rec.payment_term_id := rosetta_g_miss_num_map(p0_a95);
832 ddpx_header_rec.price_list_id := rosetta_g_miss_num_map(p0_a96);
833 ddpx_header_rec.price_request_code := p0_a97;
834 ddpx_header_rec.pricing_date := rosetta_g_miss_date_in_map(p0_a98);
835 ddpx_header_rec.program_application_id := rosetta_g_miss_num_map(p0_a99);
836 ddpx_header_rec.program_id := rosetta_g_miss_num_map(p0_a100);
837 ddpx_header_rec.program_update_date := rosetta_g_miss_date_in_map(p0_a101);
838 ddpx_header_rec.request_date := rosetta_g_miss_date_in_map(p0_a102);
839 ddpx_header_rec.request_id := rosetta_g_miss_num_map(p0_a103);
840 ddpx_header_rec.return_reason_code := p0_a104;
841 ddpx_header_rec.salesrep_id := rosetta_g_miss_num_map(p0_a105);
842 ddpx_header_rec.sales_channel_code := p0_a106;
843 ddpx_header_rec.shipment_priority_code := p0_a107;
844 ddpx_header_rec.shipping_method_code := p0_a108;
845 ddpx_header_rec.ship_from_org_id := rosetta_g_miss_num_map(p0_a109);
846 ddpx_header_rec.ship_tolerance_above := rosetta_g_miss_num_map(p0_a110);
847 ddpx_header_rec.ship_tolerance_below := rosetta_g_miss_num_map(p0_a111);
848 ddpx_header_rec.ship_to_contact_id := rosetta_g_miss_num_map(p0_a112);
849 ddpx_header_rec.ship_to_org_id := rosetta_g_miss_num_map(p0_a113);
850 ddpx_header_rec.sold_from_org_id := rosetta_g_miss_num_map(p0_a114);
851 ddpx_header_rec.sold_to_contact_id := rosetta_g_miss_num_map(p0_a115);
852 ddpx_header_rec.sold_to_org_id := rosetta_g_miss_num_map(p0_a116);
853 ddpx_header_rec.sold_to_phone_id := rosetta_g_miss_num_map(p0_a117);
854 ddpx_header_rec.source_document_id := rosetta_g_miss_num_map(p0_a118);
855 ddpx_header_rec.source_document_type_id := rosetta_g_miss_num_map(p0_a119);
856 ddpx_header_rec.tax_exempt_flag := p0_a120;
857 ddpx_header_rec.tax_exempt_number := p0_a121;
858 ddpx_header_rec.tax_exempt_reason_code := p0_a122;
859 ddpx_header_rec.tax_point_code := p0_a123;
860 ddpx_header_rec.transactional_curr_code := p0_a124;
861 ddpx_header_rec.version_number := rosetta_g_miss_num_map(p0_a125);
862 ddpx_header_rec.return_status := p0_a126;
863 ddpx_header_rec.db_flag := p0_a127;
864 ddpx_header_rec.operation := p0_a128;
865 ddpx_header_rec.first_ack_code := p0_a129;
866 ddpx_header_rec.first_ack_date := rosetta_g_miss_date_in_map(p0_a130);
867 ddpx_header_rec.last_ack_code := p0_a131;
868 ddpx_header_rec.last_ack_date := rosetta_g_miss_date_in_map(p0_a132);
869 ddpx_header_rec.change_reason := p0_a133;
870 ddpx_header_rec.change_comments := p0_a134;
871 ddpx_header_rec.change_sequence := p0_a135;
872 ddpx_header_rec.change_request_code := p0_a136;
873 ddpx_header_rec.ready_flag := p0_a137;
874 ddpx_header_rec.status_flag := p0_a138;
875 ddpx_header_rec.force_apply_flag := p0_a139;
876 ddpx_header_rec.drop_ship_flag := p0_a140;
877 ddpx_header_rec.customer_payment_term_id := rosetta_g_miss_num_map(p0_a141);
878 ddpx_header_rec.payment_type_code := p0_a142;
879 ddpx_header_rec.payment_amount := rosetta_g_miss_num_map(p0_a143);
880 ddpx_header_rec.check_number := p0_a144;
881 ddpx_header_rec.credit_card_code := p0_a145;
882 ddpx_header_rec.credit_card_holder_name := p0_a146;
883 ddpx_header_rec.credit_card_number := p0_a147;
884 ddpx_header_rec.credit_card_expiration_date := rosetta_g_miss_date_in_map(p0_a148);
885 ddpx_header_rec.credit_card_approval_code := p0_a149;
886 ddpx_header_rec.credit_card_approval_date := rosetta_g_miss_date_in_map(p0_a150);
887 ddpx_header_rec.shipping_instructions := p0_a151;
888 ddpx_header_rec.packing_instructions := p0_a152;
889 ddpx_header_rec.flow_status_code := p0_a153;
890 ddpx_header_rec.booked_date := rosetta_g_miss_date_in_map(p0_a154);
891 ddpx_header_rec.marketing_source_code_id := rosetta_g_miss_num_map(p0_a155);
892 ddpx_header_rec.upgraded_flag := p0_a156;
893 ddpx_header_rec.lock_control := rosetta_g_miss_num_map(p0_a157);
894 ddpx_header_rec.ship_to_edi_location_code := p0_a158;
895 ddpx_header_rec.sold_to_edi_location_code := p0_a159;
896 ddpx_header_rec.bill_to_edi_location_code := p0_a160;
897 ddpx_header_rec.ship_from_edi_location_code := p0_a161;
898 ddpx_header_rec.ship_from_address_id := rosetta_g_miss_num_map(p0_a162);
899 ddpx_header_rec.sold_to_address_id := rosetta_g_miss_num_map(p0_a163);
900 ddpx_header_rec.ship_to_address_id := rosetta_g_miss_num_map(p0_a164);
901 ddpx_header_rec.invoice_address_id := rosetta_g_miss_num_map(p0_a165);
902 ddpx_header_rec.ship_to_address_code := p0_a166;
903 ddpx_header_rec.xml_message_id := rosetta_g_miss_num_map(p0_a167);
904 ddpx_header_rec.ship_to_customer_id := rosetta_g_miss_num_map(p0_a168);
905 ddpx_header_rec.invoice_to_customer_id := rosetta_g_miss_num_map(p0_a169);
906 ddpx_header_rec.deliver_to_customer_id := rosetta_g_miss_num_map(p0_a170);
907 ddpx_header_rec.accounting_rule_duration := rosetta_g_miss_num_map(p0_a171);
908 ddpx_header_rec.xml_transaction_type_code := p0_a172;
909 ddpx_header_rec.blanket_number := rosetta_g_miss_num_map(p0_a173);
910 ddpx_header_rec.line_set_name := p0_a174;
911 ddpx_header_rec.fulfillment_set_name := p0_a175;
912 ddpx_header_rec.default_fulfillment_set := p0_a176;
913 ddpx_header_rec.quote_date := rosetta_g_miss_date_in_map(p0_a177);
914 ddpx_header_rec.quote_number := rosetta_g_miss_num_map(p0_a178);
915 ddpx_header_rec.sales_document_name := p0_a179;
916 ddpx_header_rec.transaction_phase_code := p0_a180;
917 ddpx_header_rec.user_status_code := p0_a181;
918 ddpx_header_rec.draft_submitted_flag := p0_a182;
919 ddpx_header_rec.source_document_version_number := rosetta_g_miss_num_map(p0_a183);
920 ddpx_header_rec.sold_to_site_use_id := rosetta_g_miss_num_map(p0_a184);
921 ddpx_header_rec.minisite_id := rosetta_g_miss_num_map(p0_a185);
922 ddpx_header_rec.ib_owner := p0_a186;
923 ddpx_header_rec.ib_installed_at_location := p0_a187;
924 ddpx_header_rec.ib_current_location := p0_a188;
925 ddpx_header_rec.end_customer_id := rosetta_g_miss_num_map(p0_a189);
926 ddpx_header_rec.end_customer_contact_id := rosetta_g_miss_num_map(p0_a190);
927 ddpx_header_rec.end_customer_site_use_id := rosetta_g_miss_num_map(p0_a191);
928 ddpx_header_rec.supplier_signature := p0_a192;
929 ddpx_header_rec.supplier_signature_date := rosetta_g_miss_date_in_map(p0_a193);
930 ddpx_header_rec.customer_signature := p0_a194;
931 ddpx_header_rec.customer_signature_date := rosetta_g_miss_date_in_map(p0_a195);
932 ddpx_header_rec.sold_to_party_id := rosetta_g_miss_num_map(p0_a196);
933 ddpx_header_rec.sold_to_org_contact_id := rosetta_g_miss_num_map(p0_a197);
934 ddpx_header_rec.ship_to_party_id := rosetta_g_miss_num_map(p0_a198);
935 ddpx_header_rec.ship_to_party_site_id := rosetta_g_miss_num_map(p0_a199);
936 ddpx_header_rec.ship_to_party_site_use_id := rosetta_g_miss_num_map(p0_a200);
937 ddpx_header_rec.deliver_to_party_id := rosetta_g_miss_num_map(p0_a201);
938 ddpx_header_rec.deliver_to_party_site_id := rosetta_g_miss_num_map(p0_a202);
939 ddpx_header_rec.deliver_to_party_site_use_id := rosetta_g_miss_num_map(p0_a203);
940 ddpx_header_rec.invoice_to_party_id := rosetta_g_miss_num_map(p0_a204);
941 ddpx_header_rec.invoice_to_party_site_id := rosetta_g_miss_num_map(p0_a205);
942 ddpx_header_rec.invoice_to_party_site_use_id := rosetta_g_miss_num_map(p0_a206);
943 ddpx_header_rec.ship_to_customer_party_id := rosetta_g_miss_num_map(p0_a207);
944 ddpx_header_rec.deliver_to_customer_party_id := rosetta_g_miss_num_map(p0_a208);
945 ddpx_header_rec.invoice_to_customer_party_id := rosetta_g_miss_num_map(p0_a209);
946 ddpx_header_rec.ship_to_org_contact_id := rosetta_g_miss_num_map(p0_a210);
947 ddpx_header_rec.deliver_to_org_contact_id := rosetta_g_miss_num_map(p0_a211);
948 ddpx_header_rec.invoice_to_org_contact_id := rosetta_g_miss_num_map(p0_a212);
949 ddpx_header_rec.contract_template_id := rosetta_g_miss_num_map(p0_a213);
950 ddpx_header_rec.contract_source_doc_type_code := p0_a214;
951 ddpx_header_rec.contract_source_document_id := rosetta_g_miss_num_map(p0_a215);
952
953 ddpx_line_rec.accounting_rule_id := rosetta_g_miss_num_map(p1_a0);
954 ddpx_line_rec.actual_arrival_date := rosetta_g_miss_date_in_map(p1_a1);
955 ddpx_line_rec.actual_shipment_date := rosetta_g_miss_date_in_map(p1_a2);
956 ddpx_line_rec.agreement_id := rosetta_g_miss_num_map(p1_a3);
957 ddpx_line_rec.arrival_set_id := rosetta_g_miss_num_map(p1_a4);
958 ddpx_line_rec.ato_line_id := rosetta_g_miss_num_map(p1_a5);
959 ddpx_line_rec.authorized_to_ship_flag := p1_a6;
960 ddpx_line_rec.auto_selected_quantity := rosetta_g_miss_num_map(p1_a7);
961 ddpx_line_rec.booked_flag := p1_a8;
962 ddpx_line_rec.cancelled_flag := p1_a9;
963 ddpx_line_rec.cancelled_quantity := rosetta_g_miss_num_map(p1_a10);
964 ddpx_line_rec.cancelled_quantity2 := rosetta_g_miss_num_map(p1_a11);
965 ddpx_line_rec.commitment_id := rosetta_g_miss_num_map(p1_a12);
966 ddpx_line_rec.component_code := p1_a13;
967 ddpx_line_rec.component_number := rosetta_g_miss_num_map(p1_a14);
968 ddpx_line_rec.component_sequence_id := rosetta_g_miss_num_map(p1_a15);
969 ddpx_line_rec.config_header_id := rosetta_g_miss_num_map(p1_a16);
970 ddpx_line_rec.config_rev_nbr := rosetta_g_miss_num_map(p1_a17);
971 ddpx_line_rec.config_display_sequence := rosetta_g_miss_num_map(p1_a18);
972 ddpx_line_rec.configuration_id := rosetta_g_miss_num_map(p1_a19);
973 ddpx_line_rec.context := p1_a20;
974 ddpx_line_rec.created_by := rosetta_g_miss_num_map(p1_a21);
975 ddpx_line_rec.creation_date := rosetta_g_miss_date_in_map(p1_a22);
976 ddpx_line_rec.credit_invoice_line_id := rosetta_g_miss_num_map(p1_a23);
977 ddpx_line_rec.customer_dock_code := p1_a24;
978 ddpx_line_rec.customer_job := p1_a25;
979 ddpx_line_rec.customer_production_line := p1_a26;
980 ddpx_line_rec.customer_trx_line_id := rosetta_g_miss_num_map(p1_a27);
981 ddpx_line_rec.cust_model_serial_number := p1_a28;
982 ddpx_line_rec.cust_po_number := p1_a29;
983 ddpx_line_rec.cust_production_seq_num := p1_a30;
984 ddpx_line_rec.delivery_lead_time := rosetta_g_miss_num_map(p1_a31);
985 ddpx_line_rec.deliver_to_contact_id := rosetta_g_miss_num_map(p1_a32);
986 ddpx_line_rec.deliver_to_org_id := rosetta_g_miss_num_map(p1_a33);
987 ddpx_line_rec.demand_bucket_type_code := p1_a34;
988 ddpx_line_rec.demand_class_code := p1_a35;
989 ddpx_line_rec.dep_plan_required_flag := p1_a36;
990 ddpx_line_rec.earliest_acceptable_date := rosetta_g_miss_date_in_map(p1_a37);
991 ddpx_line_rec.end_item_unit_number := p1_a38;
992 ddpx_line_rec.explosion_date := rosetta_g_miss_date_in_map(p1_a39);
993 ddpx_line_rec.fob_point_code := p1_a40;
994 ddpx_line_rec.freight_carrier_code := p1_a41;
995 ddpx_line_rec.freight_terms_code := p1_a42;
996 ddpx_line_rec.fulfilled_quantity := rosetta_g_miss_num_map(p1_a43);
997 ddpx_line_rec.fulfilled_quantity2 := rosetta_g_miss_num_map(p1_a44);
998 ddpx_line_rec.header_id := rosetta_g_miss_num_map(p1_a45);
999 ddpx_line_rec.intermed_ship_to_org_id := rosetta_g_miss_num_map(p1_a46);
1000 ddpx_line_rec.intermed_ship_to_contact_id := rosetta_g_miss_num_map(p1_a47);
1001 ddpx_line_rec.inventory_item_id := rosetta_g_miss_num_map(p1_a48);
1002 ddpx_line_rec.invoice_interface_status_code := p1_a49;
1003 ddpx_line_rec.invoice_to_contact_id := rosetta_g_miss_num_map(p1_a50);
1004 ddpx_line_rec.invoice_to_org_id := rosetta_g_miss_num_map(p1_a51);
1005 ddpx_line_rec.invoicing_rule_id := rosetta_g_miss_num_map(p1_a52);
1006 ddpx_line_rec.ordered_item := p1_a53;
1007 ddpx_line_rec.item_revision := p1_a54;
1008 ddpx_line_rec.item_type_code := p1_a55;
1009 ddpx_line_rec.last_updated_by := rosetta_g_miss_num_map(p1_a56);
1010 ddpx_line_rec.last_update_date := rosetta_g_miss_date_in_map(p1_a57);
1011 ddpx_line_rec.last_update_login := rosetta_g_miss_num_map(p1_a58);
1012 ddpx_line_rec.latest_acceptable_date := rosetta_g_miss_date_in_map(p1_a59);
1013 ddpx_line_rec.line_category_code := p1_a60;
1014 ddpx_line_rec.line_id := rosetta_g_miss_num_map(p1_a61);
1015 ddpx_line_rec.line_number := rosetta_g_miss_num_map(p1_a62);
1016 ddpx_line_rec.line_type_id := rosetta_g_miss_num_map(p1_a63);
1017 ddpx_line_rec.link_to_line_ref := p1_a64;
1018 ddpx_line_rec.link_to_line_id := rosetta_g_miss_num_map(p1_a65);
1019 ddpx_line_rec.link_to_line_index := rosetta_g_miss_num_map(p1_a66);
1020 ddpx_line_rec.model_group_number := rosetta_g_miss_num_map(p1_a67);
1021 ddpx_line_rec.mfg_component_sequence_id := rosetta_g_miss_num_map(p1_a68);
1022 ddpx_line_rec.mfg_lead_time := rosetta_g_miss_num_map(p1_a69);
1023 ddpx_line_rec.open_flag := p1_a70;
1024 ddpx_line_rec.option_flag := p1_a71;
1025 ddpx_line_rec.option_number := rosetta_g_miss_num_map(p1_a72);
1026 ddpx_line_rec.ordered_quantity := rosetta_g_miss_num_map(p1_a73);
1027 ddpx_line_rec.ordered_quantity2 := rosetta_g_miss_num_map(p1_a74);
1028 ddpx_line_rec.order_quantity_uom := p1_a75;
1029 ddpx_line_rec.ordered_quantity_uom2 := p1_a76;
1030 ddpx_line_rec.org_id := rosetta_g_miss_num_map(p1_a77);
1031 ddpx_line_rec.orig_sys_document_ref := p1_a78;
1032 ddpx_line_rec.orig_sys_line_ref := p1_a79;
1033 ddpx_line_rec.over_ship_reason_code := p1_a80;
1034 ddpx_line_rec.over_ship_resolved_flag := p1_a81;
1035 ddpx_line_rec.payment_term_id := rosetta_g_miss_num_map(p1_a82);
1036 ddpx_line_rec.planning_priority := rosetta_g_miss_num_map(p1_a83);
1037 ddpx_line_rec.preferred_grade := p1_a84;
1038 ddpx_line_rec.price_list_id := rosetta_g_miss_num_map(p1_a85);
1039 ddpx_line_rec.price_request_code := p1_a86;
1040 ddpx_line_rec.pricing_date := rosetta_g_miss_date_in_map(p1_a87);
1041 ddpx_line_rec.pricing_quantity := rosetta_g_miss_num_map(p1_a88);
1042 ddpx_line_rec.pricing_quantity_uom := p1_a89;
1043 ddpx_line_rec.program_application_id := rosetta_g_miss_num_map(p1_a90);
1044 ddpx_line_rec.program_id := rosetta_g_miss_num_map(p1_a91);
1045 ddpx_line_rec.program_update_date := rosetta_g_miss_date_in_map(p1_a92);
1046 ddpx_line_rec.project_id := rosetta_g_miss_num_map(p1_a93);
1047 ddpx_line_rec.promise_date := rosetta_g_miss_date_in_map(p1_a94);
1048 ddpx_line_rec.re_source_flag := p1_a95;
1049 ddpx_line_rec.reference_customer_trx_line_id := rosetta_g_miss_num_map(p1_a96);
1050 ddpx_line_rec.reference_header_id := rosetta_g_miss_num_map(p1_a97);
1051 ddpx_line_rec.reference_line_id := rosetta_g_miss_num_map(p1_a98);
1052 ddpx_line_rec.reference_type := p1_a99;
1053 ddpx_line_rec.request_date := rosetta_g_miss_date_in_map(p1_a100);
1054 ddpx_line_rec.request_id := rosetta_g_miss_num_map(p1_a101);
1055 ddpx_line_rec.reserved_quantity := rosetta_g_miss_num_map(p1_a102);
1056 ddpx_line_rec.return_reason_code := p1_a103;
1057 ddpx_line_rec.rla_schedule_type_code := p1_a104;
1058 ddpx_line_rec.salesrep_id := rosetta_g_miss_num_map(p1_a105);
1059 ddpx_line_rec.schedule_arrival_date := rosetta_g_miss_date_in_map(p1_a106);
1060 ddpx_line_rec.schedule_ship_date := rosetta_g_miss_date_in_map(p1_a107);
1061 ddpx_line_rec.schedule_action_code := p1_a108;
1062 ddpx_line_rec.schedule_status_code := p1_a109;
1063 ddpx_line_rec.shipment_number := rosetta_g_miss_num_map(p1_a110);
1064 ddpx_line_rec.shipment_priority_code := p1_a111;
1065 ddpx_line_rec.shipped_quantity := rosetta_g_miss_num_map(p1_a112);
1066 ddpx_line_rec.shipped_quantity2 := rosetta_g_miss_num_map(p1_a113);
1067 ddpx_line_rec.shipping_interfaced_flag := p1_a114;
1068 ddpx_line_rec.shipping_method_code := p1_a115;
1069 ddpx_line_rec.shipping_quantity := rosetta_g_miss_num_map(p1_a116);
1070 ddpx_line_rec.shipping_quantity2 := rosetta_g_miss_num_map(p1_a117);
1071 ddpx_line_rec.shipping_quantity_uom := p1_a118;
1072 ddpx_line_rec.shipping_quantity_uom2 := p1_a119;
1073 ddpx_line_rec.ship_from_org_id := rosetta_g_miss_num_map(p1_a120);
1074 ddpx_line_rec.ship_model_complete_flag := p1_a121;
1075 ddpx_line_rec.ship_set_id := rosetta_g_miss_num_map(p1_a122);
1076 ddpx_line_rec.fulfillment_set_id := rosetta_g_miss_num_map(p1_a123);
1077 ddpx_line_rec.ship_tolerance_above := rosetta_g_miss_num_map(p1_a124);
1078 ddpx_line_rec.ship_tolerance_below := rosetta_g_miss_num_map(p1_a125);
1079 ddpx_line_rec.ship_to_contact_id := rosetta_g_miss_num_map(p1_a126);
1080 ddpx_line_rec.ship_to_org_id := rosetta_g_miss_num_map(p1_a127);
1081 ddpx_line_rec.sold_to_org_id := rosetta_g_miss_num_map(p1_a128);
1082 ddpx_line_rec.sold_from_org_id := rosetta_g_miss_num_map(p1_a129);
1083 ddpx_line_rec.sort_order := p1_a130;
1084 ddpx_line_rec.source_document_id := rosetta_g_miss_num_map(p1_a131);
1085 ddpx_line_rec.source_document_line_id := rosetta_g_miss_num_map(p1_a132);
1086 ddpx_line_rec.source_document_type_id := rosetta_g_miss_num_map(p1_a133);
1087 ddpx_line_rec.source_type_code := p1_a134;
1088 ddpx_line_rec.split_from_line_id := rosetta_g_miss_num_map(p1_a135);
1089 ddpx_line_rec.task_id := rosetta_g_miss_num_map(p1_a136);
1090 ddpx_line_rec.tax_code := p1_a137;
1091 ddpx_line_rec.tax_date := rosetta_g_miss_date_in_map(p1_a138);
1092 ddpx_line_rec.tax_exempt_flag := p1_a139;
1093 ddpx_line_rec.tax_exempt_number := p1_a140;
1094 ddpx_line_rec.tax_exempt_reason_code := p1_a141;
1095 ddpx_line_rec.tax_point_code := p1_a142;
1096 ddpx_line_rec.tax_rate := rosetta_g_miss_num_map(p1_a143);
1097 ddpx_line_rec.tax_value := rosetta_g_miss_num_map(p1_a144);
1098 ddpx_line_rec.top_model_line_ref := p1_a145;
1099 ddpx_line_rec.top_model_line_id := rosetta_g_miss_num_map(p1_a146);
1100 ddpx_line_rec.top_model_line_index := rosetta_g_miss_num_map(p1_a147);
1101 ddpx_line_rec.unit_list_price := rosetta_g_miss_num_map(p1_a148);
1102 ddpx_line_rec.unit_list_price_per_pqty := rosetta_g_miss_num_map(p1_a149);
1103 ddpx_line_rec.unit_selling_price := rosetta_g_miss_num_map(p1_a150);
1104 ddpx_line_rec.unit_selling_price_per_pqty := rosetta_g_miss_num_map(p1_a151);
1105 ddpx_line_rec.veh_cus_item_cum_key_id := rosetta_g_miss_num_map(p1_a152);
1106 ddpx_line_rec.visible_demand_flag := p1_a153;
1107 ddpx_line_rec.return_status := p1_a154;
1108 ddpx_line_rec.db_flag := p1_a155;
1109 ddpx_line_rec.operation := p1_a156;
1110 ddpx_line_rec.first_ack_code := p1_a157;
1111 ddpx_line_rec.first_ack_date := rosetta_g_miss_date_in_map(p1_a158);
1112 ddpx_line_rec.last_ack_code := p1_a159;
1113 ddpx_line_rec.last_ack_date := rosetta_g_miss_date_in_map(p1_a160);
1114 ddpx_line_rec.change_reason := p1_a161;
1115 ddpx_line_rec.change_comments := p1_a162;
1116 ddpx_line_rec.arrival_set := p1_a163;
1117 ddpx_line_rec.ship_set := p1_a164;
1118 ddpx_line_rec.fulfillment_set := p1_a165;
1119 ddpx_line_rec.order_source_id := rosetta_g_miss_num_map(p1_a166);
1120 ddpx_line_rec.orig_sys_shipment_ref := p1_a167;
1121 ddpx_line_rec.change_sequence := p1_a168;
1122 ddpx_line_rec.change_request_code := p1_a169;
1123 ddpx_line_rec.status_flag := p1_a170;
1124 ddpx_line_rec.drop_ship_flag := p1_a171;
1125 ddpx_line_rec.customer_line_number := p1_a172;
1126 ddpx_line_rec.customer_shipment_number := p1_a173;
1127 ddpx_line_rec.customer_item_net_price := rosetta_g_miss_num_map(p1_a174);
1128 ddpx_line_rec.customer_payment_term_id := rosetta_g_miss_num_map(p1_a175);
1129 ddpx_line_rec.ordered_item_id := rosetta_g_miss_num_map(p1_a176);
1130 ddpx_line_rec.item_identifier_type := p1_a177;
1131 ddpx_line_rec.shipping_instructions := p1_a178;
1132 ddpx_line_rec.packing_instructions := p1_a179;
1133 ddpx_line_rec.calculate_price_flag := p1_a180;
1134 ddpx_line_rec.invoiced_quantity := rosetta_g_miss_num_map(p1_a181);
1135 ddpx_line_rec.service_txn_reason_code := p1_a182;
1136 ddpx_line_rec.service_txn_comments := p1_a183;
1137 ddpx_line_rec.service_duration := rosetta_g_miss_num_map(p1_a184);
1138 ddpx_line_rec.service_period := p1_a185;
1139 ddpx_line_rec.service_start_date := rosetta_g_miss_date_in_map(p1_a186);
1140 ddpx_line_rec.service_end_date := rosetta_g_miss_date_in_map(p1_a187);
1141 ddpx_line_rec.service_coterminate_flag := p1_a188;
1142 ddpx_line_rec.unit_list_percent := rosetta_g_miss_num_map(p1_a189);
1143 ddpx_line_rec.unit_selling_percent := rosetta_g_miss_num_map(p1_a190);
1144 ddpx_line_rec.unit_percent_base_price := rosetta_g_miss_num_map(p1_a191);
1145 ddpx_line_rec.service_number := rosetta_g_miss_num_map(p1_a192);
1146 ddpx_line_rec.service_reference_type_code := p1_a193;
1147 ddpx_line_rec.service_reference_line_id := rosetta_g_miss_num_map(p1_a194);
1148 ddpx_line_rec.service_reference_system_id := rosetta_g_miss_num_map(p1_a195);
1149 ddpx_line_rec.service_ref_order_number := rosetta_g_miss_num_map(p1_a196);
1150 ddpx_line_rec.service_ref_line_number := rosetta_g_miss_num_map(p1_a197);
1151 ddpx_line_rec.service_reference_order := p1_a198;
1152 ddpx_line_rec.service_reference_line := p1_a199;
1153 ddpx_line_rec.service_reference_system := p1_a200;
1154 ddpx_line_rec.service_ref_shipment_number := rosetta_g_miss_num_map(p1_a201);
1155 ddpx_line_rec.service_ref_option_number := rosetta_g_miss_num_map(p1_a202);
1156 ddpx_line_rec.service_line_index := rosetta_g_miss_num_map(p1_a203);
1157 ddpx_line_rec.line_set_id := rosetta_g_miss_num_map(p1_a204);
1158 ddpx_line_rec.split_by := p1_a205;
1159 ddpx_line_rec.split_action_code := p1_a206;
1160 ddpx_line_rec.shippable_flag := p1_a207;
1161 ddpx_line_rec.model_remnant_flag := p1_a208;
1162 ddpx_line_rec.flow_status_code := p1_a209;
1163 ddpx_line_rec.fulfilled_flag := p1_a210;
1164 ddpx_line_rec.fulfillment_method_code := p1_a211;
1165 ddpx_line_rec.revenue_amount := rosetta_g_miss_num_map(p1_a212);
1166 ddpx_line_rec.marketing_source_code_id := rosetta_g_miss_num_map(p1_a213);
1167 ddpx_line_rec.fulfillment_date := rosetta_g_miss_date_in_map(p1_a214);
1168 if p1_a215 is null
1169 then ddpx_line_rec.semi_processed_flag := null;
1170 elsif p1_a215 = 0
1171 then ddpx_line_rec.semi_processed_flag := false;
1172 else ddpx_line_rec.semi_processed_flag := true;
1173 end if;
1174 ddpx_line_rec.upgraded_flag := p1_a216;
1175 ddpx_line_rec.lock_control := rosetta_g_miss_num_map(p1_a217);
1176 ddpx_line_rec.subinventory := p1_a218;
1177 ddpx_line_rec.split_from_line_ref := p1_a219;
1178 ddpx_line_rec.split_from_shipment_ref := p1_a220;
1179 ddpx_line_rec.ship_to_edi_location_code := p1_a221;
1180 ddpx_line_rec.bill_to_edi_location_code := p1_a222;
1181 ddpx_line_rec.ship_from_edi_location_code := p1_a223;
1182 ddpx_line_rec.ship_from_address_id := rosetta_g_miss_num_map(p1_a224);
1183 ddpx_line_rec.sold_to_address_id := rosetta_g_miss_num_map(p1_a225);
1184 ddpx_line_rec.ship_to_address_id := rosetta_g_miss_num_map(p1_a226);
1185 ddpx_line_rec.invoice_address_id := rosetta_g_miss_num_map(p1_a227);
1186 ddpx_line_rec.ship_to_address_code := p1_a228;
1187 ddpx_line_rec.original_inventory_item_id := rosetta_g_miss_num_map(p1_a229);
1188 ddpx_line_rec.original_item_identifier_type := p1_a230;
1189 ddpx_line_rec.original_ordered_item_id := rosetta_g_miss_num_map(p1_a231);
1190 ddpx_line_rec.original_ordered_item := p1_a232;
1191 ddpx_line_rec.item_substitution_type_code := p1_a233;
1192 ddpx_line_rec.late_demand_penalty_factor := rosetta_g_miss_num_map(p1_a234);
1193 ddpx_line_rec.override_atp_date_code := p1_a235;
1194 ddpx_line_rec.ship_to_customer_id := rosetta_g_miss_num_map(p1_a236);
1195 ddpx_line_rec.invoice_to_customer_id := rosetta_g_miss_num_map(p1_a237);
1196 ddpx_line_rec.deliver_to_customer_id := rosetta_g_miss_num_map(p1_a238);
1197 ddpx_line_rec.accounting_rule_duration := rosetta_g_miss_num_map(p1_a239);
1198 ddpx_line_rec.unit_cost := rosetta_g_miss_num_map(p1_a240);
1199 ddpx_line_rec.user_item_description := p1_a241;
1200 ddpx_line_rec.xml_transaction_type_code := p1_a242;
1201 ddpx_line_rec.item_relationship_type := rosetta_g_miss_num_map(p1_a243);
1202 ddpx_line_rec.blanket_number := rosetta_g_miss_num_map(p1_a244);
1203 ddpx_line_rec.blanket_line_number := rosetta_g_miss_num_map(p1_a245);
1204 ddpx_line_rec.blanket_version_number := rosetta_g_miss_num_map(p1_a246);
1205 ddpx_line_rec.cso_response_flag := p1_a247;
1206 ddpx_line_rec.firm_demand_flag := p1_a248;
1207 ddpx_line_rec.earliest_ship_date := rosetta_g_miss_date_in_map(p1_a249);
1208 ddpx_line_rec.transaction_phase_code := p1_a250;
1209 ddpx_line_rec.source_document_version_number := rosetta_g_miss_num_map(p1_a251);
1210 ddpx_line_rec.minisite_id := rosetta_g_miss_num_map(p1_a252);
1211 ddpx_line_rec.ib_owner := p1_a253;
1212 ddpx_line_rec.ib_installed_at_location := p1_a254;
1213 ddpx_line_rec.ib_current_location := p1_a255;
1214 ddpx_line_rec.end_customer_id := rosetta_g_miss_num_map(p1_a256);
1215 ddpx_line_rec.end_customer_contact_id := rosetta_g_miss_num_map(p1_a257);
1216 ddpx_line_rec.end_customer_site_use_id := rosetta_g_miss_num_map(p1_a258);
1217 ddpx_line_rec.supplier_signature := p1_a259;
1218 ddpx_line_rec.supplier_signature_date := rosetta_g_miss_date_in_map(p1_a260);
1219 ddpx_line_rec.customer_signature := p1_a261;
1220 ddpx_line_rec.customer_signature_date := rosetta_g_miss_date_in_map(p1_a262);
1221 ddpx_line_rec.ship_to_party_id := rosetta_g_miss_num_map(p1_a263);
1222 ddpx_line_rec.ship_to_party_site_id := rosetta_g_miss_num_map(p1_a264);
1223 ddpx_line_rec.ship_to_party_site_use_id := rosetta_g_miss_num_map(p1_a265);
1224 ddpx_line_rec.deliver_to_party_id := rosetta_g_miss_num_map(p1_a266);
1225 ddpx_line_rec.deliver_to_party_site_id := rosetta_g_miss_num_map(p1_a267);
1226 ddpx_line_rec.deliver_to_party_site_use_id := rosetta_g_miss_num_map(p1_a268);
1227 ddpx_line_rec.invoice_to_party_id := rosetta_g_miss_num_map(p1_a269);
1228 ddpx_line_rec.invoice_to_party_site_id := rosetta_g_miss_num_map(p1_a270);
1229 ddpx_line_rec.invoice_to_party_site_use_id := rosetta_g_miss_num_map(p1_a271);
1230 ddpx_line_rec.ship_to_customer_party_id := rosetta_g_miss_num_map(p1_a272);
1231 ddpx_line_rec.deliver_to_customer_party_id := rosetta_g_miss_num_map(p1_a273);
1232 ddpx_line_rec.invoice_to_customer_party_id := rosetta_g_miss_num_map(p1_a274);
1233 ddpx_line_rec.ship_to_org_contact_id := rosetta_g_miss_num_map(p1_a275);
1234 ddpx_line_rec.deliver_to_org_contact_id := rosetta_g_miss_num_map(p1_a276);
1235 ddpx_line_rec.invoice_to_org_contact_id := rosetta_g_miss_num_map(p1_a277);
1236 ddpx_line_rec.retrobill_request_id := rosetta_g_miss_num_map(p1_a278);
1237 ddpx_line_rec.original_list_price := rosetta_g_miss_num_map(p1_a279);
1238 ddpx_line_rec.commitment_applied_amount := rosetta_g_miss_num_map(p1_a280);
1239
1240 oe_order_pub_w.rosetta_table_copy_in_p23(ddpx_line_adj_tbl, p2_a0
1241 , p2_a1
1242 , p2_a2
1243 , p2_a3
1244 , p2_a4
1245 , p2_a5
1246 , p2_a6
1247 , p2_a7
1248 , p2_a8
1249 , p2_a9
1250 , p2_a10
1251 , p2_a11
1252 , p2_a12
1253 , p2_a13
1254 , p2_a14
1255 , p2_a15
1256 , p2_a16
1257 , p2_a17
1258 , p2_a18
1259 , p2_a19
1260 , p2_a20
1261 , p2_a21
1262 , p2_a22
1263 , p2_a23
1264 , p2_a24
1265 , p2_a25
1266 , p2_a26
1267 , p2_a27
1268 , p2_a28
1269 , p2_a29
1270 , p2_a30
1271 , p2_a31
1272 , p2_a32
1273 , p2_a33
1274 , p2_a34
1275 , p2_a35
1276 , p2_a36
1277 , p2_a37
1278 , p2_a38
1279 , p2_a39
1280 , p2_a40
1281 , p2_a41
1282 , p2_a42
1283 , p2_a43
1284 , p2_a44
1285 , p2_a45
1286 , p2_a46
1287 , p2_a47
1288 , p2_a48
1289 , p2_a49
1290 , p2_a50
1291 , p2_a51
1292 , p2_a52
1293 , p2_a53
1294 , p2_a54
1295 , p2_a55
1296 , p2_a56
1297 , p2_a57
1298 , p2_a58
1299 , p2_a59
1300 , p2_a60
1301 , p2_a61
1302 , p2_a62
1303 , p2_a63
1304 , p2_a64
1305 , p2_a65
1306 , p2_a66
1307 , p2_a67
1308 , p2_a68
1309 , p2_a69
1310 , p2_a70
1311 , p2_a71
1312 , p2_a72
1313 , p2_a73
1314 , p2_a74
1315 , p2_a75
1316 , p2_a76
1317 , p2_a77
1318 , p2_a78
1319 , p2_a79
1320 , p2_a80
1321 , p2_a81
1322 , p2_a82
1323 , p2_a83
1324 , p2_a84
1325 , p2_a85
1326 , p2_a86
1327 , p2_a87
1328 , p2_a88
1329 , p2_a89
1330 , p2_a90
1331 , p2_a91
1332 , p2_a92
1333 , p2_a93
1334 , p2_a94
1335 , p2_a95
1336 , p2_a96
1337 , p2_a97
1338 , p2_a98
1339 , p2_a99
1340 , p2_a100
1341 , p2_a101
1342 , p2_a102
1343 , p2_a103
1344 , p2_a104
1345 , p2_a105
1346 , p2_a106
1347 , p2_a107
1348 , p2_a108
1349 );
1350
1351 oe_price_order_pvt_w_obsolete.rosetta_table_copy_in_p3(ddp_line_price_att_tbl, p3_a0
1352 , p3_a1
1353 , p3_a2
1354 , p3_a3
1355 , p3_a4
1356 , p3_a5
1357 , p3_a6
1358 );
1359
1360
1361
1362
1363
1364
1365 -- here's the delegated call to the old PL/SQL routine
1366 oe_price_order_pvt.price_order(ddpx_header_rec,
1367 ddpx_line_rec,
1368 ddpx_line_adj_tbl,
1369 ddp_line_price_att_tbl,
1370 p_action_code,
1371 p_pricing_events,
1372 p_simulation_flag,
1373 p_get_freight_flag,
1374 x_return_status);
1375
1376 -- copy data back from the local variables to OUT or IN-OUT args, if any
1377 p0_a0 := rosetta_g_miss_num_map(ddpx_header_rec.accounting_rule_id);
1378 p0_a1 := rosetta_g_miss_num_map(ddpx_header_rec.agreement_id);
1379 p0_a2 := ddpx_header_rec.attribute1;
1380 p0_a3 := ddpx_header_rec.attribute10;
1381 p0_a4 := ddpx_header_rec.attribute11;
1382 p0_a5 := ddpx_header_rec.attribute12;
1383 p0_a6 := ddpx_header_rec.attribute13;
1384 p0_a7 := ddpx_header_rec.attribute14;
1385 p0_a8 := ddpx_header_rec.attribute15;
1386 p0_a9 := ddpx_header_rec.attribute16;
1387 p0_a10 := ddpx_header_rec.attribute17;
1388 p0_a11 := ddpx_header_rec.attribute18;
1389 p0_a12 := ddpx_header_rec.attribute19;
1390 p0_a13 := ddpx_header_rec.attribute2;
1391 p0_a14 := ddpx_header_rec.attribute20;
1392 p0_a15 := ddpx_header_rec.attribute3;
1393 p0_a16 := ddpx_header_rec.attribute4;
1394 p0_a17 := ddpx_header_rec.attribute5;
1395 p0_a18 := ddpx_header_rec.attribute6;
1396 p0_a19 := ddpx_header_rec.attribute7;
1397 p0_a20 := ddpx_header_rec.attribute8;
1398 p0_a21 := ddpx_header_rec.attribute9;
1399 p0_a22 := ddpx_header_rec.booked_flag;
1400 p0_a23 := ddpx_header_rec.cancelled_flag;
1401 p0_a24 := ddpx_header_rec.context;
1402 p0_a25 := rosetta_g_miss_num_map(ddpx_header_rec.conversion_rate);
1403 p0_a26 := ddpx_header_rec.conversion_rate_date;
1404 p0_a27 := ddpx_header_rec.conversion_type_code;
1405 p0_a28 := ddpx_header_rec.customer_preference_set_code;
1406 p0_a29 := rosetta_g_miss_num_map(ddpx_header_rec.created_by);
1407 p0_a30 := ddpx_header_rec.creation_date;
1408 p0_a31 := ddpx_header_rec.cust_po_number;
1409 p0_a32 := rosetta_g_miss_num_map(ddpx_header_rec.deliver_to_contact_id);
1410 p0_a33 := rosetta_g_miss_num_map(ddpx_header_rec.deliver_to_org_id);
1411 p0_a34 := ddpx_header_rec.demand_class_code;
1412 p0_a35 := rosetta_g_miss_num_map(ddpx_header_rec.earliest_schedule_limit);
1413 p0_a36 := ddpx_header_rec.expiration_date;
1414 p0_a37 := ddpx_header_rec.fob_point_code;
1415 p0_a38 := ddpx_header_rec.freight_carrier_code;
1416 p0_a39 := ddpx_header_rec.freight_terms_code;
1417 p0_a40 := ddpx_header_rec.global_attribute1;
1418 p0_a41 := ddpx_header_rec.global_attribute10;
1419 p0_a42 := ddpx_header_rec.global_attribute11;
1420 p0_a43 := ddpx_header_rec.global_attribute12;
1421 p0_a44 := ddpx_header_rec.global_attribute13;
1422 p0_a45 := ddpx_header_rec.global_attribute14;
1423 p0_a46 := ddpx_header_rec.global_attribute15;
1424 p0_a47 := ddpx_header_rec.global_attribute16;
1425 p0_a48 := ddpx_header_rec.global_attribute17;
1426 p0_a49 := ddpx_header_rec.global_attribute18;
1427 p0_a50 := ddpx_header_rec.global_attribute19;
1428 p0_a51 := ddpx_header_rec.global_attribute2;
1429 p0_a52 := ddpx_header_rec.global_attribute20;
1430 p0_a53 := ddpx_header_rec.global_attribute3;
1431 p0_a54 := ddpx_header_rec.global_attribute4;
1432 p0_a55 := ddpx_header_rec.global_attribute5;
1433 p0_a56 := ddpx_header_rec.global_attribute6;
1434 p0_a57 := ddpx_header_rec.global_attribute7;
1435 p0_a58 := ddpx_header_rec.global_attribute8;
1436 p0_a59 := ddpx_header_rec.global_attribute9;
1437 p0_a60 := ddpx_header_rec.global_attribute_category;
1438 p0_a61 := ddpx_header_rec.tp_context;
1439 p0_a62 := ddpx_header_rec.tp_attribute1;
1440 p0_a63 := ddpx_header_rec.tp_attribute2;
1441 p0_a64 := ddpx_header_rec.tp_attribute3;
1442 p0_a65 := ddpx_header_rec.tp_attribute4;
1443 p0_a66 := ddpx_header_rec.tp_attribute5;
1444 p0_a67 := ddpx_header_rec.tp_attribute6;
1445 p0_a68 := ddpx_header_rec.tp_attribute7;
1446 p0_a69 := ddpx_header_rec.tp_attribute8;
1447 p0_a70 := ddpx_header_rec.tp_attribute9;
1448 p0_a71 := ddpx_header_rec.tp_attribute10;
1449 p0_a72 := ddpx_header_rec.tp_attribute11;
1450 p0_a73 := ddpx_header_rec.tp_attribute12;
1451 p0_a74 := ddpx_header_rec.tp_attribute13;
1452 p0_a75 := ddpx_header_rec.tp_attribute14;
1453 p0_a76 := ddpx_header_rec.tp_attribute15;
1454 p0_a77 := rosetta_g_miss_num_map(ddpx_header_rec.header_id);
1455 p0_a78 := rosetta_g_miss_num_map(ddpx_header_rec.invoice_to_contact_id);
1456 p0_a79 := rosetta_g_miss_num_map(ddpx_header_rec.invoice_to_org_id);
1457 p0_a80 := rosetta_g_miss_num_map(ddpx_header_rec.invoicing_rule_id);
1458 p0_a81 := rosetta_g_miss_num_map(ddpx_header_rec.last_updated_by);
1459 p0_a82 := ddpx_header_rec.last_update_date;
1460 p0_a83 := rosetta_g_miss_num_map(ddpx_header_rec.last_update_login);
1461 p0_a84 := rosetta_g_miss_num_map(ddpx_header_rec.latest_schedule_limit);
1462 p0_a85 := ddpx_header_rec.open_flag;
1463 p0_a86 := ddpx_header_rec.order_category_code;
1464 p0_a87 := ddpx_header_rec.ordered_date;
1465 p0_a88 := ddpx_header_rec.order_date_type_code;
1466 p0_a89 := rosetta_g_miss_num_map(ddpx_header_rec.order_number);
1467 p0_a90 := rosetta_g_miss_num_map(ddpx_header_rec.order_source_id);
1468 p0_a91 := rosetta_g_miss_num_map(ddpx_header_rec.order_type_id);
1469 p0_a92 := rosetta_g_miss_num_map(ddpx_header_rec.org_id);
1470 p0_a93 := ddpx_header_rec.orig_sys_document_ref;
1471 p0_a94 := ddpx_header_rec.partial_shipments_allowed;
1472 p0_a95 := rosetta_g_miss_num_map(ddpx_header_rec.payment_term_id);
1473 p0_a96 := rosetta_g_miss_num_map(ddpx_header_rec.price_list_id);
1474 p0_a97 := ddpx_header_rec.price_request_code;
1475 p0_a98 := ddpx_header_rec.pricing_date;
1476 p0_a99 := rosetta_g_miss_num_map(ddpx_header_rec.program_application_id);
1477 p0_a100 := rosetta_g_miss_num_map(ddpx_header_rec.program_id);
1478 p0_a101 := ddpx_header_rec.program_update_date;
1479 p0_a102 := ddpx_header_rec.request_date;
1480 p0_a103 := rosetta_g_miss_num_map(ddpx_header_rec.request_id);
1481 p0_a104 := ddpx_header_rec.return_reason_code;
1482 p0_a105 := rosetta_g_miss_num_map(ddpx_header_rec.salesrep_id);
1483 p0_a106 := ddpx_header_rec.sales_channel_code;
1484 p0_a107 := ddpx_header_rec.shipment_priority_code;
1485 p0_a108 := ddpx_header_rec.shipping_method_code;
1486 p0_a109 := rosetta_g_miss_num_map(ddpx_header_rec.ship_from_org_id);
1487 p0_a110 := rosetta_g_miss_num_map(ddpx_header_rec.ship_tolerance_above);
1488 p0_a111 := rosetta_g_miss_num_map(ddpx_header_rec.ship_tolerance_below);
1489 p0_a112 := rosetta_g_miss_num_map(ddpx_header_rec.ship_to_contact_id);
1490 p0_a113 := rosetta_g_miss_num_map(ddpx_header_rec.ship_to_org_id);
1491 p0_a114 := rosetta_g_miss_num_map(ddpx_header_rec.sold_from_org_id);
1492 p0_a115 := rosetta_g_miss_num_map(ddpx_header_rec.sold_to_contact_id);
1493 p0_a116 := rosetta_g_miss_num_map(ddpx_header_rec.sold_to_org_id);
1494 p0_a117 := rosetta_g_miss_num_map(ddpx_header_rec.sold_to_phone_id);
1495 p0_a118 := rosetta_g_miss_num_map(ddpx_header_rec.source_document_id);
1496 p0_a119 := rosetta_g_miss_num_map(ddpx_header_rec.source_document_type_id);
1497 p0_a120 := ddpx_header_rec.tax_exempt_flag;
1498 p0_a121 := ddpx_header_rec.tax_exempt_number;
1499 p0_a122 := ddpx_header_rec.tax_exempt_reason_code;
1500 p0_a123 := ddpx_header_rec.tax_point_code;
1501 p0_a124 := ddpx_header_rec.transactional_curr_code;
1502 p0_a125 := rosetta_g_miss_num_map(ddpx_header_rec.version_number);
1503 p0_a126 := ddpx_header_rec.return_status;
1504 p0_a127 := ddpx_header_rec.db_flag;
1505 p0_a128 := ddpx_header_rec.operation;
1506 p0_a129 := ddpx_header_rec.first_ack_code;
1507 p0_a130 := ddpx_header_rec.first_ack_date;
1508 p0_a131 := ddpx_header_rec.last_ack_code;
1509 p0_a132 := ddpx_header_rec.last_ack_date;
1510 p0_a133 := ddpx_header_rec.change_reason;
1511 p0_a134 := ddpx_header_rec.change_comments;
1512 p0_a135 := ddpx_header_rec.change_sequence;
1513 p0_a136 := ddpx_header_rec.change_request_code;
1514 p0_a137 := ddpx_header_rec.ready_flag;
1515 p0_a138 := ddpx_header_rec.status_flag;
1516 p0_a139 := ddpx_header_rec.force_apply_flag;
1517 p0_a140 := ddpx_header_rec.drop_ship_flag;
1518 p0_a141 := rosetta_g_miss_num_map(ddpx_header_rec.customer_payment_term_id);
1519 p0_a142 := ddpx_header_rec.payment_type_code;
1520 p0_a143 := rosetta_g_miss_num_map(ddpx_header_rec.payment_amount);
1521 p0_a144 := ddpx_header_rec.check_number;
1522 p0_a145 := ddpx_header_rec.credit_card_code;
1523 p0_a146 := ddpx_header_rec.credit_card_holder_name;
1524 p0_a147 := ddpx_header_rec.credit_card_number;
1525 p0_a148 := ddpx_header_rec.credit_card_expiration_date;
1526 p0_a149 := ddpx_header_rec.credit_card_approval_code;
1527 p0_a150 := ddpx_header_rec.credit_card_approval_date;
1528 p0_a151 := ddpx_header_rec.shipping_instructions;
1529 p0_a152 := ddpx_header_rec.packing_instructions;
1530 p0_a153 := ddpx_header_rec.flow_status_code;
1531 p0_a154 := ddpx_header_rec.booked_date;
1532 p0_a155 := rosetta_g_miss_num_map(ddpx_header_rec.marketing_source_code_id);
1533 p0_a156 := ddpx_header_rec.upgraded_flag;
1534 p0_a157 := rosetta_g_miss_num_map(ddpx_header_rec.lock_control);
1535 p0_a158 := ddpx_header_rec.ship_to_edi_location_code;
1536 p0_a159 := ddpx_header_rec.sold_to_edi_location_code;
1537 p0_a160 := ddpx_header_rec.bill_to_edi_location_code;
1538 p0_a161 := ddpx_header_rec.ship_from_edi_location_code;
1539 p0_a162 := rosetta_g_miss_num_map(ddpx_header_rec.ship_from_address_id);
1540 p0_a163 := rosetta_g_miss_num_map(ddpx_header_rec.sold_to_address_id);
1541 p0_a164 := rosetta_g_miss_num_map(ddpx_header_rec.ship_to_address_id);
1542 p0_a165 := rosetta_g_miss_num_map(ddpx_header_rec.invoice_address_id);
1543 p0_a166 := ddpx_header_rec.ship_to_address_code;
1544 p0_a167 := rosetta_g_miss_num_map(ddpx_header_rec.xml_message_id);
1545 p0_a168 := rosetta_g_miss_num_map(ddpx_header_rec.ship_to_customer_id);
1546 p0_a169 := rosetta_g_miss_num_map(ddpx_header_rec.invoice_to_customer_id);
1547 p0_a170 := rosetta_g_miss_num_map(ddpx_header_rec.deliver_to_customer_id);
1548 p0_a171 := rosetta_g_miss_num_map(ddpx_header_rec.accounting_rule_duration);
1549 p0_a172 := ddpx_header_rec.xml_transaction_type_code;
1550 p0_a173 := rosetta_g_miss_num_map(ddpx_header_rec.blanket_number);
1551 p0_a174 := ddpx_header_rec.line_set_name;
1552 p0_a175 := ddpx_header_rec.fulfillment_set_name;
1553 p0_a176 := ddpx_header_rec.default_fulfillment_set;
1554 p0_a177 := ddpx_header_rec.quote_date;
1555 p0_a178 := rosetta_g_miss_num_map(ddpx_header_rec.quote_number);
1556 p0_a179 := ddpx_header_rec.sales_document_name;
1557 p0_a180 := ddpx_header_rec.transaction_phase_code;
1558 p0_a181 := ddpx_header_rec.user_status_code;
1559 p0_a182 := ddpx_header_rec.draft_submitted_flag;
1560 p0_a183 := rosetta_g_miss_num_map(ddpx_header_rec.source_document_version_number);
1561 p0_a184 := rosetta_g_miss_num_map(ddpx_header_rec.sold_to_site_use_id);
1562 p0_a185 := rosetta_g_miss_num_map(ddpx_header_rec.minisite_id);
1563 p0_a186 := ddpx_header_rec.ib_owner;
1564 p0_a187 := ddpx_header_rec.ib_installed_at_location;
1565 p0_a188 := ddpx_header_rec.ib_current_location;
1566 p0_a189 := rosetta_g_miss_num_map(ddpx_header_rec.end_customer_id);
1567 p0_a190 := rosetta_g_miss_num_map(ddpx_header_rec.end_customer_contact_id);
1568 p0_a191 := rosetta_g_miss_num_map(ddpx_header_rec.end_customer_site_use_id);
1569 p0_a192 := ddpx_header_rec.supplier_signature;
1570 p0_a193 := ddpx_header_rec.supplier_signature_date;
1571 p0_a194 := ddpx_header_rec.customer_signature;
1572 p0_a195 := ddpx_header_rec.customer_signature_date;
1573 p0_a196 := rosetta_g_miss_num_map(ddpx_header_rec.sold_to_party_id);
1574 p0_a197 := rosetta_g_miss_num_map(ddpx_header_rec.sold_to_org_contact_id);
1575 p0_a198 := rosetta_g_miss_num_map(ddpx_header_rec.ship_to_party_id);
1576 p0_a199 := rosetta_g_miss_num_map(ddpx_header_rec.ship_to_party_site_id);
1577 p0_a200 := rosetta_g_miss_num_map(ddpx_header_rec.ship_to_party_site_use_id);
1578 p0_a201 := rosetta_g_miss_num_map(ddpx_header_rec.deliver_to_party_id);
1579 p0_a202 := rosetta_g_miss_num_map(ddpx_header_rec.deliver_to_party_site_id);
1580 p0_a203 := rosetta_g_miss_num_map(ddpx_header_rec.deliver_to_party_site_use_id);
1581 p0_a204 := rosetta_g_miss_num_map(ddpx_header_rec.invoice_to_party_id);
1582 p0_a205 := rosetta_g_miss_num_map(ddpx_header_rec.invoice_to_party_site_id);
1583 p0_a206 := rosetta_g_miss_num_map(ddpx_header_rec.invoice_to_party_site_use_id);
1584 p0_a207 := rosetta_g_miss_num_map(ddpx_header_rec.ship_to_customer_party_id);
1585 p0_a208 := rosetta_g_miss_num_map(ddpx_header_rec.deliver_to_customer_party_id);
1586 p0_a209 := rosetta_g_miss_num_map(ddpx_header_rec.invoice_to_customer_party_id);
1587 p0_a210 := rosetta_g_miss_num_map(ddpx_header_rec.ship_to_org_contact_id);
1588 p0_a211 := rosetta_g_miss_num_map(ddpx_header_rec.deliver_to_org_contact_id);
1589 p0_a212 := rosetta_g_miss_num_map(ddpx_header_rec.invoice_to_org_contact_id);
1590 p0_a213 := rosetta_g_miss_num_map(ddpx_header_rec.contract_template_id);
1591 p0_a214 := ddpx_header_rec.contract_source_doc_type_code;
1592 p0_a215 := rosetta_g_miss_num_map(ddpx_header_rec.contract_source_document_id);
1593
1594 p1_a0 := rosetta_g_miss_num_map(ddpx_line_rec.accounting_rule_id);
1595 p1_a1 := ddpx_line_rec.actual_arrival_date;
1596 p1_a2 := ddpx_line_rec.actual_shipment_date;
1597 p1_a3 := rosetta_g_miss_num_map(ddpx_line_rec.agreement_id);
1598 p1_a4 := rosetta_g_miss_num_map(ddpx_line_rec.arrival_set_id);
1599 p1_a5 := rosetta_g_miss_num_map(ddpx_line_rec.ato_line_id);
1600 p1_a6 := ddpx_line_rec.authorized_to_ship_flag;
1601 p1_a7 := rosetta_g_miss_num_map(ddpx_line_rec.auto_selected_quantity);
1602 p1_a8 := ddpx_line_rec.booked_flag;
1603 p1_a9 := ddpx_line_rec.cancelled_flag;
1604 p1_a10 := rosetta_g_miss_num_map(ddpx_line_rec.cancelled_quantity);
1605 p1_a11 := rosetta_g_miss_num_map(ddpx_line_rec.cancelled_quantity2);
1606 p1_a12 := rosetta_g_miss_num_map(ddpx_line_rec.commitment_id);
1607 p1_a13 := ddpx_line_rec.component_code;
1608 p1_a14 := rosetta_g_miss_num_map(ddpx_line_rec.component_number);
1609 p1_a15 := rosetta_g_miss_num_map(ddpx_line_rec.component_sequence_id);
1610 p1_a16 := rosetta_g_miss_num_map(ddpx_line_rec.config_header_id);
1611 p1_a17 := rosetta_g_miss_num_map(ddpx_line_rec.config_rev_nbr);
1612 p1_a18 := rosetta_g_miss_num_map(ddpx_line_rec.config_display_sequence);
1613 p1_a19 := rosetta_g_miss_num_map(ddpx_line_rec.configuration_id);
1614 p1_a20 := ddpx_line_rec.context;
1615 p1_a21 := rosetta_g_miss_num_map(ddpx_line_rec.created_by);
1616 p1_a22 := ddpx_line_rec.creation_date;
1617 p1_a23 := rosetta_g_miss_num_map(ddpx_line_rec.credit_invoice_line_id);
1618 p1_a24 := ddpx_line_rec.customer_dock_code;
1619 p1_a25 := ddpx_line_rec.customer_job;
1620 p1_a26 := ddpx_line_rec.customer_production_line;
1621 p1_a27 := rosetta_g_miss_num_map(ddpx_line_rec.customer_trx_line_id);
1622 p1_a28 := ddpx_line_rec.cust_model_serial_number;
1623 p1_a29 := ddpx_line_rec.cust_po_number;
1624 p1_a30 := ddpx_line_rec.cust_production_seq_num;
1625 p1_a31 := rosetta_g_miss_num_map(ddpx_line_rec.delivery_lead_time);
1626 p1_a32 := rosetta_g_miss_num_map(ddpx_line_rec.deliver_to_contact_id);
1627 p1_a33 := rosetta_g_miss_num_map(ddpx_line_rec.deliver_to_org_id);
1628 p1_a34 := ddpx_line_rec.demand_bucket_type_code;
1629 p1_a35 := ddpx_line_rec.demand_class_code;
1630 p1_a36 := ddpx_line_rec.dep_plan_required_flag;
1631 p1_a37 := ddpx_line_rec.earliest_acceptable_date;
1632 p1_a38 := ddpx_line_rec.end_item_unit_number;
1633 p1_a39 := ddpx_line_rec.explosion_date;
1634 p1_a40 := ddpx_line_rec.fob_point_code;
1635 p1_a41 := ddpx_line_rec.freight_carrier_code;
1636 p1_a42 := ddpx_line_rec.freight_terms_code;
1637 p1_a43 := rosetta_g_miss_num_map(ddpx_line_rec.fulfilled_quantity);
1638 p1_a44 := rosetta_g_miss_num_map(ddpx_line_rec.fulfilled_quantity2);
1639 p1_a45 := rosetta_g_miss_num_map(ddpx_line_rec.header_id);
1640 p1_a46 := rosetta_g_miss_num_map(ddpx_line_rec.intermed_ship_to_org_id);
1641 p1_a47 := rosetta_g_miss_num_map(ddpx_line_rec.intermed_ship_to_contact_id);
1642 p1_a48 := rosetta_g_miss_num_map(ddpx_line_rec.inventory_item_id);
1643 p1_a49 := ddpx_line_rec.invoice_interface_status_code;
1644 p1_a50 := rosetta_g_miss_num_map(ddpx_line_rec.invoice_to_contact_id);
1645 p1_a51 := rosetta_g_miss_num_map(ddpx_line_rec.invoice_to_org_id);
1646 p1_a52 := rosetta_g_miss_num_map(ddpx_line_rec.invoicing_rule_id);
1647 p1_a53 := ddpx_line_rec.ordered_item;
1648 p1_a54 := ddpx_line_rec.item_revision;
1649 p1_a55 := ddpx_line_rec.item_type_code;
1650 p1_a56 := rosetta_g_miss_num_map(ddpx_line_rec.last_updated_by);
1651 p1_a57 := ddpx_line_rec.last_update_date;
1652 p1_a58 := rosetta_g_miss_num_map(ddpx_line_rec.last_update_login);
1653 p1_a59 := ddpx_line_rec.latest_acceptable_date;
1654 p1_a60 := ddpx_line_rec.line_category_code;
1655 p1_a61 := rosetta_g_miss_num_map(ddpx_line_rec.line_id);
1656 p1_a62 := rosetta_g_miss_num_map(ddpx_line_rec.line_number);
1657 p1_a63 := rosetta_g_miss_num_map(ddpx_line_rec.line_type_id);
1658 p1_a64 := ddpx_line_rec.link_to_line_ref;
1659 p1_a65 := rosetta_g_miss_num_map(ddpx_line_rec.link_to_line_id);
1660 p1_a66 := rosetta_g_miss_num_map(ddpx_line_rec.link_to_line_index);
1661 p1_a67 := rosetta_g_miss_num_map(ddpx_line_rec.model_group_number);
1662 p1_a68 := rosetta_g_miss_num_map(ddpx_line_rec.mfg_component_sequence_id);
1663 p1_a69 := rosetta_g_miss_num_map(ddpx_line_rec.mfg_lead_time);
1664 p1_a70 := ddpx_line_rec.open_flag;
1665 p1_a71 := ddpx_line_rec.option_flag;
1666 p1_a72 := rosetta_g_miss_num_map(ddpx_line_rec.option_number);
1667 p1_a73 := rosetta_g_miss_num_map(ddpx_line_rec.ordered_quantity);
1668 p1_a74 := rosetta_g_miss_num_map(ddpx_line_rec.ordered_quantity2);
1669 p1_a75 := ddpx_line_rec.order_quantity_uom;
1670 p1_a76 := ddpx_line_rec.ordered_quantity_uom2;
1671 p1_a77 := rosetta_g_miss_num_map(ddpx_line_rec.org_id);
1672 p1_a78 := ddpx_line_rec.orig_sys_document_ref;
1673 p1_a79 := ddpx_line_rec.orig_sys_line_ref;
1674 p1_a80 := ddpx_line_rec.over_ship_reason_code;
1675 p1_a81 := ddpx_line_rec.over_ship_resolved_flag;
1676 p1_a82 := rosetta_g_miss_num_map(ddpx_line_rec.payment_term_id);
1677 p1_a83 := rosetta_g_miss_num_map(ddpx_line_rec.planning_priority);
1678 p1_a84 := ddpx_line_rec.preferred_grade;
1679 p1_a85 := rosetta_g_miss_num_map(ddpx_line_rec.price_list_id);
1680 p1_a86 := ddpx_line_rec.price_request_code;
1681 p1_a87 := ddpx_line_rec.pricing_date;
1682 p1_a88 := rosetta_g_miss_num_map(ddpx_line_rec.pricing_quantity);
1683 p1_a89 := ddpx_line_rec.pricing_quantity_uom;
1684 p1_a90 := rosetta_g_miss_num_map(ddpx_line_rec.program_application_id);
1685 p1_a91 := rosetta_g_miss_num_map(ddpx_line_rec.program_id);
1686 p1_a92 := ddpx_line_rec.program_update_date;
1687 p1_a93 := rosetta_g_miss_num_map(ddpx_line_rec.project_id);
1688 p1_a94 := ddpx_line_rec.promise_date;
1689 p1_a95 := ddpx_line_rec.re_source_flag;
1690 p1_a96 := rosetta_g_miss_num_map(ddpx_line_rec.reference_customer_trx_line_id);
1691 p1_a97 := rosetta_g_miss_num_map(ddpx_line_rec.reference_header_id);
1692 p1_a98 := rosetta_g_miss_num_map(ddpx_line_rec.reference_line_id);
1693 p1_a99 := ddpx_line_rec.reference_type;
1694 p1_a100 := ddpx_line_rec.request_date;
1695 p1_a101 := rosetta_g_miss_num_map(ddpx_line_rec.request_id);
1696 p1_a102 := rosetta_g_miss_num_map(ddpx_line_rec.reserved_quantity);
1697 p1_a103 := ddpx_line_rec.return_reason_code;
1698 p1_a104 := ddpx_line_rec.rla_schedule_type_code;
1699 p1_a105 := rosetta_g_miss_num_map(ddpx_line_rec.salesrep_id);
1700 p1_a106 := ddpx_line_rec.schedule_arrival_date;
1701 p1_a107 := ddpx_line_rec.schedule_ship_date;
1702 p1_a108 := ddpx_line_rec.schedule_action_code;
1703 p1_a109 := ddpx_line_rec.schedule_status_code;
1704 p1_a110 := rosetta_g_miss_num_map(ddpx_line_rec.shipment_number);
1705 p1_a111 := ddpx_line_rec.shipment_priority_code;
1706 p1_a112 := rosetta_g_miss_num_map(ddpx_line_rec.shipped_quantity);
1707 p1_a113 := rosetta_g_miss_num_map(ddpx_line_rec.shipped_quantity2);
1708 p1_a114 := ddpx_line_rec.shipping_interfaced_flag;
1709 p1_a115 := ddpx_line_rec.shipping_method_code;
1710 p1_a116 := rosetta_g_miss_num_map(ddpx_line_rec.shipping_quantity);
1711 p1_a117 := rosetta_g_miss_num_map(ddpx_line_rec.shipping_quantity2);
1712 p1_a118 := ddpx_line_rec.shipping_quantity_uom;
1713 p1_a119 := ddpx_line_rec.shipping_quantity_uom2;
1714 p1_a120 := rosetta_g_miss_num_map(ddpx_line_rec.ship_from_org_id);
1715 p1_a121 := ddpx_line_rec.ship_model_complete_flag;
1716 p1_a122 := rosetta_g_miss_num_map(ddpx_line_rec.ship_set_id);
1717 p1_a123 := rosetta_g_miss_num_map(ddpx_line_rec.fulfillment_set_id);
1718 p1_a124 := rosetta_g_miss_num_map(ddpx_line_rec.ship_tolerance_above);
1719 p1_a125 := rosetta_g_miss_num_map(ddpx_line_rec.ship_tolerance_below);
1720 p1_a126 := rosetta_g_miss_num_map(ddpx_line_rec.ship_to_contact_id);
1721 p1_a127 := rosetta_g_miss_num_map(ddpx_line_rec.ship_to_org_id);
1722 p1_a128 := rosetta_g_miss_num_map(ddpx_line_rec.sold_to_org_id);
1723 p1_a129 := rosetta_g_miss_num_map(ddpx_line_rec.sold_from_org_id);
1724 p1_a130 := ddpx_line_rec.sort_order;
1725 p1_a131 := rosetta_g_miss_num_map(ddpx_line_rec.source_document_id);
1726 p1_a132 := rosetta_g_miss_num_map(ddpx_line_rec.source_document_line_id);
1727 p1_a133 := rosetta_g_miss_num_map(ddpx_line_rec.source_document_type_id);
1728 p1_a134 := ddpx_line_rec.source_type_code;
1729 p1_a135 := rosetta_g_miss_num_map(ddpx_line_rec.split_from_line_id);
1730 p1_a136 := rosetta_g_miss_num_map(ddpx_line_rec.task_id);
1731 p1_a137 := ddpx_line_rec.tax_code;
1732 p1_a138 := ddpx_line_rec.tax_date;
1733 p1_a139 := ddpx_line_rec.tax_exempt_flag;
1734 p1_a140 := ddpx_line_rec.tax_exempt_number;
1735 p1_a141 := ddpx_line_rec.tax_exempt_reason_code;
1736 p1_a142 := ddpx_line_rec.tax_point_code;
1737 p1_a143 := rosetta_g_miss_num_map(ddpx_line_rec.tax_rate);
1738 p1_a144 := rosetta_g_miss_num_map(ddpx_line_rec.tax_value);
1739 p1_a145 := ddpx_line_rec.top_model_line_ref;
1740 p1_a146 := rosetta_g_miss_num_map(ddpx_line_rec.top_model_line_id);
1741 p1_a147 := rosetta_g_miss_num_map(ddpx_line_rec.top_model_line_index);
1742 p1_a148 := rosetta_g_miss_num_map(ddpx_line_rec.unit_list_price);
1743 p1_a149 := rosetta_g_miss_num_map(ddpx_line_rec.unit_list_price_per_pqty);
1744 p1_a150 := rosetta_g_miss_num_map(ddpx_line_rec.unit_selling_price);
1745 p1_a151 := rosetta_g_miss_num_map(ddpx_line_rec.unit_selling_price_per_pqty);
1746 p1_a152 := rosetta_g_miss_num_map(ddpx_line_rec.veh_cus_item_cum_key_id);
1747 p1_a153 := ddpx_line_rec.visible_demand_flag;
1748 p1_a154 := ddpx_line_rec.return_status;
1749 p1_a155 := ddpx_line_rec.db_flag;
1750 p1_a156 := ddpx_line_rec.operation;
1751 p1_a157 := ddpx_line_rec.first_ack_code;
1752 p1_a158 := ddpx_line_rec.first_ack_date;
1753 p1_a159 := ddpx_line_rec.last_ack_code;
1754 p1_a160 := ddpx_line_rec.last_ack_date;
1755 p1_a161 := ddpx_line_rec.change_reason;
1756 p1_a162 := ddpx_line_rec.change_comments;
1757 p1_a163 := ddpx_line_rec.arrival_set;
1758 p1_a164 := ddpx_line_rec.ship_set;
1759 p1_a165 := ddpx_line_rec.fulfillment_set;
1760 p1_a166 := rosetta_g_miss_num_map(ddpx_line_rec.order_source_id);
1761 p1_a167 := ddpx_line_rec.orig_sys_shipment_ref;
1762 p1_a168 := ddpx_line_rec.change_sequence;
1763 p1_a169 := ddpx_line_rec.change_request_code;
1764 p1_a170 := ddpx_line_rec.status_flag;
1765 p1_a171 := ddpx_line_rec.drop_ship_flag;
1766 p1_a172 := ddpx_line_rec.customer_line_number;
1767 p1_a173 := ddpx_line_rec.customer_shipment_number;
1768 p1_a174 := rosetta_g_miss_num_map(ddpx_line_rec.customer_item_net_price);
1769 p1_a175 := rosetta_g_miss_num_map(ddpx_line_rec.customer_payment_term_id);
1770 p1_a176 := rosetta_g_miss_num_map(ddpx_line_rec.ordered_item_id);
1771 p1_a177 := ddpx_line_rec.item_identifier_type;
1772 p1_a178 := ddpx_line_rec.shipping_instructions;
1773 p1_a179 := ddpx_line_rec.packing_instructions;
1774 p1_a180 := ddpx_line_rec.calculate_price_flag;
1775 p1_a181 := rosetta_g_miss_num_map(ddpx_line_rec.invoiced_quantity);
1776 p1_a182 := ddpx_line_rec.service_txn_reason_code;
1777 p1_a183 := ddpx_line_rec.service_txn_comments;
1778 p1_a184 := rosetta_g_miss_num_map(ddpx_line_rec.service_duration);
1779 p1_a185 := ddpx_line_rec.service_period;
1780 p1_a186 := ddpx_line_rec.service_start_date;
1781 p1_a187 := ddpx_line_rec.service_end_date;
1782 p1_a188 := ddpx_line_rec.service_coterminate_flag;
1783 p1_a189 := rosetta_g_miss_num_map(ddpx_line_rec.unit_list_percent);
1784 p1_a190 := rosetta_g_miss_num_map(ddpx_line_rec.unit_selling_percent);
1785 p1_a191 := rosetta_g_miss_num_map(ddpx_line_rec.unit_percent_base_price);
1786 p1_a192 := rosetta_g_miss_num_map(ddpx_line_rec.service_number);
1787 p1_a193 := ddpx_line_rec.service_reference_type_code;
1788 p1_a194 := rosetta_g_miss_num_map(ddpx_line_rec.service_reference_line_id);
1789 p1_a195 := rosetta_g_miss_num_map(ddpx_line_rec.service_reference_system_id);
1790 p1_a196 := rosetta_g_miss_num_map(ddpx_line_rec.service_ref_order_number);
1791 p1_a197 := rosetta_g_miss_num_map(ddpx_line_rec.service_ref_line_number);
1792 p1_a198 := ddpx_line_rec.service_reference_order;
1793 p1_a199 := ddpx_line_rec.service_reference_line;
1794 p1_a200 := ddpx_line_rec.service_reference_system;
1795 p1_a201 := rosetta_g_miss_num_map(ddpx_line_rec.service_ref_shipment_number);
1796 p1_a202 := rosetta_g_miss_num_map(ddpx_line_rec.service_ref_option_number);
1797 p1_a203 := rosetta_g_miss_num_map(ddpx_line_rec.service_line_index);
1798 p1_a204 := rosetta_g_miss_num_map(ddpx_line_rec.line_set_id);
1799 p1_a205 := ddpx_line_rec.split_by;
1800 p1_a206 := ddpx_line_rec.split_action_code;
1801 p1_a207 := ddpx_line_rec.shippable_flag;
1802 p1_a208 := ddpx_line_rec.model_remnant_flag;
1803 p1_a209 := ddpx_line_rec.flow_status_code;
1804 p1_a210 := ddpx_line_rec.fulfilled_flag;
1805 p1_a211 := ddpx_line_rec.fulfillment_method_code;
1806 p1_a212 := rosetta_g_miss_num_map(ddpx_line_rec.revenue_amount);
1807 p1_a213 := rosetta_g_miss_num_map(ddpx_line_rec.marketing_source_code_id);
1808 p1_a214 := ddpx_line_rec.fulfillment_date;
1809 if ddpx_line_rec.semi_processed_flag is null
1810 then p1_a215 := null;
1811 elsif ddpx_line_rec.semi_processed_flag
1812 then p1_a215 := 1;
1813 else p1_a215 := 0;
1814 end if;
1815 p1_a216 := ddpx_line_rec.upgraded_flag;
1816 p1_a217 := rosetta_g_miss_num_map(ddpx_line_rec.lock_control);
1817 p1_a218 := ddpx_line_rec.subinventory;
1818 p1_a219 := ddpx_line_rec.split_from_line_ref;
1819 p1_a220 := ddpx_line_rec.split_from_shipment_ref;
1820 p1_a221 := ddpx_line_rec.ship_to_edi_location_code;
1821 p1_a222 := ddpx_line_rec.bill_to_edi_location_code;
1822 p1_a223 := ddpx_line_rec.ship_from_edi_location_code;
1823 p1_a224 := rosetta_g_miss_num_map(ddpx_line_rec.ship_from_address_id);
1824 p1_a225 := rosetta_g_miss_num_map(ddpx_line_rec.sold_to_address_id);
1825 p1_a226 := rosetta_g_miss_num_map(ddpx_line_rec.ship_to_address_id);
1826 p1_a227 := rosetta_g_miss_num_map(ddpx_line_rec.invoice_address_id);
1827 p1_a228 := ddpx_line_rec.ship_to_address_code;
1828 p1_a229 := rosetta_g_miss_num_map(ddpx_line_rec.original_inventory_item_id);
1829 p1_a230 := ddpx_line_rec.original_item_identifier_type;
1830 p1_a231 := rosetta_g_miss_num_map(ddpx_line_rec.original_ordered_item_id);
1831 p1_a232 := ddpx_line_rec.original_ordered_item;
1832 p1_a233 := ddpx_line_rec.item_substitution_type_code;
1833 p1_a234 := rosetta_g_miss_num_map(ddpx_line_rec.late_demand_penalty_factor);
1834 p1_a235 := ddpx_line_rec.override_atp_date_code;
1835 p1_a236 := rosetta_g_miss_num_map(ddpx_line_rec.ship_to_customer_id);
1836 p1_a237 := rosetta_g_miss_num_map(ddpx_line_rec.invoice_to_customer_id);
1837 p1_a238 := rosetta_g_miss_num_map(ddpx_line_rec.deliver_to_customer_id);
1838 p1_a239 := rosetta_g_miss_num_map(ddpx_line_rec.accounting_rule_duration);
1839 p1_a240 := rosetta_g_miss_num_map(ddpx_line_rec.unit_cost);
1840 p1_a241 := ddpx_line_rec.user_item_description;
1841 p1_a242 := ddpx_line_rec.xml_transaction_type_code;
1842 p1_a243 := rosetta_g_miss_num_map(ddpx_line_rec.item_relationship_type);
1843 p1_a244 := rosetta_g_miss_num_map(ddpx_line_rec.blanket_number);
1844 p1_a245 := rosetta_g_miss_num_map(ddpx_line_rec.blanket_line_number);
1845 p1_a246 := rosetta_g_miss_num_map(ddpx_line_rec.blanket_version_number);
1846 p1_a247 := ddpx_line_rec.cso_response_flag;
1847 p1_a248 := ddpx_line_rec.firm_demand_flag;
1848 p1_a249 := ddpx_line_rec.earliest_ship_date;
1849 p1_a250 := ddpx_line_rec.transaction_phase_code;
1850 p1_a251 := rosetta_g_miss_num_map(ddpx_line_rec.source_document_version_number);
1851 p1_a252 := rosetta_g_miss_num_map(ddpx_line_rec.minisite_id);
1852 p1_a253 := ddpx_line_rec.ib_owner;
1853 p1_a254 := ddpx_line_rec.ib_installed_at_location;
1854 p1_a255 := ddpx_line_rec.ib_current_location;
1855 p1_a256 := rosetta_g_miss_num_map(ddpx_line_rec.end_customer_id);
1856 p1_a257 := rosetta_g_miss_num_map(ddpx_line_rec.end_customer_contact_id);
1857 p1_a258 := rosetta_g_miss_num_map(ddpx_line_rec.end_customer_site_use_id);
1858 p1_a259 := ddpx_line_rec.supplier_signature;
1859 p1_a260 := ddpx_line_rec.supplier_signature_date;
1860 p1_a261 := ddpx_line_rec.customer_signature;
1861 p1_a262 := ddpx_line_rec.customer_signature_date;
1862 p1_a263 := rosetta_g_miss_num_map(ddpx_line_rec.ship_to_party_id);
1863 p1_a264 := rosetta_g_miss_num_map(ddpx_line_rec.ship_to_party_site_id);
1864 p1_a265 := rosetta_g_miss_num_map(ddpx_line_rec.ship_to_party_site_use_id);
1865 p1_a266 := rosetta_g_miss_num_map(ddpx_line_rec.deliver_to_party_id);
1866 p1_a267 := rosetta_g_miss_num_map(ddpx_line_rec.deliver_to_party_site_id);
1867 p1_a268 := rosetta_g_miss_num_map(ddpx_line_rec.deliver_to_party_site_use_id);
1868 p1_a269 := rosetta_g_miss_num_map(ddpx_line_rec.invoice_to_party_id);
1869 p1_a270 := rosetta_g_miss_num_map(ddpx_line_rec.invoice_to_party_site_id);
1870 p1_a271 := rosetta_g_miss_num_map(ddpx_line_rec.invoice_to_party_site_use_id);
1871 p1_a272 := rosetta_g_miss_num_map(ddpx_line_rec.ship_to_customer_party_id);
1872 p1_a273 := rosetta_g_miss_num_map(ddpx_line_rec.deliver_to_customer_party_id);
1873 p1_a274 := rosetta_g_miss_num_map(ddpx_line_rec.invoice_to_customer_party_id);
1874 p1_a275 := rosetta_g_miss_num_map(ddpx_line_rec.ship_to_org_contact_id);
1875 p1_a276 := rosetta_g_miss_num_map(ddpx_line_rec.deliver_to_org_contact_id);
1876 p1_a277 := rosetta_g_miss_num_map(ddpx_line_rec.invoice_to_org_contact_id);
1877 p1_a278 := rosetta_g_miss_num_map(ddpx_line_rec.retrobill_request_id);
1878 p1_a279 := rosetta_g_miss_num_map(ddpx_line_rec.original_list_price);
1879 p1_a280 := rosetta_g_miss_num_map(ddpx_line_rec.commitment_applied_amount);
1880
1881 oe_order_pub_w.rosetta_table_copy_out_p23(ddpx_line_adj_tbl, p2_a0
1882 , p2_a1
1883 , p2_a2
1884 , p2_a3
1885 , p2_a4
1886 , p2_a5
1887 , p2_a6
1888 , p2_a7
1889 , p2_a8
1890 , p2_a9
1891 , p2_a10
1892 , p2_a11
1893 , p2_a12
1894 , p2_a13
1895 , p2_a14
1896 , p2_a15
1897 , p2_a16
1898 , p2_a17
1899 , p2_a18
1900 , p2_a19
1901 , p2_a20
1902 , p2_a21
1903 , p2_a22
1904 , p2_a23
1905 , p2_a24
1906 , p2_a25
1907 , p2_a26
1908 , p2_a27
1909 , p2_a28
1910 , p2_a29
1911 , p2_a30
1912 , p2_a31
1913 , p2_a32
1914 , p2_a33
1915 , p2_a34
1916 , p2_a35
1917 , p2_a36
1918 , p2_a37
1919 , p2_a38
1920 , p2_a39
1921 , p2_a40
1922 , p2_a41
1923 , p2_a42
1924 , p2_a43
1925 , p2_a44
1926 , p2_a45
1927 , p2_a46
1928 , p2_a47
1929 , p2_a48
1930 , p2_a49
1931 , p2_a50
1932 , p2_a51
1933 , p2_a52
1934 , p2_a53
1935 , p2_a54
1936 , p2_a55
1937 , p2_a56
1938 , p2_a57
1939 , p2_a58
1940 , p2_a59
1941 , p2_a60
1942 , p2_a61
1943 , p2_a62
1944 , p2_a63
1945 , p2_a64
1946 , p2_a65
1947 , p2_a66
1948 , p2_a67
1949 , p2_a68
1950 , p2_a69
1951 , p2_a70
1952 , p2_a71
1953 , p2_a72
1954 , p2_a73
1955 , p2_a74
1956 , p2_a75
1957 , p2_a76
1958 , p2_a77
1959 , p2_a78
1960 , p2_a79
1961 , p2_a80
1962 , p2_a81
1963 , p2_a82
1964 , p2_a83
1965 , p2_a84
1966 , p2_a85
1967 , p2_a86
1968 , p2_a87
1969 , p2_a88
1970 , p2_a89
1971 , p2_a90
1972 , p2_a91
1973 , p2_a92
1974 , p2_a93
1975 , p2_a94
1976 , p2_a95
1977 , p2_a96
1978 , p2_a97
1979 , p2_a98
1980 , p2_a99
1981 , p2_a100
1982 , p2_a101
1983 , p2_a102
1984 , p2_a103
1985 , p2_a104
1986 , p2_a105
1987 , p2_a106
1988 , p2_a107
1989 , p2_a108
1990 );
1991
1992
1993
1994
1995
1996
1997 end;
1998
1999 end oe_price_order_pvt_w_obsolete;