APPS.AHL_UC_INSTANCE_PVT_W dependencies on JTF_NUMBER_TABLE

Line 4: , a1 JTF_NUMBER_TABLE

1: package body ahl_uc_instance_pvt_w as
2: /* $Header: AHLWUCIB.pls 120.5.12020000.2 2012/12/14 06:59:28 shnatu ship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_uc_instance_pvt.uc_child_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: ) as

Line 5: , a2 JTF_NUMBER_TABLE

1: package body ahl_uc_instance_pvt_w as
2: /* $Header: AHLWUCIB.pls 120.5.12020000.2 2012/12/14 06:59:28 shnatu ship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_uc_instance_pvt.uc_child_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: ) as
9: ddindx binary_integer; indx binary_integer;

Line 31: , a1 out nocopy JTF_NUMBER_TABLE

27: end if;
28: end if;
29: end rosetta_table_copy_in_p3;
30: procedure rosetta_table_copy_out_p3(t ahl_uc_instance_pvt.uc_child_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_NUMBER_TABLE
33: , a3 out nocopy JTF_VARCHAR2_TABLE_100
34: , a4 out nocopy JTF_VARCHAR2_TABLE_100
35: ) as

Line 32: , a2 out nocopy JTF_NUMBER_TABLE

28: end if;
29: end rosetta_table_copy_in_p3;
30: procedure rosetta_table_copy_out_p3(t ahl_uc_instance_pvt.uc_child_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_NUMBER_TABLE
33: , a3 out nocopy JTF_VARCHAR2_TABLE_100
34: , a4 out nocopy JTF_VARCHAR2_TABLE_100
35: ) as
36: ddindx binary_integer; indx binary_integer;

Line 40: a1 := JTF_NUMBER_TABLE();

36: ddindx binary_integer; indx binary_integer;
37: begin
38: if t is null or t.count = 0 then
39: a0 := JTF_VARCHAR2_TABLE_100();
40: a1 := JTF_NUMBER_TABLE();
41: a2 := JTF_NUMBER_TABLE();
42: a3 := JTF_VARCHAR2_TABLE_100();
43: a4 := JTF_VARCHAR2_TABLE_100();
44: else

Line 41: a2 := JTF_NUMBER_TABLE();

37: begin
38: if t is null or t.count = 0 then
39: a0 := JTF_VARCHAR2_TABLE_100();
40: a1 := JTF_NUMBER_TABLE();
41: a2 := JTF_NUMBER_TABLE();
42: a3 := JTF_VARCHAR2_TABLE_100();
43: a4 := JTF_VARCHAR2_TABLE_100();
44: else
45: a0 := JTF_VARCHAR2_TABLE_100();

Line 46: a1 := JTF_NUMBER_TABLE();

42: a3 := JTF_VARCHAR2_TABLE_100();
43: a4 := JTF_VARCHAR2_TABLE_100();
44: else
45: a0 := JTF_VARCHAR2_TABLE_100();
46: a1 := JTF_NUMBER_TABLE();
47: a2 := JTF_NUMBER_TABLE();
48: a3 := JTF_VARCHAR2_TABLE_100();
49: a4 := JTF_VARCHAR2_TABLE_100();
50: if t.count > 0 then

Line 47: a2 := JTF_NUMBER_TABLE();

43: a4 := JTF_VARCHAR2_TABLE_100();
44: else
45: a0 := JTF_VARCHAR2_TABLE_100();
46: a1 := JTF_NUMBER_TABLE();
47: a2 := JTF_NUMBER_TABLE();
48: a3 := JTF_VARCHAR2_TABLE_100();
49: a4 := JTF_VARCHAR2_TABLE_100();
50: if t.count > 0 then
51: a0.extend(t.count);

Line 75: , a1 JTF_NUMBER_TABLE

71: end if;
72: end rosetta_table_copy_out_p3;
73:
74: procedure rosetta_table_copy_in_p5(t out nocopy ahl_uc_instance_pvt.uc_descendant_tbl_type, a0 JTF_VARCHAR2_TABLE_100
75: , a1 JTF_NUMBER_TABLE
76: , a2 JTF_NUMBER_TABLE
77: , a3 JTF_NUMBER_TABLE
78: , a4 JTF_NUMBER_TABLE
79: , a5 JTF_VARCHAR2_TABLE_100

Line 76: , a2 JTF_NUMBER_TABLE

72: end rosetta_table_copy_out_p3;
73:
74: procedure rosetta_table_copy_in_p5(t out nocopy ahl_uc_instance_pvt.uc_descendant_tbl_type, a0 JTF_VARCHAR2_TABLE_100
75: , a1 JTF_NUMBER_TABLE
76: , a2 JTF_NUMBER_TABLE
77: , a3 JTF_NUMBER_TABLE
78: , a4 JTF_NUMBER_TABLE
79: , a5 JTF_VARCHAR2_TABLE_100
80: , a6 JTF_VARCHAR2_TABLE_100

Line 77: , a3 JTF_NUMBER_TABLE

73:
74: procedure rosetta_table_copy_in_p5(t out nocopy ahl_uc_instance_pvt.uc_descendant_tbl_type, a0 JTF_VARCHAR2_TABLE_100
75: , a1 JTF_NUMBER_TABLE
76: , a2 JTF_NUMBER_TABLE
77: , a3 JTF_NUMBER_TABLE
78: , a4 JTF_NUMBER_TABLE
79: , a5 JTF_VARCHAR2_TABLE_100
80: , a6 JTF_VARCHAR2_TABLE_100
81: ) as

Line 78: , a4 JTF_NUMBER_TABLE

74: procedure rosetta_table_copy_in_p5(t out nocopy ahl_uc_instance_pvt.uc_descendant_tbl_type, a0 JTF_VARCHAR2_TABLE_100
75: , a1 JTF_NUMBER_TABLE
76: , a2 JTF_NUMBER_TABLE
77: , a3 JTF_NUMBER_TABLE
78: , a4 JTF_NUMBER_TABLE
79: , a5 JTF_VARCHAR2_TABLE_100
80: , a6 JTF_VARCHAR2_TABLE_100
81: ) as
82: ddindx binary_integer; indx binary_integer;

Line 106: , a1 out nocopy JTF_NUMBER_TABLE

102: end if;
103: end if;
104: end rosetta_table_copy_in_p5;
105: procedure rosetta_table_copy_out_p5(t ahl_uc_instance_pvt.uc_descendant_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
106: , a1 out nocopy JTF_NUMBER_TABLE
107: , a2 out nocopy JTF_NUMBER_TABLE
108: , a3 out nocopy JTF_NUMBER_TABLE
109: , a4 out nocopy JTF_NUMBER_TABLE
110: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 107: , a2 out nocopy JTF_NUMBER_TABLE

103: end if;
104: end rosetta_table_copy_in_p5;
105: procedure rosetta_table_copy_out_p5(t ahl_uc_instance_pvt.uc_descendant_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
106: , a1 out nocopy JTF_NUMBER_TABLE
107: , a2 out nocopy JTF_NUMBER_TABLE
108: , a3 out nocopy JTF_NUMBER_TABLE
109: , a4 out nocopy JTF_NUMBER_TABLE
110: , a5 out nocopy JTF_VARCHAR2_TABLE_100
111: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 108: , a3 out nocopy JTF_NUMBER_TABLE

104: end rosetta_table_copy_in_p5;
105: procedure rosetta_table_copy_out_p5(t ahl_uc_instance_pvt.uc_descendant_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
106: , a1 out nocopy JTF_NUMBER_TABLE
107: , a2 out nocopy JTF_NUMBER_TABLE
108: , a3 out nocopy JTF_NUMBER_TABLE
109: , a4 out nocopy JTF_NUMBER_TABLE
110: , a5 out nocopy JTF_VARCHAR2_TABLE_100
111: , a6 out nocopy JTF_VARCHAR2_TABLE_100
112: ) as

Line 109: , a4 out nocopy JTF_NUMBER_TABLE

105: procedure rosetta_table_copy_out_p5(t ahl_uc_instance_pvt.uc_descendant_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
106: , a1 out nocopy JTF_NUMBER_TABLE
107: , a2 out nocopy JTF_NUMBER_TABLE
108: , a3 out nocopy JTF_NUMBER_TABLE
109: , a4 out nocopy JTF_NUMBER_TABLE
110: , a5 out nocopy JTF_VARCHAR2_TABLE_100
111: , a6 out nocopy JTF_VARCHAR2_TABLE_100
112: ) as
113: ddindx binary_integer; indx binary_integer;

Line 117: a1 := JTF_NUMBER_TABLE();

113: ddindx binary_integer; indx binary_integer;
114: begin
115: if t is null or t.count = 0 then
116: a0 := JTF_VARCHAR2_TABLE_100();
117: a1 := JTF_NUMBER_TABLE();
118: a2 := JTF_NUMBER_TABLE();
119: a3 := JTF_NUMBER_TABLE();
120: a4 := JTF_NUMBER_TABLE();
121: a5 := JTF_VARCHAR2_TABLE_100();

Line 118: a2 := JTF_NUMBER_TABLE();

114: begin
115: if t is null or t.count = 0 then
116: a0 := JTF_VARCHAR2_TABLE_100();
117: a1 := JTF_NUMBER_TABLE();
118: a2 := JTF_NUMBER_TABLE();
119: a3 := JTF_NUMBER_TABLE();
120: a4 := JTF_NUMBER_TABLE();
121: a5 := JTF_VARCHAR2_TABLE_100();
122: a6 := JTF_VARCHAR2_TABLE_100();

Line 119: a3 := JTF_NUMBER_TABLE();

115: if t is null or t.count = 0 then
116: a0 := JTF_VARCHAR2_TABLE_100();
117: a1 := JTF_NUMBER_TABLE();
118: a2 := JTF_NUMBER_TABLE();
119: a3 := JTF_NUMBER_TABLE();
120: a4 := JTF_NUMBER_TABLE();
121: a5 := JTF_VARCHAR2_TABLE_100();
122: a6 := JTF_VARCHAR2_TABLE_100();
123: else

Line 120: a4 := JTF_NUMBER_TABLE();

116: a0 := JTF_VARCHAR2_TABLE_100();
117: a1 := JTF_NUMBER_TABLE();
118: a2 := JTF_NUMBER_TABLE();
119: a3 := JTF_NUMBER_TABLE();
120: a4 := JTF_NUMBER_TABLE();
121: a5 := JTF_VARCHAR2_TABLE_100();
122: a6 := JTF_VARCHAR2_TABLE_100();
123: else
124: a0 := JTF_VARCHAR2_TABLE_100();

Line 125: a1 := JTF_NUMBER_TABLE();

121: a5 := JTF_VARCHAR2_TABLE_100();
122: a6 := JTF_VARCHAR2_TABLE_100();
123: else
124: a0 := JTF_VARCHAR2_TABLE_100();
125: a1 := JTF_NUMBER_TABLE();
126: a2 := JTF_NUMBER_TABLE();
127: a3 := JTF_NUMBER_TABLE();
128: a4 := JTF_NUMBER_TABLE();
129: a5 := JTF_VARCHAR2_TABLE_100();

Line 126: a2 := JTF_NUMBER_TABLE();

122: a6 := JTF_VARCHAR2_TABLE_100();
123: else
124: a0 := JTF_VARCHAR2_TABLE_100();
125: a1 := JTF_NUMBER_TABLE();
126: a2 := JTF_NUMBER_TABLE();
127: a3 := JTF_NUMBER_TABLE();
128: a4 := JTF_NUMBER_TABLE();
129: a5 := JTF_VARCHAR2_TABLE_100();
130: a6 := JTF_VARCHAR2_TABLE_100();

Line 127: a3 := JTF_NUMBER_TABLE();

123: else
124: a0 := JTF_VARCHAR2_TABLE_100();
125: a1 := JTF_NUMBER_TABLE();
126: a2 := JTF_NUMBER_TABLE();
127: a3 := JTF_NUMBER_TABLE();
128: a4 := JTF_NUMBER_TABLE();
129: a5 := JTF_VARCHAR2_TABLE_100();
130: a6 := JTF_VARCHAR2_TABLE_100();
131: if t.count > 0 then

Line 128: a4 := JTF_NUMBER_TABLE();

124: a0 := JTF_VARCHAR2_TABLE_100();
125: a1 := JTF_NUMBER_TABLE();
126: a2 := JTF_NUMBER_TABLE();
127: a3 := JTF_NUMBER_TABLE();
128: a4 := JTF_NUMBER_TABLE();
129: a5 := JTF_VARCHAR2_TABLE_100();
130: a6 := JTF_VARCHAR2_TABLE_100();
131: if t.count > 0 then
132: a0.extend(t.count);

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

155: end if;
156: end if;
157: end rosetta_table_copy_out_p5;
158:
159: procedure rosetta_table_copy_in_p7(t out nocopy ahl_uc_instance_pvt.available_instance_tbl_type, a0 JTF_NUMBER_TABLE
160: , a1 JTF_NUMBER_TABLE
161: , a2 JTF_NUMBER_TABLE
162: , a3 JTF_NUMBER_TABLE
163: , a4 JTF_VARCHAR2_TABLE_100

Line 160: , a1 JTF_NUMBER_TABLE

156: end if;
157: end rosetta_table_copy_out_p5;
158:
159: procedure rosetta_table_copy_in_p7(t out nocopy ahl_uc_instance_pvt.available_instance_tbl_type, a0 JTF_NUMBER_TABLE
160: , a1 JTF_NUMBER_TABLE
161: , a2 JTF_NUMBER_TABLE
162: , a3 JTF_NUMBER_TABLE
163: , a4 JTF_VARCHAR2_TABLE_100
164: , a5 JTF_VARCHAR2_TABLE_300

Line 161: , a2 JTF_NUMBER_TABLE

157: end rosetta_table_copy_out_p5;
158:
159: procedure rosetta_table_copy_in_p7(t out nocopy ahl_uc_instance_pvt.available_instance_tbl_type, a0 JTF_NUMBER_TABLE
160: , a1 JTF_NUMBER_TABLE
161: , a2 JTF_NUMBER_TABLE
162: , a3 JTF_NUMBER_TABLE
163: , a4 JTF_VARCHAR2_TABLE_100
164: , a5 JTF_VARCHAR2_TABLE_300
165: , a6 JTF_VARCHAR2_TABLE_300

Line 162: , a3 JTF_NUMBER_TABLE

158:
159: procedure rosetta_table_copy_in_p7(t out nocopy ahl_uc_instance_pvt.available_instance_tbl_type, a0 JTF_NUMBER_TABLE
160: , a1 JTF_NUMBER_TABLE
161: , a2 JTF_NUMBER_TABLE
162: , a3 JTF_NUMBER_TABLE
163: , a4 JTF_VARCHAR2_TABLE_100
164: , a5 JTF_VARCHAR2_TABLE_300
165: , a6 JTF_VARCHAR2_TABLE_300
166: , a7 JTF_VARCHAR2_TABLE_100

Line 171: , a12 JTF_NUMBER_TABLE

167: , a8 JTF_VARCHAR2_TABLE_100
168: , a9 JTF_VARCHAR2_TABLE_100
169: , a10 JTF_VARCHAR2_TABLE_100
170: , a11 JTF_VARCHAR2_TABLE_100
171: , a12 JTF_NUMBER_TABLE
172: , a13 JTF_NUMBER_TABLE
173: , a14 JTF_DATE_TABLE
174: , a15 JTF_DATE_TABLE
175: , a16 JTF_VARCHAR2_TABLE_4000

Line 172: , a13 JTF_NUMBER_TABLE

168: , a9 JTF_VARCHAR2_TABLE_100
169: , a10 JTF_VARCHAR2_TABLE_100
170: , a11 JTF_VARCHAR2_TABLE_100
171: , a12 JTF_NUMBER_TABLE
172: , a13 JTF_NUMBER_TABLE
173: , a14 JTF_DATE_TABLE
174: , a15 JTF_DATE_TABLE
175: , a16 JTF_VARCHAR2_TABLE_4000
176: , a17 JTF_VARCHAR2_TABLE_100

Line 177: , a18 JTF_NUMBER_TABLE

173: , a14 JTF_DATE_TABLE
174: , a15 JTF_DATE_TABLE
175: , a16 JTF_VARCHAR2_TABLE_4000
176: , a17 JTF_VARCHAR2_TABLE_100
177: , a18 JTF_NUMBER_TABLE
178: , a19 JTF_VARCHAR2_TABLE_400
179: , a20 JTF_VARCHAR2_TABLE_400
180: , a21 JTF_NUMBER_TABLE
181: , a22 JTF_VARCHAR2_TABLE_100

Line 180: , a21 JTF_NUMBER_TABLE

176: , a17 JTF_VARCHAR2_TABLE_100
177: , a18 JTF_NUMBER_TABLE
178: , a19 JTF_VARCHAR2_TABLE_400
179: , a20 JTF_VARCHAR2_TABLE_400
180: , a21 JTF_NUMBER_TABLE
181: , a22 JTF_VARCHAR2_TABLE_100
182: , a23 JTF_NUMBER_TABLE
183: , a24 JTF_VARCHAR2_TABLE_100
184: , a25 JTF_VARCHAR2_TABLE_300

Line 182: , a23 JTF_NUMBER_TABLE

178: , a19 JTF_VARCHAR2_TABLE_400
179: , a20 JTF_VARCHAR2_TABLE_400
180: , a21 JTF_NUMBER_TABLE
181: , a22 JTF_VARCHAR2_TABLE_100
182: , a23 JTF_NUMBER_TABLE
183: , a24 JTF_VARCHAR2_TABLE_100
184: , a25 JTF_VARCHAR2_TABLE_300
185: , a26 JTF_NUMBER_TABLE
186: , a27 JTF_VARCHAR2_TABLE_100

Line 185: , a26 JTF_NUMBER_TABLE

181: , a22 JTF_VARCHAR2_TABLE_100
182: , a23 JTF_NUMBER_TABLE
183: , a24 JTF_VARCHAR2_TABLE_100
184: , a25 JTF_VARCHAR2_TABLE_300
185: , a26 JTF_NUMBER_TABLE
186: , a27 JTF_VARCHAR2_TABLE_100
187: , a28 JTF_VARCHAR2_TABLE_100
188: , a29 JTF_NUMBER_TABLE
189: , a30 JTF_VARCHAR2_TABLE_100

Line 188: , a29 JTF_NUMBER_TABLE

184: , a25 JTF_VARCHAR2_TABLE_300
185: , a26 JTF_NUMBER_TABLE
186: , a27 JTF_VARCHAR2_TABLE_100
187: , a28 JTF_VARCHAR2_TABLE_100
188: , a29 JTF_NUMBER_TABLE
189: , a30 JTF_VARCHAR2_TABLE_100
190: , a31 JTF_VARCHAR2_TABLE_100
191: , a32 JTF_VARCHAR2_TABLE_100
192: , a33 JTF_VARCHAR2_TABLE_100

Line 194: , a35 JTF_NUMBER_TABLE

190: , a31 JTF_VARCHAR2_TABLE_100
191: , a32 JTF_VARCHAR2_TABLE_100
192: , a33 JTF_VARCHAR2_TABLE_100
193: , a34 JTF_VARCHAR2_TABLE_300
194: , a35 JTF_NUMBER_TABLE
195: , a36 JTF_VARCHAR2_TABLE_100
196: , a37 JTF_NUMBER_TABLE
197: , a38 JTF_VARCHAR2_TABLE_300
198: ) as

Line 196: , a37 JTF_NUMBER_TABLE

192: , a33 JTF_VARCHAR2_TABLE_100
193: , a34 JTF_VARCHAR2_TABLE_300
194: , a35 JTF_NUMBER_TABLE
195: , a36 JTF_VARCHAR2_TABLE_100
196: , a37 JTF_NUMBER_TABLE
197: , a38 JTF_VARCHAR2_TABLE_300
198: ) as
199: ddindx binary_integer; indx binary_integer;
200: begin

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

250: end loop;
251: end if;
252: end if;
253: end rosetta_table_copy_in_p7;
254: procedure rosetta_table_copy_out_p7(t ahl_uc_instance_pvt.available_instance_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
255: , a1 out nocopy JTF_NUMBER_TABLE
256: , a2 out nocopy JTF_NUMBER_TABLE
257: , a3 out nocopy JTF_NUMBER_TABLE
258: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 255: , a1 out nocopy JTF_NUMBER_TABLE

251: end if;
252: end if;
253: end rosetta_table_copy_in_p7;
254: procedure rosetta_table_copy_out_p7(t ahl_uc_instance_pvt.available_instance_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
255: , a1 out nocopy JTF_NUMBER_TABLE
256: , a2 out nocopy JTF_NUMBER_TABLE
257: , a3 out nocopy JTF_NUMBER_TABLE
258: , a4 out nocopy JTF_VARCHAR2_TABLE_100
259: , a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 256: , a2 out nocopy JTF_NUMBER_TABLE

252: end if;
253: end rosetta_table_copy_in_p7;
254: procedure rosetta_table_copy_out_p7(t ahl_uc_instance_pvt.available_instance_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
255: , a1 out nocopy JTF_NUMBER_TABLE
256: , a2 out nocopy JTF_NUMBER_TABLE
257: , a3 out nocopy JTF_NUMBER_TABLE
258: , a4 out nocopy JTF_VARCHAR2_TABLE_100
259: , a5 out nocopy JTF_VARCHAR2_TABLE_300
260: , a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 257: , a3 out nocopy JTF_NUMBER_TABLE

253: end rosetta_table_copy_in_p7;
254: procedure rosetta_table_copy_out_p7(t ahl_uc_instance_pvt.available_instance_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
255: , a1 out nocopy JTF_NUMBER_TABLE
256: , a2 out nocopy JTF_NUMBER_TABLE
257: , a3 out nocopy JTF_NUMBER_TABLE
258: , a4 out nocopy JTF_VARCHAR2_TABLE_100
259: , a5 out nocopy JTF_VARCHAR2_TABLE_300
260: , a6 out nocopy JTF_VARCHAR2_TABLE_300
261: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 266: , a12 out nocopy JTF_NUMBER_TABLE

262: , a8 out nocopy JTF_VARCHAR2_TABLE_100
263: , a9 out nocopy JTF_VARCHAR2_TABLE_100
264: , a10 out nocopy JTF_VARCHAR2_TABLE_100
265: , a11 out nocopy JTF_VARCHAR2_TABLE_100
266: , a12 out nocopy JTF_NUMBER_TABLE
267: , a13 out nocopy JTF_NUMBER_TABLE
268: , a14 out nocopy JTF_DATE_TABLE
269: , a15 out nocopy JTF_DATE_TABLE
270: , a16 out nocopy JTF_VARCHAR2_TABLE_4000

Line 267: , a13 out nocopy JTF_NUMBER_TABLE

263: , a9 out nocopy JTF_VARCHAR2_TABLE_100
264: , a10 out nocopy JTF_VARCHAR2_TABLE_100
265: , a11 out nocopy JTF_VARCHAR2_TABLE_100
266: , a12 out nocopy JTF_NUMBER_TABLE
267: , a13 out nocopy JTF_NUMBER_TABLE
268: , a14 out nocopy JTF_DATE_TABLE
269: , a15 out nocopy JTF_DATE_TABLE
270: , a16 out nocopy JTF_VARCHAR2_TABLE_4000
271: , a17 out nocopy JTF_VARCHAR2_TABLE_100

Line 272: , a18 out nocopy JTF_NUMBER_TABLE

268: , a14 out nocopy JTF_DATE_TABLE
269: , a15 out nocopy JTF_DATE_TABLE
270: , a16 out nocopy JTF_VARCHAR2_TABLE_4000
271: , a17 out nocopy JTF_VARCHAR2_TABLE_100
272: , a18 out nocopy JTF_NUMBER_TABLE
273: , a19 out nocopy JTF_VARCHAR2_TABLE_400
274: , a20 out nocopy JTF_VARCHAR2_TABLE_400
275: , a21 out nocopy JTF_NUMBER_TABLE
276: , a22 out nocopy JTF_VARCHAR2_TABLE_100

Line 275: , a21 out nocopy JTF_NUMBER_TABLE

271: , a17 out nocopy JTF_VARCHAR2_TABLE_100
272: , a18 out nocopy JTF_NUMBER_TABLE
273: , a19 out nocopy JTF_VARCHAR2_TABLE_400
274: , a20 out nocopy JTF_VARCHAR2_TABLE_400
275: , a21 out nocopy JTF_NUMBER_TABLE
276: , a22 out nocopy JTF_VARCHAR2_TABLE_100
277: , a23 out nocopy JTF_NUMBER_TABLE
278: , a24 out nocopy JTF_VARCHAR2_TABLE_100
279: , a25 out nocopy JTF_VARCHAR2_TABLE_300

Line 277: , a23 out nocopy JTF_NUMBER_TABLE

273: , a19 out nocopy JTF_VARCHAR2_TABLE_400
274: , a20 out nocopy JTF_VARCHAR2_TABLE_400
275: , a21 out nocopy JTF_NUMBER_TABLE
276: , a22 out nocopy JTF_VARCHAR2_TABLE_100
277: , a23 out nocopy JTF_NUMBER_TABLE
278: , a24 out nocopy JTF_VARCHAR2_TABLE_100
279: , a25 out nocopy JTF_VARCHAR2_TABLE_300
280: , a26 out nocopy JTF_NUMBER_TABLE
281: , a27 out nocopy JTF_VARCHAR2_TABLE_100

Line 280: , a26 out nocopy JTF_NUMBER_TABLE

276: , a22 out nocopy JTF_VARCHAR2_TABLE_100
277: , a23 out nocopy JTF_NUMBER_TABLE
278: , a24 out nocopy JTF_VARCHAR2_TABLE_100
279: , a25 out nocopy JTF_VARCHAR2_TABLE_300
280: , a26 out nocopy JTF_NUMBER_TABLE
281: , a27 out nocopy JTF_VARCHAR2_TABLE_100
282: , a28 out nocopy JTF_VARCHAR2_TABLE_100
283: , a29 out nocopy JTF_NUMBER_TABLE
284: , a30 out nocopy JTF_VARCHAR2_TABLE_100

Line 283: , a29 out nocopy JTF_NUMBER_TABLE

279: , a25 out nocopy JTF_VARCHAR2_TABLE_300
280: , a26 out nocopy JTF_NUMBER_TABLE
281: , a27 out nocopy JTF_VARCHAR2_TABLE_100
282: , a28 out nocopy JTF_VARCHAR2_TABLE_100
283: , a29 out nocopy JTF_NUMBER_TABLE
284: , a30 out nocopy JTF_VARCHAR2_TABLE_100
285: , a31 out nocopy JTF_VARCHAR2_TABLE_100
286: , a32 out nocopy JTF_VARCHAR2_TABLE_100
287: , a33 out nocopy JTF_VARCHAR2_TABLE_100

Line 289: , a35 out nocopy JTF_NUMBER_TABLE

285: , a31 out nocopy JTF_VARCHAR2_TABLE_100
286: , a32 out nocopy JTF_VARCHAR2_TABLE_100
287: , a33 out nocopy JTF_VARCHAR2_TABLE_100
288: , a34 out nocopy JTF_VARCHAR2_TABLE_300
289: , a35 out nocopy JTF_NUMBER_TABLE
290: , a36 out nocopy JTF_VARCHAR2_TABLE_100
291: , a37 out nocopy JTF_NUMBER_TABLE
292: , a38 out nocopy JTF_VARCHAR2_TABLE_300
293: ) as

Line 291: , a37 out nocopy JTF_NUMBER_TABLE

287: , a33 out nocopy JTF_VARCHAR2_TABLE_100
288: , a34 out nocopy JTF_VARCHAR2_TABLE_300
289: , a35 out nocopy JTF_NUMBER_TABLE
290: , a36 out nocopy JTF_VARCHAR2_TABLE_100
291: , a37 out nocopy JTF_NUMBER_TABLE
292: , a38 out nocopy JTF_VARCHAR2_TABLE_300
293: ) as
294: ddindx binary_integer; indx binary_integer;
295: begin

Line 297: a0 := JTF_NUMBER_TABLE();

293: ) as
294: ddindx binary_integer; indx binary_integer;
295: begin
296: if t is null or t.count = 0 then
297: a0 := JTF_NUMBER_TABLE();
298: a1 := JTF_NUMBER_TABLE();
299: a2 := JTF_NUMBER_TABLE();
300: a3 := JTF_NUMBER_TABLE();
301: a4 := JTF_VARCHAR2_TABLE_100();

Line 298: a1 := JTF_NUMBER_TABLE();

294: ddindx binary_integer; indx binary_integer;
295: begin
296: if t is null or t.count = 0 then
297: a0 := JTF_NUMBER_TABLE();
298: a1 := JTF_NUMBER_TABLE();
299: a2 := JTF_NUMBER_TABLE();
300: a3 := JTF_NUMBER_TABLE();
301: a4 := JTF_VARCHAR2_TABLE_100();
302: a5 := JTF_VARCHAR2_TABLE_300();

Line 299: a2 := JTF_NUMBER_TABLE();

295: begin
296: if t is null or t.count = 0 then
297: a0 := JTF_NUMBER_TABLE();
298: a1 := JTF_NUMBER_TABLE();
299: a2 := JTF_NUMBER_TABLE();
300: a3 := JTF_NUMBER_TABLE();
301: a4 := JTF_VARCHAR2_TABLE_100();
302: a5 := JTF_VARCHAR2_TABLE_300();
303: a6 := JTF_VARCHAR2_TABLE_300();

Line 300: a3 := JTF_NUMBER_TABLE();

296: if t is null or t.count = 0 then
297: a0 := JTF_NUMBER_TABLE();
298: a1 := JTF_NUMBER_TABLE();
299: a2 := JTF_NUMBER_TABLE();
300: a3 := JTF_NUMBER_TABLE();
301: a4 := JTF_VARCHAR2_TABLE_100();
302: a5 := JTF_VARCHAR2_TABLE_300();
303: a6 := JTF_VARCHAR2_TABLE_300();
304: a7 := JTF_VARCHAR2_TABLE_100();

Line 309: a12 := JTF_NUMBER_TABLE();

305: a8 := JTF_VARCHAR2_TABLE_100();
306: a9 := JTF_VARCHAR2_TABLE_100();
307: a10 := JTF_VARCHAR2_TABLE_100();
308: a11 := JTF_VARCHAR2_TABLE_100();
309: a12 := JTF_NUMBER_TABLE();
310: a13 := JTF_NUMBER_TABLE();
311: a14 := JTF_DATE_TABLE();
312: a15 := JTF_DATE_TABLE();
313: a16 := JTF_VARCHAR2_TABLE_4000();

Line 310: a13 := JTF_NUMBER_TABLE();

306: a9 := JTF_VARCHAR2_TABLE_100();
307: a10 := JTF_VARCHAR2_TABLE_100();
308: a11 := JTF_VARCHAR2_TABLE_100();
309: a12 := JTF_NUMBER_TABLE();
310: a13 := JTF_NUMBER_TABLE();
311: a14 := JTF_DATE_TABLE();
312: a15 := JTF_DATE_TABLE();
313: a16 := JTF_VARCHAR2_TABLE_4000();
314: a17 := JTF_VARCHAR2_TABLE_100();

Line 315: a18 := JTF_NUMBER_TABLE();

311: a14 := JTF_DATE_TABLE();
312: a15 := JTF_DATE_TABLE();
313: a16 := JTF_VARCHAR2_TABLE_4000();
314: a17 := JTF_VARCHAR2_TABLE_100();
315: a18 := JTF_NUMBER_TABLE();
316: a19 := JTF_VARCHAR2_TABLE_400();
317: a20 := JTF_VARCHAR2_TABLE_400();
318: a21 := JTF_NUMBER_TABLE();
319: a22 := JTF_VARCHAR2_TABLE_100();

Line 318: a21 := JTF_NUMBER_TABLE();

314: a17 := JTF_VARCHAR2_TABLE_100();
315: a18 := JTF_NUMBER_TABLE();
316: a19 := JTF_VARCHAR2_TABLE_400();
317: a20 := JTF_VARCHAR2_TABLE_400();
318: a21 := JTF_NUMBER_TABLE();
319: a22 := JTF_VARCHAR2_TABLE_100();
320: a23 := JTF_NUMBER_TABLE();
321: a24 := JTF_VARCHAR2_TABLE_100();
322: a25 := JTF_VARCHAR2_TABLE_300();

Line 320: a23 := JTF_NUMBER_TABLE();

316: a19 := JTF_VARCHAR2_TABLE_400();
317: a20 := JTF_VARCHAR2_TABLE_400();
318: a21 := JTF_NUMBER_TABLE();
319: a22 := JTF_VARCHAR2_TABLE_100();
320: a23 := JTF_NUMBER_TABLE();
321: a24 := JTF_VARCHAR2_TABLE_100();
322: a25 := JTF_VARCHAR2_TABLE_300();
323: a26 := JTF_NUMBER_TABLE();
324: a27 := JTF_VARCHAR2_TABLE_100();

Line 323: a26 := JTF_NUMBER_TABLE();

319: a22 := JTF_VARCHAR2_TABLE_100();
320: a23 := JTF_NUMBER_TABLE();
321: a24 := JTF_VARCHAR2_TABLE_100();
322: a25 := JTF_VARCHAR2_TABLE_300();
323: a26 := JTF_NUMBER_TABLE();
324: a27 := JTF_VARCHAR2_TABLE_100();
325: a28 := JTF_VARCHAR2_TABLE_100();
326: a29 := JTF_NUMBER_TABLE();
327: a30 := JTF_VARCHAR2_TABLE_100();

Line 326: a29 := JTF_NUMBER_TABLE();

322: a25 := JTF_VARCHAR2_TABLE_300();
323: a26 := JTF_NUMBER_TABLE();
324: a27 := JTF_VARCHAR2_TABLE_100();
325: a28 := JTF_VARCHAR2_TABLE_100();
326: a29 := JTF_NUMBER_TABLE();
327: a30 := JTF_VARCHAR2_TABLE_100();
328: a31 := JTF_VARCHAR2_TABLE_100();
329: a32 := JTF_VARCHAR2_TABLE_100();
330: a33 := JTF_VARCHAR2_TABLE_100();

Line 332: a35 := JTF_NUMBER_TABLE();

328: a31 := JTF_VARCHAR2_TABLE_100();
329: a32 := JTF_VARCHAR2_TABLE_100();
330: a33 := JTF_VARCHAR2_TABLE_100();
331: a34 := JTF_VARCHAR2_TABLE_300();
332: a35 := JTF_NUMBER_TABLE();
333: a36 := JTF_VARCHAR2_TABLE_100();
334: a37 := JTF_NUMBER_TABLE();
335: a38 := JTF_VARCHAR2_TABLE_300();
336: else

Line 334: a37 := JTF_NUMBER_TABLE();

330: a33 := JTF_VARCHAR2_TABLE_100();
331: a34 := JTF_VARCHAR2_TABLE_300();
332: a35 := JTF_NUMBER_TABLE();
333: a36 := JTF_VARCHAR2_TABLE_100();
334: a37 := JTF_NUMBER_TABLE();
335: a38 := JTF_VARCHAR2_TABLE_300();
336: else
337: a0 := JTF_NUMBER_TABLE();
338: a1 := JTF_NUMBER_TABLE();

Line 337: a0 := JTF_NUMBER_TABLE();

333: a36 := JTF_VARCHAR2_TABLE_100();
334: a37 := JTF_NUMBER_TABLE();
335: a38 := JTF_VARCHAR2_TABLE_300();
336: else
337: a0 := JTF_NUMBER_TABLE();
338: a1 := JTF_NUMBER_TABLE();
339: a2 := JTF_NUMBER_TABLE();
340: a3 := JTF_NUMBER_TABLE();
341: a4 := JTF_VARCHAR2_TABLE_100();

Line 338: a1 := JTF_NUMBER_TABLE();

334: a37 := JTF_NUMBER_TABLE();
335: a38 := JTF_VARCHAR2_TABLE_300();
336: else
337: a0 := JTF_NUMBER_TABLE();
338: a1 := JTF_NUMBER_TABLE();
339: a2 := JTF_NUMBER_TABLE();
340: a3 := JTF_NUMBER_TABLE();
341: a4 := JTF_VARCHAR2_TABLE_100();
342: a5 := JTF_VARCHAR2_TABLE_300();

Line 339: a2 := JTF_NUMBER_TABLE();

335: a38 := JTF_VARCHAR2_TABLE_300();
336: else
337: a0 := JTF_NUMBER_TABLE();
338: a1 := JTF_NUMBER_TABLE();
339: a2 := JTF_NUMBER_TABLE();
340: a3 := JTF_NUMBER_TABLE();
341: a4 := JTF_VARCHAR2_TABLE_100();
342: a5 := JTF_VARCHAR2_TABLE_300();
343: a6 := JTF_VARCHAR2_TABLE_300();

Line 340: a3 := JTF_NUMBER_TABLE();

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

Line 349: a12 := JTF_NUMBER_TABLE();

345: a8 := JTF_VARCHAR2_TABLE_100();
346: a9 := JTF_VARCHAR2_TABLE_100();
347: a10 := JTF_VARCHAR2_TABLE_100();
348: a11 := JTF_VARCHAR2_TABLE_100();
349: a12 := JTF_NUMBER_TABLE();
350: a13 := JTF_NUMBER_TABLE();
351: a14 := JTF_DATE_TABLE();
352: a15 := JTF_DATE_TABLE();
353: a16 := JTF_VARCHAR2_TABLE_4000();

Line 350: a13 := JTF_NUMBER_TABLE();

346: a9 := JTF_VARCHAR2_TABLE_100();
347: a10 := JTF_VARCHAR2_TABLE_100();
348: a11 := JTF_VARCHAR2_TABLE_100();
349: a12 := JTF_NUMBER_TABLE();
350: a13 := JTF_NUMBER_TABLE();
351: a14 := JTF_DATE_TABLE();
352: a15 := JTF_DATE_TABLE();
353: a16 := JTF_VARCHAR2_TABLE_4000();
354: a17 := JTF_VARCHAR2_TABLE_100();

Line 355: a18 := JTF_NUMBER_TABLE();

351: a14 := JTF_DATE_TABLE();
352: a15 := JTF_DATE_TABLE();
353: a16 := JTF_VARCHAR2_TABLE_4000();
354: a17 := JTF_VARCHAR2_TABLE_100();
355: a18 := JTF_NUMBER_TABLE();
356: a19 := JTF_VARCHAR2_TABLE_400();
357: a20 := JTF_VARCHAR2_TABLE_400();
358: a21 := JTF_NUMBER_TABLE();
359: a22 := JTF_VARCHAR2_TABLE_100();

Line 358: a21 := JTF_NUMBER_TABLE();

354: a17 := JTF_VARCHAR2_TABLE_100();
355: a18 := JTF_NUMBER_TABLE();
356: a19 := JTF_VARCHAR2_TABLE_400();
357: a20 := JTF_VARCHAR2_TABLE_400();
358: a21 := JTF_NUMBER_TABLE();
359: a22 := JTF_VARCHAR2_TABLE_100();
360: a23 := JTF_NUMBER_TABLE();
361: a24 := JTF_VARCHAR2_TABLE_100();
362: a25 := JTF_VARCHAR2_TABLE_300();

Line 360: a23 := JTF_NUMBER_TABLE();

356: a19 := JTF_VARCHAR2_TABLE_400();
357: a20 := JTF_VARCHAR2_TABLE_400();
358: a21 := JTF_NUMBER_TABLE();
359: a22 := JTF_VARCHAR2_TABLE_100();
360: a23 := JTF_NUMBER_TABLE();
361: a24 := JTF_VARCHAR2_TABLE_100();
362: a25 := JTF_VARCHAR2_TABLE_300();
363: a26 := JTF_NUMBER_TABLE();
364: a27 := JTF_VARCHAR2_TABLE_100();

Line 363: a26 := JTF_NUMBER_TABLE();

359: a22 := JTF_VARCHAR2_TABLE_100();
360: a23 := JTF_NUMBER_TABLE();
361: a24 := JTF_VARCHAR2_TABLE_100();
362: a25 := JTF_VARCHAR2_TABLE_300();
363: a26 := JTF_NUMBER_TABLE();
364: a27 := JTF_VARCHAR2_TABLE_100();
365: a28 := JTF_VARCHAR2_TABLE_100();
366: a29 := JTF_NUMBER_TABLE();
367: a30 := JTF_VARCHAR2_TABLE_100();

Line 366: a29 := JTF_NUMBER_TABLE();

362: a25 := JTF_VARCHAR2_TABLE_300();
363: a26 := JTF_NUMBER_TABLE();
364: a27 := JTF_VARCHAR2_TABLE_100();
365: a28 := JTF_VARCHAR2_TABLE_100();
366: a29 := JTF_NUMBER_TABLE();
367: a30 := JTF_VARCHAR2_TABLE_100();
368: a31 := JTF_VARCHAR2_TABLE_100();
369: a32 := JTF_VARCHAR2_TABLE_100();
370: a33 := JTF_VARCHAR2_TABLE_100();

Line 372: a35 := JTF_NUMBER_TABLE();

368: a31 := JTF_VARCHAR2_TABLE_100();
369: a32 := JTF_VARCHAR2_TABLE_100();
370: a33 := JTF_VARCHAR2_TABLE_100();
371: a34 := JTF_VARCHAR2_TABLE_300();
372: a35 := JTF_NUMBER_TABLE();
373: a36 := JTF_VARCHAR2_TABLE_100();
374: a37 := JTF_NUMBER_TABLE();
375: a38 := JTF_VARCHAR2_TABLE_300();
376: if t.count > 0 then

Line 374: a37 := JTF_NUMBER_TABLE();

370: a33 := JTF_VARCHAR2_TABLE_100();
371: a34 := JTF_VARCHAR2_TABLE_300();
372: a35 := JTF_NUMBER_TABLE();
373: a36 := JTF_VARCHAR2_TABLE_100();
374: a37 := JTF_NUMBER_TABLE();
375: a38 := JTF_VARCHAR2_TABLE_300();
376: if t.count > 0 then
377: a0.extend(t.count);
378: a1.extend(t.count);

Line 1079: , p14_a0 out nocopy JTF_NUMBER_TABLE

1075: , p_instance_number VARCHAR2
1076: , p_workorder_id NUMBER
1077: , p_start_row_index NUMBER
1078: , p_max_rows NUMBER
1079: , p14_a0 out nocopy JTF_NUMBER_TABLE
1080: , p14_a1 out nocopy JTF_NUMBER_TABLE
1081: , p14_a2 out nocopy JTF_NUMBER_TABLE
1082: , p14_a3 out nocopy JTF_NUMBER_TABLE
1083: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1080: , p14_a1 out nocopy JTF_NUMBER_TABLE

1076: , p_workorder_id NUMBER
1077: , p_start_row_index NUMBER
1078: , p_max_rows NUMBER
1079: , p14_a0 out nocopy JTF_NUMBER_TABLE
1080: , p14_a1 out nocopy JTF_NUMBER_TABLE
1081: , p14_a2 out nocopy JTF_NUMBER_TABLE
1082: , p14_a3 out nocopy JTF_NUMBER_TABLE
1083: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_100
1084: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 1081: , p14_a2 out nocopy JTF_NUMBER_TABLE

1077: , p_start_row_index NUMBER
1078: , p_max_rows NUMBER
1079: , p14_a0 out nocopy JTF_NUMBER_TABLE
1080: , p14_a1 out nocopy JTF_NUMBER_TABLE
1081: , p14_a2 out nocopy JTF_NUMBER_TABLE
1082: , p14_a3 out nocopy JTF_NUMBER_TABLE
1083: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_100
1084: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_300
1085: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 1082: , p14_a3 out nocopy JTF_NUMBER_TABLE

1078: , p_max_rows NUMBER
1079: , p14_a0 out nocopy JTF_NUMBER_TABLE
1080: , p14_a1 out nocopy JTF_NUMBER_TABLE
1081: , p14_a2 out nocopy JTF_NUMBER_TABLE
1082: , p14_a3 out nocopy JTF_NUMBER_TABLE
1083: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_100
1084: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_300
1085: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_300
1086: , p14_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 1091: , p14_a12 out nocopy JTF_NUMBER_TABLE

1087: , p14_a8 out nocopy JTF_VARCHAR2_TABLE_100
1088: , p14_a9 out nocopy JTF_VARCHAR2_TABLE_100
1089: , p14_a10 out nocopy JTF_VARCHAR2_TABLE_100
1090: , p14_a11 out nocopy JTF_VARCHAR2_TABLE_100
1091: , p14_a12 out nocopy JTF_NUMBER_TABLE
1092: , p14_a13 out nocopy JTF_NUMBER_TABLE
1093: , p14_a14 out nocopy JTF_DATE_TABLE
1094: , p14_a15 out nocopy JTF_DATE_TABLE
1095: , p14_a16 out nocopy JTF_VARCHAR2_TABLE_4000

Line 1092: , p14_a13 out nocopy JTF_NUMBER_TABLE

1088: , p14_a9 out nocopy JTF_VARCHAR2_TABLE_100
1089: , p14_a10 out nocopy JTF_VARCHAR2_TABLE_100
1090: , p14_a11 out nocopy JTF_VARCHAR2_TABLE_100
1091: , p14_a12 out nocopy JTF_NUMBER_TABLE
1092: , p14_a13 out nocopy JTF_NUMBER_TABLE
1093: , p14_a14 out nocopy JTF_DATE_TABLE
1094: , p14_a15 out nocopy JTF_DATE_TABLE
1095: , p14_a16 out nocopy JTF_VARCHAR2_TABLE_4000
1096: , p14_a17 out nocopy JTF_VARCHAR2_TABLE_100

Line 1097: , p14_a18 out nocopy JTF_NUMBER_TABLE

1093: , p14_a14 out nocopy JTF_DATE_TABLE
1094: , p14_a15 out nocopy JTF_DATE_TABLE
1095: , p14_a16 out nocopy JTF_VARCHAR2_TABLE_4000
1096: , p14_a17 out nocopy JTF_VARCHAR2_TABLE_100
1097: , p14_a18 out nocopy JTF_NUMBER_TABLE
1098: , p14_a19 out nocopy JTF_VARCHAR2_TABLE_400
1099: , p14_a20 out nocopy JTF_VARCHAR2_TABLE_400
1100: , p14_a21 out nocopy JTF_NUMBER_TABLE
1101: , p14_a22 out nocopy JTF_VARCHAR2_TABLE_100

Line 1100: , p14_a21 out nocopy JTF_NUMBER_TABLE

1096: , p14_a17 out nocopy JTF_VARCHAR2_TABLE_100
1097: , p14_a18 out nocopy JTF_NUMBER_TABLE
1098: , p14_a19 out nocopy JTF_VARCHAR2_TABLE_400
1099: , p14_a20 out nocopy JTF_VARCHAR2_TABLE_400
1100: , p14_a21 out nocopy JTF_NUMBER_TABLE
1101: , p14_a22 out nocopy JTF_VARCHAR2_TABLE_100
1102: , p14_a23 out nocopy JTF_NUMBER_TABLE
1103: , p14_a24 out nocopy JTF_VARCHAR2_TABLE_100
1104: , p14_a25 out nocopy JTF_VARCHAR2_TABLE_300

Line 1102: , p14_a23 out nocopy JTF_NUMBER_TABLE

1098: , p14_a19 out nocopy JTF_VARCHAR2_TABLE_400
1099: , p14_a20 out nocopy JTF_VARCHAR2_TABLE_400
1100: , p14_a21 out nocopy JTF_NUMBER_TABLE
1101: , p14_a22 out nocopy JTF_VARCHAR2_TABLE_100
1102: , p14_a23 out nocopy JTF_NUMBER_TABLE
1103: , p14_a24 out nocopy JTF_VARCHAR2_TABLE_100
1104: , p14_a25 out nocopy JTF_VARCHAR2_TABLE_300
1105: , p14_a26 out nocopy JTF_NUMBER_TABLE
1106: , p14_a27 out nocopy JTF_VARCHAR2_TABLE_100

Line 1105: , p14_a26 out nocopy JTF_NUMBER_TABLE

1101: , p14_a22 out nocopy JTF_VARCHAR2_TABLE_100
1102: , p14_a23 out nocopy JTF_NUMBER_TABLE
1103: , p14_a24 out nocopy JTF_VARCHAR2_TABLE_100
1104: , p14_a25 out nocopy JTF_VARCHAR2_TABLE_300
1105: , p14_a26 out nocopy JTF_NUMBER_TABLE
1106: , p14_a27 out nocopy JTF_VARCHAR2_TABLE_100
1107: , p14_a28 out nocopy JTF_VARCHAR2_TABLE_100
1108: , p14_a29 out nocopy JTF_NUMBER_TABLE
1109: , p14_a30 out nocopy JTF_VARCHAR2_TABLE_100

Line 1108: , p14_a29 out nocopy JTF_NUMBER_TABLE

1104: , p14_a25 out nocopy JTF_VARCHAR2_TABLE_300
1105: , p14_a26 out nocopy JTF_NUMBER_TABLE
1106: , p14_a27 out nocopy JTF_VARCHAR2_TABLE_100
1107: , p14_a28 out nocopy JTF_VARCHAR2_TABLE_100
1108: , p14_a29 out nocopy JTF_NUMBER_TABLE
1109: , p14_a30 out nocopy JTF_VARCHAR2_TABLE_100
1110: , p14_a31 out nocopy JTF_VARCHAR2_TABLE_100
1111: , p14_a32 out nocopy JTF_VARCHAR2_TABLE_100
1112: , p14_a33 out nocopy JTF_VARCHAR2_TABLE_100

Line 1114: , p14_a35 out nocopy JTF_NUMBER_TABLE

1110: , p14_a31 out nocopy JTF_VARCHAR2_TABLE_100
1111: , p14_a32 out nocopy JTF_VARCHAR2_TABLE_100
1112: , p14_a33 out nocopy JTF_VARCHAR2_TABLE_100
1113: , p14_a34 out nocopy JTF_VARCHAR2_TABLE_300
1114: , p14_a35 out nocopy JTF_NUMBER_TABLE
1115: , p14_a36 out nocopy JTF_VARCHAR2_TABLE_100
1116: , p14_a37 out nocopy JTF_NUMBER_TABLE
1117: , p14_a38 out nocopy JTF_VARCHAR2_TABLE_300
1118: , x_tbl_count out nocopy NUMBER

Line 1116: , p14_a37 out nocopy JTF_NUMBER_TABLE

1112: , p14_a33 out nocopy JTF_VARCHAR2_TABLE_100
1113: , p14_a34 out nocopy JTF_VARCHAR2_TABLE_300
1114: , p14_a35 out nocopy JTF_NUMBER_TABLE
1115: , p14_a36 out nocopy JTF_VARCHAR2_TABLE_100
1116: , p14_a37 out nocopy JTF_NUMBER_TABLE
1117: , p14_a38 out nocopy JTF_VARCHAR2_TABLE_300
1118: , x_tbl_count out nocopy NUMBER
1119: )
1120:

Line 1232: , p13_a0 out nocopy JTF_NUMBER_TABLE

1228: , p_instance_number VARCHAR2
1229: , p_workorder_id NUMBER
1230: , p_start_row_index NUMBER
1231: , p_max_rows NUMBER
1232: , p13_a0 out nocopy JTF_NUMBER_TABLE
1233: , p13_a1 out nocopy JTF_NUMBER_TABLE
1234: , p13_a2 out nocopy JTF_NUMBER_TABLE
1235: , p13_a3 out nocopy JTF_NUMBER_TABLE
1236: , p13_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1233: , p13_a1 out nocopy JTF_NUMBER_TABLE

1229: , p_workorder_id NUMBER
1230: , p_start_row_index NUMBER
1231: , p_max_rows NUMBER
1232: , p13_a0 out nocopy JTF_NUMBER_TABLE
1233: , p13_a1 out nocopy JTF_NUMBER_TABLE
1234: , p13_a2 out nocopy JTF_NUMBER_TABLE
1235: , p13_a3 out nocopy JTF_NUMBER_TABLE
1236: , p13_a4 out nocopy JTF_VARCHAR2_TABLE_100
1237: , p13_a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 1234: , p13_a2 out nocopy JTF_NUMBER_TABLE

1230: , p_start_row_index NUMBER
1231: , p_max_rows NUMBER
1232: , p13_a0 out nocopy JTF_NUMBER_TABLE
1233: , p13_a1 out nocopy JTF_NUMBER_TABLE
1234: , p13_a2 out nocopy JTF_NUMBER_TABLE
1235: , p13_a3 out nocopy JTF_NUMBER_TABLE
1236: , p13_a4 out nocopy JTF_VARCHAR2_TABLE_100
1237: , p13_a5 out nocopy JTF_VARCHAR2_TABLE_300
1238: , p13_a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 1235: , p13_a3 out nocopy JTF_NUMBER_TABLE

1231: , p_max_rows NUMBER
1232: , p13_a0 out nocopy JTF_NUMBER_TABLE
1233: , p13_a1 out nocopy JTF_NUMBER_TABLE
1234: , p13_a2 out nocopy JTF_NUMBER_TABLE
1235: , p13_a3 out nocopy JTF_NUMBER_TABLE
1236: , p13_a4 out nocopy JTF_VARCHAR2_TABLE_100
1237: , p13_a5 out nocopy JTF_VARCHAR2_TABLE_300
1238: , p13_a6 out nocopy JTF_VARCHAR2_TABLE_300
1239: , p13_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 1244: , p13_a12 out nocopy JTF_NUMBER_TABLE

1240: , p13_a8 out nocopy JTF_VARCHAR2_TABLE_100
1241: , p13_a9 out nocopy JTF_VARCHAR2_TABLE_100
1242: , p13_a10 out nocopy JTF_VARCHAR2_TABLE_100
1243: , p13_a11 out nocopy JTF_VARCHAR2_TABLE_100
1244: , p13_a12 out nocopy JTF_NUMBER_TABLE
1245: , p13_a13 out nocopy JTF_NUMBER_TABLE
1246: , p13_a14 out nocopy JTF_DATE_TABLE
1247: , p13_a15 out nocopy JTF_DATE_TABLE
1248: , p13_a16 out nocopy JTF_VARCHAR2_TABLE_4000

Line 1245: , p13_a13 out nocopy JTF_NUMBER_TABLE

1241: , p13_a9 out nocopy JTF_VARCHAR2_TABLE_100
1242: , p13_a10 out nocopy JTF_VARCHAR2_TABLE_100
1243: , p13_a11 out nocopy JTF_VARCHAR2_TABLE_100
1244: , p13_a12 out nocopy JTF_NUMBER_TABLE
1245: , p13_a13 out nocopy JTF_NUMBER_TABLE
1246: , p13_a14 out nocopy JTF_DATE_TABLE
1247: , p13_a15 out nocopy JTF_DATE_TABLE
1248: , p13_a16 out nocopy JTF_VARCHAR2_TABLE_4000
1249: , p13_a17 out nocopy JTF_VARCHAR2_TABLE_100

Line 1250: , p13_a18 out nocopy JTF_NUMBER_TABLE

1246: , p13_a14 out nocopy JTF_DATE_TABLE
1247: , p13_a15 out nocopy JTF_DATE_TABLE
1248: , p13_a16 out nocopy JTF_VARCHAR2_TABLE_4000
1249: , p13_a17 out nocopy JTF_VARCHAR2_TABLE_100
1250: , p13_a18 out nocopy JTF_NUMBER_TABLE
1251: , p13_a19 out nocopy JTF_VARCHAR2_TABLE_400
1252: , p13_a20 out nocopy JTF_VARCHAR2_TABLE_400
1253: , p13_a21 out nocopy JTF_NUMBER_TABLE
1254: , p13_a22 out nocopy JTF_VARCHAR2_TABLE_100

Line 1253: , p13_a21 out nocopy JTF_NUMBER_TABLE

1249: , p13_a17 out nocopy JTF_VARCHAR2_TABLE_100
1250: , p13_a18 out nocopy JTF_NUMBER_TABLE
1251: , p13_a19 out nocopy JTF_VARCHAR2_TABLE_400
1252: , p13_a20 out nocopy JTF_VARCHAR2_TABLE_400
1253: , p13_a21 out nocopy JTF_NUMBER_TABLE
1254: , p13_a22 out nocopy JTF_VARCHAR2_TABLE_100
1255: , p13_a23 out nocopy JTF_NUMBER_TABLE
1256: , p13_a24 out nocopy JTF_VARCHAR2_TABLE_100
1257: , p13_a25 out nocopy JTF_VARCHAR2_TABLE_300

Line 1255: , p13_a23 out nocopy JTF_NUMBER_TABLE

1251: , p13_a19 out nocopy JTF_VARCHAR2_TABLE_400
1252: , p13_a20 out nocopy JTF_VARCHAR2_TABLE_400
1253: , p13_a21 out nocopy JTF_NUMBER_TABLE
1254: , p13_a22 out nocopy JTF_VARCHAR2_TABLE_100
1255: , p13_a23 out nocopy JTF_NUMBER_TABLE
1256: , p13_a24 out nocopy JTF_VARCHAR2_TABLE_100
1257: , p13_a25 out nocopy JTF_VARCHAR2_TABLE_300
1258: , p13_a26 out nocopy JTF_NUMBER_TABLE
1259: , p13_a27 out nocopy JTF_VARCHAR2_TABLE_100

Line 1258: , p13_a26 out nocopy JTF_NUMBER_TABLE

1254: , p13_a22 out nocopy JTF_VARCHAR2_TABLE_100
1255: , p13_a23 out nocopy JTF_NUMBER_TABLE
1256: , p13_a24 out nocopy JTF_VARCHAR2_TABLE_100
1257: , p13_a25 out nocopy JTF_VARCHAR2_TABLE_300
1258: , p13_a26 out nocopy JTF_NUMBER_TABLE
1259: , p13_a27 out nocopy JTF_VARCHAR2_TABLE_100
1260: , p13_a28 out nocopy JTF_VARCHAR2_TABLE_100
1261: , p13_a29 out nocopy JTF_NUMBER_TABLE
1262: , p13_a30 out nocopy JTF_VARCHAR2_TABLE_100

Line 1261: , p13_a29 out nocopy JTF_NUMBER_TABLE

1257: , p13_a25 out nocopy JTF_VARCHAR2_TABLE_300
1258: , p13_a26 out nocopy JTF_NUMBER_TABLE
1259: , p13_a27 out nocopy JTF_VARCHAR2_TABLE_100
1260: , p13_a28 out nocopy JTF_VARCHAR2_TABLE_100
1261: , p13_a29 out nocopy JTF_NUMBER_TABLE
1262: , p13_a30 out nocopy JTF_VARCHAR2_TABLE_100
1263: , p13_a31 out nocopy JTF_VARCHAR2_TABLE_100
1264: , p13_a32 out nocopy JTF_VARCHAR2_TABLE_100
1265: , p13_a33 out nocopy JTF_VARCHAR2_TABLE_100

Line 1267: , p13_a35 out nocopy JTF_NUMBER_TABLE

1263: , p13_a31 out nocopy JTF_VARCHAR2_TABLE_100
1264: , p13_a32 out nocopy JTF_VARCHAR2_TABLE_100
1265: , p13_a33 out nocopy JTF_VARCHAR2_TABLE_100
1266: , p13_a34 out nocopy JTF_VARCHAR2_TABLE_300
1267: , p13_a35 out nocopy JTF_NUMBER_TABLE
1268: , p13_a36 out nocopy JTF_VARCHAR2_TABLE_100
1269: , p13_a37 out nocopy JTF_NUMBER_TABLE
1270: , p13_a38 out nocopy JTF_VARCHAR2_TABLE_300
1271: )

Line 1269: , p13_a37 out nocopy JTF_NUMBER_TABLE

1265: , p13_a33 out nocopy JTF_VARCHAR2_TABLE_100
1266: , p13_a34 out nocopy JTF_VARCHAR2_TABLE_300
1267: , p13_a35 out nocopy JTF_NUMBER_TABLE
1268: , p13_a36 out nocopy JTF_VARCHAR2_TABLE_100
1269: , p13_a37 out nocopy JTF_NUMBER_TABLE
1270: , p13_a38 out nocopy JTF_VARCHAR2_TABLE_300
1271: )
1272:
1273: as