[Home] [Help]
PACKAGE BODY: APPS.AMS_DM_SCORE_PVT_W
Source
1 package body ams_dm_score_pvt_w as
2 /* $Header: amswdmsb.pls 120.1 2005/06/15 23:58:32 appldev $ */
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 function rosetta_g_miss_num_map(n number) return number as
7 a number := fnd_api.g_miss_num;
8 b number := 0-1962.0724;
9 begin
10 if n=a then return b; end if;
11 if n=b then return a; end if;
12 return n;
13 end;
14
15 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
16 function rosetta_g_miss_date_in_map(d date) return date as
17 begin
18 if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19 return d;
20 end;
21
22 procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_dm_score_pvt.dm_score_tbl_type, a0 JTF_NUMBER_TABLE
23 , a1 JTF_DATE_TABLE
24 , a2 JTF_NUMBER_TABLE
25 , a3 JTF_DATE_TABLE
26 , a4 JTF_NUMBER_TABLE
27 , a5 JTF_NUMBER_TABLE
28 , a6 JTF_NUMBER_TABLE
29 , a7 JTF_NUMBER_TABLE
30 , a8 JTF_NUMBER_TABLE
31 , a9 JTF_NUMBER_TABLE
32 , a10 JTF_VARCHAR2_TABLE_100
33 , a11 JTF_DATE_TABLE
34 , a12 JTF_NUMBER_TABLE
35 , a13 JTF_VARCHAR2_TABLE_100
36 , a14 JTF_VARCHAR2_TABLE_100
37 , a15 JTF_DATE_TABLE
38 , a16 JTF_NUMBER_TABLE
39 , a17 JTF_DATE_TABLE
40 , a18 JTF_DATE_TABLE
41 , a19 JTF_NUMBER_TABLE
42 , a20 JTF_NUMBER_TABLE
43 , a21 JTF_NUMBER_TABLE
44 , a22 JTF_NUMBER_TABLE
45 , a23 JTF_VARCHAR2_TABLE_100
46 , a24 JTF_NUMBER_TABLE
47 , a25 JTF_NUMBER_TABLE
48 , a26 JTF_NUMBER_TABLE
49 , a27 JTF_NUMBER_TABLE
50 , a28 JTF_VARCHAR2_TABLE_300
51 , a29 JTF_VARCHAR2_TABLE_200
52 , a30 JTF_VARCHAR2_TABLE_1000
53 , a31 JTF_VARCHAR2_TABLE_100
54 , a32 JTF_VARCHAR2_TABLE_200
55 , a33 JTF_VARCHAR2_TABLE_200
56 , a34 JTF_VARCHAR2_TABLE_200
57 , a35 JTF_VARCHAR2_TABLE_200
58 , a36 JTF_VARCHAR2_TABLE_200
59 , a37 JTF_VARCHAR2_TABLE_200
60 , a38 JTF_VARCHAR2_TABLE_200
61 , a39 JTF_VARCHAR2_TABLE_200
62 , a40 JTF_VARCHAR2_TABLE_200
63 , a41 JTF_VARCHAR2_TABLE_200
64 , a42 JTF_VARCHAR2_TABLE_200
65 , a43 JTF_VARCHAR2_TABLE_200
66 , a44 JTF_VARCHAR2_TABLE_200
67 , a45 JTF_VARCHAR2_TABLE_200
68 , a46 JTF_VARCHAR2_TABLE_200
69 ) as
70 ddindx binary_integer; indx binary_integer;
71 begin
72 if a0 is not null and a0.count > 0 then
73 if a0.count > 0 then
74 indx := a0.first;
75 ddindx := 1;
76 while true loop
77 t(ddindx).score_id := rosetta_g_miss_num_map(a0(indx));
78 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a1(indx));
79 t(ddindx).last_updated_by := rosetta_g_miss_num_map(a2(indx));
80 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a3(indx));
81 t(ddindx).created_by := rosetta_g_miss_num_map(a4(indx));
82 t(ddindx).last_update_login := rosetta_g_miss_num_map(a5(indx));
83 t(ddindx).object_version_number := rosetta_g_miss_num_map(a6(indx));
84 t(ddindx).org_id := rosetta_g_miss_num_map(a7(indx));
85 t(ddindx).model_id := rosetta_g_miss_num_map(a8(indx));
86 t(ddindx).user_status_id := rosetta_g_miss_num_map(a9(indx));
87 t(ddindx).status_code := a10(indx);
88 t(ddindx).status_date := rosetta_g_miss_date_in_map(a11(indx));
89 t(ddindx).owner_user_id := rosetta_g_miss_num_map(a12(indx));
90 t(ddindx).results_flag := a13(indx);
91 t(ddindx).logs_flag := a14(indx);
92 t(ddindx).scheduled_date := rosetta_g_miss_date_in_map(a15(indx));
93 t(ddindx).scheduled_timezone_id := rosetta_g_miss_num_map(a16(indx));
94 t(ddindx).score_date := rosetta_g_miss_date_in_map(a17(indx));
95 t(ddindx).expiration_date := rosetta_g_miss_date_in_map(a18(indx));
96 t(ddindx).total_records := rosetta_g_miss_num_map(a19(indx));
97 t(ddindx).total_positives := rosetta_g_miss_num_map(a20(indx));
98 t(ddindx).min_records := rosetta_g_miss_num_map(a21(indx));
99 t(ddindx).max_records := rosetta_g_miss_num_map(a22(indx));
100 t(ddindx).row_selection_type := a23(indx);
101 t(ddindx).every_nth_row := rosetta_g_miss_num_map(a24(indx));
102 t(ddindx).pct_random := rosetta_g_miss_num_map(a25(indx));
103 t(ddindx).custom_setup_id := rosetta_g_miss_num_map(a26(indx));
104 t(ddindx).country_id := rosetta_g_miss_num_map(a27(indx));
105 t(ddindx).wf_itemkey := a28(indx);
106 t(ddindx).score_name := a29(indx);
107 t(ddindx).description := a30(indx);
108 t(ddindx).attribute_category := a31(indx);
109 t(ddindx).attribute1 := a32(indx);
110 t(ddindx).attribute2 := a33(indx);
111 t(ddindx).attribute3 := a34(indx);
112 t(ddindx).attribute4 := a35(indx);
113 t(ddindx).attribute5 := a36(indx);
114 t(ddindx).attribute6 := a37(indx);
115 t(ddindx).attribute7 := a38(indx);
116 t(ddindx).attribute8 := a39(indx);
117 t(ddindx).attribute9 := a40(indx);
118 t(ddindx).attribute10 := a41(indx);
119 t(ddindx).attribute11 := a42(indx);
120 t(ddindx).attribute12 := a43(indx);
121 t(ddindx).attribute13 := a44(indx);
122 t(ddindx).attribute14 := a45(indx);
123 t(ddindx).attribute15 := a46(indx);
124 ddindx := ddindx+1;
125 if a0.last =indx
126 then exit;
127 end if;
128 indx := a0.next(indx);
129 end loop;
130 end if;
131 end if;
132 end rosetta_table_copy_in_p3;
133 procedure rosetta_table_copy_out_p3(t ams_dm_score_pvt.dm_score_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
134 , a1 OUT NOCOPY JTF_DATE_TABLE
135 , a2 OUT NOCOPY JTF_NUMBER_TABLE
136 , a3 OUT NOCOPY JTF_DATE_TABLE
137 , a4 OUT NOCOPY JTF_NUMBER_TABLE
138 , a5 OUT NOCOPY JTF_NUMBER_TABLE
139 , a6 OUT NOCOPY JTF_NUMBER_TABLE
140 , a7 OUT NOCOPY JTF_NUMBER_TABLE
141 , a8 OUT NOCOPY JTF_NUMBER_TABLE
142 , a9 OUT NOCOPY JTF_NUMBER_TABLE
143 , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
144 , a11 OUT NOCOPY JTF_DATE_TABLE
145 , a12 OUT NOCOPY JTF_NUMBER_TABLE
146 , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_100
147 , a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100
148 , a15 OUT NOCOPY JTF_DATE_TABLE
149 , a16 OUT NOCOPY JTF_NUMBER_TABLE
150 , a17 OUT NOCOPY JTF_DATE_TABLE
151 , a18 OUT NOCOPY JTF_DATE_TABLE
152 , a19 OUT NOCOPY JTF_NUMBER_TABLE
153 , a20 OUT NOCOPY JTF_NUMBER_TABLE
154 , a21 OUT NOCOPY JTF_NUMBER_TABLE
155 , a22 OUT NOCOPY JTF_NUMBER_TABLE
156 , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
157 , a24 OUT NOCOPY JTF_NUMBER_TABLE
158 , a25 OUT NOCOPY JTF_NUMBER_TABLE
159 , a26 OUT NOCOPY JTF_NUMBER_TABLE
160 , a27 OUT NOCOPY JTF_NUMBER_TABLE
161 , a28 OUT NOCOPY JTF_VARCHAR2_TABLE_300
162 , a29 OUT NOCOPY JTF_VARCHAR2_TABLE_200
163 , a30 OUT NOCOPY JTF_VARCHAR2_TABLE_1000
164 , a31 OUT NOCOPY JTF_VARCHAR2_TABLE_100
165 , a32 OUT NOCOPY JTF_VARCHAR2_TABLE_200
166 , a33 OUT NOCOPY JTF_VARCHAR2_TABLE_200
167 , a34 OUT NOCOPY JTF_VARCHAR2_TABLE_200
168 , a35 OUT NOCOPY JTF_VARCHAR2_TABLE_200
169 , a36 OUT NOCOPY JTF_VARCHAR2_TABLE_200
170 , a37 OUT NOCOPY JTF_VARCHAR2_TABLE_200
171 , a38 OUT NOCOPY JTF_VARCHAR2_TABLE_200
172 , a39 OUT NOCOPY JTF_VARCHAR2_TABLE_200
173 , a40 OUT NOCOPY JTF_VARCHAR2_TABLE_200
174 , a41 OUT NOCOPY JTF_VARCHAR2_TABLE_200
175 , a42 OUT NOCOPY JTF_VARCHAR2_TABLE_200
176 , a43 OUT NOCOPY JTF_VARCHAR2_TABLE_200
177 , a44 OUT NOCOPY JTF_VARCHAR2_TABLE_200
178 , a45 OUT NOCOPY JTF_VARCHAR2_TABLE_200
179 , a46 OUT NOCOPY JTF_VARCHAR2_TABLE_200
180 ) as
181 ddindx binary_integer; indx binary_integer;
182 begin
183 if t is null or t.count = 0 then
184 a0 := JTF_NUMBER_TABLE();
185 a1 := JTF_DATE_TABLE();
186 a2 := JTF_NUMBER_TABLE();
187 a3 := JTF_DATE_TABLE();
188 a4 := JTF_NUMBER_TABLE();
189 a5 := JTF_NUMBER_TABLE();
190 a6 := JTF_NUMBER_TABLE();
191 a7 := JTF_NUMBER_TABLE();
192 a8 := JTF_NUMBER_TABLE();
193 a9 := JTF_NUMBER_TABLE();
194 a10 := JTF_VARCHAR2_TABLE_100();
195 a11 := JTF_DATE_TABLE();
196 a12 := JTF_NUMBER_TABLE();
197 a13 := JTF_VARCHAR2_TABLE_100();
198 a14 := JTF_VARCHAR2_TABLE_100();
199 a15 := JTF_DATE_TABLE();
200 a16 := JTF_NUMBER_TABLE();
201 a17 := JTF_DATE_TABLE();
202 a18 := JTF_DATE_TABLE();
203 a19 := JTF_NUMBER_TABLE();
204 a20 := JTF_NUMBER_TABLE();
205 a21 := JTF_NUMBER_TABLE();
206 a22 := JTF_NUMBER_TABLE();
207 a23 := JTF_VARCHAR2_TABLE_100();
208 a24 := JTF_NUMBER_TABLE();
209 a25 := JTF_NUMBER_TABLE();
210 a26 := JTF_NUMBER_TABLE();
211 a27 := JTF_NUMBER_TABLE();
212 a28 := JTF_VARCHAR2_TABLE_300();
213 a29 := JTF_VARCHAR2_TABLE_200();
214 a30 := JTF_VARCHAR2_TABLE_1000();
215 a31 := JTF_VARCHAR2_TABLE_100();
216 a32 := JTF_VARCHAR2_TABLE_200();
217 a33 := JTF_VARCHAR2_TABLE_200();
218 a34 := JTF_VARCHAR2_TABLE_200();
219 a35 := JTF_VARCHAR2_TABLE_200();
220 a36 := JTF_VARCHAR2_TABLE_200();
221 a37 := JTF_VARCHAR2_TABLE_200();
222 a38 := JTF_VARCHAR2_TABLE_200();
223 a39 := JTF_VARCHAR2_TABLE_200();
224 a40 := JTF_VARCHAR2_TABLE_200();
225 a41 := JTF_VARCHAR2_TABLE_200();
226 a42 := JTF_VARCHAR2_TABLE_200();
227 a43 := JTF_VARCHAR2_TABLE_200();
228 a44 := JTF_VARCHAR2_TABLE_200();
229 a45 := JTF_VARCHAR2_TABLE_200();
230 a46 := JTF_VARCHAR2_TABLE_200();
231 else
232 a0 := JTF_NUMBER_TABLE();
233 a1 := JTF_DATE_TABLE();
234 a2 := JTF_NUMBER_TABLE();
235 a3 := JTF_DATE_TABLE();
236 a4 := JTF_NUMBER_TABLE();
237 a5 := JTF_NUMBER_TABLE();
238 a6 := JTF_NUMBER_TABLE();
239 a7 := JTF_NUMBER_TABLE();
240 a8 := JTF_NUMBER_TABLE();
241 a9 := JTF_NUMBER_TABLE();
242 a10 := JTF_VARCHAR2_TABLE_100();
243 a11 := JTF_DATE_TABLE();
244 a12 := JTF_NUMBER_TABLE();
245 a13 := JTF_VARCHAR2_TABLE_100();
246 a14 := JTF_VARCHAR2_TABLE_100();
247 a15 := JTF_DATE_TABLE();
248 a16 := JTF_NUMBER_TABLE();
249 a17 := JTF_DATE_TABLE();
250 a18 := JTF_DATE_TABLE();
251 a19 := JTF_NUMBER_TABLE();
252 a20 := JTF_NUMBER_TABLE();
253 a21 := JTF_NUMBER_TABLE();
254 a22 := JTF_NUMBER_TABLE();
255 a23 := JTF_VARCHAR2_TABLE_100();
256 a24 := JTF_NUMBER_TABLE();
257 a25 := JTF_NUMBER_TABLE();
258 a26 := JTF_NUMBER_TABLE();
259 a27 := JTF_NUMBER_TABLE();
260 a28 := JTF_VARCHAR2_TABLE_300();
261 a29 := JTF_VARCHAR2_TABLE_200();
262 a30 := JTF_VARCHAR2_TABLE_1000();
263 a31 := JTF_VARCHAR2_TABLE_100();
264 a32 := JTF_VARCHAR2_TABLE_200();
265 a33 := JTF_VARCHAR2_TABLE_200();
266 a34 := JTF_VARCHAR2_TABLE_200();
267 a35 := JTF_VARCHAR2_TABLE_200();
268 a36 := JTF_VARCHAR2_TABLE_200();
269 a37 := JTF_VARCHAR2_TABLE_200();
270 a38 := JTF_VARCHAR2_TABLE_200();
271 a39 := JTF_VARCHAR2_TABLE_200();
272 a40 := JTF_VARCHAR2_TABLE_200();
273 a41 := JTF_VARCHAR2_TABLE_200();
274 a42 := JTF_VARCHAR2_TABLE_200();
275 a43 := JTF_VARCHAR2_TABLE_200();
276 a44 := JTF_VARCHAR2_TABLE_200();
277 a45 := JTF_VARCHAR2_TABLE_200();
278 a46 := JTF_VARCHAR2_TABLE_200();
279 if t.count > 0 then
280 a0.extend(t.count);
281 a1.extend(t.count);
282 a2.extend(t.count);
283 a3.extend(t.count);
284 a4.extend(t.count);
285 a5.extend(t.count);
286 a6.extend(t.count);
287 a7.extend(t.count);
288 a8.extend(t.count);
289 a9.extend(t.count);
290 a10.extend(t.count);
291 a11.extend(t.count);
292 a12.extend(t.count);
293 a13.extend(t.count);
294 a14.extend(t.count);
295 a15.extend(t.count);
296 a16.extend(t.count);
297 a17.extend(t.count);
298 a18.extend(t.count);
299 a19.extend(t.count);
300 a20.extend(t.count);
301 a21.extend(t.count);
302 a22.extend(t.count);
303 a23.extend(t.count);
304 a24.extend(t.count);
305 a25.extend(t.count);
306 a26.extend(t.count);
307 a27.extend(t.count);
308 a28.extend(t.count);
309 a29.extend(t.count);
310 a30.extend(t.count);
311 a31.extend(t.count);
312 a32.extend(t.count);
313 a33.extend(t.count);
314 a34.extend(t.count);
315 a35.extend(t.count);
316 a36.extend(t.count);
317 a37.extend(t.count);
318 a38.extend(t.count);
319 a39.extend(t.count);
320 a40.extend(t.count);
321 a41.extend(t.count);
322 a42.extend(t.count);
323 a43.extend(t.count);
324 a44.extend(t.count);
325 a45.extend(t.count);
326 a46.extend(t.count);
327 ddindx := t.first;
328 indx := 1;
329 while true loop
330 a0(indx) := rosetta_g_miss_num_map(t(ddindx).score_id);
331 a1(indx) := t(ddindx).last_update_date;
332 a2(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
333 a3(indx) := t(ddindx).creation_date;
334 a4(indx) := rosetta_g_miss_num_map(t(ddindx).created_by);
335 a5(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
336 a6(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
337 a7(indx) := rosetta_g_miss_num_map(t(ddindx).org_id);
338 a8(indx) := rosetta_g_miss_num_map(t(ddindx).model_id);
339 a9(indx) := rosetta_g_miss_num_map(t(ddindx).user_status_id);
340 a10(indx) := t(ddindx).status_code;
341 a11(indx) := t(ddindx).status_date;
342 a12(indx) := rosetta_g_miss_num_map(t(ddindx).owner_user_id);
343 a13(indx) := t(ddindx).results_flag;
344 a14(indx) := t(ddindx).logs_flag;
345 a15(indx) := t(ddindx).scheduled_date;
346 a16(indx) := rosetta_g_miss_num_map(t(ddindx).scheduled_timezone_id);
347 a17(indx) := t(ddindx).score_date;
348 a18(indx) := t(ddindx).expiration_date;
349 a19(indx) := rosetta_g_miss_num_map(t(ddindx).total_records);
350 a20(indx) := rosetta_g_miss_num_map(t(ddindx).total_positives);
351 a21(indx) := rosetta_g_miss_num_map(t(ddindx).min_records);
352 a22(indx) := rosetta_g_miss_num_map(t(ddindx).max_records);
353 a23(indx) := t(ddindx).row_selection_type;
354 a24(indx) := rosetta_g_miss_num_map(t(ddindx).every_nth_row);
355 a25(indx) := rosetta_g_miss_num_map(t(ddindx).pct_random);
356 a26(indx) := rosetta_g_miss_num_map(t(ddindx).custom_setup_id);
357 a27(indx) := rosetta_g_miss_num_map(t(ddindx).country_id);
358 a28(indx) := t(ddindx).wf_itemkey;
359 a29(indx) := t(ddindx).score_name;
360 a30(indx) := t(ddindx).description;
361 a31(indx) := t(ddindx).attribute_category;
362 a32(indx) := t(ddindx).attribute1;
363 a33(indx) := t(ddindx).attribute2;
364 a34(indx) := t(ddindx).attribute3;
365 a35(indx) := t(ddindx).attribute4;
366 a36(indx) := t(ddindx).attribute5;
367 a37(indx) := t(ddindx).attribute6;
368 a38(indx) := t(ddindx).attribute7;
369 a39(indx) := t(ddindx).attribute8;
370 a40(indx) := t(ddindx).attribute9;
371 a41(indx) := t(ddindx).attribute10;
372 a42(indx) := t(ddindx).attribute11;
373 a43(indx) := t(ddindx).attribute12;
374 a44(indx) := t(ddindx).attribute13;
375 a45(indx) := t(ddindx).attribute14;
376 a46(indx) := t(ddindx).attribute15;
377 indx := indx+1;
378 if t.last =ddindx
379 then exit;
380 end if;
381 ddindx := t.next(ddindx);
382 end loop;
383 end if;
384 end if;
385 end rosetta_table_copy_out_p3;
386
387 procedure check_score_items(p_validation_mode VARCHAR2
388 , x_return_status OUT NOCOPY VARCHAR2
389 , p0_a0 NUMBER := 0-1962.0724
390 , p0_a1 DATE := fnd_api.g_miss_date
391 , p0_a2 NUMBER := 0-1962.0724
392 , p0_a3 DATE := fnd_api.g_miss_date
393 , p0_a4 NUMBER := 0-1962.0724
394 , p0_a5 NUMBER := 0-1962.0724
395 , p0_a6 NUMBER := 0-1962.0724
396 , p0_a7 NUMBER := 0-1962.0724
397 , p0_a8 NUMBER := 0-1962.0724
398 , p0_a9 NUMBER := 0-1962.0724
399 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
400 , p0_a11 DATE := fnd_api.g_miss_date
401 , p0_a12 NUMBER := 0-1962.0724
402 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
403 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
404 , p0_a15 DATE := fnd_api.g_miss_date
405 , p0_a16 NUMBER := 0-1962.0724
406 , p0_a17 DATE := fnd_api.g_miss_date
407 , p0_a18 DATE := fnd_api.g_miss_date
408 , p0_a19 NUMBER := 0-1962.0724
409 , p0_a20 NUMBER := 0-1962.0724
410 , p0_a21 NUMBER := 0-1962.0724
411 , p0_a22 NUMBER := 0-1962.0724
412 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
413 , p0_a24 NUMBER := 0-1962.0724
414 , p0_a25 NUMBER := 0-1962.0724
415 , p0_a26 NUMBER := 0-1962.0724
416 , p0_a27 NUMBER := 0-1962.0724
417 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
418 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
419 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
420 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
421 , p0_a32 VARCHAR2 := fnd_api.g_miss_char
422 , p0_a33 VARCHAR2 := fnd_api.g_miss_char
423 , p0_a34 VARCHAR2 := fnd_api.g_miss_char
424 , p0_a35 VARCHAR2 := fnd_api.g_miss_char
425 , p0_a36 VARCHAR2 := fnd_api.g_miss_char
426 , p0_a37 VARCHAR2 := fnd_api.g_miss_char
427 , p0_a38 VARCHAR2 := fnd_api.g_miss_char
428 , p0_a39 VARCHAR2 := fnd_api.g_miss_char
429 , p0_a40 VARCHAR2 := fnd_api.g_miss_char
430 , p0_a41 VARCHAR2 := fnd_api.g_miss_char
431 , p0_a42 VARCHAR2 := fnd_api.g_miss_char
432 , p0_a43 VARCHAR2 := fnd_api.g_miss_char
433 , p0_a44 VARCHAR2 := fnd_api.g_miss_char
434 , p0_a45 VARCHAR2 := fnd_api.g_miss_char
435 , p0_a46 VARCHAR2 := fnd_api.g_miss_char
436 )
437 as
438 ddp_score_rec ams_dm_score_pvt.score_rec_type;
439 ddindx binary_integer; indx binary_integer;
440 begin
441
442 -- copy data to the local IN or IN-OUT args, if any
443 ddp_score_rec.score_id := rosetta_g_miss_num_map(p0_a0);
444 ddp_score_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
445 ddp_score_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
446 ddp_score_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
447 ddp_score_rec.created_by := rosetta_g_miss_num_map(p0_a4);
448 ddp_score_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
449 ddp_score_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
450 ddp_score_rec.org_id := rosetta_g_miss_num_map(p0_a7);
451 ddp_score_rec.model_id := rosetta_g_miss_num_map(p0_a8);
452 ddp_score_rec.user_status_id := rosetta_g_miss_num_map(p0_a9);
453 ddp_score_rec.status_code := p0_a10;
454 ddp_score_rec.status_date := rosetta_g_miss_date_in_map(p0_a11);
455 ddp_score_rec.owner_user_id := rosetta_g_miss_num_map(p0_a12);
456 ddp_score_rec.results_flag := p0_a13;
457 ddp_score_rec.logs_flag := p0_a14;
458 ddp_score_rec.scheduled_date := rosetta_g_miss_date_in_map(p0_a15);
459 ddp_score_rec.scheduled_timezone_id := rosetta_g_miss_num_map(p0_a16);
460 ddp_score_rec.score_date := rosetta_g_miss_date_in_map(p0_a17);
461 ddp_score_rec.expiration_date := rosetta_g_miss_date_in_map(p0_a18);
462 ddp_score_rec.total_records := rosetta_g_miss_num_map(p0_a19);
463 ddp_score_rec.total_positives := rosetta_g_miss_num_map(p0_a20);
464 ddp_score_rec.min_records := rosetta_g_miss_num_map(p0_a21);
465 ddp_score_rec.max_records := rosetta_g_miss_num_map(p0_a22);
466 ddp_score_rec.row_selection_type := p0_a23;
467 ddp_score_rec.every_nth_row := rosetta_g_miss_num_map(p0_a24);
468 ddp_score_rec.pct_random := rosetta_g_miss_num_map(p0_a25);
469 ddp_score_rec.custom_setup_id := rosetta_g_miss_num_map(p0_a26);
470 ddp_score_rec.country_id := rosetta_g_miss_num_map(p0_a27);
471 ddp_score_rec.wf_itemkey := p0_a28;
472 ddp_score_rec.score_name := p0_a29;
473 ddp_score_rec.description := p0_a30;
474 ddp_score_rec.attribute_category := p0_a31;
475 ddp_score_rec.attribute1 := p0_a32;
476 ddp_score_rec.attribute2 := p0_a33;
477 ddp_score_rec.attribute3 := p0_a34;
478 ddp_score_rec.attribute4 := p0_a35;
479 ddp_score_rec.attribute5 := p0_a36;
480 ddp_score_rec.attribute6 := p0_a37;
481 ddp_score_rec.attribute7 := p0_a38;
482 ddp_score_rec.attribute8 := p0_a39;
483 ddp_score_rec.attribute9 := p0_a40;
484 ddp_score_rec.attribute10 := p0_a41;
485 ddp_score_rec.attribute11 := p0_a42;
486 ddp_score_rec.attribute12 := p0_a43;
487 ddp_score_rec.attribute13 := p0_a44;
488 ddp_score_rec.attribute14 := p0_a45;
489 ddp_score_rec.attribute15 := p0_a46;
490
491
492
493 -- here's the delegated call to the old PL/SQL routine
494 ams_dm_score_pvt.check_score_items(ddp_score_rec,
495 p_validation_mode,
496 x_return_status);
497
498 -- copy data back from the local OUT or IN-OUT args, if any
499
500
501 end;
502
503 procedure create_score(p_api_version NUMBER
504 , p_init_msg_list VARCHAR2
505 , p_commit VARCHAR2
506 , p_validation_level NUMBER
507 , x_return_status OUT NOCOPY VARCHAR2
508 , x_msg_count OUT NOCOPY NUMBER
509 , x_msg_data OUT NOCOPY VARCHAR2
510 , x_custom_setup_id OUT NOCOPY NUMBER
511 , x_score_id OUT NOCOPY NUMBER
512 , p7_a0 NUMBER := 0-1962.0724
513 , p7_a1 DATE := fnd_api.g_miss_date
514 , p7_a2 NUMBER := 0-1962.0724
515 , p7_a3 DATE := fnd_api.g_miss_date
516 , p7_a4 NUMBER := 0-1962.0724
517 , p7_a5 NUMBER := 0-1962.0724
518 , p7_a6 NUMBER := 0-1962.0724
519 , p7_a7 NUMBER := 0-1962.0724
520 , p7_a8 NUMBER := 0-1962.0724
521 , p7_a9 NUMBER := 0-1962.0724
522 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
523 , p7_a11 DATE := fnd_api.g_miss_date
524 , p7_a12 NUMBER := 0-1962.0724
525 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
526 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
527 , p7_a15 DATE := fnd_api.g_miss_date
528 , p7_a16 NUMBER := 0-1962.0724
529 , p7_a17 DATE := fnd_api.g_miss_date
530 , p7_a18 DATE := fnd_api.g_miss_date
531 , p7_a19 NUMBER := 0-1962.0724
532 , p7_a20 NUMBER := 0-1962.0724
533 , p7_a21 NUMBER := 0-1962.0724
534 , p7_a22 NUMBER := 0-1962.0724
535 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
536 , p7_a24 NUMBER := 0-1962.0724
537 , p7_a25 NUMBER := 0-1962.0724
538 , p7_a26 NUMBER := 0-1962.0724
539 , p7_a27 NUMBER := 0-1962.0724
540 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
541 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
542 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
543 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
544 , p7_a32 VARCHAR2 := fnd_api.g_miss_char
545 , p7_a33 VARCHAR2 := fnd_api.g_miss_char
546 , p7_a34 VARCHAR2 := fnd_api.g_miss_char
547 , p7_a35 VARCHAR2 := fnd_api.g_miss_char
548 , p7_a36 VARCHAR2 := fnd_api.g_miss_char
549 , p7_a37 VARCHAR2 := fnd_api.g_miss_char
550 , p7_a38 VARCHAR2 := fnd_api.g_miss_char
551 , p7_a39 VARCHAR2 := fnd_api.g_miss_char
552 , p7_a40 VARCHAR2 := fnd_api.g_miss_char
553 , p7_a41 VARCHAR2 := fnd_api.g_miss_char
554 , p7_a42 VARCHAR2 := fnd_api.g_miss_char
555 , p7_a43 VARCHAR2 := fnd_api.g_miss_char
556 , p7_a44 VARCHAR2 := fnd_api.g_miss_char
557 , p7_a45 VARCHAR2 := fnd_api.g_miss_char
558 , p7_a46 VARCHAR2 := fnd_api.g_miss_char
559 )
560 as
561 ddp_score_rec ams_dm_score_pvt.score_rec_type;
562 ddindx binary_integer; indx binary_integer;
563 begin
564
565 -- copy data to the local IN or IN-OUT args, if any
566
567
568
569
570
571
572
573 ddp_score_rec.score_id := rosetta_g_miss_num_map(p7_a0);
574 ddp_score_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
575 ddp_score_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
576 ddp_score_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
577 ddp_score_rec.created_by := rosetta_g_miss_num_map(p7_a4);
578 ddp_score_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
579 ddp_score_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
580 ddp_score_rec.org_id := rosetta_g_miss_num_map(p7_a7);
581 ddp_score_rec.model_id := rosetta_g_miss_num_map(p7_a8);
582 ddp_score_rec.user_status_id := rosetta_g_miss_num_map(p7_a9);
583 ddp_score_rec.status_code := p7_a10;
584 ddp_score_rec.status_date := rosetta_g_miss_date_in_map(p7_a11);
585 ddp_score_rec.owner_user_id := rosetta_g_miss_num_map(p7_a12);
586 ddp_score_rec.results_flag := p7_a13;
587 ddp_score_rec.logs_flag := p7_a14;
588 ddp_score_rec.scheduled_date := rosetta_g_miss_date_in_map(p7_a15);
589 ddp_score_rec.scheduled_timezone_id := rosetta_g_miss_num_map(p7_a16);
590 ddp_score_rec.score_date := rosetta_g_miss_date_in_map(p7_a17);
591 ddp_score_rec.expiration_date := rosetta_g_miss_date_in_map(p7_a18);
592 ddp_score_rec.total_records := rosetta_g_miss_num_map(p7_a19);
593 ddp_score_rec.total_positives := rosetta_g_miss_num_map(p7_a20);
594 ddp_score_rec.min_records := rosetta_g_miss_num_map(p7_a21);
595 ddp_score_rec.max_records := rosetta_g_miss_num_map(p7_a22);
596 ddp_score_rec.row_selection_type := p7_a23;
597 ddp_score_rec.every_nth_row := rosetta_g_miss_num_map(p7_a24);
598 ddp_score_rec.pct_random := rosetta_g_miss_num_map(p7_a25);
599 ddp_score_rec.custom_setup_id := rosetta_g_miss_num_map(p7_a26);
600 ddp_score_rec.country_id := rosetta_g_miss_num_map(p7_a27);
601 ddp_score_rec.wf_itemkey := p7_a28;
602 ddp_score_rec.score_name := p7_a29;
603 ddp_score_rec.description := p7_a30;
604 ddp_score_rec.attribute_category := p7_a31;
605 ddp_score_rec.attribute1 := p7_a32;
606 ddp_score_rec.attribute2 := p7_a33;
607 ddp_score_rec.attribute3 := p7_a34;
608 ddp_score_rec.attribute4 := p7_a35;
609 ddp_score_rec.attribute5 := p7_a36;
610 ddp_score_rec.attribute6 := p7_a37;
611 ddp_score_rec.attribute7 := p7_a38;
612 ddp_score_rec.attribute8 := p7_a39;
613 ddp_score_rec.attribute9 := p7_a40;
614 ddp_score_rec.attribute10 := p7_a41;
615 ddp_score_rec.attribute11 := p7_a42;
616 ddp_score_rec.attribute12 := p7_a43;
617 ddp_score_rec.attribute13 := p7_a44;
618 ddp_score_rec.attribute14 := p7_a45;
619 ddp_score_rec.attribute15 := p7_a46;
620
621
622
623 -- here's the delegated call to the old PL/SQL routine
624 ams_dm_score_pvt.create_score(p_api_version,
625 p_init_msg_list,
626 p_commit,
627 p_validation_level,
628 x_return_status,
629 x_msg_count,
630 x_msg_data,
631 ddp_score_rec,
632 x_custom_setup_id,
633 x_score_id);
634
635 -- copy data back from the local OUT or IN-OUT args, if any
636
637
638
639
640
641
642
643
644
645 end;
646
647 procedure update_score(p_api_version NUMBER
648 , p_init_msg_list VARCHAR2
649 , p_commit VARCHAR2
650 , p_validation_level NUMBER
651 , x_return_status OUT NOCOPY VARCHAR2
652 , x_msg_count OUT NOCOPY NUMBER
653 , x_msg_data OUT NOCOPY VARCHAR2
654 , x_object_version_number OUT NOCOPY NUMBER
655 , p7_a0 NUMBER := 0-1962.0724
656 , p7_a1 DATE := fnd_api.g_miss_date
657 , p7_a2 NUMBER := 0-1962.0724
658 , p7_a3 DATE := fnd_api.g_miss_date
659 , p7_a4 NUMBER := 0-1962.0724
660 , p7_a5 NUMBER := 0-1962.0724
661 , p7_a6 NUMBER := 0-1962.0724
662 , p7_a7 NUMBER := 0-1962.0724
663 , p7_a8 NUMBER := 0-1962.0724
664 , p7_a9 NUMBER := 0-1962.0724
665 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
666 , p7_a11 DATE := fnd_api.g_miss_date
667 , p7_a12 NUMBER := 0-1962.0724
668 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
669 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
670 , p7_a15 DATE := fnd_api.g_miss_date
671 , p7_a16 NUMBER := 0-1962.0724
672 , p7_a17 DATE := fnd_api.g_miss_date
673 , p7_a18 DATE := fnd_api.g_miss_date
674 , p7_a19 NUMBER := 0-1962.0724
675 , p7_a20 NUMBER := 0-1962.0724
676 , p7_a21 NUMBER := 0-1962.0724
677 , p7_a22 NUMBER := 0-1962.0724
678 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
679 , p7_a24 NUMBER := 0-1962.0724
680 , p7_a25 NUMBER := 0-1962.0724
681 , p7_a26 NUMBER := 0-1962.0724
682 , p7_a27 NUMBER := 0-1962.0724
683 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
684 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
685 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
686 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
687 , p7_a32 VARCHAR2 := fnd_api.g_miss_char
688 , p7_a33 VARCHAR2 := fnd_api.g_miss_char
689 , p7_a34 VARCHAR2 := fnd_api.g_miss_char
690 , p7_a35 VARCHAR2 := fnd_api.g_miss_char
691 , p7_a36 VARCHAR2 := fnd_api.g_miss_char
692 , p7_a37 VARCHAR2 := fnd_api.g_miss_char
693 , p7_a38 VARCHAR2 := fnd_api.g_miss_char
694 , p7_a39 VARCHAR2 := fnd_api.g_miss_char
695 , p7_a40 VARCHAR2 := fnd_api.g_miss_char
696 , p7_a41 VARCHAR2 := fnd_api.g_miss_char
697 , p7_a42 VARCHAR2 := fnd_api.g_miss_char
698 , p7_a43 VARCHAR2 := fnd_api.g_miss_char
699 , p7_a44 VARCHAR2 := fnd_api.g_miss_char
700 , p7_a45 VARCHAR2 := fnd_api.g_miss_char
701 , p7_a46 VARCHAR2 := fnd_api.g_miss_char
702 )
703 as
704 ddp_score_rec ams_dm_score_pvt.score_rec_type;
705 ddindx binary_integer; indx binary_integer;
706 begin
707
708 -- copy data to the local IN or IN-OUT args, if any
709
710
711
712
713
714
715
716 ddp_score_rec.score_id := rosetta_g_miss_num_map(p7_a0);
717 ddp_score_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
718 ddp_score_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
719 ddp_score_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
720 ddp_score_rec.created_by := rosetta_g_miss_num_map(p7_a4);
721 ddp_score_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
722 ddp_score_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
723 ddp_score_rec.org_id := rosetta_g_miss_num_map(p7_a7);
724 ddp_score_rec.model_id := rosetta_g_miss_num_map(p7_a8);
725 ddp_score_rec.user_status_id := rosetta_g_miss_num_map(p7_a9);
726 ddp_score_rec.status_code := p7_a10;
727 ddp_score_rec.status_date := rosetta_g_miss_date_in_map(p7_a11);
728 ddp_score_rec.owner_user_id := rosetta_g_miss_num_map(p7_a12);
729 ddp_score_rec.results_flag := p7_a13;
730 ddp_score_rec.logs_flag := p7_a14;
731 ddp_score_rec.scheduled_date := rosetta_g_miss_date_in_map(p7_a15);
732 ddp_score_rec.scheduled_timezone_id := rosetta_g_miss_num_map(p7_a16);
733 ddp_score_rec.score_date := rosetta_g_miss_date_in_map(p7_a17);
734 ddp_score_rec.expiration_date := rosetta_g_miss_date_in_map(p7_a18);
735 ddp_score_rec.total_records := rosetta_g_miss_num_map(p7_a19);
736 ddp_score_rec.total_positives := rosetta_g_miss_num_map(p7_a20);
737 ddp_score_rec.min_records := rosetta_g_miss_num_map(p7_a21);
738 ddp_score_rec.max_records := rosetta_g_miss_num_map(p7_a22);
739 ddp_score_rec.row_selection_type := p7_a23;
740 ddp_score_rec.every_nth_row := rosetta_g_miss_num_map(p7_a24);
741 ddp_score_rec.pct_random := rosetta_g_miss_num_map(p7_a25);
742 ddp_score_rec.custom_setup_id := rosetta_g_miss_num_map(p7_a26);
743 ddp_score_rec.country_id := rosetta_g_miss_num_map(p7_a27);
744 ddp_score_rec.wf_itemkey := p7_a28;
745 ddp_score_rec.score_name := p7_a29;
746 ddp_score_rec.description := p7_a30;
747 ddp_score_rec.attribute_category := p7_a31;
748 ddp_score_rec.attribute1 := p7_a32;
749 ddp_score_rec.attribute2 := p7_a33;
750 ddp_score_rec.attribute3 := p7_a34;
751 ddp_score_rec.attribute4 := p7_a35;
752 ddp_score_rec.attribute5 := p7_a36;
753 ddp_score_rec.attribute6 := p7_a37;
754 ddp_score_rec.attribute7 := p7_a38;
755 ddp_score_rec.attribute8 := p7_a39;
756 ddp_score_rec.attribute9 := p7_a40;
757 ddp_score_rec.attribute10 := p7_a41;
758 ddp_score_rec.attribute11 := p7_a42;
759 ddp_score_rec.attribute12 := p7_a43;
760 ddp_score_rec.attribute13 := p7_a44;
761 ddp_score_rec.attribute14 := p7_a45;
762 ddp_score_rec.attribute15 := p7_a46;
763
764
765 -- here's the delegated call to the old PL/SQL routine
766 ams_dm_score_pvt.update_score(p_api_version,
767 p_init_msg_list,
768 p_commit,
769 p_validation_level,
770 x_return_status,
771 x_msg_count,
772 x_msg_data,
773 ddp_score_rec,
774 x_object_version_number);
775
776 -- copy data back from the local OUT or IN-OUT args, if any
777
778
779
780
781
782
783
784
785 end;
786
787 procedure validate_score_rec(p_api_version NUMBER
788 , p_init_msg_list VARCHAR2
789 , p_validation_mode VARCHAR2
790 , x_return_status OUT NOCOPY VARCHAR2
791 , x_msg_count OUT NOCOPY NUMBER
792 , x_msg_data OUT NOCOPY VARCHAR2
793 , p6_a0 NUMBER := 0-1962.0724
794 , p6_a1 DATE := fnd_api.g_miss_date
795 , p6_a2 NUMBER := 0-1962.0724
796 , p6_a3 DATE := fnd_api.g_miss_date
797 , p6_a4 NUMBER := 0-1962.0724
798 , p6_a5 NUMBER := 0-1962.0724
799 , p6_a6 NUMBER := 0-1962.0724
800 , p6_a7 NUMBER := 0-1962.0724
801 , p6_a8 NUMBER := 0-1962.0724
802 , p6_a9 NUMBER := 0-1962.0724
803 , p6_a10 VARCHAR2 := fnd_api.g_miss_char
804 , p6_a11 DATE := fnd_api.g_miss_date
805 , p6_a12 NUMBER := 0-1962.0724
806 , p6_a13 VARCHAR2 := fnd_api.g_miss_char
807 , p6_a14 VARCHAR2 := fnd_api.g_miss_char
808 , p6_a15 DATE := fnd_api.g_miss_date
809 , p6_a16 NUMBER := 0-1962.0724
810 , p6_a17 DATE := fnd_api.g_miss_date
811 , p6_a18 DATE := fnd_api.g_miss_date
812 , p6_a19 NUMBER := 0-1962.0724
813 , p6_a20 NUMBER := 0-1962.0724
814 , p6_a21 NUMBER := 0-1962.0724
815 , p6_a22 NUMBER := 0-1962.0724
816 , p6_a23 VARCHAR2 := fnd_api.g_miss_char
817 , p6_a24 NUMBER := 0-1962.0724
818 , p6_a25 NUMBER := 0-1962.0724
819 , p6_a26 NUMBER := 0-1962.0724
820 , p6_a27 NUMBER := 0-1962.0724
821 , p6_a28 VARCHAR2 := fnd_api.g_miss_char
822 , p6_a29 VARCHAR2 := fnd_api.g_miss_char
823 , p6_a30 VARCHAR2 := fnd_api.g_miss_char
824 , p6_a31 VARCHAR2 := fnd_api.g_miss_char
825 , p6_a32 VARCHAR2 := fnd_api.g_miss_char
826 , p6_a33 VARCHAR2 := fnd_api.g_miss_char
827 , p6_a34 VARCHAR2 := fnd_api.g_miss_char
828 , p6_a35 VARCHAR2 := fnd_api.g_miss_char
829 , p6_a36 VARCHAR2 := fnd_api.g_miss_char
830 , p6_a37 VARCHAR2 := fnd_api.g_miss_char
831 , p6_a38 VARCHAR2 := fnd_api.g_miss_char
832 , p6_a39 VARCHAR2 := fnd_api.g_miss_char
833 , p6_a40 VARCHAR2 := fnd_api.g_miss_char
834 , p6_a41 VARCHAR2 := fnd_api.g_miss_char
835 , p6_a42 VARCHAR2 := fnd_api.g_miss_char
836 , p6_a43 VARCHAR2 := fnd_api.g_miss_char
837 , p6_a44 VARCHAR2 := fnd_api.g_miss_char
838 , p6_a45 VARCHAR2 := fnd_api.g_miss_char
839 , p6_a46 VARCHAR2 := fnd_api.g_miss_char
840 )
841 as
842 ddp_score_rec ams_dm_score_pvt.score_rec_type;
843 ddindx binary_integer; indx binary_integer;
844 begin
845
846 -- copy data to the local IN or IN-OUT args, if any
847
848
849
850
851
852
853 ddp_score_rec.score_id := rosetta_g_miss_num_map(p6_a0);
854 ddp_score_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a1);
855 ddp_score_rec.last_updated_by := rosetta_g_miss_num_map(p6_a2);
856 ddp_score_rec.creation_date := rosetta_g_miss_date_in_map(p6_a3);
857 ddp_score_rec.created_by := rosetta_g_miss_num_map(p6_a4);
858 ddp_score_rec.last_update_login := rosetta_g_miss_num_map(p6_a5);
859 ddp_score_rec.object_version_number := rosetta_g_miss_num_map(p6_a6);
860 ddp_score_rec.org_id := rosetta_g_miss_num_map(p6_a7);
861 ddp_score_rec.model_id := rosetta_g_miss_num_map(p6_a8);
862 ddp_score_rec.user_status_id := rosetta_g_miss_num_map(p6_a9);
863 ddp_score_rec.status_code := p6_a10;
864 ddp_score_rec.status_date := rosetta_g_miss_date_in_map(p6_a11);
865 ddp_score_rec.owner_user_id := rosetta_g_miss_num_map(p6_a12);
866 ddp_score_rec.results_flag := p6_a13;
867 ddp_score_rec.logs_flag := p6_a14;
868 ddp_score_rec.scheduled_date := rosetta_g_miss_date_in_map(p6_a15);
869 ddp_score_rec.scheduled_timezone_id := rosetta_g_miss_num_map(p6_a16);
870 ddp_score_rec.score_date := rosetta_g_miss_date_in_map(p6_a17);
871 ddp_score_rec.expiration_date := rosetta_g_miss_date_in_map(p6_a18);
872 ddp_score_rec.total_records := rosetta_g_miss_num_map(p6_a19);
873 ddp_score_rec.total_positives := rosetta_g_miss_num_map(p6_a20);
874 ddp_score_rec.min_records := rosetta_g_miss_num_map(p6_a21);
875 ddp_score_rec.max_records := rosetta_g_miss_num_map(p6_a22);
876 ddp_score_rec.row_selection_type := p6_a23;
877 ddp_score_rec.every_nth_row := rosetta_g_miss_num_map(p6_a24);
878 ddp_score_rec.pct_random := rosetta_g_miss_num_map(p6_a25);
879 ddp_score_rec.custom_setup_id := rosetta_g_miss_num_map(p6_a26);
880 ddp_score_rec.country_id := rosetta_g_miss_num_map(p6_a27);
881 ddp_score_rec.wf_itemkey := p6_a28;
882 ddp_score_rec.score_name := p6_a29;
883 ddp_score_rec.description := p6_a30;
884 ddp_score_rec.attribute_category := p6_a31;
885 ddp_score_rec.attribute1 := p6_a32;
886 ddp_score_rec.attribute2 := p6_a33;
887 ddp_score_rec.attribute3 := p6_a34;
888 ddp_score_rec.attribute4 := p6_a35;
889 ddp_score_rec.attribute5 := p6_a36;
890 ddp_score_rec.attribute6 := p6_a37;
891 ddp_score_rec.attribute7 := p6_a38;
892 ddp_score_rec.attribute8 := p6_a39;
893 ddp_score_rec.attribute9 := p6_a40;
894 ddp_score_rec.attribute10 := p6_a41;
895 ddp_score_rec.attribute11 := p6_a42;
896 ddp_score_rec.attribute12 := p6_a43;
897 ddp_score_rec.attribute13 := p6_a44;
898 ddp_score_rec.attribute14 := p6_a45;
899 ddp_score_rec.attribute15 := p6_a46;
900
901 -- here's the delegated call to the old PL/SQL routine
902 ams_dm_score_pvt.validate_score_rec(p_api_version,
903 p_init_msg_list,
904 p_validation_mode,
905 x_return_status,
906 x_msg_count,
907 x_msg_data,
908 ddp_score_rec);
909
910 -- copy data back from the local OUT or IN-OUT args, if any
911
912
913
914
915
916
917 end;
918
919 procedure validate_score(p_api_version NUMBER
920 , p_init_msg_list VARCHAR2
921 , p_validation_level NUMBER
922 , p_validation_mode VARCHAR2
923 , x_return_status OUT NOCOPY VARCHAR2
924 , x_msg_count OUT NOCOPY NUMBER
925 , x_msg_data OUT NOCOPY VARCHAR2
926 , p4_a0 NUMBER := 0-1962.0724
927 , p4_a1 DATE := fnd_api.g_miss_date
928 , p4_a2 NUMBER := 0-1962.0724
929 , p4_a3 DATE := fnd_api.g_miss_date
930 , p4_a4 NUMBER := 0-1962.0724
931 , p4_a5 NUMBER := 0-1962.0724
932 , p4_a6 NUMBER := 0-1962.0724
933 , p4_a7 NUMBER := 0-1962.0724
934 , p4_a8 NUMBER := 0-1962.0724
935 , p4_a9 NUMBER := 0-1962.0724
936 , p4_a10 VARCHAR2 := fnd_api.g_miss_char
937 , p4_a11 DATE := fnd_api.g_miss_date
938 , p4_a12 NUMBER := 0-1962.0724
939 , p4_a13 VARCHAR2 := fnd_api.g_miss_char
940 , p4_a14 VARCHAR2 := fnd_api.g_miss_char
941 , p4_a15 DATE := fnd_api.g_miss_date
942 , p4_a16 NUMBER := 0-1962.0724
943 , p4_a17 DATE := fnd_api.g_miss_date
944 , p4_a18 DATE := fnd_api.g_miss_date
945 , p4_a19 NUMBER := 0-1962.0724
946 , p4_a20 NUMBER := 0-1962.0724
947 , p4_a21 NUMBER := 0-1962.0724
948 , p4_a22 NUMBER := 0-1962.0724
949 , p4_a23 VARCHAR2 := fnd_api.g_miss_char
950 , p4_a24 NUMBER := 0-1962.0724
951 , p4_a25 NUMBER := 0-1962.0724
952 , p4_a26 NUMBER := 0-1962.0724
953 , p4_a27 NUMBER := 0-1962.0724
954 , p4_a28 VARCHAR2 := fnd_api.g_miss_char
955 , p4_a29 VARCHAR2 := fnd_api.g_miss_char
956 , p4_a30 VARCHAR2 := fnd_api.g_miss_char
957 , p4_a31 VARCHAR2 := fnd_api.g_miss_char
958 , p4_a32 VARCHAR2 := fnd_api.g_miss_char
959 , p4_a33 VARCHAR2 := fnd_api.g_miss_char
960 , p4_a34 VARCHAR2 := fnd_api.g_miss_char
961 , p4_a35 VARCHAR2 := fnd_api.g_miss_char
962 , p4_a36 VARCHAR2 := fnd_api.g_miss_char
963 , p4_a37 VARCHAR2 := fnd_api.g_miss_char
964 , p4_a38 VARCHAR2 := fnd_api.g_miss_char
965 , p4_a39 VARCHAR2 := fnd_api.g_miss_char
966 , p4_a40 VARCHAR2 := fnd_api.g_miss_char
967 , p4_a41 VARCHAR2 := fnd_api.g_miss_char
968 , p4_a42 VARCHAR2 := fnd_api.g_miss_char
969 , p4_a43 VARCHAR2 := fnd_api.g_miss_char
970 , p4_a44 VARCHAR2 := fnd_api.g_miss_char
971 , p4_a45 VARCHAR2 := fnd_api.g_miss_char
972 , p4_a46 VARCHAR2 := fnd_api.g_miss_char
973 )
974 as
975 ddp_score_rec ams_dm_score_pvt.score_rec_type;
976 ddindx binary_integer; indx binary_integer;
977 begin
978
979 -- copy data to the local IN or IN-OUT args, if any
980
981
982
983
984 ddp_score_rec.score_id := rosetta_g_miss_num_map(p4_a0);
985 ddp_score_rec.last_update_date := rosetta_g_miss_date_in_map(p4_a1);
986 ddp_score_rec.last_updated_by := rosetta_g_miss_num_map(p4_a2);
987 ddp_score_rec.creation_date := rosetta_g_miss_date_in_map(p4_a3);
988 ddp_score_rec.created_by := rosetta_g_miss_num_map(p4_a4);
989 ddp_score_rec.last_update_login := rosetta_g_miss_num_map(p4_a5);
990 ddp_score_rec.object_version_number := rosetta_g_miss_num_map(p4_a6);
991 ddp_score_rec.org_id := rosetta_g_miss_num_map(p4_a7);
992 ddp_score_rec.model_id := rosetta_g_miss_num_map(p4_a8);
993 ddp_score_rec.user_status_id := rosetta_g_miss_num_map(p4_a9);
994 ddp_score_rec.status_code := p4_a10;
995 ddp_score_rec.status_date := rosetta_g_miss_date_in_map(p4_a11);
996 ddp_score_rec.owner_user_id := rosetta_g_miss_num_map(p4_a12);
997 ddp_score_rec.results_flag := p4_a13;
998 ddp_score_rec.logs_flag := p4_a14;
999 ddp_score_rec.scheduled_date := rosetta_g_miss_date_in_map(p4_a15);
1000 ddp_score_rec.scheduled_timezone_id := rosetta_g_miss_num_map(p4_a16);
1001 ddp_score_rec.score_date := rosetta_g_miss_date_in_map(p4_a17);
1002 ddp_score_rec.expiration_date := rosetta_g_miss_date_in_map(p4_a18);
1003 ddp_score_rec.total_records := rosetta_g_miss_num_map(p4_a19);
1004 ddp_score_rec.total_positives := rosetta_g_miss_num_map(p4_a20);
1005 ddp_score_rec.min_records := rosetta_g_miss_num_map(p4_a21);
1006 ddp_score_rec.max_records := rosetta_g_miss_num_map(p4_a22);
1007 ddp_score_rec.row_selection_type := p4_a23;
1008 ddp_score_rec.every_nth_row := rosetta_g_miss_num_map(p4_a24);
1009 ddp_score_rec.pct_random := rosetta_g_miss_num_map(p4_a25);
1010 ddp_score_rec.custom_setup_id := rosetta_g_miss_num_map(p4_a26);
1011 ddp_score_rec.country_id := rosetta_g_miss_num_map(p4_a27);
1012 ddp_score_rec.wf_itemkey := p4_a28;
1013 ddp_score_rec.score_name := p4_a29;
1014 ddp_score_rec.description := p4_a30;
1015 ddp_score_rec.attribute_category := p4_a31;
1016 ddp_score_rec.attribute1 := p4_a32;
1017 ddp_score_rec.attribute2 := p4_a33;
1018 ddp_score_rec.attribute3 := p4_a34;
1019 ddp_score_rec.attribute4 := p4_a35;
1020 ddp_score_rec.attribute5 := p4_a36;
1021 ddp_score_rec.attribute6 := p4_a37;
1022 ddp_score_rec.attribute7 := p4_a38;
1023 ddp_score_rec.attribute8 := p4_a39;
1024 ddp_score_rec.attribute9 := p4_a40;
1025 ddp_score_rec.attribute10 := p4_a41;
1026 ddp_score_rec.attribute11 := p4_a42;
1027 ddp_score_rec.attribute12 := p4_a43;
1028 ddp_score_rec.attribute13 := p4_a44;
1029 ddp_score_rec.attribute14 := p4_a45;
1030 ddp_score_rec.attribute15 := p4_a46;
1031
1032
1033
1034
1035 -- here's the delegated call to the old PL/SQL routine
1036 ams_dm_score_pvt.validate_score(p_api_version,
1037 p_init_msg_list,
1038 p_validation_level,
1039 p_validation_mode,
1040 ddp_score_rec,
1041 x_return_status,
1042 x_msg_count,
1043 x_msg_data);
1044
1045 -- copy data back from the local OUT or IN-OUT args, if any
1046
1047
1048
1049
1050
1051
1052
1053 end;
1054
1055 procedure copy_score(p_api_version NUMBER
1056 , p_init_msg_list VARCHAR2
1057 , p_commit VARCHAR2
1058 , p_validation_level NUMBER
1059 , x_return_status OUT NOCOPY VARCHAR2
1060 , x_msg_count OUT NOCOPY NUMBER
1061 , x_msg_data OUT NOCOPY VARCHAR2
1062 , p_source_object_id NUMBER
1063 , p_attributes_table JTF_VARCHAR2_TABLE_100
1064 , p9_a0 JTF_VARCHAR2_TABLE_100
1065 , p9_a1 JTF_VARCHAR2_TABLE_4000
1066 , x_new_object_id OUT NOCOPY NUMBER
1067 , x_custom_setup_id OUT NOCOPY NUMBER
1068 )
1069 as
1070 ddp_attributes_table ams_cpyutility_pvt.copy_attributes_table_type;
1071 ddp_copy_columns_table ams_cpyutility_pvt.copy_columns_table_type;
1072 ddindx binary_integer; indx binary_integer;
1073 begin
1074
1075 -- copy data to the local IN or IN-OUT args, if any
1076
1077
1078
1079
1080
1081
1082
1083
1084 ams_cpyutility_pvt_w.rosetta_table_copy_in_p0(ddp_attributes_table, p_attributes_table);
1085
1086 ams_cpyutility_pvt_w.rosetta_table_copy_in_p2(ddp_copy_columns_table, p9_a0
1087 , p9_a1
1088 );
1089
1090
1091
1092 -- here's the delegated call to the old PL/SQL routine
1093 ams_dm_score_pvt.copy_score(p_api_version,
1094 p_init_msg_list,
1095 p_commit,
1096 p_validation_level,
1097 x_return_status,
1098 x_msg_count,
1099 x_msg_data,
1100 p_source_object_id,
1101 ddp_attributes_table,
1102 ddp_copy_columns_table,
1103 x_new_object_id,
1104 x_custom_setup_id);
1105
1106 -- copy data back from the local OUT or IN-OUT args, if any
1107
1108
1109
1110
1111
1112
1113
1114
1115
1116
1117
1118 end;
1119
1120 end ams_dm_score_pvt_w;