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