12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy jtf_cal_pvt.callsttbltype, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_VARCHAR2_TABLE_400
19: , a3 JTF_VARCHAR2_TABLE_100
20: ) as
37: end loop;
38: end if;
39: end if;
40: end rosetta_table_copy_in_p1;
41: procedure rosetta_table_copy_out_p1(t jtf_cal_pvt.callsttbltype, a0 out nocopy JTF_NUMBER_TABLE
42: , a1 out nocopy JTF_VARCHAR2_TABLE_100
43: , a2 out nocopy JTF_VARCHAR2_TABLE_400
44: , a3 out nocopy JTF_VARCHAR2_TABLE_100
45: ) as
45: ) as
46: ddindx binary_integer; indx binary_integer;
47: begin
48: if t is null or t.count = 0 then
49: a0 := JTF_NUMBER_TABLE();
50: a1 := JTF_VARCHAR2_TABLE_100();
51: a2 := JTF_VARCHAR2_TABLE_400();
52: a3 := JTF_VARCHAR2_TABLE_100();
53: else
50: a1 := JTF_VARCHAR2_TABLE_100();
51: a2 := JTF_VARCHAR2_TABLE_400();
52: a3 := JTF_VARCHAR2_TABLE_100();
53: else
54: a0 := JTF_NUMBER_TABLE();
55: a1 := JTF_VARCHAR2_TABLE_100();
56: a2 := JTF_VARCHAR2_TABLE_400();
57: a3 := JTF_VARCHAR2_TABLE_100();
58: if t.count > 0 then
76: end if;
77: end if;
78: end rosetta_table_copy_out_p1;
79:
80: procedure rosetta_table_copy_in_p3(t out nocopy jtf_cal_pvt.weektimepreftbltype, a0 JTF_NUMBER_TABLE
81: , a1 JTF_NUMBER_TABLE
82: ) as
83: ddindx binary_integer; indx binary_integer;
84: begin
77: end if;
78: end rosetta_table_copy_out_p1;
79:
80: procedure rosetta_table_copy_in_p3(t out nocopy jtf_cal_pvt.weektimepreftbltype, a0 JTF_NUMBER_TABLE
81: , a1 JTF_NUMBER_TABLE
82: ) as
83: ddindx binary_integer; indx binary_integer;
84: begin
85: if a0 is not null and a0.count > 0 then
97: end loop;
98: end if;
99: end if;
100: end rosetta_table_copy_in_p3;
101: procedure rosetta_table_copy_out_p3(t jtf_cal_pvt.weektimepreftbltype, a0 out nocopy JTF_NUMBER_TABLE
102: , a1 out nocopy JTF_NUMBER_TABLE
103: ) as
104: ddindx binary_integer; indx binary_integer;
105: begin
98: end if;
99: end if;
100: end rosetta_table_copy_in_p3;
101: procedure rosetta_table_copy_out_p3(t jtf_cal_pvt.weektimepreftbltype, a0 out nocopy JTF_NUMBER_TABLE
102: , a1 out nocopy JTF_NUMBER_TABLE
103: ) as
104: ddindx binary_integer; indx binary_integer;
105: begin
106: if t is null or t.count = 0 then
103: ) as
104: ddindx binary_integer; indx binary_integer;
105: begin
106: if t is null or t.count = 0 then
107: a0 := JTF_NUMBER_TABLE();
108: a1 := JTF_NUMBER_TABLE();
109: else
110: a0 := JTF_NUMBER_TABLE();
111: a1 := JTF_NUMBER_TABLE();
104: ddindx binary_integer; indx binary_integer;
105: begin
106: if t is null or t.count = 0 then
107: a0 := JTF_NUMBER_TABLE();
108: a1 := JTF_NUMBER_TABLE();
109: else
110: a0 := JTF_NUMBER_TABLE();
111: a1 := JTF_NUMBER_TABLE();
112: if t.count > 0 then
106: if t is null or t.count = 0 then
107: a0 := JTF_NUMBER_TABLE();
108: a1 := JTF_NUMBER_TABLE();
109: else
110: a0 := JTF_NUMBER_TABLE();
111: a1 := JTF_NUMBER_TABLE();
112: if t.count > 0 then
113: a0.extend(t.count);
114: a1.extend(t.count);
107: a0 := JTF_NUMBER_TABLE();
108: a1 := JTF_NUMBER_TABLE();
109: else
110: a0 := JTF_NUMBER_TABLE();
111: a1 := JTF_NUMBER_TABLE();
112: if t.count > 0 then
113: a0.extend(t.count);
114: a1.extend(t.count);
115: ddindx := t.first;
126: end if;
127: end if;
128: end rosetta_table_copy_out_p3;
129:
130: procedure rosetta_table_copy_in_p7(t out nocopy jtf_cal_pvt.queryouttab, a0 JTF_NUMBER_TABLE
131: , a1 JTF_NUMBER_TABLE
132: , a2 JTF_VARCHAR2_TABLE_100
133: , a3 JTF_VARCHAR2_TABLE_100
134: , a4 JTF_NUMBER_TABLE
127: end if;
128: end rosetta_table_copy_out_p3;
129:
130: procedure rosetta_table_copy_in_p7(t out nocopy jtf_cal_pvt.queryouttab, a0 JTF_NUMBER_TABLE
131: , a1 JTF_NUMBER_TABLE
132: , a2 JTF_VARCHAR2_TABLE_100
133: , a3 JTF_VARCHAR2_TABLE_100
134: , a4 JTF_NUMBER_TABLE
135: , a5 JTF_NUMBER_TABLE
130: procedure rosetta_table_copy_in_p7(t out nocopy jtf_cal_pvt.queryouttab, a0 JTF_NUMBER_TABLE
131: , a1 JTF_NUMBER_TABLE
132: , a2 JTF_VARCHAR2_TABLE_100
133: , a3 JTF_VARCHAR2_TABLE_100
134: , a4 JTF_NUMBER_TABLE
135: , a5 JTF_NUMBER_TABLE
136: , a6 JTF_VARCHAR2_TABLE_200
137: , a7 JTF_NUMBER_TABLE
138: , a8 JTF_VARCHAR2_TABLE_100
131: , a1 JTF_NUMBER_TABLE
132: , a2 JTF_VARCHAR2_TABLE_100
133: , a3 JTF_VARCHAR2_TABLE_100
134: , a4 JTF_NUMBER_TABLE
135: , a5 JTF_NUMBER_TABLE
136: , a6 JTF_VARCHAR2_TABLE_200
137: , a7 JTF_NUMBER_TABLE
138: , a8 JTF_VARCHAR2_TABLE_100
139: , a9 JTF_NUMBER_TABLE
133: , a3 JTF_VARCHAR2_TABLE_100
134: , a4 JTF_NUMBER_TABLE
135: , a5 JTF_NUMBER_TABLE
136: , a6 JTF_VARCHAR2_TABLE_200
137: , a7 JTF_NUMBER_TABLE
138: , a8 JTF_VARCHAR2_TABLE_100
139: , a9 JTF_NUMBER_TABLE
140: , a10 JTF_NUMBER_TABLE
141: , a11 JTF_DATE_TABLE
135: , a5 JTF_NUMBER_TABLE
136: , a6 JTF_VARCHAR2_TABLE_200
137: , a7 JTF_NUMBER_TABLE
138: , a8 JTF_VARCHAR2_TABLE_100
139: , a9 JTF_NUMBER_TABLE
140: , a10 JTF_NUMBER_TABLE
141: , a11 JTF_DATE_TABLE
142: , a12 JTF_DATE_TABLE
143: , a13 JTF_VARCHAR2_TABLE_2000
136: , a6 JTF_VARCHAR2_TABLE_200
137: , a7 JTF_NUMBER_TABLE
138: , a8 JTF_VARCHAR2_TABLE_100
139: , a9 JTF_NUMBER_TABLE
140: , a10 JTF_NUMBER_TABLE
141: , a11 JTF_DATE_TABLE
142: , a12 JTF_DATE_TABLE
143: , a13 JTF_VARCHAR2_TABLE_2000
144: , a14 JTF_VARCHAR2_TABLE_2000
141: , a11 JTF_DATE_TABLE
142: , a12 JTF_DATE_TABLE
143: , a13 JTF_VARCHAR2_TABLE_2000
144: , a14 JTF_VARCHAR2_TABLE_2000
145: , a15 JTF_NUMBER_TABLE
146: , a16 JTF_VARCHAR2_TABLE_100
147: , a17 JTF_NUMBER_TABLE
148: , a18 JTF_VARCHAR2_TABLE_300
149: , a19 JTF_VARCHAR2_TABLE_100
143: , a13 JTF_VARCHAR2_TABLE_2000
144: , a14 JTF_VARCHAR2_TABLE_2000
145: , a15 JTF_NUMBER_TABLE
146: , a16 JTF_VARCHAR2_TABLE_100
147: , a17 JTF_NUMBER_TABLE
148: , a18 JTF_VARCHAR2_TABLE_300
149: , a19 JTF_VARCHAR2_TABLE_100
150: , a20 JTF_NUMBER_TABLE
151: , a21 JTF_NUMBER_TABLE
146: , a16 JTF_VARCHAR2_TABLE_100
147: , a17 JTF_NUMBER_TABLE
148: , a18 JTF_VARCHAR2_TABLE_300
149: , a19 JTF_VARCHAR2_TABLE_100
150: , a20 JTF_NUMBER_TABLE
151: , a21 JTF_NUMBER_TABLE
152: , a22 JTF_NUMBER_TABLE
153: ) as
154: ddindx binary_integer; indx binary_integer;
147: , a17 JTF_NUMBER_TABLE
148: , a18 JTF_VARCHAR2_TABLE_300
149: , a19 JTF_VARCHAR2_TABLE_100
150: , a20 JTF_NUMBER_TABLE
151: , a21 JTF_NUMBER_TABLE
152: , a22 JTF_NUMBER_TABLE
153: ) as
154: ddindx binary_integer; indx binary_integer;
155: begin
148: , a18 JTF_VARCHAR2_TABLE_300
149: , a19 JTF_VARCHAR2_TABLE_100
150: , a20 JTF_NUMBER_TABLE
151: , a21 JTF_NUMBER_TABLE
152: , a22 JTF_NUMBER_TABLE
153: ) as
154: ddindx binary_integer; indx binary_integer;
155: begin
156: if a0 is not null and a0.count > 0 then
189: end loop;
190: end if;
191: end if;
192: end rosetta_table_copy_in_p7;
193: procedure rosetta_table_copy_out_p7(t jtf_cal_pvt.queryouttab, a0 out nocopy JTF_NUMBER_TABLE
194: , a1 out nocopy JTF_NUMBER_TABLE
195: , a2 out nocopy JTF_VARCHAR2_TABLE_100
196: , a3 out nocopy JTF_VARCHAR2_TABLE_100
197: , a4 out nocopy JTF_NUMBER_TABLE
190: end if;
191: end if;
192: end rosetta_table_copy_in_p7;
193: procedure rosetta_table_copy_out_p7(t jtf_cal_pvt.queryouttab, a0 out nocopy JTF_NUMBER_TABLE
194: , a1 out nocopy JTF_NUMBER_TABLE
195: , a2 out nocopy JTF_VARCHAR2_TABLE_100
196: , a3 out nocopy JTF_VARCHAR2_TABLE_100
197: , a4 out nocopy JTF_NUMBER_TABLE
198: , a5 out nocopy JTF_NUMBER_TABLE
193: procedure rosetta_table_copy_out_p7(t jtf_cal_pvt.queryouttab, a0 out nocopy JTF_NUMBER_TABLE
194: , a1 out nocopy JTF_NUMBER_TABLE
195: , a2 out nocopy JTF_VARCHAR2_TABLE_100
196: , a3 out nocopy JTF_VARCHAR2_TABLE_100
197: , a4 out nocopy JTF_NUMBER_TABLE
198: , a5 out nocopy JTF_NUMBER_TABLE
199: , a6 out nocopy JTF_VARCHAR2_TABLE_200
200: , a7 out nocopy JTF_NUMBER_TABLE
201: , a8 out nocopy JTF_VARCHAR2_TABLE_100
194: , a1 out nocopy JTF_NUMBER_TABLE
195: , a2 out nocopy JTF_VARCHAR2_TABLE_100
196: , a3 out nocopy JTF_VARCHAR2_TABLE_100
197: , a4 out nocopy JTF_NUMBER_TABLE
198: , a5 out nocopy JTF_NUMBER_TABLE
199: , a6 out nocopy JTF_VARCHAR2_TABLE_200
200: , a7 out nocopy JTF_NUMBER_TABLE
201: , a8 out nocopy JTF_VARCHAR2_TABLE_100
202: , a9 out nocopy JTF_NUMBER_TABLE
196: , a3 out nocopy JTF_VARCHAR2_TABLE_100
197: , a4 out nocopy JTF_NUMBER_TABLE
198: , a5 out nocopy JTF_NUMBER_TABLE
199: , a6 out nocopy JTF_VARCHAR2_TABLE_200
200: , a7 out nocopy JTF_NUMBER_TABLE
201: , a8 out nocopy JTF_VARCHAR2_TABLE_100
202: , a9 out nocopy JTF_NUMBER_TABLE
203: , a10 out nocopy JTF_NUMBER_TABLE
204: , a11 out nocopy JTF_DATE_TABLE
198: , a5 out nocopy JTF_NUMBER_TABLE
199: , a6 out nocopy JTF_VARCHAR2_TABLE_200
200: , a7 out nocopy JTF_NUMBER_TABLE
201: , a8 out nocopy JTF_VARCHAR2_TABLE_100
202: , a9 out nocopy JTF_NUMBER_TABLE
203: , a10 out nocopy JTF_NUMBER_TABLE
204: , a11 out nocopy JTF_DATE_TABLE
205: , a12 out nocopy JTF_DATE_TABLE
206: , a13 out nocopy JTF_VARCHAR2_TABLE_2000
199: , a6 out nocopy JTF_VARCHAR2_TABLE_200
200: , a7 out nocopy JTF_NUMBER_TABLE
201: , a8 out nocopy JTF_VARCHAR2_TABLE_100
202: , a9 out nocopy JTF_NUMBER_TABLE
203: , a10 out nocopy JTF_NUMBER_TABLE
204: , a11 out nocopy JTF_DATE_TABLE
205: , a12 out nocopy JTF_DATE_TABLE
206: , a13 out nocopy JTF_VARCHAR2_TABLE_2000
207: , a14 out nocopy JTF_VARCHAR2_TABLE_2000
204: , a11 out nocopy JTF_DATE_TABLE
205: , a12 out nocopy JTF_DATE_TABLE
206: , a13 out nocopy JTF_VARCHAR2_TABLE_2000
207: , a14 out nocopy JTF_VARCHAR2_TABLE_2000
208: , a15 out nocopy JTF_NUMBER_TABLE
209: , a16 out nocopy JTF_VARCHAR2_TABLE_100
210: , a17 out nocopy JTF_NUMBER_TABLE
211: , a18 out nocopy JTF_VARCHAR2_TABLE_300
212: , a19 out nocopy JTF_VARCHAR2_TABLE_100
206: , a13 out nocopy JTF_VARCHAR2_TABLE_2000
207: , a14 out nocopy JTF_VARCHAR2_TABLE_2000
208: , a15 out nocopy JTF_NUMBER_TABLE
209: , a16 out nocopy JTF_VARCHAR2_TABLE_100
210: , a17 out nocopy JTF_NUMBER_TABLE
211: , a18 out nocopy JTF_VARCHAR2_TABLE_300
212: , a19 out nocopy JTF_VARCHAR2_TABLE_100
213: , a20 out nocopy JTF_NUMBER_TABLE
214: , a21 out nocopy JTF_NUMBER_TABLE
209: , a16 out nocopy JTF_VARCHAR2_TABLE_100
210: , a17 out nocopy JTF_NUMBER_TABLE
211: , a18 out nocopy JTF_VARCHAR2_TABLE_300
212: , a19 out nocopy JTF_VARCHAR2_TABLE_100
213: , a20 out nocopy JTF_NUMBER_TABLE
214: , a21 out nocopy JTF_NUMBER_TABLE
215: , a22 out nocopy JTF_NUMBER_TABLE
216: ) as
217: ddindx binary_integer; indx binary_integer;
210: , a17 out nocopy JTF_NUMBER_TABLE
211: , a18 out nocopy JTF_VARCHAR2_TABLE_300
212: , a19 out nocopy JTF_VARCHAR2_TABLE_100
213: , a20 out nocopy JTF_NUMBER_TABLE
214: , a21 out nocopy JTF_NUMBER_TABLE
215: , a22 out nocopy JTF_NUMBER_TABLE
216: ) as
217: ddindx binary_integer; indx binary_integer;
218: begin
211: , a18 out nocopy JTF_VARCHAR2_TABLE_300
212: , a19 out nocopy JTF_VARCHAR2_TABLE_100
213: , a20 out nocopy JTF_NUMBER_TABLE
214: , a21 out nocopy JTF_NUMBER_TABLE
215: , a22 out nocopy JTF_NUMBER_TABLE
216: ) as
217: ddindx binary_integer; indx binary_integer;
218: begin
219: if t is null or t.count = 0 then
216: ) as
217: ddindx binary_integer; indx binary_integer;
218: begin
219: if t is null or t.count = 0 then
220: a0 := JTF_NUMBER_TABLE();
221: a1 := JTF_NUMBER_TABLE();
222: a2 := JTF_VARCHAR2_TABLE_100();
223: a3 := JTF_VARCHAR2_TABLE_100();
224: a4 := JTF_NUMBER_TABLE();
217: ddindx binary_integer; indx binary_integer;
218: begin
219: if t is null or t.count = 0 then
220: a0 := JTF_NUMBER_TABLE();
221: a1 := JTF_NUMBER_TABLE();
222: a2 := JTF_VARCHAR2_TABLE_100();
223: a3 := JTF_VARCHAR2_TABLE_100();
224: a4 := JTF_NUMBER_TABLE();
225: a5 := JTF_NUMBER_TABLE();
220: a0 := JTF_NUMBER_TABLE();
221: a1 := JTF_NUMBER_TABLE();
222: a2 := JTF_VARCHAR2_TABLE_100();
223: a3 := JTF_VARCHAR2_TABLE_100();
224: a4 := JTF_NUMBER_TABLE();
225: a5 := JTF_NUMBER_TABLE();
226: a6 := JTF_VARCHAR2_TABLE_200();
227: a7 := JTF_NUMBER_TABLE();
228: a8 := JTF_VARCHAR2_TABLE_100();
221: a1 := JTF_NUMBER_TABLE();
222: a2 := JTF_VARCHAR2_TABLE_100();
223: a3 := JTF_VARCHAR2_TABLE_100();
224: a4 := JTF_NUMBER_TABLE();
225: a5 := JTF_NUMBER_TABLE();
226: a6 := JTF_VARCHAR2_TABLE_200();
227: a7 := JTF_NUMBER_TABLE();
228: a8 := JTF_VARCHAR2_TABLE_100();
229: a9 := JTF_NUMBER_TABLE();
223: a3 := JTF_VARCHAR2_TABLE_100();
224: a4 := JTF_NUMBER_TABLE();
225: a5 := JTF_NUMBER_TABLE();
226: a6 := JTF_VARCHAR2_TABLE_200();
227: a7 := JTF_NUMBER_TABLE();
228: a8 := JTF_VARCHAR2_TABLE_100();
229: a9 := JTF_NUMBER_TABLE();
230: a10 := JTF_NUMBER_TABLE();
231: a11 := JTF_DATE_TABLE();
225: a5 := JTF_NUMBER_TABLE();
226: a6 := JTF_VARCHAR2_TABLE_200();
227: a7 := JTF_NUMBER_TABLE();
228: a8 := JTF_VARCHAR2_TABLE_100();
229: a9 := JTF_NUMBER_TABLE();
230: a10 := JTF_NUMBER_TABLE();
231: a11 := JTF_DATE_TABLE();
232: a12 := JTF_DATE_TABLE();
233: a13 := JTF_VARCHAR2_TABLE_2000();
226: a6 := JTF_VARCHAR2_TABLE_200();
227: a7 := JTF_NUMBER_TABLE();
228: a8 := JTF_VARCHAR2_TABLE_100();
229: a9 := JTF_NUMBER_TABLE();
230: a10 := JTF_NUMBER_TABLE();
231: a11 := JTF_DATE_TABLE();
232: a12 := JTF_DATE_TABLE();
233: a13 := JTF_VARCHAR2_TABLE_2000();
234: a14 := JTF_VARCHAR2_TABLE_2000();
231: a11 := JTF_DATE_TABLE();
232: a12 := JTF_DATE_TABLE();
233: a13 := JTF_VARCHAR2_TABLE_2000();
234: a14 := JTF_VARCHAR2_TABLE_2000();
235: a15 := JTF_NUMBER_TABLE();
236: a16 := JTF_VARCHAR2_TABLE_100();
237: a17 := JTF_NUMBER_TABLE();
238: a18 := JTF_VARCHAR2_TABLE_300();
239: a19 := JTF_VARCHAR2_TABLE_100();
233: a13 := JTF_VARCHAR2_TABLE_2000();
234: a14 := JTF_VARCHAR2_TABLE_2000();
235: a15 := JTF_NUMBER_TABLE();
236: a16 := JTF_VARCHAR2_TABLE_100();
237: a17 := JTF_NUMBER_TABLE();
238: a18 := JTF_VARCHAR2_TABLE_300();
239: a19 := JTF_VARCHAR2_TABLE_100();
240: a20 := JTF_NUMBER_TABLE();
241: a21 := JTF_NUMBER_TABLE();
236: a16 := JTF_VARCHAR2_TABLE_100();
237: a17 := JTF_NUMBER_TABLE();
238: a18 := JTF_VARCHAR2_TABLE_300();
239: a19 := JTF_VARCHAR2_TABLE_100();
240: a20 := JTF_NUMBER_TABLE();
241: a21 := JTF_NUMBER_TABLE();
242: a22 := JTF_NUMBER_TABLE();
243: else
244: a0 := JTF_NUMBER_TABLE();
237: a17 := JTF_NUMBER_TABLE();
238: a18 := JTF_VARCHAR2_TABLE_300();
239: a19 := JTF_VARCHAR2_TABLE_100();
240: a20 := JTF_NUMBER_TABLE();
241: a21 := JTF_NUMBER_TABLE();
242: a22 := JTF_NUMBER_TABLE();
243: else
244: a0 := JTF_NUMBER_TABLE();
245: a1 := JTF_NUMBER_TABLE();
238: a18 := JTF_VARCHAR2_TABLE_300();
239: a19 := JTF_VARCHAR2_TABLE_100();
240: a20 := JTF_NUMBER_TABLE();
241: a21 := JTF_NUMBER_TABLE();
242: a22 := JTF_NUMBER_TABLE();
243: else
244: a0 := JTF_NUMBER_TABLE();
245: a1 := JTF_NUMBER_TABLE();
246: a2 := JTF_VARCHAR2_TABLE_100();
240: a20 := JTF_NUMBER_TABLE();
241: a21 := JTF_NUMBER_TABLE();
242: a22 := JTF_NUMBER_TABLE();
243: else
244: a0 := JTF_NUMBER_TABLE();
245: a1 := JTF_NUMBER_TABLE();
246: a2 := JTF_VARCHAR2_TABLE_100();
247: a3 := JTF_VARCHAR2_TABLE_100();
248: a4 := JTF_NUMBER_TABLE();
241: a21 := JTF_NUMBER_TABLE();
242: a22 := JTF_NUMBER_TABLE();
243: else
244: a0 := JTF_NUMBER_TABLE();
245: a1 := JTF_NUMBER_TABLE();
246: a2 := JTF_VARCHAR2_TABLE_100();
247: a3 := JTF_VARCHAR2_TABLE_100();
248: a4 := JTF_NUMBER_TABLE();
249: a5 := JTF_NUMBER_TABLE();
244: a0 := JTF_NUMBER_TABLE();
245: a1 := JTF_NUMBER_TABLE();
246: a2 := JTF_VARCHAR2_TABLE_100();
247: a3 := JTF_VARCHAR2_TABLE_100();
248: a4 := JTF_NUMBER_TABLE();
249: a5 := JTF_NUMBER_TABLE();
250: a6 := JTF_VARCHAR2_TABLE_200();
251: a7 := JTF_NUMBER_TABLE();
252: a8 := JTF_VARCHAR2_TABLE_100();
245: a1 := JTF_NUMBER_TABLE();
246: a2 := JTF_VARCHAR2_TABLE_100();
247: a3 := JTF_VARCHAR2_TABLE_100();
248: a4 := JTF_NUMBER_TABLE();
249: a5 := JTF_NUMBER_TABLE();
250: a6 := JTF_VARCHAR2_TABLE_200();
251: a7 := JTF_NUMBER_TABLE();
252: a8 := JTF_VARCHAR2_TABLE_100();
253: a9 := JTF_NUMBER_TABLE();
247: a3 := JTF_VARCHAR2_TABLE_100();
248: a4 := JTF_NUMBER_TABLE();
249: a5 := JTF_NUMBER_TABLE();
250: a6 := JTF_VARCHAR2_TABLE_200();
251: a7 := JTF_NUMBER_TABLE();
252: a8 := JTF_VARCHAR2_TABLE_100();
253: a9 := JTF_NUMBER_TABLE();
254: a10 := JTF_NUMBER_TABLE();
255: a11 := JTF_DATE_TABLE();
249: a5 := JTF_NUMBER_TABLE();
250: a6 := JTF_VARCHAR2_TABLE_200();
251: a7 := JTF_NUMBER_TABLE();
252: a8 := JTF_VARCHAR2_TABLE_100();
253: a9 := JTF_NUMBER_TABLE();
254: a10 := JTF_NUMBER_TABLE();
255: a11 := JTF_DATE_TABLE();
256: a12 := JTF_DATE_TABLE();
257: a13 := JTF_VARCHAR2_TABLE_2000();
250: a6 := JTF_VARCHAR2_TABLE_200();
251: a7 := JTF_NUMBER_TABLE();
252: a8 := JTF_VARCHAR2_TABLE_100();
253: a9 := JTF_NUMBER_TABLE();
254: a10 := JTF_NUMBER_TABLE();
255: a11 := JTF_DATE_TABLE();
256: a12 := JTF_DATE_TABLE();
257: a13 := JTF_VARCHAR2_TABLE_2000();
258: a14 := JTF_VARCHAR2_TABLE_2000();
255: a11 := JTF_DATE_TABLE();
256: a12 := JTF_DATE_TABLE();
257: a13 := JTF_VARCHAR2_TABLE_2000();
258: a14 := JTF_VARCHAR2_TABLE_2000();
259: a15 := JTF_NUMBER_TABLE();
260: a16 := JTF_VARCHAR2_TABLE_100();
261: a17 := JTF_NUMBER_TABLE();
262: a18 := JTF_VARCHAR2_TABLE_300();
263: a19 := JTF_VARCHAR2_TABLE_100();
257: a13 := JTF_VARCHAR2_TABLE_2000();
258: a14 := JTF_VARCHAR2_TABLE_2000();
259: a15 := JTF_NUMBER_TABLE();
260: a16 := JTF_VARCHAR2_TABLE_100();
261: a17 := JTF_NUMBER_TABLE();
262: a18 := JTF_VARCHAR2_TABLE_300();
263: a19 := JTF_VARCHAR2_TABLE_100();
264: a20 := JTF_NUMBER_TABLE();
265: a21 := JTF_NUMBER_TABLE();
260: a16 := JTF_VARCHAR2_TABLE_100();
261: a17 := JTF_NUMBER_TABLE();
262: a18 := JTF_VARCHAR2_TABLE_300();
263: a19 := JTF_VARCHAR2_TABLE_100();
264: a20 := JTF_NUMBER_TABLE();
265: a21 := JTF_NUMBER_TABLE();
266: a22 := JTF_NUMBER_TABLE();
267: if t.count > 0 then
268: a0.extend(t.count);
261: a17 := JTF_NUMBER_TABLE();
262: a18 := JTF_VARCHAR2_TABLE_300();
263: a19 := JTF_VARCHAR2_TABLE_100();
264: a20 := JTF_NUMBER_TABLE();
265: a21 := JTF_NUMBER_TABLE();
266: a22 := JTF_NUMBER_TABLE();
267: if t.count > 0 then
268: a0.extend(t.count);
269: a1.extend(t.count);
262: a18 := JTF_VARCHAR2_TABLE_300();
263: a19 := JTF_VARCHAR2_TABLE_100();
264: a20 := JTF_NUMBER_TABLE();
265: a21 := JTF_NUMBER_TABLE();
266: a22 := JTF_NUMBER_TABLE();
267: if t.count > 0 then
268: a0.extend(t.count);
269: a1.extend(t.count);
270: a2.extend(t.count);
332: , x_msg_data out nocopy VARCHAR2
333: , p_resourceid in out nocopy NUMBER
334: , p_resourcetype in out nocopy VARCHAR2
335: , p_userid NUMBER
336: , p9_a0 out nocopy JTF_NUMBER_TABLE
337: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
338: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_400
339: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
340: )
396: , p6_a3 NUMBER
397: , p6_a4 VARCHAR2
398: , p6_a5 DATE
399: , p6_a6 NUMBER
400: , p7_a0 out nocopy JTF_NUMBER_TABLE
401: , p7_a1 out nocopy JTF_NUMBER_TABLE
402: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
403: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
404: , p7_a4 out nocopy JTF_NUMBER_TABLE
397: , p6_a4 VARCHAR2
398: , p6_a5 DATE
399: , p6_a6 NUMBER
400: , p7_a0 out nocopy JTF_NUMBER_TABLE
401: , p7_a1 out nocopy JTF_NUMBER_TABLE
402: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
403: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
404: , p7_a4 out nocopy JTF_NUMBER_TABLE
405: , p7_a5 out nocopy JTF_NUMBER_TABLE
400: , p7_a0 out nocopy JTF_NUMBER_TABLE
401: , p7_a1 out nocopy JTF_NUMBER_TABLE
402: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
403: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
404: , p7_a4 out nocopy JTF_NUMBER_TABLE
405: , p7_a5 out nocopy JTF_NUMBER_TABLE
406: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_200
407: , p7_a7 out nocopy JTF_NUMBER_TABLE
408: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
401: , p7_a1 out nocopy JTF_NUMBER_TABLE
402: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
403: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
404: , p7_a4 out nocopy JTF_NUMBER_TABLE
405: , p7_a5 out nocopy JTF_NUMBER_TABLE
406: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_200
407: , p7_a7 out nocopy JTF_NUMBER_TABLE
408: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
409: , p7_a9 out nocopy JTF_NUMBER_TABLE
403: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
404: , p7_a4 out nocopy JTF_NUMBER_TABLE
405: , p7_a5 out nocopy JTF_NUMBER_TABLE
406: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_200
407: , p7_a7 out nocopy JTF_NUMBER_TABLE
408: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
409: , p7_a9 out nocopy JTF_NUMBER_TABLE
410: , p7_a10 out nocopy JTF_NUMBER_TABLE
411: , p7_a11 out nocopy JTF_DATE_TABLE
405: , p7_a5 out nocopy JTF_NUMBER_TABLE
406: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_200
407: , p7_a7 out nocopy JTF_NUMBER_TABLE
408: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
409: , p7_a9 out nocopy JTF_NUMBER_TABLE
410: , p7_a10 out nocopy JTF_NUMBER_TABLE
411: , p7_a11 out nocopy JTF_DATE_TABLE
412: , p7_a12 out nocopy JTF_DATE_TABLE
413: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_2000
406: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_200
407: , p7_a7 out nocopy JTF_NUMBER_TABLE
408: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
409: , p7_a9 out nocopy JTF_NUMBER_TABLE
410: , p7_a10 out nocopy JTF_NUMBER_TABLE
411: , p7_a11 out nocopy JTF_DATE_TABLE
412: , p7_a12 out nocopy JTF_DATE_TABLE
413: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_2000
414: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_2000
411: , p7_a11 out nocopy JTF_DATE_TABLE
412: , p7_a12 out nocopy JTF_DATE_TABLE
413: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_2000
414: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_2000
415: , p7_a15 out nocopy JTF_NUMBER_TABLE
416: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
417: , p7_a17 out nocopy JTF_NUMBER_TABLE
418: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_300
419: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
413: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_2000
414: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_2000
415: , p7_a15 out nocopy JTF_NUMBER_TABLE
416: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
417: , p7_a17 out nocopy JTF_NUMBER_TABLE
418: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_300
419: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
420: , p7_a20 out nocopy JTF_NUMBER_TABLE
421: , p7_a21 out nocopy JTF_NUMBER_TABLE
416: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
417: , p7_a17 out nocopy JTF_NUMBER_TABLE
418: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_300
419: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
420: , p7_a20 out nocopy JTF_NUMBER_TABLE
421: , p7_a21 out nocopy JTF_NUMBER_TABLE
422: , p7_a22 out nocopy JTF_NUMBER_TABLE
423: , p8_a0 out nocopy NUMBER
424: , p8_a1 out nocopy VARCHAR2
417: , p7_a17 out nocopy JTF_NUMBER_TABLE
418: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_300
419: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
420: , p7_a20 out nocopy JTF_NUMBER_TABLE
421: , p7_a21 out nocopy JTF_NUMBER_TABLE
422: , p7_a22 out nocopy JTF_NUMBER_TABLE
423: , p8_a0 out nocopy NUMBER
424: , p8_a1 out nocopy VARCHAR2
425: , p8_a2 out nocopy VARCHAR2
418: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_300
419: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
420: , p7_a20 out nocopy JTF_NUMBER_TABLE
421: , p7_a21 out nocopy JTF_NUMBER_TABLE
422: , p7_a22 out nocopy JTF_NUMBER_TABLE
423: , p8_a0 out nocopy NUMBER
424: , p8_a1 out nocopy VARCHAR2
425: , p8_a2 out nocopy VARCHAR2
426: , p8_a3 out nocopy VARCHAR2