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
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: );
52: procedure rosetta_table_copy_out_p1(t lns_custom_pub.custom_tbl, a0 out nocopy 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: );
52: procedure rosetta_table_copy_out_p1(t lns_custom_pub.custom_tbl, a0 out nocopy JTF_NUMBER_TABLE
53: , a1 out nocopy 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: );
52: procedure rosetta_table_copy_out_p1(t lns_custom_pub.custom_tbl, a0 out nocopy JTF_NUMBER_TABLE
53: , a1 out nocopy JTF_NUMBER_TABLE
54: , a2 out nocopy JTF_NUMBER_TABLE
64: , a12 out nocopy JTF_NUMBER_TABLE
65: , a13 out nocopy JTF_NUMBER_TABLE
66: , a14 out nocopy JTF_NUMBER_TABLE
67: , a15 out nocopy JTF_NUMBER_TABLE
68: , a16 out nocopy JTF_VARCHAR2_TABLE_100
69: , a17 out nocopy JTF_VARCHAR2_TABLE_200
70: , a18 out nocopy JTF_VARCHAR2_TABLE_200
71: , a19 out nocopy JTF_VARCHAR2_TABLE_200
72: , a20 out nocopy JTF_VARCHAR2_TABLE_200
93: , a41 out nocopy JTF_NUMBER_TABLE
94: , a42 out nocopy JTF_NUMBER_TABLE
95: , a43 out nocopy JTF_NUMBER_TABLE
96: , a44 out nocopy JTF_NUMBER_TABLE
97: , a45 out nocopy JTF_VARCHAR2_TABLE_100
98: , a46 out nocopy JTF_VARCHAR2_TABLE_100
99: , a47 out nocopy JTF_VARCHAR2_TABLE_100
100: );
101:
94: , a42 out nocopy JTF_NUMBER_TABLE
95: , a43 out nocopy JTF_NUMBER_TABLE
96: , a44 out nocopy JTF_NUMBER_TABLE
97: , a45 out nocopy JTF_VARCHAR2_TABLE_100
98: , a46 out nocopy JTF_VARCHAR2_TABLE_100
99: , a47 out nocopy JTF_VARCHAR2_TABLE_100
100: );
101:
102: procedure resetcustomschedule(p_loan_id NUMBER
95: , a43 out nocopy JTF_NUMBER_TABLE
96: , a44 out nocopy JTF_NUMBER_TABLE
97: , a45 out nocopy JTF_VARCHAR2_TABLE_100
98: , a46 out nocopy JTF_VARCHAR2_TABLE_100
99: , a47 out nocopy JTF_VARCHAR2_TABLE_100
100: );
101:
102: procedure resetcustomschedule(p_loan_id NUMBER
103: , p_init_msg_list VARCHAR2
122: , p0_a12 JTF_NUMBER_TABLE
123: , p0_a13 JTF_NUMBER_TABLE
124: , p0_a14 JTF_NUMBER_TABLE
125: , p0_a15 JTF_NUMBER_TABLE
126: , p0_a16 JTF_VARCHAR2_TABLE_100
127: , p0_a17 JTF_VARCHAR2_TABLE_200
128: , p0_a18 JTF_VARCHAR2_TABLE_200
129: , p0_a19 JTF_VARCHAR2_TABLE_200
130: , p0_a20 JTF_VARCHAR2_TABLE_200
151: , p0_a41 JTF_NUMBER_TABLE
152: , p0_a42 JTF_NUMBER_TABLE
153: , p0_a43 JTF_NUMBER_TABLE
154: , p0_a44 JTF_NUMBER_TABLE
155: , p0_a45 JTF_VARCHAR2_TABLE_100
156: , p0_a46 JTF_VARCHAR2_TABLE_100
157: , p0_a47 JTF_VARCHAR2_TABLE_100
158: , p_loan_id NUMBER
159: , p_init_msg_list VARCHAR2
152: , p0_a42 JTF_NUMBER_TABLE
153: , p0_a43 JTF_NUMBER_TABLE
154: , p0_a44 JTF_NUMBER_TABLE
155: , p0_a45 JTF_VARCHAR2_TABLE_100
156: , p0_a46 JTF_VARCHAR2_TABLE_100
157: , p0_a47 JTF_VARCHAR2_TABLE_100
158: , p_loan_id NUMBER
159: , p_init_msg_list VARCHAR2
160: , p_commit VARCHAR2
153: , p0_a43 JTF_NUMBER_TABLE
154: , p0_a44 JTF_NUMBER_TABLE
155: , p0_a45 JTF_VARCHAR2_TABLE_100
156: , p0_a46 JTF_VARCHAR2_TABLE_100
157: , p0_a47 JTF_VARCHAR2_TABLE_100
158: , p_loan_id NUMBER
159: , p_init_msg_list VARCHAR2
160: , p_commit VARCHAR2
161: , x_return_status out nocopy VARCHAR2
178: , p0_a12 JTF_NUMBER_TABLE
179: , p0_a13 JTF_NUMBER_TABLE
180: , p0_a14 JTF_NUMBER_TABLE
181: , p0_a15 JTF_NUMBER_TABLE
182: , p0_a16 JTF_VARCHAR2_TABLE_100
183: , p0_a17 JTF_VARCHAR2_TABLE_200
184: , p0_a18 JTF_VARCHAR2_TABLE_200
185: , p0_a19 JTF_VARCHAR2_TABLE_200
186: , p0_a20 JTF_VARCHAR2_TABLE_200
207: , p0_a41 JTF_NUMBER_TABLE
208: , p0_a42 JTF_NUMBER_TABLE
209: , p0_a43 JTF_NUMBER_TABLE
210: , p0_a44 JTF_NUMBER_TABLE
211: , p0_a45 JTF_VARCHAR2_TABLE_100
212: , p0_a46 JTF_VARCHAR2_TABLE_100
213: , p0_a47 JTF_VARCHAR2_TABLE_100
214: , p_loan_id NUMBER
215: , p_init_msg_list VARCHAR2
208: , p0_a42 JTF_NUMBER_TABLE
209: , p0_a43 JTF_NUMBER_TABLE
210: , p0_a44 JTF_NUMBER_TABLE
211: , p0_a45 JTF_VARCHAR2_TABLE_100
212: , p0_a46 JTF_VARCHAR2_TABLE_100
213: , p0_a47 JTF_VARCHAR2_TABLE_100
214: , p_loan_id NUMBER
215: , p_init_msg_list VARCHAR2
216: , p_commit VARCHAR2
209: , p0_a43 JTF_NUMBER_TABLE
210: , p0_a44 JTF_NUMBER_TABLE
211: , p0_a45 JTF_VARCHAR2_TABLE_100
212: , p0_a46 JTF_VARCHAR2_TABLE_100
213: , p0_a47 JTF_VARCHAR2_TABLE_100
214: , p_loan_id NUMBER
215: , p_init_msg_list VARCHAR2
216: , p_commit VARCHAR2
217: , x_return_status out nocopy VARCHAR2
339: , p0_a12 JTF_NUMBER_TABLE
340: , p0_a13 JTF_NUMBER_TABLE
341: , p0_a14 JTF_NUMBER_TABLE
342: , p0_a15 JTF_NUMBER_TABLE
343: , p0_a16 JTF_VARCHAR2_TABLE_100
344: , p0_a17 JTF_VARCHAR2_TABLE_200
345: , p0_a18 JTF_VARCHAR2_TABLE_200
346: , p0_a19 JTF_VARCHAR2_TABLE_200
347: , p0_a20 JTF_VARCHAR2_TABLE_200
368: , p0_a41 JTF_NUMBER_TABLE
369: , p0_a42 JTF_NUMBER_TABLE
370: , p0_a43 JTF_NUMBER_TABLE
371: , p0_a44 JTF_NUMBER_TABLE
372: , p0_a45 JTF_VARCHAR2_TABLE_100
373: , p0_a46 JTF_VARCHAR2_TABLE_100
374: , p0_a47 JTF_VARCHAR2_TABLE_100
375: , p_loan_id NUMBER
376: , p_create_flag number
369: , p0_a42 JTF_NUMBER_TABLE
370: , p0_a43 JTF_NUMBER_TABLE
371: , p0_a44 JTF_NUMBER_TABLE
372: , p0_a45 JTF_VARCHAR2_TABLE_100
373: , p0_a46 JTF_VARCHAR2_TABLE_100
374: , p0_a47 JTF_VARCHAR2_TABLE_100
375: , p_loan_id NUMBER
376: , p_create_flag number
377: , x_installment out nocopy NUMBER
370: , p0_a43 JTF_NUMBER_TABLE
371: , p0_a44 JTF_NUMBER_TABLE
372: , p0_a45 JTF_VARCHAR2_TABLE_100
373: , p0_a46 JTF_VARCHAR2_TABLE_100
374: , p0_a47 JTF_VARCHAR2_TABLE_100
375: , p_loan_id NUMBER
376: , p_create_flag number
377: , x_installment out nocopy NUMBER
378: , x_return_status out nocopy VARCHAR2
453: , p7_a12 in out nocopy JTF_NUMBER_TABLE
454: , p7_a13 in out nocopy JTF_NUMBER_TABLE
455: , p7_a14 in out nocopy JTF_NUMBER_TABLE
456: , p7_a15 in out nocopy JTF_NUMBER_TABLE
457: , p7_a16 in out nocopy JTF_VARCHAR2_TABLE_100
458: , p7_a17 in out nocopy JTF_VARCHAR2_TABLE_200
459: , p7_a18 in out nocopy JTF_VARCHAR2_TABLE_200
460: , p7_a19 in out nocopy JTF_VARCHAR2_TABLE_200
461: , p7_a20 in out nocopy JTF_VARCHAR2_TABLE_200
482: , p7_a41 in out nocopy JTF_NUMBER_TABLE
483: , p7_a42 in out nocopy JTF_NUMBER_TABLE
484: , p7_a43 in out nocopy JTF_NUMBER_TABLE
485: , p7_a44 in out nocopy JTF_NUMBER_TABLE
486: , p7_a45 in out nocopy JTF_VARCHAR2_TABLE_100
487: , p7_a46 in out nocopy JTF_VARCHAR2_TABLE_100
488: , p7_a47 in out nocopy JTF_VARCHAR2_TABLE_100
489: , x_return_status out nocopy VARCHAR2
490: , x_msg_count out nocopy NUMBER
483: , p7_a42 in out nocopy JTF_NUMBER_TABLE
484: , p7_a43 in out nocopy JTF_NUMBER_TABLE
485: , p7_a44 in out nocopy JTF_NUMBER_TABLE
486: , p7_a45 in out nocopy JTF_VARCHAR2_TABLE_100
487: , p7_a46 in out nocopy JTF_VARCHAR2_TABLE_100
488: , p7_a47 in out nocopy JTF_VARCHAR2_TABLE_100
489: , x_return_status out nocopy VARCHAR2
490: , x_msg_count out nocopy NUMBER
491: , x_msg_data out nocopy VARCHAR2
484: , p7_a43 in out nocopy JTF_NUMBER_TABLE
485: , p7_a44 in out nocopy JTF_NUMBER_TABLE
486: , p7_a45 in out nocopy JTF_VARCHAR2_TABLE_100
487: , p7_a46 in out nocopy JTF_VARCHAR2_TABLE_100
488: , p7_a47 in out nocopy JTF_VARCHAR2_TABLE_100
489: , x_return_status out nocopy VARCHAR2
490: , x_msg_count out nocopy NUMBER
491: , x_msg_data out nocopy VARCHAR2
492: );
512: , p7_a12 out nocopy JTF_NUMBER_TABLE
513: , p7_a13 out nocopy JTF_NUMBER_TABLE
514: , p7_a14 out nocopy JTF_NUMBER_TABLE
515: , p7_a15 out nocopy JTF_NUMBER_TABLE
516: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
517: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_200
518: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_200
519: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_200
520: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_200
541: , p7_a41 out nocopy JTF_NUMBER_TABLE
542: , p7_a42 out nocopy JTF_NUMBER_TABLE
543: , p7_a43 out nocopy JTF_NUMBER_TABLE
544: , p7_a44 out nocopy JTF_NUMBER_TABLE
545: , p7_a45 out nocopy JTF_VARCHAR2_TABLE_100
546: , p7_a46 out nocopy JTF_VARCHAR2_TABLE_100
547: , p7_a47 out nocopy JTF_VARCHAR2_TABLE_100
548: , x_return_status out nocopy VARCHAR2
549: , x_msg_count out nocopy NUMBER
542: , p7_a42 out nocopy JTF_NUMBER_TABLE
543: , p7_a43 out nocopy JTF_NUMBER_TABLE
544: , p7_a44 out nocopy JTF_NUMBER_TABLE
545: , p7_a45 out nocopy JTF_VARCHAR2_TABLE_100
546: , p7_a46 out nocopy JTF_VARCHAR2_TABLE_100
547: , p7_a47 out nocopy JTF_VARCHAR2_TABLE_100
548: , x_return_status out nocopy VARCHAR2
549: , x_msg_count out nocopy NUMBER
550: , x_msg_data out nocopy VARCHAR2
543: , p7_a43 out nocopy JTF_NUMBER_TABLE
544: , p7_a44 out nocopy JTF_NUMBER_TABLE
545: , p7_a45 out nocopy JTF_VARCHAR2_TABLE_100
546: , p7_a46 out nocopy JTF_VARCHAR2_TABLE_100
547: , p7_a47 out nocopy JTF_VARCHAR2_TABLE_100
548: , x_return_status out nocopy VARCHAR2
549: , x_msg_count out nocopy NUMBER
550: , x_msg_data out nocopy VARCHAR2
551: );
571: , p7_a12 in out nocopy JTF_NUMBER_TABLE
572: , p7_a13 in out nocopy JTF_NUMBER_TABLE
573: , p7_a14 in out nocopy JTF_NUMBER_TABLE
574: , p7_a15 in out nocopy JTF_NUMBER_TABLE
575: , p7_a16 in out nocopy JTF_VARCHAR2_TABLE_100
576: , p7_a17 in out nocopy JTF_VARCHAR2_TABLE_200
577: , p7_a18 in out nocopy JTF_VARCHAR2_TABLE_200
578: , p7_a19 in out nocopy JTF_VARCHAR2_TABLE_200
579: , p7_a20 in out nocopy JTF_VARCHAR2_TABLE_200
600: , p7_a41 in out nocopy JTF_NUMBER_TABLE
601: , p7_a42 in out nocopy JTF_NUMBER_TABLE
602: , p7_a43 in out nocopy JTF_NUMBER_TABLE
603: , p7_a44 in out nocopy JTF_NUMBER_TABLE
604: , p7_a45 in out nocopy JTF_VARCHAR2_TABLE_100
605: , p7_a46 in out nocopy JTF_VARCHAR2_TABLE_100
606: , p7_a47 in out nocopy JTF_VARCHAR2_TABLE_100
607: , x_return_status out nocopy VARCHAR2
608: , x_msg_count out nocopy NUMBER
601: , p7_a42 in out nocopy JTF_NUMBER_TABLE
602: , p7_a43 in out nocopy JTF_NUMBER_TABLE
603: , p7_a44 in out nocopy JTF_NUMBER_TABLE
604: , p7_a45 in out nocopy JTF_VARCHAR2_TABLE_100
605: , p7_a46 in out nocopy JTF_VARCHAR2_TABLE_100
606: , p7_a47 in out nocopy JTF_VARCHAR2_TABLE_100
607: , x_return_status out nocopy VARCHAR2
608: , x_msg_count out nocopy NUMBER
609: , x_msg_data out nocopy VARCHAR2
602: , p7_a43 in out nocopy JTF_NUMBER_TABLE
603: , p7_a44 in out nocopy JTF_NUMBER_TABLE
604: , p7_a45 in out nocopy JTF_VARCHAR2_TABLE_100
605: , p7_a46 in out nocopy JTF_VARCHAR2_TABLE_100
606: , p7_a47 in out nocopy JTF_VARCHAR2_TABLE_100
607: , x_return_status out nocopy VARCHAR2
608: , x_msg_count out nocopy NUMBER
609: , x_msg_data out nocopy VARCHAR2
610: );
632: , p9_a12 in out nocopy JTF_NUMBER_TABLE
633: , p9_a13 in out nocopy JTF_NUMBER_TABLE
634: , p9_a14 in out nocopy JTF_NUMBER_TABLE
635: , p9_a15 in out nocopy JTF_NUMBER_TABLE
636: , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_100
637: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_200
638: , p9_a18 in out nocopy JTF_VARCHAR2_TABLE_200
639: , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_200
640: , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_200
661: , p9_a41 in out nocopy JTF_NUMBER_TABLE
662: , p9_a42 in out nocopy JTF_NUMBER_TABLE
663: , p9_a43 in out nocopy JTF_NUMBER_TABLE
664: , p9_a44 in out nocopy JTF_NUMBER_TABLE
665: , p9_a45 in out nocopy JTF_VARCHAR2_TABLE_100
666: , p9_a46 in out nocopy JTF_VARCHAR2_TABLE_100
667: , p9_a47 in out nocopy JTF_VARCHAR2_TABLE_100
668: , x_return_status out nocopy VARCHAR2
669: , x_msg_count out nocopy NUMBER
662: , p9_a42 in out nocopy JTF_NUMBER_TABLE
663: , p9_a43 in out nocopy JTF_NUMBER_TABLE
664: , p9_a44 in out nocopy JTF_NUMBER_TABLE
665: , p9_a45 in out nocopy JTF_VARCHAR2_TABLE_100
666: , p9_a46 in out nocopy JTF_VARCHAR2_TABLE_100
667: , p9_a47 in out nocopy JTF_VARCHAR2_TABLE_100
668: , x_return_status out nocopy VARCHAR2
669: , x_msg_count out nocopy NUMBER
670: , x_msg_data out nocopy VARCHAR2
663: , p9_a43 in out nocopy JTF_NUMBER_TABLE
664: , p9_a44 in out nocopy JTF_NUMBER_TABLE
665: , p9_a45 in out nocopy JTF_VARCHAR2_TABLE_100
666: , p9_a46 in out nocopy JTF_VARCHAR2_TABLE_100
667: , p9_a47 in out nocopy JTF_VARCHAR2_TABLE_100
668: , x_return_status out nocopy VARCHAR2
669: , x_msg_count out nocopy NUMBER
670: , x_msg_data out nocopy VARCHAR2
671: );