[Home] [Help]
PACKAGE: APPS.LNS_CUSTOM_PUB_W
Source
1 package lns_custom_pub_w AUTHID CURRENT_USER as
2 /* $Header: LNS_CUST_PUBJ_S.pls 120.6.12020000.2 2012/07/19 20:54:10 scherkas ship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy lns_custom_pub.custom_tbl, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_DATE_TABLE
7 , a4 JTF_DATE_TABLE
8 , a5 JTF_DATE_TABLE
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_NUMBER_TABLE
13 , a10 JTF_NUMBER_TABLE
14 , a11 JTF_NUMBER_TABLE
15 , a12 JTF_NUMBER_TABLE
16 , a13 JTF_NUMBER_TABLE
17 , a14 JTF_NUMBER_TABLE
18 , a15 JTF_NUMBER_TABLE
19 , a16 JTF_VARCHAR2_TABLE_100
20 , a17 JTF_VARCHAR2_TABLE_200
21 , a18 JTF_VARCHAR2_TABLE_200
22 , a19 JTF_VARCHAR2_TABLE_200
23 , a20 JTF_VARCHAR2_TABLE_200
24 , a21 JTF_VARCHAR2_TABLE_200
25 , a22 JTF_VARCHAR2_TABLE_200
26 , a23 JTF_VARCHAR2_TABLE_200
27 , a24 JTF_VARCHAR2_TABLE_200
28 , a25 JTF_VARCHAR2_TABLE_200
29 , a26 JTF_VARCHAR2_TABLE_200
30 , a27 JTF_VARCHAR2_TABLE_200
31 , a28 JTF_VARCHAR2_TABLE_200
32 , a29 JTF_VARCHAR2_TABLE_200
33 , a30 JTF_VARCHAR2_TABLE_200
34 , a31 JTF_VARCHAR2_TABLE_200
35 , a32 JTF_VARCHAR2_TABLE_200
36 , a33 JTF_VARCHAR2_TABLE_200
37 , a34 JTF_VARCHAR2_TABLE_200
38 , a35 JTF_VARCHAR2_TABLE_200
39 , a36 JTF_VARCHAR2_TABLE_200
40 , a37 JTF_NUMBER_TABLE
41 , a38 JTF_NUMBER_TABLE
42 , a39 JTF_NUMBER_TABLE
43 , a40 JTF_NUMBER_TABLE
44 , a41 JTF_NUMBER_TABLE
45 , a42 JTF_NUMBER_TABLE
46 , a43 JTF_NUMBER_TABLE
47 , a44 JTF_NUMBER_TABLE
48 , a45 JTF_VARCHAR2_TABLE_100
49 , a46 JTF_VARCHAR2_TABLE_100
50 , a47 JTF_VARCHAR2_TABLE_100
51 , a48 JTF_NUMBER_TABLE
52 , a49 JTF_VARCHAR2_TABLE_2000
53 , a50 JTF_VARCHAR2_TABLE_2000
54 , a51 JTF_VARCHAR2_TABLE_2000
55 , a52 JTF_VARCHAR2_TABLE_2000
56 , a53 JTF_NUMBER_TABLE
57 , a54 JTF_VARCHAR2_TABLE_200
58 , a55 JTF_NUMBER_TABLE
59 , a56 JTF_VARCHAR2_TABLE_300
60 , a57 JTF_NUMBER_TABLE
61 , a58 JTF_NUMBER_TABLE
62 , a59 JTF_VARCHAR2_TABLE_2000
63 , a60 JTF_NUMBER_TABLE
64 , a61 JTF_NUMBER_TABLE
65 , a62 JTF_NUMBER_TABLE
66 , a63 JTF_VARCHAR2_TABLE_2000
67 , a64 JTF_NUMBER_TABLE
68 , a65 JTF_VARCHAR2_TABLE_2000
69 );
70 procedure rosetta_table_copy_out_p1(t lns_custom_pub.custom_tbl, a0 out nocopy JTF_NUMBER_TABLE
71 , a1 out nocopy JTF_NUMBER_TABLE
72 , a2 out nocopy JTF_NUMBER_TABLE
73 , a3 out nocopy JTF_DATE_TABLE
74 , a4 out nocopy JTF_DATE_TABLE
75 , a5 out nocopy JTF_DATE_TABLE
76 , a6 out nocopy JTF_NUMBER_TABLE
77 , a7 out nocopy JTF_NUMBER_TABLE
78 , a8 out nocopy JTF_NUMBER_TABLE
79 , a9 out nocopy JTF_NUMBER_TABLE
80 , a10 out nocopy JTF_NUMBER_TABLE
81 , a11 out nocopy JTF_NUMBER_TABLE
82 , a12 out nocopy JTF_NUMBER_TABLE
83 , a13 out nocopy JTF_NUMBER_TABLE
84 , a14 out nocopy JTF_NUMBER_TABLE
85 , a15 out nocopy JTF_NUMBER_TABLE
86 , a16 out nocopy JTF_VARCHAR2_TABLE_100
87 , a17 out nocopy JTF_VARCHAR2_TABLE_200
88 , a18 out nocopy JTF_VARCHAR2_TABLE_200
89 , a19 out nocopy JTF_VARCHAR2_TABLE_200
90 , a20 out nocopy JTF_VARCHAR2_TABLE_200
91 , a21 out nocopy JTF_VARCHAR2_TABLE_200
92 , a22 out nocopy JTF_VARCHAR2_TABLE_200
93 , a23 out nocopy JTF_VARCHAR2_TABLE_200
94 , a24 out nocopy JTF_VARCHAR2_TABLE_200
95 , a25 out nocopy JTF_VARCHAR2_TABLE_200
96 , a26 out nocopy JTF_VARCHAR2_TABLE_200
97 , a27 out nocopy JTF_VARCHAR2_TABLE_200
98 , a28 out nocopy JTF_VARCHAR2_TABLE_200
99 , a29 out nocopy JTF_VARCHAR2_TABLE_200
100 , a30 out nocopy JTF_VARCHAR2_TABLE_200
101 , a31 out nocopy JTF_VARCHAR2_TABLE_200
102 , a32 out nocopy JTF_VARCHAR2_TABLE_200
103 , a33 out nocopy JTF_VARCHAR2_TABLE_200
104 , a34 out nocopy JTF_VARCHAR2_TABLE_200
105 , a35 out nocopy JTF_VARCHAR2_TABLE_200
106 , a36 out nocopy JTF_VARCHAR2_TABLE_200
107 , a37 out nocopy JTF_NUMBER_TABLE
108 , a38 out nocopy JTF_NUMBER_TABLE
109 , a39 out nocopy JTF_NUMBER_TABLE
110 , a40 out nocopy JTF_NUMBER_TABLE
111 , a41 out nocopy JTF_NUMBER_TABLE
112 , a42 out nocopy JTF_NUMBER_TABLE
113 , a43 out nocopy JTF_NUMBER_TABLE
114 , a44 out nocopy JTF_NUMBER_TABLE
115 , a45 out nocopy JTF_VARCHAR2_TABLE_100
116 , a46 out nocopy JTF_VARCHAR2_TABLE_100
117 , a47 out nocopy JTF_VARCHAR2_TABLE_100
118 , a48 out nocopy JTF_NUMBER_TABLE
119 , a49 out nocopy JTF_VARCHAR2_TABLE_2000
120 , a50 out nocopy JTF_VARCHAR2_TABLE_2000
121 , a51 out nocopy JTF_VARCHAR2_TABLE_2000
122 , a52 out nocopy JTF_VARCHAR2_TABLE_2000
123 , a53 out nocopy JTF_NUMBER_TABLE
124 , a54 out nocopy JTF_VARCHAR2_TABLE_200
125 , a55 out nocopy JTF_NUMBER_TABLE
126 , a56 out nocopy JTF_VARCHAR2_TABLE_300
127 , a57 out nocopy JTF_NUMBER_TABLE
128 , a58 out nocopy JTF_NUMBER_TABLE
129 , a59 out nocopy JTF_VARCHAR2_TABLE_2000
130 , a60 out nocopy JTF_NUMBER_TABLE
131 , a61 out nocopy JTF_NUMBER_TABLE
132 , a62 out nocopy JTF_NUMBER_TABLE
133 , a63 out nocopy JTF_VARCHAR2_TABLE_2000
134 , a64 out nocopy JTF_NUMBER_TABLE
135 , a65 out nocopy JTF_VARCHAR2_TABLE_2000
136 );
137
138 procedure resetcustomschedule(p_loan_id NUMBER
139 , p_init_msg_list VARCHAR2
140 , p_commit VARCHAR2
141 , p_update_header number
142 , x_return_status out nocopy VARCHAR2
143 , x_msg_count out nocopy NUMBER
144 , x_msg_data out nocopy VARCHAR2
145 );
146 procedure createcustomschedule(p0_a0 JTF_NUMBER_TABLE
147 , p0_a1 JTF_NUMBER_TABLE
148 , p0_a2 JTF_NUMBER_TABLE
149 , p0_a3 JTF_DATE_TABLE
150 , p0_a4 JTF_DATE_TABLE
151 , p0_a5 JTF_DATE_TABLE
152 , p0_a6 JTF_NUMBER_TABLE
153 , p0_a7 JTF_NUMBER_TABLE
154 , p0_a8 JTF_NUMBER_TABLE
155 , p0_a9 JTF_NUMBER_TABLE
156 , p0_a10 JTF_NUMBER_TABLE
157 , p0_a11 JTF_NUMBER_TABLE
158 , p0_a12 JTF_NUMBER_TABLE
159 , p0_a13 JTF_NUMBER_TABLE
160 , p0_a14 JTF_NUMBER_TABLE
161 , p0_a15 JTF_NUMBER_TABLE
162 , p0_a16 JTF_VARCHAR2_TABLE_100
163 , p0_a17 JTF_VARCHAR2_TABLE_200
164 , p0_a18 JTF_VARCHAR2_TABLE_200
165 , p0_a19 JTF_VARCHAR2_TABLE_200
166 , p0_a20 JTF_VARCHAR2_TABLE_200
167 , p0_a21 JTF_VARCHAR2_TABLE_200
168 , p0_a22 JTF_VARCHAR2_TABLE_200
169 , p0_a23 JTF_VARCHAR2_TABLE_200
170 , p0_a24 JTF_VARCHAR2_TABLE_200
171 , p0_a25 JTF_VARCHAR2_TABLE_200
172 , p0_a26 JTF_VARCHAR2_TABLE_200
173 , p0_a27 JTF_VARCHAR2_TABLE_200
174 , p0_a28 JTF_VARCHAR2_TABLE_200
175 , p0_a29 JTF_VARCHAR2_TABLE_200
176 , p0_a30 JTF_VARCHAR2_TABLE_200
177 , p0_a31 JTF_VARCHAR2_TABLE_200
178 , p0_a32 JTF_VARCHAR2_TABLE_200
179 , p0_a33 JTF_VARCHAR2_TABLE_200
180 , p0_a34 JTF_VARCHAR2_TABLE_200
181 , p0_a35 JTF_VARCHAR2_TABLE_200
182 , p0_a36 JTF_VARCHAR2_TABLE_200
183 , p0_a37 JTF_NUMBER_TABLE
184 , p0_a38 JTF_NUMBER_TABLE
185 , p0_a39 JTF_NUMBER_TABLE
186 , p0_a40 JTF_NUMBER_TABLE
187 , p0_a41 JTF_NUMBER_TABLE
188 , p0_a42 JTF_NUMBER_TABLE
189 , p0_a43 JTF_NUMBER_TABLE
190 , p0_a44 JTF_NUMBER_TABLE
191 , p0_a45 JTF_VARCHAR2_TABLE_100
192 , p0_a46 JTF_VARCHAR2_TABLE_100
193 , p0_a47 JTF_VARCHAR2_TABLE_100
194 , p0_a48 JTF_NUMBER_TABLE
195 , p0_a49 JTF_VARCHAR2_TABLE_2000
196 , p0_a50 JTF_VARCHAR2_TABLE_2000
197 , p0_a51 JTF_VARCHAR2_TABLE_2000
198 , p0_a52 JTF_VARCHAR2_TABLE_2000
199 , p0_a53 JTF_NUMBER_TABLE
200 , p0_a54 JTF_VARCHAR2_TABLE_200
201 , p0_a55 JTF_NUMBER_TABLE
202 , p0_a56 JTF_VARCHAR2_TABLE_300
203 , p0_a57 JTF_NUMBER_TABLE
204 , p0_a58 JTF_NUMBER_TABLE
205 , p0_a59 JTF_VARCHAR2_TABLE_2000
206 , p0_a60 JTF_NUMBER_TABLE
207 , p0_a61 JTF_NUMBER_TABLE
208 , p0_a62 JTF_NUMBER_TABLE
209 , p0_a63 JTF_VARCHAR2_TABLE_2000
210 , p0_a64 JTF_NUMBER_TABLE
211 , p0_a65 JTF_VARCHAR2_TABLE_2000
212 , p_loan_id NUMBER
213 , p_init_msg_list VARCHAR2
214 , p_commit VARCHAR2
215 , x_return_status out nocopy VARCHAR2
216 , x_msg_count out nocopy NUMBER
217 , x_msg_data out nocopy VARCHAR2
218 , x_invalid_installment_num out nocopy NUMBER
219 );
220 procedure updatecustomschedule(p0_a0 JTF_NUMBER_TABLE
221 , p0_a1 JTF_NUMBER_TABLE
222 , p0_a2 JTF_NUMBER_TABLE
223 , p0_a3 JTF_DATE_TABLE
224 , p0_a4 JTF_DATE_TABLE
225 , p0_a5 JTF_DATE_TABLE
226 , p0_a6 JTF_NUMBER_TABLE
227 , p0_a7 JTF_NUMBER_TABLE
228 , p0_a8 JTF_NUMBER_TABLE
229 , p0_a9 JTF_NUMBER_TABLE
230 , p0_a10 JTF_NUMBER_TABLE
231 , p0_a11 JTF_NUMBER_TABLE
232 , p0_a12 JTF_NUMBER_TABLE
233 , p0_a13 JTF_NUMBER_TABLE
234 , p0_a14 JTF_NUMBER_TABLE
235 , p0_a15 JTF_NUMBER_TABLE
236 , p0_a16 JTF_VARCHAR2_TABLE_100
237 , p0_a17 JTF_VARCHAR2_TABLE_200
238 , p0_a18 JTF_VARCHAR2_TABLE_200
239 , p0_a19 JTF_VARCHAR2_TABLE_200
240 , p0_a20 JTF_VARCHAR2_TABLE_200
241 , p0_a21 JTF_VARCHAR2_TABLE_200
242 , p0_a22 JTF_VARCHAR2_TABLE_200
243 , p0_a23 JTF_VARCHAR2_TABLE_200
244 , p0_a24 JTF_VARCHAR2_TABLE_200
245 , p0_a25 JTF_VARCHAR2_TABLE_200
246 , p0_a26 JTF_VARCHAR2_TABLE_200
247 , p0_a27 JTF_VARCHAR2_TABLE_200
248 , p0_a28 JTF_VARCHAR2_TABLE_200
249 , p0_a29 JTF_VARCHAR2_TABLE_200
250 , p0_a30 JTF_VARCHAR2_TABLE_200
251 , p0_a31 JTF_VARCHAR2_TABLE_200
252 , p0_a32 JTF_VARCHAR2_TABLE_200
253 , p0_a33 JTF_VARCHAR2_TABLE_200
254 , p0_a34 JTF_VARCHAR2_TABLE_200
255 , p0_a35 JTF_VARCHAR2_TABLE_200
256 , p0_a36 JTF_VARCHAR2_TABLE_200
257 , p0_a37 JTF_NUMBER_TABLE
258 , p0_a38 JTF_NUMBER_TABLE
259 , p0_a39 JTF_NUMBER_TABLE
260 , p0_a40 JTF_NUMBER_TABLE
261 , p0_a41 JTF_NUMBER_TABLE
262 , p0_a42 JTF_NUMBER_TABLE
263 , p0_a43 JTF_NUMBER_TABLE
264 , p0_a44 JTF_NUMBER_TABLE
265 , p0_a45 JTF_VARCHAR2_TABLE_100
266 , p0_a46 JTF_VARCHAR2_TABLE_100
267 , p0_a47 JTF_VARCHAR2_TABLE_100
268 , p0_a48 JTF_NUMBER_TABLE
269 , p0_a49 JTF_VARCHAR2_TABLE_2000
270 , p0_a50 JTF_VARCHAR2_TABLE_2000
271 , p0_a51 JTF_VARCHAR2_TABLE_2000
272 , p0_a52 JTF_VARCHAR2_TABLE_2000
273 , p0_a53 JTF_NUMBER_TABLE
274 , p0_a54 JTF_VARCHAR2_TABLE_200
275 , p0_a55 JTF_NUMBER_TABLE
276 , p0_a56 JTF_VARCHAR2_TABLE_300
277 , p0_a57 JTF_NUMBER_TABLE
278 , p0_a58 JTF_NUMBER_TABLE
279 , p0_a59 JTF_VARCHAR2_TABLE_2000
280 , p0_a60 JTF_NUMBER_TABLE
281 , p0_a61 JTF_NUMBER_TABLE
282 , p0_a62 JTF_NUMBER_TABLE
283 , p0_a63 JTF_VARCHAR2_TABLE_2000
284 , p0_a64 JTF_NUMBER_TABLE
285 , p0_a65 JTF_VARCHAR2_TABLE_2000
286 , p_loan_id NUMBER
287 , p_init_msg_list VARCHAR2
288 , p_commit VARCHAR2
289 , x_return_status out nocopy VARCHAR2
290 , x_msg_count out nocopy NUMBER
291 , x_msg_data out nocopy VARCHAR2
292 , x_invalid_installment_num out nocopy NUMBER
293 );
294 procedure createcustomsched(p0_a0 NUMBER
295 , p0_a1 NUMBER
296 , p0_a2 NUMBER
297 , p0_a3 DATE
298 , p0_a4 DATE
299 , p0_a5 DATE
300 , p0_a6 NUMBER
301 , p0_a7 NUMBER
302 , p0_a8 NUMBER
303 , p0_a9 NUMBER
304 , p0_a10 NUMBER
305 , p0_a11 NUMBER
306 , p0_a12 NUMBER
307 , p0_a13 NUMBER
308 , p0_a14 NUMBER
309 , p0_a15 NUMBER
310 , p0_a16 VARCHAR2
311 , p0_a17 VARCHAR2
312 , p0_a18 VARCHAR2
313 , p0_a19 VARCHAR2
314 , p0_a20 VARCHAR2
315 , p0_a21 VARCHAR2
316 , p0_a22 VARCHAR2
317 , p0_a23 VARCHAR2
318 , p0_a24 VARCHAR2
319 , p0_a25 VARCHAR2
320 , p0_a26 VARCHAR2
321 , p0_a27 VARCHAR2
322 , p0_a28 VARCHAR2
323 , p0_a29 VARCHAR2
324 , p0_a30 VARCHAR2
325 , p0_a31 VARCHAR2
326 , p0_a32 VARCHAR2
327 , p0_a33 VARCHAR2
328 , p0_a34 VARCHAR2
329 , p0_a35 VARCHAR2
330 , p0_a36 VARCHAR2
331 , p0_a37 NUMBER
332 , p0_a38 NUMBER
333 , p0_a39 NUMBER
334 , p0_a40 NUMBER
335 , p0_a41 NUMBER
336 , p0_a42 NUMBER
337 , p0_a43 NUMBER
338 , p0_a44 NUMBER
339 , p0_a45 VARCHAR2
340 , p0_a46 VARCHAR2
341 , p0_a47 VARCHAR2
342 , p0_a48 NUMBER
343 , p0_a49 VARCHAR2
344 , p0_a50 VARCHAR2
345 , p0_a51 VARCHAR2
346 , p0_a52 VARCHAR2
347 , p0_a53 NUMBER
348 , p0_a54 VARCHAR2
349 , p0_a55 NUMBER
350 , p0_a56 VARCHAR2
351 , p0_a57 NUMBER
352 , p0_a58 NUMBER
353 , p0_a59 VARCHAR2
354 , p0_a60 NUMBER
355 , p0_a61 NUMBER
356 , p0_a62 NUMBER
357 , p0_a63 VARCHAR2
358 , p0_a64 NUMBER
359 , p0_a65 VARCHAR2
360 , x_custom_sched_id out nocopy NUMBER
361 , x_return_status out nocopy VARCHAR2
362 , x_msg_count out nocopy NUMBER
363 , x_msg_data out nocopy VARCHAR2
364 );
365 procedure updatecustomsched(p0_a0 NUMBER
366 , p0_a1 NUMBER
367 , p0_a2 NUMBER
368 , p0_a3 DATE
369 , p0_a4 DATE
370 , p0_a5 DATE
371 , p0_a6 NUMBER
372 , p0_a7 NUMBER
373 , p0_a8 NUMBER
374 , p0_a9 NUMBER
375 , p0_a10 NUMBER
376 , p0_a11 NUMBER
377 , p0_a12 NUMBER
378 , p0_a13 NUMBER
379 , p0_a14 NUMBER
380 , p0_a15 NUMBER
381 , p0_a16 VARCHAR2
382 , p0_a17 VARCHAR2
383 , p0_a18 VARCHAR2
384 , p0_a19 VARCHAR2
385 , p0_a20 VARCHAR2
386 , p0_a21 VARCHAR2
387 , p0_a22 VARCHAR2
388 , p0_a23 VARCHAR2
389 , p0_a24 VARCHAR2
390 , p0_a25 VARCHAR2
391 , p0_a26 VARCHAR2
392 , p0_a27 VARCHAR2
393 , p0_a28 VARCHAR2
394 , p0_a29 VARCHAR2
395 , p0_a30 VARCHAR2
396 , p0_a31 VARCHAR2
397 , p0_a32 VARCHAR2
398 , p0_a33 VARCHAR2
399 , p0_a34 VARCHAR2
400 , p0_a35 VARCHAR2
401 , p0_a36 VARCHAR2
402 , p0_a37 NUMBER
403 , p0_a38 NUMBER
404 , p0_a39 NUMBER
405 , p0_a40 NUMBER
406 , p0_a41 NUMBER
407 , p0_a42 NUMBER
408 , p0_a43 NUMBER
409 , p0_a44 NUMBER
410 , p0_a45 VARCHAR2
411 , p0_a46 VARCHAR2
412 , p0_a47 VARCHAR2
413 , p0_a48 NUMBER
414 , p0_a49 VARCHAR2
415 , p0_a50 VARCHAR2
416 , p0_a51 VARCHAR2
417 , p0_a52 VARCHAR2
418 , p0_a53 NUMBER
419 , p0_a54 VARCHAR2
420 , p0_a55 NUMBER
421 , p0_a56 VARCHAR2
422 , p0_a57 NUMBER
423 , p0_a58 NUMBER
424 , p0_a59 VARCHAR2
425 , p0_a60 NUMBER
426 , p0_a61 NUMBER
427 , p0_a62 NUMBER
428 , p0_a63 VARCHAR2
429 , p0_a64 NUMBER
430 , p0_a65 VARCHAR2
431 , x_return_status out nocopy VARCHAR2
432 , x_msg_count out nocopy NUMBER
433 , x_msg_data out nocopy VARCHAR2
434 );
435 procedure validatecustomtable(p0_a0 JTF_NUMBER_TABLE
436 , p0_a1 JTF_NUMBER_TABLE
437 , p0_a2 JTF_NUMBER_TABLE
438 , p0_a3 JTF_DATE_TABLE
439 , p0_a4 JTF_DATE_TABLE
440 , p0_a5 JTF_DATE_TABLE
441 , p0_a6 JTF_NUMBER_TABLE
442 , p0_a7 JTF_NUMBER_TABLE
443 , p0_a8 JTF_NUMBER_TABLE
444 , p0_a9 JTF_NUMBER_TABLE
445 , p0_a10 JTF_NUMBER_TABLE
446 , p0_a11 JTF_NUMBER_TABLE
447 , p0_a12 JTF_NUMBER_TABLE
448 , p0_a13 JTF_NUMBER_TABLE
449 , p0_a14 JTF_NUMBER_TABLE
450 , p0_a15 JTF_NUMBER_TABLE
451 , p0_a16 JTF_VARCHAR2_TABLE_100
452 , p0_a17 JTF_VARCHAR2_TABLE_200
453 , p0_a18 JTF_VARCHAR2_TABLE_200
454 , p0_a19 JTF_VARCHAR2_TABLE_200
455 , p0_a20 JTF_VARCHAR2_TABLE_200
456 , p0_a21 JTF_VARCHAR2_TABLE_200
457 , p0_a22 JTF_VARCHAR2_TABLE_200
458 , p0_a23 JTF_VARCHAR2_TABLE_200
459 , p0_a24 JTF_VARCHAR2_TABLE_200
460 , p0_a25 JTF_VARCHAR2_TABLE_200
461 , p0_a26 JTF_VARCHAR2_TABLE_200
462 , p0_a27 JTF_VARCHAR2_TABLE_200
463 , p0_a28 JTF_VARCHAR2_TABLE_200
464 , p0_a29 JTF_VARCHAR2_TABLE_200
465 , p0_a30 JTF_VARCHAR2_TABLE_200
466 , p0_a31 JTF_VARCHAR2_TABLE_200
467 , p0_a32 JTF_VARCHAR2_TABLE_200
468 , p0_a33 JTF_VARCHAR2_TABLE_200
469 , p0_a34 JTF_VARCHAR2_TABLE_200
470 , p0_a35 JTF_VARCHAR2_TABLE_200
471 , p0_a36 JTF_VARCHAR2_TABLE_200
472 , p0_a37 JTF_NUMBER_TABLE
473 , p0_a38 JTF_NUMBER_TABLE
474 , p0_a39 JTF_NUMBER_TABLE
475 , p0_a40 JTF_NUMBER_TABLE
476 , p0_a41 JTF_NUMBER_TABLE
477 , p0_a42 JTF_NUMBER_TABLE
478 , p0_a43 JTF_NUMBER_TABLE
479 , p0_a44 JTF_NUMBER_TABLE
480 , p0_a45 JTF_VARCHAR2_TABLE_100
481 , p0_a46 JTF_VARCHAR2_TABLE_100
482 , p0_a47 JTF_VARCHAR2_TABLE_100
483 , p0_a48 JTF_NUMBER_TABLE
484 , p0_a49 JTF_VARCHAR2_TABLE_2000
485 , p0_a50 JTF_VARCHAR2_TABLE_2000
486 , p0_a51 JTF_VARCHAR2_TABLE_2000
487 , p0_a52 JTF_VARCHAR2_TABLE_2000
488 , p0_a53 JTF_NUMBER_TABLE
489 , p0_a54 JTF_VARCHAR2_TABLE_200
490 , p0_a55 JTF_NUMBER_TABLE
491 , p0_a56 JTF_VARCHAR2_TABLE_300
492 , p0_a57 JTF_NUMBER_TABLE
493 , p0_a58 JTF_NUMBER_TABLE
494 , p0_a59 JTF_VARCHAR2_TABLE_2000
495 , p0_a60 JTF_NUMBER_TABLE
496 , p0_a61 JTF_NUMBER_TABLE
497 , p0_a62 JTF_NUMBER_TABLE
498 , p0_a63 JTF_VARCHAR2_TABLE_2000
499 , p0_a64 JTF_NUMBER_TABLE
500 , p0_a65 JTF_VARCHAR2_TABLE_2000
501 , p_loan_id NUMBER
502 , p_create_flag number
503 , x_installment out nocopy NUMBER
504 , x_return_status out nocopy VARCHAR2
505 , x_msg_count out nocopy NUMBER
506 , x_msg_data out nocopy VARCHAR2
507 );
508 procedure validatecustomrow(p0_a0 NUMBER
509 , p0_a1 NUMBER
510 , p0_a2 NUMBER
511 , p0_a3 DATE
512 , p0_a4 DATE
513 , p0_a5 DATE
514 , p0_a6 NUMBER
515 , p0_a7 NUMBER
516 , p0_a8 NUMBER
517 , p0_a9 NUMBER
518 , p0_a10 NUMBER
519 , p0_a11 NUMBER
520 , p0_a12 NUMBER
521 , p0_a13 NUMBER
522 , p0_a14 NUMBER
523 , p0_a15 NUMBER
524 , p0_a16 VARCHAR2
525 , p0_a17 VARCHAR2
526 , p0_a18 VARCHAR2
527 , p0_a19 VARCHAR2
528 , p0_a20 VARCHAR2
529 , p0_a21 VARCHAR2
530 , p0_a22 VARCHAR2
531 , p0_a23 VARCHAR2
532 , p0_a24 VARCHAR2
533 , p0_a25 VARCHAR2
534 , p0_a26 VARCHAR2
535 , p0_a27 VARCHAR2
536 , p0_a28 VARCHAR2
537 , p0_a29 VARCHAR2
538 , p0_a30 VARCHAR2
539 , p0_a31 VARCHAR2
540 , p0_a32 VARCHAR2
541 , p0_a33 VARCHAR2
542 , p0_a34 VARCHAR2
543 , p0_a35 VARCHAR2
544 , p0_a36 VARCHAR2
545 , p0_a37 NUMBER
546 , p0_a38 NUMBER
547 , p0_a39 NUMBER
548 , p0_a40 NUMBER
549 , p0_a41 NUMBER
550 , p0_a42 NUMBER
551 , p0_a43 NUMBER
552 , p0_a44 NUMBER
553 , p0_a45 VARCHAR2
554 , p0_a46 VARCHAR2
555 , p0_a47 VARCHAR2
556 , p0_a48 NUMBER
557 , p0_a49 VARCHAR2
558 , p0_a50 VARCHAR2
559 , p0_a51 VARCHAR2
560 , p0_a52 VARCHAR2
561 , p0_a53 NUMBER
562 , p0_a54 VARCHAR2
563 , p0_a55 NUMBER
564 , p0_a56 VARCHAR2
565 , p0_a57 NUMBER
566 , p0_a58 NUMBER
567 , p0_a59 VARCHAR2
568 , p0_a60 NUMBER
569 , p0_a61 NUMBER
570 , p0_a62 NUMBER
571 , p0_a63 VARCHAR2
572 , p0_a64 NUMBER
573 , p0_a65 VARCHAR2
574 , x_return_status out nocopy VARCHAR2
575 , x_msg_count out nocopy NUMBER
576 , x_msg_data out nocopy VARCHAR2
577 );
578 procedure recalccustomschedule(p_api_version NUMBER
579 , p_init_msg_list VARCHAR2
580 , p_commit VARCHAR2
581 , p_validation_level NUMBER
582 , p_loan_id NUMBER
583 , p_based_on_terms VARCHAR2
584 , p_use_retained_data VARCHAR2
585 , p7_a0 in out nocopy VARCHAR2
586 , p7_a1 in out nocopy VARCHAR2
587 , p8_a0 in out nocopy JTF_NUMBER_TABLE
588 , p8_a1 in out nocopy JTF_NUMBER_TABLE
589 , p8_a2 in out nocopy JTF_NUMBER_TABLE
590 , p8_a3 in out nocopy JTF_DATE_TABLE
591 , p8_a4 in out nocopy JTF_DATE_TABLE
592 , p8_a5 in out nocopy JTF_DATE_TABLE
593 , p8_a6 in out nocopy JTF_NUMBER_TABLE
594 , p8_a7 in out nocopy JTF_NUMBER_TABLE
595 , p8_a8 in out nocopy JTF_NUMBER_TABLE
596 , p8_a9 in out nocopy JTF_NUMBER_TABLE
597 , p8_a10 in out nocopy JTF_NUMBER_TABLE
598 , p8_a11 in out nocopy JTF_NUMBER_TABLE
599 , p8_a12 in out nocopy JTF_NUMBER_TABLE
600 , p8_a13 in out nocopy JTF_NUMBER_TABLE
601 , p8_a14 in out nocopy JTF_NUMBER_TABLE
602 , p8_a15 in out nocopy JTF_NUMBER_TABLE
603 , p8_a16 in out nocopy JTF_VARCHAR2_TABLE_100
604 , p8_a17 in out nocopy JTF_VARCHAR2_TABLE_200
605 , p8_a18 in out nocopy JTF_VARCHAR2_TABLE_200
606 , p8_a19 in out nocopy JTF_VARCHAR2_TABLE_200
607 , p8_a20 in out nocopy JTF_VARCHAR2_TABLE_200
608 , p8_a21 in out nocopy JTF_VARCHAR2_TABLE_200
609 , p8_a22 in out nocopy JTF_VARCHAR2_TABLE_200
610 , p8_a23 in out nocopy JTF_VARCHAR2_TABLE_200
611 , p8_a24 in out nocopy JTF_VARCHAR2_TABLE_200
612 , p8_a25 in out nocopy JTF_VARCHAR2_TABLE_200
613 , p8_a26 in out nocopy JTF_VARCHAR2_TABLE_200
614 , p8_a27 in out nocopy JTF_VARCHAR2_TABLE_200
615 , p8_a28 in out nocopy JTF_VARCHAR2_TABLE_200
616 , p8_a29 in out nocopy JTF_VARCHAR2_TABLE_200
617 , p8_a30 in out nocopy JTF_VARCHAR2_TABLE_200
618 , p8_a31 in out nocopy JTF_VARCHAR2_TABLE_200
619 , p8_a32 in out nocopy JTF_VARCHAR2_TABLE_200
620 , p8_a33 in out nocopy JTF_VARCHAR2_TABLE_200
621 , p8_a34 in out nocopy JTF_VARCHAR2_TABLE_200
622 , p8_a35 in out nocopy JTF_VARCHAR2_TABLE_200
623 , p8_a36 in out nocopy JTF_VARCHAR2_TABLE_200
624 , p8_a37 in out nocopy JTF_NUMBER_TABLE
625 , p8_a38 in out nocopy JTF_NUMBER_TABLE
626 , p8_a39 in out nocopy JTF_NUMBER_TABLE
627 , p8_a40 in out nocopy JTF_NUMBER_TABLE
628 , p8_a41 in out nocopy JTF_NUMBER_TABLE
629 , p8_a42 in out nocopy JTF_NUMBER_TABLE
630 , p8_a43 in out nocopy JTF_NUMBER_TABLE
631 , p8_a44 in out nocopy JTF_NUMBER_TABLE
632 , p8_a45 in out nocopy JTF_VARCHAR2_TABLE_100
633 , p8_a46 in out nocopy JTF_VARCHAR2_TABLE_100
634 , p8_a47 in out nocopy JTF_VARCHAR2_TABLE_100
635 , p8_a48 in out nocopy JTF_NUMBER_TABLE
636 , p8_a49 in out nocopy JTF_VARCHAR2_TABLE_2000
637 , p8_a50 in out nocopy JTF_VARCHAR2_TABLE_2000
638 , p8_a51 in out nocopy JTF_VARCHAR2_TABLE_2000
639 , p8_a52 in out nocopy JTF_VARCHAR2_TABLE_2000
640 , p8_a53 in out nocopy JTF_NUMBER_TABLE
641 , p8_a54 in out nocopy JTF_VARCHAR2_TABLE_200
642 , p8_a55 in out nocopy JTF_NUMBER_TABLE
643 , p8_a56 in out nocopy JTF_VARCHAR2_TABLE_300
644 , p8_a57 in out nocopy JTF_NUMBER_TABLE
645 , p8_a58 in out nocopy JTF_NUMBER_TABLE
646 , p8_a59 in out nocopy JTF_VARCHAR2_TABLE_2000
647 , p8_a60 in out nocopy JTF_NUMBER_TABLE
648 , p8_a61 in out nocopy JTF_NUMBER_TABLE
649 , p8_a62 in out nocopy JTF_NUMBER_TABLE
650 , p8_a63 in out nocopy JTF_VARCHAR2_TABLE_2000
651 , p8_a64 in out nocopy JTF_NUMBER_TABLE
652 , p8_a65 in out nocopy JTF_VARCHAR2_TABLE_2000
653 , x_return_status out nocopy VARCHAR2
654 , x_msg_count out nocopy NUMBER
655 , x_msg_data out nocopy VARCHAR2
656 );
657 procedure loadcustomschedule(p_api_version NUMBER
658 , p_init_msg_list VARCHAR2
659 , p_commit VARCHAR2
660 , p_validation_level NUMBER
661 , p_loan_id NUMBER
662 , p_based_on_terms VARCHAR2
663 , p6_a0 out nocopy VARCHAR2
664 , p6_a1 out nocopy VARCHAR2
665 , p7_a0 out nocopy JTF_NUMBER_TABLE
666 , p7_a1 out nocopy JTF_NUMBER_TABLE
667 , p7_a2 out nocopy JTF_NUMBER_TABLE
668 , p7_a3 out nocopy JTF_DATE_TABLE
669 , p7_a4 out nocopy JTF_DATE_TABLE
670 , p7_a5 out nocopy JTF_DATE_TABLE
671 , p7_a6 out nocopy JTF_NUMBER_TABLE
672 , p7_a7 out nocopy JTF_NUMBER_TABLE
673 , p7_a8 out nocopy JTF_NUMBER_TABLE
674 , p7_a9 out nocopy JTF_NUMBER_TABLE
675 , p7_a10 out nocopy JTF_NUMBER_TABLE
676 , p7_a11 out nocopy JTF_NUMBER_TABLE
677 , p7_a12 out nocopy JTF_NUMBER_TABLE
678 , p7_a13 out nocopy JTF_NUMBER_TABLE
679 , p7_a14 out nocopy JTF_NUMBER_TABLE
680 , p7_a15 out nocopy JTF_NUMBER_TABLE
681 , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
682 , p7_a17 out nocopy JTF_VARCHAR2_TABLE_200
683 , p7_a18 out nocopy JTF_VARCHAR2_TABLE_200
684 , p7_a19 out nocopy JTF_VARCHAR2_TABLE_200
685 , p7_a20 out nocopy JTF_VARCHAR2_TABLE_200
686 , p7_a21 out nocopy JTF_VARCHAR2_TABLE_200
687 , p7_a22 out nocopy JTF_VARCHAR2_TABLE_200
688 , p7_a23 out nocopy JTF_VARCHAR2_TABLE_200
689 , p7_a24 out nocopy JTF_VARCHAR2_TABLE_200
690 , p7_a25 out nocopy JTF_VARCHAR2_TABLE_200
691 , p7_a26 out nocopy JTF_VARCHAR2_TABLE_200
692 , p7_a27 out nocopy JTF_VARCHAR2_TABLE_200
693 , p7_a28 out nocopy JTF_VARCHAR2_TABLE_200
694 , p7_a29 out nocopy JTF_VARCHAR2_TABLE_200
695 , p7_a30 out nocopy JTF_VARCHAR2_TABLE_200
696 , p7_a31 out nocopy JTF_VARCHAR2_TABLE_200
697 , p7_a32 out nocopy JTF_VARCHAR2_TABLE_200
698 , p7_a33 out nocopy JTF_VARCHAR2_TABLE_200
699 , p7_a34 out nocopy JTF_VARCHAR2_TABLE_200
700 , p7_a35 out nocopy JTF_VARCHAR2_TABLE_200
701 , p7_a36 out nocopy JTF_VARCHAR2_TABLE_200
702 , p7_a37 out nocopy JTF_NUMBER_TABLE
703 , p7_a38 out nocopy JTF_NUMBER_TABLE
704 , p7_a39 out nocopy JTF_NUMBER_TABLE
705 , p7_a40 out nocopy JTF_NUMBER_TABLE
706 , p7_a41 out nocopy JTF_NUMBER_TABLE
707 , p7_a42 out nocopy JTF_NUMBER_TABLE
708 , p7_a43 out nocopy JTF_NUMBER_TABLE
709 , p7_a44 out nocopy JTF_NUMBER_TABLE
710 , p7_a45 out nocopy JTF_VARCHAR2_TABLE_100
711 , p7_a46 out nocopy JTF_VARCHAR2_TABLE_100
712 , p7_a47 out nocopy JTF_VARCHAR2_TABLE_100
713 , p7_a48 out nocopy JTF_NUMBER_TABLE
714 , p7_a49 out nocopy JTF_VARCHAR2_TABLE_2000
715 , p7_a50 out nocopy JTF_VARCHAR2_TABLE_2000
716 , p7_a51 out nocopy JTF_VARCHAR2_TABLE_2000
717 , p7_a52 out nocopy JTF_VARCHAR2_TABLE_2000
718 , p7_a53 out nocopy JTF_NUMBER_TABLE
719 , p7_a54 out nocopy JTF_VARCHAR2_TABLE_200
720 , p7_a55 out nocopy JTF_NUMBER_TABLE
721 , p7_a56 out nocopy JTF_VARCHAR2_TABLE_300
722 , p7_a57 out nocopy JTF_NUMBER_TABLE
723 , p7_a58 out nocopy JTF_NUMBER_TABLE
724 , p7_a59 out nocopy JTF_VARCHAR2_TABLE_2000
725 , p7_a60 out nocopy JTF_NUMBER_TABLE
726 , p7_a61 out nocopy JTF_NUMBER_TABLE
727 , p7_a62 out nocopy JTF_NUMBER_TABLE
728 , p7_a63 out nocopy JTF_VARCHAR2_TABLE_2000
729 , p7_a64 out nocopy JTF_NUMBER_TABLE
730 , p7_a65 out nocopy JTF_VARCHAR2_TABLE_2000
731 , x_return_status out nocopy VARCHAR2
732 , x_msg_count out nocopy NUMBER
733 , x_msg_data out nocopy VARCHAR2
734 );
735 procedure savecustomschedule(p_api_version NUMBER
736 , p_init_msg_list VARCHAR2
737 , p_commit VARCHAR2
738 , p_validation_level NUMBER
739 , p_loan_id NUMBER
740 , p_based_on_terms VARCHAR2
741 , p_use_retained_data VARCHAR2
742 , p7_a0 in out nocopy VARCHAR2
743 , p7_a1 in out nocopy VARCHAR2
744 , p8_a0 in out nocopy JTF_NUMBER_TABLE
745 , p8_a1 in out nocopy JTF_NUMBER_TABLE
746 , p8_a2 in out nocopy JTF_NUMBER_TABLE
747 , p8_a3 in out nocopy JTF_DATE_TABLE
748 , p8_a4 in out nocopy JTF_DATE_TABLE
749 , p8_a5 in out nocopy JTF_DATE_TABLE
750 , p8_a6 in out nocopy JTF_NUMBER_TABLE
751 , p8_a7 in out nocopy JTF_NUMBER_TABLE
752 , p8_a8 in out nocopy JTF_NUMBER_TABLE
753 , p8_a9 in out nocopy JTF_NUMBER_TABLE
754 , p8_a10 in out nocopy JTF_NUMBER_TABLE
755 , p8_a11 in out nocopy JTF_NUMBER_TABLE
756 , p8_a12 in out nocopy JTF_NUMBER_TABLE
757 , p8_a13 in out nocopy JTF_NUMBER_TABLE
758 , p8_a14 in out nocopy JTF_NUMBER_TABLE
759 , p8_a15 in out nocopy JTF_NUMBER_TABLE
760 , p8_a16 in out nocopy JTF_VARCHAR2_TABLE_100
761 , p8_a17 in out nocopy JTF_VARCHAR2_TABLE_200
762 , p8_a18 in out nocopy JTF_VARCHAR2_TABLE_200
763 , p8_a19 in out nocopy JTF_VARCHAR2_TABLE_200
764 , p8_a20 in out nocopy JTF_VARCHAR2_TABLE_200
765 , p8_a21 in out nocopy JTF_VARCHAR2_TABLE_200
766 , p8_a22 in out nocopy JTF_VARCHAR2_TABLE_200
767 , p8_a23 in out nocopy JTF_VARCHAR2_TABLE_200
768 , p8_a24 in out nocopy JTF_VARCHAR2_TABLE_200
769 , p8_a25 in out nocopy JTF_VARCHAR2_TABLE_200
770 , p8_a26 in out nocopy JTF_VARCHAR2_TABLE_200
771 , p8_a27 in out nocopy JTF_VARCHAR2_TABLE_200
772 , p8_a28 in out nocopy JTF_VARCHAR2_TABLE_200
773 , p8_a29 in out nocopy JTF_VARCHAR2_TABLE_200
774 , p8_a30 in out nocopy JTF_VARCHAR2_TABLE_200
775 , p8_a31 in out nocopy JTF_VARCHAR2_TABLE_200
776 , p8_a32 in out nocopy JTF_VARCHAR2_TABLE_200
777 , p8_a33 in out nocopy JTF_VARCHAR2_TABLE_200
778 , p8_a34 in out nocopy JTF_VARCHAR2_TABLE_200
779 , p8_a35 in out nocopy JTF_VARCHAR2_TABLE_200
780 , p8_a36 in out nocopy JTF_VARCHAR2_TABLE_200
781 , p8_a37 in out nocopy JTF_NUMBER_TABLE
782 , p8_a38 in out nocopy JTF_NUMBER_TABLE
783 , p8_a39 in out nocopy JTF_NUMBER_TABLE
784 , p8_a40 in out nocopy JTF_NUMBER_TABLE
785 , p8_a41 in out nocopy JTF_NUMBER_TABLE
786 , p8_a42 in out nocopy JTF_NUMBER_TABLE
787 , p8_a43 in out nocopy JTF_NUMBER_TABLE
788 , p8_a44 in out nocopy JTF_NUMBER_TABLE
789 , p8_a45 in out nocopy JTF_VARCHAR2_TABLE_100
790 , p8_a46 in out nocopy JTF_VARCHAR2_TABLE_100
791 , p8_a47 in out nocopy JTF_VARCHAR2_TABLE_100
792 , p8_a48 in out nocopy JTF_NUMBER_TABLE
793 , p8_a49 in out nocopy JTF_VARCHAR2_TABLE_2000
794 , p8_a50 in out nocopy JTF_VARCHAR2_TABLE_2000
795 , p8_a51 in out nocopy JTF_VARCHAR2_TABLE_2000
796 , p8_a52 in out nocopy JTF_VARCHAR2_TABLE_2000
797 , p8_a53 in out nocopy JTF_NUMBER_TABLE
798 , p8_a54 in out nocopy JTF_VARCHAR2_TABLE_200
799 , p8_a55 in out nocopy JTF_NUMBER_TABLE
800 , p8_a56 in out nocopy JTF_VARCHAR2_TABLE_300
801 , p8_a57 in out nocopy JTF_NUMBER_TABLE
802 , p8_a58 in out nocopy JTF_NUMBER_TABLE
803 , p8_a59 in out nocopy JTF_VARCHAR2_TABLE_2000
804 , p8_a60 in out nocopy JTF_NUMBER_TABLE
805 , p8_a61 in out nocopy JTF_NUMBER_TABLE
806 , p8_a62 in out nocopy JTF_NUMBER_TABLE
807 , p8_a63 in out nocopy JTF_VARCHAR2_TABLE_2000
808 , p8_a64 in out nocopy JTF_NUMBER_TABLE
809 , p8_a65 in out nocopy JTF_VARCHAR2_TABLE_2000
810 , x_return_status out nocopy VARCHAR2
811 , x_msg_count out nocopy NUMBER
812 , x_msg_data out nocopy VARCHAR2
813 );
814 procedure shiftcustomschedule(p_api_version NUMBER
815 , p_init_msg_list VARCHAR2
816 , p_commit VARCHAR2
817 , p_validation_level NUMBER
818 , p_loan_id NUMBER
819 , p_old_due_date DATE
820 , p_new_due_date DATE
821 , p_based_on_terms VARCHAR2
822 , p8_a0 in out nocopy VARCHAR2
823 , p8_a1 in out nocopy VARCHAR2
824 , p9_a0 in out nocopy JTF_NUMBER_TABLE
825 , p9_a1 in out nocopy JTF_NUMBER_TABLE
826 , p9_a2 in out nocopy JTF_NUMBER_TABLE
827 , p9_a3 in out nocopy JTF_DATE_TABLE
828 , p9_a4 in out nocopy JTF_DATE_TABLE
829 , p9_a5 in out nocopy JTF_DATE_TABLE
830 , p9_a6 in out nocopy JTF_NUMBER_TABLE
831 , p9_a7 in out nocopy JTF_NUMBER_TABLE
832 , p9_a8 in out nocopy JTF_NUMBER_TABLE
833 , p9_a9 in out nocopy JTF_NUMBER_TABLE
834 , p9_a10 in out nocopy JTF_NUMBER_TABLE
835 , p9_a11 in out nocopy JTF_NUMBER_TABLE
836 , p9_a12 in out nocopy JTF_NUMBER_TABLE
837 , p9_a13 in out nocopy JTF_NUMBER_TABLE
838 , p9_a14 in out nocopy JTF_NUMBER_TABLE
839 , p9_a15 in out nocopy JTF_NUMBER_TABLE
840 , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_100
841 , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_200
842 , p9_a18 in out nocopy JTF_VARCHAR2_TABLE_200
843 , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_200
844 , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_200
845 , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_200
846 , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_200
847 , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_200
848 , p9_a24 in out nocopy JTF_VARCHAR2_TABLE_200
849 , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_200
850 , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_200
851 , p9_a27 in out nocopy JTF_VARCHAR2_TABLE_200
852 , p9_a28 in out nocopy JTF_VARCHAR2_TABLE_200
853 , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_200
854 , p9_a30 in out nocopy JTF_VARCHAR2_TABLE_200
855 , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_200
856 , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_200
857 , p9_a33 in out nocopy JTF_VARCHAR2_TABLE_200
858 , p9_a34 in out nocopy JTF_VARCHAR2_TABLE_200
859 , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_200
860 , p9_a36 in out nocopy JTF_VARCHAR2_TABLE_200
861 , p9_a37 in out nocopy JTF_NUMBER_TABLE
862 , p9_a38 in out nocopy JTF_NUMBER_TABLE
863 , p9_a39 in out nocopy JTF_NUMBER_TABLE
864 , p9_a40 in out nocopy JTF_NUMBER_TABLE
865 , p9_a41 in out nocopy JTF_NUMBER_TABLE
866 , p9_a42 in out nocopy JTF_NUMBER_TABLE
867 , p9_a43 in out nocopy JTF_NUMBER_TABLE
868 , p9_a44 in out nocopy JTF_NUMBER_TABLE
869 , p9_a45 in out nocopy JTF_VARCHAR2_TABLE_100
870 , p9_a46 in out nocopy JTF_VARCHAR2_TABLE_100
871 , p9_a47 in out nocopy JTF_VARCHAR2_TABLE_100
872 , p9_a48 in out nocopy JTF_NUMBER_TABLE
873 , p9_a49 in out nocopy JTF_VARCHAR2_TABLE_2000
874 , p9_a50 in out nocopy JTF_VARCHAR2_TABLE_2000
875 , p9_a51 in out nocopy JTF_VARCHAR2_TABLE_2000
876 , p9_a52 in out nocopy JTF_VARCHAR2_TABLE_2000
877 , p9_a53 in out nocopy JTF_NUMBER_TABLE
878 , p9_a54 in out nocopy JTF_VARCHAR2_TABLE_200
879 , p9_a55 in out nocopy JTF_NUMBER_TABLE
880 , p9_a56 in out nocopy JTF_VARCHAR2_TABLE_300
881 , p9_a57 in out nocopy JTF_NUMBER_TABLE
882 , p9_a58 in out nocopy JTF_NUMBER_TABLE
883 , p9_a59 in out nocopy JTF_VARCHAR2_TABLE_2000
884 , p9_a60 in out nocopy JTF_NUMBER_TABLE
885 , p9_a61 in out nocopy JTF_NUMBER_TABLE
886 , p9_a62 in out nocopy JTF_NUMBER_TABLE
887 , p9_a63 in out nocopy JTF_VARCHAR2_TABLE_2000
888 , p9_a64 in out nocopy JTF_NUMBER_TABLE
889 , p9_a65 in out nocopy JTF_VARCHAR2_TABLE_2000
890 , x_return_status out nocopy VARCHAR2
891 , x_msg_count out nocopy NUMBER
892 , x_msg_data out nocopy VARCHAR2
893 );
894 procedure addmissinginstallment(p_api_version NUMBER
895 , p_init_msg_list VARCHAR2
896 , p_commit VARCHAR2
897 , p_validation_level NUMBER
898 , p4_a0 NUMBER
899 , p4_a1 NUMBER
900 , p4_a2 NUMBER
901 , p4_a3 DATE
902 , p4_a4 DATE
903 , p4_a5 DATE
904 , p4_a6 NUMBER
905 , p4_a7 NUMBER
906 , p4_a8 NUMBER
907 , p4_a9 NUMBER
908 , p4_a10 NUMBER
909 , p4_a11 NUMBER
910 , p4_a12 NUMBER
911 , p4_a13 NUMBER
912 , p4_a14 NUMBER
913 , p4_a15 NUMBER
914 , p4_a16 VARCHAR2
915 , p4_a17 VARCHAR2
916 , p4_a18 VARCHAR2
917 , p4_a19 VARCHAR2
918 , p4_a20 VARCHAR2
919 , p4_a21 VARCHAR2
920 , p4_a22 VARCHAR2
921 , p4_a23 VARCHAR2
922 , p4_a24 VARCHAR2
923 , p4_a25 VARCHAR2
924 , p4_a26 VARCHAR2
925 , p4_a27 VARCHAR2
926 , p4_a28 VARCHAR2
927 , p4_a29 VARCHAR2
928 , p4_a30 VARCHAR2
929 , p4_a31 VARCHAR2
930 , p4_a32 VARCHAR2
931 , p4_a33 VARCHAR2
932 , p4_a34 VARCHAR2
933 , p4_a35 VARCHAR2
934 , p4_a36 VARCHAR2
935 , p4_a37 NUMBER
936 , p4_a38 NUMBER
937 , p4_a39 NUMBER
938 , p4_a40 NUMBER
939 , p4_a41 NUMBER
940 , p4_a42 NUMBER
941 , p4_a43 NUMBER
942 , p4_a44 NUMBER
943 , p4_a45 VARCHAR2
944 , p4_a46 VARCHAR2
945 , p4_a47 VARCHAR2
946 , p4_a48 NUMBER
947 , p4_a49 VARCHAR2
948 , p4_a50 VARCHAR2
949 , p4_a51 VARCHAR2
950 , p4_a52 VARCHAR2
951 , p4_a53 NUMBER
952 , p4_a54 VARCHAR2
953 , p4_a55 NUMBER
954 , p4_a56 VARCHAR2
955 , p4_a57 NUMBER
956 , p4_a58 NUMBER
957 , p4_a59 VARCHAR2
958 , p4_a60 NUMBER
959 , p4_a61 NUMBER
960 , p4_a62 NUMBER
961 , p4_a63 VARCHAR2
962 , p4_a64 NUMBER
963 , p4_a65 VARCHAR2
964 , x_return_status out nocopy VARCHAR2
965 , x_msg_count out nocopy NUMBER
966 , x_msg_data out nocopy VARCHAR2
967 );
968 procedure retaincustomschedule(p_api_version NUMBER
969 , p_init_msg_list VARCHAR2
970 , p_commit VARCHAR2
971 , p_validation_level NUMBER
972 , p4_a0 VARCHAR2
973 , p4_a1 VARCHAR2
974 , p5_a0 JTF_NUMBER_TABLE
975 , p5_a1 JTF_NUMBER_TABLE
976 , p5_a2 JTF_NUMBER_TABLE
977 , p5_a3 JTF_DATE_TABLE
978 , p5_a4 JTF_DATE_TABLE
979 , p5_a5 JTF_DATE_TABLE
980 , p5_a6 JTF_NUMBER_TABLE
981 , p5_a7 JTF_NUMBER_TABLE
982 , p5_a8 JTF_NUMBER_TABLE
983 , p5_a9 JTF_NUMBER_TABLE
984 , p5_a10 JTF_NUMBER_TABLE
985 , p5_a11 JTF_NUMBER_TABLE
986 , p5_a12 JTF_NUMBER_TABLE
987 , p5_a13 JTF_NUMBER_TABLE
988 , p5_a14 JTF_NUMBER_TABLE
989 , p5_a15 JTF_NUMBER_TABLE
990 , p5_a16 JTF_VARCHAR2_TABLE_100
991 , p5_a17 JTF_VARCHAR2_TABLE_200
992 , p5_a18 JTF_VARCHAR2_TABLE_200
993 , p5_a19 JTF_VARCHAR2_TABLE_200
994 , p5_a20 JTF_VARCHAR2_TABLE_200
995 , p5_a21 JTF_VARCHAR2_TABLE_200
996 , p5_a22 JTF_VARCHAR2_TABLE_200
997 , p5_a23 JTF_VARCHAR2_TABLE_200
998 , p5_a24 JTF_VARCHAR2_TABLE_200
999 , p5_a25 JTF_VARCHAR2_TABLE_200
1000 , p5_a26 JTF_VARCHAR2_TABLE_200
1001 , p5_a27 JTF_VARCHAR2_TABLE_200
1002 , p5_a28 JTF_VARCHAR2_TABLE_200
1003 , p5_a29 JTF_VARCHAR2_TABLE_200
1004 , p5_a30 JTF_VARCHAR2_TABLE_200
1005 , p5_a31 JTF_VARCHAR2_TABLE_200
1006 , p5_a32 JTF_VARCHAR2_TABLE_200
1007 , p5_a33 JTF_VARCHAR2_TABLE_200
1008 , p5_a34 JTF_VARCHAR2_TABLE_200
1009 , p5_a35 JTF_VARCHAR2_TABLE_200
1010 , p5_a36 JTF_VARCHAR2_TABLE_200
1011 , p5_a37 JTF_NUMBER_TABLE
1012 , p5_a38 JTF_NUMBER_TABLE
1013 , p5_a39 JTF_NUMBER_TABLE
1014 , p5_a40 JTF_NUMBER_TABLE
1015 , p5_a41 JTF_NUMBER_TABLE
1016 , p5_a42 JTF_NUMBER_TABLE
1017 , p5_a43 JTF_NUMBER_TABLE
1018 , p5_a44 JTF_NUMBER_TABLE
1019 , p5_a45 JTF_VARCHAR2_TABLE_100
1020 , p5_a46 JTF_VARCHAR2_TABLE_100
1021 , p5_a47 JTF_VARCHAR2_TABLE_100
1022 , p5_a48 JTF_NUMBER_TABLE
1023 , p5_a49 JTF_VARCHAR2_TABLE_2000
1024 , p5_a50 JTF_VARCHAR2_TABLE_2000
1025 , p5_a51 JTF_VARCHAR2_TABLE_2000
1026 , p5_a52 JTF_VARCHAR2_TABLE_2000
1027 , p5_a53 JTF_NUMBER_TABLE
1028 , p5_a54 JTF_VARCHAR2_TABLE_200
1029 , p5_a55 JTF_NUMBER_TABLE
1030 , p5_a56 JTF_VARCHAR2_TABLE_300
1031 , p5_a57 JTF_NUMBER_TABLE
1032 , p5_a58 JTF_NUMBER_TABLE
1033 , p5_a59 JTF_VARCHAR2_TABLE_2000
1034 , p5_a60 JTF_NUMBER_TABLE
1035 , p5_a61 JTF_NUMBER_TABLE
1036 , p5_a62 JTF_NUMBER_TABLE
1037 , p5_a63 JTF_VARCHAR2_TABLE_2000
1038 , p5_a64 JTF_NUMBER_TABLE
1039 , p5_a65 JTF_VARCHAR2_TABLE_2000
1040 , x_return_status out nocopy VARCHAR2
1041 , x_msg_count out nocopy NUMBER
1042 , x_msg_data out nocopy VARCHAR2
1043 );
1044 procedure getretainedschedule(p_api_version NUMBER
1045 , p_init_msg_list VARCHAR2
1046 , p_commit VARCHAR2
1047 , p_validation_level NUMBER
1048 , p4_a0 out nocopy VARCHAR2
1049 , p4_a1 out nocopy VARCHAR2
1050 , p5_a0 out nocopy JTF_NUMBER_TABLE
1051 , p5_a1 out nocopy JTF_NUMBER_TABLE
1052 , p5_a2 out nocopy JTF_NUMBER_TABLE
1053 , p5_a3 out nocopy JTF_DATE_TABLE
1054 , p5_a4 out nocopy JTF_DATE_TABLE
1055 , p5_a5 out nocopy JTF_DATE_TABLE
1056 , p5_a6 out nocopy JTF_NUMBER_TABLE
1057 , p5_a7 out nocopy JTF_NUMBER_TABLE
1058 , p5_a8 out nocopy JTF_NUMBER_TABLE
1059 , p5_a9 out nocopy JTF_NUMBER_TABLE
1060 , p5_a10 out nocopy JTF_NUMBER_TABLE
1061 , p5_a11 out nocopy JTF_NUMBER_TABLE
1062 , p5_a12 out nocopy JTF_NUMBER_TABLE
1063 , p5_a13 out nocopy JTF_NUMBER_TABLE
1064 , p5_a14 out nocopy JTF_NUMBER_TABLE
1065 , p5_a15 out nocopy JTF_NUMBER_TABLE
1066 , p5_a16 out nocopy JTF_VARCHAR2_TABLE_100
1067 , p5_a17 out nocopy JTF_VARCHAR2_TABLE_200
1068 , p5_a18 out nocopy JTF_VARCHAR2_TABLE_200
1069 , p5_a19 out nocopy JTF_VARCHAR2_TABLE_200
1070 , p5_a20 out nocopy JTF_VARCHAR2_TABLE_200
1071 , p5_a21 out nocopy JTF_VARCHAR2_TABLE_200
1072 , p5_a22 out nocopy JTF_VARCHAR2_TABLE_200
1073 , p5_a23 out nocopy JTF_VARCHAR2_TABLE_200
1074 , p5_a24 out nocopy JTF_VARCHAR2_TABLE_200
1075 , p5_a25 out nocopy JTF_VARCHAR2_TABLE_200
1076 , p5_a26 out nocopy JTF_VARCHAR2_TABLE_200
1077 , p5_a27 out nocopy JTF_VARCHAR2_TABLE_200
1078 , p5_a28 out nocopy JTF_VARCHAR2_TABLE_200
1079 , p5_a29 out nocopy JTF_VARCHAR2_TABLE_200
1080 , p5_a30 out nocopy JTF_VARCHAR2_TABLE_200
1081 , p5_a31 out nocopy JTF_VARCHAR2_TABLE_200
1082 , p5_a32 out nocopy JTF_VARCHAR2_TABLE_200
1083 , p5_a33 out nocopy JTF_VARCHAR2_TABLE_200
1084 , p5_a34 out nocopy JTF_VARCHAR2_TABLE_200
1085 , p5_a35 out nocopy JTF_VARCHAR2_TABLE_200
1086 , p5_a36 out nocopy JTF_VARCHAR2_TABLE_200
1087 , p5_a37 out nocopy JTF_NUMBER_TABLE
1088 , p5_a38 out nocopy JTF_NUMBER_TABLE
1089 , p5_a39 out nocopy JTF_NUMBER_TABLE
1090 , p5_a40 out nocopy JTF_NUMBER_TABLE
1091 , p5_a41 out nocopy JTF_NUMBER_TABLE
1092 , p5_a42 out nocopy JTF_NUMBER_TABLE
1093 , p5_a43 out nocopy JTF_NUMBER_TABLE
1094 , p5_a44 out nocopy JTF_NUMBER_TABLE
1095 , p5_a45 out nocopy JTF_VARCHAR2_TABLE_100
1096 , p5_a46 out nocopy JTF_VARCHAR2_TABLE_100
1097 , p5_a47 out nocopy JTF_VARCHAR2_TABLE_100
1098 , p5_a48 out nocopy JTF_NUMBER_TABLE
1099 , p5_a49 out nocopy JTF_VARCHAR2_TABLE_2000
1100 , p5_a50 out nocopy JTF_VARCHAR2_TABLE_2000
1101 , p5_a51 out nocopy JTF_VARCHAR2_TABLE_2000
1102 , p5_a52 out nocopy JTF_VARCHAR2_TABLE_2000
1103 , p5_a53 out nocopy JTF_NUMBER_TABLE
1104 , p5_a54 out nocopy JTF_VARCHAR2_TABLE_200
1105 , p5_a55 out nocopy JTF_NUMBER_TABLE
1106 , p5_a56 out nocopy JTF_VARCHAR2_TABLE_300
1107 , p5_a57 out nocopy JTF_NUMBER_TABLE
1108 , p5_a58 out nocopy JTF_NUMBER_TABLE
1109 , p5_a59 out nocopy JTF_VARCHAR2_TABLE_2000
1110 , p5_a60 out nocopy JTF_NUMBER_TABLE
1111 , p5_a61 out nocopy JTF_NUMBER_TABLE
1112 , p5_a62 out nocopy JTF_NUMBER_TABLE
1113 , p5_a63 out nocopy JTF_VARCHAR2_TABLE_2000
1114 , p5_a64 out nocopy JTF_NUMBER_TABLE
1115 , p5_a65 out nocopy JTF_VARCHAR2_TABLE_2000
1116 , x_return_status out nocopy VARCHAR2
1117 , x_msg_count out nocopy NUMBER
1118 , x_msg_data out nocopy VARCHAR2
1119 );
1120 end lns_custom_pub_w;