eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.OE_PORTAL_UTIL_W

Source


1 package body oe_portal_util_w as
2   /* $Header: OERUPORB.pls 120.0 2005/06/01 01:17:44 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 get_values(p2_a0 out NOCOPY /* file.sql.39 change */  VARCHAR2
23     , p2_a1 out NOCOPY /* file.sql.39 change */  VARCHAR2
24     , p2_a2 out NOCOPY /* file.sql.39 change */  VARCHAR2
25     , p2_a3 out NOCOPY /* file.sql.39 change */  VARCHAR2
26     , p2_a4 out NOCOPY /* file.sql.39 change */  VARCHAR2
27     , p2_a5 out NOCOPY /* file.sql.39 change */  VARCHAR2
28     , p2_a6 out NOCOPY /* file.sql.39 change */  VARCHAR2
29     , p2_a7 out NOCOPY /* file.sql.39 change */  VARCHAR2
30     , p2_a8 out NOCOPY /* file.sql.39 change */  VARCHAR2
31     , p2_a9 out NOCOPY /* file.sql.39 change */  VARCHAR2
32     , p2_a10 out NOCOPY /* file.sql.39 change */  VARCHAR2
33     , p2_a11 out NOCOPY /* file.sql.39 change */  VARCHAR2
34     , p2_a12 out NOCOPY /* file.sql.39 change */  VARCHAR2
35     , p2_a13 out NOCOPY /* file.sql.39 change */  VARCHAR2
36     , p2_a14 out NOCOPY /* file.sql.39 change */  VARCHAR2
37     , p2_a15 out NOCOPY /* file.sql.39 change */  VARCHAR2
38     , p2_a16 out NOCOPY /* file.sql.39 change */  VARCHAR2
39     , p2_a17 out NOCOPY /* file.sql.39 change */  VARCHAR2
40     , p2_a18 out NOCOPY /* file.sql.39 change */  VARCHAR2
41     , p2_a19 out NOCOPY /* file.sql.39 change */  VARCHAR2
42     , p2_a20 out NOCOPY /* file.sql.39 change */  VARCHAR2
43     , p2_a21 out NOCOPY /* file.sql.39 change */  VARCHAR2
44     , p2_a22 out NOCOPY /* file.sql.39 change */  VARCHAR2
45     , p2_a23 out NOCOPY /* file.sql.39 change */  VARCHAR2
46     , p2_a24 out NOCOPY /* file.sql.39 change */  VARCHAR2
47     , p2_a25 out NOCOPY /* file.sql.39 change */  VARCHAR2
48     , p2_a26 out NOCOPY /* file.sql.39 change */  VARCHAR2
49     , p2_a27 out NOCOPY /* file.sql.39 change */  VARCHAR2
50     , p2_a28 out NOCOPY /* file.sql.39 change */  VARCHAR2
51     , p2_a29 out NOCOPY /* file.sql.39 change */  VARCHAR2
52     , p2_a30 out NOCOPY /* file.sql.39 change */  VARCHAR2
53     , p2_a31 out NOCOPY /* file.sql.39 change */  VARCHAR2
54     , p2_a32 out NOCOPY /* file.sql.39 change */  VARCHAR2
55     , p2_a33 out NOCOPY /* file.sql.39 change */  VARCHAR2
56     , p2_a34 out NOCOPY /* file.sql.39 change */  VARCHAR2
57     , p2_a35 out NOCOPY /* file.sql.39 change */  VARCHAR2
58     , p2_a36 out NOCOPY /* file.sql.39 change */  VARCHAR2
59     , p2_a37 out NOCOPY /* file.sql.39 change */  VARCHAR2
60     , p2_a38 out NOCOPY /* file.sql.39 change */  VARCHAR2
61     , p2_a39 out NOCOPY /* file.sql.39 change */  VARCHAR2
62     , p2_a40 out NOCOPY /* file.sql.39 change */  VARCHAR2
63     , p2_a41 out NOCOPY /* file.sql.39 change */  VARCHAR2
64     , p2_a42 out NOCOPY /* file.sql.39 change */  VARCHAR2
65     , p2_a43 out NOCOPY /* file.sql.39 change */  VARCHAR2
66     , p2_a44 out NOCOPY /* file.sql.39 change */  VARCHAR2
67     , p2_a45 out NOCOPY /* file.sql.39 change */  VARCHAR2
68     , p2_a46 out NOCOPY /* file.sql.39 change */  VARCHAR2
69     , p2_a47 out NOCOPY /* file.sql.39 change */  VARCHAR
70     , p2_a48 out NOCOPY /* file.sql.39 change */  VARCHAR
71     , p2_a49 out NOCOPY /* file.sql.39 change */  VARCHAR
72     , p2_a50 out NOCOPY /* file.sql.39 change */  VARCHAR2
73     , p2_a51 out NOCOPY /* file.sql.39 change */  VARCHAR2
74     , p2_a52 out NOCOPY /* file.sql.39 change */  VARCHAR2
75     , p2_a53 out NOCOPY /* file.sql.39 change */  VARCHAR2
76     , p2_a54 out NOCOPY /* file.sql.39 change */  VARCHAR2
77     , p2_a55 out NOCOPY /* file.sql.39 change */  VARCHAR2
78     , p2_a56 out NOCOPY /* file.sql.39 change */  VARCHAR2
79     , p2_a57 out NOCOPY /* file.sql.39 change */  VARCHAR2
80     , p2_a58 out NOCOPY /* file.sql.39 change */  VARCHAR2
81     , p2_a59 out NOCOPY /* file.sql.39 change */  VARCHAR2
82     , p2_a60 out NOCOPY /* file.sql.39 change */  VARCHAR2
83     , p2_a61 out NOCOPY /* file.sql.39 change */  VARCHAR2
84     , p2_a62 out NOCOPY /* file.sql.39 change */  VARCHAR2
85     , p2_a63 out NOCOPY /* file.sql.39 change */  VARCHAR2
86     , p2_a64 out NOCOPY /* file.sql.39 change */  VARCHAR2
87     , p2_a65 out NOCOPY /* file.sql.39 change */  VARCHAR2
88     , p2_a66 out NOCOPY /* file.sql.39 change */  VARCHAR2
89     , p2_a67 out NOCOPY /* file.sql.39 change */  VARCHAR2
90     , p2_a68 out NOCOPY /* file.sql.39 change */  VARCHAR2
91     , p2_a69 out NOCOPY /* file.sql.39 change */  VARCHAR2
92     , p2_a70 out NOCOPY /* file.sql.39 change */  VARCHAR2
93     , p2_a71 out NOCOPY /* file.sql.39 change */  VARCHAR2
94     , p2_a72 out NOCOPY /* file.sql.39 change */  VARCHAR2
95     , p2_a73 out NOCOPY /* file.sql.39 change */  VARCHAR2
96     , p2_a74 out NOCOPY /* file.sql.39 change */  VARCHAR2
97     , p2_a75 out NOCOPY /* file.sql.39 change */  VARCHAR2
98     , p2_a76 out NOCOPY /* file.sql.39 change */  VARCHAR2
99     , p2_a77 out NOCOPY /* file.sql.39 change */  VARCHAR2
100     , p2_a78 out NOCOPY /* file.sql.39 change */  VARCHAR2
101     , p2_a79 out NOCOPY /* file.sql.39 change */  VARCHAR2
102     , p2_a80 out NOCOPY /* file.sql.39 change */  VARCHAR2
103     , p2_a81 out NOCOPY /* file.sql.39 change */  VARCHAR2
104     , p2_a82 out NOCOPY /* file.sql.39 change */  VARCHAR2
105     , p2_a83 out NOCOPY /* file.sql.39 change */  VARCHAR2
106     , p2_a84 out NOCOPY /* file.sql.39 change */  VARCHAR2
107     , p2_a85 out NOCOPY /* file.sql.39 change */  VARCHAR2
108     , p2_a86 out NOCOPY /* file.sql.39 change */  VARCHAR2
109     , p2_a87 out NOCOPY /* file.sql.39 change */  VARCHAR2
110     , p2_a88 out NOCOPY /* file.sql.39 change */  VARCHAR2
111     , p2_a89 out NOCOPY /* file.sql.39 change */  VARCHAR2
112     , p2_a90 out NOCOPY /* file.sql.39 change */  VARCHAR2
113     , p2_a91 out NOCOPY /* file.sql.39 change */  VARCHAR2
114     , p2_a92 out NOCOPY /* file.sql.39 change */  VARCHAR2
115     , p2_a93 out NOCOPY /* file.sql.39 change */  VARCHAR2
116     , p2_a94 out NOCOPY /* file.sql.39 change */  VARCHAR2
117     , p2_a95 out NOCOPY /* file.sql.39 change */  VARCHAR2
118     , p2_a96 out NOCOPY /* file.sql.39 change */  VARCHAR2
119     , p2_a97 out NOCOPY /* file.sql.39 change */  VARCHAR2
120     , p2_a98 out NOCOPY /* file.sql.39 change */  VARCHAR2
121     , p2_a99 out NOCOPY /* file.sql.39 change */  VARCHAR2
122     , p2_a100 out NOCOPY /* file.sql.39 change */  NUMBER
123     , p2_a101 out NOCOPY /* file.sql.39 change */  NUMBER
124     , p2_a102 out NOCOPY /* file.sql.39 change */  NUMBER
125     , p2_a103 out NOCOPY /* file.sql.39 change */  VARCHAR2
126     , p2_a104 out NOCOPY /* file.sql.39 change */  VARCHAR2
127     , p2_a105 out NOCOPY /* file.sql.39 change */  VARCHAR2
128     , p2_a106 out NOCOPY /* file.sql.39 change */  VARCHAR2
129     , p2_a107 out NOCOPY /* file.sql.39 change */  VARCHAR2
130     , p2_a108 out NOCOPY /* file.sql.39 change */  VARCHAR2
131     , p2_a109 out NOCOPY /* file.sql.39 change */  VARCHAR2
132     , p2_a110 out NOCOPY /* file.sql.39 change */  VARCHAR2
133     , p2_a111 out NOCOPY /* file.sql.39 change */  VARCHAR2
134     , p2_a112 out NOCOPY /* file.sql.39 change */  VARCHAR2
135     , p2_a113 out NOCOPY /* file.sql.39 change */  VARCHAR2
136     , p2_a114 out NOCOPY /* file.sql.39 change */  VARCHAR2
137     , p2_a115 out NOCOPY /* file.sql.39 change */  VARCHAR2
138     , p2_a116 out NOCOPY /* file.sql.39 change */  VARCHAR2
139     , p2_a117 out NOCOPY /* file.sql.39 change */  VARCHAR2
140     , p2_a118 out NOCOPY /* file.sql.39 change */  VARCHAR2
141     , p2_a119 out NOCOPY /* file.sql.39 change */  VARCHAR2
142     , p2_a120 out NOCOPY /* file.sql.39 change */  VARCHAR2
143     , p2_a121 out NOCOPY /* file.sql.39 change */  VARCHAR2
144     , p2_a122 out NOCOPY /* file.sql.39 change */  VARCHAR2
145     , p2_a123 out NOCOPY /* file.sql.39 change */  VARCHAR2
146     , p2_a124 out NOCOPY /* file.sql.39 change */  VARCHAR2
147     , p2_a125 out NOCOPY /* file.sql.39 change */  VARCHAR2
148     , p2_a126 out NOCOPY /* file.sql.39 change */  VARCHAR2
149     , p2_a127 out NOCOPY /* file.sql.39 change */  VARCHAR2
150     , p2_a128 out NOCOPY /* file.sql.39 change */  VARCHAR2
151     , p2_a129 out NOCOPY /* file.sql.39 change */  VARCHAR2
152     , p2_a130 out NOCOPY /* file.sql.39 change */  VARCHAR2
153     , p2_a131 out NOCOPY /* file.sql.39 change */  VARCHAR2
154     , p2_a132 out NOCOPY /* file.sql.39 change */  VARCHAR2
155     , p2_a133 out NOCOPY /* file.sql.39 change */  VARCHAR2
156     , p2_a134 out NOCOPY /* file.sql.39 change */  VARCHAR2
157     , p2_a135 out NOCOPY /* file.sql.39 change */  VARCHAR2
158     , p2_a136 out NOCOPY /* file.sql.39 change */  VARCHAR2
159     , p2_a137 out NOCOPY /* file.sql.39 change */  VARCHAR2
160     , p2_a138 out NOCOPY /* file.sql.39 change */  VARCHAR2
161     , p2_a139 out NOCOPY /* file.sql.39 change */  VARCHAR2
162     , p2_a140 out NOCOPY /* file.sql.39 change */  VARCHAR2
163     , p2_a141 out NOCOPY /* file.sql.39 change */  VARCHAR2
164     , p0_a0  NUMBER := 0-1962.0724
165     , p0_a1  NUMBER := 0-1962.0724
166     , p0_a2  VARCHAR2 := fnd_api.g_miss_char
167     , p0_a3  VARCHAR2 := fnd_api.g_miss_char
168     , p0_a4  VARCHAR2 := fnd_api.g_miss_char
169     , p0_a5  VARCHAR2 := fnd_api.g_miss_char
170     , p0_a6  VARCHAR2 := fnd_api.g_miss_char
171     , p0_a7  VARCHAR2 := fnd_api.g_miss_char
172     , p0_a8  VARCHAR2 := fnd_api.g_miss_char
173     , p0_a9  VARCHAR2 := fnd_api.g_miss_char
174     , p0_a10  VARCHAR2 := fnd_api.g_miss_char
175     , p0_a11  VARCHAR2 := fnd_api.g_miss_char
176     , p0_a12  VARCHAR2 := fnd_api.g_miss_char
177     , p0_a13  VARCHAR2 := fnd_api.g_miss_char
178     , p0_a14  VARCHAR2 := fnd_api.g_miss_char
179     , p0_a15  VARCHAR2 := fnd_api.g_miss_char
180     , p0_a16  VARCHAR2 := fnd_api.g_miss_char
181     , p0_a17  VARCHAR2 := fnd_api.g_miss_char
182     , p0_a18  VARCHAR2 := fnd_api.g_miss_char
183     , p0_a19  VARCHAR2 := fnd_api.g_miss_char
184     , p0_a20  VARCHAR2 := fnd_api.g_miss_char
185     , p0_a21  VARCHAR2 := fnd_api.g_miss_char
186     , p0_a22  VARCHAR2 := fnd_api.g_miss_char
187     , p0_a23  VARCHAR2 := fnd_api.g_miss_char
188     , p0_a24  VARCHAR2 := fnd_api.g_miss_char
189     , p0_a25  NUMBER := 0-1962.0724
190     , p0_a26  DATE := fnd_api.g_miss_date
191     , p0_a27  VARCHAR2 := fnd_api.g_miss_char
192     , p0_a28  VARCHAR2 := fnd_api.g_miss_char
193     , p0_a29  NUMBER := 0-1962.0724
194     , p0_a30  DATE := fnd_api.g_miss_date
195     , p0_a31  VARCHAR2 := fnd_api.g_miss_char
196     , p0_a32  NUMBER := 0-1962.0724
197     , p0_a33  NUMBER := 0-1962.0724
198     , p0_a34  VARCHAR2 := fnd_api.g_miss_char
199     , p0_a35  NUMBER := 0-1962.0724
200     , p0_a36  DATE := fnd_api.g_miss_date
201     , p0_a37  VARCHAR2 := fnd_api.g_miss_char
202     , p0_a38  VARCHAR2 := fnd_api.g_miss_char
203     , p0_a39  VARCHAR2 := fnd_api.g_miss_char
204     , p0_a40  VARCHAR2 := fnd_api.g_miss_char
205     , p0_a41  VARCHAR2 := fnd_api.g_miss_char
206     , p0_a42  VARCHAR2 := fnd_api.g_miss_char
207     , p0_a43  VARCHAR2 := fnd_api.g_miss_char
208     , p0_a44  VARCHAR2 := fnd_api.g_miss_char
209     , p0_a45  VARCHAR2 := fnd_api.g_miss_char
210     , p0_a46  VARCHAR2 := fnd_api.g_miss_char
211     , p0_a47  VARCHAR2 := fnd_api.g_miss_char
212     , p0_a48  VARCHAR2 := fnd_api.g_miss_char
213     , p0_a49  VARCHAR2 := fnd_api.g_miss_char
214     , p0_a50  VARCHAR2 := fnd_api.g_miss_char
215     , p0_a51  VARCHAR2 := fnd_api.g_miss_char
216     , p0_a52  VARCHAR2 := fnd_api.g_miss_char
217     , p0_a53  VARCHAR2 := fnd_api.g_miss_char
218     , p0_a54  VARCHAR2 := fnd_api.g_miss_char
219     , p0_a55  VARCHAR2 := fnd_api.g_miss_char
220     , p0_a56  VARCHAR2 := fnd_api.g_miss_char
221     , p0_a57  VARCHAR2 := fnd_api.g_miss_char
222     , p0_a58  VARCHAR2 := fnd_api.g_miss_char
223     , p0_a59  VARCHAR2 := fnd_api.g_miss_char
224     , p0_a60  VARCHAR2 := fnd_api.g_miss_char
225     , p0_a61  VARCHAR2 := fnd_api.g_miss_char
226     , p0_a62  VARCHAR2 := fnd_api.g_miss_char
227     , p0_a63  VARCHAR2 := fnd_api.g_miss_char
228     , p0_a64  VARCHAR2 := fnd_api.g_miss_char
229     , p0_a65  VARCHAR2 := fnd_api.g_miss_char
230     , p0_a66  VARCHAR2 := fnd_api.g_miss_char
231     , p0_a67  VARCHAR2 := fnd_api.g_miss_char
232     , p0_a68  VARCHAR2 := fnd_api.g_miss_char
233     , p0_a69  VARCHAR2 := fnd_api.g_miss_char
234     , p0_a70  VARCHAR2 := fnd_api.g_miss_char
235     , p0_a71  VARCHAR2 := fnd_api.g_miss_char
236     , p0_a72  VARCHAR2 := fnd_api.g_miss_char
237     , p0_a73  VARCHAR2 := fnd_api.g_miss_char
238     , p0_a74  VARCHAR2 := fnd_api.g_miss_char
239     , p0_a75  VARCHAR2 := fnd_api.g_miss_char
240     , p0_a76  VARCHAR2 := fnd_api.g_miss_char
241     , p0_a77  NUMBER := 0-1962.0724
242     , p0_a78  NUMBER := 0-1962.0724
243     , p0_a79  NUMBER := 0-1962.0724
244     , p0_a80  NUMBER := 0-1962.0724
245     , p0_a81  NUMBER := 0-1962.0724
246     , p0_a82  DATE := fnd_api.g_miss_date
247     , p0_a83  NUMBER := 0-1962.0724
248     , p0_a84  NUMBER := 0-1962.0724
249     , p0_a85  VARCHAR2 := fnd_api.g_miss_char
250     , p0_a86  VARCHAR2 := fnd_api.g_miss_char
251     , p0_a87  DATE := fnd_api.g_miss_date
252     , p0_a88  VARCHAR2 := fnd_api.g_miss_char
253     , p0_a89  NUMBER := 0-1962.0724
254     , p0_a90  NUMBER := 0-1962.0724
255     , p0_a91  NUMBER := 0-1962.0724
256     , p0_a92  NUMBER := 0-1962.0724
257     , p0_a93  VARCHAR2 := fnd_api.g_miss_char
258     , p0_a94  VARCHAR2 := fnd_api.g_miss_char
259     , p0_a95  NUMBER := 0-1962.0724
260     , p0_a96  NUMBER := 0-1962.0724
261     , p0_a97  VARCHAR2 := fnd_api.g_miss_char
262     , p0_a98  DATE := fnd_api.g_miss_date
263     , p0_a99  NUMBER := 0-1962.0724
264     , p0_a100  NUMBER := 0-1962.0724
265     , p0_a101  DATE := fnd_api.g_miss_date
266     , p0_a102  DATE := fnd_api.g_miss_date
267     , p0_a103  NUMBER := 0-1962.0724
268     , p0_a104  VARCHAR2 := fnd_api.g_miss_char
269     , p0_a105  NUMBER := 0-1962.0724
270     , p0_a106  VARCHAR2 := fnd_api.g_miss_char
271     , p0_a107  VARCHAR2 := fnd_api.g_miss_char
272     , p0_a108  VARCHAR2 := fnd_api.g_miss_char
273     , p0_a109  NUMBER := 0-1962.0724
274     , p0_a110  NUMBER := 0-1962.0724
275     , p0_a111  NUMBER := 0-1962.0724
276     , p0_a112  NUMBER := 0-1962.0724
277     , p0_a113  NUMBER := 0-1962.0724
278     , p0_a114  NUMBER := 0-1962.0724
279     , p0_a115  NUMBER := 0-1962.0724
280     , p0_a116  NUMBER := 0-1962.0724
281     , p0_a117  NUMBER := 0-1962.0724
282     , p0_a118  NUMBER := 0-1962.0724
283     , p0_a119  NUMBER := 0-1962.0724
284     , p0_a120  VARCHAR2 := fnd_api.g_miss_char
285     , p0_a121  VARCHAR2 := fnd_api.g_miss_char
286     , p0_a122  VARCHAR2 := fnd_api.g_miss_char
287     , p0_a123  VARCHAR2 := fnd_api.g_miss_char
288     , p0_a124  VARCHAR2 := fnd_api.g_miss_char
289     , p0_a125  NUMBER := 0-1962.0724
290     , p0_a126  VARCHAR2 := fnd_api.g_miss_char
291     , p0_a127  VARCHAR2 := fnd_api.g_miss_char
292     , p0_a128  VARCHAR2 := fnd_api.g_miss_char
293     , p0_a129  VARCHAR2 := fnd_api.g_miss_char
294     , p0_a130  DATE := fnd_api.g_miss_date
295     , p0_a131  VARCHAR2 := fnd_api.g_miss_char
296     , p0_a132  DATE := fnd_api.g_miss_date
297     , p0_a133  VARCHAR2 := fnd_api.g_miss_char
298     , p0_a134  VARCHAR2 := fnd_api.g_miss_char
299     , p0_a135  VARCHAR2 := fnd_api.g_miss_char
300     , p0_a136  VARCHAR2 := fnd_api.g_miss_char
301     , p0_a137  VARCHAR2 := fnd_api.g_miss_char
302     , p0_a138  VARCHAR2 := fnd_api.g_miss_char
303     , p0_a139  VARCHAR2 := fnd_api.g_miss_char
304     , p0_a140  VARCHAR2 := fnd_api.g_miss_char
305     , p0_a141  NUMBER := 0-1962.0724
306     , p0_a142  VARCHAR2 := fnd_api.g_miss_char
307     , p0_a143  NUMBER := 0-1962.0724
308     , p0_a144  VARCHAR2 := fnd_api.g_miss_char
309     , p0_a145  VARCHAR2 := fnd_api.g_miss_char
310     , p0_a146  VARCHAR2 := fnd_api.g_miss_char
311     , p0_a147  VARCHAR2 := fnd_api.g_miss_char
312     , p0_a148  DATE := fnd_api.g_miss_date
313     , p0_a149  VARCHAR2 := fnd_api.g_miss_char
314     , p0_a150  DATE := fnd_api.g_miss_date
315     , p0_a151  VARCHAR2 := fnd_api.g_miss_char
316     , p0_a152  VARCHAR2 := fnd_api.g_miss_char
317     , p0_a153  VARCHAR2 := fnd_api.g_miss_char
318     , p0_a154  DATE := fnd_api.g_miss_date
319     , p0_a155  NUMBER := 0-1962.0724
320     , p0_a156  VARCHAR2 := fnd_api.g_miss_char
321     , p0_a157  NUMBER := 0-1962.0724
322     , p0_a158  VARCHAR2 := fnd_api.g_miss_char
323     , p0_a159  VARCHAR2 := fnd_api.g_miss_char
324     , p0_a160  VARCHAR2 := fnd_api.g_miss_char
325     , p0_a161  VARCHAR2 := fnd_api.g_miss_char
326     , p0_a162  NUMBER := 0-1962.0724
327     , p0_a163  NUMBER := 0-1962.0724
328     , p0_a164  NUMBER := 0-1962.0724
329     , p0_a165  NUMBER := 0-1962.0724
330     , p0_a166  VARCHAR2 := fnd_api.g_miss_char
331     , p0_a167  NUMBER := 0-1962.0724
332     , p0_a168  NUMBER := 0-1962.0724
333     , p0_a169  NUMBER := 0-1962.0724
334     , p0_a170  NUMBER := 0-1962.0724
335     , p0_a171  NUMBER := 0-1962.0724
336     , p0_a172  VARCHAR2 := fnd_api.g_miss_char
337     , p0_a173  NUMBER := 0-1962.0724
338     , p0_a174  VARCHAR2 := fnd_api.g_miss_char
339     , p0_a175  VARCHAR2 := fnd_api.g_miss_char
340     , p0_a176  VARCHAR2 := fnd_api.g_miss_char
341     , p0_a177  DATE := fnd_api.g_miss_date
342     , p0_a178  NUMBER := 0-1962.0724
343     , p0_a179  VARCHAR2 := fnd_api.g_miss_char
344     , p0_a180  VARCHAR2 := fnd_api.g_miss_char
345     , p0_a181  VARCHAR2 := fnd_api.g_miss_char
346     , p0_a182  VARCHAR2 := fnd_api.g_miss_char
347     , p0_a183  NUMBER := 0-1962.0724
348     , p0_a184  NUMBER := 0-1962.0724
349     , p0_a185  NUMBER := 0-1962.0724
350     , p0_a186  VARCHAR2 := fnd_api.g_miss_char
351     , p0_a187  VARCHAR2 := fnd_api.g_miss_char
352     , p0_a188  VARCHAR2 := fnd_api.g_miss_char
353     , p0_a189  NUMBER := 0-1962.0724
354     , p0_a190  NUMBER := 0-1962.0724
355     , p0_a191  NUMBER := 0-1962.0724
356     , p0_a192  VARCHAR2 := fnd_api.g_miss_char
357     , p0_a193  DATE := fnd_api.g_miss_date
358     , p0_a194  VARCHAR2 := fnd_api.g_miss_char
359     , p0_a195  DATE := fnd_api.g_miss_date
360     , p0_a196  NUMBER := 0-1962.0724
361     , p0_a197  NUMBER := 0-1962.0724
362     , p0_a198  NUMBER := 0-1962.0724
363     , p0_a199  NUMBER := 0-1962.0724
364     , p0_a200  NUMBER := 0-1962.0724
365     , p0_a201  NUMBER := 0-1962.0724
366     , p0_a202  NUMBER := 0-1962.0724
367     , p0_a203  NUMBER := 0-1962.0724
368     , p0_a204  NUMBER := 0-1962.0724
369     , p0_a205  NUMBER := 0-1962.0724
370     , p0_a206  NUMBER := 0-1962.0724
371     , p0_a207  NUMBER := 0-1962.0724
372     , p0_a208  NUMBER := 0-1962.0724
373     , p0_a209  NUMBER := 0-1962.0724
374     , p0_a210  NUMBER := 0-1962.0724
375     , p0_a211  NUMBER := 0-1962.0724
376     , p0_a212  NUMBER := 0-1962.0724
377     , p0_a213  NUMBER := 0-1962.0724
378     , p0_a214  VARCHAR2 := fnd_api.g_miss_char
379     , p0_a215  NUMBER := 0-1962.0724
380     , p1_a0  NUMBER := 0-1962.0724
381     , p1_a1  NUMBER := 0-1962.0724
382     , p1_a2  VARCHAR2 := fnd_api.g_miss_char
383     , p1_a3  VARCHAR2 := fnd_api.g_miss_char
384     , p1_a4  VARCHAR2 := fnd_api.g_miss_char
385     , p1_a5  VARCHAR2 := fnd_api.g_miss_char
386     , p1_a6  VARCHAR2 := fnd_api.g_miss_char
387     , p1_a7  VARCHAR2 := fnd_api.g_miss_char
388     , p1_a8  VARCHAR2 := fnd_api.g_miss_char
389     , p1_a9  VARCHAR2 := fnd_api.g_miss_char
390     , p1_a10  VARCHAR2 := fnd_api.g_miss_char
391     , p1_a11  VARCHAR2 := fnd_api.g_miss_char
392     , p1_a12  VARCHAR2 := fnd_api.g_miss_char
393     , p1_a13  VARCHAR2 := fnd_api.g_miss_char
394     , p1_a14  VARCHAR2 := fnd_api.g_miss_char
395     , p1_a15  VARCHAR2 := fnd_api.g_miss_char
396     , p1_a16  VARCHAR2 := fnd_api.g_miss_char
397     , p1_a17  VARCHAR2 := fnd_api.g_miss_char
398     , p1_a18  VARCHAR2 := fnd_api.g_miss_char
399     , p1_a19  VARCHAR2 := fnd_api.g_miss_char
400     , p1_a20  VARCHAR2 := fnd_api.g_miss_char
401     , p1_a21  VARCHAR2 := fnd_api.g_miss_char
402     , p1_a22  VARCHAR2 := fnd_api.g_miss_char
403     , p1_a23  VARCHAR2 := fnd_api.g_miss_char
404     , p1_a24  VARCHAR2 := fnd_api.g_miss_char
405     , p1_a25  NUMBER := 0-1962.0724
406     , p1_a26  DATE := fnd_api.g_miss_date
407     , p1_a27  VARCHAR2 := fnd_api.g_miss_char
408     , p1_a28  VARCHAR2 := fnd_api.g_miss_char
409     , p1_a29  NUMBER := 0-1962.0724
410     , p1_a30  DATE := fnd_api.g_miss_date
411     , p1_a31  VARCHAR2 := fnd_api.g_miss_char
412     , p1_a32  NUMBER := 0-1962.0724
413     , p1_a33  NUMBER := 0-1962.0724
414     , p1_a34  VARCHAR2 := fnd_api.g_miss_char
415     , p1_a35  NUMBER := 0-1962.0724
416     , p1_a36  DATE := fnd_api.g_miss_date
417     , p1_a37  VARCHAR2 := fnd_api.g_miss_char
418     , p1_a38  VARCHAR2 := fnd_api.g_miss_char
419     , p1_a39  VARCHAR2 := fnd_api.g_miss_char
420     , p1_a40  VARCHAR2 := fnd_api.g_miss_char
421     , p1_a41  VARCHAR2 := fnd_api.g_miss_char
422     , p1_a42  VARCHAR2 := fnd_api.g_miss_char
423     , p1_a43  VARCHAR2 := fnd_api.g_miss_char
424     , p1_a44  VARCHAR2 := fnd_api.g_miss_char
425     , p1_a45  VARCHAR2 := fnd_api.g_miss_char
426     , p1_a46  VARCHAR2 := fnd_api.g_miss_char
427     , p1_a47  VARCHAR2 := fnd_api.g_miss_char
428     , p1_a48  VARCHAR2 := fnd_api.g_miss_char
429     , p1_a49  VARCHAR2 := fnd_api.g_miss_char
430     , p1_a50  VARCHAR2 := fnd_api.g_miss_char
431     , p1_a51  VARCHAR2 := fnd_api.g_miss_char
432     , p1_a52  VARCHAR2 := fnd_api.g_miss_char
433     , p1_a53  VARCHAR2 := fnd_api.g_miss_char
434     , p1_a54  VARCHAR2 := fnd_api.g_miss_char
435     , p1_a55  VARCHAR2 := fnd_api.g_miss_char
436     , p1_a56  VARCHAR2 := fnd_api.g_miss_char
437     , p1_a57  VARCHAR2 := fnd_api.g_miss_char
438     , p1_a58  VARCHAR2 := fnd_api.g_miss_char
439     , p1_a59  VARCHAR2 := fnd_api.g_miss_char
440     , p1_a60  VARCHAR2 := fnd_api.g_miss_char
441     , p1_a61  VARCHAR2 := fnd_api.g_miss_char
442     , p1_a62  VARCHAR2 := fnd_api.g_miss_char
443     , p1_a63  VARCHAR2 := fnd_api.g_miss_char
444     , p1_a64  VARCHAR2 := fnd_api.g_miss_char
445     , p1_a65  VARCHAR2 := fnd_api.g_miss_char
446     , p1_a66  VARCHAR2 := fnd_api.g_miss_char
447     , p1_a67  VARCHAR2 := fnd_api.g_miss_char
448     , p1_a68  VARCHAR2 := fnd_api.g_miss_char
449     , p1_a69  VARCHAR2 := fnd_api.g_miss_char
450     , p1_a70  VARCHAR2 := fnd_api.g_miss_char
451     , p1_a71  VARCHAR2 := fnd_api.g_miss_char
452     , p1_a72  VARCHAR2 := fnd_api.g_miss_char
453     , p1_a73  VARCHAR2 := fnd_api.g_miss_char
454     , p1_a74  VARCHAR2 := fnd_api.g_miss_char
455     , p1_a75  VARCHAR2 := fnd_api.g_miss_char
456     , p1_a76  VARCHAR2 := fnd_api.g_miss_char
457     , p1_a77  NUMBER := 0-1962.0724
458     , p1_a78  NUMBER := 0-1962.0724
459     , p1_a79  NUMBER := 0-1962.0724
460     , p1_a80  NUMBER := 0-1962.0724
461     , p1_a81  NUMBER := 0-1962.0724
462     , p1_a82  DATE := fnd_api.g_miss_date
463     , p1_a83  NUMBER := 0-1962.0724
464     , p1_a84  NUMBER := 0-1962.0724
465     , p1_a85  VARCHAR2 := fnd_api.g_miss_char
466     , p1_a86  VARCHAR2 := fnd_api.g_miss_char
467     , p1_a87  DATE := fnd_api.g_miss_date
468     , p1_a88  VARCHAR2 := fnd_api.g_miss_char
469     , p1_a89  NUMBER := 0-1962.0724
470     , p1_a90  NUMBER := 0-1962.0724
471     , p1_a91  NUMBER := 0-1962.0724
472     , p1_a92  NUMBER := 0-1962.0724
473     , p1_a93  VARCHAR2 := fnd_api.g_miss_char
474     , p1_a94  VARCHAR2 := fnd_api.g_miss_char
475     , p1_a95  NUMBER := 0-1962.0724
476     , p1_a96  NUMBER := 0-1962.0724
477     , p1_a97  VARCHAR2 := fnd_api.g_miss_char
478     , p1_a98  DATE := fnd_api.g_miss_date
479     , p1_a99  NUMBER := 0-1962.0724
480     , p1_a100  NUMBER := 0-1962.0724
481     , p1_a101  DATE := fnd_api.g_miss_date
482     , p1_a102  DATE := fnd_api.g_miss_date
483     , p1_a103  NUMBER := 0-1962.0724
484     , p1_a104  VARCHAR2 := fnd_api.g_miss_char
485     , p1_a105  NUMBER := 0-1962.0724
486     , p1_a106  VARCHAR2 := fnd_api.g_miss_char
487     , p1_a107  VARCHAR2 := fnd_api.g_miss_char
488     , p1_a108  VARCHAR2 := fnd_api.g_miss_char
489     , p1_a109  NUMBER := 0-1962.0724
490     , p1_a110  NUMBER := 0-1962.0724
491     , p1_a111  NUMBER := 0-1962.0724
492     , p1_a112  NUMBER := 0-1962.0724
493     , p1_a113  NUMBER := 0-1962.0724
494     , p1_a114  NUMBER := 0-1962.0724
495     , p1_a115  NUMBER := 0-1962.0724
496     , p1_a116  NUMBER := 0-1962.0724
497     , p1_a117  NUMBER := 0-1962.0724
498     , p1_a118  NUMBER := 0-1962.0724
499     , p1_a119  NUMBER := 0-1962.0724
500     , p1_a120  VARCHAR2 := fnd_api.g_miss_char
501     , p1_a121  VARCHAR2 := fnd_api.g_miss_char
502     , p1_a122  VARCHAR2 := fnd_api.g_miss_char
503     , p1_a123  VARCHAR2 := fnd_api.g_miss_char
504     , p1_a124  VARCHAR2 := fnd_api.g_miss_char
505     , p1_a125  NUMBER := 0-1962.0724
506     , p1_a126  VARCHAR2 := fnd_api.g_miss_char
507     , p1_a127  VARCHAR2 := fnd_api.g_miss_char
508     , p1_a128  VARCHAR2 := fnd_api.g_miss_char
509     , p1_a129  VARCHAR2 := fnd_api.g_miss_char
510     , p1_a130  DATE := fnd_api.g_miss_date
511     , p1_a131  VARCHAR2 := fnd_api.g_miss_char
512     , p1_a132  DATE := fnd_api.g_miss_date
513     , p1_a133  VARCHAR2 := fnd_api.g_miss_char
514     , p1_a134  VARCHAR2 := fnd_api.g_miss_char
515     , p1_a135  VARCHAR2 := fnd_api.g_miss_char
516     , p1_a136  VARCHAR2 := fnd_api.g_miss_char
517     , p1_a137  VARCHAR2 := fnd_api.g_miss_char
518     , p1_a138  VARCHAR2 := fnd_api.g_miss_char
519     , p1_a139  VARCHAR2 := fnd_api.g_miss_char
520     , p1_a140  VARCHAR2 := fnd_api.g_miss_char
521     , p1_a141  NUMBER := 0-1962.0724
522     , p1_a142  VARCHAR2 := fnd_api.g_miss_char
523     , p1_a143  NUMBER := 0-1962.0724
524     , p1_a144  VARCHAR2 := fnd_api.g_miss_char
525     , p1_a145  VARCHAR2 := fnd_api.g_miss_char
526     , p1_a146  VARCHAR2 := fnd_api.g_miss_char
527     , p1_a147  VARCHAR2 := fnd_api.g_miss_char
528     , p1_a148  DATE := fnd_api.g_miss_date
529     , p1_a149  VARCHAR2 := fnd_api.g_miss_char
530     , p1_a150  DATE := fnd_api.g_miss_date
531     , p1_a151  VARCHAR2 := fnd_api.g_miss_char
532     , p1_a152  VARCHAR2 := fnd_api.g_miss_char
533     , p1_a153  VARCHAR2 := fnd_api.g_miss_char
534     , p1_a154  DATE := fnd_api.g_miss_date
535     , p1_a155  NUMBER := 0-1962.0724
536     , p1_a156  VARCHAR2 := fnd_api.g_miss_char
537     , p1_a157  NUMBER := 0-1962.0724
538     , p1_a158  VARCHAR2 := fnd_api.g_miss_char
539     , p1_a159  VARCHAR2 := fnd_api.g_miss_char
540     , p1_a160  VARCHAR2 := fnd_api.g_miss_char
541     , p1_a161  VARCHAR2 := fnd_api.g_miss_char
542     , p1_a162  NUMBER := 0-1962.0724
543     , p1_a163  NUMBER := 0-1962.0724
544     , p1_a164  NUMBER := 0-1962.0724
545     , p1_a165  NUMBER := 0-1962.0724
546     , p1_a166  VARCHAR2 := fnd_api.g_miss_char
547     , p1_a167  NUMBER := 0-1962.0724
548     , p1_a168  NUMBER := 0-1962.0724
549     , p1_a169  NUMBER := 0-1962.0724
550     , p1_a170  NUMBER := 0-1962.0724
551     , p1_a171  NUMBER := 0-1962.0724
552     , p1_a172  VARCHAR2 := fnd_api.g_miss_char
553     , p1_a173  NUMBER := 0-1962.0724
554     , p1_a174  VARCHAR2 := fnd_api.g_miss_char
555     , p1_a175  VARCHAR2 := fnd_api.g_miss_char
556     , p1_a176  VARCHAR2 := fnd_api.g_miss_char
557     , p1_a177  DATE := fnd_api.g_miss_date
558     , p1_a178  NUMBER := 0-1962.0724
559     , p1_a179  VARCHAR2 := fnd_api.g_miss_char
560     , p1_a180  VARCHAR2 := fnd_api.g_miss_char
561     , p1_a181  VARCHAR2 := fnd_api.g_miss_char
562     , p1_a182  VARCHAR2 := fnd_api.g_miss_char
563     , p1_a183  NUMBER := 0-1962.0724
564     , p1_a184  NUMBER := 0-1962.0724
565     , p1_a185  NUMBER := 0-1962.0724
566     , p1_a186  VARCHAR2 := fnd_api.g_miss_char
567     , p1_a187  VARCHAR2 := fnd_api.g_miss_char
568     , p1_a188  VARCHAR2 := fnd_api.g_miss_char
569     , p1_a189  NUMBER := 0-1962.0724
570     , p1_a190  NUMBER := 0-1962.0724
571     , p1_a191  NUMBER := 0-1962.0724
572     , p1_a192  VARCHAR2 := fnd_api.g_miss_char
573     , p1_a193  DATE := fnd_api.g_miss_date
574     , p1_a194  VARCHAR2 := fnd_api.g_miss_char
575     , p1_a195  DATE := fnd_api.g_miss_date
576     , p1_a196  NUMBER := 0-1962.0724
577     , p1_a197  NUMBER := 0-1962.0724
578     , p1_a198  NUMBER := 0-1962.0724
579     , p1_a199  NUMBER := 0-1962.0724
580     , p1_a200  NUMBER := 0-1962.0724
581     , p1_a201  NUMBER := 0-1962.0724
582     , p1_a202  NUMBER := 0-1962.0724
583     , p1_a203  NUMBER := 0-1962.0724
584     , p1_a204  NUMBER := 0-1962.0724
585     , p1_a205  NUMBER := 0-1962.0724
586     , p1_a206  NUMBER := 0-1962.0724
587     , p1_a207  NUMBER := 0-1962.0724
588     , p1_a208  NUMBER := 0-1962.0724
589     , p1_a209  NUMBER := 0-1962.0724
590     , p1_a210  NUMBER := 0-1962.0724
591     , p1_a211  NUMBER := 0-1962.0724
592     , p1_a212  NUMBER := 0-1962.0724
593     , p1_a213  NUMBER := 0-1962.0724
594     , p1_a214  VARCHAR2 := fnd_api.g_miss_char
595     , p1_a215  NUMBER := 0-1962.0724
596   )
597 
598   as
599     ddp_header_rec oe_order_pub.header_rec_type;
600     ddp_old_header_rec oe_order_pub.header_rec_type;
601     ddx_header_val_rec_type oe_order_pub.header_val_rec_type;
602     ddindx binary_integer; indx binary_integer;
603   begin
604 
605     -- copy data to the local IN or IN-OUT args, if any
606     ddp_header_rec.accounting_rule_id := rosetta_g_miss_num_map(p0_a0);
607     ddp_header_rec.agreement_id := rosetta_g_miss_num_map(p0_a1);
608     ddp_header_rec.attribute1 := p0_a2;
609     ddp_header_rec.attribute10 := p0_a3;
610     ddp_header_rec.attribute11 := p0_a4;
611     ddp_header_rec.attribute12 := p0_a5;
612     ddp_header_rec.attribute13 := p0_a6;
613     ddp_header_rec.attribute14 := p0_a7;
614     ddp_header_rec.attribute15 := p0_a8;
615     ddp_header_rec.attribute16 := p0_a9;
616     ddp_header_rec.attribute17 := p0_a10;
617     ddp_header_rec.attribute18 := p0_a11;
618     ddp_header_rec.attribute19 := p0_a12;
619     ddp_header_rec.attribute2 := p0_a13;
620     ddp_header_rec.attribute20 := p0_a14;
621     ddp_header_rec.attribute3 := p0_a15;
622     ddp_header_rec.attribute4 := p0_a16;
623     ddp_header_rec.attribute5 := p0_a17;
624     ddp_header_rec.attribute6 := p0_a18;
625     ddp_header_rec.attribute7 := p0_a19;
626     ddp_header_rec.attribute8 := p0_a20;
627     ddp_header_rec.attribute9 := p0_a21;
628     ddp_header_rec.booked_flag := p0_a22;
629     ddp_header_rec.cancelled_flag := p0_a23;
630     ddp_header_rec.context := p0_a24;
631     ddp_header_rec.conversion_rate := rosetta_g_miss_num_map(p0_a25);
632     ddp_header_rec.conversion_rate_date := rosetta_g_miss_date_in_map(p0_a26);
633     ddp_header_rec.conversion_type_code := p0_a27;
634     ddp_header_rec.customer_preference_set_code := p0_a28;
635     ddp_header_rec.created_by := rosetta_g_miss_num_map(p0_a29);
636     ddp_header_rec.creation_date := rosetta_g_miss_date_in_map(p0_a30);
637     ddp_header_rec.cust_po_number := p0_a31;
638     ddp_header_rec.deliver_to_contact_id := rosetta_g_miss_num_map(p0_a32);
639     ddp_header_rec.deliver_to_org_id := rosetta_g_miss_num_map(p0_a33);
640     ddp_header_rec.demand_class_code := p0_a34;
641     ddp_header_rec.earliest_schedule_limit := rosetta_g_miss_num_map(p0_a35);
642     ddp_header_rec.expiration_date := rosetta_g_miss_date_in_map(p0_a36);
643     ddp_header_rec.fob_point_code := p0_a37;
644     ddp_header_rec.freight_carrier_code := p0_a38;
645     ddp_header_rec.freight_terms_code := p0_a39;
646     ddp_header_rec.global_attribute1 := p0_a40;
647     ddp_header_rec.global_attribute10 := p0_a41;
648     ddp_header_rec.global_attribute11 := p0_a42;
649     ddp_header_rec.global_attribute12 := p0_a43;
650     ddp_header_rec.global_attribute13 := p0_a44;
651     ddp_header_rec.global_attribute14 := p0_a45;
652     ddp_header_rec.global_attribute15 := p0_a46;
653     ddp_header_rec.global_attribute16 := p0_a47;
654     ddp_header_rec.global_attribute17 := p0_a48;
655     ddp_header_rec.global_attribute18 := p0_a49;
656     ddp_header_rec.global_attribute19 := p0_a50;
657     ddp_header_rec.global_attribute2 := p0_a51;
658     ddp_header_rec.global_attribute20 := p0_a52;
659     ddp_header_rec.global_attribute3 := p0_a53;
660     ddp_header_rec.global_attribute4 := p0_a54;
661     ddp_header_rec.global_attribute5 := p0_a55;
662     ddp_header_rec.global_attribute6 := p0_a56;
663     ddp_header_rec.global_attribute7 := p0_a57;
664     ddp_header_rec.global_attribute8 := p0_a58;
665     ddp_header_rec.global_attribute9 := p0_a59;
666     ddp_header_rec.global_attribute_category := p0_a60;
667     ddp_header_rec.tp_context := p0_a61;
668     ddp_header_rec.tp_attribute1 := p0_a62;
669     ddp_header_rec.tp_attribute2 := p0_a63;
670     ddp_header_rec.tp_attribute3 := p0_a64;
671     ddp_header_rec.tp_attribute4 := p0_a65;
672     ddp_header_rec.tp_attribute5 := p0_a66;
673     ddp_header_rec.tp_attribute6 := p0_a67;
674     ddp_header_rec.tp_attribute7 := p0_a68;
675     ddp_header_rec.tp_attribute8 := p0_a69;
676     ddp_header_rec.tp_attribute9 := p0_a70;
677     ddp_header_rec.tp_attribute10 := p0_a71;
678     ddp_header_rec.tp_attribute11 := p0_a72;
679     ddp_header_rec.tp_attribute12 := p0_a73;
680     ddp_header_rec.tp_attribute13 := p0_a74;
681     ddp_header_rec.tp_attribute14 := p0_a75;
682     ddp_header_rec.tp_attribute15 := p0_a76;
683     ddp_header_rec.header_id := rosetta_g_miss_num_map(p0_a77);
684     ddp_header_rec.invoice_to_contact_id := rosetta_g_miss_num_map(p0_a78);
685     ddp_header_rec.invoice_to_org_id := rosetta_g_miss_num_map(p0_a79);
686     ddp_header_rec.invoicing_rule_id := rosetta_g_miss_num_map(p0_a80);
687     ddp_header_rec.last_updated_by := rosetta_g_miss_num_map(p0_a81);
688     ddp_header_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a82);
689     ddp_header_rec.last_update_login := rosetta_g_miss_num_map(p0_a83);
690     ddp_header_rec.latest_schedule_limit := rosetta_g_miss_num_map(p0_a84);
691     ddp_header_rec.open_flag := p0_a85;
692     ddp_header_rec.order_category_code := p0_a86;
693     ddp_header_rec.ordered_date := rosetta_g_miss_date_in_map(p0_a87);
694     ddp_header_rec.order_date_type_code := p0_a88;
695     ddp_header_rec.order_number := rosetta_g_miss_num_map(p0_a89);
696     ddp_header_rec.order_source_id := rosetta_g_miss_num_map(p0_a90);
697     ddp_header_rec.order_type_id := rosetta_g_miss_num_map(p0_a91);
698     ddp_header_rec.org_id := rosetta_g_miss_num_map(p0_a92);
699     ddp_header_rec.orig_sys_document_ref := p0_a93;
700     ddp_header_rec.partial_shipments_allowed := p0_a94;
701     ddp_header_rec.payment_term_id := rosetta_g_miss_num_map(p0_a95);
702     ddp_header_rec.price_list_id := rosetta_g_miss_num_map(p0_a96);
703     ddp_header_rec.price_request_code := p0_a97;
704     ddp_header_rec.pricing_date := rosetta_g_miss_date_in_map(p0_a98);
705     ddp_header_rec.program_application_id := rosetta_g_miss_num_map(p0_a99);
706     ddp_header_rec.program_id := rosetta_g_miss_num_map(p0_a100);
707     ddp_header_rec.program_update_date := rosetta_g_miss_date_in_map(p0_a101);
708     ddp_header_rec.request_date := rosetta_g_miss_date_in_map(p0_a102);
709     ddp_header_rec.request_id := rosetta_g_miss_num_map(p0_a103);
710     ddp_header_rec.return_reason_code := p0_a104;
711     ddp_header_rec.salesrep_id := rosetta_g_miss_num_map(p0_a105);
712     ddp_header_rec.sales_channel_code := p0_a106;
713     ddp_header_rec.shipment_priority_code := p0_a107;
714     ddp_header_rec.shipping_method_code := p0_a108;
715     ddp_header_rec.ship_from_org_id := rosetta_g_miss_num_map(p0_a109);
716     ddp_header_rec.ship_tolerance_above := rosetta_g_miss_num_map(p0_a110);
717     ddp_header_rec.ship_tolerance_below := rosetta_g_miss_num_map(p0_a111);
718     ddp_header_rec.ship_to_contact_id := rosetta_g_miss_num_map(p0_a112);
719     ddp_header_rec.ship_to_org_id := rosetta_g_miss_num_map(p0_a113);
720     ddp_header_rec.sold_from_org_id := rosetta_g_miss_num_map(p0_a114);
721     ddp_header_rec.sold_to_contact_id := rosetta_g_miss_num_map(p0_a115);
722     ddp_header_rec.sold_to_org_id := rosetta_g_miss_num_map(p0_a116);
723     ddp_header_rec.sold_to_phone_id := rosetta_g_miss_num_map(p0_a117);
724     ddp_header_rec.source_document_id := rosetta_g_miss_num_map(p0_a118);
725     ddp_header_rec.source_document_type_id := rosetta_g_miss_num_map(p0_a119);
726     ddp_header_rec.tax_exempt_flag := p0_a120;
727     ddp_header_rec.tax_exempt_number := p0_a121;
728     ddp_header_rec.tax_exempt_reason_code := p0_a122;
729     ddp_header_rec.tax_point_code := p0_a123;
730     ddp_header_rec.transactional_curr_code := p0_a124;
731     ddp_header_rec.version_number := rosetta_g_miss_num_map(p0_a125);
732     ddp_header_rec.return_status := p0_a126;
733     ddp_header_rec.db_flag := p0_a127;
734     ddp_header_rec.operation := p0_a128;
735     ddp_header_rec.first_ack_code := p0_a129;
736     ddp_header_rec.first_ack_date := rosetta_g_miss_date_in_map(p0_a130);
737     ddp_header_rec.last_ack_code := p0_a131;
738     ddp_header_rec.last_ack_date := rosetta_g_miss_date_in_map(p0_a132);
739     ddp_header_rec.change_reason := p0_a133;
740     ddp_header_rec.change_comments := p0_a134;
741     ddp_header_rec.change_sequence := p0_a135;
742     ddp_header_rec.change_request_code := p0_a136;
743     ddp_header_rec.ready_flag := p0_a137;
744     ddp_header_rec.status_flag := p0_a138;
745     ddp_header_rec.force_apply_flag := p0_a139;
746     ddp_header_rec.drop_ship_flag := p0_a140;
747     ddp_header_rec.customer_payment_term_id := rosetta_g_miss_num_map(p0_a141);
748     ddp_header_rec.payment_type_code := p0_a142;
749     ddp_header_rec.payment_amount := rosetta_g_miss_num_map(p0_a143);
750     ddp_header_rec.check_number := p0_a144;
751     ddp_header_rec.credit_card_code := p0_a145;
752     ddp_header_rec.credit_card_holder_name := p0_a146;
753     ddp_header_rec.credit_card_number := p0_a147;
754     ddp_header_rec.credit_card_expiration_date := rosetta_g_miss_date_in_map(p0_a148);
755     ddp_header_rec.credit_card_approval_code := p0_a149;
756     ddp_header_rec.credit_card_approval_date := rosetta_g_miss_date_in_map(p0_a150);
757     ddp_header_rec.shipping_instructions := p0_a151;
758     ddp_header_rec.packing_instructions := p0_a152;
759     ddp_header_rec.flow_status_code := p0_a153;
760     ddp_header_rec.booked_date := rosetta_g_miss_date_in_map(p0_a154);
761     ddp_header_rec.marketing_source_code_id := rosetta_g_miss_num_map(p0_a155);
762     ddp_header_rec.upgraded_flag := p0_a156;
763     ddp_header_rec.lock_control := rosetta_g_miss_num_map(p0_a157);
764     ddp_header_rec.ship_to_edi_location_code := p0_a158;
765     ddp_header_rec.sold_to_edi_location_code := p0_a159;
766     ddp_header_rec.bill_to_edi_location_code := p0_a160;
767     ddp_header_rec.ship_from_edi_location_code := p0_a161;
768     ddp_header_rec.ship_from_address_id := rosetta_g_miss_num_map(p0_a162);
769     ddp_header_rec.sold_to_address_id := rosetta_g_miss_num_map(p0_a163);
770     ddp_header_rec.ship_to_address_id := rosetta_g_miss_num_map(p0_a164);
771     ddp_header_rec.invoice_address_id := rosetta_g_miss_num_map(p0_a165);
772     ddp_header_rec.ship_to_address_code := p0_a166;
773     ddp_header_rec.xml_message_id := rosetta_g_miss_num_map(p0_a167);
774     ddp_header_rec.ship_to_customer_id := rosetta_g_miss_num_map(p0_a168);
775     ddp_header_rec.invoice_to_customer_id := rosetta_g_miss_num_map(p0_a169);
776     ddp_header_rec.deliver_to_customer_id := rosetta_g_miss_num_map(p0_a170);
777     ddp_header_rec.accounting_rule_duration := rosetta_g_miss_num_map(p0_a171);
778     ddp_header_rec.xml_transaction_type_code := p0_a172;
779     ddp_header_rec.blanket_number := rosetta_g_miss_num_map(p0_a173);
780     ddp_header_rec.line_set_name := p0_a174;
781     ddp_header_rec.fulfillment_set_name := p0_a175;
782     ddp_header_rec.default_fulfillment_set := p0_a176;
783     ddp_header_rec.quote_date := rosetta_g_miss_date_in_map(p0_a177);
784     ddp_header_rec.quote_number := rosetta_g_miss_num_map(p0_a178);
785     ddp_header_rec.sales_document_name := p0_a179;
786     ddp_header_rec.transaction_phase_code := p0_a180;
787     ddp_header_rec.user_status_code := p0_a181;
788     ddp_header_rec.draft_submitted_flag := p0_a182;
789     ddp_header_rec.source_document_version_number := rosetta_g_miss_num_map(p0_a183);
790     ddp_header_rec.sold_to_site_use_id := rosetta_g_miss_num_map(p0_a184);
791     ddp_header_rec.minisite_id := rosetta_g_miss_num_map(p0_a185);
792     ddp_header_rec.ib_owner := p0_a186;
793     ddp_header_rec.ib_installed_at_location := p0_a187;
794     ddp_header_rec.ib_current_location := p0_a188;
795     ddp_header_rec.end_customer_id := rosetta_g_miss_num_map(p0_a189);
796     ddp_header_rec.end_customer_contact_id := rosetta_g_miss_num_map(p0_a190);
797     ddp_header_rec.end_customer_site_use_id := rosetta_g_miss_num_map(p0_a191);
798     ddp_header_rec.supplier_signature := p0_a192;
799     ddp_header_rec.supplier_signature_date := rosetta_g_miss_date_in_map(p0_a193);
800     ddp_header_rec.customer_signature := p0_a194;
801     ddp_header_rec.customer_signature_date := rosetta_g_miss_date_in_map(p0_a195);
802     ddp_header_rec.sold_to_party_id := rosetta_g_miss_num_map(p0_a196);
803     ddp_header_rec.sold_to_org_contact_id := rosetta_g_miss_num_map(p0_a197);
804     ddp_header_rec.ship_to_party_id := rosetta_g_miss_num_map(p0_a198);
805     ddp_header_rec.ship_to_party_site_id := rosetta_g_miss_num_map(p0_a199);
806     ddp_header_rec.ship_to_party_site_use_id := rosetta_g_miss_num_map(p0_a200);
807     ddp_header_rec.deliver_to_party_id := rosetta_g_miss_num_map(p0_a201);
808     ddp_header_rec.deliver_to_party_site_id := rosetta_g_miss_num_map(p0_a202);
809     ddp_header_rec.deliver_to_party_site_use_id := rosetta_g_miss_num_map(p0_a203);
810     ddp_header_rec.invoice_to_party_id := rosetta_g_miss_num_map(p0_a204);
811     ddp_header_rec.invoice_to_party_site_id := rosetta_g_miss_num_map(p0_a205);
812     ddp_header_rec.invoice_to_party_site_use_id := rosetta_g_miss_num_map(p0_a206);
813     ddp_header_rec.ship_to_customer_party_id := rosetta_g_miss_num_map(p0_a207);
814     ddp_header_rec.deliver_to_customer_party_id := rosetta_g_miss_num_map(p0_a208);
815     ddp_header_rec.invoice_to_customer_party_id := rosetta_g_miss_num_map(p0_a209);
816     ddp_header_rec.ship_to_org_contact_id := rosetta_g_miss_num_map(p0_a210);
817     ddp_header_rec.deliver_to_org_contact_id := rosetta_g_miss_num_map(p0_a211);
818     ddp_header_rec.invoice_to_org_contact_id := rosetta_g_miss_num_map(p0_a212);
819     ddp_header_rec.contract_template_id := rosetta_g_miss_num_map(p0_a213);
820     ddp_header_rec.contract_source_doc_type_code := p0_a214;
821     ddp_header_rec.contract_source_document_id := rosetta_g_miss_num_map(p0_a215);
822 
823     ddp_old_header_rec.accounting_rule_id := rosetta_g_miss_num_map(p1_a0);
824     ddp_old_header_rec.agreement_id := rosetta_g_miss_num_map(p1_a1);
825     ddp_old_header_rec.attribute1 := p1_a2;
826     ddp_old_header_rec.attribute10 := p1_a3;
827     ddp_old_header_rec.attribute11 := p1_a4;
828     ddp_old_header_rec.attribute12 := p1_a5;
829     ddp_old_header_rec.attribute13 := p1_a6;
830     ddp_old_header_rec.attribute14 := p1_a7;
831     ddp_old_header_rec.attribute15 := p1_a8;
832     ddp_old_header_rec.attribute16 := p1_a9;
833     ddp_old_header_rec.attribute17 := p1_a10;
834     ddp_old_header_rec.attribute18 := p1_a11;
835     ddp_old_header_rec.attribute19 := p1_a12;
836     ddp_old_header_rec.attribute2 := p1_a13;
837     ddp_old_header_rec.attribute20 := p1_a14;
838     ddp_old_header_rec.attribute3 := p1_a15;
839     ddp_old_header_rec.attribute4 := p1_a16;
840     ddp_old_header_rec.attribute5 := p1_a17;
841     ddp_old_header_rec.attribute6 := p1_a18;
842     ddp_old_header_rec.attribute7 := p1_a19;
843     ddp_old_header_rec.attribute8 := p1_a20;
844     ddp_old_header_rec.attribute9 := p1_a21;
845     ddp_old_header_rec.booked_flag := p1_a22;
846     ddp_old_header_rec.cancelled_flag := p1_a23;
847     ddp_old_header_rec.context := p1_a24;
848     ddp_old_header_rec.conversion_rate := rosetta_g_miss_num_map(p1_a25);
849     ddp_old_header_rec.conversion_rate_date := rosetta_g_miss_date_in_map(p1_a26);
850     ddp_old_header_rec.conversion_type_code := p1_a27;
851     ddp_old_header_rec.customer_preference_set_code := p1_a28;
852     ddp_old_header_rec.created_by := rosetta_g_miss_num_map(p1_a29);
853     ddp_old_header_rec.creation_date := rosetta_g_miss_date_in_map(p1_a30);
854     ddp_old_header_rec.cust_po_number := p1_a31;
855     ddp_old_header_rec.deliver_to_contact_id := rosetta_g_miss_num_map(p1_a32);
856     ddp_old_header_rec.deliver_to_org_id := rosetta_g_miss_num_map(p1_a33);
857     ddp_old_header_rec.demand_class_code := p1_a34;
858     ddp_old_header_rec.earliest_schedule_limit := rosetta_g_miss_num_map(p1_a35);
859     ddp_old_header_rec.expiration_date := rosetta_g_miss_date_in_map(p1_a36);
860     ddp_old_header_rec.fob_point_code := p1_a37;
861     ddp_old_header_rec.freight_carrier_code := p1_a38;
862     ddp_old_header_rec.freight_terms_code := p1_a39;
863     ddp_old_header_rec.global_attribute1 := p1_a40;
864     ddp_old_header_rec.global_attribute10 := p1_a41;
865     ddp_old_header_rec.global_attribute11 := p1_a42;
866     ddp_old_header_rec.global_attribute12 := p1_a43;
867     ddp_old_header_rec.global_attribute13 := p1_a44;
868     ddp_old_header_rec.global_attribute14 := p1_a45;
869     ddp_old_header_rec.global_attribute15 := p1_a46;
870     ddp_old_header_rec.global_attribute16 := p1_a47;
871     ddp_old_header_rec.global_attribute17 := p1_a48;
872     ddp_old_header_rec.global_attribute18 := p1_a49;
873     ddp_old_header_rec.global_attribute19 := p1_a50;
874     ddp_old_header_rec.global_attribute2 := p1_a51;
875     ddp_old_header_rec.global_attribute20 := p1_a52;
876     ddp_old_header_rec.global_attribute3 := p1_a53;
877     ddp_old_header_rec.global_attribute4 := p1_a54;
878     ddp_old_header_rec.global_attribute5 := p1_a55;
879     ddp_old_header_rec.global_attribute6 := p1_a56;
880     ddp_old_header_rec.global_attribute7 := p1_a57;
881     ddp_old_header_rec.global_attribute8 := p1_a58;
882     ddp_old_header_rec.global_attribute9 := p1_a59;
883     ddp_old_header_rec.global_attribute_category := p1_a60;
884     ddp_old_header_rec.tp_context := p1_a61;
885     ddp_old_header_rec.tp_attribute1 := p1_a62;
886     ddp_old_header_rec.tp_attribute2 := p1_a63;
887     ddp_old_header_rec.tp_attribute3 := p1_a64;
888     ddp_old_header_rec.tp_attribute4 := p1_a65;
889     ddp_old_header_rec.tp_attribute5 := p1_a66;
890     ddp_old_header_rec.tp_attribute6 := p1_a67;
891     ddp_old_header_rec.tp_attribute7 := p1_a68;
892     ddp_old_header_rec.tp_attribute8 := p1_a69;
893     ddp_old_header_rec.tp_attribute9 := p1_a70;
894     ddp_old_header_rec.tp_attribute10 := p1_a71;
895     ddp_old_header_rec.tp_attribute11 := p1_a72;
896     ddp_old_header_rec.tp_attribute12 := p1_a73;
897     ddp_old_header_rec.tp_attribute13 := p1_a74;
898     ddp_old_header_rec.tp_attribute14 := p1_a75;
899     ddp_old_header_rec.tp_attribute15 := p1_a76;
900     ddp_old_header_rec.header_id := rosetta_g_miss_num_map(p1_a77);
901     ddp_old_header_rec.invoice_to_contact_id := rosetta_g_miss_num_map(p1_a78);
902     ddp_old_header_rec.invoice_to_org_id := rosetta_g_miss_num_map(p1_a79);
903     ddp_old_header_rec.invoicing_rule_id := rosetta_g_miss_num_map(p1_a80);
904     ddp_old_header_rec.last_updated_by := rosetta_g_miss_num_map(p1_a81);
905     ddp_old_header_rec.last_update_date := rosetta_g_miss_date_in_map(p1_a82);
906     ddp_old_header_rec.last_update_login := rosetta_g_miss_num_map(p1_a83);
907     ddp_old_header_rec.latest_schedule_limit := rosetta_g_miss_num_map(p1_a84);
908     ddp_old_header_rec.open_flag := p1_a85;
909     ddp_old_header_rec.order_category_code := p1_a86;
910     ddp_old_header_rec.ordered_date := rosetta_g_miss_date_in_map(p1_a87);
911     ddp_old_header_rec.order_date_type_code := p1_a88;
912     ddp_old_header_rec.order_number := rosetta_g_miss_num_map(p1_a89);
913     ddp_old_header_rec.order_source_id := rosetta_g_miss_num_map(p1_a90);
914     ddp_old_header_rec.order_type_id := rosetta_g_miss_num_map(p1_a91);
915     ddp_old_header_rec.org_id := rosetta_g_miss_num_map(p1_a92);
916     ddp_old_header_rec.orig_sys_document_ref := p1_a93;
917     ddp_old_header_rec.partial_shipments_allowed := p1_a94;
918     ddp_old_header_rec.payment_term_id := rosetta_g_miss_num_map(p1_a95);
919     ddp_old_header_rec.price_list_id := rosetta_g_miss_num_map(p1_a96);
920     ddp_old_header_rec.price_request_code := p1_a97;
921     ddp_old_header_rec.pricing_date := rosetta_g_miss_date_in_map(p1_a98);
922     ddp_old_header_rec.program_application_id := rosetta_g_miss_num_map(p1_a99);
923     ddp_old_header_rec.program_id := rosetta_g_miss_num_map(p1_a100);
924     ddp_old_header_rec.program_update_date := rosetta_g_miss_date_in_map(p1_a101);
925     ddp_old_header_rec.request_date := rosetta_g_miss_date_in_map(p1_a102);
926     ddp_old_header_rec.request_id := rosetta_g_miss_num_map(p1_a103);
927     ddp_old_header_rec.return_reason_code := p1_a104;
928     ddp_old_header_rec.salesrep_id := rosetta_g_miss_num_map(p1_a105);
929     ddp_old_header_rec.sales_channel_code := p1_a106;
930     ddp_old_header_rec.shipment_priority_code := p1_a107;
931     ddp_old_header_rec.shipping_method_code := p1_a108;
932     ddp_old_header_rec.ship_from_org_id := rosetta_g_miss_num_map(p1_a109);
933     ddp_old_header_rec.ship_tolerance_above := rosetta_g_miss_num_map(p1_a110);
934     ddp_old_header_rec.ship_tolerance_below := rosetta_g_miss_num_map(p1_a111);
935     ddp_old_header_rec.ship_to_contact_id := rosetta_g_miss_num_map(p1_a112);
936     ddp_old_header_rec.ship_to_org_id := rosetta_g_miss_num_map(p1_a113);
937     ddp_old_header_rec.sold_from_org_id := rosetta_g_miss_num_map(p1_a114);
938     ddp_old_header_rec.sold_to_contact_id := rosetta_g_miss_num_map(p1_a115);
939     ddp_old_header_rec.sold_to_org_id := rosetta_g_miss_num_map(p1_a116);
940     ddp_old_header_rec.sold_to_phone_id := rosetta_g_miss_num_map(p1_a117);
941     ddp_old_header_rec.source_document_id := rosetta_g_miss_num_map(p1_a118);
942     ddp_old_header_rec.source_document_type_id := rosetta_g_miss_num_map(p1_a119);
943     ddp_old_header_rec.tax_exempt_flag := p1_a120;
944     ddp_old_header_rec.tax_exempt_number := p1_a121;
945     ddp_old_header_rec.tax_exempt_reason_code := p1_a122;
946     ddp_old_header_rec.tax_point_code := p1_a123;
947     ddp_old_header_rec.transactional_curr_code := p1_a124;
948     ddp_old_header_rec.version_number := rosetta_g_miss_num_map(p1_a125);
949     ddp_old_header_rec.return_status := p1_a126;
950     ddp_old_header_rec.db_flag := p1_a127;
951     ddp_old_header_rec.operation := p1_a128;
952     ddp_old_header_rec.first_ack_code := p1_a129;
953     ddp_old_header_rec.first_ack_date := rosetta_g_miss_date_in_map(p1_a130);
954     ddp_old_header_rec.last_ack_code := p1_a131;
955     ddp_old_header_rec.last_ack_date := rosetta_g_miss_date_in_map(p1_a132);
956     ddp_old_header_rec.change_reason := p1_a133;
957     ddp_old_header_rec.change_comments := p1_a134;
958     ddp_old_header_rec.change_sequence := p1_a135;
959     ddp_old_header_rec.change_request_code := p1_a136;
960     ddp_old_header_rec.ready_flag := p1_a137;
961     ddp_old_header_rec.status_flag := p1_a138;
962     ddp_old_header_rec.force_apply_flag := p1_a139;
963     ddp_old_header_rec.drop_ship_flag := p1_a140;
964     ddp_old_header_rec.customer_payment_term_id := rosetta_g_miss_num_map(p1_a141);
965     ddp_old_header_rec.payment_type_code := p1_a142;
966     ddp_old_header_rec.payment_amount := rosetta_g_miss_num_map(p1_a143);
967     ddp_old_header_rec.check_number := p1_a144;
968     ddp_old_header_rec.credit_card_code := p1_a145;
969     ddp_old_header_rec.credit_card_holder_name := p1_a146;
970     ddp_old_header_rec.credit_card_number := p1_a147;
971     ddp_old_header_rec.credit_card_expiration_date := rosetta_g_miss_date_in_map(p1_a148);
972     ddp_old_header_rec.credit_card_approval_code := p1_a149;
973     ddp_old_header_rec.credit_card_approval_date := rosetta_g_miss_date_in_map(p1_a150);
974     ddp_old_header_rec.shipping_instructions := p1_a151;
975     ddp_old_header_rec.packing_instructions := p1_a152;
976     ddp_old_header_rec.flow_status_code := p1_a153;
977     ddp_old_header_rec.booked_date := rosetta_g_miss_date_in_map(p1_a154);
978     ddp_old_header_rec.marketing_source_code_id := rosetta_g_miss_num_map(p1_a155);
979     ddp_old_header_rec.upgraded_flag := p1_a156;
980     ddp_old_header_rec.lock_control := rosetta_g_miss_num_map(p1_a157);
981     ddp_old_header_rec.ship_to_edi_location_code := p1_a158;
982     ddp_old_header_rec.sold_to_edi_location_code := p1_a159;
983     ddp_old_header_rec.bill_to_edi_location_code := p1_a160;
984     ddp_old_header_rec.ship_from_edi_location_code := p1_a161;
985     ddp_old_header_rec.ship_from_address_id := rosetta_g_miss_num_map(p1_a162);
986     ddp_old_header_rec.sold_to_address_id := rosetta_g_miss_num_map(p1_a163);
987     ddp_old_header_rec.ship_to_address_id := rosetta_g_miss_num_map(p1_a164);
988     ddp_old_header_rec.invoice_address_id := rosetta_g_miss_num_map(p1_a165);
989     ddp_old_header_rec.ship_to_address_code := p1_a166;
990     ddp_old_header_rec.xml_message_id := rosetta_g_miss_num_map(p1_a167);
991     ddp_old_header_rec.ship_to_customer_id := rosetta_g_miss_num_map(p1_a168);
992     ddp_old_header_rec.invoice_to_customer_id := rosetta_g_miss_num_map(p1_a169);
993     ddp_old_header_rec.deliver_to_customer_id := rosetta_g_miss_num_map(p1_a170);
994     ddp_old_header_rec.accounting_rule_duration := rosetta_g_miss_num_map(p1_a171);
995     ddp_old_header_rec.xml_transaction_type_code := p1_a172;
996     ddp_old_header_rec.blanket_number := rosetta_g_miss_num_map(p1_a173);
997     ddp_old_header_rec.line_set_name := p1_a174;
998     ddp_old_header_rec.fulfillment_set_name := p1_a175;
999     ddp_old_header_rec.default_fulfillment_set := p1_a176;
1000     ddp_old_header_rec.quote_date := rosetta_g_miss_date_in_map(p1_a177);
1001     ddp_old_header_rec.quote_number := rosetta_g_miss_num_map(p1_a178);
1002     ddp_old_header_rec.sales_document_name := p1_a179;
1003     ddp_old_header_rec.transaction_phase_code := p1_a180;
1004     ddp_old_header_rec.user_status_code := p1_a181;
1005     ddp_old_header_rec.draft_submitted_flag := p1_a182;
1006     ddp_old_header_rec.source_document_version_number := rosetta_g_miss_num_map(p1_a183);
1007     ddp_old_header_rec.sold_to_site_use_id := rosetta_g_miss_num_map(p1_a184);
1008     ddp_old_header_rec.minisite_id := rosetta_g_miss_num_map(p1_a185);
1009     ddp_old_header_rec.ib_owner := p1_a186;
1010     ddp_old_header_rec.ib_installed_at_location := p1_a187;
1011     ddp_old_header_rec.ib_current_location := p1_a188;
1012     ddp_old_header_rec.end_customer_id := rosetta_g_miss_num_map(p1_a189);
1013     ddp_old_header_rec.end_customer_contact_id := rosetta_g_miss_num_map(p1_a190);
1014     ddp_old_header_rec.end_customer_site_use_id := rosetta_g_miss_num_map(p1_a191);
1015     ddp_old_header_rec.supplier_signature := p1_a192;
1016     ddp_old_header_rec.supplier_signature_date := rosetta_g_miss_date_in_map(p1_a193);
1017     ddp_old_header_rec.customer_signature := p1_a194;
1018     ddp_old_header_rec.customer_signature_date := rosetta_g_miss_date_in_map(p1_a195);
1019     ddp_old_header_rec.sold_to_party_id := rosetta_g_miss_num_map(p1_a196);
1020     ddp_old_header_rec.sold_to_org_contact_id := rosetta_g_miss_num_map(p1_a197);
1021     ddp_old_header_rec.ship_to_party_id := rosetta_g_miss_num_map(p1_a198);
1022     ddp_old_header_rec.ship_to_party_site_id := rosetta_g_miss_num_map(p1_a199);
1023     ddp_old_header_rec.ship_to_party_site_use_id := rosetta_g_miss_num_map(p1_a200);
1024     ddp_old_header_rec.deliver_to_party_id := rosetta_g_miss_num_map(p1_a201);
1025     ddp_old_header_rec.deliver_to_party_site_id := rosetta_g_miss_num_map(p1_a202);
1026     ddp_old_header_rec.deliver_to_party_site_use_id := rosetta_g_miss_num_map(p1_a203);
1027     ddp_old_header_rec.invoice_to_party_id := rosetta_g_miss_num_map(p1_a204);
1028     ddp_old_header_rec.invoice_to_party_site_id := rosetta_g_miss_num_map(p1_a205);
1029     ddp_old_header_rec.invoice_to_party_site_use_id := rosetta_g_miss_num_map(p1_a206);
1030     ddp_old_header_rec.ship_to_customer_party_id := rosetta_g_miss_num_map(p1_a207);
1031     ddp_old_header_rec.deliver_to_customer_party_id := rosetta_g_miss_num_map(p1_a208);
1032     ddp_old_header_rec.invoice_to_customer_party_id := rosetta_g_miss_num_map(p1_a209);
1033     ddp_old_header_rec.ship_to_org_contact_id := rosetta_g_miss_num_map(p1_a210);
1034     ddp_old_header_rec.deliver_to_org_contact_id := rosetta_g_miss_num_map(p1_a211);
1035     ddp_old_header_rec.invoice_to_org_contact_id := rosetta_g_miss_num_map(p1_a212);
1036     ddp_old_header_rec.contract_template_id := rosetta_g_miss_num_map(p1_a213);
1037     ddp_old_header_rec.contract_source_doc_type_code := p1_a214;
1038     ddp_old_header_rec.contract_source_document_id := rosetta_g_miss_num_map(p1_a215);
1039 
1040 
1041     -- here's the delegated call to the old PL/SQL routine
1042     oe_portal_util.get_values(ddp_header_rec,
1043       ddp_old_header_rec,
1044       ddx_header_val_rec_type);
1045 
1046     -- copy data back from the local variables to OUT NOCOPY /* file.sql.39 change */ or IN-OUT args, if any
1047 
1048 
1049     p2_a0 := ddx_header_val_rec_type.accounting_rule;
1050     p2_a1 := ddx_header_val_rec_type.agreement;
1051     p2_a2 := ddx_header_val_rec_type.conversion_type;
1052     p2_a3 := ddx_header_val_rec_type.deliver_to_address1;
1053     p2_a4 := ddx_header_val_rec_type.deliver_to_address2;
1054     p2_a5 := ddx_header_val_rec_type.deliver_to_address3;
1055     p2_a6 := ddx_header_val_rec_type.deliver_to_address4;
1056     p2_a7 := ddx_header_val_rec_type.deliver_to_contact;
1057     p2_a8 := ddx_header_val_rec_type.deliver_to_location;
1058     p2_a9 := ddx_header_val_rec_type.deliver_to_org;
1059     p2_a10 := ddx_header_val_rec_type.deliver_to_state;
1060     p2_a11 := ddx_header_val_rec_type.deliver_to_city;
1061     p2_a12 := ddx_header_val_rec_type.deliver_to_zip;
1062     p2_a13 := ddx_header_val_rec_type.deliver_to_country;
1063     p2_a14 := ddx_header_val_rec_type.deliver_to_county;
1064     p2_a15 := ddx_header_val_rec_type.deliver_to_province;
1065     p2_a16 := ddx_header_val_rec_type.demand_class;
1066     p2_a17 := ddx_header_val_rec_type.fob_point;
1067     p2_a18 := ddx_header_val_rec_type.freight_terms;
1068     p2_a19 := ddx_header_val_rec_type.invoice_to_address1;
1069     p2_a20 := ddx_header_val_rec_type.invoice_to_address2;
1070     p2_a21 := ddx_header_val_rec_type.invoice_to_address3;
1071     p2_a22 := ddx_header_val_rec_type.invoice_to_address4;
1072     p2_a23 := ddx_header_val_rec_type.invoice_to_state;
1073     p2_a24 := ddx_header_val_rec_type.invoice_to_city;
1074     p2_a25 := ddx_header_val_rec_type.invoice_to_zip;
1075     p2_a26 := ddx_header_val_rec_type.invoice_to_country;
1076     p2_a27 := ddx_header_val_rec_type.invoice_to_county;
1077     p2_a28 := ddx_header_val_rec_type.invoice_to_province;
1078     p2_a29 := ddx_header_val_rec_type.invoice_to_contact;
1079     p2_a30 := ddx_header_val_rec_type.invoice_to_contact_first_name;
1080     p2_a31 := ddx_header_val_rec_type.invoice_to_contact_last_name;
1081     p2_a32 := ddx_header_val_rec_type.invoice_to_location;
1082     p2_a33 := ddx_header_val_rec_type.invoice_to_org;
1083     p2_a34 := ddx_header_val_rec_type.invoicing_rule;
1084     p2_a35 := ddx_header_val_rec_type.order_source;
1085     p2_a36 := ddx_header_val_rec_type.order_type;
1086     p2_a37 := ddx_header_val_rec_type.payment_term;
1087     p2_a38 := ddx_header_val_rec_type.price_list;
1088     p2_a39 := ddx_header_val_rec_type.return_reason;
1089     p2_a40 := ddx_header_val_rec_type.salesrep;
1090     p2_a41 := ddx_header_val_rec_type.shipment_priority;
1091     p2_a42 := ddx_header_val_rec_type.ship_from_address1;
1092     p2_a43 := ddx_header_val_rec_type.ship_from_address2;
1093     p2_a44 := ddx_header_val_rec_type.ship_from_address3;
1094     p2_a45 := ddx_header_val_rec_type.ship_from_address4;
1095     p2_a46 := ddx_header_val_rec_type.ship_from_location;
1096     p2_a47 := ddx_header_val_rec_type.ship_from_city;
1097     p2_a48 := ddx_header_val_rec_type.ship_from_postal_code;
1098     p2_a49 := ddx_header_val_rec_type.ship_from_country;
1099     p2_a50 := ddx_header_val_rec_type.ship_from_region1;
1100     p2_a51 := ddx_header_val_rec_type.ship_from_region2;
1101     p2_a52 := ddx_header_val_rec_type.ship_from_region3;
1102     p2_a53 := ddx_header_val_rec_type.ship_from_org;
1103     p2_a54 := ddx_header_val_rec_type.sold_to_address1;
1104     p2_a55 := ddx_header_val_rec_type.sold_to_address2;
1105     p2_a56 := ddx_header_val_rec_type.sold_to_address3;
1106     p2_a57 := ddx_header_val_rec_type.sold_to_address4;
1107     p2_a58 := ddx_header_val_rec_type.sold_to_state;
1108     p2_a59 := ddx_header_val_rec_type.sold_to_country;
1109     p2_a60 := ddx_header_val_rec_type.sold_to_zip;
1110     p2_a61 := ddx_header_val_rec_type.sold_to_county;
1111     p2_a62 := ddx_header_val_rec_type.sold_to_province;
1112     p2_a63 := ddx_header_val_rec_type.sold_to_city;
1113     p2_a64 := ddx_header_val_rec_type.sold_to_contact_last_name;
1114     p2_a65 := ddx_header_val_rec_type.sold_to_contact_first_name;
1115     p2_a66 := ddx_header_val_rec_type.ship_to_address1;
1116     p2_a67 := ddx_header_val_rec_type.ship_to_address2;
1117     p2_a68 := ddx_header_val_rec_type.ship_to_address3;
1118     p2_a69 := ddx_header_val_rec_type.ship_to_address4;
1119     p2_a70 := ddx_header_val_rec_type.ship_to_state;
1120     p2_a71 := ddx_header_val_rec_type.ship_to_country;
1121     p2_a72 := ddx_header_val_rec_type.ship_to_zip;
1122     p2_a73 := ddx_header_val_rec_type.ship_to_county;
1123     p2_a74 := ddx_header_val_rec_type.ship_to_province;
1124     p2_a75 := ddx_header_val_rec_type.ship_to_city;
1125     p2_a76 := ddx_header_val_rec_type.ship_to_contact;
1126     p2_a77 := ddx_header_val_rec_type.ship_to_contact_last_name;
1127     p2_a78 := ddx_header_val_rec_type.ship_to_contact_first_name;
1128     p2_a79 := ddx_header_val_rec_type.ship_to_location;
1129     p2_a80 := ddx_header_val_rec_type.ship_to_org;
1130     p2_a81 := ddx_header_val_rec_type.sold_to_contact;
1131     p2_a82 := ddx_header_val_rec_type.sold_to_org;
1132     p2_a83 := ddx_header_val_rec_type.sold_from_org;
1133     p2_a84 := ddx_header_val_rec_type.tax_exempt;
1134     p2_a85 := ddx_header_val_rec_type.tax_exempt_reason;
1135     p2_a86 := ddx_header_val_rec_type.tax_point;
1136     p2_a87 := ddx_header_val_rec_type.customer_payment_term;
1137     p2_a88 := ddx_header_val_rec_type.payment_type;
1138     p2_a89 := ddx_header_val_rec_type.credit_card;
1139     p2_a90 := ddx_header_val_rec_type.status;
1140     p2_a91 := ddx_header_val_rec_type.freight_carrier;
1141     p2_a92 := ddx_header_val_rec_type.shipping_method;
1142     p2_a93 := ddx_header_val_rec_type.order_date_type;
1143     p2_a94 := ddx_header_val_rec_type.customer_number;
1144     p2_a95 := ddx_header_val_rec_type.ship_to_customer_name;
1145     p2_a96 := ddx_header_val_rec_type.invoice_to_customer_name;
1146     p2_a97 := ddx_header_val_rec_type.sales_channel;
1147     p2_a98 := ddx_header_val_rec_type.ship_to_customer_number;
1148     p2_a99 := ddx_header_val_rec_type.invoice_to_customer_number;
1149     p2_a100 := rosetta_g_miss_num_map(ddx_header_val_rec_type.ship_to_customer_id);
1150     p2_a101 := rosetta_g_miss_num_map(ddx_header_val_rec_type.invoice_to_customer_id);
1151     p2_a102 := rosetta_g_miss_num_map(ddx_header_val_rec_type.deliver_to_customer_id);
1152     p2_a103 := ddx_header_val_rec_type.deliver_to_customer_number;
1153     p2_a104 := ddx_header_val_rec_type.deliver_to_customer_name;
1154     p2_a105 := ddx_header_val_rec_type.deliver_to_customer_number_oi;
1155     p2_a106 := ddx_header_val_rec_type.deliver_to_customer_name_oi;
1156     p2_a107 := ddx_header_val_rec_type.ship_to_customer_number_oi;
1157     p2_a108 := ddx_header_val_rec_type.ship_to_customer_name_oi;
1158     p2_a109 := ddx_header_val_rec_type.invoice_to_customer_number_oi;
1159     p2_a110 := ddx_header_val_rec_type.invoice_to_customer_name_oi;
1160     p2_a111 := ddx_header_val_rec_type.user_status;
1161     p2_a112 := ddx_header_val_rec_type.transaction_phase;
1162     p2_a113 := ddx_header_val_rec_type.sold_to_location_address1;
1163     p2_a114 := ddx_header_val_rec_type.sold_to_location_address2;
1164     p2_a115 := ddx_header_val_rec_type.sold_to_location_address3;
1165     p2_a116 := ddx_header_val_rec_type.sold_to_location_address4;
1166     p2_a117 := ddx_header_val_rec_type.sold_to_location;
1167     p2_a118 := ddx_header_val_rec_type.sold_to_location_city;
1168     p2_a119 := ddx_header_val_rec_type.sold_to_location_state;
1169     p2_a120 := ddx_header_val_rec_type.sold_to_location_postal;
1170     p2_a121 := ddx_header_val_rec_type.sold_to_location_country;
1171     p2_a122 := ddx_header_val_rec_type.sold_to_location_county;
1172     p2_a123 := ddx_header_val_rec_type.sold_to_location_province;
1173     p2_a124 := ddx_header_val_rec_type.end_customer_name;
1174     p2_a125 := ddx_header_val_rec_type.end_customer_number;
1175     p2_a126 := ddx_header_val_rec_type.end_customer_contact;
1176     p2_a127 := ddx_header_val_rec_type.end_cust_contact_last_name;
1177     p2_a128 := ddx_header_val_rec_type.end_cust_contact_first_name;
1178     p2_a129 := ddx_header_val_rec_type.end_customer_site_address1;
1179     p2_a130 := ddx_header_val_rec_type.end_customer_site_address2;
1180     p2_a131 := ddx_header_val_rec_type.end_customer_site_address3;
1181     p2_a132 := ddx_header_val_rec_type.end_customer_site_address4;
1182     p2_a133 := ddx_header_val_rec_type.end_customer_site_state;
1183     p2_a134 := ddx_header_val_rec_type.end_customer_site_country;
1184     p2_a135 := ddx_header_val_rec_type.end_customer_site_location;
1185     p2_a136 := ddx_header_val_rec_type.end_customer_site_zip;
1186     p2_a137 := ddx_header_val_rec_type.end_customer_site_county;
1187     p2_a138 := ddx_header_val_rec_type.end_customer_site_province;
1188     p2_a139 := ddx_header_val_rec_type.end_customer_site_city;
1189     p2_a140 := ddx_header_val_rec_type.end_customer_site_postal_code;
1190     p2_a141 := ddx_header_val_rec_type.blanket_agreement_name;
1191   end;
1192 
1193   procedure lines(p_init_msg_list  VARCHAR2
1194     , p_validation_level  NUMBER
1195     , p2_a0  NUMBER
1196     , p2_a1  NUMBER
1197     , p2_a2  NUMBER
1198     , p2_a3  NUMBER
1199     , p2_a4  NUMBER
1200     , p2_a5  NUMBER
1201     , p2_a6  NUMBER
1202     , p2_a7  NUMBER
1203     , p2_a8  NUMBER
1204     , p2_a9  NUMBER
1205     , p2_a10  VARCHAR2
1206     , p2_a11  NUMBER
1207     , p2_a12  NUMBER
1208     , p2_a13  VARCHAR2
1209     , p2_a14  VARCHAR2
1210     , p2_a15  NUMBER
1211     , p3_a0 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1212     , p3_a1 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
1213     , p3_a2 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
1214     , p3_a3 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1215     , p3_a4 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1216     , p3_a5 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1217     , p3_a6 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1218     , p3_a7 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1219     , p3_a8 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1220     , p3_a9 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1221     , p3_a10 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1222     , p3_a11 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1223     , p3_a12 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1224     , p3_a13 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_1000
1225     , p3_a14 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1226     , p3_a15 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1227     , p3_a16 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1228     , p3_a17 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1229     , p3_a18 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1230     , p3_a19 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1231     , p3_a20 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1232     , p3_a21 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1233     , p3_a22 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
1234     , p3_a23 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1235     , p3_a24 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1236     , p3_a25 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1237     , p3_a26 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1238     , p3_a27 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1239     , p3_a28 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1240     , p3_a29 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1241     , p3_a30 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1242     , p3_a31 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1243     , p3_a32 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1244     , p3_a33 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1245     , p3_a34 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1246     , p3_a35 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1247     , p3_a36 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1248     , p3_a37 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
1249     , p3_a38 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1250     , p3_a39 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
1251     , p3_a40 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1252     , p3_a41 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1253     , p3_a42 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1254     , p3_a43 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1255     , p3_a44 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1256     , p3_a45 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1257     , p3_a46 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1258     , p3_a47 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1259     , p3_a48 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1260     , p3_a49 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1261     , p3_a50 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1262     , p3_a51 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1263     , p3_a52 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1264     , p3_a53 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
1265     , p3_a54 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1266     , p3_a55 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1267     , p3_a56 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1268     , p3_a57 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
1269     , p3_a58 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1270     , p3_a59 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
1271     , p3_a60 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1272     , p3_a61 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1273     , p3_a62 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1274     , p3_a63 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1275     , p3_a64 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1276     , p3_a65 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1277     , p3_a66 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1278     , p3_a67 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1279     , p3_a68 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1280     , p3_a69 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1281     , p3_a70 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1282     , p3_a71 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1283     , p3_a72 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1284     , p3_a73 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1285     , p3_a74 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1286     , p3_a75 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1287     , p3_a76 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1288     , p3_a77 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1289     , p3_a78 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1290     , p3_a79 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1291     , p3_a80 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1292     , p3_a81 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1293     , p3_a82 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1294     , p3_a83 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1295     , p3_a84 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1296     , p3_a85 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1297     , p3_a86 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1298     , p3_a87 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
1299     , p3_a88 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1300     , p3_a89 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1301     , p3_a90 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1302     , p3_a91 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1303     , p3_a92 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
1304     , p3_a93 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1305     , p3_a94 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
1306     , p3_a95 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1307     , p3_a96 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1308     , p3_a97 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1309     , p3_a98 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1310     , p3_a99 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1311     , p3_a100 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
1312     , p3_a101 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1313     , p3_a102 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1314     , p3_a103 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1315     , p3_a104 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1316     , p3_a105 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1317     , p3_a106 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
1318     , p3_a107 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
1319     , p3_a108 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1320     , p3_a109 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1321     , p3_a110 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1322     , p3_a111 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1323     , p3_a112 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1324     , p3_a113 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1325     , p3_a114 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1326     , p3_a115 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1327     , p3_a116 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1328     , p3_a117 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1329     , p3_a118 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1330     , p3_a119 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1331     , p3_a120 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1332     , p3_a121 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1333     , p3_a122 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1334     , p3_a123 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1335     , p3_a124 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1336     , p3_a125 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1337     , p3_a126 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1338     , p3_a127 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1339     , p3_a128 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1340     , p3_a129 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1341     , p3_a130 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
1342     , p3_a131 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1343     , p3_a132 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1344     , p3_a133 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1345     , p3_a134 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1346     , p3_a135 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1347     , p3_a136 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1348     , p3_a137 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1349     , p3_a138 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
1350     , p3_a139 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1351     , p3_a140 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1352     , p3_a141 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1353     , p3_a142 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1354     , p3_a143 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1355     , p3_a144 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1356     , p3_a145 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1357     , p3_a146 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1358     , p3_a147 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1359     , p3_a148 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1360     , p3_a149 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1361     , p3_a150 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1362     , p3_a151 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1363     , p3_a152 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1364     , p3_a153 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1365     , p3_a154 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1366     , p3_a155 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1367     , p3_a156 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1368     , p3_a157 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1369     , p3_a158 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
1370     , p3_a159 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1371     , p3_a160 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
1372     , p3_a161 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1373     , p3_a162 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
1374     , p3_a163 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1375     , p3_a164 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1376     , p3_a165 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1377     , p3_a166 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1378     , p3_a167 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1379     , p3_a168 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1380     , p3_a169 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1381     , p3_a170 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1382     , p3_a171 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1383     , p3_a172 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1384     , p3_a173 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1385     , p3_a174 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1386     , p3_a175 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1387     , p3_a176 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1388     , p3_a177 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1389     , p3_a178 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
1390     , p3_a179 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
1391     , p3_a180 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1392     , p3_a181 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1393     , p3_a182 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1394     , p3_a183 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
1395     , p3_a184 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1396     , p3_a185 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1397     , p3_a186 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
1398     , p3_a187 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
1399     , p3_a188 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1400     , p3_a189 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1401     , p3_a190 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1402     , p3_a191 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1403     , p3_a192 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1404     , p3_a193 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1405     , p3_a194 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1406     , p3_a195 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1407     , p3_a196 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1408     , p3_a197 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1409     , p3_a198 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1410     , p3_a199 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1411     , p3_a200 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1412     , p3_a201 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1413     , p3_a202 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1414     , p3_a203 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1415     , p3_a204 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1416     , p3_a205 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1417     , p3_a206 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1418     , p3_a207 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1419     , p3_a208 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1420     , p3_a209 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1421     , p3_a210 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1422     , p3_a211 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1423     , p3_a212 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1424     , p3_a213 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1425     , p3_a214 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
1426     , p3_a215 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1427     , p3_a216 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1428     , p3_a217 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1429     , p3_a218 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1430     , p3_a219 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1431     , p3_a220 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1432     , p3_a221 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1433     , p3_a222 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1434     , p3_a223 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1435     , p3_a224 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1436     , p3_a225 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1437     , p3_a226 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1438     , p3_a227 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1439     , p3_a228 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1440     , p3_a229 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1441     , p3_a230 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1442     , p3_a231 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1443     , p3_a232 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
1444     , p3_a233 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1445     , p3_a234 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1446     , p3_a235 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1447     , p3_a236 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1448     , p3_a237 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1449     , p3_a238 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1450     , p3_a239 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1451     , p3_a240 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1452     , p3_a241 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_1000
1453     , p3_a242 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1454     , p3_a243 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1455     , p3_a244 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1456     , p3_a245 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1457     , p3_a246 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1458     , p3_a247 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1459     , p3_a248 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1460     , p3_a249 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
1461     , p3_a250 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1462     , p3_a251 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1463     , p3_a252 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1464     , p3_a253 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1465     , p3_a254 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1466     , p3_a255 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1467     , p3_a256 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1468     , p3_a257 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1469     , p3_a258 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1470     , p3_a259 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1471     , p3_a260 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
1472     , p3_a261 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1473     , p3_a262 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
1474     , p3_a263 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1475     , p3_a264 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1476     , p3_a265 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1477     , p3_a266 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1478     , p3_a267 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1479     , p3_a268 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1480     , p3_a269 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1481     , p3_a270 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1482     , p3_a271 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1483     , p3_a272 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1484     , p3_a273 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1485     , p3_a274 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1486     , p3_a275 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1487     , p3_a276 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1488     , p3_a277 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1489     , p3_a278 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1490     , p3_a279 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1491     , p3_a280 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1492     , p_return_status out NOCOPY /* file.sql.39 change */  VARCHAR2
1493   )
1494 
1495   as
1496     ddp_control_rec oe_globals.control_rec_type;
1497     ddp_x_line_tbl oe_order_pub.line_tbl_type;
1498     ddindx binary_integer; indx binary_integer;
1499   begin
1500 
1501     -- copy data to the local IN or IN-OUT args, if any
1502 
1503 
1504     if p2_a0 is null
1505       then ddp_control_rec.controlled_operation := null;
1506     elsif p2_a0 = 0
1507       then ddp_control_rec.controlled_operation := false;
1508     else ddp_control_rec.controlled_operation := true;
1509     end if;
1510     if p2_a1 is null
1511       then ddp_control_rec.private_call := null;
1512     elsif p2_a1 = 0
1513       then ddp_control_rec.private_call := false;
1514     else ddp_control_rec.private_call := true;
1515     end if;
1516     if p2_a2 is null
1517       then ddp_control_rec.check_security := null;
1518     elsif p2_a2 = 0
1519       then ddp_control_rec.check_security := false;
1520     else ddp_control_rec.check_security := true;
1521     end if;
1522     if p2_a3 is null
1523       then ddp_control_rec.clear_dependents := null;
1524     elsif p2_a3 = 0
1525       then ddp_control_rec.clear_dependents := false;
1526     else ddp_control_rec.clear_dependents := true;
1527     end if;
1528     if p2_a4 is null
1529       then ddp_control_rec.default_attributes := null;
1530     elsif p2_a4 = 0
1531       then ddp_control_rec.default_attributes := false;
1532     else ddp_control_rec.default_attributes := true;
1533     end if;
1534     if p2_a5 is null
1535       then ddp_control_rec.change_attributes := null;
1536     elsif p2_a5 = 0
1537       then ddp_control_rec.change_attributes := false;
1538     else ddp_control_rec.change_attributes := true;
1539     end if;
1540     if p2_a6 is null
1541       then ddp_control_rec.validate_entity := null;
1542     elsif p2_a6 = 0
1543       then ddp_control_rec.validate_entity := false;
1544     else ddp_control_rec.validate_entity := true;
1545     end if;
1546     if p2_a7 is null
1547       then ddp_control_rec.write_to_db := null;
1548     elsif p2_a7 = 0
1549       then ddp_control_rec.write_to_db := false;
1550     else ddp_control_rec.write_to_db := true;
1551     end if;
1552     if p2_a8 is null
1553       then ddp_control_rec.process_partial := null;
1554     elsif p2_a8 = 0
1555       then ddp_control_rec.process_partial := false;
1556     else ddp_control_rec.process_partial := true;
1557     end if;
1558     if p2_a9 is null
1559       then ddp_control_rec.process := null;
1560     elsif p2_a9 = 0
1561       then ddp_control_rec.process := false;
1562     else ddp_control_rec.process := true;
1563     end if;
1564     ddp_control_rec.process_entity := p2_a10;
1565     if p2_a11 is null
1566       then ddp_control_rec.clear_api_cache := null;
1567     elsif p2_a11 = 0
1568       then ddp_control_rec.clear_api_cache := false;
1569     else ddp_control_rec.clear_api_cache := true;
1570     end if;
1571     if p2_a12 is null
1572       then ddp_control_rec.clear_api_requests := null;
1573     elsif p2_a12 = 0
1574       then ddp_control_rec.clear_api_requests := false;
1575     else ddp_control_rec.clear_api_requests := true;
1576     end if;
1577     ddp_control_rec.request_category := p2_a13;
1578     ddp_control_rec.request_name := p2_a14;
1579     ddp_control_rec.org_id := rosetta_g_miss_num_map(p2_a15);
1580 
1581     oe_order_pub_w.rosetta_table_copy_in_p19(ddp_x_line_tbl, p3_a0
1582       , p3_a1
1583       , p3_a2
1584       , p3_a3
1585       , p3_a4
1586       , p3_a5
1587       , p3_a6
1588       , p3_a7
1589       , p3_a8
1590       , p3_a9
1591       , p3_a10
1592       , p3_a11
1593       , p3_a12
1594       , p3_a13
1595       , p3_a14
1596       , p3_a15
1597       , p3_a16
1598       , p3_a17
1599       , p3_a18
1600       , p3_a19
1601       , p3_a20
1602       , p3_a21
1603       , p3_a22
1604       , p3_a23
1605       , p3_a24
1606       , p3_a25
1607       , p3_a26
1608       , p3_a27
1609       , p3_a28
1610       , p3_a29
1611       , p3_a30
1612       , p3_a31
1613       , p3_a32
1614       , p3_a33
1615       , p3_a34
1616       , p3_a35
1617       , p3_a36
1618       , p3_a37
1619       , p3_a38
1620       , p3_a39
1621       , p3_a40
1622       , p3_a41
1623       , p3_a42
1624       , p3_a43
1625       , p3_a44
1626       , p3_a45
1627       , p3_a46
1628       , p3_a47
1629       , p3_a48
1630       , p3_a49
1631       , p3_a50
1632       , p3_a51
1633       , p3_a52
1634       , p3_a53
1635       , p3_a54
1636       , p3_a55
1637       , p3_a56
1638       , p3_a57
1639       , p3_a58
1640       , p3_a59
1641       , p3_a60
1642       , p3_a61
1643       , p3_a62
1644       , p3_a63
1645       , p3_a64
1646       , p3_a65
1647       , p3_a66
1648       , p3_a67
1649       , p3_a68
1650       , p3_a69
1651       , p3_a70
1652       , p3_a71
1653       , p3_a72
1654       , p3_a73
1655       , p3_a74
1656       , p3_a75
1657       , p3_a76
1658       , p3_a77
1659       , p3_a78
1660       , p3_a79
1661       , p3_a80
1662       , p3_a81
1663       , p3_a82
1664       , p3_a83
1665       , p3_a84
1666       , p3_a85
1667       , p3_a86
1668       , p3_a87
1669       , p3_a88
1670       , p3_a89
1671       , p3_a90
1672       , p3_a91
1673       , p3_a92
1674       , p3_a93
1675       , p3_a94
1676       , p3_a95
1677       , p3_a96
1678       , p3_a97
1679       , p3_a98
1680       , p3_a99
1681       , p3_a100
1682       , p3_a101
1683       , p3_a102
1684       , p3_a103
1685       , p3_a104
1686       , p3_a105
1687       , p3_a106
1688       , p3_a107
1689       , p3_a108
1690       , p3_a109
1691       , p3_a110
1692       , p3_a111
1693       , p3_a112
1694       , p3_a113
1695       , p3_a114
1696       , p3_a115
1697       , p3_a116
1698       , p3_a117
1699       , p3_a118
1700       , p3_a119
1701       , p3_a120
1702       , p3_a121
1703       , p3_a122
1704       , p3_a123
1705       , p3_a124
1706       , p3_a125
1707       , p3_a126
1708       , p3_a127
1709       , p3_a128
1710       , p3_a129
1711       , p3_a130
1712       , p3_a131
1713       , p3_a132
1714       , p3_a133
1715       , p3_a134
1716       , p3_a135
1717       , p3_a136
1718       , p3_a137
1719       , p3_a138
1720       , p3_a139
1721       , p3_a140
1722       , p3_a141
1723       , p3_a142
1724       , p3_a143
1725       , p3_a144
1726       , p3_a145
1727       , p3_a146
1728       , p3_a147
1729       , p3_a148
1730       , p3_a149
1731       , p3_a150
1732       , p3_a151
1733       , p3_a152
1734       , p3_a153
1735       , p3_a154
1736       , p3_a155
1737       , p3_a156
1738       , p3_a157
1739       , p3_a158
1740       , p3_a159
1741       , p3_a160
1742       , p3_a161
1743       , p3_a162
1744       , p3_a163
1745       , p3_a164
1746       , p3_a165
1747       , p3_a166
1748       , p3_a167
1749       , p3_a168
1750       , p3_a169
1751       , p3_a170
1752       , p3_a171
1753       , p3_a172
1754       , p3_a173
1755       , p3_a174
1756       , p3_a175
1757       , p3_a176
1758       , p3_a177
1759       , p3_a178
1760       , p3_a179
1761       , p3_a180
1762       , p3_a181
1763       , p3_a182
1764       , p3_a183
1765       , p3_a184
1766       , p3_a185
1767       , p3_a186
1768       , p3_a187
1769       , p3_a188
1770       , p3_a189
1771       , p3_a190
1772       , p3_a191
1773       , p3_a192
1774       , p3_a193
1775       , p3_a194
1776       , p3_a195
1777       , p3_a196
1778       , p3_a197
1779       , p3_a198
1780       , p3_a199
1781       , p3_a200
1782       , p3_a201
1783       , p3_a202
1784       , p3_a203
1785       , p3_a204
1786       , p3_a205
1787       , p3_a206
1788       , p3_a207
1789       , p3_a208
1790       , p3_a209
1791       , p3_a210
1792       , p3_a211
1793       , p3_a212
1794       , p3_a213
1795       , p3_a214
1796       , p3_a215
1797       , p3_a216
1798       , p3_a217
1799       , p3_a218
1800       , p3_a219
1801       , p3_a220
1802       , p3_a221
1803       , p3_a222
1804       , p3_a223
1805       , p3_a224
1806       , p3_a225
1807       , p3_a226
1808       , p3_a227
1809       , p3_a228
1810       , p3_a229
1811       , p3_a230
1812       , p3_a231
1813       , p3_a232
1814       , p3_a233
1815       , p3_a234
1816       , p3_a235
1817       , p3_a236
1818       , p3_a237
1819       , p3_a238
1820       , p3_a239
1821       , p3_a240
1822       , p3_a241
1823       , p3_a242
1824       , p3_a243
1825       , p3_a244
1826       , p3_a245
1827       , p3_a246
1828       , p3_a247
1829       , p3_a248
1830       , p3_a249
1831       , p3_a250
1832       , p3_a251
1833       , p3_a252
1834       , p3_a253
1835       , p3_a254
1836       , p3_a255
1837       , p3_a256
1838       , p3_a257
1839       , p3_a258
1840       , p3_a259
1841       , p3_a260
1842       , p3_a261
1843       , p3_a262
1844       , p3_a263
1845       , p3_a264
1846       , p3_a265
1847       , p3_a266
1848       , p3_a267
1849       , p3_a268
1850       , p3_a269
1851       , p3_a270
1852       , p3_a271
1853       , p3_a272
1854       , p3_a273
1855       , p3_a274
1856       , p3_a275
1857       , p3_a276
1858       , p3_a277
1859       , p3_a278
1860       , p3_a279
1861       , p3_a280
1862       );
1863 
1864 
1865     -- here's the delegated call to the old PL/SQL routine
1866     oe_portal_util.lines(p_init_msg_list,
1867       p_validation_level,
1868       ddp_control_rec,
1869       ddp_x_line_tbl,
1870       p_return_status);
1871 
1872     -- copy data back from the local variables to OUT NOCOPY /* file.sql.39 change */ or IN-OUT args, if any
1873 
1874 
1875 
1876     oe_order_pub_w.rosetta_table_copy_out_p19(ddp_x_line_tbl, p3_a0
1877       , p3_a1
1878       , p3_a2
1879       , p3_a3
1880       , p3_a4
1881       , p3_a5
1882       , p3_a6
1883       , p3_a7
1884       , p3_a8
1885       , p3_a9
1886       , p3_a10
1887       , p3_a11
1888       , p3_a12
1889       , p3_a13
1890       , p3_a14
1891       , p3_a15
1892       , p3_a16
1893       , p3_a17
1894       , p3_a18
1895       , p3_a19
1896       , p3_a20
1897       , p3_a21
1898       , p3_a22
1899       , p3_a23
1900       , p3_a24
1901       , p3_a25
1902       , p3_a26
1903       , p3_a27
1904       , p3_a28
1905       , p3_a29
1906       , p3_a30
1907       , p3_a31
1908       , p3_a32
1909       , p3_a33
1910       , p3_a34
1911       , p3_a35
1912       , p3_a36
1913       , p3_a37
1914       , p3_a38
1915       , p3_a39
1916       , p3_a40
1917       , p3_a41
1918       , p3_a42
1919       , p3_a43
1920       , p3_a44
1921       , p3_a45
1922       , p3_a46
1923       , p3_a47
1924       , p3_a48
1925       , p3_a49
1926       , p3_a50
1927       , p3_a51
1928       , p3_a52
1929       , p3_a53
1930       , p3_a54
1931       , p3_a55
1932       , p3_a56
1933       , p3_a57
1934       , p3_a58
1935       , p3_a59
1936       , p3_a60
1937       , p3_a61
1938       , p3_a62
1939       , p3_a63
1940       , p3_a64
1941       , p3_a65
1942       , p3_a66
1943       , p3_a67
1944       , p3_a68
1945       , p3_a69
1946       , p3_a70
1947       , p3_a71
1948       , p3_a72
1949       , p3_a73
1950       , p3_a74
1951       , p3_a75
1952       , p3_a76
1953       , p3_a77
1954       , p3_a78
1955       , p3_a79
1956       , p3_a80
1957       , p3_a81
1958       , p3_a82
1959       , p3_a83
1960       , p3_a84
1961       , p3_a85
1962       , p3_a86
1963       , p3_a87
1964       , p3_a88
1965       , p3_a89
1966       , p3_a90
1967       , p3_a91
1968       , p3_a92
1969       , p3_a93
1970       , p3_a94
1971       , p3_a95
1972       , p3_a96
1973       , p3_a97
1974       , p3_a98
1975       , p3_a99
1976       , p3_a100
1977       , p3_a101
1978       , p3_a102
1979       , p3_a103
1980       , p3_a104
1981       , p3_a105
1982       , p3_a106
1983       , p3_a107
1984       , p3_a108
1985       , p3_a109
1986       , p3_a110
1987       , p3_a111
1988       , p3_a112
1989       , p3_a113
1990       , p3_a114
1991       , p3_a115
1992       , p3_a116
1993       , p3_a117
1994       , p3_a118
1995       , p3_a119
1996       , p3_a120
1997       , p3_a121
1998       , p3_a122
1999       , p3_a123
2000       , p3_a124
2001       , p3_a125
2002       , p3_a126
2003       , p3_a127
2004       , p3_a128
2005       , p3_a129
2006       , p3_a130
2007       , p3_a131
2008       , p3_a132
2009       , p3_a133
2010       , p3_a134
2011       , p3_a135
2012       , p3_a136
2013       , p3_a137
2014       , p3_a138
2015       , p3_a139
2016       , p3_a140
2017       , p3_a141
2018       , p3_a142
2019       , p3_a143
2020       , p3_a144
2021       , p3_a145
2022       , p3_a146
2023       , p3_a147
2024       , p3_a148
2025       , p3_a149
2026       , p3_a150
2027       , p3_a151
2028       , p3_a152
2029       , p3_a153
2030       , p3_a154
2031       , p3_a155
2032       , p3_a156
2033       , p3_a157
2034       , p3_a158
2035       , p3_a159
2036       , p3_a160
2037       , p3_a161
2038       , p3_a162
2039       , p3_a163
2040       , p3_a164
2041       , p3_a165
2042       , p3_a166
2043       , p3_a167
2044       , p3_a168
2045       , p3_a169
2046       , p3_a170
2047       , p3_a171
2048       , p3_a172
2049       , p3_a173
2050       , p3_a174
2051       , p3_a175
2052       , p3_a176
2053       , p3_a177
2054       , p3_a178
2055       , p3_a179
2056       , p3_a180
2057       , p3_a181
2058       , p3_a182
2059       , p3_a183
2060       , p3_a184
2061       , p3_a185
2062       , p3_a186
2063       , p3_a187
2064       , p3_a188
2065       , p3_a189
2066       , p3_a190
2067       , p3_a191
2068       , p3_a192
2069       , p3_a193
2070       , p3_a194
2071       , p3_a195
2072       , p3_a196
2073       , p3_a197
2074       , p3_a198
2075       , p3_a199
2076       , p3_a200
2077       , p3_a201
2078       , p3_a202
2079       , p3_a203
2080       , p3_a204
2081       , p3_a205
2082       , p3_a206
2083       , p3_a207
2084       , p3_a208
2085       , p3_a209
2086       , p3_a210
2087       , p3_a211
2088       , p3_a212
2089       , p3_a213
2090       , p3_a214
2091       , p3_a215
2092       , p3_a216
2093       , p3_a217
2094       , p3_a218
2095       , p3_a219
2096       , p3_a220
2097       , p3_a221
2098       , p3_a222
2099       , p3_a223
2100       , p3_a224
2101       , p3_a225
2102       , p3_a226
2103       , p3_a227
2104       , p3_a228
2105       , p3_a229
2106       , p3_a230
2107       , p3_a231
2108       , p3_a232
2109       , p3_a233
2110       , p3_a234
2111       , p3_a235
2112       , p3_a236
2113       , p3_a237
2114       , p3_a238
2115       , p3_a239
2116       , p3_a240
2117       , p3_a241
2118       , p3_a242
2119       , p3_a243
2120       , p3_a244
2121       , p3_a245
2122       , p3_a246
2123       , p3_a247
2124       , p3_a248
2125       , p3_a249
2126       , p3_a250
2127       , p3_a251
2128       , p3_a252
2129       , p3_a253
2130       , p3_a254
2131       , p3_a255
2132       , p3_a256
2133       , p3_a257
2134       , p3_a258
2135       , p3_a259
2136       , p3_a260
2137       , p3_a261
2138       , p3_a262
2139       , p3_a263
2140       , p3_a264
2141       , p3_a265
2142       , p3_a266
2143       , p3_a267
2144       , p3_a268
2145       , p3_a269
2146       , p3_a270
2147       , p3_a271
2148       , p3_a272
2149       , p3_a273
2150       , p3_a274
2151       , p3_a275
2152       , p3_a276
2153       , p3_a277
2154       , p3_a278
2155       , p3_a279
2156       , p3_a280
2157       );
2158 
2159   end;
2160 
2161   procedure set_header_cache(p0_a0  NUMBER := 0-1962.0724
2162     , p0_a1  NUMBER := 0-1962.0724
2163     , p0_a2  VARCHAR2 := fnd_api.g_miss_char
2164     , p0_a3  VARCHAR2 := fnd_api.g_miss_char
2165     , p0_a4  VARCHAR2 := fnd_api.g_miss_char
2166     , p0_a5  VARCHAR2 := fnd_api.g_miss_char
2167     , p0_a6  VARCHAR2 := fnd_api.g_miss_char
2168     , p0_a7  VARCHAR2 := fnd_api.g_miss_char
2169     , p0_a8  VARCHAR2 := fnd_api.g_miss_char
2170     , p0_a9  VARCHAR2 := fnd_api.g_miss_char
2171     , p0_a10  VARCHAR2 := fnd_api.g_miss_char
2172     , p0_a11  VARCHAR2 := fnd_api.g_miss_char
2173     , p0_a12  VARCHAR2 := fnd_api.g_miss_char
2174     , p0_a13  VARCHAR2 := fnd_api.g_miss_char
2175     , p0_a14  VARCHAR2 := fnd_api.g_miss_char
2176     , p0_a15  VARCHAR2 := fnd_api.g_miss_char
2177     , p0_a16  VARCHAR2 := fnd_api.g_miss_char
2178     , p0_a17  VARCHAR2 := fnd_api.g_miss_char
2179     , p0_a18  VARCHAR2 := fnd_api.g_miss_char
2180     , p0_a19  VARCHAR2 := fnd_api.g_miss_char
2181     , p0_a20  VARCHAR2 := fnd_api.g_miss_char
2182     , p0_a21  VARCHAR2 := fnd_api.g_miss_char
2183     , p0_a22  VARCHAR2 := fnd_api.g_miss_char
2184     , p0_a23  VARCHAR2 := fnd_api.g_miss_char
2185     , p0_a24  VARCHAR2 := fnd_api.g_miss_char
2186     , p0_a25  NUMBER := 0-1962.0724
2187     , p0_a26  DATE := fnd_api.g_miss_date
2188     , p0_a27  VARCHAR2 := fnd_api.g_miss_char
2189     , p0_a28  VARCHAR2 := fnd_api.g_miss_char
2190     , p0_a29  NUMBER := 0-1962.0724
2191     , p0_a30  DATE := fnd_api.g_miss_date
2192     , p0_a31  VARCHAR2 := fnd_api.g_miss_char
2193     , p0_a32  NUMBER := 0-1962.0724
2194     , p0_a33  NUMBER := 0-1962.0724
2195     , p0_a34  VARCHAR2 := fnd_api.g_miss_char
2196     , p0_a35  NUMBER := 0-1962.0724
2197     , p0_a36  DATE := fnd_api.g_miss_date
2198     , p0_a37  VARCHAR2 := fnd_api.g_miss_char
2199     , p0_a38  VARCHAR2 := fnd_api.g_miss_char
2200     , p0_a39  VARCHAR2 := fnd_api.g_miss_char
2201     , p0_a40  VARCHAR2 := fnd_api.g_miss_char
2202     , p0_a41  VARCHAR2 := fnd_api.g_miss_char
2203     , p0_a42  VARCHAR2 := fnd_api.g_miss_char
2204     , p0_a43  VARCHAR2 := fnd_api.g_miss_char
2205     , p0_a44  VARCHAR2 := fnd_api.g_miss_char
2206     , p0_a45  VARCHAR2 := fnd_api.g_miss_char
2207     , p0_a46  VARCHAR2 := fnd_api.g_miss_char
2208     , p0_a47  VARCHAR2 := fnd_api.g_miss_char
2209     , p0_a48  VARCHAR2 := fnd_api.g_miss_char
2210     , p0_a49  VARCHAR2 := fnd_api.g_miss_char
2211     , p0_a50  VARCHAR2 := fnd_api.g_miss_char
2212     , p0_a51  VARCHAR2 := fnd_api.g_miss_char
2213     , p0_a52  VARCHAR2 := fnd_api.g_miss_char
2214     , p0_a53  VARCHAR2 := fnd_api.g_miss_char
2215     , p0_a54  VARCHAR2 := fnd_api.g_miss_char
2216     , p0_a55  VARCHAR2 := fnd_api.g_miss_char
2217     , p0_a56  VARCHAR2 := fnd_api.g_miss_char
2218     , p0_a57  VARCHAR2 := fnd_api.g_miss_char
2219     , p0_a58  VARCHAR2 := fnd_api.g_miss_char
2220     , p0_a59  VARCHAR2 := fnd_api.g_miss_char
2221     , p0_a60  VARCHAR2 := fnd_api.g_miss_char
2222     , p0_a61  VARCHAR2 := fnd_api.g_miss_char
2223     , p0_a62  VARCHAR2 := fnd_api.g_miss_char
2224     , p0_a63  VARCHAR2 := fnd_api.g_miss_char
2225     , p0_a64  VARCHAR2 := fnd_api.g_miss_char
2226     , p0_a65  VARCHAR2 := fnd_api.g_miss_char
2227     , p0_a66  VARCHAR2 := fnd_api.g_miss_char
2228     , p0_a67  VARCHAR2 := fnd_api.g_miss_char
2229     , p0_a68  VARCHAR2 := fnd_api.g_miss_char
2230     , p0_a69  VARCHAR2 := fnd_api.g_miss_char
2231     , p0_a70  VARCHAR2 := fnd_api.g_miss_char
2232     , p0_a71  VARCHAR2 := fnd_api.g_miss_char
2233     , p0_a72  VARCHAR2 := fnd_api.g_miss_char
2234     , p0_a73  VARCHAR2 := fnd_api.g_miss_char
2235     , p0_a74  VARCHAR2 := fnd_api.g_miss_char
2236     , p0_a75  VARCHAR2 := fnd_api.g_miss_char
2237     , p0_a76  VARCHAR2 := fnd_api.g_miss_char
2238     , p0_a77  NUMBER := 0-1962.0724
2239     , p0_a78  NUMBER := 0-1962.0724
2240     , p0_a79  NUMBER := 0-1962.0724
2241     , p0_a80  NUMBER := 0-1962.0724
2242     , p0_a81  NUMBER := 0-1962.0724
2243     , p0_a82  DATE := fnd_api.g_miss_date
2244     , p0_a83  NUMBER := 0-1962.0724
2245     , p0_a84  NUMBER := 0-1962.0724
2246     , p0_a85  VARCHAR2 := fnd_api.g_miss_char
2247     , p0_a86  VARCHAR2 := fnd_api.g_miss_char
2248     , p0_a87  DATE := fnd_api.g_miss_date
2249     , p0_a88  VARCHAR2 := fnd_api.g_miss_char
2250     , p0_a89  NUMBER := 0-1962.0724
2251     , p0_a90  NUMBER := 0-1962.0724
2252     , p0_a91  NUMBER := 0-1962.0724
2253     , p0_a92  NUMBER := 0-1962.0724
2254     , p0_a93  VARCHAR2 := fnd_api.g_miss_char
2255     , p0_a94  VARCHAR2 := fnd_api.g_miss_char
2256     , p0_a95  NUMBER := 0-1962.0724
2257     , p0_a96  NUMBER := 0-1962.0724
2258     , p0_a97  VARCHAR2 := fnd_api.g_miss_char
2259     , p0_a98  DATE := fnd_api.g_miss_date
2260     , p0_a99  NUMBER := 0-1962.0724
2261     , p0_a100  NUMBER := 0-1962.0724
2262     , p0_a101  DATE := fnd_api.g_miss_date
2263     , p0_a102  DATE := fnd_api.g_miss_date
2264     , p0_a103  NUMBER := 0-1962.0724
2265     , p0_a104  VARCHAR2 := fnd_api.g_miss_char
2266     , p0_a105  NUMBER := 0-1962.0724
2267     , p0_a106  VARCHAR2 := fnd_api.g_miss_char
2268     , p0_a107  VARCHAR2 := fnd_api.g_miss_char
2269     , p0_a108  VARCHAR2 := fnd_api.g_miss_char
2270     , p0_a109  NUMBER := 0-1962.0724
2271     , p0_a110  NUMBER := 0-1962.0724
2272     , p0_a111  NUMBER := 0-1962.0724
2273     , p0_a112  NUMBER := 0-1962.0724
2274     , p0_a113  NUMBER := 0-1962.0724
2275     , p0_a114  NUMBER := 0-1962.0724
2276     , p0_a115  NUMBER := 0-1962.0724
2277     , p0_a116  NUMBER := 0-1962.0724
2278     , p0_a117  NUMBER := 0-1962.0724
2279     , p0_a118  NUMBER := 0-1962.0724
2280     , p0_a119  NUMBER := 0-1962.0724
2281     , p0_a120  VARCHAR2 := fnd_api.g_miss_char
2282     , p0_a121  VARCHAR2 := fnd_api.g_miss_char
2283     , p0_a122  VARCHAR2 := fnd_api.g_miss_char
2284     , p0_a123  VARCHAR2 := fnd_api.g_miss_char
2285     , p0_a124  VARCHAR2 := fnd_api.g_miss_char
2286     , p0_a125  NUMBER := 0-1962.0724
2287     , p0_a126  VARCHAR2 := fnd_api.g_miss_char
2288     , p0_a127  VARCHAR2 := fnd_api.g_miss_char
2289     , p0_a128  VARCHAR2 := fnd_api.g_miss_char
2290     , p0_a129  VARCHAR2 := fnd_api.g_miss_char
2291     , p0_a130  DATE := fnd_api.g_miss_date
2292     , p0_a131  VARCHAR2 := fnd_api.g_miss_char
2293     , p0_a132  DATE := fnd_api.g_miss_date
2294     , p0_a133  VARCHAR2 := fnd_api.g_miss_char
2295     , p0_a134  VARCHAR2 := fnd_api.g_miss_char
2296     , p0_a135  VARCHAR2 := fnd_api.g_miss_char
2297     , p0_a136  VARCHAR2 := fnd_api.g_miss_char
2298     , p0_a137  VARCHAR2 := fnd_api.g_miss_char
2299     , p0_a138  VARCHAR2 := fnd_api.g_miss_char
2300     , p0_a139  VARCHAR2 := fnd_api.g_miss_char
2301     , p0_a140  VARCHAR2 := fnd_api.g_miss_char
2302     , p0_a141  NUMBER := 0-1962.0724
2303     , p0_a142  VARCHAR2 := fnd_api.g_miss_char
2304     , p0_a143  NUMBER := 0-1962.0724
2305     , p0_a144  VARCHAR2 := fnd_api.g_miss_char
2306     , p0_a145  VARCHAR2 := fnd_api.g_miss_char
2307     , p0_a146  VARCHAR2 := fnd_api.g_miss_char
2308     , p0_a147  VARCHAR2 := fnd_api.g_miss_char
2309     , p0_a148  DATE := fnd_api.g_miss_date
2310     , p0_a149  VARCHAR2 := fnd_api.g_miss_char
2311     , p0_a150  DATE := fnd_api.g_miss_date
2312     , p0_a151  VARCHAR2 := fnd_api.g_miss_char
2313     , p0_a152  VARCHAR2 := fnd_api.g_miss_char
2314     , p0_a153  VARCHAR2 := fnd_api.g_miss_char
2315     , p0_a154  DATE := fnd_api.g_miss_date
2316     , p0_a155  NUMBER := 0-1962.0724
2317     , p0_a156  VARCHAR2 := fnd_api.g_miss_char
2318     , p0_a157  NUMBER := 0-1962.0724
2319     , p0_a158  VARCHAR2 := fnd_api.g_miss_char
2320     , p0_a159  VARCHAR2 := fnd_api.g_miss_char
2321     , p0_a160  VARCHAR2 := fnd_api.g_miss_char
2322     , p0_a161  VARCHAR2 := fnd_api.g_miss_char
2323     , p0_a162  NUMBER := 0-1962.0724
2324     , p0_a163  NUMBER := 0-1962.0724
2325     , p0_a164  NUMBER := 0-1962.0724
2326     , p0_a165  NUMBER := 0-1962.0724
2327     , p0_a166  VARCHAR2 := fnd_api.g_miss_char
2328     , p0_a167  NUMBER := 0-1962.0724
2329     , p0_a168  NUMBER := 0-1962.0724
2330     , p0_a169  NUMBER := 0-1962.0724
2331     , p0_a170  NUMBER := 0-1962.0724
2332     , p0_a171  NUMBER := 0-1962.0724
2333     , p0_a172  VARCHAR2 := fnd_api.g_miss_char
2334     , p0_a173  NUMBER := 0-1962.0724
2335     , p0_a174  VARCHAR2 := fnd_api.g_miss_char
2336     , p0_a175  VARCHAR2 := fnd_api.g_miss_char
2337     , p0_a176  VARCHAR2 := fnd_api.g_miss_char
2338     , p0_a177  DATE := fnd_api.g_miss_date
2339     , p0_a178  NUMBER := 0-1962.0724
2340     , p0_a179  VARCHAR2 := fnd_api.g_miss_char
2341     , p0_a180  VARCHAR2 := fnd_api.g_miss_char
2342     , p0_a181  VARCHAR2 := fnd_api.g_miss_char
2343     , p0_a182  VARCHAR2 := fnd_api.g_miss_char
2344     , p0_a183  NUMBER := 0-1962.0724
2345     , p0_a184  NUMBER := 0-1962.0724
2346     , p0_a185  NUMBER := 0-1962.0724
2347     , p0_a186  VARCHAR2 := fnd_api.g_miss_char
2348     , p0_a187  VARCHAR2 := fnd_api.g_miss_char
2349     , p0_a188  VARCHAR2 := fnd_api.g_miss_char
2350     , p0_a189  NUMBER := 0-1962.0724
2351     , p0_a190  NUMBER := 0-1962.0724
2352     , p0_a191  NUMBER := 0-1962.0724
2353     , p0_a192  VARCHAR2 := fnd_api.g_miss_char
2354     , p0_a193  DATE := fnd_api.g_miss_date
2355     , p0_a194  VARCHAR2 := fnd_api.g_miss_char
2356     , p0_a195  DATE := fnd_api.g_miss_date
2357     , p0_a196  NUMBER := 0-1962.0724
2358     , p0_a197  NUMBER := 0-1962.0724
2359     , p0_a198  NUMBER := 0-1962.0724
2360     , p0_a199  NUMBER := 0-1962.0724
2361     , p0_a200  NUMBER := 0-1962.0724
2362     , p0_a201  NUMBER := 0-1962.0724
2363     , p0_a202  NUMBER := 0-1962.0724
2364     , p0_a203  NUMBER := 0-1962.0724
2365     , p0_a204  NUMBER := 0-1962.0724
2366     , p0_a205  NUMBER := 0-1962.0724
2367     , p0_a206  NUMBER := 0-1962.0724
2368     , p0_a207  NUMBER := 0-1962.0724
2369     , p0_a208  NUMBER := 0-1962.0724
2370     , p0_a209  NUMBER := 0-1962.0724
2371     , p0_a210  NUMBER := 0-1962.0724
2372     , p0_a211  NUMBER := 0-1962.0724
2373     , p0_a212  NUMBER := 0-1962.0724
2374     , p0_a213  NUMBER := 0-1962.0724
2375     , p0_a214  VARCHAR2 := fnd_api.g_miss_char
2376     , p0_a215  NUMBER := 0-1962.0724
2377   )
2378 
2379   as
2380     ddp_header_rec oe_order_pub.header_rec_type;
2381     ddindx binary_integer; indx binary_integer;
2382   begin
2383 
2384     -- copy data to the local IN or IN-OUT args, if any
2385     ddp_header_rec.accounting_rule_id := rosetta_g_miss_num_map(p0_a0);
2386     ddp_header_rec.agreement_id := rosetta_g_miss_num_map(p0_a1);
2387     ddp_header_rec.attribute1 := p0_a2;
2388     ddp_header_rec.attribute10 := p0_a3;
2389     ddp_header_rec.attribute11 := p0_a4;
2390     ddp_header_rec.attribute12 := p0_a5;
2391     ddp_header_rec.attribute13 := p0_a6;
2392     ddp_header_rec.attribute14 := p0_a7;
2393     ddp_header_rec.attribute15 := p0_a8;
2394     ddp_header_rec.attribute16 := p0_a9;
2395     ddp_header_rec.attribute17 := p0_a10;
2396     ddp_header_rec.attribute18 := p0_a11;
2397     ddp_header_rec.attribute19 := p0_a12;
2398     ddp_header_rec.attribute2 := p0_a13;
2399     ddp_header_rec.attribute20 := p0_a14;
2400     ddp_header_rec.attribute3 := p0_a15;
2401     ddp_header_rec.attribute4 := p0_a16;
2402     ddp_header_rec.attribute5 := p0_a17;
2403     ddp_header_rec.attribute6 := p0_a18;
2404     ddp_header_rec.attribute7 := p0_a19;
2405     ddp_header_rec.attribute8 := p0_a20;
2406     ddp_header_rec.attribute9 := p0_a21;
2407     ddp_header_rec.booked_flag := p0_a22;
2408     ddp_header_rec.cancelled_flag := p0_a23;
2409     ddp_header_rec.context := p0_a24;
2410     ddp_header_rec.conversion_rate := rosetta_g_miss_num_map(p0_a25);
2411     ddp_header_rec.conversion_rate_date := rosetta_g_miss_date_in_map(p0_a26);
2412     ddp_header_rec.conversion_type_code := p0_a27;
2413     ddp_header_rec.customer_preference_set_code := p0_a28;
2414     ddp_header_rec.created_by := rosetta_g_miss_num_map(p0_a29);
2415     ddp_header_rec.creation_date := rosetta_g_miss_date_in_map(p0_a30);
2416     ddp_header_rec.cust_po_number := p0_a31;
2417     ddp_header_rec.deliver_to_contact_id := rosetta_g_miss_num_map(p0_a32);
2418     ddp_header_rec.deliver_to_org_id := rosetta_g_miss_num_map(p0_a33);
2419     ddp_header_rec.demand_class_code := p0_a34;
2420     ddp_header_rec.earliest_schedule_limit := rosetta_g_miss_num_map(p0_a35);
2421     ddp_header_rec.expiration_date := rosetta_g_miss_date_in_map(p0_a36);
2422     ddp_header_rec.fob_point_code := p0_a37;
2423     ddp_header_rec.freight_carrier_code := p0_a38;
2424     ddp_header_rec.freight_terms_code := p0_a39;
2425     ddp_header_rec.global_attribute1 := p0_a40;
2426     ddp_header_rec.global_attribute10 := p0_a41;
2427     ddp_header_rec.global_attribute11 := p0_a42;
2428     ddp_header_rec.global_attribute12 := p0_a43;
2429     ddp_header_rec.global_attribute13 := p0_a44;
2430     ddp_header_rec.global_attribute14 := p0_a45;
2431     ddp_header_rec.global_attribute15 := p0_a46;
2432     ddp_header_rec.global_attribute16 := p0_a47;
2433     ddp_header_rec.global_attribute17 := p0_a48;
2434     ddp_header_rec.global_attribute18 := p0_a49;
2435     ddp_header_rec.global_attribute19 := p0_a50;
2436     ddp_header_rec.global_attribute2 := p0_a51;
2437     ddp_header_rec.global_attribute20 := p0_a52;
2438     ddp_header_rec.global_attribute3 := p0_a53;
2439     ddp_header_rec.global_attribute4 := p0_a54;
2440     ddp_header_rec.global_attribute5 := p0_a55;
2441     ddp_header_rec.global_attribute6 := p0_a56;
2442     ddp_header_rec.global_attribute7 := p0_a57;
2443     ddp_header_rec.global_attribute8 := p0_a58;
2444     ddp_header_rec.global_attribute9 := p0_a59;
2445     ddp_header_rec.global_attribute_category := p0_a60;
2446     ddp_header_rec.tp_context := p0_a61;
2447     ddp_header_rec.tp_attribute1 := p0_a62;
2448     ddp_header_rec.tp_attribute2 := p0_a63;
2449     ddp_header_rec.tp_attribute3 := p0_a64;
2450     ddp_header_rec.tp_attribute4 := p0_a65;
2451     ddp_header_rec.tp_attribute5 := p0_a66;
2452     ddp_header_rec.tp_attribute6 := p0_a67;
2453     ddp_header_rec.tp_attribute7 := p0_a68;
2454     ddp_header_rec.tp_attribute8 := p0_a69;
2455     ddp_header_rec.tp_attribute9 := p0_a70;
2456     ddp_header_rec.tp_attribute10 := p0_a71;
2457     ddp_header_rec.tp_attribute11 := p0_a72;
2458     ddp_header_rec.tp_attribute12 := p0_a73;
2459     ddp_header_rec.tp_attribute13 := p0_a74;
2460     ddp_header_rec.tp_attribute14 := p0_a75;
2461     ddp_header_rec.tp_attribute15 := p0_a76;
2462     ddp_header_rec.header_id := rosetta_g_miss_num_map(p0_a77);
2463     ddp_header_rec.invoice_to_contact_id := rosetta_g_miss_num_map(p0_a78);
2464     ddp_header_rec.invoice_to_org_id := rosetta_g_miss_num_map(p0_a79);
2465     ddp_header_rec.invoicing_rule_id := rosetta_g_miss_num_map(p0_a80);
2466     ddp_header_rec.last_updated_by := rosetta_g_miss_num_map(p0_a81);
2467     ddp_header_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a82);
2468     ddp_header_rec.last_update_login := rosetta_g_miss_num_map(p0_a83);
2469     ddp_header_rec.latest_schedule_limit := rosetta_g_miss_num_map(p0_a84);
2470     ddp_header_rec.open_flag := p0_a85;
2471     ddp_header_rec.order_category_code := p0_a86;
2472     ddp_header_rec.ordered_date := rosetta_g_miss_date_in_map(p0_a87);
2473     ddp_header_rec.order_date_type_code := p0_a88;
2474     ddp_header_rec.order_number := rosetta_g_miss_num_map(p0_a89);
2475     ddp_header_rec.order_source_id := rosetta_g_miss_num_map(p0_a90);
2476     ddp_header_rec.order_type_id := rosetta_g_miss_num_map(p0_a91);
2477     ddp_header_rec.org_id := rosetta_g_miss_num_map(p0_a92);
2478     ddp_header_rec.orig_sys_document_ref := p0_a93;
2479     ddp_header_rec.partial_shipments_allowed := p0_a94;
2480     ddp_header_rec.payment_term_id := rosetta_g_miss_num_map(p0_a95);
2481     ddp_header_rec.price_list_id := rosetta_g_miss_num_map(p0_a96);
2482     ddp_header_rec.price_request_code := p0_a97;
2483     ddp_header_rec.pricing_date := rosetta_g_miss_date_in_map(p0_a98);
2484     ddp_header_rec.program_application_id := rosetta_g_miss_num_map(p0_a99);
2485     ddp_header_rec.program_id := rosetta_g_miss_num_map(p0_a100);
2486     ddp_header_rec.program_update_date := rosetta_g_miss_date_in_map(p0_a101);
2487     ddp_header_rec.request_date := rosetta_g_miss_date_in_map(p0_a102);
2488     ddp_header_rec.request_id := rosetta_g_miss_num_map(p0_a103);
2489     ddp_header_rec.return_reason_code := p0_a104;
2490     ddp_header_rec.salesrep_id := rosetta_g_miss_num_map(p0_a105);
2491     ddp_header_rec.sales_channel_code := p0_a106;
2492     ddp_header_rec.shipment_priority_code := p0_a107;
2493     ddp_header_rec.shipping_method_code := p0_a108;
2494     ddp_header_rec.ship_from_org_id := rosetta_g_miss_num_map(p0_a109);
2495     ddp_header_rec.ship_tolerance_above := rosetta_g_miss_num_map(p0_a110);
2496     ddp_header_rec.ship_tolerance_below := rosetta_g_miss_num_map(p0_a111);
2497     ddp_header_rec.ship_to_contact_id := rosetta_g_miss_num_map(p0_a112);
2498     ddp_header_rec.ship_to_org_id := rosetta_g_miss_num_map(p0_a113);
2499     ddp_header_rec.sold_from_org_id := rosetta_g_miss_num_map(p0_a114);
2500     ddp_header_rec.sold_to_contact_id := rosetta_g_miss_num_map(p0_a115);
2501     ddp_header_rec.sold_to_org_id := rosetta_g_miss_num_map(p0_a116);
2502     ddp_header_rec.sold_to_phone_id := rosetta_g_miss_num_map(p0_a117);
2503     ddp_header_rec.source_document_id := rosetta_g_miss_num_map(p0_a118);
2504     ddp_header_rec.source_document_type_id := rosetta_g_miss_num_map(p0_a119);
2505     ddp_header_rec.tax_exempt_flag := p0_a120;
2506     ddp_header_rec.tax_exempt_number := p0_a121;
2507     ddp_header_rec.tax_exempt_reason_code := p0_a122;
2508     ddp_header_rec.tax_point_code := p0_a123;
2509     ddp_header_rec.transactional_curr_code := p0_a124;
2510     ddp_header_rec.version_number := rosetta_g_miss_num_map(p0_a125);
2511     ddp_header_rec.return_status := p0_a126;
2512     ddp_header_rec.db_flag := p0_a127;
2513     ddp_header_rec.operation := p0_a128;
2514     ddp_header_rec.first_ack_code := p0_a129;
2515     ddp_header_rec.first_ack_date := rosetta_g_miss_date_in_map(p0_a130);
2516     ddp_header_rec.last_ack_code := p0_a131;
2517     ddp_header_rec.last_ack_date := rosetta_g_miss_date_in_map(p0_a132);
2518     ddp_header_rec.change_reason := p0_a133;
2519     ddp_header_rec.change_comments := p0_a134;
2520     ddp_header_rec.change_sequence := p0_a135;
2521     ddp_header_rec.change_request_code := p0_a136;
2522     ddp_header_rec.ready_flag := p0_a137;
2523     ddp_header_rec.status_flag := p0_a138;
2524     ddp_header_rec.force_apply_flag := p0_a139;
2525     ddp_header_rec.drop_ship_flag := p0_a140;
2526     ddp_header_rec.customer_payment_term_id := rosetta_g_miss_num_map(p0_a141);
2527     ddp_header_rec.payment_type_code := p0_a142;
2528     ddp_header_rec.payment_amount := rosetta_g_miss_num_map(p0_a143);
2529     ddp_header_rec.check_number := p0_a144;
2530     ddp_header_rec.credit_card_code := p0_a145;
2531     ddp_header_rec.credit_card_holder_name := p0_a146;
2532     ddp_header_rec.credit_card_number := p0_a147;
2533     ddp_header_rec.credit_card_expiration_date := rosetta_g_miss_date_in_map(p0_a148);
2534     ddp_header_rec.credit_card_approval_code := p0_a149;
2535     ddp_header_rec.credit_card_approval_date := rosetta_g_miss_date_in_map(p0_a150);
2536     ddp_header_rec.shipping_instructions := p0_a151;
2537     ddp_header_rec.packing_instructions := p0_a152;
2538     ddp_header_rec.flow_status_code := p0_a153;
2539     ddp_header_rec.booked_date := rosetta_g_miss_date_in_map(p0_a154);
2540     ddp_header_rec.marketing_source_code_id := rosetta_g_miss_num_map(p0_a155);
2541     ddp_header_rec.upgraded_flag := p0_a156;
2542     ddp_header_rec.lock_control := rosetta_g_miss_num_map(p0_a157);
2543     ddp_header_rec.ship_to_edi_location_code := p0_a158;
2544     ddp_header_rec.sold_to_edi_location_code := p0_a159;
2545     ddp_header_rec.bill_to_edi_location_code := p0_a160;
2546     ddp_header_rec.ship_from_edi_location_code := p0_a161;
2547     ddp_header_rec.ship_from_address_id := rosetta_g_miss_num_map(p0_a162);
2548     ddp_header_rec.sold_to_address_id := rosetta_g_miss_num_map(p0_a163);
2549     ddp_header_rec.ship_to_address_id := rosetta_g_miss_num_map(p0_a164);
2550     ddp_header_rec.invoice_address_id := rosetta_g_miss_num_map(p0_a165);
2551     ddp_header_rec.ship_to_address_code := p0_a166;
2552     ddp_header_rec.xml_message_id := rosetta_g_miss_num_map(p0_a167);
2553     ddp_header_rec.ship_to_customer_id := rosetta_g_miss_num_map(p0_a168);
2554     ddp_header_rec.invoice_to_customer_id := rosetta_g_miss_num_map(p0_a169);
2555     ddp_header_rec.deliver_to_customer_id := rosetta_g_miss_num_map(p0_a170);
2556     ddp_header_rec.accounting_rule_duration := rosetta_g_miss_num_map(p0_a171);
2557     ddp_header_rec.xml_transaction_type_code := p0_a172;
2558     ddp_header_rec.blanket_number := rosetta_g_miss_num_map(p0_a173);
2559     ddp_header_rec.line_set_name := p0_a174;
2560     ddp_header_rec.fulfillment_set_name := p0_a175;
2561     ddp_header_rec.default_fulfillment_set := p0_a176;
2562     ddp_header_rec.quote_date := rosetta_g_miss_date_in_map(p0_a177);
2563     ddp_header_rec.quote_number := rosetta_g_miss_num_map(p0_a178);
2564     ddp_header_rec.sales_document_name := p0_a179;
2565     ddp_header_rec.transaction_phase_code := p0_a180;
2566     ddp_header_rec.user_status_code := p0_a181;
2567     ddp_header_rec.draft_submitted_flag := p0_a182;
2568     ddp_header_rec.source_document_version_number := rosetta_g_miss_num_map(p0_a183);
2569     ddp_header_rec.sold_to_site_use_id := rosetta_g_miss_num_map(p0_a184);
2570     ddp_header_rec.minisite_id := rosetta_g_miss_num_map(p0_a185);
2571     ddp_header_rec.ib_owner := p0_a186;
2572     ddp_header_rec.ib_installed_at_location := p0_a187;
2573     ddp_header_rec.ib_current_location := p0_a188;
2574     ddp_header_rec.end_customer_id := rosetta_g_miss_num_map(p0_a189);
2575     ddp_header_rec.end_customer_contact_id := rosetta_g_miss_num_map(p0_a190);
2576     ddp_header_rec.end_customer_site_use_id := rosetta_g_miss_num_map(p0_a191);
2577     ddp_header_rec.supplier_signature := p0_a192;
2578     ddp_header_rec.supplier_signature_date := rosetta_g_miss_date_in_map(p0_a193);
2579     ddp_header_rec.customer_signature := p0_a194;
2580     ddp_header_rec.customer_signature_date := rosetta_g_miss_date_in_map(p0_a195);
2581     ddp_header_rec.sold_to_party_id := rosetta_g_miss_num_map(p0_a196);
2582     ddp_header_rec.sold_to_org_contact_id := rosetta_g_miss_num_map(p0_a197);
2583     ddp_header_rec.ship_to_party_id := rosetta_g_miss_num_map(p0_a198);
2584     ddp_header_rec.ship_to_party_site_id := rosetta_g_miss_num_map(p0_a199);
2585     ddp_header_rec.ship_to_party_site_use_id := rosetta_g_miss_num_map(p0_a200);
2586     ddp_header_rec.deliver_to_party_id := rosetta_g_miss_num_map(p0_a201);
2587     ddp_header_rec.deliver_to_party_site_id := rosetta_g_miss_num_map(p0_a202);
2588     ddp_header_rec.deliver_to_party_site_use_id := rosetta_g_miss_num_map(p0_a203);
2589     ddp_header_rec.invoice_to_party_id := rosetta_g_miss_num_map(p0_a204);
2590     ddp_header_rec.invoice_to_party_site_id := rosetta_g_miss_num_map(p0_a205);
2591     ddp_header_rec.invoice_to_party_site_use_id := rosetta_g_miss_num_map(p0_a206);
2592     ddp_header_rec.ship_to_customer_party_id := rosetta_g_miss_num_map(p0_a207);
2593     ddp_header_rec.deliver_to_customer_party_id := rosetta_g_miss_num_map(p0_a208);
2594     ddp_header_rec.invoice_to_customer_party_id := rosetta_g_miss_num_map(p0_a209);
2595     ddp_header_rec.ship_to_org_contact_id := rosetta_g_miss_num_map(p0_a210);
2596     ddp_header_rec.deliver_to_org_contact_id := rosetta_g_miss_num_map(p0_a211);
2597     ddp_header_rec.invoice_to_org_contact_id := rosetta_g_miss_num_map(p0_a212);
2598     ddp_header_rec.contract_template_id := rosetta_g_miss_num_map(p0_a213);
2599     ddp_header_rec.contract_source_doc_type_code := p0_a214;
2600     ddp_header_rec.contract_source_document_id := rosetta_g_miss_num_map(p0_a215);
2601 
2602     -- here's the delegated call to the old PL/SQL routine
2603     oe_portal_util.set_header_cache(ddp_header_rec);
2604 
2605     -- copy data back from the local variables to OUT NOCOPY /* file.sql.39 change */ or IN-OUT args, if any
2606   end;
2607 
2608   procedure get_header(p_header_id  NUMBER
2609     , p1_a0 out NOCOPY /* file.sql.39 change */  NUMBER
2610     , p1_a1 out NOCOPY /* file.sql.39 change */  NUMBER
2611     , p1_a2 out NOCOPY /* file.sql.39 change */  VARCHAR2
2612     , p1_a3 out NOCOPY /* file.sql.39 change */  VARCHAR2
2613     , p1_a4 out NOCOPY /* file.sql.39 change */  VARCHAR2
2614     , p1_a5 out NOCOPY /* file.sql.39 change */  VARCHAR2
2615     , p1_a6 out NOCOPY /* file.sql.39 change */  VARCHAR2
2616     , p1_a7 out NOCOPY /* file.sql.39 change */  VARCHAR2
2617     , p1_a8 out NOCOPY /* file.sql.39 change */  VARCHAR2
2618     , p1_a9 out NOCOPY /* file.sql.39 change */  VARCHAR2
2619     , p1_a10 out NOCOPY /* file.sql.39 change */  VARCHAR2
2620     , p1_a11 out NOCOPY /* file.sql.39 change */  VARCHAR2
2621     , p1_a12 out NOCOPY /* file.sql.39 change */  VARCHAR2
2622     , p1_a13 out NOCOPY /* file.sql.39 change */  VARCHAR2
2623     , p1_a14 out NOCOPY /* file.sql.39 change */  VARCHAR2
2624     , p1_a15 out NOCOPY /* file.sql.39 change */  VARCHAR2
2625     , p1_a16 out NOCOPY /* file.sql.39 change */  VARCHAR2
2626     , p1_a17 out NOCOPY /* file.sql.39 change */  VARCHAR2
2627     , p1_a18 out NOCOPY /* file.sql.39 change */  VARCHAR2
2628     , p1_a19 out NOCOPY /* file.sql.39 change */  VARCHAR2
2629     , p1_a20 out NOCOPY /* file.sql.39 change */  VARCHAR2
2630     , p1_a21 out NOCOPY /* file.sql.39 change */  VARCHAR2
2631     , p1_a22 out NOCOPY /* file.sql.39 change */  VARCHAR2
2632     , p1_a23 out NOCOPY /* file.sql.39 change */  VARCHAR2
2633     , p1_a24 out NOCOPY /* file.sql.39 change */  VARCHAR2
2634     , p1_a25 out NOCOPY /* file.sql.39 change */  NUMBER
2635     , p1_a26 out NOCOPY /* file.sql.39 change */  DATE
2636     , p1_a27 out NOCOPY /* file.sql.39 change */  VARCHAR2
2637     , p1_a28 out NOCOPY /* file.sql.39 change */  VARCHAR2
2638     , p1_a29 out NOCOPY /* file.sql.39 change */  NUMBER
2639     , p1_a30 out NOCOPY /* file.sql.39 change */  DATE
2640     , p1_a31 out NOCOPY /* file.sql.39 change */  VARCHAR2
2641     , p1_a32 out NOCOPY /* file.sql.39 change */  NUMBER
2642     , p1_a33 out NOCOPY /* file.sql.39 change */  NUMBER
2643     , p1_a34 out NOCOPY /* file.sql.39 change */  VARCHAR2
2644     , p1_a35 out NOCOPY /* file.sql.39 change */  NUMBER
2645     , p1_a36 out NOCOPY /* file.sql.39 change */  DATE
2646     , p1_a37 out NOCOPY /* file.sql.39 change */  VARCHAR2
2647     , p1_a38 out NOCOPY /* file.sql.39 change */  VARCHAR2
2648     , p1_a39 out NOCOPY /* file.sql.39 change */  VARCHAR2
2649     , p1_a40 out NOCOPY /* file.sql.39 change */  VARCHAR2
2650     , p1_a41 out NOCOPY /* file.sql.39 change */  VARCHAR2
2651     , p1_a42 out NOCOPY /* file.sql.39 change */  VARCHAR2
2652     , p1_a43 out NOCOPY /* file.sql.39 change */  VARCHAR2
2653     , p1_a44 out NOCOPY /* file.sql.39 change */  VARCHAR2
2654     , p1_a45 out NOCOPY /* file.sql.39 change */  VARCHAR2
2655     , p1_a46 out NOCOPY /* file.sql.39 change */  VARCHAR2
2656     , p1_a47 out NOCOPY /* file.sql.39 change */  VARCHAR2
2657     , p1_a48 out NOCOPY /* file.sql.39 change */  VARCHAR2
2658     , p1_a49 out NOCOPY /* file.sql.39 change */  VARCHAR2
2659     , p1_a50 out NOCOPY /* file.sql.39 change */  VARCHAR2
2660     , p1_a51 out NOCOPY /* file.sql.39 change */  VARCHAR2
2661     , p1_a52 out NOCOPY /* file.sql.39 change */  VARCHAR2
2662     , p1_a53 out NOCOPY /* file.sql.39 change */  VARCHAR2
2663     , p1_a54 out NOCOPY /* file.sql.39 change */  VARCHAR2
2664     , p1_a55 out NOCOPY /* file.sql.39 change */  VARCHAR2
2665     , p1_a56 out NOCOPY /* file.sql.39 change */  VARCHAR2
2666     , p1_a57 out NOCOPY /* file.sql.39 change */  VARCHAR2
2667     , p1_a58 out NOCOPY /* file.sql.39 change */  VARCHAR2
2668     , p1_a59 out NOCOPY /* file.sql.39 change */  VARCHAR2
2669     , p1_a60 out NOCOPY /* file.sql.39 change */  VARCHAR2
2670     , p1_a61 out NOCOPY /* file.sql.39 change */  VARCHAR2
2671     , p1_a62 out NOCOPY /* file.sql.39 change */  VARCHAR2
2672     , p1_a63 out NOCOPY /* file.sql.39 change */  VARCHAR2
2673     , p1_a64 out NOCOPY /* file.sql.39 change */  VARCHAR2
2674     , p1_a65 out NOCOPY /* file.sql.39 change */  VARCHAR2
2675     , p1_a66 out NOCOPY /* file.sql.39 change */  VARCHAR2
2676     , p1_a67 out NOCOPY /* file.sql.39 change */  VARCHAR2
2677     , p1_a68 out NOCOPY /* file.sql.39 change */  VARCHAR2
2678     , p1_a69 out NOCOPY /* file.sql.39 change */  VARCHAR2
2679     , p1_a70 out NOCOPY /* file.sql.39 change */  VARCHAR2
2680     , p1_a71 out NOCOPY /* file.sql.39 change */  VARCHAR2
2681     , p1_a72 out NOCOPY /* file.sql.39 change */  VARCHAR2
2682     , p1_a73 out NOCOPY /* file.sql.39 change */  VARCHAR2
2683     , p1_a74 out NOCOPY /* file.sql.39 change */  VARCHAR2
2684     , p1_a75 out NOCOPY /* file.sql.39 change */  VARCHAR2
2685     , p1_a76 out NOCOPY /* file.sql.39 change */  VARCHAR2
2686     , p1_a77 out NOCOPY /* file.sql.39 change */  NUMBER
2687     , p1_a78 out NOCOPY /* file.sql.39 change */  NUMBER
2688     , p1_a79 out NOCOPY /* file.sql.39 change */  NUMBER
2689     , p1_a80 out NOCOPY /* file.sql.39 change */  NUMBER
2690     , p1_a81 out NOCOPY /* file.sql.39 change */  NUMBER
2691     , p1_a82 out NOCOPY /* file.sql.39 change */  DATE
2692     , p1_a83 out NOCOPY /* file.sql.39 change */  NUMBER
2693     , p1_a84 out NOCOPY /* file.sql.39 change */  NUMBER
2694     , p1_a85 out NOCOPY /* file.sql.39 change */  VARCHAR2
2695     , p1_a86 out NOCOPY /* file.sql.39 change */  VARCHAR2
2696     , p1_a87 out NOCOPY /* file.sql.39 change */  DATE
2697     , p1_a88 out NOCOPY /* file.sql.39 change */  VARCHAR2
2698     , p1_a89 out NOCOPY /* file.sql.39 change */  NUMBER
2699     , p1_a90 out NOCOPY /* file.sql.39 change */  NUMBER
2700     , p1_a91 out NOCOPY /* file.sql.39 change */  NUMBER
2701     , p1_a92 out NOCOPY /* file.sql.39 change */  NUMBER
2702     , p1_a93 out NOCOPY /* file.sql.39 change */  VARCHAR2
2703     , p1_a94 out NOCOPY /* file.sql.39 change */  VARCHAR2
2704     , p1_a95 out NOCOPY /* file.sql.39 change */  NUMBER
2705     , p1_a96 out NOCOPY /* file.sql.39 change */  NUMBER
2706     , p1_a97 out NOCOPY /* file.sql.39 change */  VARCHAR2
2707     , p1_a98 out NOCOPY /* file.sql.39 change */  DATE
2708     , p1_a99 out NOCOPY /* file.sql.39 change */  NUMBER
2709     , p1_a100 out NOCOPY /* file.sql.39 change */  NUMBER
2710     , p1_a101 out NOCOPY /* file.sql.39 change */  DATE
2711     , p1_a102 out NOCOPY /* file.sql.39 change */  DATE
2712     , p1_a103 out NOCOPY /* file.sql.39 change */  NUMBER
2713     , p1_a104 out NOCOPY /* file.sql.39 change */  VARCHAR2
2714     , p1_a105 out NOCOPY /* file.sql.39 change */  NUMBER
2715     , p1_a106 out NOCOPY /* file.sql.39 change */  VARCHAR2
2716     , p1_a107 out NOCOPY /* file.sql.39 change */  VARCHAR2
2717     , p1_a108 out NOCOPY /* file.sql.39 change */  VARCHAR2
2718     , p1_a109 out NOCOPY /* file.sql.39 change */  NUMBER
2719     , p1_a110 out NOCOPY /* file.sql.39 change */  NUMBER
2720     , p1_a111 out NOCOPY /* file.sql.39 change */  NUMBER
2721     , p1_a112 out NOCOPY /* file.sql.39 change */  NUMBER
2722     , p1_a113 out NOCOPY /* file.sql.39 change */  NUMBER
2723     , p1_a114 out NOCOPY /* file.sql.39 change */  NUMBER
2724     , p1_a115 out NOCOPY /* file.sql.39 change */  NUMBER
2725     , p1_a116 out NOCOPY /* file.sql.39 change */  NUMBER
2726     , p1_a117 out NOCOPY /* file.sql.39 change */  NUMBER
2727     , p1_a118 out NOCOPY /* file.sql.39 change */  NUMBER
2728     , p1_a119 out NOCOPY /* file.sql.39 change */  NUMBER
2729     , p1_a120 out NOCOPY /* file.sql.39 change */  VARCHAR2
2730     , p1_a121 out NOCOPY /* file.sql.39 change */  VARCHAR2
2731     , p1_a122 out NOCOPY /* file.sql.39 change */  VARCHAR2
2732     , p1_a123 out NOCOPY /* file.sql.39 change */  VARCHAR2
2733     , p1_a124 out NOCOPY /* file.sql.39 change */  VARCHAR2
2734     , p1_a125 out NOCOPY /* file.sql.39 change */  NUMBER
2735     , p1_a126 out NOCOPY /* file.sql.39 change */  VARCHAR2
2736     , p1_a127 out NOCOPY /* file.sql.39 change */  VARCHAR2
2737     , p1_a128 out NOCOPY /* file.sql.39 change */  VARCHAR2
2738     , p1_a129 out NOCOPY /* file.sql.39 change */  VARCHAR2
2739     , p1_a130 out NOCOPY /* file.sql.39 change */  DATE
2740     , p1_a131 out NOCOPY /* file.sql.39 change */  VARCHAR2
2741     , p1_a132 out NOCOPY /* file.sql.39 change */  DATE
2742     , p1_a133 out NOCOPY /* file.sql.39 change */  VARCHAR2
2743     , p1_a134 out NOCOPY /* file.sql.39 change */  VARCHAR2
2744     , p1_a135 out NOCOPY /* file.sql.39 change */  VARCHAR2
2745     , p1_a136 out NOCOPY /* file.sql.39 change */  VARCHAR2
2746     , p1_a137 out NOCOPY /* file.sql.39 change */  VARCHAR2
2747     , p1_a138 out NOCOPY /* file.sql.39 change */  VARCHAR2
2748     , p1_a139 out NOCOPY /* file.sql.39 change */  VARCHAR2
2749     , p1_a140 out NOCOPY /* file.sql.39 change */  VARCHAR2
2750     , p1_a141 out NOCOPY /* file.sql.39 change */  NUMBER
2751     , p1_a142 out NOCOPY /* file.sql.39 change */  VARCHAR2
2752     , p1_a143 out NOCOPY /* file.sql.39 change */  NUMBER
2753     , p1_a144 out NOCOPY /* file.sql.39 change */  VARCHAR2
2754     , p1_a145 out NOCOPY /* file.sql.39 change */  VARCHAR2
2755     , p1_a146 out NOCOPY /* file.sql.39 change */  VARCHAR2
2756     , p1_a147 out NOCOPY /* file.sql.39 change */  VARCHAR2
2757     , p1_a148 out NOCOPY /* file.sql.39 change */  DATE
2758     , p1_a149 out NOCOPY /* file.sql.39 change */  VARCHAR2
2759     , p1_a150 out NOCOPY /* file.sql.39 change */  DATE
2760     , p1_a151 out NOCOPY /* file.sql.39 change */  VARCHAR2
2761     , p1_a152 out NOCOPY /* file.sql.39 change */  VARCHAR2
2762     , p1_a153 out NOCOPY /* file.sql.39 change */  VARCHAR2
2763     , p1_a154 out NOCOPY /* file.sql.39 change */  DATE
2764     , p1_a155 out NOCOPY /* file.sql.39 change */  NUMBER
2765     , p1_a156 out NOCOPY /* file.sql.39 change */  VARCHAR2
2766     , p1_a157 out NOCOPY /* file.sql.39 change */  NUMBER
2767     , p1_a158 out NOCOPY /* file.sql.39 change */  VARCHAR2
2768     , p1_a159 out NOCOPY /* file.sql.39 change */  VARCHAR2
2769     , p1_a160 out NOCOPY /* file.sql.39 change */  VARCHAR2
2770     , p1_a161 out NOCOPY /* file.sql.39 change */  VARCHAR2
2771     , p1_a162 out NOCOPY /* file.sql.39 change */  NUMBER
2772     , p1_a163 out NOCOPY /* file.sql.39 change */  NUMBER
2773     , p1_a164 out NOCOPY /* file.sql.39 change */  NUMBER
2774     , p1_a165 out NOCOPY /* file.sql.39 change */  NUMBER
2775     , p1_a166 out NOCOPY /* file.sql.39 change */  VARCHAR2
2776     , p1_a167 out NOCOPY /* file.sql.39 change */  NUMBER
2777     , p1_a168 out NOCOPY /* file.sql.39 change */  NUMBER
2778     , p1_a169 out NOCOPY /* file.sql.39 change */  NUMBER
2779     , p1_a170 out NOCOPY /* file.sql.39 change */  NUMBER
2780     , p1_a171 out NOCOPY /* file.sql.39 change */  NUMBER
2781     , p1_a172 out NOCOPY /* file.sql.39 change */  VARCHAR2
2782     , p1_a173 out NOCOPY /* file.sql.39 change */  NUMBER
2783     , p1_a174 out NOCOPY /* file.sql.39 change */  VARCHAR2
2784     , p1_a175 out NOCOPY /* file.sql.39 change */  VARCHAR2
2785     , p1_a176 out NOCOPY /* file.sql.39 change */  VARCHAR2
2786     , p1_a177 out NOCOPY /* file.sql.39 change */  DATE
2787     , p1_a178 out NOCOPY /* file.sql.39 change */  NUMBER
2788     , p1_a179 out NOCOPY /* file.sql.39 change */  VARCHAR2
2789     , p1_a180 out NOCOPY /* file.sql.39 change */  VARCHAR2
2790     , p1_a181 out NOCOPY /* file.sql.39 change */  VARCHAR2
2791     , p1_a182 out NOCOPY /* file.sql.39 change */  VARCHAR2
2792     , p1_a183 out NOCOPY /* file.sql.39 change */  NUMBER
2793     , p1_a184 out NOCOPY /* file.sql.39 change */  NUMBER
2794     , p1_a185 out NOCOPY /* file.sql.39 change */  NUMBER
2795     , p1_a186 out NOCOPY /* file.sql.39 change */  VARCHAR2
2796     , p1_a187 out NOCOPY /* file.sql.39 change */  VARCHAR2
2797     , p1_a188 out NOCOPY /* file.sql.39 change */  VARCHAR2
2798     , p1_a189 out NOCOPY /* file.sql.39 change */  NUMBER
2799     , p1_a190 out NOCOPY /* file.sql.39 change */  NUMBER
2800     , p1_a191 out NOCOPY /* file.sql.39 change */  NUMBER
2801     , p1_a192 out NOCOPY /* file.sql.39 change */  VARCHAR2
2802     , p1_a193 out NOCOPY /* file.sql.39 change */  DATE
2803     , p1_a194 out NOCOPY /* file.sql.39 change */  VARCHAR2
2804     , p1_a195 out NOCOPY /* file.sql.39 change */  DATE
2805     , p1_a196 out NOCOPY /* file.sql.39 change */  NUMBER
2806     , p1_a197 out NOCOPY /* file.sql.39 change */  NUMBER
2807     , p1_a198 out NOCOPY /* file.sql.39 change */  NUMBER
2808     , p1_a199 out NOCOPY /* file.sql.39 change */  NUMBER
2809     , p1_a200 out NOCOPY /* file.sql.39 change */  NUMBER
2810     , p1_a201 out NOCOPY /* file.sql.39 change */  NUMBER
2811     , p1_a202 out NOCOPY /* file.sql.39 change */  NUMBER
2812     , p1_a203 out NOCOPY /* file.sql.39 change */  NUMBER
2813     , p1_a204 out NOCOPY /* file.sql.39 change */  NUMBER
2814     , p1_a205 out NOCOPY /* file.sql.39 change */  NUMBER
2815     , p1_a206 out NOCOPY /* file.sql.39 change */  NUMBER
2816     , p1_a207 out NOCOPY /* file.sql.39 change */  NUMBER
2817     , p1_a208 out NOCOPY /* file.sql.39 change */  NUMBER
2818     , p1_a209 out NOCOPY /* file.sql.39 change */  NUMBER
2819     , p1_a210 out NOCOPY /* file.sql.39 change */  NUMBER
2820     , p1_a211 out NOCOPY /* file.sql.39 change */  NUMBER
2821     , p1_a212 out NOCOPY /* file.sql.39 change */  NUMBER
2822     , p1_a213 out NOCOPY /* file.sql.39 change */  NUMBER
2823     , p1_a214 out NOCOPY /* file.sql.39 change */  VARCHAR2
2824     , p1_a215 out NOCOPY /* file.sql.39 change */  NUMBER
2825   )
2826 
2827   as
2828     ddx_header_rec oe_order_pub.header_rec_type;
2829     ddindx binary_integer; indx binary_integer;
2830   begin
2831 
2832     -- copy data to the local IN or IN-OUT args, if any
2833 
2834 
2835     -- here's the delegated call to the old PL/SQL routine
2836     oe_portal_util.get_header(p_header_id,
2837       ddx_header_rec);
2838 
2839     -- copy data back from the local variables to OUT NOCOPY /* file.sql.39 change */ or IN-OUT args, if any
2840 
2841     p1_a0 := rosetta_g_miss_num_map(ddx_header_rec.accounting_rule_id);
2842     p1_a1 := rosetta_g_miss_num_map(ddx_header_rec.agreement_id);
2843     p1_a2 := ddx_header_rec.attribute1;
2844     p1_a3 := ddx_header_rec.attribute10;
2845     p1_a4 := ddx_header_rec.attribute11;
2846     p1_a5 := ddx_header_rec.attribute12;
2847     p1_a6 := ddx_header_rec.attribute13;
2848     p1_a7 := ddx_header_rec.attribute14;
2849     p1_a8 := ddx_header_rec.attribute15;
2850     p1_a9 := ddx_header_rec.attribute16;
2851     p1_a10 := ddx_header_rec.attribute17;
2852     p1_a11 := ddx_header_rec.attribute18;
2853     p1_a12 := ddx_header_rec.attribute19;
2854     p1_a13 := ddx_header_rec.attribute2;
2855     p1_a14 := ddx_header_rec.attribute20;
2856     p1_a15 := ddx_header_rec.attribute3;
2857     p1_a16 := ddx_header_rec.attribute4;
2858     p1_a17 := ddx_header_rec.attribute5;
2859     p1_a18 := ddx_header_rec.attribute6;
2860     p1_a19 := ddx_header_rec.attribute7;
2861     p1_a20 := ddx_header_rec.attribute8;
2862     p1_a21 := ddx_header_rec.attribute9;
2863     p1_a22 := ddx_header_rec.booked_flag;
2864     p1_a23 := ddx_header_rec.cancelled_flag;
2865     p1_a24 := ddx_header_rec.context;
2866     p1_a25 := rosetta_g_miss_num_map(ddx_header_rec.conversion_rate);
2867     p1_a26 := ddx_header_rec.conversion_rate_date;
2868     p1_a27 := ddx_header_rec.conversion_type_code;
2869     p1_a28 := ddx_header_rec.customer_preference_set_code;
2870     p1_a29 := rosetta_g_miss_num_map(ddx_header_rec.created_by);
2871     p1_a30 := ddx_header_rec.creation_date;
2872     p1_a31 := ddx_header_rec.cust_po_number;
2873     p1_a32 := rosetta_g_miss_num_map(ddx_header_rec.deliver_to_contact_id);
2874     p1_a33 := rosetta_g_miss_num_map(ddx_header_rec.deliver_to_org_id);
2875     p1_a34 := ddx_header_rec.demand_class_code;
2876     p1_a35 := rosetta_g_miss_num_map(ddx_header_rec.earliest_schedule_limit);
2877     p1_a36 := ddx_header_rec.expiration_date;
2878     p1_a37 := ddx_header_rec.fob_point_code;
2879     p1_a38 := ddx_header_rec.freight_carrier_code;
2880     p1_a39 := ddx_header_rec.freight_terms_code;
2881     p1_a40 := ddx_header_rec.global_attribute1;
2882     p1_a41 := ddx_header_rec.global_attribute10;
2883     p1_a42 := ddx_header_rec.global_attribute11;
2884     p1_a43 := ddx_header_rec.global_attribute12;
2885     p1_a44 := ddx_header_rec.global_attribute13;
2886     p1_a45 := ddx_header_rec.global_attribute14;
2887     p1_a46 := ddx_header_rec.global_attribute15;
2888     p1_a47 := ddx_header_rec.global_attribute16;
2889     p1_a48 := ddx_header_rec.global_attribute17;
2890     p1_a49 := ddx_header_rec.global_attribute18;
2891     p1_a50 := ddx_header_rec.global_attribute19;
2892     p1_a51 := ddx_header_rec.global_attribute2;
2893     p1_a52 := ddx_header_rec.global_attribute20;
2894     p1_a53 := ddx_header_rec.global_attribute3;
2895     p1_a54 := ddx_header_rec.global_attribute4;
2896     p1_a55 := ddx_header_rec.global_attribute5;
2897     p1_a56 := ddx_header_rec.global_attribute6;
2898     p1_a57 := ddx_header_rec.global_attribute7;
2899     p1_a58 := ddx_header_rec.global_attribute8;
2900     p1_a59 := ddx_header_rec.global_attribute9;
2901     p1_a60 := ddx_header_rec.global_attribute_category;
2902     p1_a61 := ddx_header_rec.tp_context;
2903     p1_a62 := ddx_header_rec.tp_attribute1;
2904     p1_a63 := ddx_header_rec.tp_attribute2;
2905     p1_a64 := ddx_header_rec.tp_attribute3;
2906     p1_a65 := ddx_header_rec.tp_attribute4;
2907     p1_a66 := ddx_header_rec.tp_attribute5;
2908     p1_a67 := ddx_header_rec.tp_attribute6;
2909     p1_a68 := ddx_header_rec.tp_attribute7;
2910     p1_a69 := ddx_header_rec.tp_attribute8;
2911     p1_a70 := ddx_header_rec.tp_attribute9;
2912     p1_a71 := ddx_header_rec.tp_attribute10;
2913     p1_a72 := ddx_header_rec.tp_attribute11;
2914     p1_a73 := ddx_header_rec.tp_attribute12;
2915     p1_a74 := ddx_header_rec.tp_attribute13;
2916     p1_a75 := ddx_header_rec.tp_attribute14;
2917     p1_a76 := ddx_header_rec.tp_attribute15;
2918     p1_a77 := rosetta_g_miss_num_map(ddx_header_rec.header_id);
2919     p1_a78 := rosetta_g_miss_num_map(ddx_header_rec.invoice_to_contact_id);
2920     p1_a79 := rosetta_g_miss_num_map(ddx_header_rec.invoice_to_org_id);
2921     p1_a80 := rosetta_g_miss_num_map(ddx_header_rec.invoicing_rule_id);
2922     p1_a81 := rosetta_g_miss_num_map(ddx_header_rec.last_updated_by);
2923     p1_a82 := ddx_header_rec.last_update_date;
2924     p1_a83 := rosetta_g_miss_num_map(ddx_header_rec.last_update_login);
2925     p1_a84 := rosetta_g_miss_num_map(ddx_header_rec.latest_schedule_limit);
2926     p1_a85 := ddx_header_rec.open_flag;
2927     p1_a86 := ddx_header_rec.order_category_code;
2928     p1_a87 := ddx_header_rec.ordered_date;
2929     p1_a88 := ddx_header_rec.order_date_type_code;
2930     p1_a89 := rosetta_g_miss_num_map(ddx_header_rec.order_number);
2931     p1_a90 := rosetta_g_miss_num_map(ddx_header_rec.order_source_id);
2932     p1_a91 := rosetta_g_miss_num_map(ddx_header_rec.order_type_id);
2933     p1_a92 := rosetta_g_miss_num_map(ddx_header_rec.org_id);
2934     p1_a93 := ddx_header_rec.orig_sys_document_ref;
2935     p1_a94 := ddx_header_rec.partial_shipments_allowed;
2936     p1_a95 := rosetta_g_miss_num_map(ddx_header_rec.payment_term_id);
2937     p1_a96 := rosetta_g_miss_num_map(ddx_header_rec.price_list_id);
2938     p1_a97 := ddx_header_rec.price_request_code;
2939     p1_a98 := ddx_header_rec.pricing_date;
2940     p1_a99 := rosetta_g_miss_num_map(ddx_header_rec.program_application_id);
2941     p1_a100 := rosetta_g_miss_num_map(ddx_header_rec.program_id);
2942     p1_a101 := ddx_header_rec.program_update_date;
2943     p1_a102 := ddx_header_rec.request_date;
2944     p1_a103 := rosetta_g_miss_num_map(ddx_header_rec.request_id);
2945     p1_a104 := ddx_header_rec.return_reason_code;
2946     p1_a105 := rosetta_g_miss_num_map(ddx_header_rec.salesrep_id);
2947     p1_a106 := ddx_header_rec.sales_channel_code;
2948     p1_a107 := ddx_header_rec.shipment_priority_code;
2949     p1_a108 := ddx_header_rec.shipping_method_code;
2950     p1_a109 := rosetta_g_miss_num_map(ddx_header_rec.ship_from_org_id);
2951     p1_a110 := rosetta_g_miss_num_map(ddx_header_rec.ship_tolerance_above);
2952     p1_a111 := rosetta_g_miss_num_map(ddx_header_rec.ship_tolerance_below);
2953     p1_a112 := rosetta_g_miss_num_map(ddx_header_rec.ship_to_contact_id);
2954     p1_a113 := rosetta_g_miss_num_map(ddx_header_rec.ship_to_org_id);
2955     p1_a114 := rosetta_g_miss_num_map(ddx_header_rec.sold_from_org_id);
2956     p1_a115 := rosetta_g_miss_num_map(ddx_header_rec.sold_to_contact_id);
2957     p1_a116 := rosetta_g_miss_num_map(ddx_header_rec.sold_to_org_id);
2958     p1_a117 := rosetta_g_miss_num_map(ddx_header_rec.sold_to_phone_id);
2959     p1_a118 := rosetta_g_miss_num_map(ddx_header_rec.source_document_id);
2960     p1_a119 := rosetta_g_miss_num_map(ddx_header_rec.source_document_type_id);
2961     p1_a120 := ddx_header_rec.tax_exempt_flag;
2962     p1_a121 := ddx_header_rec.tax_exempt_number;
2963     p1_a122 := ddx_header_rec.tax_exempt_reason_code;
2964     p1_a123 := ddx_header_rec.tax_point_code;
2965     p1_a124 := ddx_header_rec.transactional_curr_code;
2966     p1_a125 := rosetta_g_miss_num_map(ddx_header_rec.version_number);
2967     p1_a126 := ddx_header_rec.return_status;
2968     p1_a127 := ddx_header_rec.db_flag;
2969     p1_a128 := ddx_header_rec.operation;
2970     p1_a129 := ddx_header_rec.first_ack_code;
2971     p1_a130 := ddx_header_rec.first_ack_date;
2972     p1_a131 := ddx_header_rec.last_ack_code;
2973     p1_a132 := ddx_header_rec.last_ack_date;
2974     p1_a133 := ddx_header_rec.change_reason;
2975     p1_a134 := ddx_header_rec.change_comments;
2976     p1_a135 := ddx_header_rec.change_sequence;
2977     p1_a136 := ddx_header_rec.change_request_code;
2978     p1_a137 := ddx_header_rec.ready_flag;
2979     p1_a138 := ddx_header_rec.status_flag;
2980     p1_a139 := ddx_header_rec.force_apply_flag;
2981     p1_a140 := ddx_header_rec.drop_ship_flag;
2982     p1_a141 := rosetta_g_miss_num_map(ddx_header_rec.customer_payment_term_id);
2983     p1_a142 := ddx_header_rec.payment_type_code;
2984     p1_a143 := rosetta_g_miss_num_map(ddx_header_rec.payment_amount);
2985     p1_a144 := ddx_header_rec.check_number;
2986     p1_a145 := ddx_header_rec.credit_card_code;
2987     p1_a146 := ddx_header_rec.credit_card_holder_name;
2988     p1_a147 := ddx_header_rec.credit_card_number;
2989     p1_a148 := ddx_header_rec.credit_card_expiration_date;
2990     p1_a149 := ddx_header_rec.credit_card_approval_code;
2991     p1_a150 := ddx_header_rec.credit_card_approval_date;
2992     p1_a151 := ddx_header_rec.shipping_instructions;
2993     p1_a152 := ddx_header_rec.packing_instructions;
2994     p1_a153 := ddx_header_rec.flow_status_code;
2995     p1_a154 := ddx_header_rec.booked_date;
2996     p1_a155 := rosetta_g_miss_num_map(ddx_header_rec.marketing_source_code_id);
2997     p1_a156 := ddx_header_rec.upgraded_flag;
2998     p1_a157 := rosetta_g_miss_num_map(ddx_header_rec.lock_control);
2999     p1_a158 := ddx_header_rec.ship_to_edi_location_code;
3000     p1_a159 := ddx_header_rec.sold_to_edi_location_code;
3001     p1_a160 := ddx_header_rec.bill_to_edi_location_code;
3002     p1_a161 := ddx_header_rec.ship_from_edi_location_code;
3003     p1_a162 := rosetta_g_miss_num_map(ddx_header_rec.ship_from_address_id);
3004     p1_a163 := rosetta_g_miss_num_map(ddx_header_rec.sold_to_address_id);
3005     p1_a164 := rosetta_g_miss_num_map(ddx_header_rec.ship_to_address_id);
3006     p1_a165 := rosetta_g_miss_num_map(ddx_header_rec.invoice_address_id);
3007     p1_a166 := ddx_header_rec.ship_to_address_code;
3008     p1_a167 := rosetta_g_miss_num_map(ddx_header_rec.xml_message_id);
3009     p1_a168 := rosetta_g_miss_num_map(ddx_header_rec.ship_to_customer_id);
3010     p1_a169 := rosetta_g_miss_num_map(ddx_header_rec.invoice_to_customer_id);
3011     p1_a170 := rosetta_g_miss_num_map(ddx_header_rec.deliver_to_customer_id);
3012     p1_a171 := rosetta_g_miss_num_map(ddx_header_rec.accounting_rule_duration);
3013     p1_a172 := ddx_header_rec.xml_transaction_type_code;
3014     p1_a173 := rosetta_g_miss_num_map(ddx_header_rec.blanket_number);
3015     p1_a174 := ddx_header_rec.line_set_name;
3016     p1_a175 := ddx_header_rec.fulfillment_set_name;
3017     p1_a176 := ddx_header_rec.default_fulfillment_set;
3018     p1_a177 := ddx_header_rec.quote_date;
3019     p1_a178 := rosetta_g_miss_num_map(ddx_header_rec.quote_number);
3020     p1_a179 := ddx_header_rec.sales_document_name;
3021     p1_a180 := ddx_header_rec.transaction_phase_code;
3022     p1_a181 := ddx_header_rec.user_status_code;
3023     p1_a182 := ddx_header_rec.draft_submitted_flag;
3024     p1_a183 := rosetta_g_miss_num_map(ddx_header_rec.source_document_version_number);
3025     p1_a184 := rosetta_g_miss_num_map(ddx_header_rec.sold_to_site_use_id);
3026     p1_a185 := rosetta_g_miss_num_map(ddx_header_rec.minisite_id);
3027     p1_a186 := ddx_header_rec.ib_owner;
3028     p1_a187 := ddx_header_rec.ib_installed_at_location;
3029     p1_a188 := ddx_header_rec.ib_current_location;
3030     p1_a189 := rosetta_g_miss_num_map(ddx_header_rec.end_customer_id);
3031     p1_a190 := rosetta_g_miss_num_map(ddx_header_rec.end_customer_contact_id);
3032     p1_a191 := rosetta_g_miss_num_map(ddx_header_rec.end_customer_site_use_id);
3033     p1_a192 := ddx_header_rec.supplier_signature;
3034     p1_a193 := ddx_header_rec.supplier_signature_date;
3035     p1_a194 := ddx_header_rec.customer_signature;
3036     p1_a195 := ddx_header_rec.customer_signature_date;
3037     p1_a196 := rosetta_g_miss_num_map(ddx_header_rec.sold_to_party_id);
3038     p1_a197 := rosetta_g_miss_num_map(ddx_header_rec.sold_to_org_contact_id);
3039     p1_a198 := rosetta_g_miss_num_map(ddx_header_rec.ship_to_party_id);
3040     p1_a199 := rosetta_g_miss_num_map(ddx_header_rec.ship_to_party_site_id);
3041     p1_a200 := rosetta_g_miss_num_map(ddx_header_rec.ship_to_party_site_use_id);
3042     p1_a201 := rosetta_g_miss_num_map(ddx_header_rec.deliver_to_party_id);
3043     p1_a202 := rosetta_g_miss_num_map(ddx_header_rec.deliver_to_party_site_id);
3044     p1_a203 := rosetta_g_miss_num_map(ddx_header_rec.deliver_to_party_site_use_id);
3045     p1_a204 := rosetta_g_miss_num_map(ddx_header_rec.invoice_to_party_id);
3046     p1_a205 := rosetta_g_miss_num_map(ddx_header_rec.invoice_to_party_site_id);
3047     p1_a206 := rosetta_g_miss_num_map(ddx_header_rec.invoice_to_party_site_use_id);
3048     p1_a207 := rosetta_g_miss_num_map(ddx_header_rec.ship_to_customer_party_id);
3049     p1_a208 := rosetta_g_miss_num_map(ddx_header_rec.deliver_to_customer_party_id);
3050     p1_a209 := rosetta_g_miss_num_map(ddx_header_rec.invoice_to_customer_party_id);
3051     p1_a210 := rosetta_g_miss_num_map(ddx_header_rec.ship_to_org_contact_id);
3052     p1_a211 := rosetta_g_miss_num_map(ddx_header_rec.deliver_to_org_contact_id);
3053     p1_a212 := rosetta_g_miss_num_map(ddx_header_rec.invoice_to_org_contact_id);
3054     p1_a213 := rosetta_g_miss_num_map(ddx_header_rec.contract_template_id);
3055     p1_a214 := ddx_header_rec.contract_source_doc_type_code;
3056     p1_a215 := rosetta_g_miss_num_map(ddx_header_rec.contract_source_document_id);
3057   end;
3058 
3059   procedure get_line(p_line_id  NUMBER
3060     , p1_a0 out NOCOPY /* file.sql.39 change */  NUMBER
3061     , p1_a1 out NOCOPY /* file.sql.39 change */  DATE
3062     , p1_a2 out NOCOPY /* file.sql.39 change */  DATE
3063     , p1_a3 out NOCOPY /* file.sql.39 change */  NUMBER
3064     , p1_a4 out NOCOPY /* file.sql.39 change */  NUMBER
3065     , p1_a5 out NOCOPY /* file.sql.39 change */  NUMBER
3066     , p1_a6 out NOCOPY /* file.sql.39 change */  VARCHAR2
3067     , p1_a7 out NOCOPY /* file.sql.39 change */  NUMBER
3068     , p1_a8 out NOCOPY /* file.sql.39 change */  VARCHAR2
3069     , p1_a9 out NOCOPY /* file.sql.39 change */  VARCHAR2
3070     , p1_a10 out NOCOPY /* file.sql.39 change */  NUMBER
3071     , p1_a11 out NOCOPY /* file.sql.39 change */  NUMBER
3072     , p1_a12 out NOCOPY /* file.sql.39 change */  NUMBER
3073     , p1_a13 out NOCOPY /* file.sql.39 change */  VARCHAR2
3074     , p1_a14 out NOCOPY /* file.sql.39 change */  NUMBER
3075     , p1_a15 out NOCOPY /* file.sql.39 change */  NUMBER
3076     , p1_a16 out NOCOPY /* file.sql.39 change */  NUMBER
3077     , p1_a17 out NOCOPY /* file.sql.39 change */  NUMBER
3078     , p1_a18 out NOCOPY /* file.sql.39 change */  NUMBER
3079     , p1_a19 out NOCOPY /* file.sql.39 change */  NUMBER
3080     , p1_a20 out NOCOPY /* file.sql.39 change */  VARCHAR2
3081     , p1_a21 out NOCOPY /* file.sql.39 change */  NUMBER
3082     , p1_a22 out NOCOPY /* file.sql.39 change */  DATE
3083     , p1_a23 out NOCOPY /* file.sql.39 change */  NUMBER
3084     , p1_a24 out NOCOPY /* file.sql.39 change */  VARCHAR2
3085     , p1_a25 out NOCOPY /* file.sql.39 change */  VARCHAR2
3086     , p1_a26 out NOCOPY /* file.sql.39 change */  VARCHAR2
3087     , p1_a27 out NOCOPY /* file.sql.39 change */  NUMBER
3088     , p1_a28 out NOCOPY /* file.sql.39 change */  VARCHAR2
3089     , p1_a29 out NOCOPY /* file.sql.39 change */  VARCHAR2
3090     , p1_a30 out NOCOPY /* file.sql.39 change */  VARCHAR2
3091     , p1_a31 out NOCOPY /* file.sql.39 change */  NUMBER
3092     , p1_a32 out NOCOPY /* file.sql.39 change */  NUMBER
3093     , p1_a33 out NOCOPY /* file.sql.39 change */  NUMBER
3094     , p1_a34 out NOCOPY /* file.sql.39 change */  VARCHAR2
3095     , p1_a35 out NOCOPY /* file.sql.39 change */  VARCHAR2
3096     , p1_a36 out NOCOPY /* file.sql.39 change */  VARCHAR2
3097     , p1_a37 out NOCOPY /* file.sql.39 change */  DATE
3098     , p1_a38 out NOCOPY /* file.sql.39 change */  VARCHAR2
3099     , p1_a39 out NOCOPY /* file.sql.39 change */  DATE
3100     , p1_a40 out NOCOPY /* file.sql.39 change */  VARCHAR2
3101     , p1_a41 out NOCOPY /* file.sql.39 change */  VARCHAR2
3102     , p1_a42 out NOCOPY /* file.sql.39 change */  VARCHAR2
3103     , p1_a43 out NOCOPY /* file.sql.39 change */  NUMBER
3104     , p1_a44 out NOCOPY /* file.sql.39 change */  NUMBER
3105     , p1_a45 out NOCOPY /* file.sql.39 change */  NUMBER
3106     , p1_a46 out NOCOPY /* file.sql.39 change */  NUMBER
3107     , p1_a47 out NOCOPY /* file.sql.39 change */  NUMBER
3108     , p1_a48 out NOCOPY /* file.sql.39 change */  NUMBER
3109     , p1_a49 out NOCOPY /* file.sql.39 change */  VARCHAR2
3110     , p1_a50 out NOCOPY /* file.sql.39 change */  NUMBER
3111     , p1_a51 out NOCOPY /* file.sql.39 change */  NUMBER
3112     , p1_a52 out NOCOPY /* file.sql.39 change */  NUMBER
3113     , p1_a53 out NOCOPY /* file.sql.39 change */  VARCHAR2
3114     , p1_a54 out NOCOPY /* file.sql.39 change */  VARCHAR2
3115     , p1_a55 out NOCOPY /* file.sql.39 change */  VARCHAR2
3116     , p1_a56 out NOCOPY /* file.sql.39 change */  NUMBER
3117     , p1_a57 out NOCOPY /* file.sql.39 change */  DATE
3118     , p1_a58 out NOCOPY /* file.sql.39 change */  NUMBER
3119     , p1_a59 out NOCOPY /* file.sql.39 change */  DATE
3120     , p1_a60 out NOCOPY /* file.sql.39 change */  VARCHAR2
3121     , p1_a61 out NOCOPY /* file.sql.39 change */  NUMBER
3122     , p1_a62 out NOCOPY /* file.sql.39 change */  NUMBER
3123     , p1_a63 out NOCOPY /* file.sql.39 change */  NUMBER
3124     , p1_a64 out NOCOPY /* file.sql.39 change */  VARCHAR2
3125     , p1_a65 out NOCOPY /* file.sql.39 change */  NUMBER
3126     , p1_a66 out NOCOPY /* file.sql.39 change */  NUMBER
3127     , p1_a67 out NOCOPY /* file.sql.39 change */  NUMBER
3128     , p1_a68 out NOCOPY /* file.sql.39 change */  NUMBER
3129     , p1_a69 out NOCOPY /* file.sql.39 change */  NUMBER
3130     , p1_a70 out NOCOPY /* file.sql.39 change */  VARCHAR2
3131     , p1_a71 out NOCOPY /* file.sql.39 change */  VARCHAR2
3132     , p1_a72 out NOCOPY /* file.sql.39 change */  NUMBER
3133     , p1_a73 out NOCOPY /* file.sql.39 change */  NUMBER
3134     , p1_a74 out NOCOPY /* file.sql.39 change */  NUMBER
3135     , p1_a75 out NOCOPY /* file.sql.39 change */  VARCHAR2
3136     , p1_a76 out NOCOPY /* file.sql.39 change */  VARCHAR2
3137     , p1_a77 out NOCOPY /* file.sql.39 change */  NUMBER
3138     , p1_a78 out NOCOPY /* file.sql.39 change */  VARCHAR2
3139     , p1_a79 out NOCOPY /* file.sql.39 change */  VARCHAR2
3140     , p1_a80 out NOCOPY /* file.sql.39 change */  VARCHAR2
3141     , p1_a81 out NOCOPY /* file.sql.39 change */  VARCHAR2
3142     , p1_a82 out NOCOPY /* file.sql.39 change */  NUMBER
3143     , p1_a83 out NOCOPY /* file.sql.39 change */  NUMBER
3144     , p1_a84 out NOCOPY /* file.sql.39 change */  VARCHAR2
3145     , p1_a85 out NOCOPY /* file.sql.39 change */  NUMBER
3146     , p1_a86 out NOCOPY /* file.sql.39 change */  VARCHAR2
3147     , p1_a87 out NOCOPY /* file.sql.39 change */  DATE
3148     , p1_a88 out NOCOPY /* file.sql.39 change */  NUMBER
3149     , p1_a89 out NOCOPY /* file.sql.39 change */  VARCHAR2
3150     , p1_a90 out NOCOPY /* file.sql.39 change */  NUMBER
3151     , p1_a91 out NOCOPY /* file.sql.39 change */  NUMBER
3152     , p1_a92 out NOCOPY /* file.sql.39 change */  DATE
3153     , p1_a93 out NOCOPY /* file.sql.39 change */  NUMBER
3154     , p1_a94 out NOCOPY /* file.sql.39 change */  DATE
3155     , p1_a95 out NOCOPY /* file.sql.39 change */  VARCHAR2
3156     , p1_a96 out NOCOPY /* file.sql.39 change */  NUMBER
3157     , p1_a97 out NOCOPY /* file.sql.39 change */  NUMBER
3158     , p1_a98 out NOCOPY /* file.sql.39 change */  NUMBER
3159     , p1_a99 out NOCOPY /* file.sql.39 change */  VARCHAR2
3160     , p1_a100 out NOCOPY /* file.sql.39 change */  DATE
3161     , p1_a101 out NOCOPY /* file.sql.39 change */  NUMBER
3162     , p1_a102 out NOCOPY /* file.sql.39 change */  NUMBER
3163     , p1_a103 out NOCOPY /* file.sql.39 change */  VARCHAR2
3164     , p1_a104 out NOCOPY /* file.sql.39 change */  VARCHAR2
3165     , p1_a105 out NOCOPY /* file.sql.39 change */  NUMBER
3166     , p1_a106 out NOCOPY /* file.sql.39 change */  DATE
3167     , p1_a107 out NOCOPY /* file.sql.39 change */  DATE
3168     , p1_a108 out NOCOPY /* file.sql.39 change */  VARCHAR2
3169     , p1_a109 out NOCOPY /* file.sql.39 change */  VARCHAR2
3170     , p1_a110 out NOCOPY /* file.sql.39 change */  NUMBER
3171     , p1_a111 out NOCOPY /* file.sql.39 change */  VARCHAR2
3172     , p1_a112 out NOCOPY /* file.sql.39 change */  NUMBER
3173     , p1_a113 out NOCOPY /* file.sql.39 change */  NUMBER
3174     , p1_a114 out NOCOPY /* file.sql.39 change */  VARCHAR2
3175     , p1_a115 out NOCOPY /* file.sql.39 change */  VARCHAR2
3176     , p1_a116 out NOCOPY /* file.sql.39 change */  NUMBER
3177     , p1_a117 out NOCOPY /* file.sql.39 change */  NUMBER
3178     , p1_a118 out NOCOPY /* file.sql.39 change */  VARCHAR2
3179     , p1_a119 out NOCOPY /* file.sql.39 change */  VARCHAR2
3180     , p1_a120 out NOCOPY /* file.sql.39 change */  NUMBER
3181     , p1_a121 out NOCOPY /* file.sql.39 change */  VARCHAR2
3182     , p1_a122 out NOCOPY /* file.sql.39 change */  NUMBER
3183     , p1_a123 out NOCOPY /* file.sql.39 change */  NUMBER
3184     , p1_a124 out NOCOPY /* file.sql.39 change */  NUMBER
3185     , p1_a125 out NOCOPY /* file.sql.39 change */  NUMBER
3186     , p1_a126 out NOCOPY /* file.sql.39 change */  NUMBER
3187     , p1_a127 out NOCOPY /* file.sql.39 change */  NUMBER
3188     , p1_a128 out NOCOPY /* file.sql.39 change */  NUMBER
3189     , p1_a129 out NOCOPY /* file.sql.39 change */  NUMBER
3190     , p1_a130 out NOCOPY /* file.sql.39 change */  VARCHAR2
3191     , p1_a131 out NOCOPY /* file.sql.39 change */  NUMBER
3192     , p1_a132 out NOCOPY /* file.sql.39 change */  NUMBER
3193     , p1_a133 out NOCOPY /* file.sql.39 change */  NUMBER
3194     , p1_a134 out NOCOPY /* file.sql.39 change */  VARCHAR2
3195     , p1_a135 out NOCOPY /* file.sql.39 change */  NUMBER
3196     , p1_a136 out NOCOPY /* file.sql.39 change */  NUMBER
3197     , p1_a137 out NOCOPY /* file.sql.39 change */  VARCHAR2
3198     , p1_a138 out NOCOPY /* file.sql.39 change */  DATE
3199     , p1_a139 out NOCOPY /* file.sql.39 change */  VARCHAR2
3200     , p1_a140 out NOCOPY /* file.sql.39 change */  VARCHAR2
3201     , p1_a141 out NOCOPY /* file.sql.39 change */  VARCHAR2
3202     , p1_a142 out NOCOPY /* file.sql.39 change */  VARCHAR2
3203     , p1_a143 out NOCOPY /* file.sql.39 change */  NUMBER
3204     , p1_a144 out NOCOPY /* file.sql.39 change */  NUMBER
3205     , p1_a145 out NOCOPY /* file.sql.39 change */  VARCHAR2
3206     , p1_a146 out NOCOPY /* file.sql.39 change */  NUMBER
3207     , p1_a147 out NOCOPY /* file.sql.39 change */  NUMBER
3208     , p1_a148 out NOCOPY /* file.sql.39 change */  NUMBER
3209     , p1_a149 out NOCOPY /* file.sql.39 change */  NUMBER
3210     , p1_a150 out NOCOPY /* file.sql.39 change */  NUMBER
3211     , p1_a151 out NOCOPY /* file.sql.39 change */  NUMBER
3212     , p1_a152 out NOCOPY /* file.sql.39 change */  NUMBER
3213     , p1_a153 out NOCOPY /* file.sql.39 change */  VARCHAR2
3214     , p1_a154 out NOCOPY /* file.sql.39 change */  VARCHAR2
3215     , p1_a155 out NOCOPY /* file.sql.39 change */  VARCHAR2
3216     , p1_a156 out NOCOPY /* file.sql.39 change */  VARCHAR2
3217     , p1_a157 out NOCOPY /* file.sql.39 change */  VARCHAR2
3218     , p1_a158 out NOCOPY /* file.sql.39 change */  DATE
3219     , p1_a159 out NOCOPY /* file.sql.39 change */  VARCHAR2
3220     , p1_a160 out NOCOPY /* file.sql.39 change */  DATE
3221     , p1_a161 out NOCOPY /* file.sql.39 change */  VARCHAR2
3222     , p1_a162 out NOCOPY /* file.sql.39 change */  VARCHAR2
3223     , p1_a163 out NOCOPY /* file.sql.39 change */  VARCHAR2
3224     , p1_a164 out NOCOPY /* file.sql.39 change */  VARCHAR2
3225     , p1_a165 out NOCOPY /* file.sql.39 change */  VARCHAR2
3226     , p1_a166 out NOCOPY /* file.sql.39 change */  NUMBER
3227     , p1_a167 out NOCOPY /* file.sql.39 change */  VARCHAR2
3228     , p1_a168 out NOCOPY /* file.sql.39 change */  VARCHAR2
3229     , p1_a169 out NOCOPY /* file.sql.39 change */  VARCHAR2
3230     , p1_a170 out NOCOPY /* file.sql.39 change */  VARCHAR2
3231     , p1_a171 out NOCOPY /* file.sql.39 change */  VARCHAR2
3232     , p1_a172 out NOCOPY /* file.sql.39 change */  VARCHAR2
3233     , p1_a173 out NOCOPY /* file.sql.39 change */  VARCHAR2
3234     , p1_a174 out NOCOPY /* file.sql.39 change */  NUMBER
3235     , p1_a175 out NOCOPY /* file.sql.39 change */  NUMBER
3236     , p1_a176 out NOCOPY /* file.sql.39 change */  NUMBER
3237     , p1_a177 out NOCOPY /* file.sql.39 change */  VARCHAR2
3238     , p1_a178 out NOCOPY /* file.sql.39 change */  VARCHAR2
3239     , p1_a179 out NOCOPY /* file.sql.39 change */  VARCHAR2
3240     , p1_a180 out NOCOPY /* file.sql.39 change */  VARCHAR2
3241     , p1_a181 out NOCOPY /* file.sql.39 change */  NUMBER
3242     , p1_a182 out NOCOPY /* file.sql.39 change */  VARCHAR2
3243     , p1_a183 out NOCOPY /* file.sql.39 change */  VARCHAR2
3244     , p1_a184 out NOCOPY /* file.sql.39 change */  NUMBER
3245     , p1_a185 out NOCOPY /* file.sql.39 change */  VARCHAR2
3246     , p1_a186 out NOCOPY /* file.sql.39 change */  DATE
3247     , p1_a187 out NOCOPY /* file.sql.39 change */  DATE
3248     , p1_a188 out NOCOPY /* file.sql.39 change */  VARCHAR2
3249     , p1_a189 out NOCOPY /* file.sql.39 change */  NUMBER
3250     , p1_a190 out NOCOPY /* file.sql.39 change */  NUMBER
3251     , p1_a191 out NOCOPY /* file.sql.39 change */  NUMBER
3252     , p1_a192 out NOCOPY /* file.sql.39 change */  NUMBER
3253     , p1_a193 out NOCOPY /* file.sql.39 change */  VARCHAR2
3254     , p1_a194 out NOCOPY /* file.sql.39 change */  NUMBER
3255     , p1_a195 out NOCOPY /* file.sql.39 change */  NUMBER
3256     , p1_a196 out NOCOPY /* file.sql.39 change */  NUMBER
3257     , p1_a197 out NOCOPY /* file.sql.39 change */  NUMBER
3258     , p1_a198 out NOCOPY /* file.sql.39 change */  VARCHAR2
3259     , p1_a199 out NOCOPY /* file.sql.39 change */  VARCHAR2
3260     , p1_a200 out NOCOPY /* file.sql.39 change */  VARCHAR2
3261     , p1_a201 out NOCOPY /* file.sql.39 change */  NUMBER
3262     , p1_a202 out NOCOPY /* file.sql.39 change */  NUMBER
3263     , p1_a203 out NOCOPY /* file.sql.39 change */  NUMBER
3264     , p1_a204 out NOCOPY /* file.sql.39 change */  NUMBER
3265     , p1_a205 out NOCOPY /* file.sql.39 change */  VARCHAR2
3266     , p1_a206 out NOCOPY /* file.sql.39 change */  VARCHAR2
3267     , p1_a207 out NOCOPY /* file.sql.39 change */  VARCHAR2
3268     , p1_a208 out NOCOPY /* file.sql.39 change */  VARCHAR2
3269     , p1_a209 out NOCOPY /* file.sql.39 change */  VARCHAR2
3270     , p1_a210 out NOCOPY /* file.sql.39 change */  VARCHAR2
3271     , p1_a211 out NOCOPY /* file.sql.39 change */  VARCHAR2
3272     , p1_a212 out NOCOPY /* file.sql.39 change */  NUMBER
3273     , p1_a213 out NOCOPY /* file.sql.39 change */  NUMBER
3274     , p1_a214 out NOCOPY /* file.sql.39 change */  DATE
3275     , p1_a215 out NOCOPY /* file.sql.39 change */  NUMBER
3276     , p1_a216 out NOCOPY /* file.sql.39 change */  VARCHAR2
3277     , p1_a217 out NOCOPY /* file.sql.39 change */  NUMBER
3278     , p1_a218 out NOCOPY /* file.sql.39 change */  VARCHAR2
3279     , p1_a219 out NOCOPY /* file.sql.39 change */  VARCHAR2
3280     , p1_a220 out NOCOPY /* file.sql.39 change */  VARCHAR2
3281     , p1_a221 out NOCOPY /* file.sql.39 change */  VARCHAR2
3282     , p1_a222 out NOCOPY /* file.sql.39 change */  VARCHAR2
3283     , p1_a223 out NOCOPY /* file.sql.39 change */  VARCHAR2
3284     , p1_a224 out NOCOPY /* file.sql.39 change */  NUMBER
3285     , p1_a225 out NOCOPY /* file.sql.39 change */  NUMBER
3286     , p1_a226 out NOCOPY /* file.sql.39 change */  NUMBER
3287     , p1_a227 out NOCOPY /* file.sql.39 change */  NUMBER
3288     , p1_a228 out NOCOPY /* file.sql.39 change */  VARCHAR2
3289     , p1_a229 out NOCOPY /* file.sql.39 change */  NUMBER
3290     , p1_a230 out NOCOPY /* file.sql.39 change */  VARCHAR2
3291     , p1_a231 out NOCOPY /* file.sql.39 change */  NUMBER
3292     , p1_a232 out NOCOPY /* file.sql.39 change */  VARCHAR2
3293     , p1_a233 out NOCOPY /* file.sql.39 change */  VARCHAR2
3294     , p1_a234 out NOCOPY /* file.sql.39 change */  NUMBER
3295     , p1_a235 out NOCOPY /* file.sql.39 change */  VARCHAR2
3296     , p1_a236 out NOCOPY /* file.sql.39 change */  NUMBER
3297     , p1_a237 out NOCOPY /* file.sql.39 change */  NUMBER
3298     , p1_a238 out NOCOPY /* file.sql.39 change */  NUMBER
3299     , p1_a239 out NOCOPY /* file.sql.39 change */  NUMBER
3300     , p1_a240 out NOCOPY /* file.sql.39 change */  NUMBER
3301     , p1_a241 out NOCOPY /* file.sql.39 change */  VARCHAR2
3302     , p1_a242 out NOCOPY /* file.sql.39 change */  VARCHAR2
3303     , p1_a243 out NOCOPY /* file.sql.39 change */  NUMBER
3304     , p1_a244 out NOCOPY /* file.sql.39 change */  NUMBER
3305     , p1_a245 out NOCOPY /* file.sql.39 change */  NUMBER
3306     , p1_a246 out NOCOPY /* file.sql.39 change */  NUMBER
3307     , p1_a247 out NOCOPY /* file.sql.39 change */  VARCHAR2
3308     , p1_a248 out NOCOPY /* file.sql.39 change */  VARCHAR2
3309     , p1_a249 out NOCOPY /* file.sql.39 change */  DATE
3310     , p1_a250 out NOCOPY /* file.sql.39 change */  VARCHAR2
3311     , p1_a251 out NOCOPY /* file.sql.39 change */  NUMBER
3312     , p1_a252 out NOCOPY /* file.sql.39 change */  NUMBER
3313     , p1_a253 out NOCOPY /* file.sql.39 change */  VARCHAR2
3314     , p1_a254 out NOCOPY /* file.sql.39 change */  VARCHAR2
3315     , p1_a255 out NOCOPY /* file.sql.39 change */  VARCHAR2
3316     , p1_a256 out NOCOPY /* file.sql.39 change */  NUMBER
3317     , p1_a257 out NOCOPY /* file.sql.39 change */  NUMBER
3318     , p1_a258 out NOCOPY /* file.sql.39 change */  NUMBER
3319     , p1_a259 out NOCOPY /* file.sql.39 change */  VARCHAR2
3320     , p1_a260 out NOCOPY /* file.sql.39 change */  DATE
3321     , p1_a261 out NOCOPY /* file.sql.39 change */  VARCHAR2
3322     , p1_a262 out NOCOPY /* file.sql.39 change */  DATE
3323     , p1_a263 out NOCOPY /* file.sql.39 change */  NUMBER
3324     , p1_a264 out NOCOPY /* file.sql.39 change */  NUMBER
3325     , p1_a265 out NOCOPY /* file.sql.39 change */  NUMBER
3326     , p1_a266 out NOCOPY /* file.sql.39 change */  NUMBER
3327     , p1_a267 out NOCOPY /* file.sql.39 change */  NUMBER
3328     , p1_a268 out NOCOPY /* file.sql.39 change */  NUMBER
3329     , p1_a269 out NOCOPY /* file.sql.39 change */  NUMBER
3330     , p1_a270 out NOCOPY /* file.sql.39 change */  NUMBER
3331     , p1_a271 out NOCOPY /* file.sql.39 change */  NUMBER
3332     , p1_a272 out NOCOPY /* file.sql.39 change */  NUMBER
3333     , p1_a273 out NOCOPY /* file.sql.39 change */  NUMBER
3334     , p1_a274 out NOCOPY /* file.sql.39 change */  NUMBER
3335     , p1_a275 out NOCOPY /* file.sql.39 change */  NUMBER
3336     , p1_a276 out NOCOPY /* file.sql.39 change */  NUMBER
3337     , p1_a277 out NOCOPY /* file.sql.39 change */  NUMBER
3338     , p1_a278 out NOCOPY /* file.sql.39 change */  NUMBER
3339     , p1_a279 out NOCOPY /* file.sql.39 change */  NUMBER
3340     , p1_a280 out NOCOPY /* file.sql.39 change */  NUMBER
3341   )
3342 
3343   as
3344     ddx_line_rec oe_order_pub.line_rec_type;
3345     ddindx binary_integer; indx binary_integer;
3346   begin
3347 
3348     -- copy data to the local IN or IN-OUT args, if any
3349 
3350 
3351     -- here's the delegated call to the old PL/SQL routine
3352     oe_portal_util.get_line(p_line_id,
3353       ddx_line_rec);
3354 
3355     -- copy data back from the local variables to OUT NOCOPY /* file.sql.39 change */ or IN-OUT args, if any
3356 
3357     p1_a0 := rosetta_g_miss_num_map(ddx_line_rec.accounting_rule_id);
3358     p1_a1 := ddx_line_rec.actual_arrival_date;
3359     p1_a2 := ddx_line_rec.actual_shipment_date;
3360     p1_a3 := rosetta_g_miss_num_map(ddx_line_rec.agreement_id);
3361     p1_a4 := rosetta_g_miss_num_map(ddx_line_rec.arrival_set_id);
3362     p1_a5 := rosetta_g_miss_num_map(ddx_line_rec.ato_line_id);
3363     p1_a6 := ddx_line_rec.authorized_to_ship_flag;
3364     p1_a7 := rosetta_g_miss_num_map(ddx_line_rec.auto_selected_quantity);
3365     p1_a8 := ddx_line_rec.booked_flag;
3366     p1_a9 := ddx_line_rec.cancelled_flag;
3367     p1_a10 := rosetta_g_miss_num_map(ddx_line_rec.cancelled_quantity);
3368     p1_a11 := rosetta_g_miss_num_map(ddx_line_rec.cancelled_quantity2);
3369     p1_a12 := rosetta_g_miss_num_map(ddx_line_rec.commitment_id);
3370     p1_a13 := ddx_line_rec.component_code;
3371     p1_a14 := rosetta_g_miss_num_map(ddx_line_rec.component_number);
3372     p1_a15 := rosetta_g_miss_num_map(ddx_line_rec.component_sequence_id);
3373     p1_a16 := rosetta_g_miss_num_map(ddx_line_rec.config_header_id);
3374     p1_a17 := rosetta_g_miss_num_map(ddx_line_rec.config_rev_nbr);
3375     p1_a18 := rosetta_g_miss_num_map(ddx_line_rec.config_display_sequence);
3376     p1_a19 := rosetta_g_miss_num_map(ddx_line_rec.configuration_id);
3377     p1_a20 := ddx_line_rec.context;
3378     p1_a21 := rosetta_g_miss_num_map(ddx_line_rec.created_by);
3379     p1_a22 := ddx_line_rec.creation_date;
3380     p1_a23 := rosetta_g_miss_num_map(ddx_line_rec.credit_invoice_line_id);
3381     p1_a24 := ddx_line_rec.customer_dock_code;
3382     p1_a25 := ddx_line_rec.customer_job;
3383     p1_a26 := ddx_line_rec.customer_production_line;
3384     p1_a27 := rosetta_g_miss_num_map(ddx_line_rec.customer_trx_line_id);
3385     p1_a28 := ddx_line_rec.cust_model_serial_number;
3386     p1_a29 := ddx_line_rec.cust_po_number;
3387     p1_a30 := ddx_line_rec.cust_production_seq_num;
3388     p1_a31 := rosetta_g_miss_num_map(ddx_line_rec.delivery_lead_time);
3389     p1_a32 := rosetta_g_miss_num_map(ddx_line_rec.deliver_to_contact_id);
3390     p1_a33 := rosetta_g_miss_num_map(ddx_line_rec.deliver_to_org_id);
3391     p1_a34 := ddx_line_rec.demand_bucket_type_code;
3392     p1_a35 := ddx_line_rec.demand_class_code;
3393     p1_a36 := ddx_line_rec.dep_plan_required_flag;
3394     p1_a37 := ddx_line_rec.earliest_acceptable_date;
3395     p1_a38 := ddx_line_rec.end_item_unit_number;
3396     p1_a39 := ddx_line_rec.explosion_date;
3397     p1_a40 := ddx_line_rec.fob_point_code;
3398     p1_a41 := ddx_line_rec.freight_carrier_code;
3399     p1_a42 := ddx_line_rec.freight_terms_code;
3400     p1_a43 := rosetta_g_miss_num_map(ddx_line_rec.fulfilled_quantity);
3401     p1_a44 := rosetta_g_miss_num_map(ddx_line_rec.fulfilled_quantity2);
3402     p1_a45 := rosetta_g_miss_num_map(ddx_line_rec.header_id);
3403     p1_a46 := rosetta_g_miss_num_map(ddx_line_rec.intermed_ship_to_org_id);
3404     p1_a47 := rosetta_g_miss_num_map(ddx_line_rec.intermed_ship_to_contact_id);
3405     p1_a48 := rosetta_g_miss_num_map(ddx_line_rec.inventory_item_id);
3406     p1_a49 := ddx_line_rec.invoice_interface_status_code;
3407     p1_a50 := rosetta_g_miss_num_map(ddx_line_rec.invoice_to_contact_id);
3408     p1_a51 := rosetta_g_miss_num_map(ddx_line_rec.invoice_to_org_id);
3409     p1_a52 := rosetta_g_miss_num_map(ddx_line_rec.invoicing_rule_id);
3410     p1_a53 := ddx_line_rec.ordered_item;
3411     p1_a54 := ddx_line_rec.item_revision;
3412     p1_a55 := ddx_line_rec.item_type_code;
3413     p1_a56 := rosetta_g_miss_num_map(ddx_line_rec.last_updated_by);
3414     p1_a57 := ddx_line_rec.last_update_date;
3415     p1_a58 := rosetta_g_miss_num_map(ddx_line_rec.last_update_login);
3416     p1_a59 := ddx_line_rec.latest_acceptable_date;
3417     p1_a60 := ddx_line_rec.line_category_code;
3418     p1_a61 := rosetta_g_miss_num_map(ddx_line_rec.line_id);
3419     p1_a62 := rosetta_g_miss_num_map(ddx_line_rec.line_number);
3420     p1_a63 := rosetta_g_miss_num_map(ddx_line_rec.line_type_id);
3421     p1_a64 := ddx_line_rec.link_to_line_ref;
3422     p1_a65 := rosetta_g_miss_num_map(ddx_line_rec.link_to_line_id);
3423     p1_a66 := rosetta_g_miss_num_map(ddx_line_rec.link_to_line_index);
3424     p1_a67 := rosetta_g_miss_num_map(ddx_line_rec.model_group_number);
3425     p1_a68 := rosetta_g_miss_num_map(ddx_line_rec.mfg_component_sequence_id);
3426     p1_a69 := rosetta_g_miss_num_map(ddx_line_rec.mfg_lead_time);
3427     p1_a70 := ddx_line_rec.open_flag;
3428     p1_a71 := ddx_line_rec.option_flag;
3429     p1_a72 := rosetta_g_miss_num_map(ddx_line_rec.option_number);
3430     p1_a73 := rosetta_g_miss_num_map(ddx_line_rec.ordered_quantity);
3431     p1_a74 := rosetta_g_miss_num_map(ddx_line_rec.ordered_quantity2);
3432     p1_a75 := ddx_line_rec.order_quantity_uom;
3433     p1_a76 := ddx_line_rec.ordered_quantity_uom2;
3434     p1_a77 := rosetta_g_miss_num_map(ddx_line_rec.org_id);
3435     p1_a78 := ddx_line_rec.orig_sys_document_ref;
3436     p1_a79 := ddx_line_rec.orig_sys_line_ref;
3437     p1_a80 := ddx_line_rec.over_ship_reason_code;
3438     p1_a81 := ddx_line_rec.over_ship_resolved_flag;
3439     p1_a82 := rosetta_g_miss_num_map(ddx_line_rec.payment_term_id);
3440     p1_a83 := rosetta_g_miss_num_map(ddx_line_rec.planning_priority);
3441     p1_a84 := ddx_line_rec.preferred_grade;
3442     p1_a85 := rosetta_g_miss_num_map(ddx_line_rec.price_list_id);
3443     p1_a86 := ddx_line_rec.price_request_code;
3444     p1_a87 := ddx_line_rec.pricing_date;
3445     p1_a88 := rosetta_g_miss_num_map(ddx_line_rec.pricing_quantity);
3446     p1_a89 := ddx_line_rec.pricing_quantity_uom;
3447     p1_a90 := rosetta_g_miss_num_map(ddx_line_rec.program_application_id);
3448     p1_a91 := rosetta_g_miss_num_map(ddx_line_rec.program_id);
3449     p1_a92 := ddx_line_rec.program_update_date;
3450     p1_a93 := rosetta_g_miss_num_map(ddx_line_rec.project_id);
3451     p1_a94 := ddx_line_rec.promise_date;
3452     p1_a95 := ddx_line_rec.re_source_flag;
3453     p1_a96 := rosetta_g_miss_num_map(ddx_line_rec.reference_customer_trx_line_id);
3454     p1_a97 := rosetta_g_miss_num_map(ddx_line_rec.reference_header_id);
3455     p1_a98 := rosetta_g_miss_num_map(ddx_line_rec.reference_line_id);
3456     p1_a99 := ddx_line_rec.reference_type;
3457     p1_a100 := ddx_line_rec.request_date;
3458     p1_a101 := rosetta_g_miss_num_map(ddx_line_rec.request_id);
3459     p1_a102 := rosetta_g_miss_num_map(ddx_line_rec.reserved_quantity);
3460     p1_a103 := ddx_line_rec.return_reason_code;
3461     p1_a104 := ddx_line_rec.rla_schedule_type_code;
3462     p1_a105 := rosetta_g_miss_num_map(ddx_line_rec.salesrep_id);
3463     p1_a106 := ddx_line_rec.schedule_arrival_date;
3464     p1_a107 := ddx_line_rec.schedule_ship_date;
3465     p1_a108 := ddx_line_rec.schedule_action_code;
3466     p1_a109 := ddx_line_rec.schedule_status_code;
3467     p1_a110 := rosetta_g_miss_num_map(ddx_line_rec.shipment_number);
3468     p1_a111 := ddx_line_rec.shipment_priority_code;
3469     p1_a112 := rosetta_g_miss_num_map(ddx_line_rec.shipped_quantity);
3470     p1_a113 := rosetta_g_miss_num_map(ddx_line_rec.shipped_quantity2);
3471     p1_a114 := ddx_line_rec.shipping_interfaced_flag;
3472     p1_a115 := ddx_line_rec.shipping_method_code;
3473     p1_a116 := rosetta_g_miss_num_map(ddx_line_rec.shipping_quantity);
3474     p1_a117 := rosetta_g_miss_num_map(ddx_line_rec.shipping_quantity2);
3475     p1_a118 := ddx_line_rec.shipping_quantity_uom;
3476     p1_a119 := ddx_line_rec.shipping_quantity_uom2;
3477     p1_a120 := rosetta_g_miss_num_map(ddx_line_rec.ship_from_org_id);
3478     p1_a121 := ddx_line_rec.ship_model_complete_flag;
3479     p1_a122 := rosetta_g_miss_num_map(ddx_line_rec.ship_set_id);
3480     p1_a123 := rosetta_g_miss_num_map(ddx_line_rec.fulfillment_set_id);
3481     p1_a124 := rosetta_g_miss_num_map(ddx_line_rec.ship_tolerance_above);
3482     p1_a125 := rosetta_g_miss_num_map(ddx_line_rec.ship_tolerance_below);
3483     p1_a126 := rosetta_g_miss_num_map(ddx_line_rec.ship_to_contact_id);
3484     p1_a127 := rosetta_g_miss_num_map(ddx_line_rec.ship_to_org_id);
3485     p1_a128 := rosetta_g_miss_num_map(ddx_line_rec.sold_to_org_id);
3486     p1_a129 := rosetta_g_miss_num_map(ddx_line_rec.sold_from_org_id);
3487     p1_a130 := ddx_line_rec.sort_order;
3488     p1_a131 := rosetta_g_miss_num_map(ddx_line_rec.source_document_id);
3489     p1_a132 := rosetta_g_miss_num_map(ddx_line_rec.source_document_line_id);
3490     p1_a133 := rosetta_g_miss_num_map(ddx_line_rec.source_document_type_id);
3491     p1_a134 := ddx_line_rec.source_type_code;
3492     p1_a135 := rosetta_g_miss_num_map(ddx_line_rec.split_from_line_id);
3493     p1_a136 := rosetta_g_miss_num_map(ddx_line_rec.task_id);
3494     p1_a137 := ddx_line_rec.tax_code;
3495     p1_a138 := ddx_line_rec.tax_date;
3496     p1_a139 := ddx_line_rec.tax_exempt_flag;
3497     p1_a140 := ddx_line_rec.tax_exempt_number;
3498     p1_a141 := ddx_line_rec.tax_exempt_reason_code;
3499     p1_a142 := ddx_line_rec.tax_point_code;
3500     p1_a143 := rosetta_g_miss_num_map(ddx_line_rec.tax_rate);
3501     p1_a144 := rosetta_g_miss_num_map(ddx_line_rec.tax_value);
3502     p1_a145 := ddx_line_rec.top_model_line_ref;
3503     p1_a146 := rosetta_g_miss_num_map(ddx_line_rec.top_model_line_id);
3504     p1_a147 := rosetta_g_miss_num_map(ddx_line_rec.top_model_line_index);
3505     p1_a148 := rosetta_g_miss_num_map(ddx_line_rec.unit_list_price);
3506     p1_a149 := rosetta_g_miss_num_map(ddx_line_rec.unit_list_price_per_pqty);
3507     p1_a150 := rosetta_g_miss_num_map(ddx_line_rec.unit_selling_price);
3508     p1_a151 := rosetta_g_miss_num_map(ddx_line_rec.unit_selling_price_per_pqty);
3509     p1_a152 := rosetta_g_miss_num_map(ddx_line_rec.veh_cus_item_cum_key_id);
3510     p1_a153 := ddx_line_rec.visible_demand_flag;
3511     p1_a154 := ddx_line_rec.return_status;
3512     p1_a155 := ddx_line_rec.db_flag;
3513     p1_a156 := ddx_line_rec.operation;
3514     p1_a157 := ddx_line_rec.first_ack_code;
3515     p1_a158 := ddx_line_rec.first_ack_date;
3516     p1_a159 := ddx_line_rec.last_ack_code;
3517     p1_a160 := ddx_line_rec.last_ack_date;
3518     p1_a161 := ddx_line_rec.change_reason;
3519     p1_a162 := ddx_line_rec.change_comments;
3520     p1_a163 := ddx_line_rec.arrival_set;
3521     p1_a164 := ddx_line_rec.ship_set;
3522     p1_a165 := ddx_line_rec.fulfillment_set;
3523     p1_a166 := rosetta_g_miss_num_map(ddx_line_rec.order_source_id);
3524     p1_a167 := ddx_line_rec.orig_sys_shipment_ref;
3525     p1_a168 := ddx_line_rec.change_sequence;
3526     p1_a169 := ddx_line_rec.change_request_code;
3527     p1_a170 := ddx_line_rec.status_flag;
3528     p1_a171 := ddx_line_rec.drop_ship_flag;
3529     p1_a172 := ddx_line_rec.customer_line_number;
3530     p1_a173 := ddx_line_rec.customer_shipment_number;
3531     p1_a174 := rosetta_g_miss_num_map(ddx_line_rec.customer_item_net_price);
3532     p1_a175 := rosetta_g_miss_num_map(ddx_line_rec.customer_payment_term_id);
3533     p1_a176 := rosetta_g_miss_num_map(ddx_line_rec.ordered_item_id);
3534     p1_a177 := ddx_line_rec.item_identifier_type;
3535     p1_a178 := ddx_line_rec.shipping_instructions;
3536     p1_a179 := ddx_line_rec.packing_instructions;
3537     p1_a180 := ddx_line_rec.calculate_price_flag;
3538     p1_a181 := rosetta_g_miss_num_map(ddx_line_rec.invoiced_quantity);
3539     p1_a182 := ddx_line_rec.service_txn_reason_code;
3540     p1_a183 := ddx_line_rec.service_txn_comments;
3541     p1_a184 := rosetta_g_miss_num_map(ddx_line_rec.service_duration);
3542     p1_a185 := ddx_line_rec.service_period;
3543     p1_a186 := ddx_line_rec.service_start_date;
3544     p1_a187 := ddx_line_rec.service_end_date;
3545     p1_a188 := ddx_line_rec.service_coterminate_flag;
3546     p1_a189 := rosetta_g_miss_num_map(ddx_line_rec.unit_list_percent);
3547     p1_a190 := rosetta_g_miss_num_map(ddx_line_rec.unit_selling_percent);
3548     p1_a191 := rosetta_g_miss_num_map(ddx_line_rec.unit_percent_base_price);
3549     p1_a192 := rosetta_g_miss_num_map(ddx_line_rec.service_number);
3550     p1_a193 := ddx_line_rec.service_reference_type_code;
3551     p1_a194 := rosetta_g_miss_num_map(ddx_line_rec.service_reference_line_id);
3552     p1_a195 := rosetta_g_miss_num_map(ddx_line_rec.service_reference_system_id);
3553     p1_a196 := rosetta_g_miss_num_map(ddx_line_rec.service_ref_order_number);
3554     p1_a197 := rosetta_g_miss_num_map(ddx_line_rec.service_ref_line_number);
3555     p1_a198 := ddx_line_rec.service_reference_order;
3556     p1_a199 := ddx_line_rec.service_reference_line;
3557     p1_a200 := ddx_line_rec.service_reference_system;
3558     p1_a201 := rosetta_g_miss_num_map(ddx_line_rec.service_ref_shipment_number);
3559     p1_a202 := rosetta_g_miss_num_map(ddx_line_rec.service_ref_option_number);
3560     p1_a203 := rosetta_g_miss_num_map(ddx_line_rec.service_line_index);
3561     p1_a204 := rosetta_g_miss_num_map(ddx_line_rec.line_set_id);
3562     p1_a205 := ddx_line_rec.split_by;
3563     p1_a206 := ddx_line_rec.split_action_code;
3564     p1_a207 := ddx_line_rec.shippable_flag;
3565     p1_a208 := ddx_line_rec.model_remnant_flag;
3566     p1_a209 := ddx_line_rec.flow_status_code;
3567     p1_a210 := ddx_line_rec.fulfilled_flag;
3568     p1_a211 := ddx_line_rec.fulfillment_method_code;
3569     p1_a212 := rosetta_g_miss_num_map(ddx_line_rec.revenue_amount);
3570     p1_a213 := rosetta_g_miss_num_map(ddx_line_rec.marketing_source_code_id);
3571     p1_a214 := ddx_line_rec.fulfillment_date;
3572     if ddx_line_rec.semi_processed_flag is null
3573       then p1_a215 := null;
3574     elsif ddx_line_rec.semi_processed_flag
3575       then p1_a215 := 1;
3576     else p1_a215 := 0;
3577     end if;
3578     p1_a216 := ddx_line_rec.upgraded_flag;
3579     p1_a217 := rosetta_g_miss_num_map(ddx_line_rec.lock_control);
3580     p1_a218 := ddx_line_rec.subinventory;
3581     p1_a219 := ddx_line_rec.split_from_line_ref;
3582     p1_a220 := ddx_line_rec.split_from_shipment_ref;
3583     p1_a221 := ddx_line_rec.ship_to_edi_location_code;
3584     p1_a222 := ddx_line_rec.bill_to_edi_location_code;
3585     p1_a223 := ddx_line_rec.ship_from_edi_location_code;
3586     p1_a224 := rosetta_g_miss_num_map(ddx_line_rec.ship_from_address_id);
3587     p1_a225 := rosetta_g_miss_num_map(ddx_line_rec.sold_to_address_id);
3588     p1_a226 := rosetta_g_miss_num_map(ddx_line_rec.ship_to_address_id);
3589     p1_a227 := rosetta_g_miss_num_map(ddx_line_rec.invoice_address_id);
3590     p1_a228 := ddx_line_rec.ship_to_address_code;
3591     p1_a229 := rosetta_g_miss_num_map(ddx_line_rec.original_inventory_item_id);
3592     p1_a230 := ddx_line_rec.original_item_identifier_type;
3593     p1_a231 := rosetta_g_miss_num_map(ddx_line_rec.original_ordered_item_id);
3594     p1_a232 := ddx_line_rec.original_ordered_item;
3595     p1_a233 := ddx_line_rec.item_substitution_type_code;
3596     p1_a234 := rosetta_g_miss_num_map(ddx_line_rec.late_demand_penalty_factor);
3597     p1_a235 := ddx_line_rec.override_atp_date_code;
3598     p1_a236 := rosetta_g_miss_num_map(ddx_line_rec.ship_to_customer_id);
3599     p1_a237 := rosetta_g_miss_num_map(ddx_line_rec.invoice_to_customer_id);
3600     p1_a238 := rosetta_g_miss_num_map(ddx_line_rec.deliver_to_customer_id);
3601     p1_a239 := rosetta_g_miss_num_map(ddx_line_rec.accounting_rule_duration);
3602     p1_a240 := rosetta_g_miss_num_map(ddx_line_rec.unit_cost);
3603     p1_a241 := ddx_line_rec.user_item_description;
3604     p1_a242 := ddx_line_rec.xml_transaction_type_code;
3605     p1_a243 := rosetta_g_miss_num_map(ddx_line_rec.item_relationship_type);
3606     p1_a244 := rosetta_g_miss_num_map(ddx_line_rec.blanket_number);
3607     p1_a245 := rosetta_g_miss_num_map(ddx_line_rec.blanket_line_number);
3608     p1_a246 := rosetta_g_miss_num_map(ddx_line_rec.blanket_version_number);
3609     p1_a247 := ddx_line_rec.cso_response_flag;
3610     p1_a248 := ddx_line_rec.firm_demand_flag;
3611     p1_a249 := ddx_line_rec.earliest_ship_date;
3612     p1_a250 := ddx_line_rec.transaction_phase_code;
3613     p1_a251 := rosetta_g_miss_num_map(ddx_line_rec.source_document_version_number);
3614     p1_a252 := rosetta_g_miss_num_map(ddx_line_rec.minisite_id);
3615     p1_a253 := ddx_line_rec.ib_owner;
3616     p1_a254 := ddx_line_rec.ib_installed_at_location;
3617     p1_a255 := ddx_line_rec.ib_current_location;
3618     p1_a256 := rosetta_g_miss_num_map(ddx_line_rec.end_customer_id);
3619     p1_a257 := rosetta_g_miss_num_map(ddx_line_rec.end_customer_contact_id);
3620     p1_a258 := rosetta_g_miss_num_map(ddx_line_rec.end_customer_site_use_id);
3621     p1_a259 := ddx_line_rec.supplier_signature;
3622     p1_a260 := ddx_line_rec.supplier_signature_date;
3623     p1_a261 := ddx_line_rec.customer_signature;
3624     p1_a262 := ddx_line_rec.customer_signature_date;
3625     p1_a263 := rosetta_g_miss_num_map(ddx_line_rec.ship_to_party_id);
3626     p1_a264 := rosetta_g_miss_num_map(ddx_line_rec.ship_to_party_site_id);
3627     p1_a265 := rosetta_g_miss_num_map(ddx_line_rec.ship_to_party_site_use_id);
3628     p1_a266 := rosetta_g_miss_num_map(ddx_line_rec.deliver_to_party_id);
3629     p1_a267 := rosetta_g_miss_num_map(ddx_line_rec.deliver_to_party_site_id);
3630     p1_a268 := rosetta_g_miss_num_map(ddx_line_rec.deliver_to_party_site_use_id);
3631     p1_a269 := rosetta_g_miss_num_map(ddx_line_rec.invoice_to_party_id);
3632     p1_a270 := rosetta_g_miss_num_map(ddx_line_rec.invoice_to_party_site_id);
3633     p1_a271 := rosetta_g_miss_num_map(ddx_line_rec.invoice_to_party_site_use_id);
3634     p1_a272 := rosetta_g_miss_num_map(ddx_line_rec.ship_to_customer_party_id);
3635     p1_a273 := rosetta_g_miss_num_map(ddx_line_rec.deliver_to_customer_party_id);
3636     p1_a274 := rosetta_g_miss_num_map(ddx_line_rec.invoice_to_customer_party_id);
3637     p1_a275 := rosetta_g_miss_num_map(ddx_line_rec.ship_to_org_contact_id);
3638     p1_a276 := rosetta_g_miss_num_map(ddx_line_rec.deliver_to_org_contact_id);
3639     p1_a277 := rosetta_g_miss_num_map(ddx_line_rec.invoice_to_org_contact_id);
3640     p1_a278 := rosetta_g_miss_num_map(ddx_line_rec.retrobill_request_id);
3641     p1_a279 := rosetta_g_miss_num_map(ddx_line_rec.original_list_price);
3642     p1_a280 := rosetta_g_miss_num_map(ddx_line_rec.commitment_applied_amount);
3643   end;
3644 
3645 end oe_portal_util_w;