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