[Home] [Help]
PACKAGE BODY: APPS.INV_TRANSACTION_FLOW_PUB_W
Source
1 package body inv_transaction_flow_pub_w as
2 /* $Header: INVWICTB.pls 115.1 2003/12/18 16:13:46 sthamman noship $ */
3 procedure rosetta_table_copy_in_p9(t out nocopy inv_transaction_flow_pub.g_transaction_flow_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_NUMBER_TABLE
13 , a10 JTF_NUMBER_TABLE
14 , a11 JTF_DATE_TABLE
15 , a12 JTF_DATE_TABLE
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_NUMBER_TABLE
25 , a22 JTF_NUMBER_TABLE
26 , a23 JTF_VARCHAR2_TABLE_100
27 , a24 JTF_NUMBER_TABLE
28 , a25 JTF_NUMBER_TABLE
29 ) as
30 ddindx binary_integer; indx binary_integer;
31 begin
32 if a0 is not null and a0.count > 0 then
33 if a0.count > 0 then
34 indx := a0.first;
35 ddindx := 1;
36 while true loop
37 t(ddindx).header_id := a0(indx);
38 t(ddindx).start_org_id := a1(indx);
39 t(ddindx).end_org_id := a2(indx);
40 t(ddindx).organization_id := a3(indx);
41 t(ddindx).line_number := a4(indx);
42 t(ddindx).from_org_id := a5(indx);
43 t(ddindx).from_organization_id := a6(indx);
44 t(ddindx).to_org_id := a7(indx);
45 t(ddindx).to_organization_id := a8(indx);
46 t(ddindx).asset_item_pricing_option := a9(indx);
47 t(ddindx).expense_item_pricing_option := a10(indx);
48 t(ddindx).start_date := a11(indx);
49 t(ddindx).end_date := a12(indx);
50 t(ddindx).customer_id := a13(indx);
51 t(ddindx).address_id := a14(indx);
52 t(ddindx).customer_site_id := a15(indx);
53 t(ddindx).cust_trx_type_id := a16(indx);
54 t(ddindx).vendor_id := a17(indx);
55 t(ddindx).vendor_site_id := a18(indx);
56 t(ddindx).freight_code_combination_id := a19(indx);
57 t(ddindx).inventory_accrual_account_id := a20(indx);
58 t(ddindx).expense_accrual_account_id := a21(indx);
59 t(ddindx).intercompany_cogs_account_id := a22(indx);
60 t(ddindx).new_accounting_flag := a23(indx);
61 t(ddindx).from_org_cost_group_id := a24(indx);
62 t(ddindx).to_org_cost_group_id := a25(indx);
63 ddindx := ddindx+1;
64 if a0.last =indx
65 then exit;
66 end if;
67 indx := a0.next(indx);
68 end loop;
69 end if;
70 end if;
71 end rosetta_table_copy_in_p9;
72 procedure rosetta_table_copy_out_p9(t inv_transaction_flow_pub.g_transaction_flow_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
73 , a1 out nocopy JTF_NUMBER_TABLE
74 , a2 out nocopy JTF_NUMBER_TABLE
75 , a3 out nocopy JTF_NUMBER_TABLE
76 , a4 out nocopy JTF_NUMBER_TABLE
77 , a5 out nocopy JTF_NUMBER_TABLE
78 , a6 out nocopy JTF_NUMBER_TABLE
79 , a7 out nocopy JTF_NUMBER_TABLE
80 , a8 out nocopy JTF_NUMBER_TABLE
81 , a9 out nocopy JTF_NUMBER_TABLE
82 , a10 out nocopy JTF_NUMBER_TABLE
83 , a11 out nocopy JTF_DATE_TABLE
84 , a12 out nocopy JTF_DATE_TABLE
85 , a13 out nocopy JTF_NUMBER_TABLE
86 , a14 out nocopy JTF_NUMBER_TABLE
87 , a15 out nocopy JTF_NUMBER_TABLE
88 , a16 out nocopy JTF_NUMBER_TABLE
89 , a17 out nocopy JTF_NUMBER_TABLE
90 , a18 out nocopy JTF_NUMBER_TABLE
91 , a19 out nocopy JTF_NUMBER_TABLE
92 , a20 out nocopy JTF_NUMBER_TABLE
93 , a21 out nocopy JTF_NUMBER_TABLE
94 , a22 out nocopy JTF_NUMBER_TABLE
95 , a23 out nocopy JTF_VARCHAR2_TABLE_100
96 , a24 out nocopy JTF_NUMBER_TABLE
97 , a25 out nocopy JTF_NUMBER_TABLE
98 ) as
99 ddindx binary_integer; indx binary_integer;
100 begin
101 if t is null or t.count = 0 then
102 a0 := JTF_NUMBER_TABLE();
103 a1 := JTF_NUMBER_TABLE();
104 a2 := JTF_NUMBER_TABLE();
105 a3 := JTF_NUMBER_TABLE();
106 a4 := JTF_NUMBER_TABLE();
107 a5 := JTF_NUMBER_TABLE();
108 a6 := JTF_NUMBER_TABLE();
109 a7 := JTF_NUMBER_TABLE();
110 a8 := JTF_NUMBER_TABLE();
111 a9 := JTF_NUMBER_TABLE();
112 a10 := JTF_NUMBER_TABLE();
113 a11 := JTF_DATE_TABLE();
114 a12 := JTF_DATE_TABLE();
115 a13 := JTF_NUMBER_TABLE();
116 a14 := JTF_NUMBER_TABLE();
117 a15 := JTF_NUMBER_TABLE();
118 a16 := JTF_NUMBER_TABLE();
119 a17 := JTF_NUMBER_TABLE();
120 a18 := JTF_NUMBER_TABLE();
121 a19 := JTF_NUMBER_TABLE();
122 a20 := JTF_NUMBER_TABLE();
123 a21 := JTF_NUMBER_TABLE();
124 a22 := JTF_NUMBER_TABLE();
125 a23 := JTF_VARCHAR2_TABLE_100();
126 a24 := JTF_NUMBER_TABLE();
127 a25 := JTF_NUMBER_TABLE();
128 else
129 a0 := JTF_NUMBER_TABLE();
130 a1 := JTF_NUMBER_TABLE();
131 a2 := JTF_NUMBER_TABLE();
132 a3 := JTF_NUMBER_TABLE();
133 a4 := JTF_NUMBER_TABLE();
134 a5 := JTF_NUMBER_TABLE();
135 a6 := JTF_NUMBER_TABLE();
136 a7 := JTF_NUMBER_TABLE();
137 a8 := JTF_NUMBER_TABLE();
138 a9 := JTF_NUMBER_TABLE();
139 a10 := JTF_NUMBER_TABLE();
140 a11 := JTF_DATE_TABLE();
141 a12 := JTF_DATE_TABLE();
142 a13 := JTF_NUMBER_TABLE();
143 a14 := JTF_NUMBER_TABLE();
144 a15 := JTF_NUMBER_TABLE();
145 a16 := JTF_NUMBER_TABLE();
146 a17 := JTF_NUMBER_TABLE();
147 a18 := JTF_NUMBER_TABLE();
148 a19 := JTF_NUMBER_TABLE();
149 a20 := JTF_NUMBER_TABLE();
150 a21 := JTF_NUMBER_TABLE();
151 a22 := JTF_NUMBER_TABLE();
152 a23 := JTF_VARCHAR2_TABLE_100();
153 a24 := JTF_NUMBER_TABLE();
154 a25 := JTF_NUMBER_TABLE();
155 if t.count > 0 then
156 a0.extend(t.count);
157 a1.extend(t.count);
158 a2.extend(t.count);
159 a3.extend(t.count);
160 a4.extend(t.count);
161 a5.extend(t.count);
162 a6.extend(t.count);
163 a7.extend(t.count);
164 a8.extend(t.count);
165 a9.extend(t.count);
166 a10.extend(t.count);
167 a11.extend(t.count);
168 a12.extend(t.count);
169 a13.extend(t.count);
170 a14.extend(t.count);
171 a15.extend(t.count);
172 a16.extend(t.count);
173 a17.extend(t.count);
174 a18.extend(t.count);
175 a19.extend(t.count);
176 a20.extend(t.count);
177 a21.extend(t.count);
178 a22.extend(t.count);
179 a23.extend(t.count);
180 a24.extend(t.count);
181 a25.extend(t.count);
182 ddindx := t.first;
183 indx := 1;
184 while true loop
185 a0(indx) := t(ddindx).header_id;
186 a1(indx) := t(ddindx).start_org_id;
187 a2(indx) := t(ddindx).end_org_id;
188 a3(indx) := t(ddindx).organization_id;
189 a4(indx) := t(ddindx).line_number;
190 a5(indx) := t(ddindx).from_org_id;
191 a6(indx) := t(ddindx).from_organization_id;
192 a7(indx) := t(ddindx).to_org_id;
193 a8(indx) := t(ddindx).to_organization_id;
194 a9(indx) := t(ddindx).asset_item_pricing_option;
195 a10(indx) := t(ddindx).expense_item_pricing_option;
196 a11(indx) := t(ddindx).start_date;
197 a12(indx) := t(ddindx).end_date;
198 a13(indx) := t(ddindx).customer_id;
199 a14(indx) := t(ddindx).address_id;
200 a15(indx) := t(ddindx).customer_site_id;
201 a16(indx) := t(ddindx).cust_trx_type_id;
202 a17(indx) := t(ddindx).vendor_id;
203 a18(indx) := t(ddindx).vendor_site_id;
204 a19(indx) := t(ddindx).freight_code_combination_id;
205 a20(indx) := t(ddindx).inventory_accrual_account_id;
206 a21(indx) := t(ddindx).expense_accrual_account_id;
207 a22(indx) := t(ddindx).intercompany_cogs_account_id;
208 a23(indx) := t(ddindx).new_accounting_flag;
209 a24(indx) := t(ddindx).from_org_cost_group_id;
210 a25(indx) := t(ddindx).to_org_cost_group_id;
211 indx := indx+1;
212 if t.last =ddindx
213 then exit;
214 end if;
215 ddindx := t.next(ddindx);
216 end loop;
217 end if;
218 end if;
219 end rosetta_table_copy_out_p9;
220
221 procedure rosetta_table_copy_in_p10(t out nocopy inv_transaction_flow_pub.number_tbl, a0 JTF_NUMBER_TABLE) as
222 ddindx binary_integer; indx binary_integer;
223 begin
224 if a0 is not null and a0.count > 0 then
225 if a0.count > 0 then
226 indx := a0.first;
227 ddindx := 1;
228 while true loop
229 t(ddindx) := a0(indx);
230 ddindx := ddindx+1;
231 if a0.last =indx
232 then exit;
233 end if;
234 indx := a0.next(indx);
235 end loop;
236 end if;
237 end if;
238 end rosetta_table_copy_in_p10;
239 procedure rosetta_table_copy_out_p10(t inv_transaction_flow_pub.number_tbl, a0 out nocopy JTF_NUMBER_TABLE) as
240 ddindx binary_integer; indx binary_integer;
241 begin
242 if t is null or t.count = 0 then
243 a0 := JTF_NUMBER_TABLE();
244 else
245 a0 := JTF_NUMBER_TABLE();
246 if t.count > 0 then
247 a0.extend(t.count);
248 ddindx := t.first;
249 indx := 1;
250 while true loop
251 a0(indx) := t(ddindx);
252 indx := indx+1;
253 if t.last =ddindx
254 then exit;
255 end if;
256 ddindx := t.next(ddindx);
257 end loop;
258 end if;
259 end if;
260 end rosetta_table_copy_out_p10;
261
262 procedure rosetta_table_copy_in_p11(t out nocopy inv_transaction_flow_pub.varchar2_tbl, a0 JTF_VARCHAR2_TABLE_200) as
263 ddindx binary_integer; indx binary_integer;
264 begin
265 if a0 is not null and a0.count > 0 then
266 if a0.count > 0 then
267 indx := a0.first;
268 ddindx := 1;
269 while true loop
270 t(ddindx) := a0(indx);
271 ddindx := ddindx+1;
272 if a0.last =indx
273 then exit;
274 end if;
275 indx := a0.next(indx);
276 end loop;
277 end if;
278 end if;
279 end rosetta_table_copy_in_p11;
280 procedure rosetta_table_copy_out_p11(t inv_transaction_flow_pub.varchar2_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_200) as
281 ddindx binary_integer; indx binary_integer;
282 begin
283 if t is null or t.count = 0 then
284 a0 := JTF_VARCHAR2_TABLE_200();
285 else
286 a0 := JTF_VARCHAR2_TABLE_200();
287 if t.count > 0 then
288 a0.extend(t.count);
289 ddindx := t.first;
290 indx := 1;
291 while true loop
292 a0(indx) := t(ddindx);
293 indx := indx+1;
294 if t.last =ddindx
295 then exit;
296 end if;
297 ddindx := t.next(ddindx);
298 end loop;
299 end if;
300 end if;
301 end rosetta_table_copy_out_p11;
302
303 procedure get_transaction_flow(x_return_status out nocopy VARCHAR2
304 , x_msg_data out nocopy VARCHAR2
305 , x_msg_count out nocopy NUMBER
306 , p3_a0 out nocopy JTF_NUMBER_TABLE
307 , p3_a1 out nocopy JTF_NUMBER_TABLE
308 , p3_a2 out nocopy JTF_NUMBER_TABLE
309 , p3_a3 out nocopy JTF_NUMBER_TABLE
310 , p3_a4 out nocopy JTF_NUMBER_TABLE
311 , p3_a5 out nocopy JTF_NUMBER_TABLE
312 , p3_a6 out nocopy JTF_NUMBER_TABLE
313 , p3_a7 out nocopy JTF_NUMBER_TABLE
314 , p3_a8 out nocopy JTF_NUMBER_TABLE
315 , p3_a9 out nocopy JTF_NUMBER_TABLE
316 , p3_a10 out nocopy JTF_NUMBER_TABLE
317 , p3_a11 out nocopy JTF_DATE_TABLE
318 , p3_a12 out nocopy JTF_DATE_TABLE
319 , p3_a13 out nocopy JTF_NUMBER_TABLE
320 , p3_a14 out nocopy JTF_NUMBER_TABLE
321 , p3_a15 out nocopy JTF_NUMBER_TABLE
322 , p3_a16 out nocopy JTF_NUMBER_TABLE
323 , p3_a17 out nocopy JTF_NUMBER_TABLE
324 , p3_a18 out nocopy JTF_NUMBER_TABLE
325 , p3_a19 out nocopy JTF_NUMBER_TABLE
326 , p3_a20 out nocopy JTF_NUMBER_TABLE
327 , p3_a21 out nocopy JTF_NUMBER_TABLE
328 , p3_a22 out nocopy JTF_NUMBER_TABLE
329 , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
330 , p3_a24 out nocopy JTF_NUMBER_TABLE
331 , p3_a25 out nocopy JTF_NUMBER_TABLE
332 , p_api_version NUMBER
333 , p_init_msg_list VARCHAR2
334 , p_start_operating_unit NUMBER
335 , p_end_operating_unit NUMBER
336 , p_flow_type NUMBER
337 , p_organization_id NUMBER
338 , p_qualifier_code_tbl JTF_NUMBER_TABLE
339 , p_qualifier_value_tbl JTF_NUMBER_TABLE
340 , p_transaction_date DATE
341 , p_get_default_cost_group VARCHAR2
342 )
343
344 as
345 ddx_transaction_flows_tbl inv_transaction_flow_pub.g_transaction_flow_tbl_type;
346 ddp_qualifier_code_tbl inv_transaction_flow_pub.number_tbl;
347 ddp_qualifier_value_tbl inv_transaction_flow_pub.number_tbl;
348 ddindx binary_integer; indx binary_integer;
349 begin
350
351 -- copy data to the local IN or IN-OUT args, if any
352
353 inv_transaction_flow_pub_w.rosetta_table_copy_in_p10(ddp_qualifier_code_tbl, p_qualifier_code_tbl);
354
355 inv_transaction_flow_pub_w.rosetta_table_copy_in_p10(ddp_qualifier_value_tbl, p_qualifier_value_tbl);
356
357 -- here's the delegated call to the old PL/SQL routine
358 inv_transaction_flow_pub.get_transaction_flow(x_return_status,
359 x_msg_data,
360 x_msg_count,
361 ddx_transaction_flows_tbl,
362 p_api_version,
363 p_init_msg_list,
364 p_start_operating_unit,
368 ddp_qualifier_code_tbl,
365 p_end_operating_unit,
366 p_flow_type,
367 p_organization_id,
369 ddp_qualifier_value_tbl,
370 p_transaction_date,
371 p_get_default_cost_group);
372
373 -- copy data back from the local variables to OUT or IN-OUT args, if any
374
375 inv_transaction_flow_pub_w.rosetta_table_copy_out_p9(ddx_transaction_flows_tbl, p3_a0
376 , p3_a1
377 , p3_a2
378 , p3_a3
379 , p3_a4
380 , p3_a5
381 , p3_a6
382 , p3_a7
383 , p3_a8
384 , p3_a9
385 , p3_a10
386 , p3_a11
387 , p3_a12
388 , p3_a13
389 , p3_a14
390 , p3_a15
391 , p3_a16
392 , p3_a17
393 , p3_a18
394 , p3_a19
395 , p3_a20
396 , p3_a21
397 , p3_a22
398 , p3_a23
399 , p3_a24
400 , p3_a25
401 );
402
403 end;
404
405 procedure get_transaction_flow(x_return_status out nocopy VARCHAR2
406 , x_msg_data out nocopy VARCHAR2
407 , x_msg_count out nocopy NUMBER
408 , p3_a0 out nocopy JTF_NUMBER_TABLE
409 , p3_a1 out nocopy JTF_NUMBER_TABLE
410 , p3_a2 out nocopy JTF_NUMBER_TABLE
411 , p3_a3 out nocopy JTF_NUMBER_TABLE
412 , p3_a4 out nocopy JTF_NUMBER_TABLE
413 , p3_a5 out nocopy JTF_NUMBER_TABLE
414 , p3_a6 out nocopy JTF_NUMBER_TABLE
415 , p3_a7 out nocopy JTF_NUMBER_TABLE
416 , p3_a8 out nocopy JTF_NUMBER_TABLE
417 , p3_a9 out nocopy JTF_NUMBER_TABLE
418 , p3_a10 out nocopy JTF_NUMBER_TABLE
419 , p3_a11 out nocopy JTF_DATE_TABLE
420 , p3_a12 out nocopy JTF_DATE_TABLE
421 , p3_a13 out nocopy JTF_NUMBER_TABLE
422 , p3_a14 out nocopy JTF_NUMBER_TABLE
423 , p3_a15 out nocopy JTF_NUMBER_TABLE
424 , p3_a16 out nocopy JTF_NUMBER_TABLE
425 , p3_a17 out nocopy JTF_NUMBER_TABLE
426 , p3_a18 out nocopy JTF_NUMBER_TABLE
427 , p3_a19 out nocopy JTF_NUMBER_TABLE
428 , p3_a20 out nocopy JTF_NUMBER_TABLE
429 , p3_a21 out nocopy JTF_NUMBER_TABLE
430 , p3_a22 out nocopy JTF_NUMBER_TABLE
431 , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
432 , p3_a24 out nocopy JTF_NUMBER_TABLE
433 , p3_a25 out nocopy JTF_NUMBER_TABLE
434 , p_api_version NUMBER
435 , p_init_msg_list VARCHAR2
436 , p_header_id NUMBER
437 , p_get_default_cost_group VARCHAR2
438 )
439
440 as
441 ddx_transaction_flows_tbl inv_transaction_flow_pub.g_transaction_flow_tbl_type;
442 ddindx binary_integer; indx binary_integer;
443 begin
444
445 -- copy data to the local IN or IN-OUT args, if any
446
447 -- here's the delegated call to the old PL/SQL routine
448 inv_transaction_flow_pub.get_transaction_flow(x_return_status,
449 x_msg_data,
450 x_msg_count,
451 ddx_transaction_flows_tbl,
452 p_api_version,
453 p_init_msg_list,
454 p_header_id,
455 p_get_default_cost_group);
456
457 -- copy data back from the local variables to OUT or IN-OUT args, if any
458
459 inv_transaction_flow_pub_w.rosetta_table_copy_out_p9(ddx_transaction_flows_tbl, p3_a0
460 , p3_a1
461 , p3_a2
462 , p3_a3
463 , p3_a4
464 , p3_a5
465 , p3_a6
466 , p3_a7
467 , p3_a8
468 , p3_a9
469 , p3_a10
470 , p3_a11
471 , p3_a12
472 , p3_a13
473 , p3_a14
474 , p3_a15
475 , p3_a16
476 , p3_a17
477 , p3_a18
478 , p3_a19
479 , p3_a20
480 , p3_a21
481 , p3_a22
482 , p3_a23
483 , p3_a24
484 , p3_a25
485 );
486
487 end;
488
489 procedure check_transaction_flow(p_api_version NUMBER
490 , p_init_msg_list VARCHAR2
491 , p_start_operating_unit NUMBER
492 , p_end_operating_unit NUMBER
493 , p_flow_type NUMBER
494 , p_organization_id NUMBER
495 , p_qualifier_code_tbl JTF_NUMBER_TABLE
496 , p_qualifier_value_tbl JTF_NUMBER_TABLE
497 , p_transaction_date DATE
498 , x_return_status out nocopy VARCHAR2
499 , x_msg_count out nocopy NUMBER
500 , x_msg_data out nocopy VARCHAR2
501 , x_header_id out nocopy NUMBER
502 , x_new_accounting_flag out nocopy VARCHAR2
503 , x_transaction_flow_exists out nocopy VARCHAR2
504 )
505
506 as
507 ddp_qualifier_code_tbl inv_transaction_flow_pub.number_tbl;
508 ddp_qualifier_value_tbl inv_transaction_flow_pub.number_tbl;
509 ddindx binary_integer; indx binary_integer;
510 begin
511
512 -- copy data to the local IN or IN-OUT args, if any
513
514 inv_transaction_flow_pub_w.rosetta_table_copy_in_p10(ddp_qualifier_code_tbl, p_qualifier_code_tbl);
515
516 inv_transaction_flow_pub_w.rosetta_table_copy_in_p10(ddp_qualifier_value_tbl, p_qualifier_value_tbl);
517
518 -- here's the delegated call to the old PL/SQL routine
519 inv_transaction_flow_pub.check_transaction_flow(p_api_version,
520 p_init_msg_list,
521 p_start_operating_unit,
522 p_end_operating_unit,
523 p_flow_type,
524 p_organization_id,
525 ddp_qualifier_code_tbl,
526 ddp_qualifier_value_tbl,
527 p_transaction_date,
528 x_return_status,
529 x_msg_count,
530 x_msg_data,
531 x_header_id,
532 x_new_accounting_flag,
533 x_transaction_flow_exists);
534
538
535 -- copy data back from the local variables to OUT or IN-OUT args, if any
536
537 end;
539 procedure create_transaction_flow(x_return_status out nocopy VARCHAR2
540 , x_msg_data out nocopy VARCHAR2
541 , x_msg_count out nocopy NUMBER
542 , x_header_id out nocopy NUMBER
543 , x_line_number_tbl out nocopy JTF_NUMBER_TABLE
544 , p_api_version NUMBER
545 , p_init_msg_list VARCHAR2
546 , p_validation_level NUMBER
547 , p_start_org_id NUMBER
548 , p_end_org_id NUMBER
549 , p_flow_type NUMBER
550 , p_organization_id NUMBER
551 , p_qualifier_code NUMBER
552 , p_qualifier_value_id NUMBER
553 , p_asset_item_pricing_option NUMBER
554 , p_expense_item_pricing_option NUMBER
555 , p_new_accounting_flag VARCHAR2
556 , p_start_date DATE
557 , p_end_date DATE
558 , p_attribute_category VARCHAR2
559 , p_attribute1 VARCHAR2
560 , p_attribute2 VARCHAR2
561 , p_attribute3 VARCHAR2
562 , p_attribute4 VARCHAR2
563 , p_attribute5 VARCHAR2
564 , p_attribute6 VARCHAR2
565 , p_attribute7 VARCHAR2
566 , p_attribute8 VARCHAR2
567 , p_attribute9 VARCHAR2
568 , p_attribute10 VARCHAR2
569 , p_attribute11 VARCHAR2
570 , p_attribute12 VARCHAR2
571 , p_attribute13 VARCHAR2
572 , p_attribute14 VARCHAR2
573 , p_attribute15 VARCHAR2
574 , p_line_number_tbl JTF_NUMBER_TABLE
575 , p_from_org_id_tbl JTF_NUMBER_TABLE
576 , p_from_organization_id_tbl JTF_NUMBER_TABLE
577 , p_to_org_id_tbl JTF_NUMBER_TABLE
578 , p_to_organization_id_tbl JTF_NUMBER_TABLE
579 , p_line_attribute_category_tbl JTF_VARCHAR2_TABLE_200
580 , p_line_attribute1_tbl JTF_VARCHAR2_TABLE_200
581 , p_line_attribute2_tbl JTF_VARCHAR2_TABLE_200
582 , p_line_attribute3_tbl JTF_VARCHAR2_TABLE_200
583 , p_line_attribute4_tbl JTF_VARCHAR2_TABLE_200
584 , p_line_attribute5_tbl JTF_VARCHAR2_TABLE_200
585 , p_line_attribute6_tbl JTF_VARCHAR2_TABLE_200
586 , p_line_attribute7_tbl JTF_VARCHAR2_TABLE_200
587 , p_line_attribute8_tbl JTF_VARCHAR2_TABLE_200
588 , p_line_attribute9_tbl JTF_VARCHAR2_TABLE_200
589 , p_line_attribute10_tbl JTF_VARCHAR2_TABLE_200
590 , p_line_attribute11_tbl JTF_VARCHAR2_TABLE_200
591 , p_line_attribute12_tbl JTF_VARCHAR2_TABLE_200
592 , p_line_attribute13_tbl JTF_VARCHAR2_TABLE_200
593 , p_line_attribute14_tbl JTF_VARCHAR2_TABLE_200
594 , p_line_attribute15_tbl JTF_VARCHAR2_TABLE_200
595 , p_ship_organization_id_tbl JTF_NUMBER_TABLE
596 , p_sell_organization_id_tbl JTF_NUMBER_TABLE
597 , p_vendor_id_tbl JTF_NUMBER_TABLE
598 , p_vendor_site_id_tbl JTF_NUMBER_TABLE
599 , p_customer_id_tbl JTF_NUMBER_TABLE
600 , p_address_id_tbl JTF_NUMBER_TABLE
601 , p_customer_site_id_tbl JTF_NUMBER_TABLE
602 , p_cust_trx_type_id_tbl JTF_NUMBER_TABLE
603 , p_ic_attribute_category_tbl JTF_VARCHAR2_TABLE_200
604 , p_ic_attribute1_tbl JTF_VARCHAR2_TABLE_200
605 , p_ic_attribute2_tbl JTF_VARCHAR2_TABLE_200
606 , p_ic_attribute3_tbl JTF_VARCHAR2_TABLE_200
607 , p_ic_attribute4_tbl JTF_VARCHAR2_TABLE_200
608 , p_ic_attribute5_tbl JTF_VARCHAR2_TABLE_200
609 , p_ic_attribute6_tbl JTF_VARCHAR2_TABLE_200
610 , p_ic_attribute7_tbl JTF_VARCHAR2_TABLE_200
611 , p_ic_attribute8_tbl JTF_VARCHAR2_TABLE_200
612 , p_ic_attribute9_tbl JTF_VARCHAR2_TABLE_200
613 , p_ic_attribute10_tbl JTF_VARCHAR2_TABLE_200
614 , p_ic_attribute11_tbl JTF_VARCHAR2_TABLE_200
615 , p_ic_attribute12_tbl JTF_VARCHAR2_TABLE_200
616 , p_ic_attribute13_tbl JTF_VARCHAR2_TABLE_200
617 , p_ic_attribute14_tbl JTF_VARCHAR2_TABLE_200
618 , p_ic_attribute15_tbl JTF_VARCHAR2_TABLE_200
619 , p_revalue_average_flag_tbl JTF_VARCHAR2_TABLE_200
620 , p_freight_code_comb_id_tbl JTF_NUMBER_TABLE
621 , p_inv_currency_code_tbl JTF_NUMBER_TABLE
622 , p_ic_cogs_acct_id_tbl JTF_NUMBER_TABLE
623 , p_inv_accrual_acct_id_tbl JTF_NUMBER_TABLE
624 , p_exp_accrual_acct_id_tbl JTF_NUMBER_TABLE
625 )
626
627 as
628 ddx_line_number_tbl inv_transaction_flow_pub.number_tbl;
629 ddp_line_number_tbl inv_transaction_flow_pub.number_tbl;
630 ddp_from_org_id_tbl inv_transaction_flow_pub.number_tbl;
631 ddp_from_organization_id_tbl inv_transaction_flow_pub.number_tbl;
632 ddp_to_org_id_tbl inv_transaction_flow_pub.number_tbl;
633 ddp_to_organization_id_tbl inv_transaction_flow_pub.number_tbl;
634 ddp_line_attr_category_tbl inv_transaction_flow_pub.varchar2_tbl;
635 ddp_line_attribute1_tbl inv_transaction_flow_pub.varchar2_tbl;
636 ddp_line_attribute2_tbl inv_transaction_flow_pub.varchar2_tbl;
637 ddp_line_attribute3_tbl inv_transaction_flow_pub.varchar2_tbl;
638 ddp_line_attribute4_tbl inv_transaction_flow_pub.varchar2_tbl;
639 ddp_line_attribute5_tbl inv_transaction_flow_pub.varchar2_tbl;
640 ddp_line_attribute6_tbl inv_transaction_flow_pub.varchar2_tbl;
641 ddp_line_attribute7_tbl inv_transaction_flow_pub.varchar2_tbl;
642 ddp_line_attribute8_tbl inv_transaction_flow_pub.varchar2_tbl;
643 ddp_line_attribute9_tbl inv_transaction_flow_pub.varchar2_tbl;
644 ddp_line_attribute10_tbl inv_transaction_flow_pub.varchar2_tbl;
645 ddp_line_attribute11_tbl inv_transaction_flow_pub.varchar2_tbl;
646 ddp_line_attribute12_tbl inv_transaction_flow_pub.varchar2_tbl;
647 ddp_line_attribute13_tbl inv_transaction_flow_pub.varchar2_tbl;
648 ddp_line_attribute14_tbl inv_transaction_flow_pub.varchar2_tbl;
649 ddp_line_attribute15_tbl inv_transaction_flow_pub.varchar2_tbl;
650 ddp_ship_organization_id_tbl inv_transaction_flow_pub.number_tbl;
651 ddp_sell_organization_id_tbl inv_transaction_flow_pub.number_tbl;
652 ddp_vendor_id_tbl inv_transaction_flow_pub.number_tbl;
653 ddp_vendor_site_id_tbl inv_transaction_flow_pub.number_tbl;
657 ddp_cust_trx_type_id_tbl inv_transaction_flow_pub.number_tbl;
654 ddp_customer_id_tbl inv_transaction_flow_pub.number_tbl;
655 ddp_address_id_tbl inv_transaction_flow_pub.number_tbl;
656 ddp_customer_site_id_tbl inv_transaction_flow_pub.number_tbl;
658 ddp_ic_attribute_category_tbl inv_transaction_flow_pub.varchar2_tbl;
659 ddp_ic_attribute1_tbl inv_transaction_flow_pub.varchar2_tbl;
660 ddp_ic_attribute2_tbl inv_transaction_flow_pub.varchar2_tbl;
661 ddp_ic_attribute3_tbl inv_transaction_flow_pub.varchar2_tbl;
662 ddp_ic_attribute4_tbl inv_transaction_flow_pub.varchar2_tbl;
663 ddp_ic_attribute5_tbl inv_transaction_flow_pub.varchar2_tbl;
664 ddp_ic_attribute6_tbl inv_transaction_flow_pub.varchar2_tbl;
665 ddp_ic_attribute7_tbl inv_transaction_flow_pub.varchar2_tbl;
666 ddp_ic_attribute8_tbl inv_transaction_flow_pub.varchar2_tbl;
667 ddp_ic_attribute9_tbl inv_transaction_flow_pub.varchar2_tbl;
668 ddp_ic_attribute10_tbl inv_transaction_flow_pub.varchar2_tbl;
669 ddp_ic_attribute11_tbl inv_transaction_flow_pub.varchar2_tbl;
670 ddp_ic_attribute12_tbl inv_transaction_flow_pub.varchar2_tbl;
671 ddp_ic_attribute13_tbl inv_transaction_flow_pub.varchar2_tbl;
672 ddp_ic_attribute14_tbl inv_transaction_flow_pub.varchar2_tbl;
673 ddp_ic_attribute15_tbl inv_transaction_flow_pub.varchar2_tbl;
674 ddp_revalue_average_flag_tbl inv_transaction_flow_pub.varchar2_tbl;
675 ddp_freight_code_comb_id_tbl inv_transaction_flow_pub.number_tbl;
676 ddp_inv_currency_code_tbl inv_transaction_flow_pub.number_tbl;
677 ddp_ic_cogs_acct_id_tbl inv_transaction_flow_pub.number_tbl;
678 ddp_inv_accrual_acct_id_tbl inv_transaction_flow_pub.number_tbl;
679 ddp_exp_accrual_acct_id_tbl inv_transaction_flow_pub.number_tbl;
680 ddindx binary_integer; indx binary_integer;
681 begin
682
683 -- copy data to the local IN or IN-OUT args, if any
684
685 inv_transaction_flow_pub_w.rosetta_table_copy_in_p10(ddp_line_number_tbl, p_line_number_tbl);
686
687 inv_transaction_flow_pub_w.rosetta_table_copy_in_p10(ddp_from_org_id_tbl, p_from_org_id_tbl);
688
689 inv_transaction_flow_pub_w.rosetta_table_copy_in_p10(ddp_from_organization_id_tbl, p_from_organization_id_tbl);
690
691 inv_transaction_flow_pub_w.rosetta_table_copy_in_p10(ddp_to_org_id_tbl, p_to_org_id_tbl);
692
693 inv_transaction_flow_pub_w.rosetta_table_copy_in_p10(ddp_to_organization_id_tbl, p_to_organization_id_tbl);
694
695 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_line_attr_category_tbl, p_line_attribute_category_tbl);
696
697 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_line_attribute1_tbl, p_line_attribute1_tbl);
698
699 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_line_attribute2_tbl, p_line_attribute2_tbl);
700
701 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_line_attribute3_tbl, p_line_attribute3_tbl);
702
703 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_line_attribute4_tbl, p_line_attribute4_tbl);
704
705 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_line_attribute5_tbl, p_line_attribute5_tbl);
706
707 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_line_attribute6_tbl, p_line_attribute6_tbl);
708
709 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_line_attribute7_tbl, p_line_attribute7_tbl);
710
711 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_line_attribute8_tbl, p_line_attribute8_tbl);
712
713 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_line_attribute9_tbl, p_line_attribute9_tbl);
714
715 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_line_attribute10_tbl, p_line_attribute10_tbl);
716
717 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_line_attribute11_tbl, p_line_attribute11_tbl);
718
719 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_line_attribute12_tbl, p_line_attribute12_tbl);
720
721 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_line_attribute13_tbl, p_line_attribute13_tbl);
722
723 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_line_attribute14_tbl, p_line_attribute14_tbl);
724
725 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_line_attribute15_tbl, p_line_attribute15_tbl);
726
727 inv_transaction_flow_pub_w.rosetta_table_copy_in_p10(ddp_ship_organization_id_tbl, p_ship_organization_id_tbl);
728
729 inv_transaction_flow_pub_w.rosetta_table_copy_in_p10(ddp_sell_organization_id_tbl, p_sell_organization_id_tbl);
730
731 inv_transaction_flow_pub_w.rosetta_table_copy_in_p10(ddp_vendor_id_tbl, p_vendor_id_tbl);
732
733 inv_transaction_flow_pub_w.rosetta_table_copy_in_p10(ddp_vendor_site_id_tbl, p_vendor_site_id_tbl);
734
735 inv_transaction_flow_pub_w.rosetta_table_copy_in_p10(ddp_customer_id_tbl, p_customer_id_tbl);
736
737 inv_transaction_flow_pub_w.rosetta_table_copy_in_p10(ddp_address_id_tbl, p_address_id_tbl);
738
739 inv_transaction_flow_pub_w.rosetta_table_copy_in_p10(ddp_customer_site_id_tbl, p_customer_site_id_tbl);
740
741 inv_transaction_flow_pub_w.rosetta_table_copy_in_p10(ddp_cust_trx_type_id_tbl, p_cust_trx_type_id_tbl);
742
743 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_ic_attribute_category_tbl, p_ic_attribute_category_tbl);
744
745 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_ic_attribute1_tbl, p_ic_attribute1_tbl);
746
747 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_ic_attribute2_tbl, p_ic_attribute2_tbl);
748
749 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_ic_attribute3_tbl, p_ic_attribute3_tbl);
750
751 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_ic_attribute4_tbl, p_ic_attribute4_tbl);
752
753 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_ic_attribute5_tbl, p_ic_attribute5_tbl);
754
755 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_ic_attribute6_tbl, p_ic_attribute6_tbl);
756
760
757 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_ic_attribute7_tbl, p_ic_attribute7_tbl);
758
759 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_ic_attribute8_tbl, p_ic_attribute8_tbl);
761 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_ic_attribute9_tbl, p_ic_attribute9_tbl);
762
763 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_ic_attribute10_tbl, p_ic_attribute10_tbl);
764
765 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_ic_attribute11_tbl, p_ic_attribute11_tbl);
766
767 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_ic_attribute12_tbl, p_ic_attribute12_tbl);
768
769 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_ic_attribute13_tbl, p_ic_attribute13_tbl);
770
771 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_ic_attribute14_tbl, p_ic_attribute14_tbl);
772
773 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_ic_attribute15_tbl, p_ic_attribute15_tbl);
774
775 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_revalue_average_flag_tbl, p_revalue_average_flag_tbl);
776
777 inv_transaction_flow_pub_w.rosetta_table_copy_in_p10(ddp_freight_code_comb_id_tbl, p_freight_code_comb_id_tbl);
778
779 inv_transaction_flow_pub_w.rosetta_table_copy_in_p10(ddp_inv_currency_code_tbl, p_inv_currency_code_tbl);
780
781 inv_transaction_flow_pub_w.rosetta_table_copy_in_p10(ddp_ic_cogs_acct_id_tbl, p_ic_cogs_acct_id_tbl);
782
783 inv_transaction_flow_pub_w.rosetta_table_copy_in_p10(ddp_inv_accrual_acct_id_tbl, p_inv_accrual_acct_id_tbl);
784
785 inv_transaction_flow_pub_w.rosetta_table_copy_in_p10(ddp_exp_accrual_acct_id_tbl, p_exp_accrual_acct_id_tbl);
786
787 -- here's the delegated call to the old PL/SQL routine
788 inv_transaction_flow_pub.create_transaction_flow(x_return_status,
789 x_msg_data,
790 x_msg_count,
791 x_header_id,
792 ddx_line_number_tbl,
793 p_api_version,
794 p_init_msg_list,
795 p_validation_level,
796 p_start_org_id,
797 p_end_org_id,
798 p_flow_type,
799 p_organization_id,
800 p_qualifier_code,
801 p_qualifier_value_id,
802 p_asset_item_pricing_option,
803 p_expense_item_pricing_option,
804 p_new_accounting_flag,
805 p_start_date,
806 p_end_date,
807 p_attribute_category,
808 p_attribute1,
809 p_attribute2,
810 p_attribute3,
811 p_attribute4,
812 p_attribute5,
813 p_attribute6,
814 p_attribute7,
815 p_attribute8,
816 p_attribute9,
817 p_attribute10,
818 p_attribute11,
819 p_attribute12,
820 p_attribute13,
821 p_attribute14,
822 p_attribute15,
823 ddp_line_number_tbl,
824 ddp_from_org_id_tbl,
825 ddp_from_organization_id_tbl,
826 ddp_to_org_id_tbl,
827 ddp_to_organization_id_tbl,
828 ddp_line_attr_category_tbl,
829 ddp_line_attribute1_tbl,
830 ddp_line_attribute2_tbl,
831 ddp_line_attribute3_tbl,
832 ddp_line_attribute4_tbl,
833 ddp_line_attribute5_tbl,
834 ddp_line_attribute6_tbl,
835 ddp_line_attribute7_tbl,
836 ddp_line_attribute8_tbl,
837 ddp_line_attribute9_tbl,
838 ddp_line_attribute10_tbl,
839 ddp_line_attribute11_tbl,
840 ddp_line_attribute12_tbl,
841 ddp_line_attribute13_tbl,
842 ddp_line_attribute14_tbl,
843 ddp_line_attribute15_tbl,
844 ddp_ship_organization_id_tbl,
845 ddp_sell_organization_id_tbl,
846 ddp_vendor_id_tbl,
847 ddp_vendor_site_id_tbl,
848 ddp_customer_id_tbl,
849 ddp_address_id_tbl,
850 ddp_customer_site_id_tbl,
851 ddp_cust_trx_type_id_tbl,
852 ddp_ic_attribute_category_tbl,
853 ddp_ic_attribute1_tbl,
854 ddp_ic_attribute2_tbl,
855 ddp_ic_attribute3_tbl,
856 ddp_ic_attribute4_tbl,
857 ddp_ic_attribute5_tbl,
858 ddp_ic_attribute6_tbl,
859 ddp_ic_attribute7_tbl,
860 ddp_ic_attribute8_tbl,
861 ddp_ic_attribute9_tbl,
862 ddp_ic_attribute10_tbl,
863 ddp_ic_attribute11_tbl,
864 ddp_ic_attribute12_tbl,
865 ddp_ic_attribute13_tbl,
866 ddp_ic_attribute14_tbl,
867 ddp_ic_attribute15_tbl,
868 ddp_revalue_average_flag_tbl,
869 ddp_freight_code_comb_id_tbl,
870 ddp_inv_currency_code_tbl,
871 ddp_ic_cogs_acct_id_tbl,
872 ddp_inv_accrual_acct_id_tbl,
873 ddp_exp_accrual_acct_id_tbl);
874
875 -- copy data back from the local variables to OUT or IN-OUT args, if any
876
877 inv_transaction_flow_pub_w.rosetta_table_copy_out_p10(ddx_line_number_tbl, x_line_number_tbl);
878
879 end;
880
881 procedure update_transaction_flow(x_return_status out nocopy VARCHAR2
882 , x_msg_data out nocopy VARCHAR2
883 , x_msg_count out nocopy NUMBER
884 , p_api_version NUMBER
885 , p_init_msg_list VARCHAR2
886 , p_validation_level NUMBER
887 , p_header_id NUMBER
888 , p_flow_type NUMBER
889 , p_start_date DATE
890 , p_end_date DATE
891 , p_attribute_category VARCHAR2
892 , p_attribute1 VARCHAR2
893 , p_attribute2 VARCHAR2
894 , p_attribute3 VARCHAR2
895 , p_attribute4 VARCHAR2
896 , p_attribute5 VARCHAR2
897 , p_attribute6 VARCHAR2
898 , p_attribute7 VARCHAR2
899 , p_attribute8 VARCHAR2
900 , p_attribute9 VARCHAR2
901 , p_attribute10 VARCHAR2
902 , p_attribute11 VARCHAR2
903 , p_attribute12 VARCHAR2
904 , p_attribute13 VARCHAR2
908 , p_line_attribute_category_tbl JTF_VARCHAR2_TABLE_200
905 , p_attribute14 VARCHAR2
906 , p_attribute15 VARCHAR2
907 , p_line_number_tbl JTF_NUMBER_TABLE
909 , p_line_attribute1_tbl JTF_VARCHAR2_TABLE_200
910 , p_line_attribute2_tbl JTF_VARCHAR2_TABLE_200
911 , p_line_attribute3_tbl JTF_VARCHAR2_TABLE_200
912 , p_line_attribute4_tbl JTF_VARCHAR2_TABLE_200
913 , p_line_attribute5_tbl JTF_VARCHAR2_TABLE_200
914 , p_line_attribute6_tbl JTF_VARCHAR2_TABLE_200
915 , p_line_attribute7_tbl JTF_VARCHAR2_TABLE_200
916 , p_line_attribute8_tbl JTF_VARCHAR2_TABLE_200
917 , p_line_attribute9_tbl JTF_VARCHAR2_TABLE_200
918 , p_line_attribute10_tbl JTF_VARCHAR2_TABLE_200
919 , p_line_attribute11_tbl JTF_VARCHAR2_TABLE_200
920 , p_line_attribute12_tbl JTF_VARCHAR2_TABLE_200
921 , p_line_attribute13_tbl JTF_VARCHAR2_TABLE_200
922 , p_line_attribute14_tbl JTF_VARCHAR2_TABLE_200
923 , p_line_attribute15_tbl JTF_VARCHAR2_TABLE_200
924 , p_ship_organization_id_tbl JTF_NUMBER_TABLE
925 , p_sell_organization_id_tbl JTF_NUMBER_TABLE
926 , p_vendor_id_tbl JTF_NUMBER_TABLE
927 , p_vendor_site_id_tbl JTF_NUMBER_TABLE
928 , p_customer_id_tbl JTF_NUMBER_TABLE
929 , p_address_id_tbl JTF_NUMBER_TABLE
930 , p_customer_site_id_tbl JTF_NUMBER_TABLE
931 , p_cust_trx_type_id_tbl JTF_NUMBER_TABLE
932 , p_ic_attribute_category_tbl JTF_VARCHAR2_TABLE_200
933 , p_ic_attribute1_tbl JTF_VARCHAR2_TABLE_200
934 , p_ic_attribute2_tbl JTF_VARCHAR2_TABLE_200
935 , p_ic_attribute3_tbl JTF_VARCHAR2_TABLE_200
936 , p_ic_attribute4_tbl JTF_VARCHAR2_TABLE_200
937 , p_ic_attribute5_tbl JTF_VARCHAR2_TABLE_200
938 , p_ic_attribute6_tbl JTF_VARCHAR2_TABLE_200
939 , p_ic_attribute7_tbl JTF_VARCHAR2_TABLE_200
940 , p_ic_attribute8_tbl JTF_VARCHAR2_TABLE_200
941 , p_ic_attribute9_tbl JTF_VARCHAR2_TABLE_200
942 , p_ic_attribute10_tbl JTF_VARCHAR2_TABLE_200
943 , p_ic_attribute11_tbl JTF_VARCHAR2_TABLE_200
944 , p_ic_attribute12_tbl JTF_VARCHAR2_TABLE_200
945 , p_ic_attribute13_tbl JTF_VARCHAR2_TABLE_200
946 , p_ic_attribute14_tbl JTF_VARCHAR2_TABLE_200
947 , p_ic_attribute15_tbl JTF_VARCHAR2_TABLE_200
948 , p_revalue_average_flag_tbl JTF_VARCHAR2_TABLE_200
949 , p_freight_code_comb_id_tbl JTF_NUMBER_TABLE
950 , p_inv_currency_code_tbl JTF_NUMBER_TABLE
951 , p_ic_cogs_acct_id_tbl JTF_NUMBER_TABLE
952 , p_inv_accrual_acct_id_tbl JTF_NUMBER_TABLE
953 , p_exp_accrual_acct_id_tbl JTF_NUMBER_TABLE
954 )
955
956 as
957 ddp_line_number_tbl inv_transaction_flow_pub.number_tbl;
958 ddp_line_attr_category_tbl inv_transaction_flow_pub.varchar2_tbl;
959 ddp_line_attribute1_tbl inv_transaction_flow_pub.varchar2_tbl;
960 ddp_line_attribute2_tbl inv_transaction_flow_pub.varchar2_tbl;
961 ddp_line_attribute3_tbl inv_transaction_flow_pub.varchar2_tbl;
962 ddp_line_attribute4_tbl inv_transaction_flow_pub.varchar2_tbl;
963 ddp_line_attribute5_tbl inv_transaction_flow_pub.varchar2_tbl;
964 ddp_line_attribute6_tbl inv_transaction_flow_pub.varchar2_tbl;
965 ddp_line_attribute7_tbl inv_transaction_flow_pub.varchar2_tbl;
966 ddp_line_attribute8_tbl inv_transaction_flow_pub.varchar2_tbl;
967 ddp_line_attribute9_tbl inv_transaction_flow_pub.varchar2_tbl;
968 ddp_line_attribute10_tbl inv_transaction_flow_pub.varchar2_tbl;
969 ddp_line_attribute11_tbl inv_transaction_flow_pub.varchar2_tbl;
970 ddp_line_attribute12_tbl inv_transaction_flow_pub.varchar2_tbl;
971 ddp_line_attribute13_tbl inv_transaction_flow_pub.varchar2_tbl;
972 ddp_line_attribute14_tbl inv_transaction_flow_pub.varchar2_tbl;
973 ddp_line_attribute15_tbl inv_transaction_flow_pub.varchar2_tbl;
974 ddp_ship_organization_id_tbl inv_transaction_flow_pub.number_tbl;
975 ddp_sell_organization_id_tbl inv_transaction_flow_pub.number_tbl;
976 ddp_vendor_id_tbl inv_transaction_flow_pub.number_tbl;
977 ddp_vendor_site_id_tbl inv_transaction_flow_pub.number_tbl;
978 ddp_customer_id_tbl inv_transaction_flow_pub.number_tbl;
979 ddp_address_id_tbl inv_transaction_flow_pub.number_tbl;
980 ddp_customer_site_id_tbl inv_transaction_flow_pub.number_tbl;
981 ddp_cust_trx_type_id_tbl inv_transaction_flow_pub.number_tbl;
982 ddp_ic_attribute_category_tbl inv_transaction_flow_pub.varchar2_tbl;
983 ddp_ic_attribute1_tbl inv_transaction_flow_pub.varchar2_tbl;
984 ddp_ic_attribute2_tbl inv_transaction_flow_pub.varchar2_tbl;
985 ddp_ic_attribute3_tbl inv_transaction_flow_pub.varchar2_tbl;
986 ddp_ic_attribute4_tbl inv_transaction_flow_pub.varchar2_tbl;
987 ddp_ic_attribute5_tbl inv_transaction_flow_pub.varchar2_tbl;
988 ddp_ic_attribute6_tbl inv_transaction_flow_pub.varchar2_tbl;
989 ddp_ic_attribute7_tbl inv_transaction_flow_pub.varchar2_tbl;
990 ddp_ic_attribute8_tbl inv_transaction_flow_pub.varchar2_tbl;
991 ddp_ic_attribute9_tbl inv_transaction_flow_pub.varchar2_tbl;
992 ddp_ic_attribute10_tbl inv_transaction_flow_pub.varchar2_tbl;
993 ddp_ic_attribute11_tbl inv_transaction_flow_pub.varchar2_tbl;
994 ddp_ic_attribute12_tbl inv_transaction_flow_pub.varchar2_tbl;
995 ddp_ic_attribute13_tbl inv_transaction_flow_pub.varchar2_tbl;
996 ddp_ic_attribute14_tbl inv_transaction_flow_pub.varchar2_tbl;
997 ddp_ic_attribute15_tbl inv_transaction_flow_pub.varchar2_tbl;
998 ddp_revalue_average_flag_tbl inv_transaction_flow_pub.varchar2_tbl;
999 ddp_freight_code_comb_id_tbl inv_transaction_flow_pub.number_tbl;
1000 ddp_inv_currency_code_tbl inv_transaction_flow_pub.number_tbl;
1001 ddp_ic_cogs_acct_id_tbl inv_transaction_flow_pub.number_tbl;
1002 ddp_inv_accrual_acct_id_tbl inv_transaction_flow_pub.number_tbl;
1003 ddp_exp_accrual_acct_id_tbl inv_transaction_flow_pub.number_tbl;
1004 ddindx binary_integer; indx binary_integer;
1005 begin
1006
1007 -- copy data to the local IN or IN-OUT args, if any
1008
1012
1009 inv_transaction_flow_pub_w.rosetta_table_copy_in_p10(ddp_line_number_tbl, p_line_number_tbl);
1010
1011 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_line_attr_category_tbl, p_line_attribute_category_tbl);
1013 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_line_attribute1_tbl, p_line_attribute1_tbl);
1014
1015 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_line_attribute2_tbl, p_line_attribute2_tbl);
1016
1017 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_line_attribute3_tbl, p_line_attribute3_tbl);
1018
1019 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_line_attribute4_tbl, p_line_attribute4_tbl);
1020
1021 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_line_attribute5_tbl, p_line_attribute5_tbl);
1022
1023 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_line_attribute6_tbl, p_line_attribute6_tbl);
1024
1025 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_line_attribute7_tbl, p_line_attribute7_tbl);
1026
1027 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_line_attribute8_tbl, p_line_attribute8_tbl);
1028
1029 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_line_attribute9_tbl, p_line_attribute9_tbl);
1030
1031 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_line_attribute10_tbl, p_line_attribute10_tbl);
1032
1033 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_line_attribute11_tbl, p_line_attribute11_tbl);
1034
1035 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_line_attribute12_tbl, p_line_attribute12_tbl);
1036
1037 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_line_attribute13_tbl, p_line_attribute13_tbl);
1038
1039 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_line_attribute14_tbl, p_line_attribute14_tbl);
1040
1041 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_line_attribute15_tbl, p_line_attribute15_tbl);
1042
1043 inv_transaction_flow_pub_w.rosetta_table_copy_in_p10(ddp_ship_organization_id_tbl, p_ship_organization_id_tbl);
1044
1045 inv_transaction_flow_pub_w.rosetta_table_copy_in_p10(ddp_sell_organization_id_tbl, p_sell_organization_id_tbl);
1046
1047 inv_transaction_flow_pub_w.rosetta_table_copy_in_p10(ddp_vendor_id_tbl, p_vendor_id_tbl);
1048
1049 inv_transaction_flow_pub_w.rosetta_table_copy_in_p10(ddp_vendor_site_id_tbl, p_vendor_site_id_tbl);
1050
1051 inv_transaction_flow_pub_w.rosetta_table_copy_in_p10(ddp_customer_id_tbl, p_customer_id_tbl);
1052
1053 inv_transaction_flow_pub_w.rosetta_table_copy_in_p10(ddp_address_id_tbl, p_address_id_tbl);
1054
1055 inv_transaction_flow_pub_w.rosetta_table_copy_in_p10(ddp_customer_site_id_tbl, p_customer_site_id_tbl);
1056
1057 inv_transaction_flow_pub_w.rosetta_table_copy_in_p10(ddp_cust_trx_type_id_tbl, p_cust_trx_type_id_tbl);
1058
1059 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_ic_attribute_category_tbl, p_ic_attribute_category_tbl);
1060
1061 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_ic_attribute1_tbl, p_ic_attribute1_tbl);
1062
1063 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_ic_attribute2_tbl, p_ic_attribute2_tbl);
1064
1065 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_ic_attribute3_tbl, p_ic_attribute3_tbl);
1066
1067 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_ic_attribute4_tbl, p_ic_attribute4_tbl);
1068
1069 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_ic_attribute5_tbl, p_ic_attribute5_tbl);
1070
1071 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_ic_attribute6_tbl, p_ic_attribute6_tbl);
1072
1073 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_ic_attribute7_tbl, p_ic_attribute7_tbl);
1074
1075 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_ic_attribute8_tbl, p_ic_attribute8_tbl);
1076
1077 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_ic_attribute9_tbl, p_ic_attribute9_tbl);
1078
1079 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_ic_attribute10_tbl, p_ic_attribute10_tbl);
1080
1081 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_ic_attribute11_tbl, p_ic_attribute11_tbl);
1082
1083 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_ic_attribute12_tbl, p_ic_attribute12_tbl);
1084
1085 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_ic_attribute13_tbl, p_ic_attribute13_tbl);
1086
1087 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_ic_attribute14_tbl, p_ic_attribute14_tbl);
1088
1089 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_ic_attribute15_tbl, p_ic_attribute15_tbl);
1090
1091 inv_transaction_flow_pub_w.rosetta_table_copy_in_p11(ddp_revalue_average_flag_tbl, p_revalue_average_flag_tbl);
1092
1093 inv_transaction_flow_pub_w.rosetta_table_copy_in_p10(ddp_freight_code_comb_id_tbl, p_freight_code_comb_id_tbl);
1094
1095 inv_transaction_flow_pub_w.rosetta_table_copy_in_p10(ddp_inv_currency_code_tbl, p_inv_currency_code_tbl);
1096
1097 inv_transaction_flow_pub_w.rosetta_table_copy_in_p10(ddp_ic_cogs_acct_id_tbl, p_ic_cogs_acct_id_tbl);
1098
1099 inv_transaction_flow_pub_w.rosetta_table_copy_in_p10(ddp_inv_accrual_acct_id_tbl, p_inv_accrual_acct_id_tbl);
1100
1101 inv_transaction_flow_pub_w.rosetta_table_copy_in_p10(ddp_exp_accrual_acct_id_tbl, p_exp_accrual_acct_id_tbl);
1102
1103 -- here's the delegated call to the old PL/SQL routine
1104 inv_transaction_flow_pub.update_transaction_flow(x_return_status,
1105 x_msg_data,
1106 x_msg_count,
1107 p_api_version,
1108 p_init_msg_list,
1109 p_validation_level,
1110 p_header_id,
1111 p_flow_type,
1112 p_start_date,
1113 p_end_date,
1114 p_attribute_category,
1115 p_attribute1,
1116 p_attribute2,
1117 p_attribute3,
1118 p_attribute4,
1119 p_attribute5,
1120 p_attribute6,
1121 p_attribute7,
1122 p_attribute8,
1123 p_attribute9,
1124 p_attribute10,
1125 p_attribute11,
1126 p_attribute12,
1127 p_attribute13,
1128 p_attribute14,
1129 p_attribute15,
1130 ddp_line_number_tbl,
1131 ddp_line_attr_category_tbl,
1132 ddp_line_attribute1_tbl,
1133 ddp_line_attribute2_tbl,
1134 ddp_line_attribute3_tbl,
1135 ddp_line_attribute4_tbl,
1136 ddp_line_attribute5_tbl,
1137 ddp_line_attribute6_tbl,
1138 ddp_line_attribute7_tbl,
1139 ddp_line_attribute8_tbl,
1140 ddp_line_attribute9_tbl,
1141 ddp_line_attribute10_tbl,
1142 ddp_line_attribute11_tbl,
1143 ddp_line_attribute12_tbl,
1144 ddp_line_attribute13_tbl,
1145 ddp_line_attribute14_tbl,
1146 ddp_line_attribute15_tbl,
1147 ddp_ship_organization_id_tbl,
1148 ddp_sell_organization_id_tbl,
1149 ddp_vendor_id_tbl,
1150 ddp_vendor_site_id_tbl,
1151 ddp_customer_id_tbl,
1152 ddp_address_id_tbl,
1153 ddp_customer_site_id_tbl,
1154 ddp_cust_trx_type_id_tbl,
1155 ddp_ic_attribute_category_tbl,
1156 ddp_ic_attribute1_tbl,
1157 ddp_ic_attribute2_tbl,
1158 ddp_ic_attribute3_tbl,
1159 ddp_ic_attribute4_tbl,
1160 ddp_ic_attribute5_tbl,
1161 ddp_ic_attribute6_tbl,
1162 ddp_ic_attribute7_tbl,
1163 ddp_ic_attribute8_tbl,
1164 ddp_ic_attribute9_tbl,
1165 ddp_ic_attribute10_tbl,
1166 ddp_ic_attribute11_tbl,
1167 ddp_ic_attribute12_tbl,
1168 ddp_ic_attribute13_tbl,
1169 ddp_ic_attribute14_tbl,
1170 ddp_ic_attribute15_tbl,
1171 ddp_revalue_average_flag_tbl,
1172 ddp_freight_code_comb_id_tbl,
1173 ddp_inv_currency_code_tbl,
1174 ddp_ic_cogs_acct_id_tbl,
1175 ddp_inv_accrual_acct_id_tbl,
1176 ddp_exp_accrual_acct_id_tbl);
1177
1178 -- copy data back from the local variables to OUT or IN-OUT args, if any
1179 end;
1180
1181 end inv_transaction_flow_pub_w;