[Home] [Help]
PACKAGE: APPS.OKL_POOL_PVT_W
Source
1 package okl_pool_pvt_w AUTHID CURRENT_USER as
2 /* $Header: OKLESZPS.pls 120.5 2007/12/14 11:10:47 ssdeshpa noship $ */
3 procedure rosetta_table_copy_in_p46(t out nocopy okl_pool_pvt.polsrch_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_VARCHAR2_TABLE_400
5 , a2 JTF_VARCHAR2_TABLE_100
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_VARCHAR2_TABLE_200
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_VARCHAR2_TABLE_100
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_DATE_TABLE
13 , a10 JTF_DATE_TABLE
14 , a11 JTF_DATE_TABLE
15 , a12 JTF_DATE_TABLE
16 , a13 JTF_NUMBER_TABLE
17 , a14 JTF_VARCHAR2_TABLE_100
18 , a15 JTF_VARCHAR2_TABLE_500
19 , a16 JTF_NUMBER_TABLE
20 , a17 JTF_NUMBER_TABLE
21 , a18 JTF_VARCHAR2_TABLE_100
22 , a19 JTF_VARCHAR2_TABLE_100
23 , a20 JTF_VARCHAR2_TABLE_100
24 , a21 JTF_NUMBER_TABLE
25 , a22 JTF_NUMBER_TABLE
26 , a23 JTF_NUMBER_TABLE
27 , a24 JTF_NUMBER_TABLE
28 , a25 JTF_NUMBER_TABLE
29 , a26 JTF_NUMBER_TABLE
30 , a27 JTF_NUMBER_TABLE
31 , a28 JTF_VARCHAR2_TABLE_200
32 , a29 JTF_VARCHAR2_TABLE_200
33 , a30 JTF_VARCHAR2_TABLE_100
34 , a31 JTF_VARCHAR2_TABLE_100
35 , a32 JTF_DATE_TABLE
36 , a33 JTF_DATE_TABLE
37 , a34 JTF_NUMBER_TABLE
38 , a35 JTF_NUMBER_TABLE
39 , a36 JTF_DATE_TABLE
40 , a37 JTF_DATE_TABLE
41 , a38 JTF_VARCHAR2_TABLE_100
42 , a39 JTF_VARCHAR2_TABLE_100
43 );
44 procedure rosetta_table_copy_out_p46(t okl_pool_pvt.polsrch_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45 , a1 out nocopy JTF_VARCHAR2_TABLE_400
46 , a2 out nocopy JTF_VARCHAR2_TABLE_100
47 , a3 out nocopy JTF_NUMBER_TABLE
48 , a4 out nocopy JTF_VARCHAR2_TABLE_200
49 , a5 out nocopy JTF_NUMBER_TABLE
50 , a6 out nocopy JTF_NUMBER_TABLE
51 , a7 out nocopy JTF_VARCHAR2_TABLE_100
52 , a8 out nocopy JTF_NUMBER_TABLE
53 , a9 out nocopy JTF_DATE_TABLE
54 , a10 out nocopy JTF_DATE_TABLE
55 , a11 out nocopy JTF_DATE_TABLE
56 , a12 out nocopy JTF_DATE_TABLE
57 , a13 out nocopy JTF_NUMBER_TABLE
58 , a14 out nocopy JTF_VARCHAR2_TABLE_100
59 , a15 out nocopy JTF_VARCHAR2_TABLE_500
60 , a16 out nocopy JTF_NUMBER_TABLE
61 , a17 out nocopy JTF_NUMBER_TABLE
62 , a18 out nocopy JTF_VARCHAR2_TABLE_100
63 , a19 out nocopy JTF_VARCHAR2_TABLE_100
64 , a20 out nocopy JTF_VARCHAR2_TABLE_100
65 , a21 out nocopy JTF_NUMBER_TABLE
66 , a22 out nocopy JTF_NUMBER_TABLE
67 , a23 out nocopy JTF_NUMBER_TABLE
68 , a24 out nocopy JTF_NUMBER_TABLE
69 , a25 out nocopy JTF_NUMBER_TABLE
70 , a26 out nocopy JTF_NUMBER_TABLE
71 , a27 out nocopy JTF_NUMBER_TABLE
72 , a28 out nocopy JTF_VARCHAR2_TABLE_200
73 , a29 out nocopy JTF_VARCHAR2_TABLE_200
74 , a30 out nocopy JTF_VARCHAR2_TABLE_100
75 , a31 out nocopy JTF_VARCHAR2_TABLE_100
76 , a32 out nocopy JTF_DATE_TABLE
77 , a33 out nocopy JTF_DATE_TABLE
78 , a34 out nocopy JTF_NUMBER_TABLE
79 , a35 out nocopy JTF_NUMBER_TABLE
80 , a36 out nocopy JTF_DATE_TABLE
81 , a37 out nocopy JTF_DATE_TABLE
82 , a38 out nocopy JTF_VARCHAR2_TABLE_100
83 , a39 out nocopy JTF_VARCHAR2_TABLE_100
84 );
85
86 procedure rosetta_table_copy_in_p48(t out nocopy okl_pool_pvt.poc_uv_tbl_type, a0 JTF_NUMBER_TABLE
87 , a1 JTF_VARCHAR2_TABLE_200
88 , a2 JTF_VARCHAR2_TABLE_200
89 , a3 JTF_VARCHAR2_TABLE_400
90 , a4 JTF_VARCHAR2_TABLE_200
91 , a5 JTF_NUMBER_TABLE
92 , a6 JTF_VARCHAR2_TABLE_100
93 , a7 JTF_VARCHAR2_TABLE_100
94 , a8 JTF_VARCHAR2_TABLE_100
95 );
96 procedure rosetta_table_copy_out_p48(t okl_pool_pvt.poc_uv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
97 , a1 out nocopy JTF_VARCHAR2_TABLE_200
98 , a2 out nocopy JTF_VARCHAR2_TABLE_200
99 , a3 out nocopy JTF_VARCHAR2_TABLE_400
100 , a4 out nocopy JTF_VARCHAR2_TABLE_200
101 , a5 out nocopy JTF_NUMBER_TABLE
102 , a6 out nocopy JTF_VARCHAR2_TABLE_100
103 , a7 out nocopy JTF_VARCHAR2_TABLE_100
104 , a8 out nocopy JTF_VARCHAR2_TABLE_100
105 );
106
107 procedure create_pool(p_api_version NUMBER
108 , p_init_msg_list VARCHAR2
109 , x_return_status out nocopy VARCHAR2
110 , x_msg_count out nocopy NUMBER
111 , x_msg_data out nocopy VARCHAR2
112 , p6_a0 out nocopy NUMBER
113 , p6_a1 out nocopy NUMBER
114 , p6_a2 out nocopy NUMBER
115 , p6_a3 out nocopy NUMBER
116 , p6_a4 out nocopy VARCHAR2
117 , p6_a5 out nocopy VARCHAR2
118 , p6_a6 out nocopy VARCHAR2
119 , p6_a7 out nocopy VARCHAR2
120 , p6_a8 out nocopy NUMBER
121 , p6_a9 out nocopy NUMBER
122 , p6_a10 out nocopy VARCHAR2
123 , p6_a11 out nocopy DATE
124 , p6_a12 out nocopy DATE
125 , p6_a13 out nocopy DATE
126 , p6_a14 out nocopy DATE
127 , p6_a15 out nocopy VARCHAR2
128 , p6_a16 out nocopy VARCHAR2
129 , p6_a17 out nocopy VARCHAR2
130 , p6_a18 out nocopy VARCHAR2
131 , p6_a19 out nocopy VARCHAR2
132 , p6_a20 out nocopy VARCHAR2
133 , p6_a21 out nocopy VARCHAR2
134 , p6_a22 out nocopy VARCHAR2
135 , p6_a23 out nocopy VARCHAR2
136 , p6_a24 out nocopy VARCHAR2
137 , p6_a25 out nocopy VARCHAR2
138 , p6_a26 out nocopy VARCHAR2
139 , p6_a27 out nocopy VARCHAR2
140 , p6_a28 out nocopy VARCHAR2
141 , p6_a29 out nocopy VARCHAR2
142 , p6_a30 out nocopy VARCHAR2
143 , p6_a31 out nocopy VARCHAR2
144 , p6_a32 out nocopy VARCHAR2
145 , p6_a33 out nocopy NUMBER
146 , p6_a34 out nocopy NUMBER
147 , p6_a35 out nocopy NUMBER
148 , p6_a36 out nocopy NUMBER
149 , p6_a37 out nocopy DATE
150 , p6_a38 out nocopy NUMBER
151 , p6_a39 out nocopy DATE
152 , p6_a40 out nocopy NUMBER
153 , p6_a41 out nocopy DATE
154 , p6_a42 out nocopy NUMBER
155 , p6_a43 out nocopy NUMBER
156 , p5_a0 NUMBER := 0-1962.0724
157 , p5_a1 NUMBER := 0-1962.0724
158 , p5_a2 NUMBER := 0-1962.0724
159 , p5_a3 NUMBER := 0-1962.0724
160 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
161 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
162 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
163 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
164 , p5_a8 NUMBER := 0-1962.0724
165 , p5_a9 NUMBER := 0-1962.0724
166 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
167 , p5_a11 DATE := fnd_api.g_miss_date
168 , p5_a12 DATE := fnd_api.g_miss_date
169 , p5_a13 DATE := fnd_api.g_miss_date
170 , p5_a14 DATE := fnd_api.g_miss_date
171 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
172 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
173 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
174 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
175 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
176 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
177 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
178 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
179 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
180 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
181 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
182 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
183 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
184 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
185 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
186 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
187 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
188 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
189 , p5_a33 NUMBER := 0-1962.0724
190 , p5_a34 NUMBER := 0-1962.0724
191 , p5_a35 NUMBER := 0-1962.0724
192 , p5_a36 NUMBER := 0-1962.0724
193 , p5_a37 DATE := fnd_api.g_miss_date
194 , p5_a38 NUMBER := 0-1962.0724
195 , p5_a39 DATE := fnd_api.g_miss_date
196 , p5_a40 NUMBER := 0-1962.0724
197 , p5_a41 DATE := fnd_api.g_miss_date
198 , p5_a42 NUMBER := 0-1962.0724
199 , p5_a43 NUMBER := 0-1962.0724
200 );
201 procedure update_pool(p_api_version NUMBER
202 , p_init_msg_list VARCHAR2
203 , x_return_status out nocopy VARCHAR2
204 , x_msg_count out nocopy NUMBER
205 , x_msg_data out nocopy VARCHAR2
206 , p6_a0 out nocopy NUMBER
207 , p6_a1 out nocopy NUMBER
208 , p6_a2 out nocopy NUMBER
209 , p6_a3 out nocopy NUMBER
210 , p6_a4 out nocopy VARCHAR2
211 , p6_a5 out nocopy VARCHAR2
212 , p6_a6 out nocopy VARCHAR2
213 , p6_a7 out nocopy VARCHAR2
214 , p6_a8 out nocopy NUMBER
215 , p6_a9 out nocopy NUMBER
216 , p6_a10 out nocopy VARCHAR2
217 , p6_a11 out nocopy DATE
218 , p6_a12 out nocopy DATE
219 , p6_a13 out nocopy DATE
220 , p6_a14 out nocopy DATE
221 , p6_a15 out nocopy VARCHAR2
222 , p6_a16 out nocopy VARCHAR2
223 , p6_a17 out nocopy VARCHAR2
224 , p6_a18 out nocopy VARCHAR2
225 , p6_a19 out nocopy VARCHAR2
226 , p6_a20 out nocopy VARCHAR2
227 , p6_a21 out nocopy VARCHAR2
228 , p6_a22 out nocopy VARCHAR2
229 , p6_a23 out nocopy VARCHAR2
230 , p6_a24 out nocopy VARCHAR2
231 , p6_a25 out nocopy VARCHAR2
232 , p6_a26 out nocopy VARCHAR2
233 , p6_a27 out nocopy VARCHAR2
234 , p6_a28 out nocopy VARCHAR2
235 , p6_a29 out nocopy VARCHAR2
236 , p6_a30 out nocopy VARCHAR2
237 , p6_a31 out nocopy VARCHAR2
238 , p6_a32 out nocopy VARCHAR2
239 , p6_a33 out nocopy NUMBER
240 , p6_a34 out nocopy NUMBER
241 , p6_a35 out nocopy NUMBER
242 , p6_a36 out nocopy NUMBER
243 , p6_a37 out nocopy DATE
244 , p6_a38 out nocopy NUMBER
245 , p6_a39 out nocopy DATE
246 , p6_a40 out nocopy NUMBER
247 , p6_a41 out nocopy DATE
248 , p6_a42 out nocopy NUMBER
249 , p6_a43 out nocopy NUMBER
250 , p5_a0 NUMBER := 0-1962.0724
251 , p5_a1 NUMBER := 0-1962.0724
252 , p5_a2 NUMBER := 0-1962.0724
253 , p5_a3 NUMBER := 0-1962.0724
254 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
255 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
256 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
257 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
258 , p5_a8 NUMBER := 0-1962.0724
259 , p5_a9 NUMBER := 0-1962.0724
260 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
261 , p5_a11 DATE := fnd_api.g_miss_date
262 , p5_a12 DATE := fnd_api.g_miss_date
263 , p5_a13 DATE := fnd_api.g_miss_date
264 , p5_a14 DATE := fnd_api.g_miss_date
265 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
266 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
267 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
268 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
269 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
270 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
271 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
272 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
273 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
274 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
275 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
276 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
277 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
278 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
279 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
280 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
281 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
282 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
283 , p5_a33 NUMBER := 0-1962.0724
284 , p5_a34 NUMBER := 0-1962.0724
285 , p5_a35 NUMBER := 0-1962.0724
286 , p5_a36 NUMBER := 0-1962.0724
287 , p5_a37 DATE := fnd_api.g_miss_date
288 , p5_a38 NUMBER := 0-1962.0724
289 , p5_a39 DATE := fnd_api.g_miss_date
290 , p5_a40 NUMBER := 0-1962.0724
291 , p5_a41 DATE := fnd_api.g_miss_date
292 , p5_a42 NUMBER := 0-1962.0724
293 , p5_a43 NUMBER := 0-1962.0724
294 );
295 procedure delete_pool(p_api_version NUMBER
296 , p_init_msg_list VARCHAR2
297 , x_return_status out nocopy VARCHAR2
298 , x_msg_count out nocopy NUMBER
299 , x_msg_data out nocopy VARCHAR2
300 , p5_a0 NUMBER := 0-1962.0724
301 , p5_a1 NUMBER := 0-1962.0724
302 , p5_a2 NUMBER := 0-1962.0724
303 , p5_a3 NUMBER := 0-1962.0724
304 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
305 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
306 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
307 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
308 , p5_a8 NUMBER := 0-1962.0724
309 , p5_a9 NUMBER := 0-1962.0724
310 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
311 , p5_a11 DATE := fnd_api.g_miss_date
312 , p5_a12 DATE := fnd_api.g_miss_date
313 , p5_a13 DATE := fnd_api.g_miss_date
314 , p5_a14 DATE := fnd_api.g_miss_date
315 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
316 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
317 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
318 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
319 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
320 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
321 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
322 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
323 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
324 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
325 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
326 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
327 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
328 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
329 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
330 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
331 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
332 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
333 , p5_a33 NUMBER := 0-1962.0724
334 , p5_a34 NUMBER := 0-1962.0724
335 , p5_a35 NUMBER := 0-1962.0724
336 , p5_a36 NUMBER := 0-1962.0724
337 , p5_a37 DATE := fnd_api.g_miss_date
338 , p5_a38 NUMBER := 0-1962.0724
339 , p5_a39 DATE := fnd_api.g_miss_date
340 , p5_a40 NUMBER := 0-1962.0724
341 , p5_a41 DATE := fnd_api.g_miss_date
342 , p5_a42 NUMBER := 0-1962.0724
343 , p5_a43 NUMBER := 0-1962.0724
344 );
345 procedure create_pool_contents(p_api_version NUMBER
346 , p_init_msg_list VARCHAR2
347 , x_return_status out nocopy VARCHAR2
348 , x_msg_count out nocopy NUMBER
349 , x_msg_data out nocopy VARCHAR2
350 , p6_a0 out nocopy NUMBER
351 , p6_a1 out nocopy NUMBER
352 , p6_a2 out nocopy NUMBER
353 , p6_a3 out nocopy NUMBER
354 , p6_a4 out nocopy NUMBER
355 , p6_a5 out nocopy NUMBER
356 , p6_a6 out nocopy NUMBER
357 , p6_a7 out nocopy VARCHAR2
358 , p6_a8 out nocopy NUMBER
359 , p6_a9 out nocopy DATE
360 , p6_a10 out nocopy DATE
361 , p6_a11 out nocopy NUMBER
362 , p6_a12 out nocopy NUMBER
363 , p6_a13 out nocopy DATE
364 , p6_a14 out nocopy VARCHAR2
365 , p6_a15 out nocopy VARCHAR2
366 , p6_a16 out nocopy VARCHAR2
367 , p6_a17 out nocopy VARCHAR2
368 , p6_a18 out nocopy VARCHAR2
369 , p6_a19 out nocopy VARCHAR2
370 , p6_a20 out nocopy VARCHAR2
371 , p6_a21 out nocopy VARCHAR2
372 , p6_a22 out nocopy VARCHAR2
373 , p6_a23 out nocopy VARCHAR2
374 , p6_a24 out nocopy VARCHAR2
375 , p6_a25 out nocopy VARCHAR2
376 , p6_a26 out nocopy VARCHAR2
377 , p6_a27 out nocopy VARCHAR2
378 , p6_a28 out nocopy VARCHAR2
379 , p6_a29 out nocopy VARCHAR2
380 , p6_a30 out nocopy VARCHAR2
381 , p6_a31 out nocopy NUMBER
382 , p6_a32 out nocopy NUMBER
383 , p6_a33 out nocopy NUMBER
384 , p6_a34 out nocopy DATE
385 , p6_a35 out nocopy NUMBER
386 , p6_a36 out nocopy DATE
387 , p6_a37 out nocopy NUMBER
388 , p6_a38 out nocopy DATE
389 , p6_a39 out nocopy NUMBER
390 , p5_a0 NUMBER := 0-1962.0724
391 , p5_a1 NUMBER := 0-1962.0724
392 , p5_a2 NUMBER := 0-1962.0724
393 , p5_a3 NUMBER := 0-1962.0724
394 , p5_a4 NUMBER := 0-1962.0724
395 , p5_a5 NUMBER := 0-1962.0724
396 , p5_a6 NUMBER := 0-1962.0724
397 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
398 , p5_a8 NUMBER := 0-1962.0724
399 , p5_a9 DATE := fnd_api.g_miss_date
400 , p5_a10 DATE := fnd_api.g_miss_date
401 , p5_a11 NUMBER := 0-1962.0724
402 , p5_a12 NUMBER := 0-1962.0724
403 , p5_a13 DATE := fnd_api.g_miss_date
404 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
405 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
406 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
407 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
408 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
409 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
410 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
411 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
412 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
413 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
414 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
415 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
416 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
417 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
418 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
419 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
420 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
421 , p5_a31 NUMBER := 0-1962.0724
422 , p5_a32 NUMBER := 0-1962.0724
423 , p5_a33 NUMBER := 0-1962.0724
424 , p5_a34 DATE := fnd_api.g_miss_date
425 , p5_a35 NUMBER := 0-1962.0724
426 , p5_a36 DATE := fnd_api.g_miss_date
427 , p5_a37 NUMBER := 0-1962.0724
428 , p5_a38 DATE := fnd_api.g_miss_date
429 , p5_a39 NUMBER := 0-1962.0724
430 );
431 procedure create_pool_contents(p_api_version NUMBER
432 , p_init_msg_list VARCHAR2
433 , x_return_status out nocopy VARCHAR2
434 , x_msg_count out nocopy NUMBER
435 , x_msg_data out nocopy VARCHAR2
436 , p5_a0 JTF_NUMBER_TABLE
437 , p5_a1 JTF_NUMBER_TABLE
438 , p5_a2 JTF_NUMBER_TABLE
439 , p5_a3 JTF_NUMBER_TABLE
440 , p5_a4 JTF_NUMBER_TABLE
441 , p5_a5 JTF_NUMBER_TABLE
442 , p5_a6 JTF_NUMBER_TABLE
443 , p5_a7 JTF_VARCHAR2_TABLE_200
444 , p5_a8 JTF_NUMBER_TABLE
445 , p5_a9 JTF_DATE_TABLE
446 , p5_a10 JTF_DATE_TABLE
447 , p5_a11 JTF_NUMBER_TABLE
448 , p5_a12 JTF_NUMBER_TABLE
449 , p5_a13 JTF_DATE_TABLE
450 , p5_a14 JTF_VARCHAR2_TABLE_100
451 , p5_a15 JTF_VARCHAR2_TABLE_100
452 , p5_a16 JTF_VARCHAR2_TABLE_500
453 , p5_a17 JTF_VARCHAR2_TABLE_500
454 , p5_a18 JTF_VARCHAR2_TABLE_500
455 , p5_a19 JTF_VARCHAR2_TABLE_500
456 , p5_a20 JTF_VARCHAR2_TABLE_500
457 , p5_a21 JTF_VARCHAR2_TABLE_500
458 , p5_a22 JTF_VARCHAR2_TABLE_500
459 , p5_a23 JTF_VARCHAR2_TABLE_500
460 , p5_a24 JTF_VARCHAR2_TABLE_500
461 , p5_a25 JTF_VARCHAR2_TABLE_500
462 , p5_a26 JTF_VARCHAR2_TABLE_500
463 , p5_a27 JTF_VARCHAR2_TABLE_500
464 , p5_a28 JTF_VARCHAR2_TABLE_500
465 , p5_a29 JTF_VARCHAR2_TABLE_500
466 , p5_a30 JTF_VARCHAR2_TABLE_500
467 , p5_a31 JTF_NUMBER_TABLE
468 , p5_a32 JTF_NUMBER_TABLE
469 , p5_a33 JTF_NUMBER_TABLE
470 , p5_a34 JTF_DATE_TABLE
471 , p5_a35 JTF_NUMBER_TABLE
472 , p5_a36 JTF_DATE_TABLE
473 , p5_a37 JTF_NUMBER_TABLE
474 , p5_a38 JTF_DATE_TABLE
475 , p5_a39 JTF_NUMBER_TABLE
476 , p6_a0 out nocopy JTF_NUMBER_TABLE
477 , p6_a1 out nocopy JTF_NUMBER_TABLE
478 , p6_a2 out nocopy JTF_NUMBER_TABLE
479 , p6_a3 out nocopy JTF_NUMBER_TABLE
480 , p6_a4 out nocopy JTF_NUMBER_TABLE
481 , p6_a5 out nocopy JTF_NUMBER_TABLE
482 , p6_a6 out nocopy JTF_NUMBER_TABLE
483 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
484 , p6_a8 out nocopy JTF_NUMBER_TABLE
485 , p6_a9 out nocopy JTF_DATE_TABLE
486 , p6_a10 out nocopy JTF_DATE_TABLE
487 , p6_a11 out nocopy JTF_NUMBER_TABLE
488 , p6_a12 out nocopy JTF_NUMBER_TABLE
489 , p6_a13 out nocopy JTF_DATE_TABLE
490 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
491 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
492 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
493 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
494 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
495 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
496 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
497 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
498 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
499 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
500 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
501 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
502 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
503 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
504 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
505 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
506 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
507 , p6_a31 out nocopy JTF_NUMBER_TABLE
508 , p6_a32 out nocopy JTF_NUMBER_TABLE
509 , p6_a33 out nocopy JTF_NUMBER_TABLE
510 , p6_a34 out nocopy JTF_DATE_TABLE
511 , p6_a35 out nocopy JTF_NUMBER_TABLE
512 , p6_a36 out nocopy JTF_DATE_TABLE
513 , p6_a37 out nocopy JTF_NUMBER_TABLE
514 , p6_a38 out nocopy JTF_DATE_TABLE
515 , p6_a39 out nocopy JTF_NUMBER_TABLE
516 );
517 procedure update_pool_contents(p_api_version NUMBER
518 , p_init_msg_list VARCHAR2
519 , x_return_status out nocopy VARCHAR2
520 , x_msg_count out nocopy NUMBER
521 , x_msg_data out nocopy VARCHAR2
522 , p6_a0 out nocopy NUMBER
523 , p6_a1 out nocopy NUMBER
524 , p6_a2 out nocopy NUMBER
525 , p6_a3 out nocopy NUMBER
526 , p6_a4 out nocopy NUMBER
527 , p6_a5 out nocopy NUMBER
528 , p6_a6 out nocopy NUMBER
529 , p6_a7 out nocopy VARCHAR2
530 , p6_a8 out nocopy NUMBER
531 , p6_a9 out nocopy DATE
532 , p6_a10 out nocopy DATE
533 , p6_a11 out nocopy NUMBER
534 , p6_a12 out nocopy NUMBER
535 , p6_a13 out nocopy DATE
536 , p6_a14 out nocopy VARCHAR2
537 , p6_a15 out nocopy VARCHAR2
538 , p6_a16 out nocopy VARCHAR2
539 , p6_a17 out nocopy VARCHAR2
540 , p6_a18 out nocopy VARCHAR2
541 , p6_a19 out nocopy VARCHAR2
542 , p6_a20 out nocopy VARCHAR2
543 , p6_a21 out nocopy VARCHAR2
544 , p6_a22 out nocopy VARCHAR2
545 , p6_a23 out nocopy VARCHAR2
546 , p6_a24 out nocopy VARCHAR2
547 , p6_a25 out nocopy VARCHAR2
548 , p6_a26 out nocopy VARCHAR2
549 , p6_a27 out nocopy VARCHAR2
550 , p6_a28 out nocopy VARCHAR2
551 , p6_a29 out nocopy VARCHAR2
552 , p6_a30 out nocopy VARCHAR2
553 , p6_a31 out nocopy NUMBER
554 , p6_a32 out nocopy NUMBER
555 , p6_a33 out nocopy NUMBER
556 , p6_a34 out nocopy DATE
557 , p6_a35 out nocopy NUMBER
558 , p6_a36 out nocopy DATE
559 , p6_a37 out nocopy NUMBER
560 , p6_a38 out nocopy DATE
561 , p6_a39 out nocopy NUMBER
562 , p5_a0 NUMBER := 0-1962.0724
563 , p5_a1 NUMBER := 0-1962.0724
564 , p5_a2 NUMBER := 0-1962.0724
565 , p5_a3 NUMBER := 0-1962.0724
566 , p5_a4 NUMBER := 0-1962.0724
567 , p5_a5 NUMBER := 0-1962.0724
568 , p5_a6 NUMBER := 0-1962.0724
569 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
570 , p5_a8 NUMBER := 0-1962.0724
571 , p5_a9 DATE := fnd_api.g_miss_date
572 , p5_a10 DATE := fnd_api.g_miss_date
573 , p5_a11 NUMBER := 0-1962.0724
574 , p5_a12 NUMBER := 0-1962.0724
575 , p5_a13 DATE := fnd_api.g_miss_date
576 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
577 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
578 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
579 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
580 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
581 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
582 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
583 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
584 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
585 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
586 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
587 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
588 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
589 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
590 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
591 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
592 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
593 , p5_a31 NUMBER := 0-1962.0724
594 , p5_a32 NUMBER := 0-1962.0724
595 , p5_a33 NUMBER := 0-1962.0724
596 , p5_a34 DATE := fnd_api.g_miss_date
597 , p5_a35 NUMBER := 0-1962.0724
598 , p5_a36 DATE := fnd_api.g_miss_date
599 , p5_a37 NUMBER := 0-1962.0724
600 , p5_a38 DATE := fnd_api.g_miss_date
601 , p5_a39 NUMBER := 0-1962.0724
602 );
603 procedure update_pool_contents(p_api_version NUMBER
604 , p_init_msg_list VARCHAR2
605 , x_return_status out nocopy VARCHAR2
606 , x_msg_count out nocopy NUMBER
607 , x_msg_data out nocopy VARCHAR2
608 , p5_a0 JTF_NUMBER_TABLE
609 , p5_a1 JTF_NUMBER_TABLE
610 , p5_a2 JTF_NUMBER_TABLE
611 , p5_a3 JTF_NUMBER_TABLE
612 , p5_a4 JTF_NUMBER_TABLE
613 , p5_a5 JTF_NUMBER_TABLE
614 , p5_a6 JTF_NUMBER_TABLE
615 , p5_a7 JTF_VARCHAR2_TABLE_200
616 , p5_a8 JTF_NUMBER_TABLE
617 , p5_a9 JTF_DATE_TABLE
618 , p5_a10 JTF_DATE_TABLE
619 , p5_a11 JTF_NUMBER_TABLE
620 , p5_a12 JTF_NUMBER_TABLE
621 , p5_a13 JTF_DATE_TABLE
622 , p5_a14 JTF_VARCHAR2_TABLE_100
623 , p5_a15 JTF_VARCHAR2_TABLE_100
624 , p5_a16 JTF_VARCHAR2_TABLE_500
625 , p5_a17 JTF_VARCHAR2_TABLE_500
626 , p5_a18 JTF_VARCHAR2_TABLE_500
627 , p5_a19 JTF_VARCHAR2_TABLE_500
628 , p5_a20 JTF_VARCHAR2_TABLE_500
629 , p5_a21 JTF_VARCHAR2_TABLE_500
630 , p5_a22 JTF_VARCHAR2_TABLE_500
631 , p5_a23 JTF_VARCHAR2_TABLE_500
632 , p5_a24 JTF_VARCHAR2_TABLE_500
633 , p5_a25 JTF_VARCHAR2_TABLE_500
634 , p5_a26 JTF_VARCHAR2_TABLE_500
635 , p5_a27 JTF_VARCHAR2_TABLE_500
636 , p5_a28 JTF_VARCHAR2_TABLE_500
637 , p5_a29 JTF_VARCHAR2_TABLE_500
638 , p5_a30 JTF_VARCHAR2_TABLE_500
639 , p5_a31 JTF_NUMBER_TABLE
640 , p5_a32 JTF_NUMBER_TABLE
641 , p5_a33 JTF_NUMBER_TABLE
642 , p5_a34 JTF_DATE_TABLE
643 , p5_a35 JTF_NUMBER_TABLE
644 , p5_a36 JTF_DATE_TABLE
645 , p5_a37 JTF_NUMBER_TABLE
646 , p5_a38 JTF_DATE_TABLE
647 , p5_a39 JTF_NUMBER_TABLE
648 , p6_a0 out nocopy JTF_NUMBER_TABLE
649 , p6_a1 out nocopy JTF_NUMBER_TABLE
650 , p6_a2 out nocopy JTF_NUMBER_TABLE
651 , p6_a3 out nocopy JTF_NUMBER_TABLE
652 , p6_a4 out nocopy JTF_NUMBER_TABLE
653 , p6_a5 out nocopy JTF_NUMBER_TABLE
654 , p6_a6 out nocopy JTF_NUMBER_TABLE
655 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
656 , p6_a8 out nocopy JTF_NUMBER_TABLE
657 , p6_a9 out nocopy JTF_DATE_TABLE
658 , p6_a10 out nocopy JTF_DATE_TABLE
659 , p6_a11 out nocopy JTF_NUMBER_TABLE
660 , p6_a12 out nocopy JTF_NUMBER_TABLE
661 , p6_a13 out nocopy JTF_DATE_TABLE
662 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
663 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
664 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
665 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
666 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
667 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
668 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
669 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
670 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
671 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
672 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
673 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
674 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
675 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
676 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
677 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
678 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
679 , p6_a31 out nocopy JTF_NUMBER_TABLE
680 , p6_a32 out nocopy JTF_NUMBER_TABLE
681 , p6_a33 out nocopy JTF_NUMBER_TABLE
682 , p6_a34 out nocopy JTF_DATE_TABLE
683 , p6_a35 out nocopy JTF_NUMBER_TABLE
684 , p6_a36 out nocopy JTF_DATE_TABLE
685 , p6_a37 out nocopy JTF_NUMBER_TABLE
686 , p6_a38 out nocopy JTF_DATE_TABLE
687 , p6_a39 out nocopy JTF_NUMBER_TABLE
688 );
689 procedure delete_pool_contents(p_api_version NUMBER
690 , p_init_msg_list VARCHAR2
691 , x_return_status out nocopy VARCHAR2
692 , x_msg_count out nocopy NUMBER
693 , x_msg_data out nocopy VARCHAR2
694 , p5_a0 NUMBER := 0-1962.0724
695 , p5_a1 NUMBER := 0-1962.0724
696 , p5_a2 NUMBER := 0-1962.0724
697 , p5_a3 NUMBER := 0-1962.0724
698 , p5_a4 NUMBER := 0-1962.0724
699 , p5_a5 NUMBER := 0-1962.0724
700 , p5_a6 NUMBER := 0-1962.0724
701 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
702 , p5_a8 NUMBER := 0-1962.0724
703 , p5_a9 DATE := fnd_api.g_miss_date
704 , p5_a10 DATE := fnd_api.g_miss_date
705 , p5_a11 NUMBER := 0-1962.0724
706 , p5_a12 NUMBER := 0-1962.0724
707 , p5_a13 DATE := fnd_api.g_miss_date
708 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
709 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
710 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
711 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
712 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
713 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
714 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
715 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
716 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
717 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
718 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
719 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
720 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
721 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
722 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
723 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
724 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
725 , p5_a31 NUMBER := 0-1962.0724
726 , p5_a32 NUMBER := 0-1962.0724
727 , p5_a33 NUMBER := 0-1962.0724
728 , p5_a34 DATE := fnd_api.g_miss_date
729 , p5_a35 NUMBER := 0-1962.0724
730 , p5_a36 DATE := fnd_api.g_miss_date
731 , p5_a37 NUMBER := 0-1962.0724
732 , p5_a38 DATE := fnd_api.g_miss_date
733 , p5_a39 NUMBER := 0-1962.0724
734 );
735 procedure delete_pool_contents(p_api_version NUMBER
736 , p_init_msg_list VARCHAR2
737 , x_return_status out nocopy VARCHAR2
738 , x_msg_count out nocopy NUMBER
739 , x_msg_data out nocopy VARCHAR2
740 , p5_a0 JTF_NUMBER_TABLE
741 , p5_a1 JTF_NUMBER_TABLE
742 , p5_a2 JTF_NUMBER_TABLE
743 , p5_a3 JTF_NUMBER_TABLE
744 , p5_a4 JTF_NUMBER_TABLE
745 , p5_a5 JTF_NUMBER_TABLE
746 , p5_a6 JTF_NUMBER_TABLE
747 , p5_a7 JTF_VARCHAR2_TABLE_200
748 , p5_a8 JTF_NUMBER_TABLE
749 , p5_a9 JTF_DATE_TABLE
750 , p5_a10 JTF_DATE_TABLE
751 , p5_a11 JTF_NUMBER_TABLE
752 , p5_a12 JTF_NUMBER_TABLE
753 , p5_a13 JTF_DATE_TABLE
754 , p5_a14 JTF_VARCHAR2_TABLE_100
755 , p5_a15 JTF_VARCHAR2_TABLE_100
756 , p5_a16 JTF_VARCHAR2_TABLE_500
757 , p5_a17 JTF_VARCHAR2_TABLE_500
758 , p5_a18 JTF_VARCHAR2_TABLE_500
759 , p5_a19 JTF_VARCHAR2_TABLE_500
760 , p5_a20 JTF_VARCHAR2_TABLE_500
761 , p5_a21 JTF_VARCHAR2_TABLE_500
762 , p5_a22 JTF_VARCHAR2_TABLE_500
763 , p5_a23 JTF_VARCHAR2_TABLE_500
764 , p5_a24 JTF_VARCHAR2_TABLE_500
765 , p5_a25 JTF_VARCHAR2_TABLE_500
766 , p5_a26 JTF_VARCHAR2_TABLE_500
767 , p5_a27 JTF_VARCHAR2_TABLE_500
768 , p5_a28 JTF_VARCHAR2_TABLE_500
769 , p5_a29 JTF_VARCHAR2_TABLE_500
770 , p5_a30 JTF_VARCHAR2_TABLE_500
771 , p5_a31 JTF_NUMBER_TABLE
772 , p5_a32 JTF_NUMBER_TABLE
773 , p5_a33 JTF_NUMBER_TABLE
774 , p5_a34 JTF_DATE_TABLE
775 , p5_a35 JTF_NUMBER_TABLE
776 , p5_a36 JTF_DATE_TABLE
777 , p5_a37 JTF_NUMBER_TABLE
778 , p5_a38 JTF_DATE_TABLE
779 , p5_a39 JTF_NUMBER_TABLE
780 );
781 procedure create_pool_transaction(p_api_version NUMBER
782 , p_init_msg_list VARCHAR2
783 , x_return_status out nocopy VARCHAR2
784 , x_msg_count out nocopy NUMBER
785 , x_msg_data out nocopy VARCHAR2
786 , p6_a0 out nocopy NUMBER
787 , p6_a1 out nocopy NUMBER
788 , p6_a2 out nocopy NUMBER
789 , p6_a3 out nocopy NUMBER
790 , p6_a4 out nocopy DATE
791 , p6_a5 out nocopy VARCHAR2
792 , p6_a6 out nocopy VARCHAR2
793 , p6_a7 out nocopy DATE
794 , p6_a8 out nocopy VARCHAR2
795 , p6_a9 out nocopy VARCHAR2
796 , p6_a10 out nocopy DATE
797 , p6_a11 out nocopy NUMBER
798 , p6_a12 out nocopy VARCHAR2
799 , p6_a13 out nocopy VARCHAR2
800 , p6_a14 out nocopy VARCHAR2
801 , p6_a15 out nocopy VARCHAR2
802 , p6_a16 out nocopy VARCHAR2
803 , p6_a17 out nocopy VARCHAR2
804 , p6_a18 out nocopy VARCHAR2
805 , p6_a19 out nocopy VARCHAR2
806 , p6_a20 out nocopy VARCHAR2
807 , p6_a21 out nocopy VARCHAR2
808 , p6_a22 out nocopy VARCHAR2
809 , p6_a23 out nocopy VARCHAR2
810 , p6_a24 out nocopy VARCHAR2
811 , p6_a25 out nocopy VARCHAR2
812 , p6_a26 out nocopy VARCHAR2
813 , p6_a27 out nocopy VARCHAR2
814 , p6_a28 out nocopy VARCHAR2
815 , p6_a29 out nocopy NUMBER
816 , p6_a30 out nocopy NUMBER
817 , p6_a31 out nocopy NUMBER
818 , p6_a32 out nocopy DATE
819 , p6_a33 out nocopy NUMBER
820 , p6_a34 out nocopy DATE
821 , p6_a35 out nocopy NUMBER
822 , p6_a36 out nocopy DATE
823 , p6_a37 out nocopy NUMBER
824 , p6_a38 out nocopy NUMBER
825 , p6_a39 out nocopy VARCHAR2
826 , p5_a0 NUMBER := 0-1962.0724
827 , p5_a1 NUMBER := 0-1962.0724
828 , p5_a2 NUMBER := 0-1962.0724
829 , p5_a3 NUMBER := 0-1962.0724
830 , p5_a4 DATE := fnd_api.g_miss_date
831 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
832 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
833 , p5_a7 DATE := fnd_api.g_miss_date
834 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
835 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
836 , p5_a10 DATE := fnd_api.g_miss_date
837 , p5_a11 NUMBER := 0-1962.0724
838 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
839 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
840 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
841 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
842 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
843 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
844 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
845 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
846 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
847 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
848 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
849 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
850 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
851 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
852 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
853 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
854 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
855 , p5_a29 NUMBER := 0-1962.0724
856 , p5_a30 NUMBER := 0-1962.0724
857 , p5_a31 NUMBER := 0-1962.0724
858 , p5_a32 DATE := fnd_api.g_miss_date
859 , p5_a33 NUMBER := 0-1962.0724
860 , p5_a34 DATE := fnd_api.g_miss_date
861 , p5_a35 NUMBER := 0-1962.0724
862 , p5_a36 DATE := fnd_api.g_miss_date
863 , p5_a37 NUMBER := 0-1962.0724
864 , p5_a38 NUMBER := 0-1962.0724
865 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
866 );
867 procedure update_pool_transaction(p_api_version NUMBER
868 , p_init_msg_list VARCHAR2
869 , x_return_status out nocopy VARCHAR2
870 , x_msg_count out nocopy NUMBER
871 , x_msg_data out nocopy VARCHAR2
872 , p6_a0 out nocopy NUMBER
873 , p6_a1 out nocopy NUMBER
874 , p6_a2 out nocopy NUMBER
875 , p6_a3 out nocopy NUMBER
876 , p6_a4 out nocopy DATE
877 , p6_a5 out nocopy VARCHAR2
878 , p6_a6 out nocopy VARCHAR2
879 , p6_a7 out nocopy DATE
880 , p6_a8 out nocopy VARCHAR2
881 , p6_a9 out nocopy VARCHAR2
882 , p6_a10 out nocopy DATE
883 , p6_a11 out nocopy NUMBER
884 , p6_a12 out nocopy VARCHAR2
885 , p6_a13 out nocopy VARCHAR2
886 , p6_a14 out nocopy VARCHAR2
887 , p6_a15 out nocopy VARCHAR2
888 , p6_a16 out nocopy VARCHAR2
889 , p6_a17 out nocopy VARCHAR2
890 , p6_a18 out nocopy VARCHAR2
891 , p6_a19 out nocopy VARCHAR2
892 , p6_a20 out nocopy VARCHAR2
893 , p6_a21 out nocopy VARCHAR2
894 , p6_a22 out nocopy VARCHAR2
895 , p6_a23 out nocopy VARCHAR2
896 , p6_a24 out nocopy VARCHAR2
897 , p6_a25 out nocopy VARCHAR2
898 , p6_a26 out nocopy VARCHAR2
899 , p6_a27 out nocopy VARCHAR2
900 , p6_a28 out nocopy VARCHAR2
901 , p6_a29 out nocopy NUMBER
902 , p6_a30 out nocopy NUMBER
903 , p6_a31 out nocopy NUMBER
904 , p6_a32 out nocopy DATE
905 , p6_a33 out nocopy NUMBER
906 , p6_a34 out nocopy DATE
907 , p6_a35 out nocopy NUMBER
908 , p6_a36 out nocopy DATE
909 , p6_a37 out nocopy NUMBER
910 , p6_a38 out nocopy NUMBER
911 , p6_a39 out nocopy VARCHAR2
912 , p5_a0 NUMBER := 0-1962.0724
913 , p5_a1 NUMBER := 0-1962.0724
914 , p5_a2 NUMBER := 0-1962.0724
915 , p5_a3 NUMBER := 0-1962.0724
916 , p5_a4 DATE := fnd_api.g_miss_date
917 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
918 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
919 , p5_a7 DATE := fnd_api.g_miss_date
920 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
921 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
922 , p5_a10 DATE := fnd_api.g_miss_date
923 , p5_a11 NUMBER := 0-1962.0724
924 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
925 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
926 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
927 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
928 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
929 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
930 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
931 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
932 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
933 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
934 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
935 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
936 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
937 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
938 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
939 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
940 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
941 , p5_a29 NUMBER := 0-1962.0724
942 , p5_a30 NUMBER := 0-1962.0724
943 , p5_a31 NUMBER := 0-1962.0724
944 , p5_a32 DATE := fnd_api.g_miss_date
945 , p5_a33 NUMBER := 0-1962.0724
946 , p5_a34 DATE := fnd_api.g_miss_date
947 , p5_a35 NUMBER := 0-1962.0724
948 , p5_a36 DATE := fnd_api.g_miss_date
949 , p5_a37 NUMBER := 0-1962.0724
950 , p5_a38 NUMBER := 0-1962.0724
951 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
952 );
953 procedure delete_pool_transaction(p_api_version NUMBER
954 , p_init_msg_list VARCHAR2
955 , x_return_status out nocopy VARCHAR2
956 , x_msg_count out nocopy NUMBER
957 , x_msg_data out nocopy VARCHAR2
958 , p5_a0 NUMBER := 0-1962.0724
959 , p5_a1 NUMBER := 0-1962.0724
960 , p5_a2 NUMBER := 0-1962.0724
961 , p5_a3 NUMBER := 0-1962.0724
962 , p5_a4 DATE := fnd_api.g_miss_date
963 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
964 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
965 , p5_a7 DATE := fnd_api.g_miss_date
966 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
967 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
968 , p5_a10 DATE := fnd_api.g_miss_date
969 , p5_a11 NUMBER := 0-1962.0724
970 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
971 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
972 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
973 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
974 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
975 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
976 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
977 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
978 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
979 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
980 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
981 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
982 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
983 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
984 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
985 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
986 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
987 , p5_a29 NUMBER := 0-1962.0724
988 , p5_a30 NUMBER := 0-1962.0724
989 , p5_a31 NUMBER := 0-1962.0724
990 , p5_a32 DATE := fnd_api.g_miss_date
991 , p5_a33 NUMBER := 0-1962.0724
992 , p5_a34 DATE := fnd_api.g_miss_date
993 , p5_a35 NUMBER := 0-1962.0724
994 , p5_a36 DATE := fnd_api.g_miss_date
995 , p5_a37 NUMBER := 0-1962.0724
996 , p5_a38 NUMBER := 0-1962.0724
997 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
998 );
999 procedure add_pool_contents(p_api_version NUMBER
1000 , p_init_msg_list VARCHAR2
1001 , x_return_status out nocopy VARCHAR2
1002 , x_msg_count out nocopy NUMBER
1003 , x_msg_data out nocopy VARCHAR2
1004 , x_row_count out nocopy NUMBER
1005 , p_currency_code VARCHAR2
1006 , p_pol_id NUMBER
1007 , p_multi_org VARCHAR2
1008 , p_cust_object1_id1 NUMBER
1009 , p_sic_code VARCHAR2
1010 , p_khr_id NUMBER
1011 , p_pre_tax_yield_from NUMBER
1012 , p_pre_tax_yield_to NUMBER
1013 , p_book_classification VARCHAR2
1014 , p_tax_owner VARCHAR2
1015 , p_pdt_id NUMBER
1016 , p_start_date_from date
1017 , p_start_date_to date
1018 , p_end_date_from date
1019 , p_end_date_to date
1020 , p_asset_id NUMBER
1021 , p_item_id1 NUMBER
1022 , p_model_number VARCHAR2
1023 , p_manufacturer_name VARCHAR2
1024 , p_vendor_id1 NUMBER
1025 , p_oec_from NUMBER
1026 , p_oec_to NUMBER
1027 , p_residual_percentage NUMBER
1028 , p_sty_id1 NUMBER
1029 , p_sty_id2 NUMBER
1030 , p_stream_type_subclass VARCHAR2
1031 , p_stream_element_from_date date
1032 , p_stream_element_to_date date
1033 , p_stream_element_payment_freq VARCHAR2
1034 , p_log_message VARCHAR2
1035 );
1036 procedure cleanup_pool_contents(p_api_version NUMBER
1037 , p_init_msg_list VARCHAR2
1038 , x_return_status out nocopy VARCHAR2
1039 , x_msg_count out nocopy NUMBER
1040 , x_msg_data out nocopy VARCHAR2
1041 , p_currency_code VARCHAR2
1042 , p_pol_id NUMBER
1043 , p_multi_org VARCHAR2
1044 , p_cust_object1_id1 NUMBER
1045 , p_sic_code VARCHAR2
1046 , p_dnz_chr_id NUMBER
1047 , p_pre_tax_yield_from NUMBER
1048 , p_pre_tax_yield_to NUMBER
1049 , p_book_classification VARCHAR2
1050 , p_tax_owner VARCHAR2
1051 , p_pdt_id NUMBER
1052 , p_start_from_date date
1053 , p_start_to_date date
1054 , p_end_from_date date
1055 , p_end_to_date date
1056 , p_asset_id NUMBER
1057 , p_item_id1 NUMBER
1058 , p_model_number VARCHAR2
1059 , p_manufacturer_name VARCHAR2
1060 , p_vendor_id1 NUMBER
1061 , p_oec_from NUMBER
1062 , p_oec_to NUMBER
1063 , p_residual_percentage NUMBER
1064 , p_sty_id NUMBER
1065 , p_stream_type_subclass VARCHAR2
1066 , p_streams_from_date date
1067 , p_streams_to_date date
1068 , p_action_code VARCHAR2
1069 , p33_a0 out nocopy JTF_NUMBER_TABLE
1070 , p33_a1 out nocopy JTF_VARCHAR2_TABLE_200
1071 , p33_a2 out nocopy JTF_VARCHAR2_TABLE_200
1072 , p33_a3 out nocopy JTF_VARCHAR2_TABLE_400
1073 , p33_a4 out nocopy JTF_VARCHAR2_TABLE_200
1074 , p33_a5 out nocopy JTF_NUMBER_TABLE
1075 , p33_a6 out nocopy JTF_VARCHAR2_TABLE_100
1076 , p33_a7 out nocopy JTF_VARCHAR2_TABLE_100
1077 , p33_a8 out nocopy JTF_VARCHAR2_TABLE_100
1078 );
1079 procedure validate_pool(p_api_version NUMBER
1080 , p_init_msg_list VARCHAR2
1081 , p_api_name VARCHAR2
1082 , p_action VARCHAR2
1083 , x_return_status out nocopy VARCHAR2
1084 , x_msg_count out nocopy NUMBER
1085 , x_msg_data out nocopy VARCHAR2
1086 , p3_a0 NUMBER := 0-1962.0724
1087 , p3_a1 NUMBER := 0-1962.0724
1088 , p3_a2 NUMBER := 0-1962.0724
1089 , p3_a3 NUMBER := 0-1962.0724
1090 , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1091 , p3_a5 VARCHAR2 := fnd_api.g_miss_char
1092 , p3_a6 VARCHAR2 := fnd_api.g_miss_char
1093 , p3_a7 VARCHAR2 := fnd_api.g_miss_char
1094 , p3_a8 NUMBER := 0-1962.0724
1095 , p3_a9 NUMBER := 0-1962.0724
1096 , p3_a10 VARCHAR2 := fnd_api.g_miss_char
1097 , p3_a11 DATE := fnd_api.g_miss_date
1098 , p3_a12 DATE := fnd_api.g_miss_date
1099 , p3_a13 DATE := fnd_api.g_miss_date
1100 , p3_a14 DATE := fnd_api.g_miss_date
1101 , p3_a15 VARCHAR2 := fnd_api.g_miss_char
1102 , p3_a16 VARCHAR2 := fnd_api.g_miss_char
1103 , p3_a17 VARCHAR2 := fnd_api.g_miss_char
1104 , p3_a18 VARCHAR2 := fnd_api.g_miss_char
1105 , p3_a19 VARCHAR2 := fnd_api.g_miss_char
1106 , p3_a20 VARCHAR2 := fnd_api.g_miss_char
1107 , p3_a21 VARCHAR2 := fnd_api.g_miss_char
1108 , p3_a22 VARCHAR2 := fnd_api.g_miss_char
1109 , p3_a23 VARCHAR2 := fnd_api.g_miss_char
1110 , p3_a24 VARCHAR2 := fnd_api.g_miss_char
1111 , p3_a25 VARCHAR2 := fnd_api.g_miss_char
1112 , p3_a26 VARCHAR2 := fnd_api.g_miss_char
1113 , p3_a27 VARCHAR2 := fnd_api.g_miss_char
1114 , p3_a28 VARCHAR2 := fnd_api.g_miss_char
1115 , p3_a29 VARCHAR2 := fnd_api.g_miss_char
1116 , p3_a30 VARCHAR2 := fnd_api.g_miss_char
1117 , p3_a31 VARCHAR2 := fnd_api.g_miss_char
1118 , p3_a32 VARCHAR2 := fnd_api.g_miss_char
1119 , p3_a33 NUMBER := 0-1962.0724
1120 , p3_a34 NUMBER := 0-1962.0724
1121 , p3_a35 NUMBER := 0-1962.0724
1122 , p3_a36 NUMBER := 0-1962.0724
1123 , p3_a37 DATE := fnd_api.g_miss_date
1124 , p3_a38 NUMBER := 0-1962.0724
1125 , p3_a39 DATE := fnd_api.g_miss_date
1126 , p3_a40 NUMBER := 0-1962.0724
1127 , p3_a41 DATE := fnd_api.g_miss_date
1128 , p3_a42 NUMBER := 0-1962.0724
1129 , p3_a43 NUMBER := 0-1962.0724
1130 );
1131 end okl_pool_pvt_w;