[Home] [Help]
PACKAGE: APPS.EAM_PMDEF_PUB_W
Source
1 package eam_pmdef_pub_w as
2 /* $Header: EAMWPMDS.pls 120.1 2005/08/17 08:19:08 ksiddhar noship $ */
3 procedure rosetta_table_copy_in_p2(t out nocopy eam_pmdef_pub.pm_activities_grp_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_VARCHAR2_TABLE_100
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_DATE_TABLE
9 , a6 JTF_DATE_TABLE
10 );
11 procedure rosetta_table_copy_out_p2(t eam_pmdef_pub.pm_activities_grp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
12 , a1 out nocopy JTF_NUMBER_TABLE
13 , a2 out nocopy JTF_NUMBER_TABLE
14 , a3 out nocopy JTF_VARCHAR2_TABLE_100
15 , a4 out nocopy JTF_NUMBER_TABLE
16 , a5 out nocopy JTF_DATE_TABLE
17 , a6 out nocopy JTF_DATE_TABLE
18 );
19
20 procedure rosetta_table_copy_in_p4(t out nocopy eam_pmdef_pub.pm_rule_tbl_type, a0 JTF_NUMBER_TABLE
21 , a1 JTF_NUMBER_TABLE
22 , a2 JTF_NUMBER_TABLE
23 , a3 JTF_NUMBER_TABLE
24 , a4 JTF_NUMBER_TABLE
25 , a5 JTF_NUMBER_TABLE
26 , a6 JTF_NUMBER_TABLE
27 , a7 JTF_NUMBER_TABLE
28 , a8 JTF_NUMBER_TABLE
29 , a9 JTF_DATE_TABLE
30 , a10 JTF_DATE_TABLE
31 , a11 JTF_DATE_TABLE
32 , a12 JTF_VARCHAR2_TABLE_100
33 );
34 procedure rosetta_table_copy_out_p4(t eam_pmdef_pub.pm_rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
35 , a1 out nocopy JTF_NUMBER_TABLE
36 , a2 out nocopy JTF_NUMBER_TABLE
37 , a3 out nocopy JTF_NUMBER_TABLE
38 , a4 out nocopy JTF_NUMBER_TABLE
39 , a5 out nocopy JTF_NUMBER_TABLE
40 , a6 out nocopy JTF_NUMBER_TABLE
41 , a7 out nocopy JTF_NUMBER_TABLE
42 , a8 out nocopy JTF_NUMBER_TABLE
43 , a9 out nocopy JTF_DATE_TABLE
44 , a10 out nocopy JTF_DATE_TABLE
45 , a11 out nocopy JTF_DATE_TABLE
46 , a12 out nocopy JTF_VARCHAR2_TABLE_100
47 );
48
49 procedure rosetta_table_copy_in_p6(t out nocopy eam_pmdef_pub.pm_date_tbl_type, a0 JTF_NUMBER_TABLE
50 , a1 JTF_DATE_TABLE
51 , a2 JTF_NUMBER_TABLE
52 );
53 procedure rosetta_table_copy_out_p6(t eam_pmdef_pub.pm_date_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
54 , a1 out nocopy JTF_DATE_TABLE
55 , a2 out nocopy JTF_NUMBER_TABLE
56 );
57
58 procedure rosetta_table_copy_in_p8(t out nocopy eam_pmdef_pub.pm_num_tbl_type, a0 JTF_NUMBER_TABLE
59 , a1 JTF_NUMBER_TABLE
60 , a2 JTF_NUMBER_TABLE
61 );
62 procedure rosetta_table_copy_out_p8(t eam_pmdef_pub.pm_num_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
63 , a1 out nocopy JTF_NUMBER_TABLE
64 , a2 out nocopy JTF_NUMBER_TABLE
65 );
66
67 procedure instantiate_pm_defs(p_api_version NUMBER
68 , p_init_msg_list VARCHAR2
69 , p_commit VARCHAR2
70 , p_validation_level NUMBER
71 , x_return_status out nocopy VARCHAR2
72 , x_msg_count out nocopy NUMBER
73 , x_msg_data out nocopy VARCHAR2
74 , p_activity_assoc_id_tbl JTF_NUMBER_TABLE
75 );
76 procedure create_pm_def(p_api_version NUMBER
77 , p_init_msg_list VARCHAR2
78 , p_commit VARCHAR2
79 , p_validation_level NUMBER
80 , x_return_status out nocopy VARCHAR2
81 , x_msg_count out nocopy NUMBER
82 , x_msg_data out nocopy VARCHAR2
83 , p7_a0 NUMBER
84 , p7_a1 NUMBER
85 , p7_a2 VARCHAR2
86 , p7_a3 DATE
87 , p7_a4 DATE
88 , p7_a5 NUMBER
89 , p7_a6 NUMBER
90 , p7_a7 VARCHAR2
91 , p7_a8 VARCHAR2
92 , p7_a9 VARCHAR2
93 , p7_a10 VARCHAR2
94 , p7_a11 VARCHAR2
95 , p7_a12 VARCHAR2
96 , p7_a13 VARCHAR2
97 , p7_a14 VARCHAR2
98 , p7_a15 VARCHAR2
99 , p7_a16 VARCHAR2
100 , p7_a17 VARCHAR2
101 , p7_a18 VARCHAR2
102 , p7_a19 VARCHAR2
103 , p7_a20 VARCHAR2
104 , p7_a21 VARCHAR2
105 , p7_a22 VARCHAR2
106 , p7_a23 NUMBER
107 , p7_a24 VARCHAR2
108 , p7_a25 VARCHAR2
109 , p7_a26 VARCHAR2
110 , p7_a27 VARCHAR2
111 , p7_a28 VARCHAR2
112 , p7_a29 NUMBER
113 , p7_a30 NUMBER
114 , p7_a31 NUMBER
115 , p7_a32 DATE
116 , p7_a33 DATE
117 , p7_a34 NUMBER
118 , p7_a35 VARCHAR2
119 , p7_a36 VARCHAR2
120 , p7_a37 VARCHAR2
121 , p7_a38 NUMBER
122 , p7_a39 NUMBER
123 , p7_a40 NUMBER
124 , p7_a41 NUMBER
125 , p7_a42 NUMBER
126 , p7_a43 DATE
127 , p7_a44 NUMBER
128 , p7_a45 NUMBER
129 , p7_a46 NUMBER
130 , p7_a47 NUMBER
131 , p8_a0 JTF_NUMBER_TABLE
132 , p8_a1 JTF_NUMBER_TABLE
133 , p8_a2 JTF_NUMBER_TABLE
134 , p8_a3 JTF_VARCHAR2_TABLE_100
135 , p8_a4 JTF_NUMBER_TABLE
136 , p8_a5 JTF_DATE_TABLE
137 , p8_a6 JTF_DATE_TABLE
138 , p9_a0 JTF_NUMBER_TABLE
139 , p9_a1 JTF_NUMBER_TABLE
140 , p9_a2 JTF_NUMBER_TABLE
141 , p9_a3 JTF_NUMBER_TABLE
142 , p9_a4 JTF_NUMBER_TABLE
143 , p9_a5 JTF_NUMBER_TABLE
144 , p9_a6 JTF_NUMBER_TABLE
145 , p9_a7 JTF_NUMBER_TABLE
146 , p9_a8 JTF_NUMBER_TABLE
147 , p9_a9 JTF_DATE_TABLE
148 , p9_a10 JTF_DATE_TABLE
149 , p9_a11 JTF_DATE_TABLE
150 , p9_a12 JTF_VARCHAR2_TABLE_100
151 , p10_a0 JTF_NUMBER_TABLE
152 , p10_a1 JTF_NUMBER_TABLE
153 , p10_a2 JTF_NUMBER_TABLE
154 , p10_a3 JTF_NUMBER_TABLE
155 , p10_a4 JTF_NUMBER_TABLE
156 , p10_a5 JTF_NUMBER_TABLE
157 , p10_a6 JTF_NUMBER_TABLE
158 , p10_a7 JTF_NUMBER_TABLE
159 , p10_a8 JTF_NUMBER_TABLE
160 , p10_a9 JTF_DATE_TABLE
161 , p10_a10 JTF_DATE_TABLE
162 , p10_a11 JTF_DATE_TABLE
163 , p10_a12 JTF_VARCHAR2_TABLE_100
164 , p11_a0 JTF_NUMBER_TABLE
165 , p11_a1 JTF_NUMBER_TABLE
166 , p11_a2 JTF_NUMBER_TABLE
167 , p11_a3 JTF_NUMBER_TABLE
168 , p11_a4 JTF_NUMBER_TABLE
169 , p11_a5 JTF_NUMBER_TABLE
170 , p11_a6 JTF_NUMBER_TABLE
171 , p11_a7 JTF_NUMBER_TABLE
172 , p11_a8 JTF_NUMBER_TABLE
173 , p11_a9 JTF_DATE_TABLE
174 , p11_a10 JTF_DATE_TABLE
175 , p11_a11 JTF_DATE_TABLE
176 , p11_a12 JTF_VARCHAR2_TABLE_100
177 , x_new_pm_schedule_id out nocopy NUMBER
178 );
179 procedure update_pm_def(p_api_version NUMBER
180 , p_init_msg_list VARCHAR2
181 , p_commit VARCHAR2
182 , p_validation_level NUMBER
183 , x_return_status out nocopy VARCHAR2
184 , x_msg_count out nocopy NUMBER
185 , x_msg_data out nocopy VARCHAR2
186 , p7_a0 NUMBER
187 , p7_a1 NUMBER
188 , p7_a2 VARCHAR2
189 , p7_a3 DATE
190 , p7_a4 DATE
191 , p7_a5 NUMBER
192 , p7_a6 NUMBER
193 , p7_a7 VARCHAR2
194 , p7_a8 VARCHAR2
195 , p7_a9 VARCHAR2
196 , p7_a10 VARCHAR2
197 , p7_a11 VARCHAR2
198 , p7_a12 VARCHAR2
199 , p7_a13 VARCHAR2
200 , p7_a14 VARCHAR2
201 , p7_a15 VARCHAR2
202 , p7_a16 VARCHAR2
203 , p7_a17 VARCHAR2
204 , p7_a18 VARCHAR2
205 , p7_a19 VARCHAR2
206 , p7_a20 VARCHAR2
207 , p7_a21 VARCHAR2
208 , p7_a22 VARCHAR2
209 , p7_a23 NUMBER
210 , p7_a24 VARCHAR2
211 , p7_a25 VARCHAR2
212 , p7_a26 VARCHAR2
213 , p7_a27 VARCHAR2
214 , p7_a28 VARCHAR2
215 , p7_a29 NUMBER
216 , p7_a30 NUMBER
217 , p7_a31 NUMBER
218 , p7_a32 DATE
219 , p7_a33 DATE
220 , p7_a34 NUMBER
221 , p7_a35 VARCHAR2
222 , p7_a36 VARCHAR2
223 , p7_a37 VARCHAR2
224 , p7_a38 NUMBER
225 , p7_a39 NUMBER
226 , p7_a40 NUMBER
227 , p7_a41 NUMBER
228 , p7_a42 NUMBER
229 , p7_a43 DATE
230 , p7_a44 NUMBER
231 , p7_a45 NUMBER
232 , p7_a46 NUMBER
233 , p7_a47 NUMBER
234 , p8_a0 JTF_NUMBER_TABLE
235 , p8_a1 JTF_NUMBER_TABLE
236 , p8_a2 JTF_NUMBER_TABLE
237 , p8_a3 JTF_VARCHAR2_TABLE_100
238 , p8_a4 JTF_NUMBER_TABLE
239 , p8_a5 JTF_DATE_TABLE
240 , p8_a6 JTF_DATE_TABLE
241 , p9_a0 JTF_NUMBER_TABLE
242 , p9_a1 JTF_NUMBER_TABLE
243 , p9_a2 JTF_NUMBER_TABLE
244 , p9_a3 JTF_NUMBER_TABLE
245 , p9_a4 JTF_NUMBER_TABLE
246 , p9_a5 JTF_NUMBER_TABLE
247 , p9_a6 JTF_NUMBER_TABLE
248 , p9_a7 JTF_NUMBER_TABLE
249 , p9_a8 JTF_NUMBER_TABLE
250 , p9_a9 JTF_DATE_TABLE
251 , p9_a10 JTF_DATE_TABLE
252 , p9_a11 JTF_DATE_TABLE
253 , p9_a12 JTF_VARCHAR2_TABLE_100
254 , p10_a0 JTF_NUMBER_TABLE
255 , p10_a1 JTF_NUMBER_TABLE
256 , p10_a2 JTF_NUMBER_TABLE
257 , p10_a3 JTF_NUMBER_TABLE
258 , p10_a4 JTF_NUMBER_TABLE
259 , p10_a5 JTF_NUMBER_TABLE
260 , p10_a6 JTF_NUMBER_TABLE
261 , p10_a7 JTF_NUMBER_TABLE
262 , p10_a8 JTF_NUMBER_TABLE
263 , p10_a9 JTF_DATE_TABLE
264 , p10_a10 JTF_DATE_TABLE
265 , p10_a11 JTF_DATE_TABLE
266 , p10_a12 JTF_VARCHAR2_TABLE_100
267 , p11_a0 JTF_NUMBER_TABLE
268 , p11_a1 JTF_NUMBER_TABLE
269 , p11_a2 JTF_NUMBER_TABLE
270 , p11_a3 JTF_NUMBER_TABLE
271 , p11_a4 JTF_NUMBER_TABLE
272 , p11_a5 JTF_NUMBER_TABLE
273 , p11_a6 JTF_NUMBER_TABLE
274 , p11_a7 JTF_NUMBER_TABLE
275 , p11_a8 JTF_NUMBER_TABLE
276 , p11_a9 JTF_DATE_TABLE
277 , p11_a10 JTF_DATE_TABLE
278 , p11_a11 JTF_DATE_TABLE
279 , p11_a12 JTF_VARCHAR2_TABLE_100
280 );
281 procedure validate_pm_header(p0_a0 NUMBER
282 , p0_a1 NUMBER
283 , p0_a2 VARCHAR2
284 , p0_a3 DATE
285 , p0_a4 DATE
286 , p0_a5 NUMBER
287 , p0_a6 NUMBER
288 , p0_a7 VARCHAR2
289 , p0_a8 VARCHAR2
290 , p0_a9 VARCHAR2
291 , p0_a10 VARCHAR2
292 , p0_a11 VARCHAR2
293 , p0_a12 VARCHAR2
294 , p0_a13 VARCHAR2
295 , p0_a14 VARCHAR2
296 , p0_a15 VARCHAR2
297 , p0_a16 VARCHAR2
298 , p0_a17 VARCHAR2
299 , p0_a18 VARCHAR2
300 , p0_a19 VARCHAR2
301 , p0_a20 VARCHAR2
302 , p0_a21 VARCHAR2
303 , p0_a22 VARCHAR2
304 , p0_a23 NUMBER
305 , p0_a24 VARCHAR2
306 , p0_a25 VARCHAR2
307 , p0_a26 VARCHAR2
308 , p0_a27 VARCHAR2
309 , p0_a28 VARCHAR2
310 , p0_a29 NUMBER
311 , p0_a30 NUMBER
312 , p0_a31 NUMBER
313 , p0_a32 DATE
314 , p0_a33 DATE
315 , p0_a34 NUMBER
316 , p0_a35 VARCHAR2
317 , p0_a36 VARCHAR2
318 , p0_a37 VARCHAR2
319 , p0_a38 NUMBER
320 , p0_a39 NUMBER
321 , p0_a40 NUMBER
322 , p0_a41 NUMBER
323 , p0_a42 NUMBER
324 , p0_a43 DATE
325 , p0_a44 NUMBER
326 , p0_a45 NUMBER
327 , p0_a46 NUMBER
328 , p0_a47 NUMBER
329 , x_reason_failed out nocopy VARCHAR2
330 , ddrosetta_retval_bool OUT NOCOPY NUMBER
331 );
332 procedure validate_pm_day_interval_rule(p0_a0 NUMBER
333 , p0_a1 NUMBER
334 , p0_a2 NUMBER
335 , p0_a3 NUMBER
336 , p0_a4 NUMBER
337 , p0_a5 NUMBER
338 , p0_a6 NUMBER
339 , p0_a7 NUMBER
340 , p0_a8 NUMBER
341 , p0_a9 DATE
342 , p0_a10 DATE
343 , p0_a11 DATE
344 , p0_a12 VARCHAR2
345 , x_reason_failed out nocopy VARCHAR2
346 , ddrosetta_retval_bool OUT NOCOPY NUMBER
347 );
348 procedure validate_pm_runtime_rule(p0_a0 NUMBER
349 , p0_a1 NUMBER
350 , p0_a2 NUMBER
351 , p0_a3 NUMBER
352 , p0_a4 NUMBER
353 , p0_a5 NUMBER
354 , p0_a6 NUMBER
355 , p0_a7 NUMBER
356 , p0_a8 NUMBER
357 , p0_a9 DATE
358 , p0_a10 DATE
359 , p0_a11 DATE
360 , p0_a12 VARCHAR2
361 , x_reason_failed out nocopy VARCHAR2
362 , ddrosetta_retval_bool OUT NOCOPY NUMBER
363 );
364 procedure validate_pm_list_date(p0_a0 NUMBER
365 , p0_a1 NUMBER
366 , p0_a2 NUMBER
367 , p0_a3 NUMBER
368 , p0_a4 NUMBER
369 , p0_a5 NUMBER
370 , p0_a6 NUMBER
371 , p0_a7 NUMBER
372 , p0_a8 NUMBER
373 , p0_a9 DATE
374 , p0_a10 DATE
375 , p0_a11 DATE
376 , p0_a12 VARCHAR2
377 , x_reason_failed out nocopy VARCHAR2
381 , p0_a1 JTF_NUMBER_TABLE
378 , ddrosetta_retval_bool OUT NOCOPY NUMBER
379 );
380 procedure validate_pm_day_interval_rules(p0_a0 JTF_NUMBER_TABLE
382 , p0_a2 JTF_NUMBER_TABLE
383 , p0_a3 JTF_NUMBER_TABLE
384 , p0_a4 JTF_NUMBER_TABLE
385 , p0_a5 JTF_NUMBER_TABLE
386 , p0_a6 JTF_NUMBER_TABLE
387 , p0_a7 JTF_NUMBER_TABLE
388 , p0_a8 JTF_NUMBER_TABLE
389 , p0_a9 JTF_DATE_TABLE
390 , p0_a10 JTF_DATE_TABLE
391 , p0_a11 JTF_DATE_TABLE
392 , p0_a12 JTF_VARCHAR2_TABLE_100
393 , x_reason_failed out nocopy VARCHAR2
394 , ddrosetta_retval_bool OUT NOCOPY NUMBER
395 );
396 procedure validate_pm_runtime_rules(p0_a0 JTF_NUMBER_TABLE
397 , p0_a1 JTF_NUMBER_TABLE
398 , p0_a2 JTF_NUMBER_TABLE
399 , p0_a3 JTF_NUMBER_TABLE
400 , p0_a4 JTF_NUMBER_TABLE
401 , p0_a5 JTF_NUMBER_TABLE
402 , p0_a6 JTF_NUMBER_TABLE
403 , p0_a7 JTF_NUMBER_TABLE
404 , p0_a8 JTF_NUMBER_TABLE
405 , p0_a9 JTF_DATE_TABLE
406 , p0_a10 JTF_DATE_TABLE
407 , p0_a11 JTF_DATE_TABLE
408 , p0_a12 JTF_VARCHAR2_TABLE_100
409 , x_reason_failed out nocopy VARCHAR2
410 , ddrosetta_retval_bool OUT NOCOPY NUMBER
411 );
412 procedure validate_pm_list_date_rules(p0_a0 JTF_NUMBER_TABLE
413 , p0_a1 JTF_NUMBER_TABLE
414 , p0_a2 JTF_NUMBER_TABLE
415 , p0_a3 JTF_NUMBER_TABLE
416 , p0_a4 JTF_NUMBER_TABLE
417 , p0_a5 JTF_NUMBER_TABLE
418 , p0_a6 JTF_NUMBER_TABLE
419 , p0_a7 JTF_NUMBER_TABLE
420 , p0_a8 JTF_NUMBER_TABLE
421 , p0_a9 JTF_DATE_TABLE
422 , p0_a10 JTF_DATE_TABLE
423 , p0_a11 JTF_DATE_TABLE
424 , p0_a12 JTF_VARCHAR2_TABLE_100
425 , x_reason_failed out nocopy VARCHAR2
426 , ddrosetta_retval_bool OUT NOCOPY NUMBER
427 );
428 procedure validate_pm_header_and_rules(p0_a0 NUMBER
429 , p0_a1 NUMBER
430 , p0_a2 VARCHAR2
431 , p0_a3 DATE
432 , p0_a4 DATE
433 , p0_a5 NUMBER
434 , p0_a6 NUMBER
435 , p0_a7 VARCHAR2
436 , p0_a8 VARCHAR2
437 , p0_a9 VARCHAR2
438 , p0_a10 VARCHAR2
439 , p0_a11 VARCHAR2
440 , p0_a12 VARCHAR2
441 , p0_a13 VARCHAR2
442 , p0_a14 VARCHAR2
443 , p0_a15 VARCHAR2
444 , p0_a16 VARCHAR2
445 , p0_a17 VARCHAR2
446 , p0_a18 VARCHAR2
447 , p0_a19 VARCHAR2
448 , p0_a20 VARCHAR2
449 , p0_a21 VARCHAR2
450 , p0_a22 VARCHAR2
451 , p0_a23 NUMBER
452 , p0_a24 VARCHAR2
453 , p0_a25 VARCHAR2
454 , p0_a26 VARCHAR2
455 , p0_a27 VARCHAR2
456 , p0_a28 VARCHAR2
457 , p0_a29 NUMBER
458 , p0_a30 NUMBER
459 , p0_a31 NUMBER
460 , p0_a32 DATE
461 , p0_a33 DATE
462 , p0_a34 NUMBER
463 , p0_a35 VARCHAR2
464 , p0_a36 VARCHAR2
465 , p0_a37 VARCHAR2
466 , p0_a38 NUMBER
467 , p0_a39 NUMBER
468 , p0_a40 NUMBER
469 , p0_a41 NUMBER
470 , p0_a42 NUMBER
471 , p0_a43 DATE
472 , p0_a44 NUMBER
473 , p0_a45 NUMBER
474 , p0_a46 NUMBER
475 , p0_a47 NUMBER
476 , p1_a0 JTF_NUMBER_TABLE
477 , p1_a1 JTF_NUMBER_TABLE
478 , p1_a2 JTF_NUMBER_TABLE
479 , p1_a3 JTF_NUMBER_TABLE
480 , p1_a4 JTF_NUMBER_TABLE
481 , p1_a5 JTF_NUMBER_TABLE
482 , p1_a6 JTF_NUMBER_TABLE
483 , p1_a7 JTF_NUMBER_TABLE
484 , p1_a8 JTF_NUMBER_TABLE
485 , p1_a9 JTF_DATE_TABLE
486 , p1_a10 JTF_DATE_TABLE
487 , p1_a11 JTF_DATE_TABLE
488 , p1_a12 JTF_VARCHAR2_TABLE_100
489 , p2_a0 JTF_NUMBER_TABLE
490 , p2_a1 JTF_NUMBER_TABLE
491 , p2_a2 JTF_NUMBER_TABLE
492 , p2_a3 JTF_NUMBER_TABLE
493 , p2_a4 JTF_NUMBER_TABLE
494 , p2_a5 JTF_NUMBER_TABLE
495 , p2_a6 JTF_NUMBER_TABLE
496 , p2_a7 JTF_NUMBER_TABLE
497 , p2_a8 JTF_NUMBER_TABLE
498 , p2_a9 JTF_DATE_TABLE
499 , p2_a10 JTF_DATE_TABLE
500 , p2_a11 JTF_DATE_TABLE
501 , p2_a12 JTF_VARCHAR2_TABLE_100
502 , p3_a0 JTF_NUMBER_TABLE
503 , p3_a1 JTF_NUMBER_TABLE
504 , p3_a2 JTF_NUMBER_TABLE
505 , p3_a3 JTF_NUMBER_TABLE
506 , p3_a4 JTF_NUMBER_TABLE
507 , p3_a5 JTF_NUMBER_TABLE
508 , p3_a6 JTF_NUMBER_TABLE
509 , p3_a7 JTF_NUMBER_TABLE
510 , p3_a8 JTF_NUMBER_TABLE
511 , p3_a9 JTF_DATE_TABLE
512 , p3_a10 JTF_DATE_TABLE
513 , p3_a11 JTF_DATE_TABLE
514 , p3_a12 JTF_VARCHAR2_TABLE_100
515 , x_reason_failed out nocopy VARCHAR2
516 , ddrosetta_retval_bool OUT NOCOPY NUMBER
517 );
518 procedure validate_pm_activity(p0_a0 NUMBER
519 , p0_a1 NUMBER
520 , p0_a2 NUMBER
521 , p0_a3 VARCHAR2
522 , p0_a4 NUMBER
523 , p0_a5 DATE
524 , p0_a6 DATE
525 , p1_a0 JTF_NUMBER_TABLE
526 , p1_a1 JTF_NUMBER_TABLE
527 , p1_a2 JTF_NUMBER_TABLE
528 , p1_a3 JTF_NUMBER_TABLE
529 , p1_a4 JTF_NUMBER_TABLE
530 , p1_a5 JTF_NUMBER_TABLE
531 , p1_a6 JTF_NUMBER_TABLE
535 , p1_a10 JTF_DATE_TABLE
532 , p1_a7 JTF_NUMBER_TABLE
533 , p1_a8 JTF_NUMBER_TABLE
534 , p1_a9 JTF_DATE_TABLE
536 , p1_a11 JTF_DATE_TABLE
537 , p1_a12 JTF_VARCHAR2_TABLE_100
538 , p2_a0 NUMBER
539 , p2_a1 NUMBER
540 , p2_a2 VARCHAR2
541 , p2_a3 DATE
542 , p2_a4 DATE
543 , p2_a5 NUMBER
544 , p2_a6 NUMBER
545 , p2_a7 VARCHAR2
546 , p2_a8 VARCHAR2
547 , p2_a9 VARCHAR2
548 , p2_a10 VARCHAR2
549 , p2_a11 VARCHAR2
550 , p2_a12 VARCHAR2
551 , p2_a13 VARCHAR2
552 , p2_a14 VARCHAR2
553 , p2_a15 VARCHAR2
554 , p2_a16 VARCHAR2
555 , p2_a17 VARCHAR2
556 , p2_a18 VARCHAR2
557 , p2_a19 VARCHAR2
558 , p2_a20 VARCHAR2
559 , p2_a21 VARCHAR2
563 , p2_a25 VARCHAR2
560 , p2_a22 VARCHAR2
561 , p2_a23 NUMBER
562 , p2_a24 VARCHAR2
564 , p2_a26 VARCHAR2
565 , p2_a27 VARCHAR2
566 , p2_a28 VARCHAR2
567 , p2_a29 NUMBER
568 , p2_a30 NUMBER
569 , p2_a31 NUMBER
570 , p2_a32 DATE
571 , p2_a33 DATE
572 , p2_a34 NUMBER
573 , p2_a35 VARCHAR2
574 , p2_a36 VARCHAR2
575 , p2_a37 VARCHAR2
576 , p2_a38 NUMBER
577 , p2_a39 NUMBER
578 , p2_a40 NUMBER
579 , p2_a41 NUMBER
580 , p2_a42 NUMBER
581 , p2_a43 DATE
582 , p2_a44 NUMBER
583 , p2_a45 NUMBER
584 , p2_a46 NUMBER
585 , p2_a47 NUMBER
586 , x_reason_failed out nocopy VARCHAR2
587 , x_message out nocopy VARCHAR2
588 , ddrosetta_retval_bool OUT NOCOPY NUMBER
589 );
590 procedure validate_pm_activity(p0_a0 NUMBER
591 , p0_a1 NUMBER
592 , p0_a2 NUMBER
593 , p0_a3 VARCHAR2
594 , p0_a4 NUMBER
595 , p0_a5 DATE
596 , p0_a6 DATE
597 , p1_a0 NUMBER
598 , p1_a1 NUMBER
599 , p1_a2 VARCHAR2
600 , p1_a3 DATE
601 , p1_a4 DATE
602 , p1_a5 NUMBER
603 , p1_a6 NUMBER
604 , p1_a7 VARCHAR2
605 , p1_a8 VARCHAR2
606 , p1_a9 VARCHAR2
607 , p1_a10 VARCHAR2
608 , p1_a11 VARCHAR2
609 , p1_a12 VARCHAR2
610 , p1_a13 VARCHAR2
611 , p1_a14 VARCHAR2
612 , p1_a15 VARCHAR2
613 , p1_a16 VARCHAR2
614 , p1_a17 VARCHAR2
615 , p1_a18 VARCHAR2
616 , p1_a19 VARCHAR2
617 , p1_a20 VARCHAR2
618 , p1_a21 VARCHAR2
619 , p1_a22 VARCHAR2
620 , p1_a23 NUMBER
621 , p1_a24 VARCHAR2
622 , p1_a25 VARCHAR2
623 , p1_a26 VARCHAR2
624 , p1_a27 VARCHAR2
625 , p1_a28 VARCHAR2
626 , p1_a29 NUMBER
627 , p1_a30 NUMBER
628 , p1_a31 NUMBER
629 , p1_a32 DATE
630 , p1_a33 DATE
631 , p1_a34 NUMBER
632 , p1_a35 VARCHAR2
633 , p1_a36 VARCHAR2
634 , p1_a37 VARCHAR2
635 , p1_a38 NUMBER
636 , p1_a39 NUMBER
637 , p1_a40 NUMBER
638 , p1_a41 NUMBER
639 , p1_a42 NUMBER
640 , p1_a43 DATE
641 , p1_a44 NUMBER
642 , p1_a45 NUMBER
643 , p1_a46 NUMBER
644 , p1_a47 NUMBER
645 , x_reason_failed out nocopy VARCHAR2
646 , ddrosetta_retval_bool OUT NOCOPY NUMBER
647 );
648 procedure validate_pm_activities(p0_a0 JTF_NUMBER_TABLE
649 , p0_a1 JTF_NUMBER_TABLE
650 , p0_a2 JTF_NUMBER_TABLE
651 , p0_a3 JTF_VARCHAR2_TABLE_100
652 , p0_a4 JTF_NUMBER_TABLE
653 , p0_a5 JTF_DATE_TABLE
654 , p0_a6 JTF_DATE_TABLE
655 , p1_a0 JTF_NUMBER_TABLE
656 , p1_a1 JTF_NUMBER_TABLE
657 , p1_a2 JTF_NUMBER_TABLE
658 , p1_a3 JTF_NUMBER_TABLE
659 , p1_a4 JTF_NUMBER_TABLE
660 , p1_a5 JTF_NUMBER_TABLE
661 , p1_a6 JTF_NUMBER_TABLE
662 , p1_a7 JTF_NUMBER_TABLE
663 , p1_a8 JTF_NUMBER_TABLE
664 , p1_a9 JTF_DATE_TABLE
665 , p1_a10 JTF_DATE_TABLE
666 , p1_a11 JTF_DATE_TABLE
667 , p1_a12 JTF_VARCHAR2_TABLE_100
668 , p2_a0 NUMBER
669 , p2_a1 NUMBER
670 , p2_a2 VARCHAR2
671 , p2_a3 DATE
672 , p2_a4 DATE
673 , p2_a5 NUMBER
674 , p2_a6 NUMBER
675 , p2_a7 VARCHAR2
676 , p2_a8 VARCHAR2
677 , p2_a9 VARCHAR2
678 , p2_a10 VARCHAR2
679 , p2_a11 VARCHAR2
680 , p2_a12 VARCHAR2
681 , p2_a13 VARCHAR2
682 , p2_a14 VARCHAR2
683 , p2_a15 VARCHAR2
684 , p2_a16 VARCHAR2
685 , p2_a17 VARCHAR2
686 , p2_a18 VARCHAR2
687 , p2_a19 VARCHAR2
688 , p2_a20 VARCHAR2
689 , p2_a21 VARCHAR2
690 , p2_a22 VARCHAR2
691 , p2_a23 NUMBER
692 , p2_a24 VARCHAR2
693 , p2_a25 VARCHAR2
694 , p2_a26 VARCHAR2
695 , p2_a27 VARCHAR2
696 , p2_a28 VARCHAR2
697 , p2_a29 NUMBER
698 , p2_a30 NUMBER
699 , p2_a31 NUMBER
700 , p2_a32 DATE
701 , p2_a33 DATE
702 , p2_a34 NUMBER
703 , p2_a35 VARCHAR2
704 , p2_a36 VARCHAR2
705 , p2_a37 VARCHAR2
706 , p2_a38 NUMBER
707 , p2_a39 NUMBER
708 , p2_a40 NUMBER
709 , p2_a41 NUMBER
710 , p2_a42 NUMBER
711 , p2_a43 DATE
712 , p2_a44 NUMBER
713 , p2_a45 NUMBER
714 , p2_a46 NUMBER
715 , p2_a47 NUMBER
716 , x_reason_failed out nocopy VARCHAR2
717 , x_message out nocopy VARCHAR2
718 , ddrosetta_retval_bool OUT NOCOPY NUMBER
719 );
720 procedure sort_table_by_date(p0_a0 JTF_NUMBER_TABLE
721 , p0_a1 JTF_DATE_TABLE
722 , p0_a2 JTF_NUMBER_TABLE
723 , p_num_rows NUMBER
724 , p2_a0 out nocopy JTF_NUMBER_TABLE
725 , p2_a1 out nocopy JTF_DATE_TABLE
726 , p2_a2 out nocopy JTF_NUMBER_TABLE
727 );
728 procedure sort_table_by_number(p0_a0 JTF_NUMBER_TABLE
729 , p0_a1 JTF_NUMBER_TABLE
730 , p0_a2 JTF_NUMBER_TABLE
731 , p_num_rows NUMBER
732 , p2_a0 out nocopy JTF_NUMBER_TABLE
733 , p2_a1 out nocopy JTF_NUMBER_TABLE
734 , p2_a2 out nocopy JTF_NUMBER_TABLE
735 );
736 procedure merge_rules(p0_a0 JTF_NUMBER_TABLE
737 , p0_a1 JTF_NUMBER_TABLE
738 , p0_a2 JTF_NUMBER_TABLE
739 , p0_a3 JTF_NUMBER_TABLE
740 , p0_a4 JTF_NUMBER_TABLE
741 , p0_a5 JTF_NUMBER_TABLE
742 , p0_a6 JTF_NUMBER_TABLE
746 , p0_a10 JTF_DATE_TABLE
743 , p0_a7 JTF_NUMBER_TABLE
744 , p0_a8 JTF_NUMBER_TABLE
745 , p0_a9 JTF_DATE_TABLE
747 , p0_a11 JTF_DATE_TABLE
748 , p0_a12 JTF_VARCHAR2_TABLE_100
749 , p1_a0 JTF_NUMBER_TABLE
750 , p1_a1 JTF_NUMBER_TABLE
751 , p1_a2 JTF_NUMBER_TABLE
752 , p1_a3 JTF_NUMBER_TABLE
753 , p1_a4 JTF_NUMBER_TABLE
754 , p1_a5 JTF_NUMBER_TABLE
755 , p1_a6 JTF_NUMBER_TABLE
756 , p1_a7 JTF_NUMBER_TABLE
757 , p1_a8 JTF_NUMBER_TABLE
758 , p1_a9 JTF_DATE_TABLE
759 , p1_a10 JTF_DATE_TABLE
760 , p1_a11 JTF_DATE_TABLE
761 , p1_a12 JTF_VARCHAR2_TABLE_100
762 , p2_a0 out nocopy JTF_NUMBER_TABLE
763 , p2_a1 out nocopy JTF_NUMBER_TABLE
764 , p2_a2 out nocopy JTF_NUMBER_TABLE
765 , p2_a3 out nocopy JTF_NUMBER_TABLE
766 , p2_a4 out nocopy JTF_NUMBER_TABLE
767 , p2_a5 out nocopy JTF_NUMBER_TABLE
768 , p2_a6 out nocopy JTF_NUMBER_TABLE
769 , p2_a7 out nocopy JTF_NUMBER_TABLE
770 , p2_a8 out nocopy JTF_NUMBER_TABLE
771 , p2_a9 out nocopy JTF_DATE_TABLE
772 , p2_a10 out nocopy JTF_DATE_TABLE
773 , p2_a11 out nocopy JTF_DATE_TABLE
774 , p2_a12 out nocopy JTF_VARCHAR2_TABLE_100
775 );
776 end eam_pmdef_pub_w;