APPS.LNS_FEE_ENGINE_W dependencies on JTF_VARCHAR2_TABLE_100

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy lns_fee_engine.fee_basis_tbl, a0 JTF_VARCHAR2_TABLE_100

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

Line 6: procedure rosetta_table_copy_out_p1(t lns_fee_engine.fee_basis_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 11: , a1 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
15: , a5 JTF_NUMBER_TABLE

Line 13: , a3 JTF_VARCHAR2_TABLE_100

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

Line 14: , a4 JTF_VARCHAR2_TABLE_100

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

Line 16: , a6 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
20: , a10 JTF_VARCHAR2_TABLE_100

Line 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

Line 21: , a11 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

Line 24: , a14 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

Line 25: , a15 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

Line 26: , a16 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

Line 28: , a18 JTF_VARCHAR2_TABLE_100

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

Line 29: , a19 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
33: , a23 JTF_VARCHAR2_TABLE_100

Line 33: , a23 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
36: , a1 out nocopy JTF_VARCHAR2_TABLE_100
37: , a2 out nocopy JTF_VARCHAR2_TABLE_300

Line 36: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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
40: , a5 out nocopy JTF_NUMBER_TABLE

Line 38: , a3 out nocopy 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
40: , a5 out nocopy JTF_NUMBER_TABLE
41: , a6 out nocopy JTF_VARCHAR2_TABLE_100
42: , a7 out nocopy JTF_DATE_TABLE

Line 39: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 41: , a6 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
45: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 45: , a10 out nocopy JTF_VARCHAR2_TABLE_100

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
49: , a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 46: , a11 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
49: , a14 out nocopy JTF_VARCHAR2_TABLE_100
50: , a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 49: , a14 out nocopy JTF_VARCHAR2_TABLE_100

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
53: , a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 50: , a15 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
53: , a18 out nocopy JTF_VARCHAR2_TABLE_100
54: , a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 51: , a16 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
53: , a18 out nocopy JTF_VARCHAR2_TABLE_100
54: , a19 out nocopy JTF_VARCHAR2_TABLE_100
55: , a20 out nocopy JTF_NUMBER_TABLE

Line 53: , a18 out nocopy JTF_VARCHAR2_TABLE_100

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
57: , a22 out nocopy JTF_DATE_TABLE

Line 54: , a19 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
57: , a22 out nocopy JTF_DATE_TABLE
58: , a23 out nocopy JTF_VARCHAR2_TABLE_100

Line 58: , a23 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:
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

Line 62: , a1 JTF_VARCHAR2_TABLE_100

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
66: , a5 JTF_NUMBER_TABLE

Line 63: , a2 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
66: , a5 JTF_NUMBER_TABLE
67: , a6 JTF_VARCHAR2_TABLE_300

Line 64: , a3 JTF_VARCHAR2_TABLE_100

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
66: , a5 JTF_NUMBER_TABLE
67: , a6 JTF_VARCHAR2_TABLE_300
68: , a7 JTF_NUMBER_TABLE

Line 69: , a8 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
73: , a12 JTF_VARCHAR2_TABLE_100

Line 70: , a9 JTF_VARCHAR2_TABLE_100

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
73: , a12 JTF_VARCHAR2_TABLE_100
74: , a13 JTF_VARCHAR2_TABLE_100

Line 71: , a10 JTF_VARCHAR2_TABLE_100

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
73: , a12 JTF_VARCHAR2_TABLE_100
74: , a13 JTF_VARCHAR2_TABLE_100
75: , a14 JTF_NUMBER_TABLE

Line 73: , a12 JTF_VARCHAR2_TABLE_100

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
77: , a16 JTF_VARCHAR2_TABLE_100

Line 74: , a13 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
77: , a16 JTF_VARCHAR2_TABLE_100
78: );

Line 76: , a15 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
80: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 77: , a16 JTF_VARCHAR2_TABLE_100

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
80: , a1 out nocopy JTF_VARCHAR2_TABLE_100
81: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 80: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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
84: , a5 out nocopy JTF_NUMBER_TABLE

Line 81: , a2 out nocopy 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
84: , a5 out nocopy JTF_NUMBER_TABLE
85: , a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 82: , a3 out nocopy 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
84: , a5 out nocopy JTF_NUMBER_TABLE
85: , a6 out nocopy JTF_VARCHAR2_TABLE_300
86: , a7 out nocopy JTF_NUMBER_TABLE

Line 87: , a8 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
91: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 88: , a9 out nocopy JTF_VARCHAR2_TABLE_100

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
91: , a12 out nocopy JTF_VARCHAR2_TABLE_100
92: , a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 89: , a10 out nocopy JTF_VARCHAR2_TABLE_100

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
91: , a12 out nocopy JTF_VARCHAR2_TABLE_100
92: , a13 out nocopy JTF_VARCHAR2_TABLE_100
93: , a14 out nocopy JTF_NUMBER_TABLE

Line 91: , a12 out nocopy JTF_VARCHAR2_TABLE_100

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
95: , a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 92: , a13 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
95: , a16 out nocopy JTF_VARCHAR2_TABLE_100
96: );

Line 94: , a15 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:
98: procedure calculatefees(p_loan_id NUMBER

Line 95: , a16 out nocopy JTF_VARCHAR2_TABLE_100

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:
98: procedure calculatefees(p_loan_id NUMBER
99: , p1_a0 JTF_VARCHAR2_TABLE_100

Line 99: , p1_a0 JTF_VARCHAR2_TABLE_100

95: , a16 out nocopy JTF_VARCHAR2_TABLE_100
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

Line 103: , p3_a1 JTF_VARCHAR2_TABLE_100

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
107: , p3_a5 JTF_NUMBER_TABLE

Line 105: , p3_a3 JTF_VARCHAR2_TABLE_100

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
107: , p3_a5 JTF_NUMBER_TABLE
108: , p3_a6 JTF_VARCHAR2_TABLE_100
109: , p3_a7 JTF_DATE_TABLE

Line 106: , p3_a4 JTF_VARCHAR2_TABLE_100

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

Line 108: , p3_a6 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
112: , p3_a10 JTF_VARCHAR2_TABLE_100

Line 112: , p3_a10 JTF_VARCHAR2_TABLE_100

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
116: , p3_a14 JTF_VARCHAR2_TABLE_100

Line 113: , p3_a11 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
116: , p3_a14 JTF_VARCHAR2_TABLE_100
117: , p3_a15 JTF_VARCHAR2_TABLE_100

Line 116: , p3_a14 JTF_VARCHAR2_TABLE_100

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
120: , p3_a18 JTF_VARCHAR2_TABLE_100

Line 117: , p3_a15 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
120: , p3_a18 JTF_VARCHAR2_TABLE_100
121: , p3_a19 JTF_VARCHAR2_TABLE_100

Line 118: , p3_a16 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
120: , p3_a18 JTF_VARCHAR2_TABLE_100
121: , p3_a19 JTF_VARCHAR2_TABLE_100
122: , p3_a20 JTF_NUMBER_TABLE

Line 120: , p3_a18 JTF_VARCHAR2_TABLE_100

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
124: , p3_a22 JTF_DATE_TABLE

Line 121: , p3_a19 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
124: , p3_a22 JTF_DATE_TABLE
125: , p3_a23 JTF_VARCHAR2_TABLE_100

Line 125: , p3_a23 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
128: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
129: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 127: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100

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
131: , p4_a5 out nocopy JTF_NUMBER_TABLE

Line 128: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100

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
131: , p4_a5 out nocopy JTF_NUMBER_TABLE
132: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 129: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 134: , p4_a8 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
138: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 135: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100

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
138: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
139: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 136: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 138: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100

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
142: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 139: , p4_a13 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
142: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
143: , x_return_status out nocopy VARCHAR2

Line 141: , p4_a15 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
145: , x_msg_data out nocopy VARCHAR2

Line 142: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100

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
145: , x_msg_data out nocopy VARCHAR2
146: );

Line 151: , p3_a1 in out nocopy JTF_VARCHAR2_TABLE_100

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
155: , p3_a5 in out nocopy JTF_NUMBER_TABLE

Line 152: , p3_a2 in out nocopy JTF_VARCHAR2_TABLE_100

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
155: , p3_a5 in out nocopy JTF_NUMBER_TABLE
156: , p3_a6 in out nocopy JTF_VARCHAR2_TABLE_300

Line 153: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100

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

Line 158: , p3_a8 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
162: , p3_a12 in out nocopy JTF_VARCHAR2_TABLE_100

Line 159: , p3_a9 in out nocopy JTF_VARCHAR2_TABLE_100

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
162: , p3_a12 in out nocopy JTF_VARCHAR2_TABLE_100
163: , p3_a13 in out nocopy JTF_VARCHAR2_TABLE_100

Line 160: , p3_a10 in out nocopy JTF_VARCHAR2_TABLE_100

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

Line 162: , p3_a12 in out nocopy JTF_VARCHAR2_TABLE_100

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
166: , p3_a16 in out nocopy JTF_VARCHAR2_TABLE_100

Line 163: , p3_a13 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
166: , p3_a16 in out nocopy JTF_VARCHAR2_TABLE_100
167: , x_return_status out nocopy VARCHAR2

Line 165: , p3_a15 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
169: , x_msg_data out nocopy VARCHAR2

Line 166: , p3_a16 in out nocopy JTF_VARCHAR2_TABLE_100

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
169: , x_msg_data out nocopy VARCHAR2
170: );

Line 175: , p3_a1 JTF_VARCHAR2_TABLE_100

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
179: , p3_a5 JTF_NUMBER_TABLE

Line 176: , p3_a2 JTF_VARCHAR2_TABLE_100

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
179: , p3_a5 JTF_NUMBER_TABLE
180: , p3_a6 JTF_VARCHAR2_TABLE_300

Line 177: , p3_a3 JTF_VARCHAR2_TABLE_100

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
179: , p3_a5 JTF_NUMBER_TABLE
180: , p3_a6 JTF_VARCHAR2_TABLE_300
181: , p3_a7 JTF_NUMBER_TABLE

Line 182: , p3_a8 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
186: , p3_a12 JTF_VARCHAR2_TABLE_100

Line 183: , p3_a9 JTF_VARCHAR2_TABLE_100

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
186: , p3_a12 JTF_VARCHAR2_TABLE_100
187: , p3_a13 JTF_VARCHAR2_TABLE_100

Line 184: , p3_a10 JTF_VARCHAR2_TABLE_100

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
186: , p3_a12 JTF_VARCHAR2_TABLE_100
187: , p3_a13 JTF_VARCHAR2_TABLE_100
188: , p3_a14 JTF_NUMBER_TABLE

Line 186: , p3_a12 JTF_VARCHAR2_TABLE_100

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
190: , p3_a16 JTF_VARCHAR2_TABLE_100

Line 187: , p3_a13 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
190: , p3_a16 JTF_VARCHAR2_TABLE_100
191: , x_return_status out nocopy VARCHAR2

Line 189: , p3_a15 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
193: , x_msg_data out nocopy VARCHAR2

Line 190: , p3_a16 JTF_VARCHAR2_TABLE_100

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
193: , x_msg_data out nocopy VARCHAR2
194: );

Line 201: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100

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
205: , p5_a5 out nocopy JTF_NUMBER_TABLE

Line 202: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100

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
205: , p5_a5 out nocopy JTF_NUMBER_TABLE
206: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 203: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 208: , p5_a8 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
212: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 209: , p5_a9 out nocopy JTF_VARCHAR2_TABLE_100

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
212: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
213: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 210: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 212: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100

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
216: , p5_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 213: , p5_a13 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
216: , p5_a16 out nocopy JTF_VARCHAR2_TABLE_100
217: , x_return_status out nocopy VARCHAR2

Line 215: , p5_a15 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
219: , x_msg_data out nocopy VARCHAR2

Line 216: , p5_a16 out nocopy JTF_VARCHAR2_TABLE_100

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
219: , x_msg_data out nocopy VARCHAR2
220: );

Line 224: , p3_a0 JTF_VARCHAR2_TABLE_100

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

Line 229: , p6_a1 out nocopy 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
233: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 230: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

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
233: , p6_a5 out nocopy JTF_NUMBER_TABLE
234: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 231: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 236: , p6_a8 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
240: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 237: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

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
240: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
241: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 238: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 240: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100

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
244: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 241: , p6_a13 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
244: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
245: , x_return_status out nocopy VARCHAR2

Line 243: , p6_a15 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
247: , x_msg_data out nocopy VARCHAR2

Line 244: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100

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
247: , x_msg_data out nocopy VARCHAR2
248: );

Line 253: , p4_a0 JTF_VARCHAR2_TABLE_100

249: procedure processfees(p_init_msg_list VARCHAR2
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

Line 256: , p5_a1 JTF_VARCHAR2_TABLE_100

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
260: , p5_a5 JTF_NUMBER_TABLE

Line 258: , p5_a3 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
260: , p5_a5 JTF_NUMBER_TABLE
261: , p5_a6 JTF_VARCHAR2_TABLE_100
262: , p5_a7 JTF_DATE_TABLE

Line 259: , p5_a4 JTF_VARCHAR2_TABLE_100

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

Line 261: , p5_a6 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
265: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 265: , p5_a10 JTF_VARCHAR2_TABLE_100

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
269: , p5_a14 JTF_VARCHAR2_TABLE_100

Line 266: , p5_a11 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
269: , p5_a14 JTF_VARCHAR2_TABLE_100
270: , p5_a15 JTF_VARCHAR2_TABLE_100

Line 269: , p5_a14 JTF_VARCHAR2_TABLE_100

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
273: , p5_a18 JTF_VARCHAR2_TABLE_100

Line 270: , p5_a15 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
273: , p5_a18 JTF_VARCHAR2_TABLE_100
274: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 271: , p5_a16 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
273: , p5_a18 JTF_VARCHAR2_TABLE_100
274: , p5_a19 JTF_VARCHAR2_TABLE_100
275: , p5_a20 JTF_NUMBER_TABLE

Line 273: , p5_a18 JTF_VARCHAR2_TABLE_100

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
277: , p5_a22 JTF_DATE_TABLE

Line 274: , p5_a19 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
277: , p5_a22 JTF_DATE_TABLE
278: , p5_a23 JTF_VARCHAR2_TABLE_100

Line 278: , p5_a23 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
281: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
282: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 280: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

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
284: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 281: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

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
284: , p6_a5 out nocopy JTF_NUMBER_TABLE
285: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 282: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 287: , p6_a8 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
291: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 288: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

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
291: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
292: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 289: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 291: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100

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
295: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 292: , p6_a13 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
295: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
296: , x_return_status out nocopy VARCHAR2

Line 294: , p6_a15 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
298: , x_msg_data out nocopy VARCHAR2

Line 295: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100

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
298: , x_msg_data out nocopy VARCHAR2
299: );

Line 304: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100

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
308: , p3_a5 out nocopy JTF_NUMBER_TABLE

Line 305: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100

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
308: , p3_a5 out nocopy JTF_NUMBER_TABLE
309: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 306: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 311: , p3_a8 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
315: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 312: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100

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
315: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
316: , p3_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 313: , p3_a10 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 315: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100

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
319: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 316: , p3_a13 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
319: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_100
320: , x_return_status out nocopy VARCHAR2

Line 318: , p3_a15 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
322: , x_msg_data out nocopy VARCHAR2

Line 319: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_100

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
322: , x_msg_data out nocopy VARCHAR2
323: );