[Home] [Help]
PACKAGE: APPS.OKL_K_RATE_PARAMS_PVT_W
Source
1 package okl_k_rate_params_pvt_w as
2 /* $Header: OKLUKRPS.pls 120.2 2005/11/22 23:40:37 ramurt noship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy okl_k_rate_params_pvt.krpdel_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_VARCHAR2_TABLE_100
5 , a2 JTF_DATE_TABLE
6 );
7 procedure rosetta_table_copy_out_p1(t okl_k_rate_params_pvt.krpdel_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
8 , a1 out nocopy JTF_VARCHAR2_TABLE_100
9 , a2 out nocopy JTF_DATE_TABLE
10 );
11
12 procedure rosetta_table_copy_in_p6(t out nocopy okl_k_rate_params_pvt.var_prm_tbl_type, a0 JTF_VARCHAR2_TABLE_100
13 , a1 JTF_VARCHAR2_TABLE_100
14 , a2 JTF_VARCHAR2_TABLE_100
15 , a3 JTF_NUMBER_TABLE
16 , a4 JTF_DATE_TABLE
17 , a5 JTF_DATE_TABLE
18 );
19 procedure rosetta_table_copy_out_p6(t okl_k_rate_params_pvt.var_prm_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
20 , a1 out nocopy JTF_VARCHAR2_TABLE_100
21 , a2 out nocopy JTF_VARCHAR2_TABLE_100
22 , a3 out nocopy JTF_NUMBER_TABLE
23 , a4 out nocopy JTF_DATE_TABLE
24 , a5 out nocopy JTF_DATE_TABLE
25 );
26
27 procedure get_product(p_api_version NUMBER
28 , p_init_msg_list VARCHAR2
29 , x_return_status out nocopy VARCHAR2
30 , x_msg_count out nocopy NUMBER
31 , x_msg_data out nocopy VARCHAR2
32 , p_khr_id NUMBER
33 , p6_a0 out nocopy NUMBER
34 , p6_a1 out nocopy VARCHAR2
35 , p6_a2 out nocopy DATE
36 , p6_a3 out nocopy DATE
37 , p6_a4 out nocopy VARCHAR2
38 , p6_a5 out nocopy NUMBER
39 , p6_a6 out nocopy NUMBER
40 , p6_a7 out nocopy NUMBER
41 , p6_a8 out nocopy VARCHAR2
42 , p6_a9 out nocopy VARCHAR2
43 , p6_a10 out nocopy VARCHAR2
44 , p6_a11 out nocopy VARCHAR2
45 , p6_a12 out nocopy VARCHAR2
46 , p6_a13 out nocopy VARCHAR2
47 , p6_a14 out nocopy VARCHAR2
48 , p6_a15 out nocopy VARCHAR2
49 , p6_a16 out nocopy VARCHAR2
50 , p6_a17 out nocopy VARCHAR2
51 , p6_a18 out nocopy VARCHAR2
52 , p6_a19 out nocopy VARCHAR2
53 , p6_a20 out nocopy VARCHAR2
54 , p6_a21 out nocopy VARCHAR2
55 , p6_a22 out nocopy VARCHAR2
56 , p6_a23 out nocopy VARCHAR2
57 , p6_a24 out nocopy VARCHAR2
58 , p6_a25 out nocopy VARCHAR2
59 , p6_a26 out nocopy VARCHAR2
60 , p6_a27 out nocopy VARCHAR2
61 , p6_a28 out nocopy VARCHAR2
62 , p6_a29 out nocopy VARCHAR2
63 , p6_a30 out nocopy NUMBER
64 , p6_a31 out nocopy VARCHAR2
65 );
66 procedure create_k_rate_params(p_api_version NUMBER
67 , p_init_msg_list VARCHAR2
68 , x_return_status out nocopy VARCHAR2
69 , x_msg_count out nocopy NUMBER
70 , x_msg_data out nocopy VARCHAR2
71 , p6_a0 out nocopy NUMBER
72 , p6_a1 out nocopy VARCHAR2
73 , p6_a2 out nocopy DATE
74 , p6_a3 out nocopy DATE
75 , p6_a4 out nocopy NUMBER
76 , p6_a5 out nocopy NUMBER
77 , p6_a6 out nocopy DATE
78 , p6_a7 out nocopy NUMBER
79 , p6_a8 out nocopy NUMBER
80 , p6_a9 out nocopy NUMBER
81 , p6_a10 out nocopy VARCHAR2
82 , p6_a11 out nocopy VARCHAR2
83 , p6_a12 out nocopy VARCHAR2
84 , p6_a13 out nocopy VARCHAR2
85 , p6_a14 out nocopy VARCHAR2
86 , p6_a15 out nocopy NUMBER
87 , p6_a16 out nocopy VARCHAR2
88 , p6_a17 out nocopy NUMBER
89 , p6_a18 out nocopy VARCHAR2
90 , p6_a19 out nocopy DATE
91 , p6_a20 out nocopy VARCHAR2
92 , p6_a21 out nocopy DATE
93 , p6_a22 out nocopy VARCHAR2
94 , p6_a23 out nocopy NUMBER
95 , p6_a24 out nocopy VARCHAR2
96 , p6_a25 out nocopy DATE
97 , p6_a26 out nocopy VARCHAR2
98 , p6_a27 out nocopy VARCHAR2
99 , p6_a28 out nocopy VARCHAR2
100 , p6_a29 out nocopy VARCHAR2
101 , p6_a30 out nocopy VARCHAR2
102 , p6_a31 out nocopy VARCHAR2
103 , p6_a32 out nocopy VARCHAR2
104 , p6_a33 out nocopy VARCHAR2
105 , p6_a34 out nocopy VARCHAR2
106 , p6_a35 out nocopy VARCHAR2
107 , p6_a36 out nocopy VARCHAR2
108 , p6_a37 out nocopy VARCHAR2
109 , p6_a38 out nocopy VARCHAR2
110 , p6_a39 out nocopy VARCHAR2
111 , p6_a40 out nocopy VARCHAR2
112 , p6_a41 out nocopy VARCHAR2
113 , p6_a42 out nocopy VARCHAR2
114 , p6_a43 out nocopy NUMBER
115 , p6_a44 out nocopy DATE
116 , p6_a45 out nocopy NUMBER
117 , p6_a46 out nocopy DATE
118 , p6_a47 out nocopy NUMBER
119 , p6_a48 out nocopy VARCHAR2
120 , p_validate_flag VARCHAR2
121 , p5_a0 NUMBER := 0-1962.0724
122 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
123 , p5_a2 DATE := fnd_api.g_miss_date
124 , p5_a3 DATE := fnd_api.g_miss_date
125 , p5_a4 NUMBER := 0-1962.0724
126 , p5_a5 NUMBER := 0-1962.0724
127 , p5_a6 DATE := fnd_api.g_miss_date
128 , p5_a7 NUMBER := 0-1962.0724
129 , p5_a8 NUMBER := 0-1962.0724
130 , p5_a9 NUMBER := 0-1962.0724
131 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
132 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
133 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
134 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
135 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
136 , p5_a15 NUMBER := 0-1962.0724
137 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
138 , p5_a17 NUMBER := 0-1962.0724
139 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
140 , p5_a19 DATE := fnd_api.g_miss_date
141 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
142 , p5_a21 DATE := fnd_api.g_miss_date
143 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
144 , p5_a23 NUMBER := 0-1962.0724
145 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
146 , p5_a25 DATE := fnd_api.g_miss_date
147 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
148 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
149 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
150 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
151 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
152 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
153 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
154 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
155 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
156 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
157 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
158 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
159 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
160 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
161 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
162 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
163 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
164 , p5_a43 NUMBER := 0-1962.0724
165 , p5_a44 DATE := fnd_api.g_miss_date
166 , p5_a45 NUMBER := 0-1962.0724
167 , p5_a46 DATE := fnd_api.g_miss_date
168 , p5_a47 NUMBER := 0-1962.0724
169 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
170 );
171 procedure create_k_rate_params(p_api_version NUMBER
172 , p_init_msg_list VARCHAR2
173 , x_return_status out nocopy VARCHAR2
174 , x_msg_count out nocopy NUMBER
175 , x_msg_data out nocopy VARCHAR2
176 , p6_a0 out nocopy NUMBER
177 , p6_a1 out nocopy VARCHAR2
178 , p6_a2 out nocopy DATE
179 , p6_a3 out nocopy DATE
180 , p6_a4 out nocopy NUMBER
181 , p6_a5 out nocopy NUMBER
182 , p6_a6 out nocopy DATE
183 , p6_a7 out nocopy NUMBER
184 , p6_a8 out nocopy NUMBER
185 , p6_a9 out nocopy NUMBER
186 , p6_a10 out nocopy VARCHAR2
187 , p6_a11 out nocopy VARCHAR2
188 , p6_a12 out nocopy VARCHAR2
189 , p6_a13 out nocopy VARCHAR2
190 , p5_a0 NUMBER := 0-1962.0724
191 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
192 , p5_a2 DATE := fnd_api.g_miss_date
193 , p5_a3 DATE := fnd_api.g_miss_date
194 , p5_a4 NUMBER := 0-1962.0724
195 , p5_a5 NUMBER := 0-1962.0724
196 , p5_a6 DATE := fnd_api.g_miss_date
197 , p5_a7 NUMBER := 0-1962.0724
198 , p5_a8 NUMBER := 0-1962.0724
199 , p5_a9 NUMBER := 0-1962.0724
200 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
201 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
202 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
203 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
204 );
205 procedure create_k_rate_params(p_api_version NUMBER
206 , p_init_msg_list VARCHAR2
207 , x_return_status out nocopy VARCHAR2
208 , x_msg_count out nocopy NUMBER
209 , x_msg_data out nocopy VARCHAR2
210 , p6_a0 out nocopy NUMBER
211 , p6_a1 out nocopy VARCHAR2
212 , p6_a2 out nocopy DATE
213 , p6_a3 out nocopy DATE
214 , p6_a4 out nocopy VARCHAR2
215 , p6_a5 out nocopy NUMBER
216 , p6_a6 out nocopy VARCHAR2
217 , p6_a7 out nocopy NUMBER
218 , p6_a8 out nocopy VARCHAR2
219 , p6_a9 out nocopy DATE
220 , p6_a10 out nocopy VARCHAR2
221 , p6_a11 out nocopy DATE
222 , p6_a12 out nocopy VARCHAR2
223 , p6_a13 out nocopy NUMBER
224 , p5_a0 NUMBER := 0-1962.0724
225 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
226 , p5_a2 DATE := fnd_api.g_miss_date
227 , p5_a3 DATE := fnd_api.g_miss_date
228 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
229 , p5_a5 NUMBER := 0-1962.0724
230 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
231 , p5_a7 NUMBER := 0-1962.0724
232 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
233 , p5_a9 DATE := fnd_api.g_miss_date
234 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
235 , p5_a11 DATE := fnd_api.g_miss_date
236 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
237 , p5_a13 NUMBER := 0-1962.0724
238 );
239 procedure create_k_rate_params(p_api_version NUMBER
240 , p_init_msg_list VARCHAR2
241 , x_return_status out nocopy VARCHAR2
242 , x_msg_count out nocopy NUMBER
243 , x_msg_data out nocopy VARCHAR2
244 , p6_a0 out nocopy NUMBER
245 , p6_a1 out nocopy VARCHAR2
246 , p6_a2 out nocopy DATE
247 , p6_a3 out nocopy DATE
248 , p6_a4 out nocopy VARCHAR2
249 , p6_a5 out nocopy DATE
250 , p6_a6 out nocopy VARCHAR2
251 , p5_a0 NUMBER := 0-1962.0724
252 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
253 , p5_a2 DATE := fnd_api.g_miss_date
254 , p5_a3 DATE := fnd_api.g_miss_date
255 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
256 , p5_a5 DATE := fnd_api.g_miss_date
257 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
258 );
259 procedure update_k_rate_params(p_api_version NUMBER
260 , p_init_msg_list VARCHAR2
261 , x_return_status out nocopy VARCHAR2
262 , x_msg_count out nocopy NUMBER
263 , x_msg_data out nocopy VARCHAR2
264 , p6_a0 out nocopy NUMBER
265 , p6_a1 out nocopy VARCHAR2
266 , p6_a2 out nocopy DATE
267 , p6_a3 out nocopy DATE
268 , p6_a4 out nocopy NUMBER
269 , p6_a5 out nocopy NUMBER
270 , p6_a6 out nocopy DATE
271 , p6_a7 out nocopy NUMBER
272 , p6_a8 out nocopy NUMBER
273 , p6_a9 out nocopy NUMBER
274 , p6_a10 out nocopy VARCHAR2
275 , p6_a11 out nocopy VARCHAR2
276 , p6_a12 out nocopy VARCHAR2
277 , p6_a13 out nocopy VARCHAR2
278 , p6_a14 out nocopy VARCHAR2
279 , p6_a15 out nocopy NUMBER
280 , p6_a16 out nocopy VARCHAR2
281 , p6_a17 out nocopy NUMBER
282 , p6_a18 out nocopy VARCHAR2
283 , p6_a19 out nocopy DATE
284 , p6_a20 out nocopy VARCHAR2
285 , p6_a21 out nocopy DATE
286 , p6_a22 out nocopy VARCHAR2
287 , p6_a23 out nocopy NUMBER
288 , p6_a24 out nocopy VARCHAR2
289 , p6_a25 out nocopy DATE
290 , p6_a26 out nocopy VARCHAR2
291 , p6_a27 out nocopy VARCHAR2
292 , p6_a28 out nocopy VARCHAR2
293 , p6_a29 out nocopy VARCHAR2
294 , p6_a30 out nocopy VARCHAR2
295 , p6_a31 out nocopy VARCHAR2
296 , p6_a32 out nocopy VARCHAR2
297 , p6_a33 out nocopy VARCHAR2
298 , p6_a34 out nocopy VARCHAR2
299 , p6_a35 out nocopy VARCHAR2
300 , p6_a36 out nocopy VARCHAR2
301 , p6_a37 out nocopy VARCHAR2
302 , p6_a38 out nocopy VARCHAR2
303 , p6_a39 out nocopy VARCHAR2
304 , p6_a40 out nocopy VARCHAR2
305 , p6_a41 out nocopy VARCHAR2
306 , p6_a42 out nocopy VARCHAR2
307 , p6_a43 out nocopy NUMBER
308 , p6_a44 out nocopy DATE
309 , p6_a45 out nocopy NUMBER
310 , p6_a46 out nocopy DATE
311 , p6_a47 out nocopy NUMBER
312 , p6_a48 out nocopy VARCHAR2
313 , p5_a0 NUMBER := 0-1962.0724
314 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
315 , p5_a2 DATE := fnd_api.g_miss_date
316 , p5_a3 DATE := fnd_api.g_miss_date
317 , p5_a4 NUMBER := 0-1962.0724
318 , p5_a5 NUMBER := 0-1962.0724
319 , p5_a6 DATE := fnd_api.g_miss_date
320 , p5_a7 NUMBER := 0-1962.0724
321 , p5_a8 NUMBER := 0-1962.0724
322 , p5_a9 NUMBER := 0-1962.0724
323 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
324 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
325 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
326 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
327 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
328 , p5_a15 NUMBER := 0-1962.0724
329 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
330 , p5_a17 NUMBER := 0-1962.0724
331 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
332 , p5_a19 DATE := fnd_api.g_miss_date
333 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
334 , p5_a21 DATE := fnd_api.g_miss_date
335 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
336 , p5_a23 NUMBER := 0-1962.0724
337 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
338 , p5_a25 DATE := fnd_api.g_miss_date
339 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
340 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
341 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
342 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
343 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
344 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
345 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
346 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
347 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
348 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
349 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
350 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
351 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
352 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
353 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
354 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
355 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
356 , p5_a43 NUMBER := 0-1962.0724
357 , p5_a44 DATE := fnd_api.g_miss_date
358 , p5_a45 NUMBER := 0-1962.0724
359 , p5_a46 DATE := fnd_api.g_miss_date
360 , p5_a47 NUMBER := 0-1962.0724
361 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
362 );
363 procedure update_k_rate_params(p_api_version NUMBER
364 , p_init_msg_list VARCHAR2
365 , x_return_status out nocopy VARCHAR2
366 , x_msg_count out nocopy NUMBER
367 , x_msg_data out nocopy VARCHAR2
368 , p6_a0 out nocopy NUMBER
369 , p6_a1 out nocopy VARCHAR2
370 , p6_a2 out nocopy DATE
371 , p6_a3 out nocopy DATE
372 , p6_a4 out nocopy NUMBER
373 , p6_a5 out nocopy NUMBER
374 , p6_a6 out nocopy DATE
375 , p6_a7 out nocopy NUMBER
376 , p6_a8 out nocopy NUMBER
377 , p6_a9 out nocopy NUMBER
378 , p6_a10 out nocopy VARCHAR2
379 , p6_a11 out nocopy VARCHAR2
380 , p6_a12 out nocopy VARCHAR2
381 , p6_a13 out nocopy VARCHAR2
382 , p5_a0 NUMBER := 0-1962.0724
383 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
384 , p5_a2 DATE := fnd_api.g_miss_date
385 , p5_a3 DATE := fnd_api.g_miss_date
386 , p5_a4 NUMBER := 0-1962.0724
387 , p5_a5 NUMBER := 0-1962.0724
388 , p5_a6 DATE := fnd_api.g_miss_date
389 , p5_a7 NUMBER := 0-1962.0724
393 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
390 , p5_a8 NUMBER := 0-1962.0724
391 , p5_a9 NUMBER := 0-1962.0724
392 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
394 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
395 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
396 );
397 procedure update_k_rate_params(p_api_version NUMBER
398 , p_init_msg_list VARCHAR2
399 , x_return_status out nocopy VARCHAR2
400 , x_msg_count out nocopy NUMBER
401 , x_msg_data out nocopy VARCHAR2
402 , p6_a0 out nocopy NUMBER
403 , p6_a1 out nocopy VARCHAR2
404 , p6_a2 out nocopy DATE
405 , p6_a3 out nocopy DATE
406 , p6_a4 out nocopy VARCHAR2
407 , p6_a5 out nocopy NUMBER
408 , p6_a6 out nocopy VARCHAR2
409 , p6_a7 out nocopy NUMBER
410 , p6_a8 out nocopy VARCHAR2
411 , p6_a9 out nocopy DATE
412 , p6_a10 out nocopy VARCHAR2
413 , p6_a11 out nocopy DATE
414 , p6_a12 out nocopy VARCHAR2
415 , p6_a13 out nocopy NUMBER
416 , p5_a0 NUMBER := 0-1962.0724
417 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
418 , p5_a2 DATE := fnd_api.g_miss_date
419 , p5_a3 DATE := fnd_api.g_miss_date
420 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
421 , p5_a5 NUMBER := 0-1962.0724
422 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
423 , p5_a7 NUMBER := 0-1962.0724
424 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
425 , p5_a9 DATE := fnd_api.g_miss_date
426 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
427 , p5_a11 DATE := fnd_api.g_miss_date
428 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
429 , p5_a13 NUMBER := 0-1962.0724
430 );
431 procedure update_k_rate_params(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 , p6_a0 out nocopy NUMBER
437 , p6_a1 out nocopy VARCHAR2
438 , p6_a2 out nocopy DATE
439 , p6_a3 out nocopy DATE
440 , p6_a4 out nocopy VARCHAR2
441 , p6_a5 out nocopy DATE
442 , p6_a6 out nocopy VARCHAR2
443 , p5_a0 NUMBER := 0-1962.0724
444 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
445 , p5_a2 DATE := fnd_api.g_miss_date
446 , p5_a3 DATE := fnd_api.g_miss_date
447 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
448 , p5_a5 DATE := fnd_api.g_miss_date
449 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
450 );
451 procedure delete_k_rate_params(p_api_version NUMBER
452 , p_init_msg_list VARCHAR2
453 , x_return_status out nocopy VARCHAR2
454 , x_msg_count out nocopy NUMBER
455 , x_msg_data out nocopy VARCHAR2
456 , p5_a0 JTF_NUMBER_TABLE
457 , p5_a1 JTF_VARCHAR2_TABLE_100
458 , p5_a2 JTF_DATE_TABLE
459 );
460 procedure validate_k_rate_params(p_api_version NUMBER
461 , p_init_msg_list VARCHAR2
462 , x_return_status out nocopy VARCHAR2
463 , x_msg_count out nocopy NUMBER
464 , x_msg_data out nocopy VARCHAR2
465 , p_product_id NUMBER
466 , p6_a0 JTF_NUMBER_TABLE
467 , p6_a1 JTF_VARCHAR2_TABLE_100
468 , p6_a2 JTF_DATE_TABLE
469 , p6_a3 JTF_DATE_TABLE
470 , p6_a4 JTF_NUMBER_TABLE
471 , p6_a5 JTF_NUMBER_TABLE
472 , p6_a6 JTF_DATE_TABLE
473 , p6_a7 JTF_NUMBER_TABLE
474 , p6_a8 JTF_NUMBER_TABLE
475 , p6_a9 JTF_NUMBER_TABLE
476 , p6_a10 JTF_VARCHAR2_TABLE_100
477 , p6_a11 JTF_VARCHAR2_TABLE_100
478 , p6_a12 JTF_VARCHAR2_TABLE_100
479 , p6_a13 JTF_VARCHAR2_TABLE_100
480 , p6_a14 JTF_VARCHAR2_TABLE_100
481 , p6_a15 JTF_NUMBER_TABLE
482 , p6_a16 JTF_VARCHAR2_TABLE_100
483 , p6_a17 JTF_NUMBER_TABLE
484 , p6_a18 JTF_VARCHAR2_TABLE_100
485 , p6_a19 JTF_DATE_TABLE
486 , p6_a20 JTF_VARCHAR2_TABLE_100
487 , p6_a21 JTF_DATE_TABLE
488 , p6_a22 JTF_VARCHAR2_TABLE_100
489 , p6_a23 JTF_NUMBER_TABLE
490 , p6_a24 JTF_VARCHAR2_TABLE_100
491 , p6_a25 JTF_DATE_TABLE
492 , p6_a26 JTF_VARCHAR2_TABLE_100
493 , p6_a27 JTF_VARCHAR2_TABLE_100
494 , p6_a28 JTF_VARCHAR2_TABLE_500
495 , p6_a29 JTF_VARCHAR2_TABLE_500
496 , p6_a30 JTF_VARCHAR2_TABLE_500
497 , p6_a31 JTF_VARCHAR2_TABLE_500
498 , p6_a32 JTF_VARCHAR2_TABLE_500
499 , p6_a33 JTF_VARCHAR2_TABLE_500
500 , p6_a34 JTF_VARCHAR2_TABLE_500
501 , p6_a35 JTF_VARCHAR2_TABLE_500
502 , p6_a36 JTF_VARCHAR2_TABLE_500
503 , p6_a37 JTF_VARCHAR2_TABLE_500
504 , p6_a38 JTF_VARCHAR2_TABLE_500
505 , p6_a39 JTF_VARCHAR2_TABLE_500
506 , p6_a40 JTF_VARCHAR2_TABLE_500
507 , p6_a41 JTF_VARCHAR2_TABLE_500
508 , p6_a42 JTF_VARCHAR2_TABLE_500
509 , p6_a43 JTF_NUMBER_TABLE
510 , p6_a44 JTF_DATE_TABLE
511 , p6_a45 JTF_NUMBER_TABLE
512 , p6_a46 JTF_DATE_TABLE
513 , p6_a47 JTF_NUMBER_TABLE
514 , p6_a48 JTF_VARCHAR2_TABLE_100
515 );
516 procedure generate_rate_summary(p_api_version NUMBER
517 , p_init_msg_list VARCHAR2
518 , x_return_status out nocopy VARCHAR2
519 , x_msg_count out nocopy NUMBER
520 , x_msg_data out nocopy VARCHAR2
521 , p_chr_id NUMBER
522 , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
523 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
524 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
525 , p6_a3 out nocopy JTF_NUMBER_TABLE
526 , p6_a4 out nocopy JTF_DATE_TABLE
527 , p6_a5 out nocopy JTF_DATE_TABLE
528 );
529 procedure default_k_rate_params(p_api_version NUMBER
530 , p_init_msg_list VARCHAR2
531 , x_return_status out nocopy VARCHAR2
535 , p_rev_rec_method VARCHAR2
532 , x_msg_count out nocopy NUMBER
533 , x_msg_data out nocopy VARCHAR2
534 , p_deal_type VARCHAR2
536 , p_int_calc_basis VARCHAR2
537 , p_column_name VARCHAR2
538 , p9_a0 in out nocopy NUMBER
539 , p9_a1 in out nocopy VARCHAR2
540 , p9_a2 in out nocopy DATE
541 , p9_a3 in out nocopy DATE
542 , p9_a4 in out nocopy NUMBER
543 , p9_a5 in out nocopy NUMBER
544 , p9_a6 in out nocopy DATE
545 , p9_a7 in out nocopy NUMBER
546 , p9_a8 in out nocopy NUMBER
547 , p9_a9 in out nocopy NUMBER
548 , p9_a10 in out nocopy VARCHAR2
549 , p9_a11 in out nocopy VARCHAR2
550 , p9_a12 in out nocopy VARCHAR2
551 , p9_a13 in out nocopy VARCHAR2
552 , p9_a14 in out nocopy VARCHAR2
553 , p9_a15 in out nocopy NUMBER
554 , p9_a16 in out nocopy VARCHAR2
555 , p9_a17 in out nocopy NUMBER
556 , p9_a18 in out nocopy VARCHAR2
557 , p9_a19 in out nocopy DATE
558 , p9_a20 in out nocopy VARCHAR2
559 , p9_a21 in out nocopy DATE
560 , p9_a22 in out nocopy VARCHAR2
561 , p9_a23 in out nocopy NUMBER
562 , p9_a24 in out nocopy VARCHAR2
563 , p9_a25 in out nocopy DATE
564 , p9_a26 in out nocopy VARCHAR2
565 , p9_a27 in out nocopy VARCHAR2
566 , p9_a28 in out nocopy VARCHAR2
567 , p9_a29 in out nocopy VARCHAR2
568 , p9_a30 in out nocopy VARCHAR2
569 , p9_a31 in out nocopy VARCHAR2
570 , p9_a32 in out nocopy VARCHAR2
571 , p9_a33 in out nocopy VARCHAR2
572 , p9_a34 in out nocopy VARCHAR2
573 , p9_a35 in out nocopy VARCHAR2
574 , p9_a36 in out nocopy VARCHAR2
575 , p9_a37 in out nocopy VARCHAR2
576 , p9_a38 in out nocopy VARCHAR2
577 , p9_a39 in out nocopy VARCHAR2
578 , p9_a40 in out nocopy VARCHAR2
579 , p9_a41 in out nocopy VARCHAR2
580 , p9_a42 in out nocopy VARCHAR2
581 , p9_a43 in out nocopy NUMBER
582 , p9_a44 in out nocopy DATE
583 , p9_a45 in out nocopy NUMBER
584 , p9_a46 in out nocopy DATE
585 , p9_a47 in out nocopy NUMBER
586 , p9_a48 in out nocopy VARCHAR2
587 );
588 procedure cascade_contract_start_date(p_api_version NUMBER
589 , p_init_msg_list VARCHAR2
590 , x_return_status out nocopy VARCHAR2
591 , x_msg_count out nocopy NUMBER
592 , x_msg_data out nocopy VARCHAR2
593 , p_chr_id NUMBER
594 , p_new_start_date date
595 );
596 procedure get_rate_rec(p_chr_id NUMBER
597 , p_parameter_type_code VARCHAR2
598 , p_effective_from_date date
599 , p3_a0 out nocopy NUMBER
600 , p3_a1 out nocopy VARCHAR2
601 , p3_a2 out nocopy DATE
602 , p3_a3 out nocopy DATE
603 , p3_a4 out nocopy NUMBER
604 , p3_a5 out nocopy NUMBER
605 , p3_a6 out nocopy DATE
606 , p3_a7 out nocopy NUMBER
607 , p3_a8 out nocopy NUMBER
608 , p3_a9 out nocopy NUMBER
609 , p3_a10 out nocopy VARCHAR2
610 , p3_a11 out nocopy VARCHAR2
611 , p3_a12 out nocopy VARCHAR2
612 , p3_a13 out nocopy VARCHAR2
613 , p3_a14 out nocopy VARCHAR2
614 , p3_a15 out nocopy NUMBER
615 , p3_a16 out nocopy VARCHAR2
616 , p3_a17 out nocopy NUMBER
617 , p3_a18 out nocopy VARCHAR2
618 , p3_a19 out nocopy DATE
619 , p3_a20 out nocopy VARCHAR2
620 , p3_a21 out nocopy DATE
621 , p3_a22 out nocopy VARCHAR2
622 , p3_a23 out nocopy NUMBER
623 , p3_a24 out nocopy VARCHAR2
624 , p3_a25 out nocopy DATE
625 , p3_a26 out nocopy VARCHAR2
626 , p3_a27 out nocopy VARCHAR2
627 , p3_a28 out nocopy VARCHAR2
628 , p3_a29 out nocopy VARCHAR2
629 , p3_a30 out nocopy VARCHAR2
630 , p3_a31 out nocopy VARCHAR2
631 , p3_a32 out nocopy VARCHAR2
632 , p3_a33 out nocopy VARCHAR2
633 , p3_a34 out nocopy VARCHAR2
634 , p3_a35 out nocopy VARCHAR2
635 , p3_a36 out nocopy VARCHAR2
636 , p3_a37 out nocopy VARCHAR2
637 , p3_a38 out nocopy VARCHAR2
638 , p3_a39 out nocopy VARCHAR2
639 , p3_a40 out nocopy VARCHAR2
640 , p3_a41 out nocopy VARCHAR2
641 , p3_a42 out nocopy VARCHAR2
642 , p3_a43 out nocopy NUMBER
643 , p3_a44 out nocopy DATE
644 , p3_a45 out nocopy NUMBER
645 , p3_a46 out nocopy DATE
646 , p3_a47 out nocopy NUMBER
647 , p3_a48 out nocopy VARCHAR2
648 , x_no_data_found out nocopy number
649 );
650 procedure check_rebook_allowed(p_api_version NUMBER
651 , p_init_msg_list VARCHAR2
652 , x_return_status out nocopy VARCHAR2
653 , x_msg_count out nocopy NUMBER
654 , x_msg_data out nocopy VARCHAR2
655 , p_chr_id NUMBER
656 , p_rebook_date date
657 );
658 procedure check_base_rate(p_khr_id NUMBER
659 , x_base_rate_defined out nocopy number
660 , x_return_status out nocopy VARCHAR2
661 );
662 procedure check_principal_payment(p_api_version NUMBER
663 , p_init_msg_list VARCHAR2
664 , x_return_status out nocopy VARCHAR2
665 , x_msg_count out nocopy NUMBER
666 , x_msg_data out nocopy VARCHAR2
667 , p_chr_id NUMBER
668 , x_principal_payment_defined out nocopy number
669 );
670 procedure copy_k_rate_params(p_api_version NUMBER
671 , p_init_msg_list VARCHAR2
672 , x_return_status out nocopy VARCHAR2
673 , x_msg_count out nocopy NUMBER
674 , x_msg_data out nocopy VARCHAR2
675 , p_khr_id NUMBER
676 , p_effective_from_date date
677 , p_rate_type VARCHAR2
678 , p8_a0 out nocopy NUMBER
679 , p8_a1 out nocopy VARCHAR2
680 , p8_a2 out nocopy DATE
681 , p8_a3 out nocopy DATE
682 , p8_a4 out nocopy NUMBER
683 , p8_a5 out nocopy NUMBER
684 , p8_a6 out nocopy DATE
685 , p8_a7 out nocopy NUMBER
686 , p8_a8 out nocopy NUMBER
687 , p8_a9 out nocopy NUMBER
688 , p8_a10 out nocopy VARCHAR2
689 , p8_a11 out nocopy VARCHAR2
690 , p8_a12 out nocopy VARCHAR2
691 , p8_a13 out nocopy VARCHAR2
692 , p8_a14 out nocopy VARCHAR2
693 , p8_a15 out nocopy NUMBER
694 , p8_a16 out nocopy VARCHAR2
695 , p8_a17 out nocopy NUMBER
696 , p8_a18 out nocopy VARCHAR2
697 , p8_a19 out nocopy DATE
698 , p8_a20 out nocopy VARCHAR2
699 , p8_a21 out nocopy DATE
700 , p8_a22 out nocopy VARCHAR2
701 , p8_a23 out nocopy NUMBER
702 , p8_a24 out nocopy VARCHAR2
703 , p8_a25 out nocopy DATE
704 , p8_a26 out nocopy VARCHAR2
705 , p8_a27 out nocopy VARCHAR2
706 , p8_a28 out nocopy VARCHAR2
707 , p8_a29 out nocopy VARCHAR2
708 , p8_a30 out nocopy VARCHAR2
709 , p8_a31 out nocopy VARCHAR2
710 , p8_a32 out nocopy VARCHAR2
711 , p8_a33 out nocopy VARCHAR2
712 , p8_a34 out nocopy VARCHAR2
713 , p8_a35 out nocopy VARCHAR2
714 , p8_a36 out nocopy VARCHAR2
715 , p8_a37 out nocopy VARCHAR2
716 , p8_a38 out nocopy VARCHAR2
717 , p8_a39 out nocopy VARCHAR2
718 , p8_a40 out nocopy VARCHAR2
719 , p8_a41 out nocopy VARCHAR2
720 , p8_a42 out nocopy VARCHAR2
721 , p8_a43 out nocopy NUMBER
722 , p8_a44 out nocopy DATE
723 , p8_a45 out nocopy NUMBER
724 , p8_a46 out nocopy DATE
725 , p8_a47 out nocopy NUMBER
726 , p8_a48 out nocopy VARCHAR2
727 );
728 end okl_k_rate_params_pvt_w;