[Home] [Help]
PACKAGE BODY: APPS.OKL_PROCESS_TMPT_SET_PUB_W
Source
1 package body okl_process_tmpt_set_pub_w as
2 /* $Header: OKLUTMSB.pls 120.2 2005/10/30 03:52:18 appldev noship $ */
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
6 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7 function rosetta_g_miss_date_in_map(d date) return date as
8 begin
9 if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10 return d;
11 end;
12
13 function rosetta_g_miss_num_map(n number) return number as
14 a number := fnd_api.g_miss_num;
15 b number := 0-1962.0724;
16 begin
17 if n=a then return b; end if;
18 if n=b then return a; end if;
19 return n;
20 end;
21
22 procedure create_tmpt_set(p_api_version NUMBER
23 , p_init_msg_list VARCHAR2
24 , x_return_status out nocopy VARCHAR2
25 , x_msg_count out nocopy NUMBER
26 , x_msg_data out nocopy VARCHAR2
27 , p6_a0 JTF_NUMBER_TABLE
28 , p6_a1 JTF_NUMBER_TABLE
29 , p6_a2 JTF_NUMBER_TABLE
30 , p6_a3 JTF_NUMBER_TABLE
31 , p6_a4 JTF_NUMBER_TABLE
32 , p6_a5 JTF_NUMBER_TABLE
33 , p6_a6 JTF_NUMBER_TABLE
34 , p6_a7 JTF_VARCHAR2_TABLE_100
35 , p6_a8 JTF_VARCHAR2_TABLE_100
36 , p6_a9 JTF_VARCHAR2_TABLE_100
37 , p6_a10 JTF_VARCHAR2_TABLE_100
38 , p6_a11 JTF_VARCHAR2_TABLE_100
39 , p6_a12 JTF_VARCHAR2_TABLE_100
40 , p6_a13 JTF_VARCHAR2_TABLE_200
41 , p6_a14 JTF_VARCHAR2_TABLE_2000
42 , p6_a15 JTF_VARCHAR2_TABLE_100
43 , p6_a16 JTF_VARCHAR2_TABLE_100
44 , p6_a17 JTF_DATE_TABLE
45 , p6_a18 JTF_DATE_TABLE
46 , p6_a19 JTF_VARCHAR2_TABLE_100
47 , p6_a20 JTF_VARCHAR2_TABLE_100
48 , p6_a21 JTF_VARCHAR2_TABLE_500
49 , p6_a22 JTF_VARCHAR2_TABLE_500
50 , p6_a23 JTF_VARCHAR2_TABLE_500
51 , p6_a24 JTF_VARCHAR2_TABLE_500
52 , p6_a25 JTF_VARCHAR2_TABLE_500
53 , p6_a26 JTF_VARCHAR2_TABLE_500
54 , p6_a27 JTF_VARCHAR2_TABLE_500
55 , p6_a28 JTF_VARCHAR2_TABLE_500
56 , p6_a29 JTF_VARCHAR2_TABLE_500
57 , p6_a30 JTF_VARCHAR2_TABLE_500
58 , p6_a31 JTF_VARCHAR2_TABLE_500
59 , p6_a32 JTF_VARCHAR2_TABLE_500
60 , p6_a33 JTF_VARCHAR2_TABLE_500
61 , p6_a34 JTF_VARCHAR2_TABLE_500
62 , p6_a35 JTF_VARCHAR2_TABLE_500
63 , p6_a36 JTF_NUMBER_TABLE
64 , p6_a37 JTF_NUMBER_TABLE
65 , p6_a38 JTF_DATE_TABLE
66 , p6_a39 JTF_NUMBER_TABLE
67 , p6_a40 JTF_DATE_TABLE
68 , p6_a41 JTF_NUMBER_TABLE
69 , p6_a42 JTF_VARCHAR2_TABLE_100
70 , p7_a0 JTF_NUMBER_TABLE
71 , p7_a1 JTF_NUMBER_TABLE
72 , p7_a2 JTF_NUMBER_TABLE
73 , p7_a3 JTF_VARCHAR2_TABLE_100
74 , p7_a4 JTF_NUMBER_TABLE
75 , p7_a5 JTF_VARCHAR2_TABLE_100
76 , p7_a6 JTF_NUMBER_TABLE
77 , p7_a7 JTF_VARCHAR2_TABLE_2000
78 , p7_a8 JTF_NUMBER_TABLE
79 , p7_a9 JTF_VARCHAR2_TABLE_100
80 , p7_a10 JTF_VARCHAR2_TABLE_100
81 , p7_a11 JTF_VARCHAR2_TABLE_500
82 , p7_a12 JTF_VARCHAR2_TABLE_500
83 , p7_a13 JTF_VARCHAR2_TABLE_500
84 , p7_a14 JTF_VARCHAR2_TABLE_500
85 , p7_a15 JTF_VARCHAR2_TABLE_500
86 , p7_a16 JTF_VARCHAR2_TABLE_500
87 , p7_a17 JTF_VARCHAR2_TABLE_500
88 , p7_a18 JTF_VARCHAR2_TABLE_500
89 , p7_a19 JTF_VARCHAR2_TABLE_500
90 , p7_a20 JTF_VARCHAR2_TABLE_500
91 , p7_a21 JTF_VARCHAR2_TABLE_500
92 , p7_a22 JTF_VARCHAR2_TABLE_500
93 , p7_a23 JTF_VARCHAR2_TABLE_500
94 , p7_a24 JTF_VARCHAR2_TABLE_500
95 , p7_a25 JTF_VARCHAR2_TABLE_500
96 , p7_a26 JTF_NUMBER_TABLE
97 , p7_a27 JTF_NUMBER_TABLE
98 , p7_a28 JTF_NUMBER_TABLE
99 , p7_a29 JTF_DATE_TABLE
100 , p7_a30 JTF_NUMBER_TABLE
101 , p7_a31 JTF_DATE_TABLE
102 , p7_a32 JTF_NUMBER_TABLE
103 , p8_a0 out nocopy NUMBER
104 , p8_a1 out nocopy NUMBER
105 , p8_a2 out nocopy VARCHAR2
106 , p8_a3 out nocopy VARCHAR2
107 , p8_a4 out nocopy VARCHAR2
108 , p8_a5 out nocopy DATE
109 , p8_a6 out nocopy DATE
110 , p8_a7 out nocopy NUMBER
111 , p8_a8 out nocopy NUMBER
112 , p8_a9 out nocopy DATE
113 , p8_a10 out nocopy NUMBER
114 , p8_a11 out nocopy DATE
115 , p8_a12 out nocopy NUMBER
116 , p8_a13 out nocopy NUMBER
117 , p9_a0 out nocopy JTF_NUMBER_TABLE
118 , p9_a1 out nocopy JTF_NUMBER_TABLE
119 , p9_a2 out nocopy JTF_NUMBER_TABLE
120 , p9_a3 out nocopy JTF_NUMBER_TABLE
121 , p9_a4 out nocopy JTF_NUMBER_TABLE
122 , p9_a5 out nocopy JTF_NUMBER_TABLE
123 , p9_a6 out nocopy JTF_NUMBER_TABLE
124 , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
125 , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
126 , p9_a9 out nocopy JTF_VARCHAR2_TABLE_100
127 , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
128 , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
129 , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
130 , p9_a13 out nocopy JTF_VARCHAR2_TABLE_200
131 , p9_a14 out nocopy JTF_VARCHAR2_TABLE_2000
132 , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100
133 , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100
134 , p9_a17 out nocopy JTF_DATE_TABLE
135 , p9_a18 out nocopy JTF_DATE_TABLE
136 , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100
137 , p9_a20 out nocopy JTF_VARCHAR2_TABLE_100
138 , p9_a21 out nocopy JTF_VARCHAR2_TABLE_500
139 , p9_a22 out nocopy JTF_VARCHAR2_TABLE_500
140 , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
141 , p9_a24 out nocopy JTF_VARCHAR2_TABLE_500
142 , p9_a25 out nocopy JTF_VARCHAR2_TABLE_500
143 , p9_a26 out nocopy JTF_VARCHAR2_TABLE_500
144 , p9_a27 out nocopy JTF_VARCHAR2_TABLE_500
145 , p9_a28 out nocopy JTF_VARCHAR2_TABLE_500
146 , p9_a29 out nocopy JTF_VARCHAR2_TABLE_500
147 , p9_a30 out nocopy JTF_VARCHAR2_TABLE_500
148 , p9_a31 out nocopy JTF_VARCHAR2_TABLE_500
149 , p9_a32 out nocopy JTF_VARCHAR2_TABLE_500
150 , p9_a33 out nocopy JTF_VARCHAR2_TABLE_500
151 , p9_a34 out nocopy JTF_VARCHAR2_TABLE_500
152 , p9_a35 out nocopy JTF_VARCHAR2_TABLE_500
153 , p9_a36 out nocopy JTF_NUMBER_TABLE
154 , p9_a37 out nocopy JTF_NUMBER_TABLE
155 , p9_a38 out nocopy JTF_DATE_TABLE
156 , p9_a39 out nocopy JTF_NUMBER_TABLE
157 , p9_a40 out nocopy JTF_DATE_TABLE
158 , p9_a41 out nocopy JTF_NUMBER_TABLE
159 , p9_a42 out nocopy JTF_VARCHAR2_TABLE_100
160 , p10_a0 out nocopy JTF_NUMBER_TABLE
161 , p10_a1 out nocopy JTF_NUMBER_TABLE
162 , p10_a2 out nocopy JTF_NUMBER_TABLE
163 , p10_a3 out nocopy JTF_VARCHAR2_TABLE_100
164 , p10_a4 out nocopy JTF_NUMBER_TABLE
165 , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
166 , p10_a6 out nocopy JTF_NUMBER_TABLE
167 , p10_a7 out nocopy JTF_VARCHAR2_TABLE_2000
168 , p10_a8 out nocopy JTF_NUMBER_TABLE
169 , p10_a9 out nocopy JTF_VARCHAR2_TABLE_100
170 , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
171 , p10_a11 out nocopy JTF_VARCHAR2_TABLE_500
172 , p10_a12 out nocopy JTF_VARCHAR2_TABLE_500
173 , p10_a13 out nocopy JTF_VARCHAR2_TABLE_500
174 , p10_a14 out nocopy JTF_VARCHAR2_TABLE_500
175 , p10_a15 out nocopy JTF_VARCHAR2_TABLE_500
176 , p10_a16 out nocopy JTF_VARCHAR2_TABLE_500
177 , p10_a17 out nocopy JTF_VARCHAR2_TABLE_500
178 , p10_a18 out nocopy JTF_VARCHAR2_TABLE_500
179 , p10_a19 out nocopy JTF_VARCHAR2_TABLE_500
180 , p10_a20 out nocopy JTF_VARCHAR2_TABLE_500
181 , p10_a21 out nocopy JTF_VARCHAR2_TABLE_500
182 , p10_a22 out nocopy JTF_VARCHAR2_TABLE_500
183 , p10_a23 out nocopy JTF_VARCHAR2_TABLE_500
184 , p10_a24 out nocopy JTF_VARCHAR2_TABLE_500
185 , p10_a25 out nocopy JTF_VARCHAR2_TABLE_500
186 , p10_a26 out nocopy JTF_NUMBER_TABLE
187 , p10_a27 out nocopy JTF_NUMBER_TABLE
188 , p10_a28 out nocopy JTF_NUMBER_TABLE
189 , p10_a29 out nocopy JTF_DATE_TABLE
190 , p10_a30 out nocopy JTF_NUMBER_TABLE
191 , p10_a31 out nocopy JTF_DATE_TABLE
192 , p10_a32 out nocopy JTF_NUMBER_TABLE
193 , p5_a0 NUMBER := 0-1962.0724
194 , p5_a1 NUMBER := 0-1962.0724
195 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
196 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
197 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
198 , p5_a5 DATE := fnd_api.g_miss_date
199 , p5_a6 DATE := fnd_api.g_miss_date
200 , p5_a7 NUMBER := 0-1962.0724
201 , p5_a8 NUMBER := 0-1962.0724
202 , p5_a9 DATE := fnd_api.g_miss_date
203 , p5_a10 NUMBER := 0-1962.0724
204 , p5_a11 DATE := fnd_api.g_miss_date
205 , p5_a12 NUMBER := 0-1962.0724
206 , p5_a13 NUMBER := 0-1962.0724
207 )
208
209 as
210 ddp_aesv_rec okl_process_tmpt_set_pub.aesv_rec_type;
211 ddp_avlv_tbl okl_process_tmpt_set_pub.avlv_tbl_type;
212 ddp_atlv_tbl okl_process_tmpt_set_pub.atlv_tbl_type;
213 ddx_aesv_rec okl_process_tmpt_set_pub.aesv_rec_type;
214 ddx_avlv_tbl okl_process_tmpt_set_pub.avlv_tbl_type;
215 ddx_atlv_tbl okl_process_tmpt_set_pub.atlv_tbl_type;
216 ddindx binary_integer; indx binary_integer;
217 begin
218
219 -- copy data to the local IN or IN-OUT args, if any
220
221
222
223
224
225 ddp_aesv_rec.id := rosetta_g_miss_num_map(p5_a0);
226 ddp_aesv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
227 ddp_aesv_rec.name := p5_a2;
228 ddp_aesv_rec.description := p5_a3;
229 ddp_aesv_rec.version := p5_a4;
230 ddp_aesv_rec.start_date := rosetta_g_miss_date_in_map(p5_a5);
231 ddp_aesv_rec.end_date := rosetta_g_miss_date_in_map(p5_a6);
232 ddp_aesv_rec.org_id := rosetta_g_miss_num_map(p5_a7);
233 ddp_aesv_rec.created_by := rosetta_g_miss_num_map(p5_a8);
234 ddp_aesv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a9);
235 ddp_aesv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a10);
236 ddp_aesv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a11);
237 ddp_aesv_rec.last_update_login := rosetta_g_miss_num_map(p5_a12);
238 ddp_aesv_rec.gts_id := rosetta_g_miss_num_map(p5_a13);
239
240 okl_avl_pvt_w.rosetta_table_copy_in_p5(ddp_avlv_tbl, p6_a0
241 , p6_a1
242 , p6_a2
243 , p6_a3
244 , p6_a4
245 , p6_a5
246 , p6_a6
247 , p6_a7
248 , p6_a8
249 , p6_a9
250 , p6_a10
251 , p6_a11
252 , p6_a12
253 , p6_a13
254 , p6_a14
255 , p6_a15
256 , p6_a16
257 , p6_a17
258 , p6_a18
259 , p6_a19
260 , p6_a20
261 , p6_a21
262 , p6_a22
263 , p6_a23
264 , p6_a24
265 , p6_a25
266 , p6_a26
267 , p6_a27
268 , p6_a28
269 , p6_a29
270 , p6_a30
271 , p6_a31
272 , p6_a32
273 , p6_a33
274 , p6_a34
275 , p6_a35
276 , p6_a36
277 , p6_a37
278 , p6_a38
279 , p6_a39
280 , p6_a40
281 , p6_a41
282 , p6_a42
283 );
284
285 okl_atl_pvt_w.rosetta_table_copy_in_p5(ddp_atlv_tbl, p7_a0
286 , p7_a1
287 , p7_a2
288 , p7_a3
289 , p7_a4
290 , p7_a5
291 , p7_a6
292 , p7_a7
293 , p7_a8
294 , p7_a9
295 , p7_a10
296 , p7_a11
297 , p7_a12
298 , p7_a13
299 , p7_a14
300 , p7_a15
301 , p7_a16
302 , p7_a17
303 , p7_a18
304 , p7_a19
305 , p7_a20
306 , p7_a21
307 , p7_a22
308 , p7_a23
309 , p7_a24
310 , p7_a25
311 , p7_a26
312 , p7_a27
313 , p7_a28
314 , p7_a29
315 , p7_a30
316 , p7_a31
317 , p7_a32
318 );
319
320
321
322
323 -- here's the delegated call to the old PL/SQL routine
324 okl_process_tmpt_set_pub.create_tmpt_set(p_api_version,
325 p_init_msg_list,
326 x_return_status,
327 x_msg_count,
328 x_msg_data,
329 ddp_aesv_rec,
330 ddp_avlv_tbl,
331 ddp_atlv_tbl,
332 ddx_aesv_rec,
333 ddx_avlv_tbl,
334 ddx_atlv_tbl);
335
336 -- copy data back from the local variables to OUT or IN-OUT args, if any
337
338
339
340
341
342
343
344
345 p8_a0 := rosetta_g_miss_num_map(ddx_aesv_rec.id);
346 p8_a1 := rosetta_g_miss_num_map(ddx_aesv_rec.object_version_number);
347 p8_a2 := ddx_aesv_rec.name;
348 p8_a3 := ddx_aesv_rec.description;
349 p8_a4 := ddx_aesv_rec.version;
350 p8_a5 := ddx_aesv_rec.start_date;
351 p8_a6 := ddx_aesv_rec.end_date;
352 p8_a7 := rosetta_g_miss_num_map(ddx_aesv_rec.org_id);
353 p8_a8 := rosetta_g_miss_num_map(ddx_aesv_rec.created_by);
354 p8_a9 := ddx_aesv_rec.creation_date;
355 p8_a10 := rosetta_g_miss_num_map(ddx_aesv_rec.last_updated_by);
356 p8_a11 := ddx_aesv_rec.last_update_date;
357 p8_a12 := rosetta_g_miss_num_map(ddx_aesv_rec.last_update_login);
358 p8_a13 := rosetta_g_miss_num_map(ddx_aesv_rec.gts_id);
359
360 okl_avl_pvt_w.rosetta_table_copy_out_p5(ddx_avlv_tbl, p9_a0
361 , p9_a1
362 , p9_a2
363 , p9_a3
364 , p9_a4
365 , p9_a5
366 , p9_a6
367 , p9_a7
368 , p9_a8
369 , p9_a9
370 , p9_a10
371 , p9_a11
372 , p9_a12
373 , p9_a13
374 , p9_a14
375 , p9_a15
376 , p9_a16
377 , p9_a17
378 , p9_a18
379 , p9_a19
380 , p9_a20
381 , p9_a21
382 , p9_a22
383 , p9_a23
384 , p9_a24
385 , p9_a25
386 , p9_a26
387 , p9_a27
388 , p9_a28
389 , p9_a29
390 , p9_a30
391 , p9_a31
392 , p9_a32
393 , p9_a33
394 , p9_a34
395 , p9_a35
396 , p9_a36
397 , p9_a37
398 , p9_a38
399 , p9_a39
400 , p9_a40
401 , p9_a41
402 , p9_a42
403 );
404
405 okl_atl_pvt_w.rosetta_table_copy_out_p5(ddx_atlv_tbl, p10_a0
406 , p10_a1
407 , p10_a2
408 , p10_a3
409 , p10_a4
410 , p10_a5
411 , p10_a6
412 , p10_a7
413 , p10_a8
414 , p10_a9
415 , p10_a10
416 , p10_a11
417 , p10_a12
418 , p10_a13
419 , p10_a14
420 , p10_a15
421 , p10_a16
422 , p10_a17
423 , p10_a18
424 , p10_a19
425 , p10_a20
426 , p10_a21
427 , p10_a22
428 , p10_a23
429 , p10_a24
430 , p10_a25
431 , p10_a26
432 , p10_a27
433 , p10_a28
434 , p10_a29
435 , p10_a30
436 , p10_a31
437 , p10_a32
438 );
439 end;
440
441 procedure update_tmpt_set(p_api_version NUMBER
442 , p_init_msg_list VARCHAR2
443 , x_return_status out nocopy VARCHAR2
444 , x_msg_count out nocopy NUMBER
445 , x_msg_data out nocopy VARCHAR2
446 , p6_a0 JTF_NUMBER_TABLE
447 , p6_a1 JTF_NUMBER_TABLE
448 , p6_a2 JTF_NUMBER_TABLE
449 , p6_a3 JTF_NUMBER_TABLE
450 , p6_a4 JTF_NUMBER_TABLE
451 , p6_a5 JTF_NUMBER_TABLE
452 , p6_a6 JTF_NUMBER_TABLE
453 , p6_a7 JTF_VARCHAR2_TABLE_100
454 , p6_a8 JTF_VARCHAR2_TABLE_100
455 , p6_a9 JTF_VARCHAR2_TABLE_100
456 , p6_a10 JTF_VARCHAR2_TABLE_100
457 , p6_a11 JTF_VARCHAR2_TABLE_100
458 , p6_a12 JTF_VARCHAR2_TABLE_100
459 , p6_a13 JTF_VARCHAR2_TABLE_200
460 , p6_a14 JTF_VARCHAR2_TABLE_2000
461 , p6_a15 JTF_VARCHAR2_TABLE_100
462 , p6_a16 JTF_VARCHAR2_TABLE_100
463 , p6_a17 JTF_DATE_TABLE
464 , p6_a18 JTF_DATE_TABLE
465 , p6_a19 JTF_VARCHAR2_TABLE_100
466 , p6_a20 JTF_VARCHAR2_TABLE_100
467 , p6_a21 JTF_VARCHAR2_TABLE_500
468 , p6_a22 JTF_VARCHAR2_TABLE_500
469 , p6_a23 JTF_VARCHAR2_TABLE_500
470 , p6_a24 JTF_VARCHAR2_TABLE_500
471 , p6_a25 JTF_VARCHAR2_TABLE_500
472 , p6_a26 JTF_VARCHAR2_TABLE_500
473 , p6_a27 JTF_VARCHAR2_TABLE_500
474 , p6_a28 JTF_VARCHAR2_TABLE_500
475 , p6_a29 JTF_VARCHAR2_TABLE_500
476 , p6_a30 JTF_VARCHAR2_TABLE_500
477 , p6_a31 JTF_VARCHAR2_TABLE_500
478 , p6_a32 JTF_VARCHAR2_TABLE_500
479 , p6_a33 JTF_VARCHAR2_TABLE_500
480 , p6_a34 JTF_VARCHAR2_TABLE_500
481 , p6_a35 JTF_VARCHAR2_TABLE_500
482 , p6_a36 JTF_NUMBER_TABLE
483 , p6_a37 JTF_NUMBER_TABLE
484 , p6_a38 JTF_DATE_TABLE
485 , p6_a39 JTF_NUMBER_TABLE
486 , p6_a40 JTF_DATE_TABLE
487 , p6_a41 JTF_NUMBER_TABLE
488 , p6_a42 JTF_VARCHAR2_TABLE_100
489 , p7_a0 JTF_NUMBER_TABLE
490 , p7_a1 JTF_NUMBER_TABLE
491 , p7_a2 JTF_NUMBER_TABLE
492 , p7_a3 JTF_VARCHAR2_TABLE_100
493 , p7_a4 JTF_NUMBER_TABLE
494 , p7_a5 JTF_VARCHAR2_TABLE_100
495 , p7_a6 JTF_NUMBER_TABLE
496 , p7_a7 JTF_VARCHAR2_TABLE_2000
497 , p7_a8 JTF_NUMBER_TABLE
498 , p7_a9 JTF_VARCHAR2_TABLE_100
499 , p7_a10 JTF_VARCHAR2_TABLE_100
500 , p7_a11 JTF_VARCHAR2_TABLE_500
501 , p7_a12 JTF_VARCHAR2_TABLE_500
502 , p7_a13 JTF_VARCHAR2_TABLE_500
503 , p7_a14 JTF_VARCHAR2_TABLE_500
504 , p7_a15 JTF_VARCHAR2_TABLE_500
505 , p7_a16 JTF_VARCHAR2_TABLE_500
506 , p7_a17 JTF_VARCHAR2_TABLE_500
507 , p7_a18 JTF_VARCHAR2_TABLE_500
508 , p7_a19 JTF_VARCHAR2_TABLE_500
509 , p7_a20 JTF_VARCHAR2_TABLE_500
510 , p7_a21 JTF_VARCHAR2_TABLE_500
511 , p7_a22 JTF_VARCHAR2_TABLE_500
512 , p7_a23 JTF_VARCHAR2_TABLE_500
513 , p7_a24 JTF_VARCHAR2_TABLE_500
514 , p7_a25 JTF_VARCHAR2_TABLE_500
515 , p7_a26 JTF_NUMBER_TABLE
516 , p7_a27 JTF_NUMBER_TABLE
517 , p7_a28 JTF_NUMBER_TABLE
518 , p7_a29 JTF_DATE_TABLE
519 , p7_a30 JTF_NUMBER_TABLE
520 , p7_a31 JTF_DATE_TABLE
521 , p7_a32 JTF_NUMBER_TABLE
522 , p8_a0 out nocopy NUMBER
523 , p8_a1 out nocopy NUMBER
524 , p8_a2 out nocopy VARCHAR2
525 , p8_a3 out nocopy VARCHAR2
526 , p8_a4 out nocopy VARCHAR2
527 , p8_a5 out nocopy DATE
528 , p8_a6 out nocopy DATE
529 , p8_a7 out nocopy NUMBER
530 , p8_a8 out nocopy NUMBER
531 , p8_a9 out nocopy DATE
532 , p8_a10 out nocopy NUMBER
533 , p8_a11 out nocopy DATE
534 , p8_a12 out nocopy NUMBER
535 , p8_a13 out nocopy NUMBER
536 , p9_a0 out nocopy JTF_NUMBER_TABLE
537 , p9_a1 out nocopy JTF_NUMBER_TABLE
538 , p9_a2 out nocopy JTF_NUMBER_TABLE
539 , p9_a3 out nocopy JTF_NUMBER_TABLE
540 , p9_a4 out nocopy JTF_NUMBER_TABLE
541 , p9_a5 out nocopy JTF_NUMBER_TABLE
542 , p9_a6 out nocopy JTF_NUMBER_TABLE
543 , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
544 , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
545 , p9_a9 out nocopy JTF_VARCHAR2_TABLE_100
546 , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
547 , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
548 , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
549 , p9_a13 out nocopy JTF_VARCHAR2_TABLE_200
550 , p9_a14 out nocopy JTF_VARCHAR2_TABLE_2000
551 , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100
552 , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100
553 , p9_a17 out nocopy JTF_DATE_TABLE
554 , p9_a18 out nocopy JTF_DATE_TABLE
555 , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100
556 , p9_a20 out nocopy JTF_VARCHAR2_TABLE_100
557 , p9_a21 out nocopy JTF_VARCHAR2_TABLE_500
558 , p9_a22 out nocopy JTF_VARCHAR2_TABLE_500
559 , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
560 , p9_a24 out nocopy JTF_VARCHAR2_TABLE_500
561 , p9_a25 out nocopy JTF_VARCHAR2_TABLE_500
562 , p9_a26 out nocopy JTF_VARCHAR2_TABLE_500
563 , p9_a27 out nocopy JTF_VARCHAR2_TABLE_500
564 , p9_a28 out nocopy JTF_VARCHAR2_TABLE_500
565 , p9_a29 out nocopy JTF_VARCHAR2_TABLE_500
566 , p9_a30 out nocopy JTF_VARCHAR2_TABLE_500
567 , p9_a31 out nocopy JTF_VARCHAR2_TABLE_500
568 , p9_a32 out nocopy JTF_VARCHAR2_TABLE_500
569 , p9_a33 out nocopy JTF_VARCHAR2_TABLE_500
570 , p9_a34 out nocopy JTF_VARCHAR2_TABLE_500
571 , p9_a35 out nocopy JTF_VARCHAR2_TABLE_500
572 , p9_a36 out nocopy JTF_NUMBER_TABLE
573 , p9_a37 out nocopy JTF_NUMBER_TABLE
574 , p9_a38 out nocopy JTF_DATE_TABLE
575 , p9_a39 out nocopy JTF_NUMBER_TABLE
576 , p9_a40 out nocopy JTF_DATE_TABLE
577 , p9_a41 out nocopy JTF_NUMBER_TABLE
578 , p9_a42 out nocopy JTF_VARCHAR2_TABLE_100
579 , p10_a0 out nocopy JTF_NUMBER_TABLE
580 , p10_a1 out nocopy JTF_NUMBER_TABLE
581 , p10_a2 out nocopy JTF_NUMBER_TABLE
582 , p10_a3 out nocopy JTF_VARCHAR2_TABLE_100
583 , p10_a4 out nocopy JTF_NUMBER_TABLE
584 , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
585 , p10_a6 out nocopy JTF_NUMBER_TABLE
586 , p10_a7 out nocopy JTF_VARCHAR2_TABLE_2000
587 , p10_a8 out nocopy JTF_NUMBER_TABLE
588 , p10_a9 out nocopy JTF_VARCHAR2_TABLE_100
589 , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
590 , p10_a11 out nocopy JTF_VARCHAR2_TABLE_500
591 , p10_a12 out nocopy JTF_VARCHAR2_TABLE_500
592 , p10_a13 out nocopy JTF_VARCHAR2_TABLE_500
593 , p10_a14 out nocopy JTF_VARCHAR2_TABLE_500
594 , p10_a15 out nocopy JTF_VARCHAR2_TABLE_500
595 , p10_a16 out nocopy JTF_VARCHAR2_TABLE_500
596 , p10_a17 out nocopy JTF_VARCHAR2_TABLE_500
597 , p10_a18 out nocopy JTF_VARCHAR2_TABLE_500
598 , p10_a19 out nocopy JTF_VARCHAR2_TABLE_500
599 , p10_a20 out nocopy JTF_VARCHAR2_TABLE_500
600 , p10_a21 out nocopy JTF_VARCHAR2_TABLE_500
601 , p10_a22 out nocopy JTF_VARCHAR2_TABLE_500
602 , p10_a23 out nocopy JTF_VARCHAR2_TABLE_500
603 , p10_a24 out nocopy JTF_VARCHAR2_TABLE_500
604 , p10_a25 out nocopy JTF_VARCHAR2_TABLE_500
605 , p10_a26 out nocopy JTF_NUMBER_TABLE
606 , p10_a27 out nocopy JTF_NUMBER_TABLE
607 , p10_a28 out nocopy JTF_NUMBER_TABLE
608 , p10_a29 out nocopy JTF_DATE_TABLE
609 , p10_a30 out nocopy JTF_NUMBER_TABLE
610 , p10_a31 out nocopy JTF_DATE_TABLE
611 , p10_a32 out nocopy JTF_NUMBER_TABLE
612 , p5_a0 NUMBER := 0-1962.0724
613 , p5_a1 NUMBER := 0-1962.0724
614 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
615 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
616 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
617 , p5_a5 DATE := fnd_api.g_miss_date
618 , p5_a6 DATE := fnd_api.g_miss_date
619 , p5_a7 NUMBER := 0-1962.0724
620 , p5_a8 NUMBER := 0-1962.0724
621 , p5_a9 DATE := fnd_api.g_miss_date
622 , p5_a10 NUMBER := 0-1962.0724
623 , p5_a11 DATE := fnd_api.g_miss_date
624 , p5_a12 NUMBER := 0-1962.0724
625 , p5_a13 NUMBER := 0-1962.0724
626 )
627
628 as
629 ddp_aesv_rec okl_process_tmpt_set_pub.aesv_rec_type;
630 ddp_avlv_tbl okl_process_tmpt_set_pub.avlv_tbl_type;
631 ddp_atlv_tbl okl_process_tmpt_set_pub.atlv_tbl_type;
632 ddx_aesv_rec okl_process_tmpt_set_pub.aesv_rec_type;
633 ddx_avlv_tbl okl_process_tmpt_set_pub.avlv_tbl_type;
634 ddx_atlv_tbl okl_process_tmpt_set_pub.atlv_tbl_type;
635 ddindx binary_integer; indx binary_integer;
636 begin
637
638 -- copy data to the local IN or IN-OUT args, if any
639
640
641
642
643
644 ddp_aesv_rec.id := rosetta_g_miss_num_map(p5_a0);
645 ddp_aesv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
646 ddp_aesv_rec.name := p5_a2;
647 ddp_aesv_rec.description := p5_a3;
648 ddp_aesv_rec.version := p5_a4;
649 ddp_aesv_rec.start_date := rosetta_g_miss_date_in_map(p5_a5);
650 ddp_aesv_rec.end_date := rosetta_g_miss_date_in_map(p5_a6);
651 ddp_aesv_rec.org_id := rosetta_g_miss_num_map(p5_a7);
652 ddp_aesv_rec.created_by := rosetta_g_miss_num_map(p5_a8);
653 ddp_aesv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a9);
654 ddp_aesv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a10);
655 ddp_aesv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a11);
656 ddp_aesv_rec.last_update_login := rosetta_g_miss_num_map(p5_a12);
657 ddp_aesv_rec.gts_id := rosetta_g_miss_num_map(p5_a13);
658
659 okl_avl_pvt_w.rosetta_table_copy_in_p5(ddp_avlv_tbl, p6_a0
660 , p6_a1
661 , p6_a2
662 , p6_a3
663 , p6_a4
664 , p6_a5
665 , p6_a6
666 , p6_a7
667 , p6_a8
668 , p6_a9
669 , p6_a10
670 , p6_a11
671 , p6_a12
672 , p6_a13
673 , p6_a14
674 , p6_a15
675 , p6_a16
676 , p6_a17
677 , p6_a18
678 , p6_a19
679 , p6_a20
680 , p6_a21
681 , p6_a22
682 , p6_a23
683 , p6_a24
684 , p6_a25
685 , p6_a26
686 , p6_a27
687 , p6_a28
688 , p6_a29
689 , p6_a30
690 , p6_a31
691 , p6_a32
692 , p6_a33
693 , p6_a34
694 , p6_a35
695 , p6_a36
696 , p6_a37
697 , p6_a38
698 , p6_a39
699 , p6_a40
700 , p6_a41
701 , p6_a42
702 );
703
704 okl_atl_pvt_w.rosetta_table_copy_in_p5(ddp_atlv_tbl, p7_a0
705 , p7_a1
706 , p7_a2
707 , p7_a3
708 , p7_a4
709 , p7_a5
710 , p7_a6
711 , p7_a7
712 , p7_a8
713 , p7_a9
714 , p7_a10
715 , p7_a11
716 , p7_a12
717 , p7_a13
718 , p7_a14
719 , p7_a15
720 , p7_a16
721 , p7_a17
722 , p7_a18
723 , p7_a19
724 , p7_a20
725 , p7_a21
726 , p7_a22
727 , p7_a23
728 , p7_a24
729 , p7_a25
730 , p7_a26
731 , p7_a27
732 , p7_a28
733 , p7_a29
734 , p7_a30
735 , p7_a31
736 , p7_a32
737 );
738
739
740
741
742 -- here's the delegated call to the old PL/SQL routine
743 okl_process_tmpt_set_pub.update_tmpt_set(p_api_version,
744 p_init_msg_list,
745 x_return_status,
746 x_msg_count,
747 x_msg_data,
748 ddp_aesv_rec,
749 ddp_avlv_tbl,
750 ddp_atlv_tbl,
751 ddx_aesv_rec,
752 ddx_avlv_tbl,
753 ddx_atlv_tbl);
754
755 -- copy data back from the local variables to OUT or IN-OUT args, if any
756
757
758
759
760
761
762
763
764 p8_a0 := rosetta_g_miss_num_map(ddx_aesv_rec.id);
765 p8_a1 := rosetta_g_miss_num_map(ddx_aesv_rec.object_version_number);
766 p8_a2 := ddx_aesv_rec.name;
767 p8_a3 := ddx_aesv_rec.description;
768 p8_a4 := ddx_aesv_rec.version;
769 p8_a5 := ddx_aesv_rec.start_date;
770 p8_a6 := ddx_aesv_rec.end_date;
771 p8_a7 := rosetta_g_miss_num_map(ddx_aesv_rec.org_id);
772 p8_a8 := rosetta_g_miss_num_map(ddx_aesv_rec.created_by);
773 p8_a9 := ddx_aesv_rec.creation_date;
774 p8_a10 := rosetta_g_miss_num_map(ddx_aesv_rec.last_updated_by);
775 p8_a11 := ddx_aesv_rec.last_update_date;
776 p8_a12 := rosetta_g_miss_num_map(ddx_aesv_rec.last_update_login);
777 p8_a13 := rosetta_g_miss_num_map(ddx_aesv_rec.gts_id);
778
779 okl_avl_pvt_w.rosetta_table_copy_out_p5(ddx_avlv_tbl, p9_a0
780 , p9_a1
781 , p9_a2
782 , p9_a3
783 , p9_a4
784 , p9_a5
785 , p9_a6
786 , p9_a7
787 , p9_a8
788 , p9_a9
789 , p9_a10
790 , p9_a11
791 , p9_a12
792 , p9_a13
793 , p9_a14
794 , p9_a15
795 , p9_a16
796 , p9_a17
797 , p9_a18
798 , p9_a19
799 , p9_a20
800 , p9_a21
801 , p9_a22
802 , p9_a23
803 , p9_a24
804 , p9_a25
805 , p9_a26
806 , p9_a27
807 , p9_a28
808 , p9_a29
809 , p9_a30
810 , p9_a31
811 , p9_a32
812 , p9_a33
813 , p9_a34
814 , p9_a35
815 , p9_a36
816 , p9_a37
817 , p9_a38
818 , p9_a39
819 , p9_a40
820 , p9_a41
821 , p9_a42
822 );
823
824 okl_atl_pvt_w.rosetta_table_copy_out_p5(ddx_atlv_tbl, p10_a0
825 , p10_a1
826 , p10_a2
827 , p10_a3
828 , p10_a4
829 , p10_a5
830 , p10_a6
831 , p10_a7
832 , p10_a8
833 , p10_a9
834 , p10_a10
835 , p10_a11
836 , p10_a12
837 , p10_a13
838 , p10_a14
839 , p10_a15
840 , p10_a16
841 , p10_a17
842 , p10_a18
843 , p10_a19
844 , p10_a20
845 , p10_a21
846 , p10_a22
847 , p10_a23
848 , p10_a24
849 , p10_a25
850 , p10_a26
851 , p10_a27
852 , p10_a28
853 , p10_a29
854 , p10_a30
855 , p10_a31
856 , p10_a32
857 );
858 end;
859
860 procedure create_tmpt_set(p_api_version NUMBER
861 , p_init_msg_list VARCHAR2
862 , x_return_status out nocopy VARCHAR2
863 , x_msg_count out nocopy NUMBER
864 , x_msg_data out nocopy VARCHAR2
865 , p5_a0 JTF_NUMBER_TABLE
866 , p5_a1 JTF_NUMBER_TABLE
867 , p5_a2 JTF_VARCHAR2_TABLE_200
868 , p5_a3 JTF_VARCHAR2_TABLE_2000
869 , p5_a4 JTF_VARCHAR2_TABLE_100
870 , p5_a5 JTF_DATE_TABLE
871 , p5_a6 JTF_DATE_TABLE
872 , p5_a7 JTF_NUMBER_TABLE
873 , p5_a8 JTF_NUMBER_TABLE
874 , p5_a9 JTF_DATE_TABLE
875 , p5_a10 JTF_NUMBER_TABLE
876 , p5_a11 JTF_DATE_TABLE
877 , p5_a12 JTF_NUMBER_TABLE
878 , p5_a13 JTF_NUMBER_TABLE
879 , p6_a0 out nocopy JTF_NUMBER_TABLE
880 , p6_a1 out nocopy JTF_NUMBER_TABLE
881 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
882 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
883 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
884 , p6_a5 out nocopy JTF_DATE_TABLE
885 , p6_a6 out nocopy JTF_DATE_TABLE
886 , p6_a7 out nocopy JTF_NUMBER_TABLE
887 , p6_a8 out nocopy JTF_NUMBER_TABLE
888 , p6_a9 out nocopy JTF_DATE_TABLE
889 , p6_a10 out nocopy JTF_NUMBER_TABLE
890 , p6_a11 out nocopy JTF_DATE_TABLE
891 , p6_a12 out nocopy JTF_NUMBER_TABLE
892 , p6_a13 out nocopy JTF_NUMBER_TABLE
893 )
894
895 as
896 ddp_aesv_tbl okl_process_tmpt_set_pub.aesv_tbl_type;
897 ddx_aesv_tbl okl_process_tmpt_set_pub.aesv_tbl_type;
898 ddindx binary_integer; indx binary_integer;
899 begin
900
901 -- copy data to the local IN or IN-OUT args, if any
902
903
904
905
906
907 okl_aes_pvt_w.rosetta_table_copy_in_p5(ddp_aesv_tbl, p5_a0
908 , p5_a1
909 , p5_a2
910 , p5_a3
911 , p5_a4
912 , p5_a5
913 , p5_a6
914 , p5_a7
915 , p5_a8
916 , p5_a9
917 , p5_a10
918 , p5_a11
919 , p5_a12
920 , p5_a13
921 );
922
923
924 -- here's the delegated call to the old PL/SQL routine
925 okl_process_tmpt_set_pub.create_tmpt_set(p_api_version,
926 p_init_msg_list,
927 x_return_status,
928 x_msg_count,
929 x_msg_data,
930 ddp_aesv_tbl,
931 ddx_aesv_tbl);
932
933 -- copy data back from the local variables to OUT or IN-OUT args, if any
934
935
936
937
938
939
940 okl_aes_pvt_w.rosetta_table_copy_out_p5(ddx_aesv_tbl, p6_a0
941 , p6_a1
942 , p6_a2
943 , p6_a3
944 , p6_a4
945 , p6_a5
946 , p6_a6
947 , p6_a7
948 , p6_a8
949 , p6_a9
950 , p6_a10
951 , p6_a11
952 , p6_a12
953 , p6_a13
954 );
955 end;
956
957 procedure create_tmpt_set(p_api_version NUMBER
958 , p_init_msg_list VARCHAR2
959 , x_return_status out nocopy VARCHAR2
960 , x_msg_count out nocopy NUMBER
961 , x_msg_data out nocopy VARCHAR2
962 , p6_a0 out nocopy NUMBER
963 , p6_a1 out nocopy NUMBER
964 , p6_a2 out nocopy VARCHAR2
965 , p6_a3 out nocopy VARCHAR2
966 , p6_a4 out nocopy VARCHAR2
967 , p6_a5 out nocopy DATE
968 , p6_a6 out nocopy DATE
969 , p6_a7 out nocopy NUMBER
970 , p6_a8 out nocopy NUMBER
971 , p6_a9 out nocopy DATE
972 , p6_a10 out nocopy NUMBER
973 , p6_a11 out nocopy DATE
974 , p6_a12 out nocopy NUMBER
975 , p6_a13 out nocopy NUMBER
976 , p_aes_source_id NUMBER
977 , p5_a0 NUMBER := 0-1962.0724
978 , p5_a1 NUMBER := 0-1962.0724
979 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
980 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
981 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
982 , p5_a5 DATE := fnd_api.g_miss_date
983 , p5_a6 DATE := fnd_api.g_miss_date
984 , p5_a7 NUMBER := 0-1962.0724
985 , p5_a8 NUMBER := 0-1962.0724
986 , p5_a9 DATE := fnd_api.g_miss_date
987 , p5_a10 NUMBER := 0-1962.0724
988 , p5_a11 DATE := fnd_api.g_miss_date
989 , p5_a12 NUMBER := 0-1962.0724
990 , p5_a13 NUMBER := 0-1962.0724
991 )
992
993 as
994 ddp_aesv_rec okl_process_tmpt_set_pub.aesv_rec_type;
995 ddx_aesv_rec okl_process_tmpt_set_pub.aesv_rec_type;
996 ddindx binary_integer; indx binary_integer;
997 begin
998
999 -- copy data to the local IN or IN-OUT args, if any
1000
1001
1002
1003
1004
1005 ddp_aesv_rec.id := rosetta_g_miss_num_map(p5_a0);
1006 ddp_aesv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1007 ddp_aesv_rec.name := p5_a2;
1008 ddp_aesv_rec.description := p5_a3;
1009 ddp_aesv_rec.version := p5_a4;
1010 ddp_aesv_rec.start_date := rosetta_g_miss_date_in_map(p5_a5);
1011 ddp_aesv_rec.end_date := rosetta_g_miss_date_in_map(p5_a6);
1012 ddp_aesv_rec.org_id := rosetta_g_miss_num_map(p5_a7);
1013 ddp_aesv_rec.created_by := rosetta_g_miss_num_map(p5_a8);
1014 ddp_aesv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a9);
1015 ddp_aesv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a10);
1016 ddp_aesv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a11);
1017 ddp_aesv_rec.last_update_login := rosetta_g_miss_num_map(p5_a12);
1018 ddp_aesv_rec.gts_id := rosetta_g_miss_num_map(p5_a13);
1019
1020
1021
1022 -- here's the delegated call to the old PL/SQL routine
1023 okl_process_tmpt_set_pub.create_tmpt_set(p_api_version,
1024 p_init_msg_list,
1025 x_return_status,
1026 x_msg_count,
1027 x_msg_data,
1028 ddp_aesv_rec,
1029 ddx_aesv_rec,
1030 p_aes_source_id);
1031
1032 -- copy data back from the local variables to OUT or IN-OUT args, if any
1033
1034
1035
1036
1037
1038
1039 p6_a0 := rosetta_g_miss_num_map(ddx_aesv_rec.id);
1040 p6_a1 := rosetta_g_miss_num_map(ddx_aesv_rec.object_version_number);
1041 p6_a2 := ddx_aesv_rec.name;
1042 p6_a3 := ddx_aesv_rec.description;
1043 p6_a4 := ddx_aesv_rec.version;
1044 p6_a5 := ddx_aesv_rec.start_date;
1045 p6_a6 := ddx_aesv_rec.end_date;
1046 p6_a7 := rosetta_g_miss_num_map(ddx_aesv_rec.org_id);
1047 p6_a8 := rosetta_g_miss_num_map(ddx_aesv_rec.created_by);
1048 p6_a9 := ddx_aesv_rec.creation_date;
1049 p6_a10 := rosetta_g_miss_num_map(ddx_aesv_rec.last_updated_by);
1050 p6_a11 := ddx_aesv_rec.last_update_date;
1051 p6_a12 := rosetta_g_miss_num_map(ddx_aesv_rec.last_update_login);
1052 p6_a13 := rosetta_g_miss_num_map(ddx_aesv_rec.gts_id);
1053
1054 end;
1055
1056 procedure update_tmpt_set(p_api_version NUMBER
1057 , p_init_msg_list VARCHAR2
1058 , x_return_status out nocopy VARCHAR2
1059 , x_msg_count out nocopy NUMBER
1060 , x_msg_data out nocopy VARCHAR2
1061 , p5_a0 JTF_NUMBER_TABLE
1062 , p5_a1 JTF_NUMBER_TABLE
1063 , p5_a2 JTF_VARCHAR2_TABLE_200
1064 , p5_a3 JTF_VARCHAR2_TABLE_2000
1065 , p5_a4 JTF_VARCHAR2_TABLE_100
1066 , p5_a5 JTF_DATE_TABLE
1067 , p5_a6 JTF_DATE_TABLE
1068 , p5_a7 JTF_NUMBER_TABLE
1069 , p5_a8 JTF_NUMBER_TABLE
1070 , p5_a9 JTF_DATE_TABLE
1071 , p5_a10 JTF_NUMBER_TABLE
1072 , p5_a11 JTF_DATE_TABLE
1073 , p5_a12 JTF_NUMBER_TABLE
1074 , p5_a13 JTF_NUMBER_TABLE
1075 , p6_a0 out nocopy JTF_NUMBER_TABLE
1076 , p6_a1 out nocopy JTF_NUMBER_TABLE
1077 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
1078 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
1079 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1080 , p6_a5 out nocopy JTF_DATE_TABLE
1081 , p6_a6 out nocopy JTF_DATE_TABLE
1082 , p6_a7 out nocopy JTF_NUMBER_TABLE
1083 , p6_a8 out nocopy JTF_NUMBER_TABLE
1084 , p6_a9 out nocopy JTF_DATE_TABLE
1085 , p6_a10 out nocopy JTF_NUMBER_TABLE
1086 , p6_a11 out nocopy JTF_DATE_TABLE
1087 , p6_a12 out nocopy JTF_NUMBER_TABLE
1088 , p6_a13 out nocopy JTF_NUMBER_TABLE
1089 )
1090
1091 as
1092 ddp_aesv_tbl okl_process_tmpt_set_pub.aesv_tbl_type;
1093 ddx_aesv_tbl okl_process_tmpt_set_pub.aesv_tbl_type;
1094 ddindx binary_integer; indx binary_integer;
1095 begin
1096
1097 -- copy data to the local IN or IN-OUT args, if any
1098
1099
1100
1101
1102
1103 okl_aes_pvt_w.rosetta_table_copy_in_p5(ddp_aesv_tbl, p5_a0
1104 , p5_a1
1105 , p5_a2
1106 , p5_a3
1107 , p5_a4
1108 , p5_a5
1109 , p5_a6
1110 , p5_a7
1111 , p5_a8
1112 , p5_a9
1113 , p5_a10
1114 , p5_a11
1115 , p5_a12
1116 , p5_a13
1117 );
1118
1119
1120 -- here's the delegated call to the old PL/SQL routine
1121 okl_process_tmpt_set_pub.update_tmpt_set(p_api_version,
1122 p_init_msg_list,
1123 x_return_status,
1124 x_msg_count,
1125 x_msg_data,
1126 ddp_aesv_tbl,
1127 ddx_aesv_tbl);
1128
1129 -- copy data back from the local variables to OUT or IN-OUT args, if any
1130
1131
1132
1133
1134
1135
1136 okl_aes_pvt_w.rosetta_table_copy_out_p5(ddx_aesv_tbl, p6_a0
1137 , p6_a1
1138 , p6_a2
1139 , p6_a3
1140 , p6_a4
1141 , p6_a5
1142 , p6_a6
1143 , p6_a7
1144 , p6_a8
1145 , p6_a9
1146 , p6_a10
1147 , p6_a11
1148 , p6_a12
1149 , p6_a13
1150 );
1151 end;
1152
1153 procedure update_tmpt_set(p_api_version NUMBER
1154 , p_init_msg_list VARCHAR2
1155 , x_return_status out nocopy VARCHAR2
1156 , x_msg_count out nocopy NUMBER
1157 , x_msg_data out nocopy VARCHAR2
1158 , p6_a0 out nocopy NUMBER
1159 , p6_a1 out nocopy NUMBER
1160 , p6_a2 out nocopy VARCHAR2
1161 , p6_a3 out nocopy VARCHAR2
1162 , p6_a4 out nocopy VARCHAR2
1163 , p6_a5 out nocopy DATE
1164 , p6_a6 out nocopy DATE
1165 , p6_a7 out nocopy NUMBER
1166 , p6_a8 out nocopy NUMBER
1167 , p6_a9 out nocopy DATE
1168 , p6_a10 out nocopy NUMBER
1169 , p6_a11 out nocopy DATE
1170 , p6_a12 out nocopy NUMBER
1171 , p6_a13 out nocopy NUMBER
1172 , p5_a0 NUMBER := 0-1962.0724
1173 , p5_a1 NUMBER := 0-1962.0724
1174 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1175 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1176 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1177 , p5_a5 DATE := fnd_api.g_miss_date
1178 , p5_a6 DATE := fnd_api.g_miss_date
1179 , p5_a7 NUMBER := 0-1962.0724
1180 , p5_a8 NUMBER := 0-1962.0724
1181 , p5_a9 DATE := fnd_api.g_miss_date
1182 , p5_a10 NUMBER := 0-1962.0724
1183 , p5_a11 DATE := fnd_api.g_miss_date
1184 , p5_a12 NUMBER := 0-1962.0724
1185 , p5_a13 NUMBER := 0-1962.0724
1186 )
1187
1188 as
1189 ddp_aesv_rec okl_process_tmpt_set_pub.aesv_rec_type;
1190 ddx_aesv_rec okl_process_tmpt_set_pub.aesv_rec_type;
1191 ddindx binary_integer; indx binary_integer;
1192 begin
1193
1194 -- copy data to the local IN or IN-OUT args, if any
1195
1196
1197
1198
1199
1200 ddp_aesv_rec.id := rosetta_g_miss_num_map(p5_a0);
1201 ddp_aesv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1202 ddp_aesv_rec.name := p5_a2;
1203 ddp_aesv_rec.description := p5_a3;
1204 ddp_aesv_rec.version := p5_a4;
1205 ddp_aesv_rec.start_date := rosetta_g_miss_date_in_map(p5_a5);
1206 ddp_aesv_rec.end_date := rosetta_g_miss_date_in_map(p5_a6);
1207 ddp_aesv_rec.org_id := rosetta_g_miss_num_map(p5_a7);
1208 ddp_aesv_rec.created_by := rosetta_g_miss_num_map(p5_a8);
1209 ddp_aesv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a9);
1210 ddp_aesv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a10);
1211 ddp_aesv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a11);
1212 ddp_aesv_rec.last_update_login := rosetta_g_miss_num_map(p5_a12);
1213 ddp_aesv_rec.gts_id := rosetta_g_miss_num_map(p5_a13);
1214
1215
1216 -- here's the delegated call to the old PL/SQL routine
1217 okl_process_tmpt_set_pub.update_tmpt_set(p_api_version,
1218 p_init_msg_list,
1219 x_return_status,
1220 x_msg_count,
1221 x_msg_data,
1222 ddp_aesv_rec,
1223 ddx_aesv_rec);
1224
1225 -- copy data back from the local variables to OUT or IN-OUT args, if any
1226
1227
1228
1229
1230
1231
1232 p6_a0 := rosetta_g_miss_num_map(ddx_aesv_rec.id);
1233 p6_a1 := rosetta_g_miss_num_map(ddx_aesv_rec.object_version_number);
1234 p6_a2 := ddx_aesv_rec.name;
1235 p6_a3 := ddx_aesv_rec.description;
1236 p6_a4 := ddx_aesv_rec.version;
1237 p6_a5 := ddx_aesv_rec.start_date;
1238 p6_a6 := ddx_aesv_rec.end_date;
1239 p6_a7 := rosetta_g_miss_num_map(ddx_aesv_rec.org_id);
1240 p6_a8 := rosetta_g_miss_num_map(ddx_aesv_rec.created_by);
1241 p6_a9 := ddx_aesv_rec.creation_date;
1242 p6_a10 := rosetta_g_miss_num_map(ddx_aesv_rec.last_updated_by);
1243 p6_a11 := ddx_aesv_rec.last_update_date;
1244 p6_a12 := rosetta_g_miss_num_map(ddx_aesv_rec.last_update_login);
1245 p6_a13 := rosetta_g_miss_num_map(ddx_aesv_rec.gts_id);
1246 end;
1247
1248 procedure delete_tmpt_set(p_api_version NUMBER
1249 , p_init_msg_list VARCHAR2
1250 , x_return_status out nocopy VARCHAR2
1251 , x_msg_count out nocopy NUMBER
1252 , x_msg_data out nocopy VARCHAR2
1253 , p5_a0 JTF_NUMBER_TABLE
1254 , p5_a1 JTF_NUMBER_TABLE
1255 , p5_a2 JTF_VARCHAR2_TABLE_200
1256 , p5_a3 JTF_VARCHAR2_TABLE_2000
1257 , p5_a4 JTF_VARCHAR2_TABLE_100
1258 , p5_a5 JTF_DATE_TABLE
1259 , p5_a6 JTF_DATE_TABLE
1260 , p5_a7 JTF_NUMBER_TABLE
1261 , p5_a8 JTF_NUMBER_TABLE
1262 , p5_a9 JTF_DATE_TABLE
1263 , p5_a10 JTF_NUMBER_TABLE
1264 , p5_a11 JTF_DATE_TABLE
1265 , p5_a12 JTF_NUMBER_TABLE
1266 , p5_a13 JTF_NUMBER_TABLE
1267 )
1268
1269 as
1270 ddp_aesv_tbl okl_process_tmpt_set_pub.aesv_tbl_type;
1271 ddindx binary_integer; indx binary_integer;
1272 begin
1273
1274 -- copy data to the local IN or IN-OUT args, if any
1275
1276
1277
1278
1279
1280 okl_aes_pvt_w.rosetta_table_copy_in_p5(ddp_aesv_tbl, p5_a0
1281 , p5_a1
1282 , p5_a2
1283 , p5_a3
1284 , p5_a4
1285 , p5_a5
1286 , p5_a6
1287 , p5_a7
1288 , p5_a8
1289 , p5_a9
1290 , p5_a10
1291 , p5_a11
1292 , p5_a12
1293 , p5_a13
1294 );
1295
1296 -- here's the delegated call to the old PL/SQL routine
1297 okl_process_tmpt_set_pub.delete_tmpt_set(p_api_version,
1298 p_init_msg_list,
1299 x_return_status,
1300 x_msg_count,
1301 x_msg_data,
1302 ddp_aesv_tbl);
1303
1304 -- copy data back from the local variables to OUT or IN-OUT args, if any
1305
1306
1307
1308
1309
1310 end;
1311
1312 procedure delete_tmpt_set(p_api_version NUMBER
1313 , p_init_msg_list VARCHAR2
1314 , x_return_status out nocopy VARCHAR2
1315 , x_msg_count out nocopy NUMBER
1316 , x_msg_data out nocopy VARCHAR2
1317 , p5_a0 NUMBER := 0-1962.0724
1318 , p5_a1 NUMBER := 0-1962.0724
1319 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1320 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1321 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1322 , p5_a5 DATE := fnd_api.g_miss_date
1323 , p5_a6 DATE := fnd_api.g_miss_date
1324 , p5_a7 NUMBER := 0-1962.0724
1325 , p5_a8 NUMBER := 0-1962.0724
1326 , p5_a9 DATE := fnd_api.g_miss_date
1327 , p5_a10 NUMBER := 0-1962.0724
1328 , p5_a11 DATE := fnd_api.g_miss_date
1329 , p5_a12 NUMBER := 0-1962.0724
1330 , p5_a13 NUMBER := 0-1962.0724
1331 )
1332
1333 as
1334 ddp_aesv_rec okl_process_tmpt_set_pub.aesv_rec_type;
1335 ddindx binary_integer; indx binary_integer;
1336 begin
1337
1338 -- copy data to the local IN or IN-OUT args, if any
1339
1340
1341
1342
1343
1344 ddp_aesv_rec.id := rosetta_g_miss_num_map(p5_a0);
1345 ddp_aesv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1346 ddp_aesv_rec.name := p5_a2;
1347 ddp_aesv_rec.description := p5_a3;
1348 ddp_aesv_rec.version := p5_a4;
1349 ddp_aesv_rec.start_date := rosetta_g_miss_date_in_map(p5_a5);
1350 ddp_aesv_rec.end_date := rosetta_g_miss_date_in_map(p5_a6);
1351 ddp_aesv_rec.org_id := rosetta_g_miss_num_map(p5_a7);
1352 ddp_aesv_rec.created_by := rosetta_g_miss_num_map(p5_a8);
1353 ddp_aesv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a9);
1354 ddp_aesv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a10);
1355 ddp_aesv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a11);
1356 ddp_aesv_rec.last_update_login := rosetta_g_miss_num_map(p5_a12);
1357 ddp_aesv_rec.gts_id := rosetta_g_miss_num_map(p5_a13);
1358
1359 -- here's the delegated call to the old PL/SQL routine
1360 okl_process_tmpt_set_pub.delete_tmpt_set(p_api_version,
1361 p_init_msg_list,
1362 x_return_status,
1363 x_msg_count,
1364 x_msg_data,
1365 ddp_aesv_rec);
1366
1367 -- copy data back from the local variables to OUT or IN-OUT args, if any
1368
1369
1370
1371
1372
1373 end;
1374
1375 procedure create_template(p_api_version NUMBER
1376 , p_init_msg_list VARCHAR2
1377 , x_return_status out nocopy VARCHAR2
1378 , x_msg_count out nocopy NUMBER
1379 , x_msg_data out nocopy VARCHAR2
1380 , p5_a0 JTF_NUMBER_TABLE
1381 , p5_a1 JTF_NUMBER_TABLE
1382 , p5_a2 JTF_NUMBER_TABLE
1383 , p5_a3 JTF_NUMBER_TABLE
1384 , p5_a4 JTF_NUMBER_TABLE
1385 , p5_a5 JTF_NUMBER_TABLE
1386 , p5_a6 JTF_NUMBER_TABLE
1387 , p5_a7 JTF_VARCHAR2_TABLE_100
1388 , p5_a8 JTF_VARCHAR2_TABLE_100
1389 , p5_a9 JTF_VARCHAR2_TABLE_100
1390 , p5_a10 JTF_VARCHAR2_TABLE_100
1391 , p5_a11 JTF_VARCHAR2_TABLE_100
1392 , p5_a12 JTF_VARCHAR2_TABLE_100
1393 , p5_a13 JTF_VARCHAR2_TABLE_200
1394 , p5_a14 JTF_VARCHAR2_TABLE_2000
1395 , p5_a15 JTF_VARCHAR2_TABLE_100
1396 , p5_a16 JTF_VARCHAR2_TABLE_100
1397 , p5_a17 JTF_DATE_TABLE
1398 , p5_a18 JTF_DATE_TABLE
1399 , p5_a19 JTF_VARCHAR2_TABLE_100
1400 , p5_a20 JTF_VARCHAR2_TABLE_100
1401 , p5_a21 JTF_VARCHAR2_TABLE_500
1402 , p5_a22 JTF_VARCHAR2_TABLE_500
1403 , p5_a23 JTF_VARCHAR2_TABLE_500
1404 , p5_a24 JTF_VARCHAR2_TABLE_500
1405 , p5_a25 JTF_VARCHAR2_TABLE_500
1406 , p5_a26 JTF_VARCHAR2_TABLE_500
1407 , p5_a27 JTF_VARCHAR2_TABLE_500
1408 , p5_a28 JTF_VARCHAR2_TABLE_500
1409 , p5_a29 JTF_VARCHAR2_TABLE_500
1410 , p5_a30 JTF_VARCHAR2_TABLE_500
1411 , p5_a31 JTF_VARCHAR2_TABLE_500
1412 , p5_a32 JTF_VARCHAR2_TABLE_500
1413 , p5_a33 JTF_VARCHAR2_TABLE_500
1414 , p5_a34 JTF_VARCHAR2_TABLE_500
1415 , p5_a35 JTF_VARCHAR2_TABLE_500
1416 , p5_a36 JTF_NUMBER_TABLE
1417 , p5_a37 JTF_NUMBER_TABLE
1418 , p5_a38 JTF_DATE_TABLE
1419 , p5_a39 JTF_NUMBER_TABLE
1420 , p5_a40 JTF_DATE_TABLE
1421 , p5_a41 JTF_NUMBER_TABLE
1422 , p5_a42 JTF_VARCHAR2_TABLE_100
1423 , p6_a0 out nocopy JTF_NUMBER_TABLE
1424 , p6_a1 out nocopy JTF_NUMBER_TABLE
1425 , p6_a2 out nocopy JTF_NUMBER_TABLE
1426 , p6_a3 out nocopy JTF_NUMBER_TABLE
1427 , p6_a4 out nocopy JTF_NUMBER_TABLE
1428 , p6_a5 out nocopy JTF_NUMBER_TABLE
1429 , p6_a6 out nocopy JTF_NUMBER_TABLE
1430 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1431 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1432 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1433 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1434 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1435 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1436 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
1437 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_2000
1438 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1439 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
1440 , p6_a17 out nocopy JTF_DATE_TABLE
1441 , p6_a18 out nocopy JTF_DATE_TABLE
1442 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
1443 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
1444 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1445 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1446 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1447 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1448 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1449 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1450 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1451 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1452 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
1453 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
1454 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
1455 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
1456 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
1457 , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
1458 , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
1459 , p6_a36 out nocopy JTF_NUMBER_TABLE
1460 , p6_a37 out nocopy JTF_NUMBER_TABLE
1461 , p6_a38 out nocopy JTF_DATE_TABLE
1462 , p6_a39 out nocopy JTF_NUMBER_TABLE
1463 , p6_a40 out nocopy JTF_DATE_TABLE
1464 , p6_a41 out nocopy JTF_NUMBER_TABLE
1465 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
1466 )
1467
1468 as
1469 ddp_avlv_tbl okl_process_tmpt_set_pub.avlv_tbl_type;
1470 ddx_avlv_tbl okl_process_tmpt_set_pub.avlv_tbl_type;
1471 ddindx binary_integer; indx binary_integer;
1472 begin
1473
1474 -- copy data to the local IN or IN-OUT args, if any
1475
1476
1477
1478
1479
1480 okl_avl_pvt_w.rosetta_table_copy_in_p5(ddp_avlv_tbl, p5_a0
1481 , p5_a1
1482 , p5_a2
1483 , p5_a3
1484 , p5_a4
1485 , p5_a5
1486 , p5_a6
1487 , p5_a7
1488 , p5_a8
1489 , p5_a9
1490 , p5_a10
1491 , p5_a11
1492 , p5_a12
1493 , p5_a13
1494 , p5_a14
1495 , p5_a15
1496 , p5_a16
1497 , p5_a17
1498 , p5_a18
1499 , p5_a19
1500 , p5_a20
1501 , p5_a21
1502 , p5_a22
1503 , p5_a23
1504 , p5_a24
1505 , p5_a25
1506 , p5_a26
1507 , p5_a27
1508 , p5_a28
1509 , p5_a29
1510 , p5_a30
1511 , p5_a31
1512 , p5_a32
1513 , p5_a33
1514 , p5_a34
1515 , p5_a35
1516 , p5_a36
1517 , p5_a37
1518 , p5_a38
1519 , p5_a39
1520 , p5_a40
1521 , p5_a41
1522 , p5_a42
1523 );
1524
1525
1526 -- here's the delegated call to the old PL/SQL routine
1527 okl_process_tmpt_set_pub.create_template(p_api_version,
1528 p_init_msg_list,
1529 x_return_status,
1530 x_msg_count,
1531 x_msg_data,
1532 ddp_avlv_tbl,
1533 ddx_avlv_tbl);
1534
1535 -- copy data back from the local variables to OUT or IN-OUT args, if any
1536
1537
1538
1539
1540
1541
1542 okl_avl_pvt_w.rosetta_table_copy_out_p5(ddx_avlv_tbl, p6_a0
1543 , p6_a1
1544 , p6_a2
1545 , p6_a3
1546 , p6_a4
1547 , p6_a5
1548 , p6_a6
1549 , p6_a7
1550 , p6_a8
1551 , p6_a9
1552 , p6_a10
1553 , p6_a11
1554 , p6_a12
1555 , p6_a13
1556 , p6_a14
1557 , p6_a15
1558 , p6_a16
1559 , p6_a17
1560 , p6_a18
1561 , p6_a19
1562 , p6_a20
1563 , p6_a21
1564 , p6_a22
1565 , p6_a23
1566 , p6_a24
1567 , p6_a25
1568 , p6_a26
1569 , p6_a27
1570 , p6_a28
1571 , p6_a29
1572 , p6_a30
1573 , p6_a31
1574 , p6_a32
1575 , p6_a33
1576 , p6_a34
1577 , p6_a35
1578 , p6_a36
1579 , p6_a37
1580 , p6_a38
1581 , p6_a39
1582 , p6_a40
1583 , p6_a41
1584 , p6_a42
1585 );
1586 end;
1587
1588 procedure create_template(p_api_version NUMBER
1589 , p_init_msg_list VARCHAR2
1590 , x_return_status out nocopy VARCHAR2
1591 , x_msg_count out nocopy NUMBER
1592 , x_msg_data out nocopy VARCHAR2
1593 , p6_a0 out nocopy NUMBER
1594 , p6_a1 out nocopy NUMBER
1595 , p6_a2 out nocopy NUMBER
1596 , p6_a3 out nocopy NUMBER
1597 , p6_a4 out nocopy NUMBER
1598 , p6_a5 out nocopy NUMBER
1599 , p6_a6 out nocopy NUMBER
1600 , p6_a7 out nocopy VARCHAR2
1601 , p6_a8 out nocopy VARCHAR2
1602 , p6_a9 out nocopy VARCHAR2
1603 , p6_a10 out nocopy VARCHAR2
1604 , p6_a11 out nocopy VARCHAR2
1605 , p6_a12 out nocopy VARCHAR2
1606 , p6_a13 out nocopy VARCHAR2
1607 , p6_a14 out nocopy VARCHAR2
1608 , p6_a15 out nocopy VARCHAR2
1609 , p6_a16 out nocopy VARCHAR2
1610 , p6_a17 out nocopy DATE
1611 , p6_a18 out nocopy DATE
1612 , p6_a19 out nocopy VARCHAR2
1613 , p6_a20 out nocopy VARCHAR2
1614 , p6_a21 out nocopy VARCHAR2
1615 , p6_a22 out nocopy VARCHAR2
1616 , p6_a23 out nocopy VARCHAR2
1617 , p6_a24 out nocopy VARCHAR2
1618 , p6_a25 out nocopy VARCHAR2
1619 , p6_a26 out nocopy VARCHAR2
1620 , p6_a27 out nocopy VARCHAR2
1621 , p6_a28 out nocopy VARCHAR2
1622 , p6_a29 out nocopy VARCHAR2
1623 , p6_a30 out nocopy VARCHAR2
1624 , p6_a31 out nocopy VARCHAR2
1625 , p6_a32 out nocopy VARCHAR2
1626 , p6_a33 out nocopy VARCHAR2
1627 , p6_a34 out nocopy VARCHAR2
1628 , p6_a35 out nocopy VARCHAR2
1629 , p6_a36 out nocopy NUMBER
1630 , p6_a37 out nocopy NUMBER
1631 , p6_a38 out nocopy DATE
1632 , p6_a39 out nocopy NUMBER
1633 , p6_a40 out nocopy DATE
1634 , p6_a41 out nocopy NUMBER
1635 , p6_a42 out nocopy VARCHAR2
1636 , p5_a0 NUMBER := 0-1962.0724
1637 , p5_a1 NUMBER := 0-1962.0724
1638 , p5_a2 NUMBER := 0-1962.0724
1639 , p5_a3 NUMBER := 0-1962.0724
1640 , p5_a4 NUMBER := 0-1962.0724
1641 , p5_a5 NUMBER := 0-1962.0724
1642 , p5_a6 NUMBER := 0-1962.0724
1643 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1644 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1645 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1646 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1647 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1648 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1649 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1650 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1651 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1652 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1653 , p5_a17 DATE := fnd_api.g_miss_date
1654 , p5_a18 DATE := fnd_api.g_miss_date
1655 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1656 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1657 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1658 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1659 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1660 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1661 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1662 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1663 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1664 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1665 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1666 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1667 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1668 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1669 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1670 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1671 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1672 , p5_a36 NUMBER := 0-1962.0724
1673 , p5_a37 NUMBER := 0-1962.0724
1674 , p5_a38 DATE := fnd_api.g_miss_date
1675 , p5_a39 NUMBER := 0-1962.0724
1676 , p5_a40 DATE := fnd_api.g_miss_date
1677 , p5_a41 NUMBER := 0-1962.0724
1678 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1679 )
1680
1681 as
1682 ddp_avlv_rec okl_process_tmpt_set_pub.avlv_rec_type;
1683 ddx_avlv_rec okl_process_tmpt_set_pub.avlv_rec_type;
1684 ddindx binary_integer; indx binary_integer;
1685 begin
1686
1687 -- copy data to the local IN or IN-OUT args, if any
1688
1689
1690
1691
1692
1693 ddp_avlv_rec.id := rosetta_g_miss_num_map(p5_a0);
1694 ddp_avlv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1695 ddp_avlv_rec.try_id := rosetta_g_miss_num_map(p5_a2);
1696 ddp_avlv_rec.aes_id := rosetta_g_miss_num_map(p5_a3);
1697 ddp_avlv_rec.sty_id := rosetta_g_miss_num_map(p5_a4);
1698 ddp_avlv_rec.fma_id := rosetta_g_miss_num_map(p5_a5);
1699 ddp_avlv_rec.set_of_books_id := rosetta_g_miss_num_map(p5_a6);
1700 ddp_avlv_rec.fac_code := p5_a7;
1701 ddp_avlv_rec.syt_code := p5_a8;
1702 ddp_avlv_rec.post_to_gl := p5_a9;
1703 ddp_avlv_rec.advance_arrears := p5_a10;
1704 ddp_avlv_rec.memo_yn := p5_a11;
1705 ddp_avlv_rec.prior_year_yn := p5_a12;
1706 ddp_avlv_rec.name := p5_a13;
1707 ddp_avlv_rec.description := p5_a14;
1708 ddp_avlv_rec.version := p5_a15;
1709 ddp_avlv_rec.factoring_synd_flag := p5_a16;
1710 ddp_avlv_rec.start_date := rosetta_g_miss_date_in_map(p5_a17);
1711 ddp_avlv_rec.end_date := rosetta_g_miss_date_in_map(p5_a18);
1712 ddp_avlv_rec.accrual_yn := p5_a19;
1713 ddp_avlv_rec.attribute_category := p5_a20;
1714 ddp_avlv_rec.attribute1 := p5_a21;
1715 ddp_avlv_rec.attribute2 := p5_a22;
1716 ddp_avlv_rec.attribute3 := p5_a23;
1717 ddp_avlv_rec.attribute4 := p5_a24;
1718 ddp_avlv_rec.attribute5 := p5_a25;
1719 ddp_avlv_rec.attribute6 := p5_a26;
1720 ddp_avlv_rec.attribute7 := p5_a27;
1721 ddp_avlv_rec.attribute8 := p5_a28;
1722 ddp_avlv_rec.attribute9 := p5_a29;
1723 ddp_avlv_rec.attribute10 := p5_a30;
1724 ddp_avlv_rec.attribute11 := p5_a31;
1725 ddp_avlv_rec.attribute12 := p5_a32;
1726 ddp_avlv_rec.attribute13 := p5_a33;
1727 ddp_avlv_rec.attribute14 := p5_a34;
1728 ddp_avlv_rec.attribute15 := p5_a35;
1729 ddp_avlv_rec.org_id := rosetta_g_miss_num_map(p5_a36);
1730 ddp_avlv_rec.created_by := rosetta_g_miss_num_map(p5_a37);
1731 ddp_avlv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a38);
1732 ddp_avlv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a39);
1733 ddp_avlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a40);
1734 ddp_avlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a41);
1735 ddp_avlv_rec.inv_code := p5_a42;
1736
1737
1738 -- here's the delegated call to the old PL/SQL routine
1739 okl_process_tmpt_set_pub.create_template(p_api_version,
1740 p_init_msg_list,
1741 x_return_status,
1742 x_msg_count,
1743 x_msg_data,
1744 ddp_avlv_rec,
1745 ddx_avlv_rec);
1746
1747 -- copy data back from the local variables to OUT or IN-OUT args, if any
1748
1749
1750
1751
1752
1753
1754 p6_a0 := rosetta_g_miss_num_map(ddx_avlv_rec.id);
1755 p6_a1 := rosetta_g_miss_num_map(ddx_avlv_rec.object_version_number);
1756 p6_a2 := rosetta_g_miss_num_map(ddx_avlv_rec.try_id);
1757 p6_a3 := rosetta_g_miss_num_map(ddx_avlv_rec.aes_id);
1758 p6_a4 := rosetta_g_miss_num_map(ddx_avlv_rec.sty_id);
1759 p6_a5 := rosetta_g_miss_num_map(ddx_avlv_rec.fma_id);
1760 p6_a6 := rosetta_g_miss_num_map(ddx_avlv_rec.set_of_books_id);
1761 p6_a7 := ddx_avlv_rec.fac_code;
1762 p6_a8 := ddx_avlv_rec.syt_code;
1763 p6_a9 := ddx_avlv_rec.post_to_gl;
1764 p6_a10 := ddx_avlv_rec.advance_arrears;
1765 p6_a11 := ddx_avlv_rec.memo_yn;
1766 p6_a12 := ddx_avlv_rec.prior_year_yn;
1767 p6_a13 := ddx_avlv_rec.name;
1768 p6_a14 := ddx_avlv_rec.description;
1769 p6_a15 := ddx_avlv_rec.version;
1770 p6_a16 := ddx_avlv_rec.factoring_synd_flag;
1771 p6_a17 := ddx_avlv_rec.start_date;
1772 p6_a18 := ddx_avlv_rec.end_date;
1773 p6_a19 := ddx_avlv_rec.accrual_yn;
1774 p6_a20 := ddx_avlv_rec.attribute_category;
1775 p6_a21 := ddx_avlv_rec.attribute1;
1776 p6_a22 := ddx_avlv_rec.attribute2;
1777 p6_a23 := ddx_avlv_rec.attribute3;
1778 p6_a24 := ddx_avlv_rec.attribute4;
1779 p6_a25 := ddx_avlv_rec.attribute5;
1780 p6_a26 := ddx_avlv_rec.attribute6;
1781 p6_a27 := ddx_avlv_rec.attribute7;
1782 p6_a28 := ddx_avlv_rec.attribute8;
1783 p6_a29 := ddx_avlv_rec.attribute9;
1784 p6_a30 := ddx_avlv_rec.attribute10;
1785 p6_a31 := ddx_avlv_rec.attribute11;
1786 p6_a32 := ddx_avlv_rec.attribute12;
1787 p6_a33 := ddx_avlv_rec.attribute13;
1788 p6_a34 := ddx_avlv_rec.attribute14;
1789 p6_a35 := ddx_avlv_rec.attribute15;
1790 p6_a36 := rosetta_g_miss_num_map(ddx_avlv_rec.org_id);
1791 p6_a37 := rosetta_g_miss_num_map(ddx_avlv_rec.created_by);
1792 p6_a38 := ddx_avlv_rec.creation_date;
1793 p6_a39 := rosetta_g_miss_num_map(ddx_avlv_rec.last_updated_by);
1794 p6_a40 := ddx_avlv_rec.last_update_date;
1795 p6_a41 := rosetta_g_miss_num_map(ddx_avlv_rec.last_update_login);
1796 p6_a42 := ddx_avlv_rec.inv_code;
1797 end;
1798
1799 procedure update_template(p_api_version NUMBER
1800 , p_init_msg_list VARCHAR2
1801 , x_return_status out nocopy VARCHAR2
1802 , x_msg_count out nocopy NUMBER
1803 , x_msg_data out nocopy VARCHAR2
1804 , p5_a0 JTF_NUMBER_TABLE
1805 , p5_a1 JTF_NUMBER_TABLE
1806 , p5_a2 JTF_NUMBER_TABLE
1807 , p5_a3 JTF_NUMBER_TABLE
1808 , p5_a4 JTF_NUMBER_TABLE
1809 , p5_a5 JTF_NUMBER_TABLE
1810 , p5_a6 JTF_NUMBER_TABLE
1811 , p5_a7 JTF_VARCHAR2_TABLE_100
1812 , p5_a8 JTF_VARCHAR2_TABLE_100
1813 , p5_a9 JTF_VARCHAR2_TABLE_100
1814 , p5_a10 JTF_VARCHAR2_TABLE_100
1815 , p5_a11 JTF_VARCHAR2_TABLE_100
1816 , p5_a12 JTF_VARCHAR2_TABLE_100
1817 , p5_a13 JTF_VARCHAR2_TABLE_200
1818 , p5_a14 JTF_VARCHAR2_TABLE_2000
1819 , p5_a15 JTF_VARCHAR2_TABLE_100
1820 , p5_a16 JTF_VARCHAR2_TABLE_100
1821 , p5_a17 JTF_DATE_TABLE
1822 , p5_a18 JTF_DATE_TABLE
1823 , p5_a19 JTF_VARCHAR2_TABLE_100
1824 , p5_a20 JTF_VARCHAR2_TABLE_100
1825 , p5_a21 JTF_VARCHAR2_TABLE_500
1826 , p5_a22 JTF_VARCHAR2_TABLE_500
1827 , p5_a23 JTF_VARCHAR2_TABLE_500
1828 , p5_a24 JTF_VARCHAR2_TABLE_500
1829 , p5_a25 JTF_VARCHAR2_TABLE_500
1830 , p5_a26 JTF_VARCHAR2_TABLE_500
1831 , p5_a27 JTF_VARCHAR2_TABLE_500
1832 , p5_a28 JTF_VARCHAR2_TABLE_500
1833 , p5_a29 JTF_VARCHAR2_TABLE_500
1834 , p5_a30 JTF_VARCHAR2_TABLE_500
1835 , p5_a31 JTF_VARCHAR2_TABLE_500
1836 , p5_a32 JTF_VARCHAR2_TABLE_500
1837 , p5_a33 JTF_VARCHAR2_TABLE_500
1838 , p5_a34 JTF_VARCHAR2_TABLE_500
1839 , p5_a35 JTF_VARCHAR2_TABLE_500
1840 , p5_a36 JTF_NUMBER_TABLE
1841 , p5_a37 JTF_NUMBER_TABLE
1842 , p5_a38 JTF_DATE_TABLE
1843 , p5_a39 JTF_NUMBER_TABLE
1844 , p5_a40 JTF_DATE_TABLE
1845 , p5_a41 JTF_NUMBER_TABLE
1846 , p5_a42 JTF_VARCHAR2_TABLE_100
1847 , p6_a0 out nocopy JTF_NUMBER_TABLE
1848 , p6_a1 out nocopy JTF_NUMBER_TABLE
1849 , p6_a2 out nocopy JTF_NUMBER_TABLE
1850 , p6_a3 out nocopy JTF_NUMBER_TABLE
1851 , p6_a4 out nocopy JTF_NUMBER_TABLE
1852 , p6_a5 out nocopy JTF_NUMBER_TABLE
1853 , p6_a6 out nocopy JTF_NUMBER_TABLE
1854 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1855 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1856 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1857 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1858 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1859 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1860 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
1861 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_2000
1862 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1863 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
1864 , p6_a17 out nocopy JTF_DATE_TABLE
1865 , p6_a18 out nocopy JTF_DATE_TABLE
1866 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
1867 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
1868 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1869 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1870 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1871 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1872 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1873 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1874 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1875 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1876 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
1877 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
1878 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
1879 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
1880 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
1881 , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
1882 , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
1883 , p6_a36 out nocopy JTF_NUMBER_TABLE
1884 , p6_a37 out nocopy JTF_NUMBER_TABLE
1885 , p6_a38 out nocopy JTF_DATE_TABLE
1886 , p6_a39 out nocopy JTF_NUMBER_TABLE
1887 , p6_a40 out nocopy JTF_DATE_TABLE
1888 , p6_a41 out nocopy JTF_NUMBER_TABLE
1889 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
1890 )
1891
1892 as
1893 ddp_avlv_tbl okl_process_tmpt_set_pub.avlv_tbl_type;
1894 ddx_avlv_tbl okl_process_tmpt_set_pub.avlv_tbl_type;
1895 ddindx binary_integer; indx binary_integer;
1896 begin
1897
1898 -- copy data to the local IN or IN-OUT args, if any
1899
1900
1901
1902
1903
1904 okl_avl_pvt_w.rosetta_table_copy_in_p5(ddp_avlv_tbl, p5_a0
1905 , p5_a1
1906 , p5_a2
1907 , p5_a3
1908 , p5_a4
1909 , p5_a5
1910 , p5_a6
1911 , p5_a7
1912 , p5_a8
1913 , p5_a9
1914 , p5_a10
1915 , p5_a11
1916 , p5_a12
1917 , p5_a13
1918 , p5_a14
1919 , p5_a15
1920 , p5_a16
1921 , p5_a17
1922 , p5_a18
1923 , p5_a19
1924 , p5_a20
1925 , p5_a21
1926 , p5_a22
1927 , p5_a23
1928 , p5_a24
1929 , p5_a25
1930 , p5_a26
1931 , p5_a27
1932 , p5_a28
1933 , p5_a29
1934 , p5_a30
1935 , p5_a31
1936 , p5_a32
1937 , p5_a33
1938 , p5_a34
1939 , p5_a35
1940 , p5_a36
1941 , p5_a37
1942 , p5_a38
1943 , p5_a39
1944 , p5_a40
1945 , p5_a41
1946 , p5_a42
1947 );
1948
1949
1950 -- here's the delegated call to the old PL/SQL routine
1951 okl_process_tmpt_set_pub.update_template(p_api_version,
1952 p_init_msg_list,
1953 x_return_status,
1954 x_msg_count,
1955 x_msg_data,
1956 ddp_avlv_tbl,
1957 ddx_avlv_tbl);
1958
1959 -- copy data back from the local variables to OUT or IN-OUT args, if any
1960
1961
1962
1963
1964
1965
1966 okl_avl_pvt_w.rosetta_table_copy_out_p5(ddx_avlv_tbl, p6_a0
1967 , p6_a1
1968 , p6_a2
1969 , p6_a3
1970 , p6_a4
1971 , p6_a5
1972 , p6_a6
1973 , p6_a7
1974 , p6_a8
1975 , p6_a9
1976 , p6_a10
1977 , p6_a11
1978 , p6_a12
1979 , p6_a13
1980 , p6_a14
1981 , p6_a15
1982 , p6_a16
1983 , p6_a17
1984 , p6_a18
1985 , p6_a19
1986 , p6_a20
1987 , p6_a21
1988 , p6_a22
1989 , p6_a23
1990 , p6_a24
1991 , p6_a25
1992 , p6_a26
1993 , p6_a27
1994 , p6_a28
1995 , p6_a29
1996 , p6_a30
1997 , p6_a31
1998 , p6_a32
1999 , p6_a33
2000 , p6_a34
2001 , p6_a35
2002 , p6_a36
2003 , p6_a37
2004 , p6_a38
2005 , p6_a39
2006 , p6_a40
2007 , p6_a41
2008 , p6_a42
2009 );
2010 end;
2011
2012 procedure update_template(p_api_version NUMBER
2013 , p_init_msg_list VARCHAR2
2014 , x_return_status out nocopy VARCHAR2
2015 , x_msg_count out nocopy NUMBER
2016 , x_msg_data out nocopy VARCHAR2
2017 , p6_a0 out nocopy NUMBER
2018 , p6_a1 out nocopy NUMBER
2019 , p6_a2 out nocopy NUMBER
2020 , p6_a3 out nocopy NUMBER
2021 , p6_a4 out nocopy NUMBER
2022 , p6_a5 out nocopy NUMBER
2023 , p6_a6 out nocopy NUMBER
2024 , p6_a7 out nocopy VARCHAR2
2025 , p6_a8 out nocopy VARCHAR2
2026 , p6_a9 out nocopy VARCHAR2
2027 , p6_a10 out nocopy VARCHAR2
2028 , p6_a11 out nocopy VARCHAR2
2029 , p6_a12 out nocopy VARCHAR2
2030 , p6_a13 out nocopy VARCHAR2
2031 , p6_a14 out nocopy VARCHAR2
2032 , p6_a15 out nocopy VARCHAR2
2033 , p6_a16 out nocopy VARCHAR2
2034 , p6_a17 out nocopy DATE
2035 , p6_a18 out nocopy DATE
2036 , p6_a19 out nocopy VARCHAR2
2037 , p6_a20 out nocopy VARCHAR2
2038 , p6_a21 out nocopy VARCHAR2
2039 , p6_a22 out nocopy VARCHAR2
2040 , p6_a23 out nocopy VARCHAR2
2041 , p6_a24 out nocopy VARCHAR2
2042 , p6_a25 out nocopy VARCHAR2
2043 , p6_a26 out nocopy VARCHAR2
2044 , p6_a27 out nocopy VARCHAR2
2045 , p6_a28 out nocopy VARCHAR2
2046 , p6_a29 out nocopy VARCHAR2
2047 , p6_a30 out nocopy VARCHAR2
2048 , p6_a31 out nocopy VARCHAR2
2049 , p6_a32 out nocopy VARCHAR2
2050 , p6_a33 out nocopy VARCHAR2
2051 , p6_a34 out nocopy VARCHAR2
2052 , p6_a35 out nocopy VARCHAR2
2053 , p6_a36 out nocopy NUMBER
2054 , p6_a37 out nocopy NUMBER
2055 , p6_a38 out nocopy DATE
2056 , p6_a39 out nocopy NUMBER
2057 , p6_a40 out nocopy DATE
2058 , p6_a41 out nocopy NUMBER
2059 , p6_a42 out nocopy VARCHAR2
2060 , p5_a0 NUMBER := 0-1962.0724
2061 , p5_a1 NUMBER := 0-1962.0724
2062 , p5_a2 NUMBER := 0-1962.0724
2063 , p5_a3 NUMBER := 0-1962.0724
2064 , p5_a4 NUMBER := 0-1962.0724
2065 , p5_a5 NUMBER := 0-1962.0724
2066 , p5_a6 NUMBER := 0-1962.0724
2067 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2068 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2069 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2070 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2071 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2072 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2073 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2074 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2075 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2076 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2077 , p5_a17 DATE := fnd_api.g_miss_date
2078 , p5_a18 DATE := fnd_api.g_miss_date
2079 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2080 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2081 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2082 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2083 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2084 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2085 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2086 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2087 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2088 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2089 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2090 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2091 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2092 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2093 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2094 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
2095 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
2096 , p5_a36 NUMBER := 0-1962.0724
2097 , p5_a37 NUMBER := 0-1962.0724
2098 , p5_a38 DATE := fnd_api.g_miss_date
2099 , p5_a39 NUMBER := 0-1962.0724
2100 , p5_a40 DATE := fnd_api.g_miss_date
2101 , p5_a41 NUMBER := 0-1962.0724
2102 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
2103 )
2104
2105 as
2106 ddp_avlv_rec okl_process_tmpt_set_pub.avlv_rec_type;
2107 ddx_avlv_rec okl_process_tmpt_set_pub.avlv_rec_type;
2108 ddindx binary_integer; indx binary_integer;
2109 begin
2110
2111 -- copy data to the local IN or IN-OUT args, if any
2112
2113
2114
2115
2116
2117 ddp_avlv_rec.id := rosetta_g_miss_num_map(p5_a0);
2118 ddp_avlv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
2119 ddp_avlv_rec.try_id := rosetta_g_miss_num_map(p5_a2);
2120 ddp_avlv_rec.aes_id := rosetta_g_miss_num_map(p5_a3);
2121 ddp_avlv_rec.sty_id := rosetta_g_miss_num_map(p5_a4);
2122 ddp_avlv_rec.fma_id := rosetta_g_miss_num_map(p5_a5);
2123 ddp_avlv_rec.set_of_books_id := rosetta_g_miss_num_map(p5_a6);
2124 ddp_avlv_rec.fac_code := p5_a7;
2125 ddp_avlv_rec.syt_code := p5_a8;
2126 ddp_avlv_rec.post_to_gl := p5_a9;
2127 ddp_avlv_rec.advance_arrears := p5_a10;
2128 ddp_avlv_rec.memo_yn := p5_a11;
2129 ddp_avlv_rec.prior_year_yn := p5_a12;
2130 ddp_avlv_rec.name := p5_a13;
2131 ddp_avlv_rec.description := p5_a14;
2132 ddp_avlv_rec.version := p5_a15;
2133 ddp_avlv_rec.factoring_synd_flag := p5_a16;
2134 ddp_avlv_rec.start_date := rosetta_g_miss_date_in_map(p5_a17);
2135 ddp_avlv_rec.end_date := rosetta_g_miss_date_in_map(p5_a18);
2136 ddp_avlv_rec.accrual_yn := p5_a19;
2137 ddp_avlv_rec.attribute_category := p5_a20;
2138 ddp_avlv_rec.attribute1 := p5_a21;
2139 ddp_avlv_rec.attribute2 := p5_a22;
2140 ddp_avlv_rec.attribute3 := p5_a23;
2141 ddp_avlv_rec.attribute4 := p5_a24;
2142 ddp_avlv_rec.attribute5 := p5_a25;
2143 ddp_avlv_rec.attribute6 := p5_a26;
2144 ddp_avlv_rec.attribute7 := p5_a27;
2145 ddp_avlv_rec.attribute8 := p5_a28;
2146 ddp_avlv_rec.attribute9 := p5_a29;
2147 ddp_avlv_rec.attribute10 := p5_a30;
2148 ddp_avlv_rec.attribute11 := p5_a31;
2149 ddp_avlv_rec.attribute12 := p5_a32;
2150 ddp_avlv_rec.attribute13 := p5_a33;
2151 ddp_avlv_rec.attribute14 := p5_a34;
2152 ddp_avlv_rec.attribute15 := p5_a35;
2153 ddp_avlv_rec.org_id := rosetta_g_miss_num_map(p5_a36);
2154 ddp_avlv_rec.created_by := rosetta_g_miss_num_map(p5_a37);
2155 ddp_avlv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a38);
2156 ddp_avlv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a39);
2157 ddp_avlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a40);
2158 ddp_avlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a41);
2159 ddp_avlv_rec.inv_code := p5_a42;
2160
2161
2162 -- here's the delegated call to the old PL/SQL routine
2163 okl_process_tmpt_set_pub.update_template(p_api_version,
2164 p_init_msg_list,
2165 x_return_status,
2166 x_msg_count,
2167 x_msg_data,
2168 ddp_avlv_rec,
2169 ddx_avlv_rec);
2170
2171 -- copy data back from the local variables to OUT or IN-OUT args, if any
2172
2173
2174
2175
2176
2177
2178 p6_a0 := rosetta_g_miss_num_map(ddx_avlv_rec.id);
2179 p6_a1 := rosetta_g_miss_num_map(ddx_avlv_rec.object_version_number);
2180 p6_a2 := rosetta_g_miss_num_map(ddx_avlv_rec.try_id);
2181 p6_a3 := rosetta_g_miss_num_map(ddx_avlv_rec.aes_id);
2182 p6_a4 := rosetta_g_miss_num_map(ddx_avlv_rec.sty_id);
2183 p6_a5 := rosetta_g_miss_num_map(ddx_avlv_rec.fma_id);
2184 p6_a6 := rosetta_g_miss_num_map(ddx_avlv_rec.set_of_books_id);
2185 p6_a7 := ddx_avlv_rec.fac_code;
2186 p6_a8 := ddx_avlv_rec.syt_code;
2187 p6_a9 := ddx_avlv_rec.post_to_gl;
2188 p6_a10 := ddx_avlv_rec.advance_arrears;
2189 p6_a11 := ddx_avlv_rec.memo_yn;
2190 p6_a12 := ddx_avlv_rec.prior_year_yn;
2191 p6_a13 := ddx_avlv_rec.name;
2192 p6_a14 := ddx_avlv_rec.description;
2193 p6_a15 := ddx_avlv_rec.version;
2194 p6_a16 := ddx_avlv_rec.factoring_synd_flag;
2195 p6_a17 := ddx_avlv_rec.start_date;
2196 p6_a18 := ddx_avlv_rec.end_date;
2197 p6_a19 := ddx_avlv_rec.accrual_yn;
2198 p6_a20 := ddx_avlv_rec.attribute_category;
2199 p6_a21 := ddx_avlv_rec.attribute1;
2200 p6_a22 := ddx_avlv_rec.attribute2;
2201 p6_a23 := ddx_avlv_rec.attribute3;
2202 p6_a24 := ddx_avlv_rec.attribute4;
2203 p6_a25 := ddx_avlv_rec.attribute5;
2204 p6_a26 := ddx_avlv_rec.attribute6;
2205 p6_a27 := ddx_avlv_rec.attribute7;
2206 p6_a28 := ddx_avlv_rec.attribute8;
2207 p6_a29 := ddx_avlv_rec.attribute9;
2208 p6_a30 := ddx_avlv_rec.attribute10;
2209 p6_a31 := ddx_avlv_rec.attribute11;
2210 p6_a32 := ddx_avlv_rec.attribute12;
2211 p6_a33 := ddx_avlv_rec.attribute13;
2212 p6_a34 := ddx_avlv_rec.attribute14;
2213 p6_a35 := ddx_avlv_rec.attribute15;
2214 p6_a36 := rosetta_g_miss_num_map(ddx_avlv_rec.org_id);
2215 p6_a37 := rosetta_g_miss_num_map(ddx_avlv_rec.created_by);
2216 p6_a38 := ddx_avlv_rec.creation_date;
2217 p6_a39 := rosetta_g_miss_num_map(ddx_avlv_rec.last_updated_by);
2218 p6_a40 := ddx_avlv_rec.last_update_date;
2219 p6_a41 := rosetta_g_miss_num_map(ddx_avlv_rec.last_update_login);
2220 p6_a42 := ddx_avlv_rec.inv_code;
2221 end;
2222
2223 procedure delete_template(p_api_version NUMBER
2224 , p_init_msg_list VARCHAR2
2225 , x_return_status out nocopy VARCHAR2
2226 , x_msg_count out nocopy NUMBER
2227 , x_msg_data out nocopy VARCHAR2
2228 , p5_a0 JTF_NUMBER_TABLE
2229 , p5_a1 JTF_NUMBER_TABLE
2230 , p5_a2 JTF_NUMBER_TABLE
2231 , p5_a3 JTF_NUMBER_TABLE
2232 , p5_a4 JTF_NUMBER_TABLE
2233 , p5_a5 JTF_NUMBER_TABLE
2234 , p5_a6 JTF_NUMBER_TABLE
2235 , p5_a7 JTF_VARCHAR2_TABLE_100
2236 , p5_a8 JTF_VARCHAR2_TABLE_100
2237 , p5_a9 JTF_VARCHAR2_TABLE_100
2238 , p5_a10 JTF_VARCHAR2_TABLE_100
2239 , p5_a11 JTF_VARCHAR2_TABLE_100
2240 , p5_a12 JTF_VARCHAR2_TABLE_100
2241 , p5_a13 JTF_VARCHAR2_TABLE_200
2242 , p5_a14 JTF_VARCHAR2_TABLE_2000
2243 , p5_a15 JTF_VARCHAR2_TABLE_100
2244 , p5_a16 JTF_VARCHAR2_TABLE_100
2245 , p5_a17 JTF_DATE_TABLE
2246 , p5_a18 JTF_DATE_TABLE
2247 , p5_a19 JTF_VARCHAR2_TABLE_100
2248 , p5_a20 JTF_VARCHAR2_TABLE_100
2249 , p5_a21 JTF_VARCHAR2_TABLE_500
2250 , p5_a22 JTF_VARCHAR2_TABLE_500
2251 , p5_a23 JTF_VARCHAR2_TABLE_500
2252 , p5_a24 JTF_VARCHAR2_TABLE_500
2253 , p5_a25 JTF_VARCHAR2_TABLE_500
2254 , p5_a26 JTF_VARCHAR2_TABLE_500
2255 , p5_a27 JTF_VARCHAR2_TABLE_500
2256 , p5_a28 JTF_VARCHAR2_TABLE_500
2257 , p5_a29 JTF_VARCHAR2_TABLE_500
2258 , p5_a30 JTF_VARCHAR2_TABLE_500
2259 , p5_a31 JTF_VARCHAR2_TABLE_500
2260 , p5_a32 JTF_VARCHAR2_TABLE_500
2261 , p5_a33 JTF_VARCHAR2_TABLE_500
2262 , p5_a34 JTF_VARCHAR2_TABLE_500
2263 , p5_a35 JTF_VARCHAR2_TABLE_500
2264 , p5_a36 JTF_NUMBER_TABLE
2265 , p5_a37 JTF_NUMBER_TABLE
2266 , p5_a38 JTF_DATE_TABLE
2267 , p5_a39 JTF_NUMBER_TABLE
2268 , p5_a40 JTF_DATE_TABLE
2269 , p5_a41 JTF_NUMBER_TABLE
2270 , p5_a42 JTF_VARCHAR2_TABLE_100
2271 )
2272
2273 as
2274 ddp_avlv_tbl okl_process_tmpt_set_pub.avlv_tbl_type;
2275 ddindx binary_integer; indx binary_integer;
2276 begin
2277
2278 -- copy data to the local IN or IN-OUT args, if any
2279
2280
2281
2282
2283
2284 okl_avl_pvt_w.rosetta_table_copy_in_p5(ddp_avlv_tbl, p5_a0
2285 , p5_a1
2286 , p5_a2
2287 , p5_a3
2288 , p5_a4
2289 , p5_a5
2290 , p5_a6
2291 , p5_a7
2292 , p5_a8
2293 , p5_a9
2294 , p5_a10
2295 , p5_a11
2296 , p5_a12
2297 , p5_a13
2298 , p5_a14
2299 , p5_a15
2300 , p5_a16
2301 , p5_a17
2302 , p5_a18
2303 , p5_a19
2304 , p5_a20
2305 , p5_a21
2306 , p5_a22
2307 , p5_a23
2308 , p5_a24
2309 , p5_a25
2310 , p5_a26
2311 , p5_a27
2312 , p5_a28
2313 , p5_a29
2314 , p5_a30
2315 , p5_a31
2316 , p5_a32
2317 , p5_a33
2318 , p5_a34
2319 , p5_a35
2320 , p5_a36
2321 , p5_a37
2322 , p5_a38
2323 , p5_a39
2324 , p5_a40
2325 , p5_a41
2326 , p5_a42
2327 );
2328
2329 -- here's the delegated call to the old PL/SQL routine
2330 okl_process_tmpt_set_pub.delete_template(p_api_version,
2331 p_init_msg_list,
2332 x_return_status,
2333 x_msg_count,
2334 x_msg_data,
2335 ddp_avlv_tbl);
2336
2337 -- copy data back from the local variables to OUT or IN-OUT args, if any
2338
2339
2340
2341
2342
2343 end;
2344
2345 procedure delete_template(p_api_version NUMBER
2346 , p_init_msg_list VARCHAR2
2347 , x_return_status out nocopy VARCHAR2
2348 , x_msg_count out nocopy NUMBER
2349 , x_msg_data out nocopy VARCHAR2
2350 , p5_a0 NUMBER := 0-1962.0724
2351 , p5_a1 NUMBER := 0-1962.0724
2352 , p5_a2 NUMBER := 0-1962.0724
2353 , p5_a3 NUMBER := 0-1962.0724
2354 , p5_a4 NUMBER := 0-1962.0724
2355 , p5_a5 NUMBER := 0-1962.0724
2356 , p5_a6 NUMBER := 0-1962.0724
2357 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2358 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2359 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2360 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2361 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2362 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2363 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2364 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2365 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2366 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2367 , p5_a17 DATE := fnd_api.g_miss_date
2368 , p5_a18 DATE := fnd_api.g_miss_date
2369 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2370 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2371 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2372 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2373 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2374 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2375 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2376 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2377 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2378 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2379 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2380 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2381 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2382 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2383 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2384 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
2385 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
2386 , p5_a36 NUMBER := 0-1962.0724
2387 , p5_a37 NUMBER := 0-1962.0724
2388 , p5_a38 DATE := fnd_api.g_miss_date
2389 , p5_a39 NUMBER := 0-1962.0724
2390 , p5_a40 DATE := fnd_api.g_miss_date
2391 , p5_a41 NUMBER := 0-1962.0724
2392 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
2393 )
2394
2395 as
2396 ddp_avlv_rec okl_process_tmpt_set_pub.avlv_rec_type;
2397 ddindx binary_integer; indx binary_integer;
2398 begin
2399
2400 -- copy data to the local IN or IN-OUT args, if any
2401
2402
2403
2404
2405
2406 ddp_avlv_rec.id := rosetta_g_miss_num_map(p5_a0);
2407 ddp_avlv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
2408 ddp_avlv_rec.try_id := rosetta_g_miss_num_map(p5_a2);
2409 ddp_avlv_rec.aes_id := rosetta_g_miss_num_map(p5_a3);
2410 ddp_avlv_rec.sty_id := rosetta_g_miss_num_map(p5_a4);
2411 ddp_avlv_rec.fma_id := rosetta_g_miss_num_map(p5_a5);
2412 ddp_avlv_rec.set_of_books_id := rosetta_g_miss_num_map(p5_a6);
2413 ddp_avlv_rec.fac_code := p5_a7;
2414 ddp_avlv_rec.syt_code := p5_a8;
2415 ddp_avlv_rec.post_to_gl := p5_a9;
2416 ddp_avlv_rec.advance_arrears := p5_a10;
2417 ddp_avlv_rec.memo_yn := p5_a11;
2418 ddp_avlv_rec.prior_year_yn := p5_a12;
2419 ddp_avlv_rec.name := p5_a13;
2420 ddp_avlv_rec.description := p5_a14;
2421 ddp_avlv_rec.version := p5_a15;
2422 ddp_avlv_rec.factoring_synd_flag := p5_a16;
2423 ddp_avlv_rec.start_date := rosetta_g_miss_date_in_map(p5_a17);
2424 ddp_avlv_rec.end_date := rosetta_g_miss_date_in_map(p5_a18);
2425 ddp_avlv_rec.accrual_yn := p5_a19;
2426 ddp_avlv_rec.attribute_category := p5_a20;
2427 ddp_avlv_rec.attribute1 := p5_a21;
2428 ddp_avlv_rec.attribute2 := p5_a22;
2429 ddp_avlv_rec.attribute3 := p5_a23;
2430 ddp_avlv_rec.attribute4 := p5_a24;
2431 ddp_avlv_rec.attribute5 := p5_a25;
2432 ddp_avlv_rec.attribute6 := p5_a26;
2433 ddp_avlv_rec.attribute7 := p5_a27;
2434 ddp_avlv_rec.attribute8 := p5_a28;
2435 ddp_avlv_rec.attribute9 := p5_a29;
2436 ddp_avlv_rec.attribute10 := p5_a30;
2437 ddp_avlv_rec.attribute11 := p5_a31;
2438 ddp_avlv_rec.attribute12 := p5_a32;
2439 ddp_avlv_rec.attribute13 := p5_a33;
2440 ddp_avlv_rec.attribute14 := p5_a34;
2441 ddp_avlv_rec.attribute15 := p5_a35;
2442 ddp_avlv_rec.org_id := rosetta_g_miss_num_map(p5_a36);
2443 ddp_avlv_rec.created_by := rosetta_g_miss_num_map(p5_a37);
2444 ddp_avlv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a38);
2445 ddp_avlv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a39);
2446 ddp_avlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a40);
2447 ddp_avlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a41);
2448 ddp_avlv_rec.inv_code := p5_a42;
2449
2450 -- here's the delegated call to the old PL/SQL routine
2451 okl_process_tmpt_set_pub.delete_template(p_api_version,
2452 p_init_msg_list,
2453 x_return_status,
2454 x_msg_count,
2455 x_msg_data,
2456 ddp_avlv_rec);
2457
2458 -- copy data back from the local variables to OUT or IN-OUT args, if any
2459
2460
2461
2462
2463
2464 end;
2465
2466 procedure create_tmpt_lines(p_api_version NUMBER
2467 , p_init_msg_list VARCHAR2
2468 , x_return_status out nocopy VARCHAR2
2469 , x_msg_count out nocopy NUMBER
2470 , x_msg_data out nocopy VARCHAR2
2471 , p5_a0 JTF_NUMBER_TABLE
2472 , p5_a1 JTF_NUMBER_TABLE
2473 , p5_a2 JTF_NUMBER_TABLE
2474 , p5_a3 JTF_VARCHAR2_TABLE_100
2475 , p5_a4 JTF_NUMBER_TABLE
2476 , p5_a5 JTF_VARCHAR2_TABLE_100
2477 , p5_a6 JTF_NUMBER_TABLE
2478 , p5_a7 JTF_VARCHAR2_TABLE_2000
2479 , p5_a8 JTF_NUMBER_TABLE
2480 , p5_a9 JTF_VARCHAR2_TABLE_100
2481 , p5_a10 JTF_VARCHAR2_TABLE_100
2482 , p5_a11 JTF_VARCHAR2_TABLE_500
2483 , p5_a12 JTF_VARCHAR2_TABLE_500
2484 , p5_a13 JTF_VARCHAR2_TABLE_500
2485 , p5_a14 JTF_VARCHAR2_TABLE_500
2486 , p5_a15 JTF_VARCHAR2_TABLE_500
2487 , p5_a16 JTF_VARCHAR2_TABLE_500
2488 , p5_a17 JTF_VARCHAR2_TABLE_500
2489 , p5_a18 JTF_VARCHAR2_TABLE_500
2490 , p5_a19 JTF_VARCHAR2_TABLE_500
2491 , p5_a20 JTF_VARCHAR2_TABLE_500
2492 , p5_a21 JTF_VARCHAR2_TABLE_500
2493 , p5_a22 JTF_VARCHAR2_TABLE_500
2494 , p5_a23 JTF_VARCHAR2_TABLE_500
2495 , p5_a24 JTF_VARCHAR2_TABLE_500
2496 , p5_a25 JTF_VARCHAR2_TABLE_500
2497 , p5_a26 JTF_NUMBER_TABLE
2498 , p5_a27 JTF_NUMBER_TABLE
2499 , p5_a28 JTF_NUMBER_TABLE
2500 , p5_a29 JTF_DATE_TABLE
2501 , p5_a30 JTF_NUMBER_TABLE
2502 , p5_a31 JTF_DATE_TABLE
2503 , p5_a32 JTF_NUMBER_TABLE
2504 , p6_a0 out nocopy JTF_NUMBER_TABLE
2505 , p6_a1 out nocopy JTF_NUMBER_TABLE
2506 , p6_a2 out nocopy JTF_NUMBER_TABLE
2507 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
2508 , p6_a4 out nocopy JTF_NUMBER_TABLE
2509 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
2510 , p6_a6 out nocopy JTF_NUMBER_TABLE
2511 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
2512 , p6_a8 out nocopy JTF_NUMBER_TABLE
2513 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
2514 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
2515 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
2516 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
2517 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
2518 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
2519 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
2520 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
2521 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
2522 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
2523 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
2524 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
2525 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
2526 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
2527 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
2528 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
2529 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
2530 , p6_a26 out nocopy JTF_NUMBER_TABLE
2531 , p6_a27 out nocopy JTF_NUMBER_TABLE
2532 , p6_a28 out nocopy JTF_NUMBER_TABLE
2533 , p6_a29 out nocopy JTF_DATE_TABLE
2534 , p6_a30 out nocopy JTF_NUMBER_TABLE
2535 , p6_a31 out nocopy JTF_DATE_TABLE
2536 , p6_a32 out nocopy JTF_NUMBER_TABLE
2537 )
2538
2539 as
2540 ddp_atlv_tbl okl_process_tmpt_set_pub.atlv_tbl_type;
2541 ddx_atlv_tbl okl_process_tmpt_set_pub.atlv_tbl_type;
2542 ddindx binary_integer; indx binary_integer;
2543 begin
2544
2545 -- copy data to the local IN or IN-OUT args, if any
2546
2547
2548
2549
2550
2551 okl_atl_pvt_w.rosetta_table_copy_in_p5(ddp_atlv_tbl, p5_a0
2552 , p5_a1
2553 , p5_a2
2554 , p5_a3
2555 , p5_a4
2556 , p5_a5
2557 , p5_a6
2558 , p5_a7
2559 , p5_a8
2560 , p5_a9
2561 , p5_a10
2562 , p5_a11
2563 , p5_a12
2564 , p5_a13
2565 , p5_a14
2566 , p5_a15
2567 , p5_a16
2568 , p5_a17
2569 , p5_a18
2570 , p5_a19
2571 , p5_a20
2572 , p5_a21
2573 , p5_a22
2574 , p5_a23
2575 , p5_a24
2576 , p5_a25
2577 , p5_a26
2578 , p5_a27
2579 , p5_a28
2580 , p5_a29
2581 , p5_a30
2582 , p5_a31
2583 , p5_a32
2584 );
2585
2586
2587 -- here's the delegated call to the old PL/SQL routine
2588 okl_process_tmpt_set_pub.create_tmpt_lines(p_api_version,
2589 p_init_msg_list,
2590 x_return_status,
2591 x_msg_count,
2592 x_msg_data,
2593 ddp_atlv_tbl,
2594 ddx_atlv_tbl);
2595
2596 -- copy data back from the local variables to OUT or IN-OUT args, if any
2597
2598
2599
2600
2601
2602
2603 okl_atl_pvt_w.rosetta_table_copy_out_p5(ddx_atlv_tbl, p6_a0
2604 , p6_a1
2605 , p6_a2
2606 , p6_a3
2607 , p6_a4
2608 , p6_a5
2609 , p6_a6
2610 , p6_a7
2611 , p6_a8
2612 , p6_a9
2613 , p6_a10
2614 , p6_a11
2615 , p6_a12
2616 , p6_a13
2617 , p6_a14
2618 , p6_a15
2619 , p6_a16
2620 , p6_a17
2621 , p6_a18
2622 , p6_a19
2623 , p6_a20
2624 , p6_a21
2625 , p6_a22
2626 , p6_a23
2627 , p6_a24
2628 , p6_a25
2629 , p6_a26
2630 , p6_a27
2631 , p6_a28
2632 , p6_a29
2633 , p6_a30
2634 , p6_a31
2635 , p6_a32
2636 );
2637 end;
2638
2639 procedure create_tmpt_lines(p_api_version NUMBER
2640 , p_init_msg_list VARCHAR2
2641 , x_return_status out nocopy VARCHAR2
2642 , x_msg_count out nocopy NUMBER
2643 , x_msg_data out nocopy VARCHAR2
2644 , p6_a0 out nocopy NUMBER
2645 , p6_a1 out nocopy NUMBER
2646 , p6_a2 out nocopy NUMBER
2647 , p6_a3 out nocopy VARCHAR2
2648 , p6_a4 out nocopy NUMBER
2649 , p6_a5 out nocopy VARCHAR2
2650 , p6_a6 out nocopy NUMBER
2651 , p6_a7 out nocopy VARCHAR2
2652 , p6_a8 out nocopy NUMBER
2653 , p6_a9 out nocopy VARCHAR2
2654 , p6_a10 out nocopy VARCHAR2
2655 , p6_a11 out nocopy VARCHAR2
2656 , p6_a12 out nocopy VARCHAR2
2657 , p6_a13 out nocopy VARCHAR2
2658 , p6_a14 out nocopy VARCHAR2
2659 , p6_a15 out nocopy VARCHAR2
2660 , p6_a16 out nocopy VARCHAR2
2661 , p6_a17 out nocopy VARCHAR2
2662 , p6_a18 out nocopy VARCHAR2
2663 , p6_a19 out nocopy VARCHAR2
2664 , p6_a20 out nocopy VARCHAR2
2665 , p6_a21 out nocopy VARCHAR2
2666 , p6_a22 out nocopy VARCHAR2
2667 , p6_a23 out nocopy VARCHAR2
2668 , p6_a24 out nocopy VARCHAR2
2669 , p6_a25 out nocopy VARCHAR2
2670 , p6_a26 out nocopy NUMBER
2671 , p6_a27 out nocopy NUMBER
2672 , p6_a28 out nocopy NUMBER
2673 , p6_a29 out nocopy DATE
2674 , p6_a30 out nocopy NUMBER
2675 , p6_a31 out nocopy DATE
2676 , p6_a32 out nocopy NUMBER
2677 , p5_a0 NUMBER := 0-1962.0724
2678 , p5_a1 NUMBER := 0-1962.0724
2679 , p5_a2 NUMBER := 0-1962.0724
2680 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2681 , p5_a4 NUMBER := 0-1962.0724
2682 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2683 , p5_a6 NUMBER := 0-1962.0724
2684 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2685 , p5_a8 NUMBER := 0-1962.0724
2686 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2687 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2688 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2689 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2690 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2691 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2692 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2693 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2694 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2695 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2696 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2697 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2698 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2699 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2700 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2701 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2702 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2703 , p5_a26 NUMBER := 0-1962.0724
2704 , p5_a27 NUMBER := 0-1962.0724
2705 , p5_a28 NUMBER := 0-1962.0724
2706 , p5_a29 DATE := fnd_api.g_miss_date
2707 , p5_a30 NUMBER := 0-1962.0724
2708 , p5_a31 DATE := fnd_api.g_miss_date
2709 , p5_a32 NUMBER := 0-1962.0724
2710 )
2711
2712 as
2713 ddp_atlv_rec okl_process_tmpt_set_pub.atlv_rec_type;
2714 ddx_atlv_rec okl_process_tmpt_set_pub.atlv_rec_type;
2715 ddindx binary_integer; indx binary_integer;
2716 begin
2717
2718 -- copy data to the local IN or IN-OUT args, if any
2719
2720
2721
2722
2723
2724 ddp_atlv_rec.id := rosetta_g_miss_num_map(p5_a0);
2725 ddp_atlv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
2726 ddp_atlv_rec.avl_id := rosetta_g_miss_num_map(p5_a2);
2727 ddp_atlv_rec.crd_code := p5_a3;
2728 ddp_atlv_rec.code_combination_id := rosetta_g_miss_num_map(p5_a4);
2729 ddp_atlv_rec.ae_line_type := p5_a5;
2730 ddp_atlv_rec.sequence_number := rosetta_g_miss_num_map(p5_a6);
2731 ddp_atlv_rec.description := p5_a7;
2732 ddp_atlv_rec.percentage := rosetta_g_miss_num_map(p5_a8);
2733 ddp_atlv_rec.account_builder_yn := p5_a9;
2734 ddp_atlv_rec.attribute_category := p5_a10;
2735 ddp_atlv_rec.attribute1 := p5_a11;
2736 ddp_atlv_rec.attribute2 := p5_a12;
2737 ddp_atlv_rec.attribute3 := p5_a13;
2738 ddp_atlv_rec.attribute4 := p5_a14;
2739 ddp_atlv_rec.attribute5 := p5_a15;
2740 ddp_atlv_rec.attribute6 := p5_a16;
2741 ddp_atlv_rec.attribute7 := p5_a17;
2742 ddp_atlv_rec.attribute8 := p5_a18;
2743 ddp_atlv_rec.attribute9 := p5_a19;
2744 ddp_atlv_rec.attribute10 := p5_a20;
2745 ddp_atlv_rec.attribute11 := p5_a21;
2746 ddp_atlv_rec.attribute12 := p5_a22;
2747 ddp_atlv_rec.attribute13 := p5_a23;
2748 ddp_atlv_rec.attribute14 := p5_a24;
2749 ddp_atlv_rec.attribute15 := p5_a25;
2750 ddp_atlv_rec.avl_tbl_index := rosetta_g_miss_num_map(p5_a26);
2751 ddp_atlv_rec.org_id := rosetta_g_miss_num_map(p5_a27);
2752 ddp_atlv_rec.created_by := rosetta_g_miss_num_map(p5_a28);
2753 ddp_atlv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a29);
2754 ddp_atlv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a30);
2755 ddp_atlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a31);
2756 ddp_atlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a32);
2757
2758
2759 -- here's the delegated call to the old PL/SQL routine
2760 okl_process_tmpt_set_pub.create_tmpt_lines(p_api_version,
2761 p_init_msg_list,
2762 x_return_status,
2763 x_msg_count,
2764 x_msg_data,
2765 ddp_atlv_rec,
2766 ddx_atlv_rec);
2767
2768 -- copy data back from the local variables to OUT or IN-OUT args, if any
2769
2770
2771
2772
2773
2774
2775 p6_a0 := rosetta_g_miss_num_map(ddx_atlv_rec.id);
2776 p6_a1 := rosetta_g_miss_num_map(ddx_atlv_rec.object_version_number);
2777 p6_a2 := rosetta_g_miss_num_map(ddx_atlv_rec.avl_id);
2778 p6_a3 := ddx_atlv_rec.crd_code;
2779 p6_a4 := rosetta_g_miss_num_map(ddx_atlv_rec.code_combination_id);
2780 p6_a5 := ddx_atlv_rec.ae_line_type;
2781 p6_a6 := rosetta_g_miss_num_map(ddx_atlv_rec.sequence_number);
2782 p6_a7 := ddx_atlv_rec.description;
2783 p6_a8 := rosetta_g_miss_num_map(ddx_atlv_rec.percentage);
2784 p6_a9 := ddx_atlv_rec.account_builder_yn;
2785 p6_a10 := ddx_atlv_rec.attribute_category;
2786 p6_a11 := ddx_atlv_rec.attribute1;
2787 p6_a12 := ddx_atlv_rec.attribute2;
2788 p6_a13 := ddx_atlv_rec.attribute3;
2789 p6_a14 := ddx_atlv_rec.attribute4;
2790 p6_a15 := ddx_atlv_rec.attribute5;
2791 p6_a16 := ddx_atlv_rec.attribute6;
2792 p6_a17 := ddx_atlv_rec.attribute7;
2793 p6_a18 := ddx_atlv_rec.attribute8;
2794 p6_a19 := ddx_atlv_rec.attribute9;
2795 p6_a20 := ddx_atlv_rec.attribute10;
2796 p6_a21 := ddx_atlv_rec.attribute11;
2797 p6_a22 := ddx_atlv_rec.attribute12;
2798 p6_a23 := ddx_atlv_rec.attribute13;
2799 p6_a24 := ddx_atlv_rec.attribute14;
2800 p6_a25 := ddx_atlv_rec.attribute15;
2801 p6_a26 := rosetta_g_miss_num_map(ddx_atlv_rec.avl_tbl_index);
2802 p6_a27 := rosetta_g_miss_num_map(ddx_atlv_rec.org_id);
2803 p6_a28 := rosetta_g_miss_num_map(ddx_atlv_rec.created_by);
2804 p6_a29 := ddx_atlv_rec.creation_date;
2805 p6_a30 := rosetta_g_miss_num_map(ddx_atlv_rec.last_updated_by);
2806 p6_a31 := ddx_atlv_rec.last_update_date;
2807 p6_a32 := rosetta_g_miss_num_map(ddx_atlv_rec.last_update_login);
2808 end;
2809
2810 procedure update_tmpt_lines(p_api_version NUMBER
2811 , p_init_msg_list VARCHAR2
2812 , x_return_status out nocopy VARCHAR2
2813 , x_msg_count out nocopy NUMBER
2814 , x_msg_data out nocopy VARCHAR2
2815 , p5_a0 JTF_NUMBER_TABLE
2816 , p5_a1 JTF_NUMBER_TABLE
2817 , p5_a2 JTF_NUMBER_TABLE
2818 , p5_a3 JTF_VARCHAR2_TABLE_100
2819 , p5_a4 JTF_NUMBER_TABLE
2820 , p5_a5 JTF_VARCHAR2_TABLE_100
2821 , p5_a6 JTF_NUMBER_TABLE
2822 , p5_a7 JTF_VARCHAR2_TABLE_2000
2823 , p5_a8 JTF_NUMBER_TABLE
2824 , p5_a9 JTF_VARCHAR2_TABLE_100
2825 , p5_a10 JTF_VARCHAR2_TABLE_100
2826 , p5_a11 JTF_VARCHAR2_TABLE_500
2827 , p5_a12 JTF_VARCHAR2_TABLE_500
2828 , p5_a13 JTF_VARCHAR2_TABLE_500
2829 , p5_a14 JTF_VARCHAR2_TABLE_500
2830 , p5_a15 JTF_VARCHAR2_TABLE_500
2831 , p5_a16 JTF_VARCHAR2_TABLE_500
2832 , p5_a17 JTF_VARCHAR2_TABLE_500
2833 , p5_a18 JTF_VARCHAR2_TABLE_500
2834 , p5_a19 JTF_VARCHAR2_TABLE_500
2835 , p5_a20 JTF_VARCHAR2_TABLE_500
2836 , p5_a21 JTF_VARCHAR2_TABLE_500
2837 , p5_a22 JTF_VARCHAR2_TABLE_500
2838 , p5_a23 JTF_VARCHAR2_TABLE_500
2839 , p5_a24 JTF_VARCHAR2_TABLE_500
2840 , p5_a25 JTF_VARCHAR2_TABLE_500
2841 , p5_a26 JTF_NUMBER_TABLE
2842 , p5_a27 JTF_NUMBER_TABLE
2843 , p5_a28 JTF_NUMBER_TABLE
2844 , p5_a29 JTF_DATE_TABLE
2845 , p5_a30 JTF_NUMBER_TABLE
2846 , p5_a31 JTF_DATE_TABLE
2847 , p5_a32 JTF_NUMBER_TABLE
2848 , p6_a0 out nocopy JTF_NUMBER_TABLE
2849 , p6_a1 out nocopy JTF_NUMBER_TABLE
2850 , p6_a2 out nocopy JTF_NUMBER_TABLE
2851 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
2852 , p6_a4 out nocopy JTF_NUMBER_TABLE
2853 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
2854 , p6_a6 out nocopy JTF_NUMBER_TABLE
2855 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
2856 , p6_a8 out nocopy JTF_NUMBER_TABLE
2857 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
2858 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
2859 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
2860 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
2861 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
2862 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
2863 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
2864 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
2865 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
2866 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
2867 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
2868 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
2869 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
2870 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
2871 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
2872 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
2873 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
2874 , p6_a26 out nocopy JTF_NUMBER_TABLE
2875 , p6_a27 out nocopy JTF_NUMBER_TABLE
2876 , p6_a28 out nocopy JTF_NUMBER_TABLE
2877 , p6_a29 out nocopy JTF_DATE_TABLE
2878 , p6_a30 out nocopy JTF_NUMBER_TABLE
2879 , p6_a31 out nocopy JTF_DATE_TABLE
2880 , p6_a32 out nocopy JTF_NUMBER_TABLE
2881 )
2882
2883 as
2884 ddp_atlv_tbl okl_process_tmpt_set_pub.atlv_tbl_type;
2885 ddx_atlv_tbl okl_process_tmpt_set_pub.atlv_tbl_type;
2886 ddindx binary_integer; indx binary_integer;
2887 begin
2888
2889 -- copy data to the local IN or IN-OUT args, if any
2890
2891
2892
2893
2894
2895 okl_atl_pvt_w.rosetta_table_copy_in_p5(ddp_atlv_tbl, p5_a0
2896 , p5_a1
2897 , p5_a2
2898 , p5_a3
2899 , p5_a4
2900 , p5_a5
2901 , p5_a6
2902 , p5_a7
2903 , p5_a8
2904 , p5_a9
2905 , p5_a10
2906 , p5_a11
2907 , p5_a12
2908 , p5_a13
2909 , p5_a14
2910 , p5_a15
2911 , p5_a16
2912 , p5_a17
2913 , p5_a18
2914 , p5_a19
2915 , p5_a20
2916 , p5_a21
2917 , p5_a22
2918 , p5_a23
2919 , p5_a24
2920 , p5_a25
2921 , p5_a26
2922 , p5_a27
2923 , p5_a28
2924 , p5_a29
2925 , p5_a30
2926 , p5_a31
2927 , p5_a32
2928 );
2929
2930
2931 -- here's the delegated call to the old PL/SQL routine
2932 okl_process_tmpt_set_pub.update_tmpt_lines(p_api_version,
2933 p_init_msg_list,
2934 x_return_status,
2935 x_msg_count,
2936 x_msg_data,
2937 ddp_atlv_tbl,
2938 ddx_atlv_tbl);
2939
2940 -- copy data back from the local variables to OUT or IN-OUT args, if any
2941
2942
2943
2944
2945
2946
2947 okl_atl_pvt_w.rosetta_table_copy_out_p5(ddx_atlv_tbl, p6_a0
2948 , p6_a1
2949 , p6_a2
2950 , p6_a3
2951 , p6_a4
2952 , p6_a5
2953 , p6_a6
2954 , p6_a7
2955 , p6_a8
2956 , p6_a9
2957 , p6_a10
2958 , p6_a11
2959 , p6_a12
2960 , p6_a13
2961 , p6_a14
2962 , p6_a15
2963 , p6_a16
2964 , p6_a17
2965 , p6_a18
2966 , p6_a19
2967 , p6_a20
2968 , p6_a21
2969 , p6_a22
2970 , p6_a23
2971 , p6_a24
2972 , p6_a25
2973 , p6_a26
2974 , p6_a27
2975 , p6_a28
2976 , p6_a29
2977 , p6_a30
2978 , p6_a31
2979 , p6_a32
2980 );
2981 end;
2982
2983 procedure update_tmpt_lines(p_api_version NUMBER
2984 , p_init_msg_list VARCHAR2
2985 , x_return_status out nocopy VARCHAR2
2986 , x_msg_count out nocopy NUMBER
2987 , x_msg_data out nocopy VARCHAR2
2988 , p6_a0 out nocopy NUMBER
2989 , p6_a1 out nocopy NUMBER
2990 , p6_a2 out nocopy NUMBER
2991 , p6_a3 out nocopy VARCHAR2
2992 , p6_a4 out nocopy NUMBER
2993 , p6_a5 out nocopy VARCHAR2
2994 , p6_a6 out nocopy NUMBER
2995 , p6_a7 out nocopy VARCHAR2
2996 , p6_a8 out nocopy NUMBER
2997 , p6_a9 out nocopy VARCHAR2
2998 , p6_a10 out nocopy VARCHAR2
2999 , p6_a11 out nocopy VARCHAR2
3000 , p6_a12 out nocopy VARCHAR2
3001 , p6_a13 out nocopy VARCHAR2
3002 , p6_a14 out nocopy VARCHAR2
3003 , p6_a15 out nocopy VARCHAR2
3004 , p6_a16 out nocopy VARCHAR2
3005 , p6_a17 out nocopy VARCHAR2
3006 , p6_a18 out nocopy VARCHAR2
3007 , p6_a19 out nocopy VARCHAR2
3008 , p6_a20 out nocopy VARCHAR2
3009 , p6_a21 out nocopy VARCHAR2
3010 , p6_a22 out nocopy VARCHAR2
3011 , p6_a23 out nocopy VARCHAR2
3012 , p6_a24 out nocopy VARCHAR2
3013 , p6_a25 out nocopy VARCHAR2
3014 , p6_a26 out nocopy NUMBER
3015 , p6_a27 out nocopy NUMBER
3016 , p6_a28 out nocopy NUMBER
3017 , p6_a29 out nocopy DATE
3018 , p6_a30 out nocopy NUMBER
3019 , p6_a31 out nocopy DATE
3020 , p6_a32 out nocopy NUMBER
3021 , p5_a0 NUMBER := 0-1962.0724
3022 , p5_a1 NUMBER := 0-1962.0724
3023 , p5_a2 NUMBER := 0-1962.0724
3024 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
3025 , p5_a4 NUMBER := 0-1962.0724
3026 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
3027 , p5_a6 NUMBER := 0-1962.0724
3028 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
3029 , p5_a8 NUMBER := 0-1962.0724
3030 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
3031 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
3032 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
3033 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
3034 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
3035 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
3036 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
3037 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
3038 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
3039 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
3040 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
3041 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
3042 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
3043 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
3044 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
3045 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
3046 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
3047 , p5_a26 NUMBER := 0-1962.0724
3048 , p5_a27 NUMBER := 0-1962.0724
3049 , p5_a28 NUMBER := 0-1962.0724
3050 , p5_a29 DATE := fnd_api.g_miss_date
3051 , p5_a30 NUMBER := 0-1962.0724
3052 , p5_a31 DATE := fnd_api.g_miss_date
3053 , p5_a32 NUMBER := 0-1962.0724
3054 )
3055
3056 as
3057 ddp_atlv_rec okl_process_tmpt_set_pub.atlv_rec_type;
3058 ddx_atlv_rec okl_process_tmpt_set_pub.atlv_rec_type;
3059 ddindx binary_integer; indx binary_integer;
3060 begin
3061
3062 -- copy data to the local IN or IN-OUT args, if any
3063
3064
3065
3066
3067
3068 ddp_atlv_rec.id := rosetta_g_miss_num_map(p5_a0);
3069 ddp_atlv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
3070 ddp_atlv_rec.avl_id := rosetta_g_miss_num_map(p5_a2);
3071 ddp_atlv_rec.crd_code := p5_a3;
3072 ddp_atlv_rec.code_combination_id := rosetta_g_miss_num_map(p5_a4);
3073 ddp_atlv_rec.ae_line_type := p5_a5;
3074 ddp_atlv_rec.sequence_number := rosetta_g_miss_num_map(p5_a6);
3075 ddp_atlv_rec.description := p5_a7;
3076 ddp_atlv_rec.percentage := rosetta_g_miss_num_map(p5_a8);
3077 ddp_atlv_rec.account_builder_yn := p5_a9;
3078 ddp_atlv_rec.attribute_category := p5_a10;
3079 ddp_atlv_rec.attribute1 := p5_a11;
3080 ddp_atlv_rec.attribute2 := p5_a12;
3081 ddp_atlv_rec.attribute3 := p5_a13;
3082 ddp_atlv_rec.attribute4 := p5_a14;
3083 ddp_atlv_rec.attribute5 := p5_a15;
3084 ddp_atlv_rec.attribute6 := p5_a16;
3085 ddp_atlv_rec.attribute7 := p5_a17;
3086 ddp_atlv_rec.attribute8 := p5_a18;
3087 ddp_atlv_rec.attribute9 := p5_a19;
3088 ddp_atlv_rec.attribute10 := p5_a20;
3089 ddp_atlv_rec.attribute11 := p5_a21;
3090 ddp_atlv_rec.attribute12 := p5_a22;
3091 ddp_atlv_rec.attribute13 := p5_a23;
3092 ddp_atlv_rec.attribute14 := p5_a24;
3093 ddp_atlv_rec.attribute15 := p5_a25;
3094 ddp_atlv_rec.avl_tbl_index := rosetta_g_miss_num_map(p5_a26);
3095 ddp_atlv_rec.org_id := rosetta_g_miss_num_map(p5_a27);
3096 ddp_atlv_rec.created_by := rosetta_g_miss_num_map(p5_a28);
3097 ddp_atlv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a29);
3098 ddp_atlv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a30);
3099 ddp_atlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a31);
3100 ddp_atlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a32);
3101
3102
3103 -- here's the delegated call to the old PL/SQL routine
3104 okl_process_tmpt_set_pub.update_tmpt_lines(p_api_version,
3105 p_init_msg_list,
3106 x_return_status,
3107 x_msg_count,
3108 x_msg_data,
3109 ddp_atlv_rec,
3110 ddx_atlv_rec);
3111
3112 -- copy data back from the local variables to OUT or IN-OUT args, if any
3113
3114
3115
3116
3117
3118
3119 p6_a0 := rosetta_g_miss_num_map(ddx_atlv_rec.id);
3120 p6_a1 := rosetta_g_miss_num_map(ddx_atlv_rec.object_version_number);
3121 p6_a2 := rosetta_g_miss_num_map(ddx_atlv_rec.avl_id);
3122 p6_a3 := ddx_atlv_rec.crd_code;
3123 p6_a4 := rosetta_g_miss_num_map(ddx_atlv_rec.code_combination_id);
3124 p6_a5 := ddx_atlv_rec.ae_line_type;
3125 p6_a6 := rosetta_g_miss_num_map(ddx_atlv_rec.sequence_number);
3126 p6_a7 := ddx_atlv_rec.description;
3127 p6_a8 := rosetta_g_miss_num_map(ddx_atlv_rec.percentage);
3128 p6_a9 := ddx_atlv_rec.account_builder_yn;
3129 p6_a10 := ddx_atlv_rec.attribute_category;
3130 p6_a11 := ddx_atlv_rec.attribute1;
3131 p6_a12 := ddx_atlv_rec.attribute2;
3132 p6_a13 := ddx_atlv_rec.attribute3;
3133 p6_a14 := ddx_atlv_rec.attribute4;
3134 p6_a15 := ddx_atlv_rec.attribute5;
3135 p6_a16 := ddx_atlv_rec.attribute6;
3136 p6_a17 := ddx_atlv_rec.attribute7;
3137 p6_a18 := ddx_atlv_rec.attribute8;
3138 p6_a19 := ddx_atlv_rec.attribute9;
3139 p6_a20 := ddx_atlv_rec.attribute10;
3140 p6_a21 := ddx_atlv_rec.attribute11;
3141 p6_a22 := ddx_atlv_rec.attribute12;
3142 p6_a23 := ddx_atlv_rec.attribute13;
3143 p6_a24 := ddx_atlv_rec.attribute14;
3144 p6_a25 := ddx_atlv_rec.attribute15;
3145 p6_a26 := rosetta_g_miss_num_map(ddx_atlv_rec.avl_tbl_index);
3146 p6_a27 := rosetta_g_miss_num_map(ddx_atlv_rec.org_id);
3147 p6_a28 := rosetta_g_miss_num_map(ddx_atlv_rec.created_by);
3148 p6_a29 := ddx_atlv_rec.creation_date;
3149 p6_a30 := rosetta_g_miss_num_map(ddx_atlv_rec.last_updated_by);
3150 p6_a31 := ddx_atlv_rec.last_update_date;
3151 p6_a32 := rosetta_g_miss_num_map(ddx_atlv_rec.last_update_login);
3152 end;
3153
3154 procedure delete_tmpt_lines(p_api_version NUMBER
3155 , p_init_msg_list VARCHAR2
3156 , x_return_status out nocopy VARCHAR2
3157 , x_msg_count out nocopy NUMBER
3158 , x_msg_data out nocopy VARCHAR2
3159 , p5_a0 JTF_NUMBER_TABLE
3160 , p5_a1 JTF_NUMBER_TABLE
3161 , p5_a2 JTF_NUMBER_TABLE
3162 , p5_a3 JTF_VARCHAR2_TABLE_100
3163 , p5_a4 JTF_NUMBER_TABLE
3164 , p5_a5 JTF_VARCHAR2_TABLE_100
3165 , p5_a6 JTF_NUMBER_TABLE
3166 , p5_a7 JTF_VARCHAR2_TABLE_2000
3167 , p5_a8 JTF_NUMBER_TABLE
3168 , p5_a9 JTF_VARCHAR2_TABLE_100
3169 , p5_a10 JTF_VARCHAR2_TABLE_100
3170 , p5_a11 JTF_VARCHAR2_TABLE_500
3171 , p5_a12 JTF_VARCHAR2_TABLE_500
3172 , p5_a13 JTF_VARCHAR2_TABLE_500
3173 , p5_a14 JTF_VARCHAR2_TABLE_500
3174 , p5_a15 JTF_VARCHAR2_TABLE_500
3175 , p5_a16 JTF_VARCHAR2_TABLE_500
3176 , p5_a17 JTF_VARCHAR2_TABLE_500
3177 , p5_a18 JTF_VARCHAR2_TABLE_500
3178 , p5_a19 JTF_VARCHAR2_TABLE_500
3179 , p5_a20 JTF_VARCHAR2_TABLE_500
3180 , p5_a21 JTF_VARCHAR2_TABLE_500
3181 , p5_a22 JTF_VARCHAR2_TABLE_500
3182 , p5_a23 JTF_VARCHAR2_TABLE_500
3183 , p5_a24 JTF_VARCHAR2_TABLE_500
3184 , p5_a25 JTF_VARCHAR2_TABLE_500
3185 , p5_a26 JTF_NUMBER_TABLE
3186 , p5_a27 JTF_NUMBER_TABLE
3187 , p5_a28 JTF_NUMBER_TABLE
3188 , p5_a29 JTF_DATE_TABLE
3189 , p5_a30 JTF_NUMBER_TABLE
3190 , p5_a31 JTF_DATE_TABLE
3191 , p5_a32 JTF_NUMBER_TABLE
3192 )
3193
3194 as
3195 ddp_atlv_tbl okl_process_tmpt_set_pub.atlv_tbl_type;
3196 ddindx binary_integer; indx binary_integer;
3197 begin
3198
3199 -- copy data to the local IN or IN-OUT args, if any
3200
3201
3202
3203
3204
3205 okl_atl_pvt_w.rosetta_table_copy_in_p5(ddp_atlv_tbl, p5_a0
3206 , p5_a1
3207 , p5_a2
3208 , p5_a3
3209 , p5_a4
3210 , p5_a5
3211 , p5_a6
3212 , p5_a7
3213 , p5_a8
3214 , p5_a9
3215 , p5_a10
3216 , p5_a11
3217 , p5_a12
3218 , p5_a13
3219 , p5_a14
3220 , p5_a15
3221 , p5_a16
3222 , p5_a17
3223 , p5_a18
3224 , p5_a19
3225 , p5_a20
3226 , p5_a21
3227 , p5_a22
3228 , p5_a23
3229 , p5_a24
3230 , p5_a25
3231 , p5_a26
3232 , p5_a27
3233 , p5_a28
3234 , p5_a29
3235 , p5_a30
3236 , p5_a31
3237 , p5_a32
3238 );
3239
3240 -- here's the delegated call to the old PL/SQL routine
3241 okl_process_tmpt_set_pub.delete_tmpt_lines(p_api_version,
3242 p_init_msg_list,
3243 x_return_status,
3244 x_msg_count,
3245 x_msg_data,
3246 ddp_atlv_tbl);
3247
3248 -- copy data back from the local variables to OUT or IN-OUT args, if any
3249
3250
3251
3252
3253
3254 end;
3255
3256 procedure delete_tmpt_lines(p_api_version NUMBER
3257 , p_init_msg_list VARCHAR2
3258 , x_return_status out nocopy VARCHAR2
3259 , x_msg_count out nocopy NUMBER
3260 , x_msg_data out nocopy VARCHAR2
3261 , p5_a0 NUMBER := 0-1962.0724
3262 , p5_a1 NUMBER := 0-1962.0724
3263 , p5_a2 NUMBER := 0-1962.0724
3264 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
3265 , p5_a4 NUMBER := 0-1962.0724
3266 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
3267 , p5_a6 NUMBER := 0-1962.0724
3268 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
3269 , p5_a8 NUMBER := 0-1962.0724
3270 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
3271 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
3272 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
3273 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
3274 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
3275 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
3276 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
3277 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
3278 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
3279 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
3280 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
3281 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
3282 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
3283 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
3284 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
3285 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
3286 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
3287 , p5_a26 NUMBER := 0-1962.0724
3288 , p5_a27 NUMBER := 0-1962.0724
3289 , p5_a28 NUMBER := 0-1962.0724
3290 , p5_a29 DATE := fnd_api.g_miss_date
3291 , p5_a30 NUMBER := 0-1962.0724
3292 , p5_a31 DATE := fnd_api.g_miss_date
3293 , p5_a32 NUMBER := 0-1962.0724
3294 )
3295
3296 as
3297 ddp_atlv_rec okl_process_tmpt_set_pub.atlv_rec_type;
3298 ddindx binary_integer; indx binary_integer;
3299 begin
3300
3301 -- copy data to the local IN or IN-OUT args, if any
3302
3303
3304
3305
3306
3307 ddp_atlv_rec.id := rosetta_g_miss_num_map(p5_a0);
3308 ddp_atlv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
3309 ddp_atlv_rec.avl_id := rosetta_g_miss_num_map(p5_a2);
3310 ddp_atlv_rec.crd_code := p5_a3;
3311 ddp_atlv_rec.code_combination_id := rosetta_g_miss_num_map(p5_a4);
3312 ddp_atlv_rec.ae_line_type := p5_a5;
3313 ddp_atlv_rec.sequence_number := rosetta_g_miss_num_map(p5_a6);
3314 ddp_atlv_rec.description := p5_a7;
3315 ddp_atlv_rec.percentage := rosetta_g_miss_num_map(p5_a8);
3316 ddp_atlv_rec.account_builder_yn := p5_a9;
3317 ddp_atlv_rec.attribute_category := p5_a10;
3318 ddp_atlv_rec.attribute1 := p5_a11;
3319 ddp_atlv_rec.attribute2 := p5_a12;
3320 ddp_atlv_rec.attribute3 := p5_a13;
3321 ddp_atlv_rec.attribute4 := p5_a14;
3322 ddp_atlv_rec.attribute5 := p5_a15;
3323 ddp_atlv_rec.attribute6 := p5_a16;
3324 ddp_atlv_rec.attribute7 := p5_a17;
3325 ddp_atlv_rec.attribute8 := p5_a18;
3326 ddp_atlv_rec.attribute9 := p5_a19;
3327 ddp_atlv_rec.attribute10 := p5_a20;
3328 ddp_atlv_rec.attribute11 := p5_a21;
3329 ddp_atlv_rec.attribute12 := p5_a22;
3330 ddp_atlv_rec.attribute13 := p5_a23;
3331 ddp_atlv_rec.attribute14 := p5_a24;
3332 ddp_atlv_rec.attribute15 := p5_a25;
3333 ddp_atlv_rec.avl_tbl_index := rosetta_g_miss_num_map(p5_a26);
3334 ddp_atlv_rec.org_id := rosetta_g_miss_num_map(p5_a27);
3335 ddp_atlv_rec.created_by := rosetta_g_miss_num_map(p5_a28);
3336 ddp_atlv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a29);
3337 ddp_atlv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a30);
3338 ddp_atlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a31);
3339 ddp_atlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a32);
3340
3341 -- here's the delegated call to the old PL/SQL routine
3342 okl_process_tmpt_set_pub.delete_tmpt_lines(p_api_version,
3343 p_init_msg_list,
3344 x_return_status,
3345 x_msg_count,
3346 x_msg_data,
3347 ddp_atlv_rec);
3348
3349 -- copy data back from the local variables to OUT or IN-OUT args, if any
3350
3351
3352
3353
3354
3355 end;
3356
3357 procedure copy_template(p_api_version NUMBER
3358 , p_init_msg_list VARCHAR2
3359 , x_return_status out nocopy VARCHAR2
3360 , x_msg_count out nocopy NUMBER
3361 , x_msg_data out nocopy VARCHAR2
3362 , p_source_tmpl_id NUMBER
3363 , p7_a0 out nocopy NUMBER
3364 , p7_a1 out nocopy NUMBER
3365 , p7_a2 out nocopy NUMBER
3366 , p7_a3 out nocopy NUMBER
3367 , p7_a4 out nocopy NUMBER
3368 , p7_a5 out nocopy NUMBER
3369 , p7_a6 out nocopy NUMBER
3370 , p7_a7 out nocopy VARCHAR2
3371 , p7_a8 out nocopy VARCHAR2
3372 , p7_a9 out nocopy VARCHAR2
3373 , p7_a10 out nocopy VARCHAR2
3374 , p7_a11 out nocopy VARCHAR2
3375 , p7_a12 out nocopy VARCHAR2
3376 , p7_a13 out nocopy VARCHAR2
3377 , p7_a14 out nocopy VARCHAR2
3378 , p7_a15 out nocopy VARCHAR2
3379 , p7_a16 out nocopy VARCHAR2
3380 , p7_a17 out nocopy DATE
3381 , p7_a18 out nocopy DATE
3382 , p7_a19 out nocopy VARCHAR2
3383 , p7_a20 out nocopy VARCHAR2
3384 , p7_a21 out nocopy VARCHAR2
3385 , p7_a22 out nocopy VARCHAR2
3386 , p7_a23 out nocopy VARCHAR2
3387 , p7_a24 out nocopy VARCHAR2
3388 , p7_a25 out nocopy VARCHAR2
3389 , p7_a26 out nocopy VARCHAR2
3390 , p7_a27 out nocopy VARCHAR2
3391 , p7_a28 out nocopy VARCHAR2
3392 , p7_a29 out nocopy VARCHAR2
3393 , p7_a30 out nocopy VARCHAR2
3394 , p7_a31 out nocopy VARCHAR2
3395 , p7_a32 out nocopy VARCHAR2
3396 , p7_a33 out nocopy VARCHAR2
3397 , p7_a34 out nocopy VARCHAR2
3398 , p7_a35 out nocopy VARCHAR2
3399 , p7_a36 out nocopy NUMBER
3400 , p7_a37 out nocopy NUMBER
3401 , p7_a38 out nocopy DATE
3402 , p7_a39 out nocopy NUMBER
3403 , p7_a40 out nocopy DATE
3404 , p7_a41 out nocopy NUMBER
3405 , p7_a42 out nocopy VARCHAR2
3406 , p5_a0 NUMBER := 0-1962.0724
3407 , p5_a1 NUMBER := 0-1962.0724
3408 , p5_a2 NUMBER := 0-1962.0724
3409 , p5_a3 NUMBER := 0-1962.0724
3410 , p5_a4 NUMBER := 0-1962.0724
3411 , p5_a5 NUMBER := 0-1962.0724
3412 , p5_a6 NUMBER := 0-1962.0724
3413 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
3414 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
3415 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
3416 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
3417 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
3418 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
3419 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
3420 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
3421 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
3422 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
3423 , p5_a17 DATE := fnd_api.g_miss_date
3424 , p5_a18 DATE := fnd_api.g_miss_date
3425 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
3426 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
3427 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
3428 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
3429 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
3430 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
3431 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
3432 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
3433 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
3434 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
3435 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
3436 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
3437 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
3438 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
3439 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
3440 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
3441 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
3442 , p5_a36 NUMBER := 0-1962.0724
3443 , p5_a37 NUMBER := 0-1962.0724
3444 , p5_a38 DATE := fnd_api.g_miss_date
3445 , p5_a39 NUMBER := 0-1962.0724
3446 , p5_a40 DATE := fnd_api.g_miss_date
3447 , p5_a41 NUMBER := 0-1962.0724
3448 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
3449 )
3450
3451 as
3452 ddp_avlv_rec okl_process_tmpt_set_pub.avlv_rec_type;
3453 ddx_avlv_rec okl_process_tmpt_set_pub.avlv_rec_type;
3454 ddindx binary_integer; indx binary_integer;
3455 begin
3456
3457 -- copy data to the local IN or IN-OUT args, if any
3458
3459
3460
3461
3462
3463 ddp_avlv_rec.id := rosetta_g_miss_num_map(p5_a0);
3464 ddp_avlv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
3465 ddp_avlv_rec.try_id := rosetta_g_miss_num_map(p5_a2);
3466 ddp_avlv_rec.aes_id := rosetta_g_miss_num_map(p5_a3);
3467 ddp_avlv_rec.sty_id := rosetta_g_miss_num_map(p5_a4);
3468 ddp_avlv_rec.fma_id := rosetta_g_miss_num_map(p5_a5);
3469 ddp_avlv_rec.set_of_books_id := rosetta_g_miss_num_map(p5_a6);
3470 ddp_avlv_rec.fac_code := p5_a7;
3471 ddp_avlv_rec.syt_code := p5_a8;
3472 ddp_avlv_rec.post_to_gl := p5_a9;
3473 ddp_avlv_rec.advance_arrears := p5_a10;
3474 ddp_avlv_rec.memo_yn := p5_a11;
3475 ddp_avlv_rec.prior_year_yn := p5_a12;
3476 ddp_avlv_rec.name := p5_a13;
3477 ddp_avlv_rec.description := p5_a14;
3478 ddp_avlv_rec.version := p5_a15;
3479 ddp_avlv_rec.factoring_synd_flag := p5_a16;
3480 ddp_avlv_rec.start_date := rosetta_g_miss_date_in_map(p5_a17);
3481 ddp_avlv_rec.end_date := rosetta_g_miss_date_in_map(p5_a18);
3482 ddp_avlv_rec.accrual_yn := p5_a19;
3483 ddp_avlv_rec.attribute_category := p5_a20;
3484 ddp_avlv_rec.attribute1 := p5_a21;
3485 ddp_avlv_rec.attribute2 := p5_a22;
3486 ddp_avlv_rec.attribute3 := p5_a23;
3487 ddp_avlv_rec.attribute4 := p5_a24;
3488 ddp_avlv_rec.attribute5 := p5_a25;
3489 ddp_avlv_rec.attribute6 := p5_a26;
3490 ddp_avlv_rec.attribute7 := p5_a27;
3491 ddp_avlv_rec.attribute8 := p5_a28;
3492 ddp_avlv_rec.attribute9 := p5_a29;
3493 ddp_avlv_rec.attribute10 := p5_a30;
3494 ddp_avlv_rec.attribute11 := p5_a31;
3495 ddp_avlv_rec.attribute12 := p5_a32;
3496 ddp_avlv_rec.attribute13 := p5_a33;
3497 ddp_avlv_rec.attribute14 := p5_a34;
3498 ddp_avlv_rec.attribute15 := p5_a35;
3499 ddp_avlv_rec.org_id := rosetta_g_miss_num_map(p5_a36);
3500 ddp_avlv_rec.created_by := rosetta_g_miss_num_map(p5_a37);
3501 ddp_avlv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a38);
3502 ddp_avlv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a39);
3503 ddp_avlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a40);
3504 ddp_avlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a41);
3505 ddp_avlv_rec.inv_code := p5_a42;
3506
3507
3508
3509 -- here's the delegated call to the old PL/SQL routine
3510 okl_process_tmpt_set_pub.copy_template(p_api_version,
3511 p_init_msg_list,
3512 x_return_status,
3513 x_msg_count,
3514 x_msg_data,
3515 ddp_avlv_rec,
3516 p_source_tmpl_id,
3517 ddx_avlv_rec);
3518
3519 -- copy data back from the local variables to OUT or IN-OUT args, if any
3520
3521
3522
3523
3524
3525
3526
3527 p7_a0 := rosetta_g_miss_num_map(ddx_avlv_rec.id);
3528 p7_a1 := rosetta_g_miss_num_map(ddx_avlv_rec.object_version_number);
3529 p7_a2 := rosetta_g_miss_num_map(ddx_avlv_rec.try_id);
3530 p7_a3 := rosetta_g_miss_num_map(ddx_avlv_rec.aes_id);
3531 p7_a4 := rosetta_g_miss_num_map(ddx_avlv_rec.sty_id);
3532 p7_a5 := rosetta_g_miss_num_map(ddx_avlv_rec.fma_id);
3533 p7_a6 := rosetta_g_miss_num_map(ddx_avlv_rec.set_of_books_id);
3534 p7_a7 := ddx_avlv_rec.fac_code;
3535 p7_a8 := ddx_avlv_rec.syt_code;
3536 p7_a9 := ddx_avlv_rec.post_to_gl;
3537 p7_a10 := ddx_avlv_rec.advance_arrears;
3538 p7_a11 := ddx_avlv_rec.memo_yn;
3539 p7_a12 := ddx_avlv_rec.prior_year_yn;
3540 p7_a13 := ddx_avlv_rec.name;
3541 p7_a14 := ddx_avlv_rec.description;
3542 p7_a15 := ddx_avlv_rec.version;
3543 p7_a16 := ddx_avlv_rec.factoring_synd_flag;
3544 p7_a17 := ddx_avlv_rec.start_date;
3545 p7_a18 := ddx_avlv_rec.end_date;
3546 p7_a19 := ddx_avlv_rec.accrual_yn;
3547 p7_a20 := ddx_avlv_rec.attribute_category;
3548 p7_a21 := ddx_avlv_rec.attribute1;
3549 p7_a22 := ddx_avlv_rec.attribute2;
3550 p7_a23 := ddx_avlv_rec.attribute3;
3551 p7_a24 := ddx_avlv_rec.attribute4;
3552 p7_a25 := ddx_avlv_rec.attribute5;
3553 p7_a26 := ddx_avlv_rec.attribute6;
3554 p7_a27 := ddx_avlv_rec.attribute7;
3555 p7_a28 := ddx_avlv_rec.attribute8;
3556 p7_a29 := ddx_avlv_rec.attribute9;
3557 p7_a30 := ddx_avlv_rec.attribute10;
3558 p7_a31 := ddx_avlv_rec.attribute11;
3559 p7_a32 := ddx_avlv_rec.attribute12;
3560 p7_a33 := ddx_avlv_rec.attribute13;
3561 p7_a34 := ddx_avlv_rec.attribute14;
3562 p7_a35 := ddx_avlv_rec.attribute15;
3563 p7_a36 := rosetta_g_miss_num_map(ddx_avlv_rec.org_id);
3564 p7_a37 := rosetta_g_miss_num_map(ddx_avlv_rec.created_by);
3565 p7_a38 := ddx_avlv_rec.creation_date;
3566 p7_a39 := rosetta_g_miss_num_map(ddx_avlv_rec.last_updated_by);
3567 p7_a40 := ddx_avlv_rec.last_update_date;
3568 p7_a41 := rosetta_g_miss_num_map(ddx_avlv_rec.last_update_login);
3569 p7_a42 := ddx_avlv_rec.inv_code;
3570 end;
3571
3572 end okl_process_tmpt_set_pub_w;