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