[Home] [Help]
PACKAGE: APPS.OKL_OPT_RUL_TMP_PUB_W
Source
1 package okl_opt_rul_tmp_pub_w as
2 /* $Header: OKLURTMS.pls 120.2 2005/12/08 17:54:28 stmathew noship $ */
3 procedure insert_opt_rul_tmp(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 , p_ovd_id NUMBER
9 , p6_a0 JTF_VARCHAR2_TABLE_100
10 , p6_a1 JTF_NUMBER_TABLE
11 , p6_a2 JTF_NUMBER_TABLE
12 , p6_a3 JTF_VARCHAR2_TABLE_100
13 , p6_a4 JTF_VARCHAR2_TABLE_100
14 , p6_a5 JTF_VARCHAR2_TABLE_100
15 , p6_a6 JTF_VARCHAR2_TABLE_100
16 , p6_a7 JTF_VARCHAR2_TABLE_200
17 , p6_a8 JTF_VARCHAR2_TABLE_200
18 , p6_a9 JTF_VARCHAR2_TABLE_200
19 , p6_a10 JTF_VARCHAR2_TABLE_100
20 , p6_a11 JTF_VARCHAR2_TABLE_100
21 , p6_a12 JTF_VARCHAR2_TABLE_100
22 , p6_a13 JTF_NUMBER_TABLE
23 , p6_a14 JTF_NUMBER_TABLE
24 , p6_a15 JTF_NUMBER_TABLE
25 , p6_a16 JTF_VARCHAR2_TABLE_100
26 , p6_a17 JTF_VARCHAR2_TABLE_2000
27 , p6_a18 JTF_VARCHAR2_TABLE_100
28 , p6_a19 JTF_VARCHAR2_TABLE_100
29 , p6_a20 JTF_VARCHAR2_TABLE_500
30 , p6_a21 JTF_VARCHAR2_TABLE_500
31 , p6_a22 JTF_VARCHAR2_TABLE_500
32 , p6_a23 JTF_VARCHAR2_TABLE_500
33 , p6_a24 JTF_VARCHAR2_TABLE_500
34 , p6_a25 JTF_VARCHAR2_TABLE_500
35 , p6_a26 JTF_VARCHAR2_TABLE_500
36 , p6_a27 JTF_VARCHAR2_TABLE_500
37 , p6_a28 JTF_VARCHAR2_TABLE_500
38 , p6_a29 JTF_VARCHAR2_TABLE_500
39 , p6_a30 JTF_VARCHAR2_TABLE_500
40 , p6_a31 JTF_VARCHAR2_TABLE_500
41 , p6_a32 JTF_VARCHAR2_TABLE_500
42 , p6_a33 JTF_VARCHAR2_TABLE_500
43 , p6_a34 JTF_VARCHAR2_TABLE_500
44 , p6_a35 JTF_NUMBER_TABLE
45 , p6_a36 JTF_DATE_TABLE
46 , p6_a37 JTF_NUMBER_TABLE
47 , p6_a38 JTF_DATE_TABLE
48 , p6_a39 JTF_NUMBER_TABLE
49 , p6_a40 JTF_VARCHAR2_TABLE_100
50 , p6_a41 JTF_VARCHAR2_TABLE_500
51 , p6_a42 JTF_VARCHAR2_TABLE_500
52 , p6_a43 JTF_VARCHAR2_TABLE_500
53 , p6_a44 JTF_VARCHAR2_TABLE_500
54 , p6_a45 JTF_VARCHAR2_TABLE_500
55 , p6_a46 JTF_VARCHAR2_TABLE_500
56 , p6_a47 JTF_VARCHAR2_TABLE_500
57 , p6_a48 JTF_VARCHAR2_TABLE_500
58 , p6_a49 JTF_VARCHAR2_TABLE_500
59 , p6_a50 JTF_VARCHAR2_TABLE_500
60 , p6_a51 JTF_VARCHAR2_TABLE_500
61 , p6_a52 JTF_VARCHAR2_TABLE_500
62 , p6_a53 JTF_VARCHAR2_TABLE_500
63 , p6_a54 JTF_VARCHAR2_TABLE_500
64 , p6_a55 JTF_VARCHAR2_TABLE_500
65 , p6_a56 JTF_VARCHAR2_TABLE_100
66 , p6_a57 JTF_VARCHAR2_TABLE_100
67 , p6_a58 JTF_VARCHAR2_TABLE_100
68 , p6_a59 JTF_VARCHAR2_TABLE_100
69 , p6_a60 JTF_NUMBER_TABLE
70 , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
71 , p7_a1 out nocopy JTF_NUMBER_TABLE
72 , p7_a2 out nocopy JTF_NUMBER_TABLE
73 , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
74 , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
75 , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
76 , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
77 , p7_a7 out nocopy JTF_VARCHAR2_TABLE_200
78 , p7_a8 out nocopy JTF_VARCHAR2_TABLE_200
79 , p7_a9 out nocopy JTF_VARCHAR2_TABLE_200
80 , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
81 , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
82 , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
83 , p7_a13 out nocopy JTF_NUMBER_TABLE
84 , p7_a14 out nocopy JTF_NUMBER_TABLE
85 , p7_a15 out nocopy JTF_NUMBER_TABLE
86 , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
87 , p7_a17 out nocopy JTF_VARCHAR2_TABLE_2000
88 , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
89 , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
90 , p7_a20 out nocopy JTF_VARCHAR2_TABLE_500
91 , p7_a21 out nocopy JTF_VARCHAR2_TABLE_500
92 , p7_a22 out nocopy JTF_VARCHAR2_TABLE_500
93 , p7_a23 out nocopy JTF_VARCHAR2_TABLE_500
94 , p7_a24 out nocopy JTF_VARCHAR2_TABLE_500
95 , p7_a25 out nocopy JTF_VARCHAR2_TABLE_500
96 , p7_a26 out nocopy JTF_VARCHAR2_TABLE_500
97 , p7_a27 out nocopy JTF_VARCHAR2_TABLE_500
98 , p7_a28 out nocopy JTF_VARCHAR2_TABLE_500
99 , p7_a29 out nocopy JTF_VARCHAR2_TABLE_500
100 , p7_a30 out nocopy JTF_VARCHAR2_TABLE_500
101 , p7_a31 out nocopy JTF_VARCHAR2_TABLE_500
102 , p7_a32 out nocopy JTF_VARCHAR2_TABLE_500
103 , p7_a33 out nocopy JTF_VARCHAR2_TABLE_500
104 , p7_a34 out nocopy JTF_VARCHAR2_TABLE_500
105 , p7_a35 out nocopy JTF_NUMBER_TABLE
106 , p7_a36 out nocopy JTF_DATE_TABLE
107 , p7_a37 out nocopy JTF_NUMBER_TABLE
108 , p7_a38 out nocopy JTF_DATE_TABLE
109 , p7_a39 out nocopy JTF_NUMBER_TABLE
110 , p7_a40 out nocopy JTF_VARCHAR2_TABLE_100
111 , p7_a41 out nocopy JTF_VARCHAR2_TABLE_500
112 , p7_a42 out nocopy JTF_VARCHAR2_TABLE_500
113 , p7_a43 out nocopy JTF_VARCHAR2_TABLE_500
114 , p7_a44 out nocopy JTF_VARCHAR2_TABLE_500
115 , p7_a45 out nocopy JTF_VARCHAR2_TABLE_500
116 , p7_a46 out nocopy JTF_VARCHAR2_TABLE_500
117 , p7_a47 out nocopy JTF_VARCHAR2_TABLE_500
118 , p7_a48 out nocopy JTF_VARCHAR2_TABLE_500
119 , p7_a49 out nocopy JTF_VARCHAR2_TABLE_500
120 , p7_a50 out nocopy JTF_VARCHAR2_TABLE_500
121 , p7_a51 out nocopy JTF_VARCHAR2_TABLE_500
122 , p7_a52 out nocopy JTF_VARCHAR2_TABLE_500
123 , p7_a53 out nocopy JTF_VARCHAR2_TABLE_500
124 , p7_a54 out nocopy JTF_VARCHAR2_TABLE_500
125 , p7_a55 out nocopy JTF_VARCHAR2_TABLE_500
126 , p7_a56 out nocopy JTF_VARCHAR2_TABLE_100
127 , p7_a57 out nocopy JTF_VARCHAR2_TABLE_100
128 , p7_a58 out nocopy JTF_VARCHAR2_TABLE_100
129 , p7_a59 out nocopy JTF_VARCHAR2_TABLE_100
130 , p7_a60 out nocopy JTF_NUMBER_TABLE
131 );
132 procedure insert_opt_rul_tmp(p_api_version NUMBER
133 , p_init_msg_list VARCHAR2
134 , x_return_status out nocopy VARCHAR2
135 , x_msg_count out nocopy NUMBER
136 , x_msg_data out nocopy VARCHAR2
137 , p_ovd_id NUMBER
138 , p7_a0 out nocopy VARCHAR2
139 , p7_a1 out nocopy NUMBER
140 , p7_a2 out nocopy NUMBER
141 , p7_a3 out nocopy VARCHAR2
142 , p7_a4 out nocopy VARCHAR2
143 , p7_a5 out nocopy VARCHAR2
144 , p7_a6 out nocopy VARCHAR2
145 , p7_a7 out nocopy VARCHAR2
146 , p7_a8 out nocopy VARCHAR2
147 , p7_a9 out nocopy VARCHAR2
148 , p7_a10 out nocopy VARCHAR2
149 , p7_a11 out nocopy VARCHAR2
150 , p7_a12 out nocopy VARCHAR2
151 , p7_a13 out nocopy NUMBER
152 , p7_a14 out nocopy NUMBER
153 , p7_a15 out nocopy NUMBER
154 , p7_a16 out nocopy VARCHAR2
155 , p7_a17 out nocopy VARCHAR2
156 , p7_a18 out nocopy VARCHAR2
157 , p7_a19 out nocopy VARCHAR2
158 , p7_a20 out nocopy VARCHAR2
159 , p7_a21 out nocopy VARCHAR2
160 , p7_a22 out nocopy VARCHAR2
161 , p7_a23 out nocopy VARCHAR2
162 , p7_a24 out nocopy VARCHAR2
163 , p7_a25 out nocopy VARCHAR2
164 , p7_a26 out nocopy VARCHAR2
165 , p7_a27 out nocopy VARCHAR2
166 , p7_a28 out nocopy VARCHAR2
167 , p7_a29 out nocopy VARCHAR2
168 , p7_a30 out nocopy VARCHAR2
169 , p7_a31 out nocopy VARCHAR2
170 , p7_a32 out nocopy VARCHAR2
171 , p7_a33 out nocopy VARCHAR2
172 , p7_a34 out nocopy VARCHAR2
173 , p7_a35 out nocopy NUMBER
174 , p7_a36 out nocopy DATE
175 , p7_a37 out nocopy NUMBER
176 , p7_a38 out nocopy DATE
177 , p7_a39 out nocopy NUMBER
178 , p7_a40 out nocopy VARCHAR2
179 , p7_a41 out nocopy VARCHAR2
180 , p7_a42 out nocopy VARCHAR2
181 , p7_a43 out nocopy VARCHAR2
182 , p7_a44 out nocopy VARCHAR2
183 , p7_a45 out nocopy VARCHAR2
184 , p7_a46 out nocopy VARCHAR2
185 , p7_a47 out nocopy VARCHAR2
186 , p7_a48 out nocopy VARCHAR2
187 , p7_a49 out nocopy VARCHAR2
188 , p7_a50 out nocopy VARCHAR2
189 , p7_a51 out nocopy VARCHAR2
190 , p7_a52 out nocopy VARCHAR2
191 , p7_a53 out nocopy VARCHAR2
192 , p7_a54 out nocopy VARCHAR2
193 , p7_a55 out nocopy VARCHAR2
194 , p7_a56 out nocopy VARCHAR2
195 , p7_a57 out nocopy VARCHAR2
196 , p7_a58 out nocopy VARCHAR2
197 , p7_a59 out nocopy VARCHAR2
198 , p7_a60 out nocopy NUMBER
199 , p6_a0 VARCHAR2 := fnd_api.g_miss_char
200 , p6_a1 NUMBER := 0-1962.0724
201 , p6_a2 NUMBER := 0-1962.0724
202 , p6_a3 VARCHAR2 := fnd_api.g_miss_char
203 , p6_a4 VARCHAR2 := fnd_api.g_miss_char
204 , p6_a5 VARCHAR2 := fnd_api.g_miss_char
205 , p6_a6 VARCHAR2 := fnd_api.g_miss_char
206 , p6_a7 VARCHAR2 := fnd_api.g_miss_char
207 , p6_a8 VARCHAR2 := fnd_api.g_miss_char
208 , p6_a9 VARCHAR2 := fnd_api.g_miss_char
209 , p6_a10 VARCHAR2 := fnd_api.g_miss_char
210 , p6_a11 VARCHAR2 := fnd_api.g_miss_char
211 , p6_a12 VARCHAR2 := fnd_api.g_miss_char
212 , p6_a13 NUMBER := 0-1962.0724
213 , p6_a14 NUMBER := 0-1962.0724
214 , p6_a15 NUMBER := 0-1962.0724
215 , p6_a16 VARCHAR2 := fnd_api.g_miss_char
216 , p6_a17 VARCHAR2 := fnd_api.g_miss_char
217 , p6_a18 VARCHAR2 := fnd_api.g_miss_char
218 , p6_a19 VARCHAR2 := fnd_api.g_miss_char
219 , p6_a20 VARCHAR2 := fnd_api.g_miss_char
220 , p6_a21 VARCHAR2 := fnd_api.g_miss_char
221 , p6_a22 VARCHAR2 := fnd_api.g_miss_char
222 , p6_a23 VARCHAR2 := fnd_api.g_miss_char
223 , p6_a24 VARCHAR2 := fnd_api.g_miss_char
224 , p6_a25 VARCHAR2 := fnd_api.g_miss_char
225 , p6_a26 VARCHAR2 := fnd_api.g_miss_char
226 , p6_a27 VARCHAR2 := fnd_api.g_miss_char
227 , p6_a28 VARCHAR2 := fnd_api.g_miss_char
228 , p6_a29 VARCHAR2 := fnd_api.g_miss_char
229 , p6_a30 VARCHAR2 := fnd_api.g_miss_char
230 , p6_a31 VARCHAR2 := fnd_api.g_miss_char
231 , p6_a32 VARCHAR2 := fnd_api.g_miss_char
232 , p6_a33 VARCHAR2 := fnd_api.g_miss_char
233 , p6_a34 VARCHAR2 := fnd_api.g_miss_char
234 , p6_a35 NUMBER := 0-1962.0724
235 , p6_a36 DATE := fnd_api.g_miss_date
236 , p6_a37 NUMBER := 0-1962.0724
237 , p6_a38 DATE := fnd_api.g_miss_date
238 , p6_a39 NUMBER := 0-1962.0724
239 , p6_a40 VARCHAR2 := fnd_api.g_miss_char
240 , p6_a41 VARCHAR2 := fnd_api.g_miss_char
241 , p6_a42 VARCHAR2 := fnd_api.g_miss_char
242 , p6_a43 VARCHAR2 := fnd_api.g_miss_char
243 , p6_a44 VARCHAR2 := fnd_api.g_miss_char
244 , p6_a45 VARCHAR2 := fnd_api.g_miss_char
245 , p6_a46 VARCHAR2 := fnd_api.g_miss_char
246 , p6_a47 VARCHAR2 := fnd_api.g_miss_char
247 , p6_a48 VARCHAR2 := fnd_api.g_miss_char
248 , p6_a49 VARCHAR2 := fnd_api.g_miss_char
249 , p6_a50 VARCHAR2 := fnd_api.g_miss_char
250 , p6_a51 VARCHAR2 := fnd_api.g_miss_char
251 , p6_a52 VARCHAR2 := fnd_api.g_miss_char
252 , p6_a53 VARCHAR2 := fnd_api.g_miss_char
253 , p6_a54 VARCHAR2 := fnd_api.g_miss_char
254 , p6_a55 VARCHAR2 := fnd_api.g_miss_char
255 , p6_a56 VARCHAR2 := fnd_api.g_miss_char
256 , p6_a57 VARCHAR2 := fnd_api.g_miss_char
257 , p6_a58 VARCHAR2 := fnd_api.g_miss_char
258 , p6_a59 VARCHAR2 := fnd_api.g_miss_char
259 , p6_a60 NUMBER := 0-1962.0724
260 );
261 procedure lock_opt_rul_tmp(p_api_version NUMBER
262 , p_init_msg_list VARCHAR2
263 , x_return_status out nocopy VARCHAR2
264 , x_msg_count out nocopy NUMBER
265 , x_msg_data out nocopy VARCHAR2
266 , p5_a0 JTF_VARCHAR2_TABLE_100
267 , p5_a1 JTF_NUMBER_TABLE
268 , p5_a2 JTF_NUMBER_TABLE
269 , p5_a3 JTF_VARCHAR2_TABLE_100
270 , p5_a4 JTF_VARCHAR2_TABLE_100
271 , p5_a5 JTF_VARCHAR2_TABLE_100
272 , p5_a6 JTF_VARCHAR2_TABLE_100
273 , p5_a7 JTF_VARCHAR2_TABLE_200
274 , p5_a8 JTF_VARCHAR2_TABLE_200
275 , p5_a9 JTF_VARCHAR2_TABLE_200
276 , p5_a10 JTF_VARCHAR2_TABLE_100
277 , p5_a11 JTF_VARCHAR2_TABLE_100
278 , p5_a12 JTF_VARCHAR2_TABLE_100
279 , p5_a13 JTF_NUMBER_TABLE
280 , p5_a14 JTF_NUMBER_TABLE
281 , p5_a15 JTF_NUMBER_TABLE
282 , p5_a16 JTF_VARCHAR2_TABLE_100
283 , p5_a17 JTF_VARCHAR2_TABLE_2000
284 , p5_a18 JTF_VARCHAR2_TABLE_100
285 , p5_a19 JTF_VARCHAR2_TABLE_100
286 , p5_a20 JTF_VARCHAR2_TABLE_500
287 , p5_a21 JTF_VARCHAR2_TABLE_500
288 , p5_a22 JTF_VARCHAR2_TABLE_500
289 , p5_a23 JTF_VARCHAR2_TABLE_500
290 , p5_a24 JTF_VARCHAR2_TABLE_500
291 , p5_a25 JTF_VARCHAR2_TABLE_500
292 , p5_a26 JTF_VARCHAR2_TABLE_500
293 , p5_a27 JTF_VARCHAR2_TABLE_500
294 , p5_a28 JTF_VARCHAR2_TABLE_500
295 , p5_a29 JTF_VARCHAR2_TABLE_500
296 , p5_a30 JTF_VARCHAR2_TABLE_500
297 , p5_a31 JTF_VARCHAR2_TABLE_500
298 , p5_a32 JTF_VARCHAR2_TABLE_500
299 , p5_a33 JTF_VARCHAR2_TABLE_500
300 , p5_a34 JTF_VARCHAR2_TABLE_500
301 , p5_a35 JTF_NUMBER_TABLE
302 , p5_a36 JTF_DATE_TABLE
303 , p5_a37 JTF_NUMBER_TABLE
304 , p5_a38 JTF_DATE_TABLE
305 , p5_a39 JTF_NUMBER_TABLE
306 , p5_a40 JTF_VARCHAR2_TABLE_100
307 , p5_a41 JTF_VARCHAR2_TABLE_500
308 , p5_a42 JTF_VARCHAR2_TABLE_500
309 , p5_a43 JTF_VARCHAR2_TABLE_500
310 , p5_a44 JTF_VARCHAR2_TABLE_500
311 , p5_a45 JTF_VARCHAR2_TABLE_500
312 , p5_a46 JTF_VARCHAR2_TABLE_500
313 , p5_a47 JTF_VARCHAR2_TABLE_500
314 , p5_a48 JTF_VARCHAR2_TABLE_500
315 , p5_a49 JTF_VARCHAR2_TABLE_500
316 , p5_a50 JTF_VARCHAR2_TABLE_500
317 , p5_a51 JTF_VARCHAR2_TABLE_500
318 , p5_a52 JTF_VARCHAR2_TABLE_500
319 , p5_a53 JTF_VARCHAR2_TABLE_500
320 , p5_a54 JTF_VARCHAR2_TABLE_500
321 , p5_a55 JTF_VARCHAR2_TABLE_500
322 , p5_a56 JTF_VARCHAR2_TABLE_100
323 , p5_a57 JTF_VARCHAR2_TABLE_100
324 , p5_a58 JTF_VARCHAR2_TABLE_100
325 , p5_a59 JTF_VARCHAR2_TABLE_100
326 , p5_a60 JTF_NUMBER_TABLE
327 );
328 procedure lock_opt_rul_tmp(p_api_version NUMBER
329 , p_init_msg_list VARCHAR2
330 , x_return_status out nocopy VARCHAR2
331 , x_msg_count out nocopy NUMBER
332 , x_msg_data out nocopy VARCHAR2
333 , p5_a0 VARCHAR2 := fnd_api.g_miss_char
334 , p5_a1 NUMBER := 0-1962.0724
335 , p5_a2 NUMBER := 0-1962.0724
336 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
337 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
338 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
339 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
340 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
341 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
342 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
343 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
344 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
345 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
346 , p5_a13 NUMBER := 0-1962.0724
347 , p5_a14 NUMBER := 0-1962.0724
348 , p5_a15 NUMBER := 0-1962.0724
349 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
350 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
351 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
352 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
353 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
354 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
355 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
356 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
357 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
358 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
359 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
360 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
361 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
362 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
363 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
364 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
365 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
366 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
367 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
368 , p5_a35 NUMBER := 0-1962.0724
369 , p5_a36 DATE := fnd_api.g_miss_date
370 , p5_a37 NUMBER := 0-1962.0724
371 , p5_a38 DATE := fnd_api.g_miss_date
372 , p5_a39 NUMBER := 0-1962.0724
373 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
374 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
375 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
376 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
377 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
378 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
379 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
380 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
381 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
382 , p5_a49 VARCHAR2 := fnd_api.g_miss_char
383 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
384 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
385 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
386 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
387 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
388 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
389 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
390 , p5_a57 VARCHAR2 := fnd_api.g_miss_char
391 , p5_a58 VARCHAR2 := fnd_api.g_miss_char
392 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
393 , p5_a60 NUMBER := 0-1962.0724
394 );
395 procedure update_opt_rul_tmp(p_api_version NUMBER
396 , p_init_msg_list VARCHAR2
397 , x_return_status out nocopy VARCHAR2
398 , x_msg_count out nocopy NUMBER
399 , x_msg_data out nocopy VARCHAR2
400 , p5_a0 JTF_VARCHAR2_TABLE_100
401 , p5_a1 JTF_NUMBER_TABLE
402 , p5_a2 JTF_NUMBER_TABLE
403 , p5_a3 JTF_VARCHAR2_TABLE_100
404 , p5_a4 JTF_VARCHAR2_TABLE_100
405 , p5_a5 JTF_VARCHAR2_TABLE_100
406 , p5_a6 JTF_VARCHAR2_TABLE_100
407 , p5_a7 JTF_VARCHAR2_TABLE_200
408 , p5_a8 JTF_VARCHAR2_TABLE_200
409 , p5_a9 JTF_VARCHAR2_TABLE_200
410 , p5_a10 JTF_VARCHAR2_TABLE_100
411 , p5_a11 JTF_VARCHAR2_TABLE_100
412 , p5_a12 JTF_VARCHAR2_TABLE_100
413 , p5_a13 JTF_NUMBER_TABLE
414 , p5_a14 JTF_NUMBER_TABLE
415 , p5_a15 JTF_NUMBER_TABLE
416 , p5_a16 JTF_VARCHAR2_TABLE_100
417 , p5_a17 JTF_VARCHAR2_TABLE_2000
418 , p5_a18 JTF_VARCHAR2_TABLE_100
419 , p5_a19 JTF_VARCHAR2_TABLE_100
420 , p5_a20 JTF_VARCHAR2_TABLE_500
421 , p5_a21 JTF_VARCHAR2_TABLE_500
422 , p5_a22 JTF_VARCHAR2_TABLE_500
423 , p5_a23 JTF_VARCHAR2_TABLE_500
424 , p5_a24 JTF_VARCHAR2_TABLE_500
425 , p5_a25 JTF_VARCHAR2_TABLE_500
426 , p5_a26 JTF_VARCHAR2_TABLE_500
427 , p5_a27 JTF_VARCHAR2_TABLE_500
428 , p5_a28 JTF_VARCHAR2_TABLE_500
429 , p5_a29 JTF_VARCHAR2_TABLE_500
430 , p5_a30 JTF_VARCHAR2_TABLE_500
431 , p5_a31 JTF_VARCHAR2_TABLE_500
432 , p5_a32 JTF_VARCHAR2_TABLE_500
433 , p5_a33 JTF_VARCHAR2_TABLE_500
434 , p5_a34 JTF_VARCHAR2_TABLE_500
435 , p5_a35 JTF_NUMBER_TABLE
436 , p5_a36 JTF_DATE_TABLE
437 , p5_a37 JTF_NUMBER_TABLE
438 , p5_a38 JTF_DATE_TABLE
439 , p5_a39 JTF_NUMBER_TABLE
440 , p5_a40 JTF_VARCHAR2_TABLE_100
441 , p5_a41 JTF_VARCHAR2_TABLE_500
442 , p5_a42 JTF_VARCHAR2_TABLE_500
443 , p5_a43 JTF_VARCHAR2_TABLE_500
444 , p5_a44 JTF_VARCHAR2_TABLE_500
445 , p5_a45 JTF_VARCHAR2_TABLE_500
446 , p5_a46 JTF_VARCHAR2_TABLE_500
447 , p5_a47 JTF_VARCHAR2_TABLE_500
448 , p5_a48 JTF_VARCHAR2_TABLE_500
449 , p5_a49 JTF_VARCHAR2_TABLE_500
450 , p5_a50 JTF_VARCHAR2_TABLE_500
451 , p5_a51 JTF_VARCHAR2_TABLE_500
452 , p5_a52 JTF_VARCHAR2_TABLE_500
453 , p5_a53 JTF_VARCHAR2_TABLE_500
454 , p5_a54 JTF_VARCHAR2_TABLE_500
455 , p5_a55 JTF_VARCHAR2_TABLE_500
456 , p5_a56 JTF_VARCHAR2_TABLE_100
457 , p5_a57 JTF_VARCHAR2_TABLE_100
458 , p5_a58 JTF_VARCHAR2_TABLE_100
459 , p5_a59 JTF_VARCHAR2_TABLE_100
460 , p5_a60 JTF_NUMBER_TABLE
461 , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
462 , p6_a1 out nocopy JTF_NUMBER_TABLE
463 , p6_a2 out nocopy JTF_NUMBER_TABLE
464 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
465 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
466 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
467 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
468 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
469 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
470 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_200
471 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
472 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
473 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
474 , p6_a13 out nocopy JTF_NUMBER_TABLE
475 , p6_a14 out nocopy JTF_NUMBER_TABLE
476 , p6_a15 out nocopy JTF_NUMBER_TABLE
477 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
478 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_2000
479 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
480 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
481 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
482 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
483 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
484 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
485 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
486 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
487 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
488 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
489 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
490 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
491 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
492 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
493 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
494 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
495 , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
496 , p6_a35 out nocopy JTF_NUMBER_TABLE
497 , p6_a36 out nocopy JTF_DATE_TABLE
498 , p6_a37 out nocopy JTF_NUMBER_TABLE
499 , p6_a38 out nocopy JTF_DATE_TABLE
500 , p6_a39 out nocopy JTF_NUMBER_TABLE
501 , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
502 , p6_a41 out nocopy JTF_VARCHAR2_TABLE_500
503 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_500
504 , p6_a43 out nocopy JTF_VARCHAR2_TABLE_500
505 , p6_a44 out nocopy JTF_VARCHAR2_TABLE_500
506 , p6_a45 out nocopy JTF_VARCHAR2_TABLE_500
507 , p6_a46 out nocopy JTF_VARCHAR2_TABLE_500
508 , p6_a47 out nocopy JTF_VARCHAR2_TABLE_500
509 , p6_a48 out nocopy JTF_VARCHAR2_TABLE_500
510 , p6_a49 out nocopy JTF_VARCHAR2_TABLE_500
511 , p6_a50 out nocopy JTF_VARCHAR2_TABLE_500
512 , p6_a51 out nocopy JTF_VARCHAR2_TABLE_500
513 , p6_a52 out nocopy JTF_VARCHAR2_TABLE_500
514 , p6_a53 out nocopy JTF_VARCHAR2_TABLE_500
515 , p6_a54 out nocopy JTF_VARCHAR2_TABLE_500
516 , p6_a55 out nocopy JTF_VARCHAR2_TABLE_500
517 , p6_a56 out nocopy JTF_VARCHAR2_TABLE_100
518 , p6_a57 out nocopy JTF_VARCHAR2_TABLE_100
519 , p6_a58 out nocopy JTF_VARCHAR2_TABLE_100
520 , p6_a59 out nocopy JTF_VARCHAR2_TABLE_100
521 , p6_a60 out nocopy JTF_NUMBER_TABLE
522 );
523 procedure update_opt_rul_tmp(p_api_version NUMBER
524 , p_init_msg_list VARCHAR2
525 , x_return_status out nocopy VARCHAR2
526 , x_msg_count out nocopy NUMBER
527 , x_msg_data out nocopy VARCHAR2
528 , p6_a0 out nocopy VARCHAR2
529 , p6_a1 out nocopy NUMBER
530 , p6_a2 out nocopy NUMBER
531 , p6_a3 out nocopy VARCHAR2
532 , p6_a4 out nocopy VARCHAR2
533 , p6_a5 out nocopy VARCHAR2
534 , p6_a6 out nocopy VARCHAR2
535 , p6_a7 out nocopy VARCHAR2
536 , p6_a8 out nocopy VARCHAR2
537 , p6_a9 out nocopy VARCHAR2
538 , p6_a10 out nocopy VARCHAR2
539 , p6_a11 out nocopy VARCHAR2
540 , p6_a12 out nocopy VARCHAR2
541 , p6_a13 out nocopy NUMBER
542 , p6_a14 out nocopy NUMBER
543 , p6_a15 out nocopy NUMBER
544 , p6_a16 out nocopy VARCHAR2
545 , p6_a17 out nocopy VARCHAR2
546 , p6_a18 out nocopy VARCHAR2
547 , p6_a19 out nocopy VARCHAR2
548 , p6_a20 out nocopy VARCHAR2
549 , p6_a21 out nocopy VARCHAR2
550 , p6_a22 out nocopy VARCHAR2
551 , p6_a23 out nocopy VARCHAR2
552 , p6_a24 out nocopy VARCHAR2
553 , p6_a25 out nocopy VARCHAR2
554 , p6_a26 out nocopy VARCHAR2
555 , p6_a27 out nocopy VARCHAR2
556 , p6_a28 out nocopy VARCHAR2
557 , p6_a29 out nocopy VARCHAR2
558 , p6_a30 out nocopy VARCHAR2
559 , p6_a31 out nocopy VARCHAR2
560 , p6_a32 out nocopy VARCHAR2
561 , p6_a33 out nocopy VARCHAR2
562 , p6_a34 out nocopy VARCHAR2
563 , p6_a35 out nocopy NUMBER
564 , p6_a36 out nocopy DATE
565 , p6_a37 out nocopy NUMBER
566 , p6_a38 out nocopy DATE
567 , p6_a39 out nocopy NUMBER
568 , p6_a40 out nocopy VARCHAR2
569 , p6_a41 out nocopy VARCHAR2
570 , p6_a42 out nocopy VARCHAR2
571 , p6_a43 out nocopy VARCHAR2
572 , p6_a44 out nocopy VARCHAR2
573 , p6_a45 out nocopy VARCHAR2
574 , p6_a46 out nocopy VARCHAR2
575 , p6_a47 out nocopy VARCHAR2
576 , p6_a48 out nocopy VARCHAR2
577 , p6_a49 out nocopy VARCHAR2
578 , p6_a50 out nocopy VARCHAR2
579 , p6_a51 out nocopy VARCHAR2
580 , p6_a52 out nocopy VARCHAR2
581 , p6_a53 out nocopy VARCHAR2
582 , p6_a54 out nocopy VARCHAR2
583 , p6_a55 out nocopy VARCHAR2
584 , p6_a56 out nocopy VARCHAR2
585 , p6_a57 out nocopy VARCHAR2
586 , p6_a58 out nocopy VARCHAR2
587 , p6_a59 out nocopy VARCHAR2
588 , p6_a60 out nocopy NUMBER
589 , p5_a0 VARCHAR2 := fnd_api.g_miss_char
590 , p5_a1 NUMBER := 0-1962.0724
591 , p5_a2 NUMBER := 0-1962.0724
592 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
593 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
594 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
595 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
596 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
597 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
598 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
599 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
600 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
601 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
602 , p5_a13 NUMBER := 0-1962.0724
603 , p5_a14 NUMBER := 0-1962.0724
604 , p5_a15 NUMBER := 0-1962.0724
605 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
606 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
607 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
608 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
609 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
610 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
611 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
612 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
613 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
614 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
615 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
616 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
617 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
618 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
619 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
620 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
621 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
622 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
623 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
624 , p5_a35 NUMBER := 0-1962.0724
625 , p5_a36 DATE := fnd_api.g_miss_date
626 , p5_a37 NUMBER := 0-1962.0724
627 , p5_a38 DATE := fnd_api.g_miss_date
628 , p5_a39 NUMBER := 0-1962.0724
629 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
630 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
631 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
632 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
633 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
634 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
635 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
636 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
637 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
638 , p5_a49 VARCHAR2 := fnd_api.g_miss_char
639 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
640 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
641 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
642 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
643 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
644 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
645 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
646 , p5_a57 VARCHAR2 := fnd_api.g_miss_char
647 , p5_a58 VARCHAR2 := fnd_api.g_miss_char
648 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
649 , p5_a60 NUMBER := 0-1962.0724
650 );
651 procedure delete_opt_rul_tmp(p_api_version NUMBER
652 , p_init_msg_list VARCHAR2
653 , x_return_status out nocopy VARCHAR2
654 , x_msg_count out nocopy NUMBER
655 , x_msg_data out nocopy VARCHAR2
656 , p5_a0 JTF_VARCHAR2_TABLE_100
657 , p5_a1 JTF_NUMBER_TABLE
658 , p5_a2 JTF_NUMBER_TABLE
659 , p5_a3 JTF_VARCHAR2_TABLE_100
660 , p5_a4 JTF_VARCHAR2_TABLE_100
661 , p5_a5 JTF_VARCHAR2_TABLE_100
662 , p5_a6 JTF_VARCHAR2_TABLE_100
663 , p5_a7 JTF_VARCHAR2_TABLE_200
664 , p5_a8 JTF_VARCHAR2_TABLE_200
665 , p5_a9 JTF_VARCHAR2_TABLE_200
666 , p5_a10 JTF_VARCHAR2_TABLE_100
667 , p5_a11 JTF_VARCHAR2_TABLE_100
668 , p5_a12 JTF_VARCHAR2_TABLE_100
669 , p5_a13 JTF_NUMBER_TABLE
670 , p5_a14 JTF_NUMBER_TABLE
671 , p5_a15 JTF_NUMBER_TABLE
672 , p5_a16 JTF_VARCHAR2_TABLE_100
673 , p5_a17 JTF_VARCHAR2_TABLE_2000
674 , p5_a18 JTF_VARCHAR2_TABLE_100
675 , p5_a19 JTF_VARCHAR2_TABLE_100
676 , p5_a20 JTF_VARCHAR2_TABLE_500
677 , p5_a21 JTF_VARCHAR2_TABLE_500
678 , p5_a22 JTF_VARCHAR2_TABLE_500
679 , p5_a23 JTF_VARCHAR2_TABLE_500
680 , p5_a24 JTF_VARCHAR2_TABLE_500
681 , p5_a25 JTF_VARCHAR2_TABLE_500
682 , p5_a26 JTF_VARCHAR2_TABLE_500
683 , p5_a27 JTF_VARCHAR2_TABLE_500
684 , p5_a28 JTF_VARCHAR2_TABLE_500
685 , p5_a29 JTF_VARCHAR2_TABLE_500
686 , p5_a30 JTF_VARCHAR2_TABLE_500
687 , p5_a31 JTF_VARCHAR2_TABLE_500
688 , p5_a32 JTF_VARCHAR2_TABLE_500
689 , p5_a33 JTF_VARCHAR2_TABLE_500
690 , p5_a34 JTF_VARCHAR2_TABLE_500
691 , p5_a35 JTF_NUMBER_TABLE
692 , p5_a36 JTF_DATE_TABLE
693 , p5_a37 JTF_NUMBER_TABLE
694 , p5_a38 JTF_DATE_TABLE
695 , p5_a39 JTF_NUMBER_TABLE
696 , p5_a40 JTF_VARCHAR2_TABLE_100
697 , p5_a41 JTF_VARCHAR2_TABLE_500
698 , p5_a42 JTF_VARCHAR2_TABLE_500
699 , p5_a43 JTF_VARCHAR2_TABLE_500
700 , p5_a44 JTF_VARCHAR2_TABLE_500
701 , p5_a45 JTF_VARCHAR2_TABLE_500
702 , p5_a46 JTF_VARCHAR2_TABLE_500
703 , p5_a47 JTF_VARCHAR2_TABLE_500
704 , p5_a48 JTF_VARCHAR2_TABLE_500
705 , p5_a49 JTF_VARCHAR2_TABLE_500
706 , p5_a50 JTF_VARCHAR2_TABLE_500
707 , p5_a51 JTF_VARCHAR2_TABLE_500
708 , p5_a52 JTF_VARCHAR2_TABLE_500
709 , p5_a53 JTF_VARCHAR2_TABLE_500
710 , p5_a54 JTF_VARCHAR2_TABLE_500
711 , p5_a55 JTF_VARCHAR2_TABLE_500
712 , p5_a56 JTF_VARCHAR2_TABLE_100
713 , p5_a57 JTF_VARCHAR2_TABLE_100
714 , p5_a58 JTF_VARCHAR2_TABLE_100
715 , p5_a59 JTF_VARCHAR2_TABLE_100
716 , p5_a60 JTF_NUMBER_TABLE
717 );
718 procedure delete_opt_rul_tmp(p_api_version NUMBER
719 , p_init_msg_list VARCHAR2
720 , x_return_status out nocopy VARCHAR2
721 , x_msg_count out nocopy NUMBER
722 , x_msg_data out nocopy VARCHAR2
723 , p5_a0 VARCHAR2 := fnd_api.g_miss_char
724 , p5_a1 NUMBER := 0-1962.0724
725 , p5_a2 NUMBER := 0-1962.0724
726 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
727 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
728 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
729 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
730 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
731 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
732 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
733 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
734 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
735 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
736 , p5_a13 NUMBER := 0-1962.0724
737 , p5_a14 NUMBER := 0-1962.0724
738 , p5_a15 NUMBER := 0-1962.0724
739 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
740 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
741 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
742 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
743 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
744 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
745 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
746 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
747 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
748 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
749 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
750 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
751 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
752 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
753 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
754 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
755 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
756 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
757 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
758 , p5_a35 NUMBER := 0-1962.0724
759 , p5_a36 DATE := fnd_api.g_miss_date
760 , p5_a37 NUMBER := 0-1962.0724
761 , p5_a38 DATE := fnd_api.g_miss_date
762 , p5_a39 NUMBER := 0-1962.0724
763 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
764 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
765 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
766 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
767 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
768 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
769 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
770 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
771 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
772 , p5_a49 VARCHAR2 := fnd_api.g_miss_char
773 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
774 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
775 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
776 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
777 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
778 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
779 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
780 , p5_a57 VARCHAR2 := fnd_api.g_miss_char
781 , p5_a58 VARCHAR2 := fnd_api.g_miss_char
782 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
783 , p5_a60 NUMBER := 0-1962.0724
784 );
785 procedure validate_opt_rul_tmp(p_api_version NUMBER
786 , p_init_msg_list VARCHAR2
787 , x_return_status out nocopy VARCHAR2
788 , x_msg_count out nocopy NUMBER
789 , x_msg_data out nocopy VARCHAR2
790 , p5_a0 JTF_VARCHAR2_TABLE_100
791 , p5_a1 JTF_NUMBER_TABLE
792 , p5_a2 JTF_NUMBER_TABLE
793 , p5_a3 JTF_VARCHAR2_TABLE_100
794 , p5_a4 JTF_VARCHAR2_TABLE_100
795 , p5_a5 JTF_VARCHAR2_TABLE_100
796 , p5_a6 JTF_VARCHAR2_TABLE_100
797 , p5_a7 JTF_VARCHAR2_TABLE_200
798 , p5_a8 JTF_VARCHAR2_TABLE_200
799 , p5_a9 JTF_VARCHAR2_TABLE_200
800 , p5_a10 JTF_VARCHAR2_TABLE_100
801 , p5_a11 JTF_VARCHAR2_TABLE_100
802 , p5_a12 JTF_VARCHAR2_TABLE_100
803 , p5_a13 JTF_NUMBER_TABLE
804 , p5_a14 JTF_NUMBER_TABLE
805 , p5_a15 JTF_NUMBER_TABLE
806 , p5_a16 JTF_VARCHAR2_TABLE_100
807 , p5_a17 JTF_VARCHAR2_TABLE_2000
808 , p5_a18 JTF_VARCHAR2_TABLE_100
809 , p5_a19 JTF_VARCHAR2_TABLE_100
810 , p5_a20 JTF_VARCHAR2_TABLE_500
811 , p5_a21 JTF_VARCHAR2_TABLE_500
812 , p5_a22 JTF_VARCHAR2_TABLE_500
813 , p5_a23 JTF_VARCHAR2_TABLE_500
814 , p5_a24 JTF_VARCHAR2_TABLE_500
815 , p5_a25 JTF_VARCHAR2_TABLE_500
816 , p5_a26 JTF_VARCHAR2_TABLE_500
817 , p5_a27 JTF_VARCHAR2_TABLE_500
818 , p5_a28 JTF_VARCHAR2_TABLE_500
819 , p5_a29 JTF_VARCHAR2_TABLE_500
820 , p5_a30 JTF_VARCHAR2_TABLE_500
821 , p5_a31 JTF_VARCHAR2_TABLE_500
822 , p5_a32 JTF_VARCHAR2_TABLE_500
823 , p5_a33 JTF_VARCHAR2_TABLE_500
824 , p5_a34 JTF_VARCHAR2_TABLE_500
825 , p5_a35 JTF_NUMBER_TABLE
826 , p5_a36 JTF_DATE_TABLE
827 , p5_a37 JTF_NUMBER_TABLE
828 , p5_a38 JTF_DATE_TABLE
829 , p5_a39 JTF_NUMBER_TABLE
830 , p5_a40 JTF_VARCHAR2_TABLE_100
831 , p5_a41 JTF_VARCHAR2_TABLE_500
832 , p5_a42 JTF_VARCHAR2_TABLE_500
833 , p5_a43 JTF_VARCHAR2_TABLE_500
834 , p5_a44 JTF_VARCHAR2_TABLE_500
835 , p5_a45 JTF_VARCHAR2_TABLE_500
836 , p5_a46 JTF_VARCHAR2_TABLE_500
837 , p5_a47 JTF_VARCHAR2_TABLE_500
838 , p5_a48 JTF_VARCHAR2_TABLE_500
839 , p5_a49 JTF_VARCHAR2_TABLE_500
840 , p5_a50 JTF_VARCHAR2_TABLE_500
841 , p5_a51 JTF_VARCHAR2_TABLE_500
842 , p5_a52 JTF_VARCHAR2_TABLE_500
843 , p5_a53 JTF_VARCHAR2_TABLE_500
844 , p5_a54 JTF_VARCHAR2_TABLE_500
845 , p5_a55 JTF_VARCHAR2_TABLE_500
846 , p5_a56 JTF_VARCHAR2_TABLE_100
847 , p5_a57 JTF_VARCHAR2_TABLE_100
848 , p5_a58 JTF_VARCHAR2_TABLE_100
849 , p5_a59 JTF_VARCHAR2_TABLE_100
850 , p5_a60 JTF_NUMBER_TABLE
851 );
852 procedure validate_opt_rul_tmp(p_api_version NUMBER
853 , p_init_msg_list VARCHAR2
854 , x_return_status out nocopy VARCHAR2
855 , x_msg_count out nocopy NUMBER
856 , x_msg_data out nocopy VARCHAR2
857 , p5_a0 VARCHAR2 := fnd_api.g_miss_char
858 , p5_a1 NUMBER := 0-1962.0724
859 , p5_a2 NUMBER := 0-1962.0724
860 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
861 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
862 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
863 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
864 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
865 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
866 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
867 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
868 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
869 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
870 , p5_a13 NUMBER := 0-1962.0724
871 , p5_a14 NUMBER := 0-1962.0724
872 , p5_a15 NUMBER := 0-1962.0724
873 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
874 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
875 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
876 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
877 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
878 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
879 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
880 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
881 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
882 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
883 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
884 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
885 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
886 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
887 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
888 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
889 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
890 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
891 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
892 , p5_a35 NUMBER := 0-1962.0724
893 , p5_a36 DATE := fnd_api.g_miss_date
894 , p5_a37 NUMBER := 0-1962.0724
895 , p5_a38 DATE := fnd_api.g_miss_date
896 , p5_a39 NUMBER := 0-1962.0724
897 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
898 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
899 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
900 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
901 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
902 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
903 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
904 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
905 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
906 , p5_a49 VARCHAR2 := fnd_api.g_miss_char
907 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
908 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
909 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
910 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
911 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
912 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
913 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
914 , p5_a57 VARCHAR2 := fnd_api.g_miss_char
915 , p5_a58 VARCHAR2 := fnd_api.g_miss_char
916 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
917 , p5_a60 NUMBER := 0-1962.0724
918 );
919 end okl_opt_rul_tmp_pub_w;