APPS.AHL_UA_UNIT_SCHEDULES_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 19: , a3 JTF_VARCHAR2_TABLE_100

15:
16: procedure rosetta_table_copy_in_p3(t out nocopy ahl_ua_unit_schedules_pvt.unit_schedules_result_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_VARCHAR2_TABLE_100
22: ) as
23: ddindx binary_integer; indx binary_integer;

Line 21: , a5 JTF_VARCHAR2_TABLE_100

17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_VARCHAR2_TABLE_100
22: ) as
23: ddindx binary_integer; indx binary_integer;
24: begin
25: if a0 is not null and a0.count > 0 then

Line 48: , a3 out nocopy JTF_VARCHAR2_TABLE_100

44: end rosetta_table_copy_in_p3;
45: procedure rosetta_table_copy_out_p3(t ahl_ua_unit_schedules_pvt.unit_schedules_result_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
46: , a1 out nocopy JTF_NUMBER_TABLE
47: , a2 out nocopy JTF_NUMBER_TABLE
48: , a3 out nocopy JTF_VARCHAR2_TABLE_100
49: , a4 out nocopy JTF_NUMBER_TABLE
50: , a5 out nocopy JTF_VARCHAR2_TABLE_100
51: ) as
52: ddindx binary_integer; indx binary_integer;

Line 50: , a5 out nocopy JTF_VARCHAR2_TABLE_100

46: , a1 out nocopy JTF_NUMBER_TABLE
47: , a2 out nocopy JTF_NUMBER_TABLE
48: , a3 out nocopy JTF_VARCHAR2_TABLE_100
49: , a4 out nocopy JTF_NUMBER_TABLE
50: , a5 out nocopy JTF_VARCHAR2_TABLE_100
51: ) as
52: ddindx binary_integer; indx binary_integer;
53: begin
54: if t is null or t.count = 0 then

Line 58: a3 := JTF_VARCHAR2_TABLE_100();

54: if t is null or t.count = 0 then
55: a0 := JTF_NUMBER_TABLE();
56: a1 := JTF_NUMBER_TABLE();
57: a2 := JTF_NUMBER_TABLE();
58: a3 := JTF_VARCHAR2_TABLE_100();
59: a4 := JTF_NUMBER_TABLE();
60: a5 := JTF_VARCHAR2_TABLE_100();
61: else
62: a0 := JTF_NUMBER_TABLE();

Line 60: a5 := JTF_VARCHAR2_TABLE_100();

56: a1 := JTF_NUMBER_TABLE();
57: a2 := JTF_NUMBER_TABLE();
58: a3 := JTF_VARCHAR2_TABLE_100();
59: a4 := JTF_NUMBER_TABLE();
60: a5 := JTF_VARCHAR2_TABLE_100();
61: else
62: a0 := JTF_NUMBER_TABLE();
63: a1 := JTF_NUMBER_TABLE();
64: a2 := JTF_NUMBER_TABLE();

Line 65: a3 := JTF_VARCHAR2_TABLE_100();

61: else
62: a0 := JTF_NUMBER_TABLE();
63: a1 := JTF_NUMBER_TABLE();
64: a2 := JTF_NUMBER_TABLE();
65: a3 := JTF_VARCHAR2_TABLE_100();
66: a4 := JTF_NUMBER_TABLE();
67: a5 := JTF_VARCHAR2_TABLE_100();
68: if t.count > 0 then
69: a0.extend(t.count);

Line 67: a5 := JTF_VARCHAR2_TABLE_100();

63: a1 := JTF_NUMBER_TABLE();
64: a2 := JTF_NUMBER_TABLE();
65: a3 := JTF_VARCHAR2_TABLE_100();
66: a4 := JTF_NUMBER_TABLE();
67: a5 := JTF_VARCHAR2_TABLE_100();
68: if t.count > 0 then
69: a0.extend(t.count);
70: a1.extend(t.count);
71: a2.extend(t.count);

Line 96: , a2 JTF_VARCHAR2_TABLE_100

92: end rosetta_table_copy_out_p3;
93:
94: procedure rosetta_table_copy_in_p6(t out nocopy ahl_ua_unit_schedules_pvt.unit_schedule_tbl_type, a0 JTF_NUMBER_TABLE
95: , a1 JTF_NUMBER_TABLE
96: , a2 JTF_VARCHAR2_TABLE_100
97: , a3 JTF_VARCHAR2_TABLE_100
98: , a4 JTF_NUMBER_TABLE
99: , a5 JTF_VARCHAR2_TABLE_300
100: , a6 JTF_NUMBER_TABLE

Line 97: , a3 JTF_VARCHAR2_TABLE_100

93:
94: procedure rosetta_table_copy_in_p6(t out nocopy ahl_ua_unit_schedules_pvt.unit_schedule_tbl_type, a0 JTF_NUMBER_TABLE
95: , a1 JTF_NUMBER_TABLE
96: , a2 JTF_VARCHAR2_TABLE_100
97: , a3 JTF_VARCHAR2_TABLE_100
98: , a4 JTF_NUMBER_TABLE
99: , a5 JTF_VARCHAR2_TABLE_300
100: , a6 JTF_NUMBER_TABLE
101: , a7 JTF_VARCHAR2_TABLE_300

Line 108: , a14 JTF_VARCHAR2_TABLE_100

104: , a10 JTF_NUMBER_TABLE
105: , a11 JTF_VARCHAR2_TABLE_300
106: , a12 JTF_DATE_TABLE
107: , a13 JTF_DATE_TABLE
108: , a14 JTF_VARCHAR2_TABLE_100
109: , a15 JTF_NUMBER_TABLE
110: , a16 JTF_NUMBER_TABLE
111: , a17 JTF_VARCHAR2_TABLE_100
112: , a18 JTF_VARCHAR2_TABLE_300

Line 111: , a17 JTF_VARCHAR2_TABLE_100

107: , a13 JTF_DATE_TABLE
108: , a14 JTF_VARCHAR2_TABLE_100
109: , a15 JTF_NUMBER_TABLE
110: , a16 JTF_NUMBER_TABLE
111: , a17 JTF_VARCHAR2_TABLE_100
112: , a18 JTF_VARCHAR2_TABLE_300
113: , a19 JTF_NUMBER_TABLE
114: , a20 JTF_VARCHAR2_TABLE_300
115: , a21 JTF_DATE_TABLE

Line 117: , a23 JTF_VARCHAR2_TABLE_100

113: , a19 JTF_NUMBER_TABLE
114: , a20 JTF_VARCHAR2_TABLE_300
115: , a21 JTF_DATE_TABLE
116: , a22 JTF_NUMBER_TABLE
117: , a23 JTF_VARCHAR2_TABLE_100
118: , a24 JTF_VARCHAR2_TABLE_100
119: , a25 JTF_VARCHAR2_TABLE_100
120: , a26 JTF_VARCHAR2_TABLE_2000
121: , a27 JTF_VARCHAR2_TABLE_100

Line 118: , a24 JTF_VARCHAR2_TABLE_100

114: , a20 JTF_VARCHAR2_TABLE_300
115: , a21 JTF_DATE_TABLE
116: , a22 JTF_NUMBER_TABLE
117: , a23 JTF_VARCHAR2_TABLE_100
118: , a24 JTF_VARCHAR2_TABLE_100
119: , a25 JTF_VARCHAR2_TABLE_100
120: , a26 JTF_VARCHAR2_TABLE_2000
121: , a27 JTF_VARCHAR2_TABLE_100
122: ) as

Line 119: , a25 JTF_VARCHAR2_TABLE_100

115: , a21 JTF_DATE_TABLE
116: , a22 JTF_NUMBER_TABLE
117: , a23 JTF_VARCHAR2_TABLE_100
118: , a24 JTF_VARCHAR2_TABLE_100
119: , a25 JTF_VARCHAR2_TABLE_100
120: , a26 JTF_VARCHAR2_TABLE_2000
121: , a27 JTF_VARCHAR2_TABLE_100
122: ) as
123: ddindx binary_integer; indx binary_integer;

Line 121: , a27 JTF_VARCHAR2_TABLE_100

117: , a23 JTF_VARCHAR2_TABLE_100
118: , a24 JTF_VARCHAR2_TABLE_100
119: , a25 JTF_VARCHAR2_TABLE_100
120: , a26 JTF_VARCHAR2_TABLE_2000
121: , a27 JTF_VARCHAR2_TABLE_100
122: ) as
123: ddindx binary_integer; indx binary_integer;
124: begin
125: if a0 is not null and a0.count > 0 then

Line 169: , a2 out nocopy JTF_VARCHAR2_TABLE_100

165: end if;
166: end rosetta_table_copy_in_p6;
167: procedure rosetta_table_copy_out_p6(t ahl_ua_unit_schedules_pvt.unit_schedule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
168: , a1 out nocopy JTF_NUMBER_TABLE
169: , a2 out nocopy JTF_VARCHAR2_TABLE_100
170: , a3 out nocopy JTF_VARCHAR2_TABLE_100
171: , a4 out nocopy JTF_NUMBER_TABLE
172: , a5 out nocopy JTF_VARCHAR2_TABLE_300
173: , a6 out nocopy JTF_NUMBER_TABLE

Line 170: , a3 out nocopy JTF_VARCHAR2_TABLE_100

166: end rosetta_table_copy_in_p6;
167: procedure rosetta_table_copy_out_p6(t ahl_ua_unit_schedules_pvt.unit_schedule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
168: , a1 out nocopy JTF_NUMBER_TABLE
169: , a2 out nocopy JTF_VARCHAR2_TABLE_100
170: , a3 out nocopy JTF_VARCHAR2_TABLE_100
171: , a4 out nocopy JTF_NUMBER_TABLE
172: , a5 out nocopy JTF_VARCHAR2_TABLE_300
173: , a6 out nocopy JTF_NUMBER_TABLE
174: , a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 181: , a14 out nocopy JTF_VARCHAR2_TABLE_100

177: , a10 out nocopy JTF_NUMBER_TABLE
178: , a11 out nocopy JTF_VARCHAR2_TABLE_300
179: , a12 out nocopy JTF_DATE_TABLE
180: , a13 out nocopy JTF_DATE_TABLE
181: , a14 out nocopy JTF_VARCHAR2_TABLE_100
182: , a15 out nocopy JTF_NUMBER_TABLE
183: , a16 out nocopy JTF_NUMBER_TABLE
184: , a17 out nocopy JTF_VARCHAR2_TABLE_100
185: , a18 out nocopy JTF_VARCHAR2_TABLE_300

Line 184: , a17 out nocopy JTF_VARCHAR2_TABLE_100

180: , a13 out nocopy JTF_DATE_TABLE
181: , a14 out nocopy JTF_VARCHAR2_TABLE_100
182: , a15 out nocopy JTF_NUMBER_TABLE
183: , a16 out nocopy JTF_NUMBER_TABLE
184: , a17 out nocopy JTF_VARCHAR2_TABLE_100
185: , a18 out nocopy JTF_VARCHAR2_TABLE_300
186: , a19 out nocopy JTF_NUMBER_TABLE
187: , a20 out nocopy JTF_VARCHAR2_TABLE_300
188: , a21 out nocopy JTF_DATE_TABLE

Line 190: , a23 out nocopy JTF_VARCHAR2_TABLE_100

186: , a19 out nocopy JTF_NUMBER_TABLE
187: , a20 out nocopy JTF_VARCHAR2_TABLE_300
188: , a21 out nocopy JTF_DATE_TABLE
189: , a22 out nocopy JTF_NUMBER_TABLE
190: , a23 out nocopy JTF_VARCHAR2_TABLE_100
191: , a24 out nocopy JTF_VARCHAR2_TABLE_100
192: , a25 out nocopy JTF_VARCHAR2_TABLE_100
193: , a26 out nocopy JTF_VARCHAR2_TABLE_2000
194: , a27 out nocopy JTF_VARCHAR2_TABLE_100

Line 191: , a24 out nocopy JTF_VARCHAR2_TABLE_100

187: , a20 out nocopy JTF_VARCHAR2_TABLE_300
188: , a21 out nocopy JTF_DATE_TABLE
189: , a22 out nocopy JTF_NUMBER_TABLE
190: , a23 out nocopy JTF_VARCHAR2_TABLE_100
191: , a24 out nocopy JTF_VARCHAR2_TABLE_100
192: , a25 out nocopy JTF_VARCHAR2_TABLE_100
193: , a26 out nocopy JTF_VARCHAR2_TABLE_2000
194: , a27 out nocopy JTF_VARCHAR2_TABLE_100
195: ) as

Line 192: , a25 out nocopy JTF_VARCHAR2_TABLE_100

188: , a21 out nocopy JTF_DATE_TABLE
189: , a22 out nocopy JTF_NUMBER_TABLE
190: , a23 out nocopy JTF_VARCHAR2_TABLE_100
191: , a24 out nocopy JTF_VARCHAR2_TABLE_100
192: , a25 out nocopy JTF_VARCHAR2_TABLE_100
193: , a26 out nocopy JTF_VARCHAR2_TABLE_2000
194: , a27 out nocopy JTF_VARCHAR2_TABLE_100
195: ) as
196: ddindx binary_integer; indx binary_integer;

Line 194: , a27 out nocopy JTF_VARCHAR2_TABLE_100

190: , a23 out nocopy JTF_VARCHAR2_TABLE_100
191: , a24 out nocopy JTF_VARCHAR2_TABLE_100
192: , a25 out nocopy JTF_VARCHAR2_TABLE_100
193: , a26 out nocopy JTF_VARCHAR2_TABLE_2000
194: , a27 out nocopy JTF_VARCHAR2_TABLE_100
195: ) as
196: ddindx binary_integer; indx binary_integer;
197: begin
198: if t is null or t.count = 0 then

Line 201: a2 := JTF_VARCHAR2_TABLE_100();

197: begin
198: if t is null or t.count = 0 then
199: a0 := JTF_NUMBER_TABLE();
200: a1 := JTF_NUMBER_TABLE();
201: a2 := JTF_VARCHAR2_TABLE_100();
202: a3 := JTF_VARCHAR2_TABLE_100();
203: a4 := JTF_NUMBER_TABLE();
204: a5 := JTF_VARCHAR2_TABLE_300();
205: a6 := JTF_NUMBER_TABLE();

Line 202: a3 := JTF_VARCHAR2_TABLE_100();

198: if t is null or t.count = 0 then
199: a0 := JTF_NUMBER_TABLE();
200: a1 := JTF_NUMBER_TABLE();
201: a2 := JTF_VARCHAR2_TABLE_100();
202: a3 := JTF_VARCHAR2_TABLE_100();
203: a4 := JTF_NUMBER_TABLE();
204: a5 := JTF_VARCHAR2_TABLE_300();
205: a6 := JTF_NUMBER_TABLE();
206: a7 := JTF_VARCHAR2_TABLE_300();

Line 213: a14 := JTF_VARCHAR2_TABLE_100();

209: a10 := JTF_NUMBER_TABLE();
210: a11 := JTF_VARCHAR2_TABLE_300();
211: a12 := JTF_DATE_TABLE();
212: a13 := JTF_DATE_TABLE();
213: a14 := JTF_VARCHAR2_TABLE_100();
214: a15 := JTF_NUMBER_TABLE();
215: a16 := JTF_NUMBER_TABLE();
216: a17 := JTF_VARCHAR2_TABLE_100();
217: a18 := JTF_VARCHAR2_TABLE_300();

Line 216: a17 := JTF_VARCHAR2_TABLE_100();

212: a13 := JTF_DATE_TABLE();
213: a14 := JTF_VARCHAR2_TABLE_100();
214: a15 := JTF_NUMBER_TABLE();
215: a16 := JTF_NUMBER_TABLE();
216: a17 := JTF_VARCHAR2_TABLE_100();
217: a18 := JTF_VARCHAR2_TABLE_300();
218: a19 := JTF_NUMBER_TABLE();
219: a20 := JTF_VARCHAR2_TABLE_300();
220: a21 := JTF_DATE_TABLE();

Line 222: a23 := JTF_VARCHAR2_TABLE_100();

218: a19 := JTF_NUMBER_TABLE();
219: a20 := JTF_VARCHAR2_TABLE_300();
220: a21 := JTF_DATE_TABLE();
221: a22 := JTF_NUMBER_TABLE();
222: a23 := JTF_VARCHAR2_TABLE_100();
223: a24 := JTF_VARCHAR2_TABLE_100();
224: a25 := JTF_VARCHAR2_TABLE_100();
225: a26 := JTF_VARCHAR2_TABLE_2000();
226: a27 := JTF_VARCHAR2_TABLE_100();

Line 223: a24 := JTF_VARCHAR2_TABLE_100();

219: a20 := JTF_VARCHAR2_TABLE_300();
220: a21 := JTF_DATE_TABLE();
221: a22 := JTF_NUMBER_TABLE();
222: a23 := JTF_VARCHAR2_TABLE_100();
223: a24 := JTF_VARCHAR2_TABLE_100();
224: a25 := JTF_VARCHAR2_TABLE_100();
225: a26 := JTF_VARCHAR2_TABLE_2000();
226: a27 := JTF_VARCHAR2_TABLE_100();
227: else

Line 224: a25 := JTF_VARCHAR2_TABLE_100();

220: a21 := JTF_DATE_TABLE();
221: a22 := JTF_NUMBER_TABLE();
222: a23 := JTF_VARCHAR2_TABLE_100();
223: a24 := JTF_VARCHAR2_TABLE_100();
224: a25 := JTF_VARCHAR2_TABLE_100();
225: a26 := JTF_VARCHAR2_TABLE_2000();
226: a27 := JTF_VARCHAR2_TABLE_100();
227: else
228: a0 := JTF_NUMBER_TABLE();

Line 226: a27 := JTF_VARCHAR2_TABLE_100();

222: a23 := JTF_VARCHAR2_TABLE_100();
223: a24 := JTF_VARCHAR2_TABLE_100();
224: a25 := JTF_VARCHAR2_TABLE_100();
225: a26 := JTF_VARCHAR2_TABLE_2000();
226: a27 := JTF_VARCHAR2_TABLE_100();
227: else
228: a0 := JTF_NUMBER_TABLE();
229: a1 := JTF_NUMBER_TABLE();
230: a2 := JTF_VARCHAR2_TABLE_100();

Line 230: a2 := JTF_VARCHAR2_TABLE_100();

226: a27 := JTF_VARCHAR2_TABLE_100();
227: else
228: a0 := JTF_NUMBER_TABLE();
229: a1 := JTF_NUMBER_TABLE();
230: a2 := JTF_VARCHAR2_TABLE_100();
231: a3 := JTF_VARCHAR2_TABLE_100();
232: a4 := JTF_NUMBER_TABLE();
233: a5 := JTF_VARCHAR2_TABLE_300();
234: a6 := JTF_NUMBER_TABLE();

Line 231: a3 := JTF_VARCHAR2_TABLE_100();

227: else
228: a0 := JTF_NUMBER_TABLE();
229: a1 := JTF_NUMBER_TABLE();
230: a2 := JTF_VARCHAR2_TABLE_100();
231: a3 := JTF_VARCHAR2_TABLE_100();
232: a4 := JTF_NUMBER_TABLE();
233: a5 := JTF_VARCHAR2_TABLE_300();
234: a6 := JTF_NUMBER_TABLE();
235: a7 := JTF_VARCHAR2_TABLE_300();

Line 242: a14 := JTF_VARCHAR2_TABLE_100();

238: a10 := JTF_NUMBER_TABLE();
239: a11 := JTF_VARCHAR2_TABLE_300();
240: a12 := JTF_DATE_TABLE();
241: a13 := JTF_DATE_TABLE();
242: a14 := JTF_VARCHAR2_TABLE_100();
243: a15 := JTF_NUMBER_TABLE();
244: a16 := JTF_NUMBER_TABLE();
245: a17 := JTF_VARCHAR2_TABLE_100();
246: a18 := JTF_VARCHAR2_TABLE_300();

Line 245: a17 := JTF_VARCHAR2_TABLE_100();

241: a13 := JTF_DATE_TABLE();
242: a14 := JTF_VARCHAR2_TABLE_100();
243: a15 := JTF_NUMBER_TABLE();
244: a16 := JTF_NUMBER_TABLE();
245: a17 := JTF_VARCHAR2_TABLE_100();
246: a18 := JTF_VARCHAR2_TABLE_300();
247: a19 := JTF_NUMBER_TABLE();
248: a20 := JTF_VARCHAR2_TABLE_300();
249: a21 := JTF_DATE_TABLE();

Line 251: a23 := JTF_VARCHAR2_TABLE_100();

247: a19 := JTF_NUMBER_TABLE();
248: a20 := JTF_VARCHAR2_TABLE_300();
249: a21 := JTF_DATE_TABLE();
250: a22 := JTF_NUMBER_TABLE();
251: a23 := JTF_VARCHAR2_TABLE_100();
252: a24 := JTF_VARCHAR2_TABLE_100();
253: a25 := JTF_VARCHAR2_TABLE_100();
254: a26 := JTF_VARCHAR2_TABLE_2000();
255: a27 := JTF_VARCHAR2_TABLE_100();

Line 252: a24 := JTF_VARCHAR2_TABLE_100();

248: a20 := JTF_VARCHAR2_TABLE_300();
249: a21 := JTF_DATE_TABLE();
250: a22 := JTF_NUMBER_TABLE();
251: a23 := JTF_VARCHAR2_TABLE_100();
252: a24 := JTF_VARCHAR2_TABLE_100();
253: a25 := JTF_VARCHAR2_TABLE_100();
254: a26 := JTF_VARCHAR2_TABLE_2000();
255: a27 := JTF_VARCHAR2_TABLE_100();
256: if t.count > 0 then

Line 253: a25 := JTF_VARCHAR2_TABLE_100();

249: a21 := JTF_DATE_TABLE();
250: a22 := JTF_NUMBER_TABLE();
251: a23 := JTF_VARCHAR2_TABLE_100();
252: a24 := JTF_VARCHAR2_TABLE_100();
253: a25 := JTF_VARCHAR2_TABLE_100();
254: a26 := JTF_VARCHAR2_TABLE_2000();
255: a27 := JTF_VARCHAR2_TABLE_100();
256: if t.count > 0 then
257: a0.extend(t.count);

Line 255: a27 := JTF_VARCHAR2_TABLE_100();

251: a23 := JTF_VARCHAR2_TABLE_100();
252: a24 := JTF_VARCHAR2_TABLE_100();
253: a25 := JTF_VARCHAR2_TABLE_100();
254: a26 := JTF_VARCHAR2_TABLE_2000();
255: a27 := JTF_VARCHAR2_TABLE_100();
256: if t.count > 0 then
257: a0.extend(t.count);
258: a1.extend(t.count);
259: a2.extend(t.count);

Line 328: , a2 JTF_VARCHAR2_TABLE_100

324: end rosetta_table_copy_out_p6;
325:
326: procedure rosetta_table_copy_in_p8(t out nocopy ahl_ua_unit_schedules_pvt.visit_schedule_tbl_type, a0 JTF_NUMBER_TABLE
327: , a1 JTF_NUMBER_TABLE
328: , a2 JTF_VARCHAR2_TABLE_100
329: , a3 JTF_VARCHAR2_TABLE_100
330: , a4 JTF_VARCHAR2_TABLE_100
331: , a5 JTF_VARCHAR2_TABLE_100
332: , a6 JTF_VARCHAR2_TABLE_100

Line 329: , a3 JTF_VARCHAR2_TABLE_100

325:
326: procedure rosetta_table_copy_in_p8(t out nocopy ahl_ua_unit_schedules_pvt.visit_schedule_tbl_type, a0 JTF_NUMBER_TABLE
327: , a1 JTF_NUMBER_TABLE
328: , a2 JTF_VARCHAR2_TABLE_100
329: , a3 JTF_VARCHAR2_TABLE_100
330: , a4 JTF_VARCHAR2_TABLE_100
331: , a5 JTF_VARCHAR2_TABLE_100
332: , a6 JTF_VARCHAR2_TABLE_100
333: , a7 JTF_NUMBER_TABLE

Line 330: , a4 JTF_VARCHAR2_TABLE_100

326: procedure rosetta_table_copy_in_p8(t out nocopy ahl_ua_unit_schedules_pvt.visit_schedule_tbl_type, a0 JTF_NUMBER_TABLE
327: , a1 JTF_NUMBER_TABLE
328: , a2 JTF_VARCHAR2_TABLE_100
329: , a3 JTF_VARCHAR2_TABLE_100
330: , a4 JTF_VARCHAR2_TABLE_100
331: , a5 JTF_VARCHAR2_TABLE_100
332: , a6 JTF_VARCHAR2_TABLE_100
333: , a7 JTF_NUMBER_TABLE
334: , a8 JTF_VARCHAR2_TABLE_300

Line 331: , a5 JTF_VARCHAR2_TABLE_100

327: , a1 JTF_NUMBER_TABLE
328: , a2 JTF_VARCHAR2_TABLE_100
329: , a3 JTF_VARCHAR2_TABLE_100
330: , a4 JTF_VARCHAR2_TABLE_100
331: , a5 JTF_VARCHAR2_TABLE_100
332: , a6 JTF_VARCHAR2_TABLE_100
333: , a7 JTF_NUMBER_TABLE
334: , a8 JTF_VARCHAR2_TABLE_300
335: , a9 JTF_NUMBER_TABLE

Line 332: , a6 JTF_VARCHAR2_TABLE_100

328: , a2 JTF_VARCHAR2_TABLE_100
329: , a3 JTF_VARCHAR2_TABLE_100
330: , a4 JTF_VARCHAR2_TABLE_100
331: , a5 JTF_VARCHAR2_TABLE_100
332: , a6 JTF_VARCHAR2_TABLE_100
333: , a7 JTF_NUMBER_TABLE
334: , a8 JTF_VARCHAR2_TABLE_300
335: , a9 JTF_NUMBER_TABLE
336: , a10 JTF_VARCHAR2_TABLE_300

Line 339: , a13 JTF_VARCHAR2_TABLE_100

335: , a9 JTF_NUMBER_TABLE
336: , a10 JTF_VARCHAR2_TABLE_300
337: , a11 JTF_DATE_TABLE
338: , a12 JTF_DATE_TABLE
339: , a13 JTF_VARCHAR2_TABLE_100
340: , a14 JTF_NUMBER_TABLE
341: , a15 JTF_NUMBER_TABLE
342: , a16 JTF_VARCHAR2_TABLE_100
343: , a17 JTF_VARCHAR2_TABLE_300

Line 342: , a16 JTF_VARCHAR2_TABLE_100

338: , a12 JTF_DATE_TABLE
339: , a13 JTF_VARCHAR2_TABLE_100
340: , a14 JTF_NUMBER_TABLE
341: , a15 JTF_NUMBER_TABLE
342: , a16 JTF_VARCHAR2_TABLE_100
343: , a17 JTF_VARCHAR2_TABLE_300
344: , a18 JTF_NUMBER_TABLE
345: , a19 JTF_VARCHAR2_TABLE_300
346: , a20 JTF_DATE_TABLE

Line 348: , a22 JTF_VARCHAR2_TABLE_100

344: , a18 JTF_NUMBER_TABLE
345: , a19 JTF_VARCHAR2_TABLE_300
346: , a20 JTF_DATE_TABLE
347: , a21 JTF_NUMBER_TABLE
348: , a22 JTF_VARCHAR2_TABLE_100
349: , a23 JTF_VARCHAR2_TABLE_100
350: , a24 JTF_VARCHAR2_TABLE_100
351: , a25 JTF_VARCHAR2_TABLE_2000
352: , a26 JTF_VARCHAR2_TABLE_100

Line 349: , a23 JTF_VARCHAR2_TABLE_100

345: , a19 JTF_VARCHAR2_TABLE_300
346: , a20 JTF_DATE_TABLE
347: , a21 JTF_NUMBER_TABLE
348: , a22 JTF_VARCHAR2_TABLE_100
349: , a23 JTF_VARCHAR2_TABLE_100
350: , a24 JTF_VARCHAR2_TABLE_100
351: , a25 JTF_VARCHAR2_TABLE_2000
352: , a26 JTF_VARCHAR2_TABLE_100
353: , a27 JTF_VARCHAR2_TABLE_100

Line 350: , a24 JTF_VARCHAR2_TABLE_100

346: , a20 JTF_DATE_TABLE
347: , a21 JTF_NUMBER_TABLE
348: , a22 JTF_VARCHAR2_TABLE_100
349: , a23 JTF_VARCHAR2_TABLE_100
350: , a24 JTF_VARCHAR2_TABLE_100
351: , a25 JTF_VARCHAR2_TABLE_2000
352: , a26 JTF_VARCHAR2_TABLE_100
353: , a27 JTF_VARCHAR2_TABLE_100
354: ) as

Line 352: , a26 JTF_VARCHAR2_TABLE_100

348: , a22 JTF_VARCHAR2_TABLE_100
349: , a23 JTF_VARCHAR2_TABLE_100
350: , a24 JTF_VARCHAR2_TABLE_100
351: , a25 JTF_VARCHAR2_TABLE_2000
352: , a26 JTF_VARCHAR2_TABLE_100
353: , a27 JTF_VARCHAR2_TABLE_100
354: ) as
355: ddindx binary_integer; indx binary_integer;
356: begin

Line 353: , a27 JTF_VARCHAR2_TABLE_100

349: , a23 JTF_VARCHAR2_TABLE_100
350: , a24 JTF_VARCHAR2_TABLE_100
351: , a25 JTF_VARCHAR2_TABLE_2000
352: , a26 JTF_VARCHAR2_TABLE_100
353: , a27 JTF_VARCHAR2_TABLE_100
354: ) as
355: ddindx binary_integer; indx binary_integer;
356: begin
357: if a0 is not null and a0.count > 0 then

Line 401: , a2 out nocopy JTF_VARCHAR2_TABLE_100

397: end if;
398: end rosetta_table_copy_in_p8;
399: procedure rosetta_table_copy_out_p8(t ahl_ua_unit_schedules_pvt.visit_schedule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
400: , a1 out nocopy JTF_NUMBER_TABLE
401: , a2 out nocopy JTF_VARCHAR2_TABLE_100
402: , a3 out nocopy JTF_VARCHAR2_TABLE_100
403: , a4 out nocopy JTF_VARCHAR2_TABLE_100
404: , a5 out nocopy JTF_VARCHAR2_TABLE_100
405: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 402: , a3 out nocopy JTF_VARCHAR2_TABLE_100

398: end rosetta_table_copy_in_p8;
399: procedure rosetta_table_copy_out_p8(t ahl_ua_unit_schedules_pvt.visit_schedule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
400: , a1 out nocopy JTF_NUMBER_TABLE
401: , a2 out nocopy JTF_VARCHAR2_TABLE_100
402: , a3 out nocopy JTF_VARCHAR2_TABLE_100
403: , a4 out nocopy JTF_VARCHAR2_TABLE_100
404: , a5 out nocopy JTF_VARCHAR2_TABLE_100
405: , a6 out nocopy JTF_VARCHAR2_TABLE_100
406: , a7 out nocopy JTF_NUMBER_TABLE

Line 403: , a4 out nocopy JTF_VARCHAR2_TABLE_100

399: procedure rosetta_table_copy_out_p8(t ahl_ua_unit_schedules_pvt.visit_schedule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
400: , a1 out nocopy JTF_NUMBER_TABLE
401: , a2 out nocopy JTF_VARCHAR2_TABLE_100
402: , a3 out nocopy JTF_VARCHAR2_TABLE_100
403: , a4 out nocopy JTF_VARCHAR2_TABLE_100
404: , a5 out nocopy JTF_VARCHAR2_TABLE_100
405: , a6 out nocopy JTF_VARCHAR2_TABLE_100
406: , a7 out nocopy JTF_NUMBER_TABLE
407: , a8 out nocopy JTF_VARCHAR2_TABLE_300

Line 404: , a5 out nocopy JTF_VARCHAR2_TABLE_100

400: , a1 out nocopy JTF_NUMBER_TABLE
401: , a2 out nocopy JTF_VARCHAR2_TABLE_100
402: , a3 out nocopy JTF_VARCHAR2_TABLE_100
403: , a4 out nocopy JTF_VARCHAR2_TABLE_100
404: , a5 out nocopy JTF_VARCHAR2_TABLE_100
405: , a6 out nocopy JTF_VARCHAR2_TABLE_100
406: , a7 out nocopy JTF_NUMBER_TABLE
407: , a8 out nocopy JTF_VARCHAR2_TABLE_300
408: , a9 out nocopy JTF_NUMBER_TABLE

Line 405: , a6 out nocopy JTF_VARCHAR2_TABLE_100

401: , a2 out nocopy JTF_VARCHAR2_TABLE_100
402: , a3 out nocopy JTF_VARCHAR2_TABLE_100
403: , a4 out nocopy JTF_VARCHAR2_TABLE_100
404: , a5 out nocopy JTF_VARCHAR2_TABLE_100
405: , a6 out nocopy JTF_VARCHAR2_TABLE_100
406: , a7 out nocopy JTF_NUMBER_TABLE
407: , a8 out nocopy JTF_VARCHAR2_TABLE_300
408: , a9 out nocopy JTF_NUMBER_TABLE
409: , a10 out nocopy JTF_VARCHAR2_TABLE_300

Line 412: , a13 out nocopy JTF_VARCHAR2_TABLE_100

408: , a9 out nocopy JTF_NUMBER_TABLE
409: , a10 out nocopy JTF_VARCHAR2_TABLE_300
410: , a11 out nocopy JTF_DATE_TABLE
411: , a12 out nocopy JTF_DATE_TABLE
412: , a13 out nocopy JTF_VARCHAR2_TABLE_100
413: , a14 out nocopy JTF_NUMBER_TABLE
414: , a15 out nocopy JTF_NUMBER_TABLE
415: , a16 out nocopy JTF_VARCHAR2_TABLE_100
416: , a17 out nocopy JTF_VARCHAR2_TABLE_300

Line 415: , a16 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 421: , a22 out nocopy JTF_VARCHAR2_TABLE_100

417: , a18 out nocopy JTF_NUMBER_TABLE
418: , a19 out nocopy JTF_VARCHAR2_TABLE_300
419: , a20 out nocopy JTF_DATE_TABLE
420: , a21 out nocopy JTF_NUMBER_TABLE
421: , a22 out nocopy JTF_VARCHAR2_TABLE_100
422: , a23 out nocopy JTF_VARCHAR2_TABLE_100
423: , a24 out nocopy JTF_VARCHAR2_TABLE_100
424: , a25 out nocopy JTF_VARCHAR2_TABLE_2000
425: , a26 out nocopy JTF_VARCHAR2_TABLE_100

Line 422: , a23 out nocopy JTF_VARCHAR2_TABLE_100

418: , a19 out nocopy JTF_VARCHAR2_TABLE_300
419: , a20 out nocopy JTF_DATE_TABLE
420: , a21 out nocopy JTF_NUMBER_TABLE
421: , a22 out nocopy JTF_VARCHAR2_TABLE_100
422: , a23 out nocopy JTF_VARCHAR2_TABLE_100
423: , a24 out nocopy JTF_VARCHAR2_TABLE_100
424: , a25 out nocopy JTF_VARCHAR2_TABLE_2000
425: , a26 out nocopy JTF_VARCHAR2_TABLE_100
426: , a27 out nocopy JTF_VARCHAR2_TABLE_100

Line 423: , a24 out nocopy JTF_VARCHAR2_TABLE_100

419: , a20 out nocopy JTF_DATE_TABLE
420: , a21 out nocopy JTF_NUMBER_TABLE
421: , a22 out nocopy JTF_VARCHAR2_TABLE_100
422: , a23 out nocopy JTF_VARCHAR2_TABLE_100
423: , a24 out nocopy JTF_VARCHAR2_TABLE_100
424: , a25 out nocopy JTF_VARCHAR2_TABLE_2000
425: , a26 out nocopy JTF_VARCHAR2_TABLE_100
426: , a27 out nocopy JTF_VARCHAR2_TABLE_100
427: ) as

Line 425: , a26 out nocopy JTF_VARCHAR2_TABLE_100

421: , a22 out nocopy JTF_VARCHAR2_TABLE_100
422: , a23 out nocopy JTF_VARCHAR2_TABLE_100
423: , a24 out nocopy JTF_VARCHAR2_TABLE_100
424: , a25 out nocopy JTF_VARCHAR2_TABLE_2000
425: , a26 out nocopy JTF_VARCHAR2_TABLE_100
426: , a27 out nocopy JTF_VARCHAR2_TABLE_100
427: ) as
428: ddindx binary_integer; indx binary_integer;
429: begin

Line 426: , a27 out nocopy JTF_VARCHAR2_TABLE_100

422: , a23 out nocopy JTF_VARCHAR2_TABLE_100
423: , a24 out nocopy JTF_VARCHAR2_TABLE_100
424: , a25 out nocopy JTF_VARCHAR2_TABLE_2000
425: , a26 out nocopy JTF_VARCHAR2_TABLE_100
426: , a27 out nocopy JTF_VARCHAR2_TABLE_100
427: ) as
428: ddindx binary_integer; indx binary_integer;
429: begin
430: if t is null or t.count = 0 then

Line 433: a2 := JTF_VARCHAR2_TABLE_100();

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

Line 434: a3 := JTF_VARCHAR2_TABLE_100();

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

Line 435: a4 := JTF_VARCHAR2_TABLE_100();

431: a0 := JTF_NUMBER_TABLE();
432: a1 := JTF_NUMBER_TABLE();
433: a2 := JTF_VARCHAR2_TABLE_100();
434: a3 := JTF_VARCHAR2_TABLE_100();
435: a4 := JTF_VARCHAR2_TABLE_100();
436: a5 := JTF_VARCHAR2_TABLE_100();
437: a6 := JTF_VARCHAR2_TABLE_100();
438: a7 := JTF_NUMBER_TABLE();
439: a8 := JTF_VARCHAR2_TABLE_300();

Line 436: a5 := JTF_VARCHAR2_TABLE_100();

432: a1 := JTF_NUMBER_TABLE();
433: a2 := JTF_VARCHAR2_TABLE_100();
434: a3 := JTF_VARCHAR2_TABLE_100();
435: a4 := JTF_VARCHAR2_TABLE_100();
436: a5 := JTF_VARCHAR2_TABLE_100();
437: a6 := JTF_VARCHAR2_TABLE_100();
438: a7 := JTF_NUMBER_TABLE();
439: a8 := JTF_VARCHAR2_TABLE_300();
440: a9 := JTF_NUMBER_TABLE();

Line 437: a6 := JTF_VARCHAR2_TABLE_100();

433: a2 := JTF_VARCHAR2_TABLE_100();
434: a3 := JTF_VARCHAR2_TABLE_100();
435: a4 := JTF_VARCHAR2_TABLE_100();
436: a5 := JTF_VARCHAR2_TABLE_100();
437: a6 := JTF_VARCHAR2_TABLE_100();
438: a7 := JTF_NUMBER_TABLE();
439: a8 := JTF_VARCHAR2_TABLE_300();
440: a9 := JTF_NUMBER_TABLE();
441: a10 := JTF_VARCHAR2_TABLE_300();

Line 444: a13 := JTF_VARCHAR2_TABLE_100();

440: a9 := JTF_NUMBER_TABLE();
441: a10 := JTF_VARCHAR2_TABLE_300();
442: a11 := JTF_DATE_TABLE();
443: a12 := JTF_DATE_TABLE();
444: a13 := JTF_VARCHAR2_TABLE_100();
445: a14 := JTF_NUMBER_TABLE();
446: a15 := JTF_NUMBER_TABLE();
447: a16 := JTF_VARCHAR2_TABLE_100();
448: a17 := JTF_VARCHAR2_TABLE_300();

Line 447: a16 := JTF_VARCHAR2_TABLE_100();

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

Line 453: a22 := JTF_VARCHAR2_TABLE_100();

449: a18 := JTF_NUMBER_TABLE();
450: a19 := JTF_VARCHAR2_TABLE_300();
451: a20 := JTF_DATE_TABLE();
452: a21 := JTF_NUMBER_TABLE();
453: a22 := JTF_VARCHAR2_TABLE_100();
454: a23 := JTF_VARCHAR2_TABLE_100();
455: a24 := JTF_VARCHAR2_TABLE_100();
456: a25 := JTF_VARCHAR2_TABLE_2000();
457: a26 := JTF_VARCHAR2_TABLE_100();

Line 454: a23 := JTF_VARCHAR2_TABLE_100();

450: a19 := JTF_VARCHAR2_TABLE_300();
451: a20 := JTF_DATE_TABLE();
452: a21 := JTF_NUMBER_TABLE();
453: a22 := JTF_VARCHAR2_TABLE_100();
454: a23 := JTF_VARCHAR2_TABLE_100();
455: a24 := JTF_VARCHAR2_TABLE_100();
456: a25 := JTF_VARCHAR2_TABLE_2000();
457: a26 := JTF_VARCHAR2_TABLE_100();
458: a27 := JTF_VARCHAR2_TABLE_100();

Line 455: a24 := JTF_VARCHAR2_TABLE_100();

451: a20 := JTF_DATE_TABLE();
452: a21 := JTF_NUMBER_TABLE();
453: a22 := JTF_VARCHAR2_TABLE_100();
454: a23 := JTF_VARCHAR2_TABLE_100();
455: a24 := JTF_VARCHAR2_TABLE_100();
456: a25 := JTF_VARCHAR2_TABLE_2000();
457: a26 := JTF_VARCHAR2_TABLE_100();
458: a27 := JTF_VARCHAR2_TABLE_100();
459: else

Line 457: a26 := JTF_VARCHAR2_TABLE_100();

453: a22 := JTF_VARCHAR2_TABLE_100();
454: a23 := JTF_VARCHAR2_TABLE_100();
455: a24 := JTF_VARCHAR2_TABLE_100();
456: a25 := JTF_VARCHAR2_TABLE_2000();
457: a26 := JTF_VARCHAR2_TABLE_100();
458: a27 := JTF_VARCHAR2_TABLE_100();
459: else
460: a0 := JTF_NUMBER_TABLE();
461: a1 := JTF_NUMBER_TABLE();

Line 458: a27 := JTF_VARCHAR2_TABLE_100();

454: a23 := JTF_VARCHAR2_TABLE_100();
455: a24 := JTF_VARCHAR2_TABLE_100();
456: a25 := JTF_VARCHAR2_TABLE_2000();
457: a26 := JTF_VARCHAR2_TABLE_100();
458: a27 := JTF_VARCHAR2_TABLE_100();
459: else
460: a0 := JTF_NUMBER_TABLE();
461: a1 := JTF_NUMBER_TABLE();
462: a2 := JTF_VARCHAR2_TABLE_100();

Line 462: a2 := JTF_VARCHAR2_TABLE_100();

458: a27 := JTF_VARCHAR2_TABLE_100();
459: else
460: a0 := JTF_NUMBER_TABLE();
461: a1 := JTF_NUMBER_TABLE();
462: a2 := JTF_VARCHAR2_TABLE_100();
463: a3 := JTF_VARCHAR2_TABLE_100();
464: a4 := JTF_VARCHAR2_TABLE_100();
465: a5 := JTF_VARCHAR2_TABLE_100();
466: a6 := JTF_VARCHAR2_TABLE_100();

Line 463: a3 := JTF_VARCHAR2_TABLE_100();

459: else
460: a0 := JTF_NUMBER_TABLE();
461: a1 := JTF_NUMBER_TABLE();
462: a2 := JTF_VARCHAR2_TABLE_100();
463: a3 := JTF_VARCHAR2_TABLE_100();
464: a4 := JTF_VARCHAR2_TABLE_100();
465: a5 := JTF_VARCHAR2_TABLE_100();
466: a6 := JTF_VARCHAR2_TABLE_100();
467: a7 := JTF_NUMBER_TABLE();

Line 464: a4 := JTF_VARCHAR2_TABLE_100();

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

Line 465: a5 := JTF_VARCHAR2_TABLE_100();

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

Line 466: a6 := JTF_VARCHAR2_TABLE_100();

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

Line 473: a13 := JTF_VARCHAR2_TABLE_100();

469: a9 := JTF_NUMBER_TABLE();
470: a10 := JTF_VARCHAR2_TABLE_300();
471: a11 := JTF_DATE_TABLE();
472: a12 := JTF_DATE_TABLE();
473: a13 := JTF_VARCHAR2_TABLE_100();
474: a14 := JTF_NUMBER_TABLE();
475: a15 := JTF_NUMBER_TABLE();
476: a16 := JTF_VARCHAR2_TABLE_100();
477: a17 := JTF_VARCHAR2_TABLE_300();

Line 476: a16 := JTF_VARCHAR2_TABLE_100();

472: a12 := JTF_DATE_TABLE();
473: a13 := JTF_VARCHAR2_TABLE_100();
474: a14 := JTF_NUMBER_TABLE();
475: a15 := JTF_NUMBER_TABLE();
476: a16 := JTF_VARCHAR2_TABLE_100();
477: a17 := JTF_VARCHAR2_TABLE_300();
478: a18 := JTF_NUMBER_TABLE();
479: a19 := JTF_VARCHAR2_TABLE_300();
480: a20 := JTF_DATE_TABLE();

Line 482: a22 := JTF_VARCHAR2_TABLE_100();

478: a18 := JTF_NUMBER_TABLE();
479: a19 := JTF_VARCHAR2_TABLE_300();
480: a20 := JTF_DATE_TABLE();
481: a21 := JTF_NUMBER_TABLE();
482: a22 := JTF_VARCHAR2_TABLE_100();
483: a23 := JTF_VARCHAR2_TABLE_100();
484: a24 := JTF_VARCHAR2_TABLE_100();
485: a25 := JTF_VARCHAR2_TABLE_2000();
486: a26 := JTF_VARCHAR2_TABLE_100();

Line 483: a23 := JTF_VARCHAR2_TABLE_100();

479: a19 := JTF_VARCHAR2_TABLE_300();
480: a20 := JTF_DATE_TABLE();
481: a21 := JTF_NUMBER_TABLE();
482: a22 := JTF_VARCHAR2_TABLE_100();
483: a23 := JTF_VARCHAR2_TABLE_100();
484: a24 := JTF_VARCHAR2_TABLE_100();
485: a25 := JTF_VARCHAR2_TABLE_2000();
486: a26 := JTF_VARCHAR2_TABLE_100();
487: a27 := JTF_VARCHAR2_TABLE_100();

Line 484: a24 := JTF_VARCHAR2_TABLE_100();

480: a20 := JTF_DATE_TABLE();
481: a21 := JTF_NUMBER_TABLE();
482: a22 := JTF_VARCHAR2_TABLE_100();
483: a23 := JTF_VARCHAR2_TABLE_100();
484: a24 := JTF_VARCHAR2_TABLE_100();
485: a25 := JTF_VARCHAR2_TABLE_2000();
486: a26 := JTF_VARCHAR2_TABLE_100();
487: a27 := JTF_VARCHAR2_TABLE_100();
488: if t.count > 0 then

Line 486: a26 := JTF_VARCHAR2_TABLE_100();

482: a22 := JTF_VARCHAR2_TABLE_100();
483: a23 := JTF_VARCHAR2_TABLE_100();
484: a24 := JTF_VARCHAR2_TABLE_100();
485: a25 := JTF_VARCHAR2_TABLE_2000();
486: a26 := JTF_VARCHAR2_TABLE_100();
487: a27 := JTF_VARCHAR2_TABLE_100();
488: if t.count > 0 then
489: a0.extend(t.count);
490: a1.extend(t.count);

Line 487: a27 := JTF_VARCHAR2_TABLE_100();

483: a23 := JTF_VARCHAR2_TABLE_100();
484: a24 := JTF_VARCHAR2_TABLE_100();
485: a25 := JTF_VARCHAR2_TABLE_2000();
486: a26 := JTF_VARCHAR2_TABLE_100();
487: a27 := JTF_VARCHAR2_TABLE_100();
488: if t.count > 0 then
489: a0.extend(t.count);
490: a1.extend(t.count);
491: a2.extend(t.count);

Line 571: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100

567: , p4_a5 VARCHAR2
568: , p5_a0 out nocopy JTF_NUMBER_TABLE
569: , p5_a1 out nocopy JTF_NUMBER_TABLE
570: , p5_a2 out nocopy JTF_NUMBER_TABLE
571: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
572: , p5_a4 out nocopy JTF_NUMBER_TABLE
573: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
574: )
575:

Line 573: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100

569: , p5_a1 out nocopy JTF_NUMBER_TABLE
570: , p5_a2 out nocopy JTF_NUMBER_TABLE
571: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
572: , p5_a4 out nocopy JTF_NUMBER_TABLE
573: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
574: )
575:
576: as
577: ddp_unit_schedules_search ahl_ua_unit_schedules_pvt.unit_schedules_search_rec_type;

Line 634: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

630: , p5_a7 in out nocopy VARCHAR2
631: , p5_a8 in out nocopy VARCHAR2
632: , p6_a0 out nocopy JTF_NUMBER_TABLE
633: , p6_a1 out nocopy JTF_NUMBER_TABLE
634: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
635: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
636: , p6_a4 out nocopy JTF_NUMBER_TABLE
637: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
638: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 635: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

631: , p5_a8 in out nocopy VARCHAR2
632: , p6_a0 out nocopy JTF_NUMBER_TABLE
633: , p6_a1 out nocopy JTF_NUMBER_TABLE
634: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
635: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
636: , p6_a4 out nocopy JTF_NUMBER_TABLE
637: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
638: , p6_a6 out nocopy JTF_NUMBER_TABLE
639: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 646: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100

642: , p6_a10 out nocopy JTF_NUMBER_TABLE
643: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_300
644: , p6_a12 out nocopy JTF_DATE_TABLE
645: , p6_a13 out nocopy JTF_DATE_TABLE
646: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
647: , p6_a15 out nocopy JTF_NUMBER_TABLE
648: , p6_a16 out nocopy JTF_NUMBER_TABLE
649: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
650: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300

Line 649: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100

645: , p6_a13 out nocopy JTF_DATE_TABLE
646: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
647: , p6_a15 out nocopy JTF_NUMBER_TABLE
648: , p6_a16 out nocopy JTF_NUMBER_TABLE
649: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
650: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300
651: , p6_a19 out nocopy JTF_NUMBER_TABLE
652: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_300
653: , p6_a21 out nocopy JTF_DATE_TABLE

Line 655: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100

651: , p6_a19 out nocopy JTF_NUMBER_TABLE
652: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_300
653: , p6_a21 out nocopy JTF_DATE_TABLE
654: , p6_a22 out nocopy JTF_NUMBER_TABLE
655: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
656: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
657: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
658: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_2000
659: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100

Line 656: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100

652: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_300
653: , p6_a21 out nocopy JTF_DATE_TABLE
654: , p6_a22 out nocopy JTF_NUMBER_TABLE
655: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
656: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
657: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
658: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_2000
659: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
660: , p7_a0 out nocopy JTF_NUMBER_TABLE

Line 657: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100

653: , p6_a21 out nocopy JTF_DATE_TABLE
654: , p6_a22 out nocopy JTF_NUMBER_TABLE
655: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
656: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
657: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
658: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_2000
659: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
660: , p7_a0 out nocopy JTF_NUMBER_TABLE
661: , p7_a1 out nocopy JTF_NUMBER_TABLE

Line 659: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100

655: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
656: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
657: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
658: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_2000
659: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
660: , p7_a0 out nocopy JTF_NUMBER_TABLE
661: , p7_a1 out nocopy JTF_NUMBER_TABLE
662: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
663: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 662: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100

658: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_2000
659: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
660: , p7_a0 out nocopy JTF_NUMBER_TABLE
661: , p7_a1 out nocopy JTF_NUMBER_TABLE
662: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
663: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
664: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
665: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
666: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 663: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100

659: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
660: , p7_a0 out nocopy JTF_NUMBER_TABLE
661: , p7_a1 out nocopy JTF_NUMBER_TABLE
662: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
663: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
664: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
665: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
666: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
667: , p7_a7 out nocopy JTF_NUMBER_TABLE

Line 664: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100

660: , p7_a0 out nocopy JTF_NUMBER_TABLE
661: , p7_a1 out nocopy JTF_NUMBER_TABLE
662: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
663: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
664: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
665: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
666: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
667: , p7_a7 out nocopy JTF_NUMBER_TABLE
668: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_300

Line 665: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100

661: , p7_a1 out nocopy JTF_NUMBER_TABLE
662: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
663: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
664: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
665: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
666: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
667: , p7_a7 out nocopy JTF_NUMBER_TABLE
668: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_300
669: , p7_a9 out nocopy JTF_NUMBER_TABLE

Line 666: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100

662: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
663: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
664: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
665: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
666: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
667: , p7_a7 out nocopy JTF_NUMBER_TABLE
668: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_300
669: , p7_a9 out nocopy JTF_NUMBER_TABLE
670: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_300

Line 673: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100

669: , p7_a9 out nocopy JTF_NUMBER_TABLE
670: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_300
671: , p7_a11 out nocopy JTF_DATE_TABLE
672: , p7_a12 out nocopy JTF_DATE_TABLE
673: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100
674: , p7_a14 out nocopy JTF_NUMBER_TABLE
675: , p7_a15 out nocopy JTF_NUMBER_TABLE
676: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
677: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_300

Line 676: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100

672: , p7_a12 out nocopy JTF_DATE_TABLE
673: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100
674: , p7_a14 out nocopy JTF_NUMBER_TABLE
675: , p7_a15 out nocopy JTF_NUMBER_TABLE
676: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
677: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_300
678: , p7_a18 out nocopy JTF_NUMBER_TABLE
679: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_300
680: , p7_a20 out nocopy JTF_DATE_TABLE

Line 682: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100

678: , p7_a18 out nocopy JTF_NUMBER_TABLE
679: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_300
680: , p7_a20 out nocopy JTF_DATE_TABLE
681: , p7_a21 out nocopy JTF_NUMBER_TABLE
682: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
683: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_100
684: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_100
685: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_2000
686: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_100

Line 683: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_100

679: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_300
680: , p7_a20 out nocopy JTF_DATE_TABLE
681: , p7_a21 out nocopy JTF_NUMBER_TABLE
682: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
683: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_100
684: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_100
685: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_2000
686: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_100
687: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_100

Line 684: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_100

680: , p7_a20 out nocopy JTF_DATE_TABLE
681: , p7_a21 out nocopy JTF_NUMBER_TABLE
682: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
683: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_100
684: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_100
685: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_2000
686: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_100
687: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_100
688: )

Line 686: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_100

682: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
683: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_100
684: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_100
685: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_2000
686: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_100
687: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_100
688: )
689:
690: as

Line 687: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_100

683: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_100
684: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_100
685: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_2000
686: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_100
687: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_100
688: )
689:
690: as
691: ddp_x_mevent_header_rec ahl_ua_unit_schedules_pvt.mevent_header_rec_type;