eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.OKL_SETUPOPTIONS_PUB_W

Source


1 package body okl_setupoptions_pub_w as
2   /* $Header: OKLUSOTB.pls 115.2 2002/12/24 04:19:38 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 
9     if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
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
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 get_rec(x_return_status out nocopy  VARCHAR2
23     , x_msg_data out nocopy  VARCHAR2
24     , x_no_data_found out nocopy  number
25     , p4_a0 out nocopy  NUMBER
26     , p4_a1 out nocopy  NUMBER
27     , p4_a2 out nocopy  VARCHAR2
28     , p4_a3 out nocopy  VARCHAR2
29     , p4_a4 out nocopy  DATE
30     , p4_a5 out nocopy  DATE
31     , p4_a6 out nocopy  VARCHAR2
32     , p4_a7 out nocopy  VARCHAR2
33     , p4_a8 out nocopy  VARCHAR2
34     , p4_a9 out nocopy  VARCHAR2
35     , p4_a10 out nocopy  VARCHAR2
36     , p4_a11 out nocopy  VARCHAR2
37     , p4_a12 out nocopy  VARCHAR2
38     , p4_a13 out nocopy  VARCHAR2
39     , p4_a14 out nocopy  VARCHAR2
40     , p4_a15 out nocopy  VARCHAR2
41     , p4_a16 out nocopy  VARCHAR2
42     , p4_a17 out nocopy  VARCHAR2
43     , p4_a18 out nocopy  VARCHAR2
44     , p4_a19 out nocopy  VARCHAR2
45     , p4_a20 out nocopy  VARCHAR2
46     , p4_a21 out nocopy  VARCHAR2
47     , p4_a22 out nocopy  NUMBER
48     , p4_a23 out nocopy  DATE
49     , p4_a24 out nocopy  NUMBER
50     , p4_a25 out nocopy  DATE
51     , p4_a26 out nocopy  NUMBER
52     , p0_a0  NUMBER := 0-1962.0724
53     , p0_a1  NUMBER := 0-1962.0724
54     , p0_a2  VARCHAR2 := fnd_api.g_miss_char
55     , p0_a3  VARCHAR2 := fnd_api.g_miss_char
56     , p0_a4  DATE := fnd_api.g_miss_date
57     , p0_a5  DATE := fnd_api.g_miss_date
58     , p0_a6  VARCHAR2 := fnd_api.g_miss_char
59     , p0_a7  VARCHAR2 := fnd_api.g_miss_char
60     , p0_a8  VARCHAR2 := fnd_api.g_miss_char
61     , p0_a9  VARCHAR2 := fnd_api.g_miss_char
62     , p0_a10  VARCHAR2 := fnd_api.g_miss_char
63     , p0_a11  VARCHAR2 := fnd_api.g_miss_char
64     , p0_a12  VARCHAR2 := fnd_api.g_miss_char
65     , p0_a13  VARCHAR2 := fnd_api.g_miss_char
66     , p0_a14  VARCHAR2 := fnd_api.g_miss_char
67     , p0_a15  VARCHAR2 := fnd_api.g_miss_char
68     , p0_a16  VARCHAR2 := fnd_api.g_miss_char
69     , p0_a17  VARCHAR2 := fnd_api.g_miss_char
70     , p0_a18  VARCHAR2 := fnd_api.g_miss_char
71     , p0_a19  VARCHAR2 := fnd_api.g_miss_char
72     , p0_a20  VARCHAR2 := fnd_api.g_miss_char
73     , p0_a21  VARCHAR2 := fnd_api.g_miss_char
74     , p0_a22  NUMBER := 0-1962.0724
75     , p0_a23  DATE := fnd_api.g_miss_date
76     , p0_a24  NUMBER := 0-1962.0724
77     , p0_a25  DATE := fnd_api.g_miss_date
78     , p0_a26  NUMBER := 0-1962.0724
79   )
80 
81   as
82     ddp_optv_rec okl_setupoptions_pub.optv_rec_type;
83     ddx_no_data_found boolean;
84     ddx_optv_rec okl_setupoptions_pub.optv_rec_type;
85     ddindx binary_integer; indx binary_integer;
86   begin
87 
88     -- copy data to the local IN or IN-OUT args, if any
89     ddp_optv_rec.id := rosetta_g_miss_num_map(p0_a0);
90     ddp_optv_rec.object_version_number := rosetta_g_miss_num_map(p0_a1);
91     ddp_optv_rec.name := p0_a2;
92     ddp_optv_rec.description := p0_a3;
93     ddp_optv_rec.from_date := rosetta_g_miss_date_in_map(p0_a4);
94     ddp_optv_rec.to_date := rosetta_g_miss_date_in_map(p0_a5);
95     ddp_optv_rec.attribute_category := p0_a6;
96     ddp_optv_rec.attribute1 := p0_a7;
97     ddp_optv_rec.attribute2 := p0_a8;
98     ddp_optv_rec.attribute3 := p0_a9;
99     ddp_optv_rec.attribute4 := p0_a10;
100     ddp_optv_rec.attribute5 := p0_a11;
101     ddp_optv_rec.attribute6 := p0_a12;
102     ddp_optv_rec.attribute7 := p0_a13;
103     ddp_optv_rec.attribute8 := p0_a14;
104     ddp_optv_rec.attribute9 := p0_a15;
105     ddp_optv_rec.attribute10 := p0_a16;
106     ddp_optv_rec.attribute11 := p0_a17;
107     ddp_optv_rec.attribute12 := p0_a18;
108     ddp_optv_rec.attribute13 := p0_a19;
109     ddp_optv_rec.attribute14 := p0_a20;
110     ddp_optv_rec.attribute15 := p0_a21;
111     ddp_optv_rec.created_by := rosetta_g_miss_num_map(p0_a22);
112     ddp_optv_rec.creation_date := rosetta_g_miss_date_in_map(p0_a23);
113     ddp_optv_rec.last_updated_by := rosetta_g_miss_num_map(p0_a24);
114     ddp_optv_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a25);
115     ddp_optv_rec.last_update_login := rosetta_g_miss_num_map(p0_a26);
116 
117 
118 
119 
120 
121     -- here's the delegated call to the old PL/SQL routine
122     okl_setupoptions_pub.get_rec(ddp_optv_rec,
123       x_return_status,
124       x_msg_data,
125       ddx_no_data_found,
126       ddx_optv_rec);
127 
128     -- copy data back from the local variables to OUT or IN-OUT args, if any
129 
130 
131 
132   if ddx_no_data_found is null
133     then x_no_data_found := null;
134   elsif ddx_no_data_found
135     then x_no_data_found := 1;
136   else x_no_data_found := 0;
137   end if;
138 
139     p4_a0 := rosetta_g_miss_num_map(ddx_optv_rec.id);
140     p4_a1 := rosetta_g_miss_num_map(ddx_optv_rec.object_version_number);
141     p4_a2 := ddx_optv_rec.name;
142     p4_a3 := ddx_optv_rec.description;
143     p4_a4 := ddx_optv_rec.from_date;
144     p4_a5 := ddx_optv_rec.to_date;
145     p4_a6 := ddx_optv_rec.attribute_category;
146     p4_a7 := ddx_optv_rec.attribute1;
147     p4_a8 := ddx_optv_rec.attribute2;
148     p4_a9 := ddx_optv_rec.attribute3;
149     p4_a10 := ddx_optv_rec.attribute4;
150     p4_a11 := ddx_optv_rec.attribute5;
151     p4_a12 := ddx_optv_rec.attribute6;
152     p4_a13 := ddx_optv_rec.attribute7;
153     p4_a14 := ddx_optv_rec.attribute8;
154     p4_a15 := ddx_optv_rec.attribute9;
155     p4_a16 := ddx_optv_rec.attribute10;
156     p4_a17 := ddx_optv_rec.attribute11;
157     p4_a18 := ddx_optv_rec.attribute12;
158     p4_a19 := ddx_optv_rec.attribute13;
159     p4_a20 := ddx_optv_rec.attribute14;
160     p4_a21 := ddx_optv_rec.attribute15;
161     p4_a22 := rosetta_g_miss_num_map(ddx_optv_rec.created_by);
162     p4_a23 := ddx_optv_rec.creation_date;
163     p4_a24 := rosetta_g_miss_num_map(ddx_optv_rec.last_updated_by);
164     p4_a25 := ddx_optv_rec.last_update_date;
165     p4_a26 := rosetta_g_miss_num_map(ddx_optv_rec.last_update_login);
166   end;
167 
168   procedure insert_options(p_api_version  NUMBER
169     , p_init_msg_list  VARCHAR2
170     , x_return_status out nocopy  VARCHAR2
171     , x_msg_count out nocopy  NUMBER
172     , x_msg_data out nocopy  VARCHAR2
173     , p6_a0 out nocopy  NUMBER
174     , p6_a1 out nocopy  NUMBER
175     , p6_a2 out nocopy  VARCHAR2
176     , p6_a3 out nocopy  VARCHAR2
177     , p6_a4 out nocopy  DATE
178     , p6_a5 out nocopy  DATE
179     , p6_a6 out nocopy  VARCHAR2
180     , p6_a7 out nocopy  VARCHAR2
181     , p6_a8 out nocopy  VARCHAR2
182     , p6_a9 out nocopy  VARCHAR2
183     , p6_a10 out nocopy  VARCHAR2
184     , p6_a11 out nocopy  VARCHAR2
185     , p6_a12 out nocopy  VARCHAR2
186     , p6_a13 out nocopy  VARCHAR2
187     , p6_a14 out nocopy  VARCHAR2
188     , p6_a15 out nocopy  VARCHAR2
189     , p6_a16 out nocopy  VARCHAR2
190     , p6_a17 out nocopy  VARCHAR2
191     , p6_a18 out nocopy  VARCHAR2
192     , p6_a19 out nocopy  VARCHAR2
193     , p6_a20 out nocopy  VARCHAR2
194     , p6_a21 out nocopy  VARCHAR2
195     , p6_a22 out nocopy  NUMBER
196     , p6_a23 out nocopy  DATE
197     , p6_a24 out nocopy  NUMBER
198     , p6_a25 out nocopy  DATE
199     , p6_a26 out nocopy  NUMBER
200     , p5_a0  NUMBER := 0-1962.0724
201     , p5_a1  NUMBER := 0-1962.0724
202     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
203     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
204     , p5_a4  DATE := fnd_api.g_miss_date
205     , p5_a5  DATE := fnd_api.g_miss_date
206     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
207     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
208     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
209     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
210     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
211     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
212     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
213     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
214     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
215     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
216     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
217     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
218     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
219     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
220     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
221     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
222     , p5_a22  NUMBER := 0-1962.0724
223     , p5_a23  DATE := fnd_api.g_miss_date
224     , p5_a24  NUMBER := 0-1962.0724
225     , p5_a25  DATE := fnd_api.g_miss_date
226     , p5_a26  NUMBER := 0-1962.0724
227   )
228 
229   as
230     ddp_optv_rec okl_setupoptions_pub.optv_rec_type;
231     ddx_optv_rec okl_setupoptions_pub.optv_rec_type;
232     ddindx binary_integer; indx binary_integer;
233   begin
234 
235     -- copy data to the local IN or IN-OUT args, if any
236 
237 
238 
239 
240 
241     ddp_optv_rec.id := rosetta_g_miss_num_map(p5_a0);
242     ddp_optv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
243     ddp_optv_rec.name := p5_a2;
244     ddp_optv_rec.description := p5_a3;
248     ddp_optv_rec.attribute1 := p5_a7;
245     ddp_optv_rec.from_date := rosetta_g_miss_date_in_map(p5_a4);
246     ddp_optv_rec.to_date := rosetta_g_miss_date_in_map(p5_a5);
247     ddp_optv_rec.attribute_category := p5_a6;
249     ddp_optv_rec.attribute2 := p5_a8;
250     ddp_optv_rec.attribute3 := p5_a9;
251     ddp_optv_rec.attribute4 := p5_a10;
252     ddp_optv_rec.attribute5 := p5_a11;
253     ddp_optv_rec.attribute6 := p5_a12;
254     ddp_optv_rec.attribute7 := p5_a13;
255     ddp_optv_rec.attribute8 := p5_a14;
256     ddp_optv_rec.attribute9 := p5_a15;
257     ddp_optv_rec.attribute10 := p5_a16;
258     ddp_optv_rec.attribute11 := p5_a17;
259     ddp_optv_rec.attribute12 := p5_a18;
260     ddp_optv_rec.attribute13 := p5_a19;
261     ddp_optv_rec.attribute14 := p5_a20;
262     ddp_optv_rec.attribute15 := p5_a21;
263     ddp_optv_rec.created_by := rosetta_g_miss_num_map(p5_a22);
264     ddp_optv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a23);
265     ddp_optv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a24);
266     ddp_optv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a25);
267     ddp_optv_rec.last_update_login := rosetta_g_miss_num_map(p5_a26);
268 
269 
270     -- here's the delegated call to the old PL/SQL routine
271     okl_setupoptions_pub.insert_options(p_api_version,
272       p_init_msg_list,
273       x_return_status,
274       x_msg_count,
275       x_msg_data,
276       ddp_optv_rec,
277       ddx_optv_rec);
278 
279     -- copy data back from the local variables to OUT or IN-OUT args, if any
280 
281 
282 
283 
284 
285 
286     p6_a0 := rosetta_g_miss_num_map(ddx_optv_rec.id);
287     p6_a1 := rosetta_g_miss_num_map(ddx_optv_rec.object_version_number);
288     p6_a2 := ddx_optv_rec.name;
289     p6_a3 := ddx_optv_rec.description;
290     p6_a4 := ddx_optv_rec.from_date;
291     p6_a5 := ddx_optv_rec.to_date;
292     p6_a6 := ddx_optv_rec.attribute_category;
293     p6_a7 := ddx_optv_rec.attribute1;
294     p6_a8 := ddx_optv_rec.attribute2;
295     p6_a9 := ddx_optv_rec.attribute3;
296     p6_a10 := ddx_optv_rec.attribute4;
297     p6_a11 := ddx_optv_rec.attribute5;
298     p6_a12 := ddx_optv_rec.attribute6;
299     p6_a13 := ddx_optv_rec.attribute7;
300     p6_a14 := ddx_optv_rec.attribute8;
301     p6_a15 := ddx_optv_rec.attribute9;
302     p6_a16 := ddx_optv_rec.attribute10;
303     p6_a17 := ddx_optv_rec.attribute11;
304     p6_a18 := ddx_optv_rec.attribute12;
305     p6_a19 := ddx_optv_rec.attribute13;
306     p6_a20 := ddx_optv_rec.attribute14;
307     p6_a21 := ddx_optv_rec.attribute15;
308     p6_a22 := rosetta_g_miss_num_map(ddx_optv_rec.created_by);
309     p6_a23 := ddx_optv_rec.creation_date;
310     p6_a24 := rosetta_g_miss_num_map(ddx_optv_rec.last_updated_by);
311     p6_a25 := ddx_optv_rec.last_update_date;
312     p6_a26 := rosetta_g_miss_num_map(ddx_optv_rec.last_update_login);
313   end;
314 
315   procedure update_options(p_api_version  NUMBER
316     , p_init_msg_list  VARCHAR2
317     , x_return_status out nocopy  VARCHAR2
318     , x_msg_count out nocopy  NUMBER
319     , x_msg_data out nocopy  VARCHAR2
320     , p6_a0 out nocopy  NUMBER
321     , p6_a1 out nocopy  NUMBER
322     , p6_a2 out nocopy  VARCHAR2
323     , p6_a3 out nocopy  VARCHAR2
324     , p6_a4 out nocopy  DATE
325     , p6_a5 out nocopy  DATE
326     , p6_a6 out nocopy  VARCHAR2
327     , p6_a7 out nocopy  VARCHAR2
328     , p6_a8 out nocopy  VARCHAR2
329     , p6_a9 out nocopy  VARCHAR2
330     , p6_a10 out nocopy  VARCHAR2
331     , p6_a11 out nocopy  VARCHAR2
332     , p6_a12 out nocopy  VARCHAR2
333     , p6_a13 out nocopy  VARCHAR2
334     , p6_a14 out nocopy  VARCHAR2
335     , p6_a15 out nocopy  VARCHAR2
336     , p6_a16 out nocopy  VARCHAR2
337     , p6_a17 out nocopy  VARCHAR2
338     , p6_a18 out nocopy  VARCHAR2
339     , p6_a19 out nocopy  VARCHAR2
340     , p6_a20 out nocopy  VARCHAR2
341     , p6_a21 out nocopy  VARCHAR2
342     , p6_a22 out nocopy  NUMBER
343     , p6_a23 out nocopy  DATE
344     , p6_a24 out nocopy  NUMBER
345     , p6_a25 out nocopy  DATE
346     , p6_a26 out nocopy  NUMBER
347     , p5_a0  NUMBER := 0-1962.0724
348     , p5_a1  NUMBER := 0-1962.0724
349     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
350     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
351     , p5_a4  DATE := fnd_api.g_miss_date
352     , p5_a5  DATE := fnd_api.g_miss_date
353     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
354     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
355     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
356     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
357     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
358     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
359     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
360     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
361     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
362     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
363     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
364     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
365     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
366     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
367     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
368     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
369     , p5_a22  NUMBER := 0-1962.0724
370     , p5_a23  DATE := fnd_api.g_miss_date
371     , p5_a24  NUMBER := 0-1962.0724
372     , p5_a25  DATE := fnd_api.g_miss_date
373     , p5_a26  NUMBER := 0-1962.0724
374   )
375 
376   as
377     ddp_optv_rec okl_setupoptions_pub.optv_rec_type;
378     ddx_optv_rec okl_setupoptions_pub.optv_rec_type;
379     ddindx binary_integer; indx binary_integer;
380   begin
381 
382     -- copy data to the local IN or IN-OUT args, if any
383 
384 
385 
386 
387 
388     ddp_optv_rec.id := rosetta_g_miss_num_map(p5_a0);
389     ddp_optv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
390     ddp_optv_rec.name := p5_a2;
391     ddp_optv_rec.description := p5_a3;
392     ddp_optv_rec.from_date := rosetta_g_miss_date_in_map(p5_a4);
393     ddp_optv_rec.to_date := rosetta_g_miss_date_in_map(p5_a5);
394     ddp_optv_rec.attribute_category := p5_a6;
395     ddp_optv_rec.attribute1 := p5_a7;
396     ddp_optv_rec.attribute2 := p5_a8;
397     ddp_optv_rec.attribute3 := p5_a9;
398     ddp_optv_rec.attribute4 := p5_a10;
399     ddp_optv_rec.attribute5 := p5_a11;
400     ddp_optv_rec.attribute6 := p5_a12;
401     ddp_optv_rec.attribute7 := p5_a13;
402     ddp_optv_rec.attribute8 := p5_a14;
403     ddp_optv_rec.attribute9 := p5_a15;
404     ddp_optv_rec.attribute10 := p5_a16;
405     ddp_optv_rec.attribute11 := p5_a17;
406     ddp_optv_rec.attribute12 := p5_a18;
407     ddp_optv_rec.attribute13 := p5_a19;
408     ddp_optv_rec.attribute14 := p5_a20;
409     ddp_optv_rec.attribute15 := p5_a21;
410     ddp_optv_rec.created_by := rosetta_g_miss_num_map(p5_a22);
411     ddp_optv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a23);
412     ddp_optv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a24);
413     ddp_optv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a25);
414     ddp_optv_rec.last_update_login := rosetta_g_miss_num_map(p5_a26);
415 
416 
417     -- here's the delegated call to the old PL/SQL routine
418     okl_setupoptions_pub.update_options(p_api_version,
419       p_init_msg_list,
420       x_return_status,
421       x_msg_count,
422       x_msg_data,
423       ddp_optv_rec,
424       ddx_optv_rec);
425 
426     -- copy data back from the local variables to OUT or IN-OUT args, if any
427 
428 
429 
430 
431 
432 
433     p6_a0 := rosetta_g_miss_num_map(ddx_optv_rec.id);
434     p6_a1 := rosetta_g_miss_num_map(ddx_optv_rec.object_version_number);
435     p6_a2 := ddx_optv_rec.name;
436     p6_a3 := ddx_optv_rec.description;
437     p6_a4 := ddx_optv_rec.from_date;
438     p6_a5 := ddx_optv_rec.to_date;
439     p6_a6 := ddx_optv_rec.attribute_category;
440     p6_a7 := ddx_optv_rec.attribute1;
441     p6_a8 := ddx_optv_rec.attribute2;
442     p6_a9 := ddx_optv_rec.attribute3;
443     p6_a10 := ddx_optv_rec.attribute4;
444     p6_a11 := ddx_optv_rec.attribute5;
445     p6_a12 := ddx_optv_rec.attribute6;
446     p6_a13 := ddx_optv_rec.attribute7;
447     p6_a14 := ddx_optv_rec.attribute8;
448     p6_a15 := ddx_optv_rec.attribute9;
449     p6_a16 := ddx_optv_rec.attribute10;
450     p6_a17 := ddx_optv_rec.attribute11;
451     p6_a18 := ddx_optv_rec.attribute12;
452     p6_a19 := ddx_optv_rec.attribute13;
453     p6_a20 := ddx_optv_rec.attribute14;
454     p6_a21 := ddx_optv_rec.attribute15;
455     p6_a22 := rosetta_g_miss_num_map(ddx_optv_rec.created_by);
456     p6_a23 := ddx_optv_rec.creation_date;
457     p6_a24 := rosetta_g_miss_num_map(ddx_optv_rec.last_updated_by);
458     p6_a25 := ddx_optv_rec.last_update_date;
459     p6_a26 := rosetta_g_miss_num_map(ddx_optv_rec.last_update_login);
460   end;
461 
462 end okl_setupoptions_pub_w;