[Home] [Help]
PACKAGE: APPS.OKL_FE_STD_RATE_TMPL_PVT_W
Source
1 package okl_fe_std_rate_tmpl_pvt_w as
2 /* $Header: OKLESRTS.pls 120.0 2005/07/07 10:38:09 viselvar noship $ */
3 procedure rosetta_table_copy_in_p5(t out nocopy okl_fe_std_rate_tmpl_pvt.okl_number_table, a0 JTF_NUMBER_TABLE);
4 procedure rosetta_table_copy_out_p5(t okl_fe_std_rate_tmpl_pvt.okl_number_table, a0 out nocopy JTF_NUMBER_TABLE);
5
6 procedure rosetta_table_copy_in_p8(t out nocopy okl_fe_std_rate_tmpl_pvt.invalid_object_tbl, a0 JTF_NUMBER_TABLE
7 , a1 JTF_VARCHAR2_TABLE_300
8 , a2 JTF_VARCHAR2_TABLE_100
9 , a3 JTF_VARCHAR2_TABLE_100
10 );
11 procedure rosetta_table_copy_out_p8(t okl_fe_std_rate_tmpl_pvt.invalid_object_tbl, a0 out nocopy JTF_NUMBER_TABLE
12 , a1 out nocopy JTF_VARCHAR2_TABLE_300
13 , a2 out nocopy JTF_VARCHAR2_TABLE_100
14 , a3 out nocopy JTF_VARCHAR2_TABLE_100
15 );
16
17 procedure get_version(p_api_version NUMBER
18 , p_init_msg_list VARCHAR2
19 , x_return_status out nocopy VARCHAR2
20 , x_msg_count out nocopy NUMBER
21 , x_msg_data out nocopy VARCHAR2
22 , p_srt_id NUMBER
23 , p_version_number NUMBER
24 , p7_a0 out nocopy NUMBER
25 , p7_a1 out nocopy VARCHAR2
26 , p7_a2 out nocopy VARCHAR2
27 , p7_a3 out nocopy NUMBER
28 , p7_a4 out nocopy NUMBER
29 , p7_a5 out nocopy VARCHAR2
30 , p7_a6 out nocopy VARCHAR2
31 , p7_a7 out nocopy VARCHAR2
32 , p7_a8 out nocopy NUMBER
33 , p7_a9 out nocopy VARCHAR2
34 , p7_a10 out nocopy VARCHAR2
35 , p7_a11 out nocopy NUMBER
36 , p7_a12 out nocopy VARCHAR2
37 , p7_a13 out nocopy VARCHAR2
38 , p7_a14 out nocopy DATE
39 , p7_a15 out nocopy DATE
40 , p7_a16 out nocopy NUMBER
41 , p7_a17 out nocopy VARCHAR2
42 , p7_a18 out nocopy VARCHAR2
43 , p7_a19 out nocopy VARCHAR2
44 , p7_a20 out nocopy VARCHAR2
45 , p7_a21 out nocopy VARCHAR2
46 , p7_a22 out nocopy VARCHAR2
47 , p7_a23 out nocopy VARCHAR2
48 , p7_a24 out nocopy VARCHAR2
49 , p7_a25 out nocopy VARCHAR2
50 , p7_a26 out nocopy VARCHAR2
51 , p7_a27 out nocopy VARCHAR2
52 , p7_a28 out nocopy VARCHAR2
53 , p7_a29 out nocopy VARCHAR2
54 , p7_a30 out nocopy VARCHAR2
55 , p7_a31 out nocopy VARCHAR2
56 , p7_a32 out nocopy VARCHAR2
57 , p7_a33 out nocopy NUMBER
58 , p7_a34 out nocopy DATE
59 , p7_a35 out nocopy NUMBER
60 , p7_a36 out nocopy DATE
61 , p7_a37 out nocopy NUMBER
62 , p8_a0 out nocopy NUMBER
63 , p8_a1 out nocopy NUMBER
64 , p8_a2 out nocopy VARCHAR2
65 , p8_a3 out nocopy NUMBER
66 , p8_a4 out nocopy DATE
67 , p8_a5 out nocopy DATE
68 , p8_a6 out nocopy VARCHAR2
69 , p8_a7 out nocopy NUMBER
70 , p8_a8 out nocopy NUMBER
71 , p8_a9 out nocopy NUMBER
72 , p8_a10 out nocopy VARCHAR2
73 , p8_a11 out nocopy NUMBER
74 , p8_a12 out nocopy NUMBER
75 , p8_a13 out nocopy VARCHAR2
76 , p8_a14 out nocopy VARCHAR2
77 , p8_a15 out nocopy VARCHAR2
78 , p8_a16 out nocopy VARCHAR2
79 , p8_a17 out nocopy VARCHAR2
80 , p8_a18 out nocopy VARCHAR2
81 , p8_a19 out nocopy VARCHAR2
82 , p8_a20 out nocopy VARCHAR2
83 , p8_a21 out nocopy VARCHAR2
84 , p8_a22 out nocopy VARCHAR2
85 , p8_a23 out nocopy VARCHAR2
86 , p8_a24 out nocopy VARCHAR2
87 , p8_a25 out nocopy VARCHAR2
88 , p8_a26 out nocopy VARCHAR2
89 , p8_a27 out nocopy VARCHAR2
90 , p8_a28 out nocopy VARCHAR2
91 , p8_a29 out nocopy NUMBER
92 , p8_a30 out nocopy DATE
93 , p8_a31 out nocopy NUMBER
94 , p8_a32 out nocopy DATE
95 , p8_a33 out nocopy NUMBER
96 , p9_a0 out nocopy NUMBER
97 , p9_a1 out nocopy NUMBER
98 , p9_a2 out nocopy NUMBER
99 , p9_a3 out nocopy VARCHAR2
100 , p9_a4 out nocopy VARCHAR2
101 , p9_a5 out nocopy VARCHAR2
102 , p9_a6 out nocopy NUMBER
103 , p9_a7 out nocopy DATE
104 , p9_a8 out nocopy NUMBER
105 , p9_a9 out nocopy DATE
106 , p9_a10 out nocopy NUMBER
107 , p10_a0 out nocopy JTF_NUMBER_TABLE
108 , p10_a1 out nocopy JTF_NUMBER_TABLE
109 , p10_a2 out nocopy JTF_NUMBER_TABLE
110 , p10_a3 out nocopy JTF_NUMBER_TABLE
111 , p10_a4 out nocopy JTF_DATE_TABLE
112 , p10_a5 out nocopy JTF_DATE_TABLE
113 , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
114 , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100
115 , p10_a8 out nocopy JTF_NUMBER_TABLE
116 , p10_a9 out nocopy JTF_DATE_TABLE
117 , p10_a10 out nocopy JTF_NUMBER_TABLE
118 , p10_a11 out nocopy JTF_DATE_TABLE
119 , p10_a12 out nocopy JTF_NUMBER_TABLE
120 , p11_a0 out nocopy JTF_NUMBER_TABLE
121 , p11_a1 out nocopy JTF_NUMBER_TABLE
122 , p11_a2 out nocopy JTF_NUMBER_TABLE
123 , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
124 , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
125 , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
126 , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
127 , p11_a7 out nocopy JTF_VARCHAR2_TABLE_300
128 , p11_a8 out nocopy JTF_VARCHAR2_TABLE_300
129 , p11_a9 out nocopy JTF_NUMBER_TABLE
130 , p11_a10 out nocopy JTF_NUMBER_TABLE
131 , p11_a11 out nocopy JTF_DATE_TABLE
132 , p11_a12 out nocopy JTF_DATE_TABLE
133 , p11_a13 out nocopy JTF_VARCHAR2_TABLE_100
134 , p11_a14 out nocopy JTF_NUMBER_TABLE
135 , p11_a15 out nocopy JTF_NUMBER_TABLE
136 , p11_a16 out nocopy JTF_DATE_TABLE
137 , p11_a17 out nocopy JTF_NUMBER_TABLE
138 , p11_a18 out nocopy JTF_DATE_TABLE
139 , p11_a19 out nocopy JTF_NUMBER_TABLE
140 , p11_a20 out nocopy JTF_VARCHAR2_TABLE_100
141 , p11_a21 out nocopy JTF_VARCHAR2_TABLE_500
142 , p11_a22 out nocopy JTF_VARCHAR2_TABLE_500
143 , p11_a23 out nocopy JTF_VARCHAR2_TABLE_500
144 , p11_a24 out nocopy JTF_VARCHAR2_TABLE_500
145 , p11_a25 out nocopy JTF_VARCHAR2_TABLE_500
146 , p11_a26 out nocopy JTF_VARCHAR2_TABLE_500
147 , p11_a27 out nocopy JTF_VARCHAR2_TABLE_500
148 , p11_a28 out nocopy JTF_VARCHAR2_TABLE_500
149 , p11_a29 out nocopy JTF_VARCHAR2_TABLE_500
150 , p11_a30 out nocopy JTF_VARCHAR2_TABLE_500
151 , p11_a31 out nocopy JTF_VARCHAR2_TABLE_500
152 , p11_a32 out nocopy JTF_VARCHAR2_TABLE_500
153 , p11_a33 out nocopy JTF_VARCHAR2_TABLE_500
154 , p11_a34 out nocopy JTF_VARCHAR2_TABLE_500
155 , p11_a35 out nocopy JTF_VARCHAR2_TABLE_500
156 );
157 procedure get_version(p_api_version NUMBER
158 , p_init_msg_list VARCHAR2
159 , x_return_status out nocopy VARCHAR2
160 , x_msg_count out nocopy NUMBER
161 , x_msg_data out nocopy VARCHAR2
162 , p_srt_id NUMBER
163 , p6_a0 out nocopy NUMBER
164 , p6_a1 out nocopy VARCHAR2
165 , p6_a2 out nocopy VARCHAR2
166 , p6_a3 out nocopy NUMBER
167 , p6_a4 out nocopy NUMBER
168 , p6_a5 out nocopy VARCHAR2
169 , p6_a6 out nocopy VARCHAR2
170 , p6_a7 out nocopy VARCHAR2
171 , p6_a8 out nocopy NUMBER
172 , p6_a9 out nocopy VARCHAR2
173 , p6_a10 out nocopy VARCHAR2
174 , p6_a11 out nocopy NUMBER
175 , p6_a12 out nocopy VARCHAR2
176 , p6_a13 out nocopy VARCHAR2
177 , p6_a14 out nocopy DATE
178 , p6_a15 out nocopy DATE
179 , p6_a16 out nocopy NUMBER
180 , p6_a17 out nocopy VARCHAR2
181 , p6_a18 out nocopy VARCHAR2
182 , p6_a19 out nocopy VARCHAR2
183 , p6_a20 out nocopy VARCHAR2
184 , p6_a21 out nocopy VARCHAR2
185 , p6_a22 out nocopy VARCHAR2
186 , p6_a23 out nocopy VARCHAR2
187 , p6_a24 out nocopy VARCHAR2
188 , p6_a25 out nocopy VARCHAR2
189 , p6_a26 out nocopy VARCHAR2
190 , p6_a27 out nocopy VARCHAR2
191 , p6_a28 out nocopy VARCHAR2
192 , p6_a29 out nocopy VARCHAR2
193 , p6_a30 out nocopy VARCHAR2
194 , p6_a31 out nocopy VARCHAR2
195 , p6_a32 out nocopy VARCHAR2
196 , p6_a33 out nocopy NUMBER
197 , p6_a34 out nocopy DATE
198 , p6_a35 out nocopy NUMBER
199 , p6_a36 out nocopy DATE
200 , p6_a37 out nocopy NUMBER
201 , p7_a0 out nocopy NUMBER
202 , p7_a1 out nocopy NUMBER
203 , p7_a2 out nocopy VARCHAR2
204 , p7_a3 out nocopy NUMBER
205 , p7_a4 out nocopy DATE
206 , p7_a5 out nocopy DATE
207 , p7_a6 out nocopy VARCHAR2
208 , p7_a7 out nocopy NUMBER
209 , p7_a8 out nocopy NUMBER
210 , p7_a9 out nocopy NUMBER
211 , p7_a10 out nocopy VARCHAR2
212 , p7_a11 out nocopy NUMBER
213 , p7_a12 out nocopy NUMBER
214 , p7_a13 out nocopy VARCHAR2
215 , p7_a14 out nocopy VARCHAR2
216 , p7_a15 out nocopy VARCHAR2
217 , p7_a16 out nocopy VARCHAR2
218 , p7_a17 out nocopy VARCHAR2
219 , p7_a18 out nocopy VARCHAR2
220 , p7_a19 out nocopy VARCHAR2
221 , p7_a20 out nocopy VARCHAR2
222 , p7_a21 out nocopy VARCHAR2
223 , p7_a22 out nocopy VARCHAR2
224 , p7_a23 out nocopy VARCHAR2
225 , p7_a24 out nocopy VARCHAR2
226 , p7_a25 out nocopy VARCHAR2
227 , p7_a26 out nocopy VARCHAR2
228 , p7_a27 out nocopy VARCHAR2
229 , p7_a28 out nocopy VARCHAR2
230 , p7_a29 out nocopy NUMBER
231 , p7_a30 out nocopy DATE
232 , p7_a31 out nocopy NUMBER
233 , p7_a32 out nocopy DATE
234 , p7_a33 out nocopy NUMBER
235 , p8_a0 out nocopy NUMBER
236 , p8_a1 out nocopy NUMBER
237 , p8_a2 out nocopy NUMBER
238 , p8_a3 out nocopy VARCHAR2
239 , p8_a4 out nocopy VARCHAR2
240 , p8_a5 out nocopy VARCHAR2
241 , p8_a6 out nocopy NUMBER
242 , p8_a7 out nocopy DATE
243 , p8_a8 out nocopy NUMBER
244 , p8_a9 out nocopy DATE
245 , p8_a10 out nocopy NUMBER
246 , p9_a0 out nocopy JTF_NUMBER_TABLE
247 , p9_a1 out nocopy JTF_NUMBER_TABLE
248 , p9_a2 out nocopy JTF_NUMBER_TABLE
249 , p9_a3 out nocopy JTF_NUMBER_TABLE
250 , p9_a4 out nocopy JTF_DATE_TABLE
251 , p9_a5 out nocopy JTF_DATE_TABLE
252 , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
253 , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
254 , p9_a8 out nocopy JTF_NUMBER_TABLE
255 , p9_a9 out nocopy JTF_DATE_TABLE
256 , p9_a10 out nocopy JTF_NUMBER_TABLE
257 , p9_a11 out nocopy JTF_DATE_TABLE
258 , p9_a12 out nocopy JTF_NUMBER_TABLE
259 , p10_a0 out nocopy JTF_NUMBER_TABLE
260 , p10_a1 out nocopy JTF_NUMBER_TABLE
261 , p10_a2 out nocopy JTF_NUMBER_TABLE
262 , p10_a3 out nocopy JTF_VARCHAR2_TABLE_100
263 , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
264 , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
265 , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
266 , p10_a7 out nocopy JTF_VARCHAR2_TABLE_300
267 , p10_a8 out nocopy JTF_VARCHAR2_TABLE_300
268 , p10_a9 out nocopy JTF_NUMBER_TABLE
269 , p10_a10 out nocopy JTF_NUMBER_TABLE
270 , p10_a11 out nocopy JTF_DATE_TABLE
271 , p10_a12 out nocopy JTF_DATE_TABLE
272 , p10_a13 out nocopy JTF_VARCHAR2_TABLE_100
273 , p10_a14 out nocopy JTF_NUMBER_TABLE
274 , p10_a15 out nocopy JTF_NUMBER_TABLE
275 , p10_a16 out nocopy JTF_DATE_TABLE
276 , p10_a17 out nocopy JTF_NUMBER_TABLE
277 , p10_a18 out nocopy JTF_DATE_TABLE
278 , p10_a19 out nocopy JTF_NUMBER_TABLE
279 , p10_a20 out nocopy JTF_VARCHAR2_TABLE_100
280 , p10_a21 out nocopy JTF_VARCHAR2_TABLE_500
281 , p10_a22 out nocopy JTF_VARCHAR2_TABLE_500
282 , p10_a23 out nocopy JTF_VARCHAR2_TABLE_500
283 , p10_a24 out nocopy JTF_VARCHAR2_TABLE_500
284 , p10_a25 out nocopy JTF_VARCHAR2_TABLE_500
285 , p10_a26 out nocopy JTF_VARCHAR2_TABLE_500
286 , p10_a27 out nocopy JTF_VARCHAR2_TABLE_500
287 , p10_a28 out nocopy JTF_VARCHAR2_TABLE_500
288 , p10_a29 out nocopy JTF_VARCHAR2_TABLE_500
289 , p10_a30 out nocopy JTF_VARCHAR2_TABLE_500
290 , p10_a31 out nocopy JTF_VARCHAR2_TABLE_500
291 , p10_a32 out nocopy JTF_VARCHAR2_TABLE_500
292 , p10_a33 out nocopy JTF_VARCHAR2_TABLE_500
293 , p10_a34 out nocopy JTF_VARCHAR2_TABLE_500
294 , p10_a35 out nocopy JTF_VARCHAR2_TABLE_500
295 );
296 procedure create_version(p_api_version NUMBER
297 , p_init_msg_list VARCHAR2
298 , x_return_status out nocopy VARCHAR2
299 , x_msg_count out nocopy NUMBER
300 , x_msg_data out nocopy VARCHAR2
301 , p5_a0 NUMBER
302 , p5_a1 NUMBER
303 , p5_a2 VARCHAR2
304 , p5_a3 NUMBER
305 , p5_a4 DATE
306 , p5_a5 DATE
307 , p5_a6 VARCHAR2
308 , p5_a7 NUMBER
309 , p5_a8 NUMBER
310 , p5_a9 NUMBER
311 , p5_a10 VARCHAR2
312 , p5_a11 NUMBER
313 , p5_a12 NUMBER
314 , p5_a13 VARCHAR2
315 , p5_a14 VARCHAR2
316 , p5_a15 VARCHAR2
317 , p5_a16 VARCHAR2
318 , p5_a17 VARCHAR2
319 , p5_a18 VARCHAR2
320 , p5_a19 VARCHAR2
321 , p5_a20 VARCHAR2
322 , p5_a21 VARCHAR2
323 , p5_a22 VARCHAR2
324 , p5_a23 VARCHAR2
325 , p5_a24 VARCHAR2
326 , p5_a25 VARCHAR2
327 , p5_a26 VARCHAR2
328 , p5_a27 VARCHAR2
329 , p5_a28 VARCHAR2
330 , p5_a29 NUMBER
331 , p5_a30 DATE
332 , p5_a31 NUMBER
333 , p5_a32 DATE
334 , p5_a33 NUMBER
335 , p6_a0 out nocopy NUMBER
336 , p6_a1 out nocopy NUMBER
337 , p6_a2 out nocopy VARCHAR2
338 , p6_a3 out nocopy NUMBER
339 , p6_a4 out nocopy DATE
340 , p6_a5 out nocopy DATE
341 , p6_a6 out nocopy VARCHAR2
342 , p6_a7 out nocopy NUMBER
343 , p6_a8 out nocopy NUMBER
344 , p6_a9 out nocopy NUMBER
345 , p6_a10 out nocopy VARCHAR2
346 , p6_a11 out nocopy NUMBER
347 , p6_a12 out nocopy NUMBER
348 , p6_a13 out nocopy VARCHAR2
349 , p6_a14 out nocopy VARCHAR2
350 , p6_a15 out nocopy VARCHAR2
351 , p6_a16 out nocopy VARCHAR2
352 , p6_a17 out nocopy VARCHAR2
353 , p6_a18 out nocopy VARCHAR2
354 , p6_a19 out nocopy VARCHAR2
355 , p6_a20 out nocopy VARCHAR2
356 , p6_a21 out nocopy VARCHAR2
357 , p6_a22 out nocopy VARCHAR2
358 , p6_a23 out nocopy VARCHAR2
359 , p6_a24 out nocopy VARCHAR2
360 , p6_a25 out nocopy VARCHAR2
361 , p6_a26 out nocopy VARCHAR2
362 , p6_a27 out nocopy VARCHAR2
363 , p6_a28 out nocopy VARCHAR2
364 , p6_a29 out nocopy NUMBER
365 , p6_a30 out nocopy DATE
366 , p6_a31 out nocopy NUMBER
367 , p6_a32 out nocopy DATE
368 , p6_a33 out nocopy NUMBER
369 );
370 procedure insert_srt(p_api_version NUMBER
371 , p_init_msg_list VARCHAR2
372 , x_return_status out nocopy VARCHAR2
373 , x_msg_count out nocopy NUMBER
374 , x_msg_data out nocopy VARCHAR2
375 , p5_a0 NUMBER
376 , p5_a1 VARCHAR2
377 , p5_a2 VARCHAR2
378 , p5_a3 NUMBER
379 , p5_a4 NUMBER
380 , p5_a5 VARCHAR2
381 , p5_a6 VARCHAR2
382 , p5_a7 VARCHAR2
383 , p5_a8 NUMBER
384 , p5_a9 VARCHAR2
385 , p5_a10 VARCHAR2
386 , p5_a11 NUMBER
387 , p5_a12 VARCHAR2
388 , p5_a13 VARCHAR2
389 , p5_a14 DATE
390 , p5_a15 DATE
391 , p5_a16 NUMBER
392 , p5_a17 VARCHAR2
393 , p5_a18 VARCHAR2
394 , p5_a19 VARCHAR2
395 , p5_a20 VARCHAR2
396 , p5_a21 VARCHAR2
397 , p5_a22 VARCHAR2
398 , p5_a23 VARCHAR2
399 , p5_a24 VARCHAR2
400 , p5_a25 VARCHAR2
401 , p5_a26 VARCHAR2
402 , p5_a27 VARCHAR2
403 , p5_a28 VARCHAR2
404 , p5_a29 VARCHAR2
405 , p5_a30 VARCHAR2
406 , p5_a31 VARCHAR2
407 , p5_a32 VARCHAR2
408 , p5_a33 NUMBER
409 , p5_a34 DATE
410 , p5_a35 NUMBER
411 , p5_a36 DATE
412 , p5_a37 NUMBER
413 , p6_a0 NUMBER
414 , p6_a1 NUMBER
415 , p6_a2 VARCHAR2
416 , p6_a3 NUMBER
417 , p6_a4 DATE
418 , p6_a5 DATE
419 , p6_a6 VARCHAR2
420 , p6_a7 NUMBER
421 , p6_a8 NUMBER
422 , p6_a9 NUMBER
423 , p6_a10 VARCHAR2
424 , p6_a11 NUMBER
425 , p6_a12 NUMBER
426 , p6_a13 VARCHAR2
427 , p6_a14 VARCHAR2
428 , p6_a15 VARCHAR2
429 , p6_a16 VARCHAR2
430 , p6_a17 VARCHAR2
431 , p6_a18 VARCHAR2
432 , p6_a19 VARCHAR2
433 , p6_a20 VARCHAR2
434 , p6_a21 VARCHAR2
435 , p6_a22 VARCHAR2
436 , p6_a23 VARCHAR2
437 , p6_a24 VARCHAR2
438 , p6_a25 VARCHAR2
439 , p6_a26 VARCHAR2
440 , p6_a27 VARCHAR2
441 , p6_a28 VARCHAR2
442 , p6_a29 NUMBER
443 , p6_a30 DATE
444 , p6_a31 NUMBER
445 , p6_a32 DATE
446 , p6_a33 NUMBER
447 , p7_a0 out nocopy NUMBER
448 , p7_a1 out nocopy VARCHAR2
449 , p7_a2 out nocopy VARCHAR2
450 , p7_a3 out nocopy NUMBER
451 , p7_a4 out nocopy NUMBER
452 , p7_a5 out nocopy VARCHAR2
453 , p7_a6 out nocopy VARCHAR2
454 , p7_a7 out nocopy VARCHAR2
455 , p7_a8 out nocopy NUMBER
456 , p7_a9 out nocopy VARCHAR2
457 , p7_a10 out nocopy VARCHAR2
458 , p7_a11 out nocopy NUMBER
459 , p7_a12 out nocopy VARCHAR2
460 , p7_a13 out nocopy VARCHAR2
461 , p7_a14 out nocopy DATE
462 , p7_a15 out nocopy DATE
463 , p7_a16 out nocopy NUMBER
464 , p7_a17 out nocopy VARCHAR2
465 , p7_a18 out nocopy VARCHAR2
466 , p7_a19 out nocopy VARCHAR2
467 , p7_a20 out nocopy VARCHAR2
468 , p7_a21 out nocopy VARCHAR2
469 , p7_a22 out nocopy VARCHAR2
470 , p7_a23 out nocopy VARCHAR2
471 , p7_a24 out nocopy VARCHAR2
472 , p7_a25 out nocopy VARCHAR2
473 , p7_a26 out nocopy VARCHAR2
474 , p7_a27 out nocopy VARCHAR2
475 , p7_a28 out nocopy VARCHAR2
476 , p7_a29 out nocopy VARCHAR2
477 , p7_a30 out nocopy VARCHAR2
478 , p7_a31 out nocopy VARCHAR2
479 , p7_a32 out nocopy VARCHAR2
480 , p7_a33 out nocopy NUMBER
481 , p7_a34 out nocopy DATE
482 , p7_a35 out nocopy NUMBER
483 , p7_a36 out nocopy DATE
484 , p7_a37 out nocopy NUMBER
485 , p8_a0 out nocopy NUMBER
486 , p8_a1 out nocopy NUMBER
487 , p8_a2 out nocopy VARCHAR2
488 , p8_a3 out nocopy NUMBER
489 , p8_a4 out nocopy DATE
490 , p8_a5 out nocopy DATE
491 , p8_a6 out nocopy VARCHAR2
492 , p8_a7 out nocopy NUMBER
493 , p8_a8 out nocopy NUMBER
494 , p8_a9 out nocopy NUMBER
495 , p8_a10 out nocopy VARCHAR2
496 , p8_a11 out nocopy NUMBER
497 , p8_a12 out nocopy NUMBER
498 , p8_a13 out nocopy VARCHAR2
499 , p8_a14 out nocopy VARCHAR2
500 , p8_a15 out nocopy VARCHAR2
501 , p8_a16 out nocopy VARCHAR2
502 , p8_a17 out nocopy VARCHAR2
503 , p8_a18 out nocopy VARCHAR2
504 , p8_a19 out nocopy VARCHAR2
505 , p8_a20 out nocopy VARCHAR2
506 , p8_a21 out nocopy VARCHAR2
507 , p8_a22 out nocopy VARCHAR2
508 , p8_a23 out nocopy VARCHAR2
509 , p8_a24 out nocopy VARCHAR2
510 , p8_a25 out nocopy VARCHAR2
511 , p8_a26 out nocopy VARCHAR2
512 , p8_a27 out nocopy VARCHAR2
513 , p8_a28 out nocopy VARCHAR2
514 , p8_a29 out nocopy NUMBER
515 , p8_a30 out nocopy DATE
516 , p8_a31 out nocopy NUMBER
517 , p8_a32 out nocopy DATE
518 , p8_a33 out nocopy NUMBER
519 );
520 procedure update_srt(p_api_version NUMBER
521 , p_init_msg_list VARCHAR2
522 , x_return_status out nocopy VARCHAR2
523 , x_msg_count out nocopy NUMBER
524 , x_msg_data out nocopy VARCHAR2
525 , p5_a0 NUMBER
526 , p5_a1 NUMBER
527 , p5_a2 VARCHAR2
528 , p5_a3 NUMBER
529 , p5_a4 DATE
530 , p5_a5 DATE
531 , p5_a6 VARCHAR2
532 , p5_a7 NUMBER
533 , p5_a8 NUMBER
534 , p5_a9 NUMBER
535 , p5_a10 VARCHAR2
536 , p5_a11 NUMBER
537 , p5_a12 NUMBER
538 , p5_a13 VARCHAR2
539 , p5_a14 VARCHAR2
540 , p5_a15 VARCHAR2
541 , p5_a16 VARCHAR2
542 , p5_a17 VARCHAR2
543 , p5_a18 VARCHAR2
544 , p5_a19 VARCHAR2
545 , p5_a20 VARCHAR2
546 , p5_a21 VARCHAR2
547 , p5_a22 VARCHAR2
548 , p5_a23 VARCHAR2
549 , p5_a24 VARCHAR2
550 , p5_a25 VARCHAR2
551 , p5_a26 VARCHAR2
552 , p5_a27 VARCHAR2
553 , p5_a28 VARCHAR2
554 , p5_a29 NUMBER
555 , p5_a30 DATE
556 , p5_a31 NUMBER
557 , p5_a32 DATE
558 , p5_a33 NUMBER
559 , p6_a0 out nocopy NUMBER
560 , p6_a1 out nocopy NUMBER
561 , p6_a2 out nocopy VARCHAR2
562 , p6_a3 out nocopy NUMBER
563 , p6_a4 out nocopy DATE
564 , p6_a5 out nocopy DATE
565 , p6_a6 out nocopy VARCHAR2
566 , p6_a7 out nocopy NUMBER
567 , p6_a8 out nocopy NUMBER
568 , p6_a9 out nocopy NUMBER
569 , p6_a10 out nocopy VARCHAR2
570 , p6_a11 out nocopy NUMBER
571 , p6_a12 out nocopy NUMBER
572 , p6_a13 out nocopy VARCHAR2
573 , p6_a14 out nocopy VARCHAR2
574 , p6_a15 out nocopy VARCHAR2
575 , p6_a16 out nocopy VARCHAR2
576 , p6_a17 out nocopy VARCHAR2
577 , p6_a18 out nocopy VARCHAR2
578 , p6_a19 out nocopy VARCHAR2
579 , p6_a20 out nocopy VARCHAR2
580 , p6_a21 out nocopy VARCHAR2
581 , p6_a22 out nocopy VARCHAR2
582 , p6_a23 out nocopy VARCHAR2
583 , p6_a24 out nocopy VARCHAR2
584 , p6_a25 out nocopy VARCHAR2
585 , p6_a26 out nocopy VARCHAR2
586 , p6_a27 out nocopy VARCHAR2
587 , p6_a28 out nocopy VARCHAR2
588 , p6_a29 out nocopy NUMBER
589 , p6_a30 out nocopy DATE
590 , p6_a31 out nocopy NUMBER
591 , p6_a32 out nocopy DATE
592 , p6_a33 out nocopy NUMBER
593 );
594 procedure invalid_objects(p_api_version NUMBER
595 , p_init_msg_list VARCHAR2
596 , x_return_status out nocopy VARCHAR2
597 , x_msg_count out nocopy NUMBER
598 , x_msg_data out nocopy VARCHAR2
599 , p_version_id NUMBER
600 , p6_a0 out nocopy JTF_NUMBER_TABLE
601 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
602 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
603 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
604 );
605 procedure calc_start_date(p_api_version NUMBER
606 , p_init_msg_list VARCHAR2
607 , x_return_status out nocopy VARCHAR2
608 , x_msg_count out nocopy NUMBER
609 , x_msg_data out nocopy VARCHAR2
610 , p5_a0 NUMBER
611 , p5_a1 NUMBER
612 , p5_a2 VARCHAR2
613 , p5_a3 NUMBER
614 , p5_a4 DATE
615 , p5_a5 DATE
616 , p5_a6 VARCHAR2
617 , p5_a7 NUMBER
618 , p5_a8 NUMBER
619 , p5_a9 NUMBER
620 , p5_a10 VARCHAR2
621 , p5_a11 NUMBER
622 , p5_a12 NUMBER
623 , p5_a13 VARCHAR2
624 , p5_a14 VARCHAR2
625 , p5_a15 VARCHAR2
626 , p5_a16 VARCHAR2
627 , p5_a17 VARCHAR2
628 , p5_a18 VARCHAR2
629 , p5_a19 VARCHAR2
630 , p5_a20 VARCHAR2
631 , p5_a21 VARCHAR2
632 , p5_a22 VARCHAR2
633 , p5_a23 VARCHAR2
634 , p5_a24 VARCHAR2
635 , p5_a25 VARCHAR2
636 , p5_a26 VARCHAR2
637 , p5_a27 VARCHAR2
638 , p5_a28 VARCHAR2
639 , p5_a29 NUMBER
640 , p5_a30 DATE
641 , p5_a31 NUMBER
642 , p5_a32 DATE
643 , p5_a33 NUMBER
644 , x_cal_eff_from out nocopy DATE
645 );
646 procedure enddate_std_rate_tmpl(p_api_version NUMBER
647 , p_init_msg_list VARCHAR2
648 , x_return_status out nocopy VARCHAR2
649 , x_msg_count out nocopy NUMBER
650 , x_msg_data out nocopy VARCHAR2
651 , p_srv_id_tbl JTF_NUMBER_TABLE
652 , p_end_date DATE
653 );
654 end okl_fe_std_rate_tmpl_pvt_w;