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_PVT_W

Source


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