APPS.LNS_FEE_ENGINE_W dependencies on JTF_NUMBER_TABLE

Line 4: , a1 JTF_NUMBER_TABLE

1: package lns_fee_engine_w AUTHID CURRENT_USER as
2: /* $Header: LNS_FEE_ENGINJ_S.pls 120.3.12010000.4 2010/02/24 01:45:04 mbolli ship $ */
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: );

Line 7: , a1 out nocopy JTF_NUMBER_TABLE

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
11: , a1 JTF_VARCHAR2_TABLE_100

Line 10: procedure rosetta_table_copy_in_p3(t out nocopy lns_fee_engine.fee_structure_tbl, a0 JTF_NUMBER_TABLE

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
11: , a1 JTF_VARCHAR2_TABLE_100
12: , a2 JTF_VARCHAR2_TABLE_300
13: , a3 JTF_VARCHAR2_TABLE_100
14: , a4 JTF_VARCHAR2_TABLE_100

Line 15: , a5 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
19: , a9 JTF_NUMBER_TABLE

Line 19: , a9 JTF_NUMBER_TABLE

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
21: , a11 JTF_VARCHAR2_TABLE_100
22: , a12 JTF_NUMBER_TABLE
23: , a13 JTF_NUMBER_TABLE

Line 22: , a12 JTF_NUMBER_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
26: , a16 JTF_VARCHAR2_TABLE_100

Line 23: , a13 JTF_NUMBER_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
26: , a16 JTF_VARCHAR2_TABLE_100
27: , a17 JTF_NUMBER_TABLE

Line 27: , a17 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
31: , a21 JTF_NUMBER_TABLE

Line 30: , a20 JTF_NUMBER_TABLE

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: , a23 JTF_VARCHAR2_TABLE_100
34: );

Line 31: , a21 JTF_NUMBER_TABLE

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: , a23 JTF_VARCHAR2_TABLE_100
34: );
35: procedure rosetta_table_copy_out_p3(t lns_fee_engine.fee_structure_tbl, a0 out nocopy JTF_NUMBER_TABLE

Line 35: procedure rosetta_table_copy_out_p3(t lns_fee_engine.fee_structure_tbl, a0 out nocopy JTF_NUMBER_TABLE

31: , a21 JTF_NUMBER_TABLE
32: , a22 JTF_DATE_TABLE
33: , a23 JTF_VARCHAR2_TABLE_100
34: );
35: procedure rosetta_table_copy_out_p3(t lns_fee_engine.fee_structure_tbl, a0 out nocopy JTF_NUMBER_TABLE
36: , a1 out nocopy JTF_VARCHAR2_TABLE_100
37: , a2 out nocopy JTF_VARCHAR2_TABLE_300
38: , a3 out nocopy JTF_VARCHAR2_TABLE_100
39: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 40: , a5 out nocopy JTF_NUMBER_TABLE

36: , a1 out nocopy JTF_VARCHAR2_TABLE_100
37: , a2 out nocopy JTF_VARCHAR2_TABLE_300
38: , a3 out nocopy JTF_VARCHAR2_TABLE_100
39: , a4 out nocopy JTF_VARCHAR2_TABLE_100
40: , a5 out nocopy JTF_NUMBER_TABLE
41: , a6 out nocopy JTF_VARCHAR2_TABLE_100
42: , a7 out nocopy JTF_DATE_TABLE
43: , a8 out nocopy JTF_DATE_TABLE
44: , a9 out nocopy JTF_NUMBER_TABLE

Line 44: , a9 out nocopy JTF_NUMBER_TABLE

40: , a5 out nocopy JTF_NUMBER_TABLE
41: , a6 out nocopy JTF_VARCHAR2_TABLE_100
42: , a7 out nocopy JTF_DATE_TABLE
43: , a8 out nocopy JTF_DATE_TABLE
44: , a9 out nocopy JTF_NUMBER_TABLE
45: , a10 out nocopy JTF_VARCHAR2_TABLE_100
46: , a11 out nocopy JTF_VARCHAR2_TABLE_100
47: , a12 out nocopy JTF_NUMBER_TABLE
48: , a13 out nocopy JTF_NUMBER_TABLE

Line 47: , a12 out nocopy JTF_NUMBER_TABLE

43: , a8 out nocopy JTF_DATE_TABLE
44: , a9 out nocopy JTF_NUMBER_TABLE
45: , a10 out nocopy JTF_VARCHAR2_TABLE_100
46: , a11 out nocopy JTF_VARCHAR2_TABLE_100
47: , a12 out nocopy JTF_NUMBER_TABLE
48: , a13 out nocopy JTF_NUMBER_TABLE
49: , a14 out nocopy JTF_VARCHAR2_TABLE_100
50: , a15 out nocopy JTF_VARCHAR2_TABLE_100
51: , a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 48: , a13 out nocopy JTF_NUMBER_TABLE

44: , a9 out nocopy JTF_NUMBER_TABLE
45: , a10 out nocopy JTF_VARCHAR2_TABLE_100
46: , a11 out nocopy JTF_VARCHAR2_TABLE_100
47: , a12 out nocopy JTF_NUMBER_TABLE
48: , a13 out nocopy JTF_NUMBER_TABLE
49: , a14 out nocopy JTF_VARCHAR2_TABLE_100
50: , a15 out nocopy JTF_VARCHAR2_TABLE_100
51: , a16 out nocopy JTF_VARCHAR2_TABLE_100
52: , a17 out nocopy JTF_NUMBER_TABLE

Line 52: , a17 out nocopy JTF_NUMBER_TABLE

48: , a13 out nocopy JTF_NUMBER_TABLE
49: , a14 out nocopy JTF_VARCHAR2_TABLE_100
50: , a15 out nocopy JTF_VARCHAR2_TABLE_100
51: , a16 out nocopy JTF_VARCHAR2_TABLE_100
52: , a17 out nocopy JTF_NUMBER_TABLE
53: , a18 out nocopy JTF_VARCHAR2_TABLE_100
54: , a19 out nocopy JTF_VARCHAR2_TABLE_100
55: , a20 out nocopy JTF_NUMBER_TABLE
56: , a21 out nocopy JTF_NUMBER_TABLE

Line 55: , a20 out nocopy JTF_NUMBER_TABLE

51: , a16 out nocopy JTF_VARCHAR2_TABLE_100
52: , a17 out nocopy JTF_NUMBER_TABLE
53: , a18 out nocopy JTF_VARCHAR2_TABLE_100
54: , a19 out nocopy JTF_VARCHAR2_TABLE_100
55: , a20 out nocopy JTF_NUMBER_TABLE
56: , a21 out nocopy JTF_NUMBER_TABLE
57: , a22 out nocopy JTF_DATE_TABLE
58: , a23 out nocopy JTF_VARCHAR2_TABLE_100
59: );

Line 56: , a21 out nocopy JTF_NUMBER_TABLE

52: , a17 out nocopy JTF_NUMBER_TABLE
53: , a18 out nocopy JTF_VARCHAR2_TABLE_100
54: , a19 out nocopy JTF_VARCHAR2_TABLE_100
55: , a20 out nocopy JTF_NUMBER_TABLE
56: , a21 out nocopy JTF_NUMBER_TABLE
57: , a22 out nocopy JTF_DATE_TABLE
58: , a23 out nocopy JTF_VARCHAR2_TABLE_100
59: );
60:

Line 61: procedure rosetta_table_copy_in_p5(t out nocopy lns_fee_engine.fee_calc_tbl, a0 JTF_NUMBER_TABLE

57: , a22 out nocopy JTF_DATE_TABLE
58: , a23 out nocopy JTF_VARCHAR2_TABLE_100
59: );
60:
61: procedure rosetta_table_copy_in_p5(t out nocopy lns_fee_engine.fee_calc_tbl, a0 JTF_NUMBER_TABLE
62: , a1 JTF_VARCHAR2_TABLE_100
63: , a2 JTF_VARCHAR2_TABLE_100
64: , a3 JTF_VARCHAR2_TABLE_100
65: , a4 JTF_NUMBER_TABLE

Line 65: , a4 JTF_NUMBER_TABLE

61: procedure rosetta_table_copy_in_p5(t out nocopy lns_fee_engine.fee_calc_tbl, a0 JTF_NUMBER_TABLE
62: , a1 JTF_VARCHAR2_TABLE_100
63: , a2 JTF_VARCHAR2_TABLE_100
64: , a3 JTF_VARCHAR2_TABLE_100
65: , a4 JTF_NUMBER_TABLE
66: , a5 JTF_NUMBER_TABLE
67: , a6 JTF_VARCHAR2_TABLE_300
68: , a7 JTF_NUMBER_TABLE
69: , a8 JTF_VARCHAR2_TABLE_100

Line 66: , a5 JTF_NUMBER_TABLE

62: , a1 JTF_VARCHAR2_TABLE_100
63: , a2 JTF_VARCHAR2_TABLE_100
64: , a3 JTF_VARCHAR2_TABLE_100
65: , a4 JTF_NUMBER_TABLE
66: , a5 JTF_NUMBER_TABLE
67: , a6 JTF_VARCHAR2_TABLE_300
68: , a7 JTF_NUMBER_TABLE
69: , a8 JTF_VARCHAR2_TABLE_100
70: , a9 JTF_VARCHAR2_TABLE_100

Line 68: , a7 JTF_NUMBER_TABLE

64: , a3 JTF_VARCHAR2_TABLE_100
65: , a4 JTF_NUMBER_TABLE
66: , a5 JTF_NUMBER_TABLE
67: , a6 JTF_VARCHAR2_TABLE_300
68: , a7 JTF_NUMBER_TABLE
69: , a8 JTF_VARCHAR2_TABLE_100
70: , a9 JTF_VARCHAR2_TABLE_100
71: , a10 JTF_VARCHAR2_TABLE_100
72: , a11 JTF_NUMBER_TABLE

Line 72: , a11 JTF_NUMBER_TABLE

68: , a7 JTF_NUMBER_TABLE
69: , a8 JTF_VARCHAR2_TABLE_100
70: , a9 JTF_VARCHAR2_TABLE_100
71: , a10 JTF_VARCHAR2_TABLE_100
72: , a11 JTF_NUMBER_TABLE
73: , a12 JTF_VARCHAR2_TABLE_100
74: , a13 JTF_VARCHAR2_TABLE_100
75: , a14 JTF_NUMBER_TABLE
76: , a15 JTF_VARCHAR2_TABLE_100

Line 75: , a14 JTF_NUMBER_TABLE

71: , a10 JTF_VARCHAR2_TABLE_100
72: , a11 JTF_NUMBER_TABLE
73: , a12 JTF_VARCHAR2_TABLE_100
74: , a13 JTF_VARCHAR2_TABLE_100
75: , a14 JTF_NUMBER_TABLE
76: , a15 JTF_VARCHAR2_TABLE_100
77: , a16 JTF_VARCHAR2_TABLE_100
78: );
79: procedure rosetta_table_copy_out_p5(t lns_fee_engine.fee_calc_tbl, a0 out nocopy JTF_NUMBER_TABLE

Line 79: procedure rosetta_table_copy_out_p5(t lns_fee_engine.fee_calc_tbl, a0 out nocopy JTF_NUMBER_TABLE

75: , a14 JTF_NUMBER_TABLE
76: , a15 JTF_VARCHAR2_TABLE_100
77: , a16 JTF_VARCHAR2_TABLE_100
78: );
79: procedure rosetta_table_copy_out_p5(t lns_fee_engine.fee_calc_tbl, a0 out nocopy JTF_NUMBER_TABLE
80: , a1 out nocopy JTF_VARCHAR2_TABLE_100
81: , a2 out nocopy JTF_VARCHAR2_TABLE_100
82: , a3 out nocopy JTF_VARCHAR2_TABLE_100
83: , a4 out nocopy JTF_NUMBER_TABLE

Line 83: , a4 out nocopy JTF_NUMBER_TABLE

79: procedure rosetta_table_copy_out_p5(t lns_fee_engine.fee_calc_tbl, a0 out nocopy JTF_NUMBER_TABLE
80: , a1 out nocopy JTF_VARCHAR2_TABLE_100
81: , a2 out nocopy JTF_VARCHAR2_TABLE_100
82: , a3 out nocopy JTF_VARCHAR2_TABLE_100
83: , a4 out nocopy JTF_NUMBER_TABLE
84: , a5 out nocopy JTF_NUMBER_TABLE
85: , a6 out nocopy JTF_VARCHAR2_TABLE_300
86: , a7 out nocopy JTF_NUMBER_TABLE
87: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 84: , a5 out nocopy JTF_NUMBER_TABLE

80: , a1 out nocopy JTF_VARCHAR2_TABLE_100
81: , a2 out nocopy JTF_VARCHAR2_TABLE_100
82: , a3 out nocopy JTF_VARCHAR2_TABLE_100
83: , a4 out nocopy JTF_NUMBER_TABLE
84: , a5 out nocopy JTF_NUMBER_TABLE
85: , a6 out nocopy JTF_VARCHAR2_TABLE_300
86: , a7 out nocopy JTF_NUMBER_TABLE
87: , a8 out nocopy JTF_VARCHAR2_TABLE_100
88: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 86: , a7 out nocopy JTF_NUMBER_TABLE

82: , a3 out nocopy JTF_VARCHAR2_TABLE_100
83: , a4 out nocopy JTF_NUMBER_TABLE
84: , a5 out nocopy JTF_NUMBER_TABLE
85: , a6 out nocopy JTF_VARCHAR2_TABLE_300
86: , a7 out nocopy JTF_NUMBER_TABLE
87: , a8 out nocopy JTF_VARCHAR2_TABLE_100
88: , a9 out nocopy JTF_VARCHAR2_TABLE_100
89: , a10 out nocopy JTF_VARCHAR2_TABLE_100
90: , a11 out nocopy JTF_NUMBER_TABLE

Line 90: , a11 out nocopy JTF_NUMBER_TABLE

86: , a7 out nocopy JTF_NUMBER_TABLE
87: , a8 out nocopy JTF_VARCHAR2_TABLE_100
88: , a9 out nocopy JTF_VARCHAR2_TABLE_100
89: , a10 out nocopy JTF_VARCHAR2_TABLE_100
90: , a11 out nocopy JTF_NUMBER_TABLE
91: , a12 out nocopy JTF_VARCHAR2_TABLE_100
92: , a13 out nocopy JTF_VARCHAR2_TABLE_100
93: , a14 out nocopy JTF_NUMBER_TABLE
94: , a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 93: , a14 out nocopy JTF_NUMBER_TABLE

89: , a10 out nocopy JTF_VARCHAR2_TABLE_100
90: , a11 out nocopy JTF_NUMBER_TABLE
91: , a12 out nocopy JTF_VARCHAR2_TABLE_100
92: , a13 out nocopy JTF_VARCHAR2_TABLE_100
93: , a14 out nocopy JTF_NUMBER_TABLE
94: , a15 out nocopy JTF_VARCHAR2_TABLE_100
95: , a16 out nocopy JTF_VARCHAR2_TABLE_100
96: );
97:

Line 100: , p1_a1 JTF_NUMBER_TABLE

96: );
97:
98: procedure calculatefees(p_loan_id NUMBER
99: , p1_a0 JTF_VARCHAR2_TABLE_100
100: , p1_a1 JTF_NUMBER_TABLE
101: , p_installment NUMBER
102: , p3_a0 JTF_NUMBER_TABLE
103: , p3_a1 JTF_VARCHAR2_TABLE_100
104: , p3_a2 JTF_VARCHAR2_TABLE_300

Line 102: , p3_a0 JTF_NUMBER_TABLE

98: procedure calculatefees(p_loan_id NUMBER
99: , p1_a0 JTF_VARCHAR2_TABLE_100
100: , p1_a1 JTF_NUMBER_TABLE
101: , p_installment NUMBER
102: , p3_a0 JTF_NUMBER_TABLE
103: , p3_a1 JTF_VARCHAR2_TABLE_100
104: , p3_a2 JTF_VARCHAR2_TABLE_300
105: , p3_a3 JTF_VARCHAR2_TABLE_100
106: , p3_a4 JTF_VARCHAR2_TABLE_100

Line 107: , p3_a5 JTF_NUMBER_TABLE

103: , p3_a1 JTF_VARCHAR2_TABLE_100
104: , p3_a2 JTF_VARCHAR2_TABLE_300
105: , p3_a3 JTF_VARCHAR2_TABLE_100
106: , p3_a4 JTF_VARCHAR2_TABLE_100
107: , p3_a5 JTF_NUMBER_TABLE
108: , p3_a6 JTF_VARCHAR2_TABLE_100
109: , p3_a7 JTF_DATE_TABLE
110: , p3_a8 JTF_DATE_TABLE
111: , p3_a9 JTF_NUMBER_TABLE

Line 111: , p3_a9 JTF_NUMBER_TABLE

107: , p3_a5 JTF_NUMBER_TABLE
108: , p3_a6 JTF_VARCHAR2_TABLE_100
109: , p3_a7 JTF_DATE_TABLE
110: , p3_a8 JTF_DATE_TABLE
111: , p3_a9 JTF_NUMBER_TABLE
112: , p3_a10 JTF_VARCHAR2_TABLE_100
113: , p3_a11 JTF_VARCHAR2_TABLE_100
114: , p3_a12 JTF_NUMBER_TABLE
115: , p3_a13 JTF_NUMBER_TABLE

Line 114: , p3_a12 JTF_NUMBER_TABLE

110: , p3_a8 JTF_DATE_TABLE
111: , p3_a9 JTF_NUMBER_TABLE
112: , p3_a10 JTF_VARCHAR2_TABLE_100
113: , p3_a11 JTF_VARCHAR2_TABLE_100
114: , p3_a12 JTF_NUMBER_TABLE
115: , p3_a13 JTF_NUMBER_TABLE
116: , p3_a14 JTF_VARCHAR2_TABLE_100
117: , p3_a15 JTF_VARCHAR2_TABLE_100
118: , p3_a16 JTF_VARCHAR2_TABLE_100

Line 115: , p3_a13 JTF_NUMBER_TABLE

111: , p3_a9 JTF_NUMBER_TABLE
112: , p3_a10 JTF_VARCHAR2_TABLE_100
113: , p3_a11 JTF_VARCHAR2_TABLE_100
114: , p3_a12 JTF_NUMBER_TABLE
115: , p3_a13 JTF_NUMBER_TABLE
116: , p3_a14 JTF_VARCHAR2_TABLE_100
117: , p3_a15 JTF_VARCHAR2_TABLE_100
118: , p3_a16 JTF_VARCHAR2_TABLE_100
119: , p3_a17 JTF_NUMBER_TABLE

Line 119: , p3_a17 JTF_NUMBER_TABLE

115: , p3_a13 JTF_NUMBER_TABLE
116: , p3_a14 JTF_VARCHAR2_TABLE_100
117: , p3_a15 JTF_VARCHAR2_TABLE_100
118: , p3_a16 JTF_VARCHAR2_TABLE_100
119: , p3_a17 JTF_NUMBER_TABLE
120: , p3_a18 JTF_VARCHAR2_TABLE_100
121: , p3_a19 JTF_VARCHAR2_TABLE_100
122: , p3_a20 JTF_NUMBER_TABLE
123: , p3_a21 JTF_NUMBER_TABLE

Line 122: , p3_a20 JTF_NUMBER_TABLE

118: , p3_a16 JTF_VARCHAR2_TABLE_100
119: , p3_a17 JTF_NUMBER_TABLE
120: , p3_a18 JTF_VARCHAR2_TABLE_100
121: , p3_a19 JTF_VARCHAR2_TABLE_100
122: , p3_a20 JTF_NUMBER_TABLE
123: , p3_a21 JTF_NUMBER_TABLE
124: , p3_a22 JTF_DATE_TABLE
125: , p3_a23 JTF_VARCHAR2_TABLE_100
126: , p4_a0 out nocopy JTF_NUMBER_TABLE

Line 123: , p3_a21 JTF_NUMBER_TABLE

119: , p3_a17 JTF_NUMBER_TABLE
120: , p3_a18 JTF_VARCHAR2_TABLE_100
121: , p3_a19 JTF_VARCHAR2_TABLE_100
122: , p3_a20 JTF_NUMBER_TABLE
123: , p3_a21 JTF_NUMBER_TABLE
124: , p3_a22 JTF_DATE_TABLE
125: , p3_a23 JTF_VARCHAR2_TABLE_100
126: , p4_a0 out nocopy JTF_NUMBER_TABLE
127: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 126: , p4_a0 out nocopy JTF_NUMBER_TABLE

122: , p3_a20 JTF_NUMBER_TABLE
123: , p3_a21 JTF_NUMBER_TABLE
124: , p3_a22 JTF_DATE_TABLE
125: , p3_a23 JTF_VARCHAR2_TABLE_100
126: , p4_a0 out nocopy JTF_NUMBER_TABLE
127: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
128: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
129: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
130: , p4_a4 out nocopy JTF_NUMBER_TABLE

Line 130: , p4_a4 out nocopy JTF_NUMBER_TABLE

126: , p4_a0 out nocopy JTF_NUMBER_TABLE
127: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
128: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
129: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
130: , p4_a4 out nocopy JTF_NUMBER_TABLE
131: , p4_a5 out nocopy JTF_NUMBER_TABLE
132: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_300
133: , p4_a7 out nocopy JTF_NUMBER_TABLE
134: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 131: , p4_a5 out nocopy JTF_NUMBER_TABLE

127: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
128: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
129: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
130: , p4_a4 out nocopy JTF_NUMBER_TABLE
131: , p4_a5 out nocopy JTF_NUMBER_TABLE
132: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_300
133: , p4_a7 out nocopy JTF_NUMBER_TABLE
134: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
135: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 133: , p4_a7 out nocopy JTF_NUMBER_TABLE

129: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
130: , p4_a4 out nocopy JTF_NUMBER_TABLE
131: , p4_a5 out nocopy JTF_NUMBER_TABLE
132: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_300
133: , p4_a7 out nocopy JTF_NUMBER_TABLE
134: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
135: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
136: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
137: , p4_a11 out nocopy JTF_NUMBER_TABLE

Line 137: , p4_a11 out nocopy JTF_NUMBER_TABLE

133: , p4_a7 out nocopy JTF_NUMBER_TABLE
134: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
135: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
136: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
137: , p4_a11 out nocopy JTF_NUMBER_TABLE
138: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
139: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_100
140: , p4_a14 out nocopy JTF_NUMBER_TABLE
141: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 140: , p4_a14 out nocopy JTF_NUMBER_TABLE

136: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
137: , p4_a11 out nocopy JTF_NUMBER_TABLE
138: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
139: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_100
140: , p4_a14 out nocopy JTF_NUMBER_TABLE
141: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
142: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
143: , x_return_status out nocopy VARCHAR2
144: , x_msg_count out nocopy NUMBER

Line 150: , p3_a0 in out nocopy JTF_NUMBER_TABLE

146: );
147: procedure writefeeschedule(p_init_msg_list VARCHAR2
148: , p_commit VARCHAR2
149: , p_loan_id NUMBER
150: , p3_a0 in out nocopy JTF_NUMBER_TABLE
151: , p3_a1 in out nocopy JTF_VARCHAR2_TABLE_100
152: , p3_a2 in out nocopy JTF_VARCHAR2_TABLE_100
153: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
154: , p3_a4 in out nocopy JTF_NUMBER_TABLE

Line 154: , p3_a4 in out nocopy JTF_NUMBER_TABLE

150: , p3_a0 in out nocopy JTF_NUMBER_TABLE
151: , p3_a1 in out nocopy JTF_VARCHAR2_TABLE_100
152: , p3_a2 in out nocopy JTF_VARCHAR2_TABLE_100
153: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
154: , p3_a4 in out nocopy JTF_NUMBER_TABLE
155: , p3_a5 in out nocopy JTF_NUMBER_TABLE
156: , p3_a6 in out nocopy JTF_VARCHAR2_TABLE_300
157: , p3_a7 in out nocopy JTF_NUMBER_TABLE
158: , p3_a8 in out nocopy JTF_VARCHAR2_TABLE_100

Line 155: , p3_a5 in out nocopy JTF_NUMBER_TABLE

151: , p3_a1 in out nocopy JTF_VARCHAR2_TABLE_100
152: , p3_a2 in out nocopy JTF_VARCHAR2_TABLE_100
153: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
154: , p3_a4 in out nocopy JTF_NUMBER_TABLE
155: , p3_a5 in out nocopy JTF_NUMBER_TABLE
156: , p3_a6 in out nocopy JTF_VARCHAR2_TABLE_300
157: , p3_a7 in out nocopy JTF_NUMBER_TABLE
158: , p3_a8 in out nocopy JTF_VARCHAR2_TABLE_100
159: , p3_a9 in out nocopy JTF_VARCHAR2_TABLE_100

Line 157: , p3_a7 in out nocopy JTF_NUMBER_TABLE

153: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
154: , p3_a4 in out nocopy JTF_NUMBER_TABLE
155: , p3_a5 in out nocopy JTF_NUMBER_TABLE
156: , p3_a6 in out nocopy JTF_VARCHAR2_TABLE_300
157: , p3_a7 in out nocopy JTF_NUMBER_TABLE
158: , p3_a8 in out nocopy JTF_VARCHAR2_TABLE_100
159: , p3_a9 in out nocopy JTF_VARCHAR2_TABLE_100
160: , p3_a10 in out nocopy JTF_VARCHAR2_TABLE_100
161: , p3_a11 in out nocopy JTF_NUMBER_TABLE

Line 161: , p3_a11 in out nocopy JTF_NUMBER_TABLE

157: , p3_a7 in out nocopy JTF_NUMBER_TABLE
158: , p3_a8 in out nocopy JTF_VARCHAR2_TABLE_100
159: , p3_a9 in out nocopy JTF_VARCHAR2_TABLE_100
160: , p3_a10 in out nocopy JTF_VARCHAR2_TABLE_100
161: , p3_a11 in out nocopy JTF_NUMBER_TABLE
162: , p3_a12 in out nocopy JTF_VARCHAR2_TABLE_100
163: , p3_a13 in out nocopy JTF_VARCHAR2_TABLE_100
164: , p3_a14 in out nocopy JTF_NUMBER_TABLE
165: , p3_a15 in out nocopy JTF_VARCHAR2_TABLE_100

Line 164: , p3_a14 in out nocopy JTF_NUMBER_TABLE

160: , p3_a10 in out nocopy JTF_VARCHAR2_TABLE_100
161: , p3_a11 in out nocopy JTF_NUMBER_TABLE
162: , p3_a12 in out nocopy JTF_VARCHAR2_TABLE_100
163: , p3_a13 in out nocopy JTF_VARCHAR2_TABLE_100
164: , p3_a14 in out nocopy JTF_NUMBER_TABLE
165: , p3_a15 in out nocopy JTF_VARCHAR2_TABLE_100
166: , p3_a16 in out nocopy JTF_VARCHAR2_TABLE_100
167: , x_return_status out nocopy VARCHAR2
168: , x_msg_count out nocopy NUMBER

Line 174: , p3_a0 JTF_NUMBER_TABLE

170: );
171: procedure updatefeeschedule(p_init_msg_list VARCHAR2
172: , p_commit VARCHAR2
173: , p_loan_id NUMBER
174: , p3_a0 JTF_NUMBER_TABLE
175: , p3_a1 JTF_VARCHAR2_TABLE_100
176: , p3_a2 JTF_VARCHAR2_TABLE_100
177: , p3_a3 JTF_VARCHAR2_TABLE_100
178: , p3_a4 JTF_NUMBER_TABLE

Line 178: , p3_a4 JTF_NUMBER_TABLE

174: , p3_a0 JTF_NUMBER_TABLE
175: , p3_a1 JTF_VARCHAR2_TABLE_100
176: , p3_a2 JTF_VARCHAR2_TABLE_100
177: , p3_a3 JTF_VARCHAR2_TABLE_100
178: , p3_a4 JTF_NUMBER_TABLE
179: , p3_a5 JTF_NUMBER_TABLE
180: , p3_a6 JTF_VARCHAR2_TABLE_300
181: , p3_a7 JTF_NUMBER_TABLE
182: , p3_a8 JTF_VARCHAR2_TABLE_100

Line 179: , p3_a5 JTF_NUMBER_TABLE

175: , p3_a1 JTF_VARCHAR2_TABLE_100
176: , p3_a2 JTF_VARCHAR2_TABLE_100
177: , p3_a3 JTF_VARCHAR2_TABLE_100
178: , p3_a4 JTF_NUMBER_TABLE
179: , p3_a5 JTF_NUMBER_TABLE
180: , p3_a6 JTF_VARCHAR2_TABLE_300
181: , p3_a7 JTF_NUMBER_TABLE
182: , p3_a8 JTF_VARCHAR2_TABLE_100
183: , p3_a9 JTF_VARCHAR2_TABLE_100

Line 181: , p3_a7 JTF_NUMBER_TABLE

177: , p3_a3 JTF_VARCHAR2_TABLE_100
178: , p3_a4 JTF_NUMBER_TABLE
179: , p3_a5 JTF_NUMBER_TABLE
180: , p3_a6 JTF_VARCHAR2_TABLE_300
181: , p3_a7 JTF_NUMBER_TABLE
182: , p3_a8 JTF_VARCHAR2_TABLE_100
183: , p3_a9 JTF_VARCHAR2_TABLE_100
184: , p3_a10 JTF_VARCHAR2_TABLE_100
185: , p3_a11 JTF_NUMBER_TABLE

Line 185: , p3_a11 JTF_NUMBER_TABLE

181: , p3_a7 JTF_NUMBER_TABLE
182: , p3_a8 JTF_VARCHAR2_TABLE_100
183: , p3_a9 JTF_VARCHAR2_TABLE_100
184: , p3_a10 JTF_VARCHAR2_TABLE_100
185: , p3_a11 JTF_NUMBER_TABLE
186: , p3_a12 JTF_VARCHAR2_TABLE_100
187: , p3_a13 JTF_VARCHAR2_TABLE_100
188: , p3_a14 JTF_NUMBER_TABLE
189: , p3_a15 JTF_VARCHAR2_TABLE_100

Line 188: , p3_a14 JTF_NUMBER_TABLE

184: , p3_a10 JTF_VARCHAR2_TABLE_100
185: , p3_a11 JTF_NUMBER_TABLE
186: , p3_a12 JTF_VARCHAR2_TABLE_100
187: , p3_a13 JTF_VARCHAR2_TABLE_100
188: , p3_a14 JTF_NUMBER_TABLE
189: , p3_a15 JTF_VARCHAR2_TABLE_100
190: , p3_a16 JTF_VARCHAR2_TABLE_100
191: , x_return_status out nocopy VARCHAR2
192: , x_msg_count out nocopy NUMBER

Line 200: , p5_a0 out nocopy JTF_NUMBER_TABLE

196: , p_loan_id NUMBER
197: , p_installment_number NUMBER
198: , p_disb_header_id NUMBER
199: , p_phase VARCHAR2
200: , p5_a0 out nocopy JTF_NUMBER_TABLE
201: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
202: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
203: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
204: , p5_a4 out nocopy JTF_NUMBER_TABLE

Line 204: , p5_a4 out nocopy JTF_NUMBER_TABLE

200: , p5_a0 out nocopy JTF_NUMBER_TABLE
201: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
202: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
203: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
204: , p5_a4 out nocopy JTF_NUMBER_TABLE
205: , p5_a5 out nocopy JTF_NUMBER_TABLE
206: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_300
207: , p5_a7 out nocopy JTF_NUMBER_TABLE
208: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 205: , p5_a5 out nocopy JTF_NUMBER_TABLE

201: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
202: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
203: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
204: , p5_a4 out nocopy JTF_NUMBER_TABLE
205: , p5_a5 out nocopy JTF_NUMBER_TABLE
206: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_300
207: , p5_a7 out nocopy JTF_NUMBER_TABLE
208: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100
209: , p5_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 207: , p5_a7 out nocopy JTF_NUMBER_TABLE

203: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
204: , p5_a4 out nocopy JTF_NUMBER_TABLE
205: , p5_a5 out nocopy JTF_NUMBER_TABLE
206: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_300
207: , p5_a7 out nocopy JTF_NUMBER_TABLE
208: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100
209: , p5_a9 out nocopy JTF_VARCHAR2_TABLE_100
210: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100
211: , p5_a11 out nocopy JTF_NUMBER_TABLE

Line 211: , p5_a11 out nocopy JTF_NUMBER_TABLE

207: , p5_a7 out nocopy JTF_NUMBER_TABLE
208: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100
209: , p5_a9 out nocopy JTF_VARCHAR2_TABLE_100
210: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100
211: , p5_a11 out nocopy JTF_NUMBER_TABLE
212: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
213: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_100
214: , p5_a14 out nocopy JTF_NUMBER_TABLE
215: , p5_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 214: , p5_a14 out nocopy JTF_NUMBER_TABLE

210: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100
211: , p5_a11 out nocopy JTF_NUMBER_TABLE
212: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
213: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_100
214: , p5_a14 out nocopy JTF_NUMBER_TABLE
215: , p5_a15 out nocopy JTF_VARCHAR2_TABLE_100
216: , p5_a16 out nocopy JTF_VARCHAR2_TABLE_100
217: , x_return_status out nocopy VARCHAR2
218: , x_msg_count out nocopy NUMBER

Line 225: , p3_a1 JTF_NUMBER_TABLE

221: procedure getfeedetails(p_init_msg_list VARCHAR2
222: , p_loan_id NUMBER
223: , p_installment NUMBER
224: , p3_a0 JTF_VARCHAR2_TABLE_100
225: , p3_a1 JTF_NUMBER_TABLE
226: , p_based_on_terms VARCHAR2
227: , p_phase VARCHAR2
228: , p6_a0 out nocopy JTF_NUMBER_TABLE
229: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 228: , p6_a0 out nocopy JTF_NUMBER_TABLE

224: , p3_a0 JTF_VARCHAR2_TABLE_100
225: , p3_a1 JTF_NUMBER_TABLE
226: , p_based_on_terms VARCHAR2
227: , p_phase VARCHAR2
228: , p6_a0 out nocopy JTF_NUMBER_TABLE
229: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
230: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
231: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
232: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 232: , p6_a4 out nocopy JTF_NUMBER_TABLE

228: , p6_a0 out nocopy JTF_NUMBER_TABLE
229: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
230: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
231: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
232: , p6_a4 out nocopy JTF_NUMBER_TABLE
233: , p6_a5 out nocopy JTF_NUMBER_TABLE
234: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
235: , p6_a7 out nocopy JTF_NUMBER_TABLE
236: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 233: , p6_a5 out nocopy JTF_NUMBER_TABLE

229: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
230: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
231: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
232: , p6_a4 out nocopy JTF_NUMBER_TABLE
233: , p6_a5 out nocopy JTF_NUMBER_TABLE
234: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
235: , p6_a7 out nocopy JTF_NUMBER_TABLE
236: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
237: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 235: , p6_a7 out nocopy JTF_NUMBER_TABLE

231: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
232: , p6_a4 out nocopy JTF_NUMBER_TABLE
233: , p6_a5 out nocopy JTF_NUMBER_TABLE
234: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
235: , p6_a7 out nocopy JTF_NUMBER_TABLE
236: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
237: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
238: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
239: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 239: , p6_a11 out nocopy JTF_NUMBER_TABLE

235: , p6_a7 out nocopy JTF_NUMBER_TABLE
236: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
237: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
238: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
239: , p6_a11 out nocopy JTF_NUMBER_TABLE
240: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
241: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
242: , p6_a14 out nocopy JTF_NUMBER_TABLE
243: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 242: , p6_a14 out nocopy JTF_NUMBER_TABLE

238: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
239: , p6_a11 out nocopy JTF_NUMBER_TABLE
240: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
241: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
242: , p6_a14 out nocopy JTF_NUMBER_TABLE
243: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
244: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
245: , x_return_status out nocopy VARCHAR2
246: , x_msg_count out nocopy NUMBER

Line 254: , p4_a1 JTF_NUMBER_TABLE

250: , p_commit VARCHAR2
251: , p_loan_id NUMBER
252: , p_installment_number NUMBER
253: , p4_a0 JTF_VARCHAR2_TABLE_100
254: , p4_a1 JTF_NUMBER_TABLE
255: , p5_a0 JTF_NUMBER_TABLE
256: , p5_a1 JTF_VARCHAR2_TABLE_100
257: , p5_a2 JTF_VARCHAR2_TABLE_300
258: , p5_a3 JTF_VARCHAR2_TABLE_100

Line 255: , p5_a0 JTF_NUMBER_TABLE

251: , p_loan_id NUMBER
252: , p_installment_number NUMBER
253: , p4_a0 JTF_VARCHAR2_TABLE_100
254: , p4_a1 JTF_NUMBER_TABLE
255: , p5_a0 JTF_NUMBER_TABLE
256: , p5_a1 JTF_VARCHAR2_TABLE_100
257: , p5_a2 JTF_VARCHAR2_TABLE_300
258: , p5_a3 JTF_VARCHAR2_TABLE_100
259: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 260: , p5_a5 JTF_NUMBER_TABLE

256: , p5_a1 JTF_VARCHAR2_TABLE_100
257: , p5_a2 JTF_VARCHAR2_TABLE_300
258: , p5_a3 JTF_VARCHAR2_TABLE_100
259: , p5_a4 JTF_VARCHAR2_TABLE_100
260: , p5_a5 JTF_NUMBER_TABLE
261: , p5_a6 JTF_VARCHAR2_TABLE_100
262: , p5_a7 JTF_DATE_TABLE
263: , p5_a8 JTF_DATE_TABLE
264: , p5_a9 JTF_NUMBER_TABLE

Line 264: , p5_a9 JTF_NUMBER_TABLE

260: , p5_a5 JTF_NUMBER_TABLE
261: , p5_a6 JTF_VARCHAR2_TABLE_100
262: , p5_a7 JTF_DATE_TABLE
263: , p5_a8 JTF_DATE_TABLE
264: , p5_a9 JTF_NUMBER_TABLE
265: , p5_a10 JTF_VARCHAR2_TABLE_100
266: , p5_a11 JTF_VARCHAR2_TABLE_100
267: , p5_a12 JTF_NUMBER_TABLE
268: , p5_a13 JTF_NUMBER_TABLE

Line 267: , p5_a12 JTF_NUMBER_TABLE

263: , p5_a8 JTF_DATE_TABLE
264: , p5_a9 JTF_NUMBER_TABLE
265: , p5_a10 JTF_VARCHAR2_TABLE_100
266: , p5_a11 JTF_VARCHAR2_TABLE_100
267: , p5_a12 JTF_NUMBER_TABLE
268: , p5_a13 JTF_NUMBER_TABLE
269: , p5_a14 JTF_VARCHAR2_TABLE_100
270: , p5_a15 JTF_VARCHAR2_TABLE_100
271: , p5_a16 JTF_VARCHAR2_TABLE_100

Line 268: , p5_a13 JTF_NUMBER_TABLE

264: , p5_a9 JTF_NUMBER_TABLE
265: , p5_a10 JTF_VARCHAR2_TABLE_100
266: , p5_a11 JTF_VARCHAR2_TABLE_100
267: , p5_a12 JTF_NUMBER_TABLE
268: , p5_a13 JTF_NUMBER_TABLE
269: , p5_a14 JTF_VARCHAR2_TABLE_100
270: , p5_a15 JTF_VARCHAR2_TABLE_100
271: , p5_a16 JTF_VARCHAR2_TABLE_100
272: , p5_a17 JTF_NUMBER_TABLE

Line 272: , p5_a17 JTF_NUMBER_TABLE

268: , p5_a13 JTF_NUMBER_TABLE
269: , p5_a14 JTF_VARCHAR2_TABLE_100
270: , p5_a15 JTF_VARCHAR2_TABLE_100
271: , p5_a16 JTF_VARCHAR2_TABLE_100
272: , p5_a17 JTF_NUMBER_TABLE
273: , p5_a18 JTF_VARCHAR2_TABLE_100
274: , p5_a19 JTF_VARCHAR2_TABLE_100
275: , p5_a20 JTF_NUMBER_TABLE
276: , p5_a21 JTF_NUMBER_TABLE

Line 275: , p5_a20 JTF_NUMBER_TABLE

271: , p5_a16 JTF_VARCHAR2_TABLE_100
272: , p5_a17 JTF_NUMBER_TABLE
273: , p5_a18 JTF_VARCHAR2_TABLE_100
274: , p5_a19 JTF_VARCHAR2_TABLE_100
275: , p5_a20 JTF_NUMBER_TABLE
276: , p5_a21 JTF_NUMBER_TABLE
277: , p5_a22 JTF_DATE_TABLE
278: , p5_a23 JTF_VARCHAR2_TABLE_100
279: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 276: , p5_a21 JTF_NUMBER_TABLE

272: , p5_a17 JTF_NUMBER_TABLE
273: , p5_a18 JTF_VARCHAR2_TABLE_100
274: , p5_a19 JTF_VARCHAR2_TABLE_100
275: , p5_a20 JTF_NUMBER_TABLE
276: , p5_a21 JTF_NUMBER_TABLE
277: , p5_a22 JTF_DATE_TABLE
278: , p5_a23 JTF_VARCHAR2_TABLE_100
279: , p6_a0 out nocopy JTF_NUMBER_TABLE
280: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 279: , p6_a0 out nocopy JTF_NUMBER_TABLE

275: , p5_a20 JTF_NUMBER_TABLE
276: , p5_a21 JTF_NUMBER_TABLE
277: , p5_a22 JTF_DATE_TABLE
278: , p5_a23 JTF_VARCHAR2_TABLE_100
279: , p6_a0 out nocopy JTF_NUMBER_TABLE
280: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
281: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
282: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
283: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 283: , p6_a4 out nocopy JTF_NUMBER_TABLE

279: , p6_a0 out nocopy JTF_NUMBER_TABLE
280: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
281: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
282: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
283: , p6_a4 out nocopy JTF_NUMBER_TABLE
284: , p6_a5 out nocopy JTF_NUMBER_TABLE
285: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
286: , p6_a7 out nocopy JTF_NUMBER_TABLE
287: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 284: , p6_a5 out nocopy JTF_NUMBER_TABLE

280: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
281: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
282: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
283: , p6_a4 out nocopy JTF_NUMBER_TABLE
284: , p6_a5 out nocopy JTF_NUMBER_TABLE
285: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
286: , p6_a7 out nocopy JTF_NUMBER_TABLE
287: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
288: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 286: , p6_a7 out nocopy JTF_NUMBER_TABLE

282: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
283: , p6_a4 out nocopy JTF_NUMBER_TABLE
284: , p6_a5 out nocopy JTF_NUMBER_TABLE
285: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
286: , p6_a7 out nocopy JTF_NUMBER_TABLE
287: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
288: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
289: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
290: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 290: , p6_a11 out nocopy JTF_NUMBER_TABLE

286: , p6_a7 out nocopy JTF_NUMBER_TABLE
287: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
288: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
289: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
290: , p6_a11 out nocopy JTF_NUMBER_TABLE
291: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
292: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
293: , p6_a14 out nocopy JTF_NUMBER_TABLE
294: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 293: , p6_a14 out nocopy JTF_NUMBER_TABLE

289: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
290: , p6_a11 out nocopy JTF_NUMBER_TABLE
291: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
292: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
293: , p6_a14 out nocopy JTF_NUMBER_TABLE
294: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
295: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
296: , x_return_status out nocopy VARCHAR2
297: , x_msg_count out nocopy NUMBER

Line 303: , p3_a0 out nocopy JTF_NUMBER_TABLE

299: );
300: procedure getsubmitforapprfeeschedule(p_init_msg_list VARCHAR2
301: , p_loan_id NUMBER
302: , p_billed_flag VARCHAR2
303: , p3_a0 out nocopy JTF_NUMBER_TABLE
304: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
305: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
306: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
307: , p3_a4 out nocopy JTF_NUMBER_TABLE

Line 307: , p3_a4 out nocopy JTF_NUMBER_TABLE

303: , p3_a0 out nocopy JTF_NUMBER_TABLE
304: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
305: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
306: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
307: , p3_a4 out nocopy JTF_NUMBER_TABLE
308: , p3_a5 out nocopy JTF_NUMBER_TABLE
309: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_300
310: , p3_a7 out nocopy JTF_NUMBER_TABLE
311: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 308: , p3_a5 out nocopy JTF_NUMBER_TABLE

304: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
305: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
306: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
307: , p3_a4 out nocopy JTF_NUMBER_TABLE
308: , p3_a5 out nocopy JTF_NUMBER_TABLE
309: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_300
310: , p3_a7 out nocopy JTF_NUMBER_TABLE
311: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
312: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 310: , p3_a7 out nocopy JTF_NUMBER_TABLE

306: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
307: , p3_a4 out nocopy JTF_NUMBER_TABLE
308: , p3_a5 out nocopy JTF_NUMBER_TABLE
309: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_300
310: , p3_a7 out nocopy JTF_NUMBER_TABLE
311: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
312: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100
313: , p3_a10 out nocopy JTF_VARCHAR2_TABLE_100
314: , p3_a11 out nocopy JTF_NUMBER_TABLE

Line 314: , p3_a11 out nocopy JTF_NUMBER_TABLE

310: , p3_a7 out nocopy JTF_NUMBER_TABLE
311: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
312: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100
313: , p3_a10 out nocopy JTF_VARCHAR2_TABLE_100
314: , p3_a11 out nocopy JTF_NUMBER_TABLE
315: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
316: , p3_a13 out nocopy JTF_VARCHAR2_TABLE_100
317: , p3_a14 out nocopy JTF_NUMBER_TABLE
318: , p3_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 317: , p3_a14 out nocopy JTF_NUMBER_TABLE

313: , p3_a10 out nocopy JTF_VARCHAR2_TABLE_100
314: , p3_a11 out nocopy JTF_NUMBER_TABLE
315: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
316: , p3_a13 out nocopy JTF_VARCHAR2_TABLE_100
317: , p3_a14 out nocopy JTF_NUMBER_TABLE
318: , p3_a15 out nocopy JTF_VARCHAR2_TABLE_100
319: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_100
320: , x_return_status out nocopy VARCHAR2
321: , x_msg_count out nocopy NUMBER