eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_UA_UNIT_SCHEDULES_PVT_W dependencies on JTF_NUMBER_TABLE

Line 16: procedure rosetta_table_copy_in_p3(t out nocopy ahl_ua_unit_schedules_pvt.unit_schedules_result_tbl_type, a0 JTF_NUMBER_TABLE

12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_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

Line 17: , a1 JTF_NUMBER_TABLE

13: return d;
14: end;
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

Line 18: , a2 JTF_NUMBER_TABLE

14: end;
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

Line 20: , a4 JTF_NUMBER_TABLE

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;
24: begin

Line 45: procedure rosetta_table_copy_out_p3(t ahl_ua_unit_schedules_pvt.unit_schedules_result_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

41: end loop;
42: end if;
43: end if;
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

Line 46: , a1 out nocopy JTF_NUMBER_TABLE

42: end if;
43: end if;
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

Line 47: , a2 out nocopy JTF_NUMBER_TABLE

43: end if;
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

Line 49: , a4 out nocopy JTF_NUMBER_TABLE

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;
53: begin

Line 55: a0 := JTF_NUMBER_TABLE();

51: ) as
52: ddindx binary_integer; indx binary_integer;
53: begin
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();

Line 56: a1 := JTF_NUMBER_TABLE();

52: ddindx binary_integer; indx binary_integer;
53: begin
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();

Line 57: a2 := JTF_NUMBER_TABLE();

53: begin
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

Line 59: a4 := JTF_NUMBER_TABLE();

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();
63: a1 := JTF_NUMBER_TABLE();

Line 62: a0 := 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();
65: a3 := JTF_VARCHAR2_TABLE_100();
66: a4 := JTF_NUMBER_TABLE();

Line 63: a1 := JTF_NUMBER_TABLE();

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();
65: a3 := JTF_VARCHAR2_TABLE_100();
66: a4 := JTF_NUMBER_TABLE();
67: a5 := JTF_VARCHAR2_TABLE_100();

Line 64: a2 := 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();
65: a3 := JTF_VARCHAR2_TABLE_100();
66: a4 := JTF_NUMBER_TABLE();
67: a5 := JTF_VARCHAR2_TABLE_100();
68: if t.count > 0 then

Line 66: a4 := JTF_NUMBER_TABLE();

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);
70: a1.extend(t.count);

Line 94: procedure rosetta_table_copy_in_p6(t out nocopy ahl_ua_unit_schedules_pvt.unit_schedule_tbl_type, a0 JTF_NUMBER_TABLE

90: end if;
91: end if;
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

Line 95: , a1 JTF_NUMBER_TABLE

91: end if;
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

Line 98: , a4 JTF_NUMBER_TABLE

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
102: , a8 JTF_NUMBER_TABLE

Line 100: , a6 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
102: , a8 JTF_NUMBER_TABLE
103: , a9 JTF_VARCHAR2_TABLE_300
104: , a10 JTF_NUMBER_TABLE

Line 102: , a8 JTF_NUMBER_TABLE

98: , a4 JTF_NUMBER_TABLE
99: , a5 JTF_VARCHAR2_TABLE_300
100: , a6 JTF_NUMBER_TABLE
101: , a7 JTF_VARCHAR2_TABLE_300
102: , a8 JTF_NUMBER_TABLE
103: , a9 JTF_VARCHAR2_TABLE_300
104: , a10 JTF_NUMBER_TABLE
105: , a11 JTF_VARCHAR2_TABLE_300
106: , a12 JTF_DATE_TABLE

Line 104: , a10 JTF_NUMBER_TABLE

100: , a6 JTF_NUMBER_TABLE
101: , a7 JTF_VARCHAR2_TABLE_300
102: , a8 JTF_NUMBER_TABLE
103: , a9 JTF_VARCHAR2_TABLE_300
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

Line 109: , a15 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
113: , a19 JTF_NUMBER_TABLE

Line 110: , a16 JTF_NUMBER_TABLE

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
113: , a19 JTF_NUMBER_TABLE
114: , a20 JTF_VARCHAR2_TABLE_300

Line 113: , a19 JTF_NUMBER_TABLE

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
116: , a22 JTF_NUMBER_TABLE
117: , a23 JTF_VARCHAR2_TABLE_100

Line 116: , a22 JTF_NUMBER_TABLE

112: , a18 JTF_VARCHAR2_TABLE_300
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

Line 167: procedure rosetta_table_copy_out_p6(t ahl_ua_unit_schedules_pvt.unit_schedule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

163: end loop;
164: end if;
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

Line 168: , a1 out nocopy JTF_NUMBER_TABLE

164: end if;
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

Line 171: , a4 out nocopy JTF_NUMBER_TABLE

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
175: , a8 out nocopy JTF_NUMBER_TABLE

Line 173: , a6 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
175: , a8 out nocopy JTF_NUMBER_TABLE
176: , a9 out nocopy JTF_VARCHAR2_TABLE_300
177: , a10 out nocopy JTF_NUMBER_TABLE

Line 175: , a8 out nocopy JTF_NUMBER_TABLE

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
175: , a8 out nocopy JTF_NUMBER_TABLE
176: , a9 out nocopy JTF_VARCHAR2_TABLE_300
177: , a10 out nocopy JTF_NUMBER_TABLE
178: , a11 out nocopy JTF_VARCHAR2_TABLE_300
179: , a12 out nocopy JTF_DATE_TABLE

Line 177: , a10 out nocopy JTF_NUMBER_TABLE

173: , a6 out nocopy JTF_NUMBER_TABLE
174: , a7 out nocopy JTF_VARCHAR2_TABLE_300
175: , a8 out nocopy JTF_NUMBER_TABLE
176: , a9 out nocopy JTF_VARCHAR2_TABLE_300
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

Line 182: , a15 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
186: , a19 out nocopy JTF_NUMBER_TABLE

Line 183: , a16 out nocopy JTF_NUMBER_TABLE

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
186: , a19 out nocopy JTF_NUMBER_TABLE
187: , a20 out nocopy JTF_VARCHAR2_TABLE_300

Line 186: , a19 out nocopy JTF_NUMBER_TABLE

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
189: , a22 out nocopy JTF_NUMBER_TABLE
190: , a23 out nocopy JTF_VARCHAR2_TABLE_100

Line 189: , a22 out nocopy JTF_NUMBER_TABLE

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
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

Line 199: a0 := JTF_NUMBER_TABLE();

195: ) as
196: ddindx binary_integer; indx binary_integer;
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();

Line 200: a1 := JTF_NUMBER_TABLE();

196: ddindx binary_integer; indx binary_integer;
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();

Line 203: a4 := JTF_NUMBER_TABLE();

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();
207: a8 := JTF_NUMBER_TABLE();

Line 205: a6 := 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();
207: a8 := JTF_NUMBER_TABLE();
208: a9 := JTF_VARCHAR2_TABLE_300();
209: a10 := JTF_NUMBER_TABLE();

Line 207: a8 := JTF_NUMBER_TABLE();

203: a4 := JTF_NUMBER_TABLE();
204: a5 := JTF_VARCHAR2_TABLE_300();
205: a6 := JTF_NUMBER_TABLE();
206: a7 := JTF_VARCHAR2_TABLE_300();
207: a8 := JTF_NUMBER_TABLE();
208: a9 := JTF_VARCHAR2_TABLE_300();
209: a10 := JTF_NUMBER_TABLE();
210: a11 := JTF_VARCHAR2_TABLE_300();
211: a12 := JTF_DATE_TABLE();

Line 209: a10 := JTF_NUMBER_TABLE();

205: a6 := JTF_NUMBER_TABLE();
206: a7 := JTF_VARCHAR2_TABLE_300();
207: a8 := JTF_NUMBER_TABLE();
208: a9 := JTF_VARCHAR2_TABLE_300();
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();

Line 214: a15 := 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();
218: a19 := JTF_NUMBER_TABLE();

Line 215: a16 := JTF_NUMBER_TABLE();

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();
218: a19 := JTF_NUMBER_TABLE();
219: a20 := JTF_VARCHAR2_TABLE_300();

Line 218: a19 := JTF_NUMBER_TABLE();

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();
221: a22 := JTF_NUMBER_TABLE();
222: a23 := JTF_VARCHAR2_TABLE_100();

Line 221: a22 := JTF_NUMBER_TABLE();

217: a18 := JTF_VARCHAR2_TABLE_300();
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();

Line 228: a0 := JTF_NUMBER_TABLE();

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();
231: a3 := JTF_VARCHAR2_TABLE_100();
232: a4 := JTF_NUMBER_TABLE();

Line 229: a1 := JTF_NUMBER_TABLE();

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();
231: a3 := JTF_VARCHAR2_TABLE_100();
232: a4 := JTF_NUMBER_TABLE();
233: a5 := JTF_VARCHAR2_TABLE_300();

Line 232: a4 := JTF_NUMBER_TABLE();

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();
236: a8 := JTF_NUMBER_TABLE();

Line 234: a6 := 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();
236: a8 := JTF_NUMBER_TABLE();
237: a9 := JTF_VARCHAR2_TABLE_300();
238: a10 := JTF_NUMBER_TABLE();

Line 236: a8 := JTF_NUMBER_TABLE();

232: a4 := JTF_NUMBER_TABLE();
233: a5 := JTF_VARCHAR2_TABLE_300();
234: a6 := JTF_NUMBER_TABLE();
235: a7 := JTF_VARCHAR2_TABLE_300();
236: a8 := JTF_NUMBER_TABLE();
237: a9 := JTF_VARCHAR2_TABLE_300();
238: a10 := JTF_NUMBER_TABLE();
239: a11 := JTF_VARCHAR2_TABLE_300();
240: a12 := JTF_DATE_TABLE();

Line 238: a10 := JTF_NUMBER_TABLE();

234: a6 := JTF_NUMBER_TABLE();
235: a7 := JTF_VARCHAR2_TABLE_300();
236: a8 := JTF_NUMBER_TABLE();
237: a9 := JTF_VARCHAR2_TABLE_300();
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();

Line 243: a15 := 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();
247: a19 := JTF_NUMBER_TABLE();

Line 244: a16 := JTF_NUMBER_TABLE();

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();
247: a19 := JTF_NUMBER_TABLE();
248: a20 := JTF_VARCHAR2_TABLE_300();

Line 247: a19 := JTF_NUMBER_TABLE();

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();
250: a22 := JTF_NUMBER_TABLE();
251: a23 := JTF_VARCHAR2_TABLE_100();

Line 250: a22 := JTF_NUMBER_TABLE();

246: a18 := JTF_VARCHAR2_TABLE_300();
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();

Line 326: procedure rosetta_table_copy_in_p8(t out nocopy ahl_ua_unit_schedules_pvt.visit_schedule_tbl_type, a0 JTF_NUMBER_TABLE

322: end if;
323: end if;
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

Line 327: , a1 JTF_NUMBER_TABLE

323: end if;
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

Line 333: , a7 JTF_NUMBER_TABLE

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
337: , a11 JTF_DATE_TABLE

Line 335: , a9 JTF_NUMBER_TABLE

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
337: , a11 JTF_DATE_TABLE
338: , a12 JTF_DATE_TABLE
339: , a13 JTF_VARCHAR2_TABLE_100

Line 340: , a14 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
344: , a18 JTF_NUMBER_TABLE

Line 341: , a15 JTF_NUMBER_TABLE

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
344: , a18 JTF_NUMBER_TABLE
345: , a19 JTF_VARCHAR2_TABLE_300

Line 344: , a18 JTF_NUMBER_TABLE

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
347: , a21 JTF_NUMBER_TABLE
348: , a22 JTF_VARCHAR2_TABLE_100

Line 347: , a21 JTF_NUMBER_TABLE

343: , a17 JTF_VARCHAR2_TABLE_300
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

Line 399: procedure rosetta_table_copy_out_p8(t ahl_ua_unit_schedules_pvt.visit_schedule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

395: end loop;
396: end if;
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

Line 400: , a1 out nocopy JTF_NUMBER_TABLE

396: end if;
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

Line 406: , a7 out nocopy JTF_NUMBER_TABLE

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
410: , a11 out nocopy JTF_DATE_TABLE

Line 408: , a9 out nocopy JTF_NUMBER_TABLE

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
410: , a11 out nocopy JTF_DATE_TABLE
411: , a12 out nocopy JTF_DATE_TABLE
412: , a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 413: , a14 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
417: , a18 out nocopy JTF_NUMBER_TABLE

Line 414: , a15 out nocopy JTF_NUMBER_TABLE

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
417: , a18 out nocopy JTF_NUMBER_TABLE
418: , a19 out nocopy JTF_VARCHAR2_TABLE_300

Line 417: , a18 out nocopy JTF_NUMBER_TABLE

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
420: , a21 out nocopy JTF_NUMBER_TABLE
421: , a22 out nocopy JTF_VARCHAR2_TABLE_100

Line 420: , a21 out nocopy JTF_NUMBER_TABLE

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
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

Line 431: a0 := JTF_NUMBER_TABLE();

427: ) as
428: ddindx binary_integer; indx binary_integer;
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();

Line 432: a1 := JTF_NUMBER_TABLE();

428: ddindx binary_integer; indx binary_integer;
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();

Line 438: a7 := JTF_NUMBER_TABLE();

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();
442: a11 := JTF_DATE_TABLE();

Line 440: a9 := JTF_NUMBER_TABLE();

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();
442: a11 := JTF_DATE_TABLE();
443: a12 := JTF_DATE_TABLE();
444: a13 := JTF_VARCHAR2_TABLE_100();

Line 445: a14 := 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();
449: a18 := JTF_NUMBER_TABLE();

Line 446: a15 := JTF_NUMBER_TABLE();

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();
449: a18 := JTF_NUMBER_TABLE();
450: a19 := JTF_VARCHAR2_TABLE_300();

Line 449: a18 := JTF_NUMBER_TABLE();

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();
452: a21 := JTF_NUMBER_TABLE();
453: a22 := JTF_VARCHAR2_TABLE_100();

Line 452: a21 := JTF_NUMBER_TABLE();

448: a17 := JTF_VARCHAR2_TABLE_300();
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();

Line 460: a0 := JTF_NUMBER_TABLE();

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();
463: a3 := JTF_VARCHAR2_TABLE_100();
464: a4 := JTF_VARCHAR2_TABLE_100();

Line 461: a1 := JTF_NUMBER_TABLE();

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();
463: a3 := JTF_VARCHAR2_TABLE_100();
464: a4 := JTF_VARCHAR2_TABLE_100();
465: a5 := JTF_VARCHAR2_TABLE_100();

Line 467: a7 := JTF_NUMBER_TABLE();

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();
471: a11 := JTF_DATE_TABLE();

Line 469: a9 := JTF_NUMBER_TABLE();

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();
471: a11 := JTF_DATE_TABLE();
472: a12 := JTF_DATE_TABLE();
473: a13 := JTF_VARCHAR2_TABLE_100();

Line 474: a14 := 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();
478: a18 := JTF_NUMBER_TABLE();

Line 475: a15 := JTF_NUMBER_TABLE();

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();
478: a18 := JTF_NUMBER_TABLE();
479: a19 := JTF_VARCHAR2_TABLE_300();

Line 478: a18 := JTF_NUMBER_TABLE();

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();
481: a21 := JTF_NUMBER_TABLE();
482: a22 := JTF_VARCHAR2_TABLE_100();

Line 481: a21 := JTF_NUMBER_TABLE();

477: a17 := JTF_VARCHAR2_TABLE_300();
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();

Line 568: , p5_a0 out nocopy JTF_NUMBER_TABLE

564: , p4_a2 VARCHAR2
565: , p4_a3 DATE
566: , p4_a4 NUMBER
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

Line 569: , p5_a1 out nocopy JTF_NUMBER_TABLE

565: , p4_a3 DATE
566: , p4_a4 NUMBER
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

Line 570: , p5_a2 out nocopy JTF_NUMBER_TABLE

566: , p4_a4 NUMBER
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: )

Line 572: , p5_a4 out nocopy JTF_NUMBER_TABLE

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:
576: as

Line 632: , p6_a0 out nocopy JTF_NUMBER_TABLE

628: , p5_a5 in out nocopy VARCHAR2
629: , p5_a6 in out nocopy NUMBER
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

Line 633: , p6_a1 out nocopy JTF_NUMBER_TABLE

629: , p5_a6 in out nocopy NUMBER
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

Line 636: , p6_a4 out nocopy JTF_NUMBER_TABLE

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
640: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 638: , p6_a6 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
640: , p6_a8 out nocopy JTF_NUMBER_TABLE
641: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_300
642: , p6_a10 out nocopy JTF_NUMBER_TABLE

Line 640: , p6_a8 out nocopy JTF_NUMBER_TABLE

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
640: , p6_a8 out nocopy JTF_NUMBER_TABLE
641: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_300
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

Line 642: , p6_a10 out nocopy JTF_NUMBER_TABLE

638: , p6_a6 out nocopy JTF_NUMBER_TABLE
639: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
640: , p6_a8 out nocopy JTF_NUMBER_TABLE
641: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_300
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

Line 647: , p6_a15 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
651: , p6_a19 out nocopy JTF_NUMBER_TABLE

Line 648: , p6_a16 out nocopy JTF_NUMBER_TABLE

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
651: , p6_a19 out nocopy JTF_NUMBER_TABLE
652: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_300

Line 651: , p6_a19 out nocopy JTF_NUMBER_TABLE

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
654: , p6_a22 out nocopy JTF_NUMBER_TABLE
655: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100

Line 654: , p6_a22 out nocopy JTF_NUMBER_TABLE

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
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

Line 660: , p7_a0 out nocopy JTF_NUMBER_TABLE

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
664: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 661: , p7_a1 out nocopy JTF_NUMBER_TABLE

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
664: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
665: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 667: , p7_a7 out nocopy JTF_NUMBER_TABLE

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
671: , p7_a11 out nocopy JTF_DATE_TABLE

Line 669: , p7_a9 out nocopy JTF_NUMBER_TABLE

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
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

Line 674: , p7_a14 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
678: , p7_a18 out nocopy JTF_NUMBER_TABLE

Line 675: , p7_a15 out nocopy JTF_NUMBER_TABLE

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
678: , p7_a18 out nocopy JTF_NUMBER_TABLE
679: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_300

Line 678: , p7_a18 out nocopy JTF_NUMBER_TABLE

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
681: , p7_a21 out nocopy JTF_NUMBER_TABLE
682: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100

Line 681: , p7_a21 out nocopy JTF_NUMBER_TABLE

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
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