59: end if;
60: end if;
61: end rosetta_table_copy_out_p1;
62:
63: procedure rosetta_table_copy_in_p4(t OUT NOCOPY ams_act_list_pvt.act_list_tbl_type, a0 JTF_NUMBER_TABLE
64: , a1 JTF_DATE_TABLE
65: , a2 JTF_NUMBER_TABLE
66: , a3 JTF_DATE_TABLE
67: , a4 JTF_NUMBER_TABLE
61: end rosetta_table_copy_out_p1;
62:
63: procedure rosetta_table_copy_in_p4(t OUT NOCOPY ams_act_list_pvt.act_list_tbl_type, a0 JTF_NUMBER_TABLE
64: , a1 JTF_DATE_TABLE
65: , a2 JTF_NUMBER_TABLE
66: , a3 JTF_DATE_TABLE
67: , a4 JTF_NUMBER_TABLE
68: , a5 JTF_NUMBER_TABLE
69: , a6 JTF_NUMBER_TABLE
63: procedure rosetta_table_copy_in_p4(t OUT NOCOPY ams_act_list_pvt.act_list_tbl_type, a0 JTF_NUMBER_TABLE
64: , a1 JTF_DATE_TABLE
65: , a2 JTF_NUMBER_TABLE
66: , a3 JTF_DATE_TABLE
67: , a4 JTF_NUMBER_TABLE
68: , a5 JTF_NUMBER_TABLE
69: , a6 JTF_NUMBER_TABLE
70: , a7 JTF_NUMBER_TABLE
71: , a8 JTF_VARCHAR2_TABLE_100
64: , a1 JTF_DATE_TABLE
65: , a2 JTF_NUMBER_TABLE
66: , a3 JTF_DATE_TABLE
67: , a4 JTF_NUMBER_TABLE
68: , a5 JTF_NUMBER_TABLE
69: , a6 JTF_NUMBER_TABLE
70: , a7 JTF_NUMBER_TABLE
71: , a8 JTF_VARCHAR2_TABLE_100
72: , a9 JTF_NUMBER_TABLE
65: , a2 JTF_NUMBER_TABLE
66: , a3 JTF_DATE_TABLE
67: , a4 JTF_NUMBER_TABLE
68: , a5 JTF_NUMBER_TABLE
69: , a6 JTF_NUMBER_TABLE
70: , a7 JTF_NUMBER_TABLE
71: , a8 JTF_VARCHAR2_TABLE_100
72: , a9 JTF_NUMBER_TABLE
73: , a10 JTF_VARCHAR2_TABLE_100
66: , a3 JTF_DATE_TABLE
67: , a4 JTF_NUMBER_TABLE
68: , a5 JTF_NUMBER_TABLE
69: , a6 JTF_NUMBER_TABLE
70: , a7 JTF_NUMBER_TABLE
71: , a8 JTF_VARCHAR2_TABLE_100
72: , a9 JTF_NUMBER_TABLE
73: , a10 JTF_VARCHAR2_TABLE_100
74: , a11 JTF_VARCHAR2_TABLE_100
68: , a5 JTF_NUMBER_TABLE
69: , a6 JTF_NUMBER_TABLE
70: , a7 JTF_NUMBER_TABLE
71: , a8 JTF_VARCHAR2_TABLE_100
72: , a9 JTF_NUMBER_TABLE
73: , a10 JTF_VARCHAR2_TABLE_100
74: , a11 JTF_VARCHAR2_TABLE_100
75: , a12 JTF_VARCHAR2_TABLE_100
76: , a13 JTF_NUMBER_TABLE
72: , a9 JTF_NUMBER_TABLE
73: , a10 JTF_VARCHAR2_TABLE_100
74: , a11 JTF_VARCHAR2_TABLE_100
75: , a12 JTF_VARCHAR2_TABLE_100
76: , a13 JTF_NUMBER_TABLE
77: ) as
78: ddindx binary_integer; indx binary_integer;
79: begin
80: if a0 is not null and a0.count > 0 then
104: end loop;
105: end if;
106: end if;
107: end rosetta_table_copy_in_p4;
108: procedure rosetta_table_copy_out_p4(t ams_act_list_pvt.act_list_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
109: , a1 OUT NOCOPY JTF_DATE_TABLE
110: , a2 OUT NOCOPY JTF_NUMBER_TABLE
111: , a3 OUT NOCOPY JTF_DATE_TABLE
112: , a4 OUT NOCOPY JTF_NUMBER_TABLE
106: end if;
107: end rosetta_table_copy_in_p4;
108: procedure rosetta_table_copy_out_p4(t ams_act_list_pvt.act_list_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
109: , a1 OUT NOCOPY JTF_DATE_TABLE
110: , a2 OUT NOCOPY JTF_NUMBER_TABLE
111: , a3 OUT NOCOPY JTF_DATE_TABLE
112: , a4 OUT NOCOPY JTF_NUMBER_TABLE
113: , a5 OUT NOCOPY JTF_NUMBER_TABLE
114: , a6 OUT NOCOPY JTF_NUMBER_TABLE
108: procedure rosetta_table_copy_out_p4(t ams_act_list_pvt.act_list_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
109: , a1 OUT NOCOPY JTF_DATE_TABLE
110: , a2 OUT NOCOPY JTF_NUMBER_TABLE
111: , a3 OUT NOCOPY JTF_DATE_TABLE
112: , a4 OUT NOCOPY JTF_NUMBER_TABLE
113: , a5 OUT NOCOPY JTF_NUMBER_TABLE
114: , a6 OUT NOCOPY JTF_NUMBER_TABLE
115: , a7 OUT NOCOPY JTF_NUMBER_TABLE
116: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
109: , a1 OUT NOCOPY JTF_DATE_TABLE
110: , a2 OUT NOCOPY JTF_NUMBER_TABLE
111: , a3 OUT NOCOPY JTF_DATE_TABLE
112: , a4 OUT NOCOPY JTF_NUMBER_TABLE
113: , a5 OUT NOCOPY JTF_NUMBER_TABLE
114: , a6 OUT NOCOPY JTF_NUMBER_TABLE
115: , a7 OUT NOCOPY JTF_NUMBER_TABLE
116: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
117: , a9 OUT NOCOPY JTF_NUMBER_TABLE
110: , a2 OUT NOCOPY JTF_NUMBER_TABLE
111: , a3 OUT NOCOPY JTF_DATE_TABLE
112: , a4 OUT NOCOPY JTF_NUMBER_TABLE
113: , a5 OUT NOCOPY JTF_NUMBER_TABLE
114: , a6 OUT NOCOPY JTF_NUMBER_TABLE
115: , a7 OUT NOCOPY JTF_NUMBER_TABLE
116: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
117: , a9 OUT NOCOPY JTF_NUMBER_TABLE
118: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
111: , a3 OUT NOCOPY JTF_DATE_TABLE
112: , a4 OUT NOCOPY JTF_NUMBER_TABLE
113: , a5 OUT NOCOPY JTF_NUMBER_TABLE
114: , a6 OUT NOCOPY JTF_NUMBER_TABLE
115: , a7 OUT NOCOPY JTF_NUMBER_TABLE
116: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
117: , a9 OUT NOCOPY JTF_NUMBER_TABLE
118: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
119: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
113: , a5 OUT NOCOPY JTF_NUMBER_TABLE
114: , a6 OUT NOCOPY JTF_NUMBER_TABLE
115: , a7 OUT NOCOPY JTF_NUMBER_TABLE
116: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
117: , a9 OUT NOCOPY JTF_NUMBER_TABLE
118: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
119: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
120: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
121: , a13 OUT NOCOPY JTF_NUMBER_TABLE
117: , a9 OUT NOCOPY JTF_NUMBER_TABLE
118: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
119: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
120: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
121: , a13 OUT NOCOPY JTF_NUMBER_TABLE
122: ) as
123: ddindx binary_integer; indx binary_integer;
124: begin
125: if t is null or t.count = 0 then
122: ) as
123: ddindx binary_integer; indx binary_integer;
124: begin
125: if t is null or t.count = 0 then
126: a0 := JTF_NUMBER_TABLE();
127: a1 := JTF_DATE_TABLE();
128: a2 := JTF_NUMBER_TABLE();
129: a3 := JTF_DATE_TABLE();
130: a4 := JTF_NUMBER_TABLE();
124: begin
125: if t is null or t.count = 0 then
126: a0 := JTF_NUMBER_TABLE();
127: a1 := JTF_DATE_TABLE();
128: a2 := JTF_NUMBER_TABLE();
129: a3 := JTF_DATE_TABLE();
130: a4 := JTF_NUMBER_TABLE();
131: a5 := JTF_NUMBER_TABLE();
132: a6 := JTF_NUMBER_TABLE();
126: a0 := JTF_NUMBER_TABLE();
127: a1 := JTF_DATE_TABLE();
128: a2 := JTF_NUMBER_TABLE();
129: a3 := JTF_DATE_TABLE();
130: a4 := JTF_NUMBER_TABLE();
131: a5 := JTF_NUMBER_TABLE();
132: a6 := JTF_NUMBER_TABLE();
133: a7 := JTF_NUMBER_TABLE();
134: a8 := JTF_VARCHAR2_TABLE_100();
127: a1 := JTF_DATE_TABLE();
128: a2 := JTF_NUMBER_TABLE();
129: a3 := JTF_DATE_TABLE();
130: a4 := JTF_NUMBER_TABLE();
131: a5 := JTF_NUMBER_TABLE();
132: a6 := JTF_NUMBER_TABLE();
133: a7 := JTF_NUMBER_TABLE();
134: a8 := JTF_VARCHAR2_TABLE_100();
135: a9 := JTF_NUMBER_TABLE();
128: a2 := JTF_NUMBER_TABLE();
129: a3 := JTF_DATE_TABLE();
130: a4 := JTF_NUMBER_TABLE();
131: a5 := JTF_NUMBER_TABLE();
132: a6 := JTF_NUMBER_TABLE();
133: a7 := JTF_NUMBER_TABLE();
134: a8 := JTF_VARCHAR2_TABLE_100();
135: a9 := JTF_NUMBER_TABLE();
136: a10 := JTF_VARCHAR2_TABLE_100();
129: a3 := JTF_DATE_TABLE();
130: a4 := JTF_NUMBER_TABLE();
131: a5 := JTF_NUMBER_TABLE();
132: a6 := JTF_NUMBER_TABLE();
133: a7 := JTF_NUMBER_TABLE();
134: a8 := JTF_VARCHAR2_TABLE_100();
135: a9 := JTF_NUMBER_TABLE();
136: a10 := JTF_VARCHAR2_TABLE_100();
137: a11 := JTF_VARCHAR2_TABLE_100();
131: a5 := JTF_NUMBER_TABLE();
132: a6 := JTF_NUMBER_TABLE();
133: a7 := JTF_NUMBER_TABLE();
134: a8 := JTF_VARCHAR2_TABLE_100();
135: a9 := JTF_NUMBER_TABLE();
136: a10 := JTF_VARCHAR2_TABLE_100();
137: a11 := JTF_VARCHAR2_TABLE_100();
138: a12 := JTF_VARCHAR2_TABLE_100();
139: a13 := JTF_NUMBER_TABLE();
135: a9 := JTF_NUMBER_TABLE();
136: a10 := JTF_VARCHAR2_TABLE_100();
137: a11 := JTF_VARCHAR2_TABLE_100();
138: a12 := JTF_VARCHAR2_TABLE_100();
139: a13 := JTF_NUMBER_TABLE();
140: else
141: a0 := JTF_NUMBER_TABLE();
142: a1 := JTF_DATE_TABLE();
143: a2 := JTF_NUMBER_TABLE();
137: a11 := JTF_VARCHAR2_TABLE_100();
138: a12 := JTF_VARCHAR2_TABLE_100();
139: a13 := JTF_NUMBER_TABLE();
140: else
141: a0 := JTF_NUMBER_TABLE();
142: a1 := JTF_DATE_TABLE();
143: a2 := JTF_NUMBER_TABLE();
144: a3 := JTF_DATE_TABLE();
145: a4 := JTF_NUMBER_TABLE();
139: a13 := JTF_NUMBER_TABLE();
140: else
141: a0 := JTF_NUMBER_TABLE();
142: a1 := JTF_DATE_TABLE();
143: a2 := JTF_NUMBER_TABLE();
144: a3 := JTF_DATE_TABLE();
145: a4 := JTF_NUMBER_TABLE();
146: a5 := JTF_NUMBER_TABLE();
147: a6 := JTF_NUMBER_TABLE();
141: a0 := JTF_NUMBER_TABLE();
142: a1 := JTF_DATE_TABLE();
143: a2 := JTF_NUMBER_TABLE();
144: a3 := JTF_DATE_TABLE();
145: a4 := JTF_NUMBER_TABLE();
146: a5 := JTF_NUMBER_TABLE();
147: a6 := JTF_NUMBER_TABLE();
148: a7 := JTF_NUMBER_TABLE();
149: a8 := JTF_VARCHAR2_TABLE_100();
142: a1 := JTF_DATE_TABLE();
143: a2 := JTF_NUMBER_TABLE();
144: a3 := JTF_DATE_TABLE();
145: a4 := JTF_NUMBER_TABLE();
146: a5 := JTF_NUMBER_TABLE();
147: a6 := JTF_NUMBER_TABLE();
148: a7 := JTF_NUMBER_TABLE();
149: a8 := JTF_VARCHAR2_TABLE_100();
150: a9 := JTF_NUMBER_TABLE();
143: a2 := JTF_NUMBER_TABLE();
144: a3 := JTF_DATE_TABLE();
145: a4 := JTF_NUMBER_TABLE();
146: a5 := JTF_NUMBER_TABLE();
147: a6 := JTF_NUMBER_TABLE();
148: a7 := JTF_NUMBER_TABLE();
149: a8 := JTF_VARCHAR2_TABLE_100();
150: a9 := JTF_NUMBER_TABLE();
151: a10 := JTF_VARCHAR2_TABLE_100();
144: a3 := JTF_DATE_TABLE();
145: a4 := JTF_NUMBER_TABLE();
146: a5 := JTF_NUMBER_TABLE();
147: a6 := JTF_NUMBER_TABLE();
148: a7 := JTF_NUMBER_TABLE();
149: a8 := JTF_VARCHAR2_TABLE_100();
150: a9 := JTF_NUMBER_TABLE();
151: a10 := JTF_VARCHAR2_TABLE_100();
152: a11 := JTF_VARCHAR2_TABLE_100();
146: a5 := JTF_NUMBER_TABLE();
147: a6 := JTF_NUMBER_TABLE();
148: a7 := JTF_NUMBER_TABLE();
149: a8 := JTF_VARCHAR2_TABLE_100();
150: a9 := JTF_NUMBER_TABLE();
151: a10 := JTF_VARCHAR2_TABLE_100();
152: a11 := JTF_VARCHAR2_TABLE_100();
153: a12 := JTF_VARCHAR2_TABLE_100();
154: a13 := JTF_NUMBER_TABLE();
150: a9 := JTF_NUMBER_TABLE();
151: a10 := JTF_VARCHAR2_TABLE_100();
152: a11 := JTF_VARCHAR2_TABLE_100();
153: a12 := JTF_VARCHAR2_TABLE_100();
154: a13 := JTF_NUMBER_TABLE();
155: if t.count > 0 then
156: a0.extend(t.count);
157: a1.extend(t.count);
158: a2.extend(t.count);