APPS.AHL_UA_UNIT_SCHEDULES_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: AHLWUUSB.pls 120.1.12020000.2 2012/12/11 05:54:47 prakkum ship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_ua_unit_schedules_pvt.unit_schedules_result_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: ) as
10: ddindx binary_integer; indx binary_integer;

Line 8: , a5 JTF_VARCHAR2_TABLE_100

4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: ) as
10: ddindx binary_integer; indx binary_integer;
11: begin
12: if a0 is not null and a0.count > 0 then

Line 35: , a3 out nocopy JTF_VARCHAR2_TABLE_100

31: end rosetta_table_copy_in_p3;
32: procedure rosetta_table_copy_out_p3(t ahl_ua_unit_schedules_pvt.unit_schedules_result_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_NUMBER_TABLE
34: , a2 out nocopy JTF_NUMBER_TABLE
35: , a3 out nocopy JTF_VARCHAR2_TABLE_100
36: , a4 out nocopy JTF_NUMBER_TABLE
37: , a5 out nocopy JTF_VARCHAR2_TABLE_100
38: ) as
39: ddindx binary_integer; indx binary_integer;

Line 37: , a5 out nocopy JTF_VARCHAR2_TABLE_100

33: , a1 out nocopy JTF_NUMBER_TABLE
34: , a2 out nocopy JTF_NUMBER_TABLE
35: , a3 out nocopy JTF_VARCHAR2_TABLE_100
36: , a4 out nocopy JTF_NUMBER_TABLE
37: , a5 out nocopy JTF_VARCHAR2_TABLE_100
38: ) as
39: ddindx binary_integer; indx binary_integer;
40: begin
41: if t is null or t.count = 0 then

Line 45: a3 := JTF_VARCHAR2_TABLE_100();

41: if t is null or t.count = 0 then
42: a0 := JTF_NUMBER_TABLE();
43: a1 := JTF_NUMBER_TABLE();
44: a2 := JTF_NUMBER_TABLE();
45: a3 := JTF_VARCHAR2_TABLE_100();
46: a4 := JTF_NUMBER_TABLE();
47: a5 := JTF_VARCHAR2_TABLE_100();
48: else
49: a0 := JTF_NUMBER_TABLE();

Line 47: a5 := JTF_VARCHAR2_TABLE_100();

43: a1 := JTF_NUMBER_TABLE();
44: a2 := JTF_NUMBER_TABLE();
45: a3 := JTF_VARCHAR2_TABLE_100();
46: a4 := JTF_NUMBER_TABLE();
47: a5 := JTF_VARCHAR2_TABLE_100();
48: else
49: a0 := JTF_NUMBER_TABLE();
50: a1 := JTF_NUMBER_TABLE();
51: a2 := JTF_NUMBER_TABLE();

Line 52: a3 := JTF_VARCHAR2_TABLE_100();

48: else
49: a0 := JTF_NUMBER_TABLE();
50: a1 := JTF_NUMBER_TABLE();
51: a2 := JTF_NUMBER_TABLE();
52: a3 := JTF_VARCHAR2_TABLE_100();
53: a4 := JTF_NUMBER_TABLE();
54: a5 := JTF_VARCHAR2_TABLE_100();
55: if t.count > 0 then
56: a0.extend(t.count);

Line 54: a5 := JTF_VARCHAR2_TABLE_100();

50: a1 := JTF_NUMBER_TABLE();
51: a2 := JTF_NUMBER_TABLE();
52: a3 := JTF_VARCHAR2_TABLE_100();
53: a4 := JTF_NUMBER_TABLE();
54: a5 := JTF_VARCHAR2_TABLE_100();
55: if t.count > 0 then
56: a0.extend(t.count);
57: a1.extend(t.count);
58: a2.extend(t.count);

Line 83: , a2 JTF_VARCHAR2_TABLE_100

79: end rosetta_table_copy_out_p3;
80:
81: procedure rosetta_table_copy_in_p6(t out nocopy ahl_ua_unit_schedules_pvt.unit_schedule_tbl_type, a0 JTF_NUMBER_TABLE
82: , a1 JTF_NUMBER_TABLE
83: , a2 JTF_VARCHAR2_TABLE_100
84: , a3 JTF_VARCHAR2_TABLE_100
85: , a4 JTF_NUMBER_TABLE
86: , a5 JTF_VARCHAR2_TABLE_300
87: , a6 JTF_NUMBER_TABLE

Line 84: , a3 JTF_VARCHAR2_TABLE_100

80:
81: procedure rosetta_table_copy_in_p6(t out nocopy ahl_ua_unit_schedules_pvt.unit_schedule_tbl_type, a0 JTF_NUMBER_TABLE
82: , a1 JTF_NUMBER_TABLE
83: , a2 JTF_VARCHAR2_TABLE_100
84: , a3 JTF_VARCHAR2_TABLE_100
85: , a4 JTF_NUMBER_TABLE
86: , a5 JTF_VARCHAR2_TABLE_300
87: , a6 JTF_NUMBER_TABLE
88: , a7 JTF_VARCHAR2_TABLE_300

Line 95: , a14 JTF_VARCHAR2_TABLE_100

91: , a10 JTF_NUMBER_TABLE
92: , a11 JTF_VARCHAR2_TABLE_300
93: , a12 JTF_DATE_TABLE
94: , a13 JTF_DATE_TABLE
95: , a14 JTF_VARCHAR2_TABLE_100
96: , a15 JTF_NUMBER_TABLE
97: , a16 JTF_NUMBER_TABLE
98: , a17 JTF_VARCHAR2_TABLE_100
99: , a18 JTF_VARCHAR2_TABLE_300

Line 98: , a17 JTF_VARCHAR2_TABLE_100

94: , a13 JTF_DATE_TABLE
95: , a14 JTF_VARCHAR2_TABLE_100
96: , a15 JTF_NUMBER_TABLE
97: , a16 JTF_NUMBER_TABLE
98: , a17 JTF_VARCHAR2_TABLE_100
99: , a18 JTF_VARCHAR2_TABLE_300
100: , a19 JTF_NUMBER_TABLE
101: , a20 JTF_VARCHAR2_TABLE_300
102: , a21 JTF_DATE_TABLE

Line 104: , a23 JTF_VARCHAR2_TABLE_100

100: , a19 JTF_NUMBER_TABLE
101: , a20 JTF_VARCHAR2_TABLE_300
102: , a21 JTF_DATE_TABLE
103: , a22 JTF_NUMBER_TABLE
104: , a23 JTF_VARCHAR2_TABLE_100
105: , a24 JTF_VARCHAR2_TABLE_100
106: , a25 JTF_VARCHAR2_TABLE_100
107: , a26 JTF_VARCHAR2_TABLE_2000
108: , a27 JTF_VARCHAR2_TABLE_100

Line 105: , a24 JTF_VARCHAR2_TABLE_100

101: , a20 JTF_VARCHAR2_TABLE_300
102: , a21 JTF_DATE_TABLE
103: , a22 JTF_NUMBER_TABLE
104: , a23 JTF_VARCHAR2_TABLE_100
105: , a24 JTF_VARCHAR2_TABLE_100
106: , a25 JTF_VARCHAR2_TABLE_100
107: , a26 JTF_VARCHAR2_TABLE_2000
108: , a27 JTF_VARCHAR2_TABLE_100
109: ) as

Line 106: , a25 JTF_VARCHAR2_TABLE_100

102: , a21 JTF_DATE_TABLE
103: , a22 JTF_NUMBER_TABLE
104: , a23 JTF_VARCHAR2_TABLE_100
105: , a24 JTF_VARCHAR2_TABLE_100
106: , a25 JTF_VARCHAR2_TABLE_100
107: , a26 JTF_VARCHAR2_TABLE_2000
108: , a27 JTF_VARCHAR2_TABLE_100
109: ) as
110: ddindx binary_integer; indx binary_integer;

Line 108: , a27 JTF_VARCHAR2_TABLE_100

104: , a23 JTF_VARCHAR2_TABLE_100
105: , a24 JTF_VARCHAR2_TABLE_100
106: , a25 JTF_VARCHAR2_TABLE_100
107: , a26 JTF_VARCHAR2_TABLE_2000
108: , a27 JTF_VARCHAR2_TABLE_100
109: ) as
110: ddindx binary_integer; indx binary_integer;
111: begin
112: if a0 is not null and a0.count > 0 then

Line 156: , a2 out nocopy JTF_VARCHAR2_TABLE_100

152: end if;
153: end rosetta_table_copy_in_p6;
154: procedure rosetta_table_copy_out_p6(t ahl_ua_unit_schedules_pvt.unit_schedule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
155: , a1 out nocopy JTF_NUMBER_TABLE
156: , a2 out nocopy JTF_VARCHAR2_TABLE_100
157: , a3 out nocopy JTF_VARCHAR2_TABLE_100
158: , a4 out nocopy JTF_NUMBER_TABLE
159: , a5 out nocopy JTF_VARCHAR2_TABLE_300
160: , a6 out nocopy JTF_NUMBER_TABLE

Line 157: , a3 out nocopy JTF_VARCHAR2_TABLE_100

153: end rosetta_table_copy_in_p6;
154: procedure rosetta_table_copy_out_p6(t ahl_ua_unit_schedules_pvt.unit_schedule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
155: , a1 out nocopy JTF_NUMBER_TABLE
156: , a2 out nocopy JTF_VARCHAR2_TABLE_100
157: , a3 out nocopy JTF_VARCHAR2_TABLE_100
158: , a4 out nocopy JTF_NUMBER_TABLE
159: , a5 out nocopy JTF_VARCHAR2_TABLE_300
160: , a6 out nocopy JTF_NUMBER_TABLE
161: , a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 168: , a14 out nocopy JTF_VARCHAR2_TABLE_100

164: , a10 out nocopy JTF_NUMBER_TABLE
165: , a11 out nocopy JTF_VARCHAR2_TABLE_300
166: , a12 out nocopy JTF_DATE_TABLE
167: , a13 out nocopy JTF_DATE_TABLE
168: , a14 out nocopy JTF_VARCHAR2_TABLE_100
169: , a15 out nocopy JTF_NUMBER_TABLE
170: , a16 out nocopy JTF_NUMBER_TABLE
171: , a17 out nocopy JTF_VARCHAR2_TABLE_100
172: , a18 out nocopy JTF_VARCHAR2_TABLE_300

Line 171: , a17 out nocopy JTF_VARCHAR2_TABLE_100

167: , a13 out nocopy JTF_DATE_TABLE
168: , a14 out nocopy JTF_VARCHAR2_TABLE_100
169: , a15 out nocopy JTF_NUMBER_TABLE
170: , a16 out nocopy JTF_NUMBER_TABLE
171: , a17 out nocopy JTF_VARCHAR2_TABLE_100
172: , a18 out nocopy JTF_VARCHAR2_TABLE_300
173: , a19 out nocopy JTF_NUMBER_TABLE
174: , a20 out nocopy JTF_VARCHAR2_TABLE_300
175: , a21 out nocopy JTF_DATE_TABLE

Line 177: , a23 out nocopy JTF_VARCHAR2_TABLE_100

173: , a19 out nocopy JTF_NUMBER_TABLE
174: , a20 out nocopy JTF_VARCHAR2_TABLE_300
175: , a21 out nocopy JTF_DATE_TABLE
176: , a22 out nocopy JTF_NUMBER_TABLE
177: , a23 out nocopy JTF_VARCHAR2_TABLE_100
178: , a24 out nocopy JTF_VARCHAR2_TABLE_100
179: , a25 out nocopy JTF_VARCHAR2_TABLE_100
180: , a26 out nocopy JTF_VARCHAR2_TABLE_2000
181: , a27 out nocopy JTF_VARCHAR2_TABLE_100

Line 178: , a24 out nocopy JTF_VARCHAR2_TABLE_100

174: , a20 out nocopy JTF_VARCHAR2_TABLE_300
175: , a21 out nocopy JTF_DATE_TABLE
176: , a22 out nocopy JTF_NUMBER_TABLE
177: , a23 out nocopy JTF_VARCHAR2_TABLE_100
178: , a24 out nocopy JTF_VARCHAR2_TABLE_100
179: , a25 out nocopy JTF_VARCHAR2_TABLE_100
180: , a26 out nocopy JTF_VARCHAR2_TABLE_2000
181: , a27 out nocopy JTF_VARCHAR2_TABLE_100
182: ) as

Line 179: , a25 out nocopy JTF_VARCHAR2_TABLE_100

175: , a21 out nocopy JTF_DATE_TABLE
176: , a22 out nocopy JTF_NUMBER_TABLE
177: , a23 out nocopy JTF_VARCHAR2_TABLE_100
178: , a24 out nocopy JTF_VARCHAR2_TABLE_100
179: , a25 out nocopy JTF_VARCHAR2_TABLE_100
180: , a26 out nocopy JTF_VARCHAR2_TABLE_2000
181: , a27 out nocopy JTF_VARCHAR2_TABLE_100
182: ) as
183: ddindx binary_integer; indx binary_integer;

Line 181: , a27 out nocopy JTF_VARCHAR2_TABLE_100

177: , a23 out nocopy JTF_VARCHAR2_TABLE_100
178: , a24 out nocopy JTF_VARCHAR2_TABLE_100
179: , a25 out nocopy JTF_VARCHAR2_TABLE_100
180: , a26 out nocopy JTF_VARCHAR2_TABLE_2000
181: , a27 out nocopy JTF_VARCHAR2_TABLE_100
182: ) as
183: ddindx binary_integer; indx binary_integer;
184: begin
185: if t is null or t.count = 0 then

Line 188: a2 := JTF_VARCHAR2_TABLE_100();

184: begin
185: if t is null or t.count = 0 then
186: a0 := JTF_NUMBER_TABLE();
187: a1 := JTF_NUMBER_TABLE();
188: a2 := JTF_VARCHAR2_TABLE_100();
189: a3 := JTF_VARCHAR2_TABLE_100();
190: a4 := JTF_NUMBER_TABLE();
191: a5 := JTF_VARCHAR2_TABLE_300();
192: a6 := JTF_NUMBER_TABLE();

Line 189: a3 := JTF_VARCHAR2_TABLE_100();

185: if t is null or t.count = 0 then
186: a0 := JTF_NUMBER_TABLE();
187: a1 := JTF_NUMBER_TABLE();
188: a2 := JTF_VARCHAR2_TABLE_100();
189: a3 := JTF_VARCHAR2_TABLE_100();
190: a4 := JTF_NUMBER_TABLE();
191: a5 := JTF_VARCHAR2_TABLE_300();
192: a6 := JTF_NUMBER_TABLE();
193: a7 := JTF_VARCHAR2_TABLE_300();

Line 200: a14 := JTF_VARCHAR2_TABLE_100();

196: a10 := JTF_NUMBER_TABLE();
197: a11 := JTF_VARCHAR2_TABLE_300();
198: a12 := JTF_DATE_TABLE();
199: a13 := JTF_DATE_TABLE();
200: a14 := JTF_VARCHAR2_TABLE_100();
201: a15 := JTF_NUMBER_TABLE();
202: a16 := JTF_NUMBER_TABLE();
203: a17 := JTF_VARCHAR2_TABLE_100();
204: a18 := JTF_VARCHAR2_TABLE_300();

Line 203: a17 := JTF_VARCHAR2_TABLE_100();

199: a13 := JTF_DATE_TABLE();
200: a14 := JTF_VARCHAR2_TABLE_100();
201: a15 := JTF_NUMBER_TABLE();
202: a16 := JTF_NUMBER_TABLE();
203: a17 := JTF_VARCHAR2_TABLE_100();
204: a18 := JTF_VARCHAR2_TABLE_300();
205: a19 := JTF_NUMBER_TABLE();
206: a20 := JTF_VARCHAR2_TABLE_300();
207: a21 := JTF_DATE_TABLE();

Line 209: a23 := JTF_VARCHAR2_TABLE_100();

205: a19 := JTF_NUMBER_TABLE();
206: a20 := JTF_VARCHAR2_TABLE_300();
207: a21 := JTF_DATE_TABLE();
208: a22 := JTF_NUMBER_TABLE();
209: a23 := JTF_VARCHAR2_TABLE_100();
210: a24 := JTF_VARCHAR2_TABLE_100();
211: a25 := JTF_VARCHAR2_TABLE_100();
212: a26 := JTF_VARCHAR2_TABLE_2000();
213: a27 := JTF_VARCHAR2_TABLE_100();

Line 210: a24 := JTF_VARCHAR2_TABLE_100();

206: a20 := JTF_VARCHAR2_TABLE_300();
207: a21 := JTF_DATE_TABLE();
208: a22 := JTF_NUMBER_TABLE();
209: a23 := JTF_VARCHAR2_TABLE_100();
210: a24 := JTF_VARCHAR2_TABLE_100();
211: a25 := JTF_VARCHAR2_TABLE_100();
212: a26 := JTF_VARCHAR2_TABLE_2000();
213: a27 := JTF_VARCHAR2_TABLE_100();
214: else

Line 211: a25 := JTF_VARCHAR2_TABLE_100();

207: a21 := JTF_DATE_TABLE();
208: a22 := JTF_NUMBER_TABLE();
209: a23 := JTF_VARCHAR2_TABLE_100();
210: a24 := JTF_VARCHAR2_TABLE_100();
211: a25 := JTF_VARCHAR2_TABLE_100();
212: a26 := JTF_VARCHAR2_TABLE_2000();
213: a27 := JTF_VARCHAR2_TABLE_100();
214: else
215: a0 := JTF_NUMBER_TABLE();

Line 213: a27 := JTF_VARCHAR2_TABLE_100();

209: a23 := JTF_VARCHAR2_TABLE_100();
210: a24 := JTF_VARCHAR2_TABLE_100();
211: a25 := JTF_VARCHAR2_TABLE_100();
212: a26 := JTF_VARCHAR2_TABLE_2000();
213: a27 := JTF_VARCHAR2_TABLE_100();
214: else
215: a0 := JTF_NUMBER_TABLE();
216: a1 := JTF_NUMBER_TABLE();
217: a2 := JTF_VARCHAR2_TABLE_100();

Line 217: a2 := JTF_VARCHAR2_TABLE_100();

213: a27 := JTF_VARCHAR2_TABLE_100();
214: else
215: a0 := JTF_NUMBER_TABLE();
216: a1 := JTF_NUMBER_TABLE();
217: a2 := JTF_VARCHAR2_TABLE_100();
218: a3 := JTF_VARCHAR2_TABLE_100();
219: a4 := JTF_NUMBER_TABLE();
220: a5 := JTF_VARCHAR2_TABLE_300();
221: a6 := JTF_NUMBER_TABLE();

Line 218: a3 := JTF_VARCHAR2_TABLE_100();

214: else
215: a0 := JTF_NUMBER_TABLE();
216: a1 := JTF_NUMBER_TABLE();
217: a2 := JTF_VARCHAR2_TABLE_100();
218: a3 := JTF_VARCHAR2_TABLE_100();
219: a4 := JTF_NUMBER_TABLE();
220: a5 := JTF_VARCHAR2_TABLE_300();
221: a6 := JTF_NUMBER_TABLE();
222: a7 := JTF_VARCHAR2_TABLE_300();

Line 229: a14 := JTF_VARCHAR2_TABLE_100();

225: a10 := JTF_NUMBER_TABLE();
226: a11 := JTF_VARCHAR2_TABLE_300();
227: a12 := JTF_DATE_TABLE();
228: a13 := JTF_DATE_TABLE();
229: a14 := JTF_VARCHAR2_TABLE_100();
230: a15 := JTF_NUMBER_TABLE();
231: a16 := JTF_NUMBER_TABLE();
232: a17 := JTF_VARCHAR2_TABLE_100();
233: a18 := JTF_VARCHAR2_TABLE_300();

Line 232: a17 := JTF_VARCHAR2_TABLE_100();

228: a13 := JTF_DATE_TABLE();
229: a14 := JTF_VARCHAR2_TABLE_100();
230: a15 := JTF_NUMBER_TABLE();
231: a16 := JTF_NUMBER_TABLE();
232: a17 := JTF_VARCHAR2_TABLE_100();
233: a18 := JTF_VARCHAR2_TABLE_300();
234: a19 := JTF_NUMBER_TABLE();
235: a20 := JTF_VARCHAR2_TABLE_300();
236: a21 := JTF_DATE_TABLE();

Line 238: a23 := JTF_VARCHAR2_TABLE_100();

234: a19 := JTF_NUMBER_TABLE();
235: a20 := JTF_VARCHAR2_TABLE_300();
236: a21 := JTF_DATE_TABLE();
237: a22 := JTF_NUMBER_TABLE();
238: a23 := JTF_VARCHAR2_TABLE_100();
239: a24 := JTF_VARCHAR2_TABLE_100();
240: a25 := JTF_VARCHAR2_TABLE_100();
241: a26 := JTF_VARCHAR2_TABLE_2000();
242: a27 := JTF_VARCHAR2_TABLE_100();

Line 239: a24 := JTF_VARCHAR2_TABLE_100();

235: a20 := JTF_VARCHAR2_TABLE_300();
236: a21 := JTF_DATE_TABLE();
237: a22 := JTF_NUMBER_TABLE();
238: a23 := JTF_VARCHAR2_TABLE_100();
239: a24 := JTF_VARCHAR2_TABLE_100();
240: a25 := JTF_VARCHAR2_TABLE_100();
241: a26 := JTF_VARCHAR2_TABLE_2000();
242: a27 := JTF_VARCHAR2_TABLE_100();
243: if t.count > 0 then

Line 240: a25 := JTF_VARCHAR2_TABLE_100();

236: a21 := JTF_DATE_TABLE();
237: a22 := JTF_NUMBER_TABLE();
238: a23 := JTF_VARCHAR2_TABLE_100();
239: a24 := JTF_VARCHAR2_TABLE_100();
240: a25 := JTF_VARCHAR2_TABLE_100();
241: a26 := JTF_VARCHAR2_TABLE_2000();
242: a27 := JTF_VARCHAR2_TABLE_100();
243: if t.count > 0 then
244: a0.extend(t.count);

Line 242: a27 := JTF_VARCHAR2_TABLE_100();

238: a23 := JTF_VARCHAR2_TABLE_100();
239: a24 := JTF_VARCHAR2_TABLE_100();
240: a25 := JTF_VARCHAR2_TABLE_100();
241: a26 := JTF_VARCHAR2_TABLE_2000();
242: a27 := JTF_VARCHAR2_TABLE_100();
243: if t.count > 0 then
244: a0.extend(t.count);
245: a1.extend(t.count);
246: a2.extend(t.count);

Line 315: , a2 JTF_VARCHAR2_TABLE_100

311: end rosetta_table_copy_out_p6;
312:
313: procedure rosetta_table_copy_in_p8(t out nocopy ahl_ua_unit_schedules_pvt.visit_schedule_tbl_type, a0 JTF_NUMBER_TABLE
314: , a1 JTF_NUMBER_TABLE
315: , a2 JTF_VARCHAR2_TABLE_100
316: , a3 JTF_VARCHAR2_TABLE_100
317: , a4 JTF_VARCHAR2_TABLE_100
318: , a5 JTF_VARCHAR2_TABLE_100
319: , a6 JTF_VARCHAR2_TABLE_100

Line 316: , a3 JTF_VARCHAR2_TABLE_100

312:
313: procedure rosetta_table_copy_in_p8(t out nocopy ahl_ua_unit_schedules_pvt.visit_schedule_tbl_type, a0 JTF_NUMBER_TABLE
314: , a1 JTF_NUMBER_TABLE
315: , a2 JTF_VARCHAR2_TABLE_100
316: , a3 JTF_VARCHAR2_TABLE_100
317: , a4 JTF_VARCHAR2_TABLE_100
318: , a5 JTF_VARCHAR2_TABLE_100
319: , a6 JTF_VARCHAR2_TABLE_100
320: , a7 JTF_NUMBER_TABLE

Line 317: , a4 JTF_VARCHAR2_TABLE_100

313: procedure rosetta_table_copy_in_p8(t out nocopy ahl_ua_unit_schedules_pvt.visit_schedule_tbl_type, a0 JTF_NUMBER_TABLE
314: , a1 JTF_NUMBER_TABLE
315: , a2 JTF_VARCHAR2_TABLE_100
316: , a3 JTF_VARCHAR2_TABLE_100
317: , a4 JTF_VARCHAR2_TABLE_100
318: , a5 JTF_VARCHAR2_TABLE_100
319: , a6 JTF_VARCHAR2_TABLE_100
320: , a7 JTF_NUMBER_TABLE
321: , a8 JTF_VARCHAR2_TABLE_300

Line 318: , a5 JTF_VARCHAR2_TABLE_100

314: , a1 JTF_NUMBER_TABLE
315: , a2 JTF_VARCHAR2_TABLE_100
316: , a3 JTF_VARCHAR2_TABLE_100
317: , a4 JTF_VARCHAR2_TABLE_100
318: , a5 JTF_VARCHAR2_TABLE_100
319: , a6 JTF_VARCHAR2_TABLE_100
320: , a7 JTF_NUMBER_TABLE
321: , a8 JTF_VARCHAR2_TABLE_300
322: , a9 JTF_NUMBER_TABLE

Line 319: , a6 JTF_VARCHAR2_TABLE_100

315: , a2 JTF_VARCHAR2_TABLE_100
316: , a3 JTF_VARCHAR2_TABLE_100
317: , a4 JTF_VARCHAR2_TABLE_100
318: , a5 JTF_VARCHAR2_TABLE_100
319: , a6 JTF_VARCHAR2_TABLE_100
320: , a7 JTF_NUMBER_TABLE
321: , a8 JTF_VARCHAR2_TABLE_300
322: , a9 JTF_NUMBER_TABLE
323: , a10 JTF_VARCHAR2_TABLE_300

Line 326: , a13 JTF_VARCHAR2_TABLE_100

322: , a9 JTF_NUMBER_TABLE
323: , a10 JTF_VARCHAR2_TABLE_300
324: , a11 JTF_DATE_TABLE
325: , a12 JTF_DATE_TABLE
326: , a13 JTF_VARCHAR2_TABLE_100
327: , a14 JTF_NUMBER_TABLE
328: , a15 JTF_NUMBER_TABLE
329: , a16 JTF_VARCHAR2_TABLE_100
330: , a17 JTF_VARCHAR2_TABLE_300

Line 329: , a16 JTF_VARCHAR2_TABLE_100

325: , a12 JTF_DATE_TABLE
326: , a13 JTF_VARCHAR2_TABLE_100
327: , a14 JTF_NUMBER_TABLE
328: , a15 JTF_NUMBER_TABLE
329: , a16 JTF_VARCHAR2_TABLE_100
330: , a17 JTF_VARCHAR2_TABLE_300
331: , a18 JTF_NUMBER_TABLE
332: , a19 JTF_VARCHAR2_TABLE_300
333: , a20 JTF_DATE_TABLE

Line 335: , a22 JTF_VARCHAR2_TABLE_100

331: , a18 JTF_NUMBER_TABLE
332: , a19 JTF_VARCHAR2_TABLE_300
333: , a20 JTF_DATE_TABLE
334: , a21 JTF_NUMBER_TABLE
335: , a22 JTF_VARCHAR2_TABLE_100
336: , a23 JTF_VARCHAR2_TABLE_100
337: , a24 JTF_VARCHAR2_TABLE_100
338: , a25 JTF_VARCHAR2_TABLE_2000
339: , a26 JTF_VARCHAR2_TABLE_100

Line 336: , a23 JTF_VARCHAR2_TABLE_100

332: , a19 JTF_VARCHAR2_TABLE_300
333: , a20 JTF_DATE_TABLE
334: , a21 JTF_NUMBER_TABLE
335: , a22 JTF_VARCHAR2_TABLE_100
336: , a23 JTF_VARCHAR2_TABLE_100
337: , a24 JTF_VARCHAR2_TABLE_100
338: , a25 JTF_VARCHAR2_TABLE_2000
339: , a26 JTF_VARCHAR2_TABLE_100
340: , a27 JTF_VARCHAR2_TABLE_100

Line 337: , a24 JTF_VARCHAR2_TABLE_100

333: , a20 JTF_DATE_TABLE
334: , a21 JTF_NUMBER_TABLE
335: , a22 JTF_VARCHAR2_TABLE_100
336: , a23 JTF_VARCHAR2_TABLE_100
337: , a24 JTF_VARCHAR2_TABLE_100
338: , a25 JTF_VARCHAR2_TABLE_2000
339: , a26 JTF_VARCHAR2_TABLE_100
340: , a27 JTF_VARCHAR2_TABLE_100
341: ) as

Line 339: , a26 JTF_VARCHAR2_TABLE_100

335: , a22 JTF_VARCHAR2_TABLE_100
336: , a23 JTF_VARCHAR2_TABLE_100
337: , a24 JTF_VARCHAR2_TABLE_100
338: , a25 JTF_VARCHAR2_TABLE_2000
339: , a26 JTF_VARCHAR2_TABLE_100
340: , a27 JTF_VARCHAR2_TABLE_100
341: ) as
342: ddindx binary_integer; indx binary_integer;
343: begin

Line 340: , a27 JTF_VARCHAR2_TABLE_100

336: , a23 JTF_VARCHAR2_TABLE_100
337: , a24 JTF_VARCHAR2_TABLE_100
338: , a25 JTF_VARCHAR2_TABLE_2000
339: , a26 JTF_VARCHAR2_TABLE_100
340: , a27 JTF_VARCHAR2_TABLE_100
341: ) as
342: ddindx binary_integer; indx binary_integer;
343: begin
344: if a0 is not null and a0.count > 0 then

Line 388: , a2 out nocopy JTF_VARCHAR2_TABLE_100

384: end if;
385: end rosetta_table_copy_in_p8;
386: procedure rosetta_table_copy_out_p8(t ahl_ua_unit_schedules_pvt.visit_schedule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
387: , a1 out nocopy JTF_NUMBER_TABLE
388: , a2 out nocopy JTF_VARCHAR2_TABLE_100
389: , a3 out nocopy JTF_VARCHAR2_TABLE_100
390: , a4 out nocopy JTF_VARCHAR2_TABLE_100
391: , a5 out nocopy JTF_VARCHAR2_TABLE_100
392: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 389: , a3 out nocopy JTF_VARCHAR2_TABLE_100

385: end rosetta_table_copy_in_p8;
386: procedure rosetta_table_copy_out_p8(t ahl_ua_unit_schedules_pvt.visit_schedule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
387: , a1 out nocopy JTF_NUMBER_TABLE
388: , a2 out nocopy JTF_VARCHAR2_TABLE_100
389: , a3 out nocopy JTF_VARCHAR2_TABLE_100
390: , a4 out nocopy JTF_VARCHAR2_TABLE_100
391: , a5 out nocopy JTF_VARCHAR2_TABLE_100
392: , a6 out nocopy JTF_VARCHAR2_TABLE_100
393: , a7 out nocopy JTF_NUMBER_TABLE

Line 390: , a4 out nocopy JTF_VARCHAR2_TABLE_100

386: procedure rosetta_table_copy_out_p8(t ahl_ua_unit_schedules_pvt.visit_schedule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
387: , a1 out nocopy JTF_NUMBER_TABLE
388: , a2 out nocopy JTF_VARCHAR2_TABLE_100
389: , a3 out nocopy JTF_VARCHAR2_TABLE_100
390: , a4 out nocopy JTF_VARCHAR2_TABLE_100
391: , a5 out nocopy JTF_VARCHAR2_TABLE_100
392: , a6 out nocopy JTF_VARCHAR2_TABLE_100
393: , a7 out nocopy JTF_NUMBER_TABLE
394: , a8 out nocopy JTF_VARCHAR2_TABLE_300

Line 391: , a5 out nocopy JTF_VARCHAR2_TABLE_100

387: , a1 out nocopy JTF_NUMBER_TABLE
388: , a2 out nocopy JTF_VARCHAR2_TABLE_100
389: , a3 out nocopy JTF_VARCHAR2_TABLE_100
390: , a4 out nocopy JTF_VARCHAR2_TABLE_100
391: , a5 out nocopy JTF_VARCHAR2_TABLE_100
392: , a6 out nocopy JTF_VARCHAR2_TABLE_100
393: , a7 out nocopy JTF_NUMBER_TABLE
394: , a8 out nocopy JTF_VARCHAR2_TABLE_300
395: , a9 out nocopy JTF_NUMBER_TABLE

Line 392: , a6 out nocopy JTF_VARCHAR2_TABLE_100

388: , a2 out nocopy JTF_VARCHAR2_TABLE_100
389: , a3 out nocopy JTF_VARCHAR2_TABLE_100
390: , a4 out nocopy JTF_VARCHAR2_TABLE_100
391: , a5 out nocopy JTF_VARCHAR2_TABLE_100
392: , a6 out nocopy JTF_VARCHAR2_TABLE_100
393: , a7 out nocopy JTF_NUMBER_TABLE
394: , a8 out nocopy JTF_VARCHAR2_TABLE_300
395: , a9 out nocopy JTF_NUMBER_TABLE
396: , a10 out nocopy JTF_VARCHAR2_TABLE_300

Line 399: , a13 out nocopy JTF_VARCHAR2_TABLE_100

395: , a9 out nocopy JTF_NUMBER_TABLE
396: , a10 out nocopy JTF_VARCHAR2_TABLE_300
397: , a11 out nocopy JTF_DATE_TABLE
398: , a12 out nocopy JTF_DATE_TABLE
399: , a13 out nocopy JTF_VARCHAR2_TABLE_100
400: , a14 out nocopy JTF_NUMBER_TABLE
401: , a15 out nocopy JTF_NUMBER_TABLE
402: , a16 out nocopy JTF_VARCHAR2_TABLE_100
403: , a17 out nocopy JTF_VARCHAR2_TABLE_300

Line 402: , a16 out nocopy JTF_VARCHAR2_TABLE_100

398: , a12 out nocopy JTF_DATE_TABLE
399: , a13 out nocopy JTF_VARCHAR2_TABLE_100
400: , a14 out nocopy JTF_NUMBER_TABLE
401: , a15 out nocopy JTF_NUMBER_TABLE
402: , a16 out nocopy JTF_VARCHAR2_TABLE_100
403: , a17 out nocopy JTF_VARCHAR2_TABLE_300
404: , a18 out nocopy JTF_NUMBER_TABLE
405: , a19 out nocopy JTF_VARCHAR2_TABLE_300
406: , a20 out nocopy JTF_DATE_TABLE

Line 408: , a22 out nocopy JTF_VARCHAR2_TABLE_100

404: , a18 out nocopy JTF_NUMBER_TABLE
405: , a19 out nocopy JTF_VARCHAR2_TABLE_300
406: , a20 out nocopy JTF_DATE_TABLE
407: , a21 out nocopy JTF_NUMBER_TABLE
408: , a22 out nocopy JTF_VARCHAR2_TABLE_100
409: , a23 out nocopy JTF_VARCHAR2_TABLE_100
410: , a24 out nocopy JTF_VARCHAR2_TABLE_100
411: , a25 out nocopy JTF_VARCHAR2_TABLE_2000
412: , a26 out nocopy JTF_VARCHAR2_TABLE_100

Line 409: , a23 out nocopy JTF_VARCHAR2_TABLE_100

405: , a19 out nocopy JTF_VARCHAR2_TABLE_300
406: , a20 out nocopy JTF_DATE_TABLE
407: , a21 out nocopy JTF_NUMBER_TABLE
408: , a22 out nocopy JTF_VARCHAR2_TABLE_100
409: , a23 out nocopy JTF_VARCHAR2_TABLE_100
410: , a24 out nocopy JTF_VARCHAR2_TABLE_100
411: , a25 out nocopy JTF_VARCHAR2_TABLE_2000
412: , a26 out nocopy JTF_VARCHAR2_TABLE_100
413: , a27 out nocopy JTF_VARCHAR2_TABLE_100

Line 410: , a24 out nocopy JTF_VARCHAR2_TABLE_100

406: , a20 out nocopy JTF_DATE_TABLE
407: , a21 out nocopy JTF_NUMBER_TABLE
408: , a22 out nocopy JTF_VARCHAR2_TABLE_100
409: , a23 out nocopy JTF_VARCHAR2_TABLE_100
410: , a24 out nocopy JTF_VARCHAR2_TABLE_100
411: , a25 out nocopy JTF_VARCHAR2_TABLE_2000
412: , a26 out nocopy JTF_VARCHAR2_TABLE_100
413: , a27 out nocopy JTF_VARCHAR2_TABLE_100
414: ) as

Line 412: , a26 out nocopy JTF_VARCHAR2_TABLE_100

408: , a22 out nocopy JTF_VARCHAR2_TABLE_100
409: , a23 out nocopy JTF_VARCHAR2_TABLE_100
410: , a24 out nocopy JTF_VARCHAR2_TABLE_100
411: , a25 out nocopy JTF_VARCHAR2_TABLE_2000
412: , a26 out nocopy JTF_VARCHAR2_TABLE_100
413: , a27 out nocopy JTF_VARCHAR2_TABLE_100
414: ) as
415: ddindx binary_integer; indx binary_integer;
416: begin

Line 413: , a27 out nocopy JTF_VARCHAR2_TABLE_100

409: , a23 out nocopy JTF_VARCHAR2_TABLE_100
410: , a24 out nocopy JTF_VARCHAR2_TABLE_100
411: , a25 out nocopy JTF_VARCHAR2_TABLE_2000
412: , a26 out nocopy JTF_VARCHAR2_TABLE_100
413: , a27 out nocopy JTF_VARCHAR2_TABLE_100
414: ) as
415: ddindx binary_integer; indx binary_integer;
416: begin
417: if t is null or t.count = 0 then

Line 420: a2 := JTF_VARCHAR2_TABLE_100();

416: begin
417: if t is null or t.count = 0 then
418: a0 := JTF_NUMBER_TABLE();
419: a1 := JTF_NUMBER_TABLE();
420: a2 := JTF_VARCHAR2_TABLE_100();
421: a3 := JTF_VARCHAR2_TABLE_100();
422: a4 := JTF_VARCHAR2_TABLE_100();
423: a5 := JTF_VARCHAR2_TABLE_100();
424: a6 := JTF_VARCHAR2_TABLE_100();

Line 421: a3 := JTF_VARCHAR2_TABLE_100();

417: if t is null or t.count = 0 then
418: a0 := JTF_NUMBER_TABLE();
419: a1 := JTF_NUMBER_TABLE();
420: a2 := JTF_VARCHAR2_TABLE_100();
421: a3 := JTF_VARCHAR2_TABLE_100();
422: a4 := JTF_VARCHAR2_TABLE_100();
423: a5 := JTF_VARCHAR2_TABLE_100();
424: a6 := JTF_VARCHAR2_TABLE_100();
425: a7 := JTF_NUMBER_TABLE();

Line 422: a4 := JTF_VARCHAR2_TABLE_100();

418: a0 := JTF_NUMBER_TABLE();
419: a1 := JTF_NUMBER_TABLE();
420: a2 := JTF_VARCHAR2_TABLE_100();
421: a3 := JTF_VARCHAR2_TABLE_100();
422: a4 := JTF_VARCHAR2_TABLE_100();
423: a5 := JTF_VARCHAR2_TABLE_100();
424: a6 := JTF_VARCHAR2_TABLE_100();
425: a7 := JTF_NUMBER_TABLE();
426: a8 := JTF_VARCHAR2_TABLE_300();

Line 423: a5 := JTF_VARCHAR2_TABLE_100();

419: a1 := JTF_NUMBER_TABLE();
420: a2 := JTF_VARCHAR2_TABLE_100();
421: a3 := JTF_VARCHAR2_TABLE_100();
422: a4 := JTF_VARCHAR2_TABLE_100();
423: a5 := JTF_VARCHAR2_TABLE_100();
424: a6 := JTF_VARCHAR2_TABLE_100();
425: a7 := JTF_NUMBER_TABLE();
426: a8 := JTF_VARCHAR2_TABLE_300();
427: a9 := JTF_NUMBER_TABLE();

Line 424: a6 := JTF_VARCHAR2_TABLE_100();

420: a2 := JTF_VARCHAR2_TABLE_100();
421: a3 := JTF_VARCHAR2_TABLE_100();
422: a4 := JTF_VARCHAR2_TABLE_100();
423: a5 := JTF_VARCHAR2_TABLE_100();
424: a6 := JTF_VARCHAR2_TABLE_100();
425: a7 := JTF_NUMBER_TABLE();
426: a8 := JTF_VARCHAR2_TABLE_300();
427: a9 := JTF_NUMBER_TABLE();
428: a10 := JTF_VARCHAR2_TABLE_300();

Line 431: a13 := JTF_VARCHAR2_TABLE_100();

427: a9 := JTF_NUMBER_TABLE();
428: a10 := JTF_VARCHAR2_TABLE_300();
429: a11 := JTF_DATE_TABLE();
430: a12 := JTF_DATE_TABLE();
431: a13 := JTF_VARCHAR2_TABLE_100();
432: a14 := JTF_NUMBER_TABLE();
433: a15 := JTF_NUMBER_TABLE();
434: a16 := JTF_VARCHAR2_TABLE_100();
435: a17 := JTF_VARCHAR2_TABLE_300();

Line 434: a16 := JTF_VARCHAR2_TABLE_100();

430: a12 := JTF_DATE_TABLE();
431: a13 := JTF_VARCHAR2_TABLE_100();
432: a14 := JTF_NUMBER_TABLE();
433: a15 := JTF_NUMBER_TABLE();
434: a16 := JTF_VARCHAR2_TABLE_100();
435: a17 := JTF_VARCHAR2_TABLE_300();
436: a18 := JTF_NUMBER_TABLE();
437: a19 := JTF_VARCHAR2_TABLE_300();
438: a20 := JTF_DATE_TABLE();

Line 440: a22 := JTF_VARCHAR2_TABLE_100();

436: a18 := JTF_NUMBER_TABLE();
437: a19 := JTF_VARCHAR2_TABLE_300();
438: a20 := JTF_DATE_TABLE();
439: a21 := JTF_NUMBER_TABLE();
440: a22 := JTF_VARCHAR2_TABLE_100();
441: a23 := JTF_VARCHAR2_TABLE_100();
442: a24 := JTF_VARCHAR2_TABLE_100();
443: a25 := JTF_VARCHAR2_TABLE_2000();
444: a26 := JTF_VARCHAR2_TABLE_100();

Line 441: a23 := JTF_VARCHAR2_TABLE_100();

437: a19 := JTF_VARCHAR2_TABLE_300();
438: a20 := JTF_DATE_TABLE();
439: a21 := JTF_NUMBER_TABLE();
440: a22 := JTF_VARCHAR2_TABLE_100();
441: a23 := JTF_VARCHAR2_TABLE_100();
442: a24 := JTF_VARCHAR2_TABLE_100();
443: a25 := JTF_VARCHAR2_TABLE_2000();
444: a26 := JTF_VARCHAR2_TABLE_100();
445: a27 := JTF_VARCHAR2_TABLE_100();

Line 442: a24 := JTF_VARCHAR2_TABLE_100();

438: a20 := JTF_DATE_TABLE();
439: a21 := JTF_NUMBER_TABLE();
440: a22 := JTF_VARCHAR2_TABLE_100();
441: a23 := JTF_VARCHAR2_TABLE_100();
442: a24 := JTF_VARCHAR2_TABLE_100();
443: a25 := JTF_VARCHAR2_TABLE_2000();
444: a26 := JTF_VARCHAR2_TABLE_100();
445: a27 := JTF_VARCHAR2_TABLE_100();
446: else

Line 444: a26 := JTF_VARCHAR2_TABLE_100();

440: a22 := JTF_VARCHAR2_TABLE_100();
441: a23 := JTF_VARCHAR2_TABLE_100();
442: a24 := JTF_VARCHAR2_TABLE_100();
443: a25 := JTF_VARCHAR2_TABLE_2000();
444: a26 := JTF_VARCHAR2_TABLE_100();
445: a27 := JTF_VARCHAR2_TABLE_100();
446: else
447: a0 := JTF_NUMBER_TABLE();
448: a1 := JTF_NUMBER_TABLE();

Line 445: a27 := JTF_VARCHAR2_TABLE_100();

441: a23 := JTF_VARCHAR2_TABLE_100();
442: a24 := JTF_VARCHAR2_TABLE_100();
443: a25 := JTF_VARCHAR2_TABLE_2000();
444: a26 := JTF_VARCHAR2_TABLE_100();
445: a27 := JTF_VARCHAR2_TABLE_100();
446: else
447: a0 := JTF_NUMBER_TABLE();
448: a1 := JTF_NUMBER_TABLE();
449: a2 := JTF_VARCHAR2_TABLE_100();

Line 449: a2 := JTF_VARCHAR2_TABLE_100();

445: a27 := JTF_VARCHAR2_TABLE_100();
446: else
447: a0 := JTF_NUMBER_TABLE();
448: a1 := JTF_NUMBER_TABLE();
449: a2 := JTF_VARCHAR2_TABLE_100();
450: a3 := JTF_VARCHAR2_TABLE_100();
451: a4 := JTF_VARCHAR2_TABLE_100();
452: a5 := JTF_VARCHAR2_TABLE_100();
453: a6 := JTF_VARCHAR2_TABLE_100();

Line 450: a3 := JTF_VARCHAR2_TABLE_100();

446: else
447: a0 := JTF_NUMBER_TABLE();
448: a1 := JTF_NUMBER_TABLE();
449: a2 := JTF_VARCHAR2_TABLE_100();
450: a3 := JTF_VARCHAR2_TABLE_100();
451: a4 := JTF_VARCHAR2_TABLE_100();
452: a5 := JTF_VARCHAR2_TABLE_100();
453: a6 := JTF_VARCHAR2_TABLE_100();
454: a7 := JTF_NUMBER_TABLE();

Line 451: a4 := JTF_VARCHAR2_TABLE_100();

447: a0 := JTF_NUMBER_TABLE();
448: a1 := JTF_NUMBER_TABLE();
449: a2 := JTF_VARCHAR2_TABLE_100();
450: a3 := JTF_VARCHAR2_TABLE_100();
451: a4 := JTF_VARCHAR2_TABLE_100();
452: a5 := JTF_VARCHAR2_TABLE_100();
453: a6 := JTF_VARCHAR2_TABLE_100();
454: a7 := JTF_NUMBER_TABLE();
455: a8 := JTF_VARCHAR2_TABLE_300();

Line 452: a5 := JTF_VARCHAR2_TABLE_100();

448: a1 := JTF_NUMBER_TABLE();
449: a2 := JTF_VARCHAR2_TABLE_100();
450: a3 := JTF_VARCHAR2_TABLE_100();
451: a4 := JTF_VARCHAR2_TABLE_100();
452: a5 := JTF_VARCHAR2_TABLE_100();
453: a6 := JTF_VARCHAR2_TABLE_100();
454: a7 := JTF_NUMBER_TABLE();
455: a8 := JTF_VARCHAR2_TABLE_300();
456: a9 := JTF_NUMBER_TABLE();

Line 453: a6 := JTF_VARCHAR2_TABLE_100();

449: a2 := JTF_VARCHAR2_TABLE_100();
450: a3 := JTF_VARCHAR2_TABLE_100();
451: a4 := JTF_VARCHAR2_TABLE_100();
452: a5 := JTF_VARCHAR2_TABLE_100();
453: a6 := JTF_VARCHAR2_TABLE_100();
454: a7 := JTF_NUMBER_TABLE();
455: a8 := JTF_VARCHAR2_TABLE_300();
456: a9 := JTF_NUMBER_TABLE();
457: a10 := JTF_VARCHAR2_TABLE_300();

Line 460: a13 := JTF_VARCHAR2_TABLE_100();

456: a9 := JTF_NUMBER_TABLE();
457: a10 := JTF_VARCHAR2_TABLE_300();
458: a11 := JTF_DATE_TABLE();
459: a12 := JTF_DATE_TABLE();
460: a13 := JTF_VARCHAR2_TABLE_100();
461: a14 := JTF_NUMBER_TABLE();
462: a15 := JTF_NUMBER_TABLE();
463: a16 := JTF_VARCHAR2_TABLE_100();
464: a17 := JTF_VARCHAR2_TABLE_300();

Line 463: a16 := JTF_VARCHAR2_TABLE_100();

459: a12 := JTF_DATE_TABLE();
460: a13 := JTF_VARCHAR2_TABLE_100();
461: a14 := JTF_NUMBER_TABLE();
462: a15 := JTF_NUMBER_TABLE();
463: a16 := JTF_VARCHAR2_TABLE_100();
464: a17 := JTF_VARCHAR2_TABLE_300();
465: a18 := JTF_NUMBER_TABLE();
466: a19 := JTF_VARCHAR2_TABLE_300();
467: a20 := JTF_DATE_TABLE();

Line 469: a22 := JTF_VARCHAR2_TABLE_100();

465: a18 := JTF_NUMBER_TABLE();
466: a19 := JTF_VARCHAR2_TABLE_300();
467: a20 := JTF_DATE_TABLE();
468: a21 := JTF_NUMBER_TABLE();
469: a22 := JTF_VARCHAR2_TABLE_100();
470: a23 := JTF_VARCHAR2_TABLE_100();
471: a24 := JTF_VARCHAR2_TABLE_100();
472: a25 := JTF_VARCHAR2_TABLE_2000();
473: a26 := JTF_VARCHAR2_TABLE_100();

Line 470: a23 := JTF_VARCHAR2_TABLE_100();

466: a19 := JTF_VARCHAR2_TABLE_300();
467: a20 := JTF_DATE_TABLE();
468: a21 := JTF_NUMBER_TABLE();
469: a22 := JTF_VARCHAR2_TABLE_100();
470: a23 := JTF_VARCHAR2_TABLE_100();
471: a24 := JTF_VARCHAR2_TABLE_100();
472: a25 := JTF_VARCHAR2_TABLE_2000();
473: a26 := JTF_VARCHAR2_TABLE_100();
474: a27 := JTF_VARCHAR2_TABLE_100();

Line 471: a24 := JTF_VARCHAR2_TABLE_100();

467: a20 := JTF_DATE_TABLE();
468: a21 := JTF_NUMBER_TABLE();
469: a22 := JTF_VARCHAR2_TABLE_100();
470: a23 := JTF_VARCHAR2_TABLE_100();
471: a24 := JTF_VARCHAR2_TABLE_100();
472: a25 := JTF_VARCHAR2_TABLE_2000();
473: a26 := JTF_VARCHAR2_TABLE_100();
474: a27 := JTF_VARCHAR2_TABLE_100();
475: if t.count > 0 then

Line 473: a26 := JTF_VARCHAR2_TABLE_100();

469: a22 := JTF_VARCHAR2_TABLE_100();
470: a23 := JTF_VARCHAR2_TABLE_100();
471: a24 := JTF_VARCHAR2_TABLE_100();
472: a25 := JTF_VARCHAR2_TABLE_2000();
473: a26 := JTF_VARCHAR2_TABLE_100();
474: a27 := JTF_VARCHAR2_TABLE_100();
475: if t.count > 0 then
476: a0.extend(t.count);
477: a1.extend(t.count);

Line 474: a27 := JTF_VARCHAR2_TABLE_100();

470: a23 := JTF_VARCHAR2_TABLE_100();
471: a24 := JTF_VARCHAR2_TABLE_100();
472: a25 := JTF_VARCHAR2_TABLE_2000();
473: a26 := JTF_VARCHAR2_TABLE_100();
474: a27 := JTF_VARCHAR2_TABLE_100();
475: if t.count > 0 then
476: a0.extend(t.count);
477: a1.extend(t.count);
478: a2.extend(t.count);

Line 558: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100

554: , p4_a5 VARCHAR2
555: , p5_a0 out nocopy JTF_NUMBER_TABLE
556: , p5_a1 out nocopy JTF_NUMBER_TABLE
557: , p5_a2 out nocopy JTF_NUMBER_TABLE
558: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
559: , p5_a4 out nocopy JTF_NUMBER_TABLE
560: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
561: )
562:

Line 560: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100

556: , p5_a1 out nocopy JTF_NUMBER_TABLE
557: , p5_a2 out nocopy JTF_NUMBER_TABLE
558: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
559: , p5_a4 out nocopy JTF_NUMBER_TABLE
560: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
561: )
562:
563: as
564: ddp_unit_schedules_search ahl_ua_unit_schedules_pvt.unit_schedules_search_rec_type;

Line 621: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

617: , p5_a7 in out nocopy VARCHAR2
618: , p5_a8 in out nocopy VARCHAR2
619: , p6_a0 out nocopy JTF_NUMBER_TABLE
620: , p6_a1 out nocopy JTF_NUMBER_TABLE
621: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
622: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
623: , p6_a4 out nocopy JTF_NUMBER_TABLE
624: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
625: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 622: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

618: , p5_a8 in out nocopy VARCHAR2
619: , p6_a0 out nocopy JTF_NUMBER_TABLE
620: , p6_a1 out nocopy JTF_NUMBER_TABLE
621: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
622: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
623: , p6_a4 out nocopy JTF_NUMBER_TABLE
624: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
625: , p6_a6 out nocopy JTF_NUMBER_TABLE
626: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 633: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100

629: , p6_a10 out nocopy JTF_NUMBER_TABLE
630: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_300
631: , p6_a12 out nocopy JTF_DATE_TABLE
632: , p6_a13 out nocopy JTF_DATE_TABLE
633: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
634: , p6_a15 out nocopy JTF_NUMBER_TABLE
635: , p6_a16 out nocopy JTF_NUMBER_TABLE
636: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
637: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300

Line 636: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100

632: , p6_a13 out nocopy JTF_DATE_TABLE
633: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
634: , p6_a15 out nocopy JTF_NUMBER_TABLE
635: , p6_a16 out nocopy JTF_NUMBER_TABLE
636: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
637: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300
638: , p6_a19 out nocopy JTF_NUMBER_TABLE
639: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_300
640: , p6_a21 out nocopy JTF_DATE_TABLE

Line 642: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100

638: , p6_a19 out nocopy JTF_NUMBER_TABLE
639: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_300
640: , p6_a21 out nocopy JTF_DATE_TABLE
641: , p6_a22 out nocopy JTF_NUMBER_TABLE
642: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
643: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
644: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
645: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_2000
646: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100

Line 643: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100

639: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_300
640: , p6_a21 out nocopy JTF_DATE_TABLE
641: , p6_a22 out nocopy JTF_NUMBER_TABLE
642: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
643: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
644: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
645: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_2000
646: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
647: , p7_a0 out nocopy JTF_NUMBER_TABLE

Line 644: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100

640: , p6_a21 out nocopy JTF_DATE_TABLE
641: , p6_a22 out nocopy JTF_NUMBER_TABLE
642: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
643: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
644: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
645: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_2000
646: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
647: , p7_a0 out nocopy JTF_NUMBER_TABLE
648: , p7_a1 out nocopy JTF_NUMBER_TABLE

Line 646: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100

642: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
643: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
644: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
645: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_2000
646: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
647: , p7_a0 out nocopy JTF_NUMBER_TABLE
648: , p7_a1 out nocopy JTF_NUMBER_TABLE
649: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
650: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 649: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100

645: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_2000
646: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
647: , p7_a0 out nocopy JTF_NUMBER_TABLE
648: , p7_a1 out nocopy JTF_NUMBER_TABLE
649: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
650: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
651: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
652: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
653: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 650: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100

646: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
647: , p7_a0 out nocopy JTF_NUMBER_TABLE
648: , p7_a1 out nocopy JTF_NUMBER_TABLE
649: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
650: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
651: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
652: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
653: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
654: , p7_a7 out nocopy JTF_NUMBER_TABLE

Line 651: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100

647: , p7_a0 out nocopy JTF_NUMBER_TABLE
648: , p7_a1 out nocopy JTF_NUMBER_TABLE
649: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
650: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
651: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
652: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
653: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
654: , p7_a7 out nocopy JTF_NUMBER_TABLE
655: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_300

Line 652: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100

648: , p7_a1 out nocopy JTF_NUMBER_TABLE
649: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
650: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
651: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
652: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
653: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
654: , p7_a7 out nocopy JTF_NUMBER_TABLE
655: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_300
656: , p7_a9 out nocopy JTF_NUMBER_TABLE

Line 653: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100

649: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
650: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
651: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
652: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
653: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
654: , p7_a7 out nocopy JTF_NUMBER_TABLE
655: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_300
656: , p7_a9 out nocopy JTF_NUMBER_TABLE
657: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_300

Line 660: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100

656: , p7_a9 out nocopy JTF_NUMBER_TABLE
657: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_300
658: , p7_a11 out nocopy JTF_DATE_TABLE
659: , p7_a12 out nocopy JTF_DATE_TABLE
660: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100
661: , p7_a14 out nocopy JTF_NUMBER_TABLE
662: , p7_a15 out nocopy JTF_NUMBER_TABLE
663: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
664: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_300

Line 663: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100

659: , p7_a12 out nocopy JTF_DATE_TABLE
660: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100
661: , p7_a14 out nocopy JTF_NUMBER_TABLE
662: , p7_a15 out nocopy JTF_NUMBER_TABLE
663: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
664: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_300
665: , p7_a18 out nocopy JTF_NUMBER_TABLE
666: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_300
667: , p7_a20 out nocopy JTF_DATE_TABLE

Line 669: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100

665: , p7_a18 out nocopy JTF_NUMBER_TABLE
666: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_300
667: , p7_a20 out nocopy JTF_DATE_TABLE
668: , p7_a21 out nocopy JTF_NUMBER_TABLE
669: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
670: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_100
671: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_100
672: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_2000
673: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_100

Line 670: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_100

666: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_300
667: , p7_a20 out nocopy JTF_DATE_TABLE
668: , p7_a21 out nocopy JTF_NUMBER_TABLE
669: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
670: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_100
671: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_100
672: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_2000
673: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_100
674: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_100

Line 671: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_100

667: , p7_a20 out nocopy JTF_DATE_TABLE
668: , p7_a21 out nocopy JTF_NUMBER_TABLE
669: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
670: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_100
671: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_100
672: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_2000
673: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_100
674: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_100
675: )

Line 673: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_100

669: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
670: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_100
671: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_100
672: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_2000
673: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_100
674: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_100
675: )
676:
677: as

Line 674: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_100

670: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_100
671: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_100
672: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_2000
673: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_100
674: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_100
675: )
676:
677: as
678: ddp_x_mevent_header_rec ahl_ua_unit_schedules_pvt.mevent_header_rec_type;