[Home] [Help]
PACKAGE BODY: APPS.AMS_THLDCHK_PVT_W
Source
1 package body ams_thldchk_pvt_w as
2 /* $Header: amswthcb.pls 115.1 2003/07/03 14:24:52 cgoyal noship $ */
3 rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4 rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5
6 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7 function rosetta_g_miss_date_in_map(d date) return date as
8 begin
9 if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10 return d;
11 end;
12
13 function rosetta_g_miss_num_map(n number) return number as
14 a number := fnd_api.g_miss_num;
15 b number := 0-1962.0724;
16 begin
17 if n=a then return b; end if;
18 if n=b then return a; end if;
19 return n;
20 end;
21
22 procedure create_thldchk(p_api_version NUMBER
23 , p_init_msg_list VARCHAR2
24 , p_commit VARCHAR2
25 , p_validation_level NUMBER
26 , x_return_status out nocopy VARCHAR2
27 , x_msg_count out nocopy NUMBER
28 , x_msg_data out nocopy VARCHAR2
29 , x_trigger_check_id out nocopy NUMBER
30 , p7_a0 NUMBER := 0-1962.0724
31 , p7_a1 DATE := fnd_api.g_miss_date
32 , p7_a2 NUMBER := 0-1962.0724
33 , p7_a3 DATE := fnd_api.g_miss_date
34 , p7_a4 NUMBER := 0-1962.0724
35 , p7_a5 NUMBER := 0-1962.0724
36 , p7_a6 NUMBER := 0-1962.0724
37 , p7_a7 NUMBER := 0-1962.0724
38 , p7_a8 NUMBER := 0-1962.0724
39 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
40 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
41 , p7_a11 NUMBER := 0-1962.0724
42 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
43 , p7_a13 NUMBER := 0-1962.0724
44 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
45 , p7_a15 NUMBER := 0-1962.0724
46 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
48 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49 , p7_a19 NUMBER := 0-1962.0724
50 , p7_a20 NUMBER := 0-1962.0724
51 , p7_a21 NUMBER := 0-1962.0724
52 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
53 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
54 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
55 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
56 , p7_a26 NUMBER := 0-1962.0724
57 , p7_a27 NUMBER := 0-1962.0724
58 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
59 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
60 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
61 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
62 )
63
64 as
65 ddp_thldchk_rec ams_thldchk_pvt.thldchk_rec_type;
66 ddindx binary_integer; indx binary_integer;
67 begin
68
69 -- copy data to the local IN or IN-OUT args, if any
70
71
72
73
74
75
76
77 ddp_thldchk_rec.trigger_check_id := rosetta_g_miss_num_map(p7_a0);
78 ddp_thldchk_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
79 ddp_thldchk_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
80 ddp_thldchk_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
81 ddp_thldchk_rec.created_by := rosetta_g_miss_num_map(p7_a4);
82 ddp_thldchk_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
83 ddp_thldchk_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
84 ddp_thldchk_rec.trigger_id := rosetta_g_miss_num_map(p7_a7);
85 ddp_thldchk_rec.order_number := rosetta_g_miss_num_map(p7_a8);
86 ddp_thldchk_rec.chk1_type := p7_a9;
87 ddp_thldchk_rec.chk1_arc_source_code_from := p7_a10;
88 ddp_thldchk_rec.chk1_act_object_id := rosetta_g_miss_num_map(p7_a11);
89 ddp_thldchk_rec.chk1_source_code := p7_a12;
90 ddp_thldchk_rec.chk1_source_code_metric_id := rosetta_g_miss_num_map(p7_a13);
91 ddp_thldchk_rec.chk1_source_code_metric_type := p7_a14;
92 ddp_thldchk_rec.chk1_workbook_owner := rosetta_g_miss_num_map(p7_a15);
93 ddp_thldchk_rec.chk1_workbook_name := p7_a16;
94 ddp_thldchk_rec.chk1_to_chk2_operator_type := p7_a17;
95 ddp_thldchk_rec.chk2_type := p7_a18;
96 ddp_thldchk_rec.chk2_value := rosetta_g_miss_num_map(p7_a19);
97 ddp_thldchk_rec.chk2_low_value := rosetta_g_miss_num_map(p7_a20);
98 ddp_thldchk_rec.chk2_high_value := rosetta_g_miss_num_map(p7_a21);
99 ddp_thldchk_rec.chk2_uom_code := p7_a22;
100 ddp_thldchk_rec.chk2_currency_code := p7_a23;
101 ddp_thldchk_rec.chk2_source_code := p7_a24;
102 ddp_thldchk_rec.chk2_arc_source_code_from := p7_a25;
103 ddp_thldchk_rec.chk2_act_object_id := rosetta_g_miss_num_map(p7_a26);
104 ddp_thldchk_rec.chk2_source_code_metric_id := rosetta_g_miss_num_map(p7_a27);
105 ddp_thldchk_rec.chk2_source_code_metric_type := p7_a28;
106 ddp_thldchk_rec.chk2_workbook_name := p7_a29;
107 ddp_thldchk_rec.chk2_workbook_owner := p7_a30;
108 ddp_thldchk_rec.chk2_worksheet_name := p7_a31;
109
110
111 -- here's the delegated call to the old PL/SQL routine
112 ams_thldchk_pvt.create_thldchk(p_api_version,
113 p_init_msg_list,
114 p_commit,
115 p_validation_level,
116 x_return_status,
117 x_msg_count,
118 x_msg_data,
119 ddp_thldchk_rec,
120 x_trigger_check_id);
121
122 -- copy data back from the local variables to OUT or IN-OUT args, if any
123
124
125
126
127
128
129
130
131 end;
132
133 procedure update_thldchk(p_api_version NUMBER
134 , p_init_msg_list VARCHAR2
135 , p_commit VARCHAR2
136 , p_validation_level NUMBER
137 , x_return_status out nocopy VARCHAR2
138 , x_msg_count out nocopy NUMBER
139 , x_msg_data out nocopy VARCHAR2
140 , p7_a0 NUMBER := 0-1962.0724
141 , p7_a1 DATE := fnd_api.g_miss_date
142 , p7_a2 NUMBER := 0-1962.0724
143 , p7_a3 DATE := fnd_api.g_miss_date
144 , p7_a4 NUMBER := 0-1962.0724
145 , p7_a5 NUMBER := 0-1962.0724
146 , p7_a6 NUMBER := 0-1962.0724
147 , p7_a7 NUMBER := 0-1962.0724
148 , p7_a8 NUMBER := 0-1962.0724
149 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
150 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
151 , p7_a11 NUMBER := 0-1962.0724
152 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
153 , p7_a13 NUMBER := 0-1962.0724
154 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
155 , p7_a15 NUMBER := 0-1962.0724
156 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
157 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
158 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
159 , p7_a19 NUMBER := 0-1962.0724
160 , p7_a20 NUMBER := 0-1962.0724
161 , p7_a21 NUMBER := 0-1962.0724
162 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
163 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
164 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
165 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
166 , p7_a26 NUMBER := 0-1962.0724
167 , p7_a27 NUMBER := 0-1962.0724
168 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
169 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
170 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
171 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
172 )
173
174 as
175 ddp_thldchk_rec ams_thldchk_pvt.thldchk_rec_type;
176 ddindx binary_integer; indx binary_integer;
177 begin
178
179 -- copy data to the local IN or IN-OUT args, if any
180
181
182
183
184
185
186
187 ddp_thldchk_rec.trigger_check_id := rosetta_g_miss_num_map(p7_a0);
188 ddp_thldchk_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
189 ddp_thldchk_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
190 ddp_thldchk_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
191 ddp_thldchk_rec.created_by := rosetta_g_miss_num_map(p7_a4);
192 ddp_thldchk_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
193 ddp_thldchk_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
194 ddp_thldchk_rec.trigger_id := rosetta_g_miss_num_map(p7_a7);
195 ddp_thldchk_rec.order_number := rosetta_g_miss_num_map(p7_a8);
196 ddp_thldchk_rec.chk1_type := p7_a9;
197 ddp_thldchk_rec.chk1_arc_source_code_from := p7_a10;
198 ddp_thldchk_rec.chk1_act_object_id := rosetta_g_miss_num_map(p7_a11);
199 ddp_thldchk_rec.chk1_source_code := p7_a12;
200 ddp_thldchk_rec.chk1_source_code_metric_id := rosetta_g_miss_num_map(p7_a13);
201 ddp_thldchk_rec.chk1_source_code_metric_type := p7_a14;
202 ddp_thldchk_rec.chk1_workbook_owner := rosetta_g_miss_num_map(p7_a15);
203 ddp_thldchk_rec.chk1_workbook_name := p7_a16;
204 ddp_thldchk_rec.chk1_to_chk2_operator_type := p7_a17;
205 ddp_thldchk_rec.chk2_type := p7_a18;
206 ddp_thldchk_rec.chk2_value := rosetta_g_miss_num_map(p7_a19);
207 ddp_thldchk_rec.chk2_low_value := rosetta_g_miss_num_map(p7_a20);
208 ddp_thldchk_rec.chk2_high_value := rosetta_g_miss_num_map(p7_a21);
209 ddp_thldchk_rec.chk2_uom_code := p7_a22;
210 ddp_thldchk_rec.chk2_currency_code := p7_a23;
211 ddp_thldchk_rec.chk2_source_code := p7_a24;
212 ddp_thldchk_rec.chk2_arc_source_code_from := p7_a25;
213 ddp_thldchk_rec.chk2_act_object_id := rosetta_g_miss_num_map(p7_a26);
214 ddp_thldchk_rec.chk2_source_code_metric_id := rosetta_g_miss_num_map(p7_a27);
215 ddp_thldchk_rec.chk2_source_code_metric_type := p7_a28;
216 ddp_thldchk_rec.chk2_workbook_name := p7_a29;
217 ddp_thldchk_rec.chk2_workbook_owner := p7_a30;
218 ddp_thldchk_rec.chk2_worksheet_name := p7_a31;
219
220 -- here's the delegated call to the old PL/SQL routine
221 ams_thldchk_pvt.update_thldchk(p_api_version,
222 p_init_msg_list,
223 p_commit,
224 p_validation_level,
225 x_return_status,
226 x_msg_count,
227 x_msg_data,
228 ddp_thldchk_rec);
229
230 -- copy data back from the local variables to OUT or IN-OUT args, if any
231
232
233
234
235
236
237
238 end;
239
240 procedure validate_thldchk(p_api_version NUMBER
241 , p_init_msg_list VARCHAR2
242 , p_validation_level NUMBER
243 , x_return_status out nocopy VARCHAR2
244 , x_msg_count out nocopy NUMBER
245 , x_msg_data out nocopy VARCHAR2
246 , p6_a0 NUMBER := 0-1962.0724
247 , p6_a1 DATE := fnd_api.g_miss_date
248 , p6_a2 NUMBER := 0-1962.0724
249 , p6_a3 DATE := fnd_api.g_miss_date
250 , p6_a4 NUMBER := 0-1962.0724
251 , p6_a5 NUMBER := 0-1962.0724
252 , p6_a6 NUMBER := 0-1962.0724
253 , p6_a7 NUMBER := 0-1962.0724
254 , p6_a8 NUMBER := 0-1962.0724
255 , p6_a9 VARCHAR2 := fnd_api.g_miss_char
256 , p6_a10 VARCHAR2 := fnd_api.g_miss_char
257 , p6_a11 NUMBER := 0-1962.0724
258 , p6_a12 VARCHAR2 := fnd_api.g_miss_char
259 , p6_a13 NUMBER := 0-1962.0724
260 , p6_a14 VARCHAR2 := fnd_api.g_miss_char
261 , p6_a15 NUMBER := 0-1962.0724
262 , p6_a16 VARCHAR2 := fnd_api.g_miss_char
263 , p6_a17 VARCHAR2 := fnd_api.g_miss_char
264 , p6_a18 VARCHAR2 := fnd_api.g_miss_char
265 , p6_a19 NUMBER := 0-1962.0724
266 , p6_a20 NUMBER := 0-1962.0724
267 , p6_a21 NUMBER := 0-1962.0724
268 , p6_a22 VARCHAR2 := fnd_api.g_miss_char
269 , p6_a23 VARCHAR2 := fnd_api.g_miss_char
270 , p6_a24 VARCHAR2 := fnd_api.g_miss_char
271 , p6_a25 VARCHAR2 := fnd_api.g_miss_char
272 , p6_a26 NUMBER := 0-1962.0724
273 , p6_a27 NUMBER := 0-1962.0724
274 , p6_a28 VARCHAR2 := fnd_api.g_miss_char
275 , p6_a29 VARCHAR2 := fnd_api.g_miss_char
276 , p6_a30 VARCHAR2 := fnd_api.g_miss_char
277 , p6_a31 VARCHAR2 := fnd_api.g_miss_char
278 )
279
280 as
281 ddp_thldchk_rec ams_thldchk_pvt.thldchk_rec_type;
282 ddindx binary_integer; indx binary_integer;
283 begin
284
285 -- copy data to the local IN or IN-OUT args, if any
286
287
288
289
290
291
292 ddp_thldchk_rec.trigger_check_id := rosetta_g_miss_num_map(p6_a0);
293 ddp_thldchk_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a1);
294 ddp_thldchk_rec.last_updated_by := rosetta_g_miss_num_map(p6_a2);
295 ddp_thldchk_rec.creation_date := rosetta_g_miss_date_in_map(p6_a3);
296 ddp_thldchk_rec.created_by := rosetta_g_miss_num_map(p6_a4);
297 ddp_thldchk_rec.last_update_login := rosetta_g_miss_num_map(p6_a5);
298 ddp_thldchk_rec.object_version_number := rosetta_g_miss_num_map(p6_a6);
299 ddp_thldchk_rec.trigger_id := rosetta_g_miss_num_map(p6_a7);
300 ddp_thldchk_rec.order_number := rosetta_g_miss_num_map(p6_a8);
301 ddp_thldchk_rec.chk1_type := p6_a9;
302 ddp_thldchk_rec.chk1_arc_source_code_from := p6_a10;
303 ddp_thldchk_rec.chk1_act_object_id := rosetta_g_miss_num_map(p6_a11);
304 ddp_thldchk_rec.chk1_source_code := p6_a12;
305 ddp_thldchk_rec.chk1_source_code_metric_id := rosetta_g_miss_num_map(p6_a13);
306 ddp_thldchk_rec.chk1_source_code_metric_type := p6_a14;
307 ddp_thldchk_rec.chk1_workbook_owner := rosetta_g_miss_num_map(p6_a15);
308 ddp_thldchk_rec.chk1_workbook_name := p6_a16;
309 ddp_thldchk_rec.chk1_to_chk2_operator_type := p6_a17;
310 ddp_thldchk_rec.chk2_type := p6_a18;
311 ddp_thldchk_rec.chk2_value := rosetta_g_miss_num_map(p6_a19);
312 ddp_thldchk_rec.chk2_low_value := rosetta_g_miss_num_map(p6_a20);
313 ddp_thldchk_rec.chk2_high_value := rosetta_g_miss_num_map(p6_a21);
314 ddp_thldchk_rec.chk2_uom_code := p6_a22;
315 ddp_thldchk_rec.chk2_currency_code := p6_a23;
316 ddp_thldchk_rec.chk2_source_code := p6_a24;
317 ddp_thldchk_rec.chk2_arc_source_code_from := p6_a25;
318 ddp_thldchk_rec.chk2_act_object_id := rosetta_g_miss_num_map(p6_a26);
319 ddp_thldchk_rec.chk2_source_code_metric_id := rosetta_g_miss_num_map(p6_a27);
320 ddp_thldchk_rec.chk2_source_code_metric_type := p6_a28;
321 ddp_thldchk_rec.chk2_workbook_name := p6_a29;
322 ddp_thldchk_rec.chk2_workbook_owner := p6_a30;
323 ddp_thldchk_rec.chk2_worksheet_name := p6_a31;
324
325 -- here's the delegated call to the old PL/SQL routine
326 ams_thldchk_pvt.validate_thldchk(p_api_version,
327 p_init_msg_list,
328 p_validation_level,
329 x_return_status,
330 x_msg_count,
331 x_msg_data,
332 ddp_thldchk_rec);
333
334 -- copy data back from the local variables to OUT or IN-OUT args, if any
335
336
337
338
339
340
341 end;
342
343 procedure check_thldchk_items(p_validation_mode VARCHAR2
344 , x_return_status out nocopy VARCHAR2
345 , p0_a0 NUMBER := 0-1962.0724
346 , p0_a1 DATE := fnd_api.g_miss_date
347 , p0_a2 NUMBER := 0-1962.0724
348 , p0_a3 DATE := fnd_api.g_miss_date
349 , p0_a4 NUMBER := 0-1962.0724
350 , p0_a5 NUMBER := 0-1962.0724
351 , p0_a6 NUMBER := 0-1962.0724
352 , p0_a7 NUMBER := 0-1962.0724
353 , p0_a8 NUMBER := 0-1962.0724
354 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
355 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
356 , p0_a11 NUMBER := 0-1962.0724
357 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
358 , p0_a13 NUMBER := 0-1962.0724
359 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
360 , p0_a15 NUMBER := 0-1962.0724
361 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
362 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
363 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
364 , p0_a19 NUMBER := 0-1962.0724
365 , p0_a20 NUMBER := 0-1962.0724
366 , p0_a21 NUMBER := 0-1962.0724
367 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
368 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
369 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
370 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
371 , p0_a26 NUMBER := 0-1962.0724
372 , p0_a27 NUMBER := 0-1962.0724
373 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
374 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
375 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
376 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
377 )
378
379 as
380 ddp_thldchk_rec ams_thldchk_pvt.thldchk_rec_type;
381 ddindx binary_integer; indx binary_integer;
382 begin
383
384 -- copy data to the local IN or IN-OUT args, if any
385 ddp_thldchk_rec.trigger_check_id := rosetta_g_miss_num_map(p0_a0);
386 ddp_thldchk_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
387 ddp_thldchk_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
388 ddp_thldchk_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
389 ddp_thldchk_rec.created_by := rosetta_g_miss_num_map(p0_a4);
390 ddp_thldchk_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
391 ddp_thldchk_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
392 ddp_thldchk_rec.trigger_id := rosetta_g_miss_num_map(p0_a7);
393 ddp_thldchk_rec.order_number := rosetta_g_miss_num_map(p0_a8);
394 ddp_thldchk_rec.chk1_type := p0_a9;
395 ddp_thldchk_rec.chk1_arc_source_code_from := p0_a10;
396 ddp_thldchk_rec.chk1_act_object_id := rosetta_g_miss_num_map(p0_a11);
397 ddp_thldchk_rec.chk1_source_code := p0_a12;
398 ddp_thldchk_rec.chk1_source_code_metric_id := rosetta_g_miss_num_map(p0_a13);
399 ddp_thldchk_rec.chk1_source_code_metric_type := p0_a14;
400 ddp_thldchk_rec.chk1_workbook_owner := rosetta_g_miss_num_map(p0_a15);
401 ddp_thldchk_rec.chk1_workbook_name := p0_a16;
402 ddp_thldchk_rec.chk1_to_chk2_operator_type := p0_a17;
403 ddp_thldchk_rec.chk2_type := p0_a18;
404 ddp_thldchk_rec.chk2_value := rosetta_g_miss_num_map(p0_a19);
405 ddp_thldchk_rec.chk2_low_value := rosetta_g_miss_num_map(p0_a20);
406 ddp_thldchk_rec.chk2_high_value := rosetta_g_miss_num_map(p0_a21);
407 ddp_thldchk_rec.chk2_uom_code := p0_a22;
408 ddp_thldchk_rec.chk2_currency_code := p0_a23;
409 ddp_thldchk_rec.chk2_source_code := p0_a24;
410 ddp_thldchk_rec.chk2_arc_source_code_from := p0_a25;
411 ddp_thldchk_rec.chk2_act_object_id := rosetta_g_miss_num_map(p0_a26);
412 ddp_thldchk_rec.chk2_source_code_metric_id := rosetta_g_miss_num_map(p0_a27);
413 ddp_thldchk_rec.chk2_source_code_metric_type := p0_a28;
414 ddp_thldchk_rec.chk2_workbook_name := p0_a29;
415 ddp_thldchk_rec.chk2_workbook_owner := p0_a30;
416 ddp_thldchk_rec.chk2_worksheet_name := p0_a31;
417
418
419
420 -- here's the delegated call to the old PL/SQL routine
421 ams_thldchk_pvt.check_thldchk_items(ddp_thldchk_rec,
422 p_validation_mode,
423 x_return_status);
424
425 -- copy data back from the local variables to OUT or IN-OUT args, if any
426
427
428 end;
429
430 procedure check_thldchk_record(x_return_status out nocopy VARCHAR2
431 , p0_a0 NUMBER := 0-1962.0724
432 , p0_a1 DATE := fnd_api.g_miss_date
433 , p0_a2 NUMBER := 0-1962.0724
434 , p0_a3 DATE := fnd_api.g_miss_date
435 , p0_a4 NUMBER := 0-1962.0724
436 , p0_a5 NUMBER := 0-1962.0724
437 , p0_a6 NUMBER := 0-1962.0724
438 , p0_a7 NUMBER := 0-1962.0724
439 , p0_a8 NUMBER := 0-1962.0724
440 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
441 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
442 , p0_a11 NUMBER := 0-1962.0724
443 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
444 , p0_a13 NUMBER := 0-1962.0724
445 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
446 , p0_a15 NUMBER := 0-1962.0724
447 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
448 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
449 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
450 , p0_a19 NUMBER := 0-1962.0724
451 , p0_a20 NUMBER := 0-1962.0724
452 , p0_a21 NUMBER := 0-1962.0724
453 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
454 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
455 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
456 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
457 , p0_a26 NUMBER := 0-1962.0724
458 , p0_a27 NUMBER := 0-1962.0724
459 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
460 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
461 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
462 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
463 , p1_a0 NUMBER := 0-1962.0724
464 , p1_a1 DATE := fnd_api.g_miss_date
465 , p1_a2 NUMBER := 0-1962.0724
466 , p1_a3 DATE := fnd_api.g_miss_date
467 , p1_a4 NUMBER := 0-1962.0724
468 , p1_a5 NUMBER := 0-1962.0724
469 , p1_a6 NUMBER := 0-1962.0724
470 , p1_a7 NUMBER := 0-1962.0724
471 , p1_a8 NUMBER := 0-1962.0724
472 , p1_a9 VARCHAR2 := fnd_api.g_miss_char
473 , p1_a10 VARCHAR2 := fnd_api.g_miss_char
474 , p1_a11 NUMBER := 0-1962.0724
475 , p1_a12 VARCHAR2 := fnd_api.g_miss_char
476 , p1_a13 NUMBER := 0-1962.0724
477 , p1_a14 VARCHAR2 := fnd_api.g_miss_char
478 , p1_a15 NUMBER := 0-1962.0724
479 , p1_a16 VARCHAR2 := fnd_api.g_miss_char
480 , p1_a17 VARCHAR2 := fnd_api.g_miss_char
481 , p1_a18 VARCHAR2 := fnd_api.g_miss_char
482 , p1_a19 NUMBER := 0-1962.0724
483 , p1_a20 NUMBER := 0-1962.0724
484 , p1_a21 NUMBER := 0-1962.0724
485 , p1_a22 VARCHAR2 := fnd_api.g_miss_char
486 , p1_a23 VARCHAR2 := fnd_api.g_miss_char
487 , p1_a24 VARCHAR2 := fnd_api.g_miss_char
488 , p1_a25 VARCHAR2 := fnd_api.g_miss_char
489 , p1_a26 NUMBER := 0-1962.0724
490 , p1_a27 NUMBER := 0-1962.0724
491 , p1_a28 VARCHAR2 := fnd_api.g_miss_char
492 , p1_a29 VARCHAR2 := fnd_api.g_miss_char
493 , p1_a30 VARCHAR2 := fnd_api.g_miss_char
494 , p1_a31 VARCHAR2 := fnd_api.g_miss_char
495 )
496
497 as
498 ddp_thldchk_rec ams_thldchk_pvt.thldchk_rec_type;
499 ddp_complete_rec ams_thldchk_pvt.thldchk_rec_type;
500 ddindx binary_integer; indx binary_integer;
501 begin
502
503 -- copy data to the local IN or IN-OUT args, if any
504 ddp_thldchk_rec.trigger_check_id := rosetta_g_miss_num_map(p0_a0);
505 ddp_thldchk_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
506 ddp_thldchk_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
507 ddp_thldchk_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
508 ddp_thldchk_rec.created_by := rosetta_g_miss_num_map(p0_a4);
509 ddp_thldchk_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
510 ddp_thldchk_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
511 ddp_thldchk_rec.trigger_id := rosetta_g_miss_num_map(p0_a7);
512 ddp_thldchk_rec.order_number := rosetta_g_miss_num_map(p0_a8);
513 ddp_thldchk_rec.chk1_type := p0_a9;
514 ddp_thldchk_rec.chk1_arc_source_code_from := p0_a10;
515 ddp_thldchk_rec.chk1_act_object_id := rosetta_g_miss_num_map(p0_a11);
516 ddp_thldchk_rec.chk1_source_code := p0_a12;
517 ddp_thldchk_rec.chk1_source_code_metric_id := rosetta_g_miss_num_map(p0_a13);
518 ddp_thldchk_rec.chk1_source_code_metric_type := p0_a14;
519 ddp_thldchk_rec.chk1_workbook_owner := rosetta_g_miss_num_map(p0_a15);
520 ddp_thldchk_rec.chk1_workbook_name := p0_a16;
521 ddp_thldchk_rec.chk1_to_chk2_operator_type := p0_a17;
522 ddp_thldchk_rec.chk2_type := p0_a18;
523 ddp_thldchk_rec.chk2_value := rosetta_g_miss_num_map(p0_a19);
524 ddp_thldchk_rec.chk2_low_value := rosetta_g_miss_num_map(p0_a20);
525 ddp_thldchk_rec.chk2_high_value := rosetta_g_miss_num_map(p0_a21);
526 ddp_thldchk_rec.chk2_uom_code := p0_a22;
527 ddp_thldchk_rec.chk2_currency_code := p0_a23;
528 ddp_thldchk_rec.chk2_source_code := p0_a24;
529 ddp_thldchk_rec.chk2_arc_source_code_from := p0_a25;
530 ddp_thldchk_rec.chk2_act_object_id := rosetta_g_miss_num_map(p0_a26);
531 ddp_thldchk_rec.chk2_source_code_metric_id := rosetta_g_miss_num_map(p0_a27);
532 ddp_thldchk_rec.chk2_source_code_metric_type := p0_a28;
533 ddp_thldchk_rec.chk2_workbook_name := p0_a29;
534 ddp_thldchk_rec.chk2_workbook_owner := p0_a30;
535 ddp_thldchk_rec.chk2_worksheet_name := p0_a31;
536
537 ddp_complete_rec.trigger_check_id := rosetta_g_miss_num_map(p1_a0);
538 ddp_complete_rec.last_update_date := rosetta_g_miss_date_in_map(p1_a1);
539 ddp_complete_rec.last_updated_by := rosetta_g_miss_num_map(p1_a2);
540 ddp_complete_rec.creation_date := rosetta_g_miss_date_in_map(p1_a3);
541 ddp_complete_rec.created_by := rosetta_g_miss_num_map(p1_a4);
542 ddp_complete_rec.last_update_login := rosetta_g_miss_num_map(p1_a5);
543 ddp_complete_rec.object_version_number := rosetta_g_miss_num_map(p1_a6);
544 ddp_complete_rec.trigger_id := rosetta_g_miss_num_map(p1_a7);
545 ddp_complete_rec.order_number := rosetta_g_miss_num_map(p1_a8);
546 ddp_complete_rec.chk1_type := p1_a9;
547 ddp_complete_rec.chk1_arc_source_code_from := p1_a10;
548 ddp_complete_rec.chk1_act_object_id := rosetta_g_miss_num_map(p1_a11);
549 ddp_complete_rec.chk1_source_code := p1_a12;
550 ddp_complete_rec.chk1_source_code_metric_id := rosetta_g_miss_num_map(p1_a13);
551 ddp_complete_rec.chk1_source_code_metric_type := p1_a14;
552 ddp_complete_rec.chk1_workbook_owner := rosetta_g_miss_num_map(p1_a15);
553 ddp_complete_rec.chk1_workbook_name := p1_a16;
554 ddp_complete_rec.chk1_to_chk2_operator_type := p1_a17;
555 ddp_complete_rec.chk2_type := p1_a18;
556 ddp_complete_rec.chk2_value := rosetta_g_miss_num_map(p1_a19);
557 ddp_complete_rec.chk2_low_value := rosetta_g_miss_num_map(p1_a20);
558 ddp_complete_rec.chk2_high_value := rosetta_g_miss_num_map(p1_a21);
559 ddp_complete_rec.chk2_uom_code := p1_a22;
560 ddp_complete_rec.chk2_currency_code := p1_a23;
561 ddp_complete_rec.chk2_source_code := p1_a24;
562 ddp_complete_rec.chk2_arc_source_code_from := p1_a25;
563 ddp_complete_rec.chk2_act_object_id := rosetta_g_miss_num_map(p1_a26);
564 ddp_complete_rec.chk2_source_code_metric_id := rosetta_g_miss_num_map(p1_a27);
565 ddp_complete_rec.chk2_source_code_metric_type := p1_a28;
566 ddp_complete_rec.chk2_workbook_name := p1_a29;
567 ddp_complete_rec.chk2_workbook_owner := p1_a30;
568 ddp_complete_rec.chk2_worksheet_name := p1_a31;
569
570
571 -- here's the delegated call to the old PL/SQL routine
572 ams_thldchk_pvt.check_thldchk_record(ddp_thldchk_rec,
573 ddp_complete_rec,
574 x_return_status);
575
576 -- copy data back from the local variables to OUT or IN-OUT args, if any
577
578
579 end;
580
581 procedure init_thldchk_rec(p0_a0 out nocopy NUMBER
582 , p0_a1 out nocopy DATE
583 , p0_a2 out nocopy NUMBER
584 , p0_a3 out nocopy DATE
585 , p0_a4 out nocopy NUMBER
586 , p0_a5 out nocopy NUMBER
587 , p0_a6 out nocopy NUMBER
588 , p0_a7 out nocopy NUMBER
589 , p0_a8 out nocopy NUMBER
590 , p0_a9 out nocopy VARCHAR2
591 , p0_a10 out nocopy VARCHAR2
592 , p0_a11 out nocopy NUMBER
593 , p0_a12 out nocopy VARCHAR2
594 , p0_a13 out nocopy NUMBER
595 , p0_a14 out nocopy VARCHAR2
596 , p0_a15 out nocopy NUMBER
597 , p0_a16 out nocopy VARCHAR2
598 , p0_a17 out nocopy VARCHAR2
599 , p0_a18 out nocopy VARCHAR2
600 , p0_a19 out nocopy NUMBER
601 , p0_a20 out nocopy NUMBER
602 , p0_a21 out nocopy NUMBER
603 , p0_a22 out nocopy VARCHAR2
604 , p0_a23 out nocopy VARCHAR2
605 , p0_a24 out nocopy VARCHAR2
606 , p0_a25 out nocopy VARCHAR2
607 , p0_a26 out nocopy NUMBER
608 , p0_a27 out nocopy NUMBER
609 , p0_a28 out nocopy VARCHAR2
610 , p0_a29 out nocopy VARCHAR2
611 , p0_a30 out nocopy VARCHAR2
612 , p0_a31 out nocopy VARCHAR2
613 )
614
615 as
616 ddx_thldchk_rec ams_thldchk_pvt.thldchk_rec_type;
617 ddindx binary_integer; indx binary_integer;
618 begin
619
620 -- copy data to the local IN or IN-OUT args, if any
621
622 -- here's the delegated call to the old PL/SQL routine
623 ams_thldchk_pvt.init_thldchk_rec(ddx_thldchk_rec);
624
625 -- copy data back from the local variables to OUT or IN-OUT args, if any
626 p0_a0 := rosetta_g_miss_num_map(ddx_thldchk_rec.trigger_check_id);
627 p0_a1 := ddx_thldchk_rec.last_update_date;
628 p0_a2 := rosetta_g_miss_num_map(ddx_thldchk_rec.last_updated_by);
629 p0_a3 := ddx_thldchk_rec.creation_date;
630 p0_a4 := rosetta_g_miss_num_map(ddx_thldchk_rec.created_by);
631 p0_a5 := rosetta_g_miss_num_map(ddx_thldchk_rec.last_update_login);
632 p0_a6 := rosetta_g_miss_num_map(ddx_thldchk_rec.object_version_number);
633 p0_a7 := rosetta_g_miss_num_map(ddx_thldchk_rec.trigger_id);
634 p0_a8 := rosetta_g_miss_num_map(ddx_thldchk_rec.order_number);
635 p0_a9 := ddx_thldchk_rec.chk1_type;
636 p0_a10 := ddx_thldchk_rec.chk1_arc_source_code_from;
637 p0_a11 := rosetta_g_miss_num_map(ddx_thldchk_rec.chk1_act_object_id);
638 p0_a12 := ddx_thldchk_rec.chk1_source_code;
639 p0_a13 := rosetta_g_miss_num_map(ddx_thldchk_rec.chk1_source_code_metric_id);
640 p0_a14 := ddx_thldchk_rec.chk1_source_code_metric_type;
641 p0_a15 := rosetta_g_miss_num_map(ddx_thldchk_rec.chk1_workbook_owner);
642 p0_a16 := ddx_thldchk_rec.chk1_workbook_name;
643 p0_a17 := ddx_thldchk_rec.chk1_to_chk2_operator_type;
644 p0_a18 := ddx_thldchk_rec.chk2_type;
645 p0_a19 := rosetta_g_miss_num_map(ddx_thldchk_rec.chk2_value);
646 p0_a20 := rosetta_g_miss_num_map(ddx_thldchk_rec.chk2_low_value);
647 p0_a21 := rosetta_g_miss_num_map(ddx_thldchk_rec.chk2_high_value);
648 p0_a22 := ddx_thldchk_rec.chk2_uom_code;
649 p0_a23 := ddx_thldchk_rec.chk2_currency_code;
650 p0_a24 := ddx_thldchk_rec.chk2_source_code;
651 p0_a25 := ddx_thldchk_rec.chk2_arc_source_code_from;
652 p0_a26 := rosetta_g_miss_num_map(ddx_thldchk_rec.chk2_act_object_id);
653 p0_a27 := rosetta_g_miss_num_map(ddx_thldchk_rec.chk2_source_code_metric_id);
654 p0_a28 := ddx_thldchk_rec.chk2_source_code_metric_type;
655 p0_a29 := ddx_thldchk_rec.chk2_workbook_name;
656 p0_a30 := ddx_thldchk_rec.chk2_workbook_owner;
657 p0_a31 := ddx_thldchk_rec.chk2_worksheet_name;
658 end;
659
660 procedure complete_thldchk_rec(p1_a0 out nocopy NUMBER
661 , p1_a1 out nocopy DATE
662 , p1_a2 out nocopy NUMBER
663 , p1_a3 out nocopy DATE
664 , p1_a4 out nocopy NUMBER
665 , p1_a5 out nocopy NUMBER
666 , p1_a6 out nocopy NUMBER
667 , p1_a7 out nocopy NUMBER
668 , p1_a8 out nocopy NUMBER
669 , p1_a9 out nocopy VARCHAR2
670 , p1_a10 out nocopy VARCHAR2
671 , p1_a11 out nocopy NUMBER
672 , p1_a12 out nocopy VARCHAR2
673 , p1_a13 out nocopy NUMBER
674 , p1_a14 out nocopy VARCHAR2
675 , p1_a15 out nocopy NUMBER
676 , p1_a16 out nocopy VARCHAR2
677 , p1_a17 out nocopy VARCHAR2
678 , p1_a18 out nocopy VARCHAR2
679 , p1_a19 out nocopy NUMBER
680 , p1_a20 out nocopy NUMBER
681 , p1_a21 out nocopy NUMBER
682 , p1_a22 out nocopy VARCHAR2
683 , p1_a23 out nocopy VARCHAR2
684 , p1_a24 out nocopy VARCHAR2
685 , p1_a25 out nocopy VARCHAR2
686 , p1_a26 out nocopy NUMBER
687 , p1_a27 out nocopy NUMBER
688 , p1_a28 out nocopy VARCHAR2
689 , p1_a29 out nocopy VARCHAR2
690 , p1_a30 out nocopy VARCHAR2
691 , p1_a31 out nocopy VARCHAR2
692 , p0_a0 NUMBER := 0-1962.0724
693 , p0_a1 DATE := fnd_api.g_miss_date
694 , p0_a2 NUMBER := 0-1962.0724
695 , p0_a3 DATE := fnd_api.g_miss_date
696 , p0_a4 NUMBER := 0-1962.0724
697 , p0_a5 NUMBER := 0-1962.0724
698 , p0_a6 NUMBER := 0-1962.0724
699 , p0_a7 NUMBER := 0-1962.0724
700 , p0_a8 NUMBER := 0-1962.0724
701 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
702 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
703 , p0_a11 NUMBER := 0-1962.0724
704 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
705 , p0_a13 NUMBER := 0-1962.0724
706 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
707 , p0_a15 NUMBER := 0-1962.0724
708 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
709 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
710 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
711 , p0_a19 NUMBER := 0-1962.0724
712 , p0_a20 NUMBER := 0-1962.0724
713 , p0_a21 NUMBER := 0-1962.0724
714 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
715 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
716 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
717 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
718 , p0_a26 NUMBER := 0-1962.0724
719 , p0_a27 NUMBER := 0-1962.0724
720 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
721 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
722 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
723 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
724 )
725
726 as
727 ddp_thldchk_rec ams_thldchk_pvt.thldchk_rec_type;
728 ddx_complete_rec ams_thldchk_pvt.thldchk_rec_type;
729 ddindx binary_integer; indx binary_integer;
730 begin
731
732 -- copy data to the local IN or IN-OUT args, if any
733 ddp_thldchk_rec.trigger_check_id := rosetta_g_miss_num_map(p0_a0);
734 ddp_thldchk_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
735 ddp_thldchk_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
736 ddp_thldchk_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
737 ddp_thldchk_rec.created_by := rosetta_g_miss_num_map(p0_a4);
738 ddp_thldchk_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
739 ddp_thldchk_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
740 ddp_thldchk_rec.trigger_id := rosetta_g_miss_num_map(p0_a7);
741 ddp_thldchk_rec.order_number := rosetta_g_miss_num_map(p0_a8);
742 ddp_thldchk_rec.chk1_type := p0_a9;
743 ddp_thldchk_rec.chk1_arc_source_code_from := p0_a10;
744 ddp_thldchk_rec.chk1_act_object_id := rosetta_g_miss_num_map(p0_a11);
745 ddp_thldchk_rec.chk1_source_code := p0_a12;
746 ddp_thldchk_rec.chk1_source_code_metric_id := rosetta_g_miss_num_map(p0_a13);
747 ddp_thldchk_rec.chk1_source_code_metric_type := p0_a14;
748 ddp_thldchk_rec.chk1_workbook_owner := rosetta_g_miss_num_map(p0_a15);
749 ddp_thldchk_rec.chk1_workbook_name := p0_a16;
750 ddp_thldchk_rec.chk1_to_chk2_operator_type := p0_a17;
751 ddp_thldchk_rec.chk2_type := p0_a18;
752 ddp_thldchk_rec.chk2_value := rosetta_g_miss_num_map(p0_a19);
753 ddp_thldchk_rec.chk2_low_value := rosetta_g_miss_num_map(p0_a20);
754 ddp_thldchk_rec.chk2_high_value := rosetta_g_miss_num_map(p0_a21);
755 ddp_thldchk_rec.chk2_uom_code := p0_a22;
756 ddp_thldchk_rec.chk2_currency_code := p0_a23;
757 ddp_thldchk_rec.chk2_source_code := p0_a24;
758 ddp_thldchk_rec.chk2_arc_source_code_from := p0_a25;
759 ddp_thldchk_rec.chk2_act_object_id := rosetta_g_miss_num_map(p0_a26);
760 ddp_thldchk_rec.chk2_source_code_metric_id := rosetta_g_miss_num_map(p0_a27);
761 ddp_thldchk_rec.chk2_source_code_metric_type := p0_a28;
762 ddp_thldchk_rec.chk2_workbook_name := p0_a29;
763 ddp_thldchk_rec.chk2_workbook_owner := p0_a30;
764 ddp_thldchk_rec.chk2_worksheet_name := p0_a31;
765
766
767 -- here's the delegated call to the old PL/SQL routine
768 ams_thldchk_pvt.complete_thldchk_rec(ddp_thldchk_rec,
769 ddx_complete_rec);
770
771 -- copy data back from the local variables to OUT or IN-OUT args, if any
772
773 p1_a0 := rosetta_g_miss_num_map(ddx_complete_rec.trigger_check_id);
774 p1_a1 := ddx_complete_rec.last_update_date;
775 p1_a2 := rosetta_g_miss_num_map(ddx_complete_rec.last_updated_by);
776 p1_a3 := ddx_complete_rec.creation_date;
777 p1_a4 := rosetta_g_miss_num_map(ddx_complete_rec.created_by);
778 p1_a5 := rosetta_g_miss_num_map(ddx_complete_rec.last_update_login);
779 p1_a6 := rosetta_g_miss_num_map(ddx_complete_rec.object_version_number);
780 p1_a7 := rosetta_g_miss_num_map(ddx_complete_rec.trigger_id);
781 p1_a8 := rosetta_g_miss_num_map(ddx_complete_rec.order_number);
782 p1_a9 := ddx_complete_rec.chk1_type;
783 p1_a10 := ddx_complete_rec.chk1_arc_source_code_from;
784 p1_a11 := rosetta_g_miss_num_map(ddx_complete_rec.chk1_act_object_id);
785 p1_a12 := ddx_complete_rec.chk1_source_code;
786 p1_a13 := rosetta_g_miss_num_map(ddx_complete_rec.chk1_source_code_metric_id);
787 p1_a14 := ddx_complete_rec.chk1_source_code_metric_type;
788 p1_a15 := rosetta_g_miss_num_map(ddx_complete_rec.chk1_workbook_owner);
789 p1_a16 := ddx_complete_rec.chk1_workbook_name;
790 p1_a17 := ddx_complete_rec.chk1_to_chk2_operator_type;
791 p1_a18 := ddx_complete_rec.chk2_type;
792 p1_a19 := rosetta_g_miss_num_map(ddx_complete_rec.chk2_value);
793 p1_a20 := rosetta_g_miss_num_map(ddx_complete_rec.chk2_low_value);
794 p1_a21 := rosetta_g_miss_num_map(ddx_complete_rec.chk2_high_value);
795 p1_a22 := ddx_complete_rec.chk2_uom_code;
796 p1_a23 := ddx_complete_rec.chk2_currency_code;
797 p1_a24 := ddx_complete_rec.chk2_source_code;
798 p1_a25 := ddx_complete_rec.chk2_arc_source_code_from;
799 p1_a26 := rosetta_g_miss_num_map(ddx_complete_rec.chk2_act_object_id);
800 p1_a27 := rosetta_g_miss_num_map(ddx_complete_rec.chk2_source_code_metric_id);
801 p1_a28 := ddx_complete_rec.chk2_source_code_metric_type;
802 p1_a29 := ddx_complete_rec.chk2_workbook_name;
803 p1_a30 := ddx_complete_rec.chk2_workbook_owner;
804 p1_a31 := ddx_complete_rec.chk2_worksheet_name;
805 end;
806
807 end ams_thldchk_pvt_w;