1: package lns_fee_engine_w as
2: /* $Header: LNS_FEE_ENGINJ_S.pls 120.3 2005/08/02 14:37 raverma noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy lns_fee_engine.fee_basis_tbl, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: );
6: procedure rosetta_table_copy_out_p1(t lns_fee_engine.fee_basis_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
7: , a1 out nocopy JTF_NUMBER_TABLE
2: /* $Header: LNS_FEE_ENGINJ_S.pls 120.3 2005/08/02 14:37 raverma noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy lns_fee_engine.fee_basis_tbl, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: );
6: procedure rosetta_table_copy_out_p1(t lns_fee_engine.fee_basis_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
7: , a1 out nocopy JTF_NUMBER_TABLE
8: );
9:
10: procedure rosetta_table_copy_in_p3(t out nocopy lns_fee_engine.fee_structure_tbl, a0 JTF_NUMBER_TABLE
7: , a1 out nocopy JTF_NUMBER_TABLE
8: );
9:
10: procedure rosetta_table_copy_in_p3(t out nocopy lns_fee_engine.fee_structure_tbl, a0 JTF_NUMBER_TABLE
11: , a1 JTF_VARCHAR2_TABLE_100
12: , a2 JTF_VARCHAR2_TABLE_300
13: , a3 JTF_VARCHAR2_TABLE_100
14: , a4 JTF_VARCHAR2_TABLE_100
15: , a5 JTF_NUMBER_TABLE
9:
10: procedure rosetta_table_copy_in_p3(t out nocopy lns_fee_engine.fee_structure_tbl, a0 JTF_NUMBER_TABLE
11: , a1 JTF_VARCHAR2_TABLE_100
12: , a2 JTF_VARCHAR2_TABLE_300
13: , a3 JTF_VARCHAR2_TABLE_100
14: , a4 JTF_VARCHAR2_TABLE_100
15: , a5 JTF_NUMBER_TABLE
16: , a6 JTF_VARCHAR2_TABLE_100
17: , a7 JTF_DATE_TABLE
10: procedure rosetta_table_copy_in_p3(t out nocopy lns_fee_engine.fee_structure_tbl, a0 JTF_NUMBER_TABLE
11: , a1 JTF_VARCHAR2_TABLE_100
12: , a2 JTF_VARCHAR2_TABLE_300
13: , a3 JTF_VARCHAR2_TABLE_100
14: , a4 JTF_VARCHAR2_TABLE_100
15: , a5 JTF_NUMBER_TABLE
16: , a6 JTF_VARCHAR2_TABLE_100
17: , a7 JTF_DATE_TABLE
18: , a8 JTF_DATE_TABLE
12: , a2 JTF_VARCHAR2_TABLE_300
13: , a3 JTF_VARCHAR2_TABLE_100
14: , a4 JTF_VARCHAR2_TABLE_100
15: , a5 JTF_NUMBER_TABLE
16: , a6 JTF_VARCHAR2_TABLE_100
17: , a7 JTF_DATE_TABLE
18: , a8 JTF_DATE_TABLE
19: , a9 JTF_NUMBER_TABLE
20: , a10 JTF_VARCHAR2_TABLE_100
16: , a6 JTF_VARCHAR2_TABLE_100
17: , a7 JTF_DATE_TABLE
18: , a8 JTF_DATE_TABLE
19: , a9 JTF_NUMBER_TABLE
20: , a10 JTF_VARCHAR2_TABLE_100
21: , a11 JTF_VARCHAR2_TABLE_100
22: , a12 JTF_NUMBER_TABLE
23: , a13 JTF_NUMBER_TABLE
24: , a14 JTF_VARCHAR2_TABLE_100
17: , a7 JTF_DATE_TABLE
18: , a8 JTF_DATE_TABLE
19: , a9 JTF_NUMBER_TABLE
20: , a10 JTF_VARCHAR2_TABLE_100
21: , a11 JTF_VARCHAR2_TABLE_100
22: , a12 JTF_NUMBER_TABLE
23: , a13 JTF_NUMBER_TABLE
24: , a14 JTF_VARCHAR2_TABLE_100
25: , a15 JTF_VARCHAR2_TABLE_100
20: , a10 JTF_VARCHAR2_TABLE_100
21: , a11 JTF_VARCHAR2_TABLE_100
22: , a12 JTF_NUMBER_TABLE
23: , a13 JTF_NUMBER_TABLE
24: , a14 JTF_VARCHAR2_TABLE_100
25: , a15 JTF_VARCHAR2_TABLE_100
26: , a16 JTF_VARCHAR2_TABLE_100
27: , a17 JTF_NUMBER_TABLE
28: , a18 JTF_VARCHAR2_TABLE_100
21: , a11 JTF_VARCHAR2_TABLE_100
22: , a12 JTF_NUMBER_TABLE
23: , a13 JTF_NUMBER_TABLE
24: , a14 JTF_VARCHAR2_TABLE_100
25: , a15 JTF_VARCHAR2_TABLE_100
26: , a16 JTF_VARCHAR2_TABLE_100
27: , a17 JTF_NUMBER_TABLE
28: , a18 JTF_VARCHAR2_TABLE_100
29: , a19 JTF_VARCHAR2_TABLE_100
22: , a12 JTF_NUMBER_TABLE
23: , a13 JTF_NUMBER_TABLE
24: , a14 JTF_VARCHAR2_TABLE_100
25: , a15 JTF_VARCHAR2_TABLE_100
26: , a16 JTF_VARCHAR2_TABLE_100
27: , a17 JTF_NUMBER_TABLE
28: , a18 JTF_VARCHAR2_TABLE_100
29: , a19 JTF_VARCHAR2_TABLE_100
30: , a20 JTF_NUMBER_TABLE
24: , a14 JTF_VARCHAR2_TABLE_100
25: , a15 JTF_VARCHAR2_TABLE_100
26: , a16 JTF_VARCHAR2_TABLE_100
27: , a17 JTF_NUMBER_TABLE
28: , a18 JTF_VARCHAR2_TABLE_100
29: , a19 JTF_VARCHAR2_TABLE_100
30: , a20 JTF_NUMBER_TABLE
31: , a21 JTF_NUMBER_TABLE
32: , a22 JTF_DATE_TABLE
25: , a15 JTF_VARCHAR2_TABLE_100
26: , a16 JTF_VARCHAR2_TABLE_100
27: , a17 JTF_NUMBER_TABLE
28: , a18 JTF_VARCHAR2_TABLE_100
29: , a19 JTF_VARCHAR2_TABLE_100
30: , a20 JTF_NUMBER_TABLE
31: , a21 JTF_NUMBER_TABLE
32: , a22 JTF_DATE_TABLE
33: );
31: , a21 JTF_NUMBER_TABLE
32: , a22 JTF_DATE_TABLE
33: );
34: procedure rosetta_table_copy_out_p3(t lns_fee_engine.fee_structure_tbl, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_VARCHAR2_TABLE_100
36: , a2 out nocopy JTF_VARCHAR2_TABLE_300
37: , a3 out nocopy JTF_VARCHAR2_TABLE_100
38: , a4 out nocopy JTF_VARCHAR2_TABLE_100
39: , a5 out nocopy JTF_NUMBER_TABLE
33: );
34: procedure rosetta_table_copy_out_p3(t lns_fee_engine.fee_structure_tbl, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_VARCHAR2_TABLE_100
36: , a2 out nocopy JTF_VARCHAR2_TABLE_300
37: , a3 out nocopy JTF_VARCHAR2_TABLE_100
38: , a4 out nocopy JTF_VARCHAR2_TABLE_100
39: , a5 out nocopy JTF_NUMBER_TABLE
40: , a6 out nocopy JTF_VARCHAR2_TABLE_100
41: , a7 out nocopy JTF_DATE_TABLE
34: procedure rosetta_table_copy_out_p3(t lns_fee_engine.fee_structure_tbl, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_VARCHAR2_TABLE_100
36: , a2 out nocopy JTF_VARCHAR2_TABLE_300
37: , a3 out nocopy JTF_VARCHAR2_TABLE_100
38: , a4 out nocopy JTF_VARCHAR2_TABLE_100
39: , a5 out nocopy JTF_NUMBER_TABLE
40: , a6 out nocopy JTF_VARCHAR2_TABLE_100
41: , a7 out nocopy JTF_DATE_TABLE
42: , a8 out nocopy JTF_DATE_TABLE
36: , a2 out nocopy JTF_VARCHAR2_TABLE_300
37: , a3 out nocopy JTF_VARCHAR2_TABLE_100
38: , a4 out nocopy JTF_VARCHAR2_TABLE_100
39: , a5 out nocopy JTF_NUMBER_TABLE
40: , a6 out nocopy JTF_VARCHAR2_TABLE_100
41: , a7 out nocopy JTF_DATE_TABLE
42: , a8 out nocopy JTF_DATE_TABLE
43: , a9 out nocopy JTF_NUMBER_TABLE
44: , a10 out nocopy JTF_VARCHAR2_TABLE_100
40: , a6 out nocopy JTF_VARCHAR2_TABLE_100
41: , a7 out nocopy JTF_DATE_TABLE
42: , a8 out nocopy JTF_DATE_TABLE
43: , a9 out nocopy JTF_NUMBER_TABLE
44: , a10 out nocopy JTF_VARCHAR2_TABLE_100
45: , a11 out nocopy JTF_VARCHAR2_TABLE_100
46: , a12 out nocopy JTF_NUMBER_TABLE
47: , a13 out nocopy JTF_NUMBER_TABLE
48: , a14 out nocopy JTF_VARCHAR2_TABLE_100
41: , a7 out nocopy JTF_DATE_TABLE
42: , a8 out nocopy JTF_DATE_TABLE
43: , a9 out nocopy JTF_NUMBER_TABLE
44: , a10 out nocopy JTF_VARCHAR2_TABLE_100
45: , a11 out nocopy JTF_VARCHAR2_TABLE_100
46: , a12 out nocopy JTF_NUMBER_TABLE
47: , a13 out nocopy JTF_NUMBER_TABLE
48: , a14 out nocopy JTF_VARCHAR2_TABLE_100
49: , a15 out nocopy JTF_VARCHAR2_TABLE_100
44: , a10 out nocopy JTF_VARCHAR2_TABLE_100
45: , a11 out nocopy JTF_VARCHAR2_TABLE_100
46: , a12 out nocopy JTF_NUMBER_TABLE
47: , a13 out nocopy JTF_NUMBER_TABLE
48: , a14 out nocopy JTF_VARCHAR2_TABLE_100
49: , a15 out nocopy JTF_VARCHAR2_TABLE_100
50: , a16 out nocopy JTF_VARCHAR2_TABLE_100
51: , a17 out nocopy JTF_NUMBER_TABLE
52: , a18 out nocopy JTF_VARCHAR2_TABLE_100
45: , a11 out nocopy JTF_VARCHAR2_TABLE_100
46: , a12 out nocopy JTF_NUMBER_TABLE
47: , a13 out nocopy JTF_NUMBER_TABLE
48: , a14 out nocopy JTF_VARCHAR2_TABLE_100
49: , a15 out nocopy JTF_VARCHAR2_TABLE_100
50: , a16 out nocopy JTF_VARCHAR2_TABLE_100
51: , a17 out nocopy JTF_NUMBER_TABLE
52: , a18 out nocopy JTF_VARCHAR2_TABLE_100
53: , a19 out nocopy JTF_VARCHAR2_TABLE_100
46: , a12 out nocopy JTF_NUMBER_TABLE
47: , a13 out nocopy JTF_NUMBER_TABLE
48: , a14 out nocopy JTF_VARCHAR2_TABLE_100
49: , a15 out nocopy JTF_VARCHAR2_TABLE_100
50: , a16 out nocopy JTF_VARCHAR2_TABLE_100
51: , a17 out nocopy JTF_NUMBER_TABLE
52: , a18 out nocopy JTF_VARCHAR2_TABLE_100
53: , a19 out nocopy JTF_VARCHAR2_TABLE_100
54: , a20 out nocopy JTF_NUMBER_TABLE
48: , a14 out nocopy JTF_VARCHAR2_TABLE_100
49: , a15 out nocopy JTF_VARCHAR2_TABLE_100
50: , a16 out nocopy JTF_VARCHAR2_TABLE_100
51: , a17 out nocopy JTF_NUMBER_TABLE
52: , a18 out nocopy JTF_VARCHAR2_TABLE_100
53: , a19 out nocopy JTF_VARCHAR2_TABLE_100
54: , a20 out nocopy JTF_NUMBER_TABLE
55: , a21 out nocopy JTF_NUMBER_TABLE
56: , a22 out nocopy JTF_DATE_TABLE
49: , a15 out nocopy JTF_VARCHAR2_TABLE_100
50: , a16 out nocopy JTF_VARCHAR2_TABLE_100
51: , a17 out nocopy JTF_NUMBER_TABLE
52: , a18 out nocopy JTF_VARCHAR2_TABLE_100
53: , a19 out nocopy JTF_VARCHAR2_TABLE_100
54: , a20 out nocopy JTF_NUMBER_TABLE
55: , a21 out nocopy JTF_NUMBER_TABLE
56: , a22 out nocopy JTF_DATE_TABLE
57: );
56: , a22 out nocopy JTF_DATE_TABLE
57: );
58:
59: procedure rosetta_table_copy_in_p5(t out nocopy lns_fee_engine.fee_calc_tbl, a0 JTF_NUMBER_TABLE
60: , a1 JTF_VARCHAR2_TABLE_100
61: , a2 JTF_VARCHAR2_TABLE_100
62: , a3 JTF_VARCHAR2_TABLE_100
63: , a4 JTF_NUMBER_TABLE
64: , a5 JTF_NUMBER_TABLE
57: );
58:
59: procedure rosetta_table_copy_in_p5(t out nocopy lns_fee_engine.fee_calc_tbl, a0 JTF_NUMBER_TABLE
60: , a1 JTF_VARCHAR2_TABLE_100
61: , a2 JTF_VARCHAR2_TABLE_100
62: , a3 JTF_VARCHAR2_TABLE_100
63: , a4 JTF_NUMBER_TABLE
64: , a5 JTF_NUMBER_TABLE
65: , a6 JTF_VARCHAR2_TABLE_300
58:
59: procedure rosetta_table_copy_in_p5(t out nocopy lns_fee_engine.fee_calc_tbl, a0 JTF_NUMBER_TABLE
60: , a1 JTF_VARCHAR2_TABLE_100
61: , a2 JTF_VARCHAR2_TABLE_100
62: , a3 JTF_VARCHAR2_TABLE_100
63: , a4 JTF_NUMBER_TABLE
64: , a5 JTF_NUMBER_TABLE
65: , a6 JTF_VARCHAR2_TABLE_300
66: , a7 JTF_NUMBER_TABLE
63: , a4 JTF_NUMBER_TABLE
64: , a5 JTF_NUMBER_TABLE
65: , a6 JTF_VARCHAR2_TABLE_300
66: , a7 JTF_NUMBER_TABLE
67: , a8 JTF_VARCHAR2_TABLE_100
68: , a9 JTF_VARCHAR2_TABLE_100
69: , a10 JTF_VARCHAR2_TABLE_100
70: , a11 JTF_NUMBER_TABLE
71: , a12 JTF_VARCHAR2_TABLE_100
64: , a5 JTF_NUMBER_TABLE
65: , a6 JTF_VARCHAR2_TABLE_300
66: , a7 JTF_NUMBER_TABLE
67: , a8 JTF_VARCHAR2_TABLE_100
68: , a9 JTF_VARCHAR2_TABLE_100
69: , a10 JTF_VARCHAR2_TABLE_100
70: , a11 JTF_NUMBER_TABLE
71: , a12 JTF_VARCHAR2_TABLE_100
72: , a13 JTF_VARCHAR2_TABLE_100
65: , a6 JTF_VARCHAR2_TABLE_300
66: , a7 JTF_NUMBER_TABLE
67: , a8 JTF_VARCHAR2_TABLE_100
68: , a9 JTF_VARCHAR2_TABLE_100
69: , a10 JTF_VARCHAR2_TABLE_100
70: , a11 JTF_NUMBER_TABLE
71: , a12 JTF_VARCHAR2_TABLE_100
72: , a13 JTF_VARCHAR2_TABLE_100
73: , a14 JTF_NUMBER_TABLE
67: , a8 JTF_VARCHAR2_TABLE_100
68: , a9 JTF_VARCHAR2_TABLE_100
69: , a10 JTF_VARCHAR2_TABLE_100
70: , a11 JTF_NUMBER_TABLE
71: , a12 JTF_VARCHAR2_TABLE_100
72: , a13 JTF_VARCHAR2_TABLE_100
73: , a14 JTF_NUMBER_TABLE
74: );
75: procedure rosetta_table_copy_out_p5(t lns_fee_engine.fee_calc_tbl, a0 out nocopy JTF_NUMBER_TABLE
68: , a9 JTF_VARCHAR2_TABLE_100
69: , a10 JTF_VARCHAR2_TABLE_100
70: , a11 JTF_NUMBER_TABLE
71: , a12 JTF_VARCHAR2_TABLE_100
72: , a13 JTF_VARCHAR2_TABLE_100
73: , a14 JTF_NUMBER_TABLE
74: );
75: procedure rosetta_table_copy_out_p5(t lns_fee_engine.fee_calc_tbl, a0 out nocopy JTF_NUMBER_TABLE
76: , a1 out nocopy JTF_VARCHAR2_TABLE_100
72: , a13 JTF_VARCHAR2_TABLE_100
73: , a14 JTF_NUMBER_TABLE
74: );
75: procedure rosetta_table_copy_out_p5(t lns_fee_engine.fee_calc_tbl, a0 out nocopy JTF_NUMBER_TABLE
76: , a1 out nocopy JTF_VARCHAR2_TABLE_100
77: , a2 out nocopy JTF_VARCHAR2_TABLE_100
78: , a3 out nocopy JTF_VARCHAR2_TABLE_100
79: , a4 out nocopy JTF_NUMBER_TABLE
80: , a5 out nocopy JTF_NUMBER_TABLE
73: , a14 JTF_NUMBER_TABLE
74: );
75: procedure rosetta_table_copy_out_p5(t lns_fee_engine.fee_calc_tbl, a0 out nocopy JTF_NUMBER_TABLE
76: , a1 out nocopy JTF_VARCHAR2_TABLE_100
77: , a2 out nocopy JTF_VARCHAR2_TABLE_100
78: , a3 out nocopy JTF_VARCHAR2_TABLE_100
79: , a4 out nocopy JTF_NUMBER_TABLE
80: , a5 out nocopy JTF_NUMBER_TABLE
81: , a6 out nocopy JTF_VARCHAR2_TABLE_300
74: );
75: procedure rosetta_table_copy_out_p5(t lns_fee_engine.fee_calc_tbl, a0 out nocopy JTF_NUMBER_TABLE
76: , a1 out nocopy JTF_VARCHAR2_TABLE_100
77: , a2 out nocopy JTF_VARCHAR2_TABLE_100
78: , a3 out nocopy JTF_VARCHAR2_TABLE_100
79: , a4 out nocopy JTF_NUMBER_TABLE
80: , a5 out nocopy JTF_NUMBER_TABLE
81: , a6 out nocopy JTF_VARCHAR2_TABLE_300
82: , a7 out nocopy JTF_NUMBER_TABLE
79: , a4 out nocopy JTF_NUMBER_TABLE
80: , a5 out nocopy JTF_NUMBER_TABLE
81: , a6 out nocopy JTF_VARCHAR2_TABLE_300
82: , a7 out nocopy JTF_NUMBER_TABLE
83: , a8 out nocopy JTF_VARCHAR2_TABLE_100
84: , a9 out nocopy JTF_VARCHAR2_TABLE_100
85: , a10 out nocopy JTF_VARCHAR2_TABLE_100
86: , a11 out nocopy JTF_NUMBER_TABLE
87: , a12 out nocopy JTF_VARCHAR2_TABLE_100
80: , a5 out nocopy JTF_NUMBER_TABLE
81: , a6 out nocopy JTF_VARCHAR2_TABLE_300
82: , a7 out nocopy JTF_NUMBER_TABLE
83: , a8 out nocopy JTF_VARCHAR2_TABLE_100
84: , a9 out nocopy JTF_VARCHAR2_TABLE_100
85: , a10 out nocopy JTF_VARCHAR2_TABLE_100
86: , a11 out nocopy JTF_NUMBER_TABLE
87: , a12 out nocopy JTF_VARCHAR2_TABLE_100
88: , a13 out nocopy JTF_VARCHAR2_TABLE_100
81: , a6 out nocopy JTF_VARCHAR2_TABLE_300
82: , a7 out nocopy JTF_NUMBER_TABLE
83: , a8 out nocopy JTF_VARCHAR2_TABLE_100
84: , a9 out nocopy JTF_VARCHAR2_TABLE_100
85: , a10 out nocopy JTF_VARCHAR2_TABLE_100
86: , a11 out nocopy JTF_NUMBER_TABLE
87: , a12 out nocopy JTF_VARCHAR2_TABLE_100
88: , a13 out nocopy JTF_VARCHAR2_TABLE_100
89: , a14 out nocopy JTF_NUMBER_TABLE
83: , a8 out nocopy JTF_VARCHAR2_TABLE_100
84: , a9 out nocopy JTF_VARCHAR2_TABLE_100
85: , a10 out nocopy JTF_VARCHAR2_TABLE_100
86: , a11 out nocopy JTF_NUMBER_TABLE
87: , a12 out nocopy JTF_VARCHAR2_TABLE_100
88: , a13 out nocopy JTF_VARCHAR2_TABLE_100
89: , a14 out nocopy JTF_NUMBER_TABLE
90: );
91:
84: , a9 out nocopy JTF_VARCHAR2_TABLE_100
85: , a10 out nocopy JTF_VARCHAR2_TABLE_100
86: , a11 out nocopy JTF_NUMBER_TABLE
87: , a12 out nocopy JTF_VARCHAR2_TABLE_100
88: , a13 out nocopy JTF_VARCHAR2_TABLE_100
89: , a14 out nocopy JTF_NUMBER_TABLE
90: );
91:
92: procedure calculatefees(p_loan_id NUMBER
89: , a14 out nocopy JTF_NUMBER_TABLE
90: );
91:
92: procedure calculatefees(p_loan_id NUMBER
93: , p1_a0 JTF_VARCHAR2_TABLE_100
94: , p1_a1 JTF_NUMBER_TABLE
95: , p_installment NUMBER
96: , p3_a0 JTF_NUMBER_TABLE
97: , p3_a1 JTF_VARCHAR2_TABLE_100
93: , p1_a0 JTF_VARCHAR2_TABLE_100
94: , p1_a1 JTF_NUMBER_TABLE
95: , p_installment NUMBER
96: , p3_a0 JTF_NUMBER_TABLE
97: , p3_a1 JTF_VARCHAR2_TABLE_100
98: , p3_a2 JTF_VARCHAR2_TABLE_300
99: , p3_a3 JTF_VARCHAR2_TABLE_100
100: , p3_a4 JTF_VARCHAR2_TABLE_100
101: , p3_a5 JTF_NUMBER_TABLE
95: , p_installment NUMBER
96: , p3_a0 JTF_NUMBER_TABLE
97: , p3_a1 JTF_VARCHAR2_TABLE_100
98: , p3_a2 JTF_VARCHAR2_TABLE_300
99: , p3_a3 JTF_VARCHAR2_TABLE_100
100: , p3_a4 JTF_VARCHAR2_TABLE_100
101: , p3_a5 JTF_NUMBER_TABLE
102: , p3_a6 JTF_VARCHAR2_TABLE_100
103: , p3_a7 JTF_DATE_TABLE
96: , p3_a0 JTF_NUMBER_TABLE
97: , p3_a1 JTF_VARCHAR2_TABLE_100
98: , p3_a2 JTF_VARCHAR2_TABLE_300
99: , p3_a3 JTF_VARCHAR2_TABLE_100
100: , p3_a4 JTF_VARCHAR2_TABLE_100
101: , p3_a5 JTF_NUMBER_TABLE
102: , p3_a6 JTF_VARCHAR2_TABLE_100
103: , p3_a7 JTF_DATE_TABLE
104: , p3_a8 JTF_DATE_TABLE
98: , p3_a2 JTF_VARCHAR2_TABLE_300
99: , p3_a3 JTF_VARCHAR2_TABLE_100
100: , p3_a4 JTF_VARCHAR2_TABLE_100
101: , p3_a5 JTF_NUMBER_TABLE
102: , p3_a6 JTF_VARCHAR2_TABLE_100
103: , p3_a7 JTF_DATE_TABLE
104: , p3_a8 JTF_DATE_TABLE
105: , p3_a9 JTF_NUMBER_TABLE
106: , p3_a10 JTF_VARCHAR2_TABLE_100
102: , p3_a6 JTF_VARCHAR2_TABLE_100
103: , p3_a7 JTF_DATE_TABLE
104: , p3_a8 JTF_DATE_TABLE
105: , p3_a9 JTF_NUMBER_TABLE
106: , p3_a10 JTF_VARCHAR2_TABLE_100
107: , p3_a11 JTF_VARCHAR2_TABLE_100
108: , p3_a12 JTF_NUMBER_TABLE
109: , p3_a13 JTF_NUMBER_TABLE
110: , p3_a14 JTF_VARCHAR2_TABLE_100
103: , p3_a7 JTF_DATE_TABLE
104: , p3_a8 JTF_DATE_TABLE
105: , p3_a9 JTF_NUMBER_TABLE
106: , p3_a10 JTF_VARCHAR2_TABLE_100
107: , p3_a11 JTF_VARCHAR2_TABLE_100
108: , p3_a12 JTF_NUMBER_TABLE
109: , p3_a13 JTF_NUMBER_TABLE
110: , p3_a14 JTF_VARCHAR2_TABLE_100
111: , p3_a15 JTF_VARCHAR2_TABLE_100
106: , p3_a10 JTF_VARCHAR2_TABLE_100
107: , p3_a11 JTF_VARCHAR2_TABLE_100
108: , p3_a12 JTF_NUMBER_TABLE
109: , p3_a13 JTF_NUMBER_TABLE
110: , p3_a14 JTF_VARCHAR2_TABLE_100
111: , p3_a15 JTF_VARCHAR2_TABLE_100
112: , p3_a16 JTF_VARCHAR2_TABLE_100
113: , p3_a17 JTF_NUMBER_TABLE
114: , p3_a18 JTF_VARCHAR2_TABLE_100
107: , p3_a11 JTF_VARCHAR2_TABLE_100
108: , p3_a12 JTF_NUMBER_TABLE
109: , p3_a13 JTF_NUMBER_TABLE
110: , p3_a14 JTF_VARCHAR2_TABLE_100
111: , p3_a15 JTF_VARCHAR2_TABLE_100
112: , p3_a16 JTF_VARCHAR2_TABLE_100
113: , p3_a17 JTF_NUMBER_TABLE
114: , p3_a18 JTF_VARCHAR2_TABLE_100
115: , p3_a19 JTF_VARCHAR2_TABLE_100
108: , p3_a12 JTF_NUMBER_TABLE
109: , p3_a13 JTF_NUMBER_TABLE
110: , p3_a14 JTF_VARCHAR2_TABLE_100
111: , p3_a15 JTF_VARCHAR2_TABLE_100
112: , p3_a16 JTF_VARCHAR2_TABLE_100
113: , p3_a17 JTF_NUMBER_TABLE
114: , p3_a18 JTF_VARCHAR2_TABLE_100
115: , p3_a19 JTF_VARCHAR2_TABLE_100
116: , p3_a20 JTF_NUMBER_TABLE
110: , p3_a14 JTF_VARCHAR2_TABLE_100
111: , p3_a15 JTF_VARCHAR2_TABLE_100
112: , p3_a16 JTF_VARCHAR2_TABLE_100
113: , p3_a17 JTF_NUMBER_TABLE
114: , p3_a18 JTF_VARCHAR2_TABLE_100
115: , p3_a19 JTF_VARCHAR2_TABLE_100
116: , p3_a20 JTF_NUMBER_TABLE
117: , p3_a21 JTF_NUMBER_TABLE
118: , p3_a22 JTF_DATE_TABLE
111: , p3_a15 JTF_VARCHAR2_TABLE_100
112: , p3_a16 JTF_VARCHAR2_TABLE_100
113: , p3_a17 JTF_NUMBER_TABLE
114: , p3_a18 JTF_VARCHAR2_TABLE_100
115: , p3_a19 JTF_VARCHAR2_TABLE_100
116: , p3_a20 JTF_NUMBER_TABLE
117: , p3_a21 JTF_NUMBER_TABLE
118: , p3_a22 JTF_DATE_TABLE
119: , p4_a0 out nocopy JTF_NUMBER_TABLE
116: , p3_a20 JTF_NUMBER_TABLE
117: , p3_a21 JTF_NUMBER_TABLE
118: , p3_a22 JTF_DATE_TABLE
119: , p4_a0 out nocopy JTF_NUMBER_TABLE
120: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
121: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
122: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
123: , p4_a4 out nocopy JTF_NUMBER_TABLE
124: , p4_a5 out nocopy JTF_NUMBER_TABLE
117: , p3_a21 JTF_NUMBER_TABLE
118: , p3_a22 JTF_DATE_TABLE
119: , p4_a0 out nocopy JTF_NUMBER_TABLE
120: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
121: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
122: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
123: , p4_a4 out nocopy JTF_NUMBER_TABLE
124: , p4_a5 out nocopy JTF_NUMBER_TABLE
125: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_300
118: , p3_a22 JTF_DATE_TABLE
119: , p4_a0 out nocopy JTF_NUMBER_TABLE
120: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
121: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
122: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
123: , p4_a4 out nocopy JTF_NUMBER_TABLE
124: , p4_a5 out nocopy JTF_NUMBER_TABLE
125: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_300
126: , p4_a7 out nocopy JTF_NUMBER_TABLE
123: , p4_a4 out nocopy JTF_NUMBER_TABLE
124: , p4_a5 out nocopy JTF_NUMBER_TABLE
125: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_300
126: , p4_a7 out nocopy JTF_NUMBER_TABLE
127: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
128: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
129: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
130: , p4_a11 out nocopy JTF_NUMBER_TABLE
131: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
124: , p4_a5 out nocopy JTF_NUMBER_TABLE
125: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_300
126: , p4_a7 out nocopy JTF_NUMBER_TABLE
127: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
128: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
129: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
130: , p4_a11 out nocopy JTF_NUMBER_TABLE
131: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
132: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_100
125: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_300
126: , p4_a7 out nocopy JTF_NUMBER_TABLE
127: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
128: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
129: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
130: , p4_a11 out nocopy JTF_NUMBER_TABLE
131: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
132: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_100
133: , p4_a14 out nocopy JTF_NUMBER_TABLE
127: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
128: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
129: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
130: , p4_a11 out nocopy JTF_NUMBER_TABLE
131: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
132: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_100
133: , p4_a14 out nocopy JTF_NUMBER_TABLE
134: , x_return_status out nocopy VARCHAR2
135: , x_msg_count out nocopy NUMBER
128: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
129: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
130: , p4_a11 out nocopy JTF_NUMBER_TABLE
131: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
132: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_100
133: , p4_a14 out nocopy JTF_NUMBER_TABLE
134: , x_return_status out nocopy VARCHAR2
135: , x_msg_count out nocopy NUMBER
136: , x_msg_data out nocopy VARCHAR2
138: procedure writefeeschedule(p_init_msg_list VARCHAR2
139: , p_commit VARCHAR2
140: , p_loan_id NUMBER
141: , p3_a0 in out nocopy JTF_NUMBER_TABLE
142: , p3_a1 in out nocopy JTF_VARCHAR2_TABLE_100
143: , p3_a2 in out nocopy JTF_VARCHAR2_TABLE_100
144: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
145: , p3_a4 in out nocopy JTF_NUMBER_TABLE
146: , p3_a5 in out nocopy JTF_NUMBER_TABLE
139: , p_commit VARCHAR2
140: , p_loan_id NUMBER
141: , p3_a0 in out nocopy JTF_NUMBER_TABLE
142: , p3_a1 in out nocopy JTF_VARCHAR2_TABLE_100
143: , p3_a2 in out nocopy JTF_VARCHAR2_TABLE_100
144: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
145: , p3_a4 in out nocopy JTF_NUMBER_TABLE
146: , p3_a5 in out nocopy JTF_NUMBER_TABLE
147: , p3_a6 in out nocopy JTF_VARCHAR2_TABLE_300
140: , p_loan_id NUMBER
141: , p3_a0 in out nocopy JTF_NUMBER_TABLE
142: , p3_a1 in out nocopy JTF_VARCHAR2_TABLE_100
143: , p3_a2 in out nocopy JTF_VARCHAR2_TABLE_100
144: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
145: , p3_a4 in out nocopy JTF_NUMBER_TABLE
146: , p3_a5 in out nocopy JTF_NUMBER_TABLE
147: , p3_a6 in out nocopy JTF_VARCHAR2_TABLE_300
148: , p3_a7 in out nocopy JTF_NUMBER_TABLE
145: , p3_a4 in out nocopy JTF_NUMBER_TABLE
146: , p3_a5 in out nocopy JTF_NUMBER_TABLE
147: , p3_a6 in out nocopy JTF_VARCHAR2_TABLE_300
148: , p3_a7 in out nocopy JTF_NUMBER_TABLE
149: , p3_a8 in out nocopy JTF_VARCHAR2_TABLE_100
150: , p3_a9 in out nocopy JTF_VARCHAR2_TABLE_100
151: , p3_a10 in out nocopy JTF_VARCHAR2_TABLE_100
152: , p3_a11 in out nocopy JTF_NUMBER_TABLE
153: , p3_a12 in out nocopy JTF_VARCHAR2_TABLE_100
146: , p3_a5 in out nocopy JTF_NUMBER_TABLE
147: , p3_a6 in out nocopy JTF_VARCHAR2_TABLE_300
148: , p3_a7 in out nocopy JTF_NUMBER_TABLE
149: , p3_a8 in out nocopy JTF_VARCHAR2_TABLE_100
150: , p3_a9 in out nocopy JTF_VARCHAR2_TABLE_100
151: , p3_a10 in out nocopy JTF_VARCHAR2_TABLE_100
152: , p3_a11 in out nocopy JTF_NUMBER_TABLE
153: , p3_a12 in out nocopy JTF_VARCHAR2_TABLE_100
154: , p3_a13 in out nocopy JTF_VARCHAR2_TABLE_100
147: , p3_a6 in out nocopy JTF_VARCHAR2_TABLE_300
148: , p3_a7 in out nocopy JTF_NUMBER_TABLE
149: , p3_a8 in out nocopy JTF_VARCHAR2_TABLE_100
150: , p3_a9 in out nocopy JTF_VARCHAR2_TABLE_100
151: , p3_a10 in out nocopy JTF_VARCHAR2_TABLE_100
152: , p3_a11 in out nocopy JTF_NUMBER_TABLE
153: , p3_a12 in out nocopy JTF_VARCHAR2_TABLE_100
154: , p3_a13 in out nocopy JTF_VARCHAR2_TABLE_100
155: , p3_a14 in out nocopy JTF_NUMBER_TABLE
149: , p3_a8 in out nocopy JTF_VARCHAR2_TABLE_100
150: , p3_a9 in out nocopy JTF_VARCHAR2_TABLE_100
151: , p3_a10 in out nocopy JTF_VARCHAR2_TABLE_100
152: , p3_a11 in out nocopy JTF_NUMBER_TABLE
153: , p3_a12 in out nocopy JTF_VARCHAR2_TABLE_100
154: , p3_a13 in out nocopy JTF_VARCHAR2_TABLE_100
155: , p3_a14 in out nocopy JTF_NUMBER_TABLE
156: , x_return_status out nocopy VARCHAR2
157: , x_msg_count out nocopy NUMBER
150: , p3_a9 in out nocopy JTF_VARCHAR2_TABLE_100
151: , p3_a10 in out nocopy JTF_VARCHAR2_TABLE_100
152: , p3_a11 in out nocopy JTF_NUMBER_TABLE
153: , p3_a12 in out nocopy JTF_VARCHAR2_TABLE_100
154: , p3_a13 in out nocopy JTF_VARCHAR2_TABLE_100
155: , p3_a14 in out nocopy JTF_NUMBER_TABLE
156: , x_return_status out nocopy VARCHAR2
157: , x_msg_count out nocopy NUMBER
158: , x_msg_data out nocopy VARCHAR2
160: procedure updatefeeschedule(p_init_msg_list VARCHAR2
161: , p_commit VARCHAR2
162: , p_loan_id NUMBER
163: , p3_a0 JTF_NUMBER_TABLE
164: , p3_a1 JTF_VARCHAR2_TABLE_100
165: , p3_a2 JTF_VARCHAR2_TABLE_100
166: , p3_a3 JTF_VARCHAR2_TABLE_100
167: , p3_a4 JTF_NUMBER_TABLE
168: , p3_a5 JTF_NUMBER_TABLE
161: , p_commit VARCHAR2
162: , p_loan_id NUMBER
163: , p3_a0 JTF_NUMBER_TABLE
164: , p3_a1 JTF_VARCHAR2_TABLE_100
165: , p3_a2 JTF_VARCHAR2_TABLE_100
166: , p3_a3 JTF_VARCHAR2_TABLE_100
167: , p3_a4 JTF_NUMBER_TABLE
168: , p3_a5 JTF_NUMBER_TABLE
169: , p3_a6 JTF_VARCHAR2_TABLE_300
162: , p_loan_id NUMBER
163: , p3_a0 JTF_NUMBER_TABLE
164: , p3_a1 JTF_VARCHAR2_TABLE_100
165: , p3_a2 JTF_VARCHAR2_TABLE_100
166: , p3_a3 JTF_VARCHAR2_TABLE_100
167: , p3_a4 JTF_NUMBER_TABLE
168: , p3_a5 JTF_NUMBER_TABLE
169: , p3_a6 JTF_VARCHAR2_TABLE_300
170: , p3_a7 JTF_NUMBER_TABLE
167: , p3_a4 JTF_NUMBER_TABLE
168: , p3_a5 JTF_NUMBER_TABLE
169: , p3_a6 JTF_VARCHAR2_TABLE_300
170: , p3_a7 JTF_NUMBER_TABLE
171: , p3_a8 JTF_VARCHAR2_TABLE_100
172: , p3_a9 JTF_VARCHAR2_TABLE_100
173: , p3_a10 JTF_VARCHAR2_TABLE_100
174: , p3_a11 JTF_NUMBER_TABLE
175: , p3_a12 JTF_VARCHAR2_TABLE_100
168: , p3_a5 JTF_NUMBER_TABLE
169: , p3_a6 JTF_VARCHAR2_TABLE_300
170: , p3_a7 JTF_NUMBER_TABLE
171: , p3_a8 JTF_VARCHAR2_TABLE_100
172: , p3_a9 JTF_VARCHAR2_TABLE_100
173: , p3_a10 JTF_VARCHAR2_TABLE_100
174: , p3_a11 JTF_NUMBER_TABLE
175: , p3_a12 JTF_VARCHAR2_TABLE_100
176: , p3_a13 JTF_VARCHAR2_TABLE_100
169: , p3_a6 JTF_VARCHAR2_TABLE_300
170: , p3_a7 JTF_NUMBER_TABLE
171: , p3_a8 JTF_VARCHAR2_TABLE_100
172: , p3_a9 JTF_VARCHAR2_TABLE_100
173: , p3_a10 JTF_VARCHAR2_TABLE_100
174: , p3_a11 JTF_NUMBER_TABLE
175: , p3_a12 JTF_VARCHAR2_TABLE_100
176: , p3_a13 JTF_VARCHAR2_TABLE_100
177: , p3_a14 JTF_NUMBER_TABLE
171: , p3_a8 JTF_VARCHAR2_TABLE_100
172: , p3_a9 JTF_VARCHAR2_TABLE_100
173: , p3_a10 JTF_VARCHAR2_TABLE_100
174: , p3_a11 JTF_NUMBER_TABLE
175: , p3_a12 JTF_VARCHAR2_TABLE_100
176: , p3_a13 JTF_VARCHAR2_TABLE_100
177: , p3_a14 JTF_NUMBER_TABLE
178: , x_return_status out nocopy VARCHAR2
179: , x_msg_count out nocopy NUMBER
172: , p3_a9 JTF_VARCHAR2_TABLE_100
173: , p3_a10 JTF_VARCHAR2_TABLE_100
174: , p3_a11 JTF_NUMBER_TABLE
175: , p3_a12 JTF_VARCHAR2_TABLE_100
176: , p3_a13 JTF_VARCHAR2_TABLE_100
177: , p3_a14 JTF_NUMBER_TABLE
178: , x_return_status out nocopy VARCHAR2
179: , x_msg_count out nocopy NUMBER
180: , x_msg_data out nocopy VARCHAR2
183: , p_loan_id NUMBER
184: , p_installment_number NUMBER
185: , p_disb_header_id NUMBER
186: , p4_a0 out nocopy JTF_NUMBER_TABLE
187: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
188: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
189: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
190: , p4_a4 out nocopy JTF_NUMBER_TABLE
191: , p4_a5 out nocopy JTF_NUMBER_TABLE
184: , p_installment_number NUMBER
185: , p_disb_header_id NUMBER
186: , p4_a0 out nocopy JTF_NUMBER_TABLE
187: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
188: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
189: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
190: , p4_a4 out nocopy JTF_NUMBER_TABLE
191: , p4_a5 out nocopy JTF_NUMBER_TABLE
192: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_300
185: , p_disb_header_id NUMBER
186: , p4_a0 out nocopy JTF_NUMBER_TABLE
187: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
188: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
189: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
190: , p4_a4 out nocopy JTF_NUMBER_TABLE
191: , p4_a5 out nocopy JTF_NUMBER_TABLE
192: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_300
193: , p4_a7 out nocopy JTF_NUMBER_TABLE
190: , p4_a4 out nocopy JTF_NUMBER_TABLE
191: , p4_a5 out nocopy JTF_NUMBER_TABLE
192: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_300
193: , p4_a7 out nocopy JTF_NUMBER_TABLE
194: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
195: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
196: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
197: , p4_a11 out nocopy JTF_NUMBER_TABLE
198: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
191: , p4_a5 out nocopy JTF_NUMBER_TABLE
192: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_300
193: , p4_a7 out nocopy JTF_NUMBER_TABLE
194: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
195: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
196: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
197: , p4_a11 out nocopy JTF_NUMBER_TABLE
198: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
199: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_100
192: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_300
193: , p4_a7 out nocopy JTF_NUMBER_TABLE
194: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
195: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
196: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
197: , p4_a11 out nocopy JTF_NUMBER_TABLE
198: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
199: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_100
200: , p4_a14 out nocopy JTF_NUMBER_TABLE
194: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
195: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
196: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
197: , p4_a11 out nocopy JTF_NUMBER_TABLE
198: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
199: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_100
200: , p4_a14 out nocopy JTF_NUMBER_TABLE
201: , x_return_status out nocopy VARCHAR2
202: , x_msg_count out nocopy NUMBER
195: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
196: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
197: , p4_a11 out nocopy JTF_NUMBER_TABLE
198: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
199: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_100
200: , p4_a14 out nocopy JTF_NUMBER_TABLE
201: , x_return_status out nocopy VARCHAR2
202: , x_msg_count out nocopy NUMBER
203: , x_msg_data out nocopy VARCHAR2
204: );
205: procedure getfeedetails(p_init_msg_list VARCHAR2
206: , p_loan_id NUMBER
207: , p_installment NUMBER
208: , p3_a0 JTF_VARCHAR2_TABLE_100
209: , p3_a1 JTF_NUMBER_TABLE
210: , p_based_on_terms VARCHAR2
211: , p_phase VARCHAR2
212: , p6_a0 out nocopy JTF_NUMBER_TABLE
209: , p3_a1 JTF_NUMBER_TABLE
210: , p_based_on_terms VARCHAR2
211: , p_phase VARCHAR2
212: , p6_a0 out nocopy JTF_NUMBER_TABLE
213: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
214: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
215: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
216: , p6_a4 out nocopy JTF_NUMBER_TABLE
217: , p6_a5 out nocopy JTF_NUMBER_TABLE
210: , p_based_on_terms VARCHAR2
211: , p_phase VARCHAR2
212: , p6_a0 out nocopy JTF_NUMBER_TABLE
213: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
214: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
215: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
216: , p6_a4 out nocopy JTF_NUMBER_TABLE
217: , p6_a5 out nocopy JTF_NUMBER_TABLE
218: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
211: , p_phase VARCHAR2
212: , p6_a0 out nocopy JTF_NUMBER_TABLE
213: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
214: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
215: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
216: , p6_a4 out nocopy JTF_NUMBER_TABLE
217: , p6_a5 out nocopy JTF_NUMBER_TABLE
218: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
219: , p6_a7 out nocopy JTF_NUMBER_TABLE
216: , p6_a4 out nocopy JTF_NUMBER_TABLE
217: , p6_a5 out nocopy JTF_NUMBER_TABLE
218: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
219: , p6_a7 out nocopy JTF_NUMBER_TABLE
220: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
221: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
222: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
223: , p6_a11 out nocopy JTF_NUMBER_TABLE
224: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
217: , p6_a5 out nocopy JTF_NUMBER_TABLE
218: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
219: , p6_a7 out nocopy JTF_NUMBER_TABLE
220: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
221: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
222: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
223: , p6_a11 out nocopy JTF_NUMBER_TABLE
224: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
225: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
218: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
219: , p6_a7 out nocopy JTF_NUMBER_TABLE
220: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
221: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
222: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
223: , p6_a11 out nocopy JTF_NUMBER_TABLE
224: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
225: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
226: , p6_a14 out nocopy JTF_NUMBER_TABLE
220: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
221: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
222: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
223: , p6_a11 out nocopy JTF_NUMBER_TABLE
224: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
225: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
226: , p6_a14 out nocopy JTF_NUMBER_TABLE
227: , x_return_status out nocopy VARCHAR2
228: , x_msg_count out nocopy NUMBER
221: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
222: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
223: , p6_a11 out nocopy JTF_NUMBER_TABLE
224: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
225: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
226: , p6_a14 out nocopy JTF_NUMBER_TABLE
227: , x_return_status out nocopy VARCHAR2
228: , x_msg_count out nocopy NUMBER
229: , x_msg_data out nocopy VARCHAR2
231: procedure processfees(p_init_msg_list VARCHAR2
232: , p_commit VARCHAR2
233: , p_loan_id NUMBER
234: , p_installment_number NUMBER
235: , p4_a0 JTF_VARCHAR2_TABLE_100
236: , p4_a1 JTF_NUMBER_TABLE
237: , p5_a0 JTF_NUMBER_TABLE
238: , p5_a1 JTF_VARCHAR2_TABLE_100
239: , p5_a2 JTF_VARCHAR2_TABLE_300
234: , p_installment_number NUMBER
235: , p4_a0 JTF_VARCHAR2_TABLE_100
236: , p4_a1 JTF_NUMBER_TABLE
237: , p5_a0 JTF_NUMBER_TABLE
238: , p5_a1 JTF_VARCHAR2_TABLE_100
239: , p5_a2 JTF_VARCHAR2_TABLE_300
240: , p5_a3 JTF_VARCHAR2_TABLE_100
241: , p5_a4 JTF_VARCHAR2_TABLE_100
242: , p5_a5 JTF_NUMBER_TABLE
236: , p4_a1 JTF_NUMBER_TABLE
237: , p5_a0 JTF_NUMBER_TABLE
238: , p5_a1 JTF_VARCHAR2_TABLE_100
239: , p5_a2 JTF_VARCHAR2_TABLE_300
240: , p5_a3 JTF_VARCHAR2_TABLE_100
241: , p5_a4 JTF_VARCHAR2_TABLE_100
242: , p5_a5 JTF_NUMBER_TABLE
243: , p5_a6 JTF_VARCHAR2_TABLE_100
244: , p5_a7 JTF_DATE_TABLE
237: , p5_a0 JTF_NUMBER_TABLE
238: , p5_a1 JTF_VARCHAR2_TABLE_100
239: , p5_a2 JTF_VARCHAR2_TABLE_300
240: , p5_a3 JTF_VARCHAR2_TABLE_100
241: , p5_a4 JTF_VARCHAR2_TABLE_100
242: , p5_a5 JTF_NUMBER_TABLE
243: , p5_a6 JTF_VARCHAR2_TABLE_100
244: , p5_a7 JTF_DATE_TABLE
245: , p5_a8 JTF_DATE_TABLE
239: , p5_a2 JTF_VARCHAR2_TABLE_300
240: , p5_a3 JTF_VARCHAR2_TABLE_100
241: , p5_a4 JTF_VARCHAR2_TABLE_100
242: , p5_a5 JTF_NUMBER_TABLE
243: , p5_a6 JTF_VARCHAR2_TABLE_100
244: , p5_a7 JTF_DATE_TABLE
245: , p5_a8 JTF_DATE_TABLE
246: , p5_a9 JTF_NUMBER_TABLE
247: , p5_a10 JTF_VARCHAR2_TABLE_100
243: , p5_a6 JTF_VARCHAR2_TABLE_100
244: , p5_a7 JTF_DATE_TABLE
245: , p5_a8 JTF_DATE_TABLE
246: , p5_a9 JTF_NUMBER_TABLE
247: , p5_a10 JTF_VARCHAR2_TABLE_100
248: , p5_a11 JTF_VARCHAR2_TABLE_100
249: , p5_a12 JTF_NUMBER_TABLE
250: , p5_a13 JTF_NUMBER_TABLE
251: , p5_a14 JTF_VARCHAR2_TABLE_100
244: , p5_a7 JTF_DATE_TABLE
245: , p5_a8 JTF_DATE_TABLE
246: , p5_a9 JTF_NUMBER_TABLE
247: , p5_a10 JTF_VARCHAR2_TABLE_100
248: , p5_a11 JTF_VARCHAR2_TABLE_100
249: , p5_a12 JTF_NUMBER_TABLE
250: , p5_a13 JTF_NUMBER_TABLE
251: , p5_a14 JTF_VARCHAR2_TABLE_100
252: , p5_a15 JTF_VARCHAR2_TABLE_100
247: , p5_a10 JTF_VARCHAR2_TABLE_100
248: , p5_a11 JTF_VARCHAR2_TABLE_100
249: , p5_a12 JTF_NUMBER_TABLE
250: , p5_a13 JTF_NUMBER_TABLE
251: , p5_a14 JTF_VARCHAR2_TABLE_100
252: , p5_a15 JTF_VARCHAR2_TABLE_100
253: , p5_a16 JTF_VARCHAR2_TABLE_100
254: , p5_a17 JTF_NUMBER_TABLE
255: , p5_a18 JTF_VARCHAR2_TABLE_100
248: , p5_a11 JTF_VARCHAR2_TABLE_100
249: , p5_a12 JTF_NUMBER_TABLE
250: , p5_a13 JTF_NUMBER_TABLE
251: , p5_a14 JTF_VARCHAR2_TABLE_100
252: , p5_a15 JTF_VARCHAR2_TABLE_100
253: , p5_a16 JTF_VARCHAR2_TABLE_100
254: , p5_a17 JTF_NUMBER_TABLE
255: , p5_a18 JTF_VARCHAR2_TABLE_100
256: , p5_a19 JTF_VARCHAR2_TABLE_100
249: , p5_a12 JTF_NUMBER_TABLE
250: , p5_a13 JTF_NUMBER_TABLE
251: , p5_a14 JTF_VARCHAR2_TABLE_100
252: , p5_a15 JTF_VARCHAR2_TABLE_100
253: , p5_a16 JTF_VARCHAR2_TABLE_100
254: , p5_a17 JTF_NUMBER_TABLE
255: , p5_a18 JTF_VARCHAR2_TABLE_100
256: , p5_a19 JTF_VARCHAR2_TABLE_100
257: , p5_a20 JTF_NUMBER_TABLE
251: , p5_a14 JTF_VARCHAR2_TABLE_100
252: , p5_a15 JTF_VARCHAR2_TABLE_100
253: , p5_a16 JTF_VARCHAR2_TABLE_100
254: , p5_a17 JTF_NUMBER_TABLE
255: , p5_a18 JTF_VARCHAR2_TABLE_100
256: , p5_a19 JTF_VARCHAR2_TABLE_100
257: , p5_a20 JTF_NUMBER_TABLE
258: , p5_a21 JTF_NUMBER_TABLE
259: , p5_a22 JTF_DATE_TABLE
252: , p5_a15 JTF_VARCHAR2_TABLE_100
253: , p5_a16 JTF_VARCHAR2_TABLE_100
254: , p5_a17 JTF_NUMBER_TABLE
255: , p5_a18 JTF_VARCHAR2_TABLE_100
256: , p5_a19 JTF_VARCHAR2_TABLE_100
257: , p5_a20 JTF_NUMBER_TABLE
258: , p5_a21 JTF_NUMBER_TABLE
259: , p5_a22 JTF_DATE_TABLE
260: , p6_a0 out nocopy JTF_NUMBER_TABLE
257: , p5_a20 JTF_NUMBER_TABLE
258: , p5_a21 JTF_NUMBER_TABLE
259: , p5_a22 JTF_DATE_TABLE
260: , p6_a0 out nocopy JTF_NUMBER_TABLE
261: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
262: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
263: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
264: , p6_a4 out nocopy JTF_NUMBER_TABLE
265: , p6_a5 out nocopy JTF_NUMBER_TABLE
258: , p5_a21 JTF_NUMBER_TABLE
259: , p5_a22 JTF_DATE_TABLE
260: , p6_a0 out nocopy JTF_NUMBER_TABLE
261: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
262: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
263: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
264: , p6_a4 out nocopy JTF_NUMBER_TABLE
265: , p6_a5 out nocopy JTF_NUMBER_TABLE
266: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
259: , p5_a22 JTF_DATE_TABLE
260: , p6_a0 out nocopy JTF_NUMBER_TABLE
261: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
262: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
263: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
264: , p6_a4 out nocopy JTF_NUMBER_TABLE
265: , p6_a5 out nocopy JTF_NUMBER_TABLE
266: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
267: , p6_a7 out nocopy JTF_NUMBER_TABLE
264: , p6_a4 out nocopy JTF_NUMBER_TABLE
265: , p6_a5 out nocopy JTF_NUMBER_TABLE
266: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
267: , p6_a7 out nocopy JTF_NUMBER_TABLE
268: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
269: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
270: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
271: , p6_a11 out nocopy JTF_NUMBER_TABLE
272: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
265: , p6_a5 out nocopy JTF_NUMBER_TABLE
266: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
267: , p6_a7 out nocopy JTF_NUMBER_TABLE
268: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
269: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
270: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
271: , p6_a11 out nocopy JTF_NUMBER_TABLE
272: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
273: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
266: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
267: , p6_a7 out nocopy JTF_NUMBER_TABLE
268: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
269: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
270: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
271: , p6_a11 out nocopy JTF_NUMBER_TABLE
272: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
273: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
274: , p6_a14 out nocopy JTF_NUMBER_TABLE
268: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
269: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
270: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
271: , p6_a11 out nocopy JTF_NUMBER_TABLE
272: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
273: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
274: , p6_a14 out nocopy JTF_NUMBER_TABLE
275: , x_return_status out nocopy VARCHAR2
276: , x_msg_count out nocopy NUMBER
269: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
270: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
271: , p6_a11 out nocopy JTF_NUMBER_TABLE
272: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
273: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
274: , p6_a14 out nocopy JTF_NUMBER_TABLE
275: , x_return_status out nocopy VARCHAR2
276: , x_msg_count out nocopy NUMBER
277: , x_msg_data out nocopy VARCHAR2