[Home] [Help]
PACKAGE: APPS.CSD_RULES_ENGINE_PVT_W
Source
1 package csd_rules_engine_pvt_w AUTHID CURRENT_USER as
2 /* $Header: csdwruls.pls 120.1.12020000.5 2013/05/07 23:53:53 vicli ship $ */
3 procedure rosetta_table_copy_in_p40(t out nocopy csd_rules_engine_pvt.csd_rule_condition_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_VARCHAR2_TABLE_100
6 , a3 JTF_VARCHAR2_TABLE_200
7 , a4 JTF_VARCHAR2_TABLE_200
8 , a5 JTF_VARCHAR2_TABLE_200
9 , a6 JTF_VARCHAR2_TABLE_200
10 , a7 JTF_VARCHAR2_TABLE_200
11 , a8 JTF_VARCHAR2_TABLE_200
12 , a9 JTF_VARCHAR2_TABLE_200
13 , a10 JTF_VARCHAR2_TABLE_200
14 , a11 JTF_VARCHAR2_TABLE_200
15 , a12 JTF_VARCHAR2_TABLE_200
16 , a13 JTF_VARCHAR2_TABLE_200
17 , a14 JTF_VARCHAR2_TABLE_200
18 , a15 JTF_VARCHAR2_TABLE_200
19 , a16 JTF_VARCHAR2_TABLE_200
20 , a17 JTF_VARCHAR2_TABLE_200
21 );
22 procedure rosetta_table_copy_out_p40(t csd_rules_engine_pvt.csd_rule_condition_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
23 , a1 out nocopy JTF_NUMBER_TABLE
24 , a2 out nocopy JTF_VARCHAR2_TABLE_100
25 , a3 out nocopy JTF_VARCHAR2_TABLE_200
26 , a4 out nocopy JTF_VARCHAR2_TABLE_200
27 , a5 out nocopy JTF_VARCHAR2_TABLE_200
28 , a6 out nocopy JTF_VARCHAR2_TABLE_200
29 , a7 out nocopy JTF_VARCHAR2_TABLE_200
30 , a8 out nocopy JTF_VARCHAR2_TABLE_200
31 , a9 out nocopy JTF_VARCHAR2_TABLE_200
32 , a10 out nocopy JTF_VARCHAR2_TABLE_200
33 , a11 out nocopy JTF_VARCHAR2_TABLE_200
34 , a12 out nocopy JTF_VARCHAR2_TABLE_200
35 , a13 out nocopy JTF_VARCHAR2_TABLE_200
36 , a14 out nocopy JTF_VARCHAR2_TABLE_200
37 , a15 out nocopy JTF_VARCHAR2_TABLE_200
38 , a16 out nocopy JTF_VARCHAR2_TABLE_200
39 , a17 out nocopy JTF_VARCHAR2_TABLE_200
40 );
41
42 procedure rosetta_table_copy_in_p43(t out nocopy csd_rules_engine_pvt.csd_rule_results_tbl_type, a0 JTF_NUMBER_TABLE
43 , a1 JTF_VARCHAR2_TABLE_200
44 , a2 JTF_VARCHAR2_TABLE_100
45 , a3 JTF_NUMBER_TABLE
46 , a4 JTF_VARCHAR2_TABLE_100
47 , a5 JTF_VARCHAR2_TABLE_200
48 );
49 procedure rosetta_table_copy_out_p43(t csd_rules_engine_pvt.csd_rule_results_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
50 , a1 out nocopy JTF_VARCHAR2_TABLE_200
51 , a2 out nocopy JTF_VARCHAR2_TABLE_100
52 , a3 out nocopy JTF_NUMBER_TABLE
53 , a4 out nocopy JTF_VARCHAR2_TABLE_100
54 , a5 out nocopy JTF_VARCHAR2_TABLE_200
55 );
56
57 procedure soo_defaulting(p_api_version_number NUMBER
58 , p_init_msg_list VARCHAR2
59 , p_commit VARCHAR2
60 , p_validation_level NUMBER
61 , p_event_type VARCHAR2
62 , p5_a0 NUMBER
63 , p5_a1 NUMBER
64 , p5_a2 NUMBER
65 , p5_a3 NUMBER
66 , p5_a4 NUMBER
67 , p5_a5 NUMBER
68 , p5_a6 NUMBER
69 , p5_a7 NUMBER
70 , p5_a8 VARCHAR2
71 , p5_a9 NUMBER
72 , p5_a10 NUMBER
73 , p5_a11 NUMBER
74 , p5_a12 NUMBER
75 , p5_a13 NUMBER
76 , p5_a14 NUMBER
77 , p5_a15 NUMBER
78 , p5_a16 NUMBER
79 , p5_a17 NUMBER
80 , p5_a18 VARCHAR2
81 , p5_a19 VARCHAR2
82 , p5_a20 VARCHAR2
83 , p5_a21 VARCHAR2
84 , p5_a22 VARCHAR2
85 , p5_a23 VARCHAR2
86 , p5_a24 VARCHAR2
87 , p5_a25 VARCHAR2
88 , p5_a26 NUMBER
89 , p5_a27 NUMBER
90 , p5_a28 NUMBER
91 , p5_a29 VARCHAR2
92 , p5_a30 VARCHAR2
93 , p5_a31 VARCHAR2
94 , p5_a32 VARCHAR2
95 , p5_a33 VARCHAR2
96 , p5_a34 VARCHAR2
97 , p5_a35 VARCHAR2
98 , p5_a36 VARCHAR2
99 , p5_a37 NUMBER
100 , p5_a38 NUMBER
101 , p5_a39 NUMBER
102 , p5_a40 NUMBER
103 , p5_a41 VARCHAR2
104 , p5_a42 VARCHAR2
105 , p5_a43 NUMBER
106 , p5_a44 NUMBER
107 , p5_a45 NUMBER
108 , x_rule_id out nocopy NUMBER
109 , x_return_status out nocopy VARCHAR2
110 , x_msg_count out nocopy NUMBER
111 , x_msg_data out nocopy VARCHAR2
112 );
113 procedure process_soo_rule(p_api_version_number NUMBER
114 , p_init_msg_list VARCHAR2
115 , p_commit VARCHAR2
116 , p_validation_level NUMBER
117 , p_ro_flow_status_id NUMBER
118 , p_flow_status_reason_code VARCHAR2
119 , p_action VARCHAR2
120 , p7_a0 NUMBER
121 , p7_a1 NUMBER
122 , p7_a2 NUMBER
123 , p7_a3 NUMBER
124 , p7_a4 NUMBER
125 , p7_a5 NUMBER
126 , p7_a6 NUMBER
127 , p7_a7 NUMBER
128 , p7_a8 VARCHAR2
129 , p7_a9 NUMBER
130 , p7_a10 NUMBER
131 , p7_a11 NUMBER
132 , p7_a12 NUMBER
133 , p7_a13 NUMBER
134 , p7_a14 NUMBER
135 , p7_a15 NUMBER
136 , p7_a16 NUMBER
137 , p7_a17 NUMBER
138 , p7_a18 VARCHAR2
139 , p7_a19 VARCHAR2
140 , p7_a20 VARCHAR2
141 , p7_a21 VARCHAR2
142 , p7_a22 VARCHAR2
143 , p7_a23 VARCHAR2
144 , p7_a24 VARCHAR2
145 , p7_a25 VARCHAR2
146 , p7_a26 NUMBER
147 , p7_a27 NUMBER
148 , p7_a28 NUMBER
149 , p7_a29 VARCHAR2
150 , p7_a30 VARCHAR2
151 , p7_a31 VARCHAR2
152 , p7_a32 VARCHAR2
153 , p7_a33 VARCHAR2
154 , p7_a34 VARCHAR2
155 , p7_a35 VARCHAR2
156 , p7_a36 VARCHAR2
157 , p7_a37 NUMBER
158 , p7_a38 NUMBER
159 , p7_a39 NUMBER
160 , p7_a40 NUMBER
161 , p7_a41 VARCHAR2
162 , p7_a42 VARCHAR2
163 , p7_a43 NUMBER
164 , p7_a44 NUMBER
165 , p7_a45 NUMBER
166 , x_return_status out nocopy VARCHAR2
167 , x_msg_count out nocopy NUMBER
168 , x_msg_data out nocopy VARCHAR2
169 );
170 procedure get_default_value_from_rule(p_api_version_number NUMBER
171 , p_init_msg_list VARCHAR2
172 , p_commit VARCHAR2
173 , p_validation_level NUMBER
174 , p_entity_attribute_type VARCHAR2
175 , p_entity_attribute_code VARCHAR2
176 , p6_a0 NUMBER
177 , p6_a1 NUMBER
178 , p6_a2 NUMBER
179 , p6_a3 NUMBER
180 , p6_a4 NUMBER
181 , p6_a5 NUMBER
182 , p6_a6 NUMBER
183 , p6_a7 NUMBER
184 , p6_a8 VARCHAR2
185 , p6_a9 NUMBER
186 , p6_a10 NUMBER
187 , p6_a11 NUMBER
188 , p6_a12 NUMBER
189 , p6_a13 NUMBER
190 , p6_a14 NUMBER
191 , p6_a15 NUMBER
192 , p6_a16 NUMBER
193 , p6_a17 NUMBER
194 , p6_a18 VARCHAR2
195 , p6_a19 VARCHAR2
196 , p6_a20 VARCHAR2
197 , p6_a21 VARCHAR2
198 , p6_a22 VARCHAR2
199 , p6_a23 VARCHAR2
200 , p6_a24 VARCHAR2
201 , p6_a25 VARCHAR2
202 , p6_a26 NUMBER
203 , p6_a27 NUMBER
204 , p6_a28 NUMBER
205 , p6_a29 VARCHAR2
206 , p6_a30 VARCHAR2
207 , p6_a31 VARCHAR2
208 , p6_a32 VARCHAR2
209 , p6_a33 VARCHAR2
210 , p6_a34 VARCHAR2
211 , p6_a35 VARCHAR2
212 , p6_a36 VARCHAR2
213 , p6_a37 NUMBER
214 , p6_a38 NUMBER
215 , p6_a39 NUMBER
216 , p6_a40 NUMBER
217 , p6_a41 VARCHAR2
218 , p6_a42 VARCHAR2
219 , p6_a43 NUMBER
220 , p6_a44 NUMBER
221 , p6_a45 NUMBER
222 , x_default_value out nocopy VARCHAR2
223 , x_rule_id out nocopy NUMBER
224 , x_return_status out nocopy VARCHAR2
225 , x_msg_count out nocopy NUMBER
226 , x_msg_data out nocopy VARCHAR2
227 );
228 procedure get_default_value_from_rule(p_api_version_number NUMBER
229 , p_init_msg_list VARCHAR2
230 , p_commit VARCHAR2
231 , p_validation_level NUMBER
232 , p_entity_attribute_type VARCHAR2
233 , p_entity_attribute_code VARCHAR2
234 , p6_a0 NUMBER
235 , p6_a1 NUMBER
236 , p6_a2 NUMBER
237 , p6_a3 NUMBER
238 , p6_a4 NUMBER
239 , p6_a5 NUMBER
240 , p6_a6 NUMBER
241 , p6_a7 NUMBER
242 , p6_a8 VARCHAR2
243 , p6_a9 NUMBER
244 , p6_a10 NUMBER
245 , p6_a11 NUMBER
246 , p6_a12 NUMBER
247 , p6_a13 NUMBER
248 , p6_a14 NUMBER
249 , p6_a15 NUMBER
250 , p6_a16 NUMBER
251 , p6_a17 NUMBER
252 , p6_a18 VARCHAR2
253 , p6_a19 VARCHAR2
254 , p6_a20 VARCHAR2
255 , p6_a21 VARCHAR2
256 , p6_a22 VARCHAR2
257 , p6_a23 VARCHAR2
258 , p6_a24 VARCHAR2
259 , p6_a25 VARCHAR2
260 , p6_a26 NUMBER
261 , p6_a27 NUMBER
262 , p6_a28 NUMBER
263 , p6_a29 VARCHAR2
264 , p6_a30 VARCHAR2
265 , p6_a31 VARCHAR2
266 , p6_a32 VARCHAR2
267 , p6_a33 VARCHAR2
268 , p6_a34 VARCHAR2
269 , p6_a35 VARCHAR2
270 , p6_a36 VARCHAR2
271 , p6_a37 NUMBER
272 , p6_a38 NUMBER
273 , p6_a39 NUMBER
274 , p6_a40 NUMBER
275 , p6_a41 VARCHAR2
276 , p6_a42 VARCHAR2
277 , p6_a43 NUMBER
278 , p6_a44 NUMBER
279 , p6_a45 NUMBER
280 , x_default_value out nocopy NUMBER
281 , x_rule_id out nocopy NUMBER
282 , x_return_status out nocopy VARCHAR2
283 , x_msg_count out nocopy NUMBER
284 , x_msg_data out nocopy VARCHAR2
285 );
286 procedure get_default_value_from_rule(p_api_version_number NUMBER
287 , p_init_msg_list VARCHAR2
288 , p_commit VARCHAR2
289 , p_validation_level NUMBER
290 , p_entity_attribute_type VARCHAR2
291 , p_entity_attribute_code VARCHAR2
292 , p6_a0 NUMBER
293 , p6_a1 NUMBER
294 , p6_a2 NUMBER
295 , p6_a3 NUMBER
296 , p6_a4 NUMBER
297 , p6_a5 NUMBER
298 , p6_a6 NUMBER
299 , p6_a7 NUMBER
300 , p6_a8 VARCHAR2
301 , p6_a9 NUMBER
302 , p6_a10 NUMBER
303 , p6_a11 NUMBER
304 , p6_a12 NUMBER
305 , p6_a13 NUMBER
306 , p6_a14 NUMBER
307 , p6_a15 NUMBER
308 , p6_a16 NUMBER
309 , p6_a17 NUMBER
310 , p6_a18 VARCHAR2
311 , p6_a19 VARCHAR2
312 , p6_a20 VARCHAR2
313 , p6_a21 VARCHAR2
314 , p6_a22 VARCHAR2
315 , p6_a23 VARCHAR2
316 , p6_a24 VARCHAR2
317 , p6_a25 VARCHAR2
318 , p6_a26 NUMBER
319 , p6_a27 NUMBER
320 , p6_a28 NUMBER
321 , p6_a29 VARCHAR2
322 , p6_a30 VARCHAR2
323 , p6_a31 VARCHAR2
324 , p6_a32 VARCHAR2
325 , p6_a33 VARCHAR2
326 , p6_a34 VARCHAR2
327 , p6_a35 VARCHAR2
328 , p6_a36 VARCHAR2
329 , p6_a37 NUMBER
330 , p6_a38 NUMBER
331 , p6_a39 NUMBER
332 , p6_a40 NUMBER
333 , p6_a41 VARCHAR2
334 , p6_a42 VARCHAR2
335 , p6_a43 NUMBER
336 , p6_a44 NUMBER
337 , p6_a45 NUMBER
338 , x_default_value out nocopy DATE
339 , x_rule_id out nocopy NUMBER
340 , x_return_status out nocopy VARCHAR2
341 , x_msg_count out nocopy NUMBER
342 , x_msg_data out nocopy VARCHAR2
343 );
344 function match_condition(p_parameter_type VARCHAR2
345 , p_operator VARCHAR2
346 , p_criterion VARCHAR2
347 , p3_a0 NUMBER
348 , p3_a1 NUMBER
349 , p3_a2 NUMBER
350 , p3_a3 NUMBER
351 , p3_a4 NUMBER
352 , p3_a5 NUMBER
353 , p3_a6 NUMBER
354 , p3_a7 NUMBER
355 , p3_a8 VARCHAR2
356 , p3_a9 NUMBER
357 , p3_a10 NUMBER
358 , p3_a11 NUMBER
359 , p3_a12 NUMBER
360 , p3_a13 NUMBER
361 , p3_a14 NUMBER
362 , p3_a15 NUMBER
363 , p3_a16 NUMBER
364 , p3_a17 NUMBER
365 , p3_a18 VARCHAR2
366 , p3_a19 VARCHAR2
367 , p3_a20 VARCHAR2
368 , p3_a21 VARCHAR2
369 , p3_a22 VARCHAR2
370 , p3_a23 VARCHAR2
371 , p3_a24 VARCHAR2
372 , p3_a25 VARCHAR2
373 , p3_a26 NUMBER
374 , p3_a27 NUMBER
375 , p3_a28 NUMBER
376 , p3_a29 VARCHAR2
377 , p3_a30 VARCHAR2
378 , p3_a31 VARCHAR2
379 , p3_a32 VARCHAR2
380 , p3_a33 VARCHAR2
381 , p3_a34 VARCHAR2
382 , p3_a35 VARCHAR2
383 , p3_a36 VARCHAR2
384 , p3_a37 NUMBER
385 , p3_a38 NUMBER
386 , p3_a39 NUMBER
387 , p3_a40 NUMBER
388 , p3_a41 VARCHAR2
389 , p3_a42 VARCHAR2
390 , p3_a43 NUMBER
391 , p3_a44 NUMBER
392 , p3_a45 NUMBER
393 ) return varchar2;
394 procedure copy_rule_input_rec_values(p0_a0 NUMBER
395 , p0_a1 NUMBER
396 , p0_a2 NUMBER
397 , p0_a3 NUMBER
398 , p0_a4 NUMBER
399 , p0_a5 NUMBER
400 , p0_a6 NUMBER
401 , p0_a7 NUMBER
402 , p0_a8 VARCHAR2
403 , p0_a9 NUMBER
404 , p0_a10 NUMBER
405 , p0_a11 NUMBER
406 , p0_a12 NUMBER
407 , p0_a13 NUMBER
408 , p0_a14 NUMBER
409 , p0_a15 NUMBER
410 , p0_a16 NUMBER
411 , p0_a17 NUMBER
412 , p0_a18 VARCHAR2
413 , p0_a19 VARCHAR2
414 , p0_a20 VARCHAR2
415 , p0_a21 VARCHAR2
416 , p0_a22 VARCHAR2
417 , p0_a23 VARCHAR2
418 , p0_a24 VARCHAR2
419 , p0_a25 VARCHAR2
420 , p0_a26 NUMBER
421 , p0_a27 NUMBER
422 , p0_a28 NUMBER
423 , p0_a29 VARCHAR2
424 , p0_a30 VARCHAR2
425 , p0_a31 VARCHAR2
426 , p0_a32 VARCHAR2
427 , p0_a33 VARCHAR2
428 , p0_a34 VARCHAR2
429 , p0_a35 VARCHAR2
430 , p0_a36 VARCHAR2
431 , p0_a37 NUMBER
432 , p0_a38 NUMBER
433 , p0_a39 NUMBER
434 , p0_a40 NUMBER
435 , p0_a41 VARCHAR2
436 , p0_a42 VARCHAR2
437 , p0_a43 NUMBER
438 , p0_a44 NUMBER
439 , p0_a45 NUMBER
440 , p1_a0 in out nocopy NUMBER
441 , p1_a1 in out nocopy NUMBER
442 , p1_a2 in out nocopy NUMBER
443 , p1_a3 in out nocopy NUMBER
444 , p1_a4 in out nocopy NUMBER
445 , p1_a5 in out nocopy NUMBER
446 , p1_a6 in out nocopy NUMBER
447 , p1_a7 in out nocopy NUMBER
448 , p1_a8 in out nocopy VARCHAR2
449 , p1_a9 in out nocopy NUMBER
450 , p1_a10 in out nocopy NUMBER
451 , p1_a11 in out nocopy NUMBER
452 , p1_a12 in out nocopy NUMBER
453 , p1_a13 in out nocopy NUMBER
454 , p1_a14 in out nocopy NUMBER
455 , p1_a15 in out nocopy NUMBER
456 , p1_a16 in out nocopy NUMBER
457 , p1_a17 in out nocopy NUMBER
458 , p1_a18 in out nocopy VARCHAR2
459 , p1_a19 in out nocopy VARCHAR2
460 , p1_a20 in out nocopy VARCHAR2
461 , p1_a21 in out nocopy VARCHAR2
462 , p1_a22 in out nocopy VARCHAR2
463 , p1_a23 in out nocopy VARCHAR2
464 , p1_a24 in out nocopy VARCHAR2
465 , p1_a25 in out nocopy VARCHAR2
466 , p1_a26 in out nocopy NUMBER
467 , p1_a27 in out nocopy NUMBER
468 , p1_a28 in out nocopy NUMBER
469 , p1_a29 in out nocopy VARCHAR2
470 , p1_a30 in out nocopy VARCHAR2
471 , p1_a31 in out nocopy VARCHAR2
472 , p1_a32 in out nocopy VARCHAR2
473 , p1_a33 in out nocopy VARCHAR2
474 , p1_a34 in out nocopy VARCHAR2
475 , p1_a35 in out nocopy VARCHAR2
476 , p1_a36 in out nocopy VARCHAR2
477 , p1_a37 in out nocopy NUMBER
478 , p1_a38 in out nocopy NUMBER
479 , p1_a39 in out nocopy NUMBER
480 , p1_a40 in out nocopy NUMBER
481 , p1_a41 in out nocopy VARCHAR2
482 , p1_a42 in out nocopy VARCHAR2
483 , p1_a43 in out nocopy NUMBER
484 , p1_a44 in out nocopy NUMBER
485 , p1_a45 in out nocopy NUMBER
486 );
487 procedure populate_rule_input_rec(p0_a0 in out nocopy NUMBER
488 , p0_a1 in out nocopy NUMBER
489 , p0_a2 in out nocopy NUMBER
490 , p0_a3 in out nocopy NUMBER
491 , p0_a4 in out nocopy NUMBER
492 , p0_a5 in out nocopy NUMBER
493 , p0_a6 in out nocopy NUMBER
494 , p0_a7 in out nocopy NUMBER
495 , p0_a8 in out nocopy VARCHAR2
496 , p0_a9 in out nocopy NUMBER
497 , p0_a10 in out nocopy NUMBER
498 , p0_a11 in out nocopy NUMBER
499 , p0_a12 in out nocopy NUMBER
500 , p0_a13 in out nocopy NUMBER
501 , p0_a14 in out nocopy NUMBER
502 , p0_a15 in out nocopy NUMBER
503 , p0_a16 in out nocopy NUMBER
504 , p0_a17 in out nocopy NUMBER
505 , p0_a18 in out nocopy VARCHAR2
506 , p0_a19 in out nocopy VARCHAR2
507 , p0_a20 in out nocopy VARCHAR2
508 , p0_a21 in out nocopy VARCHAR2
509 , p0_a22 in out nocopy VARCHAR2
510 , p0_a23 in out nocopy VARCHAR2
511 , p0_a24 in out nocopy VARCHAR2
512 , p0_a25 in out nocopy VARCHAR2
513 , p0_a26 in out nocopy NUMBER
514 , p0_a27 in out nocopy NUMBER
515 , p0_a28 in out nocopy NUMBER
516 , p0_a29 in out nocopy VARCHAR2
517 , p0_a30 in out nocopy VARCHAR2
518 , p0_a31 in out nocopy VARCHAR2
519 , p0_a32 in out nocopy VARCHAR2
520 , p0_a33 in out nocopy VARCHAR2
521 , p0_a34 in out nocopy VARCHAR2
522 , p0_a35 in out nocopy VARCHAR2
523 , p0_a36 in out nocopy VARCHAR2
524 , p0_a37 in out nocopy NUMBER
525 , p0_a38 in out nocopy NUMBER
526 , p0_a39 in out nocopy NUMBER
527 , p0_a40 in out nocopy NUMBER
528 , p0_a41 in out nocopy VARCHAR2
529 , p0_a42 in out nocopy VARCHAR2
530 , p0_a43 in out nocopy NUMBER
531 , p0_a44 in out nocopy NUMBER
532 , p0_a45 in out nocopy NUMBER
533 , p_repair_line_id NUMBER
534 );
535 function get_default_value(p_value_type VARCHAR2
536 , p_defaulting_value VARCHAR2
537 , p_attribute_type VARCHAR2
538 , p_attribute_code VARCHAR2
539 , p4_a0 NUMBER
540 , p4_a1 NUMBER
541 , p4_a2 NUMBER
542 , p4_a3 NUMBER
543 , p4_a4 NUMBER
544 , p4_a5 NUMBER
545 , p4_a6 NUMBER
546 , p4_a7 NUMBER
547 , p4_a8 VARCHAR2
548 , p4_a9 NUMBER
549 , p4_a10 NUMBER
550 , p4_a11 NUMBER
551 , p4_a12 NUMBER
552 , p4_a13 NUMBER
553 , p4_a14 NUMBER
554 , p4_a15 NUMBER
555 , p4_a16 NUMBER
556 , p4_a17 NUMBER
557 , p4_a18 VARCHAR2
558 , p4_a19 VARCHAR2
559 , p4_a20 VARCHAR2
560 , p4_a21 VARCHAR2
561 , p4_a22 VARCHAR2
562 , p4_a23 VARCHAR2
563 , p4_a24 VARCHAR2
564 , p4_a25 VARCHAR2
565 , p4_a26 NUMBER
566 , p4_a27 NUMBER
567 , p4_a28 NUMBER
568 , p4_a29 VARCHAR2
569 , p4_a30 VARCHAR2
570 , p4_a31 VARCHAR2
571 , p4_a32 VARCHAR2
572 , p4_a33 VARCHAR2
573 , p4_a34 VARCHAR2
574 , p4_a35 VARCHAR2
575 , p4_a36 VARCHAR2
576 , p4_a37 NUMBER
577 , p4_a38 NUMBER
578 , p4_a39 NUMBER
579 , p4_a40 NUMBER
580 , p4_a41 VARCHAR2
581 , p4_a42 VARCHAR2
582 , p4_a43 NUMBER
583 , p4_a44 NUMBER
584 , p4_a45 NUMBER
585 ) return varchar2;
586 end csd_rules_engine_pvt_w;