[Home] [Help]
PACKAGE BODY: APPS.OZF_CLAIMS_HISTORY_PVT_W
Source
1 package body ozf_claims_history_pvt_w as
2 /* $Header: ozfwchib.pls 115.3 2003/12/02 23:54:12 yizhang noship $ */
3 rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4 rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5
6 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7 function rosetta_g_miss_date_in_map(d date) return date as
8 begin
9 if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10 return d;
11 end;
12
13 procedure rosetta_table_copy_in_p3(t out nocopy ozf_claims_history_pvt.claims_history_tbl_type, a0 JTF_NUMBER_TABLE
14 , a1 JTF_NUMBER_TABLE
15 , a2 JTF_DATE_TABLE
16 , a3 JTF_NUMBER_TABLE
17 , a4 JTF_DATE_TABLE
18 , a5 JTF_NUMBER_TABLE
19 , a6 JTF_NUMBER_TABLE
20 , a7 JTF_NUMBER_TABLE
21 , a8 JTF_NUMBER_TABLE
22 , a9 JTF_DATE_TABLE
23 , a10 JTF_NUMBER_TABLE
24 , a11 JTF_VARCHAR2_TABLE_100
25 , a12 JTF_NUMBER_TABLE
26 , a13 JTF_NUMBER_TABLE
27 , a14 JTF_VARCHAR2_TABLE_100
28 , a15 JTF_NUMBER_TABLE
29 , a16 JTF_VARCHAR2_TABLE_100
30 , a17 JTF_DATE_TABLE
31 , a18 JTF_DATE_TABLE
32 , a19 JTF_NUMBER_TABLE
33 , a20 JTF_VARCHAR2_TABLE_100
34 , a21 JTF_DATE_TABLE
35 , a22 JTF_VARCHAR2_TABLE_2000
36 , a23 JTF_NUMBER_TABLE
37 , a24 JTF_NUMBER_TABLE
38 , a25 JTF_DATE_TABLE
39 , a26 JTF_NUMBER_TABLE
40 , a27 JTF_NUMBER_TABLE
41 , a28 JTF_NUMBER_TABLE
42 , a29 JTF_NUMBER_TABLE
43 , a30 JTF_NUMBER_TABLE
44 , a31 JTF_NUMBER_TABLE
45 , a32 JTF_NUMBER_TABLE
46 , a33 JTF_NUMBER_TABLE
47 , a34 JTF_NUMBER_TABLE
48 , a35 JTF_NUMBER_TABLE
49 , a36 JTF_VARCHAR2_TABLE_100
50 , a37 JTF_VARCHAR2_TABLE_100
51 , a38 JTF_VARCHAR2_TABLE_100
52 , a39 JTF_VARCHAR2_TABLE_100
53 , a40 JTF_DATE_TABLE
54 , a41 JTF_NUMBER_TABLE
55 , a42 JTF_NUMBER_TABLE
56 , a43 JTF_DATE_TABLE
57 , a44 JTF_NUMBER_TABLE
58 , a45 JTF_VARCHAR2_TABLE_100
59 , a46 JTF_NUMBER_TABLE
60 , a47 JTF_VARCHAR2_TABLE_100
61 , a48 JTF_NUMBER_TABLE
62 , a49 JTF_NUMBER_TABLE
63 , a50 JTF_NUMBER_TABLE
64 , a51 JTF_NUMBER_TABLE
65 , a52 JTF_VARCHAR2_TABLE_100
66 , a53 JTF_NUMBER_TABLE
67 , a54 JTF_NUMBER_TABLE
68 , a55 JTF_VARCHAR2_TABLE_100
69 , a56 JTF_NUMBER_TABLE
70 , a57 JTF_NUMBER_TABLE
71 , a58 JTF_VARCHAR2_TABLE_100
72 , a59 JTF_NUMBER_TABLE
73 , a60 JTF_NUMBER_TABLE
74 , a61 JTF_VARCHAR2_TABLE_100
75 , a62 JTF_NUMBER_TABLE
76 , a63 JTF_NUMBER_TABLE
77 , a64 JTF_NUMBER_TABLE
78 , a65 JTF_NUMBER_TABLE
79 , a66 JTF_NUMBER_TABLE
80 , a67 JTF_NUMBER_TABLE
81 , a68 JTF_DATE_TABLE
82 , a69 JTF_VARCHAR2_TABLE_100
83 , a70 JTF_NUMBER_TABLE
84 , a71 JTF_NUMBER_TABLE
85 , a72 JTF_VARCHAR2_TABLE_100
86 , a73 JTF_NUMBER_TABLE
87 , a74 JTF_NUMBER_TABLE
88 , a75 JTF_DATE_TABLE
89 , a76 JTF_VARCHAR2_TABLE_100
90 , a77 JTF_NUMBER_TABLE
91 , a78 JTF_VARCHAR2_TABLE_100
92 , a79 JTF_NUMBER_TABLE
93 , a80 JTF_VARCHAR2_TABLE_100
94 , a81 JTF_DATE_TABLE
95 , a82 JTF_VARCHAR2_TABLE_100
96 , a83 JTF_VARCHAR2_TABLE_100
97 , a84 JTF_DATE_TABLE
98 , a85 JTF_NUMBER_TABLE
99 , a86 JTF_DATE_TABLE
100 , a87 JTF_NUMBER_TABLE
101 , a88 JTF_DATE_TABLE
102 , a89 JTF_NUMBER_TABLE
103 , a90 JTF_NUMBER_TABLE
104 , a91 JTF_NUMBER_TABLE
105 , a92 JTF_NUMBER_TABLE
106 , a93 JTF_VARCHAR2_TABLE_2000
107 , a94 JTF_NUMBER_TABLE
108 , a95 JTF_DATE_TABLE
109 , a96 JTF_NUMBER_TABLE
110 , a97 JTF_VARCHAR2_TABLE_100
111 , a98 JTF_VARCHAR2_TABLE_100
112 , a99 JTF_VARCHAR2_TABLE_200
113 , a100 JTF_VARCHAR2_TABLE_200
114 , a101 JTF_VARCHAR2_TABLE_200
115 , a102 JTF_VARCHAR2_TABLE_200
116 , a103 JTF_VARCHAR2_TABLE_200
117 , a104 JTF_VARCHAR2_TABLE_200
118 , a105 JTF_VARCHAR2_TABLE_200
119 , a106 JTF_VARCHAR2_TABLE_200
120 , a107 JTF_VARCHAR2_TABLE_200
121 , a108 JTF_VARCHAR2_TABLE_200
122 , a109 JTF_VARCHAR2_TABLE_200
123 , a110 JTF_VARCHAR2_TABLE_200
124 , a111 JTF_VARCHAR2_TABLE_200
125 , a112 JTF_VARCHAR2_TABLE_200
126 , a113 JTF_VARCHAR2_TABLE_200
127 , a114 JTF_VARCHAR2_TABLE_100
128 , a115 JTF_VARCHAR2_TABLE_200
129 , a116 JTF_VARCHAR2_TABLE_200
130 , a117 JTF_VARCHAR2_TABLE_200
131 , a118 JTF_VARCHAR2_TABLE_200
132 , a119 JTF_VARCHAR2_TABLE_200
133 , a120 JTF_VARCHAR2_TABLE_200
134 , a121 JTF_VARCHAR2_TABLE_200
135 , a122 JTF_VARCHAR2_TABLE_200
136 , a123 JTF_VARCHAR2_TABLE_200
137 , a124 JTF_VARCHAR2_TABLE_200
138 , a125 JTF_VARCHAR2_TABLE_200
139 , a126 JTF_VARCHAR2_TABLE_200
140 , a127 JTF_VARCHAR2_TABLE_200
141 , a128 JTF_VARCHAR2_TABLE_200
142 , a129 JTF_VARCHAR2_TABLE_200
143 , a130 JTF_NUMBER_TABLE
144 , a131 JTF_VARCHAR2_TABLE_100
145 , a132 JTF_NUMBER_TABLE
146 , a133 JTF_VARCHAR2_TABLE_100
147 , a134 JTF_VARCHAR2_TABLE_100
148 , a135 JTF_NUMBER_TABLE
149 , a136 JTF_NUMBER_TABLE
150 , a137 JTF_NUMBER_TABLE
151 , a138 JTF_VARCHAR2_TABLE_100
152 , a139 JTF_NUMBER_TABLE
153 , a140 JTF_NUMBER_TABLE
154 , a141 JTF_VARCHAR2_TABLE_300
155 , a142 JTF_VARCHAR2_TABLE_300
156 , a143 JTF_VARCHAR2_TABLE_100
157 ) as
158 ddindx binary_integer; indx binary_integer;
159 begin
160 if a0 is not null and a0.count > 0 then
161 if a0.count > 0 then
162 indx := a0.first;
163 ddindx := 1;
164 while true loop
165 t(ddindx).claim_history_id := a0(indx);
166 t(ddindx).object_version_number := a1(indx);
167 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a2(indx));
168 t(ddindx).last_updated_by := a3(indx);
169 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a4(indx));
170 t(ddindx).created_by := a5(indx);
171 t(ddindx).last_update_login := a6(indx);
172 t(ddindx).request_id := a7(indx);
173 t(ddindx).program_application_id := a8(indx);
174 t(ddindx).program_update_date := rosetta_g_miss_date_in_map(a9(indx));
175 t(ddindx).program_id := a10(indx);
176 t(ddindx).created_from := a11(indx);
177 t(ddindx).batch_id := a12(indx);
178 t(ddindx).claim_id := a13(indx);
179 t(ddindx).claim_number := a14(indx);
180 t(ddindx).claim_type_id := a15(indx);
181 t(ddindx).claim_class := a16(indx);
182 t(ddindx).claim_date := rosetta_g_miss_date_in_map(a17(indx));
183 t(ddindx).due_date := rosetta_g_miss_date_in_map(a18(indx));
184 t(ddindx).owner_id := a19(indx);
185 t(ddindx).history_event := a20(indx);
186 t(ddindx).history_event_date := rosetta_g_miss_date_in_map(a21(indx));
187 t(ddindx).history_event_description := a22(indx);
188 t(ddindx).split_from_claim_id := a23(indx);
189 t(ddindx).duplicate_claim_id := a24(indx);
190 t(ddindx).split_date := rosetta_g_miss_date_in_map(a25(indx));
191 t(ddindx).root_claim_id := a26(indx);
192 t(ddindx).amount := a27(indx);
193 t(ddindx).amount_adjusted := a28(indx);
194 t(ddindx).amount_remaining := a29(indx);
195 t(ddindx).amount_settled := a30(indx);
196 t(ddindx).acctd_amount := a31(indx);
197 t(ddindx).acctd_amount_remaining := a32(indx);
198 t(ddindx).acctd_amount_adjusted := a33(indx);
199 t(ddindx).acctd_amount_settled := a34(indx);
200 t(ddindx).tax_amount := a35(indx);
201 t(ddindx).tax_code := a36(indx);
202 t(ddindx).tax_calculation_flag := a37(indx);
203 t(ddindx).currency_code := a38(indx);
204 t(ddindx).exchange_rate_type := a39(indx);
205 t(ddindx).exchange_rate_date := rosetta_g_miss_date_in_map(a40(indx));
206 t(ddindx).exchange_rate := a41(indx);
207 t(ddindx).set_of_books_id := a42(indx);
208 t(ddindx).original_claim_date := rosetta_g_miss_date_in_map(a43(indx));
209 t(ddindx).source_object_id := a44(indx);
210 t(ddindx).source_object_class := a45(indx);
211 t(ddindx).source_object_type_id := a46(indx);
212 t(ddindx).source_object_number := a47(indx);
213 t(ddindx).cust_account_id := a48(indx);
214 t(ddindx).cust_billto_acct_site_id := a49(indx);
215 t(ddindx).cust_shipto_acct_site_id := a50(indx);
216 t(ddindx).location_id := a51(indx);
217 t(ddindx).pay_related_account_flag := a52(indx);
218 t(ddindx).related_cust_account_id := a53(indx);
219 t(ddindx).related_site_use_id := a54(indx);
220 t(ddindx).relationship_type := a55(indx);
221 t(ddindx).vendor_id := a56(indx);
222 t(ddindx).vendor_site_id := a57(indx);
223 t(ddindx).reason_type := a58(indx);
224 t(ddindx).reason_code_id := a59(indx);
225 t(ddindx).task_template_group_id := a60(indx);
226 t(ddindx).status_code := a61(indx);
227 t(ddindx).user_status_id := a62(indx);
228 t(ddindx).sales_rep_id := a63(indx);
229 t(ddindx).collector_id := a64(indx);
230 t(ddindx).contact_id := a65(indx);
231 t(ddindx).broker_id := a66(indx);
232 t(ddindx).territory_id := a67(indx);
233 t(ddindx).customer_ref_date := rosetta_g_miss_date_in_map(a68(indx));
234 t(ddindx).customer_ref_number := a69(indx);
235 t(ddindx).assigned_to := a70(indx);
236 t(ddindx).receipt_id := a71(indx);
237 t(ddindx).receipt_number := a72(indx);
238 t(ddindx).doc_sequence_id := a73(indx);
239 t(ddindx).doc_sequence_value := a74(indx);
240 t(ddindx).gl_date := rosetta_g_miss_date_in_map(a75(indx));
241 t(ddindx).payment_method := a76(indx);
242 t(ddindx).voucher_id := a77(indx);
243 t(ddindx).voucher_number := a78(indx);
244 t(ddindx).payment_reference_id := a79(indx);
245 t(ddindx).payment_reference_number := a80(indx);
246 t(ddindx).payment_reference_date := rosetta_g_miss_date_in_map(a81(indx));
247 t(ddindx).payment_status := a82(indx);
248 t(ddindx).approved_flag := a83(indx);
249 t(ddindx).approved_date := rosetta_g_miss_date_in_map(a84(indx));
250 t(ddindx).approved_by := a85(indx);
251 t(ddindx).settled_date := rosetta_g_miss_date_in_map(a86(indx));
252 t(ddindx).settled_by := a87(indx);
253 t(ddindx).effective_date := rosetta_g_miss_date_in_map(a88(indx));
254 t(ddindx).custom_setup_id := a89(indx);
255 t(ddindx).task_id := a90(indx);
256 t(ddindx).country_id := a91(indx);
257 t(ddindx).order_type_id := a92(indx);
258 t(ddindx).comments := a93(indx);
259 t(ddindx).letter_id := a94(indx);
260 t(ddindx).letter_date := rosetta_g_miss_date_in_map(a95(indx));
261 t(ddindx).task_source_object_id := a96(indx);
262 t(ddindx).task_source_object_type_code := a97(indx);
263 t(ddindx).attribute_category := a98(indx);
264 t(ddindx).attribute1 := a99(indx);
265 t(ddindx).attribute2 := a100(indx);
266 t(ddindx).attribute3 := a101(indx);
267 t(ddindx).attribute4 := a102(indx);
268 t(ddindx).attribute5 := a103(indx);
269 t(ddindx).attribute6 := a104(indx);
270 t(ddindx).attribute7 := a105(indx);
271 t(ddindx).attribute8 := a106(indx);
272 t(ddindx).attribute9 := a107(indx);
273 t(ddindx).attribute10 := a108(indx);
274 t(ddindx).attribute11 := a109(indx);
275 t(ddindx).attribute12 := a110(indx);
276 t(ddindx).attribute13 := a111(indx);
277 t(ddindx).attribute14 := a112(indx);
278 t(ddindx).attribute15 := a113(indx);
279 t(ddindx).deduction_attribute_category := a114(indx);
280 t(ddindx).deduction_attribute1 := a115(indx);
281 t(ddindx).deduction_attribute2 := a116(indx);
282 t(ddindx).deduction_attribute3 := a117(indx);
283 t(ddindx).deduction_attribute4 := a118(indx);
284 t(ddindx).deduction_attribute5 := a119(indx);
285 t(ddindx).deduction_attribute6 := a120(indx);
286 t(ddindx).deduction_attribute7 := a121(indx);
287 t(ddindx).deduction_attribute8 := a122(indx);
288 t(ddindx).deduction_attribute9 := a123(indx);
289 t(ddindx).deduction_attribute10 := a124(indx);
290 t(ddindx).deduction_attribute11 := a125(indx);
291 t(ddindx).deduction_attribute12 := a126(indx);
292 t(ddindx).deduction_attribute13 := a127(indx);
293 t(ddindx).deduction_attribute14 := a128(indx);
294 t(ddindx).deduction_attribute15 := a129(indx);
295 t(ddindx).org_id := a130(indx);
296 t(ddindx).write_off_flag := a131(indx);
297 t(ddindx).write_off_threshold_amount := a132(indx);
298 t(ddindx).under_write_off_threshold := a133(indx);
299 t(ddindx).customer_reason := a134(indx);
300 t(ddindx).ship_to_cust_account_id := a135(indx);
301 t(ddindx).amount_applied := a136(indx);
302 t(ddindx).applied_receipt_id := a137(indx);
303 t(ddindx).applied_receipt_number := a138(indx);
304 t(ddindx).wo_rec_trx_id := a139(indx);
305 t(ddindx).group_claim_id := a140(indx);
306 t(ddindx).appr_wf_item_key := a141(indx);
307 t(ddindx).cstl_wf_item_key := a142(indx);
308 t(ddindx).batch_type := a143(indx);
309 ddindx := ddindx+1;
310 if a0.last =indx
311 then exit;
312 end if;
313 indx := a0.next(indx);
314 end loop;
315 end if;
316 end if;
317 end rosetta_table_copy_in_p3;
318 procedure rosetta_table_copy_out_p3(t ozf_claims_history_pvt.claims_history_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
319 , a1 out nocopy JTF_NUMBER_TABLE
320 , a2 out nocopy JTF_DATE_TABLE
321 , a3 out nocopy JTF_NUMBER_TABLE
322 , a4 out nocopy JTF_DATE_TABLE
323 , a5 out nocopy JTF_NUMBER_TABLE
324 , a6 out nocopy JTF_NUMBER_TABLE
325 , a7 out nocopy JTF_NUMBER_TABLE
326 , a8 out nocopy JTF_NUMBER_TABLE
327 , a9 out nocopy JTF_DATE_TABLE
328 , a10 out nocopy JTF_NUMBER_TABLE
329 , a11 out nocopy JTF_VARCHAR2_TABLE_100
330 , a12 out nocopy JTF_NUMBER_TABLE
331 , a13 out nocopy JTF_NUMBER_TABLE
332 , a14 out nocopy JTF_VARCHAR2_TABLE_100
333 , a15 out nocopy JTF_NUMBER_TABLE
334 , a16 out nocopy JTF_VARCHAR2_TABLE_100
335 , a17 out nocopy JTF_DATE_TABLE
336 , a18 out nocopy JTF_DATE_TABLE
337 , a19 out nocopy JTF_NUMBER_TABLE
338 , a20 out nocopy JTF_VARCHAR2_TABLE_100
339 , a21 out nocopy JTF_DATE_TABLE
340 , a22 out nocopy JTF_VARCHAR2_TABLE_2000
341 , a23 out nocopy JTF_NUMBER_TABLE
342 , a24 out nocopy JTF_NUMBER_TABLE
343 , a25 out nocopy JTF_DATE_TABLE
344 , a26 out nocopy JTF_NUMBER_TABLE
345 , a27 out nocopy JTF_NUMBER_TABLE
346 , a28 out nocopy JTF_NUMBER_TABLE
347 , a29 out nocopy JTF_NUMBER_TABLE
348 , a30 out nocopy JTF_NUMBER_TABLE
349 , a31 out nocopy JTF_NUMBER_TABLE
350 , a32 out nocopy JTF_NUMBER_TABLE
351 , a33 out nocopy JTF_NUMBER_TABLE
352 , a34 out nocopy JTF_NUMBER_TABLE
353 , a35 out nocopy JTF_NUMBER_TABLE
354 , a36 out nocopy JTF_VARCHAR2_TABLE_100
355 , a37 out nocopy JTF_VARCHAR2_TABLE_100
356 , a38 out nocopy JTF_VARCHAR2_TABLE_100
357 , a39 out nocopy JTF_VARCHAR2_TABLE_100
358 , a40 out nocopy JTF_DATE_TABLE
359 , a41 out nocopy JTF_NUMBER_TABLE
360 , a42 out nocopy JTF_NUMBER_TABLE
361 , a43 out nocopy JTF_DATE_TABLE
362 , a44 out nocopy JTF_NUMBER_TABLE
363 , a45 out nocopy JTF_VARCHAR2_TABLE_100
364 , a46 out nocopy JTF_NUMBER_TABLE
365 , a47 out nocopy JTF_VARCHAR2_TABLE_100
366 , a48 out nocopy JTF_NUMBER_TABLE
367 , a49 out nocopy JTF_NUMBER_TABLE
368 , a50 out nocopy JTF_NUMBER_TABLE
369 , a51 out nocopy JTF_NUMBER_TABLE
370 , a52 out nocopy JTF_VARCHAR2_TABLE_100
371 , a53 out nocopy JTF_NUMBER_TABLE
372 , a54 out nocopy JTF_NUMBER_TABLE
373 , a55 out nocopy JTF_VARCHAR2_TABLE_100
374 , a56 out nocopy JTF_NUMBER_TABLE
375 , a57 out nocopy JTF_NUMBER_TABLE
376 , a58 out nocopy JTF_VARCHAR2_TABLE_100
377 , a59 out nocopy JTF_NUMBER_TABLE
378 , a60 out nocopy JTF_NUMBER_TABLE
379 , a61 out nocopy JTF_VARCHAR2_TABLE_100
380 , a62 out nocopy JTF_NUMBER_TABLE
381 , a63 out nocopy JTF_NUMBER_TABLE
382 , a64 out nocopy JTF_NUMBER_TABLE
383 , a65 out nocopy JTF_NUMBER_TABLE
384 , a66 out nocopy JTF_NUMBER_TABLE
385 , a67 out nocopy JTF_NUMBER_TABLE
386 , a68 out nocopy JTF_DATE_TABLE
387 , a69 out nocopy JTF_VARCHAR2_TABLE_100
388 , a70 out nocopy JTF_NUMBER_TABLE
389 , a71 out nocopy JTF_NUMBER_TABLE
390 , a72 out nocopy JTF_VARCHAR2_TABLE_100
391 , a73 out nocopy JTF_NUMBER_TABLE
392 , a74 out nocopy JTF_NUMBER_TABLE
393 , a75 out nocopy JTF_DATE_TABLE
394 , a76 out nocopy JTF_VARCHAR2_TABLE_100
395 , a77 out nocopy JTF_NUMBER_TABLE
396 , a78 out nocopy JTF_VARCHAR2_TABLE_100
397 , a79 out nocopy JTF_NUMBER_TABLE
398 , a80 out nocopy JTF_VARCHAR2_TABLE_100
399 , a81 out nocopy JTF_DATE_TABLE
400 , a82 out nocopy JTF_VARCHAR2_TABLE_100
401 , a83 out nocopy JTF_VARCHAR2_TABLE_100
402 , a84 out nocopy JTF_DATE_TABLE
403 , a85 out nocopy JTF_NUMBER_TABLE
404 , a86 out nocopy JTF_DATE_TABLE
405 , a87 out nocopy JTF_NUMBER_TABLE
406 , a88 out nocopy JTF_DATE_TABLE
407 , a89 out nocopy JTF_NUMBER_TABLE
408 , a90 out nocopy JTF_NUMBER_TABLE
409 , a91 out nocopy JTF_NUMBER_TABLE
410 , a92 out nocopy JTF_NUMBER_TABLE
411 , a93 out nocopy JTF_VARCHAR2_TABLE_2000
412 , a94 out nocopy JTF_NUMBER_TABLE
413 , a95 out nocopy JTF_DATE_TABLE
414 , a96 out nocopy JTF_NUMBER_TABLE
415 , a97 out nocopy JTF_VARCHAR2_TABLE_100
416 , a98 out nocopy JTF_VARCHAR2_TABLE_100
417 , a99 out nocopy JTF_VARCHAR2_TABLE_200
418 , a100 out nocopy JTF_VARCHAR2_TABLE_200
419 , a101 out nocopy JTF_VARCHAR2_TABLE_200
420 , a102 out nocopy JTF_VARCHAR2_TABLE_200
421 , a103 out nocopy JTF_VARCHAR2_TABLE_200
422 , a104 out nocopy JTF_VARCHAR2_TABLE_200
423 , a105 out nocopy JTF_VARCHAR2_TABLE_200
424 , a106 out nocopy JTF_VARCHAR2_TABLE_200
425 , a107 out nocopy JTF_VARCHAR2_TABLE_200
426 , a108 out nocopy JTF_VARCHAR2_TABLE_200
427 , a109 out nocopy JTF_VARCHAR2_TABLE_200
428 , a110 out nocopy JTF_VARCHAR2_TABLE_200
429 , a111 out nocopy JTF_VARCHAR2_TABLE_200
430 , a112 out nocopy JTF_VARCHAR2_TABLE_200
431 , a113 out nocopy JTF_VARCHAR2_TABLE_200
432 , a114 out nocopy JTF_VARCHAR2_TABLE_100
433 , a115 out nocopy JTF_VARCHAR2_TABLE_200
434 , a116 out nocopy JTF_VARCHAR2_TABLE_200
435 , a117 out nocopy JTF_VARCHAR2_TABLE_200
436 , a118 out nocopy JTF_VARCHAR2_TABLE_200
437 , a119 out nocopy JTF_VARCHAR2_TABLE_200
438 , a120 out nocopy JTF_VARCHAR2_TABLE_200
439 , a121 out nocopy JTF_VARCHAR2_TABLE_200
440 , a122 out nocopy JTF_VARCHAR2_TABLE_200
441 , a123 out nocopy JTF_VARCHAR2_TABLE_200
442 , a124 out nocopy JTF_VARCHAR2_TABLE_200
443 , a125 out nocopy JTF_VARCHAR2_TABLE_200
444 , a126 out nocopy JTF_VARCHAR2_TABLE_200
445 , a127 out nocopy JTF_VARCHAR2_TABLE_200
446 , a128 out nocopy JTF_VARCHAR2_TABLE_200
447 , a129 out nocopy JTF_VARCHAR2_TABLE_200
448 , a130 out nocopy JTF_NUMBER_TABLE
449 , a131 out nocopy JTF_VARCHAR2_TABLE_100
450 , a132 out nocopy JTF_NUMBER_TABLE
451 , a133 out nocopy JTF_VARCHAR2_TABLE_100
452 , a134 out nocopy JTF_VARCHAR2_TABLE_100
453 , a135 out nocopy JTF_NUMBER_TABLE
454 , a136 out nocopy JTF_NUMBER_TABLE
455 , a137 out nocopy JTF_NUMBER_TABLE
456 , a138 out nocopy JTF_VARCHAR2_TABLE_100
457 , a139 out nocopy JTF_NUMBER_TABLE
458 , a140 out nocopy JTF_NUMBER_TABLE
459 , a141 out nocopy JTF_VARCHAR2_TABLE_300
460 , a142 out nocopy JTF_VARCHAR2_TABLE_300
461 , a143 out nocopy JTF_VARCHAR2_TABLE_100
462 ) as
463 ddindx binary_integer; indx binary_integer;
464 begin
465 if t is null or t.count = 0 then
466 a0 := JTF_NUMBER_TABLE();
467 a1 := JTF_NUMBER_TABLE();
468 a2 := JTF_DATE_TABLE();
469 a3 := JTF_NUMBER_TABLE();
470 a4 := JTF_DATE_TABLE();
471 a5 := JTF_NUMBER_TABLE();
472 a6 := JTF_NUMBER_TABLE();
473 a7 := JTF_NUMBER_TABLE();
474 a8 := JTF_NUMBER_TABLE();
475 a9 := JTF_DATE_TABLE();
476 a10 := JTF_NUMBER_TABLE();
477 a11 := JTF_VARCHAR2_TABLE_100();
478 a12 := JTF_NUMBER_TABLE();
479 a13 := JTF_NUMBER_TABLE();
480 a14 := JTF_VARCHAR2_TABLE_100();
481 a15 := JTF_NUMBER_TABLE();
482 a16 := JTF_VARCHAR2_TABLE_100();
483 a17 := JTF_DATE_TABLE();
484 a18 := JTF_DATE_TABLE();
485 a19 := JTF_NUMBER_TABLE();
486 a20 := JTF_VARCHAR2_TABLE_100();
487 a21 := JTF_DATE_TABLE();
488 a22 := JTF_VARCHAR2_TABLE_2000();
489 a23 := JTF_NUMBER_TABLE();
490 a24 := JTF_NUMBER_TABLE();
491 a25 := JTF_DATE_TABLE();
492 a26 := JTF_NUMBER_TABLE();
493 a27 := JTF_NUMBER_TABLE();
494 a28 := JTF_NUMBER_TABLE();
495 a29 := JTF_NUMBER_TABLE();
496 a30 := JTF_NUMBER_TABLE();
497 a31 := JTF_NUMBER_TABLE();
498 a32 := JTF_NUMBER_TABLE();
499 a33 := JTF_NUMBER_TABLE();
500 a34 := JTF_NUMBER_TABLE();
501 a35 := JTF_NUMBER_TABLE();
502 a36 := JTF_VARCHAR2_TABLE_100();
503 a37 := JTF_VARCHAR2_TABLE_100();
504 a38 := JTF_VARCHAR2_TABLE_100();
505 a39 := JTF_VARCHAR2_TABLE_100();
506 a40 := JTF_DATE_TABLE();
507 a41 := JTF_NUMBER_TABLE();
508 a42 := JTF_NUMBER_TABLE();
509 a43 := JTF_DATE_TABLE();
510 a44 := JTF_NUMBER_TABLE();
511 a45 := JTF_VARCHAR2_TABLE_100();
512 a46 := JTF_NUMBER_TABLE();
513 a47 := JTF_VARCHAR2_TABLE_100();
514 a48 := JTF_NUMBER_TABLE();
515 a49 := JTF_NUMBER_TABLE();
516 a50 := JTF_NUMBER_TABLE();
517 a51 := JTF_NUMBER_TABLE();
518 a52 := JTF_VARCHAR2_TABLE_100();
519 a53 := JTF_NUMBER_TABLE();
520 a54 := JTF_NUMBER_TABLE();
521 a55 := JTF_VARCHAR2_TABLE_100();
522 a56 := JTF_NUMBER_TABLE();
523 a57 := JTF_NUMBER_TABLE();
524 a58 := JTF_VARCHAR2_TABLE_100();
525 a59 := JTF_NUMBER_TABLE();
526 a60 := JTF_NUMBER_TABLE();
527 a61 := JTF_VARCHAR2_TABLE_100();
528 a62 := JTF_NUMBER_TABLE();
529 a63 := JTF_NUMBER_TABLE();
530 a64 := JTF_NUMBER_TABLE();
531 a65 := JTF_NUMBER_TABLE();
532 a66 := JTF_NUMBER_TABLE();
533 a67 := JTF_NUMBER_TABLE();
534 a68 := JTF_DATE_TABLE();
535 a69 := JTF_VARCHAR2_TABLE_100();
536 a70 := JTF_NUMBER_TABLE();
537 a71 := JTF_NUMBER_TABLE();
538 a72 := JTF_VARCHAR2_TABLE_100();
539 a73 := JTF_NUMBER_TABLE();
540 a74 := JTF_NUMBER_TABLE();
541 a75 := JTF_DATE_TABLE();
542 a76 := JTF_VARCHAR2_TABLE_100();
543 a77 := JTF_NUMBER_TABLE();
544 a78 := JTF_VARCHAR2_TABLE_100();
545 a79 := JTF_NUMBER_TABLE();
546 a80 := JTF_VARCHAR2_TABLE_100();
547 a81 := JTF_DATE_TABLE();
548 a82 := JTF_VARCHAR2_TABLE_100();
549 a83 := JTF_VARCHAR2_TABLE_100();
550 a84 := JTF_DATE_TABLE();
551 a85 := JTF_NUMBER_TABLE();
552 a86 := JTF_DATE_TABLE();
553 a87 := JTF_NUMBER_TABLE();
554 a88 := JTF_DATE_TABLE();
555 a89 := JTF_NUMBER_TABLE();
556 a90 := JTF_NUMBER_TABLE();
557 a91 := JTF_NUMBER_TABLE();
558 a92 := JTF_NUMBER_TABLE();
559 a93 := JTF_VARCHAR2_TABLE_2000();
560 a94 := JTF_NUMBER_TABLE();
561 a95 := JTF_DATE_TABLE();
562 a96 := JTF_NUMBER_TABLE();
563 a97 := JTF_VARCHAR2_TABLE_100();
564 a98 := JTF_VARCHAR2_TABLE_100();
565 a99 := JTF_VARCHAR2_TABLE_200();
566 a100 := JTF_VARCHAR2_TABLE_200();
567 a101 := JTF_VARCHAR2_TABLE_200();
568 a102 := JTF_VARCHAR2_TABLE_200();
569 a103 := JTF_VARCHAR2_TABLE_200();
570 a104 := JTF_VARCHAR2_TABLE_200();
571 a105 := JTF_VARCHAR2_TABLE_200();
572 a106 := JTF_VARCHAR2_TABLE_200();
573 a107 := JTF_VARCHAR2_TABLE_200();
574 a108 := JTF_VARCHAR2_TABLE_200();
575 a109 := JTF_VARCHAR2_TABLE_200();
576 a110 := JTF_VARCHAR2_TABLE_200();
577 a111 := JTF_VARCHAR2_TABLE_200();
578 a112 := JTF_VARCHAR2_TABLE_200();
579 a113 := JTF_VARCHAR2_TABLE_200();
580 a114 := JTF_VARCHAR2_TABLE_100();
581 a115 := JTF_VARCHAR2_TABLE_200();
582 a116 := JTF_VARCHAR2_TABLE_200();
583 a117 := JTF_VARCHAR2_TABLE_200();
584 a118 := JTF_VARCHAR2_TABLE_200();
585 a119 := JTF_VARCHAR2_TABLE_200();
586 a120 := JTF_VARCHAR2_TABLE_200();
587 a121 := JTF_VARCHAR2_TABLE_200();
588 a122 := JTF_VARCHAR2_TABLE_200();
589 a123 := JTF_VARCHAR2_TABLE_200();
590 a124 := JTF_VARCHAR2_TABLE_200();
591 a125 := JTF_VARCHAR2_TABLE_200();
592 a126 := JTF_VARCHAR2_TABLE_200();
593 a127 := JTF_VARCHAR2_TABLE_200();
594 a128 := JTF_VARCHAR2_TABLE_200();
595 a129 := JTF_VARCHAR2_TABLE_200();
596 a130 := JTF_NUMBER_TABLE();
597 a131 := JTF_VARCHAR2_TABLE_100();
598 a132 := JTF_NUMBER_TABLE();
599 a133 := JTF_VARCHAR2_TABLE_100();
600 a134 := JTF_VARCHAR2_TABLE_100();
601 a135 := JTF_NUMBER_TABLE();
602 a136 := JTF_NUMBER_TABLE();
603 a137 := JTF_NUMBER_TABLE();
604 a138 := JTF_VARCHAR2_TABLE_100();
605 a139 := JTF_NUMBER_TABLE();
606 a140 := JTF_NUMBER_TABLE();
607 a141 := JTF_VARCHAR2_TABLE_300();
608 a142 := JTF_VARCHAR2_TABLE_300();
609 a143 := JTF_VARCHAR2_TABLE_100();
610 else
611 a0 := JTF_NUMBER_TABLE();
612 a1 := JTF_NUMBER_TABLE();
613 a2 := JTF_DATE_TABLE();
614 a3 := JTF_NUMBER_TABLE();
615 a4 := JTF_DATE_TABLE();
616 a5 := JTF_NUMBER_TABLE();
617 a6 := JTF_NUMBER_TABLE();
618 a7 := JTF_NUMBER_TABLE();
619 a8 := JTF_NUMBER_TABLE();
620 a9 := JTF_DATE_TABLE();
621 a10 := JTF_NUMBER_TABLE();
622 a11 := JTF_VARCHAR2_TABLE_100();
623 a12 := JTF_NUMBER_TABLE();
624 a13 := JTF_NUMBER_TABLE();
625 a14 := JTF_VARCHAR2_TABLE_100();
626 a15 := JTF_NUMBER_TABLE();
627 a16 := JTF_VARCHAR2_TABLE_100();
628 a17 := JTF_DATE_TABLE();
629 a18 := JTF_DATE_TABLE();
630 a19 := JTF_NUMBER_TABLE();
631 a20 := JTF_VARCHAR2_TABLE_100();
632 a21 := JTF_DATE_TABLE();
633 a22 := JTF_VARCHAR2_TABLE_2000();
634 a23 := JTF_NUMBER_TABLE();
635 a24 := JTF_NUMBER_TABLE();
636 a25 := JTF_DATE_TABLE();
637 a26 := JTF_NUMBER_TABLE();
638 a27 := JTF_NUMBER_TABLE();
639 a28 := JTF_NUMBER_TABLE();
640 a29 := JTF_NUMBER_TABLE();
641 a30 := JTF_NUMBER_TABLE();
642 a31 := JTF_NUMBER_TABLE();
643 a32 := JTF_NUMBER_TABLE();
644 a33 := JTF_NUMBER_TABLE();
645 a34 := JTF_NUMBER_TABLE();
646 a35 := JTF_NUMBER_TABLE();
647 a36 := JTF_VARCHAR2_TABLE_100();
648 a37 := JTF_VARCHAR2_TABLE_100();
649 a38 := JTF_VARCHAR2_TABLE_100();
650 a39 := JTF_VARCHAR2_TABLE_100();
651 a40 := JTF_DATE_TABLE();
652 a41 := JTF_NUMBER_TABLE();
653 a42 := JTF_NUMBER_TABLE();
654 a43 := JTF_DATE_TABLE();
655 a44 := JTF_NUMBER_TABLE();
656 a45 := JTF_VARCHAR2_TABLE_100();
657 a46 := JTF_NUMBER_TABLE();
658 a47 := JTF_VARCHAR2_TABLE_100();
659 a48 := JTF_NUMBER_TABLE();
660 a49 := JTF_NUMBER_TABLE();
661 a50 := JTF_NUMBER_TABLE();
662 a51 := JTF_NUMBER_TABLE();
663 a52 := JTF_VARCHAR2_TABLE_100();
664 a53 := JTF_NUMBER_TABLE();
665 a54 := JTF_NUMBER_TABLE();
666 a55 := JTF_VARCHAR2_TABLE_100();
667 a56 := JTF_NUMBER_TABLE();
668 a57 := JTF_NUMBER_TABLE();
669 a58 := JTF_VARCHAR2_TABLE_100();
670 a59 := JTF_NUMBER_TABLE();
671 a60 := JTF_NUMBER_TABLE();
672 a61 := JTF_VARCHAR2_TABLE_100();
673 a62 := JTF_NUMBER_TABLE();
674 a63 := JTF_NUMBER_TABLE();
675 a64 := JTF_NUMBER_TABLE();
676 a65 := JTF_NUMBER_TABLE();
677 a66 := JTF_NUMBER_TABLE();
678 a67 := JTF_NUMBER_TABLE();
679 a68 := JTF_DATE_TABLE();
680 a69 := JTF_VARCHAR2_TABLE_100();
681 a70 := JTF_NUMBER_TABLE();
682 a71 := JTF_NUMBER_TABLE();
683 a72 := JTF_VARCHAR2_TABLE_100();
684 a73 := JTF_NUMBER_TABLE();
685 a74 := JTF_NUMBER_TABLE();
686 a75 := JTF_DATE_TABLE();
687 a76 := JTF_VARCHAR2_TABLE_100();
688 a77 := JTF_NUMBER_TABLE();
689 a78 := JTF_VARCHAR2_TABLE_100();
690 a79 := JTF_NUMBER_TABLE();
691 a80 := JTF_VARCHAR2_TABLE_100();
692 a81 := JTF_DATE_TABLE();
693 a82 := JTF_VARCHAR2_TABLE_100();
694 a83 := JTF_VARCHAR2_TABLE_100();
695 a84 := JTF_DATE_TABLE();
696 a85 := JTF_NUMBER_TABLE();
697 a86 := JTF_DATE_TABLE();
698 a87 := JTF_NUMBER_TABLE();
699 a88 := JTF_DATE_TABLE();
700 a89 := JTF_NUMBER_TABLE();
701 a90 := JTF_NUMBER_TABLE();
702 a91 := JTF_NUMBER_TABLE();
703 a92 := JTF_NUMBER_TABLE();
704 a93 := JTF_VARCHAR2_TABLE_2000();
705 a94 := JTF_NUMBER_TABLE();
706 a95 := JTF_DATE_TABLE();
707 a96 := JTF_NUMBER_TABLE();
708 a97 := JTF_VARCHAR2_TABLE_100();
709 a98 := JTF_VARCHAR2_TABLE_100();
710 a99 := JTF_VARCHAR2_TABLE_200();
711 a100 := JTF_VARCHAR2_TABLE_200();
712 a101 := JTF_VARCHAR2_TABLE_200();
713 a102 := JTF_VARCHAR2_TABLE_200();
714 a103 := JTF_VARCHAR2_TABLE_200();
715 a104 := JTF_VARCHAR2_TABLE_200();
716 a105 := JTF_VARCHAR2_TABLE_200();
717 a106 := JTF_VARCHAR2_TABLE_200();
718 a107 := JTF_VARCHAR2_TABLE_200();
719 a108 := JTF_VARCHAR2_TABLE_200();
720 a109 := JTF_VARCHAR2_TABLE_200();
721 a110 := JTF_VARCHAR2_TABLE_200();
722 a111 := JTF_VARCHAR2_TABLE_200();
723 a112 := JTF_VARCHAR2_TABLE_200();
724 a113 := JTF_VARCHAR2_TABLE_200();
725 a114 := JTF_VARCHAR2_TABLE_100();
726 a115 := JTF_VARCHAR2_TABLE_200();
727 a116 := JTF_VARCHAR2_TABLE_200();
728 a117 := JTF_VARCHAR2_TABLE_200();
729 a118 := JTF_VARCHAR2_TABLE_200();
730 a119 := JTF_VARCHAR2_TABLE_200();
731 a120 := JTF_VARCHAR2_TABLE_200();
732 a121 := JTF_VARCHAR2_TABLE_200();
733 a122 := JTF_VARCHAR2_TABLE_200();
734 a123 := JTF_VARCHAR2_TABLE_200();
735 a124 := JTF_VARCHAR2_TABLE_200();
736 a125 := JTF_VARCHAR2_TABLE_200();
737 a126 := JTF_VARCHAR2_TABLE_200();
738 a127 := JTF_VARCHAR2_TABLE_200();
739 a128 := JTF_VARCHAR2_TABLE_200();
740 a129 := JTF_VARCHAR2_TABLE_200();
741 a130 := JTF_NUMBER_TABLE();
742 a131 := JTF_VARCHAR2_TABLE_100();
743 a132 := JTF_NUMBER_TABLE();
744 a133 := JTF_VARCHAR2_TABLE_100();
745 a134 := JTF_VARCHAR2_TABLE_100();
746 a135 := JTF_NUMBER_TABLE();
747 a136 := JTF_NUMBER_TABLE();
748 a137 := JTF_NUMBER_TABLE();
749 a138 := JTF_VARCHAR2_TABLE_100();
750 a139 := JTF_NUMBER_TABLE();
751 a140 := JTF_NUMBER_TABLE();
752 a141 := JTF_VARCHAR2_TABLE_300();
753 a142 := JTF_VARCHAR2_TABLE_300();
754 a143 := JTF_VARCHAR2_TABLE_100();
755 if t.count > 0 then
756 a0.extend(t.count);
757 a1.extend(t.count);
758 a2.extend(t.count);
759 a3.extend(t.count);
760 a4.extend(t.count);
761 a5.extend(t.count);
762 a6.extend(t.count);
763 a7.extend(t.count);
764 a8.extend(t.count);
765 a9.extend(t.count);
766 a10.extend(t.count);
767 a11.extend(t.count);
768 a12.extend(t.count);
769 a13.extend(t.count);
770 a14.extend(t.count);
771 a15.extend(t.count);
772 a16.extend(t.count);
773 a17.extend(t.count);
774 a18.extend(t.count);
775 a19.extend(t.count);
776 a20.extend(t.count);
777 a21.extend(t.count);
778 a22.extend(t.count);
779 a23.extend(t.count);
780 a24.extend(t.count);
781 a25.extend(t.count);
782 a26.extend(t.count);
783 a27.extend(t.count);
784 a28.extend(t.count);
785 a29.extend(t.count);
786 a30.extend(t.count);
787 a31.extend(t.count);
788 a32.extend(t.count);
789 a33.extend(t.count);
790 a34.extend(t.count);
791 a35.extend(t.count);
792 a36.extend(t.count);
793 a37.extend(t.count);
794 a38.extend(t.count);
795 a39.extend(t.count);
796 a40.extend(t.count);
797 a41.extend(t.count);
798 a42.extend(t.count);
799 a43.extend(t.count);
800 a44.extend(t.count);
801 a45.extend(t.count);
802 a46.extend(t.count);
803 a47.extend(t.count);
804 a48.extend(t.count);
805 a49.extend(t.count);
806 a50.extend(t.count);
807 a51.extend(t.count);
808 a52.extend(t.count);
809 a53.extend(t.count);
810 a54.extend(t.count);
811 a55.extend(t.count);
812 a56.extend(t.count);
813 a57.extend(t.count);
814 a58.extend(t.count);
815 a59.extend(t.count);
816 a60.extend(t.count);
817 a61.extend(t.count);
818 a62.extend(t.count);
819 a63.extend(t.count);
820 a64.extend(t.count);
821 a65.extend(t.count);
822 a66.extend(t.count);
823 a67.extend(t.count);
824 a68.extend(t.count);
825 a69.extend(t.count);
826 a70.extend(t.count);
827 a71.extend(t.count);
828 a72.extend(t.count);
829 a73.extend(t.count);
830 a74.extend(t.count);
831 a75.extend(t.count);
832 a76.extend(t.count);
833 a77.extend(t.count);
834 a78.extend(t.count);
835 a79.extend(t.count);
836 a80.extend(t.count);
837 a81.extend(t.count);
838 a82.extend(t.count);
839 a83.extend(t.count);
840 a84.extend(t.count);
841 a85.extend(t.count);
842 a86.extend(t.count);
843 a87.extend(t.count);
844 a88.extend(t.count);
845 a89.extend(t.count);
846 a90.extend(t.count);
847 a91.extend(t.count);
848 a92.extend(t.count);
849 a93.extend(t.count);
850 a94.extend(t.count);
851 a95.extend(t.count);
852 a96.extend(t.count);
853 a97.extend(t.count);
854 a98.extend(t.count);
855 a99.extend(t.count);
856 a100.extend(t.count);
857 a101.extend(t.count);
858 a102.extend(t.count);
859 a103.extend(t.count);
860 a104.extend(t.count);
861 a105.extend(t.count);
862 a106.extend(t.count);
863 a107.extend(t.count);
864 a108.extend(t.count);
865 a109.extend(t.count);
866 a110.extend(t.count);
867 a111.extend(t.count);
868 a112.extend(t.count);
869 a113.extend(t.count);
870 a114.extend(t.count);
871 a115.extend(t.count);
872 a116.extend(t.count);
873 a117.extend(t.count);
874 a118.extend(t.count);
875 a119.extend(t.count);
876 a120.extend(t.count);
877 a121.extend(t.count);
878 a122.extend(t.count);
879 a123.extend(t.count);
880 a124.extend(t.count);
881 a125.extend(t.count);
882 a126.extend(t.count);
883 a127.extend(t.count);
884 a128.extend(t.count);
885 a129.extend(t.count);
886 a130.extend(t.count);
887 a131.extend(t.count);
888 a132.extend(t.count);
889 a133.extend(t.count);
890 a134.extend(t.count);
891 a135.extend(t.count);
892 a136.extend(t.count);
893 a137.extend(t.count);
894 a138.extend(t.count);
895 a139.extend(t.count);
896 a140.extend(t.count);
897 a141.extend(t.count);
898 a142.extend(t.count);
899 a143.extend(t.count);
900 ddindx := t.first;
901 indx := 1;
902 while true loop
903 a0(indx) := t(ddindx).claim_history_id;
904 a1(indx) := t(ddindx).object_version_number;
905 a2(indx) := t(ddindx).last_update_date;
906 a3(indx) := t(ddindx).last_updated_by;
907 a4(indx) := t(ddindx).creation_date;
908 a5(indx) := t(ddindx).created_by;
909 a6(indx) := t(ddindx).last_update_login;
910 a7(indx) := t(ddindx).request_id;
911 a8(indx) := t(ddindx).program_application_id;
912 a9(indx) := t(ddindx).program_update_date;
913 a10(indx) := t(ddindx).program_id;
914 a11(indx) := t(ddindx).created_from;
915 a12(indx) := t(ddindx).batch_id;
916 a13(indx) := t(ddindx).claim_id;
917 a14(indx) := t(ddindx).claim_number;
918 a15(indx) := t(ddindx).claim_type_id;
919 a16(indx) := t(ddindx).claim_class;
920 a17(indx) := t(ddindx).claim_date;
921 a18(indx) := t(ddindx).due_date;
922 a19(indx) := t(ddindx).owner_id;
923 a20(indx) := t(ddindx).history_event;
924 a21(indx) := t(ddindx).history_event_date;
925 a22(indx) := t(ddindx).history_event_description;
926 a23(indx) := t(ddindx).split_from_claim_id;
927 a24(indx) := t(ddindx).duplicate_claim_id;
928 a25(indx) := t(ddindx).split_date;
929 a26(indx) := t(ddindx).root_claim_id;
930 a27(indx) := t(ddindx).amount;
931 a28(indx) := t(ddindx).amount_adjusted;
932 a29(indx) := t(ddindx).amount_remaining;
933 a30(indx) := t(ddindx).amount_settled;
934 a31(indx) := t(ddindx).acctd_amount;
935 a32(indx) := t(ddindx).acctd_amount_remaining;
936 a33(indx) := t(ddindx).acctd_amount_adjusted;
937 a34(indx) := t(ddindx).acctd_amount_settled;
938 a35(indx) := t(ddindx).tax_amount;
939 a36(indx) := t(ddindx).tax_code;
940 a37(indx) := t(ddindx).tax_calculation_flag;
941 a38(indx) := t(ddindx).currency_code;
942 a39(indx) := t(ddindx).exchange_rate_type;
943 a40(indx) := t(ddindx).exchange_rate_date;
944 a41(indx) := t(ddindx).exchange_rate;
945 a42(indx) := t(ddindx).set_of_books_id;
946 a43(indx) := t(ddindx).original_claim_date;
947 a44(indx) := t(ddindx).source_object_id;
948 a45(indx) := t(ddindx).source_object_class;
949 a46(indx) := t(ddindx).source_object_type_id;
950 a47(indx) := t(ddindx).source_object_number;
951 a48(indx) := t(ddindx).cust_account_id;
952 a49(indx) := t(ddindx).cust_billto_acct_site_id;
953 a50(indx) := t(ddindx).cust_shipto_acct_site_id;
954 a51(indx) := t(ddindx).location_id;
955 a52(indx) := t(ddindx).pay_related_account_flag;
956 a53(indx) := t(ddindx).related_cust_account_id;
957 a54(indx) := t(ddindx).related_site_use_id;
958 a55(indx) := t(ddindx).relationship_type;
959 a56(indx) := t(ddindx).vendor_id;
960 a57(indx) := t(ddindx).vendor_site_id;
961 a58(indx) := t(ddindx).reason_type;
962 a59(indx) := t(ddindx).reason_code_id;
963 a60(indx) := t(ddindx).task_template_group_id;
964 a61(indx) := t(ddindx).status_code;
965 a62(indx) := t(ddindx).user_status_id;
966 a63(indx) := t(ddindx).sales_rep_id;
967 a64(indx) := t(ddindx).collector_id;
968 a65(indx) := t(ddindx).contact_id;
969 a66(indx) := t(ddindx).broker_id;
970 a67(indx) := t(ddindx).territory_id;
971 a68(indx) := t(ddindx).customer_ref_date;
972 a69(indx) := t(ddindx).customer_ref_number;
973 a70(indx) := t(ddindx).assigned_to;
974 a71(indx) := t(ddindx).receipt_id;
975 a72(indx) := t(ddindx).receipt_number;
976 a73(indx) := t(ddindx).doc_sequence_id;
977 a74(indx) := t(ddindx).doc_sequence_value;
978 a75(indx) := t(ddindx).gl_date;
979 a76(indx) := t(ddindx).payment_method;
980 a77(indx) := t(ddindx).voucher_id;
981 a78(indx) := t(ddindx).voucher_number;
982 a79(indx) := t(ddindx).payment_reference_id;
983 a80(indx) := t(ddindx).payment_reference_number;
984 a81(indx) := t(ddindx).payment_reference_date;
985 a82(indx) := t(ddindx).payment_status;
986 a83(indx) := t(ddindx).approved_flag;
987 a84(indx) := t(ddindx).approved_date;
988 a85(indx) := t(ddindx).approved_by;
989 a86(indx) := t(ddindx).settled_date;
990 a87(indx) := t(ddindx).settled_by;
991 a88(indx) := t(ddindx).effective_date;
992 a89(indx) := t(ddindx).custom_setup_id;
993 a90(indx) := t(ddindx).task_id;
994 a91(indx) := t(ddindx).country_id;
995 a92(indx) := t(ddindx).order_type_id;
996 a93(indx) := t(ddindx).comments;
997 a94(indx) := t(ddindx).letter_id;
998 a95(indx) := t(ddindx).letter_date;
999 a96(indx) := t(ddindx).task_source_object_id;
1000 a97(indx) := t(ddindx).task_source_object_type_code;
1001 a98(indx) := t(ddindx).attribute_category;
1002 a99(indx) := t(ddindx).attribute1;
1003 a100(indx) := t(ddindx).attribute2;
1004 a101(indx) := t(ddindx).attribute3;
1005 a102(indx) := t(ddindx).attribute4;
1006 a103(indx) := t(ddindx).attribute5;
1007 a104(indx) := t(ddindx).attribute6;
1008 a105(indx) := t(ddindx).attribute7;
1009 a106(indx) := t(ddindx).attribute8;
1010 a107(indx) := t(ddindx).attribute9;
1011 a108(indx) := t(ddindx).attribute10;
1012 a109(indx) := t(ddindx).attribute11;
1013 a110(indx) := t(ddindx).attribute12;
1014 a111(indx) := t(ddindx).attribute13;
1015 a112(indx) := t(ddindx).attribute14;
1016 a113(indx) := t(ddindx).attribute15;
1017 a114(indx) := t(ddindx).deduction_attribute_category;
1018 a115(indx) := t(ddindx).deduction_attribute1;
1019 a116(indx) := t(ddindx).deduction_attribute2;
1020 a117(indx) := t(ddindx).deduction_attribute3;
1021 a118(indx) := t(ddindx).deduction_attribute4;
1022 a119(indx) := t(ddindx).deduction_attribute5;
1023 a120(indx) := t(ddindx).deduction_attribute6;
1024 a121(indx) := t(ddindx).deduction_attribute7;
1025 a122(indx) := t(ddindx).deduction_attribute8;
1026 a123(indx) := t(ddindx).deduction_attribute9;
1027 a124(indx) := t(ddindx).deduction_attribute10;
1028 a125(indx) := t(ddindx).deduction_attribute11;
1029 a126(indx) := t(ddindx).deduction_attribute12;
1030 a127(indx) := t(ddindx).deduction_attribute13;
1031 a128(indx) := t(ddindx).deduction_attribute14;
1032 a129(indx) := t(ddindx).deduction_attribute15;
1033 a130(indx) := t(ddindx).org_id;
1034 a131(indx) := t(ddindx).write_off_flag;
1035 a132(indx) := t(ddindx).write_off_threshold_amount;
1036 a133(indx) := t(ddindx).under_write_off_threshold;
1037 a134(indx) := t(ddindx).customer_reason;
1038 a135(indx) := t(ddindx).ship_to_cust_account_id;
1039 a136(indx) := t(ddindx).amount_applied;
1040 a137(indx) := t(ddindx).applied_receipt_id;
1041 a138(indx) := t(ddindx).applied_receipt_number;
1042 a139(indx) := t(ddindx).wo_rec_trx_id;
1043 a140(indx) := t(ddindx).group_claim_id;
1044 a141(indx) := t(ddindx).appr_wf_item_key;
1045 a142(indx) := t(ddindx).cstl_wf_item_key;
1046 a143(indx) := t(ddindx).batch_type;
1047 indx := indx+1;
1048 if t.last =ddindx
1049 then exit;
1050 end if;
1051 ddindx := t.next(ddindx);
1052 end loop;
1053 end if;
1054 end if;
1055 end rosetta_table_copy_out_p3;
1056
1057 procedure create_claims_history(p_api_version_number NUMBER
1058 , p_init_msg_list VARCHAR2
1059 , p_commit VARCHAR2
1060 , p_validation_level NUMBER
1061 , x_return_status out nocopy VARCHAR2
1062 , x_msg_count out nocopy NUMBER
1063 , x_msg_data out nocopy VARCHAR2
1064 , p7_a0 NUMBER
1065 , p7_a1 NUMBER
1066 , p7_a2 DATE
1067 , p7_a3 NUMBER
1068 , p7_a4 DATE
1069 , p7_a5 NUMBER
1070 , p7_a6 NUMBER
1071 , p7_a7 NUMBER
1072 , p7_a8 NUMBER
1073 , p7_a9 DATE
1074 , p7_a10 NUMBER
1075 , p7_a11 VARCHAR2
1076 , p7_a12 NUMBER
1077 , p7_a13 NUMBER
1078 , p7_a14 VARCHAR2
1079 , p7_a15 NUMBER
1080 , p7_a16 VARCHAR2
1081 , p7_a17 DATE
1082 , p7_a18 DATE
1083 , p7_a19 NUMBER
1084 , p7_a20 VARCHAR2
1085 , p7_a21 DATE
1086 , p7_a22 VARCHAR2
1087 , p7_a23 NUMBER
1088 , p7_a24 NUMBER
1089 , p7_a25 DATE
1090 , p7_a26 NUMBER
1091 , p7_a27 NUMBER
1092 , p7_a28 NUMBER
1093 , p7_a29 NUMBER
1094 , p7_a30 NUMBER
1095 , p7_a31 NUMBER
1096 , p7_a32 NUMBER
1097 , p7_a33 NUMBER
1098 , p7_a34 NUMBER
1099 , p7_a35 NUMBER
1100 , p7_a36 VARCHAR2
1101 , p7_a37 VARCHAR2
1102 , p7_a38 VARCHAR2
1103 , p7_a39 VARCHAR2
1104 , p7_a40 DATE
1105 , p7_a41 NUMBER
1106 , p7_a42 NUMBER
1107 , p7_a43 DATE
1108 , p7_a44 NUMBER
1109 , p7_a45 VARCHAR2
1110 , p7_a46 NUMBER
1111 , p7_a47 VARCHAR2
1112 , p7_a48 NUMBER
1113 , p7_a49 NUMBER
1114 , p7_a50 NUMBER
1115 , p7_a51 NUMBER
1116 , p7_a52 VARCHAR2
1117 , p7_a53 NUMBER
1118 , p7_a54 NUMBER
1119 , p7_a55 VARCHAR2
1120 , p7_a56 NUMBER
1121 , p7_a57 NUMBER
1122 , p7_a58 VARCHAR2
1123 , p7_a59 NUMBER
1124 , p7_a60 NUMBER
1125 , p7_a61 VARCHAR2
1126 , p7_a62 NUMBER
1127 , p7_a63 NUMBER
1128 , p7_a64 NUMBER
1129 , p7_a65 NUMBER
1130 , p7_a66 NUMBER
1131 , p7_a67 NUMBER
1132 , p7_a68 DATE
1133 , p7_a69 VARCHAR2
1134 , p7_a70 NUMBER
1135 , p7_a71 NUMBER
1136 , p7_a72 VARCHAR2
1137 , p7_a73 NUMBER
1138 , p7_a74 NUMBER
1139 , p7_a75 DATE
1140 , p7_a76 VARCHAR2
1141 , p7_a77 NUMBER
1142 , p7_a78 VARCHAR2
1143 , p7_a79 NUMBER
1144 , p7_a80 VARCHAR2
1145 , p7_a81 DATE
1146 , p7_a82 VARCHAR2
1147 , p7_a83 VARCHAR2
1148 , p7_a84 DATE
1149 , p7_a85 NUMBER
1150 , p7_a86 DATE
1151 , p7_a87 NUMBER
1152 , p7_a88 DATE
1153 , p7_a89 NUMBER
1154 , p7_a90 NUMBER
1155 , p7_a91 NUMBER
1156 , p7_a92 NUMBER
1157 , p7_a93 VARCHAR2
1158 , p7_a94 NUMBER
1159 , p7_a95 DATE
1160 , p7_a96 NUMBER
1161 , p7_a97 VARCHAR2
1162 , p7_a98 VARCHAR2
1163 , p7_a99 VARCHAR2
1164 , p7_a100 VARCHAR2
1165 , p7_a101 VARCHAR2
1166 , p7_a102 VARCHAR2
1167 , p7_a103 VARCHAR2
1168 , p7_a104 VARCHAR2
1169 , p7_a105 VARCHAR2
1170 , p7_a106 VARCHAR2
1171 , p7_a107 VARCHAR2
1172 , p7_a108 VARCHAR2
1173 , p7_a109 VARCHAR2
1174 , p7_a110 VARCHAR2
1175 , p7_a111 VARCHAR2
1176 , p7_a112 VARCHAR2
1177 , p7_a113 VARCHAR2
1178 , p7_a114 VARCHAR2
1179 , p7_a115 VARCHAR2
1180 , p7_a116 VARCHAR2
1181 , p7_a117 VARCHAR2
1182 , p7_a118 VARCHAR2
1183 , p7_a119 VARCHAR2
1184 , p7_a120 VARCHAR2
1185 , p7_a121 VARCHAR2
1186 , p7_a122 VARCHAR2
1187 , p7_a123 VARCHAR2
1188 , p7_a124 VARCHAR2
1189 , p7_a125 VARCHAR2
1190 , p7_a126 VARCHAR2
1191 , p7_a127 VARCHAR2
1192 , p7_a128 VARCHAR2
1193 , p7_a129 VARCHAR2
1194 , p7_a130 NUMBER
1195 , p7_a131 VARCHAR2
1196 , p7_a132 NUMBER
1197 , p7_a133 VARCHAR2
1198 , p7_a134 VARCHAR2
1199 , p7_a135 NUMBER
1200 , p7_a136 NUMBER
1201 , p7_a137 NUMBER
1202 , p7_a138 VARCHAR2
1203 , p7_a139 NUMBER
1204 , p7_a140 NUMBER
1205 , p7_a141 VARCHAR2
1206 , p7_a142 VARCHAR2
1207 , p7_a143 VARCHAR2
1208 , x_claim_history_id out nocopy NUMBER
1209 )
1210
1211 as
1212 ddp_claims_history_rec ozf_claims_history_pvt.claims_history_rec_type;
1213 ddindx binary_integer; indx binary_integer;
1214 begin
1215
1216 -- copy data to the local IN or IN-OUT args, if any
1217
1218
1219
1220
1221
1222
1223
1224 ddp_claims_history_rec.claim_history_id := p7_a0;
1225 ddp_claims_history_rec.object_version_number := p7_a1;
1226 ddp_claims_history_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a2);
1227 ddp_claims_history_rec.last_updated_by := p7_a3;
1228 ddp_claims_history_rec.creation_date := rosetta_g_miss_date_in_map(p7_a4);
1229 ddp_claims_history_rec.created_by := p7_a5;
1230 ddp_claims_history_rec.last_update_login := p7_a6;
1231 ddp_claims_history_rec.request_id := p7_a7;
1232 ddp_claims_history_rec.program_application_id := p7_a8;
1233 ddp_claims_history_rec.program_update_date := rosetta_g_miss_date_in_map(p7_a9);
1234 ddp_claims_history_rec.program_id := p7_a10;
1235 ddp_claims_history_rec.created_from := p7_a11;
1236 ddp_claims_history_rec.batch_id := p7_a12;
1237 ddp_claims_history_rec.claim_id := p7_a13;
1238 ddp_claims_history_rec.claim_number := p7_a14;
1239 ddp_claims_history_rec.claim_type_id := p7_a15;
1240 ddp_claims_history_rec.claim_class := p7_a16;
1241 ddp_claims_history_rec.claim_date := rosetta_g_miss_date_in_map(p7_a17);
1242 ddp_claims_history_rec.due_date := rosetta_g_miss_date_in_map(p7_a18);
1243 ddp_claims_history_rec.owner_id := p7_a19;
1244 ddp_claims_history_rec.history_event := p7_a20;
1245 ddp_claims_history_rec.history_event_date := rosetta_g_miss_date_in_map(p7_a21);
1246 ddp_claims_history_rec.history_event_description := p7_a22;
1247 ddp_claims_history_rec.split_from_claim_id := p7_a23;
1248 ddp_claims_history_rec.duplicate_claim_id := p7_a24;
1249 ddp_claims_history_rec.split_date := rosetta_g_miss_date_in_map(p7_a25);
1250 ddp_claims_history_rec.root_claim_id := p7_a26;
1251 ddp_claims_history_rec.amount := p7_a27;
1252 ddp_claims_history_rec.amount_adjusted := p7_a28;
1253 ddp_claims_history_rec.amount_remaining := p7_a29;
1254 ddp_claims_history_rec.amount_settled := p7_a30;
1255 ddp_claims_history_rec.acctd_amount := p7_a31;
1256 ddp_claims_history_rec.acctd_amount_remaining := p7_a32;
1257 ddp_claims_history_rec.acctd_amount_adjusted := p7_a33;
1258 ddp_claims_history_rec.acctd_amount_settled := p7_a34;
1259 ddp_claims_history_rec.tax_amount := p7_a35;
1260 ddp_claims_history_rec.tax_code := p7_a36;
1261 ddp_claims_history_rec.tax_calculation_flag := p7_a37;
1262 ddp_claims_history_rec.currency_code := p7_a38;
1263 ddp_claims_history_rec.exchange_rate_type := p7_a39;
1264 ddp_claims_history_rec.exchange_rate_date := rosetta_g_miss_date_in_map(p7_a40);
1265 ddp_claims_history_rec.exchange_rate := p7_a41;
1266 ddp_claims_history_rec.set_of_books_id := p7_a42;
1267 ddp_claims_history_rec.original_claim_date := rosetta_g_miss_date_in_map(p7_a43);
1268 ddp_claims_history_rec.source_object_id := p7_a44;
1269 ddp_claims_history_rec.source_object_class := p7_a45;
1270 ddp_claims_history_rec.source_object_type_id := p7_a46;
1271 ddp_claims_history_rec.source_object_number := p7_a47;
1272 ddp_claims_history_rec.cust_account_id := p7_a48;
1273 ddp_claims_history_rec.cust_billto_acct_site_id := p7_a49;
1274 ddp_claims_history_rec.cust_shipto_acct_site_id := p7_a50;
1275 ddp_claims_history_rec.location_id := p7_a51;
1276 ddp_claims_history_rec.pay_related_account_flag := p7_a52;
1277 ddp_claims_history_rec.related_cust_account_id := p7_a53;
1278 ddp_claims_history_rec.related_site_use_id := p7_a54;
1279 ddp_claims_history_rec.relationship_type := p7_a55;
1280 ddp_claims_history_rec.vendor_id := p7_a56;
1281 ddp_claims_history_rec.vendor_site_id := p7_a57;
1282 ddp_claims_history_rec.reason_type := p7_a58;
1283 ddp_claims_history_rec.reason_code_id := p7_a59;
1284 ddp_claims_history_rec.task_template_group_id := p7_a60;
1285 ddp_claims_history_rec.status_code := p7_a61;
1286 ddp_claims_history_rec.user_status_id := p7_a62;
1287 ddp_claims_history_rec.sales_rep_id := p7_a63;
1288 ddp_claims_history_rec.collector_id := p7_a64;
1289 ddp_claims_history_rec.contact_id := p7_a65;
1290 ddp_claims_history_rec.broker_id := p7_a66;
1291 ddp_claims_history_rec.territory_id := p7_a67;
1292 ddp_claims_history_rec.customer_ref_date := rosetta_g_miss_date_in_map(p7_a68);
1293 ddp_claims_history_rec.customer_ref_number := p7_a69;
1294 ddp_claims_history_rec.assigned_to := p7_a70;
1295 ddp_claims_history_rec.receipt_id := p7_a71;
1296 ddp_claims_history_rec.receipt_number := p7_a72;
1297 ddp_claims_history_rec.doc_sequence_id := p7_a73;
1298 ddp_claims_history_rec.doc_sequence_value := p7_a74;
1299 ddp_claims_history_rec.gl_date := rosetta_g_miss_date_in_map(p7_a75);
1300 ddp_claims_history_rec.payment_method := p7_a76;
1301 ddp_claims_history_rec.voucher_id := p7_a77;
1302 ddp_claims_history_rec.voucher_number := p7_a78;
1303 ddp_claims_history_rec.payment_reference_id := p7_a79;
1304 ddp_claims_history_rec.payment_reference_number := p7_a80;
1305 ddp_claims_history_rec.payment_reference_date := rosetta_g_miss_date_in_map(p7_a81);
1306 ddp_claims_history_rec.payment_status := p7_a82;
1307 ddp_claims_history_rec.approved_flag := p7_a83;
1308 ddp_claims_history_rec.approved_date := rosetta_g_miss_date_in_map(p7_a84);
1309 ddp_claims_history_rec.approved_by := p7_a85;
1310 ddp_claims_history_rec.settled_date := rosetta_g_miss_date_in_map(p7_a86);
1311 ddp_claims_history_rec.settled_by := p7_a87;
1312 ddp_claims_history_rec.effective_date := rosetta_g_miss_date_in_map(p7_a88);
1313 ddp_claims_history_rec.custom_setup_id := p7_a89;
1314 ddp_claims_history_rec.task_id := p7_a90;
1315 ddp_claims_history_rec.country_id := p7_a91;
1316 ddp_claims_history_rec.order_type_id := p7_a92;
1317 ddp_claims_history_rec.comments := p7_a93;
1318 ddp_claims_history_rec.letter_id := p7_a94;
1319 ddp_claims_history_rec.letter_date := rosetta_g_miss_date_in_map(p7_a95);
1320 ddp_claims_history_rec.task_source_object_id := p7_a96;
1321 ddp_claims_history_rec.task_source_object_type_code := p7_a97;
1322 ddp_claims_history_rec.attribute_category := p7_a98;
1323 ddp_claims_history_rec.attribute1 := p7_a99;
1324 ddp_claims_history_rec.attribute2 := p7_a100;
1325 ddp_claims_history_rec.attribute3 := p7_a101;
1326 ddp_claims_history_rec.attribute4 := p7_a102;
1327 ddp_claims_history_rec.attribute5 := p7_a103;
1328 ddp_claims_history_rec.attribute6 := p7_a104;
1329 ddp_claims_history_rec.attribute7 := p7_a105;
1330 ddp_claims_history_rec.attribute8 := p7_a106;
1331 ddp_claims_history_rec.attribute9 := p7_a107;
1332 ddp_claims_history_rec.attribute10 := p7_a108;
1333 ddp_claims_history_rec.attribute11 := p7_a109;
1334 ddp_claims_history_rec.attribute12 := p7_a110;
1335 ddp_claims_history_rec.attribute13 := p7_a111;
1336 ddp_claims_history_rec.attribute14 := p7_a112;
1337 ddp_claims_history_rec.attribute15 := p7_a113;
1338 ddp_claims_history_rec.deduction_attribute_category := p7_a114;
1339 ddp_claims_history_rec.deduction_attribute1 := p7_a115;
1340 ddp_claims_history_rec.deduction_attribute2 := p7_a116;
1341 ddp_claims_history_rec.deduction_attribute3 := p7_a117;
1342 ddp_claims_history_rec.deduction_attribute4 := p7_a118;
1343 ddp_claims_history_rec.deduction_attribute5 := p7_a119;
1344 ddp_claims_history_rec.deduction_attribute6 := p7_a120;
1345 ddp_claims_history_rec.deduction_attribute7 := p7_a121;
1346 ddp_claims_history_rec.deduction_attribute8 := p7_a122;
1347 ddp_claims_history_rec.deduction_attribute9 := p7_a123;
1348 ddp_claims_history_rec.deduction_attribute10 := p7_a124;
1349 ddp_claims_history_rec.deduction_attribute11 := p7_a125;
1350 ddp_claims_history_rec.deduction_attribute12 := p7_a126;
1351 ddp_claims_history_rec.deduction_attribute13 := p7_a127;
1352 ddp_claims_history_rec.deduction_attribute14 := p7_a128;
1353 ddp_claims_history_rec.deduction_attribute15 := p7_a129;
1354 ddp_claims_history_rec.org_id := p7_a130;
1355 ddp_claims_history_rec.write_off_flag := p7_a131;
1356 ddp_claims_history_rec.write_off_threshold_amount := p7_a132;
1357 ddp_claims_history_rec.under_write_off_threshold := p7_a133;
1358 ddp_claims_history_rec.customer_reason := p7_a134;
1359 ddp_claims_history_rec.ship_to_cust_account_id := p7_a135;
1360 ddp_claims_history_rec.amount_applied := p7_a136;
1361 ddp_claims_history_rec.applied_receipt_id := p7_a137;
1362 ddp_claims_history_rec.applied_receipt_number := p7_a138;
1363 ddp_claims_history_rec.wo_rec_trx_id := p7_a139;
1364 ddp_claims_history_rec.group_claim_id := p7_a140;
1365 ddp_claims_history_rec.appr_wf_item_key := p7_a141;
1366 ddp_claims_history_rec.cstl_wf_item_key := p7_a142;
1367 ddp_claims_history_rec.batch_type := p7_a143;
1368
1369
1370 -- here's the delegated call to the old PL/SQL routine
1371 ozf_claims_history_pvt.create_claims_history(p_api_version_number,
1372 p_init_msg_list,
1373 p_commit,
1374 p_validation_level,
1375 x_return_status,
1376 x_msg_count,
1377 x_msg_data,
1378 ddp_claims_history_rec,
1379 x_claim_history_id);
1380
1381 -- copy data back from the local variables to OUT or IN-OUT args, if any
1382
1383
1384
1385
1386
1387
1388
1389
1390 end;
1391
1392 procedure update_claims_history(p_api_version_number NUMBER
1393 , p_init_msg_list VARCHAR2
1394 , p_commit VARCHAR2
1395 , p_validation_level NUMBER
1396 , x_return_status out nocopy VARCHAR2
1397 , x_msg_count out nocopy NUMBER
1398 , x_msg_data out nocopy VARCHAR2
1399 , p7_a0 NUMBER
1400 , p7_a1 NUMBER
1401 , p7_a2 DATE
1402 , p7_a3 NUMBER
1403 , p7_a4 DATE
1404 , p7_a5 NUMBER
1405 , p7_a6 NUMBER
1406 , p7_a7 NUMBER
1407 , p7_a8 NUMBER
1408 , p7_a9 DATE
1409 , p7_a10 NUMBER
1410 , p7_a11 VARCHAR2
1411 , p7_a12 NUMBER
1412 , p7_a13 NUMBER
1413 , p7_a14 VARCHAR2
1414 , p7_a15 NUMBER
1415 , p7_a16 VARCHAR2
1416 , p7_a17 DATE
1417 , p7_a18 DATE
1418 , p7_a19 NUMBER
1419 , p7_a20 VARCHAR2
1420 , p7_a21 DATE
1421 , p7_a22 VARCHAR2
1422 , p7_a23 NUMBER
1423 , p7_a24 NUMBER
1424 , p7_a25 DATE
1425 , p7_a26 NUMBER
1426 , p7_a27 NUMBER
1427 , p7_a28 NUMBER
1428 , p7_a29 NUMBER
1429 , p7_a30 NUMBER
1430 , p7_a31 NUMBER
1431 , p7_a32 NUMBER
1432 , p7_a33 NUMBER
1433 , p7_a34 NUMBER
1434 , p7_a35 NUMBER
1435 , p7_a36 VARCHAR2
1436 , p7_a37 VARCHAR2
1437 , p7_a38 VARCHAR2
1438 , p7_a39 VARCHAR2
1439 , p7_a40 DATE
1440 , p7_a41 NUMBER
1441 , p7_a42 NUMBER
1442 , p7_a43 DATE
1443 , p7_a44 NUMBER
1444 , p7_a45 VARCHAR2
1445 , p7_a46 NUMBER
1446 , p7_a47 VARCHAR2
1447 , p7_a48 NUMBER
1448 , p7_a49 NUMBER
1449 , p7_a50 NUMBER
1450 , p7_a51 NUMBER
1451 , p7_a52 VARCHAR2
1452 , p7_a53 NUMBER
1453 , p7_a54 NUMBER
1454 , p7_a55 VARCHAR2
1455 , p7_a56 NUMBER
1456 , p7_a57 NUMBER
1457 , p7_a58 VARCHAR2
1458 , p7_a59 NUMBER
1459 , p7_a60 NUMBER
1460 , p7_a61 VARCHAR2
1461 , p7_a62 NUMBER
1462 , p7_a63 NUMBER
1463 , p7_a64 NUMBER
1464 , p7_a65 NUMBER
1465 , p7_a66 NUMBER
1466 , p7_a67 NUMBER
1467 , p7_a68 DATE
1468 , p7_a69 VARCHAR2
1469 , p7_a70 NUMBER
1470 , p7_a71 NUMBER
1471 , p7_a72 VARCHAR2
1472 , p7_a73 NUMBER
1473 , p7_a74 NUMBER
1474 , p7_a75 DATE
1475 , p7_a76 VARCHAR2
1476 , p7_a77 NUMBER
1477 , p7_a78 VARCHAR2
1478 , p7_a79 NUMBER
1479 , p7_a80 VARCHAR2
1480 , p7_a81 DATE
1481 , p7_a82 VARCHAR2
1482 , p7_a83 VARCHAR2
1483 , p7_a84 DATE
1484 , p7_a85 NUMBER
1485 , p7_a86 DATE
1486 , p7_a87 NUMBER
1487 , p7_a88 DATE
1488 , p7_a89 NUMBER
1489 , p7_a90 NUMBER
1490 , p7_a91 NUMBER
1491 , p7_a92 NUMBER
1492 , p7_a93 VARCHAR2
1493 , p7_a94 NUMBER
1494 , p7_a95 DATE
1495 , p7_a96 NUMBER
1496 , p7_a97 VARCHAR2
1497 , p7_a98 VARCHAR2
1498 , p7_a99 VARCHAR2
1499 , p7_a100 VARCHAR2
1500 , p7_a101 VARCHAR2
1501 , p7_a102 VARCHAR2
1502 , p7_a103 VARCHAR2
1503 , p7_a104 VARCHAR2
1504 , p7_a105 VARCHAR2
1505 , p7_a106 VARCHAR2
1506 , p7_a107 VARCHAR2
1507 , p7_a108 VARCHAR2
1508 , p7_a109 VARCHAR2
1509 , p7_a110 VARCHAR2
1510 , p7_a111 VARCHAR2
1511 , p7_a112 VARCHAR2
1512 , p7_a113 VARCHAR2
1513 , p7_a114 VARCHAR2
1514 , p7_a115 VARCHAR2
1515 , p7_a116 VARCHAR2
1516 , p7_a117 VARCHAR2
1517 , p7_a118 VARCHAR2
1518 , p7_a119 VARCHAR2
1519 , p7_a120 VARCHAR2
1520 , p7_a121 VARCHAR2
1521 , p7_a122 VARCHAR2
1522 , p7_a123 VARCHAR2
1523 , p7_a124 VARCHAR2
1524 , p7_a125 VARCHAR2
1525 , p7_a126 VARCHAR2
1526 , p7_a127 VARCHAR2
1527 , p7_a128 VARCHAR2
1528 , p7_a129 VARCHAR2
1529 , p7_a130 NUMBER
1530 , p7_a131 VARCHAR2
1531 , p7_a132 NUMBER
1532 , p7_a133 VARCHAR2
1533 , p7_a134 VARCHAR2
1534 , p7_a135 NUMBER
1535 , p7_a136 NUMBER
1536 , p7_a137 NUMBER
1537 , p7_a138 VARCHAR2
1538 , p7_a139 NUMBER
1539 , p7_a140 NUMBER
1540 , p7_a141 VARCHAR2
1541 , p7_a142 VARCHAR2
1542 , p7_a143 VARCHAR2
1543 , x_object_version_number out nocopy NUMBER
1544 )
1545
1546 as
1547 ddp_claims_history_rec ozf_claims_history_pvt.claims_history_rec_type;
1548 ddindx binary_integer; indx binary_integer;
1549 begin
1550
1551 -- copy data to the local IN or IN-OUT args, if any
1552
1553
1554
1555
1556
1557
1558
1559 ddp_claims_history_rec.claim_history_id := p7_a0;
1560 ddp_claims_history_rec.object_version_number := p7_a1;
1561 ddp_claims_history_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a2);
1562 ddp_claims_history_rec.last_updated_by := p7_a3;
1563 ddp_claims_history_rec.creation_date := rosetta_g_miss_date_in_map(p7_a4);
1564 ddp_claims_history_rec.created_by := p7_a5;
1565 ddp_claims_history_rec.last_update_login := p7_a6;
1566 ddp_claims_history_rec.request_id := p7_a7;
1567 ddp_claims_history_rec.program_application_id := p7_a8;
1568 ddp_claims_history_rec.program_update_date := rosetta_g_miss_date_in_map(p7_a9);
1569 ddp_claims_history_rec.program_id := p7_a10;
1570 ddp_claims_history_rec.created_from := p7_a11;
1571 ddp_claims_history_rec.batch_id := p7_a12;
1572 ddp_claims_history_rec.claim_id := p7_a13;
1573 ddp_claims_history_rec.claim_number := p7_a14;
1574 ddp_claims_history_rec.claim_type_id := p7_a15;
1575 ddp_claims_history_rec.claim_class := p7_a16;
1576 ddp_claims_history_rec.claim_date := rosetta_g_miss_date_in_map(p7_a17);
1577 ddp_claims_history_rec.due_date := rosetta_g_miss_date_in_map(p7_a18);
1578 ddp_claims_history_rec.owner_id := p7_a19;
1579 ddp_claims_history_rec.history_event := p7_a20;
1580 ddp_claims_history_rec.history_event_date := rosetta_g_miss_date_in_map(p7_a21);
1581 ddp_claims_history_rec.history_event_description := p7_a22;
1582 ddp_claims_history_rec.split_from_claim_id := p7_a23;
1583 ddp_claims_history_rec.duplicate_claim_id := p7_a24;
1584 ddp_claims_history_rec.split_date := rosetta_g_miss_date_in_map(p7_a25);
1585 ddp_claims_history_rec.root_claim_id := p7_a26;
1586 ddp_claims_history_rec.amount := p7_a27;
1587 ddp_claims_history_rec.amount_adjusted := p7_a28;
1588 ddp_claims_history_rec.amount_remaining := p7_a29;
1589 ddp_claims_history_rec.amount_settled := p7_a30;
1590 ddp_claims_history_rec.acctd_amount := p7_a31;
1591 ddp_claims_history_rec.acctd_amount_remaining := p7_a32;
1592 ddp_claims_history_rec.acctd_amount_adjusted := p7_a33;
1593 ddp_claims_history_rec.acctd_amount_settled := p7_a34;
1594 ddp_claims_history_rec.tax_amount := p7_a35;
1595 ddp_claims_history_rec.tax_code := p7_a36;
1596 ddp_claims_history_rec.tax_calculation_flag := p7_a37;
1597 ddp_claims_history_rec.currency_code := p7_a38;
1598 ddp_claims_history_rec.exchange_rate_type := p7_a39;
1599 ddp_claims_history_rec.exchange_rate_date := rosetta_g_miss_date_in_map(p7_a40);
1600 ddp_claims_history_rec.exchange_rate := p7_a41;
1601 ddp_claims_history_rec.set_of_books_id := p7_a42;
1602 ddp_claims_history_rec.original_claim_date := rosetta_g_miss_date_in_map(p7_a43);
1603 ddp_claims_history_rec.source_object_id := p7_a44;
1604 ddp_claims_history_rec.source_object_class := p7_a45;
1605 ddp_claims_history_rec.source_object_type_id := p7_a46;
1606 ddp_claims_history_rec.source_object_number := p7_a47;
1607 ddp_claims_history_rec.cust_account_id := p7_a48;
1608 ddp_claims_history_rec.cust_billto_acct_site_id := p7_a49;
1609 ddp_claims_history_rec.cust_shipto_acct_site_id := p7_a50;
1610 ddp_claims_history_rec.location_id := p7_a51;
1611 ddp_claims_history_rec.pay_related_account_flag := p7_a52;
1612 ddp_claims_history_rec.related_cust_account_id := p7_a53;
1613 ddp_claims_history_rec.related_site_use_id := p7_a54;
1614 ddp_claims_history_rec.relationship_type := p7_a55;
1615 ddp_claims_history_rec.vendor_id := p7_a56;
1616 ddp_claims_history_rec.vendor_site_id := p7_a57;
1617 ddp_claims_history_rec.reason_type := p7_a58;
1618 ddp_claims_history_rec.reason_code_id := p7_a59;
1619 ddp_claims_history_rec.task_template_group_id := p7_a60;
1620 ddp_claims_history_rec.status_code := p7_a61;
1621 ddp_claims_history_rec.user_status_id := p7_a62;
1622 ddp_claims_history_rec.sales_rep_id := p7_a63;
1623 ddp_claims_history_rec.collector_id := p7_a64;
1624 ddp_claims_history_rec.contact_id := p7_a65;
1625 ddp_claims_history_rec.broker_id := p7_a66;
1626 ddp_claims_history_rec.territory_id := p7_a67;
1627 ddp_claims_history_rec.customer_ref_date := rosetta_g_miss_date_in_map(p7_a68);
1628 ddp_claims_history_rec.customer_ref_number := p7_a69;
1629 ddp_claims_history_rec.assigned_to := p7_a70;
1630 ddp_claims_history_rec.receipt_id := p7_a71;
1631 ddp_claims_history_rec.receipt_number := p7_a72;
1632 ddp_claims_history_rec.doc_sequence_id := p7_a73;
1633 ddp_claims_history_rec.doc_sequence_value := p7_a74;
1634 ddp_claims_history_rec.gl_date := rosetta_g_miss_date_in_map(p7_a75);
1635 ddp_claims_history_rec.payment_method := p7_a76;
1636 ddp_claims_history_rec.voucher_id := p7_a77;
1637 ddp_claims_history_rec.voucher_number := p7_a78;
1638 ddp_claims_history_rec.payment_reference_id := p7_a79;
1639 ddp_claims_history_rec.payment_reference_number := p7_a80;
1640 ddp_claims_history_rec.payment_reference_date := rosetta_g_miss_date_in_map(p7_a81);
1641 ddp_claims_history_rec.payment_status := p7_a82;
1642 ddp_claims_history_rec.approved_flag := p7_a83;
1643 ddp_claims_history_rec.approved_date := rosetta_g_miss_date_in_map(p7_a84);
1644 ddp_claims_history_rec.approved_by := p7_a85;
1645 ddp_claims_history_rec.settled_date := rosetta_g_miss_date_in_map(p7_a86);
1646 ddp_claims_history_rec.settled_by := p7_a87;
1647 ddp_claims_history_rec.effective_date := rosetta_g_miss_date_in_map(p7_a88);
1648 ddp_claims_history_rec.custom_setup_id := p7_a89;
1649 ddp_claims_history_rec.task_id := p7_a90;
1650 ddp_claims_history_rec.country_id := p7_a91;
1651 ddp_claims_history_rec.order_type_id := p7_a92;
1652 ddp_claims_history_rec.comments := p7_a93;
1653 ddp_claims_history_rec.letter_id := p7_a94;
1654 ddp_claims_history_rec.letter_date := rosetta_g_miss_date_in_map(p7_a95);
1655 ddp_claims_history_rec.task_source_object_id := p7_a96;
1656 ddp_claims_history_rec.task_source_object_type_code := p7_a97;
1657 ddp_claims_history_rec.attribute_category := p7_a98;
1658 ddp_claims_history_rec.attribute1 := p7_a99;
1659 ddp_claims_history_rec.attribute2 := p7_a100;
1660 ddp_claims_history_rec.attribute3 := p7_a101;
1661 ddp_claims_history_rec.attribute4 := p7_a102;
1662 ddp_claims_history_rec.attribute5 := p7_a103;
1663 ddp_claims_history_rec.attribute6 := p7_a104;
1664 ddp_claims_history_rec.attribute7 := p7_a105;
1665 ddp_claims_history_rec.attribute8 := p7_a106;
1666 ddp_claims_history_rec.attribute9 := p7_a107;
1667 ddp_claims_history_rec.attribute10 := p7_a108;
1668 ddp_claims_history_rec.attribute11 := p7_a109;
1669 ddp_claims_history_rec.attribute12 := p7_a110;
1670 ddp_claims_history_rec.attribute13 := p7_a111;
1671 ddp_claims_history_rec.attribute14 := p7_a112;
1672 ddp_claims_history_rec.attribute15 := p7_a113;
1673 ddp_claims_history_rec.deduction_attribute_category := p7_a114;
1674 ddp_claims_history_rec.deduction_attribute1 := p7_a115;
1675 ddp_claims_history_rec.deduction_attribute2 := p7_a116;
1676 ddp_claims_history_rec.deduction_attribute3 := p7_a117;
1677 ddp_claims_history_rec.deduction_attribute4 := p7_a118;
1678 ddp_claims_history_rec.deduction_attribute5 := p7_a119;
1679 ddp_claims_history_rec.deduction_attribute6 := p7_a120;
1680 ddp_claims_history_rec.deduction_attribute7 := p7_a121;
1681 ddp_claims_history_rec.deduction_attribute8 := p7_a122;
1682 ddp_claims_history_rec.deduction_attribute9 := p7_a123;
1683 ddp_claims_history_rec.deduction_attribute10 := p7_a124;
1684 ddp_claims_history_rec.deduction_attribute11 := p7_a125;
1685 ddp_claims_history_rec.deduction_attribute12 := p7_a126;
1686 ddp_claims_history_rec.deduction_attribute13 := p7_a127;
1687 ddp_claims_history_rec.deduction_attribute14 := p7_a128;
1688 ddp_claims_history_rec.deduction_attribute15 := p7_a129;
1689 ddp_claims_history_rec.org_id := p7_a130;
1690 ddp_claims_history_rec.write_off_flag := p7_a131;
1691 ddp_claims_history_rec.write_off_threshold_amount := p7_a132;
1692 ddp_claims_history_rec.under_write_off_threshold := p7_a133;
1693 ddp_claims_history_rec.customer_reason := p7_a134;
1694 ddp_claims_history_rec.ship_to_cust_account_id := p7_a135;
1695 ddp_claims_history_rec.amount_applied := p7_a136;
1696 ddp_claims_history_rec.applied_receipt_id := p7_a137;
1697 ddp_claims_history_rec.applied_receipt_number := p7_a138;
1698 ddp_claims_history_rec.wo_rec_trx_id := p7_a139;
1699 ddp_claims_history_rec.group_claim_id := p7_a140;
1700 ddp_claims_history_rec.appr_wf_item_key := p7_a141;
1701 ddp_claims_history_rec.cstl_wf_item_key := p7_a142;
1702 ddp_claims_history_rec.batch_type := p7_a143;
1703
1704
1705 -- here's the delegated call to the old PL/SQL routine
1706 ozf_claims_history_pvt.update_claims_history(p_api_version_number,
1707 p_init_msg_list,
1708 p_commit,
1709 p_validation_level,
1710 x_return_status,
1711 x_msg_count,
1712 x_msg_data,
1713 ddp_claims_history_rec,
1714 x_object_version_number);
1715
1716 -- copy data back from the local variables to OUT or IN-OUT args, if any
1717
1718
1719
1720
1721
1722
1723
1724
1725 end;
1726
1727 procedure validate_claims_history(p_api_version_number NUMBER
1728 , p_init_msg_list VARCHAR2
1729 , p_validation_level NUMBER
1730 , p3_a0 NUMBER
1731 , p3_a1 NUMBER
1732 , p3_a2 DATE
1733 , p3_a3 NUMBER
1734 , p3_a4 DATE
1735 , p3_a5 NUMBER
1736 , p3_a6 NUMBER
1737 , p3_a7 NUMBER
1738 , p3_a8 NUMBER
1739 , p3_a9 DATE
1740 , p3_a10 NUMBER
1741 , p3_a11 VARCHAR2
1742 , p3_a12 NUMBER
1743 , p3_a13 NUMBER
1744 , p3_a14 VARCHAR2
1745 , p3_a15 NUMBER
1746 , p3_a16 VARCHAR2
1747 , p3_a17 DATE
1748 , p3_a18 DATE
1749 , p3_a19 NUMBER
1750 , p3_a20 VARCHAR2
1751 , p3_a21 DATE
1752 , p3_a22 VARCHAR2
1753 , p3_a23 NUMBER
1754 , p3_a24 NUMBER
1755 , p3_a25 DATE
1756 , p3_a26 NUMBER
1757 , p3_a27 NUMBER
1758 , p3_a28 NUMBER
1759 , p3_a29 NUMBER
1760 , p3_a30 NUMBER
1761 , p3_a31 NUMBER
1762 , p3_a32 NUMBER
1763 , p3_a33 NUMBER
1764 , p3_a34 NUMBER
1765 , p3_a35 NUMBER
1766 , p3_a36 VARCHAR2
1767 , p3_a37 VARCHAR2
1768 , p3_a38 VARCHAR2
1769 , p3_a39 VARCHAR2
1770 , p3_a40 DATE
1771 , p3_a41 NUMBER
1772 , p3_a42 NUMBER
1773 , p3_a43 DATE
1774 , p3_a44 NUMBER
1775 , p3_a45 VARCHAR2
1776 , p3_a46 NUMBER
1777 , p3_a47 VARCHAR2
1778 , p3_a48 NUMBER
1779 , p3_a49 NUMBER
1780 , p3_a50 NUMBER
1781 , p3_a51 NUMBER
1782 , p3_a52 VARCHAR2
1783 , p3_a53 NUMBER
1784 , p3_a54 NUMBER
1785 , p3_a55 VARCHAR2
1786 , p3_a56 NUMBER
1787 , p3_a57 NUMBER
1788 , p3_a58 VARCHAR2
1789 , p3_a59 NUMBER
1790 , p3_a60 NUMBER
1791 , p3_a61 VARCHAR2
1792 , p3_a62 NUMBER
1793 , p3_a63 NUMBER
1794 , p3_a64 NUMBER
1795 , p3_a65 NUMBER
1796 , p3_a66 NUMBER
1797 , p3_a67 NUMBER
1798 , p3_a68 DATE
1799 , p3_a69 VARCHAR2
1800 , p3_a70 NUMBER
1801 , p3_a71 NUMBER
1802 , p3_a72 VARCHAR2
1803 , p3_a73 NUMBER
1804 , p3_a74 NUMBER
1805 , p3_a75 DATE
1806 , p3_a76 VARCHAR2
1807 , p3_a77 NUMBER
1808 , p3_a78 VARCHAR2
1809 , p3_a79 NUMBER
1810 , p3_a80 VARCHAR2
1811 , p3_a81 DATE
1812 , p3_a82 VARCHAR2
1813 , p3_a83 VARCHAR2
1814 , p3_a84 DATE
1815 , p3_a85 NUMBER
1816 , p3_a86 DATE
1817 , p3_a87 NUMBER
1818 , p3_a88 DATE
1819 , p3_a89 NUMBER
1820 , p3_a90 NUMBER
1821 , p3_a91 NUMBER
1822 , p3_a92 NUMBER
1823 , p3_a93 VARCHAR2
1824 , p3_a94 NUMBER
1825 , p3_a95 DATE
1826 , p3_a96 NUMBER
1827 , p3_a97 VARCHAR2
1828 , p3_a98 VARCHAR2
1829 , p3_a99 VARCHAR2
1830 , p3_a100 VARCHAR2
1831 , p3_a101 VARCHAR2
1832 , p3_a102 VARCHAR2
1833 , p3_a103 VARCHAR2
1834 , p3_a104 VARCHAR2
1835 , p3_a105 VARCHAR2
1836 , p3_a106 VARCHAR2
1837 , p3_a107 VARCHAR2
1838 , p3_a108 VARCHAR2
1839 , p3_a109 VARCHAR2
1840 , p3_a110 VARCHAR2
1841 , p3_a111 VARCHAR2
1842 , p3_a112 VARCHAR2
1843 , p3_a113 VARCHAR2
1844 , p3_a114 VARCHAR2
1845 , p3_a115 VARCHAR2
1846 , p3_a116 VARCHAR2
1847 , p3_a117 VARCHAR2
1848 , p3_a118 VARCHAR2
1849 , p3_a119 VARCHAR2
1850 , p3_a120 VARCHAR2
1851 , p3_a121 VARCHAR2
1852 , p3_a122 VARCHAR2
1853 , p3_a123 VARCHAR2
1854 , p3_a124 VARCHAR2
1855 , p3_a125 VARCHAR2
1856 , p3_a126 VARCHAR2
1857 , p3_a127 VARCHAR2
1858 , p3_a128 VARCHAR2
1859 , p3_a129 VARCHAR2
1860 , p3_a130 NUMBER
1861 , p3_a131 VARCHAR2
1862 , p3_a132 NUMBER
1863 , p3_a133 VARCHAR2
1864 , p3_a134 VARCHAR2
1865 , p3_a135 NUMBER
1866 , p3_a136 NUMBER
1867 , p3_a137 NUMBER
1868 , p3_a138 VARCHAR2
1869 , p3_a139 NUMBER
1870 , p3_a140 NUMBER
1871 , p3_a141 VARCHAR2
1872 , p3_a142 VARCHAR2
1873 , p3_a143 VARCHAR2
1874 , x_return_status out nocopy VARCHAR2
1875 , x_msg_count out nocopy NUMBER
1876 , x_msg_data out nocopy VARCHAR2
1877 )
1878
1879 as
1880 ddp_claims_history_rec ozf_claims_history_pvt.claims_history_rec_type;
1881 ddindx binary_integer; indx binary_integer;
1882 begin
1883
1884 -- copy data to the local IN or IN-OUT args, if any
1885
1886
1887
1888 ddp_claims_history_rec.claim_history_id := p3_a0;
1889 ddp_claims_history_rec.object_version_number := p3_a1;
1890 ddp_claims_history_rec.last_update_date := rosetta_g_miss_date_in_map(p3_a2);
1891 ddp_claims_history_rec.last_updated_by := p3_a3;
1892 ddp_claims_history_rec.creation_date := rosetta_g_miss_date_in_map(p3_a4);
1893 ddp_claims_history_rec.created_by := p3_a5;
1894 ddp_claims_history_rec.last_update_login := p3_a6;
1895 ddp_claims_history_rec.request_id := p3_a7;
1896 ddp_claims_history_rec.program_application_id := p3_a8;
1897 ddp_claims_history_rec.program_update_date := rosetta_g_miss_date_in_map(p3_a9);
1898 ddp_claims_history_rec.program_id := p3_a10;
1899 ddp_claims_history_rec.created_from := p3_a11;
1900 ddp_claims_history_rec.batch_id := p3_a12;
1901 ddp_claims_history_rec.claim_id := p3_a13;
1902 ddp_claims_history_rec.claim_number := p3_a14;
1903 ddp_claims_history_rec.claim_type_id := p3_a15;
1904 ddp_claims_history_rec.claim_class := p3_a16;
1905 ddp_claims_history_rec.claim_date := rosetta_g_miss_date_in_map(p3_a17);
1906 ddp_claims_history_rec.due_date := rosetta_g_miss_date_in_map(p3_a18);
1907 ddp_claims_history_rec.owner_id := p3_a19;
1908 ddp_claims_history_rec.history_event := p3_a20;
1909 ddp_claims_history_rec.history_event_date := rosetta_g_miss_date_in_map(p3_a21);
1910 ddp_claims_history_rec.history_event_description := p3_a22;
1911 ddp_claims_history_rec.split_from_claim_id := p3_a23;
1912 ddp_claims_history_rec.duplicate_claim_id := p3_a24;
1913 ddp_claims_history_rec.split_date := rosetta_g_miss_date_in_map(p3_a25);
1914 ddp_claims_history_rec.root_claim_id := p3_a26;
1915 ddp_claims_history_rec.amount := p3_a27;
1916 ddp_claims_history_rec.amount_adjusted := p3_a28;
1917 ddp_claims_history_rec.amount_remaining := p3_a29;
1918 ddp_claims_history_rec.amount_settled := p3_a30;
1919 ddp_claims_history_rec.acctd_amount := p3_a31;
1920 ddp_claims_history_rec.acctd_amount_remaining := p3_a32;
1921 ddp_claims_history_rec.acctd_amount_adjusted := p3_a33;
1922 ddp_claims_history_rec.acctd_amount_settled := p3_a34;
1923 ddp_claims_history_rec.tax_amount := p3_a35;
1924 ddp_claims_history_rec.tax_code := p3_a36;
1925 ddp_claims_history_rec.tax_calculation_flag := p3_a37;
1926 ddp_claims_history_rec.currency_code := p3_a38;
1927 ddp_claims_history_rec.exchange_rate_type := p3_a39;
1928 ddp_claims_history_rec.exchange_rate_date := rosetta_g_miss_date_in_map(p3_a40);
1929 ddp_claims_history_rec.exchange_rate := p3_a41;
1930 ddp_claims_history_rec.set_of_books_id := p3_a42;
1931 ddp_claims_history_rec.original_claim_date := rosetta_g_miss_date_in_map(p3_a43);
1932 ddp_claims_history_rec.source_object_id := p3_a44;
1933 ddp_claims_history_rec.source_object_class := p3_a45;
1934 ddp_claims_history_rec.source_object_type_id := p3_a46;
1935 ddp_claims_history_rec.source_object_number := p3_a47;
1936 ddp_claims_history_rec.cust_account_id := p3_a48;
1937 ddp_claims_history_rec.cust_billto_acct_site_id := p3_a49;
1938 ddp_claims_history_rec.cust_shipto_acct_site_id := p3_a50;
1939 ddp_claims_history_rec.location_id := p3_a51;
1940 ddp_claims_history_rec.pay_related_account_flag := p3_a52;
1941 ddp_claims_history_rec.related_cust_account_id := p3_a53;
1942 ddp_claims_history_rec.related_site_use_id := p3_a54;
1943 ddp_claims_history_rec.relationship_type := p3_a55;
1944 ddp_claims_history_rec.vendor_id := p3_a56;
1945 ddp_claims_history_rec.vendor_site_id := p3_a57;
1946 ddp_claims_history_rec.reason_type := p3_a58;
1947 ddp_claims_history_rec.reason_code_id := p3_a59;
1948 ddp_claims_history_rec.task_template_group_id := p3_a60;
1949 ddp_claims_history_rec.status_code := p3_a61;
1950 ddp_claims_history_rec.user_status_id := p3_a62;
1951 ddp_claims_history_rec.sales_rep_id := p3_a63;
1952 ddp_claims_history_rec.collector_id := p3_a64;
1953 ddp_claims_history_rec.contact_id := p3_a65;
1954 ddp_claims_history_rec.broker_id := p3_a66;
1955 ddp_claims_history_rec.territory_id := p3_a67;
1956 ddp_claims_history_rec.customer_ref_date := rosetta_g_miss_date_in_map(p3_a68);
1957 ddp_claims_history_rec.customer_ref_number := p3_a69;
1958 ddp_claims_history_rec.assigned_to := p3_a70;
1959 ddp_claims_history_rec.receipt_id := p3_a71;
1960 ddp_claims_history_rec.receipt_number := p3_a72;
1961 ddp_claims_history_rec.doc_sequence_id := p3_a73;
1962 ddp_claims_history_rec.doc_sequence_value := p3_a74;
1963 ddp_claims_history_rec.gl_date := rosetta_g_miss_date_in_map(p3_a75);
1964 ddp_claims_history_rec.payment_method := p3_a76;
1965 ddp_claims_history_rec.voucher_id := p3_a77;
1966 ddp_claims_history_rec.voucher_number := p3_a78;
1967 ddp_claims_history_rec.payment_reference_id := p3_a79;
1968 ddp_claims_history_rec.payment_reference_number := p3_a80;
1969 ddp_claims_history_rec.payment_reference_date := rosetta_g_miss_date_in_map(p3_a81);
1970 ddp_claims_history_rec.payment_status := p3_a82;
1971 ddp_claims_history_rec.approved_flag := p3_a83;
1972 ddp_claims_history_rec.approved_date := rosetta_g_miss_date_in_map(p3_a84);
1973 ddp_claims_history_rec.approved_by := p3_a85;
1974 ddp_claims_history_rec.settled_date := rosetta_g_miss_date_in_map(p3_a86);
1975 ddp_claims_history_rec.settled_by := p3_a87;
1976 ddp_claims_history_rec.effective_date := rosetta_g_miss_date_in_map(p3_a88);
1977 ddp_claims_history_rec.custom_setup_id := p3_a89;
1978 ddp_claims_history_rec.task_id := p3_a90;
1979 ddp_claims_history_rec.country_id := p3_a91;
1980 ddp_claims_history_rec.order_type_id := p3_a92;
1981 ddp_claims_history_rec.comments := p3_a93;
1982 ddp_claims_history_rec.letter_id := p3_a94;
1983 ddp_claims_history_rec.letter_date := rosetta_g_miss_date_in_map(p3_a95);
1984 ddp_claims_history_rec.task_source_object_id := p3_a96;
1985 ddp_claims_history_rec.task_source_object_type_code := p3_a97;
1986 ddp_claims_history_rec.attribute_category := p3_a98;
1987 ddp_claims_history_rec.attribute1 := p3_a99;
1988 ddp_claims_history_rec.attribute2 := p3_a100;
1989 ddp_claims_history_rec.attribute3 := p3_a101;
1990 ddp_claims_history_rec.attribute4 := p3_a102;
1991 ddp_claims_history_rec.attribute5 := p3_a103;
1992 ddp_claims_history_rec.attribute6 := p3_a104;
1993 ddp_claims_history_rec.attribute7 := p3_a105;
1994 ddp_claims_history_rec.attribute8 := p3_a106;
1995 ddp_claims_history_rec.attribute9 := p3_a107;
1996 ddp_claims_history_rec.attribute10 := p3_a108;
1997 ddp_claims_history_rec.attribute11 := p3_a109;
1998 ddp_claims_history_rec.attribute12 := p3_a110;
1999 ddp_claims_history_rec.attribute13 := p3_a111;
2000 ddp_claims_history_rec.attribute14 := p3_a112;
2001 ddp_claims_history_rec.attribute15 := p3_a113;
2002 ddp_claims_history_rec.deduction_attribute_category := p3_a114;
2003 ddp_claims_history_rec.deduction_attribute1 := p3_a115;
2004 ddp_claims_history_rec.deduction_attribute2 := p3_a116;
2005 ddp_claims_history_rec.deduction_attribute3 := p3_a117;
2006 ddp_claims_history_rec.deduction_attribute4 := p3_a118;
2007 ddp_claims_history_rec.deduction_attribute5 := p3_a119;
2008 ddp_claims_history_rec.deduction_attribute6 := p3_a120;
2009 ddp_claims_history_rec.deduction_attribute7 := p3_a121;
2010 ddp_claims_history_rec.deduction_attribute8 := p3_a122;
2011 ddp_claims_history_rec.deduction_attribute9 := p3_a123;
2012 ddp_claims_history_rec.deduction_attribute10 := p3_a124;
2013 ddp_claims_history_rec.deduction_attribute11 := p3_a125;
2014 ddp_claims_history_rec.deduction_attribute12 := p3_a126;
2015 ddp_claims_history_rec.deduction_attribute13 := p3_a127;
2016 ddp_claims_history_rec.deduction_attribute14 := p3_a128;
2017 ddp_claims_history_rec.deduction_attribute15 := p3_a129;
2018 ddp_claims_history_rec.org_id := p3_a130;
2019 ddp_claims_history_rec.write_off_flag := p3_a131;
2020 ddp_claims_history_rec.write_off_threshold_amount := p3_a132;
2021 ddp_claims_history_rec.under_write_off_threshold := p3_a133;
2022 ddp_claims_history_rec.customer_reason := p3_a134;
2023 ddp_claims_history_rec.ship_to_cust_account_id := p3_a135;
2024 ddp_claims_history_rec.amount_applied := p3_a136;
2025 ddp_claims_history_rec.applied_receipt_id := p3_a137;
2026 ddp_claims_history_rec.applied_receipt_number := p3_a138;
2027 ddp_claims_history_rec.wo_rec_trx_id := p3_a139;
2028 ddp_claims_history_rec.group_claim_id := p3_a140;
2029 ddp_claims_history_rec.appr_wf_item_key := p3_a141;
2030 ddp_claims_history_rec.cstl_wf_item_key := p3_a142;
2031 ddp_claims_history_rec.batch_type := p3_a143;
2032
2033
2034
2035
2036 -- here's the delegated call to the old PL/SQL routine
2037 ozf_claims_history_pvt.validate_claims_history(p_api_version_number,
2038 p_init_msg_list,
2039 p_validation_level,
2040 ddp_claims_history_rec,
2041 x_return_status,
2042 x_msg_count,
2043 x_msg_data);
2044
2045 -- copy data back from the local variables to OUT or IN-OUT args, if any
2046
2047
2048
2049
2050
2051
2052 end;
2053
2054 end ozf_claims_history_pvt_w;