[Home] [Help]
PACKAGE BODY: APPS.OZF_CLAIM_LINE_PVT_W
Source
1 package body ozf_claim_line_pvt_w as
2 /* $Header: ozfwclnb.pls 120.3 2011/03/04 09:18:29 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_p1(t out nocopy ozf_claim_line_pvt.claim_line_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_NUMBER_TABLE
30 , a14 JTF_NUMBER_TABLE
31 , a15 JTF_NUMBER_TABLE
32 , a16 JTF_NUMBER_TABLE
33 , a17 JTF_NUMBER_TABLE
34 , a18 JTF_VARCHAR2_TABLE_100
35 , a19 JTF_VARCHAR2_TABLE_100
36 , a20 JTF_DATE_TABLE
37 , a21 JTF_NUMBER_TABLE
38 , a22 JTF_NUMBER_TABLE
39 , a23 JTF_VARCHAR2_TABLE_100
40 , a24 JTF_NUMBER_TABLE
41 , a25 JTF_NUMBER_TABLE
42 , a26 JTF_VARCHAR2_TABLE_100
43 , a27 JTF_NUMBER_TABLE
44 , a28 JTF_NUMBER_TABLE
45 , a29 JTF_NUMBER_TABLE
46 , a30 JTF_NUMBER_TABLE
47 , a31 JTF_VARCHAR2_TABLE_100
48 , a32 JTF_NUMBER_TABLE
49 , a33 JTF_VARCHAR2_TABLE_100
50 , a34 JTF_DATE_TABLE
51 , a35 JTF_NUMBER_TABLE
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_DATE_TABLE
58 , a42 JTF_NUMBER_TABLE
59 , a43 JTF_VARCHAR2_TABLE_100
60 , a44 JTF_VARCHAR2_TABLE_100
61 , a45 JTF_VARCHAR2_TABLE_100
62 , a46 JTF_NUMBER_TABLE
63 , a47 JTF_VARCHAR2_TABLE_300
64 , a48 JTF_NUMBER_TABLE
65 , a49 JTF_VARCHAR2_TABLE_100
66 , a50 JTF_NUMBER_TABLE
67 , a51 JTF_VARCHAR2_TABLE_100
68 , a52 JTF_NUMBER_TABLE
69 , a53 JTF_NUMBER_TABLE
70 , a54 JTF_NUMBER_TABLE
71 , a55 JTF_VARCHAR2_TABLE_100
72 , a56 JTF_VARCHAR2_TABLE_100
73 , a57 JTF_VARCHAR2_TABLE_2000
74 , a58 JTF_VARCHAR2_TABLE_100
75 , a59 JTF_VARCHAR2_TABLE_100
76 , a60 JTF_VARCHAR2_TABLE_100
77 , a61 JTF_VARCHAR2_TABLE_200
78 , a62 JTF_VARCHAR2_TABLE_200
79 , a63 JTF_VARCHAR2_TABLE_200
80 , a64 JTF_VARCHAR2_TABLE_200
81 , a65 JTF_VARCHAR2_TABLE_200
82 , a66 JTF_VARCHAR2_TABLE_200
83 , a67 JTF_VARCHAR2_TABLE_200
84 , a68 JTF_VARCHAR2_TABLE_200
85 , a69 JTF_VARCHAR2_TABLE_200
86 , a70 JTF_VARCHAR2_TABLE_200
87 , a71 JTF_VARCHAR2_TABLE_200
88 , a72 JTF_VARCHAR2_TABLE_200
89 , a73 JTF_VARCHAR2_TABLE_200
90 , a74 JTF_VARCHAR2_TABLE_200
91 , a75 JTF_VARCHAR2_TABLE_200
92 , a76 JTF_NUMBER_TABLE
93 , a77 JTF_VARCHAR2_TABLE_100
94 , a78 JTF_VARCHAR2_TABLE_100
95 , a79 JTF_DATE_TABLE
96 , a80 JTF_VARCHAR2_TABLE_100
97 , a81 JTF_NUMBER_TABLE
98 , a82 JTF_NUMBER_TABLE
99 , a83 JTF_NUMBER_TABLE
100 , a84 JTF_VARCHAR2_TABLE_100
101 , a85 JTF_VARCHAR2_TABLE_100
102 , a86 JTF_DATE_TABLE
103 , a87 JTF_NUMBER_TABLE
104 , a88 JTF_NUMBER_TABLE
105 , a89 JTF_VARCHAR2_TABLE_100
106 , a90 JTF_NUMBER_TABLE
107 , a91 JTF_VARCHAR2_TABLE_2000
108 ) as
109 ddindx binary_integer; indx binary_integer;
110 begin
111 if a0 is not null and a0.count > 0 then
112 if a0.count > 0 then
113 indx := a0.first;
114 ddindx := 1;
115 while true loop
116 t(ddindx).claim_line_id := a0(indx);
117 t(ddindx).object_version_number := a1(indx);
118 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a2(indx));
119 t(ddindx).last_updated_by := a3(indx);
120 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a4(indx));
121 t(ddindx).created_by := a5(indx);
122 t(ddindx).last_update_login := a6(indx);
123 t(ddindx).request_id := a7(indx);
124 t(ddindx).program_application_id := a8(indx);
125 t(ddindx).program_update_date := rosetta_g_miss_date_in_map(a9(indx));
126 t(ddindx).program_id := a10(indx);
127 t(ddindx).created_from := a11(indx);
128 t(ddindx).claim_id := a12(indx);
129 t(ddindx).line_number := a13(indx);
130 t(ddindx).split_from_claim_line_id := a14(indx);
131 t(ddindx).amount := a15(indx);
132 t(ddindx).claim_currency_amount := a16(indx);
133 t(ddindx).acctd_amount := a17(indx);
134 t(ddindx).currency_code := a18(indx);
135 t(ddindx).exchange_rate_type := a19(indx);
136 t(ddindx).exchange_rate_date := rosetta_g_miss_date_in_map(a20(indx));
137 t(ddindx).exchange_rate := a21(indx);
138 t(ddindx).set_of_books_id := a22(indx);
139 t(ddindx).valid_flag := a23(indx);
140 t(ddindx).source_object_id := a24(indx);
141 t(ddindx).source_object_line_id := a25(indx);
142 t(ddindx).source_object_class := a26(indx);
143 t(ddindx).source_object_type_id := a27(indx);
144 t(ddindx).plan_id := a28(indx);
145 t(ddindx).offer_id := a29(indx);
146 t(ddindx).utilization_id := a30(indx);
147 t(ddindx).payment_method := a31(indx);
148 t(ddindx).payment_reference_id := a32(indx);
149 t(ddindx).payment_reference_number := a33(indx);
150 t(ddindx).payment_reference_date := rosetta_g_miss_date_in_map(a34(indx));
151 t(ddindx).voucher_id := a35(indx);
152 t(ddindx).voucher_number := a36(indx);
153 t(ddindx).payment_status := a37(indx);
154 t(ddindx).approved_flag := a38(indx);
155 t(ddindx).approved_date := rosetta_g_miss_date_in_map(a39(indx));
156 t(ddindx).approved_by := a40(indx);
157 t(ddindx).settled_date := rosetta_g_miss_date_in_map(a41(indx));
158 t(ddindx).settled_by := a42(indx);
159 t(ddindx).performance_complete_flag := a43(indx);
160 t(ddindx).performance_attached_flag := a44(indx);
161 t(ddindx).select_cust_children_flag := a45(indx);
162 t(ddindx).item_id := a46(indx);
163 t(ddindx).item_description := a47(indx);
164 t(ddindx).quantity := a48(indx);
165 t(ddindx).quantity_uom := a49(indx);
166 t(ddindx).rate := a50(indx);
167 t(ddindx).activity_type := a51(indx);
168 t(ddindx).activity_id := a52(indx);
169 t(ddindx).related_cust_account_id := a53(indx);
170 t(ddindx).buy_group_cust_account_id := a54(indx);
171 t(ddindx).relationship_type := a55(indx);
172 t(ddindx).earnings_associated_flag := a56(indx);
173 t(ddindx).comments := a57(indx);
174 t(ddindx).tax_code := a58(indx);
175 t(ddindx).credit_to := a59(indx);
176 t(ddindx).attribute_category := a60(indx);
177 t(ddindx).attribute1 := a61(indx);
178 t(ddindx).attribute2 := a62(indx);
179 t(ddindx).attribute3 := a63(indx);
180 t(ddindx).attribute4 := a64(indx);
181 t(ddindx).attribute5 := a65(indx);
182 t(ddindx).attribute6 := a66(indx);
183 t(ddindx).attribute7 := a67(indx);
184 t(ddindx).attribute8 := a68(indx);
185 t(ddindx).attribute9 := a69(indx);
186 t(ddindx).attribute10 := a70(indx);
187 t(ddindx).attribute11 := a71(indx);
188 t(ddindx).attribute12 := a72(indx);
189 t(ddindx).attribute13 := a73(indx);
190 t(ddindx).attribute14 := a74(indx);
191 t(ddindx).attribute15 := a75(indx);
192 t(ddindx).org_id := a76(indx);
193 t(ddindx).update_from_tbl_flag := a77(indx);
194 t(ddindx).tax_action := a78(indx);
195 t(ddindx).sale_date := rosetta_g_miss_date_in_map(a79(indx));
196 t(ddindx).item_type := a80(indx);
197 t(ddindx).tax_amount := a81(indx);
198 t(ddindx).claim_curr_tax_amount := a82(indx);
199 t(ddindx).activity_line_id := a83(indx);
200 t(ddindx).offer_type := a84(indx);
201 t(ddindx).prorate_earnings_flag := a85(indx);
202 t(ddindx).earnings_end_date := rosetta_g_miss_date_in_map(a86(indx));
203 t(ddindx).buy_group_party_id := a87(indx);
204 t(ddindx).acctd_tax_amount := a88(indx);
205 t(ddindx).dpp_cust_account_id := a89(indx);
206 t(ddindx).batch_line_id := a90(indx);
207 t(ddindx).activity_name := a91(indx);
208 ddindx := ddindx+1;
209 if a0.last =indx
210 then exit;
211 end if;
212 indx := a0.next(indx);
213 end loop;
214 end if;
215 end if;
216 end rosetta_table_copy_in_p1;
217 procedure rosetta_table_copy_out_p1(t ozf_claim_line_pvt.claim_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
218 , a1 out nocopy JTF_NUMBER_TABLE
219 , a2 out nocopy JTF_DATE_TABLE
220 , a3 out nocopy JTF_NUMBER_TABLE
221 , a4 out nocopy JTF_DATE_TABLE
222 , a5 out nocopy JTF_NUMBER_TABLE
223 , a6 out nocopy JTF_NUMBER_TABLE
224 , a7 out nocopy JTF_NUMBER_TABLE
225 , a8 out nocopy JTF_NUMBER_TABLE
226 , a9 out nocopy JTF_DATE_TABLE
227 , a10 out nocopy JTF_NUMBER_TABLE
228 , a11 out nocopy JTF_VARCHAR2_TABLE_100
229 , a12 out nocopy JTF_NUMBER_TABLE
230 , a13 out nocopy JTF_NUMBER_TABLE
231 , a14 out nocopy JTF_NUMBER_TABLE
232 , a15 out nocopy JTF_NUMBER_TABLE
233 , a16 out nocopy JTF_NUMBER_TABLE
234 , a17 out nocopy JTF_NUMBER_TABLE
235 , a18 out nocopy JTF_VARCHAR2_TABLE_100
236 , a19 out nocopy JTF_VARCHAR2_TABLE_100
237 , a20 out nocopy JTF_DATE_TABLE
238 , a21 out nocopy JTF_NUMBER_TABLE
239 , a22 out nocopy JTF_NUMBER_TABLE
240 , a23 out nocopy JTF_VARCHAR2_TABLE_100
241 , a24 out nocopy JTF_NUMBER_TABLE
242 , a25 out nocopy JTF_NUMBER_TABLE
243 , a26 out nocopy JTF_VARCHAR2_TABLE_100
244 , a27 out nocopy JTF_NUMBER_TABLE
245 , a28 out nocopy JTF_NUMBER_TABLE
246 , a29 out nocopy JTF_NUMBER_TABLE
247 , a30 out nocopy JTF_NUMBER_TABLE
248 , a31 out nocopy JTF_VARCHAR2_TABLE_100
249 , a32 out nocopy JTF_NUMBER_TABLE
250 , a33 out nocopy JTF_VARCHAR2_TABLE_100
251 , a34 out nocopy JTF_DATE_TABLE
252 , a35 out nocopy JTF_NUMBER_TABLE
253 , a36 out nocopy JTF_VARCHAR2_TABLE_100
254 , a37 out nocopy JTF_VARCHAR2_TABLE_100
255 , a38 out nocopy JTF_VARCHAR2_TABLE_100
256 , a39 out nocopy JTF_DATE_TABLE
257 , a40 out nocopy JTF_NUMBER_TABLE
258 , a41 out nocopy JTF_DATE_TABLE
259 , a42 out nocopy JTF_NUMBER_TABLE
260 , a43 out nocopy JTF_VARCHAR2_TABLE_100
261 , a44 out nocopy JTF_VARCHAR2_TABLE_100
262 , a45 out nocopy JTF_VARCHAR2_TABLE_100
263 , a46 out nocopy JTF_NUMBER_TABLE
264 , a47 out nocopy JTF_VARCHAR2_TABLE_300
265 , a48 out nocopy JTF_NUMBER_TABLE
266 , a49 out nocopy JTF_VARCHAR2_TABLE_100
267 , a50 out nocopy JTF_NUMBER_TABLE
268 , a51 out nocopy JTF_VARCHAR2_TABLE_100
269 , a52 out nocopy JTF_NUMBER_TABLE
270 , a53 out nocopy JTF_NUMBER_TABLE
271 , a54 out nocopy JTF_NUMBER_TABLE
272 , a55 out nocopy JTF_VARCHAR2_TABLE_100
273 , a56 out nocopy JTF_VARCHAR2_TABLE_100
274 , a57 out nocopy JTF_VARCHAR2_TABLE_2000
275 , a58 out nocopy JTF_VARCHAR2_TABLE_100
276 , a59 out nocopy JTF_VARCHAR2_TABLE_100
277 , a60 out nocopy JTF_VARCHAR2_TABLE_100
278 , a61 out nocopy JTF_VARCHAR2_TABLE_200
279 , a62 out nocopy JTF_VARCHAR2_TABLE_200
280 , a63 out nocopy JTF_VARCHAR2_TABLE_200
281 , a64 out nocopy JTF_VARCHAR2_TABLE_200
282 , a65 out nocopy JTF_VARCHAR2_TABLE_200
283 , a66 out nocopy JTF_VARCHAR2_TABLE_200
284 , a67 out nocopy JTF_VARCHAR2_TABLE_200
285 , a68 out nocopy JTF_VARCHAR2_TABLE_200
286 , a69 out nocopy JTF_VARCHAR2_TABLE_200
287 , a70 out nocopy JTF_VARCHAR2_TABLE_200
288 , a71 out nocopy JTF_VARCHAR2_TABLE_200
289 , a72 out nocopy JTF_VARCHAR2_TABLE_200
290 , a73 out nocopy JTF_VARCHAR2_TABLE_200
291 , a74 out nocopy JTF_VARCHAR2_TABLE_200
292 , a75 out nocopy JTF_VARCHAR2_TABLE_200
293 , a76 out nocopy JTF_NUMBER_TABLE
294 , a77 out nocopy JTF_VARCHAR2_TABLE_100
295 , a78 out nocopy JTF_VARCHAR2_TABLE_100
296 , a79 out nocopy JTF_DATE_TABLE
297 , a80 out nocopy JTF_VARCHAR2_TABLE_100
298 , a81 out nocopy JTF_NUMBER_TABLE
299 , a82 out nocopy JTF_NUMBER_TABLE
300 , a83 out nocopy JTF_NUMBER_TABLE
301 , a84 out nocopy JTF_VARCHAR2_TABLE_100
302 , a85 out nocopy JTF_VARCHAR2_TABLE_100
303 , a86 out nocopy JTF_DATE_TABLE
304 , a87 out nocopy JTF_NUMBER_TABLE
305 , a88 out nocopy JTF_NUMBER_TABLE
306 , a89 out nocopy JTF_VARCHAR2_TABLE_100
307 , a90 out nocopy JTF_NUMBER_TABLE
308 , a91 out nocopy JTF_VARCHAR2_TABLE_2000
309 ) as
310 ddindx binary_integer; indx binary_integer;
311 begin
312 if t is null or t.count = 0 then
313 a0 := JTF_NUMBER_TABLE();
314 a1 := JTF_NUMBER_TABLE();
315 a2 := JTF_DATE_TABLE();
316 a3 := JTF_NUMBER_TABLE();
317 a4 := JTF_DATE_TABLE();
318 a5 := JTF_NUMBER_TABLE();
319 a6 := JTF_NUMBER_TABLE();
320 a7 := JTF_NUMBER_TABLE();
321 a8 := JTF_NUMBER_TABLE();
322 a9 := JTF_DATE_TABLE();
323 a10 := JTF_NUMBER_TABLE();
324 a11 := JTF_VARCHAR2_TABLE_100();
325 a12 := JTF_NUMBER_TABLE();
326 a13 := JTF_NUMBER_TABLE();
327 a14 := JTF_NUMBER_TABLE();
328 a15 := JTF_NUMBER_TABLE();
329 a16 := JTF_NUMBER_TABLE();
330 a17 := JTF_NUMBER_TABLE();
331 a18 := JTF_VARCHAR2_TABLE_100();
332 a19 := JTF_VARCHAR2_TABLE_100();
333 a20 := JTF_DATE_TABLE();
334 a21 := JTF_NUMBER_TABLE();
335 a22 := JTF_NUMBER_TABLE();
336 a23 := JTF_VARCHAR2_TABLE_100();
337 a24 := JTF_NUMBER_TABLE();
338 a25 := JTF_NUMBER_TABLE();
339 a26 := JTF_VARCHAR2_TABLE_100();
340 a27 := JTF_NUMBER_TABLE();
341 a28 := JTF_NUMBER_TABLE();
342 a29 := JTF_NUMBER_TABLE();
343 a30 := JTF_NUMBER_TABLE();
344 a31 := JTF_VARCHAR2_TABLE_100();
345 a32 := JTF_NUMBER_TABLE();
346 a33 := JTF_VARCHAR2_TABLE_100();
347 a34 := JTF_DATE_TABLE();
348 a35 := JTF_NUMBER_TABLE();
349 a36 := JTF_VARCHAR2_TABLE_100();
350 a37 := JTF_VARCHAR2_TABLE_100();
351 a38 := JTF_VARCHAR2_TABLE_100();
352 a39 := JTF_DATE_TABLE();
353 a40 := JTF_NUMBER_TABLE();
354 a41 := JTF_DATE_TABLE();
355 a42 := JTF_NUMBER_TABLE();
356 a43 := JTF_VARCHAR2_TABLE_100();
357 a44 := JTF_VARCHAR2_TABLE_100();
358 a45 := JTF_VARCHAR2_TABLE_100();
359 a46 := JTF_NUMBER_TABLE();
360 a47 := JTF_VARCHAR2_TABLE_300();
361 a48 := JTF_NUMBER_TABLE();
362 a49 := JTF_VARCHAR2_TABLE_100();
363 a50 := JTF_NUMBER_TABLE();
364 a51 := JTF_VARCHAR2_TABLE_100();
365 a52 := JTF_NUMBER_TABLE();
366 a53 := JTF_NUMBER_TABLE();
367 a54 := JTF_NUMBER_TABLE();
368 a55 := JTF_VARCHAR2_TABLE_100();
369 a56 := JTF_VARCHAR2_TABLE_100();
370 a57 := JTF_VARCHAR2_TABLE_2000();
371 a58 := JTF_VARCHAR2_TABLE_100();
372 a59 := JTF_VARCHAR2_TABLE_100();
373 a60 := JTF_VARCHAR2_TABLE_100();
374 a61 := JTF_VARCHAR2_TABLE_200();
375 a62 := JTF_VARCHAR2_TABLE_200();
376 a63 := JTF_VARCHAR2_TABLE_200();
377 a64 := JTF_VARCHAR2_TABLE_200();
378 a65 := JTF_VARCHAR2_TABLE_200();
379 a66 := JTF_VARCHAR2_TABLE_200();
380 a67 := JTF_VARCHAR2_TABLE_200();
381 a68 := JTF_VARCHAR2_TABLE_200();
382 a69 := JTF_VARCHAR2_TABLE_200();
383 a70 := JTF_VARCHAR2_TABLE_200();
384 a71 := JTF_VARCHAR2_TABLE_200();
385 a72 := JTF_VARCHAR2_TABLE_200();
386 a73 := JTF_VARCHAR2_TABLE_200();
387 a74 := JTF_VARCHAR2_TABLE_200();
388 a75 := JTF_VARCHAR2_TABLE_200();
389 a76 := JTF_NUMBER_TABLE();
390 a77 := JTF_VARCHAR2_TABLE_100();
391 a78 := JTF_VARCHAR2_TABLE_100();
392 a79 := JTF_DATE_TABLE();
393 a80 := JTF_VARCHAR2_TABLE_100();
394 a81 := JTF_NUMBER_TABLE();
395 a82 := JTF_NUMBER_TABLE();
396 a83 := JTF_NUMBER_TABLE();
397 a84 := JTF_VARCHAR2_TABLE_100();
398 a85 := JTF_VARCHAR2_TABLE_100();
399 a86 := JTF_DATE_TABLE();
400 a87 := JTF_NUMBER_TABLE();
401 a88 := JTF_NUMBER_TABLE();
402 a89 := JTF_VARCHAR2_TABLE_100();
403 a90 := JTF_NUMBER_TABLE();
404 a91 := JTF_VARCHAR2_TABLE_2000();
405 else
406 a0 := JTF_NUMBER_TABLE();
407 a1 := JTF_NUMBER_TABLE();
408 a2 := JTF_DATE_TABLE();
409 a3 := JTF_NUMBER_TABLE();
410 a4 := JTF_DATE_TABLE();
411 a5 := JTF_NUMBER_TABLE();
412 a6 := JTF_NUMBER_TABLE();
413 a7 := JTF_NUMBER_TABLE();
414 a8 := JTF_NUMBER_TABLE();
415 a9 := JTF_DATE_TABLE();
416 a10 := JTF_NUMBER_TABLE();
417 a11 := JTF_VARCHAR2_TABLE_100();
418 a12 := JTF_NUMBER_TABLE();
419 a13 := JTF_NUMBER_TABLE();
420 a14 := JTF_NUMBER_TABLE();
421 a15 := JTF_NUMBER_TABLE();
422 a16 := JTF_NUMBER_TABLE();
423 a17 := JTF_NUMBER_TABLE();
424 a18 := JTF_VARCHAR2_TABLE_100();
425 a19 := JTF_VARCHAR2_TABLE_100();
426 a20 := JTF_DATE_TABLE();
427 a21 := JTF_NUMBER_TABLE();
428 a22 := JTF_NUMBER_TABLE();
429 a23 := JTF_VARCHAR2_TABLE_100();
430 a24 := JTF_NUMBER_TABLE();
431 a25 := JTF_NUMBER_TABLE();
432 a26 := JTF_VARCHAR2_TABLE_100();
433 a27 := JTF_NUMBER_TABLE();
434 a28 := JTF_NUMBER_TABLE();
435 a29 := JTF_NUMBER_TABLE();
436 a30 := JTF_NUMBER_TABLE();
437 a31 := JTF_VARCHAR2_TABLE_100();
438 a32 := JTF_NUMBER_TABLE();
439 a33 := JTF_VARCHAR2_TABLE_100();
440 a34 := JTF_DATE_TABLE();
441 a35 := JTF_NUMBER_TABLE();
442 a36 := JTF_VARCHAR2_TABLE_100();
443 a37 := JTF_VARCHAR2_TABLE_100();
444 a38 := JTF_VARCHAR2_TABLE_100();
445 a39 := JTF_DATE_TABLE();
446 a40 := JTF_NUMBER_TABLE();
447 a41 := JTF_DATE_TABLE();
448 a42 := JTF_NUMBER_TABLE();
449 a43 := JTF_VARCHAR2_TABLE_100();
450 a44 := JTF_VARCHAR2_TABLE_100();
451 a45 := JTF_VARCHAR2_TABLE_100();
452 a46 := JTF_NUMBER_TABLE();
453 a47 := JTF_VARCHAR2_TABLE_300();
454 a48 := JTF_NUMBER_TABLE();
455 a49 := JTF_VARCHAR2_TABLE_100();
456 a50 := JTF_NUMBER_TABLE();
457 a51 := JTF_VARCHAR2_TABLE_100();
458 a52 := JTF_NUMBER_TABLE();
459 a53 := JTF_NUMBER_TABLE();
460 a54 := JTF_NUMBER_TABLE();
461 a55 := JTF_VARCHAR2_TABLE_100();
462 a56 := JTF_VARCHAR2_TABLE_100();
463 a57 := JTF_VARCHAR2_TABLE_2000();
464 a58 := JTF_VARCHAR2_TABLE_100();
465 a59 := JTF_VARCHAR2_TABLE_100();
466 a60 := JTF_VARCHAR2_TABLE_100();
467 a61 := JTF_VARCHAR2_TABLE_200();
468 a62 := JTF_VARCHAR2_TABLE_200();
469 a63 := JTF_VARCHAR2_TABLE_200();
470 a64 := JTF_VARCHAR2_TABLE_200();
471 a65 := JTF_VARCHAR2_TABLE_200();
472 a66 := JTF_VARCHAR2_TABLE_200();
473 a67 := JTF_VARCHAR2_TABLE_200();
474 a68 := JTF_VARCHAR2_TABLE_200();
475 a69 := JTF_VARCHAR2_TABLE_200();
476 a70 := JTF_VARCHAR2_TABLE_200();
477 a71 := JTF_VARCHAR2_TABLE_200();
478 a72 := JTF_VARCHAR2_TABLE_200();
479 a73 := JTF_VARCHAR2_TABLE_200();
480 a74 := JTF_VARCHAR2_TABLE_200();
481 a75 := JTF_VARCHAR2_TABLE_200();
482 a76 := JTF_NUMBER_TABLE();
483 a77 := JTF_VARCHAR2_TABLE_100();
484 a78 := JTF_VARCHAR2_TABLE_100();
485 a79 := JTF_DATE_TABLE();
486 a80 := JTF_VARCHAR2_TABLE_100();
487 a81 := JTF_NUMBER_TABLE();
488 a82 := JTF_NUMBER_TABLE();
489 a83 := JTF_NUMBER_TABLE();
490 a84 := JTF_VARCHAR2_TABLE_100();
491 a85 := JTF_VARCHAR2_TABLE_100();
492 a86 := JTF_DATE_TABLE();
493 a87 := JTF_NUMBER_TABLE();
494 a88 := JTF_NUMBER_TABLE();
495 a89 := JTF_VARCHAR2_TABLE_100();
496 a90 := JTF_NUMBER_TABLE();
497 a91 := JTF_VARCHAR2_TABLE_2000();
498 if t.count > 0 then
499 a0.extend(t.count);
500 a1.extend(t.count);
501 a2.extend(t.count);
502 a3.extend(t.count);
503 a4.extend(t.count);
504 a5.extend(t.count);
505 a6.extend(t.count);
506 a7.extend(t.count);
507 a8.extend(t.count);
508 a9.extend(t.count);
509 a10.extend(t.count);
510 a11.extend(t.count);
511 a12.extend(t.count);
512 a13.extend(t.count);
513 a14.extend(t.count);
514 a15.extend(t.count);
515 a16.extend(t.count);
516 a17.extend(t.count);
517 a18.extend(t.count);
518 a19.extend(t.count);
519 a20.extend(t.count);
520 a21.extend(t.count);
521 a22.extend(t.count);
522 a23.extend(t.count);
523 a24.extend(t.count);
524 a25.extend(t.count);
525 a26.extend(t.count);
526 a27.extend(t.count);
527 a28.extend(t.count);
528 a29.extend(t.count);
529 a30.extend(t.count);
530 a31.extend(t.count);
531 a32.extend(t.count);
532 a33.extend(t.count);
533 a34.extend(t.count);
534 a35.extend(t.count);
535 a36.extend(t.count);
536 a37.extend(t.count);
537 a38.extend(t.count);
538 a39.extend(t.count);
539 a40.extend(t.count);
540 a41.extend(t.count);
541 a42.extend(t.count);
542 a43.extend(t.count);
543 a44.extend(t.count);
544 a45.extend(t.count);
545 a46.extend(t.count);
546 a47.extend(t.count);
547 a48.extend(t.count);
548 a49.extend(t.count);
549 a50.extend(t.count);
550 a51.extend(t.count);
551 a52.extend(t.count);
552 a53.extend(t.count);
553 a54.extend(t.count);
554 a55.extend(t.count);
555 a56.extend(t.count);
556 a57.extend(t.count);
557 a58.extend(t.count);
558 a59.extend(t.count);
559 a60.extend(t.count);
560 a61.extend(t.count);
561 a62.extend(t.count);
562 a63.extend(t.count);
563 a64.extend(t.count);
564 a65.extend(t.count);
565 a66.extend(t.count);
566 a67.extend(t.count);
567 a68.extend(t.count);
568 a69.extend(t.count);
569 a70.extend(t.count);
570 a71.extend(t.count);
571 a72.extend(t.count);
572 a73.extend(t.count);
573 a74.extend(t.count);
574 a75.extend(t.count);
575 a76.extend(t.count);
576 a77.extend(t.count);
577 a78.extend(t.count);
578 a79.extend(t.count);
579 a80.extend(t.count);
580 a81.extend(t.count);
581 a82.extend(t.count);
582 a83.extend(t.count);
583 a84.extend(t.count);
584 a85.extend(t.count);
585 a86.extend(t.count);
586 a87.extend(t.count);
587 a88.extend(t.count);
588 a89.extend(t.count);
589 a90.extend(t.count);
590 a91.extend(t.count);
591 ddindx := t.first;
592 indx := 1;
593 while true loop
594 a0(indx) := t(ddindx).claim_line_id;
595 a1(indx) := t(ddindx).object_version_number;
596 a2(indx) := t(ddindx).last_update_date;
597 a3(indx) := t(ddindx).last_updated_by;
598 a4(indx) := t(ddindx).creation_date;
599 a5(indx) := t(ddindx).created_by;
600 a6(indx) := t(ddindx).last_update_login;
601 a7(indx) := t(ddindx).request_id;
602 a8(indx) := t(ddindx).program_application_id;
603 a9(indx) := t(ddindx).program_update_date;
604 a10(indx) := t(ddindx).program_id;
605 a11(indx) := t(ddindx).created_from;
606 a12(indx) := t(ddindx).claim_id;
607 a13(indx) := t(ddindx).line_number;
608 a14(indx) := t(ddindx).split_from_claim_line_id;
609 a15(indx) := t(ddindx).amount;
610 a16(indx) := t(ddindx).claim_currency_amount;
611 a17(indx) := t(ddindx).acctd_amount;
612 a18(indx) := t(ddindx).currency_code;
613 a19(indx) := t(ddindx).exchange_rate_type;
614 a20(indx) := t(ddindx).exchange_rate_date;
615 a21(indx) := t(ddindx).exchange_rate;
616 a22(indx) := t(ddindx).set_of_books_id;
617 a23(indx) := t(ddindx).valid_flag;
618 a24(indx) := t(ddindx).source_object_id;
619 a25(indx) := t(ddindx).source_object_line_id;
620 a26(indx) := t(ddindx).source_object_class;
621 a27(indx) := t(ddindx).source_object_type_id;
622 a28(indx) := t(ddindx).plan_id;
623 a29(indx) := t(ddindx).offer_id;
624 a30(indx) := t(ddindx).utilization_id;
625 a31(indx) := t(ddindx).payment_method;
626 a32(indx) := t(ddindx).payment_reference_id;
627 a33(indx) := t(ddindx).payment_reference_number;
628 a34(indx) := t(ddindx).payment_reference_date;
629 a35(indx) := t(ddindx).voucher_id;
630 a36(indx) := t(ddindx).voucher_number;
631 a37(indx) := t(ddindx).payment_status;
632 a38(indx) := t(ddindx).approved_flag;
633 a39(indx) := t(ddindx).approved_date;
634 a40(indx) := t(ddindx).approved_by;
635 a41(indx) := t(ddindx).settled_date;
636 a42(indx) := t(ddindx).settled_by;
637 a43(indx) := t(ddindx).performance_complete_flag;
638 a44(indx) := t(ddindx).performance_attached_flag;
639 a45(indx) := t(ddindx).select_cust_children_flag;
640 a46(indx) := t(ddindx).item_id;
641 a47(indx) := t(ddindx).item_description;
642 a48(indx) := t(ddindx).quantity;
643 a49(indx) := t(ddindx).quantity_uom;
644 a50(indx) := t(ddindx).rate;
645 a51(indx) := t(ddindx).activity_type;
646 a52(indx) := t(ddindx).activity_id;
647 a53(indx) := t(ddindx).related_cust_account_id;
648 a54(indx) := t(ddindx).buy_group_cust_account_id;
649 a55(indx) := t(ddindx).relationship_type;
650 a56(indx) := t(ddindx).earnings_associated_flag;
651 a57(indx) := t(ddindx).comments;
652 a58(indx) := t(ddindx).tax_code;
653 a59(indx) := t(ddindx).credit_to;
654 a60(indx) := t(ddindx).attribute_category;
655 a61(indx) := t(ddindx).attribute1;
656 a62(indx) := t(ddindx).attribute2;
657 a63(indx) := t(ddindx).attribute3;
658 a64(indx) := t(ddindx).attribute4;
659 a65(indx) := t(ddindx).attribute5;
660 a66(indx) := t(ddindx).attribute6;
661 a67(indx) := t(ddindx).attribute7;
662 a68(indx) := t(ddindx).attribute8;
663 a69(indx) := t(ddindx).attribute9;
664 a70(indx) := t(ddindx).attribute10;
665 a71(indx) := t(ddindx).attribute11;
666 a72(indx) := t(ddindx).attribute12;
667 a73(indx) := t(ddindx).attribute13;
668 a74(indx) := t(ddindx).attribute14;
669 a75(indx) := t(ddindx).attribute15;
670 a76(indx) := t(ddindx).org_id;
671 a77(indx) := t(ddindx).update_from_tbl_flag;
672 a78(indx) := t(ddindx).tax_action;
673 a79(indx) := t(ddindx).sale_date;
674 a80(indx) := t(ddindx).item_type;
675 a81(indx) := t(ddindx).tax_amount;
676 a82(indx) := t(ddindx).claim_curr_tax_amount;
677 a83(indx) := t(ddindx).activity_line_id;
678 a84(indx) := t(ddindx).offer_type;
679 a85(indx) := t(ddindx).prorate_earnings_flag;
680 a86(indx) := t(ddindx).earnings_end_date;
681 a87(indx) := t(ddindx).buy_group_party_id;
682 a88(indx) := t(ddindx).acctd_tax_amount;
683 a89(indx) := t(ddindx).dpp_cust_account_id;
684 a90(indx) := t(ddindx).batch_line_id;
685 a91(indx) := t(ddindx).activity_name;
686 indx := indx+1;
687 if t.last =ddindx
688 then exit;
689 end if;
690 ddindx := t.next(ddindx);
691 end loop;
692 end if;
693 end if;
694 end rosetta_table_copy_out_p1;
695
696 procedure check_create_line_hist(p_api_version NUMBER
697 , p_init_msg_list VARCHAR2
698 , x_return_status out nocopy VARCHAR2
699 , x_msg_count out nocopy NUMBER
700 , x_msg_data out nocopy VARCHAR2
701 , p_mode VARCHAR2
702 , p6_a0 NUMBER
703 , p6_a1 NUMBER
704 , p6_a2 DATE
705 , p6_a3 NUMBER
706 , p6_a4 DATE
707 , p6_a5 NUMBER
708 , p6_a6 NUMBER
709 , p6_a7 NUMBER
710 , p6_a8 NUMBER
711 , p6_a9 DATE
712 , p6_a10 NUMBER
713 , p6_a11 VARCHAR2
714 , p6_a12 NUMBER
715 , p6_a13 NUMBER
716 , p6_a14 NUMBER
717 , p6_a15 NUMBER
718 , p6_a16 NUMBER
719 , p6_a17 NUMBER
720 , p6_a18 VARCHAR2
721 , p6_a19 VARCHAR2
722 , p6_a20 DATE
723 , p6_a21 NUMBER
724 , p6_a22 NUMBER
725 , p6_a23 VARCHAR2
726 , p6_a24 NUMBER
727 , p6_a25 NUMBER
728 , p6_a26 VARCHAR2
729 , p6_a27 NUMBER
730 , p6_a28 NUMBER
731 , p6_a29 NUMBER
732 , p6_a30 NUMBER
733 , p6_a31 VARCHAR2
734 , p6_a32 NUMBER
735 , p6_a33 VARCHAR2
736 , p6_a34 DATE
737 , p6_a35 NUMBER
738 , p6_a36 VARCHAR2
739 , p6_a37 VARCHAR2
740 , p6_a38 VARCHAR2
741 , p6_a39 DATE
742 , p6_a40 NUMBER
743 , p6_a41 DATE
744 , p6_a42 NUMBER
745 , p6_a43 VARCHAR2
746 , p6_a44 VARCHAR2
747 , p6_a45 VARCHAR2
748 , p6_a46 NUMBER
749 , p6_a47 VARCHAR2
750 , p6_a48 NUMBER
751 , p6_a49 VARCHAR2
752 , p6_a50 NUMBER
753 , p6_a51 VARCHAR2
754 , p6_a52 NUMBER
755 , p6_a53 NUMBER
756 , p6_a54 NUMBER
757 , p6_a55 VARCHAR2
758 , p6_a56 VARCHAR2
759 , p6_a57 VARCHAR2
760 , p6_a58 VARCHAR2
761 , p6_a59 VARCHAR2
762 , p6_a60 VARCHAR2
763 , p6_a61 VARCHAR2
764 , p6_a62 VARCHAR2
765 , p6_a63 VARCHAR2
766 , p6_a64 VARCHAR2
767 , p6_a65 VARCHAR2
768 , p6_a66 VARCHAR2
769 , p6_a67 VARCHAR2
770 , p6_a68 VARCHAR2
771 , p6_a69 VARCHAR2
772 , p6_a70 VARCHAR2
773 , p6_a71 VARCHAR2
774 , p6_a72 VARCHAR2
775 , p6_a73 VARCHAR2
776 , p6_a74 VARCHAR2
777 , p6_a75 VARCHAR2
778 , p6_a76 NUMBER
779 , p6_a77 VARCHAR2
780 , p6_a78 VARCHAR2
781 , p6_a79 DATE
782 , p6_a80 VARCHAR2
783 , p6_a81 NUMBER
784 , p6_a82 NUMBER
785 , p6_a83 NUMBER
786 , p6_a84 VARCHAR2
787 , p6_a85 VARCHAR2
788 , p6_a86 DATE
789 , p6_a87 NUMBER
790 , p6_a88 NUMBER
791 , p6_a89 VARCHAR2
792 , p6_a90 NUMBER
793 , p6_a91 VARCHAR2
794 , p_object_attribute VARCHAR2
795 , x_create_hist_flag out nocopy VARCHAR2
796 )
797
798 as
799 ddp_claim_line_rec ozf_claim_line_pvt.claim_line_rec_type;
800 ddindx binary_integer; indx binary_integer;
801 begin
802
803 -- copy data to the local IN or IN-OUT args, if any
804
805
806
807
808
809
810 ddp_claim_line_rec.claim_line_id := p6_a0;
811 ddp_claim_line_rec.object_version_number := p6_a1;
812 ddp_claim_line_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a2);
813 ddp_claim_line_rec.last_updated_by := p6_a3;
814 ddp_claim_line_rec.creation_date := rosetta_g_miss_date_in_map(p6_a4);
815 ddp_claim_line_rec.created_by := p6_a5;
816 ddp_claim_line_rec.last_update_login := p6_a6;
817 ddp_claim_line_rec.request_id := p6_a7;
818 ddp_claim_line_rec.program_application_id := p6_a8;
819 ddp_claim_line_rec.program_update_date := rosetta_g_miss_date_in_map(p6_a9);
820 ddp_claim_line_rec.program_id := p6_a10;
821 ddp_claim_line_rec.created_from := p6_a11;
822 ddp_claim_line_rec.claim_id := p6_a12;
823 ddp_claim_line_rec.line_number := p6_a13;
824 ddp_claim_line_rec.split_from_claim_line_id := p6_a14;
825 ddp_claim_line_rec.amount := p6_a15;
826 ddp_claim_line_rec.claim_currency_amount := p6_a16;
827 ddp_claim_line_rec.acctd_amount := p6_a17;
828 ddp_claim_line_rec.currency_code := p6_a18;
829 ddp_claim_line_rec.exchange_rate_type := p6_a19;
830 ddp_claim_line_rec.exchange_rate_date := rosetta_g_miss_date_in_map(p6_a20);
831 ddp_claim_line_rec.exchange_rate := p6_a21;
832 ddp_claim_line_rec.set_of_books_id := p6_a22;
833 ddp_claim_line_rec.valid_flag := p6_a23;
834 ddp_claim_line_rec.source_object_id := p6_a24;
835 ddp_claim_line_rec.source_object_line_id := p6_a25;
836 ddp_claim_line_rec.source_object_class := p6_a26;
837 ddp_claim_line_rec.source_object_type_id := p6_a27;
838 ddp_claim_line_rec.plan_id := p6_a28;
839 ddp_claim_line_rec.offer_id := p6_a29;
840 ddp_claim_line_rec.utilization_id := p6_a30;
841 ddp_claim_line_rec.payment_method := p6_a31;
842 ddp_claim_line_rec.payment_reference_id := p6_a32;
843 ddp_claim_line_rec.payment_reference_number := p6_a33;
844 ddp_claim_line_rec.payment_reference_date := rosetta_g_miss_date_in_map(p6_a34);
845 ddp_claim_line_rec.voucher_id := p6_a35;
846 ddp_claim_line_rec.voucher_number := p6_a36;
847 ddp_claim_line_rec.payment_status := p6_a37;
848 ddp_claim_line_rec.approved_flag := p6_a38;
849 ddp_claim_line_rec.approved_date := rosetta_g_miss_date_in_map(p6_a39);
850 ddp_claim_line_rec.approved_by := p6_a40;
851 ddp_claim_line_rec.settled_date := rosetta_g_miss_date_in_map(p6_a41);
852 ddp_claim_line_rec.settled_by := p6_a42;
853 ddp_claim_line_rec.performance_complete_flag := p6_a43;
854 ddp_claim_line_rec.performance_attached_flag := p6_a44;
855 ddp_claim_line_rec.select_cust_children_flag := p6_a45;
856 ddp_claim_line_rec.item_id := p6_a46;
857 ddp_claim_line_rec.item_description := p6_a47;
858 ddp_claim_line_rec.quantity := p6_a48;
859 ddp_claim_line_rec.quantity_uom := p6_a49;
860 ddp_claim_line_rec.rate := p6_a50;
861 ddp_claim_line_rec.activity_type := p6_a51;
862 ddp_claim_line_rec.activity_id := p6_a52;
863 ddp_claim_line_rec.related_cust_account_id := p6_a53;
864 ddp_claim_line_rec.buy_group_cust_account_id := p6_a54;
865 ddp_claim_line_rec.relationship_type := p6_a55;
866 ddp_claim_line_rec.earnings_associated_flag := p6_a56;
867 ddp_claim_line_rec.comments := p6_a57;
868 ddp_claim_line_rec.tax_code := p6_a58;
869 ddp_claim_line_rec.credit_to := p6_a59;
870 ddp_claim_line_rec.attribute_category := p6_a60;
871 ddp_claim_line_rec.attribute1 := p6_a61;
872 ddp_claim_line_rec.attribute2 := p6_a62;
873 ddp_claim_line_rec.attribute3 := p6_a63;
874 ddp_claim_line_rec.attribute4 := p6_a64;
875 ddp_claim_line_rec.attribute5 := p6_a65;
876 ddp_claim_line_rec.attribute6 := p6_a66;
877 ddp_claim_line_rec.attribute7 := p6_a67;
878 ddp_claim_line_rec.attribute8 := p6_a68;
879 ddp_claim_line_rec.attribute9 := p6_a69;
880 ddp_claim_line_rec.attribute10 := p6_a70;
881 ddp_claim_line_rec.attribute11 := p6_a71;
882 ddp_claim_line_rec.attribute12 := p6_a72;
883 ddp_claim_line_rec.attribute13 := p6_a73;
884 ddp_claim_line_rec.attribute14 := p6_a74;
885 ddp_claim_line_rec.attribute15 := p6_a75;
886 ddp_claim_line_rec.org_id := p6_a76;
887 ddp_claim_line_rec.update_from_tbl_flag := p6_a77;
888 ddp_claim_line_rec.tax_action := p6_a78;
889 ddp_claim_line_rec.sale_date := rosetta_g_miss_date_in_map(p6_a79);
890 ddp_claim_line_rec.item_type := p6_a80;
891 ddp_claim_line_rec.tax_amount := p6_a81;
892 ddp_claim_line_rec.claim_curr_tax_amount := p6_a82;
893 ddp_claim_line_rec.activity_line_id := p6_a83;
894 ddp_claim_line_rec.offer_type := p6_a84;
895 ddp_claim_line_rec.prorate_earnings_flag := p6_a85;
896 ddp_claim_line_rec.earnings_end_date := rosetta_g_miss_date_in_map(p6_a86);
897 ddp_claim_line_rec.buy_group_party_id := p6_a87;
898 ddp_claim_line_rec.acctd_tax_amount := p6_a88;
899 ddp_claim_line_rec.dpp_cust_account_id := p6_a89;
900 ddp_claim_line_rec.batch_line_id := p6_a90;
901 ddp_claim_line_rec.activity_name := p6_a91;
902
903
904
905 -- here's the delegated call to the old PL/SQL routine
906 ozf_claim_line_pvt.check_create_line_hist(p_api_version,
907 p_init_msg_list,
908 x_return_status,
909 x_msg_count,
910 x_msg_data,
911 p_mode,
912 ddp_claim_line_rec,
913 p_object_attribute,
914 x_create_hist_flag);
915
916 -- copy data back from the local variables to OUT or IN-OUT args, if any
917
918
919
920
921
922
923
924
925 end;
926
927 procedure create_claim_line_tbl(p_api_version NUMBER
928 , p_init_msg_list VARCHAR2
929 , p_commit VARCHAR2
930 , p_validation_level NUMBER
931 , x_return_status out nocopy VARCHAR2
932 , x_msg_data out nocopy VARCHAR2
933 , x_msg_count out nocopy NUMBER
934 , p7_a0 in out nocopy JTF_NUMBER_TABLE
935 , p7_a1 in out nocopy JTF_NUMBER_TABLE
936 , p7_a2 in out nocopy JTF_DATE_TABLE
937 , p7_a3 in out nocopy JTF_NUMBER_TABLE
938 , p7_a4 in out nocopy JTF_DATE_TABLE
939 , p7_a5 in out nocopy JTF_NUMBER_TABLE
940 , p7_a6 in out nocopy JTF_NUMBER_TABLE
941 , p7_a7 in out nocopy JTF_NUMBER_TABLE
942 , p7_a8 in out nocopy JTF_NUMBER_TABLE
943 , p7_a9 in out nocopy JTF_DATE_TABLE
944 , p7_a10 in out nocopy JTF_NUMBER_TABLE
945 , p7_a11 in out nocopy JTF_VARCHAR2_TABLE_100
946 , p7_a12 in out nocopy JTF_NUMBER_TABLE
947 , p7_a13 in out nocopy JTF_NUMBER_TABLE
948 , p7_a14 in out nocopy JTF_NUMBER_TABLE
949 , p7_a15 in out nocopy JTF_NUMBER_TABLE
950 , p7_a16 in out nocopy JTF_NUMBER_TABLE
951 , p7_a17 in out nocopy JTF_NUMBER_TABLE
952 , p7_a18 in out nocopy JTF_VARCHAR2_TABLE_100
953 , p7_a19 in out nocopy JTF_VARCHAR2_TABLE_100
954 , p7_a20 in out nocopy JTF_DATE_TABLE
955 , p7_a21 in out nocopy JTF_NUMBER_TABLE
956 , p7_a22 in out nocopy JTF_NUMBER_TABLE
957 , p7_a23 in out nocopy JTF_VARCHAR2_TABLE_100
958 , p7_a24 in out nocopy JTF_NUMBER_TABLE
959 , p7_a25 in out nocopy JTF_NUMBER_TABLE
960 , p7_a26 in out nocopy JTF_VARCHAR2_TABLE_100
961 , p7_a27 in out nocopy JTF_NUMBER_TABLE
962 , p7_a28 in out nocopy JTF_NUMBER_TABLE
963 , p7_a29 in out nocopy JTF_NUMBER_TABLE
964 , p7_a30 in out nocopy JTF_NUMBER_TABLE
965 , p7_a31 in out nocopy JTF_VARCHAR2_TABLE_100
966 , p7_a32 in out nocopy JTF_NUMBER_TABLE
967 , p7_a33 in out nocopy JTF_VARCHAR2_TABLE_100
968 , p7_a34 in out nocopy JTF_DATE_TABLE
969 , p7_a35 in out nocopy JTF_NUMBER_TABLE
970 , p7_a36 in out nocopy JTF_VARCHAR2_TABLE_100
971 , p7_a37 in out nocopy JTF_VARCHAR2_TABLE_100
972 , p7_a38 in out nocopy JTF_VARCHAR2_TABLE_100
973 , p7_a39 in out nocopy JTF_DATE_TABLE
974 , p7_a40 in out nocopy JTF_NUMBER_TABLE
975 , p7_a41 in out nocopy JTF_DATE_TABLE
976 , p7_a42 in out nocopy JTF_NUMBER_TABLE
977 , p7_a43 in out nocopy JTF_VARCHAR2_TABLE_100
978 , p7_a44 in out nocopy JTF_VARCHAR2_TABLE_100
979 , p7_a45 in out nocopy JTF_VARCHAR2_TABLE_100
980 , p7_a46 in out nocopy JTF_NUMBER_TABLE
981 , p7_a47 in out nocopy JTF_VARCHAR2_TABLE_300
982 , p7_a48 in out nocopy JTF_NUMBER_TABLE
983 , p7_a49 in out nocopy JTF_VARCHAR2_TABLE_100
984 , p7_a50 in out nocopy JTF_NUMBER_TABLE
985 , p7_a51 in out nocopy JTF_VARCHAR2_TABLE_100
986 , p7_a52 in out nocopy JTF_NUMBER_TABLE
987 , p7_a53 in out nocopy JTF_NUMBER_TABLE
988 , p7_a54 in out nocopy JTF_NUMBER_TABLE
989 , p7_a55 in out nocopy JTF_VARCHAR2_TABLE_100
990 , p7_a56 in out nocopy JTF_VARCHAR2_TABLE_100
991 , p7_a57 in out nocopy JTF_VARCHAR2_TABLE_2000
992 , p7_a58 in out nocopy JTF_VARCHAR2_TABLE_100
993 , p7_a59 in out nocopy JTF_VARCHAR2_TABLE_100
994 , p7_a60 in out nocopy JTF_VARCHAR2_TABLE_100
995 , p7_a61 in out nocopy JTF_VARCHAR2_TABLE_200
996 , p7_a62 in out nocopy JTF_VARCHAR2_TABLE_200
997 , p7_a63 in out nocopy JTF_VARCHAR2_TABLE_200
998 , p7_a64 in out nocopy JTF_VARCHAR2_TABLE_200
999 , p7_a65 in out nocopy JTF_VARCHAR2_TABLE_200
1000 , p7_a66 in out nocopy JTF_VARCHAR2_TABLE_200
1001 , p7_a67 in out nocopy JTF_VARCHAR2_TABLE_200
1002 , p7_a68 in out nocopy JTF_VARCHAR2_TABLE_200
1003 , p7_a69 in out nocopy JTF_VARCHAR2_TABLE_200
1004 , p7_a70 in out nocopy JTF_VARCHAR2_TABLE_200
1005 , p7_a71 in out nocopy JTF_VARCHAR2_TABLE_200
1006 , p7_a72 in out nocopy JTF_VARCHAR2_TABLE_200
1007 , p7_a73 in out nocopy JTF_VARCHAR2_TABLE_200
1008 , p7_a74 in out nocopy JTF_VARCHAR2_TABLE_200
1009 , p7_a75 in out nocopy JTF_VARCHAR2_TABLE_200
1010 , p7_a76 in out nocopy JTF_NUMBER_TABLE
1011 , p7_a77 in out nocopy JTF_VARCHAR2_TABLE_100
1012 , p7_a78 in out nocopy JTF_VARCHAR2_TABLE_100
1013 , p7_a79 in out nocopy JTF_DATE_TABLE
1014 , p7_a80 in out nocopy JTF_VARCHAR2_TABLE_100
1015 , p7_a81 in out nocopy JTF_NUMBER_TABLE
1016 , p7_a82 in out nocopy JTF_NUMBER_TABLE
1017 , p7_a83 in out nocopy JTF_NUMBER_TABLE
1018 , p7_a84 in out nocopy JTF_VARCHAR2_TABLE_100
1019 , p7_a85 in out nocopy JTF_VARCHAR2_TABLE_100
1020 , p7_a86 in out nocopy JTF_DATE_TABLE
1021 , p7_a87 in out nocopy JTF_NUMBER_TABLE
1022 , p7_a88 in out nocopy JTF_NUMBER_TABLE
1023 , p7_a89 in out nocopy JTF_VARCHAR2_TABLE_100
1024 , p7_a90 in out nocopy JTF_NUMBER_TABLE
1025 , p7_a91 in out nocopy JTF_VARCHAR2_TABLE_2000
1026 , p_mode VARCHAR2
1027 , x_error_index out nocopy NUMBER
1028 )
1029
1030 as
1031 ddp_claim_line_tbl ozf_claim_line_pvt.claim_line_tbl_type;
1032 ddindx binary_integer; indx binary_integer;
1033 begin
1034
1035 -- copy data to the local IN or IN-OUT args, if any
1036
1037
1038
1039
1040
1041
1042
1043 ozf_claim_line_pvt_w.rosetta_table_copy_in_p1(ddp_claim_line_tbl, p7_a0
1044 , p7_a1
1045 , p7_a2
1046 , p7_a3
1047 , p7_a4
1048 , p7_a5
1049 , p7_a6
1050 , p7_a7
1051 , p7_a8
1052 , p7_a9
1053 , p7_a10
1054 , p7_a11
1055 , p7_a12
1056 , p7_a13
1057 , p7_a14
1058 , p7_a15
1059 , p7_a16
1060 , p7_a17
1061 , p7_a18
1062 , p7_a19
1063 , p7_a20
1064 , p7_a21
1065 , p7_a22
1066 , p7_a23
1067 , p7_a24
1068 , p7_a25
1069 , p7_a26
1070 , p7_a27
1071 , p7_a28
1072 , p7_a29
1073 , p7_a30
1074 , p7_a31
1075 , p7_a32
1076 , p7_a33
1077 , p7_a34
1078 , p7_a35
1079 , p7_a36
1080 , p7_a37
1081 , p7_a38
1082 , p7_a39
1083 , p7_a40
1084 , p7_a41
1085 , p7_a42
1086 , p7_a43
1087 , p7_a44
1088 , p7_a45
1089 , p7_a46
1090 , p7_a47
1091 , p7_a48
1092 , p7_a49
1093 , p7_a50
1094 , p7_a51
1095 , p7_a52
1096 , p7_a53
1097 , p7_a54
1098 , p7_a55
1099 , p7_a56
1100 , p7_a57
1101 , p7_a58
1102 , p7_a59
1103 , p7_a60
1104 , p7_a61
1105 , p7_a62
1106 , p7_a63
1107 , p7_a64
1108 , p7_a65
1109 , p7_a66
1110 , p7_a67
1111 , p7_a68
1112 , p7_a69
1113 , p7_a70
1114 , p7_a71
1115 , p7_a72
1116 , p7_a73
1117 , p7_a74
1118 , p7_a75
1119 , p7_a76
1120 , p7_a77
1121 , p7_a78
1122 , p7_a79
1123 , p7_a80
1124 , p7_a81
1125 , p7_a82
1126 , p7_a83
1127 , p7_a84
1128 , p7_a85
1129 , p7_a86
1130 , p7_a87
1131 , p7_a88
1132 , p7_a89
1133 , p7_a90
1134 , p7_a91
1135 );
1136
1137
1138
1139 -- here's the delegated call to the old PL/SQL routine
1140 ozf_claim_line_pvt.create_claim_line_tbl(p_api_version,
1141 p_init_msg_list,
1142 p_commit,
1143 p_validation_level,
1144 x_return_status,
1145 x_msg_data,
1146 x_msg_count,
1147 ddp_claim_line_tbl,
1148 p_mode,
1149 x_error_index);
1150
1151 -- copy data back from the local variables to OUT or IN-OUT args, if any
1152
1153
1154
1155
1156
1157
1158
1159 ozf_claim_line_pvt_w.rosetta_table_copy_out_p1(ddp_claim_line_tbl, p7_a0
1160 , p7_a1
1161 , p7_a2
1162 , p7_a3
1163 , p7_a4
1164 , p7_a5
1165 , p7_a6
1166 , p7_a7
1167 , p7_a8
1168 , p7_a9
1169 , p7_a10
1170 , p7_a11
1171 , p7_a12
1172 , p7_a13
1173 , p7_a14
1174 , p7_a15
1175 , p7_a16
1176 , p7_a17
1177 , p7_a18
1178 , p7_a19
1179 , p7_a20
1180 , p7_a21
1181 , p7_a22
1182 , p7_a23
1183 , p7_a24
1184 , p7_a25
1185 , p7_a26
1186 , p7_a27
1187 , p7_a28
1188 , p7_a29
1189 , p7_a30
1190 , p7_a31
1191 , p7_a32
1192 , p7_a33
1193 , p7_a34
1194 , p7_a35
1195 , p7_a36
1196 , p7_a37
1197 , p7_a38
1198 , p7_a39
1199 , p7_a40
1200 , p7_a41
1201 , p7_a42
1202 , p7_a43
1203 , p7_a44
1204 , p7_a45
1205 , p7_a46
1206 , p7_a47
1207 , p7_a48
1208 , p7_a49
1209 , p7_a50
1210 , p7_a51
1211 , p7_a52
1212 , p7_a53
1213 , p7_a54
1214 , p7_a55
1215 , p7_a56
1216 , p7_a57
1217 , p7_a58
1218 , p7_a59
1219 , p7_a60
1220 , p7_a61
1221 , p7_a62
1222 , p7_a63
1223 , p7_a64
1224 , p7_a65
1225 , p7_a66
1226 , p7_a67
1227 , p7_a68
1228 , p7_a69
1229 , p7_a70
1230 , p7_a71
1231 , p7_a72
1232 , p7_a73
1233 , p7_a74
1234 , p7_a75
1235 , p7_a76
1236 , p7_a77
1237 , p7_a78
1238 , p7_a79
1239 , p7_a80
1240 , p7_a81
1241 , p7_a82
1242 , p7_a83
1243 , p7_a84
1244 , p7_a85
1245 , p7_a86
1246 , p7_a87
1247 , p7_a88
1248 , p7_a89
1249 , p7_a90
1250 , p7_a91
1251 );
1252
1253
1254 end;
1255
1256 procedure create_claim_line(p_api_version NUMBER
1257 , p_init_msg_list VARCHAR2
1258 , p_commit VARCHAR2
1259 , p_validation_level NUMBER
1260 , x_return_status out nocopy VARCHAR2
1261 , x_msg_count out nocopy NUMBER
1262 , x_msg_data out nocopy VARCHAR2
1263 , p7_a0 NUMBER
1264 , p7_a1 NUMBER
1265 , p7_a2 DATE
1266 , p7_a3 NUMBER
1267 , p7_a4 DATE
1268 , p7_a5 NUMBER
1269 , p7_a6 NUMBER
1270 , p7_a7 NUMBER
1271 , p7_a8 NUMBER
1272 , p7_a9 DATE
1273 , p7_a10 NUMBER
1274 , p7_a11 VARCHAR2
1275 , p7_a12 NUMBER
1276 , p7_a13 NUMBER
1277 , p7_a14 NUMBER
1278 , p7_a15 NUMBER
1279 , p7_a16 NUMBER
1280 , p7_a17 NUMBER
1281 , p7_a18 VARCHAR2
1282 , p7_a19 VARCHAR2
1283 , p7_a20 DATE
1284 , p7_a21 NUMBER
1285 , p7_a22 NUMBER
1286 , p7_a23 VARCHAR2
1287 , p7_a24 NUMBER
1288 , p7_a25 NUMBER
1289 , p7_a26 VARCHAR2
1290 , p7_a27 NUMBER
1291 , p7_a28 NUMBER
1292 , p7_a29 NUMBER
1293 , p7_a30 NUMBER
1294 , p7_a31 VARCHAR2
1295 , p7_a32 NUMBER
1296 , p7_a33 VARCHAR2
1297 , p7_a34 DATE
1298 , p7_a35 NUMBER
1299 , p7_a36 VARCHAR2
1300 , p7_a37 VARCHAR2
1301 , p7_a38 VARCHAR2
1302 , p7_a39 DATE
1303 , p7_a40 NUMBER
1304 , p7_a41 DATE
1305 , p7_a42 NUMBER
1306 , p7_a43 VARCHAR2
1307 , p7_a44 VARCHAR2
1308 , p7_a45 VARCHAR2
1309 , p7_a46 NUMBER
1310 , p7_a47 VARCHAR2
1311 , p7_a48 NUMBER
1312 , p7_a49 VARCHAR2
1313 , p7_a50 NUMBER
1314 , p7_a51 VARCHAR2
1315 , p7_a52 NUMBER
1316 , p7_a53 NUMBER
1317 , p7_a54 NUMBER
1318 , p7_a55 VARCHAR2
1319 , p7_a56 VARCHAR2
1320 , p7_a57 VARCHAR2
1321 , p7_a58 VARCHAR2
1322 , p7_a59 VARCHAR2
1323 , p7_a60 VARCHAR2
1324 , p7_a61 VARCHAR2
1325 , p7_a62 VARCHAR2
1326 , p7_a63 VARCHAR2
1327 , p7_a64 VARCHAR2
1328 , p7_a65 VARCHAR2
1329 , p7_a66 VARCHAR2
1330 , p7_a67 VARCHAR2
1331 , p7_a68 VARCHAR2
1332 , p7_a69 VARCHAR2
1333 , p7_a70 VARCHAR2
1334 , p7_a71 VARCHAR2
1335 , p7_a72 VARCHAR2
1336 , p7_a73 VARCHAR2
1337 , p7_a74 VARCHAR2
1338 , p7_a75 VARCHAR2
1339 , p7_a76 NUMBER
1340 , p7_a77 VARCHAR2
1341 , p7_a78 VARCHAR2
1342 , p7_a79 DATE
1343 , p7_a80 VARCHAR2
1344 , p7_a81 NUMBER
1345 , p7_a82 NUMBER
1346 , p7_a83 NUMBER
1347 , p7_a84 VARCHAR2
1348 , p7_a85 VARCHAR2
1349 , p7_a86 DATE
1350 , p7_a87 NUMBER
1351 , p7_a88 NUMBER
1352 , p7_a89 VARCHAR2
1353 , p7_a90 NUMBER
1354 , p7_a91 VARCHAR2
1355 , p_mode VARCHAR2
1356 , x_claim_line_id out nocopy NUMBER
1357 )
1358
1359 as
1360 ddp_claim_line_rec ozf_claim_line_pvt.claim_line_rec_type;
1361 ddindx binary_integer; indx binary_integer;
1362 begin
1363
1364 -- copy data to the local IN or IN-OUT args, if any
1365
1366
1367
1368
1369
1370
1371
1372 ddp_claim_line_rec.claim_line_id := p7_a0;
1373 ddp_claim_line_rec.object_version_number := p7_a1;
1374 ddp_claim_line_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a2);
1375 ddp_claim_line_rec.last_updated_by := p7_a3;
1376 ddp_claim_line_rec.creation_date := rosetta_g_miss_date_in_map(p7_a4);
1377 ddp_claim_line_rec.created_by := p7_a5;
1378 ddp_claim_line_rec.last_update_login := p7_a6;
1379 ddp_claim_line_rec.request_id := p7_a7;
1380 ddp_claim_line_rec.program_application_id := p7_a8;
1381 ddp_claim_line_rec.program_update_date := rosetta_g_miss_date_in_map(p7_a9);
1382 ddp_claim_line_rec.program_id := p7_a10;
1383 ddp_claim_line_rec.created_from := p7_a11;
1384 ddp_claim_line_rec.claim_id := p7_a12;
1385 ddp_claim_line_rec.line_number := p7_a13;
1386 ddp_claim_line_rec.split_from_claim_line_id := p7_a14;
1387 ddp_claim_line_rec.amount := p7_a15;
1388 ddp_claim_line_rec.claim_currency_amount := p7_a16;
1389 ddp_claim_line_rec.acctd_amount := p7_a17;
1390 ddp_claim_line_rec.currency_code := p7_a18;
1391 ddp_claim_line_rec.exchange_rate_type := p7_a19;
1392 ddp_claim_line_rec.exchange_rate_date := rosetta_g_miss_date_in_map(p7_a20);
1393 ddp_claim_line_rec.exchange_rate := p7_a21;
1394 ddp_claim_line_rec.set_of_books_id := p7_a22;
1395 ddp_claim_line_rec.valid_flag := p7_a23;
1396 ddp_claim_line_rec.source_object_id := p7_a24;
1397 ddp_claim_line_rec.source_object_line_id := p7_a25;
1398 ddp_claim_line_rec.source_object_class := p7_a26;
1399 ddp_claim_line_rec.source_object_type_id := p7_a27;
1400 ddp_claim_line_rec.plan_id := p7_a28;
1401 ddp_claim_line_rec.offer_id := p7_a29;
1402 ddp_claim_line_rec.utilization_id := p7_a30;
1403 ddp_claim_line_rec.payment_method := p7_a31;
1404 ddp_claim_line_rec.payment_reference_id := p7_a32;
1405 ddp_claim_line_rec.payment_reference_number := p7_a33;
1406 ddp_claim_line_rec.payment_reference_date := rosetta_g_miss_date_in_map(p7_a34);
1407 ddp_claim_line_rec.voucher_id := p7_a35;
1408 ddp_claim_line_rec.voucher_number := p7_a36;
1409 ddp_claim_line_rec.payment_status := p7_a37;
1410 ddp_claim_line_rec.approved_flag := p7_a38;
1411 ddp_claim_line_rec.approved_date := rosetta_g_miss_date_in_map(p7_a39);
1412 ddp_claim_line_rec.approved_by := p7_a40;
1413 ddp_claim_line_rec.settled_date := rosetta_g_miss_date_in_map(p7_a41);
1414 ddp_claim_line_rec.settled_by := p7_a42;
1415 ddp_claim_line_rec.performance_complete_flag := p7_a43;
1416 ddp_claim_line_rec.performance_attached_flag := p7_a44;
1417 ddp_claim_line_rec.select_cust_children_flag := p7_a45;
1418 ddp_claim_line_rec.item_id := p7_a46;
1419 ddp_claim_line_rec.item_description := p7_a47;
1420 ddp_claim_line_rec.quantity := p7_a48;
1421 ddp_claim_line_rec.quantity_uom := p7_a49;
1422 ddp_claim_line_rec.rate := p7_a50;
1423 ddp_claim_line_rec.activity_type := p7_a51;
1424 ddp_claim_line_rec.activity_id := p7_a52;
1425 ddp_claim_line_rec.related_cust_account_id := p7_a53;
1426 ddp_claim_line_rec.buy_group_cust_account_id := p7_a54;
1427 ddp_claim_line_rec.relationship_type := p7_a55;
1428 ddp_claim_line_rec.earnings_associated_flag := p7_a56;
1429 ddp_claim_line_rec.comments := p7_a57;
1430 ddp_claim_line_rec.tax_code := p7_a58;
1431 ddp_claim_line_rec.credit_to := p7_a59;
1432 ddp_claim_line_rec.attribute_category := p7_a60;
1433 ddp_claim_line_rec.attribute1 := p7_a61;
1434 ddp_claim_line_rec.attribute2 := p7_a62;
1435 ddp_claim_line_rec.attribute3 := p7_a63;
1436 ddp_claim_line_rec.attribute4 := p7_a64;
1437 ddp_claim_line_rec.attribute5 := p7_a65;
1438 ddp_claim_line_rec.attribute6 := p7_a66;
1439 ddp_claim_line_rec.attribute7 := p7_a67;
1440 ddp_claim_line_rec.attribute8 := p7_a68;
1441 ddp_claim_line_rec.attribute9 := p7_a69;
1442 ddp_claim_line_rec.attribute10 := p7_a70;
1443 ddp_claim_line_rec.attribute11 := p7_a71;
1444 ddp_claim_line_rec.attribute12 := p7_a72;
1445 ddp_claim_line_rec.attribute13 := p7_a73;
1446 ddp_claim_line_rec.attribute14 := p7_a74;
1447 ddp_claim_line_rec.attribute15 := p7_a75;
1448 ddp_claim_line_rec.org_id := p7_a76;
1449 ddp_claim_line_rec.update_from_tbl_flag := p7_a77;
1450 ddp_claim_line_rec.tax_action := p7_a78;
1451 ddp_claim_line_rec.sale_date := rosetta_g_miss_date_in_map(p7_a79);
1452 ddp_claim_line_rec.item_type := p7_a80;
1453 ddp_claim_line_rec.tax_amount := p7_a81;
1454 ddp_claim_line_rec.claim_curr_tax_amount := p7_a82;
1455 ddp_claim_line_rec.activity_line_id := p7_a83;
1456 ddp_claim_line_rec.offer_type := p7_a84;
1457 ddp_claim_line_rec.prorate_earnings_flag := p7_a85;
1458 ddp_claim_line_rec.earnings_end_date := rosetta_g_miss_date_in_map(p7_a86);
1459 ddp_claim_line_rec.buy_group_party_id := p7_a87;
1460 ddp_claim_line_rec.acctd_tax_amount := p7_a88;
1461 ddp_claim_line_rec.dpp_cust_account_id := p7_a89;
1462 ddp_claim_line_rec.batch_line_id := p7_a90;
1463 ddp_claim_line_rec.activity_name := p7_a91;
1464
1465
1466
1467 -- here's the delegated call to the old PL/SQL routine
1468 ozf_claim_line_pvt.create_claim_line(p_api_version,
1469 p_init_msg_list,
1470 p_commit,
1471 p_validation_level,
1472 x_return_status,
1473 x_msg_count,
1474 x_msg_data,
1475 ddp_claim_line_rec,
1476 p_mode,
1477 x_claim_line_id);
1478
1479 -- copy data back from the local variables to OUT or IN-OUT args, if any
1480
1481
1482
1483
1484
1485
1486
1487
1488
1489 end;
1490
1491 procedure delete_claim_line_tbl(p_api_version NUMBER
1492 , p_init_msg_list VARCHAR2
1493 , p_commit VARCHAR2
1494 , p_validation_level NUMBER
1495 , x_return_status out nocopy VARCHAR2
1496 , x_msg_data out nocopy VARCHAR2
1497 , x_msg_count out nocopy NUMBER
1498 , p7_a0 JTF_NUMBER_TABLE
1499 , p7_a1 JTF_NUMBER_TABLE
1500 , p7_a2 JTF_DATE_TABLE
1501 , p7_a3 JTF_NUMBER_TABLE
1502 , p7_a4 JTF_DATE_TABLE
1503 , p7_a5 JTF_NUMBER_TABLE
1504 , p7_a6 JTF_NUMBER_TABLE
1505 , p7_a7 JTF_NUMBER_TABLE
1506 , p7_a8 JTF_NUMBER_TABLE
1507 , p7_a9 JTF_DATE_TABLE
1508 , p7_a10 JTF_NUMBER_TABLE
1509 , p7_a11 JTF_VARCHAR2_TABLE_100
1510 , p7_a12 JTF_NUMBER_TABLE
1511 , p7_a13 JTF_NUMBER_TABLE
1512 , p7_a14 JTF_NUMBER_TABLE
1513 , p7_a15 JTF_NUMBER_TABLE
1514 , p7_a16 JTF_NUMBER_TABLE
1515 , p7_a17 JTF_NUMBER_TABLE
1516 , p7_a18 JTF_VARCHAR2_TABLE_100
1517 , p7_a19 JTF_VARCHAR2_TABLE_100
1518 , p7_a20 JTF_DATE_TABLE
1519 , p7_a21 JTF_NUMBER_TABLE
1520 , p7_a22 JTF_NUMBER_TABLE
1521 , p7_a23 JTF_VARCHAR2_TABLE_100
1522 , p7_a24 JTF_NUMBER_TABLE
1523 , p7_a25 JTF_NUMBER_TABLE
1524 , p7_a26 JTF_VARCHAR2_TABLE_100
1525 , p7_a27 JTF_NUMBER_TABLE
1526 , p7_a28 JTF_NUMBER_TABLE
1527 , p7_a29 JTF_NUMBER_TABLE
1528 , p7_a30 JTF_NUMBER_TABLE
1529 , p7_a31 JTF_VARCHAR2_TABLE_100
1530 , p7_a32 JTF_NUMBER_TABLE
1531 , p7_a33 JTF_VARCHAR2_TABLE_100
1532 , p7_a34 JTF_DATE_TABLE
1533 , p7_a35 JTF_NUMBER_TABLE
1534 , p7_a36 JTF_VARCHAR2_TABLE_100
1535 , p7_a37 JTF_VARCHAR2_TABLE_100
1536 , p7_a38 JTF_VARCHAR2_TABLE_100
1537 , p7_a39 JTF_DATE_TABLE
1538 , p7_a40 JTF_NUMBER_TABLE
1539 , p7_a41 JTF_DATE_TABLE
1540 , p7_a42 JTF_NUMBER_TABLE
1541 , p7_a43 JTF_VARCHAR2_TABLE_100
1542 , p7_a44 JTF_VARCHAR2_TABLE_100
1543 , p7_a45 JTF_VARCHAR2_TABLE_100
1544 , p7_a46 JTF_NUMBER_TABLE
1545 , p7_a47 JTF_VARCHAR2_TABLE_300
1546 , p7_a48 JTF_NUMBER_TABLE
1547 , p7_a49 JTF_VARCHAR2_TABLE_100
1548 , p7_a50 JTF_NUMBER_TABLE
1549 , p7_a51 JTF_VARCHAR2_TABLE_100
1550 , p7_a52 JTF_NUMBER_TABLE
1551 , p7_a53 JTF_NUMBER_TABLE
1552 , p7_a54 JTF_NUMBER_TABLE
1553 , p7_a55 JTF_VARCHAR2_TABLE_100
1554 , p7_a56 JTF_VARCHAR2_TABLE_100
1555 , p7_a57 JTF_VARCHAR2_TABLE_2000
1556 , p7_a58 JTF_VARCHAR2_TABLE_100
1557 , p7_a59 JTF_VARCHAR2_TABLE_100
1558 , p7_a60 JTF_VARCHAR2_TABLE_100
1559 , p7_a61 JTF_VARCHAR2_TABLE_200
1560 , p7_a62 JTF_VARCHAR2_TABLE_200
1561 , p7_a63 JTF_VARCHAR2_TABLE_200
1562 , p7_a64 JTF_VARCHAR2_TABLE_200
1563 , p7_a65 JTF_VARCHAR2_TABLE_200
1564 , p7_a66 JTF_VARCHAR2_TABLE_200
1565 , p7_a67 JTF_VARCHAR2_TABLE_200
1566 , p7_a68 JTF_VARCHAR2_TABLE_200
1567 , p7_a69 JTF_VARCHAR2_TABLE_200
1568 , p7_a70 JTF_VARCHAR2_TABLE_200
1569 , p7_a71 JTF_VARCHAR2_TABLE_200
1570 , p7_a72 JTF_VARCHAR2_TABLE_200
1571 , p7_a73 JTF_VARCHAR2_TABLE_200
1572 , p7_a74 JTF_VARCHAR2_TABLE_200
1573 , p7_a75 JTF_VARCHAR2_TABLE_200
1574 , p7_a76 JTF_NUMBER_TABLE
1575 , p7_a77 JTF_VARCHAR2_TABLE_100
1576 , p7_a78 JTF_VARCHAR2_TABLE_100
1577 , p7_a79 JTF_DATE_TABLE
1578 , p7_a80 JTF_VARCHAR2_TABLE_100
1579 , p7_a81 JTF_NUMBER_TABLE
1580 , p7_a82 JTF_NUMBER_TABLE
1581 , p7_a83 JTF_NUMBER_TABLE
1582 , p7_a84 JTF_VARCHAR2_TABLE_100
1583 , p7_a85 JTF_VARCHAR2_TABLE_100
1584 , p7_a86 JTF_DATE_TABLE
1585 , p7_a87 JTF_NUMBER_TABLE
1586 , p7_a88 JTF_NUMBER_TABLE
1587 , p7_a89 JTF_VARCHAR2_TABLE_100
1588 , p7_a90 JTF_NUMBER_TABLE
1589 , p7_a91 JTF_VARCHAR2_TABLE_2000
1590 , p_change_object_version VARCHAR2
1591 , p_mode VARCHAR2
1592 , x_error_index out nocopy NUMBER
1593 )
1594
1595 as
1596 ddp_claim_line_tbl ozf_claim_line_pvt.claim_line_tbl_type;
1597 ddindx binary_integer; indx binary_integer;
1598 begin
1599
1600 -- copy data to the local IN or IN-OUT args, if any
1601
1602
1603
1604
1605
1606
1607
1608 ozf_claim_line_pvt_w.rosetta_table_copy_in_p1(ddp_claim_line_tbl, p7_a0
1609 , p7_a1
1610 , p7_a2
1611 , p7_a3
1612 , p7_a4
1613 , p7_a5
1614 , p7_a6
1615 , p7_a7
1616 , p7_a8
1617 , p7_a9
1618 , p7_a10
1619 , p7_a11
1620 , p7_a12
1621 , p7_a13
1622 , p7_a14
1623 , p7_a15
1624 , p7_a16
1625 , p7_a17
1626 , p7_a18
1627 , p7_a19
1628 , p7_a20
1629 , p7_a21
1630 , p7_a22
1631 , p7_a23
1632 , p7_a24
1633 , p7_a25
1634 , p7_a26
1635 , p7_a27
1636 , p7_a28
1637 , p7_a29
1638 , p7_a30
1639 , p7_a31
1640 , p7_a32
1641 , p7_a33
1642 , p7_a34
1643 , p7_a35
1644 , p7_a36
1645 , p7_a37
1646 , p7_a38
1647 , p7_a39
1648 , p7_a40
1649 , p7_a41
1650 , p7_a42
1651 , p7_a43
1652 , p7_a44
1653 , p7_a45
1654 , p7_a46
1655 , p7_a47
1656 , p7_a48
1657 , p7_a49
1658 , p7_a50
1659 , p7_a51
1660 , p7_a52
1661 , p7_a53
1662 , p7_a54
1663 , p7_a55
1664 , p7_a56
1665 , p7_a57
1666 , p7_a58
1667 , p7_a59
1668 , p7_a60
1669 , p7_a61
1670 , p7_a62
1671 , p7_a63
1672 , p7_a64
1673 , p7_a65
1674 , p7_a66
1675 , p7_a67
1676 , p7_a68
1677 , p7_a69
1678 , p7_a70
1679 , p7_a71
1680 , p7_a72
1681 , p7_a73
1682 , p7_a74
1683 , p7_a75
1684 , p7_a76
1685 , p7_a77
1686 , p7_a78
1687 , p7_a79
1688 , p7_a80
1689 , p7_a81
1690 , p7_a82
1691 , p7_a83
1692 , p7_a84
1693 , p7_a85
1694 , p7_a86
1695 , p7_a87
1696 , p7_a88
1697 , p7_a89
1698 , p7_a90
1699 , p7_a91
1700 );
1701
1702
1703
1704
1705 -- here's the delegated call to the old PL/SQL routine
1706 ozf_claim_line_pvt.delete_claim_line_tbl(p_api_version,
1707 p_init_msg_list,
1708 p_commit,
1709 p_validation_level,
1710 x_return_status,
1711 x_msg_data,
1712 x_msg_count,
1713 ddp_claim_line_tbl,
1714 p_change_object_version,
1715 p_mode,
1716 x_error_index);
1717
1718 -- copy data back from the local variables to OUT or IN-OUT args, if any
1719
1720
1721
1722
1723
1724
1725
1726
1727
1728
1729 end;
1730
1731 procedure update_claim_line_tbl(p_api_version NUMBER
1732 , p_init_msg_list VARCHAR2
1733 , p_commit VARCHAR2
1734 , p_validation_level NUMBER
1735 , x_return_status out nocopy VARCHAR2
1736 , x_msg_data out nocopy VARCHAR2
1737 , x_msg_count out nocopy NUMBER
1738 , p7_a0 JTF_NUMBER_TABLE
1739 , p7_a1 JTF_NUMBER_TABLE
1740 , p7_a2 JTF_DATE_TABLE
1741 , p7_a3 JTF_NUMBER_TABLE
1742 , p7_a4 JTF_DATE_TABLE
1743 , p7_a5 JTF_NUMBER_TABLE
1744 , p7_a6 JTF_NUMBER_TABLE
1745 , p7_a7 JTF_NUMBER_TABLE
1746 , p7_a8 JTF_NUMBER_TABLE
1747 , p7_a9 JTF_DATE_TABLE
1748 , p7_a10 JTF_NUMBER_TABLE
1749 , p7_a11 JTF_VARCHAR2_TABLE_100
1750 , p7_a12 JTF_NUMBER_TABLE
1751 , p7_a13 JTF_NUMBER_TABLE
1752 , p7_a14 JTF_NUMBER_TABLE
1753 , p7_a15 JTF_NUMBER_TABLE
1754 , p7_a16 JTF_NUMBER_TABLE
1755 , p7_a17 JTF_NUMBER_TABLE
1756 , p7_a18 JTF_VARCHAR2_TABLE_100
1757 , p7_a19 JTF_VARCHAR2_TABLE_100
1758 , p7_a20 JTF_DATE_TABLE
1759 , p7_a21 JTF_NUMBER_TABLE
1760 , p7_a22 JTF_NUMBER_TABLE
1761 , p7_a23 JTF_VARCHAR2_TABLE_100
1762 , p7_a24 JTF_NUMBER_TABLE
1763 , p7_a25 JTF_NUMBER_TABLE
1764 , p7_a26 JTF_VARCHAR2_TABLE_100
1765 , p7_a27 JTF_NUMBER_TABLE
1766 , p7_a28 JTF_NUMBER_TABLE
1767 , p7_a29 JTF_NUMBER_TABLE
1768 , p7_a30 JTF_NUMBER_TABLE
1769 , p7_a31 JTF_VARCHAR2_TABLE_100
1770 , p7_a32 JTF_NUMBER_TABLE
1771 , p7_a33 JTF_VARCHAR2_TABLE_100
1772 , p7_a34 JTF_DATE_TABLE
1773 , p7_a35 JTF_NUMBER_TABLE
1774 , p7_a36 JTF_VARCHAR2_TABLE_100
1775 , p7_a37 JTF_VARCHAR2_TABLE_100
1776 , p7_a38 JTF_VARCHAR2_TABLE_100
1777 , p7_a39 JTF_DATE_TABLE
1778 , p7_a40 JTF_NUMBER_TABLE
1779 , p7_a41 JTF_DATE_TABLE
1780 , p7_a42 JTF_NUMBER_TABLE
1781 , p7_a43 JTF_VARCHAR2_TABLE_100
1782 , p7_a44 JTF_VARCHAR2_TABLE_100
1783 , p7_a45 JTF_VARCHAR2_TABLE_100
1784 , p7_a46 JTF_NUMBER_TABLE
1785 , p7_a47 JTF_VARCHAR2_TABLE_300
1786 , p7_a48 JTF_NUMBER_TABLE
1787 , p7_a49 JTF_VARCHAR2_TABLE_100
1788 , p7_a50 JTF_NUMBER_TABLE
1789 , p7_a51 JTF_VARCHAR2_TABLE_100
1790 , p7_a52 JTF_NUMBER_TABLE
1791 , p7_a53 JTF_NUMBER_TABLE
1792 , p7_a54 JTF_NUMBER_TABLE
1793 , p7_a55 JTF_VARCHAR2_TABLE_100
1794 , p7_a56 JTF_VARCHAR2_TABLE_100
1795 , p7_a57 JTF_VARCHAR2_TABLE_2000
1796 , p7_a58 JTF_VARCHAR2_TABLE_100
1797 , p7_a59 JTF_VARCHAR2_TABLE_100
1798 , p7_a60 JTF_VARCHAR2_TABLE_100
1799 , p7_a61 JTF_VARCHAR2_TABLE_200
1800 , p7_a62 JTF_VARCHAR2_TABLE_200
1801 , p7_a63 JTF_VARCHAR2_TABLE_200
1802 , p7_a64 JTF_VARCHAR2_TABLE_200
1803 , p7_a65 JTF_VARCHAR2_TABLE_200
1804 , p7_a66 JTF_VARCHAR2_TABLE_200
1805 , p7_a67 JTF_VARCHAR2_TABLE_200
1806 , p7_a68 JTF_VARCHAR2_TABLE_200
1807 , p7_a69 JTF_VARCHAR2_TABLE_200
1808 , p7_a70 JTF_VARCHAR2_TABLE_200
1809 , p7_a71 JTF_VARCHAR2_TABLE_200
1810 , p7_a72 JTF_VARCHAR2_TABLE_200
1811 , p7_a73 JTF_VARCHAR2_TABLE_200
1812 , p7_a74 JTF_VARCHAR2_TABLE_200
1813 , p7_a75 JTF_VARCHAR2_TABLE_200
1814 , p7_a76 JTF_NUMBER_TABLE
1815 , p7_a77 JTF_VARCHAR2_TABLE_100
1816 , p7_a78 JTF_VARCHAR2_TABLE_100
1817 , p7_a79 JTF_DATE_TABLE
1818 , p7_a80 JTF_VARCHAR2_TABLE_100
1819 , p7_a81 JTF_NUMBER_TABLE
1820 , p7_a82 JTF_NUMBER_TABLE
1821 , p7_a83 JTF_NUMBER_TABLE
1822 , p7_a84 JTF_VARCHAR2_TABLE_100
1823 , p7_a85 JTF_VARCHAR2_TABLE_100
1824 , p7_a86 JTF_DATE_TABLE
1825 , p7_a87 JTF_NUMBER_TABLE
1826 , p7_a88 JTF_NUMBER_TABLE
1827 , p7_a89 JTF_VARCHAR2_TABLE_100
1828 , p7_a90 JTF_NUMBER_TABLE
1829 , p7_a91 JTF_VARCHAR2_TABLE_2000
1830 , p_change_object_version VARCHAR2
1831 , p_mode VARCHAR2
1832 , x_error_index out nocopy NUMBER
1833 )
1834
1835 as
1836 ddp_claim_line_tbl ozf_claim_line_pvt.claim_line_tbl_type;
1837 ddindx binary_integer; indx binary_integer;
1838 begin
1839
1840 -- copy data to the local IN or IN-OUT args, if any
1841
1842
1843
1844
1845
1846
1847
1848 ozf_claim_line_pvt_w.rosetta_table_copy_in_p1(ddp_claim_line_tbl, p7_a0
1849 , p7_a1
1850 , p7_a2
1851 , p7_a3
1852 , p7_a4
1853 , p7_a5
1854 , p7_a6
1855 , p7_a7
1856 , p7_a8
1857 , p7_a9
1858 , p7_a10
1859 , p7_a11
1860 , p7_a12
1861 , p7_a13
1862 , p7_a14
1863 , p7_a15
1864 , p7_a16
1865 , p7_a17
1866 , p7_a18
1867 , p7_a19
1868 , p7_a20
1869 , p7_a21
1870 , p7_a22
1871 , p7_a23
1872 , p7_a24
1873 , p7_a25
1874 , p7_a26
1875 , p7_a27
1876 , p7_a28
1877 , p7_a29
1878 , p7_a30
1879 , p7_a31
1880 , p7_a32
1881 , p7_a33
1882 , p7_a34
1883 , p7_a35
1884 , p7_a36
1885 , p7_a37
1886 , p7_a38
1887 , p7_a39
1888 , p7_a40
1889 , p7_a41
1890 , p7_a42
1891 , p7_a43
1892 , p7_a44
1893 , p7_a45
1894 , p7_a46
1895 , p7_a47
1896 , p7_a48
1897 , p7_a49
1898 , p7_a50
1899 , p7_a51
1900 , p7_a52
1901 , p7_a53
1902 , p7_a54
1903 , p7_a55
1904 , p7_a56
1905 , p7_a57
1906 , p7_a58
1907 , p7_a59
1908 , p7_a60
1909 , p7_a61
1910 , p7_a62
1911 , p7_a63
1912 , p7_a64
1913 , p7_a65
1914 , p7_a66
1915 , p7_a67
1916 , p7_a68
1917 , p7_a69
1918 , p7_a70
1919 , p7_a71
1920 , p7_a72
1921 , p7_a73
1922 , p7_a74
1923 , p7_a75
1924 , p7_a76
1925 , p7_a77
1926 , p7_a78
1927 , p7_a79
1928 , p7_a80
1929 , p7_a81
1930 , p7_a82
1931 , p7_a83
1932 , p7_a84
1933 , p7_a85
1934 , p7_a86
1935 , p7_a87
1936 , p7_a88
1937 , p7_a89
1938 , p7_a90
1939 , p7_a91
1940 );
1941
1942
1943
1944
1945 -- here's the delegated call to the old PL/SQL routine
1946 ozf_claim_line_pvt.update_claim_line_tbl(p_api_version,
1947 p_init_msg_list,
1948 p_commit,
1949 p_validation_level,
1950 x_return_status,
1951 x_msg_data,
1952 x_msg_count,
1953 ddp_claim_line_tbl,
1954 p_change_object_version,
1955 p_mode,
1956 x_error_index);
1957
1958 -- copy data back from the local variables to OUT or IN-OUT args, if any
1959
1960
1961
1962
1963
1964
1965
1966
1967
1968
1969 end;
1970
1971 procedure update_claim_line(p_api_version NUMBER
1972 , p_init_msg_list VARCHAR2
1973 , p_commit VARCHAR2
1974 , p_validation_level NUMBER
1975 , x_return_status out nocopy VARCHAR2
1976 , x_msg_count out nocopy NUMBER
1977 , x_msg_data out nocopy VARCHAR2
1978 , p7_a0 NUMBER
1979 , p7_a1 NUMBER
1980 , p7_a2 DATE
1981 , p7_a3 NUMBER
1982 , p7_a4 DATE
1983 , p7_a5 NUMBER
1984 , p7_a6 NUMBER
1985 , p7_a7 NUMBER
1986 , p7_a8 NUMBER
1987 , p7_a9 DATE
1988 , p7_a10 NUMBER
1989 , p7_a11 VARCHAR2
1990 , p7_a12 NUMBER
1991 , p7_a13 NUMBER
1992 , p7_a14 NUMBER
1993 , p7_a15 NUMBER
1994 , p7_a16 NUMBER
1995 , p7_a17 NUMBER
1996 , p7_a18 VARCHAR2
1997 , p7_a19 VARCHAR2
1998 , p7_a20 DATE
1999 , p7_a21 NUMBER
2000 , p7_a22 NUMBER
2001 , p7_a23 VARCHAR2
2002 , p7_a24 NUMBER
2003 , p7_a25 NUMBER
2004 , p7_a26 VARCHAR2
2005 , p7_a27 NUMBER
2006 , p7_a28 NUMBER
2007 , p7_a29 NUMBER
2008 , p7_a30 NUMBER
2009 , p7_a31 VARCHAR2
2010 , p7_a32 NUMBER
2011 , p7_a33 VARCHAR2
2012 , p7_a34 DATE
2013 , p7_a35 NUMBER
2014 , p7_a36 VARCHAR2
2015 , p7_a37 VARCHAR2
2016 , p7_a38 VARCHAR2
2017 , p7_a39 DATE
2018 , p7_a40 NUMBER
2019 , p7_a41 DATE
2020 , p7_a42 NUMBER
2021 , p7_a43 VARCHAR2
2022 , p7_a44 VARCHAR2
2023 , p7_a45 VARCHAR2
2024 , p7_a46 NUMBER
2025 , p7_a47 VARCHAR2
2026 , p7_a48 NUMBER
2027 , p7_a49 VARCHAR2
2028 , p7_a50 NUMBER
2029 , p7_a51 VARCHAR2
2030 , p7_a52 NUMBER
2031 , p7_a53 NUMBER
2032 , p7_a54 NUMBER
2033 , p7_a55 VARCHAR2
2034 , p7_a56 VARCHAR2
2035 , p7_a57 VARCHAR2
2036 , p7_a58 VARCHAR2
2037 , p7_a59 VARCHAR2
2038 , p7_a60 VARCHAR2
2039 , p7_a61 VARCHAR2
2040 , p7_a62 VARCHAR2
2041 , p7_a63 VARCHAR2
2042 , p7_a64 VARCHAR2
2043 , p7_a65 VARCHAR2
2044 , p7_a66 VARCHAR2
2045 , p7_a67 VARCHAR2
2046 , p7_a68 VARCHAR2
2047 , p7_a69 VARCHAR2
2048 , p7_a70 VARCHAR2
2049 , p7_a71 VARCHAR2
2050 , p7_a72 VARCHAR2
2051 , p7_a73 VARCHAR2
2052 , p7_a74 VARCHAR2
2053 , p7_a75 VARCHAR2
2054 , p7_a76 NUMBER
2055 , p7_a77 VARCHAR2
2056 , p7_a78 VARCHAR2
2057 , p7_a79 DATE
2058 , p7_a80 VARCHAR2
2059 , p7_a81 NUMBER
2060 , p7_a82 NUMBER
2061 , p7_a83 NUMBER
2062 , p7_a84 VARCHAR2
2063 , p7_a85 VARCHAR2
2064 , p7_a86 DATE
2065 , p7_a87 NUMBER
2066 , p7_a88 NUMBER
2067 , p7_a89 VARCHAR2
2068 , p7_a90 NUMBER
2069 , p7_a91 VARCHAR2
2070 , p_mode VARCHAR2
2071 , x_object_version out nocopy NUMBER
2072 )
2073
2074 as
2075 ddp_claim_line_rec ozf_claim_line_pvt.claim_line_rec_type;
2076 ddindx binary_integer; indx binary_integer;
2077 begin
2078
2079 -- copy data to the local IN or IN-OUT args, if any
2080
2081
2082
2083
2084
2085
2086
2087 ddp_claim_line_rec.claim_line_id := p7_a0;
2088 ddp_claim_line_rec.object_version_number := p7_a1;
2089 ddp_claim_line_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a2);
2090 ddp_claim_line_rec.last_updated_by := p7_a3;
2091 ddp_claim_line_rec.creation_date := rosetta_g_miss_date_in_map(p7_a4);
2092 ddp_claim_line_rec.created_by := p7_a5;
2093 ddp_claim_line_rec.last_update_login := p7_a6;
2094 ddp_claim_line_rec.request_id := p7_a7;
2095 ddp_claim_line_rec.program_application_id := p7_a8;
2096 ddp_claim_line_rec.program_update_date := rosetta_g_miss_date_in_map(p7_a9);
2097 ddp_claim_line_rec.program_id := p7_a10;
2098 ddp_claim_line_rec.created_from := p7_a11;
2099 ddp_claim_line_rec.claim_id := p7_a12;
2100 ddp_claim_line_rec.line_number := p7_a13;
2101 ddp_claim_line_rec.split_from_claim_line_id := p7_a14;
2102 ddp_claim_line_rec.amount := p7_a15;
2103 ddp_claim_line_rec.claim_currency_amount := p7_a16;
2104 ddp_claim_line_rec.acctd_amount := p7_a17;
2105 ddp_claim_line_rec.currency_code := p7_a18;
2106 ddp_claim_line_rec.exchange_rate_type := p7_a19;
2107 ddp_claim_line_rec.exchange_rate_date := rosetta_g_miss_date_in_map(p7_a20);
2108 ddp_claim_line_rec.exchange_rate := p7_a21;
2109 ddp_claim_line_rec.set_of_books_id := p7_a22;
2110 ddp_claim_line_rec.valid_flag := p7_a23;
2111 ddp_claim_line_rec.source_object_id := p7_a24;
2112 ddp_claim_line_rec.source_object_line_id := p7_a25;
2113 ddp_claim_line_rec.source_object_class := p7_a26;
2114 ddp_claim_line_rec.source_object_type_id := p7_a27;
2115 ddp_claim_line_rec.plan_id := p7_a28;
2116 ddp_claim_line_rec.offer_id := p7_a29;
2117 ddp_claim_line_rec.utilization_id := p7_a30;
2118 ddp_claim_line_rec.payment_method := p7_a31;
2119 ddp_claim_line_rec.payment_reference_id := p7_a32;
2120 ddp_claim_line_rec.payment_reference_number := p7_a33;
2121 ddp_claim_line_rec.payment_reference_date := rosetta_g_miss_date_in_map(p7_a34);
2122 ddp_claim_line_rec.voucher_id := p7_a35;
2123 ddp_claim_line_rec.voucher_number := p7_a36;
2124 ddp_claim_line_rec.payment_status := p7_a37;
2125 ddp_claim_line_rec.approved_flag := p7_a38;
2126 ddp_claim_line_rec.approved_date := rosetta_g_miss_date_in_map(p7_a39);
2127 ddp_claim_line_rec.approved_by := p7_a40;
2128 ddp_claim_line_rec.settled_date := rosetta_g_miss_date_in_map(p7_a41);
2129 ddp_claim_line_rec.settled_by := p7_a42;
2130 ddp_claim_line_rec.performance_complete_flag := p7_a43;
2131 ddp_claim_line_rec.performance_attached_flag := p7_a44;
2132 ddp_claim_line_rec.select_cust_children_flag := p7_a45;
2133 ddp_claim_line_rec.item_id := p7_a46;
2134 ddp_claim_line_rec.item_description := p7_a47;
2135 ddp_claim_line_rec.quantity := p7_a48;
2136 ddp_claim_line_rec.quantity_uom := p7_a49;
2137 ddp_claim_line_rec.rate := p7_a50;
2138 ddp_claim_line_rec.activity_type := p7_a51;
2139 ddp_claim_line_rec.activity_id := p7_a52;
2140 ddp_claim_line_rec.related_cust_account_id := p7_a53;
2141 ddp_claim_line_rec.buy_group_cust_account_id := p7_a54;
2142 ddp_claim_line_rec.relationship_type := p7_a55;
2143 ddp_claim_line_rec.earnings_associated_flag := p7_a56;
2144 ddp_claim_line_rec.comments := p7_a57;
2145 ddp_claim_line_rec.tax_code := p7_a58;
2146 ddp_claim_line_rec.credit_to := p7_a59;
2147 ddp_claim_line_rec.attribute_category := p7_a60;
2148 ddp_claim_line_rec.attribute1 := p7_a61;
2149 ddp_claim_line_rec.attribute2 := p7_a62;
2150 ddp_claim_line_rec.attribute3 := p7_a63;
2151 ddp_claim_line_rec.attribute4 := p7_a64;
2152 ddp_claim_line_rec.attribute5 := p7_a65;
2153 ddp_claim_line_rec.attribute6 := p7_a66;
2154 ddp_claim_line_rec.attribute7 := p7_a67;
2155 ddp_claim_line_rec.attribute8 := p7_a68;
2156 ddp_claim_line_rec.attribute9 := p7_a69;
2157 ddp_claim_line_rec.attribute10 := p7_a70;
2158 ddp_claim_line_rec.attribute11 := p7_a71;
2159 ddp_claim_line_rec.attribute12 := p7_a72;
2160 ddp_claim_line_rec.attribute13 := p7_a73;
2161 ddp_claim_line_rec.attribute14 := p7_a74;
2162 ddp_claim_line_rec.attribute15 := p7_a75;
2163 ddp_claim_line_rec.org_id := p7_a76;
2164 ddp_claim_line_rec.update_from_tbl_flag := p7_a77;
2165 ddp_claim_line_rec.tax_action := p7_a78;
2166 ddp_claim_line_rec.sale_date := rosetta_g_miss_date_in_map(p7_a79);
2167 ddp_claim_line_rec.item_type := p7_a80;
2168 ddp_claim_line_rec.tax_amount := p7_a81;
2169 ddp_claim_line_rec.claim_curr_tax_amount := p7_a82;
2170 ddp_claim_line_rec.activity_line_id := p7_a83;
2171 ddp_claim_line_rec.offer_type := p7_a84;
2172 ddp_claim_line_rec.prorate_earnings_flag := p7_a85;
2173 ddp_claim_line_rec.earnings_end_date := rosetta_g_miss_date_in_map(p7_a86);
2174 ddp_claim_line_rec.buy_group_party_id := p7_a87;
2175 ddp_claim_line_rec.acctd_tax_amount := p7_a88;
2176 ddp_claim_line_rec.dpp_cust_account_id := p7_a89;
2177 ddp_claim_line_rec.batch_line_id := p7_a90;
2178 ddp_claim_line_rec.activity_name := p7_a91;
2179
2180
2181
2182 -- here's the delegated call to the old PL/SQL routine
2183 ozf_claim_line_pvt.update_claim_line(p_api_version,
2184 p_init_msg_list,
2185 p_commit,
2186 p_validation_level,
2187 x_return_status,
2188 x_msg_count,
2189 x_msg_data,
2190 ddp_claim_line_rec,
2191 p_mode,
2192 x_object_version);
2193
2194 -- copy data back from the local variables to OUT or IN-OUT args, if any
2195
2196
2197
2198
2199
2200
2201
2202
2203
2204 end;
2205
2206 procedure validate_claim_line(p_api_version NUMBER
2207 , p_init_msg_list VARCHAR2
2208 , p_validation_level NUMBER
2209 , x_return_status out nocopy VARCHAR2
2210 , x_msg_count out nocopy NUMBER
2211 , x_msg_data out nocopy VARCHAR2
2212 , p6_a0 NUMBER
2213 , p6_a1 NUMBER
2214 , p6_a2 DATE
2215 , p6_a3 NUMBER
2216 , p6_a4 DATE
2217 , p6_a5 NUMBER
2218 , p6_a6 NUMBER
2219 , p6_a7 NUMBER
2220 , p6_a8 NUMBER
2221 , p6_a9 DATE
2222 , p6_a10 NUMBER
2223 , p6_a11 VARCHAR2
2224 , p6_a12 NUMBER
2225 , p6_a13 NUMBER
2226 , p6_a14 NUMBER
2227 , p6_a15 NUMBER
2228 , p6_a16 NUMBER
2229 , p6_a17 NUMBER
2230 , p6_a18 VARCHAR2
2231 , p6_a19 VARCHAR2
2232 , p6_a20 DATE
2233 , p6_a21 NUMBER
2234 , p6_a22 NUMBER
2235 , p6_a23 VARCHAR2
2236 , p6_a24 NUMBER
2237 , p6_a25 NUMBER
2238 , p6_a26 VARCHAR2
2239 , p6_a27 NUMBER
2240 , p6_a28 NUMBER
2241 , p6_a29 NUMBER
2242 , p6_a30 NUMBER
2243 , p6_a31 VARCHAR2
2244 , p6_a32 NUMBER
2245 , p6_a33 VARCHAR2
2246 , p6_a34 DATE
2247 , p6_a35 NUMBER
2248 , p6_a36 VARCHAR2
2249 , p6_a37 VARCHAR2
2250 , p6_a38 VARCHAR2
2251 , p6_a39 DATE
2252 , p6_a40 NUMBER
2253 , p6_a41 DATE
2254 , p6_a42 NUMBER
2255 , p6_a43 VARCHAR2
2256 , p6_a44 VARCHAR2
2257 , p6_a45 VARCHAR2
2258 , p6_a46 NUMBER
2259 , p6_a47 VARCHAR2
2260 , p6_a48 NUMBER
2261 , p6_a49 VARCHAR2
2262 , p6_a50 NUMBER
2263 , p6_a51 VARCHAR2
2264 , p6_a52 NUMBER
2265 , p6_a53 NUMBER
2266 , p6_a54 NUMBER
2267 , p6_a55 VARCHAR2
2268 , p6_a56 VARCHAR2
2269 , p6_a57 VARCHAR2
2270 , p6_a58 VARCHAR2
2271 , p6_a59 VARCHAR2
2272 , p6_a60 VARCHAR2
2273 , p6_a61 VARCHAR2
2274 , p6_a62 VARCHAR2
2275 , p6_a63 VARCHAR2
2276 , p6_a64 VARCHAR2
2277 , p6_a65 VARCHAR2
2278 , p6_a66 VARCHAR2
2279 , p6_a67 VARCHAR2
2280 , p6_a68 VARCHAR2
2281 , p6_a69 VARCHAR2
2282 , p6_a70 VARCHAR2
2283 , p6_a71 VARCHAR2
2284 , p6_a72 VARCHAR2
2285 , p6_a73 VARCHAR2
2286 , p6_a74 VARCHAR2
2287 , p6_a75 VARCHAR2
2288 , p6_a76 NUMBER
2289 , p6_a77 VARCHAR2
2290 , p6_a78 VARCHAR2
2291 , p6_a79 DATE
2292 , p6_a80 VARCHAR2
2293 , p6_a81 NUMBER
2294 , p6_a82 NUMBER
2295 , p6_a83 NUMBER
2296 , p6_a84 VARCHAR2
2297 , p6_a85 VARCHAR2
2298 , p6_a86 DATE
2299 , p6_a87 NUMBER
2300 , p6_a88 NUMBER
2301 , p6_a89 VARCHAR2
2302 , p6_a90 NUMBER
2303 , p6_a91 VARCHAR2
2304 )
2305
2306 as
2307 ddp_claim_line_rec ozf_claim_line_pvt.claim_line_rec_type;
2308 ddindx binary_integer; indx binary_integer;
2309 begin
2310
2311 -- copy data to the local IN or IN-OUT args, if any
2312
2313
2314
2315
2316
2317
2318 ddp_claim_line_rec.claim_line_id := p6_a0;
2319 ddp_claim_line_rec.object_version_number := p6_a1;
2320 ddp_claim_line_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a2);
2321 ddp_claim_line_rec.last_updated_by := p6_a3;
2322 ddp_claim_line_rec.creation_date := rosetta_g_miss_date_in_map(p6_a4);
2323 ddp_claim_line_rec.created_by := p6_a5;
2324 ddp_claim_line_rec.last_update_login := p6_a6;
2325 ddp_claim_line_rec.request_id := p6_a7;
2326 ddp_claim_line_rec.program_application_id := p6_a8;
2327 ddp_claim_line_rec.program_update_date := rosetta_g_miss_date_in_map(p6_a9);
2328 ddp_claim_line_rec.program_id := p6_a10;
2329 ddp_claim_line_rec.created_from := p6_a11;
2330 ddp_claim_line_rec.claim_id := p6_a12;
2331 ddp_claim_line_rec.line_number := p6_a13;
2332 ddp_claim_line_rec.split_from_claim_line_id := p6_a14;
2333 ddp_claim_line_rec.amount := p6_a15;
2334 ddp_claim_line_rec.claim_currency_amount := p6_a16;
2335 ddp_claim_line_rec.acctd_amount := p6_a17;
2336 ddp_claim_line_rec.currency_code := p6_a18;
2337 ddp_claim_line_rec.exchange_rate_type := p6_a19;
2338 ddp_claim_line_rec.exchange_rate_date := rosetta_g_miss_date_in_map(p6_a20);
2339 ddp_claim_line_rec.exchange_rate := p6_a21;
2340 ddp_claim_line_rec.set_of_books_id := p6_a22;
2341 ddp_claim_line_rec.valid_flag := p6_a23;
2342 ddp_claim_line_rec.source_object_id := p6_a24;
2343 ddp_claim_line_rec.source_object_line_id := p6_a25;
2344 ddp_claim_line_rec.source_object_class := p6_a26;
2345 ddp_claim_line_rec.source_object_type_id := p6_a27;
2346 ddp_claim_line_rec.plan_id := p6_a28;
2347 ddp_claim_line_rec.offer_id := p6_a29;
2348 ddp_claim_line_rec.utilization_id := p6_a30;
2349 ddp_claim_line_rec.payment_method := p6_a31;
2350 ddp_claim_line_rec.payment_reference_id := p6_a32;
2351 ddp_claim_line_rec.payment_reference_number := p6_a33;
2352 ddp_claim_line_rec.payment_reference_date := rosetta_g_miss_date_in_map(p6_a34);
2353 ddp_claim_line_rec.voucher_id := p6_a35;
2354 ddp_claim_line_rec.voucher_number := p6_a36;
2355 ddp_claim_line_rec.payment_status := p6_a37;
2356 ddp_claim_line_rec.approved_flag := p6_a38;
2357 ddp_claim_line_rec.approved_date := rosetta_g_miss_date_in_map(p6_a39);
2358 ddp_claim_line_rec.approved_by := p6_a40;
2359 ddp_claim_line_rec.settled_date := rosetta_g_miss_date_in_map(p6_a41);
2360 ddp_claim_line_rec.settled_by := p6_a42;
2361 ddp_claim_line_rec.performance_complete_flag := p6_a43;
2362 ddp_claim_line_rec.performance_attached_flag := p6_a44;
2363 ddp_claim_line_rec.select_cust_children_flag := p6_a45;
2364 ddp_claim_line_rec.item_id := p6_a46;
2365 ddp_claim_line_rec.item_description := p6_a47;
2366 ddp_claim_line_rec.quantity := p6_a48;
2367 ddp_claim_line_rec.quantity_uom := p6_a49;
2368 ddp_claim_line_rec.rate := p6_a50;
2369 ddp_claim_line_rec.activity_type := p6_a51;
2370 ddp_claim_line_rec.activity_id := p6_a52;
2371 ddp_claim_line_rec.related_cust_account_id := p6_a53;
2372 ddp_claim_line_rec.buy_group_cust_account_id := p6_a54;
2373 ddp_claim_line_rec.relationship_type := p6_a55;
2374 ddp_claim_line_rec.earnings_associated_flag := p6_a56;
2375 ddp_claim_line_rec.comments := p6_a57;
2376 ddp_claim_line_rec.tax_code := p6_a58;
2377 ddp_claim_line_rec.credit_to := p6_a59;
2378 ddp_claim_line_rec.attribute_category := p6_a60;
2379 ddp_claim_line_rec.attribute1 := p6_a61;
2380 ddp_claim_line_rec.attribute2 := p6_a62;
2381 ddp_claim_line_rec.attribute3 := p6_a63;
2382 ddp_claim_line_rec.attribute4 := p6_a64;
2383 ddp_claim_line_rec.attribute5 := p6_a65;
2384 ddp_claim_line_rec.attribute6 := p6_a66;
2385 ddp_claim_line_rec.attribute7 := p6_a67;
2386 ddp_claim_line_rec.attribute8 := p6_a68;
2387 ddp_claim_line_rec.attribute9 := p6_a69;
2388 ddp_claim_line_rec.attribute10 := p6_a70;
2389 ddp_claim_line_rec.attribute11 := p6_a71;
2390 ddp_claim_line_rec.attribute12 := p6_a72;
2391 ddp_claim_line_rec.attribute13 := p6_a73;
2392 ddp_claim_line_rec.attribute14 := p6_a74;
2393 ddp_claim_line_rec.attribute15 := p6_a75;
2394 ddp_claim_line_rec.org_id := p6_a76;
2395 ddp_claim_line_rec.update_from_tbl_flag := p6_a77;
2396 ddp_claim_line_rec.tax_action := p6_a78;
2397 ddp_claim_line_rec.sale_date := rosetta_g_miss_date_in_map(p6_a79);
2398 ddp_claim_line_rec.item_type := p6_a80;
2399 ddp_claim_line_rec.tax_amount := p6_a81;
2400 ddp_claim_line_rec.claim_curr_tax_amount := p6_a82;
2401 ddp_claim_line_rec.activity_line_id := p6_a83;
2402 ddp_claim_line_rec.offer_type := p6_a84;
2403 ddp_claim_line_rec.prorate_earnings_flag := p6_a85;
2404 ddp_claim_line_rec.earnings_end_date := rosetta_g_miss_date_in_map(p6_a86);
2405 ddp_claim_line_rec.buy_group_party_id := p6_a87;
2406 ddp_claim_line_rec.acctd_tax_amount := p6_a88;
2407 ddp_claim_line_rec.dpp_cust_account_id := p6_a89;
2408 ddp_claim_line_rec.batch_line_id := p6_a90;
2409 ddp_claim_line_rec.activity_name := p6_a91;
2410
2411 -- here's the delegated call to the old PL/SQL routine
2412 ozf_claim_line_pvt.validate_claim_line(p_api_version,
2413 p_init_msg_list,
2414 p_validation_level,
2415 x_return_status,
2416 x_msg_count,
2417 x_msg_data,
2418 ddp_claim_line_rec);
2419
2420 -- copy data back from the local variables to OUT or IN-OUT args, if any
2421
2422
2423
2424
2425
2426
2427 end;
2428
2429 procedure check_claim_line_items(p0_a0 NUMBER
2430 , p0_a1 NUMBER
2431 , p0_a2 DATE
2432 , p0_a3 NUMBER
2433 , p0_a4 DATE
2434 , p0_a5 NUMBER
2435 , p0_a6 NUMBER
2436 , p0_a7 NUMBER
2437 , p0_a8 NUMBER
2438 , p0_a9 DATE
2439 , p0_a10 NUMBER
2440 , p0_a11 VARCHAR2
2441 , p0_a12 NUMBER
2442 , p0_a13 NUMBER
2443 , p0_a14 NUMBER
2444 , p0_a15 NUMBER
2445 , p0_a16 NUMBER
2446 , p0_a17 NUMBER
2447 , p0_a18 VARCHAR2
2448 , p0_a19 VARCHAR2
2449 , p0_a20 DATE
2450 , p0_a21 NUMBER
2451 , p0_a22 NUMBER
2452 , p0_a23 VARCHAR2
2453 , p0_a24 NUMBER
2454 , p0_a25 NUMBER
2455 , p0_a26 VARCHAR2
2456 , p0_a27 NUMBER
2457 , p0_a28 NUMBER
2458 , p0_a29 NUMBER
2459 , p0_a30 NUMBER
2460 , p0_a31 VARCHAR2
2461 , p0_a32 NUMBER
2462 , p0_a33 VARCHAR2
2463 , p0_a34 DATE
2464 , p0_a35 NUMBER
2465 , p0_a36 VARCHAR2
2466 , p0_a37 VARCHAR2
2467 , p0_a38 VARCHAR2
2468 , p0_a39 DATE
2469 , p0_a40 NUMBER
2470 , p0_a41 DATE
2471 , p0_a42 NUMBER
2472 , p0_a43 VARCHAR2
2473 , p0_a44 VARCHAR2
2474 , p0_a45 VARCHAR2
2475 , p0_a46 NUMBER
2476 , p0_a47 VARCHAR2
2477 , p0_a48 NUMBER
2478 , p0_a49 VARCHAR2
2479 , p0_a50 NUMBER
2480 , p0_a51 VARCHAR2
2481 , p0_a52 NUMBER
2482 , p0_a53 NUMBER
2483 , p0_a54 NUMBER
2484 , p0_a55 VARCHAR2
2485 , p0_a56 VARCHAR2
2486 , p0_a57 VARCHAR2
2487 , p0_a58 VARCHAR2
2488 , p0_a59 VARCHAR2
2489 , p0_a60 VARCHAR2
2490 , p0_a61 VARCHAR2
2491 , p0_a62 VARCHAR2
2492 , p0_a63 VARCHAR2
2493 , p0_a64 VARCHAR2
2494 , p0_a65 VARCHAR2
2495 , p0_a66 VARCHAR2
2496 , p0_a67 VARCHAR2
2497 , p0_a68 VARCHAR2
2498 , p0_a69 VARCHAR2
2499 , p0_a70 VARCHAR2
2500 , p0_a71 VARCHAR2
2501 , p0_a72 VARCHAR2
2502 , p0_a73 VARCHAR2
2503 , p0_a74 VARCHAR2
2504 , p0_a75 VARCHAR2
2505 , p0_a76 NUMBER
2506 , p0_a77 VARCHAR2
2507 , p0_a78 VARCHAR2
2508 , p0_a79 DATE
2509 , p0_a80 VARCHAR2
2510 , p0_a81 NUMBER
2511 , p0_a82 NUMBER
2512 , p0_a83 NUMBER
2513 , p0_a84 VARCHAR2
2514 , p0_a85 VARCHAR2
2515 , p0_a86 DATE
2516 , p0_a87 NUMBER
2517 , p0_a88 NUMBER
2518 , p0_a89 VARCHAR2
2519 , p0_a90 NUMBER
2520 , p0_a91 VARCHAR2
2521 , p_validation_mode VARCHAR2
2522 , x_return_status out nocopy VARCHAR2
2523 )
2524
2525 as
2526 ddp_claim_line_rec ozf_claim_line_pvt.claim_line_rec_type;
2527 ddindx binary_integer; indx binary_integer;
2528 begin
2529
2530 -- copy data to the local IN or IN-OUT args, if any
2531 ddp_claim_line_rec.claim_line_id := p0_a0;
2532 ddp_claim_line_rec.object_version_number := p0_a1;
2533 ddp_claim_line_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a2);
2534 ddp_claim_line_rec.last_updated_by := p0_a3;
2535 ddp_claim_line_rec.creation_date := rosetta_g_miss_date_in_map(p0_a4);
2536 ddp_claim_line_rec.created_by := p0_a5;
2537 ddp_claim_line_rec.last_update_login := p0_a6;
2538 ddp_claim_line_rec.request_id := p0_a7;
2539 ddp_claim_line_rec.program_application_id := p0_a8;
2540 ddp_claim_line_rec.program_update_date := rosetta_g_miss_date_in_map(p0_a9);
2541 ddp_claim_line_rec.program_id := p0_a10;
2542 ddp_claim_line_rec.created_from := p0_a11;
2543 ddp_claim_line_rec.claim_id := p0_a12;
2544 ddp_claim_line_rec.line_number := p0_a13;
2545 ddp_claim_line_rec.split_from_claim_line_id := p0_a14;
2546 ddp_claim_line_rec.amount := p0_a15;
2547 ddp_claim_line_rec.claim_currency_amount := p0_a16;
2548 ddp_claim_line_rec.acctd_amount := p0_a17;
2549 ddp_claim_line_rec.currency_code := p0_a18;
2550 ddp_claim_line_rec.exchange_rate_type := p0_a19;
2551 ddp_claim_line_rec.exchange_rate_date := rosetta_g_miss_date_in_map(p0_a20);
2552 ddp_claim_line_rec.exchange_rate := p0_a21;
2553 ddp_claim_line_rec.set_of_books_id := p0_a22;
2554 ddp_claim_line_rec.valid_flag := p0_a23;
2555 ddp_claim_line_rec.source_object_id := p0_a24;
2556 ddp_claim_line_rec.source_object_line_id := p0_a25;
2557 ddp_claim_line_rec.source_object_class := p0_a26;
2558 ddp_claim_line_rec.source_object_type_id := p0_a27;
2559 ddp_claim_line_rec.plan_id := p0_a28;
2560 ddp_claim_line_rec.offer_id := p0_a29;
2561 ddp_claim_line_rec.utilization_id := p0_a30;
2562 ddp_claim_line_rec.payment_method := p0_a31;
2563 ddp_claim_line_rec.payment_reference_id := p0_a32;
2564 ddp_claim_line_rec.payment_reference_number := p0_a33;
2565 ddp_claim_line_rec.payment_reference_date := rosetta_g_miss_date_in_map(p0_a34);
2566 ddp_claim_line_rec.voucher_id := p0_a35;
2567 ddp_claim_line_rec.voucher_number := p0_a36;
2568 ddp_claim_line_rec.payment_status := p0_a37;
2569 ddp_claim_line_rec.approved_flag := p0_a38;
2570 ddp_claim_line_rec.approved_date := rosetta_g_miss_date_in_map(p0_a39);
2571 ddp_claim_line_rec.approved_by := p0_a40;
2572 ddp_claim_line_rec.settled_date := rosetta_g_miss_date_in_map(p0_a41);
2573 ddp_claim_line_rec.settled_by := p0_a42;
2574 ddp_claim_line_rec.performance_complete_flag := p0_a43;
2575 ddp_claim_line_rec.performance_attached_flag := p0_a44;
2576 ddp_claim_line_rec.select_cust_children_flag := p0_a45;
2577 ddp_claim_line_rec.item_id := p0_a46;
2578 ddp_claim_line_rec.item_description := p0_a47;
2579 ddp_claim_line_rec.quantity := p0_a48;
2580 ddp_claim_line_rec.quantity_uom := p0_a49;
2581 ddp_claim_line_rec.rate := p0_a50;
2582 ddp_claim_line_rec.activity_type := p0_a51;
2583 ddp_claim_line_rec.activity_id := p0_a52;
2584 ddp_claim_line_rec.related_cust_account_id := p0_a53;
2585 ddp_claim_line_rec.buy_group_cust_account_id := p0_a54;
2586 ddp_claim_line_rec.relationship_type := p0_a55;
2587 ddp_claim_line_rec.earnings_associated_flag := p0_a56;
2588 ddp_claim_line_rec.comments := p0_a57;
2589 ddp_claim_line_rec.tax_code := p0_a58;
2590 ddp_claim_line_rec.credit_to := p0_a59;
2591 ddp_claim_line_rec.attribute_category := p0_a60;
2592 ddp_claim_line_rec.attribute1 := p0_a61;
2593 ddp_claim_line_rec.attribute2 := p0_a62;
2594 ddp_claim_line_rec.attribute3 := p0_a63;
2595 ddp_claim_line_rec.attribute4 := p0_a64;
2596 ddp_claim_line_rec.attribute5 := p0_a65;
2597 ddp_claim_line_rec.attribute6 := p0_a66;
2598 ddp_claim_line_rec.attribute7 := p0_a67;
2599 ddp_claim_line_rec.attribute8 := p0_a68;
2600 ddp_claim_line_rec.attribute9 := p0_a69;
2601 ddp_claim_line_rec.attribute10 := p0_a70;
2602 ddp_claim_line_rec.attribute11 := p0_a71;
2603 ddp_claim_line_rec.attribute12 := p0_a72;
2604 ddp_claim_line_rec.attribute13 := p0_a73;
2605 ddp_claim_line_rec.attribute14 := p0_a74;
2606 ddp_claim_line_rec.attribute15 := p0_a75;
2607 ddp_claim_line_rec.org_id := p0_a76;
2608 ddp_claim_line_rec.update_from_tbl_flag := p0_a77;
2609 ddp_claim_line_rec.tax_action := p0_a78;
2610 ddp_claim_line_rec.sale_date := rosetta_g_miss_date_in_map(p0_a79);
2611 ddp_claim_line_rec.item_type := p0_a80;
2612 ddp_claim_line_rec.tax_amount := p0_a81;
2613 ddp_claim_line_rec.claim_curr_tax_amount := p0_a82;
2614 ddp_claim_line_rec.activity_line_id := p0_a83;
2615 ddp_claim_line_rec.offer_type := p0_a84;
2616 ddp_claim_line_rec.prorate_earnings_flag := p0_a85;
2617 ddp_claim_line_rec.earnings_end_date := rosetta_g_miss_date_in_map(p0_a86);
2618 ddp_claim_line_rec.buy_group_party_id := p0_a87;
2619 ddp_claim_line_rec.acctd_tax_amount := p0_a88;
2620 ddp_claim_line_rec.dpp_cust_account_id := p0_a89;
2621 ddp_claim_line_rec.batch_line_id := p0_a90;
2622 ddp_claim_line_rec.activity_name := p0_a91;
2623
2624
2625
2626 -- here's the delegated call to the old PL/SQL routine
2627 ozf_claim_line_pvt.check_claim_line_items(ddp_claim_line_rec,
2628 p_validation_mode,
2629 x_return_status);
2630
2631 -- copy data back from the local variables to OUT or IN-OUT args, if any
2632
2633
2634 end;
2635
2636 procedure check_claim_line_record(p0_a0 NUMBER
2637 , p0_a1 NUMBER
2638 , p0_a2 DATE
2639 , p0_a3 NUMBER
2640 , p0_a4 DATE
2641 , p0_a5 NUMBER
2642 , p0_a6 NUMBER
2643 , p0_a7 NUMBER
2644 , p0_a8 NUMBER
2645 , p0_a9 DATE
2646 , p0_a10 NUMBER
2647 , p0_a11 VARCHAR2
2648 , p0_a12 NUMBER
2649 , p0_a13 NUMBER
2650 , p0_a14 NUMBER
2651 , p0_a15 NUMBER
2652 , p0_a16 NUMBER
2653 , p0_a17 NUMBER
2654 , p0_a18 VARCHAR2
2655 , p0_a19 VARCHAR2
2656 , p0_a20 DATE
2657 , p0_a21 NUMBER
2658 , p0_a22 NUMBER
2659 , p0_a23 VARCHAR2
2660 , p0_a24 NUMBER
2661 , p0_a25 NUMBER
2662 , p0_a26 VARCHAR2
2663 , p0_a27 NUMBER
2664 , p0_a28 NUMBER
2665 , p0_a29 NUMBER
2666 , p0_a30 NUMBER
2667 , p0_a31 VARCHAR2
2668 , p0_a32 NUMBER
2669 , p0_a33 VARCHAR2
2670 , p0_a34 DATE
2671 , p0_a35 NUMBER
2672 , p0_a36 VARCHAR2
2673 , p0_a37 VARCHAR2
2674 , p0_a38 VARCHAR2
2675 , p0_a39 DATE
2676 , p0_a40 NUMBER
2677 , p0_a41 DATE
2678 , p0_a42 NUMBER
2679 , p0_a43 VARCHAR2
2680 , p0_a44 VARCHAR2
2681 , p0_a45 VARCHAR2
2682 , p0_a46 NUMBER
2683 , p0_a47 VARCHAR2
2684 , p0_a48 NUMBER
2685 , p0_a49 VARCHAR2
2686 , p0_a50 NUMBER
2687 , p0_a51 VARCHAR2
2688 , p0_a52 NUMBER
2689 , p0_a53 NUMBER
2690 , p0_a54 NUMBER
2691 , p0_a55 VARCHAR2
2692 , p0_a56 VARCHAR2
2693 , p0_a57 VARCHAR2
2694 , p0_a58 VARCHAR2
2695 , p0_a59 VARCHAR2
2696 , p0_a60 VARCHAR2
2697 , p0_a61 VARCHAR2
2698 , p0_a62 VARCHAR2
2699 , p0_a63 VARCHAR2
2700 , p0_a64 VARCHAR2
2701 , p0_a65 VARCHAR2
2702 , p0_a66 VARCHAR2
2703 , p0_a67 VARCHAR2
2704 , p0_a68 VARCHAR2
2705 , p0_a69 VARCHAR2
2706 , p0_a70 VARCHAR2
2707 , p0_a71 VARCHAR2
2708 , p0_a72 VARCHAR2
2709 , p0_a73 VARCHAR2
2710 , p0_a74 VARCHAR2
2711 , p0_a75 VARCHAR2
2712 , p0_a76 NUMBER
2713 , p0_a77 VARCHAR2
2714 , p0_a78 VARCHAR2
2715 , p0_a79 DATE
2716 , p0_a80 VARCHAR2
2717 , p0_a81 NUMBER
2718 , p0_a82 NUMBER
2719 , p0_a83 NUMBER
2720 , p0_a84 VARCHAR2
2721 , p0_a85 VARCHAR2
2722 , p0_a86 DATE
2723 , p0_a87 NUMBER
2724 , p0_a88 NUMBER
2725 , p0_a89 VARCHAR2
2726 , p0_a90 NUMBER
2727 , p0_a91 VARCHAR2
2728 , p1_a0 NUMBER
2729 , p1_a1 NUMBER
2730 , p1_a2 DATE
2731 , p1_a3 NUMBER
2732 , p1_a4 DATE
2733 , p1_a5 NUMBER
2734 , p1_a6 NUMBER
2735 , p1_a7 NUMBER
2736 , p1_a8 NUMBER
2737 , p1_a9 DATE
2738 , p1_a10 NUMBER
2739 , p1_a11 VARCHAR2
2740 , p1_a12 NUMBER
2741 , p1_a13 NUMBER
2742 , p1_a14 NUMBER
2743 , p1_a15 NUMBER
2744 , p1_a16 NUMBER
2745 , p1_a17 NUMBER
2746 , p1_a18 VARCHAR2
2747 , p1_a19 VARCHAR2
2748 , p1_a20 DATE
2749 , p1_a21 NUMBER
2750 , p1_a22 NUMBER
2751 , p1_a23 VARCHAR2
2752 , p1_a24 NUMBER
2753 , p1_a25 NUMBER
2754 , p1_a26 VARCHAR2
2755 , p1_a27 NUMBER
2756 , p1_a28 NUMBER
2757 , p1_a29 NUMBER
2758 , p1_a30 NUMBER
2759 , p1_a31 VARCHAR2
2760 , p1_a32 NUMBER
2761 , p1_a33 VARCHAR2
2762 , p1_a34 DATE
2763 , p1_a35 NUMBER
2764 , p1_a36 VARCHAR2
2765 , p1_a37 VARCHAR2
2766 , p1_a38 VARCHAR2
2767 , p1_a39 DATE
2768 , p1_a40 NUMBER
2769 , p1_a41 DATE
2770 , p1_a42 NUMBER
2771 , p1_a43 VARCHAR2
2772 , p1_a44 VARCHAR2
2773 , p1_a45 VARCHAR2
2774 , p1_a46 NUMBER
2775 , p1_a47 VARCHAR2
2776 , p1_a48 NUMBER
2777 , p1_a49 VARCHAR2
2778 , p1_a50 NUMBER
2779 , p1_a51 VARCHAR2
2780 , p1_a52 NUMBER
2781 , p1_a53 NUMBER
2782 , p1_a54 NUMBER
2783 , p1_a55 VARCHAR2
2784 , p1_a56 VARCHAR2
2785 , p1_a57 VARCHAR2
2786 , p1_a58 VARCHAR2
2787 , p1_a59 VARCHAR2
2788 , p1_a60 VARCHAR2
2789 , p1_a61 VARCHAR2
2790 , p1_a62 VARCHAR2
2791 , p1_a63 VARCHAR2
2792 , p1_a64 VARCHAR2
2793 , p1_a65 VARCHAR2
2794 , p1_a66 VARCHAR2
2795 , p1_a67 VARCHAR2
2796 , p1_a68 VARCHAR2
2797 , p1_a69 VARCHAR2
2798 , p1_a70 VARCHAR2
2799 , p1_a71 VARCHAR2
2800 , p1_a72 VARCHAR2
2801 , p1_a73 VARCHAR2
2802 , p1_a74 VARCHAR2
2803 , p1_a75 VARCHAR2
2804 , p1_a76 NUMBER
2805 , p1_a77 VARCHAR2
2806 , p1_a78 VARCHAR2
2807 , p1_a79 DATE
2808 , p1_a80 VARCHAR2
2809 , p1_a81 NUMBER
2810 , p1_a82 NUMBER
2811 , p1_a83 NUMBER
2812 , p1_a84 VARCHAR2
2813 , p1_a85 VARCHAR2
2814 , p1_a86 DATE
2815 , p1_a87 NUMBER
2816 , p1_a88 NUMBER
2817 , p1_a89 VARCHAR2
2818 , p1_a90 NUMBER
2819 , p1_a91 VARCHAR2
2820 , x_return_status out nocopy VARCHAR2
2821 )
2822
2823 as
2824 ddp_claim_line_rec ozf_claim_line_pvt.claim_line_rec_type;
2825 ddp_complete_rec ozf_claim_line_pvt.claim_line_rec_type;
2826 ddindx binary_integer; indx binary_integer;
2827 begin
2828
2829 -- copy data to the local IN or IN-OUT args, if any
2830 ddp_claim_line_rec.claim_line_id := p0_a0;
2831 ddp_claim_line_rec.object_version_number := p0_a1;
2832 ddp_claim_line_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a2);
2833 ddp_claim_line_rec.last_updated_by := p0_a3;
2834 ddp_claim_line_rec.creation_date := rosetta_g_miss_date_in_map(p0_a4);
2835 ddp_claim_line_rec.created_by := p0_a5;
2836 ddp_claim_line_rec.last_update_login := p0_a6;
2837 ddp_claim_line_rec.request_id := p0_a7;
2838 ddp_claim_line_rec.program_application_id := p0_a8;
2839 ddp_claim_line_rec.program_update_date := rosetta_g_miss_date_in_map(p0_a9);
2840 ddp_claim_line_rec.program_id := p0_a10;
2841 ddp_claim_line_rec.created_from := p0_a11;
2842 ddp_claim_line_rec.claim_id := p0_a12;
2843 ddp_claim_line_rec.line_number := p0_a13;
2844 ddp_claim_line_rec.split_from_claim_line_id := p0_a14;
2845 ddp_claim_line_rec.amount := p0_a15;
2846 ddp_claim_line_rec.claim_currency_amount := p0_a16;
2847 ddp_claim_line_rec.acctd_amount := p0_a17;
2848 ddp_claim_line_rec.currency_code := p0_a18;
2849 ddp_claim_line_rec.exchange_rate_type := p0_a19;
2850 ddp_claim_line_rec.exchange_rate_date := rosetta_g_miss_date_in_map(p0_a20);
2851 ddp_claim_line_rec.exchange_rate := p0_a21;
2852 ddp_claim_line_rec.set_of_books_id := p0_a22;
2853 ddp_claim_line_rec.valid_flag := p0_a23;
2854 ddp_claim_line_rec.source_object_id := p0_a24;
2855 ddp_claim_line_rec.source_object_line_id := p0_a25;
2856 ddp_claim_line_rec.source_object_class := p0_a26;
2857 ddp_claim_line_rec.source_object_type_id := p0_a27;
2858 ddp_claim_line_rec.plan_id := p0_a28;
2859 ddp_claim_line_rec.offer_id := p0_a29;
2860 ddp_claim_line_rec.utilization_id := p0_a30;
2861 ddp_claim_line_rec.payment_method := p0_a31;
2862 ddp_claim_line_rec.payment_reference_id := p0_a32;
2863 ddp_claim_line_rec.payment_reference_number := p0_a33;
2864 ddp_claim_line_rec.payment_reference_date := rosetta_g_miss_date_in_map(p0_a34);
2865 ddp_claim_line_rec.voucher_id := p0_a35;
2866 ddp_claim_line_rec.voucher_number := p0_a36;
2867 ddp_claim_line_rec.payment_status := p0_a37;
2868 ddp_claim_line_rec.approved_flag := p0_a38;
2869 ddp_claim_line_rec.approved_date := rosetta_g_miss_date_in_map(p0_a39);
2870 ddp_claim_line_rec.approved_by := p0_a40;
2871 ddp_claim_line_rec.settled_date := rosetta_g_miss_date_in_map(p0_a41);
2872 ddp_claim_line_rec.settled_by := p0_a42;
2873 ddp_claim_line_rec.performance_complete_flag := p0_a43;
2874 ddp_claim_line_rec.performance_attached_flag := p0_a44;
2875 ddp_claim_line_rec.select_cust_children_flag := p0_a45;
2876 ddp_claim_line_rec.item_id := p0_a46;
2877 ddp_claim_line_rec.item_description := p0_a47;
2878 ddp_claim_line_rec.quantity := p0_a48;
2879 ddp_claim_line_rec.quantity_uom := p0_a49;
2880 ddp_claim_line_rec.rate := p0_a50;
2881 ddp_claim_line_rec.activity_type := p0_a51;
2882 ddp_claim_line_rec.activity_id := p0_a52;
2883 ddp_claim_line_rec.related_cust_account_id := p0_a53;
2884 ddp_claim_line_rec.buy_group_cust_account_id := p0_a54;
2885 ddp_claim_line_rec.relationship_type := p0_a55;
2886 ddp_claim_line_rec.earnings_associated_flag := p0_a56;
2887 ddp_claim_line_rec.comments := p0_a57;
2888 ddp_claim_line_rec.tax_code := p0_a58;
2889 ddp_claim_line_rec.credit_to := p0_a59;
2890 ddp_claim_line_rec.attribute_category := p0_a60;
2891 ddp_claim_line_rec.attribute1 := p0_a61;
2892 ddp_claim_line_rec.attribute2 := p0_a62;
2893 ddp_claim_line_rec.attribute3 := p0_a63;
2894 ddp_claim_line_rec.attribute4 := p0_a64;
2895 ddp_claim_line_rec.attribute5 := p0_a65;
2896 ddp_claim_line_rec.attribute6 := p0_a66;
2897 ddp_claim_line_rec.attribute7 := p0_a67;
2898 ddp_claim_line_rec.attribute8 := p0_a68;
2899 ddp_claim_line_rec.attribute9 := p0_a69;
2900 ddp_claim_line_rec.attribute10 := p0_a70;
2901 ddp_claim_line_rec.attribute11 := p0_a71;
2902 ddp_claim_line_rec.attribute12 := p0_a72;
2903 ddp_claim_line_rec.attribute13 := p0_a73;
2904 ddp_claim_line_rec.attribute14 := p0_a74;
2905 ddp_claim_line_rec.attribute15 := p0_a75;
2906 ddp_claim_line_rec.org_id := p0_a76;
2907 ddp_claim_line_rec.update_from_tbl_flag := p0_a77;
2908 ddp_claim_line_rec.tax_action := p0_a78;
2909 ddp_claim_line_rec.sale_date := rosetta_g_miss_date_in_map(p0_a79);
2910 ddp_claim_line_rec.item_type := p0_a80;
2911 ddp_claim_line_rec.tax_amount := p0_a81;
2912 ddp_claim_line_rec.claim_curr_tax_amount := p0_a82;
2913 ddp_claim_line_rec.activity_line_id := p0_a83;
2914 ddp_claim_line_rec.offer_type := p0_a84;
2915 ddp_claim_line_rec.prorate_earnings_flag := p0_a85;
2916 ddp_claim_line_rec.earnings_end_date := rosetta_g_miss_date_in_map(p0_a86);
2917 ddp_claim_line_rec.buy_group_party_id := p0_a87;
2918 ddp_claim_line_rec.acctd_tax_amount := p0_a88;
2919 ddp_claim_line_rec.dpp_cust_account_id := p0_a89;
2920 ddp_claim_line_rec.batch_line_id := p0_a90;
2921 ddp_claim_line_rec.activity_name := p0_a91;
2922
2923 ddp_complete_rec.claim_line_id := p1_a0;
2924 ddp_complete_rec.object_version_number := p1_a1;
2925 ddp_complete_rec.last_update_date := rosetta_g_miss_date_in_map(p1_a2);
2926 ddp_complete_rec.last_updated_by := p1_a3;
2927 ddp_complete_rec.creation_date := rosetta_g_miss_date_in_map(p1_a4);
2928 ddp_complete_rec.created_by := p1_a5;
2929 ddp_complete_rec.last_update_login := p1_a6;
2930 ddp_complete_rec.request_id := p1_a7;
2931 ddp_complete_rec.program_application_id := p1_a8;
2932 ddp_complete_rec.program_update_date := rosetta_g_miss_date_in_map(p1_a9);
2933 ddp_complete_rec.program_id := p1_a10;
2934 ddp_complete_rec.created_from := p1_a11;
2935 ddp_complete_rec.claim_id := p1_a12;
2936 ddp_complete_rec.line_number := p1_a13;
2937 ddp_complete_rec.split_from_claim_line_id := p1_a14;
2938 ddp_complete_rec.amount := p1_a15;
2939 ddp_complete_rec.claim_currency_amount := p1_a16;
2940 ddp_complete_rec.acctd_amount := p1_a17;
2941 ddp_complete_rec.currency_code := p1_a18;
2942 ddp_complete_rec.exchange_rate_type := p1_a19;
2943 ddp_complete_rec.exchange_rate_date := rosetta_g_miss_date_in_map(p1_a20);
2944 ddp_complete_rec.exchange_rate := p1_a21;
2945 ddp_complete_rec.set_of_books_id := p1_a22;
2946 ddp_complete_rec.valid_flag := p1_a23;
2947 ddp_complete_rec.source_object_id := p1_a24;
2948 ddp_complete_rec.source_object_line_id := p1_a25;
2949 ddp_complete_rec.source_object_class := p1_a26;
2950 ddp_complete_rec.source_object_type_id := p1_a27;
2951 ddp_complete_rec.plan_id := p1_a28;
2952 ddp_complete_rec.offer_id := p1_a29;
2953 ddp_complete_rec.utilization_id := p1_a30;
2954 ddp_complete_rec.payment_method := p1_a31;
2955 ddp_complete_rec.payment_reference_id := p1_a32;
2956 ddp_complete_rec.payment_reference_number := p1_a33;
2957 ddp_complete_rec.payment_reference_date := rosetta_g_miss_date_in_map(p1_a34);
2958 ddp_complete_rec.voucher_id := p1_a35;
2959 ddp_complete_rec.voucher_number := p1_a36;
2960 ddp_complete_rec.payment_status := p1_a37;
2961 ddp_complete_rec.approved_flag := p1_a38;
2962 ddp_complete_rec.approved_date := rosetta_g_miss_date_in_map(p1_a39);
2963 ddp_complete_rec.approved_by := p1_a40;
2964 ddp_complete_rec.settled_date := rosetta_g_miss_date_in_map(p1_a41);
2965 ddp_complete_rec.settled_by := p1_a42;
2966 ddp_complete_rec.performance_complete_flag := p1_a43;
2967 ddp_complete_rec.performance_attached_flag := p1_a44;
2968 ddp_complete_rec.select_cust_children_flag := p1_a45;
2969 ddp_complete_rec.item_id := p1_a46;
2970 ddp_complete_rec.item_description := p1_a47;
2971 ddp_complete_rec.quantity := p1_a48;
2972 ddp_complete_rec.quantity_uom := p1_a49;
2973 ddp_complete_rec.rate := p1_a50;
2974 ddp_complete_rec.activity_type := p1_a51;
2975 ddp_complete_rec.activity_id := p1_a52;
2976 ddp_complete_rec.related_cust_account_id := p1_a53;
2977 ddp_complete_rec.buy_group_cust_account_id := p1_a54;
2978 ddp_complete_rec.relationship_type := p1_a55;
2979 ddp_complete_rec.earnings_associated_flag := p1_a56;
2980 ddp_complete_rec.comments := p1_a57;
2981 ddp_complete_rec.tax_code := p1_a58;
2982 ddp_complete_rec.credit_to := p1_a59;
2983 ddp_complete_rec.attribute_category := p1_a60;
2984 ddp_complete_rec.attribute1 := p1_a61;
2985 ddp_complete_rec.attribute2 := p1_a62;
2986 ddp_complete_rec.attribute3 := p1_a63;
2987 ddp_complete_rec.attribute4 := p1_a64;
2988 ddp_complete_rec.attribute5 := p1_a65;
2989 ddp_complete_rec.attribute6 := p1_a66;
2990 ddp_complete_rec.attribute7 := p1_a67;
2991 ddp_complete_rec.attribute8 := p1_a68;
2992 ddp_complete_rec.attribute9 := p1_a69;
2993 ddp_complete_rec.attribute10 := p1_a70;
2994 ddp_complete_rec.attribute11 := p1_a71;
2995 ddp_complete_rec.attribute12 := p1_a72;
2996 ddp_complete_rec.attribute13 := p1_a73;
2997 ddp_complete_rec.attribute14 := p1_a74;
2998 ddp_complete_rec.attribute15 := p1_a75;
2999 ddp_complete_rec.org_id := p1_a76;
3000 ddp_complete_rec.update_from_tbl_flag := p1_a77;
3001 ddp_complete_rec.tax_action := p1_a78;
3002 ddp_complete_rec.sale_date := rosetta_g_miss_date_in_map(p1_a79);
3003 ddp_complete_rec.item_type := p1_a80;
3004 ddp_complete_rec.tax_amount := p1_a81;
3005 ddp_complete_rec.claim_curr_tax_amount := p1_a82;
3006 ddp_complete_rec.activity_line_id := p1_a83;
3007 ddp_complete_rec.offer_type := p1_a84;
3008 ddp_complete_rec.prorate_earnings_flag := p1_a85;
3009 ddp_complete_rec.earnings_end_date := rosetta_g_miss_date_in_map(p1_a86);
3010 ddp_complete_rec.buy_group_party_id := p1_a87;
3011 ddp_complete_rec.acctd_tax_amount := p1_a88;
3012 ddp_complete_rec.dpp_cust_account_id := p1_a89;
3013 ddp_complete_rec.batch_line_id := p1_a90;
3014 ddp_complete_rec.activity_name := p1_a91;
3015
3016
3017 -- here's the delegated call to the old PL/SQL routine
3018 ozf_claim_line_pvt.check_claim_line_record(ddp_claim_line_rec,
3019 ddp_complete_rec,
3020 x_return_status);
3021
3022 -- copy data back from the local variables to OUT or IN-OUT args, if any
3023
3024
3025 end;
3026
3027 procedure init_claim_line_rec(p0_a0 out nocopy NUMBER
3028 , p0_a1 out nocopy NUMBER
3029 , p0_a2 out nocopy DATE
3030 , p0_a3 out nocopy NUMBER
3031 , p0_a4 out nocopy DATE
3032 , p0_a5 out nocopy NUMBER
3033 , p0_a6 out nocopy NUMBER
3034 , p0_a7 out nocopy NUMBER
3035 , p0_a8 out nocopy NUMBER
3036 , p0_a9 out nocopy DATE
3037 , p0_a10 out nocopy NUMBER
3038 , p0_a11 out nocopy VARCHAR2
3039 , p0_a12 out nocopy NUMBER
3040 , p0_a13 out nocopy NUMBER
3041 , p0_a14 out nocopy NUMBER
3042 , p0_a15 out nocopy NUMBER
3043 , p0_a16 out nocopy NUMBER
3044 , p0_a17 out nocopy NUMBER
3045 , p0_a18 out nocopy VARCHAR2
3046 , p0_a19 out nocopy VARCHAR2
3047 , p0_a20 out nocopy DATE
3048 , p0_a21 out nocopy NUMBER
3049 , p0_a22 out nocopy NUMBER
3050 , p0_a23 out nocopy VARCHAR2
3051 , p0_a24 out nocopy NUMBER
3052 , p0_a25 out nocopy NUMBER
3053 , p0_a26 out nocopy VARCHAR2
3054 , p0_a27 out nocopy NUMBER
3055 , p0_a28 out nocopy NUMBER
3056 , p0_a29 out nocopy NUMBER
3057 , p0_a30 out nocopy NUMBER
3058 , p0_a31 out nocopy VARCHAR2
3059 , p0_a32 out nocopy NUMBER
3060 , p0_a33 out nocopy VARCHAR2
3061 , p0_a34 out nocopy DATE
3062 , p0_a35 out nocopy NUMBER
3063 , p0_a36 out nocopy VARCHAR2
3064 , p0_a37 out nocopy VARCHAR2
3065 , p0_a38 out nocopy VARCHAR2
3066 , p0_a39 out nocopy DATE
3067 , p0_a40 out nocopy NUMBER
3068 , p0_a41 out nocopy DATE
3069 , p0_a42 out nocopy NUMBER
3070 , p0_a43 out nocopy VARCHAR2
3071 , p0_a44 out nocopy VARCHAR2
3072 , p0_a45 out nocopy VARCHAR2
3073 , p0_a46 out nocopy NUMBER
3074 , p0_a47 out nocopy VARCHAR2
3075 , p0_a48 out nocopy NUMBER
3076 , p0_a49 out nocopy VARCHAR2
3077 , p0_a50 out nocopy NUMBER
3078 , p0_a51 out nocopy VARCHAR2
3079 , p0_a52 out nocopy NUMBER
3080 , p0_a53 out nocopy NUMBER
3081 , p0_a54 out nocopy NUMBER
3082 , p0_a55 out nocopy VARCHAR2
3083 , p0_a56 out nocopy VARCHAR2
3084 , p0_a57 out nocopy VARCHAR2
3085 , p0_a58 out nocopy VARCHAR2
3086 , p0_a59 out nocopy VARCHAR2
3087 , p0_a60 out nocopy VARCHAR2
3088 , p0_a61 out nocopy VARCHAR2
3089 , p0_a62 out nocopy VARCHAR2
3090 , p0_a63 out nocopy VARCHAR2
3091 , p0_a64 out nocopy VARCHAR2
3092 , p0_a65 out nocopy VARCHAR2
3093 , p0_a66 out nocopy VARCHAR2
3094 , p0_a67 out nocopy VARCHAR2
3095 , p0_a68 out nocopy VARCHAR2
3096 , p0_a69 out nocopy VARCHAR2
3097 , p0_a70 out nocopy VARCHAR2
3098 , p0_a71 out nocopy VARCHAR2
3099 , p0_a72 out nocopy VARCHAR2
3100 , p0_a73 out nocopy VARCHAR2
3101 , p0_a74 out nocopy VARCHAR2
3102 , p0_a75 out nocopy VARCHAR2
3103 , p0_a76 out nocopy NUMBER
3104 , p0_a77 out nocopy VARCHAR2
3105 , p0_a78 out nocopy VARCHAR2
3106 , p0_a79 out nocopy DATE
3107 , p0_a80 out nocopy VARCHAR2
3108 , p0_a81 out nocopy NUMBER
3109 , p0_a82 out nocopy NUMBER
3110 , p0_a83 out nocopy NUMBER
3111 , p0_a84 out nocopy VARCHAR2
3112 , p0_a85 out nocopy VARCHAR2
3113 , p0_a86 out nocopy DATE
3114 , p0_a87 out nocopy NUMBER
3115 , p0_a88 out nocopy NUMBER
3116 , p0_a89 out nocopy VARCHAR2
3117 , p0_a90 out nocopy NUMBER
3118 , p0_a91 out nocopy VARCHAR2
3119 )
3120
3121 as
3122 ddx_claim_line_rec ozf_claim_line_pvt.claim_line_rec_type;
3123 ddindx binary_integer; indx binary_integer;
3124 begin
3125
3126 -- copy data to the local IN or IN-OUT args, if any
3127
3128 -- here's the delegated call to the old PL/SQL routine
3129 ozf_claim_line_pvt.init_claim_line_rec(ddx_claim_line_rec);
3130
3131 -- copy data back from the local variables to OUT or IN-OUT args, if any
3132 p0_a0 := ddx_claim_line_rec.claim_line_id;
3133 p0_a1 := ddx_claim_line_rec.object_version_number;
3134 p0_a2 := ddx_claim_line_rec.last_update_date;
3135 p0_a3 := ddx_claim_line_rec.last_updated_by;
3136 p0_a4 := ddx_claim_line_rec.creation_date;
3137 p0_a5 := ddx_claim_line_rec.created_by;
3138 p0_a6 := ddx_claim_line_rec.last_update_login;
3139 p0_a7 := ddx_claim_line_rec.request_id;
3140 p0_a8 := ddx_claim_line_rec.program_application_id;
3141 p0_a9 := ddx_claim_line_rec.program_update_date;
3142 p0_a10 := ddx_claim_line_rec.program_id;
3143 p0_a11 := ddx_claim_line_rec.created_from;
3144 p0_a12 := ddx_claim_line_rec.claim_id;
3145 p0_a13 := ddx_claim_line_rec.line_number;
3146 p0_a14 := ddx_claim_line_rec.split_from_claim_line_id;
3147 p0_a15 := ddx_claim_line_rec.amount;
3148 p0_a16 := ddx_claim_line_rec.claim_currency_amount;
3149 p0_a17 := ddx_claim_line_rec.acctd_amount;
3150 p0_a18 := ddx_claim_line_rec.currency_code;
3151 p0_a19 := ddx_claim_line_rec.exchange_rate_type;
3152 p0_a20 := ddx_claim_line_rec.exchange_rate_date;
3153 p0_a21 := ddx_claim_line_rec.exchange_rate;
3154 p0_a22 := ddx_claim_line_rec.set_of_books_id;
3155 p0_a23 := ddx_claim_line_rec.valid_flag;
3156 p0_a24 := ddx_claim_line_rec.source_object_id;
3157 p0_a25 := ddx_claim_line_rec.source_object_line_id;
3158 p0_a26 := ddx_claim_line_rec.source_object_class;
3159 p0_a27 := ddx_claim_line_rec.source_object_type_id;
3160 p0_a28 := ddx_claim_line_rec.plan_id;
3161 p0_a29 := ddx_claim_line_rec.offer_id;
3162 p0_a30 := ddx_claim_line_rec.utilization_id;
3163 p0_a31 := ddx_claim_line_rec.payment_method;
3164 p0_a32 := ddx_claim_line_rec.payment_reference_id;
3165 p0_a33 := ddx_claim_line_rec.payment_reference_number;
3166 p0_a34 := ddx_claim_line_rec.payment_reference_date;
3167 p0_a35 := ddx_claim_line_rec.voucher_id;
3168 p0_a36 := ddx_claim_line_rec.voucher_number;
3169 p0_a37 := ddx_claim_line_rec.payment_status;
3170 p0_a38 := ddx_claim_line_rec.approved_flag;
3171 p0_a39 := ddx_claim_line_rec.approved_date;
3172 p0_a40 := ddx_claim_line_rec.approved_by;
3173 p0_a41 := ddx_claim_line_rec.settled_date;
3174 p0_a42 := ddx_claim_line_rec.settled_by;
3175 p0_a43 := ddx_claim_line_rec.performance_complete_flag;
3176 p0_a44 := ddx_claim_line_rec.performance_attached_flag;
3177 p0_a45 := ddx_claim_line_rec.select_cust_children_flag;
3178 p0_a46 := ddx_claim_line_rec.item_id;
3179 p0_a47 := ddx_claim_line_rec.item_description;
3180 p0_a48 := ddx_claim_line_rec.quantity;
3181 p0_a49 := ddx_claim_line_rec.quantity_uom;
3182 p0_a50 := ddx_claim_line_rec.rate;
3183 p0_a51 := ddx_claim_line_rec.activity_type;
3184 p0_a52 := ddx_claim_line_rec.activity_id;
3185 p0_a53 := ddx_claim_line_rec.related_cust_account_id;
3186 p0_a54 := ddx_claim_line_rec.buy_group_cust_account_id;
3187 p0_a55 := ddx_claim_line_rec.relationship_type;
3188 p0_a56 := ddx_claim_line_rec.earnings_associated_flag;
3189 p0_a57 := ddx_claim_line_rec.comments;
3190 p0_a58 := ddx_claim_line_rec.tax_code;
3191 p0_a59 := ddx_claim_line_rec.credit_to;
3192 p0_a60 := ddx_claim_line_rec.attribute_category;
3193 p0_a61 := ddx_claim_line_rec.attribute1;
3194 p0_a62 := ddx_claim_line_rec.attribute2;
3195 p0_a63 := ddx_claim_line_rec.attribute3;
3196 p0_a64 := ddx_claim_line_rec.attribute4;
3197 p0_a65 := ddx_claim_line_rec.attribute5;
3198 p0_a66 := ddx_claim_line_rec.attribute6;
3199 p0_a67 := ddx_claim_line_rec.attribute7;
3200 p0_a68 := ddx_claim_line_rec.attribute8;
3201 p0_a69 := ddx_claim_line_rec.attribute9;
3202 p0_a70 := ddx_claim_line_rec.attribute10;
3203 p0_a71 := ddx_claim_line_rec.attribute11;
3204 p0_a72 := ddx_claim_line_rec.attribute12;
3205 p0_a73 := ddx_claim_line_rec.attribute13;
3206 p0_a74 := ddx_claim_line_rec.attribute14;
3207 p0_a75 := ddx_claim_line_rec.attribute15;
3208 p0_a76 := ddx_claim_line_rec.org_id;
3209 p0_a77 := ddx_claim_line_rec.update_from_tbl_flag;
3210 p0_a78 := ddx_claim_line_rec.tax_action;
3211 p0_a79 := ddx_claim_line_rec.sale_date;
3212 p0_a80 := ddx_claim_line_rec.item_type;
3213 p0_a81 := ddx_claim_line_rec.tax_amount;
3214 p0_a82 := ddx_claim_line_rec.claim_curr_tax_amount;
3215 p0_a83 := ddx_claim_line_rec.activity_line_id;
3216 p0_a84 := ddx_claim_line_rec.offer_type;
3217 p0_a85 := ddx_claim_line_rec.prorate_earnings_flag;
3218 p0_a86 := ddx_claim_line_rec.earnings_end_date;
3219 p0_a87 := ddx_claim_line_rec.buy_group_party_id;
3220 p0_a88 := ddx_claim_line_rec.acctd_tax_amount;
3221 p0_a89 := ddx_claim_line_rec.dpp_cust_account_id;
3222 p0_a90 := ddx_claim_line_rec.batch_line_id;
3223 p0_a91 := ddx_claim_line_rec.activity_name;
3224 end;
3225
3226 procedure complete_claim_line_rec(p0_a0 NUMBER
3227 , p0_a1 NUMBER
3228 , p0_a2 DATE
3229 , p0_a3 NUMBER
3230 , p0_a4 DATE
3231 , p0_a5 NUMBER
3232 , p0_a6 NUMBER
3233 , p0_a7 NUMBER
3234 , p0_a8 NUMBER
3235 , p0_a9 DATE
3236 , p0_a10 NUMBER
3237 , p0_a11 VARCHAR2
3238 , p0_a12 NUMBER
3239 , p0_a13 NUMBER
3240 , p0_a14 NUMBER
3241 , p0_a15 NUMBER
3242 , p0_a16 NUMBER
3243 , p0_a17 NUMBER
3244 , p0_a18 VARCHAR2
3245 , p0_a19 VARCHAR2
3246 , p0_a20 DATE
3247 , p0_a21 NUMBER
3248 , p0_a22 NUMBER
3249 , p0_a23 VARCHAR2
3250 , p0_a24 NUMBER
3251 , p0_a25 NUMBER
3252 , p0_a26 VARCHAR2
3253 , p0_a27 NUMBER
3254 , p0_a28 NUMBER
3255 , p0_a29 NUMBER
3256 , p0_a30 NUMBER
3257 , p0_a31 VARCHAR2
3258 , p0_a32 NUMBER
3259 , p0_a33 VARCHAR2
3260 , p0_a34 DATE
3261 , p0_a35 NUMBER
3262 , p0_a36 VARCHAR2
3263 , p0_a37 VARCHAR2
3264 , p0_a38 VARCHAR2
3265 , p0_a39 DATE
3266 , p0_a40 NUMBER
3267 , p0_a41 DATE
3268 , p0_a42 NUMBER
3269 , p0_a43 VARCHAR2
3270 , p0_a44 VARCHAR2
3271 , p0_a45 VARCHAR2
3272 , p0_a46 NUMBER
3273 , p0_a47 VARCHAR2
3274 , p0_a48 NUMBER
3275 , p0_a49 VARCHAR2
3276 , p0_a50 NUMBER
3277 , p0_a51 VARCHAR2
3278 , p0_a52 NUMBER
3279 , p0_a53 NUMBER
3280 , p0_a54 NUMBER
3281 , p0_a55 VARCHAR2
3282 , p0_a56 VARCHAR2
3283 , p0_a57 VARCHAR2
3284 , p0_a58 VARCHAR2
3285 , p0_a59 VARCHAR2
3286 , p0_a60 VARCHAR2
3287 , p0_a61 VARCHAR2
3288 , p0_a62 VARCHAR2
3289 , p0_a63 VARCHAR2
3290 , p0_a64 VARCHAR2
3291 , p0_a65 VARCHAR2
3292 , p0_a66 VARCHAR2
3293 , p0_a67 VARCHAR2
3294 , p0_a68 VARCHAR2
3295 , p0_a69 VARCHAR2
3296 , p0_a70 VARCHAR2
3297 , p0_a71 VARCHAR2
3298 , p0_a72 VARCHAR2
3299 , p0_a73 VARCHAR2
3300 , p0_a74 VARCHAR2
3301 , p0_a75 VARCHAR2
3302 , p0_a76 NUMBER
3303 , p0_a77 VARCHAR2
3304 , p0_a78 VARCHAR2
3305 , p0_a79 DATE
3306 , p0_a80 VARCHAR2
3307 , p0_a81 NUMBER
3308 , p0_a82 NUMBER
3309 , p0_a83 NUMBER
3310 , p0_a84 VARCHAR2
3311 , p0_a85 VARCHAR2
3312 , p0_a86 DATE
3313 , p0_a87 NUMBER
3314 , p0_a88 NUMBER
3315 , p0_a89 VARCHAR2
3316 , p0_a90 NUMBER
3317 , p0_a91 VARCHAR2
3318 , p1_a0 out nocopy NUMBER
3319 , p1_a1 out nocopy NUMBER
3320 , p1_a2 out nocopy DATE
3321 , p1_a3 out nocopy NUMBER
3322 , p1_a4 out nocopy DATE
3323 , p1_a5 out nocopy NUMBER
3324 , p1_a6 out nocopy NUMBER
3325 , p1_a7 out nocopy NUMBER
3326 , p1_a8 out nocopy NUMBER
3327 , p1_a9 out nocopy DATE
3328 , p1_a10 out nocopy NUMBER
3329 , p1_a11 out nocopy VARCHAR2
3330 , p1_a12 out nocopy NUMBER
3331 , p1_a13 out nocopy NUMBER
3332 , p1_a14 out nocopy NUMBER
3333 , p1_a15 out nocopy NUMBER
3334 , p1_a16 out nocopy NUMBER
3335 , p1_a17 out nocopy NUMBER
3336 , p1_a18 out nocopy VARCHAR2
3337 , p1_a19 out nocopy VARCHAR2
3338 , p1_a20 out nocopy DATE
3339 , p1_a21 out nocopy NUMBER
3340 , p1_a22 out nocopy NUMBER
3341 , p1_a23 out nocopy VARCHAR2
3342 , p1_a24 out nocopy NUMBER
3343 , p1_a25 out nocopy NUMBER
3344 , p1_a26 out nocopy VARCHAR2
3345 , p1_a27 out nocopy NUMBER
3346 , p1_a28 out nocopy NUMBER
3347 , p1_a29 out nocopy NUMBER
3348 , p1_a30 out nocopy NUMBER
3349 , p1_a31 out nocopy VARCHAR2
3350 , p1_a32 out nocopy NUMBER
3351 , p1_a33 out nocopy VARCHAR2
3352 , p1_a34 out nocopy DATE
3353 , p1_a35 out nocopy NUMBER
3354 , p1_a36 out nocopy VARCHAR2
3355 , p1_a37 out nocopy VARCHAR2
3356 , p1_a38 out nocopy VARCHAR2
3357 , p1_a39 out nocopy DATE
3358 , p1_a40 out nocopy NUMBER
3359 , p1_a41 out nocopy DATE
3360 , p1_a42 out nocopy NUMBER
3361 , p1_a43 out nocopy VARCHAR2
3362 , p1_a44 out nocopy VARCHAR2
3363 , p1_a45 out nocopy VARCHAR2
3364 , p1_a46 out nocopy NUMBER
3365 , p1_a47 out nocopy VARCHAR2
3366 , p1_a48 out nocopy NUMBER
3367 , p1_a49 out nocopy VARCHAR2
3368 , p1_a50 out nocopy NUMBER
3369 , p1_a51 out nocopy VARCHAR2
3370 , p1_a52 out nocopy NUMBER
3371 , p1_a53 out nocopy NUMBER
3372 , p1_a54 out nocopy NUMBER
3373 , p1_a55 out nocopy VARCHAR2
3374 , p1_a56 out nocopy VARCHAR2
3375 , p1_a57 out nocopy VARCHAR2
3376 , p1_a58 out nocopy VARCHAR2
3377 , p1_a59 out nocopy VARCHAR2
3378 , p1_a60 out nocopy VARCHAR2
3379 , p1_a61 out nocopy VARCHAR2
3380 , p1_a62 out nocopy VARCHAR2
3381 , p1_a63 out nocopy VARCHAR2
3382 , p1_a64 out nocopy VARCHAR2
3383 , p1_a65 out nocopy VARCHAR2
3384 , p1_a66 out nocopy VARCHAR2
3385 , p1_a67 out nocopy VARCHAR2
3386 , p1_a68 out nocopy VARCHAR2
3387 , p1_a69 out nocopy VARCHAR2
3388 , p1_a70 out nocopy VARCHAR2
3389 , p1_a71 out nocopy VARCHAR2
3390 , p1_a72 out nocopy VARCHAR2
3391 , p1_a73 out nocopy VARCHAR2
3392 , p1_a74 out nocopy VARCHAR2
3393 , p1_a75 out nocopy VARCHAR2
3394 , p1_a76 out nocopy NUMBER
3395 , p1_a77 out nocopy VARCHAR2
3396 , p1_a78 out nocopy VARCHAR2
3397 , p1_a79 out nocopy DATE
3398 , p1_a80 out nocopy VARCHAR2
3399 , p1_a81 out nocopy NUMBER
3400 , p1_a82 out nocopy NUMBER
3401 , p1_a83 out nocopy NUMBER
3402 , p1_a84 out nocopy VARCHAR2
3403 , p1_a85 out nocopy VARCHAR2
3404 , p1_a86 out nocopy DATE
3405 , p1_a87 out nocopy NUMBER
3406 , p1_a88 out nocopy NUMBER
3407 , p1_a89 out nocopy VARCHAR2
3408 , p1_a90 out nocopy NUMBER
3409 , p1_a91 out nocopy VARCHAR2
3410 )
3411
3412 as
3413 ddp_claim_line_rec ozf_claim_line_pvt.claim_line_rec_type;
3414 ddx_complete_rec ozf_claim_line_pvt.claim_line_rec_type;
3415 ddindx binary_integer; indx binary_integer;
3416 begin
3417
3418 -- copy data to the local IN or IN-OUT args, if any
3419 ddp_claim_line_rec.claim_line_id := p0_a0;
3420 ddp_claim_line_rec.object_version_number := p0_a1;
3421 ddp_claim_line_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a2);
3422 ddp_claim_line_rec.last_updated_by := p0_a3;
3423 ddp_claim_line_rec.creation_date := rosetta_g_miss_date_in_map(p0_a4);
3424 ddp_claim_line_rec.created_by := p0_a5;
3425 ddp_claim_line_rec.last_update_login := p0_a6;
3426 ddp_claim_line_rec.request_id := p0_a7;
3427 ddp_claim_line_rec.program_application_id := p0_a8;
3428 ddp_claim_line_rec.program_update_date := rosetta_g_miss_date_in_map(p0_a9);
3429 ddp_claim_line_rec.program_id := p0_a10;
3430 ddp_claim_line_rec.created_from := p0_a11;
3431 ddp_claim_line_rec.claim_id := p0_a12;
3432 ddp_claim_line_rec.line_number := p0_a13;
3433 ddp_claim_line_rec.split_from_claim_line_id := p0_a14;
3434 ddp_claim_line_rec.amount := p0_a15;
3435 ddp_claim_line_rec.claim_currency_amount := p0_a16;
3436 ddp_claim_line_rec.acctd_amount := p0_a17;
3437 ddp_claim_line_rec.currency_code := p0_a18;
3438 ddp_claim_line_rec.exchange_rate_type := p0_a19;
3439 ddp_claim_line_rec.exchange_rate_date := rosetta_g_miss_date_in_map(p0_a20);
3440 ddp_claim_line_rec.exchange_rate := p0_a21;
3441 ddp_claim_line_rec.set_of_books_id := p0_a22;
3442 ddp_claim_line_rec.valid_flag := p0_a23;
3443 ddp_claim_line_rec.source_object_id := p0_a24;
3444 ddp_claim_line_rec.source_object_line_id := p0_a25;
3445 ddp_claim_line_rec.source_object_class := p0_a26;
3446 ddp_claim_line_rec.source_object_type_id := p0_a27;
3447 ddp_claim_line_rec.plan_id := p0_a28;
3448 ddp_claim_line_rec.offer_id := p0_a29;
3449 ddp_claim_line_rec.utilization_id := p0_a30;
3450 ddp_claim_line_rec.payment_method := p0_a31;
3451 ddp_claim_line_rec.payment_reference_id := p0_a32;
3452 ddp_claim_line_rec.payment_reference_number := p0_a33;
3453 ddp_claim_line_rec.payment_reference_date := rosetta_g_miss_date_in_map(p0_a34);
3454 ddp_claim_line_rec.voucher_id := p0_a35;
3455 ddp_claim_line_rec.voucher_number := p0_a36;
3456 ddp_claim_line_rec.payment_status := p0_a37;
3457 ddp_claim_line_rec.approved_flag := p0_a38;
3458 ddp_claim_line_rec.approved_date := rosetta_g_miss_date_in_map(p0_a39);
3459 ddp_claim_line_rec.approved_by := p0_a40;
3460 ddp_claim_line_rec.settled_date := rosetta_g_miss_date_in_map(p0_a41);
3461 ddp_claim_line_rec.settled_by := p0_a42;
3462 ddp_claim_line_rec.performance_complete_flag := p0_a43;
3463 ddp_claim_line_rec.performance_attached_flag := p0_a44;
3464 ddp_claim_line_rec.select_cust_children_flag := p0_a45;
3465 ddp_claim_line_rec.item_id := p0_a46;
3466 ddp_claim_line_rec.item_description := p0_a47;
3467 ddp_claim_line_rec.quantity := p0_a48;
3468 ddp_claim_line_rec.quantity_uom := p0_a49;
3469 ddp_claim_line_rec.rate := p0_a50;
3470 ddp_claim_line_rec.activity_type := p0_a51;
3471 ddp_claim_line_rec.activity_id := p0_a52;
3472 ddp_claim_line_rec.related_cust_account_id := p0_a53;
3473 ddp_claim_line_rec.buy_group_cust_account_id := p0_a54;
3474 ddp_claim_line_rec.relationship_type := p0_a55;
3475 ddp_claim_line_rec.earnings_associated_flag := p0_a56;
3476 ddp_claim_line_rec.comments := p0_a57;
3477 ddp_claim_line_rec.tax_code := p0_a58;
3478 ddp_claim_line_rec.credit_to := p0_a59;
3479 ddp_claim_line_rec.attribute_category := p0_a60;
3480 ddp_claim_line_rec.attribute1 := p0_a61;
3481 ddp_claim_line_rec.attribute2 := p0_a62;
3482 ddp_claim_line_rec.attribute3 := p0_a63;
3483 ddp_claim_line_rec.attribute4 := p0_a64;
3484 ddp_claim_line_rec.attribute5 := p0_a65;
3485 ddp_claim_line_rec.attribute6 := p0_a66;
3486 ddp_claim_line_rec.attribute7 := p0_a67;
3487 ddp_claim_line_rec.attribute8 := p0_a68;
3488 ddp_claim_line_rec.attribute9 := p0_a69;
3489 ddp_claim_line_rec.attribute10 := p0_a70;
3490 ddp_claim_line_rec.attribute11 := p0_a71;
3491 ddp_claim_line_rec.attribute12 := p0_a72;
3492 ddp_claim_line_rec.attribute13 := p0_a73;
3493 ddp_claim_line_rec.attribute14 := p0_a74;
3494 ddp_claim_line_rec.attribute15 := p0_a75;
3495 ddp_claim_line_rec.org_id := p0_a76;
3496 ddp_claim_line_rec.update_from_tbl_flag := p0_a77;
3497 ddp_claim_line_rec.tax_action := p0_a78;
3498 ddp_claim_line_rec.sale_date := rosetta_g_miss_date_in_map(p0_a79);
3499 ddp_claim_line_rec.item_type := p0_a80;
3500 ddp_claim_line_rec.tax_amount := p0_a81;
3501 ddp_claim_line_rec.claim_curr_tax_amount := p0_a82;
3502 ddp_claim_line_rec.activity_line_id := p0_a83;
3503 ddp_claim_line_rec.offer_type := p0_a84;
3504 ddp_claim_line_rec.prorate_earnings_flag := p0_a85;
3505 ddp_claim_line_rec.earnings_end_date := rosetta_g_miss_date_in_map(p0_a86);
3506 ddp_claim_line_rec.buy_group_party_id := p0_a87;
3507 ddp_claim_line_rec.acctd_tax_amount := p0_a88;
3508 ddp_claim_line_rec.dpp_cust_account_id := p0_a89;
3509 ddp_claim_line_rec.batch_line_id := p0_a90;
3510 ddp_claim_line_rec.activity_name := p0_a91;
3511
3512
3513 -- here's the delegated call to the old PL/SQL routine
3514 ozf_claim_line_pvt.complete_claim_line_rec(ddp_claim_line_rec,
3515 ddx_complete_rec);
3516
3517 -- copy data back from the local variables to OUT or IN-OUT args, if any
3518
3519 p1_a0 := ddx_complete_rec.claim_line_id;
3520 p1_a1 := ddx_complete_rec.object_version_number;
3521 p1_a2 := ddx_complete_rec.last_update_date;
3522 p1_a3 := ddx_complete_rec.last_updated_by;
3523 p1_a4 := ddx_complete_rec.creation_date;
3524 p1_a5 := ddx_complete_rec.created_by;
3525 p1_a6 := ddx_complete_rec.last_update_login;
3526 p1_a7 := ddx_complete_rec.request_id;
3527 p1_a8 := ddx_complete_rec.program_application_id;
3528 p1_a9 := ddx_complete_rec.program_update_date;
3529 p1_a10 := ddx_complete_rec.program_id;
3530 p1_a11 := ddx_complete_rec.created_from;
3531 p1_a12 := ddx_complete_rec.claim_id;
3532 p1_a13 := ddx_complete_rec.line_number;
3533 p1_a14 := ddx_complete_rec.split_from_claim_line_id;
3534 p1_a15 := ddx_complete_rec.amount;
3535 p1_a16 := ddx_complete_rec.claim_currency_amount;
3536 p1_a17 := ddx_complete_rec.acctd_amount;
3537 p1_a18 := ddx_complete_rec.currency_code;
3538 p1_a19 := ddx_complete_rec.exchange_rate_type;
3539 p1_a20 := ddx_complete_rec.exchange_rate_date;
3540 p1_a21 := ddx_complete_rec.exchange_rate;
3541 p1_a22 := ddx_complete_rec.set_of_books_id;
3542 p1_a23 := ddx_complete_rec.valid_flag;
3543 p1_a24 := ddx_complete_rec.source_object_id;
3544 p1_a25 := ddx_complete_rec.source_object_line_id;
3545 p1_a26 := ddx_complete_rec.source_object_class;
3546 p1_a27 := ddx_complete_rec.source_object_type_id;
3547 p1_a28 := ddx_complete_rec.plan_id;
3548 p1_a29 := ddx_complete_rec.offer_id;
3549 p1_a30 := ddx_complete_rec.utilization_id;
3550 p1_a31 := ddx_complete_rec.payment_method;
3551 p1_a32 := ddx_complete_rec.payment_reference_id;
3552 p1_a33 := ddx_complete_rec.payment_reference_number;
3553 p1_a34 := ddx_complete_rec.payment_reference_date;
3554 p1_a35 := ddx_complete_rec.voucher_id;
3555 p1_a36 := ddx_complete_rec.voucher_number;
3556 p1_a37 := ddx_complete_rec.payment_status;
3557 p1_a38 := ddx_complete_rec.approved_flag;
3558 p1_a39 := ddx_complete_rec.approved_date;
3559 p1_a40 := ddx_complete_rec.approved_by;
3560 p1_a41 := ddx_complete_rec.settled_date;
3561 p1_a42 := ddx_complete_rec.settled_by;
3562 p1_a43 := ddx_complete_rec.performance_complete_flag;
3563 p1_a44 := ddx_complete_rec.performance_attached_flag;
3564 p1_a45 := ddx_complete_rec.select_cust_children_flag;
3565 p1_a46 := ddx_complete_rec.item_id;
3566 p1_a47 := ddx_complete_rec.item_description;
3567 p1_a48 := ddx_complete_rec.quantity;
3568 p1_a49 := ddx_complete_rec.quantity_uom;
3569 p1_a50 := ddx_complete_rec.rate;
3570 p1_a51 := ddx_complete_rec.activity_type;
3571 p1_a52 := ddx_complete_rec.activity_id;
3572 p1_a53 := ddx_complete_rec.related_cust_account_id;
3573 p1_a54 := ddx_complete_rec.buy_group_cust_account_id;
3574 p1_a55 := ddx_complete_rec.relationship_type;
3575 p1_a56 := ddx_complete_rec.earnings_associated_flag;
3576 p1_a57 := ddx_complete_rec.comments;
3577 p1_a58 := ddx_complete_rec.tax_code;
3578 p1_a59 := ddx_complete_rec.credit_to;
3579 p1_a60 := ddx_complete_rec.attribute_category;
3580 p1_a61 := ddx_complete_rec.attribute1;
3581 p1_a62 := ddx_complete_rec.attribute2;
3582 p1_a63 := ddx_complete_rec.attribute3;
3583 p1_a64 := ddx_complete_rec.attribute4;
3584 p1_a65 := ddx_complete_rec.attribute5;
3585 p1_a66 := ddx_complete_rec.attribute6;
3586 p1_a67 := ddx_complete_rec.attribute7;
3587 p1_a68 := ddx_complete_rec.attribute8;
3588 p1_a69 := ddx_complete_rec.attribute9;
3589 p1_a70 := ddx_complete_rec.attribute10;
3590 p1_a71 := ddx_complete_rec.attribute11;
3591 p1_a72 := ddx_complete_rec.attribute12;
3592 p1_a73 := ddx_complete_rec.attribute13;
3593 p1_a74 := ddx_complete_rec.attribute14;
3594 p1_a75 := ddx_complete_rec.attribute15;
3595 p1_a76 := ddx_complete_rec.org_id;
3596 p1_a77 := ddx_complete_rec.update_from_tbl_flag;
3597 p1_a78 := ddx_complete_rec.tax_action;
3598 p1_a79 := ddx_complete_rec.sale_date;
3599 p1_a80 := ddx_complete_rec.item_type;
3600 p1_a81 := ddx_complete_rec.tax_amount;
3601 p1_a82 := ddx_complete_rec.claim_curr_tax_amount;
3602 p1_a83 := ddx_complete_rec.activity_line_id;
3603 p1_a84 := ddx_complete_rec.offer_type;
3604 p1_a85 := ddx_complete_rec.prorate_earnings_flag;
3605 p1_a86 := ddx_complete_rec.earnings_end_date;
3606 p1_a87 := ddx_complete_rec.buy_group_party_id;
3607 p1_a88 := ddx_complete_rec.acctd_tax_amount;
3608 p1_a89 := ddx_complete_rec.dpp_cust_account_id;
3609 p1_a90 := ddx_complete_rec.batch_line_id;
3610 p1_a91 := ddx_complete_rec.activity_name;
3611 end;
3612
3613 end ozf_claim_line_pvt_w;