[Home] [Help]
PACKAGE BODY: APPS.OZF_ACTBUDGETS_PVT_W
Source
1 package body ozf_actbudgets_pvt_w as
2 /* $Header: ozfwbdgb.pls 120.6 2008/08/14 15:45:03 nirprasa 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_act_budgets(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 DATE
27 , p7_a4 NUMBER
28 , p7_a5 NUMBER
29 , p7_a6 NUMBER
30 , p7_a7 NUMBER
31 , p7_a8 VARCHAR2
32 , p7_a9 VARCHAR2
33 , p7_a10 NUMBER
34 , p7_a11 VARCHAR2
35 , p7_a12 NUMBER
36 , p7_a13 VARCHAR2
37 , p7_a14 DATE
38 , p7_a15 NUMBER
39 , p7_a16 VARCHAR2
40 , p7_a17 NUMBER
41 , p7_a18 NUMBER
42 , p7_a19 VARCHAR2
43 , p7_a20 DATE
44 , p7_a21 NUMBER
45 , p7_a22 NUMBER
46 , p7_a23 VARCHAR2
47 , p7_a24 DATE
48 , p7_a25 VARCHAR2
49 , p7_a26 VARCHAR2
50 , p7_a27 VARCHAR2
51 , p7_a28 VARCHAR
52 , p7_a29 VARCHAR
53 , p7_a30 NUMBER
54 , p7_a31 NUMBER
55 , p7_a32 VARCHAR2
56 , p7_a33 VARCHAR2
57 , p7_a34 NUMBER
58 , p7_a35 DATE
59 , p7_a36 NUMBER
60 , p7_a37 VARCHAR2
61 , p7_a38 NUMBER
62 , p7_a39 VARCHAR2
63 , p7_a40 NUMBER
64 , p7_a41 NUMBER
65 , p7_a42 NUMBER
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 VARCHAR2
73 , p7_a50 VARCHAR2
74 , p7_a51 VARCHAR2
75 , p7_a52 VARCHAR2
76 , p7_a53 VARCHAR2
77 , p7_a54 VARCHAR2
78 , p7_a55 VARCHAR2
79 , p7_a56 VARCHAR2
80 , p7_a57 VARCHAR2
81 , p7_a58 VARCHAR2
82 , p7_a59 VARCHAR2
83 , p7_a60 NUMBER
84 , x_act_budget_id out nocopy NUMBER
85 )
86
87 as
88 ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
89 ddindx binary_integer; indx binary_integer;
90 begin
91
92 -- copy data to the local IN or IN-OUT args, if any
93
94
95
96
97
98
99
100 ddp_act_budgets_rec.activity_budget_id := p7_a0;
101 ddp_act_budgets_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
102 ddp_act_budgets_rec.last_updated_by := p7_a2;
103 ddp_act_budgets_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
104 ddp_act_budgets_rec.created_by := p7_a4;
105 ddp_act_budgets_rec.last_update_login := p7_a5;
106 ddp_act_budgets_rec.object_version_number := p7_a6;
107 ddp_act_budgets_rec.act_budget_used_by_id := p7_a7;
108 ddp_act_budgets_rec.arc_act_budget_used_by := p7_a8;
109 ddp_act_budgets_rec.budget_source_type := p7_a9;
110 ddp_act_budgets_rec.budget_source_id := p7_a10;
111 ddp_act_budgets_rec.transaction_type := p7_a11;
112 ddp_act_budgets_rec.request_amount := p7_a12;
113 ddp_act_budgets_rec.request_currency := p7_a13;
114 ddp_act_budgets_rec.request_date := rosetta_g_miss_date_in_map(p7_a14);
115 ddp_act_budgets_rec.user_status_id := p7_a15;
116 ddp_act_budgets_rec.status_code := p7_a16;
117 ddp_act_budgets_rec.approved_amount := p7_a17;
118 ddp_act_budgets_rec.approved_original_amount := p7_a18;
119 ddp_act_budgets_rec.approved_in_currency := p7_a19;
120 ddp_act_budgets_rec.approval_date := rosetta_g_miss_date_in_map(p7_a20);
121 ddp_act_budgets_rec.approver_id := p7_a21;
122 ddp_act_budgets_rec.spent_amount := p7_a22;
123 ddp_act_budgets_rec.partner_po_number := p7_a23;
124 ddp_act_budgets_rec.partner_po_date := rosetta_g_miss_date_in_map(p7_a24);
125 ddp_act_budgets_rec.partner_po_approver := p7_a25;
126 ddp_act_budgets_rec.adjusted_flag := p7_a26;
127 ddp_act_budgets_rec.posted_flag := p7_a27;
128 ddp_act_budgets_rec.justification := p7_a28;
129 ddp_act_budgets_rec.comment := p7_a29;
130 ddp_act_budgets_rec.parent_act_budget_id := p7_a30;
131 ddp_act_budgets_rec.contact_id := p7_a31;
132 ddp_act_budgets_rec.reason_code := p7_a32;
133 ddp_act_budgets_rec.transfer_type := p7_a33;
134 ddp_act_budgets_rec.requester_id := p7_a34;
135 ddp_act_budgets_rec.date_required_by := rosetta_g_miss_date_in_map(p7_a35);
136 ddp_act_budgets_rec.parent_source_id := p7_a36;
137 ddp_act_budgets_rec.parent_src_curr := p7_a37;
138 ddp_act_budgets_rec.parent_src_apprvd_amt := p7_a38;
139 ddp_act_budgets_rec.partner_holding_type := p7_a39;
140 ddp_act_budgets_rec.partner_address_id := p7_a40;
141 ddp_act_budgets_rec.vendor_id := p7_a41;
142 ddp_act_budgets_rec.owner_id := p7_a42;
143 ddp_act_budgets_rec.recal_flag := p7_a43;
144 ddp_act_budgets_rec.attribute_category := p7_a44;
145 ddp_act_budgets_rec.attribute1 := p7_a45;
146 ddp_act_budgets_rec.attribute2 := p7_a46;
147 ddp_act_budgets_rec.attribute3 := p7_a47;
148 ddp_act_budgets_rec.attribute4 := p7_a48;
149 ddp_act_budgets_rec.attribute5 := p7_a49;
150 ddp_act_budgets_rec.attribute6 := p7_a50;
151 ddp_act_budgets_rec.attribute7 := p7_a51;
152 ddp_act_budgets_rec.attribute8 := p7_a52;
153 ddp_act_budgets_rec.attribute9 := p7_a53;
154 ddp_act_budgets_rec.attribute10 := p7_a54;
155 ddp_act_budgets_rec.attribute11 := p7_a55;
156 ddp_act_budgets_rec.attribute12 := p7_a56;
157 ddp_act_budgets_rec.attribute13 := p7_a57;
158 ddp_act_budgets_rec.attribute14 := p7_a58;
159 ddp_act_budgets_rec.attribute15 := p7_a59;
160 ddp_act_budgets_rec.src_curr_req_amt := p7_a60;
161
162
163 -- here's the delegated call to the old PL/SQL routine
164 ozf_actbudgets_pvt.create_act_budgets(p_api_version,
165 p_init_msg_list,
166 p_commit,
167 p_validation_level,
168 x_return_status,
169 x_msg_count,
170 x_msg_data,
171 ddp_act_budgets_rec,
172 x_act_budget_id);
173
174 -- copy data back from the local variables to OUT or IN-OUT args, if any
175
176
177
178
179
180
181
182
183 end;
184
185 procedure create_act_budgets(p_api_version NUMBER
186 , p_init_msg_list VARCHAR2
187 , p_commit VARCHAR2
188 , p_validation_level NUMBER
189 , x_return_status out nocopy VARCHAR2
190 , x_msg_count out nocopy NUMBER
191 , x_msg_data out nocopy VARCHAR2
192 , p7_a0 NUMBER
193 , p7_a1 DATE
194 , p7_a2 NUMBER
195 , p7_a3 DATE
196 , p7_a4 NUMBER
197 , p7_a5 NUMBER
198 , p7_a6 NUMBER
199 , p7_a7 NUMBER
200 , p7_a8 VARCHAR2
201 , p7_a9 VARCHAR2
202 , p7_a10 NUMBER
203 , p7_a11 VARCHAR2
204 , p7_a12 NUMBER
205 , p7_a13 VARCHAR2
206 , p7_a14 DATE
207 , p7_a15 NUMBER
208 , p7_a16 VARCHAR2
209 , p7_a17 NUMBER
210 , p7_a18 NUMBER
211 , p7_a19 VARCHAR2
212 , p7_a20 DATE
213 , p7_a21 NUMBER
214 , p7_a22 NUMBER
215 , p7_a23 VARCHAR2
216 , p7_a24 DATE
217 , p7_a25 VARCHAR2
218 , p7_a26 VARCHAR2
219 , p7_a27 VARCHAR2
220 , p7_a28 VARCHAR
221 , p7_a29 VARCHAR
222 , p7_a30 NUMBER
223 , p7_a31 NUMBER
224 , p7_a32 VARCHAR2
225 , p7_a33 VARCHAR2
226 , p7_a34 NUMBER
227 , p7_a35 DATE
228 , p7_a36 NUMBER
229 , p7_a37 VARCHAR2
230 , p7_a38 NUMBER
231 , p7_a39 VARCHAR2
232 , p7_a40 NUMBER
233 , p7_a41 NUMBER
234 , p7_a42 NUMBER
235 , p7_a43 VARCHAR2
236 , p7_a44 VARCHAR2
237 , p7_a45 VARCHAR2
238 , p7_a46 VARCHAR2
239 , p7_a47 VARCHAR2
240 , p7_a48 VARCHAR2
241 , p7_a49 VARCHAR2
242 , p7_a50 VARCHAR2
243 , p7_a51 VARCHAR2
244 , p7_a52 VARCHAR2
245 , p7_a53 VARCHAR2
246 , p7_a54 VARCHAR2
247 , p7_a55 VARCHAR2
248 , p7_a56 VARCHAR2
249 , p7_a57 VARCHAR2
250 , p7_a58 VARCHAR2
251 , p7_a59 VARCHAR2
252 , p7_a60 NUMBER
253 , p8_a0 VARCHAR2
254 , p8_a1 NUMBER
255 , p8_a2 VARCHAR2
256 , p8_a3 NUMBER
257 , p8_a4 NUMBER
258 , p8_a5 VARCHAR2
259 , p8_a6 NUMBER
260 , p8_a7 NUMBER
261 , p8_a8 NUMBER
262 , p8_a9 VARCHAR2
263 , p8_a10 DATE
264 , p8_a11 DATE
265 , p8_a12 NUMBER
266 , p8_a13 NUMBER
267 , p8_a14 NUMBER
268 , p8_a15 NUMBER
269 , p8_a16 NUMBER
270 , p8_a17 NUMBER
271 , p8_a18 VARCHAR2
272 , p8_a19 NUMBER
273 , p8_a20 NUMBER
274 , p8_a21 NUMBER
275 , p8_a22 NUMBER
276 , p8_a23 VARCHAR2
277 , p8_a24 NUMBER
278 , p8_a25 NUMBER
279 , p8_a26 NUMBER
280 , p8_a27 NUMBER
281 , p8_a28 NUMBER
282 , p8_a29 VARCHAR2
283 , p8_a30 VARCHAR2
284 , p8_a31 VARCHAR2
285 , p8_a32 VARCHAR2
286 , p8_a33 VARCHAR2
287 , p8_a34 VARCHAR2
288 , p8_a35 VARCHAR2
289 , p8_a36 VARCHAR2
290 , p8_a37 VARCHAR2
291 , p8_a38 VARCHAR2
292 , p8_a39 VARCHAR2
293 , p8_a40 VARCHAR2
294 , p8_a41 VARCHAR2
295 , p8_a42 VARCHAR2
296 , p8_a43 VARCHAR2
297 , p8_a44 VARCHAR2
298 , x_act_budget_id out nocopy NUMBER
299 , p_approval_flag VARCHAR2
300 )
301
302 as
303 ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
304 ddp_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
305 ddindx binary_integer; indx binary_integer;
306 begin
307
308 -- copy data to the local IN or IN-OUT args, if any
309
310
311
312
313
314
315
316 ddp_act_budgets_rec.activity_budget_id := p7_a0;
317 ddp_act_budgets_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
318 ddp_act_budgets_rec.last_updated_by := p7_a2;
319 ddp_act_budgets_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
320 ddp_act_budgets_rec.created_by := p7_a4;
321 ddp_act_budgets_rec.last_update_login := p7_a5;
322 ddp_act_budgets_rec.object_version_number := p7_a6;
323 ddp_act_budgets_rec.act_budget_used_by_id := p7_a7;
324 ddp_act_budgets_rec.arc_act_budget_used_by := p7_a8;
325 ddp_act_budgets_rec.budget_source_type := p7_a9;
326 ddp_act_budgets_rec.budget_source_id := p7_a10;
327 ddp_act_budgets_rec.transaction_type := p7_a11;
328 ddp_act_budgets_rec.request_amount := p7_a12;
329 ddp_act_budgets_rec.request_currency := p7_a13;
330 ddp_act_budgets_rec.request_date := rosetta_g_miss_date_in_map(p7_a14);
331 ddp_act_budgets_rec.user_status_id := p7_a15;
332 ddp_act_budgets_rec.status_code := p7_a16;
333 ddp_act_budgets_rec.approved_amount := p7_a17;
334 ddp_act_budgets_rec.approved_original_amount := p7_a18;
335 ddp_act_budgets_rec.approved_in_currency := p7_a19;
336 ddp_act_budgets_rec.approval_date := rosetta_g_miss_date_in_map(p7_a20);
337 ddp_act_budgets_rec.approver_id := p7_a21;
338 ddp_act_budgets_rec.spent_amount := p7_a22;
339 ddp_act_budgets_rec.partner_po_number := p7_a23;
340 ddp_act_budgets_rec.partner_po_date := rosetta_g_miss_date_in_map(p7_a24);
341 ddp_act_budgets_rec.partner_po_approver := p7_a25;
342 ddp_act_budgets_rec.adjusted_flag := p7_a26;
343 ddp_act_budgets_rec.posted_flag := p7_a27;
344 ddp_act_budgets_rec.justification := p7_a28;
345 ddp_act_budgets_rec.comment := p7_a29;
346 ddp_act_budgets_rec.parent_act_budget_id := p7_a30;
347 ddp_act_budgets_rec.contact_id := p7_a31;
348 ddp_act_budgets_rec.reason_code := p7_a32;
349 ddp_act_budgets_rec.transfer_type := p7_a33;
350 ddp_act_budgets_rec.requester_id := p7_a34;
354 ddp_act_budgets_rec.parent_src_apprvd_amt := p7_a38;
351 ddp_act_budgets_rec.date_required_by := rosetta_g_miss_date_in_map(p7_a35);
352 ddp_act_budgets_rec.parent_source_id := p7_a36;
353 ddp_act_budgets_rec.parent_src_curr := p7_a37;
355 ddp_act_budgets_rec.partner_holding_type := p7_a39;
356 ddp_act_budgets_rec.partner_address_id := p7_a40;
357 ddp_act_budgets_rec.vendor_id := p7_a41;
358 ddp_act_budgets_rec.owner_id := p7_a42;
359 ddp_act_budgets_rec.recal_flag := p7_a43;
360 ddp_act_budgets_rec.attribute_category := p7_a44;
361 ddp_act_budgets_rec.attribute1 := p7_a45;
362 ddp_act_budgets_rec.attribute2 := p7_a46;
363 ddp_act_budgets_rec.attribute3 := p7_a47;
364 ddp_act_budgets_rec.attribute4 := p7_a48;
365 ddp_act_budgets_rec.attribute5 := p7_a49;
366 ddp_act_budgets_rec.attribute6 := p7_a50;
367 ddp_act_budgets_rec.attribute7 := p7_a51;
368 ddp_act_budgets_rec.attribute8 := p7_a52;
369 ddp_act_budgets_rec.attribute9 := p7_a53;
370 ddp_act_budgets_rec.attribute10 := p7_a54;
371 ddp_act_budgets_rec.attribute11 := p7_a55;
372 ddp_act_budgets_rec.attribute12 := p7_a56;
373 ddp_act_budgets_rec.attribute13 := p7_a57;
374 ddp_act_budgets_rec.attribute14 := p7_a58;
375 ddp_act_budgets_rec.attribute15 := p7_a59;
376 ddp_act_budgets_rec.src_curr_req_amt := p7_a60;
377
378 ddp_act_util_rec.object_type := p8_a0;
379 ddp_act_util_rec.object_id := p8_a1;
380 ddp_act_util_rec.adjustment_type := p8_a2;
381 ddp_act_util_rec.camp_schedule_id := p8_a3;
382 ddp_act_util_rec.adjustment_type_id := p8_a4;
383 ddp_act_util_rec.product_level_type := p8_a5;
384 ddp_act_util_rec.product_id := p8_a6;
385 ddp_act_util_rec.cust_account_id := p8_a7;
386 ddp_act_util_rec.price_adjustment_id := p8_a8;
387 ddp_act_util_rec.utilization_type := p8_a9;
388 ddp_act_util_rec.adjustment_date := rosetta_g_miss_date_in_map(p8_a10);
389 ddp_act_util_rec.gl_date := rosetta_g_miss_date_in_map(p8_a11);
390 ddp_act_util_rec.scan_unit := p8_a12;
391 ddp_act_util_rec.scan_unit_remaining := p8_a13;
392 ddp_act_util_rec.activity_product_id := p8_a14;
393 ddp_act_util_rec.scan_type_id := p8_a15;
394 ddp_act_util_rec.volume_offer_tiers_id := p8_a16;
395 ddp_act_util_rec.billto_cust_account_id := p8_a17;
396 ddp_act_util_rec.reference_type := p8_a18;
397 ddp_act_util_rec.reference_id := p8_a19;
398 ddp_act_util_rec.order_line_id := p8_a20;
399 ddp_act_util_rec.org_id := p8_a21;
400 ddp_act_util_rec.orig_utilization_id := p8_a22;
401 ddp_act_util_rec.gl_posted_flag := p8_a23;
402 ddp_act_util_rec.bill_to_site_use_id := p8_a24;
403 ddp_act_util_rec.ship_to_site_use_id := p8_a25;
404 ddp_act_util_rec.gl_account_credit := p8_a26;
405 ddp_act_util_rec.gl_account_debit := p8_a27;
406 ddp_act_util_rec.site_use_id := p8_a28;
407 ddp_act_util_rec.attribute_category := p8_a29;
408 ddp_act_util_rec.attribute1 := p8_a30;
409 ddp_act_util_rec.attribute2 := p8_a31;
410 ddp_act_util_rec.attribute3 := p8_a32;
411 ddp_act_util_rec.attribute4 := p8_a33;
412 ddp_act_util_rec.attribute5 := p8_a34;
413 ddp_act_util_rec.attribute6 := p8_a35;
414 ddp_act_util_rec.attribute7 := p8_a36;
415 ddp_act_util_rec.attribute8 := p8_a37;
416 ddp_act_util_rec.attribute9 := p8_a38;
417 ddp_act_util_rec.attribute10 := p8_a39;
418 ddp_act_util_rec.attribute11 := p8_a40;
419 ddp_act_util_rec.attribute12 := p8_a41;
420 ddp_act_util_rec.attribute13 := p8_a42;
421 ddp_act_util_rec.attribute14 := p8_a43;
422 ddp_act_util_rec.attribute15 := p8_a44;
423
424
425
426 -- here's the delegated call to the old PL/SQL routine
427 ozf_actbudgets_pvt.create_act_budgets(p_api_version,
428 p_init_msg_list,
429 p_commit,
430 p_validation_level,
431 x_return_status,
432 x_msg_count,
433 x_msg_data,
434 ddp_act_budgets_rec,
435 ddp_act_util_rec,
436 x_act_budget_id,
437 p_approval_flag);
438
439 -- copy data back from the local variables to OUT or IN-OUT args, if any
440
441
442
443
444
445
446
447
448
449
450 end;
451
452 procedure create_act_budgets(p_api_version NUMBER
453 , p_init_msg_list VARCHAR2
454 , p_commit VARCHAR2
455 , p_validation_level NUMBER
456 , x_return_status out nocopy VARCHAR2
457 , x_msg_count out nocopy NUMBER
458 , x_msg_data out nocopy VARCHAR2
459 , p7_a0 NUMBER
460 , p7_a1 DATE
461 , p7_a2 NUMBER
462 , p7_a3 DATE
463 , p7_a4 NUMBER
464 , p7_a5 NUMBER
465 , p7_a6 NUMBER
466 , p7_a7 NUMBER
467 , p7_a8 VARCHAR2
468 , p7_a9 VARCHAR2
469 , p7_a10 NUMBER
470 , p7_a11 VARCHAR2
471 , p7_a12 NUMBER
472 , p7_a13 VARCHAR2
473 , p7_a14 DATE
474 , p7_a15 NUMBER
475 , p7_a16 VARCHAR2
476 , p7_a17 NUMBER
477 , p7_a18 NUMBER
478 , p7_a19 VARCHAR2
479 , p7_a20 DATE
480 , p7_a21 NUMBER
481 , p7_a22 NUMBER
482 , p7_a23 VARCHAR2
483 , p7_a24 DATE
484 , p7_a25 VARCHAR2
485 , p7_a26 VARCHAR2
486 , p7_a27 VARCHAR2
487 , p7_a28 VARCHAR
488 , p7_a29 VARCHAR
489 , p7_a30 NUMBER
490 , p7_a31 NUMBER
491 , p7_a32 VARCHAR2
492 , p7_a33 VARCHAR2
493 , p7_a34 NUMBER
494 , p7_a35 DATE
495 , p7_a36 NUMBER
496 , p7_a37 VARCHAR2
497 , p7_a38 NUMBER
498 , p7_a39 VARCHAR2
499 , p7_a40 NUMBER
500 , p7_a41 NUMBER
504 , p7_a45 VARCHAR2
501 , p7_a42 NUMBER
502 , p7_a43 VARCHAR2
503 , p7_a44 VARCHAR2
505 , p7_a46 VARCHAR2
506 , p7_a47 VARCHAR2
507 , p7_a48 VARCHAR2
508 , p7_a49 VARCHAR2
509 , p7_a50 VARCHAR2
510 , p7_a51 VARCHAR2
511 , p7_a52 VARCHAR2
512 , p7_a53 VARCHAR2
513 , p7_a54 VARCHAR2
514 , p7_a55 VARCHAR2
515 , p7_a56 VARCHAR2
516 , p7_a57 VARCHAR2
517 , p7_a58 VARCHAR2
518 , p7_a59 VARCHAR2
519 , p7_a60 NUMBER
520 , p8_a0 VARCHAR2
521 , p8_a1 NUMBER
522 , p8_a2 VARCHAR2
523 , p8_a3 NUMBER
524 , p8_a4 NUMBER
525 , p8_a5 VARCHAR2
526 , p8_a6 NUMBER
527 , p8_a7 NUMBER
528 , p8_a8 NUMBER
529 , p8_a9 VARCHAR2
530 , p8_a10 DATE
531 , p8_a11 DATE
532 , p8_a12 NUMBER
533 , p8_a13 NUMBER
534 , p8_a14 NUMBER
535 , p8_a15 NUMBER
536 , p8_a16 NUMBER
537 , p8_a17 NUMBER
538 , p8_a18 VARCHAR2
539 , p8_a19 NUMBER
540 , p8_a20 NUMBER
541 , p8_a21 NUMBER
542 , p8_a22 NUMBER
543 , p8_a23 VARCHAR2
544 , p8_a24 NUMBER
545 , p8_a25 NUMBER
546 , p8_a26 NUMBER
547 , p8_a27 NUMBER
548 , p8_a28 NUMBER
549 , p8_a29 VARCHAR2
550 , p8_a30 VARCHAR2
551 , p8_a31 VARCHAR2
552 , p8_a32 VARCHAR2
553 , p8_a33 VARCHAR2
554 , p8_a34 VARCHAR2
555 , p8_a35 VARCHAR2
556 , p8_a36 VARCHAR2
557 , p8_a37 VARCHAR2
558 , p8_a38 VARCHAR2
559 , p8_a39 VARCHAR2
560 , p8_a40 VARCHAR2
561 , p8_a41 VARCHAR2
562 , p8_a42 VARCHAR2
563 , p8_a43 VARCHAR2
564 , p8_a44 VARCHAR2
565 , x_act_budget_id out nocopy NUMBER
566 , p_approval_flag VARCHAR2
567 , x_utilized_amount out nocopy NUMBER
568 )
569
570 as
571 ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
572 ddp_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
573 ddindx binary_integer; indx binary_integer;
574 begin
575
576 -- copy data to the local IN or IN-OUT args, if any
577
578
579
580
581
582
583
584 ddp_act_budgets_rec.activity_budget_id := p7_a0;
585 ddp_act_budgets_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
586 ddp_act_budgets_rec.last_updated_by := p7_a2;
587 ddp_act_budgets_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
588 ddp_act_budgets_rec.created_by := p7_a4;
589 ddp_act_budgets_rec.last_update_login := p7_a5;
590 ddp_act_budgets_rec.object_version_number := p7_a6;
591 ddp_act_budgets_rec.act_budget_used_by_id := p7_a7;
592 ddp_act_budgets_rec.arc_act_budget_used_by := p7_a8;
593 ddp_act_budgets_rec.budget_source_type := p7_a9;
594 ddp_act_budgets_rec.budget_source_id := p7_a10;
595 ddp_act_budgets_rec.transaction_type := p7_a11;
596 ddp_act_budgets_rec.request_amount := p7_a12;
597 ddp_act_budgets_rec.request_currency := p7_a13;
598 ddp_act_budgets_rec.request_date := rosetta_g_miss_date_in_map(p7_a14);
599 ddp_act_budgets_rec.user_status_id := p7_a15;
600 ddp_act_budgets_rec.status_code := p7_a16;
601 ddp_act_budgets_rec.approved_amount := p7_a17;
602 ddp_act_budgets_rec.approved_original_amount := p7_a18;
603 ddp_act_budgets_rec.approved_in_currency := p7_a19;
604 ddp_act_budgets_rec.approval_date := rosetta_g_miss_date_in_map(p7_a20);
605 ddp_act_budgets_rec.approver_id := p7_a21;
606 ddp_act_budgets_rec.spent_amount := p7_a22;
607 ddp_act_budgets_rec.partner_po_number := p7_a23;
608 ddp_act_budgets_rec.partner_po_date := rosetta_g_miss_date_in_map(p7_a24);
609 ddp_act_budgets_rec.partner_po_approver := p7_a25;
610 ddp_act_budgets_rec.adjusted_flag := p7_a26;
611 ddp_act_budgets_rec.posted_flag := p7_a27;
612 ddp_act_budgets_rec.justification := p7_a28;
613 ddp_act_budgets_rec.comment := p7_a29;
614 ddp_act_budgets_rec.parent_act_budget_id := p7_a30;
615 ddp_act_budgets_rec.contact_id := p7_a31;
616 ddp_act_budgets_rec.reason_code := p7_a32;
617 ddp_act_budgets_rec.transfer_type := p7_a33;
618 ddp_act_budgets_rec.requester_id := p7_a34;
619 ddp_act_budgets_rec.date_required_by := rosetta_g_miss_date_in_map(p7_a35);
620 ddp_act_budgets_rec.parent_source_id := p7_a36;
621 ddp_act_budgets_rec.parent_src_curr := p7_a37;
622 ddp_act_budgets_rec.parent_src_apprvd_amt := p7_a38;
623 ddp_act_budgets_rec.partner_holding_type := p7_a39;
624 ddp_act_budgets_rec.partner_address_id := p7_a40;
625 ddp_act_budgets_rec.vendor_id := p7_a41;
626 ddp_act_budgets_rec.owner_id := p7_a42;
627 ddp_act_budgets_rec.recal_flag := p7_a43;
628 ddp_act_budgets_rec.attribute_category := p7_a44;
629 ddp_act_budgets_rec.attribute1 := p7_a45;
630 ddp_act_budgets_rec.attribute2 := p7_a46;
631 ddp_act_budgets_rec.attribute3 := p7_a47;
632 ddp_act_budgets_rec.attribute4 := p7_a48;
633 ddp_act_budgets_rec.attribute5 := p7_a49;
634 ddp_act_budgets_rec.attribute6 := p7_a50;
635 ddp_act_budgets_rec.attribute7 := p7_a51;
636 ddp_act_budgets_rec.attribute8 := p7_a52;
637 ddp_act_budgets_rec.attribute9 := p7_a53;
638 ddp_act_budgets_rec.attribute10 := p7_a54;
639 ddp_act_budgets_rec.attribute11 := p7_a55;
640 ddp_act_budgets_rec.attribute12 := p7_a56;
641 ddp_act_budgets_rec.attribute13 := p7_a57;
642 ddp_act_budgets_rec.attribute14 := p7_a58;
643 ddp_act_budgets_rec.attribute15 := p7_a59;
644 ddp_act_budgets_rec.src_curr_req_amt := p7_a60;
645
646 ddp_act_util_rec.object_type := p8_a0;
647 ddp_act_util_rec.object_id := p8_a1;
651 ddp_act_util_rec.product_level_type := p8_a5;
648 ddp_act_util_rec.adjustment_type := p8_a2;
649 ddp_act_util_rec.camp_schedule_id := p8_a3;
650 ddp_act_util_rec.adjustment_type_id := p8_a4;
652 ddp_act_util_rec.product_id := p8_a6;
653 ddp_act_util_rec.cust_account_id := p8_a7;
654 ddp_act_util_rec.price_adjustment_id := p8_a8;
655 ddp_act_util_rec.utilization_type := p8_a9;
656 ddp_act_util_rec.adjustment_date := rosetta_g_miss_date_in_map(p8_a10);
657 ddp_act_util_rec.gl_date := rosetta_g_miss_date_in_map(p8_a11);
658 ddp_act_util_rec.scan_unit := p8_a12;
659 ddp_act_util_rec.scan_unit_remaining := p8_a13;
660 ddp_act_util_rec.activity_product_id := p8_a14;
661 ddp_act_util_rec.scan_type_id := p8_a15;
662 ddp_act_util_rec.volume_offer_tiers_id := p8_a16;
663 ddp_act_util_rec.billto_cust_account_id := p8_a17;
664 ddp_act_util_rec.reference_type := p8_a18;
665 ddp_act_util_rec.reference_id := p8_a19;
666 ddp_act_util_rec.order_line_id := p8_a20;
667 ddp_act_util_rec.org_id := p8_a21;
668 ddp_act_util_rec.orig_utilization_id := p8_a22;
669 ddp_act_util_rec.gl_posted_flag := p8_a23;
670 ddp_act_util_rec.bill_to_site_use_id := p8_a24;
671 ddp_act_util_rec.ship_to_site_use_id := p8_a25;
672 ddp_act_util_rec.gl_account_credit := p8_a26;
673 ddp_act_util_rec.gl_account_debit := p8_a27;
674 ddp_act_util_rec.site_use_id := p8_a28;
675 ddp_act_util_rec.attribute_category := p8_a29;
676 ddp_act_util_rec.attribute1 := p8_a30;
677 ddp_act_util_rec.attribute2 := p8_a31;
678 ddp_act_util_rec.attribute3 := p8_a32;
679 ddp_act_util_rec.attribute4 := p8_a33;
680 ddp_act_util_rec.attribute5 := p8_a34;
681 ddp_act_util_rec.attribute6 := p8_a35;
682 ddp_act_util_rec.attribute7 := p8_a36;
683 ddp_act_util_rec.attribute8 := p8_a37;
684 ddp_act_util_rec.attribute9 := p8_a38;
685 ddp_act_util_rec.attribute10 := p8_a39;
686 ddp_act_util_rec.attribute11 := p8_a40;
687 ddp_act_util_rec.attribute12 := p8_a41;
688 ddp_act_util_rec.attribute13 := p8_a42;
689 ddp_act_util_rec.attribute14 := p8_a43;
690 ddp_act_util_rec.attribute15 := p8_a44;
691
692
693
694
695 -- here's the delegated call to the old PL/SQL routine
696 ozf_actbudgets_pvt.create_act_budgets(p_api_version,
697 p_init_msg_list,
698 p_commit,
699 p_validation_level,
700 x_return_status,
701 x_msg_count,
702 x_msg_data,
703 ddp_act_budgets_rec,
704 ddp_act_util_rec,
705 x_act_budget_id,
706 p_approval_flag,
707 x_utilized_amount);
708
712
709 -- copy data back from the local variables to OUT or IN-OUT args, if any
710
711
713
714
715
716
717
718
719
720
721 end;
722
723 procedure update_act_budgets(p_api_version NUMBER
724 , p_init_msg_list VARCHAR2
725 , p_commit VARCHAR2
726 , p_validation_level NUMBER
727 , x_return_status out nocopy VARCHAR2
728 , x_msg_count out nocopy NUMBER
729 , x_msg_data out nocopy VARCHAR2
730 , p7_a0 NUMBER
731 , p7_a1 DATE
732 , p7_a2 NUMBER
733 , p7_a3 DATE
734 , p7_a4 NUMBER
735 , p7_a5 NUMBER
736 , p7_a6 NUMBER
737 , p7_a7 NUMBER
738 , p7_a8 VARCHAR2
739 , p7_a9 VARCHAR2
740 , p7_a10 NUMBER
741 , p7_a11 VARCHAR2
742 , p7_a12 NUMBER
743 , p7_a13 VARCHAR2
744 , p7_a14 DATE
745 , p7_a15 NUMBER
746 , p7_a16 VARCHAR2
747 , p7_a17 NUMBER
748 , p7_a18 NUMBER
749 , p7_a19 VARCHAR2
750 , p7_a20 DATE
751 , p7_a21 NUMBER
752 , p7_a22 NUMBER
753 , p7_a23 VARCHAR2
754 , p7_a24 DATE
755 , p7_a25 VARCHAR2
756 , p7_a26 VARCHAR2
757 , p7_a27 VARCHAR2
758 , p7_a28 VARCHAR
759 , p7_a29 VARCHAR
760 , p7_a30 NUMBER
761 , p7_a31 NUMBER
762 , p7_a32 VARCHAR2
763 , p7_a33 VARCHAR2
764 , p7_a34 NUMBER
765 , p7_a35 DATE
766 , p7_a36 NUMBER
767 , p7_a37 VARCHAR2
768 , p7_a38 NUMBER
769 , p7_a39 VARCHAR2
770 , p7_a40 NUMBER
771 , p7_a41 NUMBER
772 , p7_a42 NUMBER
773 , p7_a43 VARCHAR2
774 , p7_a44 VARCHAR2
775 , p7_a45 VARCHAR2
776 , p7_a46 VARCHAR2
777 , p7_a47 VARCHAR2
778 , p7_a48 VARCHAR2
779 , p7_a49 VARCHAR2
780 , p7_a50 VARCHAR2
781 , p7_a51 VARCHAR2
782 , p7_a52 VARCHAR2
783 , p7_a53 VARCHAR2
784 , p7_a54 VARCHAR2
788 , p7_a58 VARCHAR2
785 , p7_a55 VARCHAR2
786 , p7_a56 VARCHAR2
787 , p7_a57 VARCHAR2
789 , p7_a59 VARCHAR2
790 , p7_a60 NUMBER
791 )
792
793 as
794 ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
795 ddindx binary_integer; indx binary_integer;
796 begin
797
798 -- copy data to the local IN or IN-OUT args, if any
799
800
801
802
803
804
805
806 ddp_act_budgets_rec.activity_budget_id := p7_a0;
807 ddp_act_budgets_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
808 ddp_act_budgets_rec.last_updated_by := p7_a2;
809 ddp_act_budgets_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
810 ddp_act_budgets_rec.created_by := p7_a4;
811 ddp_act_budgets_rec.last_update_login := p7_a5;
812 ddp_act_budgets_rec.object_version_number := p7_a6;
813 ddp_act_budgets_rec.act_budget_used_by_id := p7_a7;
814 ddp_act_budgets_rec.arc_act_budget_used_by := p7_a8;
815 ddp_act_budgets_rec.budget_source_type := p7_a9;
816 ddp_act_budgets_rec.budget_source_id := p7_a10;
817 ddp_act_budgets_rec.transaction_type := p7_a11;
818 ddp_act_budgets_rec.request_amount := p7_a12;
819 ddp_act_budgets_rec.request_currency := p7_a13;
820 ddp_act_budgets_rec.request_date := rosetta_g_miss_date_in_map(p7_a14);
821 ddp_act_budgets_rec.user_status_id := p7_a15;
822 ddp_act_budgets_rec.status_code := p7_a16;
823 ddp_act_budgets_rec.approved_amount := p7_a17;
824 ddp_act_budgets_rec.approved_original_amount := p7_a18;
825 ddp_act_budgets_rec.approved_in_currency := p7_a19;
826 ddp_act_budgets_rec.approval_date := rosetta_g_miss_date_in_map(p7_a20);
827 ddp_act_budgets_rec.approver_id := p7_a21;
828 ddp_act_budgets_rec.spent_amount := p7_a22;
829 ddp_act_budgets_rec.partner_po_number := p7_a23;
830 ddp_act_budgets_rec.partner_po_date := rosetta_g_miss_date_in_map(p7_a24);
831 ddp_act_budgets_rec.partner_po_approver := p7_a25;
832 ddp_act_budgets_rec.adjusted_flag := p7_a26;
833 ddp_act_budgets_rec.posted_flag := p7_a27;
834 ddp_act_budgets_rec.justification := p7_a28;
835 ddp_act_budgets_rec.comment := p7_a29;
836 ddp_act_budgets_rec.parent_act_budget_id := p7_a30;
837 ddp_act_budgets_rec.contact_id := p7_a31;
838 ddp_act_budgets_rec.reason_code := p7_a32;
839 ddp_act_budgets_rec.transfer_type := p7_a33;
840 ddp_act_budgets_rec.requester_id := p7_a34;
841 ddp_act_budgets_rec.date_required_by := rosetta_g_miss_date_in_map(p7_a35);
842 ddp_act_budgets_rec.parent_source_id := p7_a36;
843 ddp_act_budgets_rec.parent_src_curr := p7_a37;
844 ddp_act_budgets_rec.parent_src_apprvd_amt := p7_a38;
845 ddp_act_budgets_rec.partner_holding_type := p7_a39;
846 ddp_act_budgets_rec.partner_address_id := p7_a40;
847 ddp_act_budgets_rec.vendor_id := p7_a41;
848 ddp_act_budgets_rec.owner_id := p7_a42;
849 ddp_act_budgets_rec.recal_flag := p7_a43;
850 ddp_act_budgets_rec.attribute_category := p7_a44;
851 ddp_act_budgets_rec.attribute1 := p7_a45;
852 ddp_act_budgets_rec.attribute2 := p7_a46;
853 ddp_act_budgets_rec.attribute3 := p7_a47;
854 ddp_act_budgets_rec.attribute4 := p7_a48;
855 ddp_act_budgets_rec.attribute5 := p7_a49;
856 ddp_act_budgets_rec.attribute6 := p7_a50;
857 ddp_act_budgets_rec.attribute7 := p7_a51;
858 ddp_act_budgets_rec.attribute8 := p7_a52;
859 ddp_act_budgets_rec.attribute9 := p7_a53;
860 ddp_act_budgets_rec.attribute10 := p7_a54;
861 ddp_act_budgets_rec.attribute11 := p7_a55;
862 ddp_act_budgets_rec.attribute12 := p7_a56;
863 ddp_act_budgets_rec.attribute13 := p7_a57;
864 ddp_act_budgets_rec.attribute14 := p7_a58;
865 ddp_act_budgets_rec.attribute15 := p7_a59;
866 ddp_act_budgets_rec.src_curr_req_amt := p7_a60;
867
868 -- here's the delegated call to the old PL/SQL routine
869 ozf_actbudgets_pvt.update_act_budgets(p_api_version,
870 p_init_msg_list,
871 p_commit,
872 p_validation_level,
873 x_return_status,
874 x_msg_count,
875 x_msg_data,
876 ddp_act_budgets_rec);
877
878 -- copy data back from the local variables to OUT or IN-OUT args, if any
879
880
881
882
883
884
885
886 end;
887
888 procedure update_act_budgets(p_api_version NUMBER
889 , p_init_msg_list VARCHAR2
890 , p_commit VARCHAR2
891 , p_validation_level NUMBER
892 , x_return_status out nocopy VARCHAR2
893 , x_msg_count out nocopy NUMBER
894 , x_msg_data out nocopy VARCHAR2
895 , p7_a0 NUMBER
896 , p7_a1 DATE
897 , p7_a2 NUMBER
898 , p7_a3 DATE
899 , p7_a4 NUMBER
900 , p7_a5 NUMBER
901 , p7_a6 NUMBER
902 , p7_a7 NUMBER
903 , p7_a8 VARCHAR2
904 , p7_a9 VARCHAR2
905 , p7_a10 NUMBER
906 , p7_a11 VARCHAR2
907 , p7_a12 NUMBER
908 , p7_a13 VARCHAR2
909 , p7_a14 DATE
910 , p7_a15 NUMBER
911 , p7_a16 VARCHAR2
912 , p7_a17 NUMBER
913 , p7_a18 NUMBER
914 , p7_a19 VARCHAR2
915 , p7_a20 DATE
916 , p7_a21 NUMBER
917 , p7_a22 NUMBER
918 , p7_a23 VARCHAR2
919 , p7_a24 DATE
920 , p7_a25 VARCHAR2
921 , p7_a26 VARCHAR2
922 , p7_a27 VARCHAR2
923 , p7_a28 VARCHAR
924 , p7_a29 VARCHAR
925 , p7_a30 NUMBER
926 , p7_a31 NUMBER
927 , p7_a32 VARCHAR2
928 , p7_a33 VARCHAR2
929 , p7_a34 NUMBER
930 , p7_a35 DATE
931 , p7_a36 NUMBER
932 , p7_a37 VARCHAR2
933 , p7_a38 NUMBER
934 , p7_a39 VARCHAR2
935 , p7_a40 NUMBER
939 , p7_a44 VARCHAR2
936 , p7_a41 NUMBER
937 , p7_a42 NUMBER
938 , p7_a43 VARCHAR2
940 , p7_a45 VARCHAR2
941 , p7_a46 VARCHAR2
942 , p7_a47 VARCHAR2
943 , p7_a48 VARCHAR2
944 , p7_a49 VARCHAR2
945 , p7_a50 VARCHAR2
946 , p7_a51 VARCHAR2
947 , p7_a52 VARCHAR2
948 , p7_a53 VARCHAR2
949 , p7_a54 VARCHAR2
950 , p7_a55 VARCHAR2
951 , p7_a56 VARCHAR2
952 , p7_a57 VARCHAR2
953 , p7_a58 VARCHAR2
954 , p7_a59 VARCHAR2
955 , p7_a60 NUMBER
956 , p_parent_process_flag VARCHAR2
957 , p_parent_process_key VARCHAR2
958 , p_parent_context VARCHAR2
959 , p_parent_approval_flag VARCHAR2
960 , p_continue_flow VARCHAR2
961 , p_child_approval_flag VARCHAR2
962 , p_requestor_owner_flag VARCHAR2
963 , p15_a0 VARCHAR2
964 , p15_a1 NUMBER
965 , p15_a2 VARCHAR2
966 , p15_a3 NUMBER
967 , p15_a4 NUMBER
968 , p15_a5 VARCHAR2
969 , p15_a6 NUMBER
970 , p15_a7 NUMBER
971 , p15_a8 NUMBER
972 , p15_a9 VARCHAR2
973 , p15_a10 DATE
974 , p15_a11 DATE
975 , p15_a12 NUMBER
976 , p15_a13 NUMBER
977 , p15_a14 NUMBER
978 , p15_a15 NUMBER
979 , p15_a16 NUMBER
980 , p15_a17 NUMBER
981 , p15_a18 VARCHAR2
982 , p15_a19 NUMBER
983 , p15_a20 NUMBER
984 , p15_a21 NUMBER
985 , p15_a22 NUMBER
986 , p15_a23 VARCHAR2
987 , p15_a24 NUMBER
988 , p15_a25 NUMBER
989 , p15_a26 NUMBER
990 , p15_a27 NUMBER
991 , p15_a28 NUMBER
992 , p15_a29 VARCHAR2
993 , p15_a30 VARCHAR2
994 , p15_a31 VARCHAR2
995 , p15_a32 VARCHAR2
996 , p15_a33 VARCHAR2
997 , p15_a34 VARCHAR2
998 , p15_a35 VARCHAR2
999 , p15_a36 VARCHAR2
1000 , p15_a37 VARCHAR2
1001 , p15_a38 VARCHAR2
1002 , p15_a39 VARCHAR2
1003 , p15_a40 VARCHAR2
1004 , p15_a41 VARCHAR2
1005 , p15_a42 VARCHAR2
1006 , p15_a43 VARCHAR2
1007 , p15_a44 VARCHAR2
1008 )
1009
1010 as
1011 ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1012 ddp_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
1013 ddindx binary_integer; indx binary_integer;
1014 begin
1015
1016 -- copy data to the local IN or IN-OUT args, if any
1017
1018
1019
1020
1021
1022
1023
1024 ddp_act_budgets_rec.activity_budget_id := p7_a0;
1025 ddp_act_budgets_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
1026 ddp_act_budgets_rec.last_updated_by := p7_a2;
1027 ddp_act_budgets_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
1028 ddp_act_budgets_rec.created_by := p7_a4;
1029 ddp_act_budgets_rec.last_update_login := p7_a5;
1030 ddp_act_budgets_rec.object_version_number := p7_a6;
1031 ddp_act_budgets_rec.act_budget_used_by_id := p7_a7;
1032 ddp_act_budgets_rec.arc_act_budget_used_by := p7_a8;
1033 ddp_act_budgets_rec.budget_source_type := p7_a9;
1034 ddp_act_budgets_rec.budget_source_id := p7_a10;
1035 ddp_act_budgets_rec.transaction_type := p7_a11;
1036 ddp_act_budgets_rec.request_amount := p7_a12;
1037 ddp_act_budgets_rec.request_currency := p7_a13;
1038 ddp_act_budgets_rec.request_date := rosetta_g_miss_date_in_map(p7_a14);
1039 ddp_act_budgets_rec.user_status_id := p7_a15;
1040 ddp_act_budgets_rec.status_code := p7_a16;
1041 ddp_act_budgets_rec.approved_amount := p7_a17;
1042 ddp_act_budgets_rec.approved_original_amount := p7_a18;
1043 ddp_act_budgets_rec.approved_in_currency := p7_a19;
1044 ddp_act_budgets_rec.approval_date := rosetta_g_miss_date_in_map(p7_a20);
1045 ddp_act_budgets_rec.approver_id := p7_a21;
1046 ddp_act_budgets_rec.spent_amount := p7_a22;
1047 ddp_act_budgets_rec.partner_po_number := p7_a23;
1048 ddp_act_budgets_rec.partner_po_date := rosetta_g_miss_date_in_map(p7_a24);
1049 ddp_act_budgets_rec.partner_po_approver := p7_a25;
1050 ddp_act_budgets_rec.adjusted_flag := p7_a26;
1051 ddp_act_budgets_rec.posted_flag := p7_a27;
1052 ddp_act_budgets_rec.justification := p7_a28;
1053 ddp_act_budgets_rec.comment := p7_a29;
1054 ddp_act_budgets_rec.parent_act_budget_id := p7_a30;
1055 ddp_act_budgets_rec.contact_id := p7_a31;
1056 ddp_act_budgets_rec.reason_code := p7_a32;
1057 ddp_act_budgets_rec.transfer_type := p7_a33;
1058 ddp_act_budgets_rec.requester_id := p7_a34;
1059 ddp_act_budgets_rec.date_required_by := rosetta_g_miss_date_in_map(p7_a35);
1060 ddp_act_budgets_rec.parent_source_id := p7_a36;
1061 ddp_act_budgets_rec.parent_src_curr := p7_a37;
1062 ddp_act_budgets_rec.parent_src_apprvd_amt := p7_a38;
1063 ddp_act_budgets_rec.partner_holding_type := p7_a39;
1064 ddp_act_budgets_rec.partner_address_id := p7_a40;
1065 ddp_act_budgets_rec.vendor_id := p7_a41;
1066 ddp_act_budgets_rec.owner_id := p7_a42;
1067 ddp_act_budgets_rec.recal_flag := p7_a43;
1068 ddp_act_budgets_rec.attribute_category := p7_a44;
1069 ddp_act_budgets_rec.attribute1 := p7_a45;
1070 ddp_act_budgets_rec.attribute2 := p7_a46;
1071 ddp_act_budgets_rec.attribute3 := p7_a47;
1072 ddp_act_budgets_rec.attribute4 := p7_a48;
1073 ddp_act_budgets_rec.attribute5 := p7_a49;
1074 ddp_act_budgets_rec.attribute6 := p7_a50;
1075 ddp_act_budgets_rec.attribute7 := p7_a51;
1076 ddp_act_budgets_rec.attribute8 := p7_a52;
1077 ddp_act_budgets_rec.attribute9 := p7_a53;
1078 ddp_act_budgets_rec.attribute10 := p7_a54;
1082 ddp_act_budgets_rec.attribute14 := p7_a58;
1079 ddp_act_budgets_rec.attribute11 := p7_a55;
1080 ddp_act_budgets_rec.attribute12 := p7_a56;
1081 ddp_act_budgets_rec.attribute13 := p7_a57;
1083 ddp_act_budgets_rec.attribute15 := p7_a59;
1084 ddp_act_budgets_rec.src_curr_req_amt := p7_a60;
1085
1086
1087
1088
1089
1090
1091
1092
1093 ddp_act_util_rec.object_type := p15_a0;
1094 ddp_act_util_rec.object_id := p15_a1;
1095 ddp_act_util_rec.adjustment_type := p15_a2;
1096 ddp_act_util_rec.camp_schedule_id := p15_a3;
1097 ddp_act_util_rec.adjustment_type_id := p15_a4;
1098 ddp_act_util_rec.product_level_type := p15_a5;
1099 ddp_act_util_rec.product_id := p15_a6;
1100 ddp_act_util_rec.cust_account_id := p15_a7;
1101 ddp_act_util_rec.price_adjustment_id := p15_a8;
1102 ddp_act_util_rec.utilization_type := p15_a9;
1103 ddp_act_util_rec.adjustment_date := rosetta_g_miss_date_in_map(p15_a10);
1104 ddp_act_util_rec.gl_date := rosetta_g_miss_date_in_map(p15_a11);
1105 ddp_act_util_rec.scan_unit := p15_a12;
1106 ddp_act_util_rec.scan_unit_remaining := p15_a13;
1107 ddp_act_util_rec.activity_product_id := p15_a14;
1108 ddp_act_util_rec.scan_type_id := p15_a15;
1109 ddp_act_util_rec.volume_offer_tiers_id := p15_a16;
1110 ddp_act_util_rec.billto_cust_account_id := p15_a17;
1111 ddp_act_util_rec.reference_type := p15_a18;
1112 ddp_act_util_rec.reference_id := p15_a19;
1113 ddp_act_util_rec.order_line_id := p15_a20;
1114 ddp_act_util_rec.org_id := p15_a21;
1115 ddp_act_util_rec.orig_utilization_id := p15_a22;
1116 ddp_act_util_rec.gl_posted_flag := p15_a23;
1117 ddp_act_util_rec.bill_to_site_use_id := p15_a24;
1118 ddp_act_util_rec.ship_to_site_use_id := p15_a25;
1119 ddp_act_util_rec.gl_account_credit := p15_a26;
1120 ddp_act_util_rec.gl_account_debit := p15_a27;
1121 ddp_act_util_rec.site_use_id := p15_a28;
1122 ddp_act_util_rec.attribute_category := p15_a29;
1123 ddp_act_util_rec.attribute1 := p15_a30;
1124 ddp_act_util_rec.attribute2 := p15_a31;
1125 ddp_act_util_rec.attribute3 := p15_a32;
1126 ddp_act_util_rec.attribute4 := p15_a33;
1127 ddp_act_util_rec.attribute5 := p15_a34;
1128 ddp_act_util_rec.attribute6 := p15_a35;
1129 ddp_act_util_rec.attribute7 := p15_a36;
1130 ddp_act_util_rec.attribute8 := p15_a37;
1131 ddp_act_util_rec.attribute9 := p15_a38;
1132 ddp_act_util_rec.attribute10 := p15_a39;
1133 ddp_act_util_rec.attribute11 := p15_a40;
1134 ddp_act_util_rec.attribute12 := p15_a41;
1135 ddp_act_util_rec.attribute13 := p15_a42;
1136 ddp_act_util_rec.attribute14 := p15_a43;
1137 ddp_act_util_rec.attribute15 := p15_a44;
1138
1139 -- here's the delegated call to the old PL/SQL routine
1140 ozf_actbudgets_pvt.update_act_budgets(p_api_version,
1141 p_init_msg_list,
1142 p_commit,
1143 p_validation_level,
1144 x_return_status,
1145 x_msg_count,
1146 x_msg_data,
1147 ddp_act_budgets_rec,
1148 p_parent_process_flag,
1149 p_parent_process_key,
1150 p_parent_context,
1151 p_parent_approval_flag,
1152 p_continue_flow,
1153 p_child_approval_flag,
1154 p_requestor_owner_flag,
1155 ddp_act_util_rec);
1156
1157 -- copy data back from the local variables to OUT or IN-OUT args, if any
1158
1159
1160
1161
1162
1163
1164
1165
1166
1167
1168
1169
1170
1171
1172
1173 end;
1174
1175 procedure update_act_budgets(p_api_version NUMBER
1176 , p_init_msg_list VARCHAR2
1177 , p_commit VARCHAR2
1178 , p_validation_level NUMBER
1179 , x_return_status out nocopy VARCHAR2
1180 , x_msg_count out nocopy NUMBER
1181 , x_msg_data out nocopy VARCHAR2
1182 , p7_a0 NUMBER
1183 , p7_a1 DATE
1184 , p7_a2 NUMBER
1185 , p7_a3 DATE
1186 , p7_a4 NUMBER
1187 , p7_a5 NUMBER
1188 , p7_a6 NUMBER
1189 , p7_a7 NUMBER
1190 , p7_a8 VARCHAR2
1191 , p7_a9 VARCHAR2
1192 , p7_a10 NUMBER
1193 , p7_a11 VARCHAR2
1194 , p7_a12 NUMBER
1195 , p7_a13 VARCHAR2
1196 , p7_a14 DATE
1197 , p7_a15 NUMBER
1198 , p7_a16 VARCHAR2
1199 , p7_a17 NUMBER
1200 , p7_a18 NUMBER
1201 , p7_a19 VARCHAR2
1202 , p7_a20 DATE
1203 , p7_a21 NUMBER
1204 , p7_a22 NUMBER
1205 , p7_a23 VARCHAR2
1206 , p7_a24 DATE
1207 , p7_a25 VARCHAR2
1208 , p7_a26 VARCHAR2
1209 , p7_a27 VARCHAR2
1210 , p7_a28 VARCHAR
1211 , p7_a29 VARCHAR
1212 , p7_a30 NUMBER
1213 , p7_a31 NUMBER
1214 , p7_a32 VARCHAR2
1215 , p7_a33 VARCHAR2
1216 , p7_a34 NUMBER
1217 , p7_a35 DATE
1218 , p7_a36 NUMBER
1219 , p7_a37 VARCHAR2
1220 , p7_a38 NUMBER
1224 , p7_a42 NUMBER
1221 , p7_a39 VARCHAR2
1222 , p7_a40 NUMBER
1223 , p7_a41 NUMBER
1225 , p7_a43 VARCHAR2
1226 , p7_a44 VARCHAR2
1227 , p7_a45 VARCHAR2
1228 , p7_a46 VARCHAR2
1229 , p7_a47 VARCHAR2
1230 , p7_a48 VARCHAR2
1231 , p7_a49 VARCHAR2
1232 , p7_a50 VARCHAR2
1233 , p7_a51 VARCHAR2
1234 , p7_a52 VARCHAR2
1235 , p7_a53 VARCHAR2
1236 , p7_a54 VARCHAR2
1237 , p7_a55 VARCHAR2
1238 , p7_a56 VARCHAR2
1239 , p7_a57 VARCHAR2
1240 , p7_a58 VARCHAR2
1241 , p7_a59 VARCHAR2
1242 , p7_a60 NUMBER
1243 , p_parent_process_flag VARCHAR2
1244 , p_parent_process_key VARCHAR2
1245 , p_parent_context VARCHAR2
1246 , p_parent_approval_flag VARCHAR2
1247 , p_continue_flow VARCHAR2
1248 , p_child_approval_flag VARCHAR2
1249 , p_requestor_owner_flag VARCHAR2
1250 , p15_a0 VARCHAR2
1251 , p15_a1 NUMBER
1252 , p15_a2 VARCHAR2
1253 , p15_a3 NUMBER
1254 , p15_a4 NUMBER
1255 , p15_a5 VARCHAR2
1256 , p15_a6 NUMBER
1257 , p15_a7 NUMBER
1258 , p15_a8 NUMBER
1259 , p15_a9 VARCHAR2
1260 , p15_a10 DATE
1261 , p15_a11 DATE
1262 , p15_a12 NUMBER
1263 , p15_a13 NUMBER
1264 , p15_a14 NUMBER
1265 , p15_a15 NUMBER
1266 , p15_a16 NUMBER
1267 , p15_a17 NUMBER
1268 , p15_a18 VARCHAR2
1269 , p15_a19 NUMBER
1270 , p15_a20 NUMBER
1271 , p15_a21 NUMBER
1272 , p15_a22 NUMBER
1273 , p15_a23 VARCHAR2
1274 , p15_a24 NUMBER
1275 , p15_a25 NUMBER
1276 , p15_a26 NUMBER
1277 , p15_a27 NUMBER
1278 , p15_a28 NUMBER
1279 , p15_a29 VARCHAR2
1280 , p15_a30 VARCHAR2
1281 , p15_a31 VARCHAR2
1282 , p15_a32 VARCHAR2
1283 , p15_a33 VARCHAR2
1284 , p15_a34 VARCHAR2
1285 , p15_a35 VARCHAR2
1286 , p15_a36 VARCHAR2
1287 , p15_a37 VARCHAR2
1288 , p15_a38 VARCHAR2
1289 , p15_a39 VARCHAR2
1290 , p15_a40 VARCHAR2
1291 , p15_a41 VARCHAR2
1292 , p15_a42 VARCHAR2
1293 , p15_a43 VARCHAR2
1294 , p15_a44 VARCHAR2
1295 , x_utilized_amount out nocopy NUMBER
1296 )
1297
1298 as
1299 ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1300 ddp_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
1301 ddindx binary_integer; indx binary_integer;
1302 begin
1303
1304 -- copy data to the local IN or IN-OUT args, if any
1305
1306
1307
1308
1309
1310
1311
1312 ddp_act_budgets_rec.activity_budget_id := p7_a0;
1313 ddp_act_budgets_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
1314 ddp_act_budgets_rec.last_updated_by := p7_a2;
1315 ddp_act_budgets_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
1316 ddp_act_budgets_rec.created_by := p7_a4;
1317 ddp_act_budgets_rec.last_update_login := p7_a5;
1318 ddp_act_budgets_rec.object_version_number := p7_a6;
1319 ddp_act_budgets_rec.act_budget_used_by_id := p7_a7;
1320 ddp_act_budgets_rec.arc_act_budget_used_by := p7_a8;
1321 ddp_act_budgets_rec.budget_source_type := p7_a9;
1322 ddp_act_budgets_rec.budget_source_id := p7_a10;
1323 ddp_act_budgets_rec.transaction_type := p7_a11;
1324 ddp_act_budgets_rec.request_amount := p7_a12;
1325 ddp_act_budgets_rec.request_currency := p7_a13;
1326 ddp_act_budgets_rec.request_date := rosetta_g_miss_date_in_map(p7_a14);
1327 ddp_act_budgets_rec.user_status_id := p7_a15;
1328 ddp_act_budgets_rec.status_code := p7_a16;
1329 ddp_act_budgets_rec.approved_amount := p7_a17;
1330 ddp_act_budgets_rec.approved_original_amount := p7_a18;
1331 ddp_act_budgets_rec.approved_in_currency := p7_a19;
1332 ddp_act_budgets_rec.approval_date := rosetta_g_miss_date_in_map(p7_a20);
1333 ddp_act_budgets_rec.approver_id := p7_a21;
1334 ddp_act_budgets_rec.spent_amount := p7_a22;
1335 ddp_act_budgets_rec.partner_po_number := p7_a23;
1336 ddp_act_budgets_rec.partner_po_date := rosetta_g_miss_date_in_map(p7_a24);
1337 ddp_act_budgets_rec.partner_po_approver := p7_a25;
1338 ddp_act_budgets_rec.adjusted_flag := p7_a26;
1339 ddp_act_budgets_rec.posted_flag := p7_a27;
1340 ddp_act_budgets_rec.justification := p7_a28;
1341 ddp_act_budgets_rec.comment := p7_a29;
1342 ddp_act_budgets_rec.parent_act_budget_id := p7_a30;
1343 ddp_act_budgets_rec.contact_id := p7_a31;
1344 ddp_act_budgets_rec.reason_code := p7_a32;
1345 ddp_act_budgets_rec.transfer_type := p7_a33;
1346 ddp_act_budgets_rec.requester_id := p7_a34;
1347 ddp_act_budgets_rec.date_required_by := rosetta_g_miss_date_in_map(p7_a35);
1348 ddp_act_budgets_rec.parent_source_id := p7_a36;
1349 ddp_act_budgets_rec.parent_src_curr := p7_a37;
1350 ddp_act_budgets_rec.parent_src_apprvd_amt := p7_a38;
1351 ddp_act_budgets_rec.partner_holding_type := p7_a39;
1352 ddp_act_budgets_rec.partner_address_id := p7_a40;
1353 ddp_act_budgets_rec.vendor_id := p7_a41;
1354 ddp_act_budgets_rec.owner_id := p7_a42;
1355 ddp_act_budgets_rec.recal_flag := p7_a43;
1356 ddp_act_budgets_rec.attribute_category := p7_a44;
1357 ddp_act_budgets_rec.attribute1 := p7_a45;
1358 ddp_act_budgets_rec.attribute2 := p7_a46;
1359 ddp_act_budgets_rec.attribute3 := p7_a47;
1360 ddp_act_budgets_rec.attribute4 := p7_a48;
1361 ddp_act_budgets_rec.attribute5 := p7_a49;
1362 ddp_act_budgets_rec.attribute6 := p7_a50;
1363 ddp_act_budgets_rec.attribute7 := p7_a51;
1364 ddp_act_budgets_rec.attribute8 := p7_a52;
1365 ddp_act_budgets_rec.attribute9 := p7_a53;
1366 ddp_act_budgets_rec.attribute10 := p7_a54;
1367 ddp_act_budgets_rec.attribute11 := p7_a55;
1371 ddp_act_budgets_rec.attribute15 := p7_a59;
1368 ddp_act_budgets_rec.attribute12 := p7_a56;
1369 ddp_act_budgets_rec.attribute13 := p7_a57;
1370 ddp_act_budgets_rec.attribute14 := p7_a58;
1372 ddp_act_budgets_rec.src_curr_req_amt := p7_a60;
1373
1374
1375
1376
1377
1378
1379
1380
1381 ddp_act_util_rec.object_type := p15_a0;
1382 ddp_act_util_rec.object_id := p15_a1;
1383 ddp_act_util_rec.adjustment_type := p15_a2;
1384 ddp_act_util_rec.camp_schedule_id := p15_a3;
1385 ddp_act_util_rec.adjustment_type_id := p15_a4;
1386 ddp_act_util_rec.product_level_type := p15_a5;
1387 ddp_act_util_rec.product_id := p15_a6;
1388 ddp_act_util_rec.cust_account_id := p15_a7;
1389 ddp_act_util_rec.price_adjustment_id := p15_a8;
1390 ddp_act_util_rec.utilization_type := p15_a9;
1391 ddp_act_util_rec.adjustment_date := rosetta_g_miss_date_in_map(p15_a10);
1392 ddp_act_util_rec.gl_date := rosetta_g_miss_date_in_map(p15_a11);
1393 ddp_act_util_rec.scan_unit := p15_a12;
1394 ddp_act_util_rec.scan_unit_remaining := p15_a13;
1395 ddp_act_util_rec.activity_product_id := p15_a14;
1396 ddp_act_util_rec.scan_type_id := p15_a15;
1397 ddp_act_util_rec.volume_offer_tiers_id := p15_a16;
1398 ddp_act_util_rec.billto_cust_account_id := p15_a17;
1399 ddp_act_util_rec.reference_type := p15_a18;
1400 ddp_act_util_rec.reference_id := p15_a19;
1401 ddp_act_util_rec.order_line_id := p15_a20;
1402 ddp_act_util_rec.org_id := p15_a21;
1403 ddp_act_util_rec.orig_utilization_id := p15_a22;
1404 ddp_act_util_rec.gl_posted_flag := p15_a23;
1405 ddp_act_util_rec.bill_to_site_use_id := p15_a24;
1406 ddp_act_util_rec.ship_to_site_use_id := p15_a25;
1407 ddp_act_util_rec.gl_account_credit := p15_a26;
1408 ddp_act_util_rec.gl_account_debit := p15_a27;
1409 ddp_act_util_rec.site_use_id := p15_a28;
1410 ddp_act_util_rec.attribute_category := p15_a29;
1411 ddp_act_util_rec.attribute1 := p15_a30;
1412 ddp_act_util_rec.attribute2 := p15_a31;
1413 ddp_act_util_rec.attribute3 := p15_a32;
1414 ddp_act_util_rec.attribute4 := p15_a33;
1415 ddp_act_util_rec.attribute5 := p15_a34;
1416 ddp_act_util_rec.attribute6 := p15_a35;
1417 ddp_act_util_rec.attribute7 := p15_a36;
1418 ddp_act_util_rec.attribute8 := p15_a37;
1419 ddp_act_util_rec.attribute9 := p15_a38;
1420 ddp_act_util_rec.attribute10 := p15_a39;
1421 ddp_act_util_rec.attribute11 := p15_a40;
1422 ddp_act_util_rec.attribute12 := p15_a41;
1423 ddp_act_util_rec.attribute13 := p15_a42;
1424 ddp_act_util_rec.attribute14 := p15_a43;
1425 ddp_act_util_rec.attribute15 := p15_a44;
1426
1427
1428 -- here's the delegated call to the old PL/SQL routine
1429 ozf_actbudgets_pvt.update_act_budgets(p_api_version,
1430 p_init_msg_list,
1431 p_commit,
1432 p_validation_level,
1433 x_return_status,
1434 x_msg_count,
1435 x_msg_data,
1436 ddp_act_budgets_rec,
1437 p_parent_process_flag,
1438 p_parent_process_key,
1439 p_parent_context,
1440 p_parent_approval_flag,
1441 p_continue_flow,
1442 p_child_approval_flag,
1443 p_requestor_owner_flag,
1444 ddp_act_util_rec,
1445 x_utilized_amount);
1446
1447 -- copy data back from the local variables to OUT or IN-OUT args, if any
1448
1449
1450
1451
1452
1453
1454
1455
1456
1457
1458
1459
1460
1461
1462
1463
1464 end;
1465
1466 procedure update_act_budgets(p_api_version NUMBER
1467 , p_init_msg_list VARCHAR2
1468 , p_commit VARCHAR2
1469 , p_validation_level NUMBER
1470 , x_return_status out nocopy VARCHAR2
1471 , x_msg_count out nocopy NUMBER
1472 , x_msg_data out nocopy VARCHAR2
1473 , p7_a0 NUMBER
1474 , p7_a1 DATE
1475 , p7_a2 NUMBER
1476 , p7_a3 DATE
1477 , p7_a4 NUMBER
1478 , p7_a5 NUMBER
1479 , p7_a6 NUMBER
1480 , p7_a7 NUMBER
1481 , p7_a8 VARCHAR2
1482 , p7_a9 VARCHAR2
1483 , p7_a10 NUMBER
1484 , p7_a11 VARCHAR2
1485 , p7_a12 NUMBER
1486 , p7_a13 VARCHAR2
1487 , p7_a14 DATE
1488 , p7_a15 NUMBER
1489 , p7_a16 VARCHAR2
1490 , p7_a17 NUMBER
1491 , p7_a18 NUMBER
1492 , p7_a19 VARCHAR2
1493 , p7_a20 DATE
1494 , p7_a21 NUMBER
1495 , p7_a22 NUMBER
1496 , p7_a23 VARCHAR2
1497 , p7_a24 DATE
1498 , p7_a25 VARCHAR2
1499 , p7_a26 VARCHAR2
1500 , p7_a27 VARCHAR2
1501 , p7_a28 VARCHAR
1502 , p7_a29 VARCHAR
1503 , p7_a30 NUMBER
1504 , p7_a31 NUMBER
1505 , p7_a32 VARCHAR2
1506 , p7_a33 VARCHAR2
1507 , p7_a34 NUMBER
1508 , p7_a35 DATE
1509 , p7_a36 NUMBER
1510 , p7_a37 VARCHAR2
1511 , p7_a38 NUMBER
1512 , p7_a39 VARCHAR2
1513 , p7_a40 NUMBER
1514 , p7_a41 NUMBER
1515 , p7_a42 NUMBER
1516 , p7_a43 VARCHAR2
1517 , p7_a44 VARCHAR2
1518 , p7_a45 VARCHAR2
1519 , p7_a46 VARCHAR2
1520 , p7_a47 VARCHAR2
1521 , p7_a48 VARCHAR2
1522 , p7_a49 VARCHAR2
1523 , p7_a50 VARCHAR2
1524 , p7_a51 VARCHAR2
1525 , p7_a52 VARCHAR2
1526 , p7_a53 VARCHAR2
1527 , p7_a54 VARCHAR2
1528 , p7_a55 VARCHAR2
1529 , p7_a56 VARCHAR2
1530 , p7_a57 VARCHAR2
1531 , p7_a58 VARCHAR2
1532 , p7_a59 VARCHAR2
1533 , p7_a60 NUMBER
1534 , p_child_approval_flag VARCHAR2
1535 , p_requestor_owner_flag VARCHAR2
1536 , p10_a0 VARCHAR2
1540 , p10_a4 NUMBER
1537 , p10_a1 NUMBER
1538 , p10_a2 VARCHAR2
1539 , p10_a3 NUMBER
1541 , p10_a5 VARCHAR2
1542 , p10_a6 NUMBER
1543 , p10_a7 NUMBER
1544 , p10_a8 NUMBER
1545 , p10_a9 VARCHAR2
1546 , p10_a10 DATE
1547 , p10_a11 DATE
1548 , p10_a12 NUMBER
1549 , p10_a13 NUMBER
1550 , p10_a14 NUMBER
1551 , p10_a15 NUMBER
1552 , p10_a16 NUMBER
1553 , p10_a17 NUMBER
1554 , p10_a18 VARCHAR2
1555 , p10_a19 NUMBER
1556 , p10_a20 NUMBER
1557 , p10_a21 NUMBER
1558 , p10_a22 NUMBER
1559 , p10_a23 VARCHAR2
1560 , p10_a24 NUMBER
1561 , p10_a25 NUMBER
1562 , p10_a26 NUMBER
1563 , p10_a27 NUMBER
1564 , p10_a28 NUMBER
1565 , p10_a29 VARCHAR2
1566 , p10_a30 VARCHAR2
1567 , p10_a31 VARCHAR2
1568 , p10_a32 VARCHAR2
1569 , p10_a33 VARCHAR2
1570 , p10_a34 VARCHAR2
1571 , p10_a35 VARCHAR2
1572 , p10_a36 VARCHAR2
1573 , p10_a37 VARCHAR2
1574 , p10_a38 VARCHAR2
1575 , p10_a39 VARCHAR2
1576 , p10_a40 VARCHAR2
1577 , p10_a41 VARCHAR2
1578 , p10_a42 VARCHAR2
1579 , p10_a43 VARCHAR2
1580 , p10_a44 VARCHAR2
1581 )
1582
1583 as
1584 ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1585 ddp_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
1586 ddindx binary_integer; indx binary_integer;
1587 begin
1588
1589 -- copy data to the local IN or IN-OUT args, if any
1590
1591
1592
1593
1594
1595
1596
1597 ddp_act_budgets_rec.activity_budget_id := p7_a0;
1598 ddp_act_budgets_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
1599 ddp_act_budgets_rec.last_updated_by := p7_a2;
1600 ddp_act_budgets_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
1601 ddp_act_budgets_rec.created_by := p7_a4;
1602 ddp_act_budgets_rec.last_update_login := p7_a5;
1603 ddp_act_budgets_rec.object_version_number := p7_a6;
1604 ddp_act_budgets_rec.act_budget_used_by_id := p7_a7;
1605 ddp_act_budgets_rec.arc_act_budget_used_by := p7_a8;
1606 ddp_act_budgets_rec.budget_source_type := p7_a9;
1607 ddp_act_budgets_rec.budget_source_id := p7_a10;
1608 ddp_act_budgets_rec.transaction_type := p7_a11;
1609 ddp_act_budgets_rec.request_amount := p7_a12;
1610 ddp_act_budgets_rec.request_currency := p7_a13;
1611 ddp_act_budgets_rec.request_date := rosetta_g_miss_date_in_map(p7_a14);
1612 ddp_act_budgets_rec.user_status_id := p7_a15;
1613 ddp_act_budgets_rec.status_code := p7_a16;
1614 ddp_act_budgets_rec.approved_amount := p7_a17;
1615 ddp_act_budgets_rec.approved_original_amount := p7_a18;
1616 ddp_act_budgets_rec.approved_in_currency := p7_a19;
1617 ddp_act_budgets_rec.approval_date := rosetta_g_miss_date_in_map(p7_a20);
1618 ddp_act_budgets_rec.approver_id := p7_a21;
1619 ddp_act_budgets_rec.spent_amount := p7_a22;
1620 ddp_act_budgets_rec.partner_po_number := p7_a23;
1621 ddp_act_budgets_rec.partner_po_date := rosetta_g_miss_date_in_map(p7_a24);
1622 ddp_act_budgets_rec.partner_po_approver := p7_a25;
1623 ddp_act_budgets_rec.adjusted_flag := p7_a26;
1624 ddp_act_budgets_rec.posted_flag := p7_a27;
1625 ddp_act_budgets_rec.justification := p7_a28;
1626 ddp_act_budgets_rec.comment := p7_a29;
1627 ddp_act_budgets_rec.parent_act_budget_id := p7_a30;
1628 ddp_act_budgets_rec.contact_id := p7_a31;
1629 ddp_act_budgets_rec.reason_code := p7_a32;
1630 ddp_act_budgets_rec.transfer_type := p7_a33;
1631 ddp_act_budgets_rec.requester_id := p7_a34;
1632 ddp_act_budgets_rec.date_required_by := rosetta_g_miss_date_in_map(p7_a35);
1633 ddp_act_budgets_rec.parent_source_id := p7_a36;
1634 ddp_act_budgets_rec.parent_src_curr := p7_a37;
1635 ddp_act_budgets_rec.parent_src_apprvd_amt := p7_a38;
1636 ddp_act_budgets_rec.partner_holding_type := p7_a39;
1637 ddp_act_budgets_rec.partner_address_id := p7_a40;
1638 ddp_act_budgets_rec.vendor_id := p7_a41;
1639 ddp_act_budgets_rec.owner_id := p7_a42;
1640 ddp_act_budgets_rec.recal_flag := p7_a43;
1641 ddp_act_budgets_rec.attribute_category := p7_a44;
1642 ddp_act_budgets_rec.attribute1 := p7_a45;
1643 ddp_act_budgets_rec.attribute2 := p7_a46;
1644 ddp_act_budgets_rec.attribute3 := p7_a47;
1645 ddp_act_budgets_rec.attribute4 := p7_a48;
1646 ddp_act_budgets_rec.attribute5 := p7_a49;
1647 ddp_act_budgets_rec.attribute6 := p7_a50;
1648 ddp_act_budgets_rec.attribute7 := p7_a51;
1649 ddp_act_budgets_rec.attribute8 := p7_a52;
1650 ddp_act_budgets_rec.attribute9 := p7_a53;
1651 ddp_act_budgets_rec.attribute10 := p7_a54;
1652 ddp_act_budgets_rec.attribute11 := p7_a55;
1653 ddp_act_budgets_rec.attribute12 := p7_a56;
1654 ddp_act_budgets_rec.attribute13 := p7_a57;
1655 ddp_act_budgets_rec.attribute14 := p7_a58;
1656 ddp_act_budgets_rec.attribute15 := p7_a59;
1657 ddp_act_budgets_rec.src_curr_req_amt := p7_a60;
1658
1659
1660
1661 ddp_act_util_rec.object_type := p10_a0;
1662 ddp_act_util_rec.object_id := p10_a1;
1663 ddp_act_util_rec.adjustment_type := p10_a2;
1664 ddp_act_util_rec.camp_schedule_id := p10_a3;
1665 ddp_act_util_rec.adjustment_type_id := p10_a4;
1666 ddp_act_util_rec.product_level_type := p10_a5;
1667 ddp_act_util_rec.product_id := p10_a6;
1668 ddp_act_util_rec.cust_account_id := p10_a7;
1669 ddp_act_util_rec.price_adjustment_id := p10_a8;
1670 ddp_act_util_rec.utilization_type := p10_a9;
1671 ddp_act_util_rec.adjustment_date := rosetta_g_miss_date_in_map(p10_a10);
1672 ddp_act_util_rec.gl_date := rosetta_g_miss_date_in_map(p10_a11);
1673 ddp_act_util_rec.scan_unit := p10_a12;
1674 ddp_act_util_rec.scan_unit_remaining := p10_a13;
1678 ddp_act_util_rec.billto_cust_account_id := p10_a17;
1675 ddp_act_util_rec.activity_product_id := p10_a14;
1676 ddp_act_util_rec.scan_type_id := p10_a15;
1677 ddp_act_util_rec.volume_offer_tiers_id := p10_a16;
1679 ddp_act_util_rec.reference_type := p10_a18;
1680 ddp_act_util_rec.reference_id := p10_a19;
1681 ddp_act_util_rec.order_line_id := p10_a20;
1682 ddp_act_util_rec.org_id := p10_a21;
1683 ddp_act_util_rec.orig_utilization_id := p10_a22;
1684 ddp_act_util_rec.gl_posted_flag := p10_a23;
1685 ddp_act_util_rec.bill_to_site_use_id := p10_a24;
1686 ddp_act_util_rec.ship_to_site_use_id := p10_a25;
1687 ddp_act_util_rec.gl_account_credit := p10_a26;
1688 ddp_act_util_rec.gl_account_debit := p10_a27;
1689 ddp_act_util_rec.site_use_id := p10_a28;
1690 ddp_act_util_rec.attribute_category := p10_a29;
1691 ddp_act_util_rec.attribute1 := p10_a30;
1692 ddp_act_util_rec.attribute2 := p10_a31;
1693 ddp_act_util_rec.attribute3 := p10_a32;
1694 ddp_act_util_rec.attribute4 := p10_a33;
1695 ddp_act_util_rec.attribute5 := p10_a34;
1696 ddp_act_util_rec.attribute6 := p10_a35;
1697 ddp_act_util_rec.attribute7 := p10_a36;
1698 ddp_act_util_rec.attribute8 := p10_a37;
1699 ddp_act_util_rec.attribute9 := p10_a38;
1700 ddp_act_util_rec.attribute10 := p10_a39;
1701 ddp_act_util_rec.attribute11 := p10_a40;
1702 ddp_act_util_rec.attribute12 := p10_a41;
1703 ddp_act_util_rec.attribute13 := p10_a42;
1704 ddp_act_util_rec.attribute14 := p10_a43;
1705 ddp_act_util_rec.attribute15 := p10_a44;
1706
1707 -- here's the delegated call to the old PL/SQL routine
1708 ozf_actbudgets_pvt.update_act_budgets(p_api_version,
1709 p_init_msg_list,
1710 p_commit,
1711 p_validation_level,
1712 x_return_status,
1713 x_msg_count,
1714 x_msg_data,
1715 ddp_act_budgets_rec,
1716 p_child_approval_flag,
1717 p_requestor_owner_flag,
1718 ddp_act_util_rec);
1719
1720 -- copy data back from the local variables to OUT or IN-OUT args, if any
1721
1722
1723
1724
1725
1726
1727
1728
1729
1730
1731 end;
1732
1733 procedure update_act_budgets(p_api_version NUMBER
1734 , p_init_msg_list VARCHAR2
1735 , p_commit VARCHAR2
1736 , p_validation_level NUMBER
1737 , x_return_status out nocopy VARCHAR2
1738 , x_msg_count out nocopy NUMBER
1739 , x_msg_data out nocopy VARCHAR2
1740 , p7_a0 NUMBER
1741 , p7_a1 DATE
1742 , p7_a2 NUMBER
1743 , p7_a3 DATE
1744 , p7_a4 NUMBER
1745 , p7_a5 NUMBER
1746 , p7_a6 NUMBER
1747 , p7_a7 NUMBER
1748 , p7_a8 VARCHAR2
1749 , p7_a9 VARCHAR2
1750 , p7_a10 NUMBER
1751 , p7_a11 VARCHAR2
1752 , p7_a12 NUMBER
1753 , p7_a13 VARCHAR2
1754 , p7_a14 DATE
1755 , p7_a15 NUMBER
1756 , p7_a16 VARCHAR2
1757 , p7_a17 NUMBER
1758 , p7_a18 NUMBER
1759 , p7_a19 VARCHAR2
1760 , p7_a20 DATE
1761 , p7_a21 NUMBER
1762 , p7_a22 NUMBER
1763 , p7_a23 VARCHAR2
1764 , p7_a24 DATE
1765 , p7_a25 VARCHAR2
1766 , p7_a26 VARCHAR2
1767 , p7_a27 VARCHAR2
1768 , p7_a28 VARCHAR
1769 , p7_a29 VARCHAR
1770 , p7_a30 NUMBER
1771 , p7_a31 NUMBER
1772 , p7_a32 VARCHAR2
1773 , p7_a33 VARCHAR2
1774 , p7_a34 NUMBER
1775 , p7_a35 DATE
1776 , p7_a36 NUMBER
1777 , p7_a37 VARCHAR2
1778 , p7_a38 NUMBER
1779 , p7_a39 VARCHAR2
1780 , p7_a40 NUMBER
1781 , p7_a41 NUMBER
1782 , p7_a42 NUMBER
1783 , p7_a43 VARCHAR2
1784 , p7_a44 VARCHAR2
1785 , p7_a45 VARCHAR2
1786 , p7_a46 VARCHAR2
1787 , p7_a47 VARCHAR2
1788 , p7_a48 VARCHAR2
1789 , p7_a49 VARCHAR2
1790 , p7_a50 VARCHAR2
1791 , p7_a51 VARCHAR2
1792 , p7_a52 VARCHAR2
1793 , p7_a53 VARCHAR2
1794 , p7_a54 VARCHAR2
1795 , p7_a55 VARCHAR2
1796 , p7_a56 VARCHAR2
1797 , p7_a57 VARCHAR2
1798 , p7_a58 VARCHAR2
1799 , p7_a59 VARCHAR2
1800 , p7_a60 NUMBER
1801 , p_child_approval_flag VARCHAR2
1802 , p_requestor_owner_flag VARCHAR2
1803 , p10_a0 VARCHAR2
1804 , p10_a1 NUMBER
1805 , p10_a2 VARCHAR2
1806 , p10_a3 NUMBER
1807 , p10_a4 NUMBER
1808 , p10_a5 VARCHAR2
1809 , p10_a6 NUMBER
1810 , p10_a7 NUMBER
1811 , p10_a8 NUMBER
1812 , p10_a9 VARCHAR2
1813 , p10_a10 DATE
1814 , p10_a11 DATE
1815 , p10_a12 NUMBER
1816 , p10_a13 NUMBER
1817 , p10_a14 NUMBER
1821 , p10_a18 VARCHAR2
1818 , p10_a15 NUMBER
1819 , p10_a16 NUMBER
1820 , p10_a17 NUMBER
1822 , p10_a19 NUMBER
1823 , p10_a20 NUMBER
1824 , p10_a21 NUMBER
1825 , p10_a22 NUMBER
1826 , p10_a23 VARCHAR2
1827 , p10_a24 NUMBER
1828 , p10_a25 NUMBER
1829 , p10_a26 NUMBER
1830 , p10_a27 NUMBER
1831 , p10_a28 NUMBER
1832 , p10_a29 VARCHAR2
1833 , p10_a30 VARCHAR2
1834 , p10_a31 VARCHAR2
1835 , p10_a32 VARCHAR2
1836 , p10_a33 VARCHAR2
1837 , p10_a34 VARCHAR2
1838 , p10_a35 VARCHAR2
1839 , p10_a36 VARCHAR2
1840 , p10_a37 VARCHAR2
1841 , p10_a38 VARCHAR2
1842 , p10_a39 VARCHAR2
1843 , p10_a40 VARCHAR2
1844 , p10_a41 VARCHAR2
1845 , p10_a42 VARCHAR2
1846 , p10_a43 VARCHAR2
1847 , p10_a44 VARCHAR2
1848 , x_utilized_amount out nocopy NUMBER
1849 )
1850
1851 as
1852 ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1853 ddp_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
1854 ddindx binary_integer; indx binary_integer;
1855 begin
1856
1857 -- copy data to the local IN or IN-OUT args, if any
1858
1859
1860
1861
1862
1863
1864
1865 ddp_act_budgets_rec.activity_budget_id := p7_a0;
1866 ddp_act_budgets_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
1867 ddp_act_budgets_rec.last_updated_by := p7_a2;
1868 ddp_act_budgets_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
1869 ddp_act_budgets_rec.created_by := p7_a4;
1870 ddp_act_budgets_rec.last_update_login := p7_a5;
1871 ddp_act_budgets_rec.object_version_number := p7_a6;
1872 ddp_act_budgets_rec.act_budget_used_by_id := p7_a7;
1873 ddp_act_budgets_rec.arc_act_budget_used_by := p7_a8;
1874 ddp_act_budgets_rec.budget_source_type := p7_a9;
1875 ddp_act_budgets_rec.budget_source_id := p7_a10;
1876 ddp_act_budgets_rec.transaction_type := p7_a11;
1877 ddp_act_budgets_rec.request_amount := p7_a12;
1878 ddp_act_budgets_rec.request_currency := p7_a13;
1879 ddp_act_budgets_rec.request_date := rosetta_g_miss_date_in_map(p7_a14);
1880 ddp_act_budgets_rec.user_status_id := p7_a15;
1881 ddp_act_budgets_rec.status_code := p7_a16;
1882 ddp_act_budgets_rec.approved_amount := p7_a17;
1883 ddp_act_budgets_rec.approved_original_amount := p7_a18;
1884 ddp_act_budgets_rec.approved_in_currency := p7_a19;
1885 ddp_act_budgets_rec.approval_date := rosetta_g_miss_date_in_map(p7_a20);
1886 ddp_act_budgets_rec.approver_id := p7_a21;
1887 ddp_act_budgets_rec.spent_amount := p7_a22;
1888 ddp_act_budgets_rec.partner_po_number := p7_a23;
1889 ddp_act_budgets_rec.partner_po_date := rosetta_g_miss_date_in_map(p7_a24);
1890 ddp_act_budgets_rec.partner_po_approver := p7_a25;
1891 ddp_act_budgets_rec.adjusted_flag := p7_a26;
1892 ddp_act_budgets_rec.posted_flag := p7_a27;
1893 ddp_act_budgets_rec.justification := p7_a28;
1894 ddp_act_budgets_rec.comment := p7_a29;
1895 ddp_act_budgets_rec.parent_act_budget_id := p7_a30;
1896 ddp_act_budgets_rec.contact_id := p7_a31;
1897 ddp_act_budgets_rec.reason_code := p7_a32;
1898 ddp_act_budgets_rec.transfer_type := p7_a33;
1899 ddp_act_budgets_rec.requester_id := p7_a34;
1900 ddp_act_budgets_rec.date_required_by := rosetta_g_miss_date_in_map(p7_a35);
1901 ddp_act_budgets_rec.parent_source_id := p7_a36;
1902 ddp_act_budgets_rec.parent_src_curr := p7_a37;
1903 ddp_act_budgets_rec.parent_src_apprvd_amt := p7_a38;
1904 ddp_act_budgets_rec.partner_holding_type := p7_a39;
1905 ddp_act_budgets_rec.partner_address_id := p7_a40;
1906 ddp_act_budgets_rec.vendor_id := p7_a41;
1907 ddp_act_budgets_rec.owner_id := p7_a42;
1908 ddp_act_budgets_rec.recal_flag := p7_a43;
1909 ddp_act_budgets_rec.attribute_category := p7_a44;
1910 ddp_act_budgets_rec.attribute1 := p7_a45;
1911 ddp_act_budgets_rec.attribute2 := p7_a46;
1912 ddp_act_budgets_rec.attribute3 := p7_a47;
1913 ddp_act_budgets_rec.attribute4 := p7_a48;
1914 ddp_act_budgets_rec.attribute5 := p7_a49;
1915 ddp_act_budgets_rec.attribute6 := p7_a50;
1916 ddp_act_budgets_rec.attribute7 := p7_a51;
1917 ddp_act_budgets_rec.attribute8 := p7_a52;
1918 ddp_act_budgets_rec.attribute9 := p7_a53;
1919 ddp_act_budgets_rec.attribute10 := p7_a54;
1920 ddp_act_budgets_rec.attribute11 := p7_a55;
1921 ddp_act_budgets_rec.attribute12 := p7_a56;
1922 ddp_act_budgets_rec.attribute13 := p7_a57;
1923 ddp_act_budgets_rec.attribute14 := p7_a58;
1924 ddp_act_budgets_rec.attribute15 := p7_a59;
1925 ddp_act_budgets_rec.src_curr_req_amt := p7_a60;
1926
1927
1928
1929 ddp_act_util_rec.object_type := p10_a0;
1930 ddp_act_util_rec.object_id := p10_a1;
1931 ddp_act_util_rec.adjustment_type := p10_a2;
1932 ddp_act_util_rec.camp_schedule_id := p10_a3;
1933 ddp_act_util_rec.adjustment_type_id := p10_a4;
1934 ddp_act_util_rec.product_level_type := p10_a5;
1935 ddp_act_util_rec.product_id := p10_a6;
1936 ddp_act_util_rec.cust_account_id := p10_a7;
1937 ddp_act_util_rec.price_adjustment_id := p10_a8;
1938 ddp_act_util_rec.utilization_type := p10_a9;
1939 ddp_act_util_rec.adjustment_date := rosetta_g_miss_date_in_map(p10_a10);
1940 ddp_act_util_rec.gl_date := rosetta_g_miss_date_in_map(p10_a11);
1941 ddp_act_util_rec.scan_unit := p10_a12;
1942 ddp_act_util_rec.scan_unit_remaining := p10_a13;
1943 ddp_act_util_rec.activity_product_id := p10_a14;
1944 ddp_act_util_rec.scan_type_id := p10_a15;
1945 ddp_act_util_rec.volume_offer_tiers_id := p10_a16;
1946 ddp_act_util_rec.billto_cust_account_id := p10_a17;
1947 ddp_act_util_rec.reference_type := p10_a18;
1948 ddp_act_util_rec.reference_id := p10_a19;
1952 ddp_act_util_rec.gl_posted_flag := p10_a23;
1949 ddp_act_util_rec.order_line_id := p10_a20;
1950 ddp_act_util_rec.org_id := p10_a21;
1951 ddp_act_util_rec.orig_utilization_id := p10_a22;
1953 ddp_act_util_rec.bill_to_site_use_id := p10_a24;
1954 ddp_act_util_rec.ship_to_site_use_id := p10_a25;
1955 ddp_act_util_rec.gl_account_credit := p10_a26;
1956 ddp_act_util_rec.gl_account_debit := p10_a27;
1957 ddp_act_util_rec.site_use_id := p10_a28;
1958 ddp_act_util_rec.attribute_category := p10_a29;
1959 ddp_act_util_rec.attribute1 := p10_a30;
1960 ddp_act_util_rec.attribute2 := p10_a31;
1961 ddp_act_util_rec.attribute3 := p10_a32;
1962 ddp_act_util_rec.attribute4 := p10_a33;
1963 ddp_act_util_rec.attribute5 := p10_a34;
1964 ddp_act_util_rec.attribute6 := p10_a35;
1965 ddp_act_util_rec.attribute7 := p10_a36;
1966 ddp_act_util_rec.attribute8 := p10_a37;
1967 ddp_act_util_rec.attribute9 := p10_a38;
1968 ddp_act_util_rec.attribute10 := p10_a39;
1969 ddp_act_util_rec.attribute11 := p10_a40;
1970 ddp_act_util_rec.attribute12 := p10_a41;
1971 ddp_act_util_rec.attribute13 := p10_a42;
1972 ddp_act_util_rec.attribute14 := p10_a43;
1973 ddp_act_util_rec.attribute15 := p10_a44;
1974
1975
1976 -- here's the delegated call to the old PL/SQL routine
1977 ozf_actbudgets_pvt.update_act_budgets(p_api_version,
1978 p_init_msg_list,
1979 p_commit,
1980 p_validation_level,
1981 x_return_status,
1982 x_msg_count,
1983 x_msg_data,
1984 ddp_act_budgets_rec,
1985 p_child_approval_flag,
1986 p_requestor_owner_flag,
1987 ddp_act_util_rec,
1988 x_utilized_amount);
1989
1990 -- copy data back from the local variables to OUT or IN-OUT args, if any
1991
1992
1993
1994
1995
1996
1997
1998
1999
2000
2001
2002 end;
2003
2004 procedure validate_act_budgets(p_api_version NUMBER
2005 , p_init_msg_list VARCHAR2
2006 , p_validation_level NUMBER
2007 , x_return_status out nocopy VARCHAR2
2008 , x_msg_count out nocopy NUMBER
2009 , x_msg_data out nocopy VARCHAR2
2010 , p6_a0 NUMBER
2011 , p6_a1 DATE
2012 , p6_a2 NUMBER
2013 , p6_a3 DATE
2014 , p6_a4 NUMBER
2015 , p6_a5 NUMBER
2016 , p6_a6 NUMBER
2017 , p6_a7 NUMBER
2018 , p6_a8 VARCHAR2
2019 , p6_a9 VARCHAR2
2020 , p6_a10 NUMBER
2021 , p6_a11 VARCHAR2
2022 , p6_a12 NUMBER
2023 , p6_a13 VARCHAR2
2024 , p6_a14 DATE
2025 , p6_a15 NUMBER
2026 , p6_a16 VARCHAR2
2027 , p6_a17 NUMBER
2028 , p6_a18 NUMBER
2029 , p6_a19 VARCHAR2
2030 , p6_a20 DATE
2031 , p6_a21 NUMBER
2032 , p6_a22 NUMBER
2033 , p6_a23 VARCHAR2
2034 , p6_a24 DATE
2035 , p6_a25 VARCHAR2
2036 , p6_a26 VARCHAR2
2037 , p6_a27 VARCHAR2
2038 , p6_a28 VARCHAR
2039 , p6_a29 VARCHAR
2040 , p6_a30 NUMBER
2041 , p6_a31 NUMBER
2042 , p6_a32 VARCHAR2
2043 , p6_a33 VARCHAR2
2044 , p6_a34 NUMBER
2045 , p6_a35 DATE
2046 , p6_a36 NUMBER
2047 , p6_a37 VARCHAR2
2048 , p6_a38 NUMBER
2049 , p6_a39 VARCHAR2
2050 , p6_a40 NUMBER
2051 , p6_a41 NUMBER
2052 , p6_a42 NUMBER
2053 , p6_a43 VARCHAR2
2054 , p6_a44 VARCHAR2
2055 , p6_a45 VARCHAR2
2056 , p6_a46 VARCHAR2
2057 , p6_a47 VARCHAR2
2058 , p6_a48 VARCHAR2
2059 , p6_a49 VARCHAR2
2060 , p6_a50 VARCHAR2
2061 , p6_a51 VARCHAR2
2062 , p6_a52 VARCHAR2
2063 , p6_a53 VARCHAR2
2064 , p6_a54 VARCHAR2
2065 , p6_a55 VARCHAR2
2066 , p6_a56 VARCHAR2
2067 , p6_a57 VARCHAR2
2068 , p6_a58 VARCHAR2
2069 , p6_a59 VARCHAR2
2070 , p6_a60 NUMBER
2071 )
2072
2073 as
2074 ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2075 ddindx binary_integer; indx binary_integer;
2076 begin
2077
2078 -- copy data to the local IN or IN-OUT args, if any
2079
2080
2081
2082
2083
2084
2085 ddp_act_budgets_rec.activity_budget_id := p6_a0;
2086 ddp_act_budgets_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a1);
2087 ddp_act_budgets_rec.last_updated_by := p6_a2;
2088 ddp_act_budgets_rec.creation_date := rosetta_g_miss_date_in_map(p6_a3);
2089 ddp_act_budgets_rec.created_by := p6_a4;
2090 ddp_act_budgets_rec.last_update_login := p6_a5;
2091 ddp_act_budgets_rec.object_version_number := p6_a6;
2092 ddp_act_budgets_rec.act_budget_used_by_id := p6_a7;
2093 ddp_act_budgets_rec.arc_act_budget_used_by := p6_a8;
2094 ddp_act_budgets_rec.budget_source_type := p6_a9;
2095 ddp_act_budgets_rec.budget_source_id := p6_a10;
2096 ddp_act_budgets_rec.transaction_type := p6_a11;
2097 ddp_act_budgets_rec.request_amount := p6_a12;
2098 ddp_act_budgets_rec.request_currency := p6_a13;
2099 ddp_act_budgets_rec.request_date := rosetta_g_miss_date_in_map(p6_a14);
2100 ddp_act_budgets_rec.user_status_id := p6_a15;
2101 ddp_act_budgets_rec.status_code := p6_a16;
2102 ddp_act_budgets_rec.approved_amount := p6_a17;
2103 ddp_act_budgets_rec.approved_original_amount := p6_a18;
2104 ddp_act_budgets_rec.approved_in_currency := p6_a19;
2105 ddp_act_budgets_rec.approval_date := rosetta_g_miss_date_in_map(p6_a20);
2106 ddp_act_budgets_rec.approver_id := p6_a21;
2107 ddp_act_budgets_rec.spent_amount := p6_a22;
2108 ddp_act_budgets_rec.partner_po_number := p6_a23;
2109 ddp_act_budgets_rec.partner_po_date := rosetta_g_miss_date_in_map(p6_a24);
2113 ddp_act_budgets_rec.justification := p6_a28;
2110 ddp_act_budgets_rec.partner_po_approver := p6_a25;
2111 ddp_act_budgets_rec.adjusted_flag := p6_a26;
2112 ddp_act_budgets_rec.posted_flag := p6_a27;
2114 ddp_act_budgets_rec.comment := p6_a29;
2115 ddp_act_budgets_rec.parent_act_budget_id := p6_a30;
2116 ddp_act_budgets_rec.contact_id := p6_a31;
2117 ddp_act_budgets_rec.reason_code := p6_a32;
2118 ddp_act_budgets_rec.transfer_type := p6_a33;
2119 ddp_act_budgets_rec.requester_id := p6_a34;
2120 ddp_act_budgets_rec.date_required_by := rosetta_g_miss_date_in_map(p6_a35);
2121 ddp_act_budgets_rec.parent_source_id := p6_a36;
2122 ddp_act_budgets_rec.parent_src_curr := p6_a37;
2123 ddp_act_budgets_rec.parent_src_apprvd_amt := p6_a38;
2124 ddp_act_budgets_rec.partner_holding_type := p6_a39;
2125 ddp_act_budgets_rec.partner_address_id := p6_a40;
2126 ddp_act_budgets_rec.vendor_id := p6_a41;
2127 ddp_act_budgets_rec.owner_id := p6_a42;
2128 ddp_act_budgets_rec.recal_flag := p6_a43;
2129 ddp_act_budgets_rec.attribute_category := p6_a44;
2130 ddp_act_budgets_rec.attribute1 := p6_a45;
2131 ddp_act_budgets_rec.attribute2 := p6_a46;
2132 ddp_act_budgets_rec.attribute3 := p6_a47;
2133 ddp_act_budgets_rec.attribute4 := p6_a48;
2134 ddp_act_budgets_rec.attribute5 := p6_a49;
2135 ddp_act_budgets_rec.attribute6 := p6_a50;
2136 ddp_act_budgets_rec.attribute7 := p6_a51;
2137 ddp_act_budgets_rec.attribute8 := p6_a52;
2138 ddp_act_budgets_rec.attribute9 := p6_a53;
2139 ddp_act_budgets_rec.attribute10 := p6_a54;
2140 ddp_act_budgets_rec.attribute11 := p6_a55;
2141 ddp_act_budgets_rec.attribute12 := p6_a56;
2142 ddp_act_budgets_rec.attribute13 := p6_a57;
2143 ddp_act_budgets_rec.attribute14 := p6_a58;
2144 ddp_act_budgets_rec.attribute15 := p6_a59;
2145 ddp_act_budgets_rec.src_curr_req_amt := p6_a60;
2146
2147 -- here's the delegated call to the old PL/SQL routine
2148 ozf_actbudgets_pvt.validate_act_budgets(p_api_version,
2149 p_init_msg_list,
2150 p_validation_level,
2151 x_return_status,
2152 x_msg_count,
2153 x_msg_data,
2154 ddp_act_budgets_rec);
2155
2156 -- copy data back from the local variables to OUT or IN-OUT args, if any
2157
2158
2159
2160
2161
2162
2163 end;
2164
2165 procedure validate_act_budgets_items(p0_a0 NUMBER
2166 , p0_a1 DATE
2167 , p0_a2 NUMBER
2168 , p0_a3 DATE
2169 , p0_a4 NUMBER
2170 , p0_a5 NUMBER
2171 , p0_a6 NUMBER
2172 , p0_a7 NUMBER
2173 , p0_a8 VARCHAR2
2174 , p0_a9 VARCHAR2
2175 , p0_a10 NUMBER
2176 , p0_a11 VARCHAR2
2177 , p0_a12 NUMBER
2178 , p0_a13 VARCHAR2
2179 , p0_a14 DATE
2180 , p0_a15 NUMBER
2181 , p0_a16 VARCHAR2
2182 , p0_a17 NUMBER
2183 , p0_a18 NUMBER
2184 , p0_a19 VARCHAR2
2185 , p0_a20 DATE
2186 , p0_a21 NUMBER
2187 , p0_a22 NUMBER
2188 , p0_a23 VARCHAR2
2189 , p0_a24 DATE
2190 , p0_a25 VARCHAR2
2191 , p0_a26 VARCHAR2
2192 , p0_a27 VARCHAR2
2193 , p0_a28 VARCHAR
2194 , p0_a29 VARCHAR
2195 , p0_a30 NUMBER
2196 , p0_a31 NUMBER
2197 , p0_a32 VARCHAR2
2198 , p0_a33 VARCHAR2
2199 , p0_a34 NUMBER
2200 , p0_a35 DATE
2201 , p0_a36 NUMBER
2202 , p0_a37 VARCHAR2
2203 , p0_a38 NUMBER
2204 , p0_a39 VARCHAR2
2205 , p0_a40 NUMBER
2206 , p0_a41 NUMBER
2207 , p0_a42 NUMBER
2208 , p0_a43 VARCHAR2
2209 , p0_a44 VARCHAR2
2210 , p0_a45 VARCHAR2
2211 , p0_a46 VARCHAR2
2212 , p0_a47 VARCHAR2
2213 , p0_a48 VARCHAR2
2214 , p0_a49 VARCHAR2
2215 , p0_a50 VARCHAR2
2216 , p0_a51 VARCHAR2
2217 , p0_a52 VARCHAR2
2218 , p0_a53 VARCHAR2
2219 , p0_a54 VARCHAR2
2220 , p0_a55 VARCHAR2
2221 , p0_a56 VARCHAR2
2222 , p0_a57 VARCHAR2
2223 , p0_a58 VARCHAR2
2224 , p0_a59 VARCHAR2
2225 , p0_a60 NUMBER
2226 , p_validation_mode VARCHAR2
2227 , x_return_status out nocopy VARCHAR2
2228 )
2229
2230 as
2231 ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2232 ddindx binary_integer; indx binary_integer;
2233 begin
2234
2235 -- copy data to the local IN or IN-OUT args, if any
2236 ddp_act_budgets_rec.activity_budget_id := p0_a0;
2237 ddp_act_budgets_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
2238 ddp_act_budgets_rec.last_updated_by := p0_a2;
2239 ddp_act_budgets_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
2240 ddp_act_budgets_rec.created_by := p0_a4;
2241 ddp_act_budgets_rec.last_update_login := p0_a5;
2242 ddp_act_budgets_rec.object_version_number := p0_a6;
2243 ddp_act_budgets_rec.act_budget_used_by_id := p0_a7;
2244 ddp_act_budgets_rec.arc_act_budget_used_by := p0_a8;
2245 ddp_act_budgets_rec.budget_source_type := p0_a9;
2246 ddp_act_budgets_rec.budget_source_id := p0_a10;
2247 ddp_act_budgets_rec.transaction_type := p0_a11;
2248 ddp_act_budgets_rec.request_amount := p0_a12;
2249 ddp_act_budgets_rec.request_currency := p0_a13;
2250 ddp_act_budgets_rec.request_date := rosetta_g_miss_date_in_map(p0_a14);
2251 ddp_act_budgets_rec.user_status_id := p0_a15;
2252 ddp_act_budgets_rec.status_code := p0_a16;
2253 ddp_act_budgets_rec.approved_amount := p0_a17;
2254 ddp_act_budgets_rec.approved_original_amount := p0_a18;
2255 ddp_act_budgets_rec.approved_in_currency := p0_a19;
2256 ddp_act_budgets_rec.approval_date := rosetta_g_miss_date_in_map(p0_a20);
2257 ddp_act_budgets_rec.approver_id := p0_a21;
2258 ddp_act_budgets_rec.spent_amount := p0_a22;
2262 ddp_act_budgets_rec.adjusted_flag := p0_a26;
2259 ddp_act_budgets_rec.partner_po_number := p0_a23;
2260 ddp_act_budgets_rec.partner_po_date := rosetta_g_miss_date_in_map(p0_a24);
2261 ddp_act_budgets_rec.partner_po_approver := p0_a25;
2263 ddp_act_budgets_rec.posted_flag := p0_a27;
2264 ddp_act_budgets_rec.justification := p0_a28;
2265 ddp_act_budgets_rec.comment := p0_a29;
2266 ddp_act_budgets_rec.parent_act_budget_id := p0_a30;
2267 ddp_act_budgets_rec.contact_id := p0_a31;
2268 ddp_act_budgets_rec.reason_code := p0_a32;
2269 ddp_act_budgets_rec.transfer_type := p0_a33;
2270 ddp_act_budgets_rec.requester_id := p0_a34;
2271 ddp_act_budgets_rec.date_required_by := rosetta_g_miss_date_in_map(p0_a35);
2272 ddp_act_budgets_rec.parent_source_id := p0_a36;
2273 ddp_act_budgets_rec.parent_src_curr := p0_a37;
2274 ddp_act_budgets_rec.parent_src_apprvd_amt := p0_a38;
2275 ddp_act_budgets_rec.partner_holding_type := p0_a39;
2276 ddp_act_budgets_rec.partner_address_id := p0_a40;
2277 ddp_act_budgets_rec.vendor_id := p0_a41;
2278 ddp_act_budgets_rec.owner_id := p0_a42;
2279 ddp_act_budgets_rec.recal_flag := p0_a43;
2280 ddp_act_budgets_rec.attribute_category := p0_a44;
2281 ddp_act_budgets_rec.attribute1 := p0_a45;
2282 ddp_act_budgets_rec.attribute2 := p0_a46;
2283 ddp_act_budgets_rec.attribute3 := p0_a47;
2284 ddp_act_budgets_rec.attribute4 := p0_a48;
2285 ddp_act_budgets_rec.attribute5 := p0_a49;
2286 ddp_act_budgets_rec.attribute6 := p0_a50;
2287 ddp_act_budgets_rec.attribute7 := p0_a51;
2288 ddp_act_budgets_rec.attribute8 := p0_a52;
2289 ddp_act_budgets_rec.attribute9 := p0_a53;
2290 ddp_act_budgets_rec.attribute10 := p0_a54;
2291 ddp_act_budgets_rec.attribute11 := p0_a55;
2292 ddp_act_budgets_rec.attribute12 := p0_a56;
2293 ddp_act_budgets_rec.attribute13 := p0_a57;
2294 ddp_act_budgets_rec.attribute14 := p0_a58;
2295 ddp_act_budgets_rec.attribute15 := p0_a59;
2296 ddp_act_budgets_rec.src_curr_req_amt := p0_a60;
2297
2298
2299
2300 -- here's the delegated call to the old PL/SQL routine
2301 ozf_actbudgets_pvt.validate_act_budgets_items(ddp_act_budgets_rec,
2302 p_validation_mode,
2303 x_return_status);
2304
2305 -- copy data back from the local variables to OUT or IN-OUT args, if any
2306
2307
2308 end;
2309
2310 procedure validate_act_budgets_record(p0_a0 NUMBER
2311 , p0_a1 DATE
2312 , p0_a2 NUMBER
2313 , p0_a3 DATE
2314 , p0_a4 NUMBER
2315 , p0_a5 NUMBER
2316 , p0_a6 NUMBER
2317 , p0_a7 NUMBER
2318 , p0_a8 VARCHAR2
2319 , p0_a9 VARCHAR2
2320 , p0_a10 NUMBER
2321 , p0_a11 VARCHAR2
2322 , p0_a12 NUMBER
2323 , p0_a13 VARCHAR2
2324 , p0_a14 DATE
2325 , p0_a15 NUMBER
2326 , p0_a16 VARCHAR2
2327 , p0_a17 NUMBER
2328 , p0_a18 NUMBER
2329 , p0_a19 VARCHAR2
2330 , p0_a20 DATE
2331 , p0_a21 NUMBER
2332 , p0_a22 NUMBER
2333 , p0_a23 VARCHAR2
2334 , p0_a24 DATE
2335 , p0_a25 VARCHAR2
2336 , p0_a26 VARCHAR2
2337 , p0_a27 VARCHAR2
2338 , p0_a28 VARCHAR
2339 , p0_a29 VARCHAR
2340 , p0_a30 NUMBER
2341 , p0_a31 NUMBER
2342 , p0_a32 VARCHAR2
2343 , p0_a33 VARCHAR2
2344 , p0_a34 NUMBER
2345 , p0_a35 DATE
2346 , p0_a36 NUMBER
2347 , p0_a37 VARCHAR2
2348 , p0_a38 NUMBER
2349 , p0_a39 VARCHAR2
2350 , p0_a40 NUMBER
2351 , p0_a41 NUMBER
2352 , p0_a42 NUMBER
2353 , p0_a43 VARCHAR2
2354 , p0_a44 VARCHAR2
2355 , p0_a45 VARCHAR2
2356 , p0_a46 VARCHAR2
2357 , p0_a47 VARCHAR2
2358 , p0_a48 VARCHAR2
2359 , p0_a49 VARCHAR2
2360 , p0_a50 VARCHAR2
2361 , p0_a51 VARCHAR2
2362 , p0_a52 VARCHAR2
2363 , p0_a53 VARCHAR2
2364 , p0_a54 VARCHAR2
2365 , p0_a55 VARCHAR2
2366 , p0_a56 VARCHAR2
2367 , p0_a57 VARCHAR2
2368 , p0_a58 VARCHAR2
2369 , p0_a59 VARCHAR2
2370 , p0_a60 NUMBER
2371 , p_validation_mode VARCHAR2
2372 , x_return_status out nocopy VARCHAR2
2373 )
2374
2375 as
2376 ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2377 ddindx binary_integer; indx binary_integer;
2378 begin
2379
2380 -- copy data to the local IN or IN-OUT args, if any
2381 ddp_act_budgets_rec.activity_budget_id := p0_a0;
2382 ddp_act_budgets_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
2383 ddp_act_budgets_rec.last_updated_by := p0_a2;
2384 ddp_act_budgets_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
2385 ddp_act_budgets_rec.created_by := p0_a4;
2386 ddp_act_budgets_rec.last_update_login := p0_a5;
2387 ddp_act_budgets_rec.object_version_number := p0_a6;
2388 ddp_act_budgets_rec.act_budget_used_by_id := p0_a7;
2389 ddp_act_budgets_rec.arc_act_budget_used_by := p0_a8;
2390 ddp_act_budgets_rec.budget_source_type := p0_a9;
2391 ddp_act_budgets_rec.budget_source_id := p0_a10;
2392 ddp_act_budgets_rec.transaction_type := p0_a11;
2393 ddp_act_budgets_rec.request_amount := p0_a12;
2394 ddp_act_budgets_rec.request_currency := p0_a13;
2395 ddp_act_budgets_rec.request_date := rosetta_g_miss_date_in_map(p0_a14);
2396 ddp_act_budgets_rec.user_status_id := p0_a15;
2397 ddp_act_budgets_rec.status_code := p0_a16;
2398 ddp_act_budgets_rec.approved_amount := p0_a17;
2399 ddp_act_budgets_rec.approved_original_amount := p0_a18;
2400 ddp_act_budgets_rec.approved_in_currency := p0_a19;
2401 ddp_act_budgets_rec.approval_date := rosetta_g_miss_date_in_map(p0_a20);
2402 ddp_act_budgets_rec.approver_id := p0_a21;
2403 ddp_act_budgets_rec.spent_amount := p0_a22;
2407 ddp_act_budgets_rec.adjusted_flag := p0_a26;
2404 ddp_act_budgets_rec.partner_po_number := p0_a23;
2405 ddp_act_budgets_rec.partner_po_date := rosetta_g_miss_date_in_map(p0_a24);
2406 ddp_act_budgets_rec.partner_po_approver := p0_a25;
2408 ddp_act_budgets_rec.posted_flag := p0_a27;
2409 ddp_act_budgets_rec.justification := p0_a28;
2410 ddp_act_budgets_rec.comment := p0_a29;
2411 ddp_act_budgets_rec.parent_act_budget_id := p0_a30;
2412 ddp_act_budgets_rec.contact_id := p0_a31;
2413 ddp_act_budgets_rec.reason_code := p0_a32;
2414 ddp_act_budgets_rec.transfer_type := p0_a33;
2415 ddp_act_budgets_rec.requester_id := p0_a34;
2416 ddp_act_budgets_rec.date_required_by := rosetta_g_miss_date_in_map(p0_a35);
2417 ddp_act_budgets_rec.parent_source_id := p0_a36;
2418 ddp_act_budgets_rec.parent_src_curr := p0_a37;
2419 ddp_act_budgets_rec.parent_src_apprvd_amt := p0_a38;
2420 ddp_act_budgets_rec.partner_holding_type := p0_a39;
2421 ddp_act_budgets_rec.partner_address_id := p0_a40;
2422 ddp_act_budgets_rec.vendor_id := p0_a41;
2423 ddp_act_budgets_rec.owner_id := p0_a42;
2424 ddp_act_budgets_rec.recal_flag := p0_a43;
2425 ddp_act_budgets_rec.attribute_category := p0_a44;
2426 ddp_act_budgets_rec.attribute1 := p0_a45;
2427 ddp_act_budgets_rec.attribute2 := p0_a46;
2428 ddp_act_budgets_rec.attribute3 := p0_a47;
2429 ddp_act_budgets_rec.attribute4 := p0_a48;
2430 ddp_act_budgets_rec.attribute5 := p0_a49;
2431 ddp_act_budgets_rec.attribute6 := p0_a50;
2432 ddp_act_budgets_rec.attribute7 := p0_a51;
2433 ddp_act_budgets_rec.attribute8 := p0_a52;
2434 ddp_act_budgets_rec.attribute9 := p0_a53;
2435 ddp_act_budgets_rec.attribute10 := p0_a54;
2436 ddp_act_budgets_rec.attribute11 := p0_a55;
2437 ddp_act_budgets_rec.attribute12 := p0_a56;
2438 ddp_act_budgets_rec.attribute13 := p0_a57;
2439 ddp_act_budgets_rec.attribute14 := p0_a58;
2440 ddp_act_budgets_rec.attribute15 := p0_a59;
2441 ddp_act_budgets_rec.src_curr_req_amt := p0_a60;
2442
2443
2444
2445 -- here's the delegated call to the old PL/SQL routine
2446 ozf_actbudgets_pvt.validate_act_budgets_record(ddp_act_budgets_rec,
2447 p_validation_mode,
2448 x_return_status);
2449
2450 -- copy data back from the local variables to OUT or IN-OUT args, if any
2451
2452
2453 end;
2454
2455 procedure complete_act_budgets_rec(p0_a0 NUMBER
2456 , p0_a1 DATE
2457 , p0_a2 NUMBER
2458 , p0_a3 DATE
2459 , p0_a4 NUMBER
2460 , p0_a5 NUMBER
2461 , p0_a6 NUMBER
2462 , p0_a7 NUMBER
2463 , p0_a8 VARCHAR2
2464 , p0_a9 VARCHAR2
2465 , p0_a10 NUMBER
2466 , p0_a11 VARCHAR2
2467 , p0_a12 NUMBER
2468 , p0_a13 VARCHAR2
2469 , p0_a14 DATE
2470 , p0_a15 NUMBER
2471 , p0_a16 VARCHAR2
2472 , p0_a17 NUMBER
2473 , p0_a18 NUMBER
2474 , p0_a19 VARCHAR2
2475 , p0_a20 DATE
2476 , p0_a21 NUMBER
2477 , p0_a22 NUMBER
2478 , p0_a23 VARCHAR2
2479 , p0_a24 DATE
2480 , p0_a25 VARCHAR2
2481 , p0_a26 VARCHAR2
2482 , p0_a27 VARCHAR2
2483 , p0_a28 VARCHAR
2484 , p0_a29 VARCHAR
2485 , p0_a30 NUMBER
2486 , p0_a31 NUMBER
2487 , p0_a32 VARCHAR2
2488 , p0_a33 VARCHAR2
2489 , p0_a34 NUMBER
2490 , p0_a35 DATE
2491 , p0_a36 NUMBER
2492 , p0_a37 VARCHAR2
2493 , p0_a38 NUMBER
2494 , p0_a39 VARCHAR2
2495 , p0_a40 NUMBER
2496 , p0_a41 NUMBER
2497 , p0_a42 NUMBER
2498 , p0_a43 VARCHAR2
2499 , p0_a44 VARCHAR2
2500 , p0_a45 VARCHAR2
2501 , p0_a46 VARCHAR2
2502 , p0_a47 VARCHAR2
2503 , p0_a48 VARCHAR2
2504 , p0_a49 VARCHAR2
2505 , p0_a50 VARCHAR2
2506 , p0_a51 VARCHAR2
2507 , p0_a52 VARCHAR2
2508 , p0_a53 VARCHAR2
2509 , p0_a54 VARCHAR2
2510 , p0_a55 VARCHAR2
2511 , p0_a56 VARCHAR2
2512 , p0_a57 VARCHAR2
2513 , p0_a58 VARCHAR2
2514 , p0_a59 VARCHAR2
2515 , p0_a60 NUMBER
2516 , p1_a0 out nocopy NUMBER
2517 , p1_a1 out nocopy DATE
2518 , p1_a2 out nocopy NUMBER
2519 , p1_a3 out nocopy DATE
2520 , p1_a4 out nocopy NUMBER
2521 , p1_a5 out nocopy NUMBER
2522 , p1_a6 out nocopy NUMBER
2523 , p1_a7 out nocopy NUMBER
2524 , p1_a8 out nocopy VARCHAR2
2525 , p1_a9 out nocopy VARCHAR2
2526 , p1_a10 out nocopy NUMBER
2527 , p1_a11 out nocopy VARCHAR2
2528 , p1_a12 out nocopy NUMBER
2529 , p1_a13 out nocopy VARCHAR2
2530 , p1_a14 out nocopy DATE
2531 , p1_a15 out nocopy NUMBER
2532 , p1_a16 out nocopy VARCHAR2
2533 , p1_a17 out nocopy NUMBER
2534 , p1_a18 out nocopy NUMBER
2535 , p1_a19 out nocopy VARCHAR2
2536 , p1_a20 out nocopy DATE
2537 , p1_a21 out nocopy NUMBER
2538 , p1_a22 out nocopy NUMBER
2539 , p1_a23 out nocopy VARCHAR2
2540 , p1_a24 out nocopy DATE
2541 , p1_a25 out nocopy VARCHAR2
2542 , p1_a26 out nocopy VARCHAR2
2543 , p1_a27 out nocopy VARCHAR2
2544 , p1_a28 out nocopy VARCHAR
2545 , p1_a29 out nocopy VARCHAR
2546 , p1_a30 out nocopy NUMBER
2547 , p1_a31 out nocopy NUMBER
2548 , p1_a32 out nocopy VARCHAR2
2549 , p1_a33 out nocopy VARCHAR2
2550 , p1_a34 out nocopy NUMBER
2551 , p1_a35 out nocopy DATE
2552 , p1_a36 out nocopy NUMBER
2553 , p1_a37 out nocopy VARCHAR2
2554 , p1_a38 out nocopy NUMBER
2555 , p1_a39 out nocopy VARCHAR2
2556 , p1_a40 out nocopy NUMBER
2557 , p1_a41 out nocopy NUMBER
2558 , p1_a42 out nocopy NUMBER
2559 , p1_a43 out nocopy VARCHAR2
2563 , p1_a47 out nocopy VARCHAR2
2560 , p1_a44 out nocopy VARCHAR2
2561 , p1_a45 out nocopy VARCHAR2
2562 , p1_a46 out nocopy VARCHAR2
2564 , p1_a48 out nocopy VARCHAR2
2565 , p1_a49 out nocopy VARCHAR2
2566 , p1_a50 out nocopy VARCHAR2
2567 , p1_a51 out nocopy VARCHAR2
2568 , p1_a52 out nocopy VARCHAR2
2569 , p1_a53 out nocopy VARCHAR2
2570 , p1_a54 out nocopy VARCHAR2
2571 , p1_a55 out nocopy VARCHAR2
2572 , p1_a56 out nocopy VARCHAR2
2573 , p1_a57 out nocopy VARCHAR2
2574 , p1_a58 out nocopy VARCHAR2
2575 , p1_a59 out nocopy VARCHAR2
2576 , p1_a60 out nocopy NUMBER
2577 )
2578
2579 as
2580 ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2581 ddx_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2582 ddindx binary_integer; indx binary_integer;
2583 begin
2584
2585 -- copy data to the local IN or IN-OUT args, if any
2586 ddp_act_budgets_rec.activity_budget_id := p0_a0;
2587 ddp_act_budgets_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
2588 ddp_act_budgets_rec.last_updated_by := p0_a2;
2589 ddp_act_budgets_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
2590 ddp_act_budgets_rec.created_by := p0_a4;
2591 ddp_act_budgets_rec.last_update_login := p0_a5;
2592 ddp_act_budgets_rec.object_version_number := p0_a6;
2593 ddp_act_budgets_rec.act_budget_used_by_id := p0_a7;
2594 ddp_act_budgets_rec.arc_act_budget_used_by := p0_a8;
2595 ddp_act_budgets_rec.budget_source_type := p0_a9;
2596 ddp_act_budgets_rec.budget_source_id := p0_a10;
2597 ddp_act_budgets_rec.transaction_type := p0_a11;
2598 ddp_act_budgets_rec.request_amount := p0_a12;
2599 ddp_act_budgets_rec.request_currency := p0_a13;
2600 ddp_act_budgets_rec.request_date := rosetta_g_miss_date_in_map(p0_a14);
2601 ddp_act_budgets_rec.user_status_id := p0_a15;
2602 ddp_act_budgets_rec.status_code := p0_a16;
2603 ddp_act_budgets_rec.approved_amount := p0_a17;
2604 ddp_act_budgets_rec.approved_original_amount := p0_a18;
2605 ddp_act_budgets_rec.approved_in_currency := p0_a19;
2606 ddp_act_budgets_rec.approval_date := rosetta_g_miss_date_in_map(p0_a20);
2607 ddp_act_budgets_rec.approver_id := p0_a21;
2608 ddp_act_budgets_rec.spent_amount := p0_a22;
2609 ddp_act_budgets_rec.partner_po_number := p0_a23;
2610 ddp_act_budgets_rec.partner_po_date := rosetta_g_miss_date_in_map(p0_a24);
2611 ddp_act_budgets_rec.partner_po_approver := p0_a25;
2612 ddp_act_budgets_rec.adjusted_flag := p0_a26;
2613 ddp_act_budgets_rec.posted_flag := p0_a27;
2614 ddp_act_budgets_rec.justification := p0_a28;
2615 ddp_act_budgets_rec.comment := p0_a29;
2616 ddp_act_budgets_rec.parent_act_budget_id := p0_a30;
2617 ddp_act_budgets_rec.contact_id := p0_a31;
2618 ddp_act_budgets_rec.reason_code := p0_a32;
2619 ddp_act_budgets_rec.transfer_type := p0_a33;
2620 ddp_act_budgets_rec.requester_id := p0_a34;
2621 ddp_act_budgets_rec.date_required_by := rosetta_g_miss_date_in_map(p0_a35);
2622 ddp_act_budgets_rec.parent_source_id := p0_a36;
2623 ddp_act_budgets_rec.parent_src_curr := p0_a37;
2624 ddp_act_budgets_rec.parent_src_apprvd_amt := p0_a38;
2625 ddp_act_budgets_rec.partner_holding_type := p0_a39;
2626 ddp_act_budgets_rec.partner_address_id := p0_a40;
2627 ddp_act_budgets_rec.vendor_id := p0_a41;
2628 ddp_act_budgets_rec.owner_id := p0_a42;
2629 ddp_act_budgets_rec.recal_flag := p0_a43;
2630 ddp_act_budgets_rec.attribute_category := p0_a44;
2631 ddp_act_budgets_rec.attribute1 := p0_a45;
2632 ddp_act_budgets_rec.attribute2 := p0_a46;
2633 ddp_act_budgets_rec.attribute3 := p0_a47;
2634 ddp_act_budgets_rec.attribute4 := p0_a48;
2635 ddp_act_budgets_rec.attribute5 := p0_a49;
2636 ddp_act_budgets_rec.attribute6 := p0_a50;
2637 ddp_act_budgets_rec.attribute7 := p0_a51;
2638 ddp_act_budgets_rec.attribute8 := p0_a52;
2639 ddp_act_budgets_rec.attribute9 := p0_a53;
2640 ddp_act_budgets_rec.attribute10 := p0_a54;
2641 ddp_act_budgets_rec.attribute11 := p0_a55;
2642 ddp_act_budgets_rec.attribute12 := p0_a56;
2643 ddp_act_budgets_rec.attribute13 := p0_a57;
2644 ddp_act_budgets_rec.attribute14 := p0_a58;
2645 ddp_act_budgets_rec.attribute15 := p0_a59;
2646 ddp_act_budgets_rec.src_curr_req_amt := p0_a60;
2647
2648
2649 -- here's the delegated call to the old PL/SQL routine
2650 ozf_actbudgets_pvt.complete_act_budgets_rec(ddp_act_budgets_rec,
2651 ddx_act_budgets_rec);
2652
2653 -- copy data back from the local variables to OUT or IN-OUT args, if any
2654
2655 p1_a0 := ddx_act_budgets_rec.activity_budget_id;
2656 p1_a1 := ddx_act_budgets_rec.last_update_date;
2657 p1_a2 := ddx_act_budgets_rec.last_updated_by;
2658 p1_a3 := ddx_act_budgets_rec.creation_date;
2659 p1_a4 := ddx_act_budgets_rec.created_by;
2660 p1_a5 := ddx_act_budgets_rec.last_update_login;
2661 p1_a6 := ddx_act_budgets_rec.object_version_number;
2662 p1_a7 := ddx_act_budgets_rec.act_budget_used_by_id;
2663 p1_a8 := ddx_act_budgets_rec.arc_act_budget_used_by;
2664 p1_a9 := ddx_act_budgets_rec.budget_source_type;
2665 p1_a10 := ddx_act_budgets_rec.budget_source_id;
2666 p1_a11 := ddx_act_budgets_rec.transaction_type;
2667 p1_a12 := ddx_act_budgets_rec.request_amount;
2668 p1_a13 := ddx_act_budgets_rec.request_currency;
2669 p1_a14 := ddx_act_budgets_rec.request_date;
2670 p1_a15 := ddx_act_budgets_rec.user_status_id;
2671 p1_a16 := ddx_act_budgets_rec.status_code;
2672 p1_a17 := ddx_act_budgets_rec.approved_amount;
2673 p1_a18 := ddx_act_budgets_rec.approved_original_amount;
2674 p1_a19 := ddx_act_budgets_rec.approved_in_currency;
2675 p1_a20 := ddx_act_budgets_rec.approval_date;
2676 p1_a21 := ddx_act_budgets_rec.approver_id;
2677 p1_a22 := ddx_act_budgets_rec.spent_amount;
2678 p1_a23 := ddx_act_budgets_rec.partner_po_number;
2682 p1_a27 := ddx_act_budgets_rec.posted_flag;
2679 p1_a24 := ddx_act_budgets_rec.partner_po_date;
2680 p1_a25 := ddx_act_budgets_rec.partner_po_approver;
2681 p1_a26 := ddx_act_budgets_rec.adjusted_flag;
2683 p1_a28 := ddx_act_budgets_rec.justification;
2684 p1_a29 := ddx_act_budgets_rec.comment;
2685 p1_a30 := ddx_act_budgets_rec.parent_act_budget_id;
2686 p1_a31 := ddx_act_budgets_rec.contact_id;
2687 p1_a32 := ddx_act_budgets_rec.reason_code;
2688 p1_a33 := ddx_act_budgets_rec.transfer_type;
2689 p1_a34 := ddx_act_budgets_rec.requester_id;
2690 p1_a35 := ddx_act_budgets_rec.date_required_by;
2691 p1_a36 := ddx_act_budgets_rec.parent_source_id;
2692 p1_a37 := ddx_act_budgets_rec.parent_src_curr;
2693 p1_a38 := ddx_act_budgets_rec.parent_src_apprvd_amt;
2694 p1_a39 := ddx_act_budgets_rec.partner_holding_type;
2695 p1_a40 := ddx_act_budgets_rec.partner_address_id;
2696 p1_a41 := ddx_act_budgets_rec.vendor_id;
2697 p1_a42 := ddx_act_budgets_rec.owner_id;
2698 p1_a43 := ddx_act_budgets_rec.recal_flag;
2699 p1_a44 := ddx_act_budgets_rec.attribute_category;
2700 p1_a45 := ddx_act_budgets_rec.attribute1;
2701 p1_a46 := ddx_act_budgets_rec.attribute2;
2702 p1_a47 := ddx_act_budgets_rec.attribute3;
2703 p1_a48 := ddx_act_budgets_rec.attribute4;
2704 p1_a49 := ddx_act_budgets_rec.attribute5;
2705 p1_a50 := ddx_act_budgets_rec.attribute6;
2706 p1_a51 := ddx_act_budgets_rec.attribute7;
2707 p1_a52 := ddx_act_budgets_rec.attribute8;
2708 p1_a53 := ddx_act_budgets_rec.attribute9;
2709 p1_a54 := ddx_act_budgets_rec.attribute10;
2710 p1_a55 := ddx_act_budgets_rec.attribute11;
2711 p1_a56 := ddx_act_budgets_rec.attribute12;
2712 p1_a57 := ddx_act_budgets_rec.attribute13;
2713 p1_a58 := ddx_act_budgets_rec.attribute14;
2714 p1_a59 := ddx_act_budgets_rec.attribute15;
2715 p1_a60 := ddx_act_budgets_rec.src_curr_req_amt;
2716 end;
2717
2718 procedure init_act_budgets_rec(p0_a0 out nocopy NUMBER
2719 , p0_a1 out nocopy DATE
2720 , p0_a2 out nocopy NUMBER
2721 , p0_a3 out nocopy DATE
2722 , p0_a4 out nocopy NUMBER
2723 , p0_a5 out nocopy NUMBER
2724 , p0_a6 out nocopy NUMBER
2725 , p0_a7 out nocopy NUMBER
2726 , p0_a8 out nocopy VARCHAR2
2727 , p0_a9 out nocopy VARCHAR2
2728 , p0_a10 out nocopy NUMBER
2729 , p0_a11 out nocopy VARCHAR2
2730 , p0_a12 out nocopy NUMBER
2731 , p0_a13 out nocopy VARCHAR2
2732 , p0_a14 out nocopy DATE
2733 , p0_a15 out nocopy NUMBER
2734 , p0_a16 out nocopy VARCHAR2
2735 , p0_a17 out nocopy NUMBER
2736 , p0_a18 out nocopy NUMBER
2737 , p0_a19 out nocopy VARCHAR2
2738 , p0_a20 out nocopy DATE
2739 , p0_a21 out nocopy NUMBER
2740 , p0_a22 out nocopy NUMBER
2741 , p0_a23 out nocopy VARCHAR2
2742 , p0_a24 out nocopy DATE
2743 , p0_a25 out nocopy VARCHAR2
2744 , p0_a26 out nocopy VARCHAR2
2745 , p0_a27 out nocopy VARCHAR2
2746 , p0_a28 out nocopy VARCHAR
2747 , p0_a29 out nocopy VARCHAR
2748 , p0_a30 out nocopy NUMBER
2749 , p0_a31 out nocopy NUMBER
2750 , p0_a32 out nocopy VARCHAR2
2751 , p0_a33 out nocopy VARCHAR2
2752 , p0_a34 out nocopy NUMBER
2753 , p0_a35 out nocopy DATE
2754 , p0_a36 out nocopy NUMBER
2755 , p0_a37 out nocopy VARCHAR2
2756 , p0_a38 out nocopy NUMBER
2757 , p0_a39 out nocopy VARCHAR2
2758 , p0_a40 out nocopy NUMBER
2759 , p0_a41 out nocopy NUMBER
2760 , p0_a42 out nocopy NUMBER
2761 , p0_a43 out nocopy VARCHAR2
2762 , p0_a44 out nocopy VARCHAR2
2763 , p0_a45 out nocopy VARCHAR2
2764 , p0_a46 out nocopy VARCHAR2
2765 , p0_a47 out nocopy VARCHAR2
2766 , p0_a48 out nocopy VARCHAR2
2767 , p0_a49 out nocopy VARCHAR2
2768 , p0_a50 out nocopy VARCHAR2
2769 , p0_a51 out nocopy VARCHAR2
2770 , p0_a52 out nocopy VARCHAR2
2771 , p0_a53 out nocopy VARCHAR2
2772 , p0_a54 out nocopy VARCHAR2
2773 , p0_a55 out nocopy VARCHAR2
2774 , p0_a56 out nocopy VARCHAR2
2775 , p0_a57 out nocopy VARCHAR2
2776 , p0_a58 out nocopy VARCHAR2
2777 , p0_a59 out nocopy VARCHAR2
2778 , p0_a60 out nocopy NUMBER
2779 )
2780
2781 as
2782 ddx_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2783 ddindx binary_integer; indx binary_integer;
2784 begin
2785
2786 -- copy data to the local IN or IN-OUT args, if any
2787
2788 -- here's the delegated call to the old PL/SQL routine
2789 ozf_actbudgets_pvt.init_act_budgets_rec(ddx_act_budgets_rec);
2790
2791 -- copy data back from the local variables to OUT or IN-OUT args, if any
2792 p0_a0 := ddx_act_budgets_rec.activity_budget_id;
2793 p0_a1 := ddx_act_budgets_rec.last_update_date;
2794 p0_a2 := ddx_act_budgets_rec.last_updated_by;
2795 p0_a3 := ddx_act_budgets_rec.creation_date;
2796 p0_a4 := ddx_act_budgets_rec.created_by;
2797 p0_a5 := ddx_act_budgets_rec.last_update_login;
2798 p0_a6 := ddx_act_budgets_rec.object_version_number;
2799 p0_a7 := ddx_act_budgets_rec.act_budget_used_by_id;
2800 p0_a8 := ddx_act_budgets_rec.arc_act_budget_used_by;
2801 p0_a9 := ddx_act_budgets_rec.budget_source_type;
2802 p0_a10 := ddx_act_budgets_rec.budget_source_id;
2803 p0_a11 := ddx_act_budgets_rec.transaction_type;
2804 p0_a12 := ddx_act_budgets_rec.request_amount;
2805 p0_a13 := ddx_act_budgets_rec.request_currency;
2806 p0_a14 := ddx_act_budgets_rec.request_date;
2807 p0_a15 := ddx_act_budgets_rec.user_status_id;
2808 p0_a16 := ddx_act_budgets_rec.status_code;
2809 p0_a17 := ddx_act_budgets_rec.approved_amount;
2810 p0_a18 := ddx_act_budgets_rec.approved_original_amount;
2811 p0_a19 := ddx_act_budgets_rec.approved_in_currency;
2815 p0_a23 := ddx_act_budgets_rec.partner_po_number;
2812 p0_a20 := ddx_act_budgets_rec.approval_date;
2813 p0_a21 := ddx_act_budgets_rec.approver_id;
2814 p0_a22 := ddx_act_budgets_rec.spent_amount;
2816 p0_a24 := ddx_act_budgets_rec.partner_po_date;
2817 p0_a25 := ddx_act_budgets_rec.partner_po_approver;
2818 p0_a26 := ddx_act_budgets_rec.adjusted_flag;
2819 p0_a27 := ddx_act_budgets_rec.posted_flag;
2820 p0_a28 := ddx_act_budgets_rec.justification;
2821 p0_a29 := ddx_act_budgets_rec.comment;
2822 p0_a30 := ddx_act_budgets_rec.parent_act_budget_id;
2823 p0_a31 := ddx_act_budgets_rec.contact_id;
2824 p0_a32 := ddx_act_budgets_rec.reason_code;
2825 p0_a33 := ddx_act_budgets_rec.transfer_type;
2826 p0_a34 := ddx_act_budgets_rec.requester_id;
2827 p0_a35 := ddx_act_budgets_rec.date_required_by;
2828 p0_a36 := ddx_act_budgets_rec.parent_source_id;
2829 p0_a37 := ddx_act_budgets_rec.parent_src_curr;
2830 p0_a38 := ddx_act_budgets_rec.parent_src_apprvd_amt;
2831 p0_a39 := ddx_act_budgets_rec.partner_holding_type;
2832 p0_a40 := ddx_act_budgets_rec.partner_address_id;
2833 p0_a41 := ddx_act_budgets_rec.vendor_id;
2834 p0_a42 := ddx_act_budgets_rec.owner_id;
2835 p0_a43 := ddx_act_budgets_rec.recal_flag;
2836 p0_a44 := ddx_act_budgets_rec.attribute_category;
2837 p0_a45 := ddx_act_budgets_rec.attribute1;
2838 p0_a46 := ddx_act_budgets_rec.attribute2;
2839 p0_a47 := ddx_act_budgets_rec.attribute3;
2840 p0_a48 := ddx_act_budgets_rec.attribute4;
2841 p0_a49 := ddx_act_budgets_rec.attribute5;
2842 p0_a50 := ddx_act_budgets_rec.attribute6;
2843 p0_a51 := ddx_act_budgets_rec.attribute7;
2844 p0_a52 := ddx_act_budgets_rec.attribute8;
2845 p0_a53 := ddx_act_budgets_rec.attribute9;
2846 p0_a54 := ddx_act_budgets_rec.attribute10;
2847 p0_a55 := ddx_act_budgets_rec.attribute11;
2848 p0_a56 := ddx_act_budgets_rec.attribute12;
2849 p0_a57 := ddx_act_budgets_rec.attribute13;
2850 p0_a58 := ddx_act_budgets_rec.attribute14;
2851 p0_a59 := ddx_act_budgets_rec.attribute15;
2852 p0_a60 := ddx_act_budgets_rec.src_curr_req_amt;
2853 end;
2854
2855 procedure create_child_act_budget(x_return_status out nocopy VARCHAR2
2856 , x_msg_count out nocopy NUMBER
2857 , x_msg_data out nocopy VARCHAR2
2858 , p3_a0 NUMBER
2859 , p3_a1 DATE
2860 , p3_a2 NUMBER
2861 , p3_a3 DATE
2862 , p3_a4 NUMBER
2863 , p3_a5 NUMBER
2864 , p3_a6 NUMBER
2865 , p3_a7 NUMBER
2866 , p3_a8 VARCHAR2
2867 , p3_a9 VARCHAR2
2868 , p3_a10 NUMBER
2869 , p3_a11 VARCHAR2
2870 , p3_a12 NUMBER
2871 , p3_a13 VARCHAR2
2872 , p3_a14 DATE
2873 , p3_a15 NUMBER
2874 , p3_a16 VARCHAR2
2875 , p3_a17 NUMBER
2876 , p3_a18 NUMBER
2877 , p3_a19 VARCHAR2
2878 , p3_a20 DATE
2879 , p3_a21 NUMBER
2880 , p3_a22 NUMBER
2881 , p3_a23 VARCHAR2
2882 , p3_a24 DATE
2883 , p3_a25 VARCHAR2
2884 , p3_a26 VARCHAR2
2885 , p3_a27 VARCHAR2
2886 , p3_a28 VARCHAR
2887 , p3_a29 VARCHAR
2888 , p3_a30 NUMBER
2889 , p3_a31 NUMBER
2890 , p3_a32 VARCHAR2
2891 , p3_a33 VARCHAR2
2892 , p3_a34 NUMBER
2893 , p3_a35 DATE
2894 , p3_a36 NUMBER
2895 , p3_a37 VARCHAR2
2896 , p3_a38 NUMBER
2897 , p3_a39 VARCHAR2
2898 , p3_a40 NUMBER
2899 , p3_a41 NUMBER
2900 , p3_a42 NUMBER
2901 , p3_a43 VARCHAR2
2902 , p3_a44 VARCHAR2
2903 , p3_a45 VARCHAR2
2904 , p3_a46 VARCHAR2
2905 , p3_a47 VARCHAR2
2906 , p3_a48 VARCHAR2
2907 , p3_a49 VARCHAR2
2908 , p3_a50 VARCHAR2
2909 , p3_a51 VARCHAR2
2910 , p3_a52 VARCHAR2
2911 , p3_a53 VARCHAR2
2912 , p3_a54 VARCHAR2
2913 , p3_a55 VARCHAR2
2914 , p3_a56 VARCHAR2
2915 , p3_a57 VARCHAR2
2916 , p3_a58 VARCHAR2
2917 , p3_a59 VARCHAR2
2918 , p3_a60 NUMBER
2919 , p_exchange_rate_type VARCHAR2
2920 )
2921
2922 as
2923 ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2924 ddindx binary_integer; indx binary_integer;
2925 begin
2926
2927 -- copy data to the local IN or IN-OUT args, if any
2928
2929
2930
2931 ddp_act_budgets_rec.activity_budget_id := p3_a0;
2932 ddp_act_budgets_rec.last_update_date := rosetta_g_miss_date_in_map(p3_a1);
2933 ddp_act_budgets_rec.last_updated_by := p3_a2;
2934 ddp_act_budgets_rec.creation_date := rosetta_g_miss_date_in_map(p3_a3);
2935 ddp_act_budgets_rec.created_by := p3_a4;
2936 ddp_act_budgets_rec.last_update_login := p3_a5;
2937 ddp_act_budgets_rec.object_version_number := p3_a6;
2938 ddp_act_budgets_rec.act_budget_used_by_id := p3_a7;
2939 ddp_act_budgets_rec.arc_act_budget_used_by := p3_a8;
2940 ddp_act_budgets_rec.budget_source_type := p3_a9;
2941 ddp_act_budgets_rec.budget_source_id := p3_a10;
2942 ddp_act_budgets_rec.transaction_type := p3_a11;
2943 ddp_act_budgets_rec.request_amount := p3_a12;
2944 ddp_act_budgets_rec.request_currency := p3_a13;
2945 ddp_act_budgets_rec.request_date := rosetta_g_miss_date_in_map(p3_a14);
2946 ddp_act_budgets_rec.user_status_id := p3_a15;
2947 ddp_act_budgets_rec.status_code := p3_a16;
2948 ddp_act_budgets_rec.approved_amount := p3_a17;
2949 ddp_act_budgets_rec.approved_original_amount := p3_a18;
2950 ddp_act_budgets_rec.approved_in_currency := p3_a19;
2951 ddp_act_budgets_rec.approval_date := rosetta_g_miss_date_in_map(p3_a20);
2952 ddp_act_budgets_rec.approver_id := p3_a21;
2953 ddp_act_budgets_rec.spent_amount := p3_a22;
2954 ddp_act_budgets_rec.partner_po_number := p3_a23;
2955 ddp_act_budgets_rec.partner_po_date := rosetta_g_miss_date_in_map(p3_a24);
2959 ddp_act_budgets_rec.justification := p3_a28;
2956 ddp_act_budgets_rec.partner_po_approver := p3_a25;
2957 ddp_act_budgets_rec.adjusted_flag := p3_a26;
2958 ddp_act_budgets_rec.posted_flag := p3_a27;
2960 ddp_act_budgets_rec.comment := p3_a29;
2961 ddp_act_budgets_rec.parent_act_budget_id := p3_a30;
2962 ddp_act_budgets_rec.contact_id := p3_a31;
2963 ddp_act_budgets_rec.reason_code := p3_a32;
2964 ddp_act_budgets_rec.transfer_type := p3_a33;
2965 ddp_act_budgets_rec.requester_id := p3_a34;
2966 ddp_act_budgets_rec.date_required_by := rosetta_g_miss_date_in_map(p3_a35);
2967 ddp_act_budgets_rec.parent_source_id := p3_a36;
2968 ddp_act_budgets_rec.parent_src_curr := p3_a37;
2969 ddp_act_budgets_rec.parent_src_apprvd_amt := p3_a38;
2970 ddp_act_budgets_rec.partner_holding_type := p3_a39;
2971 ddp_act_budgets_rec.partner_address_id := p3_a40;
2972 ddp_act_budgets_rec.vendor_id := p3_a41;
2973 ddp_act_budgets_rec.owner_id := p3_a42;
2974 ddp_act_budgets_rec.recal_flag := p3_a43;
2975 ddp_act_budgets_rec.attribute_category := p3_a44;
2976 ddp_act_budgets_rec.attribute1 := p3_a45;
2977 ddp_act_budgets_rec.attribute2 := p3_a46;
2978 ddp_act_budgets_rec.attribute3 := p3_a47;
2979 ddp_act_budgets_rec.attribute4 := p3_a48;
2980 ddp_act_budgets_rec.attribute5 := p3_a49;
2981 ddp_act_budgets_rec.attribute6 := p3_a50;
2982 ddp_act_budgets_rec.attribute7 := p3_a51;
2983 ddp_act_budgets_rec.attribute8 := p3_a52;
2984 ddp_act_budgets_rec.attribute9 := p3_a53;
2985 ddp_act_budgets_rec.attribute10 := p3_a54;
2986 ddp_act_budgets_rec.attribute11 := p3_a55;
2987 ddp_act_budgets_rec.attribute12 := p3_a56;
2988 ddp_act_budgets_rec.attribute13 := p3_a57;
2989 ddp_act_budgets_rec.attribute14 := p3_a58;
2990 ddp_act_budgets_rec.attribute15 := p3_a59;
2991 ddp_act_budgets_rec.src_curr_req_amt := p3_a60;
2992
2993
2994 -- here's the delegated call to the old PL/SQL routine
2995 ozf_actbudgets_pvt.create_child_act_budget(x_return_status,
2996 x_msg_count,
2997 x_msg_data,
2998 ddp_act_budgets_rec,
2999 p_exchange_rate_type);
3000
3001 -- copy data back from the local variables to OUT or IN-OUT args, if any
3002
3003
3004
3005
3006 end;
3007
3008 end ozf_actbudgets_pvt_w;