[Home] [Help]
PACKAGE BODY: APPS.CSP_RECEIVE_PVT_W
Source
1 package body csp_receive_pvt_w as
2 /* $Header: cspwrcvb.pls 115.7 2004/03/17 18:19:07 sunarasi noship $ */
3 procedure rosetta_table_copy_in_p5(t out nocopy csp_receive_pvt.rcv_rec_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_VARCHAR2_TABLE_100
9 , a6 JTF_VARCHAR2_TABLE_100
10 , a7 JTF_VARCHAR2_TABLE_100
11 , a8 JTF_VARCHAR2_TABLE_100
12 , a9 JTF_NUMBER_TABLE
13 , a10 JTF_VARCHAR2_TABLE_100
14 , a11 JTF_NUMBER_TABLE
15 , a12 JTF_NUMBER_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_VARCHAR2_TABLE_100
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 , a26 JTF_NUMBER_TABLE
30 , a27 JTF_NUMBER_TABLE
31 , a28 JTF_NUMBER_TABLE
32 , a29 JTF_VARCHAR2_TABLE_300
33 , a30 JTF_NUMBER_TABLE
34 , a31 JTF_VARCHAR2_TABLE_100
35 , a32 JTF_VARCHAR2_TABLE_100
36 , a33 JTF_NUMBER_TABLE
37 , a34 JTF_VARCHAR2_TABLE_100
38 , a35 JTF_VARCHAR2_TABLE_100
39 , a36 JTF_VARCHAR2_TABLE_100
40 , a37 JTF_NUMBER_TABLE
41 , a38 JTF_NUMBER_TABLE
42 , a39 JTF_VARCHAR2_TABLE_100
43 , a40 JTF_VARCHAR2_TABLE_100
44 , a41 JTF_NUMBER_TABLE
45 , a42 JTF_NUMBER_TABLE
46 , a43 JTF_NUMBER_TABLE
47 , a44 JTF_NUMBER_TABLE
48 , a45 JTF_VARCHAR2_TABLE_100
49 , a46 JTF_VARCHAR2_TABLE_100
50 , a47 JTF_VARCHAR2_TABLE_100
51 , a48 JTF_VARCHAR2_TABLE_100
52 , a49 JTF_VARCHAR2_TABLE_300
53 , a50 JTF_NUMBER_TABLE
54 , a51 JTF_VARCHAR2_TABLE_100
55 , a52 JTF_VARCHAR2_TABLE_100
56 , a53 JTF_VARCHAR2_TABLE_100
57 , a54 JTF_NUMBER_TABLE
58 , a55 JTF_VARCHAR2_TABLE_100
59 , a56 JTF_VARCHAR2_TABLE_100
60 , a57 JTF_NUMBER_TABLE
61 , a58 JTF_VARCHAR2_TABLE_100
62 , a59 JTF_DATE_TABLE
63 , a60 JTF_DATE_TABLE
64 , a61 JTF_NUMBER_TABLE
65 , a62 JTF_VARCHAR2_TABLE_100
66 , a63 JTF_VARCHAR2_TABLE_100
67 , a64 JTF_VARCHAR2_TABLE_100
68 , a65 JTF_VARCHAR2_TABLE_100
69 , a66 JTF_VARCHAR2_TABLE_100
70 , a67 JTF_VARCHAR2_TABLE_100
71 , a68 JTF_VARCHAR2_TABLE_100
72 , a69 JTF_NUMBER_TABLE
73 , a70 JTF_VARCHAR2_TABLE_100
74 , a71 JTF_VARCHAR2_TABLE_100
75 , a72 JTF_DATE_TABLE
76 , a73 JTF_NUMBER_TABLE
77 , a74 JTF_VARCHAR2_TABLE_300
78 , a75 JTF_VARCHAR2_TABLE_100
79 , a76 JTF_NUMBER_TABLE
80 , a77 JTF_NUMBER_TABLE
81 , a78 JTF_VARCHAR2_TABLE_100
82 , a79 JTF_VARCHAR2_TABLE_100
83 , a80 JTF_VARCHAR2_TABLE_300
84 , a81 JTF_VARCHAR2_TABLE_300
85 , a82 JTF_VARCHAR2_TABLE_300
86 , a83 JTF_VARCHAR2_TABLE_300
87 , a84 JTF_VARCHAR2_TABLE_300
88 , a85 JTF_VARCHAR2_TABLE_300
89 , a86 JTF_VARCHAR2_TABLE_300
90 , a87 JTF_VARCHAR2_TABLE_300
91 , a88 JTF_VARCHAR2_TABLE_300
92 , a89 JTF_VARCHAR2_TABLE_300
93 , a90 JTF_VARCHAR2_TABLE_300
94 , a91 JTF_VARCHAR2_TABLE_300
95 , a92 JTF_VARCHAR2_TABLE_300
96 , a93 JTF_VARCHAR2_TABLE_300
97 , a94 JTF_VARCHAR2_TABLE_300
98 , a95 JTF_VARCHAR2_TABLE_100
99 , a96 JTF_VARCHAR2_TABLE_100
100 , a97 JTF_VARCHAR2_TABLE_100
101 , a98 JTF_DATE_TABLE
102 , a99 JTF_VARCHAR2_TABLE_100
103 , a100 JTF_VARCHAR2_TABLE_100
104 , a101 JTF_VARCHAR2_TABLE_100
105 , a102 JTF_VARCHAR2_TABLE_100
106 , a103 JTF_VARCHAR2_TABLE_100
107 , a104 JTF_VARCHAR2_TABLE_100
108 , a105 JTF_VARCHAR2_TABLE_100
109 , a106 JTF_VARCHAR2_TABLE_100
110 , a107 JTF_VARCHAR2_TABLE_100
111 , a108 JTF_VARCHAR2_TABLE_100
112 , a109 JTF_NUMBER_TABLE
113 , a110 JTF_NUMBER_TABLE
114 , a111 JTF_NUMBER_TABLE
115 , a112 JTF_NUMBER_TABLE
116 , a113 JTF_NUMBER_TABLE
117 , a114 JTF_NUMBER_TABLE
118 , a115 JTF_VARCHAR2_TABLE_100
119 , a116 JTF_VARCHAR2_TABLE_300
120 , a117 JTF_NUMBER_TABLE
121 , a118 JTF_NUMBER_TABLE
122 , a119 JTF_NUMBER_TABLE
123 , a120 JTF_NUMBER_TABLE
124 , a121 JTF_NUMBER_TABLE
125 , a122 JTF_NUMBER_TABLE
126 , a123 JTF_NUMBER_TABLE
127 , a124 JTF_NUMBER_TABLE
128 , a125 JTF_VARCHAR2_TABLE_100
129 , a126 JTF_VARCHAR2_TABLE_100
130 , a127 JTF_NUMBER_TABLE
131 , a128 JTF_DATE_TABLE
132 , a129 JTF_NUMBER_TABLE
133 , a130 JTF_NUMBER_TABLE
134 , a131 JTF_NUMBER_TABLE
135 , a132 JTF_NUMBER_TABLE
136 , a133 JTF_VARCHAR2_TABLE_100
137 , a134 JTF_NUMBER_TABLE
138 , a135 JTF_VARCHAR2_TABLE_100
139 , a136 JTF_NUMBER_TABLE
140 , a137 JTF_NUMBER_TABLE
141 , a138 JTF_NUMBER_TABLE
142 , a139 JTF_DATE_TABLE
143 , a140 JTF_NUMBER_TABLE
144 , a141 JTF_NUMBER_TABLE
145 , a142 JTF_VARCHAR2_TABLE_100
146 , a143 JTF_VARCHAR2_TABLE_100
147 , a144 JTF_VARCHAR2_TABLE_100
148 , a145 JTF_VARCHAR2_TABLE_300
149 , a146 JTF_VARCHAR2_TABLE_300
150 , a147 JTF_VARCHAR2_TABLE_200
151 , a148 JTF_DATE_TABLE
152 , a149 JTF_VARCHAR2_TABLE_200
153 , a150 JTF_VARCHAR2_TABLE_200
154 , a151 JTF_DATE_TABLE
155 , a152 JTF_DATE_TABLE
156 , a153 JTF_DATE_TABLE
157 , a154 JTF_NUMBER_TABLE
158 , a155 JTF_NUMBER_TABLE
159 , a156 JTF_VARCHAR2_TABLE_200
160 , a157 JTF_NUMBER_TABLE
161 , a158 JTF_VARCHAR2_TABLE_100
162 , a159 JTF_VARCHAR2_TABLE_200
163 , a160 JTF_DATE_TABLE
164 , a161 JTF_NUMBER_TABLE
165 , a162 JTF_VARCHAR2_TABLE_100
166 , a163 JTF_NUMBER_TABLE
167 , a164 JTF_NUMBER_TABLE
168 , a165 JTF_VARCHAR2_TABLE_100
169 , a166 JTF_NUMBER_TABLE
170 , a167 JTF_VARCHAR2_TABLE_100
171 , a168 JTF_VARCHAR2_TABLE_200
172 , a169 JTF_VARCHAR2_TABLE_100
173 , a170 JTF_VARCHAR2_TABLE_100
174 , a171 JTF_VARCHAR2_TABLE_100
175 , a172 JTF_VARCHAR2_TABLE_100
176 , a173 JTF_VARCHAR2_TABLE_100
177 , a174 JTF_VARCHAR2_TABLE_100
178 , a175 JTF_VARCHAR2_TABLE_100
179 , a176 JTF_NUMBER_TABLE
180 , a177 JTF_NUMBER_TABLE
181 , a178 JTF_NUMBER_TABLE
182 , a179 JTF_NUMBER_TABLE
183 , a180 JTF_NUMBER_TABLE
184 , a181 JTF_NUMBER_TABLE
185 , a182 JTF_NUMBER_TABLE
186 , a183 JTF_NUMBER_TABLE
187 , a184 JTF_NUMBER_TABLE
188 , a185 JTF_NUMBER_TABLE
189 , a186 JTF_NUMBER_TABLE
190 , a187 JTF_NUMBER_TABLE
191 , a188 JTF_NUMBER_TABLE
192 , a189 JTF_VARCHAR2_TABLE_100
193 , a190 JTF_VARCHAR2_TABLE_100
194 , a191 JTF_VARCHAR2_TABLE_300
195 ) as
196 ddindx binary_integer; indx binary_integer;
197 begin
198 if a0 is not null and a0.count > 0 then
199 if a0.count > 0 then
200 indx := a0.first;
201 ddindx := 1;
202 while true loop
203 t(ddindx).interface_transaction_id := a0(indx);
204 t(ddindx).transaction_interface_id := a1(indx);
205 t(ddindx).header_interface_id := a2(indx);
206 t(ddindx).group_id := a3(indx);
207 t(ddindx).inv_loc_assignment_id := a4(indx);
208 t(ddindx).source_type_code := a5(indx);
209 t(ddindx).receipt_source_code := a6(indx);
210 t(ddindx).order_type_code := a7(indx);
211 t(ddindx).order_type := a8(indx);
212 t(ddindx).po_header_id := a9(indx);
213 t(ddindx).po_number := a10(indx);
214 t(ddindx).po_line_id := a11(indx);
215 t(ddindx).po_line_number := a12(indx);
216 t(ddindx).po_line_location_id := a13(indx);
217 t(ddindx).po_shipment_number := a14(indx);
218 t(ddindx).po_release_id := a15(indx);
219 t(ddindx).po_release_number := a16(indx);
220 t(ddindx).req_header_id := a17(indx);
221 t(ddindx).req_number := a18(indx);
222 t(ddindx).req_line_id := a19(indx);
223 t(ddindx).req_line := a20(indx);
224 t(ddindx).req_distribution_id := a21(indx);
225 t(ddindx).rcv_shipment_header_id := a22(indx);
226 t(ddindx).rcv_shipment_number := a23(indx);
227 t(ddindx).rcv_shipment_line_id := a24(indx);
228 t(ddindx).rcv_line_number := a25(indx);
229 t(ddindx).from_organization_id := a26(indx);
230 t(ddindx).to_organization_id := a27(indx);
231 t(ddindx).vendor_id := a28(indx);
232 t(ddindx).source := a29(indx);
233 t(ddindx).vendor_site_id := a30(indx);
234 t(ddindx).outside_operation_flag := a31(indx);
235 t(ddindx).receipt_exception := a32(indx);
236 t(ddindx).item_id := a33(indx);
237 t(ddindx).uom_code := a34(indx);
238 t(ddindx).primary_uom := a35(indx);
239 t(ddindx).primary_uom_class := a36(indx);
240 t(ddindx).item_allowed_units_lookup_code := a37(indx);
241 t(ddindx).item_locator_control := a38(indx);
242 t(ddindx).restrict_locators_code := a39(indx);
243 t(ddindx).restrict_subinventories_code := a40(indx);
244 t(ddindx).shelf_life_code := a41(indx);
245 t(ddindx).shelf_life_days := a42(indx);
246 t(ddindx).serial_number_control_code := a43(indx);
247 t(ddindx).lot_control_code := a44(indx);
248 t(ddindx).item_rev_control_flag_to := a45(indx);
249 t(ddindx).item_rev_control_flag_from := a46(indx);
250 t(ddindx).item_number := a47(indx);
251 t(ddindx).item_revision := a48(indx);
252 t(ddindx).item_description := a49(indx);
253 t(ddindx).item_category_id := a50(indx);
254 t(ddindx).hazard_class := a51(indx);
255 t(ddindx).un_number := a52(indx);
256 t(ddindx).vendor_item_number := a53(indx);
257 t(ddindx).ship_to_location_id := a54(indx);
258 t(ddindx).ship_to_location := a55(indx);
259 t(ddindx).packing_slip := a56(indx);
260 t(ddindx).routing_id := a57(indx);
261 t(ddindx).routing_name := a58(indx);
262 t(ddindx).need_by_date := a59(indx);
263 t(ddindx).expected_receipt_date := a60(indx);
264 t(ddindx).ordered_qty := a61(indx);
265 t(ddindx).ordered_uom := a62(indx);
266 t(ddindx).ussgl_transaction_code := a63(indx);
267 t(ddindx).government_context := a64(indx);
268 t(ddindx).inspection_required_flag := a65(indx);
269 t(ddindx).receipt_required_flag := a66(indx);
270 t(ddindx).enforce_ship_to_location_code := a67(indx);
271 t(ddindx).substitute_receipt := a68(indx);
272 t(ddindx).unit_price := a69(indx);
273 t(ddindx).currency_code := a70(indx);
274 t(ddindx).currency_conversion_type := a71(indx);
275 t(ddindx).currency_conversion_date := a72(indx);
276 t(ddindx).currency_conversion_rate := a73(indx);
277 t(ddindx).note_to_receiver := a74(indx);
278 t(ddindx).destination_type_code := a75(indx);
279 t(ddindx).deliver_to_person_id := a76(indx);
280 t(ddindx).deliver_to_location_id := a77(indx);
281 t(ddindx).destination_subinventory := a78(indx);
282 t(ddindx).attribute_category := a79(indx);
283 t(ddindx).attribute1 := a80(indx);
284 t(ddindx).attribute2 := a81(indx);
285 t(ddindx).attribute3 := a82(indx);
286 t(ddindx).attribute4 := a83(indx);
287 t(ddindx).attribute5 := a84(indx);
288 t(ddindx).attribute6 := a85(indx);
289 t(ddindx).attribute7 := a86(indx);
290 t(ddindx).attribute8 := a87(indx);
291 t(ddindx).attribute9 := a88(indx);
292 t(ddindx).attribute10 := a89(indx);
293 t(ddindx).attribute11 := a90(indx);
294 t(ddindx).attribute12 := a91(indx);
295 t(ddindx).attribute13 := a92(indx);
296 t(ddindx).attribute14 := a93(indx);
297 t(ddindx).attribute15 := a94(indx);
298 t(ddindx).closed_code := a95(indx);
299 t(ddindx).asn_type := a96(indx);
300 t(ddindx).bill_of_lading := a97(indx);
304 t(ddindx).freight_bill_num := a101(indx);
301 t(ddindx).shipped_date := a98(indx);
302 t(ddindx).freight_carrier_code := a99(indx);
303 t(ddindx).waybill_airbill_num := a100(indx);
305 t(ddindx).vendor_lot_num := a102(indx);
306 t(ddindx).container_num := a103(indx);
307 t(ddindx).truck_num := a104(indx);
308 t(ddindx).bar_code_label := a105(indx);
309 t(ddindx).rate_type_display := a106(indx);
310 t(ddindx).match_option := a107(indx);
311 t(ddindx).country_of_origin_code := a108(indx);
312 t(ddindx).oe_order_header_id := a109(indx);
313 t(ddindx).oe_order_num := a110(indx);
314 t(ddindx).oe_order_line_id := a111(indx);
315 t(ddindx).oe_order_line_num := a112(indx);
316 t(ddindx).customer_id := a113(indx);
317 t(ddindx).customer_site_id := a114(indx);
318 t(ddindx).customer_item_num := a115(indx);
319 t(ddindx).pll_note_to_receiver := a116(indx);
320 t(ddindx).po_distribution_id := a117(indx);
321 t(ddindx).qty_ordered := a118(indx);
322 t(ddindx).wip_entity_id := a119(indx);
323 t(ddindx).wip_operation_seq_num := a120(indx);
324 t(ddindx).wip_resource_seq_num := a121(indx);
325 t(ddindx).wip_repetitive_schedule_id := a122(indx);
326 t(ddindx).wip_line_id := a123(indx);
327 t(ddindx).bom_resource_id := a124(indx);
328 t(ddindx).destination_type := a125(indx);
329 t(ddindx).location := a126(indx);
330 t(ddindx).currency_conversion_rate_pod := a127(indx);
331 t(ddindx).currency_conversion_date_pod := a128(indx);
332 t(ddindx).project_id := a129(indx);
333 t(ddindx).task_id := a130(indx);
334 t(ddindx).locator_id := a131(indx);
335 t(ddindx).employee_id := a132(indx);
336 t(ddindx).lot_number := a133(indx);
337 t(ddindx).transaction_quantity := a134(indx);
338 t(ddindx).transaction_uom := a135(indx);
339 t(ddindx).primary_quantity := a136(indx);
340 t(ddindx).lot_quantity := a137(indx);
341 t(ddindx).lot_primary_quantity := a138(indx);
342 t(ddindx).expiration_date := a139(indx);
343 t(ddindx).status_id := a140(indx);
344 t(ddindx).product_transaction_id := a141(indx);
345 t(ddindx).product_code := a142(indx);
346 t(ddindx).att_exist := a143(indx);
347 t(ddindx).update_mln := a144(indx);
348 t(ddindx).description := a145(indx);
349 t(ddindx).vendor_name := a146(indx);
350 t(ddindx).supplier_lot_number := a147(indx);
351 t(ddindx).origination_date := a148(indx);
352 t(ddindx).date_code := a149(indx);
353 t(ddindx).grade_code := a150(indx);
354 t(ddindx).change_date := a151(indx);
355 t(ddindx).maturity_date := a152(indx);
356 t(ddindx).retest_date := a153(indx);
357 t(ddindx).age := a154(indx);
358 t(ddindx).item_size := a155(indx);
359 t(ddindx).color := a156(indx);
360 t(ddindx).volume := a157(indx);
361 t(ddindx).volume_uom := a158(indx);
362 t(ddindx).place_of_origin := a159(indx);
363 t(ddindx).best_by_date := a160(indx);
364 t(ddindx).length := a161(indx);
365 t(ddindx).length_uom := a162(indx);
366 t(ddindx).recycled_content := a163(indx);
367 t(ddindx).thickness := a164(indx);
368 t(ddindx).thickness_uom := a165(indx);
369 t(ddindx).width := a166(indx);
370 t(ddindx).width_uom := a167(indx);
371 t(ddindx).curl_wrinkle_fold := a168(indx);
372 t(ddindx).territory_code := a169(indx);
373 t(ddindx).fm_serial_number := a170(indx);
374 t(ddindx).to_serial_number := a171(indx);
375 t(ddindx).update_msn := a172(indx);
376 t(ddindx).vendor_serial_number := a173(indx);
377 t(ddindx).vendor_lot_number := a174(indx);
378 t(ddindx).parent_serial_number := a175(indx);
379 t(ddindx).time_since_new := a176(indx);
380 t(ddindx).cycles_since_new := a177(indx);
381 t(ddindx).time_since_overhaul := a178(indx);
382 t(ddindx).cycles_since_overhaul := a179(indx);
383 t(ddindx).time_since_repair := a180(indx);
384 t(ddindx).cycles_since_repair := a181(indx);
385 t(ddindx).time_since_visit := a182(indx);
386 t(ddindx).cycles_since_visit := a183(indx);
387 t(ddindx).time_since_mark := a184(indx);
388 t(ddindx).cycles_since_mark := a185(indx);
389 t(ddindx).number_of_repairs := a186(indx);
390 t(ddindx).set_of_books_id_sob := a187(indx);
391 t(ddindx).reason_id := a188(indx);
392 t(ddindx).currency_code_sob := a189(indx);
393 t(ddindx).department_code := a190(indx);
394 t(ddindx).comments := a191(indx);
395 ddindx := ddindx+1;
396 if a0.last =indx
397 then exit;
398 end if;
399 indx := a0.next(indx);
400 end loop;
401 end if;
402 end if;
403 end rosetta_table_copy_in_p5;
404 procedure rosetta_table_copy_out_p5(t csp_receive_pvt.rcv_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
405 , a1 out nocopy JTF_NUMBER_TABLE
406 , a2 out nocopy JTF_NUMBER_TABLE
407 , a3 out nocopy JTF_NUMBER_TABLE
408 , a4 out nocopy JTF_NUMBER_TABLE
409 , a5 out nocopy JTF_VARCHAR2_TABLE_100
410 , a6 out nocopy JTF_VARCHAR2_TABLE_100
411 , a7 out nocopy JTF_VARCHAR2_TABLE_100
412 , a8 out nocopy JTF_VARCHAR2_TABLE_100
413 , a9 out nocopy JTF_NUMBER_TABLE
414 , a10 out nocopy JTF_VARCHAR2_TABLE_100
415 , a11 out nocopy JTF_NUMBER_TABLE
416 , a12 out nocopy JTF_NUMBER_TABLE
420 , a16 out nocopy JTF_NUMBER_TABLE
417 , a13 out nocopy JTF_NUMBER_TABLE
418 , a14 out nocopy JTF_NUMBER_TABLE
419 , a15 out nocopy JTF_NUMBER_TABLE
421 , a17 out nocopy JTF_NUMBER_TABLE
422 , a18 out nocopy JTF_VARCHAR2_TABLE_100
423 , a19 out nocopy JTF_NUMBER_TABLE
424 , a20 out nocopy JTF_NUMBER_TABLE
425 , a21 out nocopy JTF_NUMBER_TABLE
426 , a22 out nocopy JTF_NUMBER_TABLE
427 , a23 out nocopy JTF_VARCHAR2_TABLE_100
428 , a24 out nocopy JTF_NUMBER_TABLE
429 , a25 out nocopy JTF_NUMBER_TABLE
430 , a26 out nocopy JTF_NUMBER_TABLE
431 , a27 out nocopy JTF_NUMBER_TABLE
432 , a28 out nocopy JTF_NUMBER_TABLE
433 , a29 out nocopy JTF_VARCHAR2_TABLE_300
434 , a30 out nocopy JTF_NUMBER_TABLE
435 , a31 out nocopy JTF_VARCHAR2_TABLE_100
436 , a32 out nocopy JTF_VARCHAR2_TABLE_100
437 , a33 out nocopy JTF_NUMBER_TABLE
438 , a34 out nocopy JTF_VARCHAR2_TABLE_100
439 , a35 out nocopy JTF_VARCHAR2_TABLE_100
440 , a36 out nocopy JTF_VARCHAR2_TABLE_100
441 , a37 out nocopy JTF_NUMBER_TABLE
442 , a38 out nocopy JTF_NUMBER_TABLE
443 , a39 out nocopy JTF_VARCHAR2_TABLE_100
444 , a40 out nocopy JTF_VARCHAR2_TABLE_100
445 , a41 out nocopy JTF_NUMBER_TABLE
446 , a42 out nocopy JTF_NUMBER_TABLE
447 , a43 out nocopy JTF_NUMBER_TABLE
448 , a44 out nocopy JTF_NUMBER_TABLE
449 , a45 out nocopy JTF_VARCHAR2_TABLE_100
450 , a46 out nocopy JTF_VARCHAR2_TABLE_100
451 , a47 out nocopy JTF_VARCHAR2_TABLE_100
452 , a48 out nocopy JTF_VARCHAR2_TABLE_100
453 , a49 out nocopy JTF_VARCHAR2_TABLE_300
454 , a50 out nocopy JTF_NUMBER_TABLE
455 , a51 out nocopy JTF_VARCHAR2_TABLE_100
456 , a52 out nocopy JTF_VARCHAR2_TABLE_100
457 , a53 out nocopy JTF_VARCHAR2_TABLE_100
458 , a54 out nocopy JTF_NUMBER_TABLE
459 , a55 out nocopy JTF_VARCHAR2_TABLE_100
460 , a56 out nocopy JTF_VARCHAR2_TABLE_100
461 , a57 out nocopy JTF_NUMBER_TABLE
462 , a58 out nocopy JTF_VARCHAR2_TABLE_100
463 , a59 out nocopy JTF_DATE_TABLE
464 , a60 out nocopy JTF_DATE_TABLE
465 , a61 out nocopy JTF_NUMBER_TABLE
466 , a62 out nocopy JTF_VARCHAR2_TABLE_100
467 , a63 out nocopy JTF_VARCHAR2_TABLE_100
468 , a64 out nocopy JTF_VARCHAR2_TABLE_100
469 , a65 out nocopy JTF_VARCHAR2_TABLE_100
470 , a66 out nocopy JTF_VARCHAR2_TABLE_100
471 , a67 out nocopy JTF_VARCHAR2_TABLE_100
472 , a68 out nocopy JTF_VARCHAR2_TABLE_100
473 , a69 out nocopy JTF_NUMBER_TABLE
474 , a70 out nocopy JTF_VARCHAR2_TABLE_100
475 , a71 out nocopy JTF_VARCHAR2_TABLE_100
476 , a72 out nocopy JTF_DATE_TABLE
477 , a73 out nocopy JTF_NUMBER_TABLE
478 , a74 out nocopy JTF_VARCHAR2_TABLE_300
479 , a75 out nocopy JTF_VARCHAR2_TABLE_100
480 , a76 out nocopy JTF_NUMBER_TABLE
481 , a77 out nocopy JTF_NUMBER_TABLE
482 , a78 out nocopy JTF_VARCHAR2_TABLE_100
483 , a79 out nocopy JTF_VARCHAR2_TABLE_100
484 , a80 out nocopy JTF_VARCHAR2_TABLE_300
485 , a81 out nocopy JTF_VARCHAR2_TABLE_300
486 , a82 out nocopy JTF_VARCHAR2_TABLE_300
487 , a83 out nocopy JTF_VARCHAR2_TABLE_300
488 , a84 out nocopy JTF_VARCHAR2_TABLE_300
489 , a85 out nocopy JTF_VARCHAR2_TABLE_300
490 , a86 out nocopy JTF_VARCHAR2_TABLE_300
491 , a87 out nocopy JTF_VARCHAR2_TABLE_300
492 , a88 out nocopy JTF_VARCHAR2_TABLE_300
493 , a89 out nocopy JTF_VARCHAR2_TABLE_300
494 , a90 out nocopy JTF_VARCHAR2_TABLE_300
495 , a91 out nocopy JTF_VARCHAR2_TABLE_300
496 , a92 out nocopy JTF_VARCHAR2_TABLE_300
497 , a93 out nocopy JTF_VARCHAR2_TABLE_300
498 , a94 out nocopy JTF_VARCHAR2_TABLE_300
499 , a95 out nocopy JTF_VARCHAR2_TABLE_100
500 , a96 out nocopy JTF_VARCHAR2_TABLE_100
501 , a97 out nocopy JTF_VARCHAR2_TABLE_100
502 , a98 out nocopy JTF_DATE_TABLE
503 , a99 out nocopy JTF_VARCHAR2_TABLE_100
504 , a100 out nocopy JTF_VARCHAR2_TABLE_100
505 , a101 out nocopy JTF_VARCHAR2_TABLE_100
506 , a102 out nocopy JTF_VARCHAR2_TABLE_100
507 , a103 out nocopy JTF_VARCHAR2_TABLE_100
508 , a104 out nocopy JTF_VARCHAR2_TABLE_100
509 , a105 out nocopy JTF_VARCHAR2_TABLE_100
510 , a106 out nocopy JTF_VARCHAR2_TABLE_100
511 , a107 out nocopy JTF_VARCHAR2_TABLE_100
512 , a108 out nocopy JTF_VARCHAR2_TABLE_100
513 , a109 out nocopy JTF_NUMBER_TABLE
514 , a110 out nocopy JTF_NUMBER_TABLE
515 , a111 out nocopy JTF_NUMBER_TABLE
516 , a112 out nocopy JTF_NUMBER_TABLE
517 , a113 out nocopy JTF_NUMBER_TABLE
518 , a114 out nocopy JTF_NUMBER_TABLE
519 , a115 out nocopy JTF_VARCHAR2_TABLE_100
520 , a116 out nocopy JTF_VARCHAR2_TABLE_300
521 , a117 out nocopy JTF_NUMBER_TABLE
522 , a118 out nocopy JTF_NUMBER_TABLE
523 , a119 out nocopy JTF_NUMBER_TABLE
524 , a120 out nocopy JTF_NUMBER_TABLE
525 , a121 out nocopy JTF_NUMBER_TABLE
526 , a122 out nocopy JTF_NUMBER_TABLE
527 , a123 out nocopy JTF_NUMBER_TABLE
528 , a124 out nocopy JTF_NUMBER_TABLE
529 , a125 out nocopy JTF_VARCHAR2_TABLE_100
530 , a126 out nocopy JTF_VARCHAR2_TABLE_100
531 , a127 out nocopy JTF_NUMBER_TABLE
532 , a128 out nocopy JTF_DATE_TABLE
533 , a129 out nocopy JTF_NUMBER_TABLE
534 , a130 out nocopy JTF_NUMBER_TABLE
535 , a131 out nocopy JTF_NUMBER_TABLE
536 , a132 out nocopy JTF_NUMBER_TABLE
537 , a133 out nocopy JTF_VARCHAR2_TABLE_100
538 , a134 out nocopy JTF_NUMBER_TABLE
539 , a135 out nocopy JTF_VARCHAR2_TABLE_100
540 , a136 out nocopy JTF_NUMBER_TABLE
541 , a137 out nocopy JTF_NUMBER_TABLE
542 , a138 out nocopy JTF_NUMBER_TABLE
543 , a139 out nocopy JTF_DATE_TABLE
544 , a140 out nocopy JTF_NUMBER_TABLE
545 , a141 out nocopy JTF_NUMBER_TABLE
549 , a145 out nocopy JTF_VARCHAR2_TABLE_300
546 , a142 out nocopy JTF_VARCHAR2_TABLE_100
547 , a143 out nocopy JTF_VARCHAR2_TABLE_100
548 , a144 out nocopy JTF_VARCHAR2_TABLE_100
550 , a146 out nocopy JTF_VARCHAR2_TABLE_300
551 , a147 out nocopy JTF_VARCHAR2_TABLE_200
552 , a148 out nocopy JTF_DATE_TABLE
553 , a149 out nocopy JTF_VARCHAR2_TABLE_200
554 , a150 out nocopy JTF_VARCHAR2_TABLE_200
555 , a151 out nocopy JTF_DATE_TABLE
556 , a152 out nocopy JTF_DATE_TABLE
557 , a153 out nocopy JTF_DATE_TABLE
558 , a154 out nocopy JTF_NUMBER_TABLE
559 , a155 out nocopy JTF_NUMBER_TABLE
560 , a156 out nocopy JTF_VARCHAR2_TABLE_200
561 , a157 out nocopy JTF_NUMBER_TABLE
562 , a158 out nocopy JTF_VARCHAR2_TABLE_100
563 , a159 out nocopy JTF_VARCHAR2_TABLE_200
564 , a160 out nocopy JTF_DATE_TABLE
565 , a161 out nocopy JTF_NUMBER_TABLE
566 , a162 out nocopy JTF_VARCHAR2_TABLE_100
567 , a163 out nocopy JTF_NUMBER_TABLE
568 , a164 out nocopy JTF_NUMBER_TABLE
569 , a165 out nocopy JTF_VARCHAR2_TABLE_100
570 , a166 out nocopy JTF_NUMBER_TABLE
571 , a167 out nocopy JTF_VARCHAR2_TABLE_100
572 , a168 out nocopy JTF_VARCHAR2_TABLE_200
573 , a169 out nocopy JTF_VARCHAR2_TABLE_100
574 , a170 out nocopy JTF_VARCHAR2_TABLE_100
575 , a171 out nocopy JTF_VARCHAR2_TABLE_100
576 , a172 out nocopy JTF_VARCHAR2_TABLE_100
577 , a173 out nocopy JTF_VARCHAR2_TABLE_100
578 , a174 out nocopy JTF_VARCHAR2_TABLE_100
579 , a175 out nocopy JTF_VARCHAR2_TABLE_100
580 , a176 out nocopy JTF_NUMBER_TABLE
581 , a177 out nocopy JTF_NUMBER_TABLE
582 , a178 out nocopy JTF_NUMBER_TABLE
583 , a179 out nocopy JTF_NUMBER_TABLE
584 , a180 out nocopy JTF_NUMBER_TABLE
585 , a181 out nocopy JTF_NUMBER_TABLE
586 , a182 out nocopy JTF_NUMBER_TABLE
587 , a183 out nocopy JTF_NUMBER_TABLE
588 , a184 out nocopy JTF_NUMBER_TABLE
589 , a185 out nocopy JTF_NUMBER_TABLE
590 , a186 out nocopy JTF_NUMBER_TABLE
591 , a187 out nocopy JTF_NUMBER_TABLE
592 , a188 out nocopy JTF_NUMBER_TABLE
593 , a189 out nocopy JTF_VARCHAR2_TABLE_100
594 , a190 out nocopy JTF_VARCHAR2_TABLE_100
595 , a191 out nocopy JTF_VARCHAR2_TABLE_300
596 ) as
597 ddindx binary_integer; indx binary_integer;
598 begin
599 if t is null or t.count = 0 then
600 a0 := JTF_NUMBER_TABLE();
601 a1 := JTF_NUMBER_TABLE();
602 a2 := JTF_NUMBER_TABLE();
603 a3 := JTF_NUMBER_TABLE();
604 a4 := JTF_NUMBER_TABLE();
605 a5 := JTF_VARCHAR2_TABLE_100();
606 a6 := JTF_VARCHAR2_TABLE_100();
607 a7 := JTF_VARCHAR2_TABLE_100();
608 a8 := JTF_VARCHAR2_TABLE_100();
609 a9 := JTF_NUMBER_TABLE();
610 a10 := JTF_VARCHAR2_TABLE_100();
611 a11 := JTF_NUMBER_TABLE();
612 a12 := JTF_NUMBER_TABLE();
613 a13 := JTF_NUMBER_TABLE();
614 a14 := JTF_NUMBER_TABLE();
615 a15 := JTF_NUMBER_TABLE();
616 a16 := JTF_NUMBER_TABLE();
617 a17 := JTF_NUMBER_TABLE();
618 a18 := JTF_VARCHAR2_TABLE_100();
619 a19 := JTF_NUMBER_TABLE();
620 a20 := JTF_NUMBER_TABLE();
621 a21 := JTF_NUMBER_TABLE();
622 a22 := JTF_NUMBER_TABLE();
623 a23 := JTF_VARCHAR2_TABLE_100();
624 a24 := JTF_NUMBER_TABLE();
625 a25 := JTF_NUMBER_TABLE();
626 a26 := JTF_NUMBER_TABLE();
627 a27 := JTF_NUMBER_TABLE();
628 a28 := JTF_NUMBER_TABLE();
629 a29 := JTF_VARCHAR2_TABLE_300();
630 a30 := JTF_NUMBER_TABLE();
631 a31 := JTF_VARCHAR2_TABLE_100();
632 a32 := JTF_VARCHAR2_TABLE_100();
633 a33 := JTF_NUMBER_TABLE();
634 a34 := JTF_VARCHAR2_TABLE_100();
635 a35 := JTF_VARCHAR2_TABLE_100();
636 a36 := JTF_VARCHAR2_TABLE_100();
637 a37 := JTF_NUMBER_TABLE();
638 a38 := JTF_NUMBER_TABLE();
639 a39 := JTF_VARCHAR2_TABLE_100();
640 a40 := JTF_VARCHAR2_TABLE_100();
641 a41 := JTF_NUMBER_TABLE();
642 a42 := JTF_NUMBER_TABLE();
643 a43 := JTF_NUMBER_TABLE();
644 a44 := JTF_NUMBER_TABLE();
645 a45 := JTF_VARCHAR2_TABLE_100();
646 a46 := JTF_VARCHAR2_TABLE_100();
647 a47 := JTF_VARCHAR2_TABLE_100();
648 a48 := JTF_VARCHAR2_TABLE_100();
649 a49 := JTF_VARCHAR2_TABLE_300();
650 a50 := JTF_NUMBER_TABLE();
651 a51 := JTF_VARCHAR2_TABLE_100();
652 a52 := JTF_VARCHAR2_TABLE_100();
653 a53 := JTF_VARCHAR2_TABLE_100();
654 a54 := JTF_NUMBER_TABLE();
655 a55 := JTF_VARCHAR2_TABLE_100();
656 a56 := JTF_VARCHAR2_TABLE_100();
657 a57 := JTF_NUMBER_TABLE();
658 a58 := JTF_VARCHAR2_TABLE_100();
659 a59 := JTF_DATE_TABLE();
660 a60 := JTF_DATE_TABLE();
661 a61 := JTF_NUMBER_TABLE();
662 a62 := JTF_VARCHAR2_TABLE_100();
663 a63 := JTF_VARCHAR2_TABLE_100();
664 a64 := JTF_VARCHAR2_TABLE_100();
665 a65 := JTF_VARCHAR2_TABLE_100();
666 a66 := JTF_VARCHAR2_TABLE_100();
667 a67 := JTF_VARCHAR2_TABLE_100();
668 a68 := JTF_VARCHAR2_TABLE_100();
669 a69 := JTF_NUMBER_TABLE();
670 a70 := JTF_VARCHAR2_TABLE_100();
671 a71 := JTF_VARCHAR2_TABLE_100();
672 a72 := JTF_DATE_TABLE();
673 a73 := JTF_NUMBER_TABLE();
674 a74 := JTF_VARCHAR2_TABLE_300();
675 a75 := JTF_VARCHAR2_TABLE_100();
676 a76 := JTF_NUMBER_TABLE();
677 a77 := JTF_NUMBER_TABLE();
678 a78 := JTF_VARCHAR2_TABLE_100();
679 a79 := JTF_VARCHAR2_TABLE_100();
680 a80 := JTF_VARCHAR2_TABLE_300();
681 a81 := JTF_VARCHAR2_TABLE_300();
682 a82 := JTF_VARCHAR2_TABLE_300();
683 a83 := JTF_VARCHAR2_TABLE_300();
684 a84 := JTF_VARCHAR2_TABLE_300();
685 a85 := JTF_VARCHAR2_TABLE_300();
686 a86 := JTF_VARCHAR2_TABLE_300();
690 a90 := JTF_VARCHAR2_TABLE_300();
687 a87 := JTF_VARCHAR2_TABLE_300();
688 a88 := JTF_VARCHAR2_TABLE_300();
689 a89 := JTF_VARCHAR2_TABLE_300();
691 a91 := JTF_VARCHAR2_TABLE_300();
692 a92 := JTF_VARCHAR2_TABLE_300();
693 a93 := JTF_VARCHAR2_TABLE_300();
694 a94 := JTF_VARCHAR2_TABLE_300();
695 a95 := JTF_VARCHAR2_TABLE_100();
696 a96 := JTF_VARCHAR2_TABLE_100();
697 a97 := JTF_VARCHAR2_TABLE_100();
698 a98 := JTF_DATE_TABLE();
699 a99 := JTF_VARCHAR2_TABLE_100();
700 a100 := JTF_VARCHAR2_TABLE_100();
701 a101 := JTF_VARCHAR2_TABLE_100();
702 a102 := JTF_VARCHAR2_TABLE_100();
703 a103 := JTF_VARCHAR2_TABLE_100();
704 a104 := JTF_VARCHAR2_TABLE_100();
705 a105 := JTF_VARCHAR2_TABLE_100();
706 a106 := JTF_VARCHAR2_TABLE_100();
707 a107 := JTF_VARCHAR2_TABLE_100();
708 a108 := JTF_VARCHAR2_TABLE_100();
709 a109 := JTF_NUMBER_TABLE();
710 a110 := JTF_NUMBER_TABLE();
711 a111 := JTF_NUMBER_TABLE();
712 a112 := JTF_NUMBER_TABLE();
713 a113 := JTF_NUMBER_TABLE();
714 a114 := JTF_NUMBER_TABLE();
715 a115 := JTF_VARCHAR2_TABLE_100();
716 a116 := JTF_VARCHAR2_TABLE_300();
717 a117 := JTF_NUMBER_TABLE();
718 a118 := JTF_NUMBER_TABLE();
719 a119 := JTF_NUMBER_TABLE();
720 a120 := JTF_NUMBER_TABLE();
721 a121 := JTF_NUMBER_TABLE();
722 a122 := JTF_NUMBER_TABLE();
723 a123 := JTF_NUMBER_TABLE();
724 a124 := JTF_NUMBER_TABLE();
725 a125 := JTF_VARCHAR2_TABLE_100();
726 a126 := JTF_VARCHAR2_TABLE_100();
727 a127 := JTF_NUMBER_TABLE();
728 a128 := JTF_DATE_TABLE();
729 a129 := JTF_NUMBER_TABLE();
730 a130 := JTF_NUMBER_TABLE();
731 a131 := JTF_NUMBER_TABLE();
732 a132 := JTF_NUMBER_TABLE();
733 a133 := JTF_VARCHAR2_TABLE_100();
734 a134 := JTF_NUMBER_TABLE();
735 a135 := JTF_VARCHAR2_TABLE_100();
736 a136 := JTF_NUMBER_TABLE();
737 a137 := JTF_NUMBER_TABLE();
738 a138 := JTF_NUMBER_TABLE();
739 a139 := JTF_DATE_TABLE();
740 a140 := JTF_NUMBER_TABLE();
741 a141 := JTF_NUMBER_TABLE();
742 a142 := JTF_VARCHAR2_TABLE_100();
743 a143 := JTF_VARCHAR2_TABLE_100();
744 a144 := JTF_VARCHAR2_TABLE_100();
745 a145 := JTF_VARCHAR2_TABLE_300();
746 a146 := JTF_VARCHAR2_TABLE_300();
747 a147 := JTF_VARCHAR2_TABLE_200();
748 a148 := JTF_DATE_TABLE();
749 a149 := JTF_VARCHAR2_TABLE_200();
750 a150 := JTF_VARCHAR2_TABLE_200();
751 a151 := JTF_DATE_TABLE();
752 a152 := JTF_DATE_TABLE();
753 a153 := JTF_DATE_TABLE();
754 a154 := JTF_NUMBER_TABLE();
755 a155 := JTF_NUMBER_TABLE();
756 a156 := JTF_VARCHAR2_TABLE_200();
757 a157 := JTF_NUMBER_TABLE();
758 a158 := JTF_VARCHAR2_TABLE_100();
759 a159 := JTF_VARCHAR2_TABLE_200();
760 a160 := JTF_DATE_TABLE();
761 a161 := JTF_NUMBER_TABLE();
762 a162 := JTF_VARCHAR2_TABLE_100();
763 a163 := JTF_NUMBER_TABLE();
764 a164 := JTF_NUMBER_TABLE();
765 a165 := JTF_VARCHAR2_TABLE_100();
766 a166 := JTF_NUMBER_TABLE();
767 a167 := JTF_VARCHAR2_TABLE_100();
768 a168 := JTF_VARCHAR2_TABLE_200();
769 a169 := JTF_VARCHAR2_TABLE_100();
770 a170 := JTF_VARCHAR2_TABLE_100();
771 a171 := JTF_VARCHAR2_TABLE_100();
772 a172 := JTF_VARCHAR2_TABLE_100();
773 a173 := JTF_VARCHAR2_TABLE_100();
774 a174 := JTF_VARCHAR2_TABLE_100();
775 a175 := JTF_VARCHAR2_TABLE_100();
776 a176 := JTF_NUMBER_TABLE();
777 a177 := JTF_NUMBER_TABLE();
778 a178 := JTF_NUMBER_TABLE();
779 a179 := JTF_NUMBER_TABLE();
780 a180 := JTF_NUMBER_TABLE();
781 a181 := JTF_NUMBER_TABLE();
782 a182 := JTF_NUMBER_TABLE();
783 a183 := JTF_NUMBER_TABLE();
784 a184 := JTF_NUMBER_TABLE();
785 a185 := JTF_NUMBER_TABLE();
786 a186 := JTF_NUMBER_TABLE();
787 a187 := JTF_NUMBER_TABLE();
788 a188 := JTF_NUMBER_TABLE();
789 a189 := JTF_VARCHAR2_TABLE_100();
790 a190 := JTF_VARCHAR2_TABLE_100();
791 a191 := JTF_VARCHAR2_TABLE_300();
792 else
793 a0 := JTF_NUMBER_TABLE();
794 a1 := JTF_NUMBER_TABLE();
795 a2 := JTF_NUMBER_TABLE();
796 a3 := JTF_NUMBER_TABLE();
797 a4 := JTF_NUMBER_TABLE();
798 a5 := JTF_VARCHAR2_TABLE_100();
799 a6 := JTF_VARCHAR2_TABLE_100();
800 a7 := JTF_VARCHAR2_TABLE_100();
801 a8 := JTF_VARCHAR2_TABLE_100();
802 a9 := JTF_NUMBER_TABLE();
803 a10 := JTF_VARCHAR2_TABLE_100();
804 a11 := JTF_NUMBER_TABLE();
805 a12 := JTF_NUMBER_TABLE();
806 a13 := JTF_NUMBER_TABLE();
807 a14 := JTF_NUMBER_TABLE();
808 a15 := JTF_NUMBER_TABLE();
809 a16 := JTF_NUMBER_TABLE();
810 a17 := JTF_NUMBER_TABLE();
811 a18 := JTF_VARCHAR2_TABLE_100();
812 a19 := JTF_NUMBER_TABLE();
813 a20 := JTF_NUMBER_TABLE();
814 a21 := JTF_NUMBER_TABLE();
815 a22 := JTF_NUMBER_TABLE();
816 a23 := JTF_VARCHAR2_TABLE_100();
817 a24 := JTF_NUMBER_TABLE();
818 a25 := JTF_NUMBER_TABLE();
819 a26 := JTF_NUMBER_TABLE();
820 a27 := JTF_NUMBER_TABLE();
821 a28 := JTF_NUMBER_TABLE();
822 a29 := JTF_VARCHAR2_TABLE_300();
823 a30 := JTF_NUMBER_TABLE();
824 a31 := JTF_VARCHAR2_TABLE_100();
825 a32 := JTF_VARCHAR2_TABLE_100();
826 a33 := JTF_NUMBER_TABLE();
827 a34 := JTF_VARCHAR2_TABLE_100();
828 a35 := JTF_VARCHAR2_TABLE_100();
829 a36 := JTF_VARCHAR2_TABLE_100();
830 a37 := JTF_NUMBER_TABLE();
831 a38 := JTF_NUMBER_TABLE();
832 a39 := JTF_VARCHAR2_TABLE_100();
833 a40 := JTF_VARCHAR2_TABLE_100();
837 a44 := JTF_NUMBER_TABLE();
834 a41 := JTF_NUMBER_TABLE();
835 a42 := JTF_NUMBER_TABLE();
836 a43 := JTF_NUMBER_TABLE();
838 a45 := JTF_VARCHAR2_TABLE_100();
839 a46 := JTF_VARCHAR2_TABLE_100();
840 a47 := JTF_VARCHAR2_TABLE_100();
841 a48 := JTF_VARCHAR2_TABLE_100();
842 a49 := JTF_VARCHAR2_TABLE_300();
843 a50 := JTF_NUMBER_TABLE();
844 a51 := JTF_VARCHAR2_TABLE_100();
845 a52 := JTF_VARCHAR2_TABLE_100();
846 a53 := JTF_VARCHAR2_TABLE_100();
847 a54 := JTF_NUMBER_TABLE();
848 a55 := JTF_VARCHAR2_TABLE_100();
849 a56 := JTF_VARCHAR2_TABLE_100();
850 a57 := JTF_NUMBER_TABLE();
851 a58 := JTF_VARCHAR2_TABLE_100();
852 a59 := JTF_DATE_TABLE();
853 a60 := JTF_DATE_TABLE();
854 a61 := JTF_NUMBER_TABLE();
855 a62 := JTF_VARCHAR2_TABLE_100();
856 a63 := JTF_VARCHAR2_TABLE_100();
857 a64 := JTF_VARCHAR2_TABLE_100();
858 a65 := JTF_VARCHAR2_TABLE_100();
859 a66 := JTF_VARCHAR2_TABLE_100();
860 a67 := JTF_VARCHAR2_TABLE_100();
861 a68 := JTF_VARCHAR2_TABLE_100();
862 a69 := JTF_NUMBER_TABLE();
863 a70 := JTF_VARCHAR2_TABLE_100();
864 a71 := JTF_VARCHAR2_TABLE_100();
865 a72 := JTF_DATE_TABLE();
866 a73 := JTF_NUMBER_TABLE();
867 a74 := JTF_VARCHAR2_TABLE_300();
868 a75 := JTF_VARCHAR2_TABLE_100();
869 a76 := JTF_NUMBER_TABLE();
870 a77 := JTF_NUMBER_TABLE();
871 a78 := JTF_VARCHAR2_TABLE_100();
872 a79 := JTF_VARCHAR2_TABLE_100();
873 a80 := JTF_VARCHAR2_TABLE_300();
874 a81 := JTF_VARCHAR2_TABLE_300();
875 a82 := JTF_VARCHAR2_TABLE_300();
876 a83 := JTF_VARCHAR2_TABLE_300();
877 a84 := JTF_VARCHAR2_TABLE_300();
878 a85 := JTF_VARCHAR2_TABLE_300();
879 a86 := JTF_VARCHAR2_TABLE_300();
880 a87 := JTF_VARCHAR2_TABLE_300();
881 a88 := JTF_VARCHAR2_TABLE_300();
882 a89 := JTF_VARCHAR2_TABLE_300();
883 a90 := JTF_VARCHAR2_TABLE_300();
884 a91 := JTF_VARCHAR2_TABLE_300();
885 a92 := JTF_VARCHAR2_TABLE_300();
886 a93 := JTF_VARCHAR2_TABLE_300();
887 a94 := JTF_VARCHAR2_TABLE_300();
888 a95 := JTF_VARCHAR2_TABLE_100();
889 a96 := JTF_VARCHAR2_TABLE_100();
890 a97 := JTF_VARCHAR2_TABLE_100();
891 a98 := JTF_DATE_TABLE();
892 a99 := JTF_VARCHAR2_TABLE_100();
893 a100 := JTF_VARCHAR2_TABLE_100();
894 a101 := JTF_VARCHAR2_TABLE_100();
895 a102 := JTF_VARCHAR2_TABLE_100();
896 a103 := JTF_VARCHAR2_TABLE_100();
897 a104 := JTF_VARCHAR2_TABLE_100();
898 a105 := JTF_VARCHAR2_TABLE_100();
899 a106 := JTF_VARCHAR2_TABLE_100();
900 a107 := JTF_VARCHAR2_TABLE_100();
901 a108 := JTF_VARCHAR2_TABLE_100();
902 a109 := JTF_NUMBER_TABLE();
903 a110 := JTF_NUMBER_TABLE();
904 a111 := JTF_NUMBER_TABLE();
905 a112 := JTF_NUMBER_TABLE();
906 a113 := JTF_NUMBER_TABLE();
907 a114 := JTF_NUMBER_TABLE();
908 a115 := JTF_VARCHAR2_TABLE_100();
909 a116 := JTF_VARCHAR2_TABLE_300();
910 a117 := JTF_NUMBER_TABLE();
911 a118 := JTF_NUMBER_TABLE();
912 a119 := JTF_NUMBER_TABLE();
913 a120 := JTF_NUMBER_TABLE();
914 a121 := JTF_NUMBER_TABLE();
915 a122 := JTF_NUMBER_TABLE();
916 a123 := JTF_NUMBER_TABLE();
917 a124 := JTF_NUMBER_TABLE();
918 a125 := JTF_VARCHAR2_TABLE_100();
919 a126 := JTF_VARCHAR2_TABLE_100();
920 a127 := JTF_NUMBER_TABLE();
921 a128 := JTF_DATE_TABLE();
922 a129 := JTF_NUMBER_TABLE();
923 a130 := JTF_NUMBER_TABLE();
924 a131 := JTF_NUMBER_TABLE();
925 a132 := JTF_NUMBER_TABLE();
926 a133 := JTF_VARCHAR2_TABLE_100();
927 a134 := JTF_NUMBER_TABLE();
928 a135 := JTF_VARCHAR2_TABLE_100();
929 a136 := JTF_NUMBER_TABLE();
930 a137 := JTF_NUMBER_TABLE();
931 a138 := JTF_NUMBER_TABLE();
932 a139 := JTF_DATE_TABLE();
933 a140 := JTF_NUMBER_TABLE();
934 a141 := JTF_NUMBER_TABLE();
935 a142 := JTF_VARCHAR2_TABLE_100();
936 a143 := JTF_VARCHAR2_TABLE_100();
937 a144 := JTF_VARCHAR2_TABLE_100();
938 a145 := JTF_VARCHAR2_TABLE_300();
939 a146 := JTF_VARCHAR2_TABLE_300();
940 a147 := JTF_VARCHAR2_TABLE_200();
941 a148 := JTF_DATE_TABLE();
942 a149 := JTF_VARCHAR2_TABLE_200();
943 a150 := JTF_VARCHAR2_TABLE_200();
944 a151 := JTF_DATE_TABLE();
945 a152 := JTF_DATE_TABLE();
946 a153 := JTF_DATE_TABLE();
947 a154 := JTF_NUMBER_TABLE();
948 a155 := JTF_NUMBER_TABLE();
949 a156 := JTF_VARCHAR2_TABLE_200();
950 a157 := JTF_NUMBER_TABLE();
951 a158 := JTF_VARCHAR2_TABLE_100();
952 a159 := JTF_VARCHAR2_TABLE_200();
953 a160 := JTF_DATE_TABLE();
954 a161 := JTF_NUMBER_TABLE();
955 a162 := JTF_VARCHAR2_TABLE_100();
956 a163 := JTF_NUMBER_TABLE();
957 a164 := JTF_NUMBER_TABLE();
958 a165 := JTF_VARCHAR2_TABLE_100();
959 a166 := JTF_NUMBER_TABLE();
960 a167 := JTF_VARCHAR2_TABLE_100();
961 a168 := JTF_VARCHAR2_TABLE_200();
962 a169 := JTF_VARCHAR2_TABLE_100();
963 a170 := JTF_VARCHAR2_TABLE_100();
964 a171 := JTF_VARCHAR2_TABLE_100();
965 a172 := JTF_VARCHAR2_TABLE_100();
966 a173 := JTF_VARCHAR2_TABLE_100();
967 a174 := JTF_VARCHAR2_TABLE_100();
968 a175 := JTF_VARCHAR2_TABLE_100();
969 a176 := JTF_NUMBER_TABLE();
970 a177 := JTF_NUMBER_TABLE();
971 a178 := JTF_NUMBER_TABLE();
972 a179 := JTF_NUMBER_TABLE();
973 a180 := JTF_NUMBER_TABLE();
977 a184 := JTF_NUMBER_TABLE();
974 a181 := JTF_NUMBER_TABLE();
975 a182 := JTF_NUMBER_TABLE();
976 a183 := JTF_NUMBER_TABLE();
978 a185 := JTF_NUMBER_TABLE();
979 a186 := JTF_NUMBER_TABLE();
980 a187 := JTF_NUMBER_TABLE();
981 a188 := JTF_NUMBER_TABLE();
982 a189 := JTF_VARCHAR2_TABLE_100();
983 a190 := JTF_VARCHAR2_TABLE_100();
984 a191 := JTF_VARCHAR2_TABLE_300();
985 if t.count > 0 then
986 a0.extend(t.count);
987 a1.extend(t.count);
988 a2.extend(t.count);
989 a3.extend(t.count);
990 a4.extend(t.count);
991 a5.extend(t.count);
992 a6.extend(t.count);
993 a7.extend(t.count);
994 a8.extend(t.count);
995 a9.extend(t.count);
996 a10.extend(t.count);
997 a11.extend(t.count);
998 a12.extend(t.count);
999 a13.extend(t.count);
1000 a14.extend(t.count);
1001 a15.extend(t.count);
1002 a16.extend(t.count);
1003 a17.extend(t.count);
1004 a18.extend(t.count);
1005 a19.extend(t.count);
1006 a20.extend(t.count);
1007 a21.extend(t.count);
1008 a22.extend(t.count);
1009 a23.extend(t.count);
1010 a24.extend(t.count);
1011 a25.extend(t.count);
1012 a26.extend(t.count);
1013 a27.extend(t.count);
1014 a28.extend(t.count);
1015 a29.extend(t.count);
1016 a30.extend(t.count);
1017 a31.extend(t.count);
1018 a32.extend(t.count);
1019 a33.extend(t.count);
1020 a34.extend(t.count);
1021 a35.extend(t.count);
1022 a36.extend(t.count);
1023 a37.extend(t.count);
1024 a38.extend(t.count);
1025 a39.extend(t.count);
1026 a40.extend(t.count);
1027 a41.extend(t.count);
1028 a42.extend(t.count);
1029 a43.extend(t.count);
1030 a44.extend(t.count);
1031 a45.extend(t.count);
1032 a46.extend(t.count);
1033 a47.extend(t.count);
1034 a48.extend(t.count);
1035 a49.extend(t.count);
1036 a50.extend(t.count);
1037 a51.extend(t.count);
1038 a52.extend(t.count);
1039 a53.extend(t.count);
1040 a54.extend(t.count);
1041 a55.extend(t.count);
1042 a56.extend(t.count);
1043 a57.extend(t.count);
1044 a58.extend(t.count);
1045 a59.extend(t.count);
1046 a60.extend(t.count);
1047 a61.extend(t.count);
1048 a62.extend(t.count);
1049 a63.extend(t.count);
1050 a64.extend(t.count);
1051 a65.extend(t.count);
1052 a66.extend(t.count);
1053 a67.extend(t.count);
1054 a68.extend(t.count);
1055 a69.extend(t.count);
1056 a70.extend(t.count);
1057 a71.extend(t.count);
1058 a72.extend(t.count);
1059 a73.extend(t.count);
1060 a74.extend(t.count);
1061 a75.extend(t.count);
1062 a76.extend(t.count);
1063 a77.extend(t.count);
1064 a78.extend(t.count);
1065 a79.extend(t.count);
1066 a80.extend(t.count);
1067 a81.extend(t.count);
1068 a82.extend(t.count);
1069 a83.extend(t.count);
1070 a84.extend(t.count);
1071 a85.extend(t.count);
1072 a86.extend(t.count);
1073 a87.extend(t.count);
1074 a88.extend(t.count);
1075 a89.extend(t.count);
1076 a90.extend(t.count);
1077 a91.extend(t.count);
1078 a92.extend(t.count);
1079 a93.extend(t.count);
1080 a94.extend(t.count);
1081 a95.extend(t.count);
1082 a96.extend(t.count);
1083 a97.extend(t.count);
1084 a98.extend(t.count);
1085 a99.extend(t.count);
1086 a100.extend(t.count);
1087 a101.extend(t.count);
1088 a102.extend(t.count);
1089 a103.extend(t.count);
1090 a104.extend(t.count);
1091 a105.extend(t.count);
1092 a106.extend(t.count);
1093 a107.extend(t.count);
1094 a108.extend(t.count);
1095 a109.extend(t.count);
1096 a110.extend(t.count);
1097 a111.extend(t.count);
1098 a112.extend(t.count);
1099 a113.extend(t.count);
1100 a114.extend(t.count);
1101 a115.extend(t.count);
1102 a116.extend(t.count);
1103 a117.extend(t.count);
1104 a118.extend(t.count);
1105 a119.extend(t.count);
1106 a120.extend(t.count);
1107 a121.extend(t.count);
1108 a122.extend(t.count);
1109 a123.extend(t.count);
1110 a124.extend(t.count);
1111 a125.extend(t.count);
1112 a126.extend(t.count);
1113 a127.extend(t.count);
1114 a128.extend(t.count);
1115 a129.extend(t.count);
1116 a130.extend(t.count);
1117 a131.extend(t.count);
1118 a132.extend(t.count);
1119 a133.extend(t.count);
1120 a134.extend(t.count);
1121 a135.extend(t.count);
1122 a136.extend(t.count);
1123 a137.extend(t.count);
1124 a138.extend(t.count);
1125 a139.extend(t.count);
1126 a140.extend(t.count);
1127 a141.extend(t.count);
1128 a142.extend(t.count);
1129 a143.extend(t.count);
1130 a144.extend(t.count);
1131 a145.extend(t.count);
1132 a146.extend(t.count);
1133 a147.extend(t.count);
1134 a148.extend(t.count);
1135 a149.extend(t.count);
1136 a150.extend(t.count);
1140 a154.extend(t.count);
1137 a151.extend(t.count);
1138 a152.extend(t.count);
1139 a153.extend(t.count);
1141 a155.extend(t.count);
1142 a156.extend(t.count);
1143 a157.extend(t.count);
1144 a158.extend(t.count);
1145 a159.extend(t.count);
1146 a160.extend(t.count);
1147 a161.extend(t.count);
1148 a162.extend(t.count);
1149 a163.extend(t.count);
1150 a164.extend(t.count);
1151 a165.extend(t.count);
1152 a166.extend(t.count);
1153 a167.extend(t.count);
1154 a168.extend(t.count);
1155 a169.extend(t.count);
1156 a170.extend(t.count);
1157 a171.extend(t.count);
1158 a172.extend(t.count);
1159 a173.extend(t.count);
1160 a174.extend(t.count);
1161 a175.extend(t.count);
1162 a176.extend(t.count);
1163 a177.extend(t.count);
1164 a178.extend(t.count);
1165 a179.extend(t.count);
1166 a180.extend(t.count);
1167 a181.extend(t.count);
1168 a182.extend(t.count);
1169 a183.extend(t.count);
1170 a184.extend(t.count);
1171 a185.extend(t.count);
1172 a186.extend(t.count);
1173 a187.extend(t.count);
1174 a188.extend(t.count);
1175 a189.extend(t.count);
1176 a190.extend(t.count);
1177 a191.extend(t.count);
1178 ddindx := t.first;
1179 indx := 1;
1180 while true loop
1181 a0(indx) := t(ddindx).interface_transaction_id;
1182 a1(indx) := t(ddindx).transaction_interface_id;
1183 a2(indx) := t(ddindx).header_interface_id;
1184 a3(indx) := t(ddindx).group_id;
1185 a4(indx) := t(ddindx).inv_loc_assignment_id;
1186 a5(indx) := t(ddindx).source_type_code;
1187 a6(indx) := t(ddindx).receipt_source_code;
1188 a7(indx) := t(ddindx).order_type_code;
1189 a8(indx) := t(ddindx).order_type;
1190 a9(indx) := t(ddindx).po_header_id;
1191 a10(indx) := t(ddindx).po_number;
1192 a11(indx) := t(ddindx).po_line_id;
1193 a12(indx) := t(ddindx).po_line_number;
1194 a13(indx) := t(ddindx).po_line_location_id;
1195 a14(indx) := t(ddindx).po_shipment_number;
1196 a15(indx) := t(ddindx).po_release_id;
1197 a16(indx) := t(ddindx).po_release_number;
1198 a17(indx) := t(ddindx).req_header_id;
1199 a18(indx) := t(ddindx).req_number;
1200 a19(indx) := t(ddindx).req_line_id;
1201 a20(indx) := t(ddindx).req_line;
1202 a21(indx) := t(ddindx).req_distribution_id;
1203 a22(indx) := t(ddindx).rcv_shipment_header_id;
1204 a23(indx) := t(ddindx).rcv_shipment_number;
1205 a24(indx) := t(ddindx).rcv_shipment_line_id;
1206 a25(indx) := t(ddindx).rcv_line_number;
1207 a26(indx) := t(ddindx).from_organization_id;
1208 a27(indx) := t(ddindx).to_organization_id;
1209 a28(indx) := t(ddindx).vendor_id;
1210 a29(indx) := t(ddindx).source;
1211 a30(indx) := t(ddindx).vendor_site_id;
1212 a31(indx) := t(ddindx).outside_operation_flag;
1213 a32(indx) := t(ddindx).receipt_exception;
1214 a33(indx) := t(ddindx).item_id;
1215 a34(indx) := t(ddindx).uom_code;
1216 a35(indx) := t(ddindx).primary_uom;
1217 a36(indx) := t(ddindx).primary_uom_class;
1218 a37(indx) := t(ddindx).item_allowed_units_lookup_code;
1219 a38(indx) := t(ddindx).item_locator_control;
1220 a39(indx) := t(ddindx).restrict_locators_code;
1221 a40(indx) := t(ddindx).restrict_subinventories_code;
1222 a41(indx) := t(ddindx).shelf_life_code;
1223 a42(indx) := t(ddindx).shelf_life_days;
1224 a43(indx) := t(ddindx).serial_number_control_code;
1225 a44(indx) := t(ddindx).lot_control_code;
1226 a45(indx) := t(ddindx).item_rev_control_flag_to;
1227 a46(indx) := t(ddindx).item_rev_control_flag_from;
1228 a47(indx) := t(ddindx).item_number;
1229 a48(indx) := t(ddindx).item_revision;
1230 a49(indx) := t(ddindx).item_description;
1231 a50(indx) := t(ddindx).item_category_id;
1232 a51(indx) := t(ddindx).hazard_class;
1233 a52(indx) := t(ddindx).un_number;
1234 a53(indx) := t(ddindx).vendor_item_number;
1235 a54(indx) := t(ddindx).ship_to_location_id;
1236 a55(indx) := t(ddindx).ship_to_location;
1237 a56(indx) := t(ddindx).packing_slip;
1238 a57(indx) := t(ddindx).routing_id;
1239 a58(indx) := t(ddindx).routing_name;
1240 a59(indx) := t(ddindx).need_by_date;
1241 a60(indx) := t(ddindx).expected_receipt_date;
1242 a61(indx) := t(ddindx).ordered_qty;
1243 a62(indx) := t(ddindx).ordered_uom;
1244 a63(indx) := t(ddindx).ussgl_transaction_code;
1245 a64(indx) := t(ddindx).government_context;
1246 a65(indx) := t(ddindx).inspection_required_flag;
1247 a66(indx) := t(ddindx).receipt_required_flag;
1248 a67(indx) := t(ddindx).enforce_ship_to_location_code;
1249 a68(indx) := t(ddindx).substitute_receipt;
1250 a69(indx) := t(ddindx).unit_price;
1251 a70(indx) := t(ddindx).currency_code;
1252 a71(indx) := t(ddindx).currency_conversion_type;
1253 a72(indx) := t(ddindx).currency_conversion_date;
1254 a73(indx) := t(ddindx).currency_conversion_rate;
1255 a74(indx) := t(ddindx).note_to_receiver;
1256 a75(indx) := t(ddindx).destination_type_code;
1257 a76(indx) := t(ddindx).deliver_to_person_id;
1258 a77(indx) := t(ddindx).deliver_to_location_id;
1259 a78(indx) := t(ddindx).destination_subinventory;
1260 a79(indx) := t(ddindx).attribute_category;
1264 a83(indx) := t(ddindx).attribute4;
1261 a80(indx) := t(ddindx).attribute1;
1262 a81(indx) := t(ddindx).attribute2;
1263 a82(indx) := t(ddindx).attribute3;
1265 a84(indx) := t(ddindx).attribute5;
1266 a85(indx) := t(ddindx).attribute6;
1267 a86(indx) := t(ddindx).attribute7;
1268 a87(indx) := t(ddindx).attribute8;
1269 a88(indx) := t(ddindx).attribute9;
1270 a89(indx) := t(ddindx).attribute10;
1271 a90(indx) := t(ddindx).attribute11;
1272 a91(indx) := t(ddindx).attribute12;
1273 a92(indx) := t(ddindx).attribute13;
1274 a93(indx) := t(ddindx).attribute14;
1275 a94(indx) := t(ddindx).attribute15;
1276 a95(indx) := t(ddindx).closed_code;
1277 a96(indx) := t(ddindx).asn_type;
1278 a97(indx) := t(ddindx).bill_of_lading;
1279 a98(indx) := t(ddindx).shipped_date;
1280 a99(indx) := t(ddindx).freight_carrier_code;
1281 a100(indx) := t(ddindx).waybill_airbill_num;
1282 a101(indx) := t(ddindx).freight_bill_num;
1283 a102(indx) := t(ddindx).vendor_lot_num;
1284 a103(indx) := t(ddindx).container_num;
1285 a104(indx) := t(ddindx).truck_num;
1286 a105(indx) := t(ddindx).bar_code_label;
1287 a106(indx) := t(ddindx).rate_type_display;
1288 a107(indx) := t(ddindx).match_option;
1289 a108(indx) := t(ddindx).country_of_origin_code;
1290 a109(indx) := t(ddindx).oe_order_header_id;
1291 a110(indx) := t(ddindx).oe_order_num;
1292 a111(indx) := t(ddindx).oe_order_line_id;
1293 a112(indx) := t(ddindx).oe_order_line_num;
1294 a113(indx) := t(ddindx).customer_id;
1295 a114(indx) := t(ddindx).customer_site_id;
1296 a115(indx) := t(ddindx).customer_item_num;
1297 a116(indx) := t(ddindx).pll_note_to_receiver;
1298 a117(indx) := t(ddindx).po_distribution_id;
1299 a118(indx) := t(ddindx).qty_ordered;
1300 a119(indx) := t(ddindx).wip_entity_id;
1301 a120(indx) := t(ddindx).wip_operation_seq_num;
1302 a121(indx) := t(ddindx).wip_resource_seq_num;
1303 a122(indx) := t(ddindx).wip_repetitive_schedule_id;
1304 a123(indx) := t(ddindx).wip_line_id;
1305 a124(indx) := t(ddindx).bom_resource_id;
1306 a125(indx) := t(ddindx).destination_type;
1307 a126(indx) := t(ddindx).location;
1308 a127(indx) := t(ddindx).currency_conversion_rate_pod;
1309 a128(indx) := t(ddindx).currency_conversion_date_pod;
1310 a129(indx) := t(ddindx).project_id;
1311 a130(indx) := t(ddindx).task_id;
1312 a131(indx) := t(ddindx).locator_id;
1313 a132(indx) := t(ddindx).employee_id;
1314 a133(indx) := t(ddindx).lot_number;
1315 a134(indx) := t(ddindx).transaction_quantity;
1316 a135(indx) := t(ddindx).transaction_uom;
1317 a136(indx) := t(ddindx).primary_quantity;
1318 a137(indx) := t(ddindx).lot_quantity;
1319 a138(indx) := t(ddindx).lot_primary_quantity;
1320 a139(indx) := t(ddindx).expiration_date;
1321 a140(indx) := t(ddindx).status_id;
1322 a141(indx) := t(ddindx).product_transaction_id;
1323 a142(indx) := t(ddindx).product_code;
1324 a143(indx) := t(ddindx).att_exist;
1325 a144(indx) := t(ddindx).update_mln;
1326 a145(indx) := t(ddindx).description;
1327 a146(indx) := t(ddindx).vendor_name;
1328 a147(indx) := t(ddindx).supplier_lot_number;
1329 a148(indx) := t(ddindx).origination_date;
1330 a149(indx) := t(ddindx).date_code;
1331 a150(indx) := t(ddindx).grade_code;
1332 a151(indx) := t(ddindx).change_date;
1333 a152(indx) := t(ddindx).maturity_date;
1334 a153(indx) := t(ddindx).retest_date;
1335 a154(indx) := t(ddindx).age;
1336 a155(indx) := t(ddindx).item_size;
1337 a156(indx) := t(ddindx).color;
1338 a157(indx) := t(ddindx).volume;
1339 a158(indx) := t(ddindx).volume_uom;
1340 a159(indx) := t(ddindx).place_of_origin;
1341 a160(indx) := t(ddindx).best_by_date;
1342 a161(indx) := t(ddindx).length;
1343 a162(indx) := t(ddindx).length_uom;
1344 a163(indx) := t(ddindx).recycled_content;
1345 a164(indx) := t(ddindx).thickness;
1346 a165(indx) := t(ddindx).thickness_uom;
1347 a166(indx) := t(ddindx).width;
1348 a167(indx) := t(ddindx).width_uom;
1349 a168(indx) := t(ddindx).curl_wrinkle_fold;
1350 a169(indx) := t(ddindx).territory_code;
1351 a170(indx) := t(ddindx).fm_serial_number;
1352 a171(indx) := t(ddindx).to_serial_number;
1353 a172(indx) := t(ddindx).update_msn;
1354 a173(indx) := t(ddindx).vendor_serial_number;
1355 a174(indx) := t(ddindx).vendor_lot_number;
1356 a175(indx) := t(ddindx).parent_serial_number;
1357 a176(indx) := t(ddindx).time_since_new;
1358 a177(indx) := t(ddindx).cycles_since_new;
1359 a178(indx) := t(ddindx).time_since_overhaul;
1360 a179(indx) := t(ddindx).cycles_since_overhaul;
1361 a180(indx) := t(ddindx).time_since_repair;
1362 a181(indx) := t(ddindx).cycles_since_repair;
1363 a182(indx) := t(ddindx).time_since_visit;
1364 a183(indx) := t(ddindx).cycles_since_visit;
1365 a184(indx) := t(ddindx).time_since_mark;
1366 a185(indx) := t(ddindx).cycles_since_mark;
1367 a186(indx) := t(ddindx).number_of_repairs;
1368 a187(indx) := t(ddindx).set_of_books_id_sob;
1369 a188(indx) := t(ddindx).reason_id;
1370 a189(indx) := t(ddindx).currency_code_sob;
1371 a190(indx) := t(ddindx).department_code;
1372 a191(indx) := t(ddindx).comments;
1373 indx := indx+1;
1374 if t.last =ddindx
1375 then exit;
1376 end if;
1377 ddindx := t.next(ddindx);
1378 end loop;
1379 end if;
1380 end if;
1381 end rosetta_table_copy_out_p5;
1382
1383 procedure receive_shipments(p_api_version_number NUMBER
1384 , p_init_msg_list VARCHAR2
1385 , p_commit VARCHAR2
1386 , p_validation_level NUMBER
1387 , p4_a0 NUMBER
1388 , p4_a1 NUMBER
1389 , p4_a2 NUMBER
1390 , p4_a3 NUMBER
1391 , p4_a4 VARCHAR2
1392 , p4_a5 VARCHAR2
1393 , p4_a6 NUMBER
1394 , p4_a7 VARCHAR2
1395 , p4_a8 NUMBER
1396 , p4_a9 VARCHAR2
1397 , p4_a10 VARCHAR2
1398 , p4_a11 VARCHAR2
1399 , p4_a12 DATE
1400 , p4_a13 VARCHAR2
1401 , p4_a14 DATE
1402 , p4_a15 NUMBER
1403 , p4_a16 VARCHAR2
1404 , p4_a17 VARCHAR2
1405 , p4_a18 NUMBER
1406 , p4_a19 NUMBER
1407 , p4_a20 NUMBER
1408 , p5_a0 JTF_NUMBER_TABLE
1409 , p5_a1 JTF_NUMBER_TABLE
1410 , p5_a2 JTF_NUMBER_TABLE
1411 , p5_a3 JTF_NUMBER_TABLE
1412 , p5_a4 JTF_NUMBER_TABLE
1413 , p5_a5 JTF_VARCHAR2_TABLE_100
1414 , p5_a6 JTF_VARCHAR2_TABLE_100
1415 , p5_a7 JTF_VARCHAR2_TABLE_100
1416 , p5_a8 JTF_VARCHAR2_TABLE_100
1417 , p5_a9 JTF_NUMBER_TABLE
1418 , p5_a10 JTF_VARCHAR2_TABLE_100
1419 , p5_a11 JTF_NUMBER_TABLE
1420 , p5_a12 JTF_NUMBER_TABLE
1421 , p5_a13 JTF_NUMBER_TABLE
1422 , p5_a14 JTF_NUMBER_TABLE
1423 , p5_a15 JTF_NUMBER_TABLE
1424 , p5_a16 JTF_NUMBER_TABLE
1425 , p5_a17 JTF_NUMBER_TABLE
1426 , p5_a18 JTF_VARCHAR2_TABLE_100
1427 , p5_a19 JTF_NUMBER_TABLE
1428 , p5_a20 JTF_NUMBER_TABLE
1429 , p5_a21 JTF_NUMBER_TABLE
1430 , p5_a22 JTF_NUMBER_TABLE
1431 , p5_a23 JTF_VARCHAR2_TABLE_100
1432 , p5_a24 JTF_NUMBER_TABLE
1433 , p5_a25 JTF_NUMBER_TABLE
1434 , p5_a26 JTF_NUMBER_TABLE
1435 , p5_a27 JTF_NUMBER_TABLE
1436 , p5_a28 JTF_NUMBER_TABLE
1437 , p5_a29 JTF_VARCHAR2_TABLE_300
1438 , p5_a30 JTF_NUMBER_TABLE
1439 , p5_a31 JTF_VARCHAR2_TABLE_100
1440 , p5_a32 JTF_VARCHAR2_TABLE_100
1441 , p5_a33 JTF_NUMBER_TABLE
1442 , p5_a34 JTF_VARCHAR2_TABLE_100
1443 , p5_a35 JTF_VARCHAR2_TABLE_100
1444 , p5_a36 JTF_VARCHAR2_TABLE_100
1445 , p5_a37 JTF_NUMBER_TABLE
1446 , p5_a38 JTF_NUMBER_TABLE
1447 , p5_a39 JTF_VARCHAR2_TABLE_100
1448 , p5_a40 JTF_VARCHAR2_TABLE_100
1449 , p5_a41 JTF_NUMBER_TABLE
1450 , p5_a42 JTF_NUMBER_TABLE
1451 , p5_a43 JTF_NUMBER_TABLE
1452 , p5_a44 JTF_NUMBER_TABLE
1453 , p5_a45 JTF_VARCHAR2_TABLE_100
1454 , p5_a46 JTF_VARCHAR2_TABLE_100
1455 , p5_a47 JTF_VARCHAR2_TABLE_100
1456 , p5_a48 JTF_VARCHAR2_TABLE_100
1457 , p5_a49 JTF_VARCHAR2_TABLE_300
1458 , p5_a50 JTF_NUMBER_TABLE
1459 , p5_a51 JTF_VARCHAR2_TABLE_100
1460 , p5_a52 JTF_VARCHAR2_TABLE_100
1461 , p5_a53 JTF_VARCHAR2_TABLE_100
1462 , p5_a54 JTF_NUMBER_TABLE
1463 , p5_a55 JTF_VARCHAR2_TABLE_100
1464 , p5_a56 JTF_VARCHAR2_TABLE_100
1465 , p5_a57 JTF_NUMBER_TABLE
1466 , p5_a58 JTF_VARCHAR2_TABLE_100
1467 , p5_a59 JTF_DATE_TABLE
1468 , p5_a60 JTF_DATE_TABLE
1469 , p5_a61 JTF_NUMBER_TABLE
1470 , p5_a62 JTF_VARCHAR2_TABLE_100
1471 , p5_a63 JTF_VARCHAR2_TABLE_100
1472 , p5_a64 JTF_VARCHAR2_TABLE_100
1473 , p5_a65 JTF_VARCHAR2_TABLE_100
1474 , p5_a66 JTF_VARCHAR2_TABLE_100
1475 , p5_a67 JTF_VARCHAR2_TABLE_100
1476 , p5_a68 JTF_VARCHAR2_TABLE_100
1477 , p5_a69 JTF_NUMBER_TABLE
1478 , p5_a70 JTF_VARCHAR2_TABLE_100
1479 , p5_a71 JTF_VARCHAR2_TABLE_100
1480 , p5_a72 JTF_DATE_TABLE
1481 , p5_a73 JTF_NUMBER_TABLE
1482 , p5_a74 JTF_VARCHAR2_TABLE_300
1483 , p5_a75 JTF_VARCHAR2_TABLE_100
1484 , p5_a76 JTF_NUMBER_TABLE
1485 , p5_a77 JTF_NUMBER_TABLE
1486 , p5_a78 JTF_VARCHAR2_TABLE_100
1487 , p5_a79 JTF_VARCHAR2_TABLE_100
1488 , p5_a80 JTF_VARCHAR2_TABLE_300
1489 , p5_a81 JTF_VARCHAR2_TABLE_300
1490 , p5_a82 JTF_VARCHAR2_TABLE_300
1491 , p5_a83 JTF_VARCHAR2_TABLE_300
1492 , p5_a84 JTF_VARCHAR2_TABLE_300
1493 , p5_a85 JTF_VARCHAR2_TABLE_300
1494 , p5_a86 JTF_VARCHAR2_TABLE_300
1495 , p5_a87 JTF_VARCHAR2_TABLE_300
1496 , p5_a88 JTF_VARCHAR2_TABLE_300
1497 , p5_a89 JTF_VARCHAR2_TABLE_300
1498 , p5_a90 JTF_VARCHAR2_TABLE_300
1499 , p5_a91 JTF_VARCHAR2_TABLE_300
1500 , p5_a92 JTF_VARCHAR2_TABLE_300
1501 , p5_a93 JTF_VARCHAR2_TABLE_300
1502 , p5_a94 JTF_VARCHAR2_TABLE_300
1503 , p5_a95 JTF_VARCHAR2_TABLE_100
1504 , p5_a96 JTF_VARCHAR2_TABLE_100
1505 , p5_a97 JTF_VARCHAR2_TABLE_100
1506 , p5_a98 JTF_DATE_TABLE
1510 , p5_a102 JTF_VARCHAR2_TABLE_100
1507 , p5_a99 JTF_VARCHAR2_TABLE_100
1508 , p5_a100 JTF_VARCHAR2_TABLE_100
1509 , p5_a101 JTF_VARCHAR2_TABLE_100
1511 , p5_a103 JTF_VARCHAR2_TABLE_100
1512 , p5_a104 JTF_VARCHAR2_TABLE_100
1513 , p5_a105 JTF_VARCHAR2_TABLE_100
1514 , p5_a106 JTF_VARCHAR2_TABLE_100
1515 , p5_a107 JTF_VARCHAR2_TABLE_100
1516 , p5_a108 JTF_VARCHAR2_TABLE_100
1517 , p5_a109 JTF_NUMBER_TABLE
1518 , p5_a110 JTF_NUMBER_TABLE
1519 , p5_a111 JTF_NUMBER_TABLE
1520 , p5_a112 JTF_NUMBER_TABLE
1521 , p5_a113 JTF_NUMBER_TABLE
1522 , p5_a114 JTF_NUMBER_TABLE
1523 , p5_a115 JTF_VARCHAR2_TABLE_100
1524 , p5_a116 JTF_VARCHAR2_TABLE_300
1525 , p5_a117 JTF_NUMBER_TABLE
1526 , p5_a118 JTF_NUMBER_TABLE
1527 , p5_a119 JTF_NUMBER_TABLE
1528 , p5_a120 JTF_NUMBER_TABLE
1529 , p5_a121 JTF_NUMBER_TABLE
1530 , p5_a122 JTF_NUMBER_TABLE
1531 , p5_a123 JTF_NUMBER_TABLE
1532 , p5_a124 JTF_NUMBER_TABLE
1533 , p5_a125 JTF_VARCHAR2_TABLE_100
1534 , p5_a126 JTF_VARCHAR2_TABLE_100
1535 , p5_a127 JTF_NUMBER_TABLE
1536 , p5_a128 JTF_DATE_TABLE
1537 , p5_a129 JTF_NUMBER_TABLE
1538 , p5_a130 JTF_NUMBER_TABLE
1539 , p5_a131 JTF_NUMBER_TABLE
1540 , p5_a132 JTF_NUMBER_TABLE
1541 , p5_a133 JTF_VARCHAR2_TABLE_100
1542 , p5_a134 JTF_NUMBER_TABLE
1543 , p5_a135 JTF_VARCHAR2_TABLE_100
1544 , p5_a136 JTF_NUMBER_TABLE
1545 , p5_a137 JTF_NUMBER_TABLE
1546 , p5_a138 JTF_NUMBER_TABLE
1547 , p5_a139 JTF_DATE_TABLE
1548 , p5_a140 JTF_NUMBER_TABLE
1549 , p5_a141 JTF_NUMBER_TABLE
1550 , p5_a142 JTF_VARCHAR2_TABLE_100
1551 , p5_a143 JTF_VARCHAR2_TABLE_100
1552 , p5_a144 JTF_VARCHAR2_TABLE_100
1553 , p5_a145 JTF_VARCHAR2_TABLE_300
1554 , p5_a146 JTF_VARCHAR2_TABLE_300
1555 , p5_a147 JTF_VARCHAR2_TABLE_200
1556 , p5_a148 JTF_DATE_TABLE
1557 , p5_a149 JTF_VARCHAR2_TABLE_200
1558 , p5_a150 JTF_VARCHAR2_TABLE_200
1559 , p5_a151 JTF_DATE_TABLE
1560 , p5_a152 JTF_DATE_TABLE
1561 , p5_a153 JTF_DATE_TABLE
1562 , p5_a154 JTF_NUMBER_TABLE
1563 , p5_a155 JTF_NUMBER_TABLE
1564 , p5_a156 JTF_VARCHAR2_TABLE_200
1565 , p5_a157 JTF_NUMBER_TABLE
1566 , p5_a158 JTF_VARCHAR2_TABLE_100
1567 , p5_a159 JTF_VARCHAR2_TABLE_200
1568 , p5_a160 JTF_DATE_TABLE
1569 , p5_a161 JTF_NUMBER_TABLE
1570 , p5_a162 JTF_VARCHAR2_TABLE_100
1571 , p5_a163 JTF_NUMBER_TABLE
1572 , p5_a164 JTF_NUMBER_TABLE
1573 , p5_a165 JTF_VARCHAR2_TABLE_100
1574 , p5_a166 JTF_NUMBER_TABLE
1575 , p5_a167 JTF_VARCHAR2_TABLE_100
1576 , p5_a168 JTF_VARCHAR2_TABLE_200
1577 , p5_a169 JTF_VARCHAR2_TABLE_100
1578 , p5_a170 JTF_VARCHAR2_TABLE_100
1579 , p5_a171 JTF_VARCHAR2_TABLE_100
1580 , p5_a172 JTF_VARCHAR2_TABLE_100
1581 , p5_a173 JTF_VARCHAR2_TABLE_100
1582 , p5_a174 JTF_VARCHAR2_TABLE_100
1583 , p5_a175 JTF_VARCHAR2_TABLE_100
1584 , p5_a176 JTF_NUMBER_TABLE
1585 , p5_a177 JTF_NUMBER_TABLE
1586 , p5_a178 JTF_NUMBER_TABLE
1587 , p5_a179 JTF_NUMBER_TABLE
1588 , p5_a180 JTF_NUMBER_TABLE
1589 , p5_a181 JTF_NUMBER_TABLE
1590 , p5_a182 JTF_NUMBER_TABLE
1591 , p5_a183 JTF_NUMBER_TABLE
1592 , p5_a184 JTF_NUMBER_TABLE
1593 , p5_a185 JTF_NUMBER_TABLE
1594 , p5_a186 JTF_NUMBER_TABLE
1595 , p5_a187 JTF_NUMBER_TABLE
1596 , p5_a188 JTF_NUMBER_TABLE
1597 , p5_a189 JTF_VARCHAR2_TABLE_100
1598 , p5_a190 JTF_VARCHAR2_TABLE_100
1599 , p5_a191 JTF_VARCHAR2_TABLE_300
1600 , x_return_status out nocopy VARCHAR2
1601 , x_msg_count out nocopy NUMBER
1602 , x_msg_data out nocopy VARCHAR2
1603 )
1604
1605 as
1606 ddp_receive_hdr_rec csp_receive_pvt.rcv_hdr_rec_type;
1607 ddp_receive_rec_tbl csp_receive_pvt.rcv_rec_tbl_type;
1608 ddindx binary_integer; indx binary_integer;
1609 begin
1610
1611 -- copy data to the local IN or IN-OUT args, if any
1612
1613
1614
1615
1616 ddp_receive_hdr_rec.header_interface_id := p4_a0;
1617 ddp_receive_hdr_rec.group_id := p4_a1;
1618 ddp_receive_hdr_rec.vendor_id := p4_a2;
1619 ddp_receive_hdr_rec.vendor_site_id := p4_a3;
1620 ddp_receive_hdr_rec.source_type_code := p4_a4;
1621 ddp_receive_hdr_rec.receipt_source_code := p4_a5;
1622 ddp_receive_hdr_rec.ship_to_org_id := p4_a6;
1623 ddp_receive_hdr_rec.rcv_shipment_num := p4_a7;
1624 ddp_receive_hdr_rec.receipt_header_id := p4_a8;
1625 ddp_receive_hdr_rec.receipt_num := p4_a9;
1626 ddp_receive_hdr_rec.bill_of_lading := p4_a10;
1627 ddp_receive_hdr_rec.packing_slip := p4_a11;
1628 ddp_receive_hdr_rec.shipped_date := p4_a12;
1629 ddp_receive_hdr_rec.freight_carrier_code := p4_a13;
1630 ddp_receive_hdr_rec.expected_receipt_date := p4_a14;
1631 ddp_receive_hdr_rec.employee_id := p4_a15;
1632 ddp_receive_hdr_rec.waybill_airbill_num := p4_a16;
1633 ddp_receive_hdr_rec.usggl_transaction_code := p4_a17;
1634 ddp_receive_hdr_rec.processing_request_id := p4_a18;
1635 ddp_receive_hdr_rec.customer_id := p4_a19;
1636 ddp_receive_hdr_rec.customer_site_id := p4_a20;
1637
1638 csp_receive_pvt_w.rosetta_table_copy_in_p5(ddp_receive_rec_tbl, p5_a0
1639 , p5_a1
1643 , p5_a5
1640 , p5_a2
1641 , p5_a3
1642 , p5_a4
1644 , p5_a6
1645 , p5_a7
1646 , p5_a8
1647 , p5_a9
1648 , p5_a10
1649 , p5_a11
1650 , p5_a12
1651 , p5_a13
1652 , p5_a14
1653 , p5_a15
1654 , p5_a16
1655 , p5_a17
1656 , p5_a18
1657 , p5_a19
1658 , p5_a20
1659 , p5_a21
1660 , p5_a22
1661 , p5_a23
1662 , p5_a24
1663 , p5_a25
1664 , p5_a26
1665 , p5_a27
1666 , p5_a28
1667 , p5_a29
1668 , p5_a30
1669 , p5_a31
1670 , p5_a32
1671 , p5_a33
1672 , p5_a34
1673 , p5_a35
1674 , p5_a36
1675 , p5_a37
1676 , p5_a38
1677 , p5_a39
1678 , p5_a40
1679 , p5_a41
1680 , p5_a42
1681 , p5_a43
1682 , p5_a44
1683 , p5_a45
1684 , p5_a46
1685 , p5_a47
1686 , p5_a48
1687 , p5_a49
1688 , p5_a50
1689 , p5_a51
1690 , p5_a52
1691 , p5_a53
1692 , p5_a54
1693 , p5_a55
1694 , p5_a56
1695 , p5_a57
1696 , p5_a58
1697 , p5_a59
1698 , p5_a60
1699 , p5_a61
1700 , p5_a62
1701 , p5_a63
1702 , p5_a64
1703 , p5_a65
1704 , p5_a66
1705 , p5_a67
1706 , p5_a68
1707 , p5_a69
1708 , p5_a70
1709 , p5_a71
1710 , p5_a72
1711 , p5_a73
1712 , p5_a74
1713 , p5_a75
1714 , p5_a76
1715 , p5_a77
1716 , p5_a78
1717 , p5_a79
1718 , p5_a80
1719 , p5_a81
1720 , p5_a82
1721 , p5_a83
1722 , p5_a84
1723 , p5_a85
1724 , p5_a86
1725 , p5_a87
1726 , p5_a88
1727 , p5_a89
1728 , p5_a90
1729 , p5_a91
1730 , p5_a92
1731 , p5_a93
1732 , p5_a94
1733 , p5_a95
1734 , p5_a96
1735 , p5_a97
1736 , p5_a98
1737 , p5_a99
1738 , p5_a100
1739 , p5_a101
1740 , p5_a102
1741 , p5_a103
1742 , p5_a104
1743 , p5_a105
1744 , p5_a106
1745 , p5_a107
1746 , p5_a108
1747 , p5_a109
1748 , p5_a110
1749 , p5_a111
1750 , p5_a112
1751 , p5_a113
1752 , p5_a114
1753 , p5_a115
1754 , p5_a116
1755 , p5_a117
1756 , p5_a118
1757 , p5_a119
1758 , p5_a120
1759 , p5_a121
1760 , p5_a122
1761 , p5_a123
1762 , p5_a124
1763 , p5_a125
1764 , p5_a126
1765 , p5_a127
1766 , p5_a128
1767 , p5_a129
1768 , p5_a130
1769 , p5_a131
1770 , p5_a132
1771 , p5_a133
1772 , p5_a134
1773 , p5_a135
1774 , p5_a136
1775 , p5_a137
1776 , p5_a138
1777 , p5_a139
1778 , p5_a140
1779 , p5_a141
1780 , p5_a142
1781 , p5_a143
1782 , p5_a144
1783 , p5_a145
1784 , p5_a146
1785 , p5_a147
1786 , p5_a148
1787 , p5_a149
1788 , p5_a150
1789 , p5_a151
1790 , p5_a152
1791 , p5_a153
1792 , p5_a154
1793 , p5_a155
1794 , p5_a156
1795 , p5_a157
1796 , p5_a158
1797 , p5_a159
1798 , p5_a160
1799 , p5_a161
1800 , p5_a162
1801 , p5_a163
1802 , p5_a164
1803 , p5_a165
1804 , p5_a166
1805 , p5_a167
1806 , p5_a168
1807 , p5_a169
1808 , p5_a170
1809 , p5_a171
1810 , p5_a172
1811 , p5_a173
1812 , p5_a174
1813 , p5_a175
1814 , p5_a176
1815 , p5_a177
1816 , p5_a178
1817 , p5_a179
1818 , p5_a180
1819 , p5_a181
1820 , p5_a182
1821 , p5_a183
1822 , p5_a184
1823 , p5_a185
1824 , p5_a186
1825 , p5_a187
1826 , p5_a188
1827 , p5_a189
1828 , p5_a190
1829 , p5_a191
1830 );
1831
1832
1833
1834
1835 -- here's the delegated call to the old PL/SQL routine
1836 csp_receive_pvt.receive_shipments(p_api_version_number,
1837 p_init_msg_list,
1838 p_commit,
1839 p_validation_level,
1840 ddp_receive_hdr_rec,
1841 ddp_receive_rec_tbl,
1842 x_return_status,
1843 x_msg_count,
1844 x_msg_data);
1845
1846 -- copy data back from the local variables to OUT or IN-OUT args, if any
1847
1848
1849
1850
1851
1852
1853
1854
1855 end;
1856
1857 procedure insert_rcv_txn_interface(p_api_version_number NUMBER
1858 , p_init_msg_list VARCHAR2
1859 , p_commit VARCHAR2
1860 , p_validation_level NUMBER
1861 , x_return_status out nocopy VARCHAR2
1862 , x_msg_count out nocopy NUMBER
1863 , x_msg_data out nocopy VARCHAR2
1864 , x_interface_transaction_id out nocopy NUMBER
1865 , p8_a0 NUMBER
1866 , p8_a1 NUMBER
1867 , p8_a2 NUMBER
1871 , p8_a6 VARCHAR2
1868 , p8_a3 NUMBER
1869 , p8_a4 NUMBER
1870 , p8_a5 VARCHAR2
1872 , p8_a7 VARCHAR2
1873 , p8_a8 VARCHAR2
1874 , p8_a9 NUMBER
1875 , p8_a10 VARCHAR2
1876 , p8_a11 NUMBER
1877 , p8_a12 NUMBER
1878 , p8_a13 NUMBER
1879 , p8_a14 NUMBER
1880 , p8_a15 NUMBER
1881 , p8_a16 NUMBER
1882 , p8_a17 NUMBER
1883 , p8_a18 VARCHAR2
1884 , p8_a19 NUMBER
1885 , p8_a20 NUMBER
1886 , p8_a21 NUMBER
1887 , p8_a22 NUMBER
1888 , p8_a23 VARCHAR2
1889 , p8_a24 NUMBER
1890 , p8_a25 NUMBER
1891 , p8_a26 NUMBER
1892 , p8_a27 NUMBER
1893 , p8_a28 NUMBER
1894 , p8_a29 VARCHAR2
1895 , p8_a30 NUMBER
1896 , p8_a31 VARCHAR2
1897 , p8_a32 VARCHAR2
1898 , p8_a33 NUMBER
1899 , p8_a34 VARCHAR2
1900 , p8_a35 VARCHAR2
1901 , p8_a36 VARCHAR2
1902 , p8_a37 NUMBER
1903 , p8_a38 NUMBER
1904 , p8_a39 VARCHAR2
1905 , p8_a40 VARCHAR2
1906 , p8_a41 NUMBER
1907 , p8_a42 NUMBER
1908 , p8_a43 NUMBER
1909 , p8_a44 NUMBER
1910 , p8_a45 VARCHAR2
1911 , p8_a46 VARCHAR2
1912 , p8_a47 VARCHAR2
1913 , p8_a48 VARCHAR2
1914 , p8_a49 VARCHAR2
1915 , p8_a50 NUMBER
1916 , p8_a51 VARCHAR2
1917 , p8_a52 VARCHAR2
1918 , p8_a53 VARCHAR2
1919 , p8_a54 NUMBER
1920 , p8_a55 VARCHAR2
1921 , p8_a56 VARCHAR2
1922 , p8_a57 NUMBER
1923 , p8_a58 VARCHAR2
1924 , p8_a59 DATE
1925 , p8_a60 DATE
1926 , p8_a61 NUMBER
1927 , p8_a62 VARCHAR2
1928 , p8_a63 VARCHAR2
1929 , p8_a64 VARCHAR2
1930 , p8_a65 VARCHAR2
1931 , p8_a66 VARCHAR2
1932 , p8_a67 VARCHAR2
1933 , p8_a68 VARCHAR2
1934 , p8_a69 NUMBER
1935 , p8_a70 VARCHAR2
1936 , p8_a71 VARCHAR2
1937 , p8_a72 DATE
1938 , p8_a73 NUMBER
1939 , p8_a74 VARCHAR2
1940 , p8_a75 VARCHAR2
1941 , p8_a76 NUMBER
1942 , p8_a77 NUMBER
1943 , p8_a78 VARCHAR2
1944 , p8_a79 VARCHAR2
1945 , p8_a80 VARCHAR2
1946 , p8_a81 VARCHAR2
1947 , p8_a82 VARCHAR2
1948 , p8_a83 VARCHAR2
1949 , p8_a84 VARCHAR2
1950 , p8_a85 VARCHAR2
1951 , p8_a86 VARCHAR2
1952 , p8_a87 VARCHAR2
1953 , p8_a88 VARCHAR2
1954 , p8_a89 VARCHAR2
1955 , p8_a90 VARCHAR2
1956 , p8_a91 VARCHAR2
1957 , p8_a92 VARCHAR2
1958 , p8_a93 VARCHAR2
1959 , p8_a94 VARCHAR2
1960 , p8_a95 VARCHAR2
1961 , p8_a96 VARCHAR2
1962 , p8_a97 VARCHAR2
1963 , p8_a98 DATE
1964 , p8_a99 VARCHAR2
1965 , p8_a100 VARCHAR2
1966 , p8_a101 VARCHAR2
1967 , p8_a102 VARCHAR2
1968 , p8_a103 VARCHAR2
1969 , p8_a104 VARCHAR2
1970 , p8_a105 VARCHAR2
1971 , p8_a106 VARCHAR2
1972 , p8_a107 VARCHAR2
1973 , p8_a108 VARCHAR2
1974 , p8_a109 NUMBER
1975 , p8_a110 NUMBER
1976 , p8_a111 NUMBER
1977 , p8_a112 NUMBER
1978 , p8_a113 NUMBER
1979 , p8_a114 NUMBER
1980 , p8_a115 VARCHAR2
1981 , p8_a116 VARCHAR2
1982 , p8_a117 NUMBER
1983 , p8_a118 NUMBER
1984 , p8_a119 NUMBER
1985 , p8_a120 NUMBER
1986 , p8_a121 NUMBER
1987 , p8_a122 NUMBER
1988 , p8_a123 NUMBER
1989 , p8_a124 NUMBER
1990 , p8_a125 VARCHAR2
1991 , p8_a126 VARCHAR2
1992 , p8_a127 NUMBER
1993 , p8_a128 DATE
1994 , p8_a129 NUMBER
1995 , p8_a130 NUMBER
1996 , p8_a131 NUMBER
1997 , p8_a132 NUMBER
1998 , p8_a133 VARCHAR2
1999 , p8_a134 NUMBER
2000 , p8_a135 VARCHAR2
2001 , p8_a136 NUMBER
2002 , p8_a137 NUMBER
2003 , p8_a138 NUMBER
2004 , p8_a139 DATE
2005 , p8_a140 NUMBER
2006 , p8_a141 NUMBER
2007 , p8_a142 VARCHAR2
2008 , p8_a143 VARCHAR2
2009 , p8_a144 VARCHAR2
2010 , p8_a145 VARCHAR2
2011 , p8_a146 VARCHAR2
2012 , p8_a147 VARCHAR2
2013 , p8_a148 DATE
2014 , p8_a149 VARCHAR2
2015 , p8_a150 VARCHAR2
2016 , p8_a151 DATE
2017 , p8_a152 DATE
2018 , p8_a153 DATE
2019 , p8_a154 NUMBER
2020 , p8_a155 NUMBER
2021 , p8_a156 VARCHAR2
2022 , p8_a157 NUMBER
2023 , p8_a158 VARCHAR2
2024 , p8_a159 VARCHAR2
2025 , p8_a160 DATE
2026 , p8_a161 NUMBER
2027 , p8_a162 VARCHAR2
2028 , p8_a163 NUMBER
2029 , p8_a164 NUMBER
2030 , p8_a165 VARCHAR2
2031 , p8_a166 NUMBER
2032 , p8_a167 VARCHAR2
2033 , p8_a168 VARCHAR2
2034 , p8_a169 VARCHAR2
2035 , p8_a170 VARCHAR2
2036 , p8_a171 VARCHAR2
2037 , p8_a172 VARCHAR2
2038 , p8_a173 VARCHAR2
2039 , p8_a174 VARCHAR2
2040 , p8_a175 VARCHAR2
2041 , p8_a176 NUMBER
2042 , p8_a177 NUMBER
2043 , p8_a178 NUMBER
2044 , p8_a179 NUMBER
2045 , p8_a180 NUMBER
2046 , p8_a181 NUMBER
2047 , p8_a182 NUMBER
2048 , p8_a183 NUMBER
2049 , p8_a184 NUMBER
2050 , p8_a185 NUMBER
2051 , p8_a186 NUMBER
2052 , p8_a187 NUMBER
2053 , p8_a188 NUMBER
2054 , p8_a189 VARCHAR2
2055 , p8_a190 VARCHAR2
2056 , p8_a191 VARCHAR2
2057 )
2058
2059 as
2060 ddp_receive_rec csp_receive_pvt.rcv_rec_type;
2061 ddindx binary_integer; indx binary_integer;
2062 begin
2063
2067
2064 -- copy data to the local IN or IN-OUT args, if any
2065
2066
2068
2069
2070
2071
2072
2073 ddp_receive_rec.interface_transaction_id := p8_a0;
2074 ddp_receive_rec.transaction_interface_id := p8_a1;
2075 ddp_receive_rec.header_interface_id := p8_a2;
2076 ddp_receive_rec.group_id := p8_a3;
2077 ddp_receive_rec.inv_loc_assignment_id := p8_a4;
2078 ddp_receive_rec.source_type_code := p8_a5;
2079 ddp_receive_rec.receipt_source_code := p8_a6;
2080 ddp_receive_rec.order_type_code := p8_a7;
2081 ddp_receive_rec.order_type := p8_a8;
2082 ddp_receive_rec.po_header_id := p8_a9;
2083 ddp_receive_rec.po_number := p8_a10;
2084 ddp_receive_rec.po_line_id := p8_a11;
2085 ddp_receive_rec.po_line_number := p8_a12;
2086 ddp_receive_rec.po_line_location_id := p8_a13;
2087 ddp_receive_rec.po_shipment_number := p8_a14;
2088 ddp_receive_rec.po_release_id := p8_a15;
2089 ddp_receive_rec.po_release_number := p8_a16;
2090 ddp_receive_rec.req_header_id := p8_a17;
2091 ddp_receive_rec.req_number := p8_a18;
2092 ddp_receive_rec.req_line_id := p8_a19;
2093 ddp_receive_rec.req_line := p8_a20;
2094 ddp_receive_rec.req_distribution_id := p8_a21;
2095 ddp_receive_rec.rcv_shipment_header_id := p8_a22;
2096 ddp_receive_rec.rcv_shipment_number := p8_a23;
2097 ddp_receive_rec.rcv_shipment_line_id := p8_a24;
2098 ddp_receive_rec.rcv_line_number := p8_a25;
2099 ddp_receive_rec.from_organization_id := p8_a26;
2100 ddp_receive_rec.to_organization_id := p8_a27;
2101 ddp_receive_rec.vendor_id := p8_a28;
2102 ddp_receive_rec.source := p8_a29;
2103 ddp_receive_rec.vendor_site_id := p8_a30;
2104 ddp_receive_rec.outside_operation_flag := p8_a31;
2105 ddp_receive_rec.receipt_exception := p8_a32;
2106 ddp_receive_rec.item_id := p8_a33;
2107 ddp_receive_rec.uom_code := p8_a34;
2108 ddp_receive_rec.primary_uom := p8_a35;
2109 ddp_receive_rec.primary_uom_class := p8_a36;
2110 ddp_receive_rec.item_allowed_units_lookup_code := p8_a37;
2111 ddp_receive_rec.item_locator_control := p8_a38;
2112 ddp_receive_rec.restrict_locators_code := p8_a39;
2113 ddp_receive_rec.restrict_subinventories_code := p8_a40;
2114 ddp_receive_rec.shelf_life_code := p8_a41;
2115 ddp_receive_rec.shelf_life_days := p8_a42;
2116 ddp_receive_rec.serial_number_control_code := p8_a43;
2117 ddp_receive_rec.lot_control_code := p8_a44;
2118 ddp_receive_rec.item_rev_control_flag_to := p8_a45;
2119 ddp_receive_rec.item_rev_control_flag_from := p8_a46;
2120 ddp_receive_rec.item_number := p8_a47;
2121 ddp_receive_rec.item_revision := p8_a48;
2122 ddp_receive_rec.item_description := p8_a49;
2123 ddp_receive_rec.item_category_id := p8_a50;
2124 ddp_receive_rec.hazard_class := p8_a51;
2125 ddp_receive_rec.un_number := p8_a52;
2126 ddp_receive_rec.vendor_item_number := p8_a53;
2127 ddp_receive_rec.ship_to_location_id := p8_a54;
2128 ddp_receive_rec.ship_to_location := p8_a55;
2129 ddp_receive_rec.packing_slip := p8_a56;
2130 ddp_receive_rec.routing_id := p8_a57;
2131 ddp_receive_rec.routing_name := p8_a58;
2132 ddp_receive_rec.need_by_date := p8_a59;
2133 ddp_receive_rec.expected_receipt_date := p8_a60;
2134 ddp_receive_rec.ordered_qty := p8_a61;
2135 ddp_receive_rec.ordered_uom := p8_a62;
2136 ddp_receive_rec.ussgl_transaction_code := p8_a63;
2137 ddp_receive_rec.government_context := p8_a64;
2138 ddp_receive_rec.inspection_required_flag := p8_a65;
2139 ddp_receive_rec.receipt_required_flag := p8_a66;
2140 ddp_receive_rec.enforce_ship_to_location_code := p8_a67;
2141 ddp_receive_rec.substitute_receipt := p8_a68;
2142 ddp_receive_rec.unit_price := p8_a69;
2143 ddp_receive_rec.currency_code := p8_a70;
2144 ddp_receive_rec.currency_conversion_type := p8_a71;
2145 ddp_receive_rec.currency_conversion_date := p8_a72;
2146 ddp_receive_rec.currency_conversion_rate := p8_a73;
2147 ddp_receive_rec.note_to_receiver := p8_a74;
2148 ddp_receive_rec.destination_type_code := p8_a75;
2149 ddp_receive_rec.deliver_to_person_id := p8_a76;
2150 ddp_receive_rec.deliver_to_location_id := p8_a77;
2151 ddp_receive_rec.destination_subinventory := p8_a78;
2152 ddp_receive_rec.attribute_category := p8_a79;
2153 ddp_receive_rec.attribute1 := p8_a80;
2154 ddp_receive_rec.attribute2 := p8_a81;
2155 ddp_receive_rec.attribute3 := p8_a82;
2156 ddp_receive_rec.attribute4 := p8_a83;
2157 ddp_receive_rec.attribute5 := p8_a84;
2158 ddp_receive_rec.attribute6 := p8_a85;
2159 ddp_receive_rec.attribute7 := p8_a86;
2160 ddp_receive_rec.attribute8 := p8_a87;
2161 ddp_receive_rec.attribute9 := p8_a88;
2162 ddp_receive_rec.attribute10 := p8_a89;
2163 ddp_receive_rec.attribute11 := p8_a90;
2164 ddp_receive_rec.attribute12 := p8_a91;
2165 ddp_receive_rec.attribute13 := p8_a92;
2166 ddp_receive_rec.attribute14 := p8_a93;
2167 ddp_receive_rec.attribute15 := p8_a94;
2168 ddp_receive_rec.closed_code := p8_a95;
2169 ddp_receive_rec.asn_type := p8_a96;
2170 ddp_receive_rec.bill_of_lading := p8_a97;
2171 ddp_receive_rec.shipped_date := p8_a98;
2172 ddp_receive_rec.freight_carrier_code := p8_a99;
2173 ddp_receive_rec.waybill_airbill_num := p8_a100;
2174 ddp_receive_rec.freight_bill_num := p8_a101;
2175 ddp_receive_rec.vendor_lot_num := p8_a102;
2176 ddp_receive_rec.container_num := p8_a103;
2177 ddp_receive_rec.truck_num := p8_a104;
2178 ddp_receive_rec.bar_code_label := p8_a105;
2179 ddp_receive_rec.rate_type_display := p8_a106;
2180 ddp_receive_rec.match_option := p8_a107;
2181 ddp_receive_rec.country_of_origin_code := p8_a108;
2182 ddp_receive_rec.oe_order_header_id := p8_a109;
2183 ddp_receive_rec.oe_order_num := p8_a110;
2184 ddp_receive_rec.oe_order_line_id := p8_a111;
2185 ddp_receive_rec.oe_order_line_num := p8_a112;
2189 ddp_receive_rec.pll_note_to_receiver := p8_a116;
2186 ddp_receive_rec.customer_id := p8_a113;
2187 ddp_receive_rec.customer_site_id := p8_a114;
2188 ddp_receive_rec.customer_item_num := p8_a115;
2190 ddp_receive_rec.po_distribution_id := p8_a117;
2191 ddp_receive_rec.qty_ordered := p8_a118;
2192 ddp_receive_rec.wip_entity_id := p8_a119;
2193 ddp_receive_rec.wip_operation_seq_num := p8_a120;
2194 ddp_receive_rec.wip_resource_seq_num := p8_a121;
2195 ddp_receive_rec.wip_repetitive_schedule_id := p8_a122;
2196 ddp_receive_rec.wip_line_id := p8_a123;
2197 ddp_receive_rec.bom_resource_id := p8_a124;
2198 ddp_receive_rec.destination_type := p8_a125;
2199 ddp_receive_rec.location := p8_a126;
2200 ddp_receive_rec.currency_conversion_rate_pod := p8_a127;
2201 ddp_receive_rec.currency_conversion_date_pod := p8_a128;
2202 ddp_receive_rec.project_id := p8_a129;
2203 ddp_receive_rec.task_id := p8_a130;
2204 ddp_receive_rec.locator_id := p8_a131;
2205 ddp_receive_rec.employee_id := p8_a132;
2206 ddp_receive_rec.lot_number := p8_a133;
2207 ddp_receive_rec.transaction_quantity := p8_a134;
2208 ddp_receive_rec.transaction_uom := p8_a135;
2209 ddp_receive_rec.primary_quantity := p8_a136;
2210 ddp_receive_rec.lot_quantity := p8_a137;
2211 ddp_receive_rec.lot_primary_quantity := p8_a138;
2212 ddp_receive_rec.expiration_date := p8_a139;
2213 ddp_receive_rec.status_id := p8_a140;
2214 ddp_receive_rec.product_transaction_id := p8_a141;
2215 ddp_receive_rec.product_code := p8_a142;
2216 ddp_receive_rec.att_exist := p8_a143;
2217 ddp_receive_rec.update_mln := p8_a144;
2218 ddp_receive_rec.description := p8_a145;
2219 ddp_receive_rec.vendor_name := p8_a146;
2220 ddp_receive_rec.supplier_lot_number := p8_a147;
2221 ddp_receive_rec.origination_date := p8_a148;
2222 ddp_receive_rec.date_code := p8_a149;
2223 ddp_receive_rec.grade_code := p8_a150;
2224 ddp_receive_rec.change_date := p8_a151;
2225 ddp_receive_rec.maturity_date := p8_a152;
2226 ddp_receive_rec.retest_date := p8_a153;
2227 ddp_receive_rec.age := p8_a154;
2228 ddp_receive_rec.item_size := p8_a155;
2229 ddp_receive_rec.color := p8_a156;
2230 ddp_receive_rec.volume := p8_a157;
2231 ddp_receive_rec.volume_uom := p8_a158;
2232 ddp_receive_rec.place_of_origin := p8_a159;
2233 ddp_receive_rec.best_by_date := p8_a160;
2234 ddp_receive_rec.length := p8_a161;
2235 ddp_receive_rec.length_uom := p8_a162;
2236 ddp_receive_rec.recycled_content := p8_a163;
2237 ddp_receive_rec.thickness := p8_a164;
2238 ddp_receive_rec.thickness_uom := p8_a165;
2239 ddp_receive_rec.width := p8_a166;
2240 ddp_receive_rec.width_uom := p8_a167;
2241 ddp_receive_rec.curl_wrinkle_fold := p8_a168;
2242 ddp_receive_rec.territory_code := p8_a169;
2243 ddp_receive_rec.fm_serial_number := p8_a170;
2244 ddp_receive_rec.to_serial_number := p8_a171;
2245 ddp_receive_rec.update_msn := p8_a172;
2246 ddp_receive_rec.vendor_serial_number := p8_a173;
2247 ddp_receive_rec.vendor_lot_number := p8_a174;
2248 ddp_receive_rec.parent_serial_number := p8_a175;
2249 ddp_receive_rec.time_since_new := p8_a176;
2250 ddp_receive_rec.cycles_since_new := p8_a177;
2251 ddp_receive_rec.time_since_overhaul := p8_a178;
2252 ddp_receive_rec.cycles_since_overhaul := p8_a179;
2253 ddp_receive_rec.time_since_repair := p8_a180;
2254 ddp_receive_rec.cycles_since_repair := p8_a181;
2255 ddp_receive_rec.time_since_visit := p8_a182;
2256 ddp_receive_rec.cycles_since_visit := p8_a183;
2257 ddp_receive_rec.time_since_mark := p8_a184;
2258 ddp_receive_rec.cycles_since_mark := p8_a185;
2259 ddp_receive_rec.number_of_repairs := p8_a186;
2260 ddp_receive_rec.set_of_books_id_sob := p8_a187;
2261 ddp_receive_rec.reason_id := p8_a188;
2262 ddp_receive_rec.currency_code_sob := p8_a189;
2263 ddp_receive_rec.department_code := p8_a190;
2264 ddp_receive_rec.comments := p8_a191;
2265
2266 -- here's the delegated call to the old PL/SQL routine
2267 csp_receive_pvt.insert_rcv_txn_interface(p_api_version_number,
2268 p_init_msg_list,
2269 p_commit,
2270 p_validation_level,
2271 x_return_status,
2272 x_msg_count,
2273 x_msg_data,
2274 x_interface_transaction_id,
2275 ddp_receive_rec);
2276
2277 -- copy data back from the local variables to OUT or IN-OUT args, if any
2278
2279
2280
2281
2282
2283
2284
2285
2286 end;
2287
2288 end csp_receive_pvt_w;