[Home] [Help]
PACKAGE BODY: APPS.OKL_OPTIONS_PUB_W
Source
1 package body okl_options_pub_w as
2 /* $Header: OKLUOPTB.pls 115.4 2002/12/24 04:13:03 sgorantl 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_options(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_VARCHAR2_TABLE_200
31 , p6_a4 JTF_VARCHAR2_TABLE_2000
32 , p6_a5 JTF_DATE_TABLE
33 , p6_a6 JTF_DATE_TABLE
34 , p6_a7 JTF_NUMBER_TABLE
35 , p6_a8 JTF_DATE_TABLE
36 , p6_a9 JTF_NUMBER_TABLE
37 , p6_a10 JTF_DATE_TABLE
38 , p6_a11 JTF_NUMBER_TABLE
39 , p7_a0 out nocopy NUMBER
40 , p7_a1 out nocopy NUMBER
41 , p7_a2 out nocopy VARCHAR2
42 , p7_a3 out nocopy VARCHAR2
43 , p7_a4 out nocopy DATE
44 , p7_a5 out nocopy DATE
45 , p7_a6 out nocopy VARCHAR2
46 , p7_a7 out nocopy VARCHAR2
47 , p7_a8 out nocopy VARCHAR2
48 , p7_a9 out nocopy VARCHAR2
49 , p7_a10 out nocopy VARCHAR2
50 , p7_a11 out nocopy VARCHAR2
51 , p7_a12 out nocopy VARCHAR2
52 , p7_a13 out nocopy VARCHAR2
53 , p7_a14 out nocopy VARCHAR2
54 , p7_a15 out nocopy VARCHAR2
55 , p7_a16 out nocopy VARCHAR2
56 , p7_a17 out nocopy VARCHAR2
57 , p7_a18 out nocopy VARCHAR2
58 , p7_a19 out nocopy VARCHAR2
59 , p7_a20 out nocopy VARCHAR2
60 , p7_a21 out nocopy VARCHAR2
61 , p7_a22 out nocopy NUMBER
62 , p7_a23 out nocopy DATE
63 , p7_a24 out nocopy NUMBER
64 , p7_a25 out nocopy DATE
65 , p7_a26 out nocopy NUMBER
66 , p8_a0 out nocopy JTF_NUMBER_TABLE
67 , p8_a1 out nocopy JTF_NUMBER_TABLE
68 , p8_a2 out nocopy JTF_NUMBER_TABLE
69 , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
70 , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000
71 , p8_a5 out nocopy JTF_DATE_TABLE
72 , p8_a6 out nocopy JTF_DATE_TABLE
73 , p8_a7 out nocopy JTF_NUMBER_TABLE
74 , p8_a8 out nocopy JTF_DATE_TABLE
75 , p8_a9 out nocopy JTF_NUMBER_TABLE
76 , p8_a10 out nocopy JTF_DATE_TABLE
77 , p8_a11 out nocopy JTF_NUMBER_TABLE
78 , p5_a0 NUMBER := 0-1962.0724
79 , p5_a1 NUMBER := 0-1962.0724
80 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
81 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
82 , p5_a4 DATE := fnd_api.g_miss_date
83 , p5_a5 DATE := fnd_api.g_miss_date
84 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
85 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
86 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
87 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
88 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
89 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
90 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
91 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
92 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
93 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
94 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
95 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
96 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
97 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
98 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
99 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
100 , p5_a22 NUMBER := 0-1962.0724
101 , p5_a23 DATE := fnd_api.g_miss_date
102 , p5_a24 NUMBER := 0-1962.0724
103 , p5_a25 DATE := fnd_api.g_miss_date
104 , p5_a26 NUMBER := 0-1962.0724
105 )
106
107 as
108 ddp_optv_rec okl_options_pub.optv_rec_type;
109 ddp_ovev_tbl okl_options_pub.ovev_tbl_type;
110 ddx_optv_rec okl_options_pub.optv_rec_type;
111 ddx_ovev_tbl okl_options_pub.ovev_tbl_type;
112 ddindx binary_integer; indx binary_integer;
113 begin
114
115 -- copy data to the local IN or IN-OUT args, if any
116
117
118
119
120
121 ddp_optv_rec.id := rosetta_g_miss_num_map(p5_a0);
122 ddp_optv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
123 ddp_optv_rec.name := p5_a2;
124 ddp_optv_rec.description := p5_a3;
125 ddp_optv_rec.from_date := rosetta_g_miss_date_in_map(p5_a4);
126 ddp_optv_rec.to_date := rosetta_g_miss_date_in_map(p5_a5);
127 ddp_optv_rec.attribute_category := p5_a6;
128 ddp_optv_rec.attribute1 := p5_a7;
129 ddp_optv_rec.attribute2 := p5_a8;
130 ddp_optv_rec.attribute3 := p5_a9;
131 ddp_optv_rec.attribute4 := p5_a10;
132 ddp_optv_rec.attribute5 := p5_a11;
133 ddp_optv_rec.attribute6 := p5_a12;
134 ddp_optv_rec.attribute7 := p5_a13;
135 ddp_optv_rec.attribute8 := p5_a14;
136 ddp_optv_rec.attribute9 := p5_a15;
137 ddp_optv_rec.attribute10 := p5_a16;
138 ddp_optv_rec.attribute11 := p5_a17;
139 ddp_optv_rec.attribute12 := p5_a18;
140 ddp_optv_rec.attribute13 := p5_a19;
141 ddp_optv_rec.attribute14 := p5_a20;
142 ddp_optv_rec.attribute15 := p5_a21;
143 ddp_optv_rec.created_by := rosetta_g_miss_num_map(p5_a22);
144 ddp_optv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a23);
145 ddp_optv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a24);
146 ddp_optv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a25);
147 ddp_optv_rec.last_update_login := rosetta_g_miss_num_map(p5_a26);
148
149 okl_ove_pvt_w.rosetta_table_copy_in_p5(ddp_ovev_tbl, p6_a0
150 , p6_a1
151 , p6_a2
152 , p6_a3
153 , p6_a4
154 , p6_a5
155 , p6_a6
156 , p6_a7
157 , p6_a8
158 , p6_a9
159 , p6_a10
160 , p6_a11
161 );
162
163
164
165 -- here's the delegated call to the old PL/SQL routine
166 okl_options_pub.create_options(p_api_version,
167 p_init_msg_list,
168 x_return_status,
169 x_msg_count,
170 x_msg_data,
171 ddp_optv_rec,
172 ddp_ovev_tbl,
173 ddx_optv_rec,
174 ddx_ovev_tbl);
175
176 -- copy data back from the local variables to OUT or IN-OUT args, if any
177
178
179
180
181
182
183
184 p7_a0 := rosetta_g_miss_num_map(ddx_optv_rec.id);
185 p7_a1 := rosetta_g_miss_num_map(ddx_optv_rec.object_version_number);
186 p7_a2 := ddx_optv_rec.name;
187 p7_a3 := ddx_optv_rec.description;
188 p7_a4 := ddx_optv_rec.from_date;
189 p7_a5 := ddx_optv_rec.to_date;
190 p7_a6 := ddx_optv_rec.attribute_category;
191 p7_a7 := ddx_optv_rec.attribute1;
192 p7_a8 := ddx_optv_rec.attribute2;
193 p7_a9 := ddx_optv_rec.attribute3;
194 p7_a10 := ddx_optv_rec.attribute4;
195 p7_a11 := ddx_optv_rec.attribute5;
196 p7_a12 := ddx_optv_rec.attribute6;
197 p7_a13 := ddx_optv_rec.attribute7;
198 p7_a14 := ddx_optv_rec.attribute8;
199 p7_a15 := ddx_optv_rec.attribute9;
200 p7_a16 := ddx_optv_rec.attribute10;
201 p7_a17 := ddx_optv_rec.attribute11;
202 p7_a18 := ddx_optv_rec.attribute12;
203 p7_a19 := ddx_optv_rec.attribute13;
204 p7_a20 := ddx_optv_rec.attribute14;
205 p7_a21 := ddx_optv_rec.attribute15;
206 p7_a22 := rosetta_g_miss_num_map(ddx_optv_rec.created_by);
207 p7_a23 := ddx_optv_rec.creation_date;
208 p7_a24 := rosetta_g_miss_num_map(ddx_optv_rec.last_updated_by);
209 p7_a25 := ddx_optv_rec.last_update_date;
210 p7_a26 := rosetta_g_miss_num_map(ddx_optv_rec.last_update_login);
211
212 okl_ove_pvt_w.rosetta_table_copy_out_p5(ddx_ovev_tbl, p8_a0
213 , p8_a1
214 , p8_a2
215 , p8_a3
216 , p8_a4
217 , p8_a5
218 , p8_a6
219 , p8_a7
220 , p8_a8
221 , p8_a9
222 , p8_a10
223 , p8_a11
224 );
225 end;
226
227 procedure update_options(p_api_version NUMBER
228 , p_init_msg_list VARCHAR2
229 , x_return_status out nocopy VARCHAR2
230 , x_msg_count out nocopy NUMBER
231 , x_msg_data out nocopy VARCHAR2
232 , p6_a0 JTF_NUMBER_TABLE
233 , p6_a1 JTF_NUMBER_TABLE
234 , p6_a2 JTF_NUMBER_TABLE
235 , p6_a3 JTF_VARCHAR2_TABLE_200
236 , p6_a4 JTF_VARCHAR2_TABLE_2000
237 , p6_a5 JTF_DATE_TABLE
238 , p6_a6 JTF_DATE_TABLE
239 , p6_a7 JTF_NUMBER_TABLE
240 , p6_a8 JTF_DATE_TABLE
241 , p6_a9 JTF_NUMBER_TABLE
242 , p6_a10 JTF_DATE_TABLE
243 , p6_a11 JTF_NUMBER_TABLE
244 , p7_a0 out nocopy NUMBER
245 , p7_a1 out nocopy NUMBER
246 , p7_a2 out nocopy VARCHAR2
247 , p7_a3 out nocopy VARCHAR2
248 , p7_a4 out nocopy DATE
249 , p7_a5 out nocopy DATE
250 , p7_a6 out nocopy VARCHAR2
251 , p7_a7 out nocopy VARCHAR2
252 , p7_a8 out nocopy VARCHAR2
253 , p7_a9 out nocopy VARCHAR2
254 , p7_a10 out nocopy VARCHAR2
255 , p7_a11 out nocopy VARCHAR2
256 , p7_a12 out nocopy VARCHAR2
257 , p7_a13 out nocopy VARCHAR2
258 , p7_a14 out nocopy VARCHAR2
259 , p7_a15 out nocopy VARCHAR2
260 , p7_a16 out nocopy VARCHAR2
261 , p7_a17 out nocopy VARCHAR2
262 , p7_a18 out nocopy VARCHAR2
263 , p7_a19 out nocopy VARCHAR2
264 , p7_a20 out nocopy VARCHAR2
265 , p7_a21 out nocopy VARCHAR2
266 , p7_a22 out nocopy NUMBER
267 , p7_a23 out nocopy DATE
268 , p7_a24 out nocopy NUMBER
269 , p7_a25 out nocopy DATE
270 , p7_a26 out nocopy NUMBER
271 , p8_a0 out nocopy JTF_NUMBER_TABLE
272 , p8_a1 out nocopy JTF_NUMBER_TABLE
273 , p8_a2 out nocopy JTF_NUMBER_TABLE
274 , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
275 , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000
276 , p8_a5 out nocopy JTF_DATE_TABLE
277 , p8_a6 out nocopy JTF_DATE_TABLE
278 , p8_a7 out nocopy JTF_NUMBER_TABLE
279 , p8_a8 out nocopy JTF_DATE_TABLE
280 , p8_a9 out nocopy JTF_NUMBER_TABLE
281 , p8_a10 out nocopy JTF_DATE_TABLE
282 , p8_a11 out nocopy JTF_NUMBER_TABLE
283 , p5_a0 NUMBER := 0-1962.0724
284 , p5_a1 NUMBER := 0-1962.0724
285 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
286 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
287 , p5_a4 DATE := fnd_api.g_miss_date
288 , p5_a5 DATE := fnd_api.g_miss_date
289 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
290 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
291 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
292 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
293 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
294 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
295 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
296 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
297 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
298 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
299 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
300 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
301 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
302 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
303 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
304 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
305 , p5_a22 NUMBER := 0-1962.0724
306 , p5_a23 DATE := fnd_api.g_miss_date
307 , p5_a24 NUMBER := 0-1962.0724
308 , p5_a25 DATE := fnd_api.g_miss_date
309 , p5_a26 NUMBER := 0-1962.0724
310 )
311
312 as
313 ddp_optv_rec okl_options_pub.optv_rec_type;
314 ddp_ovev_tbl okl_options_pub.ovev_tbl_type;
315 ddx_optv_rec okl_options_pub.optv_rec_type;
316 ddx_ovev_tbl okl_options_pub.ovev_tbl_type;
317 ddindx binary_integer; indx binary_integer;
318 begin
319
320 -- copy data to the local IN or IN-OUT args, if any
321
322
323
324
325
326 ddp_optv_rec.id := rosetta_g_miss_num_map(p5_a0);
327 ddp_optv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
328 ddp_optv_rec.name := p5_a2;
329 ddp_optv_rec.description := p5_a3;
330 ddp_optv_rec.from_date := rosetta_g_miss_date_in_map(p5_a4);
331 ddp_optv_rec.to_date := rosetta_g_miss_date_in_map(p5_a5);
332 ddp_optv_rec.attribute_category := p5_a6;
333 ddp_optv_rec.attribute1 := p5_a7;
334 ddp_optv_rec.attribute2 := p5_a8;
335 ddp_optv_rec.attribute3 := p5_a9;
336 ddp_optv_rec.attribute4 := p5_a10;
337 ddp_optv_rec.attribute5 := p5_a11;
338 ddp_optv_rec.attribute6 := p5_a12;
339 ddp_optv_rec.attribute7 := p5_a13;
340 ddp_optv_rec.attribute8 := p5_a14;
341 ddp_optv_rec.attribute9 := p5_a15;
342 ddp_optv_rec.attribute10 := p5_a16;
343 ddp_optv_rec.attribute11 := p5_a17;
344 ddp_optv_rec.attribute12 := p5_a18;
345 ddp_optv_rec.attribute13 := p5_a19;
346 ddp_optv_rec.attribute14 := p5_a20;
347 ddp_optv_rec.attribute15 := p5_a21;
348 ddp_optv_rec.created_by := rosetta_g_miss_num_map(p5_a22);
349 ddp_optv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a23);
350 ddp_optv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a24);
351 ddp_optv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a25);
352 ddp_optv_rec.last_update_login := rosetta_g_miss_num_map(p5_a26);
353
354 okl_ove_pvt_w.rosetta_table_copy_in_p5(ddp_ovev_tbl, p6_a0
355 , p6_a1
356 , p6_a2
357 , p6_a3
358 , p6_a4
359 , p6_a5
360 , p6_a6
361 , p6_a7
362 , p6_a8
363 , p6_a9
364 , p6_a10
365 , p6_a11
366 );
367
368
369
370 -- here's the delegated call to the old PL/SQL routine
371 okl_options_pub.update_options(p_api_version,
372 p_init_msg_list,
373 x_return_status,
374 x_msg_count,
375 x_msg_data,
376 ddp_optv_rec,
377 ddp_ovev_tbl,
378 ddx_optv_rec,
379 ddx_ovev_tbl);
380
381 -- copy data back from the local variables to OUT or IN-OUT args, if any
382
383
384
385
386
387
388
389 p7_a0 := rosetta_g_miss_num_map(ddx_optv_rec.id);
390 p7_a1 := rosetta_g_miss_num_map(ddx_optv_rec.object_version_number);
391 p7_a2 := ddx_optv_rec.name;
392 p7_a3 := ddx_optv_rec.description;
393 p7_a4 := ddx_optv_rec.from_date;
394 p7_a5 := ddx_optv_rec.to_date;
395 p7_a6 := ddx_optv_rec.attribute_category;
396 p7_a7 := ddx_optv_rec.attribute1;
397 p7_a8 := ddx_optv_rec.attribute2;
398 p7_a9 := ddx_optv_rec.attribute3;
399 p7_a10 := ddx_optv_rec.attribute4;
400 p7_a11 := ddx_optv_rec.attribute5;
401 p7_a12 := ddx_optv_rec.attribute6;
402 p7_a13 := ddx_optv_rec.attribute7;
403 p7_a14 := ddx_optv_rec.attribute8;
404 p7_a15 := ddx_optv_rec.attribute9;
405 p7_a16 := ddx_optv_rec.attribute10;
406 p7_a17 := ddx_optv_rec.attribute11;
407 p7_a18 := ddx_optv_rec.attribute12;
408 p7_a19 := ddx_optv_rec.attribute13;
409 p7_a20 := ddx_optv_rec.attribute14;
410 p7_a21 := ddx_optv_rec.attribute15;
411 p7_a22 := rosetta_g_miss_num_map(ddx_optv_rec.created_by);
412 p7_a23 := ddx_optv_rec.creation_date;
413 p7_a24 := rosetta_g_miss_num_map(ddx_optv_rec.last_updated_by);
414 p7_a25 := ddx_optv_rec.last_update_date;
415 p7_a26 := rosetta_g_miss_num_map(ddx_optv_rec.last_update_login);
416
417 okl_ove_pvt_w.rosetta_table_copy_out_p5(ddx_ovev_tbl, p8_a0
418 , p8_a1
419 , p8_a2
420 , p8_a3
421 , p8_a4
422 , p8_a5
423 , p8_a6
424 , p8_a7
425 , p8_a8
426 , p8_a9
427 , p8_a10
428 , p8_a11
429 );
430 end;
431
432 procedure validate_options(p_api_version NUMBER
433 , p_init_msg_list VARCHAR2
434 , x_return_status out nocopy VARCHAR2
435 , x_msg_count out nocopy NUMBER
436 , x_msg_data out nocopy VARCHAR2
437 , p6_a0 JTF_NUMBER_TABLE
438 , p6_a1 JTF_NUMBER_TABLE
439 , p6_a2 JTF_NUMBER_TABLE
440 , p6_a3 JTF_VARCHAR2_TABLE_200
441 , p6_a4 JTF_VARCHAR2_TABLE_2000
442 , p6_a5 JTF_DATE_TABLE
443 , p6_a6 JTF_DATE_TABLE
444 , p6_a7 JTF_NUMBER_TABLE
445 , p6_a8 JTF_DATE_TABLE
446 , p6_a9 JTF_NUMBER_TABLE
447 , p6_a10 JTF_DATE_TABLE
448 , p6_a11 JTF_NUMBER_TABLE
449 , p5_a0 NUMBER := 0-1962.0724
450 , p5_a1 NUMBER := 0-1962.0724
451 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
452 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
453 , p5_a4 DATE := fnd_api.g_miss_date
454 , p5_a5 DATE := fnd_api.g_miss_date
455 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
456 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
457 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
458 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
459 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
460 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
461 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
462 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
463 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
464 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
465 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
466 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
467 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
468 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
469 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
470 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
471 , p5_a22 NUMBER := 0-1962.0724
472 , p5_a23 DATE := fnd_api.g_miss_date
473 , p5_a24 NUMBER := 0-1962.0724
474 , p5_a25 DATE := fnd_api.g_miss_date
475 , p5_a26 NUMBER := 0-1962.0724
476 )
477
478 as
479 ddp_optv_rec okl_options_pub.optv_rec_type;
480 ddp_ovev_tbl okl_options_pub.ovev_tbl_type;
481 ddindx binary_integer; indx binary_integer;
482 begin
483
484 -- copy data to the local IN or IN-OUT args, if any
485
486
487
488
489
490 ddp_optv_rec.id := rosetta_g_miss_num_map(p5_a0);
491 ddp_optv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
492 ddp_optv_rec.name := p5_a2;
493 ddp_optv_rec.description := p5_a3;
494 ddp_optv_rec.from_date := rosetta_g_miss_date_in_map(p5_a4);
495 ddp_optv_rec.to_date := rosetta_g_miss_date_in_map(p5_a5);
496 ddp_optv_rec.attribute_category := p5_a6;
497 ddp_optv_rec.attribute1 := p5_a7;
498 ddp_optv_rec.attribute2 := p5_a8;
499 ddp_optv_rec.attribute3 := p5_a9;
500 ddp_optv_rec.attribute4 := p5_a10;
501 ddp_optv_rec.attribute5 := p5_a11;
502 ddp_optv_rec.attribute6 := p5_a12;
503 ddp_optv_rec.attribute7 := p5_a13;
504 ddp_optv_rec.attribute8 := p5_a14;
505 ddp_optv_rec.attribute9 := p5_a15;
506 ddp_optv_rec.attribute10 := p5_a16;
507 ddp_optv_rec.attribute11 := p5_a17;
508 ddp_optv_rec.attribute12 := p5_a18;
509 ddp_optv_rec.attribute13 := p5_a19;
510 ddp_optv_rec.attribute14 := p5_a20;
511 ddp_optv_rec.attribute15 := p5_a21;
512 ddp_optv_rec.created_by := rosetta_g_miss_num_map(p5_a22);
513 ddp_optv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a23);
514 ddp_optv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a24);
515 ddp_optv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a25);
516 ddp_optv_rec.last_update_login := rosetta_g_miss_num_map(p5_a26);
517
518 okl_ove_pvt_w.rosetta_table_copy_in_p5(ddp_ovev_tbl, p6_a0
519 , p6_a1
520 , p6_a2
521 , p6_a3
522 , p6_a4
523 , p6_a5
524 , p6_a6
525 , p6_a7
526 , p6_a8
527 , p6_a9
528 , p6_a10
529 , p6_a11
530 );
531
532 -- here's the delegated call to the old PL/SQL routine
533 okl_options_pub.validate_options(p_api_version,
534 p_init_msg_list,
535 x_return_status,
536 x_msg_count,
537 x_msg_data,
538 ddp_optv_rec,
539 ddp_ovev_tbl);
540
541 -- copy data back from the local variables to OUT or IN-OUT args, if any
542
543
544
545
546
547
548 end;
549
550 procedure create_options(p_api_version NUMBER
551 , p_init_msg_list VARCHAR2
552 , x_return_status out nocopy VARCHAR2
553 , x_msg_count out nocopy NUMBER
554 , x_msg_data out nocopy VARCHAR2
555 , p5_a0 JTF_NUMBER_TABLE
556 , p5_a1 JTF_NUMBER_TABLE
557 , p5_a2 JTF_VARCHAR2_TABLE_200
558 , p5_a3 JTF_VARCHAR2_TABLE_2000
559 , p5_a4 JTF_DATE_TABLE
560 , p5_a5 JTF_DATE_TABLE
561 , p5_a6 JTF_VARCHAR2_TABLE_100
562 , p5_a7 JTF_VARCHAR2_TABLE_500
563 , p5_a8 JTF_VARCHAR2_TABLE_500
564 , p5_a9 JTF_VARCHAR2_TABLE_500
565 , p5_a10 JTF_VARCHAR2_TABLE_500
566 , p5_a11 JTF_VARCHAR2_TABLE_500
567 , p5_a12 JTF_VARCHAR2_TABLE_500
568 , p5_a13 JTF_VARCHAR2_TABLE_500
569 , p5_a14 JTF_VARCHAR2_TABLE_500
570 , p5_a15 JTF_VARCHAR2_TABLE_500
571 , p5_a16 JTF_VARCHAR2_TABLE_500
572 , p5_a17 JTF_VARCHAR2_TABLE_500
573 , p5_a18 JTF_VARCHAR2_TABLE_500
574 , p5_a19 JTF_VARCHAR2_TABLE_500
575 , p5_a20 JTF_VARCHAR2_TABLE_500
576 , p5_a21 JTF_VARCHAR2_TABLE_500
577 , p5_a22 JTF_NUMBER_TABLE
578 , p5_a23 JTF_DATE_TABLE
579 , p5_a24 JTF_NUMBER_TABLE
580 , p5_a25 JTF_DATE_TABLE
581 , p5_a26 JTF_NUMBER_TABLE
582 , p6_a0 out nocopy JTF_NUMBER_TABLE
583 , p6_a1 out nocopy JTF_NUMBER_TABLE
584 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
585 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
586 , p6_a4 out nocopy JTF_DATE_TABLE
587 , p6_a5 out nocopy JTF_DATE_TABLE
588 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
589 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
590 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
591 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
592 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
593 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
594 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
595 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
596 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
597 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
598 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
599 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
600 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
601 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
602 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
603 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
604 , p6_a22 out nocopy JTF_NUMBER_TABLE
605 , p6_a23 out nocopy JTF_DATE_TABLE
606 , p6_a24 out nocopy JTF_NUMBER_TABLE
607 , p6_a25 out nocopy JTF_DATE_TABLE
608 , p6_a26 out nocopy JTF_NUMBER_TABLE
609 )
610
611 as
612 ddp_optv_tbl okl_options_pub.optv_tbl_type;
613 ddx_optv_tbl okl_options_pub.optv_tbl_type;
614 ddindx binary_integer; indx binary_integer;
615 begin
616
617 -- copy data to the local IN or IN-OUT args, if any
618
619
620
621
622
623 okl_opt_pvt_w.rosetta_table_copy_in_p5(ddp_optv_tbl, p5_a0
624 , p5_a1
625 , p5_a2
626 , p5_a3
627 , p5_a4
628 , p5_a5
629 , p5_a6
630 , p5_a7
631 , p5_a8
632 , p5_a9
633 , p5_a10
634 , p5_a11
635 , p5_a12
636 , p5_a13
637 , p5_a14
638 , p5_a15
639 , p5_a16
640 , p5_a17
641 , p5_a18
642 , p5_a19
643 , p5_a20
644 , p5_a21
645 , p5_a22
646 , p5_a23
647 , p5_a24
648 , p5_a25
649 , p5_a26
650 );
651
652
653 -- here's the delegated call to the old PL/SQL routine
654 okl_options_pub.create_options(p_api_version,
655 p_init_msg_list,
656 x_return_status,
657 x_msg_count,
658 x_msg_data,
659 ddp_optv_tbl,
660 ddx_optv_tbl);
661
662 -- copy data back from the local variables to OUT or IN-OUT args, if any
663
664
665
666
667
668
669 okl_opt_pvt_w.rosetta_table_copy_out_p5(ddx_optv_tbl, p6_a0
670 , p6_a1
671 , p6_a2
672 , p6_a3
673 , p6_a4
674 , p6_a5
675 , p6_a6
676 , p6_a7
677 , p6_a8
678 , p6_a9
679 , p6_a10
680 , p6_a11
681 , p6_a12
682 , p6_a13
683 , p6_a14
684 , p6_a15
685 , p6_a16
686 , p6_a17
687 , p6_a18
688 , p6_a19
689 , p6_a20
690 , p6_a21
691 , p6_a22
692 , p6_a23
693 , p6_a24
694 , p6_a25
695 , p6_a26
696 );
697 end;
698
699 procedure create_options(p_api_version NUMBER
700 , p_init_msg_list VARCHAR2
701 , x_return_status out nocopy VARCHAR2
702 , x_msg_count out nocopy NUMBER
703 , x_msg_data out nocopy VARCHAR2
704 , p6_a0 out nocopy NUMBER
705 , p6_a1 out nocopy NUMBER
706 , p6_a2 out nocopy VARCHAR2
707 , p6_a3 out nocopy VARCHAR2
708 , p6_a4 out nocopy DATE
709 , p6_a5 out nocopy DATE
710 , p6_a6 out nocopy VARCHAR2
711 , p6_a7 out nocopy VARCHAR2
712 , p6_a8 out nocopy VARCHAR2
713 , p6_a9 out nocopy VARCHAR2
714 , p6_a10 out nocopy VARCHAR2
715 , p6_a11 out nocopy VARCHAR2
716 , p6_a12 out nocopy VARCHAR2
717 , p6_a13 out nocopy VARCHAR2
718 , p6_a14 out nocopy VARCHAR2
719 , p6_a15 out nocopy VARCHAR2
720 , p6_a16 out nocopy VARCHAR2
721 , p6_a17 out nocopy VARCHAR2
722 , p6_a18 out nocopy VARCHAR2
723 , p6_a19 out nocopy VARCHAR2
724 , p6_a20 out nocopy VARCHAR2
725 , p6_a21 out nocopy VARCHAR2
726 , p6_a22 out nocopy NUMBER
727 , p6_a23 out nocopy DATE
728 , p6_a24 out nocopy NUMBER
729 , p6_a25 out nocopy DATE
730 , p6_a26 out nocopy NUMBER
731 , p5_a0 NUMBER := 0-1962.0724
732 , p5_a1 NUMBER := 0-1962.0724
733 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
734 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
735 , p5_a4 DATE := fnd_api.g_miss_date
736 , p5_a5 DATE := fnd_api.g_miss_date
737 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
738 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
739 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
740 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
741 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
742 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
743 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
744 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
745 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
746 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
747 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
748 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
749 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
750 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
751 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
752 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
753 , p5_a22 NUMBER := 0-1962.0724
754 , p5_a23 DATE := fnd_api.g_miss_date
755 , p5_a24 NUMBER := 0-1962.0724
756 , p5_a25 DATE := fnd_api.g_miss_date
757 , p5_a26 NUMBER := 0-1962.0724
758 )
759
760 as
761 ddp_optv_rec okl_options_pub.optv_rec_type;
762 ddx_optv_rec okl_options_pub.optv_rec_type;
763 ddindx binary_integer; indx binary_integer;
764 begin
765
766 -- copy data to the local IN or IN-OUT args, if any
767
768
769
770
771
772 ddp_optv_rec.id := rosetta_g_miss_num_map(p5_a0);
773 ddp_optv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
774 ddp_optv_rec.name := p5_a2;
775 ddp_optv_rec.description := p5_a3;
776 ddp_optv_rec.from_date := rosetta_g_miss_date_in_map(p5_a4);
777 ddp_optv_rec.to_date := rosetta_g_miss_date_in_map(p5_a5);
778 ddp_optv_rec.attribute_category := p5_a6;
779 ddp_optv_rec.attribute1 := p5_a7;
780 ddp_optv_rec.attribute2 := p5_a8;
781 ddp_optv_rec.attribute3 := p5_a9;
782 ddp_optv_rec.attribute4 := p5_a10;
783 ddp_optv_rec.attribute5 := p5_a11;
784 ddp_optv_rec.attribute6 := p5_a12;
785 ddp_optv_rec.attribute7 := p5_a13;
786 ddp_optv_rec.attribute8 := p5_a14;
787 ddp_optv_rec.attribute9 := p5_a15;
788 ddp_optv_rec.attribute10 := p5_a16;
789 ddp_optv_rec.attribute11 := p5_a17;
790 ddp_optv_rec.attribute12 := p5_a18;
791 ddp_optv_rec.attribute13 := p5_a19;
792 ddp_optv_rec.attribute14 := p5_a20;
793 ddp_optv_rec.attribute15 := p5_a21;
794 ddp_optv_rec.created_by := rosetta_g_miss_num_map(p5_a22);
795 ddp_optv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a23);
796 ddp_optv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a24);
797 ddp_optv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a25);
798 ddp_optv_rec.last_update_login := rosetta_g_miss_num_map(p5_a26);
799
800
801 -- here's the delegated call to the old PL/SQL routine
802 okl_options_pub.create_options(p_api_version,
803 p_init_msg_list,
804 x_return_status,
805 x_msg_count,
806 x_msg_data,
807 ddp_optv_rec,
808 ddx_optv_rec);
809
810 -- copy data back from the local variables to OUT or IN-OUT args, if any
811
812
813
814
815
816
817 p6_a0 := rosetta_g_miss_num_map(ddx_optv_rec.id);
818 p6_a1 := rosetta_g_miss_num_map(ddx_optv_rec.object_version_number);
819 p6_a2 := ddx_optv_rec.name;
820 p6_a3 := ddx_optv_rec.description;
821 p6_a4 := ddx_optv_rec.from_date;
822 p6_a5 := ddx_optv_rec.to_date;
823 p6_a6 := ddx_optv_rec.attribute_category;
824 p6_a7 := ddx_optv_rec.attribute1;
825 p6_a8 := ddx_optv_rec.attribute2;
826 p6_a9 := ddx_optv_rec.attribute3;
827 p6_a10 := ddx_optv_rec.attribute4;
828 p6_a11 := ddx_optv_rec.attribute5;
829 p6_a12 := ddx_optv_rec.attribute6;
830 p6_a13 := ddx_optv_rec.attribute7;
831 p6_a14 := ddx_optv_rec.attribute8;
832 p6_a15 := ddx_optv_rec.attribute9;
833 p6_a16 := ddx_optv_rec.attribute10;
834 p6_a17 := ddx_optv_rec.attribute11;
835 p6_a18 := ddx_optv_rec.attribute12;
836 p6_a19 := ddx_optv_rec.attribute13;
837 p6_a20 := ddx_optv_rec.attribute14;
838 p6_a21 := ddx_optv_rec.attribute15;
839 p6_a22 := rosetta_g_miss_num_map(ddx_optv_rec.created_by);
840 p6_a23 := ddx_optv_rec.creation_date;
841 p6_a24 := rosetta_g_miss_num_map(ddx_optv_rec.last_updated_by);
842 p6_a25 := ddx_optv_rec.last_update_date;
843 p6_a26 := rosetta_g_miss_num_map(ddx_optv_rec.last_update_login);
844 end;
845
846 procedure lock_options(p_api_version NUMBER
847 , p_init_msg_list VARCHAR2
848 , x_return_status out nocopy VARCHAR2
849 , x_msg_count out nocopy NUMBER
850 , x_msg_data out nocopy VARCHAR2
851 , p5_a0 JTF_NUMBER_TABLE
852 , p5_a1 JTF_NUMBER_TABLE
853 , p5_a2 JTF_VARCHAR2_TABLE_200
854 , p5_a3 JTF_VARCHAR2_TABLE_2000
855 , p5_a4 JTF_DATE_TABLE
856 , p5_a5 JTF_DATE_TABLE
857 , p5_a6 JTF_VARCHAR2_TABLE_100
858 , p5_a7 JTF_VARCHAR2_TABLE_500
859 , p5_a8 JTF_VARCHAR2_TABLE_500
860 , p5_a9 JTF_VARCHAR2_TABLE_500
861 , p5_a10 JTF_VARCHAR2_TABLE_500
862 , p5_a11 JTF_VARCHAR2_TABLE_500
863 , p5_a12 JTF_VARCHAR2_TABLE_500
864 , p5_a13 JTF_VARCHAR2_TABLE_500
865 , p5_a14 JTF_VARCHAR2_TABLE_500
866 , p5_a15 JTF_VARCHAR2_TABLE_500
867 , p5_a16 JTF_VARCHAR2_TABLE_500
868 , p5_a17 JTF_VARCHAR2_TABLE_500
869 , p5_a18 JTF_VARCHAR2_TABLE_500
870 , p5_a19 JTF_VARCHAR2_TABLE_500
871 , p5_a20 JTF_VARCHAR2_TABLE_500
872 , p5_a21 JTF_VARCHAR2_TABLE_500
873 , p5_a22 JTF_NUMBER_TABLE
874 , p5_a23 JTF_DATE_TABLE
875 , p5_a24 JTF_NUMBER_TABLE
876 , p5_a25 JTF_DATE_TABLE
877 , p5_a26 JTF_NUMBER_TABLE
878 )
879
880 as
881 ddp_optv_tbl okl_options_pub.optv_tbl_type;
882 ddindx binary_integer; indx binary_integer;
883 begin
884
885 -- copy data to the local IN or IN-OUT args, if any
886
887
888
889
890
891 okl_opt_pvt_w.rosetta_table_copy_in_p5(ddp_optv_tbl, p5_a0
892 , p5_a1
893 , p5_a2
894 , p5_a3
895 , p5_a4
896 , p5_a5
897 , p5_a6
898 , p5_a7
899 , p5_a8
900 , p5_a9
901 , p5_a10
902 , p5_a11
903 , p5_a12
904 , p5_a13
905 , p5_a14
906 , p5_a15
907 , p5_a16
908 , p5_a17
909 , p5_a18
910 , p5_a19
911 , p5_a20
912 , p5_a21
913 , p5_a22
914 , p5_a23
915 , p5_a24
916 , p5_a25
917 , p5_a26
918 );
919
920 -- here's the delegated call to the old PL/SQL routine
921 okl_options_pub.lock_options(p_api_version,
922 p_init_msg_list,
923 x_return_status,
924 x_msg_count,
925 x_msg_data,
926 ddp_optv_tbl);
927
928 -- copy data back from the local variables to OUT or IN-OUT args, if any
929
930
931
932
933
934 end;
935
936 procedure lock_options(p_api_version NUMBER
937 , p_init_msg_list VARCHAR2
938 , x_return_status out nocopy VARCHAR2
939 , x_msg_count out nocopy NUMBER
940 , x_msg_data out nocopy VARCHAR2
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 DATE := fnd_api.g_miss_date
946 , p5_a5 DATE := fnd_api.g_miss_date
947 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
948 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
949 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
950 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
951 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
952 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
953 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
954 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
955 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
956 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
957 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
958 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
959 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
960 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
961 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
962 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
963 , p5_a22 NUMBER := 0-1962.0724
964 , p5_a23 DATE := fnd_api.g_miss_date
965 , p5_a24 NUMBER := 0-1962.0724
966 , p5_a25 DATE := fnd_api.g_miss_date
967 , p5_a26 NUMBER := 0-1962.0724
968 )
969
970 as
971 ddp_optv_rec okl_options_pub.optv_rec_type;
972 ddindx binary_integer; indx binary_integer;
973 begin
974
975 -- copy data to the local IN or IN-OUT args, if any
976
977
978
979
980
981 ddp_optv_rec.id := rosetta_g_miss_num_map(p5_a0);
982 ddp_optv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
983 ddp_optv_rec.name := p5_a2;
984 ddp_optv_rec.description := p5_a3;
985 ddp_optv_rec.from_date := rosetta_g_miss_date_in_map(p5_a4);
986 ddp_optv_rec.to_date := rosetta_g_miss_date_in_map(p5_a5);
987 ddp_optv_rec.attribute_category := p5_a6;
988 ddp_optv_rec.attribute1 := p5_a7;
989 ddp_optv_rec.attribute2 := p5_a8;
990 ddp_optv_rec.attribute3 := p5_a9;
991 ddp_optv_rec.attribute4 := p5_a10;
992 ddp_optv_rec.attribute5 := p5_a11;
993 ddp_optv_rec.attribute6 := p5_a12;
994 ddp_optv_rec.attribute7 := p5_a13;
995 ddp_optv_rec.attribute8 := p5_a14;
996 ddp_optv_rec.attribute9 := p5_a15;
997 ddp_optv_rec.attribute10 := p5_a16;
998 ddp_optv_rec.attribute11 := p5_a17;
999 ddp_optv_rec.attribute12 := p5_a18;
1000 ddp_optv_rec.attribute13 := p5_a19;
1001 ddp_optv_rec.attribute14 := p5_a20;
1002 ddp_optv_rec.attribute15 := p5_a21;
1003 ddp_optv_rec.created_by := rosetta_g_miss_num_map(p5_a22);
1004 ddp_optv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a23);
1005 ddp_optv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a24);
1006 ddp_optv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a25);
1007 ddp_optv_rec.last_update_login := rosetta_g_miss_num_map(p5_a26);
1008
1009 -- here's the delegated call to the old PL/SQL routine
1010 okl_options_pub.lock_options(p_api_version,
1011 p_init_msg_list,
1012 x_return_status,
1013 x_msg_count,
1014 x_msg_data,
1015 ddp_optv_rec);
1016
1017 -- copy data back from the local variables to OUT or IN-OUT args, if any
1018
1019
1020
1021
1022
1023 end;
1024
1025 procedure update_options(p_api_version NUMBER
1026 , p_init_msg_list VARCHAR2
1027 , x_return_status out nocopy VARCHAR2
1028 , x_msg_count out nocopy NUMBER
1029 , x_msg_data out nocopy VARCHAR2
1030 , p5_a0 JTF_NUMBER_TABLE
1031 , p5_a1 JTF_NUMBER_TABLE
1032 , p5_a2 JTF_VARCHAR2_TABLE_200
1033 , p5_a3 JTF_VARCHAR2_TABLE_2000
1034 , p5_a4 JTF_DATE_TABLE
1035 , p5_a5 JTF_DATE_TABLE
1036 , p5_a6 JTF_VARCHAR2_TABLE_100
1037 , p5_a7 JTF_VARCHAR2_TABLE_500
1038 , p5_a8 JTF_VARCHAR2_TABLE_500
1039 , p5_a9 JTF_VARCHAR2_TABLE_500
1040 , p5_a10 JTF_VARCHAR2_TABLE_500
1041 , p5_a11 JTF_VARCHAR2_TABLE_500
1042 , p5_a12 JTF_VARCHAR2_TABLE_500
1043 , p5_a13 JTF_VARCHAR2_TABLE_500
1044 , p5_a14 JTF_VARCHAR2_TABLE_500
1045 , p5_a15 JTF_VARCHAR2_TABLE_500
1046 , p5_a16 JTF_VARCHAR2_TABLE_500
1047 , p5_a17 JTF_VARCHAR2_TABLE_500
1048 , p5_a18 JTF_VARCHAR2_TABLE_500
1049 , p5_a19 JTF_VARCHAR2_TABLE_500
1050 , p5_a20 JTF_VARCHAR2_TABLE_500
1051 , p5_a21 JTF_VARCHAR2_TABLE_500
1052 , p5_a22 JTF_NUMBER_TABLE
1053 , p5_a23 JTF_DATE_TABLE
1054 , p5_a24 JTF_NUMBER_TABLE
1055 , p5_a25 JTF_DATE_TABLE
1056 , p5_a26 JTF_NUMBER_TABLE
1057 , p6_a0 out nocopy JTF_NUMBER_TABLE
1058 , p6_a1 out nocopy JTF_NUMBER_TABLE
1059 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
1060 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
1061 , p6_a4 out nocopy JTF_DATE_TABLE
1062 , p6_a5 out nocopy JTF_DATE_TABLE
1063 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1064 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
1065 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
1066 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
1067 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
1068 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
1069 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
1070 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
1071 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
1072 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
1073 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
1074 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
1075 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
1076 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
1077 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
1078 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1079 , p6_a22 out nocopy JTF_NUMBER_TABLE
1080 , p6_a23 out nocopy JTF_DATE_TABLE
1081 , p6_a24 out nocopy JTF_NUMBER_TABLE
1082 , p6_a25 out nocopy JTF_DATE_TABLE
1083 , p6_a26 out nocopy JTF_NUMBER_TABLE
1084 )
1085
1086 as
1087 ddp_optv_tbl okl_options_pub.optv_tbl_type;
1088 ddx_optv_tbl okl_options_pub.optv_tbl_type;
1089 ddindx binary_integer; indx binary_integer;
1090 begin
1091
1092 -- copy data to the local IN or IN-OUT args, if any
1093
1094
1095
1096
1097
1098 okl_opt_pvt_w.rosetta_table_copy_in_p5(ddp_optv_tbl, p5_a0
1099 , p5_a1
1100 , p5_a2
1101 , p5_a3
1102 , p5_a4
1103 , p5_a5
1104 , p5_a6
1105 , p5_a7
1106 , p5_a8
1107 , p5_a9
1108 , p5_a10
1109 , p5_a11
1110 , p5_a12
1111 , p5_a13
1112 , p5_a14
1113 , p5_a15
1114 , p5_a16
1115 , p5_a17
1116 , p5_a18
1117 , p5_a19
1118 , p5_a20
1119 , p5_a21
1120 , p5_a22
1121 , p5_a23
1122 , p5_a24
1123 , p5_a25
1124 , p5_a26
1125 );
1126
1127
1128 -- here's the delegated call to the old PL/SQL routine
1129 okl_options_pub.update_options(p_api_version,
1130 p_init_msg_list,
1131 x_return_status,
1132 x_msg_count,
1133 x_msg_data,
1134 ddp_optv_tbl,
1135 ddx_optv_tbl);
1136
1137 -- copy data back from the local variables to OUT or IN-OUT args, if any
1138
1139
1140
1141
1142
1143
1144 okl_opt_pvt_w.rosetta_table_copy_out_p5(ddx_optv_tbl, p6_a0
1145 , p6_a1
1146 , p6_a2
1147 , p6_a3
1148 , p6_a4
1149 , p6_a5
1150 , p6_a6
1151 , p6_a7
1152 , p6_a8
1153 , p6_a9
1154 , p6_a10
1155 , p6_a11
1156 , p6_a12
1157 , p6_a13
1158 , p6_a14
1159 , p6_a15
1160 , p6_a16
1161 , p6_a17
1162 , p6_a18
1163 , p6_a19
1164 , p6_a20
1165 , p6_a21
1166 , p6_a22
1167 , p6_a23
1168 , p6_a24
1169 , p6_a25
1170 , p6_a26
1171 );
1172 end;
1173
1174 procedure update_options(p_api_version NUMBER
1175 , p_init_msg_list VARCHAR2
1176 , x_return_status out nocopy VARCHAR2
1177 , x_msg_count out nocopy NUMBER
1178 , x_msg_data out nocopy VARCHAR2
1179 , p6_a0 out nocopy NUMBER
1180 , p6_a1 out nocopy NUMBER
1181 , p6_a2 out nocopy VARCHAR2
1182 , p6_a3 out nocopy VARCHAR2
1183 , p6_a4 out nocopy DATE
1184 , p6_a5 out nocopy DATE
1185 , p6_a6 out nocopy VARCHAR2
1186 , p6_a7 out nocopy VARCHAR2
1187 , p6_a8 out nocopy VARCHAR2
1188 , p6_a9 out nocopy VARCHAR2
1189 , p6_a10 out nocopy VARCHAR2
1190 , p6_a11 out nocopy VARCHAR2
1191 , p6_a12 out nocopy VARCHAR2
1192 , p6_a13 out nocopy VARCHAR2
1193 , p6_a14 out nocopy VARCHAR2
1194 , p6_a15 out nocopy VARCHAR2
1195 , p6_a16 out nocopy VARCHAR2
1196 , p6_a17 out nocopy VARCHAR2
1197 , p6_a18 out nocopy VARCHAR2
1198 , p6_a19 out nocopy VARCHAR2
1199 , p6_a20 out nocopy VARCHAR2
1200 , p6_a21 out nocopy VARCHAR2
1201 , p6_a22 out nocopy NUMBER
1202 , p6_a23 out nocopy DATE
1203 , p6_a24 out nocopy NUMBER
1204 , p6_a25 out nocopy DATE
1205 , p6_a26 out nocopy NUMBER
1206 , p5_a0 NUMBER := 0-1962.0724
1207 , p5_a1 NUMBER := 0-1962.0724
1208 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1209 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1210 , p5_a4 DATE := fnd_api.g_miss_date
1211 , p5_a5 DATE := fnd_api.g_miss_date
1212 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1213 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1214 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1215 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1216 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1217 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1218 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1219 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1220 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1221 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1222 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1223 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1224 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1225 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1226 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1227 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1228 , p5_a22 NUMBER := 0-1962.0724
1229 , p5_a23 DATE := fnd_api.g_miss_date
1230 , p5_a24 NUMBER := 0-1962.0724
1231 , p5_a25 DATE := fnd_api.g_miss_date
1232 , p5_a26 NUMBER := 0-1962.0724
1233 )
1234
1235 as
1236 ddp_optv_rec okl_options_pub.optv_rec_type;
1237 ddx_optv_rec okl_options_pub.optv_rec_type;
1238 ddindx binary_integer; indx binary_integer;
1239 begin
1240
1241 -- copy data to the local IN or IN-OUT args, if any
1242
1243
1244
1245
1246
1247 ddp_optv_rec.id := rosetta_g_miss_num_map(p5_a0);
1248 ddp_optv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1249 ddp_optv_rec.name := p5_a2;
1250 ddp_optv_rec.description := p5_a3;
1251 ddp_optv_rec.from_date := rosetta_g_miss_date_in_map(p5_a4);
1252 ddp_optv_rec.to_date := rosetta_g_miss_date_in_map(p5_a5);
1253 ddp_optv_rec.attribute_category := p5_a6;
1254 ddp_optv_rec.attribute1 := p5_a7;
1255 ddp_optv_rec.attribute2 := p5_a8;
1256 ddp_optv_rec.attribute3 := p5_a9;
1257 ddp_optv_rec.attribute4 := p5_a10;
1258 ddp_optv_rec.attribute5 := p5_a11;
1259 ddp_optv_rec.attribute6 := p5_a12;
1260 ddp_optv_rec.attribute7 := p5_a13;
1261 ddp_optv_rec.attribute8 := p5_a14;
1262 ddp_optv_rec.attribute9 := p5_a15;
1263 ddp_optv_rec.attribute10 := p5_a16;
1264 ddp_optv_rec.attribute11 := p5_a17;
1265 ddp_optv_rec.attribute12 := p5_a18;
1266 ddp_optv_rec.attribute13 := p5_a19;
1267 ddp_optv_rec.attribute14 := p5_a20;
1268 ddp_optv_rec.attribute15 := p5_a21;
1269 ddp_optv_rec.created_by := rosetta_g_miss_num_map(p5_a22);
1270 ddp_optv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a23);
1271 ddp_optv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a24);
1272 ddp_optv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a25);
1273 ddp_optv_rec.last_update_login := rosetta_g_miss_num_map(p5_a26);
1274
1275
1276 -- here's the delegated call to the old PL/SQL routine
1277 okl_options_pub.update_options(p_api_version,
1278 p_init_msg_list,
1279 x_return_status,
1280 x_msg_count,
1281 x_msg_data,
1282 ddp_optv_rec,
1283 ddx_optv_rec);
1284
1285 -- copy data back from the local variables to OUT or IN-OUT args, if any
1286
1287
1288
1289
1290
1291
1292 p6_a0 := rosetta_g_miss_num_map(ddx_optv_rec.id);
1293 p6_a1 := rosetta_g_miss_num_map(ddx_optv_rec.object_version_number);
1294 p6_a2 := ddx_optv_rec.name;
1295 p6_a3 := ddx_optv_rec.description;
1296 p6_a4 := ddx_optv_rec.from_date;
1297 p6_a5 := ddx_optv_rec.to_date;
1298 p6_a6 := ddx_optv_rec.attribute_category;
1299 p6_a7 := ddx_optv_rec.attribute1;
1300 p6_a8 := ddx_optv_rec.attribute2;
1301 p6_a9 := ddx_optv_rec.attribute3;
1302 p6_a10 := ddx_optv_rec.attribute4;
1303 p6_a11 := ddx_optv_rec.attribute5;
1304 p6_a12 := ddx_optv_rec.attribute6;
1305 p6_a13 := ddx_optv_rec.attribute7;
1306 p6_a14 := ddx_optv_rec.attribute8;
1307 p6_a15 := ddx_optv_rec.attribute9;
1308 p6_a16 := ddx_optv_rec.attribute10;
1309 p6_a17 := ddx_optv_rec.attribute11;
1310 p6_a18 := ddx_optv_rec.attribute12;
1311 p6_a19 := ddx_optv_rec.attribute13;
1312 p6_a20 := ddx_optv_rec.attribute14;
1313 p6_a21 := ddx_optv_rec.attribute15;
1314 p6_a22 := rosetta_g_miss_num_map(ddx_optv_rec.created_by);
1315 p6_a23 := ddx_optv_rec.creation_date;
1316 p6_a24 := rosetta_g_miss_num_map(ddx_optv_rec.last_updated_by);
1317 p6_a25 := ddx_optv_rec.last_update_date;
1318 p6_a26 := rosetta_g_miss_num_map(ddx_optv_rec.last_update_login);
1319 end;
1320
1321 procedure delete_options(p_api_version NUMBER
1322 , p_init_msg_list VARCHAR2
1323 , x_return_status out nocopy VARCHAR2
1324 , x_msg_count out nocopy NUMBER
1325 , x_msg_data out nocopy VARCHAR2
1326 , p5_a0 JTF_NUMBER_TABLE
1327 , p5_a1 JTF_NUMBER_TABLE
1328 , p5_a2 JTF_VARCHAR2_TABLE_200
1329 , p5_a3 JTF_VARCHAR2_TABLE_2000
1330 , p5_a4 JTF_DATE_TABLE
1331 , p5_a5 JTF_DATE_TABLE
1332 , p5_a6 JTF_VARCHAR2_TABLE_100
1333 , p5_a7 JTF_VARCHAR2_TABLE_500
1334 , p5_a8 JTF_VARCHAR2_TABLE_500
1335 , p5_a9 JTF_VARCHAR2_TABLE_500
1336 , p5_a10 JTF_VARCHAR2_TABLE_500
1337 , p5_a11 JTF_VARCHAR2_TABLE_500
1338 , p5_a12 JTF_VARCHAR2_TABLE_500
1339 , p5_a13 JTF_VARCHAR2_TABLE_500
1340 , p5_a14 JTF_VARCHAR2_TABLE_500
1341 , p5_a15 JTF_VARCHAR2_TABLE_500
1342 , p5_a16 JTF_VARCHAR2_TABLE_500
1343 , p5_a17 JTF_VARCHAR2_TABLE_500
1344 , p5_a18 JTF_VARCHAR2_TABLE_500
1345 , p5_a19 JTF_VARCHAR2_TABLE_500
1346 , p5_a20 JTF_VARCHAR2_TABLE_500
1347 , p5_a21 JTF_VARCHAR2_TABLE_500
1348 , p5_a22 JTF_NUMBER_TABLE
1349 , p5_a23 JTF_DATE_TABLE
1350 , p5_a24 JTF_NUMBER_TABLE
1351 , p5_a25 JTF_DATE_TABLE
1352 , p5_a26 JTF_NUMBER_TABLE
1353 )
1354
1355 as
1356 ddp_optv_tbl okl_options_pub.optv_tbl_type;
1357 ddindx binary_integer; indx binary_integer;
1358 begin
1359
1360 -- copy data to the local IN or IN-OUT args, if any
1361
1362
1363
1364
1365
1366 okl_opt_pvt_w.rosetta_table_copy_in_p5(ddp_optv_tbl, p5_a0
1367 , p5_a1
1368 , p5_a2
1369 , p5_a3
1370 , p5_a4
1371 , p5_a5
1372 , p5_a6
1373 , p5_a7
1374 , p5_a8
1375 , p5_a9
1376 , p5_a10
1377 , p5_a11
1378 , p5_a12
1379 , p5_a13
1380 , p5_a14
1381 , p5_a15
1382 , p5_a16
1383 , p5_a17
1384 , p5_a18
1385 , p5_a19
1386 , p5_a20
1387 , p5_a21
1388 , p5_a22
1389 , p5_a23
1390 , p5_a24
1391 , p5_a25
1392 , p5_a26
1393 );
1394
1395 -- here's the delegated call to the old PL/SQL routine
1396 okl_options_pub.delete_options(p_api_version,
1397 p_init_msg_list,
1398 x_return_status,
1399 x_msg_count,
1400 x_msg_data,
1401 ddp_optv_tbl);
1402
1403 -- copy data back from the local variables to OUT or IN-OUT args, if any
1404
1405
1406
1407
1408
1409 end;
1410
1411 procedure delete_options(p_api_version NUMBER
1412 , p_init_msg_list VARCHAR2
1413 , x_return_status out nocopy VARCHAR2
1414 , x_msg_count out nocopy NUMBER
1415 , x_msg_data out nocopy VARCHAR2
1416 , p5_a0 NUMBER := 0-1962.0724
1417 , p5_a1 NUMBER := 0-1962.0724
1418 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1419 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1420 , p5_a4 DATE := fnd_api.g_miss_date
1421 , p5_a5 DATE := fnd_api.g_miss_date
1422 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1423 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1424 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1425 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1426 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1427 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1428 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1429 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1430 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1431 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1432 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1433 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1434 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1435 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1436 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1437 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1438 , p5_a22 NUMBER := 0-1962.0724
1439 , p5_a23 DATE := fnd_api.g_miss_date
1440 , p5_a24 NUMBER := 0-1962.0724
1441 , p5_a25 DATE := fnd_api.g_miss_date
1442 , p5_a26 NUMBER := 0-1962.0724
1443 )
1444
1445 as
1446 ddp_optv_rec okl_options_pub.optv_rec_type;
1447 ddindx binary_integer; indx binary_integer;
1448 begin
1449
1450 -- copy data to the local IN or IN-OUT args, if any
1451
1452
1453
1454
1455
1456 ddp_optv_rec.id := rosetta_g_miss_num_map(p5_a0);
1457 ddp_optv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1458 ddp_optv_rec.name := p5_a2;
1459 ddp_optv_rec.description := p5_a3;
1460 ddp_optv_rec.from_date := rosetta_g_miss_date_in_map(p5_a4);
1461 ddp_optv_rec.to_date := rosetta_g_miss_date_in_map(p5_a5);
1462 ddp_optv_rec.attribute_category := p5_a6;
1463 ddp_optv_rec.attribute1 := p5_a7;
1464 ddp_optv_rec.attribute2 := p5_a8;
1465 ddp_optv_rec.attribute3 := p5_a9;
1466 ddp_optv_rec.attribute4 := p5_a10;
1467 ddp_optv_rec.attribute5 := p5_a11;
1468 ddp_optv_rec.attribute6 := p5_a12;
1469 ddp_optv_rec.attribute7 := p5_a13;
1470 ddp_optv_rec.attribute8 := p5_a14;
1471 ddp_optv_rec.attribute9 := p5_a15;
1472 ddp_optv_rec.attribute10 := p5_a16;
1473 ddp_optv_rec.attribute11 := p5_a17;
1474 ddp_optv_rec.attribute12 := p5_a18;
1475 ddp_optv_rec.attribute13 := p5_a19;
1476 ddp_optv_rec.attribute14 := p5_a20;
1477 ddp_optv_rec.attribute15 := p5_a21;
1478 ddp_optv_rec.created_by := rosetta_g_miss_num_map(p5_a22);
1479 ddp_optv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a23);
1480 ddp_optv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a24);
1481 ddp_optv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a25);
1482 ddp_optv_rec.last_update_login := rosetta_g_miss_num_map(p5_a26);
1483
1484 -- here's the delegated call to the old PL/SQL routine
1485 okl_options_pub.delete_options(p_api_version,
1486 p_init_msg_list,
1487 x_return_status,
1488 x_msg_count,
1489 x_msg_data,
1490 ddp_optv_rec);
1491
1492 -- copy data back from the local variables to OUT or IN-OUT args, if any
1493
1494
1495
1496
1497
1498 end;
1499
1500 procedure validate_options(p_api_version NUMBER
1501 , p_init_msg_list VARCHAR2
1502 , x_return_status out nocopy VARCHAR2
1503 , x_msg_count out nocopy NUMBER
1504 , x_msg_data out nocopy VARCHAR2
1505 , p5_a0 JTF_NUMBER_TABLE
1506 , p5_a1 JTF_NUMBER_TABLE
1507 , p5_a2 JTF_VARCHAR2_TABLE_200
1508 , p5_a3 JTF_VARCHAR2_TABLE_2000
1509 , p5_a4 JTF_DATE_TABLE
1510 , p5_a5 JTF_DATE_TABLE
1511 , p5_a6 JTF_VARCHAR2_TABLE_100
1512 , p5_a7 JTF_VARCHAR2_TABLE_500
1513 , p5_a8 JTF_VARCHAR2_TABLE_500
1514 , p5_a9 JTF_VARCHAR2_TABLE_500
1515 , p5_a10 JTF_VARCHAR2_TABLE_500
1516 , p5_a11 JTF_VARCHAR2_TABLE_500
1517 , p5_a12 JTF_VARCHAR2_TABLE_500
1518 , p5_a13 JTF_VARCHAR2_TABLE_500
1519 , p5_a14 JTF_VARCHAR2_TABLE_500
1520 , p5_a15 JTF_VARCHAR2_TABLE_500
1521 , p5_a16 JTF_VARCHAR2_TABLE_500
1522 , p5_a17 JTF_VARCHAR2_TABLE_500
1523 , p5_a18 JTF_VARCHAR2_TABLE_500
1524 , p5_a19 JTF_VARCHAR2_TABLE_500
1525 , p5_a20 JTF_VARCHAR2_TABLE_500
1526 , p5_a21 JTF_VARCHAR2_TABLE_500
1527 , p5_a22 JTF_NUMBER_TABLE
1528 , p5_a23 JTF_DATE_TABLE
1529 , p5_a24 JTF_NUMBER_TABLE
1530 , p5_a25 JTF_DATE_TABLE
1531 , p5_a26 JTF_NUMBER_TABLE
1532 )
1533
1534 as
1535 ddp_optv_tbl okl_options_pub.optv_tbl_type;
1536 ddindx binary_integer; indx binary_integer;
1537 begin
1538
1539 -- copy data to the local IN or IN-OUT args, if any
1540
1541
1542
1543
1544
1545 okl_opt_pvt_w.rosetta_table_copy_in_p5(ddp_optv_tbl, p5_a0
1546 , p5_a1
1547 , p5_a2
1548 , p5_a3
1549 , p5_a4
1550 , p5_a5
1551 , p5_a6
1552 , p5_a7
1553 , p5_a8
1554 , p5_a9
1555 , p5_a10
1556 , p5_a11
1557 , p5_a12
1558 , p5_a13
1559 , p5_a14
1560 , p5_a15
1561 , p5_a16
1562 , p5_a17
1563 , p5_a18
1564 , p5_a19
1565 , p5_a20
1566 , p5_a21
1567 , p5_a22
1568 , p5_a23
1569 , p5_a24
1570 , p5_a25
1571 , p5_a26
1572 );
1573
1574 -- here's the delegated call to the old PL/SQL routine
1575 okl_options_pub.validate_options(p_api_version,
1576 p_init_msg_list,
1577 x_return_status,
1578 x_msg_count,
1579 x_msg_data,
1580 ddp_optv_tbl);
1581
1582 -- copy data back from the local variables to OUT or IN-OUT args, if any
1583
1584
1585
1586
1587
1588 end;
1589
1590 procedure validate_options(p_api_version NUMBER
1591 , p_init_msg_list VARCHAR2
1592 , x_return_status out nocopy VARCHAR2
1593 , x_msg_count out nocopy NUMBER
1594 , x_msg_data out nocopy VARCHAR2
1595 , p5_a0 NUMBER := 0-1962.0724
1596 , p5_a1 NUMBER := 0-1962.0724
1597 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1598 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1599 , p5_a4 DATE := fnd_api.g_miss_date
1600 , p5_a5 DATE := fnd_api.g_miss_date
1601 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1602 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1603 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1604 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1605 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1606 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1607 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1608 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1609 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1610 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1611 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1612 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1613 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1614 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1615 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1616 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1617 , p5_a22 NUMBER := 0-1962.0724
1618 , p5_a23 DATE := fnd_api.g_miss_date
1619 , p5_a24 NUMBER := 0-1962.0724
1620 , p5_a25 DATE := fnd_api.g_miss_date
1621 , p5_a26 NUMBER := 0-1962.0724
1622 )
1623
1624 as
1625 ddp_optv_rec okl_options_pub.optv_rec_type;
1626 ddindx binary_integer; indx binary_integer;
1627 begin
1628
1629 -- copy data to the local IN or IN-OUT args, if any
1630
1631
1632
1633
1634
1635 ddp_optv_rec.id := rosetta_g_miss_num_map(p5_a0);
1636 ddp_optv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1637 ddp_optv_rec.name := p5_a2;
1638 ddp_optv_rec.description := p5_a3;
1639 ddp_optv_rec.from_date := rosetta_g_miss_date_in_map(p5_a4);
1640 ddp_optv_rec.to_date := rosetta_g_miss_date_in_map(p5_a5);
1641 ddp_optv_rec.attribute_category := p5_a6;
1642 ddp_optv_rec.attribute1 := p5_a7;
1643 ddp_optv_rec.attribute2 := p5_a8;
1644 ddp_optv_rec.attribute3 := p5_a9;
1645 ddp_optv_rec.attribute4 := p5_a10;
1646 ddp_optv_rec.attribute5 := p5_a11;
1647 ddp_optv_rec.attribute6 := p5_a12;
1648 ddp_optv_rec.attribute7 := p5_a13;
1649 ddp_optv_rec.attribute8 := p5_a14;
1650 ddp_optv_rec.attribute9 := p5_a15;
1651 ddp_optv_rec.attribute10 := p5_a16;
1652 ddp_optv_rec.attribute11 := p5_a17;
1653 ddp_optv_rec.attribute12 := p5_a18;
1654 ddp_optv_rec.attribute13 := p5_a19;
1655 ddp_optv_rec.attribute14 := p5_a20;
1656 ddp_optv_rec.attribute15 := p5_a21;
1657 ddp_optv_rec.created_by := rosetta_g_miss_num_map(p5_a22);
1658 ddp_optv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a23);
1659 ddp_optv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a24);
1660 ddp_optv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a25);
1661 ddp_optv_rec.last_update_login := rosetta_g_miss_num_map(p5_a26);
1662
1663 -- here's the delegated call to the old PL/SQL routine
1664 okl_options_pub.validate_options(p_api_version,
1665 p_init_msg_list,
1666 x_return_status,
1667 x_msg_count,
1668 x_msg_data,
1669 ddp_optv_rec);
1670
1671 -- copy data back from the local variables to OUT or IN-OUT args, if any
1672
1673
1674
1675
1676
1677 end;
1678
1679 procedure create_option_values(p_api_version NUMBER
1680 , p_init_msg_list VARCHAR2
1681 , x_return_status out nocopy VARCHAR2
1682 , x_msg_count out nocopy NUMBER
1683 , x_msg_data out nocopy VARCHAR2
1684 , p5_a0 JTF_NUMBER_TABLE
1685 , p5_a1 JTF_NUMBER_TABLE
1686 , p5_a2 JTF_NUMBER_TABLE
1687 , p5_a3 JTF_VARCHAR2_TABLE_200
1688 , p5_a4 JTF_VARCHAR2_TABLE_2000
1689 , p5_a5 JTF_DATE_TABLE
1690 , p5_a6 JTF_DATE_TABLE
1691 , p5_a7 JTF_NUMBER_TABLE
1692 , p5_a8 JTF_DATE_TABLE
1693 , p5_a9 JTF_NUMBER_TABLE
1694 , p5_a10 JTF_DATE_TABLE
1695 , p5_a11 JTF_NUMBER_TABLE
1696 , p6_a0 out nocopy JTF_NUMBER_TABLE
1697 , p6_a1 out nocopy JTF_NUMBER_TABLE
1698 , p6_a2 out nocopy JTF_NUMBER_TABLE
1699 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
1700 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
1701 , p6_a5 out nocopy JTF_DATE_TABLE
1702 , p6_a6 out nocopy JTF_DATE_TABLE
1703 , p6_a7 out nocopy JTF_NUMBER_TABLE
1704 , p6_a8 out nocopy JTF_DATE_TABLE
1705 , p6_a9 out nocopy JTF_NUMBER_TABLE
1706 , p6_a10 out nocopy JTF_DATE_TABLE
1707 , p6_a11 out nocopy JTF_NUMBER_TABLE
1708 )
1709
1710 as
1711 ddp_ovev_tbl okl_options_pub.ovev_tbl_type;
1712 ddx_ovev_tbl okl_options_pub.ovev_tbl_type;
1713 ddindx binary_integer; indx binary_integer;
1714 begin
1715
1716 -- copy data to the local IN or IN-OUT args, if any
1717
1718
1719
1720
1721
1722 okl_ove_pvt_w.rosetta_table_copy_in_p5(ddp_ovev_tbl, p5_a0
1723 , p5_a1
1724 , p5_a2
1725 , p5_a3
1726 , p5_a4
1727 , p5_a5
1728 , p5_a6
1729 , p5_a7
1730 , p5_a8
1731 , p5_a9
1732 , p5_a10
1733 , p5_a11
1734 );
1735
1736
1737 -- here's the delegated call to the old PL/SQL routine
1738 okl_options_pub.create_option_values(p_api_version,
1739 p_init_msg_list,
1740 x_return_status,
1741 x_msg_count,
1742 x_msg_data,
1743 ddp_ovev_tbl,
1744 ddx_ovev_tbl);
1745
1746 -- copy data back from the local variables to OUT or IN-OUT args, if any
1747
1748
1749
1750
1751
1752
1753 okl_ove_pvt_w.rosetta_table_copy_out_p5(ddx_ovev_tbl, p6_a0
1754 , p6_a1
1755 , p6_a2
1756 , p6_a3
1757 , p6_a4
1758 , p6_a5
1759 , p6_a6
1760 , p6_a7
1761 , p6_a8
1762 , p6_a9
1763 , p6_a10
1764 , p6_a11
1765 );
1766 end;
1767
1768 procedure create_option_values(p_api_version NUMBER
1769 , p_init_msg_list VARCHAR2
1770 , x_return_status out nocopy VARCHAR2
1771 , x_msg_count out nocopy NUMBER
1772 , x_msg_data out nocopy VARCHAR2
1773 , p6_a0 out nocopy NUMBER
1774 , p6_a1 out nocopy NUMBER
1775 , p6_a2 out nocopy NUMBER
1776 , p6_a3 out nocopy VARCHAR2
1777 , p6_a4 out nocopy VARCHAR2
1778 , p6_a5 out nocopy DATE
1779 , p6_a6 out nocopy DATE
1780 , p6_a7 out nocopy NUMBER
1781 , p6_a8 out nocopy DATE
1782 , p6_a9 out nocopy NUMBER
1783 , p6_a10 out nocopy DATE
1784 , p6_a11 out nocopy NUMBER
1785 , p5_a0 NUMBER := 0-1962.0724
1786 , p5_a1 NUMBER := 0-1962.0724
1787 , p5_a2 NUMBER := 0-1962.0724
1788 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1789 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1790 , p5_a5 DATE := fnd_api.g_miss_date
1791 , p5_a6 DATE := fnd_api.g_miss_date
1792 , p5_a7 NUMBER := 0-1962.0724
1793 , p5_a8 DATE := fnd_api.g_miss_date
1794 , p5_a9 NUMBER := 0-1962.0724
1795 , p5_a10 DATE := fnd_api.g_miss_date
1796 , p5_a11 NUMBER := 0-1962.0724
1797 )
1798
1799 as
1800 ddp_ovev_rec okl_options_pub.ovev_rec_type;
1801 ddx_ovev_rec okl_options_pub.ovev_rec_type;
1802 ddindx binary_integer; indx binary_integer;
1803 begin
1804
1805 -- copy data to the local IN or IN-OUT args, if any
1806
1807
1808
1809
1810
1811 ddp_ovev_rec.id := rosetta_g_miss_num_map(p5_a0);
1812 ddp_ovev_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1813 ddp_ovev_rec.opt_id := rosetta_g_miss_num_map(p5_a2);
1814 ddp_ovev_rec.value := p5_a3;
1815 ddp_ovev_rec.description := p5_a4;
1816 ddp_ovev_rec.from_date := rosetta_g_miss_date_in_map(p5_a5);
1817 ddp_ovev_rec.to_date := rosetta_g_miss_date_in_map(p5_a6);
1818 ddp_ovev_rec.created_by := rosetta_g_miss_num_map(p5_a7);
1819 ddp_ovev_rec.creation_date := rosetta_g_miss_date_in_map(p5_a8);
1820 ddp_ovev_rec.last_updated_by := rosetta_g_miss_num_map(p5_a9);
1821 ddp_ovev_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a10);
1822 ddp_ovev_rec.last_update_login := rosetta_g_miss_num_map(p5_a11);
1823
1824
1825 -- here's the delegated call to the old PL/SQL routine
1826 okl_options_pub.create_option_values(p_api_version,
1827 p_init_msg_list,
1828 x_return_status,
1829 x_msg_count,
1830 x_msg_data,
1831 ddp_ovev_rec,
1832 ddx_ovev_rec);
1833
1834 -- copy data back from the local variables to OUT or IN-OUT args, if any
1835
1836
1837
1838
1839
1840
1841 p6_a0 := rosetta_g_miss_num_map(ddx_ovev_rec.id);
1842 p6_a1 := rosetta_g_miss_num_map(ddx_ovev_rec.object_version_number);
1843 p6_a2 := rosetta_g_miss_num_map(ddx_ovev_rec.opt_id);
1844 p6_a3 := ddx_ovev_rec.value;
1845 p6_a4 := ddx_ovev_rec.description;
1846 p6_a5 := ddx_ovev_rec.from_date;
1847 p6_a6 := ddx_ovev_rec.to_date;
1848 p6_a7 := rosetta_g_miss_num_map(ddx_ovev_rec.created_by);
1849 p6_a8 := ddx_ovev_rec.creation_date;
1850 p6_a9 := rosetta_g_miss_num_map(ddx_ovev_rec.last_updated_by);
1851 p6_a10 := ddx_ovev_rec.last_update_date;
1852 p6_a11 := rosetta_g_miss_num_map(ddx_ovev_rec.last_update_login);
1853 end;
1854
1855 procedure lock_option_values(p_api_version NUMBER
1856 , p_init_msg_list VARCHAR2
1857 , x_return_status out nocopy VARCHAR2
1858 , x_msg_count out nocopy NUMBER
1859 , x_msg_data out nocopy VARCHAR2
1860 , p5_a0 JTF_NUMBER_TABLE
1861 , p5_a1 JTF_NUMBER_TABLE
1862 , p5_a2 JTF_NUMBER_TABLE
1863 , p5_a3 JTF_VARCHAR2_TABLE_200
1864 , p5_a4 JTF_VARCHAR2_TABLE_2000
1865 , p5_a5 JTF_DATE_TABLE
1866 , p5_a6 JTF_DATE_TABLE
1867 , p5_a7 JTF_NUMBER_TABLE
1868 , p5_a8 JTF_DATE_TABLE
1869 , p5_a9 JTF_NUMBER_TABLE
1870 , p5_a10 JTF_DATE_TABLE
1871 , p5_a11 JTF_NUMBER_TABLE
1872 )
1873
1874 as
1875 ddp_ovev_tbl okl_options_pub.ovev_tbl_type;
1876 ddindx binary_integer; indx binary_integer;
1877 begin
1878
1879 -- copy data to the local IN or IN-OUT args, if any
1880
1881
1882
1883
1884
1885 okl_ove_pvt_w.rosetta_table_copy_in_p5(ddp_ovev_tbl, p5_a0
1886 , p5_a1
1887 , p5_a2
1888 , p5_a3
1889 , p5_a4
1890 , p5_a5
1891 , p5_a6
1892 , p5_a7
1893 , p5_a8
1894 , p5_a9
1895 , p5_a10
1896 , p5_a11
1897 );
1898
1899 -- here's the delegated call to the old PL/SQL routine
1900 okl_options_pub.lock_option_values(p_api_version,
1901 p_init_msg_list,
1902 x_return_status,
1903 x_msg_count,
1904 x_msg_data,
1905 ddp_ovev_tbl);
1906
1907 -- copy data back from the local variables to OUT or IN-OUT args, if any
1908
1909
1910
1911
1912
1913 end;
1914
1915 procedure lock_option_values(p_api_version NUMBER
1916 , p_init_msg_list VARCHAR2
1917 , x_return_status out nocopy VARCHAR2
1918 , x_msg_count out nocopy NUMBER
1919 , x_msg_data out nocopy VARCHAR2
1920 , p5_a0 NUMBER := 0-1962.0724
1921 , p5_a1 NUMBER := 0-1962.0724
1922 , p5_a2 NUMBER := 0-1962.0724
1923 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1924 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1925 , p5_a5 DATE := fnd_api.g_miss_date
1926 , p5_a6 DATE := fnd_api.g_miss_date
1927 , p5_a7 NUMBER := 0-1962.0724
1928 , p5_a8 DATE := fnd_api.g_miss_date
1929 , p5_a9 NUMBER := 0-1962.0724
1930 , p5_a10 DATE := fnd_api.g_miss_date
1931 , p5_a11 NUMBER := 0-1962.0724
1932 )
1933
1934 as
1935 ddp_ovev_rec okl_options_pub.ovev_rec_type;
1936 ddindx binary_integer; indx binary_integer;
1937 begin
1938
1939 -- copy data to the local IN or IN-OUT args, if any
1940
1941
1942
1943
1944
1945 ddp_ovev_rec.id := rosetta_g_miss_num_map(p5_a0);
1946 ddp_ovev_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1947 ddp_ovev_rec.opt_id := rosetta_g_miss_num_map(p5_a2);
1948 ddp_ovev_rec.value := p5_a3;
1949 ddp_ovev_rec.description := p5_a4;
1950 ddp_ovev_rec.from_date := rosetta_g_miss_date_in_map(p5_a5);
1951 ddp_ovev_rec.to_date := rosetta_g_miss_date_in_map(p5_a6);
1952 ddp_ovev_rec.created_by := rosetta_g_miss_num_map(p5_a7);
1953 ddp_ovev_rec.creation_date := rosetta_g_miss_date_in_map(p5_a8);
1954 ddp_ovev_rec.last_updated_by := rosetta_g_miss_num_map(p5_a9);
1955 ddp_ovev_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a10);
1956 ddp_ovev_rec.last_update_login := rosetta_g_miss_num_map(p5_a11);
1957
1958 -- here's the delegated call to the old PL/SQL routine
1959 okl_options_pub.lock_option_values(p_api_version,
1960 p_init_msg_list,
1961 x_return_status,
1962 x_msg_count,
1963 x_msg_data,
1964 ddp_ovev_rec);
1965
1966 -- copy data back from the local variables to OUT or IN-OUT args, if any
1967
1968
1969
1970
1971
1972 end;
1973
1974 procedure update_option_values(p_api_version NUMBER
1975 , p_init_msg_list VARCHAR2
1976 , x_return_status out nocopy VARCHAR2
1977 , x_msg_count out nocopy NUMBER
1978 , x_msg_data out nocopy VARCHAR2
1979 , p5_a0 JTF_NUMBER_TABLE
1980 , p5_a1 JTF_NUMBER_TABLE
1981 , p5_a2 JTF_NUMBER_TABLE
1982 , p5_a3 JTF_VARCHAR2_TABLE_200
1983 , p5_a4 JTF_VARCHAR2_TABLE_2000
1984 , p5_a5 JTF_DATE_TABLE
1985 , p5_a6 JTF_DATE_TABLE
1986 , p5_a7 JTF_NUMBER_TABLE
1987 , p5_a8 JTF_DATE_TABLE
1988 , p5_a9 JTF_NUMBER_TABLE
1989 , p5_a10 JTF_DATE_TABLE
1990 , p5_a11 JTF_NUMBER_TABLE
1991 , p6_a0 out nocopy JTF_NUMBER_TABLE
1992 , p6_a1 out nocopy JTF_NUMBER_TABLE
1993 , p6_a2 out nocopy JTF_NUMBER_TABLE
1994 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
1995 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
1996 , p6_a5 out nocopy JTF_DATE_TABLE
1997 , p6_a6 out nocopy JTF_DATE_TABLE
1998 , p6_a7 out nocopy JTF_NUMBER_TABLE
1999 , p6_a8 out nocopy JTF_DATE_TABLE
2000 , p6_a9 out nocopy JTF_NUMBER_TABLE
2001 , p6_a10 out nocopy JTF_DATE_TABLE
2002 , p6_a11 out nocopy JTF_NUMBER_TABLE
2003 )
2004
2005 as
2006 ddp_ovev_tbl okl_options_pub.ovev_tbl_type;
2007 ddx_ovev_tbl okl_options_pub.ovev_tbl_type;
2008 ddindx binary_integer; indx binary_integer;
2009 begin
2010
2011 -- copy data to the local IN or IN-OUT args, if any
2012
2013
2014
2015
2016
2017 okl_ove_pvt_w.rosetta_table_copy_in_p5(ddp_ovev_tbl, p5_a0
2018 , p5_a1
2019 , p5_a2
2020 , p5_a3
2021 , p5_a4
2022 , p5_a5
2023 , p5_a6
2024 , p5_a7
2025 , p5_a8
2026 , p5_a9
2027 , p5_a10
2028 , p5_a11
2029 );
2030
2031
2032 -- here's the delegated call to the old PL/SQL routine
2033 okl_options_pub.update_option_values(p_api_version,
2034 p_init_msg_list,
2035 x_return_status,
2036 x_msg_count,
2037 x_msg_data,
2038 ddp_ovev_tbl,
2039 ddx_ovev_tbl);
2040
2041 -- copy data back from the local variables to OUT or IN-OUT args, if any
2042
2043
2044
2045
2046
2047
2048 okl_ove_pvt_w.rosetta_table_copy_out_p5(ddx_ovev_tbl, p6_a0
2049 , p6_a1
2050 , p6_a2
2051 , p6_a3
2052 , p6_a4
2053 , p6_a5
2054 , p6_a6
2055 , p6_a7
2056 , p6_a8
2057 , p6_a9
2058 , p6_a10
2059 , p6_a11
2060 );
2061 end;
2062
2063 procedure update_option_values(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 VARCHAR2
2072 , p6_a4 out nocopy VARCHAR2
2073 , p6_a5 out nocopy DATE
2074 , p6_a6 out nocopy DATE
2075 , p6_a7 out nocopy NUMBER
2076 , p6_a8 out nocopy DATE
2077 , p6_a9 out nocopy NUMBER
2078 , p6_a10 out nocopy DATE
2079 , p6_a11 out nocopy NUMBER
2080 , p5_a0 NUMBER := 0-1962.0724
2081 , p5_a1 NUMBER := 0-1962.0724
2082 , p5_a2 NUMBER := 0-1962.0724
2083 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2084 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2085 , p5_a5 DATE := fnd_api.g_miss_date
2086 , p5_a6 DATE := fnd_api.g_miss_date
2087 , p5_a7 NUMBER := 0-1962.0724
2088 , p5_a8 DATE := fnd_api.g_miss_date
2089 , p5_a9 NUMBER := 0-1962.0724
2090 , p5_a10 DATE := fnd_api.g_miss_date
2091 , p5_a11 NUMBER := 0-1962.0724
2092 )
2093
2094 as
2095 ddp_ovev_rec okl_options_pub.ovev_rec_type;
2096 ddx_ovev_rec okl_options_pub.ovev_rec_type;
2097 ddindx binary_integer; indx binary_integer;
2098 begin
2099
2100 -- copy data to the local IN or IN-OUT args, if any
2101
2102
2103
2104
2105
2106 ddp_ovev_rec.id := rosetta_g_miss_num_map(p5_a0);
2107 ddp_ovev_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
2108 ddp_ovev_rec.opt_id := rosetta_g_miss_num_map(p5_a2);
2109 ddp_ovev_rec.value := p5_a3;
2110 ddp_ovev_rec.description := p5_a4;
2111 ddp_ovev_rec.from_date := rosetta_g_miss_date_in_map(p5_a5);
2112 ddp_ovev_rec.to_date := rosetta_g_miss_date_in_map(p5_a6);
2113 ddp_ovev_rec.created_by := rosetta_g_miss_num_map(p5_a7);
2114 ddp_ovev_rec.creation_date := rosetta_g_miss_date_in_map(p5_a8);
2115 ddp_ovev_rec.last_updated_by := rosetta_g_miss_num_map(p5_a9);
2116 ddp_ovev_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a10);
2117 ddp_ovev_rec.last_update_login := rosetta_g_miss_num_map(p5_a11);
2118
2119
2120 -- here's the delegated call to the old PL/SQL routine
2121 okl_options_pub.update_option_values(p_api_version,
2122 p_init_msg_list,
2123 x_return_status,
2124 x_msg_count,
2125 x_msg_data,
2126 ddp_ovev_rec,
2127 ddx_ovev_rec);
2128
2129 -- copy data back from the local variables to OUT or IN-OUT args, if any
2130
2131
2132
2133
2134
2135
2136 p6_a0 := rosetta_g_miss_num_map(ddx_ovev_rec.id);
2137 p6_a1 := rosetta_g_miss_num_map(ddx_ovev_rec.object_version_number);
2138 p6_a2 := rosetta_g_miss_num_map(ddx_ovev_rec.opt_id);
2139 p6_a3 := ddx_ovev_rec.value;
2140 p6_a4 := ddx_ovev_rec.description;
2141 p6_a5 := ddx_ovev_rec.from_date;
2142 p6_a6 := ddx_ovev_rec.to_date;
2143 p6_a7 := rosetta_g_miss_num_map(ddx_ovev_rec.created_by);
2144 p6_a8 := ddx_ovev_rec.creation_date;
2145 p6_a9 := rosetta_g_miss_num_map(ddx_ovev_rec.last_updated_by);
2146 p6_a10 := ddx_ovev_rec.last_update_date;
2147 p6_a11 := rosetta_g_miss_num_map(ddx_ovev_rec.last_update_login);
2148 end;
2149
2150 procedure delete_option_values(p_api_version NUMBER
2151 , p_init_msg_list VARCHAR2
2152 , x_return_status out nocopy VARCHAR2
2153 , x_msg_count out nocopy NUMBER
2154 , x_msg_data out nocopy VARCHAR2
2155 , p5_a0 JTF_NUMBER_TABLE
2156 , p5_a1 JTF_NUMBER_TABLE
2157 , p5_a2 JTF_NUMBER_TABLE
2158 , p5_a3 JTF_VARCHAR2_TABLE_200
2159 , p5_a4 JTF_VARCHAR2_TABLE_2000
2160 , p5_a5 JTF_DATE_TABLE
2161 , p5_a6 JTF_DATE_TABLE
2162 , p5_a7 JTF_NUMBER_TABLE
2163 , p5_a8 JTF_DATE_TABLE
2164 , p5_a9 JTF_NUMBER_TABLE
2165 , p5_a10 JTF_DATE_TABLE
2166 , p5_a11 JTF_NUMBER_TABLE
2167 )
2168
2169 as
2170 ddp_ovev_tbl okl_options_pub.ovev_tbl_type;
2171 ddindx binary_integer; indx binary_integer;
2172 begin
2173
2174 -- copy data to the local IN or IN-OUT args, if any
2175
2176
2177
2178
2179
2180 okl_ove_pvt_w.rosetta_table_copy_in_p5(ddp_ovev_tbl, p5_a0
2181 , p5_a1
2182 , p5_a2
2183 , p5_a3
2184 , p5_a4
2185 , p5_a5
2186 , p5_a6
2187 , p5_a7
2188 , p5_a8
2189 , p5_a9
2190 , p5_a10
2191 , p5_a11
2192 );
2193
2194 -- here's the delegated call to the old PL/SQL routine
2195 okl_options_pub.delete_option_values(p_api_version,
2196 p_init_msg_list,
2197 x_return_status,
2198 x_msg_count,
2199 x_msg_data,
2200 ddp_ovev_tbl);
2201
2202 -- copy data back from the local variables to OUT or IN-OUT args, if any
2203
2204
2205
2206
2207
2208 end;
2209
2210 procedure delete_option_values(p_api_version NUMBER
2211 , p_init_msg_list VARCHAR2
2212 , x_return_status out nocopy VARCHAR2
2213 , x_msg_count out nocopy NUMBER
2214 , x_msg_data out nocopy VARCHAR2
2215 , p5_a0 NUMBER := 0-1962.0724
2216 , p5_a1 NUMBER := 0-1962.0724
2217 , p5_a2 NUMBER := 0-1962.0724
2218 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2219 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2220 , p5_a5 DATE := fnd_api.g_miss_date
2221 , p5_a6 DATE := fnd_api.g_miss_date
2222 , p5_a7 NUMBER := 0-1962.0724
2223 , p5_a8 DATE := fnd_api.g_miss_date
2224 , p5_a9 NUMBER := 0-1962.0724
2225 , p5_a10 DATE := fnd_api.g_miss_date
2226 , p5_a11 NUMBER := 0-1962.0724
2227 )
2228
2229 as
2230 ddp_ovev_rec okl_options_pub.ovev_rec_type;
2231 ddindx binary_integer; indx binary_integer;
2232 begin
2233
2234 -- copy data to the local IN or IN-OUT args, if any
2235
2236
2237
2238
2239
2240 ddp_ovev_rec.id := rosetta_g_miss_num_map(p5_a0);
2241 ddp_ovev_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
2242 ddp_ovev_rec.opt_id := rosetta_g_miss_num_map(p5_a2);
2243 ddp_ovev_rec.value := p5_a3;
2244 ddp_ovev_rec.description := p5_a4;
2245 ddp_ovev_rec.from_date := rosetta_g_miss_date_in_map(p5_a5);
2246 ddp_ovev_rec.to_date := rosetta_g_miss_date_in_map(p5_a6);
2247 ddp_ovev_rec.created_by := rosetta_g_miss_num_map(p5_a7);
2248 ddp_ovev_rec.creation_date := rosetta_g_miss_date_in_map(p5_a8);
2249 ddp_ovev_rec.last_updated_by := rosetta_g_miss_num_map(p5_a9);
2250 ddp_ovev_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a10);
2251 ddp_ovev_rec.last_update_login := rosetta_g_miss_num_map(p5_a11);
2252
2253 -- here's the delegated call to the old PL/SQL routine
2254 okl_options_pub.delete_option_values(p_api_version,
2255 p_init_msg_list,
2256 x_return_status,
2257 x_msg_count,
2258 x_msg_data,
2259 ddp_ovev_rec);
2260
2261 -- copy data back from the local variables to OUT or IN-OUT args, if any
2262
2263
2264
2265
2266
2267 end;
2268
2269 procedure validate_option_values(p_api_version NUMBER
2270 , p_init_msg_list VARCHAR2
2271 , x_return_status out nocopy VARCHAR2
2272 , x_msg_count out nocopy NUMBER
2273 , x_msg_data out nocopy VARCHAR2
2274 , p5_a0 JTF_NUMBER_TABLE
2275 , p5_a1 JTF_NUMBER_TABLE
2276 , p5_a2 JTF_NUMBER_TABLE
2277 , p5_a3 JTF_VARCHAR2_TABLE_200
2278 , p5_a4 JTF_VARCHAR2_TABLE_2000
2279 , p5_a5 JTF_DATE_TABLE
2280 , p5_a6 JTF_DATE_TABLE
2281 , p5_a7 JTF_NUMBER_TABLE
2282 , p5_a8 JTF_DATE_TABLE
2283 , p5_a9 JTF_NUMBER_TABLE
2284 , p5_a10 JTF_DATE_TABLE
2285 , p5_a11 JTF_NUMBER_TABLE
2286 )
2287
2288 as
2289 ddp_ovev_tbl okl_options_pub.ovev_tbl_type;
2290 ddindx binary_integer; indx binary_integer;
2291 begin
2292
2293 -- copy data to the local IN or IN-OUT args, if any
2294
2295
2296
2297
2298
2299 okl_ove_pvt_w.rosetta_table_copy_in_p5(ddp_ovev_tbl, p5_a0
2300 , p5_a1
2301 , p5_a2
2302 , p5_a3
2303 , p5_a4
2304 , p5_a5
2305 , p5_a6
2306 , p5_a7
2307 , p5_a8
2308 , p5_a9
2309 , p5_a10
2310 , p5_a11
2311 );
2312
2313 -- here's the delegated call to the old PL/SQL routine
2314 okl_options_pub.validate_option_values(p_api_version,
2315 p_init_msg_list,
2316 x_return_status,
2317 x_msg_count,
2318 x_msg_data,
2319 ddp_ovev_tbl);
2320
2321 -- copy data back from the local variables to OUT or IN-OUT args, if any
2322
2323
2324
2325
2326
2327 end;
2328
2329 procedure validate_option_values(p_api_version NUMBER
2330 , p_init_msg_list VARCHAR2
2331 , x_return_status out nocopy VARCHAR2
2332 , x_msg_count out nocopy NUMBER
2333 , x_msg_data out nocopy VARCHAR2
2334 , p5_a0 NUMBER := 0-1962.0724
2335 , p5_a1 NUMBER := 0-1962.0724
2336 , p5_a2 NUMBER := 0-1962.0724
2337 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2338 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2339 , p5_a5 DATE := fnd_api.g_miss_date
2340 , p5_a6 DATE := fnd_api.g_miss_date
2341 , p5_a7 NUMBER := 0-1962.0724
2342 , p5_a8 DATE := fnd_api.g_miss_date
2343 , p5_a9 NUMBER := 0-1962.0724
2344 , p5_a10 DATE := fnd_api.g_miss_date
2345 , p5_a11 NUMBER := 0-1962.0724
2346 )
2347
2348 as
2349 ddp_ovev_rec okl_options_pub.ovev_rec_type;
2350 ddindx binary_integer; indx binary_integer;
2351 begin
2352
2353 -- copy data to the local IN or IN-OUT args, if any
2354
2355
2356
2357
2358
2359 ddp_ovev_rec.id := rosetta_g_miss_num_map(p5_a0);
2360 ddp_ovev_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
2361 ddp_ovev_rec.opt_id := rosetta_g_miss_num_map(p5_a2);
2362 ddp_ovev_rec.value := p5_a3;
2363 ddp_ovev_rec.description := p5_a4;
2364 ddp_ovev_rec.from_date := rosetta_g_miss_date_in_map(p5_a5);
2365 ddp_ovev_rec.to_date := rosetta_g_miss_date_in_map(p5_a6);
2366 ddp_ovev_rec.created_by := rosetta_g_miss_num_map(p5_a7);
2367 ddp_ovev_rec.creation_date := rosetta_g_miss_date_in_map(p5_a8);
2368 ddp_ovev_rec.last_updated_by := rosetta_g_miss_num_map(p5_a9);
2369 ddp_ovev_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a10);
2370 ddp_ovev_rec.last_update_login := rosetta_g_miss_num_map(p5_a11);
2371
2372 -- here's the delegated call to the old PL/SQL routine
2373 okl_options_pub.validate_option_values(p_api_version,
2374 p_init_msg_list,
2375 x_return_status,
2376 x_msg_count,
2377 x_msg_data,
2378 ddp_ovev_rec);
2379
2380 -- copy data back from the local variables to OUT or IN-OUT args, if any
2381
2382
2383
2384
2385
2386 end;
2387
2388 end okl_options_pub_w;