[Home] [Help]
PACKAGE BODY: APPS.OZF_CLAIM_PVT_W
Source
1 package body ozf_claim_pvt_w as
2 /* $Header: ozfwclab.pls 120.4.12010000.3 2009/07/27 06:38:08 kpatro ship $ */
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 rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');
6 rosetta_g_mistake_date_low date := to_date('01/01/-4710', 'MM/DD/SYYYY');
7
8 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
9 function rosetta_g_miss_date_in_map(d date) return date as
10 begin
11 if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
12 if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13 return d;
14 end;
15
16 procedure rosetta_table_copy_in_p3(t out nocopy ozf_claim_pvt.claim_tbl_type, a0 JTF_NUMBER_TABLE
17 , a1 JTF_NUMBER_TABLE
18 , a2 JTF_DATE_TABLE
19 , a3 JTF_NUMBER_TABLE
20 , a4 JTF_DATE_TABLE
21 , a5 JTF_NUMBER_TABLE
22 , a6 JTF_NUMBER_TABLE
23 , a7 JTF_NUMBER_TABLE
24 , a8 JTF_NUMBER_TABLE
25 , a9 JTF_DATE_TABLE
26 , a10 JTF_NUMBER_TABLE
27 , a11 JTF_VARCHAR2_TABLE_100
28 , a12 JTF_NUMBER_TABLE
29 , a13 JTF_VARCHAR2_TABLE_100
30 , a14 JTF_NUMBER_TABLE
31 , a15 JTF_VARCHAR2_TABLE_100
32 , a16 JTF_DATE_TABLE
33 , a17 JTF_DATE_TABLE
34 , a18 JTF_NUMBER_TABLE
35 , a19 JTF_VARCHAR2_TABLE_100
36 , a20 JTF_DATE_TABLE
37 , a21 JTF_VARCHAR2_TABLE_2000
38 , a22 JTF_NUMBER_TABLE
39 , a23 JTF_NUMBER_TABLE
40 , a24 JTF_DATE_TABLE
41 , a25 JTF_NUMBER_TABLE
42 , a26 JTF_NUMBER_TABLE
43 , a27 JTF_NUMBER_TABLE
44 , a28 JTF_NUMBER_TABLE
45 , a29 JTF_NUMBER_TABLE
46 , a30 JTF_NUMBER_TABLE
47 , a31 JTF_NUMBER_TABLE
48 , a32 JTF_NUMBER_TABLE
49 , a33 JTF_NUMBER_TABLE
50 , a34 JTF_NUMBER_TABLE
51 , a35 JTF_VARCHAR2_TABLE_100
52 , a36 JTF_VARCHAR2_TABLE_100
53 , a37 JTF_VARCHAR2_TABLE_100
54 , a38 JTF_VARCHAR2_TABLE_100
55 , a39 JTF_DATE_TABLE
56 , a40 JTF_NUMBER_TABLE
57 , a41 JTF_NUMBER_TABLE
58 , a42 JTF_DATE_TABLE
59 , a43 JTF_NUMBER_TABLE
60 , a44 JTF_VARCHAR2_TABLE_100
61 , a45 JTF_NUMBER_TABLE
62 , a46 JTF_VARCHAR2_TABLE_100
63 , a47 JTF_NUMBER_TABLE
64 , a48 JTF_NUMBER_TABLE
65 , a49 JTF_NUMBER_TABLE
66 , a50 JTF_NUMBER_TABLE
67 , a51 JTF_VARCHAR2_TABLE_100
68 , a52 JTF_NUMBER_TABLE
69 , a53 JTF_NUMBER_TABLE
70 , a54 JTF_VARCHAR2_TABLE_100
71 , a55 JTF_NUMBER_TABLE
72 , a56 JTF_NUMBER_TABLE
73 , a57 JTF_VARCHAR2_TABLE_100
74 , a58 JTF_NUMBER_TABLE
75 , a59 JTF_NUMBER_TABLE
76 , a60 JTF_VARCHAR2_TABLE_100
77 , a61 JTF_NUMBER_TABLE
78 , a62 JTF_NUMBER_TABLE
79 , a63 JTF_NUMBER_TABLE
80 , a64 JTF_NUMBER_TABLE
81 , a65 JTF_NUMBER_TABLE
82 , a66 JTF_NUMBER_TABLE
83 , a67 JTF_DATE_TABLE
84 , a68 JTF_VARCHAR2_TABLE_100
85 , a69 JTF_NUMBER_TABLE
86 , a70 JTF_NUMBER_TABLE
87 , a71 JTF_VARCHAR2_TABLE_100
88 , a72 JTF_NUMBER_TABLE
89 , a73 JTF_NUMBER_TABLE
90 , a74 JTF_DATE_TABLE
91 , a75 JTF_VARCHAR2_TABLE_100
92 , a76 JTF_NUMBER_TABLE
93 , a77 JTF_VARCHAR2_TABLE_100
94 , a78 JTF_NUMBER_TABLE
95 , a79 JTF_VARCHAR2_TABLE_100
96 , a80 JTF_DATE_TABLE
97 , a81 JTF_VARCHAR2_TABLE_100
98 , a82 JTF_VARCHAR2_TABLE_100
99 , a83 JTF_DATE_TABLE
100 , a84 JTF_NUMBER_TABLE
101 , a85 JTF_DATE_TABLE
102 , a86 JTF_NUMBER_TABLE
103 , a87 JTF_DATE_TABLE
104 , a88 JTF_NUMBER_TABLE
105 , a89 JTF_NUMBER_TABLE
106 , a90 JTF_NUMBER_TABLE
107 , a91 JTF_NUMBER_TABLE
108 , a92 JTF_VARCHAR2_TABLE_2000
109 , a93 JTF_VARCHAR2_TABLE_100
110 , a94 JTF_VARCHAR2_TABLE_200
111 , a95 JTF_VARCHAR2_TABLE_200
112 , a96 JTF_VARCHAR2_TABLE_200
113 , a97 JTF_VARCHAR2_TABLE_200
114 , a98 JTF_VARCHAR2_TABLE_200
115 , a99 JTF_VARCHAR2_TABLE_200
116 , a100 JTF_VARCHAR2_TABLE_200
117 , a101 JTF_VARCHAR2_TABLE_200
118 , a102 JTF_VARCHAR2_TABLE_200
119 , a103 JTF_VARCHAR2_TABLE_200
120 , a104 JTF_VARCHAR2_TABLE_200
121 , a105 JTF_VARCHAR2_TABLE_200
122 , a106 JTF_VARCHAR2_TABLE_200
123 , a107 JTF_VARCHAR2_TABLE_200
124 , a108 JTF_VARCHAR2_TABLE_200
125 , a109 JTF_VARCHAR2_TABLE_100
126 , a110 JTF_VARCHAR2_TABLE_200
127 , a111 JTF_VARCHAR2_TABLE_200
128 , a112 JTF_VARCHAR2_TABLE_200
129 , a113 JTF_VARCHAR2_TABLE_200
130 , a114 JTF_VARCHAR2_TABLE_200
131 , a115 JTF_VARCHAR2_TABLE_200
132 , a116 JTF_VARCHAR2_TABLE_200
133 , a117 JTF_VARCHAR2_TABLE_200
134 , a118 JTF_VARCHAR2_TABLE_200
135 , a119 JTF_VARCHAR2_TABLE_200
136 , a120 JTF_VARCHAR2_TABLE_200
137 , a121 JTF_VARCHAR2_TABLE_200
138 , a122 JTF_VARCHAR2_TABLE_200
139 , a123 JTF_VARCHAR2_TABLE_200
140 , a124 JTF_VARCHAR2_TABLE_200
141 , a125 JTF_NUMBER_TABLE
142 , a126 JTF_NUMBER_TABLE
143 , a127 JTF_VARCHAR2_TABLE_100
144 , a128 JTF_NUMBER_TABLE
145 , a129 JTF_VARCHAR2_TABLE_100
146 , a130 JTF_VARCHAR2_TABLE_100
147 , a131 JTF_NUMBER_TABLE
148 , a132 JTF_NUMBER_TABLE
149 , a133 JTF_NUMBER_TABLE
150 , a134 JTF_VARCHAR2_TABLE_100
151 , a135 JTF_NUMBER_TABLE
152 , a136 JTF_NUMBER_TABLE
153 , a137 JTF_VARCHAR2_TABLE_300
154 , a138 JTF_VARCHAR2_TABLE_300
155 , a139 JTF_VARCHAR2_TABLE_100
156 , a140 JTF_VARCHAR2_TABLE_100
157 , a141 JTF_NUMBER_TABLE
158 , a142 JTF_NUMBER_TABLE
159 , a143 JTF_VARCHAR2_TABLE_100
160 , a144 JTF_VARCHAR2_TABLE_100
161 , a145 JTF_NUMBER_TABLE
162 , a146 JTF_VARCHAR2_TABLE_100
163 , a147 JTF_VARCHAR2_TABLE_100
164 ) as
165 ddindx binary_integer; indx binary_integer;
166 begin
167 if a0 is not null and a0.count > 0 then
168 if a0.count > 0 then
169 indx := a0.first;
170 ddindx := 1;
171 while true loop
172 t(ddindx).claim_id := a0(indx);
173 t(ddindx).object_version_number := a1(indx);
174 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a2(indx));
175 t(ddindx).last_updated_by := a3(indx);
176 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a4(indx));
177 t(ddindx).created_by := a5(indx);
178 t(ddindx).last_update_login := a6(indx);
179 t(ddindx).request_id := a7(indx);
180 t(ddindx).program_application_id := a8(indx);
181 t(ddindx).program_update_date := rosetta_g_miss_date_in_map(a9(indx));
182 t(ddindx).program_id := a10(indx);
183 t(ddindx).created_from := a11(indx);
184 t(ddindx).batch_id := a12(indx);
185 t(ddindx).claim_number := a13(indx);
186 t(ddindx).claim_type_id := a14(indx);
187 t(ddindx).claim_class := a15(indx);
188 t(ddindx).claim_date := rosetta_g_miss_date_in_map(a16(indx));
189 t(ddindx).due_date := rosetta_g_miss_date_in_map(a17(indx));
190 t(ddindx).owner_id := a18(indx);
191 t(ddindx).history_event := a19(indx);
192 t(ddindx).history_event_date := rosetta_g_miss_date_in_map(a20(indx));
193 t(ddindx).history_event_description := a21(indx);
194 t(ddindx).split_from_claim_id := a22(indx);
195 t(ddindx).duplicate_claim_id := a23(indx);
196 t(ddindx).split_date := rosetta_g_miss_date_in_map(a24(indx));
197 t(ddindx).root_claim_id := a25(indx);
198 t(ddindx).amount := a26(indx);
199 t(ddindx).amount_adjusted := a27(indx);
200 t(ddindx).amount_remaining := a28(indx);
201 t(ddindx).amount_settled := a29(indx);
202 t(ddindx).acctd_amount := a30(indx);
203 t(ddindx).acctd_amount_remaining := a31(indx);
204 t(ddindx).acctd_amount_adjusted := a32(indx);
205 t(ddindx).acctd_amount_settled := a33(indx);
206 t(ddindx).tax_amount := a34(indx);
207 t(ddindx).tax_code := a35(indx);
208 t(ddindx).tax_calculation_flag := a36(indx);
209 t(ddindx).currency_code := a37(indx);
210 t(ddindx).exchange_rate_type := a38(indx);
211 t(ddindx).exchange_rate_date := rosetta_g_miss_date_in_map(a39(indx));
212 t(ddindx).exchange_rate := a40(indx);
213 t(ddindx).set_of_books_id := a41(indx);
214 t(ddindx).original_claim_date := rosetta_g_miss_date_in_map(a42(indx));
215 t(ddindx).source_object_id := a43(indx);
216 t(ddindx).source_object_class := a44(indx);
217 t(ddindx).source_object_type_id := a45(indx);
218 t(ddindx).source_object_number := a46(indx);
219 t(ddindx).cust_account_id := a47(indx);
220 t(ddindx).cust_billto_acct_site_id := a48(indx);
221 t(ddindx).cust_shipto_acct_site_id := a49(indx);
222 t(ddindx).location_id := a50(indx);
223 t(ddindx).pay_related_account_flag := a51(indx);
224 t(ddindx).related_cust_account_id := a52(indx);
225 t(ddindx).related_site_use_id := a53(indx);
226 t(ddindx).relationship_type := a54(indx);
227 t(ddindx).vendor_id := a55(indx);
228 t(ddindx).vendor_site_id := a56(indx);
229 t(ddindx).reason_type := a57(indx);
230 t(ddindx).reason_code_id := a58(indx);
231 t(ddindx).task_template_group_id := a59(indx);
232 t(ddindx).status_code := a60(indx);
233 t(ddindx).user_status_id := a61(indx);
234 t(ddindx).sales_rep_id := a62(indx);
235 t(ddindx).collector_id := a63(indx);
236 t(ddindx).contact_id := a64(indx);
237 t(ddindx).broker_id := a65(indx);
238 t(ddindx).territory_id := a66(indx);
239 t(ddindx).customer_ref_date := rosetta_g_miss_date_in_map(a67(indx));
240 t(ddindx).customer_ref_number := a68(indx);
241 t(ddindx).assigned_to := a69(indx);
242 t(ddindx).receipt_id := a70(indx);
243 t(ddindx).receipt_number := a71(indx);
244 t(ddindx).doc_sequence_id := a72(indx);
245 t(ddindx).doc_sequence_value := a73(indx);
246 t(ddindx).gl_date := rosetta_g_miss_date_in_map(a74(indx));
247 t(ddindx).payment_method := a75(indx);
248 t(ddindx).voucher_id := a76(indx);
249 t(ddindx).voucher_number := a77(indx);
250 t(ddindx).payment_reference_id := a78(indx);
251 t(ddindx).payment_reference_number := a79(indx);
252 t(ddindx).payment_reference_date := rosetta_g_miss_date_in_map(a80(indx));
253 t(ddindx).payment_status := a81(indx);
254 t(ddindx).approved_flag := a82(indx);
255 t(ddindx).approved_date := rosetta_g_miss_date_in_map(a83(indx));
256 t(ddindx).approved_by := a84(indx);
257 t(ddindx).settled_date := rosetta_g_miss_date_in_map(a85(indx));
258 t(ddindx).settled_by := a86(indx);
259 t(ddindx).effective_date := rosetta_g_miss_date_in_map(a87(indx));
260 t(ddindx).custom_setup_id := a88(indx);
261 t(ddindx).task_id := a89(indx);
262 t(ddindx).country_id := a90(indx);
263 t(ddindx).order_type_id := a91(indx);
264 t(ddindx).comments := a92(indx);
265 t(ddindx).attribute_category := a93(indx);
266 t(ddindx).attribute1 := a94(indx);
267 t(ddindx).attribute2 := a95(indx);
268 t(ddindx).attribute3 := a96(indx);
269 t(ddindx).attribute4 := a97(indx);
270 t(ddindx).attribute5 := a98(indx);
271 t(ddindx).attribute6 := a99(indx);
272 t(ddindx).attribute7 := a100(indx);
273 t(ddindx).attribute8 := a101(indx);
274 t(ddindx).attribute9 := a102(indx);
275 t(ddindx).attribute10 := a103(indx);
276 t(ddindx).attribute11 := a104(indx);
277 t(ddindx).attribute12 := a105(indx);
278 t(ddindx).attribute13 := a106(indx);
279 t(ddindx).attribute14 := a107(indx);
280 t(ddindx).attribute15 := a108(indx);
281 t(ddindx).deduction_attribute_category := a109(indx);
282 t(ddindx).deduction_attribute1 := a110(indx);
283 t(ddindx).deduction_attribute2 := a111(indx);
284 t(ddindx).deduction_attribute3 := a112(indx);
285 t(ddindx).deduction_attribute4 := a113(indx);
286 t(ddindx).deduction_attribute5 := a114(indx);
287 t(ddindx).deduction_attribute6 := a115(indx);
288 t(ddindx).deduction_attribute7 := a116(indx);
289 t(ddindx).deduction_attribute8 := a117(indx);
290 t(ddindx).deduction_attribute9 := a118(indx);
291 t(ddindx).deduction_attribute10 := a119(indx);
292 t(ddindx).deduction_attribute11 := a120(indx);
293 t(ddindx).deduction_attribute12 := a121(indx);
294 t(ddindx).deduction_attribute13 := a122(indx);
295 t(ddindx).deduction_attribute14 := a123(indx);
296 t(ddindx).deduction_attribute15 := a124(indx);
297 t(ddindx).org_id := a125(indx);
298 t(ddindx).legal_entity_id := a126(indx);
299 t(ddindx).write_off_flag := a127(indx);
300 t(ddindx).write_off_threshold_amount := a128(indx);
301 t(ddindx).under_write_off_threshold := a129(indx);
302 t(ddindx).customer_reason := a130(indx);
303 t(ddindx).ship_to_cust_account_id := a131(indx);
304 t(ddindx).amount_applied := a132(indx);
305 t(ddindx).applied_receipt_id := a133(indx);
306 t(ddindx).applied_receipt_number := a134(indx);
307 t(ddindx).wo_rec_trx_id := a135(indx);
308 t(ddindx).group_claim_id := a136(indx);
309 t(ddindx).appr_wf_item_key := a137(indx);
310 t(ddindx).cstl_wf_item_key := a138(indx);
311 t(ddindx).batch_type := a139(indx);
312 t(ddindx).tax_action := a140(indx);
313 t(ddindx).close_status_id := a141(indx);
314 t(ddindx).open_status_id := a142(indx);
315 t(ddindx).pre_auth_deduction_number := a143(indx);
316 t(ddindx).pre_auth_deduction_normalized := a144(indx);
317 t(ddindx).offer_id := a145(indx);
318 t(ddindx).settled_from := a146(indx);
319 t(ddindx).approval_in_prog := a147(indx);
320 ddindx := ddindx+1;
321 if a0.last =indx
322 then exit;
323 end if;
324 indx := a0.next(indx);
325 end loop;
326 end if;
327 end if;
328 end rosetta_table_copy_in_p3;
329 procedure rosetta_table_copy_out_p3(t ozf_claim_pvt.claim_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
330 , a1 out nocopy JTF_NUMBER_TABLE
331 , a2 out nocopy JTF_DATE_TABLE
332 , a3 out nocopy JTF_NUMBER_TABLE
333 , a4 out nocopy JTF_DATE_TABLE
334 , a5 out nocopy JTF_NUMBER_TABLE
335 , a6 out nocopy JTF_NUMBER_TABLE
336 , a7 out nocopy JTF_NUMBER_TABLE
337 , a8 out nocopy JTF_NUMBER_TABLE
338 , a9 out nocopy JTF_DATE_TABLE
339 , a10 out nocopy JTF_NUMBER_TABLE
340 , a11 out nocopy JTF_VARCHAR2_TABLE_100
341 , a12 out nocopy JTF_NUMBER_TABLE
342 , a13 out nocopy JTF_VARCHAR2_TABLE_100
343 , a14 out nocopy JTF_NUMBER_TABLE
344 , a15 out nocopy JTF_VARCHAR2_TABLE_100
345 , a16 out nocopy JTF_DATE_TABLE
346 , a17 out nocopy JTF_DATE_TABLE
347 , a18 out nocopy JTF_NUMBER_TABLE
348 , a19 out nocopy JTF_VARCHAR2_TABLE_100
349 , a20 out nocopy JTF_DATE_TABLE
350 , a21 out nocopy JTF_VARCHAR2_TABLE_2000
351 , a22 out nocopy JTF_NUMBER_TABLE
352 , a23 out nocopy JTF_NUMBER_TABLE
353 , a24 out nocopy JTF_DATE_TABLE
354 , a25 out nocopy JTF_NUMBER_TABLE
355 , a26 out nocopy JTF_NUMBER_TABLE
356 , a27 out nocopy JTF_NUMBER_TABLE
357 , a28 out nocopy JTF_NUMBER_TABLE
358 , a29 out nocopy JTF_NUMBER_TABLE
359 , a30 out nocopy JTF_NUMBER_TABLE
360 , a31 out nocopy JTF_NUMBER_TABLE
361 , a32 out nocopy JTF_NUMBER_TABLE
362 , a33 out nocopy JTF_NUMBER_TABLE
363 , a34 out nocopy JTF_NUMBER_TABLE
364 , a35 out nocopy JTF_VARCHAR2_TABLE_100
365 , a36 out nocopy JTF_VARCHAR2_TABLE_100
366 , a37 out nocopy JTF_VARCHAR2_TABLE_100
367 , a38 out nocopy JTF_VARCHAR2_TABLE_100
368 , a39 out nocopy JTF_DATE_TABLE
369 , a40 out nocopy JTF_NUMBER_TABLE
370 , a41 out nocopy JTF_NUMBER_TABLE
371 , a42 out nocopy JTF_DATE_TABLE
372 , a43 out nocopy JTF_NUMBER_TABLE
373 , a44 out nocopy JTF_VARCHAR2_TABLE_100
374 , a45 out nocopy JTF_NUMBER_TABLE
375 , a46 out nocopy JTF_VARCHAR2_TABLE_100
376 , a47 out nocopy JTF_NUMBER_TABLE
377 , a48 out nocopy JTF_NUMBER_TABLE
378 , a49 out nocopy JTF_NUMBER_TABLE
379 , a50 out nocopy JTF_NUMBER_TABLE
380 , a51 out nocopy JTF_VARCHAR2_TABLE_100
381 , a52 out nocopy JTF_NUMBER_TABLE
382 , a53 out nocopy JTF_NUMBER_TABLE
383 , a54 out nocopy JTF_VARCHAR2_TABLE_100
384 , a55 out nocopy JTF_NUMBER_TABLE
385 , a56 out nocopy JTF_NUMBER_TABLE
386 , a57 out nocopy JTF_VARCHAR2_TABLE_100
387 , a58 out nocopy JTF_NUMBER_TABLE
388 , a59 out nocopy JTF_NUMBER_TABLE
389 , a60 out nocopy JTF_VARCHAR2_TABLE_100
390 , a61 out nocopy JTF_NUMBER_TABLE
391 , a62 out nocopy JTF_NUMBER_TABLE
392 , a63 out nocopy JTF_NUMBER_TABLE
393 , a64 out nocopy JTF_NUMBER_TABLE
394 , a65 out nocopy JTF_NUMBER_TABLE
395 , a66 out nocopy JTF_NUMBER_TABLE
396 , a67 out nocopy JTF_DATE_TABLE
397 , a68 out nocopy JTF_VARCHAR2_TABLE_100
398 , a69 out nocopy JTF_NUMBER_TABLE
399 , a70 out nocopy JTF_NUMBER_TABLE
400 , a71 out nocopy JTF_VARCHAR2_TABLE_100
401 , a72 out nocopy JTF_NUMBER_TABLE
402 , a73 out nocopy JTF_NUMBER_TABLE
403 , a74 out nocopy JTF_DATE_TABLE
404 , a75 out nocopy JTF_VARCHAR2_TABLE_100
405 , a76 out nocopy JTF_NUMBER_TABLE
406 , a77 out nocopy JTF_VARCHAR2_TABLE_100
407 , a78 out nocopy JTF_NUMBER_TABLE
408 , a79 out nocopy JTF_VARCHAR2_TABLE_100
409 , a80 out nocopy JTF_DATE_TABLE
410 , a81 out nocopy JTF_VARCHAR2_TABLE_100
411 , a82 out nocopy JTF_VARCHAR2_TABLE_100
412 , a83 out nocopy JTF_DATE_TABLE
413 , a84 out nocopy JTF_NUMBER_TABLE
414 , a85 out nocopy JTF_DATE_TABLE
415 , a86 out nocopy JTF_NUMBER_TABLE
416 , a87 out nocopy JTF_DATE_TABLE
417 , a88 out nocopy JTF_NUMBER_TABLE
418 , a89 out nocopy JTF_NUMBER_TABLE
419 , a90 out nocopy JTF_NUMBER_TABLE
420 , a91 out nocopy JTF_NUMBER_TABLE
421 , a92 out nocopy JTF_VARCHAR2_TABLE_2000
422 , a93 out nocopy JTF_VARCHAR2_TABLE_100
423 , a94 out nocopy JTF_VARCHAR2_TABLE_200
424 , a95 out nocopy JTF_VARCHAR2_TABLE_200
425 , a96 out nocopy JTF_VARCHAR2_TABLE_200
426 , a97 out nocopy JTF_VARCHAR2_TABLE_200
427 , a98 out nocopy JTF_VARCHAR2_TABLE_200
428 , a99 out nocopy JTF_VARCHAR2_TABLE_200
429 , a100 out nocopy JTF_VARCHAR2_TABLE_200
430 , a101 out nocopy JTF_VARCHAR2_TABLE_200
431 , a102 out nocopy JTF_VARCHAR2_TABLE_200
432 , a103 out nocopy JTF_VARCHAR2_TABLE_200
433 , a104 out nocopy JTF_VARCHAR2_TABLE_200
434 , a105 out nocopy JTF_VARCHAR2_TABLE_200
435 , a106 out nocopy JTF_VARCHAR2_TABLE_200
436 , a107 out nocopy JTF_VARCHAR2_TABLE_200
437 , a108 out nocopy JTF_VARCHAR2_TABLE_200
438 , a109 out nocopy JTF_VARCHAR2_TABLE_100
439 , a110 out nocopy JTF_VARCHAR2_TABLE_200
440 , a111 out nocopy JTF_VARCHAR2_TABLE_200
441 , a112 out nocopy JTF_VARCHAR2_TABLE_200
442 , a113 out nocopy JTF_VARCHAR2_TABLE_200
443 , a114 out nocopy JTF_VARCHAR2_TABLE_200
444 , a115 out nocopy JTF_VARCHAR2_TABLE_200
445 , a116 out nocopy JTF_VARCHAR2_TABLE_200
446 , a117 out nocopy JTF_VARCHAR2_TABLE_200
447 , a118 out nocopy JTF_VARCHAR2_TABLE_200
448 , a119 out nocopy JTF_VARCHAR2_TABLE_200
449 , a120 out nocopy JTF_VARCHAR2_TABLE_200
450 , a121 out nocopy JTF_VARCHAR2_TABLE_200
451 , a122 out nocopy JTF_VARCHAR2_TABLE_200
452 , a123 out nocopy JTF_VARCHAR2_TABLE_200
453 , a124 out nocopy JTF_VARCHAR2_TABLE_200
454 , a125 out nocopy JTF_NUMBER_TABLE
455 , a126 out nocopy JTF_NUMBER_TABLE
456 , a127 out nocopy JTF_VARCHAR2_TABLE_100
457 , a128 out nocopy JTF_NUMBER_TABLE
458 , a129 out nocopy JTF_VARCHAR2_TABLE_100
459 , a130 out nocopy JTF_VARCHAR2_TABLE_100
460 , a131 out nocopy JTF_NUMBER_TABLE
461 , a132 out nocopy JTF_NUMBER_TABLE
462 , a133 out nocopy JTF_NUMBER_TABLE
463 , a134 out nocopy JTF_VARCHAR2_TABLE_100
464 , a135 out nocopy JTF_NUMBER_TABLE
465 , a136 out nocopy JTF_NUMBER_TABLE
466 , a137 out nocopy JTF_VARCHAR2_TABLE_300
467 , a138 out nocopy JTF_VARCHAR2_TABLE_300
468 , a139 out nocopy JTF_VARCHAR2_TABLE_100
469 , a140 out nocopy JTF_VARCHAR2_TABLE_100
470 , a141 out nocopy JTF_NUMBER_TABLE
471 , a142 out nocopy JTF_NUMBER_TABLE
472 , a143 out nocopy JTF_VARCHAR2_TABLE_100
473 , a144 out nocopy JTF_VARCHAR2_TABLE_100
474 , a145 out nocopy JTF_NUMBER_TABLE
475 , a146 out nocopy JTF_VARCHAR2_TABLE_100
476 , a147 out nocopy JTF_VARCHAR2_TABLE_100
477 ) as
478 ddindx binary_integer; indx binary_integer;
479 begin
480 if t is null or t.count = 0 then
481 a0 := JTF_NUMBER_TABLE();
482 a1 := JTF_NUMBER_TABLE();
483 a2 := JTF_DATE_TABLE();
484 a3 := JTF_NUMBER_TABLE();
485 a4 := JTF_DATE_TABLE();
486 a5 := JTF_NUMBER_TABLE();
487 a6 := JTF_NUMBER_TABLE();
488 a7 := JTF_NUMBER_TABLE();
489 a8 := JTF_NUMBER_TABLE();
490 a9 := JTF_DATE_TABLE();
491 a10 := JTF_NUMBER_TABLE();
492 a11 := JTF_VARCHAR2_TABLE_100();
493 a12 := JTF_NUMBER_TABLE();
494 a13 := JTF_VARCHAR2_TABLE_100();
495 a14 := JTF_NUMBER_TABLE();
496 a15 := JTF_VARCHAR2_TABLE_100();
497 a16 := JTF_DATE_TABLE();
498 a17 := JTF_DATE_TABLE();
499 a18 := JTF_NUMBER_TABLE();
500 a19 := JTF_VARCHAR2_TABLE_100();
501 a20 := JTF_DATE_TABLE();
502 a21 := JTF_VARCHAR2_TABLE_2000();
503 a22 := JTF_NUMBER_TABLE();
504 a23 := JTF_NUMBER_TABLE();
505 a24 := JTF_DATE_TABLE();
506 a25 := JTF_NUMBER_TABLE();
507 a26 := JTF_NUMBER_TABLE();
508 a27 := JTF_NUMBER_TABLE();
509 a28 := JTF_NUMBER_TABLE();
510 a29 := JTF_NUMBER_TABLE();
511 a30 := JTF_NUMBER_TABLE();
512 a31 := JTF_NUMBER_TABLE();
513 a32 := JTF_NUMBER_TABLE();
514 a33 := JTF_NUMBER_TABLE();
515 a34 := JTF_NUMBER_TABLE();
516 a35 := JTF_VARCHAR2_TABLE_100();
517 a36 := JTF_VARCHAR2_TABLE_100();
518 a37 := JTF_VARCHAR2_TABLE_100();
519 a38 := JTF_VARCHAR2_TABLE_100();
520 a39 := JTF_DATE_TABLE();
521 a40 := JTF_NUMBER_TABLE();
522 a41 := JTF_NUMBER_TABLE();
523 a42 := JTF_DATE_TABLE();
524 a43 := JTF_NUMBER_TABLE();
525 a44 := JTF_VARCHAR2_TABLE_100();
526 a45 := JTF_NUMBER_TABLE();
527 a46 := JTF_VARCHAR2_TABLE_100();
528 a47 := JTF_NUMBER_TABLE();
529 a48 := JTF_NUMBER_TABLE();
530 a49 := JTF_NUMBER_TABLE();
531 a50 := JTF_NUMBER_TABLE();
532 a51 := JTF_VARCHAR2_TABLE_100();
533 a52 := JTF_NUMBER_TABLE();
534 a53 := JTF_NUMBER_TABLE();
535 a54 := JTF_VARCHAR2_TABLE_100();
536 a55 := JTF_NUMBER_TABLE();
537 a56 := JTF_NUMBER_TABLE();
538 a57 := JTF_VARCHAR2_TABLE_100();
539 a58 := JTF_NUMBER_TABLE();
540 a59 := JTF_NUMBER_TABLE();
541 a60 := JTF_VARCHAR2_TABLE_100();
542 a61 := JTF_NUMBER_TABLE();
543 a62 := JTF_NUMBER_TABLE();
544 a63 := JTF_NUMBER_TABLE();
545 a64 := JTF_NUMBER_TABLE();
546 a65 := JTF_NUMBER_TABLE();
547 a66 := JTF_NUMBER_TABLE();
548 a67 := JTF_DATE_TABLE();
549 a68 := JTF_VARCHAR2_TABLE_100();
550 a69 := JTF_NUMBER_TABLE();
551 a70 := JTF_NUMBER_TABLE();
552 a71 := JTF_VARCHAR2_TABLE_100();
553 a72 := JTF_NUMBER_TABLE();
554 a73 := JTF_NUMBER_TABLE();
555 a74 := JTF_DATE_TABLE();
556 a75 := JTF_VARCHAR2_TABLE_100();
557 a76 := JTF_NUMBER_TABLE();
558 a77 := JTF_VARCHAR2_TABLE_100();
559 a78 := JTF_NUMBER_TABLE();
560 a79 := JTF_VARCHAR2_TABLE_100();
561 a80 := JTF_DATE_TABLE();
562 a81 := JTF_VARCHAR2_TABLE_100();
563 a82 := JTF_VARCHAR2_TABLE_100();
564 a83 := JTF_DATE_TABLE();
565 a84 := JTF_NUMBER_TABLE();
566 a85 := JTF_DATE_TABLE();
567 a86 := JTF_NUMBER_TABLE();
568 a87 := JTF_DATE_TABLE();
569 a88 := JTF_NUMBER_TABLE();
570 a89 := JTF_NUMBER_TABLE();
571 a90 := JTF_NUMBER_TABLE();
572 a91 := JTF_NUMBER_TABLE();
573 a92 := JTF_VARCHAR2_TABLE_2000();
574 a93 := JTF_VARCHAR2_TABLE_100();
575 a94 := JTF_VARCHAR2_TABLE_200();
576 a95 := JTF_VARCHAR2_TABLE_200();
577 a96 := JTF_VARCHAR2_TABLE_200();
578 a97 := JTF_VARCHAR2_TABLE_200();
579 a98 := JTF_VARCHAR2_TABLE_200();
580 a99 := JTF_VARCHAR2_TABLE_200();
581 a100 := JTF_VARCHAR2_TABLE_200();
582 a101 := JTF_VARCHAR2_TABLE_200();
583 a102 := JTF_VARCHAR2_TABLE_200();
584 a103 := JTF_VARCHAR2_TABLE_200();
585 a104 := JTF_VARCHAR2_TABLE_200();
586 a105 := JTF_VARCHAR2_TABLE_200();
587 a106 := JTF_VARCHAR2_TABLE_200();
588 a107 := JTF_VARCHAR2_TABLE_200();
589 a108 := JTF_VARCHAR2_TABLE_200();
590 a109 := JTF_VARCHAR2_TABLE_100();
591 a110 := JTF_VARCHAR2_TABLE_200();
592 a111 := JTF_VARCHAR2_TABLE_200();
593 a112 := JTF_VARCHAR2_TABLE_200();
594 a113 := JTF_VARCHAR2_TABLE_200();
595 a114 := JTF_VARCHAR2_TABLE_200();
596 a115 := JTF_VARCHAR2_TABLE_200();
597 a116 := JTF_VARCHAR2_TABLE_200();
598 a117 := JTF_VARCHAR2_TABLE_200();
599 a118 := JTF_VARCHAR2_TABLE_200();
600 a119 := JTF_VARCHAR2_TABLE_200();
601 a120 := JTF_VARCHAR2_TABLE_200();
602 a121 := JTF_VARCHAR2_TABLE_200();
603 a122 := JTF_VARCHAR2_TABLE_200();
604 a123 := JTF_VARCHAR2_TABLE_200();
605 a124 := JTF_VARCHAR2_TABLE_200();
606 a125 := JTF_NUMBER_TABLE();
607 a126 := JTF_NUMBER_TABLE();
608 a127 := JTF_VARCHAR2_TABLE_100();
609 a128 := JTF_NUMBER_TABLE();
610 a129 := JTF_VARCHAR2_TABLE_100();
611 a130 := JTF_VARCHAR2_TABLE_100();
612 a131 := JTF_NUMBER_TABLE();
613 a132 := JTF_NUMBER_TABLE();
614 a133 := JTF_NUMBER_TABLE();
615 a134 := JTF_VARCHAR2_TABLE_100();
616 a135 := JTF_NUMBER_TABLE();
617 a136 := JTF_NUMBER_TABLE();
618 a137 := JTF_VARCHAR2_TABLE_300();
619 a138 := JTF_VARCHAR2_TABLE_300();
620 a139 := JTF_VARCHAR2_TABLE_100();
621 a140 := JTF_VARCHAR2_TABLE_100();
622 a141 := JTF_NUMBER_TABLE();
623 a142 := JTF_NUMBER_TABLE();
624 a143 := JTF_VARCHAR2_TABLE_100();
625 a144 := JTF_VARCHAR2_TABLE_100();
626 a145 := JTF_NUMBER_TABLE();
627 a146 := JTF_VARCHAR2_TABLE_100();
628 a147 := JTF_VARCHAR2_TABLE_100();
629 else
630 a0 := JTF_NUMBER_TABLE();
631 a1 := JTF_NUMBER_TABLE();
632 a2 := JTF_DATE_TABLE();
633 a3 := JTF_NUMBER_TABLE();
634 a4 := JTF_DATE_TABLE();
635 a5 := JTF_NUMBER_TABLE();
636 a6 := JTF_NUMBER_TABLE();
637 a7 := JTF_NUMBER_TABLE();
638 a8 := JTF_NUMBER_TABLE();
639 a9 := JTF_DATE_TABLE();
640 a10 := JTF_NUMBER_TABLE();
641 a11 := JTF_VARCHAR2_TABLE_100();
642 a12 := JTF_NUMBER_TABLE();
643 a13 := JTF_VARCHAR2_TABLE_100();
644 a14 := JTF_NUMBER_TABLE();
645 a15 := JTF_VARCHAR2_TABLE_100();
646 a16 := JTF_DATE_TABLE();
647 a17 := JTF_DATE_TABLE();
648 a18 := JTF_NUMBER_TABLE();
649 a19 := JTF_VARCHAR2_TABLE_100();
650 a20 := JTF_DATE_TABLE();
651 a21 := JTF_VARCHAR2_TABLE_2000();
652 a22 := JTF_NUMBER_TABLE();
653 a23 := JTF_NUMBER_TABLE();
654 a24 := JTF_DATE_TABLE();
655 a25 := JTF_NUMBER_TABLE();
656 a26 := JTF_NUMBER_TABLE();
657 a27 := JTF_NUMBER_TABLE();
658 a28 := JTF_NUMBER_TABLE();
659 a29 := JTF_NUMBER_TABLE();
660 a30 := JTF_NUMBER_TABLE();
661 a31 := JTF_NUMBER_TABLE();
662 a32 := JTF_NUMBER_TABLE();
663 a33 := JTF_NUMBER_TABLE();
664 a34 := JTF_NUMBER_TABLE();
665 a35 := JTF_VARCHAR2_TABLE_100();
666 a36 := JTF_VARCHAR2_TABLE_100();
667 a37 := JTF_VARCHAR2_TABLE_100();
668 a38 := JTF_VARCHAR2_TABLE_100();
669 a39 := JTF_DATE_TABLE();
670 a40 := JTF_NUMBER_TABLE();
671 a41 := JTF_NUMBER_TABLE();
672 a42 := JTF_DATE_TABLE();
673 a43 := JTF_NUMBER_TABLE();
674 a44 := JTF_VARCHAR2_TABLE_100();
675 a45 := JTF_NUMBER_TABLE();
676 a46 := JTF_VARCHAR2_TABLE_100();
677 a47 := JTF_NUMBER_TABLE();
678 a48 := JTF_NUMBER_TABLE();
679 a49 := JTF_NUMBER_TABLE();
680 a50 := JTF_NUMBER_TABLE();
681 a51 := JTF_VARCHAR2_TABLE_100();
682 a52 := JTF_NUMBER_TABLE();
683 a53 := JTF_NUMBER_TABLE();
684 a54 := JTF_VARCHAR2_TABLE_100();
685 a55 := JTF_NUMBER_TABLE();
686 a56 := JTF_NUMBER_TABLE();
687 a57 := JTF_VARCHAR2_TABLE_100();
688 a58 := JTF_NUMBER_TABLE();
689 a59 := JTF_NUMBER_TABLE();
690 a60 := JTF_VARCHAR2_TABLE_100();
691 a61 := JTF_NUMBER_TABLE();
692 a62 := JTF_NUMBER_TABLE();
693 a63 := JTF_NUMBER_TABLE();
694 a64 := JTF_NUMBER_TABLE();
695 a65 := JTF_NUMBER_TABLE();
696 a66 := JTF_NUMBER_TABLE();
697 a67 := JTF_DATE_TABLE();
698 a68 := JTF_VARCHAR2_TABLE_100();
699 a69 := JTF_NUMBER_TABLE();
700 a70 := JTF_NUMBER_TABLE();
701 a71 := JTF_VARCHAR2_TABLE_100();
702 a72 := JTF_NUMBER_TABLE();
703 a73 := JTF_NUMBER_TABLE();
704 a74 := JTF_DATE_TABLE();
705 a75 := JTF_VARCHAR2_TABLE_100();
706 a76 := JTF_NUMBER_TABLE();
707 a77 := JTF_VARCHAR2_TABLE_100();
708 a78 := JTF_NUMBER_TABLE();
709 a79 := JTF_VARCHAR2_TABLE_100();
710 a80 := JTF_DATE_TABLE();
711 a81 := JTF_VARCHAR2_TABLE_100();
712 a82 := JTF_VARCHAR2_TABLE_100();
713 a83 := JTF_DATE_TABLE();
714 a84 := JTF_NUMBER_TABLE();
715 a85 := JTF_DATE_TABLE();
716 a86 := JTF_NUMBER_TABLE();
717 a87 := JTF_DATE_TABLE();
718 a88 := JTF_NUMBER_TABLE();
719 a89 := JTF_NUMBER_TABLE();
720 a90 := JTF_NUMBER_TABLE();
721 a91 := JTF_NUMBER_TABLE();
722 a92 := JTF_VARCHAR2_TABLE_2000();
723 a93 := JTF_VARCHAR2_TABLE_100();
724 a94 := JTF_VARCHAR2_TABLE_200();
725 a95 := JTF_VARCHAR2_TABLE_200();
726 a96 := JTF_VARCHAR2_TABLE_200();
727 a97 := JTF_VARCHAR2_TABLE_200();
728 a98 := JTF_VARCHAR2_TABLE_200();
729 a99 := JTF_VARCHAR2_TABLE_200();
730 a100 := JTF_VARCHAR2_TABLE_200();
731 a101 := JTF_VARCHAR2_TABLE_200();
732 a102 := JTF_VARCHAR2_TABLE_200();
733 a103 := JTF_VARCHAR2_TABLE_200();
734 a104 := JTF_VARCHAR2_TABLE_200();
735 a105 := JTF_VARCHAR2_TABLE_200();
736 a106 := JTF_VARCHAR2_TABLE_200();
737 a107 := JTF_VARCHAR2_TABLE_200();
738 a108 := JTF_VARCHAR2_TABLE_200();
739 a109 := JTF_VARCHAR2_TABLE_100();
740 a110 := JTF_VARCHAR2_TABLE_200();
741 a111 := JTF_VARCHAR2_TABLE_200();
742 a112 := JTF_VARCHAR2_TABLE_200();
743 a113 := JTF_VARCHAR2_TABLE_200();
744 a114 := JTF_VARCHAR2_TABLE_200();
745 a115 := JTF_VARCHAR2_TABLE_200();
746 a116 := JTF_VARCHAR2_TABLE_200();
747 a117 := JTF_VARCHAR2_TABLE_200();
748 a118 := JTF_VARCHAR2_TABLE_200();
749 a119 := JTF_VARCHAR2_TABLE_200();
750 a120 := JTF_VARCHAR2_TABLE_200();
751 a121 := JTF_VARCHAR2_TABLE_200();
752 a122 := JTF_VARCHAR2_TABLE_200();
753 a123 := JTF_VARCHAR2_TABLE_200();
754 a124 := JTF_VARCHAR2_TABLE_200();
755 a125 := JTF_NUMBER_TABLE();
756 a126 := JTF_NUMBER_TABLE();
757 a127 := JTF_VARCHAR2_TABLE_100();
758 a128 := JTF_NUMBER_TABLE();
759 a129 := JTF_VARCHAR2_TABLE_100();
760 a130 := JTF_VARCHAR2_TABLE_100();
761 a131 := JTF_NUMBER_TABLE();
762 a132 := JTF_NUMBER_TABLE();
763 a133 := JTF_NUMBER_TABLE();
764 a134 := JTF_VARCHAR2_TABLE_100();
765 a135 := JTF_NUMBER_TABLE();
766 a136 := JTF_NUMBER_TABLE();
767 a137 := JTF_VARCHAR2_TABLE_300();
768 a138 := JTF_VARCHAR2_TABLE_300();
769 a139 := JTF_VARCHAR2_TABLE_100();
770 a140 := JTF_VARCHAR2_TABLE_100();
771 a141 := JTF_NUMBER_TABLE();
772 a142 := JTF_NUMBER_TABLE();
773 a143 := JTF_VARCHAR2_TABLE_100();
774 a144 := JTF_VARCHAR2_TABLE_100();
775 a145 := JTF_NUMBER_TABLE();
776 a146 := JTF_VARCHAR2_TABLE_100();
777 a147 := JTF_VARCHAR2_TABLE_100();
778 if t.count > 0 then
779 a0.extend(t.count);
780 a1.extend(t.count);
781 a2.extend(t.count);
782 a3.extend(t.count);
783 a4.extend(t.count);
784 a5.extend(t.count);
785 a6.extend(t.count);
786 a7.extend(t.count);
787 a8.extend(t.count);
788 a9.extend(t.count);
789 a10.extend(t.count);
790 a11.extend(t.count);
791 a12.extend(t.count);
792 a13.extend(t.count);
793 a14.extend(t.count);
794 a15.extend(t.count);
795 a16.extend(t.count);
796 a17.extend(t.count);
797 a18.extend(t.count);
798 a19.extend(t.count);
799 a20.extend(t.count);
800 a21.extend(t.count);
801 a22.extend(t.count);
802 a23.extend(t.count);
803 a24.extend(t.count);
804 a25.extend(t.count);
805 a26.extend(t.count);
806 a27.extend(t.count);
807 a28.extend(t.count);
808 a29.extend(t.count);
809 a30.extend(t.count);
810 a31.extend(t.count);
811 a32.extend(t.count);
812 a33.extend(t.count);
813 a34.extend(t.count);
814 a35.extend(t.count);
815 a36.extend(t.count);
816 a37.extend(t.count);
817 a38.extend(t.count);
818 a39.extend(t.count);
819 a40.extend(t.count);
820 a41.extend(t.count);
821 a42.extend(t.count);
822 a43.extend(t.count);
823 a44.extend(t.count);
824 a45.extend(t.count);
825 a46.extend(t.count);
826 a47.extend(t.count);
827 a48.extend(t.count);
828 a49.extend(t.count);
829 a50.extend(t.count);
830 a51.extend(t.count);
831 a52.extend(t.count);
832 a53.extend(t.count);
833 a54.extend(t.count);
834 a55.extend(t.count);
835 a56.extend(t.count);
836 a57.extend(t.count);
837 a58.extend(t.count);
838 a59.extend(t.count);
839 a60.extend(t.count);
840 a61.extend(t.count);
841 a62.extend(t.count);
842 a63.extend(t.count);
843 a64.extend(t.count);
844 a65.extend(t.count);
845 a66.extend(t.count);
846 a67.extend(t.count);
847 a68.extend(t.count);
848 a69.extend(t.count);
849 a70.extend(t.count);
850 a71.extend(t.count);
851 a72.extend(t.count);
852 a73.extend(t.count);
853 a74.extend(t.count);
854 a75.extend(t.count);
855 a76.extend(t.count);
856 a77.extend(t.count);
857 a78.extend(t.count);
858 a79.extend(t.count);
859 a80.extend(t.count);
860 a81.extend(t.count);
861 a82.extend(t.count);
862 a83.extend(t.count);
863 a84.extend(t.count);
864 a85.extend(t.count);
865 a86.extend(t.count);
866 a87.extend(t.count);
867 a88.extend(t.count);
868 a89.extend(t.count);
869 a90.extend(t.count);
870 a91.extend(t.count);
871 a92.extend(t.count);
872 a93.extend(t.count);
873 a94.extend(t.count);
874 a95.extend(t.count);
875 a96.extend(t.count);
876 a97.extend(t.count);
877 a98.extend(t.count);
878 a99.extend(t.count);
879 a100.extend(t.count);
880 a101.extend(t.count);
881 a102.extend(t.count);
882 a103.extend(t.count);
883 a104.extend(t.count);
884 a105.extend(t.count);
885 a106.extend(t.count);
886 a107.extend(t.count);
887 a108.extend(t.count);
888 a109.extend(t.count);
889 a110.extend(t.count);
890 a111.extend(t.count);
891 a112.extend(t.count);
892 a113.extend(t.count);
893 a114.extend(t.count);
894 a115.extend(t.count);
895 a116.extend(t.count);
896 a117.extend(t.count);
897 a118.extend(t.count);
898 a119.extend(t.count);
899 a120.extend(t.count);
900 a121.extend(t.count);
901 a122.extend(t.count);
902 a123.extend(t.count);
903 a124.extend(t.count);
904 a125.extend(t.count);
905 a126.extend(t.count);
906 a127.extend(t.count);
907 a128.extend(t.count);
908 a129.extend(t.count);
909 a130.extend(t.count);
910 a131.extend(t.count);
911 a132.extend(t.count);
912 a133.extend(t.count);
913 a134.extend(t.count);
914 a135.extend(t.count);
915 a136.extend(t.count);
916 a137.extend(t.count);
917 a138.extend(t.count);
918 a139.extend(t.count);
919 a140.extend(t.count);
920 a141.extend(t.count);
921 a142.extend(t.count);
922 a143.extend(t.count);
923 a144.extend(t.count);
924 a145.extend(t.count);
925 a146.extend(t.count);
926 a147.extend(t.count);
927 ddindx := t.first;
928 indx := 1;
929 while true loop
930 a0(indx) := t(ddindx).claim_id;
931 a1(indx) := t(ddindx).object_version_number;
932 a2(indx) := t(ddindx).last_update_date;
933 a3(indx) := t(ddindx).last_updated_by;
934 a4(indx) := t(ddindx).creation_date;
935 a5(indx) := t(ddindx).created_by;
936 a6(indx) := t(ddindx).last_update_login;
937 a7(indx) := t(ddindx).request_id;
938 a8(indx) := t(ddindx).program_application_id;
939 a9(indx) := t(ddindx).program_update_date;
940 a10(indx) := t(ddindx).program_id;
941 a11(indx) := t(ddindx).created_from;
942 a12(indx) := t(ddindx).batch_id;
943 a13(indx) := t(ddindx).claim_number;
944 a14(indx) := t(ddindx).claim_type_id;
945 a15(indx) := t(ddindx).claim_class;
946 a16(indx) := t(ddindx).claim_date;
947 a17(indx) := t(ddindx).due_date;
948 a18(indx) := t(ddindx).owner_id;
949 a19(indx) := t(ddindx).history_event;
950 a20(indx) := t(ddindx).history_event_date;
951 a21(indx) := t(ddindx).history_event_description;
952 a22(indx) := t(ddindx).split_from_claim_id;
953 a23(indx) := t(ddindx).duplicate_claim_id;
954 a24(indx) := t(ddindx).split_date;
955 a25(indx) := t(ddindx).root_claim_id;
956 a26(indx) := t(ddindx).amount;
957 a27(indx) := t(ddindx).amount_adjusted;
958 a28(indx) := t(ddindx).amount_remaining;
959 a29(indx) := t(ddindx).amount_settled;
960 a30(indx) := t(ddindx).acctd_amount;
961 a31(indx) := t(ddindx).acctd_amount_remaining;
962 a32(indx) := t(ddindx).acctd_amount_adjusted;
963 a33(indx) := t(ddindx).acctd_amount_settled;
964 a34(indx) := t(ddindx).tax_amount;
965 a35(indx) := t(ddindx).tax_code;
966 a36(indx) := t(ddindx).tax_calculation_flag;
967 a37(indx) := t(ddindx).currency_code;
968 a38(indx) := t(ddindx).exchange_rate_type;
969 a39(indx) := t(ddindx).exchange_rate_date;
970 a40(indx) := t(ddindx).exchange_rate;
971 a41(indx) := t(ddindx).set_of_books_id;
972 a42(indx) := t(ddindx).original_claim_date;
973 a43(indx) := t(ddindx).source_object_id;
974 a44(indx) := t(ddindx).source_object_class;
975 a45(indx) := t(ddindx).source_object_type_id;
976 a46(indx) := t(ddindx).source_object_number;
977 a47(indx) := t(ddindx).cust_account_id;
978 a48(indx) := t(ddindx).cust_billto_acct_site_id;
979 a49(indx) := t(ddindx).cust_shipto_acct_site_id;
980 a50(indx) := t(ddindx).location_id;
981 a51(indx) := t(ddindx).pay_related_account_flag;
982 a52(indx) := t(ddindx).related_cust_account_id;
983 a53(indx) := t(ddindx).related_site_use_id;
984 a54(indx) := t(ddindx).relationship_type;
985 a55(indx) := t(ddindx).vendor_id;
986 a56(indx) := t(ddindx).vendor_site_id;
987 a57(indx) := t(ddindx).reason_type;
988 a58(indx) := t(ddindx).reason_code_id;
989 a59(indx) := t(ddindx).task_template_group_id;
990 a60(indx) := t(ddindx).status_code;
991 a61(indx) := t(ddindx).user_status_id;
992 a62(indx) := t(ddindx).sales_rep_id;
993 a63(indx) := t(ddindx).collector_id;
994 a64(indx) := t(ddindx).contact_id;
995 a65(indx) := t(ddindx).broker_id;
996 a66(indx) := t(ddindx).territory_id;
997 a67(indx) := t(ddindx).customer_ref_date;
998 a68(indx) := t(ddindx).customer_ref_number;
999 a69(indx) := t(ddindx).assigned_to;
1000 a70(indx) := t(ddindx).receipt_id;
1001 a71(indx) := t(ddindx).receipt_number;
1002 a72(indx) := t(ddindx).doc_sequence_id;
1003 a73(indx) := t(ddindx).doc_sequence_value;
1004 a74(indx) := t(ddindx).gl_date;
1005 a75(indx) := t(ddindx).payment_method;
1006 a76(indx) := t(ddindx).voucher_id;
1007 a77(indx) := t(ddindx).voucher_number;
1008 a78(indx) := t(ddindx).payment_reference_id;
1009 a79(indx) := t(ddindx).payment_reference_number;
1010 a80(indx) := t(ddindx).payment_reference_date;
1011 a81(indx) := t(ddindx).payment_status;
1012 a82(indx) := t(ddindx).approved_flag;
1013 a83(indx) := t(ddindx).approved_date;
1014 a84(indx) := t(ddindx).approved_by;
1015 a85(indx) := t(ddindx).settled_date;
1016 a86(indx) := t(ddindx).settled_by;
1017 a87(indx) := t(ddindx).effective_date;
1018 a88(indx) := t(ddindx).custom_setup_id;
1019 a89(indx) := t(ddindx).task_id;
1020 a90(indx) := t(ddindx).country_id;
1021 a91(indx) := t(ddindx).order_type_id;
1022 a92(indx) := t(ddindx).comments;
1023 a93(indx) := t(ddindx).attribute_category;
1024 a94(indx) := t(ddindx).attribute1;
1025 a95(indx) := t(ddindx).attribute2;
1026 a96(indx) := t(ddindx).attribute3;
1027 a97(indx) := t(ddindx).attribute4;
1028 a98(indx) := t(ddindx).attribute5;
1029 a99(indx) := t(ddindx).attribute6;
1030 a100(indx) := t(ddindx).attribute7;
1031 a101(indx) := t(ddindx).attribute8;
1032 a102(indx) := t(ddindx).attribute9;
1033 a103(indx) := t(ddindx).attribute10;
1034 a104(indx) := t(ddindx).attribute11;
1035 a105(indx) := t(ddindx).attribute12;
1036 a106(indx) := t(ddindx).attribute13;
1037 a107(indx) := t(ddindx).attribute14;
1038 a108(indx) := t(ddindx).attribute15;
1039 a109(indx) := t(ddindx).deduction_attribute_category;
1040 a110(indx) := t(ddindx).deduction_attribute1;
1041 a111(indx) := t(ddindx).deduction_attribute2;
1042 a112(indx) := t(ddindx).deduction_attribute3;
1043 a113(indx) := t(ddindx).deduction_attribute4;
1044 a114(indx) := t(ddindx).deduction_attribute5;
1045 a115(indx) := t(ddindx).deduction_attribute6;
1046 a116(indx) := t(ddindx).deduction_attribute7;
1047 a117(indx) := t(ddindx).deduction_attribute8;
1048 a118(indx) := t(ddindx).deduction_attribute9;
1049 a119(indx) := t(ddindx).deduction_attribute10;
1050 a120(indx) := t(ddindx).deduction_attribute11;
1051 a121(indx) := t(ddindx).deduction_attribute12;
1052 a122(indx) := t(ddindx).deduction_attribute13;
1053 a123(indx) := t(ddindx).deduction_attribute14;
1054 a124(indx) := t(ddindx).deduction_attribute15;
1055 a125(indx) := t(ddindx).org_id;
1056 a126(indx) := t(ddindx).legal_entity_id;
1057 a127(indx) := t(ddindx).write_off_flag;
1058 a128(indx) := t(ddindx).write_off_threshold_amount;
1059 a129(indx) := t(ddindx).under_write_off_threshold;
1060 a130(indx) := t(ddindx).customer_reason;
1061 a131(indx) := t(ddindx).ship_to_cust_account_id;
1062 a132(indx) := t(ddindx).amount_applied;
1063 a133(indx) := t(ddindx).applied_receipt_id;
1064 a134(indx) := t(ddindx).applied_receipt_number;
1065 a135(indx) := t(ddindx).wo_rec_trx_id;
1066 a136(indx) := t(ddindx).group_claim_id;
1067 a137(indx) := t(ddindx).appr_wf_item_key;
1068 a138(indx) := t(ddindx).cstl_wf_item_key;
1069 a139(indx) := t(ddindx).batch_type;
1070 a140(indx) := t(ddindx).tax_action;
1071 a141(indx) := t(ddindx).close_status_id;
1072 a142(indx) := t(ddindx).open_status_id;
1073 a143(indx) := t(ddindx).pre_auth_deduction_number;
1074 a144(indx) := t(ddindx).pre_auth_deduction_normalized;
1075 a145(indx) := t(ddindx).offer_id;
1076 a146(indx) := t(ddindx).settled_from;
1077 a147(indx) := t(ddindx).approval_in_prog;
1078 indx := indx+1;
1079 if t.last =ddindx
1080 then exit;
1081 end if;
1082 ddindx := t.next(ddindx);
1083 end loop;
1084 end if;
1085 end if;
1086 end rosetta_table_copy_out_p3;
1087
1088 procedure create_claim(p_api_version NUMBER
1089 , p_init_msg_list VARCHAR2
1090 , p_commit VARCHAR2
1091 , p_validation_level NUMBER
1092 , x_return_status out nocopy VARCHAR2
1093 , x_msg_data out nocopy VARCHAR2
1094 , x_msg_count out nocopy NUMBER
1095 , p7_a0 NUMBER
1096 , p7_a1 NUMBER
1097 , p7_a2 DATE
1098 , p7_a3 NUMBER
1099 , p7_a4 DATE
1100 , p7_a5 NUMBER
1101 , p7_a6 NUMBER
1102 , p7_a7 NUMBER
1103 , p7_a8 NUMBER
1104 , p7_a9 DATE
1105 , p7_a10 NUMBER
1106 , p7_a11 VARCHAR2
1107 , p7_a12 NUMBER
1108 , p7_a13 VARCHAR2
1109 , p7_a14 NUMBER
1110 , p7_a15 VARCHAR2
1111 , p7_a16 DATE
1112 , p7_a17 DATE
1113 , p7_a18 NUMBER
1114 , p7_a19 VARCHAR2
1115 , p7_a20 DATE
1116 , p7_a21 VARCHAR2
1117 , p7_a22 NUMBER
1118 , p7_a23 NUMBER
1119 , p7_a24 DATE
1120 , p7_a25 NUMBER
1121 , p7_a26 NUMBER
1122 , p7_a27 NUMBER
1123 , p7_a28 NUMBER
1124 , p7_a29 NUMBER
1125 , p7_a30 NUMBER
1126 , p7_a31 NUMBER
1127 , p7_a32 NUMBER
1128 , p7_a33 NUMBER
1129 , p7_a34 NUMBER
1130 , p7_a35 VARCHAR2
1131 , p7_a36 VARCHAR2
1132 , p7_a37 VARCHAR2
1133 , p7_a38 VARCHAR2
1134 , p7_a39 DATE
1135 , p7_a40 NUMBER
1136 , p7_a41 NUMBER
1137 , p7_a42 DATE
1138 , p7_a43 NUMBER
1139 , p7_a44 VARCHAR2
1140 , p7_a45 NUMBER
1141 , p7_a46 VARCHAR2
1142 , p7_a47 NUMBER
1143 , p7_a48 NUMBER
1144 , p7_a49 NUMBER
1145 , p7_a50 NUMBER
1146 , p7_a51 VARCHAR2
1147 , p7_a52 NUMBER
1148 , p7_a53 NUMBER
1149 , p7_a54 VARCHAR2
1150 , p7_a55 NUMBER
1151 , p7_a56 NUMBER
1152 , p7_a57 VARCHAR2
1153 , p7_a58 NUMBER
1154 , p7_a59 NUMBER
1155 , p7_a60 VARCHAR2
1156 , p7_a61 NUMBER
1157 , p7_a62 NUMBER
1158 , p7_a63 NUMBER
1159 , p7_a64 NUMBER
1160 , p7_a65 NUMBER
1161 , p7_a66 NUMBER
1162 , p7_a67 DATE
1163 , p7_a68 VARCHAR2
1164 , p7_a69 NUMBER
1165 , p7_a70 NUMBER
1166 , p7_a71 VARCHAR2
1167 , p7_a72 NUMBER
1168 , p7_a73 NUMBER
1169 , p7_a74 DATE
1170 , p7_a75 VARCHAR2
1171 , p7_a76 NUMBER
1172 , p7_a77 VARCHAR2
1173 , p7_a78 NUMBER
1174 , p7_a79 VARCHAR2
1175 , p7_a80 DATE
1176 , p7_a81 VARCHAR2
1177 , p7_a82 VARCHAR2
1178 , p7_a83 DATE
1179 , p7_a84 NUMBER
1180 , p7_a85 DATE
1181 , p7_a86 NUMBER
1182 , p7_a87 DATE
1183 , p7_a88 NUMBER
1184 , p7_a89 NUMBER
1185 , p7_a90 NUMBER
1186 , p7_a91 NUMBER
1187 , p7_a92 VARCHAR2
1188 , p7_a93 VARCHAR2
1189 , p7_a94 VARCHAR2
1190 , p7_a95 VARCHAR2
1191 , p7_a96 VARCHAR2
1192 , p7_a97 VARCHAR2
1193 , p7_a98 VARCHAR2
1194 , p7_a99 VARCHAR2
1195 , p7_a100 VARCHAR2
1196 , p7_a101 VARCHAR2
1197 , p7_a102 VARCHAR2
1198 , p7_a103 VARCHAR2
1199 , p7_a104 VARCHAR2
1200 , p7_a105 VARCHAR2
1201 , p7_a106 VARCHAR2
1202 , p7_a107 VARCHAR2
1203 , p7_a108 VARCHAR2
1204 , p7_a109 VARCHAR2
1205 , p7_a110 VARCHAR2
1206 , p7_a111 VARCHAR2
1207 , p7_a112 VARCHAR2
1208 , p7_a113 VARCHAR2
1209 , p7_a114 VARCHAR2
1210 , p7_a115 VARCHAR2
1211 , p7_a116 VARCHAR2
1212 , p7_a117 VARCHAR2
1213 , p7_a118 VARCHAR2
1214 , p7_a119 VARCHAR2
1215 , p7_a120 VARCHAR2
1216 , p7_a121 VARCHAR2
1217 , p7_a122 VARCHAR2
1218 , p7_a123 VARCHAR2
1219 , p7_a124 VARCHAR2
1220 , p7_a125 NUMBER
1221 , p7_a126 NUMBER
1222 , p7_a127 VARCHAR2
1223 , p7_a128 NUMBER
1224 , p7_a129 VARCHAR2
1225 , p7_a130 VARCHAR2
1226 , p7_a131 NUMBER
1227 , p7_a132 NUMBER
1228 , p7_a133 NUMBER
1229 , p7_a134 VARCHAR2
1230 , p7_a135 NUMBER
1231 , p7_a136 NUMBER
1232 , p7_a137 VARCHAR2
1233 , p7_a138 VARCHAR2
1234 , p7_a139 VARCHAR2
1235 , p7_a140 VARCHAR2
1236 , p7_a141 NUMBER
1237 , p7_a142 NUMBER
1238 , p7_a143 VARCHAR2
1239 , p7_a144 VARCHAR2
1240 , p7_a145 NUMBER
1241 , p7_a146 VARCHAR2
1242 , p7_a147 VARCHAR2
1243 , x_claim_id out nocopy NUMBER
1244 )
1245
1246 as
1247 ddp_claim ozf_claim_pvt.claim_rec_type;
1248 ddindx binary_integer; indx binary_integer;
1249 begin
1250
1251 -- copy data to the local IN or IN-OUT args, if any
1252
1253
1254
1255
1256
1257
1258
1259 ddp_claim.claim_id := p7_a0;
1260 ddp_claim.object_version_number := p7_a1;
1261 ddp_claim.last_update_date := rosetta_g_miss_date_in_map(p7_a2);
1262 ddp_claim.last_updated_by := p7_a3;
1263 ddp_claim.creation_date := rosetta_g_miss_date_in_map(p7_a4);
1264 ddp_claim.created_by := p7_a5;
1265 ddp_claim.last_update_login := p7_a6;
1266 ddp_claim.request_id := p7_a7;
1267 ddp_claim.program_application_id := p7_a8;
1268 ddp_claim.program_update_date := rosetta_g_miss_date_in_map(p7_a9);
1269 ddp_claim.program_id := p7_a10;
1270 ddp_claim.created_from := p7_a11;
1271 ddp_claim.batch_id := p7_a12;
1272 ddp_claim.claim_number := p7_a13;
1273 ddp_claim.claim_type_id := p7_a14;
1274 ddp_claim.claim_class := p7_a15;
1275 ddp_claim.claim_date := rosetta_g_miss_date_in_map(p7_a16);
1276 ddp_claim.due_date := rosetta_g_miss_date_in_map(p7_a17);
1277 ddp_claim.owner_id := p7_a18;
1278 ddp_claim.history_event := p7_a19;
1279 ddp_claim.history_event_date := rosetta_g_miss_date_in_map(p7_a20);
1280 ddp_claim.history_event_description := p7_a21;
1281 ddp_claim.split_from_claim_id := p7_a22;
1282 ddp_claim.duplicate_claim_id := p7_a23;
1283 ddp_claim.split_date := rosetta_g_miss_date_in_map(p7_a24);
1284 ddp_claim.root_claim_id := p7_a25;
1285 ddp_claim.amount := p7_a26;
1286 ddp_claim.amount_adjusted := p7_a27;
1287 ddp_claim.amount_remaining := p7_a28;
1288 ddp_claim.amount_settled := p7_a29;
1289 ddp_claim.acctd_amount := p7_a30;
1290 ddp_claim.acctd_amount_remaining := p7_a31;
1291 ddp_claim.acctd_amount_adjusted := p7_a32;
1292 ddp_claim.acctd_amount_settled := p7_a33;
1293 ddp_claim.tax_amount := p7_a34;
1294 ddp_claim.tax_code := p7_a35;
1295 ddp_claim.tax_calculation_flag := p7_a36;
1296 ddp_claim.currency_code := p7_a37;
1297 ddp_claim.exchange_rate_type := p7_a38;
1298 ddp_claim.exchange_rate_date := rosetta_g_miss_date_in_map(p7_a39);
1299 ddp_claim.exchange_rate := p7_a40;
1300 ddp_claim.set_of_books_id := p7_a41;
1301 ddp_claim.original_claim_date := rosetta_g_miss_date_in_map(p7_a42);
1302 ddp_claim.source_object_id := p7_a43;
1303 ddp_claim.source_object_class := p7_a44;
1304 ddp_claim.source_object_type_id := p7_a45;
1305 ddp_claim.source_object_number := p7_a46;
1306 ddp_claim.cust_account_id := p7_a47;
1307 ddp_claim.cust_billto_acct_site_id := p7_a48;
1308 ddp_claim.cust_shipto_acct_site_id := p7_a49;
1309 ddp_claim.location_id := p7_a50;
1310 ddp_claim.pay_related_account_flag := p7_a51;
1311 ddp_claim.related_cust_account_id := p7_a52;
1312 ddp_claim.related_site_use_id := p7_a53;
1313 ddp_claim.relationship_type := p7_a54;
1314 ddp_claim.vendor_id := p7_a55;
1315 ddp_claim.vendor_site_id := p7_a56;
1316 ddp_claim.reason_type := p7_a57;
1317 ddp_claim.reason_code_id := p7_a58;
1318 ddp_claim.task_template_group_id := p7_a59;
1319 ddp_claim.status_code := p7_a60;
1320 ddp_claim.user_status_id := p7_a61;
1321 ddp_claim.sales_rep_id := p7_a62;
1322 ddp_claim.collector_id := p7_a63;
1323 ddp_claim.contact_id := p7_a64;
1324 ddp_claim.broker_id := p7_a65;
1325 ddp_claim.territory_id := p7_a66;
1326 ddp_claim.customer_ref_date := rosetta_g_miss_date_in_map(p7_a67);
1327 ddp_claim.customer_ref_number := p7_a68;
1328 ddp_claim.assigned_to := p7_a69;
1329 ddp_claim.receipt_id := p7_a70;
1330 ddp_claim.receipt_number := p7_a71;
1331 ddp_claim.doc_sequence_id := p7_a72;
1332 ddp_claim.doc_sequence_value := p7_a73;
1333 ddp_claim.gl_date := rosetta_g_miss_date_in_map(p7_a74);
1334 ddp_claim.payment_method := p7_a75;
1335 ddp_claim.voucher_id := p7_a76;
1336 ddp_claim.voucher_number := p7_a77;
1337 ddp_claim.payment_reference_id := p7_a78;
1338 ddp_claim.payment_reference_number := p7_a79;
1339 ddp_claim.payment_reference_date := rosetta_g_miss_date_in_map(p7_a80);
1340 ddp_claim.payment_status := p7_a81;
1341 ddp_claim.approved_flag := p7_a82;
1342 ddp_claim.approved_date := rosetta_g_miss_date_in_map(p7_a83);
1343 ddp_claim.approved_by := p7_a84;
1344 ddp_claim.settled_date := rosetta_g_miss_date_in_map(p7_a85);
1345 ddp_claim.settled_by := p7_a86;
1346 ddp_claim.effective_date := rosetta_g_miss_date_in_map(p7_a87);
1347 ddp_claim.custom_setup_id := p7_a88;
1348 ddp_claim.task_id := p7_a89;
1349 ddp_claim.country_id := p7_a90;
1350 ddp_claim.order_type_id := p7_a91;
1351 ddp_claim.comments := p7_a92;
1352 ddp_claim.attribute_category := p7_a93;
1353 ddp_claim.attribute1 := p7_a94;
1354 ddp_claim.attribute2 := p7_a95;
1355 ddp_claim.attribute3 := p7_a96;
1356 ddp_claim.attribute4 := p7_a97;
1357 ddp_claim.attribute5 := p7_a98;
1358 ddp_claim.attribute6 := p7_a99;
1359 ddp_claim.attribute7 := p7_a100;
1360 ddp_claim.attribute8 := p7_a101;
1361 ddp_claim.attribute9 := p7_a102;
1362 ddp_claim.attribute10 := p7_a103;
1363 ddp_claim.attribute11 := p7_a104;
1364 ddp_claim.attribute12 := p7_a105;
1365 ddp_claim.attribute13 := p7_a106;
1366 ddp_claim.attribute14 := p7_a107;
1367 ddp_claim.attribute15 := p7_a108;
1368 ddp_claim.deduction_attribute_category := p7_a109;
1369 ddp_claim.deduction_attribute1 := p7_a110;
1370 ddp_claim.deduction_attribute2 := p7_a111;
1371 ddp_claim.deduction_attribute3 := p7_a112;
1372 ddp_claim.deduction_attribute4 := p7_a113;
1373 ddp_claim.deduction_attribute5 := p7_a114;
1374 ddp_claim.deduction_attribute6 := p7_a115;
1375 ddp_claim.deduction_attribute7 := p7_a116;
1376 ddp_claim.deduction_attribute8 := p7_a117;
1377 ddp_claim.deduction_attribute9 := p7_a118;
1378 ddp_claim.deduction_attribute10 := p7_a119;
1379 ddp_claim.deduction_attribute11 := p7_a120;
1380 ddp_claim.deduction_attribute12 := p7_a121;
1381 ddp_claim.deduction_attribute13 := p7_a122;
1382 ddp_claim.deduction_attribute14 := p7_a123;
1383 ddp_claim.deduction_attribute15 := p7_a124;
1384 ddp_claim.org_id := p7_a125;
1385 ddp_claim.legal_entity_id := p7_a126;
1386 ddp_claim.write_off_flag := p7_a127;
1387 ddp_claim.write_off_threshold_amount := p7_a128;
1388 ddp_claim.under_write_off_threshold := p7_a129;
1389 ddp_claim.customer_reason := p7_a130;
1390 ddp_claim.ship_to_cust_account_id := p7_a131;
1391 ddp_claim.amount_applied := p7_a132;
1392 ddp_claim.applied_receipt_id := p7_a133;
1393 ddp_claim.applied_receipt_number := p7_a134;
1394 ddp_claim.wo_rec_trx_id := p7_a135;
1395 ddp_claim.group_claim_id := p7_a136;
1396 ddp_claim.appr_wf_item_key := p7_a137;
1397 ddp_claim.cstl_wf_item_key := p7_a138;
1398 ddp_claim.batch_type := p7_a139;
1399 ddp_claim.tax_action := p7_a140;
1400 ddp_claim.close_status_id := p7_a141;
1401 ddp_claim.open_status_id := p7_a142;
1402 ddp_claim.pre_auth_deduction_number := p7_a143;
1403 ddp_claim.pre_auth_deduction_normalized := p7_a144;
1404 ddp_claim.offer_id := p7_a145;
1405 ddp_claim.settled_from := p7_a146;
1406 ddp_claim.approval_in_prog := p7_a147;
1407
1408
1409 -- here's the delegated call to the old PL/SQL routine
1410 ozf_claim_pvt.create_claim(p_api_version,
1411 p_init_msg_list,
1412 p_commit,
1413 p_validation_level,
1414 x_return_status,
1415 x_msg_data,
1416 x_msg_count,
1417 ddp_claim,
1418 x_claim_id);
1419
1420 -- copy data back from the local variables to OUT or IN-OUT args, if any
1421
1422
1423
1424
1425
1426
1427
1428
1429 end;
1430
1431 procedure update_claim(p_api_version NUMBER
1432 , p_init_msg_list VARCHAR2
1433 , p_commit VARCHAR2
1434 , p_validation_level NUMBER
1435 , x_return_status out nocopy VARCHAR2
1436 , x_msg_data out nocopy VARCHAR2
1437 , x_msg_count out nocopy NUMBER
1438 , p7_a0 NUMBER
1439 , p7_a1 NUMBER
1440 , p7_a2 DATE
1441 , p7_a3 NUMBER
1442 , p7_a4 DATE
1443 , p7_a5 NUMBER
1444 , p7_a6 NUMBER
1445 , p7_a7 NUMBER
1446 , p7_a8 NUMBER
1447 , p7_a9 DATE
1448 , p7_a10 NUMBER
1449 , p7_a11 VARCHAR2
1450 , p7_a12 NUMBER
1451 , p7_a13 VARCHAR2
1452 , p7_a14 NUMBER
1453 , p7_a15 VARCHAR2
1454 , p7_a16 DATE
1455 , p7_a17 DATE
1456 , p7_a18 NUMBER
1457 , p7_a19 VARCHAR2
1458 , p7_a20 DATE
1459 , p7_a21 VARCHAR2
1460 , p7_a22 NUMBER
1461 , p7_a23 NUMBER
1462 , p7_a24 DATE
1463 , p7_a25 NUMBER
1464 , p7_a26 NUMBER
1465 , p7_a27 NUMBER
1466 , p7_a28 NUMBER
1467 , p7_a29 NUMBER
1468 , p7_a30 NUMBER
1469 , p7_a31 NUMBER
1470 , p7_a32 NUMBER
1471 , p7_a33 NUMBER
1472 , p7_a34 NUMBER
1473 , p7_a35 VARCHAR2
1474 , p7_a36 VARCHAR2
1475 , p7_a37 VARCHAR2
1476 , p7_a38 VARCHAR2
1477 , p7_a39 DATE
1478 , p7_a40 NUMBER
1479 , p7_a41 NUMBER
1480 , p7_a42 DATE
1481 , p7_a43 NUMBER
1482 , p7_a44 VARCHAR2
1483 , p7_a45 NUMBER
1484 , p7_a46 VARCHAR2
1485 , p7_a47 NUMBER
1486 , p7_a48 NUMBER
1487 , p7_a49 NUMBER
1488 , p7_a50 NUMBER
1489 , p7_a51 VARCHAR2
1490 , p7_a52 NUMBER
1491 , p7_a53 NUMBER
1492 , p7_a54 VARCHAR2
1493 , p7_a55 NUMBER
1494 , p7_a56 NUMBER
1495 , p7_a57 VARCHAR2
1496 , p7_a58 NUMBER
1497 , p7_a59 NUMBER
1498 , p7_a60 VARCHAR2
1499 , p7_a61 NUMBER
1500 , p7_a62 NUMBER
1501 , p7_a63 NUMBER
1502 , p7_a64 NUMBER
1503 , p7_a65 NUMBER
1504 , p7_a66 NUMBER
1505 , p7_a67 DATE
1506 , p7_a68 VARCHAR2
1507 , p7_a69 NUMBER
1508 , p7_a70 NUMBER
1509 , p7_a71 VARCHAR2
1510 , p7_a72 NUMBER
1511 , p7_a73 NUMBER
1512 , p7_a74 DATE
1513 , p7_a75 VARCHAR2
1514 , p7_a76 NUMBER
1515 , p7_a77 VARCHAR2
1516 , p7_a78 NUMBER
1517 , p7_a79 VARCHAR2
1518 , p7_a80 DATE
1519 , p7_a81 VARCHAR2
1520 , p7_a82 VARCHAR2
1521 , p7_a83 DATE
1522 , p7_a84 NUMBER
1523 , p7_a85 DATE
1524 , p7_a86 NUMBER
1525 , p7_a87 DATE
1526 , p7_a88 NUMBER
1527 , p7_a89 NUMBER
1528 , p7_a90 NUMBER
1529 , p7_a91 NUMBER
1530 , p7_a92 VARCHAR2
1531 , p7_a93 VARCHAR2
1532 , p7_a94 VARCHAR2
1533 , p7_a95 VARCHAR2
1534 , p7_a96 VARCHAR2
1535 , p7_a97 VARCHAR2
1536 , p7_a98 VARCHAR2
1537 , p7_a99 VARCHAR2
1538 , p7_a100 VARCHAR2
1539 , p7_a101 VARCHAR2
1540 , p7_a102 VARCHAR2
1541 , p7_a103 VARCHAR2
1542 , p7_a104 VARCHAR2
1543 , p7_a105 VARCHAR2
1544 , p7_a106 VARCHAR2
1545 , p7_a107 VARCHAR2
1546 , p7_a108 VARCHAR2
1547 , p7_a109 VARCHAR2
1548 , p7_a110 VARCHAR2
1549 , p7_a111 VARCHAR2
1550 , p7_a112 VARCHAR2
1551 , p7_a113 VARCHAR2
1552 , p7_a114 VARCHAR2
1553 , p7_a115 VARCHAR2
1554 , p7_a116 VARCHAR2
1555 , p7_a117 VARCHAR2
1556 , p7_a118 VARCHAR2
1557 , p7_a119 VARCHAR2
1558 , p7_a120 VARCHAR2
1559 , p7_a121 VARCHAR2
1560 , p7_a122 VARCHAR2
1561 , p7_a123 VARCHAR2
1562 , p7_a124 VARCHAR2
1563 , p7_a125 NUMBER
1564 , p7_a126 NUMBER
1565 , p7_a127 VARCHAR2
1566 , p7_a128 NUMBER
1567 , p7_a129 VARCHAR2
1568 , p7_a130 VARCHAR2
1569 , p7_a131 NUMBER
1570 , p7_a132 NUMBER
1571 , p7_a133 NUMBER
1572 , p7_a134 VARCHAR2
1573 , p7_a135 NUMBER
1574 , p7_a136 NUMBER
1575 , p7_a137 VARCHAR2
1576 , p7_a138 VARCHAR2
1577 , p7_a139 VARCHAR2
1578 , p7_a140 VARCHAR2
1579 , p7_a141 NUMBER
1580 , p7_a142 NUMBER
1581 , p7_a143 VARCHAR2
1582 , p7_a144 VARCHAR2
1583 , p7_a145 NUMBER
1584 , p7_a146 VARCHAR2
1585 , p7_a147 VARCHAR2
1586 , p_event VARCHAR2
1587 , p_mode VARCHAR2
1588 , x_object_version_number out nocopy NUMBER
1589 )
1590
1591 as
1592 ddp_claim ozf_claim_pvt.claim_rec_type;
1593 ddindx binary_integer; indx binary_integer;
1594 begin
1595
1596 -- copy data to the local IN or IN-OUT args, if any
1597
1598
1599
1600
1601
1602
1603
1604 ddp_claim.claim_id := p7_a0;
1605 ddp_claim.object_version_number := p7_a1;
1606 ddp_claim.last_update_date := rosetta_g_miss_date_in_map(p7_a2);
1607 ddp_claim.last_updated_by := p7_a3;
1608 ddp_claim.creation_date := rosetta_g_miss_date_in_map(p7_a4);
1609 ddp_claim.created_by := p7_a5;
1610 ddp_claim.last_update_login := p7_a6;
1611 ddp_claim.request_id := p7_a7;
1612 ddp_claim.program_application_id := p7_a8;
1613 ddp_claim.program_update_date := rosetta_g_miss_date_in_map(p7_a9);
1614 ddp_claim.program_id := p7_a10;
1615 ddp_claim.created_from := p7_a11;
1616 ddp_claim.batch_id := p7_a12;
1617 ddp_claim.claim_number := p7_a13;
1618 ddp_claim.claim_type_id := p7_a14;
1619 ddp_claim.claim_class := p7_a15;
1620 ddp_claim.claim_date := rosetta_g_miss_date_in_map(p7_a16);
1621 ddp_claim.due_date := rosetta_g_miss_date_in_map(p7_a17);
1622 ddp_claim.owner_id := p7_a18;
1623 ddp_claim.history_event := p7_a19;
1624 ddp_claim.history_event_date := rosetta_g_miss_date_in_map(p7_a20);
1625 ddp_claim.history_event_description := p7_a21;
1626 ddp_claim.split_from_claim_id := p7_a22;
1627 ddp_claim.duplicate_claim_id := p7_a23;
1628 ddp_claim.split_date := rosetta_g_miss_date_in_map(p7_a24);
1629 ddp_claim.root_claim_id := p7_a25;
1630 ddp_claim.amount := p7_a26;
1631 ddp_claim.amount_adjusted := p7_a27;
1632 ddp_claim.amount_remaining := p7_a28;
1633 ddp_claim.amount_settled := p7_a29;
1634 ddp_claim.acctd_amount := p7_a30;
1635 ddp_claim.acctd_amount_remaining := p7_a31;
1636 ddp_claim.acctd_amount_adjusted := p7_a32;
1637 ddp_claim.acctd_amount_settled := p7_a33;
1638 ddp_claim.tax_amount := p7_a34;
1639 ddp_claim.tax_code := p7_a35;
1640 ddp_claim.tax_calculation_flag := p7_a36;
1641 ddp_claim.currency_code := p7_a37;
1642 ddp_claim.exchange_rate_type := p7_a38;
1643 ddp_claim.exchange_rate_date := rosetta_g_miss_date_in_map(p7_a39);
1644 ddp_claim.exchange_rate := p7_a40;
1645 ddp_claim.set_of_books_id := p7_a41;
1646 ddp_claim.original_claim_date := rosetta_g_miss_date_in_map(p7_a42);
1647 ddp_claim.source_object_id := p7_a43;
1648 ddp_claim.source_object_class := p7_a44;
1649 ddp_claim.source_object_type_id := p7_a45;
1650 ddp_claim.source_object_number := p7_a46;
1651 ddp_claim.cust_account_id := p7_a47;
1652 ddp_claim.cust_billto_acct_site_id := p7_a48;
1653 ddp_claim.cust_shipto_acct_site_id := p7_a49;
1654 ddp_claim.location_id := p7_a50;
1655 ddp_claim.pay_related_account_flag := p7_a51;
1656 ddp_claim.related_cust_account_id := p7_a52;
1657 ddp_claim.related_site_use_id := p7_a53;
1658 ddp_claim.relationship_type := p7_a54;
1659 ddp_claim.vendor_id := p7_a55;
1660 ddp_claim.vendor_site_id := p7_a56;
1661 ddp_claim.reason_type := p7_a57;
1662 ddp_claim.reason_code_id := p7_a58;
1663 ddp_claim.task_template_group_id := p7_a59;
1664 ddp_claim.status_code := p7_a60;
1665 ddp_claim.user_status_id := p7_a61;
1666 ddp_claim.sales_rep_id := p7_a62;
1667 ddp_claim.collector_id := p7_a63;
1668 ddp_claim.contact_id := p7_a64;
1669 ddp_claim.broker_id := p7_a65;
1670 ddp_claim.territory_id := p7_a66;
1671 ddp_claim.customer_ref_date := rosetta_g_miss_date_in_map(p7_a67);
1672 ddp_claim.customer_ref_number := p7_a68;
1673 ddp_claim.assigned_to := p7_a69;
1674 ddp_claim.receipt_id := p7_a70;
1675 ddp_claim.receipt_number := p7_a71;
1676 ddp_claim.doc_sequence_id := p7_a72;
1677 ddp_claim.doc_sequence_value := p7_a73;
1678 ddp_claim.gl_date := rosetta_g_miss_date_in_map(p7_a74);
1679 ddp_claim.payment_method := p7_a75;
1680 ddp_claim.voucher_id := p7_a76;
1681 ddp_claim.voucher_number := p7_a77;
1682 ddp_claim.payment_reference_id := p7_a78;
1683 ddp_claim.payment_reference_number := p7_a79;
1684 ddp_claim.payment_reference_date := rosetta_g_miss_date_in_map(p7_a80);
1685 ddp_claim.payment_status := p7_a81;
1686 ddp_claim.approved_flag := p7_a82;
1687 ddp_claim.approved_date := rosetta_g_miss_date_in_map(p7_a83);
1688 ddp_claim.approved_by := p7_a84;
1689 ddp_claim.settled_date := rosetta_g_miss_date_in_map(p7_a85);
1690 ddp_claim.settled_by := p7_a86;
1691 ddp_claim.effective_date := rosetta_g_miss_date_in_map(p7_a87);
1692 ddp_claim.custom_setup_id := p7_a88;
1693 ddp_claim.task_id := p7_a89;
1694 ddp_claim.country_id := p7_a90;
1695 ddp_claim.order_type_id := p7_a91;
1696 ddp_claim.comments := p7_a92;
1697 ddp_claim.attribute_category := p7_a93;
1698 ddp_claim.attribute1 := p7_a94;
1699 ddp_claim.attribute2 := p7_a95;
1700 ddp_claim.attribute3 := p7_a96;
1701 ddp_claim.attribute4 := p7_a97;
1702 ddp_claim.attribute5 := p7_a98;
1703 ddp_claim.attribute6 := p7_a99;
1704 ddp_claim.attribute7 := p7_a100;
1705 ddp_claim.attribute8 := p7_a101;
1706 ddp_claim.attribute9 := p7_a102;
1707 ddp_claim.attribute10 := p7_a103;
1708 ddp_claim.attribute11 := p7_a104;
1709 ddp_claim.attribute12 := p7_a105;
1710 ddp_claim.attribute13 := p7_a106;
1711 ddp_claim.attribute14 := p7_a107;
1712 ddp_claim.attribute15 := p7_a108;
1713 ddp_claim.deduction_attribute_category := p7_a109;
1714 ddp_claim.deduction_attribute1 := p7_a110;
1715 ddp_claim.deduction_attribute2 := p7_a111;
1716 ddp_claim.deduction_attribute3 := p7_a112;
1717 ddp_claim.deduction_attribute4 := p7_a113;
1718 ddp_claim.deduction_attribute5 := p7_a114;
1719 ddp_claim.deduction_attribute6 := p7_a115;
1720 ddp_claim.deduction_attribute7 := p7_a116;
1721 ddp_claim.deduction_attribute8 := p7_a117;
1722 ddp_claim.deduction_attribute9 := p7_a118;
1723 ddp_claim.deduction_attribute10 := p7_a119;
1724 ddp_claim.deduction_attribute11 := p7_a120;
1725 ddp_claim.deduction_attribute12 := p7_a121;
1726 ddp_claim.deduction_attribute13 := p7_a122;
1727 ddp_claim.deduction_attribute14 := p7_a123;
1728 ddp_claim.deduction_attribute15 := p7_a124;
1729 ddp_claim.org_id := p7_a125;
1730 ddp_claim.legal_entity_id := p7_a126;
1731 ddp_claim.write_off_flag := p7_a127;
1732 ddp_claim.write_off_threshold_amount := p7_a128;
1733 ddp_claim.under_write_off_threshold := p7_a129;
1734 ddp_claim.customer_reason := p7_a130;
1735 ddp_claim.ship_to_cust_account_id := p7_a131;
1736 ddp_claim.amount_applied := p7_a132;
1737 ddp_claim.applied_receipt_id := p7_a133;
1738 ddp_claim.applied_receipt_number := p7_a134;
1739 ddp_claim.wo_rec_trx_id := p7_a135;
1740 ddp_claim.group_claim_id := p7_a136;
1741 ddp_claim.appr_wf_item_key := p7_a137;
1742 ddp_claim.cstl_wf_item_key := p7_a138;
1743 ddp_claim.batch_type := p7_a139;
1744 ddp_claim.tax_action := p7_a140;
1745 ddp_claim.close_status_id := p7_a141;
1746 ddp_claim.open_status_id := p7_a142;
1747 ddp_claim.pre_auth_deduction_number := p7_a143;
1748 ddp_claim.pre_auth_deduction_normalized := p7_a144;
1749 ddp_claim.offer_id := p7_a145;
1750 ddp_claim.settled_from := p7_a146;
1751 ddp_claim.approval_in_prog := p7_a147;
1752
1753
1754
1755
1756 -- here's the delegated call to the old PL/SQL routine
1757 ozf_claim_pvt.update_claim(p_api_version,
1758 p_init_msg_list,
1759 p_commit,
1760 p_validation_level,
1761 x_return_status,
1762 x_msg_data,
1763 x_msg_count,
1764 ddp_claim,
1765 p_event,
1766 p_mode,
1767 x_object_version_number);
1768
1769 -- copy data back from the local variables to OUT or IN-OUT args, if any
1770
1771
1772
1773
1774
1775
1776
1777
1778
1779
1780 end;
1781
1782 procedure validate_claim(p_api_version NUMBER
1783 , p_init_msg_list VARCHAR2
1784 , p_validation_level NUMBER
1785 , x_return_status out nocopy VARCHAR2
1786 , x_msg_count out nocopy NUMBER
1787 , x_msg_data out nocopy VARCHAR2
1788 , p6_a0 NUMBER
1789 , p6_a1 NUMBER
1790 , p6_a2 DATE
1791 , p6_a3 NUMBER
1792 , p6_a4 DATE
1793 , p6_a5 NUMBER
1794 , p6_a6 NUMBER
1795 , p6_a7 NUMBER
1796 , p6_a8 NUMBER
1797 , p6_a9 DATE
1798 , p6_a10 NUMBER
1799 , p6_a11 VARCHAR2
1800 , p6_a12 NUMBER
1801 , p6_a13 VARCHAR2
1802 , p6_a14 NUMBER
1803 , p6_a15 VARCHAR2
1804 , p6_a16 DATE
1805 , p6_a17 DATE
1806 , p6_a18 NUMBER
1807 , p6_a19 VARCHAR2
1808 , p6_a20 DATE
1809 , p6_a21 VARCHAR2
1810 , p6_a22 NUMBER
1811 , p6_a23 NUMBER
1812 , p6_a24 DATE
1813 , p6_a25 NUMBER
1814 , p6_a26 NUMBER
1815 , p6_a27 NUMBER
1816 , p6_a28 NUMBER
1817 , p6_a29 NUMBER
1818 , p6_a30 NUMBER
1819 , p6_a31 NUMBER
1820 , p6_a32 NUMBER
1821 , p6_a33 NUMBER
1822 , p6_a34 NUMBER
1823 , p6_a35 VARCHAR2
1824 , p6_a36 VARCHAR2
1825 , p6_a37 VARCHAR2
1826 , p6_a38 VARCHAR2
1827 , p6_a39 DATE
1828 , p6_a40 NUMBER
1829 , p6_a41 NUMBER
1830 , p6_a42 DATE
1831 , p6_a43 NUMBER
1832 , p6_a44 VARCHAR2
1833 , p6_a45 NUMBER
1834 , p6_a46 VARCHAR2
1835 , p6_a47 NUMBER
1836 , p6_a48 NUMBER
1837 , p6_a49 NUMBER
1838 , p6_a50 NUMBER
1839 , p6_a51 VARCHAR2
1840 , p6_a52 NUMBER
1841 , p6_a53 NUMBER
1842 , p6_a54 VARCHAR2
1843 , p6_a55 NUMBER
1844 , p6_a56 NUMBER
1845 , p6_a57 VARCHAR2
1846 , p6_a58 NUMBER
1847 , p6_a59 NUMBER
1848 , p6_a60 VARCHAR2
1849 , p6_a61 NUMBER
1850 , p6_a62 NUMBER
1851 , p6_a63 NUMBER
1852 , p6_a64 NUMBER
1853 , p6_a65 NUMBER
1854 , p6_a66 NUMBER
1855 , p6_a67 DATE
1856 , p6_a68 VARCHAR2
1857 , p6_a69 NUMBER
1858 , p6_a70 NUMBER
1859 , p6_a71 VARCHAR2
1860 , p6_a72 NUMBER
1861 , p6_a73 NUMBER
1862 , p6_a74 DATE
1863 , p6_a75 VARCHAR2
1864 , p6_a76 NUMBER
1865 , p6_a77 VARCHAR2
1866 , p6_a78 NUMBER
1867 , p6_a79 VARCHAR2
1868 , p6_a80 DATE
1869 , p6_a81 VARCHAR2
1870 , p6_a82 VARCHAR2
1871 , p6_a83 DATE
1872 , p6_a84 NUMBER
1873 , p6_a85 DATE
1874 , p6_a86 NUMBER
1875 , p6_a87 DATE
1876 , p6_a88 NUMBER
1877 , p6_a89 NUMBER
1878 , p6_a90 NUMBER
1879 , p6_a91 NUMBER
1880 , p6_a92 VARCHAR2
1881 , p6_a93 VARCHAR2
1882 , p6_a94 VARCHAR2
1883 , p6_a95 VARCHAR2
1884 , p6_a96 VARCHAR2
1885 , p6_a97 VARCHAR2
1886 , p6_a98 VARCHAR2
1887 , p6_a99 VARCHAR2
1888 , p6_a100 VARCHAR2
1889 , p6_a101 VARCHAR2
1890 , p6_a102 VARCHAR2
1891 , p6_a103 VARCHAR2
1892 , p6_a104 VARCHAR2
1893 , p6_a105 VARCHAR2
1894 , p6_a106 VARCHAR2
1895 , p6_a107 VARCHAR2
1896 , p6_a108 VARCHAR2
1897 , p6_a109 VARCHAR2
1898 , p6_a110 VARCHAR2
1899 , p6_a111 VARCHAR2
1900 , p6_a112 VARCHAR2
1901 , p6_a113 VARCHAR2
1902 , p6_a114 VARCHAR2
1903 , p6_a115 VARCHAR2
1904 , p6_a116 VARCHAR2
1905 , p6_a117 VARCHAR2
1906 , p6_a118 VARCHAR2
1907 , p6_a119 VARCHAR2
1908 , p6_a120 VARCHAR2
1909 , p6_a121 VARCHAR2
1910 , p6_a122 VARCHAR2
1911 , p6_a123 VARCHAR2
1912 , p6_a124 VARCHAR2
1913 , p6_a125 NUMBER
1914 , p6_a126 NUMBER
1915 , p6_a127 VARCHAR2
1916 , p6_a128 NUMBER
1917 , p6_a129 VARCHAR2
1918 , p6_a130 VARCHAR2
1919 , p6_a131 NUMBER
1920 , p6_a132 NUMBER
1921 , p6_a133 NUMBER
1922 , p6_a134 VARCHAR2
1923 , p6_a135 NUMBER
1924 , p6_a136 NUMBER
1925 , p6_a137 VARCHAR2
1926 , p6_a138 VARCHAR2
1927 , p6_a139 VARCHAR2
1928 , p6_a140 VARCHAR2
1929 , p6_a141 NUMBER
1930 , p6_a142 NUMBER
1931 , p6_a143 VARCHAR2
1932 , p6_a144 VARCHAR2
1933 , p6_a145 NUMBER
1934 , p6_a146 VARCHAR2
1935 , p6_a147 VARCHAR2
1936 )
1937
1938 as
1939 ddp_claim ozf_claim_pvt.claim_rec_type;
1940 ddindx binary_integer; indx binary_integer;
1941 begin
1942
1943 -- copy data to the local IN or IN-OUT args, if any
1944
1945
1946
1947
1948
1949
1950 ddp_claim.claim_id := p6_a0;
1951 ddp_claim.object_version_number := p6_a1;
1952 ddp_claim.last_update_date := rosetta_g_miss_date_in_map(p6_a2);
1953 ddp_claim.last_updated_by := p6_a3;
1954 ddp_claim.creation_date := rosetta_g_miss_date_in_map(p6_a4);
1955 ddp_claim.created_by := p6_a5;
1956 ddp_claim.last_update_login := p6_a6;
1957 ddp_claim.request_id := p6_a7;
1958 ddp_claim.program_application_id := p6_a8;
1959 ddp_claim.program_update_date := rosetta_g_miss_date_in_map(p6_a9);
1960 ddp_claim.program_id := p6_a10;
1961 ddp_claim.created_from := p6_a11;
1962 ddp_claim.batch_id := p6_a12;
1963 ddp_claim.claim_number := p6_a13;
1964 ddp_claim.claim_type_id := p6_a14;
1965 ddp_claim.claim_class := p6_a15;
1966 ddp_claim.claim_date := rosetta_g_miss_date_in_map(p6_a16);
1967 ddp_claim.due_date := rosetta_g_miss_date_in_map(p6_a17);
1968 ddp_claim.owner_id := p6_a18;
1969 ddp_claim.history_event := p6_a19;
1970 ddp_claim.history_event_date := rosetta_g_miss_date_in_map(p6_a20);
1971 ddp_claim.history_event_description := p6_a21;
1972 ddp_claim.split_from_claim_id := p6_a22;
1973 ddp_claim.duplicate_claim_id := p6_a23;
1974 ddp_claim.split_date := rosetta_g_miss_date_in_map(p6_a24);
1975 ddp_claim.root_claim_id := p6_a25;
1976 ddp_claim.amount := p6_a26;
1977 ddp_claim.amount_adjusted := p6_a27;
1978 ddp_claim.amount_remaining := p6_a28;
1979 ddp_claim.amount_settled := p6_a29;
1980 ddp_claim.acctd_amount := p6_a30;
1981 ddp_claim.acctd_amount_remaining := p6_a31;
1982 ddp_claim.acctd_amount_adjusted := p6_a32;
1983 ddp_claim.acctd_amount_settled := p6_a33;
1984 ddp_claim.tax_amount := p6_a34;
1985 ddp_claim.tax_code := p6_a35;
1986 ddp_claim.tax_calculation_flag := p6_a36;
1987 ddp_claim.currency_code := p6_a37;
1988 ddp_claim.exchange_rate_type := p6_a38;
1989 ddp_claim.exchange_rate_date := rosetta_g_miss_date_in_map(p6_a39);
1990 ddp_claim.exchange_rate := p6_a40;
1991 ddp_claim.set_of_books_id := p6_a41;
1992 ddp_claim.original_claim_date := rosetta_g_miss_date_in_map(p6_a42);
1993 ddp_claim.source_object_id := p6_a43;
1994 ddp_claim.source_object_class := p6_a44;
1995 ddp_claim.source_object_type_id := p6_a45;
1996 ddp_claim.source_object_number := p6_a46;
1997 ddp_claim.cust_account_id := p6_a47;
1998 ddp_claim.cust_billto_acct_site_id := p6_a48;
1999 ddp_claim.cust_shipto_acct_site_id := p6_a49;
2000 ddp_claim.location_id := p6_a50;
2001 ddp_claim.pay_related_account_flag := p6_a51;
2002 ddp_claim.related_cust_account_id := p6_a52;
2003 ddp_claim.related_site_use_id := p6_a53;
2004 ddp_claim.relationship_type := p6_a54;
2005 ddp_claim.vendor_id := p6_a55;
2006 ddp_claim.vendor_site_id := p6_a56;
2007 ddp_claim.reason_type := p6_a57;
2008 ddp_claim.reason_code_id := p6_a58;
2009 ddp_claim.task_template_group_id := p6_a59;
2010 ddp_claim.status_code := p6_a60;
2011 ddp_claim.user_status_id := p6_a61;
2012 ddp_claim.sales_rep_id := p6_a62;
2013 ddp_claim.collector_id := p6_a63;
2014 ddp_claim.contact_id := p6_a64;
2015 ddp_claim.broker_id := p6_a65;
2016 ddp_claim.territory_id := p6_a66;
2017 ddp_claim.customer_ref_date := rosetta_g_miss_date_in_map(p6_a67);
2018 ddp_claim.customer_ref_number := p6_a68;
2019 ddp_claim.assigned_to := p6_a69;
2020 ddp_claim.receipt_id := p6_a70;
2021 ddp_claim.receipt_number := p6_a71;
2022 ddp_claim.doc_sequence_id := p6_a72;
2023 ddp_claim.doc_sequence_value := p6_a73;
2024 ddp_claim.gl_date := rosetta_g_miss_date_in_map(p6_a74);
2025 ddp_claim.payment_method := p6_a75;
2026 ddp_claim.voucher_id := p6_a76;
2027 ddp_claim.voucher_number := p6_a77;
2028 ddp_claim.payment_reference_id := p6_a78;
2029 ddp_claim.payment_reference_number := p6_a79;
2030 ddp_claim.payment_reference_date := rosetta_g_miss_date_in_map(p6_a80);
2031 ddp_claim.payment_status := p6_a81;
2032 ddp_claim.approved_flag := p6_a82;
2033 ddp_claim.approved_date := rosetta_g_miss_date_in_map(p6_a83);
2034 ddp_claim.approved_by := p6_a84;
2035 ddp_claim.settled_date := rosetta_g_miss_date_in_map(p6_a85);
2036 ddp_claim.settled_by := p6_a86;
2037 ddp_claim.effective_date := rosetta_g_miss_date_in_map(p6_a87);
2038 ddp_claim.custom_setup_id := p6_a88;
2039 ddp_claim.task_id := p6_a89;
2040 ddp_claim.country_id := p6_a90;
2041 ddp_claim.order_type_id := p6_a91;
2042 ddp_claim.comments := p6_a92;
2043 ddp_claim.attribute_category := p6_a93;
2044 ddp_claim.attribute1 := p6_a94;
2045 ddp_claim.attribute2 := p6_a95;
2046 ddp_claim.attribute3 := p6_a96;
2047 ddp_claim.attribute4 := p6_a97;
2048 ddp_claim.attribute5 := p6_a98;
2049 ddp_claim.attribute6 := p6_a99;
2050 ddp_claim.attribute7 := p6_a100;
2051 ddp_claim.attribute8 := p6_a101;
2052 ddp_claim.attribute9 := p6_a102;
2053 ddp_claim.attribute10 := p6_a103;
2054 ddp_claim.attribute11 := p6_a104;
2055 ddp_claim.attribute12 := p6_a105;
2056 ddp_claim.attribute13 := p6_a106;
2057 ddp_claim.attribute14 := p6_a107;
2058 ddp_claim.attribute15 := p6_a108;
2059 ddp_claim.deduction_attribute_category := p6_a109;
2060 ddp_claim.deduction_attribute1 := p6_a110;
2061 ddp_claim.deduction_attribute2 := p6_a111;
2062 ddp_claim.deduction_attribute3 := p6_a112;
2063 ddp_claim.deduction_attribute4 := p6_a113;
2064 ddp_claim.deduction_attribute5 := p6_a114;
2065 ddp_claim.deduction_attribute6 := p6_a115;
2066 ddp_claim.deduction_attribute7 := p6_a116;
2067 ddp_claim.deduction_attribute8 := p6_a117;
2068 ddp_claim.deduction_attribute9 := p6_a118;
2069 ddp_claim.deduction_attribute10 := p6_a119;
2070 ddp_claim.deduction_attribute11 := p6_a120;
2071 ddp_claim.deduction_attribute12 := p6_a121;
2072 ddp_claim.deduction_attribute13 := p6_a122;
2073 ddp_claim.deduction_attribute14 := p6_a123;
2074 ddp_claim.deduction_attribute15 := p6_a124;
2075 ddp_claim.org_id := p6_a125;
2076 ddp_claim.legal_entity_id := p6_a126;
2077 ddp_claim.write_off_flag := p6_a127;
2078 ddp_claim.write_off_threshold_amount := p6_a128;
2079 ddp_claim.under_write_off_threshold := p6_a129;
2080 ddp_claim.customer_reason := p6_a130;
2081 ddp_claim.ship_to_cust_account_id := p6_a131;
2082 ddp_claim.amount_applied := p6_a132;
2083 ddp_claim.applied_receipt_id := p6_a133;
2084 ddp_claim.applied_receipt_number := p6_a134;
2085 ddp_claim.wo_rec_trx_id := p6_a135;
2086 ddp_claim.group_claim_id := p6_a136;
2087 ddp_claim.appr_wf_item_key := p6_a137;
2088 ddp_claim.cstl_wf_item_key := p6_a138;
2089 ddp_claim.batch_type := p6_a139;
2090 ddp_claim.tax_action := p6_a140;
2091 ddp_claim.close_status_id := p6_a141;
2092 ddp_claim.open_status_id := p6_a142;
2093 ddp_claim.pre_auth_deduction_number := p6_a143;
2094 ddp_claim.pre_auth_deduction_normalized := p6_a144;
2095 ddp_claim.offer_id := p6_a145;
2096 ddp_claim.settled_from := p6_a146;
2097 ddp_claim.approval_in_prog := p6_a147;
2098
2099 -- here's the delegated call to the old PL/SQL routine
2100 ozf_claim_pvt.validate_claim(p_api_version,
2101 p_init_msg_list,
2102 p_validation_level,
2103 x_return_status,
2104 x_msg_count,
2105 x_msg_data,
2106 ddp_claim);
2107
2108 -- copy data back from the local variables to OUT or IN-OUT args, if any
2109
2110
2111
2112
2113
2114
2115 end;
2116
2117 procedure check_claim_common_element(p_api_version NUMBER
2118 , p_init_msg_list VARCHAR2
2119 , p_validation_level NUMBER
2120 , x_return_status out nocopy VARCHAR2
2121 , x_msg_count out nocopy NUMBER
2122 , x_msg_data out nocopy VARCHAR2
2123 , p6_a0 NUMBER
2124 , p6_a1 NUMBER
2125 , p6_a2 DATE
2126 , p6_a3 NUMBER
2127 , p6_a4 DATE
2128 , p6_a5 NUMBER
2129 , p6_a6 NUMBER
2130 , p6_a7 NUMBER
2131 , p6_a8 NUMBER
2132 , p6_a9 DATE
2133 , p6_a10 NUMBER
2134 , p6_a11 VARCHAR2
2135 , p6_a12 NUMBER
2136 , p6_a13 VARCHAR2
2137 , p6_a14 NUMBER
2138 , p6_a15 VARCHAR2
2139 , p6_a16 DATE
2140 , p6_a17 DATE
2141 , p6_a18 NUMBER
2142 , p6_a19 VARCHAR2
2143 , p6_a20 DATE
2144 , p6_a21 VARCHAR2
2145 , p6_a22 NUMBER
2146 , p6_a23 NUMBER
2147 , p6_a24 DATE
2148 , p6_a25 NUMBER
2149 , p6_a26 NUMBER
2150 , p6_a27 NUMBER
2151 , p6_a28 NUMBER
2152 , p6_a29 NUMBER
2153 , p6_a30 NUMBER
2154 , p6_a31 NUMBER
2155 , p6_a32 NUMBER
2156 , p6_a33 NUMBER
2157 , p6_a34 NUMBER
2158 , p6_a35 VARCHAR2
2159 , p6_a36 VARCHAR2
2160 , p6_a37 VARCHAR2
2161 , p6_a38 VARCHAR2
2162 , p6_a39 DATE
2163 , p6_a40 NUMBER
2164 , p6_a41 NUMBER
2165 , p6_a42 DATE
2166 , p6_a43 NUMBER
2167 , p6_a44 VARCHAR2
2168 , p6_a45 NUMBER
2169 , p6_a46 VARCHAR2
2170 , p6_a47 NUMBER
2171 , p6_a48 NUMBER
2172 , p6_a49 NUMBER
2173 , p6_a50 NUMBER
2174 , p6_a51 VARCHAR2
2175 , p6_a52 NUMBER
2176 , p6_a53 NUMBER
2177 , p6_a54 VARCHAR2
2178 , p6_a55 NUMBER
2179 , p6_a56 NUMBER
2180 , p6_a57 VARCHAR2
2181 , p6_a58 NUMBER
2182 , p6_a59 NUMBER
2183 , p6_a60 VARCHAR2
2184 , p6_a61 NUMBER
2185 , p6_a62 NUMBER
2186 , p6_a63 NUMBER
2187 , p6_a64 NUMBER
2188 , p6_a65 NUMBER
2189 , p6_a66 NUMBER
2190 , p6_a67 DATE
2191 , p6_a68 VARCHAR2
2192 , p6_a69 NUMBER
2193 , p6_a70 NUMBER
2194 , p6_a71 VARCHAR2
2195 , p6_a72 NUMBER
2196 , p6_a73 NUMBER
2197 , p6_a74 DATE
2198 , p6_a75 VARCHAR2
2199 , p6_a76 NUMBER
2200 , p6_a77 VARCHAR2
2201 , p6_a78 NUMBER
2202 , p6_a79 VARCHAR2
2203 , p6_a80 DATE
2204 , p6_a81 VARCHAR2
2205 , p6_a82 VARCHAR2
2206 , p6_a83 DATE
2207 , p6_a84 NUMBER
2208 , p6_a85 DATE
2209 , p6_a86 NUMBER
2210 , p6_a87 DATE
2211 , p6_a88 NUMBER
2212 , p6_a89 NUMBER
2213 , p6_a90 NUMBER
2214 , p6_a91 NUMBER
2215 , p6_a92 VARCHAR2
2216 , p6_a93 VARCHAR2
2217 , p6_a94 VARCHAR2
2218 , p6_a95 VARCHAR2
2219 , p6_a96 VARCHAR2
2220 , p6_a97 VARCHAR2
2221 , p6_a98 VARCHAR2
2222 , p6_a99 VARCHAR2
2223 , p6_a100 VARCHAR2
2224 , p6_a101 VARCHAR2
2225 , p6_a102 VARCHAR2
2226 , p6_a103 VARCHAR2
2227 , p6_a104 VARCHAR2
2228 , p6_a105 VARCHAR2
2229 , p6_a106 VARCHAR2
2230 , p6_a107 VARCHAR2
2231 , p6_a108 VARCHAR2
2232 , p6_a109 VARCHAR2
2233 , p6_a110 VARCHAR2
2234 , p6_a111 VARCHAR2
2235 , p6_a112 VARCHAR2
2236 , p6_a113 VARCHAR2
2237 , p6_a114 VARCHAR2
2238 , p6_a115 VARCHAR2
2239 , p6_a116 VARCHAR2
2240 , p6_a117 VARCHAR2
2241 , p6_a118 VARCHAR2
2242 , p6_a119 VARCHAR2
2243 , p6_a120 VARCHAR2
2244 , p6_a121 VARCHAR2
2245 , p6_a122 VARCHAR2
2246 , p6_a123 VARCHAR2
2247 , p6_a124 VARCHAR2
2248 , p6_a125 NUMBER
2249 , p6_a126 NUMBER
2250 , p6_a127 VARCHAR2
2251 , p6_a128 NUMBER
2252 , p6_a129 VARCHAR2
2253 , p6_a130 VARCHAR2
2254 , p6_a131 NUMBER
2255 , p6_a132 NUMBER
2256 , p6_a133 NUMBER
2257 , p6_a134 VARCHAR2
2258 , p6_a135 NUMBER
2259 , p6_a136 NUMBER
2260 , p6_a137 VARCHAR2
2261 , p6_a138 VARCHAR2
2262 , p6_a139 VARCHAR2
2263 , p6_a140 VARCHAR2
2264 , p6_a141 NUMBER
2265 , p6_a142 NUMBER
2266 , p6_a143 VARCHAR2
2267 , p6_a144 VARCHAR2
2268 , p6_a145 NUMBER
2269 , p6_a146 VARCHAR2
2270 , p6_a147 VARCHAR2
2271 , p7_a0 out nocopy NUMBER
2272 , p7_a1 out nocopy NUMBER
2273 , p7_a2 out nocopy DATE
2274 , p7_a3 out nocopy NUMBER
2275 , p7_a4 out nocopy DATE
2276 , p7_a5 out nocopy NUMBER
2277 , p7_a6 out nocopy NUMBER
2278 , p7_a7 out nocopy NUMBER
2279 , p7_a8 out nocopy NUMBER
2280 , p7_a9 out nocopy DATE
2281 , p7_a10 out nocopy NUMBER
2282 , p7_a11 out nocopy VARCHAR2
2283 , p7_a12 out nocopy NUMBER
2284 , p7_a13 out nocopy VARCHAR2
2285 , p7_a14 out nocopy NUMBER
2286 , p7_a15 out nocopy VARCHAR2
2287 , p7_a16 out nocopy DATE
2288 , p7_a17 out nocopy DATE
2289 , p7_a18 out nocopy NUMBER
2290 , p7_a19 out nocopy VARCHAR2
2291 , p7_a20 out nocopy DATE
2292 , p7_a21 out nocopy VARCHAR2
2293 , p7_a22 out nocopy NUMBER
2294 , p7_a23 out nocopy NUMBER
2295 , p7_a24 out nocopy DATE
2296 , p7_a25 out nocopy NUMBER
2297 , p7_a26 out nocopy NUMBER
2298 , p7_a27 out nocopy NUMBER
2299 , p7_a28 out nocopy NUMBER
2300 , p7_a29 out nocopy NUMBER
2301 , p7_a30 out nocopy NUMBER
2302 , p7_a31 out nocopy NUMBER
2303 , p7_a32 out nocopy NUMBER
2304 , p7_a33 out nocopy NUMBER
2305 , p7_a34 out nocopy NUMBER
2306 , p7_a35 out nocopy VARCHAR2
2307 , p7_a36 out nocopy VARCHAR2
2308 , p7_a37 out nocopy VARCHAR2
2309 , p7_a38 out nocopy VARCHAR2
2310 , p7_a39 out nocopy DATE
2311 , p7_a40 out nocopy NUMBER
2312 , p7_a41 out nocopy NUMBER
2313 , p7_a42 out nocopy DATE
2314 , p7_a43 out nocopy NUMBER
2315 , p7_a44 out nocopy VARCHAR2
2316 , p7_a45 out nocopy NUMBER
2317 , p7_a46 out nocopy VARCHAR2
2318 , p7_a47 out nocopy NUMBER
2319 , p7_a48 out nocopy NUMBER
2320 , p7_a49 out nocopy NUMBER
2321 , p7_a50 out nocopy NUMBER
2322 , p7_a51 out nocopy VARCHAR2
2323 , p7_a52 out nocopy NUMBER
2324 , p7_a53 out nocopy NUMBER
2325 , p7_a54 out nocopy VARCHAR2
2326 , p7_a55 out nocopy NUMBER
2327 , p7_a56 out nocopy NUMBER
2328 , p7_a57 out nocopy VARCHAR2
2329 , p7_a58 out nocopy NUMBER
2330 , p7_a59 out nocopy NUMBER
2331 , p7_a60 out nocopy VARCHAR2
2332 , p7_a61 out nocopy NUMBER
2333 , p7_a62 out nocopy NUMBER
2334 , p7_a63 out nocopy NUMBER
2335 , p7_a64 out nocopy NUMBER
2336 , p7_a65 out nocopy NUMBER
2337 , p7_a66 out nocopy NUMBER
2338 , p7_a67 out nocopy DATE
2339 , p7_a68 out nocopy VARCHAR2
2340 , p7_a69 out nocopy NUMBER
2341 , p7_a70 out nocopy NUMBER
2342 , p7_a71 out nocopy VARCHAR2
2343 , p7_a72 out nocopy NUMBER
2344 , p7_a73 out nocopy NUMBER
2345 , p7_a74 out nocopy DATE
2346 , p7_a75 out nocopy VARCHAR2
2347 , p7_a76 out nocopy NUMBER
2348 , p7_a77 out nocopy VARCHAR2
2349 , p7_a78 out nocopy NUMBER
2350 , p7_a79 out nocopy VARCHAR2
2351 , p7_a80 out nocopy DATE
2352 , p7_a81 out nocopy VARCHAR2
2353 , p7_a82 out nocopy VARCHAR2
2354 , p7_a83 out nocopy DATE
2355 , p7_a84 out nocopy NUMBER
2356 , p7_a85 out nocopy DATE
2357 , p7_a86 out nocopy NUMBER
2358 , p7_a87 out nocopy DATE
2359 , p7_a88 out nocopy NUMBER
2360 , p7_a89 out nocopy NUMBER
2361 , p7_a90 out nocopy NUMBER
2362 , p7_a91 out nocopy NUMBER
2363 , p7_a92 out nocopy VARCHAR2
2364 , p7_a93 out nocopy VARCHAR2
2365 , p7_a94 out nocopy VARCHAR2
2366 , p7_a95 out nocopy VARCHAR2
2367 , p7_a96 out nocopy VARCHAR2
2368 , p7_a97 out nocopy VARCHAR2
2369 , p7_a98 out nocopy VARCHAR2
2370 , p7_a99 out nocopy VARCHAR2
2371 , p7_a100 out nocopy VARCHAR2
2372 , p7_a101 out nocopy VARCHAR2
2373 , p7_a102 out nocopy VARCHAR2
2374 , p7_a103 out nocopy VARCHAR2
2375 , p7_a104 out nocopy VARCHAR2
2376 , p7_a105 out nocopy VARCHAR2
2377 , p7_a106 out nocopy VARCHAR2
2378 , p7_a107 out nocopy VARCHAR2
2379 , p7_a108 out nocopy VARCHAR2
2380 , p7_a109 out nocopy VARCHAR2
2381 , p7_a110 out nocopy VARCHAR2
2382 , p7_a111 out nocopy VARCHAR2
2383 , p7_a112 out nocopy VARCHAR2
2384 , p7_a113 out nocopy VARCHAR2
2385 , p7_a114 out nocopy VARCHAR2
2386 , p7_a115 out nocopy VARCHAR2
2387 , p7_a116 out nocopy VARCHAR2
2388 , p7_a117 out nocopy VARCHAR2
2389 , p7_a118 out nocopy VARCHAR2
2390 , p7_a119 out nocopy VARCHAR2
2391 , p7_a120 out nocopy VARCHAR2
2392 , p7_a121 out nocopy VARCHAR2
2393 , p7_a122 out nocopy VARCHAR2
2394 , p7_a123 out nocopy VARCHAR2
2395 , p7_a124 out nocopy VARCHAR2
2396 , p7_a125 out nocopy NUMBER
2397 , p7_a126 out nocopy NUMBER
2398 , p7_a127 out nocopy VARCHAR2
2399 , p7_a128 out nocopy NUMBER
2400 , p7_a129 out nocopy VARCHAR2
2401 , p7_a130 out nocopy VARCHAR2
2402 , p7_a131 out nocopy NUMBER
2403 , p7_a132 out nocopy NUMBER
2404 , p7_a133 out nocopy NUMBER
2405 , p7_a134 out nocopy VARCHAR2
2406 , p7_a135 out nocopy NUMBER
2407 , p7_a136 out nocopy NUMBER
2408 , p7_a137 out nocopy VARCHAR2
2409 , p7_a138 out nocopy VARCHAR2
2410 , p7_a139 out nocopy VARCHAR2
2411 , p7_a140 out nocopy VARCHAR2
2412 , p7_a141 out nocopy NUMBER
2413 , p7_a142 out nocopy NUMBER
2414 , p7_a143 out nocopy VARCHAR2
2415 , p7_a144 out nocopy VARCHAR2
2416 , p7_a145 out nocopy NUMBER
2417 , p7_a146 out nocopy VARCHAR2
2418 , p7_a147 out nocopy VARCHAR2
2419 , p_mode VARCHAR2
2420 )
2421
2422 as
2423 ddp_claim ozf_claim_pvt.claim_rec_type;
2424 ddx_claim ozf_claim_pvt.claim_rec_type;
2425 ddindx binary_integer; indx binary_integer;
2426 begin
2427
2428 -- copy data to the local IN or IN-OUT args, if any
2429
2430
2431
2432
2433
2434
2435 ddp_claim.claim_id := p6_a0;
2436 ddp_claim.object_version_number := p6_a1;
2437 ddp_claim.last_update_date := rosetta_g_miss_date_in_map(p6_a2);
2438 ddp_claim.last_updated_by := p6_a3;
2439 ddp_claim.creation_date := rosetta_g_miss_date_in_map(p6_a4);
2440 ddp_claim.created_by := p6_a5;
2441 ddp_claim.last_update_login := p6_a6;
2442 ddp_claim.request_id := p6_a7;
2443 ddp_claim.program_application_id := p6_a8;
2444 ddp_claim.program_update_date := rosetta_g_miss_date_in_map(p6_a9);
2445 ddp_claim.program_id := p6_a10;
2446 ddp_claim.created_from := p6_a11;
2447 ddp_claim.batch_id := p6_a12;
2448 ddp_claim.claim_number := p6_a13;
2449 ddp_claim.claim_type_id := p6_a14;
2450 ddp_claim.claim_class := p6_a15;
2451 ddp_claim.claim_date := rosetta_g_miss_date_in_map(p6_a16);
2452 ddp_claim.due_date := rosetta_g_miss_date_in_map(p6_a17);
2453 ddp_claim.owner_id := p6_a18;
2454 ddp_claim.history_event := p6_a19;
2455 ddp_claim.history_event_date := rosetta_g_miss_date_in_map(p6_a20);
2456 ddp_claim.history_event_description := p6_a21;
2457 ddp_claim.split_from_claim_id := p6_a22;
2458 ddp_claim.duplicate_claim_id := p6_a23;
2459 ddp_claim.split_date := rosetta_g_miss_date_in_map(p6_a24);
2460 ddp_claim.root_claim_id := p6_a25;
2461 ddp_claim.amount := p6_a26;
2462 ddp_claim.amount_adjusted := p6_a27;
2463 ddp_claim.amount_remaining := p6_a28;
2464 ddp_claim.amount_settled := p6_a29;
2465 ddp_claim.acctd_amount := p6_a30;
2466 ddp_claim.acctd_amount_remaining := p6_a31;
2467 ddp_claim.acctd_amount_adjusted := p6_a32;
2468 ddp_claim.acctd_amount_settled := p6_a33;
2469 ddp_claim.tax_amount := p6_a34;
2470 ddp_claim.tax_code := p6_a35;
2471 ddp_claim.tax_calculation_flag := p6_a36;
2472 ddp_claim.currency_code := p6_a37;
2473 ddp_claim.exchange_rate_type := p6_a38;
2474 ddp_claim.exchange_rate_date := rosetta_g_miss_date_in_map(p6_a39);
2475 ddp_claim.exchange_rate := p6_a40;
2476 ddp_claim.set_of_books_id := p6_a41;
2477 ddp_claim.original_claim_date := rosetta_g_miss_date_in_map(p6_a42);
2478 ddp_claim.source_object_id := p6_a43;
2479 ddp_claim.source_object_class := p6_a44;
2480 ddp_claim.source_object_type_id := p6_a45;
2481 ddp_claim.source_object_number := p6_a46;
2482 ddp_claim.cust_account_id := p6_a47;
2483 ddp_claim.cust_billto_acct_site_id := p6_a48;
2484 ddp_claim.cust_shipto_acct_site_id := p6_a49;
2485 ddp_claim.location_id := p6_a50;
2486 ddp_claim.pay_related_account_flag := p6_a51;
2487 ddp_claim.related_cust_account_id := p6_a52;
2488 ddp_claim.related_site_use_id := p6_a53;
2489 ddp_claim.relationship_type := p6_a54;
2490 ddp_claim.vendor_id := p6_a55;
2491 ddp_claim.vendor_site_id := p6_a56;
2492 ddp_claim.reason_type := p6_a57;
2493 ddp_claim.reason_code_id := p6_a58;
2494 ddp_claim.task_template_group_id := p6_a59;
2495 ddp_claim.status_code := p6_a60;
2496 ddp_claim.user_status_id := p6_a61;
2497 ddp_claim.sales_rep_id := p6_a62;
2498 ddp_claim.collector_id := p6_a63;
2499 ddp_claim.contact_id := p6_a64;
2500 ddp_claim.broker_id := p6_a65;
2501 ddp_claim.territory_id := p6_a66;
2502 ddp_claim.customer_ref_date := rosetta_g_miss_date_in_map(p6_a67);
2503 ddp_claim.customer_ref_number := p6_a68;
2504 ddp_claim.assigned_to := p6_a69;
2505 ddp_claim.receipt_id := p6_a70;
2506 ddp_claim.receipt_number := p6_a71;
2507 ddp_claim.doc_sequence_id := p6_a72;
2508 ddp_claim.doc_sequence_value := p6_a73;
2509 ddp_claim.gl_date := rosetta_g_miss_date_in_map(p6_a74);
2510 ddp_claim.payment_method := p6_a75;
2511 ddp_claim.voucher_id := p6_a76;
2512 ddp_claim.voucher_number := p6_a77;
2513 ddp_claim.payment_reference_id := p6_a78;
2514 ddp_claim.payment_reference_number := p6_a79;
2515 ddp_claim.payment_reference_date := rosetta_g_miss_date_in_map(p6_a80);
2516 ddp_claim.payment_status := p6_a81;
2517 ddp_claim.approved_flag := p6_a82;
2518 ddp_claim.approved_date := rosetta_g_miss_date_in_map(p6_a83);
2519 ddp_claim.approved_by := p6_a84;
2520 ddp_claim.settled_date := rosetta_g_miss_date_in_map(p6_a85);
2521 ddp_claim.settled_by := p6_a86;
2522 ddp_claim.effective_date := rosetta_g_miss_date_in_map(p6_a87);
2523 ddp_claim.custom_setup_id := p6_a88;
2524 ddp_claim.task_id := p6_a89;
2525 ddp_claim.country_id := p6_a90;
2526 ddp_claim.order_type_id := p6_a91;
2527 ddp_claim.comments := p6_a92;
2528 ddp_claim.attribute_category := p6_a93;
2529 ddp_claim.attribute1 := p6_a94;
2530 ddp_claim.attribute2 := p6_a95;
2531 ddp_claim.attribute3 := p6_a96;
2532 ddp_claim.attribute4 := p6_a97;
2533 ddp_claim.attribute5 := p6_a98;
2534 ddp_claim.attribute6 := p6_a99;
2535 ddp_claim.attribute7 := p6_a100;
2536 ddp_claim.attribute8 := p6_a101;
2537 ddp_claim.attribute9 := p6_a102;
2538 ddp_claim.attribute10 := p6_a103;
2539 ddp_claim.attribute11 := p6_a104;
2540 ddp_claim.attribute12 := p6_a105;
2541 ddp_claim.attribute13 := p6_a106;
2542 ddp_claim.attribute14 := p6_a107;
2543 ddp_claim.attribute15 := p6_a108;
2544 ddp_claim.deduction_attribute_category := p6_a109;
2545 ddp_claim.deduction_attribute1 := p6_a110;
2546 ddp_claim.deduction_attribute2 := p6_a111;
2547 ddp_claim.deduction_attribute3 := p6_a112;
2548 ddp_claim.deduction_attribute4 := p6_a113;
2549 ddp_claim.deduction_attribute5 := p6_a114;
2550 ddp_claim.deduction_attribute6 := p6_a115;
2551 ddp_claim.deduction_attribute7 := p6_a116;
2552 ddp_claim.deduction_attribute8 := p6_a117;
2553 ddp_claim.deduction_attribute9 := p6_a118;
2554 ddp_claim.deduction_attribute10 := p6_a119;
2555 ddp_claim.deduction_attribute11 := p6_a120;
2556 ddp_claim.deduction_attribute12 := p6_a121;
2557 ddp_claim.deduction_attribute13 := p6_a122;
2558 ddp_claim.deduction_attribute14 := p6_a123;
2559 ddp_claim.deduction_attribute15 := p6_a124;
2560 ddp_claim.org_id := p6_a125;
2561 ddp_claim.legal_entity_id := p6_a126;
2562 ddp_claim.write_off_flag := p6_a127;
2563 ddp_claim.write_off_threshold_amount := p6_a128;
2564 ddp_claim.under_write_off_threshold := p6_a129;
2565 ddp_claim.customer_reason := p6_a130;
2566 ddp_claim.ship_to_cust_account_id := p6_a131;
2567 ddp_claim.amount_applied := p6_a132;
2568 ddp_claim.applied_receipt_id := p6_a133;
2569 ddp_claim.applied_receipt_number := p6_a134;
2570 ddp_claim.wo_rec_trx_id := p6_a135;
2571 ddp_claim.group_claim_id := p6_a136;
2572 ddp_claim.appr_wf_item_key := p6_a137;
2573 ddp_claim.cstl_wf_item_key := p6_a138;
2574 ddp_claim.batch_type := p6_a139;
2575 ddp_claim.tax_action := p6_a140;
2576 ddp_claim.close_status_id := p6_a141;
2577 ddp_claim.open_status_id := p6_a142;
2578 ddp_claim.pre_auth_deduction_number := p6_a143;
2579 ddp_claim.pre_auth_deduction_normalized := p6_a144;
2580 ddp_claim.offer_id := p6_a145;
2581 ddp_claim.settled_from := p6_a146;
2582 ddp_claim.approval_in_prog := p6_a147;
2583
2584
2585
2586 -- here's the delegated call to the old PL/SQL routine
2587 ozf_claim_pvt.check_claim_common_element(p_api_version,
2588 p_init_msg_list,
2589 p_validation_level,
2590 x_return_status,
2591 x_msg_count,
2592 x_msg_data,
2593 ddp_claim,
2594 ddx_claim,
2595 p_mode);
2596
2597 -- copy data back from the local variables to OUT or IN-OUT args, if any
2598
2599
2600
2601
2602
2603
2604
2605 p7_a0 := ddx_claim.claim_id;
2606 p7_a1 := ddx_claim.object_version_number;
2607 p7_a2 := ddx_claim.last_update_date;
2608 p7_a3 := ddx_claim.last_updated_by;
2609 p7_a4 := ddx_claim.creation_date;
2610 p7_a5 := ddx_claim.created_by;
2611 p7_a6 := ddx_claim.last_update_login;
2612 p7_a7 := ddx_claim.request_id;
2613 p7_a8 := ddx_claim.program_application_id;
2614 p7_a9 := ddx_claim.program_update_date;
2615 p7_a10 := ddx_claim.program_id;
2616 p7_a11 := ddx_claim.created_from;
2617 p7_a12 := ddx_claim.batch_id;
2618 p7_a13 := ddx_claim.claim_number;
2619 p7_a14 := ddx_claim.claim_type_id;
2620 p7_a15 := ddx_claim.claim_class;
2621 p7_a16 := ddx_claim.claim_date;
2622 p7_a17 := ddx_claim.due_date;
2623 p7_a18 := ddx_claim.owner_id;
2624 p7_a19 := ddx_claim.history_event;
2625 p7_a20 := ddx_claim.history_event_date;
2626 p7_a21 := ddx_claim.history_event_description;
2627 p7_a22 := ddx_claim.split_from_claim_id;
2628 p7_a23 := ddx_claim.duplicate_claim_id;
2629 p7_a24 := ddx_claim.split_date;
2630 p7_a25 := ddx_claim.root_claim_id;
2631 p7_a26 := ddx_claim.amount;
2632 p7_a27 := ddx_claim.amount_adjusted;
2633 p7_a28 := ddx_claim.amount_remaining;
2634 p7_a29 := ddx_claim.amount_settled;
2635 p7_a30 := ddx_claim.acctd_amount;
2636 p7_a31 := ddx_claim.acctd_amount_remaining;
2637 p7_a32 := ddx_claim.acctd_amount_adjusted;
2638 p7_a33 := ddx_claim.acctd_amount_settled;
2639 p7_a34 := ddx_claim.tax_amount;
2640 p7_a35 := ddx_claim.tax_code;
2641 p7_a36 := ddx_claim.tax_calculation_flag;
2642 p7_a37 := ddx_claim.currency_code;
2643 p7_a38 := ddx_claim.exchange_rate_type;
2644 p7_a39 := ddx_claim.exchange_rate_date;
2645 p7_a40 := ddx_claim.exchange_rate;
2646 p7_a41 := ddx_claim.set_of_books_id;
2647 p7_a42 := ddx_claim.original_claim_date;
2648 p7_a43 := ddx_claim.source_object_id;
2649 p7_a44 := ddx_claim.source_object_class;
2650 p7_a45 := ddx_claim.source_object_type_id;
2651 p7_a46 := ddx_claim.source_object_number;
2652 p7_a47 := ddx_claim.cust_account_id;
2653 p7_a48 := ddx_claim.cust_billto_acct_site_id;
2654 p7_a49 := ddx_claim.cust_shipto_acct_site_id;
2655 p7_a50 := ddx_claim.location_id;
2656 p7_a51 := ddx_claim.pay_related_account_flag;
2657 p7_a52 := ddx_claim.related_cust_account_id;
2658 p7_a53 := ddx_claim.related_site_use_id;
2659 p7_a54 := ddx_claim.relationship_type;
2660 p7_a55 := ddx_claim.vendor_id;
2661 p7_a56 := ddx_claim.vendor_site_id;
2662 p7_a57 := ddx_claim.reason_type;
2663 p7_a58 := ddx_claim.reason_code_id;
2664 p7_a59 := ddx_claim.task_template_group_id;
2665 p7_a60 := ddx_claim.status_code;
2666 p7_a61 := ddx_claim.user_status_id;
2667 p7_a62 := ddx_claim.sales_rep_id;
2668 p7_a63 := ddx_claim.collector_id;
2669 p7_a64 := ddx_claim.contact_id;
2670 p7_a65 := ddx_claim.broker_id;
2671 p7_a66 := ddx_claim.territory_id;
2672 p7_a67 := ddx_claim.customer_ref_date;
2673 p7_a68 := ddx_claim.customer_ref_number;
2674 p7_a69 := ddx_claim.assigned_to;
2675 p7_a70 := ddx_claim.receipt_id;
2676 p7_a71 := ddx_claim.receipt_number;
2677 p7_a72 := ddx_claim.doc_sequence_id;
2678 p7_a73 := ddx_claim.doc_sequence_value;
2679 p7_a74 := ddx_claim.gl_date;
2680 p7_a75 := ddx_claim.payment_method;
2681 p7_a76 := ddx_claim.voucher_id;
2682 p7_a77 := ddx_claim.voucher_number;
2683 p7_a78 := ddx_claim.payment_reference_id;
2684 p7_a79 := ddx_claim.payment_reference_number;
2685 p7_a80 := ddx_claim.payment_reference_date;
2686 p7_a81 := ddx_claim.payment_status;
2687 p7_a82 := ddx_claim.approved_flag;
2688 p7_a83 := ddx_claim.approved_date;
2689 p7_a84 := ddx_claim.approved_by;
2690 p7_a85 := ddx_claim.settled_date;
2691 p7_a86 := ddx_claim.settled_by;
2692 p7_a87 := ddx_claim.effective_date;
2693 p7_a88 := ddx_claim.custom_setup_id;
2694 p7_a89 := ddx_claim.task_id;
2695 p7_a90 := ddx_claim.country_id;
2696 p7_a91 := ddx_claim.order_type_id;
2697 p7_a92 := ddx_claim.comments;
2698 p7_a93 := ddx_claim.attribute_category;
2699 p7_a94 := ddx_claim.attribute1;
2700 p7_a95 := ddx_claim.attribute2;
2701 p7_a96 := ddx_claim.attribute3;
2702 p7_a97 := ddx_claim.attribute4;
2703 p7_a98 := ddx_claim.attribute5;
2704 p7_a99 := ddx_claim.attribute6;
2705 p7_a100 := ddx_claim.attribute7;
2706 p7_a101 := ddx_claim.attribute8;
2707 p7_a102 := ddx_claim.attribute9;
2708 p7_a103 := ddx_claim.attribute10;
2709 p7_a104 := ddx_claim.attribute11;
2710 p7_a105 := ddx_claim.attribute12;
2711 p7_a106 := ddx_claim.attribute13;
2712 p7_a107 := ddx_claim.attribute14;
2713 p7_a108 := ddx_claim.attribute15;
2714 p7_a109 := ddx_claim.deduction_attribute_category;
2715 p7_a110 := ddx_claim.deduction_attribute1;
2716 p7_a111 := ddx_claim.deduction_attribute2;
2717 p7_a112 := ddx_claim.deduction_attribute3;
2718 p7_a113 := ddx_claim.deduction_attribute4;
2719 p7_a114 := ddx_claim.deduction_attribute5;
2720 p7_a115 := ddx_claim.deduction_attribute6;
2721 p7_a116 := ddx_claim.deduction_attribute7;
2722 p7_a117 := ddx_claim.deduction_attribute8;
2723 p7_a118 := ddx_claim.deduction_attribute9;
2724 p7_a119 := ddx_claim.deduction_attribute10;
2725 p7_a120 := ddx_claim.deduction_attribute11;
2726 p7_a121 := ddx_claim.deduction_attribute12;
2727 p7_a122 := ddx_claim.deduction_attribute13;
2728 p7_a123 := ddx_claim.deduction_attribute14;
2729 p7_a124 := ddx_claim.deduction_attribute15;
2730 p7_a125 := ddx_claim.org_id;
2731 p7_a126 := ddx_claim.legal_entity_id;
2732 p7_a127 := ddx_claim.write_off_flag;
2733 p7_a128 := ddx_claim.write_off_threshold_amount;
2734 p7_a129 := ddx_claim.under_write_off_threshold;
2735 p7_a130 := ddx_claim.customer_reason;
2736 p7_a131 := ddx_claim.ship_to_cust_account_id;
2737 p7_a132 := ddx_claim.amount_applied;
2738 p7_a133 := ddx_claim.applied_receipt_id;
2739 p7_a134 := ddx_claim.applied_receipt_number;
2740 p7_a135 := ddx_claim.wo_rec_trx_id;
2741 p7_a136 := ddx_claim.group_claim_id;
2742 p7_a137 := ddx_claim.appr_wf_item_key;
2743 p7_a138 := ddx_claim.cstl_wf_item_key;
2744 p7_a139 := ddx_claim.batch_type;
2745 p7_a140 := ddx_claim.tax_action;
2746 p7_a141 := ddx_claim.close_status_id;
2747 p7_a142 := ddx_claim.open_status_id;
2748 p7_a143 := ddx_claim.pre_auth_deduction_number;
2749 p7_a144 := ddx_claim.pre_auth_deduction_normalized;
2750 p7_a145 := ddx_claim.offer_id;
2751 p7_a146 := ddx_claim.settled_from;
2752 p7_a147 := ddx_claim.approval_in_prog;
2753
2754 end;
2755
2756 procedure check_claim_items(p_validation_mode VARCHAR2
2757 , p1_a0 NUMBER
2758 , p1_a1 NUMBER
2759 , p1_a2 DATE
2760 , p1_a3 NUMBER
2761 , p1_a4 DATE
2762 , p1_a5 NUMBER
2763 , p1_a6 NUMBER
2764 , p1_a7 NUMBER
2765 , p1_a8 NUMBER
2766 , p1_a9 DATE
2767 , p1_a10 NUMBER
2768 , p1_a11 VARCHAR2
2769 , p1_a12 NUMBER
2770 , p1_a13 VARCHAR2
2771 , p1_a14 NUMBER
2772 , p1_a15 VARCHAR2
2773 , p1_a16 DATE
2774 , p1_a17 DATE
2775 , p1_a18 NUMBER
2776 , p1_a19 VARCHAR2
2777 , p1_a20 DATE
2778 , p1_a21 VARCHAR2
2779 , p1_a22 NUMBER
2780 , p1_a23 NUMBER
2781 , p1_a24 DATE
2782 , p1_a25 NUMBER
2783 , p1_a26 NUMBER
2784 , p1_a27 NUMBER
2785 , p1_a28 NUMBER
2786 , p1_a29 NUMBER
2787 , p1_a30 NUMBER
2788 , p1_a31 NUMBER
2789 , p1_a32 NUMBER
2790 , p1_a33 NUMBER
2791 , p1_a34 NUMBER
2792 , p1_a35 VARCHAR2
2793 , p1_a36 VARCHAR2
2794 , p1_a37 VARCHAR2
2795 , p1_a38 VARCHAR2
2796 , p1_a39 DATE
2797 , p1_a40 NUMBER
2798 , p1_a41 NUMBER
2799 , p1_a42 DATE
2800 , p1_a43 NUMBER
2801 , p1_a44 VARCHAR2
2802 , p1_a45 NUMBER
2803 , p1_a46 VARCHAR2
2804 , p1_a47 NUMBER
2805 , p1_a48 NUMBER
2806 , p1_a49 NUMBER
2807 , p1_a50 NUMBER
2808 , p1_a51 VARCHAR2
2809 , p1_a52 NUMBER
2810 , p1_a53 NUMBER
2811 , p1_a54 VARCHAR2
2812 , p1_a55 NUMBER
2813 , p1_a56 NUMBER
2814 , p1_a57 VARCHAR2
2815 , p1_a58 NUMBER
2816 , p1_a59 NUMBER
2817 , p1_a60 VARCHAR2
2818 , p1_a61 NUMBER
2819 , p1_a62 NUMBER
2820 , p1_a63 NUMBER
2821 , p1_a64 NUMBER
2822 , p1_a65 NUMBER
2823 , p1_a66 NUMBER
2824 , p1_a67 DATE
2825 , p1_a68 VARCHAR2
2826 , p1_a69 NUMBER
2827 , p1_a70 NUMBER
2828 , p1_a71 VARCHAR2
2829 , p1_a72 NUMBER
2830 , p1_a73 NUMBER
2831 , p1_a74 DATE
2832 , p1_a75 VARCHAR2
2833 , p1_a76 NUMBER
2834 , p1_a77 VARCHAR2
2835 , p1_a78 NUMBER
2836 , p1_a79 VARCHAR2
2837 , p1_a80 DATE
2838 , p1_a81 VARCHAR2
2839 , p1_a82 VARCHAR2
2840 , p1_a83 DATE
2841 , p1_a84 NUMBER
2842 , p1_a85 DATE
2843 , p1_a86 NUMBER
2844 , p1_a87 DATE
2845 , p1_a88 NUMBER
2846 , p1_a89 NUMBER
2847 , p1_a90 NUMBER
2848 , p1_a91 NUMBER
2849 , p1_a92 VARCHAR2
2850 , p1_a93 VARCHAR2
2851 , p1_a94 VARCHAR2
2852 , p1_a95 VARCHAR2
2853 , p1_a96 VARCHAR2
2854 , p1_a97 VARCHAR2
2855 , p1_a98 VARCHAR2
2856 , p1_a99 VARCHAR2
2857 , p1_a100 VARCHAR2
2858 , p1_a101 VARCHAR2
2859 , p1_a102 VARCHAR2
2860 , p1_a103 VARCHAR2
2861 , p1_a104 VARCHAR2
2862 , p1_a105 VARCHAR2
2863 , p1_a106 VARCHAR2
2864 , p1_a107 VARCHAR2
2865 , p1_a108 VARCHAR2
2866 , p1_a109 VARCHAR2
2867 , p1_a110 VARCHAR2
2868 , p1_a111 VARCHAR2
2869 , p1_a112 VARCHAR2
2870 , p1_a113 VARCHAR2
2871 , p1_a114 VARCHAR2
2872 , p1_a115 VARCHAR2
2873 , p1_a116 VARCHAR2
2874 , p1_a117 VARCHAR2
2875 , p1_a118 VARCHAR2
2876 , p1_a119 VARCHAR2
2877 , p1_a120 VARCHAR2
2878 , p1_a121 VARCHAR2
2879 , p1_a122 VARCHAR2
2880 , p1_a123 VARCHAR2
2881 , p1_a124 VARCHAR2
2882 , p1_a125 NUMBER
2883 , p1_a126 NUMBER
2884 , p1_a127 VARCHAR2
2885 , p1_a128 NUMBER
2886 , p1_a129 VARCHAR2
2887 , p1_a130 VARCHAR2
2888 , p1_a131 NUMBER
2889 , p1_a132 NUMBER
2890 , p1_a133 NUMBER
2891 , p1_a134 VARCHAR2
2892 , p1_a135 NUMBER
2893 , p1_a136 NUMBER
2894 , p1_a137 VARCHAR2
2895 , p1_a138 VARCHAR2
2896 , p1_a139 VARCHAR2
2897 , p1_a140 VARCHAR2
2898 , p1_a141 NUMBER
2899 , p1_a142 NUMBER
2900 , p1_a143 VARCHAR2
2901 , p1_a144 VARCHAR2
2902 , p1_a145 NUMBER
2903 , p1_a146 VARCHAR2
2904 , p1_a147 VARCHAR2
2905 , x_return_status out nocopy VARCHAR2
2906 )
2907
2908 as
2909 ddp_claim_rec ozf_claim_pvt.claim_rec_type;
2910 ddindx binary_integer; indx binary_integer;
2911 begin
2912
2913 -- copy data to the local IN or IN-OUT args, if any
2914
2915 ddp_claim_rec.claim_id := p1_a0;
2916 ddp_claim_rec.object_version_number := p1_a1;
2917 ddp_claim_rec.last_update_date := rosetta_g_miss_date_in_map(p1_a2);
2918 ddp_claim_rec.last_updated_by := p1_a3;
2919 ddp_claim_rec.creation_date := rosetta_g_miss_date_in_map(p1_a4);
2920 ddp_claim_rec.created_by := p1_a5;
2921 ddp_claim_rec.last_update_login := p1_a6;
2922 ddp_claim_rec.request_id := p1_a7;
2923 ddp_claim_rec.program_application_id := p1_a8;
2924 ddp_claim_rec.program_update_date := rosetta_g_miss_date_in_map(p1_a9);
2925 ddp_claim_rec.program_id := p1_a10;
2926 ddp_claim_rec.created_from := p1_a11;
2927 ddp_claim_rec.batch_id := p1_a12;
2928 ddp_claim_rec.claim_number := p1_a13;
2929 ddp_claim_rec.claim_type_id := p1_a14;
2930 ddp_claim_rec.claim_class := p1_a15;
2931 ddp_claim_rec.claim_date := rosetta_g_miss_date_in_map(p1_a16);
2932 ddp_claim_rec.due_date := rosetta_g_miss_date_in_map(p1_a17);
2933 ddp_claim_rec.owner_id := p1_a18;
2934 ddp_claim_rec.history_event := p1_a19;
2935 ddp_claim_rec.history_event_date := rosetta_g_miss_date_in_map(p1_a20);
2936 ddp_claim_rec.history_event_description := p1_a21;
2937 ddp_claim_rec.split_from_claim_id := p1_a22;
2938 ddp_claim_rec.duplicate_claim_id := p1_a23;
2939 ddp_claim_rec.split_date := rosetta_g_miss_date_in_map(p1_a24);
2940 ddp_claim_rec.root_claim_id := p1_a25;
2941 ddp_claim_rec.amount := p1_a26;
2942 ddp_claim_rec.amount_adjusted := p1_a27;
2943 ddp_claim_rec.amount_remaining := p1_a28;
2944 ddp_claim_rec.amount_settled := p1_a29;
2945 ddp_claim_rec.acctd_amount := p1_a30;
2946 ddp_claim_rec.acctd_amount_remaining := p1_a31;
2947 ddp_claim_rec.acctd_amount_adjusted := p1_a32;
2948 ddp_claim_rec.acctd_amount_settled := p1_a33;
2949 ddp_claim_rec.tax_amount := p1_a34;
2950 ddp_claim_rec.tax_code := p1_a35;
2951 ddp_claim_rec.tax_calculation_flag := p1_a36;
2952 ddp_claim_rec.currency_code := p1_a37;
2953 ddp_claim_rec.exchange_rate_type := p1_a38;
2954 ddp_claim_rec.exchange_rate_date := rosetta_g_miss_date_in_map(p1_a39);
2955 ddp_claim_rec.exchange_rate := p1_a40;
2956 ddp_claim_rec.set_of_books_id := p1_a41;
2957 ddp_claim_rec.original_claim_date := rosetta_g_miss_date_in_map(p1_a42);
2958 ddp_claim_rec.source_object_id := p1_a43;
2959 ddp_claim_rec.source_object_class := p1_a44;
2960 ddp_claim_rec.source_object_type_id := p1_a45;
2961 ddp_claim_rec.source_object_number := p1_a46;
2962 ddp_claim_rec.cust_account_id := p1_a47;
2963 ddp_claim_rec.cust_billto_acct_site_id := p1_a48;
2964 ddp_claim_rec.cust_shipto_acct_site_id := p1_a49;
2965 ddp_claim_rec.location_id := p1_a50;
2966 ddp_claim_rec.pay_related_account_flag := p1_a51;
2967 ddp_claim_rec.related_cust_account_id := p1_a52;
2968 ddp_claim_rec.related_site_use_id := p1_a53;
2969 ddp_claim_rec.relationship_type := p1_a54;
2970 ddp_claim_rec.vendor_id := p1_a55;
2971 ddp_claim_rec.vendor_site_id := p1_a56;
2972 ddp_claim_rec.reason_type := p1_a57;
2973 ddp_claim_rec.reason_code_id := p1_a58;
2974 ddp_claim_rec.task_template_group_id := p1_a59;
2975 ddp_claim_rec.status_code := p1_a60;
2976 ddp_claim_rec.user_status_id := p1_a61;
2977 ddp_claim_rec.sales_rep_id := p1_a62;
2978 ddp_claim_rec.collector_id := p1_a63;
2979 ddp_claim_rec.contact_id := p1_a64;
2980 ddp_claim_rec.broker_id := p1_a65;
2981 ddp_claim_rec.territory_id := p1_a66;
2982 ddp_claim_rec.customer_ref_date := rosetta_g_miss_date_in_map(p1_a67);
2983 ddp_claim_rec.customer_ref_number := p1_a68;
2984 ddp_claim_rec.assigned_to := p1_a69;
2985 ddp_claim_rec.receipt_id := p1_a70;
2986 ddp_claim_rec.receipt_number := p1_a71;
2987 ddp_claim_rec.doc_sequence_id := p1_a72;
2988 ddp_claim_rec.doc_sequence_value := p1_a73;
2989 ddp_claim_rec.gl_date := rosetta_g_miss_date_in_map(p1_a74);
2990 ddp_claim_rec.payment_method := p1_a75;
2991 ddp_claim_rec.voucher_id := p1_a76;
2992 ddp_claim_rec.voucher_number := p1_a77;
2993 ddp_claim_rec.payment_reference_id := p1_a78;
2994 ddp_claim_rec.payment_reference_number := p1_a79;
2995 ddp_claim_rec.payment_reference_date := rosetta_g_miss_date_in_map(p1_a80);
2996 ddp_claim_rec.payment_status := p1_a81;
2997 ddp_claim_rec.approved_flag := p1_a82;
2998 ddp_claim_rec.approved_date := rosetta_g_miss_date_in_map(p1_a83);
2999 ddp_claim_rec.approved_by := p1_a84;
3000 ddp_claim_rec.settled_date := rosetta_g_miss_date_in_map(p1_a85);
3001 ddp_claim_rec.settled_by := p1_a86;
3002 ddp_claim_rec.effective_date := rosetta_g_miss_date_in_map(p1_a87);
3003 ddp_claim_rec.custom_setup_id := p1_a88;
3004 ddp_claim_rec.task_id := p1_a89;
3005 ddp_claim_rec.country_id := p1_a90;
3006 ddp_claim_rec.order_type_id := p1_a91;
3007 ddp_claim_rec.comments := p1_a92;
3008 ddp_claim_rec.attribute_category := p1_a93;
3009 ddp_claim_rec.attribute1 := p1_a94;
3010 ddp_claim_rec.attribute2 := p1_a95;
3011 ddp_claim_rec.attribute3 := p1_a96;
3012 ddp_claim_rec.attribute4 := p1_a97;
3013 ddp_claim_rec.attribute5 := p1_a98;
3014 ddp_claim_rec.attribute6 := p1_a99;
3015 ddp_claim_rec.attribute7 := p1_a100;
3016 ddp_claim_rec.attribute8 := p1_a101;
3017 ddp_claim_rec.attribute9 := p1_a102;
3018 ddp_claim_rec.attribute10 := p1_a103;
3019 ddp_claim_rec.attribute11 := p1_a104;
3020 ddp_claim_rec.attribute12 := p1_a105;
3021 ddp_claim_rec.attribute13 := p1_a106;
3022 ddp_claim_rec.attribute14 := p1_a107;
3023 ddp_claim_rec.attribute15 := p1_a108;
3024 ddp_claim_rec.deduction_attribute_category := p1_a109;
3025 ddp_claim_rec.deduction_attribute1 := p1_a110;
3026 ddp_claim_rec.deduction_attribute2 := p1_a111;
3027 ddp_claim_rec.deduction_attribute3 := p1_a112;
3028 ddp_claim_rec.deduction_attribute4 := p1_a113;
3029 ddp_claim_rec.deduction_attribute5 := p1_a114;
3030 ddp_claim_rec.deduction_attribute6 := p1_a115;
3031 ddp_claim_rec.deduction_attribute7 := p1_a116;
3032 ddp_claim_rec.deduction_attribute8 := p1_a117;
3033 ddp_claim_rec.deduction_attribute9 := p1_a118;
3034 ddp_claim_rec.deduction_attribute10 := p1_a119;
3035 ddp_claim_rec.deduction_attribute11 := p1_a120;
3036 ddp_claim_rec.deduction_attribute12 := p1_a121;
3037 ddp_claim_rec.deduction_attribute13 := p1_a122;
3038 ddp_claim_rec.deduction_attribute14 := p1_a123;
3039 ddp_claim_rec.deduction_attribute15 := p1_a124;
3040 ddp_claim_rec.org_id := p1_a125;
3041 ddp_claim_rec.legal_entity_id := p1_a126;
3042 ddp_claim_rec.write_off_flag := p1_a127;
3043 ddp_claim_rec.write_off_threshold_amount := p1_a128;
3044 ddp_claim_rec.under_write_off_threshold := p1_a129;
3045 ddp_claim_rec.customer_reason := p1_a130;
3046 ddp_claim_rec.ship_to_cust_account_id := p1_a131;
3047 ddp_claim_rec.amount_applied := p1_a132;
3048 ddp_claim_rec.applied_receipt_id := p1_a133;
3049 ddp_claim_rec.applied_receipt_number := p1_a134;
3050 ddp_claim_rec.wo_rec_trx_id := p1_a135;
3051 ddp_claim_rec.group_claim_id := p1_a136;
3052 ddp_claim_rec.appr_wf_item_key := p1_a137;
3053 ddp_claim_rec.cstl_wf_item_key := p1_a138;
3054 ddp_claim_rec.batch_type := p1_a139;
3055 ddp_claim_rec.tax_action := p1_a140;
3056 ddp_claim_rec.close_status_id := p1_a141;
3057 ddp_claim_rec.open_status_id := p1_a142;
3058 ddp_claim_rec.pre_auth_deduction_number := p1_a143;
3059 ddp_claim_rec.pre_auth_deduction_normalized := p1_a144;
3060 ddp_claim_rec.offer_id := p1_a145;
3061 ddp_claim_rec.settled_from := p1_a146;
3062 ddp_claim_rec.approval_in_prog := p1_a147;
3063
3064
3065 -- here's the delegated call to the old PL/SQL routine
3066 ozf_claim_pvt.check_claim_items(p_validation_mode,
3067 ddp_claim_rec,
3068 x_return_status);
3069
3070 -- copy data back from the local variables to OUT or IN-OUT args, if any
3071
3072
3073 end;
3074
3075 procedure complete_claim_rec(p0_a0 NUMBER
3076 , p0_a1 NUMBER
3077 , p0_a2 DATE
3078 , p0_a3 NUMBER
3079 , p0_a4 DATE
3080 , p0_a5 NUMBER
3081 , p0_a6 NUMBER
3082 , p0_a7 NUMBER
3083 , p0_a8 NUMBER
3084 , p0_a9 DATE
3085 , p0_a10 NUMBER
3086 , p0_a11 VARCHAR2
3087 , p0_a12 NUMBER
3088 , p0_a13 VARCHAR2
3089 , p0_a14 NUMBER
3090 , p0_a15 VARCHAR2
3091 , p0_a16 DATE
3092 , p0_a17 DATE
3093 , p0_a18 NUMBER
3094 , p0_a19 VARCHAR2
3095 , p0_a20 DATE
3096 , p0_a21 VARCHAR2
3097 , p0_a22 NUMBER
3098 , p0_a23 NUMBER
3099 , p0_a24 DATE
3100 , p0_a25 NUMBER
3101 , p0_a26 NUMBER
3102 , p0_a27 NUMBER
3103 , p0_a28 NUMBER
3104 , p0_a29 NUMBER
3105 , p0_a30 NUMBER
3106 , p0_a31 NUMBER
3107 , p0_a32 NUMBER
3108 , p0_a33 NUMBER
3109 , p0_a34 NUMBER
3110 , p0_a35 VARCHAR2
3111 , p0_a36 VARCHAR2
3112 , p0_a37 VARCHAR2
3113 , p0_a38 VARCHAR2
3114 , p0_a39 DATE
3115 , p0_a40 NUMBER
3116 , p0_a41 NUMBER
3117 , p0_a42 DATE
3118 , p0_a43 NUMBER
3119 , p0_a44 VARCHAR2
3120 , p0_a45 NUMBER
3121 , p0_a46 VARCHAR2
3122 , p0_a47 NUMBER
3123 , p0_a48 NUMBER
3124 , p0_a49 NUMBER
3125 , p0_a50 NUMBER
3126 , p0_a51 VARCHAR2
3127 , p0_a52 NUMBER
3128 , p0_a53 NUMBER
3129 , p0_a54 VARCHAR2
3130 , p0_a55 NUMBER
3131 , p0_a56 NUMBER
3132 , p0_a57 VARCHAR2
3133 , p0_a58 NUMBER
3134 , p0_a59 NUMBER
3135 , p0_a60 VARCHAR2
3136 , p0_a61 NUMBER
3137 , p0_a62 NUMBER
3138 , p0_a63 NUMBER
3139 , p0_a64 NUMBER
3140 , p0_a65 NUMBER
3141 , p0_a66 NUMBER
3142 , p0_a67 DATE
3143 , p0_a68 VARCHAR2
3144 , p0_a69 NUMBER
3145 , p0_a70 NUMBER
3146 , p0_a71 VARCHAR2
3147 , p0_a72 NUMBER
3148 , p0_a73 NUMBER
3149 , p0_a74 DATE
3150 , p0_a75 VARCHAR2
3151 , p0_a76 NUMBER
3152 , p0_a77 VARCHAR2
3153 , p0_a78 NUMBER
3154 , p0_a79 VARCHAR2
3155 , p0_a80 DATE
3156 , p0_a81 VARCHAR2
3157 , p0_a82 VARCHAR2
3158 , p0_a83 DATE
3159 , p0_a84 NUMBER
3160 , p0_a85 DATE
3161 , p0_a86 NUMBER
3162 , p0_a87 DATE
3163 , p0_a88 NUMBER
3164 , p0_a89 NUMBER
3165 , p0_a90 NUMBER
3166 , p0_a91 NUMBER
3167 , p0_a92 VARCHAR2
3168 , p0_a93 VARCHAR2
3169 , p0_a94 VARCHAR2
3170 , p0_a95 VARCHAR2
3171 , p0_a96 VARCHAR2
3172 , p0_a97 VARCHAR2
3173 , p0_a98 VARCHAR2
3174 , p0_a99 VARCHAR2
3175 , p0_a100 VARCHAR2
3176 , p0_a101 VARCHAR2
3177 , p0_a102 VARCHAR2
3178 , p0_a103 VARCHAR2
3179 , p0_a104 VARCHAR2
3180 , p0_a105 VARCHAR2
3181 , p0_a106 VARCHAR2
3182 , p0_a107 VARCHAR2
3183 , p0_a108 VARCHAR2
3184 , p0_a109 VARCHAR2
3185 , p0_a110 VARCHAR2
3186 , p0_a111 VARCHAR2
3187 , p0_a112 VARCHAR2
3188 , p0_a113 VARCHAR2
3189 , p0_a114 VARCHAR2
3190 , p0_a115 VARCHAR2
3191 , p0_a116 VARCHAR2
3192 , p0_a117 VARCHAR2
3193 , p0_a118 VARCHAR2
3194 , p0_a119 VARCHAR2
3195 , p0_a120 VARCHAR2
3196 , p0_a121 VARCHAR2
3197 , p0_a122 VARCHAR2
3198 , p0_a123 VARCHAR2
3199 , p0_a124 VARCHAR2
3200 , p0_a125 NUMBER
3201 , p0_a126 NUMBER
3202 , p0_a127 VARCHAR2
3203 , p0_a128 NUMBER
3204 , p0_a129 VARCHAR2
3205 , p0_a130 VARCHAR2
3206 , p0_a131 NUMBER
3207 , p0_a132 NUMBER
3208 , p0_a133 NUMBER
3209 , p0_a134 VARCHAR2
3210 , p0_a135 NUMBER
3211 , p0_a136 NUMBER
3212 , p0_a137 VARCHAR2
3213 , p0_a138 VARCHAR2
3214 , p0_a139 VARCHAR2
3215 , p0_a140 VARCHAR2
3216 , p0_a141 NUMBER
3217 , p0_a142 NUMBER
3218 , p0_a143 VARCHAR2
3219 , p0_a144 VARCHAR2
3220 , p0_a145 NUMBER
3221 , p0_a146 VARCHAR2
3222 , p0_a147 VARCHAR2
3223 , p1_a0 out nocopy NUMBER
3224 , p1_a1 out nocopy NUMBER
3225 , p1_a2 out nocopy DATE
3226 , p1_a3 out nocopy NUMBER
3227 , p1_a4 out nocopy DATE
3228 , p1_a5 out nocopy NUMBER
3229 , p1_a6 out nocopy NUMBER
3230 , p1_a7 out nocopy NUMBER
3231 , p1_a8 out nocopy NUMBER
3232 , p1_a9 out nocopy DATE
3233 , p1_a10 out nocopy NUMBER
3234 , p1_a11 out nocopy VARCHAR2
3235 , p1_a12 out nocopy NUMBER
3236 , p1_a13 out nocopy VARCHAR2
3237 , p1_a14 out nocopy NUMBER
3238 , p1_a15 out nocopy VARCHAR2
3239 , p1_a16 out nocopy DATE
3240 , p1_a17 out nocopy DATE
3241 , p1_a18 out nocopy NUMBER
3242 , p1_a19 out nocopy VARCHAR2
3243 , p1_a20 out nocopy DATE
3244 , p1_a21 out nocopy VARCHAR2
3245 , p1_a22 out nocopy NUMBER
3246 , p1_a23 out nocopy NUMBER
3247 , p1_a24 out nocopy DATE
3248 , p1_a25 out nocopy NUMBER
3249 , p1_a26 out nocopy NUMBER
3250 , p1_a27 out nocopy NUMBER
3251 , p1_a28 out nocopy NUMBER
3252 , p1_a29 out nocopy NUMBER
3253 , p1_a30 out nocopy NUMBER
3254 , p1_a31 out nocopy NUMBER
3255 , p1_a32 out nocopy NUMBER
3256 , p1_a33 out nocopy NUMBER
3257 , p1_a34 out nocopy NUMBER
3258 , p1_a35 out nocopy VARCHAR2
3259 , p1_a36 out nocopy VARCHAR2
3260 , p1_a37 out nocopy VARCHAR2
3261 , p1_a38 out nocopy VARCHAR2
3262 , p1_a39 out nocopy DATE
3263 , p1_a40 out nocopy NUMBER
3264 , p1_a41 out nocopy NUMBER
3265 , p1_a42 out nocopy DATE
3266 , p1_a43 out nocopy NUMBER
3267 , p1_a44 out nocopy VARCHAR2
3268 , p1_a45 out nocopy NUMBER
3269 , p1_a46 out nocopy VARCHAR2
3270 , p1_a47 out nocopy NUMBER
3271 , p1_a48 out nocopy NUMBER
3272 , p1_a49 out nocopy NUMBER
3273 , p1_a50 out nocopy NUMBER
3274 , p1_a51 out nocopy VARCHAR2
3275 , p1_a52 out nocopy NUMBER
3276 , p1_a53 out nocopy NUMBER
3277 , p1_a54 out nocopy VARCHAR2
3278 , p1_a55 out nocopy NUMBER
3279 , p1_a56 out nocopy NUMBER
3280 , p1_a57 out nocopy VARCHAR2
3281 , p1_a58 out nocopy NUMBER
3282 , p1_a59 out nocopy NUMBER
3283 , p1_a60 out nocopy VARCHAR2
3284 , p1_a61 out nocopy NUMBER
3285 , p1_a62 out nocopy NUMBER
3286 , p1_a63 out nocopy NUMBER
3287 , p1_a64 out nocopy NUMBER
3288 , p1_a65 out nocopy NUMBER
3289 , p1_a66 out nocopy NUMBER
3290 , p1_a67 out nocopy DATE
3291 , p1_a68 out nocopy VARCHAR2
3292 , p1_a69 out nocopy NUMBER
3293 , p1_a70 out nocopy NUMBER
3294 , p1_a71 out nocopy VARCHAR2
3295 , p1_a72 out nocopy NUMBER
3296 , p1_a73 out nocopy NUMBER
3297 , p1_a74 out nocopy DATE
3298 , p1_a75 out nocopy VARCHAR2
3299 , p1_a76 out nocopy NUMBER
3300 , p1_a77 out nocopy VARCHAR2
3301 , p1_a78 out nocopy NUMBER
3302 , p1_a79 out nocopy VARCHAR2
3303 , p1_a80 out nocopy DATE
3304 , p1_a81 out nocopy VARCHAR2
3305 , p1_a82 out nocopy VARCHAR2
3306 , p1_a83 out nocopy DATE
3307 , p1_a84 out nocopy NUMBER
3308 , p1_a85 out nocopy DATE
3309 , p1_a86 out nocopy NUMBER
3310 , p1_a87 out nocopy DATE
3311 , p1_a88 out nocopy NUMBER
3312 , p1_a89 out nocopy NUMBER
3313 , p1_a90 out nocopy NUMBER
3314 , p1_a91 out nocopy NUMBER
3315 , p1_a92 out nocopy VARCHAR2
3316 , p1_a93 out nocopy VARCHAR2
3317 , p1_a94 out nocopy VARCHAR2
3318 , p1_a95 out nocopy VARCHAR2
3319 , p1_a96 out nocopy VARCHAR2
3320 , p1_a97 out nocopy VARCHAR2
3321 , p1_a98 out nocopy VARCHAR2
3322 , p1_a99 out nocopy VARCHAR2
3323 , p1_a100 out nocopy VARCHAR2
3324 , p1_a101 out nocopy VARCHAR2
3325 , p1_a102 out nocopy VARCHAR2
3326 , p1_a103 out nocopy VARCHAR2
3327 , p1_a104 out nocopy VARCHAR2
3328 , p1_a105 out nocopy VARCHAR2
3329 , p1_a106 out nocopy VARCHAR2
3330 , p1_a107 out nocopy VARCHAR2
3331 , p1_a108 out nocopy VARCHAR2
3332 , p1_a109 out nocopy VARCHAR2
3333 , p1_a110 out nocopy VARCHAR2
3334 , p1_a111 out nocopy VARCHAR2
3335 , p1_a112 out nocopy VARCHAR2
3336 , p1_a113 out nocopy VARCHAR2
3337 , p1_a114 out nocopy VARCHAR2
3338 , p1_a115 out nocopy VARCHAR2
3339 , p1_a116 out nocopy VARCHAR2
3340 , p1_a117 out nocopy VARCHAR2
3341 , p1_a118 out nocopy VARCHAR2
3342 , p1_a119 out nocopy VARCHAR2
3343 , p1_a120 out nocopy VARCHAR2
3344 , p1_a121 out nocopy VARCHAR2
3345 , p1_a122 out nocopy VARCHAR2
3346 , p1_a123 out nocopy VARCHAR2
3347 , p1_a124 out nocopy VARCHAR2
3348 , p1_a125 out nocopy NUMBER
3349 , p1_a126 out nocopy NUMBER
3350 , p1_a127 out nocopy VARCHAR2
3351 , p1_a128 out nocopy NUMBER
3352 , p1_a129 out nocopy VARCHAR2
3353 , p1_a130 out nocopy VARCHAR2
3354 , p1_a131 out nocopy NUMBER
3355 , p1_a132 out nocopy NUMBER
3356 , p1_a133 out nocopy NUMBER
3357 , p1_a134 out nocopy VARCHAR2
3358 , p1_a135 out nocopy NUMBER
3359 , p1_a136 out nocopy NUMBER
3360 , p1_a137 out nocopy VARCHAR2
3361 , p1_a138 out nocopy VARCHAR2
3362 , p1_a139 out nocopy VARCHAR2
3363 , p1_a140 out nocopy VARCHAR2
3364 , p1_a141 out nocopy NUMBER
3365 , p1_a142 out nocopy NUMBER
3366 , p1_a143 out nocopy VARCHAR2
3367 , p1_a144 out nocopy VARCHAR2
3368 , p1_a145 out nocopy NUMBER
3369 , p1_a146 out nocopy VARCHAR2
3370 , p1_a147 out nocopy VARCHAR2
3371 , x_return_status out nocopy VARCHAR2
3372 )
3373
3374 as
3375 ddp_claim_rec ozf_claim_pvt.claim_rec_type;
3376 ddx_complete_rec ozf_claim_pvt.claim_rec_type;
3377 ddindx binary_integer; indx binary_integer;
3378 begin
3379
3380 -- copy data to the local IN or IN-OUT args, if any
3381 ddp_claim_rec.claim_id := p0_a0;
3382 ddp_claim_rec.object_version_number := p0_a1;
3383 ddp_claim_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a2);
3384 ddp_claim_rec.last_updated_by := p0_a3;
3385 ddp_claim_rec.creation_date := rosetta_g_miss_date_in_map(p0_a4);
3386 ddp_claim_rec.created_by := p0_a5;
3387 ddp_claim_rec.last_update_login := p0_a6;
3388 ddp_claim_rec.request_id := p0_a7;
3389 ddp_claim_rec.program_application_id := p0_a8;
3390 ddp_claim_rec.program_update_date := rosetta_g_miss_date_in_map(p0_a9);
3391 ddp_claim_rec.program_id := p0_a10;
3392 ddp_claim_rec.created_from := p0_a11;
3393 ddp_claim_rec.batch_id := p0_a12;
3394 ddp_claim_rec.claim_number := p0_a13;
3395 ddp_claim_rec.claim_type_id := p0_a14;
3396 ddp_claim_rec.claim_class := p0_a15;
3397 ddp_claim_rec.claim_date := rosetta_g_miss_date_in_map(p0_a16);
3398 ddp_claim_rec.due_date := rosetta_g_miss_date_in_map(p0_a17);
3399 ddp_claim_rec.owner_id := p0_a18;
3400 ddp_claim_rec.history_event := p0_a19;
3401 ddp_claim_rec.history_event_date := rosetta_g_miss_date_in_map(p0_a20);
3402 ddp_claim_rec.history_event_description := p0_a21;
3403 ddp_claim_rec.split_from_claim_id := p0_a22;
3404 ddp_claim_rec.duplicate_claim_id := p0_a23;
3405 ddp_claim_rec.split_date := rosetta_g_miss_date_in_map(p0_a24);
3406 ddp_claim_rec.root_claim_id := p0_a25;
3407 ddp_claim_rec.amount := p0_a26;
3408 ddp_claim_rec.amount_adjusted := p0_a27;
3409 ddp_claim_rec.amount_remaining := p0_a28;
3410 ddp_claim_rec.amount_settled := p0_a29;
3411 ddp_claim_rec.acctd_amount := p0_a30;
3412 ddp_claim_rec.acctd_amount_remaining := p0_a31;
3413 ddp_claim_rec.acctd_amount_adjusted := p0_a32;
3414 ddp_claim_rec.acctd_amount_settled := p0_a33;
3415 ddp_claim_rec.tax_amount := p0_a34;
3416 ddp_claim_rec.tax_code := p0_a35;
3417 ddp_claim_rec.tax_calculation_flag := p0_a36;
3418 ddp_claim_rec.currency_code := p0_a37;
3419 ddp_claim_rec.exchange_rate_type := p0_a38;
3420 ddp_claim_rec.exchange_rate_date := rosetta_g_miss_date_in_map(p0_a39);
3421 ddp_claim_rec.exchange_rate := p0_a40;
3422 ddp_claim_rec.set_of_books_id := p0_a41;
3423 ddp_claim_rec.original_claim_date := rosetta_g_miss_date_in_map(p0_a42);
3424 ddp_claim_rec.source_object_id := p0_a43;
3425 ddp_claim_rec.source_object_class := p0_a44;
3426 ddp_claim_rec.source_object_type_id := p0_a45;
3427 ddp_claim_rec.source_object_number := p0_a46;
3428 ddp_claim_rec.cust_account_id := p0_a47;
3429 ddp_claim_rec.cust_billto_acct_site_id := p0_a48;
3430 ddp_claim_rec.cust_shipto_acct_site_id := p0_a49;
3431 ddp_claim_rec.location_id := p0_a50;
3432 ddp_claim_rec.pay_related_account_flag := p0_a51;
3433 ddp_claim_rec.related_cust_account_id := p0_a52;
3434 ddp_claim_rec.related_site_use_id := p0_a53;
3435 ddp_claim_rec.relationship_type := p0_a54;
3436 ddp_claim_rec.vendor_id := p0_a55;
3437 ddp_claim_rec.vendor_site_id := p0_a56;
3438 ddp_claim_rec.reason_type := p0_a57;
3439 ddp_claim_rec.reason_code_id := p0_a58;
3440 ddp_claim_rec.task_template_group_id := p0_a59;
3441 ddp_claim_rec.status_code := p0_a60;
3442 ddp_claim_rec.user_status_id := p0_a61;
3443 ddp_claim_rec.sales_rep_id := p0_a62;
3444 ddp_claim_rec.collector_id := p0_a63;
3445 ddp_claim_rec.contact_id := p0_a64;
3446 ddp_claim_rec.broker_id := p0_a65;
3447 ddp_claim_rec.territory_id := p0_a66;
3448 ddp_claim_rec.customer_ref_date := rosetta_g_miss_date_in_map(p0_a67);
3449 ddp_claim_rec.customer_ref_number := p0_a68;
3450 ddp_claim_rec.assigned_to := p0_a69;
3451 ddp_claim_rec.receipt_id := p0_a70;
3452 ddp_claim_rec.receipt_number := p0_a71;
3453 ddp_claim_rec.doc_sequence_id := p0_a72;
3454 ddp_claim_rec.doc_sequence_value := p0_a73;
3455 ddp_claim_rec.gl_date := rosetta_g_miss_date_in_map(p0_a74);
3456 ddp_claim_rec.payment_method := p0_a75;
3457 ddp_claim_rec.voucher_id := p0_a76;
3458 ddp_claim_rec.voucher_number := p0_a77;
3459 ddp_claim_rec.payment_reference_id := p0_a78;
3460 ddp_claim_rec.payment_reference_number := p0_a79;
3461 ddp_claim_rec.payment_reference_date := rosetta_g_miss_date_in_map(p0_a80);
3462 ddp_claim_rec.payment_status := p0_a81;
3463 ddp_claim_rec.approved_flag := p0_a82;
3464 ddp_claim_rec.approved_date := rosetta_g_miss_date_in_map(p0_a83);
3465 ddp_claim_rec.approved_by := p0_a84;
3466 ddp_claim_rec.settled_date := rosetta_g_miss_date_in_map(p0_a85);
3467 ddp_claim_rec.settled_by := p0_a86;
3468 ddp_claim_rec.effective_date := rosetta_g_miss_date_in_map(p0_a87);
3469 ddp_claim_rec.custom_setup_id := p0_a88;
3470 ddp_claim_rec.task_id := p0_a89;
3471 ddp_claim_rec.country_id := p0_a90;
3472 ddp_claim_rec.order_type_id := p0_a91;
3473 ddp_claim_rec.comments := p0_a92;
3474 ddp_claim_rec.attribute_category := p0_a93;
3475 ddp_claim_rec.attribute1 := p0_a94;
3476 ddp_claim_rec.attribute2 := p0_a95;
3477 ddp_claim_rec.attribute3 := p0_a96;
3478 ddp_claim_rec.attribute4 := p0_a97;
3479 ddp_claim_rec.attribute5 := p0_a98;
3480 ddp_claim_rec.attribute6 := p0_a99;
3481 ddp_claim_rec.attribute7 := p0_a100;
3482 ddp_claim_rec.attribute8 := p0_a101;
3483 ddp_claim_rec.attribute9 := p0_a102;
3484 ddp_claim_rec.attribute10 := p0_a103;
3485 ddp_claim_rec.attribute11 := p0_a104;
3486 ddp_claim_rec.attribute12 := p0_a105;
3487 ddp_claim_rec.attribute13 := p0_a106;
3488 ddp_claim_rec.attribute14 := p0_a107;
3489 ddp_claim_rec.attribute15 := p0_a108;
3490 ddp_claim_rec.deduction_attribute_category := p0_a109;
3491 ddp_claim_rec.deduction_attribute1 := p0_a110;
3492 ddp_claim_rec.deduction_attribute2 := p0_a111;
3493 ddp_claim_rec.deduction_attribute3 := p0_a112;
3494 ddp_claim_rec.deduction_attribute4 := p0_a113;
3495 ddp_claim_rec.deduction_attribute5 := p0_a114;
3496 ddp_claim_rec.deduction_attribute6 := p0_a115;
3497 ddp_claim_rec.deduction_attribute7 := p0_a116;
3498 ddp_claim_rec.deduction_attribute8 := p0_a117;
3499 ddp_claim_rec.deduction_attribute9 := p0_a118;
3500 ddp_claim_rec.deduction_attribute10 := p0_a119;
3501 ddp_claim_rec.deduction_attribute11 := p0_a120;
3502 ddp_claim_rec.deduction_attribute12 := p0_a121;
3503 ddp_claim_rec.deduction_attribute13 := p0_a122;
3504 ddp_claim_rec.deduction_attribute14 := p0_a123;
3505 ddp_claim_rec.deduction_attribute15 := p0_a124;
3506 ddp_claim_rec.org_id := p0_a125;
3507 ddp_claim_rec.legal_entity_id := p0_a126;
3508 ddp_claim_rec.write_off_flag := p0_a127;
3509 ddp_claim_rec.write_off_threshold_amount := p0_a128;
3510 ddp_claim_rec.under_write_off_threshold := p0_a129;
3511 ddp_claim_rec.customer_reason := p0_a130;
3512 ddp_claim_rec.ship_to_cust_account_id := p0_a131;
3513 ddp_claim_rec.amount_applied := p0_a132;
3514 ddp_claim_rec.applied_receipt_id := p0_a133;
3515 ddp_claim_rec.applied_receipt_number := p0_a134;
3516 ddp_claim_rec.wo_rec_trx_id := p0_a135;
3517 ddp_claim_rec.group_claim_id := p0_a136;
3518 ddp_claim_rec.appr_wf_item_key := p0_a137;
3519 ddp_claim_rec.cstl_wf_item_key := p0_a138;
3520 ddp_claim_rec.batch_type := p0_a139;
3521 ddp_claim_rec.tax_action := p0_a140;
3522 ddp_claim_rec.close_status_id := p0_a141;
3523 ddp_claim_rec.open_status_id := p0_a142;
3524 ddp_claim_rec.pre_auth_deduction_number := p0_a143;
3525 ddp_claim_rec.pre_auth_deduction_normalized := p0_a144;
3526 ddp_claim_rec.offer_id := p0_a145;
3527 ddp_claim_rec.settled_from := p0_a146;
3528 ddp_claim_rec.approval_in_prog := p0_a147;
3529
3530
3531
3532 -- here's the delegated call to the old PL/SQL routine
3533 ozf_claim_pvt.complete_claim_rec(ddp_claim_rec,
3534 ddx_complete_rec,
3535 x_return_status);
3536
3537 -- copy data back from the local variables to OUT or IN-OUT args, if any
3538
3539 p1_a0 := ddx_complete_rec.claim_id;
3540 p1_a1 := ddx_complete_rec.object_version_number;
3541 p1_a2 := ddx_complete_rec.last_update_date;
3542 p1_a3 := ddx_complete_rec.last_updated_by;
3543 p1_a4 := ddx_complete_rec.creation_date;
3544 p1_a5 := ddx_complete_rec.created_by;
3545 p1_a6 := ddx_complete_rec.last_update_login;
3546 p1_a7 := ddx_complete_rec.request_id;
3547 p1_a8 := ddx_complete_rec.program_application_id;
3548 p1_a9 := ddx_complete_rec.program_update_date;
3549 p1_a10 := ddx_complete_rec.program_id;
3550 p1_a11 := ddx_complete_rec.created_from;
3551 p1_a12 := ddx_complete_rec.batch_id;
3552 p1_a13 := ddx_complete_rec.claim_number;
3553 p1_a14 := ddx_complete_rec.claim_type_id;
3554 p1_a15 := ddx_complete_rec.claim_class;
3555 p1_a16 := ddx_complete_rec.claim_date;
3556 p1_a17 := ddx_complete_rec.due_date;
3557 p1_a18 := ddx_complete_rec.owner_id;
3558 p1_a19 := ddx_complete_rec.history_event;
3559 p1_a20 := ddx_complete_rec.history_event_date;
3560 p1_a21 := ddx_complete_rec.history_event_description;
3561 p1_a22 := ddx_complete_rec.split_from_claim_id;
3562 p1_a23 := ddx_complete_rec.duplicate_claim_id;
3563 p1_a24 := ddx_complete_rec.split_date;
3564 p1_a25 := ddx_complete_rec.root_claim_id;
3565 p1_a26 := ddx_complete_rec.amount;
3566 p1_a27 := ddx_complete_rec.amount_adjusted;
3567 p1_a28 := ddx_complete_rec.amount_remaining;
3568 p1_a29 := ddx_complete_rec.amount_settled;
3569 p1_a30 := ddx_complete_rec.acctd_amount;
3570 p1_a31 := ddx_complete_rec.acctd_amount_remaining;
3571 p1_a32 := ddx_complete_rec.acctd_amount_adjusted;
3572 p1_a33 := ddx_complete_rec.acctd_amount_settled;
3573 p1_a34 := ddx_complete_rec.tax_amount;
3574 p1_a35 := ddx_complete_rec.tax_code;
3575 p1_a36 := ddx_complete_rec.tax_calculation_flag;
3576 p1_a37 := ddx_complete_rec.currency_code;
3577 p1_a38 := ddx_complete_rec.exchange_rate_type;
3578 p1_a39 := ddx_complete_rec.exchange_rate_date;
3579 p1_a40 := ddx_complete_rec.exchange_rate;
3580 p1_a41 := ddx_complete_rec.set_of_books_id;
3581 p1_a42 := ddx_complete_rec.original_claim_date;
3582 p1_a43 := ddx_complete_rec.source_object_id;
3583 p1_a44 := ddx_complete_rec.source_object_class;
3584 p1_a45 := ddx_complete_rec.source_object_type_id;
3585 p1_a46 := ddx_complete_rec.source_object_number;
3586 p1_a47 := ddx_complete_rec.cust_account_id;
3587 p1_a48 := ddx_complete_rec.cust_billto_acct_site_id;
3588 p1_a49 := ddx_complete_rec.cust_shipto_acct_site_id;
3589 p1_a50 := ddx_complete_rec.location_id;
3590 p1_a51 := ddx_complete_rec.pay_related_account_flag;
3591 p1_a52 := ddx_complete_rec.related_cust_account_id;
3592 p1_a53 := ddx_complete_rec.related_site_use_id;
3593 p1_a54 := ddx_complete_rec.relationship_type;
3594 p1_a55 := ddx_complete_rec.vendor_id;
3595 p1_a56 := ddx_complete_rec.vendor_site_id;
3596 p1_a57 := ddx_complete_rec.reason_type;
3597 p1_a58 := ddx_complete_rec.reason_code_id;
3598 p1_a59 := ddx_complete_rec.task_template_group_id;
3599 p1_a60 := ddx_complete_rec.status_code;
3600 p1_a61 := ddx_complete_rec.user_status_id;
3601 p1_a62 := ddx_complete_rec.sales_rep_id;
3602 p1_a63 := ddx_complete_rec.collector_id;
3603 p1_a64 := ddx_complete_rec.contact_id;
3604 p1_a65 := ddx_complete_rec.broker_id;
3605 p1_a66 := ddx_complete_rec.territory_id;
3606 p1_a67 := ddx_complete_rec.customer_ref_date;
3607 p1_a68 := ddx_complete_rec.customer_ref_number;
3608 p1_a69 := ddx_complete_rec.assigned_to;
3609 p1_a70 := ddx_complete_rec.receipt_id;
3610 p1_a71 := ddx_complete_rec.receipt_number;
3611 p1_a72 := ddx_complete_rec.doc_sequence_id;
3612 p1_a73 := ddx_complete_rec.doc_sequence_value;
3613 p1_a74 := ddx_complete_rec.gl_date;
3614 p1_a75 := ddx_complete_rec.payment_method;
3615 p1_a76 := ddx_complete_rec.voucher_id;
3616 p1_a77 := ddx_complete_rec.voucher_number;
3617 p1_a78 := ddx_complete_rec.payment_reference_id;
3618 p1_a79 := ddx_complete_rec.payment_reference_number;
3619 p1_a80 := ddx_complete_rec.payment_reference_date;
3620 p1_a81 := ddx_complete_rec.payment_status;
3621 p1_a82 := ddx_complete_rec.approved_flag;
3622 p1_a83 := ddx_complete_rec.approved_date;
3623 p1_a84 := ddx_complete_rec.approved_by;
3624 p1_a85 := ddx_complete_rec.settled_date;
3625 p1_a86 := ddx_complete_rec.settled_by;
3626 p1_a87 := ddx_complete_rec.effective_date;
3627 p1_a88 := ddx_complete_rec.custom_setup_id;
3628 p1_a89 := ddx_complete_rec.task_id;
3629 p1_a90 := ddx_complete_rec.country_id;
3630 p1_a91 := ddx_complete_rec.order_type_id;
3631 p1_a92 := ddx_complete_rec.comments;
3632 p1_a93 := ddx_complete_rec.attribute_category;
3633 p1_a94 := ddx_complete_rec.attribute1;
3634 p1_a95 := ddx_complete_rec.attribute2;
3635 p1_a96 := ddx_complete_rec.attribute3;
3636 p1_a97 := ddx_complete_rec.attribute4;
3637 p1_a98 := ddx_complete_rec.attribute5;
3638 p1_a99 := ddx_complete_rec.attribute6;
3639 p1_a100 := ddx_complete_rec.attribute7;
3640 p1_a101 := ddx_complete_rec.attribute8;
3641 p1_a102 := ddx_complete_rec.attribute9;
3642 p1_a103 := ddx_complete_rec.attribute10;
3643 p1_a104 := ddx_complete_rec.attribute11;
3644 p1_a105 := ddx_complete_rec.attribute12;
3645 p1_a106 := ddx_complete_rec.attribute13;
3646 p1_a107 := ddx_complete_rec.attribute14;
3647 p1_a108 := ddx_complete_rec.attribute15;
3648 p1_a109 := ddx_complete_rec.deduction_attribute_category;
3649 p1_a110 := ddx_complete_rec.deduction_attribute1;
3650 p1_a111 := ddx_complete_rec.deduction_attribute2;
3651 p1_a112 := ddx_complete_rec.deduction_attribute3;
3652 p1_a113 := ddx_complete_rec.deduction_attribute4;
3653 p1_a114 := ddx_complete_rec.deduction_attribute5;
3654 p1_a115 := ddx_complete_rec.deduction_attribute6;
3655 p1_a116 := ddx_complete_rec.deduction_attribute7;
3656 p1_a117 := ddx_complete_rec.deduction_attribute8;
3657 p1_a118 := ddx_complete_rec.deduction_attribute9;
3658 p1_a119 := ddx_complete_rec.deduction_attribute10;
3659 p1_a120 := ddx_complete_rec.deduction_attribute11;
3660 p1_a121 := ddx_complete_rec.deduction_attribute12;
3661 p1_a122 := ddx_complete_rec.deduction_attribute13;
3662 p1_a123 := ddx_complete_rec.deduction_attribute14;
3663 p1_a124 := ddx_complete_rec.deduction_attribute15;
3664 p1_a125 := ddx_complete_rec.org_id;
3665 p1_a126 := ddx_complete_rec.legal_entity_id;
3666 p1_a127 := ddx_complete_rec.write_off_flag;
3667 p1_a128 := ddx_complete_rec.write_off_threshold_amount;
3668 p1_a129 := ddx_complete_rec.under_write_off_threshold;
3669 p1_a130 := ddx_complete_rec.customer_reason;
3670 p1_a131 := ddx_complete_rec.ship_to_cust_account_id;
3671 p1_a132 := ddx_complete_rec.amount_applied;
3672 p1_a133 := ddx_complete_rec.applied_receipt_id;
3673 p1_a134 := ddx_complete_rec.applied_receipt_number;
3674 p1_a135 := ddx_complete_rec.wo_rec_trx_id;
3675 p1_a136 := ddx_complete_rec.group_claim_id;
3676 p1_a137 := ddx_complete_rec.appr_wf_item_key;
3677 p1_a138 := ddx_complete_rec.cstl_wf_item_key;
3678 p1_a139 := ddx_complete_rec.batch_type;
3679 p1_a140 := ddx_complete_rec.tax_action;
3680 p1_a141 := ddx_complete_rec.close_status_id;
3681 p1_a142 := ddx_complete_rec.open_status_id;
3682 p1_a143 := ddx_complete_rec.pre_auth_deduction_number;
3683 p1_a144 := ddx_complete_rec.pre_auth_deduction_normalized;
3684 p1_a145 := ddx_complete_rec.offer_id;
3685 p1_a146 := ddx_complete_rec.settled_from;
3686 p1_a147 := ddx_complete_rec.approval_in_prog;
3687
3688 end;
3689
3690 procedure create_claim_history(p_api_version NUMBER
3691 , p_init_msg_list VARCHAR2
3692 , p_commit VARCHAR2
3693 , p_validation_level NUMBER
3694 , x_return_status out nocopy VARCHAR2
3695 , x_msg_data out nocopy VARCHAR2
3696 , x_msg_count out nocopy NUMBER
3697 , p7_a0 NUMBER
3698 , p7_a1 NUMBER
3699 , p7_a2 DATE
3700 , p7_a3 NUMBER
3701 , p7_a4 DATE
3702 , p7_a5 NUMBER
3703 , p7_a6 NUMBER
3704 , p7_a7 NUMBER
3705 , p7_a8 NUMBER
3706 , p7_a9 DATE
3707 , p7_a10 NUMBER
3708 , p7_a11 VARCHAR2
3709 , p7_a12 NUMBER
3710 , p7_a13 VARCHAR2
3711 , p7_a14 NUMBER
3712 , p7_a15 VARCHAR2
3713 , p7_a16 DATE
3714 , p7_a17 DATE
3715 , p7_a18 NUMBER
3716 , p7_a19 VARCHAR2
3717 , p7_a20 DATE
3718 , p7_a21 VARCHAR2
3719 , p7_a22 NUMBER
3720 , p7_a23 NUMBER
3721 , p7_a24 DATE
3722 , p7_a25 NUMBER
3723 , p7_a26 NUMBER
3724 , p7_a27 NUMBER
3725 , p7_a28 NUMBER
3726 , p7_a29 NUMBER
3727 , p7_a30 NUMBER
3728 , p7_a31 NUMBER
3729 , p7_a32 NUMBER
3730 , p7_a33 NUMBER
3731 , p7_a34 NUMBER
3732 , p7_a35 VARCHAR2
3733 , p7_a36 VARCHAR2
3734 , p7_a37 VARCHAR2
3735 , p7_a38 VARCHAR2
3736 , p7_a39 DATE
3737 , p7_a40 NUMBER
3738 , p7_a41 NUMBER
3739 , p7_a42 DATE
3740 , p7_a43 NUMBER
3741 , p7_a44 VARCHAR2
3742 , p7_a45 NUMBER
3743 , p7_a46 VARCHAR2
3744 , p7_a47 NUMBER
3745 , p7_a48 NUMBER
3746 , p7_a49 NUMBER
3747 , p7_a50 NUMBER
3748 , p7_a51 VARCHAR2
3749 , p7_a52 NUMBER
3750 , p7_a53 NUMBER
3751 , p7_a54 VARCHAR2
3752 , p7_a55 NUMBER
3753 , p7_a56 NUMBER
3754 , p7_a57 VARCHAR2
3755 , p7_a58 NUMBER
3756 , p7_a59 NUMBER
3757 , p7_a60 VARCHAR2
3758 , p7_a61 NUMBER
3759 , p7_a62 NUMBER
3760 , p7_a63 NUMBER
3761 , p7_a64 NUMBER
3762 , p7_a65 NUMBER
3763 , p7_a66 NUMBER
3764 , p7_a67 DATE
3765 , p7_a68 VARCHAR2
3766 , p7_a69 NUMBER
3767 , p7_a70 NUMBER
3768 , p7_a71 VARCHAR2
3769 , p7_a72 NUMBER
3770 , p7_a73 NUMBER
3771 , p7_a74 DATE
3772 , p7_a75 VARCHAR2
3773 , p7_a76 NUMBER
3774 , p7_a77 VARCHAR2
3775 , p7_a78 NUMBER
3776 , p7_a79 VARCHAR2
3777 , p7_a80 DATE
3778 , p7_a81 VARCHAR2
3779 , p7_a82 VARCHAR2
3780 , p7_a83 DATE
3781 , p7_a84 NUMBER
3782 , p7_a85 DATE
3783 , p7_a86 NUMBER
3784 , p7_a87 DATE
3785 , p7_a88 NUMBER
3786 , p7_a89 NUMBER
3787 , p7_a90 NUMBER
3788 , p7_a91 NUMBER
3789 , p7_a92 VARCHAR2
3790 , p7_a93 VARCHAR2
3791 , p7_a94 VARCHAR2
3792 , p7_a95 VARCHAR2
3793 , p7_a96 VARCHAR2
3794 , p7_a97 VARCHAR2
3795 , p7_a98 VARCHAR2
3796 , p7_a99 VARCHAR2
3797 , p7_a100 VARCHAR2
3798 , p7_a101 VARCHAR2
3799 , p7_a102 VARCHAR2
3800 , p7_a103 VARCHAR2
3801 , p7_a104 VARCHAR2
3802 , p7_a105 VARCHAR2
3803 , p7_a106 VARCHAR2
3804 , p7_a107 VARCHAR2
3805 , p7_a108 VARCHAR2
3806 , p7_a109 VARCHAR2
3807 , p7_a110 VARCHAR2
3808 , p7_a111 VARCHAR2
3809 , p7_a112 VARCHAR2
3810 , p7_a113 VARCHAR2
3811 , p7_a114 VARCHAR2
3812 , p7_a115 VARCHAR2
3813 , p7_a116 VARCHAR2
3814 , p7_a117 VARCHAR2
3815 , p7_a118 VARCHAR2
3816 , p7_a119 VARCHAR2
3817 , p7_a120 VARCHAR2
3818 , p7_a121 VARCHAR2
3819 , p7_a122 VARCHAR2
3820 , p7_a123 VARCHAR2
3821 , p7_a124 VARCHAR2
3822 , p7_a125 NUMBER
3823 , p7_a126 NUMBER
3824 , p7_a127 VARCHAR2
3825 , p7_a128 NUMBER
3826 , p7_a129 VARCHAR2
3827 , p7_a130 VARCHAR2
3828 , p7_a131 NUMBER
3829 , p7_a132 NUMBER
3830 , p7_a133 NUMBER
3831 , p7_a134 VARCHAR2
3832 , p7_a135 NUMBER
3833 , p7_a136 NUMBER
3834 , p7_a137 VARCHAR2
3835 , p7_a138 VARCHAR2
3836 , p7_a139 VARCHAR2
3837 , p7_a140 VARCHAR2
3838 , p7_a141 NUMBER
3839 , p7_a142 NUMBER
3840 , p7_a143 VARCHAR2
3841 , p7_a144 VARCHAR2
3842 , p7_a145 NUMBER
3843 , p7_a146 VARCHAR2
3844 , p7_a147 VARCHAR2
3845 , p_event VARCHAR2
3846 , x_need_to_create out nocopy VARCHAR2
3847 , x_claim_history_id out nocopy NUMBER
3848 )
3849
3850 as
3851 ddp_claim ozf_claim_pvt.claim_rec_type;
3852 ddindx binary_integer; indx binary_integer;
3853 begin
3854
3855 -- copy data to the local IN or IN-OUT args, if any
3856
3857
3858
3859
3860
3861
3862
3863 ddp_claim.claim_id := p7_a0;
3864 ddp_claim.object_version_number := p7_a1;
3865 ddp_claim.last_update_date := rosetta_g_miss_date_in_map(p7_a2);
3866 ddp_claim.last_updated_by := p7_a3;
3867 ddp_claim.creation_date := rosetta_g_miss_date_in_map(p7_a4);
3868 ddp_claim.created_by := p7_a5;
3869 ddp_claim.last_update_login := p7_a6;
3870 ddp_claim.request_id := p7_a7;
3871 ddp_claim.program_application_id := p7_a8;
3872 ddp_claim.program_update_date := rosetta_g_miss_date_in_map(p7_a9);
3873 ddp_claim.program_id := p7_a10;
3874 ddp_claim.created_from := p7_a11;
3875 ddp_claim.batch_id := p7_a12;
3876 ddp_claim.claim_number := p7_a13;
3877 ddp_claim.claim_type_id := p7_a14;
3878 ddp_claim.claim_class := p7_a15;
3879 ddp_claim.claim_date := rosetta_g_miss_date_in_map(p7_a16);
3880 ddp_claim.due_date := rosetta_g_miss_date_in_map(p7_a17);
3881 ddp_claim.owner_id := p7_a18;
3882 ddp_claim.history_event := p7_a19;
3883 ddp_claim.history_event_date := rosetta_g_miss_date_in_map(p7_a20);
3884 ddp_claim.history_event_description := p7_a21;
3885 ddp_claim.split_from_claim_id := p7_a22;
3886 ddp_claim.duplicate_claim_id := p7_a23;
3887 ddp_claim.split_date := rosetta_g_miss_date_in_map(p7_a24);
3888 ddp_claim.root_claim_id := p7_a25;
3889 ddp_claim.amount := p7_a26;
3890 ddp_claim.amount_adjusted := p7_a27;
3891 ddp_claim.amount_remaining := p7_a28;
3892 ddp_claim.amount_settled := p7_a29;
3893 ddp_claim.acctd_amount := p7_a30;
3894 ddp_claim.acctd_amount_remaining := p7_a31;
3895 ddp_claim.acctd_amount_adjusted := p7_a32;
3896 ddp_claim.acctd_amount_settled := p7_a33;
3897 ddp_claim.tax_amount := p7_a34;
3898 ddp_claim.tax_code := p7_a35;
3899 ddp_claim.tax_calculation_flag := p7_a36;
3900 ddp_claim.currency_code := p7_a37;
3901 ddp_claim.exchange_rate_type := p7_a38;
3902 ddp_claim.exchange_rate_date := rosetta_g_miss_date_in_map(p7_a39);
3903 ddp_claim.exchange_rate := p7_a40;
3904 ddp_claim.set_of_books_id := p7_a41;
3905 ddp_claim.original_claim_date := rosetta_g_miss_date_in_map(p7_a42);
3906 ddp_claim.source_object_id := p7_a43;
3907 ddp_claim.source_object_class := p7_a44;
3908 ddp_claim.source_object_type_id := p7_a45;
3909 ddp_claim.source_object_number := p7_a46;
3910 ddp_claim.cust_account_id := p7_a47;
3911 ddp_claim.cust_billto_acct_site_id := p7_a48;
3912 ddp_claim.cust_shipto_acct_site_id := p7_a49;
3913 ddp_claim.location_id := p7_a50;
3914 ddp_claim.pay_related_account_flag := p7_a51;
3915 ddp_claim.related_cust_account_id := p7_a52;
3916 ddp_claim.related_site_use_id := p7_a53;
3917 ddp_claim.relationship_type := p7_a54;
3918 ddp_claim.vendor_id := p7_a55;
3919 ddp_claim.vendor_site_id := p7_a56;
3920 ddp_claim.reason_type := p7_a57;
3921 ddp_claim.reason_code_id := p7_a58;
3922 ddp_claim.task_template_group_id := p7_a59;
3923 ddp_claim.status_code := p7_a60;
3924 ddp_claim.user_status_id := p7_a61;
3925 ddp_claim.sales_rep_id := p7_a62;
3926 ddp_claim.collector_id := p7_a63;
3927 ddp_claim.contact_id := p7_a64;
3928 ddp_claim.broker_id := p7_a65;
3929 ddp_claim.territory_id := p7_a66;
3930 ddp_claim.customer_ref_date := rosetta_g_miss_date_in_map(p7_a67);
3931 ddp_claim.customer_ref_number := p7_a68;
3932 ddp_claim.assigned_to := p7_a69;
3933 ddp_claim.receipt_id := p7_a70;
3934 ddp_claim.receipt_number := p7_a71;
3935 ddp_claim.doc_sequence_id := p7_a72;
3936 ddp_claim.doc_sequence_value := p7_a73;
3937 ddp_claim.gl_date := rosetta_g_miss_date_in_map(p7_a74);
3938 ddp_claim.payment_method := p7_a75;
3939 ddp_claim.voucher_id := p7_a76;
3940 ddp_claim.voucher_number := p7_a77;
3941 ddp_claim.payment_reference_id := p7_a78;
3942 ddp_claim.payment_reference_number := p7_a79;
3943 ddp_claim.payment_reference_date := rosetta_g_miss_date_in_map(p7_a80);
3944 ddp_claim.payment_status := p7_a81;
3945 ddp_claim.approved_flag := p7_a82;
3946 ddp_claim.approved_date := rosetta_g_miss_date_in_map(p7_a83);
3947 ddp_claim.approved_by := p7_a84;
3948 ddp_claim.settled_date := rosetta_g_miss_date_in_map(p7_a85);
3949 ddp_claim.settled_by := p7_a86;
3950 ddp_claim.effective_date := rosetta_g_miss_date_in_map(p7_a87);
3951 ddp_claim.custom_setup_id := p7_a88;
3952 ddp_claim.task_id := p7_a89;
3953 ddp_claim.country_id := p7_a90;
3954 ddp_claim.order_type_id := p7_a91;
3955 ddp_claim.comments := p7_a92;
3956 ddp_claim.attribute_category := p7_a93;
3957 ddp_claim.attribute1 := p7_a94;
3958 ddp_claim.attribute2 := p7_a95;
3959 ddp_claim.attribute3 := p7_a96;
3960 ddp_claim.attribute4 := p7_a97;
3961 ddp_claim.attribute5 := p7_a98;
3962 ddp_claim.attribute6 := p7_a99;
3963 ddp_claim.attribute7 := p7_a100;
3964 ddp_claim.attribute8 := p7_a101;
3965 ddp_claim.attribute9 := p7_a102;
3966 ddp_claim.attribute10 := p7_a103;
3967 ddp_claim.attribute11 := p7_a104;
3968 ddp_claim.attribute12 := p7_a105;
3969 ddp_claim.attribute13 := p7_a106;
3970 ddp_claim.attribute14 := p7_a107;
3971 ddp_claim.attribute15 := p7_a108;
3972 ddp_claim.deduction_attribute_category := p7_a109;
3973 ddp_claim.deduction_attribute1 := p7_a110;
3974 ddp_claim.deduction_attribute2 := p7_a111;
3975 ddp_claim.deduction_attribute3 := p7_a112;
3976 ddp_claim.deduction_attribute4 := p7_a113;
3977 ddp_claim.deduction_attribute5 := p7_a114;
3978 ddp_claim.deduction_attribute6 := p7_a115;
3979 ddp_claim.deduction_attribute7 := p7_a116;
3980 ddp_claim.deduction_attribute8 := p7_a117;
3981 ddp_claim.deduction_attribute9 := p7_a118;
3982 ddp_claim.deduction_attribute10 := p7_a119;
3983 ddp_claim.deduction_attribute11 := p7_a120;
3984 ddp_claim.deduction_attribute12 := p7_a121;
3985 ddp_claim.deduction_attribute13 := p7_a122;
3986 ddp_claim.deduction_attribute14 := p7_a123;
3987 ddp_claim.deduction_attribute15 := p7_a124;
3988 ddp_claim.org_id := p7_a125;
3989 ddp_claim.legal_entity_id := p7_a126;
3990 ddp_claim.write_off_flag := p7_a127;
3991 ddp_claim.write_off_threshold_amount := p7_a128;
3992 ddp_claim.under_write_off_threshold := p7_a129;
3993 ddp_claim.customer_reason := p7_a130;
3994 ddp_claim.ship_to_cust_account_id := p7_a131;
3995 ddp_claim.amount_applied := p7_a132;
3996 ddp_claim.applied_receipt_id := p7_a133;
3997 ddp_claim.applied_receipt_number := p7_a134;
3998 ddp_claim.wo_rec_trx_id := p7_a135;
3999 ddp_claim.group_claim_id := p7_a136;
4000 ddp_claim.appr_wf_item_key := p7_a137;
4001 ddp_claim.cstl_wf_item_key := p7_a138;
4002 ddp_claim.batch_type := p7_a139;
4003 ddp_claim.tax_action := p7_a140;
4004 ddp_claim.close_status_id := p7_a141;
4005 ddp_claim.open_status_id := p7_a142;
4006 ddp_claim.pre_auth_deduction_number := p7_a143;
4007 ddp_claim.pre_auth_deduction_normalized := p7_a144;
4008 ddp_claim.offer_id := p7_a145;
4009 ddp_claim.settled_from := p7_a146;
4010 ddp_claim.approval_in_prog := p7_a147;
4011
4012
4013
4014
4015 -- here's the delegated call to the old PL/SQL routine
4016 ozf_claim_pvt.create_claim_history(p_api_version,
4017 p_init_msg_list,
4018 p_commit,
4019 p_validation_level,
4020 x_return_status,
4021 x_msg_data,
4022 x_msg_count,
4023 ddp_claim,
4024 p_event,
4025 x_need_to_create,
4026 x_claim_history_id);
4027
4028 -- copy data back from the local variables to OUT or IN-OUT args, if any
4029
4030
4031
4032
4033
4034
4035
4036
4037
4038
4039 end;
4040
4041 procedure validate_delete_claim(p_api_version_number NUMBER
4042 , p_init_msg_list VARCHAR2
4043 , p_commit VARCHAR2
4044 , p_object_id NUMBER
4045 , p_object_version_number NUMBER
4046 , p5_a0 out nocopy JTF_VARCHAR2_TABLE_300
4047 , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
4048 , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
4049 , p5_a3 out nocopy JTF_VARCHAR2_TABLE_300
4050 , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
4051 , x_return_status out nocopy VARCHAR2
4052 , x_msg_count out nocopy NUMBER
4053 , x_msg_data out nocopy VARCHAR2
4054 )
4055
4056 as
4057 ddx_dependent_object_tbl ams_utility_pvt.dependent_objects_tbl_type;
4058 ddindx binary_integer; indx binary_integer;
4059 begin
4060
4061 -- copy data to the local IN or IN-OUT args, if any
4062
4063
4064
4065
4066
4067
4068
4069
4070
4071 -- here's the delegated call to the old PL/SQL routine
4072 ozf_claim_pvt.validate_delete_claim(p_api_version_number,
4073 p_init_msg_list,
4074 p_commit,
4075 p_object_id,
4076 p_object_version_number,
4077 ddx_dependent_object_tbl,
4078 x_return_status,
4079 x_msg_count,
4080 x_msg_data);
4081
4082 -- copy data back from the local variables to OUT or IN-OUT args, if any
4083
4084
4085
4086
4087
4088 ams_utility_pvt_w.rosetta_table_copy_out_p45(ddx_dependent_object_tbl, p5_a0
4089 , p5_a1
4090 , p5_a2
4091 , p5_a3
4092 , p5_a4
4093 );
4094
4095
4096
4097 end;
4098
4099 procedure create_claim_tbl(p_api_version NUMBER
4100 , p_init_msg_list VARCHAR2
4101 , p_commit VARCHAR2
4102 , p_validation_level NUMBER
4103 , x_return_status out nocopy VARCHAR2
4104 , x_msg_data out nocopy VARCHAR2
4105 , x_msg_count out nocopy NUMBER
4106 , p7_a0 JTF_NUMBER_TABLE
4107 , p7_a1 JTF_NUMBER_TABLE
4108 , p7_a2 JTF_DATE_TABLE
4109 , p7_a3 JTF_NUMBER_TABLE
4110 , p7_a4 JTF_DATE_TABLE
4111 , p7_a5 JTF_NUMBER_TABLE
4112 , p7_a6 JTF_NUMBER_TABLE
4113 , p7_a7 JTF_NUMBER_TABLE
4114 , p7_a8 JTF_NUMBER_TABLE
4115 , p7_a9 JTF_DATE_TABLE
4116 , p7_a10 JTF_NUMBER_TABLE
4117 , p7_a11 JTF_VARCHAR2_TABLE_100
4118 , p7_a12 JTF_NUMBER_TABLE
4119 , p7_a13 JTF_VARCHAR2_TABLE_100
4120 , p7_a14 JTF_NUMBER_TABLE
4121 , p7_a15 JTF_VARCHAR2_TABLE_100
4122 , p7_a16 JTF_DATE_TABLE
4123 , p7_a17 JTF_DATE_TABLE
4124 , p7_a18 JTF_NUMBER_TABLE
4125 , p7_a19 JTF_VARCHAR2_TABLE_100
4126 , p7_a20 JTF_DATE_TABLE
4127 , p7_a21 JTF_VARCHAR2_TABLE_2000
4128 , p7_a22 JTF_NUMBER_TABLE
4129 , p7_a23 JTF_NUMBER_TABLE
4130 , p7_a24 JTF_DATE_TABLE
4131 , p7_a25 JTF_NUMBER_TABLE
4132 , p7_a26 JTF_NUMBER_TABLE
4133 , p7_a27 JTF_NUMBER_TABLE
4134 , p7_a28 JTF_NUMBER_TABLE
4135 , p7_a29 JTF_NUMBER_TABLE
4136 , p7_a30 JTF_NUMBER_TABLE
4137 , p7_a31 JTF_NUMBER_TABLE
4138 , p7_a32 JTF_NUMBER_TABLE
4139 , p7_a33 JTF_NUMBER_TABLE
4140 , p7_a34 JTF_NUMBER_TABLE
4141 , p7_a35 JTF_VARCHAR2_TABLE_100
4142 , p7_a36 JTF_VARCHAR2_TABLE_100
4143 , p7_a37 JTF_VARCHAR2_TABLE_100
4144 , p7_a38 JTF_VARCHAR2_TABLE_100
4145 , p7_a39 JTF_DATE_TABLE
4146 , p7_a40 JTF_NUMBER_TABLE
4147 , p7_a41 JTF_NUMBER_TABLE
4148 , p7_a42 JTF_DATE_TABLE
4149 , p7_a43 JTF_NUMBER_TABLE
4150 , p7_a44 JTF_VARCHAR2_TABLE_100
4151 , p7_a45 JTF_NUMBER_TABLE
4152 , p7_a46 JTF_VARCHAR2_TABLE_100
4153 , p7_a47 JTF_NUMBER_TABLE
4154 , p7_a48 JTF_NUMBER_TABLE
4155 , p7_a49 JTF_NUMBER_TABLE
4156 , p7_a50 JTF_NUMBER_TABLE
4157 , p7_a51 JTF_VARCHAR2_TABLE_100
4158 , p7_a52 JTF_NUMBER_TABLE
4159 , p7_a53 JTF_NUMBER_TABLE
4160 , p7_a54 JTF_VARCHAR2_TABLE_100
4161 , p7_a55 JTF_NUMBER_TABLE
4162 , p7_a56 JTF_NUMBER_TABLE
4163 , p7_a57 JTF_VARCHAR2_TABLE_100
4164 , p7_a58 JTF_NUMBER_TABLE
4165 , p7_a59 JTF_NUMBER_TABLE
4166 , p7_a60 JTF_VARCHAR2_TABLE_100
4167 , p7_a61 JTF_NUMBER_TABLE
4168 , p7_a62 JTF_NUMBER_TABLE
4169 , p7_a63 JTF_NUMBER_TABLE
4170 , p7_a64 JTF_NUMBER_TABLE
4171 , p7_a65 JTF_NUMBER_TABLE
4172 , p7_a66 JTF_NUMBER_TABLE
4173 , p7_a67 JTF_DATE_TABLE
4174 , p7_a68 JTF_VARCHAR2_TABLE_100
4175 , p7_a69 JTF_NUMBER_TABLE
4176 , p7_a70 JTF_NUMBER_TABLE
4177 , p7_a71 JTF_VARCHAR2_TABLE_100
4178 , p7_a72 JTF_NUMBER_TABLE
4179 , p7_a73 JTF_NUMBER_TABLE
4180 , p7_a74 JTF_DATE_TABLE
4181 , p7_a75 JTF_VARCHAR2_TABLE_100
4182 , p7_a76 JTF_NUMBER_TABLE
4183 , p7_a77 JTF_VARCHAR2_TABLE_100
4184 , p7_a78 JTF_NUMBER_TABLE
4185 , p7_a79 JTF_VARCHAR2_TABLE_100
4186 , p7_a80 JTF_DATE_TABLE
4187 , p7_a81 JTF_VARCHAR2_TABLE_100
4188 , p7_a82 JTF_VARCHAR2_TABLE_100
4189 , p7_a83 JTF_DATE_TABLE
4190 , p7_a84 JTF_NUMBER_TABLE
4191 , p7_a85 JTF_DATE_TABLE
4192 , p7_a86 JTF_NUMBER_TABLE
4193 , p7_a87 JTF_DATE_TABLE
4194 , p7_a88 JTF_NUMBER_TABLE
4195 , p7_a89 JTF_NUMBER_TABLE
4196 , p7_a90 JTF_NUMBER_TABLE
4197 , p7_a91 JTF_NUMBER_TABLE
4198 , p7_a92 JTF_VARCHAR2_TABLE_2000
4199 , p7_a93 JTF_VARCHAR2_TABLE_100
4200 , p7_a94 JTF_VARCHAR2_TABLE_200
4201 , p7_a95 JTF_VARCHAR2_TABLE_200
4202 , p7_a96 JTF_VARCHAR2_TABLE_200
4203 , p7_a97 JTF_VARCHAR2_TABLE_200
4204 , p7_a98 JTF_VARCHAR2_TABLE_200
4205 , p7_a99 JTF_VARCHAR2_TABLE_200
4206 , p7_a100 JTF_VARCHAR2_TABLE_200
4207 , p7_a101 JTF_VARCHAR2_TABLE_200
4208 , p7_a102 JTF_VARCHAR2_TABLE_200
4209 , p7_a103 JTF_VARCHAR2_TABLE_200
4210 , p7_a104 JTF_VARCHAR2_TABLE_200
4211 , p7_a105 JTF_VARCHAR2_TABLE_200
4212 , p7_a106 JTF_VARCHAR2_TABLE_200
4213 , p7_a107 JTF_VARCHAR2_TABLE_200
4214 , p7_a108 JTF_VARCHAR2_TABLE_200
4215 , p7_a109 JTF_VARCHAR2_TABLE_100
4216 , p7_a110 JTF_VARCHAR2_TABLE_200
4217 , p7_a111 JTF_VARCHAR2_TABLE_200
4218 , p7_a112 JTF_VARCHAR2_TABLE_200
4219 , p7_a113 JTF_VARCHAR2_TABLE_200
4220 , p7_a114 JTF_VARCHAR2_TABLE_200
4221 , p7_a115 JTF_VARCHAR2_TABLE_200
4222 , p7_a116 JTF_VARCHAR2_TABLE_200
4223 , p7_a117 JTF_VARCHAR2_TABLE_200
4224 , p7_a118 JTF_VARCHAR2_TABLE_200
4225 , p7_a119 JTF_VARCHAR2_TABLE_200
4226 , p7_a120 JTF_VARCHAR2_TABLE_200
4227 , p7_a121 JTF_VARCHAR2_TABLE_200
4228 , p7_a122 JTF_VARCHAR2_TABLE_200
4229 , p7_a123 JTF_VARCHAR2_TABLE_200
4230 , p7_a124 JTF_VARCHAR2_TABLE_200
4231 , p7_a125 JTF_NUMBER_TABLE
4232 , p7_a126 JTF_NUMBER_TABLE
4233 , p7_a127 JTF_VARCHAR2_TABLE_100
4234 , p7_a128 JTF_NUMBER_TABLE
4235 , p7_a129 JTF_VARCHAR2_TABLE_100
4236 , p7_a130 JTF_VARCHAR2_TABLE_100
4237 , p7_a131 JTF_NUMBER_TABLE
4238 , p7_a132 JTF_NUMBER_TABLE
4239 , p7_a133 JTF_NUMBER_TABLE
4240 , p7_a134 JTF_VARCHAR2_TABLE_100
4241 , p7_a135 JTF_NUMBER_TABLE
4242 , p7_a136 JTF_NUMBER_TABLE
4243 , p7_a137 JTF_VARCHAR2_TABLE_300
4244 , p7_a138 JTF_VARCHAR2_TABLE_300
4245 , p7_a139 JTF_VARCHAR2_TABLE_100
4246 , p7_a140 JTF_VARCHAR2_TABLE_100
4247 , p7_a141 JTF_NUMBER_TABLE
4248 , p7_a142 JTF_NUMBER_TABLE
4249 , p7_a143 JTF_VARCHAR2_TABLE_100
4250 , p7_a144 JTF_VARCHAR2_TABLE_100
4251 , p7_a145 JTF_NUMBER_TABLE
4252 , p7_a146 JTF_VARCHAR2_TABLE_100
4253 , p7_a147 JTF_VARCHAR2_TABLE_100
4254 , x_error_index out nocopy NUMBER
4255 )
4256
4257 as
4258 ddp_claim_tbl ozf_claim_pvt.claim_tbl_type;
4259 ddindx binary_integer; indx binary_integer;
4260 begin
4261
4262 -- copy data to the local IN or IN-OUT args, if any
4263
4264
4265
4266
4267
4268
4269
4270 ozf_claim_pvt_w.rosetta_table_copy_in_p3(ddp_claim_tbl, p7_a0
4271 , p7_a1
4272 , p7_a2
4273 , p7_a3
4274 , p7_a4
4275 , p7_a5
4276 , p7_a6
4277 , p7_a7
4278 , p7_a8
4279 , p7_a9
4280 , p7_a10
4281 , p7_a11
4282 , p7_a12
4283 , p7_a13
4284 , p7_a14
4285 , p7_a15
4286 , p7_a16
4287 , p7_a17
4288 , p7_a18
4289 , p7_a19
4290 , p7_a20
4291 , p7_a21
4292 , p7_a22
4293 , p7_a23
4294 , p7_a24
4295 , p7_a25
4296 , p7_a26
4297 , p7_a27
4298 , p7_a28
4299 , p7_a29
4300 , p7_a30
4301 , p7_a31
4302 , p7_a32
4303 , p7_a33
4304 , p7_a34
4305 , p7_a35
4306 , p7_a36
4307 , p7_a37
4308 , p7_a38
4309 , p7_a39
4310 , p7_a40
4311 , p7_a41
4312 , p7_a42
4313 , p7_a43
4314 , p7_a44
4315 , p7_a45
4316 , p7_a46
4317 , p7_a47
4318 , p7_a48
4319 , p7_a49
4320 , p7_a50
4321 , p7_a51
4322 , p7_a52
4323 , p7_a53
4324 , p7_a54
4325 , p7_a55
4326 , p7_a56
4327 , p7_a57
4328 , p7_a58
4329 , p7_a59
4330 , p7_a60
4331 , p7_a61
4332 , p7_a62
4333 , p7_a63
4334 , p7_a64
4335 , p7_a65
4336 , p7_a66
4337 , p7_a67
4338 , p7_a68
4339 , p7_a69
4340 , p7_a70
4341 , p7_a71
4342 , p7_a72
4343 , p7_a73
4344 , p7_a74
4345 , p7_a75
4346 , p7_a76
4347 , p7_a77
4348 , p7_a78
4349 , p7_a79
4350 , p7_a80
4351 , p7_a81
4352 , p7_a82
4353 , p7_a83
4354 , p7_a84
4355 , p7_a85
4356 , p7_a86
4357 , p7_a87
4358 , p7_a88
4359 , p7_a89
4360 , p7_a90
4361 , p7_a91
4362 , p7_a92
4363 , p7_a93
4364 , p7_a94
4365 , p7_a95
4366 , p7_a96
4367 , p7_a97
4368 , p7_a98
4369 , p7_a99
4370 , p7_a100
4371 , p7_a101
4372 , p7_a102
4373 , p7_a103
4374 , p7_a104
4375 , p7_a105
4376 , p7_a106
4377 , p7_a107
4378 , p7_a108
4379 , p7_a109
4380 , p7_a110
4381 , p7_a111
4382 , p7_a112
4383 , p7_a113
4384 , p7_a114
4385 , p7_a115
4386 , p7_a116
4387 , p7_a117
4388 , p7_a118
4389 , p7_a119
4390 , p7_a120
4391 , p7_a121
4392 , p7_a122
4393 , p7_a123
4394 , p7_a124
4395 , p7_a125
4396 , p7_a126
4397 , p7_a127
4398 , p7_a128
4399 , p7_a129
4400 , p7_a130
4401 , p7_a131
4402 , p7_a132
4403 , p7_a133
4404 , p7_a134
4405 , p7_a135
4406 , p7_a136
4407 , p7_a137
4408 , p7_a138
4409 , p7_a139
4410 , p7_a140
4411 , p7_a141
4412 , p7_a142
4413 , p7_a143
4414 , p7_a144
4415 , p7_a145
4416 , p7_a146
4417 , p7_a147
4418 );
4419
4420
4421 -- here's the delegated call to the old PL/SQL routine
4422 ozf_claim_pvt.create_claim_tbl(p_api_version,
4423 p_init_msg_list,
4424 p_commit,
4425 p_validation_level,
4426 x_return_status,
4427 x_msg_data,
4428 x_msg_count,
4429 ddp_claim_tbl,
4430 x_error_index);
4431
4432 -- copy data back from the local variables to OUT or IN-OUT args, if any
4433
4434
4435
4436
4437
4438
4439
4440
4441 end;
4442
4443 procedure update_claim_tbl(p_api_version NUMBER
4444 , p_init_msg_list VARCHAR2
4445 , p_commit VARCHAR2
4446 , p_validation_level NUMBER
4447 , x_return_status out nocopy VARCHAR2
4448 , x_msg_data out nocopy VARCHAR2
4449 , x_msg_count out nocopy NUMBER
4450 , p7_a0 JTF_NUMBER_TABLE
4451 , p7_a1 JTF_NUMBER_TABLE
4452 , p7_a2 JTF_DATE_TABLE
4453 , p7_a3 JTF_NUMBER_TABLE
4454 , p7_a4 JTF_DATE_TABLE
4455 , p7_a5 JTF_NUMBER_TABLE
4456 , p7_a6 JTF_NUMBER_TABLE
4457 , p7_a7 JTF_NUMBER_TABLE
4458 , p7_a8 JTF_NUMBER_TABLE
4459 , p7_a9 JTF_DATE_TABLE
4460 , p7_a10 JTF_NUMBER_TABLE
4461 , p7_a11 JTF_VARCHAR2_TABLE_100
4462 , p7_a12 JTF_NUMBER_TABLE
4463 , p7_a13 JTF_VARCHAR2_TABLE_100
4464 , p7_a14 JTF_NUMBER_TABLE
4465 , p7_a15 JTF_VARCHAR2_TABLE_100
4466 , p7_a16 JTF_DATE_TABLE
4467 , p7_a17 JTF_DATE_TABLE
4468 , p7_a18 JTF_NUMBER_TABLE
4469 , p7_a19 JTF_VARCHAR2_TABLE_100
4470 , p7_a20 JTF_DATE_TABLE
4471 , p7_a21 JTF_VARCHAR2_TABLE_2000
4472 , p7_a22 JTF_NUMBER_TABLE
4473 , p7_a23 JTF_NUMBER_TABLE
4474 , p7_a24 JTF_DATE_TABLE
4475 , p7_a25 JTF_NUMBER_TABLE
4476 , p7_a26 JTF_NUMBER_TABLE
4477 , p7_a27 JTF_NUMBER_TABLE
4478 , p7_a28 JTF_NUMBER_TABLE
4479 , p7_a29 JTF_NUMBER_TABLE
4480 , p7_a30 JTF_NUMBER_TABLE
4481 , p7_a31 JTF_NUMBER_TABLE
4482 , p7_a32 JTF_NUMBER_TABLE
4483 , p7_a33 JTF_NUMBER_TABLE
4484 , p7_a34 JTF_NUMBER_TABLE
4485 , p7_a35 JTF_VARCHAR2_TABLE_100
4486 , p7_a36 JTF_VARCHAR2_TABLE_100
4487 , p7_a37 JTF_VARCHAR2_TABLE_100
4488 , p7_a38 JTF_VARCHAR2_TABLE_100
4489 , p7_a39 JTF_DATE_TABLE
4490 , p7_a40 JTF_NUMBER_TABLE
4491 , p7_a41 JTF_NUMBER_TABLE
4492 , p7_a42 JTF_DATE_TABLE
4493 , p7_a43 JTF_NUMBER_TABLE
4494 , p7_a44 JTF_VARCHAR2_TABLE_100
4495 , p7_a45 JTF_NUMBER_TABLE
4496 , p7_a46 JTF_VARCHAR2_TABLE_100
4497 , p7_a47 JTF_NUMBER_TABLE
4498 , p7_a48 JTF_NUMBER_TABLE
4499 , p7_a49 JTF_NUMBER_TABLE
4500 , p7_a50 JTF_NUMBER_TABLE
4501 , p7_a51 JTF_VARCHAR2_TABLE_100
4502 , p7_a52 JTF_NUMBER_TABLE
4503 , p7_a53 JTF_NUMBER_TABLE
4504 , p7_a54 JTF_VARCHAR2_TABLE_100
4505 , p7_a55 JTF_NUMBER_TABLE
4506 , p7_a56 JTF_NUMBER_TABLE
4507 , p7_a57 JTF_VARCHAR2_TABLE_100
4508 , p7_a58 JTF_NUMBER_TABLE
4509 , p7_a59 JTF_NUMBER_TABLE
4510 , p7_a60 JTF_VARCHAR2_TABLE_100
4511 , p7_a61 JTF_NUMBER_TABLE
4512 , p7_a62 JTF_NUMBER_TABLE
4513 , p7_a63 JTF_NUMBER_TABLE
4514 , p7_a64 JTF_NUMBER_TABLE
4515 , p7_a65 JTF_NUMBER_TABLE
4516 , p7_a66 JTF_NUMBER_TABLE
4517 , p7_a67 JTF_DATE_TABLE
4518 , p7_a68 JTF_VARCHAR2_TABLE_100
4519 , p7_a69 JTF_NUMBER_TABLE
4520 , p7_a70 JTF_NUMBER_TABLE
4521 , p7_a71 JTF_VARCHAR2_TABLE_100
4522 , p7_a72 JTF_NUMBER_TABLE
4523 , p7_a73 JTF_NUMBER_TABLE
4524 , p7_a74 JTF_DATE_TABLE
4525 , p7_a75 JTF_VARCHAR2_TABLE_100
4526 , p7_a76 JTF_NUMBER_TABLE
4527 , p7_a77 JTF_VARCHAR2_TABLE_100
4528 , p7_a78 JTF_NUMBER_TABLE
4529 , p7_a79 JTF_VARCHAR2_TABLE_100
4530 , p7_a80 JTF_DATE_TABLE
4531 , p7_a81 JTF_VARCHAR2_TABLE_100
4532 , p7_a82 JTF_VARCHAR2_TABLE_100
4533 , p7_a83 JTF_DATE_TABLE
4534 , p7_a84 JTF_NUMBER_TABLE
4535 , p7_a85 JTF_DATE_TABLE
4536 , p7_a86 JTF_NUMBER_TABLE
4537 , p7_a87 JTF_DATE_TABLE
4538 , p7_a88 JTF_NUMBER_TABLE
4539 , p7_a89 JTF_NUMBER_TABLE
4540 , p7_a90 JTF_NUMBER_TABLE
4541 , p7_a91 JTF_NUMBER_TABLE
4542 , p7_a92 JTF_VARCHAR2_TABLE_2000
4543 , p7_a93 JTF_VARCHAR2_TABLE_100
4544 , p7_a94 JTF_VARCHAR2_TABLE_200
4545 , p7_a95 JTF_VARCHAR2_TABLE_200
4546 , p7_a96 JTF_VARCHAR2_TABLE_200
4547 , p7_a97 JTF_VARCHAR2_TABLE_200
4548 , p7_a98 JTF_VARCHAR2_TABLE_200
4549 , p7_a99 JTF_VARCHAR2_TABLE_200
4550 , p7_a100 JTF_VARCHAR2_TABLE_200
4551 , p7_a101 JTF_VARCHAR2_TABLE_200
4552 , p7_a102 JTF_VARCHAR2_TABLE_200
4553 , p7_a103 JTF_VARCHAR2_TABLE_200
4554 , p7_a104 JTF_VARCHAR2_TABLE_200
4555 , p7_a105 JTF_VARCHAR2_TABLE_200
4556 , p7_a106 JTF_VARCHAR2_TABLE_200
4557 , p7_a107 JTF_VARCHAR2_TABLE_200
4558 , p7_a108 JTF_VARCHAR2_TABLE_200
4559 , p7_a109 JTF_VARCHAR2_TABLE_100
4560 , p7_a110 JTF_VARCHAR2_TABLE_200
4561 , p7_a111 JTF_VARCHAR2_TABLE_200
4562 , p7_a112 JTF_VARCHAR2_TABLE_200
4563 , p7_a113 JTF_VARCHAR2_TABLE_200
4564 , p7_a114 JTF_VARCHAR2_TABLE_200
4565 , p7_a115 JTF_VARCHAR2_TABLE_200
4566 , p7_a116 JTF_VARCHAR2_TABLE_200
4567 , p7_a117 JTF_VARCHAR2_TABLE_200
4568 , p7_a118 JTF_VARCHAR2_TABLE_200
4569 , p7_a119 JTF_VARCHAR2_TABLE_200
4570 , p7_a120 JTF_VARCHAR2_TABLE_200
4571 , p7_a121 JTF_VARCHAR2_TABLE_200
4572 , p7_a122 JTF_VARCHAR2_TABLE_200
4573 , p7_a123 JTF_VARCHAR2_TABLE_200
4574 , p7_a124 JTF_VARCHAR2_TABLE_200
4575 , p7_a125 JTF_NUMBER_TABLE
4576 , p7_a126 JTF_NUMBER_TABLE
4577 , p7_a127 JTF_VARCHAR2_TABLE_100
4578 , p7_a128 JTF_NUMBER_TABLE
4579 , p7_a129 JTF_VARCHAR2_TABLE_100
4580 , p7_a130 JTF_VARCHAR2_TABLE_100
4581 , p7_a131 JTF_NUMBER_TABLE
4582 , p7_a132 JTF_NUMBER_TABLE
4583 , p7_a133 JTF_NUMBER_TABLE
4584 , p7_a134 JTF_VARCHAR2_TABLE_100
4585 , p7_a135 JTF_NUMBER_TABLE
4586 , p7_a136 JTF_NUMBER_TABLE
4587 , p7_a137 JTF_VARCHAR2_TABLE_300
4588 , p7_a138 JTF_VARCHAR2_TABLE_300
4589 , p7_a139 JTF_VARCHAR2_TABLE_100
4590 , p7_a140 JTF_VARCHAR2_TABLE_100
4591 , p7_a141 JTF_NUMBER_TABLE
4592 , p7_a142 JTF_NUMBER_TABLE
4593 , p7_a143 JTF_VARCHAR2_TABLE_100
4594 , p7_a144 JTF_VARCHAR2_TABLE_100
4595 , p7_a145 JTF_NUMBER_TABLE
4596 , p7_a146 JTF_VARCHAR2_TABLE_100
4597 , p7_a147 JTF_VARCHAR2_TABLE_100
4598 )
4599
4600 as
4601 ddp_claim_tbl ozf_claim_pvt.claim_tbl_type;
4602 ddindx binary_integer; indx binary_integer;
4603 begin
4604
4605 -- copy data to the local IN or IN-OUT args, if any
4606
4607
4608
4609
4610
4611
4612
4613 ozf_claim_pvt_w.rosetta_table_copy_in_p3(ddp_claim_tbl, p7_a0
4614 , p7_a1
4615 , p7_a2
4616 , p7_a3
4617 , p7_a4
4618 , p7_a5
4619 , p7_a6
4620 , p7_a7
4621 , p7_a8
4622 , p7_a9
4623 , p7_a10
4624 , p7_a11
4625 , p7_a12
4626 , p7_a13
4627 , p7_a14
4628 , p7_a15
4629 , p7_a16
4630 , p7_a17
4631 , p7_a18
4632 , p7_a19
4633 , p7_a20
4634 , p7_a21
4635 , p7_a22
4636 , p7_a23
4637 , p7_a24
4638 , p7_a25
4639 , p7_a26
4640 , p7_a27
4641 , p7_a28
4642 , p7_a29
4643 , p7_a30
4644 , p7_a31
4645 , p7_a32
4646 , p7_a33
4647 , p7_a34
4648 , p7_a35
4649 , p7_a36
4650 , p7_a37
4651 , p7_a38
4652 , p7_a39
4653 , p7_a40
4654 , p7_a41
4655 , p7_a42
4656 , p7_a43
4657 , p7_a44
4658 , p7_a45
4659 , p7_a46
4660 , p7_a47
4661 , p7_a48
4662 , p7_a49
4663 , p7_a50
4664 , p7_a51
4665 , p7_a52
4666 , p7_a53
4667 , p7_a54
4668 , p7_a55
4669 , p7_a56
4670 , p7_a57
4671 , p7_a58
4672 , p7_a59
4673 , p7_a60
4674 , p7_a61
4675 , p7_a62
4676 , p7_a63
4677 , p7_a64
4678 , p7_a65
4679 , p7_a66
4680 , p7_a67
4681 , p7_a68
4682 , p7_a69
4683 , p7_a70
4684 , p7_a71
4685 , p7_a72
4686 , p7_a73
4687 , p7_a74
4688 , p7_a75
4689 , p7_a76
4690 , p7_a77
4691 , p7_a78
4692 , p7_a79
4693 , p7_a80
4694 , p7_a81
4695 , p7_a82
4696 , p7_a83
4697 , p7_a84
4698 , p7_a85
4699 , p7_a86
4700 , p7_a87
4701 , p7_a88
4702 , p7_a89
4703 , p7_a90
4704 , p7_a91
4705 , p7_a92
4706 , p7_a93
4707 , p7_a94
4708 , p7_a95
4709 , p7_a96
4710 , p7_a97
4711 , p7_a98
4712 , p7_a99
4713 , p7_a100
4714 , p7_a101
4715 , p7_a102
4716 , p7_a103
4717 , p7_a104
4718 , p7_a105
4719 , p7_a106
4720 , p7_a107
4721 , p7_a108
4722 , p7_a109
4723 , p7_a110
4724 , p7_a111
4725 , p7_a112
4726 , p7_a113
4727 , p7_a114
4728 , p7_a115
4729 , p7_a116
4730 , p7_a117
4731 , p7_a118
4732 , p7_a119
4733 , p7_a120
4734 , p7_a121
4735 , p7_a122
4736 , p7_a123
4737 , p7_a124
4738 , p7_a125
4739 , p7_a126
4740 , p7_a127
4741 , p7_a128
4742 , p7_a129
4743 , p7_a130
4744 , p7_a131
4745 , p7_a132
4746 , p7_a133
4747 , p7_a134
4748 , p7_a135
4749 , p7_a136
4750 , p7_a137
4751 , p7_a138
4752 , p7_a139
4753 , p7_a140
4754 , p7_a141
4755 , p7_a142
4756 , p7_a143
4757 , p7_a144
4758 , p7_a145
4759 , p7_a146
4760 , p7_a147
4761 );
4762
4763 -- here's the delegated call to the old PL/SQL routine
4764 ozf_claim_pvt.update_claim_tbl(p_api_version,
4765 p_init_msg_list,
4766 p_commit,
4767 p_validation_level,
4768 x_return_status,
4769 x_msg_data,
4770 x_msg_count,
4771 ddp_claim_tbl);
4772
4773 -- copy data back from the local variables to OUT or IN-OUT args, if any
4774
4775
4776
4777
4778
4779
4780
4781 end;
4782
4783 end ozf_claim_pvt_w;