18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p9(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.new_rule_param_tbl, a0 JTF_VARCHAR2_TABLE_100
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_100
25: ) as
26: ddindx binary_integer; indx binary_integer;
19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p9(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.new_rule_param_tbl, a0 JTF_VARCHAR2_TABLE_100
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_100
25: ) as
26: ddindx binary_integer; indx binary_integer;
27: begin
20: end;
21:
22: procedure rosetta_table_copy_in_p9(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.new_rule_param_tbl, a0 JTF_VARCHAR2_TABLE_100
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_100
25: ) as
26: ddindx binary_integer; indx binary_integer;
27: begin
28: if a0 is not null and a0.count > 0 then
41: end loop;
42: end if;
43: end if;
44: end rosetta_table_copy_in_p9;
45: procedure rosetta_table_copy_out_p9(t jtf_dpf.new_rule_param_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
46: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
47: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
48: ) as
49: ddindx binary_integer; indx binary_integer;
42: end if;
43: end if;
44: end rosetta_table_copy_in_p9;
45: procedure rosetta_table_copy_out_p9(t jtf_dpf.new_rule_param_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
46: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
47: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
48: ) as
49: ddindx binary_integer; indx binary_integer;
50: begin
43: end if;
44: end rosetta_table_copy_in_p9;
45: procedure rosetta_table_copy_out_p9(t jtf_dpf.new_rule_param_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
46: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
47: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
48: ) as
49: ddindx binary_integer; indx binary_integer;
50: begin
51: if t is null or t.count = 0 then
48: ) as
49: ddindx binary_integer; indx binary_integer;
50: begin
51: if t is null or t.count = 0 then
52: a0 := JTF_VARCHAR2_TABLE_100();
53: a1 := JTF_VARCHAR2_TABLE_100();
54: a2 := JTF_VARCHAR2_TABLE_100();
55: else
56: a0 := JTF_VARCHAR2_TABLE_100();
49: ddindx binary_integer; indx binary_integer;
50: begin
51: if t is null or t.count = 0 then
52: a0 := JTF_VARCHAR2_TABLE_100();
53: a1 := JTF_VARCHAR2_TABLE_100();
54: a2 := JTF_VARCHAR2_TABLE_100();
55: else
56: a0 := JTF_VARCHAR2_TABLE_100();
57: a1 := JTF_VARCHAR2_TABLE_100();
50: begin
51: if t is null or t.count = 0 then
52: a0 := JTF_VARCHAR2_TABLE_100();
53: a1 := JTF_VARCHAR2_TABLE_100();
54: a2 := JTF_VARCHAR2_TABLE_100();
55: else
56: a0 := JTF_VARCHAR2_TABLE_100();
57: a1 := JTF_VARCHAR2_TABLE_100();
58: a2 := JTF_VARCHAR2_TABLE_100();
52: a0 := JTF_VARCHAR2_TABLE_100();
53: a1 := JTF_VARCHAR2_TABLE_100();
54: a2 := JTF_VARCHAR2_TABLE_100();
55: else
56: a0 := JTF_VARCHAR2_TABLE_100();
57: a1 := JTF_VARCHAR2_TABLE_100();
58: a2 := JTF_VARCHAR2_TABLE_100();
59: if t.count > 0 then
60: a0.extend(t.count);
53: a1 := JTF_VARCHAR2_TABLE_100();
54: a2 := JTF_VARCHAR2_TABLE_100();
55: else
56: a0 := JTF_VARCHAR2_TABLE_100();
57: a1 := JTF_VARCHAR2_TABLE_100();
58: a2 := JTF_VARCHAR2_TABLE_100();
59: if t.count > 0 then
60: a0.extend(t.count);
61: a1.extend(t.count);
54: a2 := JTF_VARCHAR2_TABLE_100();
55: else
56: a0 := JTF_VARCHAR2_TABLE_100();
57: a1 := JTF_VARCHAR2_TABLE_100();
58: a2 := JTF_VARCHAR2_TABLE_100();
59: if t.count > 0 then
60: a0.extend(t.count);
61: a1.extend(t.count);
62: a2.extend(t.count);
175: end if;
176: end if;
177: end rosetta_table_copy_out_p13;
178:
179: procedure rosetta_table_copy_in_p15(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.new_phys_attribs_tbl, a0 JTF_VARCHAR2_TABLE_100
180: , a1 JTF_VARCHAR2_TABLE_300
181: ) as
182: ddindx binary_integer; indx binary_integer;
183: begin
196: end loop;
197: end if;
198: end if;
199: end rosetta_table_copy_in_p15;
200: procedure rosetta_table_copy_out_p15(t jtf_dpf.new_phys_attribs_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
201: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
202: ) as
203: ddindx binary_integer; indx binary_integer;
204: begin
202: ) as
203: ddindx binary_integer; indx binary_integer;
204: begin
205: if t is null or t.count = 0 then
206: a0 := JTF_VARCHAR2_TABLE_100();
207: a1 := JTF_VARCHAR2_TABLE_300();
208: else
209: a0 := JTF_VARCHAR2_TABLE_100();
210: a1 := JTF_VARCHAR2_TABLE_300();
205: if t is null or t.count = 0 then
206: a0 := JTF_VARCHAR2_TABLE_100();
207: a1 := JTF_VARCHAR2_TABLE_300();
208: else
209: a0 := JTF_VARCHAR2_TABLE_100();
210: a1 := JTF_VARCHAR2_TABLE_300();
211: if t.count > 0 then
212: a0.extend(t.count);
213: a1.extend(t.count);
226: end if;
227: end rosetta_table_copy_out_p15;
228:
229: procedure rosetta_table_copy_in_p16(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.dpf_tbl, a0 JTF_NUMBER_TABLE
230: , a1 JTF_VARCHAR2_TABLE_100
231: , a2 JTF_VARCHAR2_TABLE_100
232: , a3 JTF_VARCHAR2_TABLE_100
233: , a4 JTF_VARCHAR2_TABLE_100
234: , a5 JTF_VARCHAR2_TABLE_100
227: end rosetta_table_copy_out_p15;
228:
229: procedure rosetta_table_copy_in_p16(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.dpf_tbl, a0 JTF_NUMBER_TABLE
230: , a1 JTF_VARCHAR2_TABLE_100
231: , a2 JTF_VARCHAR2_TABLE_100
232: , a3 JTF_VARCHAR2_TABLE_100
233: , a4 JTF_VARCHAR2_TABLE_100
234: , a5 JTF_VARCHAR2_TABLE_100
235: , a6 JTF_VARCHAR2_TABLE_200
228:
229: procedure rosetta_table_copy_in_p16(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.dpf_tbl, a0 JTF_NUMBER_TABLE
230: , a1 JTF_VARCHAR2_TABLE_100
231: , a2 JTF_VARCHAR2_TABLE_100
232: , a3 JTF_VARCHAR2_TABLE_100
233: , a4 JTF_VARCHAR2_TABLE_100
234: , a5 JTF_VARCHAR2_TABLE_100
235: , a6 JTF_VARCHAR2_TABLE_200
236: , a7 JTF_VARCHAR2_TABLE_100
229: procedure rosetta_table_copy_in_p16(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.dpf_tbl, a0 JTF_NUMBER_TABLE
230: , a1 JTF_VARCHAR2_TABLE_100
231: , a2 JTF_VARCHAR2_TABLE_100
232: , a3 JTF_VARCHAR2_TABLE_100
233: , a4 JTF_VARCHAR2_TABLE_100
234: , a5 JTF_VARCHAR2_TABLE_100
235: , a6 JTF_VARCHAR2_TABLE_200
236: , a7 JTF_VARCHAR2_TABLE_100
237: , a8 JTF_VARCHAR2_TABLE_100
230: , a1 JTF_VARCHAR2_TABLE_100
231: , a2 JTF_VARCHAR2_TABLE_100
232: , a3 JTF_VARCHAR2_TABLE_100
233: , a4 JTF_VARCHAR2_TABLE_100
234: , a5 JTF_VARCHAR2_TABLE_100
235: , a6 JTF_VARCHAR2_TABLE_200
236: , a7 JTF_VARCHAR2_TABLE_100
237: , a8 JTF_VARCHAR2_TABLE_100
238: , a9 JTF_VARCHAR2_TABLE_100
232: , a3 JTF_VARCHAR2_TABLE_100
233: , a4 JTF_VARCHAR2_TABLE_100
234: , a5 JTF_VARCHAR2_TABLE_100
235: , a6 JTF_VARCHAR2_TABLE_200
236: , a7 JTF_VARCHAR2_TABLE_100
237: , a8 JTF_VARCHAR2_TABLE_100
238: , a9 JTF_VARCHAR2_TABLE_100
239: , a10 JTF_VARCHAR2_TABLE_100
240: , a11 JTF_VARCHAR2_TABLE_100
233: , a4 JTF_VARCHAR2_TABLE_100
234: , a5 JTF_VARCHAR2_TABLE_100
235: , a6 JTF_VARCHAR2_TABLE_200
236: , a7 JTF_VARCHAR2_TABLE_100
237: , a8 JTF_VARCHAR2_TABLE_100
238: , a9 JTF_VARCHAR2_TABLE_100
239: , a10 JTF_VARCHAR2_TABLE_100
240: , a11 JTF_VARCHAR2_TABLE_100
241: ) as
234: , a5 JTF_VARCHAR2_TABLE_100
235: , a6 JTF_VARCHAR2_TABLE_200
236: , a7 JTF_VARCHAR2_TABLE_100
237: , a8 JTF_VARCHAR2_TABLE_100
238: , a9 JTF_VARCHAR2_TABLE_100
239: , a10 JTF_VARCHAR2_TABLE_100
240: , a11 JTF_VARCHAR2_TABLE_100
241: ) as
242: ddindx binary_integer; indx binary_integer;
235: , a6 JTF_VARCHAR2_TABLE_200
236: , a7 JTF_VARCHAR2_TABLE_100
237: , a8 JTF_VARCHAR2_TABLE_100
238: , a9 JTF_VARCHAR2_TABLE_100
239: , a10 JTF_VARCHAR2_TABLE_100
240: , a11 JTF_VARCHAR2_TABLE_100
241: ) as
242: ddindx binary_integer; indx binary_integer;
243: begin
236: , a7 JTF_VARCHAR2_TABLE_100
237: , a8 JTF_VARCHAR2_TABLE_100
238: , a9 JTF_VARCHAR2_TABLE_100
239: , a10 JTF_VARCHAR2_TABLE_100
240: , a11 JTF_VARCHAR2_TABLE_100
241: ) as
242: ddindx binary_integer; indx binary_integer;
243: begin
244: if a0 is not null and a0.count > 0 then
267: end if;
268: end if;
269: end rosetta_table_copy_in_p16;
270: procedure rosetta_table_copy_out_p16(t jtf_dpf.dpf_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
271: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
272: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
273: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
274: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
275: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
268: end if;
269: end rosetta_table_copy_in_p16;
270: procedure rosetta_table_copy_out_p16(t jtf_dpf.dpf_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
271: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
272: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
273: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
274: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
275: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
276: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
269: end rosetta_table_copy_in_p16;
270: procedure rosetta_table_copy_out_p16(t jtf_dpf.dpf_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
271: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
272: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
273: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
274: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
275: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
276: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
277: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
270: procedure rosetta_table_copy_out_p16(t jtf_dpf.dpf_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
271: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
272: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
273: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
274: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
275: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
276: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
277: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
278: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
271: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
272: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
273: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
274: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
275: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
276: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
277: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
278: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
279: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
273: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
274: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
275: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
276: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
277: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
278: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
279: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
280: , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
281: , a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
274: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
275: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
276: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
277: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
278: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
279: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
280: , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
281: , a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
282: ) as
275: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
276: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
277: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
278: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
279: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
280: , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
281: , a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
282: ) as
283: ddindx binary_integer; indx binary_integer;
276: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
277: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
278: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
279: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
280: , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
281: , a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
282: ) as
283: ddindx binary_integer; indx binary_integer;
284: begin
277: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
278: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
279: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
280: , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
281: , a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
282: ) as
283: ddindx binary_integer; indx binary_integer;
284: begin
285: if t is null or t.count = 0 then
283: ddindx binary_integer; indx binary_integer;
284: begin
285: if t is null or t.count = 0 then
286: a0 := JTF_NUMBER_TABLE();
287: a1 := JTF_VARCHAR2_TABLE_100();
288: a2 := JTF_VARCHAR2_TABLE_100();
289: a3 := JTF_VARCHAR2_TABLE_100();
290: a4 := JTF_VARCHAR2_TABLE_100();
291: a5 := JTF_VARCHAR2_TABLE_100();
284: begin
285: if t is null or t.count = 0 then
286: a0 := JTF_NUMBER_TABLE();
287: a1 := JTF_VARCHAR2_TABLE_100();
288: a2 := JTF_VARCHAR2_TABLE_100();
289: a3 := JTF_VARCHAR2_TABLE_100();
290: a4 := JTF_VARCHAR2_TABLE_100();
291: a5 := JTF_VARCHAR2_TABLE_100();
292: a6 := JTF_VARCHAR2_TABLE_200();
285: if t is null or t.count = 0 then
286: a0 := JTF_NUMBER_TABLE();
287: a1 := JTF_VARCHAR2_TABLE_100();
288: a2 := JTF_VARCHAR2_TABLE_100();
289: a3 := JTF_VARCHAR2_TABLE_100();
290: a4 := JTF_VARCHAR2_TABLE_100();
291: a5 := JTF_VARCHAR2_TABLE_100();
292: a6 := JTF_VARCHAR2_TABLE_200();
293: a7 := JTF_VARCHAR2_TABLE_100();
286: a0 := JTF_NUMBER_TABLE();
287: a1 := JTF_VARCHAR2_TABLE_100();
288: a2 := JTF_VARCHAR2_TABLE_100();
289: a3 := JTF_VARCHAR2_TABLE_100();
290: a4 := JTF_VARCHAR2_TABLE_100();
291: a5 := JTF_VARCHAR2_TABLE_100();
292: a6 := JTF_VARCHAR2_TABLE_200();
293: a7 := JTF_VARCHAR2_TABLE_100();
294: a8 := JTF_VARCHAR2_TABLE_100();
287: a1 := JTF_VARCHAR2_TABLE_100();
288: a2 := JTF_VARCHAR2_TABLE_100();
289: a3 := JTF_VARCHAR2_TABLE_100();
290: a4 := JTF_VARCHAR2_TABLE_100();
291: a5 := JTF_VARCHAR2_TABLE_100();
292: a6 := JTF_VARCHAR2_TABLE_200();
293: a7 := JTF_VARCHAR2_TABLE_100();
294: a8 := JTF_VARCHAR2_TABLE_100();
295: a9 := JTF_VARCHAR2_TABLE_100();
289: a3 := JTF_VARCHAR2_TABLE_100();
290: a4 := JTF_VARCHAR2_TABLE_100();
291: a5 := JTF_VARCHAR2_TABLE_100();
292: a6 := JTF_VARCHAR2_TABLE_200();
293: a7 := JTF_VARCHAR2_TABLE_100();
294: a8 := JTF_VARCHAR2_TABLE_100();
295: a9 := JTF_VARCHAR2_TABLE_100();
296: a10 := JTF_VARCHAR2_TABLE_100();
297: a11 := JTF_VARCHAR2_TABLE_100();
290: a4 := JTF_VARCHAR2_TABLE_100();
291: a5 := JTF_VARCHAR2_TABLE_100();
292: a6 := JTF_VARCHAR2_TABLE_200();
293: a7 := JTF_VARCHAR2_TABLE_100();
294: a8 := JTF_VARCHAR2_TABLE_100();
295: a9 := JTF_VARCHAR2_TABLE_100();
296: a10 := JTF_VARCHAR2_TABLE_100();
297: a11 := JTF_VARCHAR2_TABLE_100();
298: else
291: a5 := JTF_VARCHAR2_TABLE_100();
292: a6 := JTF_VARCHAR2_TABLE_200();
293: a7 := JTF_VARCHAR2_TABLE_100();
294: a8 := JTF_VARCHAR2_TABLE_100();
295: a9 := JTF_VARCHAR2_TABLE_100();
296: a10 := JTF_VARCHAR2_TABLE_100();
297: a11 := JTF_VARCHAR2_TABLE_100();
298: else
299: a0 := JTF_NUMBER_TABLE();
292: a6 := JTF_VARCHAR2_TABLE_200();
293: a7 := JTF_VARCHAR2_TABLE_100();
294: a8 := JTF_VARCHAR2_TABLE_100();
295: a9 := JTF_VARCHAR2_TABLE_100();
296: a10 := JTF_VARCHAR2_TABLE_100();
297: a11 := JTF_VARCHAR2_TABLE_100();
298: else
299: a0 := JTF_NUMBER_TABLE();
300: a1 := JTF_VARCHAR2_TABLE_100();
293: a7 := JTF_VARCHAR2_TABLE_100();
294: a8 := JTF_VARCHAR2_TABLE_100();
295: a9 := JTF_VARCHAR2_TABLE_100();
296: a10 := JTF_VARCHAR2_TABLE_100();
297: a11 := JTF_VARCHAR2_TABLE_100();
298: else
299: a0 := JTF_NUMBER_TABLE();
300: a1 := JTF_VARCHAR2_TABLE_100();
301: a2 := JTF_VARCHAR2_TABLE_100();
296: a10 := JTF_VARCHAR2_TABLE_100();
297: a11 := JTF_VARCHAR2_TABLE_100();
298: else
299: a0 := JTF_NUMBER_TABLE();
300: a1 := JTF_VARCHAR2_TABLE_100();
301: a2 := JTF_VARCHAR2_TABLE_100();
302: a3 := JTF_VARCHAR2_TABLE_100();
303: a4 := JTF_VARCHAR2_TABLE_100();
304: a5 := JTF_VARCHAR2_TABLE_100();
297: a11 := JTF_VARCHAR2_TABLE_100();
298: else
299: a0 := JTF_NUMBER_TABLE();
300: a1 := JTF_VARCHAR2_TABLE_100();
301: a2 := JTF_VARCHAR2_TABLE_100();
302: a3 := JTF_VARCHAR2_TABLE_100();
303: a4 := JTF_VARCHAR2_TABLE_100();
304: a5 := JTF_VARCHAR2_TABLE_100();
305: a6 := JTF_VARCHAR2_TABLE_200();
298: else
299: a0 := JTF_NUMBER_TABLE();
300: a1 := JTF_VARCHAR2_TABLE_100();
301: a2 := JTF_VARCHAR2_TABLE_100();
302: a3 := JTF_VARCHAR2_TABLE_100();
303: a4 := JTF_VARCHAR2_TABLE_100();
304: a5 := JTF_VARCHAR2_TABLE_100();
305: a6 := JTF_VARCHAR2_TABLE_200();
306: a7 := JTF_VARCHAR2_TABLE_100();
299: a0 := JTF_NUMBER_TABLE();
300: a1 := JTF_VARCHAR2_TABLE_100();
301: a2 := JTF_VARCHAR2_TABLE_100();
302: a3 := JTF_VARCHAR2_TABLE_100();
303: a4 := JTF_VARCHAR2_TABLE_100();
304: a5 := JTF_VARCHAR2_TABLE_100();
305: a6 := JTF_VARCHAR2_TABLE_200();
306: a7 := JTF_VARCHAR2_TABLE_100();
307: a8 := JTF_VARCHAR2_TABLE_100();
300: a1 := JTF_VARCHAR2_TABLE_100();
301: a2 := JTF_VARCHAR2_TABLE_100();
302: a3 := JTF_VARCHAR2_TABLE_100();
303: a4 := JTF_VARCHAR2_TABLE_100();
304: a5 := JTF_VARCHAR2_TABLE_100();
305: a6 := JTF_VARCHAR2_TABLE_200();
306: a7 := JTF_VARCHAR2_TABLE_100();
307: a8 := JTF_VARCHAR2_TABLE_100();
308: a9 := JTF_VARCHAR2_TABLE_100();
302: a3 := JTF_VARCHAR2_TABLE_100();
303: a4 := JTF_VARCHAR2_TABLE_100();
304: a5 := JTF_VARCHAR2_TABLE_100();
305: a6 := JTF_VARCHAR2_TABLE_200();
306: a7 := JTF_VARCHAR2_TABLE_100();
307: a8 := JTF_VARCHAR2_TABLE_100();
308: a9 := JTF_VARCHAR2_TABLE_100();
309: a10 := JTF_VARCHAR2_TABLE_100();
310: a11 := JTF_VARCHAR2_TABLE_100();
303: a4 := JTF_VARCHAR2_TABLE_100();
304: a5 := JTF_VARCHAR2_TABLE_100();
305: a6 := JTF_VARCHAR2_TABLE_200();
306: a7 := JTF_VARCHAR2_TABLE_100();
307: a8 := JTF_VARCHAR2_TABLE_100();
308: a9 := JTF_VARCHAR2_TABLE_100();
309: a10 := JTF_VARCHAR2_TABLE_100();
310: a11 := JTF_VARCHAR2_TABLE_100();
311: if t.count > 0 then
304: a5 := JTF_VARCHAR2_TABLE_100();
305: a6 := JTF_VARCHAR2_TABLE_200();
306: a7 := JTF_VARCHAR2_TABLE_100();
307: a8 := JTF_VARCHAR2_TABLE_100();
308: a9 := JTF_VARCHAR2_TABLE_100();
309: a10 := JTF_VARCHAR2_TABLE_100();
310: a11 := JTF_VARCHAR2_TABLE_100();
311: if t.count > 0 then
312: a0.extend(t.count);
305: a6 := JTF_VARCHAR2_TABLE_200();
306: a7 := JTF_VARCHAR2_TABLE_100();
307: a8 := JTF_VARCHAR2_TABLE_100();
308: a9 := JTF_VARCHAR2_TABLE_100();
309: a10 := JTF_VARCHAR2_TABLE_100();
310: a11 := JTF_VARCHAR2_TABLE_100();
311: if t.count > 0 then
312: a0.extend(t.count);
313: a1.extend(t.count);
306: a7 := JTF_VARCHAR2_TABLE_100();
307: a8 := JTF_VARCHAR2_TABLE_100();
308: a9 := JTF_VARCHAR2_TABLE_100();
309: a10 := JTF_VARCHAR2_TABLE_100();
310: a11 := JTF_VARCHAR2_TABLE_100();
311: if t.count > 0 then
312: a0.extend(t.count);
313: a1.extend(t.count);
314: a2.extend(t.count);
346: end if;
347: end rosetta_table_copy_out_p16;
348:
349: procedure rosetta_table_copy_in_p17(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.logical_tbl, a0 JTF_NUMBER_TABLE
350: , a1 JTF_VARCHAR2_TABLE_100
351: , a2 JTF_VARCHAR2_TABLE_100
352: , a3 JTF_VARCHAR2_TABLE_100
353: , a4 JTF_VARCHAR2_TABLE_200
354: , a5 JTF_VARCHAR2_TABLE_300
347: end rosetta_table_copy_out_p16;
348:
349: procedure rosetta_table_copy_in_p17(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.logical_tbl, a0 JTF_NUMBER_TABLE
350: , a1 JTF_VARCHAR2_TABLE_100
351: , a2 JTF_VARCHAR2_TABLE_100
352: , a3 JTF_VARCHAR2_TABLE_100
353: , a4 JTF_VARCHAR2_TABLE_200
354: , a5 JTF_VARCHAR2_TABLE_300
355: , a6 JTF_VARCHAR2_TABLE_100
348:
349: procedure rosetta_table_copy_in_p17(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.logical_tbl, a0 JTF_NUMBER_TABLE
350: , a1 JTF_VARCHAR2_TABLE_100
351: , a2 JTF_VARCHAR2_TABLE_100
352: , a3 JTF_VARCHAR2_TABLE_100
353: , a4 JTF_VARCHAR2_TABLE_200
354: , a5 JTF_VARCHAR2_TABLE_300
355: , a6 JTF_VARCHAR2_TABLE_100
356: , a7 JTF_NUMBER_TABLE
351: , a2 JTF_VARCHAR2_TABLE_100
352: , a3 JTF_VARCHAR2_TABLE_100
353: , a4 JTF_VARCHAR2_TABLE_200
354: , a5 JTF_VARCHAR2_TABLE_300
355: , a6 JTF_VARCHAR2_TABLE_100
356: , a7 JTF_NUMBER_TABLE
357: , a8 JTF_VARCHAR2_TABLE_100
358: ) as
359: ddindx binary_integer; indx binary_integer;
353: , a4 JTF_VARCHAR2_TABLE_200
354: , a5 JTF_VARCHAR2_TABLE_300
355: , a6 JTF_VARCHAR2_TABLE_100
356: , a7 JTF_NUMBER_TABLE
357: , a8 JTF_VARCHAR2_TABLE_100
358: ) as
359: ddindx binary_integer; indx binary_integer;
360: begin
361: if a0 is not null and a0.count > 0 then
381: end if;
382: end if;
383: end rosetta_table_copy_in_p17;
384: procedure rosetta_table_copy_out_p17(t jtf_dpf.logical_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
385: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
386: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
387: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
388: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
389: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
382: end if;
383: end rosetta_table_copy_in_p17;
384: procedure rosetta_table_copy_out_p17(t jtf_dpf.logical_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
385: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
386: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
387: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
388: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
389: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
390: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
383: end rosetta_table_copy_in_p17;
384: procedure rosetta_table_copy_out_p17(t jtf_dpf.logical_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
385: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
386: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
387: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
388: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
389: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
390: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
391: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
386: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
387: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
388: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
389: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
390: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
391: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
392: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
393: ) as
394: ddindx binary_integer; indx binary_integer;
388: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
389: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
390: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
391: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
392: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
393: ) as
394: ddindx binary_integer; indx binary_integer;
395: begin
396: if t is null or t.count = 0 then
394: ddindx binary_integer; indx binary_integer;
395: begin
396: if t is null or t.count = 0 then
397: a0 := JTF_NUMBER_TABLE();
398: a1 := JTF_VARCHAR2_TABLE_100();
399: a2 := JTF_VARCHAR2_TABLE_100();
400: a3 := JTF_VARCHAR2_TABLE_100();
401: a4 := JTF_VARCHAR2_TABLE_200();
402: a5 := JTF_VARCHAR2_TABLE_300();
395: begin
396: if t is null or t.count = 0 then
397: a0 := JTF_NUMBER_TABLE();
398: a1 := JTF_VARCHAR2_TABLE_100();
399: a2 := JTF_VARCHAR2_TABLE_100();
400: a3 := JTF_VARCHAR2_TABLE_100();
401: a4 := JTF_VARCHAR2_TABLE_200();
402: a5 := JTF_VARCHAR2_TABLE_300();
403: a6 := JTF_VARCHAR2_TABLE_100();
396: if t is null or t.count = 0 then
397: a0 := JTF_NUMBER_TABLE();
398: a1 := JTF_VARCHAR2_TABLE_100();
399: a2 := JTF_VARCHAR2_TABLE_100();
400: a3 := JTF_VARCHAR2_TABLE_100();
401: a4 := JTF_VARCHAR2_TABLE_200();
402: a5 := JTF_VARCHAR2_TABLE_300();
403: a6 := JTF_VARCHAR2_TABLE_100();
404: a7 := JTF_NUMBER_TABLE();
399: a2 := JTF_VARCHAR2_TABLE_100();
400: a3 := JTF_VARCHAR2_TABLE_100();
401: a4 := JTF_VARCHAR2_TABLE_200();
402: a5 := JTF_VARCHAR2_TABLE_300();
403: a6 := JTF_VARCHAR2_TABLE_100();
404: a7 := JTF_NUMBER_TABLE();
405: a8 := JTF_VARCHAR2_TABLE_100();
406: else
407: a0 := JTF_NUMBER_TABLE();
401: a4 := JTF_VARCHAR2_TABLE_200();
402: a5 := JTF_VARCHAR2_TABLE_300();
403: a6 := JTF_VARCHAR2_TABLE_100();
404: a7 := JTF_NUMBER_TABLE();
405: a8 := JTF_VARCHAR2_TABLE_100();
406: else
407: a0 := JTF_NUMBER_TABLE();
408: a1 := JTF_VARCHAR2_TABLE_100();
409: a2 := JTF_VARCHAR2_TABLE_100();
404: a7 := JTF_NUMBER_TABLE();
405: a8 := JTF_VARCHAR2_TABLE_100();
406: else
407: a0 := JTF_NUMBER_TABLE();
408: a1 := JTF_VARCHAR2_TABLE_100();
409: a2 := JTF_VARCHAR2_TABLE_100();
410: a3 := JTF_VARCHAR2_TABLE_100();
411: a4 := JTF_VARCHAR2_TABLE_200();
412: a5 := JTF_VARCHAR2_TABLE_300();
405: a8 := JTF_VARCHAR2_TABLE_100();
406: else
407: a0 := JTF_NUMBER_TABLE();
408: a1 := JTF_VARCHAR2_TABLE_100();
409: a2 := JTF_VARCHAR2_TABLE_100();
410: a3 := JTF_VARCHAR2_TABLE_100();
411: a4 := JTF_VARCHAR2_TABLE_200();
412: a5 := JTF_VARCHAR2_TABLE_300();
413: a6 := JTF_VARCHAR2_TABLE_100();
406: else
407: a0 := JTF_NUMBER_TABLE();
408: a1 := JTF_VARCHAR2_TABLE_100();
409: a2 := JTF_VARCHAR2_TABLE_100();
410: a3 := JTF_VARCHAR2_TABLE_100();
411: a4 := JTF_VARCHAR2_TABLE_200();
412: a5 := JTF_VARCHAR2_TABLE_300();
413: a6 := JTF_VARCHAR2_TABLE_100();
414: a7 := JTF_NUMBER_TABLE();
409: a2 := JTF_VARCHAR2_TABLE_100();
410: a3 := JTF_VARCHAR2_TABLE_100();
411: a4 := JTF_VARCHAR2_TABLE_200();
412: a5 := JTF_VARCHAR2_TABLE_300();
413: a6 := JTF_VARCHAR2_TABLE_100();
414: a7 := JTF_NUMBER_TABLE();
415: a8 := JTF_VARCHAR2_TABLE_100();
416: if t.count > 0 then
417: a0.extend(t.count);
411: a4 := JTF_VARCHAR2_TABLE_200();
412: a5 := JTF_VARCHAR2_TABLE_300();
413: a6 := JTF_VARCHAR2_TABLE_100();
414: a7 := JTF_NUMBER_TABLE();
415: a8 := JTF_VARCHAR2_TABLE_100();
416: if t.count > 0 then
417: a0.extend(t.count);
418: a1.extend(t.count);
419: a2.extend(t.count);
445: end if;
446: end rosetta_table_copy_out_p17;
447:
448: procedure rosetta_table_copy_in_p18(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.physical_tbl, a0 JTF_NUMBER_TABLE
449: , a1 JTF_VARCHAR2_TABLE_100
450: , a2 JTF_VARCHAR2_TABLE_100
451: ) as
452: ddindx binary_integer; indx binary_integer;
453: begin
446: end rosetta_table_copy_out_p17;
447:
448: procedure rosetta_table_copy_in_p18(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.physical_tbl, a0 JTF_NUMBER_TABLE
449: , a1 JTF_VARCHAR2_TABLE_100
450: , a2 JTF_VARCHAR2_TABLE_100
451: ) as
452: ddindx binary_integer; indx binary_integer;
453: begin
454: if a0 is not null and a0.count > 0 then
468: end if;
469: end if;
470: end rosetta_table_copy_in_p18;
471: procedure rosetta_table_copy_out_p18(t jtf_dpf.physical_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
472: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
473: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
474: ) as
475: ddindx binary_integer; indx binary_integer;
476: begin
469: end if;
470: end rosetta_table_copy_in_p18;
471: procedure rosetta_table_copy_out_p18(t jtf_dpf.physical_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
472: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
473: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
474: ) as
475: ddindx binary_integer; indx binary_integer;
476: begin
477: if t is null or t.count = 0 then
475: ddindx binary_integer; indx binary_integer;
476: begin
477: if t is null or t.count = 0 then
478: a0 := JTF_NUMBER_TABLE();
479: a1 := JTF_VARCHAR2_TABLE_100();
480: a2 := JTF_VARCHAR2_TABLE_100();
481: else
482: a0 := JTF_NUMBER_TABLE();
483: a1 := JTF_VARCHAR2_TABLE_100();
476: begin
477: if t is null or t.count = 0 then
478: a0 := JTF_NUMBER_TABLE();
479: a1 := JTF_VARCHAR2_TABLE_100();
480: a2 := JTF_VARCHAR2_TABLE_100();
481: else
482: a0 := JTF_NUMBER_TABLE();
483: a1 := JTF_VARCHAR2_TABLE_100();
484: a2 := JTF_VARCHAR2_TABLE_100();
479: a1 := JTF_VARCHAR2_TABLE_100();
480: a2 := JTF_VARCHAR2_TABLE_100();
481: else
482: a0 := JTF_NUMBER_TABLE();
483: a1 := JTF_VARCHAR2_TABLE_100();
484: a2 := JTF_VARCHAR2_TABLE_100();
485: if t.count > 0 then
486: a0.extend(t.count);
487: a1.extend(t.count);
480: a2 := JTF_VARCHAR2_TABLE_100();
481: else
482: a0 := JTF_NUMBER_TABLE();
483: a1 := JTF_VARCHAR2_TABLE_100();
484: a2 := JTF_VARCHAR2_TABLE_100();
485: if t.count > 0 then
486: a0.extend(t.count);
487: a1.extend(t.count);
488: a2.extend(t.count);
501: end if;
502: end if;
503: end rosetta_table_copy_out_p18;
504:
505: procedure rosetta_table_copy_in_p19(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.physical_non_default_tbl, a0 JTF_VARCHAR2_TABLE_100
506: , a1 JTF_NUMBER_TABLE
507: , a2 JTF_VARCHAR2_TABLE_100
508: , a3 JTF_VARCHAR2_TABLE_100
509: , a4 JTF_VARCHAR2_TABLE_100
503: end rosetta_table_copy_out_p18;
504:
505: procedure rosetta_table_copy_in_p19(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.physical_non_default_tbl, a0 JTF_VARCHAR2_TABLE_100
506: , a1 JTF_NUMBER_TABLE
507: , a2 JTF_VARCHAR2_TABLE_100
508: , a3 JTF_VARCHAR2_TABLE_100
509: , a4 JTF_VARCHAR2_TABLE_100
510: , a5 JTF_NUMBER_TABLE
511: , a6 JTF_VARCHAR2_TABLE_100
504:
505: procedure rosetta_table_copy_in_p19(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.physical_non_default_tbl, a0 JTF_VARCHAR2_TABLE_100
506: , a1 JTF_NUMBER_TABLE
507: , a2 JTF_VARCHAR2_TABLE_100
508: , a3 JTF_VARCHAR2_TABLE_100
509: , a4 JTF_VARCHAR2_TABLE_100
510: , a5 JTF_NUMBER_TABLE
511: , a6 JTF_VARCHAR2_TABLE_100
512: ) as
505: procedure rosetta_table_copy_in_p19(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.physical_non_default_tbl, a0 JTF_VARCHAR2_TABLE_100
506: , a1 JTF_NUMBER_TABLE
507: , a2 JTF_VARCHAR2_TABLE_100
508: , a3 JTF_VARCHAR2_TABLE_100
509: , a4 JTF_VARCHAR2_TABLE_100
510: , a5 JTF_NUMBER_TABLE
511: , a6 JTF_VARCHAR2_TABLE_100
512: ) as
513: ddindx binary_integer; indx binary_integer;
507: , a2 JTF_VARCHAR2_TABLE_100
508: , a3 JTF_VARCHAR2_TABLE_100
509: , a4 JTF_VARCHAR2_TABLE_100
510: , a5 JTF_NUMBER_TABLE
511: , a6 JTF_VARCHAR2_TABLE_100
512: ) as
513: ddindx binary_integer; indx binary_integer;
514: begin
515: if a0 is not null and a0.count > 0 then
532: end loop;
533: end if;
534: end if;
535: end rosetta_table_copy_in_p19;
536: procedure rosetta_table_copy_out_p19(t jtf_dpf.physical_non_default_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
537: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
538: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
539: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
540: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
534: end if;
535: end rosetta_table_copy_in_p19;
536: procedure rosetta_table_copy_out_p19(t jtf_dpf.physical_non_default_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
537: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
538: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
539: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
540: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
541: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
542: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
535: end rosetta_table_copy_in_p19;
536: procedure rosetta_table_copy_out_p19(t jtf_dpf.physical_non_default_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
537: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
538: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
539: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
540: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
541: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
542: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
543: ) as
536: procedure rosetta_table_copy_out_p19(t jtf_dpf.physical_non_default_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
537: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
538: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
539: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
540: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
541: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
542: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
543: ) as
544: ddindx binary_integer; indx binary_integer;
538: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
539: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
540: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
541: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
542: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
543: ) as
544: ddindx binary_integer; indx binary_integer;
545: begin
546: if t is null or t.count = 0 then
543: ) as
544: ddindx binary_integer; indx binary_integer;
545: begin
546: if t is null or t.count = 0 then
547: a0 := JTF_VARCHAR2_TABLE_100();
548: a1 := JTF_NUMBER_TABLE();
549: a2 := JTF_VARCHAR2_TABLE_100();
550: a3 := JTF_VARCHAR2_TABLE_100();
551: a4 := JTF_VARCHAR2_TABLE_100();
545: begin
546: if t is null or t.count = 0 then
547: a0 := JTF_VARCHAR2_TABLE_100();
548: a1 := JTF_NUMBER_TABLE();
549: a2 := JTF_VARCHAR2_TABLE_100();
550: a3 := JTF_VARCHAR2_TABLE_100();
551: a4 := JTF_VARCHAR2_TABLE_100();
552: a5 := JTF_NUMBER_TABLE();
553: a6 := JTF_VARCHAR2_TABLE_100();
546: if t is null or t.count = 0 then
547: a0 := JTF_VARCHAR2_TABLE_100();
548: a1 := JTF_NUMBER_TABLE();
549: a2 := JTF_VARCHAR2_TABLE_100();
550: a3 := JTF_VARCHAR2_TABLE_100();
551: a4 := JTF_VARCHAR2_TABLE_100();
552: a5 := JTF_NUMBER_TABLE();
553: a6 := JTF_VARCHAR2_TABLE_100();
554: else
547: a0 := JTF_VARCHAR2_TABLE_100();
548: a1 := JTF_NUMBER_TABLE();
549: a2 := JTF_VARCHAR2_TABLE_100();
550: a3 := JTF_VARCHAR2_TABLE_100();
551: a4 := JTF_VARCHAR2_TABLE_100();
552: a5 := JTF_NUMBER_TABLE();
553: a6 := JTF_VARCHAR2_TABLE_100();
554: else
555: a0 := JTF_VARCHAR2_TABLE_100();
549: a2 := JTF_VARCHAR2_TABLE_100();
550: a3 := JTF_VARCHAR2_TABLE_100();
551: a4 := JTF_VARCHAR2_TABLE_100();
552: a5 := JTF_NUMBER_TABLE();
553: a6 := JTF_VARCHAR2_TABLE_100();
554: else
555: a0 := JTF_VARCHAR2_TABLE_100();
556: a1 := JTF_NUMBER_TABLE();
557: a2 := JTF_VARCHAR2_TABLE_100();
551: a4 := JTF_VARCHAR2_TABLE_100();
552: a5 := JTF_NUMBER_TABLE();
553: a6 := JTF_VARCHAR2_TABLE_100();
554: else
555: a0 := JTF_VARCHAR2_TABLE_100();
556: a1 := JTF_NUMBER_TABLE();
557: a2 := JTF_VARCHAR2_TABLE_100();
558: a3 := JTF_VARCHAR2_TABLE_100();
559: a4 := JTF_VARCHAR2_TABLE_100();
553: a6 := JTF_VARCHAR2_TABLE_100();
554: else
555: a0 := JTF_VARCHAR2_TABLE_100();
556: a1 := JTF_NUMBER_TABLE();
557: a2 := JTF_VARCHAR2_TABLE_100();
558: a3 := JTF_VARCHAR2_TABLE_100();
559: a4 := JTF_VARCHAR2_TABLE_100();
560: a5 := JTF_NUMBER_TABLE();
561: a6 := JTF_VARCHAR2_TABLE_100();
554: else
555: a0 := JTF_VARCHAR2_TABLE_100();
556: a1 := JTF_NUMBER_TABLE();
557: a2 := JTF_VARCHAR2_TABLE_100();
558: a3 := JTF_VARCHAR2_TABLE_100();
559: a4 := JTF_VARCHAR2_TABLE_100();
560: a5 := JTF_NUMBER_TABLE();
561: a6 := JTF_VARCHAR2_TABLE_100();
562: if t.count > 0 then
555: a0 := JTF_VARCHAR2_TABLE_100();
556: a1 := JTF_NUMBER_TABLE();
557: a2 := JTF_VARCHAR2_TABLE_100();
558: a3 := JTF_VARCHAR2_TABLE_100();
559: a4 := JTF_VARCHAR2_TABLE_100();
560: a5 := JTF_NUMBER_TABLE();
561: a6 := JTF_VARCHAR2_TABLE_100();
562: if t.count > 0 then
563: a0.extend(t.count);
557: a2 := JTF_VARCHAR2_TABLE_100();
558: a3 := JTF_VARCHAR2_TABLE_100();
559: a4 := JTF_VARCHAR2_TABLE_100();
560: a5 := JTF_NUMBER_TABLE();
561: a6 := JTF_VARCHAR2_TABLE_100();
562: if t.count > 0 then
563: a0.extend(t.count);
564: a1.extend(t.count);
565: a2.extend(t.count);
587: end if;
588: end rosetta_table_copy_out_p19;
589:
590: procedure rosetta_table_copy_in_p20(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.rule_tbl, a0 JTF_NUMBER_TABLE
591: , a1 JTF_VARCHAR2_TABLE_100
592: , a2 JTF_VARCHAR2_TABLE_100
593: , a3 JTF_VARCHAR2_TABLE_100
594: , a4 JTF_VARCHAR2_TABLE_100
595: , a5 JTF_VARCHAR2_TABLE_100
588: end rosetta_table_copy_out_p19;
589:
590: procedure rosetta_table_copy_in_p20(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.rule_tbl, a0 JTF_NUMBER_TABLE
591: , a1 JTF_VARCHAR2_TABLE_100
592: , a2 JTF_VARCHAR2_TABLE_100
593: , a3 JTF_VARCHAR2_TABLE_100
594: , a4 JTF_VARCHAR2_TABLE_100
595: , a5 JTF_VARCHAR2_TABLE_100
596: ) as
589:
590: procedure rosetta_table_copy_in_p20(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.rule_tbl, a0 JTF_NUMBER_TABLE
591: , a1 JTF_VARCHAR2_TABLE_100
592: , a2 JTF_VARCHAR2_TABLE_100
593: , a3 JTF_VARCHAR2_TABLE_100
594: , a4 JTF_VARCHAR2_TABLE_100
595: , a5 JTF_VARCHAR2_TABLE_100
596: ) as
597: ddindx binary_integer; indx binary_integer;
590: procedure rosetta_table_copy_in_p20(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.rule_tbl, a0 JTF_NUMBER_TABLE
591: , a1 JTF_VARCHAR2_TABLE_100
592: , a2 JTF_VARCHAR2_TABLE_100
593: , a3 JTF_VARCHAR2_TABLE_100
594: , a4 JTF_VARCHAR2_TABLE_100
595: , a5 JTF_VARCHAR2_TABLE_100
596: ) as
597: ddindx binary_integer; indx binary_integer;
598: begin
591: , a1 JTF_VARCHAR2_TABLE_100
592: , a2 JTF_VARCHAR2_TABLE_100
593: , a3 JTF_VARCHAR2_TABLE_100
594: , a4 JTF_VARCHAR2_TABLE_100
595: , a5 JTF_VARCHAR2_TABLE_100
596: ) as
597: ddindx binary_integer; indx binary_integer;
598: begin
599: if a0 is not null and a0.count > 0 then
616: end if;
617: end if;
618: end rosetta_table_copy_in_p20;
619: procedure rosetta_table_copy_out_p20(t jtf_dpf.rule_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
620: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
621: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
622: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
623: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
624: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
617: end if;
618: end rosetta_table_copy_in_p20;
619: procedure rosetta_table_copy_out_p20(t jtf_dpf.rule_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
620: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
621: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
622: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
623: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
624: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
625: ) as
618: end rosetta_table_copy_in_p20;
619: procedure rosetta_table_copy_out_p20(t jtf_dpf.rule_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
620: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
621: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
622: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
623: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
624: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
625: ) as
626: ddindx binary_integer; indx binary_integer;
619: procedure rosetta_table_copy_out_p20(t jtf_dpf.rule_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
620: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
621: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
622: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
623: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
624: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
625: ) as
626: ddindx binary_integer; indx binary_integer;
627: begin
620: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
621: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
622: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
623: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
624: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
625: ) as
626: ddindx binary_integer; indx binary_integer;
627: begin
628: if t is null or t.count = 0 then
626: ddindx binary_integer; indx binary_integer;
627: begin
628: if t is null or t.count = 0 then
629: a0 := JTF_NUMBER_TABLE();
630: a1 := JTF_VARCHAR2_TABLE_100();
631: a2 := JTF_VARCHAR2_TABLE_100();
632: a3 := JTF_VARCHAR2_TABLE_100();
633: a4 := JTF_VARCHAR2_TABLE_100();
634: a5 := JTF_VARCHAR2_TABLE_100();
627: begin
628: if t is null or t.count = 0 then
629: a0 := JTF_NUMBER_TABLE();
630: a1 := JTF_VARCHAR2_TABLE_100();
631: a2 := JTF_VARCHAR2_TABLE_100();
632: a3 := JTF_VARCHAR2_TABLE_100();
633: a4 := JTF_VARCHAR2_TABLE_100();
634: a5 := JTF_VARCHAR2_TABLE_100();
635: else
628: if t is null or t.count = 0 then
629: a0 := JTF_NUMBER_TABLE();
630: a1 := JTF_VARCHAR2_TABLE_100();
631: a2 := JTF_VARCHAR2_TABLE_100();
632: a3 := JTF_VARCHAR2_TABLE_100();
633: a4 := JTF_VARCHAR2_TABLE_100();
634: a5 := JTF_VARCHAR2_TABLE_100();
635: else
636: a0 := JTF_NUMBER_TABLE();
629: a0 := JTF_NUMBER_TABLE();
630: a1 := JTF_VARCHAR2_TABLE_100();
631: a2 := JTF_VARCHAR2_TABLE_100();
632: a3 := JTF_VARCHAR2_TABLE_100();
633: a4 := JTF_VARCHAR2_TABLE_100();
634: a5 := JTF_VARCHAR2_TABLE_100();
635: else
636: a0 := JTF_NUMBER_TABLE();
637: a1 := JTF_VARCHAR2_TABLE_100();
630: a1 := JTF_VARCHAR2_TABLE_100();
631: a2 := JTF_VARCHAR2_TABLE_100();
632: a3 := JTF_VARCHAR2_TABLE_100();
633: a4 := JTF_VARCHAR2_TABLE_100();
634: a5 := JTF_VARCHAR2_TABLE_100();
635: else
636: a0 := JTF_NUMBER_TABLE();
637: a1 := JTF_VARCHAR2_TABLE_100();
638: a2 := JTF_VARCHAR2_TABLE_100();
633: a4 := JTF_VARCHAR2_TABLE_100();
634: a5 := JTF_VARCHAR2_TABLE_100();
635: else
636: a0 := JTF_NUMBER_TABLE();
637: a1 := JTF_VARCHAR2_TABLE_100();
638: a2 := JTF_VARCHAR2_TABLE_100();
639: a3 := JTF_VARCHAR2_TABLE_100();
640: a4 := JTF_VARCHAR2_TABLE_100();
641: a5 := JTF_VARCHAR2_TABLE_100();
634: a5 := JTF_VARCHAR2_TABLE_100();
635: else
636: a0 := JTF_NUMBER_TABLE();
637: a1 := JTF_VARCHAR2_TABLE_100();
638: a2 := JTF_VARCHAR2_TABLE_100();
639: a3 := JTF_VARCHAR2_TABLE_100();
640: a4 := JTF_VARCHAR2_TABLE_100();
641: a5 := JTF_VARCHAR2_TABLE_100();
642: if t.count > 0 then
635: else
636: a0 := JTF_NUMBER_TABLE();
637: a1 := JTF_VARCHAR2_TABLE_100();
638: a2 := JTF_VARCHAR2_TABLE_100();
639: a3 := JTF_VARCHAR2_TABLE_100();
640: a4 := JTF_VARCHAR2_TABLE_100();
641: a5 := JTF_VARCHAR2_TABLE_100();
642: if t.count > 0 then
643: a0.extend(t.count);
636: a0 := JTF_NUMBER_TABLE();
637: a1 := JTF_VARCHAR2_TABLE_100();
638: a2 := JTF_VARCHAR2_TABLE_100();
639: a3 := JTF_VARCHAR2_TABLE_100();
640: a4 := JTF_VARCHAR2_TABLE_100();
641: a5 := JTF_VARCHAR2_TABLE_100();
642: if t.count > 0 then
643: a0.extend(t.count);
644: a1.extend(t.count);
637: a1 := JTF_VARCHAR2_TABLE_100();
638: a2 := JTF_VARCHAR2_TABLE_100();
639: a3 := JTF_VARCHAR2_TABLE_100();
640: a4 := JTF_VARCHAR2_TABLE_100();
641: a5 := JTF_VARCHAR2_TABLE_100();
642: if t.count > 0 then
643: a0.extend(t.count);
644: a1.extend(t.count);
645: a2.extend(t.count);
664: end if;
665: end if;
666: end rosetta_table_copy_out_p20;
667:
668: procedure rosetta_table_copy_in_p21(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.next_logical_default_tbl, a0 JTF_VARCHAR2_TABLE_100
669: , a1 JTF_NUMBER_TABLE
670: , a2 JTF_VARCHAR2_TABLE_100
671: , a3 JTF_VARCHAR2_TABLE_100
672: , a4 JTF_VARCHAR2_TABLE_100
666: end rosetta_table_copy_out_p20;
667:
668: procedure rosetta_table_copy_in_p21(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.next_logical_default_tbl, a0 JTF_VARCHAR2_TABLE_100
669: , a1 JTF_NUMBER_TABLE
670: , a2 JTF_VARCHAR2_TABLE_100
671: , a3 JTF_VARCHAR2_TABLE_100
672: , a4 JTF_VARCHAR2_TABLE_100
673: , a5 JTF_VARCHAR2_TABLE_100
674: ) as
667:
668: procedure rosetta_table_copy_in_p21(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.next_logical_default_tbl, a0 JTF_VARCHAR2_TABLE_100
669: , a1 JTF_NUMBER_TABLE
670: , a2 JTF_VARCHAR2_TABLE_100
671: , a3 JTF_VARCHAR2_TABLE_100
672: , a4 JTF_VARCHAR2_TABLE_100
673: , a5 JTF_VARCHAR2_TABLE_100
674: ) as
675: ddindx binary_integer; indx binary_integer;
668: procedure rosetta_table_copy_in_p21(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.next_logical_default_tbl, a0 JTF_VARCHAR2_TABLE_100
669: , a1 JTF_NUMBER_TABLE
670: , a2 JTF_VARCHAR2_TABLE_100
671: , a3 JTF_VARCHAR2_TABLE_100
672: , a4 JTF_VARCHAR2_TABLE_100
673: , a5 JTF_VARCHAR2_TABLE_100
674: ) as
675: ddindx binary_integer; indx binary_integer;
676: begin
669: , a1 JTF_NUMBER_TABLE
670: , a2 JTF_VARCHAR2_TABLE_100
671: , a3 JTF_VARCHAR2_TABLE_100
672: , a4 JTF_VARCHAR2_TABLE_100
673: , a5 JTF_VARCHAR2_TABLE_100
674: ) as
675: ddindx binary_integer; indx binary_integer;
676: begin
677: if a0 is not null and a0.count > 0 then
693: end loop;
694: end if;
695: end if;
696: end rosetta_table_copy_in_p21;
697: procedure rosetta_table_copy_out_p21(t jtf_dpf.next_logical_default_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
698: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
699: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
700: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
701: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
695: end if;
696: end rosetta_table_copy_in_p21;
697: procedure rosetta_table_copy_out_p21(t jtf_dpf.next_logical_default_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
698: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
699: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
700: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
701: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
702: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
703: ) as
696: end rosetta_table_copy_in_p21;
697: procedure rosetta_table_copy_out_p21(t jtf_dpf.next_logical_default_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
698: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
699: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
700: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
701: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
702: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
703: ) as
704: ddindx binary_integer; indx binary_integer;
697: procedure rosetta_table_copy_out_p21(t jtf_dpf.next_logical_default_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
698: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
699: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
700: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
701: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
702: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
703: ) as
704: ddindx binary_integer; indx binary_integer;
705: begin
698: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
699: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
700: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
701: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
702: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
703: ) as
704: ddindx binary_integer; indx binary_integer;
705: begin
706: if t is null or t.count = 0 then
703: ) as
704: ddindx binary_integer; indx binary_integer;
705: begin
706: if t is null or t.count = 0 then
707: a0 := JTF_VARCHAR2_TABLE_100();
708: a1 := JTF_NUMBER_TABLE();
709: a2 := JTF_VARCHAR2_TABLE_100();
710: a3 := JTF_VARCHAR2_TABLE_100();
711: a4 := JTF_VARCHAR2_TABLE_100();
705: begin
706: if t is null or t.count = 0 then
707: a0 := JTF_VARCHAR2_TABLE_100();
708: a1 := JTF_NUMBER_TABLE();
709: a2 := JTF_VARCHAR2_TABLE_100();
710: a3 := JTF_VARCHAR2_TABLE_100();
711: a4 := JTF_VARCHAR2_TABLE_100();
712: a5 := JTF_VARCHAR2_TABLE_100();
713: else
706: if t is null or t.count = 0 then
707: a0 := JTF_VARCHAR2_TABLE_100();
708: a1 := JTF_NUMBER_TABLE();
709: a2 := JTF_VARCHAR2_TABLE_100();
710: a3 := JTF_VARCHAR2_TABLE_100();
711: a4 := JTF_VARCHAR2_TABLE_100();
712: a5 := JTF_VARCHAR2_TABLE_100();
713: else
714: a0 := JTF_VARCHAR2_TABLE_100();
707: a0 := JTF_VARCHAR2_TABLE_100();
708: a1 := JTF_NUMBER_TABLE();
709: a2 := JTF_VARCHAR2_TABLE_100();
710: a3 := JTF_VARCHAR2_TABLE_100();
711: a4 := JTF_VARCHAR2_TABLE_100();
712: a5 := JTF_VARCHAR2_TABLE_100();
713: else
714: a0 := JTF_VARCHAR2_TABLE_100();
715: a1 := JTF_NUMBER_TABLE();
708: a1 := JTF_NUMBER_TABLE();
709: a2 := JTF_VARCHAR2_TABLE_100();
710: a3 := JTF_VARCHAR2_TABLE_100();
711: a4 := JTF_VARCHAR2_TABLE_100();
712: a5 := JTF_VARCHAR2_TABLE_100();
713: else
714: a0 := JTF_VARCHAR2_TABLE_100();
715: a1 := JTF_NUMBER_TABLE();
716: a2 := JTF_VARCHAR2_TABLE_100();
710: a3 := JTF_VARCHAR2_TABLE_100();
711: a4 := JTF_VARCHAR2_TABLE_100();
712: a5 := JTF_VARCHAR2_TABLE_100();
713: else
714: a0 := JTF_VARCHAR2_TABLE_100();
715: a1 := JTF_NUMBER_TABLE();
716: a2 := JTF_VARCHAR2_TABLE_100();
717: a3 := JTF_VARCHAR2_TABLE_100();
718: a4 := JTF_VARCHAR2_TABLE_100();
712: a5 := JTF_VARCHAR2_TABLE_100();
713: else
714: a0 := JTF_VARCHAR2_TABLE_100();
715: a1 := JTF_NUMBER_TABLE();
716: a2 := JTF_VARCHAR2_TABLE_100();
717: a3 := JTF_VARCHAR2_TABLE_100();
718: a4 := JTF_VARCHAR2_TABLE_100();
719: a5 := JTF_VARCHAR2_TABLE_100();
720: if t.count > 0 then
713: else
714: a0 := JTF_VARCHAR2_TABLE_100();
715: a1 := JTF_NUMBER_TABLE();
716: a2 := JTF_VARCHAR2_TABLE_100();
717: a3 := JTF_VARCHAR2_TABLE_100();
718: a4 := JTF_VARCHAR2_TABLE_100();
719: a5 := JTF_VARCHAR2_TABLE_100();
720: if t.count > 0 then
721: a0.extend(t.count);
714: a0 := JTF_VARCHAR2_TABLE_100();
715: a1 := JTF_NUMBER_TABLE();
716: a2 := JTF_VARCHAR2_TABLE_100();
717: a3 := JTF_VARCHAR2_TABLE_100();
718: a4 := JTF_VARCHAR2_TABLE_100();
719: a5 := JTF_VARCHAR2_TABLE_100();
720: if t.count > 0 then
721: a0.extend(t.count);
722: a1.extend(t.count);
715: a1 := JTF_NUMBER_TABLE();
716: a2 := JTF_VARCHAR2_TABLE_100();
717: a3 := JTF_VARCHAR2_TABLE_100();
718: a4 := JTF_VARCHAR2_TABLE_100();
719: a5 := JTF_VARCHAR2_TABLE_100();
720: if t.count > 0 then
721: a0.extend(t.count);
722: a1.extend(t.count);
723: a2.extend(t.count);
742: end if;
743: end if;
744: end rosetta_table_copy_out_p21;
745:
746: procedure rosetta_table_copy_in_p22(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.next_logical_non_default_tbl, a0 JTF_VARCHAR2_TABLE_100
747: , a1 JTF_NUMBER_TABLE
748: , a2 JTF_VARCHAR2_TABLE_100
749: , a3 JTF_VARCHAR2_TABLE_100
750: , a4 JTF_VARCHAR2_TABLE_100
744: end rosetta_table_copy_out_p21;
745:
746: procedure rosetta_table_copy_in_p22(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.next_logical_non_default_tbl, a0 JTF_VARCHAR2_TABLE_100
747: , a1 JTF_NUMBER_TABLE
748: , a2 JTF_VARCHAR2_TABLE_100
749: , a3 JTF_VARCHAR2_TABLE_100
750: , a4 JTF_VARCHAR2_TABLE_100
751: , a5 JTF_VARCHAR2_TABLE_100
752: , a6 JTF_VARCHAR2_TABLE_100
745:
746: procedure rosetta_table_copy_in_p22(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.next_logical_non_default_tbl, a0 JTF_VARCHAR2_TABLE_100
747: , a1 JTF_NUMBER_TABLE
748: , a2 JTF_VARCHAR2_TABLE_100
749: , a3 JTF_VARCHAR2_TABLE_100
750: , a4 JTF_VARCHAR2_TABLE_100
751: , a5 JTF_VARCHAR2_TABLE_100
752: , a6 JTF_VARCHAR2_TABLE_100
753: , a7 JTF_VARCHAR2_TABLE_100
746: procedure rosetta_table_copy_in_p22(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.next_logical_non_default_tbl, a0 JTF_VARCHAR2_TABLE_100
747: , a1 JTF_NUMBER_TABLE
748: , a2 JTF_VARCHAR2_TABLE_100
749: , a3 JTF_VARCHAR2_TABLE_100
750: , a4 JTF_VARCHAR2_TABLE_100
751: , a5 JTF_VARCHAR2_TABLE_100
752: , a6 JTF_VARCHAR2_TABLE_100
753: , a7 JTF_VARCHAR2_TABLE_100
754: ) as
747: , a1 JTF_NUMBER_TABLE
748: , a2 JTF_VARCHAR2_TABLE_100
749: , a3 JTF_VARCHAR2_TABLE_100
750: , a4 JTF_VARCHAR2_TABLE_100
751: , a5 JTF_VARCHAR2_TABLE_100
752: , a6 JTF_VARCHAR2_TABLE_100
753: , a7 JTF_VARCHAR2_TABLE_100
754: ) as
755: ddindx binary_integer; indx binary_integer;
748: , a2 JTF_VARCHAR2_TABLE_100
749: , a3 JTF_VARCHAR2_TABLE_100
750: , a4 JTF_VARCHAR2_TABLE_100
751: , a5 JTF_VARCHAR2_TABLE_100
752: , a6 JTF_VARCHAR2_TABLE_100
753: , a7 JTF_VARCHAR2_TABLE_100
754: ) as
755: ddindx binary_integer; indx binary_integer;
756: begin
749: , a3 JTF_VARCHAR2_TABLE_100
750: , a4 JTF_VARCHAR2_TABLE_100
751: , a5 JTF_VARCHAR2_TABLE_100
752: , a6 JTF_VARCHAR2_TABLE_100
753: , a7 JTF_VARCHAR2_TABLE_100
754: ) as
755: ddindx binary_integer; indx binary_integer;
756: begin
757: if a0 is not null and a0.count > 0 then
775: end loop;
776: end if;
777: end if;
778: end rosetta_table_copy_in_p22;
779: procedure rosetta_table_copy_out_p22(t jtf_dpf.next_logical_non_default_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
780: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
781: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
782: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
783: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
777: end if;
778: end rosetta_table_copy_in_p22;
779: procedure rosetta_table_copy_out_p22(t jtf_dpf.next_logical_non_default_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
780: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
781: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
782: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
783: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
784: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
785: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
778: end rosetta_table_copy_in_p22;
779: procedure rosetta_table_copy_out_p22(t jtf_dpf.next_logical_non_default_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
780: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
781: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
782: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
783: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
784: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
785: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
786: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
779: procedure rosetta_table_copy_out_p22(t jtf_dpf.next_logical_non_default_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
780: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
781: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
782: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
783: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
784: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
785: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
786: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
787: ) as
780: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
781: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
782: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
783: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
784: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
785: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
786: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
787: ) as
788: ddindx binary_integer; indx binary_integer;
781: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
782: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
783: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
784: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
785: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
786: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
787: ) as
788: ddindx binary_integer; indx binary_integer;
789: begin
782: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
783: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
784: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
785: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
786: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
787: ) as
788: ddindx binary_integer; indx binary_integer;
789: begin
790: if t is null or t.count = 0 then
787: ) as
788: ddindx binary_integer; indx binary_integer;
789: begin
790: if t is null or t.count = 0 then
791: a0 := JTF_VARCHAR2_TABLE_100();
792: a1 := JTF_NUMBER_TABLE();
793: a2 := JTF_VARCHAR2_TABLE_100();
794: a3 := JTF_VARCHAR2_TABLE_100();
795: a4 := JTF_VARCHAR2_TABLE_100();
789: begin
790: if t is null or t.count = 0 then
791: a0 := JTF_VARCHAR2_TABLE_100();
792: a1 := JTF_NUMBER_TABLE();
793: a2 := JTF_VARCHAR2_TABLE_100();
794: a3 := JTF_VARCHAR2_TABLE_100();
795: a4 := JTF_VARCHAR2_TABLE_100();
796: a5 := JTF_VARCHAR2_TABLE_100();
797: a6 := JTF_VARCHAR2_TABLE_100();
790: if t is null or t.count = 0 then
791: a0 := JTF_VARCHAR2_TABLE_100();
792: a1 := JTF_NUMBER_TABLE();
793: a2 := JTF_VARCHAR2_TABLE_100();
794: a3 := JTF_VARCHAR2_TABLE_100();
795: a4 := JTF_VARCHAR2_TABLE_100();
796: a5 := JTF_VARCHAR2_TABLE_100();
797: a6 := JTF_VARCHAR2_TABLE_100();
798: a7 := JTF_VARCHAR2_TABLE_100();
791: a0 := JTF_VARCHAR2_TABLE_100();
792: a1 := JTF_NUMBER_TABLE();
793: a2 := JTF_VARCHAR2_TABLE_100();
794: a3 := JTF_VARCHAR2_TABLE_100();
795: a4 := JTF_VARCHAR2_TABLE_100();
796: a5 := JTF_VARCHAR2_TABLE_100();
797: a6 := JTF_VARCHAR2_TABLE_100();
798: a7 := JTF_VARCHAR2_TABLE_100();
799: else
792: a1 := JTF_NUMBER_TABLE();
793: a2 := JTF_VARCHAR2_TABLE_100();
794: a3 := JTF_VARCHAR2_TABLE_100();
795: a4 := JTF_VARCHAR2_TABLE_100();
796: a5 := JTF_VARCHAR2_TABLE_100();
797: a6 := JTF_VARCHAR2_TABLE_100();
798: a7 := JTF_VARCHAR2_TABLE_100();
799: else
800: a0 := JTF_VARCHAR2_TABLE_100();
793: a2 := JTF_VARCHAR2_TABLE_100();
794: a3 := JTF_VARCHAR2_TABLE_100();
795: a4 := JTF_VARCHAR2_TABLE_100();
796: a5 := JTF_VARCHAR2_TABLE_100();
797: a6 := JTF_VARCHAR2_TABLE_100();
798: a7 := JTF_VARCHAR2_TABLE_100();
799: else
800: a0 := JTF_VARCHAR2_TABLE_100();
801: a1 := JTF_NUMBER_TABLE();
794: a3 := JTF_VARCHAR2_TABLE_100();
795: a4 := JTF_VARCHAR2_TABLE_100();
796: a5 := JTF_VARCHAR2_TABLE_100();
797: a6 := JTF_VARCHAR2_TABLE_100();
798: a7 := JTF_VARCHAR2_TABLE_100();
799: else
800: a0 := JTF_VARCHAR2_TABLE_100();
801: a1 := JTF_NUMBER_TABLE();
802: a2 := JTF_VARCHAR2_TABLE_100();
796: a5 := JTF_VARCHAR2_TABLE_100();
797: a6 := JTF_VARCHAR2_TABLE_100();
798: a7 := JTF_VARCHAR2_TABLE_100();
799: else
800: a0 := JTF_VARCHAR2_TABLE_100();
801: a1 := JTF_NUMBER_TABLE();
802: a2 := JTF_VARCHAR2_TABLE_100();
803: a3 := JTF_VARCHAR2_TABLE_100();
804: a4 := JTF_VARCHAR2_TABLE_100();
798: a7 := JTF_VARCHAR2_TABLE_100();
799: else
800: a0 := JTF_VARCHAR2_TABLE_100();
801: a1 := JTF_NUMBER_TABLE();
802: a2 := JTF_VARCHAR2_TABLE_100();
803: a3 := JTF_VARCHAR2_TABLE_100();
804: a4 := JTF_VARCHAR2_TABLE_100();
805: a5 := JTF_VARCHAR2_TABLE_100();
806: a6 := JTF_VARCHAR2_TABLE_100();
799: else
800: a0 := JTF_VARCHAR2_TABLE_100();
801: a1 := JTF_NUMBER_TABLE();
802: a2 := JTF_VARCHAR2_TABLE_100();
803: a3 := JTF_VARCHAR2_TABLE_100();
804: a4 := JTF_VARCHAR2_TABLE_100();
805: a5 := JTF_VARCHAR2_TABLE_100();
806: a6 := JTF_VARCHAR2_TABLE_100();
807: a7 := JTF_VARCHAR2_TABLE_100();
800: a0 := JTF_VARCHAR2_TABLE_100();
801: a1 := JTF_NUMBER_TABLE();
802: a2 := JTF_VARCHAR2_TABLE_100();
803: a3 := JTF_VARCHAR2_TABLE_100();
804: a4 := JTF_VARCHAR2_TABLE_100();
805: a5 := JTF_VARCHAR2_TABLE_100();
806: a6 := JTF_VARCHAR2_TABLE_100();
807: a7 := JTF_VARCHAR2_TABLE_100();
808: if t.count > 0 then
801: a1 := JTF_NUMBER_TABLE();
802: a2 := JTF_VARCHAR2_TABLE_100();
803: a3 := JTF_VARCHAR2_TABLE_100();
804: a4 := JTF_VARCHAR2_TABLE_100();
805: a5 := JTF_VARCHAR2_TABLE_100();
806: a6 := JTF_VARCHAR2_TABLE_100();
807: a7 := JTF_VARCHAR2_TABLE_100();
808: if t.count > 0 then
809: a0.extend(t.count);
802: a2 := JTF_VARCHAR2_TABLE_100();
803: a3 := JTF_VARCHAR2_TABLE_100();
804: a4 := JTF_VARCHAR2_TABLE_100();
805: a5 := JTF_VARCHAR2_TABLE_100();
806: a6 := JTF_VARCHAR2_TABLE_100();
807: a7 := JTF_VARCHAR2_TABLE_100();
808: if t.count > 0 then
809: a0.extend(t.count);
810: a1.extend(t.count);
803: a3 := JTF_VARCHAR2_TABLE_100();
804: a4 := JTF_VARCHAR2_TABLE_100();
805: a5 := JTF_VARCHAR2_TABLE_100();
806: a6 := JTF_VARCHAR2_TABLE_100();
807: a7 := JTF_VARCHAR2_TABLE_100();
808: if t.count > 0 then
809: a0.extend(t.count);
810: a1.extend(t.count);
811: a2.extend(t.count);
835: end if;
836: end rosetta_table_copy_out_p22;
837:
838: procedure rosetta_table_copy_in_p23(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.physical_attribs_tbl, a0 JTF_NUMBER_TABLE
839: , a1 JTF_VARCHAR2_TABLE_100
840: , a2 JTF_VARCHAR2_TABLE_300
841: ) as
842: ddindx binary_integer; indx binary_integer;
843: begin
858: end if;
859: end if;
860: end rosetta_table_copy_in_p23;
861: procedure rosetta_table_copy_out_p23(t jtf_dpf.physical_attribs_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
862: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
863: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
864: ) as
865: ddindx binary_integer; indx binary_integer;
866: begin
865: ddindx binary_integer; indx binary_integer;
866: begin
867: if t is null or t.count = 0 then
868: a0 := JTF_NUMBER_TABLE();
869: a1 := JTF_VARCHAR2_TABLE_100();
870: a2 := JTF_VARCHAR2_TABLE_300();
871: else
872: a0 := JTF_NUMBER_TABLE();
873: a1 := JTF_VARCHAR2_TABLE_100();
869: a1 := JTF_VARCHAR2_TABLE_100();
870: a2 := JTF_VARCHAR2_TABLE_300();
871: else
872: a0 := JTF_NUMBER_TABLE();
873: a1 := JTF_VARCHAR2_TABLE_100();
874: a2 := JTF_VARCHAR2_TABLE_300();
875: if t.count > 0 then
876: a0.extend(t.count);
877: a1.extend(t.count);
895: procedure get(asn VARCHAR2
896: , p_lang IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
897: , descrs_only number
898: , p3_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
899: , p3_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
900: , p3_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
901: , p3_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
902: , p3_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
903: , p3_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
896: , p_lang IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
897: , descrs_only number
898: , p3_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
899: , p3_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
900: , p3_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
901: , p3_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
902: , p3_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
903: , p3_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
904: , p3_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
897: , descrs_only number
898: , p3_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
899: , p3_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
900: , p3_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
901: , p3_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
902: , p3_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
903: , p3_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
904: , p3_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
905: , p3_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
898: , p3_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
899: , p3_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
900: , p3_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
901: , p3_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
902: , p3_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
903: , p3_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
904: , p3_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
905: , p3_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
906: , p3_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
899: , p3_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
900: , p3_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
901: , p3_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
902: , p3_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
903: , p3_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
904: , p3_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
905: , p3_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
906: , p3_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
907: , p3_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
901: , p3_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
902: , p3_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
903: , p3_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
904: , p3_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
905: , p3_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
906: , p3_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
907: , p3_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
908: , p3_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
909: , p3_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
902: , p3_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
903: , p3_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
904: , p3_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
905: , p3_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
906: , p3_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
907: , p3_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
908: , p3_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
909: , p3_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
910: , p4_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
903: , p3_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
904: , p3_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
905: , p3_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
906: , p3_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
907: , p3_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
908: , p3_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
909: , p3_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
910: , p4_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
911: , p4_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
904: , p3_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
905: , p3_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
906: , p3_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
907: , p3_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
908: , p3_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
909: , p3_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
910: , p4_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
911: , p4_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
912: , p4_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
905: , p3_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
906: , p3_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
907: , p3_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
908: , p3_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
909: , p3_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
910: , p4_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
911: , p4_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
912: , p4_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
913: , p4_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
907: , p3_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
908: , p3_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
909: , p3_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
910: , p4_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
911: , p4_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
912: , p4_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
913: , p4_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
914: , p4_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
915: , p4_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
908: , p3_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
909: , p3_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
910: , p4_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
911: , p4_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
912: , p4_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
913: , p4_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
914: , p4_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
915: , p4_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
916: , p4_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
909: , p3_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
910: , p4_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
911: , p4_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
912: , p4_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
913: , p4_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
914: , p4_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
915: , p4_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
916: , p4_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
917: , p4_a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
912: , p4_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
913: , p4_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
914: , p4_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
915: , p4_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
916: , p4_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
917: , p4_a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
918: , p4_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
919: , p5_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
920: , p5_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
914: , p4_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
915: , p4_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
916: , p4_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
917: , p4_a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
918: , p4_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
919: , p5_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
920: , p5_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
921: , p5_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
922: , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
916: , p4_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
917: , p4_a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
918: , p4_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
919: , p5_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
920: , p5_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
921: , p5_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
922: , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
923: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
924: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
917: , p4_a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
918: , p4_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
919: , p5_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
920: , p5_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
921: , p5_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
922: , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
923: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
924: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
925: , p6_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
918: , p4_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
919: , p5_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
920: , p5_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
921: , p5_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
922: , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
923: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
924: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
925: , p6_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
926: , p6_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
920: , p5_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
921: , p5_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
922: , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
923: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
924: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
925: , p6_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
926: , p6_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
927: , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
928: , p6_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
921: , p5_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
922: , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
923: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
924: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
925: , p6_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
926: , p6_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
927: , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
928: , p6_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
929: , p7_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
922: , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
923: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
924: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
925: , p6_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
926: , p6_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
927: , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
928: , p6_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
929: , p7_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
930: , p7_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
924: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
925: , p6_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
926: , p6_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
927: , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
928: , p6_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
929: , p7_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
930: , p7_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
931: , p7_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
932: , p7_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
926: , p6_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
927: , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
928: , p6_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
929: , p7_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
930: , p7_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
931: , p7_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
932: , p7_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
933: , p7_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
934: , p7_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
927: , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
928: , p6_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
929: , p7_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
930: , p7_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
931: , p7_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
932: , p7_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
933: , p7_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
934: , p7_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
935: , p8_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
928: , p6_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
929: , p7_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
930: , p7_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
931: , p7_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
932: , p7_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
933: , p7_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
934: , p7_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
935: , p8_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
936: , p8_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
929: , p7_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
930: , p7_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
931: , p7_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
932: , p7_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
933: , p7_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
934: , p7_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
935: , p8_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
936: , p8_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
937: , p8_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
930: , p7_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
931: , p7_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
932: , p7_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
933: , p7_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
934: , p7_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
935: , p8_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
936: , p8_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
937: , p8_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
938: , p8_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
931: , p7_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
932: , p7_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
933: , p7_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
934: , p7_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
935: , p8_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
936: , p8_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
937: , p8_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
938: , p8_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
939: , p8_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
933: , p7_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
934: , p7_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
935: , p8_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
936: , p8_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
937: , p8_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
938: , p8_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
939: , p8_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
940: , p8_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
941: , p9_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
934: , p7_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
935: , p8_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
936: , p8_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
937: , p8_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
938: , p8_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
939: , p8_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
940: , p8_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
941: , p9_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
942: , p9_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
935: , p8_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
936: , p8_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
937: , p8_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
938: , p8_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
939: , p8_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
940: , p8_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
941: , p9_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
942: , p9_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
943: , p9_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
936: , p8_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
937: , p8_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
938: , p8_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
939: , p8_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
940: , p8_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
941: , p9_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
942: , p9_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
943: , p9_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
944: , p9_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
937: , p8_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
938: , p8_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
939: , p8_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
940: , p8_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
941: , p9_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
942: , p9_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
943: , p9_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
944: , p9_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
945: , p9_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
939: , p8_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
940: , p8_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
941: , p9_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
942: , p9_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
943: , p9_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
944: , p9_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
945: , p9_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
946: , p9_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
947: , p9_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
940: , p8_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
941: , p9_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
942: , p9_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
943: , p9_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
944: , p9_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
945: , p9_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
946: , p9_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
947: , p9_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
948: , p9_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
941: , p9_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
942: , p9_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
943: , p9_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
944: , p9_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
945: , p9_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
946: , p9_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
947: , p9_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
948: , p9_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
949: , p10_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
942: , p9_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
943: , p9_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
944: , p9_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
945: , p9_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
946: , p9_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
947: , p9_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
948: , p9_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
949: , p10_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
950: , p10_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
943: , p9_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
944: , p9_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
945: , p9_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
946: , p9_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
947: , p9_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
948: , p9_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
949: , p10_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
950: , p10_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
951: , p10_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
944: , p9_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
945: , p9_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
946: , p9_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
947: , p9_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
948: , p9_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
949: , p10_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
950: , p10_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
951: , p10_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
952: )
946: , p9_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
947: , p9_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
948: , p9_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
949: , p10_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
950: , p10_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
951: , p10_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
952: )
953: as
954: dddescrs_only boolean;
1098:
1099: function rule_new(p_asn VARCHAR2
1100: , p_name VARCHAR2
1101: , p_descr VARCHAR2
1102: , p3_a0 JTF_VARCHAR2_TABLE_100
1103: , p3_a1 JTF_VARCHAR2_TABLE_100
1104: , p3_a2 JTF_VARCHAR2_TABLE_100
1105: ) return number
1106: as
1099: function rule_new(p_asn VARCHAR2
1100: , p_name VARCHAR2
1101: , p_descr VARCHAR2
1102: , p3_a0 JTF_VARCHAR2_TABLE_100
1103: , p3_a1 JTF_VARCHAR2_TABLE_100
1104: , p3_a2 JTF_VARCHAR2_TABLE_100
1105: ) return number
1106: as
1107: ddrules jtf_dpf.new_rule_param_tbl;
1100: , p_name VARCHAR2
1101: , p_descr VARCHAR2
1102: , p3_a0 JTF_VARCHAR2_TABLE_100
1103: , p3_a1 JTF_VARCHAR2_TABLE_100
1104: , p3_a2 JTF_VARCHAR2_TABLE_100
1105: ) return number
1106: as
1107: ddrules jtf_dpf.new_rule_param_tbl;
1108: ddindx binary_integer; indx binary_integer;
1132: return ddrosetta_retval;
1133: end;
1134:
1135: procedure rule_set_params(p_rule_id NUMBER
1136: , p1_a0 JTF_VARCHAR2_TABLE_100
1137: , p1_a1 JTF_VARCHAR2_TABLE_100
1138: , p1_a2 JTF_VARCHAR2_TABLE_100
1139: )
1140: as
1133: end;
1134:
1135: procedure rule_set_params(p_rule_id NUMBER
1136: , p1_a0 JTF_VARCHAR2_TABLE_100
1137: , p1_a1 JTF_VARCHAR2_TABLE_100
1138: , p1_a2 JTF_VARCHAR2_TABLE_100
1139: )
1140: as
1141: ddrules jtf_dpf.new_rule_param_tbl;
1134:
1135: procedure rule_set_params(p_rule_id NUMBER
1136: , p1_a0 JTF_VARCHAR2_TABLE_100
1137: , p1_a1 JTF_VARCHAR2_TABLE_100
1138: , p1_a2 JTF_VARCHAR2_TABLE_100
1139: )
1140: as
1141: ddrules jtf_dpf.new_rule_param_tbl;
1142: ddindx binary_integer; indx binary_integer;
1184: return ddrosetta_retval;
1185: end;
1186:
1187: procedure phys_attribs_update(p_ppid NUMBER
1188: , p1_a0 JTF_VARCHAR2_TABLE_100
1189: , p1_a1 JTF_VARCHAR2_TABLE_300
1190: )
1191: as
1192: ddp_new_ones jtf_dpf.new_phys_attribs_tbl;