eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.LNS_DISTRIBUTIONS_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

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
9: , a6 JTF_NUMBER_TABLE

Line 6: , a3 JTF_VARCHAR2_TABLE_100

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
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE

Line 8: , a5 JTF_VARCHAR2_TABLE_100

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
12: , a9 JTF_VARCHAR2_TABLE_100

Line 11: , a8 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
15: , a12 JTF_NUMBER_TABLE

Line 12: , a9 JTF_VARCHAR2_TABLE_100

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
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE

Line 17: , a14 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
21: ) as

Line 19: , a16 JTF_VARCHAR2_TABLE_100

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
21: ) as
22: ddindx binary_integer; indx binary_integer;
23: begin

Line 20: , a17 JTF_VARCHAR2_TABLE_100

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
21: ) as
22: ddindx binary_integer; indx binary_integer;
23: begin
24: if a0 is not null and a0.count > 0 then

Line 58: , a2 out nocopy JTF_VARCHAR2_TABLE_100

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
62: , a6 out nocopy JTF_NUMBER_TABLE

Line 59: , a3 out nocopy JTF_VARCHAR2_TABLE_100

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
62: , a6 out nocopy JTF_NUMBER_TABLE
63: , a7 out nocopy JTF_NUMBER_TABLE

Line 61: , a5 out nocopy JTF_VARCHAR2_TABLE_100

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
65: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 64: , a8 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
68: , a12 out nocopy JTF_NUMBER_TABLE

Line 65: , a9 out nocopy JTF_VARCHAR2_TABLE_100

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
68: , a12 out nocopy JTF_NUMBER_TABLE
69: , a13 out nocopy JTF_NUMBER_TABLE

Line 70: , a14 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
74: ) as

Line 72: , a16 out nocopy JTF_VARCHAR2_TABLE_100

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
74: ) as
75: ddindx binary_integer; indx binary_integer;
76: begin

Line 73: , a17 out nocopy JTF_VARCHAR2_TABLE_100

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
74: ) as
75: ddindx binary_integer; indx binary_integer;
76: begin
77: if t is null or t.count = 0 then

Line 80: a2 := JTF_VARCHAR2_TABLE_100();

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();
84: a6 := JTF_NUMBER_TABLE();

Line 81: a3 := JTF_VARCHAR2_TABLE_100();

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();
84: a6 := JTF_NUMBER_TABLE();
85: a7 := JTF_NUMBER_TABLE();

Line 83: a5 := JTF_VARCHAR2_TABLE_100();

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();
87: a9 := JTF_VARCHAR2_TABLE_100();

Line 86: a8 := 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();
90: a12 := JTF_NUMBER_TABLE();

Line 87: a9 := JTF_VARCHAR2_TABLE_100();

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();
90: a12 := JTF_NUMBER_TABLE();
91: a13 := JTF_NUMBER_TABLE();

Line 92: a14 := 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();
96: else

Line 94: a16 := JTF_VARCHAR2_TABLE_100();

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();
96: else
97: a0 := JTF_NUMBER_TABLE();
98: a1 := JTF_NUMBER_TABLE();

Line 95: a17 := JTF_VARCHAR2_TABLE_100();

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();
96: else
97: a0 := JTF_NUMBER_TABLE();
98: a1 := JTF_NUMBER_TABLE();
99: a2 := JTF_VARCHAR2_TABLE_100();

Line 99: a2 := 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();
103: a6 := JTF_NUMBER_TABLE();

Line 100: a3 := 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();
103: a6 := JTF_NUMBER_TABLE();
104: a7 := JTF_NUMBER_TABLE();

Line 102: a5 := JTF_VARCHAR2_TABLE_100();

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();
106: a9 := JTF_VARCHAR2_TABLE_100();

Line 105: a8 := 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();
109: a12 := JTF_NUMBER_TABLE();

Line 106: a9 := JTF_VARCHAR2_TABLE_100();

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();
109: a12 := JTF_NUMBER_TABLE();
110: a13 := JTF_NUMBER_TABLE();

Line 111: a14 := 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();
115: if t.count > 0 then

Line 113: a16 := JTF_VARCHAR2_TABLE_100();

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();
115: if t.count > 0 then
116: a0.extend(t.count);
117: a1.extend(t.count);

Line 114: a17 := JTF_VARCHAR2_TABLE_100();

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();
115: if t.count > 0 then
116: a0.extend(t.count);
117: a1.extend(t.count);
118: a2.extend(t.count);

Line 165: procedure rosetta_table_copy_in_p3(t out nocopy lns_distributions_pub.default_distributions_tbl, a0 JTF_VARCHAR2_TABLE_100

161: end if;
162: end if;
163: end rosetta_table_copy_out_p1;
164:
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

Line 166: , a1 JTF_VARCHAR2_TABLE_100

162: end if;
163: end rosetta_table_copy_out_p1;
164:
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

Line 167: , a2 JTF_VARCHAR2_TABLE_100

163: end rosetta_table_copy_out_p1;
164:
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

Line 168: , a3 JTF_VARCHAR2_TABLE_100

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

Line 170: , a5 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
174: , a9 JTF_NUMBER_TABLE

Line 172: , a7 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
176: , a11 JTF_VARCHAR2_TABLE_100

Line 175: , a10 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
179: ddindx binary_integer; indx binary_integer;

Line 176: , a11 JTF_VARCHAR2_TABLE_100

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
179: ddindx binary_integer; indx binary_integer;
180: begin

Line 177: , a12 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
179: ddindx binary_integer; indx binary_integer;
180: begin
181: if a0 is not null and a0.count > 0 then

Line 208: procedure rosetta_table_copy_out_p3(t lns_distributions_pub.default_distributions_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100

204: end loop;
205: end if;
206: end if;
207: end rosetta_table_copy_in_p3;
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

Line 209: , a1 out nocopy JTF_VARCHAR2_TABLE_100

205: end if;
206: end if;
207: end rosetta_table_copy_in_p3;
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

Line 210: , a2 out nocopy JTF_VARCHAR2_TABLE_100

206: end if;
207: end rosetta_table_copy_in_p3;
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

Line 211: , a3 out nocopy JTF_VARCHAR2_TABLE_100

207: end rosetta_table_copy_in_p3;
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

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

Line 215: , a7 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
219: , a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 218: , a10 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
222: ddindx binary_integer; indx binary_integer;

Line 219: , a11 out nocopy JTF_VARCHAR2_TABLE_100

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
222: ddindx binary_integer; indx binary_integer;
223: begin

Line 220: , a12 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
222: ddindx binary_integer; indx binary_integer;
223: begin
224: if t is null or t.count = 0 then

Line 225: a0 := JTF_VARCHAR2_TABLE_100();

221: ) as
222: ddindx binary_integer; indx binary_integer;
223: begin
224: if t is null or t.count = 0 then
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();

Line 226: a1 := JTF_VARCHAR2_TABLE_100();

222: ddindx binary_integer; indx binary_integer;
223: begin
224: if t is null or t.count = 0 then
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();

Line 227: a2 := JTF_VARCHAR2_TABLE_100();

223: begin
224: if t is null or t.count = 0 then
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();

Line 228: a3 := JTF_VARCHAR2_TABLE_100();

224: if t is null or t.count = 0 then
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();

Line 230: a5 := 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();
234: a9 := JTF_NUMBER_TABLE();

Line 232: a7 := 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();
236: a11 := JTF_VARCHAR2_TABLE_100();

Line 235: a10 := 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
239: a0 := JTF_VARCHAR2_TABLE_100();

Line 236: a11 := JTF_VARCHAR2_TABLE_100();

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
239: a0 := JTF_VARCHAR2_TABLE_100();
240: a1 := JTF_VARCHAR2_TABLE_100();

Line 237: a12 := 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
239: a0 := JTF_VARCHAR2_TABLE_100();
240: a1 := JTF_VARCHAR2_TABLE_100();
241: a2 := JTF_VARCHAR2_TABLE_100();

Line 239: a0 := JTF_VARCHAR2_TABLE_100();

235: a10 := JTF_VARCHAR2_TABLE_100();
236: a11 := JTF_VARCHAR2_TABLE_100();
237: a12 := JTF_VARCHAR2_TABLE_100();
238: else
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();

Line 240: a1 := JTF_VARCHAR2_TABLE_100();

236: a11 := JTF_VARCHAR2_TABLE_100();
237: a12 := JTF_VARCHAR2_TABLE_100();
238: else
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();

Line 241: a2 := JTF_VARCHAR2_TABLE_100();

237: a12 := JTF_VARCHAR2_TABLE_100();
238: else
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();

Line 242: a3 := JTF_VARCHAR2_TABLE_100();

238: else
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();

Line 244: a5 := 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();
248: a9 := JTF_NUMBER_TABLE();

Line 246: a7 := 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();
250: a11 := JTF_VARCHAR2_TABLE_100();

Line 249: a10 := 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
253: a0.extend(t.count);

Line 250: a11 := JTF_VARCHAR2_TABLE_100();

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
253: a0.extend(t.count);
254: a1.extend(t.count);

Line 251: a12 := 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
253: a0.extend(t.count);
254: a1.extend(t.count);
255: a2.extend(t.count);

Line 293: , a1 JTF_VARCHAR2_TABLE_100

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
297: , a5 JTF_VARCHAR2_TABLE_100

Line 295: , a3 JTF_VARCHAR2_TABLE_100

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
297: , a5 JTF_VARCHAR2_TABLE_100
298: , a6 JTF_NUMBER_TABLE
299: , a7 JTF_NUMBER_TABLE

Line 297: , a5 JTF_VARCHAR2_TABLE_100

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
301: ddindx binary_integer; indx binary_integer;

Line 326: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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
330: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 328: , a3 out nocopy JTF_VARCHAR2_TABLE_100

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
330: , a5 out nocopy JTF_VARCHAR2_TABLE_100
331: , a6 out nocopy JTF_NUMBER_TABLE
332: , a7 out nocopy JTF_NUMBER_TABLE

Line 330: , a5 out nocopy JTF_VARCHAR2_TABLE_100

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
334: ddindx binary_integer; indx binary_integer;

Line 338: a1 := JTF_VARCHAR2_TABLE_100();

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();
342: a5 := JTF_VARCHAR2_TABLE_100();

Line 340: a3 := JTF_VARCHAR2_TABLE_100();

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();
342: a5 := JTF_VARCHAR2_TABLE_100();
343: a6 := JTF_NUMBER_TABLE();
344: a7 := JTF_NUMBER_TABLE();

Line 342: a5 := JTF_VARCHAR2_TABLE_100();

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
346: a0 := JTF_NUMBER_TABLE();

Line 347: a1 := 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();
351: a5 := JTF_VARCHAR2_TABLE_100();

Line 349: a3 := JTF_VARCHAR2_TABLE_100();

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();
351: a5 := JTF_VARCHAR2_TABLE_100();
352: a6 := JTF_NUMBER_TABLE();
353: a7 := JTF_NUMBER_TABLE();

Line 351: a5 := JTF_VARCHAR2_TABLE_100();

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
355: a0.extend(t.count);

Line 426: , p0_a1 JTF_VARCHAR2_TABLE_100

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
430: , p0_a5 JTF_VARCHAR2_TABLE_100

Line 428: , p0_a3 JTF_VARCHAR2_TABLE_100

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
430: , p0_a5 JTF_VARCHAR2_TABLE_100
431: , p0_a6 JTF_NUMBER_TABLE
432: , p0_a7 JTF_NUMBER_TABLE

Line 430: , p0_a5 JTF_VARCHAR2_TABLE_100

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
434: , p_commit VARCHAR2

Line 487: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100

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
491: , p8_a6 out nocopy JTF_NUMBER_TABLE

Line 488: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100

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
491: , p8_a6 out nocopy JTF_NUMBER_TABLE
492: , p8_a7 out nocopy JTF_NUMBER_TABLE

Line 490: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100

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
494: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 493: , p8_a8 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
497: , p8_a12 out nocopy JTF_NUMBER_TABLE

Line 494: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100

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
497: , p8_a12 out nocopy JTF_NUMBER_TABLE
498: , p8_a13 out nocopy JTF_NUMBER_TABLE

Line 499: , p8_a14 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
503: , x_return_status out nocopy VARCHAR2

Line 501: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_100

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
503: , x_return_status out nocopy VARCHAR2
504: , x_msg_count out nocopy NUMBER
505: , x_msg_data out nocopy VARCHAR2

Line 502: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_100

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
503: , x_return_status out nocopy VARCHAR2
504: , x_msg_count out nocopy NUMBER
505: , x_msg_data out nocopy VARCHAR2
506: )

Line 621: , p4_a2 in out nocopy JTF_VARCHAR2_TABLE_100

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
625: , p4_a6 in out nocopy JTF_NUMBER_TABLE

Line 622: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100

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
625: , p4_a6 in out nocopy JTF_NUMBER_TABLE
626: , p4_a7 in out nocopy JTF_NUMBER_TABLE

Line 624: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100

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
628: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_100

Line 627: , p4_a8 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
631: , p4_a12 in out nocopy JTF_NUMBER_TABLE

Line 628: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_100

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
631: , p4_a12 in out nocopy JTF_NUMBER_TABLE
632: , p4_a13 in out nocopy JTF_NUMBER_TABLE

Line 633: , p4_a14 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
637: , x_return_status out nocopy VARCHAR2

Line 635: , p4_a16 in out nocopy JTF_VARCHAR2_TABLE_100

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
637: , x_return_status out nocopy VARCHAR2
638: , x_msg_count out nocopy NUMBER
639: , x_msg_data out nocopy VARCHAR2

Line 636: , p4_a17 in out nocopy JTF_VARCHAR2_TABLE_100

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
637: , x_return_status out nocopy VARCHAR2
638: , x_msg_count out nocopy NUMBER
639: , x_msg_data out nocopy VARCHAR2
640: )

Line 723: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100

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
727: , p7_a6 out nocopy JTF_NUMBER_TABLE

Line 724: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100

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
727: , p7_a6 out nocopy JTF_NUMBER_TABLE
728: , p7_a7 out nocopy JTF_NUMBER_TABLE

Line 726: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100

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
730: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 729: , p7_a8 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
733: , p7_a12 out nocopy JTF_NUMBER_TABLE

Line 730: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100

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
733: , p7_a12 out nocopy JTF_NUMBER_TABLE
734: , p7_a13 out nocopy JTF_NUMBER_TABLE

Line 735: , p7_a14 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
739: , x_return_status out nocopy VARCHAR2

Line 737: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100

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
739: , x_return_status out nocopy VARCHAR2
740: , x_msg_count out nocopy NUMBER
741: , x_msg_data out nocopy VARCHAR2

Line 738: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100

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
739: , x_return_status out nocopy VARCHAR2
740: , x_msg_count out nocopy NUMBER
741: , x_msg_data out nocopy VARCHAR2
742: )