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