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.AHL_FMP_PVT_W dependencies on JTF_NUMBER_TABLE

Line 23: , a7 JTF_NUMBER_TABLE

19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_VARCHAR2_TABLE_400
21: , a5 JTF_VARCHAR2_TABLE_300
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_NUMBER_TABLE
27: , a11 JTF_VARCHAR2_TABLE_100

Line 24: , a8 JTF_NUMBER_TABLE

20: , a4 JTF_VARCHAR2_TABLE_400
21: , a5 JTF_VARCHAR2_TABLE_300
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_NUMBER_TABLE
27: , a11 JTF_VARCHAR2_TABLE_100
28: ) as

Line 25: , a9 JTF_NUMBER_TABLE

21: , a5 JTF_VARCHAR2_TABLE_300
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_NUMBER_TABLE
27: , a11 JTF_VARCHAR2_TABLE_100
28: ) as
29: ddindx binary_integer; indx binary_integer;

Line 26: , a10 JTF_NUMBER_TABLE

22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_NUMBER_TABLE
27: , a11 JTF_VARCHAR2_TABLE_100
28: ) as
29: ddindx binary_integer; indx binary_integer;
30: begin

Line 64: , a7 out nocopy JTF_NUMBER_TABLE

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

Line 65: , a8 out nocopy JTF_NUMBER_TABLE

61: , a4 out nocopy JTF_VARCHAR2_TABLE_400
62: , a5 out nocopy JTF_VARCHAR2_TABLE_300
63: , a6 out nocopy JTF_VARCHAR2_TABLE_100
64: , a7 out nocopy JTF_NUMBER_TABLE
65: , a8 out nocopy JTF_NUMBER_TABLE
66: , a9 out nocopy JTF_NUMBER_TABLE
67: , a10 out nocopy JTF_NUMBER_TABLE
68: , a11 out nocopy JTF_VARCHAR2_TABLE_100
69: ) as

Line 66: , a9 out nocopy JTF_NUMBER_TABLE

62: , a5 out nocopy JTF_VARCHAR2_TABLE_300
63: , a6 out nocopy JTF_VARCHAR2_TABLE_100
64: , a7 out nocopy JTF_NUMBER_TABLE
65: , a8 out nocopy JTF_NUMBER_TABLE
66: , a9 out nocopy JTF_NUMBER_TABLE
67: , a10 out nocopy JTF_NUMBER_TABLE
68: , a11 out nocopy JTF_VARCHAR2_TABLE_100
69: ) as
70: ddindx binary_integer; indx binary_integer;

Line 67: , a10 out nocopy JTF_NUMBER_TABLE

63: , a6 out nocopy JTF_VARCHAR2_TABLE_100
64: , a7 out nocopy JTF_NUMBER_TABLE
65: , a8 out nocopy JTF_NUMBER_TABLE
66: , a9 out nocopy JTF_NUMBER_TABLE
67: , a10 out nocopy JTF_NUMBER_TABLE
68: , a11 out nocopy JTF_VARCHAR2_TABLE_100
69: ) as
70: ddindx binary_integer; indx binary_integer;
71: begin

Line 80: a7 := JTF_NUMBER_TABLE();

76: a3 := JTF_VARCHAR2_TABLE_100();
77: a4 := JTF_VARCHAR2_TABLE_400();
78: a5 := JTF_VARCHAR2_TABLE_300();
79: a6 := JTF_VARCHAR2_TABLE_100();
80: a7 := JTF_NUMBER_TABLE();
81: a8 := JTF_NUMBER_TABLE();
82: a9 := JTF_NUMBER_TABLE();
83: a10 := JTF_NUMBER_TABLE();
84: a11 := JTF_VARCHAR2_TABLE_100();

Line 81: a8 := JTF_NUMBER_TABLE();

77: a4 := JTF_VARCHAR2_TABLE_400();
78: a5 := JTF_VARCHAR2_TABLE_300();
79: a6 := JTF_VARCHAR2_TABLE_100();
80: a7 := JTF_NUMBER_TABLE();
81: a8 := JTF_NUMBER_TABLE();
82: a9 := JTF_NUMBER_TABLE();
83: a10 := JTF_NUMBER_TABLE();
84: a11 := JTF_VARCHAR2_TABLE_100();
85: else

Line 82: a9 := JTF_NUMBER_TABLE();

78: a5 := JTF_VARCHAR2_TABLE_300();
79: a6 := JTF_VARCHAR2_TABLE_100();
80: a7 := JTF_NUMBER_TABLE();
81: a8 := JTF_NUMBER_TABLE();
82: a9 := JTF_NUMBER_TABLE();
83: a10 := JTF_NUMBER_TABLE();
84: a11 := JTF_VARCHAR2_TABLE_100();
85: else
86: a0 := JTF_VARCHAR2_TABLE_100();

Line 83: a10 := JTF_NUMBER_TABLE();

79: a6 := JTF_VARCHAR2_TABLE_100();
80: a7 := JTF_NUMBER_TABLE();
81: a8 := JTF_NUMBER_TABLE();
82: a9 := JTF_NUMBER_TABLE();
83: a10 := JTF_NUMBER_TABLE();
84: a11 := JTF_VARCHAR2_TABLE_100();
85: else
86: a0 := JTF_VARCHAR2_TABLE_100();
87: a1 := JTF_VARCHAR2_TABLE_100();

Line 93: a7 := JTF_NUMBER_TABLE();

89: a3 := JTF_VARCHAR2_TABLE_100();
90: a4 := JTF_VARCHAR2_TABLE_400();
91: a5 := JTF_VARCHAR2_TABLE_300();
92: a6 := JTF_VARCHAR2_TABLE_100();
93: a7 := JTF_NUMBER_TABLE();
94: a8 := JTF_NUMBER_TABLE();
95: a9 := JTF_NUMBER_TABLE();
96: a10 := JTF_NUMBER_TABLE();
97: a11 := JTF_VARCHAR2_TABLE_100();

Line 94: a8 := JTF_NUMBER_TABLE();

90: a4 := JTF_VARCHAR2_TABLE_400();
91: a5 := JTF_VARCHAR2_TABLE_300();
92: a6 := JTF_VARCHAR2_TABLE_100();
93: a7 := JTF_NUMBER_TABLE();
94: a8 := JTF_NUMBER_TABLE();
95: a9 := JTF_NUMBER_TABLE();
96: a10 := JTF_NUMBER_TABLE();
97: a11 := JTF_VARCHAR2_TABLE_100();
98: if t.count > 0 then

Line 95: a9 := JTF_NUMBER_TABLE();

91: a5 := JTF_VARCHAR2_TABLE_300();
92: a6 := JTF_VARCHAR2_TABLE_100();
93: a7 := JTF_NUMBER_TABLE();
94: a8 := JTF_NUMBER_TABLE();
95: a9 := JTF_NUMBER_TABLE();
96: a10 := JTF_NUMBER_TABLE();
97: a11 := JTF_VARCHAR2_TABLE_100();
98: if t.count > 0 then
99: a0.extend(t.count);

Line 96: a10 := JTF_NUMBER_TABLE();

92: a6 := JTF_VARCHAR2_TABLE_100();
93: a7 := JTF_NUMBER_TABLE();
94: a8 := JTF_NUMBER_TABLE();
95: a9 := JTF_NUMBER_TABLE();
96: a10 := JTF_NUMBER_TABLE();
97: a11 := JTF_VARCHAR2_TABLE_100();
98: if t.count > 0 then
99: a0.extend(t.count);
100: a1.extend(t.count);

Line 136: procedure rosetta_table_copy_in_p3(t out nocopy ahl_fmp_pvt.applicable_mr_tbl_type, a0 JTF_NUMBER_TABLE

132: end if;
133: end if;
134: end rosetta_table_copy_out_p1;
135:
136: procedure rosetta_table_copy_in_p3(t out nocopy ahl_fmp_pvt.applicable_mr_tbl_type, a0 JTF_NUMBER_TABLE
137: , a1 JTF_NUMBER_TABLE
138: , a2 JTF_NUMBER_TABLE
139: , a3 JTF_VARCHAR2_TABLE_100
140: , a4 JTF_VARCHAR2_TABLE_100

Line 137: , a1 JTF_NUMBER_TABLE

133: end if;
134: end rosetta_table_copy_out_p1;
135:
136: procedure rosetta_table_copy_in_p3(t out nocopy ahl_fmp_pvt.applicable_mr_tbl_type, a0 JTF_NUMBER_TABLE
137: , a1 JTF_NUMBER_TABLE
138: , a2 JTF_NUMBER_TABLE
139: , a3 JTF_VARCHAR2_TABLE_100
140: , a4 JTF_VARCHAR2_TABLE_100
141: , a5 JTF_NUMBER_TABLE

Line 138: , a2 JTF_NUMBER_TABLE

134: end rosetta_table_copy_out_p1;
135:
136: procedure rosetta_table_copy_in_p3(t out nocopy ahl_fmp_pvt.applicable_mr_tbl_type, a0 JTF_NUMBER_TABLE
137: , a1 JTF_NUMBER_TABLE
138: , a2 JTF_NUMBER_TABLE
139: , a3 JTF_VARCHAR2_TABLE_100
140: , a4 JTF_VARCHAR2_TABLE_100
141: , a5 JTF_NUMBER_TABLE
142: , a6 JTF_VARCHAR2_TABLE_100

Line 141: , a5 JTF_NUMBER_TABLE

137: , a1 JTF_NUMBER_TABLE
138: , a2 JTF_NUMBER_TABLE
139: , a3 JTF_VARCHAR2_TABLE_100
140: , a4 JTF_VARCHAR2_TABLE_100
141: , a5 JTF_NUMBER_TABLE
142: , a6 JTF_VARCHAR2_TABLE_100
143: , a7 JTF_VARCHAR2_TABLE_100
144: , a8 JTF_NUMBER_TABLE
145: , a9 JTF_VARCHAR2_TABLE_100

Line 144: , a8 JTF_NUMBER_TABLE

140: , a4 JTF_VARCHAR2_TABLE_100
141: , a5 JTF_NUMBER_TABLE
142: , a6 JTF_VARCHAR2_TABLE_100
143: , a7 JTF_VARCHAR2_TABLE_100
144: , a8 JTF_NUMBER_TABLE
145: , a9 JTF_VARCHAR2_TABLE_100
146: , a10 JTF_NUMBER_TABLE
147: , a11 JTF_NUMBER_TABLE
148: ) as

Line 146: , a10 JTF_NUMBER_TABLE

142: , a6 JTF_VARCHAR2_TABLE_100
143: , a7 JTF_VARCHAR2_TABLE_100
144: , a8 JTF_NUMBER_TABLE
145: , a9 JTF_VARCHAR2_TABLE_100
146: , a10 JTF_NUMBER_TABLE
147: , a11 JTF_NUMBER_TABLE
148: ) as
149: ddindx binary_integer; indx binary_integer;
150: begin

Line 147: , a11 JTF_NUMBER_TABLE

143: , a7 JTF_VARCHAR2_TABLE_100
144: , a8 JTF_NUMBER_TABLE
145: , a9 JTF_VARCHAR2_TABLE_100
146: , a10 JTF_NUMBER_TABLE
147: , a11 JTF_NUMBER_TABLE
148: ) as
149: ddindx binary_integer; indx binary_integer;
150: begin
151: if a0 is not null and a0.count > 0 then

Line 177: procedure rosetta_table_copy_out_p3(t ahl_fmp_pvt.applicable_mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

173: end loop;
174: end if;
175: end if;
176: end rosetta_table_copy_in_p3;
177: procedure rosetta_table_copy_out_p3(t ahl_fmp_pvt.applicable_mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
178: , a1 out nocopy JTF_NUMBER_TABLE
179: , a2 out nocopy JTF_NUMBER_TABLE
180: , a3 out nocopy JTF_VARCHAR2_TABLE_100
181: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 178: , a1 out nocopy JTF_NUMBER_TABLE

174: end if;
175: end if;
176: end rosetta_table_copy_in_p3;
177: procedure rosetta_table_copy_out_p3(t ahl_fmp_pvt.applicable_mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
178: , a1 out nocopy JTF_NUMBER_TABLE
179: , a2 out nocopy JTF_NUMBER_TABLE
180: , a3 out nocopy JTF_VARCHAR2_TABLE_100
181: , a4 out nocopy JTF_VARCHAR2_TABLE_100
182: , a5 out nocopy JTF_NUMBER_TABLE

Line 179: , a2 out nocopy JTF_NUMBER_TABLE

175: end if;
176: end rosetta_table_copy_in_p3;
177: procedure rosetta_table_copy_out_p3(t ahl_fmp_pvt.applicable_mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
178: , a1 out nocopy JTF_NUMBER_TABLE
179: , a2 out nocopy JTF_NUMBER_TABLE
180: , a3 out nocopy JTF_VARCHAR2_TABLE_100
181: , a4 out nocopy JTF_VARCHAR2_TABLE_100
182: , a5 out nocopy JTF_NUMBER_TABLE
183: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 182: , a5 out nocopy JTF_NUMBER_TABLE

178: , a1 out nocopy JTF_NUMBER_TABLE
179: , a2 out nocopy JTF_NUMBER_TABLE
180: , a3 out nocopy JTF_VARCHAR2_TABLE_100
181: , a4 out nocopy JTF_VARCHAR2_TABLE_100
182: , a5 out nocopy JTF_NUMBER_TABLE
183: , a6 out nocopy JTF_VARCHAR2_TABLE_100
184: , a7 out nocopy JTF_VARCHAR2_TABLE_100
185: , a8 out nocopy JTF_NUMBER_TABLE
186: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 185: , a8 out nocopy JTF_NUMBER_TABLE

181: , a4 out nocopy JTF_VARCHAR2_TABLE_100
182: , a5 out nocopy JTF_NUMBER_TABLE
183: , a6 out nocopy JTF_VARCHAR2_TABLE_100
184: , a7 out nocopy JTF_VARCHAR2_TABLE_100
185: , a8 out nocopy JTF_NUMBER_TABLE
186: , a9 out nocopy JTF_VARCHAR2_TABLE_100
187: , a10 out nocopy JTF_NUMBER_TABLE
188: , a11 out nocopy JTF_NUMBER_TABLE
189: ) as

Line 187: , a10 out nocopy JTF_NUMBER_TABLE

183: , a6 out nocopy JTF_VARCHAR2_TABLE_100
184: , a7 out nocopy JTF_VARCHAR2_TABLE_100
185: , a8 out nocopy JTF_NUMBER_TABLE
186: , a9 out nocopy JTF_VARCHAR2_TABLE_100
187: , a10 out nocopy JTF_NUMBER_TABLE
188: , a11 out nocopy JTF_NUMBER_TABLE
189: ) as
190: ddindx binary_integer; indx binary_integer;
191: begin

Line 188: , a11 out nocopy JTF_NUMBER_TABLE

184: , a7 out nocopy JTF_VARCHAR2_TABLE_100
185: , a8 out nocopy JTF_NUMBER_TABLE
186: , a9 out nocopy JTF_VARCHAR2_TABLE_100
187: , a10 out nocopy JTF_NUMBER_TABLE
188: , a11 out nocopy JTF_NUMBER_TABLE
189: ) as
190: ddindx binary_integer; indx binary_integer;
191: begin
192: if t is null or t.count = 0 then

Line 193: a0 := JTF_NUMBER_TABLE();

189: ) as
190: ddindx binary_integer; indx binary_integer;
191: begin
192: if t is null or t.count = 0 then
193: a0 := JTF_NUMBER_TABLE();
194: a1 := JTF_NUMBER_TABLE();
195: a2 := JTF_NUMBER_TABLE();
196: a3 := JTF_VARCHAR2_TABLE_100();
197: a4 := JTF_VARCHAR2_TABLE_100();

Line 194: a1 := JTF_NUMBER_TABLE();

190: ddindx binary_integer; indx binary_integer;
191: begin
192: if t is null or t.count = 0 then
193: a0 := JTF_NUMBER_TABLE();
194: a1 := JTF_NUMBER_TABLE();
195: a2 := JTF_NUMBER_TABLE();
196: a3 := JTF_VARCHAR2_TABLE_100();
197: a4 := JTF_VARCHAR2_TABLE_100();
198: a5 := JTF_NUMBER_TABLE();

Line 195: a2 := JTF_NUMBER_TABLE();

191: begin
192: if t is null or t.count = 0 then
193: a0 := JTF_NUMBER_TABLE();
194: a1 := JTF_NUMBER_TABLE();
195: a2 := JTF_NUMBER_TABLE();
196: a3 := JTF_VARCHAR2_TABLE_100();
197: a4 := JTF_VARCHAR2_TABLE_100();
198: a5 := JTF_NUMBER_TABLE();
199: a6 := JTF_VARCHAR2_TABLE_100();

Line 198: a5 := JTF_NUMBER_TABLE();

194: a1 := JTF_NUMBER_TABLE();
195: a2 := JTF_NUMBER_TABLE();
196: a3 := JTF_VARCHAR2_TABLE_100();
197: a4 := JTF_VARCHAR2_TABLE_100();
198: a5 := JTF_NUMBER_TABLE();
199: a6 := JTF_VARCHAR2_TABLE_100();
200: a7 := JTF_VARCHAR2_TABLE_100();
201: a8 := JTF_NUMBER_TABLE();
202: a9 := JTF_VARCHAR2_TABLE_100();

Line 201: a8 := JTF_NUMBER_TABLE();

197: a4 := JTF_VARCHAR2_TABLE_100();
198: a5 := JTF_NUMBER_TABLE();
199: a6 := JTF_VARCHAR2_TABLE_100();
200: a7 := JTF_VARCHAR2_TABLE_100();
201: a8 := JTF_NUMBER_TABLE();
202: a9 := JTF_VARCHAR2_TABLE_100();
203: a10 := JTF_NUMBER_TABLE();
204: a11 := JTF_NUMBER_TABLE();
205: else

Line 203: a10 := JTF_NUMBER_TABLE();

199: a6 := JTF_VARCHAR2_TABLE_100();
200: a7 := JTF_VARCHAR2_TABLE_100();
201: a8 := JTF_NUMBER_TABLE();
202: a9 := JTF_VARCHAR2_TABLE_100();
203: a10 := JTF_NUMBER_TABLE();
204: a11 := JTF_NUMBER_TABLE();
205: else
206: a0 := JTF_NUMBER_TABLE();
207: a1 := JTF_NUMBER_TABLE();

Line 204: a11 := JTF_NUMBER_TABLE();

200: a7 := JTF_VARCHAR2_TABLE_100();
201: a8 := JTF_NUMBER_TABLE();
202: a9 := JTF_VARCHAR2_TABLE_100();
203: a10 := JTF_NUMBER_TABLE();
204: a11 := JTF_NUMBER_TABLE();
205: else
206: a0 := JTF_NUMBER_TABLE();
207: a1 := JTF_NUMBER_TABLE();
208: a2 := JTF_NUMBER_TABLE();

Line 206: a0 := JTF_NUMBER_TABLE();

202: a9 := JTF_VARCHAR2_TABLE_100();
203: a10 := JTF_NUMBER_TABLE();
204: a11 := JTF_NUMBER_TABLE();
205: else
206: a0 := JTF_NUMBER_TABLE();
207: a1 := JTF_NUMBER_TABLE();
208: a2 := JTF_NUMBER_TABLE();
209: a3 := JTF_VARCHAR2_TABLE_100();
210: a4 := JTF_VARCHAR2_TABLE_100();

Line 207: a1 := JTF_NUMBER_TABLE();

203: a10 := JTF_NUMBER_TABLE();
204: a11 := JTF_NUMBER_TABLE();
205: else
206: a0 := JTF_NUMBER_TABLE();
207: a1 := JTF_NUMBER_TABLE();
208: a2 := JTF_NUMBER_TABLE();
209: a3 := JTF_VARCHAR2_TABLE_100();
210: a4 := JTF_VARCHAR2_TABLE_100();
211: a5 := JTF_NUMBER_TABLE();

Line 208: a2 := JTF_NUMBER_TABLE();

204: a11 := JTF_NUMBER_TABLE();
205: else
206: a0 := JTF_NUMBER_TABLE();
207: a1 := JTF_NUMBER_TABLE();
208: a2 := JTF_NUMBER_TABLE();
209: a3 := JTF_VARCHAR2_TABLE_100();
210: a4 := JTF_VARCHAR2_TABLE_100();
211: a5 := JTF_NUMBER_TABLE();
212: a6 := JTF_VARCHAR2_TABLE_100();

Line 211: a5 := JTF_NUMBER_TABLE();

207: a1 := JTF_NUMBER_TABLE();
208: a2 := JTF_NUMBER_TABLE();
209: a3 := JTF_VARCHAR2_TABLE_100();
210: a4 := JTF_VARCHAR2_TABLE_100();
211: a5 := JTF_NUMBER_TABLE();
212: a6 := JTF_VARCHAR2_TABLE_100();
213: a7 := JTF_VARCHAR2_TABLE_100();
214: a8 := JTF_NUMBER_TABLE();
215: a9 := JTF_VARCHAR2_TABLE_100();

Line 214: a8 := JTF_NUMBER_TABLE();

210: a4 := JTF_VARCHAR2_TABLE_100();
211: a5 := JTF_NUMBER_TABLE();
212: a6 := JTF_VARCHAR2_TABLE_100();
213: a7 := JTF_VARCHAR2_TABLE_100();
214: a8 := JTF_NUMBER_TABLE();
215: a9 := JTF_VARCHAR2_TABLE_100();
216: a10 := JTF_NUMBER_TABLE();
217: a11 := JTF_NUMBER_TABLE();
218: if t.count > 0 then

Line 216: a10 := JTF_NUMBER_TABLE();

212: a6 := JTF_VARCHAR2_TABLE_100();
213: a7 := JTF_VARCHAR2_TABLE_100();
214: a8 := JTF_NUMBER_TABLE();
215: a9 := JTF_VARCHAR2_TABLE_100();
216: a10 := JTF_NUMBER_TABLE();
217: a11 := JTF_NUMBER_TABLE();
218: if t.count > 0 then
219: a0.extend(t.count);
220: a1.extend(t.count);

Line 217: a11 := JTF_NUMBER_TABLE();

213: a7 := JTF_VARCHAR2_TABLE_100();
214: a8 := JTF_NUMBER_TABLE();
215: a9 := JTF_VARCHAR2_TABLE_100();
216: a10 := JTF_NUMBER_TABLE();
217: a11 := JTF_NUMBER_TABLE();
218: if t.count > 0 then
219: a0.extend(t.count);
220: a1.extend(t.count);
221: a2.extend(t.count);

Line 256: procedure rosetta_table_copy_in_p5(t out nocopy ahl_fmp_pvt.applicable_activities_tbl_type, a0 JTF_NUMBER_TABLE

252: end if;
253: end if;
254: end rosetta_table_copy_out_p3;
255:
256: procedure rosetta_table_copy_in_p5(t out nocopy ahl_fmp_pvt.applicable_activities_tbl_type, a0 JTF_NUMBER_TABLE
257: , a1 JTF_NUMBER_TABLE
258: , a2 JTF_NUMBER_TABLE
259: , a3 JTF_NUMBER_TABLE
260: , a4 JTF_NUMBER_TABLE

Line 257: , a1 JTF_NUMBER_TABLE

253: end if;
254: end rosetta_table_copy_out_p3;
255:
256: procedure rosetta_table_copy_in_p5(t out nocopy ahl_fmp_pvt.applicable_activities_tbl_type, a0 JTF_NUMBER_TABLE
257: , a1 JTF_NUMBER_TABLE
258: , a2 JTF_NUMBER_TABLE
259: , a3 JTF_NUMBER_TABLE
260: , a4 JTF_NUMBER_TABLE
261: , a5 JTF_VARCHAR2_TABLE_100

Line 258: , a2 JTF_NUMBER_TABLE

254: end rosetta_table_copy_out_p3;
255:
256: procedure rosetta_table_copy_in_p5(t out nocopy ahl_fmp_pvt.applicable_activities_tbl_type, a0 JTF_NUMBER_TABLE
257: , a1 JTF_NUMBER_TABLE
258: , a2 JTF_NUMBER_TABLE
259: , a3 JTF_NUMBER_TABLE
260: , a4 JTF_NUMBER_TABLE
261: , a5 JTF_VARCHAR2_TABLE_100
262: , a6 JTF_VARCHAR2_TABLE_100

Line 259: , a3 JTF_NUMBER_TABLE

255:
256: procedure rosetta_table_copy_in_p5(t out nocopy ahl_fmp_pvt.applicable_activities_tbl_type, a0 JTF_NUMBER_TABLE
257: , a1 JTF_NUMBER_TABLE
258: , a2 JTF_NUMBER_TABLE
259: , a3 JTF_NUMBER_TABLE
260: , a4 JTF_NUMBER_TABLE
261: , a5 JTF_VARCHAR2_TABLE_100
262: , a6 JTF_VARCHAR2_TABLE_100
263: , a7 JTF_VARCHAR2_TABLE_100

Line 260: , a4 JTF_NUMBER_TABLE

256: procedure rosetta_table_copy_in_p5(t out nocopy ahl_fmp_pvt.applicable_activities_tbl_type, a0 JTF_NUMBER_TABLE
257: , a1 JTF_NUMBER_TABLE
258: , a2 JTF_NUMBER_TABLE
259: , a3 JTF_NUMBER_TABLE
260: , a4 JTF_NUMBER_TABLE
261: , a5 JTF_VARCHAR2_TABLE_100
262: , a6 JTF_VARCHAR2_TABLE_100
263: , a7 JTF_VARCHAR2_TABLE_100
264: , a8 JTF_VARCHAR2_TABLE_100

Line 293: procedure rosetta_table_copy_out_p5(t ahl_fmp_pvt.applicable_activities_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

289: end loop;
290: end if;
291: end if;
292: end rosetta_table_copy_in_p5;
293: procedure rosetta_table_copy_out_p5(t ahl_fmp_pvt.applicable_activities_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
294: , a1 out nocopy JTF_NUMBER_TABLE
295: , a2 out nocopy JTF_NUMBER_TABLE
296: , a3 out nocopy JTF_NUMBER_TABLE
297: , a4 out nocopy JTF_NUMBER_TABLE

Line 294: , a1 out nocopy JTF_NUMBER_TABLE

290: end if;
291: end if;
292: end rosetta_table_copy_in_p5;
293: procedure rosetta_table_copy_out_p5(t ahl_fmp_pvt.applicable_activities_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
294: , a1 out nocopy JTF_NUMBER_TABLE
295: , a2 out nocopy JTF_NUMBER_TABLE
296: , a3 out nocopy JTF_NUMBER_TABLE
297: , a4 out nocopy JTF_NUMBER_TABLE
298: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 295: , a2 out nocopy JTF_NUMBER_TABLE

291: end if;
292: end rosetta_table_copy_in_p5;
293: procedure rosetta_table_copy_out_p5(t ahl_fmp_pvt.applicable_activities_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
294: , a1 out nocopy JTF_NUMBER_TABLE
295: , a2 out nocopy JTF_NUMBER_TABLE
296: , a3 out nocopy JTF_NUMBER_TABLE
297: , a4 out nocopy JTF_NUMBER_TABLE
298: , a5 out nocopy JTF_VARCHAR2_TABLE_100
299: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 296: , a3 out nocopy JTF_NUMBER_TABLE

292: end rosetta_table_copy_in_p5;
293: procedure rosetta_table_copy_out_p5(t ahl_fmp_pvt.applicable_activities_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
294: , a1 out nocopy JTF_NUMBER_TABLE
295: , a2 out nocopy JTF_NUMBER_TABLE
296: , a3 out nocopy JTF_NUMBER_TABLE
297: , a4 out nocopy JTF_NUMBER_TABLE
298: , a5 out nocopy JTF_VARCHAR2_TABLE_100
299: , a6 out nocopy JTF_VARCHAR2_TABLE_100
300: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 297: , a4 out nocopy JTF_NUMBER_TABLE

293: procedure rosetta_table_copy_out_p5(t ahl_fmp_pvt.applicable_activities_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
294: , a1 out nocopy JTF_NUMBER_TABLE
295: , a2 out nocopy JTF_NUMBER_TABLE
296: , a3 out nocopy JTF_NUMBER_TABLE
297: , a4 out nocopy JTF_NUMBER_TABLE
298: , a5 out nocopy JTF_VARCHAR2_TABLE_100
299: , a6 out nocopy JTF_VARCHAR2_TABLE_100
300: , a7 out nocopy JTF_VARCHAR2_TABLE_100
301: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 307: a0 := JTF_NUMBER_TABLE();

303: ) as
304: ddindx binary_integer; indx binary_integer;
305: begin
306: if t is null or t.count = 0 then
307: a0 := JTF_NUMBER_TABLE();
308: a1 := JTF_NUMBER_TABLE();
309: a2 := JTF_NUMBER_TABLE();
310: a3 := JTF_NUMBER_TABLE();
311: a4 := JTF_NUMBER_TABLE();

Line 308: a1 := JTF_NUMBER_TABLE();

304: ddindx binary_integer; indx binary_integer;
305: begin
306: if t is null or t.count = 0 then
307: a0 := JTF_NUMBER_TABLE();
308: a1 := JTF_NUMBER_TABLE();
309: a2 := JTF_NUMBER_TABLE();
310: a3 := JTF_NUMBER_TABLE();
311: a4 := JTF_NUMBER_TABLE();
312: a5 := JTF_VARCHAR2_TABLE_100();

Line 309: a2 := JTF_NUMBER_TABLE();

305: begin
306: if t is null or t.count = 0 then
307: a0 := JTF_NUMBER_TABLE();
308: a1 := JTF_NUMBER_TABLE();
309: a2 := JTF_NUMBER_TABLE();
310: a3 := JTF_NUMBER_TABLE();
311: a4 := JTF_NUMBER_TABLE();
312: a5 := JTF_VARCHAR2_TABLE_100();
313: a6 := JTF_VARCHAR2_TABLE_100();

Line 310: a3 := JTF_NUMBER_TABLE();

306: if t is null or t.count = 0 then
307: a0 := JTF_NUMBER_TABLE();
308: a1 := JTF_NUMBER_TABLE();
309: a2 := JTF_NUMBER_TABLE();
310: a3 := JTF_NUMBER_TABLE();
311: a4 := JTF_NUMBER_TABLE();
312: a5 := JTF_VARCHAR2_TABLE_100();
313: a6 := JTF_VARCHAR2_TABLE_100();
314: a7 := JTF_VARCHAR2_TABLE_100();

Line 311: a4 := JTF_NUMBER_TABLE();

307: a0 := JTF_NUMBER_TABLE();
308: a1 := JTF_NUMBER_TABLE();
309: a2 := JTF_NUMBER_TABLE();
310: a3 := JTF_NUMBER_TABLE();
311: a4 := JTF_NUMBER_TABLE();
312: a5 := JTF_VARCHAR2_TABLE_100();
313: a6 := JTF_VARCHAR2_TABLE_100();
314: a7 := JTF_VARCHAR2_TABLE_100();
315: a8 := JTF_VARCHAR2_TABLE_100();

Line 318: a0 := JTF_NUMBER_TABLE();

314: a7 := JTF_VARCHAR2_TABLE_100();
315: a8 := JTF_VARCHAR2_TABLE_100();
316: a9 := JTF_VARCHAR2_TABLE_100();
317: else
318: a0 := JTF_NUMBER_TABLE();
319: a1 := JTF_NUMBER_TABLE();
320: a2 := JTF_NUMBER_TABLE();
321: a3 := JTF_NUMBER_TABLE();
322: a4 := JTF_NUMBER_TABLE();

Line 319: a1 := JTF_NUMBER_TABLE();

315: a8 := JTF_VARCHAR2_TABLE_100();
316: a9 := JTF_VARCHAR2_TABLE_100();
317: else
318: a0 := JTF_NUMBER_TABLE();
319: a1 := JTF_NUMBER_TABLE();
320: a2 := JTF_NUMBER_TABLE();
321: a3 := JTF_NUMBER_TABLE();
322: a4 := JTF_NUMBER_TABLE();
323: a5 := JTF_VARCHAR2_TABLE_100();

Line 320: a2 := JTF_NUMBER_TABLE();

316: a9 := JTF_VARCHAR2_TABLE_100();
317: else
318: a0 := JTF_NUMBER_TABLE();
319: a1 := JTF_NUMBER_TABLE();
320: a2 := JTF_NUMBER_TABLE();
321: a3 := JTF_NUMBER_TABLE();
322: a4 := JTF_NUMBER_TABLE();
323: a5 := JTF_VARCHAR2_TABLE_100();
324: a6 := JTF_VARCHAR2_TABLE_100();

Line 321: a3 := JTF_NUMBER_TABLE();

317: else
318: a0 := JTF_NUMBER_TABLE();
319: a1 := JTF_NUMBER_TABLE();
320: a2 := JTF_NUMBER_TABLE();
321: a3 := JTF_NUMBER_TABLE();
322: a4 := JTF_NUMBER_TABLE();
323: a5 := JTF_VARCHAR2_TABLE_100();
324: a6 := JTF_VARCHAR2_TABLE_100();
325: a7 := JTF_VARCHAR2_TABLE_100();

Line 322: a4 := JTF_NUMBER_TABLE();

318: a0 := JTF_NUMBER_TABLE();
319: a1 := JTF_NUMBER_TABLE();
320: a2 := JTF_NUMBER_TABLE();
321: a3 := JTF_NUMBER_TABLE();
322: a4 := JTF_NUMBER_TABLE();
323: a5 := JTF_VARCHAR2_TABLE_100();
324: a6 := JTF_VARCHAR2_TABLE_100();
325: a7 := JTF_VARCHAR2_TABLE_100();
326: a8 := JTF_VARCHAR2_TABLE_100();

Line 362: procedure rosetta_table_copy_in_p7(t out nocopy ahl_fmp_pvt.applicable_programs_tbl_type, a0 JTF_NUMBER_TABLE

358: end if;
359: end if;
360: end rosetta_table_copy_out_p5;
361:
362: procedure rosetta_table_copy_in_p7(t out nocopy ahl_fmp_pvt.applicable_programs_tbl_type, a0 JTF_NUMBER_TABLE
363: , a1 JTF_VARCHAR2_TABLE_200
364: , a2 JTF_VARCHAR2_TABLE_200
365: , a3 JTF_VARCHAR2_TABLE_100
366: , a4 JTF_NUMBER_TABLE

Line 366: , a4 JTF_NUMBER_TABLE

362: procedure rosetta_table_copy_in_p7(t out nocopy ahl_fmp_pvt.applicable_programs_tbl_type, a0 JTF_NUMBER_TABLE
363: , a1 JTF_VARCHAR2_TABLE_200
364: , a2 JTF_VARCHAR2_TABLE_200
365: , a3 JTF_VARCHAR2_TABLE_100
366: , a4 JTF_NUMBER_TABLE
367: , a5 JTF_VARCHAR2_TABLE_300
368: , a6 JTF_VARCHAR2_TABLE_300
369: , a7 JTF_NUMBER_TABLE
370: , a8 JTF_VARCHAR2_TABLE_200

Line 369: , a7 JTF_NUMBER_TABLE

365: , a3 JTF_VARCHAR2_TABLE_100
366: , a4 JTF_NUMBER_TABLE
367: , a5 JTF_VARCHAR2_TABLE_300
368: , a6 JTF_VARCHAR2_TABLE_300
369: , a7 JTF_NUMBER_TABLE
370: , a8 JTF_VARCHAR2_TABLE_200
371: , a9 JTF_VARCHAR2_TABLE_2000
372: , a10 JTF_VARCHAR2_TABLE_100
373: , a11 JTF_VARCHAR2_TABLE_100

Line 374: , a12 JTF_NUMBER_TABLE

370: , a8 JTF_VARCHAR2_TABLE_200
371: , a9 JTF_VARCHAR2_TABLE_2000
372: , a10 JTF_VARCHAR2_TABLE_100
373: , a11 JTF_VARCHAR2_TABLE_100
374: , a12 JTF_NUMBER_TABLE
375: , a13 JTF_DATE_TABLE
376: , a14 JTF_DATE_TABLE
377: , a15 JTF_VARCHAR2_TABLE_100
378: , a16 JTF_VARCHAR2_TABLE_100

Line 386: , a24 JTF_NUMBER_TABLE

382: , a20 JTF_VARCHAR2_TABLE_2000
383: , a21 JTF_DATE_TABLE
384: , a22 JTF_VARCHAR2_TABLE_100
385: , a23 JTF_VARCHAR2_TABLE_500
386: , a24 JTF_NUMBER_TABLE
387: ) as
388: ddindx binary_integer; indx binary_integer;
389: begin
390: if a0 is not null and a0.count > 0 then

Line 429: procedure rosetta_table_copy_out_p7(t ahl_fmp_pvt.applicable_programs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

425: end loop;
426: end if;
427: end if;
428: end rosetta_table_copy_in_p7;
429: procedure rosetta_table_copy_out_p7(t ahl_fmp_pvt.applicable_programs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
430: , a1 out nocopy JTF_VARCHAR2_TABLE_200
431: , a2 out nocopy JTF_VARCHAR2_TABLE_200
432: , a3 out nocopy JTF_VARCHAR2_TABLE_100
433: , a4 out nocopy JTF_NUMBER_TABLE

Line 433: , a4 out nocopy JTF_NUMBER_TABLE

429: procedure rosetta_table_copy_out_p7(t ahl_fmp_pvt.applicable_programs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
430: , a1 out nocopy JTF_VARCHAR2_TABLE_200
431: , a2 out nocopy JTF_VARCHAR2_TABLE_200
432: , a3 out nocopy JTF_VARCHAR2_TABLE_100
433: , a4 out nocopy JTF_NUMBER_TABLE
434: , a5 out nocopy JTF_VARCHAR2_TABLE_300
435: , a6 out nocopy JTF_VARCHAR2_TABLE_300
436: , a7 out nocopy JTF_NUMBER_TABLE
437: , a8 out nocopy JTF_VARCHAR2_TABLE_200

Line 436: , a7 out nocopy JTF_NUMBER_TABLE

432: , a3 out nocopy JTF_VARCHAR2_TABLE_100
433: , a4 out nocopy JTF_NUMBER_TABLE
434: , a5 out nocopy JTF_VARCHAR2_TABLE_300
435: , a6 out nocopy JTF_VARCHAR2_TABLE_300
436: , a7 out nocopy JTF_NUMBER_TABLE
437: , a8 out nocopy JTF_VARCHAR2_TABLE_200
438: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
439: , a10 out nocopy JTF_VARCHAR2_TABLE_100
440: , a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 441: , a12 out nocopy JTF_NUMBER_TABLE

437: , a8 out nocopy JTF_VARCHAR2_TABLE_200
438: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
439: , a10 out nocopy JTF_VARCHAR2_TABLE_100
440: , a11 out nocopy JTF_VARCHAR2_TABLE_100
441: , a12 out nocopy JTF_NUMBER_TABLE
442: , a13 out nocopy JTF_DATE_TABLE
443: , a14 out nocopy JTF_DATE_TABLE
444: , a15 out nocopy JTF_VARCHAR2_TABLE_100
445: , a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 453: , a24 out nocopy JTF_NUMBER_TABLE

449: , a20 out nocopy JTF_VARCHAR2_TABLE_2000
450: , a21 out nocopy JTF_DATE_TABLE
451: , a22 out nocopy JTF_VARCHAR2_TABLE_100
452: , a23 out nocopy JTF_VARCHAR2_TABLE_500
453: , a24 out nocopy JTF_NUMBER_TABLE
454: ) as
455: ddindx binary_integer; indx binary_integer;
456: begin
457: if t is null or t.count = 0 then

Line 458: a0 := JTF_NUMBER_TABLE();

454: ) as
455: ddindx binary_integer; indx binary_integer;
456: begin
457: if t is null or t.count = 0 then
458: a0 := JTF_NUMBER_TABLE();
459: a1 := JTF_VARCHAR2_TABLE_200();
460: a2 := JTF_VARCHAR2_TABLE_200();
461: a3 := JTF_VARCHAR2_TABLE_100();
462: a4 := JTF_NUMBER_TABLE();

Line 462: a4 := JTF_NUMBER_TABLE();

458: a0 := JTF_NUMBER_TABLE();
459: a1 := JTF_VARCHAR2_TABLE_200();
460: a2 := JTF_VARCHAR2_TABLE_200();
461: a3 := JTF_VARCHAR2_TABLE_100();
462: a4 := JTF_NUMBER_TABLE();
463: a5 := JTF_VARCHAR2_TABLE_300();
464: a6 := JTF_VARCHAR2_TABLE_300();
465: a7 := JTF_NUMBER_TABLE();
466: a8 := JTF_VARCHAR2_TABLE_200();

Line 465: a7 := JTF_NUMBER_TABLE();

461: a3 := JTF_VARCHAR2_TABLE_100();
462: a4 := JTF_NUMBER_TABLE();
463: a5 := JTF_VARCHAR2_TABLE_300();
464: a6 := JTF_VARCHAR2_TABLE_300();
465: a7 := JTF_NUMBER_TABLE();
466: a8 := JTF_VARCHAR2_TABLE_200();
467: a9 := JTF_VARCHAR2_TABLE_2000();
468: a10 := JTF_VARCHAR2_TABLE_100();
469: a11 := JTF_VARCHAR2_TABLE_100();

Line 470: a12 := JTF_NUMBER_TABLE();

466: a8 := JTF_VARCHAR2_TABLE_200();
467: a9 := JTF_VARCHAR2_TABLE_2000();
468: a10 := JTF_VARCHAR2_TABLE_100();
469: a11 := JTF_VARCHAR2_TABLE_100();
470: a12 := JTF_NUMBER_TABLE();
471: a13 := JTF_DATE_TABLE();
472: a14 := JTF_DATE_TABLE();
473: a15 := JTF_VARCHAR2_TABLE_100();
474: a16 := JTF_VARCHAR2_TABLE_100();

Line 482: a24 := JTF_NUMBER_TABLE();

478: a20 := JTF_VARCHAR2_TABLE_2000();
479: a21 := JTF_DATE_TABLE();
480: a22 := JTF_VARCHAR2_TABLE_100();
481: a23 := JTF_VARCHAR2_TABLE_500();
482: a24 := JTF_NUMBER_TABLE();
483: else
484: a0 := JTF_NUMBER_TABLE();
485: a1 := JTF_VARCHAR2_TABLE_200();
486: a2 := JTF_VARCHAR2_TABLE_200();

Line 484: a0 := JTF_NUMBER_TABLE();

480: a22 := JTF_VARCHAR2_TABLE_100();
481: a23 := JTF_VARCHAR2_TABLE_500();
482: a24 := JTF_NUMBER_TABLE();
483: else
484: a0 := JTF_NUMBER_TABLE();
485: a1 := JTF_VARCHAR2_TABLE_200();
486: a2 := JTF_VARCHAR2_TABLE_200();
487: a3 := JTF_VARCHAR2_TABLE_100();
488: a4 := JTF_NUMBER_TABLE();

Line 488: a4 := JTF_NUMBER_TABLE();

484: a0 := JTF_NUMBER_TABLE();
485: a1 := JTF_VARCHAR2_TABLE_200();
486: a2 := JTF_VARCHAR2_TABLE_200();
487: a3 := JTF_VARCHAR2_TABLE_100();
488: a4 := JTF_NUMBER_TABLE();
489: a5 := JTF_VARCHAR2_TABLE_300();
490: a6 := JTF_VARCHAR2_TABLE_300();
491: a7 := JTF_NUMBER_TABLE();
492: a8 := JTF_VARCHAR2_TABLE_200();

Line 491: a7 := JTF_NUMBER_TABLE();

487: a3 := JTF_VARCHAR2_TABLE_100();
488: a4 := JTF_NUMBER_TABLE();
489: a5 := JTF_VARCHAR2_TABLE_300();
490: a6 := JTF_VARCHAR2_TABLE_300();
491: a7 := JTF_NUMBER_TABLE();
492: a8 := JTF_VARCHAR2_TABLE_200();
493: a9 := JTF_VARCHAR2_TABLE_2000();
494: a10 := JTF_VARCHAR2_TABLE_100();
495: a11 := JTF_VARCHAR2_TABLE_100();

Line 496: a12 := JTF_NUMBER_TABLE();

492: a8 := JTF_VARCHAR2_TABLE_200();
493: a9 := JTF_VARCHAR2_TABLE_2000();
494: a10 := JTF_VARCHAR2_TABLE_100();
495: a11 := JTF_VARCHAR2_TABLE_100();
496: a12 := JTF_NUMBER_TABLE();
497: a13 := JTF_DATE_TABLE();
498: a14 := JTF_DATE_TABLE();
499: a15 := JTF_VARCHAR2_TABLE_100();
500: a16 := JTF_VARCHAR2_TABLE_100();

Line 508: a24 := JTF_NUMBER_TABLE();

504: a20 := JTF_VARCHAR2_TABLE_2000();
505: a21 := JTF_DATE_TABLE();
506: a22 := JTF_VARCHAR2_TABLE_100();
507: a23 := JTF_VARCHAR2_TABLE_500();
508: a24 := JTF_NUMBER_TABLE();
509: if t.count > 0 then
510: a0.extend(t.count);
511: a1.extend(t.count);
512: a2.extend(t.count);

Line 594: , p14_a7 out nocopy JTF_NUMBER_TABLE

590: , p14_a3 out nocopy JTF_VARCHAR2_TABLE_100
591: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_400
592: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_300
593: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_100
594: , p14_a7 out nocopy JTF_NUMBER_TABLE
595: , p14_a8 out nocopy JTF_NUMBER_TABLE
596: , p14_a9 out nocopy JTF_NUMBER_TABLE
597: , p14_a10 out nocopy JTF_NUMBER_TABLE
598: , p14_a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 595: , p14_a8 out nocopy JTF_NUMBER_TABLE

591: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_400
592: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_300
593: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_100
594: , p14_a7 out nocopy JTF_NUMBER_TABLE
595: , p14_a8 out nocopy JTF_NUMBER_TABLE
596: , p14_a9 out nocopy JTF_NUMBER_TABLE
597: , p14_a10 out nocopy JTF_NUMBER_TABLE
598: , p14_a11 out nocopy JTF_VARCHAR2_TABLE_100
599: )

Line 596: , p14_a9 out nocopy JTF_NUMBER_TABLE

592: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_300
593: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_100
594: , p14_a7 out nocopy JTF_NUMBER_TABLE
595: , p14_a8 out nocopy JTF_NUMBER_TABLE
596: , p14_a9 out nocopy JTF_NUMBER_TABLE
597: , p14_a10 out nocopy JTF_NUMBER_TABLE
598: , p14_a11 out nocopy JTF_VARCHAR2_TABLE_100
599: )
600:

Line 597: , p14_a10 out nocopy JTF_NUMBER_TABLE

593: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_100
594: , p14_a7 out nocopy JTF_NUMBER_TABLE
595: , p14_a8 out nocopy JTF_NUMBER_TABLE
596: , p14_a9 out nocopy JTF_NUMBER_TABLE
597: , p14_a10 out nocopy JTF_NUMBER_TABLE
598: , p14_a11 out nocopy JTF_VARCHAR2_TABLE_100
599: )
600:
601: as

Line 686: , p15_a0 out nocopy JTF_NUMBER_TABLE

682: , p_visit_type_code VARCHAR2
683: , p_consider_fleet_flag VARCHAR2
684: , p_flt_range_calc_date date
685: , p_insert_into_tmp_tbl VARCHAR2
686: , p15_a0 out nocopy JTF_NUMBER_TABLE
687: , p15_a1 out nocopy JTF_NUMBER_TABLE
688: , p15_a2 out nocopy JTF_NUMBER_TABLE
689: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
690: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 687: , p15_a1 out nocopy JTF_NUMBER_TABLE

683: , p_consider_fleet_flag VARCHAR2
684: , p_flt_range_calc_date date
685: , p_insert_into_tmp_tbl VARCHAR2
686: , p15_a0 out nocopy JTF_NUMBER_TABLE
687: , p15_a1 out nocopy JTF_NUMBER_TABLE
688: , p15_a2 out nocopy JTF_NUMBER_TABLE
689: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
690: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_100
691: , p15_a5 out nocopy JTF_NUMBER_TABLE

Line 688: , p15_a2 out nocopy JTF_NUMBER_TABLE

684: , p_flt_range_calc_date date
685: , p_insert_into_tmp_tbl VARCHAR2
686: , p15_a0 out nocopy JTF_NUMBER_TABLE
687: , p15_a1 out nocopy JTF_NUMBER_TABLE
688: , p15_a2 out nocopy JTF_NUMBER_TABLE
689: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
690: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_100
691: , p15_a5 out nocopy JTF_NUMBER_TABLE
692: , p15_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 691: , p15_a5 out nocopy JTF_NUMBER_TABLE

687: , p15_a1 out nocopy JTF_NUMBER_TABLE
688: , p15_a2 out nocopy JTF_NUMBER_TABLE
689: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
690: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_100
691: , p15_a5 out nocopy JTF_NUMBER_TABLE
692: , p15_a6 out nocopy JTF_VARCHAR2_TABLE_100
693: , p15_a7 out nocopy JTF_VARCHAR2_TABLE_100
694: , p15_a8 out nocopy JTF_NUMBER_TABLE
695: , p15_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 694: , p15_a8 out nocopy JTF_NUMBER_TABLE

690: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_100
691: , p15_a5 out nocopy JTF_NUMBER_TABLE
692: , p15_a6 out nocopy JTF_VARCHAR2_TABLE_100
693: , p15_a7 out nocopy JTF_VARCHAR2_TABLE_100
694: , p15_a8 out nocopy JTF_NUMBER_TABLE
695: , p15_a9 out nocopy JTF_VARCHAR2_TABLE_100
696: , p15_a10 out nocopy JTF_NUMBER_TABLE
697: , p15_a11 out nocopy JTF_NUMBER_TABLE
698: )

Line 696: , p15_a10 out nocopy JTF_NUMBER_TABLE

692: , p15_a6 out nocopy JTF_VARCHAR2_TABLE_100
693: , p15_a7 out nocopy JTF_VARCHAR2_TABLE_100
694: , p15_a8 out nocopy JTF_NUMBER_TABLE
695: , p15_a9 out nocopy JTF_VARCHAR2_TABLE_100
696: , p15_a10 out nocopy JTF_NUMBER_TABLE
697: , p15_a11 out nocopy JTF_NUMBER_TABLE
698: )
699:
700: as

Line 697: , p15_a11 out nocopy JTF_NUMBER_TABLE

693: , p15_a7 out nocopy JTF_VARCHAR2_TABLE_100
694: , p15_a8 out nocopy JTF_NUMBER_TABLE
695: , p15_a9 out nocopy JTF_VARCHAR2_TABLE_100
696: , p15_a10 out nocopy JTF_NUMBER_TABLE
697: , p15_a11 out nocopy JTF_NUMBER_TABLE
698: )
699:
700: as
701: ddp_flt_range_calc_date date;

Line 781: , p8_a0 out nocopy JTF_NUMBER_TABLE

777: , x_return_status out nocopy VARCHAR2
778: , x_msg_count out nocopy NUMBER
779: , x_msg_data out nocopy VARCHAR2
780: , p_item_instance_id NUMBER
781: , p8_a0 out nocopy JTF_NUMBER_TABLE
782: , p8_a1 out nocopy JTF_NUMBER_TABLE
783: , p8_a2 out nocopy JTF_NUMBER_TABLE
784: , p8_a3 out nocopy JTF_NUMBER_TABLE
785: , p8_a4 out nocopy JTF_NUMBER_TABLE

Line 782: , p8_a1 out nocopy JTF_NUMBER_TABLE

778: , x_msg_count out nocopy NUMBER
779: , x_msg_data out nocopy VARCHAR2
780: , p_item_instance_id NUMBER
781: , p8_a0 out nocopy JTF_NUMBER_TABLE
782: , p8_a1 out nocopy JTF_NUMBER_TABLE
783: , p8_a2 out nocopy JTF_NUMBER_TABLE
784: , p8_a3 out nocopy JTF_NUMBER_TABLE
785: , p8_a4 out nocopy JTF_NUMBER_TABLE
786: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 783: , p8_a2 out nocopy JTF_NUMBER_TABLE

779: , x_msg_data out nocopy VARCHAR2
780: , p_item_instance_id NUMBER
781: , p8_a0 out nocopy JTF_NUMBER_TABLE
782: , p8_a1 out nocopy JTF_NUMBER_TABLE
783: , p8_a2 out nocopy JTF_NUMBER_TABLE
784: , p8_a3 out nocopy JTF_NUMBER_TABLE
785: , p8_a4 out nocopy JTF_NUMBER_TABLE
786: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
787: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 784: , p8_a3 out nocopy JTF_NUMBER_TABLE

780: , p_item_instance_id NUMBER
781: , p8_a0 out nocopy JTF_NUMBER_TABLE
782: , p8_a1 out nocopy JTF_NUMBER_TABLE
783: , p8_a2 out nocopy JTF_NUMBER_TABLE
784: , p8_a3 out nocopy JTF_NUMBER_TABLE
785: , p8_a4 out nocopy JTF_NUMBER_TABLE
786: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
787: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
788: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 785: , p8_a4 out nocopy JTF_NUMBER_TABLE

781: , p8_a0 out nocopy JTF_NUMBER_TABLE
782: , p8_a1 out nocopy JTF_NUMBER_TABLE
783: , p8_a2 out nocopy JTF_NUMBER_TABLE
784: , p8_a3 out nocopy JTF_NUMBER_TABLE
785: , p8_a4 out nocopy JTF_NUMBER_TABLE
786: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
787: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
788: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
789: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 791: , p9_a0 out nocopy JTF_NUMBER_TABLE

787: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
788: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
789: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
790: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
791: , p9_a0 out nocopy JTF_NUMBER_TABLE
792: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
793: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
794: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
795: , p9_a4 out nocopy JTF_NUMBER_TABLE

Line 795: , p9_a4 out nocopy JTF_NUMBER_TABLE

791: , p9_a0 out nocopy JTF_NUMBER_TABLE
792: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
793: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
794: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
795: , p9_a4 out nocopy JTF_NUMBER_TABLE
796: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
797: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_300
798: , p9_a7 out nocopy JTF_NUMBER_TABLE
799: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_200

Line 798: , p9_a7 out nocopy JTF_NUMBER_TABLE

794: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
795: , p9_a4 out nocopy JTF_NUMBER_TABLE
796: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
797: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_300
798: , p9_a7 out nocopy JTF_NUMBER_TABLE
799: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_200
800: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_2000
801: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
802: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 803: , p9_a12 out nocopy JTF_NUMBER_TABLE

799: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_200
800: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_2000
801: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
802: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
803: , p9_a12 out nocopy JTF_NUMBER_TABLE
804: , p9_a13 out nocopy JTF_DATE_TABLE
805: , p9_a14 out nocopy JTF_DATE_TABLE
806: , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100
807: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 815: , p9_a24 out nocopy JTF_NUMBER_TABLE

811: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_2000
812: , p9_a21 out nocopy JTF_DATE_TABLE
813: , p9_a22 out nocopy JTF_VARCHAR2_TABLE_100
814: , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
815: , p9_a24 out nocopy JTF_NUMBER_TABLE
816: )
817:
818: as
819: ddx_applicable_activities_tbl ahl_fmp_pvt.applicable_activities_tbl_type;

Line 907: , p11_a0 out nocopy JTF_NUMBER_TABLE

903: , p_item_instance_id NUMBER
904: , p_mr_header_id NUMBER
905: , p_components_flag VARCHAR2
906: , p_include_donotimplmt VARCHAR2
907: , p11_a0 out nocopy JTF_NUMBER_TABLE
908: , p11_a1 out nocopy JTF_NUMBER_TABLE
909: , p11_a2 out nocopy JTF_NUMBER_TABLE
910: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
911: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 908: , p11_a1 out nocopy JTF_NUMBER_TABLE

904: , p_mr_header_id NUMBER
905: , p_components_flag VARCHAR2
906: , p_include_donotimplmt VARCHAR2
907: , p11_a0 out nocopy JTF_NUMBER_TABLE
908: , p11_a1 out nocopy JTF_NUMBER_TABLE
909: , p11_a2 out nocopy JTF_NUMBER_TABLE
910: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
911: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
912: , p11_a5 out nocopy JTF_NUMBER_TABLE

Line 909: , p11_a2 out nocopy JTF_NUMBER_TABLE

905: , p_components_flag VARCHAR2
906: , p_include_donotimplmt VARCHAR2
907: , p11_a0 out nocopy JTF_NUMBER_TABLE
908: , p11_a1 out nocopy JTF_NUMBER_TABLE
909: , p11_a2 out nocopy JTF_NUMBER_TABLE
910: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
911: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
912: , p11_a5 out nocopy JTF_NUMBER_TABLE
913: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 912: , p11_a5 out nocopy JTF_NUMBER_TABLE

908: , p11_a1 out nocopy JTF_NUMBER_TABLE
909: , p11_a2 out nocopy JTF_NUMBER_TABLE
910: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
911: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
912: , p11_a5 out nocopy JTF_NUMBER_TABLE
913: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
914: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100
915: , p11_a8 out nocopy JTF_NUMBER_TABLE
916: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 915: , p11_a8 out nocopy JTF_NUMBER_TABLE

911: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
912: , p11_a5 out nocopy JTF_NUMBER_TABLE
913: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
914: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100
915: , p11_a8 out nocopy JTF_NUMBER_TABLE
916: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100
917: , p11_a10 out nocopy JTF_NUMBER_TABLE
918: , p11_a11 out nocopy JTF_NUMBER_TABLE
919: )

Line 917: , p11_a10 out nocopy JTF_NUMBER_TABLE

913: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
914: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100
915: , p11_a8 out nocopy JTF_NUMBER_TABLE
916: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100
917: , p11_a10 out nocopy JTF_NUMBER_TABLE
918: , p11_a11 out nocopy JTF_NUMBER_TABLE
919: )
920:
921: as

Line 918: , p11_a11 out nocopy JTF_NUMBER_TABLE

914: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100
915: , p11_a8 out nocopy JTF_NUMBER_TABLE
916: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100
917: , p11_a10 out nocopy JTF_NUMBER_TABLE
918: , p11_a11 out nocopy JTF_NUMBER_TABLE
919: )
920:
921: as
922: ddx_applicable_mr_tbl ahl_fmp_pvt.applicable_mr_tbl_type;