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