[Home] [Help]
PACKAGE BODY: APPS.OZF_FUND_ALLOCATIONS_PVT_W
Source
1 package body ozf_fund_allocations_pvt_w as
2 /* $Header: ozfwalcb.pls 115.3 2003/10/01 09:57:05 kdass noship $ */
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
6 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7 function rosetta_g_miss_date_in_map(d date) return date as
8 begin
9 if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10 return d;
11 end;
12
13 function rosetta_g_miss_num_map(n number) return number as
14 a number := fnd_api.g_miss_num;
15 b number := 0-1962.0724;
16 begin
17 if n=a then return b; end if;
18 if n=b then return a; end if;
19 return n;
20 end;
21
22 procedure rosetta_table_copy_in_p0(t out nocopy ozf_fund_allocations_pvt.fact_table_type, a0 JTF_NUMBER_TABLE
23 , a1 JTF_DATE_TABLE
24 , a2 JTF_NUMBER_TABLE
25 , a3 JTF_DATE_TABLE
26 , a4 JTF_NUMBER_TABLE
27 , a5 JTF_NUMBER_TABLE
28 , a6 JTF_NUMBER_TABLE
29 , a7 JTF_NUMBER_TABLE
30 , a8 JTF_VARCHAR2_TABLE_100
31 , a9 JTF_VARCHAR2_TABLE_100
32 , a10 JTF_NUMBER_TABLE
33 , a11 JTF_NUMBER_TABLE
34 , a12 JTF_NUMBER_TABLE
35 , a13 JTF_VARCHAR2_TABLE_100
36 , a14 JTF_NUMBER_TABLE
37 , a15 JTF_NUMBER_TABLE
38 , a16 JTF_VARCHAR2_TABLE_100
39 , a17 JTF_NUMBER_TABLE
40 , a18 JTF_NUMBER_TABLE
41 , a19 JTF_NUMBER_TABLE
42 , a20 JTF_NUMBER_TABLE
43 , a21 JTF_VARCHAR2_TABLE_100
44 , a22 JTF_NUMBER_TABLE
45 , a23 JTF_NUMBER_TABLE
46 , a24 JTF_NUMBER_TABLE
47 , a25 JTF_NUMBER_TABLE
48 , a26 JTF_NUMBER_TABLE
49 , a27 JTF_NUMBER_TABLE
50 , a28 JTF_NUMBER_TABLE
51 , a29 JTF_NUMBER_TABLE
52 , a30 JTF_NUMBER_TABLE
53 , a31 JTF_NUMBER_TABLE
54 , a32 JTF_NUMBER_TABLE
55 , a33 JTF_NUMBER_TABLE
56 , a34 JTF_NUMBER_TABLE
57 , a35 JTF_NUMBER_TABLE
58 , a36 JTF_NUMBER_TABLE
59 , a37 JTF_NUMBER_TABLE
60 , a38 JTF_NUMBER_TABLE
61 , a39 JTF_NUMBER_TABLE
62 , a40 JTF_NUMBER_TABLE
63 , a41 JTF_NUMBER_TABLE
64 , a42 JTF_NUMBER_TABLE
65 , a43 JTF_NUMBER_TABLE
66 , a44 JTF_NUMBER_TABLE
67 , a45 JTF_NUMBER_TABLE
68 , a46 JTF_NUMBER_TABLE
69 , a47 JTF_NUMBER_TABLE
70 , a48 JTF_NUMBER_TABLE
71 , a49 JTF_NUMBER_TABLE
72 , a50 JTF_NUMBER_TABLE
73 , a51 JTF_NUMBER_TABLE
74 , a52 JTF_NUMBER_TABLE
75 , a53 JTF_NUMBER_TABLE
76 , a54 JTF_NUMBER_TABLE
77 , a55 JTF_NUMBER_TABLE
78 , a56 JTF_NUMBER_TABLE
79 , a57 JTF_NUMBER_TABLE
80 , a58 JTF_NUMBER_TABLE
81 , a59 JTF_NUMBER_TABLE
82 , a60 JTF_NUMBER_TABLE
83 , a61 JTF_NUMBER_TABLE
84 , a62 JTF_NUMBER_TABLE
85 , a63 JTF_NUMBER_TABLE
86 , a64 JTF_NUMBER_TABLE
87 , a65 JTF_NUMBER_TABLE
88 , a66 JTF_NUMBER_TABLE
89 , a67 JTF_NUMBER_TABLE
90 , a68 JTF_NUMBER_TABLE
91 , a69 JTF_NUMBER_TABLE
92 , a70 JTF_NUMBER_TABLE
93 , a71 JTF_NUMBER_TABLE
94 , a72 JTF_NUMBER_TABLE
95 , a73 JTF_NUMBER_TABLE
96 , a74 JTF_NUMBER_TABLE
97 , a75 JTF_NUMBER_TABLE
98 , a76 JTF_NUMBER_TABLE
99 , a77 JTF_NUMBER_TABLE
100 , a78 JTF_NUMBER_TABLE
101 , a79 JTF_NUMBER_TABLE
102 , a80 JTF_NUMBER_TABLE
103 , a81 JTF_DATE_TABLE
104 , a82 JTF_DATE_TABLE
105 , a83 JTF_NUMBER_TABLE
106 , a84 JTF_NUMBER_TABLE
107 , a85 JTF_NUMBER_TABLE
108 , a86 JTF_NUMBER_TABLE
109 , a87 JTF_VARCHAR2_TABLE_100
110 , a88 JTF_VARCHAR2_TABLE_300
111 , a89 JTF_NUMBER_TABLE
112 , a90 JTF_VARCHAR2_TABLE_100
113 , a91 JTF_VARCHAR2_TABLE_100
114 , a92 JTF_DATE_TABLE
115 , a93 JTF_NUMBER_TABLE
116 , a94 JTF_NUMBER_TABLE
117 , a95 JTF_NUMBER_TABLE
118 , a96 JTF_NUMBER_TABLE
119 , a97 JTF_NUMBER_TABLE
120 , a98 JTF_NUMBER_TABLE
121 , a99 JTF_NUMBER_TABLE
122 , a100 JTF_NUMBER_TABLE
123 ) as
124 ddindx binary_integer; indx binary_integer;
125 begin
126 if a0 is not null and a0.count > 0 then
127 if a0.count > 0 then
128 indx := a0.first;
129 ddindx := 1;
130 while true loop
131 t(ddindx).activity_metric_fact_id := rosetta_g_miss_num_map(a0(indx));
132 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a1(indx));
133 t(ddindx).last_updated_by := rosetta_g_miss_num_map(a2(indx));
134 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a3(indx));
135 t(ddindx).created_by := rosetta_g_miss_num_map(a4(indx));
136 t(ddindx).last_update_login := rosetta_g_miss_num_map(a5(indx));
137 t(ddindx).object_version_number := rosetta_g_miss_num_map(a6(indx));
138 t(ddindx).act_metric_used_by_id := rosetta_g_miss_num_map(a7(indx));
139 t(ddindx).arc_act_metric_used_by := a8(indx);
140 t(ddindx).value_type := a9(indx);
141 t(ddindx).activity_metric_id := rosetta_g_miss_num_map(a10(indx));
142 t(ddindx).activity_geo_area_id := rosetta_g_miss_num_map(a11(indx));
143 t(ddindx).activity_product_id := rosetta_g_miss_num_map(a12(indx));
144 t(ddindx).transaction_currency_code := a13(indx);
145 t(ddindx).trans_forecasted_value := rosetta_g_miss_num_map(a14(indx));
146 t(ddindx).base_quantity := rosetta_g_miss_num_map(a15(indx));
147 t(ddindx).functional_currency_code := a16(indx);
148 t(ddindx).func_forecasted_value := rosetta_g_miss_num_map(a17(indx));
149 t(ddindx).org_id := rosetta_g_miss_num_map(a18(indx));
150 t(ddindx).de_metric_id := rosetta_g_miss_num_map(a19(indx));
151 t(ddindx).de_geographic_area_id := rosetta_g_miss_num_map(a20(indx));
152 t(ddindx).de_geographic_area_type := a21(indx);
153 t(ddindx).de_inventory_item_id := rosetta_g_miss_num_map(a22(indx));
154 t(ddindx).de_inventory_item_org_id := rosetta_g_miss_num_map(a23(indx));
155 t(ddindx).time_id1 := rosetta_g_miss_num_map(a24(indx));
156 t(ddindx).time_id2 := rosetta_g_miss_num_map(a25(indx));
157 t(ddindx).time_id3 := rosetta_g_miss_num_map(a26(indx));
158 t(ddindx).time_id4 := rosetta_g_miss_num_map(a27(indx));
159 t(ddindx).time_id5 := rosetta_g_miss_num_map(a28(indx));
160 t(ddindx).time_id6 := rosetta_g_miss_num_map(a29(indx));
161 t(ddindx).time_id7 := rosetta_g_miss_num_map(a30(indx));
162 t(ddindx).time_id8 := rosetta_g_miss_num_map(a31(indx));
163 t(ddindx).time_id9 := rosetta_g_miss_num_map(a32(indx));
164 t(ddindx).time_id10 := rosetta_g_miss_num_map(a33(indx));
165 t(ddindx).time_id11 := rosetta_g_miss_num_map(a34(indx));
166 t(ddindx).time_id12 := rosetta_g_miss_num_map(a35(indx));
167 t(ddindx).time_id13 := rosetta_g_miss_num_map(a36(indx));
168 t(ddindx).time_id14 := rosetta_g_miss_num_map(a37(indx));
169 t(ddindx).time_id15 := rosetta_g_miss_num_map(a38(indx));
170 t(ddindx).time_id16 := rosetta_g_miss_num_map(a39(indx));
171 t(ddindx).time_id17 := rosetta_g_miss_num_map(a40(indx));
172 t(ddindx).time_id18 := rosetta_g_miss_num_map(a41(indx));
173 t(ddindx).time_id19 := rosetta_g_miss_num_map(a42(indx));
174 t(ddindx).time_id20 := rosetta_g_miss_num_map(a43(indx));
175 t(ddindx).time_id21 := rosetta_g_miss_num_map(a44(indx));
176 t(ddindx).time_id22 := rosetta_g_miss_num_map(a45(indx));
177 t(ddindx).time_id23 := rosetta_g_miss_num_map(a46(indx));
178 t(ddindx).time_id24 := rosetta_g_miss_num_map(a47(indx));
179 t(ddindx).time_id25 := rosetta_g_miss_num_map(a48(indx));
180 t(ddindx).time_id26 := rosetta_g_miss_num_map(a49(indx));
181 t(ddindx).time_id27 := rosetta_g_miss_num_map(a50(indx));
182 t(ddindx).time_id28 := rosetta_g_miss_num_map(a51(indx));
183 t(ddindx).time_id29 := rosetta_g_miss_num_map(a52(indx));
184 t(ddindx).time_id30 := rosetta_g_miss_num_map(a53(indx));
185 t(ddindx).time_id31 := rosetta_g_miss_num_map(a54(indx));
186 t(ddindx).time_id32 := rosetta_g_miss_num_map(a55(indx));
187 t(ddindx).time_id33 := rosetta_g_miss_num_map(a56(indx));
188 t(ddindx).time_id34 := rosetta_g_miss_num_map(a57(indx));
189 t(ddindx).time_id35 := rosetta_g_miss_num_map(a58(indx));
190 t(ddindx).time_id36 := rosetta_g_miss_num_map(a59(indx));
191 t(ddindx).time_id37 := rosetta_g_miss_num_map(a60(indx));
192 t(ddindx).time_id38 := rosetta_g_miss_num_map(a61(indx));
193 t(ddindx).time_id39 := rosetta_g_miss_num_map(a62(indx));
194 t(ddindx).time_id40 := rosetta_g_miss_num_map(a63(indx));
195 t(ddindx).time_id41 := rosetta_g_miss_num_map(a64(indx));
196 t(ddindx).time_id42 := rosetta_g_miss_num_map(a65(indx));
197 t(ddindx).time_id43 := rosetta_g_miss_num_map(a66(indx));
198 t(ddindx).time_id44 := rosetta_g_miss_num_map(a67(indx));
199 t(ddindx).time_id45 := rosetta_g_miss_num_map(a68(indx));
200 t(ddindx).time_id46 := rosetta_g_miss_num_map(a69(indx));
201 t(ddindx).time_id47 := rosetta_g_miss_num_map(a70(indx));
202 t(ddindx).time_id48 := rosetta_g_miss_num_map(a71(indx));
203 t(ddindx).time_id49 := rosetta_g_miss_num_map(a72(indx));
204 t(ddindx).time_id50 := rosetta_g_miss_num_map(a73(indx));
205 t(ddindx).time_id51 := rosetta_g_miss_num_map(a74(indx));
206 t(ddindx).time_id52 := rosetta_g_miss_num_map(a75(indx));
207 t(ddindx).time_id53 := rosetta_g_miss_num_map(a76(indx));
208 t(ddindx).hierarchy_id := rosetta_g_miss_num_map(a77(indx));
209 t(ddindx).node_id := rosetta_g_miss_num_map(a78(indx));
210 t(ddindx).level_depth := rosetta_g_miss_num_map(a79(indx));
211 t(ddindx).formula_id := rosetta_g_miss_num_map(a80(indx));
212 t(ddindx).from_date := rosetta_g_miss_date_in_map(a81(indx));
213 t(ddindx).to_date := rosetta_g_miss_date_in_map(a82(indx));
214 t(ddindx).fact_value := rosetta_g_miss_num_map(a83(indx));
215 t(ddindx).fact_percent := rosetta_g_miss_num_map(a84(indx));
216 t(ddindx).root_fact_id := rosetta_g_miss_num_map(a85(indx));
217 t(ddindx).previous_fact_id := rosetta_g_miss_num_map(a86(indx));
218 t(ddindx).fact_type := a87(indx);
219 t(ddindx).fact_reference := a88(indx);
220 t(ddindx).forward_buy_quantity := rosetta_g_miss_num_map(a89(indx));
221 t(ddindx).status_code := a90(indx);
222 t(ddindx).hierarchy_type := a91(indx);
223 t(ddindx).approval_date := rosetta_g_miss_date_in_map(a92(indx));
224 t(ddindx).recommend_total_amount := rosetta_g_miss_num_map(a93(indx));
225 t(ddindx).recommend_hb_amount := rosetta_g_miss_num_map(a94(indx));
226 t(ddindx).request_total_amount := rosetta_g_miss_num_map(a95(indx));
227 t(ddindx).request_hb_amount := rosetta_g_miss_num_map(a96(indx));
228 t(ddindx).actual_total_amount := rosetta_g_miss_num_map(a97(indx));
229 t(ddindx).actual_hb_amount := rosetta_g_miss_num_map(a98(indx));
230 t(ddindx).base_total_pct := rosetta_g_miss_num_map(a99(indx));
231 t(ddindx).base_hb_pct := rosetta_g_miss_num_map(a100(indx));
232 ddindx := ddindx+1;
233 if a0.last =indx
234 then exit;
235 end if;
236 indx := a0.next(indx);
237 end loop;
238 end if;
239 end if;
240 end rosetta_table_copy_in_p0;
241 procedure rosetta_table_copy_out_p0(t ozf_fund_allocations_pvt.fact_table_type, a0 out nocopy JTF_NUMBER_TABLE
242 , a1 out nocopy JTF_DATE_TABLE
243 , a2 out nocopy JTF_NUMBER_TABLE
244 , a3 out nocopy JTF_DATE_TABLE
245 , a4 out nocopy JTF_NUMBER_TABLE
246 , a5 out nocopy JTF_NUMBER_TABLE
247 , a6 out nocopy JTF_NUMBER_TABLE
248 , a7 out nocopy JTF_NUMBER_TABLE
249 , a8 out nocopy JTF_VARCHAR2_TABLE_100
250 , a9 out nocopy JTF_VARCHAR2_TABLE_100
251 , a10 out nocopy JTF_NUMBER_TABLE
252 , a11 out nocopy JTF_NUMBER_TABLE
253 , a12 out nocopy JTF_NUMBER_TABLE
254 , a13 out nocopy JTF_VARCHAR2_TABLE_100
255 , a14 out nocopy JTF_NUMBER_TABLE
256 , a15 out nocopy JTF_NUMBER_TABLE
257 , a16 out nocopy JTF_VARCHAR2_TABLE_100
258 , a17 out nocopy JTF_NUMBER_TABLE
259 , a18 out nocopy JTF_NUMBER_TABLE
260 , a19 out nocopy JTF_NUMBER_TABLE
261 , a20 out nocopy JTF_NUMBER_TABLE
262 , a21 out nocopy JTF_VARCHAR2_TABLE_100
263 , a22 out nocopy JTF_NUMBER_TABLE
264 , a23 out nocopy JTF_NUMBER_TABLE
265 , a24 out nocopy JTF_NUMBER_TABLE
266 , a25 out nocopy JTF_NUMBER_TABLE
267 , a26 out nocopy JTF_NUMBER_TABLE
268 , a27 out nocopy JTF_NUMBER_TABLE
269 , a28 out nocopy JTF_NUMBER_TABLE
270 , a29 out nocopy JTF_NUMBER_TABLE
271 , a30 out nocopy JTF_NUMBER_TABLE
272 , a31 out nocopy JTF_NUMBER_TABLE
273 , a32 out nocopy JTF_NUMBER_TABLE
274 , a33 out nocopy JTF_NUMBER_TABLE
275 , a34 out nocopy JTF_NUMBER_TABLE
276 , a35 out nocopy JTF_NUMBER_TABLE
277 , a36 out nocopy JTF_NUMBER_TABLE
278 , a37 out nocopy JTF_NUMBER_TABLE
279 , a38 out nocopy JTF_NUMBER_TABLE
280 , a39 out nocopy JTF_NUMBER_TABLE
281 , a40 out nocopy JTF_NUMBER_TABLE
282 , a41 out nocopy JTF_NUMBER_TABLE
283 , a42 out nocopy JTF_NUMBER_TABLE
284 , a43 out nocopy JTF_NUMBER_TABLE
285 , a44 out nocopy JTF_NUMBER_TABLE
286 , a45 out nocopy JTF_NUMBER_TABLE
287 , a46 out nocopy JTF_NUMBER_TABLE
288 , a47 out nocopy JTF_NUMBER_TABLE
289 , a48 out nocopy JTF_NUMBER_TABLE
290 , a49 out nocopy JTF_NUMBER_TABLE
291 , a50 out nocopy JTF_NUMBER_TABLE
292 , a51 out nocopy JTF_NUMBER_TABLE
293 , a52 out nocopy JTF_NUMBER_TABLE
294 , a53 out nocopy JTF_NUMBER_TABLE
295 , a54 out nocopy JTF_NUMBER_TABLE
296 , a55 out nocopy JTF_NUMBER_TABLE
297 , a56 out nocopy JTF_NUMBER_TABLE
298 , a57 out nocopy JTF_NUMBER_TABLE
299 , a58 out nocopy JTF_NUMBER_TABLE
300 , a59 out nocopy JTF_NUMBER_TABLE
301 , a60 out nocopy JTF_NUMBER_TABLE
302 , a61 out nocopy JTF_NUMBER_TABLE
303 , a62 out nocopy JTF_NUMBER_TABLE
304 , a63 out nocopy JTF_NUMBER_TABLE
305 , a64 out nocopy JTF_NUMBER_TABLE
306 , a65 out nocopy JTF_NUMBER_TABLE
307 , a66 out nocopy JTF_NUMBER_TABLE
308 , a67 out nocopy JTF_NUMBER_TABLE
309 , a68 out nocopy JTF_NUMBER_TABLE
310 , a69 out nocopy JTF_NUMBER_TABLE
311 , a70 out nocopy JTF_NUMBER_TABLE
312 , a71 out nocopy JTF_NUMBER_TABLE
313 , a72 out nocopy JTF_NUMBER_TABLE
314 , a73 out nocopy JTF_NUMBER_TABLE
315 , a74 out nocopy JTF_NUMBER_TABLE
316 , a75 out nocopy JTF_NUMBER_TABLE
317 , a76 out nocopy JTF_NUMBER_TABLE
318 , a77 out nocopy JTF_NUMBER_TABLE
319 , a78 out nocopy JTF_NUMBER_TABLE
320 , a79 out nocopy JTF_NUMBER_TABLE
321 , a80 out nocopy JTF_NUMBER_TABLE
322 , a81 out nocopy JTF_DATE_TABLE
323 , a82 out nocopy JTF_DATE_TABLE
324 , a83 out nocopy JTF_NUMBER_TABLE
325 , a84 out nocopy JTF_NUMBER_TABLE
326 , a85 out nocopy JTF_NUMBER_TABLE
327 , a86 out nocopy JTF_NUMBER_TABLE
328 , a87 out nocopy JTF_VARCHAR2_TABLE_100
329 , a88 out nocopy JTF_VARCHAR2_TABLE_300
330 , a89 out nocopy JTF_NUMBER_TABLE
331 , a90 out nocopy JTF_VARCHAR2_TABLE_100
332 , a91 out nocopy JTF_VARCHAR2_TABLE_100
333 , a92 out nocopy JTF_DATE_TABLE
334 , a93 out nocopy JTF_NUMBER_TABLE
335 , a94 out nocopy JTF_NUMBER_TABLE
336 , a95 out nocopy JTF_NUMBER_TABLE
337 , a96 out nocopy JTF_NUMBER_TABLE
338 , a97 out nocopy JTF_NUMBER_TABLE
339 , a98 out nocopy JTF_NUMBER_TABLE
340 , a99 out nocopy JTF_NUMBER_TABLE
341 , a100 out nocopy JTF_NUMBER_TABLE
342 ) as
343 ddindx binary_integer; indx binary_integer;
344 begin
345 if t is null or t.count = 0 then
346 a0 := JTF_NUMBER_TABLE();
347 a1 := JTF_DATE_TABLE();
348 a2 := JTF_NUMBER_TABLE();
349 a3 := JTF_DATE_TABLE();
350 a4 := JTF_NUMBER_TABLE();
351 a5 := JTF_NUMBER_TABLE();
352 a6 := JTF_NUMBER_TABLE();
353 a7 := JTF_NUMBER_TABLE();
354 a8 := JTF_VARCHAR2_TABLE_100();
355 a9 := JTF_VARCHAR2_TABLE_100();
356 a10 := JTF_NUMBER_TABLE();
357 a11 := JTF_NUMBER_TABLE();
358 a12 := JTF_NUMBER_TABLE();
359 a13 := JTF_VARCHAR2_TABLE_100();
360 a14 := JTF_NUMBER_TABLE();
361 a15 := JTF_NUMBER_TABLE();
362 a16 := JTF_VARCHAR2_TABLE_100();
363 a17 := JTF_NUMBER_TABLE();
364 a18 := JTF_NUMBER_TABLE();
365 a19 := JTF_NUMBER_TABLE();
366 a20 := JTF_NUMBER_TABLE();
367 a21 := JTF_VARCHAR2_TABLE_100();
368 a22 := JTF_NUMBER_TABLE();
369 a23 := JTF_NUMBER_TABLE();
370 a24 := JTF_NUMBER_TABLE();
371 a25 := JTF_NUMBER_TABLE();
372 a26 := JTF_NUMBER_TABLE();
373 a27 := JTF_NUMBER_TABLE();
374 a28 := JTF_NUMBER_TABLE();
375 a29 := JTF_NUMBER_TABLE();
376 a30 := JTF_NUMBER_TABLE();
377 a31 := JTF_NUMBER_TABLE();
378 a32 := JTF_NUMBER_TABLE();
379 a33 := JTF_NUMBER_TABLE();
380 a34 := JTF_NUMBER_TABLE();
381 a35 := JTF_NUMBER_TABLE();
382 a36 := JTF_NUMBER_TABLE();
383 a37 := JTF_NUMBER_TABLE();
384 a38 := JTF_NUMBER_TABLE();
385 a39 := JTF_NUMBER_TABLE();
386 a40 := JTF_NUMBER_TABLE();
387 a41 := JTF_NUMBER_TABLE();
388 a42 := JTF_NUMBER_TABLE();
389 a43 := JTF_NUMBER_TABLE();
390 a44 := JTF_NUMBER_TABLE();
391 a45 := JTF_NUMBER_TABLE();
392 a46 := JTF_NUMBER_TABLE();
393 a47 := JTF_NUMBER_TABLE();
394 a48 := JTF_NUMBER_TABLE();
395 a49 := JTF_NUMBER_TABLE();
396 a50 := JTF_NUMBER_TABLE();
397 a51 := JTF_NUMBER_TABLE();
398 a52 := JTF_NUMBER_TABLE();
399 a53 := JTF_NUMBER_TABLE();
400 a54 := JTF_NUMBER_TABLE();
401 a55 := JTF_NUMBER_TABLE();
402 a56 := JTF_NUMBER_TABLE();
403 a57 := JTF_NUMBER_TABLE();
404 a58 := JTF_NUMBER_TABLE();
405 a59 := JTF_NUMBER_TABLE();
406 a60 := JTF_NUMBER_TABLE();
407 a61 := JTF_NUMBER_TABLE();
408 a62 := JTF_NUMBER_TABLE();
409 a63 := JTF_NUMBER_TABLE();
410 a64 := JTF_NUMBER_TABLE();
411 a65 := JTF_NUMBER_TABLE();
412 a66 := JTF_NUMBER_TABLE();
413 a67 := JTF_NUMBER_TABLE();
414 a68 := JTF_NUMBER_TABLE();
415 a69 := JTF_NUMBER_TABLE();
416 a70 := JTF_NUMBER_TABLE();
417 a71 := JTF_NUMBER_TABLE();
418 a72 := JTF_NUMBER_TABLE();
419 a73 := JTF_NUMBER_TABLE();
420 a74 := JTF_NUMBER_TABLE();
421 a75 := JTF_NUMBER_TABLE();
422 a76 := JTF_NUMBER_TABLE();
423 a77 := JTF_NUMBER_TABLE();
424 a78 := JTF_NUMBER_TABLE();
425 a79 := JTF_NUMBER_TABLE();
426 a80 := JTF_NUMBER_TABLE();
427 a81 := JTF_DATE_TABLE();
428 a82 := JTF_DATE_TABLE();
429 a83 := JTF_NUMBER_TABLE();
430 a84 := JTF_NUMBER_TABLE();
431 a85 := JTF_NUMBER_TABLE();
432 a86 := JTF_NUMBER_TABLE();
433 a87 := JTF_VARCHAR2_TABLE_100();
434 a88 := JTF_VARCHAR2_TABLE_300();
435 a89 := JTF_NUMBER_TABLE();
436 a90 := JTF_VARCHAR2_TABLE_100();
437 a91 := JTF_VARCHAR2_TABLE_100();
438 a92 := JTF_DATE_TABLE();
439 a93 := JTF_NUMBER_TABLE();
440 a94 := JTF_NUMBER_TABLE();
441 a95 := JTF_NUMBER_TABLE();
442 a96 := JTF_NUMBER_TABLE();
443 a97 := JTF_NUMBER_TABLE();
444 a98 := JTF_NUMBER_TABLE();
445 a99 := JTF_NUMBER_TABLE();
446 a100 := JTF_NUMBER_TABLE();
447 else
448 a0 := JTF_NUMBER_TABLE();
449 a1 := JTF_DATE_TABLE();
450 a2 := JTF_NUMBER_TABLE();
451 a3 := JTF_DATE_TABLE();
452 a4 := JTF_NUMBER_TABLE();
453 a5 := JTF_NUMBER_TABLE();
454 a6 := JTF_NUMBER_TABLE();
455 a7 := JTF_NUMBER_TABLE();
456 a8 := JTF_VARCHAR2_TABLE_100();
457 a9 := JTF_VARCHAR2_TABLE_100();
458 a10 := JTF_NUMBER_TABLE();
459 a11 := JTF_NUMBER_TABLE();
460 a12 := JTF_NUMBER_TABLE();
461 a13 := JTF_VARCHAR2_TABLE_100();
462 a14 := JTF_NUMBER_TABLE();
463 a15 := JTF_NUMBER_TABLE();
464 a16 := JTF_VARCHAR2_TABLE_100();
465 a17 := JTF_NUMBER_TABLE();
466 a18 := JTF_NUMBER_TABLE();
467 a19 := JTF_NUMBER_TABLE();
468 a20 := JTF_NUMBER_TABLE();
469 a21 := JTF_VARCHAR2_TABLE_100();
470 a22 := JTF_NUMBER_TABLE();
471 a23 := JTF_NUMBER_TABLE();
472 a24 := JTF_NUMBER_TABLE();
473 a25 := JTF_NUMBER_TABLE();
474 a26 := JTF_NUMBER_TABLE();
475 a27 := JTF_NUMBER_TABLE();
476 a28 := JTF_NUMBER_TABLE();
477 a29 := JTF_NUMBER_TABLE();
478 a30 := JTF_NUMBER_TABLE();
479 a31 := JTF_NUMBER_TABLE();
480 a32 := JTF_NUMBER_TABLE();
481 a33 := JTF_NUMBER_TABLE();
482 a34 := JTF_NUMBER_TABLE();
483 a35 := JTF_NUMBER_TABLE();
484 a36 := JTF_NUMBER_TABLE();
485 a37 := JTF_NUMBER_TABLE();
486 a38 := JTF_NUMBER_TABLE();
487 a39 := JTF_NUMBER_TABLE();
488 a40 := JTF_NUMBER_TABLE();
489 a41 := JTF_NUMBER_TABLE();
490 a42 := JTF_NUMBER_TABLE();
491 a43 := JTF_NUMBER_TABLE();
492 a44 := JTF_NUMBER_TABLE();
493 a45 := JTF_NUMBER_TABLE();
494 a46 := JTF_NUMBER_TABLE();
495 a47 := JTF_NUMBER_TABLE();
496 a48 := JTF_NUMBER_TABLE();
497 a49 := JTF_NUMBER_TABLE();
498 a50 := JTF_NUMBER_TABLE();
499 a51 := JTF_NUMBER_TABLE();
500 a52 := JTF_NUMBER_TABLE();
501 a53 := JTF_NUMBER_TABLE();
502 a54 := JTF_NUMBER_TABLE();
503 a55 := JTF_NUMBER_TABLE();
504 a56 := JTF_NUMBER_TABLE();
505 a57 := JTF_NUMBER_TABLE();
506 a58 := JTF_NUMBER_TABLE();
507 a59 := JTF_NUMBER_TABLE();
508 a60 := JTF_NUMBER_TABLE();
509 a61 := JTF_NUMBER_TABLE();
510 a62 := JTF_NUMBER_TABLE();
511 a63 := JTF_NUMBER_TABLE();
512 a64 := JTF_NUMBER_TABLE();
513 a65 := JTF_NUMBER_TABLE();
514 a66 := JTF_NUMBER_TABLE();
515 a67 := JTF_NUMBER_TABLE();
516 a68 := JTF_NUMBER_TABLE();
517 a69 := JTF_NUMBER_TABLE();
518 a70 := JTF_NUMBER_TABLE();
519 a71 := JTF_NUMBER_TABLE();
520 a72 := JTF_NUMBER_TABLE();
521 a73 := JTF_NUMBER_TABLE();
522 a74 := JTF_NUMBER_TABLE();
523 a75 := JTF_NUMBER_TABLE();
524 a76 := JTF_NUMBER_TABLE();
525 a77 := JTF_NUMBER_TABLE();
526 a78 := JTF_NUMBER_TABLE();
527 a79 := JTF_NUMBER_TABLE();
528 a80 := JTF_NUMBER_TABLE();
529 a81 := JTF_DATE_TABLE();
530 a82 := JTF_DATE_TABLE();
531 a83 := JTF_NUMBER_TABLE();
532 a84 := JTF_NUMBER_TABLE();
533 a85 := JTF_NUMBER_TABLE();
534 a86 := JTF_NUMBER_TABLE();
535 a87 := JTF_VARCHAR2_TABLE_100();
536 a88 := JTF_VARCHAR2_TABLE_300();
537 a89 := JTF_NUMBER_TABLE();
538 a90 := JTF_VARCHAR2_TABLE_100();
539 a91 := JTF_VARCHAR2_TABLE_100();
540 a92 := JTF_DATE_TABLE();
541 a93 := JTF_NUMBER_TABLE();
542 a94 := JTF_NUMBER_TABLE();
543 a95 := JTF_NUMBER_TABLE();
544 a96 := JTF_NUMBER_TABLE();
545 a97 := JTF_NUMBER_TABLE();
546 a98 := JTF_NUMBER_TABLE();
547 a99 := JTF_NUMBER_TABLE();
548 a100 := JTF_NUMBER_TABLE();
549 if t.count > 0 then
550 a0.extend(t.count);
551 a1.extend(t.count);
552 a2.extend(t.count);
553 a3.extend(t.count);
554 a4.extend(t.count);
555 a5.extend(t.count);
556 a6.extend(t.count);
557 a7.extend(t.count);
558 a8.extend(t.count);
559 a9.extend(t.count);
560 a10.extend(t.count);
561 a11.extend(t.count);
562 a12.extend(t.count);
563 a13.extend(t.count);
564 a14.extend(t.count);
565 a15.extend(t.count);
566 a16.extend(t.count);
567 a17.extend(t.count);
568 a18.extend(t.count);
569 a19.extend(t.count);
570 a20.extend(t.count);
571 a21.extend(t.count);
572 a22.extend(t.count);
573 a23.extend(t.count);
574 a24.extend(t.count);
575 a25.extend(t.count);
576 a26.extend(t.count);
577 a27.extend(t.count);
578 a28.extend(t.count);
579 a29.extend(t.count);
580 a30.extend(t.count);
581 a31.extend(t.count);
582 a32.extend(t.count);
583 a33.extend(t.count);
584 a34.extend(t.count);
585 a35.extend(t.count);
586 a36.extend(t.count);
587 a37.extend(t.count);
588 a38.extend(t.count);
589 a39.extend(t.count);
590 a40.extend(t.count);
591 a41.extend(t.count);
592 a42.extend(t.count);
593 a43.extend(t.count);
594 a44.extend(t.count);
595 a45.extend(t.count);
596 a46.extend(t.count);
597 a47.extend(t.count);
598 a48.extend(t.count);
599 a49.extend(t.count);
600 a50.extend(t.count);
601 a51.extend(t.count);
602 a52.extend(t.count);
603 a53.extend(t.count);
604 a54.extend(t.count);
605 a55.extend(t.count);
606 a56.extend(t.count);
607 a57.extend(t.count);
608 a58.extend(t.count);
609 a59.extend(t.count);
610 a60.extend(t.count);
611 a61.extend(t.count);
612 a62.extend(t.count);
613 a63.extend(t.count);
614 a64.extend(t.count);
615 a65.extend(t.count);
616 a66.extend(t.count);
617 a67.extend(t.count);
618 a68.extend(t.count);
619 a69.extend(t.count);
620 a70.extend(t.count);
621 a71.extend(t.count);
622 a72.extend(t.count);
623 a73.extend(t.count);
624 a74.extend(t.count);
625 a75.extend(t.count);
626 a76.extend(t.count);
627 a77.extend(t.count);
628 a78.extend(t.count);
629 a79.extend(t.count);
630 a80.extend(t.count);
631 a81.extend(t.count);
632 a82.extend(t.count);
633 a83.extend(t.count);
634 a84.extend(t.count);
635 a85.extend(t.count);
636 a86.extend(t.count);
637 a87.extend(t.count);
638 a88.extend(t.count);
639 a89.extend(t.count);
640 a90.extend(t.count);
641 a91.extend(t.count);
642 a92.extend(t.count);
643 a93.extend(t.count);
644 a94.extend(t.count);
645 a95.extend(t.count);
646 a96.extend(t.count);
647 a97.extend(t.count);
648 a98.extend(t.count);
649 a99.extend(t.count);
650 a100.extend(t.count);
651 ddindx := t.first;
652 indx := 1;
653 while true loop
654 a0(indx) := rosetta_g_miss_num_map(t(ddindx).activity_metric_fact_id);
655 a1(indx) := t(ddindx).last_update_date;
656 a2(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
657 a3(indx) := t(ddindx).creation_date;
658 a4(indx) := rosetta_g_miss_num_map(t(ddindx).created_by);
659 a5(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
660 a6(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
661 a7(indx) := rosetta_g_miss_num_map(t(ddindx).act_metric_used_by_id);
662 a8(indx) := t(ddindx).arc_act_metric_used_by;
663 a9(indx) := t(ddindx).value_type;
664 a10(indx) := rosetta_g_miss_num_map(t(ddindx).activity_metric_id);
665 a11(indx) := rosetta_g_miss_num_map(t(ddindx).activity_geo_area_id);
666 a12(indx) := rosetta_g_miss_num_map(t(ddindx).activity_product_id);
667 a13(indx) := t(ddindx).transaction_currency_code;
668 a14(indx) := rosetta_g_miss_num_map(t(ddindx).trans_forecasted_value);
669 a15(indx) := rosetta_g_miss_num_map(t(ddindx).base_quantity);
670 a16(indx) := t(ddindx).functional_currency_code;
671 a17(indx) := rosetta_g_miss_num_map(t(ddindx).func_forecasted_value);
672 a18(indx) := rosetta_g_miss_num_map(t(ddindx).org_id);
673 a19(indx) := rosetta_g_miss_num_map(t(ddindx).de_metric_id);
674 a20(indx) := rosetta_g_miss_num_map(t(ddindx).de_geographic_area_id);
675 a21(indx) := t(ddindx).de_geographic_area_type;
676 a22(indx) := rosetta_g_miss_num_map(t(ddindx).de_inventory_item_id);
677 a23(indx) := rosetta_g_miss_num_map(t(ddindx).de_inventory_item_org_id);
678 a24(indx) := rosetta_g_miss_num_map(t(ddindx).time_id1);
679 a25(indx) := rosetta_g_miss_num_map(t(ddindx).time_id2);
680 a26(indx) := rosetta_g_miss_num_map(t(ddindx).time_id3);
681 a27(indx) := rosetta_g_miss_num_map(t(ddindx).time_id4);
682 a28(indx) := rosetta_g_miss_num_map(t(ddindx).time_id5);
683 a29(indx) := rosetta_g_miss_num_map(t(ddindx).time_id6);
684 a30(indx) := rosetta_g_miss_num_map(t(ddindx).time_id7);
685 a31(indx) := rosetta_g_miss_num_map(t(ddindx).time_id8);
686 a32(indx) := rosetta_g_miss_num_map(t(ddindx).time_id9);
687 a33(indx) := rosetta_g_miss_num_map(t(ddindx).time_id10);
688 a34(indx) := rosetta_g_miss_num_map(t(ddindx).time_id11);
689 a35(indx) := rosetta_g_miss_num_map(t(ddindx).time_id12);
690 a36(indx) := rosetta_g_miss_num_map(t(ddindx).time_id13);
691 a37(indx) := rosetta_g_miss_num_map(t(ddindx).time_id14);
692 a38(indx) := rosetta_g_miss_num_map(t(ddindx).time_id15);
693 a39(indx) := rosetta_g_miss_num_map(t(ddindx).time_id16);
694 a40(indx) := rosetta_g_miss_num_map(t(ddindx).time_id17);
695 a41(indx) := rosetta_g_miss_num_map(t(ddindx).time_id18);
696 a42(indx) := rosetta_g_miss_num_map(t(ddindx).time_id19);
697 a43(indx) := rosetta_g_miss_num_map(t(ddindx).time_id20);
698 a44(indx) := rosetta_g_miss_num_map(t(ddindx).time_id21);
699 a45(indx) := rosetta_g_miss_num_map(t(ddindx).time_id22);
700 a46(indx) := rosetta_g_miss_num_map(t(ddindx).time_id23);
701 a47(indx) := rosetta_g_miss_num_map(t(ddindx).time_id24);
702 a48(indx) := rosetta_g_miss_num_map(t(ddindx).time_id25);
703 a49(indx) := rosetta_g_miss_num_map(t(ddindx).time_id26);
704 a50(indx) := rosetta_g_miss_num_map(t(ddindx).time_id27);
705 a51(indx) := rosetta_g_miss_num_map(t(ddindx).time_id28);
706 a52(indx) := rosetta_g_miss_num_map(t(ddindx).time_id29);
707 a53(indx) := rosetta_g_miss_num_map(t(ddindx).time_id30);
708 a54(indx) := rosetta_g_miss_num_map(t(ddindx).time_id31);
709 a55(indx) := rosetta_g_miss_num_map(t(ddindx).time_id32);
710 a56(indx) := rosetta_g_miss_num_map(t(ddindx).time_id33);
711 a57(indx) := rosetta_g_miss_num_map(t(ddindx).time_id34);
712 a58(indx) := rosetta_g_miss_num_map(t(ddindx).time_id35);
713 a59(indx) := rosetta_g_miss_num_map(t(ddindx).time_id36);
714 a60(indx) := rosetta_g_miss_num_map(t(ddindx).time_id37);
715 a61(indx) := rosetta_g_miss_num_map(t(ddindx).time_id38);
716 a62(indx) := rosetta_g_miss_num_map(t(ddindx).time_id39);
717 a63(indx) := rosetta_g_miss_num_map(t(ddindx).time_id40);
718 a64(indx) := rosetta_g_miss_num_map(t(ddindx).time_id41);
719 a65(indx) := rosetta_g_miss_num_map(t(ddindx).time_id42);
720 a66(indx) := rosetta_g_miss_num_map(t(ddindx).time_id43);
721 a67(indx) := rosetta_g_miss_num_map(t(ddindx).time_id44);
722 a68(indx) := rosetta_g_miss_num_map(t(ddindx).time_id45);
723 a69(indx) := rosetta_g_miss_num_map(t(ddindx).time_id46);
724 a70(indx) := rosetta_g_miss_num_map(t(ddindx).time_id47);
725 a71(indx) := rosetta_g_miss_num_map(t(ddindx).time_id48);
726 a72(indx) := rosetta_g_miss_num_map(t(ddindx).time_id49);
727 a73(indx) := rosetta_g_miss_num_map(t(ddindx).time_id50);
728 a74(indx) := rosetta_g_miss_num_map(t(ddindx).time_id51);
729 a75(indx) := rosetta_g_miss_num_map(t(ddindx).time_id52);
730 a76(indx) := rosetta_g_miss_num_map(t(ddindx).time_id53);
731 a77(indx) := rosetta_g_miss_num_map(t(ddindx).hierarchy_id);
732 a78(indx) := rosetta_g_miss_num_map(t(ddindx).node_id);
733 a79(indx) := rosetta_g_miss_num_map(t(ddindx).level_depth);
734 a80(indx) := rosetta_g_miss_num_map(t(ddindx).formula_id);
735 a81(indx) := t(ddindx).from_date;
736 a82(indx) := t(ddindx).to_date;
737 a83(indx) := rosetta_g_miss_num_map(t(ddindx).fact_value);
738 a84(indx) := rosetta_g_miss_num_map(t(ddindx).fact_percent);
739 a85(indx) := rosetta_g_miss_num_map(t(ddindx).root_fact_id);
740 a86(indx) := rosetta_g_miss_num_map(t(ddindx).previous_fact_id);
741 a87(indx) := t(ddindx).fact_type;
742 a88(indx) := t(ddindx).fact_reference;
743 a89(indx) := rosetta_g_miss_num_map(t(ddindx).forward_buy_quantity);
744 a90(indx) := t(ddindx).status_code;
745 a91(indx) := t(ddindx).hierarchy_type;
746 a92(indx) := t(ddindx).approval_date;
747 a93(indx) := rosetta_g_miss_num_map(t(ddindx).recommend_total_amount);
748 a94(indx) := rosetta_g_miss_num_map(t(ddindx).recommend_hb_amount);
749 a95(indx) := rosetta_g_miss_num_map(t(ddindx).request_total_amount);
750 a96(indx) := rosetta_g_miss_num_map(t(ddindx).request_hb_amount);
751 a97(indx) := rosetta_g_miss_num_map(t(ddindx).actual_total_amount);
752 a98(indx) := rosetta_g_miss_num_map(t(ddindx).actual_hb_amount);
753 a99(indx) := rosetta_g_miss_num_map(t(ddindx).base_total_pct);
754 a100(indx) := rosetta_g_miss_num_map(t(ddindx).base_hb_pct);
755 indx := indx+1;
756 if t.last =ddindx
757 then exit;
758 end if;
759 ddindx := t.next(ddindx);
760 end loop;
761 end if;
762 end if;
763 end rosetta_table_copy_out_p0;
764
765 procedure rosetta_table_copy_in_p2(t out nocopy ozf_fund_allocations_pvt.factid_table_type, a0 JTF_NUMBER_TABLE
766 , a1 JTF_NUMBER_TABLE
767 , a2 JTF_VARCHAR2_TABLE_100
768 ) as
769 ddindx binary_integer; indx binary_integer;
770 begin
771 if a0 is not null and a0.count > 0 then
772 if a0.count > 0 then
773 indx := a0.first;
774 ddindx := 1;
775 while true loop
776 t(ddindx).fact_id := rosetta_g_miss_num_map(a0(indx));
777 t(ddindx).fact_obj_ver := rosetta_g_miss_num_map(a1(indx));
778 t(ddindx).approve_recommend := a2(indx);
779 ddindx := ddindx+1;
780 if a0.last =indx
781 then exit;
782 end if;
783 indx := a0.next(indx);
784 end loop;
785 end if;
786 end if;
787 end rosetta_table_copy_in_p2;
788 procedure rosetta_table_copy_out_p2(t ozf_fund_allocations_pvt.factid_table_type, a0 out nocopy JTF_NUMBER_TABLE
789 , a1 out nocopy JTF_NUMBER_TABLE
790 , a2 out nocopy JTF_VARCHAR2_TABLE_100
791 ) as
792 ddindx binary_integer; indx binary_integer;
793 begin
794 if t is null or t.count = 0 then
795 a0 := JTF_NUMBER_TABLE();
796 a1 := JTF_NUMBER_TABLE();
797 a2 := JTF_VARCHAR2_TABLE_100();
798 else
799 a0 := JTF_NUMBER_TABLE();
800 a1 := JTF_NUMBER_TABLE();
801 a2 := JTF_VARCHAR2_TABLE_100();
802 if t.count > 0 then
803 a0.extend(t.count);
804 a1.extend(t.count);
805 a2.extend(t.count);
806 ddindx := t.first;
807 indx := 1;
808 while true loop
809 a0(indx) := rosetta_g_miss_num_map(t(ddindx).fact_id);
810 a1(indx) := rosetta_g_miss_num_map(t(ddindx).fact_obj_ver);
811 a2(indx) := t(ddindx).approve_recommend;
812 indx := indx+1;
813 if t.last =ddindx
814 then exit;
815 end if;
816 ddindx := t.next(ddindx);
817 end loop;
818 end if;
819 end if;
820 end rosetta_table_copy_out_p2;
821
822 procedure update_worksheet_amount(p_api_version NUMBER
823 , p_init_msg_list VARCHAR2
824 , p_commit VARCHAR2
825 , p_validation_level NUMBER
826 , p_alloc_id NUMBER
827 , p_alloc_obj_ver NUMBER
828 , p_cascade_flag VARCHAR2
829 , p7_a0 JTF_NUMBER_TABLE
830 , p7_a1 JTF_DATE_TABLE
831 , p7_a2 JTF_NUMBER_TABLE
832 , p7_a3 JTF_DATE_TABLE
833 , p7_a4 JTF_NUMBER_TABLE
834 , p7_a5 JTF_NUMBER_TABLE
835 , p7_a6 JTF_NUMBER_TABLE
836 , p7_a7 JTF_NUMBER_TABLE
837 , p7_a8 JTF_VARCHAR2_TABLE_100
838 , p7_a9 JTF_VARCHAR2_TABLE_100
839 , p7_a10 JTF_NUMBER_TABLE
840 , p7_a11 JTF_NUMBER_TABLE
841 , p7_a12 JTF_NUMBER_TABLE
842 , p7_a13 JTF_VARCHAR2_TABLE_100
843 , p7_a14 JTF_NUMBER_TABLE
844 , p7_a15 JTF_NUMBER_TABLE
845 , p7_a16 JTF_VARCHAR2_TABLE_100
846 , p7_a17 JTF_NUMBER_TABLE
847 , p7_a18 JTF_NUMBER_TABLE
848 , p7_a19 JTF_NUMBER_TABLE
849 , p7_a20 JTF_NUMBER_TABLE
850 , p7_a21 JTF_VARCHAR2_TABLE_100
851 , p7_a22 JTF_NUMBER_TABLE
852 , p7_a23 JTF_NUMBER_TABLE
853 , p7_a24 JTF_NUMBER_TABLE
854 , p7_a25 JTF_NUMBER_TABLE
855 , p7_a26 JTF_NUMBER_TABLE
856 , p7_a27 JTF_NUMBER_TABLE
857 , p7_a28 JTF_NUMBER_TABLE
858 , p7_a29 JTF_NUMBER_TABLE
859 , p7_a30 JTF_NUMBER_TABLE
860 , p7_a31 JTF_NUMBER_TABLE
861 , p7_a32 JTF_NUMBER_TABLE
862 , p7_a33 JTF_NUMBER_TABLE
863 , p7_a34 JTF_NUMBER_TABLE
864 , p7_a35 JTF_NUMBER_TABLE
865 , p7_a36 JTF_NUMBER_TABLE
866 , p7_a37 JTF_NUMBER_TABLE
867 , p7_a38 JTF_NUMBER_TABLE
868 , p7_a39 JTF_NUMBER_TABLE
869 , p7_a40 JTF_NUMBER_TABLE
870 , p7_a41 JTF_NUMBER_TABLE
871 , p7_a42 JTF_NUMBER_TABLE
872 , p7_a43 JTF_NUMBER_TABLE
873 , p7_a44 JTF_NUMBER_TABLE
874 , p7_a45 JTF_NUMBER_TABLE
875 , p7_a46 JTF_NUMBER_TABLE
876 , p7_a47 JTF_NUMBER_TABLE
877 , p7_a48 JTF_NUMBER_TABLE
878 , p7_a49 JTF_NUMBER_TABLE
879 , p7_a50 JTF_NUMBER_TABLE
880 , p7_a51 JTF_NUMBER_TABLE
881 , p7_a52 JTF_NUMBER_TABLE
882 , p7_a53 JTF_NUMBER_TABLE
883 , p7_a54 JTF_NUMBER_TABLE
884 , p7_a55 JTF_NUMBER_TABLE
885 , p7_a56 JTF_NUMBER_TABLE
886 , p7_a57 JTF_NUMBER_TABLE
887 , p7_a58 JTF_NUMBER_TABLE
888 , p7_a59 JTF_NUMBER_TABLE
889 , p7_a60 JTF_NUMBER_TABLE
890 , p7_a61 JTF_NUMBER_TABLE
891 , p7_a62 JTF_NUMBER_TABLE
892 , p7_a63 JTF_NUMBER_TABLE
893 , p7_a64 JTF_NUMBER_TABLE
894 , p7_a65 JTF_NUMBER_TABLE
895 , p7_a66 JTF_NUMBER_TABLE
896 , p7_a67 JTF_NUMBER_TABLE
897 , p7_a68 JTF_NUMBER_TABLE
898 , p7_a69 JTF_NUMBER_TABLE
899 , p7_a70 JTF_NUMBER_TABLE
900 , p7_a71 JTF_NUMBER_TABLE
901 , p7_a72 JTF_NUMBER_TABLE
902 , p7_a73 JTF_NUMBER_TABLE
903 , p7_a74 JTF_NUMBER_TABLE
904 , p7_a75 JTF_NUMBER_TABLE
905 , p7_a76 JTF_NUMBER_TABLE
906 , p7_a77 JTF_NUMBER_TABLE
907 , p7_a78 JTF_NUMBER_TABLE
908 , p7_a79 JTF_NUMBER_TABLE
909 , p7_a80 JTF_NUMBER_TABLE
910 , p7_a81 JTF_DATE_TABLE
911 , p7_a82 JTF_DATE_TABLE
912 , p7_a83 JTF_NUMBER_TABLE
913 , p7_a84 JTF_NUMBER_TABLE
914 , p7_a85 JTF_NUMBER_TABLE
915 , p7_a86 JTF_NUMBER_TABLE
916 , p7_a87 JTF_VARCHAR2_TABLE_100
917 , p7_a88 JTF_VARCHAR2_TABLE_300
918 , p7_a89 JTF_NUMBER_TABLE
919 , p7_a90 JTF_VARCHAR2_TABLE_100
920 , p7_a91 JTF_VARCHAR2_TABLE_100
921 , p7_a92 JTF_DATE_TABLE
922 , p7_a93 JTF_NUMBER_TABLE
923 , p7_a94 JTF_NUMBER_TABLE
924 , p7_a95 JTF_NUMBER_TABLE
925 , p7_a96 JTF_NUMBER_TABLE
926 , p7_a97 JTF_NUMBER_TABLE
927 , p7_a98 JTF_NUMBER_TABLE
928 , p7_a99 JTF_NUMBER_TABLE
929 , p7_a100 JTF_NUMBER_TABLE
930 , x_return_status out nocopy VARCHAR2
931 , x_msg_count out nocopy NUMBER
932 , x_msg_data out nocopy VARCHAR2
933 )
934
935 as
936 ddp_fact_table ozf_fund_allocations_pvt.fact_table_type;
937 ddindx binary_integer; indx binary_integer;
938 begin
939
940 -- copy data to the local IN or IN-OUT args, if any
941
942
943
944
945
946
947
948 ozf_fund_allocations_pvt_w.rosetta_table_copy_in_p0(ddp_fact_table, p7_a0
949 , p7_a1
950 , p7_a2
951 , p7_a3
952 , p7_a4
953 , p7_a5
954 , p7_a6
955 , p7_a7
956 , p7_a8
957 , p7_a9
958 , p7_a10
959 , p7_a11
960 , p7_a12
961 , p7_a13
962 , p7_a14
963 , p7_a15
964 , p7_a16
965 , p7_a17
966 , p7_a18
967 , p7_a19
968 , p7_a20
969 , p7_a21
970 , p7_a22
971 , p7_a23
972 , p7_a24
973 , p7_a25
974 , p7_a26
975 , p7_a27
976 , p7_a28
977 , p7_a29
978 , p7_a30
979 , p7_a31
980 , p7_a32
981 , p7_a33
982 , p7_a34
983 , p7_a35
984 , p7_a36
985 , p7_a37
986 , p7_a38
987 , p7_a39
988 , p7_a40
989 , p7_a41
990 , p7_a42
991 , p7_a43
992 , p7_a44
993 , p7_a45
994 , p7_a46
995 , p7_a47
996 , p7_a48
997 , p7_a49
998 , p7_a50
999 , p7_a51
1000 , p7_a52
1001 , p7_a53
1002 , p7_a54
1003 , p7_a55
1004 , p7_a56
1005 , p7_a57
1006 , p7_a58
1007 , p7_a59
1008 , p7_a60
1009 , p7_a61
1010 , p7_a62
1011 , p7_a63
1012 , p7_a64
1013 , p7_a65
1014 , p7_a66
1015 , p7_a67
1016 , p7_a68
1017 , p7_a69
1018 , p7_a70
1019 , p7_a71
1020 , p7_a72
1021 , p7_a73
1022 , p7_a74
1023 , p7_a75
1024 , p7_a76
1025 , p7_a77
1026 , p7_a78
1027 , p7_a79
1028 , p7_a80
1029 , p7_a81
1030 , p7_a82
1031 , p7_a83
1032 , p7_a84
1033 , p7_a85
1034 , p7_a86
1035 , p7_a87
1036 , p7_a88
1037 , p7_a89
1038 , p7_a90
1039 , p7_a91
1040 , p7_a92
1041 , p7_a93
1042 , p7_a94
1043 , p7_a95
1044 , p7_a96
1045 , p7_a97
1046 , p7_a98
1047 , p7_a99
1048 , p7_a100
1049 );
1050
1051
1052
1053
1054 -- here's the delegated call to the old PL/SQL routine
1055 ozf_fund_allocations_pvt.update_worksheet_amount(p_api_version,
1056 p_init_msg_list,
1057 p_commit,
1058 p_validation_level,
1059 p_alloc_id,
1060 p_alloc_obj_ver,
1061 p_cascade_flag,
1062 ddp_fact_table,
1063 x_return_status,
1064 x_msg_count,
1065 x_msg_data);
1066
1067 -- copy data back from the local variables to OUT or IN-OUT args, if any
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078 end;
1079
1080 procedure approve_levels(p_api_version NUMBER
1081 , p_init_msg_list VARCHAR2
1082 , p_commit VARCHAR2
1083 , p_validation_level NUMBER
1084 , p_approver_factid NUMBER
1085 , p_approve_all_flag VARCHAR2
1086 , p6_a0 JTF_NUMBER_TABLE
1087 , p6_a1 JTF_NUMBER_TABLE
1088 , p6_a2 JTF_VARCHAR2_TABLE_100
1089 , x_return_status out nocopy VARCHAR2
1090 , x_msg_count out nocopy NUMBER
1091 , x_msg_data out nocopy VARCHAR2
1092 )
1093
1094 as
1095 ddp_factid_table ozf_fund_allocations_pvt.factid_table_type;
1096 ddindx binary_integer; indx binary_integer;
1097 begin
1098
1099 -- copy data to the local IN or IN-OUT args, if any
1100
1101
1102
1103
1104
1105
1106 ozf_fund_allocations_pvt_w.rosetta_table_copy_in_p2(ddp_factid_table, p6_a0
1107 , p6_a1
1108 , p6_a2
1109 );
1110
1111
1112
1113
1114 -- here's the delegated call to the old PL/SQL routine
1115 ozf_fund_allocations_pvt.approve_levels(p_api_version,
1116 p_init_msg_list,
1117 p_commit,
1118 p_validation_level,
1119 p_approver_factid,
1120 p_approve_all_flag,
1121 ddp_factid_table,
1122 x_return_status,
1123 x_msg_count,
1124 x_msg_data);
1125
1126 -- copy data back from the local variables to OUT or IN-OUT args, if any
1127
1128
1129
1130
1131
1132
1133
1134
1135
1136 end;
1137
1138 procedure reject_request(p_api_version NUMBER
1139 , p_init_msg_list VARCHAR2
1140 , p_commit VARCHAR2
1141 , p_validation_level NUMBER
1142 , p_rejector_factid NUMBER
1143 , p5_a0 JTF_NUMBER_TABLE
1144 , p5_a1 JTF_NUMBER_TABLE
1145 , p5_a2 JTF_VARCHAR2_TABLE_100
1146 , x_return_status out nocopy VARCHAR2
1147 , x_msg_count out nocopy NUMBER
1148 , x_msg_data out nocopy VARCHAR2
1149 )
1150
1151 as
1152 ddp_factid_table ozf_fund_allocations_pvt.factid_table_type;
1153 ddindx binary_integer; indx binary_integer;
1154 begin
1155
1156 -- copy data to the local IN or IN-OUT args, if any
1157
1158
1159
1160
1161
1162 ozf_fund_allocations_pvt_w.rosetta_table_copy_in_p2(ddp_factid_table, p5_a0
1163 , p5_a1
1164 , p5_a2
1165 );
1166
1167
1168
1169
1170 -- here's the delegated call to the old PL/SQL routine
1171 ozf_fund_allocations_pvt.reject_request(p_api_version,
1172 p_init_msg_list,
1173 p_commit,
1174 p_validation_level,
1175 p_rejector_factid,
1176 ddp_factid_table,
1177 x_return_status,
1178 x_msg_count,
1179 x_msg_data);
1180
1181 -- copy data back from the local variables to OUT or IN-OUT args, if any
1182
1183
1184
1185
1186
1187
1188
1189
1190 end;
1191
1192 end ozf_fund_allocations_pvt_w;