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