1: package body ahl_amp_workbench_pvt_w as
2: /* $Header: AHLWAMPB.pls 120.0.12020000.2 2012/12/11 05:48:04 prakkum noship $ */
3: procedure rosetta_table_copy_in_p6(t out nocopy ahl_amp_workbench_pvt.sch_graph_results_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
1: package body ahl_amp_workbench_pvt_w as
2: /* $Header: AHLWAMPB.pls 120.0.12020000.2 2012/12/11 05:48:04 prakkum noship $ */
3: procedure rosetta_table_copy_in_p6(t out nocopy ahl_amp_workbench_pvt.sch_graph_results_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
2: /* $Header: AHLWAMPB.pls 120.0.12020000.2 2012/12/11 05:48:04 prakkum noship $ */
3: procedure rosetta_table_copy_in_p6(t out nocopy ahl_amp_workbench_pvt.sch_graph_results_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_300
10: , a7 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_300
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_300
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_DATE_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_DATE_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_DATE_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_DATE_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_DATE_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_DATE_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_DATE_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_DATE_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_DATE_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_DATE_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_DATE_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_DATE_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_DATE_TABLE
39: , a36 JTF_NUMBER_TABLE
40: , a37 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_DATE_TABLE
39: , a36 JTF_NUMBER_TABLE
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_DATE_TABLE
42: , a39 JTF_NUMBER_TABLE
43: , a40 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_DATE_TABLE
39: , a36 JTF_NUMBER_TABLE
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_DATE_TABLE
42: , a39 JTF_NUMBER_TABLE
43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_DATE_TABLE
45: , a42 JTF_NUMBER_TABLE
46: , a43 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_DATE_TABLE
42: , a39 JTF_NUMBER_TABLE
43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_DATE_TABLE
45: , a42 JTF_NUMBER_TABLE
46: , a43 JTF_VARCHAR2_TABLE_100
47: , a44 JTF_DATE_TABLE
48: , a45 JTF_NUMBER_TABLE
49: , a46 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_DATE_TABLE
45: , a42 JTF_NUMBER_TABLE
46: , a43 JTF_VARCHAR2_TABLE_100
47: , a44 JTF_DATE_TABLE
48: , a45 JTF_NUMBER_TABLE
49: , a46 JTF_VARCHAR2_TABLE_100
50: , a47 JTF_DATE_TABLE
51: , a48 JTF_NUMBER_TABLE
52: , a49 JTF_VARCHAR2_TABLE_100
47: , a44 JTF_DATE_TABLE
48: , a45 JTF_NUMBER_TABLE
49: , a46 JTF_VARCHAR2_TABLE_100
50: , a47 JTF_DATE_TABLE
51: , a48 JTF_NUMBER_TABLE
52: , a49 JTF_VARCHAR2_TABLE_100
53: , a50 JTF_DATE_TABLE
54: , a51 JTF_NUMBER_TABLE
55: , a52 JTF_VARCHAR2_TABLE_100
50: , a47 JTF_DATE_TABLE
51: , a48 JTF_NUMBER_TABLE
52: , a49 JTF_VARCHAR2_TABLE_100
53: , a50 JTF_DATE_TABLE
54: , a51 JTF_NUMBER_TABLE
55: , a52 JTF_VARCHAR2_TABLE_100
56: , a53 JTF_DATE_TABLE
57: , a54 JTF_NUMBER_TABLE
58: , a55 JTF_VARCHAR2_TABLE_100
53: , a50 JTF_DATE_TABLE
54: , a51 JTF_NUMBER_TABLE
55: , a52 JTF_VARCHAR2_TABLE_100
56: , a53 JTF_DATE_TABLE
57: , a54 JTF_NUMBER_TABLE
58: , a55 JTF_VARCHAR2_TABLE_100
59: , a56 JTF_DATE_TABLE
60: , a57 JTF_NUMBER_TABLE
61: , a58 JTF_VARCHAR2_TABLE_100
56: , a53 JTF_DATE_TABLE
57: , a54 JTF_NUMBER_TABLE
58: , a55 JTF_VARCHAR2_TABLE_100
59: , a56 JTF_DATE_TABLE
60: , a57 JTF_NUMBER_TABLE
61: , a58 JTF_VARCHAR2_TABLE_100
62: , a59 JTF_DATE_TABLE
63: , a60 JTF_NUMBER_TABLE
64: , a61 JTF_VARCHAR2_TABLE_100
59: , a56 JTF_DATE_TABLE
60: , a57 JTF_NUMBER_TABLE
61: , a58 JTF_VARCHAR2_TABLE_100
62: , a59 JTF_DATE_TABLE
63: , a60 JTF_NUMBER_TABLE
64: , a61 JTF_VARCHAR2_TABLE_100
65: , a62 JTF_DATE_TABLE
66: , a63 JTF_NUMBER_TABLE
67: , a64 JTF_VARCHAR2_TABLE_100
62: , a59 JTF_DATE_TABLE
63: , a60 JTF_NUMBER_TABLE
64: , a61 JTF_VARCHAR2_TABLE_100
65: , a62 JTF_DATE_TABLE
66: , a63 JTF_NUMBER_TABLE
67: , a64 JTF_VARCHAR2_TABLE_100
68: , a65 JTF_DATE_TABLE
69: , a66 JTF_NUMBER_TABLE
70: , a67 JTF_VARCHAR2_TABLE_100
65: , a62 JTF_DATE_TABLE
66: , a63 JTF_NUMBER_TABLE
67: , a64 JTF_VARCHAR2_TABLE_100
68: , a65 JTF_DATE_TABLE
69: , a66 JTF_NUMBER_TABLE
70: , a67 JTF_VARCHAR2_TABLE_100
71: , a68 JTF_DATE_TABLE
72: , a69 JTF_NUMBER_TABLE
73: , a70 JTF_NUMBER_TABLE
68: , a65 JTF_DATE_TABLE
69: , a66 JTF_NUMBER_TABLE
70: , a67 JTF_VARCHAR2_TABLE_100
71: , a68 JTF_DATE_TABLE
72: , a69 JTF_NUMBER_TABLE
73: , a70 JTF_NUMBER_TABLE
74: ) as
75: ddindx binary_integer; indx binary_integer;
76: begin
69: , a66 JTF_NUMBER_TABLE
70: , a67 JTF_VARCHAR2_TABLE_100
71: , a68 JTF_DATE_TABLE
72: , a69 JTF_NUMBER_TABLE
73: , a70 JTF_NUMBER_TABLE
74: ) as
75: ddindx binary_integer; indx binary_integer;
76: begin
77: if a0 is not null and a0.count > 0 then
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_amp_workbench_pvt.sch_graph_results_tbl, a0 out nocopy JTF_NUMBER_TABLE
168: , a1 out nocopy JTF_NUMBER_TABLE
169: , a2 out nocopy JTF_VARCHAR2_TABLE_300
170: , a3 out nocopy JTF_NUMBER_TABLE
171: , a4 out nocopy JTF_VARCHAR2_TABLE_100
164: end if;
165: end if;
166: end rosetta_table_copy_in_p6;
167: procedure rosetta_table_copy_out_p6(t ahl_amp_workbench_pvt.sch_graph_results_tbl, a0 out nocopy JTF_NUMBER_TABLE
168: , a1 out nocopy JTF_NUMBER_TABLE
169: , a2 out nocopy JTF_VARCHAR2_TABLE_300
170: , a3 out nocopy JTF_NUMBER_TABLE
171: , a4 out nocopy JTF_VARCHAR2_TABLE_100
172: , a5 out nocopy JTF_NUMBER_TABLE
166: end rosetta_table_copy_in_p6;
167: procedure rosetta_table_copy_out_p6(t ahl_amp_workbench_pvt.sch_graph_results_tbl, a0 out nocopy JTF_NUMBER_TABLE
168: , a1 out nocopy JTF_NUMBER_TABLE
169: , a2 out nocopy JTF_VARCHAR2_TABLE_300
170: , a3 out nocopy JTF_NUMBER_TABLE
171: , a4 out nocopy JTF_VARCHAR2_TABLE_100
172: , a5 out nocopy JTF_NUMBER_TABLE
173: , a6 out nocopy JTF_VARCHAR2_TABLE_300
174: , a7 out nocopy JTF_VARCHAR2_TABLE_100
168: , a1 out nocopy JTF_NUMBER_TABLE
169: , a2 out nocopy JTF_VARCHAR2_TABLE_300
170: , a3 out nocopy JTF_NUMBER_TABLE
171: , a4 out nocopy JTF_VARCHAR2_TABLE_100
172: , a5 out nocopy JTF_NUMBER_TABLE
173: , a6 out nocopy JTF_VARCHAR2_TABLE_300
174: , a7 out nocopy JTF_VARCHAR2_TABLE_100
175: , a8 out nocopy JTF_DATE_TABLE
176: , a9 out nocopy JTF_NUMBER_TABLE
172: , a5 out nocopy JTF_NUMBER_TABLE
173: , a6 out nocopy JTF_VARCHAR2_TABLE_300
174: , a7 out nocopy JTF_VARCHAR2_TABLE_100
175: , a8 out nocopy JTF_DATE_TABLE
176: , a9 out nocopy JTF_NUMBER_TABLE
177: , a10 out nocopy JTF_VARCHAR2_TABLE_100
178: , a11 out nocopy JTF_DATE_TABLE
179: , a12 out nocopy JTF_NUMBER_TABLE
180: , a13 out nocopy JTF_VARCHAR2_TABLE_100
175: , a8 out nocopy JTF_DATE_TABLE
176: , a9 out nocopy JTF_NUMBER_TABLE
177: , a10 out nocopy JTF_VARCHAR2_TABLE_100
178: , a11 out nocopy JTF_DATE_TABLE
179: , a12 out nocopy JTF_NUMBER_TABLE
180: , a13 out nocopy JTF_VARCHAR2_TABLE_100
181: , a14 out nocopy JTF_DATE_TABLE
182: , a15 out nocopy JTF_NUMBER_TABLE
183: , a16 out nocopy JTF_VARCHAR2_TABLE_100
178: , a11 out nocopy JTF_DATE_TABLE
179: , a12 out nocopy JTF_NUMBER_TABLE
180: , a13 out nocopy JTF_VARCHAR2_TABLE_100
181: , a14 out nocopy JTF_DATE_TABLE
182: , a15 out nocopy JTF_NUMBER_TABLE
183: , a16 out nocopy JTF_VARCHAR2_TABLE_100
184: , a17 out nocopy JTF_DATE_TABLE
185: , a18 out nocopy JTF_NUMBER_TABLE
186: , a19 out nocopy JTF_VARCHAR2_TABLE_100
181: , a14 out nocopy JTF_DATE_TABLE
182: , a15 out nocopy JTF_NUMBER_TABLE
183: , a16 out nocopy JTF_VARCHAR2_TABLE_100
184: , a17 out nocopy JTF_DATE_TABLE
185: , a18 out nocopy JTF_NUMBER_TABLE
186: , a19 out nocopy JTF_VARCHAR2_TABLE_100
187: , a20 out nocopy JTF_DATE_TABLE
188: , a21 out nocopy JTF_NUMBER_TABLE
189: , a22 out nocopy JTF_VARCHAR2_TABLE_100
184: , a17 out nocopy JTF_DATE_TABLE
185: , a18 out nocopy JTF_NUMBER_TABLE
186: , a19 out nocopy JTF_VARCHAR2_TABLE_100
187: , a20 out nocopy JTF_DATE_TABLE
188: , a21 out nocopy JTF_NUMBER_TABLE
189: , a22 out nocopy JTF_VARCHAR2_TABLE_100
190: , a23 out nocopy JTF_DATE_TABLE
191: , a24 out nocopy JTF_NUMBER_TABLE
192: , a25 out nocopy JTF_VARCHAR2_TABLE_100
187: , a20 out nocopy JTF_DATE_TABLE
188: , a21 out nocopy JTF_NUMBER_TABLE
189: , a22 out nocopy JTF_VARCHAR2_TABLE_100
190: , a23 out nocopy JTF_DATE_TABLE
191: , a24 out nocopy JTF_NUMBER_TABLE
192: , a25 out nocopy JTF_VARCHAR2_TABLE_100
193: , a26 out nocopy JTF_DATE_TABLE
194: , a27 out nocopy JTF_NUMBER_TABLE
195: , a28 out nocopy JTF_VARCHAR2_TABLE_100
190: , a23 out nocopy JTF_DATE_TABLE
191: , a24 out nocopy JTF_NUMBER_TABLE
192: , a25 out nocopy JTF_VARCHAR2_TABLE_100
193: , a26 out nocopy JTF_DATE_TABLE
194: , a27 out nocopy JTF_NUMBER_TABLE
195: , a28 out nocopy JTF_VARCHAR2_TABLE_100
196: , a29 out nocopy JTF_DATE_TABLE
197: , a30 out nocopy JTF_NUMBER_TABLE
198: , a31 out nocopy JTF_VARCHAR2_TABLE_100
193: , a26 out nocopy JTF_DATE_TABLE
194: , a27 out nocopy JTF_NUMBER_TABLE
195: , a28 out nocopy JTF_VARCHAR2_TABLE_100
196: , a29 out nocopy JTF_DATE_TABLE
197: , a30 out nocopy JTF_NUMBER_TABLE
198: , a31 out nocopy JTF_VARCHAR2_TABLE_100
199: , a32 out nocopy JTF_DATE_TABLE
200: , a33 out nocopy JTF_NUMBER_TABLE
201: , a34 out nocopy JTF_VARCHAR2_TABLE_100
196: , a29 out nocopy JTF_DATE_TABLE
197: , a30 out nocopy JTF_NUMBER_TABLE
198: , a31 out nocopy JTF_VARCHAR2_TABLE_100
199: , a32 out nocopy JTF_DATE_TABLE
200: , a33 out nocopy JTF_NUMBER_TABLE
201: , a34 out nocopy JTF_VARCHAR2_TABLE_100
202: , a35 out nocopy JTF_DATE_TABLE
203: , a36 out nocopy JTF_NUMBER_TABLE
204: , a37 out nocopy JTF_VARCHAR2_TABLE_100
199: , a32 out nocopy JTF_DATE_TABLE
200: , a33 out nocopy JTF_NUMBER_TABLE
201: , a34 out nocopy JTF_VARCHAR2_TABLE_100
202: , a35 out nocopy JTF_DATE_TABLE
203: , a36 out nocopy JTF_NUMBER_TABLE
204: , a37 out nocopy JTF_VARCHAR2_TABLE_100
205: , a38 out nocopy JTF_DATE_TABLE
206: , a39 out nocopy JTF_NUMBER_TABLE
207: , a40 out nocopy JTF_VARCHAR2_TABLE_100
202: , a35 out nocopy JTF_DATE_TABLE
203: , a36 out nocopy JTF_NUMBER_TABLE
204: , a37 out nocopy JTF_VARCHAR2_TABLE_100
205: , a38 out nocopy JTF_DATE_TABLE
206: , a39 out nocopy JTF_NUMBER_TABLE
207: , a40 out nocopy JTF_VARCHAR2_TABLE_100
208: , a41 out nocopy JTF_DATE_TABLE
209: , a42 out nocopy JTF_NUMBER_TABLE
210: , a43 out nocopy JTF_VARCHAR2_TABLE_100
205: , a38 out nocopy JTF_DATE_TABLE
206: , a39 out nocopy JTF_NUMBER_TABLE
207: , a40 out nocopy JTF_VARCHAR2_TABLE_100
208: , a41 out nocopy JTF_DATE_TABLE
209: , a42 out nocopy JTF_NUMBER_TABLE
210: , a43 out nocopy JTF_VARCHAR2_TABLE_100
211: , a44 out nocopy JTF_DATE_TABLE
212: , a45 out nocopy JTF_NUMBER_TABLE
213: , a46 out nocopy JTF_VARCHAR2_TABLE_100
208: , a41 out nocopy JTF_DATE_TABLE
209: , a42 out nocopy JTF_NUMBER_TABLE
210: , a43 out nocopy JTF_VARCHAR2_TABLE_100
211: , a44 out nocopy JTF_DATE_TABLE
212: , a45 out nocopy JTF_NUMBER_TABLE
213: , a46 out nocopy JTF_VARCHAR2_TABLE_100
214: , a47 out nocopy JTF_DATE_TABLE
215: , a48 out nocopy JTF_NUMBER_TABLE
216: , a49 out nocopy JTF_VARCHAR2_TABLE_100
211: , a44 out nocopy JTF_DATE_TABLE
212: , a45 out nocopy JTF_NUMBER_TABLE
213: , a46 out nocopy JTF_VARCHAR2_TABLE_100
214: , a47 out nocopy JTF_DATE_TABLE
215: , a48 out nocopy JTF_NUMBER_TABLE
216: , a49 out nocopy JTF_VARCHAR2_TABLE_100
217: , a50 out nocopy JTF_DATE_TABLE
218: , a51 out nocopy JTF_NUMBER_TABLE
219: , a52 out nocopy JTF_VARCHAR2_TABLE_100
214: , a47 out nocopy JTF_DATE_TABLE
215: , a48 out nocopy JTF_NUMBER_TABLE
216: , a49 out nocopy JTF_VARCHAR2_TABLE_100
217: , a50 out nocopy JTF_DATE_TABLE
218: , a51 out nocopy JTF_NUMBER_TABLE
219: , a52 out nocopy JTF_VARCHAR2_TABLE_100
220: , a53 out nocopy JTF_DATE_TABLE
221: , a54 out nocopy JTF_NUMBER_TABLE
222: , a55 out nocopy JTF_VARCHAR2_TABLE_100
217: , a50 out nocopy JTF_DATE_TABLE
218: , a51 out nocopy JTF_NUMBER_TABLE
219: , a52 out nocopy JTF_VARCHAR2_TABLE_100
220: , a53 out nocopy JTF_DATE_TABLE
221: , a54 out nocopy JTF_NUMBER_TABLE
222: , a55 out nocopy JTF_VARCHAR2_TABLE_100
223: , a56 out nocopy JTF_DATE_TABLE
224: , a57 out nocopy JTF_NUMBER_TABLE
225: , a58 out nocopy JTF_VARCHAR2_TABLE_100
220: , a53 out nocopy JTF_DATE_TABLE
221: , a54 out nocopy JTF_NUMBER_TABLE
222: , a55 out nocopy JTF_VARCHAR2_TABLE_100
223: , a56 out nocopy JTF_DATE_TABLE
224: , a57 out nocopy JTF_NUMBER_TABLE
225: , a58 out nocopy JTF_VARCHAR2_TABLE_100
226: , a59 out nocopy JTF_DATE_TABLE
227: , a60 out nocopy JTF_NUMBER_TABLE
228: , a61 out nocopy JTF_VARCHAR2_TABLE_100
223: , a56 out nocopy JTF_DATE_TABLE
224: , a57 out nocopy JTF_NUMBER_TABLE
225: , a58 out nocopy JTF_VARCHAR2_TABLE_100
226: , a59 out nocopy JTF_DATE_TABLE
227: , a60 out nocopy JTF_NUMBER_TABLE
228: , a61 out nocopy JTF_VARCHAR2_TABLE_100
229: , a62 out nocopy JTF_DATE_TABLE
230: , a63 out nocopy JTF_NUMBER_TABLE
231: , a64 out nocopy JTF_VARCHAR2_TABLE_100
226: , a59 out nocopy JTF_DATE_TABLE
227: , a60 out nocopy JTF_NUMBER_TABLE
228: , a61 out nocopy JTF_VARCHAR2_TABLE_100
229: , a62 out nocopy JTF_DATE_TABLE
230: , a63 out nocopy JTF_NUMBER_TABLE
231: , a64 out nocopy JTF_VARCHAR2_TABLE_100
232: , a65 out nocopy JTF_DATE_TABLE
233: , a66 out nocopy JTF_NUMBER_TABLE
234: , a67 out nocopy JTF_VARCHAR2_TABLE_100
229: , a62 out nocopy JTF_DATE_TABLE
230: , a63 out nocopy JTF_NUMBER_TABLE
231: , a64 out nocopy JTF_VARCHAR2_TABLE_100
232: , a65 out nocopy JTF_DATE_TABLE
233: , a66 out nocopy JTF_NUMBER_TABLE
234: , a67 out nocopy JTF_VARCHAR2_TABLE_100
235: , a68 out nocopy JTF_DATE_TABLE
236: , a69 out nocopy JTF_NUMBER_TABLE
237: , a70 out nocopy JTF_NUMBER_TABLE
232: , a65 out nocopy JTF_DATE_TABLE
233: , a66 out nocopy JTF_NUMBER_TABLE
234: , a67 out nocopy JTF_VARCHAR2_TABLE_100
235: , a68 out nocopy JTF_DATE_TABLE
236: , a69 out nocopy JTF_NUMBER_TABLE
237: , a70 out nocopy JTF_NUMBER_TABLE
238: ) as
239: ddindx binary_integer; indx binary_integer;
240: begin
233: , a66 out nocopy JTF_NUMBER_TABLE
234: , a67 out nocopy JTF_VARCHAR2_TABLE_100
235: , a68 out nocopy JTF_DATE_TABLE
236: , a69 out nocopy JTF_NUMBER_TABLE
237: , a70 out nocopy JTF_NUMBER_TABLE
238: ) as
239: ddindx binary_integer; indx binary_integer;
240: begin
241: if t is null or t.count = 0 then
238: ) as
239: ddindx binary_integer; indx binary_integer;
240: begin
241: if t is null or t.count = 0 then
242: a0 := JTF_NUMBER_TABLE();
243: a1 := JTF_NUMBER_TABLE();
244: a2 := JTF_VARCHAR2_TABLE_300();
245: a3 := JTF_NUMBER_TABLE();
246: a4 := JTF_VARCHAR2_TABLE_100();
239: ddindx binary_integer; indx binary_integer;
240: begin
241: if t is null or t.count = 0 then
242: a0 := JTF_NUMBER_TABLE();
243: a1 := JTF_NUMBER_TABLE();
244: a2 := JTF_VARCHAR2_TABLE_300();
245: a3 := JTF_NUMBER_TABLE();
246: a4 := JTF_VARCHAR2_TABLE_100();
247: a5 := JTF_NUMBER_TABLE();
241: if t is null or t.count = 0 then
242: a0 := JTF_NUMBER_TABLE();
243: a1 := JTF_NUMBER_TABLE();
244: a2 := JTF_VARCHAR2_TABLE_300();
245: a3 := JTF_NUMBER_TABLE();
246: a4 := JTF_VARCHAR2_TABLE_100();
247: a5 := JTF_NUMBER_TABLE();
248: a6 := JTF_VARCHAR2_TABLE_300();
249: a7 := JTF_VARCHAR2_TABLE_100();
243: a1 := JTF_NUMBER_TABLE();
244: a2 := JTF_VARCHAR2_TABLE_300();
245: a3 := JTF_NUMBER_TABLE();
246: a4 := JTF_VARCHAR2_TABLE_100();
247: a5 := JTF_NUMBER_TABLE();
248: a6 := JTF_VARCHAR2_TABLE_300();
249: a7 := JTF_VARCHAR2_TABLE_100();
250: a8 := JTF_DATE_TABLE();
251: a9 := JTF_NUMBER_TABLE();
247: a5 := JTF_NUMBER_TABLE();
248: a6 := JTF_VARCHAR2_TABLE_300();
249: a7 := JTF_VARCHAR2_TABLE_100();
250: a8 := JTF_DATE_TABLE();
251: a9 := JTF_NUMBER_TABLE();
252: a10 := JTF_VARCHAR2_TABLE_100();
253: a11 := JTF_DATE_TABLE();
254: a12 := JTF_NUMBER_TABLE();
255: a13 := JTF_VARCHAR2_TABLE_100();
250: a8 := JTF_DATE_TABLE();
251: a9 := JTF_NUMBER_TABLE();
252: a10 := JTF_VARCHAR2_TABLE_100();
253: a11 := JTF_DATE_TABLE();
254: a12 := JTF_NUMBER_TABLE();
255: a13 := JTF_VARCHAR2_TABLE_100();
256: a14 := JTF_DATE_TABLE();
257: a15 := JTF_NUMBER_TABLE();
258: a16 := JTF_VARCHAR2_TABLE_100();
253: a11 := JTF_DATE_TABLE();
254: a12 := JTF_NUMBER_TABLE();
255: a13 := JTF_VARCHAR2_TABLE_100();
256: a14 := JTF_DATE_TABLE();
257: a15 := JTF_NUMBER_TABLE();
258: a16 := JTF_VARCHAR2_TABLE_100();
259: a17 := JTF_DATE_TABLE();
260: a18 := JTF_NUMBER_TABLE();
261: a19 := JTF_VARCHAR2_TABLE_100();
256: a14 := JTF_DATE_TABLE();
257: a15 := JTF_NUMBER_TABLE();
258: a16 := JTF_VARCHAR2_TABLE_100();
259: a17 := JTF_DATE_TABLE();
260: a18 := JTF_NUMBER_TABLE();
261: a19 := JTF_VARCHAR2_TABLE_100();
262: a20 := JTF_DATE_TABLE();
263: a21 := JTF_NUMBER_TABLE();
264: a22 := JTF_VARCHAR2_TABLE_100();
259: a17 := JTF_DATE_TABLE();
260: a18 := JTF_NUMBER_TABLE();
261: a19 := JTF_VARCHAR2_TABLE_100();
262: a20 := JTF_DATE_TABLE();
263: a21 := JTF_NUMBER_TABLE();
264: a22 := JTF_VARCHAR2_TABLE_100();
265: a23 := JTF_DATE_TABLE();
266: a24 := JTF_NUMBER_TABLE();
267: a25 := JTF_VARCHAR2_TABLE_100();
262: a20 := JTF_DATE_TABLE();
263: a21 := JTF_NUMBER_TABLE();
264: a22 := JTF_VARCHAR2_TABLE_100();
265: a23 := JTF_DATE_TABLE();
266: a24 := JTF_NUMBER_TABLE();
267: a25 := JTF_VARCHAR2_TABLE_100();
268: a26 := JTF_DATE_TABLE();
269: a27 := JTF_NUMBER_TABLE();
270: a28 := JTF_VARCHAR2_TABLE_100();
265: a23 := JTF_DATE_TABLE();
266: a24 := JTF_NUMBER_TABLE();
267: a25 := JTF_VARCHAR2_TABLE_100();
268: a26 := JTF_DATE_TABLE();
269: a27 := JTF_NUMBER_TABLE();
270: a28 := JTF_VARCHAR2_TABLE_100();
271: a29 := JTF_DATE_TABLE();
272: a30 := JTF_NUMBER_TABLE();
273: a31 := JTF_VARCHAR2_TABLE_100();
268: a26 := JTF_DATE_TABLE();
269: a27 := JTF_NUMBER_TABLE();
270: a28 := JTF_VARCHAR2_TABLE_100();
271: a29 := JTF_DATE_TABLE();
272: a30 := JTF_NUMBER_TABLE();
273: a31 := JTF_VARCHAR2_TABLE_100();
274: a32 := JTF_DATE_TABLE();
275: a33 := JTF_NUMBER_TABLE();
276: a34 := JTF_VARCHAR2_TABLE_100();
271: a29 := JTF_DATE_TABLE();
272: a30 := JTF_NUMBER_TABLE();
273: a31 := JTF_VARCHAR2_TABLE_100();
274: a32 := JTF_DATE_TABLE();
275: a33 := JTF_NUMBER_TABLE();
276: a34 := JTF_VARCHAR2_TABLE_100();
277: a35 := JTF_DATE_TABLE();
278: a36 := JTF_NUMBER_TABLE();
279: a37 := JTF_VARCHAR2_TABLE_100();
274: a32 := JTF_DATE_TABLE();
275: a33 := JTF_NUMBER_TABLE();
276: a34 := JTF_VARCHAR2_TABLE_100();
277: a35 := JTF_DATE_TABLE();
278: a36 := JTF_NUMBER_TABLE();
279: a37 := JTF_VARCHAR2_TABLE_100();
280: a38 := JTF_DATE_TABLE();
281: a39 := JTF_NUMBER_TABLE();
282: a40 := JTF_VARCHAR2_TABLE_100();
277: a35 := JTF_DATE_TABLE();
278: a36 := JTF_NUMBER_TABLE();
279: a37 := JTF_VARCHAR2_TABLE_100();
280: a38 := JTF_DATE_TABLE();
281: a39 := JTF_NUMBER_TABLE();
282: a40 := JTF_VARCHAR2_TABLE_100();
283: a41 := JTF_DATE_TABLE();
284: a42 := JTF_NUMBER_TABLE();
285: a43 := JTF_VARCHAR2_TABLE_100();
280: a38 := JTF_DATE_TABLE();
281: a39 := JTF_NUMBER_TABLE();
282: a40 := JTF_VARCHAR2_TABLE_100();
283: a41 := JTF_DATE_TABLE();
284: a42 := JTF_NUMBER_TABLE();
285: a43 := JTF_VARCHAR2_TABLE_100();
286: a44 := JTF_DATE_TABLE();
287: a45 := JTF_NUMBER_TABLE();
288: a46 := JTF_VARCHAR2_TABLE_100();
283: a41 := JTF_DATE_TABLE();
284: a42 := JTF_NUMBER_TABLE();
285: a43 := JTF_VARCHAR2_TABLE_100();
286: a44 := JTF_DATE_TABLE();
287: a45 := JTF_NUMBER_TABLE();
288: a46 := JTF_VARCHAR2_TABLE_100();
289: a47 := JTF_DATE_TABLE();
290: a48 := JTF_NUMBER_TABLE();
291: a49 := JTF_VARCHAR2_TABLE_100();
286: a44 := JTF_DATE_TABLE();
287: a45 := JTF_NUMBER_TABLE();
288: a46 := JTF_VARCHAR2_TABLE_100();
289: a47 := JTF_DATE_TABLE();
290: a48 := JTF_NUMBER_TABLE();
291: a49 := JTF_VARCHAR2_TABLE_100();
292: a50 := JTF_DATE_TABLE();
293: a51 := JTF_NUMBER_TABLE();
294: a52 := JTF_VARCHAR2_TABLE_100();
289: a47 := JTF_DATE_TABLE();
290: a48 := JTF_NUMBER_TABLE();
291: a49 := JTF_VARCHAR2_TABLE_100();
292: a50 := JTF_DATE_TABLE();
293: a51 := JTF_NUMBER_TABLE();
294: a52 := JTF_VARCHAR2_TABLE_100();
295: a53 := JTF_DATE_TABLE();
296: a54 := JTF_NUMBER_TABLE();
297: a55 := JTF_VARCHAR2_TABLE_100();
292: a50 := JTF_DATE_TABLE();
293: a51 := JTF_NUMBER_TABLE();
294: a52 := JTF_VARCHAR2_TABLE_100();
295: a53 := JTF_DATE_TABLE();
296: a54 := JTF_NUMBER_TABLE();
297: a55 := JTF_VARCHAR2_TABLE_100();
298: a56 := JTF_DATE_TABLE();
299: a57 := JTF_NUMBER_TABLE();
300: a58 := JTF_VARCHAR2_TABLE_100();
295: a53 := JTF_DATE_TABLE();
296: a54 := JTF_NUMBER_TABLE();
297: a55 := JTF_VARCHAR2_TABLE_100();
298: a56 := JTF_DATE_TABLE();
299: a57 := JTF_NUMBER_TABLE();
300: a58 := JTF_VARCHAR2_TABLE_100();
301: a59 := JTF_DATE_TABLE();
302: a60 := JTF_NUMBER_TABLE();
303: a61 := JTF_VARCHAR2_TABLE_100();
298: a56 := JTF_DATE_TABLE();
299: a57 := JTF_NUMBER_TABLE();
300: a58 := JTF_VARCHAR2_TABLE_100();
301: a59 := JTF_DATE_TABLE();
302: a60 := JTF_NUMBER_TABLE();
303: a61 := JTF_VARCHAR2_TABLE_100();
304: a62 := JTF_DATE_TABLE();
305: a63 := JTF_NUMBER_TABLE();
306: a64 := JTF_VARCHAR2_TABLE_100();
301: a59 := JTF_DATE_TABLE();
302: a60 := JTF_NUMBER_TABLE();
303: a61 := JTF_VARCHAR2_TABLE_100();
304: a62 := JTF_DATE_TABLE();
305: a63 := JTF_NUMBER_TABLE();
306: a64 := JTF_VARCHAR2_TABLE_100();
307: a65 := JTF_DATE_TABLE();
308: a66 := JTF_NUMBER_TABLE();
309: a67 := JTF_VARCHAR2_TABLE_100();
304: a62 := JTF_DATE_TABLE();
305: a63 := JTF_NUMBER_TABLE();
306: a64 := JTF_VARCHAR2_TABLE_100();
307: a65 := JTF_DATE_TABLE();
308: a66 := JTF_NUMBER_TABLE();
309: a67 := JTF_VARCHAR2_TABLE_100();
310: a68 := JTF_DATE_TABLE();
311: a69 := JTF_NUMBER_TABLE();
312: a70 := JTF_NUMBER_TABLE();
307: a65 := JTF_DATE_TABLE();
308: a66 := JTF_NUMBER_TABLE();
309: a67 := JTF_VARCHAR2_TABLE_100();
310: a68 := JTF_DATE_TABLE();
311: a69 := JTF_NUMBER_TABLE();
312: a70 := JTF_NUMBER_TABLE();
313: else
314: a0 := JTF_NUMBER_TABLE();
315: a1 := JTF_NUMBER_TABLE();
308: a66 := JTF_NUMBER_TABLE();
309: a67 := JTF_VARCHAR2_TABLE_100();
310: a68 := JTF_DATE_TABLE();
311: a69 := JTF_NUMBER_TABLE();
312: a70 := JTF_NUMBER_TABLE();
313: else
314: a0 := JTF_NUMBER_TABLE();
315: a1 := JTF_NUMBER_TABLE();
316: a2 := JTF_VARCHAR2_TABLE_300();
310: a68 := JTF_DATE_TABLE();
311: a69 := JTF_NUMBER_TABLE();
312: a70 := JTF_NUMBER_TABLE();
313: else
314: a0 := JTF_NUMBER_TABLE();
315: a1 := JTF_NUMBER_TABLE();
316: a2 := JTF_VARCHAR2_TABLE_300();
317: a3 := JTF_NUMBER_TABLE();
318: a4 := JTF_VARCHAR2_TABLE_100();
311: a69 := JTF_NUMBER_TABLE();
312: a70 := JTF_NUMBER_TABLE();
313: else
314: a0 := JTF_NUMBER_TABLE();
315: a1 := JTF_NUMBER_TABLE();
316: a2 := JTF_VARCHAR2_TABLE_300();
317: a3 := JTF_NUMBER_TABLE();
318: a4 := JTF_VARCHAR2_TABLE_100();
319: a5 := JTF_NUMBER_TABLE();
313: else
314: a0 := JTF_NUMBER_TABLE();
315: a1 := JTF_NUMBER_TABLE();
316: a2 := JTF_VARCHAR2_TABLE_300();
317: a3 := JTF_NUMBER_TABLE();
318: a4 := JTF_VARCHAR2_TABLE_100();
319: a5 := JTF_NUMBER_TABLE();
320: a6 := JTF_VARCHAR2_TABLE_300();
321: a7 := JTF_VARCHAR2_TABLE_100();
315: a1 := JTF_NUMBER_TABLE();
316: a2 := JTF_VARCHAR2_TABLE_300();
317: a3 := JTF_NUMBER_TABLE();
318: a4 := JTF_VARCHAR2_TABLE_100();
319: a5 := JTF_NUMBER_TABLE();
320: a6 := JTF_VARCHAR2_TABLE_300();
321: a7 := JTF_VARCHAR2_TABLE_100();
322: a8 := JTF_DATE_TABLE();
323: a9 := JTF_NUMBER_TABLE();
319: a5 := JTF_NUMBER_TABLE();
320: a6 := JTF_VARCHAR2_TABLE_300();
321: a7 := JTF_VARCHAR2_TABLE_100();
322: a8 := JTF_DATE_TABLE();
323: a9 := JTF_NUMBER_TABLE();
324: a10 := JTF_VARCHAR2_TABLE_100();
325: a11 := JTF_DATE_TABLE();
326: a12 := JTF_NUMBER_TABLE();
327: a13 := JTF_VARCHAR2_TABLE_100();
322: a8 := JTF_DATE_TABLE();
323: a9 := JTF_NUMBER_TABLE();
324: a10 := JTF_VARCHAR2_TABLE_100();
325: a11 := JTF_DATE_TABLE();
326: a12 := JTF_NUMBER_TABLE();
327: a13 := JTF_VARCHAR2_TABLE_100();
328: a14 := JTF_DATE_TABLE();
329: a15 := JTF_NUMBER_TABLE();
330: a16 := JTF_VARCHAR2_TABLE_100();
325: a11 := JTF_DATE_TABLE();
326: a12 := JTF_NUMBER_TABLE();
327: a13 := JTF_VARCHAR2_TABLE_100();
328: a14 := JTF_DATE_TABLE();
329: a15 := JTF_NUMBER_TABLE();
330: a16 := JTF_VARCHAR2_TABLE_100();
331: a17 := JTF_DATE_TABLE();
332: a18 := JTF_NUMBER_TABLE();
333: a19 := JTF_VARCHAR2_TABLE_100();
328: a14 := JTF_DATE_TABLE();
329: a15 := JTF_NUMBER_TABLE();
330: a16 := JTF_VARCHAR2_TABLE_100();
331: a17 := JTF_DATE_TABLE();
332: a18 := JTF_NUMBER_TABLE();
333: a19 := JTF_VARCHAR2_TABLE_100();
334: a20 := JTF_DATE_TABLE();
335: a21 := JTF_NUMBER_TABLE();
336: a22 := JTF_VARCHAR2_TABLE_100();
331: a17 := JTF_DATE_TABLE();
332: a18 := JTF_NUMBER_TABLE();
333: a19 := JTF_VARCHAR2_TABLE_100();
334: a20 := JTF_DATE_TABLE();
335: a21 := JTF_NUMBER_TABLE();
336: a22 := JTF_VARCHAR2_TABLE_100();
337: a23 := JTF_DATE_TABLE();
338: a24 := JTF_NUMBER_TABLE();
339: a25 := JTF_VARCHAR2_TABLE_100();
334: a20 := JTF_DATE_TABLE();
335: a21 := JTF_NUMBER_TABLE();
336: a22 := JTF_VARCHAR2_TABLE_100();
337: a23 := JTF_DATE_TABLE();
338: a24 := JTF_NUMBER_TABLE();
339: a25 := JTF_VARCHAR2_TABLE_100();
340: a26 := JTF_DATE_TABLE();
341: a27 := JTF_NUMBER_TABLE();
342: a28 := JTF_VARCHAR2_TABLE_100();
337: a23 := JTF_DATE_TABLE();
338: a24 := JTF_NUMBER_TABLE();
339: a25 := JTF_VARCHAR2_TABLE_100();
340: a26 := JTF_DATE_TABLE();
341: a27 := JTF_NUMBER_TABLE();
342: a28 := JTF_VARCHAR2_TABLE_100();
343: a29 := JTF_DATE_TABLE();
344: a30 := JTF_NUMBER_TABLE();
345: a31 := JTF_VARCHAR2_TABLE_100();
340: a26 := JTF_DATE_TABLE();
341: a27 := JTF_NUMBER_TABLE();
342: a28 := JTF_VARCHAR2_TABLE_100();
343: a29 := JTF_DATE_TABLE();
344: a30 := JTF_NUMBER_TABLE();
345: a31 := JTF_VARCHAR2_TABLE_100();
346: a32 := JTF_DATE_TABLE();
347: a33 := JTF_NUMBER_TABLE();
348: a34 := JTF_VARCHAR2_TABLE_100();
343: a29 := JTF_DATE_TABLE();
344: a30 := JTF_NUMBER_TABLE();
345: a31 := JTF_VARCHAR2_TABLE_100();
346: a32 := JTF_DATE_TABLE();
347: a33 := JTF_NUMBER_TABLE();
348: a34 := JTF_VARCHAR2_TABLE_100();
349: a35 := JTF_DATE_TABLE();
350: a36 := JTF_NUMBER_TABLE();
351: a37 := JTF_VARCHAR2_TABLE_100();
346: a32 := JTF_DATE_TABLE();
347: a33 := JTF_NUMBER_TABLE();
348: a34 := JTF_VARCHAR2_TABLE_100();
349: a35 := JTF_DATE_TABLE();
350: a36 := JTF_NUMBER_TABLE();
351: a37 := JTF_VARCHAR2_TABLE_100();
352: a38 := JTF_DATE_TABLE();
353: a39 := JTF_NUMBER_TABLE();
354: a40 := JTF_VARCHAR2_TABLE_100();
349: a35 := JTF_DATE_TABLE();
350: a36 := JTF_NUMBER_TABLE();
351: a37 := JTF_VARCHAR2_TABLE_100();
352: a38 := JTF_DATE_TABLE();
353: a39 := JTF_NUMBER_TABLE();
354: a40 := JTF_VARCHAR2_TABLE_100();
355: a41 := JTF_DATE_TABLE();
356: a42 := JTF_NUMBER_TABLE();
357: a43 := JTF_VARCHAR2_TABLE_100();
352: a38 := JTF_DATE_TABLE();
353: a39 := JTF_NUMBER_TABLE();
354: a40 := JTF_VARCHAR2_TABLE_100();
355: a41 := JTF_DATE_TABLE();
356: a42 := JTF_NUMBER_TABLE();
357: a43 := JTF_VARCHAR2_TABLE_100();
358: a44 := JTF_DATE_TABLE();
359: a45 := JTF_NUMBER_TABLE();
360: a46 := JTF_VARCHAR2_TABLE_100();
355: a41 := JTF_DATE_TABLE();
356: a42 := JTF_NUMBER_TABLE();
357: a43 := JTF_VARCHAR2_TABLE_100();
358: a44 := JTF_DATE_TABLE();
359: a45 := JTF_NUMBER_TABLE();
360: a46 := JTF_VARCHAR2_TABLE_100();
361: a47 := JTF_DATE_TABLE();
362: a48 := JTF_NUMBER_TABLE();
363: a49 := JTF_VARCHAR2_TABLE_100();
358: a44 := JTF_DATE_TABLE();
359: a45 := JTF_NUMBER_TABLE();
360: a46 := JTF_VARCHAR2_TABLE_100();
361: a47 := JTF_DATE_TABLE();
362: a48 := JTF_NUMBER_TABLE();
363: a49 := JTF_VARCHAR2_TABLE_100();
364: a50 := JTF_DATE_TABLE();
365: a51 := JTF_NUMBER_TABLE();
366: a52 := JTF_VARCHAR2_TABLE_100();
361: a47 := JTF_DATE_TABLE();
362: a48 := JTF_NUMBER_TABLE();
363: a49 := JTF_VARCHAR2_TABLE_100();
364: a50 := JTF_DATE_TABLE();
365: a51 := JTF_NUMBER_TABLE();
366: a52 := JTF_VARCHAR2_TABLE_100();
367: a53 := JTF_DATE_TABLE();
368: a54 := JTF_NUMBER_TABLE();
369: a55 := JTF_VARCHAR2_TABLE_100();
364: a50 := JTF_DATE_TABLE();
365: a51 := JTF_NUMBER_TABLE();
366: a52 := JTF_VARCHAR2_TABLE_100();
367: a53 := JTF_DATE_TABLE();
368: a54 := JTF_NUMBER_TABLE();
369: a55 := JTF_VARCHAR2_TABLE_100();
370: a56 := JTF_DATE_TABLE();
371: a57 := JTF_NUMBER_TABLE();
372: a58 := JTF_VARCHAR2_TABLE_100();
367: a53 := JTF_DATE_TABLE();
368: a54 := JTF_NUMBER_TABLE();
369: a55 := JTF_VARCHAR2_TABLE_100();
370: a56 := JTF_DATE_TABLE();
371: a57 := JTF_NUMBER_TABLE();
372: a58 := JTF_VARCHAR2_TABLE_100();
373: a59 := JTF_DATE_TABLE();
374: a60 := JTF_NUMBER_TABLE();
375: a61 := JTF_VARCHAR2_TABLE_100();
370: a56 := JTF_DATE_TABLE();
371: a57 := JTF_NUMBER_TABLE();
372: a58 := JTF_VARCHAR2_TABLE_100();
373: a59 := JTF_DATE_TABLE();
374: a60 := JTF_NUMBER_TABLE();
375: a61 := JTF_VARCHAR2_TABLE_100();
376: a62 := JTF_DATE_TABLE();
377: a63 := JTF_NUMBER_TABLE();
378: a64 := JTF_VARCHAR2_TABLE_100();
373: a59 := JTF_DATE_TABLE();
374: a60 := JTF_NUMBER_TABLE();
375: a61 := JTF_VARCHAR2_TABLE_100();
376: a62 := JTF_DATE_TABLE();
377: a63 := JTF_NUMBER_TABLE();
378: a64 := JTF_VARCHAR2_TABLE_100();
379: a65 := JTF_DATE_TABLE();
380: a66 := JTF_NUMBER_TABLE();
381: a67 := JTF_VARCHAR2_TABLE_100();
376: a62 := JTF_DATE_TABLE();
377: a63 := JTF_NUMBER_TABLE();
378: a64 := JTF_VARCHAR2_TABLE_100();
379: a65 := JTF_DATE_TABLE();
380: a66 := JTF_NUMBER_TABLE();
381: a67 := JTF_VARCHAR2_TABLE_100();
382: a68 := JTF_DATE_TABLE();
383: a69 := JTF_NUMBER_TABLE();
384: a70 := JTF_NUMBER_TABLE();
379: a65 := JTF_DATE_TABLE();
380: a66 := JTF_NUMBER_TABLE();
381: a67 := JTF_VARCHAR2_TABLE_100();
382: a68 := JTF_DATE_TABLE();
383: a69 := JTF_NUMBER_TABLE();
384: a70 := JTF_NUMBER_TABLE();
385: if t.count > 0 then
386: a0.extend(t.count);
387: a1.extend(t.count);
380: a66 := JTF_NUMBER_TABLE();
381: a67 := JTF_VARCHAR2_TABLE_100();
382: a68 := JTF_DATE_TABLE();
383: a69 := JTF_NUMBER_TABLE();
384: a70 := JTF_NUMBER_TABLE();
385: if t.count > 0 then
386: a0.extend(t.count);
387: a1.extend(t.count);
388: a2.extend(t.count);
542: end if;
543: end if;
544: end rosetta_table_copy_out_p6;
545:
546: procedure rosetta_table_copy_in_p7(t out nocopy ahl_amp_workbench_pvt.sch_visits_tbl, a0 JTF_NUMBER_TABLE
547: , a1 JTF_DATE_TABLE
548: , a2 JTF_DATE_TABLE
549: ) as
550: ddindx binary_integer; indx binary_integer;
565: end loop;
566: end if;
567: end if;
568: end rosetta_table_copy_in_p7;
569: procedure rosetta_table_copy_out_p7(t ahl_amp_workbench_pvt.sch_visits_tbl, a0 out nocopy JTF_NUMBER_TABLE
570: , a1 out nocopy JTF_DATE_TABLE
571: , a2 out nocopy JTF_DATE_TABLE
572: ) as
573: ddindx binary_integer; indx binary_integer;
572: ) as
573: ddindx binary_integer; indx binary_integer;
574: begin
575: if t is null or t.count = 0 then
576: a0 := JTF_NUMBER_TABLE();
577: a1 := JTF_DATE_TABLE();
578: a2 := JTF_DATE_TABLE();
579: else
580: a0 := JTF_NUMBER_TABLE();
576: a0 := JTF_NUMBER_TABLE();
577: a1 := JTF_DATE_TABLE();
578: a2 := JTF_DATE_TABLE();
579: else
580: a0 := JTF_NUMBER_TABLE();
581: a1 := JTF_DATE_TABLE();
582: a2 := JTF_DATE_TABLE();
583: if t.count > 0 then
584: a0.extend(t.count);
599: end if;
600: end if;
601: end rosetta_table_copy_out_p7;
602:
603: procedure rosetta_table_copy_in_p8(t out nocopy ahl_amp_workbench_pvt.resource_input_tbl_type, a0 JTF_NUMBER_TABLE
604: , a1 JTF_NUMBER_TABLE
605: ) as
606: ddindx binary_integer; indx binary_integer;
607: begin
600: end if;
601: end rosetta_table_copy_out_p7;
602:
603: procedure rosetta_table_copy_in_p8(t out nocopy ahl_amp_workbench_pvt.resource_input_tbl_type, a0 JTF_NUMBER_TABLE
604: , a1 JTF_NUMBER_TABLE
605: ) as
606: ddindx binary_integer; indx binary_integer;
607: begin
608: if a0 is not null and a0.count > 0 then
620: end loop;
621: end if;
622: end if;
623: end rosetta_table_copy_in_p8;
624: procedure rosetta_table_copy_out_p8(t ahl_amp_workbench_pvt.resource_input_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
625: , a1 out nocopy JTF_NUMBER_TABLE
626: ) as
627: ddindx binary_integer; indx binary_integer;
628: begin
621: end if;
622: end if;
623: end rosetta_table_copy_in_p8;
624: procedure rosetta_table_copy_out_p8(t ahl_amp_workbench_pvt.resource_input_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
625: , a1 out nocopy JTF_NUMBER_TABLE
626: ) as
627: ddindx binary_integer; indx binary_integer;
628: begin
629: if t is null or t.count = 0 then
626: ) as
627: ddindx binary_integer; indx binary_integer;
628: begin
629: if t is null or t.count = 0 then
630: a0 := JTF_NUMBER_TABLE();
631: a1 := JTF_NUMBER_TABLE();
632: else
633: a0 := JTF_NUMBER_TABLE();
634: a1 := JTF_NUMBER_TABLE();
627: ddindx binary_integer; indx binary_integer;
628: begin
629: if t is null or t.count = 0 then
630: a0 := JTF_NUMBER_TABLE();
631: a1 := JTF_NUMBER_TABLE();
632: else
633: a0 := JTF_NUMBER_TABLE();
634: a1 := JTF_NUMBER_TABLE();
635: if t.count > 0 then
629: if t is null or t.count = 0 then
630: a0 := JTF_NUMBER_TABLE();
631: a1 := JTF_NUMBER_TABLE();
632: else
633: a0 := JTF_NUMBER_TABLE();
634: a1 := JTF_NUMBER_TABLE();
635: if t.count > 0 then
636: a0.extend(t.count);
637: a1.extend(t.count);
630: a0 := JTF_NUMBER_TABLE();
631: a1 := JTF_NUMBER_TABLE();
632: else
633: a0 := JTF_NUMBER_TABLE();
634: a1 := JTF_NUMBER_TABLE();
635: if t.count > 0 then
636: a0.extend(t.count);
637: a1.extend(t.count);
638: ddindx := t.first;
650: end if;
651: end rosetta_table_copy_out_p8;
652:
653: procedure rosetta_table_copy_in_p9(t out nocopy ahl_amp_workbench_pvt.resource_output_tbl_type, a0 JTF_DATE_TABLE
654: , a1 JTF_NUMBER_TABLE
655: , a2 JTF_NUMBER_TABLE
656: , a3 JTF_NUMBER_TABLE
657: , a4 JTF_NUMBER_TABLE
658: , a5 JTF_NUMBER_TABLE
651: end rosetta_table_copy_out_p8;
652:
653: procedure rosetta_table_copy_in_p9(t out nocopy ahl_amp_workbench_pvt.resource_output_tbl_type, a0 JTF_DATE_TABLE
654: , a1 JTF_NUMBER_TABLE
655: , a2 JTF_NUMBER_TABLE
656: , a3 JTF_NUMBER_TABLE
657: , a4 JTF_NUMBER_TABLE
658: , a5 JTF_NUMBER_TABLE
659: , a6 JTF_NUMBER_TABLE
652:
653: procedure rosetta_table_copy_in_p9(t out nocopy ahl_amp_workbench_pvt.resource_output_tbl_type, a0 JTF_DATE_TABLE
654: , a1 JTF_NUMBER_TABLE
655: , a2 JTF_NUMBER_TABLE
656: , a3 JTF_NUMBER_TABLE
657: , a4 JTF_NUMBER_TABLE
658: , a5 JTF_NUMBER_TABLE
659: , a6 JTF_NUMBER_TABLE
660: ) as
653: procedure rosetta_table_copy_in_p9(t out nocopy ahl_amp_workbench_pvt.resource_output_tbl_type, a0 JTF_DATE_TABLE
654: , a1 JTF_NUMBER_TABLE
655: , a2 JTF_NUMBER_TABLE
656: , a3 JTF_NUMBER_TABLE
657: , a4 JTF_NUMBER_TABLE
658: , a5 JTF_NUMBER_TABLE
659: , a6 JTF_NUMBER_TABLE
660: ) as
661: ddindx binary_integer; indx binary_integer;
654: , a1 JTF_NUMBER_TABLE
655: , a2 JTF_NUMBER_TABLE
656: , a3 JTF_NUMBER_TABLE
657: , a4 JTF_NUMBER_TABLE
658: , a5 JTF_NUMBER_TABLE
659: , a6 JTF_NUMBER_TABLE
660: ) as
661: ddindx binary_integer; indx binary_integer;
662: begin
655: , a2 JTF_NUMBER_TABLE
656: , a3 JTF_NUMBER_TABLE
657: , a4 JTF_NUMBER_TABLE
658: , a5 JTF_NUMBER_TABLE
659: , a6 JTF_NUMBER_TABLE
660: ) as
661: ddindx binary_integer; indx binary_integer;
662: begin
663: if a0 is not null and a0.count > 0 then
681: end if;
682: end if;
683: end rosetta_table_copy_in_p9;
684: procedure rosetta_table_copy_out_p9(t ahl_amp_workbench_pvt.resource_output_tbl_type, a0 out nocopy JTF_DATE_TABLE
685: , a1 out nocopy JTF_NUMBER_TABLE
686: , a2 out nocopy JTF_NUMBER_TABLE
687: , a3 out nocopy JTF_NUMBER_TABLE
688: , a4 out nocopy JTF_NUMBER_TABLE
689: , a5 out nocopy JTF_NUMBER_TABLE
682: end if;
683: end rosetta_table_copy_in_p9;
684: procedure rosetta_table_copy_out_p9(t ahl_amp_workbench_pvt.resource_output_tbl_type, a0 out nocopy JTF_DATE_TABLE
685: , a1 out nocopy JTF_NUMBER_TABLE
686: , a2 out nocopy JTF_NUMBER_TABLE
687: , a3 out nocopy JTF_NUMBER_TABLE
688: , a4 out nocopy JTF_NUMBER_TABLE
689: , a5 out nocopy JTF_NUMBER_TABLE
690: , a6 out nocopy JTF_NUMBER_TABLE
683: end rosetta_table_copy_in_p9;
684: procedure rosetta_table_copy_out_p9(t ahl_amp_workbench_pvt.resource_output_tbl_type, a0 out nocopy JTF_DATE_TABLE
685: , a1 out nocopy JTF_NUMBER_TABLE
686: , a2 out nocopy JTF_NUMBER_TABLE
687: , a3 out nocopy JTF_NUMBER_TABLE
688: , a4 out nocopy JTF_NUMBER_TABLE
689: , a5 out nocopy JTF_NUMBER_TABLE
690: , a6 out nocopy JTF_NUMBER_TABLE
691: ) as
684: procedure rosetta_table_copy_out_p9(t ahl_amp_workbench_pvt.resource_output_tbl_type, a0 out nocopy JTF_DATE_TABLE
685: , a1 out nocopy JTF_NUMBER_TABLE
686: , a2 out nocopy JTF_NUMBER_TABLE
687: , a3 out nocopy JTF_NUMBER_TABLE
688: , a4 out nocopy JTF_NUMBER_TABLE
689: , a5 out nocopy JTF_NUMBER_TABLE
690: , a6 out nocopy JTF_NUMBER_TABLE
691: ) as
692: ddindx binary_integer; indx binary_integer;
685: , a1 out nocopy JTF_NUMBER_TABLE
686: , a2 out nocopy JTF_NUMBER_TABLE
687: , a3 out nocopy JTF_NUMBER_TABLE
688: , a4 out nocopy JTF_NUMBER_TABLE
689: , a5 out nocopy JTF_NUMBER_TABLE
690: , a6 out nocopy JTF_NUMBER_TABLE
691: ) as
692: ddindx binary_integer; indx binary_integer;
693: begin
686: , a2 out nocopy JTF_NUMBER_TABLE
687: , a3 out nocopy JTF_NUMBER_TABLE
688: , a4 out nocopy JTF_NUMBER_TABLE
689: , a5 out nocopy JTF_NUMBER_TABLE
690: , a6 out nocopy JTF_NUMBER_TABLE
691: ) as
692: ddindx binary_integer; indx binary_integer;
693: begin
694: if t is null or t.count = 0 then
692: ddindx binary_integer; indx binary_integer;
693: begin
694: if t is null or t.count = 0 then
695: a0 := JTF_DATE_TABLE();
696: a1 := JTF_NUMBER_TABLE();
697: a2 := JTF_NUMBER_TABLE();
698: a3 := JTF_NUMBER_TABLE();
699: a4 := JTF_NUMBER_TABLE();
700: a5 := JTF_NUMBER_TABLE();
693: begin
694: if t is null or t.count = 0 then
695: a0 := JTF_DATE_TABLE();
696: a1 := JTF_NUMBER_TABLE();
697: a2 := JTF_NUMBER_TABLE();
698: a3 := JTF_NUMBER_TABLE();
699: a4 := JTF_NUMBER_TABLE();
700: a5 := JTF_NUMBER_TABLE();
701: a6 := JTF_NUMBER_TABLE();
694: if t is null or t.count = 0 then
695: a0 := JTF_DATE_TABLE();
696: a1 := JTF_NUMBER_TABLE();
697: a2 := JTF_NUMBER_TABLE();
698: a3 := JTF_NUMBER_TABLE();
699: a4 := JTF_NUMBER_TABLE();
700: a5 := JTF_NUMBER_TABLE();
701: a6 := JTF_NUMBER_TABLE();
702: else
695: a0 := JTF_DATE_TABLE();
696: a1 := JTF_NUMBER_TABLE();
697: a2 := JTF_NUMBER_TABLE();
698: a3 := JTF_NUMBER_TABLE();
699: a4 := JTF_NUMBER_TABLE();
700: a5 := JTF_NUMBER_TABLE();
701: a6 := JTF_NUMBER_TABLE();
702: else
703: a0 := JTF_DATE_TABLE();
696: a1 := JTF_NUMBER_TABLE();
697: a2 := JTF_NUMBER_TABLE();
698: a3 := JTF_NUMBER_TABLE();
699: a4 := JTF_NUMBER_TABLE();
700: a5 := JTF_NUMBER_TABLE();
701: a6 := JTF_NUMBER_TABLE();
702: else
703: a0 := JTF_DATE_TABLE();
704: a1 := JTF_NUMBER_TABLE();
697: a2 := JTF_NUMBER_TABLE();
698: a3 := JTF_NUMBER_TABLE();
699: a4 := JTF_NUMBER_TABLE();
700: a5 := JTF_NUMBER_TABLE();
701: a6 := JTF_NUMBER_TABLE();
702: else
703: a0 := JTF_DATE_TABLE();
704: a1 := JTF_NUMBER_TABLE();
705: a2 := JTF_NUMBER_TABLE();
700: a5 := JTF_NUMBER_TABLE();
701: a6 := JTF_NUMBER_TABLE();
702: else
703: a0 := JTF_DATE_TABLE();
704: a1 := JTF_NUMBER_TABLE();
705: a2 := JTF_NUMBER_TABLE();
706: a3 := JTF_NUMBER_TABLE();
707: a4 := JTF_NUMBER_TABLE();
708: a5 := JTF_NUMBER_TABLE();
701: a6 := JTF_NUMBER_TABLE();
702: else
703: a0 := JTF_DATE_TABLE();
704: a1 := JTF_NUMBER_TABLE();
705: a2 := JTF_NUMBER_TABLE();
706: a3 := JTF_NUMBER_TABLE();
707: a4 := JTF_NUMBER_TABLE();
708: a5 := JTF_NUMBER_TABLE();
709: a6 := JTF_NUMBER_TABLE();
702: else
703: a0 := JTF_DATE_TABLE();
704: a1 := JTF_NUMBER_TABLE();
705: a2 := JTF_NUMBER_TABLE();
706: a3 := JTF_NUMBER_TABLE();
707: a4 := JTF_NUMBER_TABLE();
708: a5 := JTF_NUMBER_TABLE();
709: a6 := JTF_NUMBER_TABLE();
710: if t.count > 0 then
703: a0 := JTF_DATE_TABLE();
704: a1 := JTF_NUMBER_TABLE();
705: a2 := JTF_NUMBER_TABLE();
706: a3 := JTF_NUMBER_TABLE();
707: a4 := JTF_NUMBER_TABLE();
708: a5 := JTF_NUMBER_TABLE();
709: a6 := JTF_NUMBER_TABLE();
710: if t.count > 0 then
711: a0.extend(t.count);
704: a1 := JTF_NUMBER_TABLE();
705: a2 := JTF_NUMBER_TABLE();
706: a3 := JTF_NUMBER_TABLE();
707: a4 := JTF_NUMBER_TABLE();
708: a5 := JTF_NUMBER_TABLE();
709: a6 := JTF_NUMBER_TABLE();
710: if t.count > 0 then
711: a0.extend(t.count);
712: a1.extend(t.count);
705: a2 := JTF_NUMBER_TABLE();
706: a3 := JTF_NUMBER_TABLE();
707: a4 := JTF_NUMBER_TABLE();
708: a5 := JTF_NUMBER_TABLE();
709: a6 := JTF_NUMBER_TABLE();
710: if t.count > 0 then
711: a0.extend(t.count);
712: a1.extend(t.count);
713: a2.extend(t.count);
749: , p6_a5 DATE
750: , p6_a6 DATE
751: , p6_a7 NUMBER
752: , p6_a8 VARCHAR2
753: , p7_a0 out nocopy JTF_NUMBER_TABLE
754: , p7_a1 out nocopy JTF_NUMBER_TABLE
755: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
756: , p7_a3 out nocopy JTF_NUMBER_TABLE
757: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
750: , p6_a6 DATE
751: , p6_a7 NUMBER
752: , p6_a8 VARCHAR2
753: , p7_a0 out nocopy JTF_NUMBER_TABLE
754: , p7_a1 out nocopy JTF_NUMBER_TABLE
755: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
756: , p7_a3 out nocopy JTF_NUMBER_TABLE
757: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
758: , p7_a5 out nocopy JTF_NUMBER_TABLE
752: , p6_a8 VARCHAR2
753: , p7_a0 out nocopy JTF_NUMBER_TABLE
754: , p7_a1 out nocopy JTF_NUMBER_TABLE
755: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
756: , p7_a3 out nocopy JTF_NUMBER_TABLE
757: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
758: , p7_a5 out nocopy JTF_NUMBER_TABLE
759: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
760: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
754: , p7_a1 out nocopy JTF_NUMBER_TABLE
755: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
756: , p7_a3 out nocopy JTF_NUMBER_TABLE
757: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
758: , p7_a5 out nocopy JTF_NUMBER_TABLE
759: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
760: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
761: , p7_a8 out nocopy JTF_DATE_TABLE
762: , p7_a9 out nocopy JTF_NUMBER_TABLE
758: , p7_a5 out nocopy JTF_NUMBER_TABLE
759: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
760: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
761: , p7_a8 out nocopy JTF_DATE_TABLE
762: , p7_a9 out nocopy JTF_NUMBER_TABLE
763: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
764: , p7_a11 out nocopy JTF_DATE_TABLE
765: , p7_a12 out nocopy JTF_NUMBER_TABLE
766: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100
761: , p7_a8 out nocopy JTF_DATE_TABLE
762: , p7_a9 out nocopy JTF_NUMBER_TABLE
763: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
764: , p7_a11 out nocopy JTF_DATE_TABLE
765: , p7_a12 out nocopy JTF_NUMBER_TABLE
766: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100
767: , p7_a14 out nocopy JTF_DATE_TABLE
768: , p7_a15 out nocopy JTF_NUMBER_TABLE
769: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
764: , p7_a11 out nocopy JTF_DATE_TABLE
765: , p7_a12 out nocopy JTF_NUMBER_TABLE
766: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100
767: , p7_a14 out nocopy JTF_DATE_TABLE
768: , p7_a15 out nocopy JTF_NUMBER_TABLE
769: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
770: , p7_a17 out nocopy JTF_DATE_TABLE
771: , p7_a18 out nocopy JTF_NUMBER_TABLE
772: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
767: , p7_a14 out nocopy JTF_DATE_TABLE
768: , p7_a15 out nocopy JTF_NUMBER_TABLE
769: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
770: , p7_a17 out nocopy JTF_DATE_TABLE
771: , p7_a18 out nocopy JTF_NUMBER_TABLE
772: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
773: , p7_a20 out nocopy JTF_DATE_TABLE
774: , p7_a21 out nocopy JTF_NUMBER_TABLE
775: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
770: , p7_a17 out nocopy JTF_DATE_TABLE
771: , p7_a18 out nocopy JTF_NUMBER_TABLE
772: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
773: , p7_a20 out nocopy JTF_DATE_TABLE
774: , p7_a21 out nocopy JTF_NUMBER_TABLE
775: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
776: , p7_a23 out nocopy JTF_DATE_TABLE
777: , p7_a24 out nocopy JTF_NUMBER_TABLE
778: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
773: , p7_a20 out nocopy JTF_DATE_TABLE
774: , p7_a21 out nocopy JTF_NUMBER_TABLE
775: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
776: , p7_a23 out nocopy JTF_DATE_TABLE
777: , p7_a24 out nocopy JTF_NUMBER_TABLE
778: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
779: , p7_a26 out nocopy JTF_DATE_TABLE
780: , p7_a27 out nocopy JTF_NUMBER_TABLE
781: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
776: , p7_a23 out nocopy JTF_DATE_TABLE
777: , p7_a24 out nocopy JTF_NUMBER_TABLE
778: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
779: , p7_a26 out nocopy JTF_DATE_TABLE
780: , p7_a27 out nocopy JTF_NUMBER_TABLE
781: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
782: , p7_a29 out nocopy JTF_DATE_TABLE
783: , p7_a30 out nocopy JTF_NUMBER_TABLE
784: , p7_a31 out nocopy JTF_VARCHAR2_TABLE_100
779: , p7_a26 out nocopy JTF_DATE_TABLE
780: , p7_a27 out nocopy JTF_NUMBER_TABLE
781: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
782: , p7_a29 out nocopy JTF_DATE_TABLE
783: , p7_a30 out nocopy JTF_NUMBER_TABLE
784: , p7_a31 out nocopy JTF_VARCHAR2_TABLE_100
785: , p7_a32 out nocopy JTF_DATE_TABLE
786: , p7_a33 out nocopy JTF_NUMBER_TABLE
787: , p7_a34 out nocopy JTF_VARCHAR2_TABLE_100
782: , p7_a29 out nocopy JTF_DATE_TABLE
783: , p7_a30 out nocopy JTF_NUMBER_TABLE
784: , p7_a31 out nocopy JTF_VARCHAR2_TABLE_100
785: , p7_a32 out nocopy JTF_DATE_TABLE
786: , p7_a33 out nocopy JTF_NUMBER_TABLE
787: , p7_a34 out nocopy JTF_VARCHAR2_TABLE_100
788: , p7_a35 out nocopy JTF_DATE_TABLE
789: , p7_a36 out nocopy JTF_NUMBER_TABLE
790: , p7_a37 out nocopy JTF_VARCHAR2_TABLE_100
785: , p7_a32 out nocopy JTF_DATE_TABLE
786: , p7_a33 out nocopy JTF_NUMBER_TABLE
787: , p7_a34 out nocopy JTF_VARCHAR2_TABLE_100
788: , p7_a35 out nocopy JTF_DATE_TABLE
789: , p7_a36 out nocopy JTF_NUMBER_TABLE
790: , p7_a37 out nocopy JTF_VARCHAR2_TABLE_100
791: , p7_a38 out nocopy JTF_DATE_TABLE
792: , p7_a39 out nocopy JTF_NUMBER_TABLE
793: , p7_a40 out nocopy JTF_VARCHAR2_TABLE_100
788: , p7_a35 out nocopy JTF_DATE_TABLE
789: , p7_a36 out nocopy JTF_NUMBER_TABLE
790: , p7_a37 out nocopy JTF_VARCHAR2_TABLE_100
791: , p7_a38 out nocopy JTF_DATE_TABLE
792: , p7_a39 out nocopy JTF_NUMBER_TABLE
793: , p7_a40 out nocopy JTF_VARCHAR2_TABLE_100
794: , p7_a41 out nocopy JTF_DATE_TABLE
795: , p7_a42 out nocopy JTF_NUMBER_TABLE
796: , p7_a43 out nocopy JTF_VARCHAR2_TABLE_100
791: , p7_a38 out nocopy JTF_DATE_TABLE
792: , p7_a39 out nocopy JTF_NUMBER_TABLE
793: , p7_a40 out nocopy JTF_VARCHAR2_TABLE_100
794: , p7_a41 out nocopy JTF_DATE_TABLE
795: , p7_a42 out nocopy JTF_NUMBER_TABLE
796: , p7_a43 out nocopy JTF_VARCHAR2_TABLE_100
797: , p7_a44 out nocopy JTF_DATE_TABLE
798: , p7_a45 out nocopy JTF_NUMBER_TABLE
799: , p7_a46 out nocopy JTF_VARCHAR2_TABLE_100
794: , p7_a41 out nocopy JTF_DATE_TABLE
795: , p7_a42 out nocopy JTF_NUMBER_TABLE
796: , p7_a43 out nocopy JTF_VARCHAR2_TABLE_100
797: , p7_a44 out nocopy JTF_DATE_TABLE
798: , p7_a45 out nocopy JTF_NUMBER_TABLE
799: , p7_a46 out nocopy JTF_VARCHAR2_TABLE_100
800: , p7_a47 out nocopy JTF_DATE_TABLE
801: , p7_a48 out nocopy JTF_NUMBER_TABLE
802: , p7_a49 out nocopy JTF_VARCHAR2_TABLE_100
797: , p7_a44 out nocopy JTF_DATE_TABLE
798: , p7_a45 out nocopy JTF_NUMBER_TABLE
799: , p7_a46 out nocopy JTF_VARCHAR2_TABLE_100
800: , p7_a47 out nocopy JTF_DATE_TABLE
801: , p7_a48 out nocopy JTF_NUMBER_TABLE
802: , p7_a49 out nocopy JTF_VARCHAR2_TABLE_100
803: , p7_a50 out nocopy JTF_DATE_TABLE
804: , p7_a51 out nocopy JTF_NUMBER_TABLE
805: , p7_a52 out nocopy JTF_VARCHAR2_TABLE_100
800: , p7_a47 out nocopy JTF_DATE_TABLE
801: , p7_a48 out nocopy JTF_NUMBER_TABLE
802: , p7_a49 out nocopy JTF_VARCHAR2_TABLE_100
803: , p7_a50 out nocopy JTF_DATE_TABLE
804: , p7_a51 out nocopy JTF_NUMBER_TABLE
805: , p7_a52 out nocopy JTF_VARCHAR2_TABLE_100
806: , p7_a53 out nocopy JTF_DATE_TABLE
807: , p7_a54 out nocopy JTF_NUMBER_TABLE
808: , p7_a55 out nocopy JTF_VARCHAR2_TABLE_100
803: , p7_a50 out nocopy JTF_DATE_TABLE
804: , p7_a51 out nocopy JTF_NUMBER_TABLE
805: , p7_a52 out nocopy JTF_VARCHAR2_TABLE_100
806: , p7_a53 out nocopy JTF_DATE_TABLE
807: , p7_a54 out nocopy JTF_NUMBER_TABLE
808: , p7_a55 out nocopy JTF_VARCHAR2_TABLE_100
809: , p7_a56 out nocopy JTF_DATE_TABLE
810: , p7_a57 out nocopy JTF_NUMBER_TABLE
811: , p7_a58 out nocopy JTF_VARCHAR2_TABLE_100
806: , p7_a53 out nocopy JTF_DATE_TABLE
807: , p7_a54 out nocopy JTF_NUMBER_TABLE
808: , p7_a55 out nocopy JTF_VARCHAR2_TABLE_100
809: , p7_a56 out nocopy JTF_DATE_TABLE
810: , p7_a57 out nocopy JTF_NUMBER_TABLE
811: , p7_a58 out nocopy JTF_VARCHAR2_TABLE_100
812: , p7_a59 out nocopy JTF_DATE_TABLE
813: , p7_a60 out nocopy JTF_NUMBER_TABLE
814: , p7_a61 out nocopy JTF_VARCHAR2_TABLE_100
809: , p7_a56 out nocopy JTF_DATE_TABLE
810: , p7_a57 out nocopy JTF_NUMBER_TABLE
811: , p7_a58 out nocopy JTF_VARCHAR2_TABLE_100
812: , p7_a59 out nocopy JTF_DATE_TABLE
813: , p7_a60 out nocopy JTF_NUMBER_TABLE
814: , p7_a61 out nocopy JTF_VARCHAR2_TABLE_100
815: , p7_a62 out nocopy JTF_DATE_TABLE
816: , p7_a63 out nocopy JTF_NUMBER_TABLE
817: , p7_a64 out nocopy JTF_VARCHAR2_TABLE_100
812: , p7_a59 out nocopy JTF_DATE_TABLE
813: , p7_a60 out nocopy JTF_NUMBER_TABLE
814: , p7_a61 out nocopy JTF_VARCHAR2_TABLE_100
815: , p7_a62 out nocopy JTF_DATE_TABLE
816: , p7_a63 out nocopy JTF_NUMBER_TABLE
817: , p7_a64 out nocopy JTF_VARCHAR2_TABLE_100
818: , p7_a65 out nocopy JTF_DATE_TABLE
819: , p7_a66 out nocopy JTF_NUMBER_TABLE
820: , p7_a67 out nocopy JTF_VARCHAR2_TABLE_100
815: , p7_a62 out nocopy JTF_DATE_TABLE
816: , p7_a63 out nocopy JTF_NUMBER_TABLE
817: , p7_a64 out nocopy JTF_VARCHAR2_TABLE_100
818: , p7_a65 out nocopy JTF_DATE_TABLE
819: , p7_a66 out nocopy JTF_NUMBER_TABLE
820: , p7_a67 out nocopy JTF_VARCHAR2_TABLE_100
821: , p7_a68 out nocopy JTF_DATE_TABLE
822: , p7_a69 out nocopy JTF_NUMBER_TABLE
823: , p7_a70 out nocopy JTF_NUMBER_TABLE
818: , p7_a65 out nocopy JTF_DATE_TABLE
819: , p7_a66 out nocopy JTF_NUMBER_TABLE
820: , p7_a67 out nocopy JTF_VARCHAR2_TABLE_100
821: , p7_a68 out nocopy JTF_DATE_TABLE
822: , p7_a69 out nocopy JTF_NUMBER_TABLE
823: , p7_a70 out nocopy JTF_NUMBER_TABLE
824: )
825:
826: as
819: , p7_a66 out nocopy JTF_NUMBER_TABLE
820: , p7_a67 out nocopy JTF_VARCHAR2_TABLE_100
821: , p7_a68 out nocopy JTF_DATE_TABLE
822: , p7_a69 out nocopy JTF_NUMBER_TABLE
823: , p7_a70 out nocopy JTF_NUMBER_TABLE
824: )
825:
826: as
827: ddp_org_sch_search_rec ahl_amp_workbench_pvt.org_sch_search_rec;
1024: , p7_a67 out nocopy VARCHAR2
1025: , p7_a68 out nocopy DATE
1026: , p7_a69 out nocopy NUMBER
1027: , p7_a70 out nocopy NUMBER
1028: , p8_a0 out nocopy JTF_NUMBER_TABLE
1029: , p8_a1 out nocopy JTF_DATE_TABLE
1030: , p8_a2 out nocopy JTF_DATE_TABLE
1031: )
1032:
1172: , p6_a5 VARCHAR2
1173: , p6_a6 DATE
1174: , p6_a7 DATE
1175: , p6_a8 NUMBER
1176: , p7_a0 out nocopy JTF_NUMBER_TABLE
1177: , p7_a1 out nocopy JTF_NUMBER_TABLE
1178: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
1179: , p7_a3 out nocopy JTF_NUMBER_TABLE
1180: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
1173: , p6_a6 DATE
1174: , p6_a7 DATE
1175: , p6_a8 NUMBER
1176: , p7_a0 out nocopy JTF_NUMBER_TABLE
1177: , p7_a1 out nocopy JTF_NUMBER_TABLE
1178: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
1179: , p7_a3 out nocopy JTF_NUMBER_TABLE
1180: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
1181: , p7_a5 out nocopy JTF_NUMBER_TABLE
1175: , p6_a8 NUMBER
1176: , p7_a0 out nocopy JTF_NUMBER_TABLE
1177: , p7_a1 out nocopy JTF_NUMBER_TABLE
1178: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
1179: , p7_a3 out nocopy JTF_NUMBER_TABLE
1180: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
1181: , p7_a5 out nocopy JTF_NUMBER_TABLE
1182: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
1183: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
1177: , p7_a1 out nocopy JTF_NUMBER_TABLE
1178: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
1179: , p7_a3 out nocopy JTF_NUMBER_TABLE
1180: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
1181: , p7_a5 out nocopy JTF_NUMBER_TABLE
1182: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
1183: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
1184: , p7_a8 out nocopy JTF_DATE_TABLE
1185: , p7_a9 out nocopy JTF_NUMBER_TABLE
1181: , p7_a5 out nocopy JTF_NUMBER_TABLE
1182: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
1183: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
1184: , p7_a8 out nocopy JTF_DATE_TABLE
1185: , p7_a9 out nocopy JTF_NUMBER_TABLE
1186: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
1187: , p7_a11 out nocopy JTF_DATE_TABLE
1188: , p7_a12 out nocopy JTF_NUMBER_TABLE
1189: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100
1184: , p7_a8 out nocopy JTF_DATE_TABLE
1185: , p7_a9 out nocopy JTF_NUMBER_TABLE
1186: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
1187: , p7_a11 out nocopy JTF_DATE_TABLE
1188: , p7_a12 out nocopy JTF_NUMBER_TABLE
1189: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100
1190: , p7_a14 out nocopy JTF_DATE_TABLE
1191: , p7_a15 out nocopy JTF_NUMBER_TABLE
1192: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
1187: , p7_a11 out nocopy JTF_DATE_TABLE
1188: , p7_a12 out nocopy JTF_NUMBER_TABLE
1189: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100
1190: , p7_a14 out nocopy JTF_DATE_TABLE
1191: , p7_a15 out nocopy JTF_NUMBER_TABLE
1192: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
1193: , p7_a17 out nocopy JTF_DATE_TABLE
1194: , p7_a18 out nocopy JTF_NUMBER_TABLE
1195: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
1190: , p7_a14 out nocopy JTF_DATE_TABLE
1191: , p7_a15 out nocopy JTF_NUMBER_TABLE
1192: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
1193: , p7_a17 out nocopy JTF_DATE_TABLE
1194: , p7_a18 out nocopy JTF_NUMBER_TABLE
1195: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
1196: , p7_a20 out nocopy JTF_DATE_TABLE
1197: , p7_a21 out nocopy JTF_NUMBER_TABLE
1198: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
1193: , p7_a17 out nocopy JTF_DATE_TABLE
1194: , p7_a18 out nocopy JTF_NUMBER_TABLE
1195: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
1196: , p7_a20 out nocopy JTF_DATE_TABLE
1197: , p7_a21 out nocopy JTF_NUMBER_TABLE
1198: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
1199: , p7_a23 out nocopy JTF_DATE_TABLE
1200: , p7_a24 out nocopy JTF_NUMBER_TABLE
1201: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
1196: , p7_a20 out nocopy JTF_DATE_TABLE
1197: , p7_a21 out nocopy JTF_NUMBER_TABLE
1198: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
1199: , p7_a23 out nocopy JTF_DATE_TABLE
1200: , p7_a24 out nocopy JTF_NUMBER_TABLE
1201: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
1202: , p7_a26 out nocopy JTF_DATE_TABLE
1203: , p7_a27 out nocopy JTF_NUMBER_TABLE
1204: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
1199: , p7_a23 out nocopy JTF_DATE_TABLE
1200: , p7_a24 out nocopy JTF_NUMBER_TABLE
1201: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
1202: , p7_a26 out nocopy JTF_DATE_TABLE
1203: , p7_a27 out nocopy JTF_NUMBER_TABLE
1204: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
1205: , p7_a29 out nocopy JTF_DATE_TABLE
1206: , p7_a30 out nocopy JTF_NUMBER_TABLE
1207: , p7_a31 out nocopy JTF_VARCHAR2_TABLE_100
1202: , p7_a26 out nocopy JTF_DATE_TABLE
1203: , p7_a27 out nocopy JTF_NUMBER_TABLE
1204: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
1205: , p7_a29 out nocopy JTF_DATE_TABLE
1206: , p7_a30 out nocopy JTF_NUMBER_TABLE
1207: , p7_a31 out nocopy JTF_VARCHAR2_TABLE_100
1208: , p7_a32 out nocopy JTF_DATE_TABLE
1209: , p7_a33 out nocopy JTF_NUMBER_TABLE
1210: , p7_a34 out nocopy JTF_VARCHAR2_TABLE_100
1205: , p7_a29 out nocopy JTF_DATE_TABLE
1206: , p7_a30 out nocopy JTF_NUMBER_TABLE
1207: , p7_a31 out nocopy JTF_VARCHAR2_TABLE_100
1208: , p7_a32 out nocopy JTF_DATE_TABLE
1209: , p7_a33 out nocopy JTF_NUMBER_TABLE
1210: , p7_a34 out nocopy JTF_VARCHAR2_TABLE_100
1211: , p7_a35 out nocopy JTF_DATE_TABLE
1212: , p7_a36 out nocopy JTF_NUMBER_TABLE
1213: , p7_a37 out nocopy JTF_VARCHAR2_TABLE_100
1208: , p7_a32 out nocopy JTF_DATE_TABLE
1209: , p7_a33 out nocopy JTF_NUMBER_TABLE
1210: , p7_a34 out nocopy JTF_VARCHAR2_TABLE_100
1211: , p7_a35 out nocopy JTF_DATE_TABLE
1212: , p7_a36 out nocopy JTF_NUMBER_TABLE
1213: , p7_a37 out nocopy JTF_VARCHAR2_TABLE_100
1214: , p7_a38 out nocopy JTF_DATE_TABLE
1215: , p7_a39 out nocopy JTF_NUMBER_TABLE
1216: , p7_a40 out nocopy JTF_VARCHAR2_TABLE_100
1211: , p7_a35 out nocopy JTF_DATE_TABLE
1212: , p7_a36 out nocopy JTF_NUMBER_TABLE
1213: , p7_a37 out nocopy JTF_VARCHAR2_TABLE_100
1214: , p7_a38 out nocopy JTF_DATE_TABLE
1215: , p7_a39 out nocopy JTF_NUMBER_TABLE
1216: , p7_a40 out nocopy JTF_VARCHAR2_TABLE_100
1217: , p7_a41 out nocopy JTF_DATE_TABLE
1218: , p7_a42 out nocopy JTF_NUMBER_TABLE
1219: , p7_a43 out nocopy JTF_VARCHAR2_TABLE_100
1214: , p7_a38 out nocopy JTF_DATE_TABLE
1215: , p7_a39 out nocopy JTF_NUMBER_TABLE
1216: , p7_a40 out nocopy JTF_VARCHAR2_TABLE_100
1217: , p7_a41 out nocopy JTF_DATE_TABLE
1218: , p7_a42 out nocopy JTF_NUMBER_TABLE
1219: , p7_a43 out nocopy JTF_VARCHAR2_TABLE_100
1220: , p7_a44 out nocopy JTF_DATE_TABLE
1221: , p7_a45 out nocopy JTF_NUMBER_TABLE
1222: , p7_a46 out nocopy JTF_VARCHAR2_TABLE_100
1217: , p7_a41 out nocopy JTF_DATE_TABLE
1218: , p7_a42 out nocopy JTF_NUMBER_TABLE
1219: , p7_a43 out nocopy JTF_VARCHAR2_TABLE_100
1220: , p7_a44 out nocopy JTF_DATE_TABLE
1221: , p7_a45 out nocopy JTF_NUMBER_TABLE
1222: , p7_a46 out nocopy JTF_VARCHAR2_TABLE_100
1223: , p7_a47 out nocopy JTF_DATE_TABLE
1224: , p7_a48 out nocopy JTF_NUMBER_TABLE
1225: , p7_a49 out nocopy JTF_VARCHAR2_TABLE_100
1220: , p7_a44 out nocopy JTF_DATE_TABLE
1221: , p7_a45 out nocopy JTF_NUMBER_TABLE
1222: , p7_a46 out nocopy JTF_VARCHAR2_TABLE_100
1223: , p7_a47 out nocopy JTF_DATE_TABLE
1224: , p7_a48 out nocopy JTF_NUMBER_TABLE
1225: , p7_a49 out nocopy JTF_VARCHAR2_TABLE_100
1226: , p7_a50 out nocopy JTF_DATE_TABLE
1227: , p7_a51 out nocopy JTF_NUMBER_TABLE
1228: , p7_a52 out nocopy JTF_VARCHAR2_TABLE_100
1223: , p7_a47 out nocopy JTF_DATE_TABLE
1224: , p7_a48 out nocopy JTF_NUMBER_TABLE
1225: , p7_a49 out nocopy JTF_VARCHAR2_TABLE_100
1226: , p7_a50 out nocopy JTF_DATE_TABLE
1227: , p7_a51 out nocopy JTF_NUMBER_TABLE
1228: , p7_a52 out nocopy JTF_VARCHAR2_TABLE_100
1229: , p7_a53 out nocopy JTF_DATE_TABLE
1230: , p7_a54 out nocopy JTF_NUMBER_TABLE
1231: , p7_a55 out nocopy JTF_VARCHAR2_TABLE_100
1226: , p7_a50 out nocopy JTF_DATE_TABLE
1227: , p7_a51 out nocopy JTF_NUMBER_TABLE
1228: , p7_a52 out nocopy JTF_VARCHAR2_TABLE_100
1229: , p7_a53 out nocopy JTF_DATE_TABLE
1230: , p7_a54 out nocopy JTF_NUMBER_TABLE
1231: , p7_a55 out nocopy JTF_VARCHAR2_TABLE_100
1232: , p7_a56 out nocopy JTF_DATE_TABLE
1233: , p7_a57 out nocopy JTF_NUMBER_TABLE
1234: , p7_a58 out nocopy JTF_VARCHAR2_TABLE_100
1229: , p7_a53 out nocopy JTF_DATE_TABLE
1230: , p7_a54 out nocopy JTF_NUMBER_TABLE
1231: , p7_a55 out nocopy JTF_VARCHAR2_TABLE_100
1232: , p7_a56 out nocopy JTF_DATE_TABLE
1233: , p7_a57 out nocopy JTF_NUMBER_TABLE
1234: , p7_a58 out nocopy JTF_VARCHAR2_TABLE_100
1235: , p7_a59 out nocopy JTF_DATE_TABLE
1236: , p7_a60 out nocopy JTF_NUMBER_TABLE
1237: , p7_a61 out nocopy JTF_VARCHAR2_TABLE_100
1232: , p7_a56 out nocopy JTF_DATE_TABLE
1233: , p7_a57 out nocopy JTF_NUMBER_TABLE
1234: , p7_a58 out nocopy JTF_VARCHAR2_TABLE_100
1235: , p7_a59 out nocopy JTF_DATE_TABLE
1236: , p7_a60 out nocopy JTF_NUMBER_TABLE
1237: , p7_a61 out nocopy JTF_VARCHAR2_TABLE_100
1238: , p7_a62 out nocopy JTF_DATE_TABLE
1239: , p7_a63 out nocopy JTF_NUMBER_TABLE
1240: , p7_a64 out nocopy JTF_VARCHAR2_TABLE_100
1235: , p7_a59 out nocopy JTF_DATE_TABLE
1236: , p7_a60 out nocopy JTF_NUMBER_TABLE
1237: , p7_a61 out nocopy JTF_VARCHAR2_TABLE_100
1238: , p7_a62 out nocopy JTF_DATE_TABLE
1239: , p7_a63 out nocopy JTF_NUMBER_TABLE
1240: , p7_a64 out nocopy JTF_VARCHAR2_TABLE_100
1241: , p7_a65 out nocopy JTF_DATE_TABLE
1242: , p7_a66 out nocopy JTF_NUMBER_TABLE
1243: , p7_a67 out nocopy JTF_VARCHAR2_TABLE_100
1238: , p7_a62 out nocopy JTF_DATE_TABLE
1239: , p7_a63 out nocopy JTF_NUMBER_TABLE
1240: , p7_a64 out nocopy JTF_VARCHAR2_TABLE_100
1241: , p7_a65 out nocopy JTF_DATE_TABLE
1242: , p7_a66 out nocopy JTF_NUMBER_TABLE
1243: , p7_a67 out nocopy JTF_VARCHAR2_TABLE_100
1244: , p7_a68 out nocopy JTF_DATE_TABLE
1245: , p7_a69 out nocopy JTF_NUMBER_TABLE
1246: , p7_a70 out nocopy JTF_NUMBER_TABLE
1241: , p7_a65 out nocopy JTF_DATE_TABLE
1242: , p7_a66 out nocopy JTF_NUMBER_TABLE
1243: , p7_a67 out nocopy JTF_VARCHAR2_TABLE_100
1244: , p7_a68 out nocopy JTF_DATE_TABLE
1245: , p7_a69 out nocopy JTF_NUMBER_TABLE
1246: , p7_a70 out nocopy JTF_NUMBER_TABLE
1247: )
1248:
1249: as
1242: , p7_a66 out nocopy JTF_NUMBER_TABLE
1243: , p7_a67 out nocopy JTF_VARCHAR2_TABLE_100
1244: , p7_a68 out nocopy JTF_DATE_TABLE
1245: , p7_a69 out nocopy JTF_NUMBER_TABLE
1246: , p7_a70 out nocopy JTF_NUMBER_TABLE
1247: )
1248:
1249: as
1250: ddp_flt_sch_search_rec ahl_amp_workbench_pvt.fleet_sch_search_rec;
1447: , p7_a67 out nocopy VARCHAR2
1448: , p7_a68 out nocopy DATE
1449: , p7_a69 out nocopy NUMBER
1450: , p7_a70 out nocopy NUMBER
1451: , p8_a0 out nocopy JTF_NUMBER_TABLE
1452: , p8_a1 out nocopy JTF_DATE_TABLE
1453: , p8_a2 out nocopy JTF_DATE_TABLE
1454: )
1455:
1594: , p_department_id NUMBER
1595: , p_start_date DATE
1596: , p_no_of_days NUMBER
1597: , p_max_range NUMBER
1598: , p14_a0 in out nocopy JTF_NUMBER_TABLE
1599: , p14_a1 in out nocopy JTF_NUMBER_TABLE
1600: , p15_a0 in out nocopy JTF_DATE_TABLE
1601: , p15_a1 in out nocopy JTF_NUMBER_TABLE
1602: , p15_a2 in out nocopy JTF_NUMBER_TABLE
1595: , p_start_date DATE
1596: , p_no_of_days NUMBER
1597: , p_max_range NUMBER
1598: , p14_a0 in out nocopy JTF_NUMBER_TABLE
1599: , p14_a1 in out nocopy JTF_NUMBER_TABLE
1600: , p15_a0 in out nocopy JTF_DATE_TABLE
1601: , p15_a1 in out nocopy JTF_NUMBER_TABLE
1602: , p15_a2 in out nocopy JTF_NUMBER_TABLE
1603: , p15_a3 in out nocopy JTF_NUMBER_TABLE
1597: , p_max_range NUMBER
1598: , p14_a0 in out nocopy JTF_NUMBER_TABLE
1599: , p14_a1 in out nocopy JTF_NUMBER_TABLE
1600: , p15_a0 in out nocopy JTF_DATE_TABLE
1601: , p15_a1 in out nocopy JTF_NUMBER_TABLE
1602: , p15_a2 in out nocopy JTF_NUMBER_TABLE
1603: , p15_a3 in out nocopy JTF_NUMBER_TABLE
1604: , p15_a4 in out nocopy JTF_NUMBER_TABLE
1605: , p15_a5 in out nocopy JTF_NUMBER_TABLE
1598: , p14_a0 in out nocopy JTF_NUMBER_TABLE
1599: , p14_a1 in out nocopy JTF_NUMBER_TABLE
1600: , p15_a0 in out nocopy JTF_DATE_TABLE
1601: , p15_a1 in out nocopy JTF_NUMBER_TABLE
1602: , p15_a2 in out nocopy JTF_NUMBER_TABLE
1603: , p15_a3 in out nocopy JTF_NUMBER_TABLE
1604: , p15_a4 in out nocopy JTF_NUMBER_TABLE
1605: , p15_a5 in out nocopy JTF_NUMBER_TABLE
1606: , p15_a6 in out nocopy JTF_NUMBER_TABLE
1599: , p14_a1 in out nocopy JTF_NUMBER_TABLE
1600: , p15_a0 in out nocopy JTF_DATE_TABLE
1601: , p15_a1 in out nocopy JTF_NUMBER_TABLE
1602: , p15_a2 in out nocopy JTF_NUMBER_TABLE
1603: , p15_a3 in out nocopy JTF_NUMBER_TABLE
1604: , p15_a4 in out nocopy JTF_NUMBER_TABLE
1605: , p15_a5 in out nocopy JTF_NUMBER_TABLE
1606: , p15_a6 in out nocopy JTF_NUMBER_TABLE
1607: , x_plan_date out nocopy DATE
1600: , p15_a0 in out nocopy JTF_DATE_TABLE
1601: , p15_a1 in out nocopy JTF_NUMBER_TABLE
1602: , p15_a2 in out nocopy JTF_NUMBER_TABLE
1603: , p15_a3 in out nocopy JTF_NUMBER_TABLE
1604: , p15_a4 in out nocopy JTF_NUMBER_TABLE
1605: , p15_a5 in out nocopy JTF_NUMBER_TABLE
1606: , p15_a6 in out nocopy JTF_NUMBER_TABLE
1607: , x_plan_date out nocopy DATE
1608: )
1601: , p15_a1 in out nocopy JTF_NUMBER_TABLE
1602: , p15_a2 in out nocopy JTF_NUMBER_TABLE
1603: , p15_a3 in out nocopy JTF_NUMBER_TABLE
1604: , p15_a4 in out nocopy JTF_NUMBER_TABLE
1605: , p15_a5 in out nocopy JTF_NUMBER_TABLE
1606: , p15_a6 in out nocopy JTF_NUMBER_TABLE
1607: , x_plan_date out nocopy DATE
1608: )
1609:
1602: , p15_a2 in out nocopy JTF_NUMBER_TABLE
1603: , p15_a3 in out nocopy JTF_NUMBER_TABLE
1604: , p15_a4 in out nocopy JTF_NUMBER_TABLE
1605: , p15_a5 in out nocopy JTF_NUMBER_TABLE
1606: , p15_a6 in out nocopy JTF_NUMBER_TABLE
1607: , x_plan_date out nocopy DATE
1608: )
1609:
1610: as