APPS.AHL_FMP_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 16: procedure rosetta_table_copy_in_p1(t out nocopy ahl_fmp_pvt.mr_item_instance_tbl_type, a0 JTF_VARCHAR2_TABLE_100

12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy ahl_fmp_pvt.mr_item_instance_tbl_type, a0 JTF_VARCHAR2_TABLE_100
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_VARCHAR2_TABLE_4000
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_VARCHAR2_TABLE_400

Line 17: , a1 JTF_VARCHAR2_TABLE_100

13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy ahl_fmp_pvt.mr_item_instance_tbl_type, a0 JTF_VARCHAR2_TABLE_100
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_VARCHAR2_TABLE_4000
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_VARCHAR2_TABLE_400
21: , a5 JTF_VARCHAR2_TABLE_300

Line 19: , a3 JTF_VARCHAR2_TABLE_100

15:
16: procedure rosetta_table_copy_in_p1(t out nocopy ahl_fmp_pvt.mr_item_instance_tbl_type, a0 JTF_VARCHAR2_TABLE_100
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_VARCHAR2_TABLE_4000
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

Line 22: , a6 JTF_VARCHAR2_TABLE_100

18: , a2 JTF_VARCHAR2_TABLE_4000
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

Line 55: procedure rosetta_table_copy_out_p1(t ahl_fmp_pvt.mr_item_instance_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

51: end loop;
52: end if;
53: end if;
54: end rosetta_table_copy_in_p1;
55: procedure rosetta_table_copy_out_p1(t ahl_fmp_pvt.mr_item_instance_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
56: , a1 out nocopy JTF_VARCHAR2_TABLE_100
57: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
58: , a3 out nocopy JTF_VARCHAR2_TABLE_100
59: , a4 out nocopy JTF_VARCHAR2_TABLE_400

Line 56: , a1 out nocopy JTF_VARCHAR2_TABLE_100

52: end if;
53: end if;
54: end rosetta_table_copy_in_p1;
55: procedure rosetta_table_copy_out_p1(t ahl_fmp_pvt.mr_item_instance_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
56: , a1 out nocopy JTF_VARCHAR2_TABLE_100
57: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
58: , a3 out nocopy JTF_VARCHAR2_TABLE_100
59: , a4 out nocopy JTF_VARCHAR2_TABLE_400
60: , a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 58: , a3 out nocopy JTF_VARCHAR2_TABLE_100

54: end rosetta_table_copy_in_p1;
55: procedure rosetta_table_copy_out_p1(t ahl_fmp_pvt.mr_item_instance_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
56: , a1 out nocopy JTF_VARCHAR2_TABLE_100
57: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
58: , a3 out nocopy JTF_VARCHAR2_TABLE_100
59: , a4 out nocopy JTF_VARCHAR2_TABLE_400
60: , a5 out nocopy JTF_VARCHAR2_TABLE_300
61: , a6 out nocopy JTF_VARCHAR2_TABLE_100
62: , a7 out nocopy JTF_NUMBER_TABLE

Line 61: , a6 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 70: a0 := JTF_VARCHAR2_TABLE_100();

66: ) as
67: ddindx binary_integer; indx binary_integer;
68: begin
69: if t is null or t.count = 0 then
70: a0 := JTF_VARCHAR2_TABLE_100();
71: a1 := JTF_VARCHAR2_TABLE_100();
72: a2 := JTF_VARCHAR2_TABLE_4000();
73: a3 := JTF_VARCHAR2_TABLE_100();
74: a4 := JTF_VARCHAR2_TABLE_400();

Line 71: a1 := JTF_VARCHAR2_TABLE_100();

67: ddindx binary_integer; indx binary_integer;
68: begin
69: if t is null or t.count = 0 then
70: a0 := JTF_VARCHAR2_TABLE_100();
71: a1 := JTF_VARCHAR2_TABLE_100();
72: a2 := JTF_VARCHAR2_TABLE_4000();
73: a3 := JTF_VARCHAR2_TABLE_100();
74: a4 := JTF_VARCHAR2_TABLE_400();
75: a5 := JTF_VARCHAR2_TABLE_300();

Line 73: a3 := JTF_VARCHAR2_TABLE_100();

69: if t is null or t.count = 0 then
70: a0 := JTF_VARCHAR2_TABLE_100();
71: a1 := JTF_VARCHAR2_TABLE_100();
72: a2 := JTF_VARCHAR2_TABLE_4000();
73: a3 := JTF_VARCHAR2_TABLE_100();
74: a4 := JTF_VARCHAR2_TABLE_400();
75: a5 := JTF_VARCHAR2_TABLE_300();
76: a6 := JTF_VARCHAR2_TABLE_100();
77: a7 := JTF_NUMBER_TABLE();

Line 76: a6 := JTF_VARCHAR2_TABLE_100();

72: a2 := JTF_VARCHAR2_TABLE_4000();
73: a3 := JTF_VARCHAR2_TABLE_100();
74: a4 := JTF_VARCHAR2_TABLE_400();
75: a5 := JTF_VARCHAR2_TABLE_300();
76: a6 := JTF_VARCHAR2_TABLE_100();
77: a7 := JTF_NUMBER_TABLE();
78: a8 := JTF_NUMBER_TABLE();
79: a9 := JTF_NUMBER_TABLE();
80: a10 := JTF_NUMBER_TABLE();

Line 82: a0 := JTF_VARCHAR2_TABLE_100();

78: a8 := JTF_NUMBER_TABLE();
79: a9 := JTF_NUMBER_TABLE();
80: a10 := JTF_NUMBER_TABLE();
81: else
82: a0 := JTF_VARCHAR2_TABLE_100();
83: a1 := JTF_VARCHAR2_TABLE_100();
84: a2 := JTF_VARCHAR2_TABLE_4000();
85: a3 := JTF_VARCHAR2_TABLE_100();
86: a4 := JTF_VARCHAR2_TABLE_400();

Line 83: a1 := JTF_VARCHAR2_TABLE_100();

79: a9 := JTF_NUMBER_TABLE();
80: a10 := JTF_NUMBER_TABLE();
81: else
82: a0 := JTF_VARCHAR2_TABLE_100();
83: a1 := JTF_VARCHAR2_TABLE_100();
84: a2 := JTF_VARCHAR2_TABLE_4000();
85: a3 := JTF_VARCHAR2_TABLE_100();
86: a4 := JTF_VARCHAR2_TABLE_400();
87: a5 := JTF_VARCHAR2_TABLE_300();

Line 85: a3 := JTF_VARCHAR2_TABLE_100();

81: else
82: a0 := JTF_VARCHAR2_TABLE_100();
83: a1 := JTF_VARCHAR2_TABLE_100();
84: a2 := JTF_VARCHAR2_TABLE_4000();
85: a3 := JTF_VARCHAR2_TABLE_100();
86: a4 := JTF_VARCHAR2_TABLE_400();
87: a5 := JTF_VARCHAR2_TABLE_300();
88: a6 := JTF_VARCHAR2_TABLE_100();
89: a7 := JTF_NUMBER_TABLE();

Line 88: a6 := JTF_VARCHAR2_TABLE_100();

84: a2 := JTF_VARCHAR2_TABLE_4000();
85: a3 := JTF_VARCHAR2_TABLE_100();
86: a4 := JTF_VARCHAR2_TABLE_400();
87: a5 := JTF_VARCHAR2_TABLE_300();
88: a6 := JTF_VARCHAR2_TABLE_100();
89: a7 := JTF_NUMBER_TABLE();
90: a8 := JTF_NUMBER_TABLE();
91: a9 := JTF_NUMBER_TABLE();
92: a10 := JTF_NUMBER_TABLE();

Line 132: , a3 JTF_VARCHAR2_TABLE_100

128:
129: procedure rosetta_table_copy_in_p3(t out nocopy ahl_fmp_pvt.applicable_mr_tbl_type, a0 JTF_NUMBER_TABLE
130: , a1 JTF_NUMBER_TABLE
131: , a2 JTF_NUMBER_TABLE
132: , a3 JTF_VARCHAR2_TABLE_100
133: , a4 JTF_VARCHAR2_TABLE_100
134: , a5 JTF_NUMBER_TABLE
135: , a6 JTF_VARCHAR2_TABLE_100
136: , a7 JTF_VARCHAR2_TABLE_100

Line 133: , a4 JTF_VARCHAR2_TABLE_100

129: procedure rosetta_table_copy_in_p3(t out nocopy ahl_fmp_pvt.applicable_mr_tbl_type, a0 JTF_NUMBER_TABLE
130: , a1 JTF_NUMBER_TABLE
131: , a2 JTF_NUMBER_TABLE
132: , a3 JTF_VARCHAR2_TABLE_100
133: , a4 JTF_VARCHAR2_TABLE_100
134: , a5 JTF_NUMBER_TABLE
135: , a6 JTF_VARCHAR2_TABLE_100
136: , a7 JTF_VARCHAR2_TABLE_100
137: , a8 JTF_NUMBER_TABLE

Line 135: , a6 JTF_VARCHAR2_TABLE_100

131: , a2 JTF_NUMBER_TABLE
132: , a3 JTF_VARCHAR2_TABLE_100
133: , a4 JTF_VARCHAR2_TABLE_100
134: , a5 JTF_NUMBER_TABLE
135: , a6 JTF_VARCHAR2_TABLE_100
136: , a7 JTF_VARCHAR2_TABLE_100
137: , a8 JTF_NUMBER_TABLE
138: ) as
139: ddindx binary_integer; indx binary_integer;

Line 136: , a7 JTF_VARCHAR2_TABLE_100

132: , a3 JTF_VARCHAR2_TABLE_100
133: , a4 JTF_VARCHAR2_TABLE_100
134: , a5 JTF_NUMBER_TABLE
135: , a6 JTF_VARCHAR2_TABLE_100
136: , a7 JTF_VARCHAR2_TABLE_100
137: , a8 JTF_NUMBER_TABLE
138: ) as
139: ddindx binary_integer; indx binary_integer;
140: begin

Line 167: , a3 out nocopy JTF_VARCHAR2_TABLE_100

163: end rosetta_table_copy_in_p3;
164: procedure rosetta_table_copy_out_p3(t ahl_fmp_pvt.applicable_mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
165: , a1 out nocopy JTF_NUMBER_TABLE
166: , a2 out nocopy JTF_NUMBER_TABLE
167: , a3 out nocopy JTF_VARCHAR2_TABLE_100
168: , a4 out nocopy JTF_VARCHAR2_TABLE_100
169: , a5 out nocopy JTF_NUMBER_TABLE
170: , a6 out nocopy JTF_VARCHAR2_TABLE_100
171: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 168: , a4 out nocopy JTF_VARCHAR2_TABLE_100

164: procedure rosetta_table_copy_out_p3(t ahl_fmp_pvt.applicable_mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
165: , a1 out nocopy JTF_NUMBER_TABLE
166: , a2 out nocopy JTF_NUMBER_TABLE
167: , a3 out nocopy JTF_VARCHAR2_TABLE_100
168: , a4 out nocopy JTF_VARCHAR2_TABLE_100
169: , a5 out nocopy JTF_NUMBER_TABLE
170: , a6 out nocopy JTF_VARCHAR2_TABLE_100
171: , a7 out nocopy JTF_VARCHAR2_TABLE_100
172: , a8 out nocopy JTF_NUMBER_TABLE

Line 170: , a6 out nocopy JTF_VARCHAR2_TABLE_100

166: , a2 out nocopy JTF_NUMBER_TABLE
167: , a3 out nocopy JTF_VARCHAR2_TABLE_100
168: , a4 out nocopy JTF_VARCHAR2_TABLE_100
169: , a5 out nocopy JTF_NUMBER_TABLE
170: , a6 out nocopy JTF_VARCHAR2_TABLE_100
171: , a7 out nocopy JTF_VARCHAR2_TABLE_100
172: , a8 out nocopy JTF_NUMBER_TABLE
173: ) as
174: ddindx binary_integer; indx binary_integer;

Line 171: , a7 out nocopy JTF_VARCHAR2_TABLE_100

167: , a3 out nocopy JTF_VARCHAR2_TABLE_100
168: , a4 out nocopy JTF_VARCHAR2_TABLE_100
169: , a5 out nocopy JTF_NUMBER_TABLE
170: , a6 out nocopy JTF_VARCHAR2_TABLE_100
171: , a7 out nocopy JTF_VARCHAR2_TABLE_100
172: , a8 out nocopy JTF_NUMBER_TABLE
173: ) as
174: ddindx binary_integer; indx binary_integer;
175: begin

Line 180: a3 := JTF_VARCHAR2_TABLE_100();

176: if t is null or t.count = 0 then
177: a0 := JTF_NUMBER_TABLE();
178: a1 := JTF_NUMBER_TABLE();
179: a2 := JTF_NUMBER_TABLE();
180: a3 := JTF_VARCHAR2_TABLE_100();
181: a4 := JTF_VARCHAR2_TABLE_100();
182: a5 := JTF_NUMBER_TABLE();
183: a6 := JTF_VARCHAR2_TABLE_100();
184: a7 := JTF_VARCHAR2_TABLE_100();

Line 181: a4 := JTF_VARCHAR2_TABLE_100();

177: a0 := JTF_NUMBER_TABLE();
178: a1 := JTF_NUMBER_TABLE();
179: a2 := JTF_NUMBER_TABLE();
180: a3 := JTF_VARCHAR2_TABLE_100();
181: a4 := JTF_VARCHAR2_TABLE_100();
182: a5 := JTF_NUMBER_TABLE();
183: a6 := JTF_VARCHAR2_TABLE_100();
184: a7 := JTF_VARCHAR2_TABLE_100();
185: a8 := JTF_NUMBER_TABLE();

Line 183: a6 := JTF_VARCHAR2_TABLE_100();

179: a2 := JTF_NUMBER_TABLE();
180: a3 := JTF_VARCHAR2_TABLE_100();
181: a4 := JTF_VARCHAR2_TABLE_100();
182: a5 := JTF_NUMBER_TABLE();
183: a6 := JTF_VARCHAR2_TABLE_100();
184: a7 := JTF_VARCHAR2_TABLE_100();
185: a8 := JTF_NUMBER_TABLE();
186: else
187: a0 := JTF_NUMBER_TABLE();

Line 184: a7 := JTF_VARCHAR2_TABLE_100();

180: a3 := JTF_VARCHAR2_TABLE_100();
181: a4 := JTF_VARCHAR2_TABLE_100();
182: a5 := JTF_NUMBER_TABLE();
183: a6 := JTF_VARCHAR2_TABLE_100();
184: a7 := JTF_VARCHAR2_TABLE_100();
185: a8 := JTF_NUMBER_TABLE();
186: else
187: a0 := JTF_NUMBER_TABLE();
188: a1 := JTF_NUMBER_TABLE();

Line 190: a3 := JTF_VARCHAR2_TABLE_100();

186: else
187: a0 := JTF_NUMBER_TABLE();
188: a1 := JTF_NUMBER_TABLE();
189: a2 := JTF_NUMBER_TABLE();
190: a3 := JTF_VARCHAR2_TABLE_100();
191: a4 := JTF_VARCHAR2_TABLE_100();
192: a5 := JTF_NUMBER_TABLE();
193: a6 := JTF_VARCHAR2_TABLE_100();
194: a7 := JTF_VARCHAR2_TABLE_100();

Line 191: a4 := JTF_VARCHAR2_TABLE_100();

187: a0 := JTF_NUMBER_TABLE();
188: a1 := JTF_NUMBER_TABLE();
189: a2 := JTF_NUMBER_TABLE();
190: a3 := JTF_VARCHAR2_TABLE_100();
191: a4 := JTF_VARCHAR2_TABLE_100();
192: a5 := JTF_NUMBER_TABLE();
193: a6 := JTF_VARCHAR2_TABLE_100();
194: a7 := JTF_VARCHAR2_TABLE_100();
195: a8 := JTF_NUMBER_TABLE();

Line 193: a6 := JTF_VARCHAR2_TABLE_100();

189: a2 := JTF_NUMBER_TABLE();
190: a3 := JTF_VARCHAR2_TABLE_100();
191: a4 := JTF_VARCHAR2_TABLE_100();
192: a5 := JTF_NUMBER_TABLE();
193: a6 := JTF_VARCHAR2_TABLE_100();
194: a7 := JTF_VARCHAR2_TABLE_100();
195: a8 := JTF_NUMBER_TABLE();
196: if t.count > 0 then
197: a0.extend(t.count);

Line 194: a7 := JTF_VARCHAR2_TABLE_100();

190: a3 := JTF_VARCHAR2_TABLE_100();
191: a4 := JTF_VARCHAR2_TABLE_100();
192: a5 := JTF_NUMBER_TABLE();
193: a6 := JTF_VARCHAR2_TABLE_100();
194: a7 := JTF_VARCHAR2_TABLE_100();
195: a8 := JTF_NUMBER_TABLE();
196: if t.count > 0 then
197: a0.extend(t.count);
198: a1.extend(t.count);

Line 233: , a5 JTF_VARCHAR2_TABLE_100

229: , a1 JTF_NUMBER_TABLE
230: , a2 JTF_NUMBER_TABLE
231: , a3 JTF_NUMBER_TABLE
232: , a4 JTF_NUMBER_TABLE
233: , a5 JTF_VARCHAR2_TABLE_100
234: , a6 JTF_VARCHAR2_TABLE_100
235: , a7 JTF_VARCHAR2_TABLE_100
236: , a8 JTF_VARCHAR2_TABLE_100
237: , a9 JTF_VARCHAR2_TABLE_100

Line 234: , a6 JTF_VARCHAR2_TABLE_100

230: , a2 JTF_NUMBER_TABLE
231: , a3 JTF_NUMBER_TABLE
232: , a4 JTF_NUMBER_TABLE
233: , a5 JTF_VARCHAR2_TABLE_100
234: , a6 JTF_VARCHAR2_TABLE_100
235: , a7 JTF_VARCHAR2_TABLE_100
236: , a8 JTF_VARCHAR2_TABLE_100
237: , a9 JTF_VARCHAR2_TABLE_100
238: ) as

Line 235: , a7 JTF_VARCHAR2_TABLE_100

231: , a3 JTF_NUMBER_TABLE
232: , a4 JTF_NUMBER_TABLE
233: , a5 JTF_VARCHAR2_TABLE_100
234: , a6 JTF_VARCHAR2_TABLE_100
235: , a7 JTF_VARCHAR2_TABLE_100
236: , a8 JTF_VARCHAR2_TABLE_100
237: , a9 JTF_VARCHAR2_TABLE_100
238: ) as
239: ddindx binary_integer; indx binary_integer;

Line 236: , a8 JTF_VARCHAR2_TABLE_100

232: , a4 JTF_NUMBER_TABLE
233: , a5 JTF_VARCHAR2_TABLE_100
234: , a6 JTF_VARCHAR2_TABLE_100
235: , a7 JTF_VARCHAR2_TABLE_100
236: , a8 JTF_VARCHAR2_TABLE_100
237: , a9 JTF_VARCHAR2_TABLE_100
238: ) as
239: ddindx binary_integer; indx binary_integer;
240: begin

Line 237: , a9 JTF_VARCHAR2_TABLE_100

233: , a5 JTF_VARCHAR2_TABLE_100
234: , a6 JTF_VARCHAR2_TABLE_100
235: , a7 JTF_VARCHAR2_TABLE_100
236: , a8 JTF_VARCHAR2_TABLE_100
237: , a9 JTF_VARCHAR2_TABLE_100
238: ) as
239: ddindx binary_integer; indx binary_integer;
240: begin
241: if a0 is not null and a0.count > 0 then

Line 270: , a5 out nocopy JTF_VARCHAR2_TABLE_100

266: , a1 out nocopy JTF_NUMBER_TABLE
267: , a2 out nocopy JTF_NUMBER_TABLE
268: , a3 out nocopy JTF_NUMBER_TABLE
269: , a4 out nocopy JTF_NUMBER_TABLE
270: , a5 out nocopy JTF_VARCHAR2_TABLE_100
271: , a6 out nocopy JTF_VARCHAR2_TABLE_100
272: , a7 out nocopy JTF_VARCHAR2_TABLE_100
273: , a8 out nocopy JTF_VARCHAR2_TABLE_100
274: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 271: , a6 out nocopy JTF_VARCHAR2_TABLE_100

267: , a2 out nocopy JTF_NUMBER_TABLE
268: , a3 out nocopy JTF_NUMBER_TABLE
269: , a4 out nocopy JTF_NUMBER_TABLE
270: , a5 out nocopy JTF_VARCHAR2_TABLE_100
271: , a6 out nocopy JTF_VARCHAR2_TABLE_100
272: , a7 out nocopy JTF_VARCHAR2_TABLE_100
273: , a8 out nocopy JTF_VARCHAR2_TABLE_100
274: , a9 out nocopy JTF_VARCHAR2_TABLE_100
275: ) as

Line 272: , a7 out nocopy JTF_VARCHAR2_TABLE_100

268: , a3 out nocopy JTF_NUMBER_TABLE
269: , a4 out nocopy JTF_NUMBER_TABLE
270: , a5 out nocopy JTF_VARCHAR2_TABLE_100
271: , a6 out nocopy JTF_VARCHAR2_TABLE_100
272: , a7 out nocopy JTF_VARCHAR2_TABLE_100
273: , a8 out nocopy JTF_VARCHAR2_TABLE_100
274: , a9 out nocopy JTF_VARCHAR2_TABLE_100
275: ) as
276: ddindx binary_integer; indx binary_integer;

Line 273: , a8 out nocopy JTF_VARCHAR2_TABLE_100

269: , a4 out nocopy JTF_NUMBER_TABLE
270: , a5 out nocopy JTF_VARCHAR2_TABLE_100
271: , a6 out nocopy JTF_VARCHAR2_TABLE_100
272: , a7 out nocopy JTF_VARCHAR2_TABLE_100
273: , a8 out nocopy JTF_VARCHAR2_TABLE_100
274: , a9 out nocopy JTF_VARCHAR2_TABLE_100
275: ) as
276: ddindx binary_integer; indx binary_integer;
277: begin

Line 274: , a9 out nocopy JTF_VARCHAR2_TABLE_100

270: , a5 out nocopy JTF_VARCHAR2_TABLE_100
271: , a6 out nocopy JTF_VARCHAR2_TABLE_100
272: , a7 out nocopy JTF_VARCHAR2_TABLE_100
273: , a8 out nocopy JTF_VARCHAR2_TABLE_100
274: , a9 out nocopy JTF_VARCHAR2_TABLE_100
275: ) as
276: ddindx binary_integer; indx binary_integer;
277: begin
278: if t is null or t.count = 0 then

Line 284: a5 := JTF_VARCHAR2_TABLE_100();

280: a1 := JTF_NUMBER_TABLE();
281: a2 := JTF_NUMBER_TABLE();
282: a3 := JTF_NUMBER_TABLE();
283: a4 := JTF_NUMBER_TABLE();
284: a5 := JTF_VARCHAR2_TABLE_100();
285: a6 := JTF_VARCHAR2_TABLE_100();
286: a7 := JTF_VARCHAR2_TABLE_100();
287: a8 := JTF_VARCHAR2_TABLE_100();
288: a9 := JTF_VARCHAR2_TABLE_100();

Line 285: a6 := JTF_VARCHAR2_TABLE_100();

281: a2 := JTF_NUMBER_TABLE();
282: a3 := JTF_NUMBER_TABLE();
283: a4 := JTF_NUMBER_TABLE();
284: a5 := JTF_VARCHAR2_TABLE_100();
285: a6 := JTF_VARCHAR2_TABLE_100();
286: a7 := JTF_VARCHAR2_TABLE_100();
287: a8 := JTF_VARCHAR2_TABLE_100();
288: a9 := JTF_VARCHAR2_TABLE_100();
289: else

Line 286: a7 := JTF_VARCHAR2_TABLE_100();

282: a3 := JTF_NUMBER_TABLE();
283: a4 := JTF_NUMBER_TABLE();
284: a5 := JTF_VARCHAR2_TABLE_100();
285: a6 := JTF_VARCHAR2_TABLE_100();
286: a7 := JTF_VARCHAR2_TABLE_100();
287: a8 := JTF_VARCHAR2_TABLE_100();
288: a9 := JTF_VARCHAR2_TABLE_100();
289: else
290: a0 := JTF_NUMBER_TABLE();

Line 287: a8 := JTF_VARCHAR2_TABLE_100();

283: a4 := JTF_NUMBER_TABLE();
284: a5 := JTF_VARCHAR2_TABLE_100();
285: a6 := JTF_VARCHAR2_TABLE_100();
286: a7 := JTF_VARCHAR2_TABLE_100();
287: a8 := JTF_VARCHAR2_TABLE_100();
288: a9 := JTF_VARCHAR2_TABLE_100();
289: else
290: a0 := JTF_NUMBER_TABLE();
291: a1 := JTF_NUMBER_TABLE();

Line 288: a9 := JTF_VARCHAR2_TABLE_100();

284: a5 := JTF_VARCHAR2_TABLE_100();
285: a6 := JTF_VARCHAR2_TABLE_100();
286: a7 := JTF_VARCHAR2_TABLE_100();
287: a8 := JTF_VARCHAR2_TABLE_100();
288: a9 := JTF_VARCHAR2_TABLE_100();
289: else
290: a0 := JTF_NUMBER_TABLE();
291: a1 := JTF_NUMBER_TABLE();
292: a2 := JTF_NUMBER_TABLE();

Line 295: a5 := JTF_VARCHAR2_TABLE_100();

291: a1 := JTF_NUMBER_TABLE();
292: a2 := JTF_NUMBER_TABLE();
293: a3 := JTF_NUMBER_TABLE();
294: a4 := JTF_NUMBER_TABLE();
295: a5 := JTF_VARCHAR2_TABLE_100();
296: a6 := JTF_VARCHAR2_TABLE_100();
297: a7 := JTF_VARCHAR2_TABLE_100();
298: a8 := JTF_VARCHAR2_TABLE_100();
299: a9 := JTF_VARCHAR2_TABLE_100();

Line 296: a6 := JTF_VARCHAR2_TABLE_100();

292: a2 := JTF_NUMBER_TABLE();
293: a3 := JTF_NUMBER_TABLE();
294: a4 := JTF_NUMBER_TABLE();
295: a5 := JTF_VARCHAR2_TABLE_100();
296: a6 := JTF_VARCHAR2_TABLE_100();
297: a7 := JTF_VARCHAR2_TABLE_100();
298: a8 := JTF_VARCHAR2_TABLE_100();
299: a9 := JTF_VARCHAR2_TABLE_100();
300: if t.count > 0 then

Line 297: a7 := JTF_VARCHAR2_TABLE_100();

293: a3 := JTF_NUMBER_TABLE();
294: a4 := JTF_NUMBER_TABLE();
295: a5 := JTF_VARCHAR2_TABLE_100();
296: a6 := JTF_VARCHAR2_TABLE_100();
297: a7 := JTF_VARCHAR2_TABLE_100();
298: a8 := JTF_VARCHAR2_TABLE_100();
299: a9 := JTF_VARCHAR2_TABLE_100();
300: if t.count > 0 then
301: a0.extend(t.count);

Line 298: a8 := JTF_VARCHAR2_TABLE_100();

294: a4 := JTF_NUMBER_TABLE();
295: a5 := JTF_VARCHAR2_TABLE_100();
296: a6 := JTF_VARCHAR2_TABLE_100();
297: a7 := JTF_VARCHAR2_TABLE_100();
298: a8 := JTF_VARCHAR2_TABLE_100();
299: a9 := JTF_VARCHAR2_TABLE_100();
300: if t.count > 0 then
301: a0.extend(t.count);
302: a1.extend(t.count);

Line 299: a9 := JTF_VARCHAR2_TABLE_100();

295: a5 := JTF_VARCHAR2_TABLE_100();
296: a6 := JTF_VARCHAR2_TABLE_100();
297: a7 := JTF_VARCHAR2_TABLE_100();
298: a8 := JTF_VARCHAR2_TABLE_100();
299: a9 := JTF_VARCHAR2_TABLE_100();
300: if t.count > 0 then
301: a0.extend(t.count);
302: a1.extend(t.count);
303: a2.extend(t.count);

Line 337: , a3 JTF_VARCHAR2_TABLE_100

333:
334: procedure rosetta_table_copy_in_p7(t out nocopy ahl_fmp_pvt.applicable_programs_tbl_type, a0 JTF_NUMBER_TABLE
335: , a1 JTF_VARCHAR2_TABLE_200
336: , a2 JTF_VARCHAR2_TABLE_200
337: , a3 JTF_VARCHAR2_TABLE_100
338: , a4 JTF_NUMBER_TABLE
339: , a5 JTF_VARCHAR2_TABLE_300
340: , a6 JTF_VARCHAR2_TABLE_300
341: , a7 JTF_NUMBER_TABLE

Line 344: , a10 JTF_VARCHAR2_TABLE_100

340: , a6 JTF_VARCHAR2_TABLE_300
341: , a7 JTF_NUMBER_TABLE
342: , a8 JTF_VARCHAR2_TABLE_200
343: , a9 JTF_VARCHAR2_TABLE_2000
344: , a10 JTF_VARCHAR2_TABLE_100
345: , a11 JTF_VARCHAR2_TABLE_100
346: , a12 JTF_NUMBER_TABLE
347: , a13 JTF_DATE_TABLE
348: , a14 JTF_DATE_TABLE

Line 345: , a11 JTF_VARCHAR2_TABLE_100

341: , a7 JTF_NUMBER_TABLE
342: , a8 JTF_VARCHAR2_TABLE_200
343: , a9 JTF_VARCHAR2_TABLE_2000
344: , a10 JTF_VARCHAR2_TABLE_100
345: , a11 JTF_VARCHAR2_TABLE_100
346: , a12 JTF_NUMBER_TABLE
347: , a13 JTF_DATE_TABLE
348: , a14 JTF_DATE_TABLE
349: , a15 JTF_VARCHAR2_TABLE_100

Line 349: , a15 JTF_VARCHAR2_TABLE_100

345: , a11 JTF_VARCHAR2_TABLE_100
346: , a12 JTF_NUMBER_TABLE
347: , a13 JTF_DATE_TABLE
348: , a14 JTF_DATE_TABLE
349: , a15 JTF_VARCHAR2_TABLE_100
350: , a16 JTF_VARCHAR2_TABLE_100
351: , a17 JTF_DATE_TABLE
352: , a18 JTF_DATE_TABLE
353: , a19 JTF_VARCHAR2_TABLE_100

Line 350: , a16 JTF_VARCHAR2_TABLE_100

346: , a12 JTF_NUMBER_TABLE
347: , a13 JTF_DATE_TABLE
348: , a14 JTF_DATE_TABLE
349: , a15 JTF_VARCHAR2_TABLE_100
350: , a16 JTF_VARCHAR2_TABLE_100
351: , a17 JTF_DATE_TABLE
352: , a18 JTF_DATE_TABLE
353: , a19 JTF_VARCHAR2_TABLE_100
354: , a20 JTF_VARCHAR2_TABLE_2000

Line 353: , a19 JTF_VARCHAR2_TABLE_100

349: , a15 JTF_VARCHAR2_TABLE_100
350: , a16 JTF_VARCHAR2_TABLE_100
351: , a17 JTF_DATE_TABLE
352: , a18 JTF_DATE_TABLE
353: , a19 JTF_VARCHAR2_TABLE_100
354: , a20 JTF_VARCHAR2_TABLE_2000
355: , a21 JTF_DATE_TABLE
356: , a22 JTF_VARCHAR2_TABLE_100
357: , a23 JTF_VARCHAR2_TABLE_500

Line 356: , a22 JTF_VARCHAR2_TABLE_100

352: , a18 JTF_DATE_TABLE
353: , a19 JTF_VARCHAR2_TABLE_100
354: , a20 JTF_VARCHAR2_TABLE_2000
355: , a21 JTF_DATE_TABLE
356: , a22 JTF_VARCHAR2_TABLE_100
357: , a23 JTF_VARCHAR2_TABLE_500
358: , a24 JTF_NUMBER_TABLE
359: ) as
360: ddindx binary_integer; indx binary_integer;

Line 404: , a3 out nocopy JTF_VARCHAR2_TABLE_100

400: end rosetta_table_copy_in_p7;
401: procedure rosetta_table_copy_out_p7(t ahl_fmp_pvt.applicable_programs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
402: , a1 out nocopy JTF_VARCHAR2_TABLE_200
403: , a2 out nocopy JTF_VARCHAR2_TABLE_200
404: , a3 out nocopy JTF_VARCHAR2_TABLE_100
405: , a4 out nocopy JTF_NUMBER_TABLE
406: , a5 out nocopy JTF_VARCHAR2_TABLE_300
407: , a6 out nocopy JTF_VARCHAR2_TABLE_300
408: , a7 out nocopy JTF_NUMBER_TABLE

Line 411: , a10 out nocopy JTF_VARCHAR2_TABLE_100

407: , a6 out nocopy JTF_VARCHAR2_TABLE_300
408: , a7 out nocopy JTF_NUMBER_TABLE
409: , a8 out nocopy JTF_VARCHAR2_TABLE_200
410: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
411: , a10 out nocopy JTF_VARCHAR2_TABLE_100
412: , a11 out nocopy JTF_VARCHAR2_TABLE_100
413: , a12 out nocopy JTF_NUMBER_TABLE
414: , a13 out nocopy JTF_DATE_TABLE
415: , a14 out nocopy JTF_DATE_TABLE

Line 412: , a11 out nocopy JTF_VARCHAR2_TABLE_100

408: , a7 out nocopy JTF_NUMBER_TABLE
409: , a8 out nocopy JTF_VARCHAR2_TABLE_200
410: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
411: , a10 out nocopy JTF_VARCHAR2_TABLE_100
412: , a11 out nocopy JTF_VARCHAR2_TABLE_100
413: , a12 out nocopy JTF_NUMBER_TABLE
414: , a13 out nocopy JTF_DATE_TABLE
415: , a14 out nocopy JTF_DATE_TABLE
416: , a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 416: , a15 out nocopy JTF_VARCHAR2_TABLE_100

412: , a11 out nocopy JTF_VARCHAR2_TABLE_100
413: , a12 out nocopy JTF_NUMBER_TABLE
414: , a13 out nocopy JTF_DATE_TABLE
415: , a14 out nocopy JTF_DATE_TABLE
416: , a15 out nocopy JTF_VARCHAR2_TABLE_100
417: , a16 out nocopy JTF_VARCHAR2_TABLE_100
418: , a17 out nocopy JTF_DATE_TABLE
419: , a18 out nocopy JTF_DATE_TABLE
420: , a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 417: , a16 out nocopy JTF_VARCHAR2_TABLE_100

413: , a12 out nocopy JTF_NUMBER_TABLE
414: , a13 out nocopy JTF_DATE_TABLE
415: , a14 out nocopy JTF_DATE_TABLE
416: , a15 out nocopy JTF_VARCHAR2_TABLE_100
417: , a16 out nocopy JTF_VARCHAR2_TABLE_100
418: , a17 out nocopy JTF_DATE_TABLE
419: , a18 out nocopy JTF_DATE_TABLE
420: , a19 out nocopy JTF_VARCHAR2_TABLE_100
421: , a20 out nocopy JTF_VARCHAR2_TABLE_2000

Line 420: , a19 out nocopy JTF_VARCHAR2_TABLE_100

416: , a15 out nocopy JTF_VARCHAR2_TABLE_100
417: , a16 out nocopy JTF_VARCHAR2_TABLE_100
418: , a17 out nocopy JTF_DATE_TABLE
419: , a18 out nocopy JTF_DATE_TABLE
420: , a19 out nocopy JTF_VARCHAR2_TABLE_100
421: , a20 out nocopy JTF_VARCHAR2_TABLE_2000
422: , a21 out nocopy JTF_DATE_TABLE
423: , a22 out nocopy JTF_VARCHAR2_TABLE_100
424: , a23 out nocopy JTF_VARCHAR2_TABLE_500

Line 423: , a22 out nocopy JTF_VARCHAR2_TABLE_100

419: , a18 out nocopy JTF_DATE_TABLE
420: , a19 out nocopy JTF_VARCHAR2_TABLE_100
421: , a20 out nocopy JTF_VARCHAR2_TABLE_2000
422: , a21 out nocopy JTF_DATE_TABLE
423: , a22 out nocopy JTF_VARCHAR2_TABLE_100
424: , a23 out nocopy JTF_VARCHAR2_TABLE_500
425: , a24 out nocopy JTF_NUMBER_TABLE
426: ) as
427: ddindx binary_integer; indx binary_integer;

Line 433: a3 := JTF_VARCHAR2_TABLE_100();

429: if t is null or t.count = 0 then
430: a0 := JTF_NUMBER_TABLE();
431: a1 := JTF_VARCHAR2_TABLE_200();
432: a2 := JTF_VARCHAR2_TABLE_200();
433: a3 := JTF_VARCHAR2_TABLE_100();
434: a4 := JTF_NUMBER_TABLE();
435: a5 := JTF_VARCHAR2_TABLE_300();
436: a6 := JTF_VARCHAR2_TABLE_300();
437: a7 := JTF_NUMBER_TABLE();

Line 440: a10 := JTF_VARCHAR2_TABLE_100();

436: a6 := JTF_VARCHAR2_TABLE_300();
437: a7 := JTF_NUMBER_TABLE();
438: a8 := JTF_VARCHAR2_TABLE_200();
439: a9 := JTF_VARCHAR2_TABLE_2000();
440: a10 := JTF_VARCHAR2_TABLE_100();
441: a11 := JTF_VARCHAR2_TABLE_100();
442: a12 := JTF_NUMBER_TABLE();
443: a13 := JTF_DATE_TABLE();
444: a14 := JTF_DATE_TABLE();

Line 441: a11 := JTF_VARCHAR2_TABLE_100();

437: a7 := JTF_NUMBER_TABLE();
438: a8 := JTF_VARCHAR2_TABLE_200();
439: a9 := JTF_VARCHAR2_TABLE_2000();
440: a10 := JTF_VARCHAR2_TABLE_100();
441: a11 := JTF_VARCHAR2_TABLE_100();
442: a12 := JTF_NUMBER_TABLE();
443: a13 := JTF_DATE_TABLE();
444: a14 := JTF_DATE_TABLE();
445: a15 := JTF_VARCHAR2_TABLE_100();

Line 445: a15 := JTF_VARCHAR2_TABLE_100();

441: a11 := JTF_VARCHAR2_TABLE_100();
442: a12 := JTF_NUMBER_TABLE();
443: a13 := JTF_DATE_TABLE();
444: a14 := JTF_DATE_TABLE();
445: a15 := JTF_VARCHAR2_TABLE_100();
446: a16 := JTF_VARCHAR2_TABLE_100();
447: a17 := JTF_DATE_TABLE();
448: a18 := JTF_DATE_TABLE();
449: a19 := JTF_VARCHAR2_TABLE_100();

Line 446: a16 := JTF_VARCHAR2_TABLE_100();

442: a12 := JTF_NUMBER_TABLE();
443: a13 := JTF_DATE_TABLE();
444: a14 := JTF_DATE_TABLE();
445: a15 := JTF_VARCHAR2_TABLE_100();
446: a16 := JTF_VARCHAR2_TABLE_100();
447: a17 := JTF_DATE_TABLE();
448: a18 := JTF_DATE_TABLE();
449: a19 := JTF_VARCHAR2_TABLE_100();
450: a20 := JTF_VARCHAR2_TABLE_2000();

Line 449: a19 := JTF_VARCHAR2_TABLE_100();

445: a15 := JTF_VARCHAR2_TABLE_100();
446: a16 := JTF_VARCHAR2_TABLE_100();
447: a17 := JTF_DATE_TABLE();
448: a18 := JTF_DATE_TABLE();
449: a19 := JTF_VARCHAR2_TABLE_100();
450: a20 := JTF_VARCHAR2_TABLE_2000();
451: a21 := JTF_DATE_TABLE();
452: a22 := JTF_VARCHAR2_TABLE_100();
453: a23 := JTF_VARCHAR2_TABLE_500();

Line 452: a22 := JTF_VARCHAR2_TABLE_100();

448: a18 := JTF_DATE_TABLE();
449: a19 := JTF_VARCHAR2_TABLE_100();
450: a20 := JTF_VARCHAR2_TABLE_2000();
451: a21 := JTF_DATE_TABLE();
452: a22 := JTF_VARCHAR2_TABLE_100();
453: a23 := JTF_VARCHAR2_TABLE_500();
454: a24 := JTF_NUMBER_TABLE();
455: else
456: a0 := JTF_NUMBER_TABLE();

Line 459: a3 := JTF_VARCHAR2_TABLE_100();

455: else
456: a0 := JTF_NUMBER_TABLE();
457: a1 := JTF_VARCHAR2_TABLE_200();
458: a2 := JTF_VARCHAR2_TABLE_200();
459: a3 := JTF_VARCHAR2_TABLE_100();
460: a4 := JTF_NUMBER_TABLE();
461: a5 := JTF_VARCHAR2_TABLE_300();
462: a6 := JTF_VARCHAR2_TABLE_300();
463: a7 := JTF_NUMBER_TABLE();

Line 466: a10 := JTF_VARCHAR2_TABLE_100();

462: a6 := JTF_VARCHAR2_TABLE_300();
463: a7 := JTF_NUMBER_TABLE();
464: a8 := JTF_VARCHAR2_TABLE_200();
465: a9 := JTF_VARCHAR2_TABLE_2000();
466: a10 := JTF_VARCHAR2_TABLE_100();
467: a11 := JTF_VARCHAR2_TABLE_100();
468: a12 := JTF_NUMBER_TABLE();
469: a13 := JTF_DATE_TABLE();
470: a14 := JTF_DATE_TABLE();

Line 467: a11 := JTF_VARCHAR2_TABLE_100();

463: a7 := JTF_NUMBER_TABLE();
464: a8 := JTF_VARCHAR2_TABLE_200();
465: a9 := JTF_VARCHAR2_TABLE_2000();
466: a10 := JTF_VARCHAR2_TABLE_100();
467: a11 := JTF_VARCHAR2_TABLE_100();
468: a12 := JTF_NUMBER_TABLE();
469: a13 := JTF_DATE_TABLE();
470: a14 := JTF_DATE_TABLE();
471: a15 := JTF_VARCHAR2_TABLE_100();

Line 471: a15 := JTF_VARCHAR2_TABLE_100();

467: a11 := JTF_VARCHAR2_TABLE_100();
468: a12 := JTF_NUMBER_TABLE();
469: a13 := JTF_DATE_TABLE();
470: a14 := JTF_DATE_TABLE();
471: a15 := JTF_VARCHAR2_TABLE_100();
472: a16 := JTF_VARCHAR2_TABLE_100();
473: a17 := JTF_DATE_TABLE();
474: a18 := JTF_DATE_TABLE();
475: a19 := JTF_VARCHAR2_TABLE_100();

Line 472: a16 := JTF_VARCHAR2_TABLE_100();

468: a12 := JTF_NUMBER_TABLE();
469: a13 := JTF_DATE_TABLE();
470: a14 := JTF_DATE_TABLE();
471: a15 := JTF_VARCHAR2_TABLE_100();
472: a16 := JTF_VARCHAR2_TABLE_100();
473: a17 := JTF_DATE_TABLE();
474: a18 := JTF_DATE_TABLE();
475: a19 := JTF_VARCHAR2_TABLE_100();
476: a20 := JTF_VARCHAR2_TABLE_2000();

Line 475: a19 := JTF_VARCHAR2_TABLE_100();

471: a15 := JTF_VARCHAR2_TABLE_100();
472: a16 := JTF_VARCHAR2_TABLE_100();
473: a17 := JTF_DATE_TABLE();
474: a18 := JTF_DATE_TABLE();
475: a19 := JTF_VARCHAR2_TABLE_100();
476: a20 := JTF_VARCHAR2_TABLE_2000();
477: a21 := JTF_DATE_TABLE();
478: a22 := JTF_VARCHAR2_TABLE_100();
479: a23 := JTF_VARCHAR2_TABLE_500();

Line 478: a22 := JTF_VARCHAR2_TABLE_100();

474: a18 := JTF_DATE_TABLE();
475: a19 := JTF_VARCHAR2_TABLE_100();
476: a20 := JTF_VARCHAR2_TABLE_2000();
477: a21 := JTF_DATE_TABLE();
478: a22 := JTF_VARCHAR2_TABLE_100();
479: a23 := JTF_VARCHAR2_TABLE_500();
480: a24 := JTF_NUMBER_TABLE();
481: if t.count > 0 then
482: a0.extend(t.count);

Line 557: , p12_a0 out nocopy JTF_VARCHAR2_TABLE_100

553: , p_mr_effectivity_id NUMBER
554: , p_top_node_flag VARCHAR2
555: , p_unique_inst_flag VARCHAR2
556: , p_sort_flag VARCHAR2
557: , p12_a0 out nocopy JTF_VARCHAR2_TABLE_100
558: , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100
559: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_4000
560: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
561: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_400

Line 558: , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100

554: , p_top_node_flag VARCHAR2
555: , p_unique_inst_flag VARCHAR2
556: , p_sort_flag VARCHAR2
557: , p12_a0 out nocopy JTF_VARCHAR2_TABLE_100
558: , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100
559: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_4000
560: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
561: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_400
562: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 560: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100

556: , p_sort_flag VARCHAR2
557: , p12_a0 out nocopy JTF_VARCHAR2_TABLE_100
558: , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100
559: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_4000
560: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
561: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_400
562: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_300
563: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
564: , p12_a7 out nocopy JTF_NUMBER_TABLE

Line 563: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100

559: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_4000
560: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
561: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_400
562: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_300
563: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
564: , p12_a7 out nocopy JTF_NUMBER_TABLE
565: , p12_a8 out nocopy JTF_NUMBER_TABLE
566: , p12_a9 out nocopy JTF_NUMBER_TABLE
567: , p12_a10 out nocopy JTF_NUMBER_TABLE

Line 646: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100

642: , p_visit_type_code VARCHAR2
643: , p12_a0 out nocopy JTF_NUMBER_TABLE
644: , p12_a1 out nocopy JTF_NUMBER_TABLE
645: , p12_a2 out nocopy JTF_NUMBER_TABLE
646: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
647: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
648: , p12_a5 out nocopy JTF_NUMBER_TABLE
649: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
650: , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 647: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100

643: , p12_a0 out nocopy JTF_NUMBER_TABLE
644: , p12_a1 out nocopy JTF_NUMBER_TABLE
645: , p12_a2 out nocopy JTF_NUMBER_TABLE
646: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
647: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
648: , p12_a5 out nocopy JTF_NUMBER_TABLE
649: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
650: , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100
651: , p12_a8 out nocopy JTF_NUMBER_TABLE

Line 649: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100

645: , p12_a2 out nocopy JTF_NUMBER_TABLE
646: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
647: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
648: , p12_a5 out nocopy JTF_NUMBER_TABLE
649: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
650: , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100
651: , p12_a8 out nocopy JTF_NUMBER_TABLE
652: )
653:

Line 650: , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100

646: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
647: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
648: , p12_a5 out nocopy JTF_NUMBER_TABLE
649: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
650: , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100
651: , p12_a8 out nocopy JTF_NUMBER_TABLE
652: )
653:
654: as

Line 726: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100

722: , p8_a1 out nocopy JTF_NUMBER_TABLE
723: , p8_a2 out nocopy JTF_NUMBER_TABLE
724: , p8_a3 out nocopy JTF_NUMBER_TABLE
725: , p8_a4 out nocopy JTF_NUMBER_TABLE
726: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
727: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
728: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
729: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
730: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 727: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100

723: , p8_a2 out nocopy JTF_NUMBER_TABLE
724: , p8_a3 out nocopy JTF_NUMBER_TABLE
725: , p8_a4 out nocopy JTF_NUMBER_TABLE
726: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
727: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
728: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
729: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
730: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
731: , p9_a0 out nocopy JTF_NUMBER_TABLE

Line 728: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100

724: , p8_a3 out nocopy JTF_NUMBER_TABLE
725: , p8_a4 out nocopy JTF_NUMBER_TABLE
726: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
727: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
728: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
729: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
730: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
731: , p9_a0 out nocopy JTF_NUMBER_TABLE
732: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200

Line 729: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100

725: , p8_a4 out nocopy JTF_NUMBER_TABLE
726: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
727: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
728: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
729: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
730: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
731: , p9_a0 out nocopy JTF_NUMBER_TABLE
732: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
733: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200

Line 730: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100

726: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
727: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
728: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
729: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
730: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
731: , p9_a0 out nocopy JTF_NUMBER_TABLE
732: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
733: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
734: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 734: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100

730: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
731: , p9_a0 out nocopy JTF_NUMBER_TABLE
732: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
733: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
734: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
735: , p9_a4 out nocopy JTF_NUMBER_TABLE
736: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
737: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_300
738: , p9_a7 out nocopy JTF_NUMBER_TABLE

Line 741: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100

737: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_300
738: , p9_a7 out nocopy JTF_NUMBER_TABLE
739: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_200
740: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_2000
741: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
742: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
743: , p9_a12 out nocopy JTF_NUMBER_TABLE
744: , p9_a13 out nocopy JTF_DATE_TABLE
745: , p9_a14 out nocopy JTF_DATE_TABLE

Line 742: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100

738: , p9_a7 out nocopy JTF_NUMBER_TABLE
739: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_200
740: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_2000
741: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
742: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
743: , p9_a12 out nocopy JTF_NUMBER_TABLE
744: , p9_a13 out nocopy JTF_DATE_TABLE
745: , p9_a14 out nocopy JTF_DATE_TABLE
746: , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 746: , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100

742: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
743: , p9_a12 out nocopy JTF_NUMBER_TABLE
744: , p9_a13 out nocopy JTF_DATE_TABLE
745: , p9_a14 out nocopy JTF_DATE_TABLE
746: , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100
747: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100
748: , p9_a17 out nocopy JTF_DATE_TABLE
749: , p9_a18 out nocopy JTF_DATE_TABLE
750: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 747: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100

743: , p9_a12 out nocopy JTF_NUMBER_TABLE
744: , p9_a13 out nocopy JTF_DATE_TABLE
745: , p9_a14 out nocopy JTF_DATE_TABLE
746: , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100
747: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100
748: , p9_a17 out nocopy JTF_DATE_TABLE
749: , p9_a18 out nocopy JTF_DATE_TABLE
750: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100
751: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_2000

Line 750: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100

746: , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100
747: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100
748: , p9_a17 out nocopy JTF_DATE_TABLE
749: , p9_a18 out nocopy JTF_DATE_TABLE
750: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100
751: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_2000
752: , p9_a21 out nocopy JTF_DATE_TABLE
753: , p9_a22 out nocopy JTF_VARCHAR2_TABLE_100
754: , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500

Line 753: , p9_a22 out nocopy JTF_VARCHAR2_TABLE_100

749: , p9_a18 out nocopy JTF_DATE_TABLE
750: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100
751: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_2000
752: , p9_a21 out nocopy JTF_DATE_TABLE
753: , p9_a22 out nocopy JTF_VARCHAR2_TABLE_100
754: , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
755: , p9_a24 out nocopy JTF_NUMBER_TABLE
756: )
757: