6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: );
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: );
16: procedure rosetta_table_copy_out_p20(t okl_sec_investor_revenue_pvt.szr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
19: , a3 out nocopy JTF_NUMBER_TABLE
20: , a4 out nocopy JTF_NUMBER_TABLE
21: , a5 out nocopy JTF_NUMBER_TABLE
22: , a6 out nocopy JTF_NUMBER_TABLE
23: , a7 out nocopy JTF_DATE_TABLE
24: , a8 out nocopy JTF_DATE_TABLE
25: , a9 out nocopy JTF_DATE_TABLE
26: , a10 out nocopy JTF_VARCHAR2_TABLE_100
27: , a11 out nocopy JTF_VARCHAR2_TABLE_100
20: , a4 out nocopy JTF_NUMBER_TABLE
21: , a5 out nocopy JTF_NUMBER_TABLE
22: , a6 out nocopy JTF_NUMBER_TABLE
23: , a7 out nocopy JTF_DATE_TABLE
24: , a8 out nocopy JTF_DATE_TABLE
25: , a9 out nocopy JTF_DATE_TABLE
26: , a10 out nocopy JTF_VARCHAR2_TABLE_100
27: , a11 out nocopy JTF_VARCHAR2_TABLE_100
28: );
21: , a5 out nocopy JTF_NUMBER_TABLE
22: , a6 out nocopy JTF_NUMBER_TABLE
23: , a7 out nocopy JTF_DATE_TABLE
24: , a8 out nocopy JTF_DATE_TABLE
25: , a9 out nocopy JTF_DATE_TABLE
26: , a10 out nocopy JTF_VARCHAR2_TABLE_100
27: , a11 out nocopy JTF_VARCHAR2_TABLE_100
28: );
29:
116: , p5_a3 JTF_NUMBER_TABLE
117: , p5_a4 JTF_NUMBER_TABLE
118: , p5_a5 JTF_NUMBER_TABLE
119: , p5_a6 JTF_NUMBER_TABLE
120: , p5_a7 JTF_DATE_TABLE
121: , p5_a8 JTF_DATE_TABLE
122: , p5_a9 JTF_DATE_TABLE
123: , p5_a10 JTF_VARCHAR2_TABLE_100
124: , p5_a11 JTF_VARCHAR2_TABLE_100
117: , p5_a4 JTF_NUMBER_TABLE
118: , p5_a5 JTF_NUMBER_TABLE
119: , p5_a6 JTF_NUMBER_TABLE
120: , p5_a7 JTF_DATE_TABLE
121: , p5_a8 JTF_DATE_TABLE
122: , p5_a9 JTF_DATE_TABLE
123: , p5_a10 JTF_VARCHAR2_TABLE_100
124: , p5_a11 JTF_VARCHAR2_TABLE_100
125: , p6_a0 out nocopy JTF_NUMBER_TABLE
118: , p5_a5 JTF_NUMBER_TABLE
119: , p5_a6 JTF_NUMBER_TABLE
120: , p5_a7 JTF_DATE_TABLE
121: , p5_a8 JTF_DATE_TABLE
122: , p5_a9 JTF_DATE_TABLE
123: , p5_a10 JTF_VARCHAR2_TABLE_100
124: , p5_a11 JTF_VARCHAR2_TABLE_100
125: , p6_a0 out nocopy JTF_NUMBER_TABLE
126: , p6_a1 out nocopy JTF_NUMBER_TABLE
128: , p6_a3 out nocopy JTF_NUMBER_TABLE
129: , p6_a4 out nocopy JTF_NUMBER_TABLE
130: , p6_a5 out nocopy JTF_NUMBER_TABLE
131: , p6_a6 out nocopy JTF_NUMBER_TABLE
132: , p6_a7 out nocopy JTF_DATE_TABLE
133: , p6_a8 out nocopy JTF_DATE_TABLE
134: , p6_a9 out nocopy JTF_DATE_TABLE
135: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
136: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
129: , p6_a4 out nocopy JTF_NUMBER_TABLE
130: , p6_a5 out nocopy JTF_NUMBER_TABLE
131: , p6_a6 out nocopy JTF_NUMBER_TABLE
132: , p6_a7 out nocopy JTF_DATE_TABLE
133: , p6_a8 out nocopy JTF_DATE_TABLE
134: , p6_a9 out nocopy JTF_DATE_TABLE
135: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
136: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
137: );
130: , p6_a5 out nocopy JTF_NUMBER_TABLE
131: , p6_a6 out nocopy JTF_NUMBER_TABLE
132: , p6_a7 out nocopy JTF_DATE_TABLE
133: , p6_a8 out nocopy JTF_DATE_TABLE
134: , p6_a9 out nocopy JTF_DATE_TABLE
135: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
136: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
137: );
138: procedure update_investor_revenue(p_api_version NUMBER
146: , p5_a3 JTF_NUMBER_TABLE
147: , p5_a4 JTF_NUMBER_TABLE
148: , p5_a5 JTF_NUMBER_TABLE
149: , p5_a6 JTF_NUMBER_TABLE
150: , p5_a7 JTF_DATE_TABLE
151: , p5_a8 JTF_DATE_TABLE
152: , p5_a9 JTF_DATE_TABLE
153: , p5_a10 JTF_VARCHAR2_TABLE_100
154: , p5_a11 JTF_VARCHAR2_TABLE_100
147: , p5_a4 JTF_NUMBER_TABLE
148: , p5_a5 JTF_NUMBER_TABLE
149: , p5_a6 JTF_NUMBER_TABLE
150: , p5_a7 JTF_DATE_TABLE
151: , p5_a8 JTF_DATE_TABLE
152: , p5_a9 JTF_DATE_TABLE
153: , p5_a10 JTF_VARCHAR2_TABLE_100
154: , p5_a11 JTF_VARCHAR2_TABLE_100
155: , p6_a0 out nocopy JTF_NUMBER_TABLE
148: , p5_a5 JTF_NUMBER_TABLE
149: , p5_a6 JTF_NUMBER_TABLE
150: , p5_a7 JTF_DATE_TABLE
151: , p5_a8 JTF_DATE_TABLE
152: , p5_a9 JTF_DATE_TABLE
153: , p5_a10 JTF_VARCHAR2_TABLE_100
154: , p5_a11 JTF_VARCHAR2_TABLE_100
155: , p6_a0 out nocopy JTF_NUMBER_TABLE
156: , p6_a1 out nocopy JTF_NUMBER_TABLE
158: , p6_a3 out nocopy JTF_NUMBER_TABLE
159: , p6_a4 out nocopy JTF_NUMBER_TABLE
160: , p6_a5 out nocopy JTF_NUMBER_TABLE
161: , p6_a6 out nocopy JTF_NUMBER_TABLE
162: , p6_a7 out nocopy JTF_DATE_TABLE
163: , p6_a8 out nocopy JTF_DATE_TABLE
164: , p6_a9 out nocopy JTF_DATE_TABLE
165: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
166: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
159: , p6_a4 out nocopy JTF_NUMBER_TABLE
160: , p6_a5 out nocopy JTF_NUMBER_TABLE
161: , p6_a6 out nocopy JTF_NUMBER_TABLE
162: , p6_a7 out nocopy JTF_DATE_TABLE
163: , p6_a8 out nocopy JTF_DATE_TABLE
164: , p6_a9 out nocopy JTF_DATE_TABLE
165: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
166: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
167: );
160: , p6_a5 out nocopy JTF_NUMBER_TABLE
161: , p6_a6 out nocopy JTF_NUMBER_TABLE
162: , p6_a7 out nocopy JTF_DATE_TABLE
163: , p6_a8 out nocopy JTF_DATE_TABLE
164: , p6_a9 out nocopy JTF_DATE_TABLE
165: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
166: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
167: );
168: procedure delete_investor_revenue(p_api_version NUMBER
176: , p5_a3 JTF_NUMBER_TABLE
177: , p5_a4 JTF_NUMBER_TABLE
178: , p5_a5 JTF_NUMBER_TABLE
179: , p5_a6 JTF_NUMBER_TABLE
180: , p5_a7 JTF_DATE_TABLE
181: , p5_a8 JTF_DATE_TABLE
182: , p5_a9 JTF_DATE_TABLE
183: , p5_a10 JTF_VARCHAR2_TABLE_100
184: , p5_a11 JTF_VARCHAR2_TABLE_100
177: , p5_a4 JTF_NUMBER_TABLE
178: , p5_a5 JTF_NUMBER_TABLE
179: , p5_a6 JTF_NUMBER_TABLE
180: , p5_a7 JTF_DATE_TABLE
181: , p5_a8 JTF_DATE_TABLE
182: , p5_a9 JTF_DATE_TABLE
183: , p5_a10 JTF_VARCHAR2_TABLE_100
184: , p5_a11 JTF_VARCHAR2_TABLE_100
185: );
178: , p5_a5 JTF_NUMBER_TABLE
179: , p5_a6 JTF_NUMBER_TABLE
180: , p5_a7 JTF_DATE_TABLE
181: , p5_a8 JTF_DATE_TABLE
182: , p5_a9 JTF_DATE_TABLE
183: , p5_a10 JTF_VARCHAR2_TABLE_100
184: , p5_a11 JTF_VARCHAR2_TABLE_100
185: );
186: end okl_sec_investor_revenue_pvt_w;