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