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