[Home] [Help]
PACKAGE BODY: APPS.OE_ORDER_PVT_W
Source
1 package body oe_order_pvt_w as
2 /* $Header: OERVORDB.pls 120.0 2005/05/31 23:16:57 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 l_fname varchar2(240);
7
8
9
10 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
11 function rosetta_g_miss_date_in_map(d date) return date as
12 begin
13 if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
14 return d;
15 end;
16
17 function rosetta_g_miss_num_map(n number) return number as
18 a number := fnd_api.g_miss_num;
19 b number := 0-1962.0724;
20 begin
21 if n=a then return b; end if;
22 if n=b then return a; end if;
23 return n;
24 end;
25
26 procedure header(p_init_msg_list VARCHAR2
27 , p_validation_level NUMBER
28 , p2_a0 NUMBER
29 , p2_a1 NUMBER
30 , p2_a2 NUMBER
31 , p2_a3 NUMBER
32 , p2_a4 NUMBER
33 , p2_a5 NUMBER
34 , p2_a6 NUMBER
35 , p2_a7 NUMBER
36 , p2_a8 NUMBER
37 , p2_a9 NUMBER
38 , p2_a10 VARCHAR2
39 , p2_a11 NUMBER
40 , p2_a12 NUMBER
41 , p2_a13 VARCHAR2
42 , p2_a14 VARCHAR2
43 , p2_a15 NUMBER
44 , p3_a0 in out NOCOPY /* file.sql.39 change */ NUMBER
45 , p3_a1 in out NOCOPY /* file.sql.39 change */ NUMBER
46 , p3_a2 in out NOCOPY /* file.sql.39 change */ VARCHAR2
47 , p3_a3 in out NOCOPY /* file.sql.39 change */ VARCHAR2
48 , p3_a4 in out NOCOPY /* file.sql.39 change */ VARCHAR2
49 , p3_a5 in out NOCOPY /* file.sql.39 change */ VARCHAR2
50 , p3_a6 in out NOCOPY /* file.sql.39 change */ VARCHAR2
51 , p3_a7 in out NOCOPY /* file.sql.39 change */ VARCHAR2
52 , p3_a8 in out NOCOPY /* file.sql.39 change */ VARCHAR2
53 , p3_a9 in out NOCOPY /* file.sql.39 change */ VARCHAR2
54 , p3_a10 in out NOCOPY /* file.sql.39 change */ VARCHAR2
55 , p3_a11 in out NOCOPY /* file.sql.39 change */ VARCHAR2
56 , p3_a12 in out NOCOPY /* file.sql.39 change */ VARCHAR2
57 , p3_a13 in out NOCOPY /* file.sql.39 change */ VARCHAR2
58 , p3_a14 in out NOCOPY /* file.sql.39 change */ VARCHAR2
59 , p3_a15 in out NOCOPY /* file.sql.39 change */ VARCHAR2
60 , p3_a16 in out NOCOPY /* file.sql.39 change */ VARCHAR2
61 , p3_a17 in out NOCOPY /* file.sql.39 change */ VARCHAR2
62 , p3_a18 in out NOCOPY /* file.sql.39 change */ VARCHAR2
63 , p3_a19 in out NOCOPY /* file.sql.39 change */ VARCHAR2
64 , p3_a20 in out NOCOPY /* file.sql.39 change */ VARCHAR2
65 , p3_a21 in out NOCOPY /* file.sql.39 change */ VARCHAR2
66 , p3_a22 in out NOCOPY /* file.sql.39 change */ VARCHAR2
67 , p3_a23 in out NOCOPY /* file.sql.39 change */ VARCHAR2
68 , p3_a24 in out NOCOPY /* file.sql.39 change */ VARCHAR2
69 , p3_a25 in out NOCOPY /* file.sql.39 change */ NUMBER
70 , p3_a26 in out NOCOPY /* file.sql.39 change */ DATE
71 , p3_a27 in out NOCOPY /* file.sql.39 change */ VARCHAR2
72 , p3_a28 in out NOCOPY /* file.sql.39 change */ VARCHAR2
73 , p3_a29 in out NOCOPY /* file.sql.39 change */ NUMBER
74 , p3_a30 in out NOCOPY /* file.sql.39 change */ DATE
75 , p3_a31 in out NOCOPY /* file.sql.39 change */ VARCHAR2
76 , p3_a32 in out NOCOPY /* file.sql.39 change */ NUMBER
77 , p3_a33 in out NOCOPY /* file.sql.39 change */ NUMBER
78 , p3_a34 in out NOCOPY /* file.sql.39 change */ VARCHAR2
79 , p3_a35 in out NOCOPY /* file.sql.39 change */ NUMBER
80 , p3_a36 in out NOCOPY /* file.sql.39 change */ DATE
81 , p3_a37 in out NOCOPY /* file.sql.39 change */ VARCHAR2
82 , p3_a38 in out NOCOPY /* file.sql.39 change */ VARCHAR2
83 , p3_a39 in out NOCOPY /* file.sql.39 change */ VARCHAR2
84 , p3_a40 in out NOCOPY /* file.sql.39 change */ VARCHAR2
85 , p3_a41 in out NOCOPY /* file.sql.39 change */ VARCHAR2
86 , p3_a42 in out NOCOPY /* file.sql.39 change */ VARCHAR2
87 , p3_a43 in out NOCOPY /* file.sql.39 change */ VARCHAR2
88 , p3_a44 in out NOCOPY /* file.sql.39 change */ VARCHAR2
89 , p3_a45 in out NOCOPY /* file.sql.39 change */ VARCHAR2
90 , p3_a46 in out NOCOPY /* file.sql.39 change */ VARCHAR2
91 , p3_a47 in out NOCOPY /* file.sql.39 change */ VARCHAR2
92 , p3_a48 in out NOCOPY /* file.sql.39 change */ VARCHAR2
93 , p3_a49 in out NOCOPY /* file.sql.39 change */ VARCHAR2
94 , p3_a50 in out NOCOPY /* file.sql.39 change */ VARCHAR2
95 , p3_a51 in out NOCOPY /* file.sql.39 change */ VARCHAR2
96 , p3_a52 in out NOCOPY /* file.sql.39 change */ VARCHAR2
97 , p3_a53 in out NOCOPY /* file.sql.39 change */ VARCHAR2
98 , p3_a54 in out NOCOPY /* file.sql.39 change */ VARCHAR2
99 , p3_a55 in out NOCOPY /* file.sql.39 change */ VARCHAR2
100 , p3_a56 in out NOCOPY /* file.sql.39 change */ VARCHAR2
101 , p3_a57 in out NOCOPY /* file.sql.39 change */ VARCHAR2
102 , p3_a58 in out NOCOPY /* file.sql.39 change */ VARCHAR2
103 , p3_a59 in out NOCOPY /* file.sql.39 change */ VARCHAR2
104 , p3_a60 in out NOCOPY /* file.sql.39 change */ VARCHAR2
105 , p3_a61 in out NOCOPY /* file.sql.39 change */ VARCHAR2
106 , p3_a62 in out NOCOPY /* file.sql.39 change */ VARCHAR2
107 , p3_a63 in out NOCOPY /* file.sql.39 change */ VARCHAR2
108 , p3_a64 in out NOCOPY /* file.sql.39 change */ VARCHAR2
109 , p3_a65 in out NOCOPY /* file.sql.39 change */ VARCHAR2
110 , p3_a66 in out NOCOPY /* file.sql.39 change */ VARCHAR2
111 , p3_a67 in out NOCOPY /* file.sql.39 change */ VARCHAR2
112 , p3_a68 in out NOCOPY /* file.sql.39 change */ VARCHAR2
113 , p3_a69 in out NOCOPY /* file.sql.39 change */ VARCHAR2
114 , p3_a70 in out NOCOPY /* file.sql.39 change */ VARCHAR2
115 , p3_a71 in out NOCOPY /* file.sql.39 change */ VARCHAR2
116 , p3_a72 in out NOCOPY /* file.sql.39 change */ VARCHAR2
117 , p3_a73 in out NOCOPY /* file.sql.39 change */ VARCHAR2
118 , p3_a74 in out NOCOPY /* file.sql.39 change */ VARCHAR2
119 , p3_a75 in out NOCOPY /* file.sql.39 change */ VARCHAR2
120 , p3_a76 in out NOCOPY /* file.sql.39 change */ VARCHAR2
121 , p3_a77 in out NOCOPY /* file.sql.39 change */ NUMBER
122 , p3_a78 in out NOCOPY /* file.sql.39 change */ NUMBER
123 , p3_a79 in out NOCOPY /* file.sql.39 change */ NUMBER
124 , p3_a80 in out NOCOPY /* file.sql.39 change */ NUMBER
125 , p3_a81 in out NOCOPY /* file.sql.39 change */ NUMBER
126 , p3_a82 in out NOCOPY /* file.sql.39 change */ DATE
127 , p3_a83 in out NOCOPY /* file.sql.39 change */ NUMBER
128 , p3_a84 in out NOCOPY /* file.sql.39 change */ NUMBER
129 , p3_a85 in out NOCOPY /* file.sql.39 change */ VARCHAR2
130 , p3_a86 in out NOCOPY /* file.sql.39 change */ VARCHAR2
131 , p3_a87 in out NOCOPY /* file.sql.39 change */ DATE
132 , p3_a88 in out NOCOPY /* file.sql.39 change */ VARCHAR2
133 , p3_a89 in out NOCOPY /* file.sql.39 change */ NUMBER
134 , p3_a90 in out NOCOPY /* file.sql.39 change */ NUMBER
135 , p3_a91 in out NOCOPY /* file.sql.39 change */ NUMBER
136 , p3_a92 in out NOCOPY /* file.sql.39 change */ NUMBER
137 , p3_a93 in out NOCOPY /* file.sql.39 change */ VARCHAR2
138 , p3_a94 in out NOCOPY /* file.sql.39 change */ VARCHAR2
139 , p3_a95 in out NOCOPY /* file.sql.39 change */ NUMBER
140 , p3_a96 in out NOCOPY /* file.sql.39 change */ NUMBER
141 , p3_a97 in out NOCOPY /* file.sql.39 change */ VARCHAR2
142 , p3_a98 in out NOCOPY /* file.sql.39 change */ DATE
143 , p3_a99 in out NOCOPY /* file.sql.39 change */ NUMBER
144 , p3_a100 in out NOCOPY /* file.sql.39 change */ NUMBER
145 , p3_a101 in out NOCOPY /* file.sql.39 change */ DATE
146 , p3_a102 in out NOCOPY /* file.sql.39 change */ DATE
147 , p3_a103 in out NOCOPY /* file.sql.39 change */ NUMBER
148 , p3_a104 in out NOCOPY /* file.sql.39 change */ VARCHAR2
149 , p3_a105 in out NOCOPY /* file.sql.39 change */ NUMBER
150 , p3_a106 in out NOCOPY /* file.sql.39 change */ VARCHAR2
151 , p3_a107 in out NOCOPY /* file.sql.39 change */ VARCHAR2
152 , p3_a108 in out NOCOPY /* file.sql.39 change */ VARCHAR2
153 , p3_a109 in out NOCOPY /* file.sql.39 change */ NUMBER
154 , p3_a110 in out NOCOPY /* file.sql.39 change */ NUMBER
155 , p3_a111 in out NOCOPY /* file.sql.39 change */ NUMBER
156 , p3_a112 in out NOCOPY /* file.sql.39 change */ NUMBER
157 , p3_a113 in out NOCOPY /* file.sql.39 change */ NUMBER
158 , p3_a114 in out NOCOPY /* file.sql.39 change */ NUMBER
159 , p3_a115 in out NOCOPY /* file.sql.39 change */ NUMBER
160 , p3_a116 in out NOCOPY /* file.sql.39 change */ NUMBER
161 , p3_a117 in out NOCOPY /* file.sql.39 change */ NUMBER
162 , p3_a118 in out NOCOPY /* file.sql.39 change */ NUMBER
163 , p3_a119 in out NOCOPY /* file.sql.39 change */ NUMBER
164 , p3_a120 in out NOCOPY /* file.sql.39 change */ VARCHAR2
165 , p3_a121 in out NOCOPY /* file.sql.39 change */ VARCHAR2
166 , p3_a122 in out NOCOPY /* file.sql.39 change */ VARCHAR2
167 , p3_a123 in out NOCOPY /* file.sql.39 change */ VARCHAR2
168 , p3_a124 in out NOCOPY /* file.sql.39 change */ VARCHAR2
169 , p3_a125 in out NOCOPY /* file.sql.39 change */ NUMBER
170 , p3_a126 in out NOCOPY /* file.sql.39 change */ VARCHAR2
171 , p3_a127 in out NOCOPY /* file.sql.39 change */ VARCHAR2
172 , p3_a128 in out NOCOPY /* file.sql.39 change */ VARCHAR2
173 , p3_a129 in out NOCOPY /* file.sql.39 change */ VARCHAR2
174 , p3_a130 in out NOCOPY /* file.sql.39 change */ DATE
175 , p3_a131 in out NOCOPY /* file.sql.39 change */ VARCHAR2
176 , p3_a132 in out NOCOPY /* file.sql.39 change */ DATE
177 , p3_a133 in out NOCOPY /* file.sql.39 change */ VARCHAR2
178 , p3_a134 in out NOCOPY /* file.sql.39 change */ VARCHAR2
179 , p3_a135 in out NOCOPY /* file.sql.39 change */ VARCHAR2
180 , p3_a136 in out NOCOPY /* file.sql.39 change */ VARCHAR2
181 , p3_a137 in out NOCOPY /* file.sql.39 change */ VARCHAR2
182 , p3_a138 in out NOCOPY /* file.sql.39 change */ VARCHAR2
183 , p3_a139 in out NOCOPY /* file.sql.39 change */ VARCHAR2
184 , p3_a140 in out NOCOPY /* file.sql.39 change */ VARCHAR2
185 , p3_a141 in out NOCOPY /* file.sql.39 change */ NUMBER
186 , p3_a142 in out NOCOPY /* file.sql.39 change */ VARCHAR2
187 , p3_a143 in out NOCOPY /* file.sql.39 change */ NUMBER
188 , p3_a144 in out NOCOPY /* file.sql.39 change */ VARCHAR2
189 , p3_a145 in out NOCOPY /* file.sql.39 change */ VARCHAR2
190 , p3_a146 in out NOCOPY /* file.sql.39 change */ VARCHAR2
191 , p3_a147 in out NOCOPY /* file.sql.39 change */ VARCHAR2
192 , p3_a148 in out NOCOPY /* file.sql.39 change */ DATE
193 , p3_a149 in out NOCOPY /* file.sql.39 change */ VARCHAR2
194 , p3_a150 in out NOCOPY /* file.sql.39 change */ DATE
195 , p3_a151 in out NOCOPY /* file.sql.39 change */ VARCHAR2
196 , p3_a152 in out NOCOPY /* file.sql.39 change */ VARCHAR2
197 , p3_a153 in out NOCOPY /* file.sql.39 change */ VARCHAR2
198 , p3_a154 in out NOCOPY /* file.sql.39 change */ DATE
199 , p3_a155 in out NOCOPY /* file.sql.39 change */ NUMBER
200 , p3_a156 in out NOCOPY /* file.sql.39 change */ VARCHAR2
201 , p3_a157 in out NOCOPY /* file.sql.39 change */ NUMBER
202 , p3_a158 in out NOCOPY /* file.sql.39 change */ VARCHAR2
203 , p3_a159 in out NOCOPY /* file.sql.39 change */ VARCHAR2
204 , p3_a160 in out NOCOPY /* file.sql.39 change */ VARCHAR2
205 , p3_a161 in out NOCOPY /* file.sql.39 change */ VARCHAR2
206 , p3_a162 in out NOCOPY /* file.sql.39 change */ NUMBER
207 , p3_a163 in out NOCOPY /* file.sql.39 change */ NUMBER
208 , p3_a164 in out NOCOPY /* file.sql.39 change */ NUMBER
209 , p3_a165 in out NOCOPY /* file.sql.39 change */ NUMBER
210 , p3_a166 in out NOCOPY /* file.sql.39 change */ VARCHAR2
211 , p3_a167 in out NOCOPY /* file.sql.39 change */ NUMBER
212 , p3_a168 in out NOCOPY /* file.sql.39 change */ NUMBER
213 , p3_a169 in out NOCOPY /* file.sql.39 change */ NUMBER
214 , p3_a170 in out NOCOPY /* file.sql.39 change */ NUMBER
215 , p3_a171 in out NOCOPY /* file.sql.39 change */ NUMBER
216 , p3_a172 in out NOCOPY /* file.sql.39 change */ VARCHAR2
217 , p3_a173 in out NOCOPY /* file.sql.39 change */ NUMBER
218 , p3_a174 in out NOCOPY /* file.sql.39 change */ VARCHAR2
219 , p3_a175 in out NOCOPY /* file.sql.39 change */ VARCHAR2
220 , p3_a176 in out NOCOPY /* file.sql.39 change */ VARCHAR2
221 , p4_a0 in out NOCOPY /* file.sql.39 change */ NUMBER
222 , p4_a1 in out NOCOPY /* file.sql.39 change */ NUMBER
223 , p4_a2 in out NOCOPY /* file.sql.39 change */ VARCHAR2
224 , p4_a3 in out NOCOPY /* file.sql.39 change */ VARCHAR2
225 , p4_a4 in out NOCOPY /* file.sql.39 change */ VARCHAR2
226 , p4_a5 in out NOCOPY /* file.sql.39 change */ VARCHAR2
227 , p4_a6 in out NOCOPY /* file.sql.39 change */ VARCHAR2
228 , p4_a7 in out NOCOPY /* file.sql.39 change */ VARCHAR2
229 , p4_a8 in out NOCOPY /* file.sql.39 change */ VARCHAR2
230 , p4_a9 in out NOCOPY /* file.sql.39 change */ VARCHAR2
231 , p4_a10 in out NOCOPY /* file.sql.39 change */ VARCHAR2
232 , p4_a11 in out NOCOPY /* file.sql.39 change */ VARCHAR2
233 , p4_a12 in out NOCOPY /* file.sql.39 change */ VARCHAR2
234 , p4_a13 in out NOCOPY /* file.sql.39 change */ VARCHAR2
235 , p4_a14 in out NOCOPY /* file.sql.39 change */ VARCHAR2
236 , p4_a15 in out NOCOPY /* file.sql.39 change */ VARCHAR2
237 , p4_a16 in out NOCOPY /* file.sql.39 change */ VARCHAR2
238 , p4_a17 in out NOCOPY /* file.sql.39 change */ VARCHAR2
239 , p4_a18 in out NOCOPY /* file.sql.39 change */ VARCHAR2
240 , p4_a19 in out NOCOPY /* file.sql.39 change */ VARCHAR2
241 , p4_a20 in out NOCOPY /* file.sql.39 change */ VARCHAR2
242 , p4_a21 in out NOCOPY /* file.sql.39 change */ VARCHAR2
243 , p4_a22 in out NOCOPY /* file.sql.39 change */ VARCHAR2
244 , p4_a23 in out NOCOPY /* file.sql.39 change */ VARCHAR2
245 , p4_a24 in out NOCOPY /* file.sql.39 change */ VARCHAR2
246 , p4_a25 in out NOCOPY /* file.sql.39 change */ NUMBER
247 , p4_a26 in out NOCOPY /* file.sql.39 change */ DATE
248 , p4_a27 in out NOCOPY /* file.sql.39 change */ VARCHAR2
249 , p4_a28 in out NOCOPY /* file.sql.39 change */ VARCHAR2
250 , p4_a29 in out NOCOPY /* file.sql.39 change */ NUMBER
251 , p4_a30 in out NOCOPY /* file.sql.39 change */ DATE
252 , p4_a31 in out NOCOPY /* file.sql.39 change */ VARCHAR2
253 , p4_a32 in out NOCOPY /* file.sql.39 change */ NUMBER
254 , p4_a33 in out NOCOPY /* file.sql.39 change */ NUMBER
255 , p4_a34 in out NOCOPY /* file.sql.39 change */ VARCHAR2
256 , p4_a35 in out NOCOPY /* file.sql.39 change */ NUMBER
257 , p4_a36 in out NOCOPY /* file.sql.39 change */ DATE
258 , p4_a37 in out NOCOPY /* file.sql.39 change */ VARCHAR2
259 , p4_a38 in out NOCOPY /* file.sql.39 change */ VARCHAR2
260 , p4_a39 in out NOCOPY /* file.sql.39 change */ VARCHAR2
261 , p4_a40 in out NOCOPY /* file.sql.39 change */ VARCHAR2
262 , p4_a41 in out NOCOPY /* file.sql.39 change */ VARCHAR2
263 , p4_a42 in out NOCOPY /* file.sql.39 change */ VARCHAR2
264 , p4_a43 in out NOCOPY /* file.sql.39 change */ VARCHAR2
265 , p4_a44 in out NOCOPY /* file.sql.39 change */ VARCHAR2
266 , p4_a45 in out NOCOPY /* file.sql.39 change */ VARCHAR2
267 , p4_a46 in out NOCOPY /* file.sql.39 change */ VARCHAR2
268 , p4_a47 in out NOCOPY /* file.sql.39 change */ VARCHAR2
269 , p4_a48 in out NOCOPY /* file.sql.39 change */ VARCHAR2
270 , p4_a49 in out NOCOPY /* file.sql.39 change */ VARCHAR2
271 , p4_a50 in out NOCOPY /* file.sql.39 change */ VARCHAR2
272 , p4_a51 in out NOCOPY /* file.sql.39 change */ VARCHAR2
273 , p4_a52 in out NOCOPY /* file.sql.39 change */ VARCHAR2
274 , p4_a53 in out NOCOPY /* file.sql.39 change */ VARCHAR2
275 , p4_a54 in out NOCOPY /* file.sql.39 change */ VARCHAR2
276 , p4_a55 in out NOCOPY /* file.sql.39 change */ VARCHAR2
277 , p4_a56 in out NOCOPY /* file.sql.39 change */ VARCHAR2
278 , p4_a57 in out NOCOPY /* file.sql.39 change */ VARCHAR2
279 , p4_a58 in out NOCOPY /* file.sql.39 change */ VARCHAR2
280 , p4_a59 in out NOCOPY /* file.sql.39 change */ VARCHAR2
281 , p4_a60 in out NOCOPY /* file.sql.39 change */ VARCHAR2
282 , p4_a61 in out NOCOPY /* file.sql.39 change */ VARCHAR2
283 , p4_a62 in out NOCOPY /* file.sql.39 change */ VARCHAR2
284 , p4_a63 in out NOCOPY /* file.sql.39 change */ VARCHAR2
285 , p4_a64 in out NOCOPY /* file.sql.39 change */ VARCHAR2
286 , p4_a65 in out NOCOPY /* file.sql.39 change */ VARCHAR2
287 , p4_a66 in out NOCOPY /* file.sql.39 change */ VARCHAR2
288 , p4_a67 in out NOCOPY /* file.sql.39 change */ VARCHAR2
289 , p4_a68 in out NOCOPY /* file.sql.39 change */ VARCHAR2
290 , p4_a69 in out NOCOPY /* file.sql.39 change */ VARCHAR2
291 , p4_a70 in out NOCOPY /* file.sql.39 change */ VARCHAR2
292 , p4_a71 in out NOCOPY /* file.sql.39 change */ VARCHAR2
293 , p4_a72 in out NOCOPY /* file.sql.39 change */ VARCHAR2
294 , p4_a73 in out NOCOPY /* file.sql.39 change */ VARCHAR2
295 , p4_a74 in out NOCOPY /* file.sql.39 change */ VARCHAR2
296 , p4_a75 in out NOCOPY /* file.sql.39 change */ VARCHAR2
297 , p4_a76 in out NOCOPY /* file.sql.39 change */ VARCHAR2
298 , p4_a77 in out NOCOPY /* file.sql.39 change */ NUMBER
299 , p4_a78 in out NOCOPY /* file.sql.39 change */ NUMBER
300 , p4_a79 in out NOCOPY /* file.sql.39 change */ NUMBER
301 , p4_a80 in out NOCOPY /* file.sql.39 change */ NUMBER
302 , p4_a81 in out NOCOPY /* file.sql.39 change */ NUMBER
303 , p4_a82 in out NOCOPY /* file.sql.39 change */ DATE
304 , p4_a83 in out NOCOPY /* file.sql.39 change */ NUMBER
305 , p4_a84 in out NOCOPY /* file.sql.39 change */ NUMBER
306 , p4_a85 in out NOCOPY /* file.sql.39 change */ VARCHAR2
307 , p4_a86 in out NOCOPY /* file.sql.39 change */ VARCHAR2
308 , p4_a87 in out NOCOPY /* file.sql.39 change */ DATE
309 , p4_a88 in out NOCOPY /* file.sql.39 change */ VARCHAR2
310 , p4_a89 in out NOCOPY /* file.sql.39 change */ NUMBER
311 , p4_a90 in out NOCOPY /* file.sql.39 change */ NUMBER
312 , p4_a91 in out NOCOPY /* file.sql.39 change */ NUMBER
313 , p4_a92 in out NOCOPY /* file.sql.39 change */ NUMBER
314 , p4_a93 in out NOCOPY /* file.sql.39 change */ VARCHAR2
315 , p4_a94 in out NOCOPY /* file.sql.39 change */ VARCHAR2
316 , p4_a95 in out NOCOPY /* file.sql.39 change */ NUMBER
317 , p4_a96 in out NOCOPY /* file.sql.39 change */ NUMBER
318 , p4_a97 in out NOCOPY /* file.sql.39 change */ VARCHAR2
319 , p4_a98 in out NOCOPY /* file.sql.39 change */ DATE
320 , p4_a99 in out NOCOPY /* file.sql.39 change */ NUMBER
321 , p4_a100 in out NOCOPY /* file.sql.39 change */ NUMBER
322 , p4_a101 in out NOCOPY /* file.sql.39 change */ DATE
323 , p4_a102 in out NOCOPY /* file.sql.39 change */ DATE
324 , p4_a103 in out NOCOPY /* file.sql.39 change */ NUMBER
325 , p4_a104 in out NOCOPY /* file.sql.39 change */ VARCHAR2
326 , p4_a105 in out NOCOPY /* file.sql.39 change */ NUMBER
327 , p4_a106 in out NOCOPY /* file.sql.39 change */ VARCHAR2
328 , p4_a107 in out NOCOPY /* file.sql.39 change */ VARCHAR2
329 , p4_a108 in out NOCOPY /* file.sql.39 change */ VARCHAR2
330 , p4_a109 in out NOCOPY /* file.sql.39 change */ NUMBER
331 , p4_a110 in out NOCOPY /* file.sql.39 change */ NUMBER
332 , p4_a111 in out NOCOPY /* file.sql.39 change */ NUMBER
333 , p4_a112 in out NOCOPY /* file.sql.39 change */ NUMBER
334 , p4_a113 in out NOCOPY /* file.sql.39 change */ NUMBER
335 , p4_a114 in out NOCOPY /* file.sql.39 change */ NUMBER
336 , p4_a115 in out NOCOPY /* file.sql.39 change */ NUMBER
337 , p4_a116 in out NOCOPY /* file.sql.39 change */ NUMBER
338 , p4_a117 in out NOCOPY /* file.sql.39 change */ NUMBER
339 , p4_a118 in out NOCOPY /* file.sql.39 change */ NUMBER
340 , p4_a119 in out NOCOPY /* file.sql.39 change */ NUMBER
341 , p4_a120 in out NOCOPY /* file.sql.39 change */ VARCHAR2
342 , p4_a121 in out NOCOPY /* file.sql.39 change */ VARCHAR2
343 , p4_a122 in out NOCOPY /* file.sql.39 change */ VARCHAR2
344 , p4_a123 in out NOCOPY /* file.sql.39 change */ VARCHAR2
345 , p4_a124 in out NOCOPY /* file.sql.39 change */ VARCHAR2
346 , p4_a125 in out NOCOPY /* file.sql.39 change */ NUMBER
347 , p4_a126 in out NOCOPY /* file.sql.39 change */ VARCHAR2
348 , p4_a127 in out NOCOPY /* file.sql.39 change */ VARCHAR2
349 , p4_a128 in out NOCOPY /* file.sql.39 change */ VARCHAR2
350 , p4_a129 in out NOCOPY /* file.sql.39 change */ VARCHAR2
351 , p4_a130 in out NOCOPY /* file.sql.39 change */ DATE
352 , p4_a131 in out NOCOPY /* file.sql.39 change */ VARCHAR2
353 , p4_a132 in out NOCOPY /* file.sql.39 change */ DATE
354 , p4_a133 in out NOCOPY /* file.sql.39 change */ VARCHAR2
355 , p4_a134 in out NOCOPY /* file.sql.39 change */ VARCHAR2
356 , p4_a135 in out NOCOPY /* file.sql.39 change */ VARCHAR2
357 , p4_a136 in out NOCOPY /* file.sql.39 change */ VARCHAR2
358 , p4_a137 in out NOCOPY /* file.sql.39 change */ VARCHAR2
359 , p4_a138 in out NOCOPY /* file.sql.39 change */ VARCHAR2
360 , p4_a139 in out NOCOPY /* file.sql.39 change */ VARCHAR2
361 , p4_a140 in out NOCOPY /* file.sql.39 change */ VARCHAR2
362 , p4_a141 in out NOCOPY /* file.sql.39 change */ NUMBER
363 , p4_a142 in out NOCOPY /* file.sql.39 change */ VARCHAR2
364 , p4_a143 in out NOCOPY /* file.sql.39 change */ NUMBER
365 , p4_a144 in out NOCOPY /* file.sql.39 change */ VARCHAR2
366 , p4_a145 in out NOCOPY /* file.sql.39 change */ VARCHAR2
367 , p4_a146 in out NOCOPY /* file.sql.39 change */ VARCHAR2
368 , p4_a147 in out NOCOPY /* file.sql.39 change */ VARCHAR2
369 , p4_a148 in out NOCOPY /* file.sql.39 change */ DATE
370 , p4_a149 in out NOCOPY /* file.sql.39 change */ VARCHAR2
371 , p4_a150 in out NOCOPY /* file.sql.39 change */ DATE
372 , p4_a151 in out NOCOPY /* file.sql.39 change */ VARCHAR2
373 , p4_a152 in out NOCOPY /* file.sql.39 change */ VARCHAR2
374 , p4_a153 in out NOCOPY /* file.sql.39 change */ VARCHAR2
375 , p4_a154 in out NOCOPY /* file.sql.39 change */ DATE
376 , p4_a155 in out NOCOPY /* file.sql.39 change */ NUMBER
377 , p4_a156 in out NOCOPY /* file.sql.39 change */ VARCHAR2
378 , p4_a157 in out NOCOPY /* file.sql.39 change */ NUMBER
379 , p4_a158 in out NOCOPY /* file.sql.39 change */ VARCHAR2
380 , p4_a159 in out NOCOPY /* file.sql.39 change */ VARCHAR2
381 , p4_a160 in out NOCOPY /* file.sql.39 change */ VARCHAR2
382 , p4_a161 in out NOCOPY /* file.sql.39 change */ VARCHAR2
383 , p4_a162 in out NOCOPY /* file.sql.39 change */ NUMBER
384 , p4_a163 in out NOCOPY /* file.sql.39 change */ NUMBER
385 , p4_a164 in out NOCOPY /* file.sql.39 change */ NUMBER
386 , p4_a165 in out NOCOPY /* file.sql.39 change */ NUMBER
387 , p4_a166 in out NOCOPY /* file.sql.39 change */ VARCHAR2
388 , p4_a167 in out NOCOPY /* file.sql.39 change */ NUMBER
389 , p4_a168 in out NOCOPY /* file.sql.39 change */ NUMBER
390 , p4_a169 in out NOCOPY /* file.sql.39 change */ NUMBER
391 , p4_a170 in out NOCOPY /* file.sql.39 change */ NUMBER
392 , p4_a171 in out NOCOPY /* file.sql.39 change */ NUMBER
393 , p4_a172 in out NOCOPY /* file.sql.39 change */ VARCHAR2
394 , p4_a173 in out NOCOPY /* file.sql.39 change */ NUMBER
395 , p4_a174 in out NOCOPY /* file.sql.39 change */ VARCHAR2
396 , p4_a175 in out NOCOPY /* file.sql.39 change */ VARCHAR2
397 , p4_a176 in out NOCOPY /* file.sql.39 change */ VARCHAR2
398 , x_return_status out NOCOPY /* file.sql.39 change */ VARCHAR2
399 )
400
401 as
402 ddp_control_rec oe_globals.control_rec_type;
403 ddp_x_header_rec oe_order_pub.header_rec_type;
404 ddp_x_old_header_rec oe_order_pub.header_rec_type;
405 ddindx binary_integer; indx binary_integer;
406 begin
407
408 -- copy data to the local IN or IN-OUT args, if any
409
410
411 if p2_a0 is null
412 then ddp_control_rec.controlled_operation := null;
413 elsif p2_a0 = 0
414 then ddp_control_rec.controlled_operation := false;
415 else ddp_control_rec.controlled_operation := true;
416 end if;
417 if p2_a1 is null
418 then ddp_control_rec.private_call := null;
419 elsif p2_a1 = 0
420 then ddp_control_rec.private_call := false;
421 else ddp_control_rec.private_call := true;
422 end if;
423 if p2_a2 is null
424 then ddp_control_rec.check_security := null;
425 elsif p2_a2 = 0
426 then ddp_control_rec.check_security := false;
427 else ddp_control_rec.check_security := true;
428 end if;
429 if p2_a3 is null
430 then ddp_control_rec.clear_dependents := null;
431 elsif p2_a3 = 0
432 then ddp_control_rec.clear_dependents := false;
433 else ddp_control_rec.clear_dependents := true;
434 end if;
435 if p2_a4 is null
436 then ddp_control_rec.default_attributes := null;
437 elsif p2_a4 = 0
438 then ddp_control_rec.default_attributes := false;
439 else ddp_control_rec.default_attributes := true;
440 end if;
441 if p2_a5 is null
442 then ddp_control_rec.change_attributes := null;
443 elsif p2_a5 = 0
444 then ddp_control_rec.change_attributes := false;
445 else ddp_control_rec.change_attributes := true;
446 end if;
447 if p2_a6 is null
448 then ddp_control_rec.validate_entity := null;
449 elsif p2_a6 = 0
450 then ddp_control_rec.validate_entity := false;
451 else ddp_control_rec.validate_entity := true;
452 end if;
453 if p2_a7 is null
454 then ddp_control_rec.write_to_db := null;
455 elsif p2_a7 = 0
456 then ddp_control_rec.write_to_db := false;
457 else ddp_control_rec.write_to_db := true;
458 end if;
459 if p2_a8 is null
460 then ddp_control_rec.process_partial := null;
461 elsif p2_a8 = 0
462 then ddp_control_rec.process_partial := false;
463 else ddp_control_rec.process_partial := true;
464 end if;
465 if p2_a9 is null
466 then ddp_control_rec.process := null;
467 elsif p2_a9 = 0
468 then ddp_control_rec.process := false;
469 else ddp_control_rec.process := true;
470 end if;
471 ddp_control_rec.process_entity := p2_a10;
472 if p2_a11 is null
473 then ddp_control_rec.clear_api_cache := null;
474 elsif p2_a11 = 0
475 then ddp_control_rec.clear_api_cache := false;
476 else ddp_control_rec.clear_api_cache := true;
477 end if;
478 if p2_a12 is null
479 then ddp_control_rec.clear_api_requests := null;
480 elsif p2_a12 = 0
481 then ddp_control_rec.clear_api_requests := false;
482 else ddp_control_rec.clear_api_requests := true;
483 end if;
484 ddp_control_rec.request_category := p2_a13;
485 ddp_control_rec.request_name := p2_a14;
486 ddp_control_rec.org_id := rosetta_g_miss_num_map(p2_a15);
487
488 ddp_x_header_rec.accounting_rule_id := rosetta_g_miss_num_map(p3_a0);
489 ddp_x_header_rec.agreement_id := rosetta_g_miss_num_map(p3_a1);
490 ddp_x_header_rec.attribute1 := p3_a2;
491 ddp_x_header_rec.attribute10 := p3_a3;
492 ddp_x_header_rec.attribute11 := p3_a4;
493 ddp_x_header_rec.attribute12 := p3_a5;
494 ddp_x_header_rec.attribute13 := p3_a6;
495 ddp_x_header_rec.attribute14 := p3_a7;
496 ddp_x_header_rec.attribute15 := p3_a8;
497 ddp_x_header_rec.attribute16 := p3_a9;
498 ddp_x_header_rec.attribute17 := p3_a10;
499 ddp_x_header_rec.attribute18 := p3_a11;
500 ddp_x_header_rec.attribute19 := p3_a12;
501 ddp_x_header_rec.attribute2 := p3_a13;
502 ddp_x_header_rec.attribute20 := p3_a14;
503 ddp_x_header_rec.attribute3 := p3_a15;
504 ddp_x_header_rec.attribute4 := p3_a16;
505 ddp_x_header_rec.attribute5 := p3_a17;
506 ddp_x_header_rec.attribute6 := p3_a18;
507 ddp_x_header_rec.attribute7 := p3_a19;
508 ddp_x_header_rec.attribute8 := p3_a20;
509 ddp_x_header_rec.attribute9 := p3_a21;
510 ddp_x_header_rec.booked_flag := p3_a22;
511 ddp_x_header_rec.cancelled_flag := p3_a23;
512 ddp_x_header_rec.context := p3_a24;
513 ddp_x_header_rec.conversion_rate := rosetta_g_miss_num_map(p3_a25);
514 ddp_x_header_rec.conversion_rate_date := rosetta_g_miss_date_in_map(p3_a26);
515 ddp_x_header_rec.conversion_type_code := p3_a27;
516 ddp_x_header_rec.customer_preference_set_code := p3_a28;
517 ddp_x_header_rec.created_by := rosetta_g_miss_num_map(p3_a29);
518 ddp_x_header_rec.creation_date := rosetta_g_miss_date_in_map(p3_a30);
519 ddp_x_header_rec.cust_po_number := p3_a31;
520 ddp_x_header_rec.deliver_to_contact_id := rosetta_g_miss_num_map(p3_a32);
521 ddp_x_header_rec.deliver_to_org_id := rosetta_g_miss_num_map(p3_a33);
522 ddp_x_header_rec.demand_class_code := p3_a34;
523 ddp_x_header_rec.earliest_schedule_limit := rosetta_g_miss_num_map(p3_a35);
524 ddp_x_header_rec.expiration_date := rosetta_g_miss_date_in_map(p3_a36);
525 ddp_x_header_rec.fob_point_code := p3_a37;
526 ddp_x_header_rec.freight_carrier_code := p3_a38;
527 ddp_x_header_rec.freight_terms_code := p3_a39;
528 ddp_x_header_rec.global_attribute1 := p3_a40;
529 ddp_x_header_rec.global_attribute10 := p3_a41;
530 ddp_x_header_rec.global_attribute11 := p3_a42;
531 ddp_x_header_rec.global_attribute12 := p3_a43;
532 ddp_x_header_rec.global_attribute13 := p3_a44;
533 ddp_x_header_rec.global_attribute14 := p3_a45;
534 ddp_x_header_rec.global_attribute15 := p3_a46;
535 ddp_x_header_rec.global_attribute16 := p3_a47;
536 ddp_x_header_rec.global_attribute17 := p3_a48;
537 ddp_x_header_rec.global_attribute18 := p3_a49;
538 ddp_x_header_rec.global_attribute19 := p3_a50;
539 ddp_x_header_rec.global_attribute2 := p3_a51;
540 ddp_x_header_rec.global_attribute20 := p3_a52;
541 ddp_x_header_rec.global_attribute3 := p3_a53;
542 ddp_x_header_rec.global_attribute4 := p3_a54;
543 ddp_x_header_rec.global_attribute5 := p3_a55;
544 ddp_x_header_rec.global_attribute6 := p3_a56;
545 ddp_x_header_rec.global_attribute7 := p3_a57;
546 ddp_x_header_rec.global_attribute8 := p3_a58;
547 ddp_x_header_rec.global_attribute9 := p3_a59;
548 ddp_x_header_rec.global_attribute_category := p3_a60;
549 ddp_x_header_rec.tp_context := p3_a61;
550 ddp_x_header_rec.tp_attribute1 := p3_a62;
551 ddp_x_header_rec.tp_attribute2 := p3_a63;
552 ddp_x_header_rec.tp_attribute3 := p3_a64;
553 ddp_x_header_rec.tp_attribute4 := p3_a65;
554 ddp_x_header_rec.tp_attribute5 := p3_a66;
555 ddp_x_header_rec.tp_attribute6 := p3_a67;
556 ddp_x_header_rec.tp_attribute7 := p3_a68;
557 ddp_x_header_rec.tp_attribute8 := p3_a69;
558 ddp_x_header_rec.tp_attribute9 := p3_a70;
559 ddp_x_header_rec.tp_attribute10 := p3_a71;
560 ddp_x_header_rec.tp_attribute11 := p3_a72;
561 ddp_x_header_rec.tp_attribute12 := p3_a73;
562 ddp_x_header_rec.tp_attribute13 := p3_a74;
563 ddp_x_header_rec.tp_attribute14 := p3_a75;
564 ddp_x_header_rec.tp_attribute15 := p3_a76;
565 ddp_x_header_rec.header_id := rosetta_g_miss_num_map(p3_a77);
566 ddp_x_header_rec.invoice_to_contact_id := rosetta_g_miss_num_map(p3_a78);
567 ddp_x_header_rec.invoice_to_org_id := rosetta_g_miss_num_map(p3_a79);
568 ddp_x_header_rec.invoicing_rule_id := rosetta_g_miss_num_map(p3_a80);
569 ddp_x_header_rec.last_updated_by := rosetta_g_miss_num_map(p3_a81);
570 ddp_x_header_rec.last_update_date := rosetta_g_miss_date_in_map(p3_a82);
571 ddp_x_header_rec.last_update_login := rosetta_g_miss_num_map(p3_a83);
572 ddp_x_header_rec.latest_schedule_limit := rosetta_g_miss_num_map(p3_a84);
573 ddp_x_header_rec.open_flag := p3_a85;
574 ddp_x_header_rec.order_category_code := p3_a86;
575 ddp_x_header_rec.ordered_date := rosetta_g_miss_date_in_map(p3_a87);
576 ddp_x_header_rec.order_date_type_code := p3_a88;
577 ddp_x_header_rec.order_number := rosetta_g_miss_num_map(p3_a89);
578 ddp_x_header_rec.order_source_id := rosetta_g_miss_num_map(p3_a90);
579 ddp_x_header_rec.order_type_id := rosetta_g_miss_num_map(p3_a91);
580 ddp_x_header_rec.org_id := rosetta_g_miss_num_map(p3_a92);
581 ddp_x_header_rec.orig_sys_document_ref := p3_a93;
582 ddp_x_header_rec.partial_shipments_allowed := p3_a94;
583 ddp_x_header_rec.payment_term_id := rosetta_g_miss_num_map(p3_a95);
584 ddp_x_header_rec.price_list_id := rosetta_g_miss_num_map(p3_a96);
585 ddp_x_header_rec.price_request_code := p3_a97;
586 ddp_x_header_rec.pricing_date := rosetta_g_miss_date_in_map(p3_a98);
587 ddp_x_header_rec.program_application_id := rosetta_g_miss_num_map(p3_a99);
588 ddp_x_header_rec.program_id := rosetta_g_miss_num_map(p3_a100);
589 ddp_x_header_rec.program_update_date := rosetta_g_miss_date_in_map(p3_a101);
590 ddp_x_header_rec.request_date := rosetta_g_miss_date_in_map(p3_a102);
591 ddp_x_header_rec.request_id := rosetta_g_miss_num_map(p3_a103);
592 ddp_x_header_rec.return_reason_code := p3_a104;
593 ddp_x_header_rec.salesrep_id := rosetta_g_miss_num_map(p3_a105);
594 ddp_x_header_rec.sales_channel_code := p3_a106;
595 ddp_x_header_rec.shipment_priority_code := p3_a107;
596 ddp_x_header_rec.shipping_method_code := p3_a108;
597 ddp_x_header_rec.ship_from_org_id := rosetta_g_miss_num_map(p3_a109);
598 ddp_x_header_rec.ship_tolerance_above := rosetta_g_miss_num_map(p3_a110);
599 ddp_x_header_rec.ship_tolerance_below := rosetta_g_miss_num_map(p3_a111);
600 ddp_x_header_rec.ship_to_contact_id := rosetta_g_miss_num_map(p3_a112);
601 ddp_x_header_rec.ship_to_org_id := rosetta_g_miss_num_map(p3_a113);
602 ddp_x_header_rec.sold_from_org_id := rosetta_g_miss_num_map(p3_a114);
603 ddp_x_header_rec.sold_to_contact_id := rosetta_g_miss_num_map(p3_a115);
604 ddp_x_header_rec.sold_to_org_id := rosetta_g_miss_num_map(p3_a116);
605 ddp_x_header_rec.sold_to_phone_id := rosetta_g_miss_num_map(p3_a117);
606 ddp_x_header_rec.source_document_id := rosetta_g_miss_num_map(p3_a118);
607 ddp_x_header_rec.source_document_type_id := rosetta_g_miss_num_map(p3_a119);
608 ddp_x_header_rec.tax_exempt_flag := p3_a120;
609 ddp_x_header_rec.tax_exempt_number := p3_a121;
610 ddp_x_header_rec.tax_exempt_reason_code := p3_a122;
611 ddp_x_header_rec.tax_point_code := p3_a123;
612 ddp_x_header_rec.transactional_curr_code := p3_a124;
613 ddp_x_header_rec.version_number := rosetta_g_miss_num_map(p3_a125);
614 ddp_x_header_rec.return_status := p3_a126;
615 ddp_x_header_rec.db_flag := p3_a127;
616 ddp_x_header_rec.operation := p3_a128;
617 ddp_x_header_rec.first_ack_code := p3_a129;
618 ddp_x_header_rec.first_ack_date := rosetta_g_miss_date_in_map(p3_a130);
619 ddp_x_header_rec.last_ack_code := p3_a131;
620 ddp_x_header_rec.last_ack_date := rosetta_g_miss_date_in_map(p3_a132);
621 ddp_x_header_rec.change_reason := p3_a133;
622 ddp_x_header_rec.change_comments := p3_a134;
623 ddp_x_header_rec.change_sequence := p3_a135;
624 ddp_x_header_rec.change_request_code := p3_a136;
625 ddp_x_header_rec.ready_flag := p3_a137;
626 ddp_x_header_rec.status_flag := p3_a138;
627 ddp_x_header_rec.force_apply_flag := p3_a139;
628 ddp_x_header_rec.drop_ship_flag := p3_a140;
629 ddp_x_header_rec.customer_payment_term_id := rosetta_g_miss_num_map(p3_a141);
630 ddp_x_header_rec.payment_type_code := p3_a142;
631 ddp_x_header_rec.payment_amount := rosetta_g_miss_num_map(p3_a143);
632 ddp_x_header_rec.check_number := p3_a144;
633 ddp_x_header_rec.credit_card_code := p3_a145;
634 ddp_x_header_rec.credit_card_holder_name := p3_a146;
635 ddp_x_header_rec.credit_card_number := p3_a147;
636 ddp_x_header_rec.credit_card_expiration_date := rosetta_g_miss_date_in_map(p3_a148);
637 ddp_x_header_rec.credit_card_approval_code := p3_a149;
638 ddp_x_header_rec.credit_card_approval_date := rosetta_g_miss_date_in_map(p3_a150);
639 ddp_x_header_rec.shipping_instructions := p3_a151;
640 ddp_x_header_rec.packing_instructions := p3_a152;
641 ddp_x_header_rec.flow_status_code := p3_a153;
642 ddp_x_header_rec.booked_date := rosetta_g_miss_date_in_map(p3_a154);
643 ddp_x_header_rec.marketing_source_code_id := rosetta_g_miss_num_map(p3_a155);
644 ddp_x_header_rec.upgraded_flag := p3_a156;
645 ddp_x_header_rec.lock_control := rosetta_g_miss_num_map(p3_a157);
646 ddp_x_header_rec.ship_to_edi_location_code := p3_a158;
647 ddp_x_header_rec.sold_to_edi_location_code := p3_a159;
648 ddp_x_header_rec.bill_to_edi_location_code := p3_a160;
649 ddp_x_header_rec.ship_from_edi_location_code := p3_a161;
650 ddp_x_header_rec.ship_from_address_id := rosetta_g_miss_num_map(p3_a162);
651 ddp_x_header_rec.sold_to_address_id := rosetta_g_miss_num_map(p3_a163);
652 ddp_x_header_rec.ship_to_address_id := rosetta_g_miss_num_map(p3_a164);
653 ddp_x_header_rec.invoice_address_id := rosetta_g_miss_num_map(p3_a165);
654 ddp_x_header_rec.ship_to_address_code := p3_a166;
655 ddp_x_header_rec.xml_message_id := rosetta_g_miss_num_map(p3_a167);
656 ddp_x_header_rec.ship_to_customer_id := rosetta_g_miss_num_map(p3_a168);
657 ddp_x_header_rec.invoice_to_customer_id := rosetta_g_miss_num_map(p3_a169);
658 ddp_x_header_rec.deliver_to_customer_id := rosetta_g_miss_num_map(p3_a170);
659 ddp_x_header_rec.accounting_rule_duration := rosetta_g_miss_num_map(p3_a171);
660 ddp_x_header_rec.xml_transaction_type_code := p3_a172;
661 ddp_x_header_rec.blanket_number := rosetta_g_miss_num_map(p3_a173);
662 ddp_x_header_rec.line_set_name := p3_a174;
663 ddp_x_header_rec.fulfillment_set_name := p3_a175;
664 ddp_x_header_rec.default_fulfillment_set := p3_a176;
665
666 ddp_x_old_header_rec.accounting_rule_id := rosetta_g_miss_num_map(p4_a0);
667 ddp_x_old_header_rec.agreement_id := rosetta_g_miss_num_map(p4_a1);
668 ddp_x_old_header_rec.attribute1 := p4_a2;
669 ddp_x_old_header_rec.attribute10 := p4_a3;
670 ddp_x_old_header_rec.attribute11 := p4_a4;
671 ddp_x_old_header_rec.attribute12 := p4_a5;
672 ddp_x_old_header_rec.attribute13 := p4_a6;
673 ddp_x_old_header_rec.attribute14 := p4_a7;
674 ddp_x_old_header_rec.attribute15 := p4_a8;
675 ddp_x_old_header_rec.attribute16 := p4_a9;
676 ddp_x_old_header_rec.attribute17 := p4_a10;
677 ddp_x_old_header_rec.attribute18 := p4_a11;
678 ddp_x_old_header_rec.attribute19 := p4_a12;
679 ddp_x_old_header_rec.attribute2 := p4_a13;
680 ddp_x_old_header_rec.attribute20 := p4_a14;
681 ddp_x_old_header_rec.attribute3 := p4_a15;
682 ddp_x_old_header_rec.attribute4 := p4_a16;
683 ddp_x_old_header_rec.attribute5 := p4_a17;
684 ddp_x_old_header_rec.attribute6 := p4_a18;
685 ddp_x_old_header_rec.attribute7 := p4_a19;
686 ddp_x_old_header_rec.attribute8 := p4_a20;
687 ddp_x_old_header_rec.attribute9 := p4_a21;
688 ddp_x_old_header_rec.booked_flag := p4_a22;
689 ddp_x_old_header_rec.cancelled_flag := p4_a23;
690 ddp_x_old_header_rec.context := p4_a24;
691 ddp_x_old_header_rec.conversion_rate := rosetta_g_miss_num_map(p4_a25);
692 ddp_x_old_header_rec.conversion_rate_date := rosetta_g_miss_date_in_map(p4_a26);
693 ddp_x_old_header_rec.conversion_type_code := p4_a27;
694 ddp_x_old_header_rec.customer_preference_set_code := p4_a28;
695 ddp_x_old_header_rec.created_by := rosetta_g_miss_num_map(p4_a29);
696 ddp_x_old_header_rec.creation_date := rosetta_g_miss_date_in_map(p4_a30);
697 ddp_x_old_header_rec.cust_po_number := p4_a31;
698 ddp_x_old_header_rec.deliver_to_contact_id := rosetta_g_miss_num_map(p4_a32);
699 ddp_x_old_header_rec.deliver_to_org_id := rosetta_g_miss_num_map(p4_a33);
700 ddp_x_old_header_rec.demand_class_code := p4_a34;
701 ddp_x_old_header_rec.earliest_schedule_limit := rosetta_g_miss_num_map(p4_a35);
702 ddp_x_old_header_rec.expiration_date := rosetta_g_miss_date_in_map(p4_a36);
703 ddp_x_old_header_rec.fob_point_code := p4_a37;
704 ddp_x_old_header_rec.freight_carrier_code := p4_a38;
705 ddp_x_old_header_rec.freight_terms_code := p4_a39;
706 ddp_x_old_header_rec.global_attribute1 := p4_a40;
707 ddp_x_old_header_rec.global_attribute10 := p4_a41;
708 ddp_x_old_header_rec.global_attribute11 := p4_a42;
709 ddp_x_old_header_rec.global_attribute12 := p4_a43;
710 ddp_x_old_header_rec.global_attribute13 := p4_a44;
711 ddp_x_old_header_rec.global_attribute14 := p4_a45;
712 ddp_x_old_header_rec.global_attribute15 := p4_a46;
713 ddp_x_old_header_rec.global_attribute16 := p4_a47;
714 ddp_x_old_header_rec.global_attribute17 := p4_a48;
715 ddp_x_old_header_rec.global_attribute18 := p4_a49;
716 ddp_x_old_header_rec.global_attribute19 := p4_a50;
717 ddp_x_old_header_rec.global_attribute2 := p4_a51;
718 ddp_x_old_header_rec.global_attribute20 := p4_a52;
719 ddp_x_old_header_rec.global_attribute3 := p4_a53;
720 ddp_x_old_header_rec.global_attribute4 := p4_a54;
721 ddp_x_old_header_rec.global_attribute5 := p4_a55;
722 ddp_x_old_header_rec.global_attribute6 := p4_a56;
723 ddp_x_old_header_rec.global_attribute7 := p4_a57;
724 ddp_x_old_header_rec.global_attribute8 := p4_a58;
725 ddp_x_old_header_rec.global_attribute9 := p4_a59;
726 ddp_x_old_header_rec.global_attribute_category := p4_a60;
727 ddp_x_old_header_rec.tp_context := p4_a61;
728 ddp_x_old_header_rec.tp_attribute1 := p4_a62;
729 ddp_x_old_header_rec.tp_attribute2 := p4_a63;
730 ddp_x_old_header_rec.tp_attribute3 := p4_a64;
731 ddp_x_old_header_rec.tp_attribute4 := p4_a65;
732 ddp_x_old_header_rec.tp_attribute5 := p4_a66;
733 ddp_x_old_header_rec.tp_attribute6 := p4_a67;
734 ddp_x_old_header_rec.tp_attribute7 := p4_a68;
735 ddp_x_old_header_rec.tp_attribute8 := p4_a69;
736 ddp_x_old_header_rec.tp_attribute9 := p4_a70;
737 ddp_x_old_header_rec.tp_attribute10 := p4_a71;
738 ddp_x_old_header_rec.tp_attribute11 := p4_a72;
739 ddp_x_old_header_rec.tp_attribute12 := p4_a73;
740 ddp_x_old_header_rec.tp_attribute13 := p4_a74;
741 ddp_x_old_header_rec.tp_attribute14 := p4_a75;
742 ddp_x_old_header_rec.tp_attribute15 := p4_a76;
743 ddp_x_old_header_rec.header_id := rosetta_g_miss_num_map(p4_a77);
744 ddp_x_old_header_rec.invoice_to_contact_id := rosetta_g_miss_num_map(p4_a78);
745 ddp_x_old_header_rec.invoice_to_org_id := rosetta_g_miss_num_map(p4_a79);
746 ddp_x_old_header_rec.invoicing_rule_id := rosetta_g_miss_num_map(p4_a80);
747 ddp_x_old_header_rec.last_updated_by := rosetta_g_miss_num_map(p4_a81);
748 ddp_x_old_header_rec.last_update_date := rosetta_g_miss_date_in_map(p4_a82);
749 ddp_x_old_header_rec.last_update_login := rosetta_g_miss_num_map(p4_a83);
750 ddp_x_old_header_rec.latest_schedule_limit := rosetta_g_miss_num_map(p4_a84);
751 ddp_x_old_header_rec.open_flag := p4_a85;
752 ddp_x_old_header_rec.order_category_code := p4_a86;
753 ddp_x_old_header_rec.ordered_date := rosetta_g_miss_date_in_map(p4_a87);
754 ddp_x_old_header_rec.order_date_type_code := p4_a88;
755 ddp_x_old_header_rec.order_number := rosetta_g_miss_num_map(p4_a89);
756 ddp_x_old_header_rec.order_source_id := rosetta_g_miss_num_map(p4_a90);
757 ddp_x_old_header_rec.order_type_id := rosetta_g_miss_num_map(p4_a91);
758 ddp_x_old_header_rec.org_id := rosetta_g_miss_num_map(p4_a92);
759 ddp_x_old_header_rec.orig_sys_document_ref := p4_a93;
760 ddp_x_old_header_rec.partial_shipments_allowed := p4_a94;
761 ddp_x_old_header_rec.payment_term_id := rosetta_g_miss_num_map(p4_a95);
762 ddp_x_old_header_rec.price_list_id := rosetta_g_miss_num_map(p4_a96);
763 ddp_x_old_header_rec.price_request_code := p4_a97;
764 ddp_x_old_header_rec.pricing_date := rosetta_g_miss_date_in_map(p4_a98);
765 ddp_x_old_header_rec.program_application_id := rosetta_g_miss_num_map(p4_a99);
766 ddp_x_old_header_rec.program_id := rosetta_g_miss_num_map(p4_a100);
767 ddp_x_old_header_rec.program_update_date := rosetta_g_miss_date_in_map(p4_a101);
768 ddp_x_old_header_rec.request_date := rosetta_g_miss_date_in_map(p4_a102);
769 ddp_x_old_header_rec.request_id := rosetta_g_miss_num_map(p4_a103);
770 ddp_x_old_header_rec.return_reason_code := p4_a104;
771 ddp_x_old_header_rec.salesrep_id := rosetta_g_miss_num_map(p4_a105);
772 ddp_x_old_header_rec.sales_channel_code := p4_a106;
773 ddp_x_old_header_rec.shipment_priority_code := p4_a107;
774 ddp_x_old_header_rec.shipping_method_code := p4_a108;
775 ddp_x_old_header_rec.ship_from_org_id := rosetta_g_miss_num_map(p4_a109);
776 ddp_x_old_header_rec.ship_tolerance_above := rosetta_g_miss_num_map(p4_a110);
777 ddp_x_old_header_rec.ship_tolerance_below := rosetta_g_miss_num_map(p4_a111);
778 ddp_x_old_header_rec.ship_to_contact_id := rosetta_g_miss_num_map(p4_a112);
779 ddp_x_old_header_rec.ship_to_org_id := rosetta_g_miss_num_map(p4_a113);
780 ddp_x_old_header_rec.sold_from_org_id := rosetta_g_miss_num_map(p4_a114);
781 ddp_x_old_header_rec.sold_to_contact_id := rosetta_g_miss_num_map(p4_a115);
782 ddp_x_old_header_rec.sold_to_org_id := rosetta_g_miss_num_map(p4_a116);
783 ddp_x_old_header_rec.sold_to_phone_id := rosetta_g_miss_num_map(p4_a117);
784 ddp_x_old_header_rec.source_document_id := rosetta_g_miss_num_map(p4_a118);
785 ddp_x_old_header_rec.source_document_type_id := rosetta_g_miss_num_map(p4_a119);
786 ddp_x_old_header_rec.tax_exempt_flag := p4_a120;
787 ddp_x_old_header_rec.tax_exempt_number := p4_a121;
788 ddp_x_old_header_rec.tax_exempt_reason_code := p4_a122;
789 ddp_x_old_header_rec.tax_point_code := p4_a123;
790 ddp_x_old_header_rec.transactional_curr_code := p4_a124;
791 ddp_x_old_header_rec.version_number := rosetta_g_miss_num_map(p4_a125);
792 ddp_x_old_header_rec.return_status := p4_a126;
793 ddp_x_old_header_rec.db_flag := p4_a127;
794 ddp_x_old_header_rec.operation := p4_a128;
795 ddp_x_old_header_rec.first_ack_code := p4_a129;
796 ddp_x_old_header_rec.first_ack_date := rosetta_g_miss_date_in_map(p4_a130);
797 ddp_x_old_header_rec.last_ack_code := p4_a131;
798 ddp_x_old_header_rec.last_ack_date := rosetta_g_miss_date_in_map(p4_a132);
799 ddp_x_old_header_rec.change_reason := p4_a133;
800 ddp_x_old_header_rec.change_comments := p4_a134;
801 ddp_x_old_header_rec.change_sequence := p4_a135;
802 ddp_x_old_header_rec.change_request_code := p4_a136;
803 ddp_x_old_header_rec.ready_flag := p4_a137;
804 ddp_x_old_header_rec.status_flag := p4_a138;
805 ddp_x_old_header_rec.force_apply_flag := p4_a139;
806 ddp_x_old_header_rec.drop_ship_flag := p4_a140;
807 ddp_x_old_header_rec.customer_payment_term_id := rosetta_g_miss_num_map(p4_a141);
808 ddp_x_old_header_rec.payment_type_code := p4_a142;
809 ddp_x_old_header_rec.payment_amount := rosetta_g_miss_num_map(p4_a143);
810 ddp_x_old_header_rec.check_number := p4_a144;
811 ddp_x_old_header_rec.credit_card_code := p4_a145;
812 ddp_x_old_header_rec.credit_card_holder_name := p4_a146;
813 ddp_x_old_header_rec.credit_card_number := p4_a147;
814 ddp_x_old_header_rec.credit_card_expiration_date := rosetta_g_miss_date_in_map(p4_a148);
815 ddp_x_old_header_rec.credit_card_approval_code := p4_a149;
816 ddp_x_old_header_rec.credit_card_approval_date := rosetta_g_miss_date_in_map(p4_a150);
817 ddp_x_old_header_rec.shipping_instructions := p4_a151;
818 ddp_x_old_header_rec.packing_instructions := p4_a152;
819 ddp_x_old_header_rec.flow_status_code := p4_a153;
820 ddp_x_old_header_rec.booked_date := rosetta_g_miss_date_in_map(p4_a154);
821 ddp_x_old_header_rec.marketing_source_code_id := rosetta_g_miss_num_map(p4_a155);
822 ddp_x_old_header_rec.upgraded_flag := p4_a156;
823 ddp_x_old_header_rec.lock_control := rosetta_g_miss_num_map(p4_a157);
824 ddp_x_old_header_rec.ship_to_edi_location_code := p4_a158;
825 ddp_x_old_header_rec.sold_to_edi_location_code := p4_a159;
826 ddp_x_old_header_rec.bill_to_edi_location_code := p4_a160;
827 ddp_x_old_header_rec.ship_from_edi_location_code := p4_a161;
828 ddp_x_old_header_rec.ship_from_address_id := rosetta_g_miss_num_map(p4_a162);
829 ddp_x_old_header_rec.sold_to_address_id := rosetta_g_miss_num_map(p4_a163);
830 ddp_x_old_header_rec.ship_to_address_id := rosetta_g_miss_num_map(p4_a164);
831 ddp_x_old_header_rec.invoice_address_id := rosetta_g_miss_num_map(p4_a165);
832 ddp_x_old_header_rec.ship_to_address_code := p4_a166;
833 ddp_x_old_header_rec.xml_message_id := rosetta_g_miss_num_map(p4_a167);
834 ddp_x_old_header_rec.ship_to_customer_id := rosetta_g_miss_num_map(p4_a168);
835 ddp_x_old_header_rec.invoice_to_customer_id := rosetta_g_miss_num_map(p4_a169);
836 ddp_x_old_header_rec.deliver_to_customer_id := rosetta_g_miss_num_map(p4_a170);
837 ddp_x_old_header_rec.accounting_rule_duration := rosetta_g_miss_num_map(p4_a171);
838 ddp_x_old_header_rec.xml_transaction_type_code := p4_a172;
839 ddp_x_old_header_rec.blanket_number := rosetta_g_miss_num_map(p4_a173);
840 ddp_x_old_header_rec.line_set_name := p4_a174;
841 ddp_x_old_header_rec.fulfillment_set_name := p4_a175;
842 ddp_x_old_header_rec.default_fulfillment_set := p4_a176;
843 ddp_x_old_header_rec.transaction_phase_code:='F';
844 ddp_x_header_rec.transaction_phase_code:='F';
845
846
847 oe_debug_pub.g_debug_level := FND_PROFILE.VALUE('ONT_DEBUG_LEVEL');
848 l_fname := oe_Debug_pub.set_debug_mode('FILE');
849
850 oe_debug_pub.debug_on;
851
852
853 -- here's the delegated call to the old PL/SQL routine
854 oe_order_pvt.header(p_init_msg_list,
855 p_validation_level,
856 ddp_control_rec,
857 ddp_x_header_rec,
858 ddp_x_old_header_rec,
859 x_return_status);
860
861 -- copy data back from the local variables to OUT or IN-OUT args, if any
862
863
864
865 p3_a0 := rosetta_g_miss_num_map(ddp_x_header_rec.accounting_rule_id);
866 p3_a1 := rosetta_g_miss_num_map(ddp_x_header_rec.agreement_id);
867 p3_a2 := ddp_x_header_rec.attribute1;
868 p3_a3 := ddp_x_header_rec.attribute10;
869 p3_a4 := ddp_x_header_rec.attribute11;
870 p3_a5 := ddp_x_header_rec.attribute12;
871 p3_a6 := ddp_x_header_rec.attribute13;
872 p3_a7 := ddp_x_header_rec.attribute14;
873 p3_a8 := ddp_x_header_rec.attribute15;
874 p3_a9 := ddp_x_header_rec.attribute16;
875 p3_a10 := ddp_x_header_rec.attribute17;
876 p3_a11 := ddp_x_header_rec.attribute18;
877 p3_a12 := ddp_x_header_rec.attribute19;
878 p3_a13 := ddp_x_header_rec.attribute2;
879 p3_a14 := ddp_x_header_rec.attribute20;
880 p3_a15 := ddp_x_header_rec.attribute3;
881 p3_a16 := ddp_x_header_rec.attribute4;
882 p3_a17 := ddp_x_header_rec.attribute5;
883 p3_a18 := ddp_x_header_rec.attribute6;
884 p3_a19 := ddp_x_header_rec.attribute7;
885 p3_a20 := ddp_x_header_rec.attribute8;
886 p3_a21 := ddp_x_header_rec.attribute9;
887 p3_a22 := ddp_x_header_rec.booked_flag;
888 p3_a23 := ddp_x_header_rec.cancelled_flag;
889 p3_a24 := ddp_x_header_rec.context;
890 p3_a25 := rosetta_g_miss_num_map(ddp_x_header_rec.conversion_rate);
891 p3_a26 := ddp_x_header_rec.conversion_rate_date;
892 p3_a27 := ddp_x_header_rec.conversion_type_code;
893 p3_a28 := ddp_x_header_rec.customer_preference_set_code;
894 p3_a29 := rosetta_g_miss_num_map(ddp_x_header_rec.created_by);
895 p3_a30 := ddp_x_header_rec.creation_date;
896 p3_a31 := ddp_x_header_rec.cust_po_number;
897 p3_a32 := rosetta_g_miss_num_map(ddp_x_header_rec.deliver_to_contact_id);
898 p3_a33 := rosetta_g_miss_num_map(ddp_x_header_rec.deliver_to_org_id);
899 p3_a34 := ddp_x_header_rec.demand_class_code;
900 p3_a35 := rosetta_g_miss_num_map(ddp_x_header_rec.earliest_schedule_limit);
901 p3_a36 := ddp_x_header_rec.expiration_date;
902 p3_a37 := ddp_x_header_rec.fob_point_code;
903 p3_a38 := ddp_x_header_rec.freight_carrier_code;
904 p3_a39 := ddp_x_header_rec.freight_terms_code;
905 p3_a40 := ddp_x_header_rec.global_attribute1;
906 p3_a41 := ddp_x_header_rec.global_attribute10;
907 p3_a42 := ddp_x_header_rec.global_attribute11;
908 p3_a43 := ddp_x_header_rec.global_attribute12;
909 p3_a44 := ddp_x_header_rec.global_attribute13;
910 p3_a45 := ddp_x_header_rec.global_attribute14;
911 p3_a46 := ddp_x_header_rec.global_attribute15;
912 p3_a47 := ddp_x_header_rec.global_attribute16;
913 p3_a48 := ddp_x_header_rec.global_attribute17;
914 p3_a49 := ddp_x_header_rec.global_attribute18;
915 p3_a50 := ddp_x_header_rec.global_attribute19;
916 p3_a51 := ddp_x_header_rec.global_attribute2;
917 p3_a52 := ddp_x_header_rec.global_attribute20;
918 p3_a53 := ddp_x_header_rec.global_attribute3;
919 p3_a54 := ddp_x_header_rec.global_attribute4;
920 p3_a55 := ddp_x_header_rec.global_attribute5;
921 p3_a56 := ddp_x_header_rec.global_attribute6;
922 p3_a57 := ddp_x_header_rec.global_attribute7;
923 p3_a58 := ddp_x_header_rec.global_attribute8;
924 p3_a59 := ddp_x_header_rec.global_attribute9;
925 p3_a60 := ddp_x_header_rec.global_attribute_category;
926 p3_a61 := ddp_x_header_rec.tp_context;
927 p3_a62 := ddp_x_header_rec.tp_attribute1;
928 p3_a63 := ddp_x_header_rec.tp_attribute2;
929 p3_a64 := ddp_x_header_rec.tp_attribute3;
930 p3_a65 := ddp_x_header_rec.tp_attribute4;
931 p3_a66 := ddp_x_header_rec.tp_attribute5;
932 p3_a67 := ddp_x_header_rec.tp_attribute6;
933 p3_a68 := ddp_x_header_rec.tp_attribute7;
934 p3_a69 := ddp_x_header_rec.tp_attribute8;
935 p3_a70 := ddp_x_header_rec.tp_attribute9;
936 p3_a71 := ddp_x_header_rec.tp_attribute10;
937 p3_a72 := ddp_x_header_rec.tp_attribute11;
938 p3_a73 := ddp_x_header_rec.tp_attribute12;
939 p3_a74 := ddp_x_header_rec.tp_attribute13;
940 p3_a75 := ddp_x_header_rec.tp_attribute14;
941 p3_a76 := ddp_x_header_rec.tp_attribute15;
942 p3_a77 := rosetta_g_miss_num_map(ddp_x_header_rec.header_id);
943 p3_a78 := rosetta_g_miss_num_map(ddp_x_header_rec.invoice_to_contact_id);
944 p3_a79 := rosetta_g_miss_num_map(ddp_x_header_rec.invoice_to_org_id);
945 p3_a80 := rosetta_g_miss_num_map(ddp_x_header_rec.invoicing_rule_id);
946 p3_a81 := rosetta_g_miss_num_map(ddp_x_header_rec.last_updated_by);
947 p3_a82 := ddp_x_header_rec.last_update_date;
948 p3_a83 := rosetta_g_miss_num_map(ddp_x_header_rec.last_update_login);
949 p3_a84 := rosetta_g_miss_num_map(ddp_x_header_rec.latest_schedule_limit);
950 p3_a85 := ddp_x_header_rec.open_flag;
951 p3_a86 := ddp_x_header_rec.order_category_code;
952 p3_a87 := ddp_x_header_rec.ordered_date;
953 p3_a88 := ddp_x_header_rec.order_date_type_code;
954 p3_a89 := rosetta_g_miss_num_map(ddp_x_header_rec.order_number);
955 p3_a90 := rosetta_g_miss_num_map(ddp_x_header_rec.order_source_id);
956 p3_a91 := rosetta_g_miss_num_map(ddp_x_header_rec.order_type_id);
957 p3_a92 := rosetta_g_miss_num_map(ddp_x_header_rec.org_id);
958 p3_a93 := ddp_x_header_rec.orig_sys_document_ref;
959 p3_a94 := ddp_x_header_rec.partial_shipments_allowed;
960 p3_a95 := rosetta_g_miss_num_map(ddp_x_header_rec.payment_term_id);
961 p3_a96 := rosetta_g_miss_num_map(ddp_x_header_rec.price_list_id);
962 p3_a97 := ddp_x_header_rec.price_request_code;
963 p3_a98 := ddp_x_header_rec.pricing_date;
964 p3_a99 := rosetta_g_miss_num_map(ddp_x_header_rec.program_application_id);
965 p3_a100 := rosetta_g_miss_num_map(ddp_x_header_rec.program_id);
966 p3_a101 := ddp_x_header_rec.program_update_date;
967 p3_a102 := ddp_x_header_rec.request_date;
968 p3_a103 := rosetta_g_miss_num_map(ddp_x_header_rec.request_id);
969 p3_a104 := ddp_x_header_rec.return_reason_code;
970 p3_a105 := rosetta_g_miss_num_map(ddp_x_header_rec.salesrep_id);
971 p3_a106 := ddp_x_header_rec.sales_channel_code;
972 p3_a107 := ddp_x_header_rec.shipment_priority_code;
973 p3_a108 := ddp_x_header_rec.shipping_method_code;
974 p3_a109 := rosetta_g_miss_num_map(ddp_x_header_rec.ship_from_org_id);
975 p3_a110 := rosetta_g_miss_num_map(ddp_x_header_rec.ship_tolerance_above);
976 p3_a111 := rosetta_g_miss_num_map(ddp_x_header_rec.ship_tolerance_below);
977 p3_a112 := rosetta_g_miss_num_map(ddp_x_header_rec.ship_to_contact_id);
978 p3_a113 := rosetta_g_miss_num_map(ddp_x_header_rec.ship_to_org_id);
979 p3_a114 := rosetta_g_miss_num_map(ddp_x_header_rec.sold_from_org_id);
980 p3_a115 := rosetta_g_miss_num_map(ddp_x_header_rec.sold_to_contact_id);
981 p3_a116 := rosetta_g_miss_num_map(ddp_x_header_rec.sold_to_org_id);
982 p3_a117 := rosetta_g_miss_num_map(ddp_x_header_rec.sold_to_phone_id);
983 p3_a118 := rosetta_g_miss_num_map(ddp_x_header_rec.source_document_id);
984 p3_a119 := rosetta_g_miss_num_map(ddp_x_header_rec.source_document_type_id);
985 p3_a120 := ddp_x_header_rec.tax_exempt_flag;
986 p3_a121 := ddp_x_header_rec.tax_exempt_number;
987 p3_a122 := ddp_x_header_rec.tax_exempt_reason_code;
988 p3_a123 := ddp_x_header_rec.tax_point_code;
989 p3_a124 := ddp_x_header_rec.transactional_curr_code;
990 p3_a125 := rosetta_g_miss_num_map(ddp_x_header_rec.version_number);
991 p3_a126 := ddp_x_header_rec.return_status;
992 p3_a127 := ddp_x_header_rec.db_flag;
993 p3_a128 := ddp_x_header_rec.operation;
994 p3_a129 := ddp_x_header_rec.first_ack_code;
995 p3_a130 := ddp_x_header_rec.first_ack_date;
996 p3_a131 := ddp_x_header_rec.last_ack_code;
997 p3_a132 := ddp_x_header_rec.last_ack_date;
998 p3_a133 := ddp_x_header_rec.change_reason;
999 p3_a134 := ddp_x_header_rec.change_comments;
1000 p3_a135 := ddp_x_header_rec.change_sequence;
1001 p3_a136 := ddp_x_header_rec.change_request_code;
1002 p3_a137 := ddp_x_header_rec.ready_flag;
1003 p3_a138 := ddp_x_header_rec.status_flag;
1004 p3_a139 := ddp_x_header_rec.force_apply_flag;
1005 p3_a140 := ddp_x_header_rec.drop_ship_flag;
1006 p3_a141 := rosetta_g_miss_num_map(ddp_x_header_rec.customer_payment_term_id);
1007 p3_a142 := ddp_x_header_rec.payment_type_code;
1008 p3_a143 := rosetta_g_miss_num_map(ddp_x_header_rec.payment_amount);
1009 p3_a144 := ddp_x_header_rec.check_number;
1010 p3_a145 := ddp_x_header_rec.credit_card_code;
1011 p3_a146 := ddp_x_header_rec.credit_card_holder_name;
1012 p3_a147 := ddp_x_header_rec.credit_card_number;
1013 p3_a148 := ddp_x_header_rec.credit_card_expiration_date;
1014 p3_a149 := ddp_x_header_rec.credit_card_approval_code;
1015 p3_a150 := ddp_x_header_rec.credit_card_approval_date;
1016 p3_a151 := ddp_x_header_rec.shipping_instructions;
1017 p3_a152 := ddp_x_header_rec.packing_instructions;
1018 p3_a153 := ddp_x_header_rec.flow_status_code;
1019 p3_a154 := ddp_x_header_rec.booked_date;
1020 p3_a155 := rosetta_g_miss_num_map(ddp_x_header_rec.marketing_source_code_id);
1021 p3_a156 := ddp_x_header_rec.upgraded_flag;
1022 p3_a157 := rosetta_g_miss_num_map(ddp_x_header_rec.lock_control);
1023 p3_a158 := ddp_x_header_rec.ship_to_edi_location_code;
1024 p3_a159 := ddp_x_header_rec.sold_to_edi_location_code;
1025 p3_a160 := ddp_x_header_rec.bill_to_edi_location_code;
1026 p3_a161 := ddp_x_header_rec.ship_from_edi_location_code;
1027 p3_a162 := rosetta_g_miss_num_map(ddp_x_header_rec.ship_from_address_id);
1028 p3_a163 := rosetta_g_miss_num_map(ddp_x_header_rec.sold_to_address_id);
1029 p3_a164 := rosetta_g_miss_num_map(ddp_x_header_rec.ship_to_address_id);
1030 p3_a165 := rosetta_g_miss_num_map(ddp_x_header_rec.invoice_address_id);
1031 p3_a166 := ddp_x_header_rec.ship_to_address_code;
1032 p3_a167 := rosetta_g_miss_num_map(ddp_x_header_rec.xml_message_id);
1033 p3_a168 := rosetta_g_miss_num_map(ddp_x_header_rec.ship_to_customer_id);
1034 p3_a169 := rosetta_g_miss_num_map(ddp_x_header_rec.invoice_to_customer_id);
1035 p3_a170 := rosetta_g_miss_num_map(ddp_x_header_rec.deliver_to_customer_id);
1036 p3_a171 := rosetta_g_miss_num_map(ddp_x_header_rec.accounting_rule_duration);
1037 p3_a172 := ddp_x_header_rec.xml_transaction_type_code;
1038 p3_a173 := rosetta_g_miss_num_map(ddp_x_header_rec.blanket_number);
1039 p3_a174 := ddp_x_header_rec.line_set_name;
1040 p3_a175 := ddp_x_header_rec.fulfillment_set_name;
1041 p3_a176 := ddp_x_header_rec.default_fulfillment_set;
1042
1043 p4_a0 := rosetta_g_miss_num_map(ddp_x_old_header_rec.accounting_rule_id);
1044 p4_a1 := rosetta_g_miss_num_map(ddp_x_old_header_rec.agreement_id);
1045 p4_a2 := ddp_x_old_header_rec.attribute1;
1046 p4_a3 := ddp_x_old_header_rec.attribute10;
1047 p4_a4 := ddp_x_old_header_rec.attribute11;
1048 p4_a5 := ddp_x_old_header_rec.attribute12;
1049 p4_a6 := ddp_x_old_header_rec.attribute13;
1050 p4_a7 := ddp_x_old_header_rec.attribute14;
1051 p4_a8 := ddp_x_old_header_rec.attribute15;
1052 p4_a9 := ddp_x_old_header_rec.attribute16;
1053 p4_a10 := ddp_x_old_header_rec.attribute17;
1054 p4_a11 := ddp_x_old_header_rec.attribute18;
1055 p4_a12 := ddp_x_old_header_rec.attribute19;
1056 p4_a13 := ddp_x_old_header_rec.attribute2;
1057 p4_a14 := ddp_x_old_header_rec.attribute20;
1058 p4_a15 := ddp_x_old_header_rec.attribute3;
1059 p4_a16 := ddp_x_old_header_rec.attribute4;
1060 p4_a17 := ddp_x_old_header_rec.attribute5;
1061 p4_a18 := ddp_x_old_header_rec.attribute6;
1062 p4_a19 := ddp_x_old_header_rec.attribute7;
1063 p4_a20 := ddp_x_old_header_rec.attribute8;
1064 p4_a21 := ddp_x_old_header_rec.attribute9;
1065 p4_a22 := ddp_x_old_header_rec.booked_flag;
1066 p4_a23 := ddp_x_old_header_rec.cancelled_flag;
1067 p4_a24 := ddp_x_old_header_rec.context;
1068 p4_a25 := rosetta_g_miss_num_map(ddp_x_old_header_rec.conversion_rate);
1069 p4_a26 := ddp_x_old_header_rec.conversion_rate_date;
1070 p4_a27 := ddp_x_old_header_rec.conversion_type_code;
1071 p4_a28 := ddp_x_old_header_rec.customer_preference_set_code;
1072 p4_a29 := rosetta_g_miss_num_map(ddp_x_old_header_rec.created_by);
1073 p4_a30 := ddp_x_old_header_rec.creation_date;
1074 p4_a31 := ddp_x_old_header_rec.cust_po_number;
1075 p4_a32 := rosetta_g_miss_num_map(ddp_x_old_header_rec.deliver_to_contact_id);
1076 p4_a33 := rosetta_g_miss_num_map(ddp_x_old_header_rec.deliver_to_org_id);
1077 p4_a34 := ddp_x_old_header_rec.demand_class_code;
1078 p4_a35 := rosetta_g_miss_num_map(ddp_x_old_header_rec.earliest_schedule_limit);
1079 p4_a36 := ddp_x_old_header_rec.expiration_date;
1080 p4_a37 := ddp_x_old_header_rec.fob_point_code;
1081 p4_a38 := ddp_x_old_header_rec.freight_carrier_code;
1082 p4_a39 := ddp_x_old_header_rec.freight_terms_code;
1083 p4_a40 := ddp_x_old_header_rec.global_attribute1;
1084 p4_a41 := ddp_x_old_header_rec.global_attribute10;
1085 p4_a42 := ddp_x_old_header_rec.global_attribute11;
1086 p4_a43 := ddp_x_old_header_rec.global_attribute12;
1087 p4_a44 := ddp_x_old_header_rec.global_attribute13;
1088 p4_a45 := ddp_x_old_header_rec.global_attribute14;
1089 p4_a46 := ddp_x_old_header_rec.global_attribute15;
1090 p4_a47 := ddp_x_old_header_rec.global_attribute16;
1091 p4_a48 := ddp_x_old_header_rec.global_attribute17;
1092 p4_a49 := ddp_x_old_header_rec.global_attribute18;
1093 p4_a50 := ddp_x_old_header_rec.global_attribute19;
1094 p4_a51 := ddp_x_old_header_rec.global_attribute2;
1095 p4_a52 := ddp_x_old_header_rec.global_attribute20;
1096 p4_a53 := ddp_x_old_header_rec.global_attribute3;
1097 p4_a54 := ddp_x_old_header_rec.global_attribute4;
1098 p4_a55 := ddp_x_old_header_rec.global_attribute5;
1099 p4_a56 := ddp_x_old_header_rec.global_attribute6;
1100 p4_a57 := ddp_x_old_header_rec.global_attribute7;
1101 p4_a58 := ddp_x_old_header_rec.global_attribute8;
1102 p4_a59 := ddp_x_old_header_rec.global_attribute9;
1103 p4_a60 := ddp_x_old_header_rec.global_attribute_category;
1104 p4_a61 := ddp_x_old_header_rec.tp_context;
1105 p4_a62 := ddp_x_old_header_rec.tp_attribute1;
1106 p4_a63 := ddp_x_old_header_rec.tp_attribute2;
1107 p4_a64 := ddp_x_old_header_rec.tp_attribute3;
1108 p4_a65 := ddp_x_old_header_rec.tp_attribute4;
1109 p4_a66 := ddp_x_old_header_rec.tp_attribute5;
1110 p4_a67 := ddp_x_old_header_rec.tp_attribute6;
1111 p4_a68 := ddp_x_old_header_rec.tp_attribute7;
1112 p4_a69 := ddp_x_old_header_rec.tp_attribute8;
1113 p4_a70 := ddp_x_old_header_rec.tp_attribute9;
1114 p4_a71 := ddp_x_old_header_rec.tp_attribute10;
1115 p4_a72 := ddp_x_old_header_rec.tp_attribute11;
1116 p4_a73 := ddp_x_old_header_rec.tp_attribute12;
1117 p4_a74 := ddp_x_old_header_rec.tp_attribute13;
1118 p4_a75 := ddp_x_old_header_rec.tp_attribute14;
1119 p4_a76 := ddp_x_old_header_rec.tp_attribute15;
1120 p4_a77 := rosetta_g_miss_num_map(ddp_x_old_header_rec.header_id);
1121 p4_a78 := rosetta_g_miss_num_map(ddp_x_old_header_rec.invoice_to_contact_id);
1122 p4_a79 := rosetta_g_miss_num_map(ddp_x_old_header_rec.invoice_to_org_id);
1123 p4_a80 := rosetta_g_miss_num_map(ddp_x_old_header_rec.invoicing_rule_id);
1124 p4_a81 := rosetta_g_miss_num_map(ddp_x_old_header_rec.last_updated_by);
1125 p4_a82 := ddp_x_old_header_rec.last_update_date;
1126 p4_a83 := rosetta_g_miss_num_map(ddp_x_old_header_rec.last_update_login);
1127 p4_a84 := rosetta_g_miss_num_map(ddp_x_old_header_rec.latest_schedule_limit);
1128 p4_a85 := ddp_x_old_header_rec.open_flag;
1129 p4_a86 := ddp_x_old_header_rec.order_category_code;
1130 p4_a87 := ddp_x_old_header_rec.ordered_date;
1131 p4_a88 := ddp_x_old_header_rec.order_date_type_code;
1132 p4_a89 := rosetta_g_miss_num_map(ddp_x_old_header_rec.order_number);
1133 p4_a90 := rosetta_g_miss_num_map(ddp_x_old_header_rec.order_source_id);
1134 p4_a91 := rosetta_g_miss_num_map(ddp_x_old_header_rec.order_type_id);
1135 p4_a92 := rosetta_g_miss_num_map(ddp_x_old_header_rec.org_id);
1136 p4_a93 := ddp_x_old_header_rec.orig_sys_document_ref;
1137 p4_a94 := ddp_x_old_header_rec.partial_shipments_allowed;
1138 p4_a95 := rosetta_g_miss_num_map(ddp_x_old_header_rec.payment_term_id);
1139 p4_a96 := rosetta_g_miss_num_map(ddp_x_old_header_rec.price_list_id);
1140 p4_a97 := ddp_x_old_header_rec.price_request_code;
1141 p4_a98 := ddp_x_old_header_rec.pricing_date;
1142 p4_a99 := rosetta_g_miss_num_map(ddp_x_old_header_rec.program_application_id);
1143 p4_a100 := rosetta_g_miss_num_map(ddp_x_old_header_rec.program_id);
1144 p4_a101 := ddp_x_old_header_rec.program_update_date;
1145 p4_a102 := ddp_x_old_header_rec.request_date;
1146 p4_a103 := rosetta_g_miss_num_map(ddp_x_old_header_rec.request_id);
1147 p4_a104 := ddp_x_old_header_rec.return_reason_code;
1148 p4_a105 := rosetta_g_miss_num_map(ddp_x_old_header_rec.salesrep_id);
1149 p4_a106 := ddp_x_old_header_rec.sales_channel_code;
1150 p4_a107 := ddp_x_old_header_rec.shipment_priority_code;
1151 p4_a108 := ddp_x_old_header_rec.shipping_method_code;
1152 p4_a109 := rosetta_g_miss_num_map(ddp_x_old_header_rec.ship_from_org_id);
1153 p4_a110 := rosetta_g_miss_num_map(ddp_x_old_header_rec.ship_tolerance_above);
1154 p4_a111 := rosetta_g_miss_num_map(ddp_x_old_header_rec.ship_tolerance_below);
1155 p4_a112 := rosetta_g_miss_num_map(ddp_x_old_header_rec.ship_to_contact_id);
1156 p4_a113 := rosetta_g_miss_num_map(ddp_x_old_header_rec.ship_to_org_id);
1157 p4_a114 := rosetta_g_miss_num_map(ddp_x_old_header_rec.sold_from_org_id);
1158 p4_a115 := rosetta_g_miss_num_map(ddp_x_old_header_rec.sold_to_contact_id);
1159 p4_a116 := rosetta_g_miss_num_map(ddp_x_old_header_rec.sold_to_org_id);
1160 p4_a117 := rosetta_g_miss_num_map(ddp_x_old_header_rec.sold_to_phone_id);
1161 p4_a118 := rosetta_g_miss_num_map(ddp_x_old_header_rec.source_document_id);
1162 p4_a119 := rosetta_g_miss_num_map(ddp_x_old_header_rec.source_document_type_id);
1163 p4_a120 := ddp_x_old_header_rec.tax_exempt_flag;
1164 p4_a121 := ddp_x_old_header_rec.tax_exempt_number;
1165 p4_a122 := ddp_x_old_header_rec.tax_exempt_reason_code;
1166 p4_a123 := ddp_x_old_header_rec.tax_point_code;
1167 p4_a124 := ddp_x_old_header_rec.transactional_curr_code;
1168 p4_a125 := rosetta_g_miss_num_map(ddp_x_old_header_rec.version_number);
1169 p4_a126 := ddp_x_old_header_rec.return_status;
1170 p4_a127 := ddp_x_old_header_rec.db_flag;
1171 p4_a128 := ddp_x_old_header_rec.operation;
1172 p4_a129 := ddp_x_old_header_rec.first_ack_code;
1173 p4_a130 := ddp_x_old_header_rec.first_ack_date;
1174 p4_a131 := ddp_x_old_header_rec.last_ack_code;
1175 p4_a132 := ddp_x_old_header_rec.last_ack_date;
1176 p4_a133 := ddp_x_old_header_rec.change_reason;
1177 p4_a134 := ddp_x_old_header_rec.change_comments;
1178 p4_a135 := ddp_x_old_header_rec.change_sequence;
1179 p4_a136 := ddp_x_old_header_rec.change_request_code;
1180 p4_a137 := ddp_x_old_header_rec.ready_flag;
1181 p4_a138 := ddp_x_old_header_rec.status_flag;
1182 p4_a139 := ddp_x_old_header_rec.force_apply_flag;
1183 p4_a140 := ddp_x_old_header_rec.drop_ship_flag;
1184 p4_a141 := rosetta_g_miss_num_map(ddp_x_old_header_rec.customer_payment_term_id);
1185 p4_a142 := ddp_x_old_header_rec.payment_type_code;
1186 p4_a143 := rosetta_g_miss_num_map(ddp_x_old_header_rec.payment_amount);
1187 p4_a144 := ddp_x_old_header_rec.check_number;
1188 p4_a145 := ddp_x_old_header_rec.credit_card_code;
1189 p4_a146 := ddp_x_old_header_rec.credit_card_holder_name;
1190 p4_a147 := ddp_x_old_header_rec.credit_card_number;
1191 p4_a148 := ddp_x_old_header_rec.credit_card_expiration_date;
1192 p4_a149 := ddp_x_old_header_rec.credit_card_approval_code;
1193 p4_a150 := ddp_x_old_header_rec.credit_card_approval_date;
1194 p4_a151 := ddp_x_old_header_rec.shipping_instructions;
1195 p4_a152 := ddp_x_old_header_rec.packing_instructions;
1196 p4_a153 := ddp_x_old_header_rec.flow_status_code;
1197 p4_a154 := ddp_x_old_header_rec.booked_date;
1198 p4_a155 := rosetta_g_miss_num_map(ddp_x_old_header_rec.marketing_source_code_id);
1199 p4_a156 := ddp_x_old_header_rec.upgraded_flag;
1200 p4_a157 := rosetta_g_miss_num_map(ddp_x_old_header_rec.lock_control);
1201 p4_a158 := ddp_x_old_header_rec.ship_to_edi_location_code;
1202 p4_a159 := ddp_x_old_header_rec.sold_to_edi_location_code;
1203 p4_a160 := ddp_x_old_header_rec.bill_to_edi_location_code;
1204 p4_a161 := ddp_x_old_header_rec.ship_from_edi_location_code;
1205 p4_a162 := rosetta_g_miss_num_map(ddp_x_old_header_rec.ship_from_address_id);
1206 p4_a163 := rosetta_g_miss_num_map(ddp_x_old_header_rec.sold_to_address_id);
1207 p4_a164 := rosetta_g_miss_num_map(ddp_x_old_header_rec.ship_to_address_id);
1208 p4_a165 := rosetta_g_miss_num_map(ddp_x_old_header_rec.invoice_address_id);
1209 p4_a166 := ddp_x_old_header_rec.ship_to_address_code;
1210 p4_a167 := rosetta_g_miss_num_map(ddp_x_old_header_rec.xml_message_id);
1211 p4_a168 := rosetta_g_miss_num_map(ddp_x_old_header_rec.ship_to_customer_id);
1212 p4_a169 := rosetta_g_miss_num_map(ddp_x_old_header_rec.invoice_to_customer_id);
1213 p4_a170 := rosetta_g_miss_num_map(ddp_x_old_header_rec.deliver_to_customer_id);
1214 p4_a171 := rosetta_g_miss_num_map(ddp_x_old_header_rec.accounting_rule_duration);
1215 p4_a172 := ddp_x_old_header_rec.xml_transaction_type_code;
1216 p4_a173 := rosetta_g_miss_num_map(ddp_x_old_header_rec.blanket_number);
1217 p4_a174 := ddp_x_old_header_rec.line_set_name;
1218 p4_a175 := ddp_x_old_header_rec.fulfillment_set_name;
1219 p4_a176 := ddp_x_old_header_rec.default_fulfillment_set;
1220
1221 end;
1222
1223 end oe_order_pvt_w;