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