APPS.LNS_FEE_ENGINE_W dependencies on JTF_NUMBER_TABLE

Line 4: , a1 JTF_NUMBER_TABLE

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

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: );
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

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

30: , a20 JTF_NUMBER_TABLE
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

Line 39: , a5 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
43: , a9 out nocopy JTF_NUMBER_TABLE

Line 43: , a9 out nocopy JTF_NUMBER_TABLE

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
45: , a11 out nocopy JTF_VARCHAR2_TABLE_100
46: , a12 out nocopy JTF_NUMBER_TABLE
47: , a13 out nocopy JTF_NUMBER_TABLE

Line 46: , a12 out nocopy JTF_NUMBER_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
50: , a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 47: , a13 out nocopy JTF_NUMBER_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
50: , a16 out nocopy JTF_VARCHAR2_TABLE_100
51: , a17 out nocopy JTF_NUMBER_TABLE

Line 51: , a17 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
55: , a21 out nocopy JTF_NUMBER_TABLE

Line 54: , a20 out nocopy JTF_NUMBER_TABLE

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: );
58:

Line 55: , a21 out nocopy JTF_NUMBER_TABLE

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: );
58:
59: procedure rosetta_table_copy_in_p5(t out nocopy lns_fee_engine.fee_calc_tbl, a0 JTF_NUMBER_TABLE

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

55: , a21 out nocopy JTF_NUMBER_TABLE
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

Line 63: , a4 JTF_NUMBER_TABLE

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
67: , a8 JTF_VARCHAR2_TABLE_100

Line 64: , a5 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
67: , a8 JTF_VARCHAR2_TABLE_100
68: , a9 JTF_VARCHAR2_TABLE_100

Line 66: , a7 JTF_NUMBER_TABLE

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
67: , a8 JTF_VARCHAR2_TABLE_100
68: , a9 JTF_VARCHAR2_TABLE_100
69: , a10 JTF_VARCHAR2_TABLE_100
70: , a11 JTF_NUMBER_TABLE

Line 70: , a11 JTF_NUMBER_TABLE

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
74: );

Line 73: , a14 JTF_NUMBER_TABLE

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
77: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 75: procedure rosetta_table_copy_out_p5(t lns_fee_engine.fee_calc_tbl, a0 out nocopy 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
77: , a2 out nocopy JTF_VARCHAR2_TABLE_100
78: , a3 out nocopy JTF_VARCHAR2_TABLE_100
79: , a4 out nocopy JTF_NUMBER_TABLE

Line 79: , a4 out nocopy JTF_NUMBER_TABLE

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
83: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 80: , a5 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
83: , a8 out nocopy JTF_VARCHAR2_TABLE_100
84: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 82: , a7 out nocopy JTF_NUMBER_TABLE

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
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

Line 86: , a11 out nocopy JTF_NUMBER_TABLE

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
90: );

Line 89: , a14 out nocopy JTF_NUMBER_TABLE

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
93: , p1_a0 JTF_VARCHAR2_TABLE_100

Line 94: , p1_a1 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
98: , p3_a2 JTF_VARCHAR2_TABLE_300

Line 96: , p3_a0 JTF_NUMBER_TABLE

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
98: , p3_a2 JTF_VARCHAR2_TABLE_300
99: , p3_a3 JTF_VARCHAR2_TABLE_100
100: , p3_a4 JTF_VARCHAR2_TABLE_100

Line 101: , p3_a5 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
105: , p3_a9 JTF_NUMBER_TABLE

Line 105: , p3_a9 JTF_NUMBER_TABLE

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
107: , p3_a11 JTF_VARCHAR2_TABLE_100
108: , p3_a12 JTF_NUMBER_TABLE
109: , p3_a13 JTF_NUMBER_TABLE

Line 108: , p3_a12 JTF_NUMBER_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
112: , p3_a16 JTF_VARCHAR2_TABLE_100

Line 109: , p3_a13 JTF_NUMBER_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
112: , p3_a16 JTF_VARCHAR2_TABLE_100
113: , p3_a17 JTF_NUMBER_TABLE

Line 113: , p3_a17 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
117: , p3_a21 JTF_NUMBER_TABLE

Line 116: , p3_a20 JTF_NUMBER_TABLE

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
120: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 117: , p3_a21 JTF_NUMBER_TABLE

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
120: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
121: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 119: , p4_a0 out nocopy JTF_NUMBER_TABLE

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
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

Line 123: , p4_a4 out nocopy JTF_NUMBER_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
127: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 124: , p4_a5 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
127: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
128: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 126: , p4_a7 out nocopy JTF_NUMBER_TABLE

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
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

Line 130: , p4_a11 out nocopy JTF_NUMBER_TABLE

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
134: , x_return_status out nocopy VARCHAR2

Line 133: , p4_a14 out nocopy JTF_NUMBER_TABLE

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
137: );

Line 141: , p3_a0 in out nocopy JTF_NUMBER_TABLE

137: );
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

Line 145: , p3_a4 in out nocopy JTF_NUMBER_TABLE

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
149: , p3_a8 in out nocopy JTF_VARCHAR2_TABLE_100

Line 146: , p3_a5 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
149: , p3_a8 in out nocopy JTF_VARCHAR2_TABLE_100
150: , p3_a9 in out nocopy JTF_VARCHAR2_TABLE_100

Line 148: , p3_a7 in out nocopy JTF_NUMBER_TABLE

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
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

Line 152: , p3_a11 in out nocopy JTF_NUMBER_TABLE

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
156: , x_return_status out nocopy VARCHAR2

Line 155: , p3_a14 in out nocopy JTF_NUMBER_TABLE

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
159: );

Line 163: , p3_a0 JTF_NUMBER_TABLE

159: );
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

Line 167: , p3_a4 JTF_NUMBER_TABLE

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
171: , p3_a8 JTF_VARCHAR2_TABLE_100

Line 168: , p3_a5 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
171: , p3_a8 JTF_VARCHAR2_TABLE_100
172: , p3_a9 JTF_VARCHAR2_TABLE_100

Line 170: , p3_a7 JTF_NUMBER_TABLE

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
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

Line 174: , p3_a11 JTF_NUMBER_TABLE

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
178: , x_return_status out nocopy VARCHAR2

Line 177: , p3_a14 JTF_NUMBER_TABLE

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
181: );

Line 186: , p4_a0 out nocopy JTF_NUMBER_TABLE

182: procedure getfeeschedule(p_init_msg_list 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

Line 190: , p4_a4 out nocopy JTF_NUMBER_TABLE

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
194: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 191: , p4_a5 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
194: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
195: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 193: , p4_a7 out nocopy JTF_NUMBER_TABLE

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
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

Line 197: , p4_a11 out nocopy JTF_NUMBER_TABLE

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
201: , x_return_status out nocopy VARCHAR2

Line 200: , p4_a14 out nocopy JTF_NUMBER_TABLE

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: );

Line 209: , p3_a1 JTF_NUMBER_TABLE

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
213: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 212: , p6_a0 out nocopy JTF_NUMBER_TABLE

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
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

Line 216: , p6_a4 out nocopy JTF_NUMBER_TABLE

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
220: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 217: , p6_a5 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
220: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
221: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 219: , p6_a7 out nocopy JTF_NUMBER_TABLE

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
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

Line 223: , p6_a11 out nocopy JTF_NUMBER_TABLE

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
227: , x_return_status out nocopy VARCHAR2

Line 226: , p6_a14 out nocopy JTF_NUMBER_TABLE

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
230: );

Line 236: , p4_a1 JTF_NUMBER_TABLE

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
240: , p5_a3 JTF_VARCHAR2_TABLE_100

Line 237: , p5_a0 JTF_NUMBER_TABLE

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
240: , p5_a3 JTF_VARCHAR2_TABLE_100
241: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 242: , p5_a5 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
246: , p5_a9 JTF_NUMBER_TABLE

Line 246: , p5_a9 JTF_NUMBER_TABLE

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
248: , p5_a11 JTF_VARCHAR2_TABLE_100
249: , p5_a12 JTF_NUMBER_TABLE
250: , p5_a13 JTF_NUMBER_TABLE

Line 249: , p5_a12 JTF_NUMBER_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
253: , p5_a16 JTF_VARCHAR2_TABLE_100

Line 250: , p5_a13 JTF_NUMBER_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
253: , p5_a16 JTF_VARCHAR2_TABLE_100
254: , p5_a17 JTF_NUMBER_TABLE

Line 254: , p5_a17 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
258: , p5_a21 JTF_NUMBER_TABLE

Line 257: , p5_a20 JTF_NUMBER_TABLE

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
261: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 258: , p5_a21 JTF_NUMBER_TABLE

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
261: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
262: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 260: , p6_a0 out nocopy JTF_NUMBER_TABLE

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
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

Line 264: , p6_a4 out nocopy JTF_NUMBER_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
268: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 265: , p6_a5 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
268: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
269: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 267: , p6_a7 out nocopy JTF_NUMBER_TABLE

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
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

Line 271: , p6_a11 out nocopy JTF_NUMBER_TABLE

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
275: , x_return_status out nocopy VARCHAR2

Line 274: , p6_a14 out nocopy JTF_NUMBER_TABLE

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
278: );