[Home] [Help]
PACKAGE: APPS.OKL_OPTION_RULES_PUB_W
Source
1 package okl_option_rules_pub_w AUTHID CURRENT_USER as
2 /* $Header: OKLUORLS.pls 115.3 2002/12/24 04:13:35 sgorantl noship $ */
3 procedure create_option_rules(p_api_version NUMBER
4 , p_init_msg_list VARCHAR2
5 , x_return_status out nocopy VARCHAR2
6 , x_msg_count out nocopy NUMBER
7 , x_msg_data out nocopy VARCHAR2
8 , p6_a0 JTF_NUMBER_TABLE
9 , p6_a1 JTF_VARCHAR2_TABLE_100
10 , p6_a2 JTF_NUMBER_TABLE
11 , p6_a3 JTF_NUMBER_TABLE
12 , p6_a4 JTF_NUMBER_TABLE
13 , p6_a5 JTF_VARCHAR2_TABLE_2000
14 , p6_a6 JTF_VARCHAR2_TABLE_100
15 , p6_a7 JTF_NUMBER_TABLE
16 , p6_a8 JTF_NUMBER_TABLE
17 , p6_a9 JTF_VARCHAR2_TABLE_100
18 , p6_a10 JTF_NUMBER_TABLE
19 , p6_a11 JTF_DATE_TABLE
20 , p6_a12 JTF_NUMBER_TABLE
21 , p6_a13 JTF_DATE_TABLE
22 , p6_a14 JTF_NUMBER_TABLE
23 , p7_a0 out nocopy NUMBER
24 , p7_a1 out nocopy NUMBER
25 , p7_a2 out nocopy NUMBER
26 , p7_a3 out nocopy NUMBER
27 , p7_a4 out nocopy VARCHAR2
28 , p7_a5 out nocopy VARCHAR2
29 , p7_a6 out nocopy NUMBER
30 , p7_a7 out nocopy NUMBER
31 , p7_a8 out nocopy VARCHAR2
32 , p7_a9 out nocopy NUMBER
33 , p7_a10 out nocopy DATE
34 , p7_a11 out nocopy NUMBER
35 , p7_a12 out nocopy DATE
36 , p7_a13 out nocopy NUMBER
37 , p8_a0 out nocopy JTF_NUMBER_TABLE
38 , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
39 , p8_a2 out nocopy JTF_NUMBER_TABLE
40 , p8_a3 out nocopy JTF_NUMBER_TABLE
41 , p8_a4 out nocopy JTF_NUMBER_TABLE
42 , p8_a5 out nocopy JTF_VARCHAR2_TABLE_2000
43 , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
44 , p8_a7 out nocopy JTF_NUMBER_TABLE
45 , p8_a8 out nocopy JTF_NUMBER_TABLE
46 , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
47 , p8_a10 out nocopy JTF_NUMBER_TABLE
48 , p8_a11 out nocopy JTF_DATE_TABLE
49 , p8_a12 out nocopy JTF_NUMBER_TABLE
50 , p8_a13 out nocopy JTF_DATE_TABLE
51 , p8_a14 out nocopy JTF_NUMBER_TABLE
52 , p5_a0 NUMBER := 0-1962.0724
53 , p5_a1 NUMBER := 0-1962.0724
54 , p5_a2 NUMBER := 0-1962.0724
55 , p5_a3 NUMBER := 0-1962.0724
56 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
57 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
58 , p5_a6 NUMBER := 0-1962.0724
59 , p5_a7 NUMBER := 0-1962.0724
60 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
61 , p5_a9 NUMBER := 0-1962.0724
62 , p5_a10 DATE := fnd_api.g_miss_date
63 , p5_a11 NUMBER := 0-1962.0724
64 , p5_a12 DATE := fnd_api.g_miss_date
65 , p5_a13 NUMBER := 0-1962.0724
66 );
67 procedure update_option_rules(p_api_version NUMBER
68 , p_init_msg_list VARCHAR2
69 , x_return_status out nocopy VARCHAR2
70 , x_msg_count out nocopy NUMBER
71 , x_msg_data out nocopy VARCHAR2
72 , p6_a0 JTF_NUMBER_TABLE
73 , p6_a1 JTF_VARCHAR2_TABLE_100
74 , p6_a2 JTF_NUMBER_TABLE
75 , p6_a3 JTF_NUMBER_TABLE
76 , p6_a4 JTF_NUMBER_TABLE
77 , p6_a5 JTF_VARCHAR2_TABLE_2000
78 , p6_a6 JTF_VARCHAR2_TABLE_100
79 , p6_a7 JTF_NUMBER_TABLE
80 , p6_a8 JTF_NUMBER_TABLE
81 , p6_a9 JTF_VARCHAR2_TABLE_100
82 , p6_a10 JTF_NUMBER_TABLE
83 , p6_a11 JTF_DATE_TABLE
84 , p6_a12 JTF_NUMBER_TABLE
85 , p6_a13 JTF_DATE_TABLE
86 , p6_a14 JTF_NUMBER_TABLE
87 , p7_a0 out nocopy NUMBER
88 , p7_a1 out nocopy NUMBER
89 , p7_a2 out nocopy NUMBER
90 , p7_a3 out nocopy NUMBER
91 , p7_a4 out nocopy VARCHAR2
92 , p7_a5 out nocopy VARCHAR2
93 , p7_a6 out nocopy NUMBER
94 , p7_a7 out nocopy NUMBER
95 , p7_a8 out nocopy VARCHAR2
96 , p7_a9 out nocopy NUMBER
97 , p7_a10 out nocopy DATE
98 , p7_a11 out nocopy NUMBER
99 , p7_a12 out nocopy DATE
100 , p7_a13 out nocopy NUMBER
101 , p8_a0 out nocopy JTF_NUMBER_TABLE
102 , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
103 , p8_a2 out nocopy JTF_NUMBER_TABLE
104 , p8_a3 out nocopy JTF_NUMBER_TABLE
105 , p8_a4 out nocopy JTF_NUMBER_TABLE
106 , p8_a5 out nocopy JTF_VARCHAR2_TABLE_2000
107 , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
108 , p8_a7 out nocopy JTF_NUMBER_TABLE
109 , p8_a8 out nocopy JTF_NUMBER_TABLE
110 , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
111 , p8_a10 out nocopy JTF_NUMBER_TABLE
112 , p8_a11 out nocopy JTF_DATE_TABLE
113 , p8_a12 out nocopy JTF_NUMBER_TABLE
114 , p8_a13 out nocopy JTF_DATE_TABLE
115 , p8_a14 out nocopy JTF_NUMBER_TABLE
116 , p5_a0 NUMBER := 0-1962.0724
117 , p5_a1 NUMBER := 0-1962.0724
118 , p5_a2 NUMBER := 0-1962.0724
119 , p5_a3 NUMBER := 0-1962.0724
120 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
121 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
122 , p5_a6 NUMBER := 0-1962.0724
123 , p5_a7 NUMBER := 0-1962.0724
124 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
125 , p5_a9 NUMBER := 0-1962.0724
126 , p5_a10 DATE := fnd_api.g_miss_date
127 , p5_a11 NUMBER := 0-1962.0724
128 , p5_a12 DATE := fnd_api.g_miss_date
129 , p5_a13 NUMBER := 0-1962.0724
130 );
131 procedure validate_option_rules(p_api_version NUMBER
132 , p_init_msg_list VARCHAR2
133 , x_return_status out nocopy VARCHAR2
134 , x_msg_count out nocopy NUMBER
135 , x_msg_data out nocopy VARCHAR2
136 , p6_a0 JTF_NUMBER_TABLE
137 , p6_a1 JTF_VARCHAR2_TABLE_100
138 , p6_a2 JTF_NUMBER_TABLE
139 , p6_a3 JTF_NUMBER_TABLE
140 , p6_a4 JTF_NUMBER_TABLE
141 , p6_a5 JTF_VARCHAR2_TABLE_2000
142 , p6_a6 JTF_VARCHAR2_TABLE_100
143 , p6_a7 JTF_NUMBER_TABLE
144 , p6_a8 JTF_NUMBER_TABLE
145 , p6_a9 JTF_VARCHAR2_TABLE_100
146 , p6_a10 JTF_NUMBER_TABLE
147 , p6_a11 JTF_DATE_TABLE
148 , p6_a12 JTF_NUMBER_TABLE
149 , p6_a13 JTF_DATE_TABLE
150 , p6_a14 JTF_NUMBER_TABLE
151 , p5_a0 NUMBER := 0-1962.0724
152 , p5_a1 NUMBER := 0-1962.0724
153 , p5_a2 NUMBER := 0-1962.0724
154 , p5_a3 NUMBER := 0-1962.0724
155 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
156 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
157 , p5_a6 NUMBER := 0-1962.0724
158 , p5_a7 NUMBER := 0-1962.0724
159 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
160 , p5_a9 NUMBER := 0-1962.0724
161 , p5_a10 DATE := fnd_api.g_miss_date
162 , p5_a11 NUMBER := 0-1962.0724
163 , p5_a12 DATE := fnd_api.g_miss_date
164 , p5_a13 NUMBER := 0-1962.0724
165 );
166 procedure create_option_rules(p_api_version NUMBER
167 , p_init_msg_list VARCHAR2
168 , x_return_status out nocopy VARCHAR2
169 , x_msg_count out nocopy NUMBER
170 , x_msg_data out nocopy VARCHAR2
171 , p5_a0 JTF_NUMBER_TABLE
172 , p5_a1 JTF_NUMBER_TABLE
173 , p5_a2 JTF_NUMBER_TABLE
174 , p5_a3 JTF_NUMBER_TABLE
175 , p5_a4 JTF_VARCHAR2_TABLE_100
176 , p5_a5 JTF_VARCHAR2_TABLE_100
177 , p5_a6 JTF_NUMBER_TABLE
178 , p5_a7 JTF_NUMBER_TABLE
179 , p5_a8 JTF_VARCHAR2_TABLE_2000
180 , p5_a9 JTF_NUMBER_TABLE
181 , p5_a10 JTF_DATE_TABLE
182 , p5_a11 JTF_NUMBER_TABLE
183 , p5_a12 JTF_DATE_TABLE
184 , p5_a13 JTF_NUMBER_TABLE
185 , p6_a0 out nocopy JTF_NUMBER_TABLE
186 , p6_a1 out nocopy JTF_NUMBER_TABLE
187 , p6_a2 out nocopy JTF_NUMBER_TABLE
188 , p6_a3 out nocopy JTF_NUMBER_TABLE
189 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
190 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
191 , p6_a6 out nocopy JTF_NUMBER_TABLE
192 , p6_a7 out nocopy JTF_NUMBER_TABLE
193 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
194 , p6_a9 out nocopy JTF_NUMBER_TABLE
195 , p6_a10 out nocopy JTF_DATE_TABLE
196 , p6_a11 out nocopy JTF_NUMBER_TABLE
197 , p6_a12 out nocopy JTF_DATE_TABLE
198 , p6_a13 out nocopy JTF_NUMBER_TABLE
199 );
200 procedure create_option_rules(p_api_version NUMBER
201 , p_init_msg_list VARCHAR2
202 , x_return_status out nocopy VARCHAR2
203 , x_msg_count out nocopy NUMBER
204 , x_msg_data out nocopy VARCHAR2
205 , p6_a0 out nocopy NUMBER
206 , p6_a1 out nocopy NUMBER
207 , p6_a2 out nocopy NUMBER
208 , p6_a3 out nocopy NUMBER
209 , p6_a4 out nocopy VARCHAR2
210 , p6_a5 out nocopy VARCHAR2
211 , p6_a6 out nocopy NUMBER
212 , p6_a7 out nocopy NUMBER
213 , p6_a8 out nocopy VARCHAR2
214 , p6_a9 out nocopy NUMBER
215 , p6_a10 out nocopy DATE
216 , p6_a11 out nocopy NUMBER
217 , p6_a12 out nocopy DATE
218 , p6_a13 out nocopy NUMBER
219 , p5_a0 NUMBER := 0-1962.0724
220 , p5_a1 NUMBER := 0-1962.0724
221 , p5_a2 NUMBER := 0-1962.0724
222 , p5_a3 NUMBER := 0-1962.0724
223 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
224 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
225 , p5_a6 NUMBER := 0-1962.0724
226 , p5_a7 NUMBER := 0-1962.0724
227 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
228 , p5_a9 NUMBER := 0-1962.0724
229 , p5_a10 DATE := fnd_api.g_miss_date
230 , p5_a11 NUMBER := 0-1962.0724
231 , p5_a12 DATE := fnd_api.g_miss_date
232 , p5_a13 NUMBER := 0-1962.0724
233 );
234 procedure lock_option_rules(p_api_version NUMBER
235 , p_init_msg_list VARCHAR2
236 , x_return_status out nocopy VARCHAR2
237 , x_msg_count out nocopy NUMBER
238 , x_msg_data out nocopy VARCHAR2
239 , p5_a0 JTF_NUMBER_TABLE
240 , p5_a1 JTF_NUMBER_TABLE
241 , p5_a2 JTF_NUMBER_TABLE
242 , p5_a3 JTF_NUMBER_TABLE
243 , p5_a4 JTF_VARCHAR2_TABLE_100
244 , p5_a5 JTF_VARCHAR2_TABLE_100
245 , p5_a6 JTF_NUMBER_TABLE
246 , p5_a7 JTF_NUMBER_TABLE
247 , p5_a8 JTF_VARCHAR2_TABLE_2000
248 , p5_a9 JTF_NUMBER_TABLE
249 , p5_a10 JTF_DATE_TABLE
250 , p5_a11 JTF_NUMBER_TABLE
251 , p5_a12 JTF_DATE_TABLE
252 , p5_a13 JTF_NUMBER_TABLE
253 );
254 procedure lock_option_rules(p_api_version NUMBER
255 , p_init_msg_list VARCHAR2
256 , x_return_status out nocopy VARCHAR2
257 , x_msg_count out nocopy NUMBER
258 , x_msg_data out nocopy VARCHAR2
259 , p5_a0 NUMBER := 0-1962.0724
260 , p5_a1 NUMBER := 0-1962.0724
261 , p5_a2 NUMBER := 0-1962.0724
262 , p5_a3 NUMBER := 0-1962.0724
263 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
264 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
265 , p5_a6 NUMBER := 0-1962.0724
266 , p5_a7 NUMBER := 0-1962.0724
267 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
268 , p5_a9 NUMBER := 0-1962.0724
269 , p5_a10 DATE := fnd_api.g_miss_date
270 , p5_a11 NUMBER := 0-1962.0724
271 , p5_a12 DATE := fnd_api.g_miss_date
272 , p5_a13 NUMBER := 0-1962.0724
273 );
274 procedure update_option_rules(p_api_version NUMBER
275 , p_init_msg_list VARCHAR2
276 , x_return_status out nocopy VARCHAR2
277 , x_msg_count out nocopy NUMBER
278 , x_msg_data out nocopy VARCHAR2
279 , p5_a0 JTF_NUMBER_TABLE
280 , p5_a1 JTF_NUMBER_TABLE
281 , p5_a2 JTF_NUMBER_TABLE
282 , p5_a3 JTF_NUMBER_TABLE
283 , p5_a4 JTF_VARCHAR2_TABLE_100
284 , p5_a5 JTF_VARCHAR2_TABLE_100
285 , p5_a6 JTF_NUMBER_TABLE
286 , p5_a7 JTF_NUMBER_TABLE
287 , p5_a8 JTF_VARCHAR2_TABLE_2000
288 , p5_a9 JTF_NUMBER_TABLE
289 , p5_a10 JTF_DATE_TABLE
290 , p5_a11 JTF_NUMBER_TABLE
291 , p5_a12 JTF_DATE_TABLE
292 , p5_a13 JTF_NUMBER_TABLE
293 , p6_a0 out nocopy JTF_NUMBER_TABLE
294 , p6_a1 out nocopy JTF_NUMBER_TABLE
295 , p6_a2 out nocopy JTF_NUMBER_TABLE
296 , p6_a3 out nocopy JTF_NUMBER_TABLE
297 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
298 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
299 , p6_a6 out nocopy JTF_NUMBER_TABLE
300 , p6_a7 out nocopy JTF_NUMBER_TABLE
301 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
302 , p6_a9 out nocopy JTF_NUMBER_TABLE
303 , p6_a10 out nocopy JTF_DATE_TABLE
304 , p6_a11 out nocopy JTF_NUMBER_TABLE
305 , p6_a12 out nocopy JTF_DATE_TABLE
306 , p6_a13 out nocopy JTF_NUMBER_TABLE
307 );
308 procedure update_option_rules(p_api_version NUMBER
309 , p_init_msg_list VARCHAR2
310 , x_return_status out nocopy VARCHAR2
311 , x_msg_count out nocopy NUMBER
312 , x_msg_data out nocopy VARCHAR2
313 , p6_a0 out nocopy NUMBER
314 , p6_a1 out nocopy NUMBER
315 , p6_a2 out nocopy NUMBER
316 , p6_a3 out nocopy NUMBER
317 , p6_a4 out nocopy VARCHAR2
318 , p6_a5 out nocopy VARCHAR2
319 , p6_a6 out nocopy NUMBER
320 , p6_a7 out nocopy NUMBER
321 , p6_a8 out nocopy VARCHAR2
322 , p6_a9 out nocopy NUMBER
323 , p6_a10 out nocopy DATE
324 , p6_a11 out nocopy NUMBER
325 , p6_a12 out nocopy DATE
326 , p6_a13 out nocopy NUMBER
327 , p5_a0 NUMBER := 0-1962.0724
328 , p5_a1 NUMBER := 0-1962.0724
329 , p5_a2 NUMBER := 0-1962.0724
330 , p5_a3 NUMBER := 0-1962.0724
331 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
332 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
333 , p5_a6 NUMBER := 0-1962.0724
334 , p5_a7 NUMBER := 0-1962.0724
335 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
336 , p5_a9 NUMBER := 0-1962.0724
337 , p5_a10 DATE := fnd_api.g_miss_date
338 , p5_a11 NUMBER := 0-1962.0724
339 , p5_a12 DATE := fnd_api.g_miss_date
340 , p5_a13 NUMBER := 0-1962.0724
341 );
342 procedure delete_option_rules(p_api_version NUMBER
343 , p_init_msg_list VARCHAR2
344 , x_return_status out nocopy VARCHAR2
345 , x_msg_count out nocopy NUMBER
346 , x_msg_data out nocopy VARCHAR2
347 , p5_a0 JTF_NUMBER_TABLE
348 , p5_a1 JTF_NUMBER_TABLE
349 , p5_a2 JTF_NUMBER_TABLE
350 , p5_a3 JTF_NUMBER_TABLE
351 , p5_a4 JTF_VARCHAR2_TABLE_100
352 , p5_a5 JTF_VARCHAR2_TABLE_100
353 , p5_a6 JTF_NUMBER_TABLE
354 , p5_a7 JTF_NUMBER_TABLE
355 , p5_a8 JTF_VARCHAR2_TABLE_2000
356 , p5_a9 JTF_NUMBER_TABLE
357 , p5_a10 JTF_DATE_TABLE
358 , p5_a11 JTF_NUMBER_TABLE
359 , p5_a12 JTF_DATE_TABLE
360 , p5_a13 JTF_NUMBER_TABLE
361 );
362 procedure delete_option_rules(p_api_version NUMBER
363 , p_init_msg_list VARCHAR2
364 , x_return_status out nocopy VARCHAR2
365 , x_msg_count out nocopy NUMBER
366 , x_msg_data out nocopy VARCHAR2
367 , p5_a0 NUMBER := 0-1962.0724
368 , p5_a1 NUMBER := 0-1962.0724
369 , p5_a2 NUMBER := 0-1962.0724
370 , p5_a3 NUMBER := 0-1962.0724
371 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
372 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
373 , p5_a6 NUMBER := 0-1962.0724
374 , p5_a7 NUMBER := 0-1962.0724
375 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
376 , p5_a9 NUMBER := 0-1962.0724
377 , p5_a10 DATE := fnd_api.g_miss_date
378 , p5_a11 NUMBER := 0-1962.0724
379 , p5_a12 DATE := fnd_api.g_miss_date
380 , p5_a13 NUMBER := 0-1962.0724
381 );
382 procedure validate_option_rules(p_api_version NUMBER
383 , p_init_msg_list VARCHAR2
384 , x_return_status out nocopy VARCHAR2
385 , x_msg_count out nocopy NUMBER
386 , x_msg_data out nocopy VARCHAR2
387 , p5_a0 JTF_NUMBER_TABLE
388 , p5_a1 JTF_NUMBER_TABLE
389 , p5_a2 JTF_NUMBER_TABLE
390 , p5_a3 JTF_NUMBER_TABLE
391 , p5_a4 JTF_VARCHAR2_TABLE_100
392 , p5_a5 JTF_VARCHAR2_TABLE_100
393 , p5_a6 JTF_NUMBER_TABLE
394 , p5_a7 JTF_NUMBER_TABLE
395 , p5_a8 JTF_VARCHAR2_TABLE_2000
396 , p5_a9 JTF_NUMBER_TABLE
397 , p5_a10 JTF_DATE_TABLE
398 , p5_a11 JTF_NUMBER_TABLE
402 procedure validate_option_rules(p_api_version NUMBER
399 , p5_a12 JTF_DATE_TABLE
400 , p5_a13 JTF_NUMBER_TABLE
401 );
403 , p_init_msg_list VARCHAR2
404 , x_return_status out nocopy VARCHAR2
405 , x_msg_count out nocopy NUMBER
406 , x_msg_data out nocopy VARCHAR2
407 , p5_a0 NUMBER := 0-1962.0724
408 , p5_a1 NUMBER := 0-1962.0724
409 , p5_a2 NUMBER := 0-1962.0724
410 , p5_a3 NUMBER := 0-1962.0724
411 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
412 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
413 , p5_a6 NUMBER := 0-1962.0724
414 , p5_a7 NUMBER := 0-1962.0724
415 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
416 , p5_a9 NUMBER := 0-1962.0724
417 , p5_a10 DATE := fnd_api.g_miss_date
418 , p5_a11 NUMBER := 0-1962.0724
419 , p5_a12 DATE := fnd_api.g_miss_date
420 , p5_a13 NUMBER := 0-1962.0724
421 );
422 procedure create_option_val_rules(p_api_version NUMBER
423 , p_init_msg_list VARCHAR2
424 , x_return_status out nocopy VARCHAR2
425 , x_msg_count out nocopy NUMBER
426 , x_msg_data out nocopy VARCHAR2
427 , p5_a0 JTF_NUMBER_TABLE
428 , p5_a1 JTF_VARCHAR2_TABLE_100
429 , p5_a2 JTF_NUMBER_TABLE
430 , p5_a3 JTF_NUMBER_TABLE
431 , p5_a4 JTF_NUMBER_TABLE
432 , p5_a5 JTF_VARCHAR2_TABLE_2000
433 , p5_a6 JTF_VARCHAR2_TABLE_100
434 , p5_a7 JTF_NUMBER_TABLE
435 , p5_a8 JTF_NUMBER_TABLE
436 , p5_a9 JTF_VARCHAR2_TABLE_100
437 , p5_a10 JTF_NUMBER_TABLE
438 , p5_a11 JTF_DATE_TABLE
439 , p5_a12 JTF_NUMBER_TABLE
440 , p5_a13 JTF_DATE_TABLE
441 , p5_a14 JTF_NUMBER_TABLE
442 , p6_a0 out nocopy JTF_NUMBER_TABLE
443 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
444 , p6_a2 out nocopy JTF_NUMBER_TABLE
445 , p6_a3 out nocopy JTF_NUMBER_TABLE
446 , p6_a4 out nocopy JTF_NUMBER_TABLE
447 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
448 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
449 , p6_a7 out nocopy JTF_NUMBER_TABLE
450 , p6_a8 out nocopy JTF_NUMBER_TABLE
451 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
452 , p6_a10 out nocopy JTF_NUMBER_TABLE
453 , p6_a11 out nocopy JTF_DATE_TABLE
454 , p6_a12 out nocopy JTF_NUMBER_TABLE
455 , p6_a13 out nocopy JTF_DATE_TABLE
456 , p6_a14 out nocopy JTF_NUMBER_TABLE
457 );
458 procedure create_option_val_rules(p_api_version NUMBER
459 , p_init_msg_list VARCHAR2
460 , x_return_status out nocopy VARCHAR2
461 , x_msg_count out nocopy NUMBER
462 , x_msg_data out nocopy VARCHAR2
463 , p6_a0 out nocopy NUMBER
464 , p6_a1 out nocopy VARCHAR2
465 , p6_a2 out nocopy NUMBER
466 , p6_a3 out nocopy NUMBER
467 , p6_a4 out nocopy NUMBER
468 , p6_a5 out nocopy VARCHAR2
469 , p6_a6 out nocopy VARCHAR2
470 , p6_a7 out nocopy NUMBER
471 , p6_a8 out nocopy NUMBER
472 , p6_a9 out nocopy VARCHAR2
473 , p6_a10 out nocopy NUMBER
474 , p6_a11 out nocopy DATE
475 , p6_a12 out nocopy NUMBER
476 , p6_a13 out nocopy DATE
477 , p6_a14 out nocopy NUMBER
478 , p5_a0 NUMBER := 0-1962.0724
479 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
480 , p5_a2 NUMBER := 0-1962.0724
481 , p5_a3 NUMBER := 0-1962.0724
482 , p5_a4 NUMBER := 0-1962.0724
483 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
484 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
485 , p5_a7 NUMBER := 0-1962.0724
486 , p5_a8 NUMBER := 0-1962.0724
487 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
488 , p5_a10 NUMBER := 0-1962.0724
489 , p5_a11 DATE := fnd_api.g_miss_date
490 , p5_a12 NUMBER := 0-1962.0724
491 , p5_a13 DATE := fnd_api.g_miss_date
492 , p5_a14 NUMBER := 0-1962.0724
493 );
494 procedure lock_option_val_rules(p_api_version NUMBER
495 , p_init_msg_list VARCHAR2
496 , x_return_status out nocopy VARCHAR2
497 , x_msg_count out nocopy NUMBER
498 , x_msg_data out nocopy VARCHAR2
499 , p5_a0 JTF_NUMBER_TABLE
500 , p5_a1 JTF_VARCHAR2_TABLE_100
501 , p5_a2 JTF_NUMBER_TABLE
502 , p5_a3 JTF_NUMBER_TABLE
503 , p5_a4 JTF_NUMBER_TABLE
504 , p5_a5 JTF_VARCHAR2_TABLE_2000
505 , p5_a6 JTF_VARCHAR2_TABLE_100
506 , p5_a7 JTF_NUMBER_TABLE
507 , p5_a8 JTF_NUMBER_TABLE
508 , p5_a9 JTF_VARCHAR2_TABLE_100
509 , p5_a10 JTF_NUMBER_TABLE
510 , p5_a11 JTF_DATE_TABLE
511 , p5_a12 JTF_NUMBER_TABLE
512 , p5_a13 JTF_DATE_TABLE
513 , p5_a14 JTF_NUMBER_TABLE
514 );
515 procedure lock_option_val_rules(p_api_version NUMBER
516 , p_init_msg_list VARCHAR2
517 , x_return_status out nocopy VARCHAR2
518 , x_msg_count out nocopy NUMBER
519 , x_msg_data out nocopy VARCHAR2
520 , p5_a0 NUMBER := 0-1962.0724
521 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
522 , p5_a2 NUMBER := 0-1962.0724
523 , p5_a3 NUMBER := 0-1962.0724
524 , p5_a4 NUMBER := 0-1962.0724
525 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
526 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
527 , p5_a7 NUMBER := 0-1962.0724
528 , p5_a8 NUMBER := 0-1962.0724
529 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
530 , p5_a10 NUMBER := 0-1962.0724
531 , p5_a11 DATE := fnd_api.g_miss_date
532 , p5_a12 NUMBER := 0-1962.0724
533 , p5_a13 DATE := fnd_api.g_miss_date
534 , p5_a14 NUMBER := 0-1962.0724
535 );
536 procedure update_option_val_rules(p_api_version NUMBER
537 , p_init_msg_list VARCHAR2
538 , x_return_status out nocopy VARCHAR2
539 , x_msg_count out nocopy NUMBER
540 , x_msg_data out nocopy VARCHAR2
541 , p5_a0 JTF_NUMBER_TABLE
542 , p5_a1 JTF_VARCHAR2_TABLE_100
543 , p5_a2 JTF_NUMBER_TABLE
544 , p5_a3 JTF_NUMBER_TABLE
545 , p5_a4 JTF_NUMBER_TABLE
546 , p5_a5 JTF_VARCHAR2_TABLE_2000
547 , p5_a6 JTF_VARCHAR2_TABLE_100
548 , p5_a7 JTF_NUMBER_TABLE
549 , p5_a8 JTF_NUMBER_TABLE
550 , p5_a9 JTF_VARCHAR2_TABLE_100
551 , p5_a10 JTF_NUMBER_TABLE
552 , p5_a11 JTF_DATE_TABLE
553 , p5_a12 JTF_NUMBER_TABLE
554 , p5_a13 JTF_DATE_TABLE
555 , p5_a14 JTF_NUMBER_TABLE
556 , p6_a0 out nocopy JTF_NUMBER_TABLE
557 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
558 , p6_a2 out nocopy JTF_NUMBER_TABLE
559 , p6_a3 out nocopy JTF_NUMBER_TABLE
560 , p6_a4 out nocopy JTF_NUMBER_TABLE
561 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
562 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
563 , p6_a7 out nocopy JTF_NUMBER_TABLE
564 , p6_a8 out nocopy JTF_NUMBER_TABLE
565 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
566 , p6_a10 out nocopy JTF_NUMBER_TABLE
570 , p6_a14 out nocopy JTF_NUMBER_TABLE
567 , p6_a11 out nocopy JTF_DATE_TABLE
568 , p6_a12 out nocopy JTF_NUMBER_TABLE
569 , p6_a13 out nocopy JTF_DATE_TABLE
571 );
572 procedure update_option_val_rules(p_api_version NUMBER
573 , p_init_msg_list VARCHAR2
574 , x_return_status out nocopy VARCHAR2
575 , x_msg_count out nocopy NUMBER
576 , x_msg_data out nocopy VARCHAR2
577 , p6_a0 out nocopy NUMBER
578 , p6_a1 out nocopy VARCHAR2
579 , p6_a2 out nocopy NUMBER
580 , p6_a3 out nocopy NUMBER
581 , p6_a4 out nocopy NUMBER
582 , p6_a5 out nocopy VARCHAR2
583 , p6_a6 out nocopy VARCHAR2
584 , p6_a7 out nocopy NUMBER
585 , p6_a8 out nocopy NUMBER
586 , p6_a9 out nocopy VARCHAR2
587 , p6_a10 out nocopy NUMBER
588 , p6_a11 out nocopy DATE
589 , p6_a12 out nocopy NUMBER
590 , p6_a13 out nocopy DATE
591 , p6_a14 out nocopy NUMBER
592 , p5_a0 NUMBER := 0-1962.0724
593 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
594 , p5_a2 NUMBER := 0-1962.0724
595 , p5_a3 NUMBER := 0-1962.0724
596 , p5_a4 NUMBER := 0-1962.0724
597 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
598 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
599 , p5_a7 NUMBER := 0-1962.0724
600 , p5_a8 NUMBER := 0-1962.0724
601 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
602 , p5_a10 NUMBER := 0-1962.0724
603 , p5_a11 DATE := fnd_api.g_miss_date
604 , p5_a12 NUMBER := 0-1962.0724
605 , p5_a13 DATE := fnd_api.g_miss_date
606 , p5_a14 NUMBER := 0-1962.0724
607 );
608 procedure delete_option_val_rules(p_api_version NUMBER
609 , p_init_msg_list VARCHAR2
610 , x_return_status out nocopy VARCHAR2
611 , x_msg_count out nocopy NUMBER
612 , x_msg_data out nocopy VARCHAR2
613 , p5_a0 JTF_NUMBER_TABLE
614 , p5_a1 JTF_VARCHAR2_TABLE_100
615 , p5_a2 JTF_NUMBER_TABLE
616 , p5_a3 JTF_NUMBER_TABLE
617 , p5_a4 JTF_NUMBER_TABLE
618 , p5_a5 JTF_VARCHAR2_TABLE_2000
619 , p5_a6 JTF_VARCHAR2_TABLE_100
620 , p5_a7 JTF_NUMBER_TABLE
621 , p5_a8 JTF_NUMBER_TABLE
622 , p5_a9 JTF_VARCHAR2_TABLE_100
623 , p5_a10 JTF_NUMBER_TABLE
624 , p5_a11 JTF_DATE_TABLE
625 , p5_a12 JTF_NUMBER_TABLE
626 , p5_a13 JTF_DATE_TABLE
627 , p5_a14 JTF_NUMBER_TABLE
628 );
629 procedure delete_option_val_rules(p_api_version NUMBER
630 , p_init_msg_list VARCHAR2
631 , x_return_status out nocopy VARCHAR2
632 , x_msg_count out nocopy NUMBER
633 , x_msg_data out nocopy VARCHAR2
634 , p5_a0 NUMBER := 0-1962.0724
635 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
636 , p5_a2 NUMBER := 0-1962.0724
637 , p5_a3 NUMBER := 0-1962.0724
638 , p5_a4 NUMBER := 0-1962.0724
639 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
640 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
641 , p5_a7 NUMBER := 0-1962.0724
642 , p5_a8 NUMBER := 0-1962.0724
643 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
644 , p5_a10 NUMBER := 0-1962.0724
645 , p5_a11 DATE := fnd_api.g_miss_date
646 , p5_a12 NUMBER := 0-1962.0724
647 , p5_a13 DATE := fnd_api.g_miss_date
648 , p5_a14 NUMBER := 0-1962.0724
649 );
650 procedure validate_option_val_rules(p_api_version NUMBER
651 , p_init_msg_list VARCHAR2
652 , x_return_status out nocopy VARCHAR2
653 , x_msg_count out nocopy NUMBER
654 , x_msg_data out nocopy VARCHAR2
655 , p5_a0 JTF_NUMBER_TABLE
656 , p5_a1 JTF_VARCHAR2_TABLE_100
657 , p5_a2 JTF_NUMBER_TABLE
658 , p5_a3 JTF_NUMBER_TABLE
659 , p5_a4 JTF_NUMBER_TABLE
660 , p5_a5 JTF_VARCHAR2_TABLE_2000
661 , p5_a6 JTF_VARCHAR2_TABLE_100
662 , p5_a7 JTF_NUMBER_TABLE
663 , p5_a8 JTF_NUMBER_TABLE
664 , p5_a9 JTF_VARCHAR2_TABLE_100
665 , p5_a10 JTF_NUMBER_TABLE
666 , p5_a11 JTF_DATE_TABLE
667 , p5_a12 JTF_NUMBER_TABLE
668 , p5_a13 JTF_DATE_TABLE
669 , p5_a14 JTF_NUMBER_TABLE
670 );
671 procedure validate_option_val_rules(p_api_version NUMBER
672 , p_init_msg_list VARCHAR2
673 , x_return_status out nocopy VARCHAR2
674 , x_msg_count out nocopy NUMBER
675 , x_msg_data out nocopy VARCHAR2
676 , p5_a0 NUMBER := 0-1962.0724
677 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
678 , p5_a2 NUMBER := 0-1962.0724
679 , p5_a3 NUMBER := 0-1962.0724
680 , p5_a4 NUMBER := 0-1962.0724
681 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
682 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
683 , p5_a7 NUMBER := 0-1962.0724
684 , p5_a8 NUMBER := 0-1962.0724
685 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
686 , p5_a10 NUMBER := 0-1962.0724
687 , p5_a11 DATE := fnd_api.g_miss_date
688 , p5_a12 NUMBER := 0-1962.0724
689 , p5_a13 DATE := fnd_api.g_miss_date
690 , p5_a14 NUMBER := 0-1962.0724
691 );
692 end okl_option_rules_pub_w;