18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out nocopy iex_dunning_pub.ag_dn_xref_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out nocopy iex_dunning_pub.ag_dn_xref_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out nocopy iex_dunning_pub.ag_dn_xref_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_NUMBER_TABLE
22: procedure rosetta_table_copy_in_p1(t out nocopy iex_dunning_pub.ag_dn_xref_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_DATE_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_DATE_TABLE
35: , a13 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_DATE_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_DATE_TABLE
37: , a15 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_DATE_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_DATE_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_NUMBER_TABLE
39: ) as
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_DATE_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_DATE_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_NUMBER_TABLE
39: ) as
40: ddindx binary_integer; indx binary_integer;
41: begin
34: , a12 JTF_DATE_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_DATE_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_NUMBER_TABLE
39: ) as
40: ddindx binary_integer; indx binary_integer;
41: begin
42: if a0 is not null and a0.count > 0 then
69: end loop;
70: end if;
71: end if;
72: end rosetta_table_copy_in_p1;
73: procedure rosetta_table_copy_out_p1(t iex_dunning_pub.ag_dn_xref_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
74: , a1 out nocopy JTF_NUMBER_TABLE
75: , a2 out nocopy JTF_NUMBER_TABLE
76: , a3 out nocopy JTF_VARCHAR2_TABLE_100
77: , a4 out nocopy JTF_NUMBER_TABLE
70: end if;
71: end if;
72: end rosetta_table_copy_in_p1;
73: procedure rosetta_table_copy_out_p1(t iex_dunning_pub.ag_dn_xref_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
74: , a1 out nocopy JTF_NUMBER_TABLE
75: , a2 out nocopy JTF_NUMBER_TABLE
76: , a3 out nocopy JTF_VARCHAR2_TABLE_100
77: , a4 out nocopy JTF_NUMBER_TABLE
78: , a5 out nocopy JTF_VARCHAR2_TABLE_100
71: end if;
72: end rosetta_table_copy_in_p1;
73: procedure rosetta_table_copy_out_p1(t iex_dunning_pub.ag_dn_xref_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
74: , a1 out nocopy JTF_NUMBER_TABLE
75: , a2 out nocopy JTF_NUMBER_TABLE
76: , a3 out nocopy JTF_VARCHAR2_TABLE_100
77: , a4 out nocopy JTF_NUMBER_TABLE
78: , a5 out nocopy JTF_VARCHAR2_TABLE_100
79: , a6 out nocopy JTF_NUMBER_TABLE
73: procedure rosetta_table_copy_out_p1(t iex_dunning_pub.ag_dn_xref_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
74: , a1 out nocopy JTF_NUMBER_TABLE
75: , a2 out nocopy JTF_NUMBER_TABLE
76: , a3 out nocopy JTF_VARCHAR2_TABLE_100
77: , a4 out nocopy JTF_NUMBER_TABLE
78: , a5 out nocopy JTF_VARCHAR2_TABLE_100
79: , a6 out nocopy JTF_NUMBER_TABLE
80: , a7 out nocopy JTF_NUMBER_TABLE
81: , a8 out nocopy JTF_NUMBER_TABLE
75: , a2 out nocopy JTF_NUMBER_TABLE
76: , a3 out nocopy JTF_VARCHAR2_TABLE_100
77: , a4 out nocopy JTF_NUMBER_TABLE
78: , a5 out nocopy JTF_VARCHAR2_TABLE_100
79: , a6 out nocopy JTF_NUMBER_TABLE
80: , a7 out nocopy JTF_NUMBER_TABLE
81: , a8 out nocopy JTF_NUMBER_TABLE
82: , a9 out nocopy JTF_NUMBER_TABLE
83: , a10 out nocopy JTF_VARCHAR2_TABLE_100
76: , a3 out nocopy JTF_VARCHAR2_TABLE_100
77: , a4 out nocopy JTF_NUMBER_TABLE
78: , a5 out nocopy JTF_VARCHAR2_TABLE_100
79: , a6 out nocopy JTF_NUMBER_TABLE
80: , a7 out nocopy JTF_NUMBER_TABLE
81: , a8 out nocopy JTF_NUMBER_TABLE
82: , a9 out nocopy JTF_NUMBER_TABLE
83: , a10 out nocopy JTF_VARCHAR2_TABLE_100
84: , a11 out nocopy JTF_NUMBER_TABLE
77: , a4 out nocopy JTF_NUMBER_TABLE
78: , a5 out nocopy JTF_VARCHAR2_TABLE_100
79: , a6 out nocopy JTF_NUMBER_TABLE
80: , a7 out nocopy JTF_NUMBER_TABLE
81: , a8 out nocopy JTF_NUMBER_TABLE
82: , a9 out nocopy JTF_NUMBER_TABLE
83: , a10 out nocopy JTF_VARCHAR2_TABLE_100
84: , a11 out nocopy JTF_NUMBER_TABLE
85: , a12 out nocopy JTF_DATE_TABLE
78: , a5 out nocopy JTF_VARCHAR2_TABLE_100
79: , a6 out nocopy JTF_NUMBER_TABLE
80: , a7 out nocopy JTF_NUMBER_TABLE
81: , a8 out nocopy JTF_NUMBER_TABLE
82: , a9 out nocopy JTF_NUMBER_TABLE
83: , a10 out nocopy JTF_VARCHAR2_TABLE_100
84: , a11 out nocopy JTF_NUMBER_TABLE
85: , a12 out nocopy JTF_DATE_TABLE
86: , a13 out nocopy JTF_NUMBER_TABLE
80: , a7 out nocopy JTF_NUMBER_TABLE
81: , a8 out nocopy JTF_NUMBER_TABLE
82: , a9 out nocopy JTF_NUMBER_TABLE
83: , a10 out nocopy JTF_VARCHAR2_TABLE_100
84: , a11 out nocopy JTF_NUMBER_TABLE
85: , a12 out nocopy JTF_DATE_TABLE
86: , a13 out nocopy JTF_NUMBER_TABLE
87: , a14 out nocopy JTF_DATE_TABLE
88: , a15 out nocopy JTF_NUMBER_TABLE
82: , a9 out nocopy JTF_NUMBER_TABLE
83: , a10 out nocopy JTF_VARCHAR2_TABLE_100
84: , a11 out nocopy JTF_NUMBER_TABLE
85: , a12 out nocopy JTF_DATE_TABLE
86: , a13 out nocopy JTF_NUMBER_TABLE
87: , a14 out nocopy JTF_DATE_TABLE
88: , a15 out nocopy JTF_NUMBER_TABLE
89: , a16 out nocopy JTF_NUMBER_TABLE
90: ) as
84: , a11 out nocopy JTF_NUMBER_TABLE
85: , a12 out nocopy JTF_DATE_TABLE
86: , a13 out nocopy JTF_NUMBER_TABLE
87: , a14 out nocopy JTF_DATE_TABLE
88: , a15 out nocopy JTF_NUMBER_TABLE
89: , a16 out nocopy JTF_NUMBER_TABLE
90: ) as
91: ddindx binary_integer; indx binary_integer;
92: begin
85: , a12 out nocopy JTF_DATE_TABLE
86: , a13 out nocopy JTF_NUMBER_TABLE
87: , a14 out nocopy JTF_DATE_TABLE
88: , a15 out nocopy JTF_NUMBER_TABLE
89: , a16 out nocopy JTF_NUMBER_TABLE
90: ) as
91: ddindx binary_integer; indx binary_integer;
92: begin
93: if t is null or t.count = 0 then
90: ) as
91: ddindx binary_integer; indx binary_integer;
92: begin
93: if t is null or t.count = 0 then
94: a0 := JTF_NUMBER_TABLE();
95: a1 := JTF_NUMBER_TABLE();
96: a2 := JTF_NUMBER_TABLE();
97: a3 := JTF_VARCHAR2_TABLE_100();
98: a4 := JTF_NUMBER_TABLE();
91: ddindx binary_integer; indx binary_integer;
92: begin
93: if t is null or t.count = 0 then
94: a0 := JTF_NUMBER_TABLE();
95: a1 := JTF_NUMBER_TABLE();
96: a2 := JTF_NUMBER_TABLE();
97: a3 := JTF_VARCHAR2_TABLE_100();
98: a4 := JTF_NUMBER_TABLE();
99: a5 := JTF_VARCHAR2_TABLE_100();
92: begin
93: if t is null or t.count = 0 then
94: a0 := JTF_NUMBER_TABLE();
95: a1 := JTF_NUMBER_TABLE();
96: a2 := JTF_NUMBER_TABLE();
97: a3 := JTF_VARCHAR2_TABLE_100();
98: a4 := JTF_NUMBER_TABLE();
99: a5 := JTF_VARCHAR2_TABLE_100();
100: a6 := JTF_NUMBER_TABLE();
94: a0 := JTF_NUMBER_TABLE();
95: a1 := JTF_NUMBER_TABLE();
96: a2 := JTF_NUMBER_TABLE();
97: a3 := JTF_VARCHAR2_TABLE_100();
98: a4 := JTF_NUMBER_TABLE();
99: a5 := JTF_VARCHAR2_TABLE_100();
100: a6 := JTF_NUMBER_TABLE();
101: a7 := JTF_NUMBER_TABLE();
102: a8 := JTF_NUMBER_TABLE();
96: a2 := JTF_NUMBER_TABLE();
97: a3 := JTF_VARCHAR2_TABLE_100();
98: a4 := JTF_NUMBER_TABLE();
99: a5 := JTF_VARCHAR2_TABLE_100();
100: a6 := JTF_NUMBER_TABLE();
101: a7 := JTF_NUMBER_TABLE();
102: a8 := JTF_NUMBER_TABLE();
103: a9 := JTF_NUMBER_TABLE();
104: a10 := JTF_VARCHAR2_TABLE_100();
97: a3 := JTF_VARCHAR2_TABLE_100();
98: a4 := JTF_NUMBER_TABLE();
99: a5 := JTF_VARCHAR2_TABLE_100();
100: a6 := JTF_NUMBER_TABLE();
101: a7 := JTF_NUMBER_TABLE();
102: a8 := JTF_NUMBER_TABLE();
103: a9 := JTF_NUMBER_TABLE();
104: a10 := JTF_VARCHAR2_TABLE_100();
105: a11 := JTF_NUMBER_TABLE();
98: a4 := JTF_NUMBER_TABLE();
99: a5 := JTF_VARCHAR2_TABLE_100();
100: a6 := JTF_NUMBER_TABLE();
101: a7 := JTF_NUMBER_TABLE();
102: a8 := JTF_NUMBER_TABLE();
103: a9 := JTF_NUMBER_TABLE();
104: a10 := JTF_VARCHAR2_TABLE_100();
105: a11 := JTF_NUMBER_TABLE();
106: a12 := JTF_DATE_TABLE();
99: a5 := JTF_VARCHAR2_TABLE_100();
100: a6 := JTF_NUMBER_TABLE();
101: a7 := JTF_NUMBER_TABLE();
102: a8 := JTF_NUMBER_TABLE();
103: a9 := JTF_NUMBER_TABLE();
104: a10 := JTF_VARCHAR2_TABLE_100();
105: a11 := JTF_NUMBER_TABLE();
106: a12 := JTF_DATE_TABLE();
107: a13 := JTF_NUMBER_TABLE();
101: a7 := JTF_NUMBER_TABLE();
102: a8 := JTF_NUMBER_TABLE();
103: a9 := JTF_NUMBER_TABLE();
104: a10 := JTF_VARCHAR2_TABLE_100();
105: a11 := JTF_NUMBER_TABLE();
106: a12 := JTF_DATE_TABLE();
107: a13 := JTF_NUMBER_TABLE();
108: a14 := JTF_DATE_TABLE();
109: a15 := JTF_NUMBER_TABLE();
103: a9 := JTF_NUMBER_TABLE();
104: a10 := JTF_VARCHAR2_TABLE_100();
105: a11 := JTF_NUMBER_TABLE();
106: a12 := JTF_DATE_TABLE();
107: a13 := JTF_NUMBER_TABLE();
108: a14 := JTF_DATE_TABLE();
109: a15 := JTF_NUMBER_TABLE();
110: a16 := JTF_NUMBER_TABLE();
111: else
105: a11 := JTF_NUMBER_TABLE();
106: a12 := JTF_DATE_TABLE();
107: a13 := JTF_NUMBER_TABLE();
108: a14 := JTF_DATE_TABLE();
109: a15 := JTF_NUMBER_TABLE();
110: a16 := JTF_NUMBER_TABLE();
111: else
112: a0 := JTF_NUMBER_TABLE();
113: a1 := JTF_NUMBER_TABLE();
106: a12 := JTF_DATE_TABLE();
107: a13 := JTF_NUMBER_TABLE();
108: a14 := JTF_DATE_TABLE();
109: a15 := JTF_NUMBER_TABLE();
110: a16 := JTF_NUMBER_TABLE();
111: else
112: a0 := JTF_NUMBER_TABLE();
113: a1 := JTF_NUMBER_TABLE();
114: a2 := JTF_NUMBER_TABLE();
108: a14 := JTF_DATE_TABLE();
109: a15 := JTF_NUMBER_TABLE();
110: a16 := JTF_NUMBER_TABLE();
111: else
112: a0 := JTF_NUMBER_TABLE();
113: a1 := JTF_NUMBER_TABLE();
114: a2 := JTF_NUMBER_TABLE();
115: a3 := JTF_VARCHAR2_TABLE_100();
116: a4 := JTF_NUMBER_TABLE();
109: a15 := JTF_NUMBER_TABLE();
110: a16 := JTF_NUMBER_TABLE();
111: else
112: a0 := JTF_NUMBER_TABLE();
113: a1 := JTF_NUMBER_TABLE();
114: a2 := JTF_NUMBER_TABLE();
115: a3 := JTF_VARCHAR2_TABLE_100();
116: a4 := JTF_NUMBER_TABLE();
117: a5 := JTF_VARCHAR2_TABLE_100();
110: a16 := JTF_NUMBER_TABLE();
111: else
112: a0 := JTF_NUMBER_TABLE();
113: a1 := JTF_NUMBER_TABLE();
114: a2 := JTF_NUMBER_TABLE();
115: a3 := JTF_VARCHAR2_TABLE_100();
116: a4 := JTF_NUMBER_TABLE();
117: a5 := JTF_VARCHAR2_TABLE_100();
118: a6 := JTF_NUMBER_TABLE();
112: a0 := JTF_NUMBER_TABLE();
113: a1 := JTF_NUMBER_TABLE();
114: a2 := JTF_NUMBER_TABLE();
115: a3 := JTF_VARCHAR2_TABLE_100();
116: a4 := JTF_NUMBER_TABLE();
117: a5 := JTF_VARCHAR2_TABLE_100();
118: a6 := JTF_NUMBER_TABLE();
119: a7 := JTF_NUMBER_TABLE();
120: a8 := JTF_NUMBER_TABLE();
114: a2 := JTF_NUMBER_TABLE();
115: a3 := JTF_VARCHAR2_TABLE_100();
116: a4 := JTF_NUMBER_TABLE();
117: a5 := JTF_VARCHAR2_TABLE_100();
118: a6 := JTF_NUMBER_TABLE();
119: a7 := JTF_NUMBER_TABLE();
120: a8 := JTF_NUMBER_TABLE();
121: a9 := JTF_NUMBER_TABLE();
122: a10 := JTF_VARCHAR2_TABLE_100();
115: a3 := JTF_VARCHAR2_TABLE_100();
116: a4 := JTF_NUMBER_TABLE();
117: a5 := JTF_VARCHAR2_TABLE_100();
118: a6 := JTF_NUMBER_TABLE();
119: a7 := JTF_NUMBER_TABLE();
120: a8 := JTF_NUMBER_TABLE();
121: a9 := JTF_NUMBER_TABLE();
122: a10 := JTF_VARCHAR2_TABLE_100();
123: a11 := JTF_NUMBER_TABLE();
116: a4 := JTF_NUMBER_TABLE();
117: a5 := JTF_VARCHAR2_TABLE_100();
118: a6 := JTF_NUMBER_TABLE();
119: a7 := JTF_NUMBER_TABLE();
120: a8 := JTF_NUMBER_TABLE();
121: a9 := JTF_NUMBER_TABLE();
122: a10 := JTF_VARCHAR2_TABLE_100();
123: a11 := JTF_NUMBER_TABLE();
124: a12 := JTF_DATE_TABLE();
117: a5 := JTF_VARCHAR2_TABLE_100();
118: a6 := JTF_NUMBER_TABLE();
119: a7 := JTF_NUMBER_TABLE();
120: a8 := JTF_NUMBER_TABLE();
121: a9 := JTF_NUMBER_TABLE();
122: a10 := JTF_VARCHAR2_TABLE_100();
123: a11 := JTF_NUMBER_TABLE();
124: a12 := JTF_DATE_TABLE();
125: a13 := JTF_NUMBER_TABLE();
119: a7 := JTF_NUMBER_TABLE();
120: a8 := JTF_NUMBER_TABLE();
121: a9 := JTF_NUMBER_TABLE();
122: a10 := JTF_VARCHAR2_TABLE_100();
123: a11 := JTF_NUMBER_TABLE();
124: a12 := JTF_DATE_TABLE();
125: a13 := JTF_NUMBER_TABLE();
126: a14 := JTF_DATE_TABLE();
127: a15 := JTF_NUMBER_TABLE();
121: a9 := JTF_NUMBER_TABLE();
122: a10 := JTF_VARCHAR2_TABLE_100();
123: a11 := JTF_NUMBER_TABLE();
124: a12 := JTF_DATE_TABLE();
125: a13 := JTF_NUMBER_TABLE();
126: a14 := JTF_DATE_TABLE();
127: a15 := JTF_NUMBER_TABLE();
128: a16 := JTF_NUMBER_TABLE();
129: if t.count > 0 then
123: a11 := JTF_NUMBER_TABLE();
124: a12 := JTF_DATE_TABLE();
125: a13 := JTF_NUMBER_TABLE();
126: a14 := JTF_DATE_TABLE();
127: a15 := JTF_NUMBER_TABLE();
128: a16 := JTF_NUMBER_TABLE();
129: if t.count > 0 then
130: a0.extend(t.count);
131: a1.extend(t.count);
124: a12 := JTF_DATE_TABLE();
125: a13 := JTF_NUMBER_TABLE();
126: a14 := JTF_DATE_TABLE();
127: a15 := JTF_NUMBER_TABLE();
128: a16 := JTF_NUMBER_TABLE();
129: if t.count > 0 then
130: a0.extend(t.count);
131: a1.extend(t.count);
132: a2.extend(t.count);
173: end if;
174: end if;
175: end rosetta_table_copy_out_p1;
176:
177: procedure rosetta_table_copy_in_p2(t out nocopy iex_dunning_pub.ag_dn_xref_id_tbl_type, a0 JTF_NUMBER_TABLE) as
178: ddindx binary_integer; indx binary_integer;
179: begin
180: if a0 is not null and a0.count > 0 then
181: if a0.count > 0 then
191: end loop;
192: end if;
193: end if;
194: end rosetta_table_copy_in_p2;
195: procedure rosetta_table_copy_out_p2(t iex_dunning_pub.ag_dn_xref_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
196: ddindx binary_integer; indx binary_integer;
197: begin
198: if t is null or t.count = 0 then
199: a0 := JTF_NUMBER_TABLE();
195: procedure rosetta_table_copy_out_p2(t iex_dunning_pub.ag_dn_xref_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
196: ddindx binary_integer; indx binary_integer;
197: begin
198: if t is null or t.count = 0 then
199: a0 := JTF_NUMBER_TABLE();
200: else
201: a0 := JTF_NUMBER_TABLE();
202: if t.count > 0 then
203: a0.extend(t.count);
197: begin
198: if t is null or t.count = 0 then
199: a0 := JTF_NUMBER_TABLE();
200: else
201: a0 := JTF_NUMBER_TABLE();
202: if t.count > 0 then
203: a0.extend(t.count);
204: ddindx := t.first;
205: indx := 1;
214: end if;
215: end if;
216: end rosetta_table_copy_out_p2;
217:
218: procedure rosetta_table_copy_in_p8(t out nocopy iex_dunning_pub.dunning_tbl_type, a0 JTF_NUMBER_TABLE
219: , a1 JTF_NUMBER_TABLE
220: , a2 JTF_VARCHAR2_TABLE_100
221: , a3 JTF_DATE_TABLE
222: , a4 JTF_VARCHAR2_TABLE_300
215: end if;
216: end rosetta_table_copy_out_p2;
217:
218: procedure rosetta_table_copy_in_p8(t out nocopy iex_dunning_pub.dunning_tbl_type, a0 JTF_NUMBER_TABLE
219: , a1 JTF_NUMBER_TABLE
220: , a2 JTF_VARCHAR2_TABLE_100
221: , a3 JTF_DATE_TABLE
222: , a4 JTF_VARCHAR2_TABLE_300
223: , a5 JTF_NUMBER_TABLE
219: , a1 JTF_NUMBER_TABLE
220: , a2 JTF_VARCHAR2_TABLE_100
221: , a3 JTF_DATE_TABLE
222: , a4 JTF_VARCHAR2_TABLE_300
223: , a5 JTF_NUMBER_TABLE
224: , a6 JTF_NUMBER_TABLE
225: , a7 JTF_NUMBER_TABLE
226: , a8 JTF_NUMBER_TABLE
227: , a9 JTF_NUMBER_TABLE
220: , a2 JTF_VARCHAR2_TABLE_100
221: , a3 JTF_DATE_TABLE
222: , a4 JTF_VARCHAR2_TABLE_300
223: , a5 JTF_NUMBER_TABLE
224: , a6 JTF_NUMBER_TABLE
225: , a7 JTF_NUMBER_TABLE
226: , a8 JTF_NUMBER_TABLE
227: , a9 JTF_NUMBER_TABLE
228: , a10 JTF_NUMBER_TABLE
221: , a3 JTF_DATE_TABLE
222: , a4 JTF_VARCHAR2_TABLE_300
223: , a5 JTF_NUMBER_TABLE
224: , a6 JTF_NUMBER_TABLE
225: , a7 JTF_NUMBER_TABLE
226: , a8 JTF_NUMBER_TABLE
227: , a9 JTF_NUMBER_TABLE
228: , a10 JTF_NUMBER_TABLE
229: , a11 JTF_VARCHAR2_TABLE_100
222: , a4 JTF_VARCHAR2_TABLE_300
223: , a5 JTF_NUMBER_TABLE
224: , a6 JTF_NUMBER_TABLE
225: , a7 JTF_NUMBER_TABLE
226: , a8 JTF_NUMBER_TABLE
227: , a9 JTF_NUMBER_TABLE
228: , a10 JTF_NUMBER_TABLE
229: , a11 JTF_VARCHAR2_TABLE_100
230: , a12 JTF_VARCHAR2_TABLE_100
223: , a5 JTF_NUMBER_TABLE
224: , a6 JTF_NUMBER_TABLE
225: , a7 JTF_NUMBER_TABLE
226: , a8 JTF_NUMBER_TABLE
227: , a9 JTF_NUMBER_TABLE
228: , a10 JTF_NUMBER_TABLE
229: , a11 JTF_VARCHAR2_TABLE_100
230: , a12 JTF_VARCHAR2_TABLE_100
231: , a13 JTF_NUMBER_TABLE
224: , a6 JTF_NUMBER_TABLE
225: , a7 JTF_NUMBER_TABLE
226: , a8 JTF_NUMBER_TABLE
227: , a9 JTF_NUMBER_TABLE
228: , a10 JTF_NUMBER_TABLE
229: , a11 JTF_VARCHAR2_TABLE_100
230: , a12 JTF_VARCHAR2_TABLE_100
231: , a13 JTF_NUMBER_TABLE
232: , a14 JTF_VARCHAR2_TABLE_100
227: , a9 JTF_NUMBER_TABLE
228: , a10 JTF_NUMBER_TABLE
229: , a11 JTF_VARCHAR2_TABLE_100
230: , a12 JTF_VARCHAR2_TABLE_100
231: , a13 JTF_NUMBER_TABLE
232: , a14 JTF_VARCHAR2_TABLE_100
233: , a15 JTF_NUMBER_TABLE
234: , a16 JTF_VARCHAR2_TABLE_100
235: , a17 JTF_DATE_TABLE
229: , a11 JTF_VARCHAR2_TABLE_100
230: , a12 JTF_VARCHAR2_TABLE_100
231: , a13 JTF_NUMBER_TABLE
232: , a14 JTF_VARCHAR2_TABLE_100
233: , a15 JTF_NUMBER_TABLE
234: , a16 JTF_VARCHAR2_TABLE_100
235: , a17 JTF_DATE_TABLE
236: , a18 JTF_NUMBER_TABLE
237: , a19 JTF_DATE_TABLE
232: , a14 JTF_VARCHAR2_TABLE_100
233: , a15 JTF_NUMBER_TABLE
234: , a16 JTF_VARCHAR2_TABLE_100
235: , a17 JTF_DATE_TABLE
236: , a18 JTF_NUMBER_TABLE
237: , a19 JTF_DATE_TABLE
238: , a20 JTF_NUMBER_TABLE
239: , a21 JTF_NUMBER_TABLE
240: , a22 JTF_NUMBER_TABLE
234: , a16 JTF_VARCHAR2_TABLE_100
235: , a17 JTF_DATE_TABLE
236: , a18 JTF_NUMBER_TABLE
237: , a19 JTF_DATE_TABLE
238: , a20 JTF_NUMBER_TABLE
239: , a21 JTF_NUMBER_TABLE
240: , a22 JTF_NUMBER_TABLE
241: , a23 JTF_VARCHAR2_TABLE_100
242: , a24 JTF_NUMBER_TABLE
235: , a17 JTF_DATE_TABLE
236: , a18 JTF_NUMBER_TABLE
237: , a19 JTF_DATE_TABLE
238: , a20 JTF_NUMBER_TABLE
239: , a21 JTF_NUMBER_TABLE
240: , a22 JTF_NUMBER_TABLE
241: , a23 JTF_VARCHAR2_TABLE_100
242: , a24 JTF_NUMBER_TABLE
243: , a25 JTF_NUMBER_TABLE
236: , a18 JTF_NUMBER_TABLE
237: , a19 JTF_DATE_TABLE
238: , a20 JTF_NUMBER_TABLE
239: , a21 JTF_NUMBER_TABLE
240: , a22 JTF_NUMBER_TABLE
241: , a23 JTF_VARCHAR2_TABLE_100
242: , a24 JTF_NUMBER_TABLE
243: , a25 JTF_NUMBER_TABLE
244: ) as
238: , a20 JTF_NUMBER_TABLE
239: , a21 JTF_NUMBER_TABLE
240: , a22 JTF_NUMBER_TABLE
241: , a23 JTF_VARCHAR2_TABLE_100
242: , a24 JTF_NUMBER_TABLE
243: , a25 JTF_NUMBER_TABLE
244: ) as
245: ddindx binary_integer; indx binary_integer;
246: begin
239: , a21 JTF_NUMBER_TABLE
240: , a22 JTF_NUMBER_TABLE
241: , a23 JTF_VARCHAR2_TABLE_100
242: , a24 JTF_NUMBER_TABLE
243: , a25 JTF_NUMBER_TABLE
244: ) as
245: ddindx binary_integer; indx binary_integer;
246: begin
247: if a0 is not null and a0.count > 0 then
283: end loop;
284: end if;
285: end if;
286: end rosetta_table_copy_in_p8;
287: procedure rosetta_table_copy_out_p8(t iex_dunning_pub.dunning_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
288: , a1 out nocopy JTF_NUMBER_TABLE
289: , a2 out nocopy JTF_VARCHAR2_TABLE_100
290: , a3 out nocopy JTF_DATE_TABLE
291: , a4 out nocopy JTF_VARCHAR2_TABLE_300
284: end if;
285: end if;
286: end rosetta_table_copy_in_p8;
287: procedure rosetta_table_copy_out_p8(t iex_dunning_pub.dunning_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
288: , a1 out nocopy JTF_NUMBER_TABLE
289: , a2 out nocopy JTF_VARCHAR2_TABLE_100
290: , a3 out nocopy JTF_DATE_TABLE
291: , a4 out nocopy JTF_VARCHAR2_TABLE_300
292: , a5 out nocopy JTF_NUMBER_TABLE
288: , a1 out nocopy JTF_NUMBER_TABLE
289: , a2 out nocopy JTF_VARCHAR2_TABLE_100
290: , a3 out nocopy JTF_DATE_TABLE
291: , a4 out nocopy JTF_VARCHAR2_TABLE_300
292: , a5 out nocopy JTF_NUMBER_TABLE
293: , a6 out nocopy JTF_NUMBER_TABLE
294: , a7 out nocopy JTF_NUMBER_TABLE
295: , a8 out nocopy JTF_NUMBER_TABLE
296: , a9 out nocopy JTF_NUMBER_TABLE
289: , a2 out nocopy JTF_VARCHAR2_TABLE_100
290: , a3 out nocopy JTF_DATE_TABLE
291: , a4 out nocopy JTF_VARCHAR2_TABLE_300
292: , a5 out nocopy JTF_NUMBER_TABLE
293: , a6 out nocopy JTF_NUMBER_TABLE
294: , a7 out nocopy JTF_NUMBER_TABLE
295: , a8 out nocopy JTF_NUMBER_TABLE
296: , a9 out nocopy JTF_NUMBER_TABLE
297: , a10 out nocopy JTF_NUMBER_TABLE
290: , a3 out nocopy JTF_DATE_TABLE
291: , a4 out nocopy JTF_VARCHAR2_TABLE_300
292: , a5 out nocopy JTF_NUMBER_TABLE
293: , a6 out nocopy JTF_NUMBER_TABLE
294: , a7 out nocopy JTF_NUMBER_TABLE
295: , a8 out nocopy JTF_NUMBER_TABLE
296: , a9 out nocopy JTF_NUMBER_TABLE
297: , a10 out nocopy JTF_NUMBER_TABLE
298: , a11 out nocopy JTF_VARCHAR2_TABLE_100
291: , a4 out nocopy JTF_VARCHAR2_TABLE_300
292: , a5 out nocopy JTF_NUMBER_TABLE
293: , a6 out nocopy JTF_NUMBER_TABLE
294: , a7 out nocopy JTF_NUMBER_TABLE
295: , a8 out nocopy JTF_NUMBER_TABLE
296: , a9 out nocopy JTF_NUMBER_TABLE
297: , a10 out nocopy JTF_NUMBER_TABLE
298: , a11 out nocopy JTF_VARCHAR2_TABLE_100
299: , a12 out nocopy JTF_VARCHAR2_TABLE_100
292: , a5 out nocopy JTF_NUMBER_TABLE
293: , a6 out nocopy JTF_NUMBER_TABLE
294: , a7 out nocopy JTF_NUMBER_TABLE
295: , a8 out nocopy JTF_NUMBER_TABLE
296: , a9 out nocopy JTF_NUMBER_TABLE
297: , a10 out nocopy JTF_NUMBER_TABLE
298: , a11 out nocopy JTF_VARCHAR2_TABLE_100
299: , a12 out nocopy JTF_VARCHAR2_TABLE_100
300: , a13 out nocopy JTF_NUMBER_TABLE
293: , a6 out nocopy JTF_NUMBER_TABLE
294: , a7 out nocopy JTF_NUMBER_TABLE
295: , a8 out nocopy JTF_NUMBER_TABLE
296: , a9 out nocopy JTF_NUMBER_TABLE
297: , a10 out nocopy JTF_NUMBER_TABLE
298: , a11 out nocopy JTF_VARCHAR2_TABLE_100
299: , a12 out nocopy JTF_VARCHAR2_TABLE_100
300: , a13 out nocopy JTF_NUMBER_TABLE
301: , a14 out nocopy JTF_VARCHAR2_TABLE_100
296: , a9 out nocopy JTF_NUMBER_TABLE
297: , a10 out nocopy JTF_NUMBER_TABLE
298: , a11 out nocopy JTF_VARCHAR2_TABLE_100
299: , a12 out nocopy JTF_VARCHAR2_TABLE_100
300: , a13 out nocopy JTF_NUMBER_TABLE
301: , a14 out nocopy JTF_VARCHAR2_TABLE_100
302: , a15 out nocopy JTF_NUMBER_TABLE
303: , a16 out nocopy JTF_VARCHAR2_TABLE_100
304: , a17 out nocopy JTF_DATE_TABLE
298: , a11 out nocopy JTF_VARCHAR2_TABLE_100
299: , a12 out nocopy JTF_VARCHAR2_TABLE_100
300: , a13 out nocopy JTF_NUMBER_TABLE
301: , a14 out nocopy JTF_VARCHAR2_TABLE_100
302: , a15 out nocopy JTF_NUMBER_TABLE
303: , a16 out nocopy JTF_VARCHAR2_TABLE_100
304: , a17 out nocopy JTF_DATE_TABLE
305: , a18 out nocopy JTF_NUMBER_TABLE
306: , a19 out nocopy JTF_DATE_TABLE
301: , a14 out nocopy JTF_VARCHAR2_TABLE_100
302: , a15 out nocopy JTF_NUMBER_TABLE
303: , a16 out nocopy JTF_VARCHAR2_TABLE_100
304: , a17 out nocopy JTF_DATE_TABLE
305: , a18 out nocopy JTF_NUMBER_TABLE
306: , a19 out nocopy JTF_DATE_TABLE
307: , a20 out nocopy JTF_NUMBER_TABLE
308: , a21 out nocopy JTF_NUMBER_TABLE
309: , a22 out nocopy JTF_NUMBER_TABLE
303: , a16 out nocopy JTF_VARCHAR2_TABLE_100
304: , a17 out nocopy JTF_DATE_TABLE
305: , a18 out nocopy JTF_NUMBER_TABLE
306: , a19 out nocopy JTF_DATE_TABLE
307: , a20 out nocopy JTF_NUMBER_TABLE
308: , a21 out nocopy JTF_NUMBER_TABLE
309: , a22 out nocopy JTF_NUMBER_TABLE
310: , a23 out nocopy JTF_VARCHAR2_TABLE_100
311: , a24 out nocopy JTF_NUMBER_TABLE
304: , a17 out nocopy JTF_DATE_TABLE
305: , a18 out nocopy JTF_NUMBER_TABLE
306: , a19 out nocopy JTF_DATE_TABLE
307: , a20 out nocopy JTF_NUMBER_TABLE
308: , a21 out nocopy JTF_NUMBER_TABLE
309: , a22 out nocopy JTF_NUMBER_TABLE
310: , a23 out nocopy JTF_VARCHAR2_TABLE_100
311: , a24 out nocopy JTF_NUMBER_TABLE
312: , a25 out nocopy JTF_NUMBER_TABLE
305: , a18 out nocopy JTF_NUMBER_TABLE
306: , a19 out nocopy JTF_DATE_TABLE
307: , a20 out nocopy JTF_NUMBER_TABLE
308: , a21 out nocopy JTF_NUMBER_TABLE
309: , a22 out nocopy JTF_NUMBER_TABLE
310: , a23 out nocopy JTF_VARCHAR2_TABLE_100
311: , a24 out nocopy JTF_NUMBER_TABLE
312: , a25 out nocopy JTF_NUMBER_TABLE
313: ) as
307: , a20 out nocopy JTF_NUMBER_TABLE
308: , a21 out nocopy JTF_NUMBER_TABLE
309: , a22 out nocopy JTF_NUMBER_TABLE
310: , a23 out nocopy JTF_VARCHAR2_TABLE_100
311: , a24 out nocopy JTF_NUMBER_TABLE
312: , a25 out nocopy JTF_NUMBER_TABLE
313: ) as
314: ddindx binary_integer; indx binary_integer;
315: begin
308: , a21 out nocopy JTF_NUMBER_TABLE
309: , a22 out nocopy JTF_NUMBER_TABLE
310: , a23 out nocopy JTF_VARCHAR2_TABLE_100
311: , a24 out nocopy JTF_NUMBER_TABLE
312: , a25 out nocopy JTF_NUMBER_TABLE
313: ) as
314: ddindx binary_integer; indx binary_integer;
315: begin
316: if t is null or t.count = 0 then
313: ) as
314: ddindx binary_integer; indx binary_integer;
315: begin
316: if t is null or t.count = 0 then
317: a0 := JTF_NUMBER_TABLE();
318: a1 := JTF_NUMBER_TABLE();
319: a2 := JTF_VARCHAR2_TABLE_100();
320: a3 := JTF_DATE_TABLE();
321: a4 := JTF_VARCHAR2_TABLE_300();
314: ddindx binary_integer; indx binary_integer;
315: begin
316: if t is null or t.count = 0 then
317: a0 := JTF_NUMBER_TABLE();
318: a1 := JTF_NUMBER_TABLE();
319: a2 := JTF_VARCHAR2_TABLE_100();
320: a3 := JTF_DATE_TABLE();
321: a4 := JTF_VARCHAR2_TABLE_300();
322: a5 := JTF_NUMBER_TABLE();
318: a1 := JTF_NUMBER_TABLE();
319: a2 := JTF_VARCHAR2_TABLE_100();
320: a3 := JTF_DATE_TABLE();
321: a4 := JTF_VARCHAR2_TABLE_300();
322: a5 := JTF_NUMBER_TABLE();
323: a6 := JTF_NUMBER_TABLE();
324: a7 := JTF_NUMBER_TABLE();
325: a8 := JTF_NUMBER_TABLE();
326: a9 := JTF_NUMBER_TABLE();
319: a2 := JTF_VARCHAR2_TABLE_100();
320: a3 := JTF_DATE_TABLE();
321: a4 := JTF_VARCHAR2_TABLE_300();
322: a5 := JTF_NUMBER_TABLE();
323: a6 := JTF_NUMBER_TABLE();
324: a7 := JTF_NUMBER_TABLE();
325: a8 := JTF_NUMBER_TABLE();
326: a9 := JTF_NUMBER_TABLE();
327: a10 := JTF_NUMBER_TABLE();
320: a3 := JTF_DATE_TABLE();
321: a4 := JTF_VARCHAR2_TABLE_300();
322: a5 := JTF_NUMBER_TABLE();
323: a6 := JTF_NUMBER_TABLE();
324: a7 := JTF_NUMBER_TABLE();
325: a8 := JTF_NUMBER_TABLE();
326: a9 := JTF_NUMBER_TABLE();
327: a10 := JTF_NUMBER_TABLE();
328: a11 := JTF_VARCHAR2_TABLE_100();
321: a4 := JTF_VARCHAR2_TABLE_300();
322: a5 := JTF_NUMBER_TABLE();
323: a6 := JTF_NUMBER_TABLE();
324: a7 := JTF_NUMBER_TABLE();
325: a8 := JTF_NUMBER_TABLE();
326: a9 := JTF_NUMBER_TABLE();
327: a10 := JTF_NUMBER_TABLE();
328: a11 := JTF_VARCHAR2_TABLE_100();
329: a12 := JTF_VARCHAR2_TABLE_100();
322: a5 := JTF_NUMBER_TABLE();
323: a6 := JTF_NUMBER_TABLE();
324: a7 := JTF_NUMBER_TABLE();
325: a8 := JTF_NUMBER_TABLE();
326: a9 := JTF_NUMBER_TABLE();
327: a10 := JTF_NUMBER_TABLE();
328: a11 := JTF_VARCHAR2_TABLE_100();
329: a12 := JTF_VARCHAR2_TABLE_100();
330: a13 := JTF_NUMBER_TABLE();
323: a6 := JTF_NUMBER_TABLE();
324: a7 := JTF_NUMBER_TABLE();
325: a8 := JTF_NUMBER_TABLE();
326: a9 := JTF_NUMBER_TABLE();
327: a10 := JTF_NUMBER_TABLE();
328: a11 := JTF_VARCHAR2_TABLE_100();
329: a12 := JTF_VARCHAR2_TABLE_100();
330: a13 := JTF_NUMBER_TABLE();
331: a14 := JTF_VARCHAR2_TABLE_100();
326: a9 := JTF_NUMBER_TABLE();
327: a10 := JTF_NUMBER_TABLE();
328: a11 := JTF_VARCHAR2_TABLE_100();
329: a12 := JTF_VARCHAR2_TABLE_100();
330: a13 := JTF_NUMBER_TABLE();
331: a14 := JTF_VARCHAR2_TABLE_100();
332: a15 := JTF_NUMBER_TABLE();
333: a16 := JTF_VARCHAR2_TABLE_100();
334: a17 := JTF_DATE_TABLE();
328: a11 := JTF_VARCHAR2_TABLE_100();
329: a12 := JTF_VARCHAR2_TABLE_100();
330: a13 := JTF_NUMBER_TABLE();
331: a14 := JTF_VARCHAR2_TABLE_100();
332: a15 := JTF_NUMBER_TABLE();
333: a16 := JTF_VARCHAR2_TABLE_100();
334: a17 := JTF_DATE_TABLE();
335: a18 := JTF_NUMBER_TABLE();
336: a19 := JTF_DATE_TABLE();
331: a14 := JTF_VARCHAR2_TABLE_100();
332: a15 := JTF_NUMBER_TABLE();
333: a16 := JTF_VARCHAR2_TABLE_100();
334: a17 := JTF_DATE_TABLE();
335: a18 := JTF_NUMBER_TABLE();
336: a19 := JTF_DATE_TABLE();
337: a20 := JTF_NUMBER_TABLE();
338: a21 := JTF_NUMBER_TABLE();
339: a22 := JTF_NUMBER_TABLE();
333: a16 := JTF_VARCHAR2_TABLE_100();
334: a17 := JTF_DATE_TABLE();
335: a18 := JTF_NUMBER_TABLE();
336: a19 := JTF_DATE_TABLE();
337: a20 := JTF_NUMBER_TABLE();
338: a21 := JTF_NUMBER_TABLE();
339: a22 := JTF_NUMBER_TABLE();
340: a23 := JTF_VARCHAR2_TABLE_100();
341: a24 := JTF_NUMBER_TABLE();
334: a17 := JTF_DATE_TABLE();
335: a18 := JTF_NUMBER_TABLE();
336: a19 := JTF_DATE_TABLE();
337: a20 := JTF_NUMBER_TABLE();
338: a21 := JTF_NUMBER_TABLE();
339: a22 := JTF_NUMBER_TABLE();
340: a23 := JTF_VARCHAR2_TABLE_100();
341: a24 := JTF_NUMBER_TABLE();
342: a25 := JTF_NUMBER_TABLE();
335: a18 := JTF_NUMBER_TABLE();
336: a19 := JTF_DATE_TABLE();
337: a20 := JTF_NUMBER_TABLE();
338: a21 := JTF_NUMBER_TABLE();
339: a22 := JTF_NUMBER_TABLE();
340: a23 := JTF_VARCHAR2_TABLE_100();
341: a24 := JTF_NUMBER_TABLE();
342: a25 := JTF_NUMBER_TABLE();
343: else
337: a20 := JTF_NUMBER_TABLE();
338: a21 := JTF_NUMBER_TABLE();
339: a22 := JTF_NUMBER_TABLE();
340: a23 := JTF_VARCHAR2_TABLE_100();
341: a24 := JTF_NUMBER_TABLE();
342: a25 := JTF_NUMBER_TABLE();
343: else
344: a0 := JTF_NUMBER_TABLE();
345: a1 := JTF_NUMBER_TABLE();
338: a21 := JTF_NUMBER_TABLE();
339: a22 := JTF_NUMBER_TABLE();
340: a23 := JTF_VARCHAR2_TABLE_100();
341: a24 := JTF_NUMBER_TABLE();
342: a25 := JTF_NUMBER_TABLE();
343: else
344: a0 := JTF_NUMBER_TABLE();
345: a1 := JTF_NUMBER_TABLE();
346: a2 := JTF_VARCHAR2_TABLE_100();
340: a23 := JTF_VARCHAR2_TABLE_100();
341: a24 := JTF_NUMBER_TABLE();
342: a25 := JTF_NUMBER_TABLE();
343: else
344: a0 := JTF_NUMBER_TABLE();
345: a1 := JTF_NUMBER_TABLE();
346: a2 := JTF_VARCHAR2_TABLE_100();
347: a3 := JTF_DATE_TABLE();
348: a4 := JTF_VARCHAR2_TABLE_300();
341: a24 := JTF_NUMBER_TABLE();
342: a25 := JTF_NUMBER_TABLE();
343: else
344: a0 := JTF_NUMBER_TABLE();
345: a1 := JTF_NUMBER_TABLE();
346: a2 := JTF_VARCHAR2_TABLE_100();
347: a3 := JTF_DATE_TABLE();
348: a4 := JTF_VARCHAR2_TABLE_300();
349: a5 := JTF_NUMBER_TABLE();
345: a1 := JTF_NUMBER_TABLE();
346: a2 := JTF_VARCHAR2_TABLE_100();
347: a3 := JTF_DATE_TABLE();
348: a4 := JTF_VARCHAR2_TABLE_300();
349: a5 := JTF_NUMBER_TABLE();
350: a6 := JTF_NUMBER_TABLE();
351: a7 := JTF_NUMBER_TABLE();
352: a8 := JTF_NUMBER_TABLE();
353: a9 := JTF_NUMBER_TABLE();
346: a2 := JTF_VARCHAR2_TABLE_100();
347: a3 := JTF_DATE_TABLE();
348: a4 := JTF_VARCHAR2_TABLE_300();
349: a5 := JTF_NUMBER_TABLE();
350: a6 := JTF_NUMBER_TABLE();
351: a7 := JTF_NUMBER_TABLE();
352: a8 := JTF_NUMBER_TABLE();
353: a9 := JTF_NUMBER_TABLE();
354: a10 := JTF_NUMBER_TABLE();
347: a3 := JTF_DATE_TABLE();
348: a4 := JTF_VARCHAR2_TABLE_300();
349: a5 := JTF_NUMBER_TABLE();
350: a6 := JTF_NUMBER_TABLE();
351: a7 := JTF_NUMBER_TABLE();
352: a8 := JTF_NUMBER_TABLE();
353: a9 := JTF_NUMBER_TABLE();
354: a10 := JTF_NUMBER_TABLE();
355: a11 := JTF_VARCHAR2_TABLE_100();
348: a4 := JTF_VARCHAR2_TABLE_300();
349: a5 := JTF_NUMBER_TABLE();
350: a6 := JTF_NUMBER_TABLE();
351: a7 := JTF_NUMBER_TABLE();
352: a8 := JTF_NUMBER_TABLE();
353: a9 := JTF_NUMBER_TABLE();
354: a10 := JTF_NUMBER_TABLE();
355: a11 := JTF_VARCHAR2_TABLE_100();
356: a12 := JTF_VARCHAR2_TABLE_100();
349: a5 := JTF_NUMBER_TABLE();
350: a6 := JTF_NUMBER_TABLE();
351: a7 := JTF_NUMBER_TABLE();
352: a8 := JTF_NUMBER_TABLE();
353: a9 := JTF_NUMBER_TABLE();
354: a10 := JTF_NUMBER_TABLE();
355: a11 := JTF_VARCHAR2_TABLE_100();
356: a12 := JTF_VARCHAR2_TABLE_100();
357: a13 := JTF_NUMBER_TABLE();
350: a6 := JTF_NUMBER_TABLE();
351: a7 := JTF_NUMBER_TABLE();
352: a8 := JTF_NUMBER_TABLE();
353: a9 := JTF_NUMBER_TABLE();
354: a10 := JTF_NUMBER_TABLE();
355: a11 := JTF_VARCHAR2_TABLE_100();
356: a12 := JTF_VARCHAR2_TABLE_100();
357: a13 := JTF_NUMBER_TABLE();
358: a14 := JTF_VARCHAR2_TABLE_100();
353: a9 := JTF_NUMBER_TABLE();
354: a10 := JTF_NUMBER_TABLE();
355: a11 := JTF_VARCHAR2_TABLE_100();
356: a12 := JTF_VARCHAR2_TABLE_100();
357: a13 := JTF_NUMBER_TABLE();
358: a14 := JTF_VARCHAR2_TABLE_100();
359: a15 := JTF_NUMBER_TABLE();
360: a16 := JTF_VARCHAR2_TABLE_100();
361: a17 := JTF_DATE_TABLE();
355: a11 := JTF_VARCHAR2_TABLE_100();
356: a12 := JTF_VARCHAR2_TABLE_100();
357: a13 := JTF_NUMBER_TABLE();
358: a14 := JTF_VARCHAR2_TABLE_100();
359: a15 := JTF_NUMBER_TABLE();
360: a16 := JTF_VARCHAR2_TABLE_100();
361: a17 := JTF_DATE_TABLE();
362: a18 := JTF_NUMBER_TABLE();
363: a19 := JTF_DATE_TABLE();
358: a14 := JTF_VARCHAR2_TABLE_100();
359: a15 := JTF_NUMBER_TABLE();
360: a16 := JTF_VARCHAR2_TABLE_100();
361: a17 := JTF_DATE_TABLE();
362: a18 := JTF_NUMBER_TABLE();
363: a19 := JTF_DATE_TABLE();
364: a20 := JTF_NUMBER_TABLE();
365: a21 := JTF_NUMBER_TABLE();
366: a22 := JTF_NUMBER_TABLE();
360: a16 := JTF_VARCHAR2_TABLE_100();
361: a17 := JTF_DATE_TABLE();
362: a18 := JTF_NUMBER_TABLE();
363: a19 := JTF_DATE_TABLE();
364: a20 := JTF_NUMBER_TABLE();
365: a21 := JTF_NUMBER_TABLE();
366: a22 := JTF_NUMBER_TABLE();
367: a23 := JTF_VARCHAR2_TABLE_100();
368: a24 := JTF_NUMBER_TABLE();
361: a17 := JTF_DATE_TABLE();
362: a18 := JTF_NUMBER_TABLE();
363: a19 := JTF_DATE_TABLE();
364: a20 := JTF_NUMBER_TABLE();
365: a21 := JTF_NUMBER_TABLE();
366: a22 := JTF_NUMBER_TABLE();
367: a23 := JTF_VARCHAR2_TABLE_100();
368: a24 := JTF_NUMBER_TABLE();
369: a25 := JTF_NUMBER_TABLE();
362: a18 := JTF_NUMBER_TABLE();
363: a19 := JTF_DATE_TABLE();
364: a20 := JTF_NUMBER_TABLE();
365: a21 := JTF_NUMBER_TABLE();
366: a22 := JTF_NUMBER_TABLE();
367: a23 := JTF_VARCHAR2_TABLE_100();
368: a24 := JTF_NUMBER_TABLE();
369: a25 := JTF_NUMBER_TABLE();
370: if t.count > 0 then
364: a20 := JTF_NUMBER_TABLE();
365: a21 := JTF_NUMBER_TABLE();
366: a22 := JTF_NUMBER_TABLE();
367: a23 := JTF_VARCHAR2_TABLE_100();
368: a24 := JTF_NUMBER_TABLE();
369: a25 := JTF_NUMBER_TABLE();
370: if t.count > 0 then
371: a0.extend(t.count);
372: a1.extend(t.count);
365: a21 := JTF_NUMBER_TABLE();
366: a22 := JTF_NUMBER_TABLE();
367: a23 := JTF_VARCHAR2_TABLE_100();
368: a24 := JTF_NUMBER_TABLE();
369: a25 := JTF_NUMBER_TABLE();
370: if t.count > 0 then
371: a0.extend(t.count);
372: a1.extend(t.count);
373: a2.extend(t.count);
432: end if;
433: end if;
434: end rosetta_table_copy_out_p8;
435:
436: procedure rosetta_table_copy_in_p9(t out nocopy iex_dunning_pub.delid_numlist, a0 JTF_NUMBER_TABLE) as
437: ddindx binary_integer; indx binary_integer;
438: begin
439: if a0 is null then
440: t := null;
456: end loop;
457: end if;
458: end if;
459: end rosetta_table_copy_in_p9;
460: procedure rosetta_table_copy_out_p9(t iex_dunning_pub.delid_numlist, a0 out nocopy JTF_NUMBER_TABLE) as
461: ddindx binary_integer; indx binary_integer;
462: begin
463: if t is null then
464: a0 := null;
462: begin
463: if t is null then
464: a0 := null;
465: elsif t.count = 0 then
466: a0 := JTF_NUMBER_TABLE();
467: else
468: a0 := JTF_NUMBER_TABLE();
469: if t.count > 0 then
470: a0.extend(t.count);
464: a0 := null;
465: elsif t.count = 0 then
466: a0 := JTF_NUMBER_TABLE();
467: else
468: a0 := JTF_NUMBER_TABLE();
469: if t.count > 0 then
470: a0.extend(t.count);
471: ddindx := t.first;
472: indx := 1;
484:
485: procedure create_ag_dn_xref(p_api_version NUMBER
486: , p_init_msg_list VARCHAR2
487: , p_commit VARCHAR2
488: , p3_a0 JTF_NUMBER_TABLE
489: , p3_a1 JTF_NUMBER_TABLE
490: , p3_a2 JTF_NUMBER_TABLE
491: , p3_a3 JTF_VARCHAR2_TABLE_100
492: , p3_a4 JTF_NUMBER_TABLE
485: procedure create_ag_dn_xref(p_api_version NUMBER
486: , p_init_msg_list VARCHAR2
487: , p_commit VARCHAR2
488: , p3_a0 JTF_NUMBER_TABLE
489: , p3_a1 JTF_NUMBER_TABLE
490: , p3_a2 JTF_NUMBER_TABLE
491: , p3_a3 JTF_VARCHAR2_TABLE_100
492: , p3_a4 JTF_NUMBER_TABLE
493: , p3_a5 JTF_VARCHAR2_TABLE_100
486: , p_init_msg_list VARCHAR2
487: , p_commit VARCHAR2
488: , p3_a0 JTF_NUMBER_TABLE
489: , p3_a1 JTF_NUMBER_TABLE
490: , p3_a2 JTF_NUMBER_TABLE
491: , p3_a3 JTF_VARCHAR2_TABLE_100
492: , p3_a4 JTF_NUMBER_TABLE
493: , p3_a5 JTF_VARCHAR2_TABLE_100
494: , p3_a6 JTF_NUMBER_TABLE
488: , p3_a0 JTF_NUMBER_TABLE
489: , p3_a1 JTF_NUMBER_TABLE
490: , p3_a2 JTF_NUMBER_TABLE
491: , p3_a3 JTF_VARCHAR2_TABLE_100
492: , p3_a4 JTF_NUMBER_TABLE
493: , p3_a5 JTF_VARCHAR2_TABLE_100
494: , p3_a6 JTF_NUMBER_TABLE
495: , p3_a7 JTF_NUMBER_TABLE
496: , p3_a8 JTF_NUMBER_TABLE
490: , p3_a2 JTF_NUMBER_TABLE
491: , p3_a3 JTF_VARCHAR2_TABLE_100
492: , p3_a4 JTF_NUMBER_TABLE
493: , p3_a5 JTF_VARCHAR2_TABLE_100
494: , p3_a6 JTF_NUMBER_TABLE
495: , p3_a7 JTF_NUMBER_TABLE
496: , p3_a8 JTF_NUMBER_TABLE
497: , p3_a9 JTF_NUMBER_TABLE
498: , p3_a10 JTF_VARCHAR2_TABLE_100
491: , p3_a3 JTF_VARCHAR2_TABLE_100
492: , p3_a4 JTF_NUMBER_TABLE
493: , p3_a5 JTF_VARCHAR2_TABLE_100
494: , p3_a6 JTF_NUMBER_TABLE
495: , p3_a7 JTF_NUMBER_TABLE
496: , p3_a8 JTF_NUMBER_TABLE
497: , p3_a9 JTF_NUMBER_TABLE
498: , p3_a10 JTF_VARCHAR2_TABLE_100
499: , p3_a11 JTF_NUMBER_TABLE
492: , p3_a4 JTF_NUMBER_TABLE
493: , p3_a5 JTF_VARCHAR2_TABLE_100
494: , p3_a6 JTF_NUMBER_TABLE
495: , p3_a7 JTF_NUMBER_TABLE
496: , p3_a8 JTF_NUMBER_TABLE
497: , p3_a9 JTF_NUMBER_TABLE
498: , p3_a10 JTF_VARCHAR2_TABLE_100
499: , p3_a11 JTF_NUMBER_TABLE
500: , p3_a12 JTF_DATE_TABLE
493: , p3_a5 JTF_VARCHAR2_TABLE_100
494: , p3_a6 JTF_NUMBER_TABLE
495: , p3_a7 JTF_NUMBER_TABLE
496: , p3_a8 JTF_NUMBER_TABLE
497: , p3_a9 JTF_NUMBER_TABLE
498: , p3_a10 JTF_VARCHAR2_TABLE_100
499: , p3_a11 JTF_NUMBER_TABLE
500: , p3_a12 JTF_DATE_TABLE
501: , p3_a13 JTF_NUMBER_TABLE
495: , p3_a7 JTF_NUMBER_TABLE
496: , p3_a8 JTF_NUMBER_TABLE
497: , p3_a9 JTF_NUMBER_TABLE
498: , p3_a10 JTF_VARCHAR2_TABLE_100
499: , p3_a11 JTF_NUMBER_TABLE
500: , p3_a12 JTF_DATE_TABLE
501: , p3_a13 JTF_NUMBER_TABLE
502: , p3_a14 JTF_DATE_TABLE
503: , p3_a15 JTF_NUMBER_TABLE
497: , p3_a9 JTF_NUMBER_TABLE
498: , p3_a10 JTF_VARCHAR2_TABLE_100
499: , p3_a11 JTF_NUMBER_TABLE
500: , p3_a12 JTF_DATE_TABLE
501: , p3_a13 JTF_NUMBER_TABLE
502: , p3_a14 JTF_DATE_TABLE
503: , p3_a15 JTF_NUMBER_TABLE
504: , p3_a16 JTF_NUMBER_TABLE
505: , x_return_status out nocopy VARCHAR2
499: , p3_a11 JTF_NUMBER_TABLE
500: , p3_a12 JTF_DATE_TABLE
501: , p3_a13 JTF_NUMBER_TABLE
502: , p3_a14 JTF_DATE_TABLE
503: , p3_a15 JTF_NUMBER_TABLE
504: , p3_a16 JTF_NUMBER_TABLE
505: , x_return_status out nocopy VARCHAR2
506: , x_msg_count out nocopy NUMBER
507: , x_msg_data out nocopy VARCHAR2
500: , p3_a12 JTF_DATE_TABLE
501: , p3_a13 JTF_NUMBER_TABLE
502: , p3_a14 JTF_DATE_TABLE
503: , p3_a15 JTF_NUMBER_TABLE
504: , p3_a16 JTF_NUMBER_TABLE
505: , x_return_status out nocopy VARCHAR2
506: , x_msg_count out nocopy NUMBER
507: , x_msg_data out nocopy VARCHAR2
508: , x_ag_dn_xref_id_tbl out nocopy JTF_NUMBER_TABLE
504: , p3_a16 JTF_NUMBER_TABLE
505: , x_return_status out nocopy VARCHAR2
506: , x_msg_count out nocopy NUMBER
507: , x_msg_data out nocopy VARCHAR2
508: , x_ag_dn_xref_id_tbl out nocopy JTF_NUMBER_TABLE
509: )
510:
511: as
512: ddp_ag_dn_xref_tbl iex_dunning_pub.ag_dn_xref_tbl_type;
564:
565: procedure update_ag_dn_xref(p_api_version NUMBER
566: , p_init_msg_list VARCHAR2
567: , p_commit VARCHAR2
568: , p3_a0 JTF_NUMBER_TABLE
569: , p3_a1 JTF_NUMBER_TABLE
570: , p3_a2 JTF_NUMBER_TABLE
571: , p3_a3 JTF_VARCHAR2_TABLE_100
572: , p3_a4 JTF_NUMBER_TABLE
565: procedure update_ag_dn_xref(p_api_version NUMBER
566: , p_init_msg_list VARCHAR2
567: , p_commit VARCHAR2
568: , p3_a0 JTF_NUMBER_TABLE
569: , p3_a1 JTF_NUMBER_TABLE
570: , p3_a2 JTF_NUMBER_TABLE
571: , p3_a3 JTF_VARCHAR2_TABLE_100
572: , p3_a4 JTF_NUMBER_TABLE
573: , p3_a5 JTF_VARCHAR2_TABLE_100
566: , p_init_msg_list VARCHAR2
567: , p_commit VARCHAR2
568: , p3_a0 JTF_NUMBER_TABLE
569: , p3_a1 JTF_NUMBER_TABLE
570: , p3_a2 JTF_NUMBER_TABLE
571: , p3_a3 JTF_VARCHAR2_TABLE_100
572: , p3_a4 JTF_NUMBER_TABLE
573: , p3_a5 JTF_VARCHAR2_TABLE_100
574: , p3_a6 JTF_NUMBER_TABLE
568: , p3_a0 JTF_NUMBER_TABLE
569: , p3_a1 JTF_NUMBER_TABLE
570: , p3_a2 JTF_NUMBER_TABLE
571: , p3_a3 JTF_VARCHAR2_TABLE_100
572: , p3_a4 JTF_NUMBER_TABLE
573: , p3_a5 JTF_VARCHAR2_TABLE_100
574: , p3_a6 JTF_NUMBER_TABLE
575: , p3_a7 JTF_NUMBER_TABLE
576: , p3_a8 JTF_NUMBER_TABLE
570: , p3_a2 JTF_NUMBER_TABLE
571: , p3_a3 JTF_VARCHAR2_TABLE_100
572: , p3_a4 JTF_NUMBER_TABLE
573: , p3_a5 JTF_VARCHAR2_TABLE_100
574: , p3_a6 JTF_NUMBER_TABLE
575: , p3_a7 JTF_NUMBER_TABLE
576: , p3_a8 JTF_NUMBER_TABLE
577: , p3_a9 JTF_NUMBER_TABLE
578: , p3_a10 JTF_VARCHAR2_TABLE_100
571: , p3_a3 JTF_VARCHAR2_TABLE_100
572: , p3_a4 JTF_NUMBER_TABLE
573: , p3_a5 JTF_VARCHAR2_TABLE_100
574: , p3_a6 JTF_NUMBER_TABLE
575: , p3_a7 JTF_NUMBER_TABLE
576: , p3_a8 JTF_NUMBER_TABLE
577: , p3_a9 JTF_NUMBER_TABLE
578: , p3_a10 JTF_VARCHAR2_TABLE_100
579: , p3_a11 JTF_NUMBER_TABLE
572: , p3_a4 JTF_NUMBER_TABLE
573: , p3_a5 JTF_VARCHAR2_TABLE_100
574: , p3_a6 JTF_NUMBER_TABLE
575: , p3_a7 JTF_NUMBER_TABLE
576: , p3_a8 JTF_NUMBER_TABLE
577: , p3_a9 JTF_NUMBER_TABLE
578: , p3_a10 JTF_VARCHAR2_TABLE_100
579: , p3_a11 JTF_NUMBER_TABLE
580: , p3_a12 JTF_DATE_TABLE
573: , p3_a5 JTF_VARCHAR2_TABLE_100
574: , p3_a6 JTF_NUMBER_TABLE
575: , p3_a7 JTF_NUMBER_TABLE
576: , p3_a8 JTF_NUMBER_TABLE
577: , p3_a9 JTF_NUMBER_TABLE
578: , p3_a10 JTF_VARCHAR2_TABLE_100
579: , p3_a11 JTF_NUMBER_TABLE
580: , p3_a12 JTF_DATE_TABLE
581: , p3_a13 JTF_NUMBER_TABLE
575: , p3_a7 JTF_NUMBER_TABLE
576: , p3_a8 JTF_NUMBER_TABLE
577: , p3_a9 JTF_NUMBER_TABLE
578: , p3_a10 JTF_VARCHAR2_TABLE_100
579: , p3_a11 JTF_NUMBER_TABLE
580: , p3_a12 JTF_DATE_TABLE
581: , p3_a13 JTF_NUMBER_TABLE
582: , p3_a14 JTF_DATE_TABLE
583: , p3_a15 JTF_NUMBER_TABLE
577: , p3_a9 JTF_NUMBER_TABLE
578: , p3_a10 JTF_VARCHAR2_TABLE_100
579: , p3_a11 JTF_NUMBER_TABLE
580: , p3_a12 JTF_DATE_TABLE
581: , p3_a13 JTF_NUMBER_TABLE
582: , p3_a14 JTF_DATE_TABLE
583: , p3_a15 JTF_NUMBER_TABLE
584: , p3_a16 JTF_NUMBER_TABLE
585: , x_return_status out nocopy VARCHAR2
579: , p3_a11 JTF_NUMBER_TABLE
580: , p3_a12 JTF_DATE_TABLE
581: , p3_a13 JTF_NUMBER_TABLE
582: , p3_a14 JTF_DATE_TABLE
583: , p3_a15 JTF_NUMBER_TABLE
584: , p3_a16 JTF_NUMBER_TABLE
585: , x_return_status out nocopy VARCHAR2
586: , x_msg_count out nocopy NUMBER
587: , x_msg_data out nocopy VARCHAR2
580: , p3_a12 JTF_DATE_TABLE
581: , p3_a13 JTF_NUMBER_TABLE
582: , p3_a14 JTF_DATE_TABLE
583: , p3_a15 JTF_NUMBER_TABLE
584: , p3_a16 JTF_NUMBER_TABLE
585: , x_return_status out nocopy VARCHAR2
586: , x_msg_count out nocopy NUMBER
587: , x_msg_data out nocopy VARCHAR2
588: )