APPS.AHL_UA_UNIT_SCHEDULES_PVT_W dependencies on JTF_NUMBER_TABLE

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

1: package body ahl_ua_unit_schedules_pvt_w as
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

Line 4: , a1 JTF_NUMBER_TABLE

1: package body ahl_ua_unit_schedules_pvt_w as
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

Line 5: , a2 JTF_NUMBER_TABLE

1: package body ahl_ua_unit_schedules_pvt_w as
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

Line 7: , a4 JTF_NUMBER_TABLE

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

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

28: end loop;
29: end if;
30: end if;
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

Line 33: , a1 out nocopy JTF_NUMBER_TABLE

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

Line 34: , a2 out nocopy JTF_NUMBER_TABLE

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

Line 36: , a4 out nocopy JTF_NUMBER_TABLE

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

Line 42: a0 := JTF_NUMBER_TABLE();

38: ) as
39: ddindx binary_integer; indx binary_integer;
40: begin
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();

Line 43: a1 := JTF_NUMBER_TABLE();

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

Line 44: a2 := JTF_NUMBER_TABLE();

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

Line 46: a4 := JTF_NUMBER_TABLE();

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

Line 49: a0 := 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();
52: a3 := JTF_VARCHAR2_TABLE_100();
53: a4 := JTF_NUMBER_TABLE();

Line 50: a1 := JTF_NUMBER_TABLE();

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();
52: a3 := JTF_VARCHAR2_TABLE_100();
53: a4 := JTF_NUMBER_TABLE();
54: a5 := JTF_VARCHAR2_TABLE_100();

Line 51: a2 := 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();
52: a3 := JTF_VARCHAR2_TABLE_100();
53: a4 := JTF_NUMBER_TABLE();
54: a5 := JTF_VARCHAR2_TABLE_100();
55: if t.count > 0 then

Line 53: a4 := JTF_NUMBER_TABLE();

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

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

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

Line 82: , a1 JTF_NUMBER_TABLE

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

Line 85: , a4 JTF_NUMBER_TABLE

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

Line 87: , a6 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
89: , a8 JTF_NUMBER_TABLE
90: , a9 JTF_VARCHAR2_TABLE_300
91: , a10 JTF_NUMBER_TABLE

Line 89: , a8 JTF_NUMBER_TABLE

85: , a4 JTF_NUMBER_TABLE
86: , a5 JTF_VARCHAR2_TABLE_300
87: , a6 JTF_NUMBER_TABLE
88: , a7 JTF_VARCHAR2_TABLE_300
89: , a8 JTF_NUMBER_TABLE
90: , a9 JTF_VARCHAR2_TABLE_300
91: , a10 JTF_NUMBER_TABLE
92: , a11 JTF_VARCHAR2_TABLE_300
93: , a12 JTF_DATE_TABLE

Line 91: , a10 JTF_NUMBER_TABLE

87: , a6 JTF_NUMBER_TABLE
88: , a7 JTF_VARCHAR2_TABLE_300
89: , a8 JTF_NUMBER_TABLE
90: , a9 JTF_VARCHAR2_TABLE_300
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

Line 96: , a15 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
100: , a19 JTF_NUMBER_TABLE

Line 97: , a16 JTF_NUMBER_TABLE

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
100: , a19 JTF_NUMBER_TABLE
101: , a20 JTF_VARCHAR2_TABLE_300

Line 100: , a19 JTF_NUMBER_TABLE

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
103: , a22 JTF_NUMBER_TABLE
104: , a23 JTF_VARCHAR2_TABLE_100

Line 103: , a22 JTF_NUMBER_TABLE

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

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

150: end loop;
151: end if;
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

Line 155: , a1 out nocopy JTF_NUMBER_TABLE

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

Line 158: , a4 out nocopy JTF_NUMBER_TABLE

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

Line 160: , a6 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
162: , a8 out nocopy JTF_NUMBER_TABLE
163: , a9 out nocopy JTF_VARCHAR2_TABLE_300
164: , a10 out nocopy JTF_NUMBER_TABLE

Line 162: , a8 out nocopy JTF_NUMBER_TABLE

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
162: , a8 out nocopy JTF_NUMBER_TABLE
163: , a9 out nocopy JTF_VARCHAR2_TABLE_300
164: , a10 out nocopy JTF_NUMBER_TABLE
165: , a11 out nocopy JTF_VARCHAR2_TABLE_300
166: , a12 out nocopy JTF_DATE_TABLE

Line 164: , a10 out nocopy JTF_NUMBER_TABLE

160: , a6 out nocopy JTF_NUMBER_TABLE
161: , a7 out nocopy JTF_VARCHAR2_TABLE_300
162: , a8 out nocopy JTF_NUMBER_TABLE
163: , a9 out nocopy JTF_VARCHAR2_TABLE_300
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

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

Line 170: , a16 out nocopy JTF_NUMBER_TABLE

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

Line 173: , a19 out nocopy JTF_NUMBER_TABLE

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

Line 176: , a22 out nocopy JTF_NUMBER_TABLE

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

Line 186: a0 := JTF_NUMBER_TABLE();

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

Line 187: a1 := JTF_NUMBER_TABLE();

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

Line 190: a4 := JTF_NUMBER_TABLE();

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

Line 192: a6 := 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();
194: a8 := JTF_NUMBER_TABLE();
195: a9 := JTF_VARCHAR2_TABLE_300();
196: a10 := JTF_NUMBER_TABLE();

Line 194: a8 := JTF_NUMBER_TABLE();

190: a4 := JTF_NUMBER_TABLE();
191: a5 := JTF_VARCHAR2_TABLE_300();
192: a6 := JTF_NUMBER_TABLE();
193: a7 := JTF_VARCHAR2_TABLE_300();
194: a8 := JTF_NUMBER_TABLE();
195: a9 := JTF_VARCHAR2_TABLE_300();
196: a10 := JTF_NUMBER_TABLE();
197: a11 := JTF_VARCHAR2_TABLE_300();
198: a12 := JTF_DATE_TABLE();

Line 196: a10 := JTF_NUMBER_TABLE();

192: a6 := JTF_NUMBER_TABLE();
193: a7 := JTF_VARCHAR2_TABLE_300();
194: a8 := JTF_NUMBER_TABLE();
195: a9 := JTF_VARCHAR2_TABLE_300();
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();

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

Line 202: a16 := JTF_NUMBER_TABLE();

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

Line 205: a19 := JTF_NUMBER_TABLE();

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

Line 208: a22 := JTF_NUMBER_TABLE();

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

Line 215: a0 := JTF_NUMBER_TABLE();

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

Line 216: a1 := JTF_NUMBER_TABLE();

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();
218: a3 := JTF_VARCHAR2_TABLE_100();
219: a4 := JTF_NUMBER_TABLE();
220: a5 := JTF_VARCHAR2_TABLE_300();

Line 219: a4 := JTF_NUMBER_TABLE();

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

Line 221: a6 := 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();
223: a8 := JTF_NUMBER_TABLE();
224: a9 := JTF_VARCHAR2_TABLE_300();
225: a10 := JTF_NUMBER_TABLE();

Line 223: a8 := JTF_NUMBER_TABLE();

219: a4 := JTF_NUMBER_TABLE();
220: a5 := JTF_VARCHAR2_TABLE_300();
221: a6 := JTF_NUMBER_TABLE();
222: a7 := JTF_VARCHAR2_TABLE_300();
223: a8 := JTF_NUMBER_TABLE();
224: a9 := JTF_VARCHAR2_TABLE_300();
225: a10 := JTF_NUMBER_TABLE();
226: a11 := JTF_VARCHAR2_TABLE_300();
227: a12 := JTF_DATE_TABLE();

Line 225: a10 := JTF_NUMBER_TABLE();

221: a6 := JTF_NUMBER_TABLE();
222: a7 := JTF_VARCHAR2_TABLE_300();
223: a8 := JTF_NUMBER_TABLE();
224: a9 := JTF_VARCHAR2_TABLE_300();
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();

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

Line 231: a16 := JTF_NUMBER_TABLE();

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

Line 234: a19 := JTF_NUMBER_TABLE();

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

Line 237: a22 := JTF_NUMBER_TABLE();

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

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

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

Line 314: , a1 JTF_NUMBER_TABLE

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

Line 320: , a7 JTF_NUMBER_TABLE

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

Line 322: , a9 JTF_NUMBER_TABLE

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
324: , a11 JTF_DATE_TABLE
325: , a12 JTF_DATE_TABLE
326: , a13 JTF_VARCHAR2_TABLE_100

Line 327: , a14 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
331: , a18 JTF_NUMBER_TABLE

Line 328: , a15 JTF_NUMBER_TABLE

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
331: , a18 JTF_NUMBER_TABLE
332: , a19 JTF_VARCHAR2_TABLE_300

Line 331: , a18 JTF_NUMBER_TABLE

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
334: , a21 JTF_NUMBER_TABLE
335: , a22 JTF_VARCHAR2_TABLE_100

Line 334: , a21 JTF_NUMBER_TABLE

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

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

382: end loop;
383: end if;
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

Line 387: , a1 out nocopy JTF_NUMBER_TABLE

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

Line 393: , a7 out nocopy JTF_NUMBER_TABLE

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

Line 395: , a9 out nocopy JTF_NUMBER_TABLE

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
397: , a11 out nocopy JTF_DATE_TABLE
398: , a12 out nocopy JTF_DATE_TABLE
399: , a13 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 401: , a15 out nocopy JTF_NUMBER_TABLE

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

Line 404: , a18 out nocopy JTF_NUMBER_TABLE

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

Line 407: , a21 out nocopy JTF_NUMBER_TABLE

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

Line 418: a0 := JTF_NUMBER_TABLE();

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

Line 419: a1 := JTF_NUMBER_TABLE();

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

Line 425: a7 := JTF_NUMBER_TABLE();

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

Line 427: a9 := JTF_NUMBER_TABLE();

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();
429: a11 := JTF_DATE_TABLE();
430: a12 := JTF_DATE_TABLE();
431: a13 := JTF_VARCHAR2_TABLE_100();

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

Line 433: a15 := JTF_NUMBER_TABLE();

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

Line 436: a18 := JTF_NUMBER_TABLE();

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

Line 439: a21 := JTF_NUMBER_TABLE();

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

Line 447: a0 := JTF_NUMBER_TABLE();

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

Line 448: a1 := JTF_NUMBER_TABLE();

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();
450: a3 := JTF_VARCHAR2_TABLE_100();
451: a4 := JTF_VARCHAR2_TABLE_100();
452: a5 := JTF_VARCHAR2_TABLE_100();

Line 454: a7 := JTF_NUMBER_TABLE();

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

Line 456: a9 := JTF_NUMBER_TABLE();

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();
458: a11 := JTF_DATE_TABLE();
459: a12 := JTF_DATE_TABLE();
460: a13 := JTF_VARCHAR2_TABLE_100();

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

Line 462: a15 := JTF_NUMBER_TABLE();

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

Line 465: a18 := JTF_NUMBER_TABLE();

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

Line 468: a21 := JTF_NUMBER_TABLE();

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

Line 555: , p5_a0 out nocopy JTF_NUMBER_TABLE

551: , p4_a2 VARCHAR2
552: , p4_a3 DATE
553: , p4_a4 NUMBER
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

Line 556: , p5_a1 out nocopy JTF_NUMBER_TABLE

552: , p4_a3 DATE
553: , p4_a4 NUMBER
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

Line 557: , p5_a2 out nocopy JTF_NUMBER_TABLE

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

Line 559: , p5_a4 out nocopy JTF_NUMBER_TABLE

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

Line 619: , p6_a0 out nocopy JTF_NUMBER_TABLE

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

Line 620: , p6_a1 out nocopy JTF_NUMBER_TABLE

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

Line 623: , p6_a4 out nocopy JTF_NUMBER_TABLE

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

Line 625: , p6_a6 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
627: , p6_a8 out nocopy JTF_NUMBER_TABLE
628: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_300
629: , p6_a10 out nocopy JTF_NUMBER_TABLE

Line 627: , p6_a8 out nocopy JTF_NUMBER_TABLE

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

Line 629: , p6_a10 out nocopy JTF_NUMBER_TABLE

625: , p6_a6 out nocopy JTF_NUMBER_TABLE
626: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
627: , p6_a8 out nocopy JTF_NUMBER_TABLE
628: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_300
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

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

Line 635: , p6_a16 out nocopy JTF_NUMBER_TABLE

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

Line 638: , p6_a19 out nocopy JTF_NUMBER_TABLE

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

Line 641: , p6_a22 out nocopy JTF_NUMBER_TABLE

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

Line 647: , p7_a0 out nocopy JTF_NUMBER_TABLE

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

Line 648: , p7_a1 out nocopy JTF_NUMBER_TABLE

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
651: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
652: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 654: , p7_a7 out nocopy JTF_NUMBER_TABLE

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

Line 656: , p7_a9 out nocopy JTF_NUMBER_TABLE

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

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

Line 662: , p7_a15 out nocopy JTF_NUMBER_TABLE

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

Line 665: , p7_a18 out nocopy JTF_NUMBER_TABLE

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

Line 668: , p7_a21 out nocopy JTF_NUMBER_TABLE

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