13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p2(t out nocopy ozf_mass_settlement_pvt.open_claim_tbl, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_VARCHAR2_TABLE_2000
21: ) as
14: end;
15:
16: procedure rosetta_table_copy_in_p2(t out nocopy ozf_mass_settlement_pvt.open_claim_tbl, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_VARCHAR2_TABLE_2000
21: ) as
22: ddindx binary_integer; indx binary_integer;
40: end if;
41: end if;
42: end rosetta_table_copy_in_p2;
43: procedure rosetta_table_copy_out_p2(t ozf_mass_settlement_pvt.open_claim_tbl, a0 out nocopy JTF_NUMBER_TABLE
44: , a1 out nocopy JTF_VARCHAR2_TABLE_100
45: , a2 out nocopy JTF_VARCHAR2_TABLE_100
46: , a3 out nocopy JTF_NUMBER_TABLE
47: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
48: ) as
41: end if;
42: end rosetta_table_copy_in_p2;
43: procedure rosetta_table_copy_out_p2(t ozf_mass_settlement_pvt.open_claim_tbl, a0 out nocopy JTF_NUMBER_TABLE
44: , a1 out nocopy JTF_VARCHAR2_TABLE_100
45: , a2 out nocopy JTF_VARCHAR2_TABLE_100
46: , a3 out nocopy JTF_NUMBER_TABLE
47: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
48: ) as
49: ddindx binary_integer; indx binary_integer;
49: ddindx binary_integer; indx binary_integer;
50: begin
51: if t is null or t.count = 0 then
52: a0 := JTF_NUMBER_TABLE();
53: a1 := JTF_VARCHAR2_TABLE_100();
54: a2 := JTF_VARCHAR2_TABLE_100();
55: a3 := JTF_NUMBER_TABLE();
56: a4 := JTF_VARCHAR2_TABLE_2000();
57: else
50: begin
51: if t is null or t.count = 0 then
52: a0 := JTF_NUMBER_TABLE();
53: a1 := JTF_VARCHAR2_TABLE_100();
54: a2 := JTF_VARCHAR2_TABLE_100();
55: a3 := JTF_NUMBER_TABLE();
56: a4 := JTF_VARCHAR2_TABLE_2000();
57: else
58: a0 := JTF_NUMBER_TABLE();
55: a3 := JTF_NUMBER_TABLE();
56: a4 := JTF_VARCHAR2_TABLE_2000();
57: else
58: a0 := JTF_NUMBER_TABLE();
59: a1 := JTF_VARCHAR2_TABLE_100();
60: a2 := JTF_VARCHAR2_TABLE_100();
61: a3 := JTF_NUMBER_TABLE();
62: a4 := JTF_VARCHAR2_TABLE_2000();
63: if t.count > 0 then
56: a4 := JTF_VARCHAR2_TABLE_2000();
57: else
58: a0 := JTF_NUMBER_TABLE();
59: a1 := JTF_VARCHAR2_TABLE_100();
60: a2 := JTF_VARCHAR2_TABLE_100();
61: a3 := JTF_NUMBER_TABLE();
62: a4 := JTF_VARCHAR2_TABLE_2000();
63: if t.count > 0 then
64: a0.extend(t.count);
85: end rosetta_table_copy_out_p2;
86:
87: procedure rosetta_table_copy_in_p4(t out nocopy ozf_mass_settlement_pvt.open_transaction_tbl, a0 JTF_NUMBER_TABLE
88: , a1 JTF_NUMBER_TABLE
89: , a2 JTF_VARCHAR2_TABLE_100
90: , a3 JTF_VARCHAR2_TABLE_100
91: , a4 JTF_NUMBER_TABLE
92: ) as
93: ddindx binary_integer; indx binary_integer;
86:
87: procedure rosetta_table_copy_in_p4(t out nocopy ozf_mass_settlement_pvt.open_transaction_tbl, a0 JTF_NUMBER_TABLE
88: , a1 JTF_NUMBER_TABLE
89: , a2 JTF_VARCHAR2_TABLE_100
90: , a3 JTF_VARCHAR2_TABLE_100
91: , a4 JTF_NUMBER_TABLE
92: ) as
93: ddindx binary_integer; indx binary_integer;
94: begin
112: end if;
113: end rosetta_table_copy_in_p4;
114: procedure rosetta_table_copy_out_p4(t ozf_mass_settlement_pvt.open_transaction_tbl, a0 out nocopy JTF_NUMBER_TABLE
115: , a1 out nocopy JTF_NUMBER_TABLE
116: , a2 out nocopy JTF_VARCHAR2_TABLE_100
117: , a3 out nocopy JTF_VARCHAR2_TABLE_100
118: , a4 out nocopy JTF_NUMBER_TABLE
119: ) as
120: ddindx binary_integer; indx binary_integer;
113: end rosetta_table_copy_in_p4;
114: procedure rosetta_table_copy_out_p4(t ozf_mass_settlement_pvt.open_transaction_tbl, a0 out nocopy JTF_NUMBER_TABLE
115: , a1 out nocopy JTF_NUMBER_TABLE
116: , a2 out nocopy JTF_VARCHAR2_TABLE_100
117: , a3 out nocopy JTF_VARCHAR2_TABLE_100
118: , a4 out nocopy JTF_NUMBER_TABLE
119: ) as
120: ddindx binary_integer; indx binary_integer;
121: begin
121: begin
122: if t is null or t.count = 0 then
123: a0 := JTF_NUMBER_TABLE();
124: a1 := JTF_NUMBER_TABLE();
125: a2 := JTF_VARCHAR2_TABLE_100();
126: a3 := JTF_VARCHAR2_TABLE_100();
127: a4 := JTF_NUMBER_TABLE();
128: else
129: a0 := JTF_NUMBER_TABLE();
122: if t is null or t.count = 0 then
123: a0 := JTF_NUMBER_TABLE();
124: a1 := JTF_NUMBER_TABLE();
125: a2 := JTF_VARCHAR2_TABLE_100();
126: a3 := JTF_VARCHAR2_TABLE_100();
127: a4 := JTF_NUMBER_TABLE();
128: else
129: a0 := JTF_NUMBER_TABLE();
130: a1 := JTF_NUMBER_TABLE();
127: a4 := JTF_NUMBER_TABLE();
128: else
129: a0 := JTF_NUMBER_TABLE();
130: a1 := JTF_NUMBER_TABLE();
131: a2 := JTF_VARCHAR2_TABLE_100();
132: a3 := JTF_VARCHAR2_TABLE_100();
133: a4 := JTF_NUMBER_TABLE();
134: if t.count > 0 then
135: a0.extend(t.count);
128: else
129: a0 := JTF_NUMBER_TABLE();
130: a1 := JTF_NUMBER_TABLE();
131: a2 := JTF_VARCHAR2_TABLE_100();
132: a3 := JTF_VARCHAR2_TABLE_100();
133: a4 := JTF_NUMBER_TABLE();
134: if t.count > 0 then
135: a0.extend(t.count);
136: a1.extend(t.count);
154: end if;
155: end if;
156: end rosetta_table_copy_out_p4;
157:
158: procedure rosetta_table_copy_in_p6(t out nocopy ozf_mass_settlement_pvt.claim_payment_method_tbl, a0 JTF_VARCHAR2_TABLE_100
159: , a1 JTF_DATE_TABLE
160: , a2 JTF_NUMBER_TABLE
161: , a3 JTF_NUMBER_TABLE
162: , a4 JTF_NUMBER_TABLE
183: end loop;
184: end if;
185: end if;
186: end rosetta_table_copy_in_p6;
187: procedure rosetta_table_copy_out_p6(t ozf_mass_settlement_pvt.claim_payment_method_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
188: , a1 out nocopy JTF_DATE_TABLE
189: , a2 out nocopy JTF_NUMBER_TABLE
190: , a3 out nocopy JTF_NUMBER_TABLE
191: , a4 out nocopy JTF_NUMBER_TABLE
193: ) as
194: ddindx binary_integer; indx binary_integer;
195: begin
196: if t is null or t.count = 0 then
197: a0 := JTF_VARCHAR2_TABLE_100();
198: a1 := JTF_DATE_TABLE();
199: a2 := JTF_NUMBER_TABLE();
200: a3 := JTF_NUMBER_TABLE();
201: a4 := JTF_NUMBER_TABLE();
200: a3 := JTF_NUMBER_TABLE();
201: a4 := JTF_NUMBER_TABLE();
202: a5 := JTF_VARCHAR2_TABLE_2000();
203: else
204: a0 := JTF_VARCHAR2_TABLE_100();
205: a1 := JTF_DATE_TABLE();
206: a2 := JTF_NUMBER_TABLE();
207: a3 := JTF_NUMBER_TABLE();
208: a4 := JTF_NUMBER_TABLE();
251: , p7_a8 NUMBER
252: , p7_a9 NUMBER
253: , p7_a10 VARCHAR2
254: , p8_a0 JTF_NUMBER_TABLE
255: , p8_a1 JTF_VARCHAR2_TABLE_100
256: , p8_a2 JTF_VARCHAR2_TABLE_100
257: , p8_a3 JTF_NUMBER_TABLE
258: , p8_a4 JTF_VARCHAR2_TABLE_2000
259: , p9_a0 JTF_NUMBER_TABLE
252: , p7_a9 NUMBER
253: , p7_a10 VARCHAR2
254: , p8_a0 JTF_NUMBER_TABLE
255: , p8_a1 JTF_VARCHAR2_TABLE_100
256: , p8_a2 JTF_VARCHAR2_TABLE_100
257: , p8_a3 JTF_NUMBER_TABLE
258: , p8_a4 JTF_VARCHAR2_TABLE_2000
259: , p9_a0 JTF_NUMBER_TABLE
260: , p9_a1 JTF_NUMBER_TABLE
257: , p8_a3 JTF_NUMBER_TABLE
258: , p8_a4 JTF_VARCHAR2_TABLE_2000
259: , p9_a0 JTF_NUMBER_TABLE
260: , p9_a1 JTF_NUMBER_TABLE
261: , p9_a2 JTF_VARCHAR2_TABLE_100
262: , p9_a3 JTF_VARCHAR2_TABLE_100
263: , p9_a4 JTF_NUMBER_TABLE
264: , p10_a0 JTF_VARCHAR2_TABLE_100
265: , p10_a1 JTF_DATE_TABLE
258: , p8_a4 JTF_VARCHAR2_TABLE_2000
259: , p9_a0 JTF_NUMBER_TABLE
260: , p9_a1 JTF_NUMBER_TABLE
261: , p9_a2 JTF_VARCHAR2_TABLE_100
262: , p9_a3 JTF_VARCHAR2_TABLE_100
263: , p9_a4 JTF_NUMBER_TABLE
264: , p10_a0 JTF_VARCHAR2_TABLE_100
265: , p10_a1 JTF_DATE_TABLE
266: , p10_a2 JTF_NUMBER_TABLE
260: , p9_a1 JTF_NUMBER_TABLE
261: , p9_a2 JTF_VARCHAR2_TABLE_100
262: , p9_a3 JTF_VARCHAR2_TABLE_100
263: , p9_a4 JTF_NUMBER_TABLE
264: , p10_a0 JTF_VARCHAR2_TABLE_100
265: , p10_a1 JTF_DATE_TABLE
266: , p10_a2 JTF_NUMBER_TABLE
267: , p10_a3 JTF_NUMBER_TABLE
268: , p10_a4 JTF_NUMBER_TABLE