[Home] [Help]
PACKAGE: APPS.AHL_MC_RULE_PVT_W
Source
1 package ahl_mc_rule_pvt_w as
2 /* $Header: AHLWMCRS.pls 120.0.12010000.2 2008/11/26 14:11:12 sathapli ship $ */
3 procedure rosetta_table_copy_in_p3(t out nocopy ahl_mc_rule_pvt.ui_rule_stmt_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_VARCHAR2_TABLE_100
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_VARCHAR2_TABLE_100
10 , a7 JTF_VARCHAR2_TABLE_100
11 , a8 JTF_VARCHAR2_TABLE_100
12 , a9 JTF_VARCHAR2_TABLE_100
13 , a10 JTF_VARCHAR2_TABLE_100
14 , a11 JTF_NUMBER_TABLE
15 , a12 JTF_VARCHAR2_TABLE_100
16 , a13 JTF_VARCHAR2_TABLE_100
17 , a14 JTF_VARCHAR2_TABLE_100
18 , a15 JTF_VARCHAR2_TABLE_100
19 , a16 JTF_VARCHAR2_TABLE_100
20 , a17 JTF_VARCHAR2_TABLE_100
21 , a18 JTF_VARCHAR2_TABLE_100
22 , a19 JTF_VARCHAR2_TABLE_100
23 , a20 JTF_VARCHAR2_TABLE_100
24 , a21 JTF_VARCHAR2_TABLE_100
25 , a22 JTF_NUMBER_TABLE
26 , a23 JTF_NUMBER_TABLE
27 , a24 JTF_NUMBER_TABLE
28 , a25 JTF_VARCHAR2_TABLE_100
29 , a26 JTF_VARCHAR2_TABLE_200
30 , a27 JTF_VARCHAR2_TABLE_200
31 , a28 JTF_VARCHAR2_TABLE_200
32 , a29 JTF_VARCHAR2_TABLE_200
33 , a30 JTF_VARCHAR2_TABLE_200
34 , a31 JTF_VARCHAR2_TABLE_200
35 , a32 JTF_VARCHAR2_TABLE_200
36 , a33 JTF_VARCHAR2_TABLE_200
37 , a34 JTF_VARCHAR2_TABLE_200
38 , a35 JTF_VARCHAR2_TABLE_200
39 , a36 JTF_VARCHAR2_TABLE_200
40 , a37 JTF_VARCHAR2_TABLE_200
41 , a38 JTF_VARCHAR2_TABLE_200
42 , a39 JTF_VARCHAR2_TABLE_200
43 , a40 JTF_VARCHAR2_TABLE_200
44 );
45 procedure rosetta_table_copy_out_p3(t ahl_mc_rule_pvt.ui_rule_stmt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
46 , a1 out nocopy JTF_VARCHAR2_TABLE_100
47 , a2 out nocopy JTF_NUMBER_TABLE
48 , a3 out nocopy JTF_NUMBER_TABLE
49 , a4 out nocopy JTF_NUMBER_TABLE
50 , a5 out nocopy JTF_NUMBER_TABLE
51 , a6 out nocopy JTF_VARCHAR2_TABLE_100
52 , a7 out nocopy JTF_VARCHAR2_TABLE_100
53 , a8 out nocopy JTF_VARCHAR2_TABLE_100
54 , a9 out nocopy JTF_VARCHAR2_TABLE_100
55 , a10 out nocopy JTF_VARCHAR2_TABLE_100
56 , a11 out nocopy JTF_NUMBER_TABLE
57 , a12 out nocopy JTF_VARCHAR2_TABLE_100
58 , a13 out nocopy JTF_VARCHAR2_TABLE_100
59 , a14 out nocopy JTF_VARCHAR2_TABLE_100
60 , a15 out nocopy JTF_VARCHAR2_TABLE_100
61 , a16 out nocopy JTF_VARCHAR2_TABLE_100
62 , a17 out nocopy JTF_VARCHAR2_TABLE_100
63 , a18 out nocopy JTF_VARCHAR2_TABLE_100
64 , a19 out nocopy JTF_VARCHAR2_TABLE_100
65 , a20 out nocopy JTF_VARCHAR2_TABLE_100
66 , a21 out nocopy JTF_VARCHAR2_TABLE_100
67 , a22 out nocopy JTF_NUMBER_TABLE
68 , a23 out nocopy JTF_NUMBER_TABLE
69 , a24 out nocopy JTF_NUMBER_TABLE
70 , a25 out nocopy JTF_VARCHAR2_TABLE_100
71 , a26 out nocopy JTF_VARCHAR2_TABLE_200
72 , a27 out nocopy JTF_VARCHAR2_TABLE_200
73 , a28 out nocopy JTF_VARCHAR2_TABLE_200
74 , a29 out nocopy JTF_VARCHAR2_TABLE_200
75 , a30 out nocopy JTF_VARCHAR2_TABLE_200
76 , a31 out nocopy JTF_VARCHAR2_TABLE_200
77 , a32 out nocopy JTF_VARCHAR2_TABLE_200
78 , a33 out nocopy JTF_VARCHAR2_TABLE_200
79 , a34 out nocopy JTF_VARCHAR2_TABLE_200
80 , a35 out nocopy JTF_VARCHAR2_TABLE_200
81 , a36 out nocopy JTF_VARCHAR2_TABLE_200
82 , a37 out nocopy JTF_VARCHAR2_TABLE_200
83 , a38 out nocopy JTF_VARCHAR2_TABLE_200
84 , a39 out nocopy JTF_VARCHAR2_TABLE_200
85 , a40 out nocopy JTF_VARCHAR2_TABLE_200
86 );
87
88 procedure rosetta_table_copy_in_p4(t out nocopy ahl_mc_rule_pvt.rule_stmt_tbl_type, a0 JTF_NUMBER_TABLE
89 , a1 JTF_NUMBER_TABLE
90 , a2 JTF_DATE_TABLE
91 , a3 JTF_NUMBER_TABLE
92 , a4 JTF_DATE_TABLE
93 , a5 JTF_NUMBER_TABLE
94 , a6 JTF_NUMBER_TABLE
95 , a7 JTF_NUMBER_TABLE
96 , a8 JTF_VARCHAR2_TABLE_100
97 , a9 JTF_VARCHAR2_TABLE_100
98 , a10 JTF_NUMBER_TABLE
99 , a11 JTF_VARCHAR2_TABLE_100
100 , a12 JTF_VARCHAR2_TABLE_100
101 , a13 JTF_NUMBER_TABLE
102 , a14 JTF_VARCHAR2_TABLE_100
103 , a15 JTF_VARCHAR2_TABLE_100
104 , a16 JTF_VARCHAR2_TABLE_100
105 , a17 JTF_VARCHAR2_TABLE_100
106 , a18 JTF_VARCHAR2_TABLE_100
107 , a19 JTF_VARCHAR2_TABLE_100
108 , a20 JTF_VARCHAR2_TABLE_100
109 , a21 JTF_VARCHAR2_TABLE_200
110 , a22 JTF_VARCHAR2_TABLE_200
111 , a23 JTF_VARCHAR2_TABLE_200
112 , a24 JTF_VARCHAR2_TABLE_200
113 , a25 JTF_VARCHAR2_TABLE_200
114 , a26 JTF_VARCHAR2_TABLE_200
115 , a27 JTF_VARCHAR2_TABLE_200
116 , a28 JTF_VARCHAR2_TABLE_200
117 , a29 JTF_VARCHAR2_TABLE_200
118 , a30 JTF_VARCHAR2_TABLE_200
119 , a31 JTF_VARCHAR2_TABLE_200
120 , a32 JTF_VARCHAR2_TABLE_200
121 , a33 JTF_VARCHAR2_TABLE_200
122 , a34 JTF_VARCHAR2_TABLE_200
123 , a35 JTF_VARCHAR2_TABLE_200
124 , a36 JTF_VARCHAR2_TABLE_100
125 );
126 procedure rosetta_table_copy_out_p4(t ahl_mc_rule_pvt.rule_stmt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
127 , a1 out nocopy JTF_NUMBER_TABLE
128 , a2 out nocopy JTF_DATE_TABLE
129 , a3 out nocopy JTF_NUMBER_TABLE
130 , a4 out nocopy JTF_DATE_TABLE
131 , a5 out nocopy JTF_NUMBER_TABLE
132 , a6 out nocopy JTF_NUMBER_TABLE
133 , a7 out nocopy JTF_NUMBER_TABLE
134 , a8 out nocopy JTF_VARCHAR2_TABLE_100
135 , a9 out nocopy JTF_VARCHAR2_TABLE_100
136 , a10 out nocopy JTF_NUMBER_TABLE
137 , a11 out nocopy JTF_VARCHAR2_TABLE_100
138 , a12 out nocopy JTF_VARCHAR2_TABLE_100
139 , a13 out nocopy JTF_NUMBER_TABLE
140 , a14 out nocopy JTF_VARCHAR2_TABLE_100
141 , a15 out nocopy JTF_VARCHAR2_TABLE_100
142 , a16 out nocopy JTF_VARCHAR2_TABLE_100
143 , a17 out nocopy JTF_VARCHAR2_TABLE_100
144 , a18 out nocopy JTF_VARCHAR2_TABLE_100
145 , a19 out nocopy JTF_VARCHAR2_TABLE_100
146 , a20 out nocopy JTF_VARCHAR2_TABLE_100
147 , a21 out nocopy JTF_VARCHAR2_TABLE_200
148 , a22 out nocopy JTF_VARCHAR2_TABLE_200
149 , a23 out nocopy JTF_VARCHAR2_TABLE_200
150 , a24 out nocopy JTF_VARCHAR2_TABLE_200
151 , a25 out nocopy JTF_VARCHAR2_TABLE_200
152 , a26 out nocopy JTF_VARCHAR2_TABLE_200
153 , a27 out nocopy JTF_VARCHAR2_TABLE_200
154 , a28 out nocopy JTF_VARCHAR2_TABLE_200
155 , a29 out nocopy JTF_VARCHAR2_TABLE_200
156 , a30 out nocopy JTF_VARCHAR2_TABLE_200
157 , a31 out nocopy JTF_VARCHAR2_TABLE_200
158 , a32 out nocopy JTF_VARCHAR2_TABLE_200
159 , a33 out nocopy JTF_VARCHAR2_TABLE_200
160 , a34 out nocopy JTF_VARCHAR2_TABLE_200
161 , a35 out nocopy JTF_VARCHAR2_TABLE_200
162 , a36 out nocopy JTF_VARCHAR2_TABLE_100
163 );
164
165 procedure rosetta_table_copy_in_p5(t out nocopy ahl_mc_rule_pvt.rule_tbl_type, a0 JTF_NUMBER_TABLE
166 , a1 JTF_NUMBER_TABLE
167 , a2 JTF_DATE_TABLE
168 , a3 JTF_NUMBER_TABLE
169 , a4 JTF_DATE_TABLE
170 , a5 JTF_NUMBER_TABLE
171 , a6 JTF_NUMBER_TABLE
172 , a7 JTF_NUMBER_TABLE
173 , a8 JTF_VARCHAR2_TABLE_100
174 , a9 JTF_VARCHAR2_TABLE_100
175 , a10 JTF_VARCHAR2_TABLE_100
176 , a11 JTF_VARCHAR2_TABLE_100
177 , a12 JTF_VARCHAR2_TABLE_100
178 , a13 JTF_DATE_TABLE
179 , a14 JTF_DATE_TABLE
180 , a15 JTF_VARCHAR2_TABLE_2000
181 , a16 JTF_VARCHAR2_TABLE_100
182 , a17 JTF_VARCHAR2_TABLE_200
183 , a18 JTF_VARCHAR2_TABLE_200
184 , a19 JTF_VARCHAR2_TABLE_200
185 , a20 JTF_VARCHAR2_TABLE_200
186 , a21 JTF_VARCHAR2_TABLE_200
187 , a22 JTF_VARCHAR2_TABLE_200
188 , a23 JTF_VARCHAR2_TABLE_200
189 , a24 JTF_VARCHAR2_TABLE_200
190 , a25 JTF_VARCHAR2_TABLE_200
191 , a26 JTF_VARCHAR2_TABLE_200
192 , a27 JTF_VARCHAR2_TABLE_200
193 , a28 JTF_VARCHAR2_TABLE_200
194 , a29 JTF_VARCHAR2_TABLE_200
195 , a30 JTF_VARCHAR2_TABLE_200
196 , a31 JTF_VARCHAR2_TABLE_200
197 , a32 JTF_VARCHAR2_TABLE_100
198 );
199 procedure rosetta_table_copy_out_p5(t ahl_mc_rule_pvt.rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
200 , a1 out nocopy JTF_NUMBER_TABLE
201 , a2 out nocopy JTF_DATE_TABLE
202 , a3 out nocopy JTF_NUMBER_TABLE
203 , a4 out nocopy JTF_DATE_TABLE
204 , a5 out nocopy JTF_NUMBER_TABLE
205 , a6 out nocopy JTF_NUMBER_TABLE
206 , a7 out nocopy JTF_NUMBER_TABLE
207 , a8 out nocopy JTF_VARCHAR2_TABLE_100
208 , a9 out nocopy JTF_VARCHAR2_TABLE_100
209 , a10 out nocopy JTF_VARCHAR2_TABLE_100
210 , a11 out nocopy JTF_VARCHAR2_TABLE_100
211 , a12 out nocopy JTF_VARCHAR2_TABLE_100
212 , a13 out nocopy JTF_DATE_TABLE
213 , a14 out nocopy JTF_DATE_TABLE
214 , a15 out nocopy JTF_VARCHAR2_TABLE_2000
215 , a16 out nocopy JTF_VARCHAR2_TABLE_100
216 , a17 out nocopy JTF_VARCHAR2_TABLE_200
217 , a18 out nocopy JTF_VARCHAR2_TABLE_200
218 , a19 out nocopy JTF_VARCHAR2_TABLE_200
219 , a20 out nocopy JTF_VARCHAR2_TABLE_200
220 , a21 out nocopy JTF_VARCHAR2_TABLE_200
221 , a22 out nocopy JTF_VARCHAR2_TABLE_200
222 , a23 out nocopy JTF_VARCHAR2_TABLE_200
223 , a24 out nocopy JTF_VARCHAR2_TABLE_200
224 , a25 out nocopy JTF_VARCHAR2_TABLE_200
225 , a26 out nocopy JTF_VARCHAR2_TABLE_200
226 , a27 out nocopy JTF_VARCHAR2_TABLE_200
227 , a28 out nocopy JTF_VARCHAR2_TABLE_200
228 , a29 out nocopy JTF_VARCHAR2_TABLE_200
229 , a30 out nocopy JTF_VARCHAR2_TABLE_200
230 , a31 out nocopy JTF_VARCHAR2_TABLE_200
231 , a32 out nocopy JTF_VARCHAR2_TABLE_100
232 );
233
234 procedure load_rule(p_api_version NUMBER
235 , p_init_msg_list VARCHAR2
236 , p_commit VARCHAR2
237 , p_validation_level NUMBER
238 , x_return_status out nocopy VARCHAR2
239 , x_msg_count out nocopy NUMBER
240 , x_msg_data out nocopy VARCHAR2
241 , p_rule_id NUMBER
242 , p8_a0 out nocopy JTF_NUMBER_TABLE
243 , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
244 , p8_a2 out nocopy JTF_NUMBER_TABLE
245 , p8_a3 out nocopy JTF_NUMBER_TABLE
246 , p8_a4 out nocopy JTF_NUMBER_TABLE
247 , p8_a5 out nocopy JTF_NUMBER_TABLE
248 , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
249 , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
250 , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
251 , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
252 , p8_a10 out nocopy JTF_VARCHAR2_TABLE_100
253 , p8_a11 out nocopy JTF_NUMBER_TABLE
254 , p8_a12 out nocopy JTF_VARCHAR2_TABLE_100
255 , p8_a13 out nocopy JTF_VARCHAR2_TABLE_100
256 , p8_a14 out nocopy JTF_VARCHAR2_TABLE_100
257 , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
258 , p8_a16 out nocopy JTF_VARCHAR2_TABLE_100
259 , p8_a17 out nocopy JTF_VARCHAR2_TABLE_100
260 , p8_a18 out nocopy JTF_VARCHAR2_TABLE_100
261 , p8_a19 out nocopy JTF_VARCHAR2_TABLE_100
262 , p8_a20 out nocopy JTF_VARCHAR2_TABLE_100
263 , p8_a21 out nocopy JTF_VARCHAR2_TABLE_100
264 , p8_a22 out nocopy JTF_NUMBER_TABLE
265 , p8_a23 out nocopy JTF_NUMBER_TABLE
266 , p8_a24 out nocopy JTF_NUMBER_TABLE
267 , p8_a25 out nocopy JTF_VARCHAR2_TABLE_100
268 , p8_a26 out nocopy JTF_VARCHAR2_TABLE_200
269 , p8_a27 out nocopy JTF_VARCHAR2_TABLE_200
270 , p8_a28 out nocopy JTF_VARCHAR2_TABLE_200
271 , p8_a29 out nocopy JTF_VARCHAR2_TABLE_200
272 , p8_a30 out nocopy JTF_VARCHAR2_TABLE_200
273 , p8_a31 out nocopy JTF_VARCHAR2_TABLE_200
274 , p8_a32 out nocopy JTF_VARCHAR2_TABLE_200
275 , p8_a33 out nocopy JTF_VARCHAR2_TABLE_200
276 , p8_a34 out nocopy JTF_VARCHAR2_TABLE_200
277 , p8_a35 out nocopy JTF_VARCHAR2_TABLE_200
278 , p8_a36 out nocopy JTF_VARCHAR2_TABLE_200
279 , p8_a37 out nocopy JTF_VARCHAR2_TABLE_200
280 , p8_a38 out nocopy JTF_VARCHAR2_TABLE_200
281 , p8_a39 out nocopy JTF_VARCHAR2_TABLE_200
282 , p8_a40 out nocopy JTF_VARCHAR2_TABLE_200
283 );
284 procedure insert_rule(p_api_version NUMBER
285 , p_init_msg_list VARCHAR2
286 , p_commit VARCHAR2
287 , p_validation_level NUMBER
288 , x_return_status out nocopy VARCHAR2
289 , x_msg_count out nocopy NUMBER
290 , x_msg_data out nocopy VARCHAR2
291 , p_module VARCHAR2
292 , p8_a0 JTF_NUMBER_TABLE
293 , p8_a1 JTF_VARCHAR2_TABLE_100
294 , p8_a2 JTF_NUMBER_TABLE
295 , p8_a3 JTF_NUMBER_TABLE
296 , p8_a4 JTF_NUMBER_TABLE
297 , p8_a5 JTF_NUMBER_TABLE
298 , p8_a6 JTF_VARCHAR2_TABLE_100
299 , p8_a7 JTF_VARCHAR2_TABLE_100
300 , p8_a8 JTF_VARCHAR2_TABLE_100
301 , p8_a9 JTF_VARCHAR2_TABLE_100
302 , p8_a10 JTF_VARCHAR2_TABLE_100
303 , p8_a11 JTF_NUMBER_TABLE
304 , p8_a12 JTF_VARCHAR2_TABLE_100
305 , p8_a13 JTF_VARCHAR2_TABLE_100
306 , p8_a14 JTF_VARCHAR2_TABLE_100
307 , p8_a15 JTF_VARCHAR2_TABLE_100
308 , p8_a16 JTF_VARCHAR2_TABLE_100
309 , p8_a17 JTF_VARCHAR2_TABLE_100
310 , p8_a18 JTF_VARCHAR2_TABLE_100
311 , p8_a19 JTF_VARCHAR2_TABLE_100
312 , p8_a20 JTF_VARCHAR2_TABLE_100
313 , p8_a21 JTF_VARCHAR2_TABLE_100
314 , p8_a22 JTF_NUMBER_TABLE
315 , p8_a23 JTF_NUMBER_TABLE
316 , p8_a24 JTF_NUMBER_TABLE
317 , p8_a25 JTF_VARCHAR2_TABLE_100
318 , p8_a26 JTF_VARCHAR2_TABLE_200
319 , p8_a27 JTF_VARCHAR2_TABLE_200
320 , p8_a28 JTF_VARCHAR2_TABLE_200
321 , p8_a29 JTF_VARCHAR2_TABLE_200
322 , p8_a30 JTF_VARCHAR2_TABLE_200
323 , p8_a31 JTF_VARCHAR2_TABLE_200
324 , p8_a32 JTF_VARCHAR2_TABLE_200
325 , p8_a33 JTF_VARCHAR2_TABLE_200
326 , p8_a34 JTF_VARCHAR2_TABLE_200
327 , p8_a35 JTF_VARCHAR2_TABLE_200
328 , p8_a36 JTF_VARCHAR2_TABLE_200
329 , p8_a37 JTF_VARCHAR2_TABLE_200
330 , p8_a38 JTF_VARCHAR2_TABLE_200
331 , p8_a39 JTF_VARCHAR2_TABLE_200
332 , p8_a40 JTF_VARCHAR2_TABLE_200
333 , p9_a0 in out nocopy NUMBER
334 , p9_a1 in out nocopy NUMBER
335 , p9_a2 in out nocopy DATE
336 , p9_a3 in out nocopy NUMBER
337 , p9_a4 in out nocopy DATE
338 , p9_a5 in out nocopy NUMBER
339 , p9_a6 in out nocopy NUMBER
340 , p9_a7 in out nocopy NUMBER
341 , p9_a8 in out nocopy VARCHAR2
342 , p9_a9 in out nocopy VARCHAR2
343 , p9_a10 in out nocopy VARCHAR2
344 , p9_a11 in out nocopy VARCHAR2
345 , p9_a12 in out nocopy VARCHAR2
346 , p9_a13 in out nocopy DATE
347 , p9_a14 in out nocopy DATE
348 , p9_a15 in out nocopy VARCHAR2
349 , p9_a16 in out nocopy VARCHAR2
350 , p9_a17 in out nocopy VARCHAR2
351 , p9_a18 in out nocopy VARCHAR2
352 , p9_a19 in out nocopy VARCHAR2
353 , p9_a20 in out nocopy VARCHAR2
354 , p9_a21 in out nocopy VARCHAR2
355 , p9_a22 in out nocopy VARCHAR2
356 , p9_a23 in out nocopy VARCHAR2
357 , p9_a24 in out nocopy VARCHAR2
358 , p9_a25 in out nocopy VARCHAR2
359 , p9_a26 in out nocopy VARCHAR2
360 , p9_a27 in out nocopy VARCHAR2
361 , p9_a28 in out nocopy VARCHAR2
362 , p9_a29 in out nocopy VARCHAR2
363 , p9_a30 in out nocopy VARCHAR2
364 , p9_a31 in out nocopy VARCHAR2
365 , p9_a32 in out nocopy VARCHAR2
366 );
367 procedure update_rule(p_api_version NUMBER
368 , p_init_msg_list VARCHAR2
369 , p_commit VARCHAR2
370 , p_validation_level NUMBER
371 , x_return_status out nocopy VARCHAR2
372 , x_msg_count out nocopy NUMBER
373 , x_msg_data out nocopy VARCHAR2
374 , p_module VARCHAR2
375 , p8_a0 NUMBER
376 , p8_a1 NUMBER
377 , p8_a2 DATE
378 , p8_a3 NUMBER
379 , p8_a4 DATE
380 , p8_a5 NUMBER
381 , p8_a6 NUMBER
382 , p8_a7 NUMBER
383 , p8_a8 VARCHAR2
384 , p8_a9 VARCHAR2
385 , p8_a10 VARCHAR2
386 , p8_a11 VARCHAR2
387 , p8_a12 VARCHAR2
388 , p8_a13 DATE
389 , p8_a14 DATE
390 , p8_a15 VARCHAR2
391 , p8_a16 VARCHAR2
392 , p8_a17 VARCHAR2
393 , p8_a18 VARCHAR2
394 , p8_a19 VARCHAR2
395 , p8_a20 VARCHAR2
396 , p8_a21 VARCHAR2
397 , p8_a22 VARCHAR2
398 , p8_a23 VARCHAR2
399 , p8_a24 VARCHAR2
400 , p8_a25 VARCHAR2
401 , p8_a26 VARCHAR2
402 , p8_a27 VARCHAR2
403 , p8_a28 VARCHAR2
404 , p8_a29 VARCHAR2
405 , p8_a30 VARCHAR2
406 , p8_a31 VARCHAR2
407 , p8_a32 VARCHAR2
408 , p9_a0 JTF_NUMBER_TABLE
409 , p9_a1 JTF_VARCHAR2_TABLE_100
410 , p9_a2 JTF_NUMBER_TABLE
411 , p9_a3 JTF_NUMBER_TABLE
412 , p9_a4 JTF_NUMBER_TABLE
413 , p9_a5 JTF_NUMBER_TABLE
414 , p9_a6 JTF_VARCHAR2_TABLE_100
415 , p9_a7 JTF_VARCHAR2_TABLE_100
416 , p9_a8 JTF_VARCHAR2_TABLE_100
417 , p9_a9 JTF_VARCHAR2_TABLE_100
418 , p9_a10 JTF_VARCHAR2_TABLE_100
419 , p9_a11 JTF_NUMBER_TABLE
420 , p9_a12 JTF_VARCHAR2_TABLE_100
421 , p9_a13 JTF_VARCHAR2_TABLE_100
422 , p9_a14 JTF_VARCHAR2_TABLE_100
423 , p9_a15 JTF_VARCHAR2_TABLE_100
424 , p9_a16 JTF_VARCHAR2_TABLE_100
425 , p9_a17 JTF_VARCHAR2_TABLE_100
426 , p9_a18 JTF_VARCHAR2_TABLE_100
427 , p9_a19 JTF_VARCHAR2_TABLE_100
428 , p9_a20 JTF_VARCHAR2_TABLE_100
429 , p9_a21 JTF_VARCHAR2_TABLE_100
430 , p9_a22 JTF_NUMBER_TABLE
431 , p9_a23 JTF_NUMBER_TABLE
432 , p9_a24 JTF_NUMBER_TABLE
433 , p9_a25 JTF_VARCHAR2_TABLE_100
434 , p9_a26 JTF_VARCHAR2_TABLE_200
435 , p9_a27 JTF_VARCHAR2_TABLE_200
436 , p9_a28 JTF_VARCHAR2_TABLE_200
437 , p9_a29 JTF_VARCHAR2_TABLE_200
438 , p9_a30 JTF_VARCHAR2_TABLE_200
439 , p9_a31 JTF_VARCHAR2_TABLE_200
440 , p9_a32 JTF_VARCHAR2_TABLE_200
441 , p9_a33 JTF_VARCHAR2_TABLE_200
442 , p9_a34 JTF_VARCHAR2_TABLE_200
443 , p9_a35 JTF_VARCHAR2_TABLE_200
444 , p9_a36 JTF_VARCHAR2_TABLE_200
445 , p9_a37 JTF_VARCHAR2_TABLE_200
446 , p9_a38 JTF_VARCHAR2_TABLE_200
447 , p9_a39 JTF_VARCHAR2_TABLE_200
448 , p9_a40 JTF_VARCHAR2_TABLE_200
449 );
450 procedure delete_rule(p_api_version NUMBER
451 , p_init_msg_list VARCHAR2
452 , p_commit VARCHAR2
453 , p_validation_level NUMBER
454 , x_return_status out nocopy VARCHAR2
455 , x_msg_count out nocopy NUMBER
456 , x_msg_data out nocopy VARCHAR2
457 , p7_a0 NUMBER
458 , p7_a1 NUMBER
459 , p7_a2 DATE
460 , p7_a3 NUMBER
461 , p7_a4 DATE
462 , p7_a5 NUMBER
463 , p7_a6 NUMBER
464 , p7_a7 NUMBER
465 , p7_a8 VARCHAR2
466 , p7_a9 VARCHAR2
467 , p7_a10 VARCHAR2
468 , p7_a11 VARCHAR2
469 , p7_a12 VARCHAR2
470 , p7_a13 DATE
471 , p7_a14 DATE
472 , p7_a15 VARCHAR2
473 , p7_a16 VARCHAR2
474 , p7_a17 VARCHAR2
475 , p7_a18 VARCHAR2
476 , p7_a19 VARCHAR2
477 , p7_a20 VARCHAR2
478 , p7_a21 VARCHAR2
479 , p7_a22 VARCHAR2
480 , p7_a23 VARCHAR2
481 , p7_a24 VARCHAR2
482 , p7_a25 VARCHAR2
483 , p7_a26 VARCHAR2
484 , p7_a27 VARCHAR2
485 , p7_a28 VARCHAR2
486 , p7_a29 VARCHAR2
487 , p7_a30 VARCHAR2
488 , p7_a31 VARCHAR2
489 , p7_a32 VARCHAR2
490 );
491 procedure get_rules_for_position(p_api_version NUMBER
492 , p_init_msg_list VARCHAR2
493 , p_commit VARCHAR2
494 , p_validation_level NUMBER
495 , x_return_status out nocopy VARCHAR2
496 , x_msg_count out nocopy NUMBER
497 , x_msg_data out nocopy VARCHAR2
498 , p_mc_header_id NUMBER
499 , p_encoded_path VARCHAR2
500 , p9_a0 out nocopy JTF_NUMBER_TABLE
501 , p9_a1 out nocopy JTF_NUMBER_TABLE
502 , p9_a2 out nocopy JTF_DATE_TABLE
503 , p9_a3 out nocopy JTF_NUMBER_TABLE
504 , p9_a4 out nocopy JTF_DATE_TABLE
505 , p9_a5 out nocopy JTF_NUMBER_TABLE
506 , p9_a6 out nocopy JTF_NUMBER_TABLE
507 , p9_a7 out nocopy JTF_NUMBER_TABLE
508 , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
509 , p9_a9 out nocopy JTF_VARCHAR2_TABLE_100
510 , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
511 , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
512 , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
513 , p9_a13 out nocopy JTF_DATE_TABLE
514 , p9_a14 out nocopy JTF_DATE_TABLE
515 , p9_a15 out nocopy JTF_VARCHAR2_TABLE_2000
516 , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100
517 , p9_a17 out nocopy JTF_VARCHAR2_TABLE_200
518 , p9_a18 out nocopy JTF_VARCHAR2_TABLE_200
519 , p9_a19 out nocopy JTF_VARCHAR2_TABLE_200
520 , p9_a20 out nocopy JTF_VARCHAR2_TABLE_200
521 , p9_a21 out nocopy JTF_VARCHAR2_TABLE_200
522 , p9_a22 out nocopy JTF_VARCHAR2_TABLE_200
523 , p9_a23 out nocopy JTF_VARCHAR2_TABLE_200
524 , p9_a24 out nocopy JTF_VARCHAR2_TABLE_200
525 , p9_a25 out nocopy JTF_VARCHAR2_TABLE_200
526 , p9_a26 out nocopy JTF_VARCHAR2_TABLE_200
527 , p9_a27 out nocopy JTF_VARCHAR2_TABLE_200
528 , p9_a28 out nocopy JTF_VARCHAR2_TABLE_200
529 , p9_a29 out nocopy JTF_VARCHAR2_TABLE_200
530 , p9_a30 out nocopy JTF_VARCHAR2_TABLE_200
531 , p9_a31 out nocopy JTF_VARCHAR2_TABLE_200
532 , p9_a32 out nocopy JTF_VARCHAR2_TABLE_100
533 );
534 end ahl_mc_rule_pvt_w;