[Home] [Help]
PACKAGE BODY: APPS.AMS_ACTMETRICFACT_PVT_W
Source
1 package body ams_actmetricfact_pvt_w as
2 /* $Header: amswamfb.pls 115.13 2002/11/16 01:10:14 mgudivak ship $ */
3 rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4 rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5
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 init_actmetricfact_rec(p0_a0 out nocopy NUMBER
23 , p0_a1 out nocopy DATE
24 , p0_a2 out nocopy NUMBER
25 , p0_a3 out nocopy DATE
26 , p0_a4 out nocopy NUMBER
27 , p0_a5 out nocopy NUMBER
28 , p0_a6 out nocopy NUMBER
29 , p0_a7 out nocopy NUMBER
30 , p0_a8 out nocopy VARCHAR2
31 , p0_a9 out nocopy VARCHAR2
32 , p0_a10 out nocopy NUMBER
33 , p0_a11 out nocopy NUMBER
34 , p0_a12 out nocopy NUMBER
35 , p0_a13 out nocopy VARCHAR2
36 , p0_a14 out nocopy NUMBER
37 , p0_a15 out nocopy NUMBER
38 , p0_a16 out nocopy VARCHAR2
39 , p0_a17 out nocopy NUMBER
40 , p0_a18 out nocopy NUMBER
41 , p0_a19 out nocopy NUMBER
42 , p0_a20 out nocopy NUMBER
43 , p0_a21 out nocopy VARCHAR2
44 , p0_a22 out nocopy NUMBER
45 , p0_a23 out nocopy NUMBER
46 , p0_a24 out nocopy NUMBER
47 , p0_a25 out nocopy NUMBER
48 , p0_a26 out nocopy NUMBER
49 , p0_a27 out nocopy NUMBER
50 , p0_a28 out nocopy NUMBER
51 , p0_a29 out nocopy NUMBER
52 , p0_a30 out nocopy NUMBER
53 , p0_a31 out nocopy NUMBER
54 , p0_a32 out nocopy NUMBER
55 , p0_a33 out nocopy NUMBER
56 , p0_a34 out nocopy NUMBER
57 , p0_a35 out nocopy NUMBER
58 , p0_a36 out nocopy NUMBER
59 , p0_a37 out nocopy NUMBER
60 , p0_a38 out nocopy NUMBER
61 , p0_a39 out nocopy NUMBER
62 , p0_a40 out nocopy NUMBER
63 , p0_a41 out nocopy NUMBER
64 , p0_a42 out nocopy NUMBER
65 , p0_a43 out nocopy NUMBER
66 , p0_a44 out nocopy NUMBER
67 , p0_a45 out nocopy NUMBER
68 , p0_a46 out nocopy NUMBER
69 , p0_a47 out nocopy NUMBER
70 , p0_a48 out nocopy NUMBER
71 , p0_a49 out nocopy NUMBER
72 , p0_a50 out nocopy NUMBER
73 , p0_a51 out nocopy NUMBER
74 , p0_a52 out nocopy NUMBER
75 , p0_a53 out nocopy NUMBER
76 , p0_a54 out nocopy NUMBER
77 , p0_a55 out nocopy NUMBER
78 , p0_a56 out nocopy NUMBER
79 , p0_a57 out nocopy NUMBER
80 , p0_a58 out nocopy NUMBER
81 , p0_a59 out nocopy NUMBER
82 , p0_a60 out nocopy NUMBER
83 , p0_a61 out nocopy NUMBER
84 , p0_a62 out nocopy NUMBER
85 , p0_a63 out nocopy NUMBER
86 , p0_a64 out nocopy NUMBER
87 , p0_a65 out nocopy NUMBER
88 , p0_a66 out nocopy NUMBER
89 , p0_a67 out nocopy NUMBER
90 , p0_a68 out nocopy NUMBER
91 , p0_a69 out nocopy NUMBER
92 , p0_a70 out nocopy NUMBER
93 , p0_a71 out nocopy NUMBER
94 , p0_a72 out nocopy NUMBER
95 , p0_a73 out nocopy NUMBER
96 , p0_a74 out nocopy NUMBER
97 , p0_a75 out nocopy NUMBER
98 , p0_a76 out nocopy NUMBER
99 , p0_a77 out nocopy NUMBER
100 , p0_a78 out nocopy NUMBER
101 , p0_a79 out nocopy NUMBER
102 , p0_a80 out nocopy NUMBER
103 , p0_a81 out nocopy DATE
104 , p0_a82 out nocopy DATE
105 , p0_a83 out nocopy NUMBER
106 , p0_a84 out nocopy NUMBER
107 , p0_a85 out nocopy NUMBER
108 , p0_a86 out nocopy NUMBER
109 , p0_a87 out nocopy VARCHAR2
110 , p0_a88 out nocopy VARCHAR2
111 , p0_a89 out nocopy NUMBER
112 , p0_a90 out nocopy VARCHAR2
113 , p0_a91 out nocopy VARCHAR2
114 , p0_a92 out nocopy DATE
115 , p0_a93 out nocopy NUMBER
116 , p0_a94 out nocopy NUMBER
117 , p0_a95 out nocopy NUMBER
118 , p0_a96 out nocopy NUMBER
119 , p0_a97 out nocopy NUMBER
120 , p0_a98 out nocopy NUMBER
121 , p0_a99 out nocopy NUMBER
122 , p0_a100 out nocopy NUMBER
123 )
124
125 as
126 ddx_fact_rec ams_actmetricfact_pvt.act_metric_fact_rec_type;
127 ddindx binary_integer; indx binary_integer;
128 begin
129
130 -- copy data to the local IN or IN-OUT args, if any
131
132 -- here's the delegated call to the old PL/SQL routine
133 ams_actmetricfact_pvt.init_actmetricfact_rec(ddx_fact_rec);
134
135 -- copy data back from the local variables to OUT or IN-OUT args, if any
136 p0_a0 := rosetta_g_miss_num_map(ddx_fact_rec.activity_metric_fact_id);
137 p0_a1 := ddx_fact_rec.last_update_date;
138 p0_a2 := rosetta_g_miss_num_map(ddx_fact_rec.last_updated_by);
139 p0_a3 := ddx_fact_rec.creation_date;
140 p0_a4 := rosetta_g_miss_num_map(ddx_fact_rec.created_by);
141 p0_a5 := rosetta_g_miss_num_map(ddx_fact_rec.last_update_login);
142 p0_a6 := rosetta_g_miss_num_map(ddx_fact_rec.object_version_number);
143 p0_a7 := rosetta_g_miss_num_map(ddx_fact_rec.act_metric_used_by_id);
144 p0_a8 := ddx_fact_rec.arc_act_metric_used_by;
145 p0_a9 := ddx_fact_rec.value_type;
146 p0_a10 := rosetta_g_miss_num_map(ddx_fact_rec.activity_metric_id);
147 p0_a11 := rosetta_g_miss_num_map(ddx_fact_rec.activity_geo_area_id);
148 p0_a12 := rosetta_g_miss_num_map(ddx_fact_rec.activity_product_id);
149 p0_a13 := ddx_fact_rec.transaction_currency_code;
150 p0_a14 := rosetta_g_miss_num_map(ddx_fact_rec.trans_forecasted_value);
151 p0_a15 := rosetta_g_miss_num_map(ddx_fact_rec.base_quantity);
152 p0_a16 := ddx_fact_rec.functional_currency_code;
153 p0_a17 := rosetta_g_miss_num_map(ddx_fact_rec.func_forecasted_value);
154 p0_a18 := rosetta_g_miss_num_map(ddx_fact_rec.org_id);
155 p0_a19 := rosetta_g_miss_num_map(ddx_fact_rec.de_metric_id);
156 p0_a20 := rosetta_g_miss_num_map(ddx_fact_rec.de_geographic_area_id);
157 p0_a21 := ddx_fact_rec.de_geographic_area_type;
158 p0_a22 := rosetta_g_miss_num_map(ddx_fact_rec.de_inventory_item_id);
159 p0_a23 := rosetta_g_miss_num_map(ddx_fact_rec.de_inventory_item_org_id);
160 p0_a24 := rosetta_g_miss_num_map(ddx_fact_rec.time_id1);
161 p0_a25 := rosetta_g_miss_num_map(ddx_fact_rec.time_id2);
162 p0_a26 := rosetta_g_miss_num_map(ddx_fact_rec.time_id3);
163 p0_a27 := rosetta_g_miss_num_map(ddx_fact_rec.time_id4);
164 p0_a28 := rosetta_g_miss_num_map(ddx_fact_rec.time_id5);
165 p0_a29 := rosetta_g_miss_num_map(ddx_fact_rec.time_id6);
166 p0_a30 := rosetta_g_miss_num_map(ddx_fact_rec.time_id7);
167 p0_a31 := rosetta_g_miss_num_map(ddx_fact_rec.time_id8);
168 p0_a32 := rosetta_g_miss_num_map(ddx_fact_rec.time_id9);
169 p0_a33 := rosetta_g_miss_num_map(ddx_fact_rec.time_id10);
170 p0_a34 := rosetta_g_miss_num_map(ddx_fact_rec.time_id11);
171 p0_a35 := rosetta_g_miss_num_map(ddx_fact_rec.time_id12);
172 p0_a36 := rosetta_g_miss_num_map(ddx_fact_rec.time_id13);
173 p0_a37 := rosetta_g_miss_num_map(ddx_fact_rec.time_id14);
174 p0_a38 := rosetta_g_miss_num_map(ddx_fact_rec.time_id15);
175 p0_a39 := rosetta_g_miss_num_map(ddx_fact_rec.time_id16);
176 p0_a40 := rosetta_g_miss_num_map(ddx_fact_rec.time_id17);
177 p0_a41 := rosetta_g_miss_num_map(ddx_fact_rec.time_id18);
178 p0_a42 := rosetta_g_miss_num_map(ddx_fact_rec.time_id19);
179 p0_a43 := rosetta_g_miss_num_map(ddx_fact_rec.time_id20);
180 p0_a44 := rosetta_g_miss_num_map(ddx_fact_rec.time_id21);
181 p0_a45 := rosetta_g_miss_num_map(ddx_fact_rec.time_id22);
182 p0_a46 := rosetta_g_miss_num_map(ddx_fact_rec.time_id23);
183 p0_a47 := rosetta_g_miss_num_map(ddx_fact_rec.time_id24);
184 p0_a48 := rosetta_g_miss_num_map(ddx_fact_rec.time_id25);
185 p0_a49 := rosetta_g_miss_num_map(ddx_fact_rec.time_id26);
186 p0_a50 := rosetta_g_miss_num_map(ddx_fact_rec.time_id27);
187 p0_a51 := rosetta_g_miss_num_map(ddx_fact_rec.time_id28);
188 p0_a52 := rosetta_g_miss_num_map(ddx_fact_rec.time_id29);
189 p0_a53 := rosetta_g_miss_num_map(ddx_fact_rec.time_id30);
190 p0_a54 := rosetta_g_miss_num_map(ddx_fact_rec.time_id31);
191 p0_a55 := rosetta_g_miss_num_map(ddx_fact_rec.time_id32);
192 p0_a56 := rosetta_g_miss_num_map(ddx_fact_rec.time_id33);
193 p0_a57 := rosetta_g_miss_num_map(ddx_fact_rec.time_id34);
194 p0_a58 := rosetta_g_miss_num_map(ddx_fact_rec.time_id35);
195 p0_a59 := rosetta_g_miss_num_map(ddx_fact_rec.time_id36);
196 p0_a60 := rosetta_g_miss_num_map(ddx_fact_rec.time_id37);
197 p0_a61 := rosetta_g_miss_num_map(ddx_fact_rec.time_id38);
198 p0_a62 := rosetta_g_miss_num_map(ddx_fact_rec.time_id39);
199 p0_a63 := rosetta_g_miss_num_map(ddx_fact_rec.time_id40);
200 p0_a64 := rosetta_g_miss_num_map(ddx_fact_rec.time_id41);
201 p0_a65 := rosetta_g_miss_num_map(ddx_fact_rec.time_id42);
202 p0_a66 := rosetta_g_miss_num_map(ddx_fact_rec.time_id43);
203 p0_a67 := rosetta_g_miss_num_map(ddx_fact_rec.time_id44);
204 p0_a68 := rosetta_g_miss_num_map(ddx_fact_rec.time_id45);
205 p0_a69 := rosetta_g_miss_num_map(ddx_fact_rec.time_id46);
206 p0_a70 := rosetta_g_miss_num_map(ddx_fact_rec.time_id47);
207 p0_a71 := rosetta_g_miss_num_map(ddx_fact_rec.time_id48);
208 p0_a72 := rosetta_g_miss_num_map(ddx_fact_rec.time_id49);
209 p0_a73 := rosetta_g_miss_num_map(ddx_fact_rec.time_id50);
210 p0_a74 := rosetta_g_miss_num_map(ddx_fact_rec.time_id51);
211 p0_a75 := rosetta_g_miss_num_map(ddx_fact_rec.time_id52);
212 p0_a76 := rosetta_g_miss_num_map(ddx_fact_rec.time_id53);
213 p0_a77 := rosetta_g_miss_num_map(ddx_fact_rec.hierarchy_id);
214 p0_a78 := rosetta_g_miss_num_map(ddx_fact_rec.node_id);
215 p0_a79 := rosetta_g_miss_num_map(ddx_fact_rec.level_depth);
216 p0_a80 := rosetta_g_miss_num_map(ddx_fact_rec.formula_id);
217 p0_a81 := ddx_fact_rec.from_date;
218 p0_a82 := ddx_fact_rec.to_date;
219 p0_a83 := rosetta_g_miss_num_map(ddx_fact_rec.fact_value);
220 p0_a84 := rosetta_g_miss_num_map(ddx_fact_rec.fact_percent);
221 p0_a85 := rosetta_g_miss_num_map(ddx_fact_rec.root_fact_id);
222 p0_a86 := rosetta_g_miss_num_map(ddx_fact_rec.previous_fact_id);
223 p0_a87 := ddx_fact_rec.fact_type;
224 p0_a88 := ddx_fact_rec.fact_reference;
225 p0_a89 := rosetta_g_miss_num_map(ddx_fact_rec.forward_buy_quantity);
226 p0_a90 := ddx_fact_rec.status_code;
227 p0_a91 := ddx_fact_rec.hierarchy_type;
228 p0_a92 := ddx_fact_rec.approval_date;
229 p0_a93 := rosetta_g_miss_num_map(ddx_fact_rec.recommend_total_amount);
230 p0_a94 := rosetta_g_miss_num_map(ddx_fact_rec.recommend_hb_amount);
231 p0_a95 := rosetta_g_miss_num_map(ddx_fact_rec.request_total_amount);
232 p0_a96 := rosetta_g_miss_num_map(ddx_fact_rec.request_hb_amount);
233 p0_a97 := rosetta_g_miss_num_map(ddx_fact_rec.actual_total_amount);
234 p0_a98 := rosetta_g_miss_num_map(ddx_fact_rec.actual_hb_amount);
235 p0_a99 := rosetta_g_miss_num_map(ddx_fact_rec.base_total_pct);
236 p0_a100 := rosetta_g_miss_num_map(ddx_fact_rec.base_hb_pct);
237 end;
238
239 procedure create_actmetricfact(p_api_version NUMBER
240 , p_init_msg_list VARCHAR2
241 , p_commit VARCHAR2
242 , p_validation_level NUMBER
243 , x_return_status out nocopy VARCHAR2
244 , x_msg_count out nocopy NUMBER
245 , x_msg_data out nocopy VARCHAR2
246 , x_activity_metric_fact_id out nocopy NUMBER
247 , p7_a0 NUMBER := 0-1962.0724
248 , p7_a1 DATE := fnd_api.g_miss_date
249 , p7_a2 NUMBER := 0-1962.0724
250 , p7_a3 DATE := fnd_api.g_miss_date
251 , p7_a4 NUMBER := 0-1962.0724
252 , p7_a5 NUMBER := 0-1962.0724
253 , p7_a6 NUMBER := 0-1962.0724
254 , p7_a7 NUMBER := 0-1962.0724
255 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
256 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
257 , p7_a10 NUMBER := 0-1962.0724
258 , p7_a11 NUMBER := 0-1962.0724
259 , p7_a12 NUMBER := 0-1962.0724
260 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
261 , p7_a14 NUMBER := 0-1962.0724
262 , p7_a15 NUMBER := 0-1962.0724
263 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
264 , p7_a17 NUMBER := 0-1962.0724
265 , p7_a18 NUMBER := 0-1962.0724
266 , p7_a19 NUMBER := 0-1962.0724
267 , p7_a20 NUMBER := 0-1962.0724
268 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
269 , p7_a22 NUMBER := 0-1962.0724
270 , p7_a23 NUMBER := 0-1962.0724
271 , p7_a24 NUMBER := 0-1962.0724
272 , p7_a25 NUMBER := 0-1962.0724
273 , p7_a26 NUMBER := 0-1962.0724
274 , p7_a27 NUMBER := 0-1962.0724
275 , p7_a28 NUMBER := 0-1962.0724
276 , p7_a29 NUMBER := 0-1962.0724
277 , p7_a30 NUMBER := 0-1962.0724
278 , p7_a31 NUMBER := 0-1962.0724
279 , p7_a32 NUMBER := 0-1962.0724
280 , p7_a33 NUMBER := 0-1962.0724
281 , p7_a34 NUMBER := 0-1962.0724
282 , p7_a35 NUMBER := 0-1962.0724
283 , p7_a36 NUMBER := 0-1962.0724
284 , p7_a37 NUMBER := 0-1962.0724
285 , p7_a38 NUMBER := 0-1962.0724
286 , p7_a39 NUMBER := 0-1962.0724
287 , p7_a40 NUMBER := 0-1962.0724
288 , p7_a41 NUMBER := 0-1962.0724
289 , p7_a42 NUMBER := 0-1962.0724
290 , p7_a43 NUMBER := 0-1962.0724
291 , p7_a44 NUMBER := 0-1962.0724
292 , p7_a45 NUMBER := 0-1962.0724
293 , p7_a46 NUMBER := 0-1962.0724
294 , p7_a47 NUMBER := 0-1962.0724
295 , p7_a48 NUMBER := 0-1962.0724
296 , p7_a49 NUMBER := 0-1962.0724
297 , p7_a50 NUMBER := 0-1962.0724
298 , p7_a51 NUMBER := 0-1962.0724
299 , p7_a52 NUMBER := 0-1962.0724
300 , p7_a53 NUMBER := 0-1962.0724
301 , p7_a54 NUMBER := 0-1962.0724
302 , p7_a55 NUMBER := 0-1962.0724
303 , p7_a56 NUMBER := 0-1962.0724
304 , p7_a57 NUMBER := 0-1962.0724
305 , p7_a58 NUMBER := 0-1962.0724
306 , p7_a59 NUMBER := 0-1962.0724
307 , p7_a60 NUMBER := 0-1962.0724
308 , p7_a61 NUMBER := 0-1962.0724
309 , p7_a62 NUMBER := 0-1962.0724
310 , p7_a63 NUMBER := 0-1962.0724
311 , p7_a64 NUMBER := 0-1962.0724
312 , p7_a65 NUMBER := 0-1962.0724
313 , p7_a66 NUMBER := 0-1962.0724
314 , p7_a67 NUMBER := 0-1962.0724
315 , p7_a68 NUMBER := 0-1962.0724
316 , p7_a69 NUMBER := 0-1962.0724
317 , p7_a70 NUMBER := 0-1962.0724
318 , p7_a71 NUMBER := 0-1962.0724
319 , p7_a72 NUMBER := 0-1962.0724
320 , p7_a73 NUMBER := 0-1962.0724
321 , p7_a74 NUMBER := 0-1962.0724
322 , p7_a75 NUMBER := 0-1962.0724
323 , p7_a76 NUMBER := 0-1962.0724
324 , p7_a77 NUMBER := 0-1962.0724
325 , p7_a78 NUMBER := 0-1962.0724
326 , p7_a79 NUMBER := 0-1962.0724
327 , p7_a80 NUMBER := 0-1962.0724
328 , p7_a81 DATE := fnd_api.g_miss_date
329 , p7_a82 DATE := fnd_api.g_miss_date
330 , p7_a83 NUMBER := 0-1962.0724
331 , p7_a84 NUMBER := 0-1962.0724
332 , p7_a85 NUMBER := 0-1962.0724
333 , p7_a86 NUMBER := 0-1962.0724
334 , p7_a87 VARCHAR2 := fnd_api.g_miss_char
335 , p7_a88 VARCHAR2 := fnd_api.g_miss_char
336 , p7_a89 NUMBER := 0-1962.0724
337 , p7_a90 VARCHAR2 := fnd_api.g_miss_char
338 , p7_a91 VARCHAR2 := fnd_api.g_miss_char
339 , p7_a92 DATE := fnd_api.g_miss_date
340 , p7_a93 NUMBER := 0-1962.0724
341 , p7_a94 NUMBER := 0-1962.0724
342 , p7_a95 NUMBER := 0-1962.0724
343 , p7_a96 NUMBER := 0-1962.0724
344 , p7_a97 NUMBER := 0-1962.0724
345 , p7_a98 NUMBER := 0-1962.0724
346 , p7_a99 NUMBER := 0-1962.0724
347 , p7_a100 NUMBER := 0-1962.0724
348 )
349
350 as
351 ddp_act_metric_fact_rec ams_actmetricfact_pvt.act_metric_fact_rec_type;
352 ddindx binary_integer; indx binary_integer;
353 begin
354
355 -- copy data to the local IN or IN-OUT args, if any
356
357
358
359
360
361
362
363 ddp_act_metric_fact_rec.activity_metric_fact_id := rosetta_g_miss_num_map(p7_a0);
364 ddp_act_metric_fact_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
365 ddp_act_metric_fact_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
366 ddp_act_metric_fact_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
367 ddp_act_metric_fact_rec.created_by := rosetta_g_miss_num_map(p7_a4);
368 ddp_act_metric_fact_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
369 ddp_act_metric_fact_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
370 ddp_act_metric_fact_rec.act_metric_used_by_id := rosetta_g_miss_num_map(p7_a7);
371 ddp_act_metric_fact_rec.arc_act_metric_used_by := p7_a8;
372 ddp_act_metric_fact_rec.value_type := p7_a9;
373 ddp_act_metric_fact_rec.activity_metric_id := rosetta_g_miss_num_map(p7_a10);
374 ddp_act_metric_fact_rec.activity_geo_area_id := rosetta_g_miss_num_map(p7_a11);
375 ddp_act_metric_fact_rec.activity_product_id := rosetta_g_miss_num_map(p7_a12);
376 ddp_act_metric_fact_rec.transaction_currency_code := p7_a13;
377 ddp_act_metric_fact_rec.trans_forecasted_value := rosetta_g_miss_num_map(p7_a14);
378 ddp_act_metric_fact_rec.base_quantity := rosetta_g_miss_num_map(p7_a15);
379 ddp_act_metric_fact_rec.functional_currency_code := p7_a16;
380 ddp_act_metric_fact_rec.func_forecasted_value := rosetta_g_miss_num_map(p7_a17);
381 ddp_act_metric_fact_rec.org_id := rosetta_g_miss_num_map(p7_a18);
382 ddp_act_metric_fact_rec.de_metric_id := rosetta_g_miss_num_map(p7_a19);
383 ddp_act_metric_fact_rec.de_geographic_area_id := rosetta_g_miss_num_map(p7_a20);
384 ddp_act_metric_fact_rec.de_geographic_area_type := p7_a21;
385 ddp_act_metric_fact_rec.de_inventory_item_id := rosetta_g_miss_num_map(p7_a22);
386 ddp_act_metric_fact_rec.de_inventory_item_org_id := rosetta_g_miss_num_map(p7_a23);
387 ddp_act_metric_fact_rec.time_id1 := rosetta_g_miss_num_map(p7_a24);
388 ddp_act_metric_fact_rec.time_id2 := rosetta_g_miss_num_map(p7_a25);
389 ddp_act_metric_fact_rec.time_id3 := rosetta_g_miss_num_map(p7_a26);
390 ddp_act_metric_fact_rec.time_id4 := rosetta_g_miss_num_map(p7_a27);
391 ddp_act_metric_fact_rec.time_id5 := rosetta_g_miss_num_map(p7_a28);
392 ddp_act_metric_fact_rec.time_id6 := rosetta_g_miss_num_map(p7_a29);
393 ddp_act_metric_fact_rec.time_id7 := rosetta_g_miss_num_map(p7_a30);
394 ddp_act_metric_fact_rec.time_id8 := rosetta_g_miss_num_map(p7_a31);
395 ddp_act_metric_fact_rec.time_id9 := rosetta_g_miss_num_map(p7_a32);
396 ddp_act_metric_fact_rec.time_id10 := rosetta_g_miss_num_map(p7_a33);
397 ddp_act_metric_fact_rec.time_id11 := rosetta_g_miss_num_map(p7_a34);
398 ddp_act_metric_fact_rec.time_id12 := rosetta_g_miss_num_map(p7_a35);
399 ddp_act_metric_fact_rec.time_id13 := rosetta_g_miss_num_map(p7_a36);
400 ddp_act_metric_fact_rec.time_id14 := rosetta_g_miss_num_map(p7_a37);
401 ddp_act_metric_fact_rec.time_id15 := rosetta_g_miss_num_map(p7_a38);
402 ddp_act_metric_fact_rec.time_id16 := rosetta_g_miss_num_map(p7_a39);
403 ddp_act_metric_fact_rec.time_id17 := rosetta_g_miss_num_map(p7_a40);
404 ddp_act_metric_fact_rec.time_id18 := rosetta_g_miss_num_map(p7_a41);
405 ddp_act_metric_fact_rec.time_id19 := rosetta_g_miss_num_map(p7_a42);
406 ddp_act_metric_fact_rec.time_id20 := rosetta_g_miss_num_map(p7_a43);
407 ddp_act_metric_fact_rec.time_id21 := rosetta_g_miss_num_map(p7_a44);
408 ddp_act_metric_fact_rec.time_id22 := rosetta_g_miss_num_map(p7_a45);
409 ddp_act_metric_fact_rec.time_id23 := rosetta_g_miss_num_map(p7_a46);
410 ddp_act_metric_fact_rec.time_id24 := rosetta_g_miss_num_map(p7_a47);
411 ddp_act_metric_fact_rec.time_id25 := rosetta_g_miss_num_map(p7_a48);
412 ddp_act_metric_fact_rec.time_id26 := rosetta_g_miss_num_map(p7_a49);
413 ddp_act_metric_fact_rec.time_id27 := rosetta_g_miss_num_map(p7_a50);
414 ddp_act_metric_fact_rec.time_id28 := rosetta_g_miss_num_map(p7_a51);
415 ddp_act_metric_fact_rec.time_id29 := rosetta_g_miss_num_map(p7_a52);
416 ddp_act_metric_fact_rec.time_id30 := rosetta_g_miss_num_map(p7_a53);
417 ddp_act_metric_fact_rec.time_id31 := rosetta_g_miss_num_map(p7_a54);
418 ddp_act_metric_fact_rec.time_id32 := rosetta_g_miss_num_map(p7_a55);
419 ddp_act_metric_fact_rec.time_id33 := rosetta_g_miss_num_map(p7_a56);
420 ddp_act_metric_fact_rec.time_id34 := rosetta_g_miss_num_map(p7_a57);
421 ddp_act_metric_fact_rec.time_id35 := rosetta_g_miss_num_map(p7_a58);
422 ddp_act_metric_fact_rec.time_id36 := rosetta_g_miss_num_map(p7_a59);
423 ddp_act_metric_fact_rec.time_id37 := rosetta_g_miss_num_map(p7_a60);
424 ddp_act_metric_fact_rec.time_id38 := rosetta_g_miss_num_map(p7_a61);
425 ddp_act_metric_fact_rec.time_id39 := rosetta_g_miss_num_map(p7_a62);
426 ddp_act_metric_fact_rec.time_id40 := rosetta_g_miss_num_map(p7_a63);
427 ddp_act_metric_fact_rec.time_id41 := rosetta_g_miss_num_map(p7_a64);
428 ddp_act_metric_fact_rec.time_id42 := rosetta_g_miss_num_map(p7_a65);
429 ddp_act_metric_fact_rec.time_id43 := rosetta_g_miss_num_map(p7_a66);
430 ddp_act_metric_fact_rec.time_id44 := rosetta_g_miss_num_map(p7_a67);
431 ddp_act_metric_fact_rec.time_id45 := rosetta_g_miss_num_map(p7_a68);
432 ddp_act_metric_fact_rec.time_id46 := rosetta_g_miss_num_map(p7_a69);
433 ddp_act_metric_fact_rec.time_id47 := rosetta_g_miss_num_map(p7_a70);
434 ddp_act_metric_fact_rec.time_id48 := rosetta_g_miss_num_map(p7_a71);
435 ddp_act_metric_fact_rec.time_id49 := rosetta_g_miss_num_map(p7_a72);
436 ddp_act_metric_fact_rec.time_id50 := rosetta_g_miss_num_map(p7_a73);
437 ddp_act_metric_fact_rec.time_id51 := rosetta_g_miss_num_map(p7_a74);
438 ddp_act_metric_fact_rec.time_id52 := rosetta_g_miss_num_map(p7_a75);
439 ddp_act_metric_fact_rec.time_id53 := rosetta_g_miss_num_map(p7_a76);
440 ddp_act_metric_fact_rec.hierarchy_id := rosetta_g_miss_num_map(p7_a77);
441 ddp_act_metric_fact_rec.node_id := rosetta_g_miss_num_map(p7_a78);
442 ddp_act_metric_fact_rec.level_depth := rosetta_g_miss_num_map(p7_a79);
443 ddp_act_metric_fact_rec.formula_id := rosetta_g_miss_num_map(p7_a80);
444 ddp_act_metric_fact_rec.from_date := rosetta_g_miss_date_in_map(p7_a81);
445 ddp_act_metric_fact_rec.to_date := rosetta_g_miss_date_in_map(p7_a82);
446 ddp_act_metric_fact_rec.fact_value := rosetta_g_miss_num_map(p7_a83);
447 ddp_act_metric_fact_rec.fact_percent := rosetta_g_miss_num_map(p7_a84);
448 ddp_act_metric_fact_rec.root_fact_id := rosetta_g_miss_num_map(p7_a85);
449 ddp_act_metric_fact_rec.previous_fact_id := rosetta_g_miss_num_map(p7_a86);
450 ddp_act_metric_fact_rec.fact_type := p7_a87;
451 ddp_act_metric_fact_rec.fact_reference := p7_a88;
452 ddp_act_metric_fact_rec.forward_buy_quantity := rosetta_g_miss_num_map(p7_a89);
453 ddp_act_metric_fact_rec.status_code := p7_a90;
454 ddp_act_metric_fact_rec.hierarchy_type := p7_a91;
455 ddp_act_metric_fact_rec.approval_date := rosetta_g_miss_date_in_map(p7_a92);
456 ddp_act_metric_fact_rec.recommend_total_amount := rosetta_g_miss_num_map(p7_a93);
457 ddp_act_metric_fact_rec.recommend_hb_amount := rosetta_g_miss_num_map(p7_a94);
458 ddp_act_metric_fact_rec.request_total_amount := rosetta_g_miss_num_map(p7_a95);
459 ddp_act_metric_fact_rec.request_hb_amount := rosetta_g_miss_num_map(p7_a96);
460 ddp_act_metric_fact_rec.actual_total_amount := rosetta_g_miss_num_map(p7_a97);
461 ddp_act_metric_fact_rec.actual_hb_amount := rosetta_g_miss_num_map(p7_a98);
462 ddp_act_metric_fact_rec.base_total_pct := rosetta_g_miss_num_map(p7_a99);
463 ddp_act_metric_fact_rec.base_hb_pct := rosetta_g_miss_num_map(p7_a100);
464
465
466 -- here's the delegated call to the old PL/SQL routine
467 ams_actmetricfact_pvt.create_actmetricfact(p_api_version,
468 p_init_msg_list,
469 p_commit,
470 p_validation_level,
471 x_return_status,
472 x_msg_count,
473 x_msg_data,
474 ddp_act_metric_fact_rec,
475 x_activity_metric_fact_id);
476
477 -- copy data back from the local variables to OUT or IN-OUT args, if any
478
479
480
481
482
483
484
485
486 end;
487
488 procedure update_actmetricfact(p_api_version NUMBER
489 , p_init_msg_list VARCHAR2
490 , p_commit VARCHAR2
491 , p_validation_level NUMBER
492 , x_return_status out nocopy VARCHAR2
493 , x_msg_count out nocopy NUMBER
494 , x_msg_data out nocopy VARCHAR2
495 , p7_a0 NUMBER := 0-1962.0724
496 , p7_a1 DATE := fnd_api.g_miss_date
497 , p7_a2 NUMBER := 0-1962.0724
498 , p7_a3 DATE := fnd_api.g_miss_date
499 , p7_a4 NUMBER := 0-1962.0724
500 , p7_a5 NUMBER := 0-1962.0724
501 , p7_a6 NUMBER := 0-1962.0724
502 , p7_a7 NUMBER := 0-1962.0724
503 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
504 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
505 , p7_a10 NUMBER := 0-1962.0724
506 , p7_a11 NUMBER := 0-1962.0724
507 , p7_a12 NUMBER := 0-1962.0724
508 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
509 , p7_a14 NUMBER := 0-1962.0724
510 , p7_a15 NUMBER := 0-1962.0724
511 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
512 , p7_a17 NUMBER := 0-1962.0724
513 , p7_a18 NUMBER := 0-1962.0724
514 , p7_a19 NUMBER := 0-1962.0724
515 , p7_a20 NUMBER := 0-1962.0724
516 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
517 , p7_a22 NUMBER := 0-1962.0724
518 , p7_a23 NUMBER := 0-1962.0724
519 , p7_a24 NUMBER := 0-1962.0724
520 , p7_a25 NUMBER := 0-1962.0724
521 , p7_a26 NUMBER := 0-1962.0724
522 , p7_a27 NUMBER := 0-1962.0724
523 , p7_a28 NUMBER := 0-1962.0724
524 , p7_a29 NUMBER := 0-1962.0724
525 , p7_a30 NUMBER := 0-1962.0724
526 , p7_a31 NUMBER := 0-1962.0724
527 , p7_a32 NUMBER := 0-1962.0724
528 , p7_a33 NUMBER := 0-1962.0724
529 , p7_a34 NUMBER := 0-1962.0724
530 , p7_a35 NUMBER := 0-1962.0724
531 , p7_a36 NUMBER := 0-1962.0724
532 , p7_a37 NUMBER := 0-1962.0724
533 , p7_a38 NUMBER := 0-1962.0724
534 , p7_a39 NUMBER := 0-1962.0724
535 , p7_a40 NUMBER := 0-1962.0724
536 , p7_a41 NUMBER := 0-1962.0724
537 , p7_a42 NUMBER := 0-1962.0724
538 , p7_a43 NUMBER := 0-1962.0724
539 , p7_a44 NUMBER := 0-1962.0724
540 , p7_a45 NUMBER := 0-1962.0724
541 , p7_a46 NUMBER := 0-1962.0724
542 , p7_a47 NUMBER := 0-1962.0724
543 , p7_a48 NUMBER := 0-1962.0724
544 , p7_a49 NUMBER := 0-1962.0724
545 , p7_a50 NUMBER := 0-1962.0724
546 , p7_a51 NUMBER := 0-1962.0724
547 , p7_a52 NUMBER := 0-1962.0724
548 , p7_a53 NUMBER := 0-1962.0724
549 , p7_a54 NUMBER := 0-1962.0724
550 , p7_a55 NUMBER := 0-1962.0724
551 , p7_a56 NUMBER := 0-1962.0724
552 , p7_a57 NUMBER := 0-1962.0724
553 , p7_a58 NUMBER := 0-1962.0724
554 , p7_a59 NUMBER := 0-1962.0724
555 , p7_a60 NUMBER := 0-1962.0724
556 , p7_a61 NUMBER := 0-1962.0724
557 , p7_a62 NUMBER := 0-1962.0724
558 , p7_a63 NUMBER := 0-1962.0724
559 , p7_a64 NUMBER := 0-1962.0724
560 , p7_a65 NUMBER := 0-1962.0724
561 , p7_a66 NUMBER := 0-1962.0724
562 , p7_a67 NUMBER := 0-1962.0724
563 , p7_a68 NUMBER := 0-1962.0724
564 , p7_a69 NUMBER := 0-1962.0724
565 , p7_a70 NUMBER := 0-1962.0724
566 , p7_a71 NUMBER := 0-1962.0724
567 , p7_a72 NUMBER := 0-1962.0724
568 , p7_a73 NUMBER := 0-1962.0724
569 , p7_a74 NUMBER := 0-1962.0724
570 , p7_a75 NUMBER := 0-1962.0724
571 , p7_a76 NUMBER := 0-1962.0724
572 , p7_a77 NUMBER := 0-1962.0724
573 , p7_a78 NUMBER := 0-1962.0724
574 , p7_a79 NUMBER := 0-1962.0724
575 , p7_a80 NUMBER := 0-1962.0724
576 , p7_a81 DATE := fnd_api.g_miss_date
577 , p7_a82 DATE := fnd_api.g_miss_date
578 , p7_a83 NUMBER := 0-1962.0724
579 , p7_a84 NUMBER := 0-1962.0724
580 , p7_a85 NUMBER := 0-1962.0724
581 , p7_a86 NUMBER := 0-1962.0724
582 , p7_a87 VARCHAR2 := fnd_api.g_miss_char
583 , p7_a88 VARCHAR2 := fnd_api.g_miss_char
584 , p7_a89 NUMBER := 0-1962.0724
585 , p7_a90 VARCHAR2 := fnd_api.g_miss_char
586 , p7_a91 VARCHAR2 := fnd_api.g_miss_char
587 , p7_a92 DATE := fnd_api.g_miss_date
588 , p7_a93 NUMBER := 0-1962.0724
589 , p7_a94 NUMBER := 0-1962.0724
590 , p7_a95 NUMBER := 0-1962.0724
591 , p7_a96 NUMBER := 0-1962.0724
592 , p7_a97 NUMBER := 0-1962.0724
593 , p7_a98 NUMBER := 0-1962.0724
594 , p7_a99 NUMBER := 0-1962.0724
595 , p7_a100 NUMBER := 0-1962.0724
596 )
597
598 as
599 ddp_act_metric_fact_rec ams_actmetricfact_pvt.act_metric_fact_rec_type;
600 ddindx binary_integer; indx binary_integer;
601 begin
602
603 -- copy data to the local IN or IN-OUT args, if any
604
605
606
607
608
609
610
611 ddp_act_metric_fact_rec.activity_metric_fact_id := rosetta_g_miss_num_map(p7_a0);
612 ddp_act_metric_fact_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
613 ddp_act_metric_fact_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
614 ddp_act_metric_fact_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
615 ddp_act_metric_fact_rec.created_by := rosetta_g_miss_num_map(p7_a4);
616 ddp_act_metric_fact_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
617 ddp_act_metric_fact_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
618 ddp_act_metric_fact_rec.act_metric_used_by_id := rosetta_g_miss_num_map(p7_a7);
619 ddp_act_metric_fact_rec.arc_act_metric_used_by := p7_a8;
620 ddp_act_metric_fact_rec.value_type := p7_a9;
621 ddp_act_metric_fact_rec.activity_metric_id := rosetta_g_miss_num_map(p7_a10);
622 ddp_act_metric_fact_rec.activity_geo_area_id := rosetta_g_miss_num_map(p7_a11);
623 ddp_act_metric_fact_rec.activity_product_id := rosetta_g_miss_num_map(p7_a12);
624 ddp_act_metric_fact_rec.transaction_currency_code := p7_a13;
625 ddp_act_metric_fact_rec.trans_forecasted_value := rosetta_g_miss_num_map(p7_a14);
626 ddp_act_metric_fact_rec.base_quantity := rosetta_g_miss_num_map(p7_a15);
627 ddp_act_metric_fact_rec.functional_currency_code := p7_a16;
628 ddp_act_metric_fact_rec.func_forecasted_value := rosetta_g_miss_num_map(p7_a17);
629 ddp_act_metric_fact_rec.org_id := rosetta_g_miss_num_map(p7_a18);
630 ddp_act_metric_fact_rec.de_metric_id := rosetta_g_miss_num_map(p7_a19);
631 ddp_act_metric_fact_rec.de_geographic_area_id := rosetta_g_miss_num_map(p7_a20);
632 ddp_act_metric_fact_rec.de_geographic_area_type := p7_a21;
633 ddp_act_metric_fact_rec.de_inventory_item_id := rosetta_g_miss_num_map(p7_a22);
634 ddp_act_metric_fact_rec.de_inventory_item_org_id := rosetta_g_miss_num_map(p7_a23);
635 ddp_act_metric_fact_rec.time_id1 := rosetta_g_miss_num_map(p7_a24);
636 ddp_act_metric_fact_rec.time_id2 := rosetta_g_miss_num_map(p7_a25);
637 ddp_act_metric_fact_rec.time_id3 := rosetta_g_miss_num_map(p7_a26);
638 ddp_act_metric_fact_rec.time_id4 := rosetta_g_miss_num_map(p7_a27);
639 ddp_act_metric_fact_rec.time_id5 := rosetta_g_miss_num_map(p7_a28);
640 ddp_act_metric_fact_rec.time_id6 := rosetta_g_miss_num_map(p7_a29);
641 ddp_act_metric_fact_rec.time_id7 := rosetta_g_miss_num_map(p7_a30);
642 ddp_act_metric_fact_rec.time_id8 := rosetta_g_miss_num_map(p7_a31);
643 ddp_act_metric_fact_rec.time_id9 := rosetta_g_miss_num_map(p7_a32);
644 ddp_act_metric_fact_rec.time_id10 := rosetta_g_miss_num_map(p7_a33);
645 ddp_act_metric_fact_rec.time_id11 := rosetta_g_miss_num_map(p7_a34);
646 ddp_act_metric_fact_rec.time_id12 := rosetta_g_miss_num_map(p7_a35);
647 ddp_act_metric_fact_rec.time_id13 := rosetta_g_miss_num_map(p7_a36);
648 ddp_act_metric_fact_rec.time_id14 := rosetta_g_miss_num_map(p7_a37);
649 ddp_act_metric_fact_rec.time_id15 := rosetta_g_miss_num_map(p7_a38);
650 ddp_act_metric_fact_rec.time_id16 := rosetta_g_miss_num_map(p7_a39);
651 ddp_act_metric_fact_rec.time_id17 := rosetta_g_miss_num_map(p7_a40);
652 ddp_act_metric_fact_rec.time_id18 := rosetta_g_miss_num_map(p7_a41);
653 ddp_act_metric_fact_rec.time_id19 := rosetta_g_miss_num_map(p7_a42);
654 ddp_act_metric_fact_rec.time_id20 := rosetta_g_miss_num_map(p7_a43);
655 ddp_act_metric_fact_rec.time_id21 := rosetta_g_miss_num_map(p7_a44);
656 ddp_act_metric_fact_rec.time_id22 := rosetta_g_miss_num_map(p7_a45);
657 ddp_act_metric_fact_rec.time_id23 := rosetta_g_miss_num_map(p7_a46);
658 ddp_act_metric_fact_rec.time_id24 := rosetta_g_miss_num_map(p7_a47);
659 ddp_act_metric_fact_rec.time_id25 := rosetta_g_miss_num_map(p7_a48);
660 ddp_act_metric_fact_rec.time_id26 := rosetta_g_miss_num_map(p7_a49);
661 ddp_act_metric_fact_rec.time_id27 := rosetta_g_miss_num_map(p7_a50);
662 ddp_act_metric_fact_rec.time_id28 := rosetta_g_miss_num_map(p7_a51);
663 ddp_act_metric_fact_rec.time_id29 := rosetta_g_miss_num_map(p7_a52);
664 ddp_act_metric_fact_rec.time_id30 := rosetta_g_miss_num_map(p7_a53);
665 ddp_act_metric_fact_rec.time_id31 := rosetta_g_miss_num_map(p7_a54);
666 ddp_act_metric_fact_rec.time_id32 := rosetta_g_miss_num_map(p7_a55);
667 ddp_act_metric_fact_rec.time_id33 := rosetta_g_miss_num_map(p7_a56);
668 ddp_act_metric_fact_rec.time_id34 := rosetta_g_miss_num_map(p7_a57);
669 ddp_act_metric_fact_rec.time_id35 := rosetta_g_miss_num_map(p7_a58);
670 ddp_act_metric_fact_rec.time_id36 := rosetta_g_miss_num_map(p7_a59);
671 ddp_act_metric_fact_rec.time_id37 := rosetta_g_miss_num_map(p7_a60);
672 ddp_act_metric_fact_rec.time_id38 := rosetta_g_miss_num_map(p7_a61);
673 ddp_act_metric_fact_rec.time_id39 := rosetta_g_miss_num_map(p7_a62);
674 ddp_act_metric_fact_rec.time_id40 := rosetta_g_miss_num_map(p7_a63);
675 ddp_act_metric_fact_rec.time_id41 := rosetta_g_miss_num_map(p7_a64);
676 ddp_act_metric_fact_rec.time_id42 := rosetta_g_miss_num_map(p7_a65);
677 ddp_act_metric_fact_rec.time_id43 := rosetta_g_miss_num_map(p7_a66);
678 ddp_act_metric_fact_rec.time_id44 := rosetta_g_miss_num_map(p7_a67);
679 ddp_act_metric_fact_rec.time_id45 := rosetta_g_miss_num_map(p7_a68);
680 ddp_act_metric_fact_rec.time_id46 := rosetta_g_miss_num_map(p7_a69);
681 ddp_act_metric_fact_rec.time_id47 := rosetta_g_miss_num_map(p7_a70);
682 ddp_act_metric_fact_rec.time_id48 := rosetta_g_miss_num_map(p7_a71);
683 ddp_act_metric_fact_rec.time_id49 := rosetta_g_miss_num_map(p7_a72);
684 ddp_act_metric_fact_rec.time_id50 := rosetta_g_miss_num_map(p7_a73);
685 ddp_act_metric_fact_rec.time_id51 := rosetta_g_miss_num_map(p7_a74);
686 ddp_act_metric_fact_rec.time_id52 := rosetta_g_miss_num_map(p7_a75);
687 ddp_act_metric_fact_rec.time_id53 := rosetta_g_miss_num_map(p7_a76);
688 ddp_act_metric_fact_rec.hierarchy_id := rosetta_g_miss_num_map(p7_a77);
689 ddp_act_metric_fact_rec.node_id := rosetta_g_miss_num_map(p7_a78);
690 ddp_act_metric_fact_rec.level_depth := rosetta_g_miss_num_map(p7_a79);
691 ddp_act_metric_fact_rec.formula_id := rosetta_g_miss_num_map(p7_a80);
692 ddp_act_metric_fact_rec.from_date := rosetta_g_miss_date_in_map(p7_a81);
693 ddp_act_metric_fact_rec.to_date := rosetta_g_miss_date_in_map(p7_a82);
694 ddp_act_metric_fact_rec.fact_value := rosetta_g_miss_num_map(p7_a83);
695 ddp_act_metric_fact_rec.fact_percent := rosetta_g_miss_num_map(p7_a84);
696 ddp_act_metric_fact_rec.root_fact_id := rosetta_g_miss_num_map(p7_a85);
697 ddp_act_metric_fact_rec.previous_fact_id := rosetta_g_miss_num_map(p7_a86);
698 ddp_act_metric_fact_rec.fact_type := p7_a87;
699 ddp_act_metric_fact_rec.fact_reference := p7_a88;
700 ddp_act_metric_fact_rec.forward_buy_quantity := rosetta_g_miss_num_map(p7_a89);
701 ddp_act_metric_fact_rec.status_code := p7_a90;
702 ddp_act_metric_fact_rec.hierarchy_type := p7_a91;
703 ddp_act_metric_fact_rec.approval_date := rosetta_g_miss_date_in_map(p7_a92);
704 ddp_act_metric_fact_rec.recommend_total_amount := rosetta_g_miss_num_map(p7_a93);
705 ddp_act_metric_fact_rec.recommend_hb_amount := rosetta_g_miss_num_map(p7_a94);
706 ddp_act_metric_fact_rec.request_total_amount := rosetta_g_miss_num_map(p7_a95);
707 ddp_act_metric_fact_rec.request_hb_amount := rosetta_g_miss_num_map(p7_a96);
708 ddp_act_metric_fact_rec.actual_total_amount := rosetta_g_miss_num_map(p7_a97);
709 ddp_act_metric_fact_rec.actual_hb_amount := rosetta_g_miss_num_map(p7_a98);
710 ddp_act_metric_fact_rec.base_total_pct := rosetta_g_miss_num_map(p7_a99);
711 ddp_act_metric_fact_rec.base_hb_pct := rosetta_g_miss_num_map(p7_a100);
712
713 -- here's the delegated call to the old PL/SQL routine
714 ams_actmetricfact_pvt.update_actmetricfact(p_api_version,
715 p_init_msg_list,
716 p_commit,
717 p_validation_level,
718 x_return_status,
719 x_msg_count,
720 x_msg_data,
721 ddp_act_metric_fact_rec);
722
723 -- copy data back from the local variables to OUT or IN-OUT args, if any
724
725
726
727
728
729
730
731 end;
732
733 procedure validate_actmetfact(p_api_version NUMBER
734 , p_init_msg_list VARCHAR2
735 , p_validation_level NUMBER
736 , x_return_status out nocopy VARCHAR2
737 , x_msg_count out nocopy NUMBER
738 , x_msg_data out nocopy VARCHAR2
739 , p6_a0 NUMBER := 0-1962.0724
740 , p6_a1 DATE := fnd_api.g_miss_date
741 , p6_a2 NUMBER := 0-1962.0724
742 , p6_a3 DATE := fnd_api.g_miss_date
743 , p6_a4 NUMBER := 0-1962.0724
744 , p6_a5 NUMBER := 0-1962.0724
745 , p6_a6 NUMBER := 0-1962.0724
746 , p6_a7 NUMBER := 0-1962.0724
747 , p6_a8 VARCHAR2 := fnd_api.g_miss_char
748 , p6_a9 VARCHAR2 := fnd_api.g_miss_char
749 , p6_a10 NUMBER := 0-1962.0724
750 , p6_a11 NUMBER := 0-1962.0724
751 , p6_a12 NUMBER := 0-1962.0724
752 , p6_a13 VARCHAR2 := fnd_api.g_miss_char
753 , p6_a14 NUMBER := 0-1962.0724
754 , p6_a15 NUMBER := 0-1962.0724
755 , p6_a16 VARCHAR2 := fnd_api.g_miss_char
756 , p6_a17 NUMBER := 0-1962.0724
757 , p6_a18 NUMBER := 0-1962.0724
758 , p6_a19 NUMBER := 0-1962.0724
759 , p6_a20 NUMBER := 0-1962.0724
760 , p6_a21 VARCHAR2 := fnd_api.g_miss_char
761 , p6_a22 NUMBER := 0-1962.0724
762 , p6_a23 NUMBER := 0-1962.0724
763 , p6_a24 NUMBER := 0-1962.0724
764 , p6_a25 NUMBER := 0-1962.0724
765 , p6_a26 NUMBER := 0-1962.0724
766 , p6_a27 NUMBER := 0-1962.0724
767 , p6_a28 NUMBER := 0-1962.0724
768 , p6_a29 NUMBER := 0-1962.0724
769 , p6_a30 NUMBER := 0-1962.0724
770 , p6_a31 NUMBER := 0-1962.0724
771 , p6_a32 NUMBER := 0-1962.0724
772 , p6_a33 NUMBER := 0-1962.0724
773 , p6_a34 NUMBER := 0-1962.0724
774 , p6_a35 NUMBER := 0-1962.0724
775 , p6_a36 NUMBER := 0-1962.0724
776 , p6_a37 NUMBER := 0-1962.0724
777 , p6_a38 NUMBER := 0-1962.0724
778 , p6_a39 NUMBER := 0-1962.0724
779 , p6_a40 NUMBER := 0-1962.0724
780 , p6_a41 NUMBER := 0-1962.0724
781 , p6_a42 NUMBER := 0-1962.0724
782 , p6_a43 NUMBER := 0-1962.0724
783 , p6_a44 NUMBER := 0-1962.0724
784 , p6_a45 NUMBER := 0-1962.0724
785 , p6_a46 NUMBER := 0-1962.0724
786 , p6_a47 NUMBER := 0-1962.0724
787 , p6_a48 NUMBER := 0-1962.0724
788 , p6_a49 NUMBER := 0-1962.0724
789 , p6_a50 NUMBER := 0-1962.0724
790 , p6_a51 NUMBER := 0-1962.0724
791 , p6_a52 NUMBER := 0-1962.0724
792 , p6_a53 NUMBER := 0-1962.0724
793 , p6_a54 NUMBER := 0-1962.0724
794 , p6_a55 NUMBER := 0-1962.0724
795 , p6_a56 NUMBER := 0-1962.0724
796 , p6_a57 NUMBER := 0-1962.0724
797 , p6_a58 NUMBER := 0-1962.0724
798 , p6_a59 NUMBER := 0-1962.0724
799 , p6_a60 NUMBER := 0-1962.0724
800 , p6_a61 NUMBER := 0-1962.0724
801 , p6_a62 NUMBER := 0-1962.0724
802 , p6_a63 NUMBER := 0-1962.0724
803 , p6_a64 NUMBER := 0-1962.0724
804 , p6_a65 NUMBER := 0-1962.0724
805 , p6_a66 NUMBER := 0-1962.0724
806 , p6_a67 NUMBER := 0-1962.0724
807 , p6_a68 NUMBER := 0-1962.0724
808 , p6_a69 NUMBER := 0-1962.0724
809 , p6_a70 NUMBER := 0-1962.0724
810 , p6_a71 NUMBER := 0-1962.0724
811 , p6_a72 NUMBER := 0-1962.0724
812 , p6_a73 NUMBER := 0-1962.0724
813 , p6_a74 NUMBER := 0-1962.0724
814 , p6_a75 NUMBER := 0-1962.0724
815 , p6_a76 NUMBER := 0-1962.0724
816 , p6_a77 NUMBER := 0-1962.0724
817 , p6_a78 NUMBER := 0-1962.0724
818 , p6_a79 NUMBER := 0-1962.0724
819 , p6_a80 NUMBER := 0-1962.0724
820 , p6_a81 DATE := fnd_api.g_miss_date
821 , p6_a82 DATE := fnd_api.g_miss_date
822 , p6_a83 NUMBER := 0-1962.0724
823 , p6_a84 NUMBER := 0-1962.0724
824 , p6_a85 NUMBER := 0-1962.0724
825 , p6_a86 NUMBER := 0-1962.0724
826 , p6_a87 VARCHAR2 := fnd_api.g_miss_char
827 , p6_a88 VARCHAR2 := fnd_api.g_miss_char
828 , p6_a89 NUMBER := 0-1962.0724
829 , p6_a90 VARCHAR2 := fnd_api.g_miss_char
830 , p6_a91 VARCHAR2 := fnd_api.g_miss_char
831 , p6_a92 DATE := fnd_api.g_miss_date
832 , p6_a93 NUMBER := 0-1962.0724
833 , p6_a94 NUMBER := 0-1962.0724
834 , p6_a95 NUMBER := 0-1962.0724
835 , p6_a96 NUMBER := 0-1962.0724
836 , p6_a97 NUMBER := 0-1962.0724
837 , p6_a98 NUMBER := 0-1962.0724
838 , p6_a99 NUMBER := 0-1962.0724
839 , p6_a100 NUMBER := 0-1962.0724
840 )
841
842 as
843 ddp_act_metric_fact_rec ams_actmetricfact_pvt.act_metric_fact_rec_type;
844 ddindx binary_integer; indx binary_integer;
845 begin
846
847 -- copy data to the local IN or IN-OUT args, if any
848
849
850
851
852
853
854 ddp_act_metric_fact_rec.activity_metric_fact_id := rosetta_g_miss_num_map(p6_a0);
855 ddp_act_metric_fact_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a1);
856 ddp_act_metric_fact_rec.last_updated_by := rosetta_g_miss_num_map(p6_a2);
857 ddp_act_metric_fact_rec.creation_date := rosetta_g_miss_date_in_map(p6_a3);
858 ddp_act_metric_fact_rec.created_by := rosetta_g_miss_num_map(p6_a4);
859 ddp_act_metric_fact_rec.last_update_login := rosetta_g_miss_num_map(p6_a5);
860 ddp_act_metric_fact_rec.object_version_number := rosetta_g_miss_num_map(p6_a6);
861 ddp_act_metric_fact_rec.act_metric_used_by_id := rosetta_g_miss_num_map(p6_a7);
862 ddp_act_metric_fact_rec.arc_act_metric_used_by := p6_a8;
863 ddp_act_metric_fact_rec.value_type := p6_a9;
864 ddp_act_metric_fact_rec.activity_metric_id := rosetta_g_miss_num_map(p6_a10);
865 ddp_act_metric_fact_rec.activity_geo_area_id := rosetta_g_miss_num_map(p6_a11);
866 ddp_act_metric_fact_rec.activity_product_id := rosetta_g_miss_num_map(p6_a12);
867 ddp_act_metric_fact_rec.transaction_currency_code := p6_a13;
868 ddp_act_metric_fact_rec.trans_forecasted_value := rosetta_g_miss_num_map(p6_a14);
869 ddp_act_metric_fact_rec.base_quantity := rosetta_g_miss_num_map(p6_a15);
870 ddp_act_metric_fact_rec.functional_currency_code := p6_a16;
871 ddp_act_metric_fact_rec.func_forecasted_value := rosetta_g_miss_num_map(p6_a17);
872 ddp_act_metric_fact_rec.org_id := rosetta_g_miss_num_map(p6_a18);
873 ddp_act_metric_fact_rec.de_metric_id := rosetta_g_miss_num_map(p6_a19);
874 ddp_act_metric_fact_rec.de_geographic_area_id := rosetta_g_miss_num_map(p6_a20);
875 ddp_act_metric_fact_rec.de_geographic_area_type := p6_a21;
876 ddp_act_metric_fact_rec.de_inventory_item_id := rosetta_g_miss_num_map(p6_a22);
877 ddp_act_metric_fact_rec.de_inventory_item_org_id := rosetta_g_miss_num_map(p6_a23);
878 ddp_act_metric_fact_rec.time_id1 := rosetta_g_miss_num_map(p6_a24);
879 ddp_act_metric_fact_rec.time_id2 := rosetta_g_miss_num_map(p6_a25);
880 ddp_act_metric_fact_rec.time_id3 := rosetta_g_miss_num_map(p6_a26);
881 ddp_act_metric_fact_rec.time_id4 := rosetta_g_miss_num_map(p6_a27);
882 ddp_act_metric_fact_rec.time_id5 := rosetta_g_miss_num_map(p6_a28);
883 ddp_act_metric_fact_rec.time_id6 := rosetta_g_miss_num_map(p6_a29);
884 ddp_act_metric_fact_rec.time_id7 := rosetta_g_miss_num_map(p6_a30);
885 ddp_act_metric_fact_rec.time_id8 := rosetta_g_miss_num_map(p6_a31);
886 ddp_act_metric_fact_rec.time_id9 := rosetta_g_miss_num_map(p6_a32);
887 ddp_act_metric_fact_rec.time_id10 := rosetta_g_miss_num_map(p6_a33);
888 ddp_act_metric_fact_rec.time_id11 := rosetta_g_miss_num_map(p6_a34);
889 ddp_act_metric_fact_rec.time_id12 := rosetta_g_miss_num_map(p6_a35);
890 ddp_act_metric_fact_rec.time_id13 := rosetta_g_miss_num_map(p6_a36);
891 ddp_act_metric_fact_rec.time_id14 := rosetta_g_miss_num_map(p6_a37);
892 ddp_act_metric_fact_rec.time_id15 := rosetta_g_miss_num_map(p6_a38);
893 ddp_act_metric_fact_rec.time_id16 := rosetta_g_miss_num_map(p6_a39);
894 ddp_act_metric_fact_rec.time_id17 := rosetta_g_miss_num_map(p6_a40);
895 ddp_act_metric_fact_rec.time_id18 := rosetta_g_miss_num_map(p6_a41);
896 ddp_act_metric_fact_rec.time_id19 := rosetta_g_miss_num_map(p6_a42);
897 ddp_act_metric_fact_rec.time_id20 := rosetta_g_miss_num_map(p6_a43);
898 ddp_act_metric_fact_rec.time_id21 := rosetta_g_miss_num_map(p6_a44);
899 ddp_act_metric_fact_rec.time_id22 := rosetta_g_miss_num_map(p6_a45);
900 ddp_act_metric_fact_rec.time_id23 := rosetta_g_miss_num_map(p6_a46);
901 ddp_act_metric_fact_rec.time_id24 := rosetta_g_miss_num_map(p6_a47);
902 ddp_act_metric_fact_rec.time_id25 := rosetta_g_miss_num_map(p6_a48);
903 ddp_act_metric_fact_rec.time_id26 := rosetta_g_miss_num_map(p6_a49);
904 ddp_act_metric_fact_rec.time_id27 := rosetta_g_miss_num_map(p6_a50);
905 ddp_act_metric_fact_rec.time_id28 := rosetta_g_miss_num_map(p6_a51);
906 ddp_act_metric_fact_rec.time_id29 := rosetta_g_miss_num_map(p6_a52);
907 ddp_act_metric_fact_rec.time_id30 := rosetta_g_miss_num_map(p6_a53);
908 ddp_act_metric_fact_rec.time_id31 := rosetta_g_miss_num_map(p6_a54);
909 ddp_act_metric_fact_rec.time_id32 := rosetta_g_miss_num_map(p6_a55);
910 ddp_act_metric_fact_rec.time_id33 := rosetta_g_miss_num_map(p6_a56);
911 ddp_act_metric_fact_rec.time_id34 := rosetta_g_miss_num_map(p6_a57);
912 ddp_act_metric_fact_rec.time_id35 := rosetta_g_miss_num_map(p6_a58);
913 ddp_act_metric_fact_rec.time_id36 := rosetta_g_miss_num_map(p6_a59);
914 ddp_act_metric_fact_rec.time_id37 := rosetta_g_miss_num_map(p6_a60);
915 ddp_act_metric_fact_rec.time_id38 := rosetta_g_miss_num_map(p6_a61);
916 ddp_act_metric_fact_rec.time_id39 := rosetta_g_miss_num_map(p6_a62);
917 ddp_act_metric_fact_rec.time_id40 := rosetta_g_miss_num_map(p6_a63);
918 ddp_act_metric_fact_rec.time_id41 := rosetta_g_miss_num_map(p6_a64);
919 ddp_act_metric_fact_rec.time_id42 := rosetta_g_miss_num_map(p6_a65);
920 ddp_act_metric_fact_rec.time_id43 := rosetta_g_miss_num_map(p6_a66);
921 ddp_act_metric_fact_rec.time_id44 := rosetta_g_miss_num_map(p6_a67);
922 ddp_act_metric_fact_rec.time_id45 := rosetta_g_miss_num_map(p6_a68);
923 ddp_act_metric_fact_rec.time_id46 := rosetta_g_miss_num_map(p6_a69);
924 ddp_act_metric_fact_rec.time_id47 := rosetta_g_miss_num_map(p6_a70);
925 ddp_act_metric_fact_rec.time_id48 := rosetta_g_miss_num_map(p6_a71);
926 ddp_act_metric_fact_rec.time_id49 := rosetta_g_miss_num_map(p6_a72);
927 ddp_act_metric_fact_rec.time_id50 := rosetta_g_miss_num_map(p6_a73);
928 ddp_act_metric_fact_rec.time_id51 := rosetta_g_miss_num_map(p6_a74);
929 ddp_act_metric_fact_rec.time_id52 := rosetta_g_miss_num_map(p6_a75);
930 ddp_act_metric_fact_rec.time_id53 := rosetta_g_miss_num_map(p6_a76);
931 ddp_act_metric_fact_rec.hierarchy_id := rosetta_g_miss_num_map(p6_a77);
932 ddp_act_metric_fact_rec.node_id := rosetta_g_miss_num_map(p6_a78);
933 ddp_act_metric_fact_rec.level_depth := rosetta_g_miss_num_map(p6_a79);
934 ddp_act_metric_fact_rec.formula_id := rosetta_g_miss_num_map(p6_a80);
935 ddp_act_metric_fact_rec.from_date := rosetta_g_miss_date_in_map(p6_a81);
936 ddp_act_metric_fact_rec.to_date := rosetta_g_miss_date_in_map(p6_a82);
937 ddp_act_metric_fact_rec.fact_value := rosetta_g_miss_num_map(p6_a83);
938 ddp_act_metric_fact_rec.fact_percent := rosetta_g_miss_num_map(p6_a84);
939 ddp_act_metric_fact_rec.root_fact_id := rosetta_g_miss_num_map(p6_a85);
940 ddp_act_metric_fact_rec.previous_fact_id := rosetta_g_miss_num_map(p6_a86);
941 ddp_act_metric_fact_rec.fact_type := p6_a87;
942 ddp_act_metric_fact_rec.fact_reference := p6_a88;
943 ddp_act_metric_fact_rec.forward_buy_quantity := rosetta_g_miss_num_map(p6_a89);
944 ddp_act_metric_fact_rec.status_code := p6_a90;
945 ddp_act_metric_fact_rec.hierarchy_type := p6_a91;
946 ddp_act_metric_fact_rec.approval_date := rosetta_g_miss_date_in_map(p6_a92);
947 ddp_act_metric_fact_rec.recommend_total_amount := rosetta_g_miss_num_map(p6_a93);
948 ddp_act_metric_fact_rec.recommend_hb_amount := rosetta_g_miss_num_map(p6_a94);
949 ddp_act_metric_fact_rec.request_total_amount := rosetta_g_miss_num_map(p6_a95);
950 ddp_act_metric_fact_rec.request_hb_amount := rosetta_g_miss_num_map(p6_a96);
951 ddp_act_metric_fact_rec.actual_total_amount := rosetta_g_miss_num_map(p6_a97);
952 ddp_act_metric_fact_rec.actual_hb_amount := rosetta_g_miss_num_map(p6_a98);
953 ddp_act_metric_fact_rec.base_total_pct := rosetta_g_miss_num_map(p6_a99);
954 ddp_act_metric_fact_rec.base_hb_pct := rosetta_g_miss_num_map(p6_a100);
955
956 -- here's the delegated call to the old PL/SQL routine
957 ams_actmetricfact_pvt.validate_actmetfact(p_api_version,
958 p_init_msg_list,
959 p_validation_level,
960 x_return_status,
961 x_msg_count,
962 x_msg_data,
963 ddp_act_metric_fact_rec);
964
965 -- copy data back from the local variables to OUT or IN-OUT args, if any
966
967
968
969
970
971
972 end;
973
974 procedure validate_actmetfact_items(p_validation_mode VARCHAR2
975 , x_return_status out nocopy VARCHAR2
976 , p0_a0 NUMBER := 0-1962.0724
977 , p0_a1 DATE := fnd_api.g_miss_date
978 , p0_a2 NUMBER := 0-1962.0724
979 , p0_a3 DATE := fnd_api.g_miss_date
980 , p0_a4 NUMBER := 0-1962.0724
981 , p0_a5 NUMBER := 0-1962.0724
982 , p0_a6 NUMBER := 0-1962.0724
983 , p0_a7 NUMBER := 0-1962.0724
984 , p0_a8 VARCHAR2 := fnd_api.g_miss_char
985 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
986 , p0_a10 NUMBER := 0-1962.0724
987 , p0_a11 NUMBER := 0-1962.0724
988 , p0_a12 NUMBER := 0-1962.0724
989 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
990 , p0_a14 NUMBER := 0-1962.0724
991 , p0_a15 NUMBER := 0-1962.0724
992 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
993 , p0_a17 NUMBER := 0-1962.0724
994 , p0_a18 NUMBER := 0-1962.0724
995 , p0_a19 NUMBER := 0-1962.0724
996 , p0_a20 NUMBER := 0-1962.0724
997 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
998 , p0_a22 NUMBER := 0-1962.0724
999 , p0_a23 NUMBER := 0-1962.0724
1000 , p0_a24 NUMBER := 0-1962.0724
1001 , p0_a25 NUMBER := 0-1962.0724
1002 , p0_a26 NUMBER := 0-1962.0724
1003 , p0_a27 NUMBER := 0-1962.0724
1004 , p0_a28 NUMBER := 0-1962.0724
1005 , p0_a29 NUMBER := 0-1962.0724
1006 , p0_a30 NUMBER := 0-1962.0724
1007 , p0_a31 NUMBER := 0-1962.0724
1008 , p0_a32 NUMBER := 0-1962.0724
1009 , p0_a33 NUMBER := 0-1962.0724
1010 , p0_a34 NUMBER := 0-1962.0724
1011 , p0_a35 NUMBER := 0-1962.0724
1012 , p0_a36 NUMBER := 0-1962.0724
1013 , p0_a37 NUMBER := 0-1962.0724
1014 , p0_a38 NUMBER := 0-1962.0724
1015 , p0_a39 NUMBER := 0-1962.0724
1016 , p0_a40 NUMBER := 0-1962.0724
1017 , p0_a41 NUMBER := 0-1962.0724
1018 , p0_a42 NUMBER := 0-1962.0724
1019 , p0_a43 NUMBER := 0-1962.0724
1020 , p0_a44 NUMBER := 0-1962.0724
1021 , p0_a45 NUMBER := 0-1962.0724
1022 , p0_a46 NUMBER := 0-1962.0724
1023 , p0_a47 NUMBER := 0-1962.0724
1024 , p0_a48 NUMBER := 0-1962.0724
1025 , p0_a49 NUMBER := 0-1962.0724
1026 , p0_a50 NUMBER := 0-1962.0724
1027 , p0_a51 NUMBER := 0-1962.0724
1028 , p0_a52 NUMBER := 0-1962.0724
1029 , p0_a53 NUMBER := 0-1962.0724
1030 , p0_a54 NUMBER := 0-1962.0724
1031 , p0_a55 NUMBER := 0-1962.0724
1032 , p0_a56 NUMBER := 0-1962.0724
1033 , p0_a57 NUMBER := 0-1962.0724
1034 , p0_a58 NUMBER := 0-1962.0724
1035 , p0_a59 NUMBER := 0-1962.0724
1036 , p0_a60 NUMBER := 0-1962.0724
1037 , p0_a61 NUMBER := 0-1962.0724
1038 , p0_a62 NUMBER := 0-1962.0724
1039 , p0_a63 NUMBER := 0-1962.0724
1040 , p0_a64 NUMBER := 0-1962.0724
1041 , p0_a65 NUMBER := 0-1962.0724
1042 , p0_a66 NUMBER := 0-1962.0724
1043 , p0_a67 NUMBER := 0-1962.0724
1044 , p0_a68 NUMBER := 0-1962.0724
1045 , p0_a69 NUMBER := 0-1962.0724
1046 , p0_a70 NUMBER := 0-1962.0724
1047 , p0_a71 NUMBER := 0-1962.0724
1048 , p0_a72 NUMBER := 0-1962.0724
1049 , p0_a73 NUMBER := 0-1962.0724
1050 , p0_a74 NUMBER := 0-1962.0724
1051 , p0_a75 NUMBER := 0-1962.0724
1052 , p0_a76 NUMBER := 0-1962.0724
1053 , p0_a77 NUMBER := 0-1962.0724
1054 , p0_a78 NUMBER := 0-1962.0724
1055 , p0_a79 NUMBER := 0-1962.0724
1056 , p0_a80 NUMBER := 0-1962.0724
1057 , p0_a81 DATE := fnd_api.g_miss_date
1058 , p0_a82 DATE := fnd_api.g_miss_date
1059 , p0_a83 NUMBER := 0-1962.0724
1060 , p0_a84 NUMBER := 0-1962.0724
1061 , p0_a85 NUMBER := 0-1962.0724
1062 , p0_a86 NUMBER := 0-1962.0724
1063 , p0_a87 VARCHAR2 := fnd_api.g_miss_char
1064 , p0_a88 VARCHAR2 := fnd_api.g_miss_char
1065 , p0_a89 NUMBER := 0-1962.0724
1066 , p0_a90 VARCHAR2 := fnd_api.g_miss_char
1067 , p0_a91 VARCHAR2 := fnd_api.g_miss_char
1068 , p0_a92 DATE := fnd_api.g_miss_date
1069 , p0_a93 NUMBER := 0-1962.0724
1070 , p0_a94 NUMBER := 0-1962.0724
1071 , p0_a95 NUMBER := 0-1962.0724
1072 , p0_a96 NUMBER := 0-1962.0724
1073 , p0_a97 NUMBER := 0-1962.0724
1074 , p0_a98 NUMBER := 0-1962.0724
1075 , p0_a99 NUMBER := 0-1962.0724
1076 , p0_a100 NUMBER := 0-1962.0724
1077 )
1078
1079 as
1080 ddp_act_metric_fact_rec ams_actmetricfact_pvt.act_metric_fact_rec_type;
1081 ddindx binary_integer; indx binary_integer;
1082 begin
1083
1084 -- copy data to the local IN or IN-OUT args, if any
1085 ddp_act_metric_fact_rec.activity_metric_fact_id := rosetta_g_miss_num_map(p0_a0);
1086 ddp_act_metric_fact_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
1087 ddp_act_metric_fact_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
1088 ddp_act_metric_fact_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
1089 ddp_act_metric_fact_rec.created_by := rosetta_g_miss_num_map(p0_a4);
1090 ddp_act_metric_fact_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
1091 ddp_act_metric_fact_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
1092 ddp_act_metric_fact_rec.act_metric_used_by_id := rosetta_g_miss_num_map(p0_a7);
1093 ddp_act_metric_fact_rec.arc_act_metric_used_by := p0_a8;
1094 ddp_act_metric_fact_rec.value_type := p0_a9;
1095 ddp_act_metric_fact_rec.activity_metric_id := rosetta_g_miss_num_map(p0_a10);
1096 ddp_act_metric_fact_rec.activity_geo_area_id := rosetta_g_miss_num_map(p0_a11);
1097 ddp_act_metric_fact_rec.activity_product_id := rosetta_g_miss_num_map(p0_a12);
1098 ddp_act_metric_fact_rec.transaction_currency_code := p0_a13;
1099 ddp_act_metric_fact_rec.trans_forecasted_value := rosetta_g_miss_num_map(p0_a14);
1100 ddp_act_metric_fact_rec.base_quantity := rosetta_g_miss_num_map(p0_a15);
1101 ddp_act_metric_fact_rec.functional_currency_code := p0_a16;
1102 ddp_act_metric_fact_rec.func_forecasted_value := rosetta_g_miss_num_map(p0_a17);
1103 ddp_act_metric_fact_rec.org_id := rosetta_g_miss_num_map(p0_a18);
1104 ddp_act_metric_fact_rec.de_metric_id := rosetta_g_miss_num_map(p0_a19);
1105 ddp_act_metric_fact_rec.de_geographic_area_id := rosetta_g_miss_num_map(p0_a20);
1106 ddp_act_metric_fact_rec.de_geographic_area_type := p0_a21;
1107 ddp_act_metric_fact_rec.de_inventory_item_id := rosetta_g_miss_num_map(p0_a22);
1108 ddp_act_metric_fact_rec.de_inventory_item_org_id := rosetta_g_miss_num_map(p0_a23);
1109 ddp_act_metric_fact_rec.time_id1 := rosetta_g_miss_num_map(p0_a24);
1110 ddp_act_metric_fact_rec.time_id2 := rosetta_g_miss_num_map(p0_a25);
1111 ddp_act_metric_fact_rec.time_id3 := rosetta_g_miss_num_map(p0_a26);
1112 ddp_act_metric_fact_rec.time_id4 := rosetta_g_miss_num_map(p0_a27);
1113 ddp_act_metric_fact_rec.time_id5 := rosetta_g_miss_num_map(p0_a28);
1114 ddp_act_metric_fact_rec.time_id6 := rosetta_g_miss_num_map(p0_a29);
1115 ddp_act_metric_fact_rec.time_id7 := rosetta_g_miss_num_map(p0_a30);
1116 ddp_act_metric_fact_rec.time_id8 := rosetta_g_miss_num_map(p0_a31);
1117 ddp_act_metric_fact_rec.time_id9 := rosetta_g_miss_num_map(p0_a32);
1118 ddp_act_metric_fact_rec.time_id10 := rosetta_g_miss_num_map(p0_a33);
1119 ddp_act_metric_fact_rec.time_id11 := rosetta_g_miss_num_map(p0_a34);
1120 ddp_act_metric_fact_rec.time_id12 := rosetta_g_miss_num_map(p0_a35);
1121 ddp_act_metric_fact_rec.time_id13 := rosetta_g_miss_num_map(p0_a36);
1122 ddp_act_metric_fact_rec.time_id14 := rosetta_g_miss_num_map(p0_a37);
1123 ddp_act_metric_fact_rec.time_id15 := rosetta_g_miss_num_map(p0_a38);
1124 ddp_act_metric_fact_rec.time_id16 := rosetta_g_miss_num_map(p0_a39);
1125 ddp_act_metric_fact_rec.time_id17 := rosetta_g_miss_num_map(p0_a40);
1126 ddp_act_metric_fact_rec.time_id18 := rosetta_g_miss_num_map(p0_a41);
1127 ddp_act_metric_fact_rec.time_id19 := rosetta_g_miss_num_map(p0_a42);
1128 ddp_act_metric_fact_rec.time_id20 := rosetta_g_miss_num_map(p0_a43);
1129 ddp_act_metric_fact_rec.time_id21 := rosetta_g_miss_num_map(p0_a44);
1130 ddp_act_metric_fact_rec.time_id22 := rosetta_g_miss_num_map(p0_a45);
1131 ddp_act_metric_fact_rec.time_id23 := rosetta_g_miss_num_map(p0_a46);
1132 ddp_act_metric_fact_rec.time_id24 := rosetta_g_miss_num_map(p0_a47);
1133 ddp_act_metric_fact_rec.time_id25 := rosetta_g_miss_num_map(p0_a48);
1134 ddp_act_metric_fact_rec.time_id26 := rosetta_g_miss_num_map(p0_a49);
1135 ddp_act_metric_fact_rec.time_id27 := rosetta_g_miss_num_map(p0_a50);
1136 ddp_act_metric_fact_rec.time_id28 := rosetta_g_miss_num_map(p0_a51);
1137 ddp_act_metric_fact_rec.time_id29 := rosetta_g_miss_num_map(p0_a52);
1138 ddp_act_metric_fact_rec.time_id30 := rosetta_g_miss_num_map(p0_a53);
1139 ddp_act_metric_fact_rec.time_id31 := rosetta_g_miss_num_map(p0_a54);
1140 ddp_act_metric_fact_rec.time_id32 := rosetta_g_miss_num_map(p0_a55);
1141 ddp_act_metric_fact_rec.time_id33 := rosetta_g_miss_num_map(p0_a56);
1142 ddp_act_metric_fact_rec.time_id34 := rosetta_g_miss_num_map(p0_a57);
1143 ddp_act_metric_fact_rec.time_id35 := rosetta_g_miss_num_map(p0_a58);
1144 ddp_act_metric_fact_rec.time_id36 := rosetta_g_miss_num_map(p0_a59);
1145 ddp_act_metric_fact_rec.time_id37 := rosetta_g_miss_num_map(p0_a60);
1146 ddp_act_metric_fact_rec.time_id38 := rosetta_g_miss_num_map(p0_a61);
1147 ddp_act_metric_fact_rec.time_id39 := rosetta_g_miss_num_map(p0_a62);
1148 ddp_act_metric_fact_rec.time_id40 := rosetta_g_miss_num_map(p0_a63);
1149 ddp_act_metric_fact_rec.time_id41 := rosetta_g_miss_num_map(p0_a64);
1150 ddp_act_metric_fact_rec.time_id42 := rosetta_g_miss_num_map(p0_a65);
1151 ddp_act_metric_fact_rec.time_id43 := rosetta_g_miss_num_map(p0_a66);
1152 ddp_act_metric_fact_rec.time_id44 := rosetta_g_miss_num_map(p0_a67);
1153 ddp_act_metric_fact_rec.time_id45 := rosetta_g_miss_num_map(p0_a68);
1154 ddp_act_metric_fact_rec.time_id46 := rosetta_g_miss_num_map(p0_a69);
1155 ddp_act_metric_fact_rec.time_id47 := rosetta_g_miss_num_map(p0_a70);
1156 ddp_act_metric_fact_rec.time_id48 := rosetta_g_miss_num_map(p0_a71);
1157 ddp_act_metric_fact_rec.time_id49 := rosetta_g_miss_num_map(p0_a72);
1158 ddp_act_metric_fact_rec.time_id50 := rosetta_g_miss_num_map(p0_a73);
1159 ddp_act_metric_fact_rec.time_id51 := rosetta_g_miss_num_map(p0_a74);
1160 ddp_act_metric_fact_rec.time_id52 := rosetta_g_miss_num_map(p0_a75);
1161 ddp_act_metric_fact_rec.time_id53 := rosetta_g_miss_num_map(p0_a76);
1162 ddp_act_metric_fact_rec.hierarchy_id := rosetta_g_miss_num_map(p0_a77);
1163 ddp_act_metric_fact_rec.node_id := rosetta_g_miss_num_map(p0_a78);
1164 ddp_act_metric_fact_rec.level_depth := rosetta_g_miss_num_map(p0_a79);
1165 ddp_act_metric_fact_rec.formula_id := rosetta_g_miss_num_map(p0_a80);
1166 ddp_act_metric_fact_rec.from_date := rosetta_g_miss_date_in_map(p0_a81);
1167 ddp_act_metric_fact_rec.to_date := rosetta_g_miss_date_in_map(p0_a82);
1168 ddp_act_metric_fact_rec.fact_value := rosetta_g_miss_num_map(p0_a83);
1169 ddp_act_metric_fact_rec.fact_percent := rosetta_g_miss_num_map(p0_a84);
1170 ddp_act_metric_fact_rec.root_fact_id := rosetta_g_miss_num_map(p0_a85);
1171 ddp_act_metric_fact_rec.previous_fact_id := rosetta_g_miss_num_map(p0_a86);
1172 ddp_act_metric_fact_rec.fact_type := p0_a87;
1173 ddp_act_metric_fact_rec.fact_reference := p0_a88;
1174 ddp_act_metric_fact_rec.forward_buy_quantity := rosetta_g_miss_num_map(p0_a89);
1175 ddp_act_metric_fact_rec.status_code := p0_a90;
1176 ddp_act_metric_fact_rec.hierarchy_type := p0_a91;
1177 ddp_act_metric_fact_rec.approval_date := rosetta_g_miss_date_in_map(p0_a92);
1178 ddp_act_metric_fact_rec.recommend_total_amount := rosetta_g_miss_num_map(p0_a93);
1179 ddp_act_metric_fact_rec.recommend_hb_amount := rosetta_g_miss_num_map(p0_a94);
1180 ddp_act_metric_fact_rec.request_total_amount := rosetta_g_miss_num_map(p0_a95);
1181 ddp_act_metric_fact_rec.request_hb_amount := rosetta_g_miss_num_map(p0_a96);
1182 ddp_act_metric_fact_rec.actual_total_amount := rosetta_g_miss_num_map(p0_a97);
1183 ddp_act_metric_fact_rec.actual_hb_amount := rosetta_g_miss_num_map(p0_a98);
1184 ddp_act_metric_fact_rec.base_total_pct := rosetta_g_miss_num_map(p0_a99);
1185 ddp_act_metric_fact_rec.base_hb_pct := rosetta_g_miss_num_map(p0_a100);
1186
1187
1188
1189 -- here's the delegated call to the old PL/SQL routine
1190 ams_actmetricfact_pvt.validate_actmetfact_items(ddp_act_metric_fact_rec,
1191 p_validation_mode,
1192 x_return_status);
1193
1194 -- copy data back from the local variables to OUT or IN-OUT args, if any
1195
1196
1197 end;
1198
1199 procedure validate_actmetfact_rec(x_return_status out nocopy VARCHAR2
1200 , p0_a0 NUMBER := 0-1962.0724
1201 , p0_a1 DATE := fnd_api.g_miss_date
1202 , p0_a2 NUMBER := 0-1962.0724
1203 , p0_a3 DATE := fnd_api.g_miss_date
1204 , p0_a4 NUMBER := 0-1962.0724
1205 , p0_a5 NUMBER := 0-1962.0724
1206 , p0_a6 NUMBER := 0-1962.0724
1207 , p0_a7 NUMBER := 0-1962.0724
1208 , p0_a8 VARCHAR2 := fnd_api.g_miss_char
1209 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
1210 , p0_a10 NUMBER := 0-1962.0724
1211 , p0_a11 NUMBER := 0-1962.0724
1212 , p0_a12 NUMBER := 0-1962.0724
1213 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
1214 , p0_a14 NUMBER := 0-1962.0724
1215 , p0_a15 NUMBER := 0-1962.0724
1216 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
1217 , p0_a17 NUMBER := 0-1962.0724
1218 , p0_a18 NUMBER := 0-1962.0724
1219 , p0_a19 NUMBER := 0-1962.0724
1220 , p0_a20 NUMBER := 0-1962.0724
1221 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
1222 , p0_a22 NUMBER := 0-1962.0724
1223 , p0_a23 NUMBER := 0-1962.0724
1224 , p0_a24 NUMBER := 0-1962.0724
1225 , p0_a25 NUMBER := 0-1962.0724
1226 , p0_a26 NUMBER := 0-1962.0724
1227 , p0_a27 NUMBER := 0-1962.0724
1228 , p0_a28 NUMBER := 0-1962.0724
1229 , p0_a29 NUMBER := 0-1962.0724
1230 , p0_a30 NUMBER := 0-1962.0724
1231 , p0_a31 NUMBER := 0-1962.0724
1232 , p0_a32 NUMBER := 0-1962.0724
1233 , p0_a33 NUMBER := 0-1962.0724
1234 , p0_a34 NUMBER := 0-1962.0724
1235 , p0_a35 NUMBER := 0-1962.0724
1236 , p0_a36 NUMBER := 0-1962.0724
1237 , p0_a37 NUMBER := 0-1962.0724
1238 , p0_a38 NUMBER := 0-1962.0724
1239 , p0_a39 NUMBER := 0-1962.0724
1240 , p0_a40 NUMBER := 0-1962.0724
1241 , p0_a41 NUMBER := 0-1962.0724
1242 , p0_a42 NUMBER := 0-1962.0724
1243 , p0_a43 NUMBER := 0-1962.0724
1244 , p0_a44 NUMBER := 0-1962.0724
1245 , p0_a45 NUMBER := 0-1962.0724
1246 , p0_a46 NUMBER := 0-1962.0724
1247 , p0_a47 NUMBER := 0-1962.0724
1248 , p0_a48 NUMBER := 0-1962.0724
1249 , p0_a49 NUMBER := 0-1962.0724
1250 , p0_a50 NUMBER := 0-1962.0724
1251 , p0_a51 NUMBER := 0-1962.0724
1252 , p0_a52 NUMBER := 0-1962.0724
1253 , p0_a53 NUMBER := 0-1962.0724
1254 , p0_a54 NUMBER := 0-1962.0724
1255 , p0_a55 NUMBER := 0-1962.0724
1256 , p0_a56 NUMBER := 0-1962.0724
1257 , p0_a57 NUMBER := 0-1962.0724
1258 , p0_a58 NUMBER := 0-1962.0724
1259 , p0_a59 NUMBER := 0-1962.0724
1260 , p0_a60 NUMBER := 0-1962.0724
1261 , p0_a61 NUMBER := 0-1962.0724
1262 , p0_a62 NUMBER := 0-1962.0724
1263 , p0_a63 NUMBER := 0-1962.0724
1264 , p0_a64 NUMBER := 0-1962.0724
1265 , p0_a65 NUMBER := 0-1962.0724
1266 , p0_a66 NUMBER := 0-1962.0724
1267 , p0_a67 NUMBER := 0-1962.0724
1268 , p0_a68 NUMBER := 0-1962.0724
1269 , p0_a69 NUMBER := 0-1962.0724
1270 , p0_a70 NUMBER := 0-1962.0724
1271 , p0_a71 NUMBER := 0-1962.0724
1272 , p0_a72 NUMBER := 0-1962.0724
1273 , p0_a73 NUMBER := 0-1962.0724
1274 , p0_a74 NUMBER := 0-1962.0724
1275 , p0_a75 NUMBER := 0-1962.0724
1276 , p0_a76 NUMBER := 0-1962.0724
1277 , p0_a77 NUMBER := 0-1962.0724
1278 , p0_a78 NUMBER := 0-1962.0724
1279 , p0_a79 NUMBER := 0-1962.0724
1280 , p0_a80 NUMBER := 0-1962.0724
1281 , p0_a81 DATE := fnd_api.g_miss_date
1282 , p0_a82 DATE := fnd_api.g_miss_date
1283 , p0_a83 NUMBER := 0-1962.0724
1284 , p0_a84 NUMBER := 0-1962.0724
1285 , p0_a85 NUMBER := 0-1962.0724
1286 , p0_a86 NUMBER := 0-1962.0724
1287 , p0_a87 VARCHAR2 := fnd_api.g_miss_char
1288 , p0_a88 VARCHAR2 := fnd_api.g_miss_char
1289 , p0_a89 NUMBER := 0-1962.0724
1290 , p0_a90 VARCHAR2 := fnd_api.g_miss_char
1291 , p0_a91 VARCHAR2 := fnd_api.g_miss_char
1292 , p0_a92 DATE := fnd_api.g_miss_date
1293 , p0_a93 NUMBER := 0-1962.0724
1294 , p0_a94 NUMBER := 0-1962.0724
1295 , p0_a95 NUMBER := 0-1962.0724
1296 , p0_a96 NUMBER := 0-1962.0724
1297 , p0_a97 NUMBER := 0-1962.0724
1298 , p0_a98 NUMBER := 0-1962.0724
1299 , p0_a99 NUMBER := 0-1962.0724
1300 , p0_a100 NUMBER := 0-1962.0724
1301 , p1_a0 NUMBER := 0-1962.0724
1302 , p1_a1 DATE := fnd_api.g_miss_date
1303 , p1_a2 NUMBER := 0-1962.0724
1304 , p1_a3 DATE := fnd_api.g_miss_date
1305 , p1_a4 NUMBER := 0-1962.0724
1306 , p1_a5 NUMBER := 0-1962.0724
1307 , p1_a6 NUMBER := 0-1962.0724
1308 , p1_a7 NUMBER := 0-1962.0724
1309 , p1_a8 VARCHAR2 := fnd_api.g_miss_char
1310 , p1_a9 VARCHAR2 := fnd_api.g_miss_char
1311 , p1_a10 NUMBER := 0-1962.0724
1312 , p1_a11 NUMBER := 0-1962.0724
1313 , p1_a12 NUMBER := 0-1962.0724
1314 , p1_a13 VARCHAR2 := fnd_api.g_miss_char
1315 , p1_a14 NUMBER := 0-1962.0724
1316 , p1_a15 NUMBER := 0-1962.0724
1317 , p1_a16 VARCHAR2 := fnd_api.g_miss_char
1318 , p1_a17 NUMBER := 0-1962.0724
1319 , p1_a18 NUMBER := 0-1962.0724
1320 , p1_a19 NUMBER := 0-1962.0724
1321 , p1_a20 NUMBER := 0-1962.0724
1322 , p1_a21 VARCHAR2 := fnd_api.g_miss_char
1323 , p1_a22 NUMBER := 0-1962.0724
1324 , p1_a23 NUMBER := 0-1962.0724
1325 , p1_a24 NUMBER := 0-1962.0724
1326 , p1_a25 NUMBER := 0-1962.0724
1327 , p1_a26 NUMBER := 0-1962.0724
1328 , p1_a27 NUMBER := 0-1962.0724
1329 , p1_a28 NUMBER := 0-1962.0724
1330 , p1_a29 NUMBER := 0-1962.0724
1331 , p1_a30 NUMBER := 0-1962.0724
1332 , p1_a31 NUMBER := 0-1962.0724
1333 , p1_a32 NUMBER := 0-1962.0724
1334 , p1_a33 NUMBER := 0-1962.0724
1335 , p1_a34 NUMBER := 0-1962.0724
1336 , p1_a35 NUMBER := 0-1962.0724
1337 , p1_a36 NUMBER := 0-1962.0724
1338 , p1_a37 NUMBER := 0-1962.0724
1339 , p1_a38 NUMBER := 0-1962.0724
1340 , p1_a39 NUMBER := 0-1962.0724
1341 , p1_a40 NUMBER := 0-1962.0724
1342 , p1_a41 NUMBER := 0-1962.0724
1343 , p1_a42 NUMBER := 0-1962.0724
1344 , p1_a43 NUMBER := 0-1962.0724
1345 , p1_a44 NUMBER := 0-1962.0724
1346 , p1_a45 NUMBER := 0-1962.0724
1347 , p1_a46 NUMBER := 0-1962.0724
1348 , p1_a47 NUMBER := 0-1962.0724
1349 , p1_a48 NUMBER := 0-1962.0724
1350 , p1_a49 NUMBER := 0-1962.0724
1351 , p1_a50 NUMBER := 0-1962.0724
1352 , p1_a51 NUMBER := 0-1962.0724
1353 , p1_a52 NUMBER := 0-1962.0724
1354 , p1_a53 NUMBER := 0-1962.0724
1355 , p1_a54 NUMBER := 0-1962.0724
1356 , p1_a55 NUMBER := 0-1962.0724
1357 , p1_a56 NUMBER := 0-1962.0724
1358 , p1_a57 NUMBER := 0-1962.0724
1359 , p1_a58 NUMBER := 0-1962.0724
1360 , p1_a59 NUMBER := 0-1962.0724
1361 , p1_a60 NUMBER := 0-1962.0724
1362 , p1_a61 NUMBER := 0-1962.0724
1363 , p1_a62 NUMBER := 0-1962.0724
1364 , p1_a63 NUMBER := 0-1962.0724
1365 , p1_a64 NUMBER := 0-1962.0724
1366 , p1_a65 NUMBER := 0-1962.0724
1367 , p1_a66 NUMBER := 0-1962.0724
1368 , p1_a67 NUMBER := 0-1962.0724
1369 , p1_a68 NUMBER := 0-1962.0724
1370 , p1_a69 NUMBER := 0-1962.0724
1371 , p1_a70 NUMBER := 0-1962.0724
1372 , p1_a71 NUMBER := 0-1962.0724
1373 , p1_a72 NUMBER := 0-1962.0724
1374 , p1_a73 NUMBER := 0-1962.0724
1375 , p1_a74 NUMBER := 0-1962.0724
1376 , p1_a75 NUMBER := 0-1962.0724
1377 , p1_a76 NUMBER := 0-1962.0724
1378 , p1_a77 NUMBER := 0-1962.0724
1379 , p1_a78 NUMBER := 0-1962.0724
1380 , p1_a79 NUMBER := 0-1962.0724
1381 , p1_a80 NUMBER := 0-1962.0724
1382 , p1_a81 DATE := fnd_api.g_miss_date
1383 , p1_a82 DATE := fnd_api.g_miss_date
1384 , p1_a83 NUMBER := 0-1962.0724
1385 , p1_a84 NUMBER := 0-1962.0724
1386 , p1_a85 NUMBER := 0-1962.0724
1387 , p1_a86 NUMBER := 0-1962.0724
1388 , p1_a87 VARCHAR2 := fnd_api.g_miss_char
1389 , p1_a88 VARCHAR2 := fnd_api.g_miss_char
1390 , p1_a89 NUMBER := 0-1962.0724
1391 , p1_a90 VARCHAR2 := fnd_api.g_miss_char
1392 , p1_a91 VARCHAR2 := fnd_api.g_miss_char
1393 , p1_a92 DATE := fnd_api.g_miss_date
1394 , p1_a93 NUMBER := 0-1962.0724
1395 , p1_a94 NUMBER := 0-1962.0724
1396 , p1_a95 NUMBER := 0-1962.0724
1397 , p1_a96 NUMBER := 0-1962.0724
1398 , p1_a97 NUMBER := 0-1962.0724
1399 , p1_a98 NUMBER := 0-1962.0724
1400 , p1_a99 NUMBER := 0-1962.0724
1401 , p1_a100 NUMBER := 0-1962.0724
1402 )
1403
1404 as
1405 ddp_act_metric_fact_rec ams_actmetricfact_pvt.act_metric_fact_rec_type;
1406 ddp_complete_fact_rec ams_actmetricfact_pvt.act_metric_fact_rec_type;
1407 ddindx binary_integer; indx binary_integer;
1408 begin
1409
1410 -- copy data to the local IN or IN-OUT args, if any
1411 ddp_act_metric_fact_rec.activity_metric_fact_id := rosetta_g_miss_num_map(p0_a0);
1412 ddp_act_metric_fact_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
1413 ddp_act_metric_fact_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
1414 ddp_act_metric_fact_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
1415 ddp_act_metric_fact_rec.created_by := rosetta_g_miss_num_map(p0_a4);
1416 ddp_act_metric_fact_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
1417 ddp_act_metric_fact_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
1418 ddp_act_metric_fact_rec.act_metric_used_by_id := rosetta_g_miss_num_map(p0_a7);
1419 ddp_act_metric_fact_rec.arc_act_metric_used_by := p0_a8;
1420 ddp_act_metric_fact_rec.value_type := p0_a9;
1421 ddp_act_metric_fact_rec.activity_metric_id := rosetta_g_miss_num_map(p0_a10);
1422 ddp_act_metric_fact_rec.activity_geo_area_id := rosetta_g_miss_num_map(p0_a11);
1423 ddp_act_metric_fact_rec.activity_product_id := rosetta_g_miss_num_map(p0_a12);
1424 ddp_act_metric_fact_rec.transaction_currency_code := p0_a13;
1425 ddp_act_metric_fact_rec.trans_forecasted_value := rosetta_g_miss_num_map(p0_a14);
1426 ddp_act_metric_fact_rec.base_quantity := rosetta_g_miss_num_map(p0_a15);
1427 ddp_act_metric_fact_rec.functional_currency_code := p0_a16;
1428 ddp_act_metric_fact_rec.func_forecasted_value := rosetta_g_miss_num_map(p0_a17);
1429 ddp_act_metric_fact_rec.org_id := rosetta_g_miss_num_map(p0_a18);
1430 ddp_act_metric_fact_rec.de_metric_id := rosetta_g_miss_num_map(p0_a19);
1431 ddp_act_metric_fact_rec.de_geographic_area_id := rosetta_g_miss_num_map(p0_a20);
1432 ddp_act_metric_fact_rec.de_geographic_area_type := p0_a21;
1433 ddp_act_metric_fact_rec.de_inventory_item_id := rosetta_g_miss_num_map(p0_a22);
1434 ddp_act_metric_fact_rec.de_inventory_item_org_id := rosetta_g_miss_num_map(p0_a23);
1435 ddp_act_metric_fact_rec.time_id1 := rosetta_g_miss_num_map(p0_a24);
1436 ddp_act_metric_fact_rec.time_id2 := rosetta_g_miss_num_map(p0_a25);
1437 ddp_act_metric_fact_rec.time_id3 := rosetta_g_miss_num_map(p0_a26);
1438 ddp_act_metric_fact_rec.time_id4 := rosetta_g_miss_num_map(p0_a27);
1439 ddp_act_metric_fact_rec.time_id5 := rosetta_g_miss_num_map(p0_a28);
1440 ddp_act_metric_fact_rec.time_id6 := rosetta_g_miss_num_map(p0_a29);
1441 ddp_act_metric_fact_rec.time_id7 := rosetta_g_miss_num_map(p0_a30);
1442 ddp_act_metric_fact_rec.time_id8 := rosetta_g_miss_num_map(p0_a31);
1443 ddp_act_metric_fact_rec.time_id9 := rosetta_g_miss_num_map(p0_a32);
1444 ddp_act_metric_fact_rec.time_id10 := rosetta_g_miss_num_map(p0_a33);
1445 ddp_act_metric_fact_rec.time_id11 := rosetta_g_miss_num_map(p0_a34);
1446 ddp_act_metric_fact_rec.time_id12 := rosetta_g_miss_num_map(p0_a35);
1447 ddp_act_metric_fact_rec.time_id13 := rosetta_g_miss_num_map(p0_a36);
1448 ddp_act_metric_fact_rec.time_id14 := rosetta_g_miss_num_map(p0_a37);
1449 ddp_act_metric_fact_rec.time_id15 := rosetta_g_miss_num_map(p0_a38);
1450 ddp_act_metric_fact_rec.time_id16 := rosetta_g_miss_num_map(p0_a39);
1451 ddp_act_metric_fact_rec.time_id17 := rosetta_g_miss_num_map(p0_a40);
1452 ddp_act_metric_fact_rec.time_id18 := rosetta_g_miss_num_map(p0_a41);
1453 ddp_act_metric_fact_rec.time_id19 := rosetta_g_miss_num_map(p0_a42);
1454 ddp_act_metric_fact_rec.time_id20 := rosetta_g_miss_num_map(p0_a43);
1455 ddp_act_metric_fact_rec.time_id21 := rosetta_g_miss_num_map(p0_a44);
1456 ddp_act_metric_fact_rec.time_id22 := rosetta_g_miss_num_map(p0_a45);
1457 ddp_act_metric_fact_rec.time_id23 := rosetta_g_miss_num_map(p0_a46);
1458 ddp_act_metric_fact_rec.time_id24 := rosetta_g_miss_num_map(p0_a47);
1459 ddp_act_metric_fact_rec.time_id25 := rosetta_g_miss_num_map(p0_a48);
1460 ddp_act_metric_fact_rec.time_id26 := rosetta_g_miss_num_map(p0_a49);
1461 ddp_act_metric_fact_rec.time_id27 := rosetta_g_miss_num_map(p0_a50);
1462 ddp_act_metric_fact_rec.time_id28 := rosetta_g_miss_num_map(p0_a51);
1463 ddp_act_metric_fact_rec.time_id29 := rosetta_g_miss_num_map(p0_a52);
1464 ddp_act_metric_fact_rec.time_id30 := rosetta_g_miss_num_map(p0_a53);
1465 ddp_act_metric_fact_rec.time_id31 := rosetta_g_miss_num_map(p0_a54);
1466 ddp_act_metric_fact_rec.time_id32 := rosetta_g_miss_num_map(p0_a55);
1467 ddp_act_metric_fact_rec.time_id33 := rosetta_g_miss_num_map(p0_a56);
1468 ddp_act_metric_fact_rec.time_id34 := rosetta_g_miss_num_map(p0_a57);
1469 ddp_act_metric_fact_rec.time_id35 := rosetta_g_miss_num_map(p0_a58);
1470 ddp_act_metric_fact_rec.time_id36 := rosetta_g_miss_num_map(p0_a59);
1471 ddp_act_metric_fact_rec.time_id37 := rosetta_g_miss_num_map(p0_a60);
1472 ddp_act_metric_fact_rec.time_id38 := rosetta_g_miss_num_map(p0_a61);
1473 ddp_act_metric_fact_rec.time_id39 := rosetta_g_miss_num_map(p0_a62);
1474 ddp_act_metric_fact_rec.time_id40 := rosetta_g_miss_num_map(p0_a63);
1475 ddp_act_metric_fact_rec.time_id41 := rosetta_g_miss_num_map(p0_a64);
1476 ddp_act_metric_fact_rec.time_id42 := rosetta_g_miss_num_map(p0_a65);
1477 ddp_act_metric_fact_rec.time_id43 := rosetta_g_miss_num_map(p0_a66);
1478 ddp_act_metric_fact_rec.time_id44 := rosetta_g_miss_num_map(p0_a67);
1479 ddp_act_metric_fact_rec.time_id45 := rosetta_g_miss_num_map(p0_a68);
1480 ddp_act_metric_fact_rec.time_id46 := rosetta_g_miss_num_map(p0_a69);
1481 ddp_act_metric_fact_rec.time_id47 := rosetta_g_miss_num_map(p0_a70);
1482 ddp_act_metric_fact_rec.time_id48 := rosetta_g_miss_num_map(p0_a71);
1483 ddp_act_metric_fact_rec.time_id49 := rosetta_g_miss_num_map(p0_a72);
1484 ddp_act_metric_fact_rec.time_id50 := rosetta_g_miss_num_map(p0_a73);
1485 ddp_act_metric_fact_rec.time_id51 := rosetta_g_miss_num_map(p0_a74);
1486 ddp_act_metric_fact_rec.time_id52 := rosetta_g_miss_num_map(p0_a75);
1487 ddp_act_metric_fact_rec.time_id53 := rosetta_g_miss_num_map(p0_a76);
1488 ddp_act_metric_fact_rec.hierarchy_id := rosetta_g_miss_num_map(p0_a77);
1489 ddp_act_metric_fact_rec.node_id := rosetta_g_miss_num_map(p0_a78);
1490 ddp_act_metric_fact_rec.level_depth := rosetta_g_miss_num_map(p0_a79);
1491 ddp_act_metric_fact_rec.formula_id := rosetta_g_miss_num_map(p0_a80);
1492 ddp_act_metric_fact_rec.from_date := rosetta_g_miss_date_in_map(p0_a81);
1493 ddp_act_metric_fact_rec.to_date := rosetta_g_miss_date_in_map(p0_a82);
1494 ddp_act_metric_fact_rec.fact_value := rosetta_g_miss_num_map(p0_a83);
1495 ddp_act_metric_fact_rec.fact_percent := rosetta_g_miss_num_map(p0_a84);
1496 ddp_act_metric_fact_rec.root_fact_id := rosetta_g_miss_num_map(p0_a85);
1497 ddp_act_metric_fact_rec.previous_fact_id := rosetta_g_miss_num_map(p0_a86);
1498 ddp_act_metric_fact_rec.fact_type := p0_a87;
1499 ddp_act_metric_fact_rec.fact_reference := p0_a88;
1500 ddp_act_metric_fact_rec.forward_buy_quantity := rosetta_g_miss_num_map(p0_a89);
1501 ddp_act_metric_fact_rec.status_code := p0_a90;
1502 ddp_act_metric_fact_rec.hierarchy_type := p0_a91;
1503 ddp_act_metric_fact_rec.approval_date := rosetta_g_miss_date_in_map(p0_a92);
1504 ddp_act_metric_fact_rec.recommend_total_amount := rosetta_g_miss_num_map(p0_a93);
1505 ddp_act_metric_fact_rec.recommend_hb_amount := rosetta_g_miss_num_map(p0_a94);
1506 ddp_act_metric_fact_rec.request_total_amount := rosetta_g_miss_num_map(p0_a95);
1507 ddp_act_metric_fact_rec.request_hb_amount := rosetta_g_miss_num_map(p0_a96);
1508 ddp_act_metric_fact_rec.actual_total_amount := rosetta_g_miss_num_map(p0_a97);
1509 ddp_act_metric_fact_rec.actual_hb_amount := rosetta_g_miss_num_map(p0_a98);
1510 ddp_act_metric_fact_rec.base_total_pct := rosetta_g_miss_num_map(p0_a99);
1511 ddp_act_metric_fact_rec.base_hb_pct := rosetta_g_miss_num_map(p0_a100);
1512
1513 ddp_complete_fact_rec.activity_metric_fact_id := rosetta_g_miss_num_map(p1_a0);
1514 ddp_complete_fact_rec.last_update_date := rosetta_g_miss_date_in_map(p1_a1);
1515 ddp_complete_fact_rec.last_updated_by := rosetta_g_miss_num_map(p1_a2);
1516 ddp_complete_fact_rec.creation_date := rosetta_g_miss_date_in_map(p1_a3);
1517 ddp_complete_fact_rec.created_by := rosetta_g_miss_num_map(p1_a4);
1518 ddp_complete_fact_rec.last_update_login := rosetta_g_miss_num_map(p1_a5);
1519 ddp_complete_fact_rec.object_version_number := rosetta_g_miss_num_map(p1_a6);
1520 ddp_complete_fact_rec.act_metric_used_by_id := rosetta_g_miss_num_map(p1_a7);
1521 ddp_complete_fact_rec.arc_act_metric_used_by := p1_a8;
1522 ddp_complete_fact_rec.value_type := p1_a9;
1523 ddp_complete_fact_rec.activity_metric_id := rosetta_g_miss_num_map(p1_a10);
1524 ddp_complete_fact_rec.activity_geo_area_id := rosetta_g_miss_num_map(p1_a11);
1525 ddp_complete_fact_rec.activity_product_id := rosetta_g_miss_num_map(p1_a12);
1526 ddp_complete_fact_rec.transaction_currency_code := p1_a13;
1527 ddp_complete_fact_rec.trans_forecasted_value := rosetta_g_miss_num_map(p1_a14);
1528 ddp_complete_fact_rec.base_quantity := rosetta_g_miss_num_map(p1_a15);
1529 ddp_complete_fact_rec.functional_currency_code := p1_a16;
1530 ddp_complete_fact_rec.func_forecasted_value := rosetta_g_miss_num_map(p1_a17);
1531 ddp_complete_fact_rec.org_id := rosetta_g_miss_num_map(p1_a18);
1532 ddp_complete_fact_rec.de_metric_id := rosetta_g_miss_num_map(p1_a19);
1533 ddp_complete_fact_rec.de_geographic_area_id := rosetta_g_miss_num_map(p1_a20);
1534 ddp_complete_fact_rec.de_geographic_area_type := p1_a21;
1535 ddp_complete_fact_rec.de_inventory_item_id := rosetta_g_miss_num_map(p1_a22);
1536 ddp_complete_fact_rec.de_inventory_item_org_id := rosetta_g_miss_num_map(p1_a23);
1537 ddp_complete_fact_rec.time_id1 := rosetta_g_miss_num_map(p1_a24);
1538 ddp_complete_fact_rec.time_id2 := rosetta_g_miss_num_map(p1_a25);
1539 ddp_complete_fact_rec.time_id3 := rosetta_g_miss_num_map(p1_a26);
1540 ddp_complete_fact_rec.time_id4 := rosetta_g_miss_num_map(p1_a27);
1541 ddp_complete_fact_rec.time_id5 := rosetta_g_miss_num_map(p1_a28);
1542 ddp_complete_fact_rec.time_id6 := rosetta_g_miss_num_map(p1_a29);
1543 ddp_complete_fact_rec.time_id7 := rosetta_g_miss_num_map(p1_a30);
1544 ddp_complete_fact_rec.time_id8 := rosetta_g_miss_num_map(p1_a31);
1545 ddp_complete_fact_rec.time_id9 := rosetta_g_miss_num_map(p1_a32);
1546 ddp_complete_fact_rec.time_id10 := rosetta_g_miss_num_map(p1_a33);
1547 ddp_complete_fact_rec.time_id11 := rosetta_g_miss_num_map(p1_a34);
1548 ddp_complete_fact_rec.time_id12 := rosetta_g_miss_num_map(p1_a35);
1549 ddp_complete_fact_rec.time_id13 := rosetta_g_miss_num_map(p1_a36);
1550 ddp_complete_fact_rec.time_id14 := rosetta_g_miss_num_map(p1_a37);
1551 ddp_complete_fact_rec.time_id15 := rosetta_g_miss_num_map(p1_a38);
1552 ddp_complete_fact_rec.time_id16 := rosetta_g_miss_num_map(p1_a39);
1553 ddp_complete_fact_rec.time_id17 := rosetta_g_miss_num_map(p1_a40);
1554 ddp_complete_fact_rec.time_id18 := rosetta_g_miss_num_map(p1_a41);
1555 ddp_complete_fact_rec.time_id19 := rosetta_g_miss_num_map(p1_a42);
1556 ddp_complete_fact_rec.time_id20 := rosetta_g_miss_num_map(p1_a43);
1557 ddp_complete_fact_rec.time_id21 := rosetta_g_miss_num_map(p1_a44);
1558 ddp_complete_fact_rec.time_id22 := rosetta_g_miss_num_map(p1_a45);
1559 ddp_complete_fact_rec.time_id23 := rosetta_g_miss_num_map(p1_a46);
1560 ddp_complete_fact_rec.time_id24 := rosetta_g_miss_num_map(p1_a47);
1561 ddp_complete_fact_rec.time_id25 := rosetta_g_miss_num_map(p1_a48);
1562 ddp_complete_fact_rec.time_id26 := rosetta_g_miss_num_map(p1_a49);
1563 ddp_complete_fact_rec.time_id27 := rosetta_g_miss_num_map(p1_a50);
1564 ddp_complete_fact_rec.time_id28 := rosetta_g_miss_num_map(p1_a51);
1565 ddp_complete_fact_rec.time_id29 := rosetta_g_miss_num_map(p1_a52);
1566 ddp_complete_fact_rec.time_id30 := rosetta_g_miss_num_map(p1_a53);
1567 ddp_complete_fact_rec.time_id31 := rosetta_g_miss_num_map(p1_a54);
1568 ddp_complete_fact_rec.time_id32 := rosetta_g_miss_num_map(p1_a55);
1569 ddp_complete_fact_rec.time_id33 := rosetta_g_miss_num_map(p1_a56);
1570 ddp_complete_fact_rec.time_id34 := rosetta_g_miss_num_map(p1_a57);
1571 ddp_complete_fact_rec.time_id35 := rosetta_g_miss_num_map(p1_a58);
1572 ddp_complete_fact_rec.time_id36 := rosetta_g_miss_num_map(p1_a59);
1573 ddp_complete_fact_rec.time_id37 := rosetta_g_miss_num_map(p1_a60);
1574 ddp_complete_fact_rec.time_id38 := rosetta_g_miss_num_map(p1_a61);
1575 ddp_complete_fact_rec.time_id39 := rosetta_g_miss_num_map(p1_a62);
1576 ddp_complete_fact_rec.time_id40 := rosetta_g_miss_num_map(p1_a63);
1577 ddp_complete_fact_rec.time_id41 := rosetta_g_miss_num_map(p1_a64);
1578 ddp_complete_fact_rec.time_id42 := rosetta_g_miss_num_map(p1_a65);
1579 ddp_complete_fact_rec.time_id43 := rosetta_g_miss_num_map(p1_a66);
1580 ddp_complete_fact_rec.time_id44 := rosetta_g_miss_num_map(p1_a67);
1581 ddp_complete_fact_rec.time_id45 := rosetta_g_miss_num_map(p1_a68);
1582 ddp_complete_fact_rec.time_id46 := rosetta_g_miss_num_map(p1_a69);
1583 ddp_complete_fact_rec.time_id47 := rosetta_g_miss_num_map(p1_a70);
1584 ddp_complete_fact_rec.time_id48 := rosetta_g_miss_num_map(p1_a71);
1585 ddp_complete_fact_rec.time_id49 := rosetta_g_miss_num_map(p1_a72);
1586 ddp_complete_fact_rec.time_id50 := rosetta_g_miss_num_map(p1_a73);
1587 ddp_complete_fact_rec.time_id51 := rosetta_g_miss_num_map(p1_a74);
1588 ddp_complete_fact_rec.time_id52 := rosetta_g_miss_num_map(p1_a75);
1589 ddp_complete_fact_rec.time_id53 := rosetta_g_miss_num_map(p1_a76);
1590 ddp_complete_fact_rec.hierarchy_id := rosetta_g_miss_num_map(p1_a77);
1591 ddp_complete_fact_rec.node_id := rosetta_g_miss_num_map(p1_a78);
1592 ddp_complete_fact_rec.level_depth := rosetta_g_miss_num_map(p1_a79);
1593 ddp_complete_fact_rec.formula_id := rosetta_g_miss_num_map(p1_a80);
1594 ddp_complete_fact_rec.from_date := rosetta_g_miss_date_in_map(p1_a81);
1595 ddp_complete_fact_rec.to_date := rosetta_g_miss_date_in_map(p1_a82);
1596 ddp_complete_fact_rec.fact_value := rosetta_g_miss_num_map(p1_a83);
1597 ddp_complete_fact_rec.fact_percent := rosetta_g_miss_num_map(p1_a84);
1598 ddp_complete_fact_rec.root_fact_id := rosetta_g_miss_num_map(p1_a85);
1599 ddp_complete_fact_rec.previous_fact_id := rosetta_g_miss_num_map(p1_a86);
1600 ddp_complete_fact_rec.fact_type := p1_a87;
1601 ddp_complete_fact_rec.fact_reference := p1_a88;
1602 ddp_complete_fact_rec.forward_buy_quantity := rosetta_g_miss_num_map(p1_a89);
1603 ddp_complete_fact_rec.status_code := p1_a90;
1604 ddp_complete_fact_rec.hierarchy_type := p1_a91;
1605 ddp_complete_fact_rec.approval_date := rosetta_g_miss_date_in_map(p1_a92);
1606 ddp_complete_fact_rec.recommend_total_amount := rosetta_g_miss_num_map(p1_a93);
1607 ddp_complete_fact_rec.recommend_hb_amount := rosetta_g_miss_num_map(p1_a94);
1608 ddp_complete_fact_rec.request_total_amount := rosetta_g_miss_num_map(p1_a95);
1609 ddp_complete_fact_rec.request_hb_amount := rosetta_g_miss_num_map(p1_a96);
1610 ddp_complete_fact_rec.actual_total_amount := rosetta_g_miss_num_map(p1_a97);
1611 ddp_complete_fact_rec.actual_hb_amount := rosetta_g_miss_num_map(p1_a98);
1612 ddp_complete_fact_rec.base_total_pct := rosetta_g_miss_num_map(p1_a99);
1613 ddp_complete_fact_rec.base_hb_pct := rosetta_g_miss_num_map(p1_a100);
1614
1615
1616 -- here's the delegated call to the old PL/SQL routine
1617 ams_actmetricfact_pvt.validate_actmetfact_rec(ddp_act_metric_fact_rec,
1618 ddp_complete_fact_rec,
1619 x_return_status);
1620
1621 -- copy data back from the local variables to OUT or IN-OUT args, if any
1622
1623
1624 end;
1625
1626 procedure complete_actmetfact_rec(p1_a0 out nocopy NUMBER
1627 , p1_a1 out nocopy DATE
1628 , p1_a2 out nocopy NUMBER
1629 , p1_a3 out nocopy DATE
1630 , p1_a4 out nocopy NUMBER
1631 , p1_a5 out nocopy NUMBER
1632 , p1_a6 out nocopy NUMBER
1633 , p1_a7 out nocopy NUMBER
1634 , p1_a8 out nocopy VARCHAR2
1635 , p1_a9 out nocopy VARCHAR2
1636 , p1_a10 out nocopy NUMBER
1637 , p1_a11 out nocopy NUMBER
1638 , p1_a12 out nocopy NUMBER
1639 , p1_a13 out nocopy VARCHAR2
1640 , p1_a14 out nocopy NUMBER
1641 , p1_a15 out nocopy NUMBER
1642 , p1_a16 out nocopy VARCHAR2
1643 , p1_a17 out nocopy NUMBER
1644 , p1_a18 out nocopy NUMBER
1645 , p1_a19 out nocopy NUMBER
1646 , p1_a20 out nocopy NUMBER
1647 , p1_a21 out nocopy VARCHAR2
1648 , p1_a22 out nocopy NUMBER
1649 , p1_a23 out nocopy NUMBER
1650 , p1_a24 out nocopy NUMBER
1651 , p1_a25 out nocopy NUMBER
1652 , p1_a26 out nocopy NUMBER
1653 , p1_a27 out nocopy NUMBER
1654 , p1_a28 out nocopy NUMBER
1655 , p1_a29 out nocopy NUMBER
1656 , p1_a30 out nocopy NUMBER
1657 , p1_a31 out nocopy NUMBER
1658 , p1_a32 out nocopy NUMBER
1659 , p1_a33 out nocopy NUMBER
1660 , p1_a34 out nocopy NUMBER
1661 , p1_a35 out nocopy NUMBER
1662 , p1_a36 out nocopy NUMBER
1663 , p1_a37 out nocopy NUMBER
1664 , p1_a38 out nocopy NUMBER
1665 , p1_a39 out nocopy NUMBER
1666 , p1_a40 out nocopy NUMBER
1667 , p1_a41 out nocopy NUMBER
1668 , p1_a42 out nocopy NUMBER
1669 , p1_a43 out nocopy NUMBER
1670 , p1_a44 out nocopy NUMBER
1671 , p1_a45 out nocopy NUMBER
1672 , p1_a46 out nocopy NUMBER
1673 , p1_a47 out nocopy NUMBER
1674 , p1_a48 out nocopy NUMBER
1675 , p1_a49 out nocopy NUMBER
1676 , p1_a50 out nocopy NUMBER
1677 , p1_a51 out nocopy NUMBER
1678 , p1_a52 out nocopy NUMBER
1679 , p1_a53 out nocopy NUMBER
1680 , p1_a54 out nocopy NUMBER
1681 , p1_a55 out nocopy NUMBER
1682 , p1_a56 out nocopy NUMBER
1683 , p1_a57 out nocopy NUMBER
1684 , p1_a58 out nocopy NUMBER
1685 , p1_a59 out nocopy NUMBER
1686 , p1_a60 out nocopy NUMBER
1687 , p1_a61 out nocopy NUMBER
1688 , p1_a62 out nocopy NUMBER
1689 , p1_a63 out nocopy NUMBER
1690 , p1_a64 out nocopy NUMBER
1691 , p1_a65 out nocopy NUMBER
1692 , p1_a66 out nocopy NUMBER
1693 , p1_a67 out nocopy NUMBER
1694 , p1_a68 out nocopy NUMBER
1695 , p1_a69 out nocopy NUMBER
1696 , p1_a70 out nocopy NUMBER
1697 , p1_a71 out nocopy NUMBER
1698 , p1_a72 out nocopy NUMBER
1699 , p1_a73 out nocopy NUMBER
1700 , p1_a74 out nocopy NUMBER
1701 , p1_a75 out nocopy NUMBER
1702 , p1_a76 out nocopy NUMBER
1703 , p1_a77 out nocopy NUMBER
1704 , p1_a78 out nocopy NUMBER
1705 , p1_a79 out nocopy NUMBER
1706 , p1_a80 out nocopy NUMBER
1707 , p1_a81 out nocopy DATE
1708 , p1_a82 out nocopy DATE
1709 , p1_a83 out nocopy NUMBER
1710 , p1_a84 out nocopy NUMBER
1711 , p1_a85 out nocopy NUMBER
1712 , p1_a86 out nocopy NUMBER
1713 , p1_a87 out nocopy VARCHAR2
1714 , p1_a88 out nocopy VARCHAR2
1715 , p1_a89 out nocopy NUMBER
1716 , p1_a90 out nocopy VARCHAR2
1717 , p1_a91 out nocopy VARCHAR2
1718 , p1_a92 out nocopy DATE
1719 , p1_a93 out nocopy NUMBER
1720 , p1_a94 out nocopy NUMBER
1721 , p1_a95 out nocopy NUMBER
1722 , p1_a96 out nocopy NUMBER
1723 , p1_a97 out nocopy NUMBER
1724 , p1_a98 out nocopy NUMBER
1725 , p1_a99 out nocopy NUMBER
1726 , p1_a100 out nocopy NUMBER
1727 , p0_a0 NUMBER := 0-1962.0724
1728 , p0_a1 DATE := fnd_api.g_miss_date
1729 , p0_a2 NUMBER := 0-1962.0724
1730 , p0_a3 DATE := fnd_api.g_miss_date
1731 , p0_a4 NUMBER := 0-1962.0724
1732 , p0_a5 NUMBER := 0-1962.0724
1733 , p0_a6 NUMBER := 0-1962.0724
1734 , p0_a7 NUMBER := 0-1962.0724
1735 , p0_a8 VARCHAR2 := fnd_api.g_miss_char
1736 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
1737 , p0_a10 NUMBER := 0-1962.0724
1738 , p0_a11 NUMBER := 0-1962.0724
1739 , p0_a12 NUMBER := 0-1962.0724
1740 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
1741 , p0_a14 NUMBER := 0-1962.0724
1742 , p0_a15 NUMBER := 0-1962.0724
1743 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
1744 , p0_a17 NUMBER := 0-1962.0724
1745 , p0_a18 NUMBER := 0-1962.0724
1746 , p0_a19 NUMBER := 0-1962.0724
1747 , p0_a20 NUMBER := 0-1962.0724
1748 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
1749 , p0_a22 NUMBER := 0-1962.0724
1750 , p0_a23 NUMBER := 0-1962.0724
1751 , p0_a24 NUMBER := 0-1962.0724
1752 , p0_a25 NUMBER := 0-1962.0724
1753 , p0_a26 NUMBER := 0-1962.0724
1754 , p0_a27 NUMBER := 0-1962.0724
1755 , p0_a28 NUMBER := 0-1962.0724
1756 , p0_a29 NUMBER := 0-1962.0724
1757 , p0_a30 NUMBER := 0-1962.0724
1758 , p0_a31 NUMBER := 0-1962.0724
1759 , p0_a32 NUMBER := 0-1962.0724
1760 , p0_a33 NUMBER := 0-1962.0724
1761 , p0_a34 NUMBER := 0-1962.0724
1762 , p0_a35 NUMBER := 0-1962.0724
1763 , p0_a36 NUMBER := 0-1962.0724
1764 , p0_a37 NUMBER := 0-1962.0724
1765 , p0_a38 NUMBER := 0-1962.0724
1766 , p0_a39 NUMBER := 0-1962.0724
1767 , p0_a40 NUMBER := 0-1962.0724
1768 , p0_a41 NUMBER := 0-1962.0724
1769 , p0_a42 NUMBER := 0-1962.0724
1770 , p0_a43 NUMBER := 0-1962.0724
1771 , p0_a44 NUMBER := 0-1962.0724
1772 , p0_a45 NUMBER := 0-1962.0724
1773 , p0_a46 NUMBER := 0-1962.0724
1774 , p0_a47 NUMBER := 0-1962.0724
1775 , p0_a48 NUMBER := 0-1962.0724
1776 , p0_a49 NUMBER := 0-1962.0724
1777 , p0_a50 NUMBER := 0-1962.0724
1778 , p0_a51 NUMBER := 0-1962.0724
1779 , p0_a52 NUMBER := 0-1962.0724
1780 , p0_a53 NUMBER := 0-1962.0724
1781 , p0_a54 NUMBER := 0-1962.0724
1782 , p0_a55 NUMBER := 0-1962.0724
1783 , p0_a56 NUMBER := 0-1962.0724
1784 , p0_a57 NUMBER := 0-1962.0724
1785 , p0_a58 NUMBER := 0-1962.0724
1786 , p0_a59 NUMBER := 0-1962.0724
1787 , p0_a60 NUMBER := 0-1962.0724
1788 , p0_a61 NUMBER := 0-1962.0724
1789 , p0_a62 NUMBER := 0-1962.0724
1790 , p0_a63 NUMBER := 0-1962.0724
1791 , p0_a64 NUMBER := 0-1962.0724
1792 , p0_a65 NUMBER := 0-1962.0724
1793 , p0_a66 NUMBER := 0-1962.0724
1794 , p0_a67 NUMBER := 0-1962.0724
1795 , p0_a68 NUMBER := 0-1962.0724
1796 , p0_a69 NUMBER := 0-1962.0724
1797 , p0_a70 NUMBER := 0-1962.0724
1798 , p0_a71 NUMBER := 0-1962.0724
1799 , p0_a72 NUMBER := 0-1962.0724
1800 , p0_a73 NUMBER := 0-1962.0724
1801 , p0_a74 NUMBER := 0-1962.0724
1802 , p0_a75 NUMBER := 0-1962.0724
1803 , p0_a76 NUMBER := 0-1962.0724
1804 , p0_a77 NUMBER := 0-1962.0724
1805 , p0_a78 NUMBER := 0-1962.0724
1806 , p0_a79 NUMBER := 0-1962.0724
1807 , p0_a80 NUMBER := 0-1962.0724
1808 , p0_a81 DATE := fnd_api.g_miss_date
1809 , p0_a82 DATE := fnd_api.g_miss_date
1810 , p0_a83 NUMBER := 0-1962.0724
1811 , p0_a84 NUMBER := 0-1962.0724
1812 , p0_a85 NUMBER := 0-1962.0724
1813 , p0_a86 NUMBER := 0-1962.0724
1814 , p0_a87 VARCHAR2 := fnd_api.g_miss_char
1815 , p0_a88 VARCHAR2 := fnd_api.g_miss_char
1816 , p0_a89 NUMBER := 0-1962.0724
1817 , p0_a90 VARCHAR2 := fnd_api.g_miss_char
1818 , p0_a91 VARCHAR2 := fnd_api.g_miss_char
1819 , p0_a92 DATE := fnd_api.g_miss_date
1820 , p0_a93 NUMBER := 0-1962.0724
1821 , p0_a94 NUMBER := 0-1962.0724
1822 , p0_a95 NUMBER := 0-1962.0724
1823 , p0_a96 NUMBER := 0-1962.0724
1824 , p0_a97 NUMBER := 0-1962.0724
1825 , p0_a98 NUMBER := 0-1962.0724
1826 , p0_a99 NUMBER := 0-1962.0724
1827 , p0_a100 NUMBER := 0-1962.0724
1828 )
1829
1830 as
1831 ddp_act_metric_fact_rec ams_actmetricfact_pvt.act_metric_fact_rec_type;
1832 ddx_complete_fact_rec ams_actmetricfact_pvt.act_metric_fact_rec_type;
1833 ddindx binary_integer; indx binary_integer;
1834 begin
1835
1836 -- copy data to the local IN or IN-OUT args, if any
1837 ddp_act_metric_fact_rec.activity_metric_fact_id := rosetta_g_miss_num_map(p0_a0);
1838 ddp_act_metric_fact_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
1839 ddp_act_metric_fact_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
1840 ddp_act_metric_fact_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
1841 ddp_act_metric_fact_rec.created_by := rosetta_g_miss_num_map(p0_a4);
1842 ddp_act_metric_fact_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
1843 ddp_act_metric_fact_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
1844 ddp_act_metric_fact_rec.act_metric_used_by_id := rosetta_g_miss_num_map(p0_a7);
1845 ddp_act_metric_fact_rec.arc_act_metric_used_by := p0_a8;
1846 ddp_act_metric_fact_rec.value_type := p0_a9;
1847 ddp_act_metric_fact_rec.activity_metric_id := rosetta_g_miss_num_map(p0_a10);
1848 ddp_act_metric_fact_rec.activity_geo_area_id := rosetta_g_miss_num_map(p0_a11);
1849 ddp_act_metric_fact_rec.activity_product_id := rosetta_g_miss_num_map(p0_a12);
1850 ddp_act_metric_fact_rec.transaction_currency_code := p0_a13;
1851 ddp_act_metric_fact_rec.trans_forecasted_value := rosetta_g_miss_num_map(p0_a14);
1852 ddp_act_metric_fact_rec.base_quantity := rosetta_g_miss_num_map(p0_a15);
1853 ddp_act_metric_fact_rec.functional_currency_code := p0_a16;
1854 ddp_act_metric_fact_rec.func_forecasted_value := rosetta_g_miss_num_map(p0_a17);
1855 ddp_act_metric_fact_rec.org_id := rosetta_g_miss_num_map(p0_a18);
1856 ddp_act_metric_fact_rec.de_metric_id := rosetta_g_miss_num_map(p0_a19);
1857 ddp_act_metric_fact_rec.de_geographic_area_id := rosetta_g_miss_num_map(p0_a20);
1858 ddp_act_metric_fact_rec.de_geographic_area_type := p0_a21;
1859 ddp_act_metric_fact_rec.de_inventory_item_id := rosetta_g_miss_num_map(p0_a22);
1860 ddp_act_metric_fact_rec.de_inventory_item_org_id := rosetta_g_miss_num_map(p0_a23);
1861 ddp_act_metric_fact_rec.time_id1 := rosetta_g_miss_num_map(p0_a24);
1862 ddp_act_metric_fact_rec.time_id2 := rosetta_g_miss_num_map(p0_a25);
1863 ddp_act_metric_fact_rec.time_id3 := rosetta_g_miss_num_map(p0_a26);
1864 ddp_act_metric_fact_rec.time_id4 := rosetta_g_miss_num_map(p0_a27);
1865 ddp_act_metric_fact_rec.time_id5 := rosetta_g_miss_num_map(p0_a28);
1866 ddp_act_metric_fact_rec.time_id6 := rosetta_g_miss_num_map(p0_a29);
1867 ddp_act_metric_fact_rec.time_id7 := rosetta_g_miss_num_map(p0_a30);
1868 ddp_act_metric_fact_rec.time_id8 := rosetta_g_miss_num_map(p0_a31);
1869 ddp_act_metric_fact_rec.time_id9 := rosetta_g_miss_num_map(p0_a32);
1870 ddp_act_metric_fact_rec.time_id10 := rosetta_g_miss_num_map(p0_a33);
1871 ddp_act_metric_fact_rec.time_id11 := rosetta_g_miss_num_map(p0_a34);
1872 ddp_act_metric_fact_rec.time_id12 := rosetta_g_miss_num_map(p0_a35);
1873 ddp_act_metric_fact_rec.time_id13 := rosetta_g_miss_num_map(p0_a36);
1874 ddp_act_metric_fact_rec.time_id14 := rosetta_g_miss_num_map(p0_a37);
1875 ddp_act_metric_fact_rec.time_id15 := rosetta_g_miss_num_map(p0_a38);
1876 ddp_act_metric_fact_rec.time_id16 := rosetta_g_miss_num_map(p0_a39);
1877 ddp_act_metric_fact_rec.time_id17 := rosetta_g_miss_num_map(p0_a40);
1878 ddp_act_metric_fact_rec.time_id18 := rosetta_g_miss_num_map(p0_a41);
1879 ddp_act_metric_fact_rec.time_id19 := rosetta_g_miss_num_map(p0_a42);
1880 ddp_act_metric_fact_rec.time_id20 := rosetta_g_miss_num_map(p0_a43);
1881 ddp_act_metric_fact_rec.time_id21 := rosetta_g_miss_num_map(p0_a44);
1882 ddp_act_metric_fact_rec.time_id22 := rosetta_g_miss_num_map(p0_a45);
1883 ddp_act_metric_fact_rec.time_id23 := rosetta_g_miss_num_map(p0_a46);
1884 ddp_act_metric_fact_rec.time_id24 := rosetta_g_miss_num_map(p0_a47);
1885 ddp_act_metric_fact_rec.time_id25 := rosetta_g_miss_num_map(p0_a48);
1886 ddp_act_metric_fact_rec.time_id26 := rosetta_g_miss_num_map(p0_a49);
1887 ddp_act_metric_fact_rec.time_id27 := rosetta_g_miss_num_map(p0_a50);
1888 ddp_act_metric_fact_rec.time_id28 := rosetta_g_miss_num_map(p0_a51);
1889 ddp_act_metric_fact_rec.time_id29 := rosetta_g_miss_num_map(p0_a52);
1890 ddp_act_metric_fact_rec.time_id30 := rosetta_g_miss_num_map(p0_a53);
1891 ddp_act_metric_fact_rec.time_id31 := rosetta_g_miss_num_map(p0_a54);
1892 ddp_act_metric_fact_rec.time_id32 := rosetta_g_miss_num_map(p0_a55);
1893 ddp_act_metric_fact_rec.time_id33 := rosetta_g_miss_num_map(p0_a56);
1894 ddp_act_metric_fact_rec.time_id34 := rosetta_g_miss_num_map(p0_a57);
1895 ddp_act_metric_fact_rec.time_id35 := rosetta_g_miss_num_map(p0_a58);
1896 ddp_act_metric_fact_rec.time_id36 := rosetta_g_miss_num_map(p0_a59);
1897 ddp_act_metric_fact_rec.time_id37 := rosetta_g_miss_num_map(p0_a60);
1898 ddp_act_metric_fact_rec.time_id38 := rosetta_g_miss_num_map(p0_a61);
1899 ddp_act_metric_fact_rec.time_id39 := rosetta_g_miss_num_map(p0_a62);
1900 ddp_act_metric_fact_rec.time_id40 := rosetta_g_miss_num_map(p0_a63);
1901 ddp_act_metric_fact_rec.time_id41 := rosetta_g_miss_num_map(p0_a64);
1902 ddp_act_metric_fact_rec.time_id42 := rosetta_g_miss_num_map(p0_a65);
1903 ddp_act_metric_fact_rec.time_id43 := rosetta_g_miss_num_map(p0_a66);
1904 ddp_act_metric_fact_rec.time_id44 := rosetta_g_miss_num_map(p0_a67);
1905 ddp_act_metric_fact_rec.time_id45 := rosetta_g_miss_num_map(p0_a68);
1906 ddp_act_metric_fact_rec.time_id46 := rosetta_g_miss_num_map(p0_a69);
1907 ddp_act_metric_fact_rec.time_id47 := rosetta_g_miss_num_map(p0_a70);
1908 ddp_act_metric_fact_rec.time_id48 := rosetta_g_miss_num_map(p0_a71);
1909 ddp_act_metric_fact_rec.time_id49 := rosetta_g_miss_num_map(p0_a72);
1910 ddp_act_metric_fact_rec.time_id50 := rosetta_g_miss_num_map(p0_a73);
1911 ddp_act_metric_fact_rec.time_id51 := rosetta_g_miss_num_map(p0_a74);
1912 ddp_act_metric_fact_rec.time_id52 := rosetta_g_miss_num_map(p0_a75);
1913 ddp_act_metric_fact_rec.time_id53 := rosetta_g_miss_num_map(p0_a76);
1914 ddp_act_metric_fact_rec.hierarchy_id := rosetta_g_miss_num_map(p0_a77);
1915 ddp_act_metric_fact_rec.node_id := rosetta_g_miss_num_map(p0_a78);
1916 ddp_act_metric_fact_rec.level_depth := rosetta_g_miss_num_map(p0_a79);
1917 ddp_act_metric_fact_rec.formula_id := rosetta_g_miss_num_map(p0_a80);
1918 ddp_act_metric_fact_rec.from_date := rosetta_g_miss_date_in_map(p0_a81);
1919 ddp_act_metric_fact_rec.to_date := rosetta_g_miss_date_in_map(p0_a82);
1920 ddp_act_metric_fact_rec.fact_value := rosetta_g_miss_num_map(p0_a83);
1921 ddp_act_metric_fact_rec.fact_percent := rosetta_g_miss_num_map(p0_a84);
1922 ddp_act_metric_fact_rec.root_fact_id := rosetta_g_miss_num_map(p0_a85);
1923 ddp_act_metric_fact_rec.previous_fact_id := rosetta_g_miss_num_map(p0_a86);
1924 ddp_act_metric_fact_rec.fact_type := p0_a87;
1925 ddp_act_metric_fact_rec.fact_reference := p0_a88;
1926 ddp_act_metric_fact_rec.forward_buy_quantity := rosetta_g_miss_num_map(p0_a89);
1927 ddp_act_metric_fact_rec.status_code := p0_a90;
1928 ddp_act_metric_fact_rec.hierarchy_type := p0_a91;
1929 ddp_act_metric_fact_rec.approval_date := rosetta_g_miss_date_in_map(p0_a92);
1930 ddp_act_metric_fact_rec.recommend_total_amount := rosetta_g_miss_num_map(p0_a93);
1931 ddp_act_metric_fact_rec.recommend_hb_amount := rosetta_g_miss_num_map(p0_a94);
1932 ddp_act_metric_fact_rec.request_total_amount := rosetta_g_miss_num_map(p0_a95);
1933 ddp_act_metric_fact_rec.request_hb_amount := rosetta_g_miss_num_map(p0_a96);
1934 ddp_act_metric_fact_rec.actual_total_amount := rosetta_g_miss_num_map(p0_a97);
1935 ddp_act_metric_fact_rec.actual_hb_amount := rosetta_g_miss_num_map(p0_a98);
1936 ddp_act_metric_fact_rec.base_total_pct := rosetta_g_miss_num_map(p0_a99);
1937 ddp_act_metric_fact_rec.base_hb_pct := rosetta_g_miss_num_map(p0_a100);
1938
1939
1940 -- here's the delegated call to the old PL/SQL routine
1941 ams_actmetricfact_pvt.complete_actmetfact_rec(ddp_act_metric_fact_rec,
1942 ddx_complete_fact_rec);
1943
1944 -- copy data back from the local variables to OUT or IN-OUT args, if any
1945
1946 p1_a0 := rosetta_g_miss_num_map(ddx_complete_fact_rec.activity_metric_fact_id);
1947 p1_a1 := ddx_complete_fact_rec.last_update_date;
1948 p1_a2 := rosetta_g_miss_num_map(ddx_complete_fact_rec.last_updated_by);
1949 p1_a3 := ddx_complete_fact_rec.creation_date;
1950 p1_a4 := rosetta_g_miss_num_map(ddx_complete_fact_rec.created_by);
1951 p1_a5 := rosetta_g_miss_num_map(ddx_complete_fact_rec.last_update_login);
1952 p1_a6 := rosetta_g_miss_num_map(ddx_complete_fact_rec.object_version_number);
1953 p1_a7 := rosetta_g_miss_num_map(ddx_complete_fact_rec.act_metric_used_by_id);
1954 p1_a8 := ddx_complete_fact_rec.arc_act_metric_used_by;
1955 p1_a9 := ddx_complete_fact_rec.value_type;
1956 p1_a10 := rosetta_g_miss_num_map(ddx_complete_fact_rec.activity_metric_id);
1957 p1_a11 := rosetta_g_miss_num_map(ddx_complete_fact_rec.activity_geo_area_id);
1958 p1_a12 := rosetta_g_miss_num_map(ddx_complete_fact_rec.activity_product_id);
1959 p1_a13 := ddx_complete_fact_rec.transaction_currency_code;
1960 p1_a14 := rosetta_g_miss_num_map(ddx_complete_fact_rec.trans_forecasted_value);
1961 p1_a15 := rosetta_g_miss_num_map(ddx_complete_fact_rec.base_quantity);
1962 p1_a16 := ddx_complete_fact_rec.functional_currency_code;
1963 p1_a17 := rosetta_g_miss_num_map(ddx_complete_fact_rec.func_forecasted_value);
1964 p1_a18 := rosetta_g_miss_num_map(ddx_complete_fact_rec.org_id);
1965 p1_a19 := rosetta_g_miss_num_map(ddx_complete_fact_rec.de_metric_id);
1966 p1_a20 := rosetta_g_miss_num_map(ddx_complete_fact_rec.de_geographic_area_id);
1967 p1_a21 := ddx_complete_fact_rec.de_geographic_area_type;
1968 p1_a22 := rosetta_g_miss_num_map(ddx_complete_fact_rec.de_inventory_item_id);
1969 p1_a23 := rosetta_g_miss_num_map(ddx_complete_fact_rec.de_inventory_item_org_id);
1970 p1_a24 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id1);
1971 p1_a25 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id2);
1972 p1_a26 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id3);
1973 p1_a27 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id4);
1974 p1_a28 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id5);
1975 p1_a29 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id6);
1976 p1_a30 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id7);
1977 p1_a31 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id8);
1978 p1_a32 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id9);
1979 p1_a33 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id10);
1980 p1_a34 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id11);
1981 p1_a35 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id12);
1982 p1_a36 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id13);
1983 p1_a37 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id14);
1984 p1_a38 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id15);
1985 p1_a39 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id16);
1986 p1_a40 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id17);
1987 p1_a41 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id18);
1988 p1_a42 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id19);
1989 p1_a43 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id20);
1990 p1_a44 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id21);
1991 p1_a45 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id22);
1992 p1_a46 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id23);
1993 p1_a47 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id24);
1994 p1_a48 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id25);
1995 p1_a49 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id26);
1996 p1_a50 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id27);
1997 p1_a51 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id28);
1998 p1_a52 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id29);
1999 p1_a53 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id30);
2000 p1_a54 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id31);
2001 p1_a55 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id32);
2002 p1_a56 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id33);
2003 p1_a57 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id34);
2004 p1_a58 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id35);
2005 p1_a59 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id36);
2006 p1_a60 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id37);
2007 p1_a61 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id38);
2008 p1_a62 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id39);
2009 p1_a63 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id40);
2010 p1_a64 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id41);
2011 p1_a65 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id42);
2012 p1_a66 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id43);
2013 p1_a67 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id44);
2014 p1_a68 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id45);
2015 p1_a69 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id46);
2016 p1_a70 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id47);
2017 p1_a71 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id48);
2018 p1_a72 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id49);
2019 p1_a73 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id50);
2020 p1_a74 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id51);
2021 p1_a75 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id52);
2022 p1_a76 := rosetta_g_miss_num_map(ddx_complete_fact_rec.time_id53);
2023 p1_a77 := rosetta_g_miss_num_map(ddx_complete_fact_rec.hierarchy_id);
2024 p1_a78 := rosetta_g_miss_num_map(ddx_complete_fact_rec.node_id);
2025 p1_a79 := rosetta_g_miss_num_map(ddx_complete_fact_rec.level_depth);
2026 p1_a80 := rosetta_g_miss_num_map(ddx_complete_fact_rec.formula_id);
2027 p1_a81 := ddx_complete_fact_rec.from_date;
2028 p1_a82 := ddx_complete_fact_rec.to_date;
2029 p1_a83 := rosetta_g_miss_num_map(ddx_complete_fact_rec.fact_value);
2030 p1_a84 := rosetta_g_miss_num_map(ddx_complete_fact_rec.fact_percent);
2031 p1_a85 := rosetta_g_miss_num_map(ddx_complete_fact_rec.root_fact_id);
2032 p1_a86 := rosetta_g_miss_num_map(ddx_complete_fact_rec.previous_fact_id);
2033 p1_a87 := ddx_complete_fact_rec.fact_type;
2034 p1_a88 := ddx_complete_fact_rec.fact_reference;
2035 p1_a89 := rosetta_g_miss_num_map(ddx_complete_fact_rec.forward_buy_quantity);
2036 p1_a90 := ddx_complete_fact_rec.status_code;
2037 p1_a91 := ddx_complete_fact_rec.hierarchy_type;
2038 p1_a92 := ddx_complete_fact_rec.approval_date;
2039 p1_a93 := rosetta_g_miss_num_map(ddx_complete_fact_rec.recommend_total_amount);
2040 p1_a94 := rosetta_g_miss_num_map(ddx_complete_fact_rec.recommend_hb_amount);
2041 p1_a95 := rosetta_g_miss_num_map(ddx_complete_fact_rec.request_total_amount);
2042 p1_a96 := rosetta_g_miss_num_map(ddx_complete_fact_rec.request_hb_amount);
2043 p1_a97 := rosetta_g_miss_num_map(ddx_complete_fact_rec.actual_total_amount);
2044 p1_a98 := rosetta_g_miss_num_map(ddx_complete_fact_rec.actual_hb_amount);
2045 p1_a99 := rosetta_g_miss_num_map(ddx_complete_fact_rec.base_total_pct);
2046 p1_a100 := rosetta_g_miss_num_map(ddx_complete_fact_rec.base_hb_pct);
2047 end;
2048
2049 end ams_actmetricfact_pvt_w;