APPS.AHL_UC_INSTANCE_PVT_W dependencies on JTF_NUMBER_TABLE

Line 17: , a1 JTF_NUMBER_TABLE

13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p3(t out nocopy ahl_uc_instance_pvt.uc_child_tbl_type, a0 JTF_VARCHAR2_TABLE_100
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_VARCHAR2_TABLE_100
21: ) as

Line 18: , a2 JTF_NUMBER_TABLE

14: end;
15:
16: procedure rosetta_table_copy_in_p3(t out nocopy ahl_uc_instance_pvt.uc_child_tbl_type, a0 JTF_VARCHAR2_TABLE_100
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_VARCHAR2_TABLE_100
21: ) as
22: ddindx binary_integer; indx binary_integer;

Line 44: , a1 out nocopy JTF_NUMBER_TABLE

40: end if;
41: end if;
42: end rosetta_table_copy_in_p3;
43: procedure rosetta_table_copy_out_p3(t ahl_uc_instance_pvt.uc_child_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
44: , a1 out nocopy JTF_NUMBER_TABLE
45: , a2 out nocopy JTF_NUMBER_TABLE
46: , a3 out nocopy JTF_VARCHAR2_TABLE_100
47: , a4 out nocopy JTF_VARCHAR2_TABLE_100
48: ) as

Line 45: , a2 out nocopy JTF_NUMBER_TABLE

41: end if;
42: end rosetta_table_copy_in_p3;
43: procedure rosetta_table_copy_out_p3(t ahl_uc_instance_pvt.uc_child_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
44: , a1 out nocopy JTF_NUMBER_TABLE
45: , a2 out nocopy JTF_NUMBER_TABLE
46: , a3 out nocopy JTF_VARCHAR2_TABLE_100
47: , a4 out nocopy JTF_VARCHAR2_TABLE_100
48: ) as
49: ddindx binary_integer; indx binary_integer;

Line 53: a1 := JTF_NUMBER_TABLE();

49: ddindx binary_integer; indx binary_integer;
50: begin
51: if t is null or t.count = 0 then
52: a0 := JTF_VARCHAR2_TABLE_100();
53: a1 := JTF_NUMBER_TABLE();
54: a2 := JTF_NUMBER_TABLE();
55: a3 := JTF_VARCHAR2_TABLE_100();
56: a4 := JTF_VARCHAR2_TABLE_100();
57: else

Line 54: a2 := JTF_NUMBER_TABLE();

50: begin
51: if t is null or t.count = 0 then
52: a0 := JTF_VARCHAR2_TABLE_100();
53: a1 := JTF_NUMBER_TABLE();
54: a2 := JTF_NUMBER_TABLE();
55: a3 := JTF_VARCHAR2_TABLE_100();
56: a4 := JTF_VARCHAR2_TABLE_100();
57: else
58: a0 := JTF_VARCHAR2_TABLE_100();

Line 59: a1 := JTF_NUMBER_TABLE();

55: a3 := JTF_VARCHAR2_TABLE_100();
56: a4 := JTF_VARCHAR2_TABLE_100();
57: else
58: a0 := JTF_VARCHAR2_TABLE_100();
59: a1 := JTF_NUMBER_TABLE();
60: a2 := JTF_NUMBER_TABLE();
61: a3 := JTF_VARCHAR2_TABLE_100();
62: a4 := JTF_VARCHAR2_TABLE_100();
63: if t.count > 0 then

Line 60: a2 := JTF_NUMBER_TABLE();

56: a4 := JTF_VARCHAR2_TABLE_100();
57: else
58: a0 := JTF_VARCHAR2_TABLE_100();
59: a1 := JTF_NUMBER_TABLE();
60: a2 := JTF_NUMBER_TABLE();
61: a3 := JTF_VARCHAR2_TABLE_100();
62: a4 := JTF_VARCHAR2_TABLE_100();
63: if t.count > 0 then
64: a0.extend(t.count);

Line 88: , a1 JTF_NUMBER_TABLE

84: end if;
85: end rosetta_table_copy_out_p3;
86:
87: procedure rosetta_table_copy_in_p5(t out nocopy ahl_uc_instance_pvt.uc_descendant_tbl_type, a0 JTF_VARCHAR2_TABLE_100
88: , a1 JTF_NUMBER_TABLE
89: , a2 JTF_NUMBER_TABLE
90: , a3 JTF_NUMBER_TABLE
91: , a4 JTF_NUMBER_TABLE
92: , a5 JTF_VARCHAR2_TABLE_100

Line 89: , a2 JTF_NUMBER_TABLE

85: end rosetta_table_copy_out_p3;
86:
87: procedure rosetta_table_copy_in_p5(t out nocopy ahl_uc_instance_pvt.uc_descendant_tbl_type, a0 JTF_VARCHAR2_TABLE_100
88: , a1 JTF_NUMBER_TABLE
89: , a2 JTF_NUMBER_TABLE
90: , a3 JTF_NUMBER_TABLE
91: , a4 JTF_NUMBER_TABLE
92: , a5 JTF_VARCHAR2_TABLE_100
93: , a6 JTF_VARCHAR2_TABLE_100

Line 90: , a3 JTF_NUMBER_TABLE

86:
87: procedure rosetta_table_copy_in_p5(t out nocopy ahl_uc_instance_pvt.uc_descendant_tbl_type, a0 JTF_VARCHAR2_TABLE_100
88: , a1 JTF_NUMBER_TABLE
89: , a2 JTF_NUMBER_TABLE
90: , a3 JTF_NUMBER_TABLE
91: , a4 JTF_NUMBER_TABLE
92: , a5 JTF_VARCHAR2_TABLE_100
93: , a6 JTF_VARCHAR2_TABLE_100
94: ) as

Line 91: , a4 JTF_NUMBER_TABLE

87: procedure rosetta_table_copy_in_p5(t out nocopy ahl_uc_instance_pvt.uc_descendant_tbl_type, a0 JTF_VARCHAR2_TABLE_100
88: , a1 JTF_NUMBER_TABLE
89: , a2 JTF_NUMBER_TABLE
90: , a3 JTF_NUMBER_TABLE
91: , a4 JTF_NUMBER_TABLE
92: , a5 JTF_VARCHAR2_TABLE_100
93: , a6 JTF_VARCHAR2_TABLE_100
94: ) as
95: ddindx binary_integer; indx binary_integer;

Line 119: , a1 out nocopy JTF_NUMBER_TABLE

115: end if;
116: end if;
117: end rosetta_table_copy_in_p5;
118: procedure rosetta_table_copy_out_p5(t ahl_uc_instance_pvt.uc_descendant_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
119: , a1 out nocopy JTF_NUMBER_TABLE
120: , a2 out nocopy JTF_NUMBER_TABLE
121: , a3 out nocopy JTF_NUMBER_TABLE
122: , a4 out nocopy JTF_NUMBER_TABLE
123: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 120: , a2 out nocopy JTF_NUMBER_TABLE

116: end if;
117: end rosetta_table_copy_in_p5;
118: procedure rosetta_table_copy_out_p5(t ahl_uc_instance_pvt.uc_descendant_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
119: , a1 out nocopy JTF_NUMBER_TABLE
120: , a2 out nocopy JTF_NUMBER_TABLE
121: , a3 out nocopy JTF_NUMBER_TABLE
122: , a4 out nocopy JTF_NUMBER_TABLE
123: , a5 out nocopy JTF_VARCHAR2_TABLE_100
124: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 121: , a3 out nocopy JTF_NUMBER_TABLE

117: end rosetta_table_copy_in_p5;
118: procedure rosetta_table_copy_out_p5(t ahl_uc_instance_pvt.uc_descendant_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
119: , a1 out nocopy JTF_NUMBER_TABLE
120: , a2 out nocopy JTF_NUMBER_TABLE
121: , a3 out nocopy JTF_NUMBER_TABLE
122: , a4 out nocopy JTF_NUMBER_TABLE
123: , a5 out nocopy JTF_VARCHAR2_TABLE_100
124: , a6 out nocopy JTF_VARCHAR2_TABLE_100
125: ) as

Line 122: , a4 out nocopy JTF_NUMBER_TABLE

118: procedure rosetta_table_copy_out_p5(t ahl_uc_instance_pvt.uc_descendant_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
119: , a1 out nocopy JTF_NUMBER_TABLE
120: , a2 out nocopy JTF_NUMBER_TABLE
121: , a3 out nocopy JTF_NUMBER_TABLE
122: , a4 out nocopy JTF_NUMBER_TABLE
123: , a5 out nocopy JTF_VARCHAR2_TABLE_100
124: , a6 out nocopy JTF_VARCHAR2_TABLE_100
125: ) as
126: ddindx binary_integer; indx binary_integer;

Line 130: a1 := JTF_NUMBER_TABLE();

126: ddindx binary_integer; indx binary_integer;
127: begin
128: if t is null or t.count = 0 then
129: a0 := JTF_VARCHAR2_TABLE_100();
130: a1 := JTF_NUMBER_TABLE();
131: a2 := JTF_NUMBER_TABLE();
132: a3 := JTF_NUMBER_TABLE();
133: a4 := JTF_NUMBER_TABLE();
134: a5 := JTF_VARCHAR2_TABLE_100();

Line 131: a2 := JTF_NUMBER_TABLE();

127: begin
128: if t is null or t.count = 0 then
129: a0 := JTF_VARCHAR2_TABLE_100();
130: a1 := JTF_NUMBER_TABLE();
131: a2 := JTF_NUMBER_TABLE();
132: a3 := JTF_NUMBER_TABLE();
133: a4 := JTF_NUMBER_TABLE();
134: a5 := JTF_VARCHAR2_TABLE_100();
135: a6 := JTF_VARCHAR2_TABLE_100();

Line 132: a3 := JTF_NUMBER_TABLE();

128: if t is null or t.count = 0 then
129: a0 := JTF_VARCHAR2_TABLE_100();
130: a1 := JTF_NUMBER_TABLE();
131: a2 := JTF_NUMBER_TABLE();
132: a3 := JTF_NUMBER_TABLE();
133: a4 := JTF_NUMBER_TABLE();
134: a5 := JTF_VARCHAR2_TABLE_100();
135: a6 := JTF_VARCHAR2_TABLE_100();
136: else

Line 133: a4 := JTF_NUMBER_TABLE();

129: a0 := JTF_VARCHAR2_TABLE_100();
130: a1 := JTF_NUMBER_TABLE();
131: a2 := JTF_NUMBER_TABLE();
132: a3 := JTF_NUMBER_TABLE();
133: a4 := JTF_NUMBER_TABLE();
134: a5 := JTF_VARCHAR2_TABLE_100();
135: a6 := JTF_VARCHAR2_TABLE_100();
136: else
137: a0 := JTF_VARCHAR2_TABLE_100();

Line 138: a1 := JTF_NUMBER_TABLE();

134: a5 := JTF_VARCHAR2_TABLE_100();
135: a6 := JTF_VARCHAR2_TABLE_100();
136: else
137: a0 := JTF_VARCHAR2_TABLE_100();
138: a1 := JTF_NUMBER_TABLE();
139: a2 := JTF_NUMBER_TABLE();
140: a3 := JTF_NUMBER_TABLE();
141: a4 := JTF_NUMBER_TABLE();
142: a5 := JTF_VARCHAR2_TABLE_100();

Line 139: a2 := JTF_NUMBER_TABLE();

135: a6 := JTF_VARCHAR2_TABLE_100();
136: else
137: a0 := JTF_VARCHAR2_TABLE_100();
138: a1 := JTF_NUMBER_TABLE();
139: a2 := JTF_NUMBER_TABLE();
140: a3 := JTF_NUMBER_TABLE();
141: a4 := JTF_NUMBER_TABLE();
142: a5 := JTF_VARCHAR2_TABLE_100();
143: a6 := JTF_VARCHAR2_TABLE_100();

Line 140: a3 := JTF_NUMBER_TABLE();

136: else
137: a0 := JTF_VARCHAR2_TABLE_100();
138: a1 := JTF_NUMBER_TABLE();
139: a2 := JTF_NUMBER_TABLE();
140: a3 := JTF_NUMBER_TABLE();
141: a4 := JTF_NUMBER_TABLE();
142: a5 := JTF_VARCHAR2_TABLE_100();
143: a6 := JTF_VARCHAR2_TABLE_100();
144: if t.count > 0 then

Line 141: a4 := JTF_NUMBER_TABLE();

137: a0 := JTF_VARCHAR2_TABLE_100();
138: a1 := JTF_NUMBER_TABLE();
139: a2 := JTF_NUMBER_TABLE();
140: a3 := JTF_NUMBER_TABLE();
141: a4 := JTF_NUMBER_TABLE();
142: a5 := JTF_VARCHAR2_TABLE_100();
143: a6 := JTF_VARCHAR2_TABLE_100();
144: if t.count > 0 then
145: a0.extend(t.count);

Line 172: procedure rosetta_table_copy_in_p7(t out nocopy ahl_uc_instance_pvt.available_instance_tbl_type, a0 JTF_NUMBER_TABLE

168: end if;
169: end if;
170: end rosetta_table_copy_out_p5;
171:
172: procedure rosetta_table_copy_in_p7(t out nocopy ahl_uc_instance_pvt.available_instance_tbl_type, a0 JTF_NUMBER_TABLE
173: , a1 JTF_NUMBER_TABLE
174: , a2 JTF_NUMBER_TABLE
175: , a3 JTF_NUMBER_TABLE
176: , a4 JTF_VARCHAR2_TABLE_100

Line 173: , a1 JTF_NUMBER_TABLE

169: end if;
170: end rosetta_table_copy_out_p5;
171:
172: procedure rosetta_table_copy_in_p7(t out nocopy ahl_uc_instance_pvt.available_instance_tbl_type, a0 JTF_NUMBER_TABLE
173: , a1 JTF_NUMBER_TABLE
174: , a2 JTF_NUMBER_TABLE
175: , a3 JTF_NUMBER_TABLE
176: , a4 JTF_VARCHAR2_TABLE_100
177: , a5 JTF_VARCHAR2_TABLE_300

Line 174: , a2 JTF_NUMBER_TABLE

170: end rosetta_table_copy_out_p5;
171:
172: procedure rosetta_table_copy_in_p7(t out nocopy ahl_uc_instance_pvt.available_instance_tbl_type, a0 JTF_NUMBER_TABLE
173: , a1 JTF_NUMBER_TABLE
174: , a2 JTF_NUMBER_TABLE
175: , a3 JTF_NUMBER_TABLE
176: , a4 JTF_VARCHAR2_TABLE_100
177: , a5 JTF_VARCHAR2_TABLE_300
178: , a6 JTF_VARCHAR2_TABLE_300

Line 175: , a3 JTF_NUMBER_TABLE

171:
172: procedure rosetta_table_copy_in_p7(t out nocopy ahl_uc_instance_pvt.available_instance_tbl_type, a0 JTF_NUMBER_TABLE
173: , a1 JTF_NUMBER_TABLE
174: , a2 JTF_NUMBER_TABLE
175: , a3 JTF_NUMBER_TABLE
176: , a4 JTF_VARCHAR2_TABLE_100
177: , a5 JTF_VARCHAR2_TABLE_300
178: , a6 JTF_VARCHAR2_TABLE_300
179: , a7 JTF_VARCHAR2_TABLE_100

Line 184: , a12 JTF_NUMBER_TABLE

180: , a8 JTF_VARCHAR2_TABLE_100
181: , a9 JTF_VARCHAR2_TABLE_100
182: , a10 JTF_VARCHAR2_TABLE_100
183: , a11 JTF_VARCHAR2_TABLE_100
184: , a12 JTF_NUMBER_TABLE
185: , a13 JTF_NUMBER_TABLE
186: , a14 JTF_DATE_TABLE
187: , a15 JTF_DATE_TABLE
188: , a16 JTF_VARCHAR2_TABLE_4000

Line 185: , a13 JTF_NUMBER_TABLE

181: , a9 JTF_VARCHAR2_TABLE_100
182: , a10 JTF_VARCHAR2_TABLE_100
183: , a11 JTF_VARCHAR2_TABLE_100
184: , a12 JTF_NUMBER_TABLE
185: , a13 JTF_NUMBER_TABLE
186: , a14 JTF_DATE_TABLE
187: , a15 JTF_DATE_TABLE
188: , a16 JTF_VARCHAR2_TABLE_4000
189: , a17 JTF_VARCHAR2_TABLE_100

Line 190: , a18 JTF_NUMBER_TABLE

186: , a14 JTF_DATE_TABLE
187: , a15 JTF_DATE_TABLE
188: , a16 JTF_VARCHAR2_TABLE_4000
189: , a17 JTF_VARCHAR2_TABLE_100
190: , a18 JTF_NUMBER_TABLE
191: , a19 JTF_VARCHAR2_TABLE_400
192: , a20 JTF_VARCHAR2_TABLE_400
193: , a21 JTF_NUMBER_TABLE
194: , a22 JTF_VARCHAR2_TABLE_100

Line 193: , a21 JTF_NUMBER_TABLE

189: , a17 JTF_VARCHAR2_TABLE_100
190: , a18 JTF_NUMBER_TABLE
191: , a19 JTF_VARCHAR2_TABLE_400
192: , a20 JTF_VARCHAR2_TABLE_400
193: , a21 JTF_NUMBER_TABLE
194: , a22 JTF_VARCHAR2_TABLE_100
195: , a23 JTF_NUMBER_TABLE
196: , a24 JTF_VARCHAR2_TABLE_100
197: , a25 JTF_VARCHAR2_TABLE_300

Line 195: , a23 JTF_NUMBER_TABLE

191: , a19 JTF_VARCHAR2_TABLE_400
192: , a20 JTF_VARCHAR2_TABLE_400
193: , a21 JTF_NUMBER_TABLE
194: , a22 JTF_VARCHAR2_TABLE_100
195: , a23 JTF_NUMBER_TABLE
196: , a24 JTF_VARCHAR2_TABLE_100
197: , a25 JTF_VARCHAR2_TABLE_300
198: , a26 JTF_NUMBER_TABLE
199: , a27 JTF_VARCHAR2_TABLE_100

Line 198: , a26 JTF_NUMBER_TABLE

194: , a22 JTF_VARCHAR2_TABLE_100
195: , a23 JTF_NUMBER_TABLE
196: , a24 JTF_VARCHAR2_TABLE_100
197: , a25 JTF_VARCHAR2_TABLE_300
198: , a26 JTF_NUMBER_TABLE
199: , a27 JTF_VARCHAR2_TABLE_100
200: , a28 JTF_VARCHAR2_TABLE_100
201: , a29 JTF_NUMBER_TABLE
202: , a30 JTF_VARCHAR2_TABLE_100

Line 201: , a29 JTF_NUMBER_TABLE

197: , a25 JTF_VARCHAR2_TABLE_300
198: , a26 JTF_NUMBER_TABLE
199: , a27 JTF_VARCHAR2_TABLE_100
200: , a28 JTF_VARCHAR2_TABLE_100
201: , a29 JTF_NUMBER_TABLE
202: , a30 JTF_VARCHAR2_TABLE_100
203: , a31 JTF_VARCHAR2_TABLE_100
204: , a32 JTF_VARCHAR2_TABLE_100
205: , a33 JTF_VARCHAR2_TABLE_100

Line 207: , a35 JTF_NUMBER_TABLE

203: , a31 JTF_VARCHAR2_TABLE_100
204: , a32 JTF_VARCHAR2_TABLE_100
205: , a33 JTF_VARCHAR2_TABLE_100
206: , a34 JTF_VARCHAR2_TABLE_300
207: , a35 JTF_NUMBER_TABLE
208: , a36 JTF_VARCHAR2_TABLE_100
209: , a37 JTF_NUMBER_TABLE
210: , a38 JTF_VARCHAR2_TABLE_300
211: ) as

Line 209: , a37 JTF_NUMBER_TABLE

205: , a33 JTF_VARCHAR2_TABLE_100
206: , a34 JTF_VARCHAR2_TABLE_300
207: , a35 JTF_NUMBER_TABLE
208: , a36 JTF_VARCHAR2_TABLE_100
209: , a37 JTF_NUMBER_TABLE
210: , a38 JTF_VARCHAR2_TABLE_300
211: ) as
212: ddindx binary_integer; indx binary_integer;
213: begin

Line 267: procedure rosetta_table_copy_out_p7(t ahl_uc_instance_pvt.available_instance_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

263: end loop;
264: end if;
265: end if;
266: end rosetta_table_copy_in_p7;
267: procedure rosetta_table_copy_out_p7(t ahl_uc_instance_pvt.available_instance_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
268: , a1 out nocopy JTF_NUMBER_TABLE
269: , a2 out nocopy JTF_NUMBER_TABLE
270: , a3 out nocopy JTF_NUMBER_TABLE
271: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 268: , a1 out nocopy JTF_NUMBER_TABLE

264: end if;
265: end if;
266: end rosetta_table_copy_in_p7;
267: procedure rosetta_table_copy_out_p7(t ahl_uc_instance_pvt.available_instance_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
268: , a1 out nocopy JTF_NUMBER_TABLE
269: , a2 out nocopy JTF_NUMBER_TABLE
270: , a3 out nocopy JTF_NUMBER_TABLE
271: , a4 out nocopy JTF_VARCHAR2_TABLE_100
272: , a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 269: , a2 out nocopy JTF_NUMBER_TABLE

265: end if;
266: end rosetta_table_copy_in_p7;
267: procedure rosetta_table_copy_out_p7(t ahl_uc_instance_pvt.available_instance_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
268: , a1 out nocopy JTF_NUMBER_TABLE
269: , a2 out nocopy JTF_NUMBER_TABLE
270: , a3 out nocopy JTF_NUMBER_TABLE
271: , a4 out nocopy JTF_VARCHAR2_TABLE_100
272: , a5 out nocopy JTF_VARCHAR2_TABLE_300
273: , a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 270: , a3 out nocopy JTF_NUMBER_TABLE

266: end rosetta_table_copy_in_p7;
267: procedure rosetta_table_copy_out_p7(t ahl_uc_instance_pvt.available_instance_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
268: , a1 out nocopy JTF_NUMBER_TABLE
269: , a2 out nocopy JTF_NUMBER_TABLE
270: , a3 out nocopy JTF_NUMBER_TABLE
271: , a4 out nocopy JTF_VARCHAR2_TABLE_100
272: , a5 out nocopy JTF_VARCHAR2_TABLE_300
273: , a6 out nocopy JTF_VARCHAR2_TABLE_300
274: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 279: , a12 out nocopy JTF_NUMBER_TABLE

275: , a8 out nocopy JTF_VARCHAR2_TABLE_100
276: , a9 out nocopy JTF_VARCHAR2_TABLE_100
277: , a10 out nocopy JTF_VARCHAR2_TABLE_100
278: , a11 out nocopy JTF_VARCHAR2_TABLE_100
279: , a12 out nocopy JTF_NUMBER_TABLE
280: , a13 out nocopy JTF_NUMBER_TABLE
281: , a14 out nocopy JTF_DATE_TABLE
282: , a15 out nocopy JTF_DATE_TABLE
283: , a16 out nocopy JTF_VARCHAR2_TABLE_4000

Line 280: , a13 out nocopy JTF_NUMBER_TABLE

276: , a9 out nocopy JTF_VARCHAR2_TABLE_100
277: , a10 out nocopy JTF_VARCHAR2_TABLE_100
278: , a11 out nocopy JTF_VARCHAR2_TABLE_100
279: , a12 out nocopy JTF_NUMBER_TABLE
280: , a13 out nocopy JTF_NUMBER_TABLE
281: , a14 out nocopy JTF_DATE_TABLE
282: , a15 out nocopy JTF_DATE_TABLE
283: , a16 out nocopy JTF_VARCHAR2_TABLE_4000
284: , a17 out nocopy JTF_VARCHAR2_TABLE_100

Line 285: , a18 out nocopy JTF_NUMBER_TABLE

281: , a14 out nocopy JTF_DATE_TABLE
282: , a15 out nocopy JTF_DATE_TABLE
283: , a16 out nocopy JTF_VARCHAR2_TABLE_4000
284: , a17 out nocopy JTF_VARCHAR2_TABLE_100
285: , a18 out nocopy JTF_NUMBER_TABLE
286: , a19 out nocopy JTF_VARCHAR2_TABLE_400
287: , a20 out nocopy JTF_VARCHAR2_TABLE_400
288: , a21 out nocopy JTF_NUMBER_TABLE
289: , a22 out nocopy JTF_VARCHAR2_TABLE_100

Line 288: , a21 out nocopy JTF_NUMBER_TABLE

284: , a17 out nocopy JTF_VARCHAR2_TABLE_100
285: , a18 out nocopy JTF_NUMBER_TABLE
286: , a19 out nocopy JTF_VARCHAR2_TABLE_400
287: , a20 out nocopy JTF_VARCHAR2_TABLE_400
288: , a21 out nocopy JTF_NUMBER_TABLE
289: , a22 out nocopy JTF_VARCHAR2_TABLE_100
290: , a23 out nocopy JTF_NUMBER_TABLE
291: , a24 out nocopy JTF_VARCHAR2_TABLE_100
292: , a25 out nocopy JTF_VARCHAR2_TABLE_300

Line 290: , a23 out nocopy JTF_NUMBER_TABLE

286: , a19 out nocopy JTF_VARCHAR2_TABLE_400
287: , a20 out nocopy JTF_VARCHAR2_TABLE_400
288: , a21 out nocopy JTF_NUMBER_TABLE
289: , a22 out nocopy JTF_VARCHAR2_TABLE_100
290: , a23 out nocopy JTF_NUMBER_TABLE
291: , a24 out nocopy JTF_VARCHAR2_TABLE_100
292: , a25 out nocopy JTF_VARCHAR2_TABLE_300
293: , a26 out nocopy JTF_NUMBER_TABLE
294: , a27 out nocopy JTF_VARCHAR2_TABLE_100

Line 293: , a26 out nocopy JTF_NUMBER_TABLE

289: , a22 out nocopy JTF_VARCHAR2_TABLE_100
290: , a23 out nocopy JTF_NUMBER_TABLE
291: , a24 out nocopy JTF_VARCHAR2_TABLE_100
292: , a25 out nocopy JTF_VARCHAR2_TABLE_300
293: , a26 out nocopy JTF_NUMBER_TABLE
294: , a27 out nocopy JTF_VARCHAR2_TABLE_100
295: , a28 out nocopy JTF_VARCHAR2_TABLE_100
296: , a29 out nocopy JTF_NUMBER_TABLE
297: , a30 out nocopy JTF_VARCHAR2_TABLE_100

Line 296: , a29 out nocopy JTF_NUMBER_TABLE

292: , a25 out nocopy JTF_VARCHAR2_TABLE_300
293: , a26 out nocopy JTF_NUMBER_TABLE
294: , a27 out nocopy JTF_VARCHAR2_TABLE_100
295: , a28 out nocopy JTF_VARCHAR2_TABLE_100
296: , a29 out nocopy JTF_NUMBER_TABLE
297: , a30 out nocopy JTF_VARCHAR2_TABLE_100
298: , a31 out nocopy JTF_VARCHAR2_TABLE_100
299: , a32 out nocopy JTF_VARCHAR2_TABLE_100
300: , a33 out nocopy JTF_VARCHAR2_TABLE_100

Line 302: , a35 out nocopy JTF_NUMBER_TABLE

298: , a31 out nocopy JTF_VARCHAR2_TABLE_100
299: , a32 out nocopy JTF_VARCHAR2_TABLE_100
300: , a33 out nocopy JTF_VARCHAR2_TABLE_100
301: , a34 out nocopy JTF_VARCHAR2_TABLE_300
302: , a35 out nocopy JTF_NUMBER_TABLE
303: , a36 out nocopy JTF_VARCHAR2_TABLE_100
304: , a37 out nocopy JTF_NUMBER_TABLE
305: , a38 out nocopy JTF_VARCHAR2_TABLE_300
306: ) as

Line 304: , a37 out nocopy JTF_NUMBER_TABLE

300: , a33 out nocopy JTF_VARCHAR2_TABLE_100
301: , a34 out nocopy JTF_VARCHAR2_TABLE_300
302: , a35 out nocopy JTF_NUMBER_TABLE
303: , a36 out nocopy JTF_VARCHAR2_TABLE_100
304: , a37 out nocopy JTF_NUMBER_TABLE
305: , a38 out nocopy JTF_VARCHAR2_TABLE_300
306: ) as
307: ddindx binary_integer; indx binary_integer;
308: begin

Line 310: a0 := JTF_NUMBER_TABLE();

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

Line 311: a1 := JTF_NUMBER_TABLE();

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

Line 312: a2 := JTF_NUMBER_TABLE();

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

Line 313: a3 := JTF_NUMBER_TABLE();

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

Line 322: a12 := JTF_NUMBER_TABLE();

318: a8 := JTF_VARCHAR2_TABLE_100();
319: a9 := JTF_VARCHAR2_TABLE_100();
320: a10 := JTF_VARCHAR2_TABLE_100();
321: a11 := JTF_VARCHAR2_TABLE_100();
322: a12 := JTF_NUMBER_TABLE();
323: a13 := JTF_NUMBER_TABLE();
324: a14 := JTF_DATE_TABLE();
325: a15 := JTF_DATE_TABLE();
326: a16 := JTF_VARCHAR2_TABLE_4000();

Line 323: a13 := JTF_NUMBER_TABLE();

319: a9 := JTF_VARCHAR2_TABLE_100();
320: a10 := JTF_VARCHAR2_TABLE_100();
321: a11 := JTF_VARCHAR2_TABLE_100();
322: a12 := JTF_NUMBER_TABLE();
323: a13 := JTF_NUMBER_TABLE();
324: a14 := JTF_DATE_TABLE();
325: a15 := JTF_DATE_TABLE();
326: a16 := JTF_VARCHAR2_TABLE_4000();
327: a17 := JTF_VARCHAR2_TABLE_100();

Line 328: a18 := JTF_NUMBER_TABLE();

324: a14 := JTF_DATE_TABLE();
325: a15 := JTF_DATE_TABLE();
326: a16 := JTF_VARCHAR2_TABLE_4000();
327: a17 := JTF_VARCHAR2_TABLE_100();
328: a18 := JTF_NUMBER_TABLE();
329: a19 := JTF_VARCHAR2_TABLE_400();
330: a20 := JTF_VARCHAR2_TABLE_400();
331: a21 := JTF_NUMBER_TABLE();
332: a22 := JTF_VARCHAR2_TABLE_100();

Line 331: a21 := JTF_NUMBER_TABLE();

327: a17 := JTF_VARCHAR2_TABLE_100();
328: a18 := JTF_NUMBER_TABLE();
329: a19 := JTF_VARCHAR2_TABLE_400();
330: a20 := JTF_VARCHAR2_TABLE_400();
331: a21 := JTF_NUMBER_TABLE();
332: a22 := JTF_VARCHAR2_TABLE_100();
333: a23 := JTF_NUMBER_TABLE();
334: a24 := JTF_VARCHAR2_TABLE_100();
335: a25 := JTF_VARCHAR2_TABLE_300();

Line 333: a23 := JTF_NUMBER_TABLE();

329: a19 := JTF_VARCHAR2_TABLE_400();
330: a20 := JTF_VARCHAR2_TABLE_400();
331: a21 := JTF_NUMBER_TABLE();
332: a22 := JTF_VARCHAR2_TABLE_100();
333: a23 := JTF_NUMBER_TABLE();
334: a24 := JTF_VARCHAR2_TABLE_100();
335: a25 := JTF_VARCHAR2_TABLE_300();
336: a26 := JTF_NUMBER_TABLE();
337: a27 := JTF_VARCHAR2_TABLE_100();

Line 336: a26 := JTF_NUMBER_TABLE();

332: a22 := JTF_VARCHAR2_TABLE_100();
333: a23 := JTF_NUMBER_TABLE();
334: a24 := JTF_VARCHAR2_TABLE_100();
335: a25 := JTF_VARCHAR2_TABLE_300();
336: a26 := JTF_NUMBER_TABLE();
337: a27 := JTF_VARCHAR2_TABLE_100();
338: a28 := JTF_VARCHAR2_TABLE_100();
339: a29 := JTF_NUMBER_TABLE();
340: a30 := JTF_VARCHAR2_TABLE_100();

Line 339: a29 := JTF_NUMBER_TABLE();

335: a25 := JTF_VARCHAR2_TABLE_300();
336: a26 := JTF_NUMBER_TABLE();
337: a27 := JTF_VARCHAR2_TABLE_100();
338: a28 := JTF_VARCHAR2_TABLE_100();
339: a29 := JTF_NUMBER_TABLE();
340: a30 := JTF_VARCHAR2_TABLE_100();
341: a31 := JTF_VARCHAR2_TABLE_100();
342: a32 := JTF_VARCHAR2_TABLE_100();
343: a33 := JTF_VARCHAR2_TABLE_100();

Line 345: a35 := JTF_NUMBER_TABLE();

341: a31 := JTF_VARCHAR2_TABLE_100();
342: a32 := JTF_VARCHAR2_TABLE_100();
343: a33 := JTF_VARCHAR2_TABLE_100();
344: a34 := JTF_VARCHAR2_TABLE_300();
345: a35 := JTF_NUMBER_TABLE();
346: a36 := JTF_VARCHAR2_TABLE_100();
347: a37 := JTF_NUMBER_TABLE();
348: a38 := JTF_VARCHAR2_TABLE_300();
349: else

Line 347: a37 := JTF_NUMBER_TABLE();

343: a33 := JTF_VARCHAR2_TABLE_100();
344: a34 := JTF_VARCHAR2_TABLE_300();
345: a35 := JTF_NUMBER_TABLE();
346: a36 := JTF_VARCHAR2_TABLE_100();
347: a37 := JTF_NUMBER_TABLE();
348: a38 := JTF_VARCHAR2_TABLE_300();
349: else
350: a0 := JTF_NUMBER_TABLE();
351: a1 := JTF_NUMBER_TABLE();

Line 350: a0 := JTF_NUMBER_TABLE();

346: a36 := JTF_VARCHAR2_TABLE_100();
347: a37 := JTF_NUMBER_TABLE();
348: a38 := JTF_VARCHAR2_TABLE_300();
349: else
350: a0 := JTF_NUMBER_TABLE();
351: a1 := JTF_NUMBER_TABLE();
352: a2 := JTF_NUMBER_TABLE();
353: a3 := JTF_NUMBER_TABLE();
354: a4 := JTF_VARCHAR2_TABLE_100();

Line 351: a1 := JTF_NUMBER_TABLE();

347: a37 := JTF_NUMBER_TABLE();
348: a38 := JTF_VARCHAR2_TABLE_300();
349: else
350: a0 := JTF_NUMBER_TABLE();
351: a1 := JTF_NUMBER_TABLE();
352: a2 := JTF_NUMBER_TABLE();
353: a3 := JTF_NUMBER_TABLE();
354: a4 := JTF_VARCHAR2_TABLE_100();
355: a5 := JTF_VARCHAR2_TABLE_300();

Line 352: a2 := JTF_NUMBER_TABLE();

348: a38 := JTF_VARCHAR2_TABLE_300();
349: else
350: a0 := JTF_NUMBER_TABLE();
351: a1 := JTF_NUMBER_TABLE();
352: a2 := JTF_NUMBER_TABLE();
353: a3 := JTF_NUMBER_TABLE();
354: a4 := JTF_VARCHAR2_TABLE_100();
355: a5 := JTF_VARCHAR2_TABLE_300();
356: a6 := JTF_VARCHAR2_TABLE_300();

Line 353: a3 := JTF_NUMBER_TABLE();

349: else
350: a0 := JTF_NUMBER_TABLE();
351: a1 := JTF_NUMBER_TABLE();
352: a2 := JTF_NUMBER_TABLE();
353: a3 := JTF_NUMBER_TABLE();
354: a4 := JTF_VARCHAR2_TABLE_100();
355: a5 := JTF_VARCHAR2_TABLE_300();
356: a6 := JTF_VARCHAR2_TABLE_300();
357: a7 := JTF_VARCHAR2_TABLE_100();

Line 362: a12 := JTF_NUMBER_TABLE();

358: a8 := JTF_VARCHAR2_TABLE_100();
359: a9 := JTF_VARCHAR2_TABLE_100();
360: a10 := JTF_VARCHAR2_TABLE_100();
361: a11 := JTF_VARCHAR2_TABLE_100();
362: a12 := JTF_NUMBER_TABLE();
363: a13 := JTF_NUMBER_TABLE();
364: a14 := JTF_DATE_TABLE();
365: a15 := JTF_DATE_TABLE();
366: a16 := JTF_VARCHAR2_TABLE_4000();

Line 363: a13 := JTF_NUMBER_TABLE();

359: a9 := JTF_VARCHAR2_TABLE_100();
360: a10 := JTF_VARCHAR2_TABLE_100();
361: a11 := JTF_VARCHAR2_TABLE_100();
362: a12 := JTF_NUMBER_TABLE();
363: a13 := JTF_NUMBER_TABLE();
364: a14 := JTF_DATE_TABLE();
365: a15 := JTF_DATE_TABLE();
366: a16 := JTF_VARCHAR2_TABLE_4000();
367: a17 := JTF_VARCHAR2_TABLE_100();

Line 368: a18 := JTF_NUMBER_TABLE();

364: a14 := JTF_DATE_TABLE();
365: a15 := JTF_DATE_TABLE();
366: a16 := JTF_VARCHAR2_TABLE_4000();
367: a17 := JTF_VARCHAR2_TABLE_100();
368: a18 := JTF_NUMBER_TABLE();
369: a19 := JTF_VARCHAR2_TABLE_400();
370: a20 := JTF_VARCHAR2_TABLE_400();
371: a21 := JTF_NUMBER_TABLE();
372: a22 := JTF_VARCHAR2_TABLE_100();

Line 371: a21 := JTF_NUMBER_TABLE();

367: a17 := JTF_VARCHAR2_TABLE_100();
368: a18 := JTF_NUMBER_TABLE();
369: a19 := JTF_VARCHAR2_TABLE_400();
370: a20 := JTF_VARCHAR2_TABLE_400();
371: a21 := JTF_NUMBER_TABLE();
372: a22 := JTF_VARCHAR2_TABLE_100();
373: a23 := JTF_NUMBER_TABLE();
374: a24 := JTF_VARCHAR2_TABLE_100();
375: a25 := JTF_VARCHAR2_TABLE_300();

Line 373: a23 := JTF_NUMBER_TABLE();

369: a19 := JTF_VARCHAR2_TABLE_400();
370: a20 := JTF_VARCHAR2_TABLE_400();
371: a21 := JTF_NUMBER_TABLE();
372: a22 := JTF_VARCHAR2_TABLE_100();
373: a23 := JTF_NUMBER_TABLE();
374: a24 := JTF_VARCHAR2_TABLE_100();
375: a25 := JTF_VARCHAR2_TABLE_300();
376: a26 := JTF_NUMBER_TABLE();
377: a27 := JTF_VARCHAR2_TABLE_100();

Line 376: a26 := JTF_NUMBER_TABLE();

372: a22 := JTF_VARCHAR2_TABLE_100();
373: a23 := JTF_NUMBER_TABLE();
374: a24 := JTF_VARCHAR2_TABLE_100();
375: a25 := JTF_VARCHAR2_TABLE_300();
376: a26 := JTF_NUMBER_TABLE();
377: a27 := JTF_VARCHAR2_TABLE_100();
378: a28 := JTF_VARCHAR2_TABLE_100();
379: a29 := JTF_NUMBER_TABLE();
380: a30 := JTF_VARCHAR2_TABLE_100();

Line 379: a29 := JTF_NUMBER_TABLE();

375: a25 := JTF_VARCHAR2_TABLE_300();
376: a26 := JTF_NUMBER_TABLE();
377: a27 := JTF_VARCHAR2_TABLE_100();
378: a28 := JTF_VARCHAR2_TABLE_100();
379: a29 := JTF_NUMBER_TABLE();
380: a30 := JTF_VARCHAR2_TABLE_100();
381: a31 := JTF_VARCHAR2_TABLE_100();
382: a32 := JTF_VARCHAR2_TABLE_100();
383: a33 := JTF_VARCHAR2_TABLE_100();

Line 385: a35 := JTF_NUMBER_TABLE();

381: a31 := JTF_VARCHAR2_TABLE_100();
382: a32 := JTF_VARCHAR2_TABLE_100();
383: a33 := JTF_VARCHAR2_TABLE_100();
384: a34 := JTF_VARCHAR2_TABLE_300();
385: a35 := JTF_NUMBER_TABLE();
386: a36 := JTF_VARCHAR2_TABLE_100();
387: a37 := JTF_NUMBER_TABLE();
388: a38 := JTF_VARCHAR2_TABLE_300();
389: if t.count > 0 then

Line 387: a37 := JTF_NUMBER_TABLE();

383: a33 := JTF_VARCHAR2_TABLE_100();
384: a34 := JTF_VARCHAR2_TABLE_300();
385: a35 := JTF_NUMBER_TABLE();
386: a36 := JTF_VARCHAR2_TABLE_100();
387: a37 := JTF_NUMBER_TABLE();
388: a38 := JTF_VARCHAR2_TABLE_300();
389: if t.count > 0 then
390: a0.extend(t.count);
391: a1.extend(t.count);

Line 1088: , p14_a0 out nocopy JTF_NUMBER_TABLE

1084: , p_instance_number VARCHAR2
1085: , p_workorder_id NUMBER
1086: , p_start_row_index NUMBER
1087: , p_max_rows NUMBER
1088: , p14_a0 out nocopy JTF_NUMBER_TABLE
1089: , p14_a1 out nocopy JTF_NUMBER_TABLE
1090: , p14_a2 out nocopy JTF_NUMBER_TABLE
1091: , p14_a3 out nocopy JTF_NUMBER_TABLE
1092: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1089: , p14_a1 out nocopy JTF_NUMBER_TABLE

1085: , p_workorder_id NUMBER
1086: , p_start_row_index NUMBER
1087: , p_max_rows NUMBER
1088: , p14_a0 out nocopy JTF_NUMBER_TABLE
1089: , p14_a1 out nocopy JTF_NUMBER_TABLE
1090: , p14_a2 out nocopy JTF_NUMBER_TABLE
1091: , p14_a3 out nocopy JTF_NUMBER_TABLE
1092: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_100
1093: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 1090: , p14_a2 out nocopy JTF_NUMBER_TABLE

1086: , p_start_row_index NUMBER
1087: , p_max_rows NUMBER
1088: , p14_a0 out nocopy JTF_NUMBER_TABLE
1089: , p14_a1 out nocopy JTF_NUMBER_TABLE
1090: , p14_a2 out nocopy JTF_NUMBER_TABLE
1091: , p14_a3 out nocopy JTF_NUMBER_TABLE
1092: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_100
1093: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_300
1094: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 1091: , p14_a3 out nocopy JTF_NUMBER_TABLE

1087: , p_max_rows NUMBER
1088: , p14_a0 out nocopy JTF_NUMBER_TABLE
1089: , p14_a1 out nocopy JTF_NUMBER_TABLE
1090: , p14_a2 out nocopy JTF_NUMBER_TABLE
1091: , p14_a3 out nocopy JTF_NUMBER_TABLE
1092: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_100
1093: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_300
1094: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_300
1095: , p14_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 1100: , p14_a12 out nocopy JTF_NUMBER_TABLE

1096: , p14_a8 out nocopy JTF_VARCHAR2_TABLE_100
1097: , p14_a9 out nocopy JTF_VARCHAR2_TABLE_100
1098: , p14_a10 out nocopy JTF_VARCHAR2_TABLE_100
1099: , p14_a11 out nocopy JTF_VARCHAR2_TABLE_100
1100: , p14_a12 out nocopy JTF_NUMBER_TABLE
1101: , p14_a13 out nocopy JTF_NUMBER_TABLE
1102: , p14_a14 out nocopy JTF_DATE_TABLE
1103: , p14_a15 out nocopy JTF_DATE_TABLE
1104: , p14_a16 out nocopy JTF_VARCHAR2_TABLE_4000

Line 1101: , p14_a13 out nocopy JTF_NUMBER_TABLE

1097: , p14_a9 out nocopy JTF_VARCHAR2_TABLE_100
1098: , p14_a10 out nocopy JTF_VARCHAR2_TABLE_100
1099: , p14_a11 out nocopy JTF_VARCHAR2_TABLE_100
1100: , p14_a12 out nocopy JTF_NUMBER_TABLE
1101: , p14_a13 out nocopy JTF_NUMBER_TABLE
1102: , p14_a14 out nocopy JTF_DATE_TABLE
1103: , p14_a15 out nocopy JTF_DATE_TABLE
1104: , p14_a16 out nocopy JTF_VARCHAR2_TABLE_4000
1105: , p14_a17 out nocopy JTF_VARCHAR2_TABLE_100

Line 1106: , p14_a18 out nocopy JTF_NUMBER_TABLE

1102: , p14_a14 out nocopy JTF_DATE_TABLE
1103: , p14_a15 out nocopy JTF_DATE_TABLE
1104: , p14_a16 out nocopy JTF_VARCHAR2_TABLE_4000
1105: , p14_a17 out nocopy JTF_VARCHAR2_TABLE_100
1106: , p14_a18 out nocopy JTF_NUMBER_TABLE
1107: , p14_a19 out nocopy JTF_VARCHAR2_TABLE_400
1108: , p14_a20 out nocopy JTF_VARCHAR2_TABLE_400
1109: , p14_a21 out nocopy JTF_NUMBER_TABLE
1110: , p14_a22 out nocopy JTF_VARCHAR2_TABLE_100

Line 1109: , p14_a21 out nocopy JTF_NUMBER_TABLE

1105: , p14_a17 out nocopy JTF_VARCHAR2_TABLE_100
1106: , p14_a18 out nocopy JTF_NUMBER_TABLE
1107: , p14_a19 out nocopy JTF_VARCHAR2_TABLE_400
1108: , p14_a20 out nocopy JTF_VARCHAR2_TABLE_400
1109: , p14_a21 out nocopy JTF_NUMBER_TABLE
1110: , p14_a22 out nocopy JTF_VARCHAR2_TABLE_100
1111: , p14_a23 out nocopy JTF_NUMBER_TABLE
1112: , p14_a24 out nocopy JTF_VARCHAR2_TABLE_100
1113: , p14_a25 out nocopy JTF_VARCHAR2_TABLE_300

Line 1111: , p14_a23 out nocopy JTF_NUMBER_TABLE

1107: , p14_a19 out nocopy JTF_VARCHAR2_TABLE_400
1108: , p14_a20 out nocopy JTF_VARCHAR2_TABLE_400
1109: , p14_a21 out nocopy JTF_NUMBER_TABLE
1110: , p14_a22 out nocopy JTF_VARCHAR2_TABLE_100
1111: , p14_a23 out nocopy JTF_NUMBER_TABLE
1112: , p14_a24 out nocopy JTF_VARCHAR2_TABLE_100
1113: , p14_a25 out nocopy JTF_VARCHAR2_TABLE_300
1114: , p14_a26 out nocopy JTF_NUMBER_TABLE
1115: , p14_a27 out nocopy JTF_VARCHAR2_TABLE_100

Line 1114: , p14_a26 out nocopy JTF_NUMBER_TABLE

1110: , p14_a22 out nocopy JTF_VARCHAR2_TABLE_100
1111: , p14_a23 out nocopy JTF_NUMBER_TABLE
1112: , p14_a24 out nocopy JTF_VARCHAR2_TABLE_100
1113: , p14_a25 out nocopy JTF_VARCHAR2_TABLE_300
1114: , p14_a26 out nocopy JTF_NUMBER_TABLE
1115: , p14_a27 out nocopy JTF_VARCHAR2_TABLE_100
1116: , p14_a28 out nocopy JTF_VARCHAR2_TABLE_100
1117: , p14_a29 out nocopy JTF_NUMBER_TABLE
1118: , p14_a30 out nocopy JTF_VARCHAR2_TABLE_100

Line 1117: , p14_a29 out nocopy JTF_NUMBER_TABLE

1113: , p14_a25 out nocopy JTF_VARCHAR2_TABLE_300
1114: , p14_a26 out nocopy JTF_NUMBER_TABLE
1115: , p14_a27 out nocopy JTF_VARCHAR2_TABLE_100
1116: , p14_a28 out nocopy JTF_VARCHAR2_TABLE_100
1117: , p14_a29 out nocopy JTF_NUMBER_TABLE
1118: , p14_a30 out nocopy JTF_VARCHAR2_TABLE_100
1119: , p14_a31 out nocopy JTF_VARCHAR2_TABLE_100
1120: , p14_a32 out nocopy JTF_VARCHAR2_TABLE_100
1121: , p14_a33 out nocopy JTF_VARCHAR2_TABLE_100

Line 1123: , p14_a35 out nocopy JTF_NUMBER_TABLE

1119: , p14_a31 out nocopy JTF_VARCHAR2_TABLE_100
1120: , p14_a32 out nocopy JTF_VARCHAR2_TABLE_100
1121: , p14_a33 out nocopy JTF_VARCHAR2_TABLE_100
1122: , p14_a34 out nocopy JTF_VARCHAR2_TABLE_300
1123: , p14_a35 out nocopy JTF_NUMBER_TABLE
1124: , p14_a36 out nocopy JTF_VARCHAR2_TABLE_100
1125: , p14_a37 out nocopy JTF_NUMBER_TABLE
1126: , p14_a38 out nocopy JTF_VARCHAR2_TABLE_300
1127: , x_tbl_count out nocopy NUMBER

Line 1125: , p14_a37 out nocopy JTF_NUMBER_TABLE

1121: , p14_a33 out nocopy JTF_VARCHAR2_TABLE_100
1122: , p14_a34 out nocopy JTF_VARCHAR2_TABLE_300
1123: , p14_a35 out nocopy JTF_NUMBER_TABLE
1124: , p14_a36 out nocopy JTF_VARCHAR2_TABLE_100
1125: , p14_a37 out nocopy JTF_NUMBER_TABLE
1126: , p14_a38 out nocopy JTF_VARCHAR2_TABLE_300
1127: , x_tbl_count out nocopy NUMBER
1128: )
1129:

Line 1241: , p13_a0 out nocopy JTF_NUMBER_TABLE

1237: , p_instance_number VARCHAR2
1238: , p_workorder_id NUMBER
1239: , p_start_row_index NUMBER
1240: , p_max_rows NUMBER
1241: , p13_a0 out nocopy JTF_NUMBER_TABLE
1242: , p13_a1 out nocopy JTF_NUMBER_TABLE
1243: , p13_a2 out nocopy JTF_NUMBER_TABLE
1244: , p13_a3 out nocopy JTF_NUMBER_TABLE
1245: , p13_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1242: , p13_a1 out nocopy JTF_NUMBER_TABLE

1238: , p_workorder_id NUMBER
1239: , p_start_row_index NUMBER
1240: , p_max_rows NUMBER
1241: , p13_a0 out nocopy JTF_NUMBER_TABLE
1242: , p13_a1 out nocopy JTF_NUMBER_TABLE
1243: , p13_a2 out nocopy JTF_NUMBER_TABLE
1244: , p13_a3 out nocopy JTF_NUMBER_TABLE
1245: , p13_a4 out nocopy JTF_VARCHAR2_TABLE_100
1246: , p13_a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 1243: , p13_a2 out nocopy JTF_NUMBER_TABLE

1239: , p_start_row_index NUMBER
1240: , p_max_rows NUMBER
1241: , p13_a0 out nocopy JTF_NUMBER_TABLE
1242: , p13_a1 out nocopy JTF_NUMBER_TABLE
1243: , p13_a2 out nocopy JTF_NUMBER_TABLE
1244: , p13_a3 out nocopy JTF_NUMBER_TABLE
1245: , p13_a4 out nocopy JTF_VARCHAR2_TABLE_100
1246: , p13_a5 out nocopy JTF_VARCHAR2_TABLE_300
1247: , p13_a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 1244: , p13_a3 out nocopy JTF_NUMBER_TABLE

1240: , p_max_rows NUMBER
1241: , p13_a0 out nocopy JTF_NUMBER_TABLE
1242: , p13_a1 out nocopy JTF_NUMBER_TABLE
1243: , p13_a2 out nocopy JTF_NUMBER_TABLE
1244: , p13_a3 out nocopy JTF_NUMBER_TABLE
1245: , p13_a4 out nocopy JTF_VARCHAR2_TABLE_100
1246: , p13_a5 out nocopy JTF_VARCHAR2_TABLE_300
1247: , p13_a6 out nocopy JTF_VARCHAR2_TABLE_300
1248: , p13_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 1253: , p13_a12 out nocopy JTF_NUMBER_TABLE

1249: , p13_a8 out nocopy JTF_VARCHAR2_TABLE_100
1250: , p13_a9 out nocopy JTF_VARCHAR2_TABLE_100
1251: , p13_a10 out nocopy JTF_VARCHAR2_TABLE_100
1252: , p13_a11 out nocopy JTF_VARCHAR2_TABLE_100
1253: , p13_a12 out nocopy JTF_NUMBER_TABLE
1254: , p13_a13 out nocopy JTF_NUMBER_TABLE
1255: , p13_a14 out nocopy JTF_DATE_TABLE
1256: , p13_a15 out nocopy JTF_DATE_TABLE
1257: , p13_a16 out nocopy JTF_VARCHAR2_TABLE_4000

Line 1254: , p13_a13 out nocopy JTF_NUMBER_TABLE

1250: , p13_a9 out nocopy JTF_VARCHAR2_TABLE_100
1251: , p13_a10 out nocopy JTF_VARCHAR2_TABLE_100
1252: , p13_a11 out nocopy JTF_VARCHAR2_TABLE_100
1253: , p13_a12 out nocopy JTF_NUMBER_TABLE
1254: , p13_a13 out nocopy JTF_NUMBER_TABLE
1255: , p13_a14 out nocopy JTF_DATE_TABLE
1256: , p13_a15 out nocopy JTF_DATE_TABLE
1257: , p13_a16 out nocopy JTF_VARCHAR2_TABLE_4000
1258: , p13_a17 out nocopy JTF_VARCHAR2_TABLE_100

Line 1259: , p13_a18 out nocopy JTF_NUMBER_TABLE

1255: , p13_a14 out nocopy JTF_DATE_TABLE
1256: , p13_a15 out nocopy JTF_DATE_TABLE
1257: , p13_a16 out nocopy JTF_VARCHAR2_TABLE_4000
1258: , p13_a17 out nocopy JTF_VARCHAR2_TABLE_100
1259: , p13_a18 out nocopy JTF_NUMBER_TABLE
1260: , p13_a19 out nocopy JTF_VARCHAR2_TABLE_400
1261: , p13_a20 out nocopy JTF_VARCHAR2_TABLE_400
1262: , p13_a21 out nocopy JTF_NUMBER_TABLE
1263: , p13_a22 out nocopy JTF_VARCHAR2_TABLE_100

Line 1262: , p13_a21 out nocopy JTF_NUMBER_TABLE

1258: , p13_a17 out nocopy JTF_VARCHAR2_TABLE_100
1259: , p13_a18 out nocopy JTF_NUMBER_TABLE
1260: , p13_a19 out nocopy JTF_VARCHAR2_TABLE_400
1261: , p13_a20 out nocopy JTF_VARCHAR2_TABLE_400
1262: , p13_a21 out nocopy JTF_NUMBER_TABLE
1263: , p13_a22 out nocopy JTF_VARCHAR2_TABLE_100
1264: , p13_a23 out nocopy JTF_NUMBER_TABLE
1265: , p13_a24 out nocopy JTF_VARCHAR2_TABLE_100
1266: , p13_a25 out nocopy JTF_VARCHAR2_TABLE_300

Line 1264: , p13_a23 out nocopy JTF_NUMBER_TABLE

1260: , p13_a19 out nocopy JTF_VARCHAR2_TABLE_400
1261: , p13_a20 out nocopy JTF_VARCHAR2_TABLE_400
1262: , p13_a21 out nocopy JTF_NUMBER_TABLE
1263: , p13_a22 out nocopy JTF_VARCHAR2_TABLE_100
1264: , p13_a23 out nocopy JTF_NUMBER_TABLE
1265: , p13_a24 out nocopy JTF_VARCHAR2_TABLE_100
1266: , p13_a25 out nocopy JTF_VARCHAR2_TABLE_300
1267: , p13_a26 out nocopy JTF_NUMBER_TABLE
1268: , p13_a27 out nocopy JTF_VARCHAR2_TABLE_100

Line 1267: , p13_a26 out nocopy JTF_NUMBER_TABLE

1263: , p13_a22 out nocopy JTF_VARCHAR2_TABLE_100
1264: , p13_a23 out nocopy JTF_NUMBER_TABLE
1265: , p13_a24 out nocopy JTF_VARCHAR2_TABLE_100
1266: , p13_a25 out nocopy JTF_VARCHAR2_TABLE_300
1267: , p13_a26 out nocopy JTF_NUMBER_TABLE
1268: , p13_a27 out nocopy JTF_VARCHAR2_TABLE_100
1269: , p13_a28 out nocopy JTF_VARCHAR2_TABLE_100
1270: , p13_a29 out nocopy JTF_NUMBER_TABLE
1271: , p13_a30 out nocopy JTF_VARCHAR2_TABLE_100

Line 1270: , p13_a29 out nocopy JTF_NUMBER_TABLE

1266: , p13_a25 out nocopy JTF_VARCHAR2_TABLE_300
1267: , p13_a26 out nocopy JTF_NUMBER_TABLE
1268: , p13_a27 out nocopy JTF_VARCHAR2_TABLE_100
1269: , p13_a28 out nocopy JTF_VARCHAR2_TABLE_100
1270: , p13_a29 out nocopy JTF_NUMBER_TABLE
1271: , p13_a30 out nocopy JTF_VARCHAR2_TABLE_100
1272: , p13_a31 out nocopy JTF_VARCHAR2_TABLE_100
1273: , p13_a32 out nocopy JTF_VARCHAR2_TABLE_100
1274: , p13_a33 out nocopy JTF_VARCHAR2_TABLE_100

Line 1276: , p13_a35 out nocopy JTF_NUMBER_TABLE

1272: , p13_a31 out nocopy JTF_VARCHAR2_TABLE_100
1273: , p13_a32 out nocopy JTF_VARCHAR2_TABLE_100
1274: , p13_a33 out nocopy JTF_VARCHAR2_TABLE_100
1275: , p13_a34 out nocopy JTF_VARCHAR2_TABLE_300
1276: , p13_a35 out nocopy JTF_NUMBER_TABLE
1277: , p13_a36 out nocopy JTF_VARCHAR2_TABLE_100
1278: , p13_a37 out nocopy JTF_NUMBER_TABLE
1279: , p13_a38 out nocopy JTF_VARCHAR2_TABLE_300
1280: )

Line 1278: , p13_a37 out nocopy JTF_NUMBER_TABLE

1274: , p13_a33 out nocopy JTF_VARCHAR2_TABLE_100
1275: , p13_a34 out nocopy JTF_VARCHAR2_TABLE_300
1276: , p13_a35 out nocopy JTF_NUMBER_TABLE
1277: , p13_a36 out nocopy JTF_VARCHAR2_TABLE_100
1278: , p13_a37 out nocopy JTF_NUMBER_TABLE
1279: , p13_a38 out nocopy JTF_VARCHAR2_TABLE_300
1280: )
1281:
1282: as