[Home] [Help]
PACKAGE BODY: APPS.OKL_SYS_ACCT_OPTS_PUB_W
Source
1 package body okl_sys_acct_opts_pub_w as
2 /* $Header: OKLUSAOB.pls 120.5.12010000.2 2008/09/12 22:50:23 smereddy ship $ */
3 rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4 rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5 rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');
6 rosetta_g_mistake_date_low date := to_date('01/01/-4710', 'MM/DD/SYYYY');
7
8 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
9 function rosetta_g_miss_date_in_map(d date) return date as
10 begin
11 if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
12 if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13 return d;
14 end;
15
16 function rosetta_g_miss_num_map(n number) return number as
17 a number := fnd_api.g_miss_num;
18 b number := 0-1962.0724;
19 begin
20 if n=a then return b; end if;
21 if n=b then return a; end if;
22 return n;
23 end;
24
25 procedure insert_sys_acct_opts(p_api_version NUMBER
26 , p_init_msg_list VARCHAR2
27 , x_return_status out nocopy VARCHAR2
28 , x_msg_count out nocopy NUMBER
29 , x_msg_data out nocopy VARCHAR2
30 , p6_a0 out nocopy NUMBER
31 , p6_a1 out nocopy NUMBER
32 , p6_a2 out nocopy NUMBER
33 , p6_a3 out nocopy NUMBER
34 , p6_a4 out nocopy VARCHAR2
35 , p6_a5 out nocopy VARCHAR2
36 , p6_a6 out nocopy NUMBER
37 , p6_a7 out nocopy NUMBER
38 , p6_a8 out nocopy NUMBER
39 , p6_a9 out nocopy NUMBER
40 , p6_a10 out nocopy NUMBER
41 , p6_a11 out nocopy NUMBER
42 , p6_a12 out nocopy NUMBER
43 , p6_a13 out nocopy NUMBER
44 , p6_a14 out nocopy NUMBER
45 , p6_a15 out nocopy NUMBER
46 , p6_a16 out nocopy NUMBER
47 , p6_a17 out nocopy NUMBER
48 , p6_a18 out nocopy NUMBER
49 , p6_a19 out nocopy VARCHAR2
50 , p6_a20 out nocopy NUMBER
51 , p6_a21 out nocopy NUMBER
52 , p6_a22 out nocopy VARCHAR2
53 , p6_a23 out nocopy NUMBER
54 , p6_a24 out nocopy NUMBER
55 , p6_a25 out nocopy VARCHAR2
56 , p6_a26 out nocopy VARCHAR2
57 , p6_a27 out nocopy VARCHAR2
58 , p6_a28 out nocopy VARCHAR2
59 , p6_a29 out nocopy VARCHAR2
60 , p6_a30 out nocopy VARCHAR2
61 , p6_a31 out nocopy VARCHAR2
62 , p6_a32 out nocopy VARCHAR2
63 , p6_a33 out nocopy VARCHAR2
64 , p6_a34 out nocopy VARCHAR2
65 , p6_a35 out nocopy VARCHAR2
66 , p6_a36 out nocopy VARCHAR2
67 , p6_a37 out nocopy VARCHAR2
68 , p6_a38 out nocopy VARCHAR2
69 , p6_a39 out nocopy VARCHAR2
70 , p6_a40 out nocopy VARCHAR2
71 , p6_a41 out nocopy NUMBER
72 , p6_a42 out nocopy NUMBER
73 , p6_a43 out nocopy DATE
74 , p6_a44 out nocopy NUMBER
75 , p6_a45 out nocopy DATE
76 , p6_a46 out nocopy NUMBER
77 , p6_a47 out nocopy VARCHAR2
78 , p6_a48 out nocopy VARCHAR2
79 , p6_a49 out nocopy NUMBER
80 , p6_a50 out nocopy NUMBER
81 , p6_a51 out nocopy VARCHAR2
82 , p6_a52 out nocopy VARCHAR2
83 , p6_a53 out nocopy VARCHAR2
84 , p6_a54 out nocopy VARCHAR2
85 , p6_a55 out nocopy VARCHAR2
86 , p6_a56 out nocopy NUMBER
87 , p6_a57 out nocopy VARCHAR2
88 , p5_a0 NUMBER := 0-1962.0724
89 , p5_a1 NUMBER := 0-1962.0724
90 , p5_a2 NUMBER := 0-1962.0724
91 , p5_a3 NUMBER := 0-1962.0724
92 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
93 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
94 , p5_a6 NUMBER := 0-1962.0724
95 , p5_a7 NUMBER := 0-1962.0724
96 , p5_a8 NUMBER := 0-1962.0724
97 , p5_a9 NUMBER := 0-1962.0724
98 , p5_a10 NUMBER := 0-1962.0724
99 , p5_a11 NUMBER := 0-1962.0724
100 , p5_a12 NUMBER := 0-1962.0724
101 , p5_a13 NUMBER := 0-1962.0724
102 , p5_a14 NUMBER := 0-1962.0724
103 , p5_a15 NUMBER := 0-1962.0724
104 , p5_a16 NUMBER := 0-1962.0724
105 , p5_a17 NUMBER := 0-1962.0724
106 , p5_a18 NUMBER := 0-1962.0724
107 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
108 , p5_a20 NUMBER := 0-1962.0724
109 , p5_a21 NUMBER := 0-1962.0724
110 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
111 , p5_a23 NUMBER := 0-1962.0724
112 , p5_a24 NUMBER := 0-1962.0724
113 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
114 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
115 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
116 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
117 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
118 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
119 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
120 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
121 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
122 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
123 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
124 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
125 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
126 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
127 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
128 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
129 , p5_a41 NUMBER := 0-1962.0724
130 , p5_a42 NUMBER := 0-1962.0724
131 , p5_a43 DATE := fnd_api.g_miss_date
132 , p5_a44 NUMBER := 0-1962.0724
133 , p5_a45 DATE := fnd_api.g_miss_date
134 , p5_a46 NUMBER := 0-1962.0724
135 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
136 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
137 , p5_a49 NUMBER := 0-1962.0724
138 , p5_a50 NUMBER := 0-1962.0724
139 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
140 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
141 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
142 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
143 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
144 , p5_a56 NUMBER := 0-1962.0724
145 , p5_a57 VARCHAR2 := fnd_api.g_miss_char
146 )
147
148 as
149 ddp_saov_rec okl_sys_acct_opts_pub.saov_rec_type;
150 ddx_saov_rec okl_sys_acct_opts_pub.saov_rec_type;
151 ddindx binary_integer; indx binary_integer;
152 begin
153
154 -- copy data to the local IN or IN-OUT args, if any
155
156
157
158
159
160 ddp_saov_rec.id := rosetta_g_miss_num_map(p5_a0);
161 ddp_saov_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
162 ddp_saov_rec.set_of_books_id := rosetta_g_miss_num_map(p5_a2);
163 ddp_saov_rec.code_combination_id := rosetta_g_miss_num_map(p5_a3);
164 ddp_saov_rec.cc_rep_currency_code := p5_a4;
165 ddp_saov_rec.ael_rep_currency_code := p5_a5;
166 ddp_saov_rec.rec_ccid := rosetta_g_miss_num_map(p5_a6);
167 ddp_saov_rec.realized_gain_ccid := rosetta_g_miss_num_map(p5_a7);
168 ddp_saov_rec.realized_loss_ccid := rosetta_g_miss_num_map(p5_a8);
169 ddp_saov_rec.tax_ccid := rosetta_g_miss_num_map(p5_a9);
170 ddp_saov_rec.cross_currency_ccid := rosetta_g_miss_num_map(p5_a10);
171 ddp_saov_rec.rounding_ccid := rosetta_g_miss_num_map(p5_a11);
172 ddp_saov_rec.ar_clearing_ccid := rosetta_g_miss_num_map(p5_a12);
173 ddp_saov_rec.payables_ccid := rosetta_g_miss_num_map(p5_a13);
174 ddp_saov_rec.liablity_ccid := rosetta_g_miss_num_map(p5_a14);
175 ddp_saov_rec.pre_payment_ccid := rosetta_g_miss_num_map(p5_a15);
176 ddp_saov_rec.fut_date_pay_ccid := rosetta_g_miss_num_map(p5_a16);
177 ddp_saov_rec.dis_taken_ccid := rosetta_g_miss_num_map(p5_a17);
178 ddp_saov_rec.ap_clearing_ccid := rosetta_g_miss_num_map(p5_a18);
179 ddp_saov_rec.ael_rounding_rule := p5_a19;
180 ddp_saov_rec.ael_precision := rosetta_g_miss_num_map(p5_a20);
181 ddp_saov_rec.ael_min_acct_unit := rosetta_g_miss_num_map(p5_a21);
182 ddp_saov_rec.cc_rounding_rule := p5_a22;
183 ddp_saov_rec.cc_precision := rosetta_g_miss_num_map(p5_a23);
184 ddp_saov_rec.cc_min_acct_unit := rosetta_g_miss_num_map(p5_a24);
185 ddp_saov_rec.attribute_category := p5_a25;
186 ddp_saov_rec.attribute1 := p5_a26;
187 ddp_saov_rec.attribute2 := p5_a27;
188 ddp_saov_rec.attribute3 := p5_a28;
189 ddp_saov_rec.attribute4 := p5_a29;
190 ddp_saov_rec.attribute5 := p5_a30;
191 ddp_saov_rec.attribute6 := p5_a31;
192 ddp_saov_rec.attribute7 := p5_a32;
193 ddp_saov_rec.attribute8 := p5_a33;
194 ddp_saov_rec.attribute9 := p5_a34;
195 ddp_saov_rec.attribute10 := p5_a35;
196 ddp_saov_rec.attribute11 := p5_a36;
197 ddp_saov_rec.attribute12 := p5_a37;
198 ddp_saov_rec.attribute13 := p5_a38;
199 ddp_saov_rec.attribute14 := p5_a39;
200 ddp_saov_rec.attribute15 := p5_a40;
201 ddp_saov_rec.org_id := rosetta_g_miss_num_map(p5_a41);
202 ddp_saov_rec.created_by := rosetta_g_miss_num_map(p5_a42);
203 ddp_saov_rec.creation_date := rosetta_g_miss_date_in_map(p5_a43);
204 ddp_saov_rec.last_updated_by := rosetta_g_miss_num_map(p5_a44);
205 ddp_saov_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a45);
206 ddp_saov_rec.last_update_login := rosetta_g_miss_num_map(p5_a46);
207 ddp_saov_rec.cc_apply_rounding_difference := p5_a47;
208 ddp_saov_rec.ael_apply_rounding_difference := p5_a48;
209 ddp_saov_rec.accrual_reversal_days := rosetta_g_miss_num_map(p5_a49);
210 ddp_saov_rec.lke_hold_days := rosetta_g_miss_num_map(p5_a50);
211 ddp_saov_rec.stm_apply_rounding_difference := p5_a51;
212 ddp_saov_rec.stm_rounding_rule := p5_a52;
213 ddp_saov_rec.validate_khr_start_date := p5_a53;
214 ddp_saov_rec.account_derivation := p5_a54;
215 ddp_saov_rec.isg_arrears_pay_dates_option := p5_a55;
216 ddp_saov_rec.pay_dist_set_id := rosetta_g_miss_num_map(p5_a56);
217 ddp_saov_rec.secondary_rep_method := p5_a57;
218
219
220 -- here's the delegated call to the old PL/SQL routine
221 okl_sys_acct_opts_pub.insert_sys_acct_opts(p_api_version,
222 p_init_msg_list,
223 x_return_status,
224 x_msg_count,
225 x_msg_data,
226 ddp_saov_rec,
227 ddx_saov_rec);
228
229 -- copy data back from the local variables to OUT or IN-OUT args, if any
230
231
232
233
234
235
236 p6_a0 := rosetta_g_miss_num_map(ddx_saov_rec.id);
237 p6_a1 := rosetta_g_miss_num_map(ddx_saov_rec.object_version_number);
238 p6_a2 := rosetta_g_miss_num_map(ddx_saov_rec.set_of_books_id);
239 p6_a3 := rosetta_g_miss_num_map(ddx_saov_rec.code_combination_id);
240 p6_a4 := ddx_saov_rec.cc_rep_currency_code;
241 p6_a5 := ddx_saov_rec.ael_rep_currency_code;
242 p6_a6 := rosetta_g_miss_num_map(ddx_saov_rec.rec_ccid);
243 p6_a7 := rosetta_g_miss_num_map(ddx_saov_rec.realized_gain_ccid);
244 p6_a8 := rosetta_g_miss_num_map(ddx_saov_rec.realized_loss_ccid);
245 p6_a9 := rosetta_g_miss_num_map(ddx_saov_rec.tax_ccid);
246 p6_a10 := rosetta_g_miss_num_map(ddx_saov_rec.cross_currency_ccid);
247 p6_a11 := rosetta_g_miss_num_map(ddx_saov_rec.rounding_ccid);
248 p6_a12 := rosetta_g_miss_num_map(ddx_saov_rec.ar_clearing_ccid);
249 p6_a13 := rosetta_g_miss_num_map(ddx_saov_rec.payables_ccid);
250 p6_a14 := rosetta_g_miss_num_map(ddx_saov_rec.liablity_ccid);
251 p6_a15 := rosetta_g_miss_num_map(ddx_saov_rec.pre_payment_ccid);
252 p6_a16 := rosetta_g_miss_num_map(ddx_saov_rec.fut_date_pay_ccid);
253 p6_a17 := rosetta_g_miss_num_map(ddx_saov_rec.dis_taken_ccid);
254 p6_a18 := rosetta_g_miss_num_map(ddx_saov_rec.ap_clearing_ccid);
255 p6_a19 := ddx_saov_rec.ael_rounding_rule;
256 p6_a20 := rosetta_g_miss_num_map(ddx_saov_rec.ael_precision);
257 p6_a21 := rosetta_g_miss_num_map(ddx_saov_rec.ael_min_acct_unit);
258 p6_a22 := ddx_saov_rec.cc_rounding_rule;
259 p6_a23 := rosetta_g_miss_num_map(ddx_saov_rec.cc_precision);
260 p6_a24 := rosetta_g_miss_num_map(ddx_saov_rec.cc_min_acct_unit);
261 p6_a25 := ddx_saov_rec.attribute_category;
262 p6_a26 := ddx_saov_rec.attribute1;
263 p6_a27 := ddx_saov_rec.attribute2;
264 p6_a28 := ddx_saov_rec.attribute3;
265 p6_a29 := ddx_saov_rec.attribute4;
266 p6_a30 := ddx_saov_rec.attribute5;
267 p6_a31 := ddx_saov_rec.attribute6;
268 p6_a32 := ddx_saov_rec.attribute7;
269 p6_a33 := ddx_saov_rec.attribute8;
270 p6_a34 := ddx_saov_rec.attribute9;
271 p6_a35 := ddx_saov_rec.attribute10;
272 p6_a36 := ddx_saov_rec.attribute11;
273 p6_a37 := ddx_saov_rec.attribute12;
274 p6_a38 := ddx_saov_rec.attribute13;
275 p6_a39 := ddx_saov_rec.attribute14;
276 p6_a40 := ddx_saov_rec.attribute15;
277 p6_a41 := rosetta_g_miss_num_map(ddx_saov_rec.org_id);
278 p6_a42 := rosetta_g_miss_num_map(ddx_saov_rec.created_by);
279 p6_a43 := ddx_saov_rec.creation_date;
280 p6_a44 := rosetta_g_miss_num_map(ddx_saov_rec.last_updated_by);
281 p6_a45 := ddx_saov_rec.last_update_date;
282 p6_a46 := rosetta_g_miss_num_map(ddx_saov_rec.last_update_login);
283 p6_a47 := ddx_saov_rec.cc_apply_rounding_difference;
284 p6_a48 := ddx_saov_rec.ael_apply_rounding_difference;
285 p6_a49 := rosetta_g_miss_num_map(ddx_saov_rec.accrual_reversal_days);
286 p6_a50 := rosetta_g_miss_num_map(ddx_saov_rec.lke_hold_days);
287 p6_a51 := ddx_saov_rec.stm_apply_rounding_difference;
288 p6_a52 := ddx_saov_rec.stm_rounding_rule;
289 p6_a53 := ddx_saov_rec.validate_khr_start_date;
290 p6_a54 := ddx_saov_rec.account_derivation;
291 p6_a55 := ddx_saov_rec.isg_arrears_pay_dates_option;
292 p6_a56 := rosetta_g_miss_num_map(ddx_saov_rec.pay_dist_set_id);
293 p6_a57 := ddx_saov_rec.secondary_rep_method;
294 end;
295
296 procedure insert_sys_acct_opts(p_api_version NUMBER
297 , p_init_msg_list VARCHAR2
298 , x_return_status out nocopy VARCHAR2
299 , x_msg_count out nocopy NUMBER
300 , x_msg_data out nocopy VARCHAR2
301 , p5_a0 JTF_NUMBER_TABLE
302 , p5_a1 JTF_NUMBER_TABLE
303 , p5_a2 JTF_NUMBER_TABLE
304 , p5_a3 JTF_NUMBER_TABLE
305 , p5_a4 JTF_VARCHAR2_TABLE_100
306 , p5_a5 JTF_VARCHAR2_TABLE_100
307 , p5_a6 JTF_NUMBER_TABLE
308 , p5_a7 JTF_NUMBER_TABLE
309 , p5_a8 JTF_NUMBER_TABLE
310 , p5_a9 JTF_NUMBER_TABLE
311 , p5_a10 JTF_NUMBER_TABLE
312 , p5_a11 JTF_NUMBER_TABLE
313 , p5_a12 JTF_NUMBER_TABLE
314 , p5_a13 JTF_NUMBER_TABLE
315 , p5_a14 JTF_NUMBER_TABLE
316 , p5_a15 JTF_NUMBER_TABLE
317 , p5_a16 JTF_NUMBER_TABLE
318 , p5_a17 JTF_NUMBER_TABLE
319 , p5_a18 JTF_NUMBER_TABLE
320 , p5_a19 JTF_VARCHAR2_TABLE_100
321 , p5_a20 JTF_NUMBER_TABLE
322 , p5_a21 JTF_NUMBER_TABLE
323 , p5_a22 JTF_VARCHAR2_TABLE_100
324 , p5_a23 JTF_NUMBER_TABLE
325 , p5_a24 JTF_NUMBER_TABLE
326 , p5_a25 JTF_VARCHAR2_TABLE_100
327 , p5_a26 JTF_VARCHAR2_TABLE_500
328 , p5_a27 JTF_VARCHAR2_TABLE_500
329 , p5_a28 JTF_VARCHAR2_TABLE_500
330 , p5_a29 JTF_VARCHAR2_TABLE_500
331 , p5_a30 JTF_VARCHAR2_TABLE_500
332 , p5_a31 JTF_VARCHAR2_TABLE_500
333 , p5_a32 JTF_VARCHAR2_TABLE_500
334 , p5_a33 JTF_VARCHAR2_TABLE_500
335 , p5_a34 JTF_VARCHAR2_TABLE_500
336 , p5_a35 JTF_VARCHAR2_TABLE_500
337 , p5_a36 JTF_VARCHAR2_TABLE_500
338 , p5_a37 JTF_VARCHAR2_TABLE_500
339 , p5_a38 JTF_VARCHAR2_TABLE_500
340 , p5_a39 JTF_VARCHAR2_TABLE_500
341 , p5_a40 JTF_VARCHAR2_TABLE_500
342 , p5_a41 JTF_NUMBER_TABLE
343 , p5_a42 JTF_NUMBER_TABLE
344 , p5_a43 JTF_DATE_TABLE
345 , p5_a44 JTF_NUMBER_TABLE
346 , p5_a45 JTF_DATE_TABLE
347 , p5_a46 JTF_NUMBER_TABLE
348 , p5_a47 JTF_VARCHAR2_TABLE_100
349 , p5_a48 JTF_VARCHAR2_TABLE_100
350 , p5_a49 JTF_NUMBER_TABLE
351 , p5_a50 JTF_NUMBER_TABLE
352 , p5_a51 JTF_VARCHAR2_TABLE_100
353 , p5_a52 JTF_VARCHAR2_TABLE_100
354 , p5_a53 JTF_VARCHAR2_TABLE_100
355 , p5_a54 JTF_VARCHAR2_TABLE_100
356 , p5_a55 JTF_VARCHAR2_TABLE_100
357 , p5_a56 JTF_NUMBER_TABLE
358 , p5_a57 JTF_VARCHAR2_TABLE_100
359 , p6_a0 out nocopy JTF_NUMBER_TABLE
360 , p6_a1 out nocopy JTF_NUMBER_TABLE
361 , p6_a2 out nocopy JTF_NUMBER_TABLE
362 , p6_a3 out nocopy JTF_NUMBER_TABLE
363 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
364 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
365 , p6_a6 out nocopy JTF_NUMBER_TABLE
366 , p6_a7 out nocopy JTF_NUMBER_TABLE
367 , p6_a8 out nocopy JTF_NUMBER_TABLE
368 , p6_a9 out nocopy JTF_NUMBER_TABLE
369 , p6_a10 out nocopy JTF_NUMBER_TABLE
370 , p6_a11 out nocopy JTF_NUMBER_TABLE
371 , p6_a12 out nocopy JTF_NUMBER_TABLE
372 , p6_a13 out nocopy JTF_NUMBER_TABLE
373 , p6_a14 out nocopy JTF_NUMBER_TABLE
374 , p6_a15 out nocopy JTF_NUMBER_TABLE
375 , p6_a16 out nocopy JTF_NUMBER_TABLE
376 , p6_a17 out nocopy JTF_NUMBER_TABLE
377 , p6_a18 out nocopy JTF_NUMBER_TABLE
378 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
379 , p6_a20 out nocopy JTF_NUMBER_TABLE
380 , p6_a21 out nocopy JTF_NUMBER_TABLE
381 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
382 , p6_a23 out nocopy JTF_NUMBER_TABLE
383 , p6_a24 out nocopy JTF_NUMBER_TABLE
384 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
385 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
386 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
387 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
388 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
389 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
390 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
391 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
392 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
393 , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
394 , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
395 , p6_a36 out nocopy JTF_VARCHAR2_TABLE_500
396 , p6_a37 out nocopy JTF_VARCHAR2_TABLE_500
397 , p6_a38 out nocopy JTF_VARCHAR2_TABLE_500
398 , p6_a39 out nocopy JTF_VARCHAR2_TABLE_500
399 , p6_a40 out nocopy JTF_VARCHAR2_TABLE_500
400 , p6_a41 out nocopy JTF_NUMBER_TABLE
401 , p6_a42 out nocopy JTF_NUMBER_TABLE
402 , p6_a43 out nocopy JTF_DATE_TABLE
403 , p6_a44 out nocopy JTF_NUMBER_TABLE
404 , p6_a45 out nocopy JTF_DATE_TABLE
405 , p6_a46 out nocopy JTF_NUMBER_TABLE
406 , p6_a47 out nocopy JTF_VARCHAR2_TABLE_100
407 , p6_a48 out nocopy JTF_VARCHAR2_TABLE_100
408 , p6_a49 out nocopy JTF_NUMBER_TABLE
409 , p6_a50 out nocopy JTF_NUMBER_TABLE
410 , p6_a51 out nocopy JTF_VARCHAR2_TABLE_100
411 , p6_a52 out nocopy JTF_VARCHAR2_TABLE_100
412 , p6_a53 out nocopy JTF_VARCHAR2_TABLE_100
413 , p6_a54 out nocopy JTF_VARCHAR2_TABLE_100
414 , p6_a55 out nocopy JTF_VARCHAR2_TABLE_100
415 , p6_a56 out nocopy JTF_NUMBER_TABLE
416 , p6_a57 out nocopy JTF_VARCHAR2_TABLE_100
417 )
418
419 as
420 ddp_saov_tbl okl_sys_acct_opts_pub.saov_tbl_type;
421 ddx_saov_tbl okl_sys_acct_opts_pub.saov_tbl_type;
422 ddindx binary_integer; indx binary_integer;
423 begin
424
425 -- copy data to the local IN or IN-OUT args, if any
426
427
428
429
430
431 okl_sao_pvt_w.rosetta_table_copy_in_p5(ddp_saov_tbl, p5_a0
432 , p5_a1
433 , p5_a2
434 , p5_a3
435 , p5_a4
436 , p5_a5
437 , p5_a6
438 , p5_a7
439 , p5_a8
440 , p5_a9
441 , p5_a10
442 , p5_a11
443 , p5_a12
444 , p5_a13
445 , p5_a14
446 , p5_a15
447 , p5_a16
448 , p5_a17
449 , p5_a18
450 , p5_a19
451 , p5_a20
452 , p5_a21
453 , p5_a22
454 , p5_a23
455 , p5_a24
456 , p5_a25
457 , p5_a26
458 , p5_a27
459 , p5_a28
460 , p5_a29
461 , p5_a30
462 , p5_a31
463 , p5_a32
464 , p5_a33
465 , p5_a34
466 , p5_a35
467 , p5_a36
468 , p5_a37
469 , p5_a38
470 , p5_a39
471 , p5_a40
472 , p5_a41
473 , p5_a42
474 , p5_a43
475 , p5_a44
476 , p5_a45
477 , p5_a46
478 , p5_a47
479 , p5_a48
480 , p5_a49
481 , p5_a50
482 , p5_a51
483 , p5_a52
484 , p5_a53
485 , p5_a54
486 , p5_a55
487 , p5_a56
488 , p5_a57
489 );
490
491
492 -- here's the delegated call to the old PL/SQL routine
493 okl_sys_acct_opts_pub.insert_sys_acct_opts(p_api_version,
494 p_init_msg_list,
495 x_return_status,
496 x_msg_count,
497 x_msg_data,
498 ddp_saov_tbl,
499 ddx_saov_tbl);
500
501 -- copy data back from the local variables to OUT or IN-OUT args, if any
502
503
504
505
506
507
508 okl_sao_pvt_w.rosetta_table_copy_out_p5(ddx_saov_tbl, p6_a0
509 , p6_a1
510 , p6_a2
511 , p6_a3
512 , p6_a4
513 , p6_a5
514 , p6_a6
515 , p6_a7
516 , p6_a8
517 , p6_a9
518 , p6_a10
519 , p6_a11
520 , p6_a12
521 , p6_a13
522 , p6_a14
523 , p6_a15
524 , p6_a16
525 , p6_a17
526 , p6_a18
527 , p6_a19
528 , p6_a20
529 , p6_a21
530 , p6_a22
531 , p6_a23
532 , p6_a24
533 , p6_a25
534 , p6_a26
535 , p6_a27
536 , p6_a28
537 , p6_a29
538 , p6_a30
539 , p6_a31
540 , p6_a32
541 , p6_a33
542 , p6_a34
543 , p6_a35
544 , p6_a36
545 , p6_a37
546 , p6_a38
547 , p6_a39
548 , p6_a40
549 , p6_a41
550 , p6_a42
551 , p6_a43
552 , p6_a44
553 , p6_a45
554 , p6_a46
555 , p6_a47
556 , p6_a48
557 , p6_a49
558 , p6_a50
559 , p6_a51
560 , p6_a52
561 , p6_a53
562 , p6_a54
563 , p6_a55
564 , p6_a56
565 , p6_a57
566 );
567 end;
568
569 procedure lock_sys_acct_opts(p_api_version NUMBER
570 , p_init_msg_list VARCHAR2
571 , x_return_status out nocopy VARCHAR2
572 , x_msg_count out nocopy NUMBER
573 , x_msg_data out nocopy VARCHAR2
574 , p5_a0 NUMBER := 0-1962.0724
575 , p5_a1 NUMBER := 0-1962.0724
576 , p5_a2 NUMBER := 0-1962.0724
577 , p5_a3 NUMBER := 0-1962.0724
578 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
579 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
580 , p5_a6 NUMBER := 0-1962.0724
581 , p5_a7 NUMBER := 0-1962.0724
582 , p5_a8 NUMBER := 0-1962.0724
583 , p5_a9 NUMBER := 0-1962.0724
584 , p5_a10 NUMBER := 0-1962.0724
585 , p5_a11 NUMBER := 0-1962.0724
586 , p5_a12 NUMBER := 0-1962.0724
587 , p5_a13 NUMBER := 0-1962.0724
588 , p5_a14 NUMBER := 0-1962.0724
589 , p5_a15 NUMBER := 0-1962.0724
590 , p5_a16 NUMBER := 0-1962.0724
591 , p5_a17 NUMBER := 0-1962.0724
592 , p5_a18 NUMBER := 0-1962.0724
593 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
594 , p5_a20 NUMBER := 0-1962.0724
595 , p5_a21 NUMBER := 0-1962.0724
596 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
597 , p5_a23 NUMBER := 0-1962.0724
598 , p5_a24 NUMBER := 0-1962.0724
599 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
600 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
601 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
602 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
603 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
604 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
605 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
606 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
607 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
608 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
609 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
610 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
611 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
612 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
613 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
614 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
615 , p5_a41 NUMBER := 0-1962.0724
616 , p5_a42 NUMBER := 0-1962.0724
617 , p5_a43 DATE := fnd_api.g_miss_date
618 , p5_a44 NUMBER := 0-1962.0724
619 , p5_a45 DATE := fnd_api.g_miss_date
620 , p5_a46 NUMBER := 0-1962.0724
621 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
622 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
623 , p5_a49 NUMBER := 0-1962.0724
624 , p5_a50 NUMBER := 0-1962.0724
625 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
626 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
627 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
628 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
629 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
630 , p5_a56 NUMBER := 0-1962.0724
631 , p5_a57 VARCHAR2 := fnd_api.g_miss_char
632 )
633
634 as
635 ddp_saov_rec okl_sys_acct_opts_pub.saov_rec_type;
636 ddindx binary_integer; indx binary_integer;
637 begin
638
639 -- copy data to the local IN or IN-OUT args, if any
640
641
642
643
644
645 ddp_saov_rec.id := rosetta_g_miss_num_map(p5_a0);
646 ddp_saov_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
647 ddp_saov_rec.set_of_books_id := rosetta_g_miss_num_map(p5_a2);
648 ddp_saov_rec.code_combination_id := rosetta_g_miss_num_map(p5_a3);
649 ddp_saov_rec.cc_rep_currency_code := p5_a4;
650 ddp_saov_rec.ael_rep_currency_code := p5_a5;
651 ddp_saov_rec.rec_ccid := rosetta_g_miss_num_map(p5_a6);
652 ddp_saov_rec.realized_gain_ccid := rosetta_g_miss_num_map(p5_a7);
653 ddp_saov_rec.realized_loss_ccid := rosetta_g_miss_num_map(p5_a8);
654 ddp_saov_rec.tax_ccid := rosetta_g_miss_num_map(p5_a9);
655 ddp_saov_rec.cross_currency_ccid := rosetta_g_miss_num_map(p5_a10);
656 ddp_saov_rec.rounding_ccid := rosetta_g_miss_num_map(p5_a11);
657 ddp_saov_rec.ar_clearing_ccid := rosetta_g_miss_num_map(p5_a12);
658 ddp_saov_rec.payables_ccid := rosetta_g_miss_num_map(p5_a13);
659 ddp_saov_rec.liablity_ccid := rosetta_g_miss_num_map(p5_a14);
660 ddp_saov_rec.pre_payment_ccid := rosetta_g_miss_num_map(p5_a15);
661 ddp_saov_rec.fut_date_pay_ccid := rosetta_g_miss_num_map(p5_a16);
662 ddp_saov_rec.dis_taken_ccid := rosetta_g_miss_num_map(p5_a17);
663 ddp_saov_rec.ap_clearing_ccid := rosetta_g_miss_num_map(p5_a18);
664 ddp_saov_rec.ael_rounding_rule := p5_a19;
665 ddp_saov_rec.ael_precision := rosetta_g_miss_num_map(p5_a20);
666 ddp_saov_rec.ael_min_acct_unit := rosetta_g_miss_num_map(p5_a21);
667 ddp_saov_rec.cc_rounding_rule := p5_a22;
668 ddp_saov_rec.cc_precision := rosetta_g_miss_num_map(p5_a23);
669 ddp_saov_rec.cc_min_acct_unit := rosetta_g_miss_num_map(p5_a24);
670 ddp_saov_rec.attribute_category := p5_a25;
671 ddp_saov_rec.attribute1 := p5_a26;
672 ddp_saov_rec.attribute2 := p5_a27;
673 ddp_saov_rec.attribute3 := p5_a28;
674 ddp_saov_rec.attribute4 := p5_a29;
675 ddp_saov_rec.attribute5 := p5_a30;
676 ddp_saov_rec.attribute6 := p5_a31;
677 ddp_saov_rec.attribute7 := p5_a32;
678 ddp_saov_rec.attribute8 := p5_a33;
679 ddp_saov_rec.attribute9 := p5_a34;
680 ddp_saov_rec.attribute10 := p5_a35;
681 ddp_saov_rec.attribute11 := p5_a36;
682 ddp_saov_rec.attribute12 := p5_a37;
683 ddp_saov_rec.attribute13 := p5_a38;
684 ddp_saov_rec.attribute14 := p5_a39;
685 ddp_saov_rec.attribute15 := p5_a40;
686 ddp_saov_rec.org_id := rosetta_g_miss_num_map(p5_a41);
687 ddp_saov_rec.created_by := rosetta_g_miss_num_map(p5_a42);
688 ddp_saov_rec.creation_date := rosetta_g_miss_date_in_map(p5_a43);
689 ddp_saov_rec.last_updated_by := rosetta_g_miss_num_map(p5_a44);
690 ddp_saov_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a45);
691 ddp_saov_rec.last_update_login := rosetta_g_miss_num_map(p5_a46);
692 ddp_saov_rec.cc_apply_rounding_difference := p5_a47;
693 ddp_saov_rec.ael_apply_rounding_difference := p5_a48;
694 ddp_saov_rec.accrual_reversal_days := rosetta_g_miss_num_map(p5_a49);
695 ddp_saov_rec.lke_hold_days := rosetta_g_miss_num_map(p5_a50);
696 ddp_saov_rec.stm_apply_rounding_difference := p5_a51;
697 ddp_saov_rec.stm_rounding_rule := p5_a52;
698 ddp_saov_rec.validate_khr_start_date := p5_a53;
699 ddp_saov_rec.account_derivation := p5_a54;
700 ddp_saov_rec.isg_arrears_pay_dates_option := p5_a55;
701 ddp_saov_rec.pay_dist_set_id := rosetta_g_miss_num_map(p5_a56);
702 ddp_saov_rec.secondary_rep_method := p5_a57;
703
704 -- here's the delegated call to the old PL/SQL routine
705 okl_sys_acct_opts_pub.lock_sys_acct_opts(p_api_version,
706 p_init_msg_list,
707 x_return_status,
708 x_msg_count,
709 x_msg_data,
710 ddp_saov_rec);
711
712 -- copy data back from the local variables to OUT or IN-OUT args, if any
713
714
715
716
717
718 end;
719
720 procedure lock_sys_acct_opts(p_api_version NUMBER
721 , p_init_msg_list VARCHAR2
722 , x_return_status out nocopy VARCHAR2
723 , x_msg_count out nocopy NUMBER
724 , x_msg_data out nocopy VARCHAR2
725 , p5_a0 JTF_NUMBER_TABLE
726 , p5_a1 JTF_NUMBER_TABLE
727 , p5_a2 JTF_NUMBER_TABLE
728 , p5_a3 JTF_NUMBER_TABLE
729 , p5_a4 JTF_VARCHAR2_TABLE_100
730 , p5_a5 JTF_VARCHAR2_TABLE_100
731 , p5_a6 JTF_NUMBER_TABLE
732 , p5_a7 JTF_NUMBER_TABLE
733 , p5_a8 JTF_NUMBER_TABLE
734 , p5_a9 JTF_NUMBER_TABLE
735 , p5_a10 JTF_NUMBER_TABLE
736 , p5_a11 JTF_NUMBER_TABLE
737 , p5_a12 JTF_NUMBER_TABLE
738 , p5_a13 JTF_NUMBER_TABLE
739 , p5_a14 JTF_NUMBER_TABLE
740 , p5_a15 JTF_NUMBER_TABLE
741 , p5_a16 JTF_NUMBER_TABLE
742 , p5_a17 JTF_NUMBER_TABLE
743 , p5_a18 JTF_NUMBER_TABLE
744 , p5_a19 JTF_VARCHAR2_TABLE_100
745 , p5_a20 JTF_NUMBER_TABLE
746 , p5_a21 JTF_NUMBER_TABLE
747 , p5_a22 JTF_VARCHAR2_TABLE_100
748 , p5_a23 JTF_NUMBER_TABLE
749 , p5_a24 JTF_NUMBER_TABLE
750 , p5_a25 JTF_VARCHAR2_TABLE_100
751 , p5_a26 JTF_VARCHAR2_TABLE_500
752 , p5_a27 JTF_VARCHAR2_TABLE_500
753 , p5_a28 JTF_VARCHAR2_TABLE_500
754 , p5_a29 JTF_VARCHAR2_TABLE_500
755 , p5_a30 JTF_VARCHAR2_TABLE_500
756 , p5_a31 JTF_VARCHAR2_TABLE_500
757 , p5_a32 JTF_VARCHAR2_TABLE_500
758 , p5_a33 JTF_VARCHAR2_TABLE_500
759 , p5_a34 JTF_VARCHAR2_TABLE_500
760 , p5_a35 JTF_VARCHAR2_TABLE_500
761 , p5_a36 JTF_VARCHAR2_TABLE_500
762 , p5_a37 JTF_VARCHAR2_TABLE_500
763 , p5_a38 JTF_VARCHAR2_TABLE_500
764 , p5_a39 JTF_VARCHAR2_TABLE_500
765 , p5_a40 JTF_VARCHAR2_TABLE_500
766 , p5_a41 JTF_NUMBER_TABLE
767 , p5_a42 JTF_NUMBER_TABLE
768 , p5_a43 JTF_DATE_TABLE
769 , p5_a44 JTF_NUMBER_TABLE
770 , p5_a45 JTF_DATE_TABLE
771 , p5_a46 JTF_NUMBER_TABLE
772 , p5_a47 JTF_VARCHAR2_TABLE_100
773 , p5_a48 JTF_VARCHAR2_TABLE_100
774 , p5_a49 JTF_NUMBER_TABLE
775 , p5_a50 JTF_NUMBER_TABLE
776 , p5_a51 JTF_VARCHAR2_TABLE_100
777 , p5_a52 JTF_VARCHAR2_TABLE_100
778 , p5_a53 JTF_VARCHAR2_TABLE_100
779 , p5_a54 JTF_VARCHAR2_TABLE_100
780 , p5_a55 JTF_VARCHAR2_TABLE_100
781 , p5_a56 JTF_NUMBER_TABLE
782 , p5_a57 JTF_VARCHAR2_TABLE_100
783 )
784
785 as
786 ddp_saov_tbl okl_sys_acct_opts_pub.saov_tbl_type;
787 ddindx binary_integer; indx binary_integer;
788 begin
789
790 -- copy data to the local IN or IN-OUT args, if any
791
792
793
794
795
796 okl_sao_pvt_w.rosetta_table_copy_in_p5(ddp_saov_tbl, p5_a0
797 , p5_a1
798 , p5_a2
799 , p5_a3
800 , p5_a4
801 , p5_a5
802 , p5_a6
803 , p5_a7
804 , p5_a8
805 , p5_a9
806 , p5_a10
807 , p5_a11
808 , p5_a12
809 , p5_a13
810 , p5_a14
811 , p5_a15
812 , p5_a16
813 , p5_a17
814 , p5_a18
815 , p5_a19
816 , p5_a20
817 , p5_a21
818 , p5_a22
819 , p5_a23
820 , p5_a24
821 , p5_a25
822 , p5_a26
823 , p5_a27
824 , p5_a28
825 , p5_a29
826 , p5_a30
827 , p5_a31
828 , p5_a32
829 , p5_a33
830 , p5_a34
831 , p5_a35
832 , p5_a36
833 , p5_a37
834 , p5_a38
835 , p5_a39
836 , p5_a40
837 , p5_a41
838 , p5_a42
839 , p5_a43
840 , p5_a44
841 , p5_a45
842 , p5_a46
843 , p5_a47
844 , p5_a48
845 , p5_a49
846 , p5_a50
847 , p5_a51
848 , p5_a52
849 , p5_a53
850 , p5_a54
851 , p5_a55
852 , p5_a56
853 , p5_a57
854 );
855
856 -- here's the delegated call to the old PL/SQL routine
857 okl_sys_acct_opts_pub.lock_sys_acct_opts(p_api_version,
858 p_init_msg_list,
859 x_return_status,
860 x_msg_count,
861 x_msg_data,
862 ddp_saov_tbl);
863
864 -- copy data back from the local variables to OUT or IN-OUT args, if any
865
866
867
868
869
870 end;
871
872 procedure update_sys_acct_opts(p_api_version NUMBER
873 , p_init_msg_list VARCHAR2
874 , x_return_status out nocopy VARCHAR2
875 , x_msg_count out nocopy NUMBER
876 , x_msg_data out nocopy VARCHAR2
877 , p6_a0 out nocopy NUMBER
878 , p6_a1 out nocopy NUMBER
879 , p6_a2 out nocopy NUMBER
880 , p6_a3 out nocopy NUMBER
881 , p6_a4 out nocopy VARCHAR2
882 , p6_a5 out nocopy VARCHAR2
883 , p6_a6 out nocopy NUMBER
884 , p6_a7 out nocopy NUMBER
885 , p6_a8 out nocopy NUMBER
886 , p6_a9 out nocopy NUMBER
887 , p6_a10 out nocopy NUMBER
888 , p6_a11 out nocopy NUMBER
889 , p6_a12 out nocopy NUMBER
890 , p6_a13 out nocopy NUMBER
891 , p6_a14 out nocopy NUMBER
892 , p6_a15 out nocopy NUMBER
893 , p6_a16 out nocopy NUMBER
894 , p6_a17 out nocopy NUMBER
895 , p6_a18 out nocopy NUMBER
896 , p6_a19 out nocopy VARCHAR2
897 , p6_a20 out nocopy NUMBER
898 , p6_a21 out nocopy NUMBER
899 , p6_a22 out nocopy VARCHAR2
900 , p6_a23 out nocopy NUMBER
901 , p6_a24 out nocopy NUMBER
902 , p6_a25 out nocopy VARCHAR2
903 , p6_a26 out nocopy VARCHAR2
904 , p6_a27 out nocopy VARCHAR2
905 , p6_a28 out nocopy VARCHAR2
906 , p6_a29 out nocopy VARCHAR2
907 , p6_a30 out nocopy VARCHAR2
908 , p6_a31 out nocopy VARCHAR2
909 , p6_a32 out nocopy VARCHAR2
910 , p6_a33 out nocopy VARCHAR2
911 , p6_a34 out nocopy VARCHAR2
912 , p6_a35 out nocopy VARCHAR2
913 , p6_a36 out nocopy VARCHAR2
914 , p6_a37 out nocopy VARCHAR2
915 , p6_a38 out nocopy VARCHAR2
916 , p6_a39 out nocopy VARCHAR2
917 , p6_a40 out nocopy VARCHAR2
918 , p6_a41 out nocopy NUMBER
919 , p6_a42 out nocopy NUMBER
920 , p6_a43 out nocopy DATE
921 , p6_a44 out nocopy NUMBER
922 , p6_a45 out nocopy DATE
923 , p6_a46 out nocopy NUMBER
924 , p6_a47 out nocopy VARCHAR2
925 , p6_a48 out nocopy VARCHAR2
926 , p6_a49 out nocopy NUMBER
927 , p6_a50 out nocopy NUMBER
928 , p6_a51 out nocopy VARCHAR2
929 , p6_a52 out nocopy VARCHAR2
930 , p6_a53 out nocopy VARCHAR2
931 , p6_a54 out nocopy VARCHAR2
932 , p6_a55 out nocopy VARCHAR2
933 , p6_a56 out nocopy NUMBER
934 , p6_a57 out nocopy VARCHAR2
935 , p5_a0 NUMBER := 0-1962.0724
936 , p5_a1 NUMBER := 0-1962.0724
937 , p5_a2 NUMBER := 0-1962.0724
938 , p5_a3 NUMBER := 0-1962.0724
939 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
940 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
941 , p5_a6 NUMBER := 0-1962.0724
942 , p5_a7 NUMBER := 0-1962.0724
943 , p5_a8 NUMBER := 0-1962.0724
944 , p5_a9 NUMBER := 0-1962.0724
945 , p5_a10 NUMBER := 0-1962.0724
946 , p5_a11 NUMBER := 0-1962.0724
947 , p5_a12 NUMBER := 0-1962.0724
948 , p5_a13 NUMBER := 0-1962.0724
949 , p5_a14 NUMBER := 0-1962.0724
950 , p5_a15 NUMBER := 0-1962.0724
951 , p5_a16 NUMBER := 0-1962.0724
952 , p5_a17 NUMBER := 0-1962.0724
953 , p5_a18 NUMBER := 0-1962.0724
954 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
955 , p5_a20 NUMBER := 0-1962.0724
956 , p5_a21 NUMBER := 0-1962.0724
957 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
958 , p5_a23 NUMBER := 0-1962.0724
959 , p5_a24 NUMBER := 0-1962.0724
960 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
961 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
962 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
963 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
964 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
965 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
966 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
967 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
968 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
969 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
970 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
971 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
972 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
973 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
974 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
975 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
976 , p5_a41 NUMBER := 0-1962.0724
977 , p5_a42 NUMBER := 0-1962.0724
978 , p5_a43 DATE := fnd_api.g_miss_date
979 , p5_a44 NUMBER := 0-1962.0724
980 , p5_a45 DATE := fnd_api.g_miss_date
981 , p5_a46 NUMBER := 0-1962.0724
982 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
983 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
984 , p5_a49 NUMBER := 0-1962.0724
985 , p5_a50 NUMBER := 0-1962.0724
986 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
987 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
988 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
989 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
990 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
991 , p5_a56 NUMBER := 0-1962.0724
992 , p5_a57 VARCHAR2 := fnd_api.g_miss_char
993 )
994
995 as
996 ddp_saov_rec okl_sys_acct_opts_pub.saov_rec_type;
997 ddx_saov_rec okl_sys_acct_opts_pub.saov_rec_type;
998 ddindx binary_integer; indx binary_integer;
999 begin
1000
1001 -- copy data to the local IN or IN-OUT args, if any
1002
1003
1004
1005
1006
1007 ddp_saov_rec.id := rosetta_g_miss_num_map(p5_a0);
1008 ddp_saov_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1009 ddp_saov_rec.set_of_books_id := rosetta_g_miss_num_map(p5_a2);
1010 ddp_saov_rec.code_combination_id := rosetta_g_miss_num_map(p5_a3);
1011 ddp_saov_rec.cc_rep_currency_code := p5_a4;
1012 ddp_saov_rec.ael_rep_currency_code := p5_a5;
1013 ddp_saov_rec.rec_ccid := rosetta_g_miss_num_map(p5_a6);
1014 ddp_saov_rec.realized_gain_ccid := rosetta_g_miss_num_map(p5_a7);
1015 ddp_saov_rec.realized_loss_ccid := rosetta_g_miss_num_map(p5_a8);
1016 ddp_saov_rec.tax_ccid := rosetta_g_miss_num_map(p5_a9);
1017 ddp_saov_rec.cross_currency_ccid := rosetta_g_miss_num_map(p5_a10);
1018 ddp_saov_rec.rounding_ccid := rosetta_g_miss_num_map(p5_a11);
1019 ddp_saov_rec.ar_clearing_ccid := rosetta_g_miss_num_map(p5_a12);
1020 ddp_saov_rec.payables_ccid := rosetta_g_miss_num_map(p5_a13);
1021 ddp_saov_rec.liablity_ccid := rosetta_g_miss_num_map(p5_a14);
1022 ddp_saov_rec.pre_payment_ccid := rosetta_g_miss_num_map(p5_a15);
1023 ddp_saov_rec.fut_date_pay_ccid := rosetta_g_miss_num_map(p5_a16);
1024 ddp_saov_rec.dis_taken_ccid := rosetta_g_miss_num_map(p5_a17);
1025 ddp_saov_rec.ap_clearing_ccid := rosetta_g_miss_num_map(p5_a18);
1026 ddp_saov_rec.ael_rounding_rule := p5_a19;
1027 ddp_saov_rec.ael_precision := rosetta_g_miss_num_map(p5_a20);
1028 ddp_saov_rec.ael_min_acct_unit := rosetta_g_miss_num_map(p5_a21);
1029 ddp_saov_rec.cc_rounding_rule := p5_a22;
1030 ddp_saov_rec.cc_precision := rosetta_g_miss_num_map(p5_a23);
1031 ddp_saov_rec.cc_min_acct_unit := rosetta_g_miss_num_map(p5_a24);
1032 ddp_saov_rec.attribute_category := p5_a25;
1033 ddp_saov_rec.attribute1 := p5_a26;
1034 ddp_saov_rec.attribute2 := p5_a27;
1035 ddp_saov_rec.attribute3 := p5_a28;
1036 ddp_saov_rec.attribute4 := p5_a29;
1037 ddp_saov_rec.attribute5 := p5_a30;
1038 ddp_saov_rec.attribute6 := p5_a31;
1039 ddp_saov_rec.attribute7 := p5_a32;
1040 ddp_saov_rec.attribute8 := p5_a33;
1041 ddp_saov_rec.attribute9 := p5_a34;
1042 ddp_saov_rec.attribute10 := p5_a35;
1043 ddp_saov_rec.attribute11 := p5_a36;
1044 ddp_saov_rec.attribute12 := p5_a37;
1045 ddp_saov_rec.attribute13 := p5_a38;
1046 ddp_saov_rec.attribute14 := p5_a39;
1047 ddp_saov_rec.attribute15 := p5_a40;
1048 ddp_saov_rec.org_id := rosetta_g_miss_num_map(p5_a41);
1049 ddp_saov_rec.created_by := rosetta_g_miss_num_map(p5_a42);
1050 ddp_saov_rec.creation_date := rosetta_g_miss_date_in_map(p5_a43);
1051 ddp_saov_rec.last_updated_by := rosetta_g_miss_num_map(p5_a44);
1052 ddp_saov_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a45);
1053 ddp_saov_rec.last_update_login := rosetta_g_miss_num_map(p5_a46);
1054 ddp_saov_rec.cc_apply_rounding_difference := p5_a47;
1055 ddp_saov_rec.ael_apply_rounding_difference := p5_a48;
1056 ddp_saov_rec.accrual_reversal_days := rosetta_g_miss_num_map(p5_a49);
1057 ddp_saov_rec.lke_hold_days := rosetta_g_miss_num_map(p5_a50);
1058 ddp_saov_rec.stm_apply_rounding_difference := p5_a51;
1059 ddp_saov_rec.stm_rounding_rule := p5_a52;
1060 ddp_saov_rec.validate_khr_start_date := p5_a53;
1061 ddp_saov_rec.account_derivation := p5_a54;
1062 ddp_saov_rec.isg_arrears_pay_dates_option := p5_a55;
1063 ddp_saov_rec.pay_dist_set_id := rosetta_g_miss_num_map(p5_a56);
1064 ddp_saov_rec.secondary_rep_method := p5_a57;
1065
1066
1067 -- here's the delegated call to the old PL/SQL routine
1068 okl_sys_acct_opts_pub.update_sys_acct_opts(p_api_version,
1069 p_init_msg_list,
1070 x_return_status,
1071 x_msg_count,
1072 x_msg_data,
1073 ddp_saov_rec,
1074 ddx_saov_rec);
1075
1076 -- copy data back from the local variables to OUT or IN-OUT args, if any
1077
1078
1079
1080
1081
1082
1083 p6_a0 := rosetta_g_miss_num_map(ddx_saov_rec.id);
1084 p6_a1 := rosetta_g_miss_num_map(ddx_saov_rec.object_version_number);
1085 p6_a2 := rosetta_g_miss_num_map(ddx_saov_rec.set_of_books_id);
1086 p6_a3 := rosetta_g_miss_num_map(ddx_saov_rec.code_combination_id);
1087 p6_a4 := ddx_saov_rec.cc_rep_currency_code;
1088 p6_a5 := ddx_saov_rec.ael_rep_currency_code;
1089 p6_a6 := rosetta_g_miss_num_map(ddx_saov_rec.rec_ccid);
1090 p6_a7 := rosetta_g_miss_num_map(ddx_saov_rec.realized_gain_ccid);
1091 p6_a8 := rosetta_g_miss_num_map(ddx_saov_rec.realized_loss_ccid);
1092 p6_a9 := rosetta_g_miss_num_map(ddx_saov_rec.tax_ccid);
1093 p6_a10 := rosetta_g_miss_num_map(ddx_saov_rec.cross_currency_ccid);
1094 p6_a11 := rosetta_g_miss_num_map(ddx_saov_rec.rounding_ccid);
1095 p6_a12 := rosetta_g_miss_num_map(ddx_saov_rec.ar_clearing_ccid);
1096 p6_a13 := rosetta_g_miss_num_map(ddx_saov_rec.payables_ccid);
1097 p6_a14 := rosetta_g_miss_num_map(ddx_saov_rec.liablity_ccid);
1098 p6_a15 := rosetta_g_miss_num_map(ddx_saov_rec.pre_payment_ccid);
1099 p6_a16 := rosetta_g_miss_num_map(ddx_saov_rec.fut_date_pay_ccid);
1100 p6_a17 := rosetta_g_miss_num_map(ddx_saov_rec.dis_taken_ccid);
1101 p6_a18 := rosetta_g_miss_num_map(ddx_saov_rec.ap_clearing_ccid);
1102 p6_a19 := ddx_saov_rec.ael_rounding_rule;
1103 p6_a20 := rosetta_g_miss_num_map(ddx_saov_rec.ael_precision);
1104 p6_a21 := rosetta_g_miss_num_map(ddx_saov_rec.ael_min_acct_unit);
1105 p6_a22 := ddx_saov_rec.cc_rounding_rule;
1106 p6_a23 := rosetta_g_miss_num_map(ddx_saov_rec.cc_precision);
1107 p6_a24 := rosetta_g_miss_num_map(ddx_saov_rec.cc_min_acct_unit);
1108 p6_a25 := ddx_saov_rec.attribute_category;
1109 p6_a26 := ddx_saov_rec.attribute1;
1110 p6_a27 := ddx_saov_rec.attribute2;
1111 p6_a28 := ddx_saov_rec.attribute3;
1112 p6_a29 := ddx_saov_rec.attribute4;
1113 p6_a30 := ddx_saov_rec.attribute5;
1114 p6_a31 := ddx_saov_rec.attribute6;
1115 p6_a32 := ddx_saov_rec.attribute7;
1116 p6_a33 := ddx_saov_rec.attribute8;
1117 p6_a34 := ddx_saov_rec.attribute9;
1118 p6_a35 := ddx_saov_rec.attribute10;
1119 p6_a36 := ddx_saov_rec.attribute11;
1120 p6_a37 := ddx_saov_rec.attribute12;
1121 p6_a38 := ddx_saov_rec.attribute13;
1122 p6_a39 := ddx_saov_rec.attribute14;
1123 p6_a40 := ddx_saov_rec.attribute15;
1124 p6_a41 := rosetta_g_miss_num_map(ddx_saov_rec.org_id);
1125 p6_a42 := rosetta_g_miss_num_map(ddx_saov_rec.created_by);
1126 p6_a43 := ddx_saov_rec.creation_date;
1127 p6_a44 := rosetta_g_miss_num_map(ddx_saov_rec.last_updated_by);
1128 p6_a45 := ddx_saov_rec.last_update_date;
1129 p6_a46 := rosetta_g_miss_num_map(ddx_saov_rec.last_update_login);
1130 p6_a47 := ddx_saov_rec.cc_apply_rounding_difference;
1131 p6_a48 := ddx_saov_rec.ael_apply_rounding_difference;
1132 p6_a49 := rosetta_g_miss_num_map(ddx_saov_rec.accrual_reversal_days);
1133 p6_a50 := rosetta_g_miss_num_map(ddx_saov_rec.lke_hold_days);
1134 p6_a51 := ddx_saov_rec.stm_apply_rounding_difference;
1135 p6_a52 := ddx_saov_rec.stm_rounding_rule;
1136 p6_a53 := ddx_saov_rec.validate_khr_start_date;
1137 p6_a54 := ddx_saov_rec.account_derivation;
1138 p6_a55 := ddx_saov_rec.isg_arrears_pay_dates_option;
1139 p6_a56 := rosetta_g_miss_num_map(ddx_saov_rec.pay_dist_set_id);
1140 p6_a57 := ddx_saov_rec.secondary_rep_method;
1141 end;
1142
1143 procedure update_sys_acct_opts(p_api_version NUMBER
1144 , p_init_msg_list VARCHAR2
1145 , x_return_status out nocopy VARCHAR2
1146 , x_msg_count out nocopy NUMBER
1147 , x_msg_data out nocopy VARCHAR2
1148 , p5_a0 JTF_NUMBER_TABLE
1149 , p5_a1 JTF_NUMBER_TABLE
1150 , p5_a2 JTF_NUMBER_TABLE
1151 , p5_a3 JTF_NUMBER_TABLE
1152 , p5_a4 JTF_VARCHAR2_TABLE_100
1153 , p5_a5 JTF_VARCHAR2_TABLE_100
1154 , p5_a6 JTF_NUMBER_TABLE
1155 , p5_a7 JTF_NUMBER_TABLE
1156 , p5_a8 JTF_NUMBER_TABLE
1157 , p5_a9 JTF_NUMBER_TABLE
1158 , p5_a10 JTF_NUMBER_TABLE
1159 , p5_a11 JTF_NUMBER_TABLE
1160 , p5_a12 JTF_NUMBER_TABLE
1161 , p5_a13 JTF_NUMBER_TABLE
1162 , p5_a14 JTF_NUMBER_TABLE
1163 , p5_a15 JTF_NUMBER_TABLE
1164 , p5_a16 JTF_NUMBER_TABLE
1165 , p5_a17 JTF_NUMBER_TABLE
1166 , p5_a18 JTF_NUMBER_TABLE
1167 , p5_a19 JTF_VARCHAR2_TABLE_100
1168 , p5_a20 JTF_NUMBER_TABLE
1169 , p5_a21 JTF_NUMBER_TABLE
1170 , p5_a22 JTF_VARCHAR2_TABLE_100
1171 , p5_a23 JTF_NUMBER_TABLE
1172 , p5_a24 JTF_NUMBER_TABLE
1173 , p5_a25 JTF_VARCHAR2_TABLE_100
1174 , p5_a26 JTF_VARCHAR2_TABLE_500
1175 , p5_a27 JTF_VARCHAR2_TABLE_500
1176 , p5_a28 JTF_VARCHAR2_TABLE_500
1177 , p5_a29 JTF_VARCHAR2_TABLE_500
1178 , p5_a30 JTF_VARCHAR2_TABLE_500
1179 , p5_a31 JTF_VARCHAR2_TABLE_500
1180 , p5_a32 JTF_VARCHAR2_TABLE_500
1181 , p5_a33 JTF_VARCHAR2_TABLE_500
1182 , p5_a34 JTF_VARCHAR2_TABLE_500
1183 , p5_a35 JTF_VARCHAR2_TABLE_500
1184 , p5_a36 JTF_VARCHAR2_TABLE_500
1185 , p5_a37 JTF_VARCHAR2_TABLE_500
1186 , p5_a38 JTF_VARCHAR2_TABLE_500
1187 , p5_a39 JTF_VARCHAR2_TABLE_500
1188 , p5_a40 JTF_VARCHAR2_TABLE_500
1189 , p5_a41 JTF_NUMBER_TABLE
1190 , p5_a42 JTF_NUMBER_TABLE
1191 , p5_a43 JTF_DATE_TABLE
1192 , p5_a44 JTF_NUMBER_TABLE
1193 , p5_a45 JTF_DATE_TABLE
1194 , p5_a46 JTF_NUMBER_TABLE
1195 , p5_a47 JTF_VARCHAR2_TABLE_100
1196 , p5_a48 JTF_VARCHAR2_TABLE_100
1197 , p5_a49 JTF_NUMBER_TABLE
1198 , p5_a50 JTF_NUMBER_TABLE
1199 , p5_a51 JTF_VARCHAR2_TABLE_100
1200 , p5_a52 JTF_VARCHAR2_TABLE_100
1201 , p5_a53 JTF_VARCHAR2_TABLE_100
1202 , p5_a54 JTF_VARCHAR2_TABLE_100
1203 , p5_a55 JTF_VARCHAR2_TABLE_100
1204 , p5_a56 JTF_NUMBER_TABLE
1205 , p5_a57 JTF_VARCHAR2_TABLE_100
1206 , p6_a0 out nocopy JTF_NUMBER_TABLE
1207 , p6_a1 out nocopy JTF_NUMBER_TABLE
1208 , p6_a2 out nocopy JTF_NUMBER_TABLE
1209 , p6_a3 out nocopy JTF_NUMBER_TABLE
1210 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1211 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1212 , p6_a6 out nocopy JTF_NUMBER_TABLE
1213 , p6_a7 out nocopy JTF_NUMBER_TABLE
1214 , p6_a8 out nocopy JTF_NUMBER_TABLE
1215 , p6_a9 out nocopy JTF_NUMBER_TABLE
1216 , p6_a10 out nocopy JTF_NUMBER_TABLE
1217 , p6_a11 out nocopy JTF_NUMBER_TABLE
1218 , p6_a12 out nocopy JTF_NUMBER_TABLE
1219 , p6_a13 out nocopy JTF_NUMBER_TABLE
1220 , p6_a14 out nocopy JTF_NUMBER_TABLE
1221 , p6_a15 out nocopy JTF_NUMBER_TABLE
1222 , p6_a16 out nocopy JTF_NUMBER_TABLE
1223 , p6_a17 out nocopy JTF_NUMBER_TABLE
1224 , p6_a18 out nocopy JTF_NUMBER_TABLE
1225 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
1226 , p6_a20 out nocopy JTF_NUMBER_TABLE
1227 , p6_a21 out nocopy JTF_NUMBER_TABLE
1228 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
1229 , p6_a23 out nocopy JTF_NUMBER_TABLE
1230 , p6_a24 out nocopy JTF_NUMBER_TABLE
1231 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
1232 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1233 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1234 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1235 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
1236 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
1237 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
1238 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
1239 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
1240 , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
1241 , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
1242 , p6_a36 out nocopy JTF_VARCHAR2_TABLE_500
1243 , p6_a37 out nocopy JTF_VARCHAR2_TABLE_500
1244 , p6_a38 out nocopy JTF_VARCHAR2_TABLE_500
1245 , p6_a39 out nocopy JTF_VARCHAR2_TABLE_500
1246 , p6_a40 out nocopy JTF_VARCHAR2_TABLE_500
1247 , p6_a41 out nocopy JTF_NUMBER_TABLE
1248 , p6_a42 out nocopy JTF_NUMBER_TABLE
1249 , p6_a43 out nocopy JTF_DATE_TABLE
1250 , p6_a44 out nocopy JTF_NUMBER_TABLE
1251 , p6_a45 out nocopy JTF_DATE_TABLE
1252 , p6_a46 out nocopy JTF_NUMBER_TABLE
1253 , p6_a47 out nocopy JTF_VARCHAR2_TABLE_100
1254 , p6_a48 out nocopy JTF_VARCHAR2_TABLE_100
1255 , p6_a49 out nocopy JTF_NUMBER_TABLE
1256 , p6_a50 out nocopy JTF_NUMBER_TABLE
1257 , p6_a51 out nocopy JTF_VARCHAR2_TABLE_100
1258 , p6_a52 out nocopy JTF_VARCHAR2_TABLE_100
1259 , p6_a53 out nocopy JTF_VARCHAR2_TABLE_100
1260 , p6_a54 out nocopy JTF_VARCHAR2_TABLE_100
1261 , p6_a55 out nocopy JTF_VARCHAR2_TABLE_100
1262 , p6_a56 out nocopy JTF_NUMBER_TABLE
1263 , p6_a57 out nocopy JTF_VARCHAR2_TABLE_100
1264 )
1265
1266 as
1267 ddp_saov_tbl okl_sys_acct_opts_pub.saov_tbl_type;
1268 ddx_saov_tbl okl_sys_acct_opts_pub.saov_tbl_type;
1269 ddindx binary_integer; indx binary_integer;
1270 begin
1271
1272 -- copy data to the local IN or IN-OUT args, if any
1273
1274
1275
1276
1277
1278 okl_sao_pvt_w.rosetta_table_copy_in_p5(ddp_saov_tbl, p5_a0
1279 , p5_a1
1280 , p5_a2
1281 , p5_a3
1282 , p5_a4
1283 , p5_a5
1284 , p5_a6
1285 , p5_a7
1286 , p5_a8
1287 , p5_a9
1288 , p5_a10
1289 , p5_a11
1290 , p5_a12
1291 , p5_a13
1292 , p5_a14
1293 , p5_a15
1294 , p5_a16
1295 , p5_a17
1296 , p5_a18
1297 , p5_a19
1298 , p5_a20
1299 , p5_a21
1300 , p5_a22
1301 , p5_a23
1302 , p5_a24
1303 , p5_a25
1304 , p5_a26
1305 , p5_a27
1306 , p5_a28
1307 , p5_a29
1308 , p5_a30
1309 , p5_a31
1310 , p5_a32
1311 , p5_a33
1312 , p5_a34
1313 , p5_a35
1314 , p5_a36
1315 , p5_a37
1316 , p5_a38
1317 , p5_a39
1318 , p5_a40
1319 , p5_a41
1320 , p5_a42
1321 , p5_a43
1322 , p5_a44
1323 , p5_a45
1324 , p5_a46
1325 , p5_a47
1326 , p5_a48
1327 , p5_a49
1328 , p5_a50
1329 , p5_a51
1330 , p5_a52
1331 , p5_a53
1332 , p5_a54
1333 , p5_a55
1334 , p5_a56
1335 , p5_a57
1336 );
1337
1338
1339 -- here's the delegated call to the old PL/SQL routine
1340 okl_sys_acct_opts_pub.update_sys_acct_opts(p_api_version,
1341 p_init_msg_list,
1342 x_return_status,
1343 x_msg_count,
1344 x_msg_data,
1345 ddp_saov_tbl,
1346 ddx_saov_tbl);
1347
1348 -- copy data back from the local variables to OUT or IN-OUT args, if any
1349
1350
1351
1352
1353
1354
1355 okl_sao_pvt_w.rosetta_table_copy_out_p5(ddx_saov_tbl, p6_a0
1356 , p6_a1
1357 , p6_a2
1358 , p6_a3
1359 , p6_a4
1360 , p6_a5
1361 , p6_a6
1362 , p6_a7
1363 , p6_a8
1364 , p6_a9
1365 , p6_a10
1366 , p6_a11
1367 , p6_a12
1368 , p6_a13
1369 , p6_a14
1370 , p6_a15
1371 , p6_a16
1372 , p6_a17
1373 , p6_a18
1374 , p6_a19
1375 , p6_a20
1376 , p6_a21
1377 , p6_a22
1378 , p6_a23
1379 , p6_a24
1380 , p6_a25
1381 , p6_a26
1382 , p6_a27
1383 , p6_a28
1384 , p6_a29
1385 , p6_a30
1386 , p6_a31
1387 , p6_a32
1388 , p6_a33
1389 , p6_a34
1390 , p6_a35
1391 , p6_a36
1392 , p6_a37
1393 , p6_a38
1394 , p6_a39
1395 , p6_a40
1396 , p6_a41
1397 , p6_a42
1398 , p6_a43
1399 , p6_a44
1400 , p6_a45
1401 , p6_a46
1402 , p6_a47
1403 , p6_a48
1404 , p6_a49
1405 , p6_a50
1406 , p6_a51
1407 , p6_a52
1408 , p6_a53
1409 , p6_a54
1410 , p6_a55
1411 , p6_a56
1412 , p6_a57
1413 );
1414 end;
1415
1416 procedure delete_sys_acct_opts(p_api_version NUMBER
1417 , p_init_msg_list VARCHAR2
1418 , x_return_status out nocopy VARCHAR2
1419 , x_msg_count out nocopy NUMBER
1420 , x_msg_data out nocopy VARCHAR2
1421 , p5_a0 NUMBER := 0-1962.0724
1422 , p5_a1 NUMBER := 0-1962.0724
1423 , p5_a2 NUMBER := 0-1962.0724
1424 , p5_a3 NUMBER := 0-1962.0724
1425 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1426 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1427 , p5_a6 NUMBER := 0-1962.0724
1428 , p5_a7 NUMBER := 0-1962.0724
1429 , p5_a8 NUMBER := 0-1962.0724
1430 , p5_a9 NUMBER := 0-1962.0724
1431 , p5_a10 NUMBER := 0-1962.0724
1432 , p5_a11 NUMBER := 0-1962.0724
1433 , p5_a12 NUMBER := 0-1962.0724
1434 , p5_a13 NUMBER := 0-1962.0724
1435 , p5_a14 NUMBER := 0-1962.0724
1436 , p5_a15 NUMBER := 0-1962.0724
1437 , p5_a16 NUMBER := 0-1962.0724
1438 , p5_a17 NUMBER := 0-1962.0724
1439 , p5_a18 NUMBER := 0-1962.0724
1440 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1441 , p5_a20 NUMBER := 0-1962.0724
1442 , p5_a21 NUMBER := 0-1962.0724
1443 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1444 , p5_a23 NUMBER := 0-1962.0724
1445 , p5_a24 NUMBER := 0-1962.0724
1446 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1447 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1448 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1449 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1450 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1451 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1452 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1453 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1454 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1455 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1456 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1457 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1458 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1459 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1460 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1461 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1462 , p5_a41 NUMBER := 0-1962.0724
1463 , p5_a42 NUMBER := 0-1962.0724
1464 , p5_a43 DATE := fnd_api.g_miss_date
1465 , p5_a44 NUMBER := 0-1962.0724
1466 , p5_a45 DATE := fnd_api.g_miss_date
1467 , p5_a46 NUMBER := 0-1962.0724
1468 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
1469 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
1470 , p5_a49 NUMBER := 0-1962.0724
1471 , p5_a50 NUMBER := 0-1962.0724
1472 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
1473 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
1474 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
1475 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
1476 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
1477 , p5_a56 NUMBER := 0-1962.0724
1478 , p5_a57 VARCHAR2 := fnd_api.g_miss_char
1479 )
1480
1481 as
1482 ddp_saov_rec okl_sys_acct_opts_pub.saov_rec_type;
1483 ddindx binary_integer; indx binary_integer;
1484 begin
1485
1486 -- copy data to the local IN or IN-OUT args, if any
1487
1488
1489
1490
1491
1492 ddp_saov_rec.id := rosetta_g_miss_num_map(p5_a0);
1493 ddp_saov_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1494 ddp_saov_rec.set_of_books_id := rosetta_g_miss_num_map(p5_a2);
1495 ddp_saov_rec.code_combination_id := rosetta_g_miss_num_map(p5_a3);
1496 ddp_saov_rec.cc_rep_currency_code := p5_a4;
1497 ddp_saov_rec.ael_rep_currency_code := p5_a5;
1498 ddp_saov_rec.rec_ccid := rosetta_g_miss_num_map(p5_a6);
1499 ddp_saov_rec.realized_gain_ccid := rosetta_g_miss_num_map(p5_a7);
1500 ddp_saov_rec.realized_loss_ccid := rosetta_g_miss_num_map(p5_a8);
1501 ddp_saov_rec.tax_ccid := rosetta_g_miss_num_map(p5_a9);
1502 ddp_saov_rec.cross_currency_ccid := rosetta_g_miss_num_map(p5_a10);
1503 ddp_saov_rec.rounding_ccid := rosetta_g_miss_num_map(p5_a11);
1504 ddp_saov_rec.ar_clearing_ccid := rosetta_g_miss_num_map(p5_a12);
1505 ddp_saov_rec.payables_ccid := rosetta_g_miss_num_map(p5_a13);
1506 ddp_saov_rec.liablity_ccid := rosetta_g_miss_num_map(p5_a14);
1507 ddp_saov_rec.pre_payment_ccid := rosetta_g_miss_num_map(p5_a15);
1508 ddp_saov_rec.fut_date_pay_ccid := rosetta_g_miss_num_map(p5_a16);
1509 ddp_saov_rec.dis_taken_ccid := rosetta_g_miss_num_map(p5_a17);
1510 ddp_saov_rec.ap_clearing_ccid := rosetta_g_miss_num_map(p5_a18);
1511 ddp_saov_rec.ael_rounding_rule := p5_a19;
1512 ddp_saov_rec.ael_precision := rosetta_g_miss_num_map(p5_a20);
1513 ddp_saov_rec.ael_min_acct_unit := rosetta_g_miss_num_map(p5_a21);
1514 ddp_saov_rec.cc_rounding_rule := p5_a22;
1515 ddp_saov_rec.cc_precision := rosetta_g_miss_num_map(p5_a23);
1516 ddp_saov_rec.cc_min_acct_unit := rosetta_g_miss_num_map(p5_a24);
1517 ddp_saov_rec.attribute_category := p5_a25;
1518 ddp_saov_rec.attribute1 := p5_a26;
1519 ddp_saov_rec.attribute2 := p5_a27;
1520 ddp_saov_rec.attribute3 := p5_a28;
1521 ddp_saov_rec.attribute4 := p5_a29;
1522 ddp_saov_rec.attribute5 := p5_a30;
1523 ddp_saov_rec.attribute6 := p5_a31;
1524 ddp_saov_rec.attribute7 := p5_a32;
1525 ddp_saov_rec.attribute8 := p5_a33;
1526 ddp_saov_rec.attribute9 := p5_a34;
1527 ddp_saov_rec.attribute10 := p5_a35;
1528 ddp_saov_rec.attribute11 := p5_a36;
1529 ddp_saov_rec.attribute12 := p5_a37;
1530 ddp_saov_rec.attribute13 := p5_a38;
1531 ddp_saov_rec.attribute14 := p5_a39;
1532 ddp_saov_rec.attribute15 := p5_a40;
1533 ddp_saov_rec.org_id := rosetta_g_miss_num_map(p5_a41);
1534 ddp_saov_rec.created_by := rosetta_g_miss_num_map(p5_a42);
1535 ddp_saov_rec.creation_date := rosetta_g_miss_date_in_map(p5_a43);
1536 ddp_saov_rec.last_updated_by := rosetta_g_miss_num_map(p5_a44);
1537 ddp_saov_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a45);
1538 ddp_saov_rec.last_update_login := rosetta_g_miss_num_map(p5_a46);
1539 ddp_saov_rec.cc_apply_rounding_difference := p5_a47;
1540 ddp_saov_rec.ael_apply_rounding_difference := p5_a48;
1541 ddp_saov_rec.accrual_reversal_days := rosetta_g_miss_num_map(p5_a49);
1542 ddp_saov_rec.lke_hold_days := rosetta_g_miss_num_map(p5_a50);
1543 ddp_saov_rec.stm_apply_rounding_difference := p5_a51;
1544 ddp_saov_rec.stm_rounding_rule := p5_a52;
1545 ddp_saov_rec.validate_khr_start_date := p5_a53;
1546 ddp_saov_rec.account_derivation := p5_a54;
1547 ddp_saov_rec.isg_arrears_pay_dates_option := p5_a55;
1548 ddp_saov_rec.pay_dist_set_id := rosetta_g_miss_num_map(p5_a56);
1549 ddp_saov_rec.secondary_rep_method := p5_a57;
1550
1551 -- here's the delegated call to the old PL/SQL routine
1552 okl_sys_acct_opts_pub.delete_sys_acct_opts(p_api_version,
1553 p_init_msg_list,
1554 x_return_status,
1555 x_msg_count,
1556 x_msg_data,
1557 ddp_saov_rec);
1558
1559 -- copy data back from the local variables to OUT or IN-OUT args, if any
1560
1561
1562
1563
1564
1565 end;
1566
1567 procedure delete_sys_acct_opts(p_api_version NUMBER
1568 , p_init_msg_list VARCHAR2
1569 , x_return_status out nocopy VARCHAR2
1570 , x_msg_count out nocopy NUMBER
1571 , x_msg_data out nocopy VARCHAR2
1572 , p5_a0 JTF_NUMBER_TABLE
1573 , p5_a1 JTF_NUMBER_TABLE
1574 , p5_a2 JTF_NUMBER_TABLE
1575 , p5_a3 JTF_NUMBER_TABLE
1576 , p5_a4 JTF_VARCHAR2_TABLE_100
1577 , p5_a5 JTF_VARCHAR2_TABLE_100
1578 , p5_a6 JTF_NUMBER_TABLE
1579 , p5_a7 JTF_NUMBER_TABLE
1580 , p5_a8 JTF_NUMBER_TABLE
1581 , p5_a9 JTF_NUMBER_TABLE
1582 , p5_a10 JTF_NUMBER_TABLE
1583 , p5_a11 JTF_NUMBER_TABLE
1584 , p5_a12 JTF_NUMBER_TABLE
1585 , p5_a13 JTF_NUMBER_TABLE
1586 , p5_a14 JTF_NUMBER_TABLE
1587 , p5_a15 JTF_NUMBER_TABLE
1588 , p5_a16 JTF_NUMBER_TABLE
1589 , p5_a17 JTF_NUMBER_TABLE
1590 , p5_a18 JTF_NUMBER_TABLE
1591 , p5_a19 JTF_VARCHAR2_TABLE_100
1592 , p5_a20 JTF_NUMBER_TABLE
1593 , p5_a21 JTF_NUMBER_TABLE
1594 , p5_a22 JTF_VARCHAR2_TABLE_100
1595 , p5_a23 JTF_NUMBER_TABLE
1596 , p5_a24 JTF_NUMBER_TABLE
1597 , p5_a25 JTF_VARCHAR2_TABLE_100
1598 , p5_a26 JTF_VARCHAR2_TABLE_500
1599 , p5_a27 JTF_VARCHAR2_TABLE_500
1600 , p5_a28 JTF_VARCHAR2_TABLE_500
1601 , p5_a29 JTF_VARCHAR2_TABLE_500
1602 , p5_a30 JTF_VARCHAR2_TABLE_500
1603 , p5_a31 JTF_VARCHAR2_TABLE_500
1604 , p5_a32 JTF_VARCHAR2_TABLE_500
1605 , p5_a33 JTF_VARCHAR2_TABLE_500
1606 , p5_a34 JTF_VARCHAR2_TABLE_500
1607 , p5_a35 JTF_VARCHAR2_TABLE_500
1608 , p5_a36 JTF_VARCHAR2_TABLE_500
1609 , p5_a37 JTF_VARCHAR2_TABLE_500
1610 , p5_a38 JTF_VARCHAR2_TABLE_500
1611 , p5_a39 JTF_VARCHAR2_TABLE_500
1612 , p5_a40 JTF_VARCHAR2_TABLE_500
1613 , p5_a41 JTF_NUMBER_TABLE
1614 , p5_a42 JTF_NUMBER_TABLE
1615 , p5_a43 JTF_DATE_TABLE
1616 , p5_a44 JTF_NUMBER_TABLE
1617 , p5_a45 JTF_DATE_TABLE
1618 , p5_a46 JTF_NUMBER_TABLE
1619 , p5_a47 JTF_VARCHAR2_TABLE_100
1620 , p5_a48 JTF_VARCHAR2_TABLE_100
1621 , p5_a49 JTF_NUMBER_TABLE
1622 , p5_a50 JTF_NUMBER_TABLE
1623 , p5_a51 JTF_VARCHAR2_TABLE_100
1624 , p5_a52 JTF_VARCHAR2_TABLE_100
1625 , p5_a53 JTF_VARCHAR2_TABLE_100
1626 , p5_a54 JTF_VARCHAR2_TABLE_100
1627 , p5_a55 JTF_VARCHAR2_TABLE_100
1628 , p5_a56 JTF_NUMBER_TABLE
1629 , p5_a57 JTF_VARCHAR2_TABLE_100
1630 )
1631
1632 as
1633 ddp_saov_tbl okl_sys_acct_opts_pub.saov_tbl_type;
1634 ddindx binary_integer; indx binary_integer;
1635 begin
1636
1637 -- copy data to the local IN or IN-OUT args, if any
1638
1639
1640
1641
1642
1643 okl_sao_pvt_w.rosetta_table_copy_in_p5(ddp_saov_tbl, p5_a0
1644 , p5_a1
1645 , p5_a2
1646 , p5_a3
1647 , p5_a4
1648 , p5_a5
1649 , p5_a6
1650 , p5_a7
1651 , p5_a8
1652 , p5_a9
1653 , p5_a10
1654 , p5_a11
1655 , p5_a12
1656 , p5_a13
1657 , p5_a14
1658 , p5_a15
1659 , p5_a16
1660 , p5_a17
1661 , p5_a18
1662 , p5_a19
1663 , p5_a20
1664 , p5_a21
1665 , p5_a22
1666 , p5_a23
1667 , p5_a24
1668 , p5_a25
1669 , p5_a26
1670 , p5_a27
1671 , p5_a28
1672 , p5_a29
1673 , p5_a30
1674 , p5_a31
1675 , p5_a32
1676 , p5_a33
1677 , p5_a34
1678 , p5_a35
1679 , p5_a36
1680 , p5_a37
1681 , p5_a38
1682 , p5_a39
1683 , p5_a40
1684 , p5_a41
1685 , p5_a42
1686 , p5_a43
1687 , p5_a44
1688 , p5_a45
1689 , p5_a46
1690 , p5_a47
1691 , p5_a48
1692 , p5_a49
1693 , p5_a50
1694 , p5_a51
1695 , p5_a52
1696 , p5_a53
1697 , p5_a54
1698 , p5_a55
1699 , p5_a56
1700 , p5_a57
1701 );
1702
1703 -- here's the delegated call to the old PL/SQL routine
1704 okl_sys_acct_opts_pub.delete_sys_acct_opts(p_api_version,
1705 p_init_msg_list,
1706 x_return_status,
1707 x_msg_count,
1708 x_msg_data,
1709 ddp_saov_tbl);
1710
1711 -- copy data back from the local variables to OUT or IN-OUT args, if any
1712
1713
1714
1715
1716
1717 end;
1718
1719 procedure validate_sys_acct_opts(p_api_version NUMBER
1720 , p_init_msg_list VARCHAR2
1721 , x_return_status out nocopy VARCHAR2
1722 , x_msg_count out nocopy NUMBER
1723 , x_msg_data out nocopy VARCHAR2
1724 , p5_a0 NUMBER := 0-1962.0724
1725 , p5_a1 NUMBER := 0-1962.0724
1726 , p5_a2 NUMBER := 0-1962.0724
1727 , p5_a3 NUMBER := 0-1962.0724
1728 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1729 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1730 , p5_a6 NUMBER := 0-1962.0724
1731 , p5_a7 NUMBER := 0-1962.0724
1732 , p5_a8 NUMBER := 0-1962.0724
1733 , p5_a9 NUMBER := 0-1962.0724
1734 , p5_a10 NUMBER := 0-1962.0724
1735 , p5_a11 NUMBER := 0-1962.0724
1736 , p5_a12 NUMBER := 0-1962.0724
1737 , p5_a13 NUMBER := 0-1962.0724
1738 , p5_a14 NUMBER := 0-1962.0724
1739 , p5_a15 NUMBER := 0-1962.0724
1740 , p5_a16 NUMBER := 0-1962.0724
1741 , p5_a17 NUMBER := 0-1962.0724
1742 , p5_a18 NUMBER := 0-1962.0724
1743 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1744 , p5_a20 NUMBER := 0-1962.0724
1745 , p5_a21 NUMBER := 0-1962.0724
1746 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1747 , p5_a23 NUMBER := 0-1962.0724
1748 , p5_a24 NUMBER := 0-1962.0724
1749 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1750 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1751 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1752 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1753 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1754 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1755 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1756 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1757 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1758 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1759 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1760 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1761 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1762 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1763 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1764 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1765 , p5_a41 NUMBER := 0-1962.0724
1766 , p5_a42 NUMBER := 0-1962.0724
1767 , p5_a43 DATE := fnd_api.g_miss_date
1768 , p5_a44 NUMBER := 0-1962.0724
1769 , p5_a45 DATE := fnd_api.g_miss_date
1770 , p5_a46 NUMBER := 0-1962.0724
1771 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
1772 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
1773 , p5_a49 NUMBER := 0-1962.0724
1774 , p5_a50 NUMBER := 0-1962.0724
1775 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
1776 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
1777 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
1778 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
1779 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
1780 , p5_a56 NUMBER := 0-1962.0724
1781 , p5_a57 VARCHAR2 := fnd_api.g_miss_char
1782 )
1783
1784 as
1785 ddp_saov_rec okl_sys_acct_opts_pub.saov_rec_type;
1786 ddindx binary_integer; indx binary_integer;
1787 begin
1788
1789 -- copy data to the local IN or IN-OUT args, if any
1790
1791
1792
1793
1794
1795 ddp_saov_rec.id := rosetta_g_miss_num_map(p5_a0);
1796 ddp_saov_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1797 ddp_saov_rec.set_of_books_id := rosetta_g_miss_num_map(p5_a2);
1798 ddp_saov_rec.code_combination_id := rosetta_g_miss_num_map(p5_a3);
1799 ddp_saov_rec.cc_rep_currency_code := p5_a4;
1800 ddp_saov_rec.ael_rep_currency_code := p5_a5;
1801 ddp_saov_rec.rec_ccid := rosetta_g_miss_num_map(p5_a6);
1802 ddp_saov_rec.realized_gain_ccid := rosetta_g_miss_num_map(p5_a7);
1803 ddp_saov_rec.realized_loss_ccid := rosetta_g_miss_num_map(p5_a8);
1804 ddp_saov_rec.tax_ccid := rosetta_g_miss_num_map(p5_a9);
1805 ddp_saov_rec.cross_currency_ccid := rosetta_g_miss_num_map(p5_a10);
1806 ddp_saov_rec.rounding_ccid := rosetta_g_miss_num_map(p5_a11);
1807 ddp_saov_rec.ar_clearing_ccid := rosetta_g_miss_num_map(p5_a12);
1808 ddp_saov_rec.payables_ccid := rosetta_g_miss_num_map(p5_a13);
1809 ddp_saov_rec.liablity_ccid := rosetta_g_miss_num_map(p5_a14);
1810 ddp_saov_rec.pre_payment_ccid := rosetta_g_miss_num_map(p5_a15);
1811 ddp_saov_rec.fut_date_pay_ccid := rosetta_g_miss_num_map(p5_a16);
1812 ddp_saov_rec.dis_taken_ccid := rosetta_g_miss_num_map(p5_a17);
1813 ddp_saov_rec.ap_clearing_ccid := rosetta_g_miss_num_map(p5_a18);
1814 ddp_saov_rec.ael_rounding_rule := p5_a19;
1815 ddp_saov_rec.ael_precision := rosetta_g_miss_num_map(p5_a20);
1816 ddp_saov_rec.ael_min_acct_unit := rosetta_g_miss_num_map(p5_a21);
1817 ddp_saov_rec.cc_rounding_rule := p5_a22;
1818 ddp_saov_rec.cc_precision := rosetta_g_miss_num_map(p5_a23);
1819 ddp_saov_rec.cc_min_acct_unit := rosetta_g_miss_num_map(p5_a24);
1820 ddp_saov_rec.attribute_category := p5_a25;
1821 ddp_saov_rec.attribute1 := p5_a26;
1822 ddp_saov_rec.attribute2 := p5_a27;
1823 ddp_saov_rec.attribute3 := p5_a28;
1824 ddp_saov_rec.attribute4 := p5_a29;
1825 ddp_saov_rec.attribute5 := p5_a30;
1826 ddp_saov_rec.attribute6 := p5_a31;
1827 ddp_saov_rec.attribute7 := p5_a32;
1828 ddp_saov_rec.attribute8 := p5_a33;
1829 ddp_saov_rec.attribute9 := p5_a34;
1830 ddp_saov_rec.attribute10 := p5_a35;
1831 ddp_saov_rec.attribute11 := p5_a36;
1832 ddp_saov_rec.attribute12 := p5_a37;
1833 ddp_saov_rec.attribute13 := p5_a38;
1834 ddp_saov_rec.attribute14 := p5_a39;
1835 ddp_saov_rec.attribute15 := p5_a40;
1836 ddp_saov_rec.org_id := rosetta_g_miss_num_map(p5_a41);
1837 ddp_saov_rec.created_by := rosetta_g_miss_num_map(p5_a42);
1838 ddp_saov_rec.creation_date := rosetta_g_miss_date_in_map(p5_a43);
1839 ddp_saov_rec.last_updated_by := rosetta_g_miss_num_map(p5_a44);
1840 ddp_saov_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a45);
1841 ddp_saov_rec.last_update_login := rosetta_g_miss_num_map(p5_a46);
1842 ddp_saov_rec.cc_apply_rounding_difference := p5_a47;
1843 ddp_saov_rec.ael_apply_rounding_difference := p5_a48;
1844 ddp_saov_rec.accrual_reversal_days := rosetta_g_miss_num_map(p5_a49);
1845 ddp_saov_rec.lke_hold_days := rosetta_g_miss_num_map(p5_a50);
1846 ddp_saov_rec.stm_apply_rounding_difference := p5_a51;
1847 ddp_saov_rec.stm_rounding_rule := p5_a52;
1848 ddp_saov_rec.validate_khr_start_date := p5_a53;
1849 ddp_saov_rec.account_derivation := p5_a54;
1850 ddp_saov_rec.isg_arrears_pay_dates_option := p5_a55;
1851 ddp_saov_rec.pay_dist_set_id := rosetta_g_miss_num_map(p5_a56);
1852 ddp_saov_rec.secondary_rep_method := p5_a57;
1853
1854 -- here's the delegated call to the old PL/SQL routine
1855 okl_sys_acct_opts_pub.validate_sys_acct_opts(p_api_version,
1856 p_init_msg_list,
1857 x_return_status,
1858 x_msg_count,
1859 x_msg_data,
1860 ddp_saov_rec);
1861
1862 -- copy data back from the local variables to OUT or IN-OUT args, if any
1863
1864
1865
1866
1867
1868 end;
1869
1870 procedure validate_sys_acct_opts(p_api_version NUMBER
1871 , p_init_msg_list VARCHAR2
1872 , x_return_status out nocopy VARCHAR2
1873 , x_msg_count out nocopy NUMBER
1874 , x_msg_data out nocopy VARCHAR2
1875 , p5_a0 JTF_NUMBER_TABLE
1876 , p5_a1 JTF_NUMBER_TABLE
1877 , p5_a2 JTF_NUMBER_TABLE
1878 , p5_a3 JTF_NUMBER_TABLE
1879 , p5_a4 JTF_VARCHAR2_TABLE_100
1880 , p5_a5 JTF_VARCHAR2_TABLE_100
1881 , p5_a6 JTF_NUMBER_TABLE
1882 , p5_a7 JTF_NUMBER_TABLE
1883 , p5_a8 JTF_NUMBER_TABLE
1884 , p5_a9 JTF_NUMBER_TABLE
1885 , p5_a10 JTF_NUMBER_TABLE
1886 , p5_a11 JTF_NUMBER_TABLE
1887 , p5_a12 JTF_NUMBER_TABLE
1888 , p5_a13 JTF_NUMBER_TABLE
1889 , p5_a14 JTF_NUMBER_TABLE
1890 , p5_a15 JTF_NUMBER_TABLE
1891 , p5_a16 JTF_NUMBER_TABLE
1892 , p5_a17 JTF_NUMBER_TABLE
1893 , p5_a18 JTF_NUMBER_TABLE
1894 , p5_a19 JTF_VARCHAR2_TABLE_100
1895 , p5_a20 JTF_NUMBER_TABLE
1896 , p5_a21 JTF_NUMBER_TABLE
1897 , p5_a22 JTF_VARCHAR2_TABLE_100
1898 , p5_a23 JTF_NUMBER_TABLE
1899 , p5_a24 JTF_NUMBER_TABLE
1900 , p5_a25 JTF_VARCHAR2_TABLE_100
1901 , p5_a26 JTF_VARCHAR2_TABLE_500
1902 , p5_a27 JTF_VARCHAR2_TABLE_500
1903 , p5_a28 JTF_VARCHAR2_TABLE_500
1904 , p5_a29 JTF_VARCHAR2_TABLE_500
1905 , p5_a30 JTF_VARCHAR2_TABLE_500
1906 , p5_a31 JTF_VARCHAR2_TABLE_500
1907 , p5_a32 JTF_VARCHAR2_TABLE_500
1908 , p5_a33 JTF_VARCHAR2_TABLE_500
1909 , p5_a34 JTF_VARCHAR2_TABLE_500
1910 , p5_a35 JTF_VARCHAR2_TABLE_500
1911 , p5_a36 JTF_VARCHAR2_TABLE_500
1912 , p5_a37 JTF_VARCHAR2_TABLE_500
1913 , p5_a38 JTF_VARCHAR2_TABLE_500
1914 , p5_a39 JTF_VARCHAR2_TABLE_500
1915 , p5_a40 JTF_VARCHAR2_TABLE_500
1916 , p5_a41 JTF_NUMBER_TABLE
1917 , p5_a42 JTF_NUMBER_TABLE
1918 , p5_a43 JTF_DATE_TABLE
1919 , p5_a44 JTF_NUMBER_TABLE
1920 , p5_a45 JTF_DATE_TABLE
1921 , p5_a46 JTF_NUMBER_TABLE
1922 , p5_a47 JTF_VARCHAR2_TABLE_100
1923 , p5_a48 JTF_VARCHAR2_TABLE_100
1924 , p5_a49 JTF_NUMBER_TABLE
1925 , p5_a50 JTF_NUMBER_TABLE
1926 , p5_a51 JTF_VARCHAR2_TABLE_100
1927 , p5_a52 JTF_VARCHAR2_TABLE_100
1928 , p5_a53 JTF_VARCHAR2_TABLE_100
1929 , p5_a54 JTF_VARCHAR2_TABLE_100
1930 , p5_a55 JTF_VARCHAR2_TABLE_100
1931 , p5_a56 JTF_NUMBER_TABLE
1932 , p5_a57 JTF_VARCHAR2_TABLE_100
1933 )
1934
1935 as
1936 ddp_saov_tbl okl_sys_acct_opts_pub.saov_tbl_type;
1937 ddindx binary_integer; indx binary_integer;
1938 begin
1939
1940 -- copy data to the local IN or IN-OUT args, if any
1941
1942
1943
1944
1945
1946 okl_sao_pvt_w.rosetta_table_copy_in_p5(ddp_saov_tbl, p5_a0
1947 , p5_a1
1948 , p5_a2
1949 , p5_a3
1950 , p5_a4
1951 , p5_a5
1952 , p5_a6
1953 , p5_a7
1954 , p5_a8
1955 , p5_a9
1956 , p5_a10
1957 , p5_a11
1958 , p5_a12
1959 , p5_a13
1960 , p5_a14
1961 , p5_a15
1962 , p5_a16
1963 , p5_a17
1964 , p5_a18
1965 , p5_a19
1966 , p5_a20
1967 , p5_a21
1968 , p5_a22
1969 , p5_a23
1970 , p5_a24
1971 , p5_a25
1972 , p5_a26
1973 , p5_a27
1974 , p5_a28
1975 , p5_a29
1976 , p5_a30
1977 , p5_a31
1978 , p5_a32
1979 , p5_a33
1980 , p5_a34
1981 , p5_a35
1982 , p5_a36
1983 , p5_a37
1984 , p5_a38
1985 , p5_a39
1986 , p5_a40
1987 , p5_a41
1988 , p5_a42
1989 , p5_a43
1990 , p5_a44
1991 , p5_a45
1992 , p5_a46
1993 , p5_a47
1994 , p5_a48
1995 , p5_a49
1996 , p5_a50
1997 , p5_a51
1998 , p5_a52
1999 , p5_a53
2000 , p5_a54
2001 , p5_a55
2002 , p5_a56
2003 , p5_a57
2004 );
2005
2006 -- here's the delegated call to the old PL/SQL routine
2007 okl_sys_acct_opts_pub.validate_sys_acct_opts(p_api_version,
2008 p_init_msg_list,
2009 x_return_status,
2010 x_msg_count,
2011 x_msg_data,
2012 ddp_saov_tbl);
2013
2014 -- copy data back from the local variables to OUT or IN-OUT args, if any
2015
2016
2017
2018
2019
2020 end;
2021
2022 end okl_sys_acct_opts_pub_w;