DBA Data[Home] [Help]

APPS.LNS_DISTRIBUTIONS_PUB_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy lns_distributions_pub.distribution_tbl, a0 JTF_NUMBER_TABLE

1: package body lns_distributions_pub_w as
2: /* $Header: LNS_DIST_PUBJ_B.pls 120.6.12020000.2 2012/07/19 20:55:00 scherkas ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy lns_distributions_pub.distribution_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE

Line 4: , a1 JTF_NUMBER_TABLE

1: package body lns_distributions_pub_w as
2: /* $Header: LNS_DIST_PUBJ_B.pls 120.6.12020000.2 2012/07/19 20:55:00 scherkas ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy lns_distributions_pub.distribution_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100

Line 7: , a4 JTF_NUMBER_TABLE

3: procedure rosetta_table_copy_in_p1(t out nocopy lns_distributions_pub.distribution_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100

Line 9: , a6 JTF_NUMBER_TABLE

5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE

Line 10: , a7 JTF_NUMBER_TABLE

6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE

Line 13: , a10 JTF_NUMBER_TABLE

9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100

Line 14: , a11 JTF_NUMBER_TABLE

10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_DATE_TABLE

Line 15: , a12 JTF_NUMBER_TABLE

11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_DATE_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100

Line 16: , a13 JTF_NUMBER_TABLE

12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_DATE_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100

Line 56: procedure rosetta_table_copy_out_p1(t lns_distributions_pub.distribution_tbl, a0 out nocopy JTF_NUMBER_TABLE

52: end loop;
53: end if;
54: end if;
55: end rosetta_table_copy_in_p1;
56: procedure rosetta_table_copy_out_p1(t lns_distributions_pub.distribution_tbl, a0 out nocopy JTF_NUMBER_TABLE
57: , a1 out nocopy JTF_NUMBER_TABLE
58: , a2 out nocopy JTF_VARCHAR2_TABLE_100
59: , a3 out nocopy JTF_VARCHAR2_TABLE_100
60: , a4 out nocopy JTF_NUMBER_TABLE

Line 57: , a1 out nocopy JTF_NUMBER_TABLE

53: end if;
54: end if;
55: end rosetta_table_copy_in_p1;
56: procedure rosetta_table_copy_out_p1(t lns_distributions_pub.distribution_tbl, a0 out nocopy JTF_NUMBER_TABLE
57: , a1 out nocopy JTF_NUMBER_TABLE
58: , a2 out nocopy JTF_VARCHAR2_TABLE_100
59: , a3 out nocopy JTF_VARCHAR2_TABLE_100
60: , a4 out nocopy JTF_NUMBER_TABLE
61: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 60: , a4 out nocopy JTF_NUMBER_TABLE

56: procedure rosetta_table_copy_out_p1(t lns_distributions_pub.distribution_tbl, a0 out nocopy JTF_NUMBER_TABLE
57: , a1 out nocopy JTF_NUMBER_TABLE
58: , a2 out nocopy JTF_VARCHAR2_TABLE_100
59: , a3 out nocopy JTF_VARCHAR2_TABLE_100
60: , a4 out nocopy JTF_NUMBER_TABLE
61: , a5 out nocopy JTF_VARCHAR2_TABLE_100
62: , a6 out nocopy JTF_NUMBER_TABLE
63: , a7 out nocopy JTF_NUMBER_TABLE
64: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 62: , a6 out nocopy JTF_NUMBER_TABLE

58: , a2 out nocopy JTF_VARCHAR2_TABLE_100
59: , a3 out nocopy JTF_VARCHAR2_TABLE_100
60: , a4 out nocopy JTF_NUMBER_TABLE
61: , a5 out nocopy JTF_VARCHAR2_TABLE_100
62: , a6 out nocopy JTF_NUMBER_TABLE
63: , a7 out nocopy JTF_NUMBER_TABLE
64: , a8 out nocopy JTF_VARCHAR2_TABLE_100
65: , a9 out nocopy JTF_VARCHAR2_TABLE_100
66: , a10 out nocopy JTF_NUMBER_TABLE

Line 63: , a7 out nocopy JTF_NUMBER_TABLE

59: , a3 out nocopy JTF_VARCHAR2_TABLE_100
60: , a4 out nocopy JTF_NUMBER_TABLE
61: , a5 out nocopy JTF_VARCHAR2_TABLE_100
62: , a6 out nocopy JTF_NUMBER_TABLE
63: , a7 out nocopy JTF_NUMBER_TABLE
64: , a8 out nocopy JTF_VARCHAR2_TABLE_100
65: , a9 out nocopy JTF_VARCHAR2_TABLE_100
66: , a10 out nocopy JTF_NUMBER_TABLE
67: , a11 out nocopy JTF_NUMBER_TABLE

Line 66: , a10 out nocopy JTF_NUMBER_TABLE

62: , a6 out nocopy JTF_NUMBER_TABLE
63: , a7 out nocopy JTF_NUMBER_TABLE
64: , a8 out nocopy JTF_VARCHAR2_TABLE_100
65: , a9 out nocopy JTF_VARCHAR2_TABLE_100
66: , a10 out nocopy JTF_NUMBER_TABLE
67: , a11 out nocopy JTF_NUMBER_TABLE
68: , a12 out nocopy JTF_NUMBER_TABLE
69: , a13 out nocopy JTF_NUMBER_TABLE
70: , a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 67: , a11 out nocopy JTF_NUMBER_TABLE

63: , a7 out nocopy JTF_NUMBER_TABLE
64: , a8 out nocopy JTF_VARCHAR2_TABLE_100
65: , a9 out nocopy JTF_VARCHAR2_TABLE_100
66: , a10 out nocopy JTF_NUMBER_TABLE
67: , a11 out nocopy JTF_NUMBER_TABLE
68: , a12 out nocopy JTF_NUMBER_TABLE
69: , a13 out nocopy JTF_NUMBER_TABLE
70: , a14 out nocopy JTF_VARCHAR2_TABLE_100
71: , a15 out nocopy JTF_DATE_TABLE

Line 68: , a12 out nocopy JTF_NUMBER_TABLE

64: , a8 out nocopy JTF_VARCHAR2_TABLE_100
65: , a9 out nocopy JTF_VARCHAR2_TABLE_100
66: , a10 out nocopy JTF_NUMBER_TABLE
67: , a11 out nocopy JTF_NUMBER_TABLE
68: , a12 out nocopy JTF_NUMBER_TABLE
69: , a13 out nocopy JTF_NUMBER_TABLE
70: , a14 out nocopy JTF_VARCHAR2_TABLE_100
71: , a15 out nocopy JTF_DATE_TABLE
72: , a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 69: , a13 out nocopy JTF_NUMBER_TABLE

65: , a9 out nocopy JTF_VARCHAR2_TABLE_100
66: , a10 out nocopy JTF_NUMBER_TABLE
67: , a11 out nocopy JTF_NUMBER_TABLE
68: , a12 out nocopy JTF_NUMBER_TABLE
69: , a13 out nocopy JTF_NUMBER_TABLE
70: , a14 out nocopy JTF_VARCHAR2_TABLE_100
71: , a15 out nocopy JTF_DATE_TABLE
72: , a16 out nocopy JTF_VARCHAR2_TABLE_100
73: , a17 out nocopy JTF_VARCHAR2_TABLE_100

Line 78: a0 := JTF_NUMBER_TABLE();

74: ) as
75: ddindx binary_integer; indx binary_integer;
76: begin
77: if t is null or t.count = 0 then
78: a0 := JTF_NUMBER_TABLE();
79: a1 := JTF_NUMBER_TABLE();
80: a2 := JTF_VARCHAR2_TABLE_100();
81: a3 := JTF_VARCHAR2_TABLE_100();
82: a4 := JTF_NUMBER_TABLE();

Line 79: a1 := JTF_NUMBER_TABLE();

75: ddindx binary_integer; indx binary_integer;
76: begin
77: if t is null or t.count = 0 then
78: a0 := JTF_NUMBER_TABLE();
79: a1 := JTF_NUMBER_TABLE();
80: a2 := JTF_VARCHAR2_TABLE_100();
81: a3 := JTF_VARCHAR2_TABLE_100();
82: a4 := JTF_NUMBER_TABLE();
83: a5 := JTF_VARCHAR2_TABLE_100();

Line 82: a4 := JTF_NUMBER_TABLE();

78: a0 := JTF_NUMBER_TABLE();
79: a1 := JTF_NUMBER_TABLE();
80: a2 := JTF_VARCHAR2_TABLE_100();
81: a3 := JTF_VARCHAR2_TABLE_100();
82: a4 := JTF_NUMBER_TABLE();
83: a5 := JTF_VARCHAR2_TABLE_100();
84: a6 := JTF_NUMBER_TABLE();
85: a7 := JTF_NUMBER_TABLE();
86: a8 := JTF_VARCHAR2_TABLE_100();

Line 84: a6 := JTF_NUMBER_TABLE();

80: a2 := JTF_VARCHAR2_TABLE_100();
81: a3 := JTF_VARCHAR2_TABLE_100();
82: a4 := JTF_NUMBER_TABLE();
83: a5 := JTF_VARCHAR2_TABLE_100();
84: a6 := JTF_NUMBER_TABLE();
85: a7 := JTF_NUMBER_TABLE();
86: a8 := JTF_VARCHAR2_TABLE_100();
87: a9 := JTF_VARCHAR2_TABLE_100();
88: a10 := JTF_NUMBER_TABLE();

Line 85: a7 := JTF_NUMBER_TABLE();

81: a3 := JTF_VARCHAR2_TABLE_100();
82: a4 := JTF_NUMBER_TABLE();
83: a5 := JTF_VARCHAR2_TABLE_100();
84: a6 := JTF_NUMBER_TABLE();
85: a7 := JTF_NUMBER_TABLE();
86: a8 := JTF_VARCHAR2_TABLE_100();
87: a9 := JTF_VARCHAR2_TABLE_100();
88: a10 := JTF_NUMBER_TABLE();
89: a11 := JTF_NUMBER_TABLE();

Line 88: a10 := JTF_NUMBER_TABLE();

84: a6 := JTF_NUMBER_TABLE();
85: a7 := JTF_NUMBER_TABLE();
86: a8 := JTF_VARCHAR2_TABLE_100();
87: a9 := JTF_VARCHAR2_TABLE_100();
88: a10 := JTF_NUMBER_TABLE();
89: a11 := JTF_NUMBER_TABLE();
90: a12 := JTF_NUMBER_TABLE();
91: a13 := JTF_NUMBER_TABLE();
92: a14 := JTF_VARCHAR2_TABLE_100();

Line 89: a11 := JTF_NUMBER_TABLE();

85: a7 := JTF_NUMBER_TABLE();
86: a8 := JTF_VARCHAR2_TABLE_100();
87: a9 := JTF_VARCHAR2_TABLE_100();
88: a10 := JTF_NUMBER_TABLE();
89: a11 := JTF_NUMBER_TABLE();
90: a12 := JTF_NUMBER_TABLE();
91: a13 := JTF_NUMBER_TABLE();
92: a14 := JTF_VARCHAR2_TABLE_100();
93: a15 := JTF_DATE_TABLE();

Line 90: a12 := JTF_NUMBER_TABLE();

86: a8 := JTF_VARCHAR2_TABLE_100();
87: a9 := JTF_VARCHAR2_TABLE_100();
88: a10 := JTF_NUMBER_TABLE();
89: a11 := JTF_NUMBER_TABLE();
90: a12 := JTF_NUMBER_TABLE();
91: a13 := JTF_NUMBER_TABLE();
92: a14 := JTF_VARCHAR2_TABLE_100();
93: a15 := JTF_DATE_TABLE();
94: a16 := JTF_VARCHAR2_TABLE_100();

Line 91: a13 := JTF_NUMBER_TABLE();

87: a9 := JTF_VARCHAR2_TABLE_100();
88: a10 := JTF_NUMBER_TABLE();
89: a11 := JTF_NUMBER_TABLE();
90: a12 := JTF_NUMBER_TABLE();
91: a13 := JTF_NUMBER_TABLE();
92: a14 := JTF_VARCHAR2_TABLE_100();
93: a15 := JTF_DATE_TABLE();
94: a16 := JTF_VARCHAR2_TABLE_100();
95: a17 := JTF_VARCHAR2_TABLE_100();

Line 97: a0 := JTF_NUMBER_TABLE();

93: a15 := JTF_DATE_TABLE();
94: a16 := JTF_VARCHAR2_TABLE_100();
95: a17 := JTF_VARCHAR2_TABLE_100();
96: else
97: a0 := JTF_NUMBER_TABLE();
98: a1 := JTF_NUMBER_TABLE();
99: a2 := JTF_VARCHAR2_TABLE_100();
100: a3 := JTF_VARCHAR2_TABLE_100();
101: a4 := JTF_NUMBER_TABLE();

Line 98: a1 := JTF_NUMBER_TABLE();

94: a16 := JTF_VARCHAR2_TABLE_100();
95: a17 := JTF_VARCHAR2_TABLE_100();
96: else
97: a0 := JTF_NUMBER_TABLE();
98: a1 := JTF_NUMBER_TABLE();
99: a2 := JTF_VARCHAR2_TABLE_100();
100: a3 := JTF_VARCHAR2_TABLE_100();
101: a4 := JTF_NUMBER_TABLE();
102: a5 := JTF_VARCHAR2_TABLE_100();

Line 101: a4 := JTF_NUMBER_TABLE();

97: a0 := JTF_NUMBER_TABLE();
98: a1 := JTF_NUMBER_TABLE();
99: a2 := JTF_VARCHAR2_TABLE_100();
100: a3 := JTF_VARCHAR2_TABLE_100();
101: a4 := JTF_NUMBER_TABLE();
102: a5 := JTF_VARCHAR2_TABLE_100();
103: a6 := JTF_NUMBER_TABLE();
104: a7 := JTF_NUMBER_TABLE();
105: a8 := JTF_VARCHAR2_TABLE_100();

Line 103: a6 := JTF_NUMBER_TABLE();

99: a2 := JTF_VARCHAR2_TABLE_100();
100: a3 := JTF_VARCHAR2_TABLE_100();
101: a4 := JTF_NUMBER_TABLE();
102: a5 := JTF_VARCHAR2_TABLE_100();
103: a6 := JTF_NUMBER_TABLE();
104: a7 := JTF_NUMBER_TABLE();
105: a8 := JTF_VARCHAR2_TABLE_100();
106: a9 := JTF_VARCHAR2_TABLE_100();
107: a10 := JTF_NUMBER_TABLE();

Line 104: a7 := JTF_NUMBER_TABLE();

100: a3 := JTF_VARCHAR2_TABLE_100();
101: a4 := JTF_NUMBER_TABLE();
102: a5 := JTF_VARCHAR2_TABLE_100();
103: a6 := JTF_NUMBER_TABLE();
104: a7 := JTF_NUMBER_TABLE();
105: a8 := JTF_VARCHAR2_TABLE_100();
106: a9 := JTF_VARCHAR2_TABLE_100();
107: a10 := JTF_NUMBER_TABLE();
108: a11 := JTF_NUMBER_TABLE();

Line 107: a10 := JTF_NUMBER_TABLE();

103: a6 := JTF_NUMBER_TABLE();
104: a7 := JTF_NUMBER_TABLE();
105: a8 := JTF_VARCHAR2_TABLE_100();
106: a9 := JTF_VARCHAR2_TABLE_100();
107: a10 := JTF_NUMBER_TABLE();
108: a11 := JTF_NUMBER_TABLE();
109: a12 := JTF_NUMBER_TABLE();
110: a13 := JTF_NUMBER_TABLE();
111: a14 := JTF_VARCHAR2_TABLE_100();

Line 108: a11 := JTF_NUMBER_TABLE();

104: a7 := JTF_NUMBER_TABLE();
105: a8 := JTF_VARCHAR2_TABLE_100();
106: a9 := JTF_VARCHAR2_TABLE_100();
107: a10 := JTF_NUMBER_TABLE();
108: a11 := JTF_NUMBER_TABLE();
109: a12 := JTF_NUMBER_TABLE();
110: a13 := JTF_NUMBER_TABLE();
111: a14 := JTF_VARCHAR2_TABLE_100();
112: a15 := JTF_DATE_TABLE();

Line 109: a12 := JTF_NUMBER_TABLE();

105: a8 := JTF_VARCHAR2_TABLE_100();
106: a9 := JTF_VARCHAR2_TABLE_100();
107: a10 := JTF_NUMBER_TABLE();
108: a11 := JTF_NUMBER_TABLE();
109: a12 := JTF_NUMBER_TABLE();
110: a13 := JTF_NUMBER_TABLE();
111: a14 := JTF_VARCHAR2_TABLE_100();
112: a15 := JTF_DATE_TABLE();
113: a16 := JTF_VARCHAR2_TABLE_100();

Line 110: a13 := JTF_NUMBER_TABLE();

106: a9 := JTF_VARCHAR2_TABLE_100();
107: a10 := JTF_NUMBER_TABLE();
108: a11 := JTF_NUMBER_TABLE();
109: a12 := JTF_NUMBER_TABLE();
110: a13 := JTF_NUMBER_TABLE();
111: a14 := JTF_VARCHAR2_TABLE_100();
112: a15 := JTF_DATE_TABLE();
113: a16 := JTF_VARCHAR2_TABLE_100();
114: a17 := JTF_VARCHAR2_TABLE_100();

Line 169: , a4 JTF_NUMBER_TABLE

165: procedure rosetta_table_copy_in_p3(t out nocopy lns_distributions_pub.default_distributions_tbl, a0 JTF_VARCHAR2_TABLE_100
166: , a1 JTF_VARCHAR2_TABLE_100
167: , a2 JTF_VARCHAR2_TABLE_100
168: , a3 JTF_VARCHAR2_TABLE_100
169: , a4 JTF_NUMBER_TABLE
170: , a5 JTF_VARCHAR2_TABLE_100
171: , a6 JTF_NUMBER_TABLE
172: , a7 JTF_VARCHAR2_TABLE_100
173: , a8 JTF_NUMBER_TABLE

Line 171: , a6 JTF_NUMBER_TABLE

167: , a2 JTF_VARCHAR2_TABLE_100
168: , a3 JTF_VARCHAR2_TABLE_100
169: , a4 JTF_NUMBER_TABLE
170: , a5 JTF_VARCHAR2_TABLE_100
171: , a6 JTF_NUMBER_TABLE
172: , a7 JTF_VARCHAR2_TABLE_100
173: , a8 JTF_NUMBER_TABLE
174: , a9 JTF_NUMBER_TABLE
175: , a10 JTF_VARCHAR2_TABLE_100

Line 173: , a8 JTF_NUMBER_TABLE

169: , a4 JTF_NUMBER_TABLE
170: , a5 JTF_VARCHAR2_TABLE_100
171: , a6 JTF_NUMBER_TABLE
172: , a7 JTF_VARCHAR2_TABLE_100
173: , a8 JTF_NUMBER_TABLE
174: , a9 JTF_NUMBER_TABLE
175: , a10 JTF_VARCHAR2_TABLE_100
176: , a11 JTF_VARCHAR2_TABLE_100
177: , a12 JTF_VARCHAR2_TABLE_100

Line 174: , a9 JTF_NUMBER_TABLE

170: , a5 JTF_VARCHAR2_TABLE_100
171: , a6 JTF_NUMBER_TABLE
172: , a7 JTF_VARCHAR2_TABLE_100
173: , a8 JTF_NUMBER_TABLE
174: , a9 JTF_NUMBER_TABLE
175: , a10 JTF_VARCHAR2_TABLE_100
176: , a11 JTF_VARCHAR2_TABLE_100
177: , a12 JTF_VARCHAR2_TABLE_100
178: ) as

Line 212: , a4 out nocopy JTF_NUMBER_TABLE

208: procedure rosetta_table_copy_out_p3(t lns_distributions_pub.default_distributions_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
209: , a1 out nocopy JTF_VARCHAR2_TABLE_100
210: , a2 out nocopy JTF_VARCHAR2_TABLE_100
211: , a3 out nocopy JTF_VARCHAR2_TABLE_100
212: , a4 out nocopy JTF_NUMBER_TABLE
213: , a5 out nocopy JTF_VARCHAR2_TABLE_100
214: , a6 out nocopy JTF_NUMBER_TABLE
215: , a7 out nocopy JTF_VARCHAR2_TABLE_100
216: , a8 out nocopy JTF_NUMBER_TABLE

Line 214: , a6 out nocopy JTF_NUMBER_TABLE

210: , a2 out nocopy JTF_VARCHAR2_TABLE_100
211: , a3 out nocopy JTF_VARCHAR2_TABLE_100
212: , a4 out nocopy JTF_NUMBER_TABLE
213: , a5 out nocopy JTF_VARCHAR2_TABLE_100
214: , a6 out nocopy JTF_NUMBER_TABLE
215: , a7 out nocopy JTF_VARCHAR2_TABLE_100
216: , a8 out nocopy JTF_NUMBER_TABLE
217: , a9 out nocopy JTF_NUMBER_TABLE
218: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 216: , a8 out nocopy JTF_NUMBER_TABLE

212: , a4 out nocopy JTF_NUMBER_TABLE
213: , a5 out nocopy JTF_VARCHAR2_TABLE_100
214: , a6 out nocopy JTF_NUMBER_TABLE
215: , a7 out nocopy JTF_VARCHAR2_TABLE_100
216: , a8 out nocopy JTF_NUMBER_TABLE
217: , a9 out nocopy JTF_NUMBER_TABLE
218: , a10 out nocopy JTF_VARCHAR2_TABLE_100
219: , a11 out nocopy JTF_VARCHAR2_TABLE_100
220: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 217: , a9 out nocopy JTF_NUMBER_TABLE

213: , a5 out nocopy JTF_VARCHAR2_TABLE_100
214: , a6 out nocopy JTF_NUMBER_TABLE
215: , a7 out nocopy JTF_VARCHAR2_TABLE_100
216: , a8 out nocopy JTF_NUMBER_TABLE
217: , a9 out nocopy JTF_NUMBER_TABLE
218: , a10 out nocopy JTF_VARCHAR2_TABLE_100
219: , a11 out nocopy JTF_VARCHAR2_TABLE_100
220: , a12 out nocopy JTF_VARCHAR2_TABLE_100
221: ) as

Line 229: a4 := JTF_NUMBER_TABLE();

225: a0 := JTF_VARCHAR2_TABLE_100();
226: a1 := JTF_VARCHAR2_TABLE_100();
227: a2 := JTF_VARCHAR2_TABLE_100();
228: a3 := JTF_VARCHAR2_TABLE_100();
229: a4 := JTF_NUMBER_TABLE();
230: a5 := JTF_VARCHAR2_TABLE_100();
231: a6 := JTF_NUMBER_TABLE();
232: a7 := JTF_VARCHAR2_TABLE_100();
233: a8 := JTF_NUMBER_TABLE();

Line 231: a6 := JTF_NUMBER_TABLE();

227: a2 := JTF_VARCHAR2_TABLE_100();
228: a3 := JTF_VARCHAR2_TABLE_100();
229: a4 := JTF_NUMBER_TABLE();
230: a5 := JTF_VARCHAR2_TABLE_100();
231: a6 := JTF_NUMBER_TABLE();
232: a7 := JTF_VARCHAR2_TABLE_100();
233: a8 := JTF_NUMBER_TABLE();
234: a9 := JTF_NUMBER_TABLE();
235: a10 := JTF_VARCHAR2_TABLE_100();

Line 233: a8 := JTF_NUMBER_TABLE();

229: a4 := JTF_NUMBER_TABLE();
230: a5 := JTF_VARCHAR2_TABLE_100();
231: a6 := JTF_NUMBER_TABLE();
232: a7 := JTF_VARCHAR2_TABLE_100();
233: a8 := JTF_NUMBER_TABLE();
234: a9 := JTF_NUMBER_TABLE();
235: a10 := JTF_VARCHAR2_TABLE_100();
236: a11 := JTF_VARCHAR2_TABLE_100();
237: a12 := JTF_VARCHAR2_TABLE_100();

Line 234: a9 := JTF_NUMBER_TABLE();

230: a5 := JTF_VARCHAR2_TABLE_100();
231: a6 := JTF_NUMBER_TABLE();
232: a7 := JTF_VARCHAR2_TABLE_100();
233: a8 := JTF_NUMBER_TABLE();
234: a9 := JTF_NUMBER_TABLE();
235: a10 := JTF_VARCHAR2_TABLE_100();
236: a11 := JTF_VARCHAR2_TABLE_100();
237: a12 := JTF_VARCHAR2_TABLE_100();
238: else

Line 243: a4 := JTF_NUMBER_TABLE();

239: a0 := JTF_VARCHAR2_TABLE_100();
240: a1 := JTF_VARCHAR2_TABLE_100();
241: a2 := JTF_VARCHAR2_TABLE_100();
242: a3 := JTF_VARCHAR2_TABLE_100();
243: a4 := JTF_NUMBER_TABLE();
244: a5 := JTF_VARCHAR2_TABLE_100();
245: a6 := JTF_NUMBER_TABLE();
246: a7 := JTF_VARCHAR2_TABLE_100();
247: a8 := JTF_NUMBER_TABLE();

Line 245: a6 := JTF_NUMBER_TABLE();

241: a2 := JTF_VARCHAR2_TABLE_100();
242: a3 := JTF_VARCHAR2_TABLE_100();
243: a4 := JTF_NUMBER_TABLE();
244: a5 := JTF_VARCHAR2_TABLE_100();
245: a6 := JTF_NUMBER_TABLE();
246: a7 := JTF_VARCHAR2_TABLE_100();
247: a8 := JTF_NUMBER_TABLE();
248: a9 := JTF_NUMBER_TABLE();
249: a10 := JTF_VARCHAR2_TABLE_100();

Line 247: a8 := JTF_NUMBER_TABLE();

243: a4 := JTF_NUMBER_TABLE();
244: a5 := JTF_VARCHAR2_TABLE_100();
245: a6 := JTF_NUMBER_TABLE();
246: a7 := JTF_VARCHAR2_TABLE_100();
247: a8 := JTF_NUMBER_TABLE();
248: a9 := JTF_NUMBER_TABLE();
249: a10 := JTF_VARCHAR2_TABLE_100();
250: a11 := JTF_VARCHAR2_TABLE_100();
251: a12 := JTF_VARCHAR2_TABLE_100();

Line 248: a9 := JTF_NUMBER_TABLE();

244: a5 := JTF_VARCHAR2_TABLE_100();
245: a6 := JTF_NUMBER_TABLE();
246: a7 := JTF_VARCHAR2_TABLE_100();
247: a8 := JTF_NUMBER_TABLE();
248: a9 := JTF_NUMBER_TABLE();
249: a10 := JTF_VARCHAR2_TABLE_100();
250: a11 := JTF_VARCHAR2_TABLE_100();
251: a12 := JTF_VARCHAR2_TABLE_100();
252: if t.count > 0 then

Line 292: procedure rosetta_table_copy_in_p5(t out nocopy lns_distributions_pub.acc_event_tbl, a0 JTF_NUMBER_TABLE

288: end if;
289: end if;
290: end rosetta_table_copy_out_p3;
291:
292: procedure rosetta_table_copy_in_p5(t out nocopy lns_distributions_pub.acc_event_tbl, a0 JTF_NUMBER_TABLE
293: , a1 JTF_VARCHAR2_TABLE_100
294: , a2 JTF_DATE_TABLE
295: , a3 JTF_VARCHAR2_TABLE_100
296: , a4 JTF_NUMBER_TABLE

Line 296: , a4 JTF_NUMBER_TABLE

292: procedure rosetta_table_copy_in_p5(t out nocopy lns_distributions_pub.acc_event_tbl, a0 JTF_NUMBER_TABLE
293: , a1 JTF_VARCHAR2_TABLE_100
294: , a2 JTF_DATE_TABLE
295: , a3 JTF_VARCHAR2_TABLE_100
296: , a4 JTF_NUMBER_TABLE
297: , a5 JTF_VARCHAR2_TABLE_100
298: , a6 JTF_NUMBER_TABLE
299: , a7 JTF_NUMBER_TABLE
300: ) as

Line 298: , a6 JTF_NUMBER_TABLE

294: , a2 JTF_DATE_TABLE
295: , a3 JTF_VARCHAR2_TABLE_100
296: , a4 JTF_NUMBER_TABLE
297: , a5 JTF_VARCHAR2_TABLE_100
298: , a6 JTF_NUMBER_TABLE
299: , a7 JTF_NUMBER_TABLE
300: ) as
301: ddindx binary_integer; indx binary_integer;
302: begin

Line 299: , a7 JTF_NUMBER_TABLE

295: , a3 JTF_VARCHAR2_TABLE_100
296: , a4 JTF_NUMBER_TABLE
297: , a5 JTF_VARCHAR2_TABLE_100
298: , a6 JTF_NUMBER_TABLE
299: , a7 JTF_NUMBER_TABLE
300: ) as
301: ddindx binary_integer; indx binary_integer;
302: begin
303: if a0 is not null and a0.count > 0 then

Line 325: procedure rosetta_table_copy_out_p5(t lns_distributions_pub.acc_event_tbl, a0 out nocopy JTF_NUMBER_TABLE

321: end loop;
322: end if;
323: end if;
324: end rosetta_table_copy_in_p5;
325: procedure rosetta_table_copy_out_p5(t lns_distributions_pub.acc_event_tbl, a0 out nocopy JTF_NUMBER_TABLE
326: , a1 out nocopy JTF_VARCHAR2_TABLE_100
327: , a2 out nocopy JTF_DATE_TABLE
328: , a3 out nocopy JTF_VARCHAR2_TABLE_100
329: , a4 out nocopy JTF_NUMBER_TABLE

Line 329: , a4 out nocopy JTF_NUMBER_TABLE

325: procedure rosetta_table_copy_out_p5(t lns_distributions_pub.acc_event_tbl, a0 out nocopy JTF_NUMBER_TABLE
326: , a1 out nocopy JTF_VARCHAR2_TABLE_100
327: , a2 out nocopy JTF_DATE_TABLE
328: , a3 out nocopy JTF_VARCHAR2_TABLE_100
329: , a4 out nocopy JTF_NUMBER_TABLE
330: , a5 out nocopy JTF_VARCHAR2_TABLE_100
331: , a6 out nocopy JTF_NUMBER_TABLE
332: , a7 out nocopy JTF_NUMBER_TABLE
333: ) as

Line 331: , a6 out nocopy JTF_NUMBER_TABLE

327: , a2 out nocopy JTF_DATE_TABLE
328: , a3 out nocopy JTF_VARCHAR2_TABLE_100
329: , a4 out nocopy JTF_NUMBER_TABLE
330: , a5 out nocopy JTF_VARCHAR2_TABLE_100
331: , a6 out nocopy JTF_NUMBER_TABLE
332: , a7 out nocopy JTF_NUMBER_TABLE
333: ) as
334: ddindx binary_integer; indx binary_integer;
335: begin

Line 332: , a7 out nocopy JTF_NUMBER_TABLE

328: , a3 out nocopy JTF_VARCHAR2_TABLE_100
329: , a4 out nocopy JTF_NUMBER_TABLE
330: , a5 out nocopy JTF_VARCHAR2_TABLE_100
331: , a6 out nocopy JTF_NUMBER_TABLE
332: , a7 out nocopy JTF_NUMBER_TABLE
333: ) as
334: ddindx binary_integer; indx binary_integer;
335: begin
336: if t is null or t.count = 0 then

Line 337: a0 := JTF_NUMBER_TABLE();

333: ) as
334: ddindx binary_integer; indx binary_integer;
335: begin
336: if t is null or t.count = 0 then
337: a0 := JTF_NUMBER_TABLE();
338: a1 := JTF_VARCHAR2_TABLE_100();
339: a2 := JTF_DATE_TABLE();
340: a3 := JTF_VARCHAR2_TABLE_100();
341: a4 := JTF_NUMBER_TABLE();

Line 341: a4 := JTF_NUMBER_TABLE();

337: a0 := JTF_NUMBER_TABLE();
338: a1 := JTF_VARCHAR2_TABLE_100();
339: a2 := JTF_DATE_TABLE();
340: a3 := JTF_VARCHAR2_TABLE_100();
341: a4 := JTF_NUMBER_TABLE();
342: a5 := JTF_VARCHAR2_TABLE_100();
343: a6 := JTF_NUMBER_TABLE();
344: a7 := JTF_NUMBER_TABLE();
345: else

Line 343: a6 := JTF_NUMBER_TABLE();

339: a2 := JTF_DATE_TABLE();
340: a3 := JTF_VARCHAR2_TABLE_100();
341: a4 := JTF_NUMBER_TABLE();
342: a5 := JTF_VARCHAR2_TABLE_100();
343: a6 := JTF_NUMBER_TABLE();
344: a7 := JTF_NUMBER_TABLE();
345: else
346: a0 := JTF_NUMBER_TABLE();
347: a1 := JTF_VARCHAR2_TABLE_100();

Line 344: a7 := JTF_NUMBER_TABLE();

340: a3 := JTF_VARCHAR2_TABLE_100();
341: a4 := JTF_NUMBER_TABLE();
342: a5 := JTF_VARCHAR2_TABLE_100();
343: a6 := JTF_NUMBER_TABLE();
344: a7 := JTF_NUMBER_TABLE();
345: else
346: a0 := JTF_NUMBER_TABLE();
347: a1 := JTF_VARCHAR2_TABLE_100();
348: a2 := JTF_DATE_TABLE();

Line 346: a0 := JTF_NUMBER_TABLE();

342: a5 := JTF_VARCHAR2_TABLE_100();
343: a6 := JTF_NUMBER_TABLE();
344: a7 := JTF_NUMBER_TABLE();
345: else
346: a0 := JTF_NUMBER_TABLE();
347: a1 := JTF_VARCHAR2_TABLE_100();
348: a2 := JTF_DATE_TABLE();
349: a3 := JTF_VARCHAR2_TABLE_100();
350: a4 := JTF_NUMBER_TABLE();

Line 350: a4 := JTF_NUMBER_TABLE();

346: a0 := JTF_NUMBER_TABLE();
347: a1 := JTF_VARCHAR2_TABLE_100();
348: a2 := JTF_DATE_TABLE();
349: a3 := JTF_VARCHAR2_TABLE_100();
350: a4 := JTF_NUMBER_TABLE();
351: a5 := JTF_VARCHAR2_TABLE_100();
352: a6 := JTF_NUMBER_TABLE();
353: a7 := JTF_NUMBER_TABLE();
354: if t.count > 0 then

Line 352: a6 := JTF_NUMBER_TABLE();

348: a2 := JTF_DATE_TABLE();
349: a3 := JTF_VARCHAR2_TABLE_100();
350: a4 := JTF_NUMBER_TABLE();
351: a5 := JTF_VARCHAR2_TABLE_100();
352: a6 := JTF_NUMBER_TABLE();
353: a7 := JTF_NUMBER_TABLE();
354: if t.count > 0 then
355: a0.extend(t.count);
356: a1.extend(t.count);

Line 353: a7 := JTF_NUMBER_TABLE();

349: a3 := JTF_VARCHAR2_TABLE_100();
350: a4 := JTF_NUMBER_TABLE();
351: a5 := JTF_VARCHAR2_TABLE_100();
352: a6 := JTF_NUMBER_TABLE();
353: a7 := JTF_NUMBER_TABLE();
354: if t.count > 0 then
355: a0.extend(t.count);
356: a1.extend(t.count);
357: a2.extend(t.count);

Line 384: procedure rosetta_table_copy_in_p6(t out nocopy lns_distributions_pub.g_number_tbl, a0 JTF_NUMBER_TABLE) as

380: end if;
381: end if;
382: end rosetta_table_copy_out_p5;
383:
384: procedure rosetta_table_copy_in_p6(t out nocopy lns_distributions_pub.g_number_tbl, a0 JTF_NUMBER_TABLE) as
385: ddindx binary_integer; indx binary_integer;
386: begin
387: if a0 is not null and a0.count > 0 then
388: if a0.count > 0 then

Line 402: procedure rosetta_table_copy_out_p6(t lns_distributions_pub.g_number_tbl, a0 out nocopy JTF_NUMBER_TABLE) as

398: end loop;
399: end if;
400: end if;
401: end rosetta_table_copy_in_p6;
402: procedure rosetta_table_copy_out_p6(t lns_distributions_pub.g_number_tbl, a0 out nocopy JTF_NUMBER_TABLE) as
403: ddindx binary_integer; indx binary_integer;
404: begin
405: if t is null or t.count = 0 then
406: a0 := JTF_NUMBER_TABLE();

Line 406: a0 := JTF_NUMBER_TABLE();

402: procedure rosetta_table_copy_out_p6(t lns_distributions_pub.g_number_tbl, a0 out nocopy JTF_NUMBER_TABLE) as
403: ddindx binary_integer; indx binary_integer;
404: begin
405: if t is null or t.count = 0 then
406: a0 := JTF_NUMBER_TABLE();
407: else
408: a0 := JTF_NUMBER_TABLE();
409: if t.count > 0 then
410: a0.extend(t.count);

Line 408: a0 := JTF_NUMBER_TABLE();

404: begin
405: if t is null or t.count = 0 then
406: a0 := JTF_NUMBER_TABLE();
407: else
408: a0 := JTF_NUMBER_TABLE();
409: if t.count > 0 then
410: a0.extend(t.count);
411: ddindx := t.first;
412: indx := 1;

Line 425: procedure create_event(p0_a0 JTF_NUMBER_TABLE

421: end if;
422: end if;
423: end rosetta_table_copy_out_p6;
424:
425: procedure create_event(p0_a0 JTF_NUMBER_TABLE
426: , p0_a1 JTF_VARCHAR2_TABLE_100
427: , p0_a2 JTF_DATE_TABLE
428: , p0_a3 JTF_VARCHAR2_TABLE_100
429: , p0_a4 JTF_NUMBER_TABLE

Line 429: , p0_a4 JTF_NUMBER_TABLE

425: procedure create_event(p0_a0 JTF_NUMBER_TABLE
426: , p0_a1 JTF_VARCHAR2_TABLE_100
427: , p0_a2 JTF_DATE_TABLE
428: , p0_a3 JTF_VARCHAR2_TABLE_100
429: , p0_a4 JTF_NUMBER_TABLE
430: , p0_a5 JTF_VARCHAR2_TABLE_100
431: , p0_a6 JTF_NUMBER_TABLE
432: , p0_a7 JTF_NUMBER_TABLE
433: , p_init_msg_list VARCHAR2

Line 431: , p0_a6 JTF_NUMBER_TABLE

427: , p0_a2 JTF_DATE_TABLE
428: , p0_a3 JTF_VARCHAR2_TABLE_100
429: , p0_a4 JTF_NUMBER_TABLE
430: , p0_a5 JTF_VARCHAR2_TABLE_100
431: , p0_a6 JTF_NUMBER_TABLE
432: , p0_a7 JTF_NUMBER_TABLE
433: , p_init_msg_list VARCHAR2
434: , p_commit VARCHAR2
435: , x_return_status out nocopy VARCHAR2

Line 432: , p0_a7 JTF_NUMBER_TABLE

428: , p0_a3 JTF_VARCHAR2_TABLE_100
429: , p0_a4 JTF_NUMBER_TABLE
430: , p0_a5 JTF_VARCHAR2_TABLE_100
431: , p0_a6 JTF_NUMBER_TABLE
432: , p0_a7 JTF_NUMBER_TABLE
433: , p_init_msg_list VARCHAR2
434: , p_commit VARCHAR2
435: , x_return_status out nocopy VARCHAR2
436: , x_msg_count out nocopy NUMBER

Line 485: , p8_a0 out nocopy JTF_NUMBER_TABLE

481: , p_disb_header_id NUMBER
482: , p_loan_amount_adj_id NUMBER
483: , p_include_loan_receivables VARCHAR2
484: , p_distribution_type VARCHAR2
485: , p8_a0 out nocopy JTF_NUMBER_TABLE
486: , p8_a1 out nocopy JTF_NUMBER_TABLE
487: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
488: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
489: , p8_a4 out nocopy JTF_NUMBER_TABLE

Line 486: , p8_a1 out nocopy JTF_NUMBER_TABLE

482: , p_loan_amount_adj_id NUMBER
483: , p_include_loan_receivables VARCHAR2
484: , p_distribution_type VARCHAR2
485: , p8_a0 out nocopy JTF_NUMBER_TABLE
486: , p8_a1 out nocopy JTF_NUMBER_TABLE
487: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
488: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
489: , p8_a4 out nocopy JTF_NUMBER_TABLE
490: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 489: , p8_a4 out nocopy JTF_NUMBER_TABLE

485: , p8_a0 out nocopy JTF_NUMBER_TABLE
486: , p8_a1 out nocopy JTF_NUMBER_TABLE
487: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
488: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
489: , p8_a4 out nocopy JTF_NUMBER_TABLE
490: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
491: , p8_a6 out nocopy JTF_NUMBER_TABLE
492: , p8_a7 out nocopy JTF_NUMBER_TABLE
493: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 491: , p8_a6 out nocopy JTF_NUMBER_TABLE

487: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
488: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
489: , p8_a4 out nocopy JTF_NUMBER_TABLE
490: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
491: , p8_a6 out nocopy JTF_NUMBER_TABLE
492: , p8_a7 out nocopy JTF_NUMBER_TABLE
493: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
494: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
495: , p8_a10 out nocopy JTF_NUMBER_TABLE

Line 492: , p8_a7 out nocopy JTF_NUMBER_TABLE

488: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
489: , p8_a4 out nocopy JTF_NUMBER_TABLE
490: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
491: , p8_a6 out nocopy JTF_NUMBER_TABLE
492: , p8_a7 out nocopy JTF_NUMBER_TABLE
493: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
494: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
495: , p8_a10 out nocopy JTF_NUMBER_TABLE
496: , p8_a11 out nocopy JTF_NUMBER_TABLE

Line 495: , p8_a10 out nocopy JTF_NUMBER_TABLE

491: , p8_a6 out nocopy JTF_NUMBER_TABLE
492: , p8_a7 out nocopy JTF_NUMBER_TABLE
493: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
494: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
495: , p8_a10 out nocopy JTF_NUMBER_TABLE
496: , p8_a11 out nocopy JTF_NUMBER_TABLE
497: , p8_a12 out nocopy JTF_NUMBER_TABLE
498: , p8_a13 out nocopy JTF_NUMBER_TABLE
499: , p8_a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 496: , p8_a11 out nocopy JTF_NUMBER_TABLE

492: , p8_a7 out nocopy JTF_NUMBER_TABLE
493: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
494: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
495: , p8_a10 out nocopy JTF_NUMBER_TABLE
496: , p8_a11 out nocopy JTF_NUMBER_TABLE
497: , p8_a12 out nocopy JTF_NUMBER_TABLE
498: , p8_a13 out nocopy JTF_NUMBER_TABLE
499: , p8_a14 out nocopy JTF_VARCHAR2_TABLE_100
500: , p8_a15 out nocopy JTF_DATE_TABLE

Line 497: , p8_a12 out nocopy JTF_NUMBER_TABLE

493: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
494: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
495: , p8_a10 out nocopy JTF_NUMBER_TABLE
496: , p8_a11 out nocopy JTF_NUMBER_TABLE
497: , p8_a12 out nocopy JTF_NUMBER_TABLE
498: , p8_a13 out nocopy JTF_NUMBER_TABLE
499: , p8_a14 out nocopy JTF_VARCHAR2_TABLE_100
500: , p8_a15 out nocopy JTF_DATE_TABLE
501: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 498: , p8_a13 out nocopy JTF_NUMBER_TABLE

494: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
495: , p8_a10 out nocopy JTF_NUMBER_TABLE
496: , p8_a11 out nocopy JTF_NUMBER_TABLE
497: , p8_a12 out nocopy JTF_NUMBER_TABLE
498: , p8_a13 out nocopy JTF_NUMBER_TABLE
499: , p8_a14 out nocopy JTF_VARCHAR2_TABLE_100
500: , p8_a15 out nocopy JTF_DATE_TABLE
501: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_100
502: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_100

Line 619: , p4_a0 in out nocopy JTF_NUMBER_TABLE

615: procedure createdistrforimport(p_api_version NUMBER
616: , p_init_msg_list VARCHAR2
617: , p_commit VARCHAR2
618: , p_loan_id NUMBER
619: , p4_a0 in out nocopy JTF_NUMBER_TABLE
620: , p4_a1 in out nocopy JTF_NUMBER_TABLE
621: , p4_a2 in out nocopy JTF_VARCHAR2_TABLE_100
622: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
623: , p4_a4 in out nocopy JTF_NUMBER_TABLE

Line 620: , p4_a1 in out nocopy JTF_NUMBER_TABLE

616: , p_init_msg_list VARCHAR2
617: , p_commit VARCHAR2
618: , p_loan_id NUMBER
619: , p4_a0 in out nocopy JTF_NUMBER_TABLE
620: , p4_a1 in out nocopy JTF_NUMBER_TABLE
621: , p4_a2 in out nocopy JTF_VARCHAR2_TABLE_100
622: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
623: , p4_a4 in out nocopy JTF_NUMBER_TABLE
624: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 623: , p4_a4 in out nocopy JTF_NUMBER_TABLE

619: , p4_a0 in out nocopy JTF_NUMBER_TABLE
620: , p4_a1 in out nocopy JTF_NUMBER_TABLE
621: , p4_a2 in out nocopy JTF_VARCHAR2_TABLE_100
622: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
623: , p4_a4 in out nocopy JTF_NUMBER_TABLE
624: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
625: , p4_a6 in out nocopy JTF_NUMBER_TABLE
626: , p4_a7 in out nocopy JTF_NUMBER_TABLE
627: , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100

Line 625: , p4_a6 in out nocopy JTF_NUMBER_TABLE

621: , p4_a2 in out nocopy JTF_VARCHAR2_TABLE_100
622: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
623: , p4_a4 in out nocopy JTF_NUMBER_TABLE
624: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
625: , p4_a6 in out nocopy JTF_NUMBER_TABLE
626: , p4_a7 in out nocopy JTF_NUMBER_TABLE
627: , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
628: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_100
629: , p4_a10 in out nocopy JTF_NUMBER_TABLE

Line 626: , p4_a7 in out nocopy JTF_NUMBER_TABLE

622: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
623: , p4_a4 in out nocopy JTF_NUMBER_TABLE
624: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
625: , p4_a6 in out nocopy JTF_NUMBER_TABLE
626: , p4_a7 in out nocopy JTF_NUMBER_TABLE
627: , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
628: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_100
629: , p4_a10 in out nocopy JTF_NUMBER_TABLE
630: , p4_a11 in out nocopy JTF_NUMBER_TABLE

Line 629: , p4_a10 in out nocopy JTF_NUMBER_TABLE

625: , p4_a6 in out nocopy JTF_NUMBER_TABLE
626: , p4_a7 in out nocopy JTF_NUMBER_TABLE
627: , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
628: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_100
629: , p4_a10 in out nocopy JTF_NUMBER_TABLE
630: , p4_a11 in out nocopy JTF_NUMBER_TABLE
631: , p4_a12 in out nocopy JTF_NUMBER_TABLE
632: , p4_a13 in out nocopy JTF_NUMBER_TABLE
633: , p4_a14 in out nocopy JTF_VARCHAR2_TABLE_100

Line 630: , p4_a11 in out nocopy JTF_NUMBER_TABLE

626: , p4_a7 in out nocopy JTF_NUMBER_TABLE
627: , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
628: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_100
629: , p4_a10 in out nocopy JTF_NUMBER_TABLE
630: , p4_a11 in out nocopy JTF_NUMBER_TABLE
631: , p4_a12 in out nocopy JTF_NUMBER_TABLE
632: , p4_a13 in out nocopy JTF_NUMBER_TABLE
633: , p4_a14 in out nocopy JTF_VARCHAR2_TABLE_100
634: , p4_a15 in out nocopy JTF_DATE_TABLE

Line 631: , p4_a12 in out nocopy JTF_NUMBER_TABLE

627: , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
628: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_100
629: , p4_a10 in out nocopy JTF_NUMBER_TABLE
630: , p4_a11 in out nocopy JTF_NUMBER_TABLE
631: , p4_a12 in out nocopy JTF_NUMBER_TABLE
632: , p4_a13 in out nocopy JTF_NUMBER_TABLE
633: , p4_a14 in out nocopy JTF_VARCHAR2_TABLE_100
634: , p4_a15 in out nocopy JTF_DATE_TABLE
635: , p4_a16 in out nocopy JTF_VARCHAR2_TABLE_100

Line 632: , p4_a13 in out nocopy JTF_NUMBER_TABLE

628: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_100
629: , p4_a10 in out nocopy JTF_NUMBER_TABLE
630: , p4_a11 in out nocopy JTF_NUMBER_TABLE
631: , p4_a12 in out nocopy JTF_NUMBER_TABLE
632: , p4_a13 in out nocopy JTF_NUMBER_TABLE
633: , p4_a14 in out nocopy JTF_VARCHAR2_TABLE_100
634: , p4_a15 in out nocopy JTF_DATE_TABLE
635: , p4_a16 in out nocopy JTF_VARCHAR2_TABLE_100
636: , p4_a17 in out nocopy JTF_VARCHAR2_TABLE_100

Line 721: , p7_a0 out nocopy JTF_NUMBER_TABLE

717: , p_loan_id NUMBER
718: , p_disb_header_id NUMBER
719: , p_loan_amount_adj_id NUMBER
720: , p_activity VARCHAR2
721: , p7_a0 out nocopy JTF_NUMBER_TABLE
722: , p7_a1 out nocopy JTF_NUMBER_TABLE
723: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
724: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
725: , p7_a4 out nocopy JTF_NUMBER_TABLE

Line 722: , p7_a1 out nocopy JTF_NUMBER_TABLE

718: , p_disb_header_id NUMBER
719: , p_loan_amount_adj_id NUMBER
720: , p_activity VARCHAR2
721: , p7_a0 out nocopy JTF_NUMBER_TABLE
722: , p7_a1 out nocopy JTF_NUMBER_TABLE
723: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
724: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
725: , p7_a4 out nocopy JTF_NUMBER_TABLE
726: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 725: , p7_a4 out nocopy JTF_NUMBER_TABLE

721: , p7_a0 out nocopy JTF_NUMBER_TABLE
722: , p7_a1 out nocopy JTF_NUMBER_TABLE
723: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
724: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
725: , p7_a4 out nocopy JTF_NUMBER_TABLE
726: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
727: , p7_a6 out nocopy JTF_NUMBER_TABLE
728: , p7_a7 out nocopy JTF_NUMBER_TABLE
729: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 727: , p7_a6 out nocopy JTF_NUMBER_TABLE

723: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
724: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
725: , p7_a4 out nocopy JTF_NUMBER_TABLE
726: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
727: , p7_a6 out nocopy JTF_NUMBER_TABLE
728: , p7_a7 out nocopy JTF_NUMBER_TABLE
729: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
730: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
731: , p7_a10 out nocopy JTF_NUMBER_TABLE

Line 728: , p7_a7 out nocopy JTF_NUMBER_TABLE

724: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
725: , p7_a4 out nocopy JTF_NUMBER_TABLE
726: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
727: , p7_a6 out nocopy JTF_NUMBER_TABLE
728: , p7_a7 out nocopy JTF_NUMBER_TABLE
729: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
730: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
731: , p7_a10 out nocopy JTF_NUMBER_TABLE
732: , p7_a11 out nocopy JTF_NUMBER_TABLE

Line 731: , p7_a10 out nocopy JTF_NUMBER_TABLE

727: , p7_a6 out nocopy JTF_NUMBER_TABLE
728: , p7_a7 out nocopy JTF_NUMBER_TABLE
729: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
730: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
731: , p7_a10 out nocopy JTF_NUMBER_TABLE
732: , p7_a11 out nocopy JTF_NUMBER_TABLE
733: , p7_a12 out nocopy JTF_NUMBER_TABLE
734: , p7_a13 out nocopy JTF_NUMBER_TABLE
735: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 732: , p7_a11 out nocopy JTF_NUMBER_TABLE

728: , p7_a7 out nocopy JTF_NUMBER_TABLE
729: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
730: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
731: , p7_a10 out nocopy JTF_NUMBER_TABLE
732: , p7_a11 out nocopy JTF_NUMBER_TABLE
733: , p7_a12 out nocopy JTF_NUMBER_TABLE
734: , p7_a13 out nocopy JTF_NUMBER_TABLE
735: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
736: , p7_a15 out nocopy JTF_DATE_TABLE

Line 733: , p7_a12 out nocopy JTF_NUMBER_TABLE

729: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
730: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
731: , p7_a10 out nocopy JTF_NUMBER_TABLE
732: , p7_a11 out nocopy JTF_NUMBER_TABLE
733: , p7_a12 out nocopy JTF_NUMBER_TABLE
734: , p7_a13 out nocopy JTF_NUMBER_TABLE
735: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
736: , p7_a15 out nocopy JTF_DATE_TABLE
737: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 734: , p7_a13 out nocopy JTF_NUMBER_TABLE

730: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
731: , p7_a10 out nocopy JTF_NUMBER_TABLE
732: , p7_a11 out nocopy JTF_NUMBER_TABLE
733: , p7_a12 out nocopy JTF_NUMBER_TABLE
734: , p7_a13 out nocopy JTF_NUMBER_TABLE
735: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
736: , p7_a15 out nocopy JTF_DATE_TABLE
737: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
738: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100