[Home] [Help]
PACKAGE BODY: APPS.OZF_SALES_TRANSACTIONS_PVT_W
Source
1 package body ozf_sales_transactions_pvt_w as
2 /* $Header: ozfwstnb.pls 115.2 2004/04/07 13:41:08 sangara noship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy ozf_sales_transactions_pvt.sales_trans_tbl, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_DATE_TABLE
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_DATE_TABLE
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_VARCHAR2_TABLE_100
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_NUMBER_TABLE
13 , a10 JTF_DATE_TABLE
14 , a11 JTF_NUMBER_TABLE
15 , a12 JTF_VARCHAR2_TABLE_100
16 , a13 JTF_NUMBER_TABLE
17 , a14 JTF_NUMBER_TABLE
18 , a15 JTF_NUMBER_TABLE
19 , a16 JTF_NUMBER_TABLE
20 , a17 JTF_NUMBER_TABLE
21 , a18 JTF_NUMBER_TABLE
22 , a19 JTF_NUMBER_TABLE
23 , a20 JTF_NUMBER_TABLE
24 , a21 JTF_DATE_TABLE
25 , a22 JTF_NUMBER_TABLE
26 , a23 JTF_VARCHAR2_TABLE_100
27 , a24 JTF_NUMBER_TABLE
28 , a25 JTF_VARCHAR2_TABLE_100
29 , a26 JTF_NUMBER_TABLE
30 , a27 JTF_NUMBER_TABLE
31 , a28 JTF_VARCHAR2_TABLE_100
32 , a29 JTF_NUMBER_TABLE
33 , a30 JTF_VARCHAR2_TABLE_100
34 , a31 JTF_VARCHAR2_TABLE_100
35 , a32 JTF_NUMBER_TABLE
36 , a33 JTF_NUMBER_TABLE
37 , a34 JTF_NUMBER_TABLE
38 , a35 JTF_VARCHAR2_TABLE_100
39 , a36 JTF_VARCHAR2_TABLE_100
40 , a37 JTF_VARCHAR2_TABLE_100
41 , a38 JTF_VARCHAR2_TABLE_100
42 , a39 JTF_VARCHAR2_TABLE_300
43 , a40 JTF_VARCHAR2_TABLE_300
44 , a41 JTF_VARCHAR2_TABLE_300
45 , a42 JTF_VARCHAR2_TABLE_300
46 , a43 JTF_VARCHAR2_TABLE_300
47 , a44 JTF_VARCHAR2_TABLE_300
48 , a45 JTF_VARCHAR2_TABLE_300
49 , a46 JTF_VARCHAR2_TABLE_300
50 , a47 JTF_VARCHAR2_TABLE_300
51 , a48 JTF_VARCHAR2_TABLE_300
52 , a49 JTF_VARCHAR2_TABLE_300
53 , a50 JTF_VARCHAR2_TABLE_300
54 , a51 JTF_VARCHAR2_TABLE_300
55 , a52 JTF_VARCHAR2_TABLE_300
56 , a53 JTF_VARCHAR2_TABLE_300
57 , a54 JTF_NUMBER_TABLE
58 ) as
59 ddindx binary_integer; indx binary_integer;
60 begin
61 if a0 is not null and a0.count > 0 then
62 if a0.count > 0 then
63 indx := a0.first;
64 ddindx := 1;
65 while true loop
66 t(ddindx).sales_transaction_id := a0(indx);
67 t(ddindx).object_version_number := a1(indx);
68 t(ddindx).last_update_date := a2(indx);
69 t(ddindx).last_updated_by := a3(indx);
70 t(ddindx).creation_date := a4(indx);
71 t(ddindx).request_id := a5(indx);
72 t(ddindx).created_by := a6(indx);
73 t(ddindx).created_from := a7(indx);
74 t(ddindx).last_update_login := a8(indx);
75 t(ddindx).program_application_id := a9(indx);
76 t(ddindx).program_update_date := a10(indx);
77 t(ddindx).program_id := a11(indx);
78 t(ddindx).transfer_type := a12(indx);
79 t(ddindx).sold_from_cust_account_id := a13(indx);
80 t(ddindx).sold_from_party_id := a14(indx);
81 t(ddindx).sold_from_party_site_id := a15(indx);
82 t(ddindx).sold_to_cust_account_id := a16(indx);
83 t(ddindx).sold_to_party_id := a17(indx);
84 t(ddindx).sold_to_party_site_id := a18(indx);
85 t(ddindx).bill_to_site_use_id := a19(indx);
86 t(ddindx).ship_to_site_use_id := a20(indx);
87 t(ddindx).transaction_date := a21(indx);
88 t(ddindx).quantity := a22(indx);
89 t(ddindx).uom_code := a23(indx);
90 t(ddindx).amount := a24(indx);
91 t(ddindx).currency_code := a25(indx);
92 t(ddindx).inventory_item_id := a26(indx);
93 t(ddindx).primary_quantity := a27(indx);
94 t(ddindx).primary_uom_code := a28(indx);
95 t(ddindx).common_quantity := a29(indx);
96 t(ddindx).common_uom_code := a30(indx);
97 t(ddindx).common_currency_code := a31(indx);
98 t(ddindx).common_amount := a32(indx);
99 t(ddindx).header_id := a33(indx);
100 t(ddindx).line_id := a34(indx);
101 t(ddindx).reason_code := a35(indx);
102 t(ddindx).source_code := a36(indx);
103 t(ddindx).error_flag := a37(indx);
104 t(ddindx).attribute_category := a38(indx);
105 t(ddindx).attribute1 := a39(indx);
106 t(ddindx).attribute2 := a40(indx);
107 t(ddindx).attribute3 := a41(indx);
108 t(ddindx).attribute4 := a42(indx);
109 t(ddindx).attribute5 := a43(indx);
110 t(ddindx).attribute6 := a44(indx);
111 t(ddindx).attribute7 := a45(indx);
112 t(ddindx).attribute8 := a46(indx);
113 t(ddindx).attribute9 := a47(indx);
114 t(ddindx).attribute10 := a48(indx);
115 t(ddindx).attribute11 := a49(indx);
116 t(ddindx).attribute12 := a50(indx);
117 t(ddindx).attribute13 := a51(indx);
118 t(ddindx).attribute14 := a52(indx);
119 t(ddindx).attribute15 := a53(indx);
120 t(ddindx).org_id := a54(indx);
121 ddindx := ddindx+1;
122 if a0.last =indx
123 then exit;
124 end if;
125 indx := a0.next(indx);
126 end loop;
127 end if;
128 end if;
129 end rosetta_table_copy_in_p1;
130 procedure rosetta_table_copy_out_p1(t ozf_sales_transactions_pvt.sales_trans_tbl, a0 out nocopy JTF_NUMBER_TABLE
131 , a1 out nocopy JTF_NUMBER_TABLE
132 , a2 out nocopy JTF_DATE_TABLE
133 , a3 out nocopy JTF_NUMBER_TABLE
134 , a4 out nocopy JTF_DATE_TABLE
135 , a5 out nocopy JTF_NUMBER_TABLE
136 , a6 out nocopy JTF_NUMBER_TABLE
137 , a7 out nocopy JTF_VARCHAR2_TABLE_100
138 , a8 out nocopy JTF_NUMBER_TABLE
139 , a9 out nocopy JTF_NUMBER_TABLE
140 , a10 out nocopy JTF_DATE_TABLE
141 , a11 out nocopy JTF_NUMBER_TABLE
142 , a12 out nocopy JTF_VARCHAR2_TABLE_100
143 , a13 out nocopy JTF_NUMBER_TABLE
144 , a14 out nocopy JTF_NUMBER_TABLE
145 , a15 out nocopy JTF_NUMBER_TABLE
146 , a16 out nocopy JTF_NUMBER_TABLE
147 , a17 out nocopy JTF_NUMBER_TABLE
148 , a18 out nocopy JTF_NUMBER_TABLE
149 , a19 out nocopy JTF_NUMBER_TABLE
150 , a20 out nocopy JTF_NUMBER_TABLE
151 , a21 out nocopy JTF_DATE_TABLE
152 , a22 out nocopy JTF_NUMBER_TABLE
153 , a23 out nocopy JTF_VARCHAR2_TABLE_100
154 , a24 out nocopy JTF_NUMBER_TABLE
155 , a25 out nocopy JTF_VARCHAR2_TABLE_100
156 , a26 out nocopy JTF_NUMBER_TABLE
157 , a27 out nocopy JTF_NUMBER_TABLE
158 , a28 out nocopy JTF_VARCHAR2_TABLE_100
159 , a29 out nocopy JTF_NUMBER_TABLE
160 , a30 out nocopy JTF_VARCHAR2_TABLE_100
161 , a31 out nocopy JTF_VARCHAR2_TABLE_100
162 , a32 out nocopy JTF_NUMBER_TABLE
163 , a33 out nocopy JTF_NUMBER_TABLE
164 , a34 out nocopy JTF_NUMBER_TABLE
165 , a35 out nocopy JTF_VARCHAR2_TABLE_100
166 , a36 out nocopy JTF_VARCHAR2_TABLE_100
167 , a37 out nocopy JTF_VARCHAR2_TABLE_100
168 , a38 out nocopy JTF_VARCHAR2_TABLE_100
169 , a39 out nocopy JTF_VARCHAR2_TABLE_300
170 , a40 out nocopy JTF_VARCHAR2_TABLE_300
171 , a41 out nocopy JTF_VARCHAR2_TABLE_300
172 , a42 out nocopy JTF_VARCHAR2_TABLE_300
173 , a43 out nocopy JTF_VARCHAR2_TABLE_300
174 , a44 out nocopy JTF_VARCHAR2_TABLE_300
175 , a45 out nocopy JTF_VARCHAR2_TABLE_300
176 , a46 out nocopy JTF_VARCHAR2_TABLE_300
177 , a47 out nocopy JTF_VARCHAR2_TABLE_300
178 , a48 out nocopy JTF_VARCHAR2_TABLE_300
179 , a49 out nocopy JTF_VARCHAR2_TABLE_300
180 , a50 out nocopy JTF_VARCHAR2_TABLE_300
181 , a51 out nocopy JTF_VARCHAR2_TABLE_300
182 , a52 out nocopy JTF_VARCHAR2_TABLE_300
183 , a53 out nocopy JTF_VARCHAR2_TABLE_300
184 , a54 out nocopy JTF_NUMBER_TABLE
185 ) as
186 ddindx binary_integer; indx binary_integer;
187 begin
188 if t is null or t.count = 0 then
189 a0 := JTF_NUMBER_TABLE();
190 a1 := JTF_NUMBER_TABLE();
191 a2 := JTF_DATE_TABLE();
192 a3 := JTF_NUMBER_TABLE();
193 a4 := JTF_DATE_TABLE();
194 a5 := JTF_NUMBER_TABLE();
195 a6 := JTF_NUMBER_TABLE();
196 a7 := JTF_VARCHAR2_TABLE_100();
197 a8 := JTF_NUMBER_TABLE();
198 a9 := JTF_NUMBER_TABLE();
199 a10 := JTF_DATE_TABLE();
200 a11 := JTF_NUMBER_TABLE();
201 a12 := JTF_VARCHAR2_TABLE_100();
202 a13 := JTF_NUMBER_TABLE();
203 a14 := JTF_NUMBER_TABLE();
204 a15 := JTF_NUMBER_TABLE();
205 a16 := JTF_NUMBER_TABLE();
206 a17 := JTF_NUMBER_TABLE();
207 a18 := JTF_NUMBER_TABLE();
208 a19 := JTF_NUMBER_TABLE();
209 a20 := JTF_NUMBER_TABLE();
210 a21 := JTF_DATE_TABLE();
211 a22 := JTF_NUMBER_TABLE();
212 a23 := JTF_VARCHAR2_TABLE_100();
213 a24 := JTF_NUMBER_TABLE();
214 a25 := JTF_VARCHAR2_TABLE_100();
215 a26 := JTF_NUMBER_TABLE();
216 a27 := JTF_NUMBER_TABLE();
217 a28 := JTF_VARCHAR2_TABLE_100();
218 a29 := JTF_NUMBER_TABLE();
219 a30 := JTF_VARCHAR2_TABLE_100();
220 a31 := JTF_VARCHAR2_TABLE_100();
221 a32 := JTF_NUMBER_TABLE();
222 a33 := JTF_NUMBER_TABLE();
223 a34 := JTF_NUMBER_TABLE();
224 a35 := JTF_VARCHAR2_TABLE_100();
225 a36 := JTF_VARCHAR2_TABLE_100();
226 a37 := JTF_VARCHAR2_TABLE_100();
227 a38 := JTF_VARCHAR2_TABLE_100();
228 a39 := JTF_VARCHAR2_TABLE_300();
229 a40 := JTF_VARCHAR2_TABLE_300();
230 a41 := JTF_VARCHAR2_TABLE_300();
231 a42 := JTF_VARCHAR2_TABLE_300();
232 a43 := JTF_VARCHAR2_TABLE_300();
233 a44 := JTF_VARCHAR2_TABLE_300();
234 a45 := JTF_VARCHAR2_TABLE_300();
235 a46 := JTF_VARCHAR2_TABLE_300();
236 a47 := JTF_VARCHAR2_TABLE_300();
237 a48 := JTF_VARCHAR2_TABLE_300();
238 a49 := JTF_VARCHAR2_TABLE_300();
239 a50 := JTF_VARCHAR2_TABLE_300();
240 a51 := JTF_VARCHAR2_TABLE_300();
241 a52 := JTF_VARCHAR2_TABLE_300();
242 a53 := JTF_VARCHAR2_TABLE_300();
243 a54 := JTF_NUMBER_TABLE();
244 else
245 a0 := JTF_NUMBER_TABLE();
246 a1 := JTF_NUMBER_TABLE();
247 a2 := JTF_DATE_TABLE();
248 a3 := JTF_NUMBER_TABLE();
249 a4 := JTF_DATE_TABLE();
250 a5 := JTF_NUMBER_TABLE();
251 a6 := JTF_NUMBER_TABLE();
252 a7 := JTF_VARCHAR2_TABLE_100();
253 a8 := JTF_NUMBER_TABLE();
254 a9 := JTF_NUMBER_TABLE();
255 a10 := JTF_DATE_TABLE();
256 a11 := JTF_NUMBER_TABLE();
257 a12 := JTF_VARCHAR2_TABLE_100();
258 a13 := JTF_NUMBER_TABLE();
259 a14 := JTF_NUMBER_TABLE();
260 a15 := JTF_NUMBER_TABLE();
261 a16 := JTF_NUMBER_TABLE();
262 a17 := JTF_NUMBER_TABLE();
263 a18 := JTF_NUMBER_TABLE();
264 a19 := JTF_NUMBER_TABLE();
265 a20 := JTF_NUMBER_TABLE();
266 a21 := JTF_DATE_TABLE();
267 a22 := JTF_NUMBER_TABLE();
268 a23 := JTF_VARCHAR2_TABLE_100();
269 a24 := JTF_NUMBER_TABLE();
270 a25 := JTF_VARCHAR2_TABLE_100();
271 a26 := JTF_NUMBER_TABLE();
272 a27 := JTF_NUMBER_TABLE();
273 a28 := JTF_VARCHAR2_TABLE_100();
274 a29 := JTF_NUMBER_TABLE();
275 a30 := JTF_VARCHAR2_TABLE_100();
276 a31 := JTF_VARCHAR2_TABLE_100();
277 a32 := JTF_NUMBER_TABLE();
278 a33 := JTF_NUMBER_TABLE();
279 a34 := JTF_NUMBER_TABLE();
280 a35 := JTF_VARCHAR2_TABLE_100();
281 a36 := JTF_VARCHAR2_TABLE_100();
282 a37 := JTF_VARCHAR2_TABLE_100();
283 a38 := JTF_VARCHAR2_TABLE_100();
284 a39 := JTF_VARCHAR2_TABLE_300();
285 a40 := JTF_VARCHAR2_TABLE_300();
286 a41 := JTF_VARCHAR2_TABLE_300();
287 a42 := JTF_VARCHAR2_TABLE_300();
288 a43 := JTF_VARCHAR2_TABLE_300();
289 a44 := JTF_VARCHAR2_TABLE_300();
290 a45 := JTF_VARCHAR2_TABLE_300();
291 a46 := JTF_VARCHAR2_TABLE_300();
292 a47 := JTF_VARCHAR2_TABLE_300();
293 a48 := JTF_VARCHAR2_TABLE_300();
294 a49 := JTF_VARCHAR2_TABLE_300();
295 a50 := JTF_VARCHAR2_TABLE_300();
296 a51 := JTF_VARCHAR2_TABLE_300();
297 a52 := JTF_VARCHAR2_TABLE_300();
298 a53 := JTF_VARCHAR2_TABLE_300();
299 a54 := JTF_NUMBER_TABLE();
300 if t.count > 0 then
301 a0.extend(t.count);
302 a1.extend(t.count);
303 a2.extend(t.count);
304 a3.extend(t.count);
305 a4.extend(t.count);
306 a5.extend(t.count);
307 a6.extend(t.count);
308 a7.extend(t.count);
309 a8.extend(t.count);
310 a9.extend(t.count);
311 a10.extend(t.count);
312 a11.extend(t.count);
313 a12.extend(t.count);
314 a13.extend(t.count);
315 a14.extend(t.count);
316 a15.extend(t.count);
317 a16.extend(t.count);
318 a17.extend(t.count);
319 a18.extend(t.count);
320 a19.extend(t.count);
321 a20.extend(t.count);
322 a21.extend(t.count);
323 a22.extend(t.count);
324 a23.extend(t.count);
325 a24.extend(t.count);
326 a25.extend(t.count);
327 a26.extend(t.count);
328 a27.extend(t.count);
329 a28.extend(t.count);
330 a29.extend(t.count);
331 a30.extend(t.count);
332 a31.extend(t.count);
333 a32.extend(t.count);
334 a33.extend(t.count);
335 a34.extend(t.count);
336 a35.extend(t.count);
337 a36.extend(t.count);
338 a37.extend(t.count);
339 a38.extend(t.count);
340 a39.extend(t.count);
341 a40.extend(t.count);
342 a41.extend(t.count);
343 a42.extend(t.count);
344 a43.extend(t.count);
345 a44.extend(t.count);
346 a45.extend(t.count);
347 a46.extend(t.count);
348 a47.extend(t.count);
349 a48.extend(t.count);
350 a49.extend(t.count);
351 a50.extend(t.count);
352 a51.extend(t.count);
353 a52.extend(t.count);
354 a53.extend(t.count);
355 a54.extend(t.count);
356 ddindx := t.first;
357 indx := 1;
358 while true loop
359 a0(indx) := t(ddindx).sales_transaction_id;
360 a1(indx) := t(ddindx).object_version_number;
361 a2(indx) := t(ddindx).last_update_date;
362 a3(indx) := t(ddindx).last_updated_by;
363 a4(indx) := t(ddindx).creation_date;
364 a5(indx) := t(ddindx).request_id;
365 a6(indx) := t(ddindx).created_by;
366 a7(indx) := t(ddindx).created_from;
367 a8(indx) := t(ddindx).last_update_login;
368 a9(indx) := t(ddindx).program_application_id;
369 a10(indx) := t(ddindx).program_update_date;
370 a11(indx) := t(ddindx).program_id;
371 a12(indx) := t(ddindx).transfer_type;
372 a13(indx) := t(ddindx).sold_from_cust_account_id;
373 a14(indx) := t(ddindx).sold_from_party_id;
374 a15(indx) := t(ddindx).sold_from_party_site_id;
375 a16(indx) := t(ddindx).sold_to_cust_account_id;
376 a17(indx) := t(ddindx).sold_to_party_id;
377 a18(indx) := t(ddindx).sold_to_party_site_id;
378 a19(indx) := t(ddindx).bill_to_site_use_id;
379 a20(indx) := t(ddindx).ship_to_site_use_id;
380 a21(indx) := t(ddindx).transaction_date;
381 a22(indx) := t(ddindx).quantity;
382 a23(indx) := t(ddindx).uom_code;
383 a24(indx) := t(ddindx).amount;
384 a25(indx) := t(ddindx).currency_code;
385 a26(indx) := t(ddindx).inventory_item_id;
386 a27(indx) := t(ddindx).primary_quantity;
387 a28(indx) := t(ddindx).primary_uom_code;
388 a29(indx) := t(ddindx).common_quantity;
389 a30(indx) := t(ddindx).common_uom_code;
390 a31(indx) := t(ddindx).common_currency_code;
391 a32(indx) := t(ddindx).common_amount;
392 a33(indx) := t(ddindx).header_id;
393 a34(indx) := t(ddindx).line_id;
394 a35(indx) := t(ddindx).reason_code;
395 a36(indx) := t(ddindx).source_code;
396 a37(indx) := t(ddindx).error_flag;
397 a38(indx) := t(ddindx).attribute_category;
398 a39(indx) := t(ddindx).attribute1;
399 a40(indx) := t(ddindx).attribute2;
400 a41(indx) := t(ddindx).attribute3;
401 a42(indx) := t(ddindx).attribute4;
402 a43(indx) := t(ddindx).attribute5;
403 a44(indx) := t(ddindx).attribute6;
404 a45(indx) := t(ddindx).attribute7;
405 a46(indx) := t(ddindx).attribute8;
406 a47(indx) := t(ddindx).attribute9;
407 a48(indx) := t(ddindx).attribute10;
408 a49(indx) := t(ddindx).attribute11;
409 a50(indx) := t(ddindx).attribute12;
410 a51(indx) := t(ddindx).attribute13;
411 a52(indx) := t(ddindx).attribute14;
412 a53(indx) := t(ddindx).attribute15;
413 a54(indx) := t(ddindx).org_id;
414 indx := indx+1;
415 if t.last =ddindx
416 then exit;
417 end if;
418 ddindx := t.next(ddindx);
419 end loop;
420 end if;
421 end if;
422 end rosetta_table_copy_out_p1;
423
424 procedure validate_transaction(p_api_version NUMBER
425 , p_init_msg_list VARCHAR2
426 , p_validation_level NUMBER
427 , x_return_status out nocopy VARCHAR2
428 , x_msg_count out nocopy NUMBER
429 , x_msg_data out nocopy VARCHAR2
430 , p6_a0 NUMBER
431 , p6_a1 NUMBER
432 , p6_a2 DATE
433 , p6_a3 NUMBER
434 , p6_a4 DATE
435 , p6_a5 NUMBER
436 , p6_a6 NUMBER
437 , p6_a7 VARCHAR2
438 , p6_a8 NUMBER
439 , p6_a9 NUMBER
440 , p6_a10 DATE
441 , p6_a11 NUMBER
442 , p6_a12 VARCHAR2
443 , p6_a13 NUMBER
444 , p6_a14 NUMBER
445 , p6_a15 NUMBER
446 , p6_a16 NUMBER
447 , p6_a17 NUMBER
448 , p6_a18 NUMBER
449 , p6_a19 NUMBER
450 , p6_a20 NUMBER
451 , p6_a21 DATE
452 , p6_a22 NUMBER
453 , p6_a23 VARCHAR2
454 , p6_a24 NUMBER
455 , p6_a25 VARCHAR2
456 , p6_a26 NUMBER
457 , p6_a27 NUMBER
458 , p6_a28 VARCHAR2
459 , p6_a29 NUMBER
460 , p6_a30 VARCHAR2
461 , p6_a31 VARCHAR2
462 , p6_a32 NUMBER
463 , p6_a33 NUMBER
464 , p6_a34 NUMBER
465 , p6_a35 VARCHAR2
466 , p6_a36 VARCHAR2
467 , p6_a37 VARCHAR2
468 , p6_a38 VARCHAR2
469 , p6_a39 VARCHAR2
470 , p6_a40 VARCHAR2
471 , p6_a41 VARCHAR2
472 , p6_a42 VARCHAR2
473 , p6_a43 VARCHAR2
474 , p6_a44 VARCHAR2
475 , p6_a45 VARCHAR2
476 , p6_a46 VARCHAR2
477 , p6_a47 VARCHAR2
478 , p6_a48 VARCHAR2
479 , p6_a49 VARCHAR2
480 , p6_a50 VARCHAR2
481 , p6_a51 VARCHAR2
482 , p6_a52 VARCHAR2
483 , p6_a53 VARCHAR2
484 , p6_a54 NUMBER
485 )
486
487 as
488 ddp_transaction ozf_sales_transactions_pvt.sales_transaction_rec_type;
489 ddindx binary_integer; indx binary_integer;
490 begin
491
492 -- copy data to the local IN or IN-OUT args, if any
493
494
495
496
497
498
499 ddp_transaction.sales_transaction_id := p6_a0;
500 ddp_transaction.object_version_number := p6_a1;
501 ddp_transaction.last_update_date := p6_a2;
502 ddp_transaction.last_updated_by := p6_a3;
503 ddp_transaction.creation_date := p6_a4;
504 ddp_transaction.request_id := p6_a5;
505 ddp_transaction.created_by := p6_a6;
506 ddp_transaction.created_from := p6_a7;
507 ddp_transaction.last_update_login := p6_a8;
508 ddp_transaction.program_application_id := p6_a9;
509 ddp_transaction.program_update_date := p6_a10;
510 ddp_transaction.program_id := p6_a11;
511 ddp_transaction.transfer_type := p6_a12;
512 ddp_transaction.sold_from_cust_account_id := p6_a13;
513 ddp_transaction.sold_from_party_id := p6_a14;
514 ddp_transaction.sold_from_party_site_id := p6_a15;
515 ddp_transaction.sold_to_cust_account_id := p6_a16;
516 ddp_transaction.sold_to_party_id := p6_a17;
517 ddp_transaction.sold_to_party_site_id := p6_a18;
518 ddp_transaction.bill_to_site_use_id := p6_a19;
519 ddp_transaction.ship_to_site_use_id := p6_a20;
520 ddp_transaction.transaction_date := p6_a21;
521 ddp_transaction.quantity := p6_a22;
522 ddp_transaction.uom_code := p6_a23;
523 ddp_transaction.amount := p6_a24;
524 ddp_transaction.currency_code := p6_a25;
525 ddp_transaction.inventory_item_id := p6_a26;
526 ddp_transaction.primary_quantity := p6_a27;
527 ddp_transaction.primary_uom_code := p6_a28;
528 ddp_transaction.common_quantity := p6_a29;
529 ddp_transaction.common_uom_code := p6_a30;
530 ddp_transaction.common_currency_code := p6_a31;
531 ddp_transaction.common_amount := p6_a32;
532 ddp_transaction.header_id := p6_a33;
533 ddp_transaction.line_id := p6_a34;
534 ddp_transaction.reason_code := p6_a35;
535 ddp_transaction.source_code := p6_a36;
536 ddp_transaction.error_flag := p6_a37;
537 ddp_transaction.attribute_category := p6_a38;
538 ddp_transaction.attribute1 := p6_a39;
539 ddp_transaction.attribute2 := p6_a40;
540 ddp_transaction.attribute3 := p6_a41;
541 ddp_transaction.attribute4 := p6_a42;
542 ddp_transaction.attribute5 := p6_a43;
543 ddp_transaction.attribute6 := p6_a44;
544 ddp_transaction.attribute7 := p6_a45;
545 ddp_transaction.attribute8 := p6_a46;
546 ddp_transaction.attribute9 := p6_a47;
547 ddp_transaction.attribute10 := p6_a48;
548 ddp_transaction.attribute11 := p6_a49;
549 ddp_transaction.attribute12 := p6_a50;
550 ddp_transaction.attribute13 := p6_a51;
551 ddp_transaction.attribute14 := p6_a52;
552 ddp_transaction.attribute15 := p6_a53;
553 ddp_transaction.org_id := p6_a54;
554
555 -- here's the delegated call to the old PL/SQL routine
556 ozf_sales_transactions_pvt.validate_transaction(p_api_version,
557 p_init_msg_list,
558 p_validation_level,
559 x_return_status,
560 x_msg_count,
561 x_msg_data,
562 ddp_transaction);
563
564 -- copy data back from the local variables to OUT or IN-OUT args, if any
565
566
567
568
569
570
571 end;
572
573 procedure create_transaction(p_api_version NUMBER
574 , p_init_msg_list VARCHAR2
575 , p_commit VARCHAR2
576 , p_validation_level NUMBER
577 , p4_a0 NUMBER
578 , p4_a1 NUMBER
579 , p4_a2 DATE
580 , p4_a3 NUMBER
581 , p4_a4 DATE
582 , p4_a5 NUMBER
583 , p4_a6 NUMBER
584 , p4_a7 VARCHAR2
585 , p4_a8 NUMBER
586 , p4_a9 NUMBER
587 , p4_a10 DATE
588 , p4_a11 NUMBER
589 , p4_a12 VARCHAR2
590 , p4_a13 NUMBER
591 , p4_a14 NUMBER
592 , p4_a15 NUMBER
593 , p4_a16 NUMBER
594 , p4_a17 NUMBER
595 , p4_a18 NUMBER
596 , p4_a19 NUMBER
597 , p4_a20 NUMBER
598 , p4_a21 DATE
599 , p4_a22 NUMBER
600 , p4_a23 VARCHAR2
601 , p4_a24 NUMBER
602 , p4_a25 VARCHAR2
603 , p4_a26 NUMBER
604 , p4_a27 NUMBER
605 , p4_a28 VARCHAR2
606 , p4_a29 NUMBER
607 , p4_a30 VARCHAR2
608 , p4_a31 VARCHAR2
609 , p4_a32 NUMBER
610 , p4_a33 NUMBER
611 , p4_a34 NUMBER
612 , p4_a35 VARCHAR2
613 , p4_a36 VARCHAR2
614 , p4_a37 VARCHAR2
615 , p4_a38 VARCHAR2
616 , p4_a39 VARCHAR2
617 , p4_a40 VARCHAR2
618 , p4_a41 VARCHAR2
619 , p4_a42 VARCHAR2
620 , p4_a43 VARCHAR2
621 , p4_a44 VARCHAR2
622 , p4_a45 VARCHAR2
623 , p4_a46 VARCHAR2
624 , p4_a47 VARCHAR2
625 , p4_a48 VARCHAR2
626 , p4_a49 VARCHAR2
627 , p4_a50 VARCHAR2
628 , p4_a51 VARCHAR2
629 , p4_a52 VARCHAR2
630 , p4_a53 VARCHAR2
631 , p4_a54 NUMBER
632 , x_sales_transaction_id out nocopy NUMBER
633 , x_return_status out nocopy VARCHAR2
634 , x_msg_data out nocopy VARCHAR2
635 , x_msg_count out nocopy NUMBER
636 )
637
638 as
639 ddp_transaction_rec ozf_sales_transactions_pvt.sales_transaction_rec_type;
640 ddindx binary_integer; indx binary_integer;
641 begin
642
643 -- copy data to the local IN or IN-OUT args, if any
644
645
646
647
648 ddp_transaction_rec.sales_transaction_id := p4_a0;
649 ddp_transaction_rec.object_version_number := p4_a1;
650 ddp_transaction_rec.last_update_date := p4_a2;
651 ddp_transaction_rec.last_updated_by := p4_a3;
652 ddp_transaction_rec.creation_date := p4_a4;
653 ddp_transaction_rec.request_id := p4_a5;
654 ddp_transaction_rec.created_by := p4_a6;
655 ddp_transaction_rec.created_from := p4_a7;
656 ddp_transaction_rec.last_update_login := p4_a8;
657 ddp_transaction_rec.program_application_id := p4_a9;
658 ddp_transaction_rec.program_update_date := p4_a10;
659 ddp_transaction_rec.program_id := p4_a11;
660 ddp_transaction_rec.transfer_type := p4_a12;
661 ddp_transaction_rec.sold_from_cust_account_id := p4_a13;
662 ddp_transaction_rec.sold_from_party_id := p4_a14;
663 ddp_transaction_rec.sold_from_party_site_id := p4_a15;
664 ddp_transaction_rec.sold_to_cust_account_id := p4_a16;
665 ddp_transaction_rec.sold_to_party_id := p4_a17;
666 ddp_transaction_rec.sold_to_party_site_id := p4_a18;
667 ddp_transaction_rec.bill_to_site_use_id := p4_a19;
668 ddp_transaction_rec.ship_to_site_use_id := p4_a20;
669 ddp_transaction_rec.transaction_date := p4_a21;
670 ddp_transaction_rec.quantity := p4_a22;
671 ddp_transaction_rec.uom_code := p4_a23;
672 ddp_transaction_rec.amount := p4_a24;
673 ddp_transaction_rec.currency_code := p4_a25;
674 ddp_transaction_rec.inventory_item_id := p4_a26;
675 ddp_transaction_rec.primary_quantity := p4_a27;
676 ddp_transaction_rec.primary_uom_code := p4_a28;
677 ddp_transaction_rec.common_quantity := p4_a29;
678 ddp_transaction_rec.common_uom_code := p4_a30;
679 ddp_transaction_rec.common_currency_code := p4_a31;
680 ddp_transaction_rec.common_amount := p4_a32;
681 ddp_transaction_rec.header_id := p4_a33;
682 ddp_transaction_rec.line_id := p4_a34;
683 ddp_transaction_rec.reason_code := p4_a35;
684 ddp_transaction_rec.source_code := p4_a36;
685 ddp_transaction_rec.error_flag := p4_a37;
686 ddp_transaction_rec.attribute_category := p4_a38;
687 ddp_transaction_rec.attribute1 := p4_a39;
688 ddp_transaction_rec.attribute2 := p4_a40;
689 ddp_transaction_rec.attribute3 := p4_a41;
690 ddp_transaction_rec.attribute4 := p4_a42;
691 ddp_transaction_rec.attribute5 := p4_a43;
692 ddp_transaction_rec.attribute6 := p4_a44;
693 ddp_transaction_rec.attribute7 := p4_a45;
694 ddp_transaction_rec.attribute8 := p4_a46;
695 ddp_transaction_rec.attribute9 := p4_a47;
696 ddp_transaction_rec.attribute10 := p4_a48;
697 ddp_transaction_rec.attribute11 := p4_a49;
698 ddp_transaction_rec.attribute12 := p4_a50;
699 ddp_transaction_rec.attribute13 := p4_a51;
700 ddp_transaction_rec.attribute14 := p4_a52;
701 ddp_transaction_rec.attribute15 := p4_a53;
702 ddp_transaction_rec.org_id := p4_a54;
703
704
705
706
707
708 -- here's the delegated call to the old PL/SQL routine
709 ozf_sales_transactions_pvt.create_transaction(p_api_version,
710 p_init_msg_list,
711 p_commit,
712 p_validation_level,
713 ddp_transaction_rec,
714 x_sales_transaction_id,
715 x_return_status,
716 x_msg_data,
717 x_msg_count);
718
719 -- copy data back from the local variables to OUT or IN-OUT args, if any
720
721
722
723
724
725
726
727
728 end;
729
730 procedure validate_inventory_level(p_api_version NUMBER
731 , p_init_msg_list VARCHAR2
732 , p_validation_level NUMBER
733 , p3_a0 NUMBER
734 , p3_a1 NUMBER
735 , p3_a2 DATE
736 , p3_a3 NUMBER
737 , p3_a4 DATE
738 , p3_a5 NUMBER
739 , p3_a6 NUMBER
740 , p3_a7 VARCHAR2
741 , p3_a8 NUMBER
742 , p3_a9 NUMBER
743 , p3_a10 DATE
744 , p3_a11 NUMBER
745 , p3_a12 NUMBER
746 , p3_a13 VARCHAR2
747 , p3_a14 VARCHAR2
748 , p3_a15 VARCHAR2
749 , p3_a16 DATE
750 , p3_a17 VARCHAR2
751 , p3_a18 NUMBER
752 , p3_a19 NUMBER
753 , p3_a20 VARCHAR2
754 , p3_a21 VARCHAR2
755 , p3_a22 VARCHAR2
756 , p3_a23 VARCHAR2
757 , p3_a24 VARCHAR2
758 , p3_a25 VARCHAR2
759 , p3_a26 VARCHAR2
760 , p3_a27 NUMBER
761 , p3_a28 VARCHAR2
762 , p3_a29 VARCHAR2
763 , p3_a30 VARCHAR2
764 , p3_a31 VARCHAR2
765 , p3_a32 NUMBER
766 , p3_a33 NUMBER
767 , p3_a34 VARCHAR2
768 , p3_a35 VARCHAR2
769 , p3_a36 VARCHAR2
770 , p3_a37 VARCHAR2
771 , p3_a38 VARCHAR2
772 , p3_a39 VARCHAR2
773 , p3_a40 VARCHAR2
774 , p3_a41 NUMBER
775 , p3_a42 VARCHAR2
776 , p3_a43 VARCHAR2
777 , p3_a44 VARCHAR2
778 , p3_a45 VARCHAR2
779 , p3_a46 NUMBER
780 , p3_a47 NUMBER
781 , p3_a48 NUMBER
782 , p3_a49 NUMBER
783 , p3_a50 VARCHAR2
784 , p3_a51 VARCHAR2
785 , p3_a52 VARCHAR2
786 , p3_a53 VARCHAR2
787 , p3_a54 VARCHAR2
788 , p3_a55 VARCHAR2
789 , p3_a56 VARCHAR2
790 , p3_a57 VARCHAR2
791 , p3_a58 NUMBER
792 , p3_a59 VARCHAR2
793 , p3_a60 VARCHAR2
794 , p3_a61 VARCHAR2
795 , p3_a62 VARCHAR2
796 , p3_a63 NUMBER
797 , p3_a64 NUMBER
798 , p3_a65 NUMBER
799 , p3_a66 NUMBER
800 , p3_a67 VARCHAR2
801 , p3_a68 VARCHAR2
802 , p3_a69 VARCHAR2
803 , p3_a70 VARCHAR2
804 , p3_a71 VARCHAR2
805 , p3_a72 VARCHAR2
806 , p3_a73 VARCHAR2
807 , p3_a74 VARCHAR2
808 , p3_a75 NUMBER
809 , p3_a76 VARCHAR2
810 , p3_a77 VARCHAR2
811 , p3_a78 VARCHAR2
812 , p3_a79 VARCHAR2
813 , p3_a80 NUMBER
814 , p3_a81 NUMBER
815 , p3_a82 VARCHAR2
816 , p3_a83 NUMBER
817 , p3_a84 VARCHAR2
818 , p3_a85 VARCHAR2
819 , p3_a86 VARCHAR2
820 , p3_a87 VARCHAR2
821 , p3_a88 VARCHAR2
822 , p3_a89 VARCHAR2
823 , p3_a90 VARCHAR2
824 , p3_a91 NUMBER
825 , p3_a92 VARCHAR2
826 , p3_a93 VARCHAR2
827 , p3_a94 VARCHAR2
828 , p3_a95 VARCHAR2
829 , p3_a96 VARCHAR2
830 , p3_a97 NUMBER
831 , p3_a98 VARCHAR2
832 , p3_a99 VARCHAR2
833 , p3_a100 VARCHAR2
834 , p3_a101 NUMBER
835 , p3_a102 VARCHAR2
836 , p3_a103 NUMBER
837 , p3_a104 VARCHAR2
838 , p3_a105 NUMBER
839 , p3_a106 VARCHAR2
840 , p3_a107 NUMBER
841 , p3_a108 VARCHAR2
842 , p3_a109 VARCHAR2
843 , p3_a110 VARCHAR2
844 , p3_a111 VARCHAR2
845 , p3_a112 NUMBER
846 , p3_a113 NUMBER
847 , p3_a114 VARCHAR2
848 , p3_a115 VARCHAR2
849 , p3_a116 VARCHAR2
850 , p3_a117 NUMBER
851 , p3_a118 NUMBER
852 , p3_a119 VARCHAR2
853 , p3_a120 VARCHAR2
854 , p3_a121 VARCHAR2
855 , p3_a122 VARCHAR2
856 , p3_a123 VARCHAR2
857 , p3_a124 NUMBER
858 , p3_a125 NUMBER
859 , p3_a126 VARCHAR2
860 , p3_a127 VARCHAR2
861 , p3_a128 NUMBER
862 , p3_a129 VARCHAR2
863 , p3_a130 DATE
864 , p3_a131 VARCHAR2
865 , p3_a132 VARCHAR2
866 , p3_a133 VARCHAR2
867 , p3_a134 VARCHAR2
868 , p3_a135 DATE
869 , p3_a136 VARCHAR2
870 , p3_a137 DATE
871 , p3_a138 DATE
872 , p3_a139 NUMBER
873 , p3_a140 NUMBER
874 , p3_a141 NUMBER
875 , p3_a142 NUMBER
876 , p3_a143 NUMBER
877 , p3_a144 NUMBER
878 , p3_a145 VARCHAR2
879 , p3_a146 NUMBER
880 , p3_a147 NUMBER
881 , p3_a148 VARCHAR2
882 , p3_a149 NUMBER
883 , p3_a150 NUMBER
884 , p3_a151 NUMBER
885 , p3_a152 VARCHAR2
886 , p3_a153 NUMBER
887 , p3_a154 NUMBER
888 , p3_a155 NUMBER
889 , p3_a156 NUMBER
890 , p3_a157 VARCHAR2
891 , p3_a158 DATE
892 , p3_a159 VARCHAR2
893 , p3_a160 NUMBER
894 , p3_a161 VARCHAR2
895 , p3_a162 VARCHAR2
896 , p3_a163 VARCHAR2
897 , p3_a164 VARCHAR2
898 , p3_a165 VARCHAR2
899 , p3_a166 VARCHAR2
900 , p3_a167 VARCHAR2
901 , p3_a168 VARCHAR2
902 , p3_a169 VARCHAR2
903 , p3_a170 VARCHAR2
904 , p3_a171 VARCHAR2
905 , p3_a172 VARCHAR2
906 , p3_a173 VARCHAR2
907 , p3_a174 VARCHAR2
908 , p3_a175 VARCHAR2
909 , p3_a176 VARCHAR2
910 , p3_a177 VARCHAR2
911 , p3_a178 VARCHAR2
912 , p3_a179 VARCHAR2
913 , p3_a180 VARCHAR2
914 , p3_a181 VARCHAR2
915 , p3_a182 VARCHAR2
916 , p3_a183 NUMBER
917 , p3_a184 VARCHAR2
918 , p3_a185 NUMBER
919 , p3_a186 NUMBER
920 , p3_a187 VARCHAR2
921 , p3_a188 VARCHAR2
922 , p3_a189 VARCHAR2
923 , p3_a190 VARCHAR2
924 , p3_a191 NUMBER
925 , p3_a192 VARCHAR2
926 , p3_a193 VARCHAR2
927 , p3_a194 VARCHAR2
928 , p3_a195 VARCHAR2
929 , p3_a196 VARCHAR2
930 , p3_a197 VARCHAR2
931 , p3_a198 VARCHAR2
932 , p3_a199 VARCHAR2
933 , p3_a200 VARCHAR2
934 , p3_a201 VARCHAR2
935 , p3_a202 VARCHAR2
936 , p3_a203 VARCHAR2
937 , p3_a204 VARCHAR2
938 , p3_a205 VARCHAR2
939 , p3_a206 VARCHAR2
940 , p3_a207 VARCHAR2
941 , p3_a208 VARCHAR2
942 , p3_a209 VARCHAR2
943 , p3_a210 VARCHAR2
944 , p3_a211 VARCHAR2
945 , p3_a212 VARCHAR2
946 , p3_a213 VARCHAR2
947 , p3_a214 VARCHAR2
948 , p3_a215 VARCHAR2
949 , p3_a216 VARCHAR2
950 , p3_a217 VARCHAR2
951 , p3_a218 VARCHAR2
952 , p3_a219 VARCHAR2
953 , p3_a220 VARCHAR2
954 , p3_a221 VARCHAR2
955 , p3_a222 VARCHAR2
956 , p3_a223 VARCHAR2
957 , p3_a224 VARCHAR2
958 , p3_a225 NUMBER
959 , x_valid out nocopy number
960 , x_return_status out nocopy VARCHAR2
961 , x_msg_count out nocopy NUMBER
962 , x_msg_data out nocopy VARCHAR2
963 )
964
965 as
966 ddp_line_int_rec ozf_resale_common_pvt.g_interface_rec_csr%rowtype;
967 ddx_valid boolean;
968 ddindx binary_integer; indx binary_integer;
969 begin
970
971 -- copy data to the local IN or IN-OUT args, if any
972
973
974
975 ddp_line_int_rec.resale_line_int_id := p3_a0;
976 ddp_line_int_rec.object_version_number := p3_a1;
977 ddp_line_int_rec.last_update_date := p3_a2;
978 ddp_line_int_rec.last_updated_by := p3_a3;
979 ddp_line_int_rec.creation_date := p3_a4;
980 ddp_line_int_rec.request_id := p3_a5;
981 ddp_line_int_rec.created_by := p3_a6;
982 ddp_line_int_rec.created_from := p3_a7;
983 ddp_line_int_rec.last_update_login := p3_a8;
984 ddp_line_int_rec.program_application_id := p3_a9;
985 ddp_line_int_rec.program_update_date := p3_a10;
986 ddp_line_int_rec.program_id := p3_a11;
987 ddp_line_int_rec.resale_batch_id := p3_a12;
988 ddp_line_int_rec.status_code := p3_a13;
989 ddp_line_int_rec.resale_transfer_type := p3_a14;
990 ddp_line_int_rec.product_transfer_movement_type := p3_a15;
991 ddp_line_int_rec.product_transfer_date := p3_a16;
992 ddp_line_int_rec.tracing_flag := p3_a17;
993 ddp_line_int_rec.ship_from_cust_account_id := p3_a18;
994 ddp_line_int_rec.ship_from_site_id := p3_a19;
995 ddp_line_int_rec.ship_from_party_name := p3_a20;
996 ddp_line_int_rec.ship_from_location := p3_a21;
997 ddp_line_int_rec.ship_from_address := p3_a22;
998 ddp_line_int_rec.ship_from_city := p3_a23;
999 ddp_line_int_rec.ship_from_state := p3_a24;
1000 ddp_line_int_rec.ship_from_postal_code := p3_a25;
1001 ddp_line_int_rec.ship_from_country := p3_a26;
1002 ddp_line_int_rec.ship_from_contact_party_id := p3_a27;
1003 ddp_line_int_rec.ship_from_contact_name := p3_a28;
1004 ddp_line_int_rec.ship_from_email := p3_a29;
1005 ddp_line_int_rec.ship_from_fax := p3_a30;
1006 ddp_line_int_rec.ship_from_phone := p3_a31;
1007 ddp_line_int_rec.sold_from_cust_account_id := p3_a32;
1008 ddp_line_int_rec.sold_from_site_id := p3_a33;
1009 ddp_line_int_rec.sold_from_party_name := p3_a34;
1010 ddp_line_int_rec.sold_from_location := p3_a35;
1011 ddp_line_int_rec.sold_from_address := p3_a36;
1012 ddp_line_int_rec.sold_from_city := p3_a37;
1013 ddp_line_int_rec.sold_from_state := p3_a38;
1014 ddp_line_int_rec.sold_from_postal_code := p3_a39;
1015 ddp_line_int_rec.sold_from_country := p3_a40;
1016 ddp_line_int_rec.sold_from_contact_party_id := p3_a41;
1017 ddp_line_int_rec.sold_from_contact_name := p3_a42;
1018 ddp_line_int_rec.sold_from_email := p3_a43;
1019 ddp_line_int_rec.sold_from_phone := p3_a44;
1020 ddp_line_int_rec.sold_from_fax := p3_a45;
1021 ddp_line_int_rec.bill_to_cust_account_id := p3_a46;
1022 ddp_line_int_rec.bill_to_site_use_id := p3_a47;
1023 ddp_line_int_rec.bill_to_party_id := p3_a48;
1024 ddp_line_int_rec.bill_to_party_site_id := p3_a49;
1025 ddp_line_int_rec.bill_to_party_name := p3_a50;
1026 ddp_line_int_rec.bill_to_duns_number := p3_a51;
1027 ddp_line_int_rec.bill_to_location := p3_a52;
1028 ddp_line_int_rec.bill_to_address := p3_a53;
1029 ddp_line_int_rec.bill_to_city := p3_a54;
1030 ddp_line_int_rec.bill_to_state := p3_a55;
1031 ddp_line_int_rec.bill_to_postal_code := p3_a56;
1032 ddp_line_int_rec.bill_to_country := p3_a57;
1033 ddp_line_int_rec.bill_to_contact_party_id := p3_a58;
1034 ddp_line_int_rec.bill_to_contact_name := p3_a59;
1035 ddp_line_int_rec.bill_to_email := p3_a60;
1036 ddp_line_int_rec.bill_to_phone := p3_a61;
1037 ddp_line_int_rec.bill_to_fax := p3_a62;
1038 ddp_line_int_rec.ship_to_cust_account_id := p3_a63;
1039 ddp_line_int_rec.ship_to_site_use_id := p3_a64;
1040 ddp_line_int_rec.ship_to_party_id := p3_a65;
1041 ddp_line_int_rec.ship_to_party_site_id := p3_a66;
1042 ddp_line_int_rec.ship_to_party_name := p3_a67;
1043 ddp_line_int_rec.ship_to_duns_number := p3_a68;
1044 ddp_line_int_rec.ship_to_location := p3_a69;
1045 ddp_line_int_rec.ship_to_address := p3_a70;
1046 ddp_line_int_rec.ship_to_city := p3_a71;
1047 ddp_line_int_rec.ship_to_country := p3_a72;
1048 ddp_line_int_rec.ship_to_postal_code := p3_a73;
1049 ddp_line_int_rec.ship_to_state := p3_a74;
1050 ddp_line_int_rec.ship_to_contact_party_id := p3_a75;
1051 ddp_line_int_rec.ship_to_contact_name := p3_a76;
1052 ddp_line_int_rec.ship_to_email := p3_a77;
1053 ddp_line_int_rec.ship_to_phone := p3_a78;
1054 ddp_line_int_rec.ship_to_fax := p3_a79;
1055 ddp_line_int_rec.end_cust_party_id := p3_a80;
1056 ddp_line_int_rec.end_cust_site_use_id := p3_a81;
1057 ddp_line_int_rec.end_cust_site_use_code := p3_a82;
1058 ddp_line_int_rec.end_cust_party_site_id := p3_a83;
1059 ddp_line_int_rec.end_cust_party_name := p3_a84;
1060 ddp_line_int_rec.end_cust_location := p3_a85;
1061 ddp_line_int_rec.end_cust_address := p3_a86;
1062 ddp_line_int_rec.end_cust_city := p3_a87;
1063 ddp_line_int_rec.end_cust_state := p3_a88;
1064 ddp_line_int_rec.end_cust_postal_code := p3_a89;
1065 ddp_line_int_rec.end_cust_country := p3_a90;
1066 ddp_line_int_rec.end_cust_contact_party_id := p3_a91;
1067 ddp_line_int_rec.end_cust_contact_name := p3_a92;
1068 ddp_line_int_rec.end_cust_email := p3_a93;
1069 ddp_line_int_rec.end_cust_phone := p3_a94;
1070 ddp_line_int_rec.end_cust_fax := p3_a95;
1071 ddp_line_int_rec.direct_customer_flag := p3_a96;
1072 ddp_line_int_rec.order_type_id := p3_a97;
1073 ddp_line_int_rec.order_type := p3_a98;
1074 ddp_line_int_rec.order_category := p3_a99;
1075 ddp_line_int_rec.agreement_type := p3_a100;
1076 ddp_line_int_rec.agreement_id := p3_a101;
1077 ddp_line_int_rec.agreement_name := p3_a102;
1078 ddp_line_int_rec.agreement_price := p3_a103;
1079 ddp_line_int_rec.agreement_uom_code := p3_a104;
1080 ddp_line_int_rec.corrected_agreement_id := p3_a105;
1081 ddp_line_int_rec.corrected_agreement_name := p3_a106;
1082 ddp_line_int_rec.price_list_id := p3_a107;
1083 ddp_line_int_rec.price_list_name := p3_a108;
1084 ddp_line_int_rec.orig_system_reference := p3_a109;
1085 ddp_line_int_rec.orig_system_line_reference := p3_a110;
1086 ddp_line_int_rec.orig_system_currency_code := p3_a111;
1087 ddp_line_int_rec.orig_system_selling_price := p3_a112;
1088 ddp_line_int_rec.orig_system_quantity := p3_a113;
1089 ddp_line_int_rec.orig_system_uom := p3_a114;
1090 ddp_line_int_rec.orig_system_purchase_uom := p3_a115;
1091 ddp_line_int_rec.orig_system_purchase_curr := p3_a116;
1092 ddp_line_int_rec.orig_system_purchase_price := p3_a117;
1093 ddp_line_int_rec.orig_system_purchase_quantity := p3_a118;
1094 ddp_line_int_rec.orig_system_agreement_uom := p3_a119;
1095 ddp_line_int_rec.orig_system_agreement_name := p3_a120;
1096 ddp_line_int_rec.orig_system_agreement_type := p3_a121;
1097 ddp_line_int_rec.orig_system_agreement_status := p3_a122;
1098 ddp_line_int_rec.orig_system_agreement_curr := p3_a123;
1099 ddp_line_int_rec.orig_system_agreement_price := p3_a124;
1100 ddp_line_int_rec.orig_system_agreement_quantity := p3_a125;
1101 ddp_line_int_rec.orig_system_item_number := p3_a126;
1102 ddp_line_int_rec.currency_code := p3_a127;
1103 ddp_line_int_rec.exchange_rate := p3_a128;
1104 ddp_line_int_rec.exchange_rate_type := p3_a129;
1105 ddp_line_int_rec.exchange_rate_date := p3_a130;
1106 ddp_line_int_rec.po_number := p3_a131;
1107 ddp_line_int_rec.po_release_number := p3_a132;
1108 ddp_line_int_rec.po_type := p3_a133;
1109 ddp_line_int_rec.invoice_number := p3_a134;
1110 ddp_line_int_rec.date_invoiced := p3_a135;
1111 ddp_line_int_rec.order_number := p3_a136;
1112 ddp_line_int_rec.date_ordered := p3_a137;
1113 ddp_line_int_rec.date_shipped := p3_a138;
1114 ddp_line_int_rec.claimed_amount := p3_a139;
1115 ddp_line_int_rec.allowed_amount := p3_a140;
1116 ddp_line_int_rec.total_allowed_amount := p3_a141;
1117 ddp_line_int_rec.accepted_amount := p3_a142;
1118 ddp_line_int_rec.total_accepted_amount := p3_a143;
1119 ddp_line_int_rec.line_tolerance_amount := p3_a144;
1120 ddp_line_int_rec.tolerance_flag := p3_a145;
1121 ddp_line_int_rec.total_claimed_amount := p3_a146;
1122 ddp_line_int_rec.purchase_price := p3_a147;
1123 ddp_line_int_rec.purchase_uom_code := p3_a148;
1124 ddp_line_int_rec.acctd_purchase_price := p3_a149;
1125 ddp_line_int_rec.selling_price := p3_a150;
1126 ddp_line_int_rec.acctd_selling_price := p3_a151;
1127 ddp_line_int_rec.uom_code := p3_a152;
1128 ddp_line_int_rec.quantity := p3_a153;
1129 ddp_line_int_rec.calculated_price := p3_a154;
1130 ddp_line_int_rec.acctd_calculated_price := p3_a155;
1131 ddp_line_int_rec.calculated_amount := p3_a156;
1132 ddp_line_int_rec.credit_code := p3_a157;
1133 ddp_line_int_rec.credit_advice_date := p3_a158;
1134 ddp_line_int_rec.upc_code := p3_a159;
1135 ddp_line_int_rec.inventory_item_id := p3_a160;
1136 ddp_line_int_rec.item_number := p3_a161;
1137 ddp_line_int_rec.item_description := p3_a162;
1138 ddp_line_int_rec.inventory_item_segment1 := p3_a163;
1139 ddp_line_int_rec.inventory_item_segment2 := p3_a164;
1140 ddp_line_int_rec.inventory_item_segment3 := p3_a165;
1141 ddp_line_int_rec.inventory_item_segment4 := p3_a166;
1142 ddp_line_int_rec.inventory_item_segment5 := p3_a167;
1143 ddp_line_int_rec.inventory_item_segment6 := p3_a168;
1144 ddp_line_int_rec.inventory_item_segment7 := p3_a169;
1145 ddp_line_int_rec.inventory_item_segment8 := p3_a170;
1146 ddp_line_int_rec.inventory_item_segment9 := p3_a171;
1147 ddp_line_int_rec.inventory_item_segment10 := p3_a172;
1148 ddp_line_int_rec.inventory_item_segment11 := p3_a173;
1149 ddp_line_int_rec.inventory_item_segment12 := p3_a174;
1150 ddp_line_int_rec.inventory_item_segment13 := p3_a175;
1151 ddp_line_int_rec.inventory_item_segment14 := p3_a176;
1152 ddp_line_int_rec.inventory_item_segment15 := p3_a177;
1153 ddp_line_int_rec.inventory_item_segment16 := p3_a178;
1154 ddp_line_int_rec.inventory_item_segment17 := p3_a179;
1155 ddp_line_int_rec.inventory_item_segment18 := p3_a180;
1156 ddp_line_int_rec.inventory_item_segment19 := p3_a181;
1157 ddp_line_int_rec.inventory_item_segment20 := p3_a182;
1158 ddp_line_int_rec.product_category_id := p3_a183;
1159 ddp_line_int_rec.category_name := p3_a184;
1160 ddp_line_int_rec.duplicated_line_id := p3_a185;
1161 ddp_line_int_rec.duplicated_adjustment_id := p3_a186;
1162 ddp_line_int_rec.response_type := p3_a187;
1163 ddp_line_int_rec.response_code := p3_a188;
1164 ddp_line_int_rec.reject_reason_code := p3_a189;
1165 ddp_line_int_rec.followup_action_code := p3_a190;
1166 ddp_line_int_rec.net_adjusted_amount := p3_a191;
1167 ddp_line_int_rec.dispute_code := p3_a192;
1168 ddp_line_int_rec.header_attribute_category := p3_a193;
1169 ddp_line_int_rec.header_attribute1 := p3_a194;
1170 ddp_line_int_rec.header_attribute2 := p3_a195;
1171 ddp_line_int_rec.header_attribute3 := p3_a196;
1172 ddp_line_int_rec.header_attribute4 := p3_a197;
1173 ddp_line_int_rec.header_attribute5 := p3_a198;
1174 ddp_line_int_rec.header_attribute6 := p3_a199;
1175 ddp_line_int_rec.header_attribute7 := p3_a200;
1176 ddp_line_int_rec.header_attribute8 := p3_a201;
1177 ddp_line_int_rec.header_attribute9 := p3_a202;
1178 ddp_line_int_rec.header_attribute10 := p3_a203;
1179 ddp_line_int_rec.header_attribute11 := p3_a204;
1180 ddp_line_int_rec.header_attribute12 := p3_a205;
1181 ddp_line_int_rec.header_attribute13 := p3_a206;
1182 ddp_line_int_rec.header_attribute14 := p3_a207;
1183 ddp_line_int_rec.header_attribute15 := p3_a208;
1184 ddp_line_int_rec.line_attribute_category := p3_a209;
1185 ddp_line_int_rec.line_attribute1 := p3_a210;
1186 ddp_line_int_rec.line_attribute2 := p3_a211;
1187 ddp_line_int_rec.line_attribute3 := p3_a212;
1188 ddp_line_int_rec.line_attribute4 := p3_a213;
1189 ddp_line_int_rec.line_attribute5 := p3_a214;
1190 ddp_line_int_rec.line_attribute6 := p3_a215;
1191 ddp_line_int_rec.line_attribute7 := p3_a216;
1192 ddp_line_int_rec.line_attribute8 := p3_a217;
1193 ddp_line_int_rec.line_attribute9 := p3_a218;
1194 ddp_line_int_rec.line_attribute10 := p3_a219;
1195 ddp_line_int_rec.line_attribute11 := p3_a220;
1196 ddp_line_int_rec.line_attribute12 := p3_a221;
1197 ddp_line_int_rec.line_attribute13 := p3_a222;
1198 ddp_line_int_rec.line_attribute14 := p3_a223;
1199 ddp_line_int_rec.line_attribute15 := p3_a224;
1200 ddp_line_int_rec.org_id := p3_a225;
1201
1202
1203
1204
1205
1206 -- here's the delegated call to the old PL/SQL routine
1207 ozf_sales_transactions_pvt.validate_inventory_level(p_api_version,
1208 p_init_msg_list,
1209 p_validation_level,
1210 ddp_line_int_rec,
1211 ddx_valid,
1212 x_return_status,
1213 x_msg_count,
1214 x_msg_data);
1215
1216 -- copy data back from the local variables to OUT or IN-OUT args, if any
1217
1218
1219
1220
1221 if ddx_valid is null
1222 then x_valid := null;
1223 elsif ddx_valid
1224 then x_valid := 1;
1225 else x_valid := 0;
1226 end if;
1227
1228
1229
1230 end;
1231
1232 end ozf_sales_transactions_pvt_w;