[Home] [Help]
PACKAGE BODY: APPS.OKL_TMPT_SET_PVT_W
Source
1 package body okl_tmpt_set_pvt_w as
2 /* $Header: OKLOAESB.pls 120.2 2005/10/30 03:27:39 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_tmpt_set_pvt.aesv_rec_type;
211 ddp_avlv_tbl okl_tmpt_set_pvt.avlv_tbl_type;
212 ddp_atlv_tbl okl_tmpt_set_pvt.atlv_tbl_type;
213 ddx_aesv_rec okl_tmpt_set_pvt.aesv_rec_type;
214 ddx_avlv_tbl okl_tmpt_set_pvt.avlv_tbl_type;
215 ddx_atlv_tbl okl_tmpt_set_pvt.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_tmpt_set_pvt.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_tmpt_set_pvt.aesv_rec_type;
630 ddp_avlv_tbl okl_tmpt_set_pvt.avlv_tbl_type;
631 ddp_atlv_tbl okl_tmpt_set_pvt.atlv_tbl_type;
632 ddx_aesv_rec okl_tmpt_set_pvt.aesv_rec_type;
633 ddx_avlv_tbl okl_tmpt_set_pvt.avlv_tbl_type;
634 ddx_atlv_tbl okl_tmpt_set_pvt.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_tmpt_set_pvt.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 validate_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 , p6_a0 JTF_NUMBER_TABLE
866 , p6_a1 JTF_NUMBER_TABLE
867 , p6_a2 JTF_NUMBER_TABLE
868 , p6_a3 JTF_NUMBER_TABLE
869 , p6_a4 JTF_NUMBER_TABLE
870 , p6_a5 JTF_NUMBER_TABLE
871 , p6_a6 JTF_NUMBER_TABLE
872 , p6_a7 JTF_VARCHAR2_TABLE_100
873 , p6_a8 JTF_VARCHAR2_TABLE_100
874 , p6_a9 JTF_VARCHAR2_TABLE_100
875 , p6_a10 JTF_VARCHAR2_TABLE_100
876 , p6_a11 JTF_VARCHAR2_TABLE_100
877 , p6_a12 JTF_VARCHAR2_TABLE_100
878 , p6_a13 JTF_VARCHAR2_TABLE_200
879 , p6_a14 JTF_VARCHAR2_TABLE_2000
880 , p6_a15 JTF_VARCHAR2_TABLE_100
881 , p6_a16 JTF_VARCHAR2_TABLE_100
882 , p6_a17 JTF_DATE_TABLE
883 , p6_a18 JTF_DATE_TABLE
884 , p6_a19 JTF_VARCHAR2_TABLE_100
885 , p6_a20 JTF_VARCHAR2_TABLE_100
886 , p6_a21 JTF_VARCHAR2_TABLE_500
887 , p6_a22 JTF_VARCHAR2_TABLE_500
888 , p6_a23 JTF_VARCHAR2_TABLE_500
889 , p6_a24 JTF_VARCHAR2_TABLE_500
890 , p6_a25 JTF_VARCHAR2_TABLE_500
891 , p6_a26 JTF_VARCHAR2_TABLE_500
892 , p6_a27 JTF_VARCHAR2_TABLE_500
893 , p6_a28 JTF_VARCHAR2_TABLE_500
894 , p6_a29 JTF_VARCHAR2_TABLE_500
895 , p6_a30 JTF_VARCHAR2_TABLE_500
896 , p6_a31 JTF_VARCHAR2_TABLE_500
897 , p6_a32 JTF_VARCHAR2_TABLE_500
898 , p6_a33 JTF_VARCHAR2_TABLE_500
899 , p6_a34 JTF_VARCHAR2_TABLE_500
900 , p6_a35 JTF_VARCHAR2_TABLE_500
901 , p6_a36 JTF_NUMBER_TABLE
902 , p6_a37 JTF_NUMBER_TABLE
903 , p6_a38 JTF_DATE_TABLE
904 , p6_a39 JTF_NUMBER_TABLE
905 , p6_a40 JTF_DATE_TABLE
906 , p6_a41 JTF_NUMBER_TABLE
907 , p6_a42 JTF_VARCHAR2_TABLE_100
908 , p7_a0 JTF_NUMBER_TABLE
909 , p7_a1 JTF_NUMBER_TABLE
910 , p7_a2 JTF_NUMBER_TABLE
911 , p7_a3 JTF_VARCHAR2_TABLE_100
912 , p7_a4 JTF_NUMBER_TABLE
913 , p7_a5 JTF_VARCHAR2_TABLE_100
914 , p7_a6 JTF_NUMBER_TABLE
915 , p7_a7 JTF_VARCHAR2_TABLE_2000
916 , p7_a8 JTF_NUMBER_TABLE
917 , p7_a9 JTF_VARCHAR2_TABLE_100
918 , p7_a10 JTF_VARCHAR2_TABLE_100
919 , p7_a11 JTF_VARCHAR2_TABLE_500
920 , p7_a12 JTF_VARCHAR2_TABLE_500
921 , p7_a13 JTF_VARCHAR2_TABLE_500
922 , p7_a14 JTF_VARCHAR2_TABLE_500
923 , p7_a15 JTF_VARCHAR2_TABLE_500
924 , p7_a16 JTF_VARCHAR2_TABLE_500
925 , p7_a17 JTF_VARCHAR2_TABLE_500
926 , p7_a18 JTF_VARCHAR2_TABLE_500
927 , p7_a19 JTF_VARCHAR2_TABLE_500
928 , p7_a20 JTF_VARCHAR2_TABLE_500
929 , p7_a21 JTF_VARCHAR2_TABLE_500
930 , p7_a22 JTF_VARCHAR2_TABLE_500
931 , p7_a23 JTF_VARCHAR2_TABLE_500
932 , p7_a24 JTF_VARCHAR2_TABLE_500
933 , p7_a25 JTF_VARCHAR2_TABLE_500
934 , p7_a26 JTF_NUMBER_TABLE
935 , p7_a27 JTF_NUMBER_TABLE
936 , p7_a28 JTF_NUMBER_TABLE
937 , p7_a29 JTF_DATE_TABLE
938 , p7_a30 JTF_NUMBER_TABLE
939 , p7_a31 JTF_DATE_TABLE
940 , p7_a32 JTF_NUMBER_TABLE
941 , p5_a0 NUMBER := 0-1962.0724
942 , p5_a1 NUMBER := 0-1962.0724
943 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
944 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
945 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
946 , p5_a5 DATE := fnd_api.g_miss_date
947 , p5_a6 DATE := fnd_api.g_miss_date
948 , p5_a7 NUMBER := 0-1962.0724
949 , p5_a8 NUMBER := 0-1962.0724
950 , p5_a9 DATE := fnd_api.g_miss_date
951 , p5_a10 NUMBER := 0-1962.0724
952 , p5_a11 DATE := fnd_api.g_miss_date
953 , p5_a12 NUMBER := 0-1962.0724
954 , p5_a13 NUMBER := 0-1962.0724
955 )
956
957 as
958 ddp_aesv_rec okl_tmpt_set_pvt.aesv_rec_type;
959 ddp_avlv_tbl okl_tmpt_set_pvt.avlv_tbl_type;
960 ddp_atlv_tbl okl_tmpt_set_pvt.atlv_tbl_type;
961 ddindx binary_integer; indx binary_integer;
962 begin
963
964 -- copy data to the local IN or IN-OUT args, if any
965
966
967
968
969
970 ddp_aesv_rec.id := rosetta_g_miss_num_map(p5_a0);
971 ddp_aesv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
972 ddp_aesv_rec.name := p5_a2;
973 ddp_aesv_rec.description := p5_a3;
974 ddp_aesv_rec.version := p5_a4;
975 ddp_aesv_rec.start_date := rosetta_g_miss_date_in_map(p5_a5);
976 ddp_aesv_rec.end_date := rosetta_g_miss_date_in_map(p5_a6);
977 ddp_aesv_rec.org_id := rosetta_g_miss_num_map(p5_a7);
978 ddp_aesv_rec.created_by := rosetta_g_miss_num_map(p5_a8);
979 ddp_aesv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a9);
980 ddp_aesv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a10);
981 ddp_aesv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a11);
982 ddp_aesv_rec.last_update_login := rosetta_g_miss_num_map(p5_a12);
983 ddp_aesv_rec.gts_id := rosetta_g_miss_num_map(p5_a13);
984
985 okl_avl_pvt_w.rosetta_table_copy_in_p5(ddp_avlv_tbl, p6_a0
986 , p6_a1
987 , p6_a2
988 , p6_a3
989 , p6_a4
990 , p6_a5
991 , p6_a6
992 , p6_a7
993 , p6_a8
994 , p6_a9
995 , p6_a10
996 , p6_a11
997 , p6_a12
998 , p6_a13
999 , p6_a14
1000 , p6_a15
1001 , p6_a16
1002 , p6_a17
1003 , p6_a18
1004 , p6_a19
1005 , p6_a20
1006 , p6_a21
1007 , p6_a22
1008 , p6_a23
1009 , p6_a24
1010 , p6_a25
1011 , p6_a26
1012 , p6_a27
1013 , p6_a28
1014 , p6_a29
1015 , p6_a30
1016 , p6_a31
1017 , p6_a32
1018 , p6_a33
1019 , p6_a34
1020 , p6_a35
1021 , p6_a36
1022 , p6_a37
1023 , p6_a38
1024 , p6_a39
1025 , p6_a40
1026 , p6_a41
1027 , p6_a42
1028 );
1029
1030 okl_atl_pvt_w.rosetta_table_copy_in_p5(ddp_atlv_tbl, p7_a0
1031 , p7_a1
1032 , p7_a2
1033 , p7_a3
1034 , p7_a4
1035 , p7_a5
1036 , p7_a6
1037 , p7_a7
1038 , p7_a8
1039 , p7_a9
1040 , p7_a10
1041 , p7_a11
1042 , p7_a12
1043 , p7_a13
1044 , p7_a14
1045 , p7_a15
1046 , p7_a16
1047 , p7_a17
1048 , p7_a18
1049 , p7_a19
1050 , p7_a20
1051 , p7_a21
1052 , p7_a22
1053 , p7_a23
1054 , p7_a24
1055 , p7_a25
1056 , p7_a26
1057 , p7_a27
1058 , p7_a28
1059 , p7_a29
1060 , p7_a30
1061 , p7_a31
1062 , p7_a32
1063 );
1064
1065 -- here's the delegated call to the old PL/SQL routine
1066 okl_tmpt_set_pvt.validate_tmpt_set(p_api_version,
1067 p_init_msg_list,
1068 x_return_status,
1069 x_msg_count,
1070 x_msg_data,
1071 ddp_aesv_rec,
1072 ddp_avlv_tbl,
1073 ddp_atlv_tbl);
1074
1075 -- copy data back from the local variables to OUT or IN-OUT args, if any
1076
1077
1078
1079
1080
1081
1082
1083 end;
1084
1085 procedure create_tmpt_set(p_api_version NUMBER
1086 , p_init_msg_list VARCHAR2
1087 , x_return_status out nocopy VARCHAR2
1088 , x_msg_count out nocopy NUMBER
1089 , x_msg_data out nocopy VARCHAR2
1090 , p5_a0 JTF_NUMBER_TABLE
1091 , p5_a1 JTF_NUMBER_TABLE
1092 , p5_a2 JTF_VARCHAR2_TABLE_200
1093 , p5_a3 JTF_VARCHAR2_TABLE_2000
1094 , p5_a4 JTF_VARCHAR2_TABLE_100
1095 , p5_a5 JTF_DATE_TABLE
1096 , p5_a6 JTF_DATE_TABLE
1097 , p5_a7 JTF_NUMBER_TABLE
1098 , p5_a8 JTF_NUMBER_TABLE
1099 , p5_a9 JTF_DATE_TABLE
1100 , p5_a10 JTF_NUMBER_TABLE
1101 , p5_a11 JTF_DATE_TABLE
1102 , p5_a12 JTF_NUMBER_TABLE
1103 , p5_a13 JTF_NUMBER_TABLE
1104 , p6_a0 out nocopy JTF_NUMBER_TABLE
1105 , p6_a1 out nocopy JTF_NUMBER_TABLE
1106 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
1107 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
1108 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1109 , p6_a5 out nocopy JTF_DATE_TABLE
1110 , p6_a6 out nocopy JTF_DATE_TABLE
1111 , p6_a7 out nocopy JTF_NUMBER_TABLE
1112 , p6_a8 out nocopy JTF_NUMBER_TABLE
1113 , p6_a9 out nocopy JTF_DATE_TABLE
1114 , p6_a10 out nocopy JTF_NUMBER_TABLE
1115 , p6_a11 out nocopy JTF_DATE_TABLE
1116 , p6_a12 out nocopy JTF_NUMBER_TABLE
1117 , p6_a13 out nocopy JTF_NUMBER_TABLE
1118 )
1119
1120 as
1121 ddp_aesv_tbl okl_tmpt_set_pvt.aesv_tbl_type;
1122 ddx_aesv_tbl okl_tmpt_set_pvt.aesv_tbl_type;
1123 ddindx binary_integer; indx binary_integer;
1124 begin
1125
1126 -- copy data to the local IN or IN-OUT args, if any
1127
1128
1129
1130
1131
1132 okl_aes_pvt_w.rosetta_table_copy_in_p5(ddp_aesv_tbl, p5_a0
1133 , p5_a1
1134 , p5_a2
1135 , p5_a3
1136 , p5_a4
1137 , p5_a5
1138 , p5_a6
1139 , p5_a7
1140 , p5_a8
1141 , p5_a9
1142 , p5_a10
1143 , p5_a11
1144 , p5_a12
1145 , p5_a13
1146 );
1147
1148
1149 -- here's the delegated call to the old PL/SQL routine
1150 okl_tmpt_set_pvt.create_tmpt_set(p_api_version,
1151 p_init_msg_list,
1152 x_return_status,
1153 x_msg_count,
1154 x_msg_data,
1155 ddp_aesv_tbl,
1156 ddx_aesv_tbl);
1157
1158 -- copy data back from the local variables to OUT or IN-OUT args, if any
1159
1160
1161
1162
1163
1164
1165 okl_aes_pvt_w.rosetta_table_copy_out_p5(ddx_aesv_tbl, p6_a0
1166 , p6_a1
1167 , p6_a2
1168 , p6_a3
1169 , p6_a4
1170 , p6_a5
1171 , p6_a6
1172 , p6_a7
1173 , p6_a8
1174 , p6_a9
1175 , p6_a10
1176 , p6_a11
1177 , p6_a12
1178 , p6_a13
1179 );
1180 end;
1181
1182 procedure create_tmpt_set(p_api_version NUMBER
1183 , p_init_msg_list VARCHAR2
1184 , x_return_status out nocopy VARCHAR2
1185 , x_msg_count out nocopy NUMBER
1186 , x_msg_data out nocopy VARCHAR2
1187 , p6_a0 out nocopy NUMBER
1188 , p6_a1 out nocopy NUMBER
1189 , p6_a2 out nocopy VARCHAR2
1190 , p6_a3 out nocopy VARCHAR2
1191 , p6_a4 out nocopy VARCHAR2
1192 , p6_a5 out nocopy DATE
1193 , p6_a6 out nocopy DATE
1194 , p6_a7 out nocopy NUMBER
1195 , p6_a8 out nocopy NUMBER
1196 , p6_a9 out nocopy DATE
1197 , p6_a10 out nocopy NUMBER
1198 , p6_a11 out nocopy DATE
1199 , p6_a12 out nocopy NUMBER
1200 , p6_a13 out nocopy NUMBER
1201 , p5_a0 NUMBER := 0-1962.0724
1202 , p5_a1 NUMBER := 0-1962.0724
1203 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1204 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1205 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1206 , p5_a5 DATE := fnd_api.g_miss_date
1207 , p5_a6 DATE := fnd_api.g_miss_date
1208 , p5_a7 NUMBER := 0-1962.0724
1209 , p5_a8 NUMBER := 0-1962.0724
1210 , p5_a9 DATE := fnd_api.g_miss_date
1211 , p5_a10 NUMBER := 0-1962.0724
1212 , p5_a11 DATE := fnd_api.g_miss_date
1213 , p5_a12 NUMBER := 0-1962.0724
1214 , p5_a13 NUMBER := 0-1962.0724
1215 )
1216
1217 as
1218 ddp_aesv_rec okl_tmpt_set_pvt.aesv_rec_type;
1219 ddx_aesv_rec okl_tmpt_set_pvt.aesv_rec_type;
1220 ddindx binary_integer; indx binary_integer;
1221 begin
1222
1223 -- copy data to the local IN or IN-OUT args, if any
1224
1225
1226
1227
1228
1229 ddp_aesv_rec.id := rosetta_g_miss_num_map(p5_a0);
1230 ddp_aesv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1231 ddp_aesv_rec.name := p5_a2;
1232 ddp_aesv_rec.description := p5_a3;
1233 ddp_aesv_rec.version := p5_a4;
1234 ddp_aesv_rec.start_date := rosetta_g_miss_date_in_map(p5_a5);
1235 ddp_aesv_rec.end_date := rosetta_g_miss_date_in_map(p5_a6);
1236 ddp_aesv_rec.org_id := rosetta_g_miss_num_map(p5_a7);
1237 ddp_aesv_rec.created_by := rosetta_g_miss_num_map(p5_a8);
1238 ddp_aesv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a9);
1239 ddp_aesv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a10);
1240 ddp_aesv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a11);
1241 ddp_aesv_rec.last_update_login := rosetta_g_miss_num_map(p5_a12);
1242 ddp_aesv_rec.gts_id := rosetta_g_miss_num_map(p5_a13);
1243
1244
1245 -- here's the delegated call to the old PL/SQL routine
1246 okl_tmpt_set_pvt.create_tmpt_set(p_api_version,
1247 p_init_msg_list,
1248 x_return_status,
1249 x_msg_count,
1250 x_msg_data,
1251 ddp_aesv_rec,
1252 ddx_aesv_rec);
1253
1254 -- copy data back from the local variables to OUT or IN-OUT args, if any
1255
1256
1257
1258
1259
1260
1261 p6_a0 := rosetta_g_miss_num_map(ddx_aesv_rec.id);
1262 p6_a1 := rosetta_g_miss_num_map(ddx_aesv_rec.object_version_number);
1263 p6_a2 := ddx_aesv_rec.name;
1264 p6_a3 := ddx_aesv_rec.description;
1265 p6_a4 := ddx_aesv_rec.version;
1266 p6_a5 := ddx_aesv_rec.start_date;
1267 p6_a6 := ddx_aesv_rec.end_date;
1268 p6_a7 := rosetta_g_miss_num_map(ddx_aesv_rec.org_id);
1269 p6_a8 := rosetta_g_miss_num_map(ddx_aesv_rec.created_by);
1270 p6_a9 := ddx_aesv_rec.creation_date;
1271 p6_a10 := rosetta_g_miss_num_map(ddx_aesv_rec.last_updated_by);
1272 p6_a11 := ddx_aesv_rec.last_update_date;
1273 p6_a12 := rosetta_g_miss_num_map(ddx_aesv_rec.last_update_login);
1274 p6_a13 := rosetta_g_miss_num_map(ddx_aesv_rec.gts_id);
1275 end;
1276
1277 procedure lock_tmpt_set(p_api_version NUMBER
1278 , p_init_msg_list VARCHAR2
1279 , x_return_status out nocopy VARCHAR2
1280 , x_msg_count out nocopy NUMBER
1281 , x_msg_data out nocopy VARCHAR2
1282 , p5_a0 JTF_NUMBER_TABLE
1283 , p5_a1 JTF_NUMBER_TABLE
1284 , p5_a2 JTF_VARCHAR2_TABLE_200
1285 , p5_a3 JTF_VARCHAR2_TABLE_2000
1286 , p5_a4 JTF_VARCHAR2_TABLE_100
1287 , p5_a5 JTF_DATE_TABLE
1288 , p5_a6 JTF_DATE_TABLE
1289 , p5_a7 JTF_NUMBER_TABLE
1290 , p5_a8 JTF_NUMBER_TABLE
1291 , p5_a9 JTF_DATE_TABLE
1292 , p5_a10 JTF_NUMBER_TABLE
1293 , p5_a11 JTF_DATE_TABLE
1294 , p5_a12 JTF_NUMBER_TABLE
1295 , p5_a13 JTF_NUMBER_TABLE
1296 )
1297
1298 as
1299 ddp_aesv_tbl okl_tmpt_set_pvt.aesv_tbl_type;
1300 ddindx binary_integer; indx binary_integer;
1301 begin
1302
1303 -- copy data to the local IN or IN-OUT args, if any
1304
1305
1306
1307
1308
1309 okl_aes_pvt_w.rosetta_table_copy_in_p5(ddp_aesv_tbl, p5_a0
1310 , p5_a1
1311 , p5_a2
1312 , p5_a3
1313 , p5_a4
1314 , p5_a5
1315 , p5_a6
1316 , p5_a7
1317 , p5_a8
1318 , p5_a9
1319 , p5_a10
1320 , p5_a11
1321 , p5_a12
1322 , p5_a13
1323 );
1324
1325 -- here's the delegated call to the old PL/SQL routine
1326 okl_tmpt_set_pvt.lock_tmpt_set(p_api_version,
1327 p_init_msg_list,
1328 x_return_status,
1329 x_msg_count,
1330 x_msg_data,
1331 ddp_aesv_tbl);
1332
1333 -- copy data back from the local variables to OUT or IN-OUT args, if any
1334
1335
1336
1337
1338
1339 end;
1340
1341 procedure lock_tmpt_set(p_api_version NUMBER
1342 , p_init_msg_list VARCHAR2
1343 , x_return_status out nocopy VARCHAR2
1344 , x_msg_count out nocopy NUMBER
1345 , x_msg_data out nocopy VARCHAR2
1346 , p5_a0 NUMBER := 0-1962.0724
1347 , p5_a1 NUMBER := 0-1962.0724
1348 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1349 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1350 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1351 , p5_a5 DATE := fnd_api.g_miss_date
1352 , p5_a6 DATE := fnd_api.g_miss_date
1353 , p5_a7 NUMBER := 0-1962.0724
1354 , p5_a8 NUMBER := 0-1962.0724
1355 , p5_a9 DATE := fnd_api.g_miss_date
1356 , p5_a10 NUMBER := 0-1962.0724
1357 , p5_a11 DATE := fnd_api.g_miss_date
1358 , p5_a12 NUMBER := 0-1962.0724
1359 , p5_a13 NUMBER := 0-1962.0724
1360 )
1361
1362 as
1363 ddp_aesv_rec okl_tmpt_set_pvt.aesv_rec_type;
1364 ddindx binary_integer; indx binary_integer;
1365 begin
1366
1367 -- copy data to the local IN or IN-OUT args, if any
1368
1369
1370
1371
1372
1373 ddp_aesv_rec.id := rosetta_g_miss_num_map(p5_a0);
1374 ddp_aesv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1375 ddp_aesv_rec.name := p5_a2;
1376 ddp_aesv_rec.description := p5_a3;
1377 ddp_aesv_rec.version := p5_a4;
1378 ddp_aesv_rec.start_date := rosetta_g_miss_date_in_map(p5_a5);
1379 ddp_aesv_rec.end_date := rosetta_g_miss_date_in_map(p5_a6);
1380 ddp_aesv_rec.org_id := rosetta_g_miss_num_map(p5_a7);
1381 ddp_aesv_rec.created_by := rosetta_g_miss_num_map(p5_a8);
1382 ddp_aesv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a9);
1383 ddp_aesv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a10);
1384 ddp_aesv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a11);
1385 ddp_aesv_rec.last_update_login := rosetta_g_miss_num_map(p5_a12);
1386 ddp_aesv_rec.gts_id := rosetta_g_miss_num_map(p5_a13);
1387
1388 -- here's the delegated call to the old PL/SQL routine
1389 okl_tmpt_set_pvt.lock_tmpt_set(p_api_version,
1390 p_init_msg_list,
1391 x_return_status,
1392 x_msg_count,
1393 x_msg_data,
1394 ddp_aesv_rec);
1395
1396 -- copy data back from the local variables to OUT or IN-OUT args, if any
1397
1398
1399
1400
1401
1402 end;
1403
1404 procedure update_tmpt_set(p_api_version NUMBER
1405 , p_init_msg_list VARCHAR2
1406 , x_return_status out nocopy VARCHAR2
1407 , x_msg_count out nocopy NUMBER
1408 , x_msg_data out nocopy VARCHAR2
1409 , p5_a0 JTF_NUMBER_TABLE
1410 , p5_a1 JTF_NUMBER_TABLE
1411 , p5_a2 JTF_VARCHAR2_TABLE_200
1412 , p5_a3 JTF_VARCHAR2_TABLE_2000
1413 , p5_a4 JTF_VARCHAR2_TABLE_100
1414 , p5_a5 JTF_DATE_TABLE
1415 , p5_a6 JTF_DATE_TABLE
1416 , p5_a7 JTF_NUMBER_TABLE
1417 , p5_a8 JTF_NUMBER_TABLE
1418 , p5_a9 JTF_DATE_TABLE
1419 , p5_a10 JTF_NUMBER_TABLE
1420 , p5_a11 JTF_DATE_TABLE
1421 , p5_a12 JTF_NUMBER_TABLE
1422 , p5_a13 JTF_NUMBER_TABLE
1423 , p6_a0 out nocopy JTF_NUMBER_TABLE
1424 , p6_a1 out nocopy JTF_NUMBER_TABLE
1425 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
1426 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
1427 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1428 , p6_a5 out nocopy JTF_DATE_TABLE
1429 , p6_a6 out nocopy JTF_DATE_TABLE
1430 , p6_a7 out nocopy JTF_NUMBER_TABLE
1431 , p6_a8 out nocopy JTF_NUMBER_TABLE
1432 , p6_a9 out nocopy JTF_DATE_TABLE
1433 , p6_a10 out nocopy JTF_NUMBER_TABLE
1434 , p6_a11 out nocopy JTF_DATE_TABLE
1435 , p6_a12 out nocopy JTF_NUMBER_TABLE
1436 , p6_a13 out nocopy JTF_NUMBER_TABLE
1437 )
1438
1439 as
1440 ddp_aesv_tbl okl_tmpt_set_pvt.aesv_tbl_type;
1441 ddx_aesv_tbl okl_tmpt_set_pvt.aesv_tbl_type;
1442 ddindx binary_integer; indx binary_integer;
1443 begin
1444
1445 -- copy data to the local IN or IN-OUT args, if any
1446
1447
1448
1449
1450
1451 okl_aes_pvt_w.rosetta_table_copy_in_p5(ddp_aesv_tbl, p5_a0
1452 , p5_a1
1453 , p5_a2
1454 , p5_a3
1455 , p5_a4
1456 , p5_a5
1457 , p5_a6
1458 , p5_a7
1459 , p5_a8
1460 , p5_a9
1461 , p5_a10
1462 , p5_a11
1463 , p5_a12
1464 , p5_a13
1465 );
1466
1467
1468 -- here's the delegated call to the old PL/SQL routine
1469 okl_tmpt_set_pvt.update_tmpt_set(p_api_version,
1470 p_init_msg_list,
1471 x_return_status,
1472 x_msg_count,
1473 x_msg_data,
1474 ddp_aesv_tbl,
1475 ddx_aesv_tbl);
1476
1477 -- copy data back from the local variables to OUT or IN-OUT args, if any
1478
1479
1480
1481
1482
1483
1484 okl_aes_pvt_w.rosetta_table_copy_out_p5(ddx_aesv_tbl, p6_a0
1485 , p6_a1
1486 , p6_a2
1487 , p6_a3
1488 , p6_a4
1489 , p6_a5
1490 , p6_a6
1491 , p6_a7
1492 , p6_a8
1493 , p6_a9
1494 , p6_a10
1495 , p6_a11
1496 , p6_a12
1497 , p6_a13
1498 );
1499 end;
1500
1501 procedure update_tmpt_set(p_api_version NUMBER
1502 , p_init_msg_list VARCHAR2
1503 , x_return_status out nocopy VARCHAR2
1504 , x_msg_count out nocopy NUMBER
1505 , x_msg_data out nocopy VARCHAR2
1506 , p6_a0 out nocopy NUMBER
1507 , p6_a1 out nocopy NUMBER
1508 , p6_a2 out nocopy VARCHAR2
1509 , p6_a3 out nocopy VARCHAR2
1510 , p6_a4 out nocopy VARCHAR2
1511 , p6_a5 out nocopy DATE
1512 , p6_a6 out nocopy DATE
1513 , p6_a7 out nocopy NUMBER
1514 , p6_a8 out nocopy NUMBER
1515 , p6_a9 out nocopy DATE
1516 , p6_a10 out nocopy NUMBER
1517 , p6_a11 out nocopy DATE
1518 , p6_a12 out nocopy NUMBER
1519 , p6_a13 out nocopy NUMBER
1520 , p5_a0 NUMBER := 0-1962.0724
1521 , p5_a1 NUMBER := 0-1962.0724
1522 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1523 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1524 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1525 , p5_a5 DATE := fnd_api.g_miss_date
1526 , p5_a6 DATE := fnd_api.g_miss_date
1527 , p5_a7 NUMBER := 0-1962.0724
1528 , p5_a8 NUMBER := 0-1962.0724
1529 , p5_a9 DATE := fnd_api.g_miss_date
1530 , p5_a10 NUMBER := 0-1962.0724
1531 , p5_a11 DATE := fnd_api.g_miss_date
1532 , p5_a12 NUMBER := 0-1962.0724
1533 , p5_a13 NUMBER := 0-1962.0724
1534 )
1535
1536 as
1537 ddp_aesv_rec okl_tmpt_set_pvt.aesv_rec_type;
1538 ddx_aesv_rec okl_tmpt_set_pvt.aesv_rec_type;
1539 ddindx binary_integer; indx binary_integer;
1540 begin
1541
1542 -- copy data to the local IN or IN-OUT args, if any
1543
1544
1545
1546
1547
1548 ddp_aesv_rec.id := rosetta_g_miss_num_map(p5_a0);
1549 ddp_aesv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1550 ddp_aesv_rec.name := p5_a2;
1551 ddp_aesv_rec.description := p5_a3;
1552 ddp_aesv_rec.version := p5_a4;
1553 ddp_aesv_rec.start_date := rosetta_g_miss_date_in_map(p5_a5);
1554 ddp_aesv_rec.end_date := rosetta_g_miss_date_in_map(p5_a6);
1555 ddp_aesv_rec.org_id := rosetta_g_miss_num_map(p5_a7);
1556 ddp_aesv_rec.created_by := rosetta_g_miss_num_map(p5_a8);
1557 ddp_aesv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a9);
1558 ddp_aesv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a10);
1559 ddp_aesv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a11);
1560 ddp_aesv_rec.last_update_login := rosetta_g_miss_num_map(p5_a12);
1561 ddp_aesv_rec.gts_id := rosetta_g_miss_num_map(p5_a13);
1562
1563
1564 -- here's the delegated call to the old PL/SQL routine
1565 okl_tmpt_set_pvt.update_tmpt_set(p_api_version,
1566 p_init_msg_list,
1567 x_return_status,
1568 x_msg_count,
1569 x_msg_data,
1570 ddp_aesv_rec,
1571 ddx_aesv_rec);
1572
1573 -- copy data back from the local variables to OUT or IN-OUT args, if any
1574
1575
1576
1577
1578
1579
1580 p6_a0 := rosetta_g_miss_num_map(ddx_aesv_rec.id);
1581 p6_a1 := rosetta_g_miss_num_map(ddx_aesv_rec.object_version_number);
1582 p6_a2 := ddx_aesv_rec.name;
1583 p6_a3 := ddx_aesv_rec.description;
1584 p6_a4 := ddx_aesv_rec.version;
1585 p6_a5 := ddx_aesv_rec.start_date;
1586 p6_a6 := ddx_aesv_rec.end_date;
1587 p6_a7 := rosetta_g_miss_num_map(ddx_aesv_rec.org_id);
1588 p6_a8 := rosetta_g_miss_num_map(ddx_aesv_rec.created_by);
1589 p6_a9 := ddx_aesv_rec.creation_date;
1590 p6_a10 := rosetta_g_miss_num_map(ddx_aesv_rec.last_updated_by);
1591 p6_a11 := ddx_aesv_rec.last_update_date;
1592 p6_a12 := rosetta_g_miss_num_map(ddx_aesv_rec.last_update_login);
1593 p6_a13 := rosetta_g_miss_num_map(ddx_aesv_rec.gts_id);
1594 end;
1595
1596 procedure delete_tmpt_set(p_api_version NUMBER
1597 , p_init_msg_list VARCHAR2
1598 , x_return_status out nocopy VARCHAR2
1599 , x_msg_count out nocopy NUMBER
1600 , x_msg_data out nocopy VARCHAR2
1601 , p5_a0 JTF_NUMBER_TABLE
1602 , p5_a1 JTF_NUMBER_TABLE
1603 , p5_a2 JTF_VARCHAR2_TABLE_200
1604 , p5_a3 JTF_VARCHAR2_TABLE_2000
1605 , p5_a4 JTF_VARCHAR2_TABLE_100
1606 , p5_a5 JTF_DATE_TABLE
1607 , p5_a6 JTF_DATE_TABLE
1608 , p5_a7 JTF_NUMBER_TABLE
1609 , p5_a8 JTF_NUMBER_TABLE
1610 , p5_a9 JTF_DATE_TABLE
1611 , p5_a10 JTF_NUMBER_TABLE
1612 , p5_a11 JTF_DATE_TABLE
1613 , p5_a12 JTF_NUMBER_TABLE
1614 , p5_a13 JTF_NUMBER_TABLE
1615 )
1616
1617 as
1618 ddp_aesv_tbl okl_tmpt_set_pvt.aesv_tbl_type;
1619 ddindx binary_integer; indx binary_integer;
1620 begin
1621
1622 -- copy data to the local IN or IN-OUT args, if any
1623
1624
1625
1626
1627
1628 okl_aes_pvt_w.rosetta_table_copy_in_p5(ddp_aesv_tbl, p5_a0
1629 , p5_a1
1630 , p5_a2
1631 , p5_a3
1632 , p5_a4
1633 , p5_a5
1634 , p5_a6
1635 , p5_a7
1636 , p5_a8
1637 , p5_a9
1638 , p5_a10
1639 , p5_a11
1640 , p5_a12
1641 , p5_a13
1642 );
1643
1644 -- here's the delegated call to the old PL/SQL routine
1645 okl_tmpt_set_pvt.delete_tmpt_set(p_api_version,
1646 p_init_msg_list,
1647 x_return_status,
1648 x_msg_count,
1649 x_msg_data,
1650 ddp_aesv_tbl);
1651
1652 -- copy data back from the local variables to OUT or IN-OUT args, if any
1653
1654
1655
1656
1657
1658 end;
1659
1660 procedure delete_tmpt_set(p_api_version NUMBER
1661 , p_init_msg_list VARCHAR2
1662 , x_return_status out nocopy VARCHAR2
1663 , x_msg_count out nocopy NUMBER
1664 , x_msg_data out nocopy VARCHAR2
1665 , p5_a0 NUMBER := 0-1962.0724
1666 , p5_a1 NUMBER := 0-1962.0724
1667 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1668 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1669 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1670 , p5_a5 DATE := fnd_api.g_miss_date
1671 , p5_a6 DATE := fnd_api.g_miss_date
1672 , p5_a7 NUMBER := 0-1962.0724
1673 , p5_a8 NUMBER := 0-1962.0724
1674 , p5_a9 DATE := fnd_api.g_miss_date
1675 , p5_a10 NUMBER := 0-1962.0724
1676 , p5_a11 DATE := fnd_api.g_miss_date
1677 , p5_a12 NUMBER := 0-1962.0724
1678 , p5_a13 NUMBER := 0-1962.0724
1679 )
1680
1681 as
1682 ddp_aesv_rec okl_tmpt_set_pvt.aesv_rec_type;
1683 ddindx binary_integer; indx binary_integer;
1684 begin
1685
1686 -- copy data to the local IN or IN-OUT args, if any
1687
1688
1689
1690
1691
1692 ddp_aesv_rec.id := rosetta_g_miss_num_map(p5_a0);
1693 ddp_aesv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1694 ddp_aesv_rec.name := p5_a2;
1695 ddp_aesv_rec.description := p5_a3;
1696 ddp_aesv_rec.version := p5_a4;
1697 ddp_aesv_rec.start_date := rosetta_g_miss_date_in_map(p5_a5);
1698 ddp_aesv_rec.end_date := rosetta_g_miss_date_in_map(p5_a6);
1699 ddp_aesv_rec.org_id := rosetta_g_miss_num_map(p5_a7);
1700 ddp_aesv_rec.created_by := rosetta_g_miss_num_map(p5_a8);
1701 ddp_aesv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a9);
1702 ddp_aesv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a10);
1703 ddp_aesv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a11);
1704 ddp_aesv_rec.last_update_login := rosetta_g_miss_num_map(p5_a12);
1705 ddp_aesv_rec.gts_id := rosetta_g_miss_num_map(p5_a13);
1706
1707 -- here's the delegated call to the old PL/SQL routine
1708 okl_tmpt_set_pvt.delete_tmpt_set(p_api_version,
1709 p_init_msg_list,
1710 x_return_status,
1711 x_msg_count,
1712 x_msg_data,
1713 ddp_aesv_rec);
1714
1715 -- copy data back from the local variables to OUT or IN-OUT args, if any
1716
1717
1718
1719
1720
1721 end;
1722
1723 procedure validate_tmpt_set(p_api_version NUMBER
1724 , p_init_msg_list VARCHAR2
1725 , x_return_status out nocopy VARCHAR2
1726 , x_msg_count out nocopy NUMBER
1727 , x_msg_data out nocopy VARCHAR2
1728 , p5_a0 JTF_NUMBER_TABLE
1729 , p5_a1 JTF_NUMBER_TABLE
1730 , p5_a2 JTF_VARCHAR2_TABLE_200
1731 , p5_a3 JTF_VARCHAR2_TABLE_2000
1732 , p5_a4 JTF_VARCHAR2_TABLE_100
1733 , p5_a5 JTF_DATE_TABLE
1734 , p5_a6 JTF_DATE_TABLE
1735 , p5_a7 JTF_NUMBER_TABLE
1736 , p5_a8 JTF_NUMBER_TABLE
1737 , p5_a9 JTF_DATE_TABLE
1738 , p5_a10 JTF_NUMBER_TABLE
1739 , p5_a11 JTF_DATE_TABLE
1740 , p5_a12 JTF_NUMBER_TABLE
1741 , p5_a13 JTF_NUMBER_TABLE
1742 )
1743
1744 as
1745 ddp_aesv_tbl okl_tmpt_set_pvt.aesv_tbl_type;
1746 ddindx binary_integer; indx binary_integer;
1747 begin
1748
1749 -- copy data to the local IN or IN-OUT args, if any
1750
1751
1752
1753
1754
1755 okl_aes_pvt_w.rosetta_table_copy_in_p5(ddp_aesv_tbl, p5_a0
1756 , p5_a1
1757 , p5_a2
1758 , p5_a3
1759 , p5_a4
1760 , p5_a5
1761 , p5_a6
1762 , p5_a7
1763 , p5_a8
1764 , p5_a9
1765 , p5_a10
1766 , p5_a11
1767 , p5_a12
1768 , p5_a13
1769 );
1770
1771 -- here's the delegated call to the old PL/SQL routine
1772 okl_tmpt_set_pvt.validate_tmpt_set(p_api_version,
1773 p_init_msg_list,
1774 x_return_status,
1775 x_msg_count,
1776 x_msg_data,
1777 ddp_aesv_tbl);
1778
1779 -- copy data back from the local variables to OUT or IN-OUT args, if any
1780
1781
1782
1783
1784
1785 end;
1786
1787 procedure validate_tmpt_set(p_api_version NUMBER
1788 , p_init_msg_list VARCHAR2
1789 , x_return_status out nocopy VARCHAR2
1790 , x_msg_count out nocopy NUMBER
1791 , x_msg_data out nocopy VARCHAR2
1792 , p5_a0 NUMBER := 0-1962.0724
1793 , p5_a1 NUMBER := 0-1962.0724
1794 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1795 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1796 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1797 , p5_a5 DATE := fnd_api.g_miss_date
1798 , p5_a6 DATE := fnd_api.g_miss_date
1799 , p5_a7 NUMBER := 0-1962.0724
1800 , p5_a8 NUMBER := 0-1962.0724
1801 , p5_a9 DATE := fnd_api.g_miss_date
1802 , p5_a10 NUMBER := 0-1962.0724
1803 , p5_a11 DATE := fnd_api.g_miss_date
1804 , p5_a12 NUMBER := 0-1962.0724
1805 , p5_a13 NUMBER := 0-1962.0724
1806 )
1807
1808 as
1809 ddp_aesv_rec okl_tmpt_set_pvt.aesv_rec_type;
1810 ddindx binary_integer; indx binary_integer;
1811 begin
1812
1813 -- copy data to the local IN or IN-OUT args, if any
1814
1815
1816
1817
1818
1819 ddp_aesv_rec.id := rosetta_g_miss_num_map(p5_a0);
1820 ddp_aesv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1821 ddp_aesv_rec.name := p5_a2;
1822 ddp_aesv_rec.description := p5_a3;
1823 ddp_aesv_rec.version := p5_a4;
1824 ddp_aesv_rec.start_date := rosetta_g_miss_date_in_map(p5_a5);
1825 ddp_aesv_rec.end_date := rosetta_g_miss_date_in_map(p5_a6);
1826 ddp_aesv_rec.org_id := rosetta_g_miss_num_map(p5_a7);
1827 ddp_aesv_rec.created_by := rosetta_g_miss_num_map(p5_a8);
1828 ddp_aesv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a9);
1829 ddp_aesv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a10);
1830 ddp_aesv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a11);
1831 ddp_aesv_rec.last_update_login := rosetta_g_miss_num_map(p5_a12);
1832 ddp_aesv_rec.gts_id := rosetta_g_miss_num_map(p5_a13);
1833
1834 -- here's the delegated call to the old PL/SQL routine
1835 okl_tmpt_set_pvt.validate_tmpt_set(p_api_version,
1836 p_init_msg_list,
1837 x_return_status,
1838 x_msg_count,
1839 x_msg_data,
1840 ddp_aesv_rec);
1841
1842 -- copy data back from the local variables to OUT or IN-OUT args, if any
1843
1844
1845
1846
1847
1848 end;
1849
1850 procedure create_template(p_api_version NUMBER
1851 , p_init_msg_list VARCHAR2
1852 , x_return_status out nocopy VARCHAR2
1853 , x_msg_count out nocopy NUMBER
1854 , x_msg_data out nocopy VARCHAR2
1855 , p5_a0 JTF_NUMBER_TABLE
1856 , p5_a1 JTF_NUMBER_TABLE
1857 , p5_a2 JTF_NUMBER_TABLE
1858 , p5_a3 JTF_NUMBER_TABLE
1859 , p5_a4 JTF_NUMBER_TABLE
1860 , p5_a5 JTF_NUMBER_TABLE
1861 , p5_a6 JTF_NUMBER_TABLE
1862 , p5_a7 JTF_VARCHAR2_TABLE_100
1863 , p5_a8 JTF_VARCHAR2_TABLE_100
1864 , p5_a9 JTF_VARCHAR2_TABLE_100
1865 , p5_a10 JTF_VARCHAR2_TABLE_100
1866 , p5_a11 JTF_VARCHAR2_TABLE_100
1867 , p5_a12 JTF_VARCHAR2_TABLE_100
1868 , p5_a13 JTF_VARCHAR2_TABLE_200
1869 , p5_a14 JTF_VARCHAR2_TABLE_2000
1870 , p5_a15 JTF_VARCHAR2_TABLE_100
1871 , p5_a16 JTF_VARCHAR2_TABLE_100
1872 , p5_a17 JTF_DATE_TABLE
1873 , p5_a18 JTF_DATE_TABLE
1874 , p5_a19 JTF_VARCHAR2_TABLE_100
1875 , p5_a20 JTF_VARCHAR2_TABLE_100
1876 , p5_a21 JTF_VARCHAR2_TABLE_500
1877 , p5_a22 JTF_VARCHAR2_TABLE_500
1878 , p5_a23 JTF_VARCHAR2_TABLE_500
1879 , p5_a24 JTF_VARCHAR2_TABLE_500
1880 , p5_a25 JTF_VARCHAR2_TABLE_500
1881 , p5_a26 JTF_VARCHAR2_TABLE_500
1882 , p5_a27 JTF_VARCHAR2_TABLE_500
1883 , p5_a28 JTF_VARCHAR2_TABLE_500
1884 , p5_a29 JTF_VARCHAR2_TABLE_500
1885 , p5_a30 JTF_VARCHAR2_TABLE_500
1886 , p5_a31 JTF_VARCHAR2_TABLE_500
1887 , p5_a32 JTF_VARCHAR2_TABLE_500
1888 , p5_a33 JTF_VARCHAR2_TABLE_500
1889 , p5_a34 JTF_VARCHAR2_TABLE_500
1890 , p5_a35 JTF_VARCHAR2_TABLE_500
1891 , p5_a36 JTF_NUMBER_TABLE
1892 , p5_a37 JTF_NUMBER_TABLE
1893 , p5_a38 JTF_DATE_TABLE
1894 , p5_a39 JTF_NUMBER_TABLE
1895 , p5_a40 JTF_DATE_TABLE
1896 , p5_a41 JTF_NUMBER_TABLE
1897 , p5_a42 JTF_VARCHAR2_TABLE_100
1898 , p6_a0 out nocopy JTF_NUMBER_TABLE
1899 , p6_a1 out nocopy JTF_NUMBER_TABLE
1900 , p6_a2 out nocopy JTF_NUMBER_TABLE
1901 , p6_a3 out nocopy JTF_NUMBER_TABLE
1902 , p6_a4 out nocopy JTF_NUMBER_TABLE
1903 , p6_a5 out nocopy JTF_NUMBER_TABLE
1904 , p6_a6 out nocopy JTF_NUMBER_TABLE
1905 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1906 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1907 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1908 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1909 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1910 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1911 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
1912 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_2000
1913 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1914 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
1915 , p6_a17 out nocopy JTF_DATE_TABLE
1916 , p6_a18 out nocopy JTF_DATE_TABLE
1917 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
1918 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
1919 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1920 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1921 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1922 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1923 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1924 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1925 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1926 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1927 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
1928 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
1929 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
1930 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
1931 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
1932 , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
1933 , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
1934 , p6_a36 out nocopy JTF_NUMBER_TABLE
1935 , p6_a37 out nocopy JTF_NUMBER_TABLE
1936 , p6_a38 out nocopy JTF_DATE_TABLE
1937 , p6_a39 out nocopy JTF_NUMBER_TABLE
1938 , p6_a40 out nocopy JTF_DATE_TABLE
1939 , p6_a41 out nocopy JTF_NUMBER_TABLE
1940 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
1941 )
1942
1943 as
1944 ddp_avlv_tbl okl_tmpt_set_pvt.avlv_tbl_type;
1945 ddx_avlv_tbl okl_tmpt_set_pvt.avlv_tbl_type;
1946 ddindx binary_integer; indx binary_integer;
1947 begin
1948
1949 -- copy data to the local IN or IN-OUT args, if any
1950
1951
1952
1953
1954
1955 okl_avl_pvt_w.rosetta_table_copy_in_p5(ddp_avlv_tbl, p5_a0
1956 , p5_a1
1957 , p5_a2
1958 , p5_a3
1959 , p5_a4
1960 , p5_a5
1961 , p5_a6
1962 , p5_a7
1963 , p5_a8
1964 , p5_a9
1965 , p5_a10
1966 , p5_a11
1967 , p5_a12
1968 , p5_a13
1969 , p5_a14
1970 , p5_a15
1971 , p5_a16
1972 , p5_a17
1973 , p5_a18
1974 , p5_a19
1975 , p5_a20
1976 , p5_a21
1977 , p5_a22
1978 , p5_a23
1979 , p5_a24
1980 , p5_a25
1981 , p5_a26
1982 , p5_a27
1983 , p5_a28
1984 , p5_a29
1985 , p5_a30
1986 , p5_a31
1987 , p5_a32
1988 , p5_a33
1989 , p5_a34
1990 , p5_a35
1991 , p5_a36
1992 , p5_a37
1993 , p5_a38
1994 , p5_a39
1995 , p5_a40
1996 , p5_a41
1997 , p5_a42
1998 );
1999
2000
2001 -- here's the delegated call to the old PL/SQL routine
2002 okl_tmpt_set_pvt.create_template(p_api_version,
2003 p_init_msg_list,
2004 x_return_status,
2005 x_msg_count,
2006 x_msg_data,
2007 ddp_avlv_tbl,
2008 ddx_avlv_tbl);
2009
2010 -- copy data back from the local variables to OUT or IN-OUT args, if any
2011
2012
2013
2014
2015
2016
2017 okl_avl_pvt_w.rosetta_table_copy_out_p5(ddx_avlv_tbl, p6_a0
2018 , p6_a1
2019 , p6_a2
2020 , p6_a3
2021 , p6_a4
2022 , p6_a5
2023 , p6_a6
2024 , p6_a7
2025 , p6_a8
2026 , p6_a9
2027 , p6_a10
2028 , p6_a11
2029 , p6_a12
2030 , p6_a13
2031 , p6_a14
2032 , p6_a15
2033 , p6_a16
2034 , p6_a17
2035 , p6_a18
2036 , p6_a19
2037 , p6_a20
2038 , p6_a21
2039 , p6_a22
2040 , p6_a23
2041 , p6_a24
2042 , p6_a25
2043 , p6_a26
2044 , p6_a27
2045 , p6_a28
2046 , p6_a29
2047 , p6_a30
2048 , p6_a31
2049 , p6_a32
2050 , p6_a33
2051 , p6_a34
2052 , p6_a35
2053 , p6_a36
2054 , p6_a37
2055 , p6_a38
2056 , p6_a39
2057 , p6_a40
2058 , p6_a41
2059 , p6_a42
2060 );
2061 end;
2062
2063 procedure create_template(p_api_version NUMBER
2064 , p_init_msg_list VARCHAR2
2065 , x_return_status out nocopy VARCHAR2
2066 , x_msg_count out nocopy NUMBER
2067 , x_msg_data out nocopy VARCHAR2
2068 , p6_a0 out nocopy NUMBER
2069 , p6_a1 out nocopy NUMBER
2070 , p6_a2 out nocopy NUMBER
2071 , p6_a3 out nocopy NUMBER
2072 , p6_a4 out nocopy NUMBER
2073 , p6_a5 out nocopy NUMBER
2074 , p6_a6 out nocopy NUMBER
2075 , p6_a7 out nocopy VARCHAR2
2076 , p6_a8 out nocopy VARCHAR2
2077 , p6_a9 out nocopy VARCHAR2
2078 , p6_a10 out nocopy VARCHAR2
2079 , p6_a11 out nocopy VARCHAR2
2080 , p6_a12 out nocopy VARCHAR2
2081 , p6_a13 out nocopy VARCHAR2
2082 , p6_a14 out nocopy VARCHAR2
2083 , p6_a15 out nocopy VARCHAR2
2084 , p6_a16 out nocopy VARCHAR2
2085 , p6_a17 out nocopy DATE
2086 , p6_a18 out nocopy DATE
2087 , p6_a19 out nocopy VARCHAR2
2088 , p6_a20 out nocopy VARCHAR2
2089 , p6_a21 out nocopy VARCHAR2
2090 , p6_a22 out nocopy VARCHAR2
2091 , p6_a23 out nocopy VARCHAR2
2092 , p6_a24 out nocopy VARCHAR2
2093 , p6_a25 out nocopy VARCHAR2
2094 , p6_a26 out nocopy VARCHAR2
2095 , p6_a27 out nocopy VARCHAR2
2096 , p6_a28 out nocopy VARCHAR2
2097 , p6_a29 out nocopy VARCHAR2
2098 , p6_a30 out nocopy VARCHAR2
2099 , p6_a31 out nocopy VARCHAR2
2100 , p6_a32 out nocopy VARCHAR2
2101 , p6_a33 out nocopy VARCHAR2
2102 , p6_a34 out nocopy VARCHAR2
2103 , p6_a35 out nocopy VARCHAR2
2104 , p6_a36 out nocopy NUMBER
2105 , p6_a37 out nocopy NUMBER
2106 , p6_a38 out nocopy DATE
2107 , p6_a39 out nocopy NUMBER
2108 , p6_a40 out nocopy DATE
2109 , p6_a41 out nocopy NUMBER
2110 , p6_a42 out nocopy VARCHAR2
2111 , p5_a0 NUMBER := 0-1962.0724
2112 , p5_a1 NUMBER := 0-1962.0724
2113 , p5_a2 NUMBER := 0-1962.0724
2114 , p5_a3 NUMBER := 0-1962.0724
2115 , p5_a4 NUMBER := 0-1962.0724
2116 , p5_a5 NUMBER := 0-1962.0724
2117 , p5_a6 NUMBER := 0-1962.0724
2118 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2119 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2120 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2121 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2122 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2123 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2124 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2125 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2126 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2127 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2128 , p5_a17 DATE := fnd_api.g_miss_date
2129 , p5_a18 DATE := fnd_api.g_miss_date
2130 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2131 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2132 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2133 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2134 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2135 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2136 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2137 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2138 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2139 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2140 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2141 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2142 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2143 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2144 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2145 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
2146 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
2147 , p5_a36 NUMBER := 0-1962.0724
2148 , p5_a37 NUMBER := 0-1962.0724
2149 , p5_a38 DATE := fnd_api.g_miss_date
2150 , p5_a39 NUMBER := 0-1962.0724
2151 , p5_a40 DATE := fnd_api.g_miss_date
2152 , p5_a41 NUMBER := 0-1962.0724
2153 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
2154 )
2155
2156 as
2157 ddp_avlv_rec okl_tmpt_set_pvt.avlv_rec_type;
2158 ddx_avlv_rec okl_tmpt_set_pvt.avlv_rec_type;
2159 ddindx binary_integer; indx binary_integer;
2160 begin
2161
2162 -- copy data to the local IN or IN-OUT args, if any
2163
2164
2165
2166
2167
2168 ddp_avlv_rec.id := rosetta_g_miss_num_map(p5_a0);
2169 ddp_avlv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
2170 ddp_avlv_rec.try_id := rosetta_g_miss_num_map(p5_a2);
2171 ddp_avlv_rec.aes_id := rosetta_g_miss_num_map(p5_a3);
2172 ddp_avlv_rec.sty_id := rosetta_g_miss_num_map(p5_a4);
2173 ddp_avlv_rec.fma_id := rosetta_g_miss_num_map(p5_a5);
2174 ddp_avlv_rec.set_of_books_id := rosetta_g_miss_num_map(p5_a6);
2175 ddp_avlv_rec.fac_code := p5_a7;
2176 ddp_avlv_rec.syt_code := p5_a8;
2177 ddp_avlv_rec.post_to_gl := p5_a9;
2178 ddp_avlv_rec.advance_arrears := p5_a10;
2179 ddp_avlv_rec.memo_yn := p5_a11;
2180 ddp_avlv_rec.prior_year_yn := p5_a12;
2181 ddp_avlv_rec.name := p5_a13;
2182 ddp_avlv_rec.description := p5_a14;
2183 ddp_avlv_rec.version := p5_a15;
2184 ddp_avlv_rec.factoring_synd_flag := p5_a16;
2185 ddp_avlv_rec.start_date := rosetta_g_miss_date_in_map(p5_a17);
2186 ddp_avlv_rec.end_date := rosetta_g_miss_date_in_map(p5_a18);
2187 ddp_avlv_rec.accrual_yn := p5_a19;
2188 ddp_avlv_rec.attribute_category := p5_a20;
2189 ddp_avlv_rec.attribute1 := p5_a21;
2190 ddp_avlv_rec.attribute2 := p5_a22;
2191 ddp_avlv_rec.attribute3 := p5_a23;
2192 ddp_avlv_rec.attribute4 := p5_a24;
2193 ddp_avlv_rec.attribute5 := p5_a25;
2194 ddp_avlv_rec.attribute6 := p5_a26;
2195 ddp_avlv_rec.attribute7 := p5_a27;
2196 ddp_avlv_rec.attribute8 := p5_a28;
2197 ddp_avlv_rec.attribute9 := p5_a29;
2198 ddp_avlv_rec.attribute10 := p5_a30;
2199 ddp_avlv_rec.attribute11 := p5_a31;
2200 ddp_avlv_rec.attribute12 := p5_a32;
2201 ddp_avlv_rec.attribute13 := p5_a33;
2202 ddp_avlv_rec.attribute14 := p5_a34;
2203 ddp_avlv_rec.attribute15 := p5_a35;
2204 ddp_avlv_rec.org_id := rosetta_g_miss_num_map(p5_a36);
2205 ddp_avlv_rec.created_by := rosetta_g_miss_num_map(p5_a37);
2206 ddp_avlv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a38);
2207 ddp_avlv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a39);
2208 ddp_avlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a40);
2209 ddp_avlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a41);
2210 ddp_avlv_rec.inv_code := p5_a42;
2211
2212
2213 -- here's the delegated call to the old PL/SQL routine
2214 okl_tmpt_set_pvt.create_template(p_api_version,
2215 p_init_msg_list,
2216 x_return_status,
2217 x_msg_count,
2218 x_msg_data,
2219 ddp_avlv_rec,
2220 ddx_avlv_rec);
2221
2222 -- copy data back from the local variables to OUT or IN-OUT args, if any
2223
2224
2225
2226
2227
2228
2229 p6_a0 := rosetta_g_miss_num_map(ddx_avlv_rec.id);
2230 p6_a1 := rosetta_g_miss_num_map(ddx_avlv_rec.object_version_number);
2231 p6_a2 := rosetta_g_miss_num_map(ddx_avlv_rec.try_id);
2232 p6_a3 := rosetta_g_miss_num_map(ddx_avlv_rec.aes_id);
2233 p6_a4 := rosetta_g_miss_num_map(ddx_avlv_rec.sty_id);
2234 p6_a5 := rosetta_g_miss_num_map(ddx_avlv_rec.fma_id);
2235 p6_a6 := rosetta_g_miss_num_map(ddx_avlv_rec.set_of_books_id);
2236 p6_a7 := ddx_avlv_rec.fac_code;
2237 p6_a8 := ddx_avlv_rec.syt_code;
2238 p6_a9 := ddx_avlv_rec.post_to_gl;
2239 p6_a10 := ddx_avlv_rec.advance_arrears;
2240 p6_a11 := ddx_avlv_rec.memo_yn;
2241 p6_a12 := ddx_avlv_rec.prior_year_yn;
2242 p6_a13 := ddx_avlv_rec.name;
2243 p6_a14 := ddx_avlv_rec.description;
2244 p6_a15 := ddx_avlv_rec.version;
2245 p6_a16 := ddx_avlv_rec.factoring_synd_flag;
2246 p6_a17 := ddx_avlv_rec.start_date;
2247 p6_a18 := ddx_avlv_rec.end_date;
2248 p6_a19 := ddx_avlv_rec.accrual_yn;
2249 p6_a20 := ddx_avlv_rec.attribute_category;
2250 p6_a21 := ddx_avlv_rec.attribute1;
2251 p6_a22 := ddx_avlv_rec.attribute2;
2252 p6_a23 := ddx_avlv_rec.attribute3;
2253 p6_a24 := ddx_avlv_rec.attribute4;
2254 p6_a25 := ddx_avlv_rec.attribute5;
2255 p6_a26 := ddx_avlv_rec.attribute6;
2256 p6_a27 := ddx_avlv_rec.attribute7;
2257 p6_a28 := ddx_avlv_rec.attribute8;
2258 p6_a29 := ddx_avlv_rec.attribute9;
2259 p6_a30 := ddx_avlv_rec.attribute10;
2260 p6_a31 := ddx_avlv_rec.attribute11;
2261 p6_a32 := ddx_avlv_rec.attribute12;
2262 p6_a33 := ddx_avlv_rec.attribute13;
2263 p6_a34 := ddx_avlv_rec.attribute14;
2264 p6_a35 := ddx_avlv_rec.attribute15;
2265 p6_a36 := rosetta_g_miss_num_map(ddx_avlv_rec.org_id);
2266 p6_a37 := rosetta_g_miss_num_map(ddx_avlv_rec.created_by);
2267 p6_a38 := ddx_avlv_rec.creation_date;
2268 p6_a39 := rosetta_g_miss_num_map(ddx_avlv_rec.last_updated_by);
2269 p6_a40 := ddx_avlv_rec.last_update_date;
2270 p6_a41 := rosetta_g_miss_num_map(ddx_avlv_rec.last_update_login);
2271 p6_a42 := ddx_avlv_rec.inv_code;
2272 end;
2273
2274 procedure lock_template(p_api_version NUMBER
2275 , p_init_msg_list VARCHAR2
2276 , x_return_status out nocopy VARCHAR2
2277 , x_msg_count out nocopy NUMBER
2278 , x_msg_data out nocopy VARCHAR2
2279 , p5_a0 JTF_NUMBER_TABLE
2280 , p5_a1 JTF_NUMBER_TABLE
2281 , p5_a2 JTF_NUMBER_TABLE
2282 , p5_a3 JTF_NUMBER_TABLE
2283 , p5_a4 JTF_NUMBER_TABLE
2284 , p5_a5 JTF_NUMBER_TABLE
2285 , p5_a6 JTF_NUMBER_TABLE
2286 , p5_a7 JTF_VARCHAR2_TABLE_100
2287 , p5_a8 JTF_VARCHAR2_TABLE_100
2288 , p5_a9 JTF_VARCHAR2_TABLE_100
2289 , p5_a10 JTF_VARCHAR2_TABLE_100
2290 , p5_a11 JTF_VARCHAR2_TABLE_100
2291 , p5_a12 JTF_VARCHAR2_TABLE_100
2292 , p5_a13 JTF_VARCHAR2_TABLE_200
2293 , p5_a14 JTF_VARCHAR2_TABLE_2000
2294 , p5_a15 JTF_VARCHAR2_TABLE_100
2295 , p5_a16 JTF_VARCHAR2_TABLE_100
2296 , p5_a17 JTF_DATE_TABLE
2297 , p5_a18 JTF_DATE_TABLE
2298 , p5_a19 JTF_VARCHAR2_TABLE_100
2299 , p5_a20 JTF_VARCHAR2_TABLE_100
2300 , p5_a21 JTF_VARCHAR2_TABLE_500
2301 , p5_a22 JTF_VARCHAR2_TABLE_500
2302 , p5_a23 JTF_VARCHAR2_TABLE_500
2303 , p5_a24 JTF_VARCHAR2_TABLE_500
2304 , p5_a25 JTF_VARCHAR2_TABLE_500
2305 , p5_a26 JTF_VARCHAR2_TABLE_500
2306 , p5_a27 JTF_VARCHAR2_TABLE_500
2307 , p5_a28 JTF_VARCHAR2_TABLE_500
2308 , p5_a29 JTF_VARCHAR2_TABLE_500
2309 , p5_a30 JTF_VARCHAR2_TABLE_500
2310 , p5_a31 JTF_VARCHAR2_TABLE_500
2311 , p5_a32 JTF_VARCHAR2_TABLE_500
2312 , p5_a33 JTF_VARCHAR2_TABLE_500
2313 , p5_a34 JTF_VARCHAR2_TABLE_500
2314 , p5_a35 JTF_VARCHAR2_TABLE_500
2315 , p5_a36 JTF_NUMBER_TABLE
2316 , p5_a37 JTF_NUMBER_TABLE
2317 , p5_a38 JTF_DATE_TABLE
2318 , p5_a39 JTF_NUMBER_TABLE
2319 , p5_a40 JTF_DATE_TABLE
2320 , p5_a41 JTF_NUMBER_TABLE
2321 , p5_a42 JTF_VARCHAR2_TABLE_100
2322 )
2323
2324 as
2325 ddp_avlv_tbl okl_tmpt_set_pvt.avlv_tbl_type;
2326 ddindx binary_integer; indx binary_integer;
2327 begin
2328
2329 -- copy data to the local IN or IN-OUT args, if any
2330
2331
2332
2333
2334
2335 okl_avl_pvt_w.rosetta_table_copy_in_p5(ddp_avlv_tbl, p5_a0
2336 , p5_a1
2337 , p5_a2
2338 , p5_a3
2339 , p5_a4
2340 , p5_a5
2341 , p5_a6
2342 , p5_a7
2343 , p5_a8
2344 , p5_a9
2345 , p5_a10
2346 , p5_a11
2347 , p5_a12
2348 , p5_a13
2349 , p5_a14
2350 , p5_a15
2351 , p5_a16
2352 , p5_a17
2353 , p5_a18
2354 , p5_a19
2355 , p5_a20
2356 , p5_a21
2357 , p5_a22
2358 , p5_a23
2359 , p5_a24
2360 , p5_a25
2361 , p5_a26
2362 , p5_a27
2363 , p5_a28
2364 , p5_a29
2365 , p5_a30
2366 , p5_a31
2367 , p5_a32
2368 , p5_a33
2369 , p5_a34
2370 , p5_a35
2371 , p5_a36
2372 , p5_a37
2373 , p5_a38
2374 , p5_a39
2375 , p5_a40
2376 , p5_a41
2377 , p5_a42
2378 );
2379
2380 -- here's the delegated call to the old PL/SQL routine
2381 okl_tmpt_set_pvt.lock_template(p_api_version,
2382 p_init_msg_list,
2383 x_return_status,
2384 x_msg_count,
2385 x_msg_data,
2386 ddp_avlv_tbl);
2387
2388 -- copy data back from the local variables to OUT or IN-OUT args, if any
2389
2390
2391
2392
2393
2394 end;
2395
2396 procedure lock_template(p_api_version NUMBER
2397 , p_init_msg_list VARCHAR2
2398 , x_return_status out nocopy VARCHAR2
2399 , x_msg_count out nocopy NUMBER
2400 , x_msg_data out nocopy VARCHAR2
2401 , p5_a0 NUMBER := 0-1962.0724
2402 , p5_a1 NUMBER := 0-1962.0724
2403 , p5_a2 NUMBER := 0-1962.0724
2404 , p5_a3 NUMBER := 0-1962.0724
2405 , p5_a4 NUMBER := 0-1962.0724
2406 , p5_a5 NUMBER := 0-1962.0724
2407 , p5_a6 NUMBER := 0-1962.0724
2408 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2409 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2410 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2411 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2412 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2413 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2414 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2415 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2416 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2417 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2418 , p5_a17 DATE := fnd_api.g_miss_date
2419 , p5_a18 DATE := fnd_api.g_miss_date
2420 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2421 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2422 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2423 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2424 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2425 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2426 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2427 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2428 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2429 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2430 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2431 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2432 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2433 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2434 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2435 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
2436 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
2437 , p5_a36 NUMBER := 0-1962.0724
2438 , p5_a37 NUMBER := 0-1962.0724
2439 , p5_a38 DATE := fnd_api.g_miss_date
2440 , p5_a39 NUMBER := 0-1962.0724
2441 , p5_a40 DATE := fnd_api.g_miss_date
2442 , p5_a41 NUMBER := 0-1962.0724
2443 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
2444 )
2445
2446 as
2447 ddp_avlv_rec okl_tmpt_set_pvt.avlv_rec_type;
2448 ddindx binary_integer; indx binary_integer;
2449 begin
2450
2451 -- copy data to the local IN or IN-OUT args, if any
2452
2453
2454
2455
2456
2457 ddp_avlv_rec.id := rosetta_g_miss_num_map(p5_a0);
2458 ddp_avlv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
2459 ddp_avlv_rec.try_id := rosetta_g_miss_num_map(p5_a2);
2460 ddp_avlv_rec.aes_id := rosetta_g_miss_num_map(p5_a3);
2461 ddp_avlv_rec.sty_id := rosetta_g_miss_num_map(p5_a4);
2462 ddp_avlv_rec.fma_id := rosetta_g_miss_num_map(p5_a5);
2463 ddp_avlv_rec.set_of_books_id := rosetta_g_miss_num_map(p5_a6);
2464 ddp_avlv_rec.fac_code := p5_a7;
2465 ddp_avlv_rec.syt_code := p5_a8;
2466 ddp_avlv_rec.post_to_gl := p5_a9;
2467 ddp_avlv_rec.advance_arrears := p5_a10;
2468 ddp_avlv_rec.memo_yn := p5_a11;
2469 ddp_avlv_rec.prior_year_yn := p5_a12;
2470 ddp_avlv_rec.name := p5_a13;
2471 ddp_avlv_rec.description := p5_a14;
2472 ddp_avlv_rec.version := p5_a15;
2473 ddp_avlv_rec.factoring_synd_flag := p5_a16;
2474 ddp_avlv_rec.start_date := rosetta_g_miss_date_in_map(p5_a17);
2475 ddp_avlv_rec.end_date := rosetta_g_miss_date_in_map(p5_a18);
2476 ddp_avlv_rec.accrual_yn := p5_a19;
2477 ddp_avlv_rec.attribute_category := p5_a20;
2478 ddp_avlv_rec.attribute1 := p5_a21;
2479 ddp_avlv_rec.attribute2 := p5_a22;
2480 ddp_avlv_rec.attribute3 := p5_a23;
2481 ddp_avlv_rec.attribute4 := p5_a24;
2482 ddp_avlv_rec.attribute5 := p5_a25;
2483 ddp_avlv_rec.attribute6 := p5_a26;
2484 ddp_avlv_rec.attribute7 := p5_a27;
2485 ddp_avlv_rec.attribute8 := p5_a28;
2486 ddp_avlv_rec.attribute9 := p5_a29;
2487 ddp_avlv_rec.attribute10 := p5_a30;
2488 ddp_avlv_rec.attribute11 := p5_a31;
2489 ddp_avlv_rec.attribute12 := p5_a32;
2490 ddp_avlv_rec.attribute13 := p5_a33;
2491 ddp_avlv_rec.attribute14 := p5_a34;
2492 ddp_avlv_rec.attribute15 := p5_a35;
2493 ddp_avlv_rec.org_id := rosetta_g_miss_num_map(p5_a36);
2494 ddp_avlv_rec.created_by := rosetta_g_miss_num_map(p5_a37);
2495 ddp_avlv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a38);
2496 ddp_avlv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a39);
2497 ddp_avlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a40);
2498 ddp_avlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a41);
2499 ddp_avlv_rec.inv_code := p5_a42;
2500
2501 -- here's the delegated call to the old PL/SQL routine
2502 okl_tmpt_set_pvt.lock_template(p_api_version,
2503 p_init_msg_list,
2504 x_return_status,
2505 x_msg_count,
2506 x_msg_data,
2507 ddp_avlv_rec);
2508
2509 -- copy data back from the local variables to OUT or IN-OUT args, if any
2510
2511
2512
2513
2514
2515 end;
2516
2517 procedure update_template(p_api_version NUMBER
2518 , p_init_msg_list VARCHAR2
2519 , x_return_status out nocopy VARCHAR2
2520 , x_msg_count out nocopy NUMBER
2521 , x_msg_data out nocopy VARCHAR2
2522 , p5_a0 JTF_NUMBER_TABLE
2523 , p5_a1 JTF_NUMBER_TABLE
2524 , p5_a2 JTF_NUMBER_TABLE
2525 , p5_a3 JTF_NUMBER_TABLE
2526 , p5_a4 JTF_NUMBER_TABLE
2527 , p5_a5 JTF_NUMBER_TABLE
2528 , p5_a6 JTF_NUMBER_TABLE
2529 , p5_a7 JTF_VARCHAR2_TABLE_100
2530 , p5_a8 JTF_VARCHAR2_TABLE_100
2531 , p5_a9 JTF_VARCHAR2_TABLE_100
2532 , p5_a10 JTF_VARCHAR2_TABLE_100
2533 , p5_a11 JTF_VARCHAR2_TABLE_100
2534 , p5_a12 JTF_VARCHAR2_TABLE_100
2535 , p5_a13 JTF_VARCHAR2_TABLE_200
2536 , p5_a14 JTF_VARCHAR2_TABLE_2000
2537 , p5_a15 JTF_VARCHAR2_TABLE_100
2538 , p5_a16 JTF_VARCHAR2_TABLE_100
2539 , p5_a17 JTF_DATE_TABLE
2540 , p5_a18 JTF_DATE_TABLE
2541 , p5_a19 JTF_VARCHAR2_TABLE_100
2542 , p5_a20 JTF_VARCHAR2_TABLE_100
2543 , p5_a21 JTF_VARCHAR2_TABLE_500
2544 , p5_a22 JTF_VARCHAR2_TABLE_500
2545 , p5_a23 JTF_VARCHAR2_TABLE_500
2546 , p5_a24 JTF_VARCHAR2_TABLE_500
2547 , p5_a25 JTF_VARCHAR2_TABLE_500
2548 , p5_a26 JTF_VARCHAR2_TABLE_500
2549 , p5_a27 JTF_VARCHAR2_TABLE_500
2550 , p5_a28 JTF_VARCHAR2_TABLE_500
2551 , p5_a29 JTF_VARCHAR2_TABLE_500
2552 , p5_a30 JTF_VARCHAR2_TABLE_500
2553 , p5_a31 JTF_VARCHAR2_TABLE_500
2554 , p5_a32 JTF_VARCHAR2_TABLE_500
2555 , p5_a33 JTF_VARCHAR2_TABLE_500
2556 , p5_a34 JTF_VARCHAR2_TABLE_500
2557 , p5_a35 JTF_VARCHAR2_TABLE_500
2558 , p5_a36 JTF_NUMBER_TABLE
2559 , p5_a37 JTF_NUMBER_TABLE
2560 , p5_a38 JTF_DATE_TABLE
2561 , p5_a39 JTF_NUMBER_TABLE
2562 , p5_a40 JTF_DATE_TABLE
2563 , p5_a41 JTF_NUMBER_TABLE
2564 , p5_a42 JTF_VARCHAR2_TABLE_100
2565 , p6_a0 out nocopy JTF_NUMBER_TABLE
2566 , p6_a1 out nocopy JTF_NUMBER_TABLE
2567 , p6_a2 out nocopy JTF_NUMBER_TABLE
2568 , p6_a3 out nocopy JTF_NUMBER_TABLE
2569 , p6_a4 out nocopy JTF_NUMBER_TABLE
2570 , p6_a5 out nocopy JTF_NUMBER_TABLE
2571 , p6_a6 out nocopy JTF_NUMBER_TABLE
2572 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
2573 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
2574 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
2575 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
2576 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
2577 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
2578 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
2579 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_2000
2580 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
2581 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
2582 , p6_a17 out nocopy JTF_DATE_TABLE
2583 , p6_a18 out nocopy JTF_DATE_TABLE
2584 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
2585 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
2586 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
2587 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
2588 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
2589 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
2590 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
2591 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
2592 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
2593 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
2594 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
2595 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
2596 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
2597 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
2598 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
2599 , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
2600 , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
2601 , p6_a36 out nocopy JTF_NUMBER_TABLE
2602 , p6_a37 out nocopy JTF_NUMBER_TABLE
2603 , p6_a38 out nocopy JTF_DATE_TABLE
2604 , p6_a39 out nocopy JTF_NUMBER_TABLE
2605 , p6_a40 out nocopy JTF_DATE_TABLE
2606 , p6_a41 out nocopy JTF_NUMBER_TABLE
2607 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
2608 )
2609
2610 as
2611 ddp_avlv_tbl okl_tmpt_set_pvt.avlv_tbl_type;
2612 ddx_avlv_tbl okl_tmpt_set_pvt.avlv_tbl_type;
2613 ddindx binary_integer; indx binary_integer;
2614 begin
2615
2616 -- copy data to the local IN or IN-OUT args, if any
2617
2618
2619
2620
2621
2622 okl_avl_pvt_w.rosetta_table_copy_in_p5(ddp_avlv_tbl, p5_a0
2623 , p5_a1
2624 , p5_a2
2625 , p5_a3
2626 , p5_a4
2627 , p5_a5
2628 , p5_a6
2629 , p5_a7
2630 , p5_a8
2631 , p5_a9
2632 , p5_a10
2633 , p5_a11
2634 , p5_a12
2635 , p5_a13
2636 , p5_a14
2637 , p5_a15
2638 , p5_a16
2639 , p5_a17
2640 , p5_a18
2641 , p5_a19
2642 , p5_a20
2643 , p5_a21
2644 , p5_a22
2645 , p5_a23
2646 , p5_a24
2647 , p5_a25
2648 , p5_a26
2649 , p5_a27
2650 , p5_a28
2651 , p5_a29
2652 , p5_a30
2653 , p5_a31
2654 , p5_a32
2655 , p5_a33
2656 , p5_a34
2657 , p5_a35
2658 , p5_a36
2659 , p5_a37
2660 , p5_a38
2661 , p5_a39
2662 , p5_a40
2663 , p5_a41
2664 , p5_a42
2665 );
2666
2667
2668 -- here's the delegated call to the old PL/SQL routine
2669 okl_tmpt_set_pvt.update_template(p_api_version,
2670 p_init_msg_list,
2671 x_return_status,
2672 x_msg_count,
2673 x_msg_data,
2674 ddp_avlv_tbl,
2675 ddx_avlv_tbl);
2676
2677 -- copy data back from the local variables to OUT or IN-OUT args, if any
2678
2679
2680
2681
2682
2683
2684 okl_avl_pvt_w.rosetta_table_copy_out_p5(ddx_avlv_tbl, p6_a0
2685 , p6_a1
2686 , p6_a2
2687 , p6_a3
2688 , p6_a4
2689 , p6_a5
2690 , p6_a6
2691 , p6_a7
2692 , p6_a8
2693 , p6_a9
2694 , p6_a10
2695 , p6_a11
2696 , p6_a12
2697 , p6_a13
2698 , p6_a14
2699 , p6_a15
2700 , p6_a16
2701 , p6_a17
2702 , p6_a18
2703 , p6_a19
2704 , p6_a20
2705 , p6_a21
2706 , p6_a22
2707 , p6_a23
2708 , p6_a24
2709 , p6_a25
2710 , p6_a26
2711 , p6_a27
2712 , p6_a28
2713 , p6_a29
2714 , p6_a30
2715 , p6_a31
2716 , p6_a32
2717 , p6_a33
2718 , p6_a34
2719 , p6_a35
2720 , p6_a36
2721 , p6_a37
2722 , p6_a38
2723 , p6_a39
2724 , p6_a40
2725 , p6_a41
2726 , p6_a42
2727 );
2728 end;
2729
2730 procedure update_template(p_api_version NUMBER
2731 , p_init_msg_list VARCHAR2
2732 , x_return_status out nocopy VARCHAR2
2733 , x_msg_count out nocopy NUMBER
2734 , x_msg_data out nocopy VARCHAR2
2735 , p6_a0 out nocopy NUMBER
2736 , p6_a1 out nocopy NUMBER
2737 , p6_a2 out nocopy NUMBER
2738 , p6_a3 out nocopy NUMBER
2739 , p6_a4 out nocopy NUMBER
2740 , p6_a5 out nocopy NUMBER
2741 , p6_a6 out nocopy NUMBER
2742 , p6_a7 out nocopy VARCHAR2
2743 , p6_a8 out nocopy VARCHAR2
2744 , p6_a9 out nocopy VARCHAR2
2745 , p6_a10 out nocopy VARCHAR2
2746 , p6_a11 out nocopy VARCHAR2
2747 , p6_a12 out nocopy VARCHAR2
2748 , p6_a13 out nocopy VARCHAR2
2749 , p6_a14 out nocopy VARCHAR2
2750 , p6_a15 out nocopy VARCHAR2
2751 , p6_a16 out nocopy VARCHAR2
2752 , p6_a17 out nocopy DATE
2753 , p6_a18 out nocopy DATE
2754 , p6_a19 out nocopy VARCHAR2
2755 , p6_a20 out nocopy VARCHAR2
2756 , p6_a21 out nocopy VARCHAR2
2757 , p6_a22 out nocopy VARCHAR2
2758 , p6_a23 out nocopy VARCHAR2
2759 , p6_a24 out nocopy VARCHAR2
2760 , p6_a25 out nocopy VARCHAR2
2761 , p6_a26 out nocopy VARCHAR2
2762 , p6_a27 out nocopy VARCHAR2
2763 , p6_a28 out nocopy VARCHAR2
2764 , p6_a29 out nocopy VARCHAR2
2765 , p6_a30 out nocopy VARCHAR2
2766 , p6_a31 out nocopy VARCHAR2
2767 , p6_a32 out nocopy VARCHAR2
2768 , p6_a33 out nocopy VARCHAR2
2769 , p6_a34 out nocopy VARCHAR2
2770 , p6_a35 out nocopy VARCHAR2
2771 , p6_a36 out nocopy NUMBER
2772 , p6_a37 out nocopy NUMBER
2773 , p6_a38 out nocopy DATE
2774 , p6_a39 out nocopy NUMBER
2775 , p6_a40 out nocopy DATE
2776 , p6_a41 out nocopy NUMBER
2777 , p6_a42 out nocopy VARCHAR2
2778 , p5_a0 NUMBER := 0-1962.0724
2779 , p5_a1 NUMBER := 0-1962.0724
2780 , p5_a2 NUMBER := 0-1962.0724
2781 , p5_a3 NUMBER := 0-1962.0724
2782 , p5_a4 NUMBER := 0-1962.0724
2783 , p5_a5 NUMBER := 0-1962.0724
2784 , p5_a6 NUMBER := 0-1962.0724
2785 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2786 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2787 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2788 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2789 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2790 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2791 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2792 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2793 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2794 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2795 , p5_a17 DATE := fnd_api.g_miss_date
2796 , p5_a18 DATE := fnd_api.g_miss_date
2797 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2798 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2799 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2800 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2801 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2802 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2803 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2804 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2805 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2806 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2807 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2808 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2809 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2810 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2811 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2812 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
2813 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
2814 , p5_a36 NUMBER := 0-1962.0724
2815 , p5_a37 NUMBER := 0-1962.0724
2816 , p5_a38 DATE := fnd_api.g_miss_date
2817 , p5_a39 NUMBER := 0-1962.0724
2818 , p5_a40 DATE := fnd_api.g_miss_date
2819 , p5_a41 NUMBER := 0-1962.0724
2820 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
2821 )
2822
2823 as
2824 ddp_avlv_rec okl_tmpt_set_pvt.avlv_rec_type;
2825 ddx_avlv_rec okl_tmpt_set_pvt.avlv_rec_type;
2826 ddindx binary_integer; indx binary_integer;
2827 begin
2828
2829 -- copy data to the local IN or IN-OUT args, if any
2830
2831
2832
2833
2834
2835 ddp_avlv_rec.id := rosetta_g_miss_num_map(p5_a0);
2836 ddp_avlv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
2837 ddp_avlv_rec.try_id := rosetta_g_miss_num_map(p5_a2);
2838 ddp_avlv_rec.aes_id := rosetta_g_miss_num_map(p5_a3);
2839 ddp_avlv_rec.sty_id := rosetta_g_miss_num_map(p5_a4);
2840 ddp_avlv_rec.fma_id := rosetta_g_miss_num_map(p5_a5);
2841 ddp_avlv_rec.set_of_books_id := rosetta_g_miss_num_map(p5_a6);
2842 ddp_avlv_rec.fac_code := p5_a7;
2843 ddp_avlv_rec.syt_code := p5_a8;
2844 ddp_avlv_rec.post_to_gl := p5_a9;
2845 ddp_avlv_rec.advance_arrears := p5_a10;
2846 ddp_avlv_rec.memo_yn := p5_a11;
2847 ddp_avlv_rec.prior_year_yn := p5_a12;
2848 ddp_avlv_rec.name := p5_a13;
2849 ddp_avlv_rec.description := p5_a14;
2850 ddp_avlv_rec.version := p5_a15;
2851 ddp_avlv_rec.factoring_synd_flag := p5_a16;
2852 ddp_avlv_rec.start_date := rosetta_g_miss_date_in_map(p5_a17);
2853 ddp_avlv_rec.end_date := rosetta_g_miss_date_in_map(p5_a18);
2854 ddp_avlv_rec.accrual_yn := p5_a19;
2855 ddp_avlv_rec.attribute_category := p5_a20;
2856 ddp_avlv_rec.attribute1 := p5_a21;
2857 ddp_avlv_rec.attribute2 := p5_a22;
2858 ddp_avlv_rec.attribute3 := p5_a23;
2859 ddp_avlv_rec.attribute4 := p5_a24;
2860 ddp_avlv_rec.attribute5 := p5_a25;
2861 ddp_avlv_rec.attribute6 := p5_a26;
2862 ddp_avlv_rec.attribute7 := p5_a27;
2863 ddp_avlv_rec.attribute8 := p5_a28;
2864 ddp_avlv_rec.attribute9 := p5_a29;
2865 ddp_avlv_rec.attribute10 := p5_a30;
2866 ddp_avlv_rec.attribute11 := p5_a31;
2867 ddp_avlv_rec.attribute12 := p5_a32;
2868 ddp_avlv_rec.attribute13 := p5_a33;
2869 ddp_avlv_rec.attribute14 := p5_a34;
2870 ddp_avlv_rec.attribute15 := p5_a35;
2871 ddp_avlv_rec.org_id := rosetta_g_miss_num_map(p5_a36);
2872 ddp_avlv_rec.created_by := rosetta_g_miss_num_map(p5_a37);
2873 ddp_avlv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a38);
2874 ddp_avlv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a39);
2875 ddp_avlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a40);
2876 ddp_avlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a41);
2877 ddp_avlv_rec.inv_code := p5_a42;
2878
2879
2880 -- here's the delegated call to the old PL/SQL routine
2881 okl_tmpt_set_pvt.update_template(p_api_version,
2882 p_init_msg_list,
2883 x_return_status,
2884 x_msg_count,
2885 x_msg_data,
2886 ddp_avlv_rec,
2887 ddx_avlv_rec);
2888
2889 -- copy data back from the local variables to OUT or IN-OUT args, if any
2890
2891
2892
2893
2894
2895
2896 p6_a0 := rosetta_g_miss_num_map(ddx_avlv_rec.id);
2897 p6_a1 := rosetta_g_miss_num_map(ddx_avlv_rec.object_version_number);
2898 p6_a2 := rosetta_g_miss_num_map(ddx_avlv_rec.try_id);
2899 p6_a3 := rosetta_g_miss_num_map(ddx_avlv_rec.aes_id);
2900 p6_a4 := rosetta_g_miss_num_map(ddx_avlv_rec.sty_id);
2901 p6_a5 := rosetta_g_miss_num_map(ddx_avlv_rec.fma_id);
2902 p6_a6 := rosetta_g_miss_num_map(ddx_avlv_rec.set_of_books_id);
2903 p6_a7 := ddx_avlv_rec.fac_code;
2904 p6_a8 := ddx_avlv_rec.syt_code;
2905 p6_a9 := ddx_avlv_rec.post_to_gl;
2906 p6_a10 := ddx_avlv_rec.advance_arrears;
2907 p6_a11 := ddx_avlv_rec.memo_yn;
2908 p6_a12 := ddx_avlv_rec.prior_year_yn;
2909 p6_a13 := ddx_avlv_rec.name;
2910 p6_a14 := ddx_avlv_rec.description;
2911 p6_a15 := ddx_avlv_rec.version;
2912 p6_a16 := ddx_avlv_rec.factoring_synd_flag;
2913 p6_a17 := ddx_avlv_rec.start_date;
2914 p6_a18 := ddx_avlv_rec.end_date;
2915 p6_a19 := ddx_avlv_rec.accrual_yn;
2916 p6_a20 := ddx_avlv_rec.attribute_category;
2917 p6_a21 := ddx_avlv_rec.attribute1;
2918 p6_a22 := ddx_avlv_rec.attribute2;
2919 p6_a23 := ddx_avlv_rec.attribute3;
2920 p6_a24 := ddx_avlv_rec.attribute4;
2921 p6_a25 := ddx_avlv_rec.attribute5;
2922 p6_a26 := ddx_avlv_rec.attribute6;
2923 p6_a27 := ddx_avlv_rec.attribute7;
2924 p6_a28 := ddx_avlv_rec.attribute8;
2925 p6_a29 := ddx_avlv_rec.attribute9;
2926 p6_a30 := ddx_avlv_rec.attribute10;
2927 p6_a31 := ddx_avlv_rec.attribute11;
2928 p6_a32 := ddx_avlv_rec.attribute12;
2929 p6_a33 := ddx_avlv_rec.attribute13;
2930 p6_a34 := ddx_avlv_rec.attribute14;
2931 p6_a35 := ddx_avlv_rec.attribute15;
2932 p6_a36 := rosetta_g_miss_num_map(ddx_avlv_rec.org_id);
2933 p6_a37 := rosetta_g_miss_num_map(ddx_avlv_rec.created_by);
2934 p6_a38 := ddx_avlv_rec.creation_date;
2935 p6_a39 := rosetta_g_miss_num_map(ddx_avlv_rec.last_updated_by);
2936 p6_a40 := ddx_avlv_rec.last_update_date;
2937 p6_a41 := rosetta_g_miss_num_map(ddx_avlv_rec.last_update_login);
2938 p6_a42 := ddx_avlv_rec.inv_code;
2939 end;
2940
2941 procedure delete_template(p_api_version NUMBER
2942 , p_init_msg_list VARCHAR2
2943 , x_return_status out nocopy VARCHAR2
2944 , x_msg_count out nocopy NUMBER
2945 , x_msg_data out nocopy VARCHAR2
2946 , p5_a0 JTF_NUMBER_TABLE
2947 , p5_a1 JTF_NUMBER_TABLE
2948 , p5_a2 JTF_NUMBER_TABLE
2949 , p5_a3 JTF_NUMBER_TABLE
2950 , p5_a4 JTF_NUMBER_TABLE
2951 , p5_a5 JTF_NUMBER_TABLE
2952 , p5_a6 JTF_NUMBER_TABLE
2953 , p5_a7 JTF_VARCHAR2_TABLE_100
2954 , p5_a8 JTF_VARCHAR2_TABLE_100
2955 , p5_a9 JTF_VARCHAR2_TABLE_100
2956 , p5_a10 JTF_VARCHAR2_TABLE_100
2957 , p5_a11 JTF_VARCHAR2_TABLE_100
2958 , p5_a12 JTF_VARCHAR2_TABLE_100
2959 , p5_a13 JTF_VARCHAR2_TABLE_200
2960 , p5_a14 JTF_VARCHAR2_TABLE_2000
2961 , p5_a15 JTF_VARCHAR2_TABLE_100
2962 , p5_a16 JTF_VARCHAR2_TABLE_100
2963 , p5_a17 JTF_DATE_TABLE
2964 , p5_a18 JTF_DATE_TABLE
2965 , p5_a19 JTF_VARCHAR2_TABLE_100
2966 , p5_a20 JTF_VARCHAR2_TABLE_100
2967 , p5_a21 JTF_VARCHAR2_TABLE_500
2968 , p5_a22 JTF_VARCHAR2_TABLE_500
2969 , p5_a23 JTF_VARCHAR2_TABLE_500
2970 , p5_a24 JTF_VARCHAR2_TABLE_500
2971 , p5_a25 JTF_VARCHAR2_TABLE_500
2972 , p5_a26 JTF_VARCHAR2_TABLE_500
2973 , p5_a27 JTF_VARCHAR2_TABLE_500
2974 , p5_a28 JTF_VARCHAR2_TABLE_500
2975 , p5_a29 JTF_VARCHAR2_TABLE_500
2976 , p5_a30 JTF_VARCHAR2_TABLE_500
2977 , p5_a31 JTF_VARCHAR2_TABLE_500
2978 , p5_a32 JTF_VARCHAR2_TABLE_500
2979 , p5_a33 JTF_VARCHAR2_TABLE_500
2980 , p5_a34 JTF_VARCHAR2_TABLE_500
2981 , p5_a35 JTF_VARCHAR2_TABLE_500
2982 , p5_a36 JTF_NUMBER_TABLE
2983 , p5_a37 JTF_NUMBER_TABLE
2984 , p5_a38 JTF_DATE_TABLE
2985 , p5_a39 JTF_NUMBER_TABLE
2986 , p5_a40 JTF_DATE_TABLE
2987 , p5_a41 JTF_NUMBER_TABLE
2988 , p5_a42 JTF_VARCHAR2_TABLE_100
2989 )
2990
2991 as
2992 ddp_avlv_tbl okl_tmpt_set_pvt.avlv_tbl_type;
2993 ddindx binary_integer; indx binary_integer;
2994 begin
2995
2996 -- copy data to the local IN or IN-OUT args, if any
2997
2998
2999
3000
3001
3002 okl_avl_pvt_w.rosetta_table_copy_in_p5(ddp_avlv_tbl, p5_a0
3003 , p5_a1
3004 , p5_a2
3005 , p5_a3
3006 , p5_a4
3007 , p5_a5
3008 , p5_a6
3009 , p5_a7
3010 , p5_a8
3011 , p5_a9
3012 , p5_a10
3013 , p5_a11
3014 , p5_a12
3015 , p5_a13
3016 , p5_a14
3017 , p5_a15
3018 , p5_a16
3019 , p5_a17
3020 , p5_a18
3021 , p5_a19
3022 , p5_a20
3023 , p5_a21
3024 , p5_a22
3025 , p5_a23
3026 , p5_a24
3027 , p5_a25
3028 , p5_a26
3029 , p5_a27
3030 , p5_a28
3031 , p5_a29
3032 , p5_a30
3033 , p5_a31
3034 , p5_a32
3035 , p5_a33
3036 , p5_a34
3037 , p5_a35
3038 , p5_a36
3039 , p5_a37
3040 , p5_a38
3041 , p5_a39
3042 , p5_a40
3043 , p5_a41
3044 , p5_a42
3045 );
3046
3047 -- here's the delegated call to the old PL/SQL routine
3048 okl_tmpt_set_pvt.delete_template(p_api_version,
3049 p_init_msg_list,
3050 x_return_status,
3051 x_msg_count,
3052 x_msg_data,
3053 ddp_avlv_tbl);
3054
3055 -- copy data back from the local variables to OUT or IN-OUT args, if any
3056
3057
3058
3059
3060
3061 end;
3062
3063 procedure delete_template(p_api_version NUMBER
3064 , p_init_msg_list VARCHAR2
3065 , x_return_status out nocopy VARCHAR2
3066 , x_msg_count out nocopy NUMBER
3067 , x_msg_data out nocopy VARCHAR2
3068 , p5_a0 NUMBER := 0-1962.0724
3069 , p5_a1 NUMBER := 0-1962.0724
3070 , p5_a2 NUMBER := 0-1962.0724
3071 , p5_a3 NUMBER := 0-1962.0724
3072 , p5_a4 NUMBER := 0-1962.0724
3073 , p5_a5 NUMBER := 0-1962.0724
3074 , p5_a6 NUMBER := 0-1962.0724
3075 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
3076 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
3077 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
3078 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
3079 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
3080 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
3081 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
3082 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
3083 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
3084 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
3085 , p5_a17 DATE := fnd_api.g_miss_date
3086 , p5_a18 DATE := fnd_api.g_miss_date
3087 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
3088 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
3089 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
3090 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
3091 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
3092 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
3093 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
3094 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
3095 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
3096 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
3097 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
3098 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
3099 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
3100 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
3101 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
3102 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
3103 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
3104 , p5_a36 NUMBER := 0-1962.0724
3105 , p5_a37 NUMBER := 0-1962.0724
3106 , p5_a38 DATE := fnd_api.g_miss_date
3107 , p5_a39 NUMBER := 0-1962.0724
3108 , p5_a40 DATE := fnd_api.g_miss_date
3109 , p5_a41 NUMBER := 0-1962.0724
3110 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
3111 )
3112
3113 as
3114 ddp_avlv_rec okl_tmpt_set_pvt.avlv_rec_type;
3115 ddindx binary_integer; indx binary_integer;
3116 begin
3117
3118 -- copy data to the local IN or IN-OUT args, if any
3119
3120
3121
3122
3123
3124 ddp_avlv_rec.id := rosetta_g_miss_num_map(p5_a0);
3125 ddp_avlv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
3126 ddp_avlv_rec.try_id := rosetta_g_miss_num_map(p5_a2);
3127 ddp_avlv_rec.aes_id := rosetta_g_miss_num_map(p5_a3);
3128 ddp_avlv_rec.sty_id := rosetta_g_miss_num_map(p5_a4);
3129 ddp_avlv_rec.fma_id := rosetta_g_miss_num_map(p5_a5);
3130 ddp_avlv_rec.set_of_books_id := rosetta_g_miss_num_map(p5_a6);
3131 ddp_avlv_rec.fac_code := p5_a7;
3132 ddp_avlv_rec.syt_code := p5_a8;
3133 ddp_avlv_rec.post_to_gl := p5_a9;
3134 ddp_avlv_rec.advance_arrears := p5_a10;
3135 ddp_avlv_rec.memo_yn := p5_a11;
3136 ddp_avlv_rec.prior_year_yn := p5_a12;
3137 ddp_avlv_rec.name := p5_a13;
3138 ddp_avlv_rec.description := p5_a14;
3139 ddp_avlv_rec.version := p5_a15;
3140 ddp_avlv_rec.factoring_synd_flag := p5_a16;
3141 ddp_avlv_rec.start_date := rosetta_g_miss_date_in_map(p5_a17);
3142 ddp_avlv_rec.end_date := rosetta_g_miss_date_in_map(p5_a18);
3143 ddp_avlv_rec.accrual_yn := p5_a19;
3144 ddp_avlv_rec.attribute_category := p5_a20;
3145 ddp_avlv_rec.attribute1 := p5_a21;
3146 ddp_avlv_rec.attribute2 := p5_a22;
3147 ddp_avlv_rec.attribute3 := p5_a23;
3148 ddp_avlv_rec.attribute4 := p5_a24;
3149 ddp_avlv_rec.attribute5 := p5_a25;
3150 ddp_avlv_rec.attribute6 := p5_a26;
3151 ddp_avlv_rec.attribute7 := p5_a27;
3152 ddp_avlv_rec.attribute8 := p5_a28;
3153 ddp_avlv_rec.attribute9 := p5_a29;
3154 ddp_avlv_rec.attribute10 := p5_a30;
3155 ddp_avlv_rec.attribute11 := p5_a31;
3156 ddp_avlv_rec.attribute12 := p5_a32;
3157 ddp_avlv_rec.attribute13 := p5_a33;
3158 ddp_avlv_rec.attribute14 := p5_a34;
3159 ddp_avlv_rec.attribute15 := p5_a35;
3160 ddp_avlv_rec.org_id := rosetta_g_miss_num_map(p5_a36);
3161 ddp_avlv_rec.created_by := rosetta_g_miss_num_map(p5_a37);
3162 ddp_avlv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a38);
3163 ddp_avlv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a39);
3164 ddp_avlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a40);
3165 ddp_avlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a41);
3166 ddp_avlv_rec.inv_code := p5_a42;
3167
3168 -- here's the delegated call to the old PL/SQL routine
3169 okl_tmpt_set_pvt.delete_template(p_api_version,
3170 p_init_msg_list,
3171 x_return_status,
3172 x_msg_count,
3173 x_msg_data,
3174 ddp_avlv_rec);
3175
3176 -- copy data back from the local variables to OUT or IN-OUT args, if any
3177
3178
3179
3180
3181
3182 end;
3183
3184 procedure validate_template(p_api_version NUMBER
3185 , p_init_msg_list VARCHAR2
3186 , x_return_status out nocopy VARCHAR2
3187 , x_msg_count out nocopy NUMBER
3188 , x_msg_data out nocopy VARCHAR2
3189 , p5_a0 JTF_NUMBER_TABLE
3190 , p5_a1 JTF_NUMBER_TABLE
3191 , p5_a2 JTF_NUMBER_TABLE
3192 , p5_a3 JTF_NUMBER_TABLE
3193 , p5_a4 JTF_NUMBER_TABLE
3194 , p5_a5 JTF_NUMBER_TABLE
3195 , p5_a6 JTF_NUMBER_TABLE
3196 , p5_a7 JTF_VARCHAR2_TABLE_100
3197 , p5_a8 JTF_VARCHAR2_TABLE_100
3198 , p5_a9 JTF_VARCHAR2_TABLE_100
3199 , p5_a10 JTF_VARCHAR2_TABLE_100
3200 , p5_a11 JTF_VARCHAR2_TABLE_100
3201 , p5_a12 JTF_VARCHAR2_TABLE_100
3202 , p5_a13 JTF_VARCHAR2_TABLE_200
3203 , p5_a14 JTF_VARCHAR2_TABLE_2000
3204 , p5_a15 JTF_VARCHAR2_TABLE_100
3205 , p5_a16 JTF_VARCHAR2_TABLE_100
3206 , p5_a17 JTF_DATE_TABLE
3207 , p5_a18 JTF_DATE_TABLE
3208 , p5_a19 JTF_VARCHAR2_TABLE_100
3209 , p5_a20 JTF_VARCHAR2_TABLE_100
3210 , p5_a21 JTF_VARCHAR2_TABLE_500
3211 , p5_a22 JTF_VARCHAR2_TABLE_500
3212 , p5_a23 JTF_VARCHAR2_TABLE_500
3213 , p5_a24 JTF_VARCHAR2_TABLE_500
3214 , p5_a25 JTF_VARCHAR2_TABLE_500
3215 , p5_a26 JTF_VARCHAR2_TABLE_500
3216 , p5_a27 JTF_VARCHAR2_TABLE_500
3217 , p5_a28 JTF_VARCHAR2_TABLE_500
3218 , p5_a29 JTF_VARCHAR2_TABLE_500
3219 , p5_a30 JTF_VARCHAR2_TABLE_500
3220 , p5_a31 JTF_VARCHAR2_TABLE_500
3221 , p5_a32 JTF_VARCHAR2_TABLE_500
3222 , p5_a33 JTF_VARCHAR2_TABLE_500
3223 , p5_a34 JTF_VARCHAR2_TABLE_500
3224 , p5_a35 JTF_VARCHAR2_TABLE_500
3225 , p5_a36 JTF_NUMBER_TABLE
3226 , p5_a37 JTF_NUMBER_TABLE
3227 , p5_a38 JTF_DATE_TABLE
3228 , p5_a39 JTF_NUMBER_TABLE
3229 , p5_a40 JTF_DATE_TABLE
3230 , p5_a41 JTF_NUMBER_TABLE
3231 , p5_a42 JTF_VARCHAR2_TABLE_100
3232 )
3233
3234 as
3235 ddp_avlv_tbl okl_tmpt_set_pvt.avlv_tbl_type;
3236 ddindx binary_integer; indx binary_integer;
3237 begin
3238
3239 -- copy data to the local IN or IN-OUT args, if any
3240
3241
3242
3243
3244
3245 okl_avl_pvt_w.rosetta_table_copy_in_p5(ddp_avlv_tbl, p5_a0
3246 , p5_a1
3247 , p5_a2
3248 , p5_a3
3249 , p5_a4
3250 , p5_a5
3251 , p5_a6
3252 , p5_a7
3253 , p5_a8
3254 , p5_a9
3255 , p5_a10
3256 , p5_a11
3257 , p5_a12
3258 , p5_a13
3259 , p5_a14
3260 , p5_a15
3261 , p5_a16
3262 , p5_a17
3263 , p5_a18
3264 , p5_a19
3265 , p5_a20
3266 , p5_a21
3267 , p5_a22
3268 , p5_a23
3269 , p5_a24
3270 , p5_a25
3271 , p5_a26
3272 , p5_a27
3273 , p5_a28
3274 , p5_a29
3275 , p5_a30
3276 , p5_a31
3277 , p5_a32
3278 , p5_a33
3279 , p5_a34
3280 , p5_a35
3281 , p5_a36
3282 , p5_a37
3283 , p5_a38
3284 , p5_a39
3285 , p5_a40
3286 , p5_a41
3287 , p5_a42
3288 );
3289
3290 -- here's the delegated call to the old PL/SQL routine
3291 okl_tmpt_set_pvt.validate_template(p_api_version,
3292 p_init_msg_list,
3293 x_return_status,
3294 x_msg_count,
3295 x_msg_data,
3296 ddp_avlv_tbl);
3297
3298 -- copy data back from the local variables to OUT or IN-OUT args, if any
3299
3300
3301
3302
3303
3304 end;
3305
3306 procedure validate_template(p_api_version NUMBER
3307 , p_init_msg_list VARCHAR2
3308 , x_return_status out nocopy VARCHAR2
3309 , x_msg_count out nocopy NUMBER
3310 , x_msg_data out nocopy VARCHAR2
3311 , p5_a0 NUMBER := 0-1962.0724
3312 , p5_a1 NUMBER := 0-1962.0724
3313 , p5_a2 NUMBER := 0-1962.0724
3314 , p5_a3 NUMBER := 0-1962.0724
3315 , p5_a4 NUMBER := 0-1962.0724
3316 , p5_a5 NUMBER := 0-1962.0724
3317 , p5_a6 NUMBER := 0-1962.0724
3318 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
3319 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
3320 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
3321 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
3322 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
3323 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
3324 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
3325 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
3326 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
3327 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
3328 , p5_a17 DATE := fnd_api.g_miss_date
3329 , p5_a18 DATE := fnd_api.g_miss_date
3330 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
3331 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
3332 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
3333 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
3334 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
3335 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
3336 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
3337 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
3338 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
3339 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
3340 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
3341 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
3342 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
3343 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
3344 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
3345 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
3346 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
3347 , p5_a36 NUMBER := 0-1962.0724
3348 , p5_a37 NUMBER := 0-1962.0724
3349 , p5_a38 DATE := fnd_api.g_miss_date
3350 , p5_a39 NUMBER := 0-1962.0724
3351 , p5_a40 DATE := fnd_api.g_miss_date
3352 , p5_a41 NUMBER := 0-1962.0724
3353 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
3354 )
3355
3356 as
3357 ddp_avlv_rec okl_tmpt_set_pvt.avlv_rec_type;
3358 ddindx binary_integer; indx binary_integer;
3359 begin
3360
3361 -- copy data to the local IN or IN-OUT args, if any
3362
3363
3364
3365
3366
3367 ddp_avlv_rec.id := rosetta_g_miss_num_map(p5_a0);
3368 ddp_avlv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
3369 ddp_avlv_rec.try_id := rosetta_g_miss_num_map(p5_a2);
3370 ddp_avlv_rec.aes_id := rosetta_g_miss_num_map(p5_a3);
3371 ddp_avlv_rec.sty_id := rosetta_g_miss_num_map(p5_a4);
3372 ddp_avlv_rec.fma_id := rosetta_g_miss_num_map(p5_a5);
3373 ddp_avlv_rec.set_of_books_id := rosetta_g_miss_num_map(p5_a6);
3374 ddp_avlv_rec.fac_code := p5_a7;
3375 ddp_avlv_rec.syt_code := p5_a8;
3376 ddp_avlv_rec.post_to_gl := p5_a9;
3377 ddp_avlv_rec.advance_arrears := p5_a10;
3378 ddp_avlv_rec.memo_yn := p5_a11;
3379 ddp_avlv_rec.prior_year_yn := p5_a12;
3380 ddp_avlv_rec.name := p5_a13;
3381 ddp_avlv_rec.description := p5_a14;
3382 ddp_avlv_rec.version := p5_a15;
3383 ddp_avlv_rec.factoring_synd_flag := p5_a16;
3384 ddp_avlv_rec.start_date := rosetta_g_miss_date_in_map(p5_a17);
3385 ddp_avlv_rec.end_date := rosetta_g_miss_date_in_map(p5_a18);
3386 ddp_avlv_rec.accrual_yn := p5_a19;
3387 ddp_avlv_rec.attribute_category := p5_a20;
3388 ddp_avlv_rec.attribute1 := p5_a21;
3389 ddp_avlv_rec.attribute2 := p5_a22;
3390 ddp_avlv_rec.attribute3 := p5_a23;
3391 ddp_avlv_rec.attribute4 := p5_a24;
3392 ddp_avlv_rec.attribute5 := p5_a25;
3393 ddp_avlv_rec.attribute6 := p5_a26;
3394 ddp_avlv_rec.attribute7 := p5_a27;
3395 ddp_avlv_rec.attribute8 := p5_a28;
3396 ddp_avlv_rec.attribute9 := p5_a29;
3397 ddp_avlv_rec.attribute10 := p5_a30;
3398 ddp_avlv_rec.attribute11 := p5_a31;
3399 ddp_avlv_rec.attribute12 := p5_a32;
3400 ddp_avlv_rec.attribute13 := p5_a33;
3401 ddp_avlv_rec.attribute14 := p5_a34;
3402 ddp_avlv_rec.attribute15 := p5_a35;
3403 ddp_avlv_rec.org_id := rosetta_g_miss_num_map(p5_a36);
3404 ddp_avlv_rec.created_by := rosetta_g_miss_num_map(p5_a37);
3405 ddp_avlv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a38);
3406 ddp_avlv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a39);
3407 ddp_avlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a40);
3408 ddp_avlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a41);
3409 ddp_avlv_rec.inv_code := p5_a42;
3410
3411 -- here's the delegated call to the old PL/SQL routine
3412 okl_tmpt_set_pvt.validate_template(p_api_version,
3413 p_init_msg_list,
3414 x_return_status,
3415 x_msg_count,
3416 x_msg_data,
3417 ddp_avlv_rec);
3418
3419 -- copy data back from the local variables to OUT or IN-OUT args, if any
3420
3421
3422
3423
3424
3425 end;
3426
3427 procedure create_tmpt_lines(p_api_version NUMBER
3428 , p_init_msg_list VARCHAR2
3429 , x_return_status out nocopy VARCHAR2
3430 , x_msg_count out nocopy NUMBER
3431 , x_msg_data out nocopy VARCHAR2
3432 , p5_a0 JTF_NUMBER_TABLE
3433 , p5_a1 JTF_NUMBER_TABLE
3434 , p5_a2 JTF_NUMBER_TABLE
3435 , p5_a3 JTF_VARCHAR2_TABLE_100
3436 , p5_a4 JTF_NUMBER_TABLE
3437 , p5_a5 JTF_VARCHAR2_TABLE_100
3438 , p5_a6 JTF_NUMBER_TABLE
3439 , p5_a7 JTF_VARCHAR2_TABLE_2000
3440 , p5_a8 JTF_NUMBER_TABLE
3441 , p5_a9 JTF_VARCHAR2_TABLE_100
3442 , p5_a10 JTF_VARCHAR2_TABLE_100
3443 , p5_a11 JTF_VARCHAR2_TABLE_500
3444 , p5_a12 JTF_VARCHAR2_TABLE_500
3445 , p5_a13 JTF_VARCHAR2_TABLE_500
3446 , p5_a14 JTF_VARCHAR2_TABLE_500
3447 , p5_a15 JTF_VARCHAR2_TABLE_500
3448 , p5_a16 JTF_VARCHAR2_TABLE_500
3449 , p5_a17 JTF_VARCHAR2_TABLE_500
3450 , p5_a18 JTF_VARCHAR2_TABLE_500
3451 , p5_a19 JTF_VARCHAR2_TABLE_500
3452 , p5_a20 JTF_VARCHAR2_TABLE_500
3453 , p5_a21 JTF_VARCHAR2_TABLE_500
3454 , p5_a22 JTF_VARCHAR2_TABLE_500
3455 , p5_a23 JTF_VARCHAR2_TABLE_500
3456 , p5_a24 JTF_VARCHAR2_TABLE_500
3457 , p5_a25 JTF_VARCHAR2_TABLE_500
3458 , p5_a26 JTF_NUMBER_TABLE
3459 , p5_a27 JTF_NUMBER_TABLE
3460 , p5_a28 JTF_NUMBER_TABLE
3461 , p5_a29 JTF_DATE_TABLE
3462 , p5_a30 JTF_NUMBER_TABLE
3463 , p5_a31 JTF_DATE_TABLE
3464 , p5_a32 JTF_NUMBER_TABLE
3465 , p6_a0 out nocopy JTF_NUMBER_TABLE
3466 , p6_a1 out nocopy JTF_NUMBER_TABLE
3467 , p6_a2 out nocopy JTF_NUMBER_TABLE
3468 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
3469 , p6_a4 out nocopy JTF_NUMBER_TABLE
3470 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
3471 , p6_a6 out nocopy JTF_NUMBER_TABLE
3472 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
3473 , p6_a8 out nocopy JTF_NUMBER_TABLE
3474 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
3475 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
3476 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
3477 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
3478 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
3479 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
3480 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
3481 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
3482 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
3483 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
3484 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
3485 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
3486 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
3487 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
3488 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
3489 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
3490 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
3491 , p6_a26 out nocopy JTF_NUMBER_TABLE
3492 , p6_a27 out nocopy JTF_NUMBER_TABLE
3493 , p6_a28 out nocopy JTF_NUMBER_TABLE
3494 , p6_a29 out nocopy JTF_DATE_TABLE
3495 , p6_a30 out nocopy JTF_NUMBER_TABLE
3496 , p6_a31 out nocopy JTF_DATE_TABLE
3497 , p6_a32 out nocopy JTF_NUMBER_TABLE
3498 )
3499
3500 as
3501 ddp_atlv_tbl okl_tmpt_set_pvt.atlv_tbl_type;
3502 ddx_atlv_tbl okl_tmpt_set_pvt.atlv_tbl_type;
3503 ddindx binary_integer; indx binary_integer;
3504 begin
3505
3506 -- copy data to the local IN or IN-OUT args, if any
3507
3508
3509
3510
3511
3512 okl_atl_pvt_w.rosetta_table_copy_in_p5(ddp_atlv_tbl, p5_a0
3513 , p5_a1
3514 , p5_a2
3515 , p5_a3
3516 , p5_a4
3517 , p5_a5
3518 , p5_a6
3519 , p5_a7
3520 , p5_a8
3521 , p5_a9
3522 , p5_a10
3523 , p5_a11
3524 , p5_a12
3525 , p5_a13
3526 , p5_a14
3527 , p5_a15
3528 , p5_a16
3529 , p5_a17
3530 , p5_a18
3531 , p5_a19
3532 , p5_a20
3533 , p5_a21
3534 , p5_a22
3535 , p5_a23
3536 , p5_a24
3537 , p5_a25
3538 , p5_a26
3539 , p5_a27
3540 , p5_a28
3541 , p5_a29
3542 , p5_a30
3543 , p5_a31
3544 , p5_a32
3545 );
3546
3547
3548 -- here's the delegated call to the old PL/SQL routine
3549 okl_tmpt_set_pvt.create_tmpt_lines(p_api_version,
3550 p_init_msg_list,
3551 x_return_status,
3552 x_msg_count,
3553 x_msg_data,
3554 ddp_atlv_tbl,
3555 ddx_atlv_tbl);
3556
3557 -- copy data back from the local variables to OUT or IN-OUT args, if any
3558
3559
3560
3561
3562
3563
3564 okl_atl_pvt_w.rosetta_table_copy_out_p5(ddx_atlv_tbl, p6_a0
3565 , p6_a1
3566 , p6_a2
3567 , p6_a3
3568 , p6_a4
3569 , p6_a5
3570 , p6_a6
3571 , p6_a7
3572 , p6_a8
3573 , p6_a9
3574 , p6_a10
3575 , p6_a11
3576 , p6_a12
3577 , p6_a13
3578 , p6_a14
3579 , p6_a15
3580 , p6_a16
3581 , p6_a17
3582 , p6_a18
3583 , p6_a19
3584 , p6_a20
3585 , p6_a21
3586 , p6_a22
3587 , p6_a23
3588 , p6_a24
3589 , p6_a25
3590 , p6_a26
3591 , p6_a27
3592 , p6_a28
3593 , p6_a29
3594 , p6_a30
3595 , p6_a31
3596 , p6_a32
3597 );
3598 end;
3599
3600 procedure create_tmpt_lines(p_api_version NUMBER
3601 , p_init_msg_list VARCHAR2
3602 , x_return_status out nocopy VARCHAR2
3603 , x_msg_count out nocopy NUMBER
3604 , x_msg_data out nocopy VARCHAR2
3605 , p6_a0 out nocopy NUMBER
3606 , p6_a1 out nocopy NUMBER
3607 , p6_a2 out nocopy NUMBER
3608 , p6_a3 out nocopy VARCHAR2
3609 , p6_a4 out nocopy NUMBER
3610 , p6_a5 out nocopy VARCHAR2
3611 , p6_a6 out nocopy NUMBER
3612 , p6_a7 out nocopy VARCHAR2
3613 , p6_a8 out nocopy NUMBER
3614 , p6_a9 out nocopy VARCHAR2
3615 , p6_a10 out nocopy VARCHAR2
3616 , p6_a11 out nocopy VARCHAR2
3617 , p6_a12 out nocopy VARCHAR2
3618 , p6_a13 out nocopy VARCHAR2
3619 , p6_a14 out nocopy VARCHAR2
3620 , p6_a15 out nocopy VARCHAR2
3621 , p6_a16 out nocopy VARCHAR2
3622 , p6_a17 out nocopy VARCHAR2
3623 , p6_a18 out nocopy VARCHAR2
3624 , p6_a19 out nocopy VARCHAR2
3625 , p6_a20 out nocopy VARCHAR2
3626 , p6_a21 out nocopy VARCHAR2
3627 , p6_a22 out nocopy VARCHAR2
3628 , p6_a23 out nocopy VARCHAR2
3629 , p6_a24 out nocopy VARCHAR2
3630 , p6_a25 out nocopy VARCHAR2
3631 , p6_a26 out nocopy NUMBER
3632 , p6_a27 out nocopy NUMBER
3633 , p6_a28 out nocopy NUMBER
3634 , p6_a29 out nocopy DATE
3635 , p6_a30 out nocopy NUMBER
3636 , p6_a31 out nocopy DATE
3637 , p6_a32 out nocopy NUMBER
3638 , p5_a0 NUMBER := 0-1962.0724
3639 , p5_a1 NUMBER := 0-1962.0724
3640 , p5_a2 NUMBER := 0-1962.0724
3641 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
3642 , p5_a4 NUMBER := 0-1962.0724
3643 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
3644 , p5_a6 NUMBER := 0-1962.0724
3645 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
3646 , p5_a8 NUMBER := 0-1962.0724
3647 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
3648 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
3649 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
3650 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
3651 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
3652 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
3653 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
3654 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
3655 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
3656 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
3657 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
3658 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
3659 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
3660 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
3661 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
3662 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
3663 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
3664 , p5_a26 NUMBER := 0-1962.0724
3665 , p5_a27 NUMBER := 0-1962.0724
3666 , p5_a28 NUMBER := 0-1962.0724
3667 , p5_a29 DATE := fnd_api.g_miss_date
3668 , p5_a30 NUMBER := 0-1962.0724
3669 , p5_a31 DATE := fnd_api.g_miss_date
3670 , p5_a32 NUMBER := 0-1962.0724
3671 )
3672
3673 as
3674 ddp_atlv_rec okl_tmpt_set_pvt.atlv_rec_type;
3675 ddx_atlv_rec okl_tmpt_set_pvt.atlv_rec_type;
3676 ddindx binary_integer; indx binary_integer;
3677 begin
3678
3679 -- copy data to the local IN or IN-OUT args, if any
3680
3681
3682
3683
3684
3685 ddp_atlv_rec.id := rosetta_g_miss_num_map(p5_a0);
3686 ddp_atlv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
3687 ddp_atlv_rec.avl_id := rosetta_g_miss_num_map(p5_a2);
3688 ddp_atlv_rec.crd_code := p5_a3;
3689 ddp_atlv_rec.code_combination_id := rosetta_g_miss_num_map(p5_a4);
3690 ddp_atlv_rec.ae_line_type := p5_a5;
3691 ddp_atlv_rec.sequence_number := rosetta_g_miss_num_map(p5_a6);
3692 ddp_atlv_rec.description := p5_a7;
3693 ddp_atlv_rec.percentage := rosetta_g_miss_num_map(p5_a8);
3694 ddp_atlv_rec.account_builder_yn := p5_a9;
3695 ddp_atlv_rec.attribute_category := p5_a10;
3696 ddp_atlv_rec.attribute1 := p5_a11;
3697 ddp_atlv_rec.attribute2 := p5_a12;
3698 ddp_atlv_rec.attribute3 := p5_a13;
3699 ddp_atlv_rec.attribute4 := p5_a14;
3700 ddp_atlv_rec.attribute5 := p5_a15;
3701 ddp_atlv_rec.attribute6 := p5_a16;
3702 ddp_atlv_rec.attribute7 := p5_a17;
3703 ddp_atlv_rec.attribute8 := p5_a18;
3704 ddp_atlv_rec.attribute9 := p5_a19;
3705 ddp_atlv_rec.attribute10 := p5_a20;
3706 ddp_atlv_rec.attribute11 := p5_a21;
3707 ddp_atlv_rec.attribute12 := p5_a22;
3708 ddp_atlv_rec.attribute13 := p5_a23;
3709 ddp_atlv_rec.attribute14 := p5_a24;
3710 ddp_atlv_rec.attribute15 := p5_a25;
3711 ddp_atlv_rec.avl_tbl_index := rosetta_g_miss_num_map(p5_a26);
3712 ddp_atlv_rec.org_id := rosetta_g_miss_num_map(p5_a27);
3713 ddp_atlv_rec.created_by := rosetta_g_miss_num_map(p5_a28);
3714 ddp_atlv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a29);
3715 ddp_atlv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a30);
3716 ddp_atlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a31);
3717 ddp_atlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a32);
3718
3719
3720 -- here's the delegated call to the old PL/SQL routine
3721 okl_tmpt_set_pvt.create_tmpt_lines(p_api_version,
3722 p_init_msg_list,
3723 x_return_status,
3724 x_msg_count,
3725 x_msg_data,
3726 ddp_atlv_rec,
3727 ddx_atlv_rec);
3728
3729 -- copy data back from the local variables to OUT or IN-OUT args, if any
3730
3731
3732
3733
3734
3735
3736 p6_a0 := rosetta_g_miss_num_map(ddx_atlv_rec.id);
3737 p6_a1 := rosetta_g_miss_num_map(ddx_atlv_rec.object_version_number);
3738 p6_a2 := rosetta_g_miss_num_map(ddx_atlv_rec.avl_id);
3739 p6_a3 := ddx_atlv_rec.crd_code;
3740 p6_a4 := rosetta_g_miss_num_map(ddx_atlv_rec.code_combination_id);
3741 p6_a5 := ddx_atlv_rec.ae_line_type;
3742 p6_a6 := rosetta_g_miss_num_map(ddx_atlv_rec.sequence_number);
3743 p6_a7 := ddx_atlv_rec.description;
3744 p6_a8 := rosetta_g_miss_num_map(ddx_atlv_rec.percentage);
3745 p6_a9 := ddx_atlv_rec.account_builder_yn;
3746 p6_a10 := ddx_atlv_rec.attribute_category;
3747 p6_a11 := ddx_atlv_rec.attribute1;
3748 p6_a12 := ddx_atlv_rec.attribute2;
3749 p6_a13 := ddx_atlv_rec.attribute3;
3750 p6_a14 := ddx_atlv_rec.attribute4;
3751 p6_a15 := ddx_atlv_rec.attribute5;
3752 p6_a16 := ddx_atlv_rec.attribute6;
3753 p6_a17 := ddx_atlv_rec.attribute7;
3754 p6_a18 := ddx_atlv_rec.attribute8;
3755 p6_a19 := ddx_atlv_rec.attribute9;
3756 p6_a20 := ddx_atlv_rec.attribute10;
3757 p6_a21 := ddx_atlv_rec.attribute11;
3758 p6_a22 := ddx_atlv_rec.attribute12;
3759 p6_a23 := ddx_atlv_rec.attribute13;
3760 p6_a24 := ddx_atlv_rec.attribute14;
3761 p6_a25 := ddx_atlv_rec.attribute15;
3762 p6_a26 := rosetta_g_miss_num_map(ddx_atlv_rec.avl_tbl_index);
3763 p6_a27 := rosetta_g_miss_num_map(ddx_atlv_rec.org_id);
3764 p6_a28 := rosetta_g_miss_num_map(ddx_atlv_rec.created_by);
3765 p6_a29 := ddx_atlv_rec.creation_date;
3766 p6_a30 := rosetta_g_miss_num_map(ddx_atlv_rec.last_updated_by);
3767 p6_a31 := ddx_atlv_rec.last_update_date;
3768 p6_a32 := rosetta_g_miss_num_map(ddx_atlv_rec.last_update_login);
3769 end;
3770
3771 procedure lock_tmpt_lines(p_api_version NUMBER
3772 , p_init_msg_list VARCHAR2
3773 , x_return_status out nocopy VARCHAR2
3774 , x_msg_count out nocopy NUMBER
3775 , x_msg_data out nocopy VARCHAR2
3776 , p5_a0 JTF_NUMBER_TABLE
3777 , p5_a1 JTF_NUMBER_TABLE
3778 , p5_a2 JTF_NUMBER_TABLE
3779 , p5_a3 JTF_VARCHAR2_TABLE_100
3780 , p5_a4 JTF_NUMBER_TABLE
3781 , p5_a5 JTF_VARCHAR2_TABLE_100
3782 , p5_a6 JTF_NUMBER_TABLE
3783 , p5_a7 JTF_VARCHAR2_TABLE_2000
3784 , p5_a8 JTF_NUMBER_TABLE
3785 , p5_a9 JTF_VARCHAR2_TABLE_100
3786 , p5_a10 JTF_VARCHAR2_TABLE_100
3787 , p5_a11 JTF_VARCHAR2_TABLE_500
3788 , p5_a12 JTF_VARCHAR2_TABLE_500
3789 , p5_a13 JTF_VARCHAR2_TABLE_500
3790 , p5_a14 JTF_VARCHAR2_TABLE_500
3791 , p5_a15 JTF_VARCHAR2_TABLE_500
3792 , p5_a16 JTF_VARCHAR2_TABLE_500
3793 , p5_a17 JTF_VARCHAR2_TABLE_500
3794 , p5_a18 JTF_VARCHAR2_TABLE_500
3795 , p5_a19 JTF_VARCHAR2_TABLE_500
3796 , p5_a20 JTF_VARCHAR2_TABLE_500
3797 , p5_a21 JTF_VARCHAR2_TABLE_500
3798 , p5_a22 JTF_VARCHAR2_TABLE_500
3799 , p5_a23 JTF_VARCHAR2_TABLE_500
3800 , p5_a24 JTF_VARCHAR2_TABLE_500
3801 , p5_a25 JTF_VARCHAR2_TABLE_500
3802 , p5_a26 JTF_NUMBER_TABLE
3803 , p5_a27 JTF_NUMBER_TABLE
3804 , p5_a28 JTF_NUMBER_TABLE
3805 , p5_a29 JTF_DATE_TABLE
3806 , p5_a30 JTF_NUMBER_TABLE
3807 , p5_a31 JTF_DATE_TABLE
3808 , p5_a32 JTF_NUMBER_TABLE
3809 )
3810
3811 as
3812 ddp_atlv_tbl okl_tmpt_set_pvt.atlv_tbl_type;
3813 ddindx binary_integer; indx binary_integer;
3814 begin
3815
3816 -- copy data to the local IN or IN-OUT args, if any
3817
3818
3819
3820
3821
3822 okl_atl_pvt_w.rosetta_table_copy_in_p5(ddp_atlv_tbl, p5_a0
3823 , p5_a1
3824 , p5_a2
3825 , p5_a3
3826 , p5_a4
3827 , p5_a5
3828 , p5_a6
3829 , p5_a7
3830 , p5_a8
3831 , p5_a9
3832 , p5_a10
3833 , p5_a11
3834 , p5_a12
3835 , p5_a13
3836 , p5_a14
3837 , p5_a15
3838 , p5_a16
3839 , p5_a17
3840 , p5_a18
3841 , p5_a19
3842 , p5_a20
3843 , p5_a21
3844 , p5_a22
3845 , p5_a23
3846 , p5_a24
3847 , p5_a25
3848 , p5_a26
3849 , p5_a27
3850 , p5_a28
3851 , p5_a29
3852 , p5_a30
3853 , p5_a31
3854 , p5_a32
3855 );
3856
3857 -- here's the delegated call to the old PL/SQL routine
3858 okl_tmpt_set_pvt.lock_tmpt_lines(p_api_version,
3859 p_init_msg_list,
3860 x_return_status,
3861 x_msg_count,
3862 x_msg_data,
3863 ddp_atlv_tbl);
3864
3865 -- copy data back from the local variables to OUT or IN-OUT args, if any
3866
3867
3868
3869
3870
3871 end;
3872
3873 procedure lock_tmpt_lines(p_api_version NUMBER
3874 , p_init_msg_list VARCHAR2
3875 , x_return_status out nocopy VARCHAR2
3876 , x_msg_count out nocopy NUMBER
3877 , x_msg_data out nocopy VARCHAR2
3878 , p5_a0 NUMBER := 0-1962.0724
3879 , p5_a1 NUMBER := 0-1962.0724
3880 , p5_a2 NUMBER := 0-1962.0724
3881 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
3882 , p5_a4 NUMBER := 0-1962.0724
3883 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
3884 , p5_a6 NUMBER := 0-1962.0724
3885 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
3886 , p5_a8 NUMBER := 0-1962.0724
3887 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
3888 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
3889 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
3890 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
3891 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
3892 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
3893 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
3894 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
3895 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
3896 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
3897 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
3898 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
3899 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
3900 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
3901 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
3902 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
3903 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
3904 , p5_a26 NUMBER := 0-1962.0724
3905 , p5_a27 NUMBER := 0-1962.0724
3906 , p5_a28 NUMBER := 0-1962.0724
3907 , p5_a29 DATE := fnd_api.g_miss_date
3908 , p5_a30 NUMBER := 0-1962.0724
3909 , p5_a31 DATE := fnd_api.g_miss_date
3910 , p5_a32 NUMBER := 0-1962.0724
3911 )
3912
3913 as
3914 ddp_atlv_rec okl_tmpt_set_pvt.atlv_rec_type;
3915 ddindx binary_integer; indx binary_integer;
3916 begin
3917
3918 -- copy data to the local IN or IN-OUT args, if any
3919
3920
3921
3922
3923
3924 ddp_atlv_rec.id := rosetta_g_miss_num_map(p5_a0);
3925 ddp_atlv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
3926 ddp_atlv_rec.avl_id := rosetta_g_miss_num_map(p5_a2);
3927 ddp_atlv_rec.crd_code := p5_a3;
3928 ddp_atlv_rec.code_combination_id := rosetta_g_miss_num_map(p5_a4);
3929 ddp_atlv_rec.ae_line_type := p5_a5;
3930 ddp_atlv_rec.sequence_number := rosetta_g_miss_num_map(p5_a6);
3931 ddp_atlv_rec.description := p5_a7;
3932 ddp_atlv_rec.percentage := rosetta_g_miss_num_map(p5_a8);
3933 ddp_atlv_rec.account_builder_yn := p5_a9;
3934 ddp_atlv_rec.attribute_category := p5_a10;
3935 ddp_atlv_rec.attribute1 := p5_a11;
3936 ddp_atlv_rec.attribute2 := p5_a12;
3937 ddp_atlv_rec.attribute3 := p5_a13;
3938 ddp_atlv_rec.attribute4 := p5_a14;
3939 ddp_atlv_rec.attribute5 := p5_a15;
3940 ddp_atlv_rec.attribute6 := p5_a16;
3941 ddp_atlv_rec.attribute7 := p5_a17;
3942 ddp_atlv_rec.attribute8 := p5_a18;
3943 ddp_atlv_rec.attribute9 := p5_a19;
3944 ddp_atlv_rec.attribute10 := p5_a20;
3945 ddp_atlv_rec.attribute11 := p5_a21;
3946 ddp_atlv_rec.attribute12 := p5_a22;
3947 ddp_atlv_rec.attribute13 := p5_a23;
3948 ddp_atlv_rec.attribute14 := p5_a24;
3949 ddp_atlv_rec.attribute15 := p5_a25;
3950 ddp_atlv_rec.avl_tbl_index := rosetta_g_miss_num_map(p5_a26);
3951 ddp_atlv_rec.org_id := rosetta_g_miss_num_map(p5_a27);
3952 ddp_atlv_rec.created_by := rosetta_g_miss_num_map(p5_a28);
3953 ddp_atlv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a29);
3954 ddp_atlv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a30);
3955 ddp_atlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a31);
3956 ddp_atlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a32);
3957
3958 -- here's the delegated call to the old PL/SQL routine
3959 okl_tmpt_set_pvt.lock_tmpt_lines(p_api_version,
3960 p_init_msg_list,
3961 x_return_status,
3962 x_msg_count,
3963 x_msg_data,
3964 ddp_atlv_rec);
3965
3966 -- copy data back from the local variables to OUT or IN-OUT args, if any
3967
3968
3969
3970
3971
3972 end;
3973
3974 procedure update_tmpt_lines(p_api_version NUMBER
3975 , p_init_msg_list VARCHAR2
3976 , x_return_status out nocopy VARCHAR2
3977 , x_msg_count out nocopy NUMBER
3978 , x_msg_data out nocopy VARCHAR2
3979 , p5_a0 JTF_NUMBER_TABLE
3980 , p5_a1 JTF_NUMBER_TABLE
3981 , p5_a2 JTF_NUMBER_TABLE
3982 , p5_a3 JTF_VARCHAR2_TABLE_100
3983 , p5_a4 JTF_NUMBER_TABLE
3984 , p5_a5 JTF_VARCHAR2_TABLE_100
3985 , p5_a6 JTF_NUMBER_TABLE
3986 , p5_a7 JTF_VARCHAR2_TABLE_2000
3987 , p5_a8 JTF_NUMBER_TABLE
3988 , p5_a9 JTF_VARCHAR2_TABLE_100
3989 , p5_a10 JTF_VARCHAR2_TABLE_100
3990 , p5_a11 JTF_VARCHAR2_TABLE_500
3991 , p5_a12 JTF_VARCHAR2_TABLE_500
3992 , p5_a13 JTF_VARCHAR2_TABLE_500
3993 , p5_a14 JTF_VARCHAR2_TABLE_500
3994 , p5_a15 JTF_VARCHAR2_TABLE_500
3995 , p5_a16 JTF_VARCHAR2_TABLE_500
3996 , p5_a17 JTF_VARCHAR2_TABLE_500
3997 , p5_a18 JTF_VARCHAR2_TABLE_500
3998 , p5_a19 JTF_VARCHAR2_TABLE_500
3999 , p5_a20 JTF_VARCHAR2_TABLE_500
4000 , p5_a21 JTF_VARCHAR2_TABLE_500
4001 , p5_a22 JTF_VARCHAR2_TABLE_500
4002 , p5_a23 JTF_VARCHAR2_TABLE_500
4003 , p5_a24 JTF_VARCHAR2_TABLE_500
4004 , p5_a25 JTF_VARCHAR2_TABLE_500
4005 , p5_a26 JTF_NUMBER_TABLE
4006 , p5_a27 JTF_NUMBER_TABLE
4007 , p5_a28 JTF_NUMBER_TABLE
4008 , p5_a29 JTF_DATE_TABLE
4009 , p5_a30 JTF_NUMBER_TABLE
4010 , p5_a31 JTF_DATE_TABLE
4011 , p5_a32 JTF_NUMBER_TABLE
4012 , p6_a0 out nocopy JTF_NUMBER_TABLE
4013 , p6_a1 out nocopy JTF_NUMBER_TABLE
4014 , p6_a2 out nocopy JTF_NUMBER_TABLE
4015 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
4016 , p6_a4 out nocopy JTF_NUMBER_TABLE
4017 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
4018 , p6_a6 out nocopy JTF_NUMBER_TABLE
4019 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
4020 , p6_a8 out nocopy JTF_NUMBER_TABLE
4021 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
4022 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
4023 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
4024 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
4025 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
4026 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
4027 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
4028 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
4029 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
4030 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
4031 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
4032 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
4033 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
4034 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
4035 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
4036 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
4037 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
4038 , p6_a26 out nocopy JTF_NUMBER_TABLE
4039 , p6_a27 out nocopy JTF_NUMBER_TABLE
4040 , p6_a28 out nocopy JTF_NUMBER_TABLE
4041 , p6_a29 out nocopy JTF_DATE_TABLE
4042 , p6_a30 out nocopy JTF_NUMBER_TABLE
4043 , p6_a31 out nocopy JTF_DATE_TABLE
4044 , p6_a32 out nocopy JTF_NUMBER_TABLE
4045 )
4046
4047 as
4048 ddp_atlv_tbl okl_tmpt_set_pvt.atlv_tbl_type;
4049 ddx_atlv_tbl okl_tmpt_set_pvt.atlv_tbl_type;
4050 ddindx binary_integer; indx binary_integer;
4051 begin
4052
4053 -- copy data to the local IN or IN-OUT args, if any
4054
4055
4056
4057
4058
4059 okl_atl_pvt_w.rosetta_table_copy_in_p5(ddp_atlv_tbl, p5_a0
4060 , p5_a1
4061 , p5_a2
4062 , p5_a3
4063 , p5_a4
4064 , p5_a5
4065 , p5_a6
4066 , p5_a7
4067 , p5_a8
4068 , p5_a9
4069 , p5_a10
4070 , p5_a11
4071 , p5_a12
4072 , p5_a13
4073 , p5_a14
4074 , p5_a15
4075 , p5_a16
4076 , p5_a17
4077 , p5_a18
4078 , p5_a19
4079 , p5_a20
4080 , p5_a21
4081 , p5_a22
4082 , p5_a23
4083 , p5_a24
4084 , p5_a25
4085 , p5_a26
4086 , p5_a27
4087 , p5_a28
4088 , p5_a29
4089 , p5_a30
4090 , p5_a31
4091 , p5_a32
4092 );
4093
4094
4095 -- here's the delegated call to the old PL/SQL routine
4096 okl_tmpt_set_pvt.update_tmpt_lines(p_api_version,
4097 p_init_msg_list,
4098 x_return_status,
4099 x_msg_count,
4100 x_msg_data,
4101 ddp_atlv_tbl,
4102 ddx_atlv_tbl);
4103
4104 -- copy data back from the local variables to OUT or IN-OUT args, if any
4105
4106
4107
4108
4109
4110
4111 okl_atl_pvt_w.rosetta_table_copy_out_p5(ddx_atlv_tbl, p6_a0
4112 , p6_a1
4113 , p6_a2
4114 , p6_a3
4115 , p6_a4
4116 , p6_a5
4117 , p6_a6
4118 , p6_a7
4119 , p6_a8
4120 , p6_a9
4121 , p6_a10
4122 , p6_a11
4123 , p6_a12
4124 , p6_a13
4125 , p6_a14
4126 , p6_a15
4127 , p6_a16
4128 , p6_a17
4129 , p6_a18
4130 , p6_a19
4131 , p6_a20
4132 , p6_a21
4133 , p6_a22
4134 , p6_a23
4135 , p6_a24
4136 , p6_a25
4137 , p6_a26
4138 , p6_a27
4139 , p6_a28
4140 , p6_a29
4141 , p6_a30
4142 , p6_a31
4143 , p6_a32
4144 );
4145 end;
4146
4147 procedure update_tmpt_lines(p_api_version NUMBER
4148 , p_init_msg_list VARCHAR2
4149 , x_return_status out nocopy VARCHAR2
4150 , x_msg_count out nocopy NUMBER
4151 , x_msg_data out nocopy VARCHAR2
4152 , p6_a0 out nocopy NUMBER
4153 , p6_a1 out nocopy NUMBER
4154 , p6_a2 out nocopy NUMBER
4155 , p6_a3 out nocopy VARCHAR2
4156 , p6_a4 out nocopy NUMBER
4157 , p6_a5 out nocopy VARCHAR2
4158 , p6_a6 out nocopy NUMBER
4159 , p6_a7 out nocopy VARCHAR2
4160 , p6_a8 out nocopy NUMBER
4161 , p6_a9 out nocopy VARCHAR2
4162 , p6_a10 out nocopy VARCHAR2
4163 , p6_a11 out nocopy VARCHAR2
4164 , p6_a12 out nocopy VARCHAR2
4165 , p6_a13 out nocopy VARCHAR2
4166 , p6_a14 out nocopy VARCHAR2
4167 , p6_a15 out nocopy VARCHAR2
4168 , p6_a16 out nocopy VARCHAR2
4169 , p6_a17 out nocopy VARCHAR2
4170 , p6_a18 out nocopy VARCHAR2
4171 , p6_a19 out nocopy VARCHAR2
4172 , p6_a20 out nocopy VARCHAR2
4173 , p6_a21 out nocopy VARCHAR2
4174 , p6_a22 out nocopy VARCHAR2
4175 , p6_a23 out nocopy VARCHAR2
4176 , p6_a24 out nocopy VARCHAR2
4177 , p6_a25 out nocopy VARCHAR2
4178 , p6_a26 out nocopy NUMBER
4179 , p6_a27 out nocopy NUMBER
4180 , p6_a28 out nocopy NUMBER
4181 , p6_a29 out nocopy DATE
4182 , p6_a30 out nocopy NUMBER
4183 , p6_a31 out nocopy DATE
4184 , p6_a32 out nocopy NUMBER
4185 , p5_a0 NUMBER := 0-1962.0724
4186 , p5_a1 NUMBER := 0-1962.0724
4187 , p5_a2 NUMBER := 0-1962.0724
4188 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
4189 , p5_a4 NUMBER := 0-1962.0724
4190 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
4191 , p5_a6 NUMBER := 0-1962.0724
4192 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
4193 , p5_a8 NUMBER := 0-1962.0724
4194 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
4195 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
4196 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
4197 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
4198 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
4199 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
4200 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
4201 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
4202 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
4203 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
4204 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
4205 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
4206 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
4207 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
4208 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
4209 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
4210 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
4211 , p5_a26 NUMBER := 0-1962.0724
4212 , p5_a27 NUMBER := 0-1962.0724
4213 , p5_a28 NUMBER := 0-1962.0724
4214 , p5_a29 DATE := fnd_api.g_miss_date
4215 , p5_a30 NUMBER := 0-1962.0724
4216 , p5_a31 DATE := fnd_api.g_miss_date
4217 , p5_a32 NUMBER := 0-1962.0724
4218 )
4219
4220 as
4221 ddp_atlv_rec okl_tmpt_set_pvt.atlv_rec_type;
4222 ddx_atlv_rec okl_tmpt_set_pvt.atlv_rec_type;
4223 ddindx binary_integer; indx binary_integer;
4224 begin
4225
4226 -- copy data to the local IN or IN-OUT args, if any
4227
4228
4229
4230
4231
4232 ddp_atlv_rec.id := rosetta_g_miss_num_map(p5_a0);
4233 ddp_atlv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
4234 ddp_atlv_rec.avl_id := rosetta_g_miss_num_map(p5_a2);
4235 ddp_atlv_rec.crd_code := p5_a3;
4236 ddp_atlv_rec.code_combination_id := rosetta_g_miss_num_map(p5_a4);
4237 ddp_atlv_rec.ae_line_type := p5_a5;
4238 ddp_atlv_rec.sequence_number := rosetta_g_miss_num_map(p5_a6);
4239 ddp_atlv_rec.description := p5_a7;
4240 ddp_atlv_rec.percentage := rosetta_g_miss_num_map(p5_a8);
4241 ddp_atlv_rec.account_builder_yn := p5_a9;
4242 ddp_atlv_rec.attribute_category := p5_a10;
4243 ddp_atlv_rec.attribute1 := p5_a11;
4244 ddp_atlv_rec.attribute2 := p5_a12;
4245 ddp_atlv_rec.attribute3 := p5_a13;
4246 ddp_atlv_rec.attribute4 := p5_a14;
4247 ddp_atlv_rec.attribute5 := p5_a15;
4248 ddp_atlv_rec.attribute6 := p5_a16;
4249 ddp_atlv_rec.attribute7 := p5_a17;
4250 ddp_atlv_rec.attribute8 := p5_a18;
4251 ddp_atlv_rec.attribute9 := p5_a19;
4252 ddp_atlv_rec.attribute10 := p5_a20;
4253 ddp_atlv_rec.attribute11 := p5_a21;
4254 ddp_atlv_rec.attribute12 := p5_a22;
4255 ddp_atlv_rec.attribute13 := p5_a23;
4256 ddp_atlv_rec.attribute14 := p5_a24;
4257 ddp_atlv_rec.attribute15 := p5_a25;
4258 ddp_atlv_rec.avl_tbl_index := rosetta_g_miss_num_map(p5_a26);
4259 ddp_atlv_rec.org_id := rosetta_g_miss_num_map(p5_a27);
4260 ddp_atlv_rec.created_by := rosetta_g_miss_num_map(p5_a28);
4261 ddp_atlv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a29);
4262 ddp_atlv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a30);
4263 ddp_atlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a31);
4264 ddp_atlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a32);
4265
4266
4267 -- here's the delegated call to the old PL/SQL routine
4268 okl_tmpt_set_pvt.update_tmpt_lines(p_api_version,
4269 p_init_msg_list,
4270 x_return_status,
4271 x_msg_count,
4272 x_msg_data,
4273 ddp_atlv_rec,
4274 ddx_atlv_rec);
4275
4276 -- copy data back from the local variables to OUT or IN-OUT args, if any
4277
4278
4279
4280
4281
4282
4283 p6_a0 := rosetta_g_miss_num_map(ddx_atlv_rec.id);
4284 p6_a1 := rosetta_g_miss_num_map(ddx_atlv_rec.object_version_number);
4285 p6_a2 := rosetta_g_miss_num_map(ddx_atlv_rec.avl_id);
4286 p6_a3 := ddx_atlv_rec.crd_code;
4287 p6_a4 := rosetta_g_miss_num_map(ddx_atlv_rec.code_combination_id);
4288 p6_a5 := ddx_atlv_rec.ae_line_type;
4289 p6_a6 := rosetta_g_miss_num_map(ddx_atlv_rec.sequence_number);
4290 p6_a7 := ddx_atlv_rec.description;
4291 p6_a8 := rosetta_g_miss_num_map(ddx_atlv_rec.percentage);
4292 p6_a9 := ddx_atlv_rec.account_builder_yn;
4293 p6_a10 := ddx_atlv_rec.attribute_category;
4294 p6_a11 := ddx_atlv_rec.attribute1;
4295 p6_a12 := ddx_atlv_rec.attribute2;
4296 p6_a13 := ddx_atlv_rec.attribute3;
4297 p6_a14 := ddx_atlv_rec.attribute4;
4298 p6_a15 := ddx_atlv_rec.attribute5;
4299 p6_a16 := ddx_atlv_rec.attribute6;
4300 p6_a17 := ddx_atlv_rec.attribute7;
4301 p6_a18 := ddx_atlv_rec.attribute8;
4302 p6_a19 := ddx_atlv_rec.attribute9;
4303 p6_a20 := ddx_atlv_rec.attribute10;
4304 p6_a21 := ddx_atlv_rec.attribute11;
4305 p6_a22 := ddx_atlv_rec.attribute12;
4306 p6_a23 := ddx_atlv_rec.attribute13;
4307 p6_a24 := ddx_atlv_rec.attribute14;
4308 p6_a25 := ddx_atlv_rec.attribute15;
4309 p6_a26 := rosetta_g_miss_num_map(ddx_atlv_rec.avl_tbl_index);
4310 p6_a27 := rosetta_g_miss_num_map(ddx_atlv_rec.org_id);
4311 p6_a28 := rosetta_g_miss_num_map(ddx_atlv_rec.created_by);
4312 p6_a29 := ddx_atlv_rec.creation_date;
4313 p6_a30 := rosetta_g_miss_num_map(ddx_atlv_rec.last_updated_by);
4314 p6_a31 := ddx_atlv_rec.last_update_date;
4315 p6_a32 := rosetta_g_miss_num_map(ddx_atlv_rec.last_update_login);
4316 end;
4317
4318 procedure delete_tmpt_lines(p_api_version NUMBER
4319 , p_init_msg_list VARCHAR2
4320 , x_return_status out nocopy VARCHAR2
4321 , x_msg_count out nocopy NUMBER
4322 , x_msg_data out nocopy VARCHAR2
4323 , p5_a0 JTF_NUMBER_TABLE
4324 , p5_a1 JTF_NUMBER_TABLE
4325 , p5_a2 JTF_NUMBER_TABLE
4326 , p5_a3 JTF_VARCHAR2_TABLE_100
4327 , p5_a4 JTF_NUMBER_TABLE
4328 , p5_a5 JTF_VARCHAR2_TABLE_100
4329 , p5_a6 JTF_NUMBER_TABLE
4330 , p5_a7 JTF_VARCHAR2_TABLE_2000
4331 , p5_a8 JTF_NUMBER_TABLE
4332 , p5_a9 JTF_VARCHAR2_TABLE_100
4333 , p5_a10 JTF_VARCHAR2_TABLE_100
4334 , p5_a11 JTF_VARCHAR2_TABLE_500
4335 , p5_a12 JTF_VARCHAR2_TABLE_500
4336 , p5_a13 JTF_VARCHAR2_TABLE_500
4337 , p5_a14 JTF_VARCHAR2_TABLE_500
4338 , p5_a15 JTF_VARCHAR2_TABLE_500
4339 , p5_a16 JTF_VARCHAR2_TABLE_500
4340 , p5_a17 JTF_VARCHAR2_TABLE_500
4341 , p5_a18 JTF_VARCHAR2_TABLE_500
4342 , p5_a19 JTF_VARCHAR2_TABLE_500
4343 , p5_a20 JTF_VARCHAR2_TABLE_500
4344 , p5_a21 JTF_VARCHAR2_TABLE_500
4345 , p5_a22 JTF_VARCHAR2_TABLE_500
4346 , p5_a23 JTF_VARCHAR2_TABLE_500
4347 , p5_a24 JTF_VARCHAR2_TABLE_500
4348 , p5_a25 JTF_VARCHAR2_TABLE_500
4349 , p5_a26 JTF_NUMBER_TABLE
4350 , p5_a27 JTF_NUMBER_TABLE
4351 , p5_a28 JTF_NUMBER_TABLE
4352 , p5_a29 JTF_DATE_TABLE
4353 , p5_a30 JTF_NUMBER_TABLE
4354 , p5_a31 JTF_DATE_TABLE
4355 , p5_a32 JTF_NUMBER_TABLE
4356 )
4357
4358 as
4359 ddp_atlv_tbl okl_tmpt_set_pvt.atlv_tbl_type;
4360 ddindx binary_integer; indx binary_integer;
4361 begin
4362
4363 -- copy data to the local IN or IN-OUT args, if any
4364
4365
4366
4367
4368
4369 okl_atl_pvt_w.rosetta_table_copy_in_p5(ddp_atlv_tbl, p5_a0
4370 , p5_a1
4371 , p5_a2
4372 , p5_a3
4373 , p5_a4
4374 , p5_a5
4375 , p5_a6
4376 , p5_a7
4377 , p5_a8
4378 , p5_a9
4379 , p5_a10
4380 , p5_a11
4381 , p5_a12
4382 , p5_a13
4383 , p5_a14
4384 , p5_a15
4385 , p5_a16
4386 , p5_a17
4387 , p5_a18
4388 , p5_a19
4389 , p5_a20
4390 , p5_a21
4391 , p5_a22
4392 , p5_a23
4393 , p5_a24
4394 , p5_a25
4395 , p5_a26
4396 , p5_a27
4397 , p5_a28
4398 , p5_a29
4399 , p5_a30
4400 , p5_a31
4401 , p5_a32
4402 );
4403
4404 -- here's the delegated call to the old PL/SQL routine
4405 okl_tmpt_set_pvt.delete_tmpt_lines(p_api_version,
4406 p_init_msg_list,
4407 x_return_status,
4408 x_msg_count,
4409 x_msg_data,
4410 ddp_atlv_tbl);
4411
4412 -- copy data back from the local variables to OUT or IN-OUT args, if any
4413
4414
4415
4416
4417
4418 end;
4419
4420 procedure delete_tmpt_lines(p_api_version NUMBER
4421 , p_init_msg_list VARCHAR2
4422 , x_return_status out nocopy VARCHAR2
4423 , x_msg_count out nocopy NUMBER
4424 , x_msg_data out nocopy VARCHAR2
4425 , p5_a0 NUMBER := 0-1962.0724
4426 , p5_a1 NUMBER := 0-1962.0724
4427 , p5_a2 NUMBER := 0-1962.0724
4428 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
4429 , p5_a4 NUMBER := 0-1962.0724
4430 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
4431 , p5_a6 NUMBER := 0-1962.0724
4432 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
4433 , p5_a8 NUMBER := 0-1962.0724
4434 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
4435 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
4436 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
4437 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
4438 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
4439 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
4440 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
4441 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
4442 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
4443 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
4444 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
4445 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
4446 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
4447 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
4448 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
4449 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
4450 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
4451 , p5_a26 NUMBER := 0-1962.0724
4452 , p5_a27 NUMBER := 0-1962.0724
4453 , p5_a28 NUMBER := 0-1962.0724
4454 , p5_a29 DATE := fnd_api.g_miss_date
4455 , p5_a30 NUMBER := 0-1962.0724
4456 , p5_a31 DATE := fnd_api.g_miss_date
4457 , p5_a32 NUMBER := 0-1962.0724
4458 )
4459
4460 as
4461 ddp_atlv_rec okl_tmpt_set_pvt.atlv_rec_type;
4462 ddindx binary_integer; indx binary_integer;
4463 begin
4464
4465 -- copy data to the local IN or IN-OUT args, if any
4466
4467
4468
4469
4470
4471 ddp_atlv_rec.id := rosetta_g_miss_num_map(p5_a0);
4472 ddp_atlv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
4473 ddp_atlv_rec.avl_id := rosetta_g_miss_num_map(p5_a2);
4474 ddp_atlv_rec.crd_code := p5_a3;
4475 ddp_atlv_rec.code_combination_id := rosetta_g_miss_num_map(p5_a4);
4476 ddp_atlv_rec.ae_line_type := p5_a5;
4477 ddp_atlv_rec.sequence_number := rosetta_g_miss_num_map(p5_a6);
4478 ddp_atlv_rec.description := p5_a7;
4479 ddp_atlv_rec.percentage := rosetta_g_miss_num_map(p5_a8);
4480 ddp_atlv_rec.account_builder_yn := p5_a9;
4481 ddp_atlv_rec.attribute_category := p5_a10;
4482 ddp_atlv_rec.attribute1 := p5_a11;
4483 ddp_atlv_rec.attribute2 := p5_a12;
4484 ddp_atlv_rec.attribute3 := p5_a13;
4485 ddp_atlv_rec.attribute4 := p5_a14;
4486 ddp_atlv_rec.attribute5 := p5_a15;
4487 ddp_atlv_rec.attribute6 := p5_a16;
4488 ddp_atlv_rec.attribute7 := p5_a17;
4489 ddp_atlv_rec.attribute8 := p5_a18;
4490 ddp_atlv_rec.attribute9 := p5_a19;
4491 ddp_atlv_rec.attribute10 := p5_a20;
4492 ddp_atlv_rec.attribute11 := p5_a21;
4493 ddp_atlv_rec.attribute12 := p5_a22;
4494 ddp_atlv_rec.attribute13 := p5_a23;
4495 ddp_atlv_rec.attribute14 := p5_a24;
4496 ddp_atlv_rec.attribute15 := p5_a25;
4497 ddp_atlv_rec.avl_tbl_index := rosetta_g_miss_num_map(p5_a26);
4498 ddp_atlv_rec.org_id := rosetta_g_miss_num_map(p5_a27);
4499 ddp_atlv_rec.created_by := rosetta_g_miss_num_map(p5_a28);
4500 ddp_atlv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a29);
4501 ddp_atlv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a30);
4502 ddp_atlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a31);
4503 ddp_atlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a32);
4504
4505 -- here's the delegated call to the old PL/SQL routine
4506 okl_tmpt_set_pvt.delete_tmpt_lines(p_api_version,
4507 p_init_msg_list,
4508 x_return_status,
4509 x_msg_count,
4510 x_msg_data,
4511 ddp_atlv_rec);
4512
4513 -- copy data back from the local variables to OUT or IN-OUT args, if any
4514
4515
4516
4517
4518
4519 end;
4520
4521 procedure validate_tmpt_lines(p_api_version NUMBER
4522 , p_init_msg_list VARCHAR2
4523 , x_return_status out nocopy VARCHAR2
4524 , x_msg_count out nocopy NUMBER
4525 , x_msg_data out nocopy VARCHAR2
4526 , p5_a0 JTF_NUMBER_TABLE
4527 , p5_a1 JTF_NUMBER_TABLE
4528 , p5_a2 JTF_NUMBER_TABLE
4529 , p5_a3 JTF_VARCHAR2_TABLE_100
4530 , p5_a4 JTF_NUMBER_TABLE
4531 , p5_a5 JTF_VARCHAR2_TABLE_100
4532 , p5_a6 JTF_NUMBER_TABLE
4533 , p5_a7 JTF_VARCHAR2_TABLE_2000
4534 , p5_a8 JTF_NUMBER_TABLE
4535 , p5_a9 JTF_VARCHAR2_TABLE_100
4536 , p5_a10 JTF_VARCHAR2_TABLE_100
4537 , p5_a11 JTF_VARCHAR2_TABLE_500
4538 , p5_a12 JTF_VARCHAR2_TABLE_500
4539 , p5_a13 JTF_VARCHAR2_TABLE_500
4540 , p5_a14 JTF_VARCHAR2_TABLE_500
4541 , p5_a15 JTF_VARCHAR2_TABLE_500
4542 , p5_a16 JTF_VARCHAR2_TABLE_500
4543 , p5_a17 JTF_VARCHAR2_TABLE_500
4544 , p5_a18 JTF_VARCHAR2_TABLE_500
4545 , p5_a19 JTF_VARCHAR2_TABLE_500
4546 , p5_a20 JTF_VARCHAR2_TABLE_500
4547 , p5_a21 JTF_VARCHAR2_TABLE_500
4548 , p5_a22 JTF_VARCHAR2_TABLE_500
4549 , p5_a23 JTF_VARCHAR2_TABLE_500
4550 , p5_a24 JTF_VARCHAR2_TABLE_500
4551 , p5_a25 JTF_VARCHAR2_TABLE_500
4552 , p5_a26 JTF_NUMBER_TABLE
4553 , p5_a27 JTF_NUMBER_TABLE
4554 , p5_a28 JTF_NUMBER_TABLE
4555 , p5_a29 JTF_DATE_TABLE
4556 , p5_a30 JTF_NUMBER_TABLE
4557 , p5_a31 JTF_DATE_TABLE
4558 , p5_a32 JTF_NUMBER_TABLE
4559 )
4560
4561 as
4562 ddp_atlv_tbl okl_tmpt_set_pvt.atlv_tbl_type;
4563 ddindx binary_integer; indx binary_integer;
4564 begin
4565
4566 -- copy data to the local IN or IN-OUT args, if any
4567
4568
4569
4570
4571
4572 okl_atl_pvt_w.rosetta_table_copy_in_p5(ddp_atlv_tbl, p5_a0
4573 , p5_a1
4574 , p5_a2
4575 , p5_a3
4576 , p5_a4
4577 , p5_a5
4578 , p5_a6
4579 , p5_a7
4580 , p5_a8
4581 , p5_a9
4582 , p5_a10
4583 , p5_a11
4584 , p5_a12
4585 , p5_a13
4586 , p5_a14
4587 , p5_a15
4588 , p5_a16
4589 , p5_a17
4590 , p5_a18
4591 , p5_a19
4592 , p5_a20
4593 , p5_a21
4594 , p5_a22
4595 , p5_a23
4596 , p5_a24
4597 , p5_a25
4598 , p5_a26
4599 , p5_a27
4600 , p5_a28
4601 , p5_a29
4602 , p5_a30
4603 , p5_a31
4604 , p5_a32
4605 );
4606
4607 -- here's the delegated call to the old PL/SQL routine
4608 okl_tmpt_set_pvt.validate_tmpt_lines(p_api_version,
4609 p_init_msg_list,
4610 x_return_status,
4611 x_msg_count,
4612 x_msg_data,
4613 ddp_atlv_tbl);
4614
4615 -- copy data back from the local variables to OUT or IN-OUT args, if any
4616
4617
4618
4619
4620
4621 end;
4622
4623 procedure validate_tmpt_lines(p_api_version NUMBER
4624 , p_init_msg_list VARCHAR2
4625 , x_return_status out nocopy VARCHAR2
4626 , x_msg_count out nocopy NUMBER
4627 , x_msg_data out nocopy VARCHAR2
4628 , p5_a0 NUMBER := 0-1962.0724
4629 , p5_a1 NUMBER := 0-1962.0724
4630 , p5_a2 NUMBER := 0-1962.0724
4631 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
4632 , p5_a4 NUMBER := 0-1962.0724
4633 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
4634 , p5_a6 NUMBER := 0-1962.0724
4635 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
4636 , p5_a8 NUMBER := 0-1962.0724
4637 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
4638 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
4639 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
4640 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
4641 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
4642 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
4643 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
4644 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
4645 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
4646 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
4647 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
4648 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
4649 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
4650 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
4651 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
4652 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
4653 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
4654 , p5_a26 NUMBER := 0-1962.0724
4655 , p5_a27 NUMBER := 0-1962.0724
4656 , p5_a28 NUMBER := 0-1962.0724
4657 , p5_a29 DATE := fnd_api.g_miss_date
4658 , p5_a30 NUMBER := 0-1962.0724
4659 , p5_a31 DATE := fnd_api.g_miss_date
4660 , p5_a32 NUMBER := 0-1962.0724
4661 )
4662
4663 as
4664 ddp_atlv_rec okl_tmpt_set_pvt.atlv_rec_type;
4665 ddindx binary_integer; indx binary_integer;
4666 begin
4667
4668 -- copy data to the local IN or IN-OUT args, if any
4669
4670
4671
4672
4673
4674 ddp_atlv_rec.id := rosetta_g_miss_num_map(p5_a0);
4675 ddp_atlv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
4676 ddp_atlv_rec.avl_id := rosetta_g_miss_num_map(p5_a2);
4677 ddp_atlv_rec.crd_code := p5_a3;
4678 ddp_atlv_rec.code_combination_id := rosetta_g_miss_num_map(p5_a4);
4679 ddp_atlv_rec.ae_line_type := p5_a5;
4680 ddp_atlv_rec.sequence_number := rosetta_g_miss_num_map(p5_a6);
4681 ddp_atlv_rec.description := p5_a7;
4682 ddp_atlv_rec.percentage := rosetta_g_miss_num_map(p5_a8);
4683 ddp_atlv_rec.account_builder_yn := p5_a9;
4684 ddp_atlv_rec.attribute_category := p5_a10;
4685 ddp_atlv_rec.attribute1 := p5_a11;
4686 ddp_atlv_rec.attribute2 := p5_a12;
4687 ddp_atlv_rec.attribute3 := p5_a13;
4688 ddp_atlv_rec.attribute4 := p5_a14;
4689 ddp_atlv_rec.attribute5 := p5_a15;
4690 ddp_atlv_rec.attribute6 := p5_a16;
4691 ddp_atlv_rec.attribute7 := p5_a17;
4692 ddp_atlv_rec.attribute8 := p5_a18;
4693 ddp_atlv_rec.attribute9 := p5_a19;
4694 ddp_atlv_rec.attribute10 := p5_a20;
4695 ddp_atlv_rec.attribute11 := p5_a21;
4696 ddp_atlv_rec.attribute12 := p5_a22;
4697 ddp_atlv_rec.attribute13 := p5_a23;
4698 ddp_atlv_rec.attribute14 := p5_a24;
4699 ddp_atlv_rec.attribute15 := p5_a25;
4700 ddp_atlv_rec.avl_tbl_index := rosetta_g_miss_num_map(p5_a26);
4701 ddp_atlv_rec.org_id := rosetta_g_miss_num_map(p5_a27);
4702 ddp_atlv_rec.created_by := rosetta_g_miss_num_map(p5_a28);
4703 ddp_atlv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a29);
4704 ddp_atlv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a30);
4705 ddp_atlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a31);
4706 ddp_atlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a32);
4707
4708 -- here's the delegated call to the old PL/SQL routine
4709 okl_tmpt_set_pvt.validate_tmpt_lines(p_api_version,
4710 p_init_msg_list,
4711 x_return_status,
4712 x_msg_count,
4713 x_msg_data,
4714 ddp_atlv_rec);
4715
4716 -- copy data back from the local variables to OUT or IN-OUT args, if any
4717
4718
4719
4720
4721
4722 end;
4723
4724 end okl_tmpt_set_pvt_w;